localhost
Show Full Queries ID User Host Database Command Time Status SQL query
Kill 19467223 debian-sys-maint localhost 3rs Query 3778 Sorting index OPTIMIZE TABLE `items`
Kill 19467233 threeruser1 localhost 3rs Query 3777 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19469823 threeruser1 localhost 3rs Query 3465 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470300 threeruser1 localhost 3rs Query 3399 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470817 threeruser1 localhost 3rs Query 3337 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19471719 threeruser1 localhost 3rs Query 3271 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19472570 threeruser1 localhost 3rs Query 3208 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473392 threeruser1 localhost 3rs Query 3146 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473735 threeruser1 localhost 3rs Query 3083 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19474538 threeruser1 localhost 3rs Query 3023 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19475380 threeruser1 localhost 3rs Query 2960 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476200 threeruser1 localhost 3rs Query 2898 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476832 threeruser1 localhost 3rs Query 2833 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19477551 threeruser1 localhost 3rs Query 2771 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19478375 threeruser1 localhost 3rs Query 2710 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19479205 threeruser1 localhost 3rs Query 2648 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480097 threeruser1 localhost 3rs Query 2583 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480940 threeruser1 localhost 3rs Query 2519 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19481743 threeruser1 localhost 3rs Query 2459 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19482592 threeruser1 localhost 3rs Query 2396 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483408 threeruser1 localhost 3rs Query 2336 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483898 threeruser1 localhost 3rs Query 2271 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19484742 threeruser1 localhost 3rs Query 2208 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19485585 threeruser1 localhost 3rs Query 2145 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19486419 threeruser1 localhost 3rs Query 2083 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487180 threeruser1 localhost 3rs Query 2020 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487653 threeruser1 localhost 3rs Query 1958 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19488253 threeruser1 localhost 3rs Query 1896 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489091 threeruser1 localhost 3rs Query 1833 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489953 threeruser1 localhost 3rs Query 1769 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19490825 threeruser1 localhost 3rs Query 1704 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19491681 threeruser1 localhost 3rs Query 1638 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492197 threeruser1 localhost 3rs Query 1573 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492820 threeruser1 localhost 3rs Query 1511 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493465 threeruser1 localhost 3rs Query 1445 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493969 threeruser1 localhost 3rs Query 1385 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19494785 threeruser1 localhost 3rs Query 1324 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19495607 threeruser1 localhost 3rs Query 1263 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19496203 threeruser1 localhost 3rs Query 1200 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497048 threeruser1 localhost 3rs Query 1137 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497855 threeruser1 localhost 3rs Query 1077 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19498528 threeruser1 localhost 3rs Query 1012 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19499400 threeruser1 localhost 3rs Query 946 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19500246 threeruser1 localhost 3rs Query 883 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501127 threeruser1 localhost 3rs Query 818 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501916 threeruser1 localhost 3rs Query 755 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19502793 threeruser1 localhost 3rs Query 690 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19503668 threeruser1 localhost 3rs Query 626 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504484 threeruser1 localhost 3rs Query 560 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504895 threeruser1 localhost 3rs Query 497 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19505741 threeruser1 localhost 3rs Query 434 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506593 threeruser1 localhost 3rs Query 371 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506742 threeruser1 localhost 3rs Query 360 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 306 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19508243 threeruser1 localhost 3rs Query 242 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19508614 threeruser1 localhost 3rs Query 181 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19509267 threeruser1 localhost 3rs Query 121 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19510142 threeruser1 localhost 3rs Query 56 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19510892 threeruser1 localhost mysql Query 0 --- SHOW PROCESSLIST