GET https://rmp.wgu.edu.et/am/register

Query Metrics

8 Database Queries
7 Different statements
4.48 ms Query time
2 Invalid entities
1 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.92 ms
(20.57%)
2
SELECT t0.id AS id_1, t0.assigned_at AS assigned_at_2, t0.status AS status_3, t0.role AS role_4, t0.bio AS bio_5, t0.uid AS uid_6, t0.user_id AS user_id_7, t0.assigned_by_id AS assigned_by_id_8 FROM board_member t0 WHERE t0.role = ? LIMIT 1
Parameters:
[
  "Chair"
]
0.84 ms
(18.74%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.start_date AS start_date_3, t0.end_date AS end_date_4, t0.description AS description_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.ibcode AS ibcode_8, t0.requested_exclusion_participant AS requested_exclusion_participant_9, t0.uid AS uid_10, t0.research_locations AS research_locations_11, t0.keywords AS keywords_12, t0.fda_no AS fda_no_13, t0.fda_name AS fda_name_14, t0.fda_sponsor AS fda_sponsor_15, t0.holder AS holder_16, t0.ind AS ind_17, t0.study_site AS study_site_18, t0.submitted_by_id AS submitted_by_id_19, t0.report_expectation_period_id AS report_expectation_period_id_20, t0.study_population_id AS study_population_id_21, t0.ionizing_radiation_use_id AS ionizing_radiation_use_id_22, t0.proceedure_use_id AS proceedure_use_id_23, t0.multi_site_collaboration_id AS multi_site_collaboration_id_24, t0.financial_disclosure_id AS financial_disclosure_id_25, t0.review_mode_id AS review_mode_id_26, t0.status_id AS status_id_27, t0.rexecpart_id AS rexecpart_id_28, t0.age_range_id AS age_range_id_29, t0.pediatric_cp_id AS pediatric_cp_id_30, t0.impaired_cp_id AS impaired_cp_id_31, t0.app_type_id AS app_type_id_32, t0.study_location_id AS study_location_id_33, t0.region_id AS region_id_34 FROM application t0
Parameters:
[]
0.65 ms
(14.60%)
1
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.description AS description_2, d0_.created_at AS created_at_3, d0_.acronym AS acronym_4, d0_.updated_at AS updated_at_5 FROM directorate d0_
Parameters:
[]
0.63 ms
(14.05%)
1
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.category AS category_2 FROM research_theme r0_
Parameters:
[]
0.60 ms
(13.44%)
1
SELECT t0.id AS id_1, t0.approved_at AS approved_at_2, t0.certificate_code AS certificate_code_3, t0.valid_until AS valid_until_4, t0.valid_from AS valid_from_5, t0.chair_approval AS chair_approval_6, t0.vice_approval AS vice_approval_7, t0.uid AS uid_8, t0.irb_application_id AS irb_application_id_9, t0.approved_by_id AS approved_by_id_10, t0.th_agenda_id AS th_agenda_id_11, t0.meeting_minute_id AS meeting_minute_id_12 FROM irb_certificate t0
Parameters:
[]
0.48 ms
(10.81%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM task_type t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "REPORT"
]
0.35 ms
(7.79%)
1
SELECT t0.id AS id_1, t0.assigned_at AS assigned_at_2, t0.status AS status_3, t0.role AS role_4, t0.bio AS bio_5, t0.uid AS uid_6, t0.user_id AS user_id_7, t0.assigned_by_id AS assigned_by_id_8 FROM board_member t0 WHERE t0.role = ?
Parameters:
[
  "Secretary"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Directorate 1

Entities Mapping

Class Mapping errors
App\Entity\SERO\Application No errors.
App\Entity\User No errors.
App\Entity\SERO\ReportExpectationPeriod No errors.
App\Entity\SERO\StudyPopulation No errors.
App\Entity\SERO\IonizingRadiationUse No errors.
App\Entity\SERO\ProceedureUse No errors.
App\Entity\SERO\MultiSiteCollaboration No errors.
App\Entity\SERO\FinancialDisclosure No errors.
App\Entity\SERO\DecisionType No errors.
App\Entity\SERO\Status No errors.
App\Entity\SERO\Reexecpart No errors.
App\Entity\SERO\AgeRangeCP No errors.
App\Entity\SERO\Pediatric No errors.
App\Entity\SERO\ImpairedCP No errors.
App\Entity\SERO\ApplicationType No errors.
App\Entity\SERO\City No errors.
App\Entity\SERO\Region No errors.
App\Entity\SERO\IrbCertificate No errors.
App\Entity\SERO\Agenda
  • The association App\Entity\SERO\Agenda#meetingNo refers to the inverse side field App\Entity\SERO\Meeting#agendas which does not exist.
App\Entity\SERO\Meeting
  • The mappings App\Entity\SERO\Meeting#minuteTakenBy and App\Entity\User#meetings are inconsistent with each other.
App\Entity\SERO\BoardMember No errors.
App\Entity\SERO\TaskType No errors.
App\Entity\Directorate No errors.
App\Entity\SERO\ResearchTheme No errors.
App\Entity\Profile No errors.