Symfony Profiler

SELECT
  m0_.id AS id_0,
  m0_.thumb AS thumb_1,
  m0_.name AS name_2,
  m0_.slug AS slug_3,
  m0_.color AS color_4,
  m0_.type AS type_5,
  m0_.externallink AS externallink_6,
  m0_.rang AS rang_7,
  m0_.parentid AS parentid_8,
  m0_.is_accordiant AS is_accordiant_9,
  m0_.subjectid AS subjectid_10,
  m0_.ispublish AS ispublish_11,
  m0_.widgetId AS widgetId_12
FROM
  menuitems m0_
WHERE
  m0_.id = ?
LIMIT
  1

SELECT m0_.id AS id_0, m0_.thumb AS thumb_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.color AS color_4, m0_.type AS type_5, m0_.externallink AS externallink_6, m0_.rang AS rang_7, m0_.parentid AS parentid_8, m0_.is_accordiant AS is_accordiant_9, m0_.subjectid AS subjectid_10, m0_.ispublish AS ispublish_11, m0_.widgetId AS widgetId_12 FROM menuitems m0_ WHERE m0_.id = 6 LIMIT 1;

SELECT
  u0_.picture AS picture_0,
  u0_.nom AS nom_1,
  u0_.isemailvalidated AS isemailvalidated_2,
  u0_.objectifpersonnel AS objectifpersonnel_3,
  u0_.prenom AS prenom_4,
  u0_.typenumerotel AS typenumerotel_5,
  u0_.numerotel AS numerotel_6,
  u0_.teladresseusers AS teladresseusers_7,
  u0_.tel AS tel_8,
  u0_.portable AS portable_9,
  u0_.orderlistcontact AS orderlistcontact_10,
  u0_.username AS username_11,
  u0_.username_canonical AS username_canonical_12,
  u0_.email_canonical AS email_canonical_13,
  u0_.enabled AS enabled_14,
  u0_.salt AS salt_15,
  u0_.last_login AS last_login_16,
  u0_.confirmation_token AS confirmation_token_17,
  u0_.password_requested_at AS password_requested_at_18,
  u0_.reset_token AS reset_token_19,
  u0_.id AS id_20,
  u0_.email AS email_21,
  u0_.roles AS roles_22,
  u0_.password AS password_23,
  u0_.civility AS civility_24,
  u0_.civilstate AS civilstate_25,
  u0_.adresse AS adresse_26,
  u0_.adresse2 AS adresse2_27,
  u0_.adresseregion AS adresseregion_28,
  u0_.locomotion AS locomotion_29,
  u0_.locomotiontype AS locomotiontype_30,
  u0_.site AS site_31,
  u0_.datedenaissance AS datedenaissance_32,
  u0_.cp AS cp_33,
  u0_.website AS website_34,
  u0_.created AS created_35,
  u0_.updated AS updated_36,
  u0_.isdisponible AS isdisponible_37,
  u0_.disponibleaftermonth AS disponibleaftermonth_38,
  u0_.permisconduiteb AS permisconduiteb_39,
  u0_.loisir AS loisir_40,
  u0_.lng AS lng_41,
  u0_.lat AS lat_42,
  u0_.maxdistancework AS maxdistancework_43,
  u0_.googleadresse AS googleadresse_44,
  u0_.regionlibre AS regionlibre_45,
  u0_.codeuser AS codeuser_46,
  u0_.iscitiexist AS iscitiexist_47,
  u0_.tauxoccupation AS tauxoccupation_48,
  u0_.wanted_salary_type AS wanted_salary_type_49,
  u0_.tauxoccupationfrom AS tauxoccupationfrom_50,
  u0_.tauxoccupationto AS tauxoccupationto_51,
  u0_.salary AS salary_52,
  u0_.salary_month_number AS salary_month_number_53,
  u0_.partialtimeslap AS partialtimeslap_54,
  u0_.textmotivation AS textmotivation_55,
  u0_.classedby AS classedby_56,
  u0_.evaluateby AS evaluateby_57,
  u0_.isincontactlist AS isincontactlist_58,
  u0_.fonction AS fonction_59,
  u0_.candidate_evaluate AS candidate_evaluate_60,
  u0_.evaluatedby AS evaluatedby_61,
  u0_.disponibility_persentage AS disponibility_persentage_62,
  u0_.profile_complete_percentage AS profile_complete_percentage_63,
  u0_.is_from_ga AS is_from_ga_64,
  u0_.google_token AS google_token_65,
  u0_.cooptation_code_value AS cooptation_code_value_66,
  u0_.profile_views AS profile_views_67,
  u0_.is_imported AS is_imported_68
FROM
  user u0_
WHERE
  (
    u0_.roles LIKE '%ROLE_SUPER_ADMIN%'
    OR u0_.roles LIKE '%ROLE_ADMIN%'
    OR u0_.roles LIKE '%ROLE_AUTEUR%'
    OR u0_.roles LIKE '%ROLE_ADVANCED_RECRUITER%'
    OR u0_.roles LIKE '%ROLE_RECRUITER%'
  )
  AND u0_.isincontactlist = ?
ORDER BY
  u0_.orderlistcontact ASC

SELECT u0_.picture AS picture_0, u0_.nom AS nom_1, u0_.isemailvalidated AS isemailvalidated_2, u0_.objectifpersonnel AS objectifpersonnel_3, u0_.prenom AS prenom_4, u0_.typenumerotel AS typenumerotel_5, u0_.numerotel AS numerotel_6, u0_.teladresseusers AS teladresseusers_7, u0_.tel AS tel_8, u0_.portable AS portable_9, u0_.orderlistcontact AS orderlistcontact_10, u0_.username AS username_11, u0_.username_canonical AS username_canonical_12, u0_.email_canonical AS email_canonical_13, u0_.enabled AS enabled_14, u0_.salt AS salt_15, u0_.last_login AS last_login_16, u0_.confirmation_token AS confirmation_token_17, u0_.password_requested_at AS password_requested_at_18, u0_.reset_token AS reset_token_19, u0_.id AS id_20, u0_.email AS email_21, u0_.roles AS roles_22, u0_.password AS password_23, u0_.civility AS civility_24, u0_.civilstate AS civilstate_25, u0_.adresse AS adresse_26, u0_.adresse2 AS adresse2_27, u0_.adresseregion AS adresseregion_28, u0_.locomotion AS locomotion_29, u0_.locomotiontype AS locomotiontype_30, u0_.site AS site_31, u0_.datedenaissance AS datedenaissance_32, u0_.cp AS cp_33, u0_.website AS website_34, u0_.created AS created_35, u0_.updated AS updated_36, u0_.isdisponible AS isdisponible_37, u0_.disponibleaftermonth AS disponibleaftermonth_38, u0_.permisconduiteb AS permisconduiteb_39, u0_.loisir AS loisir_40, u0_.lng AS lng_41, u0_.lat AS lat_42, u0_.maxdistancework AS maxdistancework_43, u0_.googleadresse AS googleadresse_44, u0_.regionlibre AS regionlibre_45, u0_.codeuser AS codeuser_46, u0_.iscitiexist AS iscitiexist_47, u0_.tauxoccupation AS tauxoccupation_48, u0_.wanted_salary_type AS wanted_salary_type_49, u0_.tauxoccupationfrom AS tauxoccupationfrom_50, u0_.tauxoccupationto AS tauxoccupationto_51, u0_.salary AS salary_52, u0_.salary_month_number AS salary_month_number_53, u0_.partialtimeslap AS partialtimeslap_54, u0_.textmotivation AS textmotivation_55, u0_.classedby AS classedby_56, u0_.evaluateby AS evaluateby_57, u0_.isincontactlist AS isincontactlist_58, u0_.fonction AS fonction_59, u0_.candidate_evaluate AS candidate_evaluate_60, u0_.evaluatedby AS evaluatedby_61, u0_.disponibility_persentage AS disponibility_persentage_62, u0_.profile_complete_percentage AS profile_complete_percentage_63, u0_.is_from_ga AS is_from_ga_64, u0_.google_token AS google_token_65, u0_.cooptation_code_value AS cooptation_code_value_66, u0_.profile_views AS profile_views_67, u0_.is_imported AS is_imported_68 FROM user u0_ WHERE (u0_.roles LIKE '%ROLE_SUPER_ADMIN%' OR u0_.roles LIKE '%ROLE_ADMIN%' OR u0_.roles LIKE '%ROLE_AUTEUR%' OR u0_.roles LIKE '%ROLE_ADVANCED_RECRUITER%' OR u0_.roles LIKE '%ROLE_RECRUITER%') AND u0_.isincontactlist = 1 ORDER BY u0_.orderlistcontact ASC;

SELECT
  m0_.id AS id_0,
  m0_.thumb AS thumb_1,
  m0_.name AS name_2,
  m0_.slug AS slug_3,
  m0_.color AS color_4,
  m0_.type AS type_5,
  m0_.externallink AS externallink_6,
  m0_.rang AS rang_7,
  m0_.parentid AS parentid_8,
  m0_.is_accordiant AS is_accordiant_9,
  m0_.subjectid AS subjectid_10,
  m0_.ispublish AS ispublish_11,
  m0_.widgetId AS widgetId_12,
  m1_.id AS id_13,
  m1_.title AS title_14,
  m1_.position AS position_15,
  m1_.ispublish AS ispublish_16,
  m1_.rang AS rang_17,
  m0_.menus_id AS menus_id_18
FROM
  menuitems m0_
  INNER JOIN menus m1_ ON m0_.menus_id = m1_.id
WHERE
  m0_.parentid = ?
  AND m1_.id = ?
  AND m0_.ispublish = ?
  AND (
    m0_.is_accordiant IS NULL
    OR m0_.is_accordiant = 0
  )
ORDER BY
  m0_.rang ASC

SELECT m0_.id AS id_0, m0_.thumb AS thumb_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.color AS color_4, m0_.type AS type_5, m0_.externallink AS externallink_6, m0_.rang AS rang_7, m0_.parentid AS parentid_8, m0_.is_accordiant AS is_accordiant_9, m0_.subjectid AS subjectid_10, m0_.ispublish AS ispublish_11, m0_.widgetId AS widgetId_12, m1_.id AS id_13, m1_.title AS title_14, m1_.position AS position_15, m1_.ispublish AS ispublish_16, m1_.rang AS rang_17, m0_.menus_id AS menus_id_18 FROM menuitems m0_ INNER JOIN menus m1_ ON m0_.menus_id = m1_.id WHERE m0_.parentid = 5 AND m1_.id = 226 AND m0_.ispublish = 1 AND (m0_.is_accordiant IS NULL OR m0_.is_accordiant = 0) ORDER BY m0_.rang ASC;

SELECT
  m0_.id AS id_0,
  m0_.objectid AS objectid_1,
  m0_.modulename AS modulename_2,
  m0_.isfuture AS isfuture_3,
  m0_.ordernumber AS ordernumber_4,
  m0_.created AS created_5,
  m0_.updated AS updated_6,
  m1_.id AS id_7,
  m1_.name AS name_8,
  m1_.imagedescription AS imagedescription_9,
  m1_.picturename AS picturename_10,
  m1_.picturenamewebp AS picturenamewebp_11,
  m1_.thumbname AS thumbname_12,
  m1_.thumbnamewebp AS thumbnamewebp_13,
  m1_.picturesize AS picturesize_14,
  m1_.picturetype AS picturetype_15,
  m1_.picturetypewebp AS picturetypewebp_16,
  m1_.folderpath AS folderpath_17,
  m1_.path AS path_18,
  m1_.widget AS widget_19,
  m1_.actus AS actus_20,
  m1_.title AS title_21,
  m1_.description AS description_22,
  m1_.created AS created_23
FROM
  mediapages m0_
  INNER JOIN media m1_ ON m0_.media_id = m1_.id
WHERE
  m0_.objectid IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
  AND m0_.modulename = ?

SELECT m0_.id AS id_0, m0_.objectid AS objectid_1, m0_.modulename AS modulename_2, m0_.isfuture AS isfuture_3, m0_.ordernumber AS ordernumber_4, m0_.created AS created_5, m0_.updated AS updated_6, m1_.id AS id_7, m1_.name AS name_8, m1_.imagedescription AS imagedescription_9, m1_.picturename AS picturename_10, m1_.picturenamewebp AS picturenamewebp_11, m1_.thumbname AS thumbname_12, m1_.thumbnamewebp AS thumbnamewebp_13, m1_.picturesize AS picturesize_14, m1_.picturetype AS picturetype_15, m1_.picturetypewebp AS picturetypewebp_16, m1_.folderpath AS folderpath_17, m1_.path AS path_18, m1_.widget AS widget_19, m1_.actus AS actus_20, m1_.title AS title_21, m1_.description AS description_22, m1_.created AS created_23 FROM mediapages m0_ INNER JOIN media m1_ ON m0_.media_id = m1_.id WHERE m0_.objectid IN (286, 12796, 656, 9772, 16292, 12798, 295, 2444, 2443, 11056, 2035, 16011, 291, 16003, 15643, 11991, 16236, 16002, 13407, 591, 16001, 13379, 2442, 14973, 608, 12367, 289, 388, 13046) AND m0_.modulename = 'USERS';

SELECT
  s0_.id AS id_0,
  s0_.groupname AS groupname_1,
  s0_.grouplibeller AS grouplibeller_2,
  s0_.libeller AS libeller_3,
  s0_.name AS name_4,
  s0_.fieldtype AS fieldtype_5,
  s0_.helptext AS helptext_6,
  s0_.settingvalue AS settingvalue_7,
  s0_.witheditor AS witheditor_8,
  s0_.ordre AS ordre_9,
  s0_.created AS created_10,
  s0_.updated AS updated_11
FROM
  settingsite s0_
WHERE
  s0_.groupname IN (?)
ORDER BY
  s0_.ordre ASC

SELECT s0_.id AS id_0, s0_.groupname AS groupname_1, s0_.grouplibeller AS grouplibeller_2, s0_.libeller AS libeller_3, s0_.name AS name_4, s0_.fieldtype AS fieldtype_5, s0_.helptext AS helptext_6, s0_.settingvalue AS settingvalue_7, s0_.witheditor AS witheditor_8, s0_.ordre AS ordre_9, s0_.created AS created_10, s0_.updated AS updated_11 FROM settingsite s0_ WHERE s0_.groupname IN ('homepage') ORDER BY s0_.ordre ASC;

SELECT
  m0_.id AS id_0,
  m0_.thumb AS thumb_1,
  m0_.name AS name_2,
  m0_.slug AS slug_3,
  m0_.color AS color_4,
  m0_.type AS type_5,
  m0_.externallink AS externallink_6,
  m0_.rang AS rang_7,
  m0_.parentid AS parentid_8,
  m0_.is_accordiant AS is_accordiant_9,
  m0_.subjectid AS subjectid_10,
  m0_.ispublish AS ispublish_11,
  m0_.widgetId AS widgetId_12,
  m1_.id AS id_13,
  m1_.title AS title_14,
  m1_.position AS position_15,
  m1_.ispublish AS ispublish_16,
  m1_.rang AS rang_17,
  m0_.menus_id AS menus_id_18
FROM
  menuitems m0_
  INNER JOIN menus m1_ ON m0_.menus_id = m1_.id
WHERE
  (
    m0_.parentid IS NULL
    OR m0_.parentid = ?
  )
  AND m1_.id = ?
  AND m0_.ispublish = ?
  AND (
    m0_.is_accordiant IS NULL
    OR m0_.is_accordiant = 0
  )
ORDER BY
  m0_.rang ASC

SELECT m0_.id AS id_0, m0_.thumb AS thumb_1, m0_.name AS name_2, m0_.slug AS slug_3, m0_.color AS color_4, m0_.type AS type_5, m0_.externallink AS externallink_6, m0_.rang AS rang_7, m0_.parentid AS parentid_8, m0_.is_accordiant AS is_accordiant_9, m0_.subjectid AS subjectid_10, m0_.ispublish AS ispublish_11, m0_.widgetId AS widgetId_12, m1_.id AS id_13, m1_.title AS title_14, m1_.position AS position_15, m1_.ispublish AS ispublish_16, m1_.rang AS rang_17, m0_.menus_id AS menus_id_18 FROM menuitems m0_ INNER JOIN menus m1_ ON m0_.menus_id = m1_.id WHERE (m0_.parentid IS NULL OR m0_.parentid = 0) AND m1_.id = 226 AND m0_.ispublish = 1 AND (m0_.is_accordiant IS NULL OR m0_.is_accordiant = 0) ORDER BY m0_.rang ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.position AS position_3,
  t0.ispublish AS ispublish_4,
  t0.rang AS rang_5
FROM
  menus t0
WHERE
  t0.position = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.position AS position_3, t0.ispublish AS ispublish_4, t0.rang AS rang_5 FROM menus t0 WHERE t0.position = 'MAIN' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.telephones AS telephones_2,
  t0.adresse AS adresse_3,
  t0.title AS title_4,
  t0.urlmap AS urlmap_5,
  t0.email AS email_6,
  t0.orderlist AS orderlist_7,
  t0.ispublic AS ispublic_8
FROM
  siteadressesmaps t0
WHERE
  t0.ispublic = ?
ORDER BY
  t0.orderlist ASC

SELECT t0.id AS id_1, t0.telephones AS telephones_2, t0.adresse AS adresse_3, t0.title AS title_4, t0.urlmap AS urlmap_5, t0.email AS email_6, t0.orderlist AS orderlist_7, t0.ispublic AS ispublic_8 FROM siteadressesmaps t0 WHERE t0.ispublic = 1 ORDER BY t0.orderlist ASC;