localhost
Show Full Queries ID User Host Database Command Time Status SQL query
Kill 19467223 debian-sys-maint localhost 3rs Query 3461 Sorting index OPTIMIZE TABLE `items`
Kill 19467233 threeruser1 localhost 3rs Query 3460 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19469823 threeruser1 localhost 3rs Query 3148 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470300 threeruser1 localhost 3rs Query 3082 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19470817 threeruser1 localhost 3rs Query 3020 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19471719 threeruser1 localhost 3rs Query 2954 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19472570 threeruser1 localhost 3rs Query 2891 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473392 threeruser1 localhost 3rs Query 2829 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19473735 threeruser1 localhost 3rs Query 2766 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19474538 threeruser1 localhost 3rs Query 2706 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19475380 threeruser1 localhost 3rs Query 2643 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476200 threeruser1 localhost 3rs Query 2581 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19476832 threeruser1 localhost 3rs Query 2516 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19477551 threeruser1 localhost 3rs Query 2454 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19478375 threeruser1 localhost 3rs Query 2393 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19479205 threeruser1 localhost 3rs Query 2331 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480097 threeruser1 localhost 3rs Query 2266 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19480940 threeruser1 localhost 3rs Query 2202 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19481743 threeruser1 localhost 3rs Query 2142 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19482592 threeruser1 localhost 3rs Query 2079 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483408 threeruser1 localhost 3rs Query 2019 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19483898 threeruser1 localhost 3rs Query 1954 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19484742 threeruser1 localhost 3rs Query 1891 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19485585 threeruser1 localhost 3rs Query 1828 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19486419 threeruser1 localhost 3rs Query 1766 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487180 threeruser1 localhost 3rs Query 1703 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19487653 threeruser1 localhost 3rs Query 1641 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19488253 threeruser1 localhost 3rs Query 1579 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489091 threeruser1 localhost 3rs Query 1516 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19489953 threeruser1 localhost 3rs Query 1452 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19490825 threeruser1 localhost 3rs Query 1387 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19491681 threeruser1 localhost 3rs Query 1321 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492197 threeruser1 localhost 3rs Query 1256 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19492820 threeruser1 localhost 3rs Query 1194 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493465 threeruser1 localhost 3rs Query 1128 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19493969 threeruser1 localhost 3rs Query 1068 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19494785 threeruser1 localhost 3rs Query 1007 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19495607 threeruser1 localhost 3rs Query 946 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19496203 threeruser1 localhost 3rs Query 883 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497048 threeruser1 localhost 3rs Query 820 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19497855 threeruser1 localhost 3rs Query 760 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19498528 threeruser1 localhost 3rs Query 695 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19499400 threeruser1 localhost 3rs Query 629 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19500246 threeruser1 localhost 3rs Query 566 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501127 threeruser1 localhost 3rs Query 501 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19501916 threeruser1 localhost 3rs Query 438 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19502793 threeruser1 localhost 3rs Query 373 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19503668 threeruser1 localhost 3rs Query 309 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504484 threeruser1 localhost 3rs Query 243 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19504895 threeruser1 localhost 3rs Query 180 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19505741 threeruser1 localhost 3rs Query 117 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506593 threeruser1 localhost 3rs Query 54 Waiting for table metadata lock SELECT *
FROM `items`
LIMIT 0 , 30
Kill 19506742 threeruser1 localhost 3rs Query 43 Waiting for table metadata lock SELECT *
FROM items
WHERE TYPE = "Lessons"
AND categories LIKE "%460%"
ORDER BY id ASC
Kill 19507322 threeruser1 localhost mysql Query 0 --- SHOW PROCESSLIST