Query Metrics
2
Database Queries
2
Different statements
28.05 ms
Query time
0
Invalid entities
741
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 26.75 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_reel AS nom_reel_3, t0.note AS note_4, t0.pays AS pays_5, t0.ville AS ville_6, t0.date_creation AS date_creation_7, t0.histoire AS histoire_8, t0.infos AS infos_9, t0.acces AS acces_10, t0.videosurveillance AS videosurveillance_11, t0.gardien AS gardien_12, t0.difficulte_acces AS difficulte_acces_13, t0.danger AS danger_14, t0.degradation_humaine AS degradation_humaine_15, t0.degradation_naturelle AS degradation_naturelle_16, t0.temps_exploration AS temps_exploration_17, t0.historique_updates AS historique_updates_18, t0.date_update AS date_update_19, t0.alarme AS alarme_20, t0.date_publication AS date_publication_21, t0.statut AS statut_22, t0.validation_manuelle AS validation_manuelle_23, t0.masque AS masque_24, t0.raison_refus AS raison_refus_25, t0.latitude AS latitude_26, t0.longitude AS longitude_27, t0.wikipedia AS wikipedia_28, t0.etat_id AS etat_id_29, t0.type_id AS type_id_30, t0.region_id AS region_id_31, t0.architecture_id AS architecture_id_32, t0.departement_id AS departement_id_33, t0.user_id AS user_id_34, t0.mignature_id AS mignature_id_35 FROM spots t0 WHERE t0.statut = ?
Parameters:
[
"VALIDE"
]
|
||||||||||||||||||||||||
| 2 | 1.30 ms |
SELECT t0.id AS id_1, t0.pseudo AS pseudo_2, t0.roles AS roles_3, t0.password AS password_4, t0.pdp AS pdp_5, t0.description AS description_6, t0.mail AS mail_7, t0.reseaux_sociaux AS reseaux_sociaux_8, t0.derniere_connexion AS derniere_connexion_9, t0.reset_password_key AS reset_password_key_10, t0.reset_password_end AS reset_password_end_11, t0.mail_valid AS mail_valid_12, t0.statut AS statut_13, t0.parametres AS parametres_14 FROM user t0
Parameters:
[]
|
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\Spots | 502 |
| App\Entity\Departements | 77 |
| App\Entity\User | 73 |
| App\Entity\SpotPhotos | 57 |
| App\Entity\Regions | 13 |
| App\Entity\SpotType | 11 |
| App\Entity\SpotEtat | 4 |
| App\Entity\SpotArchitecture | 4 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Spots | No errors. |
| App\Entity\SpotEtat | No errors. |
| App\Entity\SpotType | No errors. |
| App\Entity\Regions | No errors. |
| App\Entity\SpotArchitecture | No errors. |
| App\Entity\Departements | No errors. |
| App\Entity\User | No errors. |
| App\Entity\SpotPhotos | No errors. |
| App\Entity\SpotNotes | No errors. |