Symfony Profiler

SELECT
  t0.visible_in_extras AS visible_in_extras_1,
  t0.show_extras AS show_extras_2,
  t0.category_id AS category_id_3
FROM
  hb_category_options t0

SELECT t0.visible_in_extras AS visible_in_extras_1, t0.show_extras AS show_extras_2, t0.category_id AS category_id_3 FROM hb_category_options t0;

SELECT
  t0.homemade AS homemade_1,
  t0.new AS new_2,
  t0.vegan AS vegan_3,
  t0.vegetarian AS vegetarian_4,
  t0.fish AS fish_5,
  t0.beef AS beef_6,
  t0.product_id AS product_id_7
FROM
  hb_product_features t0

SELECT t0.homemade AS homemade_1, t0.new AS new_2, t0.vegan AS vegan_3, t0.vegetarian AS vegetarian_4, t0.fish AS fish_5, t0.beef AS beef_6, t0.product_id AS product_id_7 FROM hb_product_features t0;

"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:16:23', 'EUR', NULL, '', 3584, NULL);

"COMMIT"

"COMMIT";

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

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
  h0_.available AS available_0,
  h0_.sold_out AS sold_out_1,
  h0_.product_id AS product_id_2,
  h0_.shop_id AS shop_id_3
FROM
  hb_product_available h0_
WHERE
  h0_.shop_id = ?

SELECT h0_.available AS available_0, h0_.sold_out AS sold_out_1, h0_.product_id AS product_id_2, h0_.shop_id AS shop_id_3 FROM hb_product_available h0_ WHERE h0_.shop_id = 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.permalink AS permalink_4,
  t0.category_id AS category_id_5
FROM
  shop_category_translation t0

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.permalink AS permalink_4, t0.category_id AS category_id_5 FROM shop_category_translation t0;

SELECT
  t0.id AS id_1,
  t0.visible AS visible_2,
  t0.sort_order AS sort_order_3,
  t0.parent_id AS parent_id_4
FROM
  shop_category t0

SELECT t0.id AS id_1, t0.visible AS visible_2, t0.sort_order AS sort_order_3, t0.parent_id AS parent_id_4 FROM shop_category t0;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.name AS name_3,
  t0.permalink AS permalink_4,
  t0.category_id AS category_id_5
FROM
  shop_category_translation t0
WHERE
  t0.category_id IN (?)

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.permalink AS permalink_4, t0.category_id AS category_id_5 FROM shop_category_translation t0 WHERE t0.category_id IN (1, 2, 3, 4, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 19, 20, 21, 22);

SELECT
  t0.id AS id_1,
  t0.visible AS visible_2,
  t0.sort_order AS sort_order_3,
  t0.parent_id AS parent_id_4
FROM
  shop_category t0
WHERE
  t0.parent_id IS NULL
  AND t0.visible = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.visible AS visible_2, t0.sort_order AS sort_order_3, t0.parent_id AS parent_id_4 FROM shop_category t0 WHERE t0.parent_id IS NULL AND t0.visible = 1 ORDER BY t0.sort_order ASC;

SELECT
  s0_.id AS id_0,
  s0_.enabled AS enabled_1,
  s0_.deleted AS deleted_2,
  s1_.id AS id_3,
  s1_.cover AS cover_4,
  s1_.position_x AS position_x_5,
  s1_.position_y AS position_y_6,
  s2_.id AS id_7,
  s2_.visible AS visible_8,
  s2_.sort_order AS sort_order_9,
  s3_.id AS id_10,
  s3_.locale AS locale_11,
  s3_.name AS name_12,
  s3_.permalink AS permalink_13,
  s3_.description AS description_14,
  s4_.id AS id_15,
  s4_.enabled AS enabled_16,
  s5_.id AS id_17,
  s5_.locale AS locale_18,
  s6_.id AS id_19,
  s0_.primary_image_id AS primary_image_id_20,
  s0_.primary_product_image_id AS primary_product_image_id_21,
  s0_.default_variant_id AS default_variant_id_22,
  s1_.product_id AS product_id_23,
  s1_.variant_id AS variant_id_24,
  s1_.image_id AS image_id_25,
  s2_.parent_id AS parent_id_26,
  s3_.product_id AS product_id_27,
  s4_.product_id AS product_id_28,
  s5_.product_variant_id AS product_variant_id_29,
  s6_.product_id AS product_id_30,
  s6_.value_id AS value_id_31,
  s6_.variant_id AS variant_id_32
FROM
  shop_product s0_
  LEFT JOIN shop_product_image s1_ ON s0_.id = s1_.product_id
  LEFT JOIN shop_product_category s7_ ON s0_.id = s7_.product_id
  LEFT JOIN shop_category s2_ ON s2_.id = s7_.category_id
  LEFT JOIN shop_product_translation s3_ ON s0_.id = s3_.product_id
  LEFT JOIN shop_product_variant s4_ ON s0_.id = s4_.product_id
  LEFT JOIN shop_product_variant_translation s5_ ON s4_.id = s5_.product_variant_id
  LEFT JOIN shop_product_attribute s6_ ON s4_.id = s6_.variant_id
  LEFT JOIN hb_product_available h8_ ON (h8_.product_id = s0_.id)
WHERE
  s0_.enabled = 1
  AND s2_.visible = 1
  AND s0_.deleted = 0
  AND h8_.shop_id = ?
  AND (
    h8_.available = 1
    OR h8_.sold_out = 0
  )

SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.deleted AS deleted_2, s1_.id AS id_3, s1_.cover AS cover_4, s1_.position_x AS position_x_5, s1_.position_y AS position_y_6, s2_.id AS id_7, s2_.visible AS visible_8, s2_.sort_order AS sort_order_9, s3_.id AS id_10, s3_.locale AS locale_11, s3_.name AS name_12, s3_.permalink AS permalink_13, s3_.description AS description_14, s4_.id AS id_15, s4_.enabled AS enabled_16, s5_.id AS id_17, s5_.locale AS locale_18, s6_.id AS id_19, s0_.primary_image_id AS primary_image_id_20, s0_.primary_product_image_id AS primary_product_image_id_21, s0_.default_variant_id AS default_variant_id_22, s1_.product_id AS product_id_23, s1_.variant_id AS variant_id_24, s1_.image_id AS image_id_25, s2_.parent_id AS parent_id_26, s3_.product_id AS product_id_27, s4_.product_id AS product_id_28, s5_.product_variant_id AS product_variant_id_29, s6_.product_id AS product_id_30, s6_.value_id AS value_id_31, s6_.variant_id AS variant_id_32 FROM shop_product s0_ LEFT JOIN shop_product_image s1_ ON s0_.id = s1_.product_id LEFT JOIN shop_product_category s7_ ON s0_.id = s7_.product_id LEFT JOIN shop_category s2_ ON s2_.id = s7_.category_id LEFT JOIN shop_product_translation s3_ ON s0_.id = s3_.product_id LEFT JOIN shop_product_variant s4_ ON s0_.id = s4_.product_id LEFT JOIN shop_product_variant_translation s5_ ON s4_.id = s5_.product_variant_id LEFT JOIN shop_product_attribute s6_ ON s4_.id = s6_.variant_id LEFT JOIN hb_product_available h8_ ON (h8_.product_id = s0_.id) WHERE s0_.enabled = 1 AND s2_.visible = 1 AND s0_.deleted = 0 AND h8_.shop_id = 1 AND (h8_.available = 1 OR h8_.sold_out = 0);

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 IN (?)

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 IN (13, 19, 14, 33, 16, 42, 32, 39, 29, 27, 65, 55, 37, 44, 43, 57, 60, 59, 58, 98, 87, 95, 88, 93, 100, 103, 104, 101, 106, 110, 111, 113, 51, 24, 61, 68, 47, 64, 52, 50, 54, 18, 56, 70, 49, 48, 28, 66, 31, 30, 69, 41, 53, 36, 25, 26, 45, 109, 40, 63, 23, 67, 62);

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.value_id AS value_id_3,
  t0.variant_id AS variant_id_4
FROM
  shop_product_attribute t0

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.value_id AS value_id_3, t0.variant_id AS variant_id_4 FROM shop_product_attribute t0;

SELECT
  t0.receipt_style AS receipt_style_1,
  t0.product_id AS product_id_2
FROM
  hb_product_options t0

SELECT t0.receipt_style AS receipt_style_1, t0.product_id AS product_id_2 FROM hb_product_options t0;

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;

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 = 2812 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 = 2812 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 <> 2812) 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 = 2812) AND ((s0_.code = '' OR s0_.code IS NULL OR s1_.order_id IS NOT NULL)) AND ((s3_.id IS NULL OR s3_.id = 3584) 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 (3584)))) 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 = 2812;

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

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

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

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

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

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

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

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

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

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

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