Change PHP / SQL Queries in Hikashop

You must be able to work remotely with teamviewer or anydesk. You must have experience with Hikashop to complete this task You must know how to use Joomla Debugger You must be able to do work right now DO NOT BID IF YOU CAN ANSWER YES TO ALL ABOVE Project Details Remove joins that are not needed to display search/filter results All data and columns needed are in 1 table but hikashop joins product table to categories table We need to remove joins to categories table to increase 5-6 slow queries When tested query with only products , results are returned in .09 sec When tested with join to categories queries take up to 8 sec times 5 Simply put I want all unescessary joins and queries removed If you show good progress i will continue to give you more work and tasks that are similar to improve performance and function of site. There is no cpanel so dont ask. There is no ftp so dont ask Again this is to be completed directly on server in notepad Dont waste my time and i will leave good feedback