GET https://servicecivique.lfna.fr/visite

Query Metrics

26 Database Queries
3 Different statements
3.61 ms Query time
0 Invalid entities
50 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.25 ms
SELECT t0.id AS id_1, t0.cg AS cg_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.created_at AS created_at_6, t0.connected_at AS connected_at_7, t0.nom AS nom_8, t0.prenom AS prenom_9 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 0.15 ms
SELECT t0.id AS id_1, t0.cl_cod AS cl_cod_2, t0.date AS date_3, t0.subject AS subject_4, t0.body AS body_5, t0.visited_at AS visited_at_6, t0.conclusion AS conclusion_7, t0.created_at AS created_at_8, t0.created_by AS created_by_9, t0.updated_at AS updated_at_10, t0.departement AS departement_11 FROM club_visite t0
Parameters:
[]
3 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  530360
]
4 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  520964
]
5 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  525269
]
6 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  560500
]
7 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  580587
]
8 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  523322
]
9 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  500
]
10 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  563725
]
11 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  580598
]
12 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  500042
]
13 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  507200
]
14 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  563716
]
15 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  580608
]
16 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  514428
]
17 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  565815
]
18 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  552085
]
19 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  505681
]
20 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  509585
]
21 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  500211
]
22 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  560360
]
23 0.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  550805
]
24 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  500491
]
25 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  552163
]
26 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.zip AS zip_3, t0.insee AS insee_4, t0.cg AS cg_5, t0.status AS status_6, t0.type AS type_7, t0.affiliated_at AS affiliated_at_8, t0.licences AS licences_9, t0.competition AS competition_10, t0.date_affiliation AS date_affiliation_11, t0.date_agrement AS date_agrement_12, t0.updated_at AS updated_at_13 FROM club t0 WHERE t0.id = ?
Parameters:
[
  552732
]

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\ClubVisite 25
App\Entity\Club 24
App\Entity\User 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\ClubVisite No errors.
App\Entity\Club No errors.