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_.date_of_completion AS date_of_completion_68,
  c4_.last_registered_at AS last_registered_at_69,
  c4_.account_standing AS account_standing_70,
  c4_.title AS title_71,
  c4_.place_of_birth AS place_of_birth_72,
  c4_.religion AS religion_73,
  c4_.religious_denomination AS religious_denomination_74,
  c4_.national_id_type AS national_id_type_75,
  c4_.national_id_number AS national_id_number_76,
  c4_.passport_number AS passport_number_77,
  c4_.ssn AS ssn_78,
  c4_.physical_challenge AS physical_challenge_79,
  c4_.physical_challenge_info AS physical_challenge_info_80,
  c4_.personal_email AS personal_email_81,
  c4_.address_line_one AS address_line_one_82,
  c4_.post_code AS post_code_83,
  c4_.address_city AS address_city_84,
  c4_.address_country AS address_country_85,
  c4_.region AS region_86,
  c4_.home_town AS home_town_87,
  c4_.hometown_region AS hometown_region_88,
  c4_.guardian_name AS guardian_name_89,
  c4_.guardian_relationship AS guardian_relationship_90,
  c4_.guardian_contact_number AS guardian_contact_number_91,
  c4_.guardian_email AS guardian_email_92,
  c4_.guardian_address_line_one AS guardian_address_line_one_93,
  c4_.guardian_address_line_two AS guardian_address_line_two_94,
  c4_.guardian_address_city AS guardian_address_city_95,
  c4_.guardian_address_country AS guardian_address_country_96,
  c4_.admission_type AS admission_type_97,
  c4_.application_serial AS application_serial_98,
  c4_.application_year AS application_year_99,
  c4_.previously_attended_upsa AS previously_attended_upsa_100,
  c4_.previous_id AS previous_id_101,
  c4_.previous_institution AS previous_institution_102,
  c4_.gateway_reg_no AS gateway_reg_no_103,
  c4_.academic_status AS academic_status_104,
  c4_.registration_status AS registration_status_105,
  c4_.is_initial_registration_completed AS is_initial_registration_completed_106,
  c5_.id AS id_107,
  c5_.title AS title_108,
  c5_.slug AS slug_109,
  c5_.path AS path_110,
  c5_.position AS position_111,
  c5_.date_created AS date_created_112,
  c5_.visibility AS visibility_113,
  c5_.parent_id AS parent_id_114,
  c5_.route_name AS route_name_115,
  c5_.template AS template_116,
  c5_.layout_type AS layout_type_117,
  c0_.content_type AS content_type_118,
  c0_.user_id AS user_id_119,
  c0_.term_id AS term_id_120,
  c1_.route_id AS route_id_121,
  c2_.user_type AS user_type_122,
  c2_.department_id AS department_id_123,
  c2_.created_by_id AS created_by_id_124,
  c2_.updated_by_id AS updated_by_id_125,
  c4_.stud_prog_id AS stud_prog_id_126,
  c4_.stud_batch_id AS stud_batch_id_127,
  c4_.session_id AS session_id_128,
  c4_.entry_qualification_type_id AS entry_qualification_type_id_129,
  c4_.hall_id AS hall_id_130,
  c4_.current_course_registration_id AS current_course_registration_id_131,
  c5_.route_type AS route_type_132
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_.date_of_completion AS date_of_completion_68, c4_.last_registered_at AS last_registered_at_69, c4_.account_standing AS account_standing_70, c4_.title AS title_71, c4_.place_of_birth AS place_of_birth_72, c4_.religion AS religion_73, c4_.religious_denomination AS religious_denomination_74, c4_.national_id_type AS national_id_type_75, c4_.national_id_number AS national_id_number_76, c4_.passport_number AS passport_number_77, c4_.ssn AS ssn_78, c4_.physical_challenge AS physical_challenge_79, c4_.physical_challenge_info AS physical_challenge_info_80, c4_.personal_email AS personal_email_81, c4_.address_line_one AS address_line_one_82, c4_.post_code AS post_code_83, c4_.address_city AS address_city_84, c4_.address_country AS address_country_85, c4_.region AS region_86, c4_.home_town AS home_town_87, c4_.hometown_region AS hometown_region_88, c4_.guardian_name AS guardian_name_89, c4_.guardian_relationship AS guardian_relationship_90, c4_.guardian_contact_number AS guardian_contact_number_91, c4_.guardian_email AS guardian_email_92, c4_.guardian_address_line_one AS guardian_address_line_one_93, c4_.guardian_address_line_two AS guardian_address_line_two_94, c4_.guardian_address_city AS guardian_address_city_95, c4_.guardian_address_country AS guardian_address_country_96, c4_.admission_type AS admission_type_97, c4_.application_serial AS application_serial_98, c4_.application_year AS application_year_99, c4_.previously_attended_upsa AS previously_attended_upsa_100, c4_.previous_id AS previous_id_101, c4_.previous_institution AS previous_institution_102, c4_.gateway_reg_no AS gateway_reg_no_103, c4_.academic_status AS academic_status_104, c4_.registration_status AS registration_status_105, c4_.is_initial_registration_completed AS is_initial_registration_completed_106, c5_.id AS id_107, c5_.title AS title_108, c5_.slug AS slug_109, c5_.path AS path_110, c5_.position AS position_111, c5_.date_created AS date_created_112, c5_.visibility AS visibility_113, c5_.parent_id AS parent_id_114, c5_.route_name AS route_name_115, c5_.template AS template_116, c5_.layout_type AS layout_type_117, c0_.content_type AS content_type_118, c0_.user_id AS user_id_119, c0_.term_id AS term_id_120, c1_.route_id AS route_id_121, c2_.user_type AS user_type_122, c2_.department_id AS department_id_123, c2_.created_by_id AS created_by_id_124, c2_.updated_by_id AS updated_by_id_125, c4_.stud_prog_id AS stud_prog_id_126, c4_.stud_batch_id AS stud_batch_id_127, c4_.session_id AS session_id_128, c4_.entry_qualification_type_id AS entry_qualification_type_id_129, c4_.hall_id AS hall_id_130, c4_.current_course_registration_id AS current_course_registration_id_131, c5_.route_type AS route_type_132 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 = '3' 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.year_level_escalated AS year_level_escalated_50,
  t2.qualification_type AS qualification_type_51,
  t2.admission_date AS admission_date_52,
  t2.date_of_completion AS date_of_completion_53,
  t2.last_registered_at AS last_registered_at_54,
  t2.account_standing AS account_standing_55,
  t2.title AS title_56,
  t2.place_of_birth AS place_of_birth_57,
  t2.religion AS religion_58,
  t2.religious_denomination AS religious_denomination_59,
  t2.national_id_type AS national_id_type_60,
  t2.national_id_number AS national_id_number_61,
  t2.passport_number AS passport_number_62,
  t2.ssn AS ssn_63,
  t2.physical_challenge AS physical_challenge_64,
  t2.physical_challenge_info AS physical_challenge_info_65,
  t2.personal_email AS personal_email_66,
  t2.address_line_one AS address_line_one_67,
  t2.post_code AS post_code_68,
  t2.address_city AS address_city_69,
  t2.address_country AS address_country_70,
  t2.region AS region_71,
  t2.home_town AS home_town_72,
  t2.hometown_region AS hometown_region_73,
  t2.guardian_name AS guardian_name_74,
  t2.guardian_relationship AS guardian_relationship_75,
  t2.guardian_contact_number AS guardian_contact_number_76,
  t2.guardian_email AS guardian_email_77,
  t2.guardian_address_line_one AS guardian_address_line_one_78,
  t2.guardian_address_line_two AS guardian_address_line_two_79,
  t2.guardian_address_city AS guardian_address_city_80,
  t2.guardian_address_country AS guardian_address_country_81,
  t2.admission_type AS admission_type_82,
  t2.application_serial AS application_serial_83,
  t2.application_year AS application_year_84,
  t2.previously_attended_upsa AS previously_attended_upsa_85,
  t2.previous_id AS previous_id_86,
  t2.previous_institution AS previous_institution_87,
  t2.gateway_reg_no AS gateway_reg_no_88,
  t2.academic_status AS academic_status_89,
  t2.registration_status AS registration_status_90,
  t2.is_initial_registration_completed AS is_initial_registration_completed_91,
  t2.stud_prog_id AS stud_prog_id_92,
  t2.stud_batch_id AS stud_batch_id_93,
  t2.session_id AS session_id_94,
  t2.entry_qualification_type_id AS entry_qualification_type_id_95,
  t2.hall_id AS hall_id_96,
  t2.current_course_registration_id AS current_course_registration_id_97
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.date_of_completion AS date_of_completion_53, t2.last_registered_at AS last_registered_at_54, t2.account_standing AS account_standing_55, t2.title AS title_56, t2.place_of_birth AS place_of_birth_57, t2.religion AS religion_58, t2.religious_denomination AS religious_denomination_59, t2.national_id_type AS national_id_type_60, t2.national_id_number AS national_id_number_61, t2.passport_number AS passport_number_62, t2.ssn AS ssn_63, t2.physical_challenge AS physical_challenge_64, t2.physical_challenge_info AS physical_challenge_info_65, t2.personal_email AS personal_email_66, t2.address_line_one AS address_line_one_67, t2.post_code AS post_code_68, t2.address_city AS address_city_69, t2.address_country AS address_country_70, t2.region AS region_71, t2.home_town AS home_town_72, t2.hometown_region AS hometown_region_73, t2.guardian_name AS guardian_name_74, t2.guardian_relationship AS guardian_relationship_75, t2.guardian_contact_number AS guardian_contact_number_76, t2.guardian_email AS guardian_email_77, t2.guardian_address_line_one AS guardian_address_line_one_78, t2.guardian_address_line_two AS guardian_address_line_two_79, t2.guardian_address_city AS guardian_address_city_80, t2.guardian_address_country AS guardian_address_country_81, t2.admission_type AS admission_type_82, t2.application_serial AS application_serial_83, t2.application_year AS application_year_84, t2.previously_attended_upsa AS previously_attended_upsa_85, t2.previous_id AS previous_id_86, t2.previous_institution AS previous_institution_87, t2.gateway_reg_no AS gateway_reg_no_88, t2.academic_status AS academic_status_89, t2.registration_status AS registration_status_90, t2.is_initial_registration_completed AS is_initial_registration_completed_91, t2.stud_prog_id AS stud_prog_id_92, t2.stud_batch_id AS stud_batch_id_93, t2.session_id AS session_id_94, t2.entry_qualification_type_id AS entry_qualification_type_id_95, t2.hall_id AS hall_id_96, t2.current_course_registration_id AS current_course_registration_id_97 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
  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 = 'cddae852-9653-43f0-9a4e-86f3add23eee';

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;