Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

50 Database Queries

15 Different statements

65.35 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_
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.content3 AS content3_9, t0.cta_text AS cta_text_10, t0.cta_link AS cta_link_11, t0.landing_page_blocks AS landing_page_blocks_12, t0.title AS title_13, t0.content AS content_14, t0.subtitle AS subtitle_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.content2 AS content2_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26, t0.testimonial_id AS testimonial_id_27, t28.id AS id_29, t28.title AS title_30, t28.content AS content_31, t28.active AS active_32, t28.deleted AS deleted_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.sort_order AS sort_order_36, t28.page_id AS page_id_37 FROM page t0 LEFT JOIN areas_we_cover t28 ON t28.page_id = t0.id WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 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.content3 AS content3_9, t0.cta_text AS cta_text_10, t0.cta_link AS cta_link_11, t0.landing_page_blocks AS landing_page_blocks_12, t0.title AS title_13, t0.content AS content_14, t0.subtitle AS subtitle_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.content2 AS content2_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26, t0.testimonial_id AS testimonial_id_27, t28.id AS id_29, t28.title AS title_30, t28.content AS content_31, t28.active AS active_32, t28.deleted AS deleted_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.sort_order AS sort_order_36, t28.page_id AS page_id_37 FROM page t0 LEFT JOIN areas_we_cover t28 ON t28.page_id = t0.id
SELECT t0.id AS id_1, t0.excerpt AS excerpt_2, t0.publish_date AS publish_date_3, t0.thumbnail AS thumbnail_4, t0.cta_text AS cta_text_5, t0.cta_link AS cta_link_6, t0.featured_on_news_page AS featured_on_news_page_7, t0.featured_in_wisdom_component AS featured_in_wisdom_component_8, t0.slug AS slug_9, t0.title AS title_10, t0.content AS content_11, t0.subtitle AS subtitle_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.image AS image_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.updated_by_id AS updated_by_id_20 FROM news t0 WHERE t0.slug = ? LIMIT 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.cta_text AS cta_text_5, t0.cta_link AS cta_link_6, t0.featured_on_news_page AS featured_on_news_page_7, t0.featured_in_wisdom_component AS featured_in_wisdom_component_8, t0.slug AS slug_9, t0.title AS title_10, t0.content AS content_11, t0.subtitle AS subtitle_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.image AS image_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.updated_by_id AS updated_by_id_20 FROM news t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1
SELECT n0_.id AS id_0, n0_.excerpt AS excerpt_1, n0_.publish_date AS publish_date_2, n0_.thumbnail AS thumbnail_3, n0_.cta_text AS cta_text_4, n0_.cta_link AS cta_link_5, n0_.featured_on_news_page AS featured_on_news_page_6, n0_.featured_in_wisdom_component AS featured_in_wisdom_component_7, n0_.slug AS slug_8, n0_.title AS title_9, n0_.content AS content_10, n0_.subtitle AS subtitle_11, n0_.meta_title AS meta_title_12, n0_.meta_description AS meta_description_13, n0_.active AS active_14, n0_.deleted AS deleted_15, n0_.image AS image_16, n0_.created_at AS created_at_17, n0_.updated_at AS updated_at_18, n0_.updated_by_id AS updated_by_id_19 FROM news n0_ WHERE (n0_.active = 1 AND n0_.deleted = 0) AND n0_.publish_date <= ? AND n0_.publish_date > ? ORDER BY n0_.publish_date ASC LIMIT 1
SELECT n0_.id AS id_0, n0_.excerpt AS excerpt_1, n0_.publish_date AS publish_date_2, n0_.thumbnail AS thumbnail_3, n0_.cta_text AS cta_text_4, n0_.cta_link AS cta_link_5, n0_.featured_on_news_page AS featured_on_news_page_6, n0_.featured_in_wisdom_component AS featured_in_wisdom_component_7, n0_.slug AS slug_8, n0_.title AS title_9, n0_.content AS content_10, n0_.subtitle AS subtitle_11, n0_.meta_title AS meta_title_12, n0_.meta_description AS meta_description_13, n0_.active AS active_14, n0_.deleted AS deleted_15, n0_.image AS image_16, n0_.created_at AS created_at_17, n0_.updated_at AS updated_at_18, n0_.updated_by_id AS updated_by_id_19 FROM news n0_ WHERE (n0_.active = 1 AND n0_.deleted = 0) AND n0_.publish_date <= ? AND n0_.publish_date < ? ORDER BY n0_.publish_date DESC LIMIT 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.id = ? AND t0.deleted = ? AND t0.active = ? LIMIT 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.id = ? AND t0.deleted = ? AND t0.active = ? LIMIT 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.id = ? AND t0.deleted = ? AND t0.active = ? LIMIT 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 = ?
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
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
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 = ?
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.menu_item_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.content2 AS content2_2, t0.cta_text AS cta_text_3, t0.cta_link AS cta_link_4, t0.cta_text2 AS cta_text2_5, t0.cta_link2 AS cta_link2_6, t0.icon AS icon_7, t0.employer_or_employee AS employer_or_employee_8, t0.show_on_menu AS show_on_menu_9, t0.slug AS slug_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.image AS image_14, t0.sort_order AS sort_order_15, t0.active AS active_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.deleted AS deleted_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.testimonial_id AS testimonial_id_22, t0.category_id AS category_id_23 FROM service t0 WHERE t0.active = ? AND t0.deleted = ? AND t0.category_id = ? AND t0.show_on_menu = ?
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.menu_item_id = ? LIMIT 1
SELECT t0.id AS id_1, t0.content2 AS content2_2, t0.cta_text AS cta_text_3, t0.cta_link AS cta_link_4, t0.cta_text2 AS cta_text2_5, t0.cta_link2 AS cta_link2_6, t0.icon AS icon_7, t0.employer_or_employee AS employer_or_employee_8, t0.show_on_menu AS show_on_menu_9, t0.slug AS slug_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.image AS image_14, t0.sort_order AS sort_order_15, t0.active AS active_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.deleted AS deleted_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.testimonial_id AS testimonial_id_22, t0.category_id AS category_id_23 FROM service t0 WHERE t0.active = ? AND t0.deleted = ? AND t0.category_id = ? AND t0.show_on_menu = ?
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
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
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
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 = ?
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
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 = ?
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
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 = ?
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0
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
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 = ?

#▲	Time	Info
1	1.36 ms	SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_ Parameters: [] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_ SELECT p0_.id AS id_0, p0_.slug AS slug_1 FROM page p0_;
2	1.47 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.content3 AS content3_9, t0.cta_text AS cta_text_10, t0.cta_link AS cta_link_11, t0.landing_page_blocks AS landing_page_blocks_12, t0.title AS title_13, t0.content AS content_14, t0.subtitle AS subtitle_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.content2 AS content2_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26, t0.testimonial_id AS testimonial_id_27, t28.id AS id_29, t28.title AS title_30, t28.content AS content_31, t28.active AS active_32, t28.deleted AS deleted_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.sort_order AS sort_order_36, t28.page_id AS page_id_37 FROM page t0 LEFT JOIN areas_we_cover t28 ON t28.page_id = t0.id WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1 Parameters: [`"blog/navigating-employee-holidays" 0 1`] View formatted query View runnable query Explain query 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.content3 AS content3_9, t0.cta_text AS cta_text_10, t0.cta_link AS cta_link_11, t0.landing_page_blocks AS landing_page_blocks_12, t0.title AS title_13, t0.content AS content_14, t0.subtitle AS subtitle_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.content2 AS content2_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26, t0.testimonial_id AS testimonial_id_27, t28.id AS id_29, t28.title AS title_30, t28.content AS content_31, t28.active AS active_32, t28.deleted AS deleted_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.sort_order AS sort_order_36, t28.page_id AS page_id_37 FROM page t0 LEFT JOIN areas_we_cover t28 ON t28.page_id = t0.id WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 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.content3 AS content3_9, t0.cta_text AS cta_text_10, t0.cta_link AS cta_link_11, t0.landing_page_blocks AS landing_page_blocks_12, t0.title AS title_13, t0.content AS content_14, t0.subtitle AS subtitle_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.content2 AS content2_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26, t0.testimonial_id AS testimonial_id_27, t28.id AS id_29, t28.title AS title_30, t28.content AS content_31, t28.active AS active_32, t28.deleted AS deleted_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.sort_order AS sort_order_36, t28.page_id AS page_id_37 FROM page t0 LEFT JOIN areas_we_cover t28 ON t28.page_id = t0.id WHERE t0.slug = 'blog/navigating-employee-holidays' AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;
3	2.42 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.content3 AS content3_9, t0.cta_text AS cta_text_10, t0.cta_link AS cta_link_11, t0.landing_page_blocks AS landing_page_blocks_12, t0.title AS title_13, t0.content AS content_14, t0.subtitle AS subtitle_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.content2 AS content2_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26, t0.testimonial_id AS testimonial_id_27, t28.id AS id_29, t28.title AS title_30, t28.content AS content_31, t28.active AS active_32, t28.deleted AS deleted_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.sort_order AS sort_order_36, t28.page_id AS page_id_37 FROM page t0 LEFT JOIN areas_we_cover t28 ON t28.page_id = t0.id Parameters: [] View formatted query View runnable query Explain query 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.content3 AS content3_9, t0.cta_text AS cta_text_10, t0.cta_link AS cta_link_11, t0.landing_page_blocks AS landing_page_blocks_12, t0.title AS title_13, t0.content AS content_14, t0.subtitle AS subtitle_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.content2 AS content2_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26, t0.testimonial_id AS testimonial_id_27, t28.id AS id_29, t28.title AS title_30, t28.content AS content_31, t28.active AS active_32, t28.deleted AS deleted_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.sort_order AS sort_order_36, t28.page_id AS page_id_37 FROM page t0 LEFT JOIN areas_we_cover t28 ON t28.page_id = t0.id 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.content3 AS content3_9, t0.cta_text AS cta_text_10, t0.cta_link AS cta_link_11, t0.landing_page_blocks AS landing_page_blocks_12, t0.title AS title_13, t0.content AS content_14, t0.subtitle AS subtitle_15, t0.meta_title AS meta_title_16, t0.meta_description AS meta_description_17, t0.active AS active_18, t0.deleted AS deleted_19, t0.image AS image_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.content2 AS content2_23, t0.update_by AS update_by_24, t0.parent AS parent_25, t0.template_id AS template_id_26, t0.testimonial_id AS testimonial_id_27, t28.id AS id_29, t28.title AS title_30, t28.content AS content_31, t28.active AS active_32, t28.deleted AS deleted_33, t28.created_at AS created_at_34, t28.updated_at AS updated_at_35, t28.sort_order AS sort_order_36, t28.page_id AS page_id_37 FROM page t0 LEFT JOIN areas_we_cover t28 ON t28.page_id = t0.id;
4	5.98 ms	SELECT t0.id AS id_1, t0.excerpt AS excerpt_2, t0.publish_date AS publish_date_3, t0.thumbnail AS thumbnail_4, t0.cta_text AS cta_text_5, t0.cta_link AS cta_link_6, t0.featured_on_news_page AS featured_on_news_page_7, t0.featured_in_wisdom_component AS featured_in_wisdom_component_8, t0.slug AS slug_9, t0.title AS title_10, t0.content AS content_11, t0.subtitle AS subtitle_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.image AS image_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.updated_by_id AS updated_by_id_20 FROM news t0 WHERE t0.slug = ? LIMIT 1 Parameters: [`"navigating-employee-holidays"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.excerpt AS excerpt_2, t0.publish_date AS publish_date_3, t0.thumbnail AS thumbnail_4, t0.cta_text AS cta_text_5, t0.cta_link AS cta_link_6, t0.featured_on_news_page AS featured_on_news_page_7, t0.featured_in_wisdom_component AS featured_in_wisdom_component_8, t0.slug AS slug_9, t0.title AS title_10, t0.content AS content_11, t0.subtitle AS subtitle_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.image AS image_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.updated_by_id AS updated_by_id_20 FROM news t0 WHERE t0.slug = ? LIMIT 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.cta_text AS cta_text_5, t0.cta_link AS cta_link_6, t0.featured_on_news_page AS featured_on_news_page_7, t0.featured_in_wisdom_component AS featured_in_wisdom_component_8, t0.slug AS slug_9, t0.title AS title_10, t0.content AS content_11, t0.subtitle AS subtitle_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.image AS image_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.updated_by_id AS updated_by_id_20 FROM news t0 WHERE t0.slug = 'navigating-employee-holidays' LIMIT 1;
5	1.33 ms	SELECT t0.id AS id_1, t0.excerpt AS excerpt_2, t0.publish_date AS publish_date_3, t0.thumbnail AS thumbnail_4, t0.cta_text AS cta_text_5, t0.cta_link AS cta_link_6, t0.featured_on_news_page AS featured_on_news_page_7, t0.featured_in_wisdom_component AS featured_in_wisdom_component_8, t0.slug AS slug_9, t0.title AS title_10, t0.content AS content_11, t0.subtitle AS subtitle_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.image AS image_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.updated_by_id AS updated_by_id_20 FROM news t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1 Parameters: [`"navigating-employee-holidays" 0 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.excerpt AS excerpt_2, t0.publish_date AS publish_date_3, t0.thumbnail AS thumbnail_4, t0.cta_text AS cta_text_5, t0.cta_link AS cta_link_6, t0.featured_on_news_page AS featured_on_news_page_7, t0.featured_in_wisdom_component AS featured_in_wisdom_component_8, t0.slug AS slug_9, t0.title AS title_10, t0.content AS content_11, t0.subtitle AS subtitle_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.image AS image_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.updated_by_id AS updated_by_id_20 FROM news t0 WHERE t0.slug = ? AND t0.deleted = ? AND t0.active = ? LIMIT 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.cta_text AS cta_text_5, t0.cta_link AS cta_link_6, t0.featured_on_news_page AS featured_on_news_page_7, t0.featured_in_wisdom_component AS featured_in_wisdom_component_8, t0.slug AS slug_9, t0.title AS title_10, t0.content AS content_11, t0.subtitle AS subtitle_12, t0.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.active AS active_15, t0.deleted AS deleted_16, t0.image AS image_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.updated_by_id AS updated_by_id_20 FROM news t0 WHERE t0.slug = 'navigating-employee-holidays' AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;
6	12.39 ms	SELECT n0_.id AS id_0, n0_.excerpt AS excerpt_1, n0_.publish_date AS publish_date_2, n0_.thumbnail AS thumbnail_3, n0_.cta_text AS cta_text_4, n0_.cta_link AS cta_link_5, n0_.featured_on_news_page AS featured_on_news_page_6, n0_.featured_in_wisdom_component AS featured_in_wisdom_component_7, n0_.slug AS slug_8, n0_.title AS title_9, n0_.content AS content_10, n0_.subtitle AS subtitle_11, n0_.meta_title AS meta_title_12, n0_.meta_description AS meta_description_13, n0_.active AS active_14, n0_.deleted AS deleted_15, n0_.image AS image_16, n0_.created_at AS created_at_17, n0_.updated_at AS updated_at_18, n0_.updated_by_id AS updated_by_id_19 FROM news n0_ WHERE (n0_.active = 1 AND n0_.deleted = 0) AND n0_.publish_date <= ? AND n0_.publish_date > ? ORDER BY n0_.publish_date ASC LIMIT 1 Parameters: [`"2026-03-20 08:44:32" "2023-07-01 15:29:00"`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.excerpt AS excerpt_1, n0_.publish_date AS publish_date_2, n0_.thumbnail AS thumbnail_3, n0_.cta_text AS cta_text_4, n0_.cta_link AS cta_link_5, n0_.featured_on_news_page AS featured_on_news_page_6, n0_.featured_in_wisdom_component AS featured_in_wisdom_component_7, n0_.slug AS slug_8, n0_.title AS title_9, n0_.content AS content_10, n0_.subtitle AS subtitle_11, n0_.meta_title AS meta_title_12, n0_.meta_description AS meta_description_13, n0_.active AS active_14, n0_.deleted AS deleted_15, n0_.image AS image_16, n0_.created_at AS created_at_17, n0_.updated_at AS updated_at_18, n0_.updated_by_id AS updated_by_id_19 FROM news n0_ WHERE ( n0_.active = 1 AND n0_.deleted = 0 ) AND n0_.publish_date <= ? AND n0_.publish_date > ? ORDER BY n0_.publish_date ASC LIMIT 1 SELECT n0_.id AS id_0, n0_.excerpt AS excerpt_1, n0_.publish_date AS publish_date_2, n0_.thumbnail AS thumbnail_3, n0_.cta_text AS cta_text_4, n0_.cta_link AS cta_link_5, n0_.featured_on_news_page AS featured_on_news_page_6, n0_.featured_in_wisdom_component AS featured_in_wisdom_component_7, n0_.slug AS slug_8, n0_.title AS title_9, n0_.content AS content_10, n0_.subtitle AS subtitle_11, n0_.meta_title AS meta_title_12, n0_.meta_description AS meta_description_13, n0_.active AS active_14, n0_.deleted AS deleted_15, n0_.image AS image_16, n0_.created_at AS created_at_17, n0_.updated_at AS updated_at_18, n0_.updated_by_id AS updated_by_id_19 FROM news n0_ WHERE (n0_.active = 1 AND n0_.deleted = 0) AND n0_.publish_date <= '2026-03-20 08:44:32' AND n0_.publish_date > '2023-07-01 15:29:00' ORDER BY n0_.publish_date ASC LIMIT 1;
7	2.08 ms	SELECT n0_.id AS id_0, n0_.excerpt AS excerpt_1, n0_.publish_date AS publish_date_2, n0_.thumbnail AS thumbnail_3, n0_.cta_text AS cta_text_4, n0_.cta_link AS cta_link_5, n0_.featured_on_news_page AS featured_on_news_page_6, n0_.featured_in_wisdom_component AS featured_in_wisdom_component_7, n0_.slug AS slug_8, n0_.title AS title_9, n0_.content AS content_10, n0_.subtitle AS subtitle_11, n0_.meta_title AS meta_title_12, n0_.meta_description AS meta_description_13, n0_.active AS active_14, n0_.deleted AS deleted_15, n0_.image AS image_16, n0_.created_at AS created_at_17, n0_.updated_at AS updated_at_18, n0_.updated_by_id AS updated_by_id_19 FROM news n0_ WHERE (n0_.active = 1 AND n0_.deleted = 0) AND n0_.publish_date <= ? AND n0_.publish_date < ? ORDER BY n0_.publish_date DESC LIMIT 1 Parameters: [`"2026-03-20 08:44:32" "2023-07-01 15:29:00"`] View formatted query View runnable query Explain query SELECT n0_.id AS id_0, n0_.excerpt AS excerpt_1, n0_.publish_date AS publish_date_2, n0_.thumbnail AS thumbnail_3, n0_.cta_text AS cta_text_4, n0_.cta_link AS cta_link_5, n0_.featured_on_news_page AS featured_on_news_page_6, n0_.featured_in_wisdom_component AS featured_in_wisdom_component_7, n0_.slug AS slug_8, n0_.title AS title_9, n0_.content AS content_10, n0_.subtitle AS subtitle_11, n0_.meta_title AS meta_title_12, n0_.meta_description AS meta_description_13, n0_.active AS active_14, n0_.deleted AS deleted_15, n0_.image AS image_16, n0_.created_at AS created_at_17, n0_.updated_at AS updated_at_18, n0_.updated_by_id AS updated_by_id_19 FROM news n0_ WHERE ( n0_.active = 1 AND n0_.deleted = 0 ) AND n0_.publish_date <= ? AND n0_.publish_date < ? ORDER BY n0_.publish_date DESC LIMIT 1 SELECT n0_.id AS id_0, n0_.excerpt AS excerpt_1, n0_.publish_date AS publish_date_2, n0_.thumbnail AS thumbnail_3, n0_.cta_text AS cta_text_4, n0_.cta_link AS cta_link_5, n0_.featured_on_news_page AS featured_on_news_page_6, n0_.featured_in_wisdom_component AS featured_in_wisdom_component_7, n0_.slug AS slug_8, n0_.title AS title_9, n0_.content AS content_10, n0_.subtitle AS subtitle_11, n0_.meta_title AS meta_title_12, n0_.meta_description AS meta_description_13, n0_.active AS active_14, n0_.deleted AS deleted_15, n0_.image AS image_16, n0_.created_at AS created_at_17, n0_.updated_at AS updated_at_18, n0_.updated_by_id AS updated_by_id_19 FROM news n0_ WHERE (n0_.active = 1 AND n0_.deleted = 0) AND n0_.publish_date <= '2026-03-20 08:44:32' AND n0_.publish_date < '2023-07-01 15:29:00' ORDER BY n0_.publish_date DESC LIMIT 1;
8	1.56 ms	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.id = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1 Parameters: [`1 0 1`] View formatted query View runnable query Explain query 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.id = ? AND t0.deleted = ? AND t0.active = ? LIMIT 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.id = 1 AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;
9	1.24 ms	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.id = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1 Parameters: [`12 0 1`] View formatted query View runnable query Explain query 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.id = ? AND t0.deleted = ? AND t0.active = ? LIMIT 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.id = 12 AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;
10	1.06 ms	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.id = ? AND t0.deleted = ? AND t0.active = ? LIMIT 1 Parameters: [`9 0 1`] View formatted query View runnable query Explain query 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.id = ? AND t0.deleted = ? AND t0.active = ? LIMIT 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.id = 9 AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;
11	1.12 ms	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: [`8`] View formatted query View runnable query Explain query 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 = ? 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 = 8;
12	1.36 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`2`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 2 AND s0_.active = 1 AND s0_.deleted = 0;
13	1.08 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`2`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 2 AND s0_.active = 1 AND s0_.deleted = 0;
14	0.82 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`3`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 3 AND s0_.active = 1 AND s0_.deleted = 0;
15	0.76 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`3`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 3 AND s0_.active = 1 AND s0_.deleted = 0;
16	0.73 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`4`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 4 AND s0_.active = 1 AND s0_.deleted = 0;
17	0.63 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`4`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 4 AND s0_.active = 1 AND s0_.deleted = 0;
18	0.66 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`5`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 5 AND s0_.active = 1 AND s0_.deleted = 0;
19	0.65 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`5`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 5 AND s0_.active = 1 AND s0_.deleted = 0;
20	0.64 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`6`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 6 AND s0_.active = 1 AND s0_.deleted = 0;
21	0.76 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`6`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 6 AND s0_.active = 1 AND s0_.deleted = 0;
22	0.89 ms	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"`] View formatted query View runnable query Explain query 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 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 = 'Top' LIMIT 1;
23	1.17 ms	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`] View formatted query View runnable query Explain query 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 = ? 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 = 1;
24	0.79 ms	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.menu_item_id = ? LIMIT 1 Parameters: [`11`] View formatted query View runnable query Explain query 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.menu_item_id = ? LIMIT 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.menu_item_id = 11 LIMIT 1;
25	1.53 ms	SELECT t0.id AS id_1, t0.content2 AS content2_2, t0.cta_text AS cta_text_3, t0.cta_link AS cta_link_4, t0.cta_text2 AS cta_text2_5, t0.cta_link2 AS cta_link2_6, t0.icon AS icon_7, t0.employer_or_employee AS employer_or_employee_8, t0.show_on_menu AS show_on_menu_9, t0.slug AS slug_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.image AS image_14, t0.sort_order AS sort_order_15, t0.active AS active_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.deleted AS deleted_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.testimonial_id AS testimonial_id_22, t0.category_id AS category_id_23 FROM service t0 WHERE t0.active = ? AND t0.deleted = ? AND t0.category_id = ? AND t0.show_on_menu = ? Parameters: [`1 0 1 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.content2 AS content2_2, t0.cta_text AS cta_text_3, t0.cta_link AS cta_link_4, t0.cta_text2 AS cta_text2_5, t0.cta_link2 AS cta_link2_6, t0.icon AS icon_7, t0.employer_or_employee AS employer_or_employee_8, t0.show_on_menu AS show_on_menu_9, t0.slug AS slug_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.image AS image_14, t0.sort_order AS sort_order_15, t0.active AS active_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.deleted AS deleted_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.testimonial_id AS testimonial_id_22, t0.category_id AS category_id_23 FROM service t0 WHERE t0.active = ? AND t0.deleted = ? AND t0.category_id = ? AND t0.show_on_menu = ? SELECT t0.id AS id_1, t0.content2 AS content2_2, t0.cta_text AS cta_text_3, t0.cta_link AS cta_link_4, t0.cta_text2 AS cta_text2_5, t0.cta_link2 AS cta_link2_6, t0.icon AS icon_7, t0.employer_or_employee AS employer_or_employee_8, t0.show_on_menu AS show_on_menu_9, t0.slug AS slug_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.image AS image_14, t0.sort_order AS sort_order_15, t0.active AS active_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.deleted AS deleted_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.testimonial_id AS testimonial_id_22, t0.category_id AS category_id_23 FROM service t0 WHERE t0.active = 1 AND t0.deleted = 0 AND t0.category_id = 1 AND t0.show_on_menu = 1;
26	1.08 ms	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.menu_item_id = ? LIMIT 1 Parameters: [`12`] View formatted query View runnable query Explain query 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.menu_item_id = ? LIMIT 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.menu_item_id = 12 LIMIT 1;
27	1.19 ms	SELECT t0.id AS id_1, t0.content2 AS content2_2, t0.cta_text AS cta_text_3, t0.cta_link AS cta_link_4, t0.cta_text2 AS cta_text2_5, t0.cta_link2 AS cta_link2_6, t0.icon AS icon_7, t0.employer_or_employee AS employer_or_employee_8, t0.show_on_menu AS show_on_menu_9, t0.slug AS slug_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.image AS image_14, t0.sort_order AS sort_order_15, t0.active AS active_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.deleted AS deleted_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.testimonial_id AS testimonial_id_22, t0.category_id AS category_id_23 FROM service t0 WHERE t0.active = ? AND t0.deleted = ? AND t0.category_id = ? AND t0.show_on_menu = ? Parameters: [`1 0 2 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.content2 AS content2_2, t0.cta_text AS cta_text_3, t0.cta_link AS cta_link_4, t0.cta_text2 AS cta_text2_5, t0.cta_link2 AS cta_link2_6, t0.icon AS icon_7, t0.employer_or_employee AS employer_or_employee_8, t0.show_on_menu AS show_on_menu_9, t0.slug AS slug_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.image AS image_14, t0.sort_order AS sort_order_15, t0.active AS active_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.deleted AS deleted_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.testimonial_id AS testimonial_id_22, t0.category_id AS category_id_23 FROM service t0 WHERE t0.active = ? AND t0.deleted = ? AND t0.category_id = ? AND t0.show_on_menu = ? SELECT t0.id AS id_1, t0.content2 AS content2_2, t0.cta_text AS cta_text_3, t0.cta_link AS cta_link_4, t0.cta_text2 AS cta_text2_5, t0.cta_link2 AS cta_link2_6, t0.icon AS icon_7, t0.employer_or_employee AS employer_or_employee_8, t0.show_on_menu AS show_on_menu_9, t0.slug AS slug_10, t0.title AS title_11, t0.content AS content_12, t0.subtitle AS subtitle_13, t0.image AS image_14, t0.sort_order AS sort_order_15, t0.active AS active_16, t0.meta_title AS meta_title_17, t0.meta_description AS meta_description_18, t0.deleted AS deleted_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.testimonial_id AS testimonial_id_22, t0.category_id AS category_id_23 FROM service t0 WHERE t0.active = 1 AND t0.deleted = 0 AND t0.category_id = 2 AND t0.show_on_menu = 1;
28	1.22 ms	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: [`"Contact Details" 0 1`] View formatted query View runnable query Explain query 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 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 = 'Contact Details' AND t0.deleted = 0 AND t0.active = 1 LIMIT 1;
29	0.96 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`4`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 4 AND s0_.active = 1 AND s0_.deleted = 0;
30	0.89 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`4`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 4 AND s0_.active = 1 AND s0_.deleted = 0;
31	0.63 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`5`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 5 AND s0_.active = 1 AND s0_.deleted = 0;
32	0.69 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`5`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 5 AND s0_.active = 1 AND s0_.deleted = 0;
33	0.62 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`6`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 6 AND s0_.active = 1 AND s0_.deleted = 0;
34	0.59 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`6`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 6 AND s0_.active = 1 AND s0_.deleted = 0;
35	0.66 ms	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: [`"Footer - Primary"`] View formatted query View runnable query Explain query 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 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 = 'Footer - Primary' LIMIT 1;
36	0.76 ms	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: [`2`] View formatted query View runnable query Explain query 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 = ? 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 = 2;
37	1.15 ms	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: [`"Footer - Knowledge Base"`] View formatted query View runnable query Explain query 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 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 = 'Footer - Knowledge Base' LIMIT 1;
38	0.77 ms	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: [`4`] View formatted query View runnable query Explain query 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 = ? 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 = 4;
39	1.12 ms	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: [`"Footer - Areas"`] View formatted query View runnable query Explain query 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 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 = 'Footer - Areas' LIMIT 1;
40	1.09 ms	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: [`3`] View formatted query View runnable query Explain query 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 = ? 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 = 3;
41	1.07 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`2`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 2 AND s0_.active = 1 AND s0_.deleted = 0;
42	0.81 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`2`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 2 AND s0_.active = 1 AND s0_.deleted = 0;
43	0.75 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`2`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 2 AND s0_.active = 1 AND s0_.deleted = 0;
44	0.68 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`2`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 2 AND s0_.active = 1 AND s0_.deleted = 0;
45	0.72 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`3`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 3 AND s0_.active = 1 AND s0_.deleted = 0;
46	0.62 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`3`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 3 AND s0_.active = 1 AND s0_.deleted = 0;
47	0.56 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`3`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 3 AND s0_.active = 1 AND s0_.deleted = 0;
48	0.63 ms	SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 Parameters: [`3`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = ? AND s0_.active = 1 AND s0_.deleted = 0 SELECT s0_.id AS id_0, s0_.display_text AS display_text_1, s0_.title AS title_2, s0_.content AS content_3, s0_.active AS active_4, s0_.deleted AS deleted_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.image AS image_8, s0_.file AS file_9, s0_.video AS video_10 FROM setting s0_ WHERE s0_.id = 3 AND s0_.active = 1 AND s0_.deleted = 0;
49	0.90 ms	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: [`"Footer - Compliance"`] View formatted query View runnable query Explain query 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 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 = 'Footer - Compliance' LIMIT 1;
50	0.72 ms	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: [`5`] View formatted query View runnable query Explain query 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 = ? 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 = 5;

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\Testimonial	No errors.
App\Entity\AreasWeCover	No errors.
App\Entity\MenuItems	No errors.
App\Entity\Slider	No errors.
App\Entity\PagePreview	No errors.
App\Entity\News	No errors.
App\Entity\Menu	No errors.
App\Entity\SliderImages	No errors.
App\Entity\Enquiry	No errors.
App\Entity\HtmlBlocks	No errors.
App\Entity\Setting	No errors.
App\Entity\Service	No errors.
App\Entity\ServiceCategory	No errors.

Symfony Profiler

https://taurushr.thetlb.dev/blog/navigating-employee-holidays

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping