Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.titre AS titre_1,
  p0_.titre_nav AS titre_nav_2,
  p0_.sous_titre AS sous_titre_3,
  p0_.image AS image_4,
  p0_.keywords AS keywords_5,
  p0_.ordre AS ordre_6,
  p0_.actif AS actif_7,
  p0_.description AS description_8,
  p0_.description_courte AS description_courte_9,
  p0_.description_fin AS description_fin_10,
  p0_.icon AS icon_11,
  p0_.date_creation AS date_creation_12,
  p0_.date_modification AS date_modification_13,
  p0_.meta_description AS meta_description_14,
  p0_.id_import AS id_import_15,
  p0_.id_import_page_liee AS id_import_page_liee_16,
  p0_.niveau AS niveau_17,
  p0_.permalink AS permalink_18,
  p0_.parent_id AS parent_id_19,
  p0_.projet_id AS projet_id_20,
  p0_.formulaire_id AS formulaire_id_21,
  p0_.combi_id AS combi_id_22
FROM
  page p0_
WHERE
  p0_.projet_id = ?
  AND p0_.id IN (?)
ORDER BY
  p0_.parent_id ASC,
  p0_.ordre ASC

SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.titre_nav AS titre_nav_2, p0_.sous_titre AS sous_titre_3, p0_.image AS image_4, p0_.keywords AS keywords_5, p0_.ordre AS ordre_6, p0_.actif AS actif_7, p0_.description AS description_8, p0_.description_courte AS description_courte_9, p0_.description_fin AS description_fin_10, p0_.icon AS icon_11, p0_.date_creation AS date_creation_12, p0_.date_modification AS date_modification_13, p0_.meta_description AS meta_description_14, p0_.id_import AS id_import_15, p0_.id_import_page_liee AS id_import_page_liee_16, p0_.niveau AS niveau_17, p0_.permalink AS permalink_18, p0_.parent_id AS parent_id_19, p0_.projet_id AS projet_id_20, p0_.formulaire_id AS formulaire_id_21, p0_.combi_id AS combi_id_22 FROM page p0_ WHERE p0_.projet_id = 21 AND p0_.id IN (2882, 2883, 2884, 2885, 2886, 2887, 2888, 2889, 2890, 2893, 2895, 2897, 2899, 2902, 2903, 2904, 2905, 2913, 2914, 2906, 2907, 2909, 2910, 2900, 2901, 2912, 2892, 2908, 2911, 2891, 2915, 2894, 2896, 2898, 2916, 2917) ORDER BY p0_.parent_id ASC, p0_.ordre ASC;

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 = ?

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 = 18;

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 = ?

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 = 69;

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

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 = 21 LIMIT 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 = ?

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 = 21;

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 = ?

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 = 23;

SELECT
  DISTINCT p0_.id AS id_0,
  p0_.parent_id AS sclr_1,
  p0_.ordre AS ordre_2
FROM
  page p0_
WHERE
  p0_.projet_id = ?
ORDER BY
  p0_.parent_id ASC,
  p0_.ordre ASC
LIMIT
  100000

SELECT DISTINCT p0_.id AS id_0, p0_.parent_id AS sclr_1, p0_.ordre AS ordre_2 FROM page p0_ WHERE p0_.projet_id = 21 ORDER BY p0_.parent_id ASC, p0_.ordre ASC LIMIT 100000;

SELECT
  count(p0_.id) AS sclr_0
FROM
  page p0_
WHERE
  p0_.projet_id = ?

SELECT count(p0_.id) AS sclr_0 FROM page p0_ WHERE p0_.projet_id = 21;