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 = '/porte-entree' 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 04:04:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 04:04:00') AND t1_.id = 2) AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') LIMIT 1;

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_.slug AS slug_10,
  p2_.title AS title_11,
  p2_.seo_heading AS seo_heading_12,
  p2_.description AS description_13,
  p2_.advice_line AS advice_line_14,
  p2_.baseline AS baseline_15,
  p2_.dickson AS dickson_16,
  p2_.equipment_link AS equipment_link_17,
  t3_.id AS id_18,
  t3_.path AS path_19,
  t4_.id AS id_20,
  t4_.path AS path_21
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 _file t3_ ON p2_.brochure_id = t3_.id
  AND (1)
  LEFT JOIN _file t4_ ON p2_.file_id = t4_.id
  AND (1)
  LEFT JOIN _product_category_hierarchy_closure t5_ ON t0_.id = t5_.descendant
  AND (1)
  LEFT JOIN _product_category_hierarchy t6_ ON t5_.ancestor = t6_.id
  AND (1)
  LEFT JOIN _product_category_hierarchy_closure t7_ ON t0_.id = t7_.ancestor
  AND (1)
  LEFT JOIN _product_category_hierarchy t8_ ON t7_.descendant = t8_.id
  AND (1)
WHERE
  (
    t0_.catalog_id = ?
    AND t0_.depth <= ?
    AND (
      t6_.slug = ?
      OR t8_.slug = ?
    )
  )
  AND (1)
ORDER BY
  t0_.depth ASC,
  t0_.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_.slug AS slug_10, p2_.title AS title_11, p2_.seo_heading AS seo_heading_12, p2_.description AS description_13, p2_.advice_line AS advice_line_14, p2_.baseline AS baseline_15, p2_.dickson AS dickson_16, p2_.equipment_link AS equipment_link_17, t3_.id AS id_18, t3_.path AS path_19, t4_.id AS id_20, t4_.path AS path_21 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 _file t3_ ON p2_.brochure_id = t3_.id AND (1) LEFT JOIN _file t4_ ON p2_.file_id = t4_.id AND (1) LEFT JOIN _product_category_hierarchy_closure t5_ ON t0_.id = t5_.descendant AND (1) LEFT JOIN _product_category_hierarchy t6_ ON t5_.ancestor = t6_.id AND (1) LEFT JOIN _product_category_hierarchy_closure t7_ ON t0_.id = t7_.ancestor AND (1) LEFT JOIN _product_category_hierarchy t8_ ON t7_.descendant = t8_.id AND (1) WHERE (t0_.catalog_id = 5480 AND t0_.depth <= 2 AND (t6_.slug = 'portes-d-entree' OR t8_.slug = 'portes-d-entree')) AND (1) ORDER BY t0_.depth ASC, t0_.position ASC;

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.position AS position_1
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 >= ?
    )
  )
  LEFT JOIN _product_category_hierarchy_closure t2_ ON t1_.id = t2_.descendant
  AND (1)
  LEFT JOIN _product_category_hierarchy t3_ ON t2_.ancestor = t3_.id
  AND (1)
  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 >= ?
    )
  )
WHERE
  (
    t0_.status IN (?)
    AND t0_.publish_start <= ?
    AND (
      t0_.publish_end IS NULL
      OR t0_.publish_end >= ?
    )
    AND t3_.id = ?
  )
  AND (1)
ORDER BY
  t0_.position ASC

SELECT DISTINCT t0_.id AS id_0, t0_.position AS position_1 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 04:04:00' AND (t1_.publish_end IS NULL OR t1_.publish_end >= '2026-03-12 04:04:00')) LEFT JOIN _product_category_hierarchy_closure t2_ ON t1_.id = t2_.descendant AND (1) LEFT JOIN _product_category_hierarchy t3_ ON t2_.ancestor = t3_.id AND (1) AND (t3_.status IN ('published') AND t3_.publish_start <= '2026-03-12 04:04:00' AND (t3_.publish_end IS NULL OR t3_.publish_end >= '2026-03-12 04:04: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 04:04:00' AND (p4_.publish_end IS NULL OR p4_.publish_end >= '2026-03-12 04:04:00')) WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 04:04:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 04:04:00') AND t3_.id = 1385886) AND (1) ORDER BY t0_.position ASC;

SELECT
  t0_.id AS id_0,
  t0_.slug AS slug_1,
  t0_.id AS id_2,
  t0_.slug AS slug_3,
  t0_.position AS position_4,
  p1_.id AS id_5
FROM
  _hierarchy_to_product t0_
  INNER JOIN _product_category_hierarchy t2_ ON t0_.hierarchy_id = t2_.id
  AND (1)
  AND (
    t2_.status IN (?)
    AND t2_.publish_start <= ?
    AND (
      t2_.publish_end IS NULL
      OR t2_.publish_end >= ?
    )
  )
  LEFT JOIN _product_category_hierarchy_closure t3_ ON t2_.id = t3_.descendant
  AND (1)
  LEFT JOIN _product_category_hierarchy t4_ ON t3_.ancestor = t4_.id
  AND (1)
  AND (
    t4_.status IN (?)
    AND t4_.publish_start <= ?
    AND (
      t4_.publish_end IS NULL
      OR t4_.publish_end >= ?
    )
  )
  INNER JOIN product p1_ ON t0_.product_id = p1_.id
  AND (
    p1_.mac_brand = 'FX'
    AND p1_.mac_app = 'fx'
  )
  AND (
    p1_.status IN (?)
    AND p1_.publish_start <= ?
    AND (
      p1_.publish_end IS NULL
      OR p1_.publish_end >= ?
    )
  )
WHERE
  (
    t0_.status IN (?)
    AND t0_.publish_start <= ?
    AND (
      t0_.publish_end IS NULL
      OR t0_.publish_end >= ?
    )
    AND t4_.id = ?
    AND t0_.id IN (?)
  )
  AND (1)
ORDER BY
  t0_.position ASC

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.id AS id_2, t0_.slug AS slug_3, t0_.position AS position_4, p1_.id AS id_5 FROM _hierarchy_to_product t0_ INNER JOIN _product_category_hierarchy t2_ ON t0_.hierarchy_id = t2_.id AND (1) AND (t2_.status IN ('published') AND t2_.publish_start <= '2026-03-12 04:04:00' AND (t2_.publish_end IS NULL OR t2_.publish_end >= '2026-03-12 04:04:00')) LEFT JOIN _product_category_hierarchy_closure t3_ ON t2_.id = t3_.descendant AND (1) LEFT JOIN _product_category_hierarchy t4_ ON t3_.ancestor = t4_.id AND (1) AND (t4_.status IN ('published') AND t4_.publish_start <= '2026-03-12 04:04:00' AND (t4_.publish_end IS NULL OR t4_.publish_end >= '2026-03-12 04:04:00')) INNER JOIN product p1_ ON t0_.product_id = p1_.id AND (p1_.mac_brand = 'FX' AND p1_.mac_app = 'fx') AND (p1_.status IN ('published') AND p1_.publish_start <= '2026-03-12 04:04:00' AND (p1_.publish_end IS NULL OR p1_.publish_end >= '2026-03-12 04:04:00')) WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 04:04:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 04:04:00') AND t4_.id = 1385886 AND t0_.id IN (8791431, 8791436, 8791430, 8791428)) AND (1) ORDER BY t0_.position ASC;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.position AS position_2,
  c0_.mac_brand AS mac_brand_3,
  c0_.mac_app AS mac_app_4,
  c0_.reference AS reference_5,
  c0_.publish_start AS publish_start_6,
  c0_.publish_end AS publish_end_7,
  c0_.status AS status_8,
  c1_.id AS id_9,
  c1_.title AS title_10,
  c1_.type AS type_11,
  c1_.unit AS unit_12,
  c1_.position AS position_13,
  c1_.mac_brand AS mac_brand_14,
  c1_.mac_app AS mac_app_15,
  c1_.reference AS reference_16,
  c2_.id AS id_17,
  c2_.value AS value_18,
  c2_.value2 AS value2_19
FROM
  criterion c0_
  INNER JOIN criterion_category c1_ ON c0_.criterion_category_id = c1_.id
  AND (
    c1_.mac_brand = 'FX'
    AND c1_.mac_app = 'fx'
  )
  INNER JOIN criterion_product_value c2_ ON c0_.id = c2_.criterion_id
  AND (1)
  INNER JOIN product p3_ ON c2_.product_id = p3_.id
  AND (
    p3_.mac_brand = 'FX'
    AND p3_.mac_app = 'fx'
  )
  AND (
    p3_.id IN (?)
  )
WHERE
  (
    c0_.mac_brand = 'FX'
    AND c0_.mac_app = 'fx'
  )
ORDER BY
  c1_.position ASC,
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.position AS position_2, c0_.mac_brand AS mac_brand_3, c0_.mac_app AS mac_app_4, c0_.reference AS reference_5, c0_.publish_start AS publish_start_6, c0_.publish_end AS publish_end_7, c0_.status AS status_8, c1_.id AS id_9, c1_.title AS title_10, c1_.type AS type_11, c1_.unit AS unit_12, c1_.position AS position_13, c1_.mac_brand AS mac_brand_14, c1_.mac_app AS mac_app_15, c1_.reference AS reference_16, c2_.id AS id_17, c2_.value AS value_18, c2_.value2 AS value2_19 FROM criterion c0_ INNER JOIN criterion_category c1_ ON c0_.criterion_category_id = c1_.id AND (c1_.mac_brand = 'FX' AND c1_.mac_app = 'fx') INNER JOIN criterion_product_value c2_ ON c0_.id = c2_.criterion_id AND (1) INNER JOIN product p3_ ON c2_.product_id = p3_.id AND (p3_.mac_brand = 'FX' AND p3_.mac_app = 'fx') AND (p3_.id IN (2242, 2243, 2240, 20064)) WHERE (c0_.mac_brand = 'FX' AND c0_.mac_app = 'fx') ORDER BY c1_.position ASC, c0_.position ASC;

SELECT
  DISTINCT t0_.id AS id_0,
  t0_.position AS position_1
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 >= ?
    )
  )
  LEFT JOIN _product_category_hierarchy_closure t2_ ON t1_.id = t2_.descendant
  AND (1)
  LEFT JOIN _product_category_hierarchy t3_ ON t2_.ancestor = t3_.id
  AND (1)
  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 criterion_product_value c7_ ON p4_.id = c7_.product_id
  AND (1)
  LEFT JOIN criterion c8_ ON c7_.criterion_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 >= ?
    )
  )
WHERE
  (
    t0_.status IN (?)
    AND t0_.publish_start <= ?
    AND (
      t0_.publish_end IS NULL
      OR t0_.publish_end >= ?
    )
    AND t3_.id = ?
  )
  AND (1)
ORDER BY
  t0_.position ASC

SELECT DISTINCT t0_.id AS id_0, t0_.position AS position_1 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 04:04:00' AND (t1_.publish_end IS NULL OR t1_.publish_end >= '2026-03-12 04:04:00')) LEFT JOIN _product_category_hierarchy_closure t2_ ON t1_.id = t2_.descendant AND (1) LEFT JOIN _product_category_hierarchy t3_ ON t2_.ancestor = t3_.id AND (1) AND (t3_.status IN ('published') AND t3_.publish_start <= '2026-03-12 04:04:00' AND (t3_.publish_end IS NULL OR t3_.publish_end >= '2026-03-12 04:04: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 04:04:00' AND (p4_.publish_end IS NULL OR p4_.publish_end >= '2026-03-12 04:04: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 criterion_product_value c7_ ON p4_.id = c7_.product_id AND (1) LEFT JOIN criterion c8_ ON c7_.criterion_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 04:04:00' AND (c8_.publish_end IS NULL OR c8_.publish_end >= '2026-03-12 04:04:00')) WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 04:04:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 04:04:00') AND t3_.id = 1385886) AND (1) ORDER BY t0_.position ASC;

SELECT
  t0_.id AS id_0,
  t0_.slug AS slug_1,
  t0_.id AS id_2,
  t0_.slug AS slug_3,
  t0_.title AS title_4,
  p1_.id AS id_5,
  p1_.slug AS slug_6,
  p1_.title AS title_7,
  p2_.id AS id_8,
  p2_.description AS description_9,
  t3_.id AS id_10,
  t3_.path AS path_11,
  c4_.id AS id_12,
  c4_.value AS value_13,
  c4_.value2 AS value2_14,
  c5_.id AS id_15
FROM
  _hierarchy_to_product t0_
  INNER JOIN _product_category_hierarchy t6_ ON t0_.hierarchy_id = t6_.id
  AND (1)
  AND (
    t6_.status IN (?)
    AND t6_.publish_start <= ?
    AND (
      t6_.publish_end IS NULL
      OR t6_.publish_end >= ?
    )
  )
  LEFT JOIN _product_category_hierarchy_closure t7_ ON t6_.id = t7_.descendant
  AND (1)
  LEFT JOIN _product_category_hierarchy t8_ ON t7_.ancestor = t8_.id
  AND (1)
  AND (
    t8_.status IN (?)
    AND t8_.publish_start <= ?
    AND (
      t8_.publish_end IS NULL
      OR t8_.publish_end >= ?
    )
  )
  INNER JOIN product p1_ ON t0_.product_id = p1_.id
  AND (
    p1_.mac_brand = 'FX'
    AND p1_.mac_app = 'fx'
  )
  AND (
    p1_.status IN (?)
    AND p1_.publish_start <= ?
    AND (
      p1_.publish_end IS NULL
      OR p1_.publish_end >= ?
    )
  )
  LEFT JOIN product_image p2_ ON p1_.id = p2_.product_id
  AND (1)
  LEFT JOIN _file t3_ ON p2_.file_id = t3_.id
  AND (1)
  LEFT JOIN criterion_product_value c4_ ON p1_.id = c4_.product_id
  AND (1)
  LEFT JOIN criterion c5_ ON c4_.criterion_id = c5_.id
  AND (
    c5_.mac_brand = 'FX'
    AND c5_.mac_app = 'fx'
  )
  AND (
    c5_.status IN (?)
    AND c5_.publish_start <= ?
    AND (
      c5_.publish_end IS NULL
      OR c5_.publish_end >= ?
    )
  )
WHERE
  (
    t0_.status IN (?)
    AND t0_.publish_start <= ?
    AND (
      t0_.publish_end IS NULL
      OR t0_.publish_end >= ?
    )
    AND t8_.id = ?
    AND t0_.id IN (?)
  )
  AND (1)
ORDER BY
  t0_.position ASC,
  p2_.position ASC

SELECT t0_.id AS id_0, t0_.slug AS slug_1, t0_.id AS id_2, t0_.slug AS slug_3, t0_.title AS title_4, p1_.id AS id_5, p1_.slug AS slug_6, p1_.title AS title_7, p2_.id AS id_8, p2_.description AS description_9, t3_.id AS id_10, t3_.path AS path_11, c4_.id AS id_12, c4_.value AS value_13, c4_.value2 AS value2_14, c5_.id AS id_15 FROM _hierarchy_to_product t0_ INNER JOIN _product_category_hierarchy t6_ ON t0_.hierarchy_id = t6_.id AND (1) AND (t6_.status IN ('published') AND t6_.publish_start <= '2026-03-12 04:04:00' AND (t6_.publish_end IS NULL OR t6_.publish_end >= '2026-03-12 04:04:00')) LEFT JOIN _product_category_hierarchy_closure t7_ ON t6_.id = t7_.descendant AND (1) LEFT JOIN _product_category_hierarchy t8_ ON t7_.ancestor = t8_.id AND (1) AND (t8_.status IN ('published') AND t8_.publish_start <= '2026-03-12 04:04:00' AND (t8_.publish_end IS NULL OR t8_.publish_end >= '2026-03-12 04:04:00')) INNER JOIN product p1_ ON t0_.product_id = p1_.id AND (p1_.mac_brand = 'FX' AND p1_.mac_app = 'fx') AND (p1_.status IN ('published') AND p1_.publish_start <= '2026-03-12 04:04:00' AND (p1_.publish_end IS NULL OR p1_.publish_end >= '2026-03-12 04:04:00')) LEFT JOIN product_image p2_ ON p1_.id = p2_.product_id AND (1) LEFT JOIN _file t3_ ON p2_.file_id = t3_.id AND (1) LEFT JOIN criterion_product_value c4_ ON p1_.id = c4_.product_id AND (1) LEFT JOIN criterion c5_ ON c4_.criterion_id = c5_.id AND (c5_.mac_brand = 'FX' AND c5_.mac_app = 'fx') AND (c5_.status IN ('published') AND c5_.publish_start <= '2026-03-12 04:04:00' AND (c5_.publish_end IS NULL OR c5_.publish_end >= '2026-03-12 04:04:00')) WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 04:04:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 04:04:00') AND t8_.id = 1385886 AND t0_.id IN (8791431, 8791436, 8791430, 8791428)) AND (1) ORDER BY t0_.position ASC, p2_.position ASC;

SELECT
  t0_.id AS id_0,
  t0_.original_route AS original_route_1,
  t0_.from_url AS from_url_2,
  t0_.to_url AS to_url_3,
  t0_.type AS type_4
FROM
  _route t0_
WHERE
  (
    t0_.to_url = ?
    AND t0_.enabled = 1
    AND t0_.type = ?
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
LIMIT
  1

SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = '.franciaflex.com/index.php/produit/portes-d-entree/portes-d-entree-pvc/porte-d-entree-pvc-contemporaine-fxme403' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.original_route AS original_route_1,
  t0_.from_url AS from_url_2,
  t0_.to_url AS to_url_3,
  t0_.type AS type_4
FROM
  _route t0_
WHERE
  (
    t0_.to_url = ?
    AND t0_.enabled = 1
    AND t0_.type = ?
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
LIMIT
  1

SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = '.franciaflex.com/index.php/produit/portes-d-entree/portes-d-entree-pvc/porte-de-service-pvc-fxme404' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.original_route AS original_route_1,
  t0_.from_url AS from_url_2,
  t0_.to_url AS to_url_3,
  t0_.type AS type_4
FROM
  _route t0_
WHERE
  (
    t0_.to_url = ?
    AND t0_.enabled = 1
    AND t0_.type = ?
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
LIMIT
  1

SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = '.franciaflex.com/index.php/produit/portes-d-entree/portes-d-entree-pvc/porte-d-entree-pvc-classique-fxme401' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.original_route AS original_route_1,
  t0_.from_url AS from_url_2,
  t0_.to_url AS to_url_3,
  t0_.type AS type_4
FROM
  _route t0_
WHERE
  (
    t0_.to_url = ?
    AND t0_.enabled = 1
    AND t0_.type = ?
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
LIMIT
  1

SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = '.franciaflex.com/index.php/produit/portes-d-entree/portes-d-entree-aluminium/porte-d-entree-aluminium-monobloc-' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.original_route AS original_route_1,
  t0_.from_url AS from_url_2,
  t0_.to_url AS to_url_3,
  t0_.type AS type_4
FROM
  _route t0_
WHERE
  (
    t0_.to_url = ?
    AND t0_.enabled = 1
    AND t0_.type = ?
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
LIMIT
  1

SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = '.franciaflex.com/index.php/prescripteurs' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.original_route AS original_route_1,
  t0_.from_url AS from_url_2,
  t0_.to_url AS to_url_3,
  t0_.type AS type_4
FROM
  _route t0_
WHERE
  (
    t0_.to_url = ?
    AND t0_.enabled = 1
    AND t0_.type = ?
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
LIMIT
  1

SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = '.franciaflex.com/index.php/professionnels' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.original_route AS original_route_1,
  t0_.from_url AS from_url_2,
  t0_.to_url AS to_url_3,
  t0_.type AS type_4
FROM
  _route t0_
WHERE
  (
    t0_.to_url = ?
    AND t0_.enabled = 1
    AND t0_.type = ?
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
LIMIT
  1

SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = '.franciaflex.com/index.php/contact?lead_activity%5Bprofile%5D=lead_activity.profile.individual&lead_activity%5Btype%5D=lead_activity.type.quote_request' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') LIMIT 1;