** has_many_polymorphs: autoload hook invoked ** has_many_polymorphs: preloading parent model Zone ** has_many_polymorphs: associating Zone.members SQL (0.2ms) SET SQL_AUTO_IS_NULL=0 Country Columns (1.2ms) SHOW FIELDS FROM `countries` State Columns (1.2ms) SHOW FIELDS FROM `states` ZoneMember Columns (1.3ms) SHOW FIELDS FROM `zone_members` Zone Columns (1.1ms) SHOW FIELDS FROM `zones` Processing Admin::ProductsController#create (for 127.0.0.1 at 2009-02-01 21:08:38) [POST] Parameters: {"commit"=>"Create", "action"=>"create", "authenticity_token"=>"f01407f5f0c38f56152e4ed8c9d904a41260f590", "product"=>{"name"=>"Foobar", "available_on"=>"02/01/2009 03:07 PM", "tax_category_id"=>"391306076", "shipping_category_id"=>"368564052", "master_price"=>"123", "on_hand"=>"15", "sku"=>"FOOBAR", "description"=>"Foo bar"}, "controller"=>"admin/products", "image"=>{"attachment"=>#}} Taxonomy Load (0.2ms) SELECT * FROM `taxonomies`  Taxonomy Columns (1.1ms) SHOW FIELDS FROM `taxonomies` Taxon Load (0.2ms) SELECT `taxons`.* FROM `taxons` WHERE (`taxons`.taxonomy_id IN (276849385,402847427) AND (parent_id is null))  Taxon Columns (1.3ms) SHOW FIELDS FROM `taxons` Taxon Load (0.2ms) SELECT `taxons`.* FROM `taxons` WHERE (`taxons`.parent_id IN (1000,20000)) ORDER BY position SQL (2.1ms) SHOW TABLES AppConfiguration Columns (1.2ms) SHOW FIELDS FROM `configurations` AppConfiguration Load (0.3ms) SELECT * FROM `configurations` WHERE (`configurations`.`name` = 'Default configuration') AND ( (`configurations`.`type` = 'AppConfiguration' ) ) LIMIT 1 Cache hit: Spree::Config ({}) User Columns (1.3ms) SHOW FIELDS FROM `users` User Load (0.2ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Join Table Columns (1.9ms) SHOW FIELDS FROM `roles_users` Role Load (0.2ms) SELECT * FROM `roles` INNER JOIN `roles_users` ON `roles`.id = `roles_users`.role_id WHERE (`roles_users`.user_id = 1 )  Role Columns (1.0ms) SHOW FIELDS FROM `roles` TaxCategory Load (0.2ms) SELECT * FROM `tax_categories` ORDER BY name ShippingCategory Load (0.3ms) SELECT * FROM `shipping_categories` ORDER BY name Variant Columns (1.4ms) SHOW FIELDS FROM `variants` SQL (0.2ms) BEGIN SQL (0.2ms) COMMIT SQL (0.2ms) BEGIN SQL (0.5ms) SELECT count(*) AS count_all FROM `products` WHERE (products.permalink = 'foobar')  Product Exists (0.4ms) SELECT `products`.id FROM `products` WHERE (`products`.`permalink` = BINARY 'foobar') LIMIT 1 Product Create (0.5ms) INSERT INTO `products` (`name`, `permalink`, `created_at`, `available_on`, `tax_category_id`, `shipping_category_id`, `master_price`, `updated_at`, `deleted_at`, `description`, `viewable_id`) VALUES('Foobar', 'foobar', '2009-02-01 20:08:39', '2009-02-01 20:08:39', 391306076, 368564052, 123.0, '2009-02-01 20:08:39', NULL, 'Foo bar', NULL) Variant Create (0.4ms) INSERT INTO `variants` (`price`, `product_id`, `deleted_at`, `depth`, `weight`, `sku`, `height`, `width`) VALUES(123.0, 863378202, NULL, NULL, NULL, 'FOOBAR', NULL, NULL) InventoryUnit Columns (1.3ms) SHOW FIELDS FROM `inventory_units` InventoryUnit Create (0.4ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.3ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.3ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.3ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.3ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.3ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.6ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.6ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.3ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.4ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.4ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.3ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.5ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.3ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') InventoryUnit Create (0.3ms) INSERT INTO `inventory_units` (`created_at`, `order_id`, `updated_at`, `lock_version`, `variant_id`, `state`) VALUES('2009-02-01 20:08:39', NULL, '2009-02-01 20:08:39', 0, 980615693, 'on_hand') Product Load (0.4ms) SELECT * FROM `products` WHERE (`products`.`id` = 863378202)  SQL (7.3ms) COMMIT Redirected to http://localhost:3000/admin/products/foobar Image Columns (1.4ms) SHOW FIELDS FROM `assets` [paperclip] Paperclip attachment attachment on Image initialized. [paperclip] Assigning # to attachment [paperclip] Writing attributes for attachment [paperclip] Post-processing attachment SQL (0.2ms) BEGIN Asset Load (0.5ms) SELECT * FROM `assets` WHERE (viewable_id IS NULL) ORDER BY position DESC LIMIT 1 Image Create (0.4ms) INSERT INTO `assets` (`attachment_file_name`, `position`, `attachment_content_type`, `viewable_type`, `type`, `viewable_id`, `attachment_size`, `attachment_updated_at`) VALUES('code-complete-big.jpeg', 1, 'image/jpeg', NULL, 'Image', NULL, NULL, '2009-02-01 21:08:39') [paperclip] Saving attachments. [paperclip] Saving files for attachment [paperclip] Deleting files for attachment [paperclip] Writing files for attachment [paperclip] -> /home/mtah/code/suit-uw/public/assets/products/1012/mini/code-complete-big.jpeg [paperclip] -> /home/mtah/code/suit-uw/public/assets/products/1012/original/code-complete-big.jpeg [paperclip] -> /home/mtah/code/suit-uw/public/assets/products/1012/small/code-complete-big.jpeg [paperclip] -> /home/mtah/code/suit-uw/public/assets/products/1012/product/code-complete-big.jpeg SQL (6.5ms) COMMIT SQL (0.2ms) BEGIN Image Update (0.4ms) UPDATE `assets` SET `viewable_id` = 863378202, `viewable_type` = 'Product' WHERE `id` = 1012 [paperclip] Saving attachments. [paperclip] Saving files for attachment [paperclip] Deleting files for attachment [paperclip] Writing files for attachment SQL (0.5ms) COMMIT Completed in 1650ms (DB: 45) | 302 Found [http://localhost/admin/products] Product Columns (1.5ms) SHOW FIELDS FROM `products` ** has_many_polymorphs: autoload hook invoked ** has_many_polymorphs: preloading parent model Zone ** has_many_polymorphs: associating Zone.members SQL (0.1ms) SET SQL_AUTO_IS_NULL=0 Country Columns (1.2ms) SHOW FIELDS FROM `countries` State Columns (1.2ms) SHOW FIELDS FROM `states` ZoneMember Columns (1.3ms) SHOW FIELDS FROM `zone_members` Zone Columns (1.2ms) SHOW FIELDS FROM `zones` Processing Admin::ProductsController#show (for 127.0.0.1 at 2009-02-01 21:08:41) [GET] Parameters: {"action"=>"show", "id"=>"foobar", "controller"=>"admin/products"} Taxonomy Load (0.3ms) SELECT * FROM `taxonomies`  Taxonomy Columns (1.5ms) SHOW FIELDS FROM `taxonomies` Taxon Load (0.2ms) SELECT `taxons`.* FROM `taxons` WHERE (`taxons`.taxonomy_id IN (276849385,402847427) AND (parent_id is null))  Taxon Columns (1.8ms) SHOW FIELDS FROM `taxons` Taxon Load (0.3ms) SELECT `taxons`.* FROM `taxons` WHERE (`taxons`.parent_id IN (1000,20000)) ORDER BY position SQL (0.9ms) SHOW TABLES AppConfiguration Columns (1.6ms) SHOW FIELDS FROM `configurations` AppConfiguration Load (0.3ms) SELECT * FROM `configurations` WHERE (`configurations`.`name` = 'Default configuration') AND ( (`configurations`.`type` = 'AppConfiguration' ) ) LIMIT 1 Cache hit: Spree::Config ({}) User Columns (1.8ms) SHOW FIELDS FROM `users` User Load (0.3ms) SELECT * FROM `users` WHERE (`users`.`id` = 1)  Join Table Columns (1.4ms) SHOW FIELDS FROM `roles_users` Role Load (0.2ms) SELECT * FROM `roles` INNER JOIN `roles_users` ON `roles`.id = `roles_users`.role_id WHERE (`roles_users`.user_id = 1 )  Role Columns (1.3ms) SHOW FIELDS FROM `roles` TaxCategory Load (0.2ms) SELECT * FROM `tax_categories` ORDER BY name ShippingCategory Load (0.2ms) SELECT * FROM `shipping_categories` ORDER BY name Product Load (0.7ms) SELECT * FROM `products` WHERE (`products`.`permalink` = 'foobar') LIMIT 1 Rendering template within layouts/admin Rendering admin/products/show Rendered shared/_product_sub_menu (277.4ms) CACHE (0.0ms) SELECT * FROM `products` WHERE (`products`.`permalink` = 'foobar') LIMIT 1 CACHE (0.0ms) SELECT * FROM `products` WHERE (`products`.`permalink` = 'foobar') LIMIT 1 Rendered shared/_show_resource_links (10.4ms) SQL (0.6ms) SHOW TABLES CACHE (0.0ms) SELECT * FROM `configurations` WHERE (`configurations`.`name` = 'Default configuration') AND ( (`configurations`.`type` = 'AppConfiguration' ) ) LIMIT 1 Cache hit: Spree::Config ({}) Completed in 775ms (View: 317, DB: 19) | 200 OK [http://localhost/admin/products/foobar] Product Columns (3.4ms) SHOW FIELDS FROM `products`