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 = 'FA'
    AND t0_.mac_app = 'fa'
  )
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 = '/demander-un-devis-gratuit.html?products=156' AND t0_.enabled = 1) AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') 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 = 'FA'
    AND t0_.mac_app = 'fa'
  )
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 = '/demander-un-devis-gratuit.html' AND t0_.enabled = 1) AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') ORDER BY sclr_6 ASC LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.type AS type_1,
  t0_.name AS name_2,
  t0_.alternative_name AS alternative_name_3,
  t0_.description AS description_4,
  t0_.used_count AS used_count_5,
  t0_.old_id AS old_id_6,
  t0_.enabled AS enabled_7,
  t0_.created_at AS created_at_8,
  t0_.updated_at AS updated_at_9,
  t0_.mac_brand AS mac_brand_10,
  t0_.mac_app AS mac_app_11,
  t0_.reference AS reference_12,
  t1_.id AS id_13,
  t1_.validator AS validator_14,
  t1_.attributes AS attributes_15,
  t2_.id AS id_16,
  t2_.old_id AS old_id_17,
  t2_.name AS name_18,
  t2_.alternative_name AS alternative_name_19,
  t2_.teaser AS teaser_20,
  t2_.description AS description_21,
  t2_.scope AS scope_22,
  t2_.processor AS processor_23,
  t2_.attributes AS attributes_24,
  t2_.priority AS priority_25,
  t2_.enabled AS enabled_26,
  t2_.created_at AS created_at_27,
  t2_.updated_at AS updated_at_28,
  t3_.id AS id_29,
  t3_.validator AS validator_30,
  t3_.attributes AS attributes_31,
  t1_.coupon_id AS coupon_id_32,
  t1_.generated_coupon_id AS generated_coupon_id_33,
  t1_.coupon_advantage_id AS coupon_advantage_id_34,
  t2_.coupon_id AS coupon_id_35,
  t3_.coupon_id AS coupon_id_36,
  t3_.generated_coupon_id AS generated_coupon_id_37,
  t3_.coupon_advantage_id AS coupon_advantage_id_38
FROM
  _shop_coupon t0_
  LEFT JOIN _shop_constraint t1_ ON t0_.id = t1_.coupon_id
  AND (1)
  LEFT JOIN _shop_coupon_advantage t2_ ON t0_.id = t2_.coupon_id
  AND (1)
  LEFT JOIN _shop_constraint t3_ ON t2_.id = t3_.coupon_advantage_id
  AND (1)
WHERE
  (
    t0_.enabled = ?
    AND t0_.type = ?
  )
  AND (
    t0_.mac_brand = 'FA'
    AND t0_.mac_app = 'fa'
  )
ORDER BY
  t0_.id DESC,
  t2_.priority DESC

SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.name AS name_2, t0_.alternative_name AS alternative_name_3, t0_.description AS description_4, t0_.used_count AS used_count_5, t0_.old_id AS old_id_6, t0_.enabled AS enabled_7, t0_.created_at AS created_at_8, t0_.updated_at AS updated_at_9, t0_.mac_brand AS mac_brand_10, t0_.mac_app AS mac_app_11, t0_.reference AS reference_12, t1_.id AS id_13, t1_.validator AS validator_14, t1_.attributes AS attributes_15, t2_.id AS id_16, t2_.old_id AS old_id_17, t2_.name AS name_18, t2_.alternative_name AS alternative_name_19, t2_.teaser AS teaser_20, t2_.description AS description_21, t2_.scope AS scope_22, t2_.processor AS processor_23, t2_.attributes AS attributes_24, t2_.priority AS priority_25, t2_.enabled AS enabled_26, t2_.created_at AS created_at_27, t2_.updated_at AS updated_at_28, t3_.id AS id_29, t3_.validator AS validator_30, t3_.attributes AS attributes_31, t1_.coupon_id AS coupon_id_32, t1_.generated_coupon_id AS generated_coupon_id_33, t1_.coupon_advantage_id AS coupon_advantage_id_34, t2_.coupon_id AS coupon_id_35, t3_.coupon_id AS coupon_id_36, t3_.generated_coupon_id AS generated_coupon_id_37, t3_.coupon_advantage_id AS coupon_advantage_id_38 FROM _shop_coupon t0_ LEFT JOIN _shop_constraint t1_ ON t0_.id = t1_.coupon_id AND (1) LEFT JOIN _shop_coupon_advantage t2_ ON t0_.id = t2_.coupon_id AND (1) LEFT JOIN _shop_constraint t3_ ON t2_.id = t3_.coupon_advantage_id AND (1) WHERE (t0_.enabled = 1 AND t0_.type = 'forced') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') ORDER BY t0_.id DESC, t2_.priority DESC;

SELECT
  t0_.id AS id_0,
  t0_.type AS type_1,
  t0_.name AS name_2,
  t0_.alternative_name AS alternative_name_3,
  t0_.description AS description_4,
  t0_.used_count AS used_count_5,
  t0_.old_id AS old_id_6,
  t0_.enabled AS enabled_7,
  t0_.created_at AS created_at_8,
  t0_.updated_at AS updated_at_9,
  t0_.mac_brand AS mac_brand_10,
  t0_.mac_app AS mac_app_11,
  t0_.reference AS reference_12,
  t1_.id AS id_13,
  t1_.validator AS validator_14,
  t1_.attributes AS attributes_15,
  t2_.id AS id_16,
  t2_.old_id AS old_id_17,
  t2_.name AS name_18,
  t2_.alternative_name AS alternative_name_19,
  t2_.teaser AS teaser_20,
  t2_.description AS description_21,
  t2_.scope AS scope_22,
  t2_.processor AS processor_23,
  t2_.attributes AS attributes_24,
  t2_.priority AS priority_25,
  t2_.enabled AS enabled_26,
  t2_.created_at AS created_at_27,
  t2_.updated_at AS updated_at_28,
  t3_.id AS id_29,
  t3_.validator AS validator_30,
  t3_.attributes AS attributes_31,
  t1_.coupon_id AS coupon_id_32,
  t1_.generated_coupon_id AS generated_coupon_id_33,
  t1_.coupon_advantage_id AS coupon_advantage_id_34,
  t2_.coupon_id AS coupon_id_35,
  t3_.coupon_id AS coupon_id_36,
  t3_.generated_coupon_id AS generated_coupon_id_37,
  t3_.coupon_advantage_id AS coupon_advantage_id_38
FROM
  _shop_coupon t0_
  LEFT JOIN _shop_constraint t1_ ON t0_.id = t1_.coupon_id
  AND (1)
  LEFT JOIN _shop_coupon_advantage t2_ ON t0_.id = t2_.coupon_id
  AND (1)
  LEFT JOIN _shop_constraint t3_ ON t2_.id = t3_.coupon_advantage_id
  AND (1)
WHERE
  (
    t0_.enabled = ?
    AND t0_.type = ?
  )
  AND (
    t0_.mac_brand = 'FA'
    AND t0_.mac_app = 'fa'
  )
ORDER BY
  t2_.priority DESC

SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.name AS name_2, t0_.alternative_name AS alternative_name_3, t0_.description AS description_4, t0_.used_count AS used_count_5, t0_.old_id AS old_id_6, t0_.enabled AS enabled_7, t0_.created_at AS created_at_8, t0_.updated_at AS updated_at_9, t0_.mac_brand AS mac_brand_10, t0_.mac_app AS mac_app_11, t0_.reference AS reference_12, t1_.id AS id_13, t1_.validator AS validator_14, t1_.attributes AS attributes_15, t2_.id AS id_16, t2_.old_id AS old_id_17, t2_.name AS name_18, t2_.alternative_name AS alternative_name_19, t2_.teaser AS teaser_20, t2_.description AS description_21, t2_.scope AS scope_22, t2_.processor AS processor_23, t2_.attributes AS attributes_24, t2_.priority AS priority_25, t2_.enabled AS enabled_26, t2_.created_at AS created_at_27, t2_.updated_at AS updated_at_28, t3_.id AS id_29, t3_.validator AS validator_30, t3_.attributes AS attributes_31, t1_.coupon_id AS coupon_id_32, t1_.generated_coupon_id AS generated_coupon_id_33, t1_.coupon_advantage_id AS coupon_advantage_id_34, t2_.coupon_id AS coupon_id_35, t3_.coupon_id AS coupon_id_36, t3_.generated_coupon_id AS generated_coupon_id_37, t3_.coupon_advantage_id AS coupon_advantage_id_38 FROM _shop_coupon t0_ LEFT JOIN _shop_constraint t1_ ON t0_.id = t1_.coupon_id AND (1) LEFT JOIN _shop_coupon_advantage t2_ ON t0_.id = t2_.coupon_id AND (1) LEFT JOIN _shop_constraint t3_ ON t2_.id = t3_.coupon_advantage_id AND (1) WHERE (t0_.enabled = 1 AND t0_.type = 'emergency') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') ORDER BY t2_.priority DESC;

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 = 'FA'
    AND d0_.mac_app = 'fa'
  )
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 = 'FA' AND d0_.mac_app = 'fa') 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 = 'FA'
    AND t0_.mac_app = 'fa'
  )

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

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.title AS title_2,
  p0_.name AS name_3,
  p0_.subtitle AS subtitle_4,
  p0_.description AS description_5,
  p0_.long_description AS long_description_6,
  p0_.green_argument AS green_argument_7,
  p0_.features AS features_8,
  p0_.protection AS protection_9,
  p0_.speech_of_expert_title AS speech_of_expert_title_10,
  p0_.speech_of_expert AS speech_of_expert_11,
  p0_.dimensional_limits AS dimensional_limits_12,
  p0_.position AS position_13,
  p0_.color_charts_description AS color_charts_description_14,
  p0_.video AS video_15,
  p0_.video_title AS video_title_16,
  p0_.filter AS filter_17,
  p0_.base_price AS base_price_18,
  p0_.base_price_comment AS base_price_comment_19,
  p0_.is_new AS is_new_20,
  p0_.dickson_code AS dickson_code_21,
  p0_.groupe_article AS groupe_article_22,
  p0_.access_interne AS access_interne_23,
  p0_.created_by AS created_by_24,
  p0_.updated_by AS updated_by_25,
  p0_.created_at AS created_at_26,
  p0_.updated_at AS updated_at_27,
  p0_.publish_start AS publish_start_28,
  p0_.publish_end AS publish_end_29,
  p0_.status AS status_30,
  p0_.mac_brand AS mac_brand_31,
  p0_.mac_app AS mac_app_32,
  p0_.reference AS reference_33,
  p1_.id AS id_34,
  p1_.slug AS slug_35,
  p1_.title AS title_36,
  p1_.name AS name_37,
  p1_.seo_heading AS seo_heading_38,
  p1_.description AS description_39,
  p1_.position AS position_40,
  p1_.class AS class_41,
  p1_.configurator_url AS configurator_url_42,
  p1_.advice_title AS advice_title_43,
  p1_.advice_line AS advice_line_44,
  p1_.baseline AS baseline_45,
  p1_.brochure_description AS brochure_description_46,
  p1_.brochure2description AS brochure2description_47,
  p1_.brochure3description AS brochure3description_48,
  p1_.dickson AS dickson_49,
  p1_.equipment_link AS equipment_link_50,
  p1_.`range` AS range_51,
  p1_.sub_range AS sub_range_52,
  p1_.menu_hidden AS menu_hidden_53,
  p1_.is_professional AS is_professional_54,
  p1_.created_by AS created_by_55,
  p1_.updated_by AS updated_by_56,
  p1_.created_at AS created_at_57,
  p1_.updated_at AS updated_at_58,
  p1_.publish_start AS publish_start_59,
  p1_.publish_end AS publish_end_60,
  p1_.status AS status_61,
  p1_.mac_brand AS mac_brand_62,
  p1_.mac_app AS mac_app_63,
  p1_.reference AS reference_64,
  p2_.id AS id_65,
  p2_.position AS position_66,
  p3_.id AS id_67,
  p3_.position AS position_68,
  p3_.description AS description_69,
  p3_.created_by AS created_by_70,
  p3_.updated_by AS updated_by_71,
  p3_.created_at AS created_at_72,
  p3_.updated_at AS updated_at_73,
  p0_.image_expert_id AS image_expert_id_74,
  p0_.product_category_id AS product_category_id_75,
  p0_.fallback_product_id AS fallback_product_id_76,
  p0_.image_inspiration_id AS image_inspiration_id_77,
  p0_.image_inspiration_mobile_id AS image_inspiration_mobile_id_78,
  p1_.file_id AS file_id_79,
  p1_.image_mega_menu_id AS image_mega_menu_id_80,
  p1_.image_mobile_id AS image_mobile_id_81,
  p1_.parent_id AS parent_id_82,
  p1_.brochure_id AS brochure_id_83,
  p1_.brochure_image_id AS brochure_image_id_84,
  p1_.brochure2_id AS brochure2_id_85,
  p1_.brochure2image_id AS brochure2image_id_86,
  p1_.brochure3_id AS brochure3_id_87,
  p1_.brochure3image_id AS brochure3image_id_88,
  p1_.image_inspiration_id AS image_inspiration_id_89,
  p1_.image_inspiration_mobile_id AS image_inspiration_mobile_id_90,
  p2_.product_id AS product_id_91,
  p2_.picto_id AS picto_id_92,
  p3_.file_id AS file_id_93,
  p3_.file_mobile_id AS file_mobile_id_94,
  p3_.product_id AS product_id_95
FROM
  product p0_
  INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id
  AND (
    p1_.mac_brand = 'FA'
    AND p1_.mac_app = 'fa'
  )
  LEFT JOIN product_picto p2_ ON p0_.id = p2_.product_id
  AND (1)
  LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id
  AND (1)
WHERE
  (
    p0_.id = ?
    AND p0_.status IN (?)
    AND p0_.publish_start <= ?
    AND (
      p0_.publish_end IS NULL
      OR p0_.publish_end >= ?
    )
    AND p1_.status IN (?)
    AND p1_.publish_start <= ?
    AND (
      p1_.publish_end IS NULL
      OR p1_.publish_end >= ?
    )
  )
  AND (
    p0_.mac_brand = 'FA'
    AND p0_.mac_app = 'fa'
  )
ORDER BY
  p0_.position ASC,
  p2_.position ASC,
  p3_.position ASC

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p0_.name AS name_3, p0_.subtitle AS subtitle_4, p0_.description AS description_5, p0_.long_description AS long_description_6, p0_.green_argument AS green_argument_7, p0_.features AS features_8, p0_.protection AS protection_9, p0_.speech_of_expert_title AS speech_of_expert_title_10, p0_.speech_of_expert AS speech_of_expert_11, p0_.dimensional_limits AS dimensional_limits_12, p0_.position AS position_13, p0_.color_charts_description AS color_charts_description_14, p0_.video AS video_15, p0_.video_title AS video_title_16, p0_.filter AS filter_17, p0_.base_price AS base_price_18, p0_.base_price_comment AS base_price_comment_19, p0_.is_new AS is_new_20, p0_.dickson_code AS dickson_code_21, p0_.groupe_article AS groupe_article_22, p0_.access_interne AS access_interne_23, p0_.created_by AS created_by_24, p0_.updated_by AS updated_by_25, p0_.created_at AS created_at_26, p0_.updated_at AS updated_at_27, p0_.publish_start AS publish_start_28, p0_.publish_end AS publish_end_29, p0_.status AS status_30, p0_.mac_brand AS mac_brand_31, p0_.mac_app AS mac_app_32, p0_.reference AS reference_33, p1_.id AS id_34, p1_.slug AS slug_35, p1_.title AS title_36, p1_.name AS name_37, p1_.seo_heading AS seo_heading_38, p1_.description AS description_39, p1_.position AS position_40, p1_.class AS class_41, p1_.configurator_url AS configurator_url_42, p1_.advice_title AS advice_title_43, p1_.advice_line AS advice_line_44, p1_.baseline AS baseline_45, p1_.brochure_description AS brochure_description_46, p1_.brochure2description AS brochure2description_47, p1_.brochure3description AS brochure3description_48, p1_.dickson AS dickson_49, p1_.equipment_link AS equipment_link_50, p1_.`range` AS range_51, p1_.sub_range AS sub_range_52, p1_.menu_hidden AS menu_hidden_53, p1_.is_professional AS is_professional_54, p1_.created_by AS created_by_55, p1_.updated_by AS updated_by_56, p1_.created_at AS created_at_57, p1_.updated_at AS updated_at_58, p1_.publish_start AS publish_start_59, p1_.publish_end AS publish_end_60, p1_.status AS status_61, p1_.mac_brand AS mac_brand_62, p1_.mac_app AS mac_app_63, p1_.reference AS reference_64, p2_.id AS id_65, p2_.position AS position_66, p3_.id AS id_67, p3_.position AS position_68, p3_.description AS description_69, p3_.created_by AS created_by_70, p3_.updated_by AS updated_by_71, p3_.created_at AS created_at_72, p3_.updated_at AS updated_at_73, p0_.image_expert_id AS image_expert_id_74, p0_.product_category_id AS product_category_id_75, p0_.fallback_product_id AS fallback_product_id_76, p0_.image_inspiration_id AS image_inspiration_id_77, p0_.image_inspiration_mobile_id AS image_inspiration_mobile_id_78, p1_.file_id AS file_id_79, p1_.image_mega_menu_id AS image_mega_menu_id_80, p1_.image_mobile_id AS image_mobile_id_81, p1_.parent_id AS parent_id_82, p1_.brochure_id AS brochure_id_83, p1_.brochure_image_id AS brochure_image_id_84, p1_.brochure2_id AS brochure2_id_85, p1_.brochure2image_id AS brochure2image_id_86, p1_.brochure3_id AS brochure3_id_87, p1_.brochure3image_id AS brochure3image_id_88, p1_.image_inspiration_id AS image_inspiration_id_89, p1_.image_inspiration_mobile_id AS image_inspiration_mobile_id_90, p2_.product_id AS product_id_91, p2_.picto_id AS picto_id_92, p3_.file_id AS file_id_93, p3_.file_mobile_id AS file_mobile_id_94, p3_.product_id AS product_id_95 FROM product p0_ INNER JOIN product_category p1_ ON p0_.product_category_id = p1_.id AND (p1_.mac_brand = 'FA' AND p1_.mac_app = 'fa') LEFT JOIN product_picto p2_ ON p0_.id = p2_.product_id AND (1) LEFT JOIN product_image p3_ ON p0_.id = p3_.product_id AND (1) WHERE (p0_.id = '156' AND p0_.status IN ('published') AND p0_.publish_start <= '2026-07-27 16:59:09' AND (p0_.publish_end IS NULL OR p0_.publish_end >= '2026-07-27 16:59:09') AND p1_.status IN ('published') AND p1_.publish_start <= '2026-07-27 16:59:09' AND (p1_.publish_end IS NULL OR p1_.publish_end >= '2026-07-27 16:59:09')) AND (p0_.mac_brand = 'FA' AND p0_.mac_app = 'fa') ORDER BY p0_.position ASC, p2_.position ASC, p3_.position ASC;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.created_at AS created_at_2,
  t0_.updated_at AS updated_at_3
FROM
  _country t0_
WHERE
  (t0_.id = ?)
  AND (1)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.created_at AS created_at_2, t0_.updated_at AS updated_at_3 FROM _country t0_ WHERE (t0_.id = 'fr') AND (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 = 'FA'
    AND t0_.mac_app = 'fa'
  )
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.stores-faber.fr/demander-un-devis-gratuit.html' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') 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 = 'FA'
    AND t0_.mac_app = 'fa'
  )
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 = '/demander-un-devis-gratuit.html' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') 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 = 'FA'
    AND t0_.mac_app = 'fa'
  )
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.stores-faber.fr/devenir-revendeur.html' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') 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 = 'FA'
    AND t0_.mac_app = 'fa'
  )
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 = '/devenir-revendeur.html' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') 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 = 'FA'
    AND t0_.mac_app = 'fa'
  )
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.stores-faber.fr/espace-pro' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') 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 = 'FA'
    AND t0_.mac_app = 'fa'
  )
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 = '/espace-pro' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') LIMIT 1;

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.title AS title_2,
  p1_.id AS id_3,
  p1_.link AS link_4,
  p1_.title AS title_5,
  t2_.id AS id_6,
  t2_.path AS path_7,
  t3_.id AS id_8,
  t3_.path AS path_9,
  p4_.id AS id_10,
  p4_.slug AS slug_11,
  p4_.title AS title_12,
  t5_.id AS id_13,
  t5_.path AS path_14
FROM
  product_category p0_
  LEFT JOIN product_category_picture p1_ ON p0_.id = p1_.product_category_id
  AND (1)
  LEFT JOIN _file t2_ ON p0_.file_id = t2_.id
  AND (1)
  LEFT JOIN _file t3_ ON p1_.file_id = t3_.id
  AND (1)
  LEFT JOIN product_category p4_ ON p0_.id = p4_.parent_id
  AND (
    p4_.mac_brand = 'FA'
    AND p4_.mac_app = 'fa'
  )
  LEFT JOIN _file t5_ ON p4_.file_id = t5_.id
  AND (1)
WHERE
  (
    p0_.parent_id IS NULL
    AND p0_.status = 'published'
    AND (
      p4_.status = 'published'
      OR p4_.id IS NULL
    )
  )
  AND (
    p0_.mac_brand = 'FA'
    AND p0_.mac_app = 'fa'
  )
ORDER BY
  p0_.position ASC,
  p4_.position ASC

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.title AS title_2, p1_.id AS id_3, p1_.link AS link_4, p1_.title AS title_5, t2_.id AS id_6, t2_.path AS path_7, t3_.id AS id_8, t3_.path AS path_9, p4_.id AS id_10, p4_.slug AS slug_11, p4_.title AS title_12, t5_.id AS id_13, t5_.path AS path_14 FROM product_category p0_ LEFT JOIN product_category_picture p1_ ON p0_.id = p1_.product_category_id AND (1) LEFT JOIN _file t2_ ON p0_.file_id = t2_.id AND (1) LEFT JOIN _file t3_ ON p1_.file_id = t3_.id AND (1) LEFT JOIN product_category p4_ ON p0_.id = p4_.parent_id AND (p4_.mac_brand = 'FA' AND p4_.mac_app = 'fa') LEFT JOIN _file t5_ ON p4_.file_id = t5_.id AND (1) WHERE (p0_.parent_id IS NULL AND p0_.status = 'published' AND (p4_.status = 'published' OR p4_.id IS NULL)) AND (p0_.mac_brand = 'FA' AND p0_.mac_app = 'fa') ORDER BY p0_.position ASC, p4_.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 = 'FA'
    AND t0_.mac_app = 'fa'
  )
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.stores-faber.fr/stores-interieurs/' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') 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 = 'FA'
    AND t0_.mac_app = 'fa'
  )
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 = '/stores-interieurs/' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') LIMIT 1;