POST https://sara.education/api/course-music/disabled-list

Query Metrics

5 Database Queries
5 Different statements
2.77 ms Query time
0 Invalid entities
5 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.82 ms
(65.78%)
1
SELECT c0_.id AS id_0, c0_.suno_task_id AS suno_task_id_1, c0_.suno_clip_id AS suno_clip_id_2, c0_.audio_url AS audio_url_3, c0_.video_url AS video_url_4, c0_.cover_url AS cover_url_5, c0_.prompt AS prompt_6, c0_.title AS title_7, c0_.style AS style_8, c0_.relevance AS relevance_9, c0_.active AS active_10, c0_.duration AS duration_11, c0_.created_at AS created_at_12, c0_.subchapter_id AS subchapter_id_13 FROM course_music c0_ INNER JOIN subchapter s1_ ON c0_.subchapter_id = s1_.id INNER JOIN chapter c2_ ON s1_.chapter_id = c2_.id INNER JOIN subject s3_ ON c2_.subject_id = s3_.id INNER JOIN classroom c4_ ON s3_.classroom_id = c4_.id WHERE c0_.prompt IS NOT NULL AND c0_.prompt <> '' AND c0_.active = ? ORDER BY c0_.id ASC LIMIT 1
Parameters:
[
  "disabled"
]
0.26 ms
(9.46%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.slug AS slug_4, t0.cycle AS cycle_5 FROM classroom t0 WHERE t0.id = ?
Parameters:
[
  6
]
0.25 ms
(9.13%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.priority AS priority_3, t0.slug AS slug_4, t0.href AS href_5, t0.type AS type_6, t0.course AS course_7, t0.mindmap AS mindmap_8, t0.chapter_id AS chapter_id_9 FROM subchapter t0 WHERE t0.id = ?
Parameters:
[
  1329
]
0.23 ms
(8.41%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.priority AS priority_3, t0.slug AS slug_4, t0.course AS course_5, t0.mindmap AS mindmap_6, t0.subject_id AS subject_id_7 FROM chapter t0 WHERE t0.id = ?
Parameters:
[
  129
]
0.20 ms
(7.22%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.priority AS priority_3, t0.slug AS slug_4, t0.classroom_id AS classroom_id_5 FROM subject t0 WHERE t0.id = ?
Parameters:
[
  26
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\CourseMusic 1
App\Entity\Subchapter 1
App\Entity\Chapter 1
App\Entity\Subject 1
App\Entity\Classroom 1

Entities Mapping

Class Mapping errors
App\Entity\CourseMusic No errors.
App\Entity\Subchapter No errors.
App\Entity\Chapter No errors.
App\Entity\Subject No errors.
App\Entity\Classroom No errors.
App\Entity\Module No errors.