| 1 |
2.21 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.flag AS flag_6, t0.status AS status_7, t0.order_number AS order_number_8, t0.iso_code AS iso_code_9, t0.media_id AS media_id_10 FROM country t0 WHERE t0.id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.flag AS flag_6, t0.status AS status_7, t0.order_number AS order_number_8, t0.iso_code AS iso_code_9, t0.media_id AS media_id_10 FROM country t0 WHERE t0.id = '5';
|
| 2 |
1.43 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.status AS status_6, t0.group_name AS group_name_7 FROM place_category t0
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.status AS status_6, t0.group_name AS group_name_7 FROM place_category t0;
|
| 3 |
0.91 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.icon AS icon_4, t0.status AS status_5 FROM travel_preference t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.icon AS icon_4, t0.status AS status_5 FROM travel_preference t0;
|
| 4 |
2.19 ms |
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.file_name AS file_name_3, t4.created_at AS created_at_5, t4.updated_at AS updated_at_6, t4.deleted_at AS deleted_at_7, t4.id AS id_8, t4.name AS name_9, t4.cid AS cid_10, t4.description AS description_11, t4.complet_address AS complet_address_12, t4.uri_image AS uri_image_13, t4.lat AS lat_14, t4.lng AS lng_15, t4.geohash AS geohash_16, t4.rating AS rating_17, t4.votes_count AS votes_count_18, t4.rating_count1 AS rating_count1_19, t4.rating_count2 AS rating_count2_20, t4.rating_count3 AS rating_count3_21, t4.rating_count4 AS rating_count4_22, t4.rating_count5 AS rating_count5_23, t4.status AS status_24, t4.score AS score_25, t4.recent AS recent_26, t4.opening_time AS opening_time_27, t4.closing_time AS closing_time_28, t4.popularity_time0001 AS popularity_time0001_29, t4.popularity_time0102 AS popularity_time0102_30, t4.popularity_time0203 AS popularity_time0203_31, t4.popularity_time0304 AS popularity_time0304_32, t4.popularity_time0405 AS popularity_time0405_33, t4.popularity_time0506 AS popularity_time0506_34, t4.popularity_time0607 AS popularity_time0607_35, t4.popularity_time0708 AS popularity_time0708_36, t4.popularity_time0809 AS popularity_time0809_37, t4.popularity_time0910 AS popularity_time0910_38, t4.popularity_time1011 AS popularity_time1011_39, t4.popularity_time1112 AS popularity_time1112_40, t4.popularity_time1213 AS popularity_time1213_41, t4.popularity_time1314 AS popularity_time1314_42, t4.popularity_time1415 AS popularity_time1415_43, t4.popularity_time1516 AS popularity_time1516_44, t4.popularity_time1617 AS popularity_time1617_45, t4.popularity_time1718 AS popularity_time1718_46, t4.popularity_time1819 AS popularity_time1819_47, t4.popularity_time1920 AS popularity_time1920_48, t4.popularity_time2021 AS popularity_time2021_49, t4.popularity_time2122 AS popularity_time2122_50, t4.popularity_time2223 AS popularity_time2223_51, t4.popularity_time2300 AS popularity_time2300_52, t4.you_tube_id AS you_tube_id_53, t4.city_id AS city_id_54, t4.media_id AS media_id_55, t4.price_range_id AS price_range_id_56, t0.gallery_place_id AS gallery_place_id_57 FROM media t0 LEFT JOIN place t4 ON t4.media_id = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.caption AS caption_2,
t0.file_name AS file_name_3,
t4.created_at AS created_at_5,
t4.updated_at AS updated_at_6,
t4.deleted_at AS deleted_at_7,
t4.id AS id_8,
t4.name AS name_9,
t4.cid AS cid_10,
t4.description AS description_11,
t4.complet_address AS complet_address_12,
t4.uri_image AS uri_image_13,
t4.lat AS lat_14,
t4.lng AS lng_15,
t4.geohash AS geohash_16,
t4.rating AS rating_17,
t4.votes_count AS votes_count_18,
t4.rating_count1 AS rating_count1_19,
t4.rating_count2 AS rating_count2_20,
t4.rating_count3 AS rating_count3_21,
t4.rating_count4 AS rating_count4_22,
t4.rating_count5 AS rating_count5_23,
t4.status AS status_24,
t4.score AS score_25,
t4.recent AS recent_26,
t4.opening_time AS opening_time_27,
t4.closing_time AS closing_time_28,
t4.popularity_time0001 AS popularity_time0001_29,
t4.popularity_time0102 AS popularity_time0102_30,
t4.popularity_time0203 AS popularity_time0203_31,
t4.popularity_time0304 AS popularity_time0304_32,
t4.popularity_time0405 AS popularity_time0405_33,
t4.popularity_time0506 AS popularity_time0506_34,
t4.popularity_time0607 AS popularity_time0607_35,
t4.popularity_time0708 AS popularity_time0708_36,
t4.popularity_time0809 AS popularity_time0809_37,
t4.popularity_time0910 AS popularity_time0910_38,
t4.popularity_time1011 AS popularity_time1011_39,
t4.popularity_time1112 AS popularity_time1112_40,
t4.popularity_time1213 AS popularity_time1213_41,
t4.popularity_time1314 AS popularity_time1314_42,
t4.popularity_time1415 AS popularity_time1415_43,
t4.popularity_time1516 AS popularity_time1516_44,
t4.popularity_time1617 AS popularity_time1617_45,
t4.popularity_time1718 AS popularity_time1718_46,
t4.popularity_time1819 AS popularity_time1819_47,
t4.popularity_time1920 AS popularity_time1920_48,
t4.popularity_time2021 AS popularity_time2021_49,
t4.popularity_time2122 AS popularity_time2122_50,
t4.popularity_time2223 AS popularity_time2223_51,
t4.popularity_time2300 AS popularity_time2300_52,
t4.you_tube_id AS you_tube_id_53,
t4.city_id AS city_id_54,
t4.media_id AS media_id_55,
t4.price_range_id AS price_range_id_56,
t0.gallery_place_id AS gallery_place_id_57
FROM
media t0
LEFT JOIN place t4 ON t4.media_id = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.file_name AS file_name_3, t4.created_at AS created_at_5, t4.updated_at AS updated_at_6, t4.deleted_at AS deleted_at_7, t4.id AS id_8, t4.name AS name_9, t4.cid AS cid_10, t4.description AS description_11, t4.complet_address AS complet_address_12, t4.uri_image AS uri_image_13, t4.lat AS lat_14, t4.lng AS lng_15, t4.geohash AS geohash_16, t4.rating AS rating_17, t4.votes_count AS votes_count_18, t4.rating_count1 AS rating_count1_19, t4.rating_count2 AS rating_count2_20, t4.rating_count3 AS rating_count3_21, t4.rating_count4 AS rating_count4_22, t4.rating_count5 AS rating_count5_23, t4.status AS status_24, t4.score AS score_25, t4.recent AS recent_26, t4.opening_time AS opening_time_27, t4.closing_time AS closing_time_28, t4.popularity_time0001 AS popularity_time0001_29, t4.popularity_time0102 AS popularity_time0102_30, t4.popularity_time0203 AS popularity_time0203_31, t4.popularity_time0304 AS popularity_time0304_32, t4.popularity_time0405 AS popularity_time0405_33, t4.popularity_time0506 AS popularity_time0506_34, t4.popularity_time0607 AS popularity_time0607_35, t4.popularity_time0708 AS popularity_time0708_36, t4.popularity_time0809 AS popularity_time0809_37, t4.popularity_time0910 AS popularity_time0910_38, t4.popularity_time1011 AS popularity_time1011_39, t4.popularity_time1112 AS popularity_time1112_40, t4.popularity_time1213 AS popularity_time1213_41, t4.popularity_time1314 AS popularity_time1314_42, t4.popularity_time1415 AS popularity_time1415_43, t4.popularity_time1516 AS popularity_time1516_44, t4.popularity_time1617 AS popularity_time1617_45, t4.popularity_time1718 AS popularity_time1718_46, t4.popularity_time1819 AS popularity_time1819_47, t4.popularity_time1920 AS popularity_time1920_48, t4.popularity_time2021 AS popularity_time2021_49, t4.popularity_time2122 AS popularity_time2122_50, t4.popularity_time2223 AS popularity_time2223_51, t4.popularity_time2300 AS popularity_time2300_52, t4.you_tube_id AS you_tube_id_53, t4.city_id AS city_id_54, t4.media_id AS media_id_55, t4.price_range_id AS price_range_id_56, t0.gallery_place_id AS gallery_place_id_57 FROM media t0 LEFT JOIN place t4 ON t4.media_id = t0.id WHERE t0.id = 2704;
|
| 5 |
0.91 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.status AS status_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.country_id AS country_id_9, t0.media_id AS media_id_10 FROM city t0 WHERE t0.country_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.status AS status_6, t0.lat AS lat_7, t0.lng AS lng_8, t0.country_id AS country_id_9, t0.media_id AS media_id_10 FROM city t0 WHERE t0.country_id = 5;
|
| 6 |
0.95 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 47;
|
| 7 |
0.94 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 55;
|
| 8 |
0.88 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 67;
|
| 9 |
0.78 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 80;
|
| 10 |
0.93 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 93;
|
| 11 |
0.87 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 96;
|
| 12 |
0.82 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 108;
|
| 13 |
0.80 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 112;
|
| 14 |
0.79 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 113;
|
| 15 |
0.85 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 128;
|
| 16 |
0.82 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 145;
|
| 17 |
0.83 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 151;
|
| 18 |
1.00 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 153;
|
| 19 |
0.99 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 155;
|
| 20 |
0.95 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 159;
|
| 21 |
0.81 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 164;
|
| 22 |
0.78 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 167;
|
| 23 |
0.87 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 169;
|
| 24 |
0.87 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 170;
|
| 25 |
0.85 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 174;
|
| 26 |
0.72 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 175;
|
| 27 |
0.85 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 180;
|
| 28 |
0.91 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 183;
|
| 29 |
0.75 ms |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = ?
SELECT
t0.created_at AS created_at_1,
t0.updated_at AS updated_at_2,
t0.deleted_at AS deleted_at_3,
t0.id AS id_4,
t0.name AS name_5,
t0.cid AS cid_6,
t0.description AS description_7,
t0.complet_address AS complet_address_8,
t0.uri_image AS uri_image_9,
t0.lat AS lat_10,
t0.lng AS lng_11,
t0.geohash AS geohash_12,
t0.rating AS rating_13,
t0.votes_count AS votes_count_14,
t0.rating_count1 AS rating_count1_15,
t0.rating_count2 AS rating_count2_16,
t0.rating_count3 AS rating_count3_17,
t0.rating_count4 AS rating_count4_18,
t0.rating_count5 AS rating_count5_19,
t0.status AS status_20,
t0.score AS score_21,
t0.recent AS recent_22,
t0.opening_time AS opening_time_23,
t0.closing_time AS closing_time_24,
t0.popularity_time0001 AS popularity_time0001_25,
t0.popularity_time0102 AS popularity_time0102_26,
t0.popularity_time0203 AS popularity_time0203_27,
t0.popularity_time0304 AS popularity_time0304_28,
t0.popularity_time0405 AS popularity_time0405_29,
t0.popularity_time0506 AS popularity_time0506_30,
t0.popularity_time0607 AS popularity_time0607_31,
t0.popularity_time0708 AS popularity_time0708_32,
t0.popularity_time0809 AS popularity_time0809_33,
t0.popularity_time0910 AS popularity_time0910_34,
t0.popularity_time1011 AS popularity_time1011_35,
t0.popularity_time1112 AS popularity_time1112_36,
t0.popularity_time1213 AS popularity_time1213_37,
t0.popularity_time1314 AS popularity_time1314_38,
t0.popularity_time1415 AS popularity_time1415_39,
t0.popularity_time1516 AS popularity_time1516_40,
t0.popularity_time1617 AS popularity_time1617_41,
t0.popularity_time1718 AS popularity_time1718_42,
t0.popularity_time1819 AS popularity_time1819_43,
t0.popularity_time1920 AS popularity_time1920_44,
t0.popularity_time2021 AS popularity_time2021_45,
t0.popularity_time2122 AS popularity_time2122_46,
t0.popularity_time2223 AS popularity_time2223_47,
t0.popularity_time2300 AS popularity_time2300_48,
t0.you_tube_id AS you_tube_id_49,
t0.city_id AS city_id_50,
t0.media_id AS media_id_51,
t0.price_range_id AS price_range_id_52
FROM
place t0
WHERE
t0.city_id = ?
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cid AS cid_6, t0.description AS description_7, t0.complet_address AS complet_address_8, t0.uri_image AS uri_image_9, t0.lat AS lat_10, t0.lng AS lng_11, t0.geohash AS geohash_12, t0.rating AS rating_13, t0.votes_count AS votes_count_14, t0.rating_count1 AS rating_count1_15, t0.rating_count2 AS rating_count2_16, t0.rating_count3 AS rating_count3_17, t0.rating_count4 AS rating_count4_18, t0.rating_count5 AS rating_count5_19, t0.status AS status_20, t0.score AS score_21, t0.recent AS recent_22, t0.opening_time AS opening_time_23, t0.closing_time AS closing_time_24, t0.popularity_time0001 AS popularity_time0001_25, t0.popularity_time0102 AS popularity_time0102_26, t0.popularity_time0203 AS popularity_time0203_27, t0.popularity_time0304 AS popularity_time0304_28, t0.popularity_time0405 AS popularity_time0405_29, t0.popularity_time0506 AS popularity_time0506_30, t0.popularity_time0607 AS popularity_time0607_31, t0.popularity_time0708 AS popularity_time0708_32, t0.popularity_time0809 AS popularity_time0809_33, t0.popularity_time0910 AS popularity_time0910_34, t0.popularity_time1011 AS popularity_time1011_35, t0.popularity_time1112 AS popularity_time1112_36, t0.popularity_time1213 AS popularity_time1213_37, t0.popularity_time1314 AS popularity_time1314_38, t0.popularity_time1415 AS popularity_time1415_39, t0.popularity_time1516 AS popularity_time1516_40, t0.popularity_time1617 AS popularity_time1617_41, t0.popularity_time1718 AS popularity_time1718_42, t0.popularity_time1819 AS popularity_time1819_43, t0.popularity_time1920 AS popularity_time1920_44, t0.popularity_time2021 AS popularity_time2021_45, t0.popularity_time2122 AS popularity_time2122_46, t0.popularity_time2223 AS popularity_time2223_47, t0.popularity_time2300 AS popularity_time2300_48, t0.you_tube_id AS you_tube_id_49, t0.city_id AS city_id_50, t0.media_id AS media_id_51, t0.price_range_id AS price_range_id_52 FROM place t0 WHERE t0.city_id = 209;
|