Query Metrics
7
Database Queries
7
Different statements
5.73 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.64 ms (28.61%) |
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.93 ms (16.29%) |
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
]
]
|
0.86 ms (15.10%) |
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.66 ms (11.49%) |
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 = ?
Parameters:
[
24
]
|
0.64 ms (11.16%) |
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.62 ms (10.86%) |
1 |
SELECT count(p0_.id) AS sclr_0 FROM projet p0_
Parameters:
[] |
0.37 ms (6.49%) |
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. |