Query Metrics

6 Database Queries
6 Different statements
9.71 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.02 ms
(41.42%)
1
SELECT p0_.id AS id_0, p0_.projet AS projet_1, p0_.date_debut AS date_debut_2, p0_.date_fin AS date_fin_3, p0_.remarque AS remarque_4, p0_.nbr_page AS nbr_page_5, p0_.nbr_article AS nbr_article_6, p0_.nbr_main_nav AS nbr_main_nav_7, p0_.home_title_prefix AS home_title_prefix_8, p0_.home_title_suffix AS home_title_suffix_9, p0_.home_description AS home_description_10, p0_.home_keywords AS home_keywords_11, p0_.logo AS logo_12, p0_.logo_vertical AS logo_vertical_13, p0_.logo_favicon AS logo_favicon_14, p0_.logo_open_graph AS logo_open_graph_15, p0_.logo_pdf AS logo_pdf_16, p0_.image_ftp_server AS image_ftp_server_17, p0_.image_ftp_login AS image_ftp_login_18, p0_.image_ftp_mdp AS image_ftp_mdp_19, p0_.image_http_server AS image_http_server_20, p0_.web_ftp_server AS web_ftp_server_21, p0_.web_ftp_login AS web_ftp_login_22, p0_.web_ftp_mdp AS web_ftp_mdp_23, p0_.contact1_label AS contact1_label_24, p0_.contact1_tel AS contact1_tel_25, p0_.contact1_email AS contact1_email_26, p0_.contact2_label AS contact2_label_27, p0_.contact2_tel AS contact2_tel_28, p0_.contact2_email AS contact2_email_29, p0_.contact3_label AS contact3_label_30, p0_.contact3_tel AS contact3_tel_31, p0_.contact3_email AS contact3_email_32, p0_.smtp_server AS smtp_server_33, p0_.smtp_port AS smtp_port_34, p0_.smtp_login AS smtp_login_35, p0_.smtp_mdp AS smtp_mdp_36, p0_.email_sender AS email_sender_37, p0_.email_recipient AS email_recipient_38, p0_.smtp_email_api_key AS smtp_email_api_key_39, p0_.sms_sender AS sms_sender_40, p0_.sms_api_key AS sms_api_key_41, p0_.google_analytics AS google_analytics_42, p0_.recaptcha_site_key AS recaptcha_site_key_43, p0_.recaptcha_project_id AS recaptcha_project_id_44, p0_.recaptcha_config_file AS recaptcha_config_file_45, p0_.date_creation AS date_creation_46, p0_.date_modification AS date_modification_47, p0_.logo_dark AS logo_dark_48, p0_.logo_vertical_dark AS logo_vertical_dark_49, p0_.image_ftp_server_enligne AS image_ftp_server_enligne_50, p0_.image_ftp_login_enligne AS image_ftp_login_enligne_51, p0_.image_ftp_mdp_enligne AS image_ftp_mdp_enligne_52, p0_.image_http_server_enligne AS image_http_server_enligne_53, p0_.web_ftp_server_enligne AS web_ftp_server_enligne_54, p0_.web_ftp_login_enligne AS web_ftp_login_enligne_55, p0_.web_ftp_mdp_enligne AS web_ftp_mdp_enligne_56, p0_.switch_en_ligne AS switch_en_ligne_57, p0_.contact1_adresse AS contact1_adresse_58, p0_.contact1_remarque AS contact1_remarque_59, p0_.contact2_adresse AS contact2_adresse_60, p0_.contact2_remarque AS contact2_remarque_61, p0_.contact3_adresse AS contact3_adresse_62, p0_.contact3_remarque AS contact3_remarque_63, p0_.database_url AS database_url_64, p0_.database_url_enligne AS database_url_enligne_65, p0_.app_secret AS app_secret_66 FROM projet p0_ WHERE p0_.id IN (?)
Parameters:
[
  [
    24
  ]
]
2.16 ms
(22.26%)
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
]
1.05 ms
(10.83%)
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
]
0.91 ms
(9.34%)
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.89 ms
(9.17%)
1
SELECT count(p0_.id) AS sclr_0 FROM projet p0_
Parameters:
[]
0.68 ms
(6.97%)
1
SELECT DISTINCT p0_.id AS id_0 FROM projet p0_ LIMIT 1000
Parameters:
[]

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.