Symfony Profiler

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_parent_id AS products_parent_id_66,
  t0.manufacturers_id AS manufacturers_id_67,
  t0.products_tax_class_id AS products_tax_class_id_68
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_parent_id AS products_parent_id_66, t0.manufacturers_id AS manufacturers_id_67, t0.products_tax_class_id AS products_tax_class_id_68 FROM products t0 WHERE t0.products_id = 12802;

SELECT
  products_id,
  products_price,
  products_name,
  products_quantity,
  discount_title,
  IFNULL(reduced_price, products_price) AS calculated
FROM
  (
    SELECT
      p.products_id,
      p.products_price,
      pd.products_name,
      p.products_quantity,
      mkd.title AS discount_title,
      mkpd.price AS reduced_price
    FROM
      products p
      INNER JOIN products_description pd ON p.products_id = pd.products_id
      AND pd.language_id = 1
      INNER JOIN marketing_rules_products_discounted mkpd ON mkpd.products_id = pd.products_id
      INNER JOIN marketing_rules mk ON mk.id = mkpd.marketing_rule_id
      INNER JOIN marketing_rules_description mkd ON mk.id = mkd.marketing_rule_id
      AND mkd.languages_id = 1
    WHERE
      mk.active = 1
      AND mk.date_to >= NOW()
      AND mk.date_from <= NOW()
      AND p.products_quantity > 0
    UNION
    SELECT
      p1.products_id,
      p1.products_price,
      pd1.products_name,
      p1.products_quantity,
      NULL AS discount_title,
      s.specials_new_products_price
    FROM
      products p1
      INNER JOIN products_description pd1 ON p1.products_id = pd1.products_id
      AND pd1.language_id = 1
      INNER JOIN specials s ON s.products_id = p1.products_id
    WHERE
      s.expires_date >= NOW()
      AND s.date_status_change <= NOW()
  ) pu
ORDER BY
  pu.products_id DESC
LIMIT
  21 OFFSET 315

SELECT products_id, products_price, products_name, products_quantity, discount_title, IFNULL(reduced_price, products_price) AS calculated FROM (
            SELECT p.products_id, p.products_price, pd.products_name, p.products_quantity, mkd.title AS discount_title, mkpd.price AS reduced_price FROM products p 
            INNER JOIN products_description pd ON p.products_id = pd.products_id AND pd.language_id = 1  
            INNER JOIN marketing_rules_products_discounted mkpd ON mkpd.products_id = pd.products_id
            INNER JOIN marketing_rules mk ON mk.id = mkpd.marketing_rule_id
            INNER JOIN marketing_rules_description mkd ON mk.id = mkd.marketing_rule_id AND mkd.languages_id = 1 
            WHERE 
            mk.active = 1 AND mk.date_to >= NOW() AND mk.date_from <= NOW() AND p.products_quantity > 0
            UNION
            SELECT p1.products_id, p1.products_price, pd1.products_name, p1.products_quantity, NULL AS discount_title, s.specials_new_products_price FROM products p1 
            INNER JOIN products_description pd1 ON p1.products_id = pd1.products_id AND pd1.language_id = 1  
            INNER JOIN specials s ON s.products_id = p1.products_id
            WHERE
            s.expires_date >= NOW() AND s.date_status_change <= NOW()
        ) pu  ORDER BY  pu.products_id DESC  LIMIT 21 OFFSET 315;

SELECT
  COUNT(*)
FROM
  (
    SELECT
      p.products_id,
      p.products_price,
      pd.products_name
    FROM
      products p
      INNER JOIN products_description pd ON p.products_id = pd.products_id
      AND pd.language_id = 4
      INNER JOIN marketing_rules_products_discounted mkpd ON mkpd.products_id = pd.products_id
      INNER JOIN marketing_rules mk ON mk.id = mkpd.marketing_rule_id
    WHERE
      mk.active = 1
      AND mk.date_to >= NOW()
      AND mk.date_from <= NOW()
      AND p.products_quantity > 0
    UNION
    SELECT
      p1.products_id,
      p1.products_price,
      pd1.products_name
    FROM
      products p1
      INNER JOIN products_description pd1 ON p1.products_id = pd1.products_id
      AND pd1.language_id = 4
      INNER JOIN specials s ON s.products_id = p1.products_id
    WHERE
      s.expires_date >= NOW()
      AND s.date_status_change <= NOW()
  ) pu

SELECT COUNT(*) FROM (
            SELECT p.products_id, p.products_price, pd.products_name FROM products p 
            INNER JOIN products_description pd ON p.products_id = pd.products_id AND pd.language_id = 4 
            INNER JOIN marketing_rules_products_discounted mkpd ON mkpd.products_id = pd.products_id
            INNER JOIN marketing_rules mk ON mk.id = mkpd.marketing_rule_id
            WHERE 
            mk.active = 1 AND mk.date_to >= NOW() AND mk.date_from <= NOW() AND p.products_quantity > 0
            UNION
            SELECT p1.products_id, p1.products_price, pd1.products_name FROM products p1 
            INNER JOIN products_description pd1 ON p1.products_id = pd1.products_id AND pd1.language_id = 4 
            INNER JOIN specials s ON s.products_id = p1.products_id
            WHERE
            s.expires_date >= NOW() AND s.date_status_change <= NOW()
        ) pu ;

SELECT
  t0.categories_id AS categories_id_1,
  t0.categories_image AS categories_image_2,
  t0.sort_order AS sort_order_3,
  t0.date_added AS date_added_4,
  t0.last_modified AS last_modified_5,
  t0.categories_best AS categories_best_6,
  t0.categories_affichage AS categories_affichage_7,
  t0.categories_sousmenu AS categories_sousmenu_8,
  t0.categories_index AS categories_index_9,
  t0.categories_hide_children AS categories_hide_children_10,
  t0.categories_position AS categories_position_11,
  t0.categories_menu_spacer AS categories_menu_spacer_12,
  t0.parent_id AS parent_id_13
FROM
  categories t0
WHERE
  t0.categories_id = ?

SELECT t0.categories_id AS categories_id_1, t0.categories_image AS categories_image_2, t0.sort_order AS sort_order_3, t0.date_added AS date_added_4, t0.last_modified AS last_modified_5, t0.categories_best AS categories_best_6, t0.categories_affichage AS categories_affichage_7, t0.categories_sousmenu AS categories_sousmenu_8, t0.categories_index AS categories_index_9, t0.categories_hide_children AS categories_hide_children_10, t0.categories_position AS categories_position_11, t0.categories_menu_spacer AS categories_menu_spacer_12, t0.parent_id AS parent_id_13 FROM categories t0 WHERE t0.categories_id = '242';

SELECT
  t0.languages_id AS languages_id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.image AS image_4,
  t0.directory AS directory_5,
  t0.sort_order AS sort_order_6
FROM
  languages t0
WHERE
  t0.languages_id = ?

SELECT t0.languages_id AS languages_id_1, t0.name AS name_2, t0.code AS code_3, t0.image AS image_4, t0.directory AS directory_5, t0.sort_order AS sort_order_6 FROM languages t0 WHERE t0.languages_id = 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_
WHERE
  m0_.date_from <= ?
  AND m0_.date_to >= ?
  AND m0_.active = 1
  AND m0_.visible = 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_ WHERE m0_.date_from <= '2025-12-06 05:44:55' AND m0_.date_to >= '2025-12-06 05:44:55' AND m0_.active = 1 AND m0_.visible = 1;

SELECT
  t0.id AS id_1,
  t0.redirect_url AS redirect_url_2,
  t0.target_path AS target_path_3,
  t0.target_url AS target_url_4,
  t0.redirect_product_id AS redirect_product_id_5,
  t0.redirect_category_id AS redirect_category_id_6,
  t0.target_product_id AS target_product_id_7,
  t0.target_category_id AS target_category_id_8
FROM
  redirections t0
WHERE
  t0.redirect_category_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.redirect_url AS redirect_url_2, t0.target_path AS target_path_3, t0.target_url AS target_url_4, t0.redirect_product_id AS redirect_product_id_5, t0.redirect_category_id AS redirect_category_id_6, t0.target_product_id AS target_product_id_7, t0.target_category_id AS target_category_id_8 FROM redirections t0 WHERE t0.redirect_category_id = 242 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.categories_name AS categories_name_2,
  t0.categories_short_name AS categories_short_name_3,
  t0.categories_heading_title AS categories_heading_title_4,
  t0.categories_description AS categories_description_5,
  t0.categories_head_title_tag AS categories_head_title_tag_6,
  t0.categories_head_desc_tag AS categories_head_desc_tag_7,
  t0.categories_head_keywords_tag AS categories_head_keywords_tag_8,
  t0.categories_htc_title_tag AS categories_htc_title_tag_9,
  t0.categories_htc_desc_tag AS categories_htc_desc_tag_10,
  t0.categories_htc_keywords_tag AS categories_htc_keywords_tag_11,
  t0.categories_htc_description AS categories_htc_description_12,
  t0.categories_description_bas AS categories_description_bas_13,
  t0.categories_tags AS categories_tags_14,
  t0.categories_url AS categories_url_15,
  t0.categories_menu_prefix AS categories_menu_prefix_16,
  t0.categories_menu_suffix AS categories_menu_suffix_17,
  t0.categories_menu_banner AS categories_menu_banner_18,
  t0.categories_id AS categories_id_19,
  t0.language_id AS language_id_20
FROM
  categories_description t0
WHERE
  t0.categories_id = ?

SELECT t0.id AS id_1, t0.categories_name AS categories_name_2, t0.categories_short_name AS categories_short_name_3, t0.categories_heading_title AS categories_heading_title_4, t0.categories_description AS categories_description_5, t0.categories_head_title_tag AS categories_head_title_tag_6, t0.categories_head_desc_tag AS categories_head_desc_tag_7, t0.categories_head_keywords_tag AS categories_head_keywords_tag_8, t0.categories_htc_title_tag AS categories_htc_title_tag_9, t0.categories_htc_desc_tag AS categories_htc_desc_tag_10, t0.categories_htc_keywords_tag AS categories_htc_keywords_tag_11, t0.categories_htc_description AS categories_htc_description_12, t0.categories_description_bas AS categories_description_bas_13, t0.categories_tags AS categories_tags_14, t0.categories_url AS categories_url_15, t0.categories_menu_prefix AS categories_menu_prefix_16, t0.categories_menu_suffix AS categories_menu_suffix_17, t0.categories_menu_banner AS categories_menu_banner_18, t0.categories_id AS categories_id_19, t0.language_id AS language_id_20 FROM categories_description t0 WHERE t0.categories_id = 242;