Average Self

70ms

Average calls

1x

Total Self

70ms

Total Children

0ms

Total runtime

70ms

        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 (ST_DISTANCE_SPHERE(POINT(localities.longitude, localities.latitude), POINT(?, -?)) < (locality_users.radius * ?))
      

Average Self

35ms

Average calls

1x

Total Self

35ms

Total Children

77ms

Total runtime

113ms

        Api::V1::PartnersController#partners_around
      

Average Self

2.4ms

Average calls

3x

Total Self

7.3ms

Total Children

0ms

Total runtime

7.3ms

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

Average Self

1.9ms

Average calls

1x

Total Self

1.9ms

Total Children

113ms

Total runtime

115ms

        Rails::Engine#call
      

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