https://kasscaffolding.thetlb.dev/expertise/commercial

Query Metrics

8 Database Queries
8 Different statements
11.51 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.72 ms
(14.95%)
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:
[
  "commercial"
]
1.67 ms
(14.54%)
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.63 ms
(14.20%)
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.55 ms
(13.45%)
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/commercial"
  0
  1
]
1.44 ms
(12.54%)
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:
[
  "commercial"
]
1.29 ms
(11.23%)
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.21 ms
(10.49%)
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
]
0.99 ms
(8.61%)
1
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
Parameters:
[]

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.