GET https://amrc-update.dev123.site/

Query Metrics

5 Database Queries
5 Different statements
8.75 ms Query time
0 Invalid entities
13 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.99 ms
(22.72%)
1
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
]
1.91 ms
(21.79%)
1
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
]
1.78 ms
(20.34%)
1
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
]
1.67 ms
(19.10%)
1
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
]
1.40 ms
(16.04%)
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.

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.