DUO

DUO

Sortare după:

Vobler DUO Realis Jerkbait 85SP, CPA0411 Fusilier, 8.5cm, 8g

Vobler DUO Realis Jerkbait 85SP, CPA0411 Fusilier, 8.5cm, 8g

duo74507

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Rozante 63SP, ADA3197 Violet Gill YB, 6.3cm, 5g

Vobler DUO Realis Rozante 63SP, ADA3197 Violet Gill YB, 6.3cm, 5g

duo01602

Livrare 48-72 ore

73,08Lei

Spinnertail DUO Realis Spin 38 SW, GHA0574 Holo Red Head GB, 3.8cm, 11g

Spinnertail DUO Realis Spin 38 SW, GHA0574 Holo Red Head GB, 3.8cm, 11g

duo51843

Livrare 48-72 ore

69,02Lei

Vobler DUO Realis Shinmushi, CCC3204 Aburazemi, 4.0cm, 5.7g

Vobler DUO Realis Shinmushi, CCC3204 Aburazemi, 4.0cm, 5.7g

duo64815

Livrare 48-72 ore

72,07Lei

Vobler DUO BayRuf Manic Fish 88, CPA0057 Inada Verde, 8.8cm, 11g

Vobler DUO BayRuf Manic Fish 88, CPA0057 Inada Verde, 8.8cm, 11g

duo67691

Livrare 48-72 ore

75,13Lei

Vobler DUO Jerkbait 85 SP 8.5cm 8g ADA3081 Prism Shad

Vobler DUO Jerkbait 85 SP 8.5cm 8g ADA3081 Prism Shad

duo26704

Livrare imediată!

75,13Lei

Vobler DUO Realis Apex Vibe F85, DEA3006 Ghost Minnow, 8.5cm, 25g

Vobler DUO Realis Apex Vibe F85, DEA3006 Ghost Minnow, 8.5cm, 25g

duo38288

Livrare 48-72 ore

82,24Lei

Vobler DUO Ryuki 60S 6cm 6.5g CCC3815 Brown Trout S

Vobler DUO Ryuki 60S 6cm 6.5g CCC3815 Brown Trout S

duo89931

Livrare 48-72 ore

69,02Lei

Vobler DUO BayRuf Manic Fish 75, CCC0873 Mat Black PB II, 7.5cm, 7.6g

Vobler DUO BayRuf Manic Fish 75, CCC0873 Mat Black PB II, 7.5cm, 7.6g

duo71735

Livrare 48-72 ore

69,02Lei

Shad DUO Bayruf BR Fish, F099 Rikyu, 8.4cm, 7buc/pac

Shad DUO Bayruf BR Fish, F099 Rikyu, 8.4cm, 7buc/pac

duo87279

Livrare 48-72 ore

42,59Lei

Vobler Duo Realis Vibration 62 G-Fix, Omnicraw RB, 6.2cm, 14.5g

Vobler Duo Realis Vibration 62 G-Fix, Omnicraw RB, 6.2cm, 14.5g

duo83035

Livrare imediată!

74,21Lei

Vobler Duo Realis Vibration 65 Nitro, Prism Gill, 5.5cm, 11.5g

Vobler Duo Realis Vibration 65 Nitro, Prism Gill, 5.5cm, 11.5g

duo19522

Livrare imediată!

71,16Lei

Shad DUO Realis Versa, F102 Brown Zircon, 10cm, 7buc/pac

Shad DUO Realis Versa, F102 Brown Zircon, 10cm, 7buc/pac

duo90262

Livrare 48-72 ore

39,54Lei

Shad DUO Realis Versa Shad Fat, F091 Baby Bass, 12.5cm, 5buc/pac

Shad DUO Realis Versa Shad Fat, F091 Baby Bass, 12.5cm, 5buc/pac

duo83387

Livrare 48-72 ore

52,76Lei

Shad DUO Realis Versa Pintail, FF104 Smokey Magic, 12.5cm, 5buc/pac

Shad DUO Realis Versa Pintail, FF104 Smokey Magic, 12.5cm, 5buc/pac

duo87880

Livrare 48-72 ore

48,69Lei

Vobler DUO Realis Jerkbait 110SP, CCCZ103 Goby ND, 11cm, 16.2g

Vobler DUO Realis Jerkbait 110SP, CCCZ103 Goby ND, 11cm, 16.2g

duo04047

Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 85F, ASAZ399 Gunmetal M Gold Tiger, 8.5cm, 7.3g

Vobler DUO Realis Jerkbait 85F, ASAZ399 Gunmetal M Gold Tiger, 8.5cm, 7.3g

duo86210

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Rozante 77SP, CTA0511 Rainbow Mirage, 7.7cm, 8.4g

Vobler DUO Realis Rozante 77SP, CTA0511 Rainbow Mirage, 7.7cm, 8.4g

duo77300

Livrare 48-72 ore

78,18Lei

Vobler DUO Realis Rozante 63SP, MCC4054 Metal Black Gold, 6.3cm, 5g

Vobler DUO Realis Rozante 63SP, MCC4054 Metal Black Gold, 6.3cm, 5g

duo91071

Livrare 48-72 ore

73,08Lei

Shad DUO Bayruf BR Fish, F101 Pepper Prizm, 8.4cm, 7buc/pac

Shad DUO Bayruf BR Fish, F101 Pepper Prizm, 8.4cm, 7buc/pac

duo87293

Livrare 48-72 ore

42,59Lei

Afişare 981 - 1000 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: 114.757 ms [By time] [By id] [By file]

1 (0.119)

SELECT data
FROM `oc_session`
WHERE session_id = '9b14cd423242b5136d85a18bdd'

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

2 (0.107)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.130)

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

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

4 (0.114)

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

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

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

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

7 (0.174)

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