Performance : panier qualité

[clairezed]

Améliorer la requête :

↳ app/views/reminders/experts/index.haml:9
  Expert Load (70718.3ms)  SELECT "experts".* FROM "experts" 
  INNER JOIN "experts_users" ON "experts_users"."expert_id" = "experts"."id" 
  INNER JOIN "users" ON "users"."deleted_at" IS NULL AND "users"."id" = "experts_users"."user_id" 
  INNER JOIN "reminders_registers" ON "reminders_registers"."expert_id" = "experts"."id" 
  LEFT OUTER JOIN "feedbacks" ON "feedbacks"."feedbackable_type" = $1 AND "feedbacks"."category" = $2 AND "feedbacks"."feedbackable_id" = "experts"."id" 
  LEFT OUTER JOIN "matches" ON "matches"."id" IN (
    SELECT "matches"."id" FROM "matches" 
    INNER JOIN "needs" ON "needs"."id" = "matches"."need_id" 
    INNER JOIN "diagnoses" ON "diagnoses"."id" = "needs"."diagnosis_id" WHERE "diagnoses"."step" = $3
  )
  AND "matches"."status" = $4 AND "matches"."expert_id" = "experts"."id" WHERE (
    "experts"."id" IN (
      SELECT DISTINCT "experts"."id" FROM "experts" 
      INNER JOIN "communes_experts" ON "experts"."id" = "communes_experts"."expert_id" 
      INNER JOIN "communes" ON "communes_experts"."commune_id" = "communes"."id" 
      INNER JOIN "communes_territories" ON "communes"."id" = "communes_territories"."commune_id" WHERE "communes_territories"."territory_id" = $5
    ) OR "experts"."id" IN (
      SELECT DISTINCT "experts"."id" FROM "experts" 
      INNER JOIN "antennes" ON "experts"."antenne_id" = "antennes"."id" 
      INNER JOIN "antennes_communes" ON "antennes"."id" = "antennes_communes"."antenne_id" 
      INNER JOIN "communes" ON "antennes_communes"."commune_id" = "communes"."id" 
      INNER JOIN "communes_territories" ON "communes"."id" = "communes_territories"."commune_id" WHERE "communes_territories"."territory_id" = $6 AND "experts"."deleted_at" IS NULL
    ) AND "experts"."id" IN (
      SELECT "experts"."id" FROM "experts" 
      LEFT OUTER JOIN "communes_experts" ON "communes_experts"."expert_id" = "experts"."id" 
      LEFT OUTER JOIN "communes" ON "communes"."id" = "communes_experts"."commune_id" WHERE "communes"."id" IS NULL
    )
  ) AND "experts"."id" IN (
    SELECT DISTINCT "reminders_registers"."expert_id" FROM "reminders_registers" WHERE "reminders_registers"."run_number" = $7 AND (
      "reminders_registers"."category" = $8 OR "reminders_registers"."category" = $9 AND "reminders_registers"."processed" = $10
    ) AND "reminders_registers"."basket" = $11
  ) GROUP BY "experts"."id" ORDER BY COUNT(matches.id) DESC LIMIT $12 OFFSET $13  
  [["feedbackable_type", "Expert"], 
  ["category", "expert_reminder"], 
  ["step", 5], 
  ["status", "quo"], 
  ["territory_id", 119], 
  ["territory_id", 119], 
  ["run_number", 124], 
  ["category", 0], 
  ["category", 1], 
  ["processed", true], 
  ["basket", 0], ["LIMIT", 25], ["OFFSET", 0]]