SELECT "issues".* FROM "issues" WHERE "issues"."project_id" = 152639770 /*application='RailsTokyoSample'*/ Assignment Load (0.1ms) SELECT "assignments".* FROM "assignments" WHERE "assignments"."issue_id" IN (77551669, 540637335) / *application='RailsTokyoSample'*/ Membership Load (0.1ms) SELECT "memberships".* FROM "memberships" WHERE "memberships"."id" IN (1010729577, 996949822, 664416693) / *application='RailsTokyoSample'*/ Person Load (0.1ms) SELECT "people".* FROM "people" WHERE "people"."id" IN (786122151, 902541635, 663665735) /*application='RailsTokyoSample'*/
(0.4ms) SELECT "issues"."id" AS t0_r0, "issues"."created_at" AS t0_r1, "issues"."creator_id" AS t0_r2, "issues"."description" AS t0_r3, "issues"."project_id" AS t0_r4, "issues"."status" AS t0_r5, "issues"."title" AS t0_r6, "issues"."updated_at" AS t0_r7, "people"."id" AS t1_r0, "people"."created_at" AS t1_r1, "people"."updated_at" AS t1_r2 FROM "issues" LEFT OUTER JOIN "assignments" ON "assignments"."issue_id" = "issues"."id" LEFT OUTER JOIN "memberships" ON "memberships"."id" = "assignments"."membership_id" LEFT OUTER JOIN "people" ON "people"."id" = "memberships"."person_id" WHERE "issues"."project_id" = 152639770 /*application='RailsTokyoSample'*/
w ͜ͷϛϥΫϧ🦄ͳ"DUJWF3FDPSEΛ͍͠·͠ΐ͏ w ʮͪΌΜͱͨ͠ςʔϒϧߏʯΛఆٛͯ͠ɺͦΕΛਏ͘ͳ͘׆༻Ͱ͖Δ ͜ͷΞϓϩʔνͷ3BJMTͷؾ࣋ͪ ͦ͏͍ͬͯूܭΫΤϦΑɺɺɺΈ͍ͨͳͷ͋ΔΜͰ͕͢ɺ͋ΕʮΞΫςΟϒϨίʔυύλʔϯʯΛ ద༻͠ͳ͍ํ͕ྑ͍ϑΥʔε͕͋ΔΘ͚ͳͷͰɺ͞ΒʹผʹΞϓϩʔνͷ΄͏͕ྑ͍ͱࢥͬͯ·͢ɻ
'SELECT * FROM news WHERE ...ORDER BY created_at DESC LIMIT 3' %> <% ActiveRecord::Base.connection.execute(query).each do |row| %> ... <% end %> ͜ͷʮϏϡʔʹ42-ॻ͘ͳʯ Θ͔Δ ͕ͩΜͩΜͱʮϏϡʔͰ%#ʹΞΫηε͢Δͳʯʹͳͬͨͷ͔ͳͱࢥͬͯ·͢ɻ ·ͨϨΠϠׂΞʔΩςΫνϟͷӨڹ͔ɻͰ.7$ҰൠͰͳ͘ɺ3BJMTݸผͷͳͷͰɺͱ͍͏ͷ͕ࢫͰ͢
w ίϯτϩʔϥͰݺͿͱશͯͷςϯϓϨʔτͰಉ͡JODMVEFT͕ద༻͞Εͯ͠·͏ w ϏϡʔͰݺͿͱɺ֤දݱͰඞཁͳͷΛJODMVEFͰ͖Δ ੲ͍͚ͬͯͨͲϏϡʔΛม͑Δ͏ͪʹෆཁʹͳͬͨJODMVEF͕͍ͬͯͯɺΕͨࠒʹύϑΥʔϚϯε ѱԽͷݪҼʹͳͬͨɺΈ͍ͨͳܦݧ͋Δਓଟ͍͔ͱࢥ͍·͢ɻࢲ͍ͬͺ͍͋Γ·͢X