Symfony Profiler

SELECT
  IF(
    (
      SELECT
        COUNT(*)
      FROM
        products pc
      WHERE
        pc.`products_parent_id` = p.products_id
    )> 0,
    IF(
      (
        SELECT
          SUM(pq.`products_quantity`)
        FROM
          products pq
        WHERE
          pq.`products_parent_id` = p.products_id
          AND pq.`products_quantity` >= 0
      )> 0,
      1,
      0
    ),
    IF(p.products_quantity > 0, 1, 0)
  ) AS available,
  (
    SELECT
      rate
    FROM
      avisverifies_products_average
    WHERE
      ref_product = p.products_id
  ) AS average,
  (
    SELECT
      nb_reviews
    FROM
      avisverifies_products_average
    WHERE
      ref_product = p.products_id
  ) AS nb_reviews,
  IF(
    (
      SELECT
        COUNT(*)
      FROM
        products pp
      WHERE
        pp.products_parent_id = p.products_id
    )> 0,
    LEAST(
      IFNULL(
        (
          SELECT
            MIN(sp.specials_new_products_price)
          FROM
            `specials` sp
          WHERE
            sp.`products_id` IN (
              SELECT
                pp.products_id
              FROM
                products pp
              WHERE
                pp.products_parent_id = p.`products_id`
            )
            AND sp.expires_date > NOW()
            AND sp.status = 1
        ),
        10000
      ),
      (
        SELECT
          MIN(pp.products_price)
        FROM
          `products` pp
        WHERE
          pp.products_parent_id = p.`products_id`
      )
    ),
    IFNULL(
      (
        SELECT
          MIN(sp.specials_new_products_price)
        FROM
          `specials` sp
        WHERE
          sp.`products_id` = p.`products_id`
          AND sp.expires_date > NOW()
          AND sp.status = 1
      ),
      p.products_price
    )
  ) AS reduced_price,
  p.products_id,
  p.products_price,
  IF(
    s.status, s.specials_new_products_price,
    NULL
  ) AS specials_new_products_price,
  IF(
    s.status, s.specials_new_products_price,
    p.products_price
  ) AS final_price,
  IFNULL(
    LEAST(
      p.products_price,
      (
        SELECT
          MIN(pp.products_price)
        FROM
          `products` pp
        WHERE
          pp.products_parent_id = p.`products_id`
          AND p.products_quantity >= 0
      )
    ),
    p.products_price
  ) AS lowest_regular_price
FROM
  (
    products p
    LEFT JOIN specials_retail_prices s USING(products_id)
  )
  INNER JOIN products_description pd ON pd.products_id = p.products_id
  AND pd.language_id = 1
  LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id,
  products_to_categories p2c
WHERE
  p.products_status = '1'
  AND p.products_parent_id IS NULL
  AND p.products_quantity >= 0
  AND p.products_id = p2c.products_id
  AND p2c.categories_id IN (703)
GROUP BY
  p.products_id
ORDER BY
  available DESC,
  products_id DESC
LIMIT
  10 OFFSET 0

SELECT 
            IF((SELECT COUNT(*) FROM products pc WHERE pc.`products_parent_id`=p.products_id)>0,IF((SELECT SUM(pq.`products_quantity`) FROM products pq WHERE pq.`products_parent_id`=p.products_id AND pq.`products_quantity`>=0)>0,1,0),IF(p.products_quantity>0,1,0)) AS available, 
            (SELECT rate FROM avisverifies_products_average WHERE ref_product = p.products_id) AS average,
            (SELECT nb_reviews FROM avisverifies_products_average WHERE ref_product = p.products_id) AS nb_reviews,
            IF(
                (SELECT COUNT(*) FROM products pp WHERE pp.products_parent_id = p.products_id)>0,
                LEAST(
                    IFNULL((SELECT MIN(sp.specials_new_products_price) FROM `specials` sp WHERE sp.`products_id` IN (SELECT pp.products_id FROM products pp WHERE pp.products_parent_id=p.`products_id`) AND sp.expires_date>NOW() AND sp.status=1),10000),
                    (SELECT MIN(pp.products_price) FROM `products` pp WHERE pp.products_parent_id=p.`products_id`)
                ), 
                IFNULL((SELECT MIN(sp.specials_new_products_price) FROM `specials` sp WHERE sp.`products_id` = p.`products_id` AND sp.expires_date>NOW() AND sp.status=1),p.products_price)
            ) AS reduced_price,
            p.products_id, 
            p.products_price, 
            IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, 
            IF(s.status, s.specials_new_products_price, p.products_price) AS final_price,
            IFNULL(
                LEAST(
                    p.products_price,
                    (SELECT MIN(pp.products_price) FROM `products` pp WHERE pp.products_parent_id=p.`products_id` AND p.products_quantity >= 0)
                ),
                p.products_price
            ) AS lowest_regular_price
            FROM (products p LEFT JOIN specials_retail_prices s USING(products_id)) 
            INNER JOIN products_description pd ON pd.products_id = p.products_id AND pd.language_id = 1 
            LEFT JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id, products_to_categories p2c WHERE p.products_status = '1' AND p.products_parent_id  IS NULL AND p.products_quantity >= 0 AND p.products_id = p2c.products_id AND p2c.categories_id IN (703) GROUP BY p.products_id  ORDER BY available DESC , products_id DESC LIMIT 10 OFFSET 0;

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_parent_id AS products_parent_id_65,
  t0.manufacturers_id AS manufacturers_id_66,
  t0.products_tax_class_id AS products_tax_class_id_67
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_parent_id AS products_parent_id_65, t0.manufacturers_id AS manufacturers_id_66, t0.products_tax_class_id AS products_tax_class_id_67 FROM products t0 WHERE t0.products_id = '18542';

SELECT
  r0_.id AS id_0,
  r0_.redirect_url AS redirect_url_1,
  r0_.target_path AS target_path_2,
  r0_.target_url AS target_url_3,
  r0_.redirect_product_id AS redirect_product_id_4,
  r0_.redirect_category_id AS redirect_category_id_5,
  r0_.target_product_id AS target_product_id_6,
  r0_.target_category_id AS target_category_id_7
FROM
  redirections r0_
WHERE
  r0_.redirect_product_id = ?
  OR r0_.redirect_url LIKE ?
LIMIT
  1

SELECT r0_.id AS id_0, r0_.redirect_url AS redirect_url_1, r0_.target_path AS target_path_2, r0_.target_url AS target_url_3, r0_.redirect_product_id AS redirect_product_id_4, r0_.redirect_category_id AS redirect_category_id_5, r0_.target_product_id AS target_product_id_6, r0_.target_category_id AS target_category_id_7 FROM redirections r0_ WHERE r0_.redirect_product_id = 18542 OR r0_.redirect_url LIKE '%product_info.php?products_id=18542&%' 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 = 703;

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

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.products_short_name AS products_short_name_2,
  t0.products_name AS products_name_3,
  t0.products_heading_title AS products_heading_title_4,
  t0.products_short_description AS products_short_description_5,
  t0.products_description AS products_description_6,
  t0.products_url AS products_url_7,
  t0.products_viewed AS products_viewed_8,
  t0.products_head_title_tag AS products_head_title_tag_9,
  t0.products_head_desc_tag AS products_head_desc_tag_10,
  t0.products_head_keywords_tag AS products_head_keywords_tag_11,
  t0.products_teaser AS products_teaser_12,
  t0.products_op AS products_op_13,
  t0.products_top AS products_top_14,
  t0.products_new AS products_new_15,
  t0.products_video AS products_video_16,
  t0.products_video2 AS products_video2_17,
  t0.products_conseil1 AS products_conseil1_18,
  t0.products_conseil2 AS products_conseil2_19,
  t0.products_conseil_cat AS products_conseil_cat_20,
  t0.products_notice AS products_notice_21,
  t0.products_notice2 AS products_notice2_22,
  t0.doofinder_boost AS doofinder_boost_23,
  t0.doofinder_indexed_text AS doofinder_indexed_text_24,
  t0.products_categorie AS products_categorie_25,
  t0.products_tags AS products_tags_26,
  t0.products_id AS products_id_27,
  t0.language_id AS language_id_28
FROM
  products_description t0
WHERE
  t0.products_id = ?

SELECT t0.id AS id_1, t0.products_short_name AS products_short_name_2, t0.products_name AS products_name_3, t0.products_heading_title AS products_heading_title_4, t0.products_short_description AS products_short_description_5, t0.products_description AS products_description_6, t0.products_url AS products_url_7, t0.products_viewed AS products_viewed_8, t0.products_head_title_tag AS products_head_title_tag_9, t0.products_head_desc_tag AS products_head_desc_tag_10, t0.products_head_keywords_tag AS products_head_keywords_tag_11, t0.products_teaser AS products_teaser_12, t0.products_op AS products_op_13, t0.products_top AS products_top_14, t0.products_new AS products_new_15, t0.products_video AS products_video_16, t0.products_video2 AS products_video2_17, t0.products_conseil1 AS products_conseil1_18, t0.products_conseil2 AS products_conseil2_19, t0.products_conseil_cat AS products_conseil_cat_20, t0.products_notice AS products_notice_21, t0.products_notice2 AS products_notice2_22, t0.doofinder_boost AS doofinder_boost_23, t0.doofinder_indexed_text AS doofinder_indexed_text_24, t0.products_categorie AS products_categorie_25, t0.products_tags AS products_tags_26, t0.products_id AS products_id_27, t0.language_id AS language_id_28 FROM products_description t0 WHERE t0.products_id = 18542;

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_parent_id AS products_parent_id_65,
  t0.manufacturers_id AS manufacturers_id_66,
  t0.products_tax_class_id AS products_tax_class_id_67
FROM
  products t0
WHERE
  t0.products_parent_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_parent_id AS products_parent_id_65, t0.manufacturers_id AS manufacturers_id_66, t0.products_tax_class_id AS products_tax_class_id_67 FROM products t0 WHERE t0.products_parent_id = 18542;

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

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 = ?
  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 = 18542 AND m0_.date_from <= '2025-11-04 15:40:58' AND m0_.date_to >= '2025-11-04 15:40:58' AND m0_.active = 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.parent_id = ?
ORDER BY
  t0.sort_order ASC

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.parent_id = 703 ORDER BY t0.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.products_id AS products_id_3,
  t0.price_group_id AS price_group_id_4
FROM
  product_prices t0
WHERE
  t0.products_id = ?

SELECT t0.id AS id_1, t0.price AS price_2, t0.products_id AS products_id_3, t0.price_group_id AS price_group_id_4 FROM product_prices t0 WHERE t0.products_id = 18542;

SELECT
  p0_.id AS id_0,
  p0_.sort_order AS sort_order_1,
  p0_.products_id AS products_id_2,
  p0_.xsell_id AS xsell_id_3
FROM
  products_xsell p0_
  INNER JOIN products p1_ ON p0_.xsell_id = p1_.products_id
WHERE
  p0_.products_id = ?
  AND p1_.products_status = 1
ORDER BY
  p0_.sort_order ASC

SELECT p0_.id AS id_0, p0_.sort_order AS sort_order_1, p0_.products_id AS products_id_2, p0_.xsell_id AS xsell_id_3 FROM products_xsell p0_ INNER JOIN products p1_ ON p0_.xsell_id = p1_.products_id WHERE p0_.products_id = 18542 AND p1_.products_status = 1 ORDER BY p0_.sort_order ASC;