Query Metrics

20 Database Queries
15 Different statements
21.43 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.88 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
Parameters:
[]
2 1.31 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.content2 AS content2_9, t0.kicker AS kicker_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.ogImageAlt AS ogImageAlt_16, t0.ogImage AS ogImage_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.image2 AS image2_21, t0.image3 AS image3_22, t0.file AS file_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.update_by AS update_by_26, t0.parent AS parent_27, t0.template_id AS template_id_28, t0.gallery_id AS gallery_id_29 FROM page t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "team/roxy"
  0
  1
]
3 1.36 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.content2 AS content2_9, t0.kicker AS kicker_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.ogImageAlt AS ogImageAlt_16, t0.ogImage AS ogImage_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.image2 AS image2_21, t0.image3 AS image3_22, t0.file AS file_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.update_by AS update_by_26, t0.parent AS parent_27, t0.template_id AS template_id_28, t0.gallery_id AS gallery_id_29 FROM page t0
Parameters:
[]
4 1.80 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.content2 AS content2_3, t0.telephone AS telephone_4, t0.email_address AS email_address_5, t0.linked_in AS linked_in_6, t0.education AS education_7, t0.key_skills AS key_skills_8, t0.professional_interests AS professional_interests_9, t0.nickname AS nickname_10, t0.favourite_meal AS favourite_meal_11, t0.favourite_drink AS favourite_drink_12, t0.favourite_film AS favourite_film_13, t0.favourite_band AS favourite_band_14, t0.featured AS featured_15, t0.title AS title_16, t0.content AS content_17, t0.slug AS slug_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.ogImageAlt AS ogImageAlt_21, t0.ogImage AS ogImage_22, t0.active AS active_23, t0.deleted AS deleted_24, t0.image AS image_25, t0.image2 AS image2_26, t0.sort_order AS sort_order_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29 FROM meettheteam t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "roxy"
]
5 1.29 ms
SELECT t0.id AS id_1, t0.position AS position_2, t0.content2 AS content2_3, t0.telephone AS telephone_4, t0.email_address AS email_address_5, t0.linked_in AS linked_in_6, t0.education AS education_7, t0.key_skills AS key_skills_8, t0.professional_interests AS professional_interests_9, t0.nickname AS nickname_10, t0.favourite_meal AS favourite_meal_11, t0.favourite_drink AS favourite_drink_12, t0.favourite_film AS favourite_film_13, t0.favourite_band AS favourite_band_14, t0.featured AS featured_15, t0.title AS title_16, t0.content AS content_17, t0.slug AS slug_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.ogImageAlt AS ogImageAlt_21, t0.ogImage AS ogImage_22, t0.active AS active_23, t0.deleted AS deleted_24, t0.image AS image_25, t0.image2 AS image2_26, t0.sort_order AS sort_order_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29 FROM meettheteam t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "roxy"
  0
  1
]
6 1.22 ms
SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.content2 AS content2_2, m0_.telephone AS telephone_3, m0_.email_address AS email_address_4, m0_.linked_in AS linked_in_5, m0_.education AS education_6, m0_.key_skills AS key_skills_7, m0_.professional_interests AS professional_interests_8, m0_.nickname AS nickname_9, m0_.favourite_meal AS favourite_meal_10, m0_.favourite_drink AS favourite_drink_11, m0_.favourite_film AS favourite_film_12, m0_.favourite_band AS favourite_band_13, m0_.featured AS featured_14, m0_.title AS title_15, m0_.content AS content_16, m0_.slug AS slug_17, m0_.meta_title AS meta_title_18, m0_.meta_description AS meta_description_19, m0_.ogImageAlt AS ogImageAlt_20, m0_.ogImage AS ogImage_21, m0_.active AS active_22, m0_.deleted AS deleted_23, m0_.image AS image_24, m0_.image2 AS image2_25, m0_.sort_order AS sort_order_26, m0_.created_at AS created_at_27, m0_.updated_at AS updated_at_28 FROM meettheteam m0_ WHERE (m0_.active = 1 AND m0_.deleted = 0) AND m0_.sort_order >= ? AND m0_.id <> ? ORDER BY m0_.sort_order ASC LIMIT 1
Parameters:
[
  9
  8
]
7 1.06 ms
SELECT m0_.id AS id_0, m0_.position AS position_1, m0_.content2 AS content2_2, m0_.telephone AS telephone_3, m0_.email_address AS email_address_4, m0_.linked_in AS linked_in_5, m0_.education AS education_6, m0_.key_skills AS key_skills_7, m0_.professional_interests AS professional_interests_8, m0_.nickname AS nickname_9, m0_.favourite_meal AS favourite_meal_10, m0_.favourite_drink AS favourite_drink_11, m0_.favourite_film AS favourite_film_12, m0_.favourite_band AS favourite_band_13, m0_.featured AS featured_14, m0_.title AS title_15, m0_.content AS content_16, m0_.slug AS slug_17, m0_.meta_title AS meta_title_18, m0_.meta_description AS meta_description_19, m0_.ogImageAlt AS ogImageAlt_20, m0_.ogImage AS ogImage_21, m0_.active AS active_22, m0_.deleted AS deleted_23, m0_.image AS image_24, m0_.image2 AS image2_25, m0_.sort_order AS sort_order_26, m0_.created_at AS created_at_27, m0_.updated_at AS updated_at_28 FROM meettheteam m0_ WHERE (m0_.active = 1 AND m0_.deleted = 0) AND m0_.sort_order <= ? AND m0_.id <> ? ORDER BY m0_.sort_order DESC LIMIT 1
Parameters:
[
  9
  8
]
8 1.18 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
]
9 0.90 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:
[
  6
]
10 1.03 ms
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:
[
  2
]
11 0.83 ms
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:
[
  2
]
12 0.68 ms
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:
[
  3
]
13 0.66 ms
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:
[
  3
]
14 0.69 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"
]
15 0.77 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
]
16 1.08 ms
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.kicker AS kicker_3, t0.content2 AS content2_4, t0.content3 AS content3_5, t0.content4 AS content4_6, t0.title AS title_7, t0.content AS content_8, t0.subtitle AS subtitle_9, t0.image AS image_10, t0.image2 AS image2_11, t0.image3 AS image3_12, t0.image4 AS image4_13, t0.sort_order AS sort_order_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.slug AS slug_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.ogImageAlt AS ogImageAlt_20, t0.ogImage AS ogImage_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.gallery_id AS gallery_id_24 FROM sectors t0 WHERE t0.active = ? AND t0.deleted = ?
Parameters:
[
  1
  0
]
17 1.30 ms
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:
[
  24
]
18 0.87 ms
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:
[
  24
]
19 1.00 ms
SELECT t0.id AS id_1, t0.client_name AS client_name_2, t0.attestant AS attestant_3, t0.job_title AS job_title_4, t0.title AS title_5, t0.content AS content_6, t0.image AS image_7, t0.active AS active_8, t0.sort_order AS sort_order_9, t0.deleted AS deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM testimonial t0 WHERE t0.active = ? AND t0.deleted = ? ORDER BY t0.sort_order ASC
Parameters:
[
  1
  0
]
20 1.50 ms
SELECT n0_.id AS id_0, n0_.excerpt AS excerpt_1, n0_.publish_date AS publish_date_2, n0_.thumbnail AS thumbnail_3, n0_.content2 AS content2_4, n0_.kicker AS kicker_5, n0_.featured AS featured_6, n0_.title AS title_7, n0_.content AS content_8, n0_.subtitle AS subtitle_9, n0_.slug AS slug_10, n0_.meta_title AS meta_title_11, n0_.meta_description AS meta_description_12, n0_.ogImageAlt AS ogImageAlt_13, n0_.ogImage AS ogImage_14, n0_.active AS active_15, n0_.deleted AS deleted_16, n0_.image AS image_17, n0_.image2 AS image2_18, n0_.image3 AS image3_19, n0_.created_at AS created_at_20, n0_.updated_at AS updated_at_21, n0_.updated_by_id AS updated_by_id_22 FROM news n0_ WHERE (n0_.featured = 1 AND n0_.deleted = 0 AND n0_.active = 1) AND n0_.publish_date <= ? ORDER BY n0_.publish_date DESC LIMIT 1
Parameters:
[
  "2025-12-14 00:30:31"
]

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\Gallery No errors.
App\Entity\MenuItems No errors.
App\Entity\Slider No errors.
App\Entity\PagePreview No errors.
App\Entity\ImageTextGrid No errors.
App\Entity\TeamMember No errors.
App\Entity\Menu No errors.
App\Entity\News No errors.
App\Entity\GalleryImage No errors.
App\Entity\SliderImages No errors.
App\Entity\HtmlBlocks No errors.
App\Entity\Setting No errors.
App\Entity\Sectors No errors.
App\Entity\CaseStudies No errors.
App\Entity\Testimonial No errors.