Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/engine/action.php on line 61Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/engine/action.php on line 88Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/engine/action.php on line 61Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/engine/action.php on line 88Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/engine/action.php on line 61Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/engine/action.php on line 88Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Warning: Cannot modify header information - headers already sent by (output started at /var/www/www-root/data/www/atlantcabel.ru/system/framework.php:42) in /var/www/www-root/data/www/atlantcabel_storage/modification/catalog/controller/startup/startup.php on line 108Warning: Cannot modify header information - headers already sent by (output started at /var/www/www-root/data/www/atlantcabel.ru/system/framework.php:42) in /var/www/www-root/data/www/atlantcabel_storage/modification/catalog/controller/startup/startup.php on line 168Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 24Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/library/db/mysqli.php on line 32Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/engine/action.php on line 61Notice: Undefined index: OCSESSID in /var/www/www-root/data/www/atlantcabel_storage/modification/system/engine/action.php on line 88 Купить структурированные кабельные системы в интернет-магазине АтлантPRO24
Debug SQL and Controllers
0.4185581207SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, coalesce((SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1), (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1), p.price) as realprice, p.quantity FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '55' GROUP BY p.product_id HAVING realprice >=-0.5 ORDER BY (p.quantity>0) DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 6240,15
0.3062009811UPDATE oc_product SET image ='' WHERE image IS NULL
0.0048911572SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
0.0027809143SELECT value FROM oc_setting WHERE store_id = '0' AND `key`='asc_jetcache_settings'
0.0016000271SELECT * FROM oc_currency
0.0015840530SET time_zone = '+00:00'
0.0015578270SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://atlantpro24.ru/'
0.0015048981SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543414' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0014162064SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
0.0011339188SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'
0.0011219978DELETE FROM `oc_session` WHERE `expire` < '2025-08-04 08:07:17'
0.0011131763SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543415' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0010991096SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'advertise_google'
0.0010311604SELECT count(*) as c FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='atlantcabel' AND TABLE_NAME='oc_category' AND COLUMN_NAME='noindex'
0.0009660721DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
0.0009491444SHOW TABLES LIKE 'oc_ocfilter_setting'
0.0009200573SELECT * FROM oc_setting WHERE store_id = '0' AND `code` = 'theme_prostoremeslinks'
0.0008828640SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543414' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0008738041SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '46') ORDER BY tr1.priority ASC
0.0008640289SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543421' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0008587837SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543427' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0008211136SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543420' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0008101463SELECT * FROM oc_product_image WHERE product_id = '543414' ORDER BY sort_order ASC
0.0008099079SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543425' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0007851124SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
0.0007841587SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543426' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0007691383SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543425' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0007610321SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_wishlist'
0.0007598400SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543416' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0007541180SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543422' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0007481575SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543428' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0007469654SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543415' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0007431507SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543421' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0007338524SELECT * FROM oc_cart WHERE customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0007290840SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543419' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0007259846SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543416' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0007219315SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543420' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0007219315SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543426' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0007200241SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543424' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0007162094SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543419' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0007090569SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543418' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0007071495SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543417' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0007069111SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543427' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0007038116SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543418' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0007011890SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543422' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0006849766SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543423' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0006830692SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543428' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0006821156SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_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 oc_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 oc_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 oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '543424' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0006759167SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543417' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0006389618SELECT a.attribute_id, ad.name, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '543423' AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0005970001SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '4' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
0.0005819798SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
0.0005331039SELECT * FROM oc_category_to_layout WHERE category_id = '55' AND store_id = '0'
0.0005240440SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.0005130768SELECT `data` FROM `oc_session` WHERE `session_id` = '3b8f3053e5b2289d4a3468b718' AND `expire` > '2025-08-04 08:07:17'
0.0004968643SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543414' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0004889965SELECT category_id, image, parent_id FROM oc_category WHERE image=''
0.0004870892SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '46') ORDER BY tr1.priority ASC
0.0004868507SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '55' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
0.0004789829SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
0.0004780293SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0004727840SELECT * FROM oc_ocfilter_setting
0.0004711151DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 60 MINUTE)
0.0004670620SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543419' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0004551411SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0004549026SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
0.0004470348UPDATE oc_category SET image ='' WHERE image IS NULL
0.0004379749SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543425' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0004301071SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_compare'
0.0004248619SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
0.0004208088SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0004189014SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.0004138947SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543416' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0004110336SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'extension/module/callback'
0.0004041195SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0004029274SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543414' ORDER BY cp.level DESC, ptc.category_id ASC
0.0004010201SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '14' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
0.0004010201SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543415' ORDER BY cp.level DESC, ptc.category_id ASC
0.0003981590SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543422' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0003910065SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003888607SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
0.0003881454SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/category'
0.0003879070SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543426' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0003869534SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_left'
0.0003840923SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543415' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0003840923SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003740788SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543418' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0003709793SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '9' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
0.0003709793SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/currency'
0.0003678799SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543420' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0003659725SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_5'
0.0003650188SELECT DISTINCT * FROM oc_information i LEFT JOIN oc_information_description id ON (i.information_id = id.information_id) LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE i.information_id = '7' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
0.0003621578SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003590584SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543421' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0003571510SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/language'
0.0003559589SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003559589SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543417' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0003550053SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543424' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0003550053SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003530979SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543421' ORDER BY cp.level DESC, ptc.category_id ASC
0.0003530979SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003519058SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543428' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0003511906SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003509521SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003509521SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003509521SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003490448SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003471375SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003468990SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003459454SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0003449917SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003399849SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003390312SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0003359318SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003349781SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543423' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0003349781SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
0.0003349781SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003337860SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003330708SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003330708SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003328323SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '543427' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0003318787SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543420' ORDER BY cp.level DESC, ptc.category_id ASC
0.0003309250SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003299713SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003299713SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
0.0003290176SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003290176SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003280640SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003271103SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003268719SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003259182SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003259182SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543427' ORDER BY cp.level DESC, ptc.category_id ASC
0.0003259182SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003259182SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/category_grid'
0.0003240108SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003240108SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003240108SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003228188SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003221035SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003209114SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003209114SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0003201962SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003190041SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543423' ORDER BY cp.level DESC, ptc.category_id ASC
0.0003190041SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003190041SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003190041SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003180504SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003180504SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003178120SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003168583SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543418' ORDER BY cp.level DESC, ptc.category_id ASC
0.0003168583SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003161430SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0003149509SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003149509SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_nav_cust'
0.0003130436SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0003108978SELECT * FROM oc_ocfilter_setting WHERE `key` = 'placement_layout'
0.0003108978SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003108978SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0003099442SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header_nav_v_drop'
0.0003099442SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543417' ORDER BY cp.level DESC, ptc.category_id ASC
0.0003089905SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003089905SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003080368SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0003070831SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003070831SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003068447SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543426' ORDER BY cp.level DESC, ptc.category_id ASC
0.0003068447SET SQL_BIG_SELECTS = 1
0.0003068447SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
0.0003058910SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003049374SELECT * FROM oc_product_image WHERE product_id = '543415' ORDER BY sort_order ASC
0.0003049374SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003049374SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003049374SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003049374SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003049374SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003049374SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003039837SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003039837SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_top'
0.0003030300SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003030300SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003030300SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543425' ORDER BY cp.level DESC, ptc.category_id ASC
0.0003020763SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003018379SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003018379SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/cart'
0.0003011227SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/header'
0.0003011227SELECT * FROM oc_category_to_layout WHERE category_id = '55' AND store_id = '0'
0.0003008842SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003001690SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0003001690SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
0.0002992153SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002989769SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002989769SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002989769SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/search'
0.0002989769SELECT * FROM oc_layout_module WHERE layout_id = '3' AND `code` = 'ocfilter'
0.0002989769SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002980232SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002980232SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002980232SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
0.0002961159SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
0.0002958775SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002958775SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002958775SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002958775SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002958775SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002951622SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002949238SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002949238SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002949238SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543424' ORDER BY cp.level DESC, ptc.category_id ASC
0.0002930164SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002920628SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002918243SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002911091SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002911091SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002908707SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002901554SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002901554SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543428' ORDER BY cp.level DESC, ptc.category_id ASC
0.0002901554SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
0.0002901554SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002899170SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form'
0.0002899170SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002899170SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002892017SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543416' ORDER BY cp.level DESC, ptc.category_id ASC
0.0002889633SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002889633SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002880096SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
0.0002880096SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002870560SELECT * FROM oc_product_image WHERE product_id = '543420' ORDER BY sort_order ASC
0.0002870560SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/column_right'
0.0002858639SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002858639SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002858639SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002858639SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002849102SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002849102SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002841949SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002839565SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002839565SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002830029SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002820492SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002820492SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002820492SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'ru-ru')
0.0002820492SELECT * FROM oc_product_image WHERE product_id = '543424' ORDER BY sort_order ASC
0.0002818108SELECT * FROM oc_product_image WHERE product_id = '543427' ORDER BY sort_order ASC
0.0002818108SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002799034SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002799034SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002789497SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002789497SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002779961SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002779961SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543419' ORDER BY cp.level DESC, ptc.category_id ASC
0.0002770424SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002770424SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002770424SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002760887SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002760887SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002751350SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002751350SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0002748966SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002748966SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002748966SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002739429SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002729893SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002729893SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002729893SELECT * FROM oc_product_image WHERE product_id = '543428' ORDER BY sort_order ASC
0.0002729893SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002720356SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002720356SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
0.0002717972SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002710819SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002710819SELECT * FROM oc_product_image WHERE product_id = '543421' ORDER BY sort_order ASC
0.0002710819SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002701283SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002698898SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002698898SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level FROM `oc_product_to_category` ptc INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id WHERE product_id = '543422' ORDER BY cp.level DESC, ptc.category_id ASC
0.0002691746SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002682209SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002679825SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002679825SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002679825SELECT * FROM oc_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0002679825SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002679825SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002679825SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002670288SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002670288SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002670288SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002670288SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002670288SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002670288SELECT * FROM oc_product_image WHERE product_id = '543423' ORDER BY sort_order ASC
0.0002651215SELECT * FROM oc_category_to_layout WHERE category_id = '55' AND store_id = '0'
0.0002651215SELECT * FROM oc_extension WHERE `type` = 'total'
0.0002648830SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002648830SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002648830SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002641678SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002639294SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002639294SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002629757SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002620220SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002620220SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002620220SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002620220SELECT * FROM oc_product_image WHERE product_id = '543426' ORDER BY sort_order ASC
0.0002620220SELECT * FROM oc_extension WHERE `type` = 'analytics'
0.0002610683SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002610683SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru')
0.0002608299SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002601147SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002591610SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002589226SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002589226SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002582073SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543414'
0.0002579689SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002579689SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002570152SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002570152SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002570152SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002570152SELECT category_id, image, parent_id FROM oc_category WHERE image=''
0.0002567768SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002560616SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002560616SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002558231SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'product/buyclick_form'
0.0002548695SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002548695SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002539158SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002539158SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002529621SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002520084SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002520084SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'
0.0002520084SELECT * FROM oc_product_image WHERE product_id = '543422' ORDER BY sort_order ASC
0.0002520084SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002520084SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002520084SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002510548SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002510548SELECT * FROM oc_category_to_layout WHERE category_id = '55' AND store_id = '0'
0.0002508163SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
0.0002501011SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002501011SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002498627SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002491474SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002481937SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002479553SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002479553SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002479553SELECT * FROM oc_product_image WHERE product_id = '543419' ORDER BY sort_order ASC
0.0002470016SELECT * FROM oc_product_image WHERE product_id = '543425' ORDER BY sort_order ASC
0.0002470016SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002470016SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002470016SELECT * FROM oc_product_image WHERE product_id = '543417' ORDER BY sort_order ASC
0.0002460480SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002460480SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543420'
0.0002450943SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002450943SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002441406SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
0.0002439022SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/prostore' OR route = 'ru-ru')
0.0002439022SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002439022SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002419949SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002419949SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002419949SELECT * FROM oc_product_image WHERE product_id = '543418' ORDER BY sort_order ASC
0.0002410412SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543425'
0.0002410412SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543427'
0.0002410412SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002400875SELECT * FROM oc_product_image WHERE product_id = '543416' ORDER BY sort_order ASC
0.0002400875SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002400875SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002398491SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002391338SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543418'
0.0002391338SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002381802SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002379417SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
0.0002379417SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002369881SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543423'
0.0002360344SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002348423SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543428'
0.0002341270SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002338886SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '3b8f3053e5b2289d4a3468b718'
0.0002338886SELECT * FROM oc_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
0.0002338886SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002338886SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002329350SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002319813SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002310276SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002300739SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002298355SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002288818SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543416'
0.0002288818SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002288818SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '55' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002288818SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543421'
0.0002279282SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543424'
0.0002279282SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002269745SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '56' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002269745SELECT *, qty as quantity FROM oc_category_discount cd WHERE category_id = '38' AND status = '1' AND customer_group_id = '1' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
0.0002250671SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543417'
0.0002250671SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/prostoresets' OR route = 'ru-ru')
0.0002250671SELECT * FROM oc_category_to_layout WHERE category_id = '55' AND store_id = '0'
0.0002229214SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543415'
0.0002219677SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002210140SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002179146SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'prostore' AND route = 'common/content_bottom'
0.0002169609SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002110004SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543422'
0.0002088547SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543419'
0.0002059937SELECT * FROM oc_category_discount WHERE category_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1' AND customer_group_id = '1';
0.0002059937SELECT COUNT(*) AS total FROM oc_customer_wishlist WHERE product_id = '543426'
0.0002000332SET time_zone = '+00:00'

event

0.0210669038event/language (43 action)
0.0201678277event/theme (19 action)
0.0174822808event/translation (19 action)

startup

2.5763120651startup/router (1 action)
0.0316281319startup/startup (1 action)
0.0099809170startup/event (1 action)
0.0015220642startup/session (1 action)
0.0005249977startup/maintenance (1 action)
0.0005230904startup/error (1 action)
0.0004901886startup/seo_url (1 action)

extension

0.0074348447extension/module/ocfilter (19 action)
0.0065841675extension/module/callback (1 action)
0.0042700767extension/advertise/google (2 action)
0.0003659725extension/analytics/yandex_metrika (1 action)

common

0.4931499958common/header (1 action)
0.0285799503common/cart (1 action)
0.0071640015common/column_left (1 action)
0.0070419312common/language (1 action)
0.0067479610common/currency (1 action)
0.0060110092common/content_top (1 action)
0.0056588650common/search (1 action)
0.0053310394common/column_right (1 action)
0.0052800179common/content_bottom (1 action)

product

2.5741739273product/category (1 action)