localhost
Show Full Queries ID User Host Database Command Time Status SQL query
Kill 19467223 debian-sys-maint localhost 3rs Query 7227 Sorting index OPTIMIZE TABLE `items`
Kill 19467233 threeruser1 localhost 3rs Query 7226 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19469823 threeruser1 localhost 3rs Query 6914 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470300 threeruser1 localhost 3rs Query 6848 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470817 threeruser1 localhost 3rs Query 6786 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19471719 threeruser1 localhost 3rs Query 6720 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19472570 threeruser1 localhost 3rs Query 6657 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473392 threeruser1 localhost 3rs Query 6595 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473735 threeruser1 localhost 3rs Query 6532 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19474538 threeruser1 localhost 3rs Query 6472 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19475380 threeruser1 localhost 3rs Query 6409 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476200 threeruser1 localhost 3rs Query 6347 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476832 threeruser1 localhost 3rs Query 6282 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19477551 threeruser1 localhost 3rs Query 6220 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19478375 threeruser1 localhost 3rs Query 6159 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19479205 threeruser1 localhost 3rs Query 6097 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480097 threeruser1 localhost 3rs Query 6032 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480940 threeruser1 localhost 3rs Query 5968 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19481743 threeruser1 localhost 3rs Query 5908 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19482592 threeruser1 localhost 3rs Query 5845 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483408 threeruser1 localhost 3rs Query 5785 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483898 threeruser1 localhost 3rs Query 5720 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19484742 threeruser1 localhost 3rs Query 5657 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19485585 threeruser1 localhost 3rs Query 5594 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19486419 threeruser1 localhost 3rs Query 5532 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487180 threeruser1 localhost 3rs Query 5469 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487653 threeruser1 localhost 3rs Query 5407 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19488253 threeruser1 localhost 3rs Query 5345 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489091 threeruser1 localhost 3rs Query 5282 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489953 threeruser1 localhost 3rs Query 5218 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19490825 threeruser1 localhost 3rs Query 5153 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19491681 threeruser1 localhost 3rs Query 5087 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492197 threeruser1 localhost 3rs Query 5022 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492820 threeruser1 localhost 3rs Query 4960 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493465 threeruser1 localhost 3rs Query 4894 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493969 threeruser1 localhost 3rs Query 4834 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19494785 threeruser1 localhost 3rs Query 4773 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19495607 threeruser1 localhost 3rs Query 4712 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19496203 threeruser1 localhost 3rs Query 4649 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497048 threeruser1 localhost 3rs Query 4586 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497855 threeruser1 localhost 3rs Query 4526 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19498528 threeruser1 localhost 3rs Query 4461 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19499400 threeruser1 localhost 3rs Query 4395 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19500246 threeruser1 localhost 3rs Query 4332 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501127 threeruser1 localhost 3rs Query 4267 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501916 threeruser1 localhost 3rs Query 4204 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19502793 threeruser1 localhost 3rs Query 4139 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19503668 threeruser1 localhost 3rs Query 4075 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504484 threeruser1 localhost 3rs Query 4009 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504895 threeruser1 localhost 3rs Query 3946 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19505741 threeruser1 localhost 3rs Query 3883 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506593 threeruser1 localhost 3rs Query 3820 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506742 threeruser1 localhost 3rs Query 3809 Waiting for table metadata lock SELECT *
FROM items
WHERE TYPE = "Lessons"
AND categories LIKE "%460%"
ORDER BY id ASC
Kill 19507467 threeruser1 localhost 3rs Query 3755 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19508243 threeruser1 localhost 3rs Query 3691 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19508614 threeruser1 localhost 3rs Query 3630 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19509267 threeruser1 localhost 3rs Query 3570 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19510142 threeruser1 localhost 3rs Query 3505 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19511018 threeruser1 localhost 3rs Query 3439 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19511659 threeruser1 localhost 3rs Query 3379 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19512496 threeruser1 localhost 3rs Query 3317 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19513332 threeruser1 localhost 3rs Query 3255 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19514134 threeruser1 localhost 3rs Query 3192 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19515017 threeruser1 localhost 3rs Query 3127 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19515820 threeruser1 localhost 3rs Query 3067 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19516503 threeruser1 localhost 3rs Query 3003 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19517301 threeruser1 localhost 3rs Query 2941 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19518150 threeruser1 localhost 3rs Query 2877 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19518982 threeruser1 localhost 3rs Query 2816 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19519471 threeruser1 localhost 3rs Query 2751 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19520101 threeruser1 localhost 3rs Query 2688 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19520947 threeruser1 localhost 3rs Query 2625 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19521789 threeruser1 localhost 3rs Query 2563 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19522630 threeruser1 localhost 3rs Query 2500 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19523317 threeruser1 localhost 3rs Query 2435 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19523767 threeruser1 localhost 3rs Query 2370 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19524494 threeruser1 localhost 3rs Query 2308 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19525339 threeruser1 localhost 3rs Query 2245 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19526158 threeruser1 localhost 3rs Query 2185 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19526878 threeruser1 localhost 3rs Query 2123 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19527550 threeruser1 localhost 3rs Query 2058 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19528396 threeruser1 localhost 3rs Query 1994 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19529173 threeruser1 localhost 3rs Query 1934 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19530445 threeruser1 localhost 3rs Query 1805 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19531263 threeruser1 localhost 3rs Query 1744 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19532149 threeruser1 localhost 3rs Query 1679 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19532687 threeruser1 localhost 3rs Query 1615 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19533438 threeruser1 localhost 3rs Query 1549 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19534273 threeruser1 localhost 3rs Query 1487 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19535127 threeruser1 localhost 3rs Query 1422 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19535898 threeruser1 localhost 3rs Query 1357 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19536500 threeruser1 localhost 3rs Query 1292 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19537320 threeruser1 localhost 3rs Query 1230 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19538166 threeruser1 localhost 3rs Query 1168 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19539023 threeruser1 localhost 3rs Query 1103 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19539826 threeruser1 localhost 3rs Query 1043 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19540662 threeruser1 localhost 3rs Query 981 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19541464 threeruser1 localhost 3rs Query 919 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19542292 threeruser1 localhost 3rs Query 857 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19542872 threeruser1 localhost 3rs Query 796 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19543359 threeruser1 localhost 3rs Query 734 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19543610 threeruser1 localhost 3rs Query 671 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19544477 threeruser1 localhost 3rs Query 606 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19545191 threeruser1 localhost 3rs Query 541 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19545818 threeruser1 localhost 3rs Query 479 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19546696 threeruser1 localhost 3rs Query 414 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19547373 threeruser1 localhost 3rs Query 353 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19547694 threeruser1 localhost 3rs Query 287 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19548426 threeruser1 localhost 3rs Query 225 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19549300 threeruser1 localhost 3rs Query 160 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19550149 threeruser1 localhost 3rs Query 96 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19550962 threeruser1 localhost 3rs Query 36 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19551440 threeruser1 localhost mysql Query 0 --- SHOW PROCESSLIST