Skip to content

Instantly share code, notes, and snippets.

@jgrannas
Created August 9, 2013 17:39
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save jgrannas/6195528 to your computer and use it in GitHub Desktop.
Save jgrannas/6195528 to your computer and use it in GitHub Desktop.
Started GET "/styles?utf8=%E2%9C%93&t%5B%5D=engagement" for 127.0.0.1 at 2013-08-09 13:38:51 -0400
Processing by StylesController#index as JSON
Parameters: {"utf8"=>"✓", "t"=>["engagement"]}
User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
 (0.4ms) SELECT COUNT(*) FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 1 AND (((roles.name = 'admin') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL)))
Collection Load (0.3ms) SELECT "collections".* FROM "collections"
SQL (0.6ms) SELECT "styles"."id" AS t0_r0, "styles"."collection_id" AS t0_r1, "styles"."item_number" AS t0_r2, "styles"."name" AS t0_r3, "styles"."title" AS t0_r4, "styles"."description" AS t0_r5, "styles"."slug" AS t0_r6, "styles"."content" AS t0_r7, "styles"."created_at" AS t0_r8, "styles"."updated_at" AS t0_r9, "styles"."price" AS t0_r10, "styles"."data" AS t0_r11, "styles"."meta_title" AS t0_r12, "styles"."meta_desc" AS t0_r13, "styles"."active" AS t0_r14, "tags"."id" AS t1_r0, "tags"."name" AS t1_r1, "tags"."created_at" AS t1_r2, "tags"."updated_at" AS t1_r3, "tags"."tag_category_id" AS t1_r4 FROM "styles" LEFT OUTER JOIN "tagizations" ON "tagizations"."style_id" = "styles"."id" LEFT OUTER JOIN "tags" ON "tags"."id" = "tagizations"."tag_id" WHERE "tags"."name" = 'engagement' AND (styles.name != '')
Image Load (0.3ms) SELECT "images".* FROM "images" WHERE "images"."style_id" = 5
Image Load (0.3ms) SELECT "images".* FROM "images" WHERE "images"."style_id" = 8
Image Load (0.2ms) SELECT "images".* FROM "images" WHERE "images"."style_id" = 3
Image Load (0.2ms) SELECT "images".* FROM "images" WHERE "images"."style_id" = 10
Image Load (0.2ms) SELECT "images".* FROM "images" WHERE "images"."style_id" = 12
Image Load (0.3ms) SELECT "images".* FROM "images" WHERE "images"."style_id" = 14
Completed 200 OK in 89ms (Views: 44.2ms | ActiveRecord: 3.1ms)
Started GET "/styles?utf8=%E2%9C%93&t%5B%5D=engagement&t%5B%5D=Halo" for 127.0.0.1 at 2013-08-09 13:38:53 -0400
Processing by StylesController#index as JSON
Parameters: {"utf8"=>"✓", "t"=>["engagement", "Halo"]}
User Load (0.4ms) SELECT "users".* FROM "users" WHERE "users"."id" = 1 LIMIT 1
 (0.4ms) SELECT COUNT(*) FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 1 AND (((roles.name = 'admin') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL)))
Collection Load (0.3ms) SELECT "collections".* FROM "collections"
SQL (0.4ms) SELECT "styles"."id" AS t0_r0, "styles"."collection_id" AS t0_r1, "styles"."item_number" AS t0_r2, "styles"."name" AS t0_r3, "styles"."title" AS t0_r4, "styles"."description" AS t0_r5, "styles"."slug" AS t0_r6, "styles"."content" AS t0_r7, "styles"."created_at" AS t0_r8, "styles"."updated_at" AS t0_r9, "styles"."price" AS t0_r10, "styles"."data" AS t0_r11, "styles"."meta_title" AS t0_r12, "styles"."meta_desc" AS t0_r13, "styles"."active" AS t0_r14, "tags"."id" AS t1_r0, "tags"."name" AS t1_r1, "tags"."created_at" AS t1_r2, "tags"."updated_at" AS t1_r3, "tags"."tag_category_id" AS t1_r4 FROM "styles" LEFT OUTER JOIN "tagizations" ON "tagizations"."style_id" = "styles"."id" LEFT OUTER JOIN "tags" ON "tags"."id" = "tagizations"."tag_id" WHERE "tags"."name" = 'engagement' AND "tags"."name" = 'Halo' AND (styles.name != '')
Completed 200 OK in 23ms (Views: 0.1ms | ActiveRecord: 1.4ms)
@jgrannas
Copy link
Author

jgrannas commented Aug 9, 2013

The top log output is where I request one tag ["engagement"]

The lower log output is with two tags ["engagement", "Halo"] which yields no results

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment