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

POST

array(0) {
}

COOKIE

array(0) {
}

SERVER

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

SESSION

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

FILES

array(0) {
}

REQUEST

array(1) {
  ["_route_"]=>
  string(59) "vse-dlya-montazha-kabelya/lotki-metallicheskie-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/view/theme/tehnoton/template/common/content_bottom.tpl
77	/home/ttncomua/public_html/catalog/controller/common/footer.php
78	/home/ttncomua/public_html/catalog/controller/module/popupcart_extended.php
79	/home/ttncomua/public_html/catalog/language/russian/module/popupcart_extended.php
80	/home/ttncomua/public_html/catalog/view/theme/default/template/module/popupcart_extended.tpl
81	/home/ttncomua/public_html/catalog/language/russian/common/footer.php
82	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/footer.tpl
83	/home/ttncomua/public_html/catalog/controller/common/header.php
84	/home/ttncomua/public_html/catalog/language/russian/common/header.php
85	/home/ttncomua/public_html/catalog/model/setting/store.php
86	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/header.tpl
87	/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/product/category.tpl
88	/home/ttncomua/public_html/system/helper/fa_debuger.php

#	Time	Query	File	Function
1	0.00024	SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://380.com.ua/'	/home/ttncomua/public_html/index.php	Array
2	0.00131	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.00016	SELECT * FROM `oc_language` WHERE status = '1'	/home/ttncomua/public_html/index.php	Array
4	0.00015	SELECT * FROM oc_currency	/home/ttncomua/public_html/system/library/currency.php	__construct
5	0.00014	SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '2'	/home/ttncomua/public_html/system/library/weight.php	__construct
6	0.00013	SELECT * FROM oc_length_class mc LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '2'	/home/ttncomua/public_html/system/library/length.php	__construct
7	0.00082	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','lotki-metallicheskie-i-aksessuary') ORDER BY FIND_IN_SET(keyword, 'vse-dlya-montazha-kabelya,lotki-metallicheskie-i-aksessuary')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	index
8	0.00019	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.00013	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
10	0.00015	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 = '14' 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=14')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
12	0.00015	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 = '14' 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.00019	SELECT filter_id FROM oc_category_filter WHERE category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
14	0.0002	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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.00015	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
16	0.00013	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
17	0.00015	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
18	0.00016	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
19	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
20	0.00021	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
21	0.00018	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
22	0.00084	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 = '4683' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
23	0.00045	SELECT filter_id FROM oc_product_filter WHERE product_id = '4683'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
24	0.00097	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (281,392) 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
25	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 (281,392) 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
26	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 (281,392) 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
27	0.00048	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4683')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
28	0.00043	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '4684' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
29	0.00032	SELECT filter_id FROM oc_product_filter WHERE product_id = '4684'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
30	0.00014	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 (281,392) 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
31	0.00013	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (281,392) 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
32	0.00013	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (281,392) 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
33	0.00045	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4684')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
34	0.00043	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '5036' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
35	0.00032	SELECT filter_id FROM oc_product_filter WHERE product_id = '5036'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
36	0.00043	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (198) 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
37	0.00042	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) 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
38	0.00065	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=5036')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
39	0.00067	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '5037' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
40	0.00056	SELECT filter_id FROM oc_product_filter WHERE product_id = '5037'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
41	0.00071	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=5037')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
42	0.00059	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '5038' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
43	0.0006	SELECT filter_id FROM oc_product_filter WHERE product_id = '5038'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
44	0.00072	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=5038')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
45	0.00071	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 = '5039' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
46	0.00046	SELECT filter_id FROM oc_product_filter WHERE product_id = '5039'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
47	0.00077	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=5039')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
48	0.00059	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '5035' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
49	0.00042	SELECT filter_id FROM oc_product_filter WHERE product_id = '5035'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
50	0.00065	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=5035')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
51	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 = '5240' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
52	0.00041	SELECT filter_id FROM oc_product_filter WHERE product_id = '5240'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
53	0.00106	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 (202,203,205,330) 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
54	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 (202,203,205,330) 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
55	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 (202,203,205,330) 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
56	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 (202,203,205,330) 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
57	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 (202,203,205,330) 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
58	0.0006	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=5240')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
59	0.00097	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 = '5241' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
60	0.00061	SELECT filter_id FROM oc_product_filter WHERE product_id = '5241'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
61	0.00098	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (203,205,292,330) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
62	0.00083	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 (203,205,292,330) 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.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 (203,205,292,330) 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.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 (203,205,292,330) 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.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 (203,205,292,330) 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.00069	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=5241')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
67	0.00055	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '4854' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
68	0.00045	SELECT filter_id FROM oc_product_filter WHERE product_id = '4854'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
69	0.00067	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4854')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
70	0.00082	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 = '4862' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
71	0.00045	SELECT filter_id FROM oc_product_filter WHERE product_id = '4862'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
72	0.00061	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4862')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
73	0.00054	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '4954' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
74	0.00045	SELECT filter_id FROM oc_product_filter WHERE product_id = '4954'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
75	0.00021	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (208,210) 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
76	0.00023	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,210) 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
77	0.00025	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,210) 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	getProductFilter
78	0.00082	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4954')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
79	0.00091	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 = '5124' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
80	0.00052	SELECT filter_id FROM oc_product_filter WHERE product_id = '5124'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
81	0.00022	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (198) 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
82	0.00022	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) 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.00065	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=5124')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
84	0.00055	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '18391' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
85	0.00067	SELECT filter_id FROM oc_product_filter WHERE product_id = '18391'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
86	0.00084	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=18391')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
87	0.00078	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 = '4662' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
88	0.00042	SELECT filter_id FROM oc_product_filter WHERE product_id = '4662'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
89	0.00064	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4662')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
90	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 = '4715' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
91	0.00091	SELECT filter_id FROM oc_product_filter WHERE product_id = '4715'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
92	0.00067	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4715')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
93	0.00058	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 = '4716' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
94	0.00043	SELECT filter_id FROM oc_product_filter WHERE product_id = '4716'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
95	0.00071	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4716')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
96	0.00054	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '4717' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
97	0.00042	SELECT filter_id FROM oc_product_filter WHERE product_id = '4717'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
98	0.00059	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4717')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
99	0.00095	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 = '4718' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
100	0.00048	SELECT filter_id FROM oc_product_filter WHERE product_id = '4718'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
101	0.00072	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4718')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
102	0.00057	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '4719' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
103	0.00042	SELECT filter_id FROM oc_product_filter WHERE product_id = '4719'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
104	0.00062	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4719')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
105	0.00088	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 = '4720' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
106	0.00045	SELECT filter_id FROM oc_product_filter WHERE product_id = '4720'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
107	0.00067	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4720')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
108	0.00057	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '4721' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
109	0.00043	SELECT filter_id FROM oc_product_filter WHERE product_id = '4721'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
110	0.00062	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4721')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
111	0.00094	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 = '4722' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
112	0.00069	SELECT filter_id FROM oc_product_filter WHERE product_id = '4722'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
113	0.00064	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4722')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
114	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 = '4723' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
115	0.00038	SELECT filter_id FROM oc_product_filter WHERE product_id = '4723'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
116	0.00064	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4723')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
117	0.00062	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '4724' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
118	0.00073	SELECT filter_id FROM oc_product_filter WHERE product_id = '4724'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
119	0.00109	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4724')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
120	0.00089	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '4725' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
121	0.00056	SELECT filter_id FROM oc_product_filter WHERE product_id = '4725'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
122	0.00066	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4725')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
123	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 = '4726' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
124	0.00044	SELECT filter_id FROM oc_product_filter WHERE product_id = '4726'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
125	0.00067	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4726')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
126	0.00063	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 = '4727' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
127	0.00055	SELECT filter_id FROM oc_product_filter WHERE product_id = '4727'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
128	0.00083	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4727')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
129	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 = '4728' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
130	0.00043	SELECT filter_id FROM oc_product_filter WHERE product_id = '4728'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
131	0.00065	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4728')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
132	0.00062	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '4729' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
133	0.00046	SELECT filter_id FROM oc_product_filter WHERE product_id = '4729'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
134	0.00064	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4729')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
135	0.00058	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 = '4730' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
136	0.00073	SELECT filter_id FROM oc_product_filter WHERE product_id = '4730'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
137	0.00117	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4730')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
138	0.00218	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 = '4731' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
139	0.00036	SELECT filter_id FROM oc_product_filter WHERE product_id = '4731'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
140	0.00066	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4731')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
141	0.00051	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '4732' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
142	0.00035	SELECT filter_id FROM oc_product_filter WHERE product_id = '4732'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
143	0.00042	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4732')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
144	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 = '4756' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
145	0.00027	SELECT filter_id FROM oc_product_filter WHERE product_id = '4756'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
146	0.00043	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4756')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
147	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 = '4757' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
148	0.00044	SELECT filter_id FROM oc_product_filter WHERE product_id = '4757'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
149	0.00063	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4757')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
150	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 = '4758' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
151	0.00027	SELECT filter_id FROM oc_product_filter WHERE product_id = '4758'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
152	0.00041	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4758')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
153	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 = '4759' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
154	0.00026	SELECT filter_id FROM oc_product_filter WHERE product_id = '4759'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
155	0.00041	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4759')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
156	0.00035	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 = '4760' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
157	0.00029	SELECT filter_id FROM oc_product_filter WHERE product_id = '4760'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
158	0.00055	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4760')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
159	0.00069	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '4761' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
160	0.00031	SELECT filter_id FROM oc_product_filter WHERE product_id = '4761'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
161	0.00051	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4761')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
162	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 = '4762' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
163	0.00029	SELECT filter_id FROM oc_product_filter WHERE product_id = '4762'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
164	0.00041	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14', 'product_id=4762')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
165	0.00015	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
166	0.00021	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
167	0.00021	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
168	0.0002	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
169	0.00019	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
170	0.00017	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
171	0.00019	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
172	0.00023	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
173	0.0002	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
174	0.00015	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
175	0.00017	SELECT * FROM oc_category_to_layout WHERE category_id = '14' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
176	0.00017	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
177	0.00023	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
178	0.00014	SELECT * FROM oc_category_to_layout WHERE category_id = '14' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
179	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
180	0.00022	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
181	0.03159	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 = 14 AND p.price <> '999999.0000' AND p.status = '1'	/home/ttncomua/public_html/catalog/controller/module/priceslider.php	index
182	0.00024	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
183	0.00014	SELECT category_id FROM oc_category WHERE parent_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoriesByParentId
184	0.03226	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 (14) 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
185	0.00024	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
186	0.00031	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
187	0.00021	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
188	0.00016	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
189	0.00017	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 = '14' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategory
190	0.00016	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
191	0.00021	SELECT filter_id FROM oc_category_filter WHERE category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
192	0.00018	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
193	0.00018	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
194	0.00017	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
195	0.00018	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
196	0.00014	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
197	0.00016	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
198	0.00015	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
199	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 (196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,281,292,328,330,331,390,391,392,393,394,395,396,411,412,738,739,870,1073,1148,1149,1274) 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
200	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 (1274,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 (1274,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
201	0.00102	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1274 ON (p2c.product_id = pf1274.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 pf1274.filter_id = 1274 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
202	0.00052	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 (392,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 (392,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
203	0.00222	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf392 ON (p2c.product_id = pf392.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 pf392.filter_id = 392 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
204	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 (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
205	0.00144	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
206	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 (391,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 (391,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
207	0.0019	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf391 ON (p2c.product_id = pf391.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 pf391.filter_id = 391 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
208	0.0003	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 (196,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 (196,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
209	0.00313	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf196 ON (p2c.product_id = pf196.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 pf196.filter_id = 196 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
210	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 (396,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 (396,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
211	0.00221	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf396 ON (p2c.product_id = pf396.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 pf396.filter_id = 396 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
212	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 (395,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 (395,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
213	0.00296	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf395 ON (p2c.product_id = pf395.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 pf395.filter_id = 395 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
214	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 (203,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 (203,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
215	0.00688	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf203 ON (p2c.product_id = pf203.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 pf203.filter_id = 203 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
216	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
217	0.00145	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
218	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 (212,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 (212,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
219	0.00509	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf212 ON (p2c.product_id = pf212.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 pf212.filter_id = 212 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
220	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 (393,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 (393,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
221	0.00488	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf393 ON (p2c.product_id = pf393.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 pf393.filter_id = 393 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
222	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 (207,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 (207,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
223	0.00238	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf207 ON (p2c.product_id = pf207.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 pf207.filter_id = 207 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
224	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 (411,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 (411,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
225	0.0016	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf411 ON (p2c.product_id = pf411.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 pf411.filter_id = 411 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
226	0.0006	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
227	0.00924	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
228	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 (281,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 (281,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
229	0.00734	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf281 ON (p2c.product_id = pf281.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 pf281.filter_id = 281 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
230	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 (412,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 (412,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
231	0.00175	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf412 ON (p2c.product_id = pf412.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 pf412.filter_id = 412 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
232	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 (390,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 (390,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
233	0.00128	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf390 ON (p2c.product_id = pf390.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 pf390.filter_id = 390 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
234	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 (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
235	0.00503	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
236	0.00026	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
237	0.00311	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
238	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 (394,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 (394,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
239	0.00545	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf394 ON (p2c.product_id = pf394.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 pf394.filter_id = 394 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
240	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 (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
241	0.00705	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
242	0.00018	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (214,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 (214,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
243	0.00121	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf214 ON (p2c.product_id = pf214.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 pf214.filter_id = 214 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
244	0.00026	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
245	0.00422	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
246	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 (211,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 (211,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
247	0.00337	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf211 ON (p2c.product_id = pf211.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 pf211.filter_id = 211 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
248	0.00034	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
249	0.00722	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
250	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 (1148,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 (1148,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
251	0.0007	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1148 ON (p2c.product_id = pf1148.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 pf1148.filter_id = 1148 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
252	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 (205,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 (205,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
253	0.00412	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf205 ON (p2c.product_id = pf205.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 pf205.filter_id = 205 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
254	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 (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
255	0.00383	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
256	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 (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
257	0.0034	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
258	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
259	0.00167	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
260	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 (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
261	0.00235	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
262	0.00031	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
263	0.00599	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
264	0.00029	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
265	0.00505	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
266	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 (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
267	0.00643	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
268	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 (200,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 (200,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
269	0.00275	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf200 ON (p2c.product_id = pf200.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 pf200.filter_id = 200 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
270	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 (201,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 (201,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
271	0.00243	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf201 ON (p2c.product_id = pf201.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 pf201.filter_id = 201 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
272	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 (202,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 (202,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
273	0.00247	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf202 ON (p2c.product_id = pf202.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 pf202.filter_id = 202 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
274	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 (292,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 (292,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
275	0.0019	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf292 ON (p2c.product_id = pf292.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 pf292.filter_id = 292 AND p2c.category_id = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
276	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 (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
277	0.00113	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 = '14'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
278	0.00025	SELECT * FROM oc_category_to_layout WHERE category_id = '14' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
279	0.00023	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
280	0.00031	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
281	0.00025	SELECT * FROM oc_category_to_layout WHERE category_id = '14' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
282	0.00024	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1	/home/ttncomua/public_html/catalog/model/design/layout.php	getLayout
283	0.00023	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
284	0.00026	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
285	0.00095	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
286	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
287	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
288	0.00028	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
289	0.00021	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
290	0.00029	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
291	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=5')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
292	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
293	0.00067	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
294	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
295	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
296	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
297	0.00031	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
298	0.00025	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
299	0.0003	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
300	0.00021	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
301	0.00027	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
302	0.00027	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
303	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
304	0.00036	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
305	0.00024	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
306	0.00024	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
307	0.00022	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
308	0.00021	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
309	0.00024	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
310	0.00025	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
311	0.00023	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
312	0.00028	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
313	0.00024	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
314	0.00104	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
315	0.00027	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
316	0.00027	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
317	0.00022	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
318	0.00022	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
319	0.00022	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
320	0.00018	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
321	0.00026	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '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
322	0.00018	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
323	0.00019	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
324	0.00018	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
325	0.00015	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
326	0.00019	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
327	0.00017	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
328	0.00016	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
329	0.00026	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '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
330	0.00017	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
331	0.0002	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
332	0.00018	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
333	0.00026	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
334	0.00023	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
335	0.0002	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
336	0.00025	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
337	0.00021	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
338	0.00021	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
339	0.00021	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
340	0.00023	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
341	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
342	0.00023	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
343	0.00021	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
344	0.00025	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
345	0.0003	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
346	0.0003	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '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
347	0.00021	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
348	0.00021	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
349	0.00021	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
350	0.00021	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
351	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
352	0.0002	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
353	0.00016	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
354	0.00019	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
355	0.00017	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
356	0.00017	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
357	0.00019	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
358	0.00016	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
359	0.00017	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
360	0.00017	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
361	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
362	0.0002	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
363	0.00016	SELECT * FROM oc_category_to_layout WHERE category_id = '14' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
364	0.00016	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
365	0.0002	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
366	0.00037	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
367	0.00031	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
368	0.00024	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions