|
http
app/services/open_street_map_api.rb:28
|
46%
|
app/services/open_street_map_api.rb:28
- Average Self
-
52ms
- Calls
- 1x
- Total Self
- 52ms
- Total Children
- 0ms
- Total runtime
- 52ms
GET nominatim.openstreetmap.org
|
|
code
app/controllers/api/v1/locality_users_controller.rb:19
|
41%
|
app/controllers/api/v1/locality_users_controller.rb:19
- Average Self
-
46ms
- Calls
- 1x
- Total Self
- 46ms
- Total Children
- 66ms
- Total runtime
- 112ms
Api::V1::LocalityUsersController#create
|
|
sql
app/models/locality_user.rb:85
|
4%
|
app/models/locality_user.rb:85
- Average Self
-
1.3ms
- Calls
- 3x
- Total Self
- 4ms
- Total Children
- 0ms
- Total runtime
- 4ms
BEGIN
INSERT INTO `locality_users` (`user_id`, `locality_id`, `partner_search`, `local_sharing`, `radius`, `created_at`, `updated_at`) VALUES (?, ?, TRUE, TRUE, ?, ?, ?)
|
|
sql
app/models/locality_user.rb:68
|
3%
|
app/models/locality_user.rb:68
- Average Self
-
3ms
- Calls
- 1x
- Total Self
- 3ms
- Total Children
- 0ms
- Total runtime
- 3ms
SELECT `localities`.* FROM `localities` WHERE `localities`.`name` = ? AND (ST_DISTANCE_SPHERE(POINT(longitude, latitude), POINT(?, ?)) < ?) ORDER BY ST_DISTANCE_SPHERE(POINT(longitude, latitude), POINT(?, ?)) LIMIT ?
|
|
sql
app/models/locality.rb:61
|
<1%
|
app/models/locality.rb:61
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT COUNT(*) FROM `locality_users` INNER JOIN `users` ON `users`.`id` = `locality_users`.`user_id` WHERE (`deactivated_at` IS NULL OR `deactivated_at` > ?) AND `locality_users`.`locality_id` = ? AND `locality_users`.`partner_search` = TRUE AND (users.last_activity_at > ?) AND `users`.`partner_search` = TRUE
|
|
sql
app/models/locality.rb:65
|
<1%
|
app/models/locality.rb:65
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT COUNT(*) FROM `locality_users` WHERE (`deactivated_at` IS NULL OR `deactivated_at` > ?) AND `locality_users`.`locality_id` = ? AND `locality_users`.`local_sharing` = TRUE
|
|
sql
app/models/locality.rb:66
|
<1%
|
app/models/locality.rb:66
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT COUNT(*) FROM `locality_users` WHERE `locality_users`.`locality_id` = ? AND (`deactivated_at` IS NULL OR `deactivated_at` > ?)
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
<1%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 112ms
- Total runtime
- 113ms
Rails::Engine#call
|
|
sql
app/models/locality.rb:67
|
<1%
|
app/models/locality.rb:67
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
UPDATE `localities` SET `localities`.`local_sharing_users_count` = ?, `localities`.`distinct_users_count` = ?, `localities`.`updated_at` = ? WHERE `localities`.`id` = ?
|
|
sql
app/controllers/api/v1/api_controller.rb:26
|
<1%
|
app/controllers/api/v1/api_controller.rb:26
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `ip_black_lists`.* FROM `ip_black_lists` WHERE (block_expired_at <= NOW() OR block_expired_at IS NULL) AND `ip_black_lists`.`ip` IS NULL LIMIT ?
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
<1%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/models/locality_user.rb:71
|
<1%
|
app/models/locality_user.rb:71
- Average Self
-
1ms
- Calls
- 1x
- Total Self
- 1ms
- Total Children
- 0ms
- Total runtime
- 1ms
SELECT `locality_users`.* FROM `locality_users` WHERE `locality_users`.`user_id` = ? AND `locality_users`.`locality_id` = ? LIMIT ?
|