Symfony Profiler

SELECT
  t0_.id AS id_0,
  t0_.type AS type_1,
  t0_.to_url AS to_url_2,
  t0_.meta_title AS meta_title_3,
  t0_.original_route AS original_route_4,
  t0_.meta_description AS meta_description_5,
  (
    CASE t0_.type
    WHEN 'redirect_permanent' THEN
      1
    WHEN 'redirect_temporary' THEN
      2
    WHEN 'forward' THEN
      3
    ELSE
      0
    END
  ) AS sclr_6
FROM
  _route t0_
WHERE
  (
    t0_.from_url = ?
    AND t0_.enabled = 1
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
ORDER BY
  sclr_6 ASC
LIMIT
  1

SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.to_url AS to_url_2, t0_.meta_title AS meta_title_3, t0_.original_route AS original_route_4, t0_.meta_description AS meta_description_5, (CASE t0_.type WHEN 'redirect_permanent' THEN 1 WHEN 'redirect_temporary' THEN 2 WHEN 'forward' THEN 3 ELSE 0 END) AS sclr_6 FROM _route t0_ WHERE (t0_.from_url = '/volet/volet-battant/volet-battant-pvc-planeo' AND t0_.enabled = 1) AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') ORDER BY sclr_6 ASC LIMIT 1;

SELECT
  d0_.id AS id_0,
  d0_.title AS title_1,
  d0_.description AS description_2,
  d0_.price AS price_3,
  d0_.position AS position_4,
  d0_.delay AS delay_5,
  d0_.enabled AS enabled_6,
  d0_.`default` AS default_7,
  d0_.free_delivery_threshold AS free_delivery_threshold_8,
  d0_.mac_brand AS mac_brand_9,
  d0_.mac_app AS mac_app_10,
  d0_.reference AS reference_11,
  d0_.vat_type_id AS vat_type_id_12
FROM
  delivery d0_
  INNER JOIN delivery_country d2_ ON d0_.id = d2_.delivery_id
  INNER JOIN _country t1_ ON t1_.id = d2_.country_id
  AND (1)
WHERE
  (
    d0_.`default` = 1
    AND t1_.id = ?
  )
  AND (
    d0_.mac_brand = 'FX'
    AND d0_.mac_app = 'fx'
  )
ORDER BY
  d0_.position ASC
LIMIT
  1

SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.description AS description_2, d0_.price AS price_3, d0_.position AS position_4, d0_.delay AS delay_5, d0_.enabled AS enabled_6, d0_.`default` AS default_7, d0_.free_delivery_threshold AS free_delivery_threshold_8, d0_.mac_brand AS mac_brand_9, d0_.mac_app AS mac_app_10, d0_.reference AS reference_11, d0_.vat_type_id AS vat_type_id_12 FROM delivery d0_ INNER JOIN delivery_country d2_ ON d0_.id = d2_.delivery_id INNER JOIN _country t1_ ON t1_.id = d2_.country_id AND (1) WHERE (d0_.`default` = 1 AND t1_.id = 'fr') AND (d0_.mac_brand = 'FX' AND d0_.mac_app = 'fx') ORDER BY d0_.position ASC LIMIT 1;

SELECT
  t0_.name AS name_0,
  t0_.value AS value_1
FROM
  _parameter t0_
WHERE
  (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )

SELECT t0_.name AS name_0, t0_.value AS value_1 FROM _parameter t0_ WHERE (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx');

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.reference AS reference_2
FROM
  _store t0_
WHERE
  (t0_.reference = ?)
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.reference AS reference_2 FROM _store t0_ WHERE (t0_.reference = 'main_store') AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx');

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1
FROM
  _catalog t0_
  INNER JOIN _store t1_ ON t0_.store_id = t1_.id
  AND (
    t1_.mac_brand = 'FX'
    AND t1_.mac_app = 'fx'
  )
WHERE
  (
    t0_.status IN (?)
    AND t0_.publish_start <= ?
    AND (
      t0_.publish_end IS NULL
      OR t0_.publish_end >= ?
    )
    AND t1_.id = ?
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
LIMIT
  1

SELECT t0_.id AS id_0, t0_.name AS name_1 FROM _catalog t0_ INNER JOIN _store t1_ ON t0_.store_id = t1_.id AND (t1_.mac_brand = 'FX' AND t1_.mac_app = 'fx') WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 07:40:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 07:40:00') AND t1_.id = 2) AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') LIMIT 1;

SELECT
  count(DISTINCT t0_.id) AS sclr_0
FROM
  _hierarchy_to_product t0_
  INNER JOIN _product_category_hierarchy t1_ ON t0_.hierarchy_id = t1_.id
  AND (1)
  AND (
    t1_.status IN (?)
    AND t1_.publish_start <= ?
    AND (
      t1_.publish_end IS NULL
      OR t1_.publish_end >= ?
    )
  )
  INNER JOIN product_category p2_ ON t1_.category_id = p2_.id
  AND (
    p2_.mac_brand = 'FX'
    AND p2_.mac_app = 'fx'
  )
  AND (
    p2_.status IN (?)
    AND p2_.publish_start <= ?
    AND (
      p2_.publish_end IS NULL
      OR p2_.publish_end >= ?
    )
  )
  INNER JOIN _catalog t3_ ON t1_.catalog_id = t3_.id
  AND (
    t3_.mac_brand = 'FX'
    AND t3_.mac_app = 'fx'
  )
  AND (
    t3_.status IN (?)
    AND t3_.publish_start <= ?
    AND (
      t3_.publish_end IS NULL
      OR t3_.publish_end >= ?
    )
  )
  INNER JOIN product p4_ ON t0_.product_id = p4_.id
  AND (
    p4_.mac_brand = 'FX'
    AND p4_.mac_app = 'fx'
  )
  AND (
    p4_.status IN (?)
    AND p4_.publish_start <= ?
    AND (
      p4_.publish_end IS NULL
      OR p4_.publish_end >= ?
    )
  )
  LEFT JOIN product_image p5_ ON p4_.id = p5_.product_id
  AND (1)
  LEFT JOIN _file t6_ ON p5_.file_id = t6_.id
  AND (1)
  LEFT JOIN product_color_chart p7_ ON p4_.id = p7_.product_id
  AND (1)
  LEFT JOIN color_chart c8_ ON p7_.color_chart_id = c8_.id
  AND (
    c8_.mac_brand = 'FX'
    AND c8_.mac_app = 'fx'
  )
  AND (
    c8_.status IN (?)
    AND c8_.publish_start <= ?
    AND (
      c8_.publish_end IS NULL
      OR c8_.publish_end >= ?
    )
  )
  LEFT JOIN color_chart_color c9_ ON c8_.id = c9_.color_chart_id
  AND (1)
  LEFT JOIN color c10_ ON c9_.color_id = c10_.id
  AND (
    c10_.mac_brand = 'FX'
    AND c10_.mac_app = 'fx'
  )
  AND (
    c10_.status IN (?)
    AND c10_.publish_start <= ?
    AND (
      c10_.publish_end IS NULL
      OR c10_.publish_end >= ?
    )
  )
  LEFT JOIN _file t11_ ON c10_.file_id = t11_.id
  AND (1)
  LEFT JOIN product_picto p12_ ON p4_.id = p12_.product_id
  AND (1)
  LEFT JOIN picto p13_ ON p12_.picto_id = p13_.id
  AND (
    p13_.mac_brand = 'FX'
    AND p13_.mac_app = 'fx'
  )
  AND (
    p13_.status IN (?)
    AND p13_.publish_start <= ?
    AND (
      p13_.publish_end IS NULL
      OR p13_.publish_end >= ?
    )
  )
  LEFT JOIN picto_category p14_ ON p13_.picto_category_id = p14_.id
  AND (
    p14_.mac_brand = 'FX'
    AND p14_.mac_app = 'fx'
  )
  AND (
    p14_.status IN (?)
    AND p14_.publish_start <= ?
    AND (
      p14_.publish_end IS NULL
      OR p14_.publish_end >= ?
    )
  )
  LEFT JOIN product_equipment p15_ ON p4_.id = p15_.product_id
  AND (1)
  LEFT JOIN _file t16_ ON p13_.file_id = t16_.id
  AND (1)
  LEFT JOIN _file t17_ ON p15_.file_id = t17_.id
  AND (1)
WHERE
  (
    t0_.status IN (?)
    AND t0_.publish_start <= ?
    AND (
      t0_.publish_end IS NULL
      OR t0_.publish_end >= ?
    )
    AND t3_.id = ?
    AND t0_.slug = ?
  )
  AND (1)

SELECT count(DISTINCT t0_.id) AS sclr_0 FROM _hierarchy_to_product t0_ INNER JOIN _product_category_hierarchy t1_ ON t0_.hierarchy_id = t1_.id AND (1) AND (t1_.status IN ('published') AND t1_.publish_start <= '2026-03-12 07:40:00' AND (t1_.publish_end IS NULL OR t1_.publish_end >= '2026-03-12 07:40:00')) INNER JOIN product_category p2_ ON t1_.category_id = p2_.id AND (p2_.mac_brand = 'FX' AND p2_.mac_app = 'fx') AND (p2_.status IN ('published') AND p2_.publish_start <= '2026-03-12 07:40:00' AND (p2_.publish_end IS NULL OR p2_.publish_end >= '2026-03-12 07:40:00')) INNER JOIN _catalog t3_ ON t1_.catalog_id = t3_.id AND (t3_.mac_brand = 'FX' AND t3_.mac_app = 'fx') AND (t3_.status IN ('published') AND t3_.publish_start <= '2026-03-12 07:40:00' AND (t3_.publish_end IS NULL OR t3_.publish_end >= '2026-03-12 07:40:00')) INNER JOIN product p4_ ON t0_.product_id = p4_.id AND (p4_.mac_brand = 'FX' AND p4_.mac_app = 'fx') AND (p4_.status IN ('published') AND p4_.publish_start <= '2026-03-12 07:40:00' AND (p4_.publish_end IS NULL OR p4_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN product_image p5_ ON p4_.id = p5_.product_id AND (1) LEFT JOIN _file t6_ ON p5_.file_id = t6_.id AND (1) LEFT JOIN product_color_chart p7_ ON p4_.id = p7_.product_id AND (1) LEFT JOIN color_chart c8_ ON p7_.color_chart_id = c8_.id AND (c8_.mac_brand = 'FX' AND c8_.mac_app = 'fx') AND (c8_.status IN ('published') AND c8_.publish_start <= '2026-03-12 07:40:00' AND (c8_.publish_end IS NULL OR c8_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN color_chart_color c9_ ON c8_.id = c9_.color_chart_id AND (1) LEFT JOIN color c10_ ON c9_.color_id = c10_.id AND (c10_.mac_brand = 'FX' AND c10_.mac_app = 'fx') AND (c10_.status IN ('published') AND c10_.publish_start <= '2026-03-12 07:40:00' AND (c10_.publish_end IS NULL OR c10_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN _file t11_ ON c10_.file_id = t11_.id AND (1) LEFT JOIN product_picto p12_ ON p4_.id = p12_.product_id AND (1) LEFT JOIN picto p13_ ON p12_.picto_id = p13_.id AND (p13_.mac_brand = 'FX' AND p13_.mac_app = 'fx') AND (p13_.status IN ('published') AND p13_.publish_start <= '2026-03-12 07:40:00' AND (p13_.publish_end IS NULL OR p13_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN picto_category p14_ ON p13_.picto_category_id = p14_.id AND (p14_.mac_brand = 'FX' AND p14_.mac_app = 'fx') AND (p14_.status IN ('published') AND p14_.publish_start <= '2026-03-12 07:40:00' AND (p14_.publish_end IS NULL OR p14_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN product_equipment p15_ ON p4_.id = p15_.product_id AND (1) LEFT JOIN _file t16_ ON p13_.file_id = t16_.id AND (1) LEFT JOIN _file t17_ ON p15_.file_id = t17_.id AND (1) WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 07:40:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 07:40:00') AND t3_.id = 5480 AND t0_.slug = 'volets/volets-battants/volet-battant-planeo-pvc-fxfe202') AND (1);

SELECT
  DISTINCT t0_.id AS id_0
FROM
  _hierarchy_to_product t0_
  INNER JOIN _product_category_hierarchy t1_ ON t0_.hierarchy_id = t1_.id
  AND (1)
  AND (
    t1_.status IN (?)
    AND t1_.publish_start <= ?
    AND (
      t1_.publish_end IS NULL
      OR t1_.publish_end >= ?
    )
  )
  INNER JOIN product_category p2_ ON t1_.category_id = p2_.id
  AND (
    p2_.mac_brand = 'FX'
    AND p2_.mac_app = 'fx'
  )
  AND (
    p2_.status IN (?)
    AND p2_.publish_start <= ?
    AND (
      p2_.publish_end IS NULL
      OR p2_.publish_end >= ?
    )
  )
  INNER JOIN _catalog t3_ ON t1_.catalog_id = t3_.id
  AND (
    t3_.mac_brand = 'FX'
    AND t3_.mac_app = 'fx'
  )
  AND (
    t3_.status IN (?)
    AND t3_.publish_start <= ?
    AND (
      t3_.publish_end IS NULL
      OR t3_.publish_end >= ?
    )
  )
  INNER JOIN product p4_ ON t0_.product_id = p4_.id
  AND (
    p4_.mac_brand = 'FX'
    AND p4_.mac_app = 'fx'
  )
  AND (
    p4_.status IN (?)
    AND p4_.publish_start <= ?
    AND (
      p4_.publish_end IS NULL
      OR p4_.publish_end >= ?
    )
  )
  LEFT JOIN product_image p5_ ON p4_.id = p5_.product_id
  AND (1)
  LEFT JOIN _file t6_ ON p5_.file_id = t6_.id
  AND (1)
  LEFT JOIN product_color_chart p7_ ON p4_.id = p7_.product_id
  AND (1)
  LEFT JOIN color_chart c8_ ON p7_.color_chart_id = c8_.id
  AND (
    c8_.mac_brand = 'FX'
    AND c8_.mac_app = 'fx'
  )
  AND (
    c8_.status IN (?)
    AND c8_.publish_start <= ?
    AND (
      c8_.publish_end IS NULL
      OR c8_.publish_end >= ?
    )
  )
  LEFT JOIN color_chart_color c9_ ON c8_.id = c9_.color_chart_id
  AND (1)
  LEFT JOIN color c10_ ON c9_.color_id = c10_.id
  AND (
    c10_.mac_brand = 'FX'
    AND c10_.mac_app = 'fx'
  )
  AND (
    c10_.status IN (?)
    AND c10_.publish_start <= ?
    AND (
      c10_.publish_end IS NULL
      OR c10_.publish_end >= ?
    )
  )
  LEFT JOIN _file t11_ ON c10_.file_id = t11_.id
  AND (1)
  LEFT JOIN product_picto p12_ ON p4_.id = p12_.product_id
  AND (1)
  LEFT JOIN picto p13_ ON p12_.picto_id = p13_.id
  AND (
    p13_.mac_brand = 'FX'
    AND p13_.mac_app = 'fx'
  )
  AND (
    p13_.status IN (?)
    AND p13_.publish_start <= ?
    AND (
      p13_.publish_end IS NULL
      OR p13_.publish_end >= ?
    )
  )
  LEFT JOIN picto_category p14_ ON p13_.picto_category_id = p14_.id
  AND (
    p14_.mac_brand = 'FX'
    AND p14_.mac_app = 'fx'
  )
  AND (
    p14_.status IN (?)
    AND p14_.publish_start <= ?
    AND (
      p14_.publish_end IS NULL
      OR p14_.publish_end >= ?
    )
  )
  LEFT JOIN product_equipment p15_ ON p4_.id = p15_.product_id
  AND (1)
  LEFT JOIN _file t16_ ON p13_.file_id = t16_.id
  AND (1)
  LEFT JOIN _file t17_ ON p15_.file_id = t17_.id
  AND (1)
WHERE
  (
    t0_.status IN (?)
    AND t0_.publish_start <= ?
    AND (
      t0_.publish_end IS NULL
      OR t0_.publish_end >= ?
    )
    AND t3_.id = ?
    AND t0_.slug = ?
  )
  AND (1)
LIMIT
  1

SELECT DISTINCT t0_.id AS id_0 FROM _hierarchy_to_product t0_ INNER JOIN _product_category_hierarchy t1_ ON t0_.hierarchy_id = t1_.id AND (1) AND (t1_.status IN ('published') AND t1_.publish_start <= '2026-03-12 07:40:00' AND (t1_.publish_end IS NULL OR t1_.publish_end >= '2026-03-12 07:40:00')) INNER JOIN product_category p2_ ON t1_.category_id = p2_.id AND (p2_.mac_brand = 'FX' AND p2_.mac_app = 'fx') AND (p2_.status IN ('published') AND p2_.publish_start <= '2026-03-12 07:40:00' AND (p2_.publish_end IS NULL OR p2_.publish_end >= '2026-03-12 07:40:00')) INNER JOIN _catalog t3_ ON t1_.catalog_id = t3_.id AND (t3_.mac_brand = 'FX' AND t3_.mac_app = 'fx') AND (t3_.status IN ('published') AND t3_.publish_start <= '2026-03-12 07:40:00' AND (t3_.publish_end IS NULL OR t3_.publish_end >= '2026-03-12 07:40:00')) INNER JOIN product p4_ ON t0_.product_id = p4_.id AND (p4_.mac_brand = 'FX' AND p4_.mac_app = 'fx') AND (p4_.status IN ('published') AND p4_.publish_start <= '2026-03-12 07:40:00' AND (p4_.publish_end IS NULL OR p4_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN product_image p5_ ON p4_.id = p5_.product_id AND (1) LEFT JOIN _file t6_ ON p5_.file_id = t6_.id AND (1) LEFT JOIN product_color_chart p7_ ON p4_.id = p7_.product_id AND (1) LEFT JOIN color_chart c8_ ON p7_.color_chart_id = c8_.id AND (c8_.mac_brand = 'FX' AND c8_.mac_app = 'fx') AND (c8_.status IN ('published') AND c8_.publish_start <= '2026-03-12 07:40:00' AND (c8_.publish_end IS NULL OR c8_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN color_chart_color c9_ ON c8_.id = c9_.color_chart_id AND (1) LEFT JOIN color c10_ ON c9_.color_id = c10_.id AND (c10_.mac_brand = 'FX' AND c10_.mac_app = 'fx') AND (c10_.status IN ('published') AND c10_.publish_start <= '2026-03-12 07:40:00' AND (c10_.publish_end IS NULL OR c10_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN _file t11_ ON c10_.file_id = t11_.id AND (1) LEFT JOIN product_picto p12_ ON p4_.id = p12_.product_id AND (1) LEFT JOIN picto p13_ ON p12_.picto_id = p13_.id AND (p13_.mac_brand = 'FX' AND p13_.mac_app = 'fx') AND (p13_.status IN ('published') AND p13_.publish_start <= '2026-03-12 07:40:00' AND (p13_.publish_end IS NULL OR p13_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN picto_category p14_ ON p13_.picto_category_id = p14_.id AND (p14_.mac_brand = 'FX' AND p14_.mac_app = 'fx') AND (p14_.status IN ('published') AND p14_.publish_start <= '2026-03-12 07:40:00' AND (p14_.publish_end IS NULL OR p14_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN product_equipment p15_ ON p4_.id = p15_.product_id AND (1) LEFT JOIN _file t16_ ON p13_.file_id = t16_.id AND (1) LEFT JOIN _file t17_ ON p15_.file_id = t17_.id AND (1) WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 07:40:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 07:40:00') AND t3_.id = 5480 AND t0_.slug = 'volets/volets-battants/volet-battant-planeo-pvc-fxfe202') AND (1) LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.slug AS slug_1,
  t0_.title AS title_2,
  t0_.subtitle AS subtitle_3,
  t1_.id AS id_4,
  t1_.slug AS slug_5,
  p2_.id AS id_6,
  p2_.title AS title_7,
  p2_.subtitle AS subtitle_8,
  p2_.description AS description_9,
  p2_.long_description AS long_description_10,
  p2_.green_argument AS green_argument_11,
  p2_.features AS features_12,
  p2_.protection AS protection_13,
  p2_.video AS video_14,
  p2_.dickson_code AS dickson_code_15,
  p3_.id AS id_16,
  p3_.description AS description_17,
  t4_.id AS id_18,
  t4_.name AS name_19,
  t4_.path AS path_20,
  p5_.id AS id_21,
  c6_.id AS id_22,
  c6_.title AS title_23,
  c6_.description AS description_24,
  c7_.id AS id_25,
  c8_.id AS id_26,
  c8_.title AS title_27,
  c8_.code_hexa AS code_hexa_28,
  c8_.code_rgb AS code_rgb_29,
  c8_.color_code AS color_code_30,
  t9_.id AS id_31,
  t9_.path AS path_32,
  p10_.id AS id_33,
  p11_.id AS id_34,
  p11_.title AS title_35,
  p11_.link AS link_36,
  p11_.description AS description_37,
  p11_.target_blank AS target_blank_38,
  p12_.id AS id_39,
  p12_.reference AS reference_40,
  p13_.id AS id_41,
  p13_.link AS link_42,
  p13_.title AS title_43,
  t14_.id AS id_44,
  t14_.name AS name_45,
  t14_.path AS path_46,
  t15_.id AS id_47,
  t15_.name AS name_48,
  t15_.path AS path_49
FROM
  _hierarchy_to_product t0_
  INNER JOIN _product_category_hierarchy t1_ ON t0_.hierarchy_id = t1_.id
  AND (1)
  AND (
    t1_.status IN (?)
    AND t1_.publish_start <= ?
    AND (
      t1_.publish_end IS NULL
      OR t1_.publish_end >= ?
    )
  )
  INNER JOIN product_category p16_ ON t1_.category_id = p16_.id
  AND (
    p16_.mac_brand = 'FX'
    AND p16_.mac_app = 'fx'
  )
  AND (
    p16_.status IN (?)
    AND p16_.publish_start <= ?
    AND (
      p16_.publish_end IS NULL
      OR p16_.publish_end >= ?
    )
  )
  INNER JOIN _catalog t17_ ON t1_.catalog_id = t17_.id
  AND (
    t17_.mac_brand = 'FX'
    AND t17_.mac_app = 'fx'
  )
  AND (
    t17_.status IN (?)
    AND t17_.publish_start <= ?
    AND (
      t17_.publish_end IS NULL
      OR t17_.publish_end >= ?
    )
  )
  INNER JOIN product p2_ ON t0_.product_id = p2_.id
  AND (
    p2_.mac_brand = 'FX'
    AND p2_.mac_app = 'fx'
  )
  AND (
    p2_.status IN (?)
    AND p2_.publish_start <= ?
    AND (
      p2_.publish_end IS NULL
      OR p2_.publish_end >= ?
    )
  )
  LEFT JOIN product_image p3_ ON p2_.id = p3_.product_id
  AND (1)
  LEFT JOIN _file t4_ ON p3_.file_id = t4_.id
  AND (1)
  LEFT JOIN product_color_chart p5_ ON p2_.id = p5_.product_id
  AND (1)
  LEFT JOIN color_chart c6_ ON p5_.color_chart_id = c6_.id
  AND (
    c6_.mac_brand = 'FX'
    AND c6_.mac_app = 'fx'
  )
  AND (
    c6_.status IN (?)
    AND c6_.publish_start <= ?
    AND (
      c6_.publish_end IS NULL
      OR c6_.publish_end >= ?
    )
  )
  LEFT JOIN color_chart_color c7_ ON c6_.id = c7_.color_chart_id
  AND (1)
  LEFT JOIN color c8_ ON c7_.color_id = c8_.id
  AND (
    c8_.mac_brand = 'FX'
    AND c8_.mac_app = 'fx'
  )
  AND (
    c8_.status IN (?)
    AND c8_.publish_start <= ?
    AND (
      c8_.publish_end IS NULL
      OR c8_.publish_end >= ?
    )
  )
  LEFT JOIN _file t9_ ON c8_.file_id = t9_.id
  AND (1)
  LEFT JOIN product_picto p10_ ON p2_.id = p10_.product_id
  AND (1)
  LEFT JOIN picto p11_ ON p10_.picto_id = p11_.id
  AND (
    p11_.mac_brand = 'FX'
    AND p11_.mac_app = 'fx'
  )
  AND (
    p11_.status IN (?)
    AND p11_.publish_start <= ?
    AND (
      p11_.publish_end IS NULL
      OR p11_.publish_end >= ?
    )
  )
  LEFT JOIN picto_category p12_ ON p11_.picto_category_id = p12_.id
  AND (
    p12_.mac_brand = 'FX'
    AND p12_.mac_app = 'fx'
  )
  AND (
    p12_.status IN (?)
    AND p12_.publish_start <= ?
    AND (
      p12_.publish_end IS NULL
      OR p12_.publish_end >= ?
    )
  )
  LEFT JOIN product_equipment p13_ ON p2_.id = p13_.product_id
  AND (1)
  LEFT JOIN _file t14_ ON p11_.file_id = t14_.id
  AND (1)
  LEFT JOIN _file t15_ ON p13_.file_id = t15_.id
  AND (1)
WHERE
  (
    t0_.status IN (?)
    AND t0_.publish_start <= ?
    AND (
      t0_.publish_end IS NULL
      OR t0_.publish_end >= ?
    )
    AND t17_.id = ?
    AND t0_.slug = ?
    AND t0_.id IN (?)
  )
  AND (1)
ORDER BY
  p3_.position ASC,
  p5_.position ASC,
  c7_.position ASC,
  p10_.position ASC,
  p13_.position ASC

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.title AS title_2, t0_.subtitle AS subtitle_3, t1_.id AS id_4, t1_.slug AS slug_5, p2_.id AS id_6, p2_.title AS title_7, p2_.subtitle AS subtitle_8, p2_.description AS description_9, p2_.long_description AS long_description_10, p2_.green_argument AS green_argument_11, p2_.features AS features_12, p2_.protection AS protection_13, p2_.video AS video_14, p2_.dickson_code AS dickson_code_15, p3_.id AS id_16, p3_.description AS description_17, t4_.id AS id_18, t4_.name AS name_19, t4_.path AS path_20, p5_.id AS id_21, c6_.id AS id_22, c6_.title AS title_23, c6_.description AS description_24, c7_.id AS id_25, c8_.id AS id_26, c8_.title AS title_27, c8_.code_hexa AS code_hexa_28, c8_.code_rgb AS code_rgb_29, c8_.color_code AS color_code_30, t9_.id AS id_31, t9_.path AS path_32, p10_.id AS id_33, p11_.id AS id_34, p11_.title AS title_35, p11_.link AS link_36, p11_.description AS description_37, p11_.target_blank AS target_blank_38, p12_.id AS id_39, p12_.reference AS reference_40, p13_.id AS id_41, p13_.link AS link_42, p13_.title AS title_43, t14_.id AS id_44, t14_.name AS name_45, t14_.path AS path_46, t15_.id AS id_47, t15_.name AS name_48, t15_.path AS path_49 FROM _hierarchy_to_product t0_ INNER JOIN _product_category_hierarchy t1_ ON t0_.hierarchy_id = t1_.id AND (1) AND (t1_.status IN ('published') AND t1_.publish_start <= '2026-03-12 07:40:00' AND (t1_.publish_end IS NULL OR t1_.publish_end >= '2026-03-12 07:40:00')) INNER JOIN product_category p16_ ON t1_.category_id = p16_.id AND (p16_.mac_brand = 'FX' AND p16_.mac_app = 'fx') AND (p16_.status IN ('published') AND p16_.publish_start <= '2026-03-12 07:40:00' AND (p16_.publish_end IS NULL OR p16_.publish_end >= '2026-03-12 07:40:00')) INNER JOIN _catalog t17_ ON t1_.catalog_id = t17_.id AND (t17_.mac_brand = 'FX' AND t17_.mac_app = 'fx') AND (t17_.status IN ('published') AND t17_.publish_start <= '2026-03-12 07:40:00' AND (t17_.publish_end IS NULL OR t17_.publish_end >= '2026-03-12 07:40:00')) INNER JOIN product p2_ ON t0_.product_id = p2_.id AND (p2_.mac_brand = 'FX' AND p2_.mac_app = 'fx') AND (p2_.status IN ('published') AND p2_.publish_start <= '2026-03-12 07:40:00' AND (p2_.publish_end IS NULL OR p2_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN product_image p3_ ON p2_.id = p3_.product_id AND (1) LEFT JOIN _file t4_ ON p3_.file_id = t4_.id AND (1) LEFT JOIN product_color_chart p5_ ON p2_.id = p5_.product_id AND (1) LEFT JOIN color_chart c6_ ON p5_.color_chart_id = c6_.id AND (c6_.mac_brand = 'FX' AND c6_.mac_app = 'fx') AND (c6_.status IN ('published') AND c6_.publish_start <= '2026-03-12 07:40:00' AND (c6_.publish_end IS NULL OR c6_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN color_chart_color c7_ ON c6_.id = c7_.color_chart_id AND (1) LEFT JOIN color c8_ ON c7_.color_id = c8_.id AND (c8_.mac_brand = 'FX' AND c8_.mac_app = 'fx') AND (c8_.status IN ('published') AND c8_.publish_start <= '2026-03-12 07:40:00' AND (c8_.publish_end IS NULL OR c8_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN _file t9_ ON c8_.file_id = t9_.id AND (1) LEFT JOIN product_picto p10_ ON p2_.id = p10_.product_id AND (1) LEFT JOIN picto p11_ ON p10_.picto_id = p11_.id AND (p11_.mac_brand = 'FX' AND p11_.mac_app = 'fx') AND (p11_.status IN ('published') AND p11_.publish_start <= '2026-03-12 07:40:00' AND (p11_.publish_end IS NULL OR p11_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN picto_category p12_ ON p11_.picto_category_id = p12_.id AND (p12_.mac_brand = 'FX' AND p12_.mac_app = 'fx') AND (p12_.status IN ('published') AND p12_.publish_start <= '2026-03-12 07:40:00' AND (p12_.publish_end IS NULL OR p12_.publish_end >= '2026-03-12 07:40:00')) LEFT JOIN product_equipment p13_ ON p2_.id = p13_.product_id AND (1) LEFT JOIN _file t14_ ON p11_.file_id = t14_.id AND (1) LEFT JOIN _file t15_ ON p13_.file_id = t15_.id AND (1) WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 07:40:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 07:40:00') AND t17_.id = 5480 AND t0_.slug = 'volets/volets-battants/volet-battant-planeo-pvc-fxfe202' AND t0_.id IN (8791493)) AND (1) ORDER BY p3_.position ASC, p5_.position ASC, c7_.position ASC, p10_.position ASC, p13_.position ASC;

SELECT
  t0_.id AS id_0,
  t0_.depth AS depth_1,
  t0_.slug AS slug_2,
  t0_.title AS title_3,
  t0_.publish_start AS publish_start_4,
  t0_.publish_end AS publish_end_5,
  t0_.status AS status_6,
  t1_.id AS id_7,
  t1_.slug AS slug_8,
  p2_.id AS id_9,
  p2_.title AS title_10
FROM
  _product_category_hierarchy t0_
  LEFT JOIN _product_category_hierarchy t1_ ON t0_.parent_id = t1_.id
  AND (1)
  INNER JOIN product_category p2_ ON t0_.category_id = p2_.id
  AND (
    p2_.mac_brand = 'FX'
    AND p2_.mac_app = 'fx'
  )
  LEFT JOIN _product_category_hierarchy_closure t3_ ON t0_.id = t3_.descendant
  AND (1)
  LEFT JOIN _product_category_hierarchy t4_ ON t3_.ancestor = t4_.id
  AND (1)
  LEFT JOIN _product_category_hierarchy_closure t5_ ON t0_.id = t5_.ancestor
  AND (1)
  LEFT JOIN _product_category_hierarchy t6_ ON t5_.descendant = t6_.id
  AND (1)
WHERE
  (
    t0_.catalog_id = ?
    AND t0_.depth <= ?
    AND (
      t4_.slug = ?
      OR t6_.slug = ?
    )
  )
  AND (1)
ORDER BY
  t0_.depth ASC,
  t0_.position ASC