Currently, I have three payment options set up in my store. They are all turned on in the extension Admin and all are showing in the shopping cart, but when I ran a SQL query in the database, only one option shows. How do I fix this?

I got a critical error message when testing a new extension. Any leads on how to fix the problem will be greatly appreciated. Here's a summary of the error message:

There has been a critical error processing your request

SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0 store_id = '0', store_name = 'Assistech', store_url = 'https' at line 2
Error No: 1064
SQL: INSERT INTO `ac_orders` SET 0 store_id = '0', store_name = 'Assistech', store_url = 'https://assistech.com/up127/', customer_id = '0', customer_group_id = '1', firstname = 'Oliver', lastname = 'Simoes', email = 'ollie@assistech.com', telephone = '15208838600', fax = '5208838600', total = '187.6167', language_id = '1', currency = 'USD', currency_id = '1', value = '1', coupon_id = '0', ip = '73.24.199.186', shipping_firstname = 'Oliver', shipping_lastname = 'Simoes', shipping_company = '', shipping_address_1 = '1234 Main Street', shipping_address_2 = '', shipping_city = 'Tucson', shipping_postcode = '85721', shipping_zone = 'Arizona', shipping_zone_id = '3616', shipping_country = 'United States', shipping_country_id = '223', shipping_address_format = '{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city}, {zone} {postcode}\r\n{country}', shipping_method = 'Priority Mail 1-Day', payment_firstname = 'Oliver', payment_lastname = 'Simoes', payment_company = '', payment_address_1 = '1234 Main Street', payment_address_2 = '', payment_city = 'Tucson', payment_postcode = '85721', payment_zone = 'Arizona', payment_zone_id = '3616', payment_country = 'United States', payment_country_id = '223', payment_address_format = '{firstname} {lastname}\r\n{company}\r\n{address_1}\r\n{address_2}\r\n{city}, {zone} {postcode}\r\n{country}', payment_method = 'Credit Card / Debit Card (Authorize.Net)', comment = '', date_modified = NOW(), date_added = NOW() in /home/assistec/public_html/xx/core/database/amysqli.php on line 106

My website is taking about 4 seconds to GET store. I already changed the driver from mysql to amysqli and enabled Turbo cache with the webhost, but these steps haven't helped improve the first byte load. Is there anything else I can do to make it faster? The total page load time can be as low as 9s and as high as 40+ seconds, depending on how busy the server is. (I use a shared server.) I'm in the process of optimizing images, minifying scripts and deferring whatever scripts I can. I use v. 1.2.0 with tons of customizations and I'd rather not upgrade. I'm also trying to stay away from CDN as I had some a pretty bad experience with CloudFlare (constant 404 errors).

Some of my database search queries are taking too long. Is there a way to improve its performance?
I see a bunch of abc tables at the top. Are they necessary for Abantecart to work properly? Can they be deleted without affecting the performance of the shopping cart?

I appreciate whatever information is provided to help me improve performance/speed?

Also, I have a slow query log file, but I don't know how to read it. Any insights on that?

For some reason, my shopping cart is not displaying all the items in the VoIP phones category: https://assistech.com/store/voip-video-ip-phones

It lists a total of 26 items (20 on page 1 and 6 on page 2). Of the 6 on page 2, 5 are repeats from page 1 and 5 other items are not showing at all. When I go back from page 2 to page 1, I can see the missing items. How can I get the shopping cart to display the items correctly (without repeats and without skipping any items at first view)?

Does Abantecart output an "all orders" text file? If so, where is it located?

I use version 1.2.

Is there a way to change the image associated with a Facebook post? Whenever a post a link to the shopping cart on FB, it always shows the same telephone picture.

I'm having some issues with the newly purchased Mobile template:

1) The Categories are not showing in the mobile version: https://assistech.com/store/?sf=mobile

2) How can I redirect calls from mobile devices to this template? I believe I found the answer at http://stackoverflow.com/questions/18141708/smarty-php-abantecart-e-commerce-user-agent-theme but I have no idea where to paste the code.

3) The product page is not displaying the price with options.

4) The Submit button in the confirmation page is not responding.

Any help is greatly appreciated.