localhost
Show Full Queries ID User Host Database Command Time Status SQL query
Kill 19467223 debian-sys-maint localhost 3rs Query 7189 Sorting index OPTIMIZE TABLE `items`
Kill 19467233 threeruser1 localhost 3rs Query 7188 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19469823 threeruser1 localhost 3rs Query 6876 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470300 threeruser1 localhost 3rs Query 6810 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470817 threeruser1 localhost 3rs Query 6748 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19471719 threeruser1 localhost 3rs Query 6682 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19472570 threeruser1 localhost 3rs Query 6619 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473392 threeruser1 localhost 3rs Query 6557 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473735 threeruser1 localhost 3rs Query 6494 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19474538 threeruser1 localhost 3rs Query 6434 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19475380 threeruser1 localhost 3rs Query 6371 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476200 threeruser1 localhost 3rs Query 6309 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476832 threeruser1 localhost 3rs Query 6244 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19477551 threeruser1 localhost 3rs Query 6182 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19478375 threeruser1 localhost 3rs Query 6121 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19479205 threeruser1 localhost 3rs Query 6059 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480097 threeruser1 localhost 3rs Query 5994 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480940 threeruser1 localhost 3rs Query 5930 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19481743 threeruser1 localhost 3rs Query 5870 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19482592 threeruser1 localhost 3rs Query 5807 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483408 threeruser1 localhost 3rs Query 5747 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483898 threeruser1 localhost 3rs Query 5682 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19484742 threeruser1 localhost 3rs Query 5619 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19485585 threeruser1 localhost 3rs Query 5556 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19486419 threeruser1 localhost 3rs Query 5494 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487180 threeruser1 localhost 3rs Query 5431 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487653 threeruser1 localhost 3rs Query 5369 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19488253 threeruser1 localhost 3rs Query 5307 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489091 threeruser1 localhost 3rs Query 5244 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489953 threeruser1 localhost 3rs Query 5180 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19490825 threeruser1 localhost 3rs Query 5115 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19491681 threeruser1 localhost 3rs Query 5049 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492197 threeruser1 localhost 3rs Query 4984 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492820 threeruser1 localhost 3rs Query 4922 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493465 threeruser1 localhost 3rs Query 4856 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493969 threeruser1 localhost 3rs Query 4796 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19494785 threeruser1 localhost 3rs Query 4735 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19495607 threeruser1 localhost 3rs Query 4674 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19496203 threeruser1 localhost 3rs Query 4611 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497048 threeruser1 localhost 3rs Query 4548 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497855 threeruser1 localhost 3rs Query 4488 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19498528 threeruser1 localhost 3rs Query 4423 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19499400 threeruser1 localhost 3rs Query 4357 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19500246 threeruser1 localhost 3rs Query 4294 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501127 threeruser1 localhost 3rs Query 4229 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501916 threeruser1 localhost 3rs Query 4166 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19502793 threeruser1 localhost 3rs Query 4101 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19503668 threeruser1 localhost 3rs Query 4037 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504484 threeruser1 localhost 3rs Query 3971 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504895 threeruser1 localhost 3rs Query 3908 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19505741 threeruser1 localhost 3rs Query 3845 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506593 threeruser1 localhost 3rs Query 3782 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506742 threeruser1 localhost 3rs Query 3771 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 3717 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19508243 threeruser1 localhost 3rs Query 3653 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19508614 threeruser1 localhost 3rs Query 3592 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19509267 threeruser1 localhost 3rs Query 3532 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19510142 threeruser1 localhost 3rs Query 3467 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19511018 threeruser1 localhost 3rs Query 3401 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19511659 threeruser1 localhost 3rs Query 3341 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19512496 threeruser1 localhost 3rs Query 3279 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19513332 threeruser1 localhost 3rs Query 3217 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19514134 threeruser1 localhost 3rs Query 3154 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19515017 threeruser1 localhost 3rs Query 3089 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19515820 threeruser1 localhost 3rs Query 3029 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19516503 threeruser1 localhost 3rs Query 2965 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19517301 threeruser1 localhost 3rs Query 2903 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19518150 threeruser1 localhost 3rs Query 2839 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19518982 threeruser1 localhost 3rs Query 2778 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19519471 threeruser1 localhost 3rs Query 2713 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19520101 threeruser1 localhost 3rs Query 2650 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19520947 threeruser1 localhost 3rs Query 2587 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19521789 threeruser1 localhost 3rs Query 2525 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19522630 threeruser1 localhost 3rs Query 2462 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19523317 threeruser1 localhost 3rs Query 2397 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19523767 threeruser1 localhost 3rs Query 2332 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19524494 threeruser1 localhost 3rs Query 2270 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19525339 threeruser1 localhost 3rs Query 2207 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19526158 threeruser1 localhost 3rs Query 2147 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19526878 threeruser1 localhost 3rs Query 2085 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19527550 threeruser1 localhost 3rs Query 2020 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19528396 threeruser1 localhost 3rs Query 1956 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19529173 threeruser1 localhost 3rs Query 1896 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19530445 threeruser1 localhost 3rs Query 1767 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19531263 threeruser1 localhost 3rs Query 1706 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19532149 threeruser1 localhost 3rs Query 1641 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19532687 threeruser1 localhost 3rs Query 1577 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19533438 threeruser1 localhost 3rs Query 1511 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19534273 threeruser1 localhost 3rs Query 1449 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19535127 threeruser1 localhost 3rs Query 1384 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19535898 threeruser1 localhost 3rs Query 1319 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19536500 threeruser1 localhost 3rs Query 1254 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19537320 threeruser1 localhost 3rs Query 1192 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19538166 threeruser1 localhost 3rs Query 1130 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19539023 threeruser1 localhost 3rs Query 1065 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19539826 threeruser1 localhost 3rs Query 1005 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19540662 threeruser1 localhost 3rs Query 943 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19541464 threeruser1 localhost 3rs Query 881 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19542292 threeruser1 localhost 3rs Query 819 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19542872 threeruser1 localhost 3rs Query 758 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19543359 threeruser1 localhost 3rs Query 696 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19543610 threeruser1 localhost 3rs Query 633 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19544477 threeruser1 localhost 3rs Query 568 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19545191 threeruser1 localhost 3rs Query 503 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19545818 threeruser1 localhost 3rs Query 441 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19546696 threeruser1 localhost 3rs Query 376 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19547373 threeruser1 localhost 3rs Query 315 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19547694 threeruser1 localhost 3rs Query 249 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19548426 threeruser1 localhost 3rs Query 187 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19549300 threeruser1 localhost 3rs Query 122 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19550149 threeruser1 localhost 3rs Query 58 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19550938 threeruser1 localhost mysql Query 0 --- SHOW PROCESSLIST