Symfony Profiler

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

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
  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.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
WHERE
  t0.parent_id = ?
ORDER BY
  t0.name ASC

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 WHERE t0.parent_id = 891 ORDER BY t0.name 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 = ?
  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
  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 = '' AND t0.status = 'open' LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.price AS price_2,
  p0_.label AS label_3,
  p0_.available AS available_4,
  p0_.slug AS slug_5,
  p0_.description AS description_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p0_.sku AS sku_9,
  p0_.short_description AS short_description_10,
  p0_.stock AS stock_11,
  p0_.delivery_time AS delivery_time_12,
  p0_.weight AS weight_13,
  p0_.length AS length_14,
  p0_.width AS width_15,
  p0_.height AS height_16,
  p0_.manufacturer AS manufacturer_17,
  p0_.ean AS ean_18,
  p0_.is_active AS is_active_19,
  p0_.special_price AS special_price_20,
  p0_.uvp AS uvp_21,
  p0_.tags AS tags_22,
  p0_.video_url AS video_url_23,
  p0_.material AS material_24,
  p0_.country_of_origin AS country_of_origin_25,
  p0_.custom1 AS custom1_26,
  p0_.custom2 AS custom2_27,
  p0_.mwst AS mwst_28,
  p0_.versandkosten AS versandkosten_29,
  p0_.pickup_available AS pickup_available_30,
  p0_.pickup_only AS pickup_only_31,
  p0_.pickup_note AS pickup_note_32,
  p0_.category_id AS category_id_33,
  p0_.seo_meta_id AS seo_meta_id_34,
  p0_.shipping_method_id AS shipping_method_id_35
FROM
  product p0_
WHERE
  p0_.available = ?
  AND (
    (
      p0_.is_active = ?
      OR p0_.is_active IS NULL
    )
  )
LIMIT
  12
OFFSET
  60

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.label AS label_3, p0_.available AS available_4, p0_.slug AS slug_5, p0_.description AS description_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.sku AS sku_9, p0_.short_description AS short_description_10, p0_.stock AS stock_11, p0_.delivery_time AS delivery_time_12, p0_.weight AS weight_13, p0_.length AS length_14, p0_.width AS width_15, p0_.height AS height_16, p0_.manufacturer AS manufacturer_17, p0_.ean AS ean_18, p0_.is_active AS is_active_19, p0_.special_price AS special_price_20, p0_.uvp AS uvp_21, p0_.tags AS tags_22, p0_.video_url AS video_url_23, p0_.material AS material_24, p0_.country_of_origin AS country_of_origin_25, p0_.custom1 AS custom1_26, p0_.custom2 AS custom2_27, p0_.mwst AS mwst_28, p0_.versandkosten AS versandkosten_29, p0_.pickup_available AS pickup_available_30, p0_.pickup_only AS pickup_only_31, p0_.pickup_note AS pickup_note_32, p0_.category_id AS category_id_33, p0_.seo_meta_id AS seo_meta_id_34, p0_.shipping_method_id AS shipping_method_id_35 FROM product p0_ WHERE p0_.available = 1 AND ((p0_.is_active = 1 OR p0_.is_active IS NULL)) LIMIT 12 OFFSET 60;

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
  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 (3572, 3573, 3574, 3575, 3576, 3577, 3578, 3579, 3580, 3581, 3582, 3583);

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

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
  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 (3572, 3573, 3574, 3575, 3576, 3577, 3578, 3579, 3580, 3581, 3582, 3583);

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.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;

SELECT
  COUNT(p0_.id) AS sclr_0
FROM
  product p0_
WHERE
  p0_.available = ?
  AND (
    (
      p0_.is_active = ?
      OR p0_.is_active IS NULL
    )
  )

SELECT COUNT(p0_.id) AS sclr_0 FROM product p0_ WHERE p0_.available = 1 AND ((p0_.is_active = 1 OR p0_.is_active IS NULL));

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
WHERE
  t0.parent_id IS NULL
ORDER BY
  t0.name ASC

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 WHERE t0.parent_id IS NULL ORDER BY t0.name ASC;