DUO


Vobler DUO Tide Minnow 75S Sprint, DJA0101 Zebra Glow, 7.5cm, 11g

Vobler DUO Tide Minnow 75S Sprint, DJA0101 Zebra Glow, 7.5cm, 11g

duo22836
Livrare 48-72 ore

85,29Lei

Vobler DUO Spearhead Ryuki 50MDSP, ANA4010 Ayu, 5cm, 3.4g

Vobler DUO Spearhead Ryuki 50MDSP, ANA4010 Ayu, 5cm, 3.4g

duo95090
Livrare 48-72 ore

69,02Lei

Vobler DUO Realis Spinbait 62 Alpha, CCC3190 Ghost M Shad, 6.2cm, 10.9g

Vobler DUO Realis Spinbait 62 Alpha, CCC3190 Ghost M Shad, 6.2cm, 10.9g

duo44142
Livrare 48-72 ore

70,03Lei

Cicada DUO Metal Garage Plate Jig, PHA0279 Tsuregisu GB, 8cm, 40g

Cicada DUO Metal Garage Plate Jig, PHA0279 Tsuregisu GB, 8cm, 40g

duo35645
Livrare 48-72 ore

70,03Lei

Cicada DUO Metal Garage Plate Jig, PPA0026 Red Gold, 6.5cm, 20g

Cicada DUO Metal Garage Plate Jig, PPA0026 Red Gold, 6.5cm, 20g

duo35331
Livrare 48-72 ore

56,82Lei

Vobler DUO Realis Popper 64F, GEA3006 Ghost Minnow, 6.4cm, 9g

Vobler DUO Realis Popper 64F, GEA3006 Ghost Minnow, 6.4cm, 9g

duo59071
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 50S SW, DHN0402 Belone, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S SW, DHN0402 Belone, 5cm, 4.5g

duo14428
Livrare 48-72 ore

69,02Lei

Vobler DUO Bay Ruf Tide Vib 60, CEA0674 Clear Chart Mirage, 6cm, 9.6g

Vobler DUO Bay Ruf Tide Vib 60, CEA0674 Clear Chart Mirage, 6cm, 9.6g

duo79243
Livrare 48-72 ore

75,13Lei

Vobler DUO Tetra Works Totoshad, ASA0026 Red Gold, 4.8cm, 4.5g

Vobler DUO Tetra Works Totoshad, ASA0026 Red Gold, 4.8cm, 4.5g

duo61180
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki Vib 45, ADA4019 Pink Yamame, 4.5cm, 5.3g

Vobler DUO Spearhead Ryuki Vib 45, ADA4019 Pink Yamame, 4.5cm, 5.3g

duo86305
Livrare 48-72 ore

66,99Lei

Vobler DUO Spearhead Ryuki 71S, ADA4140 Lime Yamame OB, 7.1cm, 10g

Vobler DUO Spearhead Ryuki 71S, ADA4140 Lime Yamame OB, 7.1cm, 10g

duo73739
Livrare 48-72 ore

90,37Lei

Vobler DUO Spearhead Ryuki 70S, AJO4064 Ivory Yamame OB, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, AJO4064 Ivory Yamame OB, 7cm, 9g

duo44876
Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 50S, ADA4140 Lime Yamame OB, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, ADA4140 Lime Yamame OB, 5cm, 4.5g

duo61913
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 50S, GPA4009 River Bait, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, GPA4009 River Bait, 5cm, 4.5g

duo11403
Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 60S SW, ADA0088 Prism Ivory, 6cm, 6.5g

Vobler Duo Spearhead Ryuki 60S SW, ADA0088 Prism Ivory, 6cm, 6.5g

duo91606
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 50S SW, DHA0574 Holo Red Head GB, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S SW, DHA0574 Holo Red Head GB, 5cm, 4.5g

duo51867
Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 45S, ADA4059 Green Gold OB, 4.5cm, 4g

Vobler Duo Spearhead Ryuki 45S, ADA4059 Green Gold OB, 4.5cm, 4g

duo30827
Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 38S, MCC4026 Metal Red Gold, 3.8cm, 2.8g

Vobler Duo Spearhead Ryuki 38S, MCC4026 Metal Red Gold, 3.8cm, 2.8g

duo16903
Livrare 48-72 ore

69,02Lei

Vobler DUO Spreadhead Ryuki 80SP, CRA3061 Komochi Wakasagi, 8cm, 5.6g

Vobler DUO Spreadhead Ryuki 80SP, CRA3061 Komochi Wakasagi, 8cm, 5.6g

duo95489
Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 51S, ADA4071 Hokkaido, 5.1cm, 5.5g

Vobler DUO Spearhead Ryuki 51S, ADA4071 Hokkaido, 5.1cm, 5.5g

duo72435
Livrare 48-72 ore

75,13Lei

Afişare 261 - 280 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: 96.736 ms [By time] [By id] [By file]
1 (0.154)
SELECT data
FROM `oc_session`
WHERE session_id = '8431b9fcde6230c5a848fd4c51'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.088)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.088)
SELECT *
FROM oc_url_alias
WHERE keyword = 'duo.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.088)
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 (39.912)
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 (56.275)
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 260,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.131)
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