Query Metrics

9 Database Queries
7 Different statements
28.58 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.34 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
Parameters:
[]
2 18.39 ms
SELECT t0.components AS components_1, t0.extraUrlsegments AS extraUrlsegments_2, t0.htmlblocks AS htmlblocks_3, t0.slug AS slug_4, t0.id AS id_5, t0.navtitle AS navtitle_6, t0.url AS url_7, t0.viewable_from AS viewable_from_8, t0.title AS title_9, t0.content AS content_10, t0.subtitle AS subtitle_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.active AS active_14, t0.deleted AS deleted_15, t0.image AS image_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.update_by AS update_by_19, t0.parent AS parent_20, t0.template_id AS template_id_21 FROM page t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "home"
  0
  1
]
3 1.62 ms
SELECT t0.id AS id_1, t0.html AS html_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.active AS active_6, t0.deleted AS deleted_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM html_blocks t0 WHERE t0.deleted = ?
Parameters:
[
  0
]
4 0.97 ms
SELECT t0.id AS id_1, t0.description AS description_2, t0.templatefile AS templatefile_3, t0.number_of_html AS number_of_html_4, t0.number_of_components AS number_of_components_5, t0.inherited_bundle_name AS inherited_bundle_name_6, t0.title AS title_7, t0.content AS content_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.image AS image_11 FROM templates t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 1.41 ms
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.active AS active_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.update_by AS update_by_7 FROM menus t0 WHERE t0.identifier = ? LIMIT 1
Parameters:
[
  "Top"
]
6 1.29 ms
SELECT t0.id AS id_1, t0.name_override AS name_override_2, t0.url_override AS url_override_3, t0.menu_item_id AS menu_item_id_4, t0.menu_parent_id AS menu_parent_id_5, t0.newwindow AS newwindow_6, t0.isdynamic AS isdynamic_7, t0.dynamicentity AS dynamicentity_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menuId AS menuId_13, t0.pageId AS pageId_14 FROM menuitems t0 WHERE t0.menuId = ?
Parameters:
[
  1
]
7 1.20 ms
SELECT t0.components AS components_1, t0.extraUrlsegments AS extraUrlsegments_2, t0.htmlblocks AS htmlblocks_3, t0.slug AS slug_4, t0.id AS id_5, t0.navtitle AS navtitle_6, t0.url AS url_7, t0.viewable_from AS viewable_from_8, t0.title AS title_9, t0.content AS content_10, t0.subtitle AS subtitle_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.active AS active_14, t0.deleted AS deleted_15, t0.image AS image_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.update_by AS update_by_19, t0.parent AS parent_20, t0.template_id AS template_id_21 FROM page t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 1.13 ms
SELECT t0.components AS components_1, t0.extraUrlsegments AS extraUrlsegments_2, t0.htmlblocks AS htmlblocks_3, t0.slug AS slug_4, t0.id AS id_5, t0.navtitle AS navtitle_6, t0.url AS url_7, t0.viewable_from AS viewable_from_8, t0.title AS title_9, t0.content AS content_10, t0.subtitle AS subtitle_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.active AS active_14, t0.deleted AS deleted_15, t0.image AS image_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.update_by AS update_by_19, t0.parent AS parent_20, t0.template_id AS template_id_21 FROM page t0 WHERE t0.id = ?
Parameters:
[
  4
]
9 1.22 ms
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.active AS active_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.update_by AS update_by_7 FROM menus t0 WHERE t0.identifier = ? LIMIT 1
Parameters:
[
  "Top"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Page No errors.
App\Entity\User No errors.
App\Entity\Templates No errors.
App\Entity\MenuItems No errors.
App\Entity\Slider No errors.
App\Entity\PagePreview No errors.
App\Entity\HtmlBlocks No errors.
App\Entity\Menu No errors.
App\Entity\SliderImages No errors.