API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jun 25th, 2018
87
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 183.47 KB | None | 0 0
raw download clone embed print report
  1. mysql> SHOW FULL PROCESSLIST;
  2. +----------+-----------------+-----------+-----------------+---------+------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  3. | Id | User | Host | db | Command | Time | State | Info |
  4. +----------+-----------------+-----------+-----------------+---------+------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  5. | 9740767 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 31 | | NULL |
  6. | 9740768 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 18 | | NULL |
  7. | 9740837 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  8. | 12017542 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  9. | 12019829 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  10. | 12081913 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  11. | 12082025 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  12. | 12082640 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  13. | 12082714 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 7 | | NULL |
  14. | 12083189 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  15. | 12083243 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 112 | | NULL |
  16. | 12083265 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  17. | 12083618 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  18. | 12084262 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  19. | 12084268 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  20. | 12084692 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  21. | 12084705 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  22. | 12084958 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  23. | 12085089 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 213 | | NULL |
  24. | 12085324 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  25. | 12085417 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  26. | 12085448 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  27. | 12085570 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  28. | 12085622 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 225 | | NULL |
  29. | 12085656 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  30. | 12085674 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  31. | 12085686 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 6 | | NULL |
  32. | 12085865 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 8 | | NULL |
  33. | 12085867 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  34. | 12085882 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  35. | 12085995 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  36. | 12085999 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  37. | 12086021 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 12 | | NULL |
  38. | 12086035 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 6 | | NULL |
  39. | 12086082 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  40. | 12086239 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  41. | 12086266 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 6 | | NULL |
  42. | 12086292 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 11 | | NULL |
  43. | 12086405 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  44. | 12086445 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  45. | 12086519 | root | localhost | NULL | Query | 0 | init | SHOW FULL PROCESSLIST |
  46. | 12086538 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  47. | 12086554 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  48. | 12086648 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 8 | | NULL |
  49. | 12086809 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  50. | 12086834 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  51. | 12086931 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 59 | | NULL |
  52. | 12086954 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  53. | 12086982 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  54. | 12087007 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 47 | | NULL |
  55. | 12087073 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  56. | 12087083 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  57. | 12087092 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  58. | 12087094 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 15 | | NULL |
  59. | 12087114 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  60. | 12087124 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  61. | 12087151 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  62. | 12087183 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  63. | 12087247 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  64. | 12087323 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  65. | 12087347 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  66. | 12087407 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 22 | | NULL |
  67. | 12087415 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  68. | 12087439 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  69. | 12087542 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  70. | 12087579 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  71. | 12087583 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 24 | | NULL |
  72. | 12087663 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  73. | 12087704 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  74. | 12087745 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  75. | 12087828 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 18 | | NULL |
  76. | 12087842 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 44 | | NULL |
  77. | 12087901 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  78. | 12087932 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  79. | 12087948 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 14 | | NULL |
  80. | 12087957 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 35 | | NULL |
  81. | 12088017 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 12 | | NULL |
  82. | 12088028 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  83. | 12088041 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  84. | 12088042 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 153 | | NULL |
  85. | 12088043 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  86. | 12088044 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 8 | | NULL |
  87. | 12088045 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 9 | | NULL |
  88. | 12088049 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  89. | 12088091 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 62 | | NULL |
  90. | 12088101 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  91. | 12088150 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  92. | 12088182 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  93. | 12088213 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  94. | 12088244 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 42 | | NULL |
  95. | 12088254 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 24 | | NULL |
  96. | 12088256 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  97. | 12088272 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  98. | 12088311 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  99. | 12088352 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  100. | 12088410 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  101. | 12088436 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  102. | 12088437 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 27 | | NULL |
  103. | 12088443 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  104. | 12088445 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  105. | 12088474 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  106. | 12088481 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  107. | 12088501 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  108. | 12088519 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  109. | 12088526 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 29 | | NULL |
  110. | 12088558 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  111. | 12088565 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  112. | 12088569 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 22 | | NULL |
  113. | 12088577 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 17 | | NULL |
  114. | 12088626 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 18 | | NULL |
  115. | 12088628 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  116. | 12088644 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  117. | 12088652 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 15 | | NULL |
  118. | 12088659 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  119. | 12088674 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  120. | 12088677 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  121. | 12088680 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  122. | 12088683 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  123. | 12088688 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  124. | 12088696 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  125. | 12088711 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  126. | 12088713 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  127. | 12088734 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  128. | 12088746 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  129. | 12088782 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 24 | | NULL |
  130. | 12088787 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  131. | 12088798 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  132. | 12088805 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  133. | 12088809 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  134. | 12088810 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 23 | | NULL |
  135. | 12088819 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  136. | 12088828 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  137. | 12088830 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  138. | 12088841 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  139. | 12088842 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  140. | 12088846 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  141. | 12088863 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 17 | | NULL |
  142. | 12088875 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  143. | 12088913 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  144. | 12088923 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  145. | 12088927 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  146. | 12088937 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  147. | 12088959 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  148. | 12088961 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  149. | 12088967 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  150. | 12088969 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  151. | 12088973 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  152. | 12088981 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  153. | 12088984 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 56 | | NULL |
  154. | 12088987 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  155. | 12088988 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  156. | 12088990 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  157. | 12088993 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  158. | 12088994 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  159. | 12088997 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  160. | 12088998 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  161. | 12089015 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 11 | | NULL |
  162. | 12089016 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 49 | | NULL |
  163. | 12089025 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  164. | 12089034 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 12 | | NULL |
  165. | 12089037 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  166. | 12089040 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  167. | 12089041 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  168. | 12089048 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  169. | 12089062 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 41 | | NULL |
  170. | 12089065 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 41 | | NULL |
  171. | 12089066 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 34 | | NULL |
  172. | 12089068 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 41 | | NULL |
  173. | 12089069 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 41 | | NULL |
  174. | 12089070 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 37 | | NULL |
  175. | 12089076 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  176. | 12089083 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  177. | 12089084 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  178. | 12089086 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  179. | 12089087 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  180. | 12089088 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  181. | 12089089 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  182. | 12089090 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 40 | | NULL |
  183. | 12089093 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  184. | 12089101 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 6 | | NULL |
  185. | 12089117 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  186. | 12089121 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  187. | 12089129 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  188. | 12089132 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  189. | 12089135 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 33 | | NULL |
  190. | 12089136 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 33 | | NULL |
  191. | 12089142 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  192. | 12089147 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  193. | 12089148 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  194. | 12089150 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  195. | 12089167 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 8 | | NULL |
  196. | 12089170 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  197. | 12089172 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  198. | 12089177 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  199. | 12089179 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  200. | 12089180 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  201. | 12089181 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  202. | 12089185 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  203. | 12089190 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  204. | 12089198 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 20 | | NULL |
  205. | 12089200 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 20 | | NULL |
  206. | 12089201 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 20 | | NULL |
  207. | 12089203 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 20 | | NULL |
  208. | 12089208 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  209. | 12089211 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  210. | 12089214 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 19 | | NULL |
  211. | 12089215 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  212. | 12089216 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  213. | 12089218 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  214. | 12089219 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  215. | 12089222 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  216. | 12089224 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 6 | | NULL |
  217. | 12089225 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  218. | 12089227 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  219. | 12089228 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  220. | 12089230 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  221. | 12089232 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 18 | | NULL |
  222. | 12089237 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  223. | 12089239 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 6 | | NULL |
  224. | 12089240 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  225. | 12089241 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  226. | 12089243 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  227. | 12089244 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 4 | | NULL |
  228. | 12089245 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  229. | 12089246 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  230. | 12089247 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  231. | 12089248 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 12 | | NULL |
  232. | 12089249 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  233. | 12089250 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  234. | 12089251 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  235. | 12089252 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  236. | 12089256 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  237. | 12089257 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  238. | 12089258 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 13 | | NULL |
  239. | 12089259 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 6 | | NULL |
  240. | 12089260 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 12 | | NULL |
  241. | 12089263 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 12 | | NULL |
  242. | 12089264 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 12 | | NULL |
  243. | 12089267 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 12 | | NULL |
  244. | 12089268 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  245. | 12089270 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  246. | 12089271 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  247. | 12089272 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  248. | 12089279 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  249. | 12089281 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  250. | 12089283 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  251. | 12089284 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  252. | 12089287 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  253. | 12089288 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 6 | | NULL |
  254. | 12089290 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  255. | 12089293 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  256. | 12089294 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 6 | | NULL |
  257. | 12089295 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 2 | | NULL |
  258. | 12089296 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 0 | | NULL |
  259. | 12089298 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  260. | 12089300 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  261. | 12089301 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  262. | 12089302 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 1 | | NULL |
  263. | 12089303 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  264. | 12089305 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 5 | | NULL |
  265. | 12089308 | myinstar_ranker | localhost | myinstar_ranker | Sleep | 3 | | NULL |
  266. | 12089313 | myinstar_ranker | localhost | myinstar_ranker | Query | 0 | Sending data | SELECT
  267. count(1)
  268. AS `counter`
  269. FROM `status` `s1`
  270. LEFT JOIN (`status`) on(((`status`.`user_id` = `s1`.`user_id`)
  271. AND (`status`.`ptype` = 'u')
  272. AND (`status`.`md5id` = '8be8d176473d27dbbbaaa856288fa6dd')))
  273. left Join unfollow_blacklisted ub On ub.md5id = s1.md5id and ub.user_name = s1.user_name
  274. WHERE ((`s1`.`md5id` = '8be8d176473d27dbbbaaa856288fa6dd')
  275. AND (`s1`.`ptype` = 'f')
  276. AND status.md5id IS NULL
  277. AND ub.id is NULL
  278. AND (`s1`.`date` < ((now() - interval 3 DAY)))) |
  279. +----------+-----------------+-----------+-----------------+---------+------+--------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  280. 262 rows in set (0.00 sec)
  281.  
  282. mysql>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!