Query Metrics
16
Database Queries
11
Different statements
68.24 ms
Query time
0
Invalid entities
6
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.47 ms |
SELECT s0_.id AS id_0, s0_.settings_key AS settings_key_1, s0_.value AS value_2, s0_.type AS type_3, s0_.description AS description_4, s0_.scope AS scope_5 FROM system_setting s0_ WHERE s0_.settings_key = ?
Parameters:
[
"shop_status"
]
|
| 2 | 2.06 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.label AS label_4, t0.available AS available_5, t0.slug AS slug_6, t0.description AS description_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.sku AS sku_10, t0.short_description AS short_description_11, t0.stock AS stock_12, t0.delivery_time AS delivery_time_13, t0.weight AS weight_14, t0.length AS length_15, t0.width AS width_16, t0.height AS height_17, t0.manufacturer AS manufacturer_18, t0.ean AS ean_19, t0.is_active AS is_active_20, t0.special_price AS special_price_21, t0.uvp AS uvp_22, t0.tags AS tags_23, t0.video_url AS video_url_24, t0.material AS material_25, t0.country_of_origin AS country_of_origin_26, t0.custom1 AS custom1_27, t0.custom2 AS custom2_28, t0.mwst AS mwst_29, t0.versandkosten AS versandkosten_30, t0.pickup_available AS pickup_available_31, t0.pickup_only AS pickup_only_32, t0.pickup_note AS pickup_note_33, t0.category_id AS category_id_34, t0.seo_meta_id AS seo_meta_id_35, t0.shipping_method_id AS shipping_method_id_36 FROM product t0 WHERE t0.id = ?
Parameters:
[
"3571"
]
|
| 3 | 6.94 ms |
SELECT t0.id AS id_1, t0.session_id AS session_id_2, t0.user_id AS user_id_3, t0.total AS total_4, t0.status AS status_5, t0.admin_comment AS admin_comment_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.payment AS payment_9, t0.stripe_payment_intent_id AS stripe_payment_intent_id_10, t0.stripe_status AS stripe_status_11, t0.shipping_cost AS shipping_cost_12, t0.discount AS discount_13, t0.order_status AS order_status_14, t0.shipping_address_snapshot AS shipping_address_snapshot_15, t0.billing_address_snapshot AS billing_address_snapshot_16, t0.invoice_number AS invoice_number_17, t0.invoice_issued_at AS invoice_issued_at_18, t0.invoice_snapshot AS invoice_snapshot_19, t0.fulfillment_type AS fulfillment_type_20, t0.pickup_status AS pickup_status_21, t0.pickup_ready_at AS pickup_ready_at_22, t0.pickup_notified_at AS pickup_notified_at_23, t0.customer_id AS customer_id_24, t0.shipping_method_id AS shipping_method_id_25, t0.coupon_id AS coupon_id_26 FROM cart t0 WHERE t0.session_id = ? AND t0.status = ? LIMIT 1
Parameters:
[ "l6rl0b8evsuep9vu7j36seijq2" "open" ] |
| 4 | 5.57 ms |
"START TRANSACTION"
Parameters:
[] |
| 5 | 2.73 ms |
INSERT INTO cart (session_id, user_id, total, status, admin_comment, created_at, updated_at, payment, stripe_payment_intent_id, stripe_status, shipping_cost, discount, order_status, shipping_address_snapshot, billing_address_snapshot, invoice_number, invoice_issued_at, invoice_snapshot, fulfillment_type, pickup_status, pickup_ready_at, pickup_notified_at, customer_id, shipping_method_id, coupon_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "l6rl0b8evsuep9vu7j36seijq2" null 0.0 "open" null "2026-08-26 06:17:45" "2026-08-26 06:17:45" null null null null null null null null null null null "shipping" null null null null null null ] |
| 6 | 15.99 ms |
"COMMIT"
Parameters:
[] |
| 7 | 3.17 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.configuration AS configuration_4, t0.cart_id AS cart_id_5, t0.product_id AS product_id_6 FROM cart_item t0 WHERE t0.cart_id = ? AND t0.product_id = ?
Parameters:
[ 1995 3571 ] |
| 8 | 0.77 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.configuration AS configuration_4, t0.cart_id AS cart_id_5, t0.product_id AS product_id_6 FROM cart_item t0 WHERE t0.cart_id = ? AND t0.product_id = ?
Parameters:
[ 1995 3571 ] |
| 9 | 1.26 ms |
"START TRANSACTION"
Parameters:
[] |
| 10 | 2.31 ms |
INSERT INTO cart_item (quantity, price, configuration, cart_id, product_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 99.9 null 1995 3571 ] |
| 11 | 3.32 ms |
"COMMIT"
Parameters:
[] |
| 12 | 2.77 ms |
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.configuration AS configuration_4, t0.cart_id AS cart_id_5, t0.product_id AS product_id_6 FROM cart_item t0 WHERE t0.cart_id = ?
Parameters:
[
1995
]
|
| 13 | 3.16 ms |
SELECT c0_.id AS id_0, c0_.type AS type_1, c0_.priority AS priority_2, c0_.min_cart_value AS min_cart_value_3, c0_.discount_percent AS discount_percent_4, c0_.is_active AS is_active_5, c0_.created_at AS created_at_6, c0_.valid_until AS valid_until_7, c0_.source_product_id AS source_product_id_8, c0_.target_product_id AS target_product_id_9 FROM cross_sell_rule c0_ WHERE c0_.source_product_id = ? AND c0_.is_active = 1 AND c0_.min_cart_value <= ? AND (c0_.valid_until IS NULL OR c0_.valid_until >= CURRENT_TIMESTAMP) ORDER BY c0_.priority DESC, c0_.created_at DESC
Parameters:
[ 3571 99.9 ] |
| 14 | 1.64 ms |
"START TRANSACTION"
Parameters:
[] |
| 15 | 3.32 ms |
UPDATE cart SET total = ?, updated_at = ? WHERE id = ?
Parameters:
[ 99.9 "2026-08-26 06:17:45" 1995 ] |
| 16 | 11.75 ms |
"COMMIT"
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\SystemSetting | 1 |
| App\Entity\Product | 1 |
| App\Entity\Category | 1 |
| App\Entity\SeoMeta | 1 |
| App\Entity\Cart | 1 |
| App\Entity\CartItem | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\SystemSetting | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\SeoMeta | No errors. |
| App\Entity\ShippingMethod | No errors. |
| App\Entity\ProductImage | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\Coupon | No errors. |
| App\Entity\CartItem | No errors. |
| App\Entity\CrossSellRule | No errors. |