Query Metrics

17 Database Queries
14 Different statements
18.20 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.84 ms
(21.09%)
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:
[
  2
]
1.60 ms
(8.80%)
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
Parameters:
[]
1.45 ms
(7.99%)
1
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.40 ms
(7.70%)
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
]
1.27 ms
(7.00%)
1
SELECT t0.id AS id_1, t0.description AS description_2, t0.templatefile AS templatefile_3, t0.number_of_html AS number_of_html_4, t0.number_of_components AS number_of_components_5, t0.inherited_bundle_name AS inherited_bundle_name_6, t0.title AS title_7, t0.content AS content_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.image AS image_11 FROM templates t0 WHERE t0.id = ?
Parameters:
[
  2
]
1.25 ms
(6.87%)
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:
[
  "sitemap"
  0
  1
]
1.06 ms
(5.81%)
1
SELECT t0.id AS id_1, t0.excerpt AS excerpt_2, t0.publish_date AS publish_date_3, t0.thumbnail AS thumbnail_4, t0.content2 AS content2_5, t0.kicker AS kicker_6, t0.featured AS featured_7, t0.title AS title_8, t0.content AS content_9, t0.subtitle AS subtitle_10, t0.slug AS slug_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.ogImageAlt AS ogImageAlt_14, t0.ogImage AS ogImage_15, t0.active AS active_16, t0.deleted AS deleted_17, t0.image AS image_18, t0.image2 AS image2_19, t0.image3 AS image3_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.updated_by_id AS updated_by_id_23 FROM news t0
Parameters:
[]
1.03 ms
(5.64%)
1
SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
Parameters:
[]
1.00 ms
(5.49%)
1
SELECT t0.id AS id_1, t0.featured AS featured_2, t0.client_name AS client_name_3, t0.client_testimonial AS client_testimonial_4, t0.client_testimonial_attestant AS client_testimonial_attestant_5, t0.client_testimonial_attestant_job_title AS client_testimonial_attestant_job_title_6, t0.project_name AS project_name_7, t0.project_start_date AS project_start_date_8, t0.project_duration AS project_duration_9, t0.project_budget AS project_budget_10, t0.project_location AS project_location_11, t0.detail_subtitle AS detail_subtitle_12, t0.detail_content AS detail_content_13, t0.challenges_subtitle AS challenges_subtitle_14, t0.challenges_content AS challenges_content_15, t0.solution_subtitle AS solution_subtitle_16, t0.solution_content AS solution_content_17, t0.kicker AS kicker_18, t0.title AS title_19, t0.content AS content_20, t0.slug AS slug_21, t0.meta_title AS meta_title_22, t0.meta_description AS meta_description_23, t0.ogImageAlt AS ogImageAlt_24, t0.ogImage AS ogImage_25, t0.active AS active_26, t0.deleted AS deleted_27, t0.image AS image_28, t0.image2 AS image2_29, t0.image3 AS image3_30, t0.image4 AS image4_31, t0.image5 AS image5_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34, t0.project_type_id AS project_type_id_35, t0.gallery_id AS gallery_id_36, t0.testimonial_id AS testimonial_id_37 FROM casestudies t0
Parameters:
[]
0.97 ms
(5.30%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.content2 AS content2_3, t0.telephone AS telephone_4, t0.email_address AS email_address_5, t0.linked_in AS linked_in_6, t0.education AS education_7, t0.key_skills AS key_skills_8, t0.professional_interests AS professional_interests_9, t0.nickname AS nickname_10, t0.favourite_meal AS favourite_meal_11, t0.favourite_drink AS favourite_drink_12, t0.favourite_film AS favourite_film_13, t0.favourite_band AS favourite_band_14, t0.featured AS featured_15, t0.title AS title_16, t0.content AS content_17, t0.slug AS slug_18, t0.meta_title AS meta_title_19, t0.meta_description AS meta_description_20, t0.ogImageAlt AS ogImageAlt_21, t0.ogImage AS ogImage_22, t0.active AS active_23, t0.deleted AS deleted_24, t0.image AS image_25, t0.image2 AS image2_26, t0.sort_order AS sort_order_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29 FROM meettheteam t0
Parameters:
[]
0.95 ms
(5.22%)
1
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.kicker AS kicker_3, t0.content2 AS content2_4, t0.content3 AS content3_5, t0.content4 AS content4_6, t0.title AS title_7, t0.content AS content_8, t0.subtitle AS subtitle_9, t0.image AS image_10, t0.image2 AS image2_11, t0.image3 AS image3_12, t0.image4 AS image4_13, t0.sort_order AS sort_order_14, t0.active AS active_15, t0.deleted AS deleted_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.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.gallery_id AS gallery_id_24 FROM sectors t0
Parameters:
[]
0.83 ms
(4.54%)
1
SELECT t0.id AS id_1, t0.name_override AS name_override_2, t0.url_override AS url_override_3, t0.menu_item_id AS menu_item_id_4, t0.menu_parent_id AS menu_parent_id_5, t0.newwindow AS newwindow_6, t0.isdynamic AS isdynamic_7, t0.dynamicentity AS dynamicentity_8, t0.active AS active_9, t0.deleted AS deleted_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.menuId AS menuId_13, t0.pageId AS pageId_14 FROM menuitems t0 WHERE t0.menuId = ?
Parameters:
[
  1
]
0.82 ms
(4.52%)
1
SELECT t0.id AS id_1, t0.icon AS icon_2, t0.kicker AS kicker_3, t0.content2 AS content2_4, t0.content3 AS content3_5, t0.content4 AS content4_6, t0.title AS title_7, t0.content AS content_8, t0.subtitle AS subtitle_9, t0.image AS image_10, t0.image2 AS image2_11, t0.image3 AS image3_12, t0.image4 AS image4_13, t0.sort_order AS sort_order_14, t0.active AS active_15, t0.deleted AS deleted_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.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.gallery_id AS gallery_id_24 FROM sectors t0 WHERE t0.active = ? AND t0.deleted = ?
Parameters:
[
  1
  0
]
0.73 ms
(4.03%)
1
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.active AS active_3, t0.deleted AS deleted_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.update_by AS update_by_7 FROM menus t0 WHERE t0.identifier = ? LIMIT 1
Parameters:
[
  "Top"
]

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.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractTranslation No errors.
App\Entity\PageTranslations No errors.
App\Entity\Menu No errors.
App\Entity\News No errors.
App\Entity\GalleryImage No errors.
App\Entity\SliderTranslations No errors.
App\Entity\SliderImages No errors.
App\Entity\PagePreviewTranslations No errors.
App\Entity\Sectors No errors.
App\Entity\Logo No errors.
App\Entity\TeamMember No errors.
App\Entity\Enquiry No errors.
App\Entity\Faq No errors.
App\Entity\CaseStudies No errors.
App\Entity\Testimonial No errors.
App\Entity\CaseStudiesTranslations No errors.
App\Entity\SocialTranslations No errors.
App\Entity\Setting No errors.
App\Entity\HtmlBlocksTranslations No errors.
App\Entity\EnquiryCV No errors.
App\Entity\Social No errors.
App\Entity\SliderImagesTranslations No errors.
App\Entity\Accreditation No errors.
App\Entity\NewsTranslations No errors.
App\Entity\TeamMemberTranslations No errors.
App\Entity\Locales No errors.
App\Entity\HtmlBlocks No errors.
Gedmo\Translatable\Entity\Translation No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation No errors.
Gedmo\Translator\Entity\Translation No errors.
Gedmo\Loggable\Entity\MappedSuperclass\AbstractLogEntry No errors.
Gedmo\Loggable\Entity\LogEntry No errors.