|
sql
app/models/search.rb:54
|
48%
|
app/models/search.rb:54
- Average Self
-
38ms
- Average calls
- 0.96x
- Total Self
- 37ms
- Total Children
- 0ms
- Total runtime
- 37ms
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 ?)) AND `searches`.`collection` = ?
|
|
code
app/controllers/api/v1/searches_controller.rb:23
|
36%
|
app/controllers/api/v1/searches_controller.rb:23
- Average Self
-
27ms
- Average calls
- 1x
- Total Self
- 27ms
- Total Children
- 47ms
- Total runtime
- 75ms
Api::V1::SearchesController#search_all
|
|
sql
app/controllers/api/v1/searches_controller.rb:43
|
4%
|
app/controllers/api/v1/searches_controller.rb:43
- Average Self
-
1.1ms
- Average calls
- 3x
- Total Self
- 3.2ms
- Total Children
- 0ms
- Total runtime
- 3.2ms
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
|
4%
|
app/controllers/api/v1/searches_controller.rb:41
- Average Self
-
1.2ms
- Average calls
- 2.7x
- Total Self
- 3.1ms
- Total Children
- 0ms
- Total runtime
- 3.1ms
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
|
3%
|
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
- Average Self
-
2ms
- Average calls
- 1x
- Total Self
- 2ms
- Total Children
- 75ms
- Total runtime
- 77ms
Rails::Engine#call
|
|
sql
app/models/concerns/attachment_resizable.rb:12
|
2%
|
app/models/concerns/attachment_resizable.rb:12
- Average Self
-
0.84ms
- Average calls
- 1.6x
- Total Self
- 1.3ms
- Total Children
- 0ms
- Total runtime
- 1.3ms
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.82ms
- Average calls
- 1.6x
- Total Self
- 1.3ms
- Total Children
- 0ms
- Total runtime
- 1.3ms
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
-
0.91ms
- Average calls
- 0.76x
- Total Self
- 0.7ms
- Total Children
- 0ms
- Total runtime
- 0.7ms
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.96ms
- Average calls
- 0.24x
- Total Self
- 0.23ms
- Total Children
- 0ms
- Total runtime
- 0.23ms
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:180
|
<1%
|
app/models/gym.rb:180
- Average Self
-
0.84ms
- Average calls
- 0.24x
- Total Self
- 0.2ms
- Total Children
- 0ms
- Total runtime
- 0.2ms
SELECT `gym_options`.* FROM `gym_options` WHERE `gym_options`.`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.08x
- Total Self
- 0.08ms
- Total Children
- 0ms
- Total runtime
- 0.08ms
SELECT `areas`.* FROM `areas` WHERE `areas`.`id` = ?
|
|
sql
app/models/gym.rb:282
|
<1%
|
app/models/gym.rb:282
- Average Self
-
1.3ms
- Average calls
- 0.06x
- Total Self
- 0.08ms
- Total Children
- 0ms
- Total runtime
- 0.08ms
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/gym.rb:295
|
<1%
|
app/models/gym.rb:295
- Average Self
-
1ms
- Average calls
- 0.04x
- Total Self
- 0.04ms
- Total Children
- 0ms
- Total runtime
- 0.04ms
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/area.rb:53
|
<1%
|
app/models/area.rb:53
- Average Self
-
1ms
- Average calls
- <0.01x
- Total Self
- <0.01ms
- Total Children
- 0ms
- Total runtime
- <0.01ms
SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND `crags`.`id` = ? LIMIT ?
|