Menu
Jūsu grozs

Olli Ella

Zīmols: Olli Ella
Cozy Dinkums var pozēt vairākās miega pozīcijāsGalvu, rokas un kājas ar auduma lenti savienotas ar ķermeniIzgatavots no kokvilnas, pildījumā ir poliestera šķiedras un plastmasas granulasCozy Dinkums valkā nenovelkamu kokvilnas ausainu kombinezonu ar izšūtu varavīksni sirds zonāSejā ir iz..
49,90€
Bez nodokļa:41,24€
Zīmols: Olli Ella
Cozy Dinkums var pozēt vairākās miega pozīcijāsGalvu, rokas un kājas ar auduma lenti savienotas ar ķermeniIzgatavots no kokvilnas, pildījumā ir poliestera šķiedras un plastmasas granulasCozy Dinkums valkā nenovelkamu kokvilnas ausainu kombinezonu ar izšūtu varavīksni sirds zonāSejā ir iz..
49,90€
Bez nodokļa:41,24€
Zīmols: Olli Ella
Cozy Dinkums var pozēt vairākās miega pozīcijās, galvu, rokas un kājas ar auduma lenti savienotas ar ķermeniIzgatavots no kokvilnas, pildījumā ir poliestera šķiedras un plastmasas granulasCozy Dinkums valkā nenovelkamu kokvilnas ausainu kombinezonuSejā ir izšūtas acis, mute un ovāls degu..
49,90€
Bez nodokļa:41,24€
Zīmols: Olli Ella
Cozy Dinkums var pozēt vairākās miega pozīcijāsGalvu, rokas un kājas ar auduma lenti savienotas ar ķermeniIzgatavots no kokvilnas, pildījumā ir poliestera šķiedras un plastmasas granulasCozy Dinkums valkā nenovelkamu kokvilnas ausainu kombinezonu ar izšūtu varavīksni sirds zonāSejā ir iz..
49,90€
Bez nodokļa:41,24€
Zīmols: Olli Ella
Cozy Dinkums var pozēt vairākās miega pozīcijās, galvu, rokas un kājas ar auduma lenti savienotas ar ķermeniIzgatavots no kokvilnas, pildījumā ir poliestera šķiedras un plastmasas granulasCozy Dinkums valkā nenovelkamu kokvilnas ausainu kombinezonuSejā ir izšūtas acis, mute un ovāls degu..
49,90€
Bez nodokļa:41,24€
Zīmols: Olli Ella
Unikāls, nenoņemams tērpsizgatavots no kokvilnas un poliesteraIepakots papīra maisiņāPiemērots VISIEMIzmēri: 22cm x 12cm x 8cmSvars: 0,16 kgMazgāt ar aukstu ūdeni vieglā veļasmašīnas režīmā veļas maisiņā, Dinky Dinkums lellēm patīk virpuļi cikla beigāsIzņemiet no maisiņa un novietojiet horizontālā s..
24,90€
Bez nodokļa:20,58€
Zīmols: Olli Ella
Unikāls, nenoņemams tērpsizgatavots no kokvilnas un poliesteraIepakots papīra maisiņā īpaši jautra birka "paberzē un paosti"Piemērots VISIEMIzmēri: 22cm x 12cm x 8cmSvars: 0,16 kgMazgāt ar aukstu ūdeni vieglā veļasmašīnas režīmā veļas maisiņā, Dinky Dinkums lellēm patīk virpuļi cikla beigāsIzņemiet ..
24,90€
Bez nodokļa:20,58€
Zīmols: Olli Ella
Unikāls, nenoņemams tērpsizgatavots no kokvilnas un poliesteraIepakots papīra maisiņā jautra birka "paberzē un paosti"Piemērots VISIEMIzmēri: 22cm x 12cm x 8cmSvars: 0,16 kgMazgāt ar aukstu ūdeni vieglā veļasmašīnas režīmā veļas maisiņā, Dinky Dinkums lellēm patīk virpuļi cikla beigāsIzņemiet no mai..
24,90€
Bez nodokļa:20,58€
Zīmols: Olli Ella
Unikāls, nenoņemams tērpsizgatavots no kokvilnas un poliesteraIepakots papīra maisiņāPiemērots VISIEMIzmēri: 22cm x 12cm x 8cmSvars: 0,16 kgMazgāt ar aukstu ūdeni vieglā veļasmašīnas režīmā veļas maisiņā, Dinky Dinkums lellēm patīk virpuļi cikla beigāsIzņemiet no maisiņa un novietojiet horizontālā s..
24,90€
Bez nodokļa:20,58€
Zīmols: Olli Ella
Unikāls, nenoņemams tērpsizgatavots no kokvilnas un poliesteraIepakots papīra maisiņā jautra birka "paberzē un paosti"Piemērots VISIEMIzmēri: 22cm x 12cm x 8cmSvars: 0,16 kgMazgāt ar aukstu ūdeni vieglā veļasmašīnas režīmā veļas maisiņā, Dinky Dinkums lellēm patīk virpuļi cikla beigāsIzņemiet no mai..
24,90€
Bez nodokļa:20,58€
Zīmols: Olli Ella
Unikāls, nenoņemams tērpsizgatavots no kokvilnas un poliesteraIepakots papīra maisiņāPiemērots VISIEMIzmēri: 22cm x 12cm x 8cmSvars: 0,16 kgMazgāt ar aukstu ūdeni vieglā veļasmašīnas režīmā veļas maisiņā, Dinky Dinkums lellēm patīk virpuļi cikla beigāsIzņemiet no maisiņa un novietojiet horizontālā s..
24,90€
Bez nodokļa:20,58€
Zīmols: Olli Ella
Unikāls, nenoņemams tērpsizgatavots no kokvilnas un poliesteraIepakots papīra maisiņā jautra birka "paberzē un paosti"Piemērots VISIEMIzmēri: 22cm x 12cm x 8cmSvars: 0,16 kgMazgāt ar aukstu ūdeni vieglā veļasmašīnas režīmā veļas maisiņā, Dinky Dinkums lellēm patīk virpuļi cikla beigāsIzņemiet no mai..
24,90€
Bez nodokļa:20,58€
Rāda no 1 līdz 12 kopā 106 (Kopā lapu - 9)
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: 503, Total time: 551.363 ms [By time] [By id] [By file]
1 (16.388)
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.524)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/pingas/liepinmaja_public_html/system/library/openbay.php:61
3 (1.810)
select value
from oc_setting
where `key` like "adk_%inline_translate"
/home/pingas/liepinmaja_public_html/system/library/advertikon/advertikon.php:3497
4 (0.731)
SELECT `data`
FROM `oc_session`
WHERE session_id = '513f385c5fcf248abc25140381' AND expire > 1695946140
/home/pingas/liepinmaja_public_html/system/library/session/db.php:21
5 (0.387)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://liepinmaja.lv/'
/home/pingas/storage3032/modification/catalog/controller/startup/startup.php:6
6 (4.641)
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.488)
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.363)
SELECT *
FROM oc_currency
/home/pingas/liepinmaja_public_html/system/library/cart/currency.php:10
9 (1.141)
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.766)
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.500)
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.516)
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 (23.889)
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.562)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/pingas/liepinmaja_public_html/system/library/openbay.php:61
15 (0.877)
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.817)
SELECT *
FROM oc_seo_url
WHERE keyword = 'OE-viss' AND store_id = '0'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:19
17 (0.504)
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
18 (0.650)
SELECT count(*) AS total
FROM `oc_journal3_skin`
/home/pingas/liepinmaja_public_html/catalog/model/journal3/settings.php:112
19 (23.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
20 (23.876)
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
21 (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
22 (0.447)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
23 (1.523)
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
24 (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
25 (27.678)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '5658' AND store_id = '0'
/home/pingas/liepinmaja_public_html/catalog/model/catalog/category.php:55
26 (0.492)
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
27 (0.511)
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
28 (1.056)
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
29 (0.298)
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
30 (0.252)
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
31 (0.845)
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
32 (0.228)
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
33 (0.797)
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.246)
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 (0.759)
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.205)
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 (0.721)
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.210)
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 (0.737)
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.241)
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 (0.759)
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.211)
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 (0.754)
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.266)
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 (0.762)
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.757)
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
47 (0.247)
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
48 (0.185)
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 = '5658' 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
49 (0.046)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
50 (0.046)
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 = '5658' 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
51 (2.301)
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 = '5658'
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
52 (4.600)
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 = '5658' 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
53 (2.988)
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 (28249,27528,28357,27529,28358,28610,28351,28352,28613,28353,28612,28354) 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
54 (0.085)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=355' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
55 (0.051)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
56 (0.154)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28249' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
57 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=355' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
58 (0.029)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
59 (0.155)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=27528' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
60 (0.039)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=355' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
61 (0.029)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
62 (0.113)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28357' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
63 (0.037)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=355' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
64 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
65 (0.122)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=27529' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
66 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=355' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
67 (0.031)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
68 (0.114)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28358' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
69 (0.036)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=355' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
70 (0.029)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
71 (0.128)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28610' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
72 (0.037)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=355' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
73 (0.029)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
74 (0.117)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28351' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
75 (0.042)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=355' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
76 (0.032)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
77 (0.118)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28352' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
78 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=355' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
79 (0.030)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
80 (0.115)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28613' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
81 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=355' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
82 (0.032)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
83 (0.126)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28353' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
84 (0.037)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=355' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
85 (0.029)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
86 (0.110)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28612' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
87 (0.038)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=355' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
88 (0.029)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
89 (0.113)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=28354' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:132
90 (0.033)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
91 (0.027)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
92 (0.028)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
93 (0.025)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
94 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
95 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
96 (0.040)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
97 (0.031)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
98 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
99 (0.025)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
100 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
101 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
102 (0.048)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
103 (0.030)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
104 (0.026)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
105 (0.706)
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
106 (0.219)
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
107 (0.346)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '19'
/home/pingas/liepinmaja_public_html/catalog/model/journal3/module.php:8
108 (0.284)
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
109 (0.224)
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
110 (1.439)
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 = '5658'
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
111 (4.709)
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 = '5658'
/home/pingas/liepinmaja_public_html/system/library/journal3/opencart/model.php:48
112 (1.702)
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 = '5658' 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
113 (25.304)
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 = '5658' 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
114 (73.125)
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 = '5658' 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
115 (117.961)
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 = '5658' 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
116 (0.349)
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
117 (0.118)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
118 (0.218)
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
119 (0.245)
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
120 (0.279)
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
121 (0.270)
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
122 (0.215)
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
123 (0.249)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
124 (0.233)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
125 (0.225)
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
126 (0.229)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
127 (0.239)
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
128 (0.254)
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
129 (0.215)
SELECT *
FROM `oc_journal3_module`
WHERE `module_id` = '0'
/home/pingas/liepinmaja_public_html/catalog/model/journal3/module.php:8
130 (0.220)
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
131 (0.206)
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
132 (0.225)
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
133 (0.250)
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
134 (0.215)
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
135 (0.223)
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
136 (0.223)
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
137 (0.194)
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
138 (0.212)
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
139 (0.224)
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
140 (0.214)
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
141 (0.224)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
142 (0.208)
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
143 (0.241)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
144 (0.215)
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
145 (0.238)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
146 (0.199)
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
147 (0.228)
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
148 (0.205)
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
149 (0.250)
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
150 (0.217)
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
151 (0.226)
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
152 (0.206)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'journal3' AND route = 'journal3/module/blocks'
/home/pingas/liepinmaja_public_html/catalog/model/design/theme.php:4
153 (0.259)
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
154 (0.259)
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
155 (0.267)
SELECT *
FROM `oc_language`
/home/pingas/liepinmaja_public_html/system/library/advertikon/query.php:1400
156 (0.258)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2023-09-28 23:09:01'
/home/pingas/liepinmaja_public_html/catalog/model/tool/online.php:4
157 (0.294)
REPLACE INTO `oc_customer_online` SET `ip` = '77.75.78.164', `customer_id` = '0', `url` = 'https://liepinmaja.lv/OE-viss', `referer` = '', `date_added` = '2023-09-29 00:09:01'
/home/pingas/liepinmaja_public_html/catalog/model/tool/online.php:6
158 (0.266)
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
159 (0.418)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
160 (0.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
161 (0.250)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
162 (0.248)
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
163 (0.244)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/pingas/liepinmaja_public_html/catalog/model/setting/extension.php:4
164 (0.255)
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
165 (0.246)
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
166 (0.308)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/home/pingas/liepinmaja_public_html/catalog/model/localisation/language.php:15
167 (0.088)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
168 (0.243)
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
169 (0.290)
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
170 (0.068)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
171 (0.226)
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
172 (0.254)
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
173 (0.230)
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
174 (0.252)
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
175 (0.315)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
176 (0.229)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/pingas/liepinmaja_public_html/catalog/model/setting/extension.php:4
177 (0.263)
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
178 (0.259)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
179 (0.267)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
180 (0.266)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
181 (0.305)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
182 (0.257)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
183 (1.110)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
184 (0.244)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
185 (0.242)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
186 (0.260)
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
187 (0.265)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/pingas/liepinmaja_public_html/system/library/cart/customer.php:122
188 (0.251)
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
189 (0.254)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
190 (0.228)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
191 (0.240)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
192 (0.223)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '513f385c5fcf248abc25140381'
/home/pingas/storage3032/modification/system/library/cart/cart.php:43
193 (0.220)
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
194 (0.985)
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
195 (0.261)
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
196 (0.219)
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
197 (0.113)
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 = '5658' 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
198 (5.190)
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 = '5658' 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
199 (1.229)
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 = '28249' 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
200 (0.450)
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 = '28249'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
201 (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 ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
202 (0.304)
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
203 (0.284)
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
204 (0.336)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
205 (0.293)
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
206 (0.293)
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
207 (0.345)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
208 (0.302)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
209 (0.313)
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
210 (0.295)
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
211 (0.305)
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
212 (0.281)
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
213 (0.254)
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
214 (0.265)
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
215 (0.315)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
216 (0.324)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
217 (0.311)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
218 (0.314)
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
219 (0.218)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28249'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
220 (0.548)
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 = '355' 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
221 (0.386)
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
222 (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
223 (1.910)
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 = '27528' 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
224 (0.549)
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 = '27528'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
225 (0.406)
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
226 (0.376)
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
227 (0.377)
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
228 (0.378)
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
229 (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
230 (0.389)
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
231 (0.408)
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
232 (0.452)
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
233 (0.424)
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
234 (0.401)
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
235 (0.455)
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
236 (0.439)
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
237 (0.405)
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
238 (0.396)
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
239 (0.430)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
240 (0.416)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
241 (0.347)
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
242 (0.361)
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
243 (0.224)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '27528'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
244 (0.409)
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 = '355' 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
245 (0.328)
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
246 (0.314)
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
247 (1.346)
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 = '28357' 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
248 (0.449)
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 = '28357'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
249 (0.551)
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
250 (0.404)
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
251 (0.310)
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
252 (0.279)
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
253 (0.265)
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
254 (0.275)
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
255 (0.293)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
256 (0.327)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
257 (0.322)
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
258 (0.317)
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
259 (0.307)
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
260 (0.328)
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
261 (0.308)
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
262 (0.315)
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
263 (0.321)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.316)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.313)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
266 (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
267 (0.205)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28357'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
268 (0.396)
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 = '355' 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
269 (0.322)
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
270 (0.301)
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
271 (1.183)
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 = '27529' 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
272 (0.380)
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 = '27529'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
273 (0.336)
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
274 (0.337)
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
275 (0.323)
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
276 (0.323)
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
277 (0.325)
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
278 (0.321)
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
279 (0.315)
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
280 (0.332)
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
281 (0.311)
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
282 (0.318)
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
283 (0.316)
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
284 (18.276)
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
285 (0.381)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.284)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.181)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '27529'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
288 (0.335)
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 = '355' 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
289 (0.280)
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
290 (0.258)
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
291 (1.014)
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 = '28358' 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
292 (0.349)
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 = '28358'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
293 (0.280)
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
294 (0.275)
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
295 (0.277)
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
296 (0.274)
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
297 (0.264)
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
298 (0.267)
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
299 (0.311)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
300 (0.267)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
301 (0.260)
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
302 (0.277)
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
303 (0.262)
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
304 (0.272)
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
305 (0.261)
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
306 (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
307 (0.348)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
308 (0.363)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
309 (0.337)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
310 (1.253)
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
311 (0.222)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28358'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
312 (0.422)
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 = '355' 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
313 (0.326)
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
314 (0.358)
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
315 (1.306)
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 = '28610' 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
316 (1.144)
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 = '28610'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
317 (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
318 (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 affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.349)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.344)
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.334)
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
322 (0.407)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.338)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
324 (0.342)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
325 (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
326 (0.340)
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.331)
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.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
329 (0.337)
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.358)
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.340)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.343)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.347)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
334 (0.341)
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.337)
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
336 (0.353)
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
337 (0.208)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28610'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
338 (0.415)
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 = '355' 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
339 (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
340 (0.321)
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
341 (0.229)
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 = '28351' 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
342 (0.452)
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 = '28351'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
343 (0.361)
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
344 (0.406)
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
345 (0.349)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
346 (0.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
347 (0.343)
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.349)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
349 (0.345)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
350 (0.342)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
351 (1.115)
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.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
353 (0.343)
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
354 (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 affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.374)
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
356 (0.346)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.345)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.375)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.339)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
360 (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
361 (0.226)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28351'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
362 (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 = '355' 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
363 (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
364 (0.376)
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
365 (0.217)
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 = '28352' 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
366 (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 = '28352'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
367 (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
368 (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 affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.332)
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
370 (0.341)
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
371 (0.369)
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
372 (0.338)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '231' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
373 (0.331)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
374 (1.166)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
375 (0.362)
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
376 (0.343)
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
377 (0.342)
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
378 (0.341)
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
379 (0.333)
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.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
381 (0.370)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.392)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.375)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
384 (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
385 (0.259)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28352'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
386 (0.473)
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 = '355' 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
387 (0.416)
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
388 (0.355)
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
389 (1.805)
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 = '28613' 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
390 (0.679)
SELECT ptc.category_id as category_id, cp.path_id as parent_id, cp.level
FROM `oc_product_to_category` ptc
INNER JOIN `oc_category_path` cp ON ptc.category_id = cp.category_id
WHERE product_id = '28613'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
391 (0.482)
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
392 (0.404)
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
393 (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 ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.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
395 (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
396 (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
397 (0.368)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
398 (0.369)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
399 (0.366)
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
400 (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
401 (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
402 (0.382)
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
403 (0.364)
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
404 (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
405 (0.360)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.404)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.389)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
408 (0.369)
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.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
410 (0.417)
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
411 (0.297)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28613'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
412 (0.618)
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 = '355' 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
413 (0.616)
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
414 (0.505)
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
415 (0.338)
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 = '28353' 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
416 (0.503)
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 = '28353'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
417 (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
418 (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 affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.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
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.320)
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.341)
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.320)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
424 (0.319)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
425 (0.317)
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
426 (0.314)
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
427 (0.300)
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
428 (0.365)
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.323)
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
430 (0.328)
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.339)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.350)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.325)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
434 (0.333)
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.227)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28353'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
436 (0.428)
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 = '355' 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
437 (0.328)
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
438 (0.313)
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
439 (0.235)
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 = '28612' 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
440 (0.406)
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 = '28612'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
441 (1.575)
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
442 (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 affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.282)
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
444 (0.273)
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
445 (0.276)
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
446 (0.340)
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
447 (0.314)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
448 (0.337)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
449 (0.561)
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
450 (0.346)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '308' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.310)
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
452 (0.294)
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
453 (0.279)
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
454 (0.293)
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
455 (0.261)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.272)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.301)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
458 (0.283)
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
459 (0.272)
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
460 (0.287)
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
461 (0.219)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28612'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
462 (0.399)
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 = '355' 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
463 (0.331)
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
464 (0.300)
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
465 (0.282)
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 = '28354' 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
466 (0.416)
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 = '28354'
ORDER BY cp.level DESC, ptc.category_id ASC
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:805
467 (0.319)
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
468 (0.295)
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
469 (0.310)
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
470 (0.318)
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
471 (0.329)
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
472 (0.320)
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
473 (0.324)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
474 (0.346)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
475 (0.314)
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
476 (0.334)
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
477 (0.321)
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
478 (0.336)
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
479 (0.326)
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
480 (0.327)
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
481 (0.305)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.325)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5658' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND affect = '1' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_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.305)
SELECT *, qty as quantity
FROM oc_category_discount cd
WHERE category_id = '5762' AND status = '1' AND customer_group_id = '8' AND (qty = '0' OR qty = '1') AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY priority ASC, qty ASC, percentage DESC LIMIT 1
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:1238
484 (0.354)
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
485 (0.221)
SELECT manufacturer_id
FROM `oc_product`
WHERE product_id = '28354'
/home/pingas/liepinmaja_public_html/catalog/model/extension/module/discount.php:813
486 (0.375)
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 = '355' 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
487 (0.289)
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
488 (0.309)
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
489 (0.497)
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
490 (0.380)
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
491 (0.117)
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 = '5658' 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
492 (0.069)
SELECT *
FROM oc_seo_url
WHERE `query` = 'category_id=5658' AND store_id = '0' AND language_id = '2'
/home/pingas/storage3032/modification/catalog/controller/startup/seo_url.php:163
493 (0.364)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
494 (0.364)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'journal3/journal3' OR route = 'lv')
/home/pingas/liepinmaja_public_html/catalog/model/design/translation.php:6
495 (0.360)
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
496 (0.345)
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
497 (1.117)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/pingas/liepinmaja_public_html/catalog/model/setting/setting.php:6
498 (0.306)
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
499 (0.317)
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
500 (0.500)
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
501 (0.782)
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
502 (0.800)
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
503 (5.152)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/home/pingas/liepinmaja_public_html/catalog/model/setting/setting.php:6