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.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 = 'qatar' LIMIT 1;

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 = 54 ORDER BY s0_.id DESC LIMIT 1000 OFFSET 0;

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, 
  t33.id AS id_34, 
  t33.text AS text_35, 
  t33.created_at AS created_at_36, 
  t33.audio_path AS audio_path_37, 
  t33.story_id AS story_id_38, 
  t33.place_id AS place_id_39, 
  t33.user_id AS user_id_40, 
  t0.category_id AS category_id_41, 
  t42.name AS name_43, 
  t42.description AS description_44, 
  t42.is_menu AS is_menu_45, 
  t42.is_menu_web AS is_menu_web_46, 
  t42.is_menu_app AS is_menu_app_47, 
  t42.is_menu_vr AS is_menu_vr_48, 
  t42.included_by_default_in_web AS included_by_default_in_web_49, 
  t42.included_by_default_in_app AS included_by_default_in_app_50, 
  t42.included_by_default_in_vr AS included_by_default_in_vr_51, 
  t42.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_52, 
  t42.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_53, 
  t42.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_54, 
  t42.id AS id_55, 
  t42.parent_category_id AS parent_category_id_56, 
  t0.new_category_id AS new_category_id_57, 
  t58.name AS name_59, 
  t58.description AS description_60, 
  t58.is_menu AS is_menu_61, 
  t58.is_menu_web AS is_menu_web_62, 
  t58.is_menu_app AS is_menu_app_63, 
  t58.is_menu_vr AS is_menu_vr_64, 
  t58.included_by_default_in_web AS included_by_default_in_web_65, 
  t58.included_by_default_in_app AS included_by_default_in_app_66, 
  t58.included_by_default_in_vr AS included_by_default_in_vr_67, 
  t58.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_68, 
  t58.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_69, 
  t58.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_70, 
  t58.id AS id_71, 
  t58.parent_category_id AS parent_category_id_72, 
  t0.category2_id AS category2_id_73, 
  t74.name AS name_75, 
  t74.description AS description_76, 
  t74.is_menu AS is_menu_77, 
  t74.is_menu_web AS is_menu_web_78, 
  t74.is_menu_app AS is_menu_app_79, 
  t74.is_menu_vr AS is_menu_vr_80, 
  t74.included_by_default_in_web AS included_by_default_in_web_81, 
  t74.included_by_default_in_app AS included_by_default_in_app_82, 
  t74.included_by_default_in_vr AS included_by_default_in_vr_83, 
  t74.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_84, 
  t74.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_85, 
  t74.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_86, 
  t74.id AS id_87, 
  t74.parent_category_id AS parent_category_id_88, 
  t0.category3_id AS category3_id_89, 
  t90.name AS name_91, 
  t90.description AS description_92, 
  t90.is_menu AS is_menu_93, 
  t90.is_menu_web AS is_menu_web_94, 
  t90.is_menu_app AS is_menu_app_95, 
  t90.is_menu_vr AS is_menu_vr_96, 
  t90.included_by_default_in_web AS included_by_default_in_web_97, 
  t90.included_by_default_in_app AS included_by_default_in_app_98, 
  t90.included_by_default_in_vr AS included_by_default_in_vr_99, 
  t90.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_100, 
  t90.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_101, 
  t90.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_102, 
  t90.id AS id_103, 
  t90.parent_category_id AS parent_category_id_104, 
  t105.id AS id_106, 
  t105.first_fly_through_video AS first_fly_through_video_107, 
  t105.second_fly_through_video AS second_fly_through_video_108, 
  t105.first_walk_through_video AS first_walk_through_video_109, 
  t105.second_walk_through_video AS second_walk_through_video_110, 
  t105.walk_through_thumbnail AS walk_through_thumbnail_111, 
  t105.fly_through_thumbnail AS fly_through_thumbnail_112, 
  t105.walk_through_view_angle AS walk_through_view_angle_113, 
  t105.fly_through_view_angle AS fly_through_view_angle_114, 
  t105.city_id AS city_id_115, 
  t105.place_id AS place_id_116, 
  t0.second_point_id AS second_point_id_117, 
  t0.third_point_id AS third_point_id_118, 
  t0.point_id AS point_id_119, 
  t0.story_id AS story_id_120, 
  t0.inner_point_id AS inner_point_id_121 
FROM 
  place t0 
  LEFT JOIN comment t33 ON t33.place_id = t0.id 
  LEFT JOIN category t42 ON t0.category_id = t42.id 
  LEFT JOIN category t58 ON t0.new_category_id = t58.id 
  LEFT JOIN category t74 ON t0.category2_id = t74.id 
  LEFT JOIN category t90 ON t0.category3_id = t90.id 
  LEFT JOIN action_video t105 ON t105.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.city_id AS city_id_32, t33.id AS id_34, t33.text AS text_35, t33.created_at AS created_at_36, t33.audio_path AS audio_path_37, t33.story_id AS story_id_38, t33.place_id AS place_id_39, t33.user_id AS user_id_40, t0.category_id AS category_id_41, t42.name AS name_43, t42.description AS description_44, t42.is_menu AS is_menu_45, t42.is_menu_web AS is_menu_web_46, t42.is_menu_app AS is_menu_app_47, t42.is_menu_vr AS is_menu_vr_48, t42.included_by_default_in_web AS included_by_default_in_web_49, t42.included_by_default_in_app AS included_by_default_in_app_50, t42.included_by_default_in_vr AS included_by_default_in_vr_51, t42.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_52, t42.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_53, t42.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_54, t42.id AS id_55, t42.parent_category_id AS parent_category_id_56, t0.new_category_id AS new_category_id_57, t58.name AS name_59, t58.description AS description_60, t58.is_menu AS is_menu_61, t58.is_menu_web AS is_menu_web_62, t58.is_menu_app AS is_menu_app_63, t58.is_menu_vr AS is_menu_vr_64, t58.included_by_default_in_web AS included_by_default_in_web_65, t58.included_by_default_in_app AS included_by_default_in_app_66, t58.included_by_default_in_vr AS included_by_default_in_vr_67, t58.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_68, t58.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_69, t58.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_70, t58.id AS id_71, t58.parent_category_id AS parent_category_id_72, t0.category2_id AS category2_id_73, t74.name AS name_75, t74.description AS description_76, t74.is_menu AS is_menu_77, t74.is_menu_web AS is_menu_web_78, t74.is_menu_app AS is_menu_app_79, t74.is_menu_vr AS is_menu_vr_80, t74.included_by_default_in_web AS included_by_default_in_web_81, t74.included_by_default_in_app AS included_by_default_in_app_82, t74.included_by_default_in_vr AS included_by_default_in_vr_83, t74.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_84, t74.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_85, t74.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_86, t74.id AS id_87, t74.parent_category_id AS parent_category_id_88, t0.category3_id AS category3_id_89, t90.name AS name_91, t90.description AS description_92, t90.is_menu AS is_menu_93, t90.is_menu_web AS is_menu_web_94, t90.is_menu_app AS is_menu_app_95, t90.is_menu_vr AS is_menu_vr_96, t90.included_by_default_in_web AS included_by_default_in_web_97, t90.included_by_default_in_app AS included_by_default_in_app_98, t90.included_by_default_in_vr AS included_by_default_in_vr_99, t90.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_100, t90.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_101, t90.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_102, t90.id AS id_103, t90.parent_category_id AS parent_category_id_104, t105.id AS id_106, t105.first_fly_through_video AS first_fly_through_video_107, t105.second_fly_through_video AS second_fly_through_video_108, t105.first_walk_through_video AS first_walk_through_video_109, t105.second_walk_through_video AS second_walk_through_video_110, t105.walk_through_thumbnail AS walk_through_thumbnail_111, t105.fly_through_thumbnail AS fly_through_thumbnail_112, t105.walk_through_view_angle AS walk_through_view_angle_113, t105.fly_through_view_angle AS fly_through_view_angle_114, t105.city_id AS city_id_115, t105.place_id AS place_id_116, t0.second_point_id AS second_point_id_117, t0.third_point_id AS third_point_id_118, t0.point_id AS point_id_119, t0.story_id AS story_id_120, t0.inner_point_id AS inner_point_id_121 FROM place t0 LEFT JOIN comment t33 ON t33.place_id = t0.id LEFT JOIN category t42 ON t0.category_id = t42.id LEFT JOIN category t58 ON t0.new_category_id = t58.id LEFT JOIN category t74 ON t0.category2_id = t74.id LEFT JOIN category t90 ON t0.category3_id = t90.id LEFT JOIN action_video t105 ON t105.place_id = t0.id WHERE t0.story_id = 7719;

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, 
  t33.id AS id_34, 
  t33.text AS text_35, 
  t33.created_at AS created_at_36, 
  t33.audio_path AS audio_path_37, 
  t33.story_id AS story_id_38, 
  t33.place_id AS place_id_39, 
  t33.user_id AS user_id_40, 
  t0.category_id AS category_id_41, 
  t42.name AS name_43, 
  t42.description AS description_44, 
  t42.is_menu AS is_menu_45, 
  t42.is_menu_web AS is_menu_web_46, 
  t42.is_menu_app AS is_menu_app_47, 
  t42.is_menu_vr AS is_menu_vr_48, 
  t42.included_by_default_in_web AS included_by_default_in_web_49, 
  t42.included_by_default_in_app AS included_by_default_in_app_50, 
  t42.included_by_default_in_vr AS included_by_default_in_vr_51, 
  t42.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_52, 
  t42.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_53, 
  t42.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_54, 
  t42.id AS id_55, 
  t42.parent_category_id AS parent_category_id_56, 
  t0.new_category_id AS new_category_id_57, 
  t58.name AS name_59, 
  t58.description AS description_60, 
  t58.is_menu AS is_menu_61, 
  t58.is_menu_web AS is_menu_web_62, 
  t58.is_menu_app AS is_menu_app_63, 
  t58.is_menu_vr AS is_menu_vr_64, 
  t58.included_by_default_in_web AS included_by_default_in_web_65, 
  t58.included_by_default_in_app AS included_by_default_in_app_66, 
  t58.included_by_default_in_vr AS included_by_default_in_vr_67, 
  t58.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_68, 
  t58.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_69, 
  t58.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_70, 
  t58.id AS id_71, 
  t58.parent_category_id AS parent_category_id_72, 
  t0.category2_id AS category2_id_73, 
  t74.name AS name_75, 
  t74.description AS description_76, 
  t74.is_menu AS is_menu_77, 
  t74.is_menu_web AS is_menu_web_78, 
  t74.is_menu_app AS is_menu_app_79, 
  t74.is_menu_vr AS is_menu_vr_80, 
  t74.included_by_default_in_web AS included_by_default_in_web_81, 
  t74.included_by_default_in_app AS included_by_default_in_app_82, 
  t74.included_by_default_in_vr AS included_by_default_in_vr_83, 
  t74.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_84, 
  t74.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_85, 
  t74.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_86, 
  t74.id AS id_87, 
  t74.parent_category_id AS parent_category_id_88, 
  t0.category3_id AS category3_id_89, 
  t90.name AS name_91, 
  t90.description AS description_92, 
  t90.is_menu AS is_menu_93, 
  t90.is_menu_web AS is_menu_web_94, 
  t90.is_menu_app AS is_menu_app_95, 
  t90.is_menu_vr AS is_menu_vr_96, 
  t90.included_by_default_in_web AS included_by_default_in_web_97, 
  t90.included_by_default_in_app AS included_by_default_in_app_98, 
  t90.included_by_default_in_vr AS included_by_default_in_vr_99, 
  t90.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_100, 
  t90.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_101, 
  t90.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_102, 
  t90.id AS id_103, 
  t90.parent_category_id AS parent_category_id_104, 
  t105.id AS id_106, 
  t105.first_fly_through_video AS first_fly_through_video_107, 
  t105.second_fly_through_video AS second_fly_through_video_108, 
  t105.first_walk_through_video AS first_walk_through_video_109, 
  t105.second_walk_through_video AS second_walk_through_video_110, 
  t105.walk_through_thumbnail AS walk_through_thumbnail_111, 
  t105.fly_through_thumbnail AS fly_through_thumbnail_112, 
  t105.walk_through_view_angle AS walk_through_view_angle_113, 
  t105.fly_through_view_angle AS fly_through_view_angle_114, 
  t105.city_id AS city_id_115, 
  t105.place_id AS place_id_116, 
  t0.second_point_id AS second_point_id_117, 
  t0.third_point_id AS third_point_id_118, 
  t0.point_id AS point_id_119, 
  t0.story_id AS story_id_120, 
  t0.inner_point_id AS inner_point_id_121 
FROM 
  place t0 
  LEFT JOIN comment t33 ON t33.place_id = t0.id 
  LEFT JOIN category t42 ON t0.category_id = t42.id 
  LEFT JOIN category t58 ON t0.new_category_id = t58.id 
  LEFT JOIN category t74 ON t0.category2_id = t74.id 
  LEFT JOIN category t90 ON t0.category3_id = t90.id 
  LEFT JOIN action_video t105 ON t105.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.city_id AS city_id_32, t33.id AS id_34, t33.text AS text_35, t33.created_at AS created_at_36, t33.audio_path AS audio_path_37, t33.story_id AS story_id_38, t33.place_id AS place_id_39, t33.user_id AS user_id_40, t0.category_id AS category_id_41, t42.name AS name_43, t42.description AS description_44, t42.is_menu AS is_menu_45, t42.is_menu_web AS is_menu_web_46, t42.is_menu_app AS is_menu_app_47, t42.is_menu_vr AS is_menu_vr_48, t42.included_by_default_in_web AS included_by_default_in_web_49, t42.included_by_default_in_app AS included_by_default_in_app_50, t42.included_by_default_in_vr AS included_by_default_in_vr_51, t42.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_52, t42.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_53, t42.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_54, t42.id AS id_55, t42.parent_category_id AS parent_category_id_56, t0.new_category_id AS new_category_id_57, t58.name AS name_59, t58.description AS description_60, t58.is_menu AS is_menu_61, t58.is_menu_web AS is_menu_web_62, t58.is_menu_app AS is_menu_app_63, t58.is_menu_vr AS is_menu_vr_64, t58.included_by_default_in_web AS included_by_default_in_web_65, t58.included_by_default_in_app AS included_by_default_in_app_66, t58.included_by_default_in_vr AS included_by_default_in_vr_67, t58.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_68, t58.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_69, t58.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_70, t58.id AS id_71, t58.parent_category_id AS parent_category_id_72, t0.category2_id AS category2_id_73, t74.name AS name_75, t74.description AS description_76, t74.is_menu AS is_menu_77, t74.is_menu_web AS is_menu_web_78, t74.is_menu_app AS is_menu_app_79, t74.is_menu_vr AS is_menu_vr_80, t74.included_by_default_in_web AS included_by_default_in_web_81, t74.included_by_default_in_app AS included_by_default_in_app_82, t74.included_by_default_in_vr AS included_by_default_in_vr_83, t74.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_84, t74.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_85, t74.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_86, t74.id AS id_87, t74.parent_category_id AS parent_category_id_88, t0.category3_id AS category3_id_89, t90.name AS name_91, t90.description AS description_92, t90.is_menu AS is_menu_93, t90.is_menu_web AS is_menu_web_94, t90.is_menu_app AS is_menu_app_95, t90.is_menu_vr AS is_menu_vr_96, t90.included_by_default_in_web AS included_by_default_in_web_97, t90.included_by_default_in_app AS included_by_default_in_app_98, t90.included_by_default_in_vr AS included_by_default_in_vr_99, t90.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_100, t90.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_101, t90.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_102, t90.id AS id_103, t90.parent_category_id AS parent_category_id_104, t105.id AS id_106, t105.first_fly_through_video AS first_fly_through_video_107, t105.second_fly_through_video AS second_fly_through_video_108, t105.first_walk_through_video AS first_walk_through_video_109, t105.second_walk_through_video AS second_walk_through_video_110, t105.walk_through_thumbnail AS walk_through_thumbnail_111, t105.fly_through_thumbnail AS fly_through_thumbnail_112, t105.walk_through_view_angle AS walk_through_view_angle_113, t105.fly_through_view_angle AS fly_through_view_angle_114, t105.city_id AS city_id_115, t105.place_id AS place_id_116, t0.second_point_id AS second_point_id_117, t0.third_point_id AS third_point_id_118, t0.point_id AS point_id_119, t0.story_id AS story_id_120, t0.inner_point_id AS inner_point_id_121 FROM place t0 LEFT JOIN comment t33 ON t33.place_id = t0.id LEFT JOIN category t42 ON t0.category_id = t42.id LEFT JOIN category t58 ON t0.new_category_id = t58.id LEFT JOIN category t74 ON t0.category2_id = t74.id LEFT JOIN category t90 ON t0.category3_id = t90.id LEFT JOIN action_video t105 ON t105.place_id = t0.id WHERE t0.story_id = 7718;

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, 
  t33.id AS id_34, 
  t33.text AS text_35, 
  t33.created_at AS created_at_36, 
  t33.audio_path AS audio_path_37, 
  t33.story_id AS story_id_38, 
  t33.place_id AS place_id_39, 
  t33.user_id AS user_id_40, 
  t0.category_id AS category_id_41, 
  t42.name AS name_43, 
  t42.description AS description_44, 
  t42.is_menu AS is_menu_45, 
  t42.is_menu_web AS is_menu_web_46, 
  t42.is_menu_app AS is_menu_app_47, 
  t42.is_menu_vr AS is_menu_vr_48, 
  t42.included_by_default_in_web AS included_by_default_in_web_49, 
  t42.included_by_default_in_app AS included_by_default_in_app_50, 
  t42.included_by_default_in_vr AS included_by_default_in_vr_51, 
  t42.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_52, 
  t42.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_53, 
  t42.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_54, 
  t42.id AS id_55, 
  t42.parent_category_id AS parent_category_id_56, 
  t0.new_category_id AS new_category_id_57, 
  t58.name AS name_59, 
  t58.description AS description_60, 
  t58.is_menu AS is_menu_61, 
  t58.is_menu_web AS is_menu_web_62, 
  t58.is_menu_app AS is_menu_app_63, 
  t58.is_menu_vr AS is_menu_vr_64, 
  t58.included_by_default_in_web AS included_by_default_in_web_65, 
  t58.included_by_default_in_app AS included_by_default_in_app_66, 
  t58.included_by_default_in_vr AS included_by_default_in_vr_67, 
  t58.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_68, 
  t58.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_69, 
  t58.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_70, 
  t58.id AS id_71, 
  t58.parent_category_id AS parent_category_id_72, 
  t0.category2_id AS category2_id_73, 
  t74.name AS name_75, 
  t74.description AS description_76, 
  t74.is_menu AS is_menu_77, 
  t74.is_menu_web AS is_menu_web_78, 
  t74.is_menu_app AS is_menu_app_79, 
  t74.is_menu_vr AS is_menu_vr_80, 
  t74.included_by_default_in_web AS included_by_default_in_web_81, 
  t74.included_by_default_in_app AS included_by_default_in_app_82, 
  t74.included_by_default_in_vr AS included_by_default_in_vr_83, 
  t74.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_84, 
  t74.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_85, 
  t74.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_86, 
  t74.id AS id_87, 
  t74.parent_category_id AS parent_category_id_88, 
  t0.category3_id AS category3_id_89, 
  t90.name AS name_91, 
  t90.description AS description_92, 
  t90.is_menu AS is_menu_93, 
  t90.is_menu_web AS is_menu_web_94, 
  t90.is_menu_app AS is_menu_app_95, 
  t90.is_menu_vr AS is_menu_vr_96, 
  t90.included_by_default_in_web AS included_by_default_in_web_97, 
  t90.included_by_default_in_app AS included_by_default_in_app_98, 
  t90.included_by_default_in_vr AS included_by_default_in_vr_99, 
  t90.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_100, 
  t90.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_101, 
  t90.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_102, 
  t90.id AS id_103, 
  t90.parent_category_id AS parent_category_id_104, 
  t105.id AS id_106, 
  t105.first_fly_through_video AS first_fly_through_video_107, 
  t105.second_fly_through_video AS second_fly_through_video_108, 
  t105.first_walk_through_video AS first_walk_through_video_109, 
  t105.second_walk_through_video AS second_walk_through_video_110, 
  t105.walk_through_thumbnail AS walk_through_thumbnail_111, 
  t105.fly_through_thumbnail AS fly_through_thumbnail_112, 
  t105.walk_through_view_angle AS walk_through_view_angle_113, 
  t105.fly_through_view_angle AS fly_through_view_angle_114, 
  t105.city_id AS city_id_115, 
  t105.place_id AS place_id_116, 
  t0.second_point_id AS second_point_id_117, 
  t0.third_point_id AS third_point_id_118, 
  t0.point_id AS point_id_119, 
  t0.story_id AS story_id_120, 
  t0.inner_point_id AS inner_point_id_121 
FROM 
  place t0 
  LEFT JOIN comment t33 ON t33.place_id = t0.id 
  LEFT JOIN category t42 ON t0.category_id = t42.id 
  LEFT JOIN category t58 ON t0.new_category_id = t58.id 
  LEFT JOIN category t74 ON t0.category2_id = t74.id 
  LEFT JOIN category t90 ON t0.category3_id = t90.id 
  LEFT JOIN action_video t105 ON t105.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.city_id AS city_id_32, t33.id AS id_34, t33.text AS text_35, t33.created_at AS created_at_36, t33.audio_path AS audio_path_37, t33.story_id AS story_id_38, t33.place_id AS place_id_39, t33.user_id AS user_id_40, t0.category_id AS category_id_41, t42.name AS name_43, t42.description AS description_44, t42.is_menu AS is_menu_45, t42.is_menu_web AS is_menu_web_46, t42.is_menu_app AS is_menu_app_47, t42.is_menu_vr AS is_menu_vr_48, t42.included_by_default_in_web AS included_by_default_in_web_49, t42.included_by_default_in_app AS included_by_default_in_app_50, t42.included_by_default_in_vr AS included_by_default_in_vr_51, t42.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_52, t42.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_53, t42.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_54, t42.id AS id_55, t42.parent_category_id AS parent_category_id_56, t0.new_category_id AS new_category_id_57, t58.name AS name_59, t58.description AS description_60, t58.is_menu AS is_menu_61, t58.is_menu_web AS is_menu_web_62, t58.is_menu_app AS is_menu_app_63, t58.is_menu_vr AS is_menu_vr_64, t58.included_by_default_in_web AS included_by_default_in_web_65, t58.included_by_default_in_app AS included_by_default_in_app_66, t58.included_by_default_in_vr AS included_by_default_in_vr_67, t58.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_68, t58.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_69, t58.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_70, t58.id AS id_71, t58.parent_category_id AS parent_category_id_72, t0.category2_id AS category2_id_73, t74.name AS name_75, t74.description AS description_76, t74.is_menu AS is_menu_77, t74.is_menu_web AS is_menu_web_78, t74.is_menu_app AS is_menu_app_79, t74.is_menu_vr AS is_menu_vr_80, t74.included_by_default_in_web AS included_by_default_in_web_81, t74.included_by_default_in_app AS included_by_default_in_app_82, t74.included_by_default_in_vr AS included_by_default_in_vr_83, t74.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_84, t74.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_85, t74.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_86, t74.id AS id_87, t74.parent_category_id AS parent_category_id_88, t0.category3_id AS category3_id_89, t90.name AS name_91, t90.description AS description_92, t90.is_menu AS is_menu_93, t90.is_menu_web AS is_menu_web_94, t90.is_menu_app AS is_menu_app_95, t90.is_menu_vr AS is_menu_vr_96, t90.included_by_default_in_web AS included_by_default_in_web_97, t90.included_by_default_in_app AS included_by_default_in_app_98, t90.included_by_default_in_vr AS included_by_default_in_vr_99, t90.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_100, t90.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_101, t90.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_102, t90.id AS id_103, t90.parent_category_id AS parent_category_id_104, t105.id AS id_106, t105.first_fly_through_video AS first_fly_through_video_107, t105.second_fly_through_video AS second_fly_through_video_108, t105.first_walk_through_video AS first_walk_through_video_109, t105.second_walk_through_video AS second_walk_through_video_110, t105.walk_through_thumbnail AS walk_through_thumbnail_111, t105.fly_through_thumbnail AS fly_through_thumbnail_112, t105.walk_through_view_angle AS walk_through_view_angle_113, t105.fly_through_view_angle AS fly_through_view_angle_114, t105.city_id AS city_id_115, t105.place_id AS place_id_116, t0.second_point_id AS second_point_id_117, t0.third_point_id AS third_point_id_118, t0.point_id AS point_id_119, t0.story_id AS story_id_120, t0.inner_point_id AS inner_point_id_121 FROM place t0 LEFT JOIN comment t33 ON t33.place_id = t0.id LEFT JOIN category t42 ON t0.category_id = t42.id LEFT JOIN category t58 ON t0.new_category_id = t58.id LEFT JOIN category t74 ON t0.category2_id = t74.id LEFT JOIN category t90 ON t0.category3_id = t90.id LEFT JOIN action_video t105 ON t105.place_id = t0.id WHERE t0.story_id = 7717;