DUO

DUO

Sortare după:

Vobler DUO Realis Jerkbait 100 SP 10cm 14.5g DRA3050 Half Mirrow Ayu

Vobler DUO Realis Jerkbait 100 SP 10cm 14.5g DRA3050 Half Mirrow Ayu

duo56650

Livrare imediată!

74,21Lei

Vobler DUO Ryuki 50S Takumi 5cm 4g ADA4068 Yamame Red Belly S

Vobler DUO Ryuki 50S Takumi 5cm 4g ADA4068 Yamame Red Belly S

duo33184

Livrare imediată!

69,02Lei

Vobler DUO Realis Apex Vibe F85, DEA3341 AM Edge, 8.5cm, 25g

Vobler DUO Realis Apex Vibe F85, DEA3341 AM Edge, 8.5cm, 25g

duo38295

Livrare 48-72 ore

82,24Lei

Vobler Duo Realis Vibration 68 G-Fix, Shadow Halo, 6.8cm, 21g

Vobler Duo Realis Vibration 68 G-Fix, Shadow Halo, 6.8cm, 21g

duo64464

Livrare imediată!

74,21Lei

Vobler Duo Realis Vibration 62 Apex Tune, AM Edge, 6.2cm, 9.7g

Vobler Duo Realis Vibration 62 Apex Tune, AM Edge, 6.2cm, 9.7g

duo31692

Livrare imediată!

71,16Lei

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

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

duo90125

Livrare 48-72 ore

39,54Lei

Vobler DUO Realis Rozante 77SP, ADA3197 Violet Gill YB, 7.7cm, 8.4g

Vobler DUO Realis Rozante 77SP, ADA3197 Violet Gill YB, 7.7cm, 8.4g

duo01626

Livrare 48-72 ore

78,18Lei

Inele Despicate DUO Original Split Ring, Nr.5, 12buc/plic

Inele Despicate DUO Original Split Ring, Nr.5, 12buc/plic

duo77693

Livrare 48-72 ore

13,10Lei

Vobler DUO Spearhead Ryuki Quattro 90S, CMA4083 Blue Back RB II, 9cm 14g

Vobler DUO Spearhead Ryuki Quattro 90S, CMA4083 Blue Back RB II, 9cm 14g

duo58088

Livrare 48-72 ore

130,03Lei

Shad DUO Realis Versa Shad Fat, F092 Pink Chart, 17.8cm, 3buc/pac

Shad DUO Realis Versa Shad Fat, F092 Pink Chart, 17.8cm, 3buc/pac

duo88177

Livrare 48-72 ore

85,29Lei

Shad DUO Realis Versa Shad, F092 Pink Chart, 7.6cm, 10buc/pac

Shad DUO Realis Versa Shad, F092 Pink Chart, 7.6cm, 10buc/pac

duo80218

Livrare 48-72 ore

36,49Lei

Vobler DUO Realis Jerkbait 110SP, CCC3158 Ghost Gill, 11cm, 16.2g

Vobler DUO Realis Jerkbait 110SP, CCC3158 Ghost Gill, 11cm, 16.2g

duo66826

Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 85F, ACCZ402 Gunmetal M White Tiger, 8.5cm, 7.3g

Vobler DUO Realis Jerkbait 85F, ACCZ402 Gunmetal M White Tiger, 8.5cm, 7.3g

duo86241

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Rozante 77SP, CEA3375 ELT Chart, 7.7cm, 8.4g

Vobler DUO Realis Rozante 77SP, CEA3375 ELT Chart, 7.7cm, 8.4g

duo63181

Livrare 48-72 ore

78,18Lei

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

Afişare 821 - 840 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: 124.957 ms [By time] [By id] [By file]

1 (0.095)

SELECT data
FROM `oc_session`
WHERE session_id = '478a2db6d4294b064fc5880f80'

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

2 (0.122)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.137)

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

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

4 (0.118)

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

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

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

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

7 (0.152)

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