Average Self

93ms

Average calls

3.9x

Total Self

367ms

Total Children

0ms

Total runtime

367ms

        SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND (sport_climbing OR bouldering OR aid_climbing) AND (getRange(latitude, longitude, ?, -?) <= ?) ORDER BY getRange(latitude, longitude, ?, -?)
      

Average Self

68ms

Average calls

1x

Total Self

68ms

Total Children

375ms

Total runtime

443ms

        Api::V1::CragsController#advanced_search
      

Average Self

6.2ms

Average calls

1x

Total Self

6.2ms

Total Children

0ms

Total runtime

6.2ms

        SELECT climbing_type,
      crag_routes.max_grade_value,
      crag_routes.max_grade_text,
      crag_routes.min_grade_value,
      crag_routes.min_grade_text,
      crag_routes.id,
      crag_id,
      crag_routes.name,
      crag_routes.slug_name,
      sections_count,
      sections,
      crags.name AS crag_name,
      crags.slug_name AS crag_slug_name FROM `crag_routes` INNER JOIN `crags` ON `crags`.`id` = `crag_routes`.`crag_id` AND (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) WHERE (`crag_routes`.`deleted_at` IS NULL OR `crag_routes`.`deleted_at` > ?) AND `crag_routes`.`crag_id` IN (?)
      

Average Self

2.8ms

Average calls

1x

Total Self

2.8ms

Total Children

443ms

Total runtime

445ms

        Rails::Engine#call
      

Average Self

1.6ms

Average calls

1x

Total Self

1.6ms

Total Children

0ms

Total runtime

1.6ms

        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 ?