Symfony Profiler

SELECT
  t0_.translation_key AS translation_key_0,
  t0_.translation_value AS translation_value_1
FROM
  translation t0_
WHERE
  t0_.locale = ?
  AND t0_.domain = ?

SELECT t0_.translation_key AS translation_key_0, t0_.translation_value AS translation_value_1 FROM translation t0_ WHERE t0_.locale = 'de' AND t0_.domain = 'messages';

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

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 = 3534 AND c0_.is_active = 1 AND c0_.min_cart_value <= 1546.8 AND (c0_.valid_until IS NULL OR c0_.valid_until >= CURRENT_TIMESTAMP) ORDER BY c0_.priority DESC, c0_.created_at DESC;

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 = ?

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 = 3534;

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 = ?

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 = 3534;

SELECT
  p0_.base_product_id AS sclr_0,
  p0_.id AS id_1
FROM
  product_configurator p0_
WHERE
  p0_.base_product_id IN (?)

SELECT p0_.base_product_id AS sclr_0, p0_.id AS id_1 FROM product_configurator p0_ WHERE p0_.base_product_id IN (3534);

SELECT
  c0_.product_id AS sclr_0,
  c0_.id AS id_1
FROM
  configurable_product c0_
WHERE
  c0_.product_id IN (?)

SELECT c0_.product_id AS sclr_0, c0_.id AS id_1 FROM configurable_product c0_ WHERE c0_.product_id IN (3534);

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

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 = '3gp4ubanhp9t9gmf6vimn50iul' AND t0.status = 'open' LIMIT 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 = ?

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 = 'shop_status';

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 = ?

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 = 2127;

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

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 = 'main' AND p0_.is_published = 1 ORDER BY p0_.footer_position ASC, p1_.footer_position ASC;

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

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;

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 = ?

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 = 'cart_session_lifetime' AND s0_.scope = 'frontend';

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

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;

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 = ?

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 = 2127;

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

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;

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 = ?

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 = 1;

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

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 = 'shop_menu_config' LIMIT 1;

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

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 = 'shop' LIMIT 1;