Query Metrics
6
Database Queries
6
Different statements
10.50 ms
Query time
0
Invalid entities
60
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.29 ms |
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
Parameters:
[] |
| 2 | 1.58 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.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:
[ "our-work/domestic-electrical-installation" 0 1 ] |
| 3 | 1.86 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.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:
[] |
| 4 | 2.51 ms |
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.ogImageAlt AS ogImageAlt_8, t0.ogImage AS ogImage_9, t0.image AS image_10, t0.active AS active_11, t0.deleted AS deleted_12, t0.sort_order AS sort_order_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM gallery t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"domestic-electrical-installation"
]
|
| 5 | 1.24 ms |
SELECT t0.id AS id_1, t0.short_title AS short_title_2, t0.title AS title_3, t0.content AS content_4, t0.slug AS slug_5, t0.meta_title AS meta_title_6, t0.meta_description AS meta_description_7, t0.ogImageAlt AS ogImageAlt_8, t0.ogImage AS ogImage_9, t0.image AS image_10, t0.active AS active_11, t0.deleted AS deleted_12, t0.sort_order AS sort_order_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM gallery t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[ "domestic-electrical-installation" 0 1 ] |
| 6 | 2.02 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, t0.gallery_id AS gallery_id_10 FROM gallery_image t0 WHERE t0.gallery_id = ? AND t0.deleted = ? AND t0.active = ? ORDER BY t0.sort_order ASC
Parameters:
[ 2 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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Page | 23 |
| App\Entity\GalleryImage | 20 |
| App\Entity\Templates | 6 |
| App\Entity\FaqGroup | 6 |
| App\Entity\Testimonial | 3 |
| App\Entity\User | 1 |
| App\Entity\Gallery | 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\Gallery | No errors. |
| App\Entity\GalleryImage | No errors. |