tyber

ВОт все что просили 777.xml

Живые есть? помогите с вопросом по категориям

Чтото я себе весь мозг поламал 1. Не могу распихать вновь добавляемый товар в разные категории на основании Вкладки данные. указываю Название категории в прайс листе (числовое у меня) и соответствующую категорию нажимаю старт пишет готово и ничего не происходит и ничего не добавляется 2. так же добавленый товар тоже не могу сменить категорию через вкладку данные. Куда копать?

Спасибо freelancer сделал все быстро и оперативно, буду обращаться к нему и впредь.

Требуется доработка! два пункта 1. обновление изменений сделаных в админке проходит только через час примерно, наверное чтото с кешем. 2. Сервер ВПС падает при приходе индексирующих роботов требуется исправить это Связь по личке.

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

необходимо решить два вопроса 1. После редактирования товара обновление не появляется на сайте 2. увеличение скорости работы а если конкретно чтобы не валился сервер когда на него приходят боты. требуется проанализировать и выявить проблемное место чтобы ВПС не заваливался.

да я тока вчера все сделал я даже модулей не ставил еще никаких

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

нууу это понятно и так, но ведь не решение же моей проблемы это

в errors вот такие ошибки валятся 2013-06-25 7:27:04 - PHP Notice: Undefined variable: keyword_in in /var/www/admin/data/www/********/vqmod/vqcache/vq2-catalog_controller_common_seo_pro.php on line 77 2013-06-25 7:27:05 - PHP Notice: Undefined variable: seo_title in /var/www/admin/data/www/***********/vqmod/vqcache/vq2-catalog_view_theme_bigshop_template_product_product.tpl on line 577

единственное изменение которое я делал это переименовывал папку Admin может чтото гдето не дописал.

тоже самое сейчас и у меня ТС как решил проблему??

Ребят что может быть за фигня редактирую товар в админке а он не изменяется на самом сайте. Хотя в админке то что я изменил видно.

вот может поможет это slow.log со значением 0.1 WHERE category_id IN (302) AND customer_group_id = 1 2013-06-24 17:30:36 - 1.53022 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '8495' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:30:37 - 1.35160 SELECT * FROM product_to_category WHERE product_id = '8495' 2013-06-24 17:30:38 - 0.47453 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '9190' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:30:38 - 0.46742 SELECT * FROM length_class mc LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1' 2013-06-24 17:30:38 - 0.27884 SELECT * FROM product_to_category WHERE product_id = '9190' 2013-06-24 17:30:38 - 0.22924 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '9191' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:30:38 - 0.31543 SELECT * FROM product_to_category WHERE product_id = '9191' 2013-06-24 17:30:39 - 0.33493 SELECT * FROM layout_route WHERE 'error/not_found' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1 2013-06-24 17:30:39 - 0.27015 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '9193' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:30:39 - 0.49239 SELECT * FROM extension WHERE `type` = 'module' 2013-06-24 17:30:40 - 0.72607 SELECT * FROM product_to_category WHERE product_id = '9193' 2013-06-24 17:30:41 - 0.12760 SELECT * FROM layout_route WHERE 'error/not_found' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1 2013-06-24 17:30:41 - all_time: 1.78203; count_queries: 00020 /2-dvigateli-vnutrennego-sgoraniya-i-prinadlezhnosti/208-svechi/8660-svecha-nakala-CP-02-STD-No-6-medium-.html 2013-06-24 17:30:41 - 0.65183 SELECT category_id FROM product_to_category WHERE product_id = '546' ORDER BY main_category DESC LIMIT 1 2013-06-24 17:30:42 - 0.14228 SELECT category_id FROM product_to_category WHERE product_id = '8460' ORDER BY main_category DESC LIMIT 1 2013-06-24 17:30:42 - 0.16052 SELECT category_id FROM product_to_category WHERE product_id = '5216' ORDER BY main_category DESC LIMIT 1 2013-06-24 17:30:43 - 0.60714 SELECT category_id FROM product_to_category WHERE product_id = '8495' ORDER BY main_category DESC LIMIT 1 2013-06-24 17:30:44 - 0.10531 SELECT category_id FROM product_to_category WHERE product_id = '9190' ORDER BY main_category DESC LIMIT 1 2013-06-24 17:30:44 - 0.10914 SELECT * FROM setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC 2013-06-24 17:30:44 - 0.17301 SELECT category_id FROM product_to_category WHERE product_id = '9191' ORDER BY main_category DESC LIMIT 1 2013-06-24 17:30:44 - 0.10042 SELECT * FROM language WHERE status = '1' 2013-06-24 17:30:45 - 0.15299 SELECT category_id FROM product_to_category WHERE product_id = '9193' ORDER BY main_category DESC LIMIT 1 2013-06-24 17:30:45 - 0.27748 SELECT category_id FROM product_to_category WHERE product_id = '12156' ORDER BY main_category DESC LIMIT 1 2013-06-24 17:30:45 - 0.24304 SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.parent_id, c.sort_order, cd.name 2013-06-24 17:30:46 - 0.70245 SELECT * FROM category_to_layout WHERE category_id = '302' AND store_id = '0' 2013-06-24 17:30:46 - 0.66839 SELECT COUNT(DISTINCT p.product_id) AS total FROM product p 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) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '2' 2013-06-24 17:30:46 - 0.63743 SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.parent_id, c.sort_order, cd.name 2013-06-24 17:30:46 - 0.29106 SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '3' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' 2013-06-24 17:30:46 - 0.32075 SELECT * FROM product_to_category WHERE product_id = '12156' 2013-06-24 17:30:46 - 0.23400 SELECT * FROM category_to_layout WHERE category_id = '2' AND store_id = '0' 2013-06-24 17:30:46 - 0.14914 SELECT DISTINCT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '302' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' 2013-06-24 17:30:46 - 0.10666 SELECT * FROM product_image WHERE product_id = '12156' ORDER BY sort_order ASC 2013-06-24 17:30:47 - 0.30863 SELECT * FROM layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1 2013-06-24 17:30:47 - 0.29608 SELECT category_id FROM product_to_category WHERE product_id = '12156' 2013-06-24 17:30:47 - 0.32009 SELECT * FROM category_to_layout WHERE category_id = '302' AND store_id = '0' 2013-06-24 17:30:47 - 0.14986 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '12159' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:30:47 - 0.13931 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '0' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:30:47 - 0.12825 SELECT * FROM product_to_category WHERE product_id = '12159' 2013-06-24 17:30:47 - 0.27135 SELECT * FROM extension WHERE `type` = 'total' 2013-06-24 17:30:48 - all_time: 17.33890; count_queries: 00079 /3-kuzova-i-antikrylya/302-masschtab-1-12-i-1-10/?page=6 2013-06-24 17:30:48 - 0.32665 SELECT SUM(amount) AS total FROM customer_transaction WHERE customer_id = '0' 2013-06-24 17:30:48 - all_time: 3.01410; count_queries: 00027 /2-benzinovye-i-nitro-dvigateli-prinadlezhnosti/ 2013-06-24 17:30:48 - 0.26456 SELECT category_id FROM product_to_category WHERE product_id = '12158' ORDER BY main_category DESC LIMIT 1 2013-06-24 17:30:49 - 0.18154 SELECT * FROM product_tag WHERE product_id = '12156' AND language_id = '1' 2013-06-24 17:30:49 - 0.16365 SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added FROM review r LEFT JOIN product p ON (r.product_id = p.product_id) LEFT JOIN product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '12156' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1' ORDER BY r.date_added DESC LIMIT 0,5 2013-06-24 17:30:50 - 0.56493 SELECT * FROM product_to_layout WHERE product_id = '12156' AND store_id = '0' 2013-06-24 17:30:50 - 0.24302 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '12156' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:30:51 - all_time: 5.19570; count_queries: 00070 /2-benzinovye-i-nitro-dvigateli-prinadlezhnosti/206-zapchasti-k-njtro-dvigatelyam/pistonpin-1.html 2013-06-24 17:30:57 - all_time: 0.11048; count_queries: 00007 /9-startovoe-oborudovanie/9298-natyazhitel-remnya-dlya-H6501-6502-.html 2013-06-24 17:31:09 - all_time: 0.77078; count_queries: 00033 /4-radioapparatura/401-moduli-dsm-i-fm/ 2013-06-24 17:31:15 - all_time: 0.15057; count_queries: 00007 /1-modelj/trial-i-trofi2/Axial-SCX10-Trail-Honcho-rtr.html 2013-06-24 17:31:17 - 0.48239 SELECT p.product_id FROM product p LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p2c.category_id = '1566' AND p.status = '1' AND p.date_available <= NOW() AND p.product_id <> '18077' ORDER BY p.product_id ASC LIMIT 4 2013-06-24 17:31:18 - 0.13592 SELECT MIN(price) as price, type FROM customer_group_price WHERE category_id IN (102,1566) AND customer_group_id = 1 2013-06-24 17:31:19 - all_time: 2.50331; count_queries: 00068 /1-modelj/trial-i-trofi2/axial-scx10-trail-honcho-rtr.html 2013-06-24 17:31:23 - all_time: 0.20193; count_queries: 00006 /index.php?route=product/product/captcha 2013-06-24 17:31:25 - all_time: 0.96698; count_queries: 00047 / 2013-06-24 17:31:37 - all_time: 0.12139; count_queries: 00007 /2pl-r152je-s30032-a40p1dd 2013-06-24 17:31:39 - all_time: 0.25700; count_queries: 00007 /2nd-pinion-gear-17t-vision 2013-06-24 17:31:40 - 0.11114 SELECT * FROM product_to_category WHERE product_id = '4157' 2013-06-24 17:31:40 - 0.12939 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 = '4157' AND od.language_id = '1' ORDER BY o.sort_order 2013-06-24 17:31:40 - 0.13163 SELECT * FROM extension WHERE `type` = 'module' 2013-06-24 17:31:41 - all_time: 2.39286; count_queries: 00069 /4-radioapparatura/402-komplekty-radioapparatury/2pl-r152je-s30032-a40p1dd.html 2013-06-24 17:31:42 - all_time: 2.16341; count_queries: 00065 /19-schesterni-dlya-modelej-s-dvs/2nd-pinion-gear-17t-vision.html 2013-06-24 17:32:16 - all_time: 0.09942; count_queries: 00007 /70-mikro-vertolety-i-prinadlezhnosti/8020-komplekt-tyag-Tracer-60-.html 2013-06-24 17:32:42 - all_time: 0.12748; count_queries: 00007 /14-schiny-diski-vstavki/1404-Off-Road-1-6-1-5-/8818-schiny-so-vstavkami-Spike-schirokie-myagkie--2scht-.html 2013-06-24 17:32:54 - all_time: 0.14200; count_queries: 00007 /2nd-gear08m28trrevofw-05r 2013-06-24 17:32:56 - all_time: 1.08251; count_queries: 00067 /20-zapasnye-chasti-dlya-avtomodelej/2nd-gear08m28trrevofw-05r.html 2013-06-24 17:33:14 - all_time: 1.15802; count_queries: 00070 /1-modelj/104-avtomodeli-1-6-i-bolsche/kupit-baggi-15-elektro-maverick-vader-xb-15-scale-4wd-electric-brushless-v-magazine-rc-tachkiru.html 2013-06-24 17:33:16 - all_time: 0.09650; count_queries: 00006 /index.php?route=product/product/captcha 2013-06-24 17:33:17 - all_time: 0.63879; count_queries: 00047 / 2013-06-24 17:33:29 - all_time: 1.27736; count_queries: 00068 /20-zapasnye-chasti-dlya-avtomodelej/shock-shafts-chromexxl25.html 2013-06-24 17:33:41 - all_time: 0.10625; count_queries: 00007 /front-hub-carrier22degmp777 2013-06-24 17:33:49 - all_time: 0.77047; count_queries: 00047 / 2013-06-24 17:34:08 - all_time: 0.29609; count_queries: 00020 /2-benzinovye-i-nitro-dvigateli-prinadlezhnosti/210-scepleniya-i-zapchasti-k-nim/7471-gajka-scepleniya-s-valom--M5-1scht-.html 2013-06-24 17:34:57 - all_time: 0.64180; count_queries: 00047 / 2013-06-24 17:35:00 - all_time: 0.09669; count_queries: 00007 /2nd-spur-gear-08m56t-rrevo 2013-06-24 17:35:01 - 0.15342 SELECT * FROM product_to_category WHERE product_id = '15277' 2013-06-24 17:35:01 - 0.14673 SELECT category_id FROM product_to_category WHERE product_id = '15277' 2013-06-24 17:35:03 - all_time: 1.77378; count_queries: 00067 /20-zapasnye-chasti-dlya-avtomodelej/2nd-spur-gear-08m56t-rrevo.html 2013-06-24 17:35:06 - all_time: 0.09431; count_queries: 00007 /35mmcrosspin 2013-06-24 17:35:08 - all_time: 0.96094; count_queries: 00067 /20-zapasnye-chasti-dlya-avtomodelej/35mmcrosspin.html 2013-06-24 17:35:13 - all_time: 0.28203; count_queries: 00020 /5-elektrodvigateli-regulyatory-i-prinadlezhnosti/704-aksessuary-dlya-regulyatorov/2910-ventilyator-High-speed-ESC-Fan.html 2013-06-24 17:35:42 - all_time: 0.70642; count_queries: 00047 / 2013-06-24 17:35:43 - all_time: 0.09669; count_queries: 00007 /2nd-spur-gear45t 2013-06-24 17:35:44 - 0.16520 SELECT * FROM product_to_category WHERE product_id = '15151' 2013-06-24 17:35:45 - 0.16687 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '15154' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:35:46 - 0.22670 UPDATE product SET viewed = (viewed + 1) WHERE product_id = '15151' 2013-06-24 17:35:46 - 0.31112 SELECT * FROM product_to_layout WHERE product_id = '15151' AND store_id = '0' 2013-06-24 17:35:47 - all_time: 2.02901; count_queries: 00067 /20-zapasnye-chasti-dlya-avtomodelej/2nd-spur-gear45t.html 2013-06-24 17:35:54 - all_time: 0.70081; count_queries: 00047 / 2013-06-24 17:36:23 - all_time: 0.73459; count_queries: 00047 / 2013-06-24 17:37:14 - all_time: 0.20339; count_queries: 00007 /receiver-r149dp-pcm40-wo-xtal 2013-06-24 17:37:14 - all_time: 0.24643; count_queries: 00007 /battery-form-scorpion-xxl-ve 2013-06-24 17:37:15 - all_time: 1.09836; count_queries: 00070 /2-benzinovye-i-nitro-dvigateli-prinadlezhnosti/206-zapchasti-k-njtro-dvigatelyam/air-clearer-mp9-tki2.html 2013-06-24 17:37:53 - all_time: 0.27802; count_queries: 00020 /18-tyagi-nakonechniki-scharovye/7516-Gr-5-6Al4v-Titanium-Ball-Stud-4-3mm-x-13-0mm-Long--4pcs-.html 2013-06-24 17:38:17 - all_time: 0.10669; count_queries: 00007 /20-zapasnye-chasti-dlya-avtomodelej/1344-servosejver-Tube-Assembly.html 2013-06-24 17:38:20 - all_time: 0.82119; count_queries: 00063 /20-zapasnye-chasti-dlya-avtomodelej/1344-servosejver-tube-assembly.html 2013-06-24 17:38:20 - all_time: 1.09068; count_queries: 00067 /20-zapasnye-chasti-dlya-avtomodelej/1344-servosejver-tube-assembly.html 2013-06-24 17:38:21 - all_time: 0.08170; count_queries: 00006 /index.php?route=product/product/captcha 2013-06-24 17:38:22 - all_time: 0.64554; count_queries: 00047 / 2013-06-24 17:38:40 - all_time: 0.09386; count_queries: 00007 /2-speed-clutch-tool-for-08module-gear 2013-06-24 17:38:49 - all_time: 0.95293; count_queries: 00065 /10-jnstrumenty-i-materialy/1007-namazka-smyvka-i-pr-/kupit-gel-dlya-ochistki-ruk-fastrax-cleaning-gum-v-magazine-rc-tachkiru.html 2013-06-24 17:38:49 - all_time: 1.13837; count_queries: 00070 /10-jnstrumenty-i-materialy/1007-namazka-smyvka-i-pr-/kupit-gel-dlya-ochistki-ruk-fastrax-cleaning-gum-v-magazine-rc-tachkiru.html 2013-06-24 17:39:10 - 0.27521 SELECT p.product_id, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM product p 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) LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '201' GROUP BY p.product_id ORDER BY p.quantity DESC, LCASE(pd.name) DESC LIMIT 0,10 2013-06-24 17:39:12 - all_time: 1.54083; count_queries: 00079 /2-benzinovye-i-nitro-dvigateli-prinadlezhnosti/201-obem-ot-0-07-do-0-18/ 2013-06-24 17:39:52 - all_time: 0.17425; count_queries: 00007 /pressure-form-7x44pcs 2013-06-24 17:39:52 - all_time: 0.18158; count_queries: 00007 /6650-korpus-differenciala-alyum- 2013-06-24 17:40:04 - all_time: 0.10167; count_queries: 00006 /aluminum-rear-lower-sus-holderl 2013-06-24 17:40:07 - 0.24869 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '16062' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:40:07 - 0.20904 SELECT * FROM product_to_category WHERE product_id = '16062' 2013-06-24 17:40:07 - 0.30571 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '16063' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:40:07 - 0.14579 SELECT * FROM product_to_category WHERE product_id = '16063' 2013-06-24 17:40:08 - 0.36437 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '16064' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:40:08 - 0.31145 SELECT * FROM product_to_category WHERE product_id = '16064' 2013-06-24 17:40:09 - 0.40807 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '16065' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:40:09 - 0.33309 SELECT * FROM product_to_category WHERE product_id = '16065' 2013-06-24 17:40:09 - 0.13467 UPDATE product SET viewed = (viewed + 1) WHERE product_id = '16062' 2013-06-24 17:40:10 - all_time: 3.53278; count_queries: 00063 /20-zapasnye-chasti-dlya-avtomodelej/aluminum-rear-lower-sus-holderl.html 2013-06-24 17:40:55 - all_time: 0.92029; count_queries: 00070 /1-modelj/101-mini-i-mikro/bandit.html 2013-06-24 17:40:57 - all_time: 0.07788; count_queries: 00006 /index.php?route=product/product/captcha 2013-06-24 17:40:59 - all_time: 0.35379; count_queries: 00020 /video/uppod.swf 2013-06-24 17:41:00 - all_time: 0.66886; count_queries: 00047 / 2013-06-24 17:41:11 - all_time: 0.08670; count_queries: 00007 /mini-z-buggy-optima-bluewhite 2013-06-24 17:41:12 - all_time: 0.12291; count_queries: 00007 /2pl-r153f-s30032-f40p1dd 2013-06-24 17:41:14 - all_time: 0.94779; count_queries: 00067 /4-radioapparatura/402-komplekty-radioapparatury/2pl-r153f-s30032-f40p1dd.html 2013-06-24 17:41:39 - all_time: 0.24261; count_queries: 00020 /11-vinty-schajby-gajki-i-prochee-metizy-/1104-prochee/3404-vint-ustanovochnyj-3x12mm.html 2013-06-24 17:41:51 - 0.11617 SELECT * FROM store WHERE REPLACE(`url`, 'www.', '') = 'http://www.сайт.ру/' 2013-06-24 17:41:51 - all_time: 0.18868; count_queries: 00007 /2mm-stopper-set-10 2013-06-24 17:41:52 - 0.11461 SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p 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) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '3367' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' 2013-06-24 17:41:53 - all_time: 0.98285; count_queries: 00067 /20-zapasnye-chasti-dlya-avtomodelej/2mm-stopper-set-10.html

вот что в логе творится 199.59.149.167 - - [24/Jun/2013:21:21:14 +0400] "GET /aluminum-rear-toe-out-mount-set-0-15-3-degree-for-a HTTP/1.1" 404 7033 "-" "Twitterbot/1.0" "-" 176.196.57.55 - - [24/Jun/2013:21:21:16 +0400] "GET /19-schesterni-dlya-modelej-s-dvs/ HTTP/1.1" 200 9288 "http://www.google.ru/url?sa=t&rct=j&q=%D1%88%D0%B5%D1%81%D1%82%D0%B5%D1%80%D0%BD%D0%B8%20%D0%B4%D0%BB%D1%8F%20%D0%BC%D0%BE%D0%B4%D0%B5%D0%BB%D0%B5%D0%B9&source=web&cd=10&ved=0CEMQFjAJ&url=http%3A%2F%2Frc-tachki.ru%2F19-schesterni-dlya-modelej-s-dvs%2F&ei=TX_IUcugKsWs4ATLioC4CQ&usg=AFQjCNHM_zUmHqDY50EsJm-qrXY-HjA9Vg&bvm=bv.48293060,d.bGE&cad=rjt" "Mozilla/5.0 (iPad; CPU OS 6_1_3 like Mac OS X) AppleWebKit/536.26 (KHTML, like Gecko) Version/6.0 Mobile/10B329 Safari/8536.25" "-" 184.169.219.196 - - [24/Jun/2013:21:21:16 +0400] "GET /aluminum-rear-upper-covermini-z-awdblu HTTP/1.1" 301 0 "-" "JS-Kit URL Resolver, http://js-kit.com/" "-" 184.169.192.68 - - [24/Jun/2013:21:21:16 +0400] "GET /108-hop-apy-i-tyuning/aluminum-rear-toe-out-mount-3-degree-for-associated-rc18t.html HTTP/1.1" 499 0 "-" "JS-Kit URL Resolver, http://js-kit.com/" "-" 54.241.198.78 - - [24/Jun/2013:21:21:16 +0400] "HEAD /aluminum-rear-upper-covermini-z-awdblu HTTP/1.1" 499 0 "-" "UnwindFetchor/1.0 (+http://www.gnip.com/)" "216.46.175.33, 10.179.39.22" 199.59.149.167 - - [24/Jun/2013:21:21:16 +0400] "GET /108-hop-apy-i-tyuning/aluminum-rear-toe-out-mount-3-degree-for-associated-rc18t.html HTTP/1.1" 499 0 "-" "Twitterbot/1.0" "-" 74.112.131.242 - - [24/Jun/2013:21:21:17 +0400] "GET /aluminum-rear-toe-out-mount-set-0-15-3-degree-for-a HTTP/1.1" 499 0 "-" "Mozilla/5.0 (compatible; Butterfly/1.0; +http://labs.topsy.com/butterfly/) Gecko/2009032608 Firefox/3.0.8" "-" 74.112.131.245 - - [24/Jun/2013:21:21:17 +0400] "GET /aluminum-rear-upper-covermini-z-awdblu HTTP/1.1" 499 0 "-" "Mozilla/5.0 (compatible; Butterfly/1.0; +http://labs.topsy.com/butterfly/) Gecko/2009032608 Firefox/3.0.8" "-" 74.112.131.245 - - [24/Jun/2013:21:21:17 +0400] "GET /aluminum-rear-toe-out-mount-set-0-15-3-degree-for-a HTTP/1.1" 499 0 "-" "Mozilla/5.0 (compatible; Butterfly/1.0; +http://labs.topsy.com/butterfly/) Gecko/2009032608 Firefox/3.0.8" "-" 74.112.131.244 - - [24/Jun/2013:21:21:17 +0400] "GET /aluminum-rear-upper-covermini-z-awdblu HTTP/1.1" 499 0 "-" "Mozilla/5.0 (compatible; Butterfly/1.0; +http://labs.topsy.com/butterfly/) Gecko/2009032608 Firefox/3.0.8" "-" 74.112.131.244 - - [24/Jun/2013:21:21:17 +0400] "GET /aluminum-rear-upper-plate-stallion HTTP/1.1" 499 0 "-" "Mozilla/5.0 (compatible; Butterfly/1.0; +http://labs.topsy.com/butterfly/) Gecko/2009032608 Firefox/3.0.8" "-" 46.236.24.52 - - [24/Jun/2013:21:21:17 +0400] "GET /aluminum-rear-upper-plate-stallion HTTP/1.1" 301 0 "-" "Mozilla/5.0 (compatible; TweetmemeBot/3.0; +http://tweetmeme.com/)" "-" 46.236.24.52 - - [24/Jun/2013:21:21:17 +0400] "GET /aluminum-rear-upper-covermini-z-awdblu HTTP/1.1" 499 0 "-" "Mozilla/5.0 (compatible; TweetmemeBot/3.0; +http://tweetmeme.com/)" "-" 54.241.198.78 - - [24/Jun/2013:21:21:17 +0400] "HEAD /aluminum-rear-upper-plate-stallion HTTP/1.1" 499 0 "-" "UnwindFetchor/1.0 (+http://www.gnip.com/)" "216.46.190.189, 10.196.6.45" 98.137.207.87 - - [24/Jun/2013:21:21:18 +0400] "GET /aluminum-rear-toe-out-mount-set-0-15-3-degree-for-a HTTP/1.0" 404 26955 "-" "NING/1.0" "-" 199.59.149.167 - - [24/Jun/2013:21:21:19 +0400] "GET /aluminum-rear-upper-covermini-z-awdblu HTTP/1.1" 301 0 "-" "Twitterbot/1.0" "-"

эмммм в каком виде? сами твиты чтоли или то что на сервере происходит в момент твитинга?

поменял не помогло опять заваливает Есть еще идеи?

подскажите в каких конфигах переименование делать? и я так понимаю это для безопасности?

Итак борюсь с темой двое суток. Я запихиваю страницы в индекс яндекса с помощью масствитинга програмулиной, которая раз в 5 секунд твитит ссылку на мой магазин, и мой хваленый ВПС с гигом оперативы падает нафиг потому что приходят боты на сайт и валят его. я написал в тех поддержку и они прислали мне такой ответ. ребят подскажите где что подкрутить чтобы не перегружался сервер. Вы превысили технические ограничения Вашего тарифа VPS Было превышение по LoadAverage 23 числа (Вы можете посмотреть в личном кабинете) из-за чего у Вас прерывались процессы: Jun 23 20:17:07 ovzhost57 kernel: [1622226.695214] OOM killed process mysqld (pid=811594, ve=5185805) exited, free=780109. Jun 23 20:17:07 ovzhost57 kernel: [1622226.695218] UB-5185805-Mem-Info: Jun 23 20:17:07 ovzhost57 kernel: [1622226.695281] <<< 5185805 oom generation 0 ends (task died) Jun 23 20:18:59 ovzhost57 kernel: [1622338.964027] >>> 5185805 oom generation 1 starts Jun 23 20:18:59 ovzhost57 kernel: [1622338.964035] UB-5185805-Mem-Info: Jun 23 20:18:59 ovzhost57 kernel: [1622338.967815] OOM killed process php (pid=629595, ve=5185805) exited, free=828988. Jun 23 20:18:59 ovzhost57 kernel: [1622338.967820] UB-5185805-Mem-Info: Jun 23 20:18:59 ovzhost57 kernel: [1622338.967912] <<< 5185805 oom generation 1 ends (task died) Jun 23 20:19:19 ovzhost57 kernel: [1622359.350599] >>> 5185805 oom generation 2 starts Jun 23 20:19:19 ovzhost57 kernel: [1622359.355934] OOM killed process php (pid=801099, ve=5185805) exited, free=864327. Jun 23 20:19:19 ovzhost57 kernel: [1622359.355940] <<< 5185805 oom generation 2 ends (task died) Jun 23 20:19:25 ovzhost57 kernel: [1622364.910484] >>> 5185805 oom generation 3 starts Jun 23 20:19:25 ovzhost57 kernel: [1622364.915465] OOM killed process mysqld (pid=829981, ve=5185805) exited, free=868839. Jun 23 20:19:25 ovzhost57 kernel: [1622364.915470] <<< 5185805 oom generation 3 ends (task died) Jun 23 20:19:46 ovzhost57 kernel: [1622385.972764] >>> 5185805 oom generation 4 starts Jun 23 20:19:46 ovzhost57 kernel: [1622386.083349] OOM killed process php (pid=731398, ve=5185805) exited, free=882082. Jun 23 20:19:46 ovzhost57 kernel: [1622386.083354] <<< 5185805 oom generation 4 ends (task died) Jun 23 20:20:20 ovzhost57 kernel: [1622419.918299] >>> 5185805 oom generation 5 starts Jun 23 20:20:20 ovzhost57 kernel: [1622419.928902] OOM killed process php (pid=800111, ve=5185805) exited, free=792156. Jun 23 20:20:20 ovzhost57 kernel: [1622419.928907] <<< 5185805 oom generation 5 ends (task died) Jun 23 21:00:17 ovzhost57 sshcommands shuntsov root[/root] : vzctl enter 5185805 Внутри контейнера было большое количество процессов php, что создавало нагрузку на хардноду. Для того чтобы не прерывать целиком работу контейнера в конфигурацию /etc/httpd/conf.d/fcgid.conf были внесены следующие изменения DefaultMaxClassProcessCount 24 DefaultMinClassProcessCount 0 Однако судя по логам даже такого количества процессов недостаточно для сайта [Mon Jun 24 16:25:06 2013] [warn] [client 74.112.131.243] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:10 2013] [warn] [client 74.112.131.243] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:10 2013] [warn] [client 216.46.190.180] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:10 2013] [warn] [client 74.112.131.242] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:12 2013] [warn] [client 50.18.20.243] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:15 2013] [warn] [client 74.112.131.242] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:15 2013] [warn] [client 46.236.23.248] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:20 2013] [warn] [client 74.112.131.241] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:20 2013] [warn] [client 74.112.131.245] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:20 2013] [warn] [client 74.112.131.241] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:20 2013] [warn] [client 216.46.190.187] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:22 2013] [warn] [client 184.169.245.99] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:25 2013] [warn] [client 74.112.131.245] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:25 2013] [warn] [client 74.112.131.241] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:30 2013] [warn] [client 74.112.131.243] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php [Mon Jun 24 16:25:32 2013] [warn] [client 98.137.207.87] mod_fcgid: can't apply process slot for /var/www/admin/data/php-bin/php Так же был настроен конфиг mysql, в частности параметры: tmp_table_size = 256M max_heap_table_size = 256M thread_cache_size = 24 join_buffer_size = 512K query_cache_limit = 4M Несмотря на всю проведенную оптимизацию работа ботов на сайте порождает такое количество процессов php, которое создает стабильную нагрузку на хардноду по LoadAverage свыше 65. Настоятельно рекомендуем произвести оптимизацию скриптов сайта (также установить какой либо акселератор) либо повысить тарифный план. Обращаю Ваше внимание, что в случае повторного нарушения технических ограничений Ваш контейнер будет заблокирован (согласно договору).

подскажите как правильно подключить CDN jquery? везде тока написана ссылка на гугловский или яндексовский а как правильно подключать синтаксиса нету и в каком файле если это header.tpl то вот какой у меня длинный код подключения различных библиотек <script type="text/javascript" src="catalog/view/javascript/jquery/jquery-1.7.1.min.js"></script> <script type="text/javascript" src="catalog/view/theme/bigshop/js/jquery.easing-1.3.min.js"></script> <script type="text/javascript" src="catalog/view/theme/bigshop/js/jquery.flexslider-min.js"></script> <script type="text/javascript" src="catalog/view/javascript/jquery/ui/jquery-ui-1.8.16.custom.min.js"></script> <link rel="stylesheet" type="text/css" href="catalog/view/javascript/jquery/ui/themes/ui-lightness/jquery-ui-1.8.16.custom.css" /> <script type="text/javascript" src="catalog/view/javascript/jquery/ui/external/jquery.cookie.js"></script> <script type="text/javascript" src="catalog/view/javascript/jquery/colorbox/jquery.colorbox.js"></script> <link rel="stylesheet" type="text/css" href="catalog/view/javascript/jquery/colorbox/colorbox.css" media="screen" /> <script type="text/javascript" src="catalog/view/javascript/jquery/tabs.js"></script> <script type="text/javascript" src="catalog/view/javascript/common.js"></script> <script type="text/javascript" src="catalog/view/theme/bigshop/js/custom.js"></script> <script type="text/javascript" src="catalog/view/theme/bigshop/js/cloud_zoom.js"></script>

хостеры отдельные бараны, ответ на тикет раз в 10 часов и не раньше

Ребят посмотрите в чем проблема вирус в респонс.пхп проверял нет вот логи с db_log сайт rc-tachki.ru 2013-06-23 19:51:20 - all_time: 13.63846; count_queries: 00240 / 2013-06-23 19:51:22 - all_time: 14.21238; count_queries: 00297 /14-schiny-diski-vstavki/1406-Off-Road-1-10/ 2013-06-23 19:51:31 - all_time: 6.65860; count_queries: 00245 /14-schiny-diski-vstavki/ 2013-06-23 19:51:41 - all_time: 7.83437; count_queries: 00270 /6-akkumulyatory-i-oborudovanie/604-zaryadnye-i-razryadnye-ustrojstva/kupit-zaryadnoe-ustroystvo-skyrc-t6755-220v-55w-c7a-d2a-all-type-v-magazine-rc-tachkiru.html 2013-06-23 19:51:52 - all_time: 8.70943; count_queries: 00294 /13-schesterni-dlya-elektromodelej/ 2013-06-23 19:52:02 - all_time: 10.76259; count_queries: 00213 /oplata.html 2013-06-23 19:52:02 - 0.50517 SELECT * FROM url_alias WHERE `query` IN ('category_id=11', 'category_id=1103') 2013-06-23 19:52:05 - all_time: 1.00068; count_queries: 00009 /110-buggy-rear-white-kyo-ae-tlr 2013-06-23 19:52:13 - all_time: 18.54247; count_queries: 00209 /index.php?route=product/testimonial&testimonial_id=1 2013-06-23 19:52:24 - all_time: 26.94605; count_queries: 00271 /18-tyagi-nakonechniki-scharovye/4x25-mm-adjustable-rod-2.html 2013-06-23 19:52:26 - all_time: 25.75952; count_queries: 00270 /108-hop-apy-i-tyuning/2400-kulaki-povorotnye-Vertical-Steering-Block-2scht-opcionnye.html 2013-06-23 19:52:31 - all_time: 24.60237; count_queries: 00273 /14-schiny-diski-vstavki/1406-Off-Road-1-10/110-buggy-rear-white-kyo-ae-tlr.html 2013-06-23 19:52:34 - all_time: 17.84019; count_queries: 00209 /index.php?route=product/testimonial&testimonial_id=2 2013-06-23 19:52:34 - 0.55875 SELECT * FROM url_alias WHERE `query` IN ('category_id=12', 'product_id=7491') 2013-06-23 19:52:34 - 0.58328 SELECT * FROM url_alias WHERE `query` IN ('category_id=4', 'category_id=407') 2013-06-23 19:52:49 - all_time: 21.16458; count_queries: 00270 /108-hop-apy-i-tyuning/4wd-conversion-kit-for-wheely-king-truck-2wd.html 2013-06-23 19:52:50 - all_time: 19.79840; count_queries: 00270 /12-podschipniki/7488-podschipnik-flancevyj-1-4-x-3-8--2-scht-.html 2013-06-23 19:52:51 - all_time: 15.18781; count_queries: 00243 /19-schesterni-dlya-modelej-s-dvs/ 2013-06-23 19:53:11 - all_time: 18.75446; count_queries: 00270 /20-zapasnye-chasti-dlya-avtomodelej/4mm-suspension-shaftmp777-4pcs.html 2013-06-23 19:53:16 - all_time: 21.55028; count_queries: 00266 /12-podschipniki/7489-podschipnik-1-4-x3-8--2-scht-.html 2013-06-23 19:53:18 - all_time: 23.48547; count_queries: 00294 /8-razemy-kontakty-provoda-i-prochee/ 2013-06-23 19:53:31 - all_time: 24.26347; count_queries: 00271 /1-modelj/105-baggi-turing-ralli-1-8/kupit-baggi-18-nitro-d8-atsushi-hara-edition-kit-v-magazine-rc-tachkiru.html 2013-06-23 19:53:33 - all_time: 0.76236; count_queries: 00006 /index.php?route=product/product/captcha 2013-06-23 19:53:40 - all_time: 25.17355; count_queries: 00246 /5-elektrodvigateli-regulyatory-i-prinadlezhnosti/703-sistemy-elektrodvigatel-regulyator-/ 2013-06-23 19:53:47 - all_time: 24.29332; count_queries: 00208 /110-gridiron-sc-soft-pre-mnt-

ребят глянте подсобите определить почему так долго открываются страницы. выглядит как долгий запрос потом резко выплевывает. 20 тыс товаров в магазе. rc-tachki.ру

Эпопея продолжается ругаюсь с тех поддержкой. Объясните мне как три с половиной робота твитера могут завалить ВПС с 1024 мб