Query Metrics

82 Database Queries
13 Different statements
41.80 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
16.39 ms
(39.20%)
35
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.paragraphe AS paragraphe_3, t0.ordre AS ordre_4, t0.image AS image_5, t0.position AS position_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.id_import_page AS id_import_page_9, t0.id_import AS id_import_10, t0.button_label AS button_label_11, t0.button_type AS button_type_12, t0.button_value AS button_value_13, t0.page_id AS page_id_14, t0.objet_id AS objet_id_15 FROM page_contenu t0 WHERE t0.page_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  2436
]
10.73 ms
(25.68%)
31
SELECT t0.id AS id_1, t0.label AS label_2, t0.actif AS actif_3, t0.ordre AS ordre_4, t0.remarque AS remarque_5, t0.position AS position_6, t0.date_debut AS date_debut_7, t0.date_fin AS date_fin_8, t0.date_creation AS date_creation_9, t0.date_modification AS date_modification_10, t0.visibility AS visibility_11, t0.id_import AS id_import_12, t0.section_id AS section_id_13, t0.projet_id AS projet_id_14 FROM objet t0 WHERE t0.id = ?
Parameters:
[
  223
]
3.06 ms
(7.31%)
5
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:
[
  422
]
1.74 ms
(4.17%)
1
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:
[
  402
]
1.64 ms
(3.92%)
2
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:
[
  231
]
1.61 ms
(3.86%)
1
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:
[
  101
]
1.52 ms
(3.65%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.titre_nav AS titre_nav_3, t0.sous_titre AS sous_titre_4, t0.image AS image_5, t0.keywords AS keywords_6, t0.ordre AS ordre_7, t0.actif AS actif_8, t0.description AS description_9, t0.description_courte AS description_courte_10, t0.description_fin AS description_fin_11, t0.icon AS icon_12, t0.date_creation AS date_creation_13, t0.date_modification AS date_modification_14, t0.meta_description AS meta_description_15, t0.id_import AS id_import_16, t0.id_import_page_liee AS id_import_page_liee_17, t0.niveau AS niveau_18, t0.permalink AS permalink_19, t0.parent_id AS parent_id_20, t0.projet_id AS projet_id_21, t0.formulaire_id AS formulaire_id_22, t0.combi_id AS combi_id_23 FROM page t0 WHERE t0.projet_id = ? ORDER BY t0.ordre ASC
Parameters:
[
  24
]
1.37 ms
(3.29%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.nb_ligne AS nb_ligne_3, t0.created_at AS created_at_4, t0.projet_id AS projet_id_5 FROM combi t0 WHERE t0.id = ?
Parameters:
[
  20
]
1.30 ms
(3.11%)
1
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
]
0.71 ms
(1.70%)
1
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:
[
  24
]
0.61 ms
(1.46%)
1
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.logo_pdf AS logo_pdf_17, t0.image_ftp_server AS image_ftp_server_18, t0.image_ftp_login AS image_ftp_login_19, t0.image_ftp_mdp AS image_ftp_mdp_20, t0.image_http_server AS image_http_server_21, t0.web_ftp_server AS web_ftp_server_22, t0.web_ftp_login AS web_ftp_login_23, t0.web_ftp_mdp AS web_ftp_mdp_24, t0.contact1_label AS contact1_label_25, t0.contact1_tel AS contact1_tel_26, t0.contact1_email AS contact1_email_27, t0.contact2_label AS contact2_label_28, t0.contact2_tel AS contact2_tel_29, t0.contact2_email AS contact2_email_30, t0.contact3_label AS contact3_label_31, t0.contact3_tel AS contact3_tel_32, t0.contact3_email AS contact3_email_33, t0.smtp_server AS smtp_server_34, t0.smtp_port AS smtp_port_35, t0.smtp_login AS smtp_login_36, t0.smtp_mdp AS smtp_mdp_37, t0.email_sender AS email_sender_38, t0.email_recipient AS email_recipient_39, t0.smtp_email_api_key AS smtp_email_api_key_40, t0.sms_sender AS sms_sender_41, t0.sms_api_key AS sms_api_key_42, t0.google_analytics AS google_analytics_43, t0.recaptcha_site_key AS recaptcha_site_key_44, t0.recaptcha_project_id AS recaptcha_project_id_45, t0.recaptcha_config_file AS recaptcha_config_file_46, t0.date_creation AS date_creation_47, t0.date_modification AS date_modification_48, t0.logo_dark AS logo_dark_49, t0.logo_vertical_dark AS logo_vertical_dark_50, t0.image_ftp_server_enligne AS image_ftp_server_enligne_51, t0.image_ftp_login_enligne AS image_ftp_login_enligne_52, t0.image_ftp_mdp_enligne AS image_ftp_mdp_enligne_53, t0.image_http_server_enligne AS image_http_server_enligne_54, t0.web_ftp_server_enligne AS web_ftp_server_enligne_55, t0.web_ftp_login_enligne AS web_ftp_login_enligne_56, t0.web_ftp_mdp_enligne AS web_ftp_mdp_enligne_57, t0.switch_en_ligne AS switch_en_ligne_58, t0.contact1_adresse AS contact1_adresse_59, t0.contact1_remarque AS contact1_remarque_60, t0.contact2_adresse AS contact2_adresse_61, t0.contact2_remarque AS contact2_remarque_62, t0.contact3_adresse AS contact3_adresse_63, t0.contact3_remarque AS contact3_remarque_64, t0.database_url AS database_url_65, t0.database_url_enligne AS database_url_enligne_66, t0.app_secret AS app_secret_67 FROM projet t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  24
]
0.56 ms
(1.33%)
1
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.id = ?
Parameters:
[
  101
]
0.55 ms
(1.31%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.ordre AS ordre_3, t0.nbr_liaison AS nbr_liaison_4, t0.date_creation AS date_creation_5, t0.date_modification AS date_modification_6, t0.actif AS actif_7, t0.id_import AS id_import_8, t0.actif_date AS actif_date_9, t0.actif_redacteur AS actif_redacteur_10, t0.emplacement_image AS emplacement_image_11, t0.permalink AS permalink_12, t0.icon AS icon_13, t0.projet_id AS projet_id_14 FROM article_type t0 WHERE t0.projet_id = ?
Parameters:
[
  24
]

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\Objet No errors.
App\Entity\Section No errors.
App\Entity\PageContenu No errors.
App\Entity\Article No errors.
App\Entity\FormulaireEtape No errors.
App\Entity\CombiVariable No errors.
App\Entity\ConfigObjet No errors.
App\Entity\BlockObjet No errors.
App\Entity\ArticleContenu No errors.
App\Entity\FormulaireChampLiee No errors.
App\Entity\FormulaireChamp No errors.
App\Entity\FormulaireOption No errors.