Average Self

7.3ms

Average calls

1x

Total Self

7.3ms

Total Children

4.8ms

Total runtime

12ms

        Api::V1::CragRoutesController#search
      

Average Self

1.8ms

Average calls

1x

Total Self

1.8ms

Total Children

12ms

Total runtime

13ms

        Rails::Engine#call
      

Average Self

1.7ms

Average calls

0.93x

Total Self

1.6ms

Total Children

0ms

Total runtime

1.6ms

        SELECT `searches`.`index_id`, `searches`.`index_name` 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 ?)) AND (bucket = ? OR secondary_bucket = ?) AND `searches`.`collection` = ?
      

Average Self

1.1ms

Average calls

1x

Total Self

1.1ms

Total Children

0ms

Total runtime

1.1ms

        SELECT `crag_sectors`.* FROM `crag_sectors` WHERE (`crag_sectors`.`deleted_at` IS NULL OR `crag_sectors`.`deleted_at` > ?) AND `crag_sectors`.`id` IS NULL LIMIT ?
      

Average Self

1.1ms

Average calls

1x

Total Self

1.1ms

Total Children

0ms

Total runtime

1.1ms

        SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND `crags`.`id` IS NULL LIMIT ?
      

Average Self

0.9ms

Average calls

0.71x

Total Self

0.64ms

Total Children

0ms

Total runtime

0.64ms

        SELECT `users`.* FROM `users` WHERE `users`.`id` = ? LIMIT ?
      

Average Self

1ms

Average calls

0.43x

Total Self

0.43ms

Total Children

0ms

Total runtime

0.43ms

        SELECT `crag_routes`.* FROM `crag_routes` WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`id` IN (?)