Hi ,
I have more than 5 years experience in magento and develop more than 55 website.I have worked on both front-end and back-end module development. Worked on varous ad dons like belvg color swatch, amasty layered navigation, manadev layered navigation,aptha multivendor etc extensions. I had worked on both enterprise and community versions. Recently upgrade magento enterprise from 1.12.0.2 to 1.13.0.2 and magento community from 1.7.0.2 to magento 1.9.
As seen , all queries looks good as it's default magento process if you are opening catalog or sales order page in admin.
Ther are 2-3 queries where i think some extension or script tries to insert data which causes table lock.
i need an ftp details and databse server detail if you have . i can solve this issue in 2 days only