DUO

DUO

Sortare după:

Shad DUO Realis Versa, F086 Purple Back Shad, 10cm, 7buc/pac

Shad DUO Realis Versa, F086 Purple Back Shad, 10cm, 7buc/pac

duo90194

Livrare 48-72 ore

39,54Lei

Shad DUO Realis Versa Shad Fat, F077 Bluegill Flash, 12.5cm, 5buc/pac

Shad DUO Realis Versa Shad Fat, F077 Bluegill Flash, 12.5cm, 5buc/pac

duo87781

Livrare 48-72 ore

52,76Lei

Shad DUO Realis Versa Pintail, F090 Psychedelic Chart, 12.5cm, 5buc/pac

Shad DUO Realis Versa Pintail, F090 Psychedelic Chart, 12.5cm, 5buc/pac

duo83455

Livrare 48-72 ore

48,69Lei

Vobler DUO Realis Jerkbait 100SP, AJA3055 Chart Gill Halo, 10cm, 14.5g

Vobler DUO Realis Jerkbait 100SP, AJA3055 Chart Gill Halo, 10cm, 14.5g

duo82956

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Jerkbait 110SP, GEA3006 Ghost Minnow, 11cm, 16.2g

Vobler DUO Realis Jerkbait 110SP, GEA3006 Ghost Minnow, 11cm, 16.2g

duo66741

Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 85SP, ACC3194 Red Tiger II, 8.5cm, 8g

Vobler DUO Realis Jerkbait 85SP, ACC3194 Red Tiger II, 8.5cm, 8g

duo28739

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Rozante 63SP, ACC3008 Neo Pearl, 6.3cm, 5g

Vobler DUO Realis Rozante 63SP, ACC3008 Neo Pearl, 6.3cm, 5g

duo61425

Livrare 48-72 ore

73,08Lei

Shad DUO Bayruf BR Fish, S035 UV Silver, 8.4cm, 7buc/pac

Shad DUO Bayruf BR Fish, S035 UV Silver, 8.4cm, 7buc/pac

duo68803

Livrare 48-72 ore

42,59Lei

Vobler DUO Realis Shinmushi, CCC3405 Firefly, 4.0cm, 5.7g

Vobler DUO Realis Shinmushi, CCC3405 Firefly, 4.0cm, 5.7g

duo75016

Livrare 48-72 ore

72,07Lei

Vobler DUO BayRuf Manic Fish 77, CCC0092 LG Mazume Sardine, 7.7cm, 9g

Vobler DUO BayRuf Manic Fish 77, CCC0092 LG Mazume Sardine, 7.7cm, 9g

duo67929

Livrare 48-72 ore

75,13Lei

Vobler DUO Jerkbait 100 F 10cm 13.7g GPA3244

Vobler DUO Jerkbait 100 F 10cm 13.7g GPA3244

4525918111519

Livrare imediată!

72,00Lei(-16%) 60,48Lei

Vobler DUO Realis Apex Vibe F85, ASA3825 Tule Perch ND, 8.5cm, 25g

Vobler DUO Realis Apex Vibe F85, ASA3825 Tule Perch ND, 8.5cm, 25g

duo57784

Livrare 48-72 ore

82,24Lei

Vobler DUO Ryuki 45S 4.5cm 4g MNI4047 Tennessee Shad S

Vobler DUO Ryuki 45S 4.5cm 4g MNI4047 Tennessee Shad S

duo30773

Livrare imediată!

68,11Lei

Vobler DUO Realis Jerkbait 120 SP 12cm 18g DTA3345 AM Hasu

Vobler DUO Realis Jerkbait 120 SP 12cm 18g DTA3345 AM Hasu

duo36918

Livrare 48-72 ore

86,31Lei

Vobler Duo Realis Vibration 68 G-Fix, Red Tiger, 6.8cm, 21g

Vobler Duo Realis Vibration 68 G-Fix, Red Tiger, 6.8cm, 21g

duo58210

Livrare imediată!

74,21Lei

Vobler Duo Realis Vibration 65 Apex Tune, Ghost Gill, 6.5cm, 17.5g

Vobler Duo Realis Vibration 65 Apex Tune, Ghost Gill, 6.5cm, 17.5g

duo53465

Livrare imediată!

71,16Lei

Shad DUO Realis Versa, F077 Bluegill Flash, 10cm, 7buc/pac

Shad DUO Realis Versa, F077 Bluegill Flash, 10cm, 7buc/pac

duo90101

Livrare 48-72 ore

39,54Lei

Shad DUO Realis Versa Pintail, F086 Purple Back Shad, 10cm, 7buc/pac

Shad DUO Realis Versa Pintail, F086 Purple Back Shad, 10cm, 7buc/pac

duo90385

Livrare 48-72 ore

39,54Lei

Inele Despicate DUO Original Split Ring, Nr.3, 24buc/plic

Inele Despicate DUO Original Split Ring, Nr.3, 24buc/plic

duo77679

Livrare imediată!

13,10Lei

Vobler DUO Spearhead Ryuki Quattro 90S, CDA4019 Pink Yamame, 9cm 14g

Vobler DUO Spearhead Ryuki Quattro 90S, CDA4019 Pink Yamame, 9cm 14g

duo58064

Livrare 48-72 ore

130,03Lei

Afişare 1121 - 1140 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: 81.414 ms [By time] [By id] [By file]

1 (0.132)

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

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

2 (0.086)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.121)

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

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

4 (0.142)

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

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

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

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

7 (0.113)

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