Query Metrics

29 Database Queries
9 Different statements
16.88 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.