慢查询排行榜

事先申明 这项目不是我写ヾ(o◕∀◕)ﾉヾ

Profile
Rank Query ID                            Response time   Calls  R/Call  
==== =================================== =============== ====== ======= 
   1 0x43213F365998840ACD9C3079B9E87DAE  857789.5898 ... 230501  3.7214  0.47 SELECT com_order
   2 0xDF3E01C0AD745FDFF16601E364C36572  107786.6011 ...   7621 14.1434  8.21 SELECT com_order_step
   3 0x8F9F477B37A66516C7CD43B477D3A270  68362.6915  ...   3105 22.0170  4.60 UPDATE com_order_detail
   4 0x4A0BE95958C84E7A96EDFB2C21FB67C1  61784.0898  ...  18351  3.3668  0.05 SELECT com_order
   5 0x118C6D89A59CD6963430E2D2D19BB258  47610.6692  ...  11604  4.1030  0.19 SELECT com_order
   6 0xE53F09B2262794BEC6E2688CAA143431  45380.2740  ...  12985  3.4948  0.06 SELECT com_order com_goods_co
   7 0x2C3A955FE023BE233878F80DEBE1C7F5  45306.2355  ...  10324  4.3884  2.03 SELECT com_order
   8 0x881AF4FC304C67F886CE7F4B92F5F836  32297.1495  ...   2164 14.9247  2.56 SELECT com_order com_goods co
   9 0xE2B66B13B936E38828F345F8840CB173  17972.5383  ...    943 19.0589  3.67 SELECT com_order com_goods co
  10 0xBA63E58F684365ED5EF9EBECF6211154  12255.0037  ...    633 19.3602  1.64 SELECT com_order com_goods co
  11 0x9AF174602EBD35D03339D52BD6BA454A  6755.3975  0.5%    976  6.9215  0.58 SELECT com_goods com_order
  12 0xAE8DB0A6FE47D628D931A483CCAE8A75  6587.3134  0.5%    737  8.9380  3.80 SELECT com_order com_goods co
  13 0x41CD552DAEB5C20B6442CE78748915D4  6388.0521  0.5%   1074  5.9479  0.38 SELECT com_goods com_order
  14 0x5821670C589337A3F5230781CA62B830  5463.3930  0.4%   1452  3.7627  0.88 UPDATE com_order
  17 0x29284E1C020294A86F3B5089534E1F25  3770.1613  0.3%    130 29.0012  0.02 SELECT com_order com_goods co
  18 0x4FD4F24768F143A7E142658B51C74256  3136.3929  0.2%    285 11.0049  5.74 SELECT com_order com_goods co
  19 0x7D5D8A24C7C014336145D6174DD83F54  3082.0708  0.2%    183 16.8419  1.81 SELECT com_order com_goods co
  20 0x827B61B85C77531BFAD687333071E9C2  2498.9570  0.2%    640  3.9046  1.01 SELECT com_goods com_order
  21 0x92DB913CB9BC963C7C2815C23F00603E  2251.8580  0.2%     75 30.0248  0.00 INSERT com_order_step
  22 0x1E42A48C29626389B6911D90A3C7BE41  2137.8542  0.2%     69 30.9834  1.65 INSERT com_order_detail
  23 0x55FA21C415B57A8C8BEE934489C5C092  2030.6716  0.1%    486  4.1783  0.17 SELECT com_order com_goods co
  24 0xB7098BC79C0AF47C49F17C710D3D3357  1920.8152  0.1%     64 30.0127  0.00 INSERT com_order
  25 0x3718B70A1AD6C2B67B67703C6EBE839C  1704.2796  0.1%    456  3.7375  0.01 SELECT com_order
  26 0x1FA49422BC44151C0D4FA0D8AA44BB27  1659.9687  0.1%    120 13.8331  0.01 SELECT com_order com_goods co
  27 0x5A7C30146FFACC7F55CC11096B93B354  1607.1963  0.1%    442  3.6362  0.28 SELECT com_order
  30 0x43D8E9778CDD92BE946D19B37645F74C  1196.9710  0.1%    218  5.4907  2.59 SELECT com_order_detail com_o
  31 0xFB9EE232DEF62B88A9E803150ABE2D9D  1163.1644  0.1%     52 22.3685  3.58 SELECT ers_cash_list com_orde
  32 0x342763F4807710266FE036FD2AC058B9  1137.1729  0.1%     59 19.2741  4.43 SELECT ers_cash_list com_orde
  33 0x37AE68F96E70CDFF548417176CAEB2AF  1002.2846  0.1%    209  4.7956  0.64 SELECT com_goods com_order
  34 0xCFD2BFF2205FD63DD0FF201E7734D7FD   865.9522  0.1%    178  4.8649  0.17 SELECT com_goods com_order
  35 0x6AF371BEED556B36FD41230774042645   810.7413  0.1%     27 30.0275  0.00 UPDATE com_order
  36 0xFB49BD352A70DA19A7B45E49CA0FB56A   755.3083  0.1%     82  9.2111  0.01 SELECT com_order com_goods co
  37 0x591DFEABF77D53A9DB97E97F66DB2BCC   686.2606  0.0%    173  3.9668  0.22 SELECT com_order com_goods co
  38 0xAD6FBF179A5CC50419715DCE46FC7EB1   682.1636  0.0%    182  3.7482  0.11 SELECT ers_cash_list com_orde
  39 0xE360E29586DD3B1FA65F5AE61988A6CB   676.1795  0.0%    141  4.7956  0.24 SELECT com_order com_goods co
  40 0xCB8BD72D494052A7A56DD28BDDFDCBDC   657.7839  0.0%     87  7.5607  0.47 SELECT com_order com_goods co
  41 0xB1E04439EF51C794A915EB4866531585   537.9265  0.0%    153  3.5159  0.01 SELECT com_order com_goods co
  42 0x594D5C2699347573F74DE0CDC2CEFC32   529.2930  0.0%     20 26.4647  0.55 SELECT ers_cash_list com_orde
  43 0x27D2F92EBA60A1D41619A371781312A2   503.5509  0.0%     96  5.2453  0.00 SELECT com_order com_goods co
  44 0xD3F5CCA83C841835CC79BAE5E68A8CFF   496.4855  0.0%    132  3.7613  0.10 SELECT ers_cash_list com_orde
  45 0x7D3AA779A8224BC6F6C452E880162A64   475.0059  0.0%     55  8.6365  1.97 SELECT com_order_detail com_o
  46 0xB5A0A353B20D286F197F13E71BBAFC81   444.7246  0.0%    117  3.8011  0.37 SELECT com_order
  47 0xC695CA39DA1088B7ED82E1BEB33B4B7B   419.5935  0.0%     15 27.9729  0.46 SELECT ers_cash_list com_orde
  48 0xB10F790621F5CA1C97B99EAA126E00B2   346.4819  0.0%     17 20.3813  4.26 SELECT ers_cash_list com_orde
  50 0x0C170F407F3F8F9BA2A097013DF2317A   333.6224  0.0%     24 13.9009  2.32 SELECT ers_cash_list com_orde

就贴出前五十个,留作纪念;

• Mysql