Average Self

292ms

Average calls

0.99x

Total Self

290ms

Total Children

0ms

Total runtime

290ms

        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

52ms

Average calls

1x

Total Self

52ms

Total Children

298ms

Total runtime

351ms

        Api::V1::PartnersController#partners_around
      

Average Self

2.8ms

Average calls

3x

Total Self

8.2ms

Total Children

0ms

Total runtime

8.2ms

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

Average Self

2.4ms

Average calls

1x

Total Self

2.4ms

Total Children

351ms

Total runtime

353ms

        Rails::Engine#call
      

Average Self

2ms

Average calls

<0.01x

Total Self

0.01ms

Total Children

0ms

Total runtime

0.01ms

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

Average Self

1ms

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 = ?