Query Metrics
8
Database Queries
8
Different statements
1153.03 ms
Query time
0
Invalid entities
Grouped Statements
camden connection
| Time▼ | Count | Info |
|---|---|---|
|
1023.29 ms (88.75%) |
1 |
EXEC [dbo].[stp_API_webenrol] @webenrolVersion = 5, @page =?,@action='getCourseInfo',@username=?,@entityURL=?,@context='webenrol',@subdomain=?,@courseCode =?
Parameters:
[ "courseDetail" null "camden" "dev" "HACL35C25" ] |
|
88.42 ms (7.67%) |
1 |
EXEC [dbo].[stp_API_webenrol] @webenrolVersion = 5, @page =?,@action='getCourseDetail',@username=?,@entityURL=?,@context='webenrol',@subdomain=?,@courseCode =?,@sessionID =?
Parameters:
[ "courseDetail" null "camden" "dev" "HACL35C25" null ] |
|
19.57 ms (1.70%) |
1 |
EXEC [dbo].[stp_API_webenrol] @subdomain=?, @page = ?, @action='attention', @context = 'webenrol', @username=?, @courseCode=?
Parameters:
[ "dev" "courseDetail" null "HACL35C25" ] |
|
13.18 ms (1.14%) |
1 |
EXEC [dbo].[stp_API_webenrol] @webenrolVersion = 5, @page ='courseDetail',@action='getCourseSessions',@username=?,@entityURL=?,@context='webenrol',@subdomain=?,@courseCode =?
Parameters:
[ null "camden" "dev" "HACL35C25" ] |
|
6.73 ms (0.58%) |
1 |
EXEC [dbo].[stp_API_webenrol] @subdomain=?, @action='getNavPages', @context='webenrol', @entityUrl = ?, @page = ?, @username=?, @sessionID = ?
Parameters:
[ "dev" "camden" "courseDetail" null null ] |
|
0.69 ms (0.06%) |
1 |
EXEC [dbo].[stp_API_webenrol] @subdomain=?, @context = 'webenrol', @action='getPageContent', @entityUrl=?, @page = ?, @username = ?, @sessionID = ?, @courseCode = ?, @sectionID = ?
Parameters:
[ "dev" "camden" "courseDetail" null null null null ] |
|
0.59 ms (0.05%) |
1 |
EXEC [dbo].[stp_webenrol_getFooter]
Parameters:
[ "dev" "camden" null ] |
|
0.55 ms (0.05%) |
1 |
EXEC [dbo].[stp_API_webenrol] @entityURL = ?, @subdomain=?, @context = 'webenrol', @action='getcards', @page=?, @username=?
Parameters:
[ "camden" "dev" "courseDetail" null ] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| skillsandlearningace | doctrine.dbal.skillsandlearningace_connection |
| skillsandlearningaceWrite | doctrine.dbal.skillsandlearningaceWrite_connection |
| bristolcourses | doctrine.dbal.bristolcourses_connection |
| bristolcoursesWrite | doctrine.dbal.bristolcoursesWrite_connection |
| camden | doctrine.dbal.camden_connection |
| camdenWrite | doctrine.dbal.camdenWrite_connection |
| greenwich | doctrine.dbal.greenwich_connection |
| greenwichWrite | doctrine.dbal.greenwichWrite_connection |
| haringeylearns | doctrine.dbal.haringeylearns_connection |
| haringeylearnsWrite | doctrine.dbal.haringeylearnsWrite_connection |
| learnharrow | doctrine.dbal.learnharrow_connection |
| learnharrowWrite | doctrine.dbal.learnharrowWrite_connection |
| hertfordshire | doctrine.dbal.hertfordshire_connection |
| hertfordshireWrite | doctrine.dbal.hertfordshireWrite_connection |
| islington | doctrine.dbal.islington_connection |
| islingtonWrite | doctrine.dbal.islingtonWrite_connection |
| lambeth | doctrine.dbal.lambeth_connection |
| lambethWrite | doctrine.dbal.lambethWrite_connection |
| portsmouth | doctrine.dbal.portsmouth_connection |
| portsmouthWrite | doctrine.dbal.portsmouthWrite_connection |
| rbkc | doctrine.dbal.rbkc_connection |
| rbkcWrite | doctrine.dbal.rbkcWrite_connection |
| ebclass | doctrine.dbal.ebclass_connection |
| ebclassWrite | doctrine.dbal.ebclassWrite_connection |
| southampton | doctrine.dbal.southampton_connection |
| southamptonWrite | doctrine.dbal.southamptonWrite_connection |
| southwark | doctrine.dbal.southwark_connection |
| southwarkWrite | doctrine.dbal.southwarkWrite_connection |
| swindon | doctrine.dbal.swindon_connection |
| swindonWrite | doctrine.dbal.swindonWrite_connection |
| wessex | doctrine.dbal.wessex_connection |
| wessexWrite | doctrine.dbal.wessexWrite_connection |
| westberks | doctrine.dbal.westberks_connection |
| westberksWrite | doctrine.dbal.westberksWrite_connection |
| westsussex | doctrine.dbal.westsussex_connection |
| westsussexWrite | doctrine.dbal.westsussexWrite_connection |
| wokingham | doctrine.dbal.wokingham_connection |
| wokinghamWrite | doctrine.dbal.wokinghamWrite_connection |
| wolverhampton | doctrine.dbal.wolverhampton_connection |
| wolverhamptonWrite | doctrine.dbal.wolverhamptonWrite_connection |
| learnHarrow | doctrine.dbal.learnHarrow_connection |
| learnHarrowWrite | doctrine.dbal.learnHarrowWrite_connection |
Entity Managers
| Name | Service |
|---|---|
| skillsandlearningace | doctrine.orm.skillsandlearningace_entity_manager |
| skillsandlearningaceWrite | doctrine.orm.skillsandlearningaceWrite_entity_manager |
| bristolcourses | doctrine.orm.bristolcourses_entity_manager |
| bristolcoursesWrite | doctrine.orm.bristolcoursesWrite_entity_manager |
| camden | doctrine.orm.camden_entity_manager |
| camdenWrite | doctrine.orm.camdenWrite_entity_manager |
| greenwich | doctrine.orm.greenwich_entity_manager |
| greenwichWrite | doctrine.orm.greenwichWrite_entity_manager |
| haringeylearns | doctrine.orm.haringeylearns_entity_manager |
| haringeylearnsWrite | doctrine.orm.haringeylearnsWrite_entity_manager |
| learnharrow | doctrine.orm.learnharrow_entity_manager |
| learnharrowWrite | doctrine.orm.learnharrowWrite_entity_manager |
| hertfordshire | doctrine.orm.hertfordshire_entity_manager |
| hertfordshireWrite | doctrine.orm.hertfordshireWrite_entity_manager |
| islington | doctrine.orm.islington_entity_manager |
| islingtonWrite | doctrine.orm.islingtonWrite_entity_manager |
| lambeth | doctrine.orm.lambeth_entity_manager |
| lambethWrite | doctrine.orm.lambethWrite_entity_manager |
| portsmouth | doctrine.orm.portsmouth_entity_manager |
| portsmouthWrite | doctrine.orm.portsmouthWrite_entity_manager |
| rbkc | doctrine.orm.rbkc_entity_manager |
| rbkcWrite | doctrine.orm.rbkcWrite_entity_manager |
| ebclass | doctrine.orm.ebclass_entity_manager |
| ebclassWrite | doctrine.orm.ebclassWrite_entity_manager |
| southampton | doctrine.orm.southampton_entity_manager |
| southamptonWrite | doctrine.orm.southamptonWrite_entity_manager |
| southwark | doctrine.orm.southwark_entity_manager |
| southwarkWrite | doctrine.orm.southwarkWrite_entity_manager |
| swindon | doctrine.orm.swindon_entity_manager |
| swindonWrite | doctrine.orm.swindonWrite_entity_manager |
| wessex | doctrine.orm.wessex_entity_manager |
| wessexWrite | doctrine.orm.wessexWrite_entity_manager |
| westberks | doctrine.orm.westberks_entity_manager |
| westberksWrite | doctrine.orm.westberksWrite_entity_manager |
| westsussex | doctrine.orm.westsussex_entity_manager |
| westsussexWrite | doctrine.orm.westsussexWrite_entity_manager |
| wokingham | doctrine.orm.wokingham_entity_manager |
| wokinghamWrite | doctrine.orm.wokinghamWrite_entity_manager |
| wolverhampton | doctrine.orm.wolverhampton_entity_manager |
| wolverhamptonWrite | doctrine.orm.wolverhamptonWrite_entity_manager |
| default | doctrine.orm.default_entity_manager |
| learnHarrow | doctrine.orm.learnHarrow_entity_manager |
| learnHarrowWrite | doctrine.orm.learnHarrowWrite_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
skillsandlearningace entity manager
No loaded entities.
skillsandlearningaceWrite entity manager
No loaded entities.
bristolcourses entity manager
No loaded entities.
bristolcoursesWrite entity manager
No loaded entities.
camden entity manager
No loaded entities.
camdenWrite entity manager
No loaded entities.
greenwich entity manager
No loaded entities.
greenwichWrite entity manager
No loaded entities.
haringeylearns entity manager
No loaded entities.
haringeylearnsWrite entity manager
No loaded entities.
learnharrow entity manager
No loaded entities.
learnharrowWrite entity manager
No loaded entities.
hertfordshire entity manager
No loaded entities.
hertfordshireWrite entity manager
No loaded entities.
islington entity manager
No loaded entities.
islingtonWrite entity manager
No loaded entities.
lambeth entity manager
No loaded entities.
lambethWrite entity manager
No loaded entities.
portsmouth entity manager
No loaded entities.
portsmouthWrite entity manager
No loaded entities.
rbkc entity manager
No loaded entities.
rbkcWrite entity manager
No loaded entities.
ebclass entity manager
No loaded entities.
ebclassWrite entity manager
No loaded entities.
southampton entity manager
No loaded entities.
southamptonWrite entity manager
No loaded entities.
southwark entity manager
No loaded entities.
southwarkWrite entity manager
No loaded entities.
swindon entity manager
No loaded entities.
swindonWrite entity manager
No loaded entities.
wessex entity manager
No loaded entities.
wessexWrite entity manager
No loaded entities.
westberks entity manager
No loaded entities.
westberksWrite entity manager
No loaded entities.
westsussex entity manager
No loaded entities.
westsussexWrite entity manager
No loaded entities.
wokingham entity manager
No loaded entities.
wokinghamWrite entity manager
No loaded entities.
wolverhampton entity manager
No loaded entities.
wolverhamptonWrite entity manager
No loaded entities.
default entity manager
No loaded entities.
learnHarrow entity manager
No loaded entities.
learnHarrowWrite entity manager
No loaded entities.