Created
March 24, 2011 17:23
-
-
Save jonpaul/885466 to your computer and use it in GitHub Desktop.
Log file-
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Processing ApplicationController#index (for 127.0.0.1 at 2011-03-28 16:37:43) [GET] | |
| Rendering /Users/gamestreamer/Desktop/gamestreamer_mainrepo/gamestreamer/vendor/plugins/facebooker/templates/layout.erb (200) | |
| New Relic Agent not running | |
| ** [Hoptoad] Notifier 2.2.2 ready to catch errors | |
| SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 | |
| Genre Load (0.1ms) SELECT * FROM `genres` | |
| Genre Columns (0.9ms) SHOW FIELDS FROM `genres` | |
| Genre Load (0.1ms) SELECT * FROM `genres` | |
| Genre::Translation Load (0.3ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 2) | |
| Genre::Translation Columns (0.9ms) SHOW FIELDS FROM `genre_translations` | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 4) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 5) | |
| Genre::Translation Load (0.3ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 6) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 8) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 9) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 10) | |
| Genre::Translation Load (0.3ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 12) | |
| Genre::Translation Load (0.2ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 14) | |
| Genre::Translation Load (0.8ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 17) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 18) | |
| Genre::Translation Load (0.3ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 19) | |
| Genre::Translation Load (0.2ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 20) | |
| Genre::Translation Load (0.2ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 21) | |
| Genre::Translation Load (0.2ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 22) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 23) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 24) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 25) | |
| Genre::Translation Load (0.3ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 26) | |
| Genre::Translation Load (0.8ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 27) | |
| Genre::Translation Load (0.6ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 28) | |
| Genre::Translation Load (0.3ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 29) | |
| Genre::Translation Load (0.3ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 30) | |
| Genre::Translation Load (0.3ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 31) | |
| Genre::Translation Load (0.2ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 32) | |
| Genre::Translation Load (0.2ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 33) | |
| [RAILS] Rails loaded successfully! | |
| Partner Columns (2.3ms) SHOW FIELDS FROM `partners` | |
| SQL (1.7ms) SHOW TABLES | |
| User Columns (1.7ms) SHOW FIELDS FROM `users` | |
| SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 | |
| Partner Columns (2.3ms) SHOW FIELDS FROM `partners` | |
| SQL (1.7ms) SHOW TABLES | |
| User Columns (2.5ms) SHOW FIELDS FROM `users` | |
| Processing SessionsController#create (for 127.0.0.1 at 2011-03-28 16:38:44) [POST] | |
| Parameters: {"action"=>"create", "controller"=>"sessions", "user"=>{"password"=>"[FILTERED]", "email"=>"[FILTERED]"}} | |
| Store Load (0.2ms) SELECT * FROM `stores` WHERE ((host = 'mygamestore.gamestreamer.rails' or host = 'www.mygamestore.gamestreamer.rails' or address = 'mygamestore')) LIMIT 1 | |
| Store Columns (1.6ms) SHOW FIELDS FROM `stores` | |
| GsTemplate Load (0.1ms) SELECT * FROM `gs_templates` WHERE (action = 'create' AND controller = 'sessions' AND store_id = 25 AND theme = 'novo') LIMIT 1 | |
| Snippet Columns (1.0ms) SHOW FIELDS FROM `snippets` | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.2ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (1.2ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.3ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.3ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.5ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.2ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| User Load (0.1ms) SELECT * FROM `users` WHERE (`users`.`email` = 'jp@local.com') AND ((`users`.store_id = 25) AND (users.state = 'active')) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (users.store_id is null and lower(users.email) = 'jp@local.com') LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.`email` = 'jp@local.com') AND ((`users`.store_id = 25) AND (`users`.store_id = 25)) LIMIT 1 | |
| User Create (40.4ms) INSERT INTO `users` (`city`, `salt`, `interests`, `fav_movies`, `facebook_id`, `auth`, `dob`, `created_at`, `activated_at`, `zip`, `is_online`, `country`, `crypted_password`, `remember_token_expires_at`, `remember_token_api`, `hash_email`, `has_dlm`, `dlm_token`, `screenname`, `updated_at`, `deleted_at`, `password_reset_code`, `current_activity`, `fl_opt_in`, `account_id`, `activation_code`, `website_url`, `store_id`, `street`, `last_name`, `remember_token`, `fav_games`, `remember_token_api_expires_at`, `facebook_session_key`, `last_ping_time`, `partner_id`, `province`, `first_name`, `email`, `state`, `eula_accepted_at`) VALUES(NULL, '0f54f8242ee3fff8b860a297eb1e741b35912a8b', NULL, NULL, NULL, 0, NULL, '2011-03-24 16:16:00', '2011-03-24 16:16:20', NULL, NULL, NULL, '7a7b526dc605b9d6fc6e6938826cbe9ea8425dd9', NULL, NULL, NULL, 0, NULL, 'jpeasy', '2011-03-24 16:16:21', NULL, NULL, NULL, 1, NULL, NULL, NULL, 25, NULL, 'Ptest', NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'Jtest', 'jp@local.com', 'pending', NULL) | |
| Audit Columns (27.9ms) SHOW FIELDS FROM `versions` | |
| SQL (4.6ms) SELECT max(`number`) AS max_number FROM `versions` WHERE (`versions`.versioned_id = 676 AND `versions`.versioned_type = 'User') | |
| SQL (0.1ms) BEGIN | |
| Audit Create (0.3ms) INSERT INTO `versions` (`number`, `created_at`, `updated_at`, `versioned_type`, `tag`, `versioned_id`, `user_type`, `item_name`, `user_id`, `user_name`, `changes`, `ip`, `site`, `user_email`, `activity_type`) VALUES(1, '2011-03-28 20:38:46', '2011-03-28 20:38:46', 'User', NULL, 676, NULL, NULL, NULL, NULL, '--- {}\n\n', NULL, NULL, NULL, NULL) | |
| SQL (0.7ms) COMMIT | |
| Audit Load (0.4ms) SELECT * FROM `versions` WHERE (`versions`.versioned_id = 676 AND `versions`.versioned_type = 'User') ORDER BY versions.`number` ASC | |
| SQL (0.1ms) BEGIN | |
| Audit Update (0.3ms) UPDATE `versions` SET `changes` = '--- {}\n\n' WHERE `id` = 127 | |
| SQL (0.7ms) COMMIT | |
| User Load (1.7ms) SELECT * FROM `users` WHERE (users.store_id is null and lower(users.email) = 'jp@local.com') LIMIT 1 | |
| SQL (0.4ms) SELECT count(*) AS count_all FROM `users` WHERE ((`users`.store_id = 25) AND ((users.auth >= 4 or users.partner_id is not null) and users.store_id is null and lower(users.email) = 'jp@local.com')) | |
| Store Load (0.7ms) SELECT * FROM `stores` | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 1) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 1))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 2) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 2))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 3) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 3))) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 4) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 4))) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 5) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 5))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 6) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 6))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 7) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 7))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 9) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 9))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 10) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 10))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 11) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 11))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 12) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 12))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 13) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 13))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 15) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 15))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 16) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 16))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 17) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 17))) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 18) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 18))) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 20) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 20))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 21) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 21))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 22) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 22))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 23) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 23))) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 25) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 25))) LIMIT 1 | |
| User Update (1.2ms) UPDATE `users` SET `updated_at` = '2011-03-28 20:38:46', `activation_code` = '1453a50e0a3dff875f72954fb421fd33d75a797f', `fl_opt_in` = 1 WHERE `id` = 675 | |
| SQL (0.3ms) SELECT max(`number`) AS max_number FROM `versions` WHERE (`versions`.versioned_id = 675 AND `versions`.versioned_type = 'User') | |
| SQL (0.1ms) BEGIN | |
| Audit Create (0.3ms) INSERT INTO `versions` (`number`, `created_at`, `updated_at`, `versioned_type`, `tag`, `versioned_id`, `user_type`, `item_name`, `user_id`, `user_name`, `changes`, `ip`, `site`, `user_email`, `activity_type`) VALUES(5, '2011-03-28 20:38:46', '2011-03-28 20:38:46', 'User', NULL, 675, NULL, NULL, NULL, NULL, '--- \nfl_opt_in: \n- false\n- true\nactivation_code: \n- \n- 1453a50e0a3dff875f72954fb421fd33d75a797f\n', NULL, NULL, NULL, NULL) | |
| SQL (0.7ms) COMMIT | |
| Store Load (0.4ms) SELECT * FROM `stores` WHERE (`stores`.`id` = 25) | |
| UserImage Load (0.3ms) SELECT * FROM `user_images` WHERE (`user_images`.user_id = 675 AND (user_images.state = 'active')) LIMIT 1 | |
| ShoppingCart Load (0.4ms) SELECT * FROM `shopping_carts` WHERE (`shopping_carts`.user_id = 676) LIMIT 1 | |
| ShoppingCart Columns (0.9ms) SHOW FIELDS FROM `shopping_carts` | |
| ShoppingCart Load (0.1ms) SELECT * FROM `shopping_carts` WHERE (`shopping_carts`.`id` IS NULL) LIMIT 1 | |
| SQL (0.1ms) BEGIN | |
| ShoppingCart Create (0.6ms) INSERT INTO `shopping_carts` (`created_at`, `updated_at`, `user_id`, `coupon_code`, `currency_code`) VALUES('2011-03-28 20:38:46', '2011-03-28 20:38:46', 676, NULL, 'usd') | |
| SQL (1.2ms) COMMIT | |
| SQL (0.1ms) BEGIN | |
| SQL (1.0ms) SELECT count(*) AS count_all FROM `users` WHERE ((users.auth >= 4 or users.partner_id is not null) and users.store_id is null and lower(users.email) = 'jp@local.com') | |
| Store Load (1.2ms) SELECT * FROM `stores` | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 1) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 1)) LIMIT 1 | |
| User Load (1.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 2) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 2)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 3) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 3)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 4) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 4)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 5) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 5)) LIMIT 1 | |
| User Load (0.9ms) SELECT * FROM `users` WHERE (`users`.store_id = 6) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 6)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 7) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 7)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 9) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 9)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 10) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 10)) LIMIT 1 | |
| User Load (1.2ms) SELECT * FROM `users` WHERE (`users`.store_id = 11) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 11)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 12) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 12)) LIMIT 1 | |
| User Load (0.8ms) SELECT * FROM `users` WHERE (`users`.store_id = 13) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 13)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 15) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 15)) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 16) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 16)) LIMIT 1 | |
| User Load (0.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 17) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 17)) LIMIT 1 | |
| User Load (39.2ms) SELECT * FROM `users` WHERE (`users`.store_id = 18) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 18)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 20) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 20)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 21) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 21)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 22) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 22)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 23) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 23)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 25) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 25)) LIMIT 1 | |
| User Update (0.5ms) UPDATE `users` SET `updated_at` = '2011-03-28 20:38:47', `activation_code` = 'b4987f372ae44874b6ec2721cae4d5913622fdd9', `fl_opt_in` = 1 WHERE `id` = 675 | |
| SQL (0.3ms) SELECT max(`number`) AS max_number FROM `versions` WHERE (`versions`.versioned_id = 675 AND `versions`.versioned_type = 'User') | |
| Audit Create (0.3ms) INSERT INTO `versions` (`number`, `created_at`, `updated_at`, `versioned_type`, `tag`, `versioned_id`, `user_type`, `item_name`, `user_id`, `user_name`, `changes`, `ip`, `site`, `user_email`, `activity_type`) VALUES(6, '2011-03-28 20:38:47', '2011-03-28 20:38:47', 'User', NULL, 675, NULL, NULL, NULL, NULL, '--- \nfl_opt_in: \n- false\n- true\nactivation_code: \n- \n- b4987f372ae44874b6ec2721cae4d5913622fdd9\n', NULL, NULL, NULL, NULL) | |
| Store Load (0.4ms) SELECT * FROM `stores` | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 1) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 1)) LIMIT 1 | |
| User Load (1.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 2) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 2)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 3) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 3)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 4) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 4)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 5) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 5)) LIMIT 1 | |
| User Load (1.0ms) SELECT * FROM `users` WHERE (`users`.store_id = 6) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 6)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 7) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 7)) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 9) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 9)) LIMIT 1 | |
| User Load (1.1ms) SELECT * FROM `users` WHERE (`users`.store_id = 10) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 10)) LIMIT 1 | |
| User Load (1.1ms) SELECT * FROM `users` WHERE (`users`.store_id = 11) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 11)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 12) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 12)) LIMIT 1 | |
| User Load (0.9ms) SELECT * FROM `users` WHERE (`users`.store_id = 13) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 13)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 15) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 15)) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 16) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 16)) LIMIT 1 | |
| User Load (0.8ms) SELECT * FROM `users` WHERE (`users`.store_id = 17) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 17)) LIMIT 1 | |
| User Load (1.8ms) SELECT * FROM `users` WHERE (`users`.store_id = 18) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 18)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 20) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 20)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 21) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 21)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 22) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 22)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 23) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 23)) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 25) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 25)) LIMIT 1 | |
| User Update (0.3ms) UPDATE `users` SET `updated_at` = '2011-03-28 20:38:47', `activated_at` = '2011-03-24 16:16:20', `crypted_password` = '7a7b526dc605b9d6fc6e6938826cbe9ea8425dd9', `salt` = '0f54f8242ee3fff8b860a297eb1e741b35912a8b', `screenname` = 'jpeasy', `created_at` = '2011-03-24 16:16:00', `last_name` = 'Ptest', `first_name` = 'Jtest', `fl_opt_in` = 1, `store_id` = 25, `email` = 'jp@local.com', `state` = 'pending' WHERE `id` = 676 | |
| SQL (0.7ms) SELECT max(`number`) AS max_number FROM `versions` WHERE (`versions`.versioned_id = 676 AND `versions`.versioned_type = 'User') | |
| Audit Create (12.1ms) INSERT INTO `versions` (`number`, `created_at`, `updated_at`, `versioned_type`, `tag`, `versioned_id`, `user_type`, `item_name`, `user_id`, `user_name`, `changes`, `ip`, `site`, `user_email`, `activity_type`) VALUES(2, '2011-03-28 20:38:47', '2011-03-28 20:38:47', 'User', NULL, 676, NULL, NULL, NULL, NULL, '--- \nsalt: \n- \n- 0f54f8242ee3fff8b860a297eb1e741b35912a8b\nactivated_at: \n- \n- 2011-03-24 16:16:20 Z\ncrypted_password: \n- \n- 7a7b526dc605b9d6fc6e6938826cbe9ea8425dd9\nscreenname: \n- \n- jpeasy\nfl_opt_in: \n- false\n- true\nid: \n- \n- 676\nstore_id: \n- \n- 25\nlast_name: \n- \"\"\n- Ptest\nfirst_name: \n- \"\"\n- Jtest\nstate: \n- passive\n- pending\nemail: \n- \n- jp@local.com\n', NULL, NULL, NULL, NULL) | |
| SQL (1.3ms) COMMIT | |
| Redirected to http://mygamestore.gamestreamer.rails/account | |
| SQL (0.2ms) BEGIN | |
| Store Update (0.3ms) UPDATE `stores` SET `updated_at` = '2011-03-28 20:38:47' WHERE `id` = 25 | |
| SQL (0.7ms) COMMIT | |
| Completed in 3024ms (DB: 192) | 302 Found [http://mygamestore.gamestreamer.rails/session] | |
| SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 | |
| Partner Columns (2.1ms) SHOW FIELDS FROM `partners` | |
| SQL (1.7ms) SHOW TABLES | |
| User Columns (2.1ms) SHOW FIELDS FROM `users` | |
| Processing AccountController#show (for 127.0.0.1 at 2011-03-28 16:38:49) [GET] | |
| Parameters: {"action"=>"show", "controller"=>"account"} | |
| User Load (7.1ms) SELECT * FROM `users` WHERE (`users`.`remember_token` = '') LIMIT 1 | |
| Store Load (0.6ms) SELECT * FROM `stores` WHERE ((host = 'mygamestore.gamestreamer.rails' or host = 'www.mygamestore.gamestreamer.rails' or address = 'mygamestore')) LIMIT 1 | |
| Store Columns (1.6ms) SHOW FIELDS FROM `stores` | |
| GsTemplate Load (0.1ms) SELECT * FROM `gs_templates` WHERE (action = 'show' AND controller = 'account' AND store_id = 25 AND theme = 'novo') LIMIT 1 | |
| Snippet Columns (1.1ms) SHOW FIELDS FROM `snippets` | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.3ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.2ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.3ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.`id` = 676) LIMIT 1 | |
| Store Load (0.3ms) SELECT * FROM `stores` WHERE (`stores`.`id` = 25) | |
| SQL (0.5ms) BEGIN | |
| Store Load (0.8ms) SELECT * FROM `stores` | |
| User Load (0.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 1) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 1)) LIMIT 1 | |
| User Load (1.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 2) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 2)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 3) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 3)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 4) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 4)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 5) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 5)) LIMIT 1 | |
| User Load (0.9ms) SELECT * FROM `users` WHERE (`users`.store_id = 6) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 6)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 7) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 7)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 9) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 9)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 10) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 10)) LIMIT 1 | |
| User Load (1.0ms) SELECT * FROM `users` WHERE (`users`.store_id = 11) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 11)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 12) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 12)) LIMIT 1 | |
| User Load (1.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 13) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 13)) LIMIT 1 | |
| User Load (0.8ms) SELECT * FROM `users` WHERE (`users`.store_id = 15) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 15)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 16) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 16)) LIMIT 1 | |
| User Load (0.8ms) SELECT * FROM `users` WHERE (`users`.store_id = 17) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 17)) LIMIT 1 | |
| User Load (1.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 18) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 18)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 20) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 20)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 21) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 21)) LIMIT 1 | |
| User Load (0.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 22) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 22)) LIMIT 1 | |
| User Load (1.1ms) SELECT * FROM `users` WHERE (`users`.store_id = 23) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 23)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 25) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 25)) LIMIT 1 | |
| User Update (0.5ms) UPDATE `users` SET `updated_at` = '2011-03-28 20:38:51', `dlm_token` = '9d38606ec0fb3ad96c8f6cecdcd0f8ae3ec2e480' WHERE `id` = 676 | |
| SQL (1.2ms) COMMIT | |
| SQL (1.8ms) SHOW TABLES | |
| SQL (1.9ms) SHOW TABLES | |
| Genre Columns (1.2ms) SHOW FIELDS FROM `genres` | |
| Genre Load (0.3ms) SELECT `genres`.* FROM `genres` INNER JOIN `genres_stores` ON `genres`.id = `genres_stores`.genre_id WHERE (`genres`.`address` IS NULL) AND (`genres_stores`.store_id = 25 ) LIMIT 1 | |
| Genre Load (0.1ms) SELECT `genres`.id FROM `genres` INNER JOIN `genres_stores` ON `genres`.id = `genres_stores`.genre_id WHERE (`genres_stores`.store_id = 25 ) | |
| Genre Load (0.2ms) SELECT * FROM `genres` | |
| Partner Load (0.3ms) SELECT `partners`.id FROM `partners` INNER JOIN `partners_stores` ON `partners`.id = `partners_stores`.partner_id WHERE (`partners_stores`.store_id = 25 ) ORDER BY partners.company_name | |
| Sunspot::NoAdapterError (No adapter is configured for Fixnum or its superclasses. See the documentation for Sunspot::Adapters): | |
| sunspot (1.2.1) lib/sunspot/adapters.rb:126:in `for' | |
| sunspot (1.2.1) lib/sunspot/adapters.rb:82:in `adapt' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:210:in `add_restriction' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:209:in `map' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:209:in `add_restriction' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:81:in `with' | |
| app/models/products/searchable.rb:197:in `facets_from_options' | |
| sunspot (1.2.1) lib/sunspot/util.rb:84:in `call' | |
| sunspot (1.2.1) lib/sunspot/util.rb:84:in `instance_eval_or_call' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:162:in `dynamic' | |
| sunspot (1.2.1) lib/sunspot/util.rb:232:in `__send__' | |
| sunspot (1.2.1) lib/sunspot/util.rb:232:in `method_missing' | |
| app/models/products/searchable.rb:197:in `facets_from_options' | |
| sunspot (1.2.1) lib/sunspot/util.rb:208:in `instance_eval' | |
| sunspot (1.2.1) lib/sunspot/util.rb:208:in `instance_eval_with_context' | |
| sunspot (1.2.1) lib/sunspot/util.rb:86:in `instance_eval_or_call' | |
| sunspot (1.2.1) lib/sunspot/dsl/query_facet.rb:31:in `row' | |
| sunspot (1.2.1) lib/sunspot/util.rb:232:in `__send__' | |
| sunspot (1.2.1) lib/sunspot/util.rb:232:in `method_missing' | |
| app/models/products/searchable.rb:197:in `facets_from_options' | |
| sunspot (1.2.1) lib/sunspot/util.rb:208:in `instance_eval' | |
| sunspot (1.2.1) lib/sunspot/util.rb:208:in `instance_eval_with_context' | |
| sunspot (1.2.1) lib/sunspot/util.rb:86:in `instance_eval_or_call' | |
| sunspot (1.2.1) lib/sunspot/dsl/field_query.rb:186:in `facet' | |
| app/models/products/searchable.rb:196:in `facets_from_options' | |
| app/models/products/searchable.rb:383:in `search_with_options' | |
| sunspot (1.2.1) lib/sunspot/util.rb:84:in `call' | |
| sunspot (1.2.1) lib/sunspot/util.rb:84:in `instance_eval_or_call' | |
| sunspot (1.2.1) lib/sunspot/search/abstract_search.rb:207:in `build' | |
| sunspot (1.2.1) lib/sunspot/session.rb:50:in `new_search' | |
| sunspot (1.2.1) lib/sunspot/session_proxy/abstract_session_proxy.rb:11:in `new_search' | |
| sunspot (1.2.1) lib/sunspot.rb:261:in `new_search' | |
| /Users/gamestreamer/.rvm/gems/ruby-1.8.7-p334@gsi-gemset/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:140:in `search' | |
| /Users/gamestreamer/.rvm/gems/ruby-1.8.7-p334@gsi-gemset/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:295:in `solr_execute_search' | |
| /Users/gamestreamer/.rvm/gems/ruby-1.8.7-p334@gsi-gemset/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:139:in `search' | |
| app/models/products/searchable.rb:371:in `search_with_options' | |
| sites/gamestore/app/controllers/game_store_controller.rb:58:in `product_search' | |
| sites/gamestore/app/controllers/account_controller.rb:260:in `new_products' | |
| sites/gamestore/app/controllers/account_controller.rb:76:in `show' | |
| lib/memcached_system.rb:9:in `cache' | |
| haml (3.0.25) rails/./lib/sass/plugin/rack.rb:41:in `call' | |
| vendor/gems/hoptoad_notifier-2.2.2/lib/hoptoad_notifier/rack.rb:27:in `call' | |
| passenger (3.0.5) lib/phusion_passenger/rack/request_handler.rb:96:in `process_request' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_request_handler.rb:513:in `accept_and_process_next_request' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:321:in `start_request_handler' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `send' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `handle_spawn_application' | |
| passenger (3.0.5) lib/phusion_passenger/utils.rb:479:in `safe_fork' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:270:in `handle_spawn_application' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:357:in `__send__' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:180:in `start' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:149:in `start' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:219:in `spawn_rails_application' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:214:in `spawn_rails_application' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server_collection.rb:82:in `synchronize' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:213:in `spawn_rails_application' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:132:in `spawn_application' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:357:in `__send__' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' | |
| passenger (3.0.5) helper-scripts/passenger-spawn-server:99 | |
| Rendered rescues/_trace (110.1ms) | |
| Rendered rescues/_request_and_response (0.7ms) | |
| Rendering /Users/gamestreamer/Desktop/gamestreamer_mainrepo/gamestreamer/vendor/plugins/facebooker/templates/layout.erb (200) | |
| SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 | |
| Partner Columns (2.1ms) SHOW FIELDS FROM `partners` | |
| SQL (1.7ms) SHOW TABLES | |
| User Columns (1.7ms) SHOW FIELDS FROM `users` | |
| Processing ApplicationController#index (for 127.0.0.1 at 2011-03-28 16:38:54) [GET] | |
| Rendering /Users/gamestreamer/Desktop/gamestreamer_mainrepo/gamestreamer/vendor/plugins/facebooker/templates/layout.erb (200) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Processing CatalogController#show (for 127.0.0.1 at 2011-03-24 13:21:54) [GET] | |
| Parameters: {"action"=>"show", "page"=>"home", "controller"=>"catalog"} | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.`remember_token` = '') LIMIT 1 | |
| Store Load (0.2ms) SELECT * FROM `stores` WHERE ((host = 'mygamestore.gamestreamer.rails' or host = 'www.mygamestore.gamestreamer.rails' or address = 'mygamestore')) LIMIT 1 | |
| Store Columns (1.7ms) SHOW FIELDS FROM `stores` | |
| GsTemplate Load (0.3ms) SELECT * FROM `gs_templates` WHERE (action = 'show' AND controller = 'catalog' AND store_id = 25 AND theme = 'novo') LIMIT 1 | |
| Snippet Columns (1.1ms) SHOW FIELDS FROM `snippets` | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Catalog' AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Catalog' AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Catalog' AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Catalog' AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Catalog' AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Catalog' AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Catalog' AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Catalog' AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Catalog' AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| User Load (0.1ms) SELECT * FROM `users` WHERE (`users`.`id` = 675) LIMIT 1 | |
| SQL (1.7ms) SHOW TABLES | |
| SQL (5.2ms) SHOW TABLES | |
| Product Columns (1.4ms) SHOW FIELDS FROM `products` | |
| SQL (0.4ms) SELECT count(*) AS count_all FROM `products` INNER JOIN `distributions` ON distributions.product_id = products.id INNER JOIN showcasings ON ( products.id = showcasings.product_id ) WHERE (((((`showcasings`.`page` = 'home' AND `distributions`.`country` = 'us')) AND ((products.released_at IS NULL and products.available_at IS NULL) OR products.released_at <= '2011-03-24 17:21:55' OR (products.available_at IS NOT NULL AND products.available_at <= '2011-03-24 17:21:55'))) AND (showcasings.store_id = 25 )) AND (showcasings.store_id = 25 )) | |
| Product Load (0.0ms) Mysql::Error: Unknown column 'showcasings.page' in 'where clause': SELECT `products`.* FROM `products` INNER JOIN `distributions` ON distributions.product_id = products.id INNER JOIN listings ON ( products.id = listings.product_id ) WHERE (((((`showcasings`.`page` = 'catalog' AND `distributions`.`country` = 'us')) AND ((products.released_at IS NULL and products.available_at IS NULL) OR products.released_at <= '2011-03-24 17:21:55' OR (products.available_at IS NOT NULL AND products.available_at <= '2011-03-24 17:21:55'))) AND (listings.store_id = 25 AND `listings`.`active` = 1)) AND (listings.store_id = 25 AND `listings`.`active` = 1)) ORDER BY products.released_at desc LIMIT 8 | |
| Product Load (1.3ms) SELECT `products`.* FROM `products` INNER JOIN `distributions` ON distributions.product_id = products.id INNER JOIN listings ON ( products.id = listings.product_id ) WHERE ((((`distributions`.`country` = 'us') AND ((products.released_at IS NULL and products.available_at IS NULL) OR products.released_at <= '2011-03-24 17:21:55' OR (products.available_at IS NOT NULL AND products.available_at <= '2011-03-24 17:21:55'))) AND (listings.store_id = 25 AND `listings`.`active` = 1)) AND (listings.store_id = 25 AND `listings`.`active` = 1)) ORDER BY products.released_at desc LIMIT 8 | |
| Genre Columns (1.4ms) SHOW FIELDS FROM `genres` | |
| Genre Load (0.4ms) SELECT * FROM `genres` WHERE (`genres`.`address` IS NULL) LIMIT 1 | |
| Genre Load (0.1ms) SELECT `genres`.* FROM `genres` INNER JOIN `genres_stores` ON `genres`.id = `genres_stores`.genre_id WHERE (`genres`.`address` IS NULL) AND (`genres_stores`.store_id = 25 ) LIMIT 1 | |
| CACHE (0.0ms) SELECT `genres`.* FROM `genres` INNER JOIN `genres_stores` ON `genres`.id = `genres_stores`.genre_id WHERE (`genres`.`address` IS NULL) AND (`genres_stores`.store_id = 25 ) LIMIT 1 | |
| Genre Load (0.1ms) SELECT `genres`.id FROM `genres` INNER JOIN `genres_stores` ON `genres`.id = `genres_stores`.genre_id WHERE (`genres_stores`.store_id = 25 ) | |
| Genre Load (0.1ms) SELECT * FROM `genres` | |
| Partner Load (0.1ms) SELECT `partners`.id FROM `partners` INNER JOIN `partners_stores` ON `partners`.id = `partners_stores`.partner_id WHERE (`partners_stores`.store_id = 25 ) ORDER BY partners.company_name | |
| Sunspot::NoAdapterError (No adapter is configured for Fixnum or its superclasses. See the documentation for Sunspot::Adapters): | |
| sunspot (1.2.1) lib/sunspot/adapters.rb:126:in `for' | |
| sunspot (1.2.1) lib/sunspot/adapters.rb:82:in `adapt' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:210:in `add_restriction' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:209:in `map' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:209:in `add_restriction' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:81:in `with' | |
| app/models/products/searchable.rb:197:in `facets_from_options' | |
| sunspot (1.2.1) lib/sunspot/util.rb:84:in `call' | |
| sunspot (1.2.1) lib/sunspot/util.rb:84:in `instance_eval_or_call' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:162:in `dynamic' | |
| sunspot (1.2.1) lib/sunspot/util.rb:232:in `__send__' | |
| sunspot (1.2.1) lib/sunspot/util.rb:232:in `method_missing' | |
| app/models/products/searchable.rb:197:in `facets_from_options' | |
| sunspot (1.2.1) lib/sunspot/util.rb:208:in `instance_eval' | |
| sunspot (1.2.1) lib/sunspot/util.rb:208:in `instance_eval_with_context' | |
| sunspot (1.2.1) lib/sunspot/util.rb:86:in `instance_eval_or_call' | |
| sunspot (1.2.1) lib/sunspot/dsl/query_facet.rb:31:in `row' | |
| sunspot (1.2.1) lib/sunspot/util.rb:232:in `__send__' | |
| sunspot (1.2.1) lib/sunspot/util.rb:232:in `method_missing' | |
| app/models/products/searchable.rb:197:in `facets_from_options' | |
| sunspot (1.2.1) lib/sunspot/util.rb:208:in `instance_eval' | |
| sunspot (1.2.1) lib/sunspot/util.rb:208:in `instance_eval_with_context' | |
| sunspot (1.2.1) lib/sunspot/util.rb:86:in `instance_eval_or_call' | |
| sunspot (1.2.1) lib/sunspot/dsl/field_query.rb:186:in `facet' | |
| app/models/products/searchable.rb:196:in `facets_from_options' | |
| app/models/products/searchable.rb:383:in `search_with_options' | |
| sunspot (1.2.1) lib/sunspot/util.rb:84:in `call' | |
| sunspot (1.2.1) lib/sunspot/util.rb:84:in `instance_eval_or_call' | |
| sunspot (1.2.1) lib/sunspot/search/abstract_search.rb:207:in `build' | |
| sunspot (1.2.1) lib/sunspot/session.rb:50:in `new_search' | |
| sunspot (1.2.1) lib/sunspot/session_proxy/abstract_session_proxy.rb:11:in `new_search' | |
| sunspot (1.2.1) lib/sunspot.rb:261:in `new_search' | |
| /Users/gamestreamer/.rvm/gems/ruby-1.8.7-p334@gsi-gemset/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:140:in `search' | |
| /Users/gamestreamer/.rvm/gems/ruby-1.8.7-p334@gsi-gemset/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:295:in `solr_execute_search' | |
| /Users/gamestreamer/.rvm/gems/ruby-1.8.7-p334@gsi-gemset/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:139:in `search' | |
| app/models/products/searchable.rb:371:in `search_with_options' | |
| sites/gamestore/app/controllers/game_store_controller.rb:58:in `product_search' | |
| sites/gamestore/app/controllers/catalog_controller.rb:440:in `featured_products' | |
| sites/gamestore/app/controllers/catalog_controller.rb:14:in `show' | |
| lib/memcached_system.rb:9:in `cache' | |
| haml (3.0.25) rails/./lib/sass/plugin/rack.rb:41:in `call' | |
| vendor/gems/hoptoad_notifier-2.2.2/lib/hoptoad_notifier/rack.rb:27:in `call' | |
| passenger (3.0.5) lib/phusion_passenger/rack/request_handler.rb:96:in `process_request' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_request_handler.rb:513:in `accept_and_process_next_request' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:321:in `start_request_handler' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `send' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `handle_spawn_application' | |
| passenger (3.0.5) lib/phusion_passenger/utils.rb:479:in `safe_fork' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:270:in `handle_spawn_application' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:357:in `__send__' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:180:in `start' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:149:in `start' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:219:in `spawn_rails_application' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:214:in `spawn_rails_application' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server_collection.rb:82:in `synchronize' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:213:in `spawn_rails_application' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:132:in `spawn_application' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:357:in `__send__' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' | |
| passenger (3.0.5) helper-scripts/passenger-spawn-server:99 | |
| Rendered rescues/_trace (96.5ms) | |
| Rendered rescues/_request_and_response (1.9ms) | |
| Rendering /Users/gamestreamer/Desktop/gamestreamer_mainrepo/gamestreamer/vendor/plugins/facebooker/templates/layout.erb (200) | |
| SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 | |
| Partner Columns (2.3ms) SHOW FIELDS FROM `partners` | |
| SQL (1.8ms) SHOW TABLES | |
| User Columns (1.7ms) SHOW FIELDS FROM `users` | |
| Processing ApplicationController#index (for 127.0.0.1 at 2011-03-24 13:21:57) [GET] | |
| Rendering /Users/gamestreamer/Desktop/gamestreamer_mainrepo/gamestreamer/vendor/plugins/facebooker/templates/layout.erb (200) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Processing ApplicationController#index (for 127.0.0.1 at 2011-03-28 16:46:24) [GET] | |
| Rendering /Users/gamestreamer/Desktop/gamestreamer_mainrepo/gamestreamer/vendor/plugins/facebooker/templates/layout.erb (200) | |
| SQL (0.6ms) SET SQL_AUTO_IS_NULL=0 | |
| Partner Columns (2.6ms) SHOW FIELDS FROM `partners` | |
| SQL (1.7ms) SHOW TABLES | |
| User Columns (1.8ms) SHOW FIELDS FROM `users` | |
| Processing SessionsController#new (for 127.0.0.1 at 2011-03-28 16:46:39) [GET] | |
| Parameters: {"action"=>"new", "controller"=>"sessions"} | |
| User Load (0.2ms) SELECT * FROM `users` WHERE (`users`.`remember_token` = '') LIMIT 1 | |
| Store Load (0.1ms) SELECT * FROM `stores` WHERE ((host = 'mygamestore.gamestreamer.rails' or host = 'www.mygamestore.gamestreamer.rails' or address = 'mygamestore')) LIMIT 1 | |
| Store Columns (2.2ms) SHOW FIELDS FROM `stores` | |
| GsTemplate Load (0.1ms) SELECT * FROM `gs_templates` WHERE (action = 'new' AND controller = 'sessions' AND store_id = 25 AND theme = 'novo') LIMIT 1 | |
| Snippet Columns (1.1ms) SHOW FIELDS FROM `snippets` | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (1.9ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.3ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| User Load (1.7ms) SELECT * FROM `users` WHERE (`users`.`id` = 676) LIMIT 1 | |
| ShoppingCart Columns (5.8ms) SHOW FIELDS FROM `shopping_carts` | |
| ShoppingCart Load (0.1ms) SELECT * FROM `shopping_carts` WHERE (`shopping_carts`.`id` IS NULL) LIMIT 1 | |
| Order Columns (1.4ms) SHOW FIELDS FROM `orders` | |
| SQL (0.1ms) BEGIN | |
| SQL (0.1ms) COMMIT | |
| User Load (0.1ms) SELECT `users`.* FROM `users` inner join user_images on user_images.user_id = users.id and user_images.parent_id is null WHERE (user_images.state = 'active') AND (`users`.store_id = 25) ORDER BY users.created_at DESC LIMIT 10 | |
| Rendering template within layouts/gamestore | |
| Rendering sessions/new | |
| Rendered shopping_cart/_step_indicator (6.6ms) | |
| Rendered sessions/_form (36.1ms) | |
| Rendered catalog/_head (24.3ms) | |
| Rendered catalog/_utilities (14.1ms) | |
| CartItem Columns (1.1ms) SHOW FIELDS FROM `cart_items` | |
| SQL (0.1ms) SELECT count(*) AS count_all FROM `cart_items` WHERE (`cart_items`.shopping_cart_id = NULL) | |
| CACHE (0.0ms) SELECT count(*) AS count_all FROM `cart_items` WHERE (`cart_items`.shopping_cart_id = NULL) | |
| Rendered catalog/_cart (7.5ms) | |
| Genre Load (0.1ms) SELECT * FROM `genres` WHERE (genres.address IN ('action','strategy','sports','children','role-playing','indie','guides','adventure','puzzle','casual')) ORDER BY address | |
| Genre Columns (1.2ms) SHOW FIELDS FROM `genres` | |
| Genre::Translation Load (0.2ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 5) | |
| Genre::Translation Columns (1.1ms) SHOW FIELDS FROM `genre_translations` | |
| Genre::Translation Load (0.3ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 9) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 18) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 24) | |
| Genre::Translation Load (0.5ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 25) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 4) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 23) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 10) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 8) | |
| Rendered catalog/_header (636.0ms) | |
| Rendered catalog/_footer (22.3ms) | |
| Completed in 2766ms (View: 824, DB: 29) | 200 OK [http://mygamestore.gamestreamer.rails/login] | |
| SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 | |
| Partner Columns (2.0ms) SHOW FIELDS FROM `partners` | |
| SQL (1.8ms) SHOW TABLES | |
| User Columns (2.0ms) SHOW FIELDS FROM `users` | |
| Processing ApplicationController#index (for 127.0.0.1 at 2011-03-28 16:46:45) [GET] | |
| Rendering /Users/gamestreamer/Desktop/gamestreamer_mainrepo/gamestreamer/vendor/plugins/facebooker/templates/layout.erb (200) | |
| SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 | |
| Partner Columns (10.2ms) SHOW FIELDS FROM `partners` | |
| SQL (1.7ms) SHOW TABLES | |
| User Columns (1.8ms) SHOW FIELDS FROM `users` | |
| Processing SessionsController#new (for 127.0.0.1 at 2011-03-28 16:46:48) [GET] | |
| Parameters: {"action"=>"new", "controller"=>"sessions"} | |
| User Load (0.2ms) SELECT * FROM `users` WHERE (`users`.`remember_token` = '') LIMIT 1 | |
| Store Load (0.1ms) SELECT * FROM `stores` WHERE ((host = 'mygamestore.gamestreamer.rails' or host = 'www.mygamestore.gamestreamer.rails' or address = 'mygamestore')) LIMIT 1 | |
| Store Columns (114.5ms) SHOW FIELDS FROM `stores` | |
| GsTemplate Load (0.2ms) SELECT * FROM `gs_templates` WHERE (action = 'new' AND controller = 'sessions' AND store_id = 25 AND theme = 'novo') LIMIT 1 | |
| Snippet Columns (1.6ms) SHOW FIELDS FROM `snippets` | |
| Snippet Load (0.2ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.3ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.4ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.2ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.2ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.2ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.2ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| User Load (0.2ms) SELECT * FROM `users` WHERE (`users`.`id` = 676) LIMIT 1 | |
| ShoppingCart Columns (1.7ms) SHOW FIELDS FROM `shopping_carts` | |
| ShoppingCart Load (0.5ms) SELECT * FROM `shopping_carts` WHERE (`shopping_carts`.`id` IS NULL) LIMIT 1 | |
| Order Columns (5.5ms) SHOW FIELDS FROM `orders` | |
| SQL (0.3ms) BEGIN | |
| SQL (0.1ms) COMMIT | |
| User Load (0.3ms) SELECT `users`.* FROM `users` inner join user_images on user_images.user_id = users.id and user_images.parent_id is null WHERE (user_images.state = 'active') AND (`users`.store_id = 25) ORDER BY users.created_at DESC LIMIT 10 | |
| Rendering template within layouts/gamestore | |
| Rendering sessions/new | |
| Rendered shopping_cart/_step_indicator (6.1ms) | |
| Rendered sessions/_form (357.4ms) | |
| Rendered catalog/_head (28.4ms) | |
| Rendered catalog/_utilities (34.6ms) | |
| CartItem Columns (1.1ms) SHOW FIELDS FROM `cart_items` | |
| SQL (0.5ms) SELECT count(*) AS count_all FROM `cart_items` WHERE (`cart_items`.shopping_cart_id = NULL) | |
| CACHE (0.0ms) SELECT count(*) AS count_all FROM `cart_items` WHERE (`cart_items`.shopping_cart_id = NULL) | |
| Rendered catalog/_cart (9.9ms) | |
| Genre Load (0.1ms) SELECT * FROM `genres` WHERE (genres.address IN ('action','strategy','sports','children','role-playing','indie','guides','adventure','puzzle','casual')) ORDER BY address | |
| Genre Columns (1.3ms) SHOW FIELDS FROM `genres` | |
| Genre::Translation Load (8.7ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 5) | |
| Genre::Translation Columns (1.9ms) SHOW FIELDS FROM `genre_translations` | |
| Genre::Translation Load (1.5ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 9) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 18) | |
| Genre::Translation Load (0.3ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 24) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 25) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 4) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 23) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 10) | |
| Genre::Translation Load (0.1ms) SELECT * FROM `genre_translations` WHERE (`genre_translations`.`locale` IN ('en')) AND (`genre_translations`.genre_id = 8) | |
| Rendered catalog/_header (816.9ms) | |
| Rendered catalog/_footer (23.8ms) | |
| Completed in 3402ms (View: 1353, DB: 158) | 200 OK [http://mygamestore.gamestreamer.rails/login] | |
| SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 | |
| Partner Columns (2.0ms) SHOW FIELDS FROM `partners` | |
| SQL (1.7ms) SHOW TABLES | |
| User Columns (2.8ms) SHOW FIELDS FROM `users` | |
| Processing ApplicationController#index (for 127.0.0.1 at 2011-03-28 16:46:53) [GET] | |
| Rendering /Users/gamestreamer/Desktop/gamestreamer_mainrepo/gamestreamer/vendor/plugins/facebooker/templates/layout.erb (200) | |
| SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 | |
| Partner Columns (12.6ms) SHOW FIELDS FROM `partners` | |
| SQL (1.9ms) SHOW TABLES | |
| User Columns (1.7ms) SHOW FIELDS FROM `users` | |
| Processing SessionsController#create (for 127.0.0.1 at 2011-03-28 16:47:38) [POST] | |
| Parameters: {"action"=>"create", "controller"=>"sessions", "user"=>{"password"=>"[FILTERED]", "email"=>"[FILTERED]"}} | |
| User Load (0.2ms) SELECT * FROM `users` WHERE (`users`.`remember_token` = '') LIMIT 1 | |
| Store Load (0.1ms) SELECT * FROM `stores` WHERE ((host = 'mygamestore.gamestreamer.rails' or host = 'www.mygamestore.gamestreamer.rails' or address = 'mygamestore')) LIMIT 1 | |
| Store Columns (1.8ms) SHOW FIELDS FROM `stores` | |
| GsTemplate Load (0.1ms) SELECT * FROM `gs_templates` WHERE (action = 'create' AND controller = 'sessions' AND store_id = 25 AND theme = 'novo') LIMIT 1 | |
| Snippet Columns (1.0ms) SHOW FIELDS FROM `snippets` | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.2ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (4.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (1.0ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.3ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (1.6ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.3ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.2ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (1.0ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (4.7ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| User Load (0.1ms) SELECT * FROM `users` WHERE (`users`.`id` = 676) LIMIT 1 | |
| SQL (0.1ms) BEGIN | |
| Store Load (0.3ms) SELECT * FROM `stores` | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 1) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 1)) LIMIT 1 | |
| User Load (1.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 2) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 2)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 3) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 3)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 4) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 4)) LIMIT 1 | |
| User Load (0.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 5) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 5)) LIMIT 1 | |
| User Load (1.2ms) SELECT * FROM `users` WHERE (`users`.store_id = 6) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 6)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 7) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 7)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 9) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 9)) LIMIT 1 | |
| User Load (3.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 10) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 10)) LIMIT 1 | |
| User Load (1.2ms) SELECT * FROM `users` WHERE (`users`.store_id = 11) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 11)) LIMIT 1 | |
| User Load (0.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 12) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 12)) LIMIT 1 | |
| User Load (0.9ms) SELECT * FROM `users` WHERE (`users`.store_id = 13) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 13)) LIMIT 1 | |
| User Load (1.2ms) SELECT * FROM `users` WHERE (`users`.store_id = 15) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 15)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 16) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 16)) LIMIT 1 | |
| User Load (0.8ms) SELECT * FROM `users` WHERE (`users`.store_id = 17) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 17)) LIMIT 1 | |
| User Load (2.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 18) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 18)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 20) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 20)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 21) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 21)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 22) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 22)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 23) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 23)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 25) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 25)) LIMIT 1 | |
| SQL (0.1ms) COMMIT | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.`email` = 'jp@local.com') AND ((`users`.store_id = 25) AND (users.state = 'active')) LIMIT 1 | |
| User Load (1.8ms) SELECT * FROM `users` WHERE (users.store_id is null and lower(users.email) = 'jp@local.com') LIMIT 1 | |
| User Load (2.5ms) SELECT * FROM `users` WHERE (`users`.`email` = 'jp@local.com') AND ((`users`.store_id = 25) AND (`users`.store_id = 25)) LIMIT 1 | |
| CACHE (0.0ms) SELECT * FROM `stores` | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 1) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 1))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 2) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 2))) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 3) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 3))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 4) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 4))) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 5) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 5))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 6) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 6))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 7) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 7))) LIMIT 1 | |
| User Load (0.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 9) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 9))) LIMIT 1 | |
| User Load (0.9ms) SELECT * FROM `users` WHERE (`users`.store_id = 10) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 10))) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 11) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 11))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 12) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 12))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 13) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 13))) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 15) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 15))) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 16) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 16))) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 17) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 17))) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 18) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 18))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 20) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 20))) LIMIT 1 | |
| User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 21) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 21))) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 22) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 22))) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 23) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 23))) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 25) AND (((`users`.store_id = 25) AND (lower(users.email) = 'jp@local.com')) AND ((`users`.store_id = 25) AND (`users`.store_id = 25))) LIMIT 1 | |
| User Update (46.4ms) UPDATE `users` SET `updated_at` = '2011-03-28 20:47:40', `activation_code` = 'b4987f372ae44874b6ec2721cae4d5913622fdd9', `dlm_token` = NULL WHERE `id` = 676 | |
| Audit Columns (1.2ms) SHOW FIELDS FROM `versions` | |
| SQL (0.4ms) SELECT max(`number`) AS max_number FROM `versions` WHERE (`versions`.versioned_id = 676 AND `versions`.versioned_type = 'User') | |
| SQL (0.1ms) BEGIN | |
| Audit Create (0.4ms) INSERT INTO `versions` (`number`, `created_at`, `updated_at`, `versioned_type`, `tag`, `versioned_id`, `user_type`, `item_name`, `user_id`, `user_name`, `changes`, `ip`, `site`, `user_email`, `activity_type`) VALUES(3, '2011-03-28 20:47:40', '2011-03-28 20:47:40', 'User', NULL, 676, NULL, NULL, NULL, NULL, '--- \nactivation_code: \n- \n- b4987f372ae44874b6ec2721cae4d5913622fdd9\n', NULL, NULL, NULL, NULL) | |
| SQL (1.3ms) COMMIT | |
| UserImage Load (0.1ms) SELECT * FROM `user_images` WHERE (`user_images`.user_id = 675 AND (user_images.state = 'active')) LIMIT 1 | |
| ShoppingCart Load (0.4ms) SELECT * FROM `shopping_carts` WHERE (`shopping_carts`.user_id = 676) LIMIT 1 | |
| ShoppingCart Columns (0.9ms) SHOW FIELDS FROM `shopping_carts` | |
| ShoppingCart Load (0.1ms) SELECT * FROM `shopping_carts` WHERE (`shopping_carts`.`id` IS NULL) LIMIT 1 | |
| SQL (0.1ms) BEGIN | |
| Store Load (0.2ms) SELECT * FROM `stores` | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 1) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 1)) LIMIT 1 | |
| User Load (1.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 2) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 2)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 3) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 3)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 4) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 4)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 5) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 5)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 6) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 6)) LIMIT 1 | |
| User Load (2.0ms) SELECT * FROM `users` WHERE (`users`.store_id = 7) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 7)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 9) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 9)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 10) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 10)) LIMIT 1 | |
| User Load (1.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 11) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 11)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 12) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 12)) LIMIT 1 | |
| User Load (0.8ms) SELECT * FROM `users` WHERE (`users`.store_id = 13) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 13)) LIMIT 1 | |
| User Load (0.8ms) SELECT * FROM `users` WHERE (`users`.store_id = 15) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 15)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 16) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 16)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 17) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 17)) LIMIT 1 | |
| User Load (2.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 18) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 18)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 20) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 20)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 21) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 21)) LIMIT 1 | |
| User Load (1.1ms) SELECT * FROM `users` WHERE (`users`.store_id = 22) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 22)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 23) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 23)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 25) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 25)) LIMIT 1 | |
| User Update (0.4ms) UPDATE `users` SET `updated_at` = '2011-03-28 20:47:41', `activation_code` = 'b4987f372ae44874b6ec2721cae4d5913622fdd9', `dlm_token` = NULL WHERE `id` = 676 | |
| SQL (0.3ms) SELECT max(`number`) AS max_number FROM `versions` WHERE (`versions`.versioned_id = 676 AND `versions`.versioned_type = 'User') | |
| Audit Create (0.3ms) INSERT INTO `versions` (`number`, `created_at`, `updated_at`, `versioned_type`, `tag`, `versioned_id`, `user_type`, `item_name`, `user_id`, `user_name`, `changes`, `ip`, `site`, `user_email`, `activity_type`) VALUES(4, '2011-03-28 20:47:41', '2011-03-28 20:47:41', 'User', NULL, 676, NULL, NULL, NULL, NULL, '--- \nactivation_code: \n- \n- b4987f372ae44874b6ec2721cae4d5913622fdd9\n', NULL, NULL, NULL, NULL) | |
| SQL (1.4ms) COMMIT | |
| Redirected to http://mygamestore.gamestreamer.rails/account | |
| SQL (0.1ms) BEGIN | |
| Store Update (0.3ms) UPDATE `stores` SET `updated_at` = '2011-03-28 20:47:41' WHERE `id` = 25 | |
| SQL (0.8ms) COMMIT | |
| Completed in 2896ms (DB: 139) | 302 Found [http://mygamestore.gamestreamer.rails/session] | |
| SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 | |
| Partner Columns (5.9ms) SHOW FIELDS FROM `partners` | |
| SQL (1.6ms) SHOW TABLES | |
| User Columns (2.0ms) SHOW FIELDS FROM `users` | |
| Processing AccountController#show (for 127.0.0.1 at 2011-03-28 16:47:44) [GET] | |
| Parameters: {"action"=>"show", "controller"=>"account"} | |
| User Load (7.9ms) SELECT * FROM `users` WHERE (`users`.`remember_token` = '') LIMIT 1 | |
| Store Load (0.6ms) SELECT * FROM `stores` WHERE ((host = 'mygamestore.gamestreamer.rails' or host = 'www.mygamestore.gamestreamer.rails' or address = 'mygamestore')) LIMIT 1 | |
| Store Columns (1.7ms) SHOW FIELDS FROM `stores` | |
| GsTemplate Load (0.1ms) SELECT * FROM `gs_templates` WHERE (action = 'show' AND controller = 'account' AND store_id = 25 AND theme = 'novo') LIMIT 1 | |
| Snippet Columns (1.0ms) SHOW FIELDS FROM `snippets` | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'header_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.2ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'navigation_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'top') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'left') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.6ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_right') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'bottom_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` IS NULL AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| Snippet Load (0.1ms) SELECT * FROM `snippets` WHERE (`snippets`.`template_name` = 'Default' AND `snippets`.`location` = 'footer_links') AND (`snippets`.store_id = 25) LIMIT 1 | |
| User Load (2.0ms) SELECT * FROM `users` WHERE (`users`.`id` = 676) LIMIT 1 | |
| Store Load (0.4ms) SELECT * FROM `stores` WHERE (`stores`.`id` = 25) | |
| SQL (0.1ms) BEGIN | |
| Store Load (0.8ms) SELECT * FROM `stores` | |
| User Load (2.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 1) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 1)) LIMIT 1 | |
| User Load (2.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 2) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 2)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 3) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 3)) LIMIT 1 | |
| User Load (0.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 4) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 4)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 5) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 5)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 6) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 6)) LIMIT 1 | |
| User Load (3.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 7) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 7)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 9) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 9)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 10) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 10)) LIMIT 1 | |
| User Load (1.1ms) SELECT * FROM `users` WHERE (`users`.store_id = 11) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 11)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 12) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 12)) LIMIT 1 | |
| User Load (1.3ms) SELECT * FROM `users` WHERE (`users`.store_id = 13) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 13)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 15) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 15)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 16) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 16)) LIMIT 1 | |
| User Load (0.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 17) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 17)) LIMIT 1 | |
| User Load (1.8ms) SELECT * FROM `users` WHERE (`users`.store_id = 18) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 18)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 20) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 20)) LIMIT 1 | |
| User Load (0.7ms) SELECT * FROM `users` WHERE (`users`.store_id = 21) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 21)) LIMIT 1 | |
| User Load (0.5ms) SELECT * FROM `users` WHERE (`users`.store_id = 22) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 22)) LIMIT 1 | |
| User Load (0.6ms) SELECT * FROM `users` WHERE (`users`.store_id = 23) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 23)) LIMIT 1 | |
| User Load (0.4ms) SELECT * FROM `users` WHERE (`users`.store_id = 25) AND ((lower(users.email) = 'jp@local.com') AND (`users`.store_id = 25)) LIMIT 1 | |
| User Update (0.9ms) UPDATE `users` SET `updated_at` = '2011-03-28 20:47:46', `dlm_token` = '7c72e27293b590148636145b0dc44505fab5994b' WHERE `id` = 676 | |
| SQL (1.2ms) COMMIT | |
| SQL (4.3ms) SHOW TABLES | |
| SQL (1.6ms) SHOW TABLES | |
| Genre Columns (1.0ms) SHOW FIELDS FROM `genres` | |
| Genre Load (0.1ms) SELECT `genres`.* FROM `genres` INNER JOIN `genres_stores` ON `genres`.id = `genres_stores`.genre_id WHERE (`genres`.`address` IS NULL) AND (`genres_stores`.store_id = 25 ) LIMIT 1 | |
| Genre Load (0.1ms) SELECT `genres`.id FROM `genres` INNER JOIN `genres_stores` ON `genres`.id = `genres_stores`.genre_id WHERE (`genres_stores`.store_id = 25 ) | |
| Genre Load (0.1ms) SELECT * FROM `genres` | |
| Partner Load (4.7ms) SELECT `partners`.id FROM `partners` INNER JOIN `partners_stores` ON `partners`.id = `partners_stores`.partner_id WHERE (`partners_stores`.store_id = 25 ) ORDER BY partners.company_name | |
| Sunspot::NoAdapterError (No adapter is configured for Fixnum or its superclasses. See the documentation for Sunspot::Adapters): | |
| sunspot (1.2.1) lib/sunspot/adapters.rb:126:in `for' | |
| sunspot (1.2.1) lib/sunspot/adapters.rb:82:in `adapt' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:210:in `add_restriction' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:209:in `map' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:209:in `add_restriction' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:81:in `with' | |
| app/models/products/searchable.rb:197:in `facets_from_options' | |
| sunspot (1.2.1) lib/sunspot/util.rb:84:in `call' | |
| sunspot (1.2.1) lib/sunspot/util.rb:84:in `instance_eval_or_call' | |
| sunspot (1.2.1) lib/sunspot/dsl/scope.rb:162:in `dynamic' | |
| sunspot (1.2.1) lib/sunspot/util.rb:232:in `__send__' | |
| sunspot (1.2.1) lib/sunspot/util.rb:232:in `method_missing' | |
| app/models/products/searchable.rb:197:in `facets_from_options' | |
| sunspot (1.2.1) lib/sunspot/util.rb:208:in `instance_eval' | |
| sunspot (1.2.1) lib/sunspot/util.rb:208:in `instance_eval_with_context' | |
| sunspot (1.2.1) lib/sunspot/util.rb:86:in `instance_eval_or_call' | |
| sunspot (1.2.1) lib/sunspot/dsl/query_facet.rb:31:in `row' | |
| sunspot (1.2.1) lib/sunspot/util.rb:232:in `__send__' | |
| sunspot (1.2.1) lib/sunspot/util.rb:232:in `method_missing' | |
| app/models/products/searchable.rb:197:in `facets_from_options' | |
| sunspot (1.2.1) lib/sunspot/util.rb:208:in `instance_eval' | |
| sunspot (1.2.1) lib/sunspot/util.rb:208:in `instance_eval_with_context' | |
| sunspot (1.2.1) lib/sunspot/util.rb:86:in `instance_eval_or_call' | |
| sunspot (1.2.1) lib/sunspot/dsl/field_query.rb:186:in `facet' | |
| app/models/products/searchable.rb:196:in `facets_from_options' | |
| app/models/products/searchable.rb:383:in `search_with_options' | |
| sunspot (1.2.1) lib/sunspot/util.rb:84:in `call' | |
| sunspot (1.2.1) lib/sunspot/util.rb:84:in `instance_eval_or_call' | |
| sunspot (1.2.1) lib/sunspot/search/abstract_search.rb:207:in `build' | |
| sunspot (1.2.1) lib/sunspot/session.rb:50:in `new_search' | |
| sunspot (1.2.1) lib/sunspot/session_proxy/abstract_session_proxy.rb:11:in `new_search' | |
| sunspot (1.2.1) lib/sunspot.rb:261:in `new_search' | |
| /Users/gamestreamer/.rvm/gems/ruby-1.8.7-p334@gsi-gemset/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:140:in `search' | |
| /Users/gamestreamer/.rvm/gems/ruby-1.8.7-p334@gsi-gemset/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:295:in `solr_execute_search' | |
| /Users/gamestreamer/.rvm/gems/ruby-1.8.7-p334@gsi-gemset/gems/sunspot_rails-1.2.1/lib/sunspot/rails/searchable.rb:139:in `search' | |
| app/models/products/searchable.rb:371:in `search_with_options' | |
| sites/gamestore/app/controllers/game_store_controller.rb:58:in `product_search' | |
| sites/gamestore/app/controllers/account_controller.rb:260:in `new_products' | |
| sites/gamestore/app/controllers/account_controller.rb:76:in `show' | |
| lib/memcached_system.rb:9:in `cache' | |
| haml (3.0.25) rails/./lib/sass/plugin/rack.rb:41:in `call' | |
| vendor/gems/hoptoad_notifier-2.2.2/lib/hoptoad_notifier/rack.rb:27:in `call' | |
| passenger (3.0.5) lib/phusion_passenger/rack/request_handler.rb:96:in `process_request' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_request_handler.rb:513:in `accept_and_process_next_request' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_request_handler.rb:274:in `main_loop' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:321:in `start_request_handler' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `send' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:275:in `handle_spawn_application' | |
| passenger (3.0.5) lib/phusion_passenger/utils.rb:479:in `safe_fork' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:270:in `handle_spawn_application' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:357:in `__send__' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:180:in `start' | |
| passenger (3.0.5) lib/phusion_passenger/classic_rails/application_spawner.rb:149:in `start' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:219:in `spawn_rails_application' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server_collection.rb:132:in `lookup_or_add' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:214:in `spawn_rails_application' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server_collection.rb:82:in `synchronize' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server_collection.rb:79:in `synchronize' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:213:in `spawn_rails_application' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:132:in `spawn_application' | |
| passenger (3.0.5) lib/phusion_passenger/spawn_manager.rb:275:in `handle_spawn_application' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:357:in `__send__' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:357:in `server_main_loop' | |
| passenger (3.0.5) lib/phusion_passenger/abstract_server.rb:206:in `start_synchronously' | |
| passenger (3.0.5) helper-scripts/passenger-spawn-server:99 | |
| Rendered rescues/_trace (379.1ms) | |
| Rendered rescues/_request_and_response (0.6ms) | |
| Rendering /Users/gamestreamer/Desktop/gamestreamer_mainrepo/gamestreamer/vendor/plugins/facebooker/templates/layout.erb (200) | |
| SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 | |
| Partner Columns (2.8ms) SHOW FIELDS FROM `partners` | |
| SQL (2.0ms) SHOW TABLES | |
| User Columns (1.9ms) SHOW FIELDS FROM `users` | |
| Processing ApplicationController#index (for 127.0.0.1 at 2011-03-28 16:48:14) [GET] | |
| Rendering /Users/gamestreamer/Desktop/gamestreamer_mainrepo/gamestreamer/vendor/plugins/facebooker/templates/layout.erb (200) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment