Перейти к содержанию
Elizaveta

Сайт стал очень долго открываться

Рекомендуемые сообщения

OpenCart 1531

хостинг  -SpaceWeb

 

Проблема - сайт стал очень медленно загружаться от 10- 15 секунд, при чем  изменений ни каких ни за день на за два не вносила. Почистила кеш, файлы error, пробовала отключать поочередно модули - не помогло. 

Звонила в техподдержку хостинга, они говорят что это скрипты/ При обращении в техподдержку в письменном виде вот что они ответили

 

Ситуация заключается в том, что виснет выполнение скриптов Вашего сайта, в
частности скрипта index.php
Скрипт виснет на выполнении задачи:

open("/home/l/ldmsu/public_html/system/logs/error.txt",
O_RDWR|O_CREAT|O_APPEND, 0666) = 9
fstat(9, {st_mode=S_IFREG|0644, st_size=9377570, ...}) = 0
lseek(9, 0, SEEK_CUR)                   = 0
lseek(9, 0, SEEK_CUR)                   = 0
write(9, "2013-04-29 15:00:45 - PHP Notice"..., 153) = 153
close(9)                                = 0
socket(PF_INET6, SOCK_DGRAM, IPPROTO_IP) = 9
close(9)                                = 0
mmap(NULL, 8392704, PROT_READ|PROT_WRITE|PROT_EXEC,
MAP_PRIVATE|MAP_ANONYMOUS|MAP_STACK, -1, 0) = 0x7f604ed96000
mprotect(0x7f604ed96000, 4096, PROT_NONE) = 0
clone(child_stack=0x7f604f595fb0,
flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID,
parent_tidptr=0x7f604f5969d0, tls=0x7f604f596700, child_tidptr=0x7f604f5969d0)
= 5157
futex(0x7f604f5969d0, FUTEX_WAIT, 5157, NULL^C <unfinished ...>

что с этим делать я понятия не имею. На сайте имеются проблемы, которые возникали из-за моих кривых ручек и установки модулей на уже работающий сайт ))))

 

 

Может кто сталкивался с такой проблемой, подскажите пожалуйста что делать (желательно подробно)))

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

сайт ошибками сыпет, пишет в лог. начните с этого.

установите dblog https://opencartforum.com/files/file/786-db-log/

скиньте сюда ваши логи

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Присоединяюсь.. 

Мне из техподдержки хостинга наконец ответили о причинах задержки, мол, 

у Ваших скриптов возникают проблемы при ресолвинге myopencart.net. Как часто Ваши скрипты это делают и зачем, лучше уточнить у разработчика Вашего сайта.

При этом к скорости загрузки сайта добавляется ровно 5 секунд.

В логах наблюдается некое 

poll([{fd=29, events=POLLIN}], 1, 4999) = ? ERESTART_RESTARTBLOCK (To be restarted) <4.996134> (!!!!)

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

логи из файла slow.log ?
Если да то вот они, пока все что есть

 

2013-04-30 17:44:10 - all_time: 0.26055; count_queries: 00224 /
2013-04-30 17:44:12 - all_time: 0.02249; count_queries: 00209 /
2013-04-30 17:44:45 - all_time: 0.02876; count_queries: 00189 /Boat_motors_Honda/
2013-04-30 17:45:08 - all_time: 0.08954; count_queries: 00224 /maslo-dlya-lodochnyih-motorov-Honda.html
2013-04-30 17:45:18 - all_time: 0.07306; count_queries: 00184 /HONDA_BF-20_D3_SHU.html
2013-04-30 17:45:18 - all_time: 0.00201; count_queries: 00009 /index.php?route=product/product/captcha
2013-04-30 17:45:38 - all_time: 0.00263; count_queries: 00011 /index.php?route=product/product/review&product_id=95
2013-04-30 17:45:48 - all_time: 0.03336; count_queries: 00187 /teplovie-pyshki-Kerona/
2013-04-30 17:46:08 - all_time: 0.00169; count_queries: 00009 /index.php?route=record/record/captcham
2013-04-30 17:46:52 - all_time: 0.04405; count_queries: 00201 /snegoyborshiki/
2013-04-30 17:47:02 - all_time: 0.02896; count_queries: 00118 /remont/
2013-04-30 17:47:06 - all_time: 0.05110; count_queries: 00208 /motorpumps/motopompi-Robin-Subaru/
2013-04-30 17:47:25 - all_time: 0.03875; count_queries: 00195 /armada/
2013-04-30 17:47:35 - all_time: 0.06002; count_queries: 00223 /generatory/
2013-04-30 17:47:39 - all_time: 0.36770; count_queries: 00209 /
2013-04-30 17:48:10 - all_time: 0.02714; count_queries: 00224 /
2013-04-30 17:48:57 - all_time: 0.04242; count_queries: 00209 /
2013-04-30 17:49:49 - all_time: 0.04794; count_queries: 00208 /compressori_REMEZA/
2013-04-30 17:50:20 - all_time: 0.02508; count_queries: 00190 /motorpumps/motopompi-Robin-Subaru/
2013-04-30 17:50:34 - all_time: 0.02157; count_queries: 00190 /motorpumps/motopompi-Robin-Subaru/
2013-04-30 17:51:07 - all_time: 0.02574; count_queries: 00224 /
2013-04-30 17:51:39 - all_time: 0.02529; count_queries: 00189 /Boat_motors_Honda/
2013-04-30 17:51:40 - all_time: 0.07277; count_queries: 00181 /arenda-kompressora-Abac-D3-50.html
2013-04-30 17:51:41 - all_time: 0.08507; count_queries: 00179 /benzinovii-generator-CHAMPION-IGG1100.html
2013-04-30 17:51:42 - all_time: 0.07911; count_queries: 00178 /benzogenerator-robin-subaru-eb12-230-sle.html
2013-04-30 17:52:11 - 0.60820
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '70'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '105'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '96'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '76'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '59'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '71'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '72'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '60'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '73'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '74'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '104'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '99'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '100'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '106'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '109'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '108'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '103'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '111'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '77'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '97'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '107'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '98'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '69'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '64'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '83'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '84'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '81'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '86'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '85'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '88'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '110'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '92'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '90'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '93'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '94'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '91'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '101'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '102'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) UNION
(SELECT DISTINCT
cd.name as blog_name, rd.name as record_name, comm.*,
comm.date_added as date_available,
comm.review_id as commentid,
rec.viewed as record_viewed, comm.rating as rating, c.category_id as blog_id, rec.image,
(SELECT AVG(rating) AS total FROM di_review r1
WHERE
r1.product_id = rec.product_id
AND
r1.status = '1'
GROUP BY r1.product_id) AS rating_avg,
(SELECT COUNT(*) AS total FROM di_review r2
WHERE
r2.product_id = rec.product_id
AND
r2.status = '1'
GROUP BY r2.product_id) AS record_comments,
'categories' as type
FROM di_category c
LEFT JOIN di_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN di_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN di_product_to_category r2b ON (c.category_id = r2b.category_id)
LEFT JOIN di_product rec ON (rec.product_id = r2b.product_id)
LEFT JOIN di_product_to_store r2s ON (r2s.product_id = rec.product_id)
LEFT JOIN di_product_description rd ON (rec.product_id = rd.product_id)
LEFT JOIN di_review comm ON (rec.product_id = comm.product_id)
WHERE c.category_id = '82'
AND cd.language_id = '1'
AND rd.language_id = '1'
AND c2s.store_id = '0'
AND r2s.store_id = '0'
AND c.status = '1'
AND rec.status = '1'
AND comm.status = '1'
) ORDER BY commentid DESC LIMIT 0,4
2013-04-30 17:52:31 - all_time: 0.63432; count_queries: 00209 /
2013-04-30 17:52:37 - all_time: 0.00186; count_queries: 00007 /index.php?product_id=291&route=product/product
2013-04-30 17:53:56 - all_time: 0.07113; count_queries: 00180 /gazovii-nagrevatel-fa50p.html
2013-04-30 17:53:56 - all_time: 0.06900; count_queries: 00209 /
2013-04-30 17:54:24 - all_time: 0.03137; count_queries: 00216 /
2013-04-30 18:02:06 - all_time: 0.00189; count_queries: 00007 /index.php?product_id=179&route=product/product
2013-04-30 18:04:16 - all_time: 0.02959; count_queries: 00209 /
2013-04-30 18:05:15 - all_time: 0.02608; count_queries: 00209 /
2013-04-30 18:06:40 - all_time: 0.02960; count_queries: 00209 /
2013-04-30 18:08:41 - all_time: 0.02234; count_queries: 00209 /
2013-04-30 18:09:49 - all_time: 0.02208; count_queries: 00209 /
2013-04-30 18:13:04 - all_time: 0.02875; count_queries: 00215 /
2013-04-30 18:13:53 - all_time: 0.02614; count_queries: 00209 /
2013-04-30 18:15:04 - all_time: 0.02592; count_queries: 00209 /
2013-04-30 18:15:11 - all_time: 0.02437; count_queries: 00209 /
2013-04-30 18:15:53 - all_time: 0.02785; count_queries: 00209 /
2013-04-30 18:16:17 - all_time: 0.07712; count_queries: 00181 /Honda-HSS-655-ETS.html
2013-04-30 18:16:25 - all_time: 0.37347; count_queries: 00209 /

 

  и error

PHP Notice:  Undefined variable: tab_description in /home/l/*/public_html/catalog/view/theme/default/template/product/product.tpl on line 231
PHP Notice:  Undefined variable: tab_attribute in /home/l/*/public_html/catalog/view/theme/default/template/product/product.tpl on line 233
PHP Notice:  Undefined variable: tab_review in /home/l/*/public_html/catalog/view/theme/default/template/product/product.tpl on line 236
PHP Notice:  Undefined variable: tab_related in /home/l/*/public_html/catalog/view/theme/default/template/product/product.tpl on line 239

сайт ошибками сыпет, пишет в лог. начните с этого.
установите dblog https://opencartforum.com/files/file/786-db-log/
скиньте сюда ваши логи

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

От: (абонент)

Сообщение: Ну вот уже яснее, спасибо.

Кстати, сейчас ответ в пределах 0.5секунды на обоих доменах. Т.е. опять всё стало нормально..

От: (техподдержка 1)

Сообщение: Доброго времени суток!

Не совсем понимаем, как это может быть связанно с нашим хостингом. Как Вам уже отвечали, у Ваших скриптов возникают проблемы при ресолвинге myopencart.net. Как часто Ваши скрипты это делают и зачем, лучше уточнить у разработчика Вашего сайта.

--

С уважением,

От: (техподдержка 2)

Сообщение: Доброго времени суток!

Это потому что мы в качестве тесте прописали в резольвер

127.0.0.1 myopencart.net

127.0.0.1 www.myopencart.net

Сейчас опять убрали.

--

С уважением,

От: (абонент)

Сообщение: Будем выяснять.. Спасибо

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Ошибки:

PHP Notice:  Undefined index: HTTP_HOST in /home/*/index.php on line 177

а именно:

setcookie('language', $code, time() + 60 * 60 * 24 * 30, '/', $request->server['HTTP_HOST']);

PHP Notice:  Undefined index: HTTP_HOST in /home/*/system/library/currency.php on line 45

 

setcookie('currency', $currency, time() + 60 * 60 * 24 * 30, '/', $this->request->server['HTTP_HOST']);

PHP Notice:  Undefined index: SERVER_NAME in /home/*/system/library/response.php(68) : eval()'d code on line 22

 

Эм.. тут строчка содержит только "}"

PHP Notice:  Undefined index: REQUEST_METHOD in /home/*/admin/controller/common/login.php on line 14

 

if (($this->request->server['REQUEST_METHOD'] == 'POST') && $this->validate()) {

 

Ещё наблюдаю непонятный файл "str.out" в корне сайта

 

upd: кстати, ещё ниже тема https://opencartforum.com/topic/21229-skorost-zagruzki/  видимо с подобной ситуацией..

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

baxabit, у вас какой-то вирусняк, который обращается к myopencart.net , возможно конфиги переопределяет.

Весь спектр услуг.

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

baxabit, у вас какой-то вирусняк, который обращается к myopencart.net , возможно конфиги переопределяет.

Весь спектр услуг.

Странно, что он возник внезапно, и походу не у меня одного.

Наталкивает на мысли))

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

ребят. давайте по 1 проблеме в теме.

Elizaveta,

а этот sql на более 1300 строк, который висит 0,6 сек и выгребает 4 строки случайно не всем известный модуль блога?

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

ребят. давайте по 1 проблеме в теме.

Elizaveta,

а этот sql на более 1300 строк, который висит 0,6 сек и выгребает 4 строки случайно не всем известный модуль блога?

модуль блог стоит на сайте, но установлен он наверное с месяц назад, до этого проблем не было, да и сейчас скорость загрузки почему то восстановилась...

а с ним проблемы такие связаны?

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

попробуйте отключить. походите по сайту и прикрепите лог

  • +1 1

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

попробуйте отключить. походите по сайту и прикрепите лог

2013-04-30 20:41:22 - all_time: 0.07423; count_queries: 00180 /AirCast-%D0%A1%D0%914-%D0%A1-100-LB30.html

2013-04-30 20:41:35 - all_time: 0.00520; count_queries: 00008 /admin/

2013-04-30 20:41:37 - all_time: 0.00240; count_queries: 00010 /admin/index.php?route=common/login

2013-04-30 20:41:37 - all_time: 0.04389; count_queries: 00023 /admin/index.php?route=common/home&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:38 - all_time: 0.01279; count_queries: 00056 /admin/index.php?route=common/home/chart&token=4a9e7d463b0aee9db2475b8d760d907d&range=day

2013-04-30 20:41:39 - all_time: 0.00158; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:40 - all_time: 0.00169; count_queries: 00010 /admin/index.php?route=extension/module&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:41 - all_time: 0.00143; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:43 - all_time: 0.00126; count_queries: 00010 /admin/index.php?route=module/blog&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:44 - all_time: 0.00140; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:44 - all_time: 0.00374; count_queries: 00012 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:45 - all_time: 0.01616; count_queries: 00022 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:45 - all_time: 0.00124; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:46 - all_time: 0.07423; count_queries: 00135 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:46 - all_time: 0.00186; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:47 - all_time: 0.00169; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:47 - all_time: 0.00173; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:48 - all_time: 0.00141; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:41:57 - all_time: 0.02600; count_queries: 00186 /Boat_motors_Honda/

2013-04-30 20:42:06 - all_time: 0.00196; count_queries: 00010 /admin/index.php?route=extension/module&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:06 - all_time: 0.00181; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:16 - all_time: 0.02162; count_queries: 00011 /admin/index.php?route=module/slideshow&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:16 - all_time: 0.00126; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:21 - all_time: 0.00157; count_queries: 00010 /admin/index.php?route=extension/module&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:22 - all_time: 0.00179; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:25 - all_time: 0.01922; count_queries: 00010 /admin/index.php?route=extension/module/uninstall&token=4a9e7d463b0aee9db2475b8d760d907d&extension=slideshow

2013-04-30 20:42:25 - all_time: 0.00198; count_queries: 00010 /admin/index.php?route=extension/module&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:26 - all_time: 0.00117; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:31 - all_time: 0.00645; count_queries: 00015 /admin/index.php?route=extension/module/install&token=4a9e7d463b0aee9db2475b8d760d907d&extension=slideshow

2013-04-30 20:42:31 - all_time: 0.00187; count_queries: 00010 /admin/index.php?route=extension/module&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:32 - all_time: 0.00311; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:35 - all_time: 0.00196; count_queries: 00011 /admin/index.php?route=module/slideshow&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:36 - all_time: 0.00166; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:45 - all_time: 0.00254; count_queries: 00010 /admin/index.php?route=module/slideshow&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:45 - all_time: 0.00197; count_queries: 00010 /admin/index.php?route=extension/module&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:46 - all_time: 0.00132; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:49 - all_time: 0.11118; count_queries: 00223 /

2013-04-30 20:42:59 - all_time: 0.00232; count_queries: 00011 /admin/index.php?route=module/slideshow&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:42:59 - all_time: 0.00157; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:06 - all_time: 0.00258; count_queries: 00010 /admin/index.php?route=module/slideshow&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:06 - all_time: 0.00204; count_queries: 00010 /admin/index.php?route=extension/module&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:07 - all_time: 0.00164; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:09 - all_time: 0.02540; count_queries: 00223 /

2013-04-30 20:43:18 - all_time: 0.01511; count_queries: 00011 /admin/index.php?route=design/layout&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:19 - all_time: 0.00146; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:21 - all_time: 0.00365; count_queries: 00011 /admin/index.php?route=design/banner&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:22 - all_time: 0.00127; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:23 - all_time: 0.24865; count_queries: 00014 /admin/index.php?route=design/banner/update&token=4a9e7d463b0aee9db2475b8d760d907d&banner_id=7

2013-04-30 20:43:24 - all_time: 0.00152; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:26 - all_time: 0.00203; count_queries: 00011 /admin/index.php?route=design/banner&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:27 - all_time: 0.00137; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:28 - all_time: 0.00229; count_queries: 00011 /admin/index.php?route=design/layout&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:28 - all_time: 0.00142; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:30 - all_time: 0.00222; count_queries: 00010 /admin/index.php?route=extension/module&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:31 - all_time: 0.00143; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:37 - all_time: 0.00211; count_queries: 00011 /admin/index.php?route=module/slideshow&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:38 - all_time: 0.00163; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:46 - all_time: 0.00320; count_queries: 00010 /admin/index.php?route=module/slideshow&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:46 - all_time: 0.00228; count_queries: 00010 /admin/index.php?route=extension/module&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:47 - all_time: 0.00122; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:43:49 - all_time: 0.02734; count_queries: 00224 /

2013-04-30 20:44:09 - all_time: 0.00186; count_queries: 00011 /admin/index.php?route=module/slideshow&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:09 - all_time: 0.00165; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:14 - all_time: 0.00227; count_queries: 00010 /admin/index.php?route=module/slideshow&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:14 - all_time: 0.00176; count_queries: 00010 /admin/index.php?route=extension/module&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:15 - all_time: 0.00168; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:17 - all_time: 0.02713; count_queries: 00224 /

2013-04-30 20:44:36 - all_time: 0.00273; count_queries: 00010 /admin/index.php?route=module/blog&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:37 - all_time: 0.00154; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:37 - all_time: 0.00257; count_queries: 00012 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:38 - all_time: 0.00157; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:38 - all_time: 0.00134; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:39 - all_time: 0.00144; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:39 - all_time: 0.00154; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:40 - all_time: 0.00126; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:40 - all_time: 0.00156; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:41 - all_time: 0.00167; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:41 - all_time: 0.00177; count_queries: 00009 /admin/index.php?route=catalog/blog&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:42 - all_time: 0.00158; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:48 - all_time: 0.02277; count_queries: 00016 /admin/index.php?route=catalog/blog/update&token=4a9e7d463b0aee9db2475b8d760d907d&blog_id=1

2013-04-30 20:44:49 - all_time: 0.00164; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:44:59 - all_time: 0.00188; count_queries: 00009 /admin/index.php?route=catalog/blog&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:00 - all_time: 0.00173; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:01 - all_time: 0.00223; count_queries: 00010 /admin/index.php?route=module/blog&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:02 - all_time: 0.04205; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:02 - all_time: 0.00240; count_queries: 00012 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:03 - all_time: 0.00135; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:03 - all_time: 0.00195; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:04 - all_time: 0.00164; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:04 - all_time: 0.00167; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:05 - all_time: 0.00151; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:05 - all_time: 0.00192; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:06 - all_time: 0.00163; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:14 - all_time: 0.02412; count_queries: 00209 /

2013-04-30 20:45:21 - all_time: 0.00411; count_queries: 00021 /admin/index.php?route=module/blog&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:21 - all_time: 0.00270; count_queries: 00010 /admin/index.php?route=module/blog&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:22 - all_time: 0.00185; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:23 - all_time: 0.00235; count_queries: 00012 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:24 - all_time: 0.00273; count_queries: 00022 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:24 - all_time: 0.00161; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:25 - all_time: 0.01420; count_queries: 00087 /

2013-04-30 20:45:25 - all_time: 0.00135; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:26 - all_time: 0.04298; count_queries: 00008 /admin/index.php?route=module/blog/blogadmin&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:26 - all_time: 0.00149; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:26 - all_time: 0.00143; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:27 - all_time: 0.00141; count_queries: 00008 /admin/index.php?route=module/blog/ajax_list&token=4a9e7d463b0aee9db2475b8d760d907d

2013-04-30 20:45:38 - all_time: 0.01922; count_queries: 00121 /Honda_BF_5A4_SU.html

2013-04-30 20:45:38 - all_time: 0.00121; count_queries: 00006 /index.php?route=product/product/captcha

2013-04-30 20:45:39 - all_time: 0.00248; count_queries: 00008 /index.php?route=product/product/review&product_id=68

2013-04-30 20:47:19 - all_time: 0.04645; count_queries: 00169 /motorpumps/

2013-04-30 20:47:21 - all_time: 0.02201; count_queries: 00142 /Boat_motors_Honda/

2013-04-30 20:47:23 - all_time: 0.01986; count_queries: 00124 /HONDA_BF-20_D3_SHU.html

2013-04-30 20:47:23 - all_time: 0.00198; count_queries: 00009 /index.php?route=product/product/captcha

2013-04-30 20:47:24 - all_time: 0.00260; count_queries: 00011 /index.php?route=product/product/review&product_id=95

2013-04-30 20:47:38 - all_time: 0.02320; count_queries: 00150 /motorpumps/

2013-04-30 20:47:39 - all_time: 0.03400; count_queries: 00145 /armada/

2013-04-30 20:47:41 - all_time: 0.02927; count_queries: 00116 /remont/

2013-04-30 20:47:43 - all_time: 0.01070; count_queries: 00084 /

2013-04-30 20:47:44 - all_time: 0.04410; count_queries: 00164 /maslo-dlya-lodochnyih-motorov-Honda.html

2013-04-30 20:47:44 - all_time: 0.00190; count_queries: 00009 /index.php?route=product/product/captcha

2013-04-30 20:47:44 - all_time: 0.00181; count_queries: 00011 /index.php?route=product/product/review&product_id=299

2013-04-30 20:47:48 - all_time: 0.02535; count_queries: 00139 /teplovie-pyshki-Kerona/

2013-04-30 20:47:50 - all_time: 0.03226; count_queries: 00122 /gazovii-nagrevatel-fa150p.html

2013-04-30 20:47:50 - all_time: 0.00283; count_queries: 00011 /index.php?route=product/product/review&product_id=165

2013-04-30 20:47:50 - all_time: 0.00184; count_queries: 00009 /index.php?route=product/product/captcha

2013-04-30 20:47:51 - all_time: 0.05641; count_queries: 00175 /generatory/

2013-04-30 20:47:55 - all_time: 0.02324; count_queries: 00137 /generatory/generators-Robin-Subaru/Robin-Subaru-diezel/

2013-04-30 20:48:23 - all_time: 0.03924; count_queries: 00165 /compressori_REMEZA/

2013-04-30 20:48:26 - all_time: 0.01124; count_queries: 00084 /

2013-04-30 20:48:27 - all_time: 0.01019; count_queries: 00078 /index.php?route=information/contact

2013-04-30 20:48:27 - all_time: 0.00145; count_queries: 00009 /index.php?route=information/contact/captcha

2013-04-30 20:48:41 - all_time: 0.02021; count_queries: 00121 /Honda_BF_5A4_SU.html

2013-04-30 20:48:42 - all_time: 0.00135; count_queries: 00006 /index.php?route=product/product/captcha

2013-04-30 20:48:42 - all_time: 0.00254; count_queries: 00008 /index.php?route=product/product/review&product_id=68

2013-04-30 20:48:43 - all_time: 0.01000; count_queries: 00078 /index.php?route=information/contact

2013-04-30 20:48:44 - all_time: 0.00183; count_queries: 00009 /index.php?route=information/contact/captcha

2013-04-30 20:49:28 - all_time: 0.00208; count_queries: 00009 /index.php?route=information/contact

2013-04-30 20:49:29 - all_time: 0.00983; count_queries: 00078 /index.php?route=information/contact/success

2013-04-30 20:49:29 - all_time: 0.01575; count_queries: 00121 /Honda_BF_5A4_SU.html

2013-04-30 20:49:29 - all_time: 0.00095; count_queries: 00006 /index.php?route=product/product/captcha

2013-04-30 20:49:30 - all_time: 0.00221; count_queries: 00008 /index.php?route=product/product/review&product_id=68

2013-04-30 20:50:16 - all_time: 0.01400; count_queries: 00144 /compressori_REMEZA/

2013-04-30 20:50:18 - all_time: 0.04401; count_queries: 00146 /index.php?route=product/special&limit=50

2013-04-30 20:50:22 - all_time: 0.27309; count_queries: 00123 /Honda_BF60A_LRTU.html

2013-04-30 20:50:22 - all_time: 0.00172; count_queries: 00009 /index.php?route=product/product/captcha

2013-04-30 20:50:23 - all_time: 0.00251; count_queries: 00011 /index.php?route=product/product/review&product_id=102

2013-04-30 20:50:27 - all_time: 0.00765; count_queries: 00084 /

2013-04-30 20:52:13 - all_time: 0.01523; count_queries: 00101 /Boat_motors_Honda/shtyrval/

2013-04-30 20:52:45 - all_time: 0.02267; count_queries: 00118 /benzogenerator-Honda-EG4500-CX-RG.html

2013-04-30 20:53:27 - all_time: 0.03751; count_queries: 00153 /snegoyborshiki/

2013-04-30 20:53:34 - all_time: 0.03092; count_queries: 00146 /generatory/generatori-Pramac/generators_diesel_Pramac/trehfaznie_dizelgeneratori_Prama/

2013-04-30 20:53:37 - all_time: 0.01985; count_queries: 00122 /Prama%D1%81-P-9000ta.html

2013-04-30 20:53:37 - all_time: 0.00200; count_queries: 00009 /index.php?route=product/product/captcha

2013-04-30 20:53:38 - all_time: 0.00249; count_queries: 00011 /index.php?route=product/product/review&product_id=137

2013-04-30 20:53:47 - all_time: 0.03307; count_queries: 00148 /generatory/generators-HONDA/

2013-04-30 20:53:49 - all_time: 0.01682; count_queries: 00121 /benzogenerator-Honda-EU20i-K1-RGG3.html

2013-04-30 20:53:49 - all_time: 0.00186; count_queries: 00009 /index.php?route=product/product/captcha

2013-04-30 20:53:49 - all_time: 0.00210; count_queries: 00011 /index.php?route=product/product/review&product_id=173

2013-04-30 20:53:54 - all_time: 0.00350; count_queries: 00011 /index.php?route=product/compare/add

2013-04-30 20:53:58 - all_time: 0.04028; count_queries: 00161 /generatory/generators-CHAMPION/CHAMPION-benzin/

2013-04-30 20:54:01 - all_time: 0.02179; count_queries: 00123 /benzinovii-generator-CHAMPION-GG950DC.html

2013-04-30 20:54:01 - all_time: 0.00202; count_queries: 00009 /index.php?route=product/product/captcha

2013-04-30 20:54:01 - all_time: 0.00285; count_queries: 00011 /index.php?route=product/product/review&product_id=251

2013-04-30 20:54:03 - all_time: 0.00349; count_queries: 00011 /index.php?route=product/compare/add

2013-04-30 20:54:05 - all_time: 0.02115; count_queries: 00093 /index.php?route=product/compare

2013-04-30 20:54:14 - all_time: 0.01012; count_queries: 00084 /

2013-04-30 20:54:24 - all_time: 0.00200; count_queries: 00009 /index.php?route=product/compare&remove=199

2013-04-30 20:54:24 - all_time: 0.01557; count_queries: 00089 /index.php?route=product/compare

2013-04-30 20:54:26 - all_time: 0.00198; count_queries: 00009 /index.php?route=product/compare&remove=218

2013-04-30 20:54:27 - all_time: 0.01344; count_queries: 00085 /index.php?route=product/compare

2013-04-30 20:54:29 - all_time: 0.00179; count_queries: 00009 /index.php?route=product/compare&remove=173

2013-04-30 20:54:30 - all_time: 0.00871; count_queries: 00082 /index.php?route=product/compare

2013-04-30 20:54:32 - all_time: 0.00144; count_queries: 00009 /index.php?route=product/compare&remove=251

2013-04-30 20:54:32 - all_time: 0.00854; count_queries: 00078 /index.php?route=product/compare

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

все запросы в пределах нормы. думаю время загрузки заметно уменьшилось

  • +1 1

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

все запросы в пределах нормы. думаю время загрузки заметно уменьшилось

Да, спасибо большое за потраченное время, обращусь к разработчику модуля... все таки он платный....

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

все запросы в пределах нормы. думаю время загрузки заметно уменьшилось

Последний вопрос, вы сказали что сайт оишбками сыпет, а как бы проверить какими что бы их устранить?

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

все ошибки в логах, возможно не определены текстовые константы

  и error

PHP Notice:  Undefined variable: tab_description in /home/l/*/public_html/catalog/view/theme/default/template/product/product.tpl on line 231
PHP Notice:  Undefined variable: tab_attribute in /home/l/*/public_html/catalog/view/theme/default/template/product/product.tpl on line 233
PHP Notice:  Undefined variable: tab_review in /home/l/*/public_html/catalog/view/theme/default/template/product/product.tpl on line 236
PHP Notice:  Undefined variable: tab_related in /home/l/*/public_html/catalog/view/theme/default/template/product/product.tpl on line 239
  • +1 1

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

а этот sql на более 1300 строк, который висит 0,6 сек и выгребает 4 строки случайно не всем известный модуль блога?

Это тот, который от мастера по улучшению архитектуры опенкарт? :)

Феерично, спасибо всем за находку. Я бы на месте сервера загнулся ещё на парсинге этого запроса, не дойдя до выполнения.

  • +1 1

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

все ошибки в логах, возможно не определены текстовые константы

 

  и error

PHP Notice:  Undefined variable: tab_description in /home/l/*/public_html/catalog/view/theme/default/template/product/product.tpl on line 231
PHP Notice:  Undefined variable: tab_attribute in /home/l/*/public_html/catalog/view/theme/default/template/product/product.tpl on line 233
PHP Notice:  Undefined variable: tab_review in /home/l/*/public_html/catalog/view/theme/default/template/product/product.tpl on line 236
PHP Notice:  Undefined variable: tab_related in /home/l/*/public_html/catalog/view/theme/default/template/product/product.tpl on line 239

в общем удалила лишние куски кода, отключила некоторые функции модуля блог и в общем то ошибки самоустранились )) , спасибо вам большое!!!

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

а этот sql на более 1300 строк, который висит 0,6 сек и выгребает 4 строки случайно не всем известный модуль блога?

Это тот, который от мастера по улучшению архитектуры опенкарт? :)

Феерично, спасибо всем за находку. Я бы на месте сервера загнулся ещё на парсинге этого запроса, не дойдя до выполнения.

 

Слушай давай без этих ваших сарказмов. ok? Умничать все умеют.

 

Там все как раз сделано так как в opencart.

И не разобравшись говорить не надо.

 

Пользователь включил вывод из всех категорий сразу, а их много и выключил кеширование для модуля.

А если вы посмотрите, запросы - полная копия запросов как в opencart

 

К тому же они сделаны отдельными и соединены через Union (а использование union более правильный метод, чем использовании OR (тем более что их было бы ой как много) (тогда индексы вообще не используются в отличии от union). Понятное дело что каждая категория - запрос, сколько хотите вывести - столько и запросов. (0.6 сек раз в сто лет сделать для супер перегруженного пользователем (и не забываем более 30 рекомендуемых товаров на странице товара у пользователя, которые и "ложат" mysql сервер)) запроса, это много?), так же и в opencart - отключите кеширование и вы такое увидите...  что не налазит не на одни ворота.

 

Это к вопросу о том, что действительно надо все запросы opencart оптимизировать и кеш не спасает.

 

Запрос кстати кешируется, а так как пользователь отключил кеширование модуля, понятное дело что случиться. Отключите кеширование в opencart вы и не такое увидите.

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Далее - у модуля было отключено кеширование, в конкретном случае

 

Плюс у товаров было более 30 рекомендованных товаров, что тоже дает ой какую нагрузку на БД со стороны стандартного opencart (поэтому и 0.6 запрос был, а у рекомендованных и того больше будет!).

 

Так что давайте не умничать, не разобравшись

 

Можете посмотреть сейчас, после включения кеширования. Загрузка моментальная.

 

P.S. Так что давайте не умничать и тем более не использовать сарказм не разобравшись в ситуации. Это выглядит очень не корректно. У каждого может возникнуть такая ситуация с пользователями. Уважайте друг друга.

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

О Солнцеликий! Простите смерда, что посмел улыбнуться в Вашу сторону без надлежащего разрешения.

При чём тут неуважение? Я Вас что, чести лишил, улыбнувшись на грандиозный запрос из 1365 строк? В котором, как заметил Freelancer, выбирается 4 записи.

Оправдания в стиле "у меня так же, как в опенкарт" вгоняют меня в ещё больший ступор. Если Вы этим подразумеваете, что "как там" -- это безусловно хорошо, то я, пожалуй, до 10 посчитаю. Нет, лучше до ста. А лучше - ну нафиг нашу высокоинтеллектуальную дискуссию. Разбирайтесь со своими тараканами и уважением сами, пока не поймёте, что у других может и не быть никакого тайного желания Вас оскорбить или унизить. Иногда улыбка - это просто улыбка.

(хищно, в сторону) и запись в досье! (демонический смех, быстро удаляющийся, свет гаснет, занавес закрывается)

  • +1 1

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Сказать нечего, клоунизм

Хватит разводить демагогию

Вы наверно не отличите union от кучи Left Join c OR вместе, для вас это одно и тоже.

Для тех, кто не в курсе: Все UNION (для sql интерпретатора) выполняются как отдельные запросы

 

Все UNION выполняются как отдельные запросы и результаты складываются во временную таблицу, и потом MySQL работает уже с этой таблицей, т.е. проходясь циклом по записям в ней

 

Т.е. для интерпретатора 1300 строк - это всего навсего запросы (40, что всего 10% от всех запросов opencart на страницу, т.е. каждый запрос с LJ и подзапросами всего 0.015 с) по 30 строк.

И речь шла не о 0.6 сек этого запроса, который к тому же кешируется (если включено кеширование для модуля, в данном конкретном случае - оно было выключено, но даже это, ни как бы не повлияло так на скорость)

Так что с вами - "всё понятно"

И читайте внимательно:
 

модуль блог стоит на сайте, но установлен он наверное с месяц назад, до этого проблем не было, да и сейчас скорость загрузки почему то восстановилась...

 

Высказывания в стиле:  " - Акелла промахнулся..."

  • +1 1

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

А дайте пожалуйста, какой именно самый медленный запрос в модуле блога?. Общими усилиями оптимизируем. Не одним кэшированием лечить.

 

P.S. Цели других чмырить не имею, все ошибаются.

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

 

А дайте пожалуйста, какой именно самый медленный запрос в модуле блога?. Общими усилиями оптимизируем. Не одним кэшированием лечить.

 

P.S. Цели других чмырить не имею, все ошибаются.

 

Да он собственно не медленный, просто чем больше категорий "выделено" - тем больше запросов.  Для mysql UNION - это не один запрос, а разные запросы. Сами по себе они по скорости в пределах нормы, просто надо понимать, что когда вы "выделяете" 50 категорий, то это как минимум плюс 50 запросов, хотя в 99% случаев можно "выделять" только главные категории, что сокращает очень сильно количество "выделенных" категорий и соответственно запросов.

 

Сами по себе запросы сделаны правильно и объедены UNION, как раз для того, чтобы использовались индексы, если бы были Left Join и OR-ы (как раз как делают многие) - можно было бы позабыть тогда про использование индексов.

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

есть мнение, что этот запрос можно оптимизировать. например не добавлять новые UNION если уже достигнут лимит

Поделиться сообщением


Ссылка на сообщение
Поделиться на другие сайты

Для публикации сообщений создайте учётную запись или авторизуйтесь

Вы должны быть пользователем, чтобы оставить комментарий

Создать учетную запись

Зарегистрируйте новую учётную запись в нашем сообществе. Это очень просто!

Регистрация нового пользователя

Войти

Уже есть аккаунт? Войти в систему.

Войти

  • Последние посетители   0 пользователей онлайн

    Ни одного зарегистрированного пользователя не просматривает данную страницу

×

Важная информация

На нашем сайте используются файлы cookie и происходит обработка некоторых персональных данных пользователей, чтобы улучшить пользовательский интерфейс. Чтобы узнать для чего и какие персональные данные мы обрабатываем перейдите по ссылке. Если Вы нажмете «Я даю согласие», это означает, что Вы понимаете и принимаете все условия, указанные в этом Уведомлении о Конфиденциальности.