DUO


Vobler Duo Realis Vibration 68 G-Fix, Iris Flare, 6.8cm, 21g

Vobler Duo Realis Vibration 68 G-Fix, Iris Flare, 6.8cm, 21g

duo25301
Livrare imediată!

74,21Lei

Vobler Duo Realis Vibration 68 Apex Tune, Kohoku Purple Kinkuro, 6.8cm, 14.3g

Vobler Duo Realis Vibration 68 Apex Tune, Kohoku Purple Kinkuro, 6.8cm, 14.3g

duo74354
Livrare imediată!

71,16Lei

Chatter Shad DUO Bay Ruf, PCC0668 LG Blue Pink, 18g

Chatter Shad DUO Bay Ruf, PCC0668 LG Blue Pink, 18g

duo84704
Livrare 48-72 ore

78,18Lei

Shad DUO Realis Versa Pintail, F082 Green Pumpkin Chartreuse, 10cm, 7buc/pac

Shad DUO Realis Versa Pintail, F082 Green Pumpkin Chartreuse, 10cm, 7buc/pac

duo90347
Livrare 48-72 ore

39,54Lei

Inele Despicate DUO Original Split Ring, Nr.1, 38buc/plic

Inele Despicate DUO Original Split Ring, Nr.1, 38buc/plic

duo77655
Livrare 48-72 ore

13,10Lei

Vobler DUO Spearhead Ryuki Quattro 70S, CDA4055 Chart Back Yamame OB, 7cm 5.7g

Vobler DUO Spearhead Ryuki Quattro 70S, CDA4055 Chart Back Yamame OB, 7cm 5.7g

duo73630
Livrare 48-72 ore

110,72Lei

Shad DUO Realis Versa Shad Fat, F077 Bluegill Flash, 17.8cm, 3buc/pac

Shad DUO Realis Versa Shad Fat, F077 Bluegill Flash, 17.8cm, 3buc/pac

duo88115
Livrare 48-72 ore

85,29Lei

Shad DUO Realis Versa Shad, F084 Lime Chartreuse UV, 7.6cm, 10buc/pac

Shad DUO Realis Versa Shad, F084 Lime Chartreuse UV, 7.6cm, 10buc/pac

duo78444
Livrare 48-72 ore

36,49Lei

Shad DUO Realis Versa Pintail, F087 Young Melon, 7.6cm, 10buc/pac

Shad DUO Realis Versa Pintail, F087 Young Melon, 7.6cm, 10buc/pac

duo80232
Livrare 48-72 ore

36,49Lei

Vobler DUO Realis Jerkbait 110SP, ADA3058 Prism Gill, 11cm, 16.2g

Vobler DUO Realis Jerkbait 110SP, ADA3058 Prism Gill, 11cm, 16.2g

duo66703
Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 120SP, CLB0230 Ghost Pearl Chart, 12cm, 17.7g

Vobler DUO Realis Jerkbait 120SP, CLB0230 Ghost Pearl Chart, 12cm, 17.7g

duo69237
Livrare 48-72 ore

86,31Lei

Vobler DUO Realis Rozante 77SP, CCC3019 Mat Pink Tiger, 7.7cm, 8.4g

Vobler DUO Realis Rozante 77SP, CCC3019 Mat Pink Tiger, 7.7cm, 8.4g

duo77294
Livrare 48-72 ore

78,18Lei

Vobler DUO Realis Rozante 63SP, CCC3864 Perch ND, 6.3cm, 5g

Vobler DUO Realis Rozante 63SP, CCC3864 Perch ND, 6.3cm, 5g

duo17832
Livrare 48-72 ore

73,08Lei

Vobler DUO BayRuf Manic 95, CCC0715 Mat Orange Pink Back, 9.5cm, 8g

Vobler DUO BayRuf Manic 95, CCC0715 Mat Orange Pink Back, 9.5cm, 8g

duo83486
Livrare 48-72 ore

78,18Lei

Spinnertail DUO Realis Spin 35, CDA3185 Itako Green Gold, 3.5cm, 7g

Spinnertail DUO Realis Spin 35, CDA3185 Itako Green Gold, 3.5cm, 7g

duo00292
Livrare 48-72 ore

69,02Lei

Vobler DUO Realis Jerkbait 110 SP 11cm 16.2g CCC3162 Chartreuse Shad

Vobler DUO Realis Jerkbait 110 SP 11cm 16.2g CCC3162 Chartreuse Shad

duo86473
Livrare imediată!

79,29Lei

Vobler DUO Realis Apex Crank 66 Squared, ACC3018 Smokey Bone, 6.6cm, 17.7g

Vobler DUO Realis Apex Crank 66 Squared, ACC3018 Smokey Bone, 6.6cm, 17.7g

duo79656
Livrare 48-72 ore

82,24Lei

Vobler DUO Ryuki Vib 45 4.5cm 5.3g GPA4009 River Bait S

Vobler DUO Ryuki Vib 45 4.5cm 5.3g GPA4009 River Bait S

duo11762
Livrare 48-72 ore

66,99Lei

Vobler Duo Realis Vibration 62 G-Fix, Iwana ll, 6.2cm, 14.5g

Vobler Duo Realis Vibration 62 G-Fix, Iwana ll, 6.2cm, 14.5g

duo83073
Livrare 48-72 ore

75,13Lei

Shad DUO Realis Versa, F076 White Back Shad, 10cm, 7buc/pac

Shad DUO Realis Versa, F076 White Back Shad, 10cm, 7buc/pac

duo90095
Livrare 48-72 ore

39,54Lei

Afişare 1141 - 1160 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.509 ms [By time] [By id] [By file]
1 (0.083)
SELECT data
FROM `oc_session`
WHERE session_id = '00a26975423ac3faa3638a5a20'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.096)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.087)
SELECT *
FROM oc_url_alias
WHERE keyword = 'duo.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.098)
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 (38.141)
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.772)
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 1140,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.232)
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