Query Metrics
5
Database Queries
5
Different statements
445.58 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 163.34 ms |
SELECT r0_.id AS id_0, r0_.rac_raceno AS rac_raceno_1, m1_.mee_date AS mee_date_2, m1_.mee_legtypes AS mee_legtypes_3, m1_.mee_sport AS mee_sport_4, t2_.trk_shortname AS trk_shortname_5, t2_.trk_length AS trk_length_6, t2_.trk_extra AS trk_extra_7, t2_.trk_lenght_2 AS trk_lenght_2_8, t2_.trk_extra_2 AS trk_extra_2_9, t2_.trk_info_1 AS trk_info_1_10, t2_.trk_info_2 AS trk_info_2_11, t2_.trk_sc AS trk_sc_12, t2_.trk_code AS trk_code_13 FROM races r0_ LEFT JOIN meetings m1_ ON r0_.rac_mee_id = m1_.id LEFT JOIN tracks t2_ ON m1_.mee_tra_id = t2_.id WHERE r0_.rac_mee_id = ? ORDER BY r0_.rac_raceno ASC
Parameters:
[
"30120121"
]
|
2 | 141.67 ms |
SELECT r0_.id AS id_0, r0_.rac_racetype_code AS rac_racetype_code_1, r0_.rac_name AS rac_name_2, r0_.rac_raceno AS rac_raceno_3, r0_.rac_mee_id AS rac_mee_id_4, m1_.mee_date AS mee_date_5, t2_.trk_trackname AS trk_trackname_6, t2_.trk_shortname AS trk_shortname_7, t2_.id AS id_8, r0_.rac_starttime AS rac_starttime_9, r0_.rac_basedist AS rac_basedist_10, m1_.mee_firstracestart AS mee_firstracestart_11 FROM races r0_ LEFT JOIN meetings m1_ ON r0_.rac_mee_id = m1_.id LEFT JOIN tracks t2_ ON m1_.mee_tra_id = t2_.id WHERE m1_.mee_date > ? AND r0_.rac_racetype_code = ? GROUP BY m1_.mee_date, t2_.trk_trackname ORDER BY m1_.mee_date ASC, t2_.trk_trackname ASC, r0_.rac_raceno ASC
Parameters:
[ "2025-08-01 20:40:59" "V" ] |
3 | 0.45 ms |
SELECT c0_.id AS id_0, c0_.cht_text AS cht_text_1, c0_.cht_image AS cht_image_2, c0_.cht_ready AS cht_ready_3, c0_.cht_image_caption AS cht_image_caption_4 FROM chilitexts c0_ WHERE c0_.id = ?
Parameters:
[
"30120121"
]
|
4 | 139.63 ms |
SELECT r0_.id AS id_0, l1_.leg_code AS leg_code_1, m2_.id AS id_2 FROM races r0_ LEFT JOIN meetings m2_ ON r0_.rac_mee_id = m2_.id LEFT JOIN legtypes l1_ ON r0_.id = l1_.leg_rac_id LEFT JOIN legtypecodes l3_ ON l1_.leg_code = l3_.id WHERE m2_.mee_date > ? AND l3_.lec_show = 1 GROUP BY m2_.id, l1_.leg_code ORDER BY m2_.mee_date ASC, r0_.rac_raceno ASC
Parameters:
[
"2025-08-01 20:40:59"
]
|
5 | 0.49 ms |
SELECT t0.id AS id_1, t0.gam_gambling AS gam_gambling_2 FROM gambling t0 WHERE t0.id = ?
Parameters:
[
"30120121"
]
|
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\Races | No errors. |
App\Entity\Meetings | No errors. |
App\Entity\Tracks | No errors. |
App\Entity\Chilitexts | No errors. |
App\Entity\Legtypes | No errors. |
App\Entity\Legtypecodes | No errors. |
App\Entity\Gambling | No errors. |
App\Entity\Starts | No errors. |
App\Entity\Results | No errors. |
App\Entity\Interviews | No errors. |
App\Entity\Trackconditions | No errors. |