Symfony Profiler

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_.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 01:36:00' AND (t2_.publish_end IS NULL OR t2_.publish_end >= '2026-03-12 01:36:00')) WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 01:36:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 01:36: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_.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_.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'
  )
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 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') 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_.name AS name_1,
  t0_.slug AS slug_2,
  t0_.title AS title_3,
  t0_.body AS body_4,
  t0_.action AS action_5,
  t0_.subtitle AS subtitle_6,
  t0_.created_by AS created_by_7,
  t0_.updated_by AS updated_by_8,
  t0_.created_at AS created_at_9,
  t0_.updated_at AS updated_at_10,
  t0_.publish_start AS publish_start_11,
  t0_.publish_end AS publish_end_12,
  t0_.status AS status_13,
  t0_.mac_brand AS mac_brand_14,
  t0_.mac_app AS mac_app_15,
  t0_.reference AS reference_16,
  t1_.id AS id_17,
  t1_.position AS position_18,
  t2_.id AS id_19,
  t2_.title AS title_20,
  t2_.slug AS slug_21,
  t2_.description AS description_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,
  t0_.image_id AS image_id_31,
  t1_.page_id AS page_id_32,
  t1_.category_id AS category_id_33
FROM
  _page t0_
  INNER JOIN _page2page_category t1_ ON t0_.id = t1_.page_id
  AND (1)
  INNER JOIN _page_category t2_ ON t1_.category_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_.slug = ?
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
ORDER BY
  t1_.position ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.title AS title_3, t0_.body AS body_4, t0_.action AS action_5, t0_.subtitle AS subtitle_6, t0_.created_by AS created_by_7, t0_.updated_by AS updated_by_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.publish_start AS publish_start_11, t0_.publish_end AS publish_end_12, t0_.status AS status_13, t0_.mac_brand AS mac_brand_14, t0_.mac_app AS mac_app_15, t0_.reference AS reference_16, t1_.id AS id_17, t1_.position AS position_18, t2_.id AS id_19, t2_.title AS title_20, t2_.slug AS slug_21, t2_.description AS description_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, t0_.image_id AS image_id_31, t1_.page_id AS page_id_32, t1_.category_id AS category_id_33 FROM _page t0_ INNER JOIN _page2page_category t1_ ON t0_.id = t1_.page_id AND (1) INNER JOIN _page_category t2_ ON t1_.category_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 01:36:00' AND (t2_.publish_end IS NULL OR t2_.publish_end >= '2026-03-12 01:36:00')) WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 01:36:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 01:36:00') AND t0_.slug = 'les-garanties-franciaflex') AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') ORDER BY t1_.position ASC;

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 = '/store-volet-fenetre-sur-mesure' 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_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2,
  t0_.title AS title_3,
  t0_.body AS body_4,
  t0_.action AS action_5,
  t0_.subtitle AS subtitle_6,
  t0_.created_by AS created_by_7,
  t0_.updated_by AS updated_by_8,
  t0_.created_at AS created_at_9,
  t0_.updated_at AS updated_at_10,
  t0_.publish_start AS publish_start_11,
  t0_.publish_end AS publish_end_12,
  t0_.status AS status_13,
  t0_.mac_brand AS mac_brand_14,
  t0_.mac_app AS mac_app_15,
  t0_.reference AS reference_16,
  t0_.image_id AS image_id_17
FROM
  _page t0_
  INNER JOIN _page2page_category t1_ ON t0_.id = t1_.page_id
  AND (1)
  AND (t1_.category_id = ?)
WHERE
  (
    t0_.status IN (?)
    AND t0_.publish_start <= ?
    AND (
      t0_.publish_end IS NULL
      OR t0_.publish_end >= ?
    )
  )
  AND (
    t0_.mac_brand = 'FX'
    AND t0_.mac_app = 'fx'
  )
ORDER BY
  t1_.position ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2, t0_.title AS title_3, t0_.body AS body_4, t0_.action AS action_5, t0_.subtitle AS subtitle_6, t0_.created_by AS created_by_7, t0_.updated_by AS updated_by_8, t0_.created_at AS created_at_9, t0_.updated_at AS updated_at_10, t0_.publish_start AS publish_start_11, t0_.publish_end AS publish_end_12, t0_.status AS status_13, t0_.mac_brand AS mac_brand_14, t0_.mac_app AS mac_app_15, t0_.reference AS reference_16, t0_.image_id AS image_id_17 FROM _page t0_ INNER JOIN _page2page_category t1_ ON t0_.id = t1_.page_id AND (1) AND (t1_.category_id = 5) WHERE (t0_.status IN ('published') AND t0_.publish_start <= '2026-03-12 01:36:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 01:36:00')) AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') ORDER BY t1_.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 01:36:00' AND (t0_.publish_end IS NULL OR t0_.publish_end >= '2026-03-12 01:36:00') AND t1_.id = 2) AND (t0_.mac_brand = 'FX' AND t0_.mac_app = 'fx') 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_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;