Symfony Profiler

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.locked AS locked_32, 
  t0.city_id AS city_id_33, 
  t34.id AS id_35, 
  t34.text AS text_36, 
  t34.created_at AS created_at_37, 
  t34.audio_path AS audio_path_38, 
  t34.story_id AS story_id_39, 
  t34.place_id AS place_id_40, 
  t34.user_id AS user_id_41, 
  t0.category_id AS category_id_42, 
  t43.name AS name_44, 
  t43.description AS description_45, 
  t43.is_menu AS is_menu_46, 
  t43.is_menu_web AS is_menu_web_47, 
  t43.is_menu_app AS is_menu_app_48, 
  t43.is_menu_vr AS is_menu_vr_49, 
  t43.included_by_default_in_web AS included_by_default_in_web_50, 
  t43.included_by_default_in_app AS included_by_default_in_app_51, 
  t43.included_by_default_in_vr AS included_by_default_in_vr_52, 
  t43.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_53, 
  t43.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_54, 
  t43.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_55, 
  t43.id AS id_56, 
  t43.parent_category_id AS parent_category_id_57, 
  t0.new_category_id AS new_category_id_58, 
  t59.name AS name_60, 
  t59.description AS description_61, 
  t59.is_menu AS is_menu_62, 
  t59.is_menu_web AS is_menu_web_63, 
  t59.is_menu_app AS is_menu_app_64, 
  t59.is_menu_vr AS is_menu_vr_65, 
  t59.included_by_default_in_web AS included_by_default_in_web_66, 
  t59.included_by_default_in_app AS included_by_default_in_app_67, 
  t59.included_by_default_in_vr AS included_by_default_in_vr_68, 
  t59.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_69, 
  t59.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_70, 
  t59.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_71, 
  t59.id AS id_72, 
  t59.parent_category_id AS parent_category_id_73, 
  t0.category2_id AS category2_id_74, 
  t75.name AS name_76, 
  t75.description AS description_77, 
  t75.is_menu AS is_menu_78, 
  t75.is_menu_web AS is_menu_web_79, 
  t75.is_menu_app AS is_menu_app_80, 
  t75.is_menu_vr AS is_menu_vr_81, 
  t75.included_by_default_in_web AS included_by_default_in_web_82, 
  t75.included_by_default_in_app AS included_by_default_in_app_83, 
  t75.included_by_default_in_vr AS included_by_default_in_vr_84, 
  t75.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_85, 
  t75.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_86, 
  t75.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_87, 
  t75.id AS id_88, 
  t75.parent_category_id AS parent_category_id_89, 
  t0.category3_id AS category3_id_90, 
  t91.name AS name_92, 
  t91.description AS description_93, 
  t91.is_menu AS is_menu_94, 
  t91.is_menu_web AS is_menu_web_95, 
  t91.is_menu_app AS is_menu_app_96, 
  t91.is_menu_vr AS is_menu_vr_97, 
  t91.included_by_default_in_web AS included_by_default_in_web_98, 
  t91.included_by_default_in_app AS included_by_default_in_app_99, 
  t91.included_by_default_in_vr AS included_by_default_in_vr_100, 
  t91.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_101, 
  t91.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_102, 
  t91.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_103, 
  t91.id AS id_104, 
  t91.parent_category_id AS parent_category_id_105, 
  t106.id AS id_107, 
  t106.first_fly_through_video AS first_fly_through_video_108, 
  t106.second_fly_through_video AS second_fly_through_video_109, 
  t106.first_walk_through_video AS first_walk_through_video_110, 
  t106.second_walk_through_video AS second_walk_through_video_111, 
  t106.walk_through_thumbnail AS walk_through_thumbnail_112, 
  t106.fly_through_thumbnail AS fly_through_thumbnail_113, 
  t106.walk_through_view_angle AS walk_through_view_angle_114, 
  t106.fly_through_view_angle AS fly_through_view_angle_115, 
  t106.city_id AS city_id_116, 
  t106.place_id AS place_id_117, 
  t0.second_point_id AS second_point_id_118, 
  t0.third_point_id AS third_point_id_119, 
  t0.point_id AS point_id_120, 
  t0.story_id AS story_id_121, 
  t0.inner_point_id AS inner_point_id_122 
FROM 
  place t0 
  LEFT JOIN comment t34 ON t34.place_id = t0.id 
  LEFT JOIN category t43 ON t0.category_id = t43.id 
  LEFT JOIN category t59 ON t0.new_category_id = t59.id 
  LEFT JOIN category t75 ON t0.category2_id = t75.id 
  LEFT JOIN category t91 ON t0.category3_id = t91.id 
  LEFT JOIN action_video t106 ON t106.place_id = t0.id 
WHERE 
  t0.story_id = ?

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.locked AS locked_32, t0.city_id AS city_id_33, t34.id AS id_35, t34.text AS text_36, t34.created_at AS created_at_37, t34.audio_path AS audio_path_38, t34.story_id AS story_id_39, t34.place_id AS place_id_40, t34.user_id AS user_id_41, t0.category_id AS category_id_42, t43.name AS name_44, t43.description AS description_45, t43.is_menu AS is_menu_46, t43.is_menu_web AS is_menu_web_47, t43.is_menu_app AS is_menu_app_48, t43.is_menu_vr AS is_menu_vr_49, t43.included_by_default_in_web AS included_by_default_in_web_50, t43.included_by_default_in_app AS included_by_default_in_app_51, t43.included_by_default_in_vr AS included_by_default_in_vr_52, t43.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_53, t43.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_54, t43.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_55, t43.id AS id_56, t43.parent_category_id AS parent_category_id_57, t0.new_category_id AS new_category_id_58, t59.name AS name_60, t59.description AS description_61, t59.is_menu AS is_menu_62, t59.is_menu_web AS is_menu_web_63, t59.is_menu_app AS is_menu_app_64, t59.is_menu_vr AS is_menu_vr_65, t59.included_by_default_in_web AS included_by_default_in_web_66, t59.included_by_default_in_app AS included_by_default_in_app_67, t59.included_by_default_in_vr AS included_by_default_in_vr_68, t59.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_69, t59.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_70, t59.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_71, t59.id AS id_72, t59.parent_category_id AS parent_category_id_73, t0.category2_id AS category2_id_74, t75.name AS name_76, t75.description AS description_77, t75.is_menu AS is_menu_78, t75.is_menu_web AS is_menu_web_79, t75.is_menu_app AS is_menu_app_80, t75.is_menu_vr AS is_menu_vr_81, t75.included_by_default_in_web AS included_by_default_in_web_82, t75.included_by_default_in_app AS included_by_default_in_app_83, t75.included_by_default_in_vr AS included_by_default_in_vr_84, t75.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_85, t75.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_86, t75.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_87, t75.id AS id_88, t75.parent_category_id AS parent_category_id_89, t0.category3_id AS category3_id_90, t91.name AS name_92, t91.description AS description_93, t91.is_menu AS is_menu_94, t91.is_menu_web AS is_menu_web_95, t91.is_menu_app AS is_menu_app_96, t91.is_menu_vr AS is_menu_vr_97, t91.included_by_default_in_web AS included_by_default_in_web_98, t91.included_by_default_in_app AS included_by_default_in_app_99, t91.included_by_default_in_vr AS included_by_default_in_vr_100, t91.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_101, t91.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_102, t91.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_103, t91.id AS id_104, t91.parent_category_id AS parent_category_id_105, t106.id AS id_107, t106.first_fly_through_video AS first_fly_through_video_108, t106.second_fly_through_video AS second_fly_through_video_109, t106.first_walk_through_video AS first_walk_through_video_110, t106.second_walk_through_video AS second_walk_through_video_111, t106.walk_through_thumbnail AS walk_through_thumbnail_112, t106.fly_through_thumbnail AS fly_through_thumbnail_113, t106.walk_through_view_angle AS walk_through_view_angle_114, t106.fly_through_view_angle AS fly_through_view_angle_115, t106.city_id AS city_id_116, t106.place_id AS place_id_117, t0.second_point_id AS second_point_id_118, t0.third_point_id AS third_point_id_119, t0.point_id AS point_id_120, t0.story_id AS story_id_121, t0.inner_point_id AS inner_point_id_122 FROM place t0 LEFT JOIN comment t34 ON t34.place_id = t0.id LEFT JOIN category t43 ON t0.category_id = t43.id LEFT JOIN category t59 ON t0.new_category_id = t59.id LEFT JOIN category t75 ON t0.category2_id = t75.id LEFT JOIN category t91 ON t0.category3_id = t91.id LEFT JOIN action_video t106 ON t106.place_id = t0.id WHERE t0.story_id = 7408;

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 = 6787;

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.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.position 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.position ASC;

SELECT 
  s0_.id AS id_0, 
  s0_.title AS title_1, 
  s0_.slug AS slug_2, 
  s0_.story_type AS story_type_3, 
  s0_.description AS description_4, 
  s0_.meta_title AS meta_title_5, 
  s0_.meta_description AS meta_description_6, 
  s0_.video_url AS video_url_7, 
  s0_.video_path AS video_path_8, 
  s0_.ath AS ath_9, 
  s0_.atv AS atv_10, 
  s0_.view_count AS view_count_11, 
  s0_.is_autogenerated AS is_autogenerated_12, 
  s0_.private AS private_13, 
  s0_.created_from_place AS created_from_place_14, 
  s0_.created_at AS created_at_15, 
  s0_.updated_at AS updated_at_16, 
  s0_.latitude AS latitude_17, 
  s0_.longitude AS longitude_18, 
  s0_.user_id AS user_id_19, 
  s0_.city_id AS city_id_20, 
  s0_.point_id AS point_id_21 
FROM 
  story s0_ 
  LEFT JOIN city c1_ ON s0_.city_id = c1_.id 
WHERE 
  c1_.id = ? 
ORDER BY 
  s0_.id DESC 
LIMIT 
  1000 OFFSET 0

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.story_type AS story_type_3, s0_.description AS description_4, s0_.meta_title AS meta_title_5, s0_.meta_description AS meta_description_6, s0_.video_url AS video_url_7, s0_.video_path AS video_path_8, s0_.ath AS ath_9, s0_.atv AS atv_10, s0_.view_count AS view_count_11, s0_.is_autogenerated AS is_autogenerated_12, s0_.private AS private_13, s0_.created_from_place AS created_from_place_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16, s0_.latitude AS latitude_17, s0_.longitude AS longitude_18, s0_.user_id AS user_id_19, s0_.city_id AS city_id_20, s0_.point_id AS point_id_21 FROM story s0_ LEFT JOIN city c1_ ON s0_.city_id = c1_.id WHERE c1_.id = 6 ORDER BY s0_.id DESC LIMIT 1000 OFFSET 0;

SELECT 
  p0_.id AS id_0, 
  p0_.title AS title_1, 
  p0_.thumbnail_image AS thumbnail_image_2, 
  p0_.slug AS slug_3, 
  p0_.meta_title AS meta_title_4, 
  p0_.meta_description AS meta_description_5, 
  p0_.description AS description_6, 
  p0_.video_url AS video_url_7, 
  p0_.ath AS ath_8, 
  p0_.atv AS atv_9, 
  p0_.second_ath AS second_ath_10, 
  p0_.second_atv AS second_atv_11, 
  p0_.third_ath AS third_ath_12, 
  p0_.third_atv AS third_atv_13, 
  p0_.view_count AS view_count_14, 
  p0_.thumbnail_type AS thumbnail_type_15, 
  p0_.css_thumbnail_center AS css_thumbnail_center_16, 
  p0_.published AS published_17, 
  p0_.created_at AS created_at_18, 
  p0_.updated_at AS updated_at_19, 
  p0_.name AS name_20, 
  p0_.phone_numbers AS phone_numbers_21, 
  p0_.address AS address_22, 
  p0_.website AS website_23, 
  p0_.lonely_planet_id AS lonely_planet_id_24, 
  p0_.overlay_image AS overlay_image_25, 
  p0_.overlay_h AS overlay_h_26, 
  p0_.overlay_v AS overlay_v_27, 
  p0_.overlay_width AS overlay_width_28, 
  p0_.overlay_height AS overlay_height_29, 
  p0_.overlay_active AS overlay_active_30, 
  p0_.locked AS locked_31, 
  COUNT(u1_.id) AS sclr_32, 
  p0_.city_id AS city_id_33, 
  p0_.category_id AS category_id_34, 
  p0_.new_category_id AS new_category_id_35, 
  p0_.category2_id AS category2_id_36, 
  p0_.category3_id AS category3_id_37, 
  p0_.second_point_id AS second_point_id_38, 
  p0_.third_point_id AS third_point_id_39, 
  p0_.point_id AS point_id_40, 
  p0_.story_id AS story_id_41, 
  p0_.inner_point_id AS inner_point_id_42 
FROM 
  place p0_ 
  LEFT JOIN user_favorite_places u1_ ON p0_.id = u1_.story_id 
  INNER JOIN city c2_ ON p0_.city_id = c2_.id 
WHERE 
  c2_.id = ? 
  AND p0_.published = 1 
GROUP BY 
  p0_.id 
ORDER BY 
  sclr_32 DESC, 
  p0_.id DESC 
LIMIT 
  18446744073709551615 OFFSET 0

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.thumbnail_image AS thumbnail_image_2, p0_.slug AS slug_3, p0_.meta_title AS meta_title_4, p0_.meta_description AS meta_description_5, p0_.description AS description_6, p0_.video_url AS video_url_7, p0_.ath AS ath_8, p0_.atv AS atv_9, p0_.second_ath AS second_ath_10, p0_.second_atv AS second_atv_11, p0_.third_ath AS third_ath_12, p0_.third_atv AS third_atv_13, p0_.view_count AS view_count_14, p0_.thumbnail_type AS thumbnail_type_15, p0_.css_thumbnail_center AS css_thumbnail_center_16, p0_.published AS published_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.name AS name_20, p0_.phone_numbers AS phone_numbers_21, p0_.address AS address_22, p0_.website AS website_23, p0_.lonely_planet_id AS lonely_planet_id_24, p0_.overlay_image AS overlay_image_25, p0_.overlay_h AS overlay_h_26, p0_.overlay_v AS overlay_v_27, p0_.overlay_width AS overlay_width_28, p0_.overlay_height AS overlay_height_29, p0_.overlay_active AS overlay_active_30, p0_.locked AS locked_31, COUNT(u1_.id) AS sclr_32, p0_.city_id AS city_id_33, p0_.category_id AS category_id_34, p0_.new_category_id AS new_category_id_35, p0_.category2_id AS category2_id_36, p0_.category3_id AS category3_id_37, p0_.second_point_id AS second_point_id_38, p0_.third_point_id AS third_point_id_39, p0_.point_id AS point_id_40, p0_.story_id AS story_id_41, p0_.inner_point_id AS inner_point_id_42 FROM place p0_ LEFT JOIN user_favorite_places u1_ ON p0_.id = u1_.story_id INNER JOIN city c2_ ON p0_.city_id = c2_.id WHERE c2_.id = 6 AND p0_.published = 1 GROUP BY p0_.id ORDER BY sclr_32 DESC, p0_.id DESC LIMIT 18446744073709551615 OFFSET 0;

SELECT 
  t0.name AS name_1, 
  t0.description AS description_2, 
  t0.is_menu AS is_menu_3, 
  t0.is_menu_web AS is_menu_web_4, 
  t0.is_menu_app AS is_menu_app_5, 
  t0.is_menu_vr AS is_menu_vr_6, 
  t0.included_by_default_in_web AS included_by_default_in_web_7, 
  t0.included_by_default_in_app AS included_by_default_in_app_8, 
  t0.included_by_default_in_vr AS included_by_default_in_vr_9, 
  t0.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_10, 
  t0.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_11, 
  t0.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_12, 
  t0.id AS id_13, 
  t0.parent_category_id AS parent_category_id_14 
FROM 
  category t0 
WHERE 
  t0.id = ?

SELECT t0.name AS name_1, t0.description AS description_2, t0.is_menu AS is_menu_3, t0.is_menu_web AS is_menu_web_4, t0.is_menu_app AS is_menu_app_5, t0.is_menu_vr AS is_menu_vr_6, t0.included_by_default_in_web AS included_by_default_in_web_7, t0.included_by_default_in_app AS included_by_default_in_app_8, t0.included_by_default_in_vr AS included_by_default_in_vr_9, t0.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_10, t0.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_11, t0.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_12, t0.id AS id_13, t0.parent_category_id AS parent_category_id_14 FROM category t0 WHERE t0.id = 77;

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 = 4232;

SELECT 
  t0.name AS name_1, 
  t0.description AS description_2, 
  t0.is_menu AS is_menu_3, 
  t0.is_menu_web AS is_menu_web_4, 
  t0.is_menu_app AS is_menu_app_5, 
  t0.is_menu_vr AS is_menu_vr_6, 
  t0.included_by_default_in_web AS included_by_default_in_web_7, 
  t0.included_by_default_in_app AS included_by_default_in_app_8, 
  t0.included_by_default_in_vr AS included_by_default_in_vr_9, 
  t0.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_10, 
  t0.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_11, 
  t0.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_12, 
  t0.id AS id_13, 
  t0.parent_category_id AS parent_category_id_14 
FROM 
  category t0 
WHERE 
  t0.id IN (?)

SELECT t0.name AS name_1, t0.description AS description_2, t0.is_menu AS is_menu_3, t0.is_menu_web AS is_menu_web_4, t0.is_menu_app AS is_menu_app_5, t0.is_menu_vr AS is_menu_vr_6, t0.included_by_default_in_web AS included_by_default_in_web_7, t0.included_by_default_in_app AS included_by_default_in_app_8, t0.included_by_default_in_vr AS included_by_default_in_vr_9, t0.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_10, t0.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_11, t0.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_12, t0.id AS id_13, t0.parent_category_id AS parent_category_id_14 FROM category t0 WHERE t0.id IN (79, 122);

SELECT 
  t0.id AS id_1, 
  t0.first_fly_through_video AS first_fly_through_video_2, 
  t0.second_fly_through_video AS second_fly_through_video_3, 
  t0.first_walk_through_video AS first_walk_through_video_4, 
  t0.second_walk_through_video AS second_walk_through_video_5, 
  t0.walk_through_thumbnail AS walk_through_thumbnail_6, 
  t0.fly_through_thumbnail AS fly_through_thumbnail_7, 
  t0.walk_through_view_angle AS walk_through_view_angle_8, 
  t0.fly_through_view_angle AS fly_through_view_angle_9, 
  t0.city_id AS city_id_10, 
  t0.place_id AS place_id_11 
FROM 
  action_video t0 
WHERE 
  t0.place_id = ?

SELECT t0.id AS id_1, t0.first_fly_through_video AS first_fly_through_video_2, t0.second_fly_through_video AS second_fly_through_video_3, t0.first_walk_through_video AS first_walk_through_video_4, t0.second_walk_through_video AS second_walk_through_video_5, t0.walk_through_thumbnail AS walk_through_thumbnail_6, t0.fly_through_thumbnail AS fly_through_thumbnail_7, t0.walk_through_view_angle AS walk_through_view_angle_8, t0.fly_through_view_angle AS fly_through_view_angle_9, t0.city_id AS city_id_10, t0.place_id AS place_id_11 FROM action_video t0 WHERE t0.place_id = 4232;

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;

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 = ? 
  AND 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.published = 1 AND t0.name = 'turkey' LIMIT 1;