|
code
app/controllers/api/v1/searches_controller.rb:23
|
41%
|
app/controllers/api/v1/searches_controller.rb:23
- Average Self
-
70ms
- Average calls
- 1x
- Total Self
- 70ms
- Total Children
- 98ms
- Total runtime
- 169ms
Api::V1::SearchesController#search_all
|
|
sql
app/models/search.rb:54
|
40%
|
app/models/search.rb:54
- Average Self
-
68ms
- Average calls
- 0.99x
- Total Self
- 68ms
- Total Children
- 0ms
- Total runtime
- 68ms
SELECT DISTINCT `searches`.`index_id`, `searches`.`index_name`, `searches`.`collection` FROM `searches` WHERE ((((((((index_name LIKE ?) OR (index_name LIKE ?)) OR (index_name LIKE ?)) OR (index_name LIKE ?)) OR (index_name LIKE ?)) OR (index_name LIKE ?)) OR (index_name LIKE ?)) OR (index_name LIKE ?)) AND `searches`.`collection` = ?
|
|
sql
app/models/concerns/attachment_resizable.rb:10
|
4%
|
app/models/concerns/attachment_resizable.rb:10
- Average Self
-
1.5ms
- Average calls
- 5.3x
- Total Self
- 7.7ms
- Total Children
- 0ms
- Total runtime
- 7.7ms
SELECT `active_storage_attachments`.* FROM `active_storage_attachments` WHERE `active_storage_attachments`.`record_id` = ? AND `active_storage_attachments`.`record_type` = ? AND `active_storage_attachments`.`name` = ? LIMIT ?
|
|
sql
app/models/concerns/attachment_resizable.rb:12
|
4%
|
app/models/concerns/attachment_resizable.rb:12
- Average Self
-
1.3ms
- Average calls
- 5.3x
- Total Self
- 6.7ms
- Total Children
- 0ms
- Total runtime
- 6.7ms
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
|
|
sql
app/controllers/api/v1/searches_controller.rb:43
|
3%
|
app/controllers/api/v1/searches_controller.rb:43
- Average Self
-
2.2ms
- Average calls
- 2.6x
- Total Self
- 5.8ms
- Total Children
- 0ms
- Total runtime
- 5.8ms
SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` IN (?)
|
|
sql
app/controllers/api/v1/searches_controller.rb:41
|
3%
|
app/controllers/api/v1/searches_controller.rb:41
- Average Self
-
1.9ms
- Average calls
- 2.8x
- Total Self
- 5.4ms
- Total Children
- 0ms
- Total runtime
- 5.4ms
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND `crags`.`id` IN (?)
|
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
2%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
2.7ms
- Average calls
- 1x
- Total Self
- 2.7ms
- Total Children
- 169ms
- Total runtime
- 172ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/searches_controller.rb:47
|
<1%
|
app/controllers/api/v1/searches_controller.rb:47
- Average Self
-
1.3ms
- Average calls
- 0.96x
- Total Self
- 1.2ms
- Total Children
- 0ms
- Total runtime
- 1.2ms
SELECT `areas`.* FROM `areas` WHERE `areas`.`id` = ?
|
|
sql
app/controllers/api/v1/searches_controller.rb:44
|
<1%
|
app/controllers/api/v1/searches_controller.rb:44
- Average Self
-
1.3ms
- Average calls
- 0.91x
- Total Self
- 1.2ms
- Total Children
- 0ms
- Total runtime
- 1.2ms
SELECT `guide_book_papers`.* FROM `guide_book_papers` WHERE `guide_book_papers`.`id` IN (?)
|
|
sql
app/models/gym.rb:295
|
<1%
|
app/models/gym.rb:295
- Average Self
-
1.3ms
- Average calls
- 0.69x
- Total Self
- 0.89ms
- Total Children
- 0ms
- Total runtime
- 0.89ms
SELECT COUNT(*) FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ?
|
|
sql
app/models/gym.rb:182
|
<1%
|
app/models/gym.rb:182
- Average Self
-
1.3ms
- Average calls
- 0.69x
- Total Self
- 0.88ms
- Total Children
- 0ms
- Total runtime
- 0.88ms
SELECT `gym_options`.* FROM `gym_options` WHERE `gym_options`.`gym_id` = ?
|
|
sql
app/controllers/api/v1/searches_controller.rb:45
|
<1%
|
app/controllers/api/v1/searches_controller.rb:45
- Average Self
-
2.2ms
- Average calls
- 0.21x
- Total Self
- 0.46ms
- Total Children
- 0ms
- Total runtime
- 0.46ms
SELECT `users`.* FROM `users` WHERE `users`.`id` IN (?)
|
|
sql
app/models/gym.rb:297
|
<1%
|
app/models/gym.rb:297
- Average Self
-
1.6ms
- Average calls
- 0.14x
- Total Self
- 0.22ms
- Total Children
- 0ms
- Total runtime
- 0.22ms
SELECT `gym_spaces`.* FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ? ORDER BY `gym_spaces`.`order` ASC LIMIT ?
|
|
sql
app/models/gym.rb:284
|
<1%
|
app/models/gym.rb:284
- Average Self
-
1.5ms
- Average calls
- 0.13x
- Total Self
- 0.19ms
- Total Children
- 0ms
- Total runtime
- 0.19ms
SELECT `gym_spaces`.* FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ? ORDER BY `gym_spaces`.`order` ASC
|
|
sql
app/models/area.rb:49
|
<1%
|
app/models/area.rb:49
- Average Self
-
1.7ms
- Average calls
- 0.06x
- Total Self
- 0.11ms
- Total Children
- 0ms
- Total runtime
- 0.11ms
SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`id` = ? LIMIT ?
|