Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 7
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.employee_id AS employee_id_9 FROM `user` t0 WHERE t0.email = ? LIMIT 1

[
  "superadmin1@yopmail.com"
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.status AS status_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.employee_id AS employee_id_9
FROM
  `user` t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.status AS status_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.employee_id AS employee_id_9 FROM `user` t0 WHERE t0.email = 'superadmin1@yopmail.com' LIMIT 1;

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.active AS active_4, t0.automatic_renewal AS automatic_renewal_5, t0.cycle AS cycle_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.amount AS amount_10, t0.company_id AS company_id_11, t0.pricing_id AS pricing_id_12 FROM subscription t0 WHERE t0.company_id = ? AND t0.active = ? LIMIT 1

[
  1
  1
]

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.active AS active_4,
  t0.automatic_renewal AS automatic_renewal_5,
  t0.cycle AS cycle_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.amount AS amount_10,
  t0.company_id AS company_id_11,
  t0.pricing_id AS pricing_id_12
FROM
  subscription t0
WHERE
  t0.company_id = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.active AS active_4, t0.automatic_renewal AS automatic_renewal_5, t0.cycle AS cycle_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.amount AS amount_10, t0.company_id AS company_id_11, t0.pricing_id AS pricing_id_12 FROM subscription t0 WHERE t0.company_id = 1 AND t0.active = 1 LIMIT 1;

SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.phone AS phone_5, t0.gender AS gender_6, t0.birth_date AS birth_date_7, t0.marital_status AS marital_status_8, t0.recruitment_date AS recruitment_date_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.company_id AS company_id_13, t14.id AS id_15, t14.email AS email_16, t14.password AS password_17, t14.roles AS roles_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.deleted_at AS deleted_at_22, t14.employee_id AS employee_id_23, t0.profile_photo_id AS profile_photo_id_24, t0.job_id AS job_id_25, t0.work_schedule_id AS work_schedule_id_26 FROM employee t0 LEFT JOIN `user` t14 ON t14.employee_id = t0.id WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.matricule AS matricule_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.phone AS phone_5,
  t0.gender AS gender_6,
  t0.birth_date AS birth_date_7,
  t0.marital_status AS marital_status_8,
  t0.recruitment_date AS recruitment_date_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12,
  t0.company_id AS company_id_13,
  t14.id AS id_15,
  t14.email AS email_16,
  t14.password AS password_17,
  t14.roles AS roles_18,
  t14.status AS status_19,
  t14.created_at AS created_at_20,
  t14.updated_at AS updated_at_21,
  t14.deleted_at AS deleted_at_22,
  t14.employee_id AS employee_id_23,
  t0.profile_photo_id AS profile_photo_id_24,
  t0.job_id AS job_id_25,
  t0.work_schedule_id AS work_schedule_id_26
FROM
  employee t0
  LEFT JOIN `user` t14 ON t14.employee_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.phone AS phone_5, t0.gender AS gender_6, t0.birth_date AS birth_date_7, t0.marital_status AS marital_status_8, t0.recruitment_date AS recruitment_date_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.company_id AS company_id_13, t14.id AS id_15, t14.email AS email_16, t14.password AS password_17, t14.roles AS roles_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.deleted_at AS deleted_at_22, t14.employee_id AS employee_id_23, t0.profile_photo_id AS profile_photo_id_24, t0.job_id AS job_id_25, t0.work_schedule_id AS work_schedule_id_26 FROM employee t0 LEFT JOIN `user` t14 ON t14.employee_id = t0.id WHERE t0.id = 1;

SELECT t0.id AS id_1, t0.name AS name_2, t0.nif AS nif_3, t0.registration_number AS registration_number_4, t0.is_active AS is_active_5, t0.activity AS activity_6, t0.legal_form AS legal_form_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t11.id AS id_12, t11.allowed_radius_meter AS allowed_radius_meter_13, t11.qr_code_refresh_interval AS qr_code_refresh_interval_14, t11.timezone AS timezone_15, t11.geo_fencing_enabled AS geo_fencing_enabled_16, t11.device_binding_enabled AS device_binding_enabled_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.deleted_at AS deleted_at_20, t11.company_id AS company_id_21, t0.address_id AS address_id_22, t0.logo_id AS logo_id_23, t24.id AS id_25, t24.email AS email_26, t24.currency AS currency_27, t24.company_id AS company_id_28 FROM company t0 LEFT JOIN company_setting t11 ON t11.company_id = t0.id LEFT JOIN billing_setting t24 ON t24.company_id = t0.id WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.nif AS nif_3,
  t0.registration_number AS registration_number_4,
  t0.is_active AS is_active_5,
  t0.activity AS activity_6,
  t0.legal_form AS legal_form_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.deleted_at AS deleted_at_10,
  t11.id AS id_12,
  t11.allowed_radius_meter AS allowed_radius_meter_13,
  t11.qr_code_refresh_interval AS qr_code_refresh_interval_14,
  t11.timezone AS timezone_15,
  t11.geo_fencing_enabled AS geo_fencing_enabled_16,
  t11.device_binding_enabled AS device_binding_enabled_17,
  t11.created_at AS created_at_18,
  t11.updated_at AS updated_at_19,
  t11.deleted_at AS deleted_at_20,
  t11.company_id AS company_id_21,
  t0.address_id AS address_id_22,
  t0.logo_id AS logo_id_23,
  t24.id AS id_25,
  t24.email AS email_26,
  t24.currency AS currency_27,
  t24.company_id AS company_id_28
FROM
  company t0
  LEFT JOIN company_setting t11 ON t11.company_id = t0.id
  LEFT JOIN billing_setting t24 ON t24.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.nif AS nif_3, t0.registration_number AS registration_number_4, t0.is_active AS is_active_5, t0.activity AS activity_6, t0.legal_form AS legal_form_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.deleted_at AS deleted_at_10, t11.id AS id_12, t11.allowed_radius_meter AS allowed_radius_meter_13, t11.qr_code_refresh_interval AS qr_code_refresh_interval_14, t11.timezone AS timezone_15, t11.geo_fencing_enabled AS geo_fencing_enabled_16, t11.device_binding_enabled AS device_binding_enabled_17, t11.created_at AS created_at_18, t11.updated_at AS updated_at_19, t11.deleted_at AS deleted_at_20, t11.company_id AS company_id_21, t0.address_id AS address_id_22, t0.logo_id AS logo_id_23, t24.id AS id_25, t24.email AS email_26, t24.currency AS currency_27, t24.company_id AS company_id_28 FROM company t0 LEFT JOIN company_setting t11 ON t11.company_id = t0.id LEFT JOIN billing_setting t24 ON t24.company_id = t0.id WHERE t0.id = 1;