Query Metrics

362 Database Queries
9 Different statements
189.31 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
64.16 ms
(33.89%)
140
SELECT t0.id AS id_1, t0.voornaam AS voornaam_2, t0.tussenvoegsels AS tussenvoegsels_3, t0.achternaam AS achternaam_4, t0.telefoonnr AS telefoonnr_5, t0.email AS email_6 FROM spelers t0 WHERE t0.id = ?
Parameters:
[
  3
]
36.23 ms
(19.14%)
70
SELECT t0.id AS id_1, t0.team1_games AS team1_games_2, t0.team2_games AS team2_games_3, t0.team1_rating AS team1_rating_4, t0.team2_rating AS team2_rating_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.team1_pos AS team1_pos_8, t0.team2_pos AS team2_pos_9, t0.token AS token_10, t0.seizoendivisie_id AS seizoendivisie_id_11, t0.seizoenronde_id AS seizoenronde_id_12, t0.seizoenteam1_id AS seizoenteam1_id_13, t0.seizoenteam2_id AS seizoenteam2_id_14 FROM seizoenwedstrijden t0 WHERE t0.seizoenteam1_id = ?
Parameters:
[
  6
]
36.20 ms
(19.12%)
70
SELECT t0.id AS id_1, t0.team1_games AS team1_games_2, t0.team2_games AS team2_games_3, t0.team1_rating AS team1_rating_4, t0.team2_rating AS team2_rating_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.team1_pos AS team1_pos_8, t0.team2_pos AS team2_pos_9, t0.token AS token_10, t0.seizoendivisie_id AS seizoendivisie_id_11, t0.seizoenronde_id AS seizoenronde_id_12, t0.seizoenteam1_id AS seizoenteam1_id_13, t0.seizoenteam2_id AS seizoenteam2_id_14 FROM seizoenwedstrijden t0 WHERE t0.seizoenteam2_id = ?
Parameters:
[
  6
]
36.05 ms
(19.04%)
70
SELECT t0.id AS id_1, t0.ind_aanvoerder AS ind_aanvoerder_2, t0.seizoenteam_id AS seizoenteam_id_3, t0.speler_id AS speler_id_4 FROM seizoenteamspelers t0 WHERE t0.seizoenteam_id = ?
Parameters:
[
  6
]
6.56 ms
(3.47%)
5
SELECT s0_.id AS id_0, s0_.positie AS positie_1, s0_.ind_betaald AS ind_betaald_2, s0_.rating AS rating_3, s0_.inrondenr AS inrondenr_4, s0_.doelsaldo AS doelsaldo_5, s0_.nwrating AS nwrating_6, s0_.rondenr_verwerkt AS rondenr_verwerkt_7, s0_.nwpositie AS nwpositie_8, s0_.seizoen_id AS seizoen_id_9, s0_.seizoendivisie_id AS seizoendivisie_id_10 FROM seizoenteams s0_ WHERE s0_.seizoendivisie_id = ? ORDER BY s0_.positie ASC
Parameters:
[
  1
]
3.56 ms
(1.88%)
1
SELECT s0_.id AS id_0, s0_.whatsapp_group AS whatsapp_group_1, d1_.id AS id_2, d1_.omschrijving AS omschrijving_3, s0_.seizoen_id AS seizoen_id_4, s0_.divisie_id AS divisie_id_5 FROM seizoendivisies s0_ INNER JOIN divisies d1_ ON s0_.divisie_id = d1_.id WHERE s0_.seizoen_id = ? ORDER BY d1_.omschrijving ASC
Parameters:
[
  1
]
3.34 ms
(1.77%)
4
SELECT t0.id AS id_1, t0.nr AS nr_2, t0.startdatum AS startdatum_3, t0.einddatum AS einddatum_4, t0.ind_aktief AS ind_aktief_5, t0.ind_verwerkt AS ind_verwerkt_6, t0.seizoen_id AS seizoen_id_7 FROM seizoenrondes t0 WHERE t0.id = ?
Parameters:
[
  2
]
2.24 ms
(1.18%)
1
SELECT s0_.id AS id_0, s0_.omschrijving AS omschrijving_1, s0_.startdatum AS startdatum_2, s0_.einddatum AS einddatum_3, s0_.ind_aktief AS ind_aktief_4, s0_.ind_inonderhoud AS ind_inonderhoud_5 FROM seizoenen s0_ WHERE s0_.ind_aktief = 1 LIMIT 1
Parameters:
[]
0.96 ms
(0.51%)
1
SELECT t0.id AS id_1, t0.sitename AS sitename_2, t0.skin AS skin_3, t0.naam AS naam_4, t0.adres AS adres_5, t0.postcode AS postcode_6, t0.plaats AS plaats_7, t0.telefoon AS telefoon_8, t0.email AS email_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.linkedin AS linkedin_12, t0.youtube AS youtube_13, t0.email_noreply AS email_noreply_14, t0.email_contact AS email_contact_15, t0.email_beheer AS email_beheer_16 FROM settings t0 WHERE t0.id = ?
Parameters:
[
  1
]

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