Query Metrics
9
Database Queries
6
Different statements
4.53 ms
Query time
13
Invalid entities
35
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.40 ms (30.91%) |
2 |
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 = ?
Parameters:
[
"f8583a61-a8e1-4a19-aa79-829409514d6a"
]
|
|
0.91 ms (20.15%) |
1 |
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, a0_.academic_year_id AS academic_year_id_16, a0_.batch_id AS batch_id_17, a0_.created_by_id AS created_by_id_18, a0_.updated_by_id AS updated_by_id_19 FROM admissions_application_period a0_ WHERE a0_.status = ? AND a0_.end_date >= ? ORDER BY a0_.start_date DESC, a0_.end_date DESC
Parameters:
[ "active" "2026-06-17 03:17:23" ] |
|
0.86 ms (19.02%) |
2 |
SELECT t0.id AS id_1, t0.period AS period_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.status AS status_7, t0.is_deleted AS is_deleted_8, t0.deleted_at AS deleted_at_9, t0.batch_id AS batch_id_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12 FROM academic_year t0 WHERE t0.id = ?
Parameters:
[
"4e450930-f21a-4353-8007-702381be1c10"
]
|
|
0.50 ms (11.05%) |
2 |
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 = ?
Parameters:
[
"cddae852-9653-43f0-9a4e-86f3add23eee"
]
|
|
0.50 ms (10.99%) |
1 |
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
Parameters:
[] |
|
0.36 ms (7.88%) |
1 |
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
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| logger | doctrine.dbal.logger_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| logger | doctrine.orm.logger_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| Fbeen\SettingsBundle\Entity\Setting | 21 |
| Boab\CmsBundle\Entity\Route | 4 |
| App\Entity\Admissions\ApplicationPeriod | 2 |
| App\Entity\Academic\AcademicYear | 2 |
| Boab\CoreBundle\Entity\User | 2 |
| App\Admin\Entity\Department\Department | 2 |
| App\Entity\Academic\Batch | 1 |
| Boab\CoreBundle\Entity\Lecturer | 1 |
logger entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| Boab\CmsBundle\Entity\Route | No errors. |
| Boab\CmsBundle\Entity\Content | No errors. |
| Boab\CmsBundle\Entity\Event | No errors. |
| Boab\CmsBundle\Entity\ListRoute | No errors. |
| Boab\CmsBundle\Entity\PostRoute | No errors. |
| Boab\CmsBundle\Entity\PageRoute | No errors. |
| Boab\CmsBundle\Entity\TermRoute | No errors. |
| Boab\CmsBundle\Entity\UrlRoute | No errors. |
| Fbeen\SettingsBundle\Entity\Setting | No errors. |
| Boab\CoreBundle\Entity\User |
|
| Boab\CoreBundle\Entity\Role | No errors. |
| Boab\CoreBundle\Entity\Module | No errors. |
| Boab\CmsBundle\Entity\Block | No errors. |
| App\Entity\ResetPasswordRequest | No errors. |
| App\Entity\Admissions\ApplicationPeriodFresherFee | No errors. |
| App\Entity\Admissions\Subject | No errors. |
| App\Entity\Admissions\ApplicationPeriodFee | No errors. |
| App\Entity\Admissions\PreviousInstitution | No errors. |
| App\Entity\Admissions\ApplicationPeriod | No errors. |
| App\Entity\Admissions\EntryQualification | No errors. |
| App\Entity\Applicant | No errors. |
| App\Entity\Chat\UserChannel | No errors. |
| App\Entity\Chat\Message | No errors. |
| App\Entity\Chat\Channel |
|
| App\Entity\Course\CourseLeadLecturer | No errors. |
| App\Entity\Institution\Campus |
|
| App\Entity\PasswordHistory | No errors. |
| App\Entity\ApplicationCode | No errors. |
| App\Entity\Academic\ProgramCreditRequirement | No errors. |
| App\Entity\Academic\Session | No errors. |
| App\Entity\Academic\AcademicYear | No errors. |
| App\Entity\Academic\CourseVersion | No errors. |
| App\Entity\Academic\Batch | No errors. |
| App\Entity\Academic\Course | No errors. |
| App\Entity\Academic\Semester |
|
| App\Entity\Academic\Program |
|
| App\Entity\DocumentType | No errors. |
| App\Entity\Setup\ContactRelationship | No errors. |
| App\Entity\Hall | No errors. |
| App\Admin\Entity\Messaging\MessageLog | No errors. |
| App\Admin\Entity\Messaging\MessageTemplate | No errors. |
| App\Admin\Entity\Core\Config | No errors. |
| App\Admin\Entity\Registration\LateRegistrationPenalty |
|
| App\Admin\Entity\Registration\ProgramElectiveRequirement | No errors. |
| App\Admin\Entity\Registration\ResitRegistrationFee |
|
| App\Admin\Entity\Registration\AddDropPeriod | No errors. |
| App\Admin\Entity\Registration\LateRegistrationPeriod | No errors. |
| App\Admin\Entity\Registration\ProgramCourseOffering | No errors. |
| App\Admin\Entity\Registration\CreditHourLimit | No errors. |
| App\Admin\Entity\Registration\CourseRegistrationPeriod | No errors. |
| App\Admin\Entity\Registration\RegistrationPeriodLevel | No errors. |
| App\Admin\Entity\Department\DepartmentExpenditure | No errors. |
| App\Admin\Entity\Department\DepartmentCostCenter | No errors. |
| App\Admin\Entity\Department\Department |
|
| App\Admin\Entity\Department\DepartmentHodHistory | No errors. |
| App\Admin\Entity\Faculty\FacultyDeanHistory | No errors. |
| App\Admin\Entity\Faculty\FacultyViceDeanHistory | No errors. |
| App\Admin\Entity\Faculty\Faculty | No errors. |
| App\Admissions\Entity\Applicant | No errors. |
| App\Admissions\Entity\AdmissionStepOverride | No errors. |
| App\Admissions\Entity\VoucherOrder | No errors. |
| App\Admissions\Entity\EducationalQualification | No errors. |
| App\Admissions\Entity\AdmissionPeriod | No errors. |
| App\Admissions\Entity\Application |
|
| App\Admissions\Entity\AdmissionLetterSequenceRule | No errors. |
| App\Admissions\Entity\Document | No errors. |
| App\Admissions\Entity\AdmissionStep | No errors. |
| App\Admissions\Entity\VoucherPayment | No errors. |
| App\Admissions\Entity\AdmissionFlowRule | No errors. |
| App\Admissions\Entity\WasseApplicant | No errors. |
| App\Admissions\Entity\PasswordResetRequest | No errors. |
| App\Admissions\Entity\ExaminationDetail | No errors. |
| App\Admissions\Entity\EmailAccountUser | No errors. |
| App\Admissions\Entity\CodeAccountUser | No errors. |
| App\Admissions\Entity\ApplicationAdmitted | No errors. |
| App\Admissions\Entity\AdmissionLetterContent | No errors. |
| App\Admissions\Entity\Remark | No errors. |
| App\Admissions\Entity\Reference | No errors. |
| App\Admissions\Entity\ExaminationResult | No errors. |
| App\Student\Entity\StudentSnapshot | No errors. |
| App\Student\Entity\Student |
|
| App\Student\Entity\StudentAdmissionLink | No errors. |
| App\Registration\Entity\CourseRegistration | No errors. |
| App\Registration\Entity\StudentCourseResult | No errors. |
| App\Registration\Entity\StudentCourseEnrollment | No errors. |
| App\Registration\Entity\Resit | No errors. |
| App\Registration\Entity\RegistrationCourseHistory | No errors. |
| App\Registration\Entity\RegistrationDocument | No errors. |
| App\Registration\Entity\RegistrationLog | No errors. |
| App\Registration\Entity\ResitLog | No errors. |
| App\Registration\Entity\ProgramCourseOfferingChange | No errors. |
| App\Registration\Entity\StudentAcademicTranscript | No errors. |
| App\Examination\Entity\LecturerSubmitResult | No errors. |
| App\Examination\Entity\GraduationFinal | No errors. |
| App\Examination\Entity\GradingSystemBreakdown | No errors. |
| App\Examination\Entity\CourseGradingSystem | No errors. |
| App\Examination\Entity\AssessmentScheme | No errors. |
| App\Examination\Entity\LetterGrading | No errors. |
| App\Examination\Entity\StudentThesis | No errors. |
| App\Examination\Entity\GradingScaleProfile | No errors. |
| App\Examination\Entity\GradingSystem | No errors. |
| App\Examination\Entity\LetterGradingUnit | No errors. |
| App\Examination\Entity\AssessmentComponent |
|
| App\Examination\Entity\LecturerSubmitChangedResult | No errors. |
| App\Examination\Entity\Faculty | No errors. |
| App\Examination\Entity\GradingScaleEntry |
|
| App\Examination\Entity\ResultEntryPeriod | No errors. |
| App\Examination\Entity\AlertRecipient | No errors. |
| App\Examination\Entity\ResultsChangeRequest | No errors. |
| App\Examination\Entity\ExaminationAlert | No errors. |
| Mgilet\NotificationBundle\Entity\NotifiableNotification | No errors. |
| Mgilet\NotificationBundle\Entity\NotifiableEntity | No errors. |
| Mgilet\NotificationBundle\Model\Notification | No errors. |
| Mgilet\NotificationBundle\Entity\Notification | No errors. |
| Boab\CoreBundle\Entity\Lecturer | No errors. |
| Boab\CoreBundle\Entity\OAuth2ClientProfile | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\AbstractClient | No errors. |
| Boab\CoreBundle\Entity\Client | No errors. |
| Boab\CoreBundle\Entity\OAuth2UserConsent | No errors. |
| Boab\CoreBundle\Entity\ConfigSection | No errors. |
| Boab\CoreBundle\Entity\Permission | No errors. |
| Boab\CoreBundle\Entity\Admin |
|
| Boab\CoreBundle\Entity\ConfigSetting | No errors. |
| Boab\CoreBundle\Entity\LoginHistory | No errors. |
| Boab\CoreBundle\Entity\UserPermission | No errors. |
| Boab\CoreBundle\Entity\DelegatedPermission | No errors. |
| Boab\CoreBundle\Entity\UserDelegation | No errors. |
| Boab\CoreBundle\Entity\RolePermission | No errors. |
| Boab\CoreBundle\Entity\Email\EmailTemplate | No errors. |
| Boab\CoreBundle\Entity\Email\EmailLog | No errors. |
| Boab\CmsBundle\Entity\Role | No errors. |
| Boab\CmsBundle\Entity\Project | No errors. |
| Boab\CmsBundle\Entity\Vocabulary | No errors. |
| Boab\CmsBundle\Entity\Video | No errors. |
| Boab\CmsBundle\Entity\User | No errors. |
| Boab\CmsBundle\Entity\Audio | No errors. |
| Boab\CmsBundle\Entity\Document | No errors. |
| Boab\CmsBundle\Entity\Page | No errors. |
| Boab\CmsBundle\Entity\Article | No errors. |
| Boab\CmsBundle\Entity\Media | No errors. |
| Boab\CmsBundle\Entity\Term | No errors. |
| Boab\CmsBundle\Entity\RouteMetadata | No errors. |
| Boab\CmsBundle\Entity\Photo | No errors. |
| Boab\CmsBundle\Entity\News | No errors. |
| Boab\CmsBundle\Entity\Album | No errors. |
| Boab\AuthorizationWorkflowBundle\Entity\Stage | No errors. |
| Boab\AuthorizationWorkflowBundle\Entity\WorkflowAudit | No errors. |
| Boab\AuthorizationWorkflowBundle\Entity\ItemStage | No errors. |
| Boab\AuthorizationWorkflowBundle\Entity\WorkflowEvent | No errors. |
| Boab\AuthorizationWorkflowBundle\Entity\WorkflowConfiguration | No errors. |
| Boab\AuthorizationWorkflowBundle\Entity\WorkflowData | No errors. |
| Boab\AuthorizationWorkflowBundle\Entity\ItemWorkflow | No errors. |
| Boab\QueueBundle\Entity\Job | No errors. |
| Boab\QueueBundle\Entity\ProcessJob | No errors. |
| Boab\QueueBundle\Entity\JobLog | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\AuthorizationCode | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\RefreshToken | No errors. |
| League\Bundle\OAuth2ServerBundle\Model\AccessToken | No errors. |
logger entity manager
No loaded entities.