localhost
Show Full Queries ID User Host Database Command Time Status SQL query
Kill 19467223 debian-sys-maint localhost 3rs Query 8868 Sorting index OPTIMIZE TABLE `items`
Kill 19467233 threeruser1 localhost 3rs Query 8867 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19469823 threeruser1 localhost 3rs Query 8555 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470300 threeruser1 localhost 3rs Query 8489 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470817 threeruser1 localhost 3rs Query 8427 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19471719 threeruser1 localhost 3rs Query 8361 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19472570 threeruser1 localhost 3rs Query 8298 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473392 threeruser1 localhost 3rs Query 8236 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473735 threeruser1 localhost 3rs Query 8173 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19474538 threeruser1 localhost 3rs Query 8113 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19475380 threeruser1 localhost 3rs Query 8050 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476200 threeruser1 localhost 3rs Query 7988 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476832 threeruser1 localhost 3rs Query 7923 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19477551 threeruser1 localhost 3rs Query 7861 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19478375 threeruser1 localhost 3rs Query 7800 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19479205 threeruser1 localhost 3rs Query 7738 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480097 threeruser1 localhost 3rs Query 7673 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480940 threeruser1 localhost 3rs Query 7609 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19481743 threeruser1 localhost 3rs Query 7549 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19482592 threeruser1 localhost 3rs Query 7486 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483408 threeruser1 localhost 3rs Query 7426 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483898 threeruser1 localhost 3rs Query 7361 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19484742 threeruser1 localhost 3rs Query 7298 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19485585 threeruser1 localhost 3rs Query 7235 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19486419 threeruser1 localhost 3rs Query 7173 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487180 threeruser1 localhost 3rs Query 7110 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487653 threeruser1 localhost 3rs Query 7048 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19488253 threeruser1 localhost 3rs Query 6986 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489091 threeruser1 localhost 3rs Query 6923 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489953 threeruser1 localhost 3rs Query 6859 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19490825 threeruser1 localhost 3rs Query 6794 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19491681 threeruser1 localhost 3rs Query 6728 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492197 threeruser1 localhost 3rs Query 6663 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492820 threeruser1 localhost 3rs Query 6601 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493465 threeruser1 localhost 3rs Query 6535 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493969 threeruser1 localhost 3rs Query 6475 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19494785 threeruser1 localhost 3rs Query 6414 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19495607 threeruser1 localhost 3rs Query 6353 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19496203 threeruser1 localhost 3rs Query 6290 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497048 threeruser1 localhost 3rs Query 6227 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497855 threeruser1 localhost 3rs Query 6167 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19498528 threeruser1 localhost 3rs Query 6102 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19499400 threeruser1 localhost 3rs Query 6036 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19500246 threeruser1 localhost 3rs Query 5973 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501127 threeruser1 localhost 3rs Query 5908 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501916 threeruser1 localhost 3rs Query 5845 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19502793 threeruser1 localhost 3rs Query 5780 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19503668 threeruser1 localhost 3rs Query 5716 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504484 threeruser1 localhost 3rs Query 5650 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504895 threeruser1 localhost 3rs Query 5587 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19505741 threeruser1 localhost 3rs Query 5524 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506593 threeruser1 localhost 3rs Query 5461 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506742 threeruser1 localhost 3rs Query 5450 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 5396 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19508243 threeruser1 localhost 3rs Query 5332 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19508614 threeruser1 localhost 3rs Query 5271 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19509267 threeruser1 localhost 3rs Query 5211 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19510142 threeruser1 localhost 3rs Query 5146 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19511018 threeruser1 localhost 3rs Query 5080 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19511659 threeruser1 localhost 3rs Query 5020 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19512496 threeruser1 localhost 3rs Query 4958 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19513332 threeruser1 localhost 3rs Query 4896 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19514134 threeruser1 localhost 3rs Query 4833 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19515017 threeruser1 localhost 3rs Query 4768 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19515820 threeruser1 localhost 3rs Query 4708 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19516503 threeruser1 localhost 3rs Query 4644 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19517301 threeruser1 localhost 3rs Query 4582 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19518150 threeruser1 localhost 3rs Query 4518 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19518982 threeruser1 localhost 3rs Query 4457 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19519471 threeruser1 localhost 3rs Query 4392 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19520101 threeruser1 localhost 3rs Query 4329 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19520947 threeruser1 localhost 3rs Query 4266 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19521789 threeruser1 localhost 3rs Query 4204 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19522630 threeruser1 localhost 3rs Query 4141 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19523317 threeruser1 localhost 3rs Query 4076 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19523767 threeruser1 localhost 3rs Query 4011 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19524494 threeruser1 localhost 3rs Query 3949 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19525339 threeruser1 localhost 3rs Query 3886 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19526158 threeruser1 localhost 3rs Query 3826 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19526878 threeruser1 localhost 3rs Query 3764 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19527550 threeruser1 localhost 3rs Query 3699 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19528396 threeruser1 localhost 3rs Query 3635 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19529173 threeruser1 localhost 3rs Query 3575 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19530445 threeruser1 localhost 3rs Query 3446 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19531263 threeruser1 localhost 3rs Query 3385 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19532149 threeruser1 localhost 3rs Query 3320 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19532687 threeruser1 localhost 3rs Query 3256 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19533438 threeruser1 localhost 3rs Query 3190 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19534273 threeruser1 localhost 3rs Query 3128 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19535127 threeruser1 localhost 3rs Query 3063 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19535898 threeruser1 localhost 3rs Query 2998 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19536500 threeruser1 localhost 3rs Query 2933 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19537320 threeruser1 localhost 3rs Query 2871 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19538166 threeruser1 localhost 3rs Query 2809 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19539023 threeruser1 localhost 3rs Query 2744 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19539826 threeruser1 localhost 3rs Query 2684 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19540662 threeruser1 localhost 3rs Query 2622 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19541464 threeruser1 localhost 3rs Query 2560 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19542292 threeruser1 localhost 3rs Query 2498 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19542872 threeruser1 localhost 3rs Query 2437 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19543359 threeruser1 localhost 3rs Query 2375 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19543610 threeruser1 localhost 3rs Query 2312 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19544477 threeruser1 localhost 3rs Query 2247 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19545191 threeruser1 localhost 3rs Query 2182 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19545818 threeruser1 localhost 3rs Query 2120 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19546696 threeruser1 localhost 3rs Query 2055 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19547373 threeruser1 localhost 3rs Query 1994 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19547694 threeruser1 localhost 3rs Query 1928 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19548426 threeruser1 localhost 3rs Query 1866 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19549300 threeruser1 localhost 3rs Query 1801 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19550149 threeruser1 localhost 3rs Query 1737 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19550962 threeruser1 localhost 3rs Query 1677 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19551791 threeruser1 localhost 3rs Query 1615 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19552673 threeruser1 localhost 3rs Query 1551 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19553473 threeruser1 localhost 3rs Query 1491 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19554318 threeruser1 localhost 3rs Query 1427 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19555044 threeruser1 localhost 3rs Query 1363 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19555874 threeruser1 localhost 3rs Query 1301 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19556662 threeruser1 localhost 3rs Query 1238 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557045 threeruser1 localhost 3rs Query 1173 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557389 threeruser1 localhost 3rs Query 1108 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557456 threeruser1 localhost 3rs Query 1047 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557562 threeruser1 localhost 3rs Query 1012 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 987 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557844 threeruser1 localhost 3rs Query 922 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19558034 threeruser1 localhost 3rs Query 861 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19558238 threeruser1 localhost 3rs Query 797 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19558583 threeruser1 localhost 3rs Query 727 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19559347 threeruser1 localhost 3rs Query 668 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19560205 threeruser1 localhost 3rs Query 603 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19560848 threeruser1 localhost 3rs Query 543 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19561588 threeruser1 localhost 3rs Query 482 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19562467 threeruser1 localhost 3rs Query 417 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19563333 threeruser1 localhost 3rs Query 351 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19563770 threeruser1 localhost 3rs Query 318 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 286 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19564637 threeruser1 localhost 3rs Query 220 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19565524 threeruser1 localhost 3rs Query 154 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19566295 threeruser1 localhost 3rs Query 92 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19566762 threeruser1 localhost 3rs Query 31 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19566871 threeruser1 localhost mysql Query 0 --- SHOW PROCESSLIST