Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs
• Events
• Routing
• Cache
• Security
• Twig
• HTTP Client
• Doctrine 4
• Emails
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.is_verified AS is_verified_8, t0.is_active AS is_active_9, t0.phone_number AS phone_number_10, t0.dialing_code AS dialing_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.siret AS siret_16, t0.company_name AS company_name_17, t0.addresses AS addresses_18, t0.avatar_path AS avatar_path_19, t0.type FROM jb_user t0 WHERE t0.email = ? AND t0.type IN ('user', 'customer', 'repairer', 'manager', 'fleet') LIMIT 1

[
  "jb@manager.local"
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.email AS email_7,
  t0.is_verified AS is_verified_8,
  t0.is_active AS is_active_9,
  t0.phone_number AS phone_number_10,
  t0.dialing_code AS dialing_code_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.created_by AS created_by_14,
  t0.updated_by AS updated_by_15,
  t0.siret AS siret_16,
  t0.company_name AS company_name_17,
  t0.addresses AS addresses_18,
  t0.avatar_path AS avatar_path_19,
  t0.type
FROM
  jb_user t0
WHERE
  t0.email = ?
  AND t0.type IN (
    'user', 'customer', 'repairer', 'manager',
    'fleet'
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.password AS password_3, t0.roles AS roles_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.is_verified AS is_verified_8, t0.is_active AS is_active_9, t0.phone_number AS phone_number_10, t0.dialing_code AS dialing_code_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15, t0.siret AS siret_16, t0.company_name AS company_name_17, t0.addresses AS addresses_18, t0.avatar_path AS avatar_path_19, t0.type FROM jb_user t0 WHERE t0.email = 'jb@manager.local' AND t0.type IN ('user', 'customer', 'repairer', 'manager', 'fleet') LIMIT 1;

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.activity AS activity_2, w0_.contact AS contact_3, w0_.status AS status_4, w0_.location AS location_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7, w0_.city AS city_8, w0_.country AS country_9, (CASE WHEN w0_.updated_at IS NULL THEN w0_.created_at ELSE w0_.updated_at END) AS sclr_10 FROM workshop w0_ ORDER BY sclr_10 DESC, w0_.created_at DESC

[]

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.activity AS activity_2,
  w0_.contact AS contact_3,
  w0_.status AS status_4,
  w0_.location AS location_5,
  w0_.created_at AS created_at_6,
  w0_.updated_at AS updated_at_7,
  w0_.city AS city_8,
  w0_.country AS country_9,
  (
    CASE WHEN w0_.updated_at IS NULL THEN
      w0_.created_at
    ELSE
      w0_.updated_at
    END
  ) AS sclr_10
FROM
  workshop w0_
ORDER BY
  sclr_10 DESC,
  w0_.created_at DESC

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.activity AS activity_2, w0_.contact AS contact_3, w0_.status AS status_4, w0_.location AS location_5, w0_.created_at AS created_at_6, w0_.updated_at AS updated_at_7, w0_.city AS city_8, w0_.country AS country_9, (CASE WHEN w0_.updated_at IS NULL THEN w0_.created_at ELSE w0_.updated_at END) AS sclr_10 FROM workshop w0_ ORDER BY sclr_10 DESC, w0_.created_at DESC;