SHOW FULL COLUMNS FROM `ecs_site` [ RunTime:0.007349s ]
SELECT * FROM `ecs_site` WHERE `code` = 'hualien' AND `status` = 1 LIMIT 1 [ RunTime:0.009349s ]
SHOW FULL COLUMNS FROM `ecs_bnb` [ RunTime:0.007694s ]
SELECT * FROM `ecs_bnb` WHERE `id` = 53 AND `site_code` = 'hualien' LIMIT 1 [ RunTime:0.001715s ]
SHOW FULL COLUMNS FROM `ecs_bnb_image` [ RunTime:0.007487s ]
SELECT * FROM `ecs_bnb_image` WHERE `bnb_id` = 53 AND `is_cover` = 0 AND `site_code` = 'hualien' LIMIT 4 [ RunTime:0.005505s ]
SELECT a.*, ac.name as category_name, ac.icon as category_icon,
ROUND((6371 * ACOS(
COS(RADIANS('23.48880450')) * COS(RADIANS(a.latitude)) * COS(RADIANS(a.longitude) - RADIANS('121.50972760'))
+ SIN(RADIANS('23.48880450')) * SIN(RADIANS(a.latitude))
)), 1) AS distance
FROM ecs_attraction a
LEFT JOIN ecs_attraction_category ac ON a.category_id = ac.id
WHERE a.status = 1
AND a.latitude IS NOT NULL
AND a.longitude IS NOT NULL
AND a.latitude != ''
AND a.longitude != ''
HAVING distance < 20
ORDER BY distance ASC
LIMIT 3 [ RunTime:0.001085s ]
SELECT f.*,
ROUND((6371 * ACOS(
COS(RADIANS('23.48880450')) * COS(RADIANS(f.latitude)) * COS(RADIANS(f.longitude) - RADIANS('121.50972760'))
+ SIN(RADIANS('23.48880450')) * SIN(RADIANS(f.latitude))
)), 1) AS distance
FROM ecs_food f
WHERE f.status > 0
AND f.latitude IS NOT NULL
AND f.longitude IS NOT NULL
AND f.latitude != ''
AND f.longitude != ''
HAVING distance < 20
ORDER BY distance ASC
LIMIT 5 [ RunTime:0.003274s ]
