Query Metrics
2
Database Queries
2
Different statements
6.78 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.45 ms (50.83%) |
1 |
SELECT g0_.id AS id_0, g0_.start_at AS start_at_1, g0_.end_at AS end_at_2, g0_.pause_at AS pause_at_3, g0_.duration AS duration_4, g0_.created_at AS created_at_5, g0_.school_class_id AS school_class_id_6 FROM game_timer g0_ LEFT JOIN school_class s1_ ON g0_.school_class_id = s1_.id LEFT JOIN school s2_ ON s1_.school_id = s2_.id WHERE s2_.id = ? AND g0_.start_at <= ? AND ? <= g0_.end_at ORDER BY g0_.created_at DESC
Parameters:
[ 167 "2024-11-18 19:37:22" "2024-11-18 19:37:22" ] |
3.33 ms (49.17%) |
1 |
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.school_id AS school_id_19, t9.communication_id AS communication_id_20, t9.gallery_id AS gallery_id_21, t9.video_gallery_id AS video_gallery_id_22, t9.document_gallery_id AS document_gallery_id_23, t9.contact_gallery_id AS contact_gallery_id_24, t9.profile_picture_id AS profile_picture_id_25, t9.header_picture_id AS header_picture_id_26, t9.profile_link_id AS profile_link_id_27 FROM school t0 LEFT JOIN school_profile t9 ON t9.school_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
167
]
|
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\School | 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. |
App\Entity\GameTimer | No errors. |