DUO

DUO

Sortare după:

Cutie DUO Reversible Lure Case 100 Pearl Black - Gold Logo

duo48478

Livrare 48-72 ore

65,97Lei

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 80, AHA0087 Mazume Sardine, 8cm, 25g

Vobler DUO Bay Ruf Tide Vib 80, AHA0087 Mazume Sardine, 8cm, 25g

duo89235

Livrare 48-72 ore

88,34Lei

Spinnertail DUO Realis Spin 38, CCC3028 Ghost Chart, 3.8cm, 11g

Spinnertail DUO Realis Spin 38, CCC3028 Ghost Chart, 3.8cm, 11g

duo04184

Livrare 48-72 ore

69,02Lei

Vobler DUO Tetra Works Toto Fat 35F, MCC0522 UV Silver Slash B, 3.5cm, 1.8g

Vobler DUO Tetra Works Toto Fat 35F, MCC0522 UV Silver Slash B, 3.5cm, 1.8g

duo55889

Livrare 48-72 ore

69,02Lei

Vobler DUO Tetra Works Kurakura SF, GBA0291 Red Isome, 3cm, 2.5g

Vobler DUO Tetra Works Kurakura SF, GBA0291 Red Isome, 3cm, 2.5g

duo91958

Livrare 48-72 ore

72,07Lei

Lingurita Rotativa DUO Spearhead Ryuki Spinner, PNA4010 Ayu, 2cm, 5g

Lingurita Rotativa DUO Spearhead Ryuki Spinner, PNA4010 Ayu, 2cm, 5g

duo57395

Livrare 48-72 ore

41,58Lei

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

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

duo43599

Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 70S SW, ADA0088 Prism Ivory, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S SW, ADA0088 Prism Ivory, 7cm, 9g

duo15517

Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 70S, GPA4009 River Bait, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, GPA4009 River Bait, 7cm, 9g

duo11441

Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 50S, MCC4036 Rainbow Trout, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, MCC4036 Rainbow Trout, 5cm, 4.5g

duo30995

Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 60S SW, DHN0402 Belone, 6cm, 6.5g

Vobler Duo Spearhead Ryuki 60S SW, DHN0402 Belone, 6cm, 6.5g

duo13490

Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 50F, DAA4005 Sapphire Lux, 5cm, 2.8g

Vobler DUO Spearhead Ryuki 50F, DAA4005 Sapphire Lux, 5cm, 2.8g

duo30350

Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 45S, ADA4093 UV Pink Chart Yamame OB, 4.5cm, 4g

Vobler Duo Spearhead Ryuki 45S, ADA4093 UV Pink Chart Yamame OB, 4.5cm, 4g

duo85367

Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 38S, MNI4047 Tennessee Shad, 3.8cm, 2.8g

Vobler Duo Spearhead Ryuki 38S, MNI4047 Tennessee Shad, 3.8cm, 2.8g

duo16873

Livrare 48-72 ore

69,02Lei

Spinnertail DUO Realis Spin 40, ACC3016 Blue Back Chart, 4cm, 14g

Spinnertail DUO Realis Spin 40, ACC3016 Blue Back Chart, 4cm, 14g

duo50228

Livrare 48-72 ore

69,02Lei

Vobler DUO Spreadhead Ryuki 80SP, MCC4036 Rainbow Trout, 8cm, 5.6g

Vobler DUO Spreadhead Ryuki 80SP, MCC4036 Rainbow Trout, 8cm, 5.6g

duo95434

Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 70F, ADA3058 Prism Gill, 7cm, 5.3g

Vobler DUO Spearhead Ryuki 70F, ADA3058 Prism Gill, 7cm, 5.3g

duo63672

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Spinbait 62 Alpha, ADA3058 Prism Gill, 6.2cm, 10.9g

Vobler DUO Realis Spinbait 62 Alpha, ADA3058 Prism Gill, 6.2cm, 10.9g

duo44067

Livrare 48-72 ore

70,03Lei

Cicada DUO Metal Garage Plate Jig, PHA0011 Sardine, 8cm, 40g

Cicada DUO Metal Garage Plate Jig, PHA0011 Sardine, 8cm, 40g

duo35713

Livrare 48-72 ore

70,03Lei

Afişare 661 - 680 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: 87.002 ms [By time] [By id] [By file]

1 (0.125)

SELECT data
FROM `oc_session`
WHERE session_id = '82cb532f8b149e05d681892dd4'

/var/www/clients/client1/web1/web/system/library/session/db.php:24

2 (0.089)

SELECT `trigger`, `action`
FROM oc_event

/var/www/clients/client1/web1/web/index.php:453

3 (0.114)

SELECT *
FROM oc_url_alias
WHERE keyword = 'duo.html'

/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48

4 (0.109)

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 (37.646)

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.776)

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 660,20

/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440

7 (0.143)

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