Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine
• E-mails
• Serializer
• EasyAdmin
• Configuration

Query Metrics

SELECT COUNT(*) FROM `character` t0 WHERE t0.course_id = ?

  0 of 0       
[▼
  "20"
]

SELECT
  COUNT(*)
FROM
  `character` t0
WHERE
  t0.course_id = ?

SELECT COUNT(*) FROM `character` t0 WHERE t0.course_id = '20';

SELECT t0.course_id AS course_id_1, t0.title AS title_2 FROM course t0 WHERE t0.course_id = ?

  0 of 0       
[▼
  "20"
]

SELECT
  t0.course_id AS course_id_1,
  t0.title AS title_2
FROM
  course t0
WHERE
  t0.course_id = ?

SELECT t0.course_id AS course_id_1, t0.title AS title_2 FROM course t0 WHERE t0.course_id = '20';

SELECT t0.shortcut_path AS shortcut_path_1, t0.id AS id_2, t0.pinyin AS pinyin_3, t0.`character` AS character_4, t0.fz_radical_value AS fz_radical_value_5, t0.place_in_course AS place_in_course_6, t0.hypa AS hypa_7, t0.course_id AS course_id_8, t0.rcc AS rcc_9, t0.origin AS origin_10 FROM `character` t0 WHERE t0.course_id = ? ORDER BY t0.place_in_course ASC LIMIT 10 OFFSET 20

  0 of 0       
[▼
  "20"
]

SELECT
  t0.shortcut_path AS shortcut_path_1,
  t0.id AS id_2,
  t0.pinyin AS pinyin_3,
  t0.`character` AS character_4,
  t0.fz_radical_value AS fz_radical_value_5,
  t0.place_in_course AS place_in_course_6,
  t0.hypa AS hypa_7,
  t0.course_id AS course_id_8,
  t0.rcc AS rcc_9,
  t0.origin AS origin_10
FROM
  `character` t0
WHERE
  t0.course_id = ?
ORDER BY
  t0.place_in_course ASC
LIMIT
  10 OFFSET 20

SELECT t0.shortcut_path AS shortcut_path_1, t0.id AS id_2, t0.pinyin AS pinyin_3, t0.`character` AS character_4, t0.fz_radical_value AS fz_radical_value_5, t0.place_in_course AS place_in_course_6, t0.hypa AS hypa_7, t0.course_id AS course_id_8, t0.rcc AS rcc_9, t0.origin AS origin_10 FROM `character` t0 WHERE t0.course_id = '20' ORDER BY t0.place_in_course ASC LIMIT 10 OFFSET 20;