Symfony Profiler

• Request / Response
• API Platform
• Performance
• Validator
• Forms
• Exception
• Logs 15
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• VichUploader
• EasyAdmin
• Mercure
• Configuration

Query Metrics

SELECT count(*) AS sclr_0 FROM language l0_

[]

SELECT
  count(*) AS sclr_0
FROM
  language l0_

SELECT count(*) AS sclr_0 FROM language l0_;

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.flag AS flag_2, l0_.locale AS locale_3, l0_.is_active AS is_active_4, l0_.is_public AS is_public_5, l0_.teachers AS teachers_6 FROM language l0_ ORDER BY l0_.id ASC LIMIT 30

[]

SELECT
  l0_.id AS id_0,
  l0_.name AS name_1,
  l0_.flag AS flag_2,
  l0_.locale AS locale_3,
  l0_.is_active AS is_active_4,
  l0_.is_public AS is_public_5,
  l0_.teachers AS teachers_6
FROM
  language l0_
ORDER BY
  l0_.id ASC
LIMIT
  30

SELECT l0_.id AS id_0, l0_.name AS name_1, l0_.flag AS flag_2, l0_.locale AS locale_3, l0_.is_active AS is_active_4, l0_.is_public AS is_public_5, l0_.teachers AS teachers_6 FROM language l0_ ORDER BY l0_.id ASC LIMIT 30;

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?

[
  1
  1
  1
]

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  teacher t0_
  INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id
WHERE
  t1_.language_id = ?
  AND t0_.is_active = ?
  AND t0_.is_verified = ?

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = 1 AND t0_.is_active = 1 AND t0_.is_verified = 1;

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?

[
  2
  1
  1
]

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  teacher t0_
  INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id
WHERE
  t1_.language_id = ?
  AND t0_.is_active = ?
  AND t0_.is_verified = ?

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = 2 AND t0_.is_active = 1 AND t0_.is_verified = 1;

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?

[
  3
  1
  1
]

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  teacher t0_
  INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id
WHERE
  t1_.language_id = ?
  AND t0_.is_active = ?
  AND t0_.is_verified = ?

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = 3 AND t0_.is_active = 1 AND t0_.is_verified = 1;

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?

[
  4
  1
  1
]

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  teacher t0_
  INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id
WHERE
  t1_.language_id = ?
  AND t0_.is_active = ?
  AND t0_.is_verified = ?

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = 4 AND t0_.is_active = 1 AND t0_.is_verified = 1;

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?

[
  5
  1
  1
]

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  teacher t0_
  INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id
WHERE
  t1_.language_id = ?
  AND t0_.is_active = ?
  AND t0_.is_verified = ?

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = 5 AND t0_.is_active = 1 AND t0_.is_verified = 1;

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?

[
  6
  1
  1
]

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  teacher t0_
  INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id
WHERE
  t1_.language_id = ?
  AND t0_.is_active = ?
  AND t0_.is_verified = ?

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = 6 AND t0_.is_active = 1 AND t0_.is_verified = 1;

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = ? AND t0_.is_active = ? AND t0_.is_verified = ?

[
  8
  1
  1
]

SELECT
  COUNT(DISTINCT t0_.id) AS sclr_0
FROM
  teacher t0_
  INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id
WHERE
  t1_.language_id = ?
  AND t0_.is_active = ?
  AND t0_.is_verified = ?

SELECT COUNT(DISTINCT t0_.id) AS sclr_0 FROM teacher t0_ INNER JOIN teaching_language t1_ ON t0_.id = t1_.teacher_id WHERE t1_.language_id = 8 AND t0_.is_active = 1 AND t0_.is_verified = 1;