Quantum


Shad Quantum Hairy Mary 6.5g 10cm Salt n pepper -49%

Shad Quantum Hairy Mary 6.5g 10cm Salt n pepper

801160150
Livrare imediată!

23,30Lei(-49%) 11,90Lei

Sticker, Quantum, Sktech,, 15, x, 8.2cm, 9949303, Diverse, Diverse Quantum, Diverse Quantum, Quantum

Sticker, Quantum, Sktech,, 15, x, 8.2cm, 9949303, Diverse, Diverse Quantum, Diverse Quantum, Quantum

9949303
Livrare imediată!

4,28Lei

Turbotail Sakura Tailspin 33mm 14gr A06 Aurora Minnow

Turbotail Sakura Tailspin 33mm 14gr A06 Aurora Minnow

131634saple500214-a06
Livrare imediată!

35,19Lei

Chatterbait, Quantum, 4Street, Pike, Chatter, 16g, Firetiger, 3525101, Spinner Bait, Spinner Bait Quantum, Spinner Quantum, Bait Quantum, Quantum
Quantum Fast Change X Strong Crosslock Snap 15mm

Quantum Fast Change X Strong Crosslock Snap 15mm

410160062
Livrare 48-72 ore

6,08Lei

Shad, Quantum, 4street, B-Ass, Shad, 61mm, Pink, Lady, 3337206, Shad-uri, Shad-uri Quantum, Quantum -56%

Shad, Quantum, 4street, B-Ass, Shad, 61mm, Pink, Lady, 3337206, Shad-uri, Shad-uri Quantum, Quantum

3337206
Livrare imediată!

31,29Lei(-56%) 13,90Lei

Turbotail, Quantum, 4Street, Spin-Jig, 35g, 4.7cm, Ghost, 3494203, Spinnertails, Spinnertails Quantum, Quantum -63%

Turbotail, Quantum, 4Street, Spin-Jig, 35g, 4.7cm, Ghost, 3494203, Spinnertails, Spinnertails Quantum, Quantum

3494203
Livrare imediată!

40,28Lei(-63%) 15,01Lei

Pluta, Rapitori, Quantum, Mr., Pike, Pencil, Slider,, 30g,, 170mm, 5240003, Plute Rapitor, Plute Rapitor Quantum, Plute Quantum, Rapitor Quantum, Quantum
Shad, Quantum, 4street, B-Ass, Shad, 56mm, Lime, 3337110, Shad-uri, Shad-uri Quantum, Quantum

Shad, Quantum, 4street, B-Ass, Shad, 56mm, Lime, 3337110, Shad-uri, Shad-uri Quantum, Quantum

3337110
Livrare imediată!

31,29Lei

Turbotail, Quantum, 4Street, Spin-Jig, 21g, 4.1cm, Firetiger, 3494002, Spinnertails, Spinnertails Quantum, Quantum -63%

Turbotail, Quantum, 4Street, Spin-Jig, 21g, 4.1cm, Firetiger, 3494002, Spinnertails, Spinnertails Quantum, Quantum

3494002
Livrare imediată!

40,28Lei(-63%) 15,01Lei

Pluta Rapitori Quantum Mr. Pike Drift Float, 40g, 125mm

Pluta Rapitori Quantum Mr. Pike Drift Float, 40g, 125mm

5242003
Livrare 14-21 zile

26,78Lei

Shad Quantum Hairy Mary 6.5g 10cm Minnow -23%

Shad Quantum Hairy Mary 6.5g 10cm Minnow

801160157
Livrare imediată!

23,30Lei(-23%) 17,90Lei

Shad, Quantum, 4Street, B-Ass, Shad, Motor, Oil, 5.6cm, 0.9g, 10buc, 3337114, Shad-uri, Shad-uri Quantum, Quantum
Turbotail Sakura Tailspin 14 33mm 14gr 046 Sexy Shad

Turbotail Sakura Tailspin 14 33mm 14gr 046 Sexy Shad

131634saple500214-046
Livrare imediată!

40,15Lei

Fir, Quantum, Salsa, Rosu, Transparent, 0.40mm,, 275m, 2611140, Fire Monofilament Crap, Fire Monofilament Crap Quantum, Quantum
Chatterbait, Quantum, 4Street, 10g, Natural, 3139106, Spinnerbaits, Spinnerbaits Quantum, Quantum

Chatterbait, Quantum, 4Street, 10g, Natural, 3139106, Spinnerbaits, Spinnerbaits Quantum, Quantum

3139106
Livrare imediată!

26,78Lei

Shad, Quantum, 4street, B-Ass, Shad, 56mm, Green, Pumpkin, Chartreuse, 10/buc, 3337102, Shad-uri, Shad-uri Quantum, Quantum
Geanta, Quantum, 4Street, Pusher, Bag, 19x23x5cm, 8810001, Genti Accesorii, Genti Accesorii Quantum, Quantum -44%

Geanta, Quantum, 4Street, Pusher, Bag, 19x23x5cm, 8810001, Genti Accesorii, Genti Accesorii Quantum, Quantum

8810001
Livrare imediată!

71,78Lei(-44%) 39,90Lei

Turbotail, Quantum, 4Street, Spin-Jig, 28g, 4.1cm, Ghost, 3494103, Spinnertails, Spinnertails Quantum, Quantum -63%

Turbotail, Quantum, 4Street, Spin-Jig, 28g, 4.1cm, Ghost, 3494103, Spinnertails, Spinnertails Quantum, Quantum

3494103
Livrare imediată!

40,28Lei(-63%) 15,01Lei

Costum De Iarna Quantum black/grey L -39%

Costum De Iarna Quantum black/grey L

8440003
Livrare 48-72ore

539,78Lei(-39%) 326,73Lei

Afişare 41 - 60 din 141 (8 pagini)
Queries: 10, Total time: 55.504 ms [By time] [By id] [By file]
1 (0.100)
SELECT data
FROM `oc_session`
WHERE session_id = '42bfadf5098f270c16e46573c2'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.102)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.101)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.130)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Quantum'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.127)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '228' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (26.017)
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 = '0' AND p.manufacturer_id = '228'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1650
7 (28.557)
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 = '0' AND p.manufacturer_id = '228' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:432
8 (0.141)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"PRODUSE INACTIVE"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.117)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
10 (0.112)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38