Average Self

50ms

Average calls

1x

Total Self

50ms

Total Children

33ms

Total runtime

83ms

        Api::V1::CragsController#advanced_search
      

Average Self

5.2ms

Average calls

5x

Total Self

26ms

Total Children

0ms

Total runtime

26ms

        SELECT `crags`.* FROM `crags` WHERE (`crags`.`deleted_at` IS NULL OR `crags`.`deleted_at` > ?) AND (north OR north_east OR north_west OR west OR north_west OR south_west) AND (multi_pitch) AND (`crags`.`id` IN (?)) AND (ST_DISTANCE_SPHERE(POINT(crags.longitude, crags.latitude), POINT(?, ?)) <= ?) ORDER BY ST_DISTANCE_SPHERE(POINT(crags.longitude, crags.latitude), POINT(?, ?))
      

Average Self

6ms

Average calls

1x

Total Self

6ms

Total Children

0ms

Total runtime

6ms

        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

2ms

Average calls

1x

Total Self

2ms

Total Children

83ms

Total runtime

85ms

        Rails::Engine#call
      

Average Self

1.1ms

Average calls

1x

Total Self

1.1ms

Total Children

0ms

Total runtime

1.1ms

        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 ?