DUO


Vobler DUO Spearhead Ryuki 51S, ADA4059 Green Gold OB, 5.1cm, 5.5g

Vobler DUO Spearhead Ryuki 51S, ADA4059 Green Gold OB, 5.1cm, 5.5g

duo61439
Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 46S, ACC3059 Mat Tiger, 4.6cm, 5g

Vobler DUO Spearhead Ryuki 46S, ACC3059 Mat Tiger, 4.6cm, 5g

duo72428
Livrare 48-72 ore

77,16Lei

Vobler Duo Spearhead Ryuki 45S, ANA4027 Artic Char II, 4.5cm, 4g

Vobler Duo Spearhead Ryuki 45S, ANA4027 Artic Char II, 4.5cm, 4g

duo13605
Livrare 48-72 ore

69,02Lei

Vobler DUO Rough Trail Blazin 70, CSB0054 Genkai Sardine, 7cm, 20g

Vobler DUO Rough Trail Blazin 70, CSB0054 Genkai Sardine, 7cm, 20g

duo43619
Livrare 48-72 ore

91,39Lei

Vobler DUO Spreadhead Ryuki 70MDF, CEA3006 Ghost Minnow, 7cm, 5.4g

Vobler DUO Spreadhead Ryuki 70MDF, CEA3006 Ghost Minnow, 7cm, 5.4g

duo93515
Livrare 48-72 ore

76,15Lei

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

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

duo36263
Livrare 48-72 ore

85,29Lei

Vobler DUO Spearhead Ryuki 70F, GSN4011 Stream Shad, 7cm, 5.3g

Vobler DUO Spearhead Ryuki 70F, GSN4011 Stream Shad, 7cm, 5.3g

duo77426
Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Spinbait 62 Alpha, CCC3162 Chartreuse Shad, 6.2cm, 10.9g

Vobler DUO Realis Spinbait 62 Alpha, CCC3162 Chartreuse Shad, 6.2cm, 10.9g

duo44128
Livrare 48-72 ore

70,03Lei

Jig DUO Bayruf BR Head Jig, Nr.1/0, 5g, 4buc/pac

Jig DUO Bayruf BR Head Jig, Nr.1/0, 5g, 4buc/pac

duo68209
Livrare 48-72 ore

34,45Lei

Spinnertail DUO Realis Spin 30 SW, ACC0170 Pearl Chart OB II, 3cm, 5g

Spinnertail DUO Realis Spin 30 SW, ACC0170 Pearl Chart OB II, 3cm, 5g

duo79762
Livrare 48-72 ore

69,02Lei

Vobler DUO Realis Shinmushi, CCC3233 Sunset Moth F, 4.0cm, 5.7g

Vobler DUO Realis Shinmushi, CCC3233 Sunset Moth F, 4.0cm, 5.7g

duo01374
Livrare 48-72 ore

72,07Lei

Vobler DUO Ryuki 45S 4.5cm 4g ACC3059 Mat Tiger S

Vobler DUO Ryuki 45S 4.5cm 4g ACC3059 Mat Tiger S

duo71646
Livrare imediată!

69,02Lei

Vobler DUO Realis Jerkbait 120 SP 12cm 18g DEA3341 AM Edge

Vobler DUO Realis Jerkbait 120 SP 12cm 18g DEA3341 AM Edge

duo36901
Livrare 48-72 ore

86,31Lei

Vobler Duo Realis Vibration 68 G-Fix, Goby Gill, 6.8cm, 21g

Vobler Duo Realis Vibration 68 G-Fix, Goby Gill, 6.8cm, 21g

duo64518
Livrare imediată!

74,21Lei

Vobler Duo Realis Vibration 65 Apex Tune, Red Tiger, 6.5cm, 17.5g

Vobler Duo Realis Vibration 65 Apex Tune, Red Tiger, 6.5cm, 17.5g

duo37281
Livrare imediată!

71,16Lei

Chatter Shad DUO Bay Ruf, PCC0722 LG Violet Shiner, 18g

Chatter Shad DUO Bay Ruf, PCC0722 LG Violet Shiner, 18g

duo84735
Livrare 48-72 ore

78,18Lei

Shad DUO Realis Versa Pintail, F085 Sexy Shad UV, 10cm, 7buc/pac

Shad DUO Realis Versa Pintail, F085 Sexy Shad UV, 10cm, 7buc/pac

duo90378
Livrare 48-72 ore

39,54Lei

Inele Despicate DUO Original Split Ring, Nr.2.5, 252buc/plic

Inele Despicate DUO Original Split Ring, Nr.2.5, 252buc/plic

duo16651
Livrare imediată!

12,18Lei

Vobler DUO Spearhead Ryuki Quattro 90S, CCCZ214 RP Loach, 9cm 14g

Vobler DUO Spearhead Ryuki Quattro 90S, CCCZ214 RP Loach, 9cm 14g

duo58095
Livrare 48-72 ore

130,03Lei

Shad DUO Realis Versa Shad Fat, F088 Light Pro Blue, 17.8cm, 3buc/pac

Shad DUO Realis Versa Shad Fat, F088 Light Pro Blue, 17.8cm, 3buc/pac

duo88146
Livrare 48-72 ore

85,29Lei

Afişare 761 - 780 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: 94.434 ms [By time] [By id] [By file]
1 (0.093)
SELECT data
FROM `oc_session`
WHERE session_id = '8cd458701bfba0166ceb8747c6'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.103)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.147)
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 (49.158)
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.675)
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 760,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.165)
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