localhost
Show Full Queries ID User Host Database Command Time Status SQL query
Kill 19467223 debian-sys-maint localhost 3rs Query 8971 Sorting index OPTIMIZE TABLE `items`
Kill 19467233 threeruser1 localhost 3rs Query 8970 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19469823 threeruser1 localhost 3rs Query 8658 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470300 threeruser1 localhost 3rs Query 8592 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470817 threeruser1 localhost 3rs Query 8530 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19471719 threeruser1 localhost 3rs Query 8464 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19472570 threeruser1 localhost 3rs Query 8401 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473392 threeruser1 localhost 3rs Query 8339 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473735 threeruser1 localhost 3rs Query 8276 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19474538 threeruser1 localhost 3rs Query 8216 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19475380 threeruser1 localhost 3rs Query 8153 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476200 threeruser1 localhost 3rs Query 8091 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476832 threeruser1 localhost 3rs Query 8026 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19477551 threeruser1 localhost 3rs Query 7964 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19478375 threeruser1 localhost 3rs Query 7903 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19479205 threeruser1 localhost 3rs Query 7841 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480097 threeruser1 localhost 3rs Query 7776 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480940 threeruser1 localhost 3rs Query 7712 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19481743 threeruser1 localhost 3rs Query 7652 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19482592 threeruser1 localhost 3rs Query 7589 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483408 threeruser1 localhost 3rs Query 7529 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483898 threeruser1 localhost 3rs Query 7464 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19484742 threeruser1 localhost 3rs Query 7401 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19485585 threeruser1 localhost 3rs Query 7338 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19486419 threeruser1 localhost 3rs Query 7276 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487180 threeruser1 localhost 3rs Query 7213 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487653 threeruser1 localhost 3rs Query 7151 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19488253 threeruser1 localhost 3rs Query 7089 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489091 threeruser1 localhost 3rs Query 7026 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489953 threeruser1 localhost 3rs Query 6962 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19490825 threeruser1 localhost 3rs Query 6897 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19491681 threeruser1 localhost 3rs Query 6831 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492197 threeruser1 localhost 3rs Query 6766 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492820 threeruser1 localhost 3rs Query 6704 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493465 threeruser1 localhost 3rs Query 6638 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493969 threeruser1 localhost 3rs Query 6578 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19494785 threeruser1 localhost 3rs Query 6517 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19495607 threeruser1 localhost 3rs Query 6456 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19496203 threeruser1 localhost 3rs Query 6393 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497048 threeruser1 localhost 3rs Query 6330 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497855 threeruser1 localhost 3rs Query 6270 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19498528 threeruser1 localhost 3rs Query 6205 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19499400 threeruser1 localhost 3rs Query 6139 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19500246 threeruser1 localhost 3rs Query 6076 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501127 threeruser1 localhost 3rs Query 6011 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501916 threeruser1 localhost 3rs Query 5948 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19502793 threeruser1 localhost 3rs Query 5883 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19503668 threeruser1 localhost 3rs Query 5819 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504484 threeruser1 localhost 3rs Query 5753 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504895 threeruser1 localhost 3rs Query 5690 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19505741 threeruser1 localhost 3rs Query 5627 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506593 threeruser1 localhost 3rs Query 5564 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506742 threeruser1 localhost 3rs Query 5553 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 5499 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19508243 threeruser1 localhost 3rs Query 5435 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19508614 threeruser1 localhost 3rs Query 5374 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19509267 threeruser1 localhost 3rs Query 5314 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19510142 threeruser1 localhost 3rs Query 5249 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19511018 threeruser1 localhost 3rs Query 5183 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19511659 threeruser1 localhost 3rs Query 5123 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19512496 threeruser1 localhost 3rs Query 5061 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19513332 threeruser1 localhost 3rs Query 4999 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19514134 threeruser1 localhost 3rs Query 4936 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19515017 threeruser1 localhost 3rs Query 4871 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19515820 threeruser1 localhost 3rs Query 4811 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19516503 threeruser1 localhost 3rs Query 4747 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19517301 threeruser1 localhost 3rs Query 4685 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19518150 threeruser1 localhost 3rs Query 4621 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19518982 threeruser1 localhost 3rs Query 4560 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19519471 threeruser1 localhost 3rs Query 4495 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19520101 threeruser1 localhost 3rs Query 4432 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19520947 threeruser1 localhost 3rs Query 4369 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19521789 threeruser1 localhost 3rs Query 4307 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19522630 threeruser1 localhost 3rs Query 4244 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19523317 threeruser1 localhost 3rs Query 4179 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19523767 threeruser1 localhost 3rs Query 4114 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19524494 threeruser1 localhost 3rs Query 4052 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19525339 threeruser1 localhost 3rs Query 3989 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19526158 threeruser1 localhost 3rs Query 3929 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19526878 threeruser1 localhost 3rs Query 3867 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19527550 threeruser1 localhost 3rs Query 3802 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19528396 threeruser1 localhost 3rs Query 3738 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19529173 threeruser1 localhost 3rs Query 3678 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19530445 threeruser1 localhost 3rs Query 3549 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19531263 threeruser1 localhost 3rs Query 3488 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19532149 threeruser1 localhost 3rs Query 3423 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19532687 threeruser1 localhost 3rs Query 3359 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19533438 threeruser1 localhost 3rs Query 3293 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19534273 threeruser1 localhost 3rs Query 3231 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19535127 threeruser1 localhost 3rs Query 3166 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19535898 threeruser1 localhost 3rs Query 3101 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19536500 threeruser1 localhost 3rs Query 3036 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19537320 threeruser1 localhost 3rs Query 2974 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19538166 threeruser1 localhost 3rs Query 2912 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19539023 threeruser1 localhost 3rs Query 2847 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19539826 threeruser1 localhost 3rs Query 2787 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19540662 threeruser1 localhost 3rs Query 2725 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19541464 threeruser1 localhost 3rs Query 2663 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19542292 threeruser1 localhost 3rs Query 2601 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19542872 threeruser1 localhost 3rs Query 2540 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19543359 threeruser1 localhost 3rs Query 2478 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19543610 threeruser1 localhost 3rs Query 2415 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19544477 threeruser1 localhost 3rs Query 2350 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19545191 threeruser1 localhost 3rs Query 2285 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19545818 threeruser1 localhost 3rs Query 2223 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19546696 threeruser1 localhost 3rs Query 2158 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19547373 threeruser1 localhost 3rs Query 2097 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19547694 threeruser1 localhost 3rs Query 2031 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19548426 threeruser1 localhost 3rs Query 1969 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19549300 threeruser1 localhost 3rs Query 1904 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19550149 threeruser1 localhost 3rs Query 1840 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19550962 threeruser1 localhost 3rs Query 1780 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19551791 threeruser1 localhost 3rs Query 1718 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19552673 threeruser1 localhost 3rs Query 1654 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19553473 threeruser1 localhost 3rs Query 1594 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19554318 threeruser1 localhost 3rs Query 1530 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19555044 threeruser1 localhost 3rs Query 1466 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19555874 threeruser1 localhost 3rs Query 1404 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19556662 threeruser1 localhost 3rs Query 1341 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557045 threeruser1 localhost 3rs Query 1276 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557389 threeruser1 localhost 3rs Query 1211 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557456 threeruser1 localhost 3rs Query 1150 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557562 threeruser1 localhost 3rs Query 1115 Waiting for table metadata lock SELECT *
FROM items
WHERE TYPE = "Resources"
AND categories LIKE "%130%"
ORDER BY id ASC
Kill 19557643 threeruser1 localhost 3rs Query 1090 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557844 threeruser1 localhost 3rs Query 1025 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19558034 threeruser1 localhost 3rs Query 964 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19558238 threeruser1 localhost 3rs Query 900 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19558583 threeruser1 localhost 3rs Query 830 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19559347 threeruser1 localhost 3rs Query 771 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19560205 threeruser1 localhost 3rs Query 706 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19560848 threeruser1 localhost 3rs Query 646 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19561588 threeruser1 localhost 3rs Query 585 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19562467 threeruser1 localhost 3rs Query 520 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19563333 threeruser1 localhost 3rs Query 454 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19563770 threeruser1 localhost 3rs Query 421 Waiting for table metadata lock SELECT *
FROM items
WHERE TYPE = "Lessons"
AND categories LIKE "%120%"
ORDER BY id ASC
Kill 19564082 threeruser1 localhost 3rs Query 389 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19564637 threeruser1 localhost 3rs Query 323 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19565524 threeruser1 localhost 3rs Query 257 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19566295 threeruser1 localhost 3rs Query 195 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19566762 threeruser1 localhost 3rs Query 134 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19567250 threeruser1 localhost 3rs Query 70 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19567923 threeruser1 localhost 3rs Query 8 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19567981 threeruser1 localhost mysql Query 0 --- SHOW PROCESSLIST