DUO

DUO

Sortare după:

Vobler DUO Ryuki 38S 3.8cm 2.8g ADA4019 Pink Yamame S

Vobler DUO Ryuki 38S 3.8cm 2.8g ADA4019 Pink Yamame S

duo16774

Livrare imediată!

69,02Lei

Vobler DUO Realis Jerkbait 100 SP 10cm 14.5g CCC3350 AM Dawn

Vobler DUO Realis Jerkbait 100 SP 10cm 14.5g CCC3350 AM Dawn

duo30404

Livrare 48-72 ore

75,13Lei

Vobler DUO Ryuki 70S, GAA4005 Sapphire Lux S, 7cm, 9g

Vobler DUO Ryuki 70S, GAA4005 Sapphire Lux S, 7cm, 9g

duo28548

Livrare 48-72 ore

75,13Lei

Vobler Duo Realis Vibration 68 Apex Tune, Omnicraw RB, 6.8cm, 14.3g

Vobler Duo Realis Vibration 68 Apex Tune, Omnicraw RB, 6.8cm, 14.3g

duo31685

Livrare imediată!

71,16Lei

Chatter Shad DUO Bay Ruf, PCC0654 Bay White Silver Flake, 18g

Chatter Shad DUO Bay Ruf, PCC0654 Bay White Silver Flake, 18g

duo84681

Livrare 48-72 ore

78,18Lei

Shad DUO Realis Versa Pintail, F090 Psychedelic Chart, 10cm, 7buc/pac

Shad DUO Realis Versa Pintail, F090 Psychedelic Chart, 10cm, 7buc/pac

duo90422

Livrare 48-72 ore

39,54Lei

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

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

duo87811

Livrare 48-72 ore

52,76Lei

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

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

duo78482

Livrare 48-72 ore

36,49Lei

Vobler DUO Realis Jerkbait 100SP, CCC3816 Wakasagi ND, 10cm, 14.5g

Vobler DUO Realis Jerkbait 100SP, CCC3816 Wakasagi ND, 10cm, 14.5g

duo73524

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Jerkbait 120SP, AQA0111 White Glow, 12cm, 17.7g

Vobler DUO Realis Jerkbait 120SP, AQA0111 White Glow, 12cm, 17.7g

duo69411

Livrare 48-72 ore

86,31Lei

Vobler DUO Realis Jerkbait 85SP, CCC3314 LG Young Ayu, 8.5cm, 8g

Vobler DUO Realis Jerkbait 85SP, CCC3314 LG Young Ayu, 8.5cm, 8g

duo26223

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Rozante 63SP, ADA4071 Hokkaido, 6.3cm, 5g

Vobler DUO Realis Rozante 63SP, ADA4071 Hokkaido, 6.3cm, 5g

duo74255

Livrare 48-72 ore

73,08Lei

Vobler DUO BayRuf Manic Fish 88, CUA0762 UV Sight Shirasu GB, 8.8cm, 11g

Vobler DUO BayRuf Manic Fish 88, CUA0762 UV Sight Shirasu GB, 8.8cm, 11g

duo92471

Livrare 48-72 ore

75,13Lei

Spinnertail DUO Realis Spin 38, ACCC3313 Frisky Oikawa, 3.8cm, 11g

Spinnertail DUO Realis Spin 38, ACCC3313 Frisky Oikawa, 3.8cm, 11g

duo50198

Livrare 48-72 ore

69,02Lei

Vobler DUO Realis Apex Crank 66 Squared, CCC3364 Ghost Mat Tiger, 6.6cm, 17.7g

Vobler DUO Realis Apex Crank 66 Squared, CCC3364 Ghost Mat Tiger, 6.6cm, 17.7g

duo43534

Livrare imediată!

82,24Lei

Vobler DUO Realis Apex Vibe F85, DPA3331 Iris Flare, 8.5cm, 25g

Vobler DUO Realis Apex Vibe F85, DPA3331 Iris Flare, 8.5cm, 25g

duo38257

Livrare 48-72 ore

82,24Lei

Vobler DUO Ryuki 60S SW 6cm 6.5g GJA0101 Zebra Glow S

Vobler DUO Ryuki 60S SW 6cm 6.5g GJA0101 Zebra Glow S

duo10857

Livrare 48-72 ore

69,02Lei

Shad DUO Bayruf BR Fish, S042 UV Clear Pink, 8.4cm, 7buc/pac

Shad DUO Bayruf BR Fish, S042 UV Clear Pink, 8.4cm, 7buc/pac

duo68858

Livrare 48-72 ore

42,59Lei

Vobler Duo Realis Vibration 62 G-Fix, Tule Perch ND, 6.2cm, 14.5g

Vobler Duo Realis Vibration 62 G-Fix, Tule Perch ND, 6.2cm, 14.5g

duo85148

Livrare imediată!

74,21Lei

Shad DUO Realis Versa Shad Fat, F076 White Back Shad, 12.5cm, 5buc/pac

Shad DUO Realis Versa Shad Fat, F076 White Back Shad, 12.5cm, 5buc/pac

duo83332

Livrare 48-72 ore

52,76Lei

Afişare 1181 - 1200 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: 86.899 ms [By time] [By id] [By file]

1 (0.084)

SELECT data
FROM `oc_session`
WHERE session_id = '6f544427a6adeff0b187a325e4'

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

2 (0.084)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.100)

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

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

4 (0.094)

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

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

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

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

7 (0.129)

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