DUO

DUO

Sortare după:

Vobler DUO Spearhead Ryuki 60S SW, AQA0111 White Glow, 6cm, 6.5g

Vobler DUO Spearhead Ryuki 60S SW, AQA0111 White Glow, 6cm, 6.5g

duo10840

Livrare 48-72 ore

69,02Lei

DUO Realis Spin 40 4cm 14g CSA3807 Tanago II

DUO Realis Spin 40 4cm 14g CSA3807 Tanago II

duo04474

Livrare 48-72 ore

69,02Lei

Vobler DUO Bay Ruf Tide Vib 70, CPA3512 Inakko Lime Chart, 7cm, 15.5g

Vobler DUO Bay Ruf Tide Vib 70, CPA3512 Inakko Lime Chart, 7cm, 15.5g

duo79892

Livrare 48-72 ore

82,24Lei

Vobler DUO Spearhead Ryuki 80S SW, CNA0841 Real Sand Lance, 8cm, 12g

Vobler DUO Spearhead Ryuki 80S SW, CNA0841 Real Sand Lance, 8cm, 12g

duo89075

Livrare 48-72 ore

76,15Lei

Vobler DUO Tetra Works Toto Fat 35F, CCC0073 Peachy GT, 3.5cm, 1.8g

Vobler DUO Tetra Works Toto Fat 35F, CCC0073 Peachy GT, 3.5cm, 1.8g

duo30206

Livrare 48-72 ore

69,02Lei

Vobler DUO Tetra Works Kurakura, AJA0305 Gold Red Head, 3cm, 2.5g

Vobler DUO Tetra Works Kurakura, AJA0305 Gold Red Head, 3cm, 2.5g

duo82017

Livrare 48-72 ore

72,07Lei

Lingurita Rotativa DUO Spearhead Ryuki Spinner, ANA4076 Pink Clown Yamame, 2cm, 5g

Lingurita Rotativa DUO Spearhead Ryuki Spinner, ANA4076 Pink Clown Yamame, 2cm, 5g

duo86173

Livrare 48-72 ore

41,58Lei

Vobler DUO Spearhead Ryuki 80S, ADA4090 UV RGG Yamame OB, 8cm, 12g

Vobler DUO Spearhead Ryuki 80S, ADA4090 UV RGG Yamame OB, 8cm, 12g

duo85299

Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 70S SW, ACC0001 Pearl Red Head, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S SW, ACC0001 Pearl Red Head, 7cm, 9g

duo30541

Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 70S, CCC0676 Mat Mullet Pink Back, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, CCC0676 Mat Mullet Pink Back, 7cm, 9g

duo86845

Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 50S, ANA4032 Itou RB, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, ANA4032 Itou RB, 5cm, 4.5g

duo97820

Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 60S, ADA3058 Prism Gill, 6cm, 6.5g

Vobler DUO Spearhead Ryuki 60S, ADA3058 Prism Gill, 6cm, 6.5g

duo56780

Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 51S, ADA4059 Green Gold OB, 5.1cm, 5.5g

Vobler DUO Spearhead Ryuki 51S, ADA4059 Green Gold OB, 5.1cm, 5.5g

duo61439

Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 46S, ACC3059 Mat Tiger, 4.6cm, 5g

Vobler DUO Spearhead Ryuki 46S, ACC3059 Mat Tiger, 4.6cm, 5g

duo72428

Livrare 48-72 ore

77,16Lei

Vobler Duo Spearhead Ryuki 45S, ANA4032 Itou RB, 4.5cm, 4g

Vobler Duo Spearhead Ryuki 45S, ANA4032 Itou RB, 4.5cm, 4g

duo97783

Livrare 48-72 ore

69,02Lei

Vobler DUO Rough Trail Blazin 70, CSI0616 UV Pink Silver Flash, 7cm, 20g

Vobler DUO Rough Trail Blazin 70, CSI0616 UV Pink Silver Flash, 7cm, 20g

duo62696

Livrare 48-72 ore

91,39Lei

Vobler DUO Spreadhead Ryuki 70MDF, CSN4011 Stream Shad, 7cm, 5.4g

Vobler DUO Spreadhead Ryuki 70MDF, CSN4011 Stream Shad, 7cm, 5.4g

duo93492

Livrare 48-72 ore

76,15Lei

Vobler DUO Tide Minnow 75S Sprint, DHN0402 Belone, 7.5cm, 11g

Vobler DUO Tide Minnow 75S Sprint, DHN0402 Belone, 7.5cm, 11g

duo24588

Livrare 48-72 ore

85,29Lei

Vobler DUO Spearhead Ryuki 70F, MCC4036 Rainbow Trout, 7cm, 5.3g

Vobler DUO Spearhead Ryuki 70F, MCC4036 Rainbow Trout, 7cm, 5.3g

duo63597

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Spinbait 62 Alpha, CCC3176 Morning Dawn, 6.2cm, 10.9g

Vobler DUO Realis Spinbait 62 Alpha, CCC3176 Morning Dawn, 6.2cm, 10.9g

duo44135

Livrare 48-72 ore

70,03Lei

Afişare 401 - 420 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: 82.166 ms [By time] [By id] [By file]

1 (0.144)

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

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

2 (0.075)

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

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

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

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

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

7 (0.216)

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