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 = '/nos-actualites/motorisation-autonome-sonesse-28-li-ion.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_.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 = '/nos-actualites/motorisation-autonome-sonesse-28-li-ion.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_.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
  n0_.id AS id_0,
  n0_.slug AS slug_1,
  n0_.title AS title_2,
  n0_.subtitle AS subtitle_3,
  n0_.short_description AS short_description_4,
  n0_.anti_date AS anti_date_5,
  n0_.description AS description_6,
  n0_.show_in_home AS show_in_home_7,
  n0_.is_prescriber AS is_prescriber_8,
  n0_.is_professional AS is_professional_9,
  n0_.is_premium AS is_premium_10,
  n0_.created_by AS created_by_11,
  n0_.updated_by AS updated_by_12,
  n0_.created_at AS created_at_13,
  n0_.updated_at AS updated_at_14,
  n0_.publish_start AS publish_start_15,
  n0_.publish_end AS publish_end_16,
  n0_.status AS status_17,
  n0_.mac_brand AS mac_brand_18,
  n0_.mac_app AS mac_app_19,
  n0_.reference AS reference_20,
  t1_.id AS id_21,
  t1_.name AS name_22,
  t1_.path AS path_23,
  p2_.id AS id_24,
  p2_.slug AS slug_25,
  p2_.title AS title_26,
  p2_.name AS name_27,
  p2_.subtitle AS subtitle_28,
  p2_.description AS description_29,
  p2_.long_description AS long_description_30,
  p2_.green_argument AS green_argument_31,
  p2_.features AS features_32,
  p2_.protection AS protection_33,
  p2_.speech_of_expert_title AS speech_of_expert_title_34,
  p2_.speech_of_expert AS speech_of_expert_35,
  p2_.dimensional_limits AS dimensional_limits_36,
  p2_.position AS position_37,
  p2_.color_charts_description AS color_charts_description_38,
  p2_.video AS video_39,
  p2_.video_title AS video_title_40,
  p2_.filter AS filter_41,
  p2_.base_price AS base_price_42,
  p2_.base_price_comment AS base_price_comment_43,
  p2_.is_new AS is_new_44,
  p2_.dickson_code AS dickson_code_45,
  p2_.groupe_article AS groupe_article_46,
  p2_.access_interne AS access_interne_47,
  p2_.created_by AS created_by_48,
  p2_.updated_by AS updated_by_49,
  p2_.created_at AS created_at_50,
  p2_.updated_at AS updated_at_51,
  p2_.publish_start AS publish_start_52,
  p2_.publish_end AS publish_end_53,
  p2_.status AS status_54,
  p2_.mac_brand AS mac_brand_55,
  p2_.mac_app AS mac_app_56,
  p2_.reference AS reference_57,
  p3_.id AS id_58,
  p3_.slug AS slug_59,
  p3_.title AS title_60,
  p3_.name AS name_61,
  p3_.seo_heading AS seo_heading_62,
  p3_.description AS description_63,
  p3_.position AS position_64,
  p3_.class AS class_65,
  p3_.configurator_url AS configurator_url_66,
  p3_.advice_title AS advice_title_67,
  p3_.advice_line AS advice_line_68,
  p3_.baseline AS baseline_69,
  p3_.brochure_description AS brochure_description_70,
  p3_.brochure2description AS brochure2description_71,
  p3_.brochure3description AS brochure3description_72,
  p3_.dickson AS dickson_73,
  p3_.equipment_link AS equipment_link_74,
  p3_.`range` AS range_75,
  p3_.sub_range AS sub_range_76,
  p3_.menu_hidden AS menu_hidden_77,
  p3_.is_professional AS is_professional_78,
  p3_.created_by AS created_by_79,
  p3_.updated_by AS updated_by_80,
  p3_.created_at AS created_at_81,
  p3_.updated_at AS updated_at_82,
  p3_.publish_start AS publish_start_83,
  p3_.publish_end AS publish_end_84,
  p3_.status AS status_85,
  p3_.mac_brand AS mac_brand_86,
  p3_.mac_app AS mac_app_87,
  p3_.reference AS reference_88,
  p4_.id AS id_89,
  p4_.slug AS slug_90,
  p4_.title AS title_91,
  p4_.name AS name_92,
  p4_.seo_heading AS seo_heading_93,
  p4_.description AS description_94,
  p4_.position AS position_95,
  p4_.class AS class_96,
  p4_.configurator_url AS configurator_url_97,
  p4_.advice_title AS advice_title_98,
  p4_.advice_line AS advice_line_99,
  p4_.baseline AS baseline_100,
  p4_.brochure_description AS brochure_description_101,
  p4_.brochure2description AS brochure2description_102,
  p4_.brochure3description AS brochure3description_103,
  p4_.dickson AS dickson_104,
  p4_.equipment_link AS equipment_link_105,
  p4_.`range` AS range_106,
  p4_.sub_range AS sub_range_107,
  p4_.menu_hidden AS menu_hidden_108,
  p4_.is_professional AS is_professional_109,
  p4_.created_by AS created_by_110,
  p4_.updated_by AS updated_by_111,
  p4_.created_at AS created_at_112,
  p4_.updated_at AS updated_at_113,
  p4_.publish_start AS publish_start_114,
  p4_.publish_end AS publish_end_115,
  p4_.status AS status_116,
  p4_.mac_brand AS mac_brand_117,
  p4_.mac_app AS mac_app_118,
  p4_.reference AS reference_119,
  p5_.id AS id_120,
  p5_.position AS position_121,
  p5_.description AS description_122,
  p5_.created_by AS created_by_123,
  p5_.updated_by AS updated_by_124,
  p5_.created_at AS created_at_125,
  p5_.updated_at AS updated_at_126,
  t6_.id AS id_127,
  t6_.name AS name_128,
  t6_.path AS path_129,
  n0_.news_category_id AS news_category_id_130,
  n0_.point_of_sale_id AS point_of_sale_id_131,
  n0_.file_id AS file_id_132,
  n0_.file_mobile_id AS file_mobile_id_133,
  n0_.attached_file_id AS attached_file_id_134,
  p2_.image_expert_id AS image_expert_id_135,
  p2_.product_category_id AS product_category_id_136,
  p2_.fallback_product_id AS fallback_product_id_137,
  p2_.image_inspiration_id AS image_inspiration_id_138,
  p2_.image_inspiration_mobile_id AS image_inspiration_mobile_id_139,
  p3_.file_id AS file_id_140,
  p3_.image_mega_menu_id AS image_mega_menu_id_141,
  p3_.image_mobile_id AS image_mobile_id_142,
  p3_.parent_id AS parent_id_143,
  p3_.brochure_id AS brochure_id_144,
  p3_.brochure_image_id AS brochure_image_id_145,
  p3_.brochure2_id AS brochure2_id_146,
  p3_.brochure2image_id AS brochure2image_id_147,
  p3_.brochure3_id AS brochure3_id_148,
  p3_.brochure3image_id AS brochure3image_id_149,
  p3_.image_inspiration_id AS image_inspiration_id_150,
  p3_.image_inspiration_mobile_id AS image_inspiration_mobile_id_151,
  p4_.file_id AS file_id_152,
  p4_.image_mega_menu_id AS image_mega_menu_id_153,
  p4_.image_mobile_id AS image_mobile_id_154,
  p4_.parent_id AS parent_id_155,
  p4_.brochure_id AS brochure_id_156,
  p4_.brochure_image_id AS brochure_image_id_157,
  p4_.brochure2_id AS brochure2_id_158,
  p4_.brochure2image_id AS brochure2image_id_159,
  p4_.brochure3_id AS brochure3_id_160,
  p4_.brochure3image_id AS brochure3image_id_161,
  p4_.image_inspiration_id AS image_inspiration_id_162,
  p4_.image_inspiration_mobile_id AS image_inspiration_mobile_id_163,
  p5_.file_id AS file_id_164,
  p5_.file_mobile_id AS file_mobile_id_165,
  p5_.product_id AS product_id_166
FROM
  news n0_
  LEFT JOIN _file t1_ ON n0_.file_id = t1_.id
  AND (1)
  LEFT JOIN product_to_news p7_ ON n0_.id = p7_.news_id
  LEFT JOIN product p2_ ON p2_.id = p7_.product_id
  AND (
    p2_.mac_brand = 'FA'
    AND p2_.mac_app = 'fa'
  )
  AND (
    p2_.status = 'published'
    AND p2_.publish_start <= '2026-08-02 19:37:14'
    AND (
      p2_.publish_end IS NULL
      OR p2_.publish_end >= '2026-08-02 19:37:14'
    )
  )
  LEFT JOIN product_category p3_ ON p2_.product_category_id = p3_.id
  AND (
    p3_.mac_brand = 'FA'
    AND p3_.mac_app = 'fa'
  )
  AND (
    p3_.status = 'published'
    AND p3_.publish_start <= '2026-08-02 19:37:14'
    AND (
      p3_.publish_end IS NULL
      OR p3_.publish_end >= '2026-08-02 19:37:14'
    )
  )
  LEFT JOIN product_category p4_ ON p3_.parent_id = p4_.id
  AND (
    p4_.mac_brand = 'FA'
    AND p4_.mac_app = 'fa'
  )
  AND (
    p4_.status = 'published'
    AND p4_.publish_start <= '2026-08-02 19:37:14'
    AND (
      p4_.publish_end IS NULL
      OR p4_.publish_end >= '2026-08-02 19:37:14'
    )
  )
  LEFT JOIN product_image p5_ ON p2_.id = p5_.product_id
  AND (1)
  LEFT JOIN _file t6_ ON p5_.file_id = t6_.id
  AND (1)
WHERE
  (
    n0_.status IN (?)
    AND n0_.publish_start <= ?
    AND (
      n0_.publish_end IS NULL
      OR n0_.publish_end >= ?
    )
    AND n0_.status IN (?)
    AND n0_.publish_start <= ?
    AND (
      n0_.publish_end IS NULL
      OR n0_.publish_end >= ?
    )
    AND n0_.slug = ?
  )
  AND (
    n0_.mac_brand = 'FA'
    AND n0_.mac_app = 'fa'
  )
ORDER BY
  n0_.publish_start DESC,
  p5_.position ASC

SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.title AS title_2, n0_.subtitle AS subtitle_3, n0_.short_description AS short_description_4, n0_.anti_date AS anti_date_5, n0_.description AS description_6, n0_.show_in_home AS show_in_home_7, n0_.is_prescriber AS is_prescriber_8, n0_.is_professional AS is_professional_9, n0_.is_premium AS is_premium_10, n0_.created_by AS created_by_11, n0_.updated_by AS updated_by_12, n0_.created_at AS created_at_13, n0_.updated_at AS updated_at_14, n0_.publish_start AS publish_start_15, n0_.publish_end AS publish_end_16, n0_.status AS status_17, n0_.mac_brand AS mac_brand_18, n0_.mac_app AS mac_app_19, n0_.reference AS reference_20, t1_.id AS id_21, t1_.name AS name_22, t1_.path AS path_23, p2_.id AS id_24, p2_.slug AS slug_25, p2_.title AS title_26, p2_.name AS name_27, p2_.subtitle AS subtitle_28, p2_.description AS description_29, p2_.long_description AS long_description_30, p2_.green_argument AS green_argument_31, p2_.features AS features_32, p2_.protection AS protection_33, p2_.speech_of_expert_title AS speech_of_expert_title_34, p2_.speech_of_expert AS speech_of_expert_35, p2_.dimensional_limits AS dimensional_limits_36, p2_.position AS position_37, p2_.color_charts_description AS color_charts_description_38, p2_.video AS video_39, p2_.video_title AS video_title_40, p2_.filter AS filter_41, p2_.base_price AS base_price_42, p2_.base_price_comment AS base_price_comment_43, p2_.is_new AS is_new_44, p2_.dickson_code AS dickson_code_45, p2_.groupe_article AS groupe_article_46, p2_.access_interne AS access_interne_47, p2_.created_by AS created_by_48, p2_.updated_by AS updated_by_49, p2_.created_at AS created_at_50, p2_.updated_at AS updated_at_51, p2_.publish_start AS publish_start_52, p2_.publish_end AS publish_end_53, p2_.status AS status_54, p2_.mac_brand AS mac_brand_55, p2_.mac_app AS mac_app_56, p2_.reference AS reference_57, p3_.id AS id_58, p3_.slug AS slug_59, p3_.title AS title_60, p3_.name AS name_61, p3_.seo_heading AS seo_heading_62, p3_.description AS description_63, p3_.position AS position_64, p3_.class AS class_65, p3_.configurator_url AS configurator_url_66, p3_.advice_title AS advice_title_67, p3_.advice_line AS advice_line_68, p3_.baseline AS baseline_69, p3_.brochure_description AS brochure_description_70, p3_.brochure2description AS brochure2description_71, p3_.brochure3description AS brochure3description_72, p3_.dickson AS dickson_73, p3_.equipment_link AS equipment_link_74, p3_.`range` AS range_75, p3_.sub_range AS sub_range_76, p3_.menu_hidden AS menu_hidden_77, p3_.is_professional AS is_professional_78, p3_.created_by AS created_by_79, p3_.updated_by AS updated_by_80, p3_.created_at AS created_at_81, p3_.updated_at AS updated_at_82, p3_.publish_start AS publish_start_83, p3_.publish_end AS publish_end_84, p3_.status AS status_85, p3_.mac_brand AS mac_brand_86, p3_.mac_app AS mac_app_87, p3_.reference AS reference_88, p4_.id AS id_89, p4_.slug AS slug_90, p4_.title AS title_91, p4_.name AS name_92, p4_.seo_heading AS seo_heading_93, p4_.description AS description_94, p4_.position AS position_95, p4_.class AS class_96, p4_.configurator_url AS configurator_url_97, p4_.advice_title AS advice_title_98, p4_.advice_line AS advice_line_99, p4_.baseline AS baseline_100, p4_.brochure_description AS brochure_description_101, p4_.brochure2description AS brochure2description_102, p4_.brochure3description AS brochure3description_103, p4_.dickson AS dickson_104, p4_.equipment_link AS equipment_link_105, p4_.`range` AS range_106, p4_.sub_range AS sub_range_107, p4_.menu_hidden AS menu_hidden_108, p4_.is_professional AS is_professional_109, p4_.created_by AS created_by_110, p4_.updated_by AS updated_by_111, p4_.created_at AS created_at_112, p4_.updated_at AS updated_at_113, p4_.publish_start AS publish_start_114, p4_.publish_end AS publish_end_115, p4_.status AS status_116, p4_.mac_brand AS mac_brand_117, p4_.mac_app AS mac_app_118, p4_.reference AS reference_119, p5_.id AS id_120, p5_.position AS position_121, p5_.description AS description_122, p5_.created_by AS created_by_123, p5_.updated_by AS updated_by_124, p5_.created_at AS created_at_125, p5_.updated_at AS updated_at_126, t6_.id AS id_127, t6_.name AS name_128, t6_.path AS path_129, n0_.news_category_id AS news_category_id_130, n0_.point_of_sale_id AS point_of_sale_id_131, n0_.file_id AS file_id_132, n0_.file_mobile_id AS file_mobile_id_133, n0_.attached_file_id AS attached_file_id_134, p2_.image_expert_id AS image_expert_id_135, p2_.product_category_id AS product_category_id_136, p2_.fallback_product_id AS fallback_product_id_137, p2_.image_inspiration_id AS image_inspiration_id_138, p2_.image_inspiration_mobile_id AS image_inspiration_mobile_id_139, p3_.file_id AS file_id_140, p3_.image_mega_menu_id AS image_mega_menu_id_141, p3_.image_mobile_id AS image_mobile_id_142, p3_.parent_id AS parent_id_143, p3_.brochure_id AS brochure_id_144, p3_.brochure_image_id AS brochure_image_id_145, p3_.brochure2_id AS brochure2_id_146, p3_.brochure2image_id AS brochure2image_id_147, p3_.brochure3_id AS brochure3_id_148, p3_.brochure3image_id AS brochure3image_id_149, p3_.image_inspiration_id AS image_inspiration_id_150, p3_.image_inspiration_mobile_id AS image_inspiration_mobile_id_151, p4_.file_id AS file_id_152, p4_.image_mega_menu_id AS image_mega_menu_id_153, p4_.image_mobile_id AS image_mobile_id_154, p4_.parent_id AS parent_id_155, p4_.brochure_id AS brochure_id_156, p4_.brochure_image_id AS brochure_image_id_157, p4_.brochure2_id AS brochure2_id_158, p4_.brochure2image_id AS brochure2image_id_159, p4_.brochure3_id AS brochure3_id_160, p4_.brochure3image_id AS brochure3image_id_161, p4_.image_inspiration_id AS image_inspiration_id_162, p4_.image_inspiration_mobile_id AS image_inspiration_mobile_id_163, p5_.file_id AS file_id_164, p5_.file_mobile_id AS file_mobile_id_165, p5_.product_id AS product_id_166 FROM news n0_ LEFT JOIN _file t1_ ON n0_.file_id = t1_.id AND (1) LEFT JOIN product_to_news p7_ ON n0_.id = p7_.news_id LEFT JOIN product p2_ ON p2_.id = p7_.product_id AND (p2_.mac_brand = 'FA' AND p2_.mac_app = 'fa') AND (p2_.status = 'published' AND p2_.publish_start <= '2026-08-02 19'published''2026-08-02 19:37:14'' AND (p2_.publish_end IS NULL OR p2_.publish_end >= '2026-08-02 19'2026-08-02 19:37:14''published'')) LEFT JOIN product_category p3_ ON p2_.product_category_id = p3_.id AND (p3_.mac_brand = 'FA' AND p3_.mac_app = 'fa') AND (p3_.status = 'published' AND p3_.publish_start <= '2026-08-02 19'2026-08-02 19:37:14''2026-08-02 19:37:14'' AND (p3_.publish_end IS NULL OR p3_.publish_end >= '2026-08-02 19'motorisation-autonome-sonesse-28-li-ion':14')) LEFT JOIN product_category p4_ ON p3_.parent_id = p4_.id AND (p4_.mac_brand = 'FA' AND p4_.mac_app = 'fa') AND (p4_.status = 'published' AND p4_.publish_start <= '2026-08-02 19:37:14' AND (p4_.publish_end IS NULL OR p4_.publish_end >= '2026-08-02 19:37:14')) LEFT JOIN product_image p5_ ON p2_.id = p5_.product_id AND (1) LEFT JOIN _file t6_ ON p5_.file_id = t6_.id AND (1) WHERE (n0_.status IN (?) AND n0_.publish_start <= ? AND (n0_.publish_end IS NULL OR n0_.publish_end >= ?) AND n0_.status IN (?) AND n0_.publish_start <= ? AND (n0_.publish_end IS NULL OR n0_.publish_end >= ?) AND n0_.slug = ?) AND (n0_.mac_brand = 'FA' AND n0_.mac_app = 'fa') ORDER BY n0_.publish_start DESC, p5_.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/nos-actualites/motorisation-autonome-sonesse-28-li-ion.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;