Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.is_published AS is_published_3,
  t0.theme AS theme_4,
  t0.theme_color AS theme_color_5,
  t0.modules AS modules_6,
  t0.header_logo AS header_logo_7,
  t0.footer_logo AS footer_logo_8,
  t0.facebook_url AS facebook_url_9,
  t0.facebook_id AS facebook_id_10,
  t0.twitter_url AS twitter_url_11,
  t0.twitter_username AS twitter_username_12,
  t0.linkedin_url AS linkedin_url_13,
  t0.youtube_url AS youtube_url_14,
  t0.pinterest_url AS pinterest_url_15,
  t0.google_analytics_id AS google_analytics_id_16,
  t0.google_site_verification AS google_site_verification_17,
  t0.bing_site_verification AS bing_site_verification_18,
  t0.pinterest_site_verification AS pinterest_site_verification_19,
  t0.is_boxed_layout AS is_boxed_layout_20,
  t0.background_color AS background_color_21,
  t0.background AS background_22,
  t0.specials_background AS specials_background_23,
  t0.icon AS icon_24,
  t0.favicon AS favicon_25,
  t0.icon_tile_background AS icon_tile_background_26,
  t0.texts AS texts_27,
  t0.callback_background AS callback_background_28,
  t0.livechat AS livechat_29,
  t0.livechat_badge_image AS livechat_badge_image_30,
  t0.livechat_operator_avatar AS livechat_operator_avatar_31,
  t0.email_logo AS email_logo_32,
  t0.covered_areas_image AS covered_areas_image_33,
  t0.place_name AS place_name_34,
  t0.company_id AS company_id_35,
  t36.id AS id_37,
  t36.page_heading AS page_heading_38,
  t36.page_breadcrumb AS page_breadcrumb_39,
  t36.page_title AS page_title_40,
  t36.social_title AS social_title_41,
  t36.social_description AS social_description_42,
  t36.meta_description AS meta_description_43,
  t36.meta_keywords AS meta_keywords_44,
  t36.meta_robots AS meta_robots_45,
  t36.content AS content_46,
  t36.images AS images_47,
  t36.carousel_setting AS carousel_setting_48,
  t36.carousel_background AS carousel_background_49,
  t36.carousel_slides AS carousel_slides_50,
  t36.editor_note AS editor_note_51,
  t36.domain_id AS domain_id_52,
  t53.id AS id_54,
  t53.address_label AS address_label_55,
  t53.postcode AS postcode_56,
  t53.town AS town_57,
  t53.county AS county_58,
  t53.street_1 AS street_1_59,
  t53.street_2 AS street_2_60,
  t53.latitude AS latitude_61,
  t53.longitude AS longitude_62,
  t53.map_zoom AS map_zoom_63,
  t53.phone_1 AS phone_1_64,
  t53.phone_1_label AS phone_1_label_65,
  t53.phone_1_in_header AS phone_1_in_header_66,
  t53.phone_2 AS phone_2_67,
  t53.phone_2_label AS phone_2_label_68,
  t53.phone_2_in_header AS phone_2_in_header_69,
  t53.fax AS fax_70,
  t53.fax_label AS fax_label_71,
  t53.email AS email_72,
  t53.email_label AS email_label_73,
  t53.working_hours AS working_hours_74,
  t53.content AS content_75,
  t53.image AS image_76,
  t53.is_published AS is_published_77,
  t53.sort AS sort_78,
  t53.editor_note AS editor_note_79,
  t53.domain_id AS domain_id_80,
  t81.id AS id_82,
  t81.page_heading AS page_heading_83,
  t81.page_breadcrumb AS page_breadcrumb_84,
  t81.social_title AS social_title_85,
  t81.social_description AS social_description_86,
  t81.meta_description AS meta_description_87,
  t81.meta_robots AS meta_robots_88,
  t81.content AS content_89,
  t81.images AS images_90,
  t81.carousel_settings AS carousel_settings_91,
  t81.carousel_background AS carousel_background_92,
  t81.carousel_slides AS carousel_slides_93,
  t81.editor_note AS editor_note_94,
  t81.page_title AS page_title_95,
  t81.domain_id AS domain_id_96,
  t97.id AS id_98,
  t97.page_heading AS page_heading_99,
  t97.page_breadcrumb AS page_breadcrumb_100,
  t97.page_title AS page_title_101,
  t97.social_title AS social_title_102,
  t97.social_description AS social_description_103,
  t97.meta_description AS meta_description_104,
  t97.meta_keyword AS meta_keyword_105,
  t97.meta_robots AS meta_robots_106,
  t97.content AS content_107,
  t97.images AS images_108,
  t97.carousel_settings AS carousel_settings_109,
  t97.carousel_background AS carousel_background_110,
  t97.carousel_slides AS carousel_slides_111,
  t97.editor_note AS editor_note_112,
  t97.domain_id AS domain_id_113,
  t114.id AS id_115,
  t114.page_heading AS page_heading_116,
  t114.page_subheading AS page_subheading_117,
  t114.page_title AS page_title_118,
  t114.social_title AS social_title_119,
  t114.social_description AS social_description_120,
  t114.meta_description AS meta_description_121,
  t114.meta_keywords AS meta_keywords_122,
  t114.content AS content_123,
  t114.thumbnail AS thumbnail_124,
  t114.images AS images_125,
  t114.carousel_settings AS carousel_settings_126,
  t114.carousel_background AS carousel_background_127,
  t114.carousel_slides AS carousel_slides_128,
  t114.texts AS texts_129,
  t114.created_at AS created_at_130,
  t114.editor_note AS editor_note_131,
  t114.domain_id AS domain_id_132
FROM
  domain t0
  LEFT JOIN about t36 ON t36.domain_id = t0.id
  LEFT JOIN contact t53 ON t53.domain_id = t0.id
  LEFT JOIN privacy_cookies t81 ON t81.domain_id = t0.id
  LEFT JOIN privacy_terms t97 ON t97.domain_id = t0.id
  LEFT JOIN homepage t114 ON t114.domain_id = t0.id
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.is_published AS is_published_3, t0.theme AS theme_4, t0.theme_color AS theme_color_5, t0.modules AS modules_6, t0.header_logo AS header_logo_7, t0.footer_logo AS footer_logo_8, t0.facebook_url AS facebook_url_9, t0.facebook_id AS facebook_id_10, t0.twitter_url AS twitter_url_11, t0.twitter_username AS twitter_username_12, t0.linkedin_url AS linkedin_url_13, t0.youtube_url AS youtube_url_14, t0.pinterest_url AS pinterest_url_15, t0.google_analytics_id AS google_analytics_id_16, t0.google_site_verification AS google_site_verification_17, t0.bing_site_verification AS bing_site_verification_18, t0.pinterest_site_verification AS pinterest_site_verification_19, t0.is_boxed_layout AS is_boxed_layout_20, t0.background_color AS background_color_21, t0.background AS background_22, t0.specials_background AS specials_background_23, t0.icon AS icon_24, t0.favicon AS favicon_25, t0.icon_tile_background AS icon_tile_background_26, t0.texts AS texts_27, t0.callback_background AS callback_background_28, t0.livechat AS livechat_29, t0.livechat_badge_image AS livechat_badge_image_30, t0.livechat_operator_avatar AS livechat_operator_avatar_31, t0.email_logo AS email_logo_32, t0.covered_areas_image AS covered_areas_image_33, t0.place_name AS place_name_34, t0.company_id AS company_id_35, t36.id AS id_37, t36.page_heading AS page_heading_38, t36.page_breadcrumb AS page_breadcrumb_39, t36.page_title AS page_title_40, t36.social_title AS social_title_41, t36.social_description AS social_description_42, t36.meta_description AS meta_description_43, t36.meta_keywords AS meta_keywords_44, t36.meta_robots AS meta_robots_45, t36.content AS content_46, t36.images AS images_47, t36.carousel_setting AS carousel_setting_48, t36.carousel_background AS carousel_background_49, t36.carousel_slides AS carousel_slides_50, t36.editor_note AS editor_note_51, t36.domain_id AS domain_id_52, t53.id AS id_54, t53.address_label AS address_label_55, t53.postcode AS postcode_56, t53.town AS town_57, t53.county AS county_58, t53.street_1 AS street_1_59, t53.street_2 AS street_2_60, t53.latitude AS latitude_61, t53.longitude AS longitude_62, t53.map_zoom AS map_zoom_63, t53.phone_1 AS phone_1_64, t53.phone_1_label AS phone_1_label_65, t53.phone_1_in_header AS phone_1_in_header_66, t53.phone_2 AS phone_2_67, t53.phone_2_label AS phone_2_label_68, t53.phone_2_in_header AS phone_2_in_header_69, t53.fax AS fax_70, t53.fax_label AS fax_label_71, t53.email AS email_72, t53.email_label AS email_label_73, t53.working_hours AS working_hours_74, t53.content AS content_75, t53.image AS image_76, t53.is_published AS is_published_77, t53.sort AS sort_78, t53.editor_note AS editor_note_79, t53.domain_id AS domain_id_80, t81.id AS id_82, t81.page_heading AS page_heading_83, t81.page_breadcrumb AS page_breadcrumb_84, t81.social_title AS social_title_85, t81.social_description AS social_description_86, t81.meta_description AS meta_description_87, t81.meta_robots AS meta_robots_88, t81.content AS content_89, t81.images AS images_90, t81.carousel_settings AS carousel_settings_91, t81.carousel_background AS carousel_background_92, t81.carousel_slides AS carousel_slides_93, t81.editor_note AS editor_note_94, t81.page_title AS page_title_95, t81.domain_id AS domain_id_96, t97.id AS id_98, t97.page_heading AS page_heading_99, t97.page_breadcrumb AS page_breadcrumb_100, t97.page_title AS page_title_101, t97.social_title AS social_title_102, t97.social_description AS social_description_103, t97.meta_description AS meta_description_104, t97.meta_keyword AS meta_keyword_105, t97.meta_robots AS meta_robots_106, t97.content AS content_107, t97.images AS images_108, t97.carousel_settings AS carousel_settings_109, t97.carousel_background AS carousel_background_110, t97.carousel_slides AS carousel_slides_111, t97.editor_note AS editor_note_112, t97.domain_id AS domain_id_113, t114.id AS id_115, t114.page_heading AS page_heading_116, t114.page_subheading AS page_subheading_117, t114.page_title AS page_title_118, t114.social_title AS social_title_119, t114.social_description AS social_description_120, t114.meta_description AS meta_description_121, t114.meta_keywords AS meta_keywords_122, t114.content AS content_123, t114.thumbnail AS thumbnail_124, t114.images AS images_125, t114.carousel_settings AS carousel_settings_126, t114.carousel_background AS carousel_background_127, t114.carousel_slides AS carousel_slides_128, t114.texts AS texts_129, t114.created_at AS created_at_130, t114.editor_note AS editor_note_131, t114.domain_id AS domain_id_132 FROM domain t0 LEFT JOIN about t36 ON t36.domain_id = t0.id LEFT JOIN contact t53 ON t53.domain_id = t0.id LEFT JOIN privacy_cookies t81 ON t81.domain_id = t0.id LEFT JOIN privacy_terms t97 ON t97.domain_id = t0.id LEFT JOIN homepage t114 ON t114.domain_id = t0.id WHERE t0.name = 'woodfloorsanding.london' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.place_type AS place_type_2,
  t0.name AS name_3,
  t0.url AS url_4,
  t0.postcodes AS postcodes_5,
  t0.region_id AS region_id_6,
  t0.parent_id AS parent_id_7
FROM
  place t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.place_type AS place_type_2, t0.name AS name_3, t0.url AS url_4, t0.postcodes AS postcodes_5, t0.region_id AS region_id_6, t0.parent_id AS parent_id_7 FROM place t0 WHERE t0.url = 'bromley-by-bow' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.page_url AS page_url_2,
  t0.page_heading AS page_heading_3,
  t0.page_subheading AS page_subheading_4,
  t0.page_breadcrumb AS page_breadcrumb_5,
  t0.page_title AS page_title_6,
  t0.social_title AS social_title_7,
  t0.social_description AS social_description_8,
  t0.meta_description AS meta_description_9,
  t0.meta_keyword AS meta_keyword_10,
  t0.meta_robots AS meta_robots_11,
  t0.content AS content_12,
  t0.thumbnail AS thumbnail_13,
  t0.is_published AS is_published_14,
  t0.created_at AS created_at_15,
  t0.editor_note AS editor_note_16,
  t0.domain_id AS domain_id_17,
  t0.place_id AS place_id_18
FROM
  places_content t0
WHERE
  t0.domain_id = ?
  AND t0.place_id = ?
  AND t0.is_published = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.page_url AS page_url_2, t0.page_heading AS page_heading_3, t0.page_subheading AS page_subheading_4, t0.page_breadcrumb AS page_breadcrumb_5, t0.page_title AS page_title_6, t0.social_title AS social_title_7, t0.social_description AS social_description_8, t0.meta_description AS meta_description_9, t0.meta_keyword AS meta_keyword_10, t0.meta_robots AS meta_robots_11, t0.content AS content_12, t0.thumbnail AS thumbnail_13, t0.is_published AS is_published_14, t0.created_at AS created_at_15, t0.editor_note AS editor_note_16, t0.domain_id AS domain_id_17, t0.place_id AS place_id_18 FROM places_content t0 WHERE t0.domain_id = 2 AND t0.place_id = 64 AND t0.is_published = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.portfolio_id AS portfolio_id_2,
  t0.service_id AS service_id_3
FROM
  portfolio_services t0
WHERE
  t0.service_id = ?

SELECT t0.id AS id_1, t0.portfolio_id AS portfolio_id_2, t0.service_id AS service_id_3 FROM portfolio_services t0 WHERE t0.service_id = 64;

SELECT
  p0_.id AS id_0,
  p0_.heading AS heading_1,
  p0_.client_name AS client_name_2,
  p0_.location AS location_3,
  p0_.content AS content_4,
  p0_.thumbnail AS thumbnail_5,
  p0_.services AS services_6,
  p0_.images AS images_7,
  p0_.is_published AS is_published_8,
  p0_.created_at AS created_at_9,
  p0_.sort AS sort_10,
  p0_.editor_note AS editor_note_11,
  p0_.domain_id AS domain_id_12
FROM
  portfolio p0_
WHERE
  p0_.domain_id = ?
LIMIT
  8

SELECT p0_.id AS id_0, p0_.heading AS heading_1, p0_.client_name AS client_name_2, p0_.location AS location_3, p0_.content AS content_4, p0_.thumbnail AS thumbnail_5, p0_.services AS services_6, p0_.images AS images_7, p0_.is_published AS is_published_8, p0_.created_at AS created_at_9, p0_.sort AS sort_10, p0_.editor_note AS editor_note_11, p0_.domain_id AS domain_id_12 FROM portfolio p0_ WHERE p0_.domain_id = 2 LIMIT 8;

SELECT
  p0_.id AS id_0,
  p0_.place_type AS place_type_1,
  p0_.name AS name_2,
  p0_.url AS url_3,
  p0_.postcodes AS postcodes_4,
  p0_.region_id AS region_id_5,
  p0_.parent_id AS parent_id_6
FROM
  place p0_
WHERE
  p0_.parent_id = ?

SELECT p0_.id AS id_0, p0_.place_type AS place_type_1, p0_.name AS name_2, p0_.url AS url_3, p0_.postcodes AS postcodes_4, p0_.region_id AS region_id_5, p0_.parent_id AS parent_id_6 FROM place p0_ WHERE p0_.parent_id = 64;

SELECT
  t0.id AS id_1,
  t0.page_heading AS page_heading_2,
  t0.page_breadcrumb AS page_breadcrumb_3,
  t0.page_title AS page_title_4,
  t0.social_title AS social_title_5,
  t0.social_description AS social_description_6,
  t0.meta_description AS meta_description_7,
  t0.meta_robots AS meta_robots_8,
  t0.content AS content_9,
  t0.images AS images_10,
  t0.carousel_settings AS carousel_settings_11,
  t0.carousel_background AS carousel_background_12,
  t0.carousel_slides AS carousel_slides_13,
  t0.editor_note AS editor_note_14,
  t0.domain_id AS domain_id_15
FROM
  places_settings t0
WHERE
  t0.domain_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.page_heading AS page_heading_2, t0.page_breadcrumb AS page_breadcrumb_3, t0.page_title AS page_title_4, t0.social_title AS social_title_5, t0.social_description AS social_description_6, t0.meta_description AS meta_description_7, t0.meta_robots AS meta_robots_8, t0.content AS content_9, t0.images AS images_10, t0.carousel_settings AS carousel_settings_11, t0.carousel_background AS carousel_background_12, t0.carousel_slides AS carousel_slides_13, t0.editor_note AS editor_note_14, t0.domain_id AS domain_id_15 FROM places_settings t0 WHERE t0.domain_id = 2 LIMIT 1;

SELECT
  p0_.postcodes AS postcodes_0
FROM
  place p0_
WHERE
  p0_.id = ?

SELECT p0_.postcodes AS postcodes_0 FROM place p0_ WHERE p0_.id = 64;

SELECT
  t0.id AS id_1,
  t0.services AS services_2,
  t0.name AS name_3,
  t0.email AS email_4,
  t0.heading AS heading_5,
  t0.content AS content_6,
  t0.rating AS rating_7,
  t0.source AS source_8,
  t0.location AS location_9,
  t0.job AS job_10,
  t0.photo AS photo_11,
  t0.is_shared AS is_shared_12,
  t0.created_at AS created_at_13,
  t0.auto_publish_on AS auto_publish_on_14,
  t0.published_on AS published_on_15,
  t0.editor_note AS editor_note_16,
  t0.domain_id AS domain_id_17
FROM
  review t0
WHERE
  t0.domain_id = ?
ORDER BY
  t0.id DESC
LIMIT
  3

SELECT t0.id AS id_1, t0.services AS services_2, t0.name AS name_3, t0.email AS email_4, t0.heading AS heading_5, t0.content AS content_6, t0.rating AS rating_7, t0.source AS source_8, t0.location AS location_9, t0.job AS job_10, t0.photo AS photo_11, t0.is_shared AS is_shared_12, t0.created_at AS created_at_13, t0.auto_publish_on AS auto_publish_on_14, t0.published_on AS published_on_15, t0.editor_note AS editor_note_16, t0.domain_id AS domain_id_17 FROM review t0 WHERE t0.domain_id = 2 ORDER BY t0.id DESC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_long AS name_long_3,
  t0.email AS email_4,
  t0.phone AS phone_5
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_long AS name_long_3, t0.email AS email_4, t0.phone AS phone_5 FROM company t0 WHERE t0.id = 156;

SELECT
  t0.id AS id_1,
  t0.page_url AS page_url_2,
  t0.page_heading AS page_heading_3,
  t0.page_breadcrumb AS page_breadcrumb_4,
  t0.page_title AS page_title_5,
  t0.social_title AS social_title_6,
  t0.social_description AS social_description_7,
  t0.meta_description AS meta_description_8,
  t0.meta_keywords AS meta_keywords_9,
  t0.meta_robots AS meta_robots_10,
  t0.name AS name_11,
  t0.content AS content_12,
  t0.in_index AS in_index_13,
  t0.summary AS summary_14,
  t0.thumbnail AS thumbnail_15,
  t0.images AS images_16,
  t0.carousel_settings AS carousel_settings_17,
  t0.carousel_background AS carousel_background_18,
  t0.carousel_slides AS carousel_slides_19,
  t0.is_published AS is_published_20,
  t0.created_at AS created_at_21,
  t0.sort AS sort_22,
  t0.editor_note AS editor_note_23,
  t0.domain_id AS domain_id_24,
  t0.parent_id AS parent_id_25
FROM
  service t0
WHERE
  t0.domain_id = ?

SELECT t0.id AS id_1, t0.page_url AS page_url_2, t0.page_heading AS page_heading_3, t0.page_breadcrumb AS page_breadcrumb_4, t0.page_title AS page_title_5, t0.social_title AS social_title_6, t0.social_description AS social_description_7, t0.meta_description AS meta_description_8, t0.meta_keywords AS meta_keywords_9, t0.meta_robots AS meta_robots_10, t0.name AS name_11, t0.content AS content_12, t0.in_index AS in_index_13, t0.summary AS summary_14, t0.thumbnail AS thumbnail_15, t0.images AS images_16, t0.carousel_settings AS carousel_settings_17, t0.carousel_background AS carousel_background_18, t0.carousel_slides AS carousel_slides_19, t0.is_published AS is_published_20, t0.created_at AS created_at_21, t0.sort AS sort_22, t0.editor_note AS editor_note_23, t0.domain_id AS domain_id_24, t0.parent_id AS parent_id_25 FROM service t0 WHERE t0.domain_id = 2;