GET https://move-test.awa-solutions.fr/3/resultats-configuration

Query Metrics

106 Database Queries
7 Different statements
39.22 ms Query time
1 Invalid entities
181 Managed entities

Grouped Statements

Show all queries

Time Count Info
26.21 ms
(66.83%)
79
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.id_question_id AS id_question_id_3 FROM sous_question t0 WHERE t0.id_question_id = ?
Parameters:
[
  72
]
3.58 ms
(9.14%)
8
SELECT t0.id AS id_1, t0.description AS description_2, t0.date_creation AS date_creation_3, t0.date_derniere_modification AS date_derniere_modification_4, t0.nom_questionnaire_id AS nom_questionnaire_id_5, t0.profil_questionnaire_id AS profil_questionnaire_id_6 FROM questionnaire t0 WHERE t0.id = ?
Parameters:
[
  8
]
3.57 ms
(9.10%)
8
SELECT t0.id AS id_1, t0.intitule AS intitule_2, t0.obligatoire AS obligatoire_3, t0.ordre AS ordre_4, t0.valeur_calcul AS valeur_calcul_5, t0.id_questionnaire_id AS id_questionnaire_id_6, t0.id_type_reponse_id AS id_type_reponse_id_7 FROM question t0 WHERE t0.id_questionnaire_id = ?
Parameters:
[
  8
]
3.46 ms
(8.82%)
8
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.est_utilise AS est_utilise_3, t0.langue AS langue_4, t5.id AS id_6, t5.description AS description_7, t5.date_creation AS date_creation_8, t5.date_derniere_modification AS date_derniere_modification_9, t5.nom_questionnaire_id AS nom_questionnaire_id_10, t5.profil_questionnaire_id AS profil_questionnaire_id_11 FROM nom_questionnaire t0 LEFT JOIN questionnaire t5 ON t5.nom_questionnaire_id = t0.id WHERE t0.id = ?
Parameters:
[
  8
]
0.99 ms
(2.52%)
1
SELECT t0.id AS id_1, t0.date AS date_2, t0.json_reponses AS json_reponses_3, t0.statut AS statut_4, t0.id_questionnaire_id AS id_questionnaire_id_5, t0.id_sportif_id AS id_sportif_id_6, t0.id_participant_id AS id_participant_id_7, t0.id_config_id AS id_config_id_8, t9.id AS id_10, t9.date AS date_11, t9.preparation_calcul AS preparation_calcul_12, t9.total AS total_13, t9.interpretation AS interpretation_14, t9.type_questionnaire AS type_questionnaire_15, t9.resultat_questionnaire_id AS resultat_questionnaire_id_16, t9.sportif_id AS sportif_id_17, t9.participant_id AS participant_id_18, t9.profil_general_id AS profil_general_id_19 FROM resultat_questionnaire t0 LEFT JOIN score_questionnaire t9 ON t9.resultat_questionnaire_id = t0.id WHERE t0.id_config_id = ?
Parameters:
[
  3
]
0.79 ms
(2.01%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.url_qrcode AS url_qrcode_4, t0.type_mesure AS type_mesure_5, t0.active AS active_6, t0.structure_id AS structure_id_7, t0.etude_id AS etude_id_8 FROM configuration_questionnaire t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
0.62 ms
(1.59%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  1
]

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\Question 79
App\Entity\SousQuestion 58
App\Entity\ResultatQuestionnaire 8
App\Entity\Questionnaire 8
App\Entity\NomQuestionnaire 8
App\Entity\TypeReponse 8
App\Entity\ScoreQuestionnaire 7
App\Entity\ConfigurationQuestionnaire 1
App\Entity\StructureEntrainement 1
App\Entity\User 1
App\Entity\Sportif 1
App\Entity\ProfilGeneral 1

Entities Mapping

Class Mapping errors
App\Entity\ConfigurationQuestionnaire
  • If association App\Entity\ConfigurationQuestionnaire#etude is many-to-one, then the inversed side App\Entity\Etude#configurationQuestionnaires has to be one-to-many.
App\Entity\StructureEntrainement No errors.
App\Entity\Etude No errors.
App\Entity\LienConfigQuestionnaire No errors.
App\Entity\ResultatQuestionnaire No errors.
App\Entity\User No errors.
App\Entity\Chercheur No errors.
App\Entity\HistoriqueMails No errors.
App\Entity\Questionnaire No errors.
App\Entity\Sportif No errors.
App\Entity\Participant No errors.
App\Entity\ScoreQuestionnaire No errors.
App\Entity\ProfilGeneral No errors.
App\Entity\NomQuestionnaire No errors.
App\Entity\ProfilQuestionnaire No errors.
App\Entity\Question No errors.
App\Entity\TypeReponse No errors.
App\Entity\SousQuestion No errors.
App\Entity\Reponse No errors.