Id User Host db Command Time State Info 19777 userA host58:48639 dbA Query 1177 Locked SELECT fid, Pos FROM table1 WHERE id=493762062 A ND type=23 19778 userA host58:48640 dbA Query 1177 Locked SELECT fid, Pos FROM table2 WHERE id=450698109 A ND type=6 19779 userA host58:48643 dbA Query 1215 Locked SELECT fid, Pos FROM table1 WHERE id=493048871 A ND type=23 19780 userA host58:48646 dbA Query 1215 Locked SELECT fid, Pos FROM table1 WHERE id=493782592 A ND type=22 19781 userA host58:48647 dbA Query 1213 Locked SELECT fid, Pos FROM table2 WHERE id=450409106 A ND type=6 19782 userA host58:48650 dbA Query 1215 Locked SELECT fid, Pos FROM table2 WHERE id=450708772 A ND type=22 19783 userA host58:48651 dbA Query 1210 Locked SELECT fid, Pos FROM table2 WHERE id=450956428 A ND type=23 19784 userA host58:48652 dbA Query 1190 Locked SELECT fid, Pos FROM table1 WHERE id=493698728 A ND type=6 19785 userA host58:48653 dbA Query 1207 Locked SELECT fid, Pos FROM table2 WHERE id=450678325 A ND type=6 19786 userA host58:48654 dbA Query 1179 Locked SELECT fid, Pos FROM table1 WHERE id=493502764 A ND type=6 19787 userA host58:48655 dbA Query 1218 freeing items SELECT fid, Pos FROM table478 WHERE id=478 484095 AND type=6 19788 userA host58:48656 dbA Query 1218 Locked SELECT fid, Pos FROM table2 WHERE id=450301095 A ND type=22 19789 userA host58:48657 dbA Query 1195 Locked SELECT fid, Pos FROM table2 WHERE id=450126296 A ND type=6 19790 userA host58:48658 dbA Query 1215 Locked SELECT fid, Pos FROM table1 WHERE id=493318114 A ND type=6 19791 userA host58:48659 dbA Query 1214 Locked SELECT fid, Pos FROM table2 WHERE id=450484442 A ND type=23 19792 userA host58:48662 dbA Query 1192 Locked SELECT fid, Pos FROM table2 WHERE id=450781817 A ND type=22 19793 userA host58:48663 dbA Query 1199 Locked SELECT fid, Pos FROM table2 WHERE id=450855391 A ND type=23 19794 userA host58:48664 dbA Query 1206 Locked SELECT fid, Pos FROM table2 WHERE id=450974399 A ND type=6 19795 userA host58:48665 dbA Query 1201 Locked SELECT fid, Pos FROM table2 WHERE id=450133061 A ND type=6 19796 userA host58:48666 dbA Query 1178 Locked SELECT fid, Pos FROM table2 WHERE id=450224949 A ND type=6 19797 userA host58:48667 dbA Query 1190 Locked SELECT fid, Pos FROM table2 WHERE id=450777979 A ND type=6 19798 userA host58:48668 dbA Query 1199 Locked SELECT fid, Pos FROM table1 WHERE id=493216762 A ND type=6 19799 userA host58:48671 dbA Query 1197 Locked SELECT fid, Pos FROM table2 WHERE id=450547840 A ND type=6 19800 userA host58:48672 dbA Query 1193 Locked SELECT fid, Pos FROM table1 WHERE id=493708886 A ND type=6 19801 userA host58:48673 dbA Query 1206 Locked SELECT fid, Pos FROM table1 WHERE id=493073018 A ND type=6 19802 userA host58:48674 dbA Query 1219 freeing items SELECT fid, Pos FROM table478 WHERE id=478 503971 AND type=6 19803 userA host58:48677 dbA Query 1218 update REPLACE INTO table2 (id,type,fid,Pos) VALUES (450734015,25,10,5796) 19804 userA host58:48680 dbA Query 1198 Locked SELECT fid, Pos FROM table2 WHERE id=450355233 A ND type=6 19805 userA host58:48681 dbA Query 1190 freeing items SELECT fid, Pos FROM table476 WHERE id=476 949668 AND type=22 19806 userA host58:48682 dbA Query 1219 freeing items SELECT fid, Pos FROM table476 WHERE id=476 074774 AND type=23 19807 userA host58:48683 dbA Query 1202 Locked SELECT fid, Pos FROM table1 WHERE id=493028346 A ND type=6 19808 userA host58:48686 dbA Query 1207 Locked SELECT fid, Pos FROM table2 WHERE id=450889371 A ND type=6 19809 userA host58:48689 dbA Query 1207 Locked SELECT fid, Pos FROM table2 WHERE id=450620407 A ND type=6 19810 userA host58:48690 dbA Query 1218 freeing items SELECT fid, Pos FROM table464 WHERE id=464 955714 AND type=23 19811 userA host58:48691 dbA Query 1212 Locked SELECT fid, Pos FROM table2 WHERE id=450515420 A ND type=22 19812 userA host58:48692 dbA Query 1197 Locked SELECT fid, Pos FROM table1 WHERE id=493874399 A ND type=6 19813 userA host58:48693 dbA Query 1198 Locked SELECT fid, Pos FROM table1 WHERE id=493937059 A ND type=6 19814 userA host58:48695 dbA Query 1215 Locked SELECT fid, Pos FROM table2 WHERE id=450722208 A ND type=6 19815 userA host58:48697 dbA Query 1212 Locked SELECT fid, Pos FROM table1 WHERE id=493015693 A ND type=23 19816 userA host58:48698 dbA Query 1206 Locked SELECT fid, Pos FROM table1 WHERE id=493894683 A ND type=23 19817 userA host58:48713 dbA Query 1218 freeing items SELECT fid, Pos FROM table490 WHERE id=490 997636 AND type=6 19818 userA host58:48716 dbA Query 1198 Locked SELECT fid, Pos FROM table1 WHERE id=493983868 A ND type=6 19819 userA host58:48719 dbA Query 1188 Locked SELECT fid, Pos FROM table1 WHERE id=493096860 A ND type=6 19820 userA host58:48720 dbA Query 1214 Locked SELECT fid, Pos FROM table2 WHERE id=450429582 A ND type=23 19821 userA host58:48725 dbA Query 1192 Locked SELECT fid, Pos FROM table1 WHERE id=493390136 A ND type=6 19822 userA host58:48728 dbA Query 1213 Locked SELECT fid, Pos FROM table2 WHERE id=450689225 A ND type=6 19823 userA host58:48737 dbA Query 1218 Locked SELECT fid, Pos FROM table1 WHERE id=493733660 A ND type=22 19824 userA host58:48742 dbA Query 1197 Locked SELECT fid, Pos FROM table1 WHERE id=493550597 A ND type=6 19825 userA host58:48747 dbA Query 1198 Locked SELECT fid, Pos FROM table2 WHERE id=450553225 A ND type=22 19826 userA host58:48750 dbA Query 1204 Locked SELECT fid, Pos FROM table1 WHERE id=493676228 A ND type=6 19827 userA host58:48754 dbA Query 1218 freeing items SELECT fid, Pos FROM table475 WHERE id=475 339095 AND type=23 19828 userA host58:48757 dbA Query 1206 Locked SELECT fid, Pos FROM table2 WHERE id=450866443 A ND type=23 19829 userA host58:48762 dbA Query 1179 Locked SELECT fid, Pos FROM table1 WHERE id=493201383 A ND type=6 19830 userA host58:48779 dbA Query 1215 Locked SELECT fid, Pos FROM table1 WHERE id=493342341 A ND type=22 19831 userA host58:48795 dbA Query 1215 Locked SELECT fid, Pos FROM table2 WHERE id=450146793 A ND type=6 19832 userA host58:48800 dbA Query 1202 Locked SELECT fid, Pos FROM table1 WHERE id=493530666 A ND type=6 19833 userA host58:48802 dbA Query 1213 Locked SELECT fid, Pos FROM table1 WHERE id=493888778 A ND type=22 19834 userA host58:48806 dbA Query 1211 Locked SELECT fid, Pos FROM table1 WHERE id=493927398 A ND type=6 19835 userA host58:48807 dbA Query 1211 freeing items SELECT fid, Pos FROM table447 WHERE id=447 233876 AND type=6 19836 userA host58:48808 dbA Query 1200 Locked SELECT fid, Pos FROM table2 WHERE id=450434573 A ND type=23 19837 userA host58:48809 dbA Query 1215 freeing items SELECT fid, Pos FROM table490 WHERE id=490 117064 AND type=6 19838 userA host58:48813 dbA Query 1205 Locked SELECT fid, Pos FROM table1 WHERE id=493749126 A ND type=6 19839 userA host58:48814 dbA Query 1215 Locked SELECT fid, Pos FROM table2 WHERE id=450908283 A ND type=23 19840 userA host58:48818 dbA Query 1193 Locked SELECT fid, Pos FROM table1 WHERE id=493351779 A ND type=6 19841 userA host58:48819 dbA Query 1217 freeing items SELECT fid, Pos FROM table465 WHERE id=465 903244 AND type=23 19842 userA host58:48820 dbA Query 1212 Locked SELECT fid, Pos FROM table2 WHERE id=450171550 A ND type=6 19843 userA host58:48822 dbA Query 1191 Locked SELECT fid, Pos FROM table1 WHERE id=493303913 A ND type=6 19844 userA host58:48823 dbA Query 1197 Locked SELECT fid, Pos FROM table1 WHERE id=493109236 A ND type=6 19845 userA host58:48824 dbA Query 1204 Locked SELECT fid, Pos FROM table2 WHERE id=450631019 A ND type=6 19846 userA host58:48825 dbA Query 1179 Locked SELECT fid, Pos FROM table1 WHERE id=493123707 A ND type=23 19847 userA host58:48826 dbA Query 1204 Locked SELECT fid, Pos FROM table2 WHERE id=450604748 A ND type=6 19848 userA host58:48827 dbA Query 1200 Locked SELECT fid, Pos FROM table1 WHERE id=493416769 A ND type=6 19849 userA host58:48828 dbA Query 1192 Locked SELECT fid, Pos FROM table1 WHERE id=493386325 A ND type=6 19850 userA host58:48829 dbA Query 1202 Locked SELECT fid, Pos FROM table1 WHERE id=493405035 A ND type=23 19851 userA host58:48830 dbA Query 1186 Locked SELECT fid, Pos FROM table2 WHERE id=450564330 A ND type=23 19852 userA host58:48831 dbA Query 1189 Locked SELECT fid, Pos FROM table2 WHERE id=450385052 A ND type=6 19853 userA host58:48832 dbA Query 1193 Locked SELECT fid, Pos FROM table1 WHERE id=493527309 A ND type=6 19854 userA host58:48833 dbA Query 1196 Locked SELECT fid, Pos FROM table1 WHERE id=493519608 A ND type=6 19855 userA host58:48834 dbA Query 1189 Locked SELECT fid, Pos FROM table1 WHERE id=493008059 A ND type=23 19856 userA host58:48835 dbA Query 1211 Locked SELECT fid, Pos FROM table2 WHERE id=450538909 A ND type=6 19857 userA host58:48836 dbA Query 1206 Locked SELECT fid, Pos FROM table2 WHERE id=450796246 A ND type=6 19858 userA host58:48837 dbA Query 1179 Locked SELECT fid, Pos FROM table1 WHERE id=493491578 A ND type=6 19859 userA host58:48838 dbA Query 1179 Locked SELECT fid, Pos FROM table1 WHERE id=493057913 A ND type=23 19860 userA host58:48839 dbA Query 1191 Locked SELECT fid, Pos FROM table2 WHERE id=450048996 A ND type=23 19861 userA host58:48840 dbA Query 1215 Locked SELECT fid, Pos FROM table2 WHERE id=450256064 A ND type=6 19862 userA host58:48841 dbA Query 1209 Locked SELECT fid, Pos FROM table2 WHERE id=450968559 A ND type=6 19863 userA host58:48842 dbA Query 1215 Locked SELECT fid, Pos FROM table2 WHERE id=450586398 A ND type=6 19864 userA host58:48843 dbA Query 1219 update REPLACE INTO table1 (id,type,fid,Pos) VALUES (493291545,23,16,670) 19865 userA host58:48844 dbA Query 1189 Locked SELECT fid, Pos FROM table2 WHERE id=450838056 A ND type=6 19866 userA host58:48845 dbA Query 1212 Locked SELECT fid, Pos FROM table1 WHERE id=493227201 A ND type=6 19867 userA host58:48846 dbA Query 1187 Locked SELECT fid, Pos FROM table2 WHERE id=450311623 A ND type=6 19868 userA host58:48847 dbA Query 1211 Locked SELECT fid, Pos FROM table2 WHERE id=450821236 A ND type=22 19869 userA host58:48848 dbA Query 1211 Locked SELECT fid, Pos FROM table2 WHERE id=450644899 A ND type=6 19870 userA host58:48851 dbA Query 1199 Locked SELECT fid, Pos FROM table1 WHERE id=493452818 A ND type=6 19871 userA host58:48856 dbA Query 1212 Locked SELECT fid, Pos FROM table2 WHERE id=450197705 A ND type=23 19872 userA host58:48857 dbA Query 1217 freeing items SELECT fid, Pos FROM table467 WHERE id=467 913150 AND type=6 19873 userA host58:48858 dbA Query 1202 Locked SELECT fid, Pos FROM table2 WHERE id=450457374 A ND type=6 19874 userA host58:48859 dbA Query 1202 Locked SELECT fid, Pos FROM table2 WHERE id=450917052 A ND type=6 19875 userA host58:48860 dbA Query 1218 Locked SELECT fid, Pos FROM table1 WHERE id=493267791 A ND type=23 19876 userA host58:48861 dbA Query 1212 Locked SELECT fid, Pos FROM table2 WHERE id=450994741 A ND type=22 20338 userA localhost NULL Query 0 NULL show full processlist