Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.image AS image_2,
  p0_.price AS price_3,
  p0_.description AS description_4,
  p0_.old_price AS old_price_5,
  p0_.quantity AS quantity_6,
  p0_.product_type AS product_type_7,
  p0_.meta_title AS meta_title_8,
  p0_.meta_description AS meta_description_9,
  p0_.meta_keywords AS meta_keywords_10,
  p0_.slug AS slug_11,
  p0_.created_at AS created_at_12,
  p0_.is_price_reduced_per_percent AS is_price_reduced_per_percent_13,
  p0_.percent_reduction AS percent_reduction_14,
  p0_.sku_code AS sku_code_15,
  p0_.short_description AS short_description_16,
  p0_.is_published AS is_published_17,
  p0_.sku_code_shop AS sku_code_shop_18,
  p0_.end_at AS end_at_19,
  p0_.type_reduction AS type_reduction_20,
  p0_.value_reduction AS value_reduction_21,
  p0_.subscription_monthly_price AS subscription_monthly_price_22,
  p0_.subscription_yearly_price AS subscription_yearly_price_23,
  p0_.deleted_at AS deleted_at_24,
  p0_.label_price_from AS label_price_from_25,
  p0_.capacity AS capacity_26,
  a1_.regular_price AS regular_price_27,
  p0_.dtype AS dtype_28,
  p0_.promotion_id AS promotion_id_29,
  p0_.vendor_id AS vendor_id_30,
  p0_.brand_id AS brand_id_31,
  p0_.parent_category_id AS parent_category_id_32,
  p0_.cloned_product_id AS cloned_product_id_33,
  p0_.store_id AS store_id_34
FROM
  product p0_
  LEFT JOIN article a1_ ON p0_.id = a1_.id
  LEFT JOIN shop_product s2_ ON p0_.id = s2_.id
  LEFT JOIN promotion p3_ ON p0_.promotion_id = p3_.id
  LEFT JOIN vendor v4_ ON p0_.vendor_id = v4_.id
  LEFT JOIN user u5_ ON v4_.user_id = u5_.id
WHERE
  (
    (
      p0_.is_published = 1
      AND u5_.is_valid = 1
    )
    AND p3_.id IS NOT NULL
    AND p3_.end_at > ?
  )
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_.id DESC
LIMIT
  10

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.image AS image_2, p0_.price AS price_3, p0_.description AS description_4, p0_.old_price AS old_price_5, p0_.quantity AS quantity_6, p0_.product_type AS product_type_7, p0_.meta_title AS meta_title_8, p0_.meta_description AS meta_description_9, p0_.meta_keywords AS meta_keywords_10, p0_.slug AS slug_11, p0_.created_at AS created_at_12, p0_.is_price_reduced_per_percent AS is_price_reduced_per_percent_13, p0_.percent_reduction AS percent_reduction_14, p0_.sku_code AS sku_code_15, p0_.short_description AS short_description_16, p0_.is_published AS is_published_17, p0_.sku_code_shop AS sku_code_shop_18, p0_.end_at AS end_at_19, p0_.type_reduction AS type_reduction_20, p0_.value_reduction AS value_reduction_21, p0_.subscription_monthly_price AS subscription_monthly_price_22, p0_.subscription_yearly_price AS subscription_yearly_price_23, p0_.deleted_at AS deleted_at_24, p0_.label_price_from AS label_price_from_25, p0_.capacity AS capacity_26, a1_.regular_price AS regular_price_27, p0_.dtype AS dtype_28, p0_.promotion_id AS promotion_id_29, p0_.vendor_id AS vendor_id_30, p0_.brand_id AS brand_id_31, p0_.parent_category_id AS parent_category_id_32, p0_.cloned_product_id AS cloned_product_id_33, p0_.store_id AS store_id_34 FROM product p0_ LEFT JOIN article a1_ ON p0_.id = a1_.id LEFT JOIN shop_product s2_ ON p0_.id = s2_.id LEFT JOIN promotion p3_ ON p0_.promotion_id = p3_.id LEFT JOIN vendor v4_ ON p0_.vendor_id = v4_.id LEFT JOIN user u5_ ON v4_.user_id = u5_.id WHERE ((p0_.is_published = 1 AND u5_.is_valid = 1) AND p3_.id IS NOT NULL AND p3_.end_at > '2025-07-31 00:48:03') AND (p0_.deleted_at IS NULL) ORDER BY p0_.id DESC LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.is_monday AS is_monday_2,
  t0.is_tuesday AS is_tuesday_3,
  t0.is_wednesday AS is_wednesday_4,
  t0.is_thursday AS is_thursday_5,
  t0.is_friday AS is_friday_6,
  t0.is_saturday AS is_saturday_7,
  t0.is_sunday AS is_sunday_8,
  t0.start_work_at AS start_work_at_9,
  t0.end_work_at AS end_work_at_10,
  t0.exclude_days AS exclude_days_11,
  t0.exclude_dates AS exclude_dates_12,
  t0.exclude_hours AS exclude_hours_13,
  t0.logo AS logo_14,
  t0.logo_base64 AS logo_base64_15,
  t0.favicon AS favicon_16,
  t0.email AS email_17,
  t0.address AS address_18,
  t0.currency AS currency_19,
  t0.default_lang AS default_lang_20,
  t0.project_name AS project_name_21,
  t0.code AS code_22,
  t0.asset_folder_name AS asset_folder_name_23,
  t0.mail_order_created_body AS mail_order_created_body_24,
  t0.mail_order_created_title AS mail_order_created_title_25,
  t0.prefix_order AS prefix_order_26,
  t0.root_url AS root_url_27,
  t0.description AS description_28,
  t0.is_mercure_enabled AS is_mercure_enabled_29,
  t0.mobile_app_scheme AS mobile_app_scheme_30,
  t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_31,
  t0.developpement_env AS developpement_env_32,
  t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_33,
  t0.mobile_app_scheme_android AS mobile_app_scheme_android_34,
  t0.front_theme_id AS front_theme_id_35
FROM
  settings t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.mobile_app_scheme AS mobile_app_scheme_30, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_31, t0.developpement_env AS developpement_env_32, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_33, t0.mobile_app_scheme_android AS mobile_app_scheme_android_34, t0.front_theme_id AS front_theme_id_35 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.first_title_section AS first_title_section_3,
  t0.first_text_section AS first_text_section_4,
  t0.second_title_section AS second_title_section_5,
  t0.second_text_section AS second_text_section_6,
  t0.third_title_section AS third_title_section_7,
  t0.third_text_section AS third_text_section_8,
  t0.text_card1 AS text_card1_9,
  t0.text_flip_card1 AS text_flip_card1_10,
  t0.text_card2 AS text_card2_11,
  t0.text_flip_card2 AS text_flip_card2_12,
  t0.text_card3 AS text_card3_13,
  t0.text_flip_card3 AS text_flip_card3_14,
  t0.text_card4 AS text_card4_15,
  t0.text_flip_card4 AS text_flip_card4_16,
  t0.text_card5 AS text_card5_17,
  t0.text_flip_card5 AS text_flip_card5_18,
  t0.text_card6 AS text_card6_19,
  t0.text_flip_card6 AS text_flip_card6_20,
  t0.text_card7 AS text_card7_21,
  t0.text_flip_card7 AS text_flip_card7_22,
  t0.text_card8 AS text_card8_23,
  t0.text_flip_card8 AS text_flip_card8_24,
  t0.text_card9 AS text_card9_25,
  t0.text_flip9 AS text_flip9_26,
  t0.text_card10 AS text_card10_27,
  t0.text_flip10 AS text_flip10_28,
  t0.text_card11 AS text_card11_29,
  t0.text_flip11 AS text_flip11_30,
  t0.text_card12 AS text_card12_31,
  t0.text_flip12 AS text_flip12_32,
  t0.gallery AS gallery_33,
  t0.banner AS banner_34,
  t0.link_youtube AS link_youtube_35,
  t0.is_new_lead AS is_new_lead_36,
  t0.whatsapp AS whatsapp_37
FROM
  home_page t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.first_title_section AS first_title_section_3, t0.first_text_section AS first_text_section_4, t0.second_title_section AS second_title_section_5, t0.second_text_section AS second_text_section_6, t0.third_title_section AS third_title_section_7, t0.third_text_section AS third_text_section_8, t0.text_card1 AS text_card1_9, t0.text_flip_card1 AS text_flip_card1_10, t0.text_card2 AS text_card2_11, t0.text_flip_card2 AS text_flip_card2_12, t0.text_card3 AS text_card3_13, t0.text_flip_card3 AS text_flip_card3_14, t0.text_card4 AS text_card4_15, t0.text_flip_card4 AS text_flip_card4_16, t0.text_card5 AS text_card5_17, t0.text_flip_card5 AS text_flip_card5_18, t0.text_card6 AS text_card6_19, t0.text_flip_card6 AS text_flip_card6_20, t0.text_card7 AS text_card7_21, t0.text_flip_card7 AS text_flip_card7_22, t0.text_card8 AS text_card8_23, t0.text_flip_card8 AS text_flip_card8_24, t0.text_card9 AS text_card9_25, t0.text_flip9 AS text_flip9_26, t0.text_card10 AS text_card10_27, t0.text_flip10 AS text_flip10_28, t0.text_card11 AS text_card11_29, t0.text_flip11 AS text_flip11_30, t0.text_card12 AS text_card12_31, t0.text_flip12 AS text_flip12_32, t0.gallery AS gallery_33, t0.banner AS banner_34, t0.link_youtube AS link_youtube_35, t0.is_new_lead AS is_new_lead_36, t0.whatsapp AS whatsapp_37 FROM home_page t0 WHERE t0.id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.css_classes AS css_classes_3,
  t0.type AS type_4,
  t0.route_name AS route_name_5,
  t0.route_param AS route_param_6,
  t0.route_param_value AS route_param_value_7,
  t0.url AS url_8,
  t0.role AS role_9,
  t0.anchor AS anchor_10,
  t0.position AS position_11,
  t0.attributes AS attributes_12,
  t0.link_css_classes AS link_css_classes_13,
  t0.hide_if_role AS hide_if_role_14,
  t0.deleted_at AS deleted_at_15,
  t0.menu_id AS menu_id_16,
  t0.parent_menu_item_id AS parent_menu_item_id_17,
  t0.link_id AS link_id_18,
  t0.link_type_id AS link_type_id_19
FROM
  menu_item t0
WHERE
  (
    t0.parent_menu_item_id IS NULL
    AND t0.menu_id = ?
  )
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.css_classes AS css_classes_3, t0.type AS type_4, t0.route_name AS route_name_5, t0.route_param AS route_param_6, t0.route_param_value AS route_param_value_7, t0.url AS url_8, t0.role AS role_9, t0.anchor AS anchor_10, t0.position AS position_11, t0.attributes AS attributes_12, t0.link_css_classes AS link_css_classes_13, t0.hide_if_role AS hide_if_role_14, t0.deleted_at AS deleted_at_15, t0.menu_id AS menu_id_16, t0.parent_menu_item_id AS parent_menu_item_id_17, t0.link_id AS link_id_18, t0.link_type_id AS link_type_id_19 FROM menu_item t0 WHERE (t0.parent_menu_item_id IS NULL AND t0.menu_id = 1) AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.css_classes AS css_classes_3,
  t0.created_at AS created_at_4,
  t0.is_main_menu AS is_main_menu_5
FROM
  menu t0
WHERE
  t0.is_main_menu = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.css_classes AS css_classes_3, t0.created_at AS created_at_4, t0.is_main_menu AS is_main_menu_5 FROM menu t0 WHERE t0.is_main_menu = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.grand_titre AS grand_titre_3,
  t0.petit_titre AS petit_titre_4,
  t0.texte_prix AS texte_prix_5,
  t0.lien AS lien_6,
  t0.titre_btn AS titre_btn_7,
  t0.is_enabled AS is_enabled_8
FROM
  master_slider t0
WHERE
  t0.is_enabled = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.grand_titre AS grand_titre_3, t0.petit_titre AS petit_titre_4, t0.texte_prix AS texte_prix_5, t0.lien AS lien_6, t0.titre_btn AS titre_btn_7, t0.is_enabled AS is_enabled_8 FROM master_slider t0 WHERE t0.is_enabled = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.commission AS commission_5,
  t0.for_product_type AS for_product_type_6,
  t0.old_id AS old_id_7,
  t0.parent_category_id AS parent_category_id_8
FROM
  flexy_categoryproduct t0
WHERE
  t0.parent_category_id IS NULL

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.commission AS commission_5, t0.for_product_type AS for_product_type_6, t0.old_id AS old_id_7, t0.parent_category_id AS parent_category_id_8 FROM flexy_categoryproduct t0 WHERE t0.parent_category_id IS NULL;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.date_debut AS date_debut_5,
  t0.date_fin AS date_fin_6,
  t0.under_title AS under_title_7,
  t0.type AS type_8
FROM
  newshome t0
WHERE
  t0.type = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.date_debut AS date_debut_5, t0.date_fin AS date_fin_6, t0.under_title AS under_title_7, t0.type AS type_8 FROM newshome t0 WHERE t0.type = 'Annonce';

SELECT
  t0.id AS id_1,
  t0.image AS image_2,
  t0.lien AS lien_3,
  t0.emplacement AS emplacement_4,
  t0.is_enabled AS is_enabled_5,
  t0.is_text_white AS is_text_white_6,
  t0.petit_titre AS petit_titre_7,
  t0.grand_titre AS grand_titre_8,
  t0.texte_prix AS texte_prix_9,
  t0.titre_btn AS titre_btn_10
FROM
  pub_banner t0
WHERE
  t0.is_enabled = ?

SELECT t0.id AS id_1, t0.image AS image_2, t0.lien AS lien_3, t0.emplacement AS emplacement_4, t0.is_enabled AS is_enabled_5, t0.is_text_white AS is_text_white_6, t0.petit_titre AS petit_titre_7, t0.grand_titre AS grand_titre_8, t0.texte_prix AS texte_prix_9, t0.titre_btn AS titre_btn_10 FROM pub_banner t0 WHERE t0.is_enabled = 1;

SELECT
  t0.id AS id_3,
  t0.name AS name_4,
  t0.image AS image_5,
  t0.price AS price_6,
  t0.description AS description_7,
  t0.old_price AS old_price_8,
  t0.quantity AS quantity_9,
  t0.product_type AS product_type_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.meta_keywords AS meta_keywords_13,
  t0.slug AS slug_14,
  t0.created_at AS created_at_15,
  t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16,
  t0.percent_reduction AS percent_reduction_17,
  t0.sku_code AS sku_code_18,
  t0.short_description AS short_description_19,
  t0.is_published AS is_published_20,
  t0.sku_code_shop AS sku_code_shop_21,
  t0.end_at AS end_at_22,
  t0.type_reduction AS type_reduction_23,
  t0.value_reduction AS value_reduction_24,
  t0.subscription_monthly_price AS subscription_monthly_price_25,
  t0.subscription_yearly_price AS subscription_yearly_price_26,
  t0.deleted_at AS deleted_at_27,
  t0.label_price_from AS label_price_from_28,
  t0.capacity AS capacity_29,
  t0.promotion_id AS promotion_id_30,
  t0.vendor_id AS vendor_id_31,
  t0.brand_id AS brand_id_32,
  t0.parent_category_id AS parent_category_id_33,
  t0.cloned_product_id AS cloned_product_id_34,
  t0.store_id AS store_id_35,
  t0.dtype,
  t1.regular_price AS regular_price_36
FROM
  product t0
  LEFT JOIN article t1 ON t0.id = t1.id
  LEFT JOIN shop_product t2 ON t0.id = t2.id
WHERE
  t0.product_type IN (?)
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_3, t0.name AS name_4, t0.image AS image_5, t0.price AS price_6, t0.description AS description_7, t0.old_price AS old_price_8, t0.quantity AS quantity_9, t0.product_type AS product_type_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16, t0.percent_reduction AS percent_reduction_17, t0.sku_code AS sku_code_18, t0.short_description AS short_description_19, t0.is_published AS is_published_20, t0.sku_code_shop AS sku_code_shop_21, t0.end_at AS end_at_22, t0.type_reduction AS type_reduction_23, t0.value_reduction AS value_reduction_24, t0.subscription_monthly_price AS subscription_monthly_price_25, t0.subscription_yearly_price AS subscription_yearly_price_26, t0.deleted_at AS deleted_at_27, t0.label_price_from AS label_price_from_28, t0.capacity AS capacity_29, t0.promotion_id AS promotion_id_30, t0.vendor_id AS vendor_id_31, t0.brand_id AS brand_id_32, t0.parent_category_id AS parent_category_id_33, t0.cloned_product_id AS cloned_product_id_34, t0.store_id AS store_id_35, t0.dtype, t1.regular_price AS regular_price_36 FROM product t0 LEFT JOIN article t1 ON t0.id = t1.id LEFT JOIN shop_product t2 ON t0.id = t2.id WHERE t0.product_type IN ('subscription') AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_3,
  t0.name AS name_4,
  t0.image AS image_5,
  t0.price AS price_6,
  t0.description AS description_7,
  t0.old_price AS old_price_8,
  t0.quantity AS quantity_9,
  t0.product_type AS product_type_10,
  t0.meta_title AS meta_title_11,
  t0.meta_description AS meta_description_12,
  t0.meta_keywords AS meta_keywords_13,
  t0.slug AS slug_14,
  t0.created_at AS created_at_15,
  t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16,
  t0.percent_reduction AS percent_reduction_17,
  t0.sku_code AS sku_code_18,
  t0.short_description AS short_description_19,
  t0.is_published AS is_published_20,
  t0.sku_code_shop AS sku_code_shop_21,
  t0.end_at AS end_at_22,
  t0.type_reduction AS type_reduction_23,
  t0.value_reduction AS value_reduction_24,
  t0.subscription_monthly_price AS subscription_monthly_price_25,
  t0.subscription_yearly_price AS subscription_yearly_price_26,
  t0.deleted_at AS deleted_at_27,
  t0.label_price_from AS label_price_from_28,
  t0.capacity AS capacity_29,
  t0.promotion_id AS promotion_id_30,
  t0.vendor_id AS vendor_id_31,
  t0.brand_id AS brand_id_32,
  t0.parent_category_id AS parent_category_id_33,
  t0.cloned_product_id AS cloned_product_id_34,
  t0.store_id AS store_id_35,
  t0.dtype,
  t1.regular_price AS regular_price_36
FROM
  product t0
  LEFT JOIN article t1 ON t0.id = t1.id
  LEFT JOIN shop_product t2 ON t0.id = t2.id
WHERE
  t0.is_published = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.id ASC
LIMIT
  12

SELECT t0.id AS id_3, t0.name AS name_4, t0.image AS image_5, t0.price AS price_6, t0.description AS description_7, t0.old_price AS old_price_8, t0.quantity AS quantity_9, t0.product_type AS product_type_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.meta_keywords AS meta_keywords_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.is_price_reduced_per_percent AS is_price_reduced_per_percent_16, t0.percent_reduction AS percent_reduction_17, t0.sku_code AS sku_code_18, t0.short_description AS short_description_19, t0.is_published AS is_published_20, t0.sku_code_shop AS sku_code_shop_21, t0.end_at AS end_at_22, t0.type_reduction AS type_reduction_23, t0.value_reduction AS value_reduction_24, t0.subscription_monthly_price AS subscription_monthly_price_25, t0.subscription_yearly_price AS subscription_yearly_price_26, t0.deleted_at AS deleted_at_27, t0.label_price_from AS label_price_from_28, t0.capacity AS capacity_29, t0.promotion_id AS promotion_id_30, t0.vendor_id AS vendor_id_31, t0.brand_id AS brand_id_32, t0.parent_category_id AS parent_category_id_33, t0.cloned_product_id AS cloned_product_id_34, t0.store_id AS store_id_35, t0.dtype, t1.regular_price AS regular_price_36 FROM product t0 LEFT JOIN article t1 ON t0.id = t1.id LEFT JOIN shop_product t2 ON t0.id = t2.id WHERE t0.is_published = 1 AND ((t0.deleted_at IS NULL)) ORDER BY t0.id ASC LIMIT 12;

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.description AS description_2,
  n0_.image AS image_3,
  n0_.date_debut AS date_debut_4,
  n0_.date_fin AS date_fin_5,
  n0_.under_title AS under_title_6,
  n0_.type AS type_7
FROM
  newshome n0_
WHERE
  n0_.type = ?
  AND n0_.date_debut <= ?
  AND n0_.date_fin >= ?

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.image AS image_3, n0_.date_debut AS date_debut_4, n0_.date_fin AS date_fin_5, n0_.under_title AS under_title_6, n0_.type AS type_7 FROM newshome n0_ WHERE n0_.type = 'Offre' AND n0_.date_debut <= '2025-07-31 00:48:03' AND n0_.date_fin >= '2025-07-31 00:48:03';

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.image AS image_4,
  t0.date_debut AS date_debut_5,
  t0.date_fin AS date_fin_6,
  t0.under_title AS under_title_7,
  t0.type AS type_8
FROM
  newshome t0
WHERE
  t0.type IS NULL

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.image AS image_4, t0.date_debut AS date_debut_5, t0.date_fin AS date_fin_6, t0.under_title AS under_title_7, t0.type AS type_8 FROM newshome t0 WHERE t0.type IS NULL;