https://africatkdreferee.com/

Query Metrics

5 Database Queries
4 Different statements
3.88 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.33 ms
(34.25%)
1
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.hall AS hall_2, c0_.date AS date_3, c0_.checkin AS checkin_4, c0_.checkout AS checkout_5, c0_.deadline AS deadline_6, c0_.timezone AS timezone_7, c0_.brochure_file AS brochure_file_8, c0_.dateend AS dateend_9, c0_.city_id AS city_id_10 FROM competition c0_ WHERE c0_.date >= ? ORDER BY c0_.date DESC LIMIT 10
Parameters:
[
  "2026-02-24 15:54:36"
]
0.98 ms
(25.21%)
2
SELECT t0.id AS id_1, t0.date_add AS date_add_2, t0.date_up AS date_up_3, t0.active AS active_4, t0.referee_id AS referee_id_5, t0.competition_id AS competition_id_6 FROM attribution t0 WHERE t0.competition_id = ?
Parameters:
[
  35
]
0.98 ms
(25.13%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.cca2 AS cca2_3, t0.cca3 AS cca3_4, t0.ccn3 AS ccn3_5, t0.sub_continent AS sub_continent_6, t0.continent_id AS continent_id_7 FROM country t0 WHERE t0.id = ?
Parameters:
[
  134
]
0.60 ms
(15.41%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3, t0.zone AS zone_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.country_id AS country_id_7 FROM city t0 WHERE t0.id = ?
Parameters:
[
  5968
]

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\Competition No errors.
App\Entity\City No errors.
App\Entity\Attribution No errors.
App\Entity\Country No errors.
App\Entity\Continent No errors.
App\Entity\Referee No errors.