Skip to content

Instantly share code, notes, and snippets.

@Olefine
Created September 30, 2013 13:13
Show Gist options
  • Save Olefine/6763626 to your computer and use it in GitHub Desktop.
Save Olefine/6763626 to your computer and use it in GitHub Desktop.
polls log
Started GET "/polls/12" for 127.0.0.1 at 2013-09-30 16:51:13 +0400
Processing by PollsController#show as JS
Parameters: {"id"=>"12"}
User Load (2.1ms) SELECT "users".* FROM "users" WHERE "users"."id" = 10 LIMIT 1
Poll Load (1.7ms) SELECT "polls".* FROM "polls" WHERE "polls"."id" = $1 ORDER BY created_at DESC LIMIT 1 [["id", "12"]]
Client Load (3.2ms) SELECT "clients".* FROM "clients" WHERE "clients"."id" = 64 LIMIT 1
User Load (3.1ms) SELECT "users".* FROM "users" WHERE "users"."profileable_id" = 64 AND "users"."profileable_type" = 'Client' LIMIT 1
(2.9ms) SELECT COUNT(*) FROM "comments" WHERE "comments"."commentable_id" = 12 AND "comments"."commentable_type" = 'Poll'
(2.8ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."votable_id" = 12 AND "votes"."votable_type" = 'Poll' AND "votes"."vote_flag" = 't' AND "votes"."vote_scope" IS NULL
PollImage Load (3.1ms) SELECT "images".* FROM "images" WHERE "images"."type" IN ('PollImage') AND "images"."imageable_id" = 12 AND "images"."imageable_type" = 'Poll' ORDER BY id DESC
(3.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 136 AND "votes"."votable_type" = 'Image'
(3.3ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 135 AND "votes"."votable_type" = 'Image'
(3.3ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 134 AND "votes"."votable_type" = 'Image'
(3.4ms) SELECT COUNT(*) FROM "images" WHERE "images"."type" IN ('PollImage') AND "images"."imageable_id" = 12 AND "images"."imageable_type" = 'Poll'
CACHE (0.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 136 AND "votes"."votable_type" = 'Image'
CACHE (0.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 135 AND "votes"."votable_type" = 'Image'
CACHE (0.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 134 AND "votes"."votable_type" = 'Image'
CACHE (0.0ms) SELECT COUNT(*) FROM "images" WHERE "images"."type" IN ('PollImage') AND "images"."imageable_id" = 12 AND "images"."imageable_type" = 'Poll'
CACHE (0.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 136 AND "votes"."votable_type" = 'Image'
CACHE (0.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 135 AND "votes"."votable_type" = 'Image'
CACHE (0.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 134 AND "votes"."votable_type" = 'Image'
CACHE (0.0ms) SELECT COUNT(*) FROM "images" WHERE "images"."type" IN ('PollImage') AND "images"."imageable_id" = 12 AND "images"."imageable_type" = 'Poll'
CACHE (0.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 136 AND "votes"."votable_type" = 'Image'
CACHE (0.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 135 AND "votes"."votable_type" = 'Image'
CACHE (0.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 134 AND "votes"."votable_type" = 'Image'
CACHE (0.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 136 AND "votes"."votable_type" = 'Image'
CACHE (0.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 135 AND "votes"."votable_type" = 'Image'
CACHE (0.0ms) SELECT COUNT(*) FROM "votes" WHERE "votes"."voter_id" = 10 AND "votes"."voter_type" = 'User' AND "votes"."votable_id" = 134 AND "votes"."votable_type" = 'Image'
CACHE (0.0ms) SELECT COUNT(*) FROM "images" WHERE "images"."type" IN ('PollImage') AND "images"."imageable_id" = 12 AND "images"."imageable_type" = 'Poll'
Poll Load (125.2ms) SELECT "polls".* FROM "polls" WHERE "polls"."id" = 12 ORDER BY created_at DESC LIMIT 1
PollImage Load (3.8ms) SELECT "images".* FROM "images" WHERE "images"."type" IN ('PollImage') AND "images"."imageable_id" = 12 AND "images"."imageable_type" = 'Poll' ORDER BY id DESC, cached_votes_up DESC LIMIT 1
CACHE (0.0ms) SELECT COUNT(*) FROM "images" WHERE "images"."type" IN ('PollImage') AND "images"."imageable_id" = 12 AND "images"."imageable_type" = 'Poll'
CACHE (0.0ms) SELECT "polls".* FROM "polls" WHERE "polls"."id" = 12 ORDER BY created_at DESC LIMIT 1
CACHE (0.0ms) SELECT "images".* FROM "images" WHERE "images"."type" IN ('PollImage') AND "images"."imageable_id" = 12 AND "images"."imageable_type" = 'Poll' ORDER BY id DESC, cached_votes_up DESC LIMIT 1
CACHE (0.0ms) SELECT COUNT(*) FROM "images" WHERE "images"."type" IN ('PollImage') AND "images"."imageable_id" = 12 AND "images"."imageable_type" = 'Poll'
CACHE (0.0ms) SELECT "polls".* FROM "polls" WHERE "polls"."id" = 12 ORDER BY created_at DESC LIMIT 1
CACHE (0.0ms) SELECT "images".* FROM "images" WHERE "images"."type" IN ('PollImage') AND "images"."imageable_id" = 12 AND "images"."imageable_type" = 'Poll' ORDER BY id DESC, cached_votes_up DESC LIMIT 1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment