sqlSleeping.txt 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899
  1. +-------+------------+-----------------------+-------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
  2. | Id | User | Host | db | Command | Time | State | Info | Progress |
  3. +-------+------------+-----------------------+-------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+
  4. | 30573 | wacs | localhost:60024 | bswas | Sleep | 32 | | | 0.000 |
  5. | 30574 | wacs | localhost:60026 | bswas | Sleep | 2 | | | 0.000 |
  6. | 30576 | wacs | localhost:60034 | bswas | Sleep | 8 | | | 0.000 |
  7. | 30578 | wacs | localhost:60044 | bswas | Sleep | 5 | | | 0.000 |
  8. | 30579 | wacs | localhost:60052 | bswas | Sleep | 26 | | | 0.000 |
  9. | 30580 | wacs | localhost:60054 | bswas | Sleep | 35 | | | 0.000 |
  10. | 30581 | wacs | localhost:60062 | bswas | Sleep | 5 | | | 0.000 |
  11. | 30582 | wacs | localhost:60066 | bswas | Sleep | 35 | | | 0.000 |
  12. | 30583 | wacs | localhost:60076 | bswas | Sleep | 2 | | | 0.000 |
  13. | 82709 | wacs | localhost:60110 | bswas | Sleep | 80 | | | 0.000 |
  14. | 83531 | wacs | localhost:36828 | bswas | Sleep | 5853 | | | 0.000 |
  15. | 83537 | wacs | localhost:36864 | bswas | Sleep | 5841 | | | 0.000 |
  16. | 83545 | wacs | localhost:36910 | bswas | Sleep | 5828 | | | 0.000 |
  17. | 83549 | wacs | localhost:36934 | bswas | Sleep | 5814 | | | 0.000 |
  18. | 83565 | wacs | localhost:37016 | bswas | Sleep | 5802 | | | 0.000 |
  19. | 83566 | wacs | localhost:37020 | bswas | Execute | 15 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  20. | 83571 | wacs | localhost:37054 | bswas | Sleep | 5789 | | | 0.000 |
  21. | 83580 | wacs | localhost:37106 | bswas | Sleep | 5774 | | | 0.000 |
  22. | 83587 | wacs | localhost:37150 | bswas | Sleep | 5761 | | | 0.000 |
  23. | 83596 | wacs | localhost:37208 | bswas | Sleep | 5748 | | | 0.000 |
  24. | 83610 | wacs | localhost:37288 | bswas | Sleep | 5735 | | | 0.000 |
  25. | 83792 | wacs | localhost:38180 | bswas | Sleep | 5491 | | | 0.000 |
  26. | 83793 | wacs | localhost:38184 | bswas | Execute | 16 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  27. | 83802 | wacs | localhost:38244 | bswas | Sleep | 5477 | | | 0.000 |
  28. | 83803 | wacs | localhost:38254 | bswas | Execute | 5 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  29. | 83811 | wacs | localhost:38302 | bswas | Sleep | 5464 | | | 0.000 |
  30. | 83812 | wacs | localhost:38310 | bswas | Execute | 7 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  31. | 83815 | wacs | localhost:38330 | bswas | Sleep | 5452 | | | 0.000 |
  32. | 83816 | wacs | localhost:38334 | bswas | Execute | 13 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  33. | 83826 | wacs | localhost:38386 | bswas | Sleep | 5439 | | | 0.000 |
  34. | 83827 | wacs | localhost:38390 | bswas | Execute | 6 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  35. | 83832 | wacs | localhost:38420 | bswas | Sleep | 5426 | | | 0.000 |
  36. | 83840 | wacs | localhost:38466 | bswas | Sleep | 5413 | | | 0.000 |
  37. | 83848 | wacs | localhost:38516 | bswas | Sleep | 5400 | | | 0.000 |
  38. | 83849 | wacs | localhost:38520 | bswas | Execute | 13 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  39. | 83853 | wacs | localhost:38548 | bswas | Sleep | 5387 | | | 0.000 |
  40. | 83854 | wacs | localhost:38552 | bswas | Execute | 1 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  41. | 83864 | wacs | localhost:38608 | bswas | Sleep | 5374 | | | 0.000 |
  42. | 83865 | wacs | localhost:38612 | bswas | Execute | 7 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  43. | 83868 | wacs | localhost:38632 | bswas | Sleep | 5361 | | | 0.000 |
  44. | 83876 | wacs | localhost:38676 | bswas | Sleep | 5348 | | | 0.000 |
  45. | 83881 | wacs | localhost:38706 | bswas | Sleep | 5335 | | | 0.000 |
  46. | 83882 | wacs | localhost:38710 | bswas | Execute | 5 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  47. | 83890 | wacs | localhost:38754 | bswas | Sleep | 5322 | | | 0.000 |
  48. | 83900 | wacs | localhost:38806 | bswas | Sleep | 5309 | | | 0.000 |
  49. | 83906 | wacs | localhost:38840 | bswas | Sleep | 5296 | | | 0.000 |
  50. | 83907 | wacs | localhost:38846 | bswas | Execute | 5 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  51. | 83915 | wacs | localhost:38902 | bswas | Sleep | 5283 | | | 0.000 |
  52. | 83920 | wacs | localhost:38934 | bswas | Sleep | 5270 | | | 0.000 |
  53. | 83932 | wacs | localhost:38996 | bswas | Sleep | 5257 | | | 0.000 |
  54. | 83933 | wacs | localhost:39000 | bswas | Execute | 9 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  55. | 83937 | wacs | localhost:39026 | bswas | Sleep | 5244 | | | 0.000 |
  56. | 83938 | wacs | localhost:39030 | bswas | Execute | 1 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  57. | 83946 | wacs | localhost:39078 | bswas | Sleep | 5231 | | | 0.000 |
  58. | 83953 | wacs | localhost:39124 | bswas | Sleep | 5218 | | | 0.000 |
  59. | 83959 | wacs | localhost:39160 | bswas | Sleep | 5205 | | | 0.000 |
  60. | 83986 | wacs | localhost:39302 | bswas | Sleep | 5179 | | | 0.000 |
  61. | 86075 | baoshiRoot | 180.174.192.107:59164 | bswas | Sleep | 1042 | | | 0.000 |
  62. | 87490 | wacs | localhost:58264 | bswas | Sleep | 1894 | | | 0.000 |
  63. | 87492 | wacs | localhost:58276 | bswas | Execute | 7 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  64. | 87552 | wacs | localhost:58548 | bswas | Sleep | 1868 | | | 0.000 |
  65. | 87594 | wacs | localhost:58736 | bswas | Sleep | 1855 | | | 0.000 |
  66. | 87634 | wacs | localhost:58920 | bswas | Sleep | 1842 | | | 0.000 |
  67. | 87635 | wacs | localhost:58924 | bswas | Execute | 10 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  68. | 87673 | wacs | localhost:59090 | bswas | Sleep | 1829 | | | 0.000 |
  69. | 87675 | wacs | localhost:59098 | bswas | Execute | 6 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  70. | 87687 | wacs | localhost:59158 | bswas | Sleep | 1814 | | | 0.000 |
  71. | 87690 | wacs | localhost:59166 | bswas | Execute | 9 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  72. | 87720 | wacs | localhost:59328 | bswas | Sleep | 1802 | | | 0.000 |
  73. | 87723 | wacs | localhost:59342 | bswas | Execute | 0 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  74. | 87736 | wacs | localhost:59426 | bswas | Sleep | 1789 | | | 0.000 |
  75. | 88693 | wacs | localhost:36806 | bswas | Sleep | 811 | | | 0.000 |
  76. | 88694 | wacs | localhost:36810 | bswas | Execute | 7 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  77. | 88710 | wacs | localhost:36900 | bswas | Sleep | 797 | | | 0.000 |
  78. | 88711 | wacs | localhost:36904 | bswas | Execute | 10 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  79. | 88750 | wacs | localhost:37078 | bswas | Sleep | 785 | | | 0.000 |
  80. | 88751 | wacs | localhost:37082 | bswas | Execute | 1 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  81. | 88765 | wacs | localhost:37168 | bswas | Sleep | 772 | | | 0.000 |
  82. | 88767 | wacs | localhost:37178 | bswas | Execute | 6 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  83. | 88780 | wacs | localhost:37266 | bswas | Sleep | 759 | | | 0.000 |
  84. | 88781 | wacs | localhost:37270 | bswas | Execute | 2 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  85. | 88795 | wacs | localhost:37360 | bswas | Sleep | 746 | | | 0.000 |
  86. | 88796 | wacs | localhost:37364 | bswas | Execute | 4 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  87. | 88818 | wacs | localhost:37492 | bswas | Sleep | 731 | | | 0.000 |
  88. | 88831 | wacs | localhost:37546 | bswas | Execute | 11 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  89. | 88842 | wacs | localhost:37628 | bswas | Sleep | 718 | | | 0.000 |
  90. | 88843 | wacs | localhost:37632 | bswas | Execute | 13 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  91. | 88854 | wacs | localhost:37704 | bswas | Sleep | 705 | | | 0.000 |
  92. | 88855 | wacs | localhost:37708 | bswas | Execute | 6 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  93. | 89075 | wacs | localhost:39056 | bswas | Sleep | 490 | | | 0.000 |
  94. | 89078 | wacs | localhost:39079 | bswas | Execute | 10 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  95. | 89084 | wacs | localhost:39122 | bswas | Sleep | 477 | | | 0.000 |
  96. | 89085 | wacs | localhost:39126 | bswas | Execute | 12 | Sending data | select * from `commodity_barcodes` where exists (select * from `commodities` where `commodity_barcod | 0.000 |
  97. | 89458 | wacs | localhost:41314 | bswas | Execute | 6 | Sending data | select order_issues.* ,order_issue_on_tops.id top_id ,order_issue_on_tops.remark,order_issue_on_tops | 0.000 |
  98. | 89465 | root | localhost | | Query | 0 | | show processlist | 0.000 |
  99. +-------+------------+-----------------------+-------+---------+------+--------------+------------------------------------------------------------------------------------------------------+----------+