Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 14
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine 2
• Debug
• Emails
• Notifications
• Serializer
• VichUploader
• Configuration

Query Metrics

SELECT t0.id AS id_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.is_email_verified AS is_email_verified_9, t0.is_phone_verified AS is_phone_verified_10, t0.email_verification_token AS email_verification_token_11, t0.phone_verification_token AS phone_verification_token_12, t0.status AS status_13, t0.pending_email AS pending_email_14, t0.pending_phone AS pending_phone_15, t0.reference AS reference_16, t0.created_at AS created_at_17, t0.last_name AS last_name_18, t0.first_name AS first_name_19, t0.phone AS phone_20, t0.discriminator_type, t2.name AS name_21, t2.profile_picture AS profile_picture_22, t2.description AS description_23, t2.slug AS slug_24, t2.is_visible AS is_visible_25, t3.agency_id AS agency_id_26 FROM user t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN agency t2 ON t0.id = t2.id LEFT JOIN employee t3 ON t0.id = t3.id LEFT JOIN client t4 ON t0.id = t4.id WHERE t0.id = ?

[
  "019bd724-370a-7176-94e1-f55468d22e02"
]

SELECT
  t0.id AS id_5,
  t0.email AS email_6,
  t0.roles AS roles_7,
  t0.password AS password_8,
  t0.is_email_verified AS is_email_verified_9,
  t0.is_phone_verified AS is_phone_verified_10,
  t0.email_verification_token AS email_verification_token_11,
  t0.phone_verification_token AS phone_verification_token_12,
  t0.status AS status_13,
  t0.pending_email AS pending_email_14,
  t0.pending_phone AS pending_phone_15,
  t0.reference AS reference_16,
  t0.created_at AS created_at_17,
  t0.last_name AS last_name_18,
  t0.first_name AS first_name_19,
  t0.phone AS phone_20,
  t0.discriminator_type,
  t2.name AS name_21,
  t2.profile_picture AS profile_picture_22,
  t2.description AS description_23,
  t2.slug AS slug_24,
  t2.is_visible AS is_visible_25,
  t3.agency_id AS agency_id_26
FROM
  user t0
  LEFT JOIN admin t1 ON t0.id = t1.id
  LEFT JOIN agency t2 ON t0.id = t2.id
  LEFT JOIN employee t3 ON t0.id = t3.id
  LEFT JOIN client t4 ON t0.id = t4.id
WHERE
  t0.id = ?

SELECT t0.id AS id_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.is_email_verified AS is_email_verified_9, t0.is_phone_verified AS is_phone_verified_10, t0.email_verification_token AS email_verification_token_11, t0.phone_verification_token AS phone_verification_token_12, t0.status AS status_13, t0.pending_email AS pending_email_14, t0.pending_phone AS pending_phone_15, t0.reference AS reference_16, t0.created_at AS created_at_17, t0.last_name AS last_name_18, t0.first_name AS first_name_19, t0.phone AS phone_20, t0.discriminator_type, t2.name AS name_21, t2.profile_picture AS profile_picture_22, t2.description AS description_23, t2.slug AS slug_24, t2.is_visible AS is_visible_25, t3.agency_id AS agency_id_26 FROM user t0 LEFT JOIN admin t1 ON t0.id = t1.id LEFT JOIN agency t2 ON t0.id = t2.id LEFT JOIN employee t3 ON t0.id = t3.id LEFT JOIN client t4 ON t0.id = t4.id WHERE t0.id = '019bd724-370a-7176-94e1-f55468d22e02';

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM agency_address a0_ WHERE a0_.agency_id = ?

[
  "019bd724-370a-7176-94e1-f55468d22e02"
]

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  agency_address a0_
WHERE
  a0_.agency_id = ?

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM agency_address a0_ WHERE a0_.agency_id = '019bd724-370a-7176-94e1-f55468d22e02';

SELECT DISTINCT a0_.id AS id_0, a0_.id AS id_1 FROM agency_address a0_ WHERE a0_.agency_id = ? ORDER BY a0_.id DESC LIMIT 10

[
  "019bd724-370a-7176-94e1-f55468d22e02"
]

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.id AS id_1
FROM
  agency_address a0_
WHERE
  a0_.agency_id = ?
ORDER BY
  a0_.id DESC
LIMIT
  10

SELECT DISTINCT a0_.id AS id_0, a0_.id AS id_1 FROM agency_address a0_ WHERE a0_.agency_id = '019bd724-370a-7176-94e1-f55468d22e02' ORDER BY a0_.id DESC LIMIT 10;

SELECT a0_.id AS id_0, a0_.addresses AS addresses_1, a0_.city_id AS city_id_2, a0_.agency_id AS agency_id_3 FROM agency_address a0_ WHERE a0_.agency_id = ? AND a0_.id IN (?, ?) ORDER BY a0_.id DESC

[
  "019bd724-370a-7176-94e1-f55468d22e02"
  2
  1
]

SELECT
  a0_.id AS id_0,
  a0_.addresses AS addresses_1,
  a0_.city_id AS city_id_2,
  a0_.agency_id AS agency_id_3
FROM
  agency_address a0_
WHERE
  a0_.agency_id = ?
  AND a0_.id IN (?, ?)
ORDER BY
  a0_.id DESC

SELECT a0_.id AS id_0, a0_.addresses AS addresses_1, a0_.city_id AS city_id_2, a0_.agency_id AS agency_id_3 FROM agency_address a0_ WHERE a0_.agency_id = '019bd724-370a-7176-94e1-f55468d22e02' AND a0_.id IN (2, 1) ORDER BY a0_.id DESC;

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2 FROM city t0 WHERE t0.id = ?

[
  5
]

SELECT
  t0.id AS id_1,
  t0.name_fr AS name_fr_2
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2 FROM city t0 WHERE t0.id = 5;

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2 FROM city t0 WHERE t0.id = ?

[
  2
]

SELECT
  t0.id AS id_1,
  t0.name_fr AS name_fr_2
FROM
  city t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2 FROM city t0 WHERE t0.id = 2;