Электротехническая производственная компания 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(63) "vse-dlya-montazha-kabelya/kabel-kanaly-plastikovye-i-aksessuary"
}

POST

array(0) {
}

COOKIE

array(0) {
}

SERVER

array(44) {
  ["PHPRC"]=>
  string(22) "/usr/local/lib/php.ini"
  ["PATH"]=>
  string(180) "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin"
  ["PWD"]=>
  string(25) "/usr/local/cpanel/cgi-sys"
  ["TZ"]=>
  string(11) "Europe/Kiev"
  ["SHLVL"]=>
  string(1) "0"
  ["FCGI_ROLE"]=>
  string(9) "RESPONDER"
  ["REDIRECT_UNIQUE_ID"]=>
  string(24) "WwoLTsIcVBsAJjS@GYsAAAAE"
  ["REDIRECT_SCRIPT_URL"]=>
  string(64) "/vse-dlya-montazha-kabelya/kabel-kanaly-plastikovye-i-aksessuary"
  ["REDIRECT_SCRIPT_URI"]=>
  string(82) "https://380.com.ua/vse-dlya-montazha-kabelya/kabel-kanaly-plastikovye-i-aksessuary"
  ["REDIRECT_HTTPS"]=>
  string(2) "on"
  ["REDIRECT_STATUS"]=>
  string(3) "200"
  ["UNIQUE_ID"]=>
  string(24) "WwoLTsIcVBsAJjS@GYsAAAAE"
  ["SCRIPT_URL"]=>
  string(64) "/vse-dlya-montazha-kabelya/kabel-kanaly-plastikovye-i-aksessuary"
  ["SCRIPT_URI"]=>
  string(82) "https://380.com.ua/vse-dlya-montazha-kabelya/kabel-kanaly-plastikovye-i-aksessuary"
  ["HTTPS"]=>
  string(2) "on"
  ["HTTP_HOST"]=>
  string(10) "380.com.ua"
  ["HTTP_X_REAL_IP"]=>
  string(14) "54.167.216.239"
  ["HTTP_X_FORWARDED_FOR"]=>
  string(14) "54.167.216.239"
  ["HTTP_X_FORWARDED_PROTO"]=>
  string(5) "https"
  ["HTTP_CONNECTION"]=>
  string(5) "close"
  ["HTTP_ACCEPT_ENCODING"]=>
  string(21) "x-gzip, gzip, deflate"
  ["HTTP_USER_AGENT"]=>
  string(39) "CCBot/2.0 (http://commoncrawl.org/faq/)"
  ["HTTP_ACCEPT"]=>
  string(63) "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8"
  ["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(14) "54.167.216.239"
  ["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) "51171"
  ["REDIRECT_QUERY_STRING"]=>
  string(71) "_route_=vse-dlya-montazha-kabelya/kabel-kanaly-plastikovye-i-aksessuary"
  ["REDIRECT_URL"]=>
  string(64) "/vse-dlya-montazha-kabelya/kabel-kanaly-plastikovye-i-aksessuary"
  ["GATEWAY_INTERFACE"]=>
  string(7) "CGI/1.1"
  ["SERVER_PROTOCOL"]=>
  string(8) "HTTP/1.1"
  ["REQUEST_METHOD"]=>
  string(3) "GET"
  ["QUERY_STRING"]=>
  string(71) "_route_=vse-dlya-montazha-kabelya/kabel-kanaly-plastikovye-i-aksessuary"
  ["REQUEST_URI"]=>
  string(64) "/vse-dlya-montazha-kabelya/kabel-kanaly-plastikovye-i-aksessuary"
  ["SCRIPT_NAME"]=>
  string(10) "/index.php"
  ["PHP_SELF"]=>
  string(10) "/index.php"
  ["REQUEST_TIME"]=>
  string(10) "1527384910"
}

SESSION

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

FILES

array(0) {
}

REQUEST

array(1) {
  ["_route_"]=>
  string(63) "vse-dlya-montazha-kabelya/kabel-kanaly-plastikovye-i-aksessuary"
}

#	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/controller/module/astickers.php
77	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/astickers.tpl
78	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/content_bottom.tpl
79	/home/ttncomua/public_html/catalog/controller/common/footer.php
80	/home/ttncomua/public_html/catalog/controller/module/popupcart_extended.php
81	/home/ttncomua/public_html/catalog/language/russian/module/popupcart_extended.php
82	/home/ttncomua/public_html/catalog/view/theme/default/template/module/popupcart_extended.tpl
83	/home/ttncomua/public_html/catalog/language/russian/common/footer.php
84	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/footer.tpl
85	/home/ttncomua/public_html/catalog/controller/common/header.php
86	/home/ttncomua/public_html/catalog/language/russian/common/header.php
87	/home/ttncomua/public_html/catalog/model/setting/store.php
88	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/header.tpl
89	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/product/category.tpl
90	/home/ttncomua/public_html/system/helper/fa_debuger.php

#	Time	Query	File	Function
1	0.00024	SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://380.com.ua/'	/home/ttncomua/public_html/index.php	Array
2	0.00137	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.0002	SELECT * FROM oc_currency	/home/ttncomua/public_html/system/library/currency.php	__construct
5	0.00023	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.00017	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.00096	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','kabel-kanaly-plastikovye-i-aksessuary') ORDER BY FIND_IN_SET(keyword, 'vse-dlya-montazha-kabelya,kabel-kanaly-plastikovye-i-aksessuary')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	index
8	0.00022	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.00021	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
10	0.0002	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 = '12' 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.00018	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
12	0.00018	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 = '12' 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.00054	SELECT filter_id FROM oc_category_filter WHERE category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
14	0.00244	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) 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.00708	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) 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.00473	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) 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.00523	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '3' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
18	0.0035	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '4' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
19	0.003	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '24' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
20	0.00284	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '23' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
21	0.00334	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '16' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
22	0.00369	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
23	0.00384	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
24	0.02044	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 = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts
25	0.03842	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 = '12' GROUP BY p.product_id ORDER BY (p.image !='') DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,23	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProducts
26	0.00216	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2842' 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.00156	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2843' 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.00169	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2844' 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.00169	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2960' 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.00169	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2961' 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.00179	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2860' 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.00179	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2962' 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.00177	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2865' 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.00157	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2867' 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.00164	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2868' 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.0016	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2869' 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.00157	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2870' 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.00145	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2872' 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.00144	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2873' 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.00148	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2879' 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.00156	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2880' 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.00167	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2881' 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.00119	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2882' 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.00117	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2885' 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.00118	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2888' 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.00114	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2891' 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.00113	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2894' 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.00138	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND 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 = '2897' 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.00087	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 = '2842' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
50	0.0005	SELECT filter_id FROM oc_product_filter WHERE product_id = '2842'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
51	0.00113	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 (208,327,838,875,884,1080,1219) 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
52	0.00141	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 (208,327,838,875,884,1080,1219) 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
53	0.00138	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 (208,327,838,875,884,1080,1219) 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
54	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 (208,327,838,875,884,1080,1219) AND f.filter_group_id = '4' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
55	0.00063	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 (208,327,838,875,884,1080,1219) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
56	0.00058	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 (208,327,838,875,884,1080,1219) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
57	0.00048	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2842')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
58	0.00079	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 = '2843' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
59	0.00036	SELECT filter_id FROM oc_product_filter WHERE product_id = '2843'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
60	0.00069	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 (208,327,875,876,885,1125,1219) 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
61	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 (208,327,875,876,885,1125,1219) 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
62	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 (208,327,875,876,885,1125,1219) 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
63	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 (208,327,875,876,885,1125,1219) AND f.filter_group_id = '4' 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.00085	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 (208,327,875,876,885,1125,1219) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
65	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 (208,327,875,876,885,1125,1219) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
66	0.00053	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2843')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
67	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 = '2844' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
68	0.00041	SELECT filter_id FROM oc_product_filter WHERE product_id = '2844'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
69	0.00066	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 (208,327,875,884,886,1126,1219) 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
70	0.00068	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 (208,327,875,884,886,1126,1219) 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
71	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 (208,327,875,884,886,1126,1219) 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
72	0.00054	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 (208,327,875,884,886,1126,1219) AND f.filter_group_id = '4' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
73	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 (208,327,875,884,886,1126,1219) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
74	0.00057	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 (208,327,875,884,886,1126,1219) AND f.filter_group_id = '21' 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.00069	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2844')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
76	0.0012	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 = '2960' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
77	0.00034	SELECT filter_id FROM oc_product_filter WHERE product_id = '2960'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
78	0.00066	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 (208,327,876,878,1072) 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
79	0.0008	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 (208,327,876,878,1072) 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
80	0.0009	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 (208,327,876,878,1072) AND f.filter_group_id = '4' 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.00054	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 (208,327,876,878,1072) AND f.filter_group_id = '22' 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.00058	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 (208,327,876,878,1072) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
83	0.00048	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2960')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
84	0.00066	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 = '2961' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
85	0.00037	SELECT filter_id FROM oc_product_filter WHERE product_id = '2961'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
86	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 (198,208,228,741) 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
87	0.00063	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 (198,208,228,741) 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.00055	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 (198,208,228,741) AND f.filter_group_id = '4' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
89	0.00057	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 (198,208,228,741) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
90	0.00068	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 (198,208,228,741) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
91	0.00043	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2961')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
92	0.00044	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 = '2860' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
93	0.0005	SELECT filter_id FROM oc_product_filter WHERE product_id = '2860'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
94	0.00156	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 (208,228,838,884,887,1080,1220) 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
95	0.00065	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 (208,228,838,884,887,1080,1220) 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
96	0.00058	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 (208,228,838,884,887,1080,1220) 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
97	0.0006	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 (208,228,838,884,887,1080,1220) AND f.filter_group_id = '4' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
98	0.00062	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 (208,228,838,884,887,1080,1220) AND f.filter_group_id = '22' 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.00109	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 (208,228,838,884,887,1080,1220) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
100	0.00055	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2860')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
101	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 = '2962' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
102	0.00033	SELECT filter_id FROM oc_product_filter WHERE product_id = '2962'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
103	0.00052	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 (198,328,869) 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
104	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 (198,328,869) 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.0005	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 (198,328,869) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
106	0.00046	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 (198,328,869) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
107	0.00048	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2962')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
108	0.00036	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 = '2865' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
109	0.00052	SELECT filter_id FROM oc_product_filter WHERE product_id = '2865'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
110	0.00104	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 (198,328,741,888,1221) 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
111	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 (198,328,741,888,1221) 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
112	0.0005	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 (198,328,741,888,1221) 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
113	0.0006	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 (198,328,741,888,1221) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
114	0.00051	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 (198,328,741,888,1221) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
115	0.00043	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2865')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
116	0.0006	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 = '2867' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
117	0.00046	SELECT filter_id FROM oc_product_filter WHERE product_id = '2867'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
118	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 (328,838,884,888,1080,1221) 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
119	0.00076	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 (328,838,884,888,1080,1221) 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
120	0.00062	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 (328,838,884,888,1080,1221) 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
121	0.00057	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 (328,838,884,888,1080,1221) AND f.filter_group_id = '22' 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.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 (328,838,884,888,1080,1221) AND f.filter_group_id = '21' 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.00044	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2867')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
124	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 = '2868' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
125	0.00033	SELECT filter_id FROM oc_product_filter WHERE product_id = '2868'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
126	0.00084	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 (328,876,885,888,1125,1221) 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.00071	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 (328,876,885,888,1125,1221) 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
128	0.0006	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 (328,876,885,888,1125,1221) 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
129	0.00053	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 (328,876,885,888,1125,1221) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
130	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 (328,876,885,888,1125,1221) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
131	0.00046	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2868')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
132	0.00041	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 = '2869' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
133	0.00034	SELECT filter_id FROM oc_product_filter WHERE product_id = '2869'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
134	0.0006	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 (328,884,886,888,1126,1221) 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
135	0.00057	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 (328,884,886,888,1126,1221) 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
136	0.00062	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 (328,884,886,888,1126,1221) 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
137	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 (328,884,886,888,1126,1221) AND f.filter_group_id = '22' 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.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 (328,884,886,888,1126,1221) AND f.filter_group_id = '21' 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.00045	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2869')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
140	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 = '2870' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
141	0.00049	SELECT filter_id FROM oc_product_filter WHERE product_id = '2870'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
142	0.00085	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 (328,876,877,888,1070,1221) 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.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 (328,876,877,888,1070,1221) 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.00063	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 (328,876,877,888,1070,1221) 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.00063	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 (328,876,877,888,1070,1221) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
146	0.00058	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 (328,876,877,888,1070,1221) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
147	0.00049	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2870')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
148	0.00042	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 = '2872' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
149	0.00079	SELECT filter_id FROM oc_product_filter WHERE product_id = '2872'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
150	0.00127	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 (328,876,878,888,1072,1221) 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
151	0.00106	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 (328,876,878,888,1072,1221) 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
152	0.00087	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 (328,876,878,888,1072,1221) 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
153	0.00082	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 (328,876,878,888,1072,1221) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
154	0.00078	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 (328,876,878,888,1072,1221) AND f.filter_group_id = '21' 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.00046	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2872')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
156	0.00039	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 = '2873' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
157	0.00062	SELECT filter_id FROM oc_product_filter WHERE product_id = '2873'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
158	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 (328,878,879,888,1072,1221) 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.00054	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 (328,878,879,888,1072,1221) 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
160	0.00057	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 (328,878,879,888,1072,1221) 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
161	0.00098	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 (328,878,879,888,1072,1221) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
162	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 (328,878,879,888,1072,1221) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
163	0.00039	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2873')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
164	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 = '2879' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
165	0.00048	SELECT filter_id FROM oc_product_filter WHERE product_id = '2879'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
166	0.0007	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 (198,329,330,869,871,1062,1275) 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
167	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 (198,329,330,869,871,1062,1275) 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
168	0.0006	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 (198,329,330,869,871,1062,1275) AND f.filter_group_id = '3' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
169	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 (198,329,330,869,871,1062,1275) AND f.filter_group_id = '4' 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.00058	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 (198,329,330,869,871,1062,1275) AND f.filter_group_id = '22' 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.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 (198,329,330,869,871,1062,1275) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
172	0.00064	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2879')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
173	0.00041	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 = '2880' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
174	0.00064	SELECT filter_id FROM oc_product_filter WHERE product_id = '2880'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
175	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 (198,329,330,741,871,1062,1275) 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
176	0.00062	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 (198,329,330,741,871,1062,1275) 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.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 (198,329,330,741,871,1062,1275) AND f.filter_group_id = '3' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
178	0.00055	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 (198,329,330,741,871,1062,1275) AND f.filter_group_id = '4' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
179	0.00057	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 (198,329,330,741,871,1062,1275) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
180	0.00054	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 (198,329,330,741,871,1062,1275) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
181	0.00082	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2880')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
182	0.00079	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 = '2881' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
183	0.00032	SELECT filter_id FROM oc_product_filter WHERE product_id = '2881'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
184	0.00072	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 (329,330,871,915,916,1062,1120,1275) 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
185	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 (329,330,871,915,916,1062,1120,1275) 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
186	0.0006	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 (329,330,871,915,916,1062,1120,1275) AND f.filter_group_id = '3' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
187	0.00084	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 (329,330,871,915,916,1062,1120,1275) AND f.filter_group_id = '4' 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.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 (329,330,871,915,916,1062,1120,1275) AND f.filter_group_id = '22' 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.00087	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 (329,330,871,915,916,1062,1120,1275) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
190	0.00042	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2881')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
191	0.0004	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 = '2882' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
192	0.00031	SELECT filter_id FROM oc_product_filter WHERE product_id = '2882'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
193	0.00073	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 (329,330,871,882,883,1062,1124,1275) 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
194	0.00104	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 (329,330,871,882,883,1062,1124,1275) 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.00146	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 (329,330,871,882,883,1062,1124,1275) AND f.filter_group_id = '3' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
196	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 (329,330,871,882,883,1062,1124,1275) AND f.filter_group_id = '4' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
197	0.00057	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 (329,330,871,882,883,1062,1124,1275) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
198	0.0006	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 (329,330,871,882,883,1062,1124,1275) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
199	0.00042	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2882')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
200	0.00039	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 = '2885' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
201	0.00033	SELECT filter_id FROM oc_product_filter WHERE product_id = '2885'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
202	0.00071	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 (329,330,838,871,884,1062,1080,1275) 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
203	0.00109	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 (329,330,838,871,884,1062,1080,1275) 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
204	0.00106	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 (329,330,838,871,884,1062,1080,1275) AND f.filter_group_id = '3' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
205	0.00087	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 (329,330,838,871,884,1062,1080,1275) AND f.filter_group_id = '4' 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.00058	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 (329,330,838,871,884,1062,1080,1275) AND f.filter_group_id = '22' 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.00063	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 (329,330,838,871,884,1062,1080,1275) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
208	0.00044	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2885')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
209	0.00039	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 = '2888' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
210	0.00078	SELECT filter_id FROM oc_product_filter WHERE product_id = '2888'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
211	0.00208	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 (329,330,838,871,876,1062,1080,1275) 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
212	0.0008	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 (329,330,838,871,876,1062,1080,1275) 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.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 (329,330,838,871,876,1062,1080,1275) AND f.filter_group_id = '3' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
214	0.00132	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 (329,330,838,871,876,1062,1080,1275) AND f.filter_group_id = '4' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
215	0.00096	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 (329,330,838,871,876,1062,1080,1275) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
216	0.00117	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 (329,330,838,871,876,1062,1080,1275) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
217	0.00077	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2888')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
218	0.00068	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 = '2891' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
219	0.00047	SELECT filter_id FROM oc_product_filter WHERE product_id = '2891'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
220	0.00121	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 (329,330,871,884,886,1062,1126,1275) 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
221	0.0009	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 (329,330,871,884,886,1062,1126,1275) 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
222	0.001	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 (329,330,871,884,886,1062,1126,1275) AND f.filter_group_id = '3' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
223	0.00096	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 (329,330,871,884,886,1062,1126,1275) AND f.filter_group_id = '4' 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.00144	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 (329,330,871,884,886,1062,1126,1275) AND f.filter_group_id = '22' 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.00138	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 (329,330,871,884,886,1062,1126,1275) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
226	0.00069	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2891')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
227	0.0006	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 = '2894' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
228	0.0011	SELECT filter_id FROM oc_product_filter WHERE product_id = '2894'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
229	0.00116	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 (329,330,871,876,877,1062,1070,1275) 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
230	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 (329,330,871,876,877,1062,1070,1275) 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.00101	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 (329,330,871,876,877,1062,1070,1275) AND f.filter_group_id = '3' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
232	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 (329,330,871,876,877,1062,1070,1275) AND f.filter_group_id = '4' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
233	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 (329,330,871,876,877,1062,1070,1275) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
234	0.00101	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 (329,330,871,876,877,1062,1070,1275) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
235	0.00111	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2894')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
236	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 = '2897' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
237	0.0005	SELECT filter_id FROM oc_product_filter WHERE product_id = '2897'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
238	0.00118	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 (329,330,871,877,879,1062,1070,1275) 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
239	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 (329,330,871,877,879,1062,1070,1275) 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
240	0.00098	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 (329,330,871,877,879,1062,1070,1275) AND f.filter_group_id = '3' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
241	0.00095	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 (329,330,871,877,879,1062,1070,1275) AND f.filter_group_id = '4' 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.00086	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 (329,330,871,877,879,1062,1070,1275) AND f.filter_group_id = '22' 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.00098	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 (329,330,871,877,879,1062,1070,1275) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
244	0.0006	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12', 'product_id=2897')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
245	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
246	0.00023	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
247	0.00027	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
248	0.00025	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
249	0.00022	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
250	0.00024	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
251	0.00023	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
252	0.00026	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
253	0.00018	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
254	0.00021	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
255	0.00027	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
256	0.00047	SELECT * FROM oc_category_to_layout WHERE category_id = '12' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
257	0.00027	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
258	0.00044	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
259	0.00025	SELECT * FROM oc_category_to_layout WHERE category_id = '12' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
260	0.00022	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
261	0.00035	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
262	0.01031	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 = 12 AND p.price <> '999999.0000' AND p.status = '1'	/home/ttncomua/public_html/catalog/controller/module/priceslider.php	index
263	0.00038	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
264	0.00036	SELECT category_id FROM oc_category WHERE parent_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoriesByParentId
265	0.01106	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 (12) 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
266	0.0003	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
267	0.00024	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
268	0.00029	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
269	0.00038	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
270	0.00047	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
271	0.00035	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
272	0.00033	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 = '12' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategory
273	0.0003	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
274	0.00048	SELECT filter_id FROM oc_category_filter WHERE category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
275	0.0003	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) 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
276	0.00027	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) 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
277	0.00036	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) 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
278	0.00024	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '3' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
279	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '4' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
280	0.00034	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '24' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
281	0.00023	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '23' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
282	0.00023	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '16' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
283	0.00039	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '22' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
284	0.0003	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 (129,141,143,197,198,199,204,206,208,209,210,213,226,228,327,328,329,330,331,340,409,578,732,738,739,741,785,838,869,870,871,872,873,874,876,877,878,879,880,881,882,883,884,885,886,915,916,917,1062,1070,1071,1072,1073,1074,1078,1079,1080,1120,1121,1122,1123,1124,1125,1126,1219,1220,1221,1222,1223,1224,1275,1276,1382,1383,1449) AND f.filter_group_id = '21' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
285	0.0025	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 (1220,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 (1220,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
286	0.00175	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1220 ON (p2c.product_id = pf1220.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 pf1220.filter_id = 1220 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
287	0.00244	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 (1221,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 (1221,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
288	0.00109	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1221 ON (p2c.product_id = pf1221.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 pf1221.filter_id = 1221 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
289	0.00136	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 (1219,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 (1219,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
290	0.00113	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1219 ON (p2c.product_id = pf1219.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 pf1219.filter_id = 1219 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
291	0.00095	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 (1222,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 (1222,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
292	0.00106	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1222 ON (p2c.product_id = pf1222.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 pf1222.filter_id = 1222 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
293	0.00094	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 (1223,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 (1223,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
294	0.00099	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1223 ON (p2c.product_id = pf1223.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 pf1223.filter_id = 1223 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
295	0.00092	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 (1224,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 (1224,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
296	0.001	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1224 ON (p2c.product_id = pf1224.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 pf1224.filter_id = 1224 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
297	0.00105	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 (1449,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 (1449,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
298	0.00178	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1449 ON (p2c.product_id = pf1449.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 pf1449.filter_id = 1449 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
299	0.00048	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 (1275,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 (1275,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
300	0.00608	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1275 ON (p2c.product_id = pf1275.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 pf1275.filter_id = 1275 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
301	0.00019	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 (1276,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 (1276,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
302	0.00076	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1276 ON (p2c.product_id = pf1276.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 pf1276.filter_id = 1276 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
303	0.00101	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 (1383,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 (1383,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
304	0.00118	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1383 ON (p2c.product_id = pf1383.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 pf1383.filter_id = 1383 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
305	0.00083	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 (1382,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 (1382,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
306	0.00111	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1382 ON (p2c.product_id = pf1382.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 pf1382.filter_id = 1382 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
307	0.00032	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 (143,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 (143,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
308	0.00179	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf143 ON (p2c.product_id = pf143.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 pf143.filter_id = 143 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
309	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 (328,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 (328,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
310	0.00159	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf328 ON (p2c.product_id = pf328.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 pf328.filter_id = 328 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
311	0.00266	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 (329,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 (329,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
312	0.00617	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf329 ON (p2c.product_id = pf329.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 pf329.filter_id = 329 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
313	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 (226,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 (226,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
314	0.00122	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf226 ON (p2c.product_id = pf226.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 pf226.filter_id = 226 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
315	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 (331,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 (331,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
316	0.00089	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf331 ON (p2c.product_id = pf331.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 pf331.filter_id = 331 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
317	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 (578,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 (578,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
318	0.00075	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf578 ON (p2c.product_id = pf578.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 pf578.filter_id = 578 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
319	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 (409,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 (409,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
320	0.00171	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf409 ON (p2c.product_id = pf409.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 pf409.filter_id = 409 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
321	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 (340,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 (340,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
322	0.00154	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf340 ON (p2c.product_id = pf340.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 pf340.filter_id = 340 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
323	0.00038	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 (129,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 (129,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
324	0.00234	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf129 ON (p2c.product_id = pf129.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 pf129.filter_id = 129 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
325	0.00055	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 (208,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 (208,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
326	0.0049	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf208 ON (p2c.product_id = pf208.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 pf208.filter_id = 208 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
327	0.00038	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 (1062,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 (1062,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
328	0.00612	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1062 ON (p2c.product_id = pf1062.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 pf1062.filter_id = 1062 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
329	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 (228,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 (228,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
330	0.0016	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf228 ON (p2c.product_id = pf228.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 pf228.filter_id = 228 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
331	0.00038	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 (204,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 (204,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
332	0.00508	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf204 ON (p2c.product_id = pf204.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 pf204.filter_id = 204 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
333	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 (330,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 (330,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
334	0.00233	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf330 ON (p2c.product_id = pf330.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 pf330.filter_id = 330 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
335	0.00028	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 (209,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 (209,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
336	0.00193	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf209 ON (p2c.product_id = pf209.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 pf209.filter_id = 209 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
337	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 (327,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 (327,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
338	0.00155	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf327 ON (p2c.product_id = pf327.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 pf327.filter_id = 327 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
339	0.00016	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 (785,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 (785,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
340	0.00083	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf785 ON (p2c.product_id = pf785.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 pf785.filter_id = 785 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
341	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 (213,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 (213,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
342	0.00178	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf213 ON (p2c.product_id = pf213.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 pf213.filter_id = 213 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
343	0.00038	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 (210,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 (210,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
344	0.0025	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf210 ON (p2c.product_id = pf210.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 pf210.filter_id = 210 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
345	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 (141,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 (141,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
346	0.00144	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf141 ON (p2c.product_id = pf141.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 pf141.filter_id = 141 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
347	0.00116	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 (884,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 (884,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
348	0.00181	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf884 ON (p2c.product_id = pf884.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 pf884.filter_id = 884 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
349	0.00087	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 (882,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 (882,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
350	0.00133	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf882 ON (p2c.product_id = pf882.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 pf882.filter_id = 882 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
351	0.0011	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 (876,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 (876,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
352	0.00183	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf876 ON (p2c.product_id = pf876.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 pf876.filter_id = 876 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
353	0.00088	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 (1121,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 (1121,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
354	0.00079	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1121 ON (p2c.product_id = pf1121.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 pf1121.filter_id = 1121 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
355	0.00081	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 (1079,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 (1079,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
356	0.0006	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1079 ON (p2c.product_id = pf1079.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 pf1079.filter_id = 1079 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
357	0.00084	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 (881,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 (881,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
358	0.00085	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf881 ON (p2c.product_id = pf881.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 pf881.filter_id = 881 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
359	0.00094	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 (879,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 (879,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
360	0.00135	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf879 ON (p2c.product_id = pf879.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 pf879.filter_id = 879 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
361	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 (1078,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 (1078,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
362	0.00134	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1078 ON (p2c.product_id = pf1078.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 pf1078.filter_id = 1078 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
363	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 (869,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 (869,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
364	0.00287	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf869 ON (p2c.product_id = pf869.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 pf869.filter_id = 869 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
365	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 (915,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 (915,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
366	0.00071	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf915 ON (p2c.product_id = pf915.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 pf915.filter_id = 915 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
367	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 (741,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 (741,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
368	0.00286	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf741 ON (p2c.product_id = pf741.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 pf741.filter_id = 741 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
369	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 (739,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 (739,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
370	0.0021	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf739 ON (p2c.product_id = pf739.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 pf739.filter_id = 739 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
371	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 (738,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 (738,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
372	0.00173	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf738 ON (p2c.product_id = pf738.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 pf738.filter_id = 738 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
373	0.00121	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 (1120,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 (1120,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
374	0.00071	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1120 ON (p2c.product_id = pf1120.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 pf1120.filter_id = 1120 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
375	0.00109	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 (1124,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 (1124,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
376	0.00091	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1124 ON (p2c.product_id = pf1124.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 pf1124.filter_id = 1124 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
377	0.00017	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 (1074,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 (1074,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
378	0.00085	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1074 ON (p2c.product_id = pf1074.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 pf1074.filter_id = 1074 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
379	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 (1080,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 (1080,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
380	0.00145	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1080 ON (p2c.product_id = pf1080.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 pf1080.filter_id = 1080 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
381	0.00098	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 (1125,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 (1125,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
382	0.0007	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1125 ON (p2c.product_id = pf1125.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 pf1125.filter_id = 1125 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
383	0.0009	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 (1126,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 (1126,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
384	0.00086	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1126 ON (p2c.product_id = pf1126.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 pf1126.filter_id = 1126 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
385	0.00082	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 (1123,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 (1123,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
386	0.00061	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1123 ON (p2c.product_id = pf1123.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 pf1123.filter_id = 1123 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
387	0.00019	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 (1070,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 (1070,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
388	0.00179	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1070 ON (p2c.product_id = pf1070.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 pf1070.filter_id = 1070 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
389	0.00082	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 (1122,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 (1122,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
390	0.00061	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1122 ON (p2c.product_id = pf1122.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 pf1122.filter_id = 1122 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
391	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 (1072,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 (1072,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
392	0.00209	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1072 ON (p2c.product_id = pf1072.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 pf1072.filter_id = 1072 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
393	0.00017	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 (1071,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 (1071,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
394	0.00158	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1071 ON (p2c.product_id = pf1071.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 pf1071.filter_id = 1071 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
395	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 (1073,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 (1073,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
396	0.00206	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1073 ON (p2c.product_id = pf1073.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 pf1073.filter_id = 1073 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
397	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 (197,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 (197,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
398	0.00099	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf197 ON (p2c.product_id = pf197.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 pf197.filter_id = 197 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
399	0.00036	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 (198,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 (198,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
400	0.00338	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf198 ON (p2c.product_id = pf198.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 pf198.filter_id = 198 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
401	0.00038	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 (206,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 (206,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
402	0.00263	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf206 ON (p2c.product_id = pf206.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 pf206.filter_id = 206 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
403	0.00044	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 (199,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 (199,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
404	0.0034	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf199 ON (p2c.product_id = pf199.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 pf199.filter_id = 199 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
405	0.00113	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 (916,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 (916,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
406	0.00124	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf916 ON (p2c.product_id = pf916.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 pf916.filter_id = 916 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
407	0.0009	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 (883,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 (883,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
408	0.00111	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf883 ON (p2c.product_id = pf883.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 pf883.filter_id = 883 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
409	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 (838,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 (838,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
410	0.00112	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf838 ON (p2c.product_id = pf838.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 pf838.filter_id = 838 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
411	0.00085	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 (885,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 (885,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
412	0.00072	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf885 ON (p2c.product_id = pf885.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 pf885.filter_id = 885 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
413	0.0009	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 (886,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 (886,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
414	0.00083	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf886 ON (p2c.product_id = pf886.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 pf886.filter_id = 886 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
415	0.00132	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 (877,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 (877,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
416	0.00117	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf877 ON (p2c.product_id = pf877.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 pf877.filter_id = 877 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
417	0.00098	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 (917,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 (917,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
418	0.00063	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf917 ON (p2c.product_id = pf917.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 pf917.filter_id = 917 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
419	0.00128	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 (878,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 (878,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
420	0.00153	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf878 ON (p2c.product_id = pf878.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 pf878.filter_id = 878 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
421	0.00097	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 (880,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 (880,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
422	0.00101	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf880 ON (p2c.product_id = pf880.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 pf880.filter_id = 880 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
423	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 (870,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 (870,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
424	0.00147	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf870 ON (p2c.product_id = pf870.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 pf870.filter_id = 870 AND p2c.category_id = '12'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
425	0.00025	SELECT * FROM oc_category_to_layout WHERE category_id = '12' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
426	0.00015	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
427	0.00019	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
428	0.00014	SELECT * FROM oc_category_to_layout WHERE category_id = '12' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
429	0.00014	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
430	0.0002	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
431	0.00028	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
432	0.00108	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
433	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
434	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
435	0.00014	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
436	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
437	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
438	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=5')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
439	0.00017	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
440	0.00046	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
441	0.00031	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
442	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
443	0.00031	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
444	0.00033	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
445	0.00032	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
446	0.00026	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
447	0.00035	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
448	0.0003	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
449	0.0003	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
450	0.00028	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19', 'category_id=5')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
451	0.00026	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
452	0.0005	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
453	0.00028	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
454	0.00036	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
455	0.00028	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
456	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
457	0.00038	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
458	0.0003	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
459	0.00035	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
460	0.00033	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
461	0.00033	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
462	0.00031	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=42')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
463	0.00031	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
464	0.00034	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
465	0.00038	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
466	0.00038	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
467	0.00031	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=36')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
468	0.00032	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=32')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
469	0.00036	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=37')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
470	0.00038	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
471	0.0003	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
472	0.00034	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=69')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
473	0.00032	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
474	0.00054	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
475	0.00041	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
476	0.0003	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
477	0.00036	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
478	0.00041	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
479	0.00034	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
480	0.00033	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
481	0.00032	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=27')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
482	0.00031	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=21')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
483	0.0003	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
484	0.00044	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
485	0.00032	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
486	0.00029	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
487	0.00023	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
488	0.0003	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
489	0.00029	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
490	0.00033	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
491	0.00028	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
492	0.00024	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
493	0.00027	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
494	0.00028	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
495	0.00033	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
496	0.00023	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
497	0.00027	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
498	0.00033	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
499	0.00031	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
500	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
501	0.00041	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
502	0.00026	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
503	0.0003	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
504	0.00029	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
505	0.00031	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
506	0.00027	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
507	0.00022	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
508	0.00029	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
509	0.00021	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
510	0.0003	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
511	0.00027	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
512	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 = '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
513	0.00025	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
514	0.00032	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
515	0.00029	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
516	0.00028	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
517	0.00031	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
518	0.00027	SELECT * FROM oc_category_to_layout WHERE category_id = '12' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
519	0.00026	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
520	0.00062	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
521	0.00044	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
522	0.00039	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
523	0.00029	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions