Warning (2): Illegal string offset 'language' [APP/app_helper.php, line 11]
This is the test environment server: dev.kinnshare.com
Near where
Wanna Eat/Find
Search results for: "[All restaurants]" Near "BTS-Ekkamai"
[-] Search Filters
Near
  • BTS-Ekkamai
Include nearby stations
Restaurant Cuisines/Types
Cuisines types
more...
Restaurant types
more...
Restaurant features
more...
Price range
more...
 
No results found for your search.
Add new restaurant you know.
Don't find it?
Add new restaurant you know.
Loading map...
 
(default) 17 queries took 97 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `visits`7722
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';113
3SHOW FULL COLUMNS FROM `unique_visitors`5517
4SHOW FULL COLUMNS FROM `rests_comments_likes`5510
5SHOW FULL COLUMNS FROM `rests_pics_likes`5514
6SHOW FULL COLUMNS FROM `blds_pics_likes`5526
7SELECT `Setting`.`id`, `Setting`.`key`, `Setting`.`value`, `Setting`.`description` FROM `settings` AS `Setting` WHERE 1 = 1 220
8SELECT `Bts`.`id`, `Bts`.`isBtsOrMrt`, `Bts`.`line`, `Bts`.`station_no`, `Bts`.`station_code`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`addr`, `Bts`.`lat`, `Bts`.`lng`, `Bts`.`num_rests`, `Bts`.`num_blds`, `Bts`.`exit1_lat`, `Bts`.`exit1_long`, `Bts`.`exit2_lat`, `Bts`.`exit2_long`, `Bts`.`exit3_lat`, `Bts`.`exit3_long`, `Bts`.`exit4_lat`, `Bts`.`exit4_long`, `Bts`.`exit5_lat`, `Bts`.`exit5_long`, `Bts`.`exit6_lat`, `Bts`.`exit6_long`, `Bts`.`created`, `Bts`.`modified`, `Bts`.`nearby_bts1_id`, `Bts`.`nearby_bts2_id`, `Bts`.`nearby_bts3_id`, `Bts`.`nearby_mrt1_id`, `Bts`.`nearby_mrt2_id`, `Bts`.`nearby_mrt3_id`, `Bts`.`popular_ranking`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn` FROM `btses` AS `Bts` WHERE ((`Bts`.`nameEn` LIKE '%เอกมัย%') OR (`Bts`.`nameTh` LIKE '%เอกมัย%')) LIMIT 1111
9SELECT `Bts`.`id`, `Bts`.`isBtsOrMrt`, `Bts`.`line`, `Bts`.`station_no`, `Bts`.`station_code`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`addr`, `Bts`.`lat`, `Bts`.`lng`, `Bts`.`num_rests`, `Bts`.`num_blds`, `Bts`.`exit1_lat`, `Bts`.`exit1_long`, `Bts`.`exit2_lat`, `Bts`.`exit2_long`, `Bts`.`exit3_lat`, `Bts`.`exit3_long`, `Bts`.`exit4_lat`, `Bts`.`exit4_long`, `Bts`.`exit5_lat`, `Bts`.`exit5_long`, `Bts`.`exit6_lat`, `Bts`.`exit6_long`, `Bts`.`created`, `Bts`.`modified`, `Bts`.`nearby_bts1_id`, `Bts`.`nearby_bts2_id`, `Bts`.`nearby_bts3_id`, `Bts`.`nearby_mrt1_id`, `Bts`.`nearby_mrt2_id`, `Bts`.`nearby_mrt3_id`, `Bts`.`popular_ranking`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn`, `NearbyToBts1`.`id`, `NearbyToBts1`.`isBtsOrMrt`, `NearbyToBts1`.`line`, `NearbyToBts1`.`station_no`, `NearbyToBts1`.`station_code`, `NearbyToBts1`.`nameTh`, `NearbyToBts1`.`nameEn`, `NearbyToBts1`.`addr`, `NearbyToBts1`.`lat`, `NearbyToBts1`.`lng`, `NearbyToBts1`.`num_rests`, `NearbyToBts1`.`num_blds`, `NearbyToBts1`.`exit1_lat`, `NearbyToBts1`.`exit1_long`, `NearbyToBts1`.`exit2_lat`, `NearbyToBts1`.`exit2_long`, `NearbyToBts1`.`exit3_lat`, `NearbyToBts1`.`exit3_long`, `NearbyToBts1`.`exit4_lat`, `NearbyToBts1`.`exit4_long`, `NearbyToBts1`.`exit5_lat`, `NearbyToBts1`.`exit5_long`, `NearbyToBts1`.`exit6_lat`, `NearbyToBts1`.`exit6_long`, `NearbyToBts1`.`created`, `NearbyToBts1`.`modified`, `NearbyToBts1`.`nearby_bts1_id`, `NearbyToBts1`.`nearby_bts2_id`, `NearbyToBts1`.`nearby_bts3_id`, `NearbyToBts1`.`nearby_mrt1_id`, `NearbyToBts1`.`nearby_mrt2_id`, `NearbyToBts1`.`nearby_mrt3_id`, `NearbyToBts1`.`popular_ranking`, (CONCAT("BTS-", `NearbyToBts1`.`nameTh`)) AS `NearbyToBts1__full_nameTh`, (CONCAT("BTS-", `NearbyToBts1`.`nameEn`)) AS `NearbyToBts1__full_nameEn`, `NearbyToBts2`.`id`, `NearbyToBts2`.`isBtsOrMrt`, `NearbyToBts2`.`line`, `NearbyToBts2`.`station_no`, `NearbyToBts2`.`station_code`, `NearbyToBts2`.`nameTh`, `NearbyToBts2`.`nameEn`, `NearbyToBts2`.`addr`, `NearbyToBts2`.`lat`, `NearbyToBts2`.`lng`, `NearbyToBts2`.`num_rests`, `NearbyToBts2`.`num_blds`, `NearbyToBts2`.`exit1_lat`, `NearbyToBts2`.`exit1_long`, `NearbyToBts2`.`exit2_lat`, `NearbyToBts2`.`exit2_long`, `NearbyToBts2`.`exit3_lat`, `NearbyToBts2`.`exit3_long`, `NearbyToBts2`.`exit4_lat`, `NearbyToBts2`.`exit4_long`, `NearbyToBts2`.`exit5_lat`, `NearbyToBts2`.`exit5_long`, `NearbyToBts2`.`exit6_lat`, `NearbyToBts2`.`exit6_long`, `NearbyToBts2`.`created`, `NearbyToBts2`.`modified`, `NearbyToBts2`.`nearby_bts1_id`, `NearbyToBts2`.`nearby_bts2_id`, `NearbyToBts2`.`nearby_bts3_id`, `NearbyToBts2`.`nearby_mrt1_id`, `NearbyToBts2`.`nearby_mrt2_id`, `NearbyToBts2`.`nearby_mrt3_id`, `NearbyToBts2`.`popular_ranking`, (CONCAT("BTS-", `NearbyToBts2`.`nameTh`)) AS `NearbyToBts2__full_nameTh`, (CONCAT("BTS-", `NearbyToBts2`.`nameEn`)) AS `NearbyToBts2__full_nameEn`, `NearbyToBts3`.`id`, `NearbyToBts3`.`isBtsOrMrt`, `NearbyToBts3`.`line`, `NearbyToBts3`.`station_no`, `NearbyToBts3`.`station_code`, `NearbyToBts3`.`nameTh`, `NearbyToBts3`.`nameEn`, `NearbyToBts3`.`addr`, `NearbyToBts3`.`lat`, `NearbyToBts3`.`lng`, `NearbyToBts3`.`num_rests`, `NearbyToBts3`.`num_blds`, `NearbyToBts3`.`exit1_lat`, `NearbyToBts3`.`exit1_long`, `NearbyToBts3`.`exit2_lat`, `NearbyToBts3`.`exit2_long`, `NearbyToBts3`.`exit3_lat`, `NearbyToBts3`.`exit3_long`, `NearbyToBts3`.`exit4_lat`, `NearbyToBts3`.`exit4_long`, `NearbyToBts3`.`exit5_lat`, `NearbyToBts3`.`exit5_long`, `NearbyToBts3`.`exit6_lat`, `NearbyToBts3`.`exit6_long`, `NearbyToBts3`.`created`, `NearbyToBts3`.`modified`, `NearbyToBts3`.`nearby_bts1_id`, `NearbyToBts3`.`nearby_bts2_id`, `NearbyToBts3`.`nearby_bts3_id`, `NearbyToBts3`.`nearby_mrt1_id`, `NearbyToBts3`.`nearby_mrt2_id`, `NearbyToBts3`.`nearby_mrt3_id`, `NearbyToBts3`.`popular_ranking`, (CONCAT("BTS-", `NearbyToBts3`.`nameTh`)) AS `NearbyToBts3__full_nameTh`, (CONCAT("BTS-", `NearbyToBts3`.`nameEn`)) AS `NearbyToBts3__full_nameEn` FROM `btses` AS `Bts` LEFT JOIN `btses` AS `NearbyToBts1` ON (`Bts`.`nearby_bts1_id` = `NearbyToBts1`.`id`) LEFT JOIN `btses` AS `NearbyToBts2` ON (`Bts`.`nearby_bts2_id` = `NearbyToBts2`.`id`) LEFT JOIN `btses` AS `NearbyToBts3` ON (`Bts`.`nearby_bts3_id` = `NearbyToBts3`.`id`) WHERE `Bts`.`id` = 15 LIMIT 1113
10SELECT `Bts`.`id`, `Bts`.`isBtsOrMrt`, `Bts`.`line`, `Bts`.`station_no`, `Bts`.`station_code`, `Bts`.`nameTh`, `Bts`.`nameEn`, `Bts`.`addr`, `Bts`.`lat`, `Bts`.`lng`, `Bts`.`num_rests`, `Bts`.`num_blds`, `Bts`.`exit1_lat`, `Bts`.`exit1_long`, `Bts`.`exit2_lat`, `Bts`.`exit2_long`, `Bts`.`exit3_lat`, `Bts`.`exit3_long`, `Bts`.`exit4_lat`, `Bts`.`exit4_long`, `Bts`.`exit5_lat`, `Bts`.`exit5_long`, `Bts`.`exit6_lat`, `Bts`.`exit6_long`, `Bts`.`created`, `Bts`.`modified`, `Bts`.`nearby_bts1_id`, `Bts`.`nearby_bts2_id`, `Bts`.`nearby_bts3_id`, `Bts`.`nearby_mrt1_id`, `Bts`.`nearby_mrt2_id`, `Bts`.`nearby_mrt3_id`, `Bts`.`popular_ranking`, (CONCAT("BTS-", `Bts`.`nameTh`)) AS `Bts__full_nameTh`, (CONCAT("BTS-", `Bts`.`nameEn`)) AS `Bts__full_nameEn`, `NearbyToMrt1`.`id`, `NearbyToMrt1`.`line`, `NearbyToMrt1`.`station_no`, `NearbyToMrt1`.`station_code`, `NearbyToMrt1`.`nameTh`, `NearbyToMrt1`.`nameEn`, `NearbyToMrt1`.`addr`, `NearbyToMrt1`.`lat`, `NearbyToMrt1`.`lng`, `NearbyToMrt1`.`num_rests`, `NearbyToMrt1`.`num_blds`, `NearbyToMrt1`.`exit1_lat`, `NearbyToMrt1`.`exit1_long`, `NearbyToMrt1`.`exit2_lat`, `NearbyToMrt1`.`exit2_long`, `NearbyToMrt1`.`exit3_lat`, `NearbyToMrt1`.`exit3_long`, `NearbyToMrt1`.`exit4_lat`, `NearbyToMrt1`.`exit4_long`, `NearbyToMrt1`.`exit5_lat`, `NearbyToMrt1`.`exit5_long`, `NearbyToMrt1`.`exit6_lat`, `NearbyToMrt1`.`exit6_long`, `NearbyToMrt1`.`created`, `NearbyToMrt1`.`modified`, `NearbyToMrt1`.`nearby_bts1_id`, `NearbyToMrt1`.`nearby_bts2_id`, `NearbyToMrt1`.`nearby_bts3_id`, `NearbyToMrt1`.`nearby_mrt1_id`, `NearbyToMrt1`.`nearby_mrt2_id`, `NearbyToMrt1`.`nearby_mrt3_id`, `NearbyToMrt1`.`popular_ranking`, (CONCAT("MRT-", `NearbyToMrt1`.`nameTh`)) AS `NearbyToMrt1__full_nameTh`, (CONCAT("MRT-", `NearbyToMrt1`.`nameEn`)) AS `NearbyToMrt1__full_nameEn`, `NearbyToMrt2`.`id`, `NearbyToMrt2`.`line`, `NearbyToMrt2`.`station_no`, `NearbyToMrt2`.`station_code`, `NearbyToMrt2`.`nameTh`, `NearbyToMrt2`.`nameEn`, `NearbyToMrt2`.`addr`, `NearbyToMrt2`.`lat`, `NearbyToMrt2`.`lng`, `NearbyToMrt2`.`num_rests`, `NearbyToMrt2`.`num_blds`, `NearbyToMrt2`.`exit1_lat`, `NearbyToMrt2`.`exit1_long`, `NearbyToMrt2`.`exit2_lat`, `NearbyToMrt2`.`exit2_long`, `NearbyToMrt2`.`exit3_lat`, `NearbyToMrt2`.`exit3_long`, `NearbyToMrt2`.`exit4_lat`, `NearbyToMrt2`.`exit4_long`, `NearbyToMrt2`.`exit5_lat`, `NearbyToMrt2`.`exit5_long`, `NearbyToMrt2`.`exit6_lat`, `NearbyToMrt2`.`exit6_long`, `NearbyToMrt2`.`created`, `NearbyToMrt2`.`modified`, `NearbyToMrt2`.`nearby_bts1_id`, `NearbyToMrt2`.`nearby_bts2_id`, `NearbyToMrt2`.`nearby_bts3_id`, `NearbyToMrt2`.`nearby_mrt1_id`, `NearbyToMrt2`.`nearby_mrt2_id`, `NearbyToMrt2`.`nearby_mrt3_id`, `NearbyToMrt2`.`popular_ranking`, (CONCAT("MRT-", `NearbyToMrt2`.`nameTh`)) AS `NearbyToMrt2__full_nameTh`, (CONCAT("MRT-", `NearbyToMrt2`.`nameEn`)) AS `NearbyToMrt2__full_nameEn`, `NearbyToMrt3`.`id`, `NearbyToMrt3`.`line`, `NearbyToMrt3`.`station_no`, `NearbyToMrt3`.`station_code`, `NearbyToMrt3`.`nameTh`, `NearbyToMrt3`.`nameEn`, `NearbyToMrt3`.`addr`, `NearbyToMrt3`.`lat`, `NearbyToMrt3`.`lng`, `NearbyToMrt3`.`num_rests`, `NearbyToMrt3`.`num_blds`, `NearbyToMrt3`.`exit1_lat`, `NearbyToMrt3`.`exit1_long`, `NearbyToMrt3`.`exit2_lat`, `NearbyToMrt3`.`exit2_long`, `NearbyToMrt3`.`exit3_lat`, `NearbyToMrt3`.`exit3_long`, `NearbyToMrt3`.`exit4_lat`, `NearbyToMrt3`.`exit4_long`, `NearbyToMrt3`.`exit5_lat`, `NearbyToMrt3`.`exit5_long`, `NearbyToMrt3`.`exit6_lat`, `NearbyToMrt3`.`exit6_long`, `NearbyToMrt3`.`created`, `NearbyToMrt3`.`modified`, `NearbyToMrt3`.`nearby_bts1_id`, `NearbyToMrt3`.`nearby_bts2_id`, `NearbyToMrt3`.`nearby_bts3_id`, `NearbyToMrt3`.`nearby_mrt1_id`, `NearbyToMrt3`.`nearby_mrt2_id`, `NearbyToMrt3`.`nearby_mrt3_id`, `NearbyToMrt3`.`popular_ranking`, (CONCAT("MRT-", `NearbyToMrt3`.`nameTh`)) AS `NearbyToMrt3__full_nameTh`, (CONCAT("MRT-", `NearbyToMrt3`.`nameEn`)) AS `NearbyToMrt3__full_nameEn` FROM `btses` AS `Bts` LEFT JOIN `mrts` AS `NearbyToMrt1` ON (`Bts`.`nearby_mrt1_id` = `NearbyToMrt1`.`id`) LEFT JOIN `mrts` AS `NearbyToMrt2` ON (`Bts`.`nearby_mrt2_id` = `NearbyToMrt2`.`id`) LEFT JOIN `mrts` AS `NearbyToMrt3` ON (`Bts`.`nearby_mrt3_id` = `NearbyToMrt3`.`id`) WHERE `Bts`.`id` = 15 LIMIT 1111
11SELECT `CuisineType`.`id`, `CuisineType`.`nameEn`, `CuisineType`.`nameTh`, `CuisineType`.`level`, `CuisineType`.`parent_id`, `CuisineType`.`popular_ranking`, `CuisineType`.`show_in_filter`, `CuisineType`.`created`, `CuisineType`.`modified`, `CuisineType`.`preferred_order` FROM `cuisine_types` AS `CuisineType` WHERE `CuisineType`.`show_in_filter` = 1 ORDER BY `CuisineType`.`level` ASC, ABS(`preferred_order`) ASC, CONVERT(`CuisineType`.`nameTh` USING tis620) ASC 74740
12SELECT `CuisineType`.`id`, `CuisineType`.`nameEn`, `CuisineType`.`nameTh`, `CuisineType`.`level`, `CuisineType`.`parent_id`, `CuisineType`.`popular_ranking`, `CuisineType`.`show_in_filter`, `CuisineType`.`created`, `CuisineType`.`modified`, `CuisineType`.`preferred_order` FROM `cuisine_types` AS `CuisineType` WHERE `CuisineType`.`popular_ranking` > 0 ORDER BY `CuisineType`.`popular_ranking` ASC LIMIT 6660
13SELECT `RestType`.`id`, `RestType`.`nameEn`, `RestType`.`nameTh`, `RestType`.`level`, `RestType`.`parent_id`, `RestType`.`created`, `RestType`.`modified`, `RestType`.`popular_ranking`, `RestType`.`show_in_filter`, `RestType`.`preferred_order` FROM `rest_types` AS `RestType` WHERE `RestType`.`popular_ranking` > 0 ORDER BY `RestType`.`popular_ranking` ASC LIMIT 6550
14SELECT `RestType`.`id`, `RestType`.`nameEn`, `RestType`.`nameTh`, `RestType`.`level`, `RestType`.`parent_id`, `RestType`.`created`, `RestType`.`modified`, `RestType`.`popular_ranking`, `RestType`.`show_in_filter`, `RestType`.`preferred_order` FROM `rest_types` AS `RestType` WHERE `RestType`.`show_in_filter` = 1 ORDER BY `RestType`.`level` ASC, ABS(`preferred_order`) ASC, CONVERT(`RestType`.`nameTh` USING tis620) ASC 20200
15SELECT `RestFeature`.`id`, `RestFeature`.`nameEn`, `RestFeature`.`nameTh`, `RestFeature`.`level`, `RestFeature`.`parent_id`, `RestFeature`.`created`, `RestFeature`.`modified`, `RestFeature`.`popular_ranking`, `RestFeature`.`preferred_order`, `RestFeature`.`show_in_filter` FROM `rest_features` AS `RestFeature` WHERE `RestFeature`.`popular_ranking` > 0 ORDER BY `RestFeature`.`popular_ranking` ASC LIMIT 6330
16SELECT `RestFeature`.`id`, `RestFeature`.`nameEn`, `RestFeature`.`nameTh`, `RestFeature`.`level`, `RestFeature`.`parent_id`, `RestFeature`.`created`, `RestFeature`.`modified`, `RestFeature`.`popular_ranking`, `RestFeature`.`preferred_order`, `RestFeature`.`show_in_filter` FROM `rest_features` AS `RestFeature` WHERE `RestFeature`.`show_in_filter` = 1 ORDER BY `RestFeature`.`level` ASC, ABS(`preferred_order`) ASC, CONVERT(`RestFeature`.`nameTh` USING tis620) ASC 27270
17SELECT `PriceRange`.`id`, `PriceRange`.`nameTh`, `PriceRange`.`nameEn`, `PriceRange`.`from`, `PriceRange`.`to`, `PriceRange`.`created`, `PriceRange`.`modified` FROM `price_ranges` AS `PriceRange` WHERE 1 = 1 ORDER BY `PriceRange`.`id` ASC 990
Submit feedback to KinnShare
If you would like to submit feedback to us, report any bugs or problems using KinnShare website, or found any incorrect info. You can use the form below to contact us :-).
submitting ...