Menu
Jūsu grozs

Lacīši

Lacīte Contour Gold/Blue Lacīte Contour Gold/Blue
-30%
Zīmols: Done by Deer
Velcro stiprinājums nodrošina vieglu un ātru uzlikšanu kā arī noņemšanuŪdensizturīga un viegli tīrāmaMateriāli: 100% ftalātu brīvs poliuretāns Tīrīšana: mazgāt 30 CIzmēri: 36 cm x 26 cm..
8,36€ 11,95€
Bez nodokļa:6,91€
Lacīte Contour Grey
-30%
Zīmols: Done by Deer
Velcro stiprinājums nodrošina vieglu un ātru uzlikšanu kā arī noņemšanuŪdensizturīga un viegli tīrāmaMateriāli: 100% ftalātu brīvs poliuretāns Tīrīšana: mazgāt 30 CIzmēri: 42cm x 27,5cm..
8,36€ 11,95€
Bez nodokļa:6,91€
Zīmols: Elodie Details
Priekšējā kabata noķers krītošo ēdienuViegli noskalot vai notīrīt ar mitru lupatiņuMīksts velcro lipeklisIzturīgs un praktisks meteriāls100% mīksts poliesters Oeko-Tex (nesatur PVC)..
24,90€
Bez nodokļa:20,58€
Zīmols: Done by Deer
Izcils palīgs brīžos, kad mazulis apgūst ēsanas prasmes un zīmēšanas pasauliRegulējama aizdare, deēs gan zīdaiņiem, gan lielākiem bērniem.Materiāls: 100% poliesters ar PU pārklājumuIzmērs: garums priekšā: 34 cm. Piedurknes platums: 72 cmKopšana: delikāta mazgāšana 30°C..
21,95€
Bez nodokļa:18,14€
Zīmols: Done by Deer
Izcils palīgs brīžos, kad mazulis apgūst ēsanas prasmes un zīmēšanas pasauliRegulējama aizdare, deēs gan zīdaiņiem, gan lielākiem bērniemMateriāls: 100% poliesters ar PU pārklājumuIzmērs: garums priekšā: 34 cm. Piedurknes platums: 72 cmKopšana: delikāta mazgāšana 30°C..
21,95€
Bez nodokļa:18,14€
Zīmols: Done by Deer
Izcils palīgs brīžos, kad mazulis apgūst ēsanas prasmes un zīmēšanas pasauliRegulējama aizdare, derēs gan zīdaiņiem, gan lielākiem bērniemMateriāls: 100% poliesters ar PU pārklājumuIzmērs: garums priekšā: 34 cm. Piedurknes platums: 72 cmKopšana: delikāta mazgāšana 30°C..
21,95€
Bez nodokļa:18,14€
Zīmols: Done by Deer
Praktiska ūdensizturīga silikona lacīte ar kabatiņuMīksta un komfortable ar regulējamu izmēru kakla daļāTo var viegli noslaucīt vai mazgāt trauku mazgajamā mašīnāMateriāli: 100% silikons Tīrīšana: trauku mazgājamā mašīnā līdz 100°C. Temperatāras izturīgs no -40°C līdz +230°C..
10,95€
Bez nodokļa:9,05€
Zīmols: Elodie Details
Priekšējā kabata noķers krītošo ēdienuViegli noskalot vai notīrīt ar mitru lupatiņuMīksts velcro lipeklisIzturīgs un praktisks meteriāls100% mīksts poliesters Oeko-Tex (nesatur PVC)..
23,90€
Bez nodokļa:19,75€
Zīmols: Done by Deer
Praktiska ūdensizturīga silikona lacīte ar kabatiņuMīksta un komfortable ar regulējamu izmēru kakla daļāTo var viegli noslaucīt vai mazgāt trauku mazgajamā mašīnāMateriāli: 100% silikons Tīrīšana: trauku mazgājamā mašīnā līdz 100°C. Temperatāras izturīgs no -40°C līdz +230°C..
10,95€
Bez nodokļa:9,05€
Zīmols: Elodie Details
Priekšējā kabata noķers krītošo ēdienuMīksts velcro lipeklisIzturīgs un praktisks meteriālsViegli noskalot vai notīrīt ar mitru lupatiņu100% mīksts poliesters Oeko-Tex (nesatur PVC)..
24,90€
Bez nodokļa:20,58€
Lacīte White Design Letters Lacīte White Design Letters
-60%
Zīmols: Design Letters
Lacīte White Design LettersViegli tīrāma ar slapju lupatiņuViegli un ātra Velcro aizdareIzmēri: 28 x 38 cmMateriāli: laminēta kokvilna..
8,00€ 20,00€
Bez nodokļa:6,61€
Zīmols: Done by Deer
Praktiskas ūdensizturīgas silikona lacītes ar kabatiņuMīkstas un komfortablas ar regulējamu izmēru kakla daļāTos var viegli notīrīt vai mazgāt trauku mazgajamā mašīnāMateriāli: 100% silikons Tīrīšana: trauku mazgājamā mašīnā līdz 100°C. Temperatāras izturīgs no -40°C l..
24,95€
Bez nodokļa:20,62€
Rāda no 1 līdz 12 kopā 22 (Kopā lapu - 2)
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: 610, Total time: 4,965.081 ms [By time] [By id] [By file]
1 (2.427)
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.466)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/pingas/liepinmaja_public_html/system/library/openbay.php:61
3 (1.209)
select value
from oc_setting
where `key` like "adk_%inline_translate"
/home/pingas/liepinmaja_public_html/system/library/advertikon/advertikon.php:3497
4 (0.520)
SELECT `data`
FROM `oc_session`
WHERE session_id = '3832d834527303779995a40d01' AND expire > 1701521101
/home/pingas/liepinmaja_public_html/system/library/session/db.php:21
5 (0.391)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://liepinmaja.lv/'
/home/pingas/storage3032/modification/catalog/controller/startup/startup.php:6
6 (4.193)
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 (0.553)
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.448)
SELECT *
FROM oc_currency
/home/pingas/liepinmaja_public_html/system/library/cart/currency.php:10
9 (1.265)
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.869)
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 (0.593)
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 (0.565)
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 (0.607)
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.457)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/pingas/liepinmaja_public_html/system/library/openbay.php:61
15 (1.032)
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.167)
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.081)
SELECT *
FROM oc_seo_url
WHERE keyword = 'Apgerbs' AND store_id = '0'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:19
18 (1.007)
SELECT *
FROM oc_seo_url
WHERE keyword = 'Lacisi' AND store_id = '0'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:19
19 (0.638)
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 (0.724)
SELECT count(*) AS total
FROM `oc_journal3_skin`
/home/pingas/liepinmaja_public_html/catalog/model/journal3/settings.php:112
21 (1.741)
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 (1.211)
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 (0.448)
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 (0.473)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
25 (12.614)
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 (0.399)
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 (0.357)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '5550' AND store_id = '0'
/home/pingas/liepinmaja_public_html/catalog/model/catalog/category.php:55
28 (0.458)
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 (0.406)
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.075)
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.439)
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.351)
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.338)
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.374)
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.165)
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.352)
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.029)
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.318)
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.010)
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.335)
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.176)
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.329)
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.003)
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.346)
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.058)
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.362)
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.055)
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.024)
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.330)
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.132)
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.071)
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.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 = '75' 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.077)
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.088)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
55 (0.808)
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 = '5550' 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.109)
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.056)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' 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=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
59 (1.906)
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 = '5550' 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 (2.028)
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 = '5550'
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
61 (23.481)
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 = '5550' 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 (40.722)
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 (22904,24312,27421,27767,27768,27769,24959,23764,24961,27422,23650,26842) 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.136)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=334' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
64 (0.084)
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.071)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
66 (0.067)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
67 (0.074)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=22904' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
68 (0.102)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=334' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
69 (0.084)
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.069)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
71 (0.078)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
72 (0.075)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=24312' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
73 (0.178)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=50' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
74 (0.110)
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.080)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
76 (0.077)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
77 (0.092)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=27421' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
78 (0.141)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=334' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
79 (0.076)
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.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
81 (0.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
82 (0.059)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=27767' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
83 (0.114)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=334' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
84 (0.073)
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
85 (0.064)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
86 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
87 (0.061)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=27768' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
88 (0.155)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=334' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
89 (0.084)
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.073)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
91 (0.060)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
92 (0.067)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=27769' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
93 (0.131)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=334' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
94 (0.085)
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
95 (0.051)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
96 (0.051)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
97 (0.064)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=24959' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
98 (0.131)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=50' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
99 (0.067)
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
100 (0.057)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
101 (0.048)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
102 (0.060)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=23764' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
103 (0.115)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=334' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
104 (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
105 (0.052)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
106 (0.050)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
107 (0.058)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=24961' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
108 (0.099)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=50' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
109 (0.062)
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
110 (0.055)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
111 (0.048)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
112 (0.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=27422' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
113 (0.073)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=356' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
114 (0.055)
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
115 (0.056)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
116 (0.045)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
117 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=23650' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
118 (0.067)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=334' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
119 (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
120 (0.046)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
121 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
122 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=26842' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
123 (0.059)
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
124 (0.047)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
125 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
126 (0.050)
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
127 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
128 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
129 (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
130 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
131 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
132 (0.050)
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
133 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
134 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
135 (0.045)
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.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
137 (0.055)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
138 (0.049)
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
139 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
140 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
141 (0.048)
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
142 (0.047)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
143 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
144 (0.055)
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
145 (0.045)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
146 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
147 (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
148 (0.051)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
149 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
150 (0.045)
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
151 (0.045)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
152 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
153 (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
154 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
155 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
156 (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
157 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
158 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
159 (0.065)
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
160 (0.050)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
161 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
162 (0.051)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
163 (0.047)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
164 (72.990)
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
165 (106.852)
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 (94.922)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '19'
/home/pingas/liepinmaja_public_html/catalog/model/journal3/module.php:8
167 (52.794)
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 (36.821)
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
169 (53.135)
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 = '5550'
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
170 (139.602)
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 = '5550'
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
171 (48.416)
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 = '5550' 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
172 (51.232)
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 = '5550' 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
173 (170.488)
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 = '5550' 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
174 (52.120)
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 = '5550' 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
175 (51.917)
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
176 (0.122)
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
177 (0.059)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
178 (0.049)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
179 (47.651)
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
180 (24.403)
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
181 (58.033)
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
182 (33.943)
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
183 (17.057)
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
184 (67.457)
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
185 (97.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
186 (43.268)
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
187 (13.721)
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
188 (16.226)
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
189 (49.804)
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
190 (53.223)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '0'
/home/pingas/liepinmaja_public_html/catalog/model/journal3/module.php:8
191 (22.441)
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
192 (158.519)
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
193 (25.102)
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
194 (51.200)
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
195 (74.313)
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
196 (53.085)
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
197 (50.101)
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
198 (50.521)
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
199 (24.307)
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
200 (23.100)
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
201 (25.901)
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
202 (49.634)
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
203 (0.511)
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
204 (25.329)
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
205 (22.544)
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
206 (20.177)
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
207 (70.824)
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
208 (69.470)
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
209 (26.592)
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
210 (44.243)
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
211 (52.381)
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
212 (25.954)
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
213 (24.323)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/blocks'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
214 (23.037)
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
215 (27.663)
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
216 (0.474)
SELECT *
FROM `oc_language`
/home/pingas/liepinmaja_public_html/system/library/advertikon/query.php:1400
217 (0.523)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2023-12-02 11:45:06'
/home/pingas/liepinmaja_public_html/catalog/model/tool/online.php:4
218 (0.476)
REPLACE INTO `oc_customer_online` SET `ip` = '18.206.48.243', `customer_id` = '0', `url` = 'https://liepinmaja.lv/Produkti/Apgerbs/Lacisi', `referer` = '', `date_added` = '2023-12-02 12:45:06'
/home/pingas/liepinmaja_public_html/catalog/model/tool/online.php:6
219 (0.417)
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
220 (37.796)
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
221 (17.016)
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
222 (0.459)
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
223 (17.836)
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
224 (15.354)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/pingas/liepinmaja_public_html/catalog/model/setting/extension.php:4
225 (19.412)
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
226 (0.636)
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
227 (0.396)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/pingas/liepinmaja_public_html/catalog/model/localisation/language.php:15
228 (0.119)
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
229 (0.093)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
230 (0.083)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
231 (24.806)
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
232 (25.469)
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
233 (0.111)
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
234 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=75' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
235 (0.057)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
236 (72.725)
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
237 (22.913)
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
238 (0.411)
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
239 (56.097)
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
240 (76.714)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
241 (24.791)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/pingas/liepinmaja_public_html/catalog/model/setting/extension.php:4
242 (24.734)
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
243 (0.562)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
244 (26.554)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
245 (24.566)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
246 (0.503)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
247 (0.464)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
248 (0.568)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
249 (0.480)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
250 (0.494)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
251 (0.447)
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
252 (13.546)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/pingas/liepinmaja_public_html/system/library/cart/customer.php:122
253 (77.488)
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
254 (0.593)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
255 (0.526)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
256 (0.503)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
257 (55.923)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '3832d834527303779995a40d01'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
258 (0.438)
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
259 (52.721)
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
260 (0.650)
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
261 (0.450)
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
262 (0.144)
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 = '5550' 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
263 (96.693)
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 = '5550' 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
264 (0.185)
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 = '22904' 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
265 (45.991)
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 = '22904'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
266 (28.631)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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 (51.269)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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 (26.438)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.543)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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 (53.399)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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.608)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.491)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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.490)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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.490)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5757' 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 (25.093)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5757' 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 (99.820)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5770' 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.605)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5770' 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.463)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.459)
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.419)
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
281 (0.446)
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
282 (0.436)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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.463)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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.448)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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.450)
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
286 (23.805)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5662' 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.558)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5662' 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.450)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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.451)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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.419)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5757' 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.425)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5662' 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 (47.121)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5770' 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
293 (56.115)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
294 (0.420)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '22904'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
295 (0.736)
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 = '334' 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
296 (25.103)
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
297 (107.811)
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
298 (0.210)
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 = '24312' 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
299 (102.033)
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 = '24312'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
300 (23.526)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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.729)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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.540)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.497)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.501)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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.471)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.591)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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.503)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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 (25.350)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5757' 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.547)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5757' 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.483)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5770' 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.501)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5770' 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.466)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.476)
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
314 (0.423)
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
315 (0.528)
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
316 (0.488)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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 (25.119)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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 (26.609)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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 (24.830)
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 (27.630)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5662' 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 (26.245)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5662' 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.553)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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.488)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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.461)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5757' 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.447)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5662' 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 (25.282)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5770' 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 (24.955)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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 (26.828)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '24312'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
329 (0.892)
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 = '334' 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
330 (0.534)
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
331 (26.169)
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
332 (26.019)
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 = '27421' 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
333 (0.679)
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 = '27421'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
334 (0.562)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
335 (0.584)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
336 (0.509)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5751' 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
337 (45.575)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5751' 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
338 (25.951)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
339 (1.110)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
340 (0.582)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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.562)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.555)
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
343 (0.515)
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
344 (0.544)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5751' 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.586)
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
346 (0.512)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.534)
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
348 (0.614)
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
349 (0.566)
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
350 (0.541)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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.678)
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
352 (0.552)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5660' 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.546)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5660' 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.503)
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
355 (0.554)
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
356 (0.510)
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
357 (0.529)
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
358 (0.503)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5751' 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.540)
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
360 (0.336)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '27421'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
361 (0.647)
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 = '50' 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
362 (0.477)
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
363 (0.492)
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
364 (2.295)
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 = '27767' 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
365 (7.921)
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 = '27767'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
366 (0.662)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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.593)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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.575)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.517)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.551)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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.512)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.540)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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.555)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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.561)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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.563)
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
376 (0.549)
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
377 (0.559)
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
378 (0.553)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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.571)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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.570)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
381 (0.550)
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
382 (0.538)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
383 (0.526)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
384 (0.723)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '27767'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
385 (0.680)
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 = '334' 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
386 (0.499)
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
387 (0.508)
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
388 (2.367)
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 = '27768' 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
389 (0.660)
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 = '27768'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
390 (0.579)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
391 (0.588)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
392 (0.524)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
393 (0.546)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
394 (0.559)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
395 (0.551)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
396 (0.562)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
397 (0.537)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
398 (0.544)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
399 (0.547)
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
400 (0.522)
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
401 (0.552)
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
402 (0.537)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
403 (0.606)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
404 (0.575)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
405 (0.562)
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
406 (0.526)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
407 (0.550)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
408 (0.388)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '27768'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
409 (0.690)
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 = '334' 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
410 (0.503)
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
411 (0.500)
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
412 (2.135)
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 = '27769' 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
413 (0.690)
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 = '27769'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
414 (0.575)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
415 (0.547)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
416 (0.527)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
417 (0.524)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
418 (0.525)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
419 (0.545)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
420 (0.527)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
421 (0.554)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
422 (0.532)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
423 (0.590)
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
424 (0.533)
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
425 (0.552)
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
426 (0.497)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
427 (0.510)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
428 (0.519)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
429 (0.562)
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
430 (0.550)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
431 (0.514)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
432 (0.349)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '27769'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
433 (0.660)
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 = '334' 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
434 (0.499)
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
435 (0.509)
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
436 (2.230)
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 = '24959' 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
437 (0.733)
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 = '24959'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
438 (0.591)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
439 (0.535)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
440 (0.516)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
441 (0.596)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
442 (0.557)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
443 (0.564)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
444 (0.552)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
445 (0.551)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
446 (0.553)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
447 (0.544)
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
448 (0.576)
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
449 (0.544)
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
450 (0.531)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
451 (0.547)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
452 (0.537)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
453 (0.562)
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
454 (0.798)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
455 (0.656)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
456 (0.485)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '24959'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
457 (0.747)
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 = '334' 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
458 (0.574)
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
459 (0.548)
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
460 (2.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 = '23764' 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
461 (0.788)
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 = '23764'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
462 (0.560)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
463 (0.612)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
464 (0.595)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
465 (0.546)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
466 (0.543)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '255' 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
467 (0.572)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '255' 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
468 (0.541)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
469 (0.564)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
470 (0.536)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' 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
471 (0.545)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' 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
472 (0.557)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
473 (0.539)
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
474 (0.537)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '255' 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
475 (0.557)
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
476 (0.493)
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
477 (0.529)
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
478 (0.576)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
479 (0.522)
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
480 (0.511)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5660' 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
481 (0.544)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5660' 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
482 (0.500)
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
483 (0.574)
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
484 (0.510)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' 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
485 (0.505)
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
486 (0.310)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '23764'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
487 (0.615)
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 = '50' 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
488 (0.469)
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
489 (0.466)
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
490 (1.900)
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 = '24961' 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
491 (0.645)
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 = '24961'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
492 (17.881)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
493 (0.594)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
494 (0.550)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
495 (0.572)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
496 (0.618)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '255' 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
497 (0.625)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '255' 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
498 (0.572)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
499 (0.563)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
500 (0.556)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
501 (0.575)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
502 (0.565)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
503 (0.616)
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
504 (0.567)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '255' 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
505 (0.597)
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
506 (0.591)
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
507 (0.594)
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
508 (0.594)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
509 (0.606)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
510 (0.593)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
511 (0.648)
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
512 (0.590)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
513 (0.607)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
514 (0.418)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '24961'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
515 (0.740)
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 = '334' 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
516 (0.570)
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
517 (0.556)
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
518 (2.015)
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 = '27422' 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
519 (0.691)
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 = '27422'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
520 (0.599)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
521 (0.608)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
522 (18.652)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
523 (0.712)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
524 (16.946)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
525 (0.649)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
526 (0.593)
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
527 (0.652)
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
528 (0.581)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
529 (0.629)
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
530 (0.591)
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
531 (0.596)
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
532 (0.619)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
533 (0.622)
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
534 (0.585)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5660' 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
535 (0.608)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5660' 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
536 (0.595)
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
537 (0.614)
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
538 (0.612)
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
539 (0.612)
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
540 (0.401)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '27422'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
541 (0.757)
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 = '50' 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
542 (0.578)
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
543 (0.602)
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
544 (2.060)
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 = '23650' 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
545 (0.677)
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 = '23650'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
546 (0.616)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
547 (0.758)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
548 (0.633)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
549 (0.604)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
550 (0.608)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
551 (0.624)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
552 (0.643)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5760' 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
553 (0.648)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5760' 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
554 (0.633)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
555 (0.621)
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
556 (0.625)
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
557 (0.591)
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
558 (0.566)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
559 (0.594)
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
560 (0.586)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5662' 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
561 (0.612)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5662' 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
562 (0.626)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5760' 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
563 (0.577)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5662' 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
564 (0.381)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '23650'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
565 (0.682)
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 = '356' 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
566 (0.531)
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
567 (0.542)
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
568 (27.277)
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 = '26842' 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
569 (24.277)
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 = '26842'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
570 (24.618)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
571 (0.795)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
572 (0.655)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
573 (0.635)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
574 (0.616)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
575 (0.567)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
576 (0.582)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
577 (0.570)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
578 (0.533)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5770' 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
579 (0.528)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5770' 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
580 (0.522)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '75' 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
581 (0.503)
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
582 (0.523)
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
583 (0.536)
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
584 (0.586)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
585 (0.599)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
586 (0.536)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5550' 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
587 (0.574)
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
588 (0.594)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5699' 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
589 (0.605)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
590 (0.573)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5770' 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
591 (0.604)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5547' 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
592 (0.386)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '26842'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
593 (0.711)
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 = '334' 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
594 (0.559)
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
595 (0.515)
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
596 (6.378)
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
597 (23.497)
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
598 (0.121)
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 = '5550' 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
599 (0.092)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5550' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
600 (20.280)
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
601 (26.819)
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
602 (27.285)
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
603 (24.466)
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
604 (27.466)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/pingas/liepinmaja_public_html/catalog/model/setting/setting.php:6
605 (0.346)
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
606 (0.273)
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
607 (0.282)
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
608 (0.305)
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
609 (0.308)
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
610 (0.822)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/pingas/liepinmaja_public_html/catalog/model/setting/setting.php:6