GET http://162.19.233.34:9000/rapport/f/d/l/new

Query Metrics

13 Database Queries
4 Different statements
4.34 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.88 ms
SELECT t0.id AS id_1, t0.region AS region_2, t0.commune AS commune_3, t0.shape AS shape_4, t0.localisation AS localisation_5, t0.com_id AS com_id_6, t0.communeb_id AS communeb_id_7 FROM shape_commune t0
Parameters:
[]
2 0.27 ms
SELECT t0.id AS id_1, t0.region AS region_2, t0.departement AS departement_3, t0.commune AS commune_4, t0.village AS village_5, t0.reference AS reference_6, t0.secteur AS secteur_7, t0.libelle AS libelle_8, t0.photo AS photo_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.lat AS lat_12, t0.long AS long_13, t0.fonctionnalite AS fonctionnalite_14, t0.generique_id AS generique_id_15, t0.categorie_id AS categorie_id_16, t0.ct_id AS ct_id_17 FROM georeferencement t0
Parameters:
[]
3 0.46 ms
SELECT c0_.id AS id_0, c0_.commune AS commune_1, c0_.type AS type_2, c0_.region_id AS region_id_3, c0_.departement_id AS departement_id_4 FROM commune c0_
Parameters:
[]
4 0.37 ms
SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 WHERE t0.id = ?
Parameters:
[
  6
]
5 0.25 ms
SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 WHERE t0.id = ?
Parameters:
[
  9
]
6 0.23 ms
SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 0.26 ms
SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 WHERE t0.id = ?
Parameters:
[
  4
]
8 0.23 ms
SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 WHERE t0.id = ?
Parameters:
[
  1
]
9 0.24 ms
SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 WHERE t0.id = ?
Parameters:
[
  7
]
10 0.24 ms
SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 WHERE t0.id = ?
Parameters:
[
  3
]
11 0.28 ms
SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 WHERE t0.id = ?
Parameters:
[
  10
]
12 0.29 ms
SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 WHERE t0.id = ?
Parameters:
[
  8
]
13 0.33 ms
SELECT t0.id AS id_1, t0.secteur AS secteur_2, t0.couleur AS couleur_3, t0.icone AS icone_4, t0.image AS image_5 FROM sectoriel t0 WHERE t0.id = ?
Parameters:
[
  5
]

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