1 |
1.14 ms |
SELECT t0.id AS id_1, t0.thumbnail_image AS thumbnail_image_2, t0.type AS type_3, t0.data AS data_4, t0.game_data AS game_data_5, t0.active AS active_6, t0.test_card_allowed AS test_card_allowed_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.is_single_place AS is_single_place_10, t0.title AS title_11, t0.provider_url AS provider_url_12, t0.slug AS slug_13, t0.duration AS duration_14, t0.thumbnail_type AS thumbnail_type_15, t0.css_thumbnail_center AS css_thumbnail_center_16, t0.short_description AS short_description_17, t0.description AS description_18, t0.meta_title AS meta_title_19, t0.created_by AS created_by_20, t0.show_in_libraries_page AS show_in_libraries_page_21, t0.meta_description AS meta_description_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.image AS image_25, t0.booking_page_image AS booking_page_image_26, t0.price_amd AS price_amd_27, t0.price_usd AS price_usd_28, t0.price_euro AS price_euro_29, t0.price_ruble AS price_ruble_30, t0.rating AS rating_31, t0.total_reviews AS total_reviews_32, t0.lonely_planet_id AS lonely_planet_id_33, t0.gyg_id AS gyg_id_34, t0.tiqets_id AS tiqets_id_35, t0.headout_id AS headout_id_36, t0.path AS path_37, t0.provider_id AS provider_id_38, t0.tour_id AS tour_id_39, t0.created_by_user_id AS created_by_user_id_40, t0.video_id AS video_id_41, t0.new_category_id AS new_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.city_id AS city_id_58, t0.selected_city_id AS selected_city_id_59 FROM experience t0 LEFT JOIN category t43 ON t0.new_category_id = t43.id WHERE t0.id = ? LIMIT 1
Parameters: [0 => 1076]
SELECT
t0.id AS id_1,
t0.thumbnail_image AS thumbnail_image_2,
t0.type AS type_3,
t0.data AS data_4,
t0.game_data AS game_data_5,
t0.active AS active_6,
t0.test_card_allowed AS test_card_allowed_7,
t0.latitude AS latitude_8,
t0.longitude AS longitude_9,
t0.is_single_place AS is_single_place_10,
t0.title AS title_11,
t0.provider_url AS provider_url_12,
t0.slug AS slug_13,
t0.duration AS duration_14,
t0.thumbnail_type AS thumbnail_type_15,
t0.css_thumbnail_center AS css_thumbnail_center_16,
t0.short_description AS short_description_17,
t0.description AS description_18,
t0.meta_title AS meta_title_19,
t0.created_by AS created_by_20,
t0.show_in_libraries_page AS show_in_libraries_page_21,
t0.meta_description AS meta_description_22,
t0.created_at AS created_at_23,
t0.updated_at AS updated_at_24,
t0.image AS image_25,
t0.booking_page_image AS booking_page_image_26,
t0.price_amd AS price_amd_27,
t0.price_usd AS price_usd_28,
t0.price_euro AS price_euro_29,
t0.price_ruble AS price_ruble_30,
t0.rating AS rating_31,
t0.total_reviews AS total_reviews_32,
t0.lonely_planet_id AS lonely_planet_id_33,
t0.gyg_id AS gyg_id_34,
t0.tiqets_id AS tiqets_id_35,
t0.headout_id AS headout_id_36,
t0.path AS path_37,
t0.provider_id AS provider_id_38,
t0.tour_id AS tour_id_39,
t0.created_by_user_id AS created_by_user_id_40,
t0.video_id AS video_id_41,
t0.new_category_id AS new_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.city_id AS city_id_58,
t0.selected_city_id AS selected_city_id_59
FROM
experience t0
LEFT JOIN category t43 ON t0.new_category_id = t43.id
WHERE
t0.id = ?
LIMIT
1
SELECT t0.id AS id_1, t0.thumbnail_image AS thumbnail_image_2, t0.type AS type_3, t0.data AS data_4, t0.game_data AS game_data_5, t0.active AS active_6, t0.test_card_allowed AS test_card_allowed_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.is_single_place AS is_single_place_10, t0.title AS title_11, t0.provider_url AS provider_url_12, t0.slug AS slug_13, t0.duration AS duration_14, t0.thumbnail_type AS thumbnail_type_15, t0.css_thumbnail_center AS css_thumbnail_center_16, t0.short_description AS short_description_17, t0.description AS description_18, t0.meta_title AS meta_title_19, t0.created_by AS created_by_20, t0.show_in_libraries_page AS show_in_libraries_page_21, t0.meta_description AS meta_description_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.image AS image_25, t0.booking_page_image AS booking_page_image_26, t0.price_amd AS price_amd_27, t0.price_usd AS price_usd_28, t0.price_euro AS price_euro_29, t0.price_ruble AS price_ruble_30, t0.rating AS rating_31, t0.total_reviews AS total_reviews_32, t0.lonely_planet_id AS lonely_planet_id_33, t0.gyg_id AS gyg_id_34, t0.tiqets_id AS tiqets_id_35, t0.headout_id AS headout_id_36, t0.path AS path_37, t0.provider_id AS provider_id_38, t0.tour_id AS tour_id_39, t0.created_by_user_id AS created_by_user_id_40, t0.video_id AS video_id_41, t0.new_category_id AS new_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.city_id AS city_id_58, t0.selected_city_id AS selected_city_id_59 FROM experience t0 LEFT JOIN category t43 ON t0.new_category_id = t43.id WHERE t0.id = '1076' LIMIT 1;
|
2 |
1.32 ms |
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.id = ?
Parameters: [0 => 3579]
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.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.id = '3579';
|
3 |
1.42 ms |
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.id = ?
Parameters: [0 => 3568]
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.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.id = '3568';
|
4 |
1.23 ms |
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.id = ?
Parameters: [0 => 3570]
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.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.id = '3570';
|
5 |
1.27 ms |
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.id = ?
Parameters: [0 => 3575]
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.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.id = '3575';
|
6 |
1.11 ms |
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.id = ?
Parameters: [0 => 3589]
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.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.id = '3589';
|
7 |
0.87 ms |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.starts_at AS starts_at_3, t0.started_at AS started_at_4, t0.ended_at AS ended_at_5, t0.duration AS duration_6, t0.data AS data_7, t0.timezone AS timezone_8, t0.title AS title_9, t0.room AS room_10, t0.type AS type_11, t0.redirect_url AS redirect_url_12, t0.game_data AS game_data_13, t0.show_in_libraries_page AS show_in_libraries_page_14, t0.user_id AS user_id_15, t0.experience_id AS experience_id_16, t17.id AS id_18, t17.created_at AS created_at_19, t17.name AS name_20, t17.email AS email_21, t17.group_id AS group_id_22, t17.participant_id AS participant_id_23, t17.exited_at AS exited_at_24, t17.live_tour_id AS live_tour_id_25, t26.id AS id_27, t26.rating AS rating_28, t26.comment AS comment_29, t26.created_at AS created_at_30, t26.updated_at AS updated_at_31, t26.enabled AS enabled_32, t26.participant_id AS participant_id_33, t26.live_tour_id AS live_tour_id_34 FROM live_tour t0 LEFT JOIN live_tour_participant t17 ON t17.live_tour_id = t0.id LEFT JOIN review t26 ON t26.live_tour_id = t0.id WHERE t0.experience_id = ?
Parameters: [0 => 1076]
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.starts_at AS starts_at_3, t0.started_at AS started_at_4, t0.ended_at AS ended_at_5, t0.duration AS duration_6, t0.data AS data_7, t0.timezone AS timezone_8, t0.title AS title_9, t0.room AS room_10, t0.type AS type_11, t0.redirect_url AS redirect_url_12, t0.game_data AS game_data_13, t0.show_in_libraries_page AS show_in_libraries_page_14, t0.user_id AS user_id_15, t0.experience_id AS experience_id_16, t17.id AS id_18, t17.created_at AS created_at_19, t17.name AS name_20, t17.email AS email_21, t17.group_id AS group_id_22, t17.participant_id AS participant_id_23, t17.exited_at AS exited_at_24, t17.live_tour_id AS live_tour_id_25, t26.id AS id_27, t26.rating AS rating_28, t26.comment AS comment_29, t26.created_at AS created_at_30, t26.updated_at AS updated_at_31, t26.enabled AS enabled_32, t26.participant_id AS participant_id_33, t26.live_tour_id AS live_tour_id_34 FROM live_tour t0 LEFT JOIN live_tour_participant t17 ON t17.live_tour_id = t0.id LEFT JOIN review t26 ON t26.live_tour_id = t0.id WHERE t0.experience_id = 1076;
|
8 |
0.82 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.country AS country_8, t0.kids AS kids_9, t0.adults AS adults_10, t0.price_kids AS price_kids_11, t0.price_adults AS price_adults_12, t0.data AS data_13, t0.experience_id AS experience_id_14, t0.live_tour_id AS live_tour_id_15, t0.user_id AS user_id_16 FROM booking t0 WHERE t0.live_tour_id = ?
Parameters: [0 => 3610]
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.country AS country_8, t0.kids AS kids_9, t0.adults AS adults_10, t0.price_kids AS price_kids_11, t0.price_adults AS price_adults_12, t0.data AS data_13, t0.experience_id AS experience_id_14, t0.live_tour_id AS live_tour_id_15, t0.user_id AS user_id_16 FROM booking t0 WHERE t0.live_tour_id = 3610;
|
9 |
0.65 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.country AS country_8, t0.kids AS kids_9, t0.adults AS adults_10, t0.price_kids AS price_kids_11, t0.price_adults AS price_adults_12, t0.data AS data_13, t0.experience_id AS experience_id_14, t0.live_tour_id AS live_tour_id_15, t0.user_id AS user_id_16 FROM booking t0 WHERE t0.live_tour_id = ?
Parameters: [0 => 3663]
SELECT t0.id AS id_1, t0.email AS email_2, t0.phone AS phone_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.country AS country_8, t0.kids AS kids_9, t0.adults AS adults_10, t0.price_kids AS price_kids_11, t0.price_adults AS price_adults_12, t0.data AS data_13, t0.experience_id AS experience_id_14, t0.live_tour_id AS live_tour_id_15, t0.user_id AS user_id_16 FROM booking t0 WHERE t0.live_tour_id = 3663;
|
10 |
0.80 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => site_title]
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = 'site_title' LIMIT 1;
|
11 |
0.65 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => google_tag_manager_head]
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;
|
12 |
0.64 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => google_tag_manager_head]
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;
|
13 |
0.63 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => google_tag_manager_body]
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;
|
14 |
0.68 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => google_tag_manager_body]
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;
|
15 |
0.61 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => Become a host]
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = 'Become a host' LIMIT 1;
|
16 |
0.68 ms |
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = ? LIMIT 1
Parameters: [0 => copyright_text]
SELECT t0.`key` AS key_1, t0.value AS value_2, t0.id AS id_3 FROM dictionary t0 WHERE t0.`key` = 'copyright_text' LIMIT 1;
|
17 |
1.63 ms |
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
Parameters: [0 => 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 ORDER BY t0.position ASC;
|
18 |
1.32 ms |
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
Parameters: [0 => 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 ORDER BY t0.position ASC;
|
19 |
1.17 ms |
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
Parameters: [0 => 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 ORDER BY t0.position ASC;
|
20 |
1.08 ms |
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
Parameters: [0 => 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 ORDER BY t0.position ASC;
|
21 |
1.01 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.content AS content_5, t0.url AS url_6, t0.tags AS tags_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.published AS published_10, t0.featured AS featured_11, t0.published_at AS published_at_12, t0.image AS image_13, t0.views AS views_14, t0.author_id AS author_id_15 FROM post t0 WHERE t0.published = ? ORDER BY t0.created_at DESC LIMIT 3 OFFSET 0
Parameters: [0 => 1]
SELECT t0.id AS id_1, t0.title AS title_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.content AS content_5, t0.url AS url_6, t0.tags AS tags_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.published AS published_10, t0.featured AS featured_11, t0.published_at AS published_at_12, t0.image AS image_13, t0.views AS views_14, t0.author_id AS author_id_15 FROM post t0 WHERE t0.published = 1 ORDER BY t0.created_at DESC LIMIT 3 OFFSET 0;
|
22 |
1.26 ms |
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
Parameters: [0 => 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 ORDER BY t0.slug ASC;
|