Symfony Profiler

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 = 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
      INNER JOIN marketing_rules_description mkd ON mk.id = mkd.marketing_rule_id
      AND mkd.languages_id = 4
    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 = 4
      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 399

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 = 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
            INNER JOIN marketing_rules_description mkd ON mk.id = mkd.marketing_rule_id AND mkd.languages_id = 4 
            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 = 4  
            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 399;

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.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.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
  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 11:07:34' AND m0_.date_to >= '2025-12-06 11:07:34' AND m0_.active = 1 AND m0_.visible = 1;

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