GET https://projet-matthew.fr/api/emplacements-lat-lng

Query Metrics

79 Database Queries
2 Different statements
75.64 ms Query time
0 Invalid entities
357 Managed entities

Grouped Statements

Show all queries

Time Count Info
73.18 ms
(96.75%)
78
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.pprenom AS pprenom_3, t0.resp_resa AS resp_resa_4, t0.date_resa AS date_resa_5, t0.tel AS tel_6, t0.email AS email_7, t0.nb_empl AS nb_empl_8, t0.tarif AS tarif_9, t0.rglt AS rglt_10, t0.mode_rglt AS mode_rglt_11, t0.notes AS notes_12, t0.date_naissance AS date_naissance_13, t0.lieu_naissance AS lieu_naissance_14, t0.adresse AS adresse_15, t0.cp AS cp_16, t0.ville AS ville_17, t0.num_cni AS num_cni_18, t0.date_cni AS date_cni_19, t0.deliv_cni AS deliv_cni_20, t0.is_pro AS is_pro_21, t0.siret AS siret_22, t0.photo_idtt_recto AS photo_idtt_recto_23, t0.photo_idtt_verso AS photo_idtt_verso_24, t0.is_ombre AS is_ombre_25, t0.is_voiture AS is_voiture_26, t0.is_fixe_emplacement AS is_fixe_emplacement_27, t0.nat_cni AS nat_cni_28, t0.etat_arrivee AS etat_arrivee_29 FROM reservations t0 WHERE t0.id = ?
Parameters:
[
  8
]
2.46 ms
(3.25%)
1
SELECT t0.id AS id_1, t0.is_ombre AS is_ombre_2, t0.is_voiture AS is_voiture_3, t0.secteur AS secteur_4, t0.num AS num_5, t0.lat AS lat_6, t0.lng AS lng_7, t0.lat_fixe AS lat_fixe_8, t0.lng_fixe AS lng_fixe_9, t10.id AS id_11, t10.emplacement_id AS emplacement_id_12, t10.resa_id AS resa_id_13 FROM emplacement t0 LEFT JOIN lien_empl_resa t10 ON t10.emplacement_id = t0.id
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\Emplacement 162
App\Entity\LienEmplResa 114
App\Entity\Reservations 81

Entities Mapping

Class Mapping errors
App\Entity\Emplacement No errors.
App\Entity\LienEmplResa No errors.
App\Entity\Reservations No errors.