Query Metrics
15
Database Queries
10
Different statements
40.84 ms
Query time
0
Invalid entities
10
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.70 ms (18.85%) |
2 |
"COMMIT"
Parameters:
[] |
|
6.10 ms (14.94%) |
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"
]
|
|
5.63 ms (13.78%) |
2 |
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:
[ 3612 29.8 ] |
|
5.49 ms (13.45%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
4.93 ms (12.06%) |
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.id = ?
Parameters:
[
2065
]
|
|
4.24 ms (10.38%) |
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:
[ 2065 3610 ] |
|
2.25 ms (5.51%) |
2 |
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:
[
"3610"
]
|
|
2.04 ms (4.99%) |
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:
[
2065
]
|
|
1.52 ms (3.73%) |
1 |
INSERT INTO cart_item (quantity, price, configuration, cart_id, product_id) VALUES (?, ?, ?, ?, ?)
Parameters:
[ 1 14.9 null 2065 3610 ] |
|
0.94 ms (2.30%) |
1 |
UPDATE cart SET total = ?, updated_at = ? WHERE id = ?
Parameters:
[ 29.8 "2026-08-26 06:23:47" 2065 ] |
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\Product | 2 |
| App\Entity\SeoMeta | 2 |
| App\Entity\CartItem | 2 |
| App\Entity\SystemSetting | 1 |
| App\Entity\Category | 1 |
| App\Entity\Cart | 1 |
| App\Entity\ShippingMethod | 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. |