|
http
app/services/open_street_map_api.rb:28
|
60%
|
app/services/open_street_map_api.rb:28
- Average Self
-
128ms
- Average calls
- 1x
- Total Self
- 128ms
- Total Children
- 0ms
- Total runtime
- 128ms
GET nominatim.openstreetmap.org
|
|
code
app/controllers/api/v1/locality_users_controller.rb:19
|
26%
|
app/controllers/api/v1/locality_users_controller.rb:19
- Average Self
-
54ms
- Average calls
- 1x
- Total Self
- 54ms
- Total Children
- 155ms
- Total runtime
- 209ms
Api::V1::LocalityUsersController#create
|
|
sql
app/models/locality_user.rb:85
|
4%
|
app/models/locality_user.rb:85
- Average Self
-
2.4ms
- Average calls
- 3.3x
- Total Self
- 7.9ms
- Total Children
- 0ms
- Total runtime
- 7.9ms
BEGIN
INSERT INTO `localities` (`name`, `code_country`, `region`, `latitude`, `longitude`, `created_at`, `updated_at`) VALUES (?, ?, ?, ?, ?, ?, ?)
|
|
sql
app/models/locality_user.rb:68
|
2%
|
app/models/locality_user.rb:68
- Average Self
-
4.4ms
- Average calls
- 1x
- Total Self
- 4.4ms
- Total Children
- 0ms
- Total runtime
- 4.4ms
SELECT `localities`.* FROM `localities` WHERE `localities`.`name` = ? AND (getRange(latitude, longitude, ?, ?) < ?) ORDER BY getRange(latitude, longitude, ? , ?) LIMIT ?
|
|
sql
app/models/locality.rb:61
|
2%
|
app/models/locality.rb:61
- Average Self
-
3.9ms
- Average calls
- 1x
- Total Self
- 3.9ms
- Total Children
- 0ms
- Total runtime
- 3.9ms
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
|
|
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
-
2.6ms
- Average calls
- 1x
- Total Self
- 2.6ms
- Total Children
- 209ms
- Total runtime
- 212ms
Rails::Engine#call
|
|
sql
app/models/locality.rb:66
|
1%
|
app/models/locality.rb:66
- Average Self
-
2.3ms
- Average calls
- 1x
- Total Self
- 2.3ms
- Total Children
- 0ms
- Total runtime
- 2.3ms
SELECT COUNT(*) FROM `locality_users` WHERE `locality_users`.`locality_id` = ? AND (`deactivated_at` IS NULL OR `deactivated_at` > ?)
|
|
sql
app/models/locality.rb:65
|
1%
|
app/models/locality.rb:65
- Average Self
-
2.3ms
- Average calls
- 1x
- Total Self
- 2.3ms
- Total Children
- 0ms
- Total runtime
- 2.3ms
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:67
|
<1%
|
app/models/locality.rb:67
- Average Self
-
1.9ms
- Average calls
- 1x
- Total Self
- 1.9ms
- Total Children
- 0ms
- Total runtime
- 1.9ms
UPDATE `localities` SET `localities`.`local_sharing_users_count` = ?, `localities`.`distinct_users_count` = ?, `localities`.`updated_at` = ? WHERE `localities`.`id` = ?
|
|
sql
app/models/locality_user.rb:71
|
<1%
|
app/models/locality_user.rb:71
- Average Self
-
2ms
- Average calls
- 0.71x
- Total Self
- 1.4ms
- Total Children
- 0ms
- Total runtime
- 1.4ms
SELECT `locality_users`.* FROM `locality_users` WHERE `locality_users`.`user_id` = ? AND `locality_users`.`locality_id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/api_controller.rb:64
|
<1%
|
app/controllers/api/v1/api_controller.rb:64
- Average Self
-
1.4ms
- Average calls
- 1x
- Total Self
- 1.4ms
- Total Children
- 0ms
- Total runtime
- 1.4ms
SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/api_controller.rb:26
|
<1%
|
app/controllers/api/v1/api_controller.rb:26
- Average Self
-
1.4ms
- Average calls
- 1x
- Total Self
- 1.4ms
- Total Children
- 0ms
- Total runtime
- 1.4ms
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 ?
|