Skip to content

Instantly share code, notes, and snippets.

@schof

schof/gist:235557

Created November 15, 2009 23:07
Show Gist options
  • Save schof/235557 to your computer and use it in GitHub Desktop.
Save schof/235557 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
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
Raw
gistfile2.txt
SELECT * 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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment