localhost
Show Full Queries ID User Host Database Command Time Status SQL query
Kill 19467223 debian-sys-maint localhost 3rs Query 8976 Sorting index OPTIMIZE TABLE `items`
Kill 19467233 threeruser1 localhost 3rs Query 8975 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19469823 threeruser1 localhost 3rs Query 8663 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470300 threeruser1 localhost 3rs Query 8597 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470817 threeruser1 localhost 3rs Query 8535 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19471719 threeruser1 localhost 3rs Query 8469 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19472570 threeruser1 localhost 3rs Query 8406 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473392 threeruser1 localhost 3rs Query 8344 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473735 threeruser1 localhost 3rs Query 8281 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19474538 threeruser1 localhost 3rs Query 8221 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19475380 threeruser1 localhost 3rs Query 8158 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476200 threeruser1 localhost 3rs Query 8096 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476832 threeruser1 localhost 3rs Query 8031 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19477551 threeruser1 localhost 3rs Query 7969 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19478375 threeruser1 localhost 3rs Query 7908 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19479205 threeruser1 localhost 3rs Query 7846 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480097 threeruser1 localhost 3rs Query 7781 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480940 threeruser1 localhost 3rs Query 7717 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19481743 threeruser1 localhost 3rs Query 7657 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19482592 threeruser1 localhost 3rs Query 7594 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483408 threeruser1 localhost 3rs Query 7534 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483898 threeruser1 localhost 3rs Query 7469 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19484742 threeruser1 localhost 3rs Query 7406 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19485585 threeruser1 localhost 3rs Query 7343 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19486419 threeruser1 localhost 3rs Query 7281 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487180 threeruser1 localhost 3rs Query 7218 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487653 threeruser1 localhost 3rs Query 7156 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19488253 threeruser1 localhost 3rs Query 7094 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489091 threeruser1 localhost 3rs Query 7031 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489953 threeruser1 localhost 3rs Query 6967 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19490825 threeruser1 localhost 3rs Query 6902 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19491681 threeruser1 localhost 3rs Query 6836 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492197 threeruser1 localhost 3rs Query 6771 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492820 threeruser1 localhost 3rs Query 6709 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493465 threeruser1 localhost 3rs Query 6643 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493969 threeruser1 localhost 3rs Query 6583 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19494785 threeruser1 localhost 3rs Query 6522 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19495607 threeruser1 localhost 3rs Query 6461 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19496203 threeruser1 localhost 3rs Query 6398 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497048 threeruser1 localhost 3rs Query 6335 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497855 threeruser1 localhost 3rs Query 6275 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19498528 threeruser1 localhost 3rs Query 6210 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19499400 threeruser1 localhost 3rs Query 6144 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19500246 threeruser1 localhost 3rs Query 6081 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501127 threeruser1 localhost 3rs Query 6016 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501916 threeruser1 localhost 3rs Query 5953 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19502793 threeruser1 localhost 3rs Query 5888 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19503668 threeruser1 localhost 3rs Query 5824 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504484 threeruser1 localhost 3rs Query 5758 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504895 threeruser1 localhost 3rs Query 5695 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19505741 threeruser1 localhost 3rs Query 5632 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506593 threeruser1 localhost 3rs Query 5569 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506742 threeruser1 localhost 3rs Query 5558 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 5504 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19508243 threeruser1 localhost 3rs Query 5440 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19508614 threeruser1 localhost 3rs Query 5379 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19509267 threeruser1 localhost 3rs Query 5319 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19510142 threeruser1 localhost 3rs Query 5254 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19511018 threeruser1 localhost 3rs Query 5188 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19511659 threeruser1 localhost 3rs Query 5128 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19512496 threeruser1 localhost 3rs Query 5066 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19513332 threeruser1 localhost 3rs Query 5004 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19514134 threeruser1 localhost 3rs Query 4941 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19515017 threeruser1 localhost 3rs Query 4876 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19515820 threeruser1 localhost 3rs Query 4816 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19516503 threeruser1 localhost 3rs Query 4752 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19517301 threeruser1 localhost 3rs Query 4690 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19518150 threeruser1 localhost 3rs Query 4626 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19518982 threeruser1 localhost 3rs Query 4565 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19519471 threeruser1 localhost 3rs Query 4500 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19520101 threeruser1 localhost 3rs Query 4437 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19520947 threeruser1 localhost 3rs Query 4374 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19521789 threeruser1 localhost 3rs Query 4312 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19522630 threeruser1 localhost 3rs Query 4249 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19523317 threeruser1 localhost 3rs Query 4184 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19523767 threeruser1 localhost 3rs Query 4119 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19524494 threeruser1 localhost 3rs Query 4057 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19525339 threeruser1 localhost 3rs Query 3994 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19526158 threeruser1 localhost 3rs Query 3934 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19526878 threeruser1 localhost 3rs Query 3872 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19527550 threeruser1 localhost 3rs Query 3807 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19528396 threeruser1 localhost 3rs Query 3743 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19529173 threeruser1 localhost 3rs Query 3683 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19530445 threeruser1 localhost 3rs Query 3554 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19531263 threeruser1 localhost 3rs Query 3493 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19532149 threeruser1 localhost 3rs Query 3428 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19532687 threeruser1 localhost 3rs Query 3364 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19533438 threeruser1 localhost 3rs Query 3298 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19534273 threeruser1 localhost 3rs Query 3236 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19535127 threeruser1 localhost 3rs Query 3171 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19535898 threeruser1 localhost 3rs Query 3106 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19536500 threeruser1 localhost 3rs Query 3041 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19537320 threeruser1 localhost 3rs Query 2979 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19538166 threeruser1 localhost 3rs Query 2917 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19539023 threeruser1 localhost 3rs Query 2852 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19539826 threeruser1 localhost 3rs Query 2792 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19540662 threeruser1 localhost 3rs Query 2730 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19541464 threeruser1 localhost 3rs Query 2668 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19542292 threeruser1 localhost 3rs Query 2606 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19542872 threeruser1 localhost 3rs Query 2545 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19543359 threeruser1 localhost 3rs Query 2483 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19543610 threeruser1 localhost 3rs Query 2420 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19544477 threeruser1 localhost 3rs Query 2355 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19545191 threeruser1 localhost 3rs Query 2290 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19545818 threeruser1 localhost 3rs Query 2228 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19546696 threeruser1 localhost 3rs Query 2163 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19547373 threeruser1 localhost 3rs Query 2102 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19547694 threeruser1 localhost 3rs Query 2036 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19548426 threeruser1 localhost 3rs Query 1974 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19549300 threeruser1 localhost 3rs Query 1909 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19550149 threeruser1 localhost 3rs Query 1845 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19550962 threeruser1 localhost 3rs Query 1785 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19551791 threeruser1 localhost 3rs Query 1723 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19552673 threeruser1 localhost 3rs Query 1659 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19553473 threeruser1 localhost 3rs Query 1599 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19554318 threeruser1 localhost 3rs Query 1535 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19555044 threeruser1 localhost 3rs Query 1471 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19555874 threeruser1 localhost 3rs Query 1409 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19556662 threeruser1 localhost 3rs Query 1346 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557045 threeruser1 localhost 3rs Query 1281 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557389 threeruser1 localhost 3rs Query 1216 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557456 threeruser1 localhost 3rs Query 1155 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557562 threeruser1 localhost 3rs Query 1120 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 1095 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19557844 threeruser1 localhost 3rs Query 1030 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19558034 threeruser1 localhost 3rs Query 969 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19558238 threeruser1 localhost 3rs Query 905 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19558583 threeruser1 localhost 3rs Query 835 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19559347 threeruser1 localhost 3rs Query 776 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19560205 threeruser1 localhost 3rs Query 711 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19560848 threeruser1 localhost 3rs Query 651 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19561588 threeruser1 localhost 3rs Query 590 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19562467 threeruser1 localhost 3rs Query 525 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19563333 threeruser1 localhost 3rs Query 459 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19563770 threeruser1 localhost 3rs Query 426 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 394 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19564637 threeruser1 localhost 3rs Query 328 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19565524 threeruser1 localhost 3rs Query 262 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19566295 threeruser1 localhost 3rs Query 200 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19566762 threeruser1 localhost 3rs Query 139 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19567250 threeruser1 localhost 3rs Query 75 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19567923 threeruser1 localhost 3rs Query 13 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19568026 threeruser1 localhost mysql Query 0 --- SHOW PROCESSLIST