Ребят расшифруйте слова тех поддержки

[tyber]

Итак борюсь с темой двое суток. Я запихиваю страницы в индекс яндекса с помощью масствитинга програмулиной, которая раз в 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.
Настоятельно рекомендуем произвести оптимизацию скриптов сайта (также установить какой либо акселератор) либо повысить тарифный план.

Обращаю Ваше внимание, что в случае повторного нарушения технических ограничений Ваш контейнер будет заблокирован (согласно договору).

[alware]

каталог admin переименуй в чтонибудь типа admin456retugvjhvx45654545

и конфиги поправь соотвественно

[tyber]

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

и я так понимаю это для безопасности?

[alware]

Это не только для безопасности

 

еще и всякая дрянь ломится в админку постоянно не будет. (что видимо и происходит в инфе в первом посте)

 

пути просто меняеш в config.php в корне и в папке admin меняеш admin на то во что ты его переименовал

[tyber]

поменял не помогло опять заваливает

Есть еще идеи?

[alware]

покажи твиты

[tyber]

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

[tyber]

вот что в логе творится

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

[tyber]

вот может поможет это 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