| 1 |
1.03 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.name = ? LIMIT 1
Parameters: [0 => armenia]
SELECT t0.id AS id_1, t0.published AS published_2, t0.meta_title AS meta_title_3, t0.meta_description AS meta_description_4, t0.name AS name_5, t0.domains AS domains_6, t0.slug AS slug_7, t0.lat AS lat_8, t0.lng AS lng_9, t0.map_zoom_level AS map_zoom_level_10, t0.address AS address_11, t0.phone_number AS phone_number_12, t0.email AS email_13, t0.lonely_planet_id AS lonely_planet_id_14, t0.landing_image1 AS landing_image1_15, t0.landing_image2 AS landing_image2_16, t0.landing_image3 AS landing_image3_17, t0.landing_image4 AS landing_image4_18, t0.landing_image5 AS landing_image5_19, t0.landing_image6 AS landing_image6_20, t0.landing_image7 AS landing_image7_21, t0.vr_image AS vr_image_22, t0.poly_image AS poly_image_23, t0.vr_icon AS vr_icon_24, t0.vr_map_icon_x AS vr_map_icon_x_25, t0.vr_map_icon_y AS vr_map_icon_y_26, t0.airport_code AS airport_code_27, t0.airport_name AS airport_name_28, t0.position AS position_29, t0.point_id AS point_id_30, t0.weather_id AS weather_id_31, t0.continent_id AS continent_id_32, t0.voice_configuration_id AS voice_configuration_id_33, t0.country_id AS country_id_34 FROM city t0 WHERE t0.name = 'armenia' LIMIT 1;
|
| 2 |
1.59 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, t0.category_id AS category_id_33, t34.name AS name_35, t34.description AS description_36, t34.is_menu AS is_menu_37, t34.is_menu_web AS is_menu_web_38, t34.is_menu_app AS is_menu_app_39, t34.is_menu_vr AS is_menu_vr_40, t34.included_by_default_in_web AS included_by_default_in_web_41, t34.included_by_default_in_app AS included_by_default_in_app_42, t34.included_by_default_in_vr AS included_by_default_in_vr_43, t34.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_44, t34.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_45, t34.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_46, t34.id AS id_47, t34.parent_category_id AS parent_category_id_48, t0.new_category_id AS new_category_id_49, t50.name AS name_51, t50.description AS description_52, t50.is_menu AS is_menu_53, t50.is_menu_web AS is_menu_web_54, t50.is_menu_app AS is_menu_app_55, t50.is_menu_vr AS is_menu_vr_56, t50.included_by_default_in_web AS included_by_default_in_web_57, t50.included_by_default_in_app AS included_by_default_in_app_58, t50.included_by_default_in_vr AS included_by_default_in_vr_59, t50.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_60, t50.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_61, t50.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_62, t50.id AS id_63, t50.parent_category_id AS parent_category_id_64, t0.category2_id AS category2_id_65, t66.name AS name_67, t66.description AS description_68, t66.is_menu AS is_menu_69, t66.is_menu_web AS is_menu_web_70, t66.is_menu_app AS is_menu_app_71, t66.is_menu_vr AS is_menu_vr_72, t66.included_by_default_in_web AS included_by_default_in_web_73, t66.included_by_default_in_app AS included_by_default_in_app_74, t66.included_by_default_in_vr AS included_by_default_in_vr_75, t66.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_76, t66.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_77, t66.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_78, t66.id AS id_79, t66.parent_category_id AS parent_category_id_80, t0.category3_id AS category3_id_81, t82.name AS name_83, t82.description AS description_84, t82.is_menu AS is_menu_85, t82.is_menu_web AS is_menu_web_86, t82.is_menu_app AS is_menu_app_87, t82.is_menu_vr AS is_menu_vr_88, t82.included_by_default_in_web AS included_by_default_in_web_89, t82.included_by_default_in_app AS included_by_default_in_app_90, t82.included_by_default_in_vr AS included_by_default_in_vr_91, t82.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_92, t82.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_93, t82.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_94, t82.id AS id_95, t82.parent_category_id AS parent_category_id_96, t97.id AS id_98, t97.first_fly_through_video AS first_fly_through_video_99, t97.second_fly_through_video AS second_fly_through_video_100, t97.first_walk_through_video AS first_walk_through_video_101, t97.second_walk_through_video AS second_walk_through_video_102, t97.walk_through_thumbnail AS walk_through_thumbnail_103, t97.fly_through_thumbnail AS fly_through_thumbnail_104, t97.walk_through_view_angle AS walk_through_view_angle_105, t97.fly_through_view_angle AS fly_through_view_angle_106, t97.city_id AS city_id_107, t97.place_id AS place_id_108, t0.second_point_id AS second_point_id_109, t0.third_point_id AS third_point_id_110, t0.point_id AS point_id_111, t0.story_id AS story_id_112, t0.inner_point_id AS inner_point_id_113 FROM place t0 LEFT JOIN category t34 ON t0.category_id = t34.id LEFT JOIN category t50 ON t0.new_category_id = t50.id LEFT JOIN category t66 ON t0.category2_id = t66.id LEFT JOIN category t82 ON t0.category3_id = t82.id LEFT JOIN action_video t97 ON t97.place_id = t0.id WHERE t0.slug = ? AND t0.published = ? AND t0.city_id = ? LIMIT 1
Parameters: [0 => new-year-2017, 1 => 1, 2 => 1]
SELECT
t0.id AS id_1,
t0.title AS title_2,
t0.thumbnail_image AS thumbnail_image_3,
t0.slug AS slug_4,
t0.meta_title AS meta_title_5,
t0.meta_description AS meta_description_6,
t0.description AS description_7,
t0.video_url AS video_url_8,
t0.ath AS ath_9,
t0.atv AS atv_10,
t0.second_ath AS second_ath_11,
t0.second_atv AS second_atv_12,
t0.third_ath AS third_ath_13,
t0.third_atv AS third_atv_14,
t0.view_count AS view_count_15,
t0.thumbnail_type AS thumbnail_type_16,
t0.css_thumbnail_center AS css_thumbnail_center_17,
t0.published AS published_18,
t0.created_at AS created_at_19,
t0.updated_at AS updated_at_20,
t0.name AS name_21,
t0.phone_numbers AS phone_numbers_22,
t0.address AS address_23,
t0.website AS website_24,
t0.lonely_planet_id AS lonely_planet_id_25,
t0.overlay_image AS overlay_image_26,
t0.overlay_h AS overlay_h_27,
t0.overlay_v AS overlay_v_28,
t0.overlay_width AS overlay_width_29,
t0.overlay_height AS overlay_height_30,
t0.overlay_active AS overlay_active_31,
t0.city_id AS city_id_32,
t0.category_id AS category_id_33,
t34.name AS name_35,
t34.description AS description_36,
t34.is_menu AS is_menu_37,
t34.is_menu_web AS is_menu_web_38,
t34.is_menu_app AS is_menu_app_39,
t34.is_menu_vr AS is_menu_vr_40,
t34.included_by_default_in_web AS included_by_default_in_web_41,
t34.included_by_default_in_app AS included_by_default_in_app_42,
t34.included_by_default_in_vr AS included_by_default_in_vr_43,
t34.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_44,
t34.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_45,
t34.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_46,
t34.id AS id_47,
t34.parent_category_id AS parent_category_id_48,
t0.new_category_id AS new_category_id_49,
t50.name AS name_51,
t50.description AS description_52,
t50.is_menu AS is_menu_53,
t50.is_menu_web AS is_menu_web_54,
t50.is_menu_app AS is_menu_app_55,
t50.is_menu_vr AS is_menu_vr_56,
t50.included_by_default_in_web AS included_by_default_in_web_57,
t50.included_by_default_in_app AS included_by_default_in_app_58,
t50.included_by_default_in_vr AS included_by_default_in_vr_59,
t50.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_60,
t50.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_61,
t50.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_62,
t50.id AS id_63,
t50.parent_category_id AS parent_category_id_64,
t0.category2_id AS category2_id_65,
t66.name AS name_67,
t66.description AS description_68,
t66.is_menu AS is_menu_69,
t66.is_menu_web AS is_menu_web_70,
t66.is_menu_app AS is_menu_app_71,
t66.is_menu_vr AS is_menu_vr_72,
t66.included_by_default_in_web AS included_by_default_in_web_73,
t66.included_by_default_in_app AS included_by_default_in_app_74,
t66.included_by_default_in_vr AS included_by_default_in_vr_75,
t66.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_76,
t66.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_77,
t66.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_78,
t66.id AS id_79,
t66.parent_category_id AS parent_category_id_80,
t0.category3_id AS category3_id_81,
t82.name AS name_83,
t82.description AS description_84,
t82.is_menu AS is_menu_85,
t82.is_menu_web AS is_menu_web_86,
t82.is_menu_app AS is_menu_app_87,
t82.is_menu_vr AS is_menu_vr_88,
t82.included_by_default_in_web AS included_by_default_in_web_89,
t82.included_by_default_in_app AS included_by_default_in_app_90,
t82.included_by_default_in_vr AS included_by_default_in_vr_91,
t82.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_92,
t82.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_93,
t82.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_94,
t82.id AS id_95,
t82.parent_category_id AS parent_category_id_96,
t97.id AS id_98,
t97.first_fly_through_video AS first_fly_through_video_99,
t97.second_fly_through_video AS second_fly_through_video_100,
t97.first_walk_through_video AS first_walk_through_video_101,
t97.second_walk_through_video AS second_walk_through_video_102,
t97.walk_through_thumbnail AS walk_through_thumbnail_103,
t97.fly_through_thumbnail AS fly_through_thumbnail_104,
t97.walk_through_view_angle AS walk_through_view_angle_105,
t97.fly_through_view_angle AS fly_through_view_angle_106,
t97.city_id AS city_id_107,
t97.place_id AS place_id_108,
t0.second_point_id AS second_point_id_109,
t0.third_point_id AS third_point_id_110,
t0.point_id AS point_id_111,
t0.story_id AS story_id_112,
t0.inner_point_id AS inner_point_id_113
FROM
place t0
LEFT JOIN category t34 ON t0.category_id = t34.id
LEFT JOIN category t50 ON t0.new_category_id = t50.id
LEFT JOIN category t66 ON t0.category2_id = t66.id
LEFT JOIN category t82 ON t0.category3_id = t82.id
LEFT JOIN action_video t97 ON t97.place_id = t0.id
WHERE
t0.slug = ?
AND t0.published = ?
AND t0.city_id = ?
LIMIT
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.thumbnail_image AS thumbnail_image_3, t0.slug AS slug_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.description AS description_7, t0.video_url AS video_url_8, t0.ath AS ath_9, t0.atv AS atv_10, t0.second_ath AS second_ath_11, t0.second_atv AS second_atv_12, t0.third_ath AS third_ath_13, t0.third_atv AS third_atv_14, t0.view_count AS view_count_15, t0.thumbnail_type AS thumbnail_type_16, t0.css_thumbnail_center AS css_thumbnail_center_17, t0.published AS published_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.name AS name_21, t0.phone_numbers AS phone_numbers_22, t0.address AS address_23, t0.website AS website_24, t0.lonely_planet_id AS lonely_planet_id_25, t0.overlay_image AS overlay_image_26, t0.overlay_h AS overlay_h_27, t0.overlay_v AS overlay_v_28, t0.overlay_width AS overlay_width_29, t0.overlay_height AS overlay_height_30, t0.overlay_active AS overlay_active_31, t0.city_id AS city_id_32, t0.category_id AS category_id_33, t34.name AS name_35, t34.description AS description_36, t34.is_menu AS is_menu_37, t34.is_menu_web AS is_menu_web_38, t34.is_menu_app AS is_menu_app_39, t34.is_menu_vr AS is_menu_vr_40, t34.included_by_default_in_web AS included_by_default_in_web_41, t34.included_by_default_in_app AS included_by_default_in_app_42, t34.included_by_default_in_vr AS included_by_default_in_vr_43, t34.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_44, t34.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_45, t34.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_46, t34.id AS id_47, t34.parent_category_id AS parent_category_id_48, t0.new_category_id AS new_category_id_49, t50.name AS name_51, t50.description AS description_52, t50.is_menu AS is_menu_53, t50.is_menu_web AS is_menu_web_54, t50.is_menu_app AS is_menu_app_55, t50.is_menu_vr AS is_menu_vr_56, t50.included_by_default_in_web AS included_by_default_in_web_57, t50.included_by_default_in_app AS included_by_default_in_app_58, t50.included_by_default_in_vr AS included_by_default_in_vr_59, t50.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_60, t50.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_61, t50.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_62, t50.id AS id_63, t50.parent_category_id AS parent_category_id_64, t0.category2_id AS category2_id_65, t66.name AS name_67, t66.description AS description_68, t66.is_menu AS is_menu_69, t66.is_menu_web AS is_menu_web_70, t66.is_menu_app AS is_menu_app_71, t66.is_menu_vr AS is_menu_vr_72, t66.included_by_default_in_web AS included_by_default_in_web_73, t66.included_by_default_in_app AS included_by_default_in_app_74, t66.included_by_default_in_vr AS included_by_default_in_vr_75, t66.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_76, t66.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_77, t66.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_78, t66.id AS id_79, t66.parent_category_id AS parent_category_id_80, t0.category3_id AS category3_id_81, t82.name AS name_83, t82.description AS description_84, t82.is_menu AS is_menu_85, t82.is_menu_web AS is_menu_web_86, t82.is_menu_app AS is_menu_app_87, t82.is_menu_vr AS is_menu_vr_88, t82.included_by_default_in_web AS included_by_default_in_web_89, t82.included_by_default_in_app AS included_by_default_in_app_90, t82.included_by_default_in_vr AS included_by_default_in_vr_91, t82.included_by_default_in_parent_in_vr AS included_by_default_in_parent_in_vr_92, t82.included_by_default_in_parent_in_web AS included_by_default_in_parent_in_web_93, t82.included_by_default_in_parent_in_apps AS included_by_default_in_parent_in_apps_94, t82.id AS id_95, t82.parent_category_id AS parent_category_id_96, t97.id AS id_98, t97.first_fly_through_video AS first_fly_through_video_99, t97.second_fly_through_video AS second_fly_through_video_100, t97.first_walk_through_video AS first_walk_through_video_101, t97.second_walk_through_video AS second_walk_through_video_102, t97.walk_through_thumbnail AS walk_through_thumbnail_103, t97.fly_through_thumbnail AS fly_through_thumbnail_104, t97.walk_through_view_angle AS walk_through_view_angle_105, t97.fly_through_view_angle AS fly_through_view_angle_106, t97.city_id AS city_id_107, t97.place_id AS place_id_108, t0.second_point_id AS second_point_id_109, t0.third_point_id AS third_point_id_110, t0.point_id AS point_id_111, t0.story_id AS story_id_112, t0.inner_point_id AS inner_point_id_113 FROM place t0 LEFT JOIN category t34 ON t0.category_id = t34.id LEFT JOIN category t50 ON t0.new_category_id = t50.id LEFT JOIN category t66 ON t0.category2_id = t66.id LEFT JOIN category t82 ON t0.category3_id = t82.id LEFT JOIN action_video t97 ON t97.place_id = t0.id WHERE t0.slug = 'new-year-2017' AND t0.published = 1 AND t0.city_id = 1 LIMIT 1;
|
