gistfile1.sql

Started POST "/refinery/users/***" for 127.0.0.1 at 2011-02-09 10:46:54 +0300
  SQL (0.7ms)   SELECT name
 FROM sqlite_master
 WHERE type = 'table' AND NOT name = 'sqlite_sequence'
  SQL (0.2ms)   SELECT name
 FROM sqlite_master
 WHERE type = 'table' AND NOT name = 'sqlite_sequence'

  SQL (0.2ms)   SELECT name
 FROM sqlite_master
 WHERE type = 'table' AND NOT name = 'sqlite_sequence'
  Processing by Admin::UsersController#update as HTML
  Parameters: {"utf8"=>"✓", "authenticity_token"=>"3ZLOvRRDkG2U9wpSzwvm4D2ye2D+1dqKBGyKQH/M6+w=", "user"=>{"username"=>"****", "email"=>"", "password"=>"[FILTERED]", "password_confirmation"=>"[FILTERED]", "plugins"=>["refinery_inquiries", "refinery_images", "refinery_settings", "refinery_users", "refinery_dashboard", "refinery_pages", "refinery_files"]}, "id"=>"***", "locale"=>:en}
  SQL (0.1ms)  SELECT sluggable_id FROM slugs WHERE ((slugs.sluggable_type = 'User' AND slugs.name = '***' AND slugs.sequence = 1))
  User Load (0.5ms)  SELECT "users".* FROM "users" WHERE ("users"."id" = 1) LIMIT 1
  SQL (0.2ms)   SELECT name
 FROM sqlite_master
 WHERE type = 'table' AND NOT name = 'sqlite_sequence'

  Role Load (0.1ms)  SELECT "roles".* FROM "roles" WHERE ("roles"."title" = 'Refinery') LIMIT 1
  User Load (0.6ms)  SELECT * FROM "users" INNER JOIN "roles_users" ON "users".id = "roles_users".user_id WHERE ("roles_users".role_id = 1 )
  CACHE (0.0ms)  SELECT "users".* FROM "users" WHERE ("users"."id" = 1) LIMIT 1
  UserPlugin Load (0.3ms)  SELECT "user_plugins".* FROM "user_plugins" WHERE ("user_plugins".user_id = 1) ORDER BY position ASC
  Role Load (0.1ms)  SELECT "roles".* FROM "roles" WHERE ("roles"."title" = 'Superuser') LIMIT 1
  Role Load (0.2ms)  SELECT * FROM "roles" INNER JOIN "roles_users" ON "roles".id = "roles_users".role_id WHERE ("roles_users".user_id = 1 )
  Role Load (0.1ms)  SELECT "roles".* FROM "roles"
  CACHE (0.0ms)  SELECT "roles".* FROM "roles" WHERE ("roles"."title" = 'Superuser') LIMIT 1
  CACHE (0.0ms)  SELECT * FROM "roles" INNER JOIN "roles_users" ON "roles".id = "roles_users".role_id WHERE ("roles_users".user_id = 1 )
  CACHE (0.0ms)  SELECT "user_plugins".* FROM "user_plugins" WHERE ("user_plugins".user_id = 1) ORDER BY position ASC
  CACHE (0.0ms)  SELECT "roles".* FROM "roles" WHERE ("roles"."title" = 'Refinery') LIMIT 1
  CACHE (0.0ms)  SELECT "roles".* FROM "roles" WHERE ("roles"."title" = 'Superuser') LIMIT 1
  AREL (0.6ms)  DELETE FROM "user_plugins" WHERE ("user_plugins"."user_id" = 1)
  AREL (0.2ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_inquiries', 0)
  AREL (0.1ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_images', 1)
  AREL (0.1ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_settings', 2)
  AREL (0.1ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_users', 3)
  AREL (0.1ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_dashboard', 4)
  AREL (0.1ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_pages', 5)
  AREL (0.1ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_files', 6)
  User Load (0.1ms)  SELECT "users"."id" FROM "users" WHERE (LOWER("users"."email") = LOWER('****')) AND ("users".id <> 1) LIMIT 1
  User Load (0.1ms)  SELECT "users"."id" FROM "users" WHERE ("users"."username" = '***') AND ("users".id <> 1) LIMIT 1
  Slug Load (0.2ms)  SELECT "slugs".* FROM "slugs" WHERE ("slugs".sluggable_id = 1 AND "slugs".sluggable_type = 'User' AND ("slugs"."locale" = 'en')) ORDER BY id DESC LIMIT 1
Redirected to http://localhost:3000/refinery/users
  Role Load (0.1ms)  SELECT "roles".* FROM "roles" WHERE ("roles"."title" = 'Refinery') LIMIT 1
Completed 302 Found in 569ms
cache: [POST /refinery/users/***] invalidate, pass
cache: [POST /refinery/users/***] invalidate, pass


Started GET "/refinery/users" for 127.0.0.1 at 2011-02-09 10:46:55 +0300
  SQL (0.6ms)   SELECT name
 FROM sqlite_master
 WHERE type = 'table' AND NOT name = 'sqlite_sequence'
  SQL (0.3ms)   SELECT name
 FROM sqlite_master
 WHERE type = 'table' AND NOT name = 'sqlite_sequence'

  SQL (0.2ms)   SELECT name
 FROM sqlite_master
 WHERE type = 'table' AND NOT name = 'sqlite_sequence'
  Processing by Admin::UsersController#index as HTML
  Parameters: {"locale"=>:en}
  SQL (0.2ms)   SELECT name
 FROM sqlite_master
 WHERE type = 'table' AND NOT name = 'sqlite_sequence'

  Role Load (0.1ms)  SELECT "roles".* FROM "roles" WHERE ("roles"."title" = 'Refinery') LIMIT 1
  User Load (0.7ms)  SELECT * FROM "users" INNER JOIN "roles_users" ON "users".id = "roles_users".user_id WHERE ("roles_users".role_id = 1 )
  User Load (0.5ms)  SELECT "users".* FROM "users" WHERE ("users"."id" = 1) LIMIT 1
  UserPlugin Load (0.2ms)  SELECT "user_plugins".* FROM "user_plugins" WHERE ("user_plugins".user_id = 1) ORDER BY position ASC
  Role Load (0.1ms)  SELECT "roles".* FROM "roles" WHERE ("roles"."title" = 'Superuser') LIMIT 1
  Role Load (0.1ms)  SELECT * FROM "roles" INNER JOIN "roles_users" ON "roles".id = "roles_users".role_id WHERE ("roles_users".user_id = 1 )
  AREL (116.8ms)  DELETE FROM "user_plugins" WHERE ("user_plugins"."user_id" = 1)
  AREL (2.1ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_inquiries', 0)
  AREL (1.1ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_images', 1)
  AREL (0.7ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_settings', 2)
  AREL (15.2ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_users', 3)
  AREL (0.7ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_dashboard', 4)
  AREL (1.1ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_pages', 5)
  AREL (0.7ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_files', 6)
  AREL (0.7ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_core', 7)
  AREL (1.1ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_dialogs', 8)
  AREL (1.1ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinerycms_base', 9)
  AREL (9.3ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_i18n', 10)
  AREL (1.6ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinery_generators', 11)
  AREL (0.7ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'refinerycms_news', 12)
  AREL (1.1ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'portfolio', 13)
  AREL (0.7ms)  INSERT INTO "user_plugins" ("user_id", "name", "position") VALUES (1, 'page_images', 14)
  User Load (1.0ms)  SELECT "users".* FROM "users" ORDER BY username ASC LIMIT 30 OFFSET 0
  SQL (0.2ms)   SELECT name
 FROM sqlite_master
 WHERE type = 'table' AND NOT name = 'sqlite_sequence'

  Slug Load (0.3ms)  SELECT "slugs".* FROM "slugs" WHERE ("slugs".sluggable_id = 1 AND "slugs".sluggable_type = 'User') ORDER BY id DESC
  Role Load (0.1ms)  SELECT "roles".* FROM "roles" WHERE ("roles"."title" = 'Superuser') LIMIT 1
  Role Load (0.1ms)  SELECT * FROM "roles" INNER JOIN "roles_users" ON "roles".id = "roles_users".role_id WHERE ("roles_users".user_id = 1 )
Rendered /usr/local/lib/ruby/gems/1.9.1/gems/refinerycms-0.9.9/authentication/app/views/admin/users/_user.html.erb (8.1ms)
Rendered /usr/local/lib/ruby/gems/1.9.1/gems/refinerycms-0.9.9/authentication/app/views/admin/users/_users.html.erb (13.4ms)
Rendered /usr/local/lib/ruby/gems/1.9.1/gems/refinerycms-0.9.9/core/app/views/shared/_html_tag.html.erb (0.3ms)
Rendered /usr/local/lib/ruby/gems/1.9.1/gems/refinerycms-0.9.9/core/app/views/admin/_head.html.erb (3.7ms)
  Role Load (0.2ms)  SELECT "roles".* FROM "roles" WHERE ("roles"."title" = 'Refinery') LIMIT 1
Rendered /usr/local/lib/ruby/gems/1.9.1/gems/refinerycms-0.9.9/core/app/views/shared/_site_bar.html.erb (2.5ms)
Rendered /usr/local/lib/ruby/gems/1.9.1/gems/refinerycms-0.9.9/core/app/views/admin/_menu.html.erb (2.8ms)
Rendered /usr/local/lib/ruby/gems/1.9.1/gems/refinerycms-0.9.9/core/app/views/shared/_no_script.html.erb (0.6ms)
Rendered /usr/local/lib/ruby/gems/1.9.1/gems/refinerycms-0.9.9/core/app/views/shared/_message.html.erb (0.5ms)
Rendered /usr/local/lib/ruby/gems/1.9.1/gems/refinerycms-0.9.9/core/app/views/admin/_javascripts.html.erb (4.3ms)
Rendered /usr/local/lib/ruby/gems/1.9.1/gems/refinerycms-0.9.9/authentication/app/views/admin/users/index.html.erb within layouts/admin (133.3ms)
  CACHE (0.0ms)  SELECT "roles".* FROM "roles" WHERE ("roles"."title" = 'Refinery') LIMIT 1
Completed 200 OK in 4422ms (Views: 156.7ms | ActiveRecord: 164.9ms)
cache: [GET /refinery/users] miss
cache: [GET /refinery/users] miss