Query Metrics

35 Database Queries
18 Different statements
33.75 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
11.57 ms
(34.29%)
16
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
]
1.74 ms
(5.17%)
1
SELECT c0_.id AS id_0, c0_.featured AS featured_1, c0_.client_name AS client_name_2, c0_.client_testimonial AS client_testimonial_3, c0_.client_testimonial_attestant AS client_testimonial_attestant_4, c0_.client_testimonial_attestant_job_title AS client_testimonial_attestant_job_title_5, c0_.project_name AS project_name_6, c0_.project_start_date AS project_start_date_7, c0_.project_duration AS project_duration_8, c0_.project_budget AS project_budget_9, c0_.project_location AS project_location_10, c0_.detail_subtitle AS detail_subtitle_11, c0_.detail_content AS detail_content_12, c0_.challenges_subtitle AS challenges_subtitle_13, c0_.challenges_content AS challenges_content_14, c0_.solution_subtitle AS solution_subtitle_15, c0_.solution_content AS solution_content_16, c0_.kicker AS kicker_17, c0_.title AS title_18, c0_.content AS content_19, c0_.slug AS slug_20, c0_.meta_title AS meta_title_21, c0_.meta_description AS meta_description_22, c0_.ogImageAlt AS ogImageAlt_23, c0_.ogImage AS ogImage_24, c0_.active AS active_25, c0_.deleted AS deleted_26, c0_.image AS image_27, c0_.image2 AS image2_28, c0_.image3 AS image3_29, c0_.image4 AS image4_30, c0_.image5 AS image5_31, c0_.created_at AS created_at_32, c0_.updated_at AS updated_at_33, c0_.project_type_id AS project_type_id_34, c0_.gallery_id AS gallery_id_35, c0_.testimonial_id AS testimonial_id_36 FROM casestudies c0_ WHERE (c0_.active = 1 AND c0_.deleted = 0) AND c0_.featured = 1 ORDER BY c0_.created_at DESC LIMIT 1
Parameters:
[]
1.63 ms
(4.82%)
1
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 = ? ORDER BY t0.sort_order ASC
Parameters:
[
  1
  0
]
1.48 ms
(4.38%)
1
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.slug = ? LIMIT 1
Parameters:
[
  "new-builds"
]
1.46 ms
(4.32%)
1
SELECT s0_.id AS id_0, s0_.icon AS icon_1, s0_.kicker AS kicker_2, s0_.content2 AS content2_3, s0_.content3 AS content3_4, s0_.content4 AS content4_5, s0_.title AS title_6, s0_.content AS content_7, s0_.subtitle AS subtitle_8, s0_.image AS image_9, s0_.image2 AS image2_10, s0_.image3 AS image3_11, s0_.image4 AS image4_12, s0_.sort_order AS sort_order_13, s0_.active AS active_14, s0_.deleted AS deleted_15, s0_.slug AS slug_16, s0_.meta_title AS meta_title_17, s0_.meta_description AS meta_description_18, s0_.ogImageAlt AS ogImageAlt_19, s0_.ogImage AS ogImage_20, s0_.created_at AS created_at_21, s0_.updated_at AS updated_at_22, g1_.id AS id_23, g1_.title AS title_24, g1_.content AS content_25, g1_.active AS active_26, g1_.deleted AS deleted_27, g1_.created_at AS created_at_28, g1_.updated_at AS updated_at_29, g2_.id AS id_30, g2_.title AS title_31, g2_.content AS content_32, g2_.image AS image_33, g2_.file AS file_34, g2_.sort_order AS sort_order_35, g2_.active AS active_36, g2_.deleted AS deleted_37, g2_.created_at AS created_at_38, g2_.updated_at AS updated_at_39, s0_.gallery_id AS gallery_id_40, g2_.gallery_id AS gallery_id_41 FROM sectors s0_ LEFT JOIN gallery g1_ ON s0_.gallery_id = g1_.id AND (g1_.active = 1 AND g1_.deleted = 0) LEFT JOIN gallery_image g2_ ON g1_.id = g2_.gallery_id AND (g2_.active = 1 AND g2_.deleted = 0) WHERE s0_.slug = ? AND (s0_.active = 1 AND s0_.deleted = 0) ORDER BY g2_.sort_order ASC
Parameters:
[
  "new-builds"
]
1.45 ms
(4.30%)
2
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"
]
1.38 ms
(4.08%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.content AS content_4, t0.image AS image_5, t0.sort_order AS sort_order_6, t0.active AS active_7, t0.deleted AS deleted_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM accreditation t0 WHERE t0.active = ? AND t0.deleted = ? ORDER BY t0.sort_order ASC
Parameters:
[
  1
  0
]
1.33 ms
(3.93%)
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_.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-13 21:31:25"
]
1.32 ms
(3.93%)
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.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:
[]
1.31 ms
(3.89%)
2
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.31 ms
(3.88%)
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.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:
[
  "expertise/new-builds"
  0
  1
]
1.29 ms
(3.82%)
1
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
]
1.27 ms
(3.78%)
1
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.title = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "Form Text"
  0
  1
]
1.26 ms
(3.74%)
1
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
]
1.11 ms
(3.28%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.content AS content_3, t0.image AS image_4, t0.sort_order AS sort_order_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 logo t0 WHERE t0.active = ? AND t0.deleted = ? ORDER BY t0.sort_order ASC
Parameters:
[
  1
  0
]
1.03 ms
(3.06%)
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:
[
  6
]
0.99 ms
(2.92%)
1
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
Parameters:
[]
0.82 ms
(2.42%)
1
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
]

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\Sectors No errors.
App\Entity\CaseStudies No errors.
App\Entity\GalleryImage No errors.
App\Entity\Menu No errors.
App\Entity\News No errors.
App\Entity\SliderImages No errors.
App\Entity\Testimonial No errors.
App\Entity\Enquiry No errors.
App\Entity\HtmlBlocks No errors.
App\Entity\Logo No errors.
App\Entity\Setting No errors.
App\Entity\Accreditation No errors.