Электротехническая производственная компания 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(54) "boksy-shkafy-i-vse-dlya-sborki/vse-dlya-sborki-schitov"
}

POST

array(0) {
}

COOKIE

array(0) {
}

SERVER

array(44) {
  ["PHPRC"]=>
  string(22) "/usr/local/lib/php.ini"
  ["PATH"]=>
  string(180) "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin"
  ["PWD"]=>
  string(25) "/usr/local/cpanel/cgi-sys"
  ["TZ"]=>
  string(11) "Europe/Kiev"
  ["SHLVL"]=>
  string(1) "0"
  ["FCGI_ROLE"]=>
  string(9) "RESPONDER"
  ["REDIRECT_UNIQUE_ID"]=>
  string(24) "WynONsIcVBsAB7qv@joAAAAE"
  ["REDIRECT_SCRIPT_URL"]=>
  string(55) "/boksy-shkafy-i-vse-dlya-sborki/vse-dlya-sborki-schitov"
  ["REDIRECT_SCRIPT_URI"]=>
  string(73) "https://380.com.ua/boksy-shkafy-i-vse-dlya-sborki/vse-dlya-sborki-schitov"
  ["REDIRECT_HTTPS"]=>
  string(2) "on"
  ["REDIRECT_STATUS"]=>
  string(3) "200"
  ["UNIQUE_ID"]=>
  string(24) "WynONsIcVBsAB7qv@joAAAAE"
  ["SCRIPT_URL"]=>
  string(55) "/boksy-shkafy-i-vse-dlya-sborki/vse-dlya-sborki-schitov"
  ["SCRIPT_URI"]=>
  string(73) "https://380.com.ua/boksy-shkafy-i-vse-dlya-sborki/vse-dlya-sborki-schitov"
  ["HTTPS"]=>
  string(2) "on"
  ["HTTP_HOST"]=>
  string(10) "380.com.ua"
  ["HTTP_X_REAL_IP"]=>
  string(14) "54.162.224.176"
  ["HTTP_X_FORWARDED_FOR"]=>
  string(14) "54.162.224.176"
  ["HTTP_X_FORWARDED_PROTO"]=>
  string(5) "https"
  ["HTTP_CONNECTION"]=>
  string(5) "close"
  ["HTTP_ACCEPT_ENCODING"]=>
  string(21) "x-gzip, gzip, deflate"
  ["HTTP_USER_AGENT"]=>
  string(39) "CCBot/2.0 (http://commoncrawl.org/faq/)"
  ["HTTP_ACCEPT"]=>
  string(63) "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8"
  ["HTTP_X_HTTPS"]=>
  string(1) "1"
  ["SERVER_SIGNATURE"]=>
  string(0) ""
  ["SERVER_SOFTWARE"]=>
  string(6) "Apache"
  ["SERVER_NAME"]=>
  string(10) "380.com.ua"
  ["SERVER_ADDR"]=>
  string(12) "194.28.84.27"
  ["SERVER_PORT"]=>
  string(3) "443"
  ["REMOTE_ADDR"]=>
  string(14) "54.162.224.176"
  ["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) "37701"
  ["REDIRECT_QUERY_STRING"]=>
  string(62) "_route_=boksy-shkafy-i-vse-dlya-sborki/vse-dlya-sborki-schitov"
  ["REDIRECT_URL"]=>
  string(55) "/boksy-shkafy-i-vse-dlya-sborki/vse-dlya-sborki-schitov"
  ["GATEWAY_INTERFACE"]=>
  string(7) "CGI/1.1"
  ["SERVER_PROTOCOL"]=>
  string(8) "HTTP/1.1"
  ["REQUEST_METHOD"]=>
  string(3) "GET"
  ["QUERY_STRING"]=>
  string(62) "_route_=boksy-shkafy-i-vse-dlya-sborki/vse-dlya-sborki-schitov"
  ["REQUEST_URI"]=>
  string(55) "/boksy-shkafy-i-vse-dlya-sborki/vse-dlya-sborki-schitov"
  ["SCRIPT_NAME"]=>
  string(10) "/index.php"
  ["PHP_SELF"]=>
  string(10) "/index.php"
  ["REQUEST_TIME"]=>
  string(10) "1529466422"
}

SESSION

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

FILES

array(0) {
}

REQUEST

array(1) {
  ["_route_"]=>
  string(54) "boksy-shkafy-i-vse-dlya-sborki/vse-dlya-sborki-schitov"
}

#	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.00023	SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://380.com.ua/'	/home/ttncomua/public_html/index.php	Array
2	0.00089	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.00027	SELECT * FROM `oc_language` WHERE status = '1'	/home/ttncomua/public_html/index.php	Array
4	0.00028	SELECT * FROM oc_currency	/home/ttncomua/public_html/system/library/currency.php	__construct
5	0.00021	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.00026	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.00105	SELECT SUBSTRING_INDEX(query,'=',1) AS name, CONVERT(SUBSTRING_INDEX(query,'=',-1),UNSIGNED INTEGER) AS value FROM oc_url_alias WHERE keyword IN('boksy-shkafy-i-vse-dlya-sborki','vse-dlya-sborki-schitov') ORDER BY FIND_IN_SET(keyword, 'boksy-shkafy-i-vse-dlya-sborki,vse-dlya-sborki-schitov')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	index
8	0.00028	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 = '64' 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.00024	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
10	0.00027	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 = '65' 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.00028	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
12	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 = '65' 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.00067	SELECT filter_id FROM oc_category_filter WHERE category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
14	0.00384	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) 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.0054	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
16	0.00426	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '9' 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.00628	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) 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
18	0.00484	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) 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
19	0.00518	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) 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
20	0.00432	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '37' 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.0062	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '17' 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.0041	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '6' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
23	0.00435	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '7' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
24	0.00452	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '27' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
25	0.05468	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts
26	0.1287	SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '65' GROUP BY p.product_id ORDER BY (p.image !='') DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,23	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProducts
27	0.00164	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13252' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
28	0.0013	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13934' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
29	0.00137	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13940' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
30	0.00135	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13937' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
31	0.00129	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13938' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
32	0.0013	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13939' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
33	0.00131	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13204' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
34	0.00124	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13194' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
35	0.00128	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13205' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
36	0.0012	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13313' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
37	0.00115	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13298' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
38	0.00116	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13299' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
39	0.00116	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13300' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
40	0.00115	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '5957' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
41	0.00117	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '5931' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
42	0.00114	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '5962' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
43	0.00116	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '9147' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
44	0.00114	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '9148' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
45	0.00114	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '9149' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
46	0.00114	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '9150' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
47	0.00116	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '16464' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
48	0.00114	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '16466' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
49	0.00114	SELECT DISTINCT , pd.name AS name, p.image, m.image AS m_image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '16467' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
50	0.00099	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 = '13252' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
51	0.00047	SELECT filter_id FROM oc_product_filter WHERE product_id = '13252'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
52	0.0009	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13252')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
53	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 = '13934' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
54	0.00058	SELECT filter_id FROM oc_product_filter WHERE product_id = '13934'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
55	0.00105	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (281,412,688,1404) 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
56	0.0008	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (281,412,688,1404) 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
57	0.00077	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (281,412,688,1404) 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
58	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 (281,412,688,1404) 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
59	0.00123	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13934')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
60	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 = '13940' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
61	0.00047	SELECT filter_id FROM oc_product_filter WHERE product_id = '13940'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
62	0.00041	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,412,688,1404) 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
63	0.00028	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,412,688,1404) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
64	0.00027	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,412,688,1404) 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
65	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 (281,412,688,1404) 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
66	0.00064	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13940')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
67	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 = '13937' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
68	0.00046	SELECT filter_id FROM oc_product_filter WHERE product_id = '13937'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
69	0.00044	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (281,412,688,1404) AND fgd.language_id = '2' GROUP BY f.filter_group_id ORDER BY fg.sort_order, LCASE(fgd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
70	0.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 (281,412,688,1404) 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
71	0.00024	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,412,688,1404) 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
72	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 (281,412,688,1404) AND f.filter_group_id = '4' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
73	0.00062	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13937')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
74	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 = '13938' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
75	0.00045	SELECT filter_id FROM oc_product_filter WHERE product_id = '13938'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
76	0.00036	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,412,688,1404) 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
77	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 (281,412,688,1404) 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
78	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 (281,412,688,1404) 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
79	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 (281,412,688,1404) 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
80	0.00063	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13938')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
81	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 = '13939' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
82	0.00044	SELECT filter_id FROM oc_product_filter WHERE product_id = '13939'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
83	0.00041	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,412,688,1404) 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
84	0.0003	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,412,688,1404) 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
85	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 (281,412,688,1404) 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
86	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 (281,412,688,1404) 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
87	0.0006	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13939')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
88	0.00056	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '13204' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
89	0.00044	SELECT filter_id FROM oc_product_filter WHERE product_id = '13204'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
90	0.00069	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13204')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
91	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 = '13194' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
92	0.00043	SELECT filter_id FROM oc_product_filter WHERE product_id = '13194'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
93	0.00062	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13194')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
94	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 = '13205' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
95	0.0004	SELECT filter_id FROM oc_product_filter WHERE product_id = '13205'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
96	0.00064	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13205')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
97	0.0014	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 = '13313' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
98	0.00049	SELECT filter_id FROM oc_product_filter WHERE product_id = '13313'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
99	0.00062	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13313')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
100	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 = '13298' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
101	0.00049	SELECT filter_id FROM oc_product_filter WHERE product_id = '13298'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
102	0.00064	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13298')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
103	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 = '13299' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
104	0.00041	SELECT filter_id FROM oc_product_filter WHERE product_id = '13299'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
105	0.00065	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13299')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
106	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 = '13300' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
107	0.00042	SELECT filter_id FROM oc_product_filter WHERE product_id = '13300'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
108	0.00055	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=13300')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
109	0.00104	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 = '5957' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
110	0.00044	SELECT filter_id FROM oc_product_filter WHERE product_id = '5957'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
111	0.00103	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,402) 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
112	0.00141	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (281,402) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
113	0.00088	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,402) 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
114	0.00064	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=5957')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
115	0.00053	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '5931' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
116	0.0004	SELECT filter_id FROM oc_product_filter WHERE product_id = '5931'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
117	0.00031	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,402) 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
118	0.00032	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,402) 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
119	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 (281,402) 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
120	0.0014	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=5931')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
121	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 = '5962' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
122	0.0008	SELECT filter_id FROM oc_product_filter WHERE product_id = '5962'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
123	0.00025	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (281,402) 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
124	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 (281,402) 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
125	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 (281,402) 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
126	0.00082	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=5962')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
127	0.00046	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '9147' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
128	0.00033	SELECT filter_id FROM oc_product_filter WHERE product_id = '9147'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
129	0.00068	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=9147')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
130	0.00099	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 = '9148' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
131	0.00092	SELECT filter_id FROM oc_product_filter WHERE product_id = '9148'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
132	0.00073	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=9148')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
133	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 = '9149' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
134	0.00034	SELECT filter_id FROM oc_product_filter WHERE product_id = '9149'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
135	0.00061	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=9149')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
136	0.0005	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '9150' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
137	0.00043	SELECT filter_id FROM oc_product_filter WHERE product_id = '9150'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
138	0.00066	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=9150')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
139	0.0005	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '16464' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
140	0.00049	SELECT filter_id FROM oc_product_filter WHERE product_id = '16464'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
141	0.00081	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 (776,1407) 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
142	0.00059	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (776,1407) 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
143	0.00054	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=16464')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
144	0.00047	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '16466' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
145	0.00056	SELECT filter_id FROM oc_product_filter WHERE product_id = '16466'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
146	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 (776,1407) 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
147	0.00021	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (776,1407) 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
148	0.00068	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=16466')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
149	0.00075	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 = '16467' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
150	0.00093	SELECT filter_id FROM oc_product_filter WHERE product_id = '16467'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
151	0.00061	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65', 'product_id=16467')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
152	0.00024	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
153	0.00024	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
154	0.00021	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
155	0.00024	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
156	0.00019	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
157	0.0002	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
158	0.00026	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
159	0.00068	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
160	0.00028	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
161	0.00117	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
162	0.00055	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
163	0.00034	SELECT * FROM oc_category_to_layout WHERE category_id = '65' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
164	0.00035	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
165	0.00031	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
166	0.0002	SELECT * FROM oc_category_to_layout WHERE category_id = '65' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
167	0.0002	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
168	0.00025	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
169	0.03722	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 = 65 AND p.price <> '999999.0000' AND p.status = '1'	/home/ttncomua/public_html/catalog/controller/module/priceslider.php	index
170	0.00029	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
171	0.00072	SELECT category_id FROM oc_category WHERE parent_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoriesByParentId
172	0.04093	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 (65) 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
173	0.00068	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
174	0.00016	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
175	0.00016	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
176	0.00018	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
177	0.00015	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
178	0.00042	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
179	0.00045	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
180	0.00029	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
181	0.0003	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 = '65' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategory
182	0.00023	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
183	0.0004	SELECT filter_id FROM oc_category_filter WHERE category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
184	0.00036	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) 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
185	0.00026	SELECT DISTINCT f.filter_id, fd.name, fd.img FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '1' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
186	0.0002	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '9' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
187	0.00028	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) 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
188	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) 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
189	0.00034	SELECT DISTINCT f.filter_id, fd.name, fd.img FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) 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
190	0.00031	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '37' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
191	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '17' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
192	0.00029	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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '6' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
193	0.00025	SELECT DISTINCT f.filter_id, fd.name, fd.img FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '7' 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.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 (23,129,145,147,215,234,248,272,274,281,315,316,317,318,320,321,322,323,324,325,326,328,334,342,402,403,404,405,406,407,412,425,474,491,554,558,588,589,590,614,686,688,710,712,717,718,719,776,777,809,813,814,831,832,836,845,903,906,909,913,921,1205,1208,1209,1292,1336,1376,1404,1407,1408,1425,1438,1440) AND f.filter_group_id = '27' 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.00248	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 (1208,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 (1208,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
196	0.00137	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1208 ON (p2c.product_id = pf1208.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 pf1208.filter_id = 1208 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
197	0.00138	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 (1205,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 (1205,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
198	0.00217	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1205 ON (p2c.product_id = pf1205.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 pf1205.filter_id = 1205 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
199	0.00174	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 (1209,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 (1209,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
200	0.00199	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1209 ON (p2c.product_id = pf1209.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 pf1209.filter_id = 1209 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
201	0.00257	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 (322,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 (322,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
202	0.0019	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf322 ON (p2c.product_id = pf322.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 pf322.filter_id = 322 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
203	0.00209	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 (1292,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 (1292,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
204	0.00215	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1292 ON (p2c.product_id = pf1292.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 pf1292.filter_id = 1292 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
205	0.00037	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 (717,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 (717,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
206	0.0028	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf717 ON (p2c.product_id = pf717.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 pf717.filter_id = 717 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
207	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 (710,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 (710,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
208	0.00243	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf710 ON (p2c.product_id = pf710.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 pf710.filter_id = 710 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
209	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 (712,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 (712,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
210	0.00153	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf712 ON (p2c.product_id = pf712.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 pf712.filter_id = 712 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
211	0.00179	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 (1336,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 (1336,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
212	0.00418	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1336 ON (p2c.product_id = pf1336.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 pf1336.filter_id = 1336 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
213	0.00182	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 (588,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 (588,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
214	0.00334	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf588 ON (p2c.product_id = pf588.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 pf588.filter_id = 588 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
215	0.00136	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (590,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 (590,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
216	0.00125	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf590 ON (p2c.product_id = pf590.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 pf590.filter_id = 590 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
217	0.00143	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 (589,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 (589,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
218	0.00159	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf589 ON (p2c.product_id = pf589.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 pf589.filter_id = 589 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
219	0.00145	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 (1438,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 (1438,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
220	0.00149	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1438 ON (p2c.product_id = pf1438.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 pf1438.filter_id = 1438 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
221	0.00165	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 (1440,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 (1440,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
222	0.00258	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1440 ON (p2c.product_id = pf1440.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 pf1440.filter_id = 1440 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
223	0.00142	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 (1376,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 (1376,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
224	0.00131	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1376 ON (p2c.product_id = pf1376.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 pf1376.filter_id = 1376 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
225	0.00311	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 (554,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 (554,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
226	0.00609	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf554 ON (p2c.product_id = pf554.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 pf554.filter_id = 554 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
227	0.00035	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 (1404,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 (1404,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
228	0.00191	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1404 ON (p2c.product_id = pf1404.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 pf1404.filter_id = 1404 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
229	0.00205	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 (402,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 (402,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
230	0.00256	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf402 ON (p2c.product_id = pf402.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 pf402.filter_id = 402 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
231	0.00188	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 (403,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 (403,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
232	0.0022	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf403 ON (p2c.product_id = pf403.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 pf403.filter_id = 403 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
233	0.00126	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 (404,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 (404,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
234	0.00104	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf404 ON (p2c.product_id = pf404.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 pf404.filter_id = 404 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
235	0.00141	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 (405,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 (405,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
236	0.002	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf405 ON (p2c.product_id = pf405.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 pf405.filter_id = 405 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
237	0.00044	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (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
238	0.0026	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 = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
239	0.00058	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 (215,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 (215,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
240	0.00469	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf215 ON (p2c.product_id = pf215.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 pf215.filter_id = 215 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
241	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 (334,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 (334,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
242	0.00158	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf334 ON (p2c.product_id = pf334.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 pf334.filter_id = 334 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
243	0.00126	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 (474,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 (474,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
244	0.00191	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf474 ON (p2c.product_id = pf474.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 pf474.filter_id = 474 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
245	0.00213	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 (320,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 (320,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
246	0.00391	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf320 ON (p2c.product_id = pf320.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 pf320.filter_id = 320 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
247	0.00146	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 (342,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 (342,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
248	0.00381	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf342 ON (p2c.product_id = pf342.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 pf342.filter_id = 342 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
249	0.00261	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 (1408,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 (1408,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
250	0.00329	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1408 ON (p2c.product_id = pf1408.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 pf1408.filter_id = 1408 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
251	0.0021	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 (147,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 (147,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
252	0.00356	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf147 ON (p2c.product_id = pf147.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 pf147.filter_id = 147 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
253	0.00132	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (491,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 (491,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
254	0.00146	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf491 ON (p2c.product_id = pf491.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 pf491.filter_id = 491 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
255	0.00255	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (129,0) GROUP BY product_id , filter_group_id) as i, (select count(distinct filter_group_id) as filter_group from oc_filter_description f_b WHERE f_b.filter_id in (129,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
256	0.00281	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf129 ON (p2c.product_id = pf129.product_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pf129.filter_id = 129 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
257	0.00275	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 (1407,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 (1407,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
258	0.00285	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1407 ON (p2c.product_id = pf1407.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 pf1407.filter_id = 1407 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
259	0.00126	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 (1425,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 (1425,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
260	0.00245	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1425 ON (p2c.product_id = pf1425.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 pf1425.filter_id = 1425 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
261	0.00124	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 (406,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 (406,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
262	0.00168	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf406 ON (p2c.product_id = pf406.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 pf406.filter_id = 406 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
263	0.00143	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 (558,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 (558,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
264	0.00216	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf558 ON (p2c.product_id = pf558.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 pf558.filter_id = 558 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
265	0.00098	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (407,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 (407,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
266	0.00098	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf407 ON (p2c.product_id = pf407.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 pf407.filter_id = 407 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
267	0.00107	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (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
268	0.0085	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 = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
269	0.00103	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 (845,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 (845,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
270	0.00082	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf845 ON (p2c.product_id = pf845.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 pf845.filter_id = 845 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
271	0.00097	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (809,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 (809,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
272	0.00108	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf809 ON (p2c.product_id = pf809.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 pf809.filter_id = 809 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
273	0.00095	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (324,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 (324,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
274	0.00095	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf324 ON (p2c.product_id = pf324.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 pf324.filter_id = 324 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
275	0.00101	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (323,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 (323,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
276	0.00096	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf323 ON (p2c.product_id = pf323.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 pf323.filter_id = 323 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
277	0.00104	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 (325,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 (325,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
278	0.00129	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf325 ON (p2c.product_id = pf325.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 pf325.filter_id = 325 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
279	0.00094	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (326,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 (326,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
280	0.00072	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf326 ON (p2c.product_id = pf326.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 pf326.filter_id = 326 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
281	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 (234,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 (234,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
282	0.00169	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf234 ON (p2c.product_id = pf234.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 pf234.filter_id = 234 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
283	0.00145	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
284	0.00162	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 = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
285	0.00098	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (718,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 (718,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
286	0.00108	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf718 ON (p2c.product_id = pf718.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 pf718.filter_id = 718 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
287	0.00207	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 (903,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 (903,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
288	0.00229	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf903 ON (p2c.product_id = pf903.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 pf903.filter_id = 903 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
289	0.00119	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 (921,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 (921,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
290	0.00092	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf921 ON (p2c.product_id = pf921.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 pf921.filter_id = 921 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
291	0.00448	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 (906,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 (906,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
292	0.00937	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf906 ON (p2c.product_id = pf906.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 pf906.filter_id = 906 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
293	0.00118	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 (909,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 (909,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
294	0.00141	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf909 ON (p2c.product_id = pf909.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 pf909.filter_id = 909 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
295	0.00117	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 (813,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 (813,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
296	0.00136	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf813 ON (p2c.product_id = pf813.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 pf813.filter_id = 813 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
297	0.00087	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (145,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 (145,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
298	0.01102	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf145 ON (p2c.product_id = pf145.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 pf145.filter_id = 145 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
299	0.00039	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 (315,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 (315,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
300	0.00326	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf315 ON (p2c.product_id = pf315.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 pf315.filter_id = 315 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
301	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 (316,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 (316,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
302	0.0035	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf316 ON (p2c.product_id = pf316.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 pf316.filter_id = 316 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
303	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 (317,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 (317,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
304	0.00381	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf317 ON (p2c.product_id = pf317.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 pf317.filter_id = 317 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
305	0.0021	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 (719,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 (719,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
306	0.00135	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf719 ON (p2c.product_id = pf719.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 pf719.filter_id = 719 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
307	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 (318,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 (318,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
308	0.00217	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf318 ON (p2c.product_id = pf318.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 pf318.filter_id = 318 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
309	0.0011	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (814,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 (814,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
310	0.00078	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf814 ON (p2c.product_id = pf814.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 pf814.filter_id = 814 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
311	0.00073	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 (23,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 (23,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
312	0.00382	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf23 ON (p2c.product_id = pf23.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 pf23.filter_id = 23 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
313	0.00492	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 (248,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 (248,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
314	0.00744	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf248 ON (p2c.product_id = pf248.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 pf248.filter_id = 248 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
315	0.0077	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 (272,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 (272,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
316	0.00407	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf272 ON (p2c.product_id = pf272.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 pf272.filter_id = 272 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
317	0.00155	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 (614,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 (614,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
318	0.00116	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf614 ON (p2c.product_id = pf614.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 pf614.filter_id = 614 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
319	0.00177	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 (274,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 (274,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
320	0.00147	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf274 ON (p2c.product_id = pf274.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 pf274.filter_id = 274 AND p2c.category_id = '65'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
321	0.00019	SELECT * FROM oc_category_to_layout WHERE category_id = '65' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
322	0.00021	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
323	0.00034	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
324	0.00025	SELECT * FROM oc_category_to_layout WHERE category_id = '65' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
325	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
326	0.0004	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
327	0.00023	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
328	0.00153	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
329	0.00021	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
330	0.00028	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
331	0.00031	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
332	0.00026	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
333	0.00029	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
334	0.00035	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=5')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
335	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
336	0.0008	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
337	0.00046	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
338	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
339	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
340	0.00034	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '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
341	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 = '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
342	0.00027	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
343	0.00025	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
344	0.00024	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
345	0.00026	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
346	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
347	0.00043	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
348	0.00027	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
349	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
350	0.00024	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
351	0.00019	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
352	0.0002	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
353	0.00023	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
354	0.00027	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=44')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
355	0.00027	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
356	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
357	0.00019	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
358	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=48')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
359	0.00022	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
360	0.00028	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
361	0.00024	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
362	0.00019	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
363	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
364	0.00033	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '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
365	0.00025	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
366	0.00024	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
367	0.00024	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
368	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=28')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
369	0.00024	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
370	0.00024	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
371	0.00026	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
372	0.0004	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '49' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order DESC, LCASE(cd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategories
373	0.00028	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
374	0.00021	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=68')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
375	0.00026	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
376	0.00022	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
377	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
378	0.00024	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
379	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=60')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
380	0.00023	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
381	0.00025	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
382	0.00029	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
383	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
384	0.00024	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
385	0.00019	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
386	0.00024	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
387	0.00024	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
388	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
389	0.00044	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '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
390	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
391	0.00022	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
392	0.00023	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
393	0.00025	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
394	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
395	0.00025	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
396	0.00019	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
397	0.00025	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
398	0.00027	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
399	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
400	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 = '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
401	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=67')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
402	0.00022	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
403	0.00025	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
404	0.00026	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
405	0.00026	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
406	0.00025	SELECT * FROM oc_category_to_layout WHERE category_id = '65' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
407	0.00025	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
408	0.00032	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
409	0.00032	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
410	0.00036	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
411	0.00027	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions