Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 34
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Emails
• Configuration

Query Metrics

SELECT a0_.id AS id_0, a0_.dirname AS dirname_1, COUNT(a1_.id) AS sclr_2 FROM application a0_ LEFT JOIN app_exercise a1_ ON a0_.id = a1_.application_id WHERE a0_.active = ? AND a1_.active = ? GROUP BY a0_.dirname

[
  1
  1
]

SELECT
  a0_.id AS id_0,
  a0_.dirname AS dirname_1,
  COUNT(a1_.id) AS sclr_2
FROM
  application a0_
  LEFT JOIN app_exercise a1_ ON a0_.id = a1_.application_id
WHERE
  a0_.active = ?
  AND a1_.active = ?
GROUP BY
  a0_.dirname

SELECT a0_.id AS id_0, a0_.dirname AS dirname_1, COUNT(a1_.id) AS sclr_2 FROM application a0_ LEFT JOIN app_exercise a1_ ON a0_.id = a1_.application_id WHERE a0_.active = 1 AND a1_.active = 1 GROUP BY a0_.dirname;

SELECT a0_.dirname AS dirname_0, a0_.is_mobile AS is_mobile_1, a0_.testable AS testable_2, a0_.has_info AS has_info_3, a0_.has_index AS has_index_4, a0_.id AS id_5, a0_.name AS name_6, a0_.information AS information_7, a0_.dirname AS dirname_8, a0_.is_application AS is_application_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.active AS active_12, a0_.exportdata AS exportdata_13, r1_.id AS id_14, r1_.language AS language_15, r1_.amount AS amount_16, r1_.created_at AS created_at_17, r1_.updated_at AS updated_at_18, r1_.active AS active_19, r1_.exportdata AS exportdata_20 FROM application a0_ LEFT JOIN rating r1_ ON a0_.id = r1_.application_id AND (r1_.app_exercise_id IS NULL) WHERE a0_.is_application = ? AND a0_.active = ? AND r1_.app_exercise_id IS NULL GROUP BY is_mobile_1, testable_2, has_info_3, has_index_4, id_5, name_6, information_7, dirname_8, is_application_9, created_at_10, updated_at_11, active_12, exportdata_13, a0_.id, r1_.id, r1_.language, r1_.amount, r1_.created_at, r1_.updated_at, r1_.active, r1_.exportdata, r1_.app_exercise_id, r1_.application_id, r1_.user_id ORDER BY a0_.id ASC LIMIT 25

[
  1
  1
]

SELECT
  a0_.dirname AS dirname_0,
  a0_.is_mobile AS is_mobile_1,
  a0_.testable AS testable_2,
  a0_.has_info AS has_info_3,
  a0_.has_index AS has_index_4,
  a0_.id AS id_5,
  a0_.name AS name_6,
  a0_.information AS information_7,
  a0_.dirname AS dirname_8,
  a0_.is_application AS is_application_9,
  a0_.created_at AS created_at_10,
  a0_.updated_at AS updated_at_11,
  a0_.active AS active_12,
  a0_.exportdata AS exportdata_13,
  r1_.id AS id_14,
  r1_.language AS language_15,
  r1_.amount AS amount_16,
  r1_.created_at AS created_at_17,
  r1_.updated_at AS updated_at_18,
  r1_.active AS active_19,
  r1_.exportdata AS exportdata_20
FROM
  application a0_
  LEFT JOIN rating r1_ ON a0_.id = r1_.application_id
  AND (r1_.app_exercise_id IS NULL)
WHERE
  a0_.is_application = ?
  AND a0_.active = ?
  AND r1_.app_exercise_id IS NULL
GROUP BY
  is_mobile_1,
  testable_2,
  has_info_3,
  has_index_4,
  id_5,
  name_6,
  information_7,
  dirname_8,
  is_application_9,
  created_at_10,
  updated_at_11,
  active_12,
  exportdata_13,
  a0_.id,
  r1_.id,
  r1_.language,
  r1_.amount,
  r1_.created_at,
  r1_.updated_at,
  r1_.active,
  r1_.exportdata,
  r1_.app_exercise_id,
  r1_.application_id,
  r1_.user_id
ORDER BY
  a0_.id ASC
LIMIT
  25

SELECT a0_.dirname AS dirname_0, a0_.is_mobile AS is_mobile_1, a0_.testable AS testable_2, a0_.has_info AS has_info_3, a0_.has_index AS has_index_4, a0_.id AS id_5, a0_.name AS name_6, a0_.information AS information_7, a0_.dirname AS dirname_8, a0_.is_application AS is_application_9, a0_.created_at AS created_at_10, a0_.updated_at AS updated_at_11, a0_.active AS active_12, a0_.exportdata AS exportdata_13, r1_.id AS id_14, r1_.language AS language_15, r1_.amount AS amount_16, r1_.created_at AS created_at_17, r1_.updated_at AS updated_at_18, r1_.active AS active_19, r1_.exportdata AS exportdata_20 FROM application a0_ LEFT JOIN rating r1_ ON a0_.id = r1_.application_id AND (r1_.app_exercise_id IS NULL) WHERE a0_.is_application = 1 AND a0_.active = 1 AND r1_.app_exercise_id IS NULL GROUP BY is_mobile_1, testable_2, has_info_3, has_index_4, id_5, name_6, information_7, dirname_8, is_application_9, created_at_10, updated_at_11, active_12, exportdata_13, a0_.id, r1_.id, r1_.language, r1_.amount, r1_.created_at, r1_.updated_at, r1_.active, r1_.exportdata, r1_.app_exercise_id, r1_.application_id, r1_.user_id ORDER BY a0_.id ASC LIMIT 25;

SELECT t0.id AS id_1, t0.email AS email_2, t0.fullname AS fullname_3, t0.azure_id AS azure_id_4, t0.azure_refresh_token AS azure_refresh_token_5, t0.roles AS roles_6, t0.used AS used_7, t0.last_used AS last_used_8, t0.password AS password_9, t0.progress AS progress_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.active AS active_13, t0.exportdata AS exportdata_14, t0.user_id AS user_id_15 FROM user t0 WHERE t0.id = ?

[
  2015
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.fullname AS fullname_3,
  t0.azure_id AS azure_id_4,
  t0.azure_refresh_token AS azure_refresh_token_5,
  t0.roles AS roles_6,
  t0.used AS used_7,
  t0.last_used AS last_used_8,
  t0.password AS password_9,
  t0.progress AS progress_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.active AS active_13,
  t0.exportdata AS exportdata_14,
  t0.user_id AS user_id_15
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.fullname AS fullname_3, t0.azure_id AS azure_id_4, t0.azure_refresh_token AS azure_refresh_token_5, t0.roles AS roles_6, t0.used AS used_7, t0.last_used AS last_used_8, t0.password AS password_9, t0.progress AS progress_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.active AS active_13, t0.exportdata AS exportdata_14, t0.user_id AS user_id_15 FROM user t0 WHERE t0.id = 2015;

SELECT COUNT(*) FROM application t0 WHERE t0.active = ?

[
  1
]

SELECT
  COUNT(*)
FROM
  application t0
WHERE
  t0.active = ?

SELECT COUNT(*) FROM application t0 WHERE t0.active = 1;