|
sql
app/models/search.rb:54
|
50%
|
app/models/search.rb:54
- Average Self
-
41ms
- Average calls
- 0.93x
- Total Self
- 38ms
- Total Children
- 0ms
- Total runtime
- 38ms
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 ?)) 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 ?)) OR (index_name LIKE ?)) OR (index_name LIKE ?)) OR (index_name LIKE ?)) OR (index_name LIKE ?)) OR (index_name LIKE ?)) AND `searches`.`collection` IN (?)
|
|
code
app/controllers/api/v1/searches_controller.rb:23
|
35%
|
app/controllers/api/v1/searches_controller.rb:23
- Average Self
-
27ms
- Average calls
- 1x
- Total Self
- 27ms
- Total Children
- 48ms
- Total runtime
- 76ms
Api::V1::SearchesController#search_all
|
|
sql
app/controllers/api/v1/searches_controller.rb:41
|
5%
|
app/controllers/api/v1/searches_controller.rb:41
- Average Self
-
1.2ms
- Average calls
- 3.4x
- Total Self
- 4ms
- Total Children
- 0ms
- Total runtime
- 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
-
1.9ms
- Average calls
- 1x
- Total Self
- 1.9ms
- Total Children
- 76ms
- Total runtime
- 77ms
Rails::Engine#call
|
|
sql
app/controllers/api/v1/searches_controller.rb:43
|
2%
|
app/controllers/api/v1/searches_controller.rb:43
- Average Self
-
0.86ms
- Average calls
- 2.2x
- Total Self
- 1.9ms
- Total Children
- 0ms
- Total runtime
- 1.9ms
SELECT `gyms`.* FROM `gyms` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > ?) AND `gyms`.`id` IN (?)
|
|
sql
app/models/concerns/attachment_resizable.rb:12
|
2%
|
app/models/concerns/attachment_resizable.rb:12
- Average Self
-
0.8ms
- Average calls
- 1.8x
- Total Self
- 1.4ms
- Total Children
- 0ms
- Total runtime
- 1.4ms
SELECT `active_storage_blobs`.* FROM `active_storage_blobs` WHERE `active_storage_blobs`.`id` = ? LIMIT ?
|
|
sql
app/models/concerns/attachment_resizable.rb:10
|
2%
|
app/models/concerns/attachment_resizable.rb:10
- Average Self
-
0.79ms
- Average calls
- 1.8x
- Total Self
- 1.4ms
- Total Children
- 0ms
- Total runtime
- 1.4ms
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/controllers/api/v1/searches_controller.rb:44
|
<1%
|
app/controllers/api/v1/searches_controller.rb:44
- Average Self
-
1ms
- Average calls
- 0.57x
- Total Self
- 0.57ms
- Total Children
- 0ms
- Total runtime
- 0.57ms
SELECT `guide_book_papers`.* FROM `guide_book_papers` WHERE `guide_book_papers`.`id` IN (?)
|
|
sql
app/models/gym.rb:293
|
<1%
|
app/models/gym.rb:293
- Average Self
-
0.9ms
- Average calls
- 0.17x
- Total Self
- 0.16ms
- Total Children
- 0ms
- Total runtime
- 0.16ms
SELECT COUNT(*) FROM `gym_spaces` WHERE (`gym_spaces`.`deleted_at` IS NULL OR `gym_spaces`.`deleted_at` > ?) AND `gym_spaces`.`gym_id` = ?
|
|
sql
app/controllers/api/v1/searches_controller.rb:47
|
<1%
|
app/controllers/api/v1/searches_controller.rb:47
- Average Self
-
1ms
- Average calls
- 0.14x
- Total Self
- 0.14ms
- Total Children
- 0ms
- Total runtime
- 0.14ms
SELECT `areas`.* FROM `areas` WHERE `areas`.`id` = ?
|
|
sql
app/models/gym.rb:180
|
<1%
|
app/models/gym.rb:180
- Average Self
-
0.8ms
- Average calls
- 0.17x
- Total Self
- 0.14ms
- Total Children
- 0ms
- Total runtime
- 0.14ms
SELECT `gym_options`.* FROM `gym_options` WHERE `gym_options`.`gym_id` = ?
|
|
sql
app/models/gym.rb:295
|
<1%
|
app/models/gym.rb:295
- Average Self
-
1ms
- Average calls
- 0.03x
- Total Self
- 0.03ms
- Total Children
- 0ms
- Total runtime
- 0.03ms
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:282
|
<1%
|
app/models/gym.rb:282
- Average Self
-
1ms
- Average calls
- 0.02x
- Total Self
- 0.02ms
- Total Children
- 0ms
- Total runtime
- 0.02ms
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:53
|
<1%
|
app/models/area.rb:53
- Average Self
-
1ms
- Average calls
- 0.02x
- Total Self
- 0.02ms
- Total Children
- 0ms
- Total runtime
- 0.02ms
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND `crags`.`id` = ? LIMIT ?
|