Symfony Profiler

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

Query Metrics

SELECT t0.`id` AS id_1, t0.`headquarters_name` AS adquarters_name_2, t0.`name` AS name_3, t0.`code` AS code_4, t0.`slug` AS slug_5, t0.`siren` AS siren_6, t0.`siret` AS siret_7, t0.`email` AS email_8, t0.`as_install_serial` AS _install_serial_9, t0.`as_install_key` AS as_install_key_10, t0.`active` AS active_11, t0.`created_at` AS created_at_12, t0.`updated_at` AS updated_at_13 FROM agency t0 WHERE t0.`code` = ? LIMIT 0,1

[
  "02"
]

SELECT
  t0.`id` AS id_1,
  t0.`headquarters_name` AS adquarters_name_2,
  t0.`name` AS name_3,
  t0.`code` AS code_4,
  t0.`slug` AS slug_5,
  t0.`siren` AS siren_6,
  t0.`siret` AS siret_7,
  t0.`email` AS email_8,
  t0.`as_install_serial` AS _install_serial_9,
  t0.`as_install_key` AS as_install_key_10,
  t0.`active` AS active_11,
  t0.`created_at` AS created_at_12,
  t0.`updated_at` AS updated_at_13
FROM
  agency t0
WHERE
  t0.`code` = ?
LIMIT
  0, 1

SELECT t0.`id` AS id_1, t0.`headquarters_name` AS adquarters_name_2, t0.`name` AS name_3, t0.`code` AS code_4, t0.`slug` AS slug_5, t0.`siren` AS siren_6, t0.`siret` AS siret_7, t0.`email` AS email_8, t0.`as_install_serial` AS _install_serial_9, t0.`as_install_key` AS as_install_key_10, t0.`active` AS active_11, t0.`created_at` AS created_at_12, t0.`updated_at` AS updated_at_13 FROM agency t0 WHERE t0.`code` = '02' LIMIT 0,1;

SELECT u0_.`id` AS id_0, u0_.`email` AS email_1, u0_.`roles` AS roles_2, u0_.`idy_person_uuid` AS idy_person_uuid_3, u0_.`idy_acc_pers_uuid` AS y_acc_pers_uuid_4, u0_.`idy_acc_created_at` AS _acc_created_at_5, u0_.`acc_id_lg_space` AS acc_id_lg_space_6, u0_.`user_id_lg_space` AS ser_id_lg_space_7, u0_.`email_lg_space` AS email_lg_space_8, u0_.`active_at_lg_space` AS ive_at_lg_space_9, u0_.`active` AS active_10, u0_.`created_at` AS created_at_11, u0_.`updated_at` AS updated_at_12, f1_.`id` AS id_13, f1_.`uuid` AS uuid_14, f1_.`username` AS username_15, f1_.`email` AS email_16, f1_.`firstname` AS firstname_17, f1_.`lastname` AS lastname_18, f1_.`full_name` AS full_name_19, f1_.`roles` AS roles_20, f1_.`password` AS password_21, f1_.`salt` AS salt_22, f1_.`hash` AS hash_23, f1_.`active` AS active_24, f1_.`last_login_at` AS last_login_at_25, f1_.`created_at` AS created_at_26, f1_.`updated_at` AS updated_at_27, c2_.`id` AS id_28, c2_.`name` AS name_29, c2_.`legal_form` AS legal_form_30, c2_.`siren` AS siren_31, c2_.`siret` AS siret_32, c2_.`naf` AS naf_33, c2_.`phone` AS phone_34, c2_.`address` AS address_35, c2_.`address_complement` AS ess_complement_36, c2_.`zip_code` AS zip_code_37, c2_.`city` AS city_38, c2_.`country` AS country_39, c2_.`slug` AS slug_40, c2_.`idy_uuid_account` AS y_uuid_account_41, c2_.`created_at` AS created_at_42, c2_.`updated_at` AS updated_at_43, a3_.`id` AS id_44, a3_.`client_code` AS client_code_45, a3_.`agency_code` AS agency_code_46, a3_.`client_name` AS client_name_47, a3_.`idy_accnt_org_uuid` AS accnt_org_uuid_48, a3_.`created_at` AS created_at_49, a3_.`updated_at` AS updated_at_50, u0_.user_id AS user_id_51, u0_.client_id AS client_id_52, f1_.last_usr_cli_id AS ast_usr_cli_id_53, a3_.agency_id AS agency_id_54, a3_.client_id AS client_id_55 FROM user_client u0_ INNER JOIN fi_user f1_ ON u0_.user_id = f1_.id INNER JOIN client c2_ ON u0_.client_id = c2_.id INNER JOIN agency_client a3_ ON c2_.id = a3_.client_id WHERE a3_.agency_id = ?

[
  1
]

SELECT
  u0_.`id` AS id_0,
  u0_.`email` AS email_1,
  u0_.`roles` AS roles_2,
  u0_.`idy_person_uuid` AS idy_person_uuid_3,
  u0_.`idy_acc_pers_uuid` AS y_acc_pers_uuid_4,
  u0_.`idy_acc_created_at` AS _acc_created_at_5,
  u0_.`acc_id_lg_space` AS acc_id_lg_space_6,
  u0_.`user_id_lg_space` AS ser_id_lg_space_7,
  u0_.`email_lg_space` AS email_lg_space_8,
  u0_.`active_at_lg_space` AS ive_at_lg_space_9,
  u0_.`active` AS active_10,
  u0_.`created_at` AS created_at_11,
  u0_.`updated_at` AS updated_at_12,
  f1_.`id` AS id_13,
  f1_.`uuid` AS uuid_14,
  f1_.`username` AS username_15,
  f1_.`email` AS email_16,
  f1_.`firstname` AS firstname_17,
  f1_.`lastname` AS lastname_18,
  f1_.`full_name` AS full_name_19,
  f1_.`roles` AS roles_20,
  f1_.`password` AS password_21,
  f1_.`salt` AS salt_22,
  f1_.`hash` AS hash_23,
  f1_.`active` AS active_24,
  f1_.`last_login_at` AS last_login_at_25,
  f1_.`created_at` AS created_at_26,
  f1_.`updated_at` AS updated_at_27,
  c2_.`id` AS id_28,
  c2_.`name` AS name_29,
  c2_.`legal_form` AS legal_form_30,
  c2_.`siren` AS siren_31,
  c2_.`siret` AS siret_32,
  c2_.`naf` AS naf_33,
  c2_.`phone` AS phone_34,
  c2_.`address` AS address_35,
  c2_.`address_complement` AS ess_complement_36,
  c2_.`zip_code` AS zip_code_37,
  c2_.`city` AS city_38,
  c2_.`country` AS country_39,
  c2_.`slug` AS slug_40,
  c2_.`idy_uuid_account` AS y_uuid_account_41,
  c2_.`created_at` AS created_at_42,
  c2_.`updated_at` AS updated_at_43,
  a3_.`id` AS id_44,
  a3_.`client_code` AS client_code_45,
  a3_.`agency_code` AS agency_code_46,
  a3_.`client_name` AS client_name_47,
  a3_.`idy_accnt_org_uuid` AS accnt_org_uuid_48,
  a3_.`created_at` AS created_at_49,
  a3_.`updated_at` AS updated_at_50,
  u0_.user_id AS user_id_51,
  u0_.client_id AS client_id_52,
  f1_.last_usr_cli_id AS ast_usr_cli_id_53,
  a3_.agency_id AS agency_id_54,
  a3_.client_id AS client_id_55
FROM
  user_client u0_
  INNER JOIN fi_user f1_ ON u0_.user_id = f1_.id
  INNER JOIN client c2_ ON u0_.client_id = c2_.id
  INNER JOIN agency_client a3_ ON c2_.id = a3_.client_id
WHERE
  a3_.agency_id = ?

SELECT u0_.`id` AS id_0, u0_.`email` AS email_1, u0_.`roles` AS roles_2, u0_.`idy_person_uuid` AS idy_person_uuid_3, u0_.`idy_acc_pers_uuid` AS y_acc_pers_uuid_4, u0_.`idy_acc_created_at` AS _acc_created_at_5, u0_.`acc_id_lg_space` AS acc_id_lg_space_6, u0_.`user_id_lg_space` AS ser_id_lg_space_7, u0_.`email_lg_space` AS email_lg_space_8, u0_.`active_at_lg_space` AS ive_at_lg_space_9, u0_.`active` AS active_10, u0_.`created_at` AS created_at_11, u0_.`updated_at` AS updated_at_12, f1_.`id` AS id_13, f1_.`uuid` AS uuid_14, f1_.`username` AS username_15, f1_.`email` AS email_16, f1_.`firstname` AS firstname_17, f1_.`lastname` AS lastname_18, f1_.`full_name` AS full_name_19, f1_.`roles` AS roles_20, f1_.`password` AS password_21, f1_.`salt` AS salt_22, f1_.`hash` AS hash_23, f1_.`active` AS active_24, f1_.`last_login_at` AS last_login_at_25, f1_.`created_at` AS created_at_26, f1_.`updated_at` AS updated_at_27, c2_.`id` AS id_28, c2_.`name` AS name_29, c2_.`legal_form` AS legal_form_30, c2_.`siren` AS siren_31, c2_.`siret` AS siret_32, c2_.`naf` AS naf_33, c2_.`phone` AS phone_34, c2_.`address` AS address_35, c2_.`address_complement` AS ess_complement_36, c2_.`zip_code` AS zip_code_37, c2_.`city` AS city_38, c2_.`country` AS country_39, c2_.`slug` AS slug_40, c2_.`idy_uuid_account` AS y_uuid_account_41, c2_.`created_at` AS created_at_42, c2_.`updated_at` AS updated_at_43, a3_.`id` AS id_44, a3_.`client_code` AS client_code_45, a3_.`agency_code` AS agency_code_46, a3_.`client_name` AS client_name_47, a3_.`idy_accnt_org_uuid` AS accnt_org_uuid_48, a3_.`created_at` AS created_at_49, a3_.`updated_at` AS updated_at_50, u0_.user_id AS user_id_51, u0_.client_id AS client_id_52, f1_.last_usr_cli_id AS ast_usr_cli_id_53, a3_.agency_id AS agency_id_54, a3_.client_id AS client_id_55 FROM user_client u0_ INNER JOIN fi_user f1_ ON u0_.user_id = f1_.id INNER JOIN client c2_ ON u0_.client_id = c2_.id INNER JOIN agency_client a3_ ON c2_.id = a3_.client_id WHERE a3_.agency_id = 1;