|
sql
app/jobs/add_shared_satisfactions_job.rb:11
|
61%
|
app/jobs/add_shared_satisfactions_job.rb:11
- Average Self
-
29ms
- Average calls
- 2.1x
- Total Self
- 61ms
- Total Children
- 0ms
- Total runtime
- 61ms
SELECT DISTINCT "company_satisfactions"."id" FROM "company_satisfactions" INNER JOIN "shared_satisfactions" ON "shared_satisfactions"."company_satisfaction_id" = "company_satisfactions"."id" INNER JOIN "experts" ON "experts"."id" = "shared_satisfactions"."expert_id" INNER JOIN "antennes" ON "antennes"."id" = "experts"."antenne_id" WHERE "experts"."antenne_id" IN (?)
SELECT "company_satisfactions"."id" FROM "company_satisfactions" INNER JOIN "shared_satisfactions" ON "company_satisfactions"."id" = "shared_satisfactions"."company_satisfaction_id" WHERE "shared_satisfactions"."user_id" = ?
|
|
sql
app/jobs/add_shared_satisfactions_job.rb:8
|
12%
|
app/jobs/add_shared_satisfactions_job.rb:8
- Average Self
-
11ms
- Average calls
- 1x
- Total Self
- 11ms
- Total Children
- 0ms
- Total runtime
- 11ms
SELECT DISTINCT "antennes".* FROM "antennes" INNER JOIN "user_rights" ON "antennes"."id" = "user_rights"."rightable_element_id" INNER JOIN "user_rights" "user_rights_antennes" ON "user_rights_antennes"."rightable_element_type" = ? AND "user_rights_antennes"."rightable_element_id" = "antennes"."id" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? AND "user_rights"."rightable_element_type" = ? ORDER BY "antennes"."id" ASC LIMIT ?
|
|
redis
app/models/antenne.rb:269
|
8%
|
app/models/antenne.rb:269
- Average Self
-
4.9ms
- Average calls
- 1.6x
- Total Self
- 8ms
- Total Children
- 0ms
- Total runtime
- 8ms
get
|
|
code
app/jobs/add_shared_satisfactions_job.rb:4
|
7%
|
app/jobs/add_shared_satisfactions_job.rb:4
- Average Self
-
7ms
- Average calls
- 1x
- Total Self
- 7ms
- Total Children
- 85ms
- Total runtime
- 92ms
AddSharedSatisfactionsJob#perform
|
|
gc
ruby/gc.c
|
6%
|
ruby/gc.c
- Average Self
-
9.2ms
- Average calls
- 0.63x
- Total Self
- 5.8ms
- Total Children
- 0ms
- Total runtime
- 5.8ms
GC.start
|
|
code
vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/active_job/queue_adapters/sidekiq_adapter.rb:13
|
2%
|
vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/active_job/queue_adapters/sidekiq_adapter.rb:13
- Average Self
-
1.8ms
- Average calls
- 1x
- Total Self
- 1.8ms
- Total Children
- 92ms
- Total runtime
- 94ms
AddSharedSatisfactionsJob#perform
|
|
sql
app/jobs/add_shared_satisfactions_job.rb:5
|
2%
|
app/jobs/add_shared_satisfactions_job.rb:5
- Average Self
-
1.8ms
- Average calls
- 1x
- Total Self
- 1.8ms
- Total Children
- 0ms
- Total runtime
- 1.8ms
SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ?
|
|
sql
app/jobs/add_shared_satisfactions_job.rb:14
|
<1%
|
app/jobs/add_shared_satisfactions_job.rb:14
- Average Self
-
0.86ms
- Average calls
- 0.84x
- Total Self
- 0.72ms
- Total Children
- 0.05ms
- Total runtime
- 0.77ms
SELECT "shared_satisfactions".* FROM "shared_satisfactions" WHERE "shared_satisfactions"."company_satisfaction_id" = ? AND "shared_satisfactions"."user_id" = ? ORDER BY "shared_satisfactions"."id" ASC LIMIT ?
SELECT "users".* FROM "users" WHERE "users"."id" = ? LIMIT ?
BEGIN
SELECT ? AS one FROM "shared_satisfactions" WHERE "shared_satisfactions"."user_id" = ? AND "shared_satisfactions"."company_satisfaction_id" = ? AND "shared_satisfactions"."expert_id" = ? LIMIT ?
INSERT INTO "shared_satisfactions" ("user_id", "company_satisfaction_id", "expert_id", "seen_at", "created_at", "updated_at") VALUES (?, ?, ?, ?, ?, ?) RETURNING "id"
UPDATE "company_satisfactions" SET "updated_at" = ? WHERE "company_satisfactions"."id" = ?
COMMIT
|
|
cache
app/models/antenne.rb:269
|
<1%
|
app/models/antenne.rb:269
- Average Self
-
0.4ms
- Average calls
- 1.6x
- Total Self
- 0.64ms
- Total Children
- 8ms
- Total runtime
- 8.6ms
read
|
|
sql
app/models/antenne.rb:273
|
<1%
|
app/models/antenne.rb:273
- Average Self
-
1.9ms
- Average calls
- 0.17x
- Total Self
- 0.33ms
- Total Children
- 0ms
- Total runtime
- 0.33ms
SELECT "antennes"."id" FROM "antennes" WHERE "antennes"."parent_antenne_id" = ?
|
|
sql
app/jobs/add_shared_satisfactions_job.rb:13
|
<1%
|
app/jobs/add_shared_satisfactions_job.rb:13
- Average Self
-
0.75ms
- Average calls
- 0.24x
- Total Self
- 0.18ms
- Total Children
- 0ms
- Total runtime
- 0.18ms
SELECT "antennes"."id" FROM "antennes" WHERE "antennes"."id" = ?
SELECT "experts".* FROM "experts" INNER JOIN "matches" ON "experts"."id" = "matches"."expert_id" INNER JOIN "needs" ON "matches"."need_id" = "needs"."id" WHERE "needs"."id" = ? AND "matches"."status" = ? AND "experts"."antenne_id" = ? ORDER BY "experts"."id" ASC LIMIT ?
|
|
code
vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:130
|
<1%
|
vendor/bundle/ruby/4.0.0/gems/activesupport-8.1.3/lib/active_support/callbacks.rb:130
- Average Self
-
0.1ms
- Average calls
- 1x
- Total Self
- 0.1ms
- Total Children
- 92ms
- Total runtime
- 92ms
AddSharedSatisfactionsJob
|
|
code
vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/sidekiq/middleware/chain.rb:182
|
<1%
|
vendor/bundle/ruby/4.0.0/gems/sidekiq-8.1.6/lib/sidekiq/middleware/chain.rb:182
- Average Self
-
0.06ms
- Average calls
- 1x
- Total Self
- 0.06ms
- Total Children
- 94ms
- Total runtime
- 94ms
|
|
sql
app/models/user.rb:310
|
<1%
|
app/models/user.rb:310
- Average Self
-
0.5ms
- Average calls
- 0.12x
- Total Self
- 0.06ms
- Total Children
- 0ms
- Total runtime
- 0.06ms
SELECT ? AS one FROM "user_rights" WHERE "user_rights"."user_id" = ? AND "user_rights"."category" = ? LIMIT ?
|
|
sql
app/models/antenne.rb:271
|
<1%
|
app/models/antenne.rb:271
- Average Self
-
0.83ms
- Average calls
- 0.07x
- Total Self
- 0.06ms
- Total Children
- 0ms
- Total runtime
- 0.06ms
SELECT "institutions".* FROM "institutions" WHERE "institutions"."id" = ? LIMIT ?
|
|
sql
app/models/user.rb:351
|
<1%
|
app/models/user.rb:351
- Average Self
-
1ms
- Average calls
- 0.01x
- Total Self
- 0.01ms
- Total Children
- 0ms
- Total runtime
- 0.01ms
SELECT "antennes".* FROM "antennes" WHERE "antennes"."id" = ? LIMIT ?
|
|
sql
app/jobs/add_shared_satisfactions_job.rb:12
|
<1%
|
app/jobs/add_shared_satisfactions_job.rb:12
- Average Self
-
0ms
- Average calls
- 0.01x
- Total Self
- 0ms
- Total Children
- 0ms
- Total runtime
- 0ms
SELECT "company_satisfactions".* FROM "company_satisfactions" WHERE "company_satisfactions"."id" IN (?) ORDER BY "company_satisfactions"."id" ASC LIMIT ?
|