Menu
Jūsu grozs

Kaleidoskopi

Kaleidoskops FOOTBALL FCB Londji Kaleidoskops FOOTBALL FCB Londji
-50%
Zīmols: Londji
Atšķirībā no klasiskajam kaleidoskopiem, kas attēlu veido no sīkiem gabaliem tā iekšienē, teleskops veido kaleidoskopisku attēlu no objektiem, kas atrodas tev apkārt.Materiāls Kartons un spogulisIzmēri diametrs 3,8 cm, augstums 19,4 cm..
6,00€ 12,00€
Bez nodokļa:4,96€
Kaleidoskops MINI Londji Kaleidoskops MINI Londji
Bestsellers
Zīmols: Londji
Lēca, kas pārveido realitāti mazā poētiskā fragmentāMateriāls Kartons un spogulisIzmēri diametrs 3,5 cm, augstums 5 cm..
4,95€
Bez nodokļa:4,09€
Zīmols: Londji
Atšķirībā no klasiskajam kaleidoskopiem, kas attēlu veido no sīkiem gabaliem tā iekšienē, teleskops veido kaleidoskopisku attēlu no objektiem, kas atrodas tev apkārtIlustrācija Van GogsMateriāls Kartons un spogulisIzmēri diametrs 3,8 cm, augstums 19,4 cm..
12,00€
Bez nodokļa:9,92€
Zīmols: Londji
Atšķirībā no klasiskajam kaleidoskopiem, kas attēlu veido no sīkiem gabaliem tā iekšienē, teleskops veido kaleidoskopisku attēlu no objektiem, kas atrodas tev apkārt.Ilustrācija Nathalie OuederniMateriāls Kartons un spogulisIzmēri diametrs 3,8 cm, augstums 19,4 cm..
12,00€
Bez nodokļa:9,92€
Rāda no 1 līdz 4 kopā 4 (Kopā lapu - 1)
Sīkdatņu paziņojums
Šajā vietnē tiek izmantotas sīkdatnes. Piekrītot izmantot sīkdatnes, vietne tiks optimizēta. Turpinot skatīt vietni, jūs piekrītat, ka mēs jūsu ierīcē izmantosim sīkfailus. Jūs jebkurā laikā varat atsaukt savu piekrišanu, izdzēšot saglabātos sīkfailus
Queries: 398, Total time: 1,347.321 ms [By time] [By id] [By file]
1 (9.755)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
2 (0.458)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/pingas/liepinmaja_public_html/system/library/openbay.php:61
3 (0.838)
select value
from oc_setting
where `key` like "adk_%inline_translate"
/home/pingas/liepinmaja_public_html/system/library/advertikon/advertikon.php:3497
4 (14.101)
SELECT `data`
FROM `oc_session`
WHERE session_id = '2cc810a92fc099f42e0cb4f598' AND expire > 1686253383
/home/pingas/liepinmaja_public_html/system/library/session/db.php:21
5 (19.831)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://liepinmaja.lv/'
/home/pingas/storage3032/modification/catalog/controller/startup/startup.php:6
6 (28.397)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/pingas/storage3032/modification/catalog/controller/startup/startup.php:25
7 (24.261)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/pingas/liepinmaja_public_html/catalog/model/localisation/language.php:15
8 (0.373)
SELECT *
FROM oc_currency
/home/pingas/liepinmaja_public_html/system/library/cart/currency.php:10
9 (0.965)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '8' AND z2gz.country_id = '117' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4163')
ORDER BY tr1.priority ASC
/home/pingas/liepinmaja_public_html/system/library/cart/tax.php:16
10 (0.750)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '8' AND z2gz.country_id = '117' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4163')
ORDER BY tr1.priority ASC
/home/pingas/liepinmaja_public_html/system/library/cart/tax.php:44
11 (25.367)
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/pingas/liepinmaja_public_html/system/library/cart/weight.php:10
12 (51.699)
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/pingas/liepinmaja_public_html/system/library/cart/length.php:10
13 (56.011)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/pingas/storage3032/modification/system/library/cart/cart.php:15
14 (0.450)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/pingas/liepinmaja_public_html/system/library/openbay.php:61
15 (0.744)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/pingas/liepinmaja_public_html/catalog/model/setting/event.php:4
16 (0.095)
SELECT *
FROM oc_seo_url
WHERE keyword = 'Produkti' AND store_id = '0'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:19
17 (0.052)
SELECT *
FROM oc_seo_url
WHERE keyword = 'Rotallietas-speles' AND store_id = '0'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:19
18 (73.520)
SELECT *
FROM oc_seo_url
WHERE keyword = 'Kaleidoskopi_' AND store_id = '0'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:19
19 (0.526)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
20 (74.419)
SELECT count(*) AS total
FROM `oc_journal3_skin`
/home/pingas/liepinmaja_public_html/catalog/model/journal3/settings.php:112
21 (19.748)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
22 (80.114)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
23 (23.116)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
24 (26.800)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
25 (84.506)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
26 (49.263)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
27 (22.557)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '5209' AND store_id = '0'
/home/pingas/liepinmaja_public_html/catalog/model/catalog/category.php:55
28 (52.430)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/design/layout.php:4
29 (26.137)
SELECT layout_id, layout_data
FROM `oc_journal3_layout`
WHERE `layout_id` = '3' OR `layout_id` = -1
ORDER BY `layout_id` DESC
/home/pingas/liepinmaja_public_html/catalog/model/journal3/layout.php:122
30 (1.348)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
31 (0.498)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
32 (0.438)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/css'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
33 (1.196)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
34 (0.490)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
35 (1.197)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
36 (0.486)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
37 (1.126)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
38 (0.434)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
39 (1.131)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
40 (0.419)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
41 (1.114)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
42 (0.454)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
43 (1.099)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
44 (0.446)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
45 (1.154)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
46 (0.450)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
47 (1.119)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
48 (1.095)
SELECT `key`, `value`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` like 'esi%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:42
49 (0.487)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/category' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
50 (0.129)
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 = '308' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/pingas/liepinmaja_public_html/catalog/model/catalog/category.php:4
51 (0.068)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
52 (0.077)
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 = '231' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/pingas/liepinmaja_public_html/catalog/model/catalog/category.php:4
53 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
54 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
55 (19.269)
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 = '5209' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/pingas/liepinmaja_public_html/catalog/model/catalog/category.php:4
56 (0.087)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
57 (0.050)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
58 (0.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
59 (15.042)
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 = '5209' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/pingas/liepinmaja_public_html/catalog/model/catalog/category.php:10
60 (1.443)
SELECT COUNT(DISTINCT p.product_id) total
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '5209'
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
61 (1.347)
SELECT p.product_id, ( SELECT AVG(rating) total
FROM `oc_review` r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id ) rating, ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) discount, ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) special, p.viewed
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '5209' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 12
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
62 (2.999)
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 = '8' 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 = '8' 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 pr.customer_group_id = '8') 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 IN (28061,24912,27194,25244) AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/pingas/liepinmaja_public_html/catalog/model/journal3/product.php:27
63 (0.138)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=318' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
64 (0.075)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
65 (0.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
66 (0.046)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
67 (0.899)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28061' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
68 (0.134)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=318' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
69 (0.061)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
70 (0.050)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
71 (0.048)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
72 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=24912' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
73 (0.136)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=318' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
74 (0.060)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
75 (0.048)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
76 (0.050)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
77 (41.588)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=27194' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
78 (0.119)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=318' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
79 (0.060)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
80 (0.051)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
81 (0.060)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
82 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=25244' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
83 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
84 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
85 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
86 (0.047)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
87 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
88 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
89 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
90 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
91 (0.058)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
92 (0.046)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
93 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
94 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
95 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
96 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
97 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
98 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
99 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
100 (0.037)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
101 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
102 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
103 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
104 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
105 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
106 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
107 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
108 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
109 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
110 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
111 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
112 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
113 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
114 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
115 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
116 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
117 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
118 (0.049)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
119 (0.061)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
120 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
121 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
122 (0.057)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
123 (21.133)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
124 (22.133)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
125 (23.953)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '19'
/home/pingas/liepinmaja_public_html/catalog/model/journal3/module.php:8
126 (0.472)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
127 (0.423)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/category' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
128 (0.811)
SELECT COUNT(DISTINCT p.product_id) total
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '5209'
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
129 (1.435)
SELECT MIN(COALESCE( ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) , ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) , p.price)) AS min, MAX(COALESCE( ( SELECT price
FROM `oc_product_special` ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '8' 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 ) , ( SELECT price
FROM `oc_product_discount` pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 ) , p.price)) AS max
FROM `oc_product` p
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '5209'
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
130 (21.435)
SELECT max(m.manufacturer_id) id, MAX(m.name) value, MAX(m.image) image, COUNT(*) total
FROM `oc_manufacturer` m
LEFT JOIN `oc_manufacturer_to_store` m2s ON (m.manufacturer_id = m2s.manufacturer_id)
LEFT JOIN `oc_product` p ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '5209' AND m2s.store_id = '0' GROUP BY m.manufacturer_id HAVING COUNT(*) > 0
ORDER BY m.sort_order ASC, m.name ASC
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
131 (26.334)
SELECT MAX(a.attribute_id) attribute_id, MAX(ad.name) attribute_name, MAX(pa.text) value, COUNT(*) total
FROM `oc_product` p
LEFT JOIN `oc_product_attribute` pa ON (p.product_id = pa.product_id)
LEFT JOIN `oc_attribute` a ON (a.attribute_id = pa.attribute_id)
LEFT JOIN `oc_attribute_description` ad ON (ad.attribute_id = a.attribute_id)
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '5209' AND pa.language_id = '2' AND ad.language_id = '2' GROUP BY lower(pa.text), a.attribute_id HAVING COUNT(*) > 0
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
132 (76.062)
SELECT MAX(pov.option_id) option_id, MAX(od.name) option_name, MAX(ovd.option_value_id) id, MAX(ovd.name) value, COUNT(*) total, ov.image image
FROM `oc_product` p
LEFT JOIN `oc_product_option_value` pov ON (p.product_id = pov.product_id)
LEFT JOIN `oc_option_value` ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN `oc_option_value_description` ovd ON (pov.option_value_id = ovd.option_value_id)
LEFT JOIN `oc_option_description` od ON (pov.option_id = od.option_id)
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '5209' AND od.language_id = '2' AND ovd.language_id = '2' GROUP BY pov.option_value_id HAVING COUNT(*) > 0
ORDER BY ov.sort_order, ovd.name
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
133 (28.081)
SELECT f.filter_id id, fd.name filter_name, fg.filter_group_id filter_group_id, fgd.name filter_group_name, COUNT(*) total
FROM `oc_product` p
LEFT JOIN `oc_product_filter` pf ON (p.product_id = pf.product_id)
LEFT JOIN `oc_filter` f ON (f.filter_id = pf.filter_id)
LEFT JOIN `oc_filter_description` fd ON (fd.filter_id = pf.filter_id)
LEFT JOIN `oc_filter_group` fg ON (fg.filter_group_id = fd.filter_group_id)
LEFT JOIN `oc_filter_group_description` fgd ON (fd.filter_group_id = fgd.filter_group_id)
LEFT JOIN `oc_product_to_category` p2c 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 p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND pd.language_id = '2' AND p2c.category_id = '5209' AND fd.language_id = '2' AND fgd.language_id = '2' GROUP BY pf.filter_id HAVING COUNT(*) > 0
ORDER BY f.sort_order, fd.name
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
134 (0.404)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/filter'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
135 (0.101)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
136 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
137 (0.048)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
138 (0.380)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
139 (0.390)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/column_left'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
140 (0.431)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
141 (0.394)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
142 (0.358)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/notification'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
143 (0.453)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
144 (21.802)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
145 (0.458)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
146 (16.063)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
147 (14.851)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/main_menu'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
148 (0.514)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
149 (0.316)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '0'
/home/pingas/liepinmaja_public_html/catalog/model/journal3/module.php:8
150 (0.406)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
151 (0.364)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
152 (0.415)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
153 (0.379)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
154 (0.396)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
155 (0.363)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
156 (0.397)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
157 (17.012)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/top_menu'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
158 (0.428)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
159 (0.395)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
160 (0.370)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
161 (0.419)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
162 (0.334)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/info_blocks'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
163 (0.371)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
164 (0.326)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
165 (0.358)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
166 (0.316)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
167 (0.387)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
168 (0.324)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/newsletter'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
169 (0.389)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
170 (0.348)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/links_menu'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
171 (0.364)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
172 (23.888)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/layout'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
173 (0.544)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/footer' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
174 (0.414)
SELECT *
FROM `oc_language`
/home/pingas/liepinmaja_public_html/system/library/advertikon/query.php:1400
175 (0.412)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/footer'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
176 (0.370)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
177 (0.341)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
178 (16.825)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
179 (0.458)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
180 (0.409)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/pingas/liepinmaja_public_html/catalog/model/setting/extension.php:4
181 (0.447)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
182 (0.456)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/language' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
183 (0.456)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/pingas/liepinmaja_public_html/catalog/model/localisation/language.php:15
184 (0.098)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
185 (0.071)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
186 (0.066)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
187 (0.400)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/language'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
188 (0.462)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/currency' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
189 (0.081)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=308' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
190 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=231' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
191 (0.065)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
192 (0.377)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/currency'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
193 (0.415)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/search' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
194 (0.336)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/search'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
195 (0.388)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/cart' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
196 (0.395)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
197 (0.369)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/pingas/liepinmaja_public_html/catalog/model/setting/extension.php:4
198 (0.393)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/sub_total' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
199 (0.378)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
200 (0.383)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
201 (0.384)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
202 (0.377)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
203 (0.387)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
204 (0.384)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
205 (0.367)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
206 (0.386)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
207 (0.382)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/credit' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
208 (0.297)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/pingas/liepinmaja_public_html/system/library/cart/customer.php:122
209 (0.360)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/total' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
210 (0.366)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
211 (0.342)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
212 (0.358)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
213 (0.415)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '2cc810a92fc099f42e0cb4f598'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
214 (0.315)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/cart'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
215 (1.112)
SELECT `key`, `value`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` like 'esi%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:42
216 (0.348)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
217 (0.291)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/menu'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
218 (0.102)
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 = '5209' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/pingas/liepinmaja_public_html/catalog/model/catalog/category.php:4
219 (1.586)
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 = '8' 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 = '8' 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 = '5209' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,12
/home/pingas/storage3032/modification/catalog/model/catalog/product.php:206
220 (1.605)
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 = '8' 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 = '8' 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 pr.customer_group_id = '8') 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 = '28061' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/pingas/storage3032/modification/catalog/model/catalog/product.php:8
221 (0.582)
SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level
FROM `oc_product_to_category` ptc
INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id
WHERE product_id = '28061'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
222 (0.462)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
223 (0.429)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
224 (0.394)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
225 (0.394)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
226 (0.407)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
227 (0.396)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
228 (0.406)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
229 (0.398)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
230 (0.398)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5728' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
231 (0.398)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5728' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
232 (0.384)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
233 (0.411)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
234 (0.383)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
235 (0.403)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
236 (0.391)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
237 (0.400)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
238 (0.366)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
239 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
240 (0.351)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
241 (0.351)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
242 (0.343)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
243 (0.362)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
244 (0.345)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5725' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
245 (0.359)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5725' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
246 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5728' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
247 (0.352)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5725' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
248 (0.357)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
249 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
250 (0.341)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
251 (0.365)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
252 (0.340)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5777' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
253 (0.354)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5777' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
254 (0.213)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28061'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
255 (0.440)
SELECT *, md.qty as quantity
FROM `oc_manufacturer_discount` md
INNER JOIN `oc_manufacturer` m ON md.manufacturer_id = m.manufacturer_id
WHERE md.status = '1' AND md.manufacturer_id = '318' AND md.customer_group_id = '8' AND ((md.date_start = '0000-00-00' OR md.date_start < NOW()) AND (qty = '0' OR qty = '1') AND (md.date_end = '0000-00-00' OR md.date_end > NOW()))
ORDER BY md.qty ASC, md.percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:817
256 (0.347)
SELECT *
FROM `oc_customer_group_discount`
WHERE status = '1' AND customer_group_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:835
257 (0.337)
SELECT percentage, qty as quantity
FROM `oc_volume_discount`
WHERE status = '1' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (qty = '0' OR qty = '1') AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY qty ASC, percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:846
258 (1.246)
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 = '8' 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 = '8' 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 pr.customer_group_id = '8') 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 = '24912' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/pingas/storage3032/modification/catalog/model/catalog/product.php:8
259 (0.451)
SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level
FROM `oc_product_to_category` ptc
INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id
WHERE product_id = '24912'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
260 (0.369)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
261 (0.376)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
262 (0.343)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
263 (0.376)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
264 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
265 (0.349)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
266 (0.372)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
267 (0.376)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
268 (0.358)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5728' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
269 (0.354)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5728' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
270 (0.339)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
271 (0.365)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
272 (0.344)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
273 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
274 (0.358)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
275 (0.413)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
276 (0.392)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
277 (0.374)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
278 (0.346)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
279 (0.374)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
280 (0.342)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
281 (0.362)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
282 (0.346)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5725' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
283 (0.347)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5725' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
284 (0.376)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5728' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
285 (0.354)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5725' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
286 (0.347)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
287 (0.368)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
288 (0.340)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
289 (0.355)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
290 (0.341)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5777' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
291 (0.354)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5777' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
292 (0.222)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '24912'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
293 (0.425)
SELECT *, md.qty as quantity
FROM `oc_manufacturer_discount` md
INNER JOIN `oc_manufacturer` m ON md.manufacturer_id = m.manufacturer_id
WHERE md.status = '1' AND md.manufacturer_id = '318' AND md.customer_group_id = '8' AND ((md.date_start = '0000-00-00' OR md.date_start < NOW()) AND (qty = '0' OR qty = '1') AND (md.date_end = '0000-00-00' OR md.date_end > NOW()))
ORDER BY md.qty ASC, md.percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:817
294 (0.325)
SELECT *
FROM `oc_customer_group_discount`
WHERE status = '1' AND customer_group_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:835
295 (0.335)
SELECT percentage, qty as quantity
FROM `oc_volume_discount`
WHERE status = '1' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (qty = '0' OR qty = '1') AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY qty ASC, percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:846
296 (1.250)
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 = '8' 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 = '8' 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 pr.customer_group_id = '8') 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 = '27194' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/pingas/storage3032/modification/catalog/model/catalog/product.php:8
297 (0.469)
SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level
FROM `oc_product_to_category` ptc
INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id
WHERE product_id = '27194'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
298 (0.376)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
299 (0.372)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
300 (0.344)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
301 (0.351)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
302 (0.355)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5753' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
303 (0.350)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5753' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
304 (0.339)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
305 (0.356)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
306 (0.343)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
307 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
308 (0.335)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5728' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
309 (0.340)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5728' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
310 (0.344)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
311 (0.342)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
312 (0.333)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
313 (0.349)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
314 (0.332)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5753' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
315 (0.345)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
316 (0.335)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
317 (0.339)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
318 (0.346)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
319 (0.344)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
320 (0.337)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
321 (0.359)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
322 (0.336)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
323 (0.337)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
324 (0.344)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5725' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
325 (0.345)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5725' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
326 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5728' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
327 (0.352)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5725' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
328 (0.340)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
329 (0.355)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
330 (0.331)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
331 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
332 (0.339)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5753' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
333 (0.342)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
334 (0.201)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '27194'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
335 (0.421)
SELECT *, md.qty as quantity
FROM `oc_manufacturer_discount` md
INNER JOIN `oc_manufacturer` m ON md.manufacturer_id = m.manufacturer_id
WHERE md.status = '1' AND md.manufacturer_id = '318' AND md.customer_group_id = '8' AND ((md.date_start = '0000-00-00' OR md.date_start < NOW()) AND (qty = '0' OR qty = '1') AND (md.date_end = '0000-00-00' OR md.date_end > NOW()))
ORDER BY md.qty ASC, md.percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:817
336 (0.356)
SELECT *
FROM `oc_customer_group_discount`
WHERE status = '1' AND customer_group_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:835
337 (0.326)
SELECT percentage, qty as quantity
FROM `oc_volume_discount`
WHERE status = '1' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (qty = '0' OR qty = '1') AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY qty ASC, percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:846
338 (0.112)
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 = '8' 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 = '8' 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 pr.customer_group_id = '8') 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 = '25244' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/pingas/storage3032/modification/catalog/model/catalog/product.php:8
339 (0.418)
SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level
FROM `oc_product_to_category` ptc
INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id
WHERE product_id = '25244'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
340 (0.363)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
341 (0.351)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
342 (0.342)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
343 (0.344)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
344 (0.332)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5753' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
345 (0.351)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5753' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
346 (0.336)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
347 (0.338)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
348 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
349 (0.343)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
350 (0.342)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5728' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
351 (0.346)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5728' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
352 (0.336)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
353 (0.354)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
354 (0.336)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
355 (0.340)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
356 (0.343)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5753' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
357 (0.341)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
358 (0.337)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5776' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
359 (0.349)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5776' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
360 (0.334)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
361 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
362 (0.339)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
363 (0.354)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
364 (0.344)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5209' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
365 (0.337)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
366 (0.328)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
367 (0.349)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
368 (0.331)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5725' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
369 (0.340)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5725' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
370 (0.338)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5728' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
371 (0.338)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5725' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
372 (0.383)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
373 (0.405)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
374 (0.335)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
375 (0.356)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
376 (0.335)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5753' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
377 (0.353)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
378 (0.336)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5776' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
379 (0.342)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
380 (0.247)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '25244'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
381 (0.453)
SELECT *, md.qty as quantity
FROM `oc_manufacturer_discount` md
INNER JOIN `oc_manufacturer` m ON md.manufacturer_id = m.manufacturer_id
WHERE md.status = '1' AND md.manufacturer_id = '318' AND md.customer_group_id = '8' AND ((md.date_start = '0000-00-00' OR md.date_start < NOW()) AND (qty = '0' OR qty = '1') AND (md.date_end = '0000-00-00' OR md.date_end > NOW()))
ORDER BY md.qty ASC, md.percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:817
382 (0.327)
SELECT *
FROM `oc_customer_group_discount`
WHERE status = '1' AND customer_group_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:835
383 (0.339)
SELECT percentage, qty as quantity
FROM `oc_volume_discount`
WHERE status = '1' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (qty = '0' OR qty = '1') AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY qty ASC, percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:846
384 (16.929)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'common/header'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
385 (0.453)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
386 (0.099)
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 = '5209' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/pingas/liepinmaja_public_html/catalog/model/catalog/category.php:4
387 (0.059)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5209' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
388 (16.115)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
389 (15.713)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
390 (0.452)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
391 (0.412)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
392 (0.997)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/pingas/liepinmaja_public_html/catalog/model/setting/setting.php:6
393 (0.302)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'extension/module/facebook_business'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
394 (0.301)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'product/category'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
395 (0.355)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
396 (0.349)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
397 (0.366)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
398 (1.018)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/pingas/liepinmaja_public_html/catalog/model/setting/setting.php:6