DUO


Vobler DUO Tetra Works Toto Fat 35S, CCC0077 UVGold Wglow, 3.5cm, 12.1g

Vobler DUO Tetra Works Toto Fat 35S, CCC0077 UVGold Wglow, 3.5cm, 12.1g

duo30121
Livrare 48-72 ore

69,02Lei

Vobler DUO Tetra Works Kurakura S, AJA0305 Gold Red Head, 3cm, 2.9g

Vobler DUO Tetra Works Kurakura S, AJA0305 Gold Red Head, 3cm, 2.9g

duo23086
Livrare 48-72 ore

72,07Lei

Lingurita Rotativa DUO Spearhead Ryuki Spinner, ACC0591 Mat Black, 2cm, 3.5g

Lingurita Rotativa DUO Spearhead Ryuki Spinner, ACC0591 Mat Black, 2cm, 3.5g

duo57333
Livrare 48-72 ore

41,58Lei

Vobler DUO Spearhead Ryuki 80S, ASA4014 Himemasu, 8cm, 12g

Vobler DUO Spearhead Ryuki 80S, ASA4014 Himemasu, 8cm, 12g

duo11656
Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 70S SW, AQA0111 White Glow, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S SW, AQA0111 White Glow, 7cm, 9g

duo10901
Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 70S, MCC4010 Metal Ayu, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, MCC4010 Metal Ayu, 7cm, 9g

duo52393
Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 50S, ANA4834 Yamame ND II, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, ANA4834 Yamame ND II, 5cm, 4.5g

duo45774
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 60S, AJO4064 Ivory Yamame OB, 6cm, 6.5g

Vobler DUO Spearhead Ryuki 60S, AJO4064 Ivory Yamame OB, 6cm, 6.5g

duo44869
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 51S, MCC0552 UV Silver Slash B, 5.1cm, 5.5g

Vobler DUO Spearhead Ryuki 51S, MCC0552 UV Silver Slash B, 5.1cm, 5.5g

duo61385
Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 46S, ADA4068 Yamame Red Belly, 4.6cm, 5g

Vobler DUO Spearhead Ryuki 46S, ADA4068 Yamame Red Belly, 4.6cm, 5g

duo61286
Livrare 48-72 ore

77,16Lei

Vobler Duo Spearhead Ryuki 45S, ASI4073 Pink Chart Yamame, 4.5cm, 4g

Vobler Duo Spearhead Ryuki 45S, ASI4073 Pink Chart Yamame, 4.5cm, 4g

duo72657
Livrare 48-72 ore

69,02Lei

Vobler DUO Rough Trail Aomasa Lightning 190F, CSH0867 Clear Bait Glitter, 19cm, 74g

Vobler DUO Rough Trail Aomasa Lightning 190F, CSH0867 Clear Bait Glitter, 19cm, 74g

duo76983
Livrare 48-72 ore

204,26Lei

Vobler DUO Spreadhead Ryuki 70MDSP, MCC4084 Gold Yamame, 7cm, 5.6g

Vobler DUO Spreadhead Ryuki 70MDSP, MCC4084 Gold Yamame, 7cm, 5.6g

duo95236
Livrare 48-72 ore

76,15Lei

Vobler DUO Tide Minnow 75S Sprint, AHA0087 Mazume Sardine, 7.5cm, 11g

Vobler DUO Tide Minnow 75S Sprint, AHA0087 Mazume Sardine, 7.5cm, 11g

duo64591
Livrare 48-72 ore

85,29Lei

Vobler DUO Spearhead Ryuki 50MDSP, CPA4009 River Bait, 5cm, 3.4g

Vobler DUO Spearhead Ryuki 50MDSP, CPA4009 River Bait, 5cm, 3.4g

duo95151
Livrare 48-72 ore

69,02Lei

Vobler DUO Realis Spinbait 62 Alpha, GEA3006 Ghost Minnow, 6.2cm, 10.9g

Vobler DUO Realis Spinbait 62 Alpha, GEA3006 Ghost Minnow, 6.2cm, 10.9g

duo44203
Livrare 48-72 ore

70,03Lei

Cicada DUO Metal Garage Plate Jig, PXA0471 Pink Candy, 8cm, 40g

Cicada DUO Metal Garage Plate Jig, PXA0471 Pink Candy, 8cm, 40g

duo35744
Livrare 48-72 ore

70,03Lei

Vobler DUO Realis Shad 59MR SP, ACC3008 Neo Pearl, 5.9cm, 4.7g

Vobler DUO Realis Shad 59MR SP, ACC3008 Neo Pearl, 5.9cm, 4.7g

duo53444
Livrare 48-72 ore

69,02Lei

Vobler DUO Realis Pencil 85 SW, DHN0157 Waka Mullet, 8.5cm, 9.7g

Vobler DUO Realis Pencil 85 SW, DHN0157 Waka Mullet, 8.5cm, 9.7g

duo20955
Livrare 48-72 ore

70,03Lei

Vobler DUO Bay Ruf Tide Vib 60, ACC0022 Bay White, 6cm, 9.6g

Vobler DUO Bay Ruf Tide Vib 60, ACC0022 Bay White, 6cm, 9.6g

duo79212
Livrare 48-72 ore

75,13Lei

Afişare 1 - 20 din 1281 (65 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: 84.135 ms [By time] [By id] [By file]
1 (0.131)
SELECT data
FROM `oc_session`
WHERE session_id = 'bfb8c824eda6231c02b7e9e977'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.108)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.132)
SELECT *
FROM oc_url_alias
WHERE keyword = 'duo.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.128)
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 = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (35.816)
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 = '2' AND p.manufacturer_id = '459'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (47.709)
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 = '2' AND p.manufacturer_id = '459' 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:440
7 (0.111)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37