Query Metrics
29
Database Queries
9
Different statements
16.88 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 2.86 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.etat AS etat_7, t0.telephone AS telephone_8, t0.date_creation AS date_creation_9, t0.date_modification AS date_modification_10, t0.is_verified AS is_verified_11, t0.remarque AS remarque_12, t0.projet_id AS projet_id_13 FROM user t0 WHERE t0.id = ?
Parameters:
[
18
]
|
| 2 | 1.21 ms |
SELECT t0.id AS id_1, t0.projet AS projet_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.remarque AS remarque_5, t0.nbr_page AS nbr_page_6, t0.nbr_article AS nbr_article_7, t0.nbr_main_nav AS nbr_main_nav_8, t0.home_title_prefix AS home_title_prefix_9, t0.home_title_suffix AS home_title_suffix_10, t0.home_description AS home_description_11, t0.home_keywords AS home_keywords_12, t0.logo AS logo_13, t0.logo_vertical AS logo_vertical_14, t0.logo_favicon AS logo_favicon_15, t0.logo_open_graph AS logo_open_graph_16, t0.image_ftp_server AS image_ftp_server_17, t0.image_ftp_login AS image_ftp_login_18, t0.image_ftp_mdp AS image_ftp_mdp_19, t0.image_http_server AS image_http_server_20, t0.web_ftp_server AS web_ftp_server_21, t0.web_ftp_login AS web_ftp_login_22, t0.web_ftp_mdp AS web_ftp_mdp_23, t0.contact1_label AS contact1_label_24, t0.contact1_tel AS contact1_tel_25, t0.contact1_email AS contact1_email_26, t0.contact2_label AS contact2_label_27, t0.contact2_tel AS contact2_tel_28, t0.contact2_email AS contact2_email_29, t0.contact3_label AS contact3_label_30, t0.contact3_tel AS contact3_tel_31, t0.contact3_email AS contact3_email_32, t0.smtp_server AS smtp_server_33, t0.smtp_port AS smtp_port_34, t0.smtp_login AS smtp_login_35, t0.smtp_mdp AS smtp_mdp_36, t0.email_sender AS email_sender_37, t0.email_recipient AS email_recipient_38, t0.smtp_email_api_key AS smtp_email_api_key_39, t0.sms_sender AS sms_sender_40, t0.sms_api_key AS sms_api_key_41, t0.google_analytics AS google_analytics_42, t0.recaptcha_site_key AS recaptcha_site_key_43, t0.recaptcha_project_id AS recaptcha_project_id_44, t0.recaptcha_config_file AS recaptcha_config_file_45, t0.date_creation AS date_creation_46, t0.date_modification AS date_modification_47, t0.logo_dark AS logo_dark_48, t0.logo_vertical_dark AS logo_vertical_dark_49, t0.image_ftp_server_enligne AS image_ftp_server_enligne_50, t0.image_ftp_login_enligne AS image_ftp_login_enligne_51, t0.image_ftp_mdp_enligne AS image_ftp_mdp_enligne_52, t0.image_http_server_enligne AS image_http_server_enligne_53, t0.web_ftp_server_enligne AS web_ftp_server_enligne_54, t0.web_ftp_login_enligne AS web_ftp_login_enligne_55, t0.web_ftp_mdp_enligne AS web_ftp_mdp_enligne_56, t0.switch_en_ligne AS switch_en_ligne_57, t0.contact1_adresse AS contact1_adresse_58, t0.contact1_remarque AS contact1_remarque_59, t0.contact2_adresse AS contact2_adresse_60, t0.contact2_remarque AS contact2_remarque_61, t0.contact3_adresse AS contact3_adresse_62, t0.contact3_remarque AS contact3_remarque_63, t0.database_url AS database_url_64, t0.database_url_enligne AS database_url_enligne_65, t0.app_secret AS app_secret_66 FROM projet t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
21
]
|
| 3 | 0.74 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.titre AS titre_3, t0.description_debut AS description_debut_4, t0.description_fin AS description_fin_5, t0.date_creation AS date_creation_6, t0.date_modification AS date_modification_7, t0.id_import AS id_import_8, t0.projet_id AS projet_id_9 FROM formulaire t0 WHERE t0.projet_id = ?
Parameters:
[
21
]
|
| 4 | 0.63 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.actif AS actif_5, t0.save AS save_6, t0.secure AS secure_7, t0.id_import AS id_import_8, t0.id_import_formulaire AS id_import_formulaire_9, t0.date_creation AS date_creation_10, t0.date_modification AS date_modification_11, t0.formulaire_id AS formulaire_id_12 FROM formulaire_etape t0 WHERE t0.formulaire_id = ? ORDER BY t0.ordre ASC
Parameters:
[
69
]
|
| 5 | 0.66 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.obligatoire AS obligatoire_3, t0.date_creation AS date_creation_4, t0.date_modification AS date_modification_5, t0.id_import AS id_import_6, t0.id_import_etape AS id_import_etape_7, t0.id_import_champ AS id_import_champ_8, t0.formulaire_etape_id AS formulaire_etape_id_9, t0.formulaire_champ_id AS formulaire_champ_id_10 FROM formulaire_champ_liee t0 WHERE t0.formulaire_etape_id = ? ORDER BY t0.ordre ASC
Parameters:
[
245
]
|
| 6 | 0.49 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.question AS question_3, t0.description AS description_4, t0.actif AS actif_5, t0.attribut AS attribut_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.id_import AS id_import_9, t0.id_import_input AS id_import_input_10, t0.id_import_recap AS id_import_recap_11, t0.formulaire_recap_id AS formulaire_recap_id_12, t0.formulaire_input_id AS formulaire_input_id_13 FROM formulaire_champ t0 WHERE t0.id = ?
Parameters:
[
219
]
|
| 7 | 0.50 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3, t0.actif AS actif_4, t0.attribut AS attribut_5, t0.date_creation AS date_creation_6, t0.date_modification AS date_modification_7, t0.id_import AS id_import_8, t0.projet_id AS projet_id_9 FROM formulaire_input t0 WHERE t0.id = ?
Parameters:
[
173
]
|
| 8 | 0.39 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.question AS question_3, t0.description AS description_4, t0.actif AS actif_5, t0.attribut AS attribut_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.id_import AS id_import_9, t0.id_import_input AS id_import_input_10, t0.id_import_recap AS id_import_recap_11, t0.formulaire_recap_id AS formulaire_recap_id_12, t0.formulaire_input_id AS formulaire_input_id_13 FROM formulaire_champ t0 WHERE t0.id = ?
Parameters:
[
220
]
|
| 9 | 0.35 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.question AS question_3, t0.description AS description_4, t0.actif AS actif_5, t0.attribut AS attribut_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.id_import AS id_import_9, t0.id_import_input AS id_import_input_10, t0.id_import_recap AS id_import_recap_11, t0.formulaire_recap_id AS formulaire_recap_id_12, t0.formulaire_input_id AS formulaire_input_id_13 FROM formulaire_champ t0 WHERE t0.id = ?
Parameters:
[
231
]
|
| 10 | 0.34 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.question AS question_3, t0.description AS description_4, t0.actif AS actif_5, t0.attribut AS attribut_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.id_import AS id_import_9, t0.id_import_input AS id_import_input_10, t0.id_import_recap AS id_import_recap_11, t0.formulaire_recap_id AS formulaire_recap_id_12, t0.formulaire_input_id AS formulaire_input_id_13 FROM formulaire_champ t0 WHERE t0.id = ?
Parameters:
[
376
]
|
| 11 | 0.31 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3, t0.actif AS actif_4, t0.attribut AS attribut_5, t0.date_creation AS date_creation_6, t0.date_modification AS date_modification_7, t0.id_import AS id_import_8, t0.projet_id AS projet_id_9 FROM formulaire_input t0 WHERE t0.id = ?
Parameters:
[
176
]
|
| 12 | 0.36 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.obligatoire AS obligatoire_3, t0.date_creation AS date_creation_4, t0.date_modification AS date_modification_5, t0.id_import AS id_import_6, t0.id_import_etape AS id_import_etape_7, t0.id_import_champ AS id_import_champ_8, t0.formulaire_etape_id AS formulaire_etape_id_9, t0.formulaire_champ_id AS formulaire_champ_id_10 FROM formulaire_champ_liee t0 WHERE t0.formulaire_etape_id = ? ORDER BY t0.ordre ASC
Parameters:
[
246
]
|
| 13 | 0.34 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.question AS question_3, t0.description AS description_4, t0.actif AS actif_5, t0.attribut AS attribut_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.id_import AS id_import_9, t0.id_import_input AS id_import_input_10, t0.id_import_recap AS id_import_recap_11, t0.formulaire_recap_id AS formulaire_recap_id_12, t0.formulaire_input_id AS formulaire_input_id_13 FROM formulaire_champ t0 WHERE t0.id = ?
Parameters:
[
224
]
|
| 14 | 0.46 ms |
SELECT t0.id AS id_1, t0.recap AS recap_2, t0.unite AS unite_3, t0.date_creation AS date_creation_4, t0.date_modification AS date_modification_5, t0.id_import AS id_import_6, t0.projet_id AS projet_id_7 FROM formulaire_recap t0 WHERE t0.id = ?
Parameters:
[
163
]
|
| 15 | 0.40 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.obligatoire AS obligatoire_3, t0.date_creation AS date_creation_4, t0.date_modification AS date_modification_5, t0.id_import AS id_import_6, t0.id_import_etape AS id_import_etape_7, t0.id_import_champ AS id_import_champ_8, t0.formulaire_etape_id AS formulaire_etape_id_9, t0.formulaire_champ_id AS formulaire_champ_id_10 FROM formulaire_champ_liee t0 WHERE t0.formulaire_etape_id = ? ORDER BY t0.ordre ASC
Parameters:
[
362
]
|
| 16 | 0.36 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.question AS question_3, t0.description AS description_4, t0.actif AS actif_5, t0.attribut AS attribut_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.id_import AS id_import_9, t0.id_import_input AS id_import_input_10, t0.id_import_recap AS id_import_recap_11, t0.formulaire_recap_id AS formulaire_recap_id_12, t0.formulaire_input_id AS formulaire_input_id_13 FROM formulaire_champ t0 WHERE t0.id = ?
Parameters:
[
378
]
|
| 17 | 0.33 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.question AS question_3, t0.description AS description_4, t0.actif AS actif_5, t0.attribut AS attribut_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.id_import AS id_import_9, t0.id_import_input AS id_import_input_10, t0.id_import_recap AS id_import_recap_11, t0.formulaire_recap_id AS formulaire_recap_id_12, t0.formulaire_input_id AS formulaire_input_id_13 FROM formulaire_champ t0 WHERE t0.id = ?
Parameters:
[
379
]
|
| 18 | 0.32 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3, t0.actif AS actif_4, t0.attribut AS attribut_5, t0.date_creation AS date_creation_6, t0.date_modification AS date_modification_7, t0.id_import AS id_import_8, t0.projet_id AS projet_id_9 FROM formulaire_input t0 WHERE t0.id = ?
Parameters:
[
286
]
|
| 19 | 0.36 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.ordre AS ordre_4, t0.actif AS actif_5, t0.save AS save_6, t0.secure AS secure_7, t0.id_import AS id_import_8, t0.id_import_formulaire AS id_import_formulaire_9, t0.date_creation AS date_creation_10, t0.date_modification AS date_modification_11, t0.formulaire_id AS formulaire_id_12 FROM formulaire_etape t0 WHERE t0.formulaire_id = ? ORDER BY t0.ordre ASC
Parameters:
[
90
]
|
| 20 | 0.36 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.obligatoire AS obligatoire_3, t0.date_creation AS date_creation_4, t0.date_modification AS date_modification_5, t0.id_import AS id_import_6, t0.id_import_etape AS id_import_etape_7, t0.id_import_champ AS id_import_champ_8, t0.formulaire_etape_id AS formulaire_etape_id_9, t0.formulaire_champ_id AS formulaire_champ_id_10 FROM formulaire_champ_liee t0 WHERE t0.formulaire_etape_id = ? ORDER BY t0.ordre ASC
Parameters:
[
363
]
|
| 21 | 0.33 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.question AS question_3, t0.description AS description_4, t0.actif AS actif_5, t0.attribut AS attribut_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.id_import AS id_import_9, t0.id_import_input AS id_import_input_10, t0.id_import_recap AS id_import_recap_11, t0.formulaire_recap_id AS formulaire_recap_id_12, t0.formulaire_input_id AS formulaire_input_id_13 FROM formulaire_champ t0 WHERE t0.id = ?
Parameters:
[
221
]
|
| 22 | 0.32 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.question AS question_3, t0.description AS description_4, t0.actif AS actif_5, t0.attribut AS attribut_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.id_import AS id_import_9, t0.id_import_input AS id_import_input_10, t0.id_import_recap AS id_import_recap_11, t0.formulaire_recap_id AS formulaire_recap_id_12, t0.formulaire_input_id AS formulaire_input_id_13 FROM formulaire_champ t0 WHERE t0.id = ?
Parameters:
[
380
]
|
| 23 | 0.35 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.obligatoire AS obligatoire_3, t0.date_creation AS date_creation_4, t0.date_modification AS date_modification_5, t0.id_import AS id_import_6, t0.id_import_etape AS id_import_etape_7, t0.id_import_champ AS id_import_champ_8, t0.formulaire_etape_id AS formulaire_etape_id_9, t0.formulaire_champ_id AS formulaire_champ_id_10 FROM formulaire_champ_liee t0 WHERE t0.formulaire_etape_id = ? ORDER BY t0.ordre ASC
Parameters:
[
364
]
|
| 24 | 0.38 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.question AS question_3, t0.description AS description_4, t0.actif AS actif_5, t0.attribut AS attribut_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.id_import AS id_import_9, t0.id_import_input AS id_import_input_10, t0.id_import_recap AS id_import_recap_11, t0.formulaire_recap_id AS formulaire_recap_id_12, t0.formulaire_input_id AS formulaire_input_id_13 FROM formulaire_champ t0 WHERE t0.id = ?
Parameters:
[
232
]
|
| 25 | 0.34 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.question AS question_3, t0.description AS description_4, t0.actif AS actif_5, t0.attribut AS attribut_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.id_import AS id_import_9, t0.id_import_input AS id_import_input_10, t0.id_import_recap AS id_import_recap_11, t0.formulaire_recap_id AS formulaire_recap_id_12, t0.formulaire_input_id AS formulaire_input_id_13 FROM formulaire_champ t0 WHERE t0.id = ?
Parameters:
[
228
]
|
| 26 | 2.09 ms |
SELECT t0.id AS id_1, t0.reponse AS reponse_2, t0.ordre AS ordre_3, t0.valeur AS valeur_4, t0.image AS image_5, t0.date_creation AS date_creation_6, t0.date_modification AS date_modification_7, t0.id_import AS id_import_8, t0.id_import_champ AS id_import_champ_9, t0.actif AS actif_10, t0.formulaire_champ_id AS formulaire_champ_id_11 FROM formulaire_option t0 WHERE t0.formulaire_champ_id = ? ORDER BY t0.ordre ASC
Parameters:
[
376
]
|
| 27 | 0.52 ms |
SELECT t0.id AS id_1, t0.reponse AS reponse_2, t0.ordre AS ordre_3, t0.valeur AS valeur_4, t0.image AS image_5, t0.date_creation AS date_creation_6, t0.date_modification AS date_modification_7, t0.id_import AS id_import_8, t0.id_import_champ AS id_import_champ_9, t0.actif AS actif_10, t0.formulaire_champ_id AS formulaire_champ_id_11 FROM formulaire_option t0 WHERE t0.formulaire_champ_id = ? ORDER BY t0.ordre ASC
Parameters:
[
224
]
|
| 28 | 0.38 ms |
SELECT t0.id AS id_1, t0.reponse AS reponse_2, t0.ordre AS ordre_3, t0.valeur AS valeur_4, t0.image AS image_5, t0.date_creation AS date_creation_6, t0.date_modification AS date_modification_7, t0.id_import AS id_import_8, t0.id_import_champ AS id_import_champ_9, t0.actif AS actif_10, t0.formulaire_champ_id AS formulaire_champ_id_11 FROM formulaire_option t0 WHERE t0.formulaire_champ_id = ? ORDER BY t0.ordre ASC
Parameters:
[
378
]
|
| 29 | 0.38 ms |
SELECT t0.id AS id_1, t0.reponse AS reponse_2, t0.ordre AS ordre_3, t0.valeur AS valeur_4, t0.image AS image_5, t0.date_creation AS date_creation_6, t0.date_modification AS date_modification_7, t0.id_import AS id_import_8, t0.id_import_champ AS id_import_champ_9, t0.actif AS actif_10, t0.formulaire_champ_id AS formulaire_champ_id_11 FROM formulaire_option t0 WHERE t0.formulaire_champ_id = ? ORDER BY t0.ordre ASC
Parameters:
[
228
]
|
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\User | No errors. |
| App\Entity\Projet | No errors. |
| App\Entity\UserRole | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\ArticleType | No errors. |
| App\Entity\Formulaire | No errors. |
| App\Entity\FormulaireInput | No errors. |
| App\Entity\FormulaireRecap | No errors. |
| App\Entity\Combi | No errors. |
| App\Entity\Section | No errors. |
| App\Entity\Objet | No errors. |
| App\Entity\FormulaireEtape | No errors. |
| App\Entity\Article | No errors. |
| App\Entity\FormulaireChampLiee | No errors. |
| App\Entity\FormulaireChamp | No errors. |
| App\Entity\FormulaireOption | No errors. |