Symfony Profiler

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

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
  21

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

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

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

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

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

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

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

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