Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  price_groups t0

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0;

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_code AS products_code_66,
  t0.is_default_variant AS is_default_variant_67,
  t0.products_parent_id AS products_parent_id_68,
  t0.products_model_id AS products_model_id_69,
  t0.manufacturers_id AS manufacturers_id_70,
  t0.products_tax_class_id AS products_tax_class_id_71
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_code AS products_code_66, t0.is_default_variant AS is_default_variant_67, t0.products_parent_id AS products_parent_id_68, t0.products_model_id AS products_model_id_69, t0.manufacturers_id AS manufacturers_id_70, t0.products_tax_class_id AS products_tax_class_id_71 FROM products t0 WHERE t0.products_id = '21763';

SELECT
  t0.id AS id_1,
  t0.products_short_name AS products_short_name_2,
  t0.products_name AS products_name_3,
  t0.products_label AS products_label_4,
  t0.products_heading_title AS products_heading_title_5,
  t0.products_short_description AS products_short_description_6,
  t0.products_description AS products_description_7,
  t0.products_url AS products_url_8,
  t0.products_viewed AS products_viewed_9,
  t0.products_head_title_tag AS products_head_title_tag_10,
  t0.products_head_desc_tag AS products_head_desc_tag_11,
  t0.products_head_keywords_tag AS products_head_keywords_tag_12,
  t0.products_teaser AS products_teaser_13,
  t0.products_op AS products_op_14,
  t0.products_top AS products_top_15,
  t0.products_new AS products_new_16,
  t0.products_video AS products_video_17,
  t0.products_video2 AS products_video2_18,
  t0.products_conseil1 AS products_conseil1_19,
  t0.products_conseil2 AS products_conseil2_20,
  t0.products_conseil_cat AS products_conseil_cat_21,
  t0.products_notice AS products_notice_22,
  t0.products_notice2 AS products_notice2_23,
  t0.doofinder_boost AS doofinder_boost_24,
  t0.doofinder_indexed_text AS doofinder_indexed_text_25,
  t0.products_categorie AS products_categorie_26,
  t0.products_tags AS products_tags_27,
  t0.products_id AS products_id_28,
  t0.language_id AS language_id_29
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_label AS products_label_4, t0.products_heading_title AS products_heading_title_5, t0.products_short_description AS products_short_description_6, t0.products_description AS products_description_7, t0.products_url AS products_url_8, t0.products_viewed AS products_viewed_9, t0.products_head_title_tag AS products_head_title_tag_10, t0.products_head_desc_tag AS products_head_desc_tag_11, t0.products_head_keywords_tag AS products_head_keywords_tag_12, t0.products_teaser AS products_teaser_13, t0.products_op AS products_op_14, t0.products_top AS products_top_15, t0.products_new AS products_new_16, t0.products_video AS products_video_17, t0.products_video2 AS products_video2_18, t0.products_conseil1 AS products_conseil1_19, t0.products_conseil2 AS products_conseil2_20, t0.products_conseil_cat AS products_conseil_cat_21, t0.products_notice AS products_notice_22, t0.products_notice2 AS products_notice2_23, t0.doofinder_boost AS doofinder_boost_24, t0.doofinder_indexed_text AS doofinder_indexed_text_25, t0.products_categorie AS products_categorie_26, t0.products_tags AS products_tags_27, t0.products_id AS products_id_28, t0.language_id AS language_id_29 FROM products_description t0 WHERE t0.products_id = 21763;

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

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.date_added AS date_added_3,
  t0.last_modified AS last_modified_4,
  t0.status AS status_5,
  t0.parent_id AS parent_id_6,
  t0.manufacturers_id AS manufacturers_id_7,
  t0.variant_id AS variant_id_8
FROM
  products_models t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.date_added AS date_added_3, t0.last_modified AS last_modified_4, t0.status AS status_5, t0.parent_id AS parent_id_6, t0.manufacturers_id AS manufacturers_id_7, t0.variant_id AS variant_id_8 FROM products_models t0 WHERE t0.id = 1589;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.date_added AS date_added_3,
  t0.last_modified AS last_modified_4,
  t0.status AS status_5,
  t0.parent_id AS parent_id_6,
  t0.manufacturers_id AS manufacturers_id_7,
  t0.variant_id AS variant_id_8
FROM
  products_models t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.date_added AS date_added_3, t0.last_modified AS last_modified_4, t0.status AS status_5, t0.parent_id AS parent_id_6, t0.manufacturers_id AS manufacturers_id_7, t0.variant_id AS variant_id_8 FROM products_models t0 WHERE t0.id = 376;

SELECT
  p0_.id AS id_0,
  p0_.products_id AS products_id_1,
  p0_.categories_id AS categories_id_2
FROM
  products_to_categories p0_
  INNER JOIN products p1_ ON p0_.products_id = p1_.products_id
WHERE
  p0_.products_id = ?

SELECT p0_.id AS id_0, p0_.products_id AS products_id_1, p0_.categories_id AS categories_id_2 FROM products_to_categories p0_ INNER JOIN products p1_ ON p0_.products_id = p1_.products_id WHERE p0_.products_id = 21763;

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.categories_code AS categories_code_13,
  t0.parent_id AS parent_id_14
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.categories_code AS categories_code_13, t0.parent_id AS parent_id_14 FROM categories t0 WHERE t0.categories_id = 2483;

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.categories_code AS categories_code_13,
  t0.parent_id AS parent_id_14
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.categories_code AS categories_code_13, t0.parent_id AS parent_id_14 FROM categories t0 WHERE t0.categories_id = 2482;

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.categories_code AS categories_code_13,
  t0.parent_id AS parent_id_14
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.categories_code AS categories_code_13, t0.parent_id AS parent_id_14 FROM categories t0 WHERE t0.categories_id = 2448;

SELECT
  p0_.products_id AS products_id_0,
  p1_.id AS id_1,
  p0_.is_default_variant AS is_default_variant_2
FROM
  products_to_categories p2_
  INNER JOIN products p0_ ON p2_.products_id = p0_.products_id
  LEFT JOIN products_models p1_ ON p0_.products_model_id = p1_.id
WHERE
  p2_.categories_id = ?
  AND p0_.products_status = 1
ORDER BY
  p0_.products_id ASC

SELECT p0_.products_id AS products_id_0, p1_.id AS id_1, p0_.is_default_variant AS is_default_variant_2 FROM products_to_categories p2_ INNER JOIN products p0_ ON p2_.products_id = p0_.products_id LEFT JOIN products_models p1_ ON p0_.products_model_id = p1_.id WHERE p2_.categories_id = 2483 AND p0_.products_status = 1 ORDER BY p0_.products_id ASC;

SELECT
  id,
  parent_id
FROM
  products_models
WHERE
  id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )

SELECT id, parent_id FROM products_models WHERE id IN (559, 104, 248, 1748, 1749, 1750, 1751, 412, 1689, 1582, 1583, 1584, 1585, 1586, 1673, 1587, 1588, 1589, 1590, 1591, 1592, 1639, 606, 2014, 2016, 2026, 1472, 276, 1965, 2005, 1471, 2006, 434, 433, 367, 380, 370, 366, 401, 407, 577, 1765, 1766, 1767, 1768, 1769, 1743, 1896, 1905, 1919, 466, 1307, 1318, 1329, 1572, 1775, 1573, 1574, 382, 432, 383, 1362, 1369, 1380, 1383, 1391, 1402, 1413, 1422, 1776, 1777, 1778, 1779, 1485, 1490, 1491, 1496, 1497, 1498, 1499, 1500, 1736, 1737, 1738, 1643, 1676, 1595, 1596, 1597, 1644, 1859, 1866, 277, 1488, 2145, 1858, 259, 1466, 1489, 1864, 265, 2058, 274, 1865, 1599, 1600, 1598, 2223, 2234, 2245, 2255, 2266, 2276, 285, 286, 1868, 2059, 1869, 1870, 1601, 1602, 1603, 1604, 1605, 1606, 1607, 1492, 1625, 1626, 1627, 1628, 1629, 1630, 1631, 1470, 1875, 1876, 1478, 1877, 1477, 593, 473, 1527, 1528, 1529, 1530, 1531, 1532, 242, 557, 1780, 1781, 1782, 198, 1935, 2078, 1982, 1844, 1964, 1741, 1742, 1457, 108, 1883, 1884, 1885, 1886, 313, 1887, 1888, 1890, 1891, 1788, 436, 2062, 1789, 2082, 1790, 2083, 1791, 1192, 1203, 1214, 1726, 1225, 523, 271, 522, 1959, 1745, 596, 1482, 2023, 2010, 1897, 1898, 1899, 1901, 2000, 2001, 2002, 1796, 1797, 1798, 1799, 2011, 2012, 2013, 351, 476, 1810, 1811, 1837, 1968, 230, 1952, 2007, 2144, 1927, 1838, 2136, 2009, 386, 326, 1576, 402, 1577, 1525, 429, 2124, 2127);

SELECT
  id,
  parent_id
FROM
  products_models
WHERE
  id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )

SELECT id, parent_id FROM products_models WHERE id IN (123, 123, 123, 123, 165, 165, 165, 170, 170, 170, 170, 170, 170, 170, 170, 111, 275, 426, 439, 454, 293, 293, 449, 176, 264, 264, 176, 176, 388, 176, 176, 176, 176, 176, 234, 237, 237, 237, 237, 237, 237, 356, 356, 356, 234, 234, 375, 375, 375, 375, 375, 375, 375, 376, 376, 376, 376, 385, 385, 385, 385, 385, 385, 388, 388, 388, 388, 388, 388, 388, 426, 426, 426, 426, 426, 426, 426, 376, 498, 385, 375, 498, 375, 123, 498, 498, 498, 111, 111, 114, 120, 126, 126, 126, 126, 174, 174, 174, 174, 174, 196, 196, 196, 196, 196, 197, 197, 197, 202, 203, 202, 203, 207, 207, 207, 207, 213, 213, 229, 229, 254, 264, 268, 275, 275, 268, 290, 290, 290, 293, 293, 293, 309, 309, 309, 309, 310, 310, 310, 310, 314, 316, 316, 316, 316, 314, 314, 120, 254, 350, 120, 358, 364, 120, 358, 420, 420, 420, 439, 439, 443, 443, 449, 450, 450, 450, 454, 454, 449, 454, 264, 290, 203, 254, 202, 203, 114, 114, 358, 350, 275, 115, 115, 115, 115, 115, 115);

SELECT
  p0_.products_id AS products_id_0,
  p0_.products_quantity AS products_quantity_1,
  p0_.products_model AS products_model_2,
  p0_.products_model_sap AS products_model_sap_3,
  p0_.products_ean AS products_ean_4,
  p0_.products_image AS products_image_5,
  p0_.products_image_med AS products_image_med_6,
  p0_.products_image_lrg AS products_image_lrg_7,
  p0_.products_image_sm_1 AS products_image_sm_1_8,
  p0_.products_image_xl_1 AS products_image_xl_1_9,
  p0_.products_image_sm_2 AS products_image_sm_2_10,
  p0_.products_image_xl_2 AS products_image_xl_2_11,
  p0_.products_image_sm_3 AS products_image_sm_3_12,
  p0_.products_image_xl_3 AS products_image_xl_3_13,
  p0_.products_image_sm_4 AS products_image_sm_4_14,
  p0_.products_image_xl_4 AS products_image_xl_4_15,
  p0_.products_image_sm_5 AS products_image_sm_5_16,
  p0_.products_image_xl_5 AS products_image_xl_5_17,
  p0_.products_image_sm_6 AS products_image_sm_6_18,
  p0_.products_image_xl_6 AS products_image_xl_6_19,
  p0_.products_price AS products_price_20,
  p0_.products_ecotax AS products_ecotax_21,
  p0_.products_date_added AS products_date_added_22,
  p0_.products_last_modified AS products_last_modified_23,
  p0_.products_date_available AS products_date_available_24,
  p0_.products_weight AS products_weight_25,
  p0_.products_status AS products_status_26,
  p0_.products_ordered AS products_ordered_27,
  p0_.products_price1 AS products_price1_28,
  p0_.products_price2 AS products_price2_29,
  p0_.products_price3 AS products_price3_30,
  p0_.products_price4 AS products_price4_31,
  p0_.products_price5 AS products_price5_32,
  p0_.products_price6 AS products_price6_33,
  p0_.products_price7 AS products_price7_34,
  p0_.products_price8 AS products_price8_35,
  p0_.products_price9 AS products_price9_36,
  p0_.products_price10 AS products_price10_37,
  p0_.products_price11 AS products_price11_38,
  p0_.products_price1_qty AS products_price1_qty_39,
  p0_.products_price2_qty AS products_price2_qty_40,
  p0_.products_price3_qty AS products_price3_qty_41,
  p0_.products_price4_qty AS products_price4_qty_42,
  p0_.products_price5_qty AS products_price5_qty_43,
  p0_.products_price6_qty AS products_price6_qty_44,
  p0_.products_price7_qty AS products_price7_qty_45,
  p0_.products_price8_qty AS products_price8_qty_46,
  p0_.products_price9_qty AS products_price9_qty_47,
  p0_.products_price10_qty AS products_price10_qty_48,
  p0_.products_price11_qty AS products_price11_qty_49,
  p0_.products_qty_blocks AS products_qty_blocks_50,
  p0_.products_soleil AS products_soleil_51,
  p0_.products_limite_panier AS products_limite_panier_52,
  p0_.products_page AS products_page_53,
  p0_.products_garantie AS products_garantie_54,
  p0_.products_cat AS products_cat_55,
  p0_.products_index AS products_index_56,
  p0_.products_mvente AS products_mvente_57,
  p0_.products_strategique AS products_strategique_58,
  p0_.products_reappro_non AS products_reappro_non_59,
  p0_.products_multiple AS products_multiple_60,
  p0_.products_origin AS products_origin_61,
  p0_.products_gift AS products_gift_62,
  p0_.products_type AS products_type_63,
  p0_.products_welcome AS products_welcome_64,
  p0_.products_code AS products_code_65,
  p0_.is_default_variant AS is_default_variant_66,
  p0_.products_parent_id AS products_parent_id_67,
  p0_.products_model_id AS products_model_id_68,
  p0_.manufacturers_id AS manufacturers_id_69,
  p0_.products_tax_class_id AS products_tax_class_id_70
FROM
  products p0_
WHERE
  p0_.products_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)