GET https://cte-cms.thetlb.dev/case-studies/ev-charge-point-installation

Query Metrics

8 Database Queries
6 Different statements
33.27 ms Query time
0 Invalid entities
43 Managed entities

Grouped Statements

Show all queries

Time Count Info
10.08 ms
(30.31%)
1
SELECT t0.id AS id_1, t0.kicker AS kicker_2, t0.cta_title AS cta_title_3, t0.cta_intro AS cta_intro_4, t0.cta_text_1 AS cta_text_1_5, t0.cta_url_1 AS cta_url_1_6, t0.cta_text_2 AS cta_text_2_7, t0.cta_url_2 AS cta_url_2_8, t0.content2 AS content2_9, t0.content3 AS content3_10, t0.sector AS sector_11, t0.location AS location_12, t0.client AS client_13, t0.title AS title_14, t0.content AS content_15, t0.subtitle AS subtitle_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.active AS active_22, t0.deleted AS deleted_23, t0.image AS image_24, t0.image2 AS image2_25, t0.image3 AS image3_26, t0.file AS file_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.video AS video_30, t0.testimonial1_id AS testimonial1_id_31, t0.testimonial2_id AS testimonial2_id_32, t0.testimonial3_id AS testimonial3_id_33 FROM casestudies t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "ev-charge-point-installation"
]
9.32 ms
(28.02%)
1
SELECT t0.id AS id_1, t0.kicker AS kicker_2, t0.cta_title AS cta_title_3, t0.cta_intro AS cta_intro_4, t0.cta_text_1 AS cta_text_1_5, t0.cta_url_1 AS cta_url_1_6, t0.cta_text_2 AS cta_text_2_7, t0.cta_url_2 AS cta_url_2_8, t0.content2 AS content2_9, t0.content3 AS content3_10, t0.sector AS sector_11, t0.location AS location_12, t0.client AS client_13, t0.title AS title_14, t0.content AS content_15, t0.subtitle AS subtitle_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.active AS active_22, t0.deleted AS deleted_23, t0.image AS image_24, t0.image2 AS image2_25, t0.image3 AS image3_26, t0.file AS file_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.video AS video_30, t0.testimonial1_id AS testimonial1_id_31, t0.testimonial2_id AS testimonial2_id_32, t0.testimonial3_id AS testimonial3_id_33 FROM casestudies t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "ev-charge-point-installation"
  0
  1
]
7.02 ms
(21.10%)
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.content3 AS content3_10, t0.content4 AS content4_11, t0.cta_text_1 AS cta_text_1_12, t0.cta_url_1 AS cta_url_1_13, t0.cta_text_2 AS cta_text_2_14, t0.cta_url_2 AS cta_url_2_15, t0.cta_text_3 AS cta_text_3_16, t0.cta_url_3 AS cta_url_3_17, t0.title AS title_18, t0.content AS content_19, t0.subtitle AS subtitle_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.ogImageAlt AS ogImageAlt_23, t0.ogImage AS ogImage_24, t0.active AS active_25, t0.deleted AS deleted_26, t0.image AS image_27, t0.image2 AS image2_28, t0.image3 AS image3_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.update_by AS update_by_32, t0.parent AS parent_33, t0.template_id AS template_id_34, t0.faq_group_id AS faq_group_id_35, t0.testimonial1_id AS testimonial1_id_36, t0.testimonial2_id AS testimonial2_id_37, t0.testimonial3_id AS testimonial3_id_38 FROM page t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "case-studies/ev-charge-point-installation"
  0
  1
]
3.41 ms
(10.24%)
3
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.attestant AS attestant_3, t0.title AS title_4, t0.content AS content_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, t0.video AS video_11 FROM testimonial t0 WHERE t0.id = ?
Parameters:
[
  32
]
1.86 ms
(5.58%)
1
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
Parameters:
[]
1.58 ms
(4.75%)
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.content3 AS content3_10, t0.content4 AS content4_11, t0.cta_text_1 AS cta_text_1_12, t0.cta_url_1 AS cta_url_1_13, t0.cta_text_2 AS cta_text_2_14, t0.cta_url_2 AS cta_url_2_15, t0.cta_text_3 AS cta_text_3_16, t0.cta_url_3 AS cta_url_3_17, t0.title AS title_18, t0.content AS content_19, t0.subtitle AS subtitle_20, t0.meta_title AS meta_title_21, t0.meta_description AS meta_description_22, t0.ogImageAlt AS ogImageAlt_23, t0.ogImage AS ogImage_24, t0.active AS active_25, t0.deleted AS deleted_26, t0.image AS image_27, t0.image2 AS image2_28, t0.image3 AS image3_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.update_by AS update_by_32, t0.parent AS parent_33, t0.template_id AS template_id_34, t0.faq_group_id AS faq_group_id_35, t0.testimonial1_id AS testimonial1_id_36, t0.testimonial2_id AS testimonial2_id_37, t0.testimonial3_id AS testimonial3_id_38 FROM page t0
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Page 23
App\Entity\Templates 6
App\Entity\FaqGroup 6
App\Entity\Testimonial 6
App\Entity\User 1
App\Entity\CaseStudies 1

Entities Mapping

Class Mapping errors
App\Entity\Page No errors.
App\Entity\User No errors.
App\Entity\Templates No errors.
App\Entity\FaqGroup No errors.
App\Entity\Testimonial No errors.
App\Entity\MenuItems No errors.
App\Entity\Slider No errors.
App\Entity\PagePreview No errors.
App\Entity\CaseStudies No errors.