Электротехническая производственная компания 380.com.ua

Украина, 02094, г. Киев, ул. Магнитогорская, 1А

(044) 502 88 00, (068) 355-5247, (098) 593-1420, (095) 241-5892, (093) 388-1514

sales@380.com.ua

Все контакты и график работы

Карта проезда

Подпишитесь на нашу email-рассылку и получайте скидки и специальные предложения на Ваш email-адрес!

Для наших подписчиков в социальных сетях действуют отдельные акции и специальные предложения

©

GET

array(1) {
  ["_route_"]=>
  string(36) "vse-dlya-montazha-kabelya/instrument"
}

POST

array(0) {
}

COOKIE

array(0) {
}

SERVER

array(44) {
  ["PHPRC"]=>
  string(22) "/usr/local/lib/php.ini"
  ["PATH"]=>
  string(224) "/usr/local/cpanel/3rdparty/lib/path-bin:/usr/local/jdk/bin:/usr/local/cpanel/3rdparty/lib/path-bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/opt/cpanel/composer/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin"
  ["PWD"]=>
  string(25) "/usr/local/cpanel/cgi-sys"
  ["SHLVL"]=>
  string(1) "0"
  ["FCGI_ROLE"]=>
  string(9) "RESPONDER"
  ["REDIRECT_UNIQUE_ID"]=>
  string(24) "W8y2YsIcVBsANeAgb0AAAAAH"
  ["REDIRECT_SCRIPT_URL"]=>
  string(37) "/vse-dlya-montazha-kabelya/instrument"
  ["REDIRECT_SCRIPT_URI"]=>
  string(55) "https://380.com.ua/vse-dlya-montazha-kabelya/instrument"
  ["REDIRECT_HTTPS"]=>
  string(2) "on"
  ["REDIRECT_STATUS"]=>
  string(3) "200"
  ["UNIQUE_ID"]=>
  string(24) "W8y2YsIcVBsANeAgb0AAAAAH"
  ["SCRIPT_URL"]=>
  string(37) "/vse-dlya-montazha-kabelya/instrument"
  ["SCRIPT_URI"]=>
  string(55) "https://380.com.ua/vse-dlya-montazha-kabelya/instrument"
  ["HTTPS"]=>
  string(2) "on"
  ["HTTP_HOST"]=>
  string(10) "380.com.ua"
  ["HTTP_X_REAL_IP"]=>
  string(12) "54.145.83.79"
  ["HTTP_X_FORWARDED_FOR"]=>
  string(12) "54.145.83.79"
  ["HTTP_X_FORWARDED_PROTO"]=>
  string(5) "https"
  ["HTTP_CONNECTION"]=>
  string(5) "close"
  ["HTTP_USER_AGENT"]=>
  string(40) "CCBot/2.0 (https://commoncrawl.org/faq/)"
  ["HTTP_ACCEPT"]=>
  string(63) "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8"
  ["HTTP_IF_MODIFIED_SINCE"]=>
  string(29) "Fri, 17 Aug 2018 08:47:56 MSK"
  ["HTTP_ACCEPT_ENCODING"]=>
  string(4) "gzip"
  ["HTTP_X_HTTPS"]=>
  string(1) "1"
  ["SERVER_SIGNATURE"]=>
  string(0) ""
  ["SERVER_SOFTWARE"]=>
  string(6) "Apache"
  ["SERVER_NAME"]=>
  string(10) "380.com.ua"
  ["SERVER_ADDR"]=>
  string(12) "194.28.84.27"
  ["SERVER_PORT"]=>
  string(3) "443"
  ["REMOTE_ADDR"]=>
  string(12) "54.145.83.79"
  ["DOCUMENT_ROOT"]=>
  string(26) "/home/ttncomua/public_html"
  ["SERVER_ADMIN"]=>
  string(20) "webmaster@380.com.ua"
  ["SCRIPT_FILENAME"]=>
  string(36) "/home/ttncomua/public_html/index.php"
  ["REMOTE_PORT"]=>
  string(5) "16948"
  ["REDIRECT_QUERY_STRING"]=>
  string(44) "_route_=vse-dlya-montazha-kabelya/instrument"
  ["REDIRECT_URL"]=>
  string(37) "/vse-dlya-montazha-kabelya/instrument"
  ["GATEWAY_INTERFACE"]=>
  string(7) "CGI/1.1"
  ["SERVER_PROTOCOL"]=>
  string(8) "HTTP/1.1"
  ["REQUEST_METHOD"]=>
  string(3) "GET"
  ["QUERY_STRING"]=>
  string(44) "_route_=vse-dlya-montazha-kabelya/instrument"
  ["REQUEST_URI"]=>
  string(37) "/vse-dlya-montazha-kabelya/instrument"
  ["SCRIPT_NAME"]=>
  string(10) "/index.php"
  ["PHP_SELF"]=>
  string(10) "/index.php"
  ["REQUEST_TIME"]=>
  string(10) "1540142690"
}

SESSION

array(6) {
  ["language"]=>
  string(2) "ru"
  ["currency"]=>
  string(3) "UAH"
  ["cart"]=>
  array(0) {
  }
  ["category_id"]=>
  int(70)
  ["token"]=>
  string(0) ""
  ["compare"]=>
  array(0) {
  }
}

FILES

array(0) {
}

REQUEST

array(1) {
  ["_route_"]=>
  string(36) "vse-dlya-montazha-kabelya/instrument"
}

#	File
1	/home/ttncomua/public_html/index.php
2	/home/ttncomua/public_html/config.php
3	/home/ttncomua/public_html/system/startup.php
4	/home/ttncomua/public_html/system/helper/json.php
5	/home/ttncomua/public_html/system/helper/utf8.php
6	/home/ttncomua/public_html/system/engine/action.php
7	/home/ttncomua/public_html/system/engine/controller.php
8	/home/ttncomua/public_html/system/engine/front.php
9	/home/ttncomua/public_html/system/engine/loader.php
10	/home/ttncomua/public_html/system/engine/model.php
11	/home/ttncomua/public_html/system/engine/registry.php
12	/home/ttncomua/public_html/system/library/cache.php
13	/home/ttncomua/public_html/system/library/url.php
14	/home/ttncomua/public_html/system/library/config.php
15	/home/ttncomua/public_html/system/library/db.php
16	/home/ttncomua/public_html/system/library/document.php
17	/home/ttncomua/public_html/system/library/encryption.php
18	/home/ttncomua/public_html/system/library/image.php
19	/home/ttncomua/public_html/system/library/language.php
20	/home/ttncomua/public_html/system/library/log.php
21	/home/ttncomua/public_html/system/library/mail.php
22	/home/ttncomua/public_html/system/library/pagination.php
23	/home/ttncomua/public_html/system/library/request.php
24	/home/ttncomua/public_html/system/library/response.php
25	/home/ttncomua/public_html/system/library/session.php
26	/home/ttncomua/public_html/system/library/template.php
27	/home/ttncomua/public_html/system/library/customer.php
28	/home/ttncomua/public_html/system/library/affiliate.php
29	/home/ttncomua/public_html/system/library/currency.php
30	/home/ttncomua/public_html/system/library/tax.php
31	/home/ttncomua/public_html/system/library/weight.php
32	/home/ttncomua/public_html/system/library/length.php
33	/home/ttncomua/public_html/system/library/cart.php
34	/home/ttncomua/public_html/system/database/mysql.php
35	/home/ttncomua/public_html/catalog/language/russian/russian.php
36	/home/ttncomua/public_html/catalog/controller/common/seo_url.php
37	/home/ttncomua/public_html/catalog/controller/product/category.php
38	/home/ttncomua/public_html/catalog/language/russian/product/category.php
39	/home/ttncomua/public_html/catalog/language/russian/module/order_one_click_product.php
40	/home/ttncomua/public_html/catalog/model/catalog/category.php
41	/home/ttncomua/public_html/catalog/model/catalog/product.php
42	/home/ttncomua/public_html/catalog/model/tool/image.php
43	/home/ttncomua/public_html/catalog/controller/common/column_left.php
44	/home/ttncomua/public_html/catalog/model/design/layout.php
45	/home/ttncomua/public_html/catalog/model/catalog/information.php
46	/home/ttncomua/public_html/catalog/model/setting/extension.php
47	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/column_left.tpl
48	/home/ttncomua/public_html/catalog/controller/common/column_right.php
49	/home/ttncomua/public_html/catalog/controller/module/compare.php
50	/home/ttncomua/public_html/catalog/language/russian/module/compare.php
51	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/compare.tpl
52	/home/ttncomua/public_html/catalog/controller/module/priceslider.php
53	/home/ttncomua/public_html/catalog/language/russian/module/priceslider.php
54	/home/ttncomua/public_html/catalog/model/catalog/manufacturer.php
55	/home/ttncomua/public_html/catalog/controller/module/language.php
56	/home/ttncomua/public_html/catalog/language/russian/module/language.php
57	/home/ttncomua/public_html/catalog/model/localisation/language.php
58	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/language.tpl
59	/home/ttncomua/public_html/catalog/controller/module/currency.php
60	/home/ttncomua/public_html/catalog/language/russian/module/currency.php
61	/home/ttncomua/public_html/catalog/model/localisation/currency.php
62	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/currency.tpl
63	/home/ttncomua/public_html/catalog/controller/module/cart.php
64	/home/ttncomua/public_html/catalog/language/russian/module/cart.php
65	/home/ttncomua/public_html/catalog/model/total/sub_total.php
66	/home/ttncomua/public_html/catalog/language/russian/total/sub_total.php
67	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/cart.tpl
68	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/priceslider.tpl
69	/home/ttncomua/public_html/catalog/controller/module/filter.php
70	/home/ttncomua/public_html/catalog/language/russian/module/filter.php
71	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/filter.tpl
72	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/column_right.tpl
73	/home/ttncomua/public_html/catalog/controller/common/content_top.php
74	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/content_top.tpl
75	/home/ttncomua/public_html/catalog/controller/common/content_bottom.php
76	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/content_bottom.tpl
77	/home/ttncomua/public_html/catalog/controller/common/footer.php
78	/home/ttncomua/public_html/catalog/controller/module/popupcart_extended.php
79	/home/ttncomua/public_html/catalog/language/russian/module/popupcart_extended.php
80	/home/ttncomua/public_html/catalog/view/theme/default/template/module/popupcart_extended.tpl
81	/home/ttncomua/public_html/catalog/language/russian/common/footer.php
82	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/footer.tpl
83	/home/ttncomua/public_html/catalog/controller/common/header.php
84	/home/ttncomua/public_html/catalog/language/russian/common/header.php
85	/home/ttncomua/public_html/catalog/model/setting/store.php
86	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/header.tpl
87	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/product/category.tpl
88	/home/ttncomua/public_html/system/helper/fa_debuger.php

#	Time	Query	File	Function
1	0.00016	SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://380.com.ua/'	/home/ttncomua/public_html/index.php	Array
2	0.0012	SELECT * FROM oc_setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC	/home/ttncomua/public_html/index.php	Array
3	0.00015	SELECT * FROM `oc_language` WHERE status = '1'	/home/ttncomua/public_html/index.php	Array
4	0.00014	SELECT * FROM oc_currency	/home/ttncomua/public_html/system/library/currency.php	__construct
5	0.00018	SELECT * 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 = '2'	/home/ttncomua/public_html/system/library/weight.php	__construct
6	0.00013	SELECT * 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 = '2'	/home/ttncomua/public_html/system/library/length.php	__construct
7	0.0013	SELECT SUBSTRING_INDEX(query,'=',1) AS name, CONVERT(SUBSTRING_INDEX(query,'=',-1),UNSIGNED INTEGER) AS value FROM oc_url_alias WHERE keyword IN('vse-dlya-montazha-kabelya','instrument') ORDER BY FIND_IN_SET(keyword, 'vse-dlya-montazha-kabelya,instrument')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	index
8	0.00058	SELECT 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 = '6' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategory
9	0.00018	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
10	0.00048	SELECT 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 = '70' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategory
11	0.00021	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
12	0.00014	SELECT * 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.parent_id = '70' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order DESC, LCASE(cd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategories
13	0.00037	SELECT filter_id FROM oc_category_filter WHERE category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
14	0.00166	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (847,848,850,851,852,853,854,856,858,860,862,864,868,1210,1211,1212,1213,1214,1215,1216,1217,1218,1377,1378,1379,1380,1381,1441,1442,1443,1444,1445,1446,1447,1448) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
15	0.0026	SELECT DISTINCT f.filter_id, fd.name, fd.img FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (847,848,850,851,852,853,854,856,858,860,862,864,868,1210,1211,1212,1213,1214,1215,1216,1217,1218,1377,1378,1379,1380,1381,1441,1442,1443,1444,1445,1446,1447,1448) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
16	0.00395	SELECT DISTINCT f.filter_id, fd.name, fd.img FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (847,848,850,851,852,853,854,856,858,860,862,864,868,1210,1211,1212,1213,1214,1215,1216,1217,1218,1377,1378,1379,1380,1381,1441,1442,1443,1444,1445,1446,1447,1448) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
17	0.00348	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c 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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts
18	0.01161	SELECT 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 FROM oc_product_to_category p2c 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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '70' GROUP BY p.product_id ORDER BY (p.image !='') DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,40	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProducts
19	0.00234	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14747' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
20	0.00191	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14748' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
21	0.0019	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14753' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
22	0.00189	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14754' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
23	0.00184	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14751' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
24	0.00181	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14752' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
25	0.0018	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14758' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
26	0.00179	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14771' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
27	0.00177	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14772' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
28	0.00175	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14773' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
29	0.00189	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14774' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
30	0.00198	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14745' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
31	0.00183	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14746' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
32	0.00185	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14749' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
33	0.00189	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14750' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
34	0.00198	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14759' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
35	0.00194	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14760' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
36	0.00196	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14761' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
37	0.00196	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14762' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
38	0.00195	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14763' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
39	0.0019	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14764' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
40	0.0019	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14765' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
41	0.00188	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14766' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
42	0.00195	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14767' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
43	0.00191	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14768' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
44	0.00183	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14769' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
45	0.00185	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14770' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
46	0.00184	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14786' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
47	0.00188	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14787' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
48	0.00193	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14775' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
49	0.0019	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14776' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
50	0.00186	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14777' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
51	0.00188	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14778' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
52	0.00235	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14779' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
53	0.002	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14780' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
54	0.00231	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14781' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
55	0.0019	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14782' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
56	0.00183	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14783' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
57	0.00195	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14784' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
58	0.00196	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_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 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 = '2') 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 = '2') 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 = '2') 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 = '14785' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
59	0.00086	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14747' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
60	0.00042	SELECT filter_id FROM oc_product_filter WHERE product_id = '14747'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
61	0.00164	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
62	0.00074	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
63	0.0007	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
64	0.00058	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14747')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
65	0.00101	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14748' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
66	0.00055	SELECT filter_id FROM oc_product_filter WHERE product_id = '14748'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
67	0.00022	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
68	0.00013	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
69	0.00013	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
70	0.00058	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14748')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
71	0.00038	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14753' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
72	0.00045	SELECT filter_id FROM oc_product_filter WHERE product_id = '14753'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
73	0.00015	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
74	0.00013	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
75	0.00013	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
76	0.00053	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14753')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
77	0.00048	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14754' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
78	0.00044	SELECT filter_id FROM oc_product_filter WHERE product_id = '14754'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
79	0.00021	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
80	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
81	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
82	0.00057	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14754')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
83	0.00057	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14751' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
84	0.00042	SELECT filter_id FROM oc_product_filter WHERE product_id = '14751'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
85	0.00028	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
86	0.00017	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
87	0.00017	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
88	0.00061	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14751')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
89	0.00049	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14752' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
90	0.00069	SELECT filter_id FROM oc_product_filter WHERE product_id = '14752'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
91	0.00017	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
92	0.00014	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
93	0.0002	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (398,849,850,1210,1443) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
94	0.00061	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14752')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
95	0.00045	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14758' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
96	0.00036	SELECT filter_id FROM oc_product_filter WHERE product_id = '14758'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
97	0.00068	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (852,1445) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
98	0.00059	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (852,1445) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
99	0.00059	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14758')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
100	0.00045	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14771' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
101	0.00038	SELECT filter_id FROM oc_product_filter WHERE product_id = '14771'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
102	0.00064	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (859,860,1213,1378) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
103	0.00059	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (859,860,1213,1378) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
104	0.00061	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (859,860,1213,1378) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
105	0.00049	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14771')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
106	0.00076	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14772' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
107	0.00056	SELECT filter_id FROM oc_product_filter WHERE product_id = '14772'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
108	0.00154	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (859,860,1213,1378) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
109	0.00018	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (859,860,1213,1378) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
110	0.00017	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (859,860,1213,1378) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
111	0.00087	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14772')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
112	0.00059	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14773' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
113	0.00051	SELECT filter_id FROM oc_product_filter WHERE product_id = '14773'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
114	0.00089	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (861,862,1214,1379) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
115	0.00115	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (861,862,1214,1379) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
116	0.00066	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (861,862,1214,1379) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
117	0.00065	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14773')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
118	0.00047	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14774' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
119	0.00049	SELECT filter_id FROM oc_product_filter WHERE product_id = '14774'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
120	0.00013	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (861,862,1214,1379) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
121	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (861,862,1214,1379) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
122	0.00013	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (861,862,1214,1379) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
123	0.00039	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14774')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
124	0.00069	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14745' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
125	0.00078	SELECT filter_id FROM oc_product_filter WHERE product_id = '14745'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
126	0.00082	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (847,1441) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
127	0.00069	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (847,1441) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
128	0.00054	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14745')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
129	0.00056	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14746' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
130	0.00063	SELECT filter_id FROM oc_product_filter WHERE product_id = '14746'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
131	0.00083	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (848,1442) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
132	0.00077	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (848,1442) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
133	0.00074	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14746')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
134	0.00065	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14749' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
135	0.00089	SELECT filter_id FROM oc_product_filter WHERE product_id = '14749'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
136	0.00102	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (849,850,1210,1443) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
137	0.00093	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (849,850,1210,1443) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
138	0.00064	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (849,850,1210,1443) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
139	0.00054	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14749')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
140	0.00073	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14750' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
141	0.00039	SELECT filter_id FROM oc_product_filter WHERE product_id = '14750'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
142	0.00039	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (849,850,1210,1443) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
143	0.00017	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (849,850,1210,1443) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
144	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (849,850,1210,1443) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
145	0.00053	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14750')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
146	0.00101	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14759' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
147	0.00041	SELECT filter_id FROM oc_product_filter WHERE product_id = '14759'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
148	0.00098	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (853,1446) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
149	0.0011	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (853,1446) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
150	0.00077	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14759')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
151	0.00089	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14760' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
152	0.00045	SELECT filter_id FROM oc_product_filter WHERE product_id = '14760'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
153	0.00035	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (853,1446) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
154	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (853,1446) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
155	0.00052	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14760')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
156	0.00051	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14761' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
157	0.00048	SELECT filter_id FROM oc_product_filter WHERE product_id = '14761'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
158	0.00043	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (853,1446) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
159	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (853,1446) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
160	0.00053	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14761')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
161	0.00055	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14762' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
162	0.0006	SELECT filter_id FROM oc_product_filter WHERE product_id = '14762'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
163	0.00076	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (854,1447) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
164	0.00075	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (854,1447) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
165	0.0005	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14762')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
166	0.00054	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14763' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
167	0.00049	SELECT filter_id FROM oc_product_filter WHERE product_id = '14763'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
168	0.00097	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (855,856,1211,1448) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
169	0.00052	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (855,856,1211,1448) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
170	0.00067	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (855,856,1211,1448) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
171	0.00055	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14763')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
172	0.00062	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14764' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
173	0.00057	SELECT filter_id FROM oc_product_filter WHERE product_id = '14764'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
174	0.00065	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (857,858,1212,1377) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
175	0.00069	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
176	0.00059	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
177	0.00048	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14764')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
178	0.00055	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14765' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
179	0.00036	SELECT filter_id FROM oc_product_filter WHERE product_id = '14765'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
180	0.00015	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (857,858,1212,1377) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
181	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
182	0.0002	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
183	0.00057	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14765')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
184	0.00067	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14766' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
185	0.00044	SELECT filter_id FROM oc_product_filter WHERE product_id = '14766'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
186	0.00017	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (857,858,1212,1377) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
187	0.00021	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
188	0.0002	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
189	0.00049	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14766')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
190	0.00073	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14767' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
191	0.0004	SELECT filter_id FROM oc_product_filter WHERE product_id = '14767'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
192	0.00018	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (857,858,1212,1377) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
193	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
194	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
195	0.0005	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14767')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
196	0.00077	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14768' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
197	0.0004	SELECT filter_id FROM oc_product_filter WHERE product_id = '14768'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
198	0.00017	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (857,858,1212,1377) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
199	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
200	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
201	0.0005	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14768')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
202	0.00073	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14769' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
203	0.0004	SELECT filter_id FROM oc_product_filter WHERE product_id = '14769'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
204	0.00017	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (857,858,1212,1377) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
205	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
206	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
207	0.00053	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14769')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
208	0.00074	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14770' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
209	0.00037	SELECT filter_id FROM oc_product_filter WHERE product_id = '14770'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
210	0.00021	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (857,858,1212,1377) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
211	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
212	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (857,858,1212,1377) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
213	0.0006	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14770')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
214	0.00076	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14786' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
215	0.00041	SELECT filter_id FROM oc_product_filter WHERE product_id = '14786'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
216	0.00082	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (864,866,1217,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
217	0.00092	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (864,866,1217,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
218	0.00073	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (864,866,1217,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
219	0.00055	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14786')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
220	0.00073	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14787' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
221	0.00051	SELECT filter_id FROM oc_product_filter WHERE product_id = '14787'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
222	0.00021	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (864,866,1217,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
223	0.00017	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (864,866,1217,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
224	0.00091	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (864,866,1217,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
225	0.00064	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14787')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
226	0.00046	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14775' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
227	0.00076	SELECT filter_id FROM oc_product_filter WHERE product_id = '14775'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
228	0.00105	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (863,864,1215,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
229	0.00056	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
230	0.00048	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
231	0.00065	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14775')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
232	0.00047	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14776' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
233	0.00049	SELECT filter_id FROM oc_product_filter WHERE product_id = '14776'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
234	0.00057	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (863,864,1215,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
235	0.00013	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
236	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
237	0.00039	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14776')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
238	0.00043	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14777' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
239	0.00046	SELECT filter_id FROM oc_product_filter WHERE product_id = '14777'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
240	0.00044	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (863,864,1215,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
241	0.00013	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
242	0.00013	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
243	0.00042	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14777')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
244	0.00037	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14778' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
245	0.00048	SELECT filter_id FROM oc_product_filter WHERE product_id = '14778'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
246	0.00038	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (863,864,1215,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
247	0.00015	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
248	0.00017	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
249	0.0005	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14778')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
250	0.00053	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14779' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
251	0.00057	SELECT filter_id FROM oc_product_filter WHERE product_id = '14779'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
252	0.00083	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (863,864,1215,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
253	0.00017	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
254	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
255	0.00055	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14779')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
256	0.00047	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14780' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
257	0.00063	SELECT filter_id FROM oc_product_filter WHERE product_id = '14780'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
258	0.00021	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (863,864,1215,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
259	0.0002	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
260	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
261	0.00055	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14780')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
262	0.00046	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14781' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
263	0.00061	SELECT filter_id FROM oc_product_filter WHERE product_id = '14781'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
264	0.00023	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (863,864,1215,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
265	0.00018	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
266	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
267	0.00056	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14781')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
268	0.00047	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14782' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
269	0.00058	SELECT filter_id FROM oc_product_filter WHERE product_id = '14782'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
270	0.00024	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (863,864,1215,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
271	0.00017	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
272	0.0002	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
273	0.00051	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14782')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
274	0.00046	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14783' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
275	0.00059	SELECT filter_id FROM oc_product_filter WHERE product_id = '14783'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
276	0.00025	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (863,864,1215,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
277	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
278	0.00016	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (863,864,1215,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
279	0.00051	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14783')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
280	0.0005	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14784' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
281	0.00036	SELECT filter_id FROM oc_product_filter WHERE product_id = '14784'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
282	0.00096	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (864,865,1216,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
283	0.00072	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (864,865,1216,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
284	0.00064	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (864,865,1216,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
285	0.00055	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14784')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
286	0.00073	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '14785' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
287	0.00043	SELECT filter_id FROM oc_product_filter WHERE product_id = '14785'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
288	0.00018	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (864,865,1216,1380) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
289	0.0002	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (864,865,1216,1380) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
290	0.00017	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (864,865,1216,1380) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
291	0.00079	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70', 'product_id=14785')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
292	0.00064	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
293	0.00017	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
294	0.00017	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
295	0.00021	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
296	0.00017	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
297	0.00014	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
298	0.00013	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
299	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
300	0.00014	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
301	0.00013	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
302	0.00031	SELECT * FROM oc_category_to_layout WHERE category_id = '70' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
303	0.00047	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1	/home/ttncomua/public_html/catalog/model/design/layout.php	getLayout
304	0.0002	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
305	0.00014	SELECT * FROM oc_category_to_layout WHERE category_id = '70' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
306	0.00013	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1	/home/ttncomua/public_html/catalog/model/design/layout.php	getLayout
307	0.00017	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
308	0.00165	SELECT MIN(p.price) as min_price, MAX(p.price) as max_price FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p2c.product_id = p.product_id) WHERE p2c.category_id = 70 AND p.price <> '999999.0000' AND p.status = '1'	/home/ttncomua/public_html/catalog/controller/module/priceslider.php	index
309	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
310	0.00027	SELECT category_id FROM oc_category WHERE parent_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoriesByParentId
311	0.00206	SELECT m.manufacturer_id, m.name, COUNT(p.product_id) AS products_total FROM oc_product_to_category pc LEFT JOIN oc_product p ON (p.product_id = pc.product_id) LEFT JOIN oc_manufacturer m ON (m.manufacturer_id = p.manufacturer_id) WHERE pc.category_id IN (70) AND p.status = 1 AND p.quantity > -1 GROUP BY m.manufacturer_id ORDER BY m.name ASC	/home/ttncomua/public_html/catalog/model/catalog/manufacturer.php	getManufacturersByCategories
312	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
313	0.00033	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
314	0.00044	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
315	0.00029	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
316	0.00031	SELECT 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 = '70' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategory
317	0.00028	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
318	0.00025	SELECT filter_id FROM oc_category_filter WHERE category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
319	0.00029	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (847,848,850,851,852,853,854,856,858,860,862,864,868,1210,1211,1212,1213,1214,1215,1216,1217,1218,1377,1378,1379,1380,1381,1441,1442,1443,1444,1445,1446,1447,1448) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
320	0.00026	SELECT DISTINCT f.filter_id, fd.name, fd.img FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (847,848,850,851,852,853,854,856,858,860,862,864,868,1210,1211,1212,1213,1214,1215,1216,1217,1218,1377,1378,1379,1380,1381,1441,1442,1443,1444,1445,1446,1447,1448) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
321	0.00025	SELECT DISTINCT f.filter_id, fd.name, fd.img FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (847,848,850,851,852,853,854,856,858,860,862,864,868,1210,1211,1212,1213,1214,1215,1216,1217,1218,1377,1378,1379,1380,1381,1441,1442,1443,1444,1445,1446,1447,1448) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
322	0.00151	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1210,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1210,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
323	0.00159	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1210 ON (p2c.product_id = pf1210.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1210.filter_id = 1210 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
324	0.00137	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1211,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1211,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
325	0.00084	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1211 ON (p2c.product_id = pf1211.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1211.filter_id = 1211 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
326	0.00106	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1212,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1212,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
327	0.00104	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1212 ON (p2c.product_id = pf1212.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1212.filter_id = 1212 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
328	0.00112	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1213,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1213,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
329	0.00099	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1213 ON (p2c.product_id = pf1213.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1213.filter_id = 1213 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
330	0.00107	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1217,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1217,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
331	0.00115	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1217 ON (p2c.product_id = pf1217.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1217.filter_id = 1217 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
332	0.00107	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1215,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1215,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
333	0.00112	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1215 ON (p2c.product_id = pf1215.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1215.filter_id = 1215 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
334	0.00099	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1216,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1216,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
335	0.00082	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1216 ON (p2c.product_id = pf1216.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1216.filter_id = 1216 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
336	0.00108	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1214,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1214,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
337	0.00127	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1214 ON (p2c.product_id = pf1214.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1214.filter_id = 1214 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
338	0.001	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1218,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1218,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
339	0.00153	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1218 ON (p2c.product_id = pf1218.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1218.filter_id = 1218 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
340	0.00018	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1380,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1380,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
341	0.00165	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1380 ON (p2c.product_id = pf1380.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1380.filter_id = 1380 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
342	0.00025	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1443,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1443,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
343	0.00135	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1443 ON (p2c.product_id = pf1443.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1443.filter_id = 1443 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
344	0.00021	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1381,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1381,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
345	0.00134	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1381 ON (p2c.product_id = pf1381.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1381.filter_id = 1381 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
346	0.00024	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1377,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1377,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
347	0.00166	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1377 ON (p2c.product_id = pf1377.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1377.filter_id = 1377 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
348	0.00021	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1378,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1378,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
349	0.00102	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1378 ON (p2c.product_id = pf1378.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1378.filter_id = 1378 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
350	0.00027	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1444,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1444,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
351	0.00091	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1444 ON (p2c.product_id = pf1444.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1444.filter_id = 1444 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
352	0.00022	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1442,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1442,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
353	0.00097	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1442 ON (p2c.product_id = pf1442.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1442.filter_id = 1442 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
354	0.0002	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1445,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1445,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
355	0.0009	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1445 ON (p2c.product_id = pf1445.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1445.filter_id = 1445 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
356	0.00025	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1446,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1446,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
357	0.00108	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1446 ON (p2c.product_id = pf1446.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1446.filter_id = 1446 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
358	0.00079	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1441,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1441,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
359	0.00099	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1441 ON (p2c.product_id = pf1441.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1441.filter_id = 1441 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
360	0.00024	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1448,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1448,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
361	0.00099	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1448 ON (p2c.product_id = pf1448.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1448.filter_id = 1448 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
362	0.00023	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1447,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1447,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
363	0.00113	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1447 ON (p2c.product_id = pf1447.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1447.filter_id = 1447 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
364	0.00045	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1379,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (1379,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
365	0.00118	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1379 ON (p2c.product_id = pf1379.product_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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf1379.filter_id = 1379 AND p2c.category_id = '70'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
366	0.00108	SELECT * FROM oc_category_to_layout WHERE category_id = '70' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
367	0.0008	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1	/home/ttncomua/public_html/catalog/model/design/layout.php	getLayout
368	0.00097	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
369	0.00148	SELECT * FROM oc_category_to_layout WHERE category_id = '70' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
370	0.00067	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1	/home/ttncomua/public_html/catalog/model/design/layout.php	getLayout
371	0.00043	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
372	0.00046	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
373	0.00084	SELECT * 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 id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC	/home/ttncomua/public_html/catalog/model/catalog/information.php	getInformations
374	0.00135	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
375	0.0006	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
376	0.00043	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
377	0.00277	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
378	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
379	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=5')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
380	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
381	0.00083	SELECT * 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 id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC	/home/ttncomua/public_html/catalog/model/catalog/information.php	getInformations
382	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
383	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
384	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
385	0.00037	SELECT * 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.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order DESC, LCASE(cd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategories
386	0.0003	SELECT * 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.parent_id = '19' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order DESC, LCASE(cd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategories
387	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19', 'category_id=1')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
388	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19', 'category_id=2')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
389	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19', 'category_id=3')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
390	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19', 'category_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
391	0.00016	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
392	0.00026	SELECT * 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.parent_id = '29' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order DESC, LCASE(cd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategories
393	0.00014	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=30')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
394	0.00016	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=31')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
395	0.00068	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=34')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
396	0.00028	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=35')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
397	0.00029	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=33')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
398	0.00026	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=39')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
399	0.00027	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=44')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
400	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=46')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
401	0.00027	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
402	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=40')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
403	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=48')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
404	0.00028	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=47')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
405	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=43')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
406	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=38')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
407	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=45')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
408	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
409	0.00034	SELECT * 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.parent_id = '20' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order DESC, LCASE(cd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategories
410	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=25')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
411	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=24')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
412	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
413	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=28')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
414	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=23')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
415	0.00021	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=26')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
416	0.00027	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
417	0.0004	SELECT * 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.parent_id = '49' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order DESC, LCASE(cd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategories
418	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=53')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
419	0.00021	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=68')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
420	0.00016	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=56')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
421	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=62')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
422	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=50')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
423	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=58')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
424	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=60')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
425	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=57')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
426	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=59')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
427	0.00031	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=54')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
428	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=55')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
429	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=51')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
430	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=52')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
431	0.00017	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=61')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
432	0.00017	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=63')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
433	0.00014	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
434	0.00022	SELECT * 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.parent_id = '6' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order DESC, LCASE(cd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategories
435	0.00014	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
436	0.00014	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=18')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
437	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=15')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
438	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=9')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
439	0.00019	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
440	0.00014	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
441	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=13')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
442	0.00017	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=16')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
443	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
444	0.00019	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
445	0.00023	SELECT * 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.parent_id = '64' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order DESC, LCASE(cd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategories
446	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=67')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
447	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=66')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
448	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
449	0.00026	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
450	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
451	0.00022	SELECT * FROM oc_category_to_layout WHERE category_id = '70' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
452	0.00024	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1	/home/ttncomua/public_html/catalog/model/design/layout.php	getLayout
453	0.00028	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
454	0.00033	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
455	0.00035	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
456	0.00025	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions