Prologic


TRICOU PROLOGIC CAMO LOGO GREY MELANGE MAR.2XL

a8.pro.73747
Livrare 24-48 ore

97,28Lei

Mulineta Prologic Element XD 8000 FD

o.pro.74711
Livrare imediată!

587,47Lei(-24%) 449,02Lei

213,19Lei

207,32Lei(-10%) 186,59Lei

AVERTIZOR PROLOGIC SET C-SERIES 3 ELECTR RECIVER

a.pro.71023
Livrare imediată!

676,32Lei(-10%) 608,70Lei

211,02Lei

Pantaloni PROLOGIC Combat, Army Green, Marime 2XL

a8.pro.1611139
Livrare 24-48 ore

384,93Lei

Lanseta Prologic C-Series Spod Marker 3.60m 5lbs

o.pro.72637
Livrare imediată!

380,76Lei

HANORAC PROLOGIC EDEN ZIP BLACK CAVIAR MARIME L

a8.pro.73753
Livrare imediată!

231,88Lei

Fes Prologic Fold Up One Size Green

a8.pro.73770
Livrare imediată!

38,84Lei

PROLOGIC COSTUM HIGHGRADE REALTREE THERMO MAR.XL

a8.pro.64548
Livrare imediată!

904,85Lei

HANORAC PROLOGIC CARPIO ZIP ARMY GREEN MARIME L

a8.pro.73757
Livrare imediată!

246,78Lei

233,20Lei(-9%) 213,19Lei

Jacheta Ploaie Prologic Bark Green M

a8.pro.76517
Livrare imediată!

307,86Lei

CHOD BUFFER PROLOGIC 15BUC/PL

a.pro.49907
Livrare 24-48 ore

31,57Lei(-40%) 18,94Lei

JACHETA Prologic FLEECE TECH MARIME S

a8.pro.57271
Livrare 24-48 ore

291,24Lei(-20%) 232,99Lei

Jacheta Prologic Bank Bound Insulated XL

a8.pro.64525
Livrare 24-48 ore

397,58Lei

HANORAC SAVAGE GEAR COSMO BLACK INK MARIME M

a8.sg.73698
Livrare imediată!

223,84Lei(-23%) 172,17Lei

Afişare 1 - 20 din 626 (32 pagini)
Queries: 7, Total time: 97.373 ms [By time] [By id] [By file]
1 (0.139)
SELECT data
FROM `oc_session`
WHERE session_id = '385b8e337a0abddd55eacd49eb'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.105)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:427
3 (0.128)
SELECT *
FROM oc_url_alias
WHERE keyword = 'prologic.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.099)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '47' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (33.388)
SELECT COUNT(1) AS total
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)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '3' AND p.manufacturer_id = '47'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1667
6 (63.409)
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 = '1' 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 = '1' 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, p.viewed, p.price
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)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '3' AND p.manufacturer_id = '47' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
7 (0.106)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38