http://dev-hestefakta.tgn.no/tips/30120173

Query Metrics

5 Database Queries
5 Different statements
590.43 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
230.39 ms
(39.02%)
1
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:
[
  "30120173"
]
198.87 ms
(33.68%)
1
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-02 03:10:42"
  "V"
]
160.46 ms
(27.18%)
1
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-02 03:10:42"
]
0.38 ms
(0.06%)
1
SELECT t0.id AS id_1, t0.gam_gambling AS gam_gambling_2 FROM gambling t0 WHERE t0.id = ?
Parameters:
[
  "30120173"
]
0.33 ms
(0.06%)
1
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:
[
  "30120173"
]

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.