Query Metrics

8 Database Queries
5 Different statements
10.38 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.57 ms
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:
[
  "8"
]
2 1.84 ms
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 1.09 ms
SELECT t0.id AS id_1, t0.omschrijving AS omschrijving_2, t0.startdatum AS startdatum_3, t0.einddatum AS einddatum_4, t0.ind_aktief AS ind_aktief_5, t0.ind_inonderhoud AS ind_inonderhoud_6 FROM seizoenen t0 WHERE t0.id = ?
Parameters:
[
  1
]
4 1.01 ms
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
]
5 1.89 ms
SELECT s0_.id AS id_0, s0_.team1_games AS team1_games_1, s0_.team2_games AS team2_games_2, s0_.team1_rating AS team1_rating_3, s0_.team2_rating AS team2_rating_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.team1_pos AS team1_pos_7, s0_.team2_pos AS team2_pos_8, s0_.token AS token_9, s0_.seizoendivisie_id AS seizoendivisie_id_10, s0_.seizoenronde_id AS seizoenronde_id_11, s0_.seizoenteam1_id AS seizoenteam1_id_12, s0_.seizoenteam2_id AS seizoenteam2_id_13 FROM seizoenwedstrijden s0_ INNER JOIN seizoenteams s1_ ON s0_.seizoenteam1_id = s1_.id WHERE s0_.seizoendivisie_id = ? AND s0_.seizoenronde_id = ? ORDER BY s0_.team1_pos ASC, s1_.positie ASC
Parameters:
[
  1
  8
]
6 0.90 ms
SELECT s0_.id AS id_0, s0_.team1_games AS team1_games_1, s0_.team2_games AS team2_games_2, s0_.team1_rating AS team1_rating_3, s0_.team2_rating AS team2_rating_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.team1_pos AS team1_pos_7, s0_.team2_pos AS team2_pos_8, s0_.token AS token_9, s0_.seizoendivisie_id AS seizoendivisie_id_10, s0_.seizoenronde_id AS seizoenronde_id_11, s0_.seizoenteam1_id AS seizoenteam1_id_12, s0_.seizoenteam2_id AS seizoenteam2_id_13 FROM seizoenwedstrijden s0_ INNER JOIN seizoenteams s1_ ON s0_.seizoenteam1_id = s1_.id WHERE s0_.seizoendivisie_id = ? AND s0_.seizoenronde_id = ? ORDER BY s0_.team1_pos ASC, s1_.positie ASC
Parameters:
[
  2
  8
]
7 0.95 ms
SELECT s0_.id AS id_0, s0_.team1_games AS team1_games_1, s0_.team2_games AS team2_games_2, s0_.team1_rating AS team1_rating_3, s0_.team2_rating AS team2_rating_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.team1_pos AS team1_pos_7, s0_.team2_pos AS team2_pos_8, s0_.token AS token_9, s0_.seizoendivisie_id AS seizoendivisie_id_10, s0_.seizoenronde_id AS seizoenronde_id_11, s0_.seizoenteam1_id AS seizoenteam1_id_12, s0_.seizoenteam2_id AS seizoenteam2_id_13 FROM seizoenwedstrijden s0_ INNER JOIN seizoenteams s1_ ON s0_.seizoenteam1_id = s1_.id WHERE s0_.seizoendivisie_id = ? AND s0_.seizoenronde_id = ? ORDER BY s0_.team1_pos ASC, s1_.positie ASC
Parameters:
[
  3
  8
]
8 1.13 ms
SELECT s0_.id AS id_0, s0_.team1_games AS team1_games_1, s0_.team2_games AS team2_games_2, s0_.team1_rating AS team1_rating_3, s0_.team2_rating AS team2_rating_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.team1_pos AS team1_pos_7, s0_.team2_pos AS team2_pos_8, s0_.token AS token_9, s0_.seizoendivisie_id AS seizoendivisie_id_10, s0_.seizoenronde_id AS seizoenronde_id_11, s0_.seizoenteam1_id AS seizoenteam1_id_12, s0_.seizoenteam2_id AS seizoenteam2_id_13 FROM seizoenwedstrijden s0_ INNER JOIN seizoenteams s1_ ON s0_.seizoenteam1_id = s1_.id WHERE s0_.seizoendivisie_id = ? AND s0_.seizoenronde_id = ? ORDER BY s0_.team1_pos ASC, s1_.positie ASC
Parameters:
[
  5
  8
]

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