Query Metrics
13
Database Queries
4
Different statements
8.60 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.93 ms (57.30%) |
8 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.school_number AS school_number_3, t0.url AS url_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.communication_id AS communication_id_7, t0.address_id AS address_id_8, t9.id AS id_10, t9.uuid AS uuid_11, t9.name AS name_12, t9.description AS description_13, t9.training_information AS training_information_14, t9.certificate_information AS certificate_information_15, t9.url AS url_16, t9.click_count AS click_count_17, t9.is_visible AS is_visible_18, t9.logo_style AS logo_style_19, t9.school_id AS school_id_20, t9.communication_id AS communication_id_21, t9.gallery_id AS gallery_id_22, t9.video_gallery_id AS video_gallery_id_23, t9.document_gallery_id AS document_gallery_id_24, t9.contact_gallery_id AS contact_gallery_id_25, t9.profile_picture_id AS profile_picture_id_26, t9.header_picture_id AS header_picture_id_27, t9.profile_link_id AS profile_link_id_28 FROM school t0 LEFT JOIN school_profile t9 ON t9.school_id = t0.id WHERE t0.id = ?
Parameters:
[
370
]
|
|
1.71 ms (19.94%) |
3 |
SELECT t0.id AS id_1, t0.optional_name AS optional_name_2, t0.director_mail AS director_mail_3, t0.is_visible AS is_visible_4, t0.rookie_district_id AS rookie_district_id_5, t0.school_id AS school_id_6, t0.rookie_time_slot_id AS rookie_time_slot_id_7 FROM rookie_school t0 WHERE t0.rookie_time_slot_id = ?
Parameters:
[
7
]
|
|
1.28 ms (14.88%) |
1 |
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.open_at AS open_at_2, r0_.close_at AS close_at_3, r0_.work_from AS work_from_4, r0_.work_to AS work_to_5, r0_.comment AS comment_6, r0_.rookie_district_id AS rookie_district_id_7, r0_.rookie_time_slot_state_id AS rookie_time_slot_state_id_8 FROM rookie_time_slot r0_ LEFT JOIN rookie_district r1_ ON r0_.rookie_district_id = r1_.id LEFT JOIN rookie_time_slot_state r2_ ON r0_.rookie_time_slot_state_id = r2_.id WHERE r1_.id = 1 AND r0_.id NOT IN (9, 60) AND r2_.id = 1 ORDER BY r0_.open_at ASC
Parameters:
[] |
|
0.68 ms (7.88%) |
1 |
SELECT t0.id AS id_1, t0.district_name AS district_name_2, t0.event_type AS event_type_3, t0.event_state AS event_state_4 FROM rookie_district t0 WHERE t0.id = ? LIMIT 1
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\RookieDistrict | No errors. |
| App\Entity\RookieTimeSlot | No errors. |
| App\Entity\RookieTimeSlotState | No errors. |
| App\Entity\RookieSchool | No errors. |
| App\Entity\School | No errors. |
| App\Entity\RookieSchoolClass | No errors. |
| App\Entity\Communication | No errors. |
| App\Entity\Address | No errors. |
| App\Entity\SchoolProfile | No errors. |
| App\Entity\Gallery | No errors. |
| App\Entity\ContactGallery | No errors. |
| App\Entity\Media | No errors. |
| App\Entity\ProfileLink | No errors. |
| App\Entity\SchoolClass | No errors. |
| App\Entity\SchoolDirectorMapping | No errors. |
| App\Entity\SchoolTeacherMapping | No errors. |
| App\Entity\JobSchool | No errors. |
| App\Entity\InterestField | No errors. |
| App\Entity\SchoolType | No errors. |
| App\Entity\SchoolAward | No errors. |