Query Metrics
155
Database Queries
18
Different statements
177.77 ms
Query time
0
Invalid entities
196
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.68 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 | 1.81 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.id = ?
Parameters:
[
2127
]
|
| 3 | 1.62 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:
[
2127
]
|
| 4 | 1.98 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:
[
3534
]
|
| 5 | 1.91 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:
[
3537
]
|
| 6 | 3.89 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:
[
3570
]
|
| 7 | 2.28 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:
[
3584
]
|
| 8 | 2.02 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:
[
3558
]
|
| 9 | 2.00 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:
[
3550
]
|
| 10 | 0.72 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:
[
3582
]
|
| 11 | 1.60 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:
[
3598
]
|
| 12 | 1.27 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:
[
3592
]
|
| 13 | 2.57 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:
[
3546
]
|
| 14 | 1.66 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:
[
3575
]
|
| 15 | 2.50 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:
[
3567
]
|
| 16 | 1.52 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:
[
3586
]
|
| 17 | 3.51 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:
[
3547
]
|
| 18 | 0.74 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:
[
3577
]
|
| 19 | 3.10 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:
[
3606
]
|
| 20 | 0.77 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:
[
3574
]
|
| 21 | 1.33 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:
[
3572
]
|
| 22 | 0.65 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:
[
3549
]
|
| 23 | 0.83 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:
[
3580
]
|
| 24 | 1.22 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:
[
3535
]
|
| 25 | 1.60 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:
[ 3534 2236.1 ] |
| 26 | 1.42 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:
[ 3537 2236.1 ] |
| 27 | 0.49 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:
[ 3570 2236.1 ] |
| 28 | 1.48 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:
[ 3584 2236.1 ] |
| 29 | 0.54 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:
[ 3558 2236.1 ] |
| 30 | 0.40 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:
[ 3550 2236.1 ] |
| 31 | 1.48 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:
[ 3582 2236.1 ] |
| 32 | 0.50 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:
[ 3598 2236.1 ] |
| 33 | 0.47 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:
[ 3592 2236.1 ] |
| 34 | 1.09 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:
[ 3546 2236.1 ] |
| 35 | 0.47 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:
[ 3575 2236.1 ] |
| 36 | 1.13 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:
[ 3567 2236.1 ] |
| 37 | 0.70 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:
[ 3586 2236.1 ] |
| 38 | 0.47 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:
[ 3547 2236.1 ] |
| 39 | 0.53 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:
[ 3577 2236.1 ] |
| 40 | 1.45 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:
[ 3606 2236.1 ] |
| 41 | 0.44 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:
[ 3574 2236.1 ] |
| 42 | 1.50 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:
[ 3572 2236.1 ] |
| 43 | 1.53 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:
[ 3549 2236.1 ] |
| 44 | 0.46 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:
[ 3580 2236.1 ] |
| 45 | 1.40 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:
[ 3535 2236.1 ] |
| 46 | 1.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.description AS description_4, t0.delivery_time AS delivery_time_5, t0.type AS type_6, t0.zone_id AS zone_id_7 FROM shipping_method t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 47 | 1.72 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:
[ 3534 2236.1 ] |
| 48 | 0.78 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:
[ 3537 2236.1 ] |
| 49 | 1.53 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:
[ 3570 2236.1 ] |
| 50 | 1.52 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:
[ 3584 2236.1 ] |
| 51 | 0.53 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:
[ 3558 2236.1 ] |
| 52 | 2.42 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:
[ 3550 2236.1 ] |
| 53 | 0.56 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:
[ 3582 2236.1 ] |
| 54 | 0.97 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:
[ 3598 2236.1 ] |
| 55 | 2.52 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:
[ 3592 2236.1 ] |
| 56 | 1.08 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:
[ 3546 2236.1 ] |
| 57 | 0.80 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:
[ 3575 2236.1 ] |
| 58 | 1.79 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:
[ 3567 2236.1 ] |
| 59 | 1.75 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:
[ 3586 2236.1 ] |
| 60 | 1.12 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:
[ 3547 2236.1 ] |
| 61 | 0.51 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:
[ 3577 2236.1 ] |
| 62 | 1.70 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:
[ 3606 2236.1 ] |
| 63 | 0.43 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:
[ 3574 2236.1 ] |
| 64 | 1.19 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:
[ 3572 2236.1 ] |
| 65 | 0.46 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:
[ 3549 2236.1 ] |
| 66 | 0.49 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:
[ 3580 2236.1 ] |
| 67 | 1.53 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:
[ 3535 2236.1 ] |
| 68 | 2.35 ms |
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.content AS content_4, t0.page_template AS page_template_5, t0.builder_sections AS builder_sections_6, t0.published_sections AS published_sections_7, t0.is_published AS is_published_8, t0.published_at AS published_at_9, t0.position AS position_10, t0.is_footer_menu AS is_footer_menu_11, t0.footer_placement AS footer_placement_12, t0.footer_position AS footer_position_13, t0.slider_enabled AS slider_enabled_14, t0.slider_type AS slider_type_15, t0.show_in_menu AS show_in_menu_16, t0.parent_id AS parent_id_17, t0.footer_parent_id AS footer_parent_id_18, t0.seo_meta_id AS seo_meta_id_19 FROM page t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"shop"
]
|
| 69 | 1.59 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.placeholder AS placeholder_3, t0.template_content AS template_content_4 FROM widget t0
Parameters:
[] |
| 70 | 35.16 ms |
SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ?
Parameters:
[ "de" "messages" ] |
| 71 | 0.89 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.parent_id AS parent_id_4, t0.seo_meta_id AS seo_meta_id_5 FROM category t0
Parameters:
[] |
| 72 | 0.87 ms |
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.value AS value_3, t0.type AS type_4, t0.description AS description_5, t0.scope AS scope_6 FROM system_setting t0 WHERE t0.settings_key = ? LIMIT 1
Parameters:
[
"shop_menu_config"
]
|
| 73 | 1.66 ms |
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.parent_id WHERE p0_.parent_id IS NULL AND p0_.show_in_menu = 1 ORDER BY p0_.position ASC
Parameters:
[] |
| 74 | 1.55 ms |
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.footer_parent_id WHERE p0_.footer_parent_id IS NULL AND p0_.footer_placement = ? AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC
Parameters:
[
"main"
]
|
| 75 | 2.77 ms |
SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.content AS content_3, p0_.page_template AS page_template_4, p0_.builder_sections AS builder_sections_5, p0_.published_sections AS published_sections_6, p0_.is_published AS is_published_7, p0_.published_at AS published_at_8, p0_.position AS position_9, p0_.is_footer_menu AS is_footer_menu_10, p0_.footer_placement AS footer_placement_11, p0_.footer_position AS footer_position_12, p0_.slider_enabled AS slider_enabled_13, p0_.slider_type AS slider_type_14, p0_.show_in_menu AS show_in_menu_15, p1_.id AS id_16, p1_.slug AS slug_17, p1_.title AS title_18, p1_.content AS content_19, p1_.page_template AS page_template_20, p1_.builder_sections AS builder_sections_21, p1_.published_sections AS published_sections_22, p1_.is_published AS is_published_23, p1_.published_at AS published_at_24, p1_.position AS position_25, p1_.is_footer_menu AS is_footer_menu_26, p1_.footer_placement AS footer_placement_27, p1_.footer_position AS footer_position_28, p1_.slider_enabled AS slider_enabled_29, p1_.slider_type AS slider_type_30, p1_.show_in_menu AS show_in_menu_31, p0_.parent_id AS parent_id_32, p0_.footer_parent_id AS footer_parent_id_33, p0_.seo_meta_id AS seo_meta_id_34, p1_.parent_id AS parent_id_35, p1_.footer_parent_id AS footer_parent_id_36, p1_.seo_meta_id AS seo_meta_id_37 FROM page p0_ LEFT JOIN page p1_ ON p0_.id = p1_.footer_parent_id WHERE p0_.footer_parent_id IS NULL AND p0_.footer_placement = ? AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC
Parameters:
[
"legal"
]
|
| 76 | 0.82 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_currency"
]
|
| 77 | 0.77 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 = ? AND s0_.scope = ?
Parameters:
[ "cart_session_lifetime" "frontend" ] |
| 78 | 4.39 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:
[ "3gp4ubanhp9t9gmf6vimn50iul" "open" ] |
| 79 | 0.95 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:
[
2127
]
|
| 80 | 0.84 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:
[
"sitename"
]
|
| 81 | 0.63 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:
[
"siteslogan"
]
|
| 82 | 0.49 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_phone"
]
|
| 83 | 0.43 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:
[
"site_email"
]
|
| 84 | 0.35 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:
[
"site_opening_hours"
]
|
| 85 | 0.34 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:
[
"site_city"
]
|
| 86 | 0.30 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:
[
"site_top_location"
]
|
| 87 | 0.38 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:
[
"site_opening_hours_header"
]
|
| 88 | 0.37 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_logo"
]
|
| 89 | 3.96 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:
[ "3gp4ubanhp9t9gmf6vimn50iul" "open" ] |
| 90 | 0.90 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:
[
2127
]
|
| 91 | 0.65 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3534
]
|
| 92 | 0.64 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3534
]
|
| 93 | 0.56 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3534
]
|
| 94 | 0.63 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3537
]
|
| 95 | 0.52 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3537
]
|
| 96 | 0.47 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3537
]
|
| 97 | 0.51 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3570
]
|
| 98 | 0.40 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3570
]
|
| 99 | 0.32 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3570
]
|
| 100 | 0.43 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3584
]
|
| 101 | 0.33 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3584
]
|
| 102 | 0.43 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3584
]
|
| 103 | 0.54 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3558
]
|
| 104 | 0.33 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3558
]
|
| 105 | 0.32 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3558
]
|
| 106 | 0.44 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3550
]
|
| 107 | 0.33 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3550
]
|
| 108 | 0.32 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3550
]
|
| 109 | 0.44 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3582
]
|
| 110 | 0.41 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3582
]
|
| 111 | 0.44 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3582
]
|
| 112 | 0.43 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3598
]
|
| 113 | 0.31 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3598
]
|
| 114 | 0.36 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3598
]
|
| 115 | 0.45 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3592
]
|
| 116 | 0.41 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3592
]
|
| 117 | 0.37 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3592
]
|
| 118 | 0.50 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3546
]
|
| 119 | 0.32 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3546
]
|
| 120 | 0.33 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3546
]
|
| 121 | 0.45 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3575
]
|
| 122 | 0.35 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3575
]
|
| 123 | 0.36 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3575
]
|
| 124 | 0.43 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3567
]
|
| 125 | 0.39 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3567
]
|
| 126 | 0.39 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3567
]
|
| 127 | 0.43 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3586
]
|
| 128 | 0.37 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3586
]
|
| 129 | 0.33 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3586
]
|
| 130 | 0.47 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3547
]
|
| 131 | 0.33 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3547
]
|
| 132 | 0.34 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3547
]
|
| 133 | 0.47 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3577
]
|
| 134 | 0.34 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3577
]
|
| 135 | 0.32 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3577
]
|
| 136 | 0.43 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3606
]
|
| 137 | 0.31 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3606
]
|
| 138 | 0.33 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3606
]
|
| 139 | 0.39 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3574
]
|
| 140 | 0.33 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3574
]
|
| 141 | 0.48 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3574
]
|
| 142 | 0.48 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3572
]
|
| 143 | 0.32 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3572
]
|
| 144 | 0.31 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3572
]
|
| 145 | 0.40 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3549
]
|
| 146 | 0.32 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3549
]
|
| 147 | 0.33 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3549
]
|
| 148 | 0.44 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3580
]
|
| 149 | 0.37 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3580
]
|
| 150 | 0.35 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3580
]
|
| 151 | 0.41 ms |
SELECT t0.id AS id_1, t0.image_name AS image_name_2, t0.position AS position_3, t0.product_id AS product_id_4 FROM product_image t0 WHERE t0.product_id = ?
Parameters:
[
3535
]
|
| 152 | 0.36 ms |
SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (?)
Parameters:
[
3535
]
|
| 153 | 0.35 ms |
SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (?)
Parameters:
[
3535
]
|
| 154 | 0.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 = ? AND s0_.scope = ?
Parameters:
[ "shop_product_fulfillment_badges_enabled" "frontend" ] |
| 155 | 0.91 ms |
SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = ? AND t0_.domain = ?
Parameters:
[ "de" "frontend_shop" ] |
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\SeoMeta | 60 |
| App\Entity\Category | 33 |
| App\Entity\CartItem | 21 |
| App\Entity\Product | 21 |
| App\Entity\ProductImage | 21 |
| App\Entity\Widget | 18 |
| App\Entity\Page | 10 |
| App\Entity\SystemSetting | 9 |
| App\Entity\Cart | 1 |
| App\Entity\ShippingMethod | 1 |
| App\Entity\ShippingZone | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\SystemSetting | No errors. |
| App\Entity\Cart | No errors. |
| App\Entity\Customer | No errors. |
| App\Entity\ShippingMethod | No errors. |
| App\Entity\Coupon | No errors. |
| App\Entity\CartItem | No errors. |
| App\Entity\Product | No errors. |
| App\Entity\CrossSellRule | No errors. |
| App\Entity\Category | No errors. |
| App\Entity\SeoMeta | No errors. |
| App\Entity\ProductImage | No errors. |
| App\Entity\ShippingZone | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\Widget | No errors. |
| App\Entity\Translation | No errors. |
| App\Entity\ProductConfigurator | No errors. |
| App\Entity\ConfigurableProduct | No errors. |