GET https://climit.web.selmet.inrae.fr/enquete/voir/12

Query Metrics

33 Database Queries
6 Different statements
9.43 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.49 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.prenom AS prenom_3, t0.id_enquete AS id_enquete_4, t0.age AS age_5, t0.fady AS fady_6, t0.ilot_id AS ilot_id_7, t0.genre_id AS genre_id_8 FROM enquete t0 WHERE t0.id = ?
Parameters:
[
  "12"
]
2 0.33 ms
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM genre t0 WHERE t0.id = ?
Parameters:
[
  2
]
3 0.35 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero AS numero_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.fokontany_id AS fokontany_id_6 FROM ilot t0 WHERE t0.id = ?
Parameters:
[
  9
]
4 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.icone_id AS icone_id_3 FROM fokontany t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.38 ms
SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.variable_id AS variable_id_3, t0.enquete_id AS enquete_id_4 FROM data_enquete t0 WHERE t0.enquete_id = ?
Parameters:
[
  12
]
6 0.34 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  13
]
7 0.28 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  14
]
8 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  15
]
9 0.25 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  16
]
10 0.29 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  17
]
11 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  18
]
12 0.25 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  19
]
13 0.26 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  25
]
14 0.25 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  26
]
15 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  27
]
16 0.26 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  28
]
17 0.26 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  29
]
18 0.28 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  34
]
19 0.31 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  40
]
20 0.28 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  41
]
21 0.25 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  42
]
22 0.25 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  43
]
23 0.26 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  44
]
24 0.28 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  45
]
25 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  46
]
26 0.28 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  47
]
27 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  48
]
28 0.29 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  49
]
29 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  50
]
30 0.27 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  63
]
31 0.26 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  64
]
32 0.25 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  65
]
33 0.28 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.numero_question AS numero_question_3, t0.signification AS signification_4, t0.modalites AS modalites_5, t0.is_export AS is_export_6 FROM variable t0 WHERE t0.id = ?
Parameters:
[
  66
]

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

Class Mapping errors
App\Entity\Enquete No errors.
App\Entity\Ilot No errors.
App\Entity\Genre No errors.
App\Entity\Visite No errors.
App\Entity\DataEnquete No errors.
App\Entity\Fokontany No errors.
App\Entity\Icone No errors.
App\Entity\Variable No errors.