DUO


Cicada DUO Metal Garage Plate Jig, PHA0011 Sardine, 6.5cm, 20g

Cicada DUO Metal Garage Plate Jig, PHA0011 Sardine, 6.5cm, 20g

duo35393
Livrare 48-72 ore

56,82Lei

Vobler DUO Realis Shad 57MR SP, AJA3055 Chart Gill Halo, 5.7cm, 4.8g

Vobler DUO Realis Shad 57MR SP, AJA3055 Chart Gill Halo, 5.7cm, 4.8g

duo19225
Livrare 48-72 ore

72,07Lei

Vobler DUO Realis Jerkbait 100DR SP, DTA3345 AM Hasu, 10cm, 15.6g

Vobler DUO Realis Jerkbait 100DR SP, DTA3345 AM Hasu, 10cm, 15.6g

duo30589
Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Crank 48MR Kabuki Floating, Chart Gill Halo, 4.8cm, 10.5gVobler DUO

Vobler DUO Realis Crank 48MR Kabuki Floating, Chart Gill Halo, 4.8cm, 10.5gVobler DUO

duo50266
Livrare 48-72 ore

72,07Lei

Vobler DUO Bay Ruf Tide Vib 70, ABA0289 Chart Back Candy, 7cm, 15.5g

Vobler DUO Bay Ruf Tide Vib 70, ABA0289 Chart Back Candy, 7cm, 15.5g

duo79915
Livrare 48-72 ore

82,24Lei

Vobler DUO Bayruf Bulk 95F, ACC0077 Ginrin Mat Chart, 9.5cm, 14g

Vobler DUO Bayruf Bulk 95F, ACC0077 Ginrin Mat Chart, 9.5cm, 14g

duo98459
Livrare 48-72 ore

109,70Lei

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, CEA0737 Lime Head Clear Gigo, 6cm, 9.6g

Vobler DUO Bay Ruf Tide Vib 60, CEA0737 Lime Head Clear Gigo, 6cm, 9.6g

duo89099
Livrare 48-72 ore

75,13Lei

Vobler DUO Tetra Works Totoshad, ACCC0075 Lemon Boost, 4.8cm, 4.5g

Vobler DUO Tetra Works Totoshad, ACCC0075 Lemon Boost, 4.8cm, 4.5g

duo42971
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki Vib 45, ADA4068 Yamame Red Belly, 4.5cm, 5.3g

Vobler DUO Spearhead Ryuki Vib 45, ADA4068 Yamame Red Belly, 4.5cm, 5.3g

duo86329
Livrare 48-72 ore

66,99Lei

Vobler DUO Spearhead Ryuki 71S, AHA4052 Peach Gold Yamame, 7.1cm, 10g

Vobler DUO Spearhead Ryuki 71S, AHA4052 Peach Gold Yamame, 7.1cm, 10g

duo73678
Livrare 48-72 ore

90,37Lei

Vobler DUO Spearhead Ryuki 70S, ANA4025 Iwana II, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, ANA4025 Iwana II, 7cm, 9g

duo14794
Livrare 48-72 ore

75,13Lei

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

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

duo94843
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 50S, MCC4018 Brown Back Yamame OB, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, MCC4018 Brown Back Yamame OB, 5cm, 4.5g

duo85018
Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 60S SW, AHA0087 Mazume Sardine, 6cm, 6.5g

Vobler Duo Spearhead Ryuki 60S SW, AHA0087 Mazume Sardine, 6cm, 6.5g

duo91644
Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 50F, ADA4013 Wakasagi, 5cm, 2.8g

Vobler DUO Spearhead Ryuki 50F, ADA4013 Wakasagi, 5cm, 2.8g

duo63276
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 70SP, MCC4036 Rainbow Trout, 7cm, 4.1g

Vobler DUO Spreadhead Ryuki 70SP, MCC4036 Rainbow Trout, 7cm, 4.1g

duo95335
Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 50F, GEA3006 Ghost Minnow, 5cm, 2.8g

Vobler DUO Spearhead Ryuki 50F, GEA3006 Ghost Minnow, 5cm, 2.8g

duo63443
Livrare 48-72 ore

69,02Lei

Afişare 581 - 600 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: 139.497 ms [By time] [By id] [By file]
1 (0.101)
SELECT data
FROM `oc_session`
WHERE session_id = '9ddba5635ce024f7229295ef2f'
/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.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'duo.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.143)
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 (61.488)
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 (77.371)
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 580,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.151)
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