Долго грузится (Запросы внутри) Прошу помощи)

[Milli]

Доброго времени суток! Мой сайт очень долго грузит(. Порядка 11 секунд. На сайте 8к товаров и не больше 50 категорий. Помогите пожалуйста
Вот список запросов при загрузки категории:

[Milli]

totalProcessTime - 5.58270597458 sec
Queries - 495.
Queries time - 4.38227677345.

1. (0.000) SELECT * FROM store WHERE REPLACE(`url`, 'www.', '') = 'http://nazikan.ru/'


2. (0.001) SELECT * FROM setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC


3. (0.000) SELECT * FROM language


4. (0.000) SELECT * FROM currency


5. (0.000) SELECT * FROM weight_class wc LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'


6. (0.000) 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'


7. (0.002) SELECT * FROM url_alias WHERE keyword = '57-zhenskij-razdel'


8. (0.006) 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


9. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


10. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


11. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


12. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=64'


13. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


14. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=65'


15. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


16. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=72'


17. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


18. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=68'


19. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


20. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=71'


21. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


22. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=70'


23. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


24. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=69'


25. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


26. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=67'


27. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


28. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=66'


29. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


30. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=61'


31. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


32. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=63'


33. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


34. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=62'


35. (0.051) 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 = '57' GROUP BY p.product_id ORDER BY p.sort_order ASC LIMIT 0,24


36. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '46681' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


37. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47021' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


38. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47056' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


39. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47089' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


40. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47122' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


41. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47155' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


42. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47191' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


43. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47224' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


44. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47258' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


45. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47291' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


46. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47331' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


47. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47673' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


48. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47716' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


49. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47748' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


50. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47780' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


51. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '47812' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


52. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '48786' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


53. (0.003) 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 = '8' 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 = '8' 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 = '8') 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 = '51310' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


54. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '51344' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


55. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '51382' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


56. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '51426' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


57. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '51465' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


58. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '51503' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


59. (0.002) 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 = '8' 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 = '8' 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 = '8') 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 = '51537' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'


60. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


61. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=46681'


62. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


63. (0.004) SELECT * FROM url_alias WHERE `query` = 'product_id=47021'


64. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


65. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=47056'


66. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


67. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=47089'


68. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


69. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=47122'


70. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


71. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=47155'


72. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


73. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=47191'


74. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


75. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=47224'


76. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


77. (0.004) SELECT * FROM url_alias WHERE `query` = 'product_id=47258'


78. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


79. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=47291'


80. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


81. (0.002) SELECT * FROM url_alias WHERE `query` = 'product_id=47331'


82. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


83. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=47673'


84. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


85. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=47716'


86. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


87. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=47748'


88. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


89. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=47780'


90. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


91. (0.004) SELECT * FROM url_alias WHERE `query` = 'product_id=47812'


92. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


93. (0.004) SELECT * FROM url_alias WHERE `query` = 'product_id=48786'


94. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


95. (0.004) SELECT * FROM url_alias WHERE `query` = 'product_id=51310'


96. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


97. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=51344'


98. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


99. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=51382'


100. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


101. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=51426'


102. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


103. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=51465'


104. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


105. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=51503'


106. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


107. (0.003) SELECT * FROM url_alias WHERE `query` = 'product_id=51537'


108. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


109. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


110. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


111. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


112. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


113. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


114. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


115. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


116. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


117. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


118. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


119. (0.207) 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 = '57'


120. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


121. (0.002) SELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'


122. (0.000) SELECT * FROM layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1


123. (0.000) SELECT * FROM extension WHERE `type` = 'module'


124. (0.071) 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 = '57'


125. (0.043) 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 = '64')


126. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


127. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=64'


128. (0.044) 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 = '65')


129. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


130. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=65'


131. (0.043) 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 = '72')


132. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


133. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=72'


134. (0.044) 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 = '68')


135. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


136. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=68'


137. (0.043) 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 = '71')


138. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


139. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=71'


140. (0.043) 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 = '70')


141. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


142. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=70'


143. (0.046) 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 = '69')


144. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


145. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=69'


146. (0.044) 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 = '67')


147. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


148. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=67'


149. (0.043) 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 = '66')


150. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


151. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=66'


152. (0.044) 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 = '61')


153. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


154. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=61'


155. (0.043) 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 = '63')


156. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


157. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=63'


158. (0.046) 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 = '62')


159. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


160. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=62'


161. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


162. (0.080) 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 = '17'


163. (0.045) 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 = '76')


164. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


165. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=76'


166. (0.043) 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 = '79')


167. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


168. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=79'


169. (0.043) 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 = '75')


170. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


171. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=75'


172. (0.042) 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 = '78')


173. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


174. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=78'


175. (0.043) 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 = '74')


176. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


177. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=74'


178. (0.042) 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 = '77')


179. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


180. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=77'


181. (0.044) 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 = '73')


182. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


183. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=73'


184. (0.043) 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 = '134')


185. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


186. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=134'


187. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


188. (0.047) 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 = '81'


189. (0.045) 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 = '85')


190. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=81'


191. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=85'


192. (0.051) 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 = '86')


193. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=81'


194. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=86'


195. (0.046) 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 = '87')


196. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=81'


197. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=87'


198. (0.045) 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 = '88')


199. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=81'


200. (0.002) SELECT * FROM url_alias WHERE `query` = 'category_id=88'

[Vladzimir]

Поставте СЕО-ПРО с кешированием от freelancer. Отключите подсчет товаров в категории.

[Milli]

 

 

Отключите подсчет товаров в категории.

Вроде у меня отключенный. На сайте не показывает сколько товаров. 

[Milli]

 

 

Поставте СЕО-ПРО с кешированием от freelancer

Вы про этот модуль? https://opencartforum.com/files/file/1155-modul-upravleniia-seopro/

[Vladzimir]

Вот это говорит что считает

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 = '67')

Не выводится и не считает, это немного разные вещи. Возможно через шаблон убрано.

 

Нет, вот этот. https://opencartforum.com/topic/10270-dubli-stranitc-seopro/

[Milli]

Установил модуль 1000 категорий и скорость сайта в два раза изменилась в хорошую сторону). 

Теперь запросов стало меньше) 

Помогите пожалуйста, как еще повысить скорость.

totalProcessTime - 6.39552998543 sec
Queries - 222.
Queries time - 6.32638382912.

1. (0.000) SELECT * FROM store WHERE REPLACE(`url`, 'www.', '') = 'http://nazikan.ru/'


2. (0.000) SELECT * FROM setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC


3. (0.000) SELECT * FROM language


4. (0.000) SELECT * FROM currency


5. (0.000) SELECT * FROM weight_class wc LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'


6. (0.000) 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'


7. (0.000) SELECT * FROM url_alias WHERE keyword = '57-zhenskij-razdel'


8. (0.000) 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


9. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


10. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


11. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


12. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=64'


13. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


14. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=65'


15. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


16. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=72'


17. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


18. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=68'


19. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


20. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=71'


21. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


22. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=70'


23. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


24. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=69'


25. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


26. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=67'


27. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


28. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=66'


29. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


30. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=61'


31. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


32. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=63'


33. (0.004) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


34. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=62'


35. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


36. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=54309'


37. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


38. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=54367'


39. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


40. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=19495'


41. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


42. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43342'


43. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


44. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43379'


45. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


46. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43421'


47. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


48. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43456'


49. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


50. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43509'


51. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


52. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43552'


53. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


54. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43606'


55. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


56. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43641'


57. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


58. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43675'


59. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


60. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43709'


61. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


62. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43745'


63. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


64. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43788'


65. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


66. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=43914'


67. (0.006) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


68. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=45159'


69. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


70. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=45208'


71. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


72. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=45296'


73. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


74. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=45495'


75. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


76. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=46021'


77. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


78. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=46062'


79. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


80. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=46106'


81. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


82. (0.000) SELECT * FROM url_alias WHERE `query` = 'product_id=46154'


83. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


84. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


85. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


86. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


87. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


88. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


89. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


90. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


91. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


92. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


93. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


94. (0.208) 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 = '57'


95. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


96. (0.000) SELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'


97. (0.000) SELECT * FROM layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1


98. (0.000) SELECT * FROM extension WHERE `type` = 'module'


99. (0.000) SELECT *, (SELECT COUNT(parent_id) FROM category WHERE parent_id = c.category_id AND status = '1' ) AS children FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '0' AND c.status = '1' AND cd.language_id = '1' ORDER BY c.sort_order, cd.name


100. (0.000) SELECT *, (SELECT COUNT(parent_id) FROM category WHERE parent_id = c.category_id AND status = '1' ) AS children FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) WHERE c.parent_id = '57' AND c.status = '1' AND cd.language_id = '1' ORDER BY c.sort_order, cd.name


101. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


102. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=64'


103. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


104. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=65'


105. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


106. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=72'


107. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


108. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=68'


109. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


110. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=71'


111. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


112. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=70'


113. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


114. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=69'


115. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


116. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=67'


117. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


118. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=66'


119. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


120. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=61'


121. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


122. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=63'


123. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


124. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=62'


125. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


126. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


127. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=81'


128. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=59'


129. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=82'


130. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=83'


131. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=84'


132. (0.000) SELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'


133. (0.000) SELECT * FROM layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1


134. (0.000) SELECT * FROM extension WHERE `type` = 'module'


135. (0.000) SELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'


136. (0.000) SELECT * FROM layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1


137. (0.000) SELECT * FROM extension WHERE `type` = 'module'


138. (0.000) SELECT * FROM category_to_layout WHERE category_id = '57' AND store_id = '0'


139. (0.000) SELECT * FROM layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route ASC LIMIT 1


140. (0.000) SELECT * FROM extension WHERE `type` = 'module'


141. (0.000) SELECT * FROM information i LEFT JOIN information_description id ON (i.information_id = id.information_id) LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' AND i.sort_order <> '-1' ORDER BY i.sort_order, LCASE(id.title) ASC


142. (0.000) SELECT * FROM url_alias WHERE `query` = 'information_id=10'


143. (0.000) SELECT * FROM url_alias WHERE `query` = 'information_id=9'


144. (0.000) SELECT * FROM url_alias WHERE `query` = 'information_id=4'


145. (0.000) SELECT * FROM url_alias WHERE `query` = 'information_id=6'


146. (0.000) SELECT * FROM extension WHERE `type` = 'total'


147. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


148. (0.191) 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 = '64')


149. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


150. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=64'


151. (0.184) 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 = '65')


152. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


153. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=65'


154. (0.207) 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 = '72')


155. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


156. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=72'


157. (0.188) 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 = '68')


158. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


159. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=68'


160. (0.227) 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 = '71')


161. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


162. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=71'


163. (0.204) 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 = '70')


164. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


165. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=70'


166. (0.214) 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 = '69')


167. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


168. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=69'


169. (0.558) 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 = '67')


170. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


171. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=67'


172. (0.412) 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 = '66')


173. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


174. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=66'


175. (0.233) 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 = '61')


176. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


177. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=61'


178. (0.185) 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 = '63')


179. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


180. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=63'


181. (0.181) 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 = '62')


182. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


183. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=62'


184. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=57'


185. (0.173) 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 = '76')


186. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


187. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=76'


188. (0.192) 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 = '79')


189. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


190. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=79'


191. (0.190) 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 = '75')


192. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


193. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=75'


194. (0.160) 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 = '78')


195. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


196. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=78'


197. (0.167) 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 = '74')


198. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


199. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=74'


200. (0.216) 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 = '77')


201. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


202. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=77'


203. (0.213) 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 = '73')


204. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


205. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=73'


206. (0.213) 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 = '134')


207. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


208. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=134'


209. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=17'


210. (0.437) 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 = '85')


211. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=81'


212. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=85'


213. (0.380) 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 = '86')


214. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=81'


215. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=86'


216. (0.329) 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 = '87')


217. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=81'


218. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=87'


219. (0.441) 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 = '88')


220. (0.001) SELECT * FROM url_alias WHERE `query` = 'category_id=81'


221. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=88'


222. (0.000) SELECT * FROM url_alias WHERE `query` = 'category_id=81'

[Milli]

 

Вот это говорит что считает

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 = '67')

Не выводится и не считает, это немного разные вещи. Возможно через шаблон убрано.

Я в инете и в поиске ничего не нашел как убрать(. Помогите пожалуйста

[Milli]

Мне тут написали, что можно исправиться от всего этого купив vps хостинг с мэмкеш

[Vladzimir]

А вы знаете что потом с этим мемкешем делать?

Объясните мне каким образом установленный мемкеш (без правки кода) поможет в проблеме с большим количеством запросов?

[Milli]

А еще код нужно менять?( Может посоветуете vps? Или же поможете с этим ?) 

[Vladzimir]

Ну а как вы думали, опенкарт по умолчанию не умеет работать с другими системами кеширования. У вас уже есть ВПС?

[Milli]

Нету. Вот ищу ) Посоветуйте хороший. И что легче? Установить на vps мэмкеш или здесь все подправить? версия опенкарта кстати 1.5.1.3.

[Vladzimir]

Я бы ставил и ВПС с мемкешем и подправить то о чем я говорил. ВПС можно взять здесь http://freehost.com.ua/

[Milli]

Спасибо

[Milli]

Этого хватит для  8к товаров? 

Процессор: 750 Mhz
RAM: 750 Mb
HDD: 10000 Мб

[Vladzimir]

Самый дешевый пакет идет без панели. Берите пакет "Универсальный"

[RGB]

Да и не нужен вам никакой впс - 8к товаров и 50 категорий это далеко не те условия, когда есть необходимость в этом. И поддержку мемкеша предоставляют не только на впс, но и на обычном виртуальном хостинге - как пример, упомянутый в шапке сообщества domenam.ru

[Milli]

Ребят! Я переехал на vps хостинг adminvps.ru там мне перенесли сайт со старого хостинга и установили мэмкеш. Подскажите пожалуйста, как подключить мэмкеш к опенкарту? 

[Vladzimir]

Кеш на мемкеше для опенкарта https://github.com/shaman/opencart-memcached

[Milli]

Подключил, и ничего не работает походу(. Как было так и осталось(. Сайт на домене http://1millionex.ru/57-zhenskij-razdel?cat=1&stat=sql посмотрите в конце запросы. 

И после переноса какие-то ошибки, посмотрите пожалуйста) 

[Milli]

Вроде заработало. После переезда на другой хостинг, появились ошибки в категориях в конце сайта. 

В чем может быть проблема? Помогите пожалуйста) 

 

Warning: file_put_contents(/home/a/aisur1/nazikan.ru/public_html/vqmod/logs/Tue.log): failed to open stream: No such file or directory in /var/www/aisur1/data/www/1millionex.ru/vqmod/vqmod.php on line 415 Warning: fopen(/var/www/aisur1/data/www/1millionex.ru/system/logs/error.txt): failed to open stream: Permission denied in /var/www/aisur1/data/www/1millionex.ru/system/library/log.php on line 12 Warning: fwrite() expects parameter 1 to be resource, boolean given in /var/www/aisur1/data/www/1millionex.ru/system/library/log.php on line 14 Warning: fclose() expects parameter 1 to be resource, boolean given in /var/www/aisur1/data/www/1millionex.ru/system/library/log.php on line 16 LOG FILE COULD NOT BE WRITTEN

 

Спасибо

[Vladzimir]

Права на папки выставьте правильные.

[Milli]

Выставил. Осталась ошибка: 

Warning: file_put_contents(/home/a/aisur1/nazikan.ru/public_html/vqmod/logs/Tue.log): failed to open stream: No such file or directory in /var/www/aisur1/data/www/1millionex.ru/vqmod/vqmod.php on line 415LOG FILE COULD NOT BE WRITTEN

[Milli]

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

Сайт на этом домене nazikan.ru/57-zhenskij-razdel

Или сайт на этом домене 1millionex.ru/57-zhenskij-razdel

Спасибо