Перейти до вмісту
Пошук в
  • Детальніше...
Шукати результати, які ...
Шукати результати в ...

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


Elizaveta

Recommended Posts

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

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

 

 

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

Надіслати
Поділитися на інших сайтах


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

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

у Ваших скриптов возникают проблемы при ресолвинге 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 , возможно конфиги переопределяет.

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

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

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

Надіслати
Поділитися на інших сайтах


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

Elizaveta,

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

Надіслати
Поділитися на інших сайтах

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

Elizaveta,

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

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

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

Надіслати
Поділитися на інших сайтах


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

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

Надіслати
Поділитися на інших сайтах


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

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

Надіслати
Поділитися на інших сайтах


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

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

Надіслати
Поділитися на інших сайтах


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

  и 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
Надіслати
Поділитися на інших сайтах

  • 2 weeks later...

 

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

 

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

 

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

 

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

Надіслати
Поділитися на інших сайтах

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

 

:)

 

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

 

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

Надіслати
Поділитися на інших сайтах

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

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

 

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

 

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

Надіслати
Поділитися на інших сайтах

Створіть аккаунт або увійдіть для коментування

Ви повинні бути користувачем, щоб залишити коментар

Створити обліковий запис

Зареєструйтеся для отримання облікового запису. Це просто!

Зареєструвати аккаунт

Вхід

Уже зареєстровані? Увійдіть тут.

Вхід зараз
  • Зараз на сторінці   0 користувачів

    • Ні користувачів, які переглядиють цю сторінку
×
×
  • Створити...

Important Information

На нашому сайті використовуються файли cookie і відбувається обробка деяких персональних даних користувачів, щоб поліпшити користувальницький інтерфейс. Щоб дізнатися для чого і які персональні дані ми обробляємо перейдіть за посиланням . Якщо Ви натиснете «Я даю згоду», це означає, що Ви розумієте і приймаєте всі умови, зазначені в цьому Повідомленні про конфіденційність.