https://taurushr.thetlb.dev/case-studies/redundancy-support

Query Metrics

8 Database Queries
6 Different statements
29.80 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 4.00 ms
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
Parameters:
[]
2 1.05 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.content3 AS content3_9, t0.cta_text AS cta_text_10, t0.cta_link AS cta_link_11, t0.landing_page_blocks AS landing_page_blocks_12, t0.title AS title_13, t0.content AS content_14, t0.subtitle AS subtitle_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.content2 AS content2_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26, t0.testimonial_id AS testimonial_id_27, t28.id AS id_29, t28.title AS title_30, t28.content AS content_31, t28.active AS active_32, t28.deleted AS deleted_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.sort_order AS sort_order_36, t28.page_id AS page_id_37 FROM page t0 LEFT JOIN areas_we_cover t28 ON t28.page_id = t0.id WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "case-studies/redundancy-support"
  0
  1
]
3 2.52 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.content3 AS content3_9, t0.cta_text AS cta_text_10, t0.cta_link AS cta_link_11, t0.landing_page_blocks AS landing_page_blocks_12, t0.title AS title_13, t0.content AS content_14, t0.subtitle AS subtitle_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.content2 AS content2_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26, t0.testimonial_id AS testimonial_id_27, t28.id AS id_29, t28.title AS title_30, t28.content AS content_31, t28.active AS active_32, t28.deleted AS deleted_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.sort_order AS sort_order_36, t28.page_id AS page_id_37 FROM page t0 LEFT JOIN areas_we_cover t28 ON t28.page_id = t0.id
Parameters:
[]
4 8.11 ms
SELECT t0.id AS id_1, t0.cta_text AS cta_text_2, t0.cta_link AS cta_link_3, t0.quote AS quote_4, t0.featured AS featured_5, t0.logo AS logo_6, t0.slug AS slug_7, t0.title AS title_8, t0.content AS content_9, t0.subtitle AS subtitle_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.deleted AS deleted_14, t0.image AS image_15, t0.file AS file_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.testimonial_id AS testimonial_id_19 FROM casestudies t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "redundancy-support"
]
5 8.32 ms
SELECT t0.id AS id_1, t0.cta_text AS cta_text_2, t0.cta_link AS cta_link_3, t0.quote AS quote_4, t0.featured AS featured_5, t0.logo AS logo_6, t0.slug AS slug_7, t0.title AS title_8, t0.content AS content_9, t0.subtitle AS subtitle_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.active AS active_13, t0.deleted AS deleted_14, t0.image AS image_15, t0.file AS file_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.testimonial_id AS testimonial_id_19 FROM casestudies t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "redundancy-support"
  0
  1
]
6 0.82 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.id = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  1
  0
  1
]
7 2.33 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.id = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  12
  0
  1
]
8 2.66 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.id = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  9
  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\Testimonial No errors.
App\Entity\AreasWeCover No errors.
App\Entity\MenuItems No errors.
App\Entity\Slider No errors.
App\Entity\PagePreview No errors.
App\Entity\CaseStudies No errors.
App\Entity\Menu No errors.
App\Entity\News No errors.
App\Entity\SliderImages No errors.
App\Entity\Enquiry No errors.
App\Entity\HtmlBlocks No errors.