Symfony Profiler

SELECT 
  t0.id AS id_1, 
  t0.published AS published_2, 
  t0.meta_title AS meta_title_3, 
  t0.meta_description AS meta_description_4, 
  t0.name AS name_5, 
  t0.domains AS domains_6, 
  t0.slug AS slug_7, 
  t0.lat AS lat_8, 
  t0.lng AS lng_9, 
  t0.map_zoom_level AS map_zoom_level_10, 
  t0.address AS address_11, 
  t0.phone_number AS phone_number_12, 
  t0.email AS email_13, 
  t0.lonely_planet_id AS lonely_planet_id_14, 
  t0.landing_image1 AS landing_image1_15, 
  t0.landing_image2 AS landing_image2_16, 
  t0.landing_image3 AS landing_image3_17, 
  t0.landing_image4 AS landing_image4_18, 
  t0.landing_image5 AS landing_image5_19, 
  t0.landing_image6 AS landing_image6_20, 
  t0.landing_image7 AS landing_image7_21, 
  t0.vr_image AS vr_image_22, 
  t0.poly_image AS poly_image_23, 
  t0.vr_icon AS vr_icon_24, 
  t0.vr_map_icon_x AS vr_map_icon_x_25, 
  t0.vr_map_icon_y AS vr_map_icon_y_26, 
  t0.airport_code AS airport_code_27, 
  t0.airport_name AS airport_name_28, 
  t0.position AS position_29, 
  t0.point_id AS point_id_30, 
  t0.weather_id AS weather_id_31, 
  t0.continent_id AS continent_id_32, 
  t0.voice_configuration_id AS voice_configuration_id_33, 
  t0.country_id AS country_id_34 
FROM 
  city t0 
WHERE 
  t0.name = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.published AS published_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.name AS name_5, t0.domains AS domains_6, t0.slug AS slug_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.map_zoom_level AS map_zoom_level_10, t0.address AS address_11, t0.phone_number AS phone_number_12, t0.email AS email_13, t0.lonely_planet_id AS lonely_planet_id_14, t0.landing_image1 AS landing_image1_15, t0.landing_image2 AS landing_image2_16, t0.landing_image3 AS landing_image3_17, t0.landing_image4 AS landing_image4_18, t0.landing_image5 AS landing_image5_19, t0.landing_image6 AS landing_image6_20, t0.landing_image7 AS landing_image7_21, t0.vr_image AS vr_image_22, t0.poly_image AS poly_image_23, t0.vr_icon AS vr_icon_24, t0.vr_map_icon_x AS vr_map_icon_x_25, t0.vr_map_icon_y AS vr_map_icon_y_26, t0.airport_code AS airport_code_27, t0.airport_name AS airport_name_28, t0.position AS position_29, t0.point_id AS point_id_30, t0.weather_id AS weather_id_31, t0.continent_id AS continent_id_32, t0.voice_configuration_id AS voice_configuration_id_33, t0.country_id AS country_id_34 FROM city t0 WHERE t0.name = 'berlin' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.title AS title_2, 
  t0.thumbnail_image AS thumbnail_image_3, 
  t0.slug AS slug_4, 
  t0.meta_title AS meta_title_5, 
  t0.meta_description AS meta_description_6, 
  t0.description AS description_7, 
  t0.video_url AS video_url_8, 
  t0.ath AS ath_9, 
  t0.atv AS atv_10, 
  t0.second_ath AS second_ath_11, 
  t0.second_atv AS second_atv_12, 
  t0.third_ath AS third_ath_13, 
  t0.third_atv AS third_atv_14, 
  t0.view_count AS view_count_15, 
  t0.thumbnail_type AS thumbnail_type_16, 
  t0.css_thumbnail_center AS css_thumbnail_center_17, 
  t0.published AS published_18, 
  t0.created_at AS created_at_19, 
  t0.updated_at AS updated_at_20, 
  t0.name AS name_21, 
  t0.phone_numbers AS phone_numbers_22, 
  t0.address AS address_23, 
  t0.website AS website_24, 
  t0.lonely_planet_id AS lonely_planet_id_25, 
  t0.overlay_image AS overlay_image_26, 
  t0.overlay_h AS overlay_h_27, 
  t0.overlay_v AS overlay_v_28, 
  t0.overlay_width AS overlay_width_29, 
  t0.overlay_height AS overlay_height_30, 
  t0.overlay_active AS overlay_active_31, 
  t0.city_id AS city_id_32, 
  t0.category_id AS category_id_33, 
  t34.name AS name_35, 
  t34.description AS description_36, 
  t34.is_menu AS is_menu_37, 
  t34.is_menu_web AS is_menu_web_38, 
  t34.is_menu_app AS is_menu_app_39, 
  t34.is_menu_vr AS is_menu_vr_40, 
  t34.included_by_default_in_web AS included_by_default_in_web_41, 
  t34.included_by_default_in_app AS included_by_default_in_app_42, 
  t34.included_by_default_in_vr AS included_by_default_in_vr_43, 
  t34.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_44, 
  t34.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_45, 
  t34.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_46, 
  t34.id AS id_47, 
  t34.parent_category_id AS parent_category_id_48, 
  t0.new_category_id AS new_category_id_49, 
  t50.name AS name_51, 
  t50.description AS description_52, 
  t50.is_menu AS is_menu_53, 
  t50.is_menu_web AS is_menu_web_54, 
  t50.is_menu_app AS is_menu_app_55, 
  t50.is_menu_vr AS is_menu_vr_56, 
  t50.included_by_default_in_web AS included_by_default_in_web_57, 
  t50.included_by_default_in_app AS included_by_default_in_app_58, 
  t50.included_by_default_in_vr AS included_by_default_in_vr_59, 
  t50.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_60, 
  t50.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_61, 
  t50.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_62, 
  t50.id AS id_63, 
  t50.parent_category_id AS parent_category_id_64, 
  t0.category2_id AS category2_id_65, 
  t66.name AS name_67, 
  t66.description AS description_68, 
  t66.is_menu AS is_menu_69, 
  t66.is_menu_web AS is_menu_web_70, 
  t66.is_menu_app AS is_menu_app_71, 
  t66.is_menu_vr AS is_menu_vr_72, 
  t66.included_by_default_in_web AS included_by_default_in_web_73, 
  t66.included_by_default_in_app AS included_by_default_in_app_74, 
  t66.included_by_default_in_vr AS included_by_default_in_vr_75, 
  t66.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_76, 
  t66.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_77, 
  t66.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_78, 
  t66.id AS id_79, 
  t66.parent_category_id AS parent_category_id_80, 
  t0.category3_id AS category3_id_81, 
  t82.name AS name_83, 
  t82.description AS description_84, 
  t82.is_menu AS is_menu_85, 
  t82.is_menu_web AS is_menu_web_86, 
  t82.is_menu_app AS is_menu_app_87, 
  t82.is_menu_vr AS is_menu_vr_88, 
  t82.included_by_default_in_web AS included_by_default_in_web_89, 
  t82.included_by_default_in_app AS included_by_default_in_app_90, 
  t82.included_by_default_in_vr AS included_by_default_in_vr_91, 
  t82.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_92, 
  t82.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_93, 
  t82.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_94, 
  t82.id AS id_95, 
  t82.parent_category_id AS parent_category_id_96, 
  t97.id AS id_98, 
  t97.first_fly_through_video AS first_fly_through_video_99, 
  t97.second_fly_through_video AS second_fly_through_video_100, 
  t97.first_walk_through_video AS first_walk_through_video_101, 
  t97.second_walk_through_video AS second_walk_through_video_102, 
  t97.walk_through_thumbnail AS walk_through_thumbnail_103, 
  t97.fly_through_thumbnail AS fly_through_thumbnail_104, 
  t97.walk_through_view_angle AS walk_through_view_angle_105, 
  t97.fly_through_view_angle AS fly_through_view_angle_106, 
  t97.city_id AS city_id_107, 
  t97.place_id AS place_id_108, 
  t0.second_point_id AS second_point_id_109, 
  t0.third_point_id AS third_point_id_110, 
  t0.point_id AS point_id_111, 
  t0.story_id AS story_id_112, 
  t0.inner_point_id AS inner_point_id_113 
FROM 
  place t0 
  LEFT JOIN category t34 ON t0.category_id = t34.id 
  LEFT JOIN category t50 ON t0.new_category_id = t50.id 
  LEFT JOIN category t66 ON t0.category2_id = t66.id 
  LEFT JOIN category t82 ON t0.category3_id = t82.id 
  LEFT JOIN action_video t97 ON t97.place_id = t0.id 
WHERE 
  t0.slug = ? 
  AND t0.published = ? 
  AND t0.city_id = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.thumbnail_image AS thumbnail_image_3, t0.slug AS slug_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.description AS description_7, t0.video_url AS video_url_8, t0.ath AS ath_9, t0.atv AS atv_10, t0.second_ath AS second_ath_11, t0.second_atv AS second_atv_12, t0.third_ath AS third_ath_13, t0.third_atv AS third_atv_14, t0.view_count AS view_count_15, t0.thumbnail_type AS thumbnail_type_16, t0.css_thumbnail_center AS css_thumbnail_center_17, t0.published AS published_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.name AS name_21, t0.phone_numbers AS phone_numbers_22, t0.address AS address_23, t0.website AS website_24, t0.lonely_planet_id AS lonely_planet_id_25, t0.overlay_image AS overlay_image_26, t0.overlay_h AS overlay_h_27, t0.overlay_v AS overlay_v_28, t0.overlay_width AS overlay_width_29, t0.overlay_height AS overlay_height_30, t0.overlay_active AS overlay_active_31, t0.city_id AS city_id_32, t0.category_id AS category_id_33, t34.name AS name_35, t34.description AS description_36, t34.is_menu AS is_menu_37, t34.is_menu_web AS is_menu_web_38, t34.is_menu_app AS is_menu_app_39, t34.is_menu_vr AS is_menu_vr_40, t34.included_by_default_in_web AS included_by_default_in_web_41, t34.included_by_default_in_app AS included_by_default_in_app_42, t34.included_by_default_in_vr AS included_by_default_in_vr_43, t34.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_44, t34.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_45, t34.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_46, t34.id AS id_47, t34.parent_category_id AS parent_category_id_48, t0.new_category_id AS new_category_id_49, t50.name AS name_51, t50.description AS description_52, t50.is_menu AS is_menu_53, t50.is_menu_web AS is_menu_web_54, t50.is_menu_app AS is_menu_app_55, t50.is_menu_vr AS is_menu_vr_56, t50.included_by_default_in_web AS included_by_default_in_web_57, t50.included_by_default_in_app AS included_by_default_in_app_58, t50.included_by_default_in_vr AS included_by_default_in_vr_59, t50.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_60, t50.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_61, t50.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_62, t50.id AS id_63, t50.parent_category_id AS parent_category_id_64, t0.category2_id AS category2_id_65, t66.name AS name_67, t66.description AS description_68, t66.is_menu AS is_menu_69, t66.is_menu_web AS is_menu_web_70, t66.is_menu_app AS is_menu_app_71, t66.is_menu_vr AS is_menu_vr_72, t66.included_by_default_in_web AS included_by_default_in_web_73, t66.included_by_default_in_app AS included_by_default_in_app_74, t66.included_by_default_in_vr AS included_by_default_in_vr_75, t66.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_76, t66.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_77, t66.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_78, t66.id AS id_79, t66.parent_category_id AS parent_category_id_80, t0.category3_id AS category3_id_81, t82.name AS name_83, t82.description AS description_84, t82.is_menu AS is_menu_85, t82.is_menu_web AS is_menu_web_86, t82.is_menu_app AS is_menu_app_87, t82.is_menu_vr AS is_menu_vr_88, t82.included_by_default_in_web AS included_by_default_in_web_89, t82.included_by_default_in_app AS included_by_default_in_app_90, t82.included_by_default_in_vr AS included_by_default_in_vr_91, t82.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_92, t82.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_93, t82.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_94, t82.id AS id_95, t82.parent_category_id AS parent_category_id_96, t97.id AS id_98, t97.first_fly_through_video AS first_fly_through_video_99, t97.second_fly_through_video AS second_fly_through_video_100, t97.first_walk_through_video AS first_walk_through_video_101, t97.second_walk_through_video AS second_walk_through_video_102, t97.walk_through_thumbnail AS walk_through_thumbnail_103, t97.fly_through_thumbnail AS fly_through_thumbnail_104, t97.walk_through_view_angle AS walk_through_view_angle_105, t97.fly_through_view_angle AS fly_through_view_angle_106, t97.city_id AS city_id_107, t97.place_id AS place_id_108, t0.second_point_id AS second_point_id_109, t0.third_point_id AS third_point_id_110, t0.point_id AS point_id_111, t0.story_id AS story_id_112, t0.inner_point_id AS inner_point_id_113 FROM place t0 LEFT JOIN category t34 ON t0.category_id = t34.id LEFT JOIN category t50 ON t0.new_category_id = t50.id LEFT JOIN category t66 ON t0.category2_id = t66.id LEFT JOIN category t82 ON t0.category3_id = t82.id LEFT JOIN action_video t97 ON t97.place_id = t0.id WHERE t0.slug = 'tempelhofer-feld' AND t0.published = 1 AND t0.city_id = 11 LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.text AS text_2, 
  t0.created_at AS created_at_3, 
  t0.audio_path AS audio_path_4, 
  t0.story_id AS story_id_5, 
  t0.place_id AS place_id_6, 
  t0.user_id AS user_id_7 
FROM 
  comment t0 
WHERE 
  t0.place_id = ?

SELECT t0.id AS id_1, t0.text AS text_2, t0.created_at AS created_at_3, t0.audio_path AS audio_path_4, t0.story_id AS story_id_5, t0.place_id AS place_id_6, t0.user_id AS user_id_7 FROM comment t0 WHERE t0.place_id = 3443;

SELECT 
  t0.id AS id_1, 
  t0.point_number AS point_number_2, 
  t0.point_name AS point_name_3, 
  t0.slug AS slug_4, 
  t0.sound_name AS sound_name_5, 
  t0.sharing_image_name AS sharing_image_name_6, 
  t0.video_name AS video_name_7, 
  t0.video_name_2 AS video_name_2_8, 
  t0.video_name_3 AS video_name_3_9, 
  t0.latitude AS latitude_10, 
  t0.longitude AS longitude_11, 
  t0.is_published AS is_published_12, 
  t0.is_visible_in_tour AS is_visible_in_tour_13, 
  t0.display_name AS display_name_14, 
  t0.hlookat AS hlookat_15, 
  t0.vlookat AS vlookat_16, 
  t0.created_at AS created_at_17, 
  t0.requires_conversion AS requires_conversion_18, 
  t0.city_id AS city_id_19, 
  t0.place_id AS place_id_20, 
  t21.id AS id_22, 
  t21.image AS image_23, 
  t21.h AS h_24, 
  t21.v AS v_25, 
  t21.width AS width_26, 
  t21.height AS height_27, 
  t21.created_at AS created_at_28, 
  t21.updated_at AS updated_at_29, 
  t21.point_id AS point_id_30, 
  t31.id AS id_32, 
  t31.h AS h_33, 
  t31.v AS v_34, 
  t31.width AS width_35, 
  t31.height AS height_36, 
  t31.rotationX AS rotationX_37, 
  t31.rotationY AS rotationY_38, 
  t31.rotationZ AS rotationZ_39, 
  t31.shadow AS shadow_40, 
  t31.point_id AS point_id_41, 
  t31.experience_id AS experience_id_42 
FROM 
  point t0 
  LEFT JOIN overlay_image t21 ON t21.point_id = t0.id 
  LEFT JOIN portal t31 ON t31.point_id = t0.id 
WHERE 
  t0.id = ?

SELECT t0.id AS id_1, t0.point_number AS point_number_2, t0.point_name AS point_name_3, t0.slug AS slug_4, t0.sound_name AS sound_name_5, t0.sharing_image_name AS sharing_image_name_6, t0.video_name AS video_name_7, t0.video_name_2 AS video_name_2_8, t0.video_name_3 AS video_name_3_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.is_published AS is_published_12, t0.is_visible_in_tour AS is_visible_in_tour_13, t0.display_name AS display_name_14, t0.hlookat AS hlookat_15, t0.vlookat AS vlookat_16, t0.created_at AS created_at_17, t0.requires_conversion AS requires_conversion_18, t0.city_id AS city_id_19, t0.place_id AS place_id_20, t21.id AS id_22, t21.image AS image_23, t21.h AS h_24, t21.v AS v_25, t21.width AS width_26, t21.height AS height_27, t21.created_at AS created_at_28, t21.updated_at AS updated_at_29, t21.point_id AS point_id_30, t31.id AS id_32, t31.h AS h_33, t31.v AS v_34, t31.width AS width_35, t31.height AS height_36, t31.rotationX AS rotationX_37, t31.rotationY AS rotationY_38, t31.rotationZ AS rotationZ_39, t31.shadow AS shadow_40, t31.point_id AS point_id_41, t31.experience_id AS experience_id_42 FROM point t0 LEFT JOIN overlay_image t21 ON t21.point_id = t0.id LEFT JOIN portal t31 ON t31.point_id = t0.id WHERE t0.id = 9527;

SELECT 
  t0.`key` AS key_1, 
  t0.value AS value_2, 
  t0.id AS id_3 
FROM 
  dictionary t0 
WHERE 
  t0.`key` = ? 
LIMIT 
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = 'site_title_default_suffix' LIMIT 1;

SELECT 
  t0.`key` AS key_1, 
  t0.value AS value_2, 
  t0.id AS id_3 
FROM 
  dictionary t0 
WHERE 
  t0.`key` = ? 
LIMIT 
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = 'google_tag_manager_head' LIMIT 1;

SELECT 
  t0.`key` AS key_1, 
  t0.value AS value_2, 
  t0.id AS id_3 
FROM 
  dictionary t0 
WHERE 
  t0.`key` = ? 
LIMIT 
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = 'google_tag_manager_head' LIMIT 1;

SELECT 
  t0.`key` AS key_1, 
  t0.value AS value_2, 
  t0.id AS id_3 
FROM 
  dictionary t0 
WHERE 
  t0.`key` = ? 
LIMIT 
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = 'google_tag_manager_body' LIMIT 1;

SELECT 
  t0.`key` AS key_1, 
  t0.value AS value_2, 
  t0.id AS id_3 
FROM 
  dictionary t0 
WHERE 
  t0.`key` = ? 
LIMIT 
  1

SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = 'google_tag_manager_body' LIMIT 1;

SELECT 
  t0.id AS id_1, 
  t0.published AS published_2, 
  t0.meta_title AS meta_title_3, 
  t0.meta_description AS meta_description_4, 
  t0.name AS name_5, 
  t0.domains AS domains_6, 
  t0.slug AS slug_7, 
  t0.lat AS lat_8, 
  t0.lng AS lng_9, 
  t0.map_zoom_level AS map_zoom_level_10, 
  t0.address AS address_11, 
  t0.phone_number AS phone_number_12, 
  t0.email AS email_13, 
  t0.lonely_planet_id AS lonely_planet_id_14, 
  t0.landing_image1 AS landing_image1_15, 
  t0.landing_image2 AS landing_image2_16, 
  t0.landing_image3 AS landing_image3_17, 
  t0.landing_image4 AS landing_image4_18, 
  t0.landing_image5 AS landing_image5_19, 
  t0.landing_image6 AS landing_image6_20, 
  t0.landing_image7 AS landing_image7_21, 
  t0.vr_image AS vr_image_22, 
  t0.poly_image AS poly_image_23, 
  t0.vr_icon AS vr_icon_24, 
  t0.vr_map_icon_x AS vr_map_icon_x_25, 
  t0.vr_map_icon_y AS vr_map_icon_y_26, 
  t0.airport_code AS airport_code_27, 
  t0.airport_name AS airport_name_28, 
  t0.position AS position_29, 
  t0.point_id AS point_id_30, 
  t0.weather_id AS weather_id_31, 
  t0.continent_id AS continent_id_32, 
  t0.voice_configuration_id AS voice_configuration_id_33, 
  t0.country_id AS country_id_34 
FROM 
  city t0 
WHERE 
  t0.published = ? 
ORDER BY 
  t0.slug ASC

SELECT t0.id AS id_1, t0.published AS published_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.name AS name_5, t0.domains AS domains_6, t0.slug AS slug_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.map_zoom_level AS map_zoom_level_10, t0.address AS address_11, t0.phone_number AS phone_number_12, t0.email AS email_13, t0.lonely_planet_id AS lonely_planet_id_14, t0.landing_image1 AS landing_image1_15, t0.landing_image2 AS landing_image2_16, t0.landing_image3 AS landing_image3_17, t0.landing_image4 AS landing_image4_18, t0.landing_image5 AS landing_image5_19, t0.landing_image6 AS landing_image6_20, t0.landing_image7 AS landing_image7_21, t0.vr_image AS vr_image_22, t0.poly_image AS poly_image_23, t0.vr_icon AS vr_icon_24, t0.vr_map_icon_x AS vr_map_icon_x_25, t0.vr_map_icon_y AS vr_map_icon_y_26, t0.airport_code AS airport_code_27, t0.airport_name AS airport_name_28, t0.position AS position_29, t0.point_id AS point_id_30, t0.weather_id AS weather_id_31, t0.continent_id AS continent_id_32, t0.voice_configuration_id AS voice_configuration_id_33, t0.country_id AS country_id_34 FROM city t0 WHERE t0.published = 1 ORDER BY t0.slug ASC;