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 = '24540';

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

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 = 24540 OR r0_.redirect_url LIKE '%product_info.php?products_id=24540&%' 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 = 1332;

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 = 1532 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 = ?
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 = 1481 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 = ?
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 = 1559 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 = ?
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 = 1753 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 = ?
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 = 1507 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 = ?
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 = 1739 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 = ?
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 = 1736 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 = ?
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 = 1821 ORDER BY t0.sort_order ASC;

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 pp.products_status = 1
            )
            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`
          and pp.products_status = 1
      )
    ),
    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 (
    1532, 1481, 1559, 1753, 1507, 1739, 1736,
    1821
  )
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 pp.products_status=1) 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` and pp.products_status=1)
                ), 
                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 (1532,1481,1559,1753,1507,1739,1736,1821) 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_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 = 25733;