Symfony Profiler

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.id = ?
  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.id = '97' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.created_at AS created_at_3,
  t0.value AS value_4,
  t0.price AS price_5,
  t0.quantity AS quantity_6,
  t0.code AS code_7,
  t0.attribut_id AS attribut_id_8,
  t0.product_id AS product_id_9
FROM
  attribut_value t0
WHERE
  t0.product_id IN (?)

SELECT t0.id AS id_1, t0.description AS description_2, t0.created_at AS created_at_3, t0.value AS value_4, t0.price AS price_5, t0.quantity AS quantity_6, t0.code AS code_7, t0.attribut_id AS attribut_id_8, t0.product_id AS product_id_9 FROM attribut_value t0 WHERE t0.product_id IN (97);

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 = ?
  AND t0.parent_category_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.short_description ASC

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 = 'service' AND t0.parent_category_id = 4 AND ((t0.deleted_at IS NULL)) ORDER BY t0.short_description ASC;

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 = ?
  AND t0.parent_category_id IS NULL
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.short_description ASC

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 = 'service' AND t0.parent_category_id IS NULL AND ((t0.deleted_at IS NULL)) ORDER BY t0.short_description ASC;

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.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.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.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.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.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.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.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
  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-08-01 14:55:48' AND n0_.date_fin >= '2025-08-01 14:55:48';