Symfony Profiler

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_.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
  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,
  p2_.id AS id_44,
  p2_.name AS name_45,
  p2_.code AS code_46,
  p2_.alias AS alias_47,
  p2_.orderlist AS orderlist_48,
  u3_.picture AS picture_49,
  u3_.nom AS nom_50,
  u3_.isemailvalidated AS isemailvalidated_51,
  u3_.objectifpersonnel AS objectifpersonnel_52,
  u3_.prenom AS prenom_53,
  u3_.typenumerotel AS typenumerotel_54,
  u3_.numerotel AS numerotel_55,
  u3_.teladresseusers AS teladresseusers_56,
  u3_.tel AS tel_57,
  u3_.portable AS portable_58,
  u3_.orderlistcontact AS orderlistcontact_59,
  u3_.username AS username_60,
  u3_.username_canonical AS username_canonical_61,
  u3_.email_canonical AS email_canonical_62,
  u3_.enabled AS enabled_63,
  u3_.salt AS salt_64,
  u3_.last_login AS last_login_65,
  u3_.confirmation_token AS confirmation_token_66,
  u3_.password_requested_at AS password_requested_at_67,
  u3_.reset_token AS reset_token_68,
  u3_.id AS id_69,
  u3_.email AS email_70,
  u3_.roles AS roles_71,
  u3_.password AS password_72,
  u3_.civility AS civility_73,
  u3_.civilstate AS civilstate_74,
  u3_.adresse AS adresse_75,
  u3_.adresse2 AS adresse2_76,
  u3_.adresseregion AS adresseregion_77,
  u3_.locomotion AS locomotion_78,
  u3_.locomotiontype AS locomotiontype_79,
  u3_.site AS site_80,
  u3_.datedenaissance AS datedenaissance_81,
  u3_.cp AS cp_82,
  u3_.website AS website_83,
  u3_.created AS created_84,
  u3_.updated AS updated_85,
  u3_.isdisponible AS isdisponible_86,
  u3_.disponibleaftermonth AS disponibleaftermonth_87,
  u3_.permisconduiteb AS permisconduiteb_88,
  u3_.loisir AS loisir_89,
  u3_.lng AS lng_90,
  u3_.lat AS lat_91,
  u3_.maxdistancework AS maxdistancework_92,
  u3_.googleadresse AS googleadresse_93,
  u3_.regionlibre AS regionlibre_94,
  u3_.codeuser AS codeuser_95,
  u3_.iscitiexist AS iscitiexist_96,
  u3_.tauxoccupation AS tauxoccupation_97,
  u3_.wanted_salary_type AS wanted_salary_type_98,
  u3_.tauxoccupationfrom AS tauxoccupationfrom_99,
  u3_.tauxoccupationto AS tauxoccupationto_100,
  u3_.salary AS salary_101,
  u3_.salary_month_number AS salary_month_number_102,
  u3_.partialtimeslap AS partialtimeslap_103,
  u3_.textmotivation AS textmotivation_104,
  u3_.classedby AS classedby_105,
  u3_.evaluateby AS evaluateby_106,
  u3_.isincontactlist AS isincontactlist_107,
  u3_.fonction AS fonction_108,
  u3_.candidate_evaluate AS candidate_evaluate_109,
  u3_.evaluatedby AS evaluatedby_110,
  u3_.disponibility_persentage AS disponibility_persentage_111,
  u3_.profile_complete_percentage AS profile_complete_percentage_112,
  u3_.is_from_ga AS is_from_ga_113,
  u3_.google_token AS google_token_114,
  u3_.cooptation_code_value AS cooptation_code_value_115,
  u3_.profile_views AS profile_views_116,
  u3_.is_imported AS is_imported_117,
  r4_.id AS id_118,
  r4_.name AS name_119,
  r4_.parentsregions AS parentsregions_120,
  c5_.id AS id_121,
  c5_.name AS name_122,
  c5_.parentid AS parentid_123,
  c5_.isdeleted AS isdeleted_124,
  c5_.ispublish AS ispublish_125,
  c5_.orderlist AS orderlist_126,
  c5_.isexcluded AS isexcluded_127,
  o6_.id AS id_128,
  o6_.name AS name_129,
  o6_.created AS created_130,
  o6_.updated AS updated_131,
  c7_.id AS id_132,
  c7_.name AS name_133,
  o0_.contracttypes_id AS contracttypes_id_134,
  o0_.supplimentcriterias_id AS supplimentcriterias_id_135,
  o0_.user_id AS user_id_136,
  o0_.personnecontacts_id AS personnecontacts_id_137,
  o0_.pays_id AS pays_id_138,
  o0_.regions_id AS regions_id_139,
  o0_.localites_id AS localites_id_140,
  o0_.offresemploistatus_id AS offresemploistatus_id_141,
  u3_.candidate_classementlist_id AS candidate_classementlist_id_142,
  u3_.notice_period_id AS notice_period_id_143,
  u3_.civilstates_id AS civilstates_id_144,
  u3_.deleted_by AS deleted_by_145,
  u3_.nationnalite_id AS nationnalite_id_146,
  u3_.adressepays_id AS adressepays_id_147,
  u3_.cities_id AS cities_id_148,
  u3_.states_id AS states_id_149,
  u3_.permistravails_id AS permistravails_id_150,
  u3_.candidateevaluatelist_id AS candidateevaluatelist_id_151,
  u3_.cooptation_code AS cooptation_code_152,
  r4_.pays_id AS pays_id_153,
  o6_.offresemplois_id AS offresemplois_id_154
FROM
  offresemplois o0_
  INNER JOIN offresemploistatus o1_ ON o0_.offresemploistatus_id = o1_.id
  LEFT JOIN pays p2_ ON o0_.pays_id = p2_.id
  LEFT JOIN user u3_ ON o0_.personnecontacts_id = u3_.id
  LEFT JOIN regions r4_ ON o0_.regions_id = r4_.id
  LEFT JOIN offreemploi_categories o8_ ON o0_.id = o8_.offresemplois_id
  LEFT JOIN categorieemplois c5_ ON c5_.id = o8_.categorieemplois_id
  LEFT JOIN offresemploisqualifications o6_ ON o0_.id = o6_.offresemplois_id
  LEFT JOIN contracttypes c7_ ON o0_.contracttypes_id = c7_.id
WHERE
  o1_.code IN (?, ?)
ORDER BY
  o0_.publishdate DESC

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, p2_.id AS id_44, p2_.name AS name_45, p2_.code AS code_46, p2_.alias AS alias_47, p2_.orderlist AS orderlist_48, u3_.picture AS picture_49, u3_.nom AS nom_50, u3_.isemailvalidated AS isemailvalidated_51, u3_.objectifpersonnel AS objectifpersonnel_52, u3_.prenom AS prenom_53, u3_.typenumerotel AS typenumerotel_54, u3_.numerotel AS numerotel_55, u3_.teladresseusers AS teladresseusers_56, u3_.tel AS tel_57, u3_.portable AS portable_58, u3_.orderlistcontact AS orderlistcontact_59, u3_.username AS username_60, u3_.username_canonical AS username_canonical_61, u3_.email_canonical AS email_canonical_62, u3_.enabled AS enabled_63, u3_.salt AS salt_64, u3_.last_login AS last_login_65, u3_.confirmation_token AS confirmation_token_66, u3_.password_requested_at AS password_requested_at_67, u3_.reset_token AS reset_token_68, u3_.id AS id_69, u3_.email AS email_70, u3_.roles AS roles_71, u3_.password AS password_72, u3_.civility AS civility_73, u3_.civilstate AS civilstate_74, u3_.adresse AS adresse_75, u3_.adresse2 AS adresse2_76, u3_.adresseregion AS adresseregion_77, u3_.locomotion AS locomotion_78, u3_.locomotiontype AS locomotiontype_79, u3_.site AS site_80, u3_.datedenaissance AS datedenaissance_81, u3_.cp AS cp_82, u3_.website AS website_83, u3_.created AS created_84, u3_.updated AS updated_85, u3_.isdisponible AS isdisponible_86, u3_.disponibleaftermonth AS disponibleaftermonth_87, u3_.permisconduiteb AS permisconduiteb_88, u3_.loisir AS loisir_89, u3_.lng AS lng_90, u3_.lat AS lat_91, u3_.maxdistancework AS maxdistancework_92, u3_.googleadresse AS googleadresse_93, u3_.regionlibre AS regionlibre_94, u3_.codeuser AS codeuser_95, u3_.iscitiexist AS iscitiexist_96, u3_.tauxoccupation AS tauxoccupation_97, u3_.wanted_salary_type AS wanted_salary_type_98, u3_.tauxoccupationfrom AS tauxoccupationfrom_99, u3_.tauxoccupationto AS tauxoccupationto_100, u3_.salary AS salary_101, u3_.salary_month_number AS salary_month_number_102, u3_.partialtimeslap AS partialtimeslap_103, u3_.textmotivation AS textmotivation_104, u3_.classedby AS classedby_105, u3_.evaluateby AS evaluateby_106, u3_.isincontactlist AS isincontactlist_107, u3_.fonction AS fonction_108, u3_.candidate_evaluate AS candidate_evaluate_109, u3_.evaluatedby AS evaluatedby_110, u3_.disponibility_persentage AS disponibility_persentage_111, u3_.profile_complete_percentage AS profile_complete_percentage_112, u3_.is_from_ga AS is_from_ga_113, u3_.google_token AS google_token_114, u3_.cooptation_code_value AS cooptation_code_value_115, u3_.profile_views AS profile_views_116, u3_.is_imported AS is_imported_117, r4_.id AS id_118, r4_.name AS name_119, r4_.parentsregions AS parentsregions_120, c5_.id AS id_121, c5_.name AS name_122, c5_.parentid AS parentid_123, c5_.isdeleted AS isdeleted_124, c5_.ispublish AS ispublish_125, c5_.orderlist AS orderlist_126, c5_.isexcluded AS isexcluded_127, o6_.id AS id_128, o6_.name AS name_129, o6_.created AS created_130, o6_.updated AS updated_131, c7_.id AS id_132, c7_.name AS name_133, o0_.contracttypes_id AS contracttypes_id_134, o0_.supplimentcriterias_id AS supplimentcriterias_id_135, o0_.user_id AS user_id_136, o0_.personnecontacts_id AS personnecontacts_id_137, o0_.pays_id AS pays_id_138, o0_.regions_id AS regions_id_139, o0_.localites_id AS localites_id_140, o0_.offresemploistatus_id AS offresemploistatus_id_141, u3_.candidate_classementlist_id AS candidate_classementlist_id_142, u3_.notice_period_id AS notice_period_id_143, u3_.civilstates_id AS civilstates_id_144, u3_.deleted_by AS deleted_by_145, u3_.nationnalite_id AS nationnalite_id_146, u3_.adressepays_id AS adressepays_id_147, u3_.cities_id AS cities_id_148, u3_.states_id AS states_id_149, u3_.permistravails_id AS permistravails_id_150, u3_.candidateevaluatelist_id AS candidateevaluatelist_id_151, u3_.cooptation_code AS cooptation_code_152, r4_.pays_id AS pays_id_153, o6_.offresemplois_id AS offresemplois_id_154 FROM offresemplois o0_ INNER JOIN offresemploistatus o1_ ON o0_.offresemploistatus_id = o1_.id LEFT JOIN pays p2_ ON o0_.pays_id = p2_.id LEFT JOIN user u3_ ON o0_.personnecontacts_id = u3_.id LEFT JOIN regions r4_ ON o0_.regions_id = r4_.id LEFT JOIN offreemploi_categories o8_ ON o0_.id = o8_.offresemplois_id LEFT JOIN categorieemplois c5_ ON c5_.id = o8_.categorieemplois_id LEFT JOIN offresemploisqualifications o6_ ON o0_.id = o6_.offresemplois_id LEFT JOIN contracttypes c7_ ON o0_.contracttypes_id = c7_.id WHERE o1_.code IN ('publish', 'candidate_only') ORDER BY o0_.publishdate DESC;

SELECT
  t0.id AS id_1,
  t0.objectid AS objectid_2,
  t0.modulename AS modulename_3,
  t0.isfuture AS isfuture_4,
  t0.ordernumber AS ordernumber_5,
  t0.created AS created_6,
  t0.updated AS updated_7,
  t0.media_id AS media_id_8
FROM
  mediapages t0
WHERE
  t0.objectid = ?
  AND t0.modulename = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.objectid AS objectid_2, t0.modulename AS modulename_3, t0.isfuture AS isfuture_4, t0.ordernumber AS ordernumber_5, t0.created AS created_6, t0.updated AS updated_7, t0.media_id AS media_id_8 FROM mediapages t0 WHERE t0.objectid = 206 AND t0.modulename = 'OFFREEMPLOIS' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.objectid AS objectid_2,
  t0.modulename AS modulename_3,
  t0.isfuture AS isfuture_4,
  t0.ordernumber AS ordernumber_5,
  t0.created AS created_6,
  t0.updated AS updated_7,
  t0.media_id AS media_id_8
FROM
  mediapages t0
WHERE
  t0.objectid = ?
  AND t0.modulename = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.objectid AS objectid_2, t0.modulename AS modulename_3, t0.isfuture AS isfuture_4, t0.ordernumber AS ordernumber_5, t0.created AS created_6, t0.updated AS updated_7, t0.media_id AS media_id_8 FROM mediapages t0 WHERE t0.objectid = 198 AND t0.modulename = 'OFFREEMPLOIS' LIMIT 1;

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 ('globalparams') ORDER BY s0_.ordre 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
  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
  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_.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
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 = 5 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 = ?
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 = 14 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 = ?
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 = 5 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 = ?
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 = 241 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 = ?
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 = 5 LIMIT 1;