DUO


Vobler DUO Realis Vibration 68 G-FIX, DUA3005 GF Watermelon, 6.8cm, 21g

Vobler DUO Realis Vibration 68 G-FIX, DUA3005 GF Watermelon, 6.8cm, 21g

duo58258
Livrare 48-72 ore

75,13Lei

Spinnertail DUO Realis Spin 30 CSA3807 Tanago II, 3cm, 5g

Spinnertail DUO Realis Spin 30 CSA3807 Tanago II, 3cm, 5g

duo00247
Livrare 48-72 ore

69,02Lei

Vobler DUO Tetra Works Toto 48HS Heavy Sinking, CCC0075 Lemon Boost, 4.8cm, 4.3g

Vobler DUO Tetra Works Toto 48HS Heavy Sinking, CCC0075 Lemon Boost, 4.8cm, 4.3g

duo42933
Livrare 48-72 ore

69,02Lei

Vobler DUO Tide Minnow 75 Sprint, CPA3512 Inakko Lime Chart, 7.5cm, 11g

Vobler DUO Tide Minnow 75 Sprint, CPA3512 Inakko Lime Chart, 7.5cm, 11g

duo64614
Livrare 48-72 ore

85,29Lei

Vobler DUO Terrif DC-12 Type 1, GFN0093 Clear Mullet, 12cm, 18g

Vobler DUO Terrif DC-12 Type 1, GFN0093 Clear Mullet, 12cm, 18g

duo20163
Livrare 48-72 ore

102,58Lei

Vobler DUO Spearhead Ryuki 71S, ADA4068 Yamame Red Belly, 7.1cm, 10g

Vobler DUO Spearhead Ryuki 71S, ADA4068 Yamame Red Belly, 7.1cm, 10g

duo73708
Livrare 48-72 ore

90,37Lei

Vobler DUO Spearhead Ryuki 70S, ADA4093 UV Pink Chart Yamame OB, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, ADA4093 UV Pink Chart Yamame OB, 7cm, 9g

duo85749
Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 50S, ADA4090 UV RGG Yamame OB, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, ADA4090 UV RGG Yamame OB, 5cm, 4.5g

duo85381
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 50S, CNA0534 UV Flash, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, CNA0534 UV Flash, 5cm, 4.5g

duo85374
Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 80S SW, ADA0218 Pink Gigo, 8cm, 12g

Vobler Duo Spearhead Ryuki 80S SW, ADA0218 Pink Gigo, 8cm, 12g

duo23574
Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 50S SW, ACC3514 Mat Impact Chart GB, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S SW, ACC3514 Mat Impact Chart GB, 5cm, 4.5g

duo63396
Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 45S, ADA4013 Wakasagi, 4.5cm, 4g

Vobler Duo Spearhead Ryuki 45S, ADA4013 Wakasagi, 4.5cm, 4g

duo30803
Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 38S, ANI4010 Pearl Ayu, 3.8cm, 2.8g

Vobler Duo Spearhead Ryuki 38S, ANI4010 Pearl Ayu, 3.8cm, 2.8g

duo16989
Livrare 48-72 ore

69,02Lei

Vobler DUO Spreadhead Ryuki 80SP, ADA4068 Yamame Red Belly, 8cm, 5.6g

Vobler DUO Spreadhead Ryuki 80SP, ADA4068 Yamame Red Belly, 8cm, 5.6g

duo95410
Livrare 48-72 ore

76,15Lei

Carlig Offset Lestat DUO Realis Spin Hook, Mat Black, 1.8g, Nr.1/0, 3buc/pac

Carlig Offset Lestat DUO Realis Spin Hook, Mat Black, 1.8g, Nr.1/0, 3buc/pac

duo24557
Livrare 48-72 ore

48,69Lei

Vobler DUO Rough Trail Blazin 85, CPA0068 Midnight Gill, 8.5cm, 28g

Vobler DUO Rough Trail Blazin 85, CPA0068 Midnight Gill, 8.5cm, 28g

duo44401
Livrare 48-72 ore

92,41Lei

Vobler DUO Realis Fangbait 80DR, CMA3367 Chirai, 8cm, 11.5g

Vobler DUO Realis Fangbait 80DR, CMA3367 Chirai, 8cm, 11.5g

duo56039
Livrare 48-72 ore

102,58Lei

Cicada DUO Metal Garage Plate Jig, PXA0478 Green Gold Candy, 7cm, 30g

Cicada DUO Metal Garage Plate Jig, PXA0478 Green Gold Candy, 7cm, 30g

duo35607
Livrare 48-72 ore

62,92Lei

Vobler DUO Realis Shad 57MR SP, ACC3008 Neo Pearl, 5.7cm, 4.8g

Vobler DUO Realis Shad 57MR SP, ACC3008 Neo Pearl, 5.7cm, 4.8g

duo49697
Livrare 48-72 ore

72,07Lei

Vobler DUO Realis Jerkbait 100DR SP, DEA3341 AM Edge, 10cm, 15.6g

Vobler DUO Realis Jerkbait 100DR SP, DEA3341 AM Edge, 10cm, 15.6g

duo30572
Livrare 48-72 ore

75,13Lei

Afişare 101 - 120 din 1280 (64 pagini)
💬
WhatsApp Chat
👋 Salut! Cu ce vă pot ajuta?

Pot răspunde la întrebări despre:
✅ Comenzi și status livrare
✅ Informatii produse
✅ Recomandari produse(beta)
✅ Compatibilitate intre produse(beta)
Queries: 7, Total time: 105.663 ms [By time] [By id] [By file]
1 (0.174)
SELECT data
FROM `oc_session`
WHERE session_id = '8e9da902864863949f3402a3b1'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.098)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.128)
SELECT *
FROM oc_url_alias
WHERE keyword = 'duo.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (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 = '459' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (56.611)
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 = '459'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (48.367)
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, ps.price AS special, p.viewed, p.price
FROM oc_product p
LEFT JOIN (SELECT pss.price, pss.product_id
FROM oc_product_special pss GROUP BY pss.product_id) ps ON (ps.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.quantity > '0' AND p.price > '0' AND p2s.store_id = '0' AND p.manufacturer_id = '459' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 100,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.158)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37