Query Metrics
29
Database Queries
5
Different statements
26.67 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 6.49 ms |
SELECT t0.id AS id_1, t0.maintenance AS maintenance_2, t0.mode_test AS mode_test_3 FROM system_configuration t0 WHERE t0.id = ?
Parameters:
[
1
]
|
2 | 0.88 ms |
SELECT t0.id AS id_1, t0.contenu AS contenu_2 FROM config_header t0 WHERE t0.id = ?
Parameters:
[
2
]
|
3 | 1.78 ms |
SELECT t0.id AS id_1, t0.nom_questionnaire AS nom_questionnaire_2, t0.url_questionnaire AS url_questionnaire_3, t0.code_couleur AS code_couleur_4, t0.couleur_contraste AS couleur_contraste_5, t0.meta_description AS meta_description_6, t0.img_principale AS img_principale_7, t0.fond AS fond_8, t0.presentation AS presentation_9, t0.header AS header_10, t0.comptage_commencer AS comptage_commencer_11, t0.compage_terminer AS compage_terminer_12, t0.comptage_envoye AS comptage_envoye_13, t0.etat AS etat_14, t0.created_at AS created_at_15, t0.hashed_url AS hashed_url_16, t0.reponse_profil_id AS reponse_profil_id_17 FROM questionnaire t0 WHERE t0.url_questionnaire = ? LIMIT 1
Parameters:
[
"irooki"
]
|
4 | 1.55 ms |
SELECT t0.id AS id_1, t0.nom_questionnaire AS nom_questionnaire_2, t0.question AS question_3, t0.image AS image_4, t0.fond AS fond_5, t0.largeur AS largeur_6, t0.num_responses AS num_responses_7, t0.questionnaire_id AS questionnaire_id_8 FROM questions t0 WHERE t0.questionnaire_id = ?
Parameters:
[
134
]
|
5 | 1.16 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
159
]
|
6 | 0.70 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
160
]
|
7 | 0.63 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
161
]
|
8 | 0.52 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
163
]
|
9 | 0.60 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
164
]
|
10 | 0.72 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
165
]
|
11 | 0.63 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
166
]
|
12 | 0.68 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
167
]
|
13 | 0.70 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
168
]
|
14 | 0.61 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
169
]
|
15 | 0.60 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
170
]
|
16 | 0.50 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
171
]
|
17 | 0.52 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
172
]
|
18 | 0.53 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
173
]
|
19 | 0.70 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
174
]
|
20 | 0.63 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
175
]
|
21 | 0.60 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
176
]
|
22 | 0.47 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
177
]
|
23 | 0.65 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
178
]
|
24 | 0.51 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
179
]
|
25 | 0.52 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
180
]
|
26 | 0.64 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
181
]
|
27 | 0.71 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
182
]
|
28 | 0.79 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
183
]
|
29 | 0.64 ms |
SELECT t0.id AS id_1, t0.content AS content_2, t0.profile_points AS profile_points_3, t0.question_id AS question_id_4 FROM question_reponse t0 WHERE t0.question_id = ?
Parameters:
[
184
]
|
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\Questionnaire | No errors. |
App\Entity\SystemConfiguration | No errors. |
App\Entity\ConfigHeader | No errors. |
App\Entity\ReponseProfil | No errors. |
App\Entity\Questions |
|
App\Entity\QuestionnaireProfile | No errors. |
App\Entity\QuestionReponse | No errors. |