DUO


Vobler DUO Spearhead Ryuki 95S WT, CYA0592 UV Sparkle Sillago Glow, 9.5cm, 17g

Vobler DUO Spearhead Ryuki 95S WT, CYA0592 UV Sparkle Sillago Glow, 9.5cm, 17g

duo89341
Livrare 48-72 ore

79,19Lei

Vobler DUO Tetra Works Toto Fat 35F, CCC0076 UV Silver, 3.5cm, 1.8g

Vobler DUO Tetra Works Toto Fat 35F, CCC0076 UV Silver, 3.5cm, 1.8g

duo30237
Livrare 48-72 ore

69,02Lei

Vobler DUO Tetra Works Kurakura SF, ASA0328 Red Gold, 3cm, 2.5g

Vobler DUO Tetra Works Kurakura SF, ASA0328 Red Gold, 3cm, 2.5g

duo82079
Livrare 48-72 ore

72,07Lei

Lingurita Rotativa DUO Spearhead Ryuki Spinner, PHA0055 Green Gold, 2cm, 5g

Lingurita Rotativa DUO Spearhead Ryuki Spinner, PHA0055 Green Gold, 2cm, 5g

duo57388
Livrare 48-72 ore

41,58Lei

Vobler DUO Spearhead Ryuki 80S, AHA4006 Ayu OB, 8cm, 12g

Vobler DUO Spearhead Ryuki 80S, AHA4006 Ayu OB, 8cm, 12g

duo11458
Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 70S SW, ACC3008 Neo Pearl, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S SW, ACC3008 Neo Pearl, 7cm, 9g

duo10895
Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 70S, COA0585 Yozakura, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, COA0585 Yozakura, 7cm, 9g

duo86852
Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 50S, ANA4043 Militia RB, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, ANA4043 Militia RB, 5cm, 4.5g

duo86275
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 60S, ADA4013 Wakasagi, 6cm, 6.5g

Vobler DUO Spearhead Ryuki 60S, ADA4013 Wakasagi, 6cm, 6.5g

duo53536
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 51S, ADA4140 Lime Yamame OB, 5.1cm, 5.5g

Vobler DUO Spearhead Ryuki 51S, ADA4140 Lime Yamame OB, 5.1cm, 5.5g

duo61507
Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 46S, ACC4072 Full Orange Yamame RB, 4.6cm, 5g

Vobler DUO Spearhead Ryuki 46S, ACC4072 Full Orange Yamame RB, 4.6cm, 5g

duo61231
Livrare 48-72 ore

77,16Lei

Vobler Duo Spearhead Ryuki 45S, ANA4076 Pink Clown Yamame, 4.5cm, 4g

Vobler Duo Spearhead Ryuki 45S, ANA4076 Pink Clown Yamame, 4.5cm, 4g

duo72640
Livrare 48-72 ore

69,02Lei

Vobler DUO Rough Trail Aomasa Lightning 190F, CPA0411 Fusilier, 19cm, 74g

Vobler DUO Rough Trail Aomasa Lightning 190F, CPA0411 Fusilier, 19cm, 74g

duo87910
Livrare 48-72 ore

204,26Lei

Vobler DUO Spreadhead Ryuki 70MDSP, CEA3006 Ghost Minnow, 7cm, 5.6g

Vobler DUO Spreadhead Ryuki 70MDSP, CEA3006 Ghost Minnow, 7cm, 5.6g

duo95205
Livrare 48-72 ore

76,15Lei

Vobler DUO Tide Minnow 75S Sprint, ACC0170 Pearl Chart OB II, 7.5cm, 11g

Vobler DUO Tide Minnow 75S Sprint, ACC0170 Pearl Chart OB II, 7.5cm, 11g

duo82581
Livrare 48-72 ore

85,29Lei

Vobler DUO Spearhead Ryuki 50MDSP, ADA4013 Wakasagi, 5cm, 3.4g

Vobler DUO Spearhead Ryuki 50MDSP, ADA4013 Wakasagi, 5cm, 3.4g

duo95120
Livrare 48-72 ore

69,02Lei

Vobler DUO Realis Spinbait 62 Alpha, CCC3339 CL Dace, 6.2cm, 10.9g

Vobler DUO Realis Spinbait 62 Alpha, CCC3339 CL Dace, 6.2cm, 10.9g

duo44166
Livrare 48-72 ore

70,03Lei

Cicada DUO Metal Garage Plate Jig, PMA0027 Mullet, 8cm, 40g

Cicada DUO Metal Garage Plate Jig, PMA0027 Mullet, 8cm, 40g

duo35720
Livrare 48-72 ore

70,03Lei

Cicada DUO Metal Garage Plate Jig, PPA0063 Hirame Gold, 6.5cm, 20g

Cicada DUO Metal Garage Plate Jig, PPA0063 Hirame Gold, 6.5cm, 20g

duo35348
Livrare 48-72 ore

56,82Lei

Vobler DUO Realis Popper 64F, GHA3138 Midnight Black II, 6.4cm, 9g

Vobler DUO Realis Popper 64F, GHA3138 Midnight Black II, 6.4cm, 9g

duo81812
Livrare 48-72 ore

69,02Lei

Afişare 321 - 340 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: 82.959 ms [By time] [By id] [By file]
1 (0.110)
SELECT data
FROM `oc_session`
WHERE session_id = '8aaa1e613205e7d340c10bd74a'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.078)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.081)
SELECT *
FROM oc_url_alias
WHERE keyword = 'duo.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.093)
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 (38.089)
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 (44.362)
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 320,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.146)
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