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

[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 ...>

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

 

 

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

[freelancer]

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

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

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

[baxabit]

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

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

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

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

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

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

[Elizaveta]

логи из файла 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/
скиньте сюда ваши логи

[baxabit]

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

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

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

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

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

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

--

С уважением,

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

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

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

127.0.0.1 myopencart.net

127.0.0.1 www.myopencart.net

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

--

С уважением,

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

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

[baxabit]

Ошибки:

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]

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

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

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

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

[freelancer]

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

Elizaveta,

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

[Elizaveta]

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

Elizaveta,

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

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

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

[freelancer]

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

[Elizaveta]

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

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

[freelancer]

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

[Elizaveta]

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

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

[Elizaveta]

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

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

[freelancer]

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

  и 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

[rb2]

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

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

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

[Elizaveta]

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

 

  и 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

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

[markimax]

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

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

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

 

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

 

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

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

 

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

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

 

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

 

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

 

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

[markimax]

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

 

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

 

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

 

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

 

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

[rb2]

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

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

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

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

[markimax]

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

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

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

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

 

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

 

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

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

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

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

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

 

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

[markimax]

 

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

 

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

 

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

 

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

[freelancer]

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

[markimax]

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

 

:)

 

Нет, в данном случае, все равно будут "перебираться" все отзывы и товары (LJ не забываем), limit - это чисто "обрезание" вычисленного результата

 

Если сделать на OR - ах, да запрос будет всего 50 строк, но..., тогда не будут использоваться индексы, и тогда даже на 1000 товарах и 50 категорий - запрос положит mysql, все равно будет создаваться временная таблица, но... уже без использования индексов, и вместо 0.6 сек будет исполняться наверно секунд 30 и так далее, прогрессия будет зависеть от количества товаров, а на UNION - не будет так сильно проседать.

[freelancer]

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

или ты можешь с уверенностью сказать что этот запрос нельзя сделать быстрее ?

 

тут ты сам себе противоречишь - с одной стороны Opencart сделал не правильно , всё в нем не так, всё надо переписать, но сам же используешь полные копии запросов

 

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