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 = '/' 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
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.delay AS delay_2,
  s0_.slug AS slug_3,
  s0_.mac_brand AS mac_brand_4,
  s0_.mac_app AS mac_app_5,
  s0_.reference AS reference_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  s0_.publish_start AS publish_start_9,
  s0_.publish_end AS publish_end_10,
  s0_.status AS status_11,
  s1_.id AS id_12,
  s1_.title AS title_13,
  s1_.slug AS slug_14,
  s1_.link AS link_15,
  s1_.position AS position_16,
  s1_.is_target_blank AS is_target_blank_17,
  s1_.alternative_text AS alternative_text_18,
  s1_.has_frame AS has_frame_19,
  s1_.title_frame AS title_frame_20,
  s1_.description_frame AS description_frame_21,
  s1_.button_title_frame AS button_title_frame_22,
  s1_.button_link_frame AS button_link_frame_23,
  s1_.color_frame AS color_frame_24,
  s1_.position_x AS position_x_25,
  s1_.position_y AS position_y_26,
  s1_.mac_brand AS mac_brand_27,
  s1_.mac_app AS mac_app_28,
  s1_.reference AS reference_29,
  s1_.created_at AS created_at_30,
  s1_.updated_at AS updated_at_31,
  s1_.publish_start AS publish_start_32,
  s1_.publish_end AS publish_end_33,
  s1_.status AS status_34,
  s1_.image_id AS image_id_35,
  s1_.slideshow_id AS slideshow_id_36
FROM
  slideshow s0_
  INNER JOIN slideshow_item s1_ ON s0_.id = s1_.slideshow_id
  AND (
    s1_.mac_brand = 'FX'
    AND s1_.mac_app = 'fx'
  )
  AND (
    s1_.status IN (?)
    AND s1_.publish_start <= ?
    AND (
      s1_.publish_end IS NULL
      OR s1_.publish_end >= ?
    )
  )
WHERE
  (
    s0_.status IN (?)
    AND s0_.publish_start <= ?
    AND (
      s0_.publish_end IS NULL
      OR s0_.publish_end >= ?
    )
  )
  AND (
    s0_.mac_brand = 'FX'
    AND s0_.mac_app = 'fx'
  )
ORDER BY
  s0_.publish_start ASC,
  s1_.position ASC

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.delay AS delay_2, s0_.slug AS slug_3, s0_.mac_brand AS mac_brand_4, s0_.mac_app AS mac_app_5, s0_.reference AS reference_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.publish_start AS publish_start_9, s0_.publish_end AS publish_end_10, s0_.status AS status_11, s1_.id AS id_12, s1_.title AS title_13, s1_.slug AS slug_14, s1_.link AS link_15, s1_.position AS position_16, s1_.is_target_blank AS is_target_blank_17, s1_.alternative_text AS alternative_text_18, s1_.has_frame AS has_frame_19, s1_.title_frame AS title_frame_20, s1_.description_frame AS description_frame_21, s1_.button_title_frame AS button_title_frame_22, s1_.button_link_frame AS button_link_frame_23, s1_.color_frame AS color_frame_24, s1_.position_x AS position_x_25, s1_.position_y AS position_y_26, s1_.mac_brand AS mac_brand_27, s1_.mac_app AS mac_app_28, s1_.reference AS reference_29, s1_.created_at AS created_at_30, s1_.updated_at AS updated_at_31, s1_.publish_start AS publish_start_32, s1_.publish_end AS publish_end_33, s1_.status AS status_34, s1_.image_id AS image_id_35, s1_.slideshow_id AS slideshow_id_36 FROM slideshow s0_ INNER JOIN slideshow_item s1_ ON s0_.id = s1_.slideshow_id AND (s1_.mac_brand = 'FX' AND s1_.mac_app = 'fx') AND (s1_.status IN ('published') AND s1_.publish_start <= '2026-03-12 05:43:00' AND (s1_.publish_end IS NULL OR s1_.publish_end >= '2026-03-12 05:43:00')) WHERE (s0_.status IN ('published') AND s0_.publish_start <= '2026-03-12 05:43:00' AND (s0_.publish_end IS NULL OR s0_.publish_end >= '2026-03-12 05:43:00')) AND (s0_.mac_brand = 'FX' AND s0_.mac_app = 'fx') ORDER BY s0_.publish_start ASC, s1_.position ASC;

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 05:43:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 05:43: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_.title AS title_10,
  t3_.id AS id_11,
  t3_.path AS path_12
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_.file_id = t3_.id
  AND (1)
  INNER JOIN product_category p4_ ON t0_.category_id = p4_.id
  AND (
    p4_.mac_brand = 'FX'
    AND p4_.mac_app = 'fx'
  )
  AND (p4_.menu_hidden = 0)
WHERE
  (
    t0_.catalog_id = ?
    AND t0_.depth <= ?
  )
  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_.title AS title_10, t3_.id AS id_11, t3_.path AS path_12 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_.file_id = t3_.id AND (1) INNER JOIN product_category p4_ ON t0_.category_id = p4_.id AND (p4_.mac_brand = 'FX' AND p4_.mac_app = 'fx') AND (p4_.menu_hidden = 0) WHERE (t0_.catalog_id = 5480 AND t0_.depth <= 1) AND (1) ORDER BY t0_.depth ASC, t0_.position ASC;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.slug AS slug_2,
  t0_.description AS description_3,
  t0_.created_at AS created_at_4,
  t0_.updated_at AS updated_at_5,
  t0_.publish_start AS publish_start_6,
  t0_.publish_end AS publish_end_7,
  t0_.status AS status_8,
  t0_.mac_brand AS mac_brand_9,
  t0_.mac_app AS mac_app_10,
  t0_.reference AS reference_11,
  t1_.id AS id_12,
  t1_.position AS position_13,
  t2_.id AS id_14,
  t2_.name AS name_15,
  t2_.slug AS slug_16,
  t2_.title AS title_17,
  t2_.body AS body_18,
  t2_.action AS action_19,
  t2_.subtitle AS subtitle_20,
  t2_.created_by AS created_by_21,
  t2_.updated_by AS updated_by_22,
  t2_.created_at AS created_at_23,
  t2_.updated_at AS updated_at_24,
  t2_.publish_start AS publish_start_25,
  t2_.publish_end AS publish_end_26,
  t2_.status AS status_27,
  t2_.mac_brand AS mac_brand_28,
  t2_.mac_app AS mac_app_29,
  t2_.reference AS reference_30,
  t1_.page_id AS page_id_31,
  t1_.category_id AS category_id_32,
  t2_.image_id AS image_id_33
FROM
  _page_category t0_
  INNER JOIN _page2page_category t1_ ON t0_.id = t1_.category_id
  AND (1)
  INNER JOIN _page t2_ ON t1_.page_id = t2_.id
  AND (
    t2_.mac_brand = 'FX'
    AND t2_.mac_app = 'fx'
  )
  AND (
    t2_.status IN (?)
    AND t2_.publish_start <= ?
    AND (
      t2_.publish_end IS NULL
      OR t2_.publish_end >= ?
    )
  )
WHERE
  (
    t0_.status IN (?)
    AND t0_.publish_start <= ?
    AND (
      t0_.publish_end IS NULL
      OR t0_.publish_end >= ?
    )
    AND t0_.title = ?
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
ORDER BY
  t1_.position ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.slug AS slug_2, t0_.description AS description_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5, t0_.publish_start AS publish_start_6, t0_.publish_end AS publish_end_7, t0_.status AS status_8, t0_.mac_brand AS mac_brand_9, t0_.mac_app AS mac_app_10, t0_.reference AS reference_11, t1_.id AS id_12, t1_.position AS position_13, t2_.id AS id_14, t2_.name AS name_15, t2_.slug AS slug_16, t2_.title AS title_17, t2_.body AS body_18, t2_.action AS action_19, t2_.subtitle AS subtitle_20, t2_.created_by AS created_by_21, t2_.updated_by AS updated_by_22, t2_.created_at AS created_at_23, t2_.updated_at AS updated_at_24, t2_.publish_start AS publish_start_25, t2_.publish_end AS publish_end_26, t2_.status AS status_27, t2_.mac_brand AS mac_brand_28, t2_.mac_app AS mac_app_29, t2_.reference AS reference_30, t1_.page_id AS page_id_31, t1_.category_id AS category_id_32, t2_.image_id AS image_id_33 FROM _page_category t0_ INNER JOIN _page2page_category t1_ ON t0_.id = t1_.category_id AND (1) INNER JOIN _page t2_ ON t1_.page_id = t2_.id AND (t2_.mac_brand = 'FX' AND t2_.mac_app = 'fx') AND (t2_.status IN ('published') AND t2_.publish_start <= '2026-03-12 05:43:00' AND (t2_.publish_end IS NULL OR t2_.publish_end >= '2026-03-12 05:43:00')) WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 05:43:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 05:43:00') AND t0_.title = 'Gammes') AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') ORDER BY t1_.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.page_id AS page_id_3,
  t0.category_id AS category_id_4
FROM
  _page2page_category t0
WHERE
  t0.page_id = ?
  AND (
    (1)
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.page_id AS page_id_3, t0.category_id AS category_id_4 FROM _page2page_category t0 WHERE t0.page_id = 48 AND ((1)) ORDER BY t0.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 = 'http://www.franciaflex.com/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 = '/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 = 'http://www.franciaflex.com/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 = '/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 = 'http://www.franciaflex.com/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;

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 = '/contact' 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 = 'http://www.franciaflex.com/contact?lead_activity%5Bprofile%5D=lead_activity.profile.individual&lead_activity%5Btype%5D=lead_activity.type.retailer_address' 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_.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,
  p2_.dickson AS dickson_11,
  p2_.equipment_link AS equipment_link_12,
  t3_.id AS id_13,
  t3_.path AS path_14,
  t4_.id AS id_15,
  t4_.path AS path_16,
  t5_.id AS id_17,
  t5_.path AS path_18,
  t6_.id AS id_19,
  t6_.path AS path_20,
  t7_.id AS id_21,
  t7_.path AS path_22
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_.brochure2_id = t4_.id
  AND (1)
  LEFT JOIN _file t5_ ON p2_.brochure3_id = t5_.id
  AND (1)
  LEFT JOIN _file t6_ ON p2_.file_id = t6_.id
  AND (1)
  LEFT JOIN _file t7_ ON p2_.image_mega_menu_id = t7_.id
  AND (1)
  INNER JOIN product_category p8_ ON t0_.category_id = p8_.id
  AND (
    p8_.mac_brand = 'FX'
    AND p8_.mac_app = 'fx'
  )
  AND (p8_.menu_hidden = 0)
WHERE
  (
    t0_.catalog_id = ?
    AND t0_.depth <= ?
  )
  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_.title AS title_10, p2_.dickson AS dickson_11, p2_.equipment_link AS equipment_link_12, t3_.id AS id_13, t3_.path AS path_14, t4_.id AS id_15, t4_.path AS path_16, t5_.id AS id_17, t5_.path AS path_18, t6_.id AS id_19, t6_.path AS path_20, t7_.id AS id_21, t7_.path AS path_22 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_.brochure2_id = t4_.id AND (1) LEFT JOIN _file t5_ ON p2_.brochure3_id = t5_.id AND (1) LEFT JOIN _file t6_ ON p2_.file_id = t6_.id AND (1) LEFT JOIN _file t7_ ON p2_.image_mega_menu_id = t7_.id AND (1) INNER JOIN product_category p8_ ON t0_.category_id = p8_.id AND (p8_.mac_brand = 'FX' AND p8_.mac_app = 'fx') AND (p8_.menu_hidden = 0) WHERE (t0_.catalog_id = 5480 AND t0_.depth <= 2) AND (1) ORDER BY t0_.depth ASC, t0_.position ASC;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.slug AS slug_2,
  t0_.description AS description_3,
  t0_.created_at AS created_at_4,
  t0_.updated_at AS updated_at_5,
  t0_.publish_start AS publish_start_6,
  t0_.publish_end AS publish_end_7,
  t0_.status AS status_8,
  t0_.mac_brand AS mac_brand_9,
  t0_.mac_app AS mac_app_10,
  t0_.reference AS reference_11,
  t1_.id AS id_12,
  t1_.position AS position_13,
  t2_.id AS id_14,
  t2_.name AS name_15,
  t2_.slug AS slug_16,
  t2_.title AS title_17,
  t2_.body AS body_18,
  t2_.action AS action_19,
  t2_.subtitle AS subtitle_20,
  t2_.created_by AS created_by_21,
  t2_.updated_by AS updated_by_22,
  t2_.created_at AS created_at_23,
  t2_.updated_at AS updated_at_24,
  t2_.publish_start AS publish_start_25,
  t2_.publish_end AS publish_end_26,
  t2_.status AS status_27,
  t2_.mac_brand AS mac_brand_28,
  t2_.mac_app AS mac_app_29,
  t2_.reference AS reference_30,
  t1_.page_id AS page_id_31,
  t1_.category_id AS category_id_32,
  t2_.image_id AS image_id_33
FROM
  _page_category t0_
  INNER JOIN _page2page_category t1_ ON t0_.id = t1_.category_id
  AND (1)
  INNER JOIN _page t2_ ON t1_.page_id = t2_.id
  AND (
    t2_.mac_brand = 'FX'
    AND t2_.mac_app = 'fx'
  )
  AND (
    t2_.status IN (?)
    AND t2_.publish_start <= ?
    AND (
      t2_.publish_end IS NULL
      OR t2_.publish_end >= ?
    )
  )
WHERE
  (
    t0_.status IN (?)
    AND t0_.publish_start <= ?
    AND (
      t0_.publish_end IS NULL
      OR t0_.publish_end >= ?
    )
    AND t0_.title = ?
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
ORDER BY
  t1_.position ASC

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.slug AS slug_2, t0_.description AS description_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5, t0_.publish_start AS publish_start_6, t0_.publish_end AS publish_end_7, t0_.status AS status_8, t0_.mac_brand AS mac_brand_9, t0_.mac_app AS mac_app_10, t0_.reference AS reference_11, t1_.id AS id_12, t1_.position AS position_13, t2_.id AS id_14, t2_.name AS name_15, t2_.slug AS slug_16, t2_.title AS title_17, t2_.body AS body_18, t2_.action AS action_19, t2_.subtitle AS subtitle_20, t2_.created_by AS created_by_21, t2_.updated_by AS updated_by_22, t2_.created_at AS created_at_23, t2_.updated_at AS updated_at_24, t2_.publish_start AS publish_start_25, t2_.publish_end AS publish_end_26, t2_.status AS status_27, t2_.mac_brand AS mac_brand_28, t2_.mac_app AS mac_app_29, t2_.reference AS reference_30, t1_.page_id AS page_id_31, t1_.category_id AS category_id_32, t2_.image_id AS image_id_33 FROM _page_category t0_ INNER JOIN _page2page_category t1_ ON t0_.id = t1_.category_id AND (1) INNER JOIN _page t2_ ON t1_.page_id = t2_.id AND (t2_.mac_brand = 'FX' AND t2_.mac_app = 'fx') AND (t2_.status IN ('published') AND t2_.publish_start <= '2026-03-12 05:43:00' AND (t2_.publish_end IS NULL OR t2_.publish_end >= '2026-03-12 05:43:00')) WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 05:43:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 05:43:00') AND t0_.title = 'Gammes') AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') ORDER BY t1_.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 = 'http://www.franciaflex.com/categorie/fenetres-et-coulissants' 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