https://stablescaffolding.dev123.site/sectors/power-utilities

Query Metrics

17 Database Queries
9 Different statements
22.15 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
7.09 ms
(32.02%)
8
SELECT t0.id AS id_1, t0.icon_class AS icon_class_2, t0.excerpt AS excerpt_3, t0.title AS title_4, t0.content AS content_5, t0.content2 AS content2_6, t0.slug AS slug_7, t0.image AS image_8, t0.image2 AS image2_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.ogImageAlt AS ogImageAlt_12, t0.ogImage AS ogImage_13, t0.sort_order AS sort_order_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.featured AS featured_19, t0.parent_id AS parent_id_20 FROM sector t0 WHERE ((t0.active = ? AND t0.deleted = ?) AND t0.parent_id = ?)
Parameters:
[
  1
  0
  4
]
3.88 ms
(17.54%)
2
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.icon_class AS icon_class_2, s0_.title AS title_3, s0_.content AS content_4, s0_.active AS active_5, s0_.deleted AS deleted_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, s0_.image AS image_9, s0_.file AS file_10, s0_.video AS video_11 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
Parameters:
[
  13
]
3.73 ms
(16.83%)
1
SELECT t0.id AS id_1, t0.icon_class AS icon_class_2, t0.excerpt AS excerpt_3, t0.title AS title_4, t0.content AS content_5, t0.content2 AS content2_6, t0.slug AS slug_7, t0.image AS image_8, t0.image2 AS image2_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.ogImageAlt AS ogImageAlt_12, t0.ogImage AS ogImage_13, t0.sort_order AS sort_order_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.featured AS featured_19, t0.parent_id AS parent_id_20 FROM sector t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "power-utilities"
]
2.32 ms
(10.47%)
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:
[
  "Work For Us CTA"
  0
  1
]
1.29 ms
(5.80%)
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:
[
  "sectors/power-utilities"
  0
  1
]
1.10 ms
(4.98%)
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:
[]
0.94 ms
(4.26%)
1
SELECT t0.id AS id_1, t0.icon_class AS icon_class_2, t0.excerpt AS excerpt_3, t0.title AS title_4, t0.content AS content_5, t0.content2 AS content2_6, t0.slug AS slug_7, t0.image AS image_8, t0.image2 AS image2_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.ogImageAlt AS ogImageAlt_12, t0.ogImage AS ogImage_13, t0.sort_order AS sort_order_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.featured AS featured_19, t0.parent_id AS parent_id_20 FROM sector t0 WHERE t0.deleted = ? AND t0.active = ? AND t0.parent_id = ? ORDER BY t0.sort_order ASC
Parameters:
[
  0
  1
  1
]
0.90 ms
(4.06%)
1
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
Parameters:
[]
0.90 ms
(4.04%)
1
SELECT t0.id AS id_1, t0.icon_class AS icon_class_2, t0.excerpt AS excerpt_3, t0.title AS title_4, t0.content AS content_5, t0.content2 AS content2_6, t0.slug AS slug_7, t0.image AS image_8, t0.image2 AS image2_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.ogImageAlt AS ogImageAlt_12, t0.ogImage AS ogImage_13, t0.sort_order AS sort_order_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.featured AS featured_19, t0.parent_id AS parent_id_20 FROM sector t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "power-utilities"
  0
  1
]

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\Sector No errors.
App\Entity\HtmlBlocks No errors.
App\Entity\Setting No errors.