Menu
Jūsu grozs

3 - 6 gadi

Zīmols: Kids Concept
Instrumentu galds ir lieliski piemērots tiem, kam patīk galdniecība. Galdam ir caurumi, kur var piestiprināt skrūves, naglas un celtniecības plāksnes. Ir ripzāģis, kas griežas, pagriežot pogu.Satur: instrumentu galds, āmurs, skrūvgriezis, zāģis, uzgriežņu atslēga, smilšpapīra turētājs, 2 sm..
129,90€
Bez nodokļa:107,36€
Zīmols: Minikane
Minikane Amigas lelle Carol ir 32 cm gara skaistule ar brūniem matiem un skaistām acīmMinikane lelles ar rokām ražo spāņu zīmols Paola Reina, un tas atspoguļo augstu kvalitāti. Lellei raksturīga maiga, smalka vaniļas smaržaTāpat kā visas Minikane lelles, arī šī lelle ir izgatavota no vinila bez ftal..
31,95€
Bez nodokļa:26,40€
Zīmols: Minikane
Minikane Amigas lelle Liu ir 32 cm gara skaistule ar gariem melniem matiem un skaistām acīmMinikane lelles ar rokām ražo spāņu zīmols Paola Reina, un tas atspoguļo augstu kvalitāti. Lellei raksturīga maiga, smalka vaniļas smaržaTāpat kā visas Minikane lelles, arī šī lelle ir izgatavota no vinila bez..
39,95€
Bez nodokļa:33,02€
Zīmols: Minikane
Minikane Amigas lelle Liu ir 32 cm gara skaistule ar gariem melniem matiem un skaistām acīmMinikane lelles ar rokām ražo spāņu zīmols Paola Reina, un tas atspoguļo augstu kvalitāti. Lellei raksturīga maiga, smalka vaniļas smaržaTāpat kā visas Minikane lelles, arī šī lelle ir izgatavota no vinila bez..
39,95€
Bez nodokļa:33,02€
Zīmols: Minikane
Minikane Amigas lelle Mei ir 32 cm gara skaistule ar gariem gaišiem matiem un skaistām acīmMinikane lelles ar rokām ražo spāņu zīmols Paola Reina, un tas atspoguļo augstu kvalitāti. Lellei raksturīga maiga, smalka vaniļas smaržaTāpat kā visas Minikane lelles, arī šī lelle ir izgatavota no vinila bez..
31,95€
Bez nodokļa:26,40€
Zīmols: Minikane
Minikane Amigas lelle Nora ir 32 cm gara skaistule ar gariem taisniem tumšiem matiem un skaistām acīmMinikane lelles ar rokām ražo spāņu zīmols Paola Reina, un tas atspoguļo augstu kvalitāti. Lellei raksturīga maiga, smalka vaniļas smaržaTāpat kā visas Minikane lelles, arī šī lelle ir izgatavota no ..
31,95€
Bez nodokļa:26,40€
Zīmols: Minikane
Angele ir 34 cm gara vinila lelle ar zilpelēkām acīm, kas smaržo pēc vaniļasPieejama arī apģērba kolekcija, kas īpaši pielāgota lellei Matu krāsa: blonda, acu krāsa: zilpelēkaLelles rokas, galva un kājas ir kustīgasLielas izteiksmīgas acis, kas izgatavotas no drošas caurspīdīgas plastmasas; Lel..
32,95€
Bez nodokļa:27,23€
Zīmols: Minikane
Charline ir 37 cm gara vinila lelle ar pelēkām acīm, kas smaržo pēc vaniļasPieejama arī apģērba kolekcija, kas īpaši pielāgota lellei Matu krāsa: brūna, acu krāsa: pelēkasLelles rokas, galva un kājas ir kustīgasLielas izteiksmīgas acis, kas izgatavotas no drošas caurspīdīgas plastmasas; Lelles ..
59,95€
Bez nodokļa:49,55€
Zīmols: Minikane
Jade ir 34 cm gara vinila lelle, kas smaržo pēc vaniļasPieejama arī apģērba kolekcija, kas īpaši pielāgota lellei Matu krāsa: melnaLelles rokas, galva un kājas ir kustīgasLielas izteiksmīgas acis, kas izgatavotas no drošas caurspīdīgas plastmasas; Lelles acis neaizverasLelles ir ar rokām darinātas (..
32,95€
Bez nodokļa:27,23€
Zīmols: Minikane
Jaro ir 34 cm gara vinila lelle, kas smaržo pēc vaniļasPieejama arī apģērba kolekcija, kas īpaši pielāgota lelleiMatu krāsa: melna, acu krāsa: pelēkaLelles rokas, galva un kājas ir kustīgasLielas izteiksmīgas acis, kas izgatavotas no drošas caurspīdīgas plastmasas; Lelles acis neaizverasLelles ir ar..
32,95€
Bez nodokļa:27,23€
Zīmols: Minikane
Jules ir 34 cm gara vinila lelle ar brūnām acīm, kas smaržo pēc vaniļasPieejama arī apģērba kolekcija, kas īpaši pielāgota lelleiMatu krāsa: brūna, acu krāsa: brūnasLelles rokas, galva un kājas ir kustīgasLielas izteiksmīgas acis, kas izgatavotas no drošas caurspīdīgas plastmasas; Lelles acis neaizv..
32,95€
Bez nodokļa:27,23€
Zīmols: Minikane
Latika ir 34 cm gara vinila lelle ar pelēkām acīm, kas smaržo pēc vaniļasPieejama arī apģērba kolekcija, kas īpaši pielāgota lelleiMatu krāsa: melna, acu krāsa: pelēkaLelles rokas, galva un kājas ir kustīgasLielas izteiksmīgas acis, kas izgatavotas no drošas caurspīdīgas plastmasas; Lelles acis neai..
32,95€
Bez nodokļa:27,23€
Rāda no 1 līdz 12 kopā 487 (Kopā lapu - 41)
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: 687, Total time: 367.444 ms [By time] [By id] [By file]
1 (2.066)
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.429)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/pingas/liepinmaja_public_html/system/library/openbay.php:61
3 (0.888)
select value
from oc_setting
where `key` like "adk_%inline_translate"
/home/pingas/liepinmaja_public_html/system/library/advertikon/advertikon.php:3497
4 (0.426)
SELECT `data`
FROM `oc_session`
WHERE session_id = '7d99c00b82e6dc9eb1caec265c' AND expire > 1686251774
/home/pingas/liepinmaja_public_html/system/library/session/db.php:21
5 (0.334)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://liepinmaja.lv/'
/home/pingas/storage3032/modification/catalog/controller/startup/startup.php:6
6 (3.307)
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.419)
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.425)
SELECT *
FROM oc_currency
/home/pingas/liepinmaja_public_html/system/library/cart/currency.php:10
9 (0.938)
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.761)
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.489)
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.452)
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.400)
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.422)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/pingas/liepinmaja_public_html/system/library/openbay.php:61
15 (0.853)
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.128)
SELECT *
FROM oc_seo_url
WHERE keyword = 'Svinibas' AND store_id = '0'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:19
17 (0.056)
SELECT *
FROM oc_seo_url
WHERE keyword = 'Davanas' AND store_id = '0'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:19
18 (0.055)
SELECT *
FROM oc_seo_url
WHERE keyword = '3-6-gadi' AND store_id = '0'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:19
19 (0.669)
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.475)
SELECT count(*) AS total
FROM `oc_journal3_skin`
/home/pingas/liepinmaja_public_html/catalog/model/journal3/settings.php:112
21 (1.233)
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.114)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
23 (0.496)
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.462)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
25 (1.490)
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.495)
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.384)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '5752' AND store_id = '0'
/home/pingas/liepinmaja_public_html/catalog/model/catalog/category.php:55
28 (0.491)
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.402)
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.135)
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.429)
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.390)
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.242)
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.449)
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.132)
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.438)
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.122)
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.438)
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.107)
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.421)
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.119)
SELECT `key`, `value`, `serialized`
FROM oc_setting
WHERE store_id = '0' AND `code` = 'module_lscache' AND `key` not like 'esi%' AND `key` not like 'page%'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/lscache.php:108
42 (0.413)
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.109)
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.452)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
45 (1.112)
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.367)
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.045)
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 (0.992)
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.367)
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.122)
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 = '5724' 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.081)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
52 (0.076)
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 = '5749' 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.056)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
54 (0.052)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
55 (0.071)
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 = '5752' 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.067)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
57 (0.050)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' 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=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
59 (2.873)
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 = '5752' 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 (10.056)
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 = '5752'
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
61 (24.508)
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 = '5752' 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 (4.387)
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 (27141,28166,26654,26199,28169,28168,27501,26765,26114,26116,27500,26744) 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.098)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=341' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
64 (0.078)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
65 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
66 (0.051)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
67 (0.058)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=27141' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
68 (0.074)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=395' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
69 (0.051)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
70 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
71 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
72 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28166' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
73 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=395' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
74 (0.050)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
75 (0.045)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
76 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
77 (0.052)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=26654' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
78 (0.061)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=395' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
79 (0.058)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
80 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
81 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
82 (0.051)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=26199' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
83 (0.066)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=395' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
84 (0.050)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
85 (0.045)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
86 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
87 (0.068)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28169' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
88 (0.065)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=395' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
89 (0.051)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
90 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
91 (0.045)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
92 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28168' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
93 (0.065)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=395' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
94 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
95 (0.045)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
96 (0.046)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
97 (0.055)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=27501' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
98 (0.065)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=395' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
99 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
100 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
101 (0.045)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
102 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=26765' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
103 (0.083)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=395' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
104 (0.063)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
105 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
106 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
107 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=26114' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
108 (0.112)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=395' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
109 (0.056)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
110 (0.046)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
111 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
112 (0.048)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=26116' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
113 (0.061)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=395' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
114 (0.048)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
115 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
116 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' 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=27500' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
118 (0.060)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=395' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
119 (0.047)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
120 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
121 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
122 (0.048)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=26744' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
123 (0.054)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
124 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
125 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
126 (0.046)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
127 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
128 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
129 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
130 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
131 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
132 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
133 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
134 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
135 (0.048)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
136 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
137 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
138 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
139 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' 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=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
141 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
142 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
143 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
144 (0.053)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
145 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
146 (0.049)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
147 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
148 (0.041)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
149 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
150 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
151 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
152 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
153 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
154 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
155 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
156 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
157 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
158 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
159 (0.063)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
160 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
161 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
162 (0.049)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
163 (0.044)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
164 (0.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
165 (0.371)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
166 (0.269)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '19'
/home/pingas/liepinmaja_public_html/catalog/model/journal3/module.php:8
167 (0.323)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
168 (0.312)
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 (5.849)
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 = '5752'
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
170 (26.691)
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 = '5752'
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
171 (7.227)
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 = '5752' 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 (1.298)
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 = '5752' 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 (8.383)
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 = '5752' 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 (0.796)
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 = '5752' 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 (0.380)
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.117)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
177 (0.068)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
178 (0.048)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
179 (0.324)
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 (0.307)
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 (0.356)
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 (0.328)
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 (0.304)
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 (0.334)
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 (0.336)
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 (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
187 (0.321)
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 (0.301)
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 (0.359)
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 (0.255)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '0'
/home/pingas/liepinmaja_public_html/catalog/model/journal3/module.php:8
191 (0.349)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
192 (0.295)
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 (0.325)
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 (0.297)
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 (0.337)
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 (0.291)
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 (0.323)
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 (0.293)
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 (0.324)
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 (0.417)
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 (0.366)
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 (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
203 (0.290)
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 (0.317)
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 (0.282)
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 (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
207 (0.357)
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 (0.321)
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 (0.271)
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 (0.301)
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 (0.263)
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 (0.302)
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 (0.266)
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
214 (0.383)
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
215 (0.437)
SELECT *
FROM `oc_language`
/home/pingas/liepinmaja_public_html/system/library/advertikon/query.php:1400
216 (0.357)
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
217 (0.334)
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
218 (0.323)
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
219 (0.320)
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
220 (0.309)
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 (0.306)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/pingas/liepinmaja_public_html/catalog/model/setting/extension.php:4
222 (0.341)
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
223 (0.323)
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
224 (0.328)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/pingas/liepinmaja_public_html/catalog/model/localisation/language.php:15
225 (0.084)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
226 (0.062)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
227 (0.050)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
228 (0.304)
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
229 (0.393)
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
230 (0.063)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5724' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
231 (0.046)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5749' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
232 (0.043)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
233 (0.321)
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
234 (0.334)
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
235 (0.281)
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
236 (0.352)
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
237 (0.365)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
238 (0.323)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/pingas/liepinmaja_public_html/catalog/model/setting/extension.php:4
239 (0.365)
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
240 (0.334)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
241 (0.350)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
242 (0.320)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
243 (0.327)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
244 (0.350)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
245 (0.320)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
246 (0.306)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
247 (0.383)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
248 (0.341)
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
249 (0.273)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/pingas/liepinmaja_public_html/system/library/cart/customer.php:122
250 (0.322)
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
251 (0.329)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
252 (0.312)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
253 (0.308)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
254 (0.318)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '7d99c00b82e6dc9eb1caec265c'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
255 (0.348)
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
256 (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
257 (0.373)
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
258 (0.303)
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
259 (0.098)
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 = '5752' 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
260 (23.204)
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 = '5752' 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
261 (0.102)
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 = '27141' 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
262 (0.620)
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 = '27141'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
263 (0.472)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5566' 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
264 (0.431)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5566' 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
265 (0.369)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5686' 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
266 (0.389)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5686' 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
267 (0.386)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
268 (0.498)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
269 (0.406)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
270 (0.445)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
271 (0.486)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5566' 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
272 (0.445)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
273 (0.421)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5671' 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
274 (0.389)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5671' 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
275 (0.393)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5684' 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
276 (0.441)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5684' 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
277 (0.380)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5686' 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
278 (0.385)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5671' 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
279 (0.365)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.581)
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
281 (0.487)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
282 (0.469)
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
283 (0.402)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5769' 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
284 (0.396)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5769' 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
285 (0.402)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
286 (0.406)
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
287 (0.369)
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
288 (0.386)
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
289 (0.366)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5563' 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
290 (0.374)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5563' 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
291 (0.394)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5566' 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
292 (0.387)
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
293 (0.376)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5671' 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
294 (0.377)
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
295 (0.359)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5684' 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
296 (0.379)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5563' 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
297 (0.357)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5686' 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
298 (0.362)
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
299 (0.366)
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
300 (0.362)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
301 (0.365)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.367)
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
303 (0.370)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
304 (0.371)
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
305 (0.358)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5769' 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
306 (0.397)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5563' 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
307 (0.234)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '27141'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
308 (0.464)
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 = '341' 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
309 (0.367)
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
310 (0.356)
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
311 (0.134)
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 = '28166' 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
312 (0.474)
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 = '28166'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
313 (0.386)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
314 (0.368)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
315 (0.352)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
316 (0.365)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
317 (0.351)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
318 (0.372)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
319 (0.350)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
320 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
321 (0.368)
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
322 (0.364)
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
323 (0.365)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
324 (0.375)
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
325 (0.381)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
326 (0.405)
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
327 (0.351)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
328 (0.364)
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
329 (0.355)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
330 (0.390)
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
331 (0.374)
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
332 (0.367)
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
333 (0.355)
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
334 (0.380)
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
335 (0.349)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
336 (0.365)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
337 (0.362)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5763' 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
338 (0.362)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5763' 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
339 (0.369)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
340 (0.359)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
341 (0.214)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28166'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
342 (0.441)
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 = '395' 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
343 (0.336)
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
344 (0.336)
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
345 (0.093)
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 = '26654' 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
346 (0.407)
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 = '26654'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
347 (0.398)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
348 (0.375)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
349 (0.362)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
350 (0.395)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
351 (0.357)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
352 (0.380)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
353 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
354 (0.397)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
355 (0.372)
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
356 (0.356)
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
357 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
358 (0.358)
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
359 (0.347)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
360 (0.368)
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
361 (0.345)
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
362 (0.376)
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
363 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
364 (0.356)
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
365 (0.359)
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
366 (0.357)
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
367 (0.349)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.370)
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
369 (0.351)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.370)
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
371 (0.507)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
372 (0.367)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
373 (0.217)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '26654'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
374 (0.423)
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 = '395' 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
375 (0.340)
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
376 (0.331)
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
377 (0.095)
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 = '26199' 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
378 (0.425)
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 = '26199'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
379 (0.367)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
380 (0.366)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
381 (0.354)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
382 (0.358)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
383 (0.365)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
384 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
385 (0.353)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
386 (0.369)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
387 (0.385)
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
388 (0.396)
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
389 (0.354)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
390 (0.365)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
391 (0.370)
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
392 (0.356)
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
393 (0.374)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
394 (0.367)
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
395 (0.359)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.383)
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
397 (0.353)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
398 (0.361)
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
399 (0.359)
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
400 (0.422)
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
401 (0.391)
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
402 (0.365)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
403 (0.366)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
404 (0.358)
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
405 (0.359)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
406 (0.361)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
407 (0.351)
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
408 (0.371)
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
409 (0.217)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '26199'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
410 (0.449)
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 = '395' 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
411 (0.355)
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
412 (0.337)
SELECT percentage, qty as quantity
FROM `oc_volume_discount`
WHERE status = '1' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (qty = '0' OR qty = '1') AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY qty ASC, percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:846
413 (0.125)
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 = '28169' 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
414 (0.414)
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 = '28169'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
415 (0.366)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
416 (0.372)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
417 (0.350)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
418 (0.369)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
419 (0.350)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
420 (0.357)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
421 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
422 (0.357)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
423 (0.347)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
424 (0.384)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND 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
425 (0.399)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
426 (0.397)
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
427 (23.799)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
428 (0.489)
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
429 (0.426)
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
430 (0.398)
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
431 (0.428)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
432 (0.402)
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
433 (0.374)
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
434 (0.397)
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
435 (0.352)
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
436 (0.357)
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
437 (0.395)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
438 (0.365)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
439 (0.479)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5763' 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
440 (0.444)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5763' 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
441 (0.407)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
442 (0.374)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
443 (0.226)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28169'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
444 (0.508)
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 = '395' 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
445 (0.411)
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
446 (0.407)
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
447 (0.194)
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 = '28168' 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
448 (0.481)
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 = '28168'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
449 (0.431)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
450 (0.381)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
451 (0.354)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
452 (0.381)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
453 (0.353)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
454 (0.450)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
455 (0.358)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
456 (0.359)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
457 (0.368)
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
458 (0.358)
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
459 (0.362)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
460 (0.358)
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
461 (0.345)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
462 (0.368)
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
463 (0.347)
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
464 (0.353)
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
465 (0.351)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
466 (0.356)
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
467 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.355)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
469 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.368)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
471 (0.345)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
472 (0.367)
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
473 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
474 (0.355)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
475 (0.229)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28168'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
476 (0.461)
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 = '395' 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
477 (0.353)
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
478 (0.396)
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
479 (0.121)
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 = '27501' 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
480 (0.460)
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 = '27501'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
481 (0.388)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
482 (0.380)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
483 (0.350)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
484 (0.358)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
485 (0.364)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
486 (0.359)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
487 (0.365)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
488 (0.364)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
489 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
490 (0.372)
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
491 (0.352)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
492 (0.387)
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
493 (0.350)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
494 (0.355)
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
495 (0.369)
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
496 (0.357)
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
497 (0.366)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
498 (0.390)
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
499 (0.406)
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
500 (0.420)
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
501 (0.407)
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
502 (0.447)
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
503 (0.417)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
504 (0.451)
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
505 (0.419)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
506 (0.437)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
507 (0.261)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '27501'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
508 (0.515)
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 = '395' 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
509 (0.403)
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
510 (0.392)
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
511 (0.148)
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 = '26765' 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
512 (0.489)
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 = '26765'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
513 (0.435)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
514 (0.455)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
515 (0.421)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
516 (0.455)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
517 (0.397)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
518 (0.411)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
519 (0.422)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
520 (0.418)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
521 (0.416)
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
522 (0.409)
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
523 (0.432)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
524 (0.429)
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
525 (0.388)
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
526 (0.374)
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
527 (0.350)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
528 (0.380)
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
529 (0.361)
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
530 (0.362)
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
531 (0.350)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
532 (0.352)
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
533 (0.364)
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
534 (0.357)
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
535 (0.351)
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
536 (0.371)
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
537 (0.347)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
538 (0.389)
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
539 (0.361)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
540 (0.358)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
541 (0.364)
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
542 (0.357)
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
543 (0.267)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '26765'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
544 (0.547)
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 = '395' 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
545 (0.344)
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
546 (0.347)
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
547 (0.132)
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 = '26114' 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
548 (0.521)
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 = '26114'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
549 (0.430)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
550 (0.423)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
551 (0.415)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
552 (0.441)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
553 (0.449)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
554 (0.449)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
555 (0.443)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
556 (0.432)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
557 (0.458)
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
558 (0.435)
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
559 (0.452)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
560 (0.441)
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
561 (0.479)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
562 (0.448)
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
563 (0.445)
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
564 (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
565 (0.436)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
566 (0.437)
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
567 (0.374)
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
568 (0.371)
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
569 (0.346)
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
570 (0.367)
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
571 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
572 (0.357)
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
573 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
574 (0.355)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
575 (0.229)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '26114'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
576 (0.441)
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 = '395' 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
577 (0.332)
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
578 (0.343)
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
579 (0.100)
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 = '26116' 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
580 (0.404)
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 = '26116'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
581 (0.380)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
582 (0.394)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
583 (0.375)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
584 (0.358)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
585 (0.369)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
586 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
587 (0.350)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
588 (0.392)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
589 (0.351)
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
590 (0.369)
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
591 (0.351)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.358)
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
593 (0.363)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
594 (0.356)
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
595 (0.347)
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
596 (0.373)
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
597 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
598 (0.373)
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
599 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
600 (0.355)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
601 (0.356)
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
602 (0.359)
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
603 (0.349)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
604 (0.373)
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
605 (0.347)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
606 (0.377)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
607 (0.218)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '26116'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
608 (0.426)
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 = '395' 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
609 (0.353)
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
610 (0.337)
SELECT percentage, qty as quantity
FROM `oc_volume_discount`
WHERE status = '1' AND customer_group_id = '8' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (qty = '0' OR qty = '1') AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY qty ASC, percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:846
611 (0.102)
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 = '27500' 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
612 (0.395)
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 = '27500'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
613 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
614 (0.368)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
615 (0.345)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
616 (0.349)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
617 (0.357)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
618 (0.364)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
619 (0.359)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
620 (0.359)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
621 (0.355)
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
622 (0.369)
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
623 (0.346)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
624 (0.350)
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
625 (0.397)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
626 (0.353)
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
627 (0.356)
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
628 (0.353)
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
629 (0.340)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
630 (0.366)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND 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
631 (0.340)
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
632 (0.346)
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
633 (0.354)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
634 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
635 (0.350)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
636 (0.379)
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
637 (0.231)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '27500'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
638 (0.445)
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 = '395' 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
639 (0.346)
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
640 (0.340)
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
641 (0.101)
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 = '26744' 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
642 (0.408)
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 = '26744'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
643 (0.381)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
644 (0.359)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
645 (0.346)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
646 (0.389)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
647 (0.432)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
648 (0.382)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
649 (0.356)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
650 (0.384)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
651 (0.358)
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
652 (0.361)
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
653 (0.352)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
654 (0.351)
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
655 (0.346)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
656 (0.369)
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
657 (0.344)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
658 (0.350)
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
659 (0.355)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5545' 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
660 (0.349)
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
661 (0.353)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
662 (0.352)
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
663 (0.341)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5749' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
664 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5724' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
665 (0.341)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5752' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
666 (0.350)
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
667 (0.351)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
668 (0.352)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5764' 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
669 (0.212)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '26744'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
670 (0.431)
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 = '395' 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
671 (0.327)
SELECT *
FROM `oc_customer_group_discount`
WHERE status = '1' AND customer_group_id = '0' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, percentage ASC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:835
672 (0.341)
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
673 (0.817)
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
674 (0.480)
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
675 (0.150)
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 = '5752' 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
676 (0.100)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5752' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
677 (0.518)
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
678 (0.384)
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
679 (0.320)
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
680 (0.310)
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
681 (0.910)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/pingas/liepinmaja_public_html/catalog/model/setting/setting.php:6
682 (0.289)
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
683 (0.389)
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
684 (0.403)
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
685 (0.401)
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
686 (0.402)
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
687 (0.878)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/pingas/liepinmaja_public_html/catalog/model/setting/setting.php:6