Created
November 15, 2009 23:05
-
-
Save schof/235555 to your computer and use it in GitHub Desktop.
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 ProductsController#show (for 127.0.0.1 at 2009-11-15 17:55:52) [GET] | |
| Parameters: {"action"=>"show", "id"=>"palmgard-grip-tack-lite-adult-football-lineman-gloves", "controller"=>"products"} | |
| [4;36;1mProduct Load (0.9ms)[0m [0;1mSELECT * FROM `products` WHERE (`products`.`permalink` = 'palmgard-grip-tack-lite-adult-football-lineman-gloves') LIMIT 1[0m | |
| Cache miss: Spree::Config ({}) | |
| [4;35;1mPreference Load (0.4ms)[0m [0mSELECT * FROM `preferences` WHERE (`preferences`.owner_id = 1 AND `preferences`.owner_type = 'Configuration') [0m | |
| [4;36;1mConfiguration Columns (1.2ms)[0m [0;1mSHOW FIELDS FROM `configurations`[0m | |
| [4;35;1mConfiguration Load (0.2ms)[0m [0mSELECT * FROM `configurations` WHERE (`configurations`.`id` = 1) [0m | |
| [4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `configurations` WHERE (`configurations`.`id` = 1) [0m | |
| [4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `configurations` WHERE (`configurations`.`id` = 1) [0m | |
| Cache write (will save 3.80ms): Spree::Config | |
| [4;36;1mVariant Columns (1.2ms)[0m [0;1mSHOW FIELDS FROM `variants`[0m | |
| [4;35;1mVariant Load (2.2ms)[0m [0mSELECT * FROM `variants` WHERE (`variants`.`product_id` = 1918211) AND (variants.deleted_at is null) [0m | |
| [4;36;1mOptionValue Load (0.5ms)[0m [0;1mSELECT `option_values`.*, t0.variant_id as the_parent_record_id FROM `option_values` INNER JOIN `option_values_variants` t0 ON `option_values`.id = t0.option_value_id WHERE (t0.variant_id = 7088) [0m | |
| [4;35;1mImage Columns (1.3ms)[0m [0mSHOW FIELDS FROM `assets`[0m | |
| [4;36;1mImage Load (0.4ms)[0m [0;1mSELECT `assets`.* FROM `assets` WHERE (`assets`.`viewable_id` = 7088 and `assets`.`viewable_type` = 'Variant') AND ( (`assets`.`type` = 'Image' ) ) ORDER BY position[0m | |
| [4;35;1mProductProperty Columns (1.2ms)[0m [0mSHOW FIELDS FROM `product_properties`[0m | |
| [4;36;1mProductProperty Load (2.9ms)[0m [0;1mSELECT * FROM `product_properties` WHERE (`product_properties`.`product_id` = 1918211) [0m | |
| Cache hit: Spree::Config ({}) | |
| [4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `variants` WHERE (`variants`.`product_id` = 1918211) AND (variants.deleted_at is null) [0m | |
| [4;36;1mCACHE (0.0ms)[0m [0;1mSELECT `option_values`.*, t0.variant_id as the_parent_record_id FROM `option_values` INNER JOIN `option_values_variants` t0 ON `option_values`.id = t0.option_value_id WHERE (t0.variant_id = 7088) [0m | |
| [4;35;1mCACHE (0.0ms)[0m [0mSELECT `assets`.* FROM `assets` WHERE (`assets`.`viewable_id` = 7088 and `assets`.`viewable_type` = 'Variant') AND ( (`assets`.`type` = 'Image' ) ) ORDER BY position[0m | |
| [4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `product_properties` WHERE (`product_properties`.`product_id` = 1918211) [0m | |
| Cache hit: Spree::Config ({}) | |
| [4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `products` WHERE (`products`.`permalink` = 'palmgard-grip-tack-lite-adult-football-lineman-gloves') LIMIT 1[0m | |
| Rendering template within layouts/spree_application | |
| Rendering products/show | |
| Cache hit: Spree::Config ({}) | |
| [4;36;1mVariant Load (0.7ms)[0m [0;1mSELECT * FROM `variants` WHERE (`variants`.product_id = 1918211 AND (variants.is_master = 1 AND variants.deleted_at IS NULL)) LIMIT 1[0m | |
| Cache hit: Spree::Config ({}) | |
| Cache hit: Spree::Config ({}) | |
| Cache hit: Spree::Config ({}) | |
| [4;35;1mRating Load (0.4ms)[0m [0mSELECT * FROM `ratings` WHERE (`ratings`.product_id = 1918211) LIMIT 1[0m | |
| Rendered reviews/_stars (2.2ms) | |
| Rendered shared/_rating (112.2ms) | |
| [4;36;1mImage Load (0.4ms)[0m [0;1mSELECT * FROM `assets` WHERE (`assets`.viewable_id = 1918211 AND `assets`.viewable_type = 'Product') AND ( (`assets`.`type` = 'Image' ) ) ORDER BY position[0m | |
| [4;35;1mRemoteImage Load (122650.2ms)[0m [0mSELECT * FROM `remote_images` WHERE ((width > 100 OR height > 100) AND width <= 240 AND height <= 240) AND (`remote_images`.viewable_id = 1918211 AND `remote_images`.viewable_type = 'Product') ORDER BY width DESC[0m | |
| [4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `remote_images` WHERE ((width > 100 OR height > 100) AND width <= 240 AND height <= 240) AND (`remote_images`.viewable_id = 1918211 AND `remote_images`.viewable_type = 'Product') ORDER BY width DESC[0m | |
| [4;35;1mRemoteImage Columns (1.4ms)[0m [0mSHOW FIELDS FROM `remote_images`[0m | |
| Rendered products/_image (122669.9ms) | |
| Rendered reviews/_stars (1.2ms) | |
| [4;36;1mSQL (0.6ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mReviewsConfiguration Columns (1.7ms)[0m [0mSHOW FIELDS FROM `configurations`[0m | |
| [4;36;1mReviewsConfiguration Load (0.5ms)[0m [0;1mSELECT * FROM `configurations` WHERE (`configurations`.`name` = 'Reviews configuration') AND ( (`configurations`.`type` = 'ReviewsConfiguration' ) ) LIMIT 1[0m | |
| Cache miss: Spree::Reviews::Config ({}) | |
| [4;35;1mPreference Load (0.5ms)[0m [0mSELECT * FROM `preferences` WHERE (`preferences`.owner_id = 3 AND `preferences`.owner_type = 'Configuration') [0m | |
| [4;36;1mConfiguration Load (0.2ms)[0m [0;1mSELECT * FROM `configurations` WHERE (`configurations`.`id` = 3) [0m | |
| [4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `configurations` WHERE (`configurations`.`id` = 3) [0m | |
| Cache write (will save 2.25ms): Spree::Reviews::Config | |
| [4;36;1mReview Load (20.7ms)[0m [0;1mSELECT * FROM `reviews` WHERE (`reviews`.product_id = 1918211) [0m | |
| [4;35;1mSQL (0.8ms)[0m [0mSELECT count(*) AS count_all FROM `variants` WHERE (`variants`.product_id = 1918211 AND (variants.is_master = 0 AND variants.deleted_at IS NULL)) [0m | |
| [4;36;1mWishedProduct Columns (5.9ms)[0m [0;1mSHOW FIELDS FROM `wished_products`[0m | |
| Rendered products/_wishlist_form (19.5ms) | |
| [4;35;1mproducts_taxons Columns (12.6ms)[0m [0mSHOW FIELDS FROM `products_taxons`[0m | |
| [4;36;1mTaxon Load (21.8ms)[0m [0;1mSELECT * FROM `taxons` INNER JOIN `products_taxons` ON `taxons`.id = `products_taxons`.taxon_id WHERE (`products_taxons`.product_id = 1918211 ) [0m | |
| [4;35;1mTaxon Columns (1.5ms)[0m [0mSHOW FIELDS FROM `taxons`[0m | |
| Cache hit: Spree::Config ({}) | |
| [4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `products` WHERE (`products`.`permalink` = 'palmgard-grip-tack-lite-adult-football-lineman-gloves') LIMIT 1[0m | |
| [4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `products` WHERE (`products`.`permalink` = 'palmgard-grip-tack-lite-adult-football-lineman-gloves') LIMIT 1[0m | |
| [4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `products` WHERE (`products`.`permalink` = 'palmgard-grip-tack-lite-adult-football-lineman-gloves') LIMIT 1[0m | |
| [4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `products` WHERE (`products`.`permalink` = 'palmgard-grip-tack-lite-adult-football-lineman-gloves') LIMIT 1[0m | |
| [4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `products` WHERE (`products`.`permalink` = 'palmgard-grip-tack-lite-adult-football-lineman-gloves') LIMIT 1[0m | |
| [4;35;1mProduct Load (0.2ms)[0m [0mSELECT * FROM `products` WHERE (id IN (NULL)) [0m | |
| Rendered shared/_head (6.8ms) | |
| [4;36;1mTaxonomy Columns (1.2ms)[0m [0;1mSHOW FIELDS FROM `taxonomies`[0m | |
| [4;35;1mTaxonomy Load (5.9ms)[0m [0mSELECT * FROM `taxonomies` WHERE (`taxonomies`.`name` = 'Categories') LIMIT 1[0m | |
| [4;36;1mTaxon Load (0.7ms)[0m [0;1mSELECT * FROM `taxons` WHERE (`taxons`.taxonomy_id = 854451430 AND (parent_id is null)) LIMIT 1[0m | |
| [4;35;1mTaxon Load (4.5ms)[0m [0mSELECT * FROM `taxons` WHERE (`taxons`.parent_id = 9999) ORDER BY `lft`[0m | |
| Rendered shared/_search (19.5ms) | |
| [4;36;1mTaxon Load (21.6ms)[0m [0;1mSELECT * FROM `taxons` WHERE (`taxons`.`department` = 1) ORDER BY lft[0m | |
| [4;35;1mTaxon Load (0.8ms)[0m [0mSELECT * FROM `taxons` WHERE (`taxons`.parent_id = 676) ORDER BY `lft`[0m | |
| [4;36;1mTaxon Load (0.7ms)[0m [0;1mSELECT * FROM `taxons` WHERE (`taxons`.parent_id = 855) ORDER BY `lft`[0m | |
| [4;35;1mTaxon Load (0.7ms)[0m [0mSELECT * FROM `taxons` WHERE (`taxons`.parent_id = 1055) ORDER BY `lft`[0m | |
| [4;36;1mTaxon Load (1.0ms)[0m [0;1mSELECT * FROM `taxons` WHERE (`taxons`.parent_id = 1982) ORDER BY `lft`[0m | |
| [4;35;1mTaxon Load (0.7ms)[0m [0mSELECT * FROM `taxons` WHERE (`taxons`.parent_id = 2329) ORDER BY `lft`[0m | |
| [4;36;1mTaxon Load (0.5ms)[0m [0;1mSELECT * FROM `taxons` WHERE (`taxons`.parent_id = 2520) ORDER BY `lft`[0m | |
| [4;35;1mTaxon Load (0.9ms)[0m [0mSELECT * FROM `taxons` WHERE (`taxons`.parent_id = 2772) ORDER BY `lft`[0m | |
| [4;36;1mTaxon Load (1.1ms)[0m [0;1mSELECT * FROM `taxons` WHERE (`taxons`.parent_id = 4810) ORDER BY `lft`[0m | |
| [4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `taxonomies` WHERE (`taxonomies`.`name` = 'Categories') LIMIT 1[0m | |
| [4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `taxons` WHERE (`taxons`.taxonomy_id = 854451430 AND (parent_id is null)) LIMIT 1[0m | |
| [4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `taxonomies` WHERE (`taxonomies`.`name` = 'Categories') LIMIT 1[0m | |
| [4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `taxons` WHERE (`taxons`.taxonomy_id = 854451430 AND (parent_id is null)) LIMIT 1[0m | |
| Rendered shared/_header (93.5ms) | |
| Completed in 123232ms (View: 426, DB: 122775) | 200 OK [http://localhost/products/palmgard-grip-tack-lite-adult-football-lineman-gloves] | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| [4;35;1mSQL (0.6ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mSQL (0.6ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mSQL (0.7ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mSQL (0.5ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mSQL (0.5ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mSQL (0.8ms)[0m [0;1mSHOW TABLES[0m | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| [4;35;1mProduct Columns (1.6ms)[0m [0mSHOW FIELDS FROM `products`[0m | |
| [4;36;1mSQL (0.6ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mProperty Columns (1.2ms)[0m [0mSHOW FIELDS FROM `properties`[0m | |
| [4;36;1mProperty Load (0.7ms)[0m [0;1mSELECT * FROM `properties` WHERE (`properties`.`name` = 'brand') LIMIT 1[0m | |
| [4;35;1mSQL (0.6ms)[0m [0mSHOW TABLES[0m | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| [4;36;1mOrder Columns (1.6ms)[0m [0;1mSHOW FIELDS FROM `orders`[0m | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| [4;35;1mSQL (0.6ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mAppConfiguration Columns (1.3ms)[0m [0;1mSHOW FIELDS FROM `configurations`[0m | |
| [4;35;1mAppConfiguration Load (0.3ms)[0m [0mSELECT * FROM `configurations` WHERE (`configurations`.`name` = 'Default configuration') AND ( (`configurations`.`type` = 'AppConfiguration' ) ) LIMIT 1[0m | |
| [4;36;1mSQL (0.1ms)[0m [0;1mBEGIN[0m | |
| [4;35;1mAppConfiguration Load (0.3ms)[0m [0mSELECT `configurations`.id FROM `configurations` WHERE (`configurations`.`name` = BINARY 'Default configuration' AND `configurations`.id <> 1) AND ( (`configurations`.`type` = 'AppConfiguration' ) ) LIMIT 1[0m | |
| [4;36;1mPreference Load (0.4ms)[0m [0;1mSELECT * FROM `preferences` WHERE (`preferences`.owner_id = 1 AND `preferences`.owner_type = 'Configuration' AND (`preferences`.`attribute` = 'recently_viewed_products_max_count' AND `preferences`.`group_id` IS NULL AND `preferences`.`group_type` IS NULL)) LIMIT 1[0m | |
| [4;35;1mPreference Columns (1.3ms)[0m [0mSHOW FIELDS FROM `preferences`[0m | |
| [4;36;1mPreference Update (0.3ms)[0m [0;1mUPDATE `preferences` SET `value` = 5, `updated_at` = '2009-11-15 22:57:56' WHERE `id` = 1[0m | |
| [4;35;1mSQL (0.5ms)[0m [0mCOMMIT[0m | |
| Cache delete: Spree::Config | |
| [4;36;1mSQL (0.8ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mUser Columns (2.7ms)[0m [0mSHOW FIELDS FROM `users`[0m | |
| [4;36;1mSQL (0.1ms)[0m [0;1mSET SQL_AUTO_IS_NULL=0[0m | |
| [4;35;1mSQL (0.5ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mRole Columns (1.3ms)[0m [0;1mSHOW FIELDS FROM `roles`[0m | |
| [4;35;1mUser Load IDs For Limited Eager Loading (0.6ms)[0m [0mSELECT DISTINCT `users`.id FROM `users` LEFT OUTER JOIN `roles_users` ON `roles_users`.user_id = `users`.id LEFT OUTER JOIN `roles` ON `roles`.id = `roles_users`.role_id WHERE (roles.name = 'admin') LIMIT 1[0m | |
| [4;36;1mUser Load Including Associations (0.3ms)[0m [0;1mSELECT `users`.`id` AS t0_r0, `users`.`email` AS t0_r1, `users`.`crypted_password` AS t0_r2, `users`.`salt` AS t0_r3, `users`.`remember_token` AS t0_r4, `users`.`remember_token_expires_at` AS t0_r5, `users`.`created_at` AS t0_r6, `users`.`updated_at` AS t0_r7, `users`.`persistence_token` AS t0_r8, `users`.`single_access_token` AS t0_r9, `users`.`perishable_token` AS t0_r10, `users`.`login_count` AS t0_r11, `users`.`failed_login_count` AS t0_r12, `users`.`last_request_at` AS t0_r13, `users`.`current_login_at` AS t0_r14, `users`.`last_login_at` AS t0_r15, `users`.`current_login_ip` AS t0_r16, `users`.`last_login_ip` AS t0_r17, `users`.`login` AS t0_r18, `users`.`ship_address_id` AS t0_r19, `users`.`bill_address_id` AS t0_r20, `users`.`openid_identifier` AS t0_r21, `roles`.`id` AS t1_r0, `roles`.`name` AS t1_r1 FROM `users` LEFT OUTER JOIN `roles_users` ON `roles_users`.user_id = `users`.id LEFT OUTER JOIN `roles` ON `roles`.id = `roles_users`.role_id WHERE (roles.name = 'admin') AND `users`.id IN (1) [0m | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| Processing ContentController#show (for 127.0.0.1 at 2009-11-15 17:57:56) [GET] | |
| Parameters: {"action"=>"show", "controller"=>"content", "path"=>["javascripts", "localization", "messages_en.js"]} | |
| Cache miss: Spree::Config ({}) | |
| [4;35;1mPreference Load (0.4ms)[0m [0mSELECT * FROM `preferences` WHERE (`preferences`.owner_id = 1 AND `preferences`.owner_type = 'Configuration') [0m | |
| [4;36;1mConfiguration Columns (1.1ms)[0m [0;1mSHOW FIELDS FROM `configurations`[0m | |
| [4;35;1mConfiguration Load (0.1ms)[0m [0mSELECT * FROM `configurations` WHERE (`configurations`.`id` = 1) [0m | |
| [4;36;1mCACHE (0.0ms)[0m [0;1mSELECT * FROM `configurations` WHERE (`configurations`.`id` = 1) [0m | |
| [4;35;1mCACHE (0.0ms)[0m [0mSELECT * FROM `configurations` WHERE (`configurations`.`id` = 1) [0m | |
| Cache write (will save 4.17ms): Spree::Config | |
| Rendering /Users/schof/client_work/fogdog/public/404.html (404 Not Found) | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| [4;36;1mSQL (0.7ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mSQL (0.6ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mSQL (0.9ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mSQL (0.5ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mSQL (0.4ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mSQL (0.6ms)[0m [0mSHOW TABLES[0m | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| [4;36;1mProduct Columns (1.6ms)[0m [0;1mSHOW FIELDS FROM `products`[0m | |
| [4;35;1mSQL (0.6ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mProperty Columns (1.2ms)[0m [0;1mSHOW FIELDS FROM `properties`[0m | |
| [4;35;1mProperty Load (0.2ms)[0m [0mSELECT * FROM `properties` WHERE (`properties`.`name` = 'brand') LIMIT 1[0m | |
| [4;36;1mSQL (0.5ms)[0m [0;1mSHOW TABLES[0m | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| [4;35;1mOrder Columns (1.6ms)[0m [0mSHOW FIELDS FROM `orders`[0m | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| [4;36;1mSQL (0.6ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mAppConfiguration Columns (1.3ms)[0m [0mSHOW FIELDS FROM `configurations`[0m | |
| [4;36;1mAppConfiguration Load (0.4ms)[0m [0;1mSELECT * FROM `configurations` WHERE (`configurations`.`name` = 'Default configuration') AND ( (`configurations`.`type` = 'AppConfiguration' ) ) LIMIT 1[0m | |
| [4;35;1mSQL (0.1ms)[0m [0mBEGIN[0m | |
| [4;36;1mAppConfiguration Load (0.3ms)[0m [0;1mSELECT `configurations`.id FROM `configurations` WHERE (`configurations`.`name` = BINARY 'Default configuration' AND `configurations`.id <> 1) AND ( (`configurations`.`type` = 'AppConfiguration' ) ) LIMIT 1[0m | |
| [4;35;1mPreference Load (0.4ms)[0m [0mSELECT * FROM `preferences` WHERE (`preferences`.owner_id = 1 AND `preferences`.owner_type = 'Configuration' AND (`preferences`.`attribute` = 'recently_viewed_products_max_count' AND `preferences`.`group_id` IS NULL AND `preferences`.`group_type` IS NULL)) LIMIT 1[0m | |
| [4;36;1mPreference Columns (1.4ms)[0m [0;1mSHOW FIELDS FROM `preferences`[0m | |
| [4;35;1mPreference Update (0.2ms)[0m [0mUPDATE `preferences` SET `value` = 5, `updated_at` = '2009-11-15 22:57:57' WHERE `id` = 1[0m | |
| [4;36;1mSQL (0.4ms)[0m [0;1mCOMMIT[0m | |
| Cache delete: Spree::Config | |
| [4;35;1mSQL (0.5ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mUser Columns (1.6ms)[0m [0;1mSHOW FIELDS FROM `users`[0m | |
| [4;35;1mSQL (0.1ms)[0m [0mSET SQL_AUTO_IS_NULL=0[0m | |
| [4;36;1mSQL (0.5ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mRole Columns (1.1ms)[0m [0mSHOW FIELDS FROM `roles`[0m | |
| [4;36;1mUser Load IDs For Limited Eager Loading (0.3ms)[0m [0;1mSELECT DISTINCT `users`.id FROM `users` LEFT OUTER JOIN `roles_users` ON `roles_users`.user_id = `users`.id LEFT OUTER JOIN `roles` ON `roles`.id = `roles_users`.role_id WHERE (roles.name = 'admin') LIMIT 1[0m | |
| [4;35;1mUser Load Including Associations (0.3ms)[0m [0mSELECT `users`.`id` AS t0_r0, `users`.`email` AS t0_r1, `users`.`crypted_password` AS t0_r2, `users`.`salt` AS t0_r3, `users`.`remember_token` AS t0_r4, `users`.`remember_token_expires_at` AS t0_r5, `users`.`created_at` AS t0_r6, `users`.`updated_at` AS t0_r7, `users`.`persistence_token` AS t0_r8, `users`.`single_access_token` AS t0_r9, `users`.`perishable_token` AS t0_r10, `users`.`login_count` AS t0_r11, `users`.`failed_login_count` AS t0_r12, `users`.`last_request_at` AS t0_r13, `users`.`current_login_at` AS t0_r14, `users`.`last_login_at` AS t0_r15, `users`.`current_login_ip` AS t0_r16, `users`.`last_login_ip` AS t0_r17, `users`.`login` AS t0_r18, `users`.`ship_address_id` AS t0_r19, `users`.`bill_address_id` AS t0_r20, `users`.`openid_identifier` AS t0_r21, `roles`.`id` AS t1_r0, `roles`.`name` AS t1_r1 FROM `users` LEFT OUTER JOIN `roles_users` ON `roles_users`.user_id = `users`.id LEFT OUTER JOIN `roles` ON `roles`.id = `roles_users`.role_id WHERE (roles.name = 'admin') AND `users`.id IN (1) [0m | |
| Cache miss: Spree::Config ({}) | |
| [4;36;1mPreference Load (0.2ms)[0m [0;1mSELECT * FROM `preferences` WHERE (`preferences`.owner_id = 1 AND `preferences`.owner_type = 'Configuration') [0m | |
| [4;35;1mConfiguration Columns (2.4ms)[0m [0mSHOW FIELDS FROM `configurations`[0m | |
| [4;36;1mConfiguration Load (0.2ms)[0m [0;1mSELECT * FROM `configurations` WHERE (`configurations`.`id` = 1) [0m | |
| [4;35;1mConfiguration Load (0.1ms)[0m [0mSELECT * FROM `configurations` WHERE (`configurations`.`id` = 1) [0m | |
| [4;36;1mConfiguration Load (0.1ms)[0m [0;1mSELECT * FROM `configurations` WHERE (`configurations`.`id` = 1) [0m | |
| Cache write (will save 5.79ms): Spree::Config | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| [4;35;1mSQL (0.6ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mSQL (0.6ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mSQL (0.5ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mSQL (0.6ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mSQL (0.8ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mSQL (0.6ms)[0m [0;1mSHOW TABLES[0m | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| [4;35;1mProduct Columns (1.6ms)[0m [0mSHOW FIELDS FROM `products`[0m | |
| [4;36;1mSQL (0.5ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mProperty Columns (1.1ms)[0m [0mSHOW FIELDS FROM `properties`[0m | |
| [4;36;1mProperty Load (0.2ms)[0m [0;1mSELECT * FROM `properties` WHERE (`properties`.`name` = 'brand') LIMIT 1[0m | |
| [4;35;1mSQL (0.4ms)[0m [0mSHOW TABLES[0m | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| [4;36;1mOrder Columns (1.9ms)[0m [0;1mSHOW FIELDS FROM `orders`[0m | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| INFO: Loading permissions from /Users/schof/client_work/fogdog/vendor/extensions/wishlist/config/spree_permissions.yml | |
| [4;35;1mSQL (0.6ms)[0m [0mSHOW TABLES[0m | |
| [4;36;1mAppConfiguration Columns (1.2ms)[0m [0;1mSHOW FIELDS FROM `configurations`[0m | |
| [4;35;1mAppConfiguration Load (0.3ms)[0m [0mSELECT * FROM `configurations` WHERE (`configurations`.`name` = 'Default configuration') AND ( (`configurations`.`type` = 'AppConfiguration' ) ) LIMIT 1[0m | |
| [4;36;1mSQL (0.1ms)[0m [0;1mBEGIN[0m | |
| [4;35;1mAppConfiguration Load (0.3ms)[0m [0mSELECT `configurations`.id FROM `configurations` WHERE (`configurations`.`name` = BINARY 'Default configuration' AND `configurations`.id <> 1) AND ( (`configurations`.`type` = 'AppConfiguration' ) ) LIMIT 1[0m | |
| [4;36;1mPreference Load (0.4ms)[0m [0;1mSELECT * FROM `preferences` WHERE (`preferences`.owner_id = 1 AND `preferences`.owner_type = 'Configuration' AND (`preferences`.`attribute` = 'recently_viewed_products_max_count' AND `preferences`.`group_id` IS NULL AND `preferences`.`group_type` IS NULL)) LIMIT 1[0m | |
| [4;35;1mPreference Columns (1.3ms)[0m [0mSHOW FIELDS FROM `preferences`[0m | |
| [4;36;1mPreference Update (0.2ms)[0m [0;1mUPDATE `preferences` SET `value` = 5, `updated_at` = '2009-11-15 22:57:58' WHERE `id` = 1[0m | |
| [4;35;1mSQL (0.6ms)[0m [0mCOMMIT[0m | |
| Cache delete: Spree::Config | |
| [4;36;1mSQL (0.6ms)[0m [0;1mSHOW TABLES[0m | |
| [4;35;1mUser Columns (1.7ms)[0m [0mSHOW FIELDS FROM `users`[0m |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment