Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.layout AS layout_2,
  t0.serialized_layout AS serialized_layout_3,
  t0.time_last_updated AS time_last_updated_4,
  t0.synchronize_translations AS synchronize_translations_5,
  t0.type AS type_6,
  t0.parent_id AS parent_id_7,
  t0.primary_image_id AS primary_image_id_8
FROM
  cms_page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.layout AS layout_2, t0.serialized_layout AS serialized_layout_3, t0.time_last_updated AS time_last_updated_4, t0.synchronize_translations AS synchronize_translations_5, t0.type AS type_6, t0.parent_id AS parent_id_7, t0.primary_image_id AS primary_image_id_8 FROM cms_page t0 WHERE t0.id = 4;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.enabled AS enabled_2,
  c0_.priority AS priority_3,
  c1_.id AS id_4,
  c1_.locale AS locale_5,
  c1_.title AS title_6,
  c1_.content_elements AS content_elements_7,
  c1_.link AS link_8,
  c1_.popup_id AS popup_id_9,
  c1_.image_id AS image_id_10
FROM
  cms_popup c0_
  LEFT JOIN cms_popup_translation c1_ ON c0_.id = c1_.popup_id
WHERE
  c0_.enabled = 1
  AND c1_.locale = ?
ORDER BY
  c0_.priority ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.enabled AS enabled_2, c0_.priority AS priority_3, c1_.id AS id_4, c1_.locale AS locale_5, c1_.title AS title_6, c1_.content_elements AS content_elements_7, c1_.link AS link_8, c1_.popup_id AS popup_id_9, c1_.image_id AS image_id_10 FROM cms_popup c0_ LEFT JOIN cms_popup_translation c1_ ON c0_.id = c1_.popup_id WHERE c0_.enabled = 1 AND c1_.locale = 'en' ORDER BY c0_.priority ASC;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO shop_customer (
  is_deleted, first_name, last_name,
  email_address, phone_number, company,
  preferred_currency, submitted_personal_details,
  accepted_privacy_policy, separate_cart_per_session,
  can_change_own_details, locale,
  default_invoice_address_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO shop_customer (is_deleted, first_name, last_name, email_address, phone_number, company, preferred_currency, submitted_personal_details, accepted_privacy_policy, separate_cart_per_session, can_change_own_details, locale, default_invoice_address_id) VALUES (0, '', '', '', '', '', NULL, 0, 0, 0, 1, 'en', NULL);

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO shop_order (
  number, item_count, total_price, state,
  previous_states, time_customer_confirmed,
  time_state_changed, currency, selected_payment_option,
  customer_note, customer_id, invoice_address_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO shop_order (number, item_count, total_price, state, previous_states, time_customer_confirmed, time_state_changed, currency, selected_payment_option, customer_note, customer_id, invoice_address_id) VALUES (NULL, 0, NULL, 'cart', '[]', NULL, '2025-01-18 06:20:55', 'EUR', NULL, '', 3586, NULL);

"COMMIT"

"COMMIT";

SELECT
  s0_.id AS id_0,
  s0_.quantity AS quantity_1,
  s1_.quantity AS quantity_2,
  s1_.currencies AS currencies_3
FROM
  shop_order_item s0_
  LEFT JOIN shop_product_variant s2_ ON s0_.product_variant_id = s2_.id
  LEFT JOIN shop_product s3_ ON s2_.product_id = s3_.id
  LEFT JOIN shop_product_n_for_x s1_ ON (s1_.product_id = s3_.id)
  LEFT JOIN shop_order_item_invoice_item s4_ ON s0_.id = s4_.order_item_id
  LEFT JOIN shop_invoice_item s5_ ON s4_.id = s5_.id
WHERE
  s0_.order_id = ?
  AND s5_.id IS NULL
  AND s1_.id IS NOT NULL
  AND s0_.quantity >= s1_.quantity
GROUP BY
  s0_.id,
  s1_.id
ORDER BY
  s1_.quantity DESC

SELECT s0_.id AS id_0, s0_.quantity AS quantity_1, s1_.quantity AS quantity_2, s1_.currencies AS currencies_3 FROM shop_order_item s0_ LEFT JOIN shop_product_variant s2_ ON s0_.product_variant_id = s2_.id LEFT JOIN shop_product s3_ ON s2_.product_id = s3_.id LEFT JOIN shop_product_n_for_x s1_ ON (s1_.product_id = s3_.id) LEFT JOIN shop_order_item_invoice_item s4_ ON s0_.id = s4_.order_item_id LEFT JOIN shop_invoice_item s5_ ON s4_.id = s5_.id WHERE s0_.order_id = 2814 AND s5_.id IS NULL AND s1_.id IS NOT NULL AND s0_.quantity >= s1_.quantity GROUP BY s0_.id, s1_.id ORDER BY s1_.quantity DESC;

SELECT
  t0.delivery AS delivery_1,
  t0.date_time AS date_time_2,
  t0.order_id AS order_id_3,
  t0.order_pickup_delivery_address_id AS order_pickup_delivery_address_id_4
FROM
  hb_order_pickup_delivery t0
WHERE
  t0.order_id = ?
LIMIT
  1

SELECT t0.delivery AS delivery_1, t0.date_time AS date_time_2, t0.order_id AS order_id_3, t0.order_pickup_delivery_address_id AS order_pickup_delivery_address_id_4 FROM hb_order_pickup_delivery t0 WHERE t0.order_id = 2814 LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s0_.maximum_usage AS maximum_usage_2,
  s0_.type AS type_3,
  s0_.percentage AS percentage_4,
  s0_.quantity AS quantity_5,
  s0_.quantity_free AS quantity_free_6,
  s0_.allow_multiple_products AS allow_multiple_products_7,
  s0_.date_start AS date_start_8,
  s0_.date_end AS date_end_9,
  s0_.disabled_days AS disabled_days_10
FROM
  shop_discount s0_
  LEFT JOIN shop_order_discount s1_ ON (s0_.id = s1_.discount_id)
  LEFT JOIN shop_order_discount s2_ ON (
    s0_.id = s2_.discount_id
    AND s2_.order_id <> ?
  )
  LEFT JOIN shop_discount_customer s4_ ON s0_.id = s4_.discount_id
  LEFT JOIN shop_customer s3_ ON s3_.id = s4_.customer_id
  LEFT JOIN shop_discount_group s6_ ON s0_.id = s6_.discount_id
  LEFT JOIN shop_group s5_ ON s5_.id = s6_.group_id
WHERE
  (
    s1_.id IS NULL
    OR s1_.order_id = ?
  )
  AND (
    (
      s0_.code = ''
      OR s0_.code IS NULL
      OR s1_.order_id IS NOT NULL
    )
  )
  AND (
    (
      s3_.id IS NULL
      OR s3_.id = ?
    )
    AND (
      s5_.id IS NULL
      OR EXISTS (
        SELECT
          1
        FROM
          shop_customer_group s7_
        WHERE
          s7_.group_id = s5_.id
          AND s7_.customer_id IN (?)
      )
    )
  )
  AND (
    (
      s0_.date_start IS NULL
      OR s0_.date_start <= ?
    )
  )
  AND (
    (
      s0_.date_end IS NULL
      OR s0_.date_end >= ?
    )
  )
  AND s0_.disabled_days NOT LIKE ?
GROUP BY
  s0_.id,
  s2_.discount_id
HAVING
  (
    s0_.maximum_usage IS NULL
    OR COUNT(s2_.id) < s0_.maximum_usage
  )

SELECT s0_.id AS id_0, s0_.code AS code_1, s0_.maximum_usage AS maximum_usage_2, s0_.type AS type_3, s0_.percentage AS percentage_4, s0_.quantity AS quantity_5, s0_.quantity_free AS quantity_free_6, s0_.allow_multiple_products AS allow_multiple_products_7, s0_.date_start AS date_start_8, s0_.date_end AS date_end_9, s0_.disabled_days AS disabled_days_10 FROM shop_discount s0_ LEFT JOIN shop_order_discount s1_ ON (s0_.id = s1_.discount_id) LEFT JOIN shop_order_discount s2_ ON (s0_.id = s2_.discount_id AND s2_.order_id <> 2814) LEFT JOIN shop_discount_customer s4_ ON s0_.id = s4_.discount_id LEFT JOIN shop_customer s3_ ON s3_.id = s4_.customer_id LEFT JOIN shop_discount_group s6_ ON s0_.id = s6_.discount_id LEFT JOIN shop_group s5_ ON s5_.id = s6_.group_id WHERE (s1_.id IS NULL OR s1_.order_id = 2814) AND ((s0_.code = '' OR s0_.code IS NULL OR s1_.order_id IS NOT NULL)) AND ((s3_.id IS NULL OR s3_.id = 3586) AND (s5_.id IS NULL OR EXISTS (SELECT 1 FROM shop_customer_group s7_ WHERE s7_.group_id = s5_.id AND s7_.customer_id IN (3586)))) AND ((s0_.date_start IS NULL OR s0_.date_start <= '2025-01-18')) AND ((s0_.date_end IS NULL OR s0_.date_end >= '2025-01-18')) AND s0_.disabled_days NOT LIKE '%6%' GROUP BY s0_.id, s2_.discount_id HAVING (s0_.maximum_usage IS NULL OR COUNT(s2_.id) < s0_.maximum_usage);

SELECT
  t0.delivery AS delivery_1,
  t0.date_time AS date_time_2,
  t0.order_id AS order_id_3,
  t0.order_pickup_delivery_address_id AS order_pickup_delivery_address_id_4
FROM
  hb_order_pickup_delivery t0
WHERE
  t0.order_id = ?

SELECT t0.delivery AS delivery_1, t0.date_time AS date_time_2, t0.order_id AS order_id_3, t0.order_pickup_delivery_address_id AS order_pickup_delivery_address_id_4 FROM hb_order_pickup_delivery t0 WHERE t0.order_id = 2814;

SELECT
  t0.gesneden_in_doos AS gesneden_in_doos_1,
  t0.order_id AS order_id_2
FROM
  hb_order_options t0
WHERE
  t0.order_id = ?

SELECT t0.gesneden_in_doos AS gesneden_in_doos_1, t0.order_id AS order_id_2 FROM hb_order_options t0 WHERE t0.order_id = 2814;

SELECT
  t0.delivery_allowed AS delivery_allowed_1,
  t0.delivery_minimum AS delivery_minimum_2,
  t0.rit AS rit_3,
  t0.factuur_allowed AS factuur_allowed_4,
  t0.contant_allowed AS contant_allowed_5,
  t0.pin_allowed AS pin_allowed_6,
  t0.latest_order_time AS latest_order_time_7,
  t0.customer_id AS customer_id_8
FROM
  hb_customer_options t0
WHERE
  t0.customer_id = ?

SELECT t0.delivery_allowed AS delivery_allowed_1, t0.delivery_minimum AS delivery_minimum_2, t0.rit AS rit_3, t0.factuur_allowed AS factuur_allowed_4, t0.contant_allowed AS contant_allowed_5, t0.pin_allowed AS pin_allowed_6, t0.latest_order_time AS latest_order_time_7, t0.customer_id AS customer_id_8 FROM hb_customer_options t0 WHERE t0.customer_id = 3586;

SELECT
  t0.name AS name_1,
  t0.department AS department_2,
  t0.email_address AS email_address_3,
  t0.order_id AS order_id_4
FROM
  hb_order_employee t0
WHERE
  t0.order_id = ?

SELECT t0.name AS name_1, t0.department AS department_2, t0.email_address AS email_address_3, t0.order_id AS order_id_4 FROM hb_order_employee t0 WHERE t0.order_id = 2814;

SELECT
  t0.order_id AS order_id_1,
  t0.shop_id AS shop_id_2
FROM
  multishop_order_shop t0
WHERE
  t0.order_id = ?

SELECT t0.order_id AS order_id_1, t0.shop_id AS shop_id_2 FROM multishop_order_shop t0 WHERE t0.order_id = 2814;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.noreply_email AS noreply_email_3
FROM
  multishop_shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.noreply_email AS noreply_email_3 FROM multishop_shop t0 WHERE t0.id = 1;

SELECT
  t0.order_id AS order_id_1,
  t0.shop_id AS shop_id_2
FROM
  multishop_order_shop t0
WHERE
  t0.order_id = ?

SELECT t0.order_id AS order_id_1, t0.shop_id AS shop_id_2 FROM multishop_order_shop t0 WHERE t0.order_id = 2814;

SELECT
  t0.shop_id AS shop_id_1,
  t0.opening_hours_set_id AS opening_hours_set_id_2
FROM
  hb_shop_options t0
WHERE
  t0.shop_id = ?

SELECT t0.shop_id AS shop_id_1, t0.opening_hours_set_id AS opening_hours_set_id_2 FROM hb_shop_options t0 WHERE t0.shop_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.by_appointment AS by_appointment_3
FROM
  opening_hours_set t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.by_appointment AS by_appointment_3 FROM opening_hours_set t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.day_of_the_week AS day_of_the_week_3,
  t0.time_start AS time_start_4,
  t0.time_end AS time_end_5,
  t0.preparation_time AS preparation_time_6,
  t0.set_id AS set_id_7
FROM
  opening_hours_opening_hours t0
WHERE
  t0.set_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.day_of_the_week AS day_of_the_week_3, t0.time_start AS time_start_4, t0.time_end AS time_end_5, t0.preparation_time AS preparation_time_6, t0.set_id AS set_id_7 FROM opening_hours_opening_hours t0 WHERE t0.set_id = 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.caption AS caption_3,
  t0.set_id AS set_id_4
FROM
  opening_hours_set_translation t0
WHERE
  t0.set_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.caption AS caption_3, t0.set_id AS set_id_4 FROM opening_hours_set_translation t0 WHERE t0.set_id = 1;

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.storage_identifier AS storage_identifier_3,
  t0.public_name AS public_name_4,
  t0.derivatives AS derivatives_5,
  t0.enqueued_derivatives AS enqueued_derivatives_6,
  t0.derivatives_enqueued AS derivatives_enqueued_7,
  t0.mime_type AS mime_type_8,
  t0.size AS size_9,
  t0.width AS width_10,
  t0.height AS height_11,
  t0.time_uploaded AS time_uploaded_12
FROM
  cms_upload t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.derivatives AS derivatives_5, t0.enqueued_derivatives AS enqueued_derivatives_6, t0.derivatives_enqueued AS derivatives_enqueued_7, t0.mime_type AS mime_type_8, t0.size AS size_9, t0.width AS width_10, t0.height AS height_11, t0.time_uploaded AS time_uploaded_12 FROM cms_upload t0 WHERE t0.id = 116;

SELECT
  t0.delivery AS delivery_1,
  t0.date_time AS date_time_2,
  t0.order_id AS order_id_3,
  t0.order_pickup_delivery_address_id AS order_pickup_delivery_address_id_4
FROM
  hb_order_pickup_delivery t0
WHERE
  t0.order_id = ?

SELECT t0.delivery AS delivery_1, t0.date_time AS date_time_2, t0.order_id AS order_id_3, t0.order_pickup_delivery_address_id AS order_pickup_delivery_address_id_4 FROM hb_order_pickup_delivery t0 WHERE t0.order_id = 2814;

SELECT
  t0.gesneden_in_doos AS gesneden_in_doos_1,
  t0.order_id AS order_id_2
FROM
  hb_order_options t0
WHERE
  t0.order_id = ?

SELECT t0.gesneden_in_doos AS gesneden_in_doos_1, t0.order_id AS order_id_2 FROM hb_order_options t0 WHERE t0.order_id = 2814;

SELECT
  t0.delivery_allowed AS delivery_allowed_1,
  t0.delivery_minimum AS delivery_minimum_2,
  t0.rit AS rit_3,
  t0.factuur_allowed AS factuur_allowed_4,
  t0.contant_allowed AS contant_allowed_5,
  t0.pin_allowed AS pin_allowed_6,
  t0.latest_order_time AS latest_order_time_7,
  t0.customer_id AS customer_id_8
FROM
  hb_customer_options t0
WHERE
  t0.customer_id = ?

SELECT t0.delivery_allowed AS delivery_allowed_1, t0.delivery_minimum AS delivery_minimum_2, t0.rit AS rit_3, t0.factuur_allowed AS factuur_allowed_4, t0.contant_allowed AS contant_allowed_5, t0.pin_allowed AS pin_allowed_6, t0.latest_order_time AS latest_order_time_7, t0.customer_id AS customer_id_8 FROM hb_customer_options t0 WHERE t0.customer_id = 3586;

SELECT
  t0.name AS name_1,
  t0.department AS department_2,
  t0.email_address AS email_address_3,
  t0.order_id AS order_id_4
FROM
  hb_order_employee t0
WHERE
  t0.order_id = ?

SELECT t0.name AS name_1, t0.department AS department_2, t0.email_address AS email_address_3, t0.order_id AS order_id_4 FROM hb_order_employee t0 WHERE t0.order_id = 2814;

SELECT
  t0.order_id AS order_id_1,
  t0.shop_id AS shop_id_2
FROM
  multishop_order_shop t0
WHERE
  t0.order_id = ?

SELECT t0.order_id AS order_id_1, t0.shop_id AS shop_id_2 FROM multishop_order_shop t0 WHERE t0.order_id = 2814;