Query Metrics
7
Database Queries
5
Different statements
2.20 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.52 ms |
SELECT t0.id AS id_1, t0.district_name AS district_name_2 FROM rookie_day_district t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
1
]
|
| 2 | 0.34 ms |
SELECT t0.id AS id_1, t0.register_scholar_start_at AS register_scholar_start_at_2, t0.register_scholar_end_at AS register_scholar_end_at_3, t0.register_company_start_at AS register_company_start_at_4, t0.register_company_end_at AS register_company_end_at_5, t0.created_at AS created_at_6, t0.rookie_day_district_id AS rookie_day_district_id_7 FROM rookie_day_setup t0 WHERE t0.rookie_day_district_id = ? LIMIT 1
Parameters:
[
1
]
|
| 3 | 0.29 ms |
SELECT t0.id AS id_1, t0.event_at AS event_at_2, t0.created_at AS created_at_3, t0.rookie_day_setup_id AS rookie_day_setup_id_4 FROM rookie_day_date t0 WHERE t0.rookie_day_setup_id = ?
Parameters:
[
1
]
|
| 4 | 0.44 ms |
SELECT r0_.id AS id_0, r0_.created_at AS created_at_1, r0_.rookie_day_school_id AS rookie_day_school_id_2, r0_.rookie_day_date_id AS rookie_day_date_id_3 FROM rookie_day_school_date_mapping r0_ LEFT JOIN rookie_day_school r1_ ON r0_.rookie_day_school_id = r1_.id WHERE r0_.rookie_day_date_id = ? ORDER BY r1_.school_name ASC
Parameters:
[
1
]
|
| 5 | 0.23 ms |
SELECT t0.id AS id_1, t0.school_name AS school_name_2, t0.created_at AS created_at_3, t0.rookie_day_district_id AS rookie_day_district_id_4 FROM rookie_day_school t0 WHERE t0.id = ?
Parameters:
[
10
]
|
| 6 | 0.20 ms |
SELECT t0.id AS id_1, t0.school_name AS school_name_2, t0.created_at AS created_at_3, t0.rookie_day_district_id AS rookie_day_district_id_4 FROM rookie_day_school t0 WHERE t0.id = ?
Parameters:
[
11
]
|
| 7 | 0.19 ms |
SELECT t0.id AS id_1, t0.school_name AS school_name_2, t0.created_at AS created_at_3, t0.rookie_day_district_id AS rookie_day_district_id_4 FROM rookie_day_school t0 WHERE t0.id = ?
Parameters:
[
14
]
|
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\RookieDayDistrict | No errors. |
| App\Entity\RookieDaySetup | No errors. |
| App\Entity\RookieDayDate | No errors. |
| App\Entity\RookieDaySchoolDateMapping | No errors. |
| App\Entity\RookieDaySchool | No errors. |