sql
app/models/search.rb:59
|
62 ms
|
1.0
|
44 %
|
DELETE FROM `searches` WHERE `searches`.`collection` = 'User' AND `searches`.`index_id` = 4176
|
code
app/controllers/api/v1/current_users_controller.rb:282
|
46 ms
|
1.0
|
33 %
|
Api::V1::CurrentUsersController#update
|
sql
app/controllers/api/v1/current_users_controller.rb:283
|
2 ms
|
5.8
|
9 %
|
BEGIN
SELECT 1 AS one FROM `users` WHERE `users`.`email` = BINARY 'pa.lagadec@gmail.com' AND `users`.`id` != 4176 LIMIT 1
|
code
/var/www/oblyk/api/shared/bundle/ruby/2.6.0/gems/railties-6.0.3.6/lib/rails/engine.rb:525
|
4 ms
|
1.0
|
3 %
|
|
sql
app/models/search.rb:43
|
2 ms
|
1.0
|
1 %
|
SELECT `searches`.* FROM `searches` WHERE `searches`.`index_name` = 'pierre-axel-lagadec' AND `searches`.`index_id` = 4176 AND `searches`.`collection` = 'User' AND `searches`.`bucket` IS NULL AND `searches`.`secondary_bucket` IS NULL LIMIT 1
|
sql
app/models/user.rb:119
|
2 ms
|
1.0
|
1 %
|
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = 'AscentCragRoute' AND `ascents`.`user_id` = 4176
|
sql
app/controllers/api/v1/api_controller.rb:20
|
2 ms
|
1.0
|
1 %
|
SELECT `ip_black_lists`.* FROM `ip_black_lists` WHERE (block_expired_at <= NOW() OR block_expired_at IS NULL) AND `ip_black_lists`.`ip` = '92.184.102.78' LIMIT 1
|
sql
app/models/search.rb:48
|
1 ms
|
1.0
|
<1 %
|
INSERT INTO `searches` (`index_name`, `index_id`, `collection`) VALUES ('pierre-axel-lagadec', 4176, 'User')
|
sql
app/models/user.rb:346
|
<1 ms
|
1.0
|
<1 %
|
SELECT `gyms`.* FROM `gyms` INNER JOIN `gym_administrators` ON `gyms`.`id` = `gym_administrators`.`gym_id` WHERE (`gyms`.`deleted_at` IS NULL OR `gyms`.`deleted_at` > '2022-06-29 08:53:41.959118') AND `gym_administrators`.`user_id` = 4176
|
sql
app/models/user.rb:142
|
<1 ms
|
1.0
|
<1 %
|
SELECT `tick_lists`.`crag_route_id` FROM `tick_lists` WHERE `tick_lists`.`user_id` = 4176
|
sql
app/controllers/api/v1/api_controller.rb:42
|
<1 ms
|
1.0
|
<1 %
|
SELECT `organizations`.* FROM `organizations` WHERE `organizations`.`api_access_token` = 'M4rvBxc4M7kqqdtXPDvFEYm9' LIMIT 1
|
sql
app/models/user.rb:106
|
<1 ms
|
1.0
|
<1 %
|
SELECT `follows`.* FROM `follows` WHERE `follows`.`user_id` = 4176
|
sql
app/models/user.rb:328
|
<1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `follows` WHERE `follows`.`user_id` = 4176 AND `follows`.`accepted_at` IS NOT NULL AND `follows`.`followable_type` = 'User'
|
sql
app/models/user.rb:347
|
<1 ms
|
1.0
|
<1 %
|
SELECT `organizations`.* FROM `organizations` INNER JOIN `organization_users` ON `organizations`.`id` = `organization_users`.`organization_id` WHERE `organization_users`.`user_id` = 4176
|
sql
app/models/user.rb:326
|
<1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `follows` WHERE `follows`.`followable_id` = 4176 AND `follows`.`followable_type` = 'User'
|
sql
app/models/user.rb:131
|
<1 ms
|
1.0
|
<1 %
|
SELECT `ascents`.* FROM `ascents` WHERE `ascents`.`type` = 'AscentGymRoute' AND `ascents`.`user_id` = 4176 AND `ascents`.`gym_route_id` IS NOT NULL
|
sql
app/controllers/api/v1/api_controller.rb:55
|
<1 ms
|
1.0
|
<1 %
|
SELECT `users`.* FROM `users` WHERE `users`.`id` = 4176 LIMIT 1
|
sql
app/models/user.rb:330
|
<1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `photos` WHERE `photos`.`user_id` = 4176
|
sql
app/models/user.rb:329
|
<1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `videos` WHERE `videos`.`user_id` = 4176
|
sql
app/models/user.rb:327
|
<1 ms
|
1.0
|
<1 %
|
SELECT COUNT(*) FROM `follows` WHERE `follows`.`user_id` = 4176
|