app/jobs/historize_towns_around_job.rb:17
- Average Self
-
94ms
- Average calls
- 1x
- Total Self
- 94ms
- Total Children
- 0ms
- Total runtime
- 94ms
SELECT `towns`.* FROM `towns` WHERE (updated_at < ?) AND ((population BETWEEN ? AND ? AND ST_DISTANCE_SPHERE(POINT(towns.longitude, towns.latitude), POINT(?, ?)) < ?)
OR (population BETWEEN ? AND ? AND ST_DISTANCE_SPHERE(POINT(towns.longitude, towns.latitude), POINT(?, ?)) < ?)
OR (population BETWEEN ? AND ? AND ST_DISTANCE_SPHERE(POINT(towns.longitude, towns.latitude), POINT(?, ?)) < ?)
OR (population > ? AND ST_DISTANCE_SPHERE(POINT(towns.longitude, towns.latitude), POINT(?, ?)) < ?)) ORDER BY `towns`.`id` ASC LIMIT ?
|
app/jobs/historize_towns_around_job.rb:8
- Average Self
-
0.5ms
- Average calls
- 1x
- Total Self
- 0.5ms
- Total Children
- 0ms
- Total runtime
- 0.5ms
SET NAMES utf8mb4, @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ?), ?), @@SESSION.sql_auto_is_null = ?, @@SESSION.wait_timeout = ?
|