Symfony Profiler

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
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 IN (706, 999, 1016, 1000, 1020, 1007, 1017, 1015, 526, 707, 669, 720, 1362, 708, 1824, 761, 1324, 892, 1329, 1389, 491, 1391, 1501, 1103, 1390, 891, 1748, 1652, 614, 1069, 1004, 519, 1799, 616, 445, 628, 630, 629, 1403, 632, 756, 636, 522, 757, 1743, 1018, 634, 528, 935, 870, 1742, 523, 444, 1835, 668, 671, 1392, 670, 673, 739, 1486, 1485, 1804, 1429, 521, 765, 1401, 525, 1432, 617, 426, 1649, 465, 467, 468, 469, 911, 1414, 1803, 470, 1415, 1416, 1058, 1417, 682, 1418, 524, 391, 1746, 1745, 1747, 1466, 946, 1110, 714, 716, 715, 1376, 679, 1729, 1730, 1816, 1818, 1828, 520, 1001, 693, 1031, 1032, 1033, 1034, 1100, 437, 1101, 1728, 1044, 704, 436, 705, 441, 1002, 913, 1836, 1419, 908, 439, 776, 766, 1552, 988, 934, 1487, 635, 1096, 527, 1825) AND p0_.products_status = 1 ORDER BY p0_.products_id ASC;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.products_attributes_id AS products_attributes_id_3,
  t0.language_id AS language_id_4
FROM
  products_attributes_description t0
WHERE
  t0.products_attributes_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.products_attributes_id AS products_attributes_id_3, t0.language_id AS language_id_4 FROM products_attributes_description t0 WHERE t0.products_attributes_id = 326618;

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

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

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.alt AS alt_4,
  t0.pictures_id AS pictures_id_5,
  t0.language_id AS language_id_6
FROM
  pictures_description t0
WHERE
  t0.pictures_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.alt AS alt_4, t0.pictures_id AS pictures_id_5, t0.language_id AS language_id_6 FROM pictures_description t0 WHERE t0.pictures_id = 8126;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  price_groups t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM price_groups t0 WHERE t0.code = 'VV' LIMIT 1;

SELECT
  t1.id AS id_2,
  t1.url AS url_3,
  t1.source_name AS source_name_4,
  t1.`rank` AS rank_5,
  t1.`code` AS code_6,
  t1.format AS format_7,
  t0.products_id AS products_id_8,
  t1.type
FROM
  pictures_products t0
  INNER JOIN pictures t1 ON t0.id = t1.id
WHERE
  t0.products_id = ?
ORDER BY
  t1.`rank` ASC,
  t1.id ASC

SELECT t1.id AS id_2, t1.url AS url_3, t1.source_name AS source_name_4, t1.`rank` AS rank_5, t1.`code` AS code_6, t1.format AS format_7, t0.products_id AS products_id_8, t1.type FROM pictures_products t0 INNER JOIN pictures t1 ON t0.id = t1.id WHERE t0.products_id = 21123 ORDER BY t1.`rank` ASC, t1.id ASC;

SELECT
  t0.attributes_id AS attributes_id_1,
  t0.attributes_status AS attributes_status_2,
  t0.attributes_code AS attributes_code_3,
  t0.attributes_order AS attributes_order_4,
  t0.attributes_display AS attributes_display_5,
  t0.attributes_filter AS attributes_filter_6,
  t0.attributes_caracteristic AS attributes_caracteristic_7
FROM
  attributes t0
WHERE
  t0.attributes_id = ?

SELECT t0.attributes_id AS attributes_id_1, t0.attributes_status AS attributes_status_2, t0.attributes_code AS attributes_code_3, t0.attributes_order AS attributes_order_4, t0.attributes_display AS attributes_display_5, t0.attributes_filter AS attributes_filter_6, t0.attributes_caracteristic AS attributes_caracteristic_7 FROM attributes t0 WHERE t0.attributes_id = 250;

SELECT
  t0.colors_id AS colors_id_1,
  t0.colors_code AS colors_code_2,
  t0.colors_type AS colors_type_3,
  t0.colors_image AS colors_image_4
FROM
  colors t0
WHERE
  t0.colors_code = ?
LIMIT
  1

SELECT t0.colors_id AS colors_id_1, t0.colors_code AS colors_code_2, t0.colors_type AS colors_type_3, t0.colors_image AS colors_image_4 FROM colors t0 WHERE t0.colors_code = 'blue' LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.date_from AS date_from_1,
  m0_.date_to AS date_to_2,
  m0_.visible AS visible_3,
  m0_.title AS title_4,
  m0_.description AS description_5,
  m0_.type AS type_6,
  m0_.percent_discount AS percent_discount_7,
  m0_.amount_discount AS amount_discount_8,
  m0_.qty_requested AS qty_requested_9,
  m0_.amount_requested AS amount_requested_10,
  m0_.amount_soleil_requested AS amount_soleil_requested_11,
  m0_.amount_vivog_requested AS amount_vivog_requested_12,
  m0_.qty_offered AS qty_offered_13,
  m0_.active AS active_14,
  m0_.skip_soleil AS skip_soleil_15,
  m0_.customer_id AS customer_id_16
FROM
  marketing_rules m0_
WHERE
  m0_.date_from <= ?
  AND m0_.date_to >= ?
  AND m0_.type = ?
  AND m0_.active = 1

SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ WHERE m0_.date_from <= '2026-10-08 20:06:56' AND m0_.date_to >= '2026-10-08 20:06:56' AND m0_.type = 'percent-soleil' AND m0_.active = 1;

SELECT
  t0.products_attributes_id AS products_attributes_id_1,
  t0.attributes_value AS attributes_value_2,
  t0.products_id AS products_id_3,
  t0.attributes_id AS attributes_id_4
FROM
  products_attributes t0
WHERE
  t0.products_id = ?

SELECT t0.products_attributes_id AS products_attributes_id_1, t0.attributes_value AS attributes_value_2, t0.products_id AS products_id_3, t0.attributes_id AS attributes_id_4 FROM products_attributes t0 WHERE t0.products_id = 15467;

SELECT
  m0_.id AS id_0,
  m0_.date_from AS date_from_1,
  m0_.date_to AS date_to_2,
  m0_.visible AS visible_3,
  m0_.title AS title_4,
  m0_.description AS description_5,
  m0_.type AS type_6,
  m0_.percent_discount AS percent_discount_7,
  m0_.amount_discount AS amount_discount_8,
  m0_.qty_requested AS qty_requested_9,
  m0_.amount_requested AS amount_requested_10,
  m0_.amount_soleil_requested AS amount_soleil_requested_11,
  m0_.amount_vivog_requested AS amount_vivog_requested_12,
  m0_.qty_offered AS qty_offered_13,
  m0_.active AS active_14,
  m0_.skip_soleil AS skip_soleil_15,
  m0_.customer_id AS customer_id_16
FROM
  marketing_rules m0_
  INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id
WHERE
  m1_.products_id = ?
  AND m0_.date_from <= ?
  AND m0_.date_to >= ?
  AND m0_.active = 1

SELECT m0_.id AS id_0, m0_.date_from AS date_from_1, m0_.date_to AS date_to_2, m0_.visible AS visible_3, m0_.title AS title_4, m0_.description AS description_5, m0_.type AS type_6, m0_.percent_discount AS percent_discount_7, m0_.amount_discount AS amount_discount_8, m0_.qty_requested AS qty_requested_9, m0_.amount_requested AS amount_requested_10, m0_.amount_soleil_requested AS amount_soleil_requested_11, m0_.amount_vivog_requested AS amount_vivog_requested_12, m0_.qty_offered AS qty_offered_13, m0_.active AS active_14, m0_.skip_soleil AS skip_soleil_15, m0_.customer_id AS customer_id_16 FROM marketing_rules m0_ INNER JOIN marketing_rules_products_discounted m1_ ON m0_.id = m1_.marketing_rule_id WHERE m1_.products_id = 21123 AND m0_.date_from <= '2026-10-08 20:06:56' AND m0_.date_to >= '2026-10-08 20:06:56' AND m0_.active = 1;