|
sql
app/controllers/api/v1/towns_controller.rb:57
|
52%
|
app/controllers/api/v1/towns_controller.rb:57
- Average Self
-
12ms
- Average calls
- 1.7x
- Total Self
- 20ms
- Total Children
- 0ms
- Total runtime
- 20ms
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND (ST_DISTANCE_SPHERE(POINT(longitude, latitude), POINT(-?, ?)) < ?) ORDER BY `crags`.`id` ASC LIMIT ?
|
|
code
app/controllers/api/v1/towns_controller.rb:50
|
32%
|
app/controllers/api/v1/towns_controller.rb:50
- Average Self
-
13ms
- Average calls
- 1x
- Total Self
- 13ms
- Total Children
- 25ms
- Total runtime
- 38ms
Api::V1::TownsController#geo_json
|
|
sql
app/controllers/api/v1/towns_controller.rb:63
|
9%
|
app/controllers/api/v1/towns_controller.rb:63
- Average Self
-
2.6ms
- Average calls
- 1.4x
- Total Self
- 3.5ms
- Total Children
- 0ms
- Total runtime
- 3.5ms
SELECT `gyms`.`id`, `gyms`.`name`, `gyms`.`longitude`, `gyms`.`latitude`, `gyms`.`updated_at` FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND (ST_DISTANCE_SPHERE(POINT(longitude, latitude), POINT(-?, ?)) < ?) ORDER BY `gyms`.`id` ASC LIMIT ?
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
5%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
1.8ms
- Average calls
- 1x
- Total Self
- 1.8ms
- Total Children
- 38ms
- Total runtime
- 40ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/towns_controller.rb:82
|
2%
|
app/controllers/api/v1/towns_controller.rb:82
- Average Self
-
1ms
- Average calls
- 0.94x
- Total Self
- 0.94ms
- Total Children
- 0ms
- Total runtime
- 0.94ms
SELECT `towns`.* FROM `towns` WHERE `towns`.`slug_name` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/api_controller.rb:50
|
<1%
|
app/controllers/api/v1/api_controller.rb:50
- Average Self
-
1ms
- Average calls
- 0.06x
- Total Self
- 0.06ms
- Total Children
- 0ms
- Total runtime
- 0.06ms
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` IS NULL LIMIT ?
|