DUO

DUO

Sortare după:

Cicada DUO Metal Garage Plate Jig, PHA0278 Blue Back Candy, 8cm, 40g

Cicada DUO Metal Garage Plate Jig, PHA0278 Blue Back Candy, 8cm, 40g

duo35751

Livrare 48-72 ore

70,03Lei

Cicada DUO Metal Garage Plate Jig, PMA0027 Mullet, 6.5cm, 20g

Cicada DUO Metal Garage Plate Jig, PMA0027 Mullet, 6.5cm, 20g

duo35409

Livrare 48-72 ore

56,82Lei

Vobler DUO Realis Popper 64F, ADA3093 Prism Smelt, 6.4cm, 9g

Vobler DUO Realis Popper 64F, ADA3093 Prism Smelt, 6.4cm, 9g

duo59064

Livrare 48-72 ore

69,02Lei

Cutie DUO Reversible Lure Case 120 Pearl Black - Gold Logo

duo48485

Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 50S SW, AHA4006 Ayu OB, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S SW, AHA4006 Ayu OB, 5cm, 4.5g

duo85909

Livrare 48-72 ore

69,02Lei

DUO Realis Spin 35 CDA3058 Prism Gill, 3.5cm, 7g

DUO Realis Spin 35 CDA3058 Prism Gill, 3.5cm, 7g

duo93259

Livrare 48-72 ore

69,02Lei

Vobler DUO Bay Ruf Tide Vib 60, ABA0289 Chart Back Candy, 6cm, 9.6g

Vobler DUO Bay Ruf Tide Vib 60, ABA0289 Chart Back Candy, 6cm, 9.6g

duo79175

Livrare 48-72 ore

75,13Lei

Vobler DUO Tide Minnow 75 Sprint, MCC0522 UV Silver Slash B, 7.5cm, 11g

Vobler DUO Tide Minnow 75 Sprint, MCC0522 UV Silver Slash B, 7.5cm, 11g

duo64645

Livrare 48-72 ore

85,29Lei

Vobler DUO Terrif DC-12 Type 1, GFN0134 Clear Sayori, 12cm, 18g

Vobler DUO Terrif DC-12 Type 1, GFN0134 Clear Sayori, 12cm, 18g

duo25762

Livrare 48-72 ore

102,58Lei

Vobler DUO Spearhead Ryuki 71S, ADA4093 UV Pink Chart Yamame OB, 7.1cm, 10g

Vobler DUO Spearhead Ryuki 71S, ADA4093 UV Pink Chart Yamame OB, 7.1cm, 10g

duo85725

Livrare 48-72 ore

90,37Lei

Vobler DUO Spearhead Ryuki 70S, AHA4037 Berry Bait, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, AHA4037 Berry Bait, 7cm, 9g

duo68721

Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 50S, ADA4125 Red Belly, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, ADA4125 Red Belly, 5cm, 4.5g

duo52621

Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 50S, GAA4005 Sapphire Lux, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, GAA4005 Sapphire Lux, 5cm, 4.5g

duo27732

Livrare 48-72 ore

69,02Lei

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

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

duo99534

Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 50S SW, ASI0106 Gigo, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S SW, ASI0106 Gigo, 5cm, 4.5g

duo14398

Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 45S, ADA4055 Chart Back Yamame OB, 4.5cm, 4g

Vobler Duo Spearhead Ryuki 45S, ADA4055 Chart Back Yamame OB, 4.5cm, 4g

duo57142

Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 38S, ASI4073 Pink Chart Yamame, 3.8cm, 2.8g

Vobler Duo Spearhead Ryuki 38S, ASI4073 Pink Chart Yamame, 3.8cm, 2.8g

duo72633

Livrare 48-72 ore

69,02Lei

Vobler DUO Spreadhead Ryuki 80SP, CRA3050 Half Mirror Ayu, 8cm, 5.6g

Vobler DUO Spreadhead Ryuki 80SP, CRA3050 Half Mirror Ayu, 8cm, 5.6g

duo95496

Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 50SP, ANA4034 Yamame, 5cm, 3.3g

Vobler DUO Spearhead Ryuki 50SP, ANA4034 Yamame, 5cm, 3.3g

duo03064

Livrare 48-72 ore

69,02Lei

Vobler DUO Rough Trail Blazin 85, CSHZ310 UV Sagoshi Clear Bait, 8.5cm, 28g

Vobler DUO Rough Trail Blazin 85, CSHZ310 UV Sagoshi Clear Bait, 8.5cm, 28g

duo62726

Livrare 48-72 ore

92,41Lei

Afişare 421 - 440 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: 90.910 ms [By time] [By id] [By file]

1 (0.120)

SELECT data
FROM `oc_session`
WHERE session_id = '0209fe6f5aaead37b93537e519'

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

2 (0.099)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.103)

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

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

4 (0.095)

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

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

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

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

7 (0.116)

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