Преобразователи частоты

Преобразователь частоты Moeller/EATON DC1-12011FB-A20N (169252)

Количество (шт.)

Код товара: 089188

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-12011NB-A20N (169234)

Количество (шт.)

Код товара: 089187

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-122D3FN-A20N (169240)

Количество (шт.)

Код товара: 089182

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-122D3NN-A20N (169222)

Количество (шт.)

Код товара: 089181

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-124D3FN-A20N (169243)

Количество (шт.)

Код товара: 089184

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-124D3NN-A20N (169225)

Количество (шт.)

Код товара: 089183

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-127D0FB-A20N (169249)

Количество (шт.)

Код товара: 089186

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-127D0FN-A20N (169246)

Количество (шт.)

Код товара: 089191

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-127D0NB-A20N (169231)

Количество (шт.)

Код товара: 089185

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-1D2D3NN-A20N (169503)

Количество (шт.)

Код товара: 089192

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-1D4D3NN-A20N (169506)

Количество (шт.)

Код товара: 089193

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-1D5D8NB-A20N (169509)

Количество (шт.)

Код товара: 089189

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-32011FB-A20N (169447)

Количество (шт.)

Код товара: 089220

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-32011NB-A20N (169438)

Количество (шт.)

Код товара: 089178

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-32018FB-A20N (169450)

Количество (шт.)

Код товара: 089180

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-32018NB-A20N (169441)

Количество (шт.)

Код товара: 089179

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-322D3NN-A20N (169255)

Количество (шт.)

Код товара: 089175

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-324D3NN-A20N (169258)

Количество (шт.)

Код товара: 089176

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-327D0FB-A20N (169444)

Количество (шт.)

Код товара: 089221

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-327D0NB-A20N (169264)

Количество (шт.)

Код товара: 089177

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-327D0NN-A20N (169261)

Количество (шт.)

Код товара: 089223

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-34014FB-A20N (169490)

Количество (шт.)

Код товара: 089170

В избранное

В сравнение

Преобразователь частоты Moeller/EATON DC1-34014NB-A20N (169468)

Количество (шт.)

Код товара: 089169

В избранное

В сравнение

Показано с 1 по 23 из 41 (всего 2 страниц)

SERVER

array(44) { ["PHPRC"]=> string(22) "/usr/local/lib/php.ini" ["PATH"]=> string(180) "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin" ["PWD"]=> string(25) "/usr/local/cpanel/cgi-sys" ["TZ"]=> string(11) "Europe/Kiev" ["SHLVL"]=> string(1) "0" ["FCGI_ROLE"]=> string(9) "RESPONDER" ["REDIRECT_UNIQUE_ID"]=> string(24) "WwoKX8IcVBsAJjE@UdcAAAAD" ["REDIRECT_SCRIPT_URL"]=> string(40) "/elektrotehnika/preobrazovateli-chastoty" ["REDIRECT_SCRIPT_URI"]=> string(58) "https://380.com.ua/elektrotehnika/preobrazovateli-chastoty" ["REDIRECT_HTTPS"]=> string(2) "on" ["REDIRECT_STATUS"]=> string(3) "200" ["UNIQUE_ID"]=> string(24) "WwoKX8IcVBsAJjE@UdcAAAAD" ["SCRIPT_URL"]=> string(40) "/elektrotehnika/preobrazovateli-chastoty" ["SCRIPT_URI"]=> string(58) "https://380.com.ua/elektrotehnika/preobrazovateli-chastoty" ["HTTPS"]=> string(2) "on" ["HTTP_HOST"]=> string(10) "380.com.ua" ["HTTP_X_REAL_IP"]=> string(14) "54.167.216.239" ["HTTP_X_FORWARDED_FOR"]=> string(14) "54.167.216.239" ["HTTP_X_FORWARDED_PROTO"]=> string(5) "https" ["HTTP_CONNECTION"]=> string(5) "close" ["HTTP_ACCEPT_ENCODING"]=> string(21) "x-gzip, gzip, deflate" ["HTTP_USER_AGENT"]=> string(39) "CCBot/2.0 (http://commoncrawl.org/faq/)" ["HTTP_ACCEPT"]=> string(63) "text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8" ["HTTP_X_HTTPS"]=> string(1) "1" ["SERVER_SIGNATURE"]=> string(0) "" ["SERVER_SOFTWARE"]=> string(6) "Apache" ["SERVER_NAME"]=> string(10) "380.com.ua" ["SERVER_ADDR"]=> string(12) "194.28.84.27" ["SERVER_PORT"]=> string(3) "443" ["REMOTE_ADDR"]=> string(14) "54.167.216.239" ["DOCUMENT_ROOT"]=> string(26) "/home/ttncomua/public_html" ["SERVER_ADMIN"]=> string(20) "webmaster@380.com.ua" ["SCRIPT_FILENAME"]=> string(36) "/home/ttncomua/public_html/index.php" ["REMOTE_PORT"]=> string(5) "50507" ["REDIRECT_QUERY_STRING"]=> string(47) "_route_=elektrotehnika/preobrazovateli-chastoty" ["REDIRECT_URL"]=> string(40) "/elektrotehnika/preobrazovateli-chastoty" ["GATEWAY_INTERFACE"]=> string(7) "CGI/1.1" ["SERVER_PROTOCOL"]=> string(8) "HTTP/1.1" ["REQUEST_METHOD"]=> string(3) "GET" ["QUERY_STRING"]=> string(47) "_route_=elektrotehnika/preobrazovateli-chastoty" ["REQUEST_URI"]=> string(40) "/elektrotehnika/preobrazovateli-chastoty" ["SCRIPT_NAME"]=> string(10) "/index.php" ["PHP_SELF"]=> string(10) "/index.php" ["REQUEST_TIME"]=> string(10) "1527384671" }

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

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

File

/home/ttncomua/public_html/index.php

/home/ttncomua/public_html/config.php

/home/ttncomua/public_html/system/startup.php

/home/ttncomua/public_html/system/helper/json.php

/home/ttncomua/public_html/system/helper/utf8.php

/home/ttncomua/public_html/system/engine/action.php

/home/ttncomua/public_html/system/engine/controller.php

/home/ttncomua/public_html/system/engine/front.php

/home/ttncomua/public_html/system/engine/loader.php

/home/ttncomua/public_html/system/engine/model.php

/home/ttncomua/public_html/system/engine/registry.php

/home/ttncomua/public_html/system/library/cache.php

/home/ttncomua/public_html/system/library/url.php

/home/ttncomua/public_html/system/library/config.php

/home/ttncomua/public_html/system/library/db.php

/home/ttncomua/public_html/system/library/document.php

/home/ttncomua/public_html/system/library/encryption.php

/home/ttncomua/public_html/system/library/image.php

/home/ttncomua/public_html/system/library/language.php

/home/ttncomua/public_html/system/library/log.php

/home/ttncomua/public_html/system/library/mail.php

/home/ttncomua/public_html/system/library/pagination.php

/home/ttncomua/public_html/system/library/request.php

/home/ttncomua/public_html/system/library/response.php

/home/ttncomua/public_html/system/library/session.php

/home/ttncomua/public_html/system/library/template.php

/home/ttncomua/public_html/system/library/customer.php

/home/ttncomua/public_html/system/library/affiliate.php

/home/ttncomua/public_html/system/library/currency.php

/home/ttncomua/public_html/system/library/tax.php

/home/ttncomua/public_html/system/library/weight.php

/home/ttncomua/public_html/system/library/length.php

/home/ttncomua/public_html/system/library/cart.php

/home/ttncomua/public_html/system/database/mysql.php

/home/ttncomua/public_html/catalog/language/russian/russian.php

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

/home/ttncomua/public_html/catalog/controller/product/category.php

/home/ttncomua/public_html/catalog/language/russian/product/category.php

/home/ttncomua/public_html/catalog/language/russian/module/order_one_click_product.php

/home/ttncomua/public_html/catalog/model/catalog/category.php

/home/ttncomua/public_html/catalog/model/catalog/product.php

/home/ttncomua/public_html/catalog/model/tool/image.php

/home/ttncomua/public_html/catalog/controller/common/column_left.php

/home/ttncomua/public_html/catalog/model/design/layout.php

/home/ttncomua/public_html/catalog/model/catalog/information.php

/home/ttncomua/public_html/catalog/model/setting/extension.php

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/column_left.tpl

/home/ttncomua/public_html/catalog/controller/common/column_right.php

/home/ttncomua/public_html/catalog/controller/module/compare.php

/home/ttncomua/public_html/catalog/language/russian/module/compare.php

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/compare.tpl

/home/ttncomua/public_html/catalog/controller/module/priceslider.php

/home/ttncomua/public_html/catalog/language/russian/module/priceslider.php

/home/ttncomua/public_html/catalog/model/catalog/manufacturer.php

/home/ttncomua/public_html/catalog/controller/module/language.php

/home/ttncomua/public_html/catalog/language/russian/module/language.php

/home/ttncomua/public_html/catalog/model/localisation/language.php

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/language.tpl

/home/ttncomua/public_html/catalog/controller/module/currency.php

/home/ttncomua/public_html/catalog/language/russian/module/currency.php

/home/ttncomua/public_html/catalog/model/localisation/currency.php

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/currency.tpl

/home/ttncomua/public_html/catalog/controller/module/cart.php

/home/ttncomua/public_html/catalog/language/russian/module/cart.php

/home/ttncomua/public_html/catalog/model/total/sub_total.php

/home/ttncomua/public_html/catalog/language/russian/total/sub_total.php

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/cart.tpl

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/priceslider.tpl

/home/ttncomua/public_html/catalog/controller/module/filter.php

/home/ttncomua/public_html/catalog/language/russian/module/filter.php

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/column_right.tpl

/home/ttncomua/public_html/catalog/controller/common/content_top.php

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/content_top.tpl

/home/ttncomua/public_html/catalog/controller/common/content_bottom.php

/home/ttncomua/public_html/catalog/controller/module/astickers.php

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/module/astickers.tpl

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/content_bottom.tpl

/home/ttncomua/public_html/catalog/controller/common/footer.php

/home/ttncomua/public_html/catalog/controller/module/popupcart_extended.php

/home/ttncomua/public_html/catalog/language/russian/module/popupcart_extended.php

/home/ttncomua/public_html/catalog/view/theme/default/template/module/popupcart_extended.tpl

/home/ttncomua/public_html/catalog/language/russian/common/footer.php

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/footer.tpl

/home/ttncomua/public_html/catalog/controller/common/header.php

/home/ttncomua/public_html/catalog/language/russian/common/header.php

/home/ttncomua/public_html/catalog/model/setting/store.php

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/common/header.tpl

/home/ttncomua/public_html/catalog/view/theme/tehnoton/template/product/category.tpl

/home/ttncomua/public_html/system/helper/fa_debuger.php

#	Time	Query	File	Function
1	0.00021	SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://380.com.ua/'	/home/ttncomua/public_html/index.php	Array
2	0.0013	SELECT * FROM oc_setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC	/home/ttncomua/public_html/index.php	Array
3	0.00016	SELECT * FROM `oc_language` WHERE status = '1'	/home/ttncomua/public_html/index.php	Array
4	0.00024	SELECT * FROM oc_currency	/home/ttncomua/public_html/system/library/currency.php	__construct
5	0.00018	SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '2'	/home/ttncomua/public_html/system/library/weight.php	__construct
6	0.00015	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.00332	SELECT SUBSTRING_INDEX(query,'=',1) AS name, CONVERT(SUBSTRING_INDEX(query,'=',-1),UNSIGNED INTEGER) AS value FROM oc_url_alias WHERE keyword IN('elektrotehnika','preobrazovateli-chastoty') ORDER BY FIND_IN_SET(keyword, 'elektrotehnika,preobrazovateli-chastoty')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	index
8	0.00027	SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '29' 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.00015	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
10	0.00215	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 = '41' 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.00023	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
12	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 = '41' 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.00082	SELECT filter_id FROM oc_category_filter WHERE category_id = '41'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
14	0.00571	SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '41'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getTotalProducts
15	0.00832	SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '41' GROUP BY p.product_id ORDER BY (p.image !='') DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,23	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProducts
16	0.00319	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13900' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
17	0.0013	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13895' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
18	0.00129	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13896' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
19	0.00124	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13892' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
20	0.00131	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13897' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
21	0.00122	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13893' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
22	0.00123	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13899' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
23	0.00116	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13898' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
24	0.00115	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13894' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
25	0.00125	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13925' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
26	0.00114	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13926' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
27	0.00162	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13927' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
28	0.00129	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13908' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
29	0.0012	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13905' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
30	0.00125	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13909' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
31	0.00118	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13906' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
32	0.00126	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13901' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
33	0.00126	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13902' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
34	0.00124	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13907' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
35	0.00123	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13904' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
36	0.00127	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13903' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
37	0.0013	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13922' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
38	0.00122	SELECT DISTINCT , pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT() AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13914' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProduct
39	0.00276	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 = '13900' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
40	0.00157	SELECT filter_id FROM oc_product_filter WHERE product_id = '13900'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
41	0.00094	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13900')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
42	0.00135	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 = '13895' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
43	0.00077	SELECT filter_id FROM oc_product_filter WHERE product_id = '13895'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
44	0.00072	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13895')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
45	0.00063	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '13896' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
46	0.00043	SELECT filter_id FROM oc_product_filter WHERE product_id = '13896'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
47	0.00113	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13896')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
48	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 = '13892' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
49	0.0006	SELECT filter_id FROM oc_product_filter WHERE product_id = '13892'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
50	0.00066	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13892')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
51	0.0006	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '13897' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
52	0.00047	SELECT filter_id FROM oc_product_filter WHERE product_id = '13897'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
53	0.00081	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13897')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
54	0.00088	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '13893' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
55	0.00054	SELECT filter_id FROM oc_product_filter WHERE product_id = '13893'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
56	0.00054	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13893')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
57	0.00125	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 = '13899' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
58	0.00086	SELECT filter_id FROM oc_product_filter WHERE product_id = '13899'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
59	0.00089	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13899')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
60	0.00102	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 = '13898' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
61	0.00029	SELECT filter_id FROM oc_product_filter WHERE product_id = '13898'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
62	0.00037	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13898')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
63	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 = '13894' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
64	0.00088	SELECT filter_id FROM oc_product_filter WHERE product_id = '13894'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
65	0.00047	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13894')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
66	0.00037	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '13925' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
67	0.00028	SELECT filter_id FROM oc_product_filter WHERE product_id = '13925'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
68	0.00059	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13925')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
69	0.00052	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 = '13926' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
70	0.00033	SELECT filter_id FROM oc_product_filter WHERE product_id = '13926'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
71	0.00043	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13926')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
72	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 = '13927' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
73	0.00108	SELECT filter_id FROM oc_product_filter WHERE product_id = '13927'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
74	0.00052	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13927')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
75	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 = '13908' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
76	0.001	SELECT filter_id FROM oc_product_filter WHERE product_id = '13908'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
77	0.00041	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13908')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
78	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 = '13905' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
79	0.00044	SELECT filter_id FROM oc_product_filter WHERE product_id = '13905'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
80	0.0005	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13905')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
81	0.00043	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '13909' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
82	0.001	SELECT filter_id FROM oc_product_filter WHERE product_id = '13909'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
83	0.00043	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13909')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
84	0.00037	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '13906' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
85	0.00032	SELECT filter_id FROM oc_product_filter WHERE product_id = '13906'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
86	0.00123	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13906')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
87	0.00045	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '13901' 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 = '13901'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
89	0.0007	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13901')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
90	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 = '13902' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
91	0.00033	SELECT filter_id FROM oc_product_filter WHERE product_id = '13902'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
92	0.00052	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13902')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
93	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 = '13907' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
94	0.00038	SELECT filter_id FROM oc_product_filter WHERE product_id = '13907'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
95	0.00042	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13907')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
96	0.00046	SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '13904' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
97	0.00037	SELECT filter_id FROM oc_product_filter WHERE product_id = '13904'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
98	0.00047	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13904')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
99	0.00072	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 = '13903' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
100	0.00044	SELECT filter_id FROM oc_product_filter WHERE product_id = '13903'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
101	0.00057	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13903')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
102	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 = '13922' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
103	0.0005	SELECT filter_id FROM oc_product_filter WHERE product_id = '13922'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
104	0.00039	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13922')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
105	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 = '13914' AND od.language_id = '2' ORDER BY o.sort_order	/home/ttncomua/public_html/catalog/model/catalog/product.php	getProductOptions
106	0.00036	SELECT filter_id FROM oc_product_filter WHERE product_id = '13914'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getProductFilter
107	0.00043	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13914')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
108	0.00038	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
109	0.00025	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
110	0.00023	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
111	0.00022	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
112	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
113	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
114	0.00025	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
115	0.0003	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
116	0.00031	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
117	0.00029	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
118	0.00029	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
119	0.00124	SELECT * FROM oc_category_to_layout WHERE category_id = '41' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
120	0.00026	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1	/home/ttncomua/public_html/catalog/model/design/layout.php	getLayout
121	0.00044	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
122	0.00026	SELECT * FROM oc_category_to_layout WHERE category_id = '41' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
123	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
124	0.00029	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
125	0.00371	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 = 41 AND p.price <> '999999.0000' AND p.status = '1'	/home/ttncomua/public_html/catalog/controller/module/priceslider.php	index
126	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
127	0.0004	SELECT category_id FROM oc_category WHERE parent_id = '41'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoriesByParentId
128	0.00414	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 (41) 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
129	0.00019	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
130	0.00034	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
131	0.0003	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
132	0.00019	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
133	0.00023	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 = '41' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategory
134	0.00019	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
135	0.00015	SELECT filter_id FROM oc_category_filter WHERE category_id = '41'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryFilters
136	0.00027	SELECT * FROM oc_category_to_layout WHERE category_id = '41' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
137	0.00031	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
138	0.0002	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
139	0.00017	SELECT * FROM oc_category_to_layout WHERE category_id = '41' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
140	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
141	0.00023	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
142	0.00021	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
143	0.00143	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
144	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
145	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
146	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
147	0.00017	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
148	0.00015	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
149	0.00018	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=5')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
150	0.00018	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
151	0.00058	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
152	0.00019	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
153	0.00016	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
154	0.00018	SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
155	0.00029	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
156	0.00021	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
157	0.00019	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
158	0.00021	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19', 'category_id=2')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
159	0.00025	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
160	0.0002	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
161	0.00016	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
162	0.00017	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
163	0.00041	SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '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
164	0.00017	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
165	0.00016	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=31')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
166	0.0002	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
167	0.00019	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=35')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
168	0.00036	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
169	0.00019	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
170	0.0002	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
171	0.00019	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
172	0.00032	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
173	0.00017	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
174	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=40')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
175	0.00021	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
176	0.00023	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
177	0.00023	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
178	0.00024	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
179	0.00018	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
180	0.00049	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
181	0.00018	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
182	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=45')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
183	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
184	0.00021	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
185	0.00039	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
186	0.00022	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
187	0.00021	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
188	0.00039	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
189	0.00027	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
190	0.00029	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
191	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
192	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
193	0.00035	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
194	0.00037	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
195	0.00047	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
196	0.00032	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=53')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
197	0.00034	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
198	0.00034	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
199	0.00031	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
200	0.00033	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
201	0.00031	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
202	0.00028	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=60')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
203	0.00029	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
204	0.00035	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
205	0.00032	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
206	0.00029	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
207	0.0003	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
208	0.0004	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
209	0.00033	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=61')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
210	0.00035	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
211	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
212	0.00038	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
213	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
214	0.00027	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
215	0.00021	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=15')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
216	0.00023	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
217	0.00023	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
218	0.00022	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
219	0.00025	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
220	0.00026	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
221	0.00028	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
222	0.00024	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
223	0.00055	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
224	0.00017	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
225	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
226	0.0002	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
227	0.00017	SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64')	/home/ttncomua/public_html/catalog/controller/common/seo_url.php	rewrite
228	0.00021	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
229	0.0002	SELECT * FROM oc_category_to_layout WHERE category_id = '41' AND store_id = '0'	/home/ttncomua/public_html/catalog/model/catalog/category.php	getCategoryLayoutId
230	0.0002	SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1	/home/ttncomua/public_html/catalog/model/design/layout.php	getLayout
231	0.00028	SELECT * FROM oc_extension WHERE `type` = 'module'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions
232	0.00042	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
233	0.00037	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
234	0.00083	SELECT * FROM oc_extension WHERE `type` = 'total'	/home/ttncomua/public_html/catalog/model/setting/extension.php	getExtensions

Time

Query

File

Function

0.00021

SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://380.com.ua/'

/home/ttncomua/public_html/index.php

Array

0.0013

SELECT * FROM oc_setting WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC

/home/ttncomua/public_html/index.php

Array

0.00016

SELECT * FROM `oc_language` WHERE status = '1'

/home/ttncomua/public_html/index.php

Array

0.00024

SELECT * FROM oc_currency

/home/ttncomua/public_html/system/library/currency.php

__construct

0.00018

SELECT * FROM oc_weight_class wc LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '2'

/home/ttncomua/public_html/system/library/weight.php

__construct

0.00015

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

0.00332

SELECT SUBSTRING_INDEX(query,'=',1) AS name, CONVERT(SUBSTRING_INDEX(query,'=',-1),UNSIGNED INTEGER) AS value FROM oc_url_alias WHERE keyword IN('elektrotehnika','preobrazovateli-chastoty') ORDER BY FIND_IN_SET(keyword, 'elektrotehnika,preobrazovateli-chastoty')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

index

0.00027

SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '29' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getCategory

0.00015

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00215

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 = '41' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getCategory

0.00023

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

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 = '41' 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

0.00082

SELECT filter_id FROM oc_category_filter WHERE category_id = '41'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getCategoryFilters

0.00571

SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '41'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getTotalProducts

0.00832

SELECT p.product_id, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '41' GROUP BY p.product_id ORDER BY (p.image !='') DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,23

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProducts

0.00319

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13900' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.0013

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13895' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00129

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13896' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00124

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13892' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00131

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13897' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00122

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13893' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00123

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13899' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00116

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13898' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00115

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13894' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00125

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13925' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00114

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13926' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00162

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13927' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00129

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13908' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.0012

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13905' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00125

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13909' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00118

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13906' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00126

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13901' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00126

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13902' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00124

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13907' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00123

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13904' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00127

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13903' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.0013

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13922' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00122

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '13914' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProduct

0.00276

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 = '13900' AND od.language_id = '2' ORDER BY o.sort_order

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00157

SELECT filter_id FROM oc_product_filter WHERE product_id = '13900'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00094

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13900')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00135

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 = '13895' AND od.language_id = '2' ORDER BY o.sort_order

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00077

SELECT filter_id FROM oc_product_filter WHERE product_id = '13895'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00072

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13895')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00063

SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '13896' AND od.language_id = '2' ORDER BY o.sort_order

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00043

SELECT filter_id FROM oc_product_filter WHERE product_id = '13896'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00113

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13896')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

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 = '13892' AND od.language_id = '2' ORDER BY o.sort_order

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.0006

SELECT filter_id FROM oc_product_filter WHERE product_id = '13892'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00066

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13892')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.0006

SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '13897' AND od.language_id = '2' ORDER BY o.sort_order

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00047

SELECT filter_id FROM oc_product_filter WHERE product_id = '13897'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00081

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13897')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00088

SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '13893' AND od.language_id = '2' ORDER BY o.sort_order

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00054

SELECT filter_id FROM oc_product_filter WHERE product_id = '13893'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00054

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13893')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00125

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 = '13899' AND od.language_id = '2' ORDER BY o.sort_order

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00086

SELECT filter_id FROM oc_product_filter WHERE product_id = '13899'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00089

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13899')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00102

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 = '13898' AND od.language_id = '2' ORDER BY o.sort_order

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00029

SELECT filter_id FROM oc_product_filter WHERE product_id = '13898'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00037

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13898')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

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 = '13894' AND od.language_id = '2' ORDER BY o.sort_order

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00088

SELECT filter_id FROM oc_product_filter WHERE product_id = '13894'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00047

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13894')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00037

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00028

SELECT filter_id FROM oc_product_filter WHERE product_id = '13925'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00059

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13925')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00052

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00033

SELECT filter_id FROM oc_product_filter WHERE product_id = '13926'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00043

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13926')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.0004

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00108

SELECT filter_id FROM oc_product_filter WHERE product_id = '13927'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00052

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13927')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00042

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.001

SELECT filter_id FROM oc_product_filter WHERE product_id = '13908'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00041

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13908')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00042

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00044

SELECT filter_id FROM oc_product_filter WHERE product_id = '13905'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.0005

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13905')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00043

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.001

SELECT filter_id FROM oc_product_filter WHERE product_id = '13909'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00043

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13909')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00037

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00032

SELECT filter_id FROM oc_product_filter WHERE product_id = '13906'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00123

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13906')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00045

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00037

SELECT filter_id FROM oc_product_filter WHERE product_id = '13901'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.0007

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13901')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00054

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00033

SELECT filter_id FROM oc_product_filter WHERE product_id = '13902'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00052

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13902')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00056

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00038

SELECT filter_id FROM oc_product_filter WHERE product_id = '13907'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00042

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13907')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00046

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

0.00037

SELECT filter_id FROM oc_product_filter WHERE product_id = '13904'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

0.00047

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13904')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

0.00072

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

100

0.00044

SELECT filter_id FROM oc_product_filter WHERE product_id = '13903'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

101

0.00057

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13903')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

102

0.0004

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

103

0.0005

SELECT filter_id FROM oc_product_filter WHERE product_id = '13922'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

104

0.00039

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13922')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

105

0.0005

/home/ttncomua/public_html/catalog/model/catalog/product.php

getProductOptions

106

0.00036

SELECT filter_id FROM oc_product_filter WHERE product_id = '13914'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getProductFilter

107

0.00043

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41', 'product_id=13914')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

108

0.00038

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

109

0.00025

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

110

0.00023

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

111

0.00022

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

112

0.00024

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

113

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

114

0.00025

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

115

0.0003

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

116

0.00031

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

117

0.00029

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

118

0.00029

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

119

0.00124

SELECT * FROM oc_category_to_layout WHERE category_id = '41' AND store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getCategoryLayoutId

120

0.00026

SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1

/home/ttncomua/public_html/catalog/model/design/layout.php

getLayout

121

0.00044

SELECT * FROM oc_extension WHERE `type` = 'module'

/home/ttncomua/public_html/catalog/model/setting/extension.php

getExtensions

122

0.00026

SELECT * FROM oc_category_to_layout WHERE category_id = '41' AND store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getCategoryLayoutId

123

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

124

0.00029

SELECT * FROM oc_extension WHERE `type` = 'module'

/home/ttncomua/public_html/catalog/model/setting/extension.php

getExtensions

125

0.00371

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 = 41 AND p.price <> '999999.0000' AND p.status = '1'

/home/ttncomua/public_html/catalog/controller/module/priceslider.php

index

126

0.00024

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=41')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

127

0.0004

SELECT category_id FROM oc_category WHERE parent_id = '41'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getCategoriesByParentId

128

0.00414

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 (41) 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

129

0.00019

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

130

0.00034

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

131

0.0003

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

132

0.00019

SELECT * FROM oc_extension WHERE `type` = 'total'

/home/ttncomua/public_html/catalog/model/setting/extension.php

getExtensions

133

0.00023

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 = '41' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getCategory

134

0.00019

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

135

0.00015

SELECT filter_id FROM oc_category_filter WHERE category_id = '41'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getCategoryFilters

136

0.00027

SELECT * FROM oc_category_to_layout WHERE category_id = '41' AND store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getCategoryLayoutId

137

0.00031

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

138

0.0002

SELECT * FROM oc_extension WHERE `type` = 'module'

/home/ttncomua/public_html/catalog/model/setting/extension.php

getExtensions

139

0.00017

SELECT * FROM oc_category_to_layout WHERE category_id = '41' AND store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getCategoryLayoutId

140

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

141

0.00023

SELECT * FROM oc_extension WHERE `type` = 'module'

/home/ttncomua/public_html/catalog/model/setting/extension.php

getExtensions

142

0.00021

SELECT * FROM oc_extension WHERE `type` = 'total'

/home/ttncomua/public_html/catalog/model/setting/extension.php

getExtensions

143

0.00143

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

144

0.00023

SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

145

0.00015

SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

146

0.00015

SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

147

0.00017

SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

148

0.00015

SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

149

0.00018

SELECT * FROM oc_url_alias WHERE `query` IN('information_id=5')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

150

0.00018

SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

151

0.00058

/home/ttncomua/public_html/catalog/model/catalog/information.php

getInformations

152

0.00019

SELECT * FROM oc_url_alias WHERE `query` IN('information_id=6')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

153

0.00016

SELECT * FROM oc_url_alias WHERE `query` IN('information_id=4')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

154

0.00018

SELECT * FROM oc_url_alias WHERE `query` IN('information_id=7')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

155

0.00029

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

156

0.00021

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

157

0.00019

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

158

0.00021

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19', 'category_id=2')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

159

0.00025

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

160

0.0002

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

161

0.00016

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

162

0.00017

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=19')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

163

0.00041

SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '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

164

0.00017

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

165

0.00016

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=31')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

166

0.0002

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

167

0.00019

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=35')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

168

0.00036

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

169

0.00019

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

170

0.0002

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

171

0.00019

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

172

0.00032

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

173

0.00017

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

174

0.00022

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=40')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

175

0.00021

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

176

0.00023

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

177

0.00023

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

178

0.00024

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

179

0.00018

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

180

0.00049

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

181

0.00018

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

182

0.00022

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29', 'category_id=45')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

183

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

184

0.00021

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=29')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

185

0.00039

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

186

0.00022

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

187

0.00021

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

188

0.00039

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

189

0.00027

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

190

0.00029

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

191

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

192

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

193

0.00035

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

194

0.00037

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=20')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

195

0.00047

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

196

0.00032

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=53')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

197

0.00034

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

198

0.00034

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

199

0.00031

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

200

0.00033

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

201

0.00031

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

202

0.00028

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=60')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

203

0.00029

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

204

0.00035

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

205

0.00032

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

206

0.00029

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

207

0.0003

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

208

0.0004

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

209

0.00033

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49', 'category_id=61')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

210

0.00035

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

211

0.00023

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=49')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

212

0.00038

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

213

0.00023

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=14')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

214

0.00027

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

215

0.00021

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=15')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

216

0.00023

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

217

0.00023

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=12')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

218

0.00022

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6', 'category_id=70')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

219

0.00025

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

220

0.00026

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

221

0.00028

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

222

0.00024

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=6')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

223

0.00055

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

224

0.00017

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

225

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

226

0.0002

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64', 'category_id=65')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

227

0.00017

SELECT * FROM oc_url_alias WHERE `query` IN('category_id=64')

/home/ttncomua/public_html/catalog/controller/common/seo_url.php

rewrite

228

0.00021

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

229

0.0002

SELECT * FROM oc_category_to_layout WHERE category_id = '41' AND store_id = '0'

/home/ttncomua/public_html/catalog/model/catalog/category.php

getCategoryLayoutId

230

0.0002

SELECT * FROM oc_layout_route WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0' ORDER BY route DESC LIMIT 1

/home/ttncomua/public_html/catalog/model/design/layout.php

getLayout

231

0.00028

SELECT * FROM oc_extension WHERE `type` = 'module'

/home/ttncomua/public_html/catalog/model/setting/extension.php

getExtensions

232

0.00042

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

233

0.00037

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

234

0.00083

SELECT * FROM oc_extension WHERE `type` = 'total'

/home/ttncomua/public_html/catalog/model/setting/extension.php

getExtensions

Преобразователи частоты

GET

POST

COOKIE

SERVER

SESSION

FILES

REQUEST