Тормоза, отловил, что сделать

[tyber]

Итак господа, надоело мне платить бабки нерадивым горе оптимизаторам которые тока крыльями машут как питухи а сделать ничего не могут, в итоге фраза "у тя сервер ховно разбирайся сам" да и бадягу разводить по две недели на форуме где никто не мождет толком на что-то ответить, приходится самому садится и разбиратся, чайнику полному,

 

Проблема долго открывается категория

Движек 1.5.5.1.1

вот этот поганых запрос, сами видите время

2013-11-08 6:12:06 - all_time: 9.06868; count_queries: 00320 /r-u-modeli/

 

на какие байтоны нажать чтобы его прибить? счетчики мне нафиг ненужны никакие, но отсюда вылезает вполне законный вопрос ребятам из OcTeam, Насколько я могу понять это они пилили ОсСторе, и как я понял если я выключаю подсчет товара в категории то судя по коду они его реально вырубили, но тогда откуда берется этот запрос?

[freelancer]

это не запрос.. это общее время запросов в базе. по нему можно сказать следующее

всего запросов 320, общее время ~9,07 секунды, страница /r-u-modeli/

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

[tyber]

понял спс щас покопаю

[tyber]

это не запрос.. это общее время запросов в базе. по нему можно сказать следующее

всего запросов 320, общее время ~9,07 секунды, страница /r-u-modeli/

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

Тогда я немного не понял синтаксиса лога

вот все что выше шло как их разгребать

2013-11-13 7:21:23 - all_time: 0.04843; count_queries: 00225 /1004-podschipniki-3x6x2-5mm-2scht-.html

2013-11-13 7:21:30 - all_time: 0.06812; count_queries: 00225 /10748-control-box-complete--ez-sta.html

2013-11-13 7:21:39 - all_time: 0.01980; count_queries: 00158 /index.php?route=module/cart

2013-11-13 7:21:53 - all_time: 0.06071; count_queries: 00225 /4694-plastina-schassi-6061-trophy-buggy-flux-gunmetal-.html

2013-11-13 7:22:09 - all_time: 0.02431; count_queries: 00158 /index.php?route=module/cart

2013-11-13 7:22:14 - all_time: 0.05503; count_queries: 00225 /16492-traxxas-sealed-receiver-box-set.html

2013-11-13 7:22:24 - all_time: 0.06764; count_queries: 00225 /10049-megax-brushless-mb20-3012.html

2013-11-13 7:22:30 - all_time: 0.05088; count_queries: 00225 /9273-5-0-mm-anti-roll-bar-ball-end-4-.html

2013-11-13 7:22:37 - all_time: 0.12503; count_queries: 00226 /9784-gp-mt-4wd-r-s-giga-crusher-sf-w-gxr28.html

2013-11-13 7:22:41 - all_time: 5.20391; count_queries: 00306 /r-u-modeli/

[tyber]

вот самый свежий запрос удалил файл слоу и жмакал по /r-u-modeli/

2013-11-13 8:07:05 - 0.57431 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2892'
2013-11-13 8:07:05 - 0.53397 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2896'
2013-11-13 8:07:07 - all_time: 0.45599; count_queries: 00225 /10988-7-4v-300mah-lipo-battery-mini-cub.html
2013-11-13 8:07:09 - all_time: 5.59614; count_queries: 00306 /r-u-modeli/
2013-11-13 8:07:14 - all_time: 0.04253; count_queries: 00174 /2-benzinovye-i-nitro-dvigateli-prinadlezhnosti/201-obem-ot-0-07-do-0-18/max-18cv-rx-w11j-carburettor-blue.html
2013-11-13 8:07:15 - all_time: 0.05410; count_queries: 00225 /11593-7l-70s-120seneedlevalveassembly.html
2013-11-13 8:07:22 - all_time: 0.06217; count_queries: 00225 /11594-fronthousing.html
2013-11-13 8:07:25 - 0.58411 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2895'
2013-11-13 8:07:28 - 0.52854 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '4090'
2013-11-13 8:07:30 - all_time: 5.27003; count_queries: 00306 /r-u-modeli/
2013-11-13 8:07:30 - all_time: 0.04800; count_queries: 00225 /11595-rearhousing.html
2013-11-13 8:07:36 - 0.57406 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2889'
2013-11-13 8:07:37 - 0.62667 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2895'
2013-11-13 8:07:37 - 0.55752 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2892'
2013-11-13 8:07:38 - all_time: 0.39568; count_queries: 00225 /11596-connectingrod.html
2013-11-13 8:07:39 - 0.62936 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2880'
2013-11-13 8:07:40 - 0.71076 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2897'
2013-11-13 8:07:40 - 0.69943 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2899'
2013-11-13 8:07:41 - 0.53452 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '4091'
2013-11-13 8:07:41 - 0.52569 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '4090'
2013-11-13 8:07:43 - all_time: 7.03404; count_queries: 00306 /r-u-modeli/
2013-11-13 8:07:45 - all_time: 0.06646; count_queries: 00225 /11597-rearrotor.html
2013-11-13 8:07:50 - 0.58275 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2889'
2013-11-13 8:07:50 - 0.51713 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2895'
2013-11-13 8:07:51 - 0.50582 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2892'
2013-11-13 8:07:51 - 0.65961 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2896'
2013-11-13 8:07:51 - all_time: 0.05852; count_queries: 00172 /108-hop-apy-i-tyuning/gs-storm-kronshteyn-usilitel-peredniy-ergal.html
2013-11-13 8:07:52 - 0.51491 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '3993'
2013-11-13 8:07:52 - 0.56861 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2880'
2013-11-13 8:07:53 - 0.63945 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '2899'
2013-11-13 8:07:53 - 0.55970 UPDATE product SET viewed = (viewed + 1) WHERE product_id = '11598'
2013-11-13 8:07:53 - all_time: 0.63120; count_queries: 00225 /11598-20c-46-86-91sneedlevalveassembly.html
2013-11-13 8:07:54 - 0.57104 SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product p ON (p2c.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= '2013-11-13 08:07:00' AND p2s.store_id = '0' AND cp.path_id = '4091'
2013-11-13 8:07:56 - all_time: 6.32014; count_queries: 00306 /r-u-modeli/
2013-11-13 8:08:01 - all_time: 0.07246; count_queries: 00225 /11599-20c-46-86-91s-c13needle.html
2013-11-13 8:08:08 - all_time: 0.11778; count_queries: 00224 /1160-remkomplekt-reduktora--metal-gear-set-s1903-s1903mg.html
2013-11-13 8:08:16 - all_time: 0.06543; count_queries: 00225 /11600-drivewasher61sx-rx-91sxh.html
2013-11-13 8:08:19 - all_time: 0.05876; count_queries: 00225 /6477-front-knuckle-l-dash-.html
2013-11-13 8:08:24 - all_time: 0.06722; count_queries: 00225 /11601-woodruff-key.html
2013-11-13 8:08:32 - all_time: 0.12882; count_queries: 00225 /11602-61fxcrankshaftballbearing-f-.html
2013-11-13 8:08:35 - all_time: 0.09841; count_queries: 00225 /6061-schiny-baggi-1-8--hb-block-2scht-pink-extra-soft.html
2013-11-13 8:08:39 - all_time: 0.06514; count_queries: 00225 /11603-crankcase61fx.html
2013-11-13 8:08:47 - all_time: 0.06135; count_queries: 00225 /11604-crankshaft61fx.html
2013-11-13 8:08:55 - all_time: 0.19903; count_queries: 00225 /11605-cylinder--pistonassembly61fx.html
2013-11-13 8:09:05 - 1.97156 SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '11606' AND od.language_id = '1' ORDER BY o.sort_order
2013-11-13 8:09:06 - all_time: 2.26798; count_queries: 00225 /11606-c-y-l-i-n-d-e-r-h-e-a-d--w--g-a-s-k-e-t--6-1-f-x.html
2013-11-13 8:09:10 - all_time: 0.24594; count_queries: 00225 /11608-61fxcarburettorcomplete-60c-.html
2013-11-13 8:09:19 - all_time: 0.13644; count_queries: 00225 /11607-coverplatebody61fx.html
2013-11-13 8:09:25 - all_time: 0.06943; count_queries: 00224 /1161-komplekt-kvarcev-27-095-mgc-am-ch3-oranzhevyj-.html
2013-11-13 8:09:33 - all_time: 0.05489; count_queries: 00225 /11610-61fxneedlevalveholderassembly.html
2013-11-13 8:09:41 - all_time: 0.07594; count_queries: 00225 /11611-throttle-lever-assembly.html
2013-11-13 8:09:48 - all_time: 0.06825; count_queries: 00225 /11612-o-ring.html
2013-11-13 8:09:56 - all_time: 0.06269; count_queries: 00225 /11613-61sxh-sxh-wc-piston.html
2013-11-13 8:10:06 - 0.51942 SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '11614' AND od.language_id = '1' ORDER BY o.sort_order
2013-11-13 8:10:06 - all_time: 0.78523; count_queries: 00225 /11614-heatsinkhead61sxh-rxh.html
2013-11-13 8:10:12 - all_time: 0.14984; count_queries: 00227 /11615-61sxh-rxhconnectingrod.html
2013-11-13 8:10:19 - all_time: 0.08612; count_queries: 00225 /11617-61sxh-rxh-61fxgasketset.html
2013-11-13 8:10:27 - all_time: 0.30410; count_queries: 00225 /11618-carburettorrubbergasket60b.html
2013-11-13 8:10:35 - all_time: 0.05739; count_queries: 00225 /11619-60bcarburettorsealingwasher.html
2013-11-13 8:10:42 - all_time: 0.07770; count_queries: 00225 /18674-mini-wildcat-catamaran-rtr-yellow-.html
2013-11-13 8:10:50 - all_time: 0.05713; count_queries: 00225 /11620-piston-pin-retainer-91fx-91sz-rz-91sxh.html

[tyber]

Насколько я понимаю грузят загрузку эти вот запросы?

SELECT COUNT(DISTINCT p.product_id) AS total FROM category_path cp LEFT JOIN product_to_category p2c ON

 

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

[freelancer]

это подсчет кол-ва товаров в категориях

[tyber]

Торпочило очень помог куда копать в какую сторону. Вобщем SQL походу непричем, тормозит сам сайт. Первое что хочу сделать это направить CDN скриптов на googl. Подскажите как это делается?

[freelancer]

так в чем причина была?

[ingenerks]

Торпочило очень помог куда копать в какую сторону. Вобщем SQL походу непричем, тормозит сам сайт. Первое что хочу сделать это направить CDN скриптов на googl. Подскажите как это делается?

https://opencartforum.com/topic/16965-uvelichivaem-skorost-zagruzki-stranitc-opencart/

[Ostmetal]

Прогоните сайт через http://gtmetrix.com/. Он сразу выдаст кучу рекомендаций, что делать. Ваша цель достичь всех зеленых линий в графе Grade любыми способами.

 

Для CDN в официальном репозитарии есть бесплатный плагин "Speed by loading Jquery from Google CDN". Также посмотрите отличный плагин "Add to Head for Opencart", который поможет вам разнести загрузку стилей и скриптов по шаблонам, где они нужны.