GET https://srnb.penguin-dev.co.uk/register

Response
200 OK
IP
216.73.216.221
Profiled on
Token
c65b5c

Query Metrics

26 Database Queries
12 Different statements
13.99 ms Query time
2 Invalid entities
45 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.88 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.`key` AS key_4, t0.value AS value_5 FROM system_config t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 0.59 ms 
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.time_submitted AS time_submitted_3, c0_.submitted AS submitted_4, c0_.passed AS passed_5, c0_.pass_rate AS pass_rate_6, c0_.user_id AS user_id_7, c0_.admission_id AS admission_id_8, c0_.assessment_id AS assessment_id_9 FROM clients_userassessments c0_ WHERE c0_.user_id IS NULL AND c0_.submitted = ? LIMIT 1
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
3 0.88 ms 
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.name AS name_3, c0_.content AS content_4, c0_.slug AS slug_5, c0_.path AS path_6, c0_.primary_image AS primary_image_7, c0_.seo_page_title AS seo_page_title_8, c0_.seo_description AS seo_description_9, c0_.seo_keywords AS seo_keywords_10, c0_.html_head AS html_head_11, c0_.display_order AS display_order_12, c0_.parent_id AS parent_id_13, c0_.project_id AS project_id_14 FROM content_pages_page c0_ WHERE c0_.path = ? LIMIT 1
Parameters: 
[
  "register"
]
View formatted query    View runnable query    Explain query
4 0.54 ms 
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.block_name AS block_name_3, c0_.is_visible AS is_visible_4, c0_.data AS data_5, c0_.page_id AS page_id_6 FROM content_pages_block c0_ WHERE c0_.id = ? LIMIT 1
Parameters: 
[
  113
]
View formatted query    View runnable query    Explain query
5 0.51 ms 
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.total_admissions AS total_admissions_3, c0_.admissions_used AS admissions_used_4, c0_.code AS code_5, c0_.expiry AS expiry_6, c0_.client_id AS client_id_7, c0_.course_id AS course_id_8, c0_.sales_order_item_id AS sales_order_item_id_9 FROM clients_code c0_ WHERE c0_.uuid IS NULL LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 0.64 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.domain AS domain_5, t0.logo AS logo_6, t0.publish_on_shop AS publish_on_shop_7, t0.display_order AS display_order_8, t0.code_head AS code_head_9, t0.code_body AS code_body_10 FROM projects_project t0 WHERE t0.domain = ? LIMIT 1
Parameters: 
[
  "srnb.penguin-dev.co.uk"
]
View formatted query    View runnable query    Explain query
7 0.63 ms 
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.modified AS modified_3, c0_.identifier AS identifier_4, c0_.name AS name_5, c0_.is_locked AS is_locked_6, c0_.disable_child_items AS disable_child_items_7, c0_.project_id AS project_id_8 FROM content_menus_menu c0_ WHERE c0_.identifier = ? AND c0_.project_id IS NULL LIMIT 1
Parameters: 
[
  "primary"
]
View formatted query    View runnable query    Explain query
8 0.67 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.menu_id = ? ORDER BY t0.display_order ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
9 0.71 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.content AS content_5, t0.slug AS slug_6, t0.path AS path_7, t0.primary_image AS primary_image_8, t0.seo_page_title AS seo_page_title_9, t0.seo_description AS seo_description_10, t0.seo_keywords AS seo_keywords_11, t0.html_head AS html_head_12, t0.display_order AS display_order_13, t0.parent_id AS parent_id_14, t0.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
10 0.53 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters: 
[
  3
]
View formatted query    View runnable query    Explain query
11 0.46 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.content AS content_5, t0.slug AS slug_6, t0.path AS path_7, t0.primary_image AS primary_image_8, t0.seo_page_title AS seo_page_title_9, t0.seo_description AS seo_description_10, t0.seo_keywords AS seo_keywords_11, t0.html_head AS html_head_12, t0.display_order AS display_order_13, t0.parent_id AS parent_id_14, t0.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = ?
Parameters: 
[
  34
]
View formatted query    View runnable query    Explain query
12 0.54 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters: 
[
  50
]
View formatted query    View runnable query    Explain query
13 0.49 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters: 
[
  61
]
View formatted query    View runnable query    Explain query
14 0.44 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.content AS content_5, t0.slug AS slug_6, t0.path AS path_7, t0.primary_image AS primary_image_8, t0.seo_page_title AS seo_page_title_9, t0.seo_description AS seo_description_10, t0.seo_keywords AS seo_keywords_11, t0.html_head AS html_head_12, t0.display_order AS display_order_13, t0.parent_id AS parent_id_14, t0.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = ?
Parameters: 
[
  4
]
View formatted query    View runnable query    Explain query
15 0.45 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters: 
[
  53
]
View formatted query    View runnable query    Explain query
16 0.41 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.content AS content_5, t0.slug AS slug_6, t0.path AS path_7, t0.primary_image AS primary_image_8, t0.seo_page_title AS seo_page_title_9, t0.seo_description AS seo_description_10, t0.seo_keywords AS seo_keywords_11, t0.html_head AS html_head_12, t0.display_order AS display_order_13, t0.parent_id AS parent_id_14, t0.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = ?
Parameters: 
[
  38
]
View formatted query    View runnable query    Explain query
17 0.42 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters: 
[
  60
]
View formatted query    View runnable query    Explain query
18 0.33 ms 
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.tag AS tag_3, c0_.replacement AS replacement_4 FROM content_tags_tag c0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
19 0.58 ms 
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.modified AS modified_3, c0_.identifier AS identifier_4, c0_.name AS name_5, c0_.is_locked AS is_locked_6, c0_.disable_child_items AS disable_child_items_7, c0_.project_id AS project_id_8 FROM content_menus_menu c0_ WHERE c0_.identifier = ? LIMIT 1
Parameters: 
[
  "footer"
]
View formatted query    View runnable query    Explain query
20 0.49 ms 
SELECT c0_.id AS id_0, c0_.uuid AS uuid_1, c0_.created AS created_2, c0_.modified AS modified_3, c0_.identifier AS identifier_4, c0_.name AS name_5, c0_.is_locked AS is_locked_6, c0_.disable_child_items AS disable_child_items_7, c0_.project_id AS project_id_8 FROM content_menus_menu c0_ WHERE c0_.identifier = ? AND c0_.project_id IS NULL LIMIT 1
Parameters: 
[
  "footer"
]
View formatted query    View runnable query    Explain query
21 0.55 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.menu_id = ? ORDER BY t0.display_order ASC
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
22 0.45 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
23 0.43 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.content AS content_5, t0.slug AS slug_6, t0.path AS path_7, t0.primary_image AS primary_image_8, t0.seo_page_title AS seo_page_title_9, t0.seo_description AS seo_description_10, t0.seo_keywords AS seo_keywords_11, t0.html_head AS html_head_12, t0.display_order AS display_order_13, t0.parent_id AS parent_id_14, t0.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
24 0.46 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters: 
[
  6
]
View formatted query    View runnable query    Explain query
25 0.42 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.name AS name_4, t0.content AS content_5, t0.slug AS slug_6, t0.path AS path_7, t0.primary_image AS primary_image_8, t0.seo_page_title AS seo_page_title_9, t0.seo_description AS seo_description_10, t0.seo_keywords AS seo_keywords_11, t0.html_head AS html_head_12, t0.display_order AS display_order_13, t0.parent_id AS parent_id_14, t0.project_id AS project_id_15 FROM content_pages_page t0 WHERE t0.id = ?
Parameters: 
[
  28
]
View formatted query    View runnable query    Explain query
26 0.47 ms 
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created AS created_3, t0.modified AS modified_4, t0.label AS label_5, t0.url AS url_6, t0.auto_update AS auto_update_7, t0.open_new_window AS open_new_window_8, t0.display_order AS display_order_9, t0.type AS type_10, t0.menu_id AS menu_id_11, t0.page_id AS page_id_12, t0.parent_id AS parent_id_13 FROM content_menus_menuitem t0 WHERE t0.parent_id = ? ORDER BY t0.display_order ASC
Parameters: 
[
  42
]
View formatted query    View runnable query    Explain query

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\System\Config 26
App\Entity\Content\Menus\MenuItem 8
App\Entity\Content\Pages\Page 7
App\Entity\Content\Menus\Menu 2
App\Entity\Content\Pages\Block 1
App\Entity\Content\Tags\Tag 1

Entities Mapping

Class Mapping errors
App\Entity\System\Config No errors.
App\Entity\Clients\UserAssessment No errors.
App\Entity\Clients\User No errors.
App\Entity\Clients\Admission No errors.
App\Entity\Assessments\Assessment No errors.
App\Entity\Content\Pages\Page No errors.
App\Entity\Projects\Project
  • The association App\Entity\Projects\Project#restrictedClients refers to the inverse side field App\Entity\Clients\Client#restrictedCourses which does not exist.
App\Entity\Content\Pages\Block No errors.
App\Entity\Clients\Code No errors.
App\Entity\Clients\Client
  • The mappings App\Entity\Clients\Client#restrictedProjects and App\Entity\Projects\Project#restrictedClients are inconsistent with each other.
App\Entity\Courses\Course No errors.
App\Entity\SalesOrders\Item No errors.
App\Entity\Content\Menus\Menu No errors.
App\Entity\Content\Menus\MenuItem No errors.
App\Entity\Content\Tags\Tag No errors.