Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  price_groups t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0;

SELECT
  t0.customers_id AS customers_id_1,
  t0.purchased_without_account AS purchased_without_account_2,
  t0.customers_gender AS customers_gender_3,
  t0.customers_firstname AS customers_firstname_4,
  t0.customers_lastname AS customers_lastname_5,
  t0.customers_dob AS customers_dob_6,
  t0.customers_email_address AS customers_email_address_7,
  t0.customers_telephone AS customers_telephone_8,
  t0.customers_fax AS customers_fax_9,
  t0.customers_tva AS customers_tva_10,
  t0.customers_siret AS customers_siret_11,
  t0.customers_elevage AS customers_elevage_12,
  t0.customers_affixe AS customers_affixe_13,
  t0.customers_password AS customers_password_14,
  t0.customers_newsletter AS customers_newsletter_15,
  t0.customers_selected_template AS customers_selected_template_16,
  t0.customers_group_ra AS customers_group_ra_17,
  t0.customers_payment_allowed AS customers_payment_allowed_18,
  t0.customers_shipment_allowed AS customers_shipment_allowed_19,
  t0.customers_validation_code AS customers_validation_code_20,
  t0.customers_validation AS customers_validation_21,
  t0.customers_email_registered AS customers_email_registered_22,
  t0.customers_sage AS customers_sage_23,
  t0.customers_sap_id AS customers_sap_id_24,
  t0.customers_company AS customers_company_25,
  t0.customers_referent AS customers_referent_26,
  t0.customers_metier AS customers_metier_27,
  t0.customers_metier_sap AS customers_metier_sap_28,
  t0.customers_autreprecisez AS customers_autreprecisez_29,
  t0.customers_pai_differe AS customers_pai_differe_30,
  t0.customers_exclu_TVA AS customers_exclu_TVA_31,
  t0.customers_invoice_type AS customers_invoice_type_32,
  t0.customers_last_login AS customers_last_login_33,
  t0.customers_creation AS customers_creation_34,
  t0.customers_nblogin AS customers_nblogin_35,
  t0.customers_account_update AS customers_account_update_36,
  t0.customers_status AS customers_status_37,
  t0.customers_expert AS customers_expert_38,
  t0.customers_expert_id AS customers_expert_id_39,
  t0.customers_consent_ad_products AS customers_consent_ad_products_40,
  t0.customers_consent_ad_others AS customers_consent_ad_others_41,
  t0.customers_consent_group AS customers_consent_group_42,
  t0.customers_default_address_id AS customers_default_address_id_43,
  t0.languages_id AS languages_id_44,
  t0.customers_group_id AS customers_group_id_45
FROM
  customers t0
WHERE
  t0.customers_id = ?

SELECT t0.customers_id AS customers_id_1, t0.purchased_without_account AS purchased_without_account_2, t0.customers_gender AS customers_gender_3, t0.customers_firstname AS customers_firstname_4, t0.customers_lastname AS customers_lastname_5, t0.customers_dob AS customers_dob_6, t0.customers_email_address AS customers_email_address_7, t0.customers_telephone AS customers_telephone_8, t0.customers_fax AS customers_fax_9, t0.customers_tva AS customers_tva_10, t0.customers_siret AS customers_siret_11, t0.customers_elevage AS customers_elevage_12, t0.customers_affixe AS customers_affixe_13, t0.customers_password AS customers_password_14, t0.customers_newsletter AS customers_newsletter_15, t0.customers_selected_template AS customers_selected_template_16, t0.customers_group_ra AS customers_group_ra_17, t0.customers_payment_allowed AS customers_payment_allowed_18, t0.customers_shipment_allowed AS customers_shipment_allowed_19, t0.customers_validation_code AS customers_validation_code_20, t0.customers_validation AS customers_validation_21, t0.customers_email_registered AS customers_email_registered_22, t0.customers_sage AS customers_sage_23, t0.customers_sap_id AS customers_sap_id_24, t0.customers_company AS customers_company_25, t0.customers_referent AS customers_referent_26, t0.customers_metier AS customers_metier_27, t0.customers_metier_sap AS customers_metier_sap_28, t0.customers_autreprecisez AS customers_autreprecisez_29, t0.customers_pai_differe AS customers_pai_differe_30, t0.customers_exclu_TVA AS customers_exclu_TVA_31, t0.customers_invoice_type AS customers_invoice_type_32, t0.customers_last_login AS customers_last_login_33, t0.customers_creation AS customers_creation_34, t0.customers_nblogin AS customers_nblogin_35, t0.customers_account_update AS customers_account_update_36, t0.customers_status AS customers_status_37, t0.customers_expert AS customers_expert_38, t0.customers_expert_id AS customers_expert_id_39, t0.customers_consent_ad_products AS customers_consent_ad_products_40, t0.customers_consent_ad_others AS customers_consent_ad_others_41, t0.customers_consent_group AS customers_consent_group_42, t0.customers_default_address_id AS customers_default_address_id_43, t0.languages_id AS languages_id_44, t0.customers_group_id AS customers_group_id_45 FROM customers t0 WHERE t0.customers_id = 39158;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  price_groups t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = 'VV' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.shipping_infos AS shipping_infos_2,
  t0.comment AS comment_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.customer_id AS customer_id_6,
  t0.price_group_id AS price_group_id_7,
  t0.shipping_address_id AS shipping_address_id_8,
  t0.billing_address_id AS billing_address_id_9,
  t0.carrier_id AS carrier_id_10,
  t0.payment_mean_id AS payment_mean_id_11
FROM
  carts t0
WHERE
  t0.customer_id = ?
  AND t0.price_group_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.shipping_infos AS shipping_infos_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.customer_id AS customer_id_6, t0.price_group_id AS price_group_id_7, t0.shipping_address_id AS shipping_address_id_8, t0.billing_address_id AS billing_address_id_9, t0.carrier_id AS carrier_id_10, t0.payment_mean_id AS payment_mean_id_11 FROM carts t0 WHERE t0.customer_id = 39158 AND t0.price_group_id = 1 LIMIT 1;

SELECT
  t0.address_book_id AS address_book_id_1,
  t0.entry_gender AS entry_gender_2,
  t0.entry_company AS entry_company_3,
  t0.entry_company_tax_id AS entry_company_tax_id_4,
  t0.entry_firstname AS entry_firstname_5,
  t0.entry_lastname AS entry_lastname_6,
  t0.entry_street_address AS entry_street_address_7,
  t0.entry_suburb AS entry_suburb_8,
  t0.entry_postcode AS entry_postcode_9,
  t0.entry_city AS entry_city_10,
  t0.entry_state AS entry_state_11,
  t0.entry_phone AS entry_phone_12,
  t0.entry_email AS entry_email_13,
  t0.entry_zone_id AS entry_zone_id_14,
  t0.customers_id AS customers_id_15,
  t0.entry_country_id AS entry_country_id_16
FROM
  address_book t0
WHERE
  t0.address_book_id = ?

SELECT t0.address_book_id AS address_book_id_1, t0.entry_gender AS entry_gender_2, t0.entry_company AS entry_company_3, t0.entry_company_tax_id AS entry_company_tax_id_4, t0.entry_firstname AS entry_firstname_5, t0.entry_lastname AS entry_lastname_6, t0.entry_street_address AS entry_street_address_7, t0.entry_suburb AS entry_suburb_8, t0.entry_postcode AS entry_postcode_9, t0.entry_city AS entry_city_10, t0.entry_state AS entry_state_11, t0.entry_phone AS entry_phone_12, t0.entry_email AS entry_email_13, t0.entry_zone_id AS entry_zone_id_14, t0.customers_id AS customers_id_15, t0.entry_country_id AS entry_country_id_16 FROM address_book t0 WHERE t0.address_book_id = 74240;

SELECT
  t0.id AS id_1,
  t0.from_cart_amount AS from_cart_amount_2,
  t0.price AS price_3,
  t0.carrier_id AS carrier_id_4,
  t0.countries_id AS countries_id_5
FROM
  shipping_rates t0
WHERE
  t0.countries_id = ?

SELECT t0.id AS id_1, t0.from_cart_amount AS from_cart_amount_2, t0.price AS price_3, t0.carrier_id AS carrier_id_4, t0.countries_id AS countries_id_5 FROM shipping_rates t0 WHERE t0.countries_id = 73;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.final_price AS final_price_3,
  t0.total_price AS total_price_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.cart_id AS cart_id_7,
  t0.product_id AS product_id_8
FROM
  carts_items t0
WHERE
  t0.cart_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.final_price AS final_price_3, t0.total_price AS total_price_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.cart_id AS cart_id_7, t0.product_id AS product_id_8 FROM carts_items t0 WHERE t0.cart_id = 24377;

SELECT
  t0.products_id AS products_id_1,
  t0.products_quantity AS products_quantity_2,
  t0.products_model AS products_model_3,
  t0.products_model_sap AS products_model_sap_4,
  t0.products_ean AS products_ean_5,
  t0.products_image AS products_image_6,
  t0.products_image_med AS products_image_med_7,
  t0.products_image_lrg AS products_image_lrg_8,
  t0.products_image_sm_1 AS products_image_sm_1_9,
  t0.products_image_xl_1 AS products_image_xl_1_10,
  t0.products_image_sm_2 AS products_image_sm_2_11,
  t0.products_image_xl_2 AS products_image_xl_2_12,
  t0.products_image_sm_3 AS products_image_sm_3_13,
  t0.products_image_xl_3 AS products_image_xl_3_14,
  t0.products_image_sm_4 AS products_image_sm_4_15,
  t0.products_image_xl_4 AS products_image_xl_4_16,
  t0.products_image_sm_5 AS products_image_sm_5_17,
  t0.products_image_xl_5 AS products_image_xl_5_18,
  t0.products_image_sm_6 AS products_image_sm_6_19,
  t0.products_image_xl_6 AS products_image_xl_6_20,
  t0.products_price AS products_price_21,
  t0.products_ecotax AS products_ecotax_22,
  t0.products_date_added AS products_date_added_23,
  t0.products_last_modified AS products_last_modified_24,
  t0.products_date_available AS products_date_available_25,
  t0.products_weight AS products_weight_26,
  t0.products_status AS products_status_27,
  t0.products_ordered AS products_ordered_28,
  t0.products_price1 AS products_price1_29,
  t0.products_price2 AS products_price2_30,
  t0.products_price3 AS products_price3_31,
  t0.products_price4 AS products_price4_32,
  t0.products_price5 AS products_price5_33,
  t0.products_price6 AS products_price6_34,
  t0.products_price7 AS products_price7_35,
  t0.products_price8 AS products_price8_36,
  t0.products_price9 AS products_price9_37,
  t0.products_price10 AS products_price10_38,
  t0.products_price11 AS products_price11_39,
  t0.products_price1_qty AS products_price1_qty_40,
  t0.products_price2_qty AS products_price2_qty_41,
  t0.products_price3_qty AS products_price3_qty_42,
  t0.products_price4_qty AS products_price4_qty_43,
  t0.products_price5_qty AS products_price5_qty_44,
  t0.products_price6_qty AS products_price6_qty_45,
  t0.products_price7_qty AS products_price7_qty_46,
  t0.products_price8_qty AS products_price8_qty_47,
  t0.products_price9_qty AS products_price9_qty_48,
  t0.products_price10_qty AS products_price10_qty_49,
  t0.products_price11_qty AS products_price11_qty_50,
  t0.products_qty_blocks AS products_qty_blocks_51,
  t0.products_soleil AS products_soleil_52,
  t0.products_limite_panier AS products_limite_panier_53,
  t0.products_page AS products_page_54,
  t0.products_garantie AS products_garantie_55,
  t0.products_cat AS products_cat_56,
  t0.products_index AS products_index_57,
  t0.products_mvente AS products_mvente_58,
  t0.products_strategique AS products_strategique_59,
  t0.products_reappro_non AS products_reappro_non_60,
  t0.products_multiple AS products_multiple_61,
  t0.products_origin AS products_origin_62,
  t0.products_gift AS products_gift_63,
  t0.products_type AS products_type_64,
  t0.products_welcome AS products_welcome_65,
  t0.products_code AS products_code_66,
  t0.is_default_variant AS is_default_variant_67,
  t0.products_parent_id AS products_parent_id_68,
  t0.products_model_id AS products_model_id_69,
  t0.manufacturers_id AS manufacturers_id_70,
  t0.products_tax_class_id AS products_tax_class_id_71
FROM
  products t0
WHERE
  t0.products_id = ?

SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.products_code AS products_code_66, t0.is_default_variant AS is_default_variant_67, t0.products_parent_id AS products_parent_id_68, t0.products_model_id AS products_model_id_69, t0.manufacturers_id AS manufacturers_id_70, t0.products_tax_class_id AS products_tax_class_id_71 FROM products t0 WHERE t0.products_id = 20645;

SELECT
  t0.products_id AS products_id_1,
  t0.products_quantity AS products_quantity_2,
  t0.products_model AS products_model_3,
  t0.products_model_sap AS products_model_sap_4,
  t0.products_ean AS products_ean_5,
  t0.products_image AS products_image_6,
  t0.products_image_med AS products_image_med_7,
  t0.products_image_lrg AS products_image_lrg_8,
  t0.products_image_sm_1 AS products_image_sm_1_9,
  t0.products_image_xl_1 AS products_image_xl_1_10,
  t0.products_image_sm_2 AS products_image_sm_2_11,
  t0.products_image_xl_2 AS products_image_xl_2_12,
  t0.products_image_sm_3 AS products_image_sm_3_13,
  t0.products_image_xl_3 AS products_image_xl_3_14,
  t0.products_image_sm_4 AS products_image_sm_4_15,
  t0.products_image_xl_4 AS products_image_xl_4_16,
  t0.products_image_sm_5 AS products_image_sm_5_17,
  t0.products_image_xl_5 AS products_image_xl_5_18,
  t0.products_image_sm_6 AS products_image_sm_6_19,
  t0.products_image_xl_6 AS products_image_xl_6_20,
  t0.products_price AS products_price_21,
  t0.products_ecotax AS products_ecotax_22,
  t0.products_date_added AS products_date_added_23,
  t0.products_last_modified AS products_last_modified_24,
  t0.products_date_available AS products_date_available_25,
  t0.products_weight AS products_weight_26,
  t0.products_status AS products_status_27,
  t0.products_ordered AS products_ordered_28,
  t0.products_price1 AS products_price1_29,
  t0.products_price2 AS products_price2_30,
  t0.products_price3 AS products_price3_31,
  t0.products_price4 AS products_price4_32,
  t0.products_price5 AS products_price5_33,
  t0.products_price6 AS products_price6_34,
  t0.products_price7 AS products_price7_35,
  t0.products_price8 AS products_price8_36,
  t0.products_price9 AS products_price9_37,
  t0.products_price10 AS products_price10_38,
  t0.products_price11 AS products_price11_39,
  t0.products_price1_qty AS products_price1_qty_40,
  t0.products_price2_qty AS products_price2_qty_41,
  t0.products_price3_qty AS products_price3_qty_42,
  t0.products_price4_qty AS products_price4_qty_43,
  t0.products_price5_qty AS products_price5_qty_44,
  t0.products_price6_qty AS products_price6_qty_45,
  t0.products_price7_qty AS products_price7_qty_46,
  t0.products_price8_qty AS products_price8_qty_47,
  t0.products_price9_qty AS products_price9_qty_48,
  t0.products_price10_qty AS products_price10_qty_49,
  t0.products_price11_qty AS products_price11_qty_50,
  t0.products_qty_blocks AS products_qty_blocks_51,
  t0.products_soleil AS products_soleil_52,
  t0.products_limite_panier AS products_limite_panier_53,
  t0.products_page AS products_page_54,
  t0.products_garantie AS products_garantie_55,
  t0.products_cat AS products_cat_56,
  t0.products_index AS products_index_57,
  t0.products_mvente AS products_mvente_58,
  t0.products_strategique AS products_strategique_59,
  t0.products_reappro_non AS products_reappro_non_60,
  t0.products_multiple AS products_multiple_61,
  t0.products_origin AS products_origin_62,
  t0.products_gift AS products_gift_63,
  t0.products_type AS products_type_64,
  t0.products_welcome AS products_welcome_65,
  t0.products_code AS products_code_66,
  t0.is_default_variant AS is_default_variant_67,
  t0.products_parent_id AS products_parent_id_68,
  t0.products_model_id AS products_model_id_69,
  t0.manufacturers_id AS manufacturers_id_70,
  t0.products_tax_class_id AS products_tax_class_id_71
FROM
  products t0
WHERE
  t0.products_id = ?

SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.products_code AS products_code_66, t0.is_default_variant AS is_default_variant_67, t0.products_parent_id AS products_parent_id_68, t0.products_model_id AS products_model_id_69, t0.manufacturers_id AS manufacturers_id_70, t0.products_tax_class_id AS products_tax_class_id_71 FROM products t0 WHERE t0.products_id = 20641;

SELECT
  t0.products_id AS products_id_1,
  t0.products_quantity AS products_quantity_2,
  t0.products_model AS products_model_3,
  t0.products_model_sap AS products_model_sap_4,
  t0.products_ean AS products_ean_5,
  t0.products_image AS products_image_6,
  t0.products_image_med AS products_image_med_7,
  t0.products_image_lrg AS products_image_lrg_8,
  t0.products_image_sm_1 AS products_image_sm_1_9,
  t0.products_image_xl_1 AS products_image_xl_1_10,
  t0.products_image_sm_2 AS products_image_sm_2_11,
  t0.products_image_xl_2 AS products_image_xl_2_12,
  t0.products_image_sm_3 AS products_image_sm_3_13,
  t0.products_image_xl_3 AS products_image_xl_3_14,
  t0.products_image_sm_4 AS products_image_sm_4_15,
  t0.products_image_xl_4 AS products_image_xl_4_16,
  t0.products_image_sm_5 AS products_image_sm_5_17,
  t0.products_image_xl_5 AS products_image_xl_5_18,
  t0.products_image_sm_6 AS products_image_sm_6_19,
  t0.products_image_xl_6 AS products_image_xl_6_20,
  t0.products_price AS products_price_21,
  t0.products_ecotax AS products_ecotax_22,
  t0.products_date_added AS products_date_added_23,
  t0.products_last_modified AS products_last_modified_24,
  t0.products_date_available AS products_date_available_25,
  t0.products_weight AS products_weight_26,
  t0.products_status AS products_status_27,
  t0.products_ordered AS products_ordered_28,
  t0.products_price1 AS products_price1_29,
  t0.products_price2 AS products_price2_30,
  t0.products_price3 AS products_price3_31,
  t0.products_price4 AS products_price4_32,
  t0.products_price5 AS products_price5_33,
  t0.products_price6 AS products_price6_34,
  t0.products_price7 AS products_price7_35,
  t0.products_price8 AS products_price8_36,
  t0.products_price9 AS products_price9_37,
  t0.products_price10 AS products_price10_38,
  t0.products_price11 AS products_price11_39,
  t0.products_price1_qty AS products_price1_qty_40,
  t0.products_price2_qty AS products_price2_qty_41,
  t0.products_price3_qty AS products_price3_qty_42,
  t0.products_price4_qty AS products_price4_qty_43,
  t0.products_price5_qty AS products_price5_qty_44,
  t0.products_price6_qty AS products_price6_qty_45,
  t0.products_price7_qty AS products_price7_qty_46,
  t0.products_price8_qty AS products_price8_qty_47,
  t0.products_price9_qty AS products_price9_qty_48,
  t0.products_price10_qty AS products_price10_qty_49,
  t0.products_price11_qty AS products_price11_qty_50,
  t0.products_qty_blocks AS products_qty_blocks_51,
  t0.products_soleil AS products_soleil_52,
  t0.products_limite_panier AS products_limite_panier_53,
  t0.products_page AS products_page_54,
  t0.products_garantie AS products_garantie_55,
  t0.products_cat AS products_cat_56,
  t0.products_index AS products_index_57,
  t0.products_mvente AS products_mvente_58,
  t0.products_strategique AS products_strategique_59,
  t0.products_reappro_non AS products_reappro_non_60,
  t0.products_multiple AS products_multiple_61,
  t0.products_origin AS products_origin_62,
  t0.products_gift AS products_gift_63,
  t0.products_type AS products_type_64,
  t0.products_welcome AS products_welcome_65,
  t0.products_code AS products_code_66,
  t0.is_default_variant AS is_default_variant_67,
  t0.products_parent_id AS products_parent_id_68,
  t0.products_model_id AS products_model_id_69,
  t0.manufacturers_id AS manufacturers_id_70,
  t0.products_tax_class_id AS products_tax_class_id_71
FROM
  products t0
WHERE
  t0.products_id = ?

SELECT t0.products_id AS products_id_1, t0.products_quantity AS products_quantity_2, t0.products_model AS products_model_3, t0.products_model_sap AS products_model_sap_4, t0.products_ean AS products_ean_5, t0.products_image AS products_image_6, t0.products_image_med AS products_image_med_7, t0.products_image_lrg AS products_image_lrg_8, t0.products_image_sm_1 AS products_image_sm_1_9, t0.products_image_xl_1 AS products_image_xl_1_10, t0.products_image_sm_2 AS products_image_sm_2_11, t0.products_image_xl_2 AS products_image_xl_2_12, t0.products_image_sm_3 AS products_image_sm_3_13, t0.products_image_xl_3 AS products_image_xl_3_14, t0.products_image_sm_4 AS products_image_sm_4_15, t0.products_image_xl_4 AS products_image_xl_4_16, t0.products_image_sm_5 AS products_image_sm_5_17, t0.products_image_xl_5 AS products_image_xl_5_18, t0.products_image_sm_6 AS products_image_sm_6_19, t0.products_image_xl_6 AS products_image_xl_6_20, t0.products_price AS products_price_21, t0.products_ecotax AS products_ecotax_22, t0.products_date_added AS products_date_added_23, t0.products_last_modified AS products_last_modified_24, t0.products_date_available AS products_date_available_25, t0.products_weight AS products_weight_26, t0.products_status AS products_status_27, t0.products_ordered AS products_ordered_28, t0.products_price1 AS products_price1_29, t0.products_price2 AS products_price2_30, t0.products_price3 AS products_price3_31, t0.products_price4 AS products_price4_32, t0.products_price5 AS products_price5_33, t0.products_price6 AS products_price6_34, t0.products_price7 AS products_price7_35, t0.products_price8 AS products_price8_36, t0.products_price9 AS products_price9_37, t0.products_price10 AS products_price10_38, t0.products_price11 AS products_price11_39, t0.products_price1_qty AS products_price1_qty_40, t0.products_price2_qty AS products_price2_qty_41, t0.products_price3_qty AS products_price3_qty_42, t0.products_price4_qty AS products_price4_qty_43, t0.products_price5_qty AS products_price5_qty_44, t0.products_price6_qty AS products_price6_qty_45, t0.products_price7_qty AS products_price7_qty_46, t0.products_price8_qty AS products_price8_qty_47, t0.products_price9_qty AS products_price9_qty_48, t0.products_price10_qty AS products_price10_qty_49, t0.products_price11_qty AS products_price11_qty_50, t0.products_qty_blocks AS products_qty_blocks_51, t0.products_soleil AS products_soleil_52, t0.products_limite_panier AS products_limite_panier_53, t0.products_page AS products_page_54, t0.products_garantie AS products_garantie_55, t0.products_cat AS products_cat_56, t0.products_index AS products_index_57, t0.products_mvente AS products_mvente_58, t0.products_strategique AS products_strategique_59, t0.products_reappro_non AS products_reappro_non_60, t0.products_multiple AS products_multiple_61, t0.products_origin AS products_origin_62, t0.products_gift AS products_gift_63, t0.products_type AS products_type_64, t0.products_welcome AS products_welcome_65, t0.products_code AS products_code_66, t0.is_default_variant AS is_default_variant_67, t0.products_parent_id AS products_parent_id_68, t0.products_model_id AS products_model_id_69, t0.manufacturers_id AS manufacturers_id_70, t0.products_tax_class_id AS products_tax_class_id_71 FROM products t0 WHERE t0.products_id = 20644;

SELECT
  p0_.products_id AS products_id_0,
  p0_.products_quantity AS products_quantity_1,
  p0_.products_model AS products_model_2,
  p0_.products_model_sap AS products_model_sap_3,
  p0_.products_ean AS products_ean_4,
  p0_.products_image AS products_image_5,
  p0_.products_image_med AS products_image_med_6,
  p0_.products_image_lrg AS products_image_lrg_7,
  p0_.products_image_sm_1 AS products_image_sm_1_8,
  p0_.products_image_xl_1 AS products_image_xl_1_9,
  p0_.products_image_sm_2 AS products_image_sm_2_10,
  p0_.products_image_xl_2 AS products_image_xl_2_11,
  p0_.products_image_sm_3 AS products_image_sm_3_12,
  p0_.products_image_xl_3 AS products_image_xl_3_13,
  p0_.products_image_sm_4 AS products_image_sm_4_14,
  p0_.products_image_xl_4 AS products_image_xl_4_15,
  p0_.products_image_sm_5 AS products_image_sm_5_16,
  p0_.products_image_xl_5 AS products_image_xl_5_17,
  p0_.products_image_sm_6 AS products_image_sm_6_18,
  p0_.products_image_xl_6 AS products_image_xl_6_19,
  p0_.products_price AS products_price_20,
  p0_.products_ecotax AS products_ecotax_21,
  p0_.products_date_added AS products_date_added_22,
  p0_.products_last_modified AS products_last_modified_23,
  p0_.products_date_available AS products_date_available_24,
  p0_.products_weight AS products_weight_25,
  p0_.products_status AS products_status_26,
  p0_.products_ordered AS products_ordered_27,
  p0_.products_price1 AS products_price1_28,
  p0_.products_price2 AS products_price2_29,
  p0_.products_price3 AS products_price3_30,
  p0_.products_price4 AS products_price4_31,
  p0_.products_price5 AS products_price5_32,
  p0_.products_price6 AS products_price6_33,
  p0_.products_price7 AS products_price7_34,
  p0_.products_price8 AS products_price8_35,
  p0_.products_price9 AS products_price9_36,
  p0_.products_price10 AS products_price10_37,
  p0_.products_price11 AS products_price11_38,
  p0_.products_price1_qty AS products_price1_qty_39,
  p0_.products_price2_qty AS products_price2_qty_40,
  p0_.products_price3_qty AS products_price3_qty_41,
  p0_.products_price4_qty AS products_price4_qty_42,
  p0_.products_price5_qty AS products_price5_qty_43,
  p0_.products_price6_qty AS products_price6_qty_44,
  p0_.products_price7_qty AS products_price7_qty_45,
  p0_.products_price8_qty AS products_price8_qty_46,
  p0_.products_price9_qty AS products_price9_qty_47,
  p0_.products_price10_qty AS products_price10_qty_48,
  p0_.products_price11_qty AS products_price11_qty_49,
  p0_.products_qty_blocks AS products_qty_blocks_50,
  p0_.products_soleil AS products_soleil_51,
  p0_.products_limite_panier AS products_limite_panier_52,
  p0_.products_page AS products_page_53,
  p0_.products_garantie AS products_garantie_54,
  p0_.products_cat AS products_cat_55,
  p0_.products_index AS products_index_56,
  p0_.products_mvente AS products_mvente_57,
  p0_.products_strategique AS products_strategique_58,
  p0_.products_reappro_non AS products_reappro_non_59,
  p0_.products_multiple AS products_multiple_60,
  p0_.products_origin AS products_origin_61,
  p0_.products_gift AS products_gift_62,
  p0_.products_type AS products_type_63,
  p0_.products_welcome AS products_welcome_64,
  p0_.products_code AS products_code_65,
  p0_.is_default_variant AS is_default_variant_66,
  p0_.products_parent_id AS products_parent_id_67,
  p0_.products_model_id AS products_model_id_68,
  p0_.manufacturers_id AS manufacturers_id_69,
  p0_.products_tax_class_id AS products_tax_class_id_70
FROM
  products p0_
WHERE
  p0_.products_status = 1
  AND p0_.products_gift = 1

SELECT p0_.products_id AS products_id_0, p0_.products_quantity AS products_quantity_1, p0_.products_model AS products_model_2, p0_.products_model_sap AS products_model_sap_3, p0_.products_ean AS products_ean_4, p0_.products_image AS products_image_5, p0_.products_image_med AS products_image_med_6, p0_.products_image_lrg AS products_image_lrg_7, p0_.products_image_sm_1 AS products_image_sm_1_8, p0_.products_image_xl_1 AS products_image_xl_1_9, p0_.products_image_sm_2 AS products_image_sm_2_10, p0_.products_image_xl_2 AS products_image_xl_2_11, p0_.products_image_sm_3 AS products_image_sm_3_12, p0_.products_image_xl_3 AS products_image_xl_3_13, p0_.products_image_sm_4 AS products_image_sm_4_14, p0_.products_image_xl_4 AS products_image_xl_4_15, p0_.products_image_sm_5 AS products_image_sm_5_16, p0_.products_image_xl_5 AS products_image_xl_5_17, p0_.products_image_sm_6 AS products_image_sm_6_18, p0_.products_image_xl_6 AS products_image_xl_6_19, p0_.products_price AS products_price_20, p0_.products_ecotax AS products_ecotax_21, p0_.products_date_added AS products_date_added_22, p0_.products_last_modified AS products_last_modified_23, p0_.products_date_available AS products_date_available_24, p0_.products_weight AS products_weight_25, p0_.products_status AS products_status_26, p0_.products_ordered AS products_ordered_27, p0_.products_price1 AS products_price1_28, p0_.products_price2 AS products_price2_29, p0_.products_price3 AS products_price3_30, p0_.products_price4 AS products_price4_31, p0_.products_price5 AS products_price5_32, p0_.products_price6 AS products_price6_33, p0_.products_price7 AS products_price7_34, p0_.products_price8 AS products_price8_35, p0_.products_price9 AS products_price9_36, p0_.products_price10 AS products_price10_37, p0_.products_price11 AS products_price11_38, p0_.products_price1_qty AS products_price1_qty_39, p0_.products_price2_qty AS products_price2_qty_40, p0_.products_price3_qty AS products_price3_qty_41, p0_.products_price4_qty AS products_price4_qty_42, p0_.products_price5_qty AS products_price5_qty_43, p0_.products_price6_qty AS products_price6_qty_44, p0_.products_price7_qty AS products_price7_qty_45, p0_.products_price8_qty AS products_price8_qty_46, p0_.products_price9_qty AS products_price9_qty_47, p0_.products_price10_qty AS products_price10_qty_48, p0_.products_price11_qty AS products_price11_qty_49, p0_.products_qty_blocks AS products_qty_blocks_50, p0_.products_soleil AS products_soleil_51, p0_.products_limite_panier AS products_limite_panier_52, p0_.products_page AS products_page_53, p0_.products_garantie AS products_garantie_54, p0_.products_cat AS products_cat_55, p0_.products_index AS products_index_56, p0_.products_mvente AS products_mvente_57, p0_.products_strategique AS products_strategique_58, p0_.products_reappro_non AS products_reappro_non_59, p0_.products_multiple AS products_multiple_60, p0_.products_origin AS products_origin_61, p0_.products_gift AS products_gift_62, p0_.products_type AS products_type_63, p0_.products_welcome AS products_welcome_64, p0_.products_code AS products_code_65, p0_.is_default_variant AS is_default_variant_66, p0_.products_parent_id AS products_parent_id_67, p0_.products_model_id AS products_model_id_68, p0_.manufacturers_id AS manufacturers_id_69, p0_.products_tax_class_id AS products_tax_class_id_70 FROM products p0_ WHERE p0_.products_status = 1 AND p0_.products_gift = 1;

SELECT
  m0_.id AS id_0,
  m0_.date_from AS date_from_1,
  m0_.date_to AS date_to_2,
  m0_.visible AS visible_3,
  m0_.title AS title_4,
  m0_.description AS description_5,
  m0_.type AS type_6,
  m0_.percent_discount AS percent_discount_7,
  m0_.amount_discount AS amount_discount_8,
  m0_.qty_requested AS qty_requested_9,
  m0_.amount_requested AS amount_requested_10,
  m0_.amount_soleil_requested AS amount_soleil_requested_11,
  m0_.amount_vivog_requested AS amount_vivog_requested_12,
  m0_.qty_offered AS qty_offered_13,
  m0_.active AS active_14,
  m0_.skip_soleil AS skip_soleil_15,
  m0_.customer_id AS customer_id_16
FROM
  marketing_rules m0_
  INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id
WHERE
  m1_.products_id IN (?, ?, ?)
  AND m0_.date_from <= ?
  AND m0_.date_to >= ?
  AND m0_.active = 1

SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id IN (20645, 20641, 20644) AND m0_.date_from <= '2026-09-07 09:17:13' AND m0_.date_to >= '2026-09-07 09:17:13' AND m0_.active = 1;