text_special

Attēls Produkta nosaukums Cena Produkta kods Noliktavā Daudzums
Acerbis motora aizsargs HUSQ/KTM 250/350 Melns/Balts Acerbis motora aizsargs HUSQ/KTM 250/350 Melns/Balts 54.99€ / m2 0024022.315
Izpārdots
/ m2
CYCRA STEALTH MX ALLOY roku sargi, Oranži CYCRA STEALTH MX ALLOY roku sargi, Oranži 52.95€ / m2 0024030.010
Ir pieejams Noliktavā 221
/ m2
CYCRA STEALTH MX ALLOY roku sargi, Balti CYCRA STEALTH MX ALLOY roku sargi, Balti 52.95€ / m2 0024030.030
Izpārdots
/ m2
CYCRA STEALTH MX ALLOY roku sargi, Zili CYCRA STEALTH MX ALLOY roku sargi, Zili 52.95€ / m2 0024030.040
Izpārdots
/ m2
CYCRA STEALTH PRIMAL roku sargi, Oranži CYCRA STEALTH PRIMAL roku sargi, Oranži 39.95€ / m2 0024058.010
Izpārdots
/ m2
CYCRA SERIES ONE NO CLAMPS roku sargi, Zili CYCRA SERIES ONE NO CLAMPS roku sargi, Zili 74.95€ / m2 0024070.040
Izpārdots
/ m2
CYCRA NUMBERPLATE atslēgu piekariņš (Balts) CYCRA NUMBERPLATE atslēgu piekariņš (Balts) 2.95€ / m2 0024218.030
Ir pieejams Noliktavā 444
/ m2
CYCRA NUMBERPLATE atslēgu piekariņš (Zils) CYCRA NUMBERPLATE atslēgu piekariņš (Zils) 2.95€ / m2 0024218.040
Izpārdots
/ m2
CYCRA NUMBERPLATE atslēgu piekariņš (Sarkans) CYCRA NUMBERPLATE atslēgu piekariņš (Sarkans) 2.95€ / m2 0024218.110
Izpārdots
/ m2
CYCRA NUMBERPLATE atslēgu piekariņš (Zaļš) CYCRA NUMBERPLATE atslēgu piekariņš (Zaļš) 100.00€ / m2 0024218.130
Ir pieejams Noliktavā 220
/ m2
Velcro slīpēšanas sprausla SENDI #200 Velcro slīpēšanas sprausla SENDI #200 14.00€ 01120001032
Ir pieejams Noliktavā 1
Velcro slīpēšanas sprausla SENDI #200 (Copy) (Copy) Velcro slīpēšanas sprausla SENDI #200 (Copy) (Copy) 14.00€ 01120001033
Ir pieejams Noliktavā 1
Velcro slīpēšanas sprausla SENDI #200 (Copy) Velcro slīpēšanas sprausla SENDI #200 (Copy) 14.00€ 01120001034
Ir pieejams Noliktavā 1
SENDI GS teleskopiskais rokturis trīskāršam GS slīpmašīnai SENDI GS teleskopiskais rokturis trīskāršam GS slīpmašīnai 29.00€ 01961204300
Izpārdots
400 x 20 mm centrālais caurums DISTAR TECHNIC ADVANCED Betona dimanta disks STIHL griezējiem 400 x 20 mm centrālais caurums DISTAR TECHNIC ADVANCED Betona dimanta disks STIHL griezējiem 109.00€ 10120024020
Izpārdots
RS-X Distar Drill Master 68 mm dimanta kroņurbis rozetēm (5 zobi, cauruma gals) RS-X Distar Drill Master 68 mm dimanta kroņurbis rozetēm (5 zobi, cauruma gals) 52.00€ 11133053029
Izpārdots
50W LED Prožektors 50W LED Prožektors 75.96€ 475345
Ir pieejams Noliktavā 101
50W Sensora LED Prožektors 50W Sensora LED Prožektors 51.95€ 475431
Izpārdots
CeraMAX 1800 Mechanic lielformāta darba galds CeraMAX 1800 Mechanic lielformāta darba galds 762.00€ 71419031035
Ir pieejams Noliktavā 1
Mapei Ultracare gluds silikons 750ml silikona aerosols Mapei Ultracare gluds silikons 750ml silikona aerosols 11.48€ 8022452220937
Ir pieejams Noliktavā 1
cc Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT cc Manometrs 1bar, 63mm, 1/4 4011 hor., HORIZONT 4.18€ / gab cc3829013
Ir pieejams Noliktavā 4
/ gab
Epoksīda javas komplekts, dubultās apaļas sprauslas, 4 gab. Epoksīda javas komplekts, dubultās apaļas sprauslas, 4 gab. 8.00€ GL-FORM-RINK-4
Ir pieejams Noliktavā 1
HP EliteBook 850 G5 MAIN HP EliteBook 850 G5 MAIN 619.83€ / gab HP EliteBook Main
Ir pieejams Noliktavā 40
BIHUI AUTO LFBSL Vakuuma piesūcekņa rezerves sprausla BIHUI AUTO LFBSL Vakuuma piesūcekņa rezerves sprausla 22.00€ LFBSL-TXP
Ir pieejams Noliktavā 1
test2 test2 474.00€ test2
Ir pieejams Noliktavā 113
img
img
img
kle

Jaunākie produkti LV Skatīt vairāk

Attēls Produkta nosaukums Cena Produkta kods Noliktavā Daudzums
CYCRA NUMBERPLATE atslēgu piekariņš (Zaļš) CYCRA NUMBERPLATE atslēgu piekariņš (Zaļš) 100.00€ / m2 0024218.130
Ir pieejams Noliktavā 220
/ m2
CYCRA NUMBERPLATE atslēgu piekariņš (Sarkans) CYCRA NUMBERPLATE atslēgu piekariņš (Sarkans) 2.95€ / m2 0024218.110
Izpārdots
/ m2
CYCRA NUMBERPLATE atslēgu piekariņš (Zils) CYCRA NUMBERPLATE atslēgu piekariņš (Zils) 2.95€ / m2 0024218.040
Izpārdots
/ m2
CYCRA NUMBERPLATE atslēgu piekariņš (Balts) CYCRA NUMBERPLATE atslēgu piekariņš (Balts) 2.95€ / m2 0024218.030
Ir pieejams Noliktavā 444
/ m2
CYCRA SERIES ONE NO CLAMPS roku sargi, Zili CYCRA SERIES ONE NO CLAMPS roku sargi, Zili 74.95€ / m2 0024070.040
Izpārdots
/ m2
CYCRA STEALTH PRIMAL roku sargi, Oranži CYCRA STEALTH PRIMAL roku sargi, Oranži 39.95€ / m2 0024058.010
Izpārdots
/ m2
CYCRA STEALTH MX ALLOY roku sargi, Zili CYCRA STEALTH MX ALLOY roku sargi, Zili 52.95€ / m2 0024030.040
Izpārdots
/ m2
CYCRA STEALTH MX ALLOY roku sargi, Balti CYCRA STEALTH MX ALLOY roku sargi, Balti 52.95€ / m2 0024030.030
Izpārdots
/ m2

Akcijas preces Skatīt vairāk

Attēls Produkta nosaukums Cena Produkta kods Noliktavā Daudzums
Lenovo ThinkPad 1111 Lenovo ThinkPad 1111
1,300.00€ 1,569.80€
Ir pieejams Noliktavā 99986
2Lenovo ThinkPad L480 20LS001APB 2Lenovo ThinkPad L480 20LS001APB
700.00€ 767.10€
Ir pieejams Noliktavā 991

Jaunākās ziņas Apskatīt visus

Ziemassvētku aktualitātes

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore ..

Lasīt vairāk
Pirktākie 2020. gada viedtālruņi

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore ..

Lasīt vairāk
Pirmās pavasara puķes

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore ..

Lasīt vairāk
Kā stiprināt imūnsistēmu ziemas mēnešos?

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore ..

Lasīt vairāk
Kādu telti izvēlēties pārgājieniem?

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore ..

Lasīt vairāk
#

Par piegādi

Interneta veikals padara iepirkšanos vienkāršu un ērtu - izdari pasūtījumu, izvēlies vēlamo apmaksas un piegādes veidu un saņem savu jauno pirkumu maksimāli ātri. Piedāvajam preces saņemt birojā, piegādāt uz Tavu vēlamo adresi, vai arī saņemt kādā no piegādes punktiem.

Uzzināt vairāk

Queries: 247, Total time: 106.332 ms [By time] [By id] [By file]
1 (0.849)
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 = '1' AND z2gz.country_id = '117' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/elvijs.nomasveikals.lv/web/system/library/cart/tax.php:53
2 (0.416)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'e01a14fb5ed996f239ff249504b7566d'
/var/www/elvijs.nomasveikals.lv/web/system/library/cart/cart.php:48
3 (0.473)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `event_id` ASC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/event.php:4
4 (0.171)
SELECT *
FROM oc_module
WHERE module_id = '0'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module.php:11
5 (1.811)
WITH cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '0' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1) SELECT /*+ MAX_EXECUTION_TIME(10000) */ p.product_id, p.sort_order, "1" AS match_filters, pr_restricted.value AS restrict_customer_group, pr_blocked.value AS block_customer_group, pp.image, pp.model
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
INNER JOIN `oc_bf_filter_guest` AS f ON (p.product_id = f.product_id)
INNER JOIN `oc_product_description` AS pd ON (pd.product_id = p.product_id)
LEFT JOIN `oc_product_rule` AS pr_restricted ON (pr_restricted.product_id = p.product_id AND pr_restricted.type = 'restrict_customer_group')
LEFT JOIN `oc_product_rule` AS pr_blocked ON (pr_blocked.product_id = p.product_id AND pr_blocked.type = 'block_customer_group')
INNER JOIN `oc_product` AS pp ON (pp.product_id = p.product_id)
WHERE p.date_available <= NOW() AND p.type NOT LIKE 'option' AND IF(f.filter_group LIKE 'o%', f.out_of_stock = 0, 1 = 1) AND pd.language_id = '1' GROUP BY p.product_id, product_id HAVING match_filters = 1
ORDER BY LCASE(pp.image) ASC, LCASE(pp.model) ASC LIMIT 0, 25
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:245
6 (1.671)
WITH cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '0' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND psf.customer_group_id = '1')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND psp.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '1')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN `oc_category` AS c ON (c.category_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON ((cd.category_id = ptc.category_id OR (cd.category_id = c.parent_id AND cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '1' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('374','375','376','377','378','379','380','381','382','383','349','347','348','344','342','343','352','353','341','350','335','345','324','346','340') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/discount.php:1241
7 (2.747)
SELECT p.*, pd.*, m.*, pd.name AS name, p.image, m.name AS manufacturer, md.seo_keyword AS manufacturer_seo_keyword, prw.points AS reward, wcd.unit AS weight_class, lcd.unit AS length_class, AVG(r.rating) AS rating, COUNT(DISTINCT r.review_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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_manufacturer_description md ON (p.manufacturer_id = md.manufacturer_id AND md.language_id = '1')
LEFT JOIN oc_product_reward prw ON (prw.product_id = p.product_id AND prw.customer_group_id = '1')
LEFT JOIN oc_weight_class_description wcd ON (p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1')
LEFT JOIN oc_length_class_description lcd ON (p.length_class_id = lcd.length_class_id AND lcd.language_id = '1')
LEFT JOIN oc_review r ON (r.product_id = p.product_id AND r.status = '1')
WHERE p.product_id IN (374,375,376,377,378,379,380,381,382,383,349,347,348,344,342,343,352,353,341,350,335,345,324,346,340) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() GROUP BY p.product_id
ORDER BY FIELD(p.product_id,374,375,376,377,378,379,380,381,382,383,349,347,348,344,342,343,352,353,341,350,335,345,324,346,340)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:2056
8 (0.667)
SELECT *
FROM oc_product p
WHERE p.product_id IN (374,375,376,377,378,379,380,381,382,383,349,347,348,344,342,343,352,353,341,350,335,345,324,346,340)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:2004
9 (1.711)
WITH cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '11' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND psf.customer_group_id = '11')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND psp.customer_group_id = '11')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '11')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '11')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN `oc_category` AS c ON (c.category_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON ((cd.category_id = ptc.category_id OR (cd.category_id = c.parent_id AND cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '11' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('324','335','341','340','342','343','344','345','346','347','348','349','350','352','353','374','375','376','377','378','379','380','381','382','383') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/discount.php:1241
10 (0.805)
SELECT COUNT(*) AS total
FROM ( WITH cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '0' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1) SELECT /*+ MAX_EXECUTION_TIME(10000) */ p.product_id, p.sort_order, "1" AS match_filters
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
INNER JOIN `oc_bf_filter_guest` AS f ON (p.product_id = f.product_id)
WHERE p.date_available <= NOW() AND p.type NOT LIKE 'option' AND IF(f.filter_group LIKE 'o%', f.out_of_stock = 0, 1 = 1) GROUP BY p.product_id HAVING match_filters = 1) AS t
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1599
11 (0.166)
SELECT *
FROM oc_product_to_category
WHERE product_id = '374'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
12 (0.170)
SELECT *
FROM oc_product_to_category
WHERE product_id = '374'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
13 (0.129)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '374'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
14 (0.155)
SELECT *
FROM oc_product_label pl
WHERE pl.status = 1
ORDER BY pl.sort_order ASC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:75
15 (0.184)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
16 (0.195)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '374' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
17 (0.166)
SELECT *
FROM oc_product_to_category
WHERE product_id = '375'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
18 (0.170)
SELECT *
FROM oc_product_to_category
WHERE product_id = '375'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
19 (0.122)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '375'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
20 (0.137)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
21 (0.172)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '375' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
22 (0.158)
SELECT *
FROM oc_product_to_category
WHERE product_id = '376'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
23 (0.128)
SELECT *
FROM oc_product_to_category
WHERE product_id = '376'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
24 (0.111)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '376'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
25 (0.161)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
26 (0.173)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '376' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
27 (0.129)
SELECT *
FROM oc_product_to_category
WHERE product_id = '377'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
28 (0.152)
SELECT *
FROM oc_product_to_category
WHERE product_id = '377'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
29 (0.118)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '377'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
30 (0.130)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
31 (0.180)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '377' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
32 (0.172)
SELECT *
FROM oc_product_to_category
WHERE product_id = '378'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
33 (0.197)
SELECT *
FROM oc_product_to_category
WHERE product_id = '378'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
34 (0.155)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '378'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
35 (0.202)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
36 (0.206)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '378' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
37 (0.168)
SELECT *
FROM oc_product_to_category
WHERE product_id = '379'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
38 (0.172)
SELECT *
FROM oc_product_to_category
WHERE product_id = '379'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
39 (0.170)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '379'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
40 (0.218)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
41 (0.245)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '379' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
42 (0.173)
SELECT *
FROM oc_product_to_category
WHERE product_id = '380'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
43 (0.180)
SELECT *
FROM oc_product_to_category
WHERE product_id = '380'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
44 (0.168)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '380'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
45 (0.160)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
46 (0.286)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '380' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
47 (0.171)
SELECT *
FROM oc_product_to_category
WHERE product_id = '381'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
48 (0.173)
SELECT *
FROM oc_product_to_category
WHERE product_id = '381'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
49 (0.170)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '381'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
50 (0.183)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
51 (0.231)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '381' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
52 (0.174)
SELECT *
FROM oc_product_to_category
WHERE product_id = '382'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
53 (0.191)
SELECT *
FROM oc_product_to_category
WHERE product_id = '382'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
54 (0.134)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '382'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
55 (0.132)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
56 (0.165)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '382' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
57 (0.161)
SELECT *
FROM oc_product_to_category
WHERE product_id = '383'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
58 (0.131)
SELECT *
FROM oc_product_to_category
WHERE product_id = '383'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
59 (0.114)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '383'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
60 (0.154)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
61 (0.186)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '383' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
62 (0.121)
SELECT *
FROM oc_product_to_category
WHERE product_id = '349'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
63 (0.227)
SELECT *
FROM oc_product_to_category
WHERE product_id = '349'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
64 (0.215)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '349'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
65 (0.236)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
66 (0.348)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '349' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
67 (0.230)
SELECT *
FROM oc_product_to_category
WHERE product_id = '347'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
68 (0.178)
SELECT *
FROM oc_product_to_category
WHERE product_id = '347'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
69 (0.222)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '347'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
70 (0.203)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
71 (0.310)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '347' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
72 (0.193)
SELECT *
FROM oc_product_to_category
WHERE product_id = '348'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
73 (0.179)
SELECT *
FROM oc_product_to_category
WHERE product_id = '348'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
74 (0.195)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '348'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
75 (0.177)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
76 (0.311)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '348' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
77 (0.203)
SELECT *
FROM oc_product_to_category
WHERE product_id = '344'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
78 (0.180)
SELECT *
FROM oc_product_to_category
WHERE product_id = '344'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
79 (0.161)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '344'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
80 (0.206)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
81 (0.308)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '344' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
82 (0.218)
SELECT *
FROM oc_product_to_category
WHERE product_id = '342'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
83 (0.179)
SELECT *
FROM oc_product_to_category
WHERE product_id = '342'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
84 (0.209)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '342'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
85 (0.189)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
86 (0.216)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '342' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
87 (0.176)
SELECT *
FROM oc_product_to_category
WHERE product_id = '343'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
88 (0.162)
SELECT *
FROM oc_product_to_category
WHERE product_id = '343'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
89 (0.171)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '343'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
90 (0.149)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
91 (0.207)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '343' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
92 (0.139)
SELECT *
FROM oc_product_to_category
WHERE product_id = '352'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
93 (0.140)
SELECT *
FROM oc_product_to_category
WHERE product_id = '352'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
94 (0.135)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
95 (0.202)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '352' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
96 (0.137)
SELECT *
FROM oc_product_to_category
WHERE product_id = '353'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
97 (0.160)
SELECT *
FROM oc_product_to_category
WHERE product_id = '353'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
98 (0.132)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '353'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
99 (0.133)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
100 (0.193)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '353' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
101 (0.141)
SELECT *
FROM oc_product_to_category
WHERE product_id = '341'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
102 (0.140)
SELECT *
FROM oc_product_to_category
WHERE product_id = '341'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
103 (0.121)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '341'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
104 (0.144)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
105 (0.200)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '341' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
106 (0.140)
SELECT *
FROM oc_product_to_category
WHERE product_id = '350'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
107 (0.138)
SELECT *
FROM oc_product_to_category
WHERE product_id = '350'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
108 (0.128)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '350'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
109 (0.144)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
110 (0.204)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '350' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
111 (0.152)
SELECT *
FROM oc_product_to_category
WHERE product_id = '335'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
112 (0.120)
SELECT *
FROM oc_product_to_category
WHERE product_id = '335'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
113 (0.118)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '335'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
114 (0.164)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '4' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
115 (0.194)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '335' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
116 (0.161)
SELECT *
FROM oc_product_to_category
WHERE product_id = '345'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
117 (0.123)
SELECT *
FROM oc_product_to_category
WHERE product_id = '345'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
118 (0.131)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '345'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
119 (0.128)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
120 (0.181)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '345' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
121 (0.146)
SELECT *
FROM oc_product_to_category
WHERE product_id = '324'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
122 (0.124)
SELECT *
FROM oc_product_to_category
WHERE product_id = '324'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
123 (0.151)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '4' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
124 (0.209)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '324' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
125 (0.272)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '324' AND pov.product_option_id = '5' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1040
126 (1.017)
WITH cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '0' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND psf.customer_group_id = '1')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND psp.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '1')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN `oc_category` AS c ON (c.category_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON ((cd.category_id = ptc.category_id OR (cd.category_id = c.parent_id AND cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '1' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('323','322') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/discount.php:1241
127 (0.848)
SELECT p.*, pd.*, m.*, pd.name AS name, p.image, m.name AS manufacturer, md.seo_keyword AS manufacturer_seo_keyword, prw.points AS reward, wcd.unit AS weight_class, lcd.unit AS length_class, AVG(r.rating) AS rating, COUNT(DISTINCT r.review_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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_manufacturer_description md ON (p.manufacturer_id = md.manufacturer_id AND md.language_id = '1')
LEFT JOIN oc_product_reward prw ON (prw.product_id = p.product_id AND prw.customer_group_id = '1')
LEFT JOIN oc_weight_class_description wcd ON (p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1')
LEFT JOIN oc_length_class_description lcd ON (p.length_class_id = lcd.length_class_id AND lcd.language_id = '1')
LEFT JOIN oc_review r ON (r.product_id = p.product_id AND r.status = '1')
WHERE p.product_id IN (323,322) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() GROUP BY p.product_id
ORDER BY FIELD(p.product_id,323,322)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:2056
128 (0.226)
SELECT *
FROM oc_product p
WHERE p.product_id IN (323,322)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:2004
129 (0.913)
WITH cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '11' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND psf.customer_group_id = '11')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND psp.customer_group_id = '11')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '11')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '11')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN `oc_category` AS c ON (c.category_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON ((cd.category_id = ptc.category_id OR (cd.category_id = c.parent_id AND cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '11' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('322','323') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/discount.php:1241
130 (0.165)
SELECT *
FROM oc_product_to_category
WHERE product_id = '346'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
131 (0.165)
SELECT *
FROM oc_product_to_category
WHERE product_id = '346'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
132 (0.154)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '346'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
133 (0.135)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
134 (0.199)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '346' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
135 (0.174)
SELECT *
FROM oc_product_to_category
WHERE product_id = '340'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
136 (0.141)
SELECT *
FROM oc_product_to_category
WHERE product_id = '340'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
137 (0.150)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '340'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
138 (0.168)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
139 (0.220)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '340' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
140 (0.265)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '340' AND pov.product_option_id = '14' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1040
141 (0.272)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '340' AND pov.product_option_id = '9' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1040
142 (0.338)
SELECT *
FROM oc_layout_route
WHERE 'product/selection' LIKE route
ORDER BY route DESC LIMIT 1
/var/www/elvijs.nomasveikals.lv/web/catalog/model/design/layout.php:11
143 (0.299)
SELECT *
FROM oc_layout_module
WHERE layout_id = '4'
ORDER BY sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/design/layout.php:29
144 (0.235)
SELECT *
FROM oc_module
WHERE module_id = '168'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module.php:11
145 (0.944)
SHOW COLUMNS
FROM `oc_banner` LIKE 'width'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/design/banner.php:60
146 (0.526)
SHOW COLUMNS
FROM `oc_banner` LIKE 'height'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/design/banner.php:60
147 (0.586)
SHOW COLUMNS
FROM `oc_banner` LIKE 'width_m'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/design/banner.php:60
148 (0.691)
SHOW COLUMNS
FROM `oc_banner` LIKE 'height_m'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/design/banner.php:60
149 (0.681)
SHOW COLUMNS
FROM `oc_banner` LIKE 'slider_speed'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/design/banner.php:60
150 (0.685)
SHOW COLUMNS
FROM `oc_banner` LIKE 'autoplay_speed'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/design/banner.php:60
151 (0.326)
SELECT *
FROM oc_banner b
LEFT JOIN oc_banner_image bi ON (b.banner_id = bi.banner_id)
WHERE b.banner_id = '7' AND b.status = '1' AND bi.language_id = '1'
ORDER BY bi.sort_order ASC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/design/banner.php:6
152 (0.197)
SELECT *
FROM oc_theme
WHERE theme = 'wd_freshshop' AND route = 'extension/module/banner'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module/d_twig_manager.php:15
153 (0.212)
SELECT *
FROM oc_module
WHERE module_id = '178'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module.php:11
154 (0.230)
SELECT *
FROM oc_module
WHERE module_id = '125'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module.php:11
155 (0.177)
SELECT *
FROM oc_module
WHERE module_id = '170'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module.php:11
156 (0.456)
SELECT p.product_id, p.sort_order, p.type , p.date_added
FROM oc_product p
WHERE p.status = '1' AND p.type != 'option'
ORDER BY p.product_id DESC LIMIT 0,8
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module/product_block.php:283
157 (1.065)
WITH cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '0' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND psf.customer_group_id = '1')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND psp.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '1')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN `oc_category` AS c ON (c.category_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON ((cd.category_id = ptc.category_id OR (cd.category_id = c.parent_id AND cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '1' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('383','382','381','380','379','378','377','376') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/discount.php:1241
158 (1.130)
SELECT p.*, pd.*, m.*, pd.name AS name, p.image, m.name AS manufacturer, md.seo_keyword AS manufacturer_seo_keyword, prw.points AS reward, wcd.unit AS weight_class, lcd.unit AS length_class, AVG(r.rating) AS rating, COUNT(DISTINCT r.review_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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_manufacturer_description md ON (p.manufacturer_id = md.manufacturer_id AND md.language_id = '1')
LEFT JOIN oc_product_reward prw ON (prw.product_id = p.product_id AND prw.customer_group_id = '1')
LEFT JOIN oc_weight_class_description wcd ON (p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1')
LEFT JOIN oc_length_class_description lcd ON (p.length_class_id = lcd.length_class_id AND lcd.language_id = '1')
LEFT JOIN oc_review r ON (r.product_id = p.product_id AND r.status = '1')
WHERE p.product_id IN (383,382,381,380,379,378,377,376) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() GROUP BY p.product_id
ORDER BY FIELD(p.product_id,383,382,381,380,379,378,377,376)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:2056
159 (0.320)
SELECT *
FROM oc_product p
WHERE p.product_id IN (383,382,381,380,379,378,377,376)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:2004
160 (1.002)
WITH cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '11' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND psf.customer_group_id = '11')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND psp.customer_group_id = '11')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '11')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '11')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN `oc_category` AS c ON (c.category_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON ((cd.category_id = ptc.category_id OR (cd.category_id = c.parent_id AND cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '11' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('376','377','378','379','380','381','382','383') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/discount.php:1241
161 (0.189)
SELECT *
FROM oc_product_to_category
WHERE product_id = '383'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
162 (0.145)
SELECT *
FROM oc_product_to_category
WHERE product_id = '383'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
163 (0.178)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '383'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
164 (0.165)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
165 (0.225)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '383' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
166 (0.234)
SELECT *
FROM oc_product_to_category
WHERE product_id = '382'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
167 (0.178)
SELECT *
FROM oc_product_to_category
WHERE product_id = '382'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
168 (0.149)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '382'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
169 (0.208)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
170 (0.244)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '382' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
171 (0.171)
SELECT *
FROM oc_product_to_category
WHERE product_id = '381'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
172 (0.177)
SELECT *
FROM oc_product_to_category
WHERE product_id = '381'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
173 (0.130)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '381'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
174 (0.187)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
175 (0.281)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '381' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
176 (0.165)
SELECT *
FROM oc_product_to_category
WHERE product_id = '380'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
177 (0.200)
SELECT *
FROM oc_product_to_category
WHERE product_id = '380'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
178 (0.194)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '380'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
179 (0.218)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
180 (0.272)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '380' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
181 (0.181)
SELECT *
FROM oc_product_to_category
WHERE product_id = '379'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
182 (0.188)
SELECT *
FROM oc_product_to_category
WHERE product_id = '379'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
183 (0.147)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '379'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
184 (0.200)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
185 (0.288)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '379' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
186 (0.171)
SELECT *
FROM oc_product_to_category
WHERE product_id = '378'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
187 (0.163)
SELECT *
FROM oc_product_to_category
WHERE product_id = '378'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
188 (0.156)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '378'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
189 (0.197)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
190 (0.220)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '378' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
191 (0.168)
SELECT *
FROM oc_product_to_category
WHERE product_id = '377'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
192 (0.170)
SELECT *
FROM oc_product_to_category
WHERE product_id = '377'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
193 (0.156)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '377'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
194 (0.130)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
195 (0.164)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '377' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
196 (0.132)
SELECT *
FROM oc_product_to_category
WHERE product_id = '376'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
197 (0.131)
SELECT *
FROM oc_product_to_category
WHERE product_id = '376'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
198 (0.137)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '376'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
199 (0.118)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '7' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
200 (0.157)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '376' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
201 (0.136)
SELECT *
FROM oc_theme
WHERE theme = 'wd_freshshop' AND route = 'extension/module/product_block'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module/d_twig_manager.php:15
202 (0.120)
SELECT *
FROM oc_module
WHERE module_id = '171'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module.php:11
203 (0.424)
SELECT p.product_id, p.sort_order, p.type , COALESCE(special.price, p.price) AS price
FROM oc_product p
LEFT JOIN ( SELECT ps.product_id AS product_id, MIN(ps.price) AS price
FROM oc_product_special ps JOIN ( SELECT product_id, MIN(priority) as lowest_priority
FROM oc_product_special GROUP BY product_id ) subquery ON ps.product_id = subquery.product_id AND ps.priority = subquery.lowest_priority
WHERE ps.customer_group_id = 1 AND (ps.date_start = '0000-00-00' OR ps.date_start < NOW()) GROUP BY ps.product_id ) AS special ON p.product_id = special.product_id
WHERE p.status = '1' AND p.type != 'option' AND special.price IS NOT NULL
ORDER BY COALESCE(special.price, p.price) DESC LIMIT 0,5
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module/product_block.php:283
204 (0.879)
WITH cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '0' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND psf.customer_group_id = '1')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND psp.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '1')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '1')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN `oc_category` AS c ON (c.category_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON ((cd.category_id = ptc.category_id OR (cd.category_id = c.parent_id AND cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '1' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('11','16') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/discount.php:1241
205 (0.709)
SELECT p.*, pd.*, m.*, pd.name AS name, p.image, m.name AS manufacturer, md.seo_keyword AS manufacturer_seo_keyword, prw.points AS reward, wcd.unit AS weight_class, lcd.unit AS length_class, AVG(r.rating) AS rating, COUNT(DISTINCT r.review_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_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN oc_manufacturer_description md ON (p.manufacturer_id = md.manufacturer_id AND md.language_id = '1')
LEFT JOIN oc_product_reward prw ON (prw.product_id = p.product_id AND prw.customer_group_id = '1')
LEFT JOIN oc_weight_class_description wcd ON (p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1')
LEFT JOIN oc_length_class_description lcd ON (p.length_class_id = lcd.length_class_id AND lcd.language_id = '1')
LEFT JOIN oc_review r ON (r.product_id = p.product_id AND r.status = '1')
WHERE p.product_id IN (11,16) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() GROUP BY p.product_id
ORDER BY FIELD(p.product_id,11,16)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:2056
206 (0.170)
SELECT *
FROM oc_product p
WHERE p.product_id IN (11,16)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:2004
207 (0.817)
WITH cgd AS ( SELECT cgd.percentage
FROM `oc_customer_group_discount` AS cgd
WHERE cgd.status = '1' AND cgd.customer_group_id = '11' AND (cgd.date_start = '0000-00-00' OR cgd.date_start < NOW())
ORDER BY cgd.priority ASC, cgd.percentage ASC LIMIT 0, 1) SELECT p.product_id, CASE WHEN psf.price IS NOT NULL THEN p.price WHEN psp.percentage IS NOT NULL THEN p.price WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END AS `before`, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END) AS discount, (CASE WHEN psf.price IS NOT NULL THEN psf.price WHEN psp.percentage IS NOT NULL THEN (100 - psp.percentage) * p.price / 100 WHEN pdf.price IS NOT NULL THEN pdf.price WHEN pdp.percentage IS NOT NULL THEN (100 - pdp.percentage) * p.price / 100 ELSE p.price END * IF(psf.price IS NULL AND psp.percentage IS NULL AND (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0))) < 100, (100 - (MAX(IFNULL(cgd.percentage, 0)) + MAX(IFNULL(cd.percentage, 0)))) / 100, 1)) AS final
FROM `oc_product` AS p
LEFT JOIN cgd ON (1)
LEFT JOIN `oc_product_special` AS psf ON (psf.product_id = p.product_id AND psf.discount_type = 'F' AND psf.price > 0 AND (psf.date_start = '0000-00-00' OR psf.date_start < NOW()) AND psf.customer_group_id = '11')
LEFT JOIN `oc_product_special` AS psp ON (psp.product_id = p.product_id AND psp.discount_type = 'P' AND psp.percentage > 0 AND (psp.date_start = '0000-00-00' OR psp.date_start < NOW()) AND psp.customer_group_id = '11')
LEFT JOIN `oc_product_discount` AS pdf ON (pdf.product_id = p.product_id AND pdf.quantity <= p.minimum AND pdf.discount_type = 'F' AND pdf.price > 0 AND (pdf.date_start = '0000-00-00' OR pdf.date_start < NOW()) AND pdf.customer_group_id = '11')
LEFT JOIN `oc_product_discount` AS pdp ON (pdp.product_id = p.product_id AND pdp.quantity <= p.minimum AND pdp.discount_type = 'P' AND pdp.percentage > 0 AND (pdp.date_start = '0000-00-00' OR pdp.date_start < NOW()) AND pdp.customer_group_id = '11')
LEFT JOIN `oc_product_to_category` AS ptc ON (ptc.product_id = p.product_id)
LEFT JOIN `oc_category` AS c ON (c.category_id = ptc.category_id)
LEFT JOIN `oc_category_discount` AS cd ON ((cd.category_id = ptc.category_id OR (cd.category_id = c.parent_id AND cd.affect = '1')) AND cd.status = '1' AND cd.customer_group_id = '11' AND cd.qty <= p.minimum AND cd.qty IS NOT NULL AND (cd.date_start = '0000-00-00' OR cd.date_start < NOW()))
WHERE p.status = '1' AND p.date_available <= NOW() AND p.product_id IN ('11','16') GROUP BY p.product_id
ORDER BY psf.priority ASC, psp.priority ASC, psf.price ASC, psp.percentage DESC, pdf.priority ASC, pdp.priority ASC, pdf.price ASC, pdp.percentage DESC, cd.priority ASC, cd.percentage DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/discount.php:1241
208 (0.126)
SELECT *
FROM oc_product_to_category
WHERE product_id = '11'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
209 (0.153)
SELECT *
FROM oc_product_to_category
WHERE product_id = '11'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
210 (0.101)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '11'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
211 (0.104)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
212 (0.174)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '11' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
213 (0.129)
SELECT *
FROM oc_product_to_category
WHERE product_id = '16'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
214 (0.162)
SELECT *
FROM oc_product_to_category
WHERE product_id = '16'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1287
215 (0.101)
SELECT manufacturer_id
FROM oc_product
WHERE product_id = '16'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/tool/product_label.php:81
216 (0.101)
SELECT *
FROM oc_unit_class uc
LEFT JOIN oc_unit_class_description ucd ON (uc.unit_class_id = ucd.unit_class_id)
WHERE uc.unit_class_id = '0' AND ucd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1761
217 (0.167)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '16' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/product.php:1035
218 (0.142)
SELECT *
FROM oc_module
WHERE module_id = '173'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module.php:11
219 (0.271)
SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '61' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:4
220 (0.186)
SELECT *
FROM oc_category_description
WHERE `category_id` = '61' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:462
221 (0.287)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
WHERE c.parent_id = '61' AND cd.language_id = '1' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:48
222 (0.239)
SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '66' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:4
223 (0.182)
SELECT *
FROM oc_category_description
WHERE `category_id` = '66' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:462
224 (0.183)
SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '489' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:4
225 (0.419)
SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '488' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:4
226 (0.609)
SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '487' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:4
227 (0.502)
SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '556' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:4
228 (0.673)
SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '553' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:4
229 (0.713)
SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '1613' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:4
230 (0.764)
SELECT DISTINCT c.*, cd.*, GROUP_CONCAT(cep.parent_id
ORDER BY cep.sort_order ASC) as parent_ids
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_extra_parents cep ON (c.category_id = cep.category_id)
WHERE c.category_id = '503' AND cd.language_id = '1' AND c.status = '1' GROUP BY c.category_id
/var/www/elvijs.nomasveikals.lv/web/catalog/model/catalog/category.php:4
231 (0.631)
SELECT *
FROM oc_category_description
WHERE `category_id` = '62' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:462
232 (0.253)
SELECT *
FROM oc_theme
WHERE theme = 'wd_freshshop' AND route = 'extension/module/contentpreview'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module/d_twig_manager.php:15
233 (0.230)
SELECT *
FROM oc_module
WHERE module_id = '157'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module.php:11
234 (0.844)
SELECT *
FROM oc_blog n
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
LEFT JOIN oc_blog_to_category n2c ON (n.blog_id = n2c.blog_id)
WHERE nd.language_id = '1' AND n2c.blog_category_id = '50' AND n.status = '1' AND n.sort_order <> '-1'
ORDER BY n.sort_order, n.blog_id DESC LIMIT 0,5
/var/www/elvijs.nomasveikals.lv/web/catalog/model/blog/blog.php:71
235 (0.707)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '25' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/blog/blog.php:161
236 (0.437)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '24' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/blog/blog.php:161
237 (0.401)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '23' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/blog/blog.php:161
238 (0.409)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '19' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/blog/blog.php:161
239 (0.393)
SELECT COUNT(*) AS total
FROM oc_blog_comment nc
LEFT JOIN oc_blog n ON (nc.blog_id = n.blog_id)
LEFT JOIN oc_blog_description nd ON (n.blog_id = nd.blog_id)
WHERE n.blog_id = '16' AND n.status = '1' AND nc.status = '1' AND nd.language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/blog/blog.php:161
240 (0.366)
SELECT *
FROM oc_url_alias
WHERE `query` = 'blog/home' AND (`language_id` = '1' OR `language_id` = 0)
ORDER BY language_id DESC
/var/www/elvijs.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:429
241 (0.205)
SELECT *
FROM oc_theme
WHERE theme = 'wd_freshshop' AND route = 'extension/module/blog_latest'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module/d_twig_manager.php:15
242 (0.251)
SELECT *
FROM oc_module
WHERE module_id = '169'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module.php:11
243 (36.113)
SELECT `query`, `keyword`
FROM oc_url_alias
WHERE `language_id` = '3' AND `query` LIKE '%/%'
/var/www/elvijs.nomasveikals.lv/web/catalog/controller/startup/seo_url.php:676
244 (0.374)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/elvijs.nomasveikals.lv/web/system/library/cart/customer.php:144
245 (0.329)
SELECT *
FROM oc_module
WHERE module_id = '180'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module.php:11
246 (0.341)
SELECT product_id, language_id, name, seo_keyword
FROM `oc_product_description`
WHERE product_id IN (16) AND language_id = '1'
/var/www/elvijs.nomasveikals.lv/web/catalog/controller/extension/module/mega_menu.php:882
247 (0.318)
SELECT *
FROM oc_theme
WHERE theme = 'wd_freshshop' AND route = 'product/special'
/var/www/elvijs.nomasveikals.lv/web/catalog/model/extension/module/d_twig_manager.php:15