DUO

DUO

Sortare după:

Vobler DUO Realis Rozante 77SP, CEA0317 Clear Chart Halo, 7.7cm, 8.4g

Vobler DUO Realis Rozante 77SP, CEA0317 Clear Chart Halo, 7.7cm, 8.4g

duo77317

Livrare 48-72 ore

78,18Lei

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

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

duo60404

Livrare 48-72 ore

73,08Lei

Shad DUO Bayruf BR Fish, F097 Young Water Melon, 8.4cm, 7buc/pac

Shad DUO Bayruf BR Fish, F097 Young Water Melon, 8.4cm, 7buc/pac

duo87255

Livrare 48-72 ore

42,59Lei

Spinnertail DUO Realis Spin 30, ACC3225 Mat Tiger ll, 3cm, 5g

Spinnertail DUO Realis Spin 30, ACC3225 Mat Tiger ll, 3cm, 5g

duo93174

Livrare 48-72 ore

69,02Lei

VOBLER DUO RYUKI 45S 4.5CM 4G ANI4004 NATURAL YAMAME S

VOBLER DUO RYUKI 45S 4.5CM 4G ANI4004 NATURAL YAMAME S

duo30797

Livrare imediată!

68,11Lei

Vobler DUO Realis Vibration 55 Nitro 5.5cm 11.5g ACC3059 Mat Tiger S

Vobler DUO Realis Vibration 55 Nitro 5.5cm 11.5g ACC3059 Mat Tiger S

4525918119584

Livrare imediată!

68,99Lei(-16%) 58,04Lei

Vobler DUO Realis Apex Crank 66 Squared, CCC3272 AM Magic, 6.6cm, 17.7g

Vobler DUO Realis Apex Crank 66 Squared, CCC3272 AM Magic, 6.6cm, 17.7g

duo43466

Livrare 48-72 ore

82,24Lei

Vobler DUO Realis Jerkbait 120 SP 12cm 18g ACC3338 Dragon Fruit Tiger

Vobler DUO Realis Jerkbait 120 SP 12cm 18g ACC3338 Dragon Fruit Tiger

duo28234

Livrare 48-72 ore

86,31Lei

Vobler DUO Ryuki 45S SW, ADA4125 Red Belly S, 4.5cm, 4g

Vobler DUO Ryuki 45S SW, ADA4125 Red Belly S, 4.5cm, 4g

duo52607

Livrare 48-72 ore

69,02Lei

Vobler Duo Realis Vibration 68 Apex Tune, Ghost Red Tiger, 6.8cm, 14.3g

Vobler Duo Realis Vibration 68 Apex Tune, Ghost Red Tiger, 6.8cm, 14.3g

duo31647

Livrare imediată!

71,16Lei

Chatter Shad DUO Bay Ruf, PCC0649 LG Lime Gold, 18g

Chatter Shad DUO Bay Ruf, PCC0649 LG Lime Gold, 18g

duo84667

Livrare 48-72 ore

78,18Lei

Shad DUO Realis Versa Pintail, F078 Gold Flash Shad, 10cm, 7buc/pac

Shad DUO Realis Versa Pintail, F078 Gold Flash Shad, 10cm, 7buc/pac

duo90309

Livrare 48-72 ore

39,54Lei

Shad DUO Realis Versa Shad, F080 Natural Wakasagi, 7.6cm, 10buc/pac

Shad DUO Realis Versa Shad, F080 Natural Wakasagi, 7.6cm, 10buc/pac

duo78406

Livrare 48-72 ore

36,49Lei

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

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

duo78550

Livrare 48-72 ore

36,49Lei

Vobler DUO Realis Jerkbait 110SP, ACC3008 Neo Pearl, 11cm, 16.2g

Vobler DUO Realis Jerkbait 110SP, ACC3008 Neo Pearl, 11cm, 16.2g

duo66796

Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 120SP, CCC3243 BK Ayu, 12cm, 17.7g

Vobler DUO Realis Jerkbait 120SP, CCC3243 BK Ayu, 12cm, 17.7g

duo52611

Livrare 48-72 ore

86,31Lei

Vobler DUO Realis Rozante 77SP, ADA3033 Prism Clown, 7.7cm, 8.4g

Vobler DUO Realis Rozante 77SP, ADA3033 Prism Clown, 7.7cm, 8.4g

duo88033

Livrare 48-72 ore

78,18Lei

Vobler DUO Realis Rozante 63SP, CCC3516 Ghost Mat Lime Chart, 6.3cm, 5g

Vobler DUO Realis Rozante 63SP, CCC3516 Ghost Mat Lime Chart, 6.3cm, 5g

duo75177

Livrare 48-72 ore

73,08Lei

Vobler DUO BayRuf Manic Fish 77, MCC0522 UV Silver Slash B, 7.7cm, 9g

Vobler DUO BayRuf Manic Fish 77, MCC0522 UV Silver Slash B, 7.7cm, 9g

duo92440

Livrare 48-72 ore

75,13Lei

Spinnertail DUO Realis Spin 35, ACC3297 Hell Craw, 3.5cm, 7g

Spinnertail DUO Realis Spin 35, ACC3297 Hell Craw, 3.5cm, 7g

duo70974

Livrare 48-72 ore

69,02Lei

Afişare 1041 - 1060 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: 82.797 ms [By time] [By id] [By file]

1 (0.184)

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

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

2 (0.120)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.145)

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

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

4 (0.130)

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

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

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

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

7 (0.158)

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