Symfony Profiler

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.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
  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_.qualification_type AS qualification_type_65,
  c4_.admission_date AS admission_date_66,
  c4_.date_of_completion AS date_of_completion_67,
  c4_.last_registered_at AS last_registered_at_68,
  c4_.account_standing AS account_standing_69,
  c4_.title AS title_70,
  c4_.place_of_birth AS place_of_birth_71,
  c4_.religion AS religion_72,
  c4_.religious_denomination AS religious_denomination_73,
  c4_.national_id_type AS national_id_type_74,
  c4_.national_id_number AS national_id_number_75,
  c4_.passport_number AS passport_number_76,
  c4_.ssn AS ssn_77,
  c4_.physical_challenge AS physical_challenge_78,
  c4_.physical_challenge_info AS physical_challenge_info_79,
  c4_.personal_email AS personal_email_80,
  c4_.address_line_one AS address_line_one_81,
  c4_.post_code AS post_code_82,
  c4_.address_city AS address_city_83,
  c4_.address_country AS address_country_84,
  c4_.region AS region_85,
  c4_.home_town AS home_town_86,
  c4_.hometown_region AS hometown_region_87,
  c4_.guardian_name AS guardian_name_88,
  c4_.guardian_relationship AS guardian_relationship_89,
  c4_.guardian_contact_number AS guardian_contact_number_90,
  c4_.guardian_email AS guardian_email_91,
  c4_.guardian_address_line_one AS guardian_address_line_one_92,
  c4_.guardian_address_line_two AS guardian_address_line_two_93,
  c4_.guardian_address_city AS guardian_address_city_94,
  c4_.guardian_address_country AS guardian_address_country_95,
  c4_.admission_type AS admission_type_96,
  c4_.application_serial AS application_serial_97,
  c4_.application_year AS application_year_98,
  c4_.previously_attended_upsa AS previously_attended_upsa_99,
  c4_.previous_id AS previous_id_100,
  c4_.previous_institution AS previous_institution_101,
  c4_.gateway_reg_no AS gateway_reg_no_102,
  c4_.academic_status AS academic_status_103,
  c4_.registration_status AS registration_status_104,
  c4_.is_initial_registration_completed AS is_initial_registration_completed_105,
  c5_.id AS id_106,
  c5_.title AS title_107,
  c5_.slug AS slug_108,
  c5_.path AS path_109,
  c5_.position AS position_110,
  c5_.date_created AS date_created_111,
  c5_.visibility AS visibility_112,
  c5_.parent_id AS parent_id_113,
  c5_.route_name AS route_name_114,
  c5_.template AS template_115,
  c5_.layout_type AS layout_type_116,
  c0_.content_type AS content_type_117,
  c0_.user_id AS user_id_118,
  c0_.term_id AS term_id_119,
  c1_.route_id AS route_id_120,
  c2_.user_type AS user_type_121,
  c2_.department_id AS department_id_122,
  c2_.created_by_id AS created_by_id_123,
  c2_.updated_by_id AS updated_by_id_124,
  c4_.stud_prog_id AS stud_prog_id_125,
  c4_.stud_batch_id AS stud_batch_id_126,
  c4_.session_id AS session_id_127,
  c4_.entry_qualification_type_id AS entry_qualification_type_id_128,
  c4_.hall_id AS hall_id_129,
  c4_.current_course_registration_id AS current_course_registration_id_130,
  c5_.route_type AS route_type_131
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_.qualification_type AS qualification_type_65, c4_.admission_date AS admission_date_66, c4_.date_of_completion AS date_of_completion_67, c4_.last_registered_at AS last_registered_at_68, c4_.account_standing AS account_standing_69, c4_.title AS title_70, c4_.place_of_birth AS place_of_birth_71, c4_.religion AS religion_72, c4_.religious_denomination AS religious_denomination_73, c4_.national_id_type AS national_id_type_74, c4_.national_id_number AS national_id_number_75, c4_.passport_number AS passport_number_76, c4_.ssn AS ssn_77, c4_.physical_challenge AS physical_challenge_78, c4_.physical_challenge_info AS physical_challenge_info_79, c4_.personal_email AS personal_email_80, c4_.address_line_one AS address_line_one_81, c4_.post_code AS post_code_82, c4_.address_city AS address_city_83, c4_.address_country AS address_country_84, c4_.region AS region_85, c4_.home_town AS home_town_86, c4_.hometown_region AS hometown_region_87, c4_.guardian_name AS guardian_name_88, c4_.guardian_relationship AS guardian_relationship_89, c4_.guardian_contact_number AS guardian_contact_number_90, c4_.guardian_email AS guardian_email_91, c4_.guardian_address_line_one AS guardian_address_line_one_92, c4_.guardian_address_line_two AS guardian_address_line_two_93, c4_.guardian_address_city AS guardian_address_city_94, c4_.guardian_address_country AS guardian_address_country_95, c4_.admission_type AS admission_type_96, c4_.application_serial AS application_serial_97, c4_.application_year AS application_year_98, c4_.previously_attended_upsa AS previously_attended_upsa_99, c4_.previous_id AS previous_id_100, c4_.previous_institution AS previous_institution_101, c4_.gateway_reg_no AS gateway_reg_no_102, c4_.academic_status AS academic_status_103, c4_.registration_status AS registration_status_104, c4_.is_initial_registration_completed AS is_initial_registration_completed_105, c5_.id AS id_106, c5_.title AS title_107, c5_.slug AS slug_108, c5_.path AS path_109, c5_.position AS position_110, c5_.date_created AS date_created_111, c5_.visibility AS visibility_112, c5_.parent_id AS parent_id_113, c5_.route_name AS route_name_114, c5_.template AS template_115, c5_.layout_type AS layout_type_116, c0_.content_type AS content_type_117, c0_.user_id AS user_id_118, c0_.term_id AS term_id_119, c1_.route_id AS route_id_120, c2_.user_type AS user_type_121, c2_.department_id AS department_id_122, c2_.created_by_id AS created_by_id_123, c2_.updated_by_id AS updated_by_id_124, c4_.stud_prog_id AS stud_prog_id_125, c4_.stud_batch_id AS stud_batch_id_126, c4_.session_id AS session_id_127, c4_.entry_qualification_type_id AS entry_qualification_type_id_128, c4_.hall_id AS hall_id_129, c4_.current_course_registration_id AS current_course_registration_id_130, c5_.route_type AS route_type_131 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
  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.qualification_type AS qualification_type_50,
  t2.admission_date AS admission_date_51,
  t2.date_of_completion AS date_of_completion_52,
  t2.last_registered_at AS last_registered_at_53,
  t2.account_standing AS account_standing_54,
  t2.title AS title_55,
  t2.place_of_birth AS place_of_birth_56,
  t2.religion AS religion_57,
  t2.religious_denomination AS religious_denomination_58,
  t2.national_id_type AS national_id_type_59,
  t2.national_id_number AS national_id_number_60,
  t2.passport_number AS passport_number_61,
  t2.ssn AS ssn_62,
  t2.physical_challenge AS physical_challenge_63,
  t2.physical_challenge_info AS physical_challenge_info_64,
  t2.personal_email AS personal_email_65,
  t2.address_line_one AS address_line_one_66,
  t2.post_code AS post_code_67,
  t2.address_city AS address_city_68,
  t2.address_country AS address_country_69,
  t2.region AS region_70,
  t2.home_town AS home_town_71,
  t2.hometown_region AS hometown_region_72,
  t2.guardian_name AS guardian_name_73,
  t2.guardian_relationship AS guardian_relationship_74,
  t2.guardian_contact_number AS guardian_contact_number_75,
  t2.guardian_email AS guardian_email_76,
  t2.guardian_address_line_one AS guardian_address_line_one_77,
  t2.guardian_address_line_two AS guardian_address_line_two_78,
  t2.guardian_address_city AS guardian_address_city_79,
  t2.guardian_address_country AS guardian_address_country_80,
  t2.admission_type AS admission_type_81,
  t2.application_serial AS application_serial_82,
  t2.application_year AS application_year_83,
  t2.previously_attended_upsa AS previously_attended_upsa_84,
  t2.previous_id AS previous_id_85,
  t2.previous_institution AS previous_institution_86,
  t2.gateway_reg_no AS gateway_reg_no_87,
  t2.academic_status AS academic_status_88,
  t2.registration_status AS registration_status_89,
  t2.is_initial_registration_completed AS is_initial_registration_completed_90,
  t2.stud_prog_id AS stud_prog_id_91,
  t2.stud_batch_id AS stud_batch_id_92,
  t2.session_id AS session_id_93,
  t2.entry_qualification_type_id AS entry_qualification_type_id_94,
  t2.hall_id AS hall_id_95,
  t2.current_course_registration_id AS current_course_registration_id_96
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.qualification_type AS qualification_type_50, t2.admission_date AS admission_date_51, t2.date_of_completion AS date_of_completion_52, t2.last_registered_at AS last_registered_at_53, t2.account_standing AS account_standing_54, t2.title AS title_55, t2.place_of_birth AS place_of_birth_56, t2.religion AS religion_57, t2.religious_denomination AS religious_denomination_58, t2.national_id_type AS national_id_type_59, t2.national_id_number AS national_id_number_60, t2.passport_number AS passport_number_61, t2.ssn AS ssn_62, t2.physical_challenge AS physical_challenge_63, t2.physical_challenge_info AS physical_challenge_info_64, t2.personal_email AS personal_email_65, t2.address_line_one AS address_line_one_66, t2.post_code AS post_code_67, t2.address_city AS address_city_68, t2.address_country AS address_country_69, t2.region AS region_70, t2.home_town AS home_town_71, t2.hometown_region AS hometown_region_72, t2.guardian_name AS guardian_name_73, t2.guardian_relationship AS guardian_relationship_74, t2.guardian_contact_number AS guardian_contact_number_75, t2.guardian_email AS guardian_email_76, t2.guardian_address_line_one AS guardian_address_line_one_77, t2.guardian_address_line_two AS guardian_address_line_two_78, t2.guardian_address_city AS guardian_address_city_79, t2.guardian_address_country AS guardian_address_country_80, t2.admission_type AS admission_type_81, t2.application_serial AS application_serial_82, t2.application_year AS application_year_83, t2.previously_attended_upsa AS previously_attended_upsa_84, t2.previous_id AS previous_id_85, t2.previous_institution AS previous_institution_86, t2.gateway_reg_no AS gateway_reg_no_87, t2.academic_status AS academic_status_88, t2.registration_status AS registration_status_89, t2.is_initial_registration_completed AS is_initial_registration_completed_90, t2.stud_prog_id AS stud_prog_id_91, t2.stud_batch_id AS stud_batch_id_92, t2.session_id AS session_id_93, t2.entry_qualification_type_id AS entry_qualification_type_id_94, t2.hall_id AS hall_id_95, t2.current_course_registration_id AS current_course_registration_id_96 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';

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 = 'cddae852-9653-43f0-9a4e-86f3add23eee';

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
  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,
  a0_.batch_id AS batch_id_9,
  a0_.created_by_id AS created_by_id_10,
  a0_.updated_by_id AS updated_by_id_11
FROM
  academic_year a0_
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, a0_.batch_id AS batch_id_9, a0_.created_by_id AS created_by_id_10, a0_.updated_by_id AS updated_by_id_11 FROM academic_year a0_ WHERE a0_.start_date <= '2026-06-17 03:50:00' AND a0_.end_date >= '2026-06-17 03:50:00' AND a0_.status = 'active' AND (a0_.is_deleted IS NULL OR a0_.is_deleted = 0) ORDER BY a0_.period 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_.slug AS slug_29,
  p2_.qualification_type AS qualification_type_30,
  p2_.field_of_study AS field_of_study_31,
  p2_.discipline AS discipline_32,
  p2_.specialization AS specialization_33,
  p2_.accreditation_body AS accreditation_body_34,
  p2_.accreditation_status AS accreditation_status_35,
  p2_.accreditation_expiry_date AS accreditation_expiry_date_36,
  p2_.duration_years AS duration_years_37,
  p2_.duration_semesters AS duration_semesters_38,
  p2_.study_mode AS study_mode_39,
  p2_.delivery_mode AS delivery_mode_40,
  p2_.intake_schedule AS intake_schedule_41,
  p2_.min_enrollment AS min_enrollment_42,
  p2_.max_enrollment AS max_enrollment_43,
  p2_.is_accepting_applications AS is_accepting_applications_44,
  p2_.administrative_contact AS administrative_contact_45,
  p2_.approval_status AS approval_status_46,
  p2_.approved_at AS approved_at_47,
  p2_.description AS description_48,
  p2_.objectives AS objectives_49,
  p2_.career_outcomes AS career_outcomes_50,
  p2_.curriculum AS curriculum_51,
  p2_.highlights AS highlights_52,
  p2_.is_featured AS is_featured_53,
  p2_.display_order AS display_order_54,
  p2_.image_url AS image_url_55,
  p2_.video_url AS video_url_56,
  p2_.brochure_url AS brochure_url_57,
  p2_.website_url AS website_url_58,
  p2_.letter_year AS letter_year_59,
  p2_.letter_template AS letter_template_60,
  p2_.letter_opening AS letter_opening_61,
  p2_.pdf_layout_group AS pdf_layout_group_62,
  p2_.created_at AS created_at_63,
  p2_.updated_at AS updated_at_64,
  p2_.status AS status_65,
  p2_.is_deleted AS is_deleted_66,
  p2_.deleted_at AS deleted_at_67,
  a0_.academic_year_id AS academic_year_id_68,
  a0_.batch_id AS batch_id_69,
  a0_.created_by_id AS created_by_id_70,
  a0_.updated_by_id AS updated_by_id_71,
  a1_.batch_id AS batch_id_72,
  a1_.created_by_id AS created_by_id_73,
  a1_.updated_by_id AS updated_by_id_74,
  p2_.session_id AS session_id_75,
  p2_.department_id AS department_id_76,
  p2_.coordinator_id AS coordinator_id_77,
  p2_.approved_by_id AS approved_by_id_78,
  p2_.created_by_id AS created_by_id_79,
  p2_.updated_by_id AS updated_by_id_80
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_.slug AS slug_29, p2_.qualification_type AS qualification_type_30, p2_.field_of_study AS field_of_study_31, p2_.discipline AS discipline_32, p2_.specialization AS specialization_33, p2_.accreditation_body AS accreditation_body_34, p2_.accreditation_status AS accreditation_status_35, p2_.accreditation_expiry_date AS accreditation_expiry_date_36, p2_.duration_years AS duration_years_37, p2_.duration_semesters AS duration_semesters_38, p2_.study_mode AS study_mode_39, p2_.delivery_mode AS delivery_mode_40, p2_.intake_schedule AS intake_schedule_41, p2_.min_enrollment AS min_enrollment_42, p2_.max_enrollment AS max_enrollment_43, p2_.is_accepting_applications AS is_accepting_applications_44, p2_.administrative_contact AS administrative_contact_45, p2_.approval_status AS approval_status_46, p2_.approved_at AS approved_at_47, p2_.description AS description_48, p2_.objectives AS objectives_49, p2_.career_outcomes AS career_outcomes_50, p2_.curriculum AS curriculum_51, p2_.highlights AS highlights_52, p2_.is_featured AS is_featured_53, p2_.display_order AS display_order_54, p2_.image_url AS image_url_55, p2_.video_url AS video_url_56, p2_.brochure_url AS brochure_url_57, p2_.website_url AS website_url_58, p2_.letter_year AS letter_year_59, p2_.letter_template AS letter_template_60, p2_.letter_opening AS letter_opening_61, p2_.pdf_layout_group AS pdf_layout_group_62, p2_.created_at AS created_at_63, p2_.updated_at AS updated_at_64, p2_.status AS status_65, p2_.is_deleted AS is_deleted_66, p2_.deleted_at AS deleted_at_67, a0_.academic_year_id AS academic_year_id_68, a0_.batch_id AS batch_id_69, a0_.created_by_id AS created_by_id_70, a0_.updated_by_id AS updated_by_id_71, a1_.batch_id AS batch_id_72, a1_.created_by_id AS created_by_id_73, a1_.updated_by_id AS updated_by_id_74, p2_.session_id AS session_id_75, p2_.department_id AS department_id_76, p2_.coordinator_id AS coordinator_id_77, p2_.approved_by_id AS approved_by_id_78, p2_.created_by_id AS created_by_id_79, p2_.updated_by_id AS updated_by_id_80 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 ('7aa7bff1-ca82-43be-a217-731f07ae522a', '4e450930-f21a-4353-8007-702381be1c10', '9ba23605-54df-444c-8d78-254b96e395fa', '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;