Электротехническая производственная компания 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(18) "svetotehnika/lampy"
}

POST

array(0) {
}

COOKIE

array(0) {
}

SERVER

array(45) {
  ["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) "WwXUycIcVBsALijo4aoAAAAL"
  ["REDIRECT_SCRIPT_URL"]=>
  string(19) "/svetotehnika/lampy"
  ["REDIRECT_SCRIPT_URI"]=>
  string(37) "https://380.com.ua/svetotehnika/lampy"
  ["REDIRECT_HTTPS"]=>
  string(2) "on"
  ["REDIRECT_STATUS"]=>
  string(3) "200"
  ["UNIQUE_ID"]=>
  string(24) "WwXUycIcVBsALijo4aoAAAAL"
  ["SCRIPT_URL"]=>
  string(19) "/svetotehnika/lampy"
  ["SCRIPT_URI"]=>
  string(37) "https://380.com.ua/svetotehnika/lampy"
  ["HTTPS"]=>
  string(2) "on"
  ["HTTP_HOST"]=>
  string(10) "380.com.ua"
  ["HTTP_X_REAL_IP"]=>
  string(13) "54.156.76.187"
  ["HTTP_X_FORWARDED_FOR"]=>
  string(13) "54.156.76.187"
  ["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_IF_MODIFIED_SINCE"]=>
  string(29) "Thu, 22 Mar 2018 13:34:20 GMT"
  ["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(13) "54.156.76.187"
  ["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) "35765"
  ["REDIRECT_QUERY_STRING"]=>
  string(26) "_route_=svetotehnika/lampy"
  ["REDIRECT_URL"]=>
  string(19) "/svetotehnika/lampy"
  ["GATEWAY_INTERFACE"]=>
  string(7) "CGI/1.1"
  ["SERVER_PROTOCOL"]=>
  string(8) "HTTP/1.1"
  ["REQUEST_METHOD"]=>
  string(3) "GET"
  ["QUERY_STRING"]=>
  string(26) "_route_=svetotehnika/lampy"
  ["REQUEST_URI"]=>
  string(19) "/svetotehnika/lampy"
  ["SCRIPT_NAME"]=>
  string(10) "/index.php"
  ["PHP_SELF"]=>
  string(10) "/index.php"
  ["REQUEST_TIME"]=>
  string(10) "1527108809"
}

SESSION

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

FILES

array(0) {
}

REQUEST

array(1) {
  ["_route_"]=>
  string(18) "svetotehnika/lampy"
}

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

#	Time	Query	File	Function
1	0.00024	SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://380.com.ua/'	/home/ttncomua/public_html/index.php	Array
2	0.00109	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.00022	SELECT * FROM `oc_language` WHERE status = '1'	/home/ttncomua/public_html/index.php	Array
4	0.00022	SELECT * FROM oc_currency	/home/ttncomua/public_html/system/library/currency.php	__construct
5	0.00023	SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '2'	/home/ttncomua/public_html/system/library/weight.php	__construct
6	0.0002	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.00088	SELECT SUBSTRING_INDEX(query,'=',1) AS name, CONVERT(SUBSTRING_INDEX(query,'=',-1),UNSIGNED INTEGER) AS value FROM oc_url_alias WHERE keyword IN('svetotehnika','lampy') ORDER BY FIND_IN_SET(keyword, 'svetotehnika,lampy')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	index
8	0.00022	SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '20' 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.00019	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
10	0.00021	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 = '22' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategory
11	0.00021	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
12	0.00046	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 = '22' 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.00187	SELECT filter_id FROM oc_category_filter WHERE category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
14	0.00291	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 (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) 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.00319	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 (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) 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.00262	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 (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) AND f.filter_group_id = '5' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
17	0.00253	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 (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) AND f.filter_group_id = '4' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
18	0.00366	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 (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) AND f.filter_group_id = '14' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
19	0.003	SELECT DISTINCT f.filter_id, fd.name, fd.img FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) AND f.filter_group_id = '13' 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.00253	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 (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) AND f.filter_group_id = '34' 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.00077	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '1446' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
22	0.00059	SELECT filter_id FROM oc_product_filter WHERE product_id = '1446'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
23	0.0005	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 (94) 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
24	0.00044	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 (94) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
25	0.00055	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=1446')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
26	0.00054	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '1447' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
27	0.00061	SELECT filter_id FROM oc_product_filter WHERE product_id = '1447'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
28	0.00015	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (94) 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
29	0.00017	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (94) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
30	0.00055	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=1447')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
31	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 = '1448' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
32	0.00041	SELECT filter_id FROM oc_product_filter WHERE product_id = '1448'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
33	0.00014	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (94) 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
34	0.00017	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (94) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
35	0.00074	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=1448')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
36	0.00094	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '1449' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
37	0.0004	SELECT filter_id FROM oc_product_filter WHERE product_id = '1449'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
38	0.00022	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (94) 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
39	0.00018	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (94) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
40	0.00057	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=1449')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
41	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 = '1450' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
42	0.00049	SELECT filter_id FROM oc_product_filter WHERE product_id = '1450'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
43	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 (94) 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
44	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 (94) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
45	0.00062	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=1450')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
46	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 = '1451' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
47	0.00054	SELECT filter_id FROM oc_product_filter WHERE product_id = '1451'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
48	0.00016	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 (94) 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
49	0.00015	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (94) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
50	0.00061	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=1451')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
51	0.00087	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '816' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
52	0.00073	SELECT filter_id FROM oc_product_filter WHERE product_id = '816'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
53	0.00069	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=816')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
54	0.00073	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '817' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
55	0.00049	SELECT filter_id FROM oc_product_filter WHERE product_id = '817'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
56	0.00066	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=817')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
57	0.00061	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 = '818' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
58	0.00065	SELECT filter_id FROM oc_product_filter WHERE product_id = '818'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
59	0.00059	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=818')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
60	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 = '820' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
61	0.00044	SELECT filter_id FROM oc_product_filter WHERE product_id = '820'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
62	0.00099	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 (94,96) 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.00073	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (94,96) AND f.filter_group_id = '14' 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.00104	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (94,96) AND f.filter_group_id = '13' 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.00127	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=820')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
66	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 = '806' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
67	0.0006	SELECT filter_id FROM oc_product_filter WHERE product_id = '806'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
68	0.00056	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=806')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
69	0.0004	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '804' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
70	0.00027	SELECT filter_id FROM oc_product_filter WHERE product_id = '804'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
71	0.0004	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=804')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
72	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 = '805' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
73	0.00071	SELECT filter_id FROM oc_product_filter WHERE product_id = '805'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
74	0.00056	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=805')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
75	0.00076	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '807' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
76	0.00031	SELECT filter_id FROM oc_product_filter WHERE product_id = '807'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
77	0.00044	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=807')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
78	0.0004	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '808' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
79	0.00027	SELECT filter_id FROM oc_product_filter WHERE product_id = '808'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
80	0.00042	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=808')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
81	0.0004	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '811' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
82	0.00029	SELECT filter_id FROM oc_product_filter WHERE product_id = '811'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
83	0.00043	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=811')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
84	0.00042	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '812' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
85	0.00036	SELECT filter_id FROM oc_product_filter WHERE product_id = '812'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
86	0.00053	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=812')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
87	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 = '826' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
88	0.00037	SELECT filter_id FROM oc_product_filter WHERE product_id = '826'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
89	0.00066	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (102,103) 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
90	0.00054	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (102,103) AND f.filter_group_id = '14' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
91	0.00049	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 (102,103) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
92	0.00045	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=826')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
93	0.00079	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '827' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
94	0.00034	SELECT filter_id FROM oc_product_filter WHERE product_id = '827'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
95	0.00049	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 (102,103) 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
96	0.00014	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (102,103) AND f.filter_group_id = '14' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
97	0.00014	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (102,103) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
98	0.00047	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=827')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
99	0.00042	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '830' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
100	0.00046	SELECT filter_id FROM oc_product_filter WHERE product_id = '830'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
101	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 (103,105) 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
102	0.00053	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (103,105) AND f.filter_group_id = '14' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
103	0.00053	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (103,105) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
104	0.00046	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=830')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
105	0.00062	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '832' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
106	0.00087	SELECT filter_id FROM oc_product_filter WHERE product_id = '832'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
107	0.00065	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (103,106) 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
108	0.00063	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (103,106) AND f.filter_group_id = '14' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
109	0.00055	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (103,106) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
110	0.00047	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=832')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
111	0.00038	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '833' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
112	0.00085	SELECT filter_id FROM oc_product_filter WHERE product_id = '833'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
113	0.00072	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (103,107) 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
114	0.0007	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (103,107) AND f.filter_group_id = '14' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
115	0.00071	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (103,107) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
116	0.00108	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=833')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
117	0.00038	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '834' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
118	0.0004	SELECT filter_id FROM oc_product_filter WHERE product_id = '834'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
119	0.0003	SELECT DISTINCT f.filter_group_id, fgd.name, fg.sort_order FROM oc_filter f LEFT JOIN oc_filter_group fg ON (f.filter_group_id = fg.filter_group_id) LEFT JOIN oc_filter_group_description fgd ON (fg.filter_group_id = fgd.filter_group_id) WHERE f.filter_id IN (103,107) 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
120	0.00014	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (103,107) AND f.filter_group_id = '14' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
121	0.00015	SELECT DISTINCT f.filter_id, fd.name FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (103,107) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
122	0.00055	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22', 'product_id=834')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
123	0.00029	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
124	0.00015	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
125	0.00015	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
126	0.00015	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
127	0.00018	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
128	0.00015	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
129	0.00014	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
130	0.00015	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
131	0.00017	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
132	0.00014	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
133	0.00017	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
134	0.00055	SELECT * FROM oc_category_to_layout WHERE category_id = '22' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
135	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
136	0.00022	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
137	0.00014	SELECT * FROM oc_category_to_layout WHERE category_id = '22' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
138	0.00017	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1	/home/ttncomua/public_html/catalog/model/design/layout.php	getLayout
139	0.00019	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
140	0.02435	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 = 22 AND p.price <> '999999.0000' AND p.status = '1'	/home/ttncomua/public_html/catalog/controller/module/priceslider.php	index
141	0.0003	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
142	0.00042	SELECT category_id FROM oc_category WHERE parent_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoriesByParentId
143	0.02487	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 (22) 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
144	0.00029	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
145	0.00027	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
146	0.00026	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
147	0.00025	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
148	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
149	0.00021	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
150	0.0003	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
151	0.00026	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
152	0.00026	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
153	0.00041	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
154	0.00034	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
155	0.00022	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
156	0.00026	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 = '22' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategory
157	0.00018	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
158	0.00027	SELECT filter_id FROM oc_category_filter WHERE category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
159	0.00027	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 (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) 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
160	0.00019	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 (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) 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
161	0.00019	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 (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) 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
162	0.00021	SELECT DISTINCT f.filter_id, fd.name, fd.img FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) 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
163	0.00027	SELECT DISTINCT f.filter_id, fd.name, fd.img FROM oc_filter f LEFT JOIN oc_filter_description fd ON (f.filter_id = fd.filter_id) WHERE f.filter_id IN (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) AND f.filter_group_id = '14' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
164	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 (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) AND f.filter_group_id = '13' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
165	0.00019	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 (94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,171,172,173,174,416,420,758,1390,1408,1462,1463,1469,1491,1499,1500,1501,1502,1503,1504) AND f.filter_group_id = '34' AND fd.language_id = '2' ORDER BY f.sort_order, LCASE(fd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
166	0.00144	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 (1502,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 (1502,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
167	0.0013	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1502 ON (p2c.product_id = pf1502.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 pf1502.filter_id = 1502 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
168	0.00171	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 (1503,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 (1503,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
169	0.00094	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1503 ON (p2c.product_id = pf1503.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 pf1503.filter_id = 1503 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
170	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 (1504,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 (1504,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
171	0.00071	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1504 ON (p2c.product_id = pf1504.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 pf1504.filter_id = 1504 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
172	0.00151	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1499,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 (1499,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
173	0.00105	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1499 ON (p2c.product_id = pf1499.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 pf1499.filter_id = 1499 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
174	0.00106	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (1501,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 (1501,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
175	0.00082	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1501 ON (p2c.product_id = pf1501.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 pf1501.filter_id = 1501 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
176	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 (1390,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 (1390,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
177	0.00488	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1390 ON (p2c.product_id = pf1390.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 pf1390.filter_id = 1390 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
178	0.00054	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
179	0.00761	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 = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
180	0.00031	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (758,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 (758,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
181	0.00104	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf758 ON (p2c.product_id = pf758.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 pf758.filter_id = 758 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
182	0.00026	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (420,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 (420,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
183	0.001	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf420 ON (p2c.product_id = pf420.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 pf420.filter_id = 420 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
184	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 (1462,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 (1462,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
185	0.00075	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1462 ON (p2c.product_id = pf1462.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 pf1462.filter_id = 1462 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
186	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 (96,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 (96,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
187	0.00088	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf96 ON (p2c.product_id = pf96.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 pf96.filter_id = 96 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
188	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 (99,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 (99,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
189	0.00115	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf99 ON (p2c.product_id = pf99.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 pf99.filter_id = 99 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
190	0.00026	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (97,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 (97,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
191	0.00107	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf97 ON (p2c.product_id = pf97.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 pf97.filter_id = 97 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
192	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 (101,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 (101,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
193	0.00078	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf101 ON (p2c.product_id = pf101.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 pf101.filter_id = 101 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
194	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 (100,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 (100,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
195	0.001	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf100 ON (p2c.product_id = pf100.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 pf100.filter_id = 100 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
196	0.00128	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (98,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 (98,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
197	0.0008	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf98 ON (p2c.product_id = pf98.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 pf98.filter_id = 98 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
198	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 (95,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 (95,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
199	0.00086	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf95 ON (p2c.product_id = pf95.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 pf95.filter_id = 95 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
200	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 (102,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 (102,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
201	0.00097	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf102 ON (p2c.product_id = pf102.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 pf102.filter_id = 102 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
202	0.00128	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (104,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 (104,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
203	0.00073	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf104 ON (p2c.product_id = pf104.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 pf104.filter_id = 104 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
204	0.00129	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 (105,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 (105,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
205	0.00099	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf105 ON (p2c.product_id = pf105.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 pf105.filter_id = 105 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
206	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 (106,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 (106,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
207	0.00095	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf106 ON (p2c.product_id = pf106.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 pf106.filter_id = 106 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
208	0.00115	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 (107,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 (107,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
209	0.00096	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf107 ON (p2c.product_id = pf107.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 pf107.filter_id = 107 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
210	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 (111,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 (111,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
211	0.00104	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf111 ON (p2c.product_id = pf111.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 pf111.filter_id = 111 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
212	0.001	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (112,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 (112,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
213	0.00099	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf112 ON (p2c.product_id = pf112.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 pf112.filter_id = 112 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
214	0.00023	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (109,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 (109,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
215	0.00097	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf109 ON (p2c.product_id = pf109.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 pf109.filter_id = 109 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
216	0.00026	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (108,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 (108,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
217	0.00101	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf108 ON (p2c.product_id = pf108.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 pf108.filter_id = 108 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
218	0.00241	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 (110,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 (110,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
219	0.00141	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf110 ON (p2c.product_id = pf110.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 pf110.filter_id = 110 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
220	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 (115,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 (115,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
221	0.00092	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf115 ON (p2c.product_id = pf115.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 pf115.filter_id = 115 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
222	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 (117,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 (117,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
223	0.00094	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf117 ON (p2c.product_id = pf117.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 pf117.filter_id = 117 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
224	0.00023	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (116,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 (116,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
225	0.00111	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf116 ON (p2c.product_id = pf116.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 pf116.filter_id = 116 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
226	0.00121	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (119,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 (119,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
227	0.00078	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf119 ON (p2c.product_id = pf119.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 pf119.filter_id = 119 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
228	0.00148	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 (113,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 (113,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
229	0.00201	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf113 ON (p2c.product_id = pf113.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 pf113.filter_id = 113 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
230	0.0013	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 (120,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 (120,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
231	0.00077	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf120 ON (p2c.product_id = pf120.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 pf120.filter_id = 120 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
232	0.00108	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (121,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 (121,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
233	0.00138	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf121 ON (p2c.product_id = pf121.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 pf121.filter_id = 121 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
234	0.00114	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 (126,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 (126,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
235	0.00066	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf126 ON (p2c.product_id = pf126.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 pf126.filter_id = 126 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
236	0.00088	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (125,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 (125,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
237	0.00071	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf125 ON (p2c.product_id = pf125.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 pf125.filter_id = 125 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
238	0.00018	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (173,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 (173,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
239	0.00081	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf173 ON (p2c.product_id = pf173.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 pf173.filter_id = 173 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
240	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 (174,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 (174,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
241	0.00097	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf174 ON (p2c.product_id = pf174.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 pf174.filter_id = 174 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
242	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 (1500,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 (1500,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
243	0.00097	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1500 ON (p2c.product_id = pf1500.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 pf1500.filter_id = 1500 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
244	0.00135	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 (1469,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 (1469,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
245	0.00202	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1469 ON (p2c.product_id = pf1469.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 pf1469.filter_id = 1469 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
246	0.00176	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 (1491,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 (1491,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
247	0.00168	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1491 ON (p2c.product_id = pf1491.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 pf1491.filter_id = 1491 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
248	0.00156	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 (1463,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 (1463,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
249	0.00114	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf1463 ON (p2c.product_id = pf1463.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 pf1463.filter_id = 1463 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
250	0.00163	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 (172,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 (172,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
251	0.01808	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf172 ON (p2c.product_id = pf172.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 pf172.filter_id = 172 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
252	0.00072	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 (127,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 (127,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
253	0.01589	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf127 ON (p2c.product_id = pf127.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 pf127.filter_id = 127 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
254	0.01023	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 (103,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 (103,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
255	0.00756	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf103 ON (p2c.product_id = pf103.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 pf103.filter_id = 103 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
256	0.00164	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 (122,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 (122,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
257	0.00158	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf122 ON (p2c.product_id = pf122.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 pf122.filter_id = 122 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
258	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 (124,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 (124,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
259	0.00132	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf124 ON (p2c.product_id = pf124.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 pf124.filter_id = 124 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
260	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 (94,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 (94,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
261	0.00129	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf94 ON (p2c.product_id = pf94.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 pf94.filter_id = 94 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
262	0.00023	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (114,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 (114,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
263	0.00191	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf114 ON (p2c.product_id = pf114.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 pf114.filter_id = 114 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
264	0.0003	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (118,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 (118,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
265	0.00232	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf118 ON (p2c.product_id = pf118.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 pf118.filter_id = 118 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
266	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 (171,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 (171,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
267	0.00088	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf171 ON (p2c.product_id = pf171.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 pf171.filter_id = 171 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
268	0.0009	SELECT id.product_id FROM(SELECT product_id, count(i.product_id) as t, c.filter_group as b FROM (SELECT f.filter_id, f.product_id, p.filter_group_id FROM oc_product_filter f left join oc_filter p ON p.filter_id = f.filter_id where p.filter_id IN (123,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 (123,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
269	0.00081	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf123 ON (p2c.product_id = pf123.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 pf123.filter_id = 123 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
270	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 (416,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 (416,0)) as c GROUP BY product_id HAVING t = b) as id	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
271	0.00106	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product_filter pf416 ON (p2c.product_id = pf416.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 pf416.filter_id = 416 AND p2c.category_id = '22'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts2
272	0.00019	SELECT * FROM oc_category_to_layout WHERE category_id = '22' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
273	0.00019	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
274	0.00026	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
275	0.00021	SELECT * FROM oc_category_to_layout WHERE category_id = '22' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
276	0.00018	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
277	0.00031	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
278	0.00025	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
279	0.00139	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
280	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
281	0.0003	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
282	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
283	0.00028	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
284	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
285	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=5')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
286	0.00027	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
287	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
288	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
289	0.00026	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
290	0.0003	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
291	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
292	0.0003	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '19' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order DESC, LCASE(cd.name)	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategories
293	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
294	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
295	0.0003	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19', 'category_id=3')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
296	0.00025	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
297	0.0003	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19', 'category_id=5')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
298	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
299	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 = '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
300	0.00023	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
301	0.00026	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
302	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
303	0.00025	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
304	0.00031	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
305	0.00028	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
306	0.00031	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
307	0.00034	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
308	0.00026	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
309	0.00027	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=42')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
310	0.00024	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
311	0.00028	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
312	0.00025	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
313	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
314	0.00028	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=36')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
315	0.0003	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=32')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
316	0.00028	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=37')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
317	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
318	0.00025	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
319	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=69')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
320	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
321	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
322	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
323	0.00026	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=24')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
324	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=22')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
325	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=28')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
326	0.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
327	0.00033	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=26')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
328	0.00026	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=27')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
329	0.00026	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20', 'category_id=21')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
330	0.0003	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
331	0.00045	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
332	0.00031	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
333	0.00028	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
334	0.00025	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
335	0.00046	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
336	0.00019	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
337	0.00015	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
338	0.00018	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
339	0.00015	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
340	0.00015	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
341	0.00015	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
342	0.00017	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
343	0.00018	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
344	0.00017	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
345	0.00014	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
346	0.00015	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
347	0.00014	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
348	0.00024	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
349	0.00019	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
350	0.00014	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=18')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
351	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=15')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
352	0.00017	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
353	0.00016	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
354	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
355	0.00017	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
356	0.00019	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=16')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
357	0.00032	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
358	0.00025	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
359	0.00024	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
360	0.00023	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
361	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=66')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
362	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
363	0.00026	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
364	0.00026	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
365	0.00021	SELECT * FROM oc_category_to_layout WHERE category_id = '22' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
366	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
367	0.0003	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
368	0.00037	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
369	0.00033	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
370	0.0002	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions