https://kasscaffolding.thetlb.dev/blog/how-often-should-scaffold-be-inspected

Query Metrics

15 Database Queries
11 Different statements
17.69 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.33 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:
[
  "blog/how-often-should-scaffold-be-inspected"
  0
  1
]
3 1.43 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 2.50 ms
SELECT t0.id AS id_1, t0.excerpt AS excerpt_2, t0.publish_date AS publish_date_3, t0.thumbnail AS thumbnail_4, t0.content2 AS content2_5, t0.kicker AS kicker_6, t0.featured AS featured_7, t0.title AS title_8, t0.content AS content_9, t0.subtitle AS subtitle_10, t0.slug AS slug_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.ogImageAlt AS ogImageAlt_14, t0.ogImage AS ogImage_15, t0.active AS active_16, t0.deleted AS deleted_17, t0.image AS image_18, t0.image2 AS image2_19, t0.image3 AS image3_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.updated_by_id AS updated_by_id_23 FROM news t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "how-often-should-scaffold-be-inspected"
]
5 1.10 ms
SELECT t0.id AS id_1, t0.excerpt AS excerpt_2, t0.publish_date AS publish_date_3, t0.thumbnail AS thumbnail_4, t0.content2 AS content2_5, t0.kicker AS kicker_6, t0.featured AS featured_7, t0.title AS title_8, t0.content AS content_9, t0.subtitle AS subtitle_10, t0.slug AS slug_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.ogImageAlt AS ogImageAlt_14, t0.ogImage AS ogImage_15, t0.active AS active_16, t0.deleted AS deleted_17, t0.image AS image_18, t0.image2 AS image2_19, t0.image3 AS image3_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.updated_by_id AS updated_by_id_23 FROM news t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "how-often-should-scaffold-be-inspected"
  0
  1
]
6 1.29 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_.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-13 21:29:36"
  "2025-05-12 16:32:00"
]
7 1.17 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_.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-13 21:29:36"
  "2025-05-12 16:32:00"
]
8 1.31 ms
SELECT t0.id AS id_1, t0.popular AS popular_2, t0.title AS title_3, t0.content AS content_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 faq t0 WHERE t0.deleted = ? AND t0.active = ? AND t0.popular = ? ORDER BY t0.sort_order ASC
Parameters:
[
  0
  1
  1
]
9 1.23 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.title = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "FAQ Content"
  0
  1
]
10 0.95 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:
[
  19
]
11 0.65 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:
[
  19
]
12 0.80 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:
[
  25
]
13 0.55 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:
[
  25
]
14 1.25 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.title = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "Form Text"
  0
  1
]
15 1.26 ms
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
]

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