Query Metrics
11
Database Queries
7
Different statements
12.33 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.16 ms (25.63%) |
4 |
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
]
|
|
2.43 ms (19.73%) |
2 |
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 ] |
|
1.88 ms (15.24%) |
1 |
SELECT p0_.components AS components_0, p0_.extraUrlsegments AS extraUrlsegments_1, p0_.htmlblocks AS htmlblocks_2, p0_.slug AS slug_3, p0_.id AS id_4, p0_.navtitle AS navtitle_5, p0_.url AS url_6, p0_.viewable_from AS viewable_from_7, p0_.content2 AS content2_8, p0_.kicker AS kicker_9, p0_.title AS title_10, p0_.content AS content_11, p0_.subtitle AS subtitle_12, p0_.meta_title AS meta_title_13, p0_.meta_description AS meta_description_14, p0_.ogImageAlt AS ogImageAlt_15, p0_.ogImage AS ogImage_16, p0_.active AS active_17, p0_.deleted AS deleted_18, p0_.image AS image_19, p0_.image2 AS image2_20, p0_.image3 AS image3_21, p0_.file AS file_22, p0_.created_at AS created_at_23, p0_.updated_at AS updated_at_24, i1_.id AS id_25, i1_.title AS title_26, i1_.content AS content_27, i1_.subtitle AS subtitle_28, i1_.image AS image_29, i1_.image2 AS image2_30, i1_.image3 AS image3_31, i1_.image4 AS image4_32, i1_.active AS active_33, i1_.deleted AS deleted_34, i1_.sort_order AS sort_order_35, i1_.created_at AS created_at_36, i1_.updated_at AS updated_at_37, p0_.update_by AS update_by_38, p0_.parent AS parent_39, p0_.template_id AS template_id_40, p0_.gallery_id AS gallery_id_41 FROM page p0_ LEFT JOIN page_image_text_grid p2_ ON p0_.id = p2_.page_id LEFT JOIN image_text_grid i1_ ON i1_.id = p2_.image_text_grid_id AND (i1_.deleted = 0 AND i1_.active = 1) WHERE p0_.slug = ? ORDER BY i1_.sort_order ASC
Parameters:
[
"scaffolding-in-oxford"
]
|
|
1.41 ms (11.42%) |
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.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:
[ "scaffolding-in-oxford" 0 1 ] |
|
1.39 ms (11.31%) |
1 |
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 ] |
|
1.19 ms (9.63%) |
1 |
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 ] |
|
0.87 ms (7.03%) |
1 |
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
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.
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\Enquiry | No errors. |
| App\Entity\HtmlBlocks | No errors. |
| App\Entity\Logo | No errors. |
| App\Entity\Menu | No errors. |
| App\Entity\News | No errors. |
| App\Entity\GalleryImage | No errors. |
| App\Entity\SliderImages | No errors. |
| App\Entity\Faq | No errors. |
| App\Entity\Setting | No errors. |