Query Metrics
16
Database Queries
11
Different statements
28.21 ms
Query time
0
Invalid entities
6
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
14.61 ms (51.80%) |
3 |
"COMMIT"
Parameters:
[] |
|
3.47 ms (12.29%) |
1 |
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:
[ "38jvg5kh0uqtdrs7ctct7qj3le" "open" ] |
|
2.35 ms (8.31%) |
3 |
"START TRANSACTION"
Parameters:
[] |
|
2.03 ms (7.19%) |
2 |
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:
[ 1509 3533 ] |
|
1.22 ms (4.33%) |
1 |
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"
]
|
|
0.93 ms (3.30%) |
1 |
INSERT INTO cart_item (quantity, price, configuration, cart_id, product_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 199.9 null 1509 3533 ] |
|
0.81 ms (2.87%) |
1 |
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:
[ 3533 199.9 ] |
|
0.77 ms (2.72%) |
1 |
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:
[ "38jvg5kh0uqtdrs7ctct7qj3le" null 0.0 "open" null "2026-08-26 04:07:03" "2026-08-26 04:07:03" null null null null null null null null null null null "shipping" null null null null null null ] |
|
0.75 ms (2.66%) |
1 |
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:
[
"3533"
]
|
|
0.75 ms (2.64%) |
1 |
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:
[
1509
]
|
|
0.53 ms (1.89%) |
1 |
UPDATE cart SET total = ?, updated_at = ? WHERE id = ?
Parameters:
[ 199.9 "2026-08-26 04:07:03" 1509 ] |
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. |