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
  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 = ?
  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 = 45 AND m0_.modulename = 'SETTINGSITE';

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 ('jobsetting') 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
  o0_.id AS id_0,
  o0_.title AS title_1,
  o0_.refinterne AS refinterne_2,
  o0_.newscoreaffect AS newscoreaffect_3,
  o0_.nbrvisite AS nbrvisite_4,
  o0_.ispublish AS ispublish_5,
  o0_.publishdate AS publishdate_6,
  o0_.expiration_date AS expiration_date_7,
  o0_.datebeginwork AS datebeginwork_8,
  o0_.usemainlogo AS usemainlogo_9,
  o0_.logo AS logo_10,
  o0_.emailpost AS emailpost_11,
  o0_.telpost AS telpost_12,
  o0_.introduction AS introduction_13,
  o0_.titlepostaffichage AS titlepostaffichage_14,
  o0_.description AS description_15,
  o0_.duresanonces AS duresanonces_16,
  o0_.tauxactvity AS tauxactvity_17,
  o0_.tauxactvityfrom AS tauxactvityfrom_18,
  o0_.tauxactvityto AS tauxactvityto_19,
  o0_.displaymentionlegaleagenceplacement AS displaymentionlegaleagenceplacement_20,
  o0_.sendautoresponsetonotqualificationcondidate AS sendautoresponsetonotqualificationcondidate_21,
  o0_.sendnotifpermail AS sendnotifpermail_22,
  o0_.receivealertemailexpiration AS receivealertemailexpiration_23,
  o0_.display_coordonnee_adresse AS display_coordonnee_adresse_24,
  o0_.display_coordonnee_tel AS display_coordonnee_tel_25,
  o0_.display_coordonnee_site AS display_coordonnee_site_26,
  o0_.display_coordonnee_mail AS display_coordonnee_mail_27,
  o0_.activatecandidatureenligne AS activatecandidatureenligne_28,
  o0_.displayonlycontons AS displayonlycontons_29,
  o0_.type_notification_postulation AS type_notification_postulation_30,
  o0_.coordonneeaffichersurannonce AS coordonneeaffichersurannonce_31,
  o0_.newscorequestions AS newscorequestions_32,
  o0_.created AS created_33,
  o0_.updated AS updated_34,
  o0_.isdeleted AS isdeleted_35,
  o0_.author AS author_36,
  o0_.seotitle AS seotitle_37,
  o0_.seodescription AS seodescription_38,
  o0_.seokeywords AS seokeywords_39,
  o0_.localiteafficher AS localiteafficher_40,
  u1_.picture AS picture_41,
  u1_.nom AS nom_42,
  u1_.isemailvalidated AS isemailvalidated_43,
  u1_.objectifpersonnel AS objectifpersonnel_44,
  u1_.prenom AS prenom_45,
  u1_.typenumerotel AS typenumerotel_46,
  u1_.numerotel AS numerotel_47,
  u1_.teladresseusers AS teladresseusers_48,
  u1_.tel AS tel_49,
  u1_.portable AS portable_50,
  u1_.orderlistcontact AS orderlistcontact_51,
  u1_.username AS username_52,
  u1_.username_canonical AS username_canonical_53,
  u1_.email_canonical AS email_canonical_54,
  u1_.enabled AS enabled_55,
  u1_.salt AS salt_56,
  u1_.last_login AS last_login_57,
  u1_.confirmation_token AS confirmation_token_58,
  u1_.password_requested_at AS password_requested_at_59,
  u1_.reset_token AS reset_token_60,
  u1_.id AS id_61,
  u1_.email AS email_62,
  u1_.roles AS roles_63,
  u1_.password AS password_64,
  u1_.civility AS civility_65,
  u1_.civilstate AS civilstate_66,
  u1_.adresse AS adresse_67,
  u1_.adresse2 AS adresse2_68,
  u1_.adresseregion AS adresseregion_69,
  u1_.locomotion AS locomotion_70,
  u1_.locomotiontype AS locomotiontype_71,
  u1_.site AS site_72,
  u1_.datedenaissance AS datedenaissance_73,
  u1_.cp AS cp_74,
  u1_.website AS website_75,
  u1_.created AS created_76,
  u1_.updated AS updated_77,
  u1_.isdisponible AS isdisponible_78,
  u1_.disponibleaftermonth AS disponibleaftermonth_79,
  u1_.permisconduiteb AS permisconduiteb_80,
  u1_.loisir AS loisir_81,
  u1_.lng AS lng_82,
  u1_.lat AS lat_83,
  u1_.maxdistancework AS maxdistancework_84,
  u1_.googleadresse AS googleadresse_85,
  u1_.regionlibre AS regionlibre_86,
  u1_.codeuser AS codeuser_87,
  u1_.iscitiexist AS iscitiexist_88,
  u1_.tauxoccupation AS tauxoccupation_89,
  u1_.wanted_salary_type AS wanted_salary_type_90,
  u1_.tauxoccupationfrom AS tauxoccupationfrom_91,
  u1_.tauxoccupationto AS tauxoccupationto_92,
  u1_.salary AS salary_93,
  u1_.salary_month_number AS salary_month_number_94,
  u1_.partialtimeslap AS partialtimeslap_95,
  u1_.textmotivation AS textmotivation_96,
  u1_.classedby AS classedby_97,
  u1_.evaluateby AS evaluateby_98,
  u1_.isincontactlist AS isincontactlist_99,
  u1_.fonction AS fonction_100,
  u1_.candidate_evaluate AS candidate_evaluate_101,
  u1_.evaluatedby AS evaluatedby_102,
  u1_.disponibility_persentage AS disponibility_persentage_103,
  u1_.profile_complete_percentage AS profile_complete_percentage_104,
  u1_.is_from_ga AS is_from_ga_105,
  u1_.google_token AS google_token_106,
  u1_.cooptation_code_value AS cooptation_code_value_107,
  u1_.profile_views AS profile_views_108,
  u1_.is_imported AS is_imported_109,
  c2_.id AS id_110,
  c2_.name AS name_111,
  c2_.parentid AS parentid_112,
  c2_.isdeleted AS isdeleted_113,
  c2_.ispublish AS ispublish_114,
  c2_.orderlist AS orderlist_115,
  c2_.isexcluded AS isexcluded_116,
  o3_.id AS id_117,
  o3_.name AS name_118,
  o3_.created AS created_119,
  o3_.updated AS updated_120,
  c4_.id AS id_121,
  c4_.name AS name_122,
  q5_.id AS id_123,
  q5_.name AS name_124,
  q5_.slug AS slug_125,
  q5_.indexord AS indexord_126,
  q5_.scoreval AS scoreval_127,
  q5_.maxscore AS maxscore_128,
  q5_.iseliminable AS iseliminable_129,
  q5_.type AS type_130,
  q5_.suppclass AS suppclass_131,
  q5_.helpbloc AS helpbloc_132,
  q5_.placeholder AS placeholder_133,
  q5_.suggestions AS suggestions_134,
  q5_.ispublic AS ispublic_135,
  q5_.created AS created_136,
  q5_.updated AS updated_137,
  q5_.parentid AS parentid_138,
  o0_.contracttypes_id AS contracttypes_id_139,
  o0_.supplimentcriterias_id AS supplimentcriterias_id_140,
  o0_.user_id AS user_id_141,
  o0_.personnecontacts_id AS personnecontacts_id_142,
  o0_.pays_id AS pays_id_143,
  o0_.regions_id AS regions_id_144,
  o0_.localites_id AS localites_id_145,
  o0_.offresemploistatus_id AS offresemploistatus_id_146,
  u1_.candidate_classementlist_id AS candidate_classementlist_id_147,
  u1_.notice_period_id AS notice_period_id_148,
  u1_.civilstates_id AS civilstates_id_149,
  u1_.deleted_by AS deleted_by_150,
  u1_.nationnalite_id AS nationnalite_id_151,
  u1_.adressepays_id AS adressepays_id_152,
  u1_.cities_id AS cities_id_153,
  u1_.states_id AS states_id_154,
  u1_.permistravails_id AS permistravails_id_155,
  u1_.candidateevaluatelist_id AS candidateevaluatelist_id_156,
  u1_.cooptation_code AS cooptation_code_157,
  o3_.offresemplois_id AS offresemplois_id_158
FROM
  offresemplois o0_
  LEFT JOIN user u1_ ON o0_.personnecontacts_id = u1_.id
  LEFT JOIN offreemploi_categories o6_ ON o0_.id = o6_.offresemplois_id
  LEFT JOIN categorieemplois c2_ ON c2_.id = o6_.categorieemplois_id
  LEFT JOIN offresemploisqualifications o3_ ON o0_.id = o3_.offresemplois_id
  LEFT JOIN contracttypes c4_ ON o0_.contracttypes_id = c4_.id
  LEFT JOIN offreemplois_questionsposts o7_ ON o0_.id = o7_.offresemplois_id
  LEFT JOIN questionsposts q5_ ON q5_.id = o7_.questionsposts_id
WHERE
  o0_.id = ?

SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.refinterne AS refinterne_2, o0_.newscoreaffect AS newscoreaffect_3, o0_.nbrvisite AS nbrvisite_4, o0_.ispublish AS ispublish_5, o0_.publishdate AS publishdate_6, o0_.expiration_date AS expiration_date_7, o0_.datebeginwork AS datebeginwork_8, o0_.usemainlogo AS usemainlogo_9, o0_.logo AS logo_10, o0_.emailpost AS emailpost_11, o0_.telpost AS telpost_12, o0_.introduction AS introduction_13, o0_.titlepostaffichage AS titlepostaffichage_14, o0_.description AS description_15, o0_.duresanonces AS duresanonces_16, o0_.tauxactvity AS tauxactvity_17, o0_.tauxactvityfrom AS tauxactvityfrom_18, o0_.tauxactvityto AS tauxactvityto_19, o0_.displaymentionlegaleagenceplacement AS displaymentionlegaleagenceplacement_20, o0_.sendautoresponsetonotqualificationcondidate AS sendautoresponsetonotqualificationcondidate_21, o0_.sendnotifpermail AS sendnotifpermail_22, o0_.receivealertemailexpiration AS receivealertemailexpiration_23, o0_.display_coordonnee_adresse AS display_coordonnee_adresse_24, o0_.display_coordonnee_tel AS display_coordonnee_tel_25, o0_.display_coordonnee_site AS display_coordonnee_site_26, o0_.display_coordonnee_mail AS display_coordonnee_mail_27, o0_.activatecandidatureenligne AS activatecandidatureenligne_28, o0_.displayonlycontons AS displayonlycontons_29, o0_.type_notification_postulation AS type_notification_postulation_30, o0_.coordonneeaffichersurannonce AS coordonneeaffichersurannonce_31, o0_.newscorequestions AS newscorequestions_32, o0_.created AS created_33, o0_.updated AS updated_34, o0_.isdeleted AS isdeleted_35, o0_.author AS author_36, o0_.seotitle AS seotitle_37, o0_.seodescription AS seodescription_38, o0_.seokeywords AS seokeywords_39, o0_.localiteafficher AS localiteafficher_40, u1_.picture AS picture_41, u1_.nom AS nom_42, u1_.isemailvalidated AS isemailvalidated_43, u1_.objectifpersonnel AS objectifpersonnel_44, u1_.prenom AS prenom_45, u1_.typenumerotel AS typenumerotel_46, u1_.numerotel AS numerotel_47, u1_.teladresseusers AS teladresseusers_48, u1_.tel AS tel_49, u1_.portable AS portable_50, u1_.orderlistcontact AS orderlistcontact_51, u1_.username AS username_52, u1_.username_canonical AS username_canonical_53, u1_.email_canonical AS email_canonical_54, u1_.enabled AS enabled_55, u1_.salt AS salt_56, u1_.last_login AS last_login_57, u1_.confirmation_token AS confirmation_token_58, u1_.password_requested_at AS password_requested_at_59, u1_.reset_token AS reset_token_60, u1_.id AS id_61, u1_.email AS email_62, u1_.roles AS roles_63, u1_.password AS password_64, u1_.civility AS civility_65, u1_.civilstate AS civilstate_66, u1_.adresse AS adresse_67, u1_.adresse2 AS adresse2_68, u1_.adresseregion AS adresseregion_69, u1_.locomotion AS locomotion_70, u1_.locomotiontype AS locomotiontype_71, u1_.site AS site_72, u1_.datedenaissance AS datedenaissance_73, u1_.cp AS cp_74, u1_.website AS website_75, u1_.created AS created_76, u1_.updated AS updated_77, u1_.isdisponible AS isdisponible_78, u1_.disponibleaftermonth AS disponibleaftermonth_79, u1_.permisconduiteb AS permisconduiteb_80, u1_.loisir AS loisir_81, u1_.lng AS lng_82, u1_.lat AS lat_83, u1_.maxdistancework AS maxdistancework_84, u1_.googleadresse AS googleadresse_85, u1_.regionlibre AS regionlibre_86, u1_.codeuser AS codeuser_87, u1_.iscitiexist AS iscitiexist_88, u1_.tauxoccupation AS tauxoccupation_89, u1_.wanted_salary_type AS wanted_salary_type_90, u1_.tauxoccupationfrom AS tauxoccupationfrom_91, u1_.tauxoccupationto AS tauxoccupationto_92, u1_.salary AS salary_93, u1_.salary_month_number AS salary_month_number_94, u1_.partialtimeslap AS partialtimeslap_95, u1_.textmotivation AS textmotivation_96, u1_.classedby AS classedby_97, u1_.evaluateby AS evaluateby_98, u1_.isincontactlist AS isincontactlist_99, u1_.fonction AS fonction_100, u1_.candidate_evaluate AS candidate_evaluate_101, u1_.evaluatedby AS evaluatedby_102, u1_.disponibility_persentage AS disponibility_persentage_103, u1_.profile_complete_percentage AS profile_complete_percentage_104, u1_.is_from_ga AS is_from_ga_105, u1_.google_token AS google_token_106, u1_.cooptation_code_value AS cooptation_code_value_107, u1_.profile_views AS profile_views_108, u1_.is_imported AS is_imported_109, c2_.id AS id_110, c2_.name AS name_111, c2_.parentid AS parentid_112, c2_.isdeleted AS isdeleted_113, c2_.ispublish AS ispublish_114, c2_.orderlist AS orderlist_115, c2_.isexcluded AS isexcluded_116, o3_.id AS id_117, o3_.name AS name_118, o3_.created AS created_119, o3_.updated AS updated_120, c4_.id AS id_121, c4_.name AS name_122, q5_.id AS id_123, q5_.name AS name_124, q5_.slug AS slug_125, q5_.indexord AS indexord_126, q5_.scoreval AS scoreval_127, q5_.maxscore AS maxscore_128, q5_.iseliminable AS iseliminable_129, q5_.type AS type_130, q5_.suppclass AS suppclass_131, q5_.helpbloc AS helpbloc_132, q5_.placeholder AS placeholder_133, q5_.suggestions AS suggestions_134, q5_.ispublic AS ispublic_135, q5_.created AS created_136, q5_.updated AS updated_137, q5_.parentid AS parentid_138, o0_.contracttypes_id AS contracttypes_id_139, o0_.supplimentcriterias_id AS supplimentcriterias_id_140, o0_.user_id AS user_id_141, o0_.personnecontacts_id AS personnecontacts_id_142, o0_.pays_id AS pays_id_143, o0_.regions_id AS regions_id_144, o0_.localites_id AS localites_id_145, o0_.offresemploistatus_id AS offresemploistatus_id_146, u1_.candidate_classementlist_id AS candidate_classementlist_id_147, u1_.notice_period_id AS notice_period_id_148, u1_.civilstates_id AS civilstates_id_149, u1_.deleted_by AS deleted_by_150, u1_.nationnalite_id AS nationnalite_id_151, u1_.adressepays_id AS adressepays_id_152, u1_.cities_id AS cities_id_153, u1_.states_id AS states_id_154, u1_.permistravails_id AS permistravails_id_155, u1_.candidateevaluatelist_id AS candidateevaluatelist_id_156, u1_.cooptation_code AS cooptation_code_157, o3_.offresemplois_id AS offresemplois_id_158 FROM offresemplois o0_ LEFT JOIN user u1_ ON o0_.personnecontacts_id = u1_.id LEFT JOIN offreemploi_categories o6_ ON o0_.id = o6_.offresemplois_id LEFT JOIN categorieemplois c2_ ON c2_.id = o6_.categorieemplois_id LEFT JOIN offresemploisqualifications o3_ ON o0_.id = o3_.offresemplois_id LEFT JOIN contracttypes c4_ ON o0_.contracttypes_id = c4_.id LEFT JOIN offreemplois_questionsposts o7_ ON o0_.id = o7_.offresemplois_id LEFT JOIN questionsposts q5_ ON q5_.id = o7_.questionsposts_id WHERE o0_.id = 206;

SELECT
  o0_.id AS id_0,
  o0_.title AS title_1,
  o0_.refinterne AS refinterne_2,
  o0_.newscoreaffect AS newscoreaffect_3,
  o0_.nbrvisite AS nbrvisite_4,
  o0_.ispublish AS ispublish_5,
  o0_.publishdate AS publishdate_6,
  o0_.expiration_date AS expiration_date_7,
  o0_.datebeginwork AS datebeginwork_8,
  o0_.usemainlogo AS usemainlogo_9,
  o0_.logo AS logo_10,
  o0_.emailpost AS emailpost_11,
  o0_.telpost AS telpost_12,
  o0_.introduction AS introduction_13,
  o0_.titlepostaffichage AS titlepostaffichage_14,
  o0_.description AS description_15,
  o0_.duresanonces AS duresanonces_16,
  o0_.tauxactvity AS tauxactvity_17,
  o0_.tauxactvityfrom AS tauxactvityfrom_18,
  o0_.tauxactvityto AS tauxactvityto_19,
  o0_.displaymentionlegaleagenceplacement AS displaymentionlegaleagenceplacement_20,
  o0_.sendautoresponsetonotqualificationcondidate AS sendautoresponsetonotqualificationcondidate_21,
  o0_.sendnotifpermail AS sendnotifpermail_22,
  o0_.receivealertemailexpiration AS receivealertemailexpiration_23,
  o0_.display_coordonnee_adresse AS display_coordonnee_adresse_24,
  o0_.display_coordonnee_tel AS display_coordonnee_tel_25,
  o0_.display_coordonnee_site AS display_coordonnee_site_26,
  o0_.display_coordonnee_mail AS display_coordonnee_mail_27,
  o0_.activatecandidatureenligne AS activatecandidatureenligne_28,
  o0_.displayonlycontons AS displayonlycontons_29,
  o0_.type_notification_postulation AS type_notification_postulation_30,
  o0_.coordonneeaffichersurannonce AS coordonneeaffichersurannonce_31,
  o0_.newscorequestions AS newscorequestions_32,
  o0_.created AS created_33,
  o0_.updated AS updated_34,
  o0_.isdeleted AS isdeleted_35,
  o0_.author AS author_36,
  o0_.seotitle AS seotitle_37,
  o0_.seodescription AS seodescription_38,
  o0_.seokeywords AS seokeywords_39,
  o0_.localiteafficher AS localiteafficher_40,
  o1_.id AS id_41,
  o1_.name AS name_42,
  o1_.code AS code_43,
  u2_.picture AS picture_44,
  u2_.nom AS nom_45,
  u2_.isemailvalidated AS isemailvalidated_46,
  u2_.objectifpersonnel AS objectifpersonnel_47,
  u2_.prenom AS prenom_48,
  u2_.typenumerotel AS typenumerotel_49,
  u2_.numerotel AS numerotel_50,
  u2_.teladresseusers AS teladresseusers_51,
  u2_.tel AS tel_52,
  u2_.portable AS portable_53,
  u2_.orderlistcontact AS orderlistcontact_54,
  u2_.username AS username_55,
  u2_.username_canonical AS username_canonical_56,
  u2_.email_canonical AS email_canonical_57,
  u2_.enabled AS enabled_58,
  u2_.salt AS salt_59,
  u2_.last_login AS last_login_60,
  u2_.confirmation_token AS confirmation_token_61,
  u2_.password_requested_at AS password_requested_at_62,
  u2_.reset_token AS reset_token_63,
  u2_.id AS id_64,
  u2_.email AS email_65,
  u2_.roles AS roles_66,
  u2_.password AS password_67,
  u2_.civility AS civility_68,
  u2_.civilstate AS civilstate_69,
  u2_.adresse AS adresse_70,
  u2_.adresse2 AS adresse2_71,
  u2_.adresseregion AS adresseregion_72,
  u2_.locomotion AS locomotion_73,
  u2_.locomotiontype AS locomotiontype_74,
  u2_.site AS site_75,
  u2_.datedenaissance AS datedenaissance_76,
  u2_.cp AS cp_77,
  u2_.website AS website_78,
  u2_.created AS created_79,
  u2_.updated AS updated_80,
  u2_.isdisponible AS isdisponible_81,
  u2_.disponibleaftermonth AS disponibleaftermonth_82,
  u2_.permisconduiteb AS permisconduiteb_83,
  u2_.loisir AS loisir_84,
  u2_.lng AS lng_85,
  u2_.lat AS lat_86,
  u2_.maxdistancework AS maxdistancework_87,
  u2_.googleadresse AS googleadresse_88,
  u2_.regionlibre AS regionlibre_89,
  u2_.codeuser AS codeuser_90,
  u2_.iscitiexist AS iscitiexist_91,
  u2_.tauxoccupation AS tauxoccupation_92,
  u2_.wanted_salary_type AS wanted_salary_type_93,
  u2_.tauxoccupationfrom AS tauxoccupationfrom_94,
  u2_.tauxoccupationto AS tauxoccupationto_95,
  u2_.salary AS salary_96,
  u2_.salary_month_number AS salary_month_number_97,
  u2_.partialtimeslap AS partialtimeslap_98,
  u2_.textmotivation AS textmotivation_99,
  u2_.classedby AS classedby_100,
  u2_.evaluateby AS evaluateby_101,
  u2_.isincontactlist AS isincontactlist_102,
  u2_.fonction AS fonction_103,
  u2_.candidate_evaluate AS candidate_evaluate_104,
  u2_.evaluatedby AS evaluatedby_105,
  u2_.disponibility_persentage AS disponibility_persentage_106,
  u2_.profile_complete_percentage AS profile_complete_percentage_107,
  u2_.is_from_ga AS is_from_ga_108,
  u2_.google_token AS google_token_109,
  u2_.cooptation_code_value AS cooptation_code_value_110,
  u2_.profile_views AS profile_views_111,
  u2_.is_imported AS is_imported_112,
  c3_.id AS id_113,
  c3_.name AS name_114,
  c3_.parentid AS parentid_115,
  c3_.isdeleted AS isdeleted_116,
  c3_.ispublish AS ispublish_117,
  c3_.orderlist AS orderlist_118,
  c3_.isexcluded AS isexcluded_119,
  o4_.id AS id_120,
  o4_.name AS name_121,
  o4_.created AS created_122,
  o4_.updated AS updated_123,
  c5_.id AS id_124,
  c5_.name AS name_125
FROM
  offresemplois o0_
  LEFT JOIN offresemploistatus o1_ ON o0_.offresemploistatus_id = o1_.id
  LEFT JOIN user u2_ ON o0_.personnecontacts_id = u2_.id
  LEFT JOIN offreemploi_categories o6_ ON o0_.id = o6_.offresemplois_id
  LEFT JOIN categorieemplois c3_ ON c3_.id = o6_.categorieemplois_id
  LEFT JOIN offresemploisqualifications o4_ ON o0_.id = o4_.offresemplois_id
  LEFT JOIN contracttypes c5_ ON o0_.contracttypes_id = c5_.id
WHERE
  o0_.id = ?

SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.refinterne AS refinterne_2, o0_.newscoreaffect AS newscoreaffect_3, o0_.nbrvisite AS nbrvisite_4, o0_.ispublish AS ispublish_5, o0_.publishdate AS publishdate_6, o0_.expiration_date AS expiration_date_7, o0_.datebeginwork AS datebeginwork_8, o0_.usemainlogo AS usemainlogo_9, o0_.logo AS logo_10, o0_.emailpost AS emailpost_11, o0_.telpost AS telpost_12, o0_.introduction AS introduction_13, o0_.titlepostaffichage AS titlepostaffichage_14, o0_.description AS description_15, o0_.duresanonces AS duresanonces_16, o0_.tauxactvity AS tauxactvity_17, o0_.tauxactvityfrom AS tauxactvityfrom_18, o0_.tauxactvityto AS tauxactvityto_19, o0_.displaymentionlegaleagenceplacement AS displaymentionlegaleagenceplacement_20, o0_.sendautoresponsetonotqualificationcondidate AS sendautoresponsetonotqualificationcondidate_21, o0_.sendnotifpermail AS sendnotifpermail_22, o0_.receivealertemailexpiration AS receivealertemailexpiration_23, o0_.display_coordonnee_adresse AS display_coordonnee_adresse_24, o0_.display_coordonnee_tel AS display_coordonnee_tel_25, o0_.display_coordonnee_site AS display_coordonnee_site_26, o0_.display_coordonnee_mail AS display_coordonnee_mail_27, o0_.activatecandidatureenligne AS activatecandidatureenligne_28, o0_.displayonlycontons AS displayonlycontons_29, o0_.type_notification_postulation AS type_notification_postulation_30, o0_.coordonneeaffichersurannonce AS coordonneeaffichersurannonce_31, o0_.newscorequestions AS newscorequestions_32, o0_.created AS created_33, o0_.updated AS updated_34, o0_.isdeleted AS isdeleted_35, o0_.author AS author_36, o0_.seotitle AS seotitle_37, o0_.seodescription AS seodescription_38, o0_.seokeywords AS seokeywords_39, o0_.localiteafficher AS localiteafficher_40, o1_.id AS id_41, o1_.name AS name_42, o1_.code AS code_43, u2_.picture AS picture_44, u2_.nom AS nom_45, u2_.isemailvalidated AS isemailvalidated_46, u2_.objectifpersonnel AS objectifpersonnel_47, u2_.prenom AS prenom_48, u2_.typenumerotel AS typenumerotel_49, u2_.numerotel AS numerotel_50, u2_.teladresseusers AS teladresseusers_51, u2_.tel AS tel_52, u2_.portable AS portable_53, u2_.orderlistcontact AS orderlistcontact_54, u2_.username AS username_55, u2_.username_canonical AS username_canonical_56, u2_.email_canonical AS email_canonical_57, u2_.enabled AS enabled_58, u2_.salt AS salt_59, u2_.last_login AS last_login_60, u2_.confirmation_token AS confirmation_token_61, u2_.password_requested_at AS password_requested_at_62, u2_.reset_token AS reset_token_63, u2_.id AS id_64, u2_.email AS email_65, u2_.roles AS roles_66, u2_.password AS password_67, u2_.civility AS civility_68, u2_.civilstate AS civilstate_69, u2_.adresse AS adresse_70, u2_.adresse2 AS adresse2_71, u2_.adresseregion AS adresseregion_72, u2_.locomotion AS locomotion_73, u2_.locomotiontype AS locomotiontype_74, u2_.site AS site_75, u2_.datedenaissance AS datedenaissance_76, u2_.cp AS cp_77, u2_.website AS website_78, u2_.created AS created_79, u2_.updated AS updated_80, u2_.isdisponible AS isdisponible_81, u2_.disponibleaftermonth AS disponibleaftermonth_82, u2_.permisconduiteb AS permisconduiteb_83, u2_.loisir AS loisir_84, u2_.lng AS lng_85, u2_.lat AS lat_86, u2_.maxdistancework AS maxdistancework_87, u2_.googleadresse AS googleadresse_88, u2_.regionlibre AS regionlibre_89, u2_.codeuser AS codeuser_90, u2_.iscitiexist AS iscitiexist_91, u2_.tauxoccupation AS tauxoccupation_92, u2_.wanted_salary_type AS wanted_salary_type_93, u2_.tauxoccupationfrom AS tauxoccupationfrom_94, u2_.tauxoccupationto AS tauxoccupationto_95, u2_.salary AS salary_96, u2_.salary_month_number AS salary_month_number_97, u2_.partialtimeslap AS partialtimeslap_98, u2_.textmotivation AS textmotivation_99, u2_.classedby AS classedby_100, u2_.evaluateby AS evaluateby_101, u2_.isincontactlist AS isincontactlist_102, u2_.fonction AS fonction_103, u2_.candidate_evaluate AS candidate_evaluate_104, u2_.evaluatedby AS evaluatedby_105, u2_.disponibility_persentage AS disponibility_persentage_106, u2_.profile_complete_percentage AS profile_complete_percentage_107, u2_.is_from_ga AS is_from_ga_108, u2_.google_token AS google_token_109, u2_.cooptation_code_value AS cooptation_code_value_110, u2_.profile_views AS profile_views_111, u2_.is_imported AS is_imported_112, c3_.id AS id_113, c3_.name AS name_114, c3_.parentid AS parentid_115, c3_.isdeleted AS isdeleted_116, c3_.ispublish AS ispublish_117, c3_.orderlist AS orderlist_118, c3_.isexcluded AS isexcluded_119, o4_.id AS id_120, o4_.name AS name_121, o4_.created AS created_122, o4_.updated AS updated_123, c5_.id AS id_124, c5_.name AS name_125 FROM offresemplois o0_ LEFT JOIN offresemploistatus o1_ ON o0_.offresemploistatus_id = o1_.id LEFT JOIN user u2_ ON o0_.personnecontacts_id = u2_.id LEFT JOIN offreemploi_categories o6_ ON o0_.id = o6_.offresemplois_id LEFT JOIN categorieemplois c3_ ON c3_.id = o6_.categorieemplois_id LEFT JOIN offresemploisqualifications o4_ ON o0_.id = o4_.offresemplois_id LEFT JOIN contracttypes c5_ ON o0_.contracttypes_id = c5_.id WHERE o0_.id = '206';