Average Self

291ms

Average calls

0.99x

Total Self

288ms

Total Children

0ms

Total runtime

288ms

        SELECT `locality_users`.`user_id` FROM `locality_users` INNER JOIN `users` ON `users`.`id` = `locality_users`.`user_id` INNER JOIN `localities` ON `localities`.`id` = `locality_users`.`locality_id` WHERE `users`.`partner_search` = TRUE AND (EXISTS(SELECT * FROM locality_users WHERE deactivated_at IS NULL AND user_id = users.id)) AND (users.last_activity_at > ?) AND (getRange(localities.latitude, localities.longitude, -?, ?) < (locality_users.radius * ?))
      

Average Self

62ms

Average calls

1x

Total Self

62ms

Total Children

297ms

Total runtime

360ms

        Api::V1::PartnersController#partners_around
      

Average Self

3.3ms

Average calls

2.9x

Total Self

9.8ms

Total Children

0ms

Total runtime

9.8ms

        SELECT `users`.* FROM `users` WHERE `users`.`id` IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? [TRUNCATED]
      

Average Self

2.6ms

Average calls

1x

Total Self

2.6ms

Total Children

360ms

Total runtime

363ms

        Rails::Engine#call
      

Average Self

1.4ms

Average calls

0.01x

Total Self

0.02ms

Total Children

0ms

Total runtime

0.02ms

        SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` IS NULL LIMIT ?
      

Average Self

2ms

Average calls

<0.01x

Total Self

<0.01ms

Total Children

0ms

Total runtime

<0.01ms

        SET NAMES utf8mb4,  @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ?), ?),  @@SESSION.sql_auto_is_null = ?, @@SESSION.wait_timeout = ?