Last active
December 11, 2015 10:08
-
-
Save rubyonrailsworks/4584649 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
| Started GET "/api/trades?trade_type=all" for 127.0.0.1 at 2013-01-21 16:38:32 +0800 | |
| Processing by TradesController#index as JSON | |
| Parameters: {"trade_type"=>"all"} | |
| User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 6 LIMIT 1 | |
| (0.2ms) SELECT COUNT(*) FROM `roles` INNER JOIN `users_roles` ON `roles`.`id` = `users_roles`.`role_id` WHERE `users_roles`.`user_id` = 6 AND (((roles.name = 'seller') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL))) | |
| (0.2ms) SELECT COUNT(*) FROM `roles` INNER JOIN `users_roles` ON `roles`.`id` = `users_roles`.`role_id` WHERE `users_roles`.`user_id` = 6 AND (((roles.name = 'interface') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL))) | |
| (0.2ms) SELECT COUNT(*) FROM `roles` INNER JOIN `users_roles` ON `roles`.`id` = `users_roles`.`role_id` WHERE `users_roles`.`user_id` = 6 AND (((roles.name = 'logistic') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL))) | |
| MOPED: 127.0.0.1:27017 COMMAND database=admin command={:ismaster=>1} (0.4878ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"trades", :query=>{"deleted_at"=>nil, "$or"=>[{"has_buyer_message"=>{"$ne"=>true}}, {"buyer_message"=>{"$ne"=>nil}}]}} (18812.7425ms) | |
| MOPED: 127.0.0.1:27017 QUERY database=magicalpha collection=trades selector={"$query"=>{"deleted_at"=>nil, "$or"=>[{"has_buyer_message"=>{"$ne"=>true}}, {"buyer_message"=>{"$ne"=>nil}}]}, "$orderby"=>{"created"=>-1}} flags=[:slave_ok] limit=20 skip=0 batch_size=nil fields=nil (25171.7350ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94dab9a240e9d1802e160"}} (6.9788ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94dab9a240e9d1802e15d"}} (0.5882ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e15a"}} (0.5953ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e158"}} (0.5674ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e152"}} (0.5560ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e155"}} (0.5603ms) | |
| Seller Load (2.2ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` IS NULL LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e150"}} (0.6235ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e14a"}} (0.5872ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e14c"}} (0.5469ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e146"}} (0.5143ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e148"}} (0.5071ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e144"}} (0.5095ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` IS NULL LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e142"}} (0.5679ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e13f"}} (0.6354ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e13a"}} (0.5462ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e13d"}} (0.5393ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e138"}} (0.7083ms) | |
| Seller Load (0.2ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 683 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e136"}} (0.5770ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e134"}} (0.4973ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94daa9a240e9d1802e132"}} (0.8256ms) | |
| Rendered trades/index.json.jbuilder (25461.1ms) | |
| Completed 200 OK in 44439ms (Views: 25478.7ms | ActiveRecord: 3.2ms) |
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
| Started GET "/api/trades?trade_type=" for 127.0.0.1 at 2013-01-21 17:11:15 +0800 | |
| Processing by TradesController#index as JSON | |
| Parameters: {"trade_type"=>""} | |
| User Load (0.3ms) SELECT `users`.* FROM `users` WHERE `users`.`id` = 1182 LIMIT 1 | |
| (0.2ms) SELECT COUNT(*) FROM `roles` INNER JOIN `users_roles` ON `roles`.`id` = `users_roles`.`role_id` WHERE `users_roles`.`user_id` = 1182 AND (((roles.name = 'seller') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL))) | |
| Seller Load (0.4ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| Seller Load (36.4ms) SELECT `sellers`.* FROM `sellers` WHERE (`sellers`.`lft` >= 10 AND `sellers`.`lft` < 11) ORDER BY `sellers`.`lft` | |
| (2.2ms) SELECT COUNT(*) FROM `roles` INNER JOIN `users_roles` ON `roles`.`id` = `users_roles`.`role_id` WHERE `users_roles`.`user_id` = 1182 AND (((roles.name = 'logistic') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL))) | |
| CACHE (0.0ms) SELECT COUNT(*) FROM `roles` INNER JOIN `users_roles` ON `roles`.`id` = `users_roles`.`role_id` WHERE `users_roles`.`user_id` = 1182 AND (((roles.name = 'seller') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL))) | |
| (0.2ms) SELECT COUNT(*) FROM `roles` INNER JOIN `users_roles` ON `roles`.`id` = `users_roles`.`role_id` WHERE `users_roles`.`user_id` = 1182 AND (((roles.name = 'cs') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL))) | |
| (0.3ms) SELECT COUNT(*) FROM `roles` INNER JOIN `users_roles` ON `roles`.`id` = `users_roles`.`role_id` WHERE `users_roles`.`user_id` = 1182 AND (((roles.name = 'admin') AND (roles.resource_type IS NULL) AND (roles.resource_id IS NULL))) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"trades", :query=>{"deleted_at"=>nil, "seller_id"=>{"$in"=>[1720]}, "dispatched_at"=>{"$ne"=>nil}, "status"=>{"$in"=>["WAIT_SELLER_SEND_GOODS", "WAIT_SELLER_DELIVERY", "WAIT_SELLER_STOCK_OUT"]}, "$or"=>[{"has_buyer_message"=>{"$ne"=>true}}, {"buyer_message"=>{"$ne"=>nil}}]}} (24590.4770ms) | |
| MOPED: 127.0.0.1:27017 QUERY database=magicalpha collection=trades selector={"$query"=>{"deleted_at"=>nil, "seller_id"=>{"$in"=>[1720]}, "dispatched_at"=>{"$ne"=>nil}, "status"=>{"$in"=>["WAIT_SELLER_SEND_GOODS", "WAIT_SELLER_DELIVERY", "WAIT_SELLER_STOCK_OUT"]}, "$or"=>[{"has_buyer_message"=>{"$ne"=>true}}, {"buyer_message"=>{"$ne"=>nil}}]}, "$orderby"=>{"created"=>-1}} flags=[:slave_ok] limit=20 skip=0 batch_size=nil fields=nil (20786.6416ms) | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da99a240e9d1802e0ec"}} (3.5748ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da99a240e9d1802e0e6"}} (0.6559ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da89a240e9d1802e0e0"}} (0.8807ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da89a240e9d1802e0c8"}} (0.5648ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da89a240e9d1802e0ad"}} (0.5536ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e5189f1d41c8abea000001"}} (0.5727ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da69a240e9d1802e04f"}} (0.7639ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da69a240e9d1802e033"}} (0.5503ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da69a240e9d1802e02f"}} (0.5548ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da69a240e9d1802e01c"}} (0.5558ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da59a240e9d1802dff8"}} (0.5946ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da59a240e9d1802dffa"}} (0.6170ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da59a240e9d1802dfce"}} (0.5636ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da49a240e9d1802dfb9"}} (0.5755ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da49a240e9d1802df7a"}} (0.6363ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da39a240e9d1802df57"}} (0.5622ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da39a240e9d1802df37"}} (0.7000ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da29a240e9d1802df00"}} (0.5746ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da29a240e9d1802deea"}} (0.7911ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| MOPED: 127.0.0.1:27017 COMMAND database=magicalpha command={:count=>"deliver_bills", :query=>{"trade_id"=>"50e94da19a240e9d1802debf"}} (0.7932ms) | |
| CACHE (0.0ms) SELECT `sellers`.* FROM `sellers` WHERE `sellers`.`id` = 1720 LIMIT 1 | |
| Rendered trades/index.json.jbuilder (21047.9ms) | |
| Completed 200 OK in 46138ms (Views: 21453.2ms | ActiveRecord: 40.1ms) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment