Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type, t1.first_name AS first_name_8, t1.last_name AS last_name_9 FROM `user` t0 LEFT JOIN admin t1 ON t0.id = t1.id WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.type,
  t1.first_name AS first_name_8,
  t1.last_name AS last_name_9
FROM
  `user` t0
  LEFT JOIN admin t1 ON t0.id = t1.id
WHERE
  t0.id = ?

SELECT t0.id AS id_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.type, t1.first_name AS first_name_8, t1.last_name AS last_name_9 FROM `user` t0 LEFT JOIN admin t1 ON t0.id = t1.id WHERE t0.id = 1;

SELECT i0_.id AS id_0, i0_.first_name AS first_name_1, i0_.last_name AS last_name_2, i0_.inmate_id AS inmate_id_3, i0_.email AS email_4, i0_.password AS password_5, i0_.roles AS roles_6, i0_.fingerprint_data AS fingerprint_data_7, i0_.created_at AS created_at_8, i0_.updated_at AS updated_at_9, w1_.id AS id_10, w1_.balance AS balance_11, w1_.daily_limit AS daily_limit_12, w1_.monthly_limit AS monthly_limit_13, w1_.status AS status_14, w1_.created_at AS created_at_15, w1_.updated_at AS updated_at_16, w1_.inmate_id AS inmate_id_17 FROM inmates i0_ LEFT JOIN wallets w1_ ON i0_.id = w1_.inmate_id ORDER BY i0_.created_at DESC LIMIT 10

[]

SELECT
  i0_.id AS id_0,
  i0_.first_name AS first_name_1,
  i0_.last_name AS last_name_2,
  i0_.inmate_id AS inmate_id_3,
  i0_.email AS email_4,
  i0_.password AS password_5,
  i0_.roles AS roles_6,
  i0_.fingerprint_data AS fingerprint_data_7,
  i0_.created_at AS created_at_8,
  i0_.updated_at AS updated_at_9,
  w1_.id AS id_10,
  w1_.balance AS balance_11,
  w1_.daily_limit AS daily_limit_12,
  w1_.monthly_limit AS monthly_limit_13,
  w1_.status AS status_14,
  w1_.created_at AS created_at_15,
  w1_.updated_at AS updated_at_16,
  w1_.inmate_id AS inmate_id_17
FROM
  inmates i0_
  LEFT JOIN wallets w1_ ON i0_.id = w1_.inmate_id
ORDER BY
  i0_.created_at DESC
LIMIT
  10

SELECT i0_.id AS id_0, i0_.first_name AS first_name_1, i0_.last_name AS last_name_2, i0_.inmate_id AS inmate_id_3, i0_.email AS email_4, i0_.password AS password_5, i0_.roles AS roles_6, i0_.fingerprint_data AS fingerprint_data_7, i0_.created_at AS created_at_8, i0_.updated_at AS updated_at_9, w1_.id AS id_10, w1_.balance AS balance_11, w1_.daily_limit AS daily_limit_12, w1_.monthly_limit AS monthly_limit_13, w1_.status AS status_14, w1_.created_at AS created_at_15, w1_.updated_at AS updated_at_16, w1_.inmate_id AS inmate_id_17 FROM inmates i0_ LEFT JOIN wallets w1_ ON i0_.id = w1_.inmate_id ORDER BY i0_.created_at DESC LIMIT 10;

SELECT COUNT(i0_.id) AS sclr_0 FROM inmates i0_ LEFT JOIN wallets w1_ ON i0_.id = w1_.inmate_id

[]

SELECT
  COUNT(i0_.id) AS sclr_0
FROM
  inmates i0_
  LEFT JOIN wallets w1_ ON i0_.id = w1_.inmate_id

SELECT COUNT(i0_.id) AS sclr_0 FROM inmates i0_ LEFT JOIN wallets w1_ ON i0_.id = w1_.inmate_id;