DUO

DUO

Sortare după:

Vobler DUO Spearhead Ryuki 50MDF, CSN4011 Stream Shad, 5cm, 3.2g

Vobler DUO Spearhead Ryuki 50MDF, CSN4011 Stream Shad, 5cm, 3.2g

duo94987

Livrare 48-72 ore

69,02Lei

Vobler DUO Realis Fangbait 80DR, ACC0028 Mat Chart, 8cm, 11.5g

Vobler DUO Realis Fangbait 80DR, ACC0028 Mat Chart, 8cm, 11.5g

duo72336

Livrare 48-72 ore

102,58Lei

Cicada DUO Metal Garage Plate Jig, PHA0087 Mazume Sardine, 7cm, 30g

Cicada DUO Metal Garage Plate Jig, PHA0087 Mazume Sardine, 7cm, 30g

duo35522

Livrare 48-72 ore

62,92Lei

Vobler DUO Realis Rozante 63MR, ACC3008 Neo Pearl, 6.3cm, 6.8g

Vobler DUO Realis Rozante 63MR, ACC3008 Neo Pearl, 6.3cm, 6.8g

duo51676

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Jerkbait 100DR SP, ACC3008 Neo Pearl, 10cm, 15.6g

Vobler DUO Realis Jerkbait 100DR SP, ACC3008 Neo Pearl, 10cm, 15.6g

duo65157

Livrare 48-72 ore

75,13Lei

Ancore DUO Bay Ruf Manic MN-TR, Nr.6, 18buc/pac

Ancore DUO Bay Ruf Manic MN-TR, Nr.6, 18buc/pac

duo99886

Livrare 48-72 ore

61,92Lei

Vobler DUO Spearhead Ryuki 70S, ADA0088 Prism Ivory, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, ADA0088 Prism Ivory, 7cm, 9g

duo21549

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Crank 48MR Kabuki Floating, Hazzard Chart II, 4.8cm, 10.5g

Vobler DUO Realis Crank 48MR Kabuki Floating, Hazzard Chart II, 4.8cm, 10.5g

duo50310

Livrare imediată!

71,16Lei

Vobler Duo Realis Crank Mid Roller Floating 40F, GA Tiger, 4cm, 5.3g

Vobler Duo Realis Crank Mid Roller Floating 40F, GA Tiger, 4cm, 5.3g

duo37151

Livrare imediată!

71,16Lei

Vobler DUO Spearhead Ryuki 80S SW, DHN0402 Belone, 8cm, 12g

Vobler DUO Spearhead Ryuki 80S SW, DHN0402 Belone, 8cm, 12g

duo15876

Livrare 48-72 ore

76,15Lei

Vobler DUO Tetra Works Toto 48HS Heavy Sinking, CGI0578 Full Moon Black RB, 4.8cm, 4.3g

Vobler DUO Tetra Works Toto 48HS Heavy Sinking, CGI0578 Full Moon Black RB, 4.8cm, 4.3g

duo54134

Livrare 48-72 ore

69,02Lei

Vobler DUO Tetra Works Kurakura S, GHI0085 Red Worm, 3cm, 2.9g

Vobler DUO Tetra Works Kurakura S, GHI0085 Red Worm, 3cm, 2.9g

duo39773

Livrare 48-72 ore

72,07Lei

Lingurita Rotativa DUO Spearhead Ryuki Spinner, PNA4010 Ayu, 2cm, 3.5g

Lingurita Rotativa DUO Spearhead Ryuki Spinner, PNA4010 Ayu, 2cm, 3.5g

duo57265

Livrare 48-72 ore

41,58Lei

Vobler DUO Spearhead Ryuki 80S, MCC4026 Metal Red Gold, 8cm, 12g

Vobler DUO Spearhead Ryuki 80S, MCC4026 Metal Red Gold, 8cm, 12g

duo62002

Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 70S SW, DHN0402 Belone, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S SW, DHN0402 Belone, 7cm, 9g

duo15760

Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 50S, ACC3059 Mat Tiger, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, ACC3059 Mat Tiger, 5cm, 4.5g

duo71653

Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 50S, ASI4044 Full Chart Yamame, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, ASI4044 Full Chart Yamame, 5cm, 4.5g

duo68882

Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 60S, GEA3006 Ghost Minnow, 6cm, 6.5g

Vobler DUO Spearhead Ryuki 60S, GEA3006 Ghost Minnow, 6cm, 6.5g

duo62156

Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 50SP, AHA4006 Ayu OB, 5cm, 3.3g

Vobler DUO Spearhead Ryuki 50SP, AHA4006 Ayu OB, 5cm, 3.3g

duo18020

Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 46S, ASI4044 Full Chart Yamame, 4.6cm, 5g

Vobler DUO Spearhead Ryuki 46S, ASI4044 Full Chart Yamame, 4.6cm, 5g

duo61323

Livrare 48-72 ore

77,16Lei

Afişare 381 - 400 din 1280 (64 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: 80.249 ms [By time] [By id] [By file]

1 (0.090)

SELECT data
FROM `oc_session`
WHERE session_id = '7225e9501d7cdfdc2ab7f61bec'

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

2 (0.080)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.091)

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

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

4 (0.095)

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

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

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

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

7 (0.148)

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