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

Query Metrics

12 Database Queries
3 Different statements
4.23 ms Query time
0 Invalid entities
19 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.28 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.30 ms
SELECT t0.id AS id_1, t0.cl_cod AS cl_cod_2, t0.title AS title_3, t0.body AS body_4, t0.created_at AS created_at_5, t0.created_by AS created_by_6 FROM club_alert t0
Parameters:
[]
3 0.33 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:
[
  530417
]
4 0.30 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:
[
  6
]
5 0.21 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:
[
  560801
]
6 0.18 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:
[
  500045
]
7 0.24 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:
[
  563836
]
8 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:
[
  550170
]
9 0.22 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:
[
  4
]
10 1.10 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:
[
  507113
]
11 0.67 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:
[
  506296
]
12 0.21 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:
[
  554180
]

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\ClubAlert 8
App\Entity\Club 8
App\Entity\User 3

Entities Mapping

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