Query Metrics
3
Database Queries
3
Different statements
1.95 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.73 ms (37.16%) |
1 |
SELECT t0.id AS id_1, t0.order_type AS order_type_2, t0.delivery_date AS delivery_date_3, t0.delivery_start_time AS delivery_start_time_4, t0.delivery_end_time AS delivery_end_time_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.customer_id AS customer_id_8, t0.shipping_address_id AS shipping_address_id_9, t0.billing_address_id AS billing_address_id_10, t0.delivery_schedule_id AS delivery_schedule_id_11, t0.shipping_product_id AS shipping_product_id_12, t0.created_by_id AS created_by_id_13, t0.updated_by_id AS updated_by_id_14 FROM cart t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
291438
]
|
|
0.70 ms (35.73%) |
1 |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.cart_id AS cart_id_5, t0.product_id AS product_id_6, t7.id AS id_8, t7.type AS type_9, t7.name AS name_10, t7.description AS description_11, t7.presentation AS presentation_12, t7.is_wholesaler AS is_wholesaler_13, t7.publicSale AS publicSale_14, t7.active AS active_15, t7.isDeleted AS isDeleted_16, t7.recommended AS recommended_17, t7.tax AS tax_18, t7.base_price AS base_price_19, t7.price AS price_20, t7.thumbnail AS thumbnail_21, t7.image AS image_22, t7.idCategory AS idCategory_23, t7.idSize AS idSize_24, t7.unit_of_measurement_id AS unit_of_measurement_id_25, t0.created_by_id AS created_by_id_26, t0.updated_by_id AS updated_by_id_27 FROM cart_item t0 LEFT JOIN product t7 ON t0.product_id = t7.id WHERE t0.cart_id = ?
Parameters:
[
291438
]
|
|
0.53 ms (27.11%) |
1 |
SELECT t0.pkey AS pkey_1, t0.pvalue AS pvalue_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.created_by_id AS created_by_id_5, t0.updated_by_id AS updated_by_id_6 FROM parameter t0
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Order\Entity\Cart |
|
| App\Core\Entity\Parameter | No errors. |
| App\Delivery\Entity\DeliveryZone | No errors. |
| App\Delivery\Entity\DeliverySchedule | No errors. |
| App\Stock\Entity\StockItem | No errors. |
| App\Stock\Entity\StockMovement | No errors. |
| App\Product\Entity\Product | No errors. |
| App\Customer\Entity\Customer | No errors. |
| App\Authentication\Entity\User | No errors. |
| App\Customer\Entity\StreetAddress | No errors. |
| App\Customer\Entity\BillingAddress | No errors. |
| App\Order\Entity\CartItem | No errors. |
| App\Product\Entity\ProductCategory | No errors. |
| App\Product\Entity\ProductSize | No errors. |
| App\Product\Entity\UnitOfMeasurement | No errors. |