DUO

DUO

Sortare după:

Vobler DUO Realis Shinmushi, CCC3219 Beetle, 4.0cm, 5.7g

Vobler DUO Realis Shinmushi, CCC3219 Beetle, 4.0cm, 5.7g

duo86947

Livrare 48-72 ore

72,07Lei

Vobler DUO Ryuki 38S 3.8cm 2.8g MCC4036 Rainbow Trout S

Vobler DUO Ryuki 38S 3.8cm 2.8g MCC4036 Rainbow Trout S

duo16996

Livrare imediată!

68,11Lei

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

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

duo44999

Livrare imediată!

74,21Lei

Vobler Duo Realis Vibration 68 Apex Tune, Chart Gill Halo, 6.8cm, 14.3g

Vobler Duo Realis Vibration 68 Apex Tune, Chart Gill Halo, 6.8cm, 14.3g

duo71674

Livrare imediată!

71,16Lei

Chatter Shad DUO Bay Ruf, PCC0670 LG Emerald, 18g

Chatter Shad DUO Bay Ruf, PCC0670 LG Emerald, 18g

duo84711

Livrare 48-72 ore

78,18Lei

Shad DUO Realis Versa Pintail, F083 Watermelon Orange Gold, 10cm, 7buc/pac

Shad DUO Realis Versa Pintail, F083 Watermelon Orange Gold, 10cm, 7buc/pac

duo90354

Livrare 48-72 ore

39,54Lei

Inele Despicate DUO Original Split Ring, Nr.1.5, 30buc/plic

Inele Despicate DUO Original Split Ring, Nr.1.5, 30buc/plic

duo16644

Livrare 48-72 ore

13,10Lei

Vobler DUO Spearhead Ryuki Quattro 70S, MCC0522 UV Silver Slash B, 7cm 5.7g

Vobler DUO Spearhead Ryuki Quattro 70S, MCC0522 UV Silver Slash B, 7cm 5.7g

duo73616

Livrare 48-72 ore

110,72Lei

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

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

duo78369

Livrare 48-72 ore

36,49Lei

Shad DUO Realis Versa Pintail, F079 Dark Motor Oil UV, 7.6cm, 10buc/pac

Shad DUO Realis Versa Pintail, F079 Dark Motor Oil UV, 7.6cm, 10buc/pac

duo78512

Livrare 48-72 ore

36,49Lei

Vobler DUO Realis Jerkbait 100SP, CNAZ106 Bora Konoshiro, 10cm, 14.5g

Vobler DUO Realis Jerkbait 100SP, CNAZ106 Bora Konoshiro, 10cm, 14.5g

duo77171

Livrare 48-72 ore

75,13Lei

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

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

duo64072

Livrare 48-72 ore

86,31Lei

Vobler DUO Realis Jerkbait 85SP, CCC3864 Perch ND, 8.5cm, 8g

Vobler DUO Realis Jerkbait 85SP, CCC3864 Perch ND, 8.5cm, 8g

duo28746

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Rozante 63SP, CCC3028 Ghost Chart, 6.3cm, 5g

Vobler DUO Realis Rozante 63SP, CCC3028 Ghost Chart, 6.3cm, 5g

duo70687

Livrare 48-72 ore

73,08Lei

Vobler DUO BayRuf Manic Fish 77, CPB0054 Genkai Sardine, 7.7cm, 9g

Vobler DUO BayRuf Manic Fish 77, CPB0054 Genkai Sardine, 7.7cm, 9g

duo67905

Livrare 48-72 ore

75,13Lei

Spinnertail DUO Realis Spin 35 SW, ACC0001 Pearl Red Head, 3.5cm, 7g

Spinnertail DUO Realis Spin 35 SW, ACC0001 Pearl Red Head, 3.5cm, 7g

duo79830

Livrare 48-72 ore

69,02Lei

Vobler DUO Realis Jerkbait 110 SP 11cm 16.2g CCC3816 Wakasagi ND

Vobler DUO Realis Jerkbait 110 SP 11cm 16.2g CCC3816 Wakasagi ND

duo86480

Livrare imediată!

77,00Lei(-12%) 68,01Lei

Vobler DUO Realis Apex Crank 66 Squared, ACC3083 American Shad, 6.6cm, 17.7g

Vobler DUO Realis Apex Crank 66 Squared, ACC3083 American Shad, 6.6cm, 17.7g

duo43497

Livrare 48-72 ore

82,24Lei

Vobler DUO Ryuki 38S 3.8cm 2.8g CCC3815 Brown Trout S

Vobler DUO Ryuki 38S 3.8cm 2.8g CCC3815 Brown Trout S

duo17061

Livrare 48-72 ore

69,02Lei

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

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

duo74262

Livrare imediată!

74,21Lei

Afişare 1161 - 1180 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: 102.865 ms [By time] [By id] [By file]

1 (0.156)

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

/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.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 (33.837)

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

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

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

7 (0.222)

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