σε συνέχεια της κουβέντας μας σου παραθέτω καποιες πληροφορίες που συνέλεξε το siteground support.
=== Top 10 Executed Scripts ================================================================
Count Script Local Path
----- ----------------------------------------- ------------------------------------------
1308 http://mysiteko.com/index.php /home/mysite/public_html/index.php
Additionally, when reviewing the database queries of your website I see that some of them last for almost 30 seconds:
1. Executed 3h 11m 10s ago for 29.956192 sec on Database --> mysite_my
Date: 2020-05-04 09:14:42 Query_time: 29.956192 Rows_examined: 0: Rows_sent 0 Lock_time: 0.050323
# Schema: mysite_my Last_errno: 0 Killed: 0 SELECT * FROM mysite_store WHERE REPLACE(`url`, 'www.', '') = '
http://mysiteko.com/';
-------------------------------------------------------------------------------------------------
2. Executed 6h 26m 48s ago for 26.773055 sec on Database --> mysite_my
Date: 2020-05-04 05:59:04 Query_time: 26.773055 Rows_examined: 0: Rows_sent 0 Lock_time: 0.050164
# Schema: mysite_my Last_errno: 0 Killed: 0 SELECT * FROM mysite_url_alias WHERE `query` = 'category_id=11';
-------------------------------------------------------------------------------------------------
3. Executed 3h 11m 11s ago for 26.111361 sec on Database --> mysite_my
Date: 2020-05-04 09:14:41 Query_time: 26.111361 Rows_examined: 0: Rows_sent 0 Lock_time: 0.050392
# Schema: mysite_my Last_errno: 0 Killed: 0 SELECT * FROM mysite_store WHERE REPLACE(`url`, 'www.', '') = '
http://mysiteko.com/';
-------------------------------------------------------------------------------------------------
4. Executed 4h 26m 20s ago for 14.351024 sec on Database --> mysite_my
Date: 2020-05-04 07:59:32 Query_time: 14.351024 Rows_examined: 28: Rows_sent 1 Lock_time: 0.050307
# Schema: mysite_my Last_errno: 0 Killed: 0 SELECT COUNT(DISTINCT p.product_id) AS total FROM mysite_category_path cp LEFT JOIN mysite_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN mysite_product p ON (p2c.product_id = p.product_id) LEFT JOIN mysite_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN mysite_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '184';
--------------------------------------------------------------------------------------------------
σκέφτομαι να δοκιμάσω το OpenCart Lightning (εμπορικό), φαινεται υποσχόμενο.
Ευχαριστώ και πάλι για το χρόνο σου.