下面的进程
+------+----------------------+----------------+--------+---------+------+------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+----------------------+----------------+--------+---------+------+------------------+------------------------------------------------------------------------------------------------------+
| 5543 | root | localhost:2239 | cnbaidou | Sleep | 49 | | |
| 5549 | root | localhost:2247 | cnbaidou | Sleep | 13 | | |
| 5550 | root | localhost:2245 | cnbaidou | Sleep | 21 | | |
| 5580 | root | localhost:2269 | cnbaidou | Sleep | 35 | | |
| 5647 | root | localhost:2343 | cnbaidou | Sleep | 11 | | |
| 5666 | root | localhost:2362 | cnbaidou | Sleep | 8 | | |
| 5679 | root | localhost:2375 | cnbaidou | Sleep | 1 | | |
| 5681 | root | localhost:2377 | cnbaidou | Sleep | 2 | | |
| 5685 | root | localhost:2381 | cnbaidou | Sleep | 1 | | |
| 5692 | root | localhost:2389 | cnbaidou | Sleep | 1 | | |
| 5689 | root | localhost:2385 | cnbaidou | Sleep | 1 | | |
| 5699 | root | localhost:2395 | cnbaidou | Sleep | 6 | | |
| 5702 | root | localhost:2396 | cnbaidou | Sleep | 0 | | |
| 5704 | root | localhost:2399 | cnbaidou | Sleep | 0 | | |
| 5703 | root | localhost:2400 | cnbaidou | Sleep | 0 | | |
| 5712 | root | localhost:2409 | cnbaidou | Sleep | 0 | | |
| 5711 | root | localhost:2408 | cnbaidou | Sleep | 1 | | |
| 5715 | root | localhost:2411 | cnbaidou | Sleep | 0 | | |
| 5714 | cnyichun | localhost:2410 | yichun | Sleep | 1 | | |
| 5718 | root | localhost:2414 | cnbaidou | Query | 0 | | select * from company where compID=1159 |
| 5716 | root | localhost:2412 | cnbaidou | Sleep | 0 | | |
| 5720 | root | localhost:2415 | cnbaidou | Sleep | 1 | | |
| 5719 | root | localhost:2416 | cnbaidou | Query | 0 | Sorting result | select * from daycount where menutype = '34' and dc_type like '%p%' order by dc_count desc limit |
| 5722 | root | localhost:2418 | cnbaidou | Query | 0 | freeing items | select count(*) as thecount from daycount where dc_type = 'total' and dc_time = '2007-06-13' and com |
| 5721 | cnyichun | localhost:2417 | yichun | Sleep | 1 | | |
| 5724 | cnyichun | localhost:2420 | | Sleep | 1 | | |
| 5726 | root | localhost:2423 | cnbaidou | Sleep | 1 | | |
| 5725 | root | localhost:2421 | | Sleep | 0 | | |
| 5727 | unauthenticated user | localhost:2424 | | Connect | | Reading from net | |
| 5729 | root | localhost:2422 | cnbaidou | Sleep | 0 | | |
| 5728 | root | localhost:2425 | | Query | 0 | | show processlist |
| 5732 | root | localhost:2430 | cnbaidou | Sleep | 0 | | |
| 5731 | root | localhost:2429 | cnbaidou | Sleep | 0 | | |
| 5730 | unauthenticated user | localhost:2426 | | Connect | | Reading from net | |
+------+----------------------+----------------+--------+---------+------+------------------+------------------------------------------------------------------------------------------------------+
+------+----------------------+----------------+--------+---------+------+------------------+------------------------------------------------------------------------------------------------------+
| Id | User | Host | db | Command | Time | State | Info |
+------+----------------------+----------------+--------+---------+------+------------------+------------------------------------------------------------------------------------------------------+
| 5543 | root | localhost:2239 | cnbaidou | Sleep | 49 | | |
| 5549 | root | localhost:2247 | cnbaidou | Sleep | 13 | | |
| 5550 | root | localhost:2245 | cnbaidou | Sleep | 21 | | |
| 5580 | root | localhost:2269 | cnbaidou | Sleep | 35 | | |
| 5647 | root | localhost:2343 | cnbaidou | Sleep | 11 | | |
| 5666 | root | localhost:2362 | cnbaidou | Sleep | 8 | | |
| 5679 | root | localhost:2375 | cnbaidou | Sleep | 1 | | |
| 5681 | root | localhost:2377 | cnbaidou | Sleep | 2 | | |
| 5685 | root | localhost:2381 | cnbaidou | Sleep | 1 | | |
| 5692 | root | localhost:2389 | cnbaidou | Sleep | 1 | | |
| 5689 | root | localhost:2385 | cnbaidou | Sleep | 1 | | |
| 5699 | root | localhost:2395 | cnbaidou | Sleep | 6 | | |
| 5702 | root | localhost:2396 | cnbaidou | Sleep | 0 | | |
| 5704 | root | localhost:2399 | cnbaidou | Sleep | 0 | | |
| 5703 | root | localhost:2400 | cnbaidou | Sleep | 0 | | |
| 5712 | root | localhost:2409 | cnbaidou | Sleep | 0 | | |
| 5711 | root | localhost:2408 | cnbaidou | Sleep | 1 | | |
| 5715 | root | localhost:2411 | cnbaidou | Sleep | 0 | | |
| 5714 | cnyichun | localhost:2410 | yichun | Sleep | 1 | | |
| 5718 | root | localhost:2414 | cnbaidou | Query | 0 | | select * from company where compID=1159 |
| 5716 | root | localhost:2412 | cnbaidou | Sleep | 0 | | |
| 5720 | root | localhost:2415 | cnbaidou | Sleep | 1 | | |
| 5719 | root | localhost:2416 | cnbaidou | Query | 0 | Sorting result | select * from daycount where menutype = '34' and dc_type like '%p%' order by dc_count desc limit |
| 5722 | root | localhost:2418 | cnbaidou | Query | 0 | freeing items | select count(*) as thecount from daycount where dc_type = 'total' and dc_time = '2007-06-13' and com |
| 5721 | cnyichun | localhost:2417 | yichun | Sleep | 1 | | |
| 5724 | cnyichun | localhost:2420 | | Sleep | 1 | | |
| 5726 | root | localhost:2423 | cnbaidou | Sleep | 1 | | |
| 5725 | root | localhost:2421 | | Sleep | 0 | | |
| 5727 | unauthenticated user | localhost:2424 | | Connect | | Reading from net | |
| 5729 | root | localhost:2422 | cnbaidou | Sleep | 0 | | |
| 5728 | root | localhost:2425 | | Query | 0 | | show processlist |
| 5732 | root | localhost:2430 | cnbaidou | Sleep | 0 | | |
| 5731 | root | localhost:2429 | cnbaidou | Sleep | 0 | | |
| 5730 | unauthenticated user | localhost:2426 | | Connect | | Reading from net | |
+------+----------------------+----------------+--------+---------+------+------------------+------------------------------------------------------------------------------------------------------+
看看单独执行此查询需要多长时间?是否需要优化?新建索引可提高查询速度。分析:
explain select * from daycount where menutype = '34 ' and dc_type like '%p% ' order by dc_count desc