GET https://chezamusicschool.co.ke/level/show/Piano/Broken%20Chords/Dflat

Query Metrics

10 Database Queries
7 Different statements
12.16 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.mode_id AS mode_id_3 FROM my_key t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Dflat"
]
2 3.00 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.availability AS availability_3, t0.category AS category_4, t0.description AS description_5, t0.image AS image_6, t0.book_online AS book_online_7 FROM instrument t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Piano"
]
3 1.79 ms
SELECT t0.id AS id_1, t0.type AS type_2, t0.instrument_id AS instrument_id_3 FROM exercise t0 WHERE t0.type = ? LIMIT 1
Parameters:
[
  "Broken Chords"
]
4 0.58 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM level t0
Parameters:
[]
5 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "level/index.html.twig"
]
6 0.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "level/index.html.twig"
]
7 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "base_flash.html.twig"
]
8 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.typography AS typography_3, t0.position AS position_4, t0.visible AS visible_5, t0.last_updated AS last_updated_6, t0.page_id AS page_id_7 FROM section t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "base_flash.html.twig"
]
9 0.79 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM mode t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 3.13 ms
SELECT t0.id AS id_1, t0.image AS image_2, t0.description AS description_3, t0.exercise_id AS exercise_id_4, t0.mykey_id AS mykey_id_5, t0.mode_id AS mode_id_6, t0.level_id AS level_id_7 FROM flash_card t0 WHERE t0.exercise_id = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\MyKey No errors.
App\Entity\Mode No errors.
App\Entity\FlashCard No errors.
App\Entity\Instrument No errors.
App\Entity\UserInstrumentGrade No errors.
App\Entity\Exercise No errors.
App\Entity\Course No errors.
App\Entity\Booking No errors.
App\Entity\Learner No errors.
App\Entity\Level No errors.
App\Entity\Section No errors.
App\Entity\Page No errors.