GET http://beta.easyscore.be/equipe/81-hvc-helchteren-a

Response
200 OK
IP
172.23.0.1
Profiled on
Token
9b588d

Query Metrics

8 Database Queries
8 Different statements
18.06 ms Query time
0 Invalid entities
53 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
3.87 ms
(21.41%) 		1 
SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.cancelled AS cancelled_3, g0_.forfeit AS forfeit_4, g0_.completed AS completed_5, g0_.phase_clubee_id AS phase_clubee_id_6, g0_.phase_name AS phase_name_7, g0_.updated_at AS updated_at_8, g0_.result_recorded_at AS result_recorded_at_9, g0_.detail_fetched_at AS detail_fetched_at_10, g0_.clubee_id AS clubee_id_11, g0_.starts_at AS starts_at_12, g0_.venue_name AS venue_name_13, g0_.venue_street AS venue_street_14, g0_.venue_city AS venue_city_15, g0_.venue_zip AS venue_zip_16, g0_.venue_country AS venue_country_17, g0_.venue_latitude AS venue_latitude_18, g0_.venue_longitude AS venue_longitude_19, t1_.id AS id_20, t1_.search_name AS search_name_21, t1_.subname AS subname_22, t1_.category AS category_23, t1_.gender AS gender_24, t1_.crest_url AS crest_url_25, t1_.name AS name_26, t1_.normalized_name AS normalized_name_27, t1_.clubee_id AS clubee_id_28, t2_.id AS id_29, t2_.search_name AS search_name_30, t2_.subname AS subname_31, t2_.category AS category_32, t2_.gender AS gender_33, t2_.crest_url AS crest_url_34, t2_.name AS name_35, t2_.normalized_name AS normalized_name_36, t2_.clubee_id AS clubee_id_37, c3_.id AS id_38, c3_.search_name AS search_name_39, c3_.gender AS gender_40, c3_.region AS region_41, c3_.category AS category_42, c3_.type AS type_43, c3_.active AS active_44, c3_.scanned_at AS scanned_at_45, c3_.name AS name_46, c3_.clubee_id AS clubee_id_47, g0_.home_team_id AS home_team_id_48, g0_.away_team_id AS away_team_id_49, g0_.competition_id AS competition_id_50, g0_.season_id AS season_id_51, t1_.club_id AS club_id_52, t2_.club_id AS club_id_53, c3_.season_id AS season_id_54 FROM "game" g0_ INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id WHERE (g0_.home_team_id = ? OR g0_.away_team_id = ?) AND g0_.starts_at >= ? AND g0_.cancelled = false ORDER BY g0_.starts_at ASC LIMIT 1
Parameters: 
[
  81
  81
  "2026-08-29 00:00:00"
]
View formatted query    View runnable query    Explain query    View query backtrace
3.61 ms
(19.97%) 		1 
SELECT c0_.id AS id_0, c0_.search_name AS search_name_1, c0_.gender AS gender_2, c0_.region AS region_3, c0_.category AS category_4, c0_.type AS type_5, c0_.active AS active_6, c0_.scanned_at AS scanned_at_7, c0_.name AS name_8, c0_.clubee_id AS clubee_id_9, COUNT(g1_.id) AS sclr_10, CASE WHEN c0_.season_id = ? THEN 0 ELSE 1 END AS sclr_11, c0_.season_id AS season_id_12 FROM "competition" c0_ INNER JOIN "game" g1_ ON c0_.id = g1_.competition_id WHERE g1_.home_team_id = ? OR g1_.away_team_id = ? GROUP BY c0_.id ORDER BY sclr_11 ASC, sclr_10 DESC LIMIT 1
Parameters: 
[
  1
  81
  81
]
View formatted query    View runnable query    Explain query    View query backtrace
2.66 ms
(14.74%) 		1 
SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.cancelled AS cancelled_3, g0_.forfeit AS forfeit_4, g0_.completed AS completed_5, g0_.phase_clubee_id AS phase_clubee_id_6, g0_.phase_name AS phase_name_7, g0_.updated_at AS updated_at_8, g0_.result_recorded_at AS result_recorded_at_9, g0_.detail_fetched_at AS detail_fetched_at_10, g0_.clubee_id AS clubee_id_11, g0_.starts_at AS starts_at_12, g0_.venue_name AS venue_name_13, g0_.venue_street AS venue_street_14, g0_.venue_city AS venue_city_15, g0_.venue_zip AS venue_zip_16, g0_.venue_country AS venue_country_17, g0_.venue_latitude AS venue_latitude_18, g0_.venue_longitude AS venue_longitude_19, t1_.id AS id_20, t1_.search_name AS search_name_21, t1_.subname AS subname_22, t1_.category AS category_23, t1_.gender AS gender_24, t1_.crest_url AS crest_url_25, t1_.name AS name_26, t1_.normalized_name AS normalized_name_27, t1_.clubee_id AS clubee_id_28, t2_.id AS id_29, t2_.search_name AS search_name_30, t2_.subname AS subname_31, t2_.category AS category_32, t2_.gender AS gender_33, t2_.crest_url AS crest_url_34, t2_.name AS name_35, t2_.normalized_name AS normalized_name_36, t2_.clubee_id AS clubee_id_37, c3_.id AS id_38, c3_.search_name AS search_name_39, c3_.gender AS gender_40, c3_.region AS region_41, c3_.category AS category_42, c3_.type AS type_43, c3_.active AS active_44, c3_.scanned_at AS scanned_at_45, c3_.name AS name_46, c3_.clubee_id AS clubee_id_47, g0_.home_team_id AS home_team_id_48, g0_.away_team_id AS away_team_id_49, g0_.competition_id AS competition_id_50, g0_.season_id AS season_id_51, t1_.club_id AS club_id_52, t2_.club_id AS club_id_53, c3_.season_id AS season_id_54 FROM "game" g0_ INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id WHERE g0_.home_team_id = ? OR g0_.away_team_id = ? ORDER BY g0_.starts_at ASC
Parameters: 
[
  81
  81
]
View formatted query    View runnable query    Explain query    View query backtrace
1.97 ms
(10.92%) 		1 
SELECT t0.id AS id_1, t0.search_name AS search_name_2, t0.subname AS subname_3, t0.category AS category_4, t0.gender AS gender_5, t0.crest_url AS crest_url_6, t0.name AS name_7, t0.normalized_name AS normalized_name_8, t0.clubee_id AS clubee_id_9, t0.club_id AS club_id_10 FROM "team" t0 WHERE t0.id = ?
Parameters: 
[
  81
]
View formatted query    View runnable query    Explain query    View query backtrace
1.81 ms
(10.02%) 		1 
SELECT r0_.id AS id_0, r0_.captured_at AS captured_at_1, r0_.hash AS hash_2, r0_.competition_id AS competition_id_3 FROM "ranking_snapshot" r0_ INNER JOIN "ranking_entry" r1_ ON r0_.id = r1_.snapshot_id INNER JOIN "competition" c2_ ON r0_.competition_id = c2_.id WHERE r1_.team_id = ? AND c2_.clubee_id = ? ORDER BY r0_.captured_at DESC LIMIT 1
Parameters: 
[
  81
  10768
]
View formatted query    View runnable query    Explain query    View query backtrace
1.80 ms
(9.94%) 		1 
SELECT t0.id AS id_1, t0.clubee_id AS clubee_id_2, t0.name AS name_3 FROM "season" t0 WHERE t0.name = ? LIMIT 1
Parameters: 
[
  "2026/2027"
]
View formatted query    View runnable query    Explain query    View query backtrace
1.74 ms
(9.61%) 		1 
SELECT g0_.id AS id_0, g0_.home_score AS home_score_1, g0_.away_score AS away_score_2, g0_.cancelled AS cancelled_3, g0_.forfeit AS forfeit_4, g0_.completed AS completed_5, g0_.phase_clubee_id AS phase_clubee_id_6, g0_.phase_name AS phase_name_7, g0_.updated_at AS updated_at_8, g0_.result_recorded_at AS result_recorded_at_9, g0_.detail_fetched_at AS detail_fetched_at_10, g0_.clubee_id AS clubee_id_11, g0_.starts_at AS starts_at_12, g0_.venue_name AS venue_name_13, g0_.venue_street AS venue_street_14, g0_.venue_city AS venue_city_15, g0_.venue_zip AS venue_zip_16, g0_.venue_country AS venue_country_17, g0_.venue_latitude AS venue_latitude_18, g0_.venue_longitude AS venue_longitude_19, t1_.id AS id_20, t1_.search_name AS search_name_21, t1_.subname AS subname_22, t1_.category AS category_23, t1_.gender AS gender_24, t1_.crest_url AS crest_url_25, t1_.name AS name_26, t1_.normalized_name AS normalized_name_27, t1_.clubee_id AS clubee_id_28, t2_.id AS id_29, t2_.search_name AS search_name_30, t2_.subname AS subname_31, t2_.category AS category_32, t2_.gender AS gender_33, t2_.crest_url AS crest_url_34, t2_.name AS name_35, t2_.normalized_name AS normalized_name_36, t2_.clubee_id AS clubee_id_37, c3_.id AS id_38, c3_.search_name AS search_name_39, c3_.gender AS gender_40, c3_.region AS region_41, c3_.category AS category_42, c3_.type AS type_43, c3_.active AS active_44, c3_.scanned_at AS scanned_at_45, c3_.name AS name_46, c3_.clubee_id AS clubee_id_47, g0_.home_team_id AS home_team_id_48, g0_.away_team_id AS away_team_id_49, g0_.competition_id AS competition_id_50, g0_.season_id AS season_id_51, t1_.club_id AS club_id_52, t2_.club_id AS club_id_53, c3_.season_id AS season_id_54 FROM "game" g0_ INNER JOIN "team" t1_ ON g0_.home_team_id = t1_.id INNER JOIN "team" t2_ ON g0_.away_team_id = t2_.id INNER JOIN "competition" c3_ ON g0_.competition_id = c3_.id WHERE (g0_.home_team_id = ? OR g0_.away_team_id = ?) AND g0_.home_score IS NOT NULL AND g0_.away_score IS NOT NULL ORDER BY g0_.starts_at DESC LIMIT 1
Parameters: 
[
  81
  81
]
View formatted query    View runnable query    Explain query    View query backtrace
0.61 ms
(3.39%) 		1 
SELECT t0.id AS id_1, t0.won AS won_2, t0.lost AS lost_3, t0.sets_won AS sets_won_4, t0.sets_lost AS sets_lost_5, t0.points_for AS points_for_6, t0.points_against AS points_against_7, t0.position AS position_8, t0.played AS played_9, t0.points AS points_10, t0.snapshot_id AS snapshot_id_11, t0.team_id AS team_id_12 FROM "ranking_entry" t0 WHERE t0.snapshot_id = ? ORDER BY t0.position ASC
Parameters: 
[
  93
]
View formatted query    View runnable query    Explain query    View query backtrace

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Game 23
App\Entity\Team 12
App\Entity\RankingEntry 12
App\Entity\Competition 2
App\Entity\Club 2
App\Entity\Season 1
App\Entity\RankingSnapshot 1

Entities Mapping

Class Mapping errors
App\Entity\Team No errors.
App\Entity\Address No errors.
App\Entity\Club No errors.
App\Entity\Season No errors.
App\Entity\Competition No errors.
App\Entity\Game No errors.
App\Entity\GameSet No errors.
App\Entity\Referee No errors.
App\Entity\RankingSnapshot No errors.
App\Entity\RankingEntry No errors.