Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 76
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client 1
• Doctrine 2
• Migrations 170
• Debug
• E-mails
• Notifications
• EasyAdmin
• VichUploader
• Mercure
• Configuration

Query Metrics

SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.code AS code_26, c0_.reference AS reference_27, c0_.identity_number AS identity_number_28, c0_.is_actif AS is_actif_29, c0_.customer_group_id AS customer_group_id_30, c0_.user_id AS user_id_31, c0_.vendor_id AS vendor_id_32, c0_.city_region_id AS city_region_id_33, c0_.store_id AS store_id_34 FROM customer c0_ LEFT JOIN product_subscription p1_ ON c0_.id = p1_.customer_id WHERE (c0_.reference = ? AND (c0_.is_actif IS NULL OR c0_.is_actif = 0) AND ? BETWEEN p1_.start_at AND p1_.end_at) AND (c0_.deleted_at IS NULL)

[
  "1039297095105"
  "2025-06-08 11:22:16"
]

SELECT
  c0_.id AS id_0,
  c0_.description AS description_1,
  c0_.email AS email_2,
  c0_.created_at AS created_at_3,
  c0_.first_name AS first_name_4,
  c0_.last_name AS last_name_5,
  c0_.address AS address_6,
  c0_.city AS city_7,
  c0_.phone AS phone_8,
  c0_.company_name AS company_name_9,
  c0_.address_indication AS address_indication_10,
  c0_.country AS country_11,
  c0_.post_code AS post_code_12,
  c0_.gender AS gender_13,
  c0_.date_of_birth AS date_of_birth_14,
  c0_.sponsorship_code AS sponsorship_code_15,
  c0_.image AS image_16,
  c0_.can_receive_mails AS can_receive_mails_17,
  c0_.can_receive_sms AS can_receive_sms_18,
  c0_.blind_password AS blind_password_19,
  c0_.deleted_at AS deleted_at_20,
  c0_.collect_address AS collect_address_21,
  c0_.shipping_address AS shipping_address_22,
  c0_.collect_lat AS collect_lat_23,
  c0_.collect_lng AS collect_lng_24,
  c0_.shipping_lng AS shipping_lng_25,
  c0_.code AS code_26,
  c0_.reference AS reference_27,
  c0_.identity_number AS identity_number_28,
  c0_.is_actif AS is_actif_29,
  c0_.customer_group_id AS customer_group_id_30,
  c0_.user_id AS user_id_31,
  c0_.vendor_id AS vendor_id_32,
  c0_.city_region_id AS city_region_id_33,
  c0_.store_id AS store_id_34
FROM
  customer c0_
  LEFT JOIN product_subscription p1_ ON c0_.id = p1_.customer_id
WHERE
  (
    c0_.reference = ?
    AND (
      c0_.is_actif IS NULL
      OR c0_.is_actif = 0
    )
    AND ? BETWEEN p1_.start_at
    AND p1_.end_at
  )
  AND (c0_.deleted_at IS NULL)

SELECT c0_.id AS id_0, c0_.description AS description_1, c0_.email AS email_2, c0_.created_at AS created_at_3, c0_.first_name AS first_name_4, c0_.last_name AS last_name_5, c0_.address AS address_6, c0_.city AS city_7, c0_.phone AS phone_8, c0_.company_name AS company_name_9, c0_.address_indication AS address_indication_10, c0_.country AS country_11, c0_.post_code AS post_code_12, c0_.gender AS gender_13, c0_.date_of_birth AS date_of_birth_14, c0_.sponsorship_code AS sponsorship_code_15, c0_.image AS image_16, c0_.can_receive_mails AS can_receive_mails_17, c0_.can_receive_sms AS can_receive_sms_18, c0_.blind_password AS blind_password_19, c0_.deleted_at AS deleted_at_20, c0_.collect_address AS collect_address_21, c0_.shipping_address AS shipping_address_22, c0_.collect_lat AS collect_lat_23, c0_.collect_lng AS collect_lng_24, c0_.shipping_lng AS shipping_lng_25, c0_.code AS code_26, c0_.reference AS reference_27, c0_.identity_number AS identity_number_28, c0_.is_actif AS is_actif_29, c0_.customer_group_id AS customer_group_id_30, c0_.user_id AS user_id_31, c0_.vendor_id AS vendor_id_32, c0_.city_region_id AS city_region_id_33, c0_.store_id AS store_id_34 FROM customer c0_ LEFT JOIN product_subscription p1_ ON c0_.id = p1_.customer_id WHERE (c0_.reference = '1039297095105' AND (c0_.is_actif IS NULL OR c0_.is_actif = 0) AND '2025-06-08 11:22:16' BETWEEN p1_.start_at AND p1_.end_at) AND (c0_.deleted_at IS NULL);

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.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = ? LIMIT 1

[
  "main"
]

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.front_theme_id AS front_theme_id_30
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.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = 'main' LIMIT 1;

SELECT c.*
                    FROM customer c
                    LEFT JOIN product_subscription ps 
                        ON c.id = ps.customer_id
                    WHERE c.reference = ?
                    AND (c.is_actif IS NULL OR c.is_actif = 0)
                    AND ? BETWEEN ps.start_at AND ps.end_at

[
  "1039297095105"
  "2025-06-08 11:22:16"
]

SELECT
  c.*
FROM
  customer c
  LEFT JOIN product_subscription ps ON c.id = ps.customer_id
WHERE
  c.reference = ?
  AND (
    c.is_actif IS NULL
    OR c.is_actif = 0
  )
  AND ? BETWEEN ps.start_at
  AND ps.end_at

SELECT c.*
                    FROM customer c
                    LEFT JOIN product_subscription ps 
                        ON c.id = ps.customer_id
                    WHERE c.reference = '1039297095105'
                    AND (c.is_actif IS NULL OR c.is_actif = 0)
                    AND '2025-06-08 11:22:16' BETWEEN ps.start_at AND ps.end_at
                ;