Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.unique_id AS unique_id_1,
  c0_.title AS title_2,
  c0_.slug AS slug_3,
  c0_.summary AS summary_4,
  c0_.body AS body_5,
  c0_.thumbnail AS thumbnail_6,
  c0_.status AS status_7,
  c0_.is_featured AS is_featured_8,
  c0_.promoted AS promoted_9,
  c0_.publish_on_socialmedia AS publish_on_socialmedia_10,
  c0_.is_published_social_media AS is_published_social_media_11,
  c0_.is_home AS is_home_12,
  c0_.date_created AS date_created_13,
  c0_.date_published AS date_published_14,
  c0_.meta_keywords AS meta_keywords_15,
  c0_.meta_description AS meta_description_16,
  c0_.updated_at AS updated_at_17,
  c0_.position AS position_18,
  c1_.parent_id AS parent_id_19,
  c1_.page_icon AS page_icon_20,
  c2_.id AS id_21,
  c2_.contact_number AS contact_number_22,
  c2_.created_at AS created_at_23,
  c2_.updated_at AS updated_at_24,
  c2_.date_of_birth AS date_of_birth_25,
  c2_.thumbnail AS thumbnail_26,
  c2_.profile_cover_image AS profile_cover_image_27,
  c2_.auth_code AS auth_code_28,
  c2_.is_two_factor_enabled AS is_two_factor_enabled_29,
  c2_.profile_photo AS profile_photo_30,
  c2_.profile_cover_photo AS profile_cover_photo_31,
  c2_.account_status AS account_status_32,
  c2_.account_confirmed_at AS account_confirmed_at_33,
  c2_.last_login_at AS last_login_at_34,
  c2_.bio AS bio_35,
  c2_.address AS address_36,
  c2_.city AS city_37,
  c2_.marital_status AS marital_status_38,
  c2_.country AS country_39,
  c2_.nationality AS nationality_40,
  c2_.status AS status_41,
  c2_.username AS username_42,
  c2_.postal_code AS postal_code_43,
  c2_.is_activated AS is_activated_44,
  c2_.online_status AS online_status_45,
  c2_.phone_numbers AS phone_numbers_46,
  c2_.active_role AS active_role_47,
  c2_.active_layout AS active_layout_48,
  c2_.active_theme AS active_theme_49,
  c2_.email AS email_50,
  c2_.password AS password_51,
  c2_.is_verified AS is_verified_52,
  c2_.is_logged_in AS is_logged_in_53,
  c2_.gender AS gender_54,
  c2_.first_name AS first_name_55,
  c2_.last_name AS last_name_56,
  c2_.other_names AS other_names_57,
  c2_.is_deleted AS is_deleted_58,
  c2_.deleted_at AS deleted_at_59,
  c2_.documents AS documents_60,
  c4_.index_number AS index_number_61,
  c4_.student_id AS student_id_62,
  c4_.year_level AS year_level_63,
  c4_.next_year_level AS next_year_level_64,
  c4_.year_level_escalated AS year_level_escalated_65,
  c4_.qualification_type AS qualification_type_66,
  c4_.admission_date AS admission_date_67,
  c4_.matriculation_affirmed_at AS matriculation_affirmed_at_68,
  c4_.date_of_completion AS date_of_completion_69,
  c4_.last_registered_at AS last_registered_at_70,
  c4_.account_standing AS account_standing_71,
  c4_.title AS title_72,
  c4_.place_of_birth AS place_of_birth_73,
  c4_.religion AS religion_74,
  c4_.religious_denomination AS religious_denomination_75,
  c4_.national_id_type AS national_id_type_76,
  c4_.national_id_number AS national_id_number_77,
  c4_.passport_number AS passport_number_78,
  c4_.ssn AS ssn_79,
  c4_.physical_challenge AS physical_challenge_80,
  c4_.physical_challenge_info AS physical_challenge_info_81,
  c4_.personal_email AS personal_email_82,
  c4_.address_line_one AS address_line_one_83,
  c4_.post_code AS post_code_84,
  c4_.address_city AS address_city_85,
  c4_.address_country AS address_country_86,
  c4_.region AS region_87,
  c4_.home_town AS home_town_88,
  c4_.hometown_region AS hometown_region_89,
  c4_.guardian_name AS guardian_name_90,
  c4_.guardian_relationship AS guardian_relationship_91,
  c4_.guardian_contact_number AS guardian_contact_number_92,
  c4_.guardian_email AS guardian_email_93,
  c4_.guardian_address_line_one AS guardian_address_line_one_94,
  c4_.guardian_address_line_two AS guardian_address_line_two_95,
  c4_.guardian_address_city AS guardian_address_city_96,
  c4_.guardian_address_country AS guardian_address_country_97,
  c4_.admission_type AS admission_type_98,
  c4_.application_serial AS application_serial_99,
  c4_.application_year AS application_year_100,
  c4_.previously_attended_upsa AS previously_attended_upsa_101,
  c4_.previous_id AS previous_id_102,
  c4_.previous_institution AS previous_institution_103,
  c4_.gateway_reg_no AS gateway_reg_no_104,
  c4_.academic_status AS academic_status_105,
  c4_.registration_status AS registration_status_106,
  c4_.is_initial_registration_completed AS is_initial_registration_completed_107,
  c5_.id AS id_108,
  c5_.title AS title_109,
  c5_.slug AS slug_110,
  c5_.path AS path_111,
  c5_.position AS position_112,
  c5_.date_created AS date_created_113,
  c5_.visibility AS visibility_114,
  c5_.parent_id AS parent_id_115,
  c5_.route_name AS route_name_116,
  c5_.template AS template_117,
  c5_.layout_type AS layout_type_118,
  c0_.content_type AS content_type_119,
  c0_.user_id AS user_id_120,
  c0_.term_id AS term_id_121,
  c1_.route_id AS route_id_122,
  c2_.user_type AS user_type_123,
  c2_.department_id AS department_id_124,
  c2_.created_by_id AS created_by_id_125,
  c2_.updated_by_id AS updated_by_id_126,
  c4_.stud_prog_id AS stud_prog_id_127,
  c4_.stud_batch_id AS stud_batch_id_128,
  c4_.session_id AS session_id_129,
  c4_.entry_qualification_type_id AS entry_qualification_type_id_130,
  c4_.hall_id AS hall_id_131,
  c4_.current_course_registration_id AS current_course_registration_id_132,
  c5_.route_type AS route_type_133
FROM
  cms_page c1_
  INNER JOIN cms_contents c0_ ON c1_.id = c0_.id
  LEFT JOIN core_user c2_ ON c0_.user_id = c2_.id
  LEFT JOIN core_user_admin c3_ ON c2_.id = c3_.id
  LEFT JOIN core_user_student c4_ ON c2_.id = c4_.id
  LEFT JOIN cms_route c5_ ON c1_.route_id = c5_.id
  AND c5_.route_type IN ('page')
WHERE
  c5_.id = ?
  AND c0_.status = ?

SELECT c0_.id AS id_0, c0_.unique_id AS unique_id_1, c0_.title AS title_2, c0_.slug AS slug_3, c0_.summary AS summary_4, c0_.body AS body_5, c0_.thumbnail AS thumbnail_6, c0_.status AS status_7, c0_.is_featured AS is_featured_8, c0_.promoted AS promoted_9, c0_.publish_on_socialmedia AS publish_on_socialmedia_10, c0_.is_published_social_media AS is_published_social_media_11, c0_.is_home AS is_home_12, c0_.date_created AS date_created_13, c0_.date_published AS date_published_14, c0_.meta_keywords AS meta_keywords_15, c0_.meta_description AS meta_description_16, c0_.updated_at AS updated_at_17, c0_.position AS position_18, c1_.parent_id AS parent_id_19, c1_.page_icon AS page_icon_20, c2_.id AS id_21, c2_.contact_number AS contact_number_22, c2_.created_at AS created_at_23, c2_.updated_at AS updated_at_24, c2_.date_of_birth AS date_of_birth_25, c2_.thumbnail AS thumbnail_26, c2_.profile_cover_image AS profile_cover_image_27, c2_.auth_code AS auth_code_28, c2_.is_two_factor_enabled AS is_two_factor_enabled_29, c2_.profile_photo AS profile_photo_30, c2_.profile_cover_photo AS profile_cover_photo_31, c2_.account_status AS account_status_32, c2_.account_confirmed_at AS account_confirmed_at_33, c2_.last_login_at AS last_login_at_34, c2_.bio AS bio_35, c2_.address AS address_36, c2_.city AS city_37, c2_.marital_status AS marital_status_38, c2_.country AS country_39, c2_.nationality AS nationality_40, c2_.status AS status_41, c2_.username AS username_42, c2_.postal_code AS postal_code_43, c2_.is_activated AS is_activated_44, c2_.online_status AS online_status_45, c2_.phone_numbers AS phone_numbers_46, c2_.active_role AS active_role_47, c2_.active_layout AS active_layout_48, c2_.active_theme AS active_theme_49, c2_.email AS email_50, c2_.password AS password_51, c2_.is_verified AS is_verified_52, c2_.is_logged_in AS is_logged_in_53, c2_.gender AS gender_54, c2_.first_name AS first_name_55, c2_.last_name AS last_name_56, c2_.other_names AS other_names_57, c2_.is_deleted AS is_deleted_58, c2_.deleted_at AS deleted_at_59, c2_.documents AS documents_60, c4_.index_number AS index_number_61, c4_.student_id AS student_id_62, c4_.year_level AS year_level_63, c4_.next_year_level AS next_year_level_64, c4_.year_level_escalated AS year_level_escalated_65, c4_.qualification_type AS qualification_type_66, c4_.admission_date AS admission_date_67, c4_.matriculation_affirmed_at AS matriculation_affirmed_at_68, c4_.date_of_completion AS date_of_completion_69, c4_.last_registered_at AS last_registered_at_70, c4_.account_standing AS account_standing_71, c4_.title AS title_72, c4_.place_of_birth AS place_of_birth_73, c4_.religion AS religion_74, c4_.religious_denomination AS religious_denomination_75, c4_.national_id_type AS national_id_type_76, c4_.national_id_number AS national_id_number_77, c4_.passport_number AS passport_number_78, c4_.ssn AS ssn_79, c4_.physical_challenge AS physical_challenge_80, c4_.physical_challenge_info AS physical_challenge_info_81, c4_.personal_email AS personal_email_82, c4_.address_line_one AS address_line_one_83, c4_.post_code AS post_code_84, c4_.address_city AS address_city_85, c4_.address_country AS address_country_86, c4_.region AS region_87, c4_.home_town AS home_town_88, c4_.hometown_region AS hometown_region_89, c4_.guardian_name AS guardian_name_90, c4_.guardian_relationship AS guardian_relationship_91, c4_.guardian_contact_number AS guardian_contact_number_92, c4_.guardian_email AS guardian_email_93, c4_.guardian_address_line_one AS guardian_address_line_one_94, c4_.guardian_address_line_two AS guardian_address_line_two_95, c4_.guardian_address_city AS guardian_address_city_96, c4_.guardian_address_country AS guardian_address_country_97, c4_.admission_type AS admission_type_98, c4_.application_serial AS application_serial_99, c4_.application_year AS application_year_100, c4_.previously_attended_upsa AS previously_attended_upsa_101, c4_.previous_id AS previous_id_102, c4_.previous_institution AS previous_institution_103, c4_.gateway_reg_no AS gateway_reg_no_104, c4_.academic_status AS academic_status_105, c4_.registration_status AS registration_status_106, c4_.is_initial_registration_completed AS is_initial_registration_completed_107, c5_.id AS id_108, c5_.title AS title_109, c5_.slug AS slug_110, c5_.path AS path_111, c5_.position AS position_112, c5_.date_created AS date_created_113, c5_.visibility AS visibility_114, c5_.parent_id AS parent_id_115, c5_.route_name AS route_name_116, c5_.template AS template_117, c5_.layout_type AS layout_type_118, c0_.content_type AS content_type_119, c0_.user_id AS user_id_120, c0_.term_id AS term_id_121, c1_.route_id AS route_id_122, c2_.user_type AS user_type_123, c2_.department_id AS department_id_124, c2_.created_by_id AS created_by_id_125, c2_.updated_by_id AS updated_by_id_126, c4_.stud_prog_id AS stud_prog_id_127, c4_.stud_batch_id AS stud_batch_id_128, c4_.session_id AS session_id_129, c4_.entry_qualification_type_id AS entry_qualification_type_id_130, c4_.hall_id AS hall_id_131, c4_.current_course_registration_id AS current_course_registration_id_132, c5_.route_type AS route_type_133 FROM cms_page c1_ INNER JOIN cms_contents c0_ ON c1_.id = c0_.id LEFT JOIN core_user c2_ ON c0_.user_id = c2_.id LEFT JOIN core_user_admin c3_ ON c2_.id = c3_.id LEFT JOIN core_user_student c4_ ON c2_.id = c4_.id LEFT JOIN cms_route c5_ ON c1_.route_id = c5_.id AND c5_.route_type IN ('page') WHERE c5_.id = '5' AND c0_.status = 'published';

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.qualification_type AS qualification_type_2,
  a0_.start_date AS start_date_3,
  a0_.end_date AS end_date_4,
  a0_.description AS description_5,
  a0_.application_instructions AS application_instructions_6,
  a0_.admission_information_template AS admission_information_template_7,
  a0_.matriculation_date AS matriculation_date_8,
  a0_.official_date_of_admission AS official_date_of_admission_9,
  a0_.provisional_admission_information_template AS provisional_admission_information_template_10,
  a0_.created_at AS created_at_11,
  a0_.updated_at AS updated_at_12,
  a0_.status AS status_13,
  a0_.is_deleted AS is_deleted_14,
  a0_.deleted_at AS deleted_at_15,
  a1_.id AS id_16,
  a1_.period AS period_17,
  a1_.start_date AS start_date_18,
  a1_.end_date AS end_date_19,
  a1_.created_at AS created_at_20,
  a1_.updated_at AS updated_at_21,
  a1_.status AS status_22,
  a1_.is_deleted AS is_deleted_23,
  a1_.deleted_at AS deleted_at_24,
  p2_.id AS id_25,
  p2_.code AS code_26,
  p2_.name AS name_27,
  p2_.short_name AS short_name_28,
  p2_.certificate_name AS certificate_name_29,
  p2_.slug AS slug_30,
  p2_.qualification_type AS qualification_type_31,
  p2_.field_of_study AS field_of_study_32,
  p2_.discipline AS discipline_33,
  p2_.specialization AS specialization_34,
  p2_.accreditation_body AS accreditation_body_35,
  p2_.accreditation_status AS accreditation_status_36,
  p2_.accreditation_expiry_date AS accreditation_expiry_date_37,
  p2_.duration_years AS duration_years_38,
  p2_.duration_semesters AS duration_semesters_39,
  p2_.study_mode AS study_mode_40,
  p2_.delivery_mode AS delivery_mode_41,
  p2_.intake_schedule AS intake_schedule_42,
  p2_.min_enrollment AS min_enrollment_43,
  p2_.max_enrollment AS max_enrollment_44,
  p2_.is_accepting_applications AS is_accepting_applications_45,
  p2_.administrative_contact AS administrative_contact_46,
  p2_.approval_status AS approval_status_47,
  p2_.approved_at AS approved_at_48,
  p2_.description AS description_49,
  p2_.objectives AS objectives_50,
  p2_.career_outcomes AS career_outcomes_51,
  p2_.curriculum AS curriculum_52,
  p2_.highlights AS highlights_53,
  p2_.is_featured AS is_featured_54,
  p2_.display_order AS display_order_55,
  p2_.image_url AS image_url_56,
  p2_.video_url AS video_url_57,
  p2_.brochure_url AS brochure_url_58,
  p2_.website_url AS website_url_59,
  p2_.letter_year AS letter_year_60,
  p2_.letter_template AS letter_template_61,
  p2_.letter_opening AS letter_opening_62,
  p2_.pdf_layout_group AS pdf_layout_group_63,
  p2_.created_at AS created_at_64,
  p2_.updated_at AS updated_at_65,
  p2_.status AS status_66,
  p2_.is_deleted AS is_deleted_67,
  p2_.deleted_at AS deleted_at_68,
  a0_.academic_year_id AS academic_year_id_69,
  a0_.batch_id AS batch_id_70,
  a0_.created_by_id AS created_by_id_71,
  a0_.updated_by_id AS updated_by_id_72,
  a1_.batch_id AS batch_id_73,
  a1_.created_by_id AS created_by_id_74,
  a1_.updated_by_id AS updated_by_id_75,
  p2_.session_id AS session_id_76,
  p2_.department_id AS department_id_77,
  p2_.coordinator_id AS coordinator_id_78,
  p2_.approved_by_id AS approved_by_id_79,
  p2_.created_by_id AS created_by_id_80,
  p2_.updated_by_id AS updated_by_id_81
FROM
  admissions_application_period a0_
  INNER JOIN academic_year a1_ ON a0_.academic_year_id = a1_.id
  LEFT JOIN admissions_application_period_programs a3_ ON a0_.id = a3_.application_period_id
  LEFT JOIN program p2_ ON p2_.id = a3_.program_id
WHERE
  a1_.id IN (?, ?, ?)
  AND a0_.status = ?
  AND (
    a0_.is_deleted IS NULL
    OR a0_.is_deleted = 0
  )
ORDER BY
  a0_.start_date DESC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.qualification_type AS qualification_type_2, a0_.start_date AS start_date_3, a0_.end_date AS end_date_4, a0_.description AS description_5, a0_.application_instructions AS application_instructions_6, a0_.admission_information_template AS admission_information_template_7, a0_.matriculation_date AS matriculation_date_8, a0_.official_date_of_admission AS official_date_of_admission_9, a0_.provisional_admission_information_template AS provisional_admission_information_template_10, a0_.created_at AS created_at_11, a0_.updated_at AS updated_at_12, a0_.status AS status_13, a0_.is_deleted AS is_deleted_14, a0_.deleted_at AS deleted_at_15, a1_.id AS id_16, a1_.period AS period_17, a1_.start_date AS start_date_18, a1_.end_date AS end_date_19, a1_.created_at AS created_at_20, a1_.updated_at AS updated_at_21, a1_.status AS status_22, a1_.is_deleted AS is_deleted_23, a1_.deleted_at AS deleted_at_24, p2_.id AS id_25, p2_.code AS code_26, p2_.name AS name_27, p2_.short_name AS short_name_28, p2_.certificate_name AS certificate_name_29, p2_.slug AS slug_30, p2_.qualification_type AS qualification_type_31, p2_.field_of_study AS field_of_study_32, p2_.discipline AS discipline_33, p2_.specialization AS specialization_34, p2_.accreditation_body AS accreditation_body_35, p2_.accreditation_status AS accreditation_status_36, p2_.accreditation_expiry_date AS accreditation_expiry_date_37, p2_.duration_years AS duration_years_38, p2_.duration_semesters AS duration_semesters_39, p2_.study_mode AS study_mode_40, p2_.delivery_mode AS delivery_mode_41, p2_.intake_schedule AS intake_schedule_42, p2_.min_enrollment AS min_enrollment_43, p2_.max_enrollment AS max_enrollment_44, p2_.is_accepting_applications AS is_accepting_applications_45, p2_.administrative_contact AS administrative_contact_46, p2_.approval_status AS approval_status_47, p2_.approved_at AS approved_at_48, p2_.description AS description_49, p2_.objectives AS objectives_50, p2_.career_outcomes AS career_outcomes_51, p2_.curriculum AS curriculum_52, p2_.highlights AS highlights_53, p2_.is_featured AS is_featured_54, p2_.display_order AS display_order_55, p2_.image_url AS image_url_56, p2_.video_url AS video_url_57, p2_.brochure_url AS brochure_url_58, p2_.website_url AS website_url_59, p2_.letter_year AS letter_year_60, p2_.letter_template AS letter_template_61, p2_.letter_opening AS letter_opening_62, p2_.pdf_layout_group AS pdf_layout_group_63, p2_.created_at AS created_at_64, p2_.updated_at AS updated_at_65, p2_.status AS status_66, p2_.is_deleted AS is_deleted_67, p2_.deleted_at AS deleted_at_68, a0_.academic_year_id AS academic_year_id_69, a0_.batch_id AS batch_id_70, a0_.created_by_id AS created_by_id_71, a0_.updated_by_id AS updated_by_id_72, a1_.batch_id AS batch_id_73, a1_.created_by_id AS created_by_id_74, a1_.updated_by_id AS updated_by_id_75, p2_.session_id AS session_id_76, p2_.department_id AS department_id_77, p2_.coordinator_id AS coordinator_id_78, p2_.approved_by_id AS approved_by_id_79, p2_.created_by_id AS created_by_id_80, p2_.updated_by_id AS updated_by_id_81 FROM admissions_application_period a0_ INNER JOIN academic_year a1_ ON a0_.academic_year_id = a1_.id LEFT JOIN admissions_application_period_programs a3_ ON a0_.id = a3_.application_period_id LEFT JOIN program p2_ ON p2_.id = a3_.program_id WHERE a1_.id IN ('57d2aec8-6c99-495b-b9e4-7ce3abd4fe4a', '7aa7bff1-ca82-43be-a217-731f07ae522a', 'cbaaf437-7591-4b90-b55d-ec9b52dc1b73') AND a0_.status = 'active' AND (a0_.is_deleted IS NULL OR a0_.is_deleted = 0) ORDER BY a0_.start_date DESC;

SELECT
  a0_.id AS id_0,
  a0_.period AS period_1,
  a0_.start_date AS start_date_2,
  a0_.end_date AS end_date_3,
  a0_.created_at AS created_at_4,
  a0_.updated_at AS updated_at_5,
  a0_.status AS status_6,
  a0_.is_deleted AS is_deleted_7,
  a0_.deleted_at AS deleted_at_8,
  b1_.id AS id_9,
  b1_.name AS name_10,
  b1_.code AS code_11,
  b1_.number_of_semesters AS number_of_semesters_12,
  b1_.description AS description_13,
  b1_.is_default AS is_default_14,
  b1_.created_at AS created_at_15,
  b1_.updated_at AS updated_at_16,
  b1_.status AS status_17,
  b1_.is_deleted AS is_deleted_18,
  b1_.deleted_at AS deleted_at_19,
  s2_.id AS id_20,
  s2_.number AS number_21,
  s2_.start_date AS start_date_22,
  s2_.end_date AS end_date_23,
  s2_.created_at AS created_at_24,
  s2_.updated_at AS updated_at_25,
  s2_.status AS status_26,
  s2_.is_deleted AS is_deleted_27,
  s2_.deleted_at AS deleted_at_28,
  a0_.batch_id AS batch_id_29,
  a0_.created_by_id AS created_by_id_30,
  a0_.updated_by_id AS updated_by_id_31,
  b1_.created_by_id AS created_by_id_32,
  b1_.updated_by_id AS updated_by_id_33,
  s2_.academic_year_id AS academic_year_id_34,
  s2_.created_by_id AS created_by_id_35,
  s2_.updated_by_id AS updated_by_id_36
FROM
  academic_year a0_
  LEFT JOIN batch b1_ ON a0_.batch_id = b1_.id
  LEFT JOIN semester s2_ ON a0_.id = s2_.academic_year_id
WHERE
  a0_.start_date <= ?
  AND a0_.end_date >= ?
  AND a0_.status = ?
  AND (
    a0_.is_deleted IS NULL
    OR a0_.is_deleted = 0
  )
ORDER BY
  a0_.period DESC

SELECT a0_.id AS id_0, a0_.period AS period_1, a0_.start_date AS start_date_2, a0_.end_date AS end_date_3, a0_.created_at AS created_at_4, a0_.updated_at AS updated_at_5, a0_.status AS status_6, a0_.is_deleted AS is_deleted_7, a0_.deleted_at AS deleted_at_8, b1_.id AS id_9, b1_.name AS name_10, b1_.code AS code_11, b1_.number_of_semesters AS number_of_semesters_12, b1_.description AS description_13, b1_.is_default AS is_default_14, b1_.created_at AS created_at_15, b1_.updated_at AS updated_at_16, b1_.status AS status_17, b1_.is_deleted AS is_deleted_18, b1_.deleted_at AS deleted_at_19, s2_.id AS id_20, s2_.number AS number_21, s2_.start_date AS start_date_22, s2_.end_date AS end_date_23, s2_.created_at AS created_at_24, s2_.updated_at AS updated_at_25, s2_.status AS status_26, s2_.is_deleted AS is_deleted_27, s2_.deleted_at AS deleted_at_28, a0_.batch_id AS batch_id_29, a0_.created_by_id AS created_by_id_30, a0_.updated_by_id AS updated_by_id_31, b1_.created_by_id AS created_by_id_32, b1_.updated_by_id AS updated_by_id_33, s2_.academic_year_id AS academic_year_id_34, s2_.created_by_id AS created_by_id_35, s2_.updated_by_id AS updated_by_id_36 FROM academic_year a0_ LEFT JOIN batch b1_ ON a0_.batch_id = b1_.id LEFT JOIN semester s2_ ON a0_.id = s2_.academic_year_id WHERE a0_.start_date <= '2026-10-16 02:30:15' AND a0_.end_date >= '2026-10-16 02:30:15' AND a0_.status = 'active' AND (a0_.is_deleted IS NULL OR a0_.is_deleted = 0) ORDER BY a0_.period DESC;

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.slug AS slug_2,
  c0_.path AS path_3,
  c0_.position AS position_4,
  c0_.date_created AS date_created_5,
  c0_.visibility AS visibility_6,
  c0_.parent_id AS parent_id_7,
  c0_.route_name AS route_name_8,
  c0_.template AS template_9,
  c0_.layout_type AS layout_type_10,
  c0_.controller AS controller_11,
  c0_.content_type AS content_type_12,
  c0_.controller AS controller_13,
  c0_.content_type AS content_type_14,
  c0_.url AS url_15,
  c0_.permanent AS permanent_16,
  c0_.route_type AS route_type_17
FROM
  cms_route c0_
WHERE
  c0_.route_type IN (
    'list', 'post', 'page', 'taxon', 'url'
  )
ORDER BY
  c0_.position ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.slug AS slug_2, c0_.path AS path_3, c0_.position AS position_4, c0_.date_created AS date_created_5, c0_.visibility AS visibility_6, c0_.parent_id AS parent_id_7, c0_.route_name AS route_name_8, c0_.template AS template_9, c0_.layout_type AS layout_type_10, c0_.controller AS controller_11, c0_.content_type AS content_type_12, c0_.controller AS controller_13, c0_.content_type AS content_type_14, c0_.url AS url_15, c0_.permanent AS permanent_16, c0_.route_type AS route_type_17 FROM cms_route c0_ WHERE c0_.route_type IN ('list', 'post', 'page', 'taxon', 'url') ORDER BY c0_.position ASC;

SELECT
  t0.id AS id_1,
  t0.honorific AS honorific_2,
  t0.academic_title AS academic_title_3,
  t0.academic_rank AS academic_rank_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.status AS status_7,
  t0.user_id AS user_id_8,
  t0.created_by_id AS created_by_id_9,
  t0.updated_by_id AS updated_by_id_10
FROM
  core_user_lecturer t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.honorific AS honorific_2, t0.academic_title AS academic_title_3, t0.academic_rank AS academic_rank_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.user_id AS user_id_8, t0.created_by_id AS created_by_id_9, t0.updated_by_id AS updated_by_id_10 FROM core_user_lecturer t0 WHERE t0.user_id = 'f8583a61-a8e1-4a19-aa79-829409514d6a';

SELECT
  t0.id AS id_1,
  t0.identifier AS identifier_2,
  t0.value AS value_3,
  t0.type AS type_4,
  t0.required AS required_5
FROM
  fbeen_settings t0

SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.value AS value_3, t0.type AS type_4, t0.required AS required_5 FROM fbeen_settings t0;

SELECT
  t0.id AS id_3,
  t0.contact_number AS contact_number_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.date_of_birth AS date_of_birth_7,
  t0.thumbnail AS thumbnail_8,
  t0.profile_cover_image AS profile_cover_image_9,
  t0.auth_code AS auth_code_10,
  t0.is_two_factor_enabled AS is_two_factor_enabled_11,
  t0.profile_photo AS profile_photo_12,
  t0.profile_cover_photo AS profile_cover_photo_13,
  t0.account_status AS account_status_14,
  t0.account_confirmed_at AS account_confirmed_at_15,
  t0.last_login_at AS last_login_at_16,
  t0.bio AS bio_17,
  t0.address AS address_18,
  t0.city AS city_19,
  t0.marital_status AS marital_status_20,
  t0.country AS country_21,
  t0.nationality AS nationality_22,
  t0.status AS status_23,
  t0.username AS username_24,
  t0.postal_code AS postal_code_25,
  t0.is_activated AS is_activated_26,
  t0.online_status AS online_status_27,
  t0.phone_numbers AS phone_numbers_28,
  t0.active_role AS active_role_29,
  t0.active_layout AS active_layout_30,
  t0.active_theme AS active_theme_31,
  t0.email AS email_32,
  t0.password AS password_33,
  t0.is_verified AS is_verified_34,
  t0.is_logged_in AS is_logged_in_35,
  t0.gender AS gender_36,
  t0.first_name AS first_name_37,
  t0.last_name AS last_name_38,
  t0.other_names AS other_names_39,
  t0.is_deleted AS is_deleted_40,
  t0.deleted_at AS deleted_at_41,
  t0.documents AS documents_42,
  t0.department_id AS department_id_43,
  t0.created_by_id AS created_by_id_44,
  t0.updated_by_id AS updated_by_id_45,
  t0.user_type,
  t2.index_number AS index_number_46,
  t2.student_id AS student_id_47,
  t2.year_level AS year_level_48,
  t2.next_year_level AS next_year_level_49,
  t2.year_level_escalated AS year_level_escalated_50,
  t2.qualification_type AS qualification_type_51,
  t2.admission_date AS admission_date_52,
  t2.matriculation_affirmed_at AS matriculation_affirmed_at_53,
  t2.date_of_completion AS date_of_completion_54,
  t2.last_registered_at AS last_registered_at_55,
  t2.account_standing AS account_standing_56,
  t2.title AS title_57,
  t2.place_of_birth AS place_of_birth_58,
  t2.religion AS religion_59,
  t2.religious_denomination AS religious_denomination_60,
  t2.national_id_type AS national_id_type_61,
  t2.national_id_number AS national_id_number_62,
  t2.passport_number AS passport_number_63,
  t2.ssn AS ssn_64,
  t2.physical_challenge AS physical_challenge_65,
  t2.physical_challenge_info AS physical_challenge_info_66,
  t2.personal_email AS personal_email_67,
  t2.address_line_one AS address_line_one_68,
  t2.post_code AS post_code_69,
  t2.address_city AS address_city_70,
  t2.address_country AS address_country_71,
  t2.region AS region_72,
  t2.home_town AS home_town_73,
  t2.hometown_region AS hometown_region_74,
  t2.guardian_name AS guardian_name_75,
  t2.guardian_relationship AS guardian_relationship_76,
  t2.guardian_contact_number AS guardian_contact_number_77,
  t2.guardian_email AS guardian_email_78,
  t2.guardian_address_line_one AS guardian_address_line_one_79,
  t2.guardian_address_line_two AS guardian_address_line_two_80,
  t2.guardian_address_city AS guardian_address_city_81,
  t2.guardian_address_country AS guardian_address_country_82,
  t2.admission_type AS admission_type_83,
  t2.application_serial AS application_serial_84,
  t2.application_year AS application_year_85,
  t2.previously_attended_upsa AS previously_attended_upsa_86,
  t2.previous_id AS previous_id_87,
  t2.previous_institution AS previous_institution_88,
  t2.gateway_reg_no AS gateway_reg_no_89,
  t2.academic_status AS academic_status_90,
  t2.registration_status AS registration_status_91,
  t2.is_initial_registration_completed AS is_initial_registration_completed_92,
  t2.stud_prog_id AS stud_prog_id_93,
  t2.stud_batch_id AS stud_batch_id_94,
  t2.session_id AS session_id_95,
  t2.entry_qualification_type_id AS entry_qualification_type_id_96,
  t2.hall_id AS hall_id_97,
  t2.current_course_registration_id AS current_course_registration_id_98
FROM
  core_user t0
  LEFT JOIN core_user_admin t1 ON t0.id = t1.id
  LEFT JOIN core_user_student t2 ON t0.id = t2.id
WHERE
  t0.id = ?

SELECT t0.id AS id_3, t0.contact_number AS contact_number_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.date_of_birth AS date_of_birth_7, t0.thumbnail AS thumbnail_8, t0.profile_cover_image AS profile_cover_image_9, t0.auth_code AS auth_code_10, t0.is_two_factor_enabled AS is_two_factor_enabled_11, t0.profile_photo AS profile_photo_12, t0.profile_cover_photo AS profile_cover_photo_13, t0.account_status AS account_status_14, t0.account_confirmed_at AS account_confirmed_at_15, t0.last_login_at AS last_login_at_16, t0.bio AS bio_17, t0.address AS address_18, t0.city AS city_19, t0.marital_status AS marital_status_20, t0.country AS country_21, t0.nationality AS nationality_22, t0.status AS status_23, t0.username AS username_24, t0.postal_code AS postal_code_25, t0.is_activated AS is_activated_26, t0.online_status AS online_status_27, t0.phone_numbers AS phone_numbers_28, t0.active_role AS active_role_29, t0.active_layout AS active_layout_30, t0.active_theme AS active_theme_31, t0.email AS email_32, t0.password AS password_33, t0.is_verified AS is_verified_34, t0.is_logged_in AS is_logged_in_35, t0.gender AS gender_36, t0.first_name AS first_name_37, t0.last_name AS last_name_38, t0.other_names AS other_names_39, t0.is_deleted AS is_deleted_40, t0.deleted_at AS deleted_at_41, t0.documents AS documents_42, t0.department_id AS department_id_43, t0.created_by_id AS created_by_id_44, t0.updated_by_id AS updated_by_id_45, t0.user_type, t2.index_number AS index_number_46, t2.student_id AS student_id_47, t2.year_level AS year_level_48, t2.next_year_level AS next_year_level_49, t2.year_level_escalated AS year_level_escalated_50, t2.qualification_type AS qualification_type_51, t2.admission_date AS admission_date_52, t2.matriculation_affirmed_at AS matriculation_affirmed_at_53, t2.date_of_completion AS date_of_completion_54, t2.last_registered_at AS last_registered_at_55, t2.account_standing AS account_standing_56, t2.title AS title_57, t2.place_of_birth AS place_of_birth_58, t2.religion AS religion_59, t2.religious_denomination AS religious_denomination_60, t2.national_id_type AS national_id_type_61, t2.national_id_number AS national_id_number_62, t2.passport_number AS passport_number_63, t2.ssn AS ssn_64, t2.physical_challenge AS physical_challenge_65, t2.physical_challenge_info AS physical_challenge_info_66, t2.personal_email AS personal_email_67, t2.address_line_one AS address_line_one_68, t2.post_code AS post_code_69, t2.address_city AS address_city_70, t2.address_country AS address_country_71, t2.region AS region_72, t2.home_town AS home_town_73, t2.hometown_region AS hometown_region_74, t2.guardian_name AS guardian_name_75, t2.guardian_relationship AS guardian_relationship_76, t2.guardian_contact_number AS guardian_contact_number_77, t2.guardian_email AS guardian_email_78, t2.guardian_address_line_one AS guardian_address_line_one_79, t2.guardian_address_line_two AS guardian_address_line_two_80, t2.guardian_address_city AS guardian_address_city_81, t2.guardian_address_country AS guardian_address_country_82, t2.admission_type AS admission_type_83, t2.application_serial AS application_serial_84, t2.application_year AS application_year_85, t2.previously_attended_upsa AS previously_attended_upsa_86, t2.previous_id AS previous_id_87, t2.previous_institution AS previous_institution_88, t2.gateway_reg_no AS gateway_reg_no_89, t2.academic_status AS academic_status_90, t2.registration_status AS registration_status_91, t2.is_initial_registration_completed AS is_initial_registration_completed_92, t2.stud_prog_id AS stud_prog_id_93, t2.stud_batch_id AS stud_batch_id_94, t2.session_id AS session_id_95, t2.entry_qualification_type_id AS entry_qualification_type_id_96, t2.hall_id AS hall_id_97, t2.current_course_registration_id AS current_course_registration_id_98 FROM core_user t0 LEFT JOIN core_user_admin t1 ON t0.id = t1.id LEFT JOIN core_user_student t2 ON t0.id = t2.id WHERE t0.id = 'cddae852-9653-43f0-9a4e-86f3add23eee';