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.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.listing_axis AS listing_axis_6,
  t0.products_cat AS products_cat_7,
  t0.parent_id AS parent_id_8,
  t0.manufacturers_id AS manufacturers_id_9,
  t0.variant_id AS variant_id_10,
  t0.default_product_id AS default_product_id_11
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.listing_axis AS listing_axis_6, t0.products_cat AS products_cat_7, t0.parent_id AS parent_id_8, t0.manufacturers_id AS manufacturers_id_9, t0.variant_id AS variant_id_10, t0.default_product_id AS default_product_id_11 FROM products_models t0 WHERE t0.id = '1000';

SELECT
  t0.id AS id_1,
  t0.short_name AS short_name_2,
  t0.name AS name_3,
  t0.label AS label_4,
  t0.heading_title AS heading_title_5,
  t0.short_description AS short_description_6,
  t0.description AS 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_video AS products_video_13,
  t0.products_conseil1 AS products_conseil1_14,
  t0.products_notice AS products_notice_15,
  t0.products_tags AS products_tags_16,
  t0.products_models_id AS products_models_id_17,
  t0.language_id AS language_id_18
FROM
  products_models_description t0
WHERE
  t0.products_models_id = ?

SELECT t0.id AS id_1, t0.short_name AS short_name_2, t0.name AS name_3, t0.label AS label_4, t0.heading_title AS heading_title_5, t0.short_description AS short_description_6, t0.description AS 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_video AS products_video_13, t0.products_conseil1 AS products_conseil1_14, t0.products_notice AS products_notice_15, t0.products_tags AS products_tags_16, t0.products_models_id AS products_models_id_17, t0.language_id AS language_id_18 FROM products_models_description t0 WHERE t0.products_models_id = 1000;

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.listing_axis AS listing_axis_6,
  t0.products_cat AS products_cat_7,
  t0.parent_id AS parent_id_8,
  t0.manufacturers_id AS manufacturers_id_9,
  t0.variant_id AS variant_id_10,
  t0.default_product_id AS default_product_id_11
FROM
  products_models t0
WHERE
  t0.parent_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.listing_axis AS listing_axis_6, t0.products_cat AS products_cat_7, t0.parent_id AS parent_id_8, t0.manufacturers_id AS manufacturers_id_9, t0.variant_id AS variant_id_10, t0.default_product_id AS default_product_id_11 FROM products_models t0 WHERE t0.parent_id = 1000;

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.is_default_variant AS is_default_variant_66,
  t0.products_parent_id AS products_parent_id_67,
  t0.products_model_id AS products_model_id_68,
  t0.manufacturers_id AS manufacturers_id_69,
  t0.products_tax_class_id AS products_tax_class_id_70
FROM
  products t0
WHERE
  t0.products_model_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.is_default_variant AS is_default_variant_66, t0.products_parent_id AS products_parent_id_67, t0.products_model_id AS products_model_id_68, t0.manufacturers_id AS manufacturers_id_69, t0.products_tax_class_id AS products_tax_class_id_70 FROM products t0 WHERE t0.products_model_id = 1000;

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

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

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

SELECT
  t0.languages_id AS languages_id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.image AS image_4,
  t0.directory AS directory_5,
  t0.sort_order AS sort_order_6
FROM
  languages t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.languages_id AS languages_id_1, t0.name AS name_2, t0.code AS code_3, t0.image AS image_4, t0.directory AS directory_5, t0.sort_order AS sort_order_6 FROM languages t0 WHERE t0.code = 'fr' 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.categories_code AS categories_code_13,
  t0.parent_id AS parent_id_14
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.categories_code AS categories_code_13, t0.parent_id AS parent_id_14 FROM categories t0 WHERE t0.parent_id = 521 ORDER BY t0.sort_order 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 IN (?)
  AND p0_.products_status = 1
  AND p0_.products_quantity <> -800
ORDER BY
  p0_.products_model_sap DESC

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 IN (521) AND p0_.products_status = 1 AND p0_.products_quantity <> -800 ORDER BY p0_.products_model_sap DESC;

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

SELECT id, parent_id FROM products_models WHERE id IN (2297, 2296, 2295, 2294, 2293, 2292, 2290, 1023, 2286, 2285, 1416, 1415, 1161, 1160, 1159, 1083, 1158, 1156, 1155, 1001, 1000, 2244, 1004, 2243, 2242, 2241, 2240, 2239, 2237, 1052, 1414, 1413, 1412, 1411, 1410, 2331, 2330, 2329, 2328, 2327, 1041, 1039, 2323, 2322, 2321, 2320, 2319, 2318, 2317, 2316, 2315, 2314, 2312, 2311, 2310, 2309, 2308, 2307, 2306, 2305, 2304, 2303, 2261, 2259, 2258, 2301, 2300, 2299, 2298, 1163, 2206, 2203, 2202, 2194, 2193, 2233, 2232, 978, 977, 976, 2257, 2256, 2255, 2283, 2282, 2280, 2279, 2278, 2191, 1049, 1048, 1047, 1055, 2231, 2229, 2228, 2227, 1409, 1407, 1406, 1405, 1404, 1403, 1402, 2269, 2268, 1401, 1400, 1399, 1398, 1396, 1395, 2267, 2219, 2218, 2217, 2216, 2215, 2214, 2213, 2212, 2211);

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

SELECT id, parent_id FROM products_models WHERE id IN (1043, 1044, 1044, 1045, 1045, 1045, 1053, 987, 987, 987, 987, 987, 987, 991, 991, 991, 991, 991, 991, 991, 997, 997, 997, 997, 997, 1021, 1021, 975, 979, 979, 981, 981, 983, 986, 986, 986, 986, 986, 986, 986, 986, 986, 992, 992, 992, 992, 993, 993, 1002, 1002, 1002, 1002, 1002, 1003, 1003, 1011, 1011, 1011, 1014, 1014, 1014, 1017, 1017, 1017, 1020, 1020, 1020, 1020, 1020, 1022, 1022, 1025, 1025, 1026, 1026, 1026, 1026, 1026, 1027, 1027, 1028, 1028, 1014, 1029, 1029, 1029, 1030, 1030, 1030, 1031, 1036, 1036, 1036, 1036, 1037, 1037, 1037, 1038, 1038, 1038, 1038, 1038, 1042, 1042, 1042, 1042, 1042);

SELECT
  m.id,
  m.listing_axis,
  v.axis1,
  v.axis2
FROM
  products_models m
  INNER JOIN products_models_variants v ON v.id = m.variant_id
WHERE
  m.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
  AND m.listing_axis IS NOT NULL

SELECT m.id, m.listing_axis, v.axis1, v.axis2
            FROM products_models m
            INNER JOIN products_models_variants v ON v.id = m.variant_id
            WHERE m.id IN (1026, 1025, 1023, 1022, 1021, 1045, 1083, 1044, 1043, 1001, 1000, 1003, 1004, 1002, 1052, 997, 1042, 1041, 1039, 1038, 1037, 1036, 1031, 1030, 1029, 1014, 1028, 1027, 1053, 983, 981, 979, 993, 978, 977, 976, 1011, 1020, 975, 1049, 1048, 1047, 1055, 992, 991, 1017, 987, 986) AND m.listing_axis IS NOT NULL;

SELECT
  pa.products_id,
  a.attributes_code,
  pa.attributes_value
FROM
  products_attributes pa
  INNER JOIN attributes a ON a.attributes_id = pa.attributes_id
WHERE
  pa.products_id IN (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )
  AND a.attributes_code IN (?)

SELECT pa.products_id, a.attributes_code, pa.attributes_value
            FROM products_attributes pa
            INNER JOIN attributes a ON a.attributes_id = pa.attributes_id
            WHERE pa.products_id IN (26030, 26029, 26028, 26027, 26026, 26036, 26035, 26034, 26033, 26032, 26002, 26003, 26039, 26038, 26042, 26041, 25737, 25736, 25735, 25743, 25742, 25740, 25739, 25738, 25634, 25632, 25630, 25628, 25626, 25624, 25622, 25621, 25620, 25619, 25618, 25616, 25615, 25614, 25613, 25612, 25610, 25609, 25608, 25607, 25606, 25172, 25171, 25170, 25164, 25165, 25168, 25167, 25160, 17777, 17771, 17765, 17776, 17770, 17764, 17775, 17769, 17763, 17774, 17768, 17762, 17773, 17767, 17761, 24832, 24831, 24824, 24830, 24823, 24829, 24822, 24828, 24821, 24864, 24863, 24854, 24848, 24853, 24847, 24852, 24846, 24851, 24845, 24850, 24844, 24862, 24858, 24861, 24857, 24860, 24856, 24842, 24837, 24841, 24836, 24840, 24835, 24839, 24834, 24590, 24586, 24589, 24581, 24585, 24588, 24580, 24584, 23736, 23740, 23735, 23739, 23734, 23738, 23733, 23039, 23020, 23038, 23019, 23036, 23017, 23035, 23016, 23080, 23062, 22250, 22253, 22226, 22223, 22220, 22225, 22222, 22219, 22154, 22151, 22148, 22153, 21427, 21424, 21421, 21426, 21423, 21420, 21188, 21202, 21187, 21201, 21186, 21200, 21185, 21199, 21184, 21198, 20842, 13031, 13030, 13027, 20112, 20107, 20111, 20106, 20110, 20105, 20109, 20104, 17639, 17631, 17623, 17615, 17638, 17630, 17622, 17614, 17637, 17629, 17621, 17613, 17636, 17628, 17620, 17612, 17635, 17627, 17619, 17611, 17634, 17626, 17618, 17610, 17633, 17625, 17617, 17609, 24807, 24803, 24806, 24802, 17660, 17653, 17659, 17652, 17658, 17651, 17657, 17650, 17656, 17649, 17655, 17648, 24805, 24801, 17607, 17597, 17587, 17577, 17606, 17596, 17586, 17576, 17605, 17595, 17585, 17575, 17604, 17594, 17584, 17574, 17603, 17593, 17583, 19709, 17602, 17592, 17582, 17572, 17601, 17591, 17581, 19708, 17600, 17590, 17580, 17570, 17599, 17589, 17579, 17569) AND a.attributes_code IN ('precise_color');