Query Metrics
5
Database Queries
5
Different statements
8.75 ms
Query time
0
Invalid entities
13
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.40 ms |
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
Parameters:
[] |
| 2 | 1.99 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.navtitle AS navtitle_3, t0.viewable_from AS viewable_from_4, t0.url AS url_5, t0.slug AS slug_6, t0.content AS content_7, t0.content2 AS content2_8, t0.ctaButtonTitle AS ctaButtonTitle_9, t0.ctaButtonLink AS ctaButtonLink_10, t0.bannerText AS bannerText_11, t0.buttonTitle AS buttonTitle_12, t0.buttonLink AS buttonLink_13, t0.created AS created_14, t0.updated AS updated_15, t0.active AS active_16, t0.deleted AS deleted_17, t0.components AS components_18, t0.extraUrlsegments AS extraUrlsegments_19, t0.metatitle AS metatitle_20, t0.metadescription AS metadescription_21, t0.related_sectors AS related_sectors_22, t0.related_services AS related_services_23, t0.htmlblocks AS htmlblocks_24, t0.image AS image_25, t0.subtitle AS subtitle_26, t0.pageIntro AS pageIntro_27, t0.sub_image AS sub_image_28, t0.largeImage AS largeImage_29, t0.video AS video_30, t0.pagelinkBoxes AS pagelinkBoxes_31, t0.page_links_sort_order AS page_links_sort_order_32, t0.pagelinkText AS pagelinkText_33, t0.faq AS faq_34, t0.files AS files_35, t0.dont_show_image AS dont_show_image_36, t0.youtube_id AS youtube_id_37, t0.vimeo_id AS vimeo_id_38, t0.show_media_type AS show_media_type_39, t0.taggedin AS taggedin_40, t0.update_by AS update_by_41, t0.parent AS parent_42, t0.template_id AS template_id_43 FROM page t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
Parameters:
[ "home" 0 1 ] |
| 3 | 1.91 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.identifier AS identifier_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.active AS active_6, t0.deleted AS deleted_7 FROM slider t0 INNER JOIN slider_page ON t0.id = slider_page.slider_id WHERE slider_page.page_id = ?
Parameters:
[
1
]
|
| 4 | 1.67 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.html AS html_3, t0.position AS position_4, t0.image AS image_5, t0.link AS link_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.buttontext AS buttontext_11, t0.slider_id AS slider_id_12 FROM slider_images t0 WHERE t0.slider_id = ? AND t0.active = ? AND t0.deleted = ? ORDER BY t0.position ASC
Parameters:
[ 1 1 0 ] |
| 5 | 1.78 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.navtitle AS navtitle_2, p0_.viewable_from AS viewable_from_3, p0_.url AS url_4, p0_.slug AS slug_5, p0_.content AS content_6, p0_.content2 AS content2_7, p0_.ctaButtonTitle AS ctaButtonTitle_8, p0_.ctaButtonLink AS ctaButtonLink_9, p0_.bannerText AS bannerText_10, p0_.buttonTitle AS buttonTitle_11, p0_.buttonLink AS buttonLink_12, p0_.created AS created_13, p0_.updated AS updated_14, p0_.active AS active_15, p0_.deleted AS deleted_16, p0_.components AS components_17, p0_.extraUrlsegments AS extraUrlsegments_18, p0_.metatitle AS metatitle_19, p0_.metadescription AS metadescription_20, p0_.related_sectors AS related_sectors_21, p0_.related_services AS related_services_22, p0_.htmlblocks AS htmlblocks_23, p0_.image AS image_24, p0_.subtitle AS subtitle_25, p0_.pageIntro AS pageIntro_26, p0_.sub_image AS sub_image_27, p0_.largeImage AS largeImage_28, p0_.video AS video_29, p0_.pagelinkBoxes AS pagelinkBoxes_30, p0_.page_links_sort_order AS page_links_sort_order_31, p0_.pagelinkText AS pagelinkText_32, p0_.faq AS faq_33, p0_.files AS files_34, p0_.dont_show_image AS dont_show_image_35, p0_.youtube_id AS youtube_id_36, p0_.vimeo_id AS vimeo_id_37, p0_.show_media_type AS show_media_type_38, p0_.taggedin AS taggedin_39, p0_.update_by AS update_by_40, p0_.parent AS parent_41, p0_.template_id AS template_id_42 FROM page p0_ WHERE p0_.slug NOT LIKE ? AND p0_.image IS NOT NULL AND (p0_.active = 1 AND p0_.deleted = 0) AND p0_.id IN (?, ?, ?)
Parameters:
[ "{%" 3 12 35 ] |
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 | 4 |
| App\Entity\User | 3 |
| App\Entity\SliderImages | 3 |
| App\Entity\Templates | 2 |
| App\Entity\Slider | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Page | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Templates | No errors. |
| App\Entity\MenuItems | No errors. |
| App\Entity\Slider | No errors. |
| App\Entity\PagePreview | No errors. |
| App\Entity\SliderImages | No errors. |
| App\Entity\Menu | No errors. |