DUO

DUO

Sortare după:

Vobler DUO Realis Rozante 63SP, CCC3517 Mat Bone, 6.3cm, 5g

Vobler DUO Realis Rozante 63SP, CCC3517 Mat Bone, 6.3cm, 5g

duo75184

Livrare 48-72 ore

73,08Lei

Vobler DUO BayRuf Manic 95, ACC0580 Red Hot Chili, 9.5cm, 8g

Vobler DUO BayRuf Manic 95, ACC0580 Red Hot Chili, 9.5cm, 8g

duo56619

Livrare 48-72 ore

78,18Lei

Spinnertail DUO Realis Spin 35, ACCZ049 Ivory Pearl, 3.5cm, 7g

Spinnertail DUO Realis Spin 35, ACCZ049 Ivory Pearl, 3.5cm, 7g

duo70967

Livrare 48-72 ore

69,02Lei

VOBLER DUO RYUKI 45S 4.5CM 4G ADA4068 YAMAME RED BELLY S

VOBLER DUO RYUKI 45S 4.5CM 4G ADA4068 YAMAME RED BELLY S

duo30834

Livrare imediată!

68,11Lei

Vobler DUO Realis Vibration 55 Nitro 5.5cm 11.5g CCC3069 Red Tiger S

Vobler DUO Realis Vibration 55 Nitro 5.5cm 11.5g CCC3069 Red Tiger S

duo37304

Livrare imediată!

68,99Lei(-17%) 57,12Lei

Vobler DUO Realis Jerkbait 100 SP 10cm 14.5g DTA3345 AM Hasu

Vobler DUO Realis Jerkbait 100 SP 10cm 14.5g DTA3345 AM Hasu

duo30398

Livrare 48-72 ore

75,13Lei

Vobler DUO Ryuki 60S, GAA4005 Sapphire Lux S, 6cm, 6.5g

Vobler DUO Ryuki 60S, GAA4005 Sapphire Lux S, 6cm, 6.5g

duo28470

Livrare 48-72 ore

69,02Lei

Vobler Duo Realis Vibration 62 G-Fix, Red Tiger, 6.2cm, 14.5g

Vobler Duo Realis Vibration 62 G-Fix, Red Tiger, 6.2cm, 14.5g

duo58135

Livrare imediată!

74,21Lei

Vobler Duo Realis Vibration 65 Nitro, Burning Tiger, 5.5cm, 11.5g

Vobler Duo Realis Vibration 65 Nitro, Burning Tiger, 5.5cm, 11.5g

duo19546

Livrare imediată!

71,16Lei

Shad DUO Realis Versa Pintail, F089 Sky Blue Chart, 10cm, 7buc/pac

Shad DUO Realis Versa Pintail, F089 Sky Blue Chart, 10cm, 7buc/pac

duo90415

Livrare 48-72 ore

39,54Lei

Shad DUO Realis Versa Shad Fat, F099 Rikyu, 12.5cm, 5buc/pac

Shad DUO Realis Versa Shad Fat, F099 Rikyu, 12.5cm, 5buc/pac

duo87804

Livrare 48-72 ore

52,76Lei

Shad DUO Realis Versa Pintail, F075 Chartreuse Shad, 7.6cm, 10buc/pac

Shad DUO Realis Versa Pintail, F075 Chartreuse Shad, 7.6cm, 10buc/pac

duo78475

Livrare 48-72 ore

36,49Lei

Vobler DUO Realis Jerkbait 100SP, CCC3314 LG Young Ayu, 10cm, 14.5g

Vobler DUO Realis Jerkbait 100SP, CCC3314 LG Young Ayu, 10cm, 14.5g

duo31500

Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 120SP, ADA3077 All Bait, 12cm, 17.7g

Vobler DUO Realis Jerkbait 120SP, ADA3077 All Bait, 12cm, 17.7g

duo51495

Livrare 48-72 ore

86,31Lei

Vobler DUO Realis Jerkbait 85SP, ASI4044 Full Chart Yamame, 8.5cm, 8g

Vobler DUO Realis Jerkbait 85SP, ASI4044 Full Chart Yamame, 8.5cm, 8g

duo28753

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Rozante 63SP, ADA4013 Wakasagi, 6.3cm, 5g

Vobler DUO Realis Rozante 63SP, ADA4013 Wakasagi, 6.3cm, 5g

duo91040

Livrare 48-72 ore

73,08Lei

Vobler DUO Luayu VIB, CCC4529 Ougonayu, 10cm, 15g

Vobler DUO Luayu VIB, CCC4529 Ougonayu, 10cm, 15g

duo91528

Livrare 48-72 ore

128,01Lei

Spinnertail DUO Realis Spin 38, ACC3016 Blue Back Chart, 3.8cm, 11g

Spinnertail DUO Realis Spin 38, ACC3016 Blue Back Chart, 3.8cm, 11g

duo50204

Livrare 48-72 ore

69,02Lei

Vobler DUO Jerkbait 85 SP 8.5cm 8g GPA4009 River Bait

Vobler DUO Jerkbait 85 SP 8.5cm 8g GPA4009 River Bait

duo30770

Livrare imediată!

75,13Lei

Vobler DUO Realis Apex Vibe F85, DPA3298 Bottom Knock Tiger, 8.5cm, 25g

Vobler DUO Realis Apex Vibe F85, DPA3298 Bottom Knock Tiger, 8.5cm, 25g

duo38233

Livrare 48-72 ore

82,24Lei

Afişare 1101 - 1120 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: 79.367 ms [By time] [By id] [By file]

1 (0.159)

SELECT data
FROM `oc_session`
WHERE session_id = 'e65ff0506b8423d2e7f26c883d'

/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.095)

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

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

4 (0.091)

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

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

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

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

7 (0.139)

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