Symfony Profiler

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

Query Metrics

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.is_email_verified AS is_email_verified_6, t1.is_phone_verified AS is_phone_verified_7, t1.email_verification_token AS email_verification_token_8, t1.phone_verification_token AS phone_verification_token_9, t1.status AS status_10, t1.pending_email AS pending_email_11, t1.pending_phone AS pending_phone_12, t1.reference AS reference_13, t1.created_at AS created_at_14, t1.last_name AS last_name_15, t1.first_name AS first_name_16, t1.phone AS phone_17, t0.name AS name_18, t0.profile_picture AS profile_picture_19, t0.description AS description_20, t0.slug AS slug_21, t0.is_visible AS is_visible_22, t1.discriminator_type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.reference = ? LIMIT 1

[
  "696E5F4978691"
]

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.roles AS roles_4,
  t1.password AS password_5,
  t1.is_email_verified AS is_email_verified_6,
  t1.is_phone_verified AS is_phone_verified_7,
  t1.email_verification_token AS email_verification_token_8,
  t1.phone_verification_token AS phone_verification_token_9,
  t1.status AS status_10,
  t1.pending_email AS pending_email_11,
  t1.pending_phone AS pending_phone_12,
  t1.reference AS reference_13,
  t1.created_at AS created_at_14,
  t1.last_name AS last_name_15,
  t1.first_name AS first_name_16,
  t1.phone AS phone_17,
  t0.name AS name_18,
  t0.profile_picture AS profile_picture_19,
  t0.description AS description_20,
  t0.slug AS slug_21,
  t0.is_visible AS is_visible_22,
  t1.discriminator_type
FROM
  agency t0
  INNER JOIN user t1 ON t0.id = t1.id
WHERE
  t1.reference = ?
LIMIT
  1

SELECT t1.id AS id_2, t1.email AS email_3, t1.roles AS roles_4, t1.password AS password_5, t1.is_email_verified AS is_email_verified_6, t1.is_phone_verified AS is_phone_verified_7, t1.email_verification_token AS email_verification_token_8, t1.phone_verification_token AS phone_verification_token_9, t1.status AS status_10, t1.pending_email AS pending_email_11, t1.pending_phone AS pending_phone_12, t1.reference AS reference_13, t1.created_at AS created_at_14, t1.last_name AS last_name_15, t1.first_name AS first_name_16, t1.phone AS phone_17, t0.name AS name_18, t0.profile_picture AS profile_picture_19, t0.description AS description_20, t0.slug AS slug_21, t0.is_visible AS is_visible_22, t1.discriminator_type FROM agency t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.reference = '696E5F4978691' LIMIT 1;

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.reference AS reference_4, t0.created_at AS created_at_5, t0.client_id AS client_id_6, t0.agency_id AS agency_id_7 FROM review t0 WHERE t0.agency_id = ? ORDER BY t0.created_at DESC

[
  "019bd724-3715-7380-812d-4036cbef3751"
]

SELECT
  t0.id AS id_1,
  t0.rating AS rating_2,
  t0.comment AS comment_3,
  t0.reference AS reference_4,
  t0.created_at AS created_at_5,
  t0.client_id AS client_id_6,
  t0.agency_id AS agency_id_7
FROM
  review t0
WHERE
  t0.agency_id = ?
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.rating AS rating_2, t0.comment AS comment_3, t0.reference AS reference_4, t0.created_at AS created_at_5, t0.client_id AS client_id_6, t0.agency_id AS agency_id_7 FROM review t0 WHERE t0.agency_id = '019bd724-3715-7380-812d-4036cbef3751' ORDER BY t0.created_at DESC;

SELECT t0.id AS id_1, t0.addresses AS addresses_2, t0.city_id AS city_id_3, t0.agency_id AS agency_id_4 FROM agency_address t0 WHERE t0.agency_id = ?

[
  "019bd724-3715-7380-812d-4036cbef3751"
]

SELECT
  t0.id AS id_1,
  t0.addresses AS addresses_2,
  t0.city_id AS city_id_3,
  t0.agency_id AS agency_id_4
FROM
  agency_address t0
WHERE
  t0.agency_id = ?

SELECT t0.id AS id_1, t0.addresses AS addresses_2, t0.city_id AS city_id_3, t0.agency_id AS agency_id_4 FROM agency_address t0 WHERE t0.agency_id = '019bd724-3715-7380-812d-4036cbef3751';