DUO

DUO

Sortare după:

Shad DUO Realis Versa Shad, F081 Copper Red Gold, 7.6cm, 10buc/pac

Shad DUO Realis Versa Shad, F081 Copper Red Gold, 7.6cm, 10buc/pac

duo78413

Livrare 48-72 ore

36,49Lei

Shad DUO Realis Versa Pintail, F084 Lime Chartreuse UV, 7.6cm, 10buc/pac

Shad DUO Realis Versa Pintail, F084 Lime Chartreuse UV, 7.6cm, 10buc/pac

duo78567

Livrare 48-72 ore

36,49Lei

Vobler DUO Realis Jerkbait 110SP, ACC3338 Dragon Fruit Tiger, 11cm, 16.2g

Vobler DUO Realis Jerkbait 110SP, ACC3338 Dragon Fruit Tiger, 11cm, 16.2g

duo28227

Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 120SP, CCC3816 Wakasagi ND, 12cm, 17.7g

Vobler DUO Realis Jerkbait 120SP, CCC3816 Wakasagi ND, 12cm, 17.7g

duo82796

Livrare 48-72 ore

86,31Lei

Vobler DUO Realis Rozante 77SP, ADA3058 Prism Gill, 7.7cm, 8.4g

Vobler DUO Realis Rozante 77SP, ADA3058 Prism Gill, 7.7cm, 8.4g

duo88040

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

Vobler DUO Ryuki 60S, GAA4005 Sapphire Lux S, 6cm, 6.5g

Vobler DUO Ryuki 60S, GAA4005 Sapphire Lux S, 6cm, 6.5g

duo28470

Livrare 48-72 ore

69,02Lei

Shad DUO Bayruf BR Fish, S040 Orange Gold, 8.4cm, 7buc/pac

Shad DUO Bayruf BR Fish, S040 Orange Gold, 8.4cm, 7buc/pac

duo68834

Livrare 48-72 ore

42,59Lei

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

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

duo58135

Livrare imediată!

74,21Lei

Vobler Duo Realis Vibration 65 Nitro, Burning Tiger, 5.5cm, 11.5g

Vobler Duo Realis Vibration 65 Nitro, Burning Tiger, 5.5cm, 11.5g

duo19546

Livrare imediată!

71,16Lei

Shad DUO Realis Versa Pintail, F089 Sky Blue Chart, 10cm, 7buc/pac

Shad DUO Realis Versa Pintail, F089 Sky Blue Chart, 10cm, 7buc/pac

duo90415

Livrare 48-72 ore

39,54Lei

Shad DUO Realis Versa Shad Fat, F099 Rikyu, 12.5cm, 5buc/pac

Shad DUO Realis Versa Shad Fat, F099 Rikyu, 12.5cm, 5buc/pac

duo87804

Livrare 48-72 ore

52,76Lei

Shad DUO Realis Versa Pintail, F075 Chartreuse Shad, 7.6cm, 10buc/pac

Shad DUO Realis Versa Pintail, F075 Chartreuse Shad, 7.6cm, 10buc/pac

duo78475

Livrare 48-72 ore

36,49Lei

Vobler DUO Realis Jerkbait 100SP, CCC3314 LG Young Ayu, 10cm, 14.5g

Vobler DUO Realis Jerkbait 100SP, CCC3314 LG Young Ayu, 10cm, 14.5g

duo31500

Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 120SP, ADA3077 All Bait, 12cm, 17.7g

Vobler DUO Realis Jerkbait 120SP, ADA3077 All Bait, 12cm, 17.7g

duo51495

Livrare 48-72 ore

86,31Lei

Afişare 901 - 920 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: 84.879 ms [By time] [By id] [By file]

1 (0.136)

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

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

2 (0.076)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.088)

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

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

4 (0.087)

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.382)

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

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

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

7 (0.175)

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