[function.php]

[0] functions > [2025-06-23 17:45:41] [c:3 - lat:41.988735 - lng:14.976369].

query_nearest_places : SELECT *, distance_calculated.distance_in_miles, ((`Reviews` + (10 / GREATEST(distance_calculated.distance_in_miles, 1))) * 1) / POW(GREATEST(distance_calculated.distance_in_miles, 1), 4) AS `reviews_per_distance` FROM ( SELECT *, ((ACOS(SIN(41.9887 * PI() / 180) * SIN(`truncated_lat` * PI() / 180) + COS(41.9887 * PI() / 180) * COS(`truncated_lat` * PI() / 180) * COS((14.9763 - `truncated_lng`) * PI() / 180)) * 180 / PI()) * 60 * 1.1515) AS distance_in_miles FROM `places_min` WHERE `truncated_lat` BETWEEN (41.9887 - 0.2) AND (41.9887 + 0.2) AND `truncated_lng` BETWEEN (14.9763 - 0.14865535568751) AND (14.9763 + 0.14865535568751) AND `Reviews` > 10 AND SUBSTRING_INDEX(id_cat_all, ',', 1) IN ( SELECT id_cat FROM categories_google_maps WHERE parent_cat = '3' AND yutugo_cat >= 1 ) ) AS distance_calculated GROUP BY Name ORDER BY CASE WHEN distance_calculated.distance_in_miles <= 7 THEN 0 ELSE 1 END, `reviews_per_distance` DESC LIMIT 0, 86;

total_nearest_places : 5

Google Maps (41.9887 - 14.9763)

Load time: 0.299 seconds