Query Metrics
9
Database Queries
8
Different statements
30.63 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 7.98 ms |
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, t12.id AS id_13, t12.quantity AS quantity_14, t12.created_at AS created_at_15, t12.updated_at AS updated_at_16, t12.cart_id AS cart_id_17, t12.product_id AS product_id_18, t12.created_by_id AS created_by_id_19, t12.updated_by_id AS updated_by_id_20, t0.shipping_product_id AS shipping_product_id_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23 FROM cart t0 LEFT JOIN cart_item t12 ON t12.cart_id = t0.id WHERE t0.id = ?
Parameters:
[
"291437"
]
|
| 2 | 6.61 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.description AS description_4, t0.presentation AS presentation_5, t0.is_wholesaler AS is_wholesaler_6, t0.publicSale AS publicSale_7, t0.active AS active_8, t0.isDeleted AS isDeleted_9, t0.recommended AS recommended_10, t0.tax AS tax_11, t0.base_price AS base_price_12, t0.price AS price_13, t0.thumbnail AS thumbnail_14, t0.image AS image_15, t0.idCategory AS idCategory_16, t0.idSize AS idSize_17, t0.unit_of_measurement_id AS unit_of_measurement_id_18 FROM product t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
372
]
|
| 3 | 0.40 ms |
"START TRANSACTION"
Parameters:
[] |
| 4 | 5.40 ms |
INSERT INTO cart_item (quantity, created_at, updated_at, cart_id, product_id, created_by_id, updated_by_id) VALUES (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => 4 2 => "2025-12-21 00:50:11" 3 => "2025-12-21 00:50:11" 4 => 291437 5 => 372 6 => null 7 => null ] |
| 5 | 0.56 ms |
UPDATE product SET tax = ?, base_price = ?, price = ? WHERE id = ?
Parameters:
[ 21.0 6157.0247933884 7450.0 372 ] |
| 6 | 1.28 ms |
"COMMIT"
Parameters:
[] |
| 7 | 5.34 ms |
SELECT s0_.current_stock AS current_stock_0, s0_.minimum_stock_level AS minimum_stock_level_1, s0_.stop_selling_stock_level AS stop_selling_stock_level_2, s0_.perishable AS perishable_3, s0_.product_id AS product_id_4 FROM stock_item s0_ INNER JOIN product p1_ ON s0_.product_id = p1_.id WHERE s0_.product_id = ? ORDER BY p1_.name ASC
Parameters:
[
372
]
|
| 8 | 2.55 ms |
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:
[] |
| 9 | 0.53 ms |
SELECT s0_.current_stock AS current_stock_0, s0_.minimum_stock_level AS minimum_stock_level_1, s0_.stop_selling_stock_level AS stop_selling_stock_level_2, s0_.perishable AS perishable_3, s0_.product_id AS product_id_4 FROM stock_item s0_ INNER JOIN product p1_ ON s0_.product_id = p1_.id WHERE s0_.product_id = ? ORDER BY p1_.name ASC
Parameters:
[
372
]
|
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. |
| App\Customer\Entity\IvaCondition | No errors. |