Symfony Profiler

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.enabled AS enabled_3,
  t0.salt AS salt_4,
  t0.password AS password_5,
  t0.encoder_name AS encoder_name_6,
  t0.last_login AS last_login_7,
  t0.password_reset_token AS password_reset_token_8,
  t0.password_requested_at AS password_requested_at_9,
  t0.email_verification_token AS email_verification_token_10,
  t0.verified_at AS verified_at_11,
  t0.locked AS locked_12,
  t0.expires_at AS expires_at_13,
  t0.credentials_expire_at AS credentials_expire_at_14,
  t0.roles AS roles_15,
  t0.email AS email_16,
  t0.email_canonical AS email_canonical_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.id AS id_20,
  t0.plain_password_registered AS plain_password_registered_21,
  t22.id AS id_23,
  t22.first_name AS first_name_24,
  t22.last_name AS last_name_25,
  t22.email AS email_26,
  t22.phone_number AS phone_number_27,
  t22.job AS job_28,
  t22.image_name AS image_name_29,
  t22.updated_at AS updated_at_30,
  t22.user_id AS user_id_31,
  t32.id AS id_33,
  t32.first_name AS first_name_34,
  t32.last_name AS last_name_35,
  t32.email AS email_36,
  t32.phone_number AS phone_number_37,
  t32.job AS job_38,
  t32.image_name AS image_name_39,
  t32.updated_at AS updated_at_40,
  t32.user_id AS user_id_41,
  t32.establishment_id AS establishment_id_42,
  t0.user_type_id AS user_type_id_43,
  t44.id AS id_45,
  t44.first_name AS first_name_46,
  t44.last_name AS last_name_47,
  t44.email AS email_48,
  t44.phone_number AS phone_number_49,
  t44.company AS company_50,
  t44.siret AS siret_51,
  t44.image_name AS image_name_52,
  t44.updated_at AS updated_at_53,
  t44.user_id AS user_id_54,
  t0.customer_id AS customer_id_55
FROM
  sylius_shop_user t0
  LEFT JOIN admin_establishment t22 ON t22.user_id = t0.id
  LEFT JOIN collaborator t32 ON t32.user_id = t0.id
  LEFT JOIN parent_student t44 ON t44.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.enabled AS enabled_3, t0.salt AS salt_4, t0.password AS password_5, t0.encoder_name AS encoder_name_6, t0.last_login AS last_login_7, t0.password_reset_token AS password_reset_token_8, t0.password_requested_at AS password_requested_at_9, t0.email_verification_token AS email_verification_token_10, t0.verified_at AS verified_at_11, t0.locked AS locked_12, t0.expires_at AS expires_at_13, t0.credentials_expire_at AS credentials_expire_at_14, t0.roles AS roles_15, t0.email AS email_16, t0.email_canonical AS email_canonical_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.id AS id_20, t0.plain_password_registered AS plain_password_registered_21, t22.id AS id_23, t22.first_name AS first_name_24, t22.last_name AS last_name_25, t22.email AS email_26, t22.phone_number AS phone_number_27, t22.job AS job_28, t22.image_name AS image_name_29, t22.updated_at AS updated_at_30, t22.user_id AS user_id_31, t32.id AS id_33, t32.first_name AS first_name_34, t32.last_name AS last_name_35, t32.email AS email_36, t32.phone_number AS phone_number_37, t32.job AS job_38, t32.image_name AS image_name_39, t32.updated_at AS updated_at_40, t32.user_id AS user_id_41, t32.establishment_id AS establishment_id_42, t0.user_type_id AS user_type_id_43, t44.id AS id_45, t44.first_name AS first_name_46, t44.last_name AS last_name_47, t44.email AS email_48, t44.phone_number AS phone_number_49, t44.company AS company_50, t44.siret AS siret_51, t44.image_name AS image_name_52, t44.updated_at AS updated_at_53, t44.user_id AS user_id_54, t0.customer_id AS customer_id_55 FROM sylius_shop_user t0 LEFT JOIN admin_establishment t22 ON t22.user_id = t0.id LEFT JOIN collaborator t32 ON t32.user_id = t0.id LEFT JOIN parent_student t44 ON t44.user_id = t0.id WHERE t0.id = 35;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
WHERE
  t0.hostname = ?
  AND t0.enabled = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id WHERE t0.hostname = 'www.marentree-keepschool.com' AND t0.enabled = 1 ORDER BY t0.id ASC LIMIT 1;

SELECT
  COUNT(*)
FROM
  sylius_channel t0

SELECT COUNT(*) FROM sylius_channel t0;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9,
  t0.theme_name AS theme_name_10,
  t0.tax_calculation_strategy AS tax_calculation_strategy_11,
  t0.contact_email AS contact_email_12,
  t0.contact_phone_number AS contact_phone_number_13,
  t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14,
  t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15,
  t0.account_verification_required AS account_verification_required_16,
  t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17,
  t0.default_locale_id AS default_locale_id_18,
  t19.code AS code_20,
  t19.created_at AS created_at_21,
  t19.updated_at AS updated_at_22,
  t19.id AS id_23,
  t0.base_currency_id AS base_currency_id_24,
  t25.code AS code_26,
  t25.created_at AS created_at_27,
  t25.updated_at AS updated_at_28,
  t25.id AS id_29,
  t0.default_tax_zone_id AS default_tax_zone_id_30,
  t0.menu_taxon_id AS menu_taxon_id_31,
  t0.shop_billing_data_id AS shop_billing_data_id_32,
  t0.channel_price_history_config_id AS channel_price_history_config_id_33
FROM
  sylius_channel t0
  INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id
  INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9, t0.theme_name AS theme_name_10, t0.tax_calculation_strategy AS tax_calculation_strategy_11, t0.contact_email AS contact_email_12, t0.contact_phone_number AS contact_phone_number_13, t0.skipping_shipping_step_allowed AS skipping_shipping_step_allowed_14, t0.skipping_payment_step_allowed AS skipping_payment_step_allowed_15, t0.account_verification_required AS account_verification_required_16, t0.shipping_address_in_checkout_required AS shipping_address_in_checkout_required_17, t0.default_locale_id AS default_locale_id_18, t19.code AS code_20, t19.created_at AS created_at_21, t19.updated_at AS updated_at_22, t19.id AS id_23, t0.base_currency_id AS base_currency_id_24, t25.code AS code_26, t25.created_at AS created_at_27, t25.updated_at AS updated_at_28, t25.id AS id_29, t0.default_tax_zone_id AS default_tax_zone_id_30, t0.menu_taxon_id AS menu_taxon_id_31, t0.shop_billing_data_id AS shop_billing_data_id_32, t0.channel_price_history_config_id AS channel_price_history_config_id_33 FROM sylius_channel t0 INNER JOIN sylius_locale t19 ON t0.default_locale_id = t19.id INNER JOIN sylius_currency t25 ON t0.base_currency_id = t25.id LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4
FROM
  sylius_locale t0
  INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id
WHERE
  sylius_channel_locales.channel_id = ?

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.id AS id_4 FROM sylius_locale t0 INNER JOIN sylius_channel_locales ON t0.id = sylius_channel_locales.locale_id WHERE sylius_channel_locales.channel_id = 2;

SELECT
  c0_.id AS id_0,
  c0_.section AS section_1,
  c0_.file_path AS file_path_2
FROM
  custom_init_logo c1_
  INNER JOIN custom_logo c0_ ON c1_.id = c0_.init_logo_id
WHERE
  c0_.section = ?
ORDER BY
  c1_.id ASC

SELECT c0_.id AS id_0, c0_.section AS section_1, c0_.file_path AS file_path_2 FROM custom_init_logo c1_ INNER JOIN custom_logo c0_ ON c1_.id = c0_.init_logo_id WHERE c0_.section = 'logo_fo_header' ORDER BY c1_.id ASC;

SELECT
  c0_.id AS id_0,
  c0_.section AS section_1,
  c0_.file_path AS file_path_2
FROM
  custom_init_logo c1_
  INNER JOIN custom_logo c0_ ON c1_.id = c0_.init_logo_id
WHERE
  c0_.section = ?
ORDER BY
  c1_.id ASC

SELECT c0_.id AS id_0, c0_.section AS section_1, c0_.file_path AS file_path_2 FROM custom_init_logo c1_ INNER JOIN custom_logo c0_ ON c1_.id = c0_.init_logo_id WHERE c0_.section = 'logo_fo_footer' ORDER BY c1_.id ASC;

SELECT
  c0_.id AS id_0,
  c0_.section AS section_1,
  c0_.file_path AS file_path_2
FROM
  custom_init_logo c1_
  INNER JOIN custom_logo c0_ ON c1_.id = c0_.init_logo_id
WHERE
  c0_.section = ?
ORDER BY
  c1_.id ASC

SELECT c0_.id AS id_0, c0_.section AS section_1, c0_.file_path AS file_path_2 FROM custom_init_logo c1_ INNER JOIN custom_logo c0_ ON c1_.id = c0_.init_logo_id WHERE c0_.section = 'logo_bo' ORDER BY c1_.id ASC;

SELECT
  c0_.id AS id_0,
  c0_.section AS section_1,
  c0_.file_path AS file_path_2
FROM
  custom_init_logo c1_
  INNER JOIN custom_logo c0_ ON c1_.id = c0_.init_logo_id
WHERE
  c0_.section = ?
ORDER BY
  c1_.id ASC

SELECT c0_.id AS id_0, c0_.section AS section_1, c0_.file_path AS file_path_2 FROM custom_init_logo c1_ INNER JOIN custom_logo c0_ ON c1_.id = c0_.init_logo_id WHERE c0_.section = 'logo_login' ORDER BY c1_.id ASC;

SELECT
  t0.id AS id_1
FROM
  custom_pre_footer_init t0
LIMIT
  1

SELECT t0.id AS id_1 FROM custom_pre_footer_init t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title_bloc1 AS title_bloc1_2,
  t0.content_bloc1 AS content_bloc1_3,
  t0.title_bloc2 AS title_bloc2_4,
  t0.content_bloc2 AS content_bloc2_5,
  t0.title_bloc3 AS title_bloc3_6,
  t0.content_bloc3 AS content_bloc3_7,
  t0.title_bloc4 AS title_bloc4_8,
  t0.content_bloc4 AS content_bloc4_9,
  t0.contact_link AS contact_link_10,
  t0.need_help_link AS need_help_link_11,
  t0.legal_notice_link AS legal_notice_link_12
FROM
  custom_footer t0
LIMIT
  1

SELECT t0.id AS id_1, t0.title_bloc1 AS title_bloc1_2, t0.content_bloc1 AS content_bloc1_3, t0.title_bloc2 AS title_bloc2_4, t0.content_bloc2 AS content_bloc2_5, t0.title_bloc3 AS title_bloc3_6, t0.content_bloc3 AS content_bloc3_7, t0.title_bloc4 AS title_bloc4_8, t0.content_bloc4 AS content_bloc4_9, t0.contact_link AS contact_link_10, t0.need_help_link AS need_help_link_11, t0.legal_notice_link AS legal_notice_link_12 FROM custom_footer t0 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.subject_establishment_id AS subject_establishment_id_2,
  t0.requirement_id AS requirement_id_3
FROM
  requirement_subject t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.subject_establishment_id AS subject_establishment_id_2, t0.requirement_id AS requirement_id_3 FROM requirement_subject t0 WHERE t0.id = '1202';

SELECT
  s0_.id AS id_0,
  s0_.code AS code_1,
  s1_.locale AS locale_2,
  s1_.name AS name_3,
  s2_.path AS path_4,
  s1_.slug AS slug_5,
  s0_.average_rating AS average_rating_6,
  r3_.id AS id_7,
  (
    SELECT
      sum(r4_.quantity) AS sclr_9
    FROM
      requirement_subject_product r4_
    WHERE
      r4_.requirement_subject_id = r5_.id
      AND r4_.product_id = s0_.id
  ) AS sclr_8
FROM
  sylius_product s0_
  LEFT JOIN sylius_product_options s7_ ON s0_.id = s7_.product_id
  LEFT JOIN sylius_product_option s6_ ON s6_.id = s7_.option_id
  INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id
  INNER JOIN sylius_product_image s2_ ON s0_.id = s2_.owner_id
  INNER JOIN requirement_subject_product r3_ ON s0_.id = r3_.product_id
  INNER JOIN requirement_subject r5_ ON r3_.requirement_subject_id = r5_.id
WHERE
  (
    s0_.is_pack IS NULL
    OR s0_.is_pack = ?
  )
  AND s1_.locale = ?
  AND (
    s2_.owner_id = s0_.id
    AND s2_.type = ?
  )
  AND r5_.id = ?
GROUP BY
  s0_.id,
  s0_.code,
  s1_.locale,
  s1_.name,
  s1_.slug,
  s0_.average_rating

SELECT s0_.id AS id_0, s0_.code AS code_1, s1_.locale AS locale_2, s1_.name AS name_3, s2_.path AS path_4, s1_.slug AS slug_5, s0_.average_rating AS average_rating_6, r3_.id AS id_7, (SELECT sum(r4_.quantity) AS sclr_9 FROM requirement_subject_product r4_ WHERE r4_.requirement_subject_id = r5_.id AND r4_.product_id = s0_.id) AS sclr_8 FROM sylius_product s0_ LEFT JOIN sylius_product_options s7_ ON s0_.id = s7_.product_id LEFT JOIN sylius_product_option s6_ ON s6_.id = s7_.option_id INNER JOIN sylius_product_translation s1_ ON s0_.id = s1_.translatable_id INNER JOIN sylius_product_image s2_ ON s0_.id = s2_.owner_id INNER JOIN requirement_subject_product r3_ ON s0_.id = r3_.product_id INNER JOIN requirement_subject r5_ ON r3_.requirement_subject_id = r5_.id WHERE (s0_.is_pack IS NULL OR s0_.is_pack = 0) AND s1_.locale = 'fr_FR' AND (s2_.owner_id = s0_.id AND s2_.type = 'main') AND r5_.id = '1202' GROUP BY s0_.id, s0_.code, s1_.locale, s1_.name, s1_.slug, s0_.average_rating;

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.enabled AS enabled_4,
  t0.id AS id_5,
  t0.variant_selection_method AS variant_selection_method_6,
  t0.average_rating AS average_rating_7,
  t0.origin AS origin_8,
  t0.is_pack AS is_pack_9,
  t0.is_current_offer AS is_current_offer_10,
  t0.main_taxon_id AS main_taxon_id_11,
  t12.id AS id_13,
  t12.label AS label_14,
  t12.school_year AS school_year_15,
  t12.personalized_product_title AS personalized_product_title_16,
  t12.status_enum AS status_enum_17,
  t12.creation_date AS creation_date_18,
  t12.update_date AS update_date_19,
  t12.closing_date AS closing_date_20,
  t12.to_validate_date AS to_validate_date_21,
  t12.validated_date AS validated_date_22,
  t12.grade_establishment_id AS grade_establishment_id_23,
  t12.collaborator_id AS collaborator_id_24,
  t12.establishment_id AS establishment_id_25,
  t12.user_creator_id AS user_creator_id_26,
  t12.product_id AS product_id_27,
  t0.product_taxon_id AS product_taxon_id_28,
  t29.is_packed_product AS is_packed_product_30,
  t29.created_at AS created_at_31,
  t29.updated_at AS updated_at_32,
  t29.id AS id_33,
  t29.product_id AS product_id_34
FROM
  sylius_product t0
  LEFT JOIN requirement t12 ON t12.product_id = t0.id
  LEFT JOIN bitbag_product_bundle t29 ON t29.product_id = t0.id
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enabled AS enabled_4, t0.id AS id_5, t0.variant_selection_method AS variant_selection_method_6, t0.average_rating AS average_rating_7, t0.origin AS origin_8, t0.is_pack AS is_pack_9, t0.is_current_offer AS is_current_offer_10, t0.main_taxon_id AS main_taxon_id_11, t12.id AS id_13, t12.label AS label_14, t12.school_year AS school_year_15, t12.personalized_product_title AS personalized_product_title_16, t12.status_enum AS status_enum_17, t12.creation_date AS creation_date_18, t12.update_date AS update_date_19, t12.closing_date AS closing_date_20, t12.to_validate_date AS to_validate_date_21, t12.validated_date AS validated_date_22, t12.grade_establishment_id AS grade_establishment_id_23, t12.collaborator_id AS collaborator_id_24, t12.establishment_id AS establishment_id_25, t12.user_creator_id AS user_creator_id_26, t12.product_id AS product_id_27, t0.product_taxon_id AS product_taxon_id_28, t29.is_packed_product AS is_packed_product_30, t29.created_at AS created_at_31, t29.updated_at AS updated_at_32, t29.id AS id_33, t29.product_id AS product_id_34 FROM sylius_product t0 LEFT JOIN requirement t12 ON t12.product_id = t0.id LEFT JOIN bitbag_product_bundle t29 ON t29.product_id = t0.id WHERE t0.id = 69;

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.position AS position_4,
  t0.enabled AS enabled_5,
  t0.id AS id_6,
  t0.version AS version_7,
  t0.on_hold AS on_hold_8,
  t0.on_hand AS on_hand_9,
  t0.tracked AS tracked_10,
  t0.width AS width_11,
  t0.height AS height_12,
  t0.depth AS depth_13,
  t0.weight AS weight_14,
  t0.shipping_required AS shipping_required_15,
  t0.product_id AS product_id_16,
  t0.tax_category_id AS tax_category_id_17,
  t0.shipping_category_id AS shipping_category_id_18
FROM
  sylius_product_variant t0
WHERE
  t0.product_id = ?
  AND t0.enabled = ?
ORDER BY
  t0.position ASC,
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = 69 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.position AS position_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.id AS id_5,
  t0.is_filterable AS is_filterable_6
FROM
  sylius_product_option t0
  INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id
WHERE
  sylius_product_options.product_id = ?
ORDER BY
  t0.position ASC,
  t0.id ASC

SELECT t0.code AS code_1, t0.position AS position_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.id AS id_5, t0.is_filterable AS is_filterable_6 FROM sylius_product_option t0 INNER JOIN sylius_product_options ON t0.id = sylius_product_options.option_id WHERE sylius_product_options.product_id = 69 ORDER BY t0.position ASC, t0.id ASC;

SELECT
  t0.title AS title_1,
  t0.rating AS rating_2,
  t0.comment AS comment_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.id AS id_7,
  t0.product_id AS product_id_8,
  t0.author_id AS author_id_9
FROM
  sylius_product_review t0
WHERE
  t0.product_id = ?

SELECT t0.title AS title_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.product_id AS product_id_8, t0.author_id AS author_id_9 FROM sylius_product_review t0 WHERE t0.product_id = 69;

SELECT
  s0_.id AS id_0,
  sum(r1_.quantity) AS sclr_1
FROM
  requirement_subject_product r1_
  INNER JOIN sylius_product s0_ ON r1_.product_id = s0_.id
  INNER JOIN requirement_subject r2_ ON r1_.requirement_subject_id = r2_.id
WHERE
  s0_.id = ?
  AND (
    s0_.is_pack IS NULL
    OR s0_.is_pack = ?
  )
GROUP BY
  s0_.id

SELECT s0_.id AS id_0, sum(r1_.quantity) AS sclr_1 FROM requirement_subject_product r1_ INNER JOIN sylius_product s0_ ON r1_.product_id = s0_.id INNER JOIN requirement_subject r2_ ON r1_.requirement_subject_id = r2_.id WHERE s0_.id = 69 AND (s0_.is_pack IS NULL OR s0_.is_pack = 0) GROUP BY s0_.id;

SELECT
  t0.price AS price_1,
  t0.original_price AS original_price_2,
  t0.minimum_price AS minimum_price_3,
  t0.lowest_price_before_discount AS lowest_price_before_discount_4,
  t0.channel_code AS channel_code_5,
  t0.id AS id_6,
  t0.product_variant_id AS product_variant_id_7
FROM
  sylius_channel_pricing t0
WHERE
  t0.product_variant_id = ?
ORDER BY
  t0.id ASC

SELECT t0.price AS price_1, t0.original_price AS original_price_2, t0.minimum_price AS minimum_price_3, t0.lowest_price_before_discount AS lowest_price_before_discount_4, t0.channel_code AS channel_code_5, t0.id AS id_6, t0.product_variant_id AS product_variant_id_7 FROM sylius_channel_pricing t0 WHERE t0.product_variant_id = 64 ORDER BY t0.id ASC;

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.enabled AS enabled_4,
  t0.id AS id_5,
  t0.variant_selection_method AS variant_selection_method_6,
  t0.average_rating AS average_rating_7,
  t0.origin AS origin_8,
  t0.is_pack AS is_pack_9,
  t0.is_current_offer AS is_current_offer_10,
  t0.main_taxon_id AS main_taxon_id_11,
  t12.id AS id_13,
  t12.label AS label_14,
  t12.school_year AS school_year_15,
  t12.personalized_product_title AS personalized_product_title_16,
  t12.status_enum AS status_enum_17,
  t12.creation_date AS creation_date_18,
  t12.update_date AS update_date_19,
  t12.closing_date AS closing_date_20,
  t12.to_validate_date AS to_validate_date_21,
  t12.validated_date AS validated_date_22,
  t12.grade_establishment_id AS grade_establishment_id_23,
  t12.collaborator_id AS collaborator_id_24,
  t12.establishment_id AS establishment_id_25,
  t12.user_creator_id AS user_creator_id_26,
  t12.product_id AS product_id_27,
  t0.product_taxon_id AS product_taxon_id_28,
  t29.is_packed_product AS is_packed_product_30,
  t29.created_at AS created_at_31,
  t29.updated_at AS updated_at_32,
  t29.id AS id_33,
  t29.product_id AS product_id_34
FROM
  sylius_product t0
  LEFT JOIN requirement t12 ON t12.product_id = t0.id
  LEFT JOIN bitbag_product_bundle t29 ON t29.product_id = t0.id
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.enabled AS enabled_4, t0.id AS id_5, t0.variant_selection_method AS variant_selection_method_6, t0.average_rating AS average_rating_7, t0.origin AS origin_8, t0.is_pack AS is_pack_9, t0.is_current_offer AS is_current_offer_10, t0.main_taxon_id AS main_taxon_id_11, t12.id AS id_13, t12.label AS label_14, t12.school_year AS school_year_15, t12.personalized_product_title AS personalized_product_title_16, t12.status_enum AS status_enum_17, t12.creation_date AS creation_date_18, t12.update_date AS update_date_19, t12.closing_date AS closing_date_20, t12.to_validate_date AS to_validate_date_21, t12.validated_date AS validated_date_22, t12.grade_establishment_id AS grade_establishment_id_23, t12.collaborator_id AS collaborator_id_24, t12.establishment_id AS establishment_id_25, t12.user_creator_id AS user_creator_id_26, t12.product_id AS product_id_27, t0.product_taxon_id AS product_taxon_id_28, t29.is_packed_product AS is_packed_product_30, t29.created_at AS created_at_31, t29.updated_at AS updated_at_32, t29.id AS id_33, t29.product_id AS product_id_34 FROM sylius_product t0 LEFT JOIN requirement t12 ON t12.product_id = t0.id LEFT JOIN bitbag_product_bundle t29 ON t29.product_id = t0.id WHERE t0.id = 73;

SELECT
  t0.code AS code_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.position AS position_4,
  t0.enabled AS enabled_5,
  t0.id AS id_6,
  t0.version AS version_7,
  t0.on_hold AS on_hold_8,
  t0.on_hand AS on_hand_9,
  t0.tracked AS tracked_10,
  t0.width AS width_11,
  t0.height AS height_12,
  t0.depth AS depth_13,
  t0.weight AS weight_14,
  t0.shipping_required AS shipping_required_15,
  t0.product_id AS product_id_16,
  t0.tax_category_id AS tax_category_id_17,
  t0.shipping_category_id AS shipping_category_id_18
FROM
  sylius_product_variant t0
WHERE
  t0.product_id = ?
  AND t0.enabled = ?
ORDER BY
  t0.position ASC,
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.position AS position_4, t0.enabled AS enabled_5, t0.id AS id_6, t0.version AS version_7, t0.on_hold AS on_hold_8, t0.on_hand AS on_hand_9, t0.tracked AS tracked_10, t0.width AS width_11, t0.height AS height_12, t0.depth AS depth_13, t0.weight AS weight_14, t0.shipping_required AS shipping_required_15, t0.product_id AS product_id_16, t0.tax_category_id AS tax_category_id_17, t0.shipping_category_id AS shipping_category_id_18 FROM sylius_product_variant t0 WHERE t0.product_id = 73 AND t0.enabled = 1 ORDER BY t0.position ASC, t0.id ASC LIMIT 1;