Query Metrics

19 Database Queries
11 Different statements
20.20 ms Query time
0 Invalid entities
38 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.70 ms
(23.26%)
5
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.content AS content_2, s0_.active AS active_3, s0_.deleted AS deleted_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.image AS image_7, s0_.file AS file_8 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
Parameters:
[
  1
]
3.07 ms
(15.22%)
3
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"
]
2.99 ms
(14.79%)
3
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
]
1.88 ms
(9.33%)
1
SELECT t0.id AS id_1, t0.excerpt AS excerpt_2, t0.publish_date AS publish_date_3, t0.thumbnail AS thumbnail_4, t0.title AS title_5, t0.content AS content_6, t0.subtitle AS subtitle_7, t0.slug AS slug_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.ogImageAlt AS ogImageAlt_11, t0.ogImage AS ogImage_12, t0.active AS active_13, t0.deleted AS deleted_14, t0.image AS image_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.updated_by_id AS updated_by_id_18 FROM news t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "another-news-story"
]
1.42 ms
(7.04%)
1
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.content2 AS content2_9, t0.title AS title_10, t0.content AS content_11, t0.subtitle AS subtitle_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.ogImageAlt AS ogImageAlt_15, t0.ogImage AS ogImage_16, t0.active AS active_17, t0.deleted AS deleted_18, t0.image AS image_19, t0.image2 AS image2_20, t0.image3 AS image3_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26 FROM page t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "news/another-news-story"
  0
  1
]
1.27 ms
(6.28%)
1
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:
[
  2
]
1.07 ms
(5.29%)
1
SELECT t0.id AS id_1, t0.excerpt AS excerpt_2, t0.publish_date AS publish_date_3, t0.thumbnail AS thumbnail_4, t0.title AS title_5, t0.content AS content_6, t0.subtitle AS subtitle_7, t0.slug AS slug_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.ogImageAlt AS ogImageAlt_11, t0.ogImage AS ogImage_12, t0.active AS active_13, t0.deleted AS deleted_14, t0.image AS image_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.updated_by_id AS updated_by_id_18 FROM news t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "another-news-story"
  0
  1
]
1.02 ms
(5.05%)
1
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.content2 AS content2_9, t0.title AS title_10, t0.content AS content_11, t0.subtitle AS subtitle_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.ogImageAlt AS ogImageAlt_15, t0.ogImage AS ogImage_16, t0.active AS active_17, t0.deleted AS deleted_18, t0.image AS image_19, t0.image2 AS image2_20, t0.image3 AS image3_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26 FROM page t0
Parameters:
[]
1.01 ms
(4.98%)
1
SELECT n0_.id AS id_0, n0_.excerpt AS excerpt_1, n0_.publish_date AS publish_date_2, n0_.thumbnail AS thumbnail_3, n0_.title AS title_4, n0_.content AS content_5, n0_.subtitle AS subtitle_6, n0_.slug AS slug_7, n0_.meta_title AS meta_title_8, n0_.meta_description AS meta_description_9, n0_.ogImageAlt AS ogImageAlt_10, n0_.ogImage AS ogImage_11, n0_.active AS active_12, n0_.deleted AS deleted_13, n0_.image AS image_14, n0_.created_at AS created_at_15, n0_.updated_at AS updated_at_16, n0_.updated_by_id AS updated_by_id_17 FROM news n0_ WHERE (n0_.active = 1 AND n0_.deleted = 0) AND n0_.publish_date <= ? AND n0_.publish_date > ? ORDER BY n0_.publish_date ASC LIMIT 1
Parameters:
[
  "2025-12-06 03:13:34"
  "2025-11-17 10:09:21"
]
0.97 ms
(4.79%)
1
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
Parameters:
[]
0.80 ms
(3.96%)
1
SELECT n0_.id AS id_0, n0_.excerpt AS excerpt_1, n0_.publish_date AS publish_date_2, n0_.thumbnail AS thumbnail_3, n0_.title AS title_4, n0_.content AS content_5, n0_.subtitle AS subtitle_6, n0_.slug AS slug_7, n0_.meta_title AS meta_title_8, n0_.meta_description AS meta_description_9, n0_.ogImageAlt AS ogImageAlt_10, n0_.ogImage AS ogImage_11, n0_.active AS active_12, n0_.deleted AS deleted_13, n0_.image AS image_14, n0_.created_at AS created_at_15, n0_.updated_at AS updated_at_16, n0_.updated_by_id AS updated_by_id_17 FROM news n0_ WHERE (n0_.active = 1 AND n0_.deleted = 0) AND n0_.publish_date <= ? AND n0_.publish_date < ? ORDER BY n0_.publish_date DESC LIMIT 1
Parameters:
[
  "2025-12-06 03:13:34"
  "2025-11-17 10:09:21"
]

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\MenuItems 15
App\Entity\Page 11
App\Entity\Templates 4
App\Entity\Menu 3
App\Entity\Setting 3
App\Entity\User 1
App\Entity\News 1

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\News No errors.
App\Entity\Menu No errors.
App\Entity\SliderImages No errors.
App\Entity\Setting No errors.