DUO

DUO

Sortare după:

Vobler DUO Bay Ruf Tide Vib 70, AHA0087 Mazume Sardine, 7cm, 15.5g

Vobler DUO Bay Ruf Tide Vib 70, AHA0087 Mazume Sardine, 7cm, 15.5g

duo79922

Livrare 48-72 ore

82,24Lei

Vobler DUO Bayruf Bulk 95F, CPA3512 Inakko Lime Chart, 9.5cm, 14g

Vobler DUO Bayruf Bulk 95F, CPA3512 Inakko Lime Chart, 9.5cm, 14g

duo98497

Livrare 48-72 ore

109,70Lei

Spinnertail DUO Realis Spin 40 4cm 14g CRA3050 Lively Ayu

Spinnertail DUO Realis Spin 40 4cm 14g CRA3050 Lively Ayu

duo04269

Livrare 48-72 ore

69,02Lei

Vobler DUO Bay Ruf Tide Vib 70, CPA0738 Kuwase Kibinago, 7cm, 15.5g

Vobler DUO Bay Ruf Tide Vib 70, CPA0738 Kuwase Kibinago, 7cm, 15.5g

duo89129

Livrare 48-72 ore

82,24Lei

Vobler DUO Spearhead Ryuki 80S SW, AKA0002 Rainbow, 8cm, 12g

Vobler DUO Spearhead Ryuki 80S SW, AKA0002 Rainbow, 8cm, 12g

duo77792

Livrare 48-72 ore

76,15Lei

Vobler DUO Tetra Works Totoshad, CCC0475 Sardine Spirit, 4.8cm, 4.5g

Vobler DUO Tetra Works Totoshad, CCC0475 Sardine Spirit, 4.8cm, 4.5g

duo25578

Livrare 48-72 ore

69,02Lei

Vobler DUO Tetra Works Pocopoco F, DHH0317 Clear Pink GB, 4cm, 3g

Vobler DUO Tetra Works Pocopoco F, DHH0317 Clear Pink GB, 4cm, 3g

duo36980

Livrare 48-72 ore

69,02Lei

Lingurita Rotativa DUO Spearhead Ryuki Spinner, ACC4044 Full Chart Yamame, 2cm, 5g

Lingurita Rotativa DUO Spearhead Ryuki Spinner, ACC4044 Full Chart Yamame, 2cm, 5g

duo57449

Livrare 48-72 ore

41,58Lei

Vobler DUO Spearhead Ryuki 80S, ADA4071 Hokkaido, 8cm, 12g

Vobler DUO Spearhead Ryuki 80S, ADA4071 Hokkaido, 8cm, 12g

duo86794

Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 71S, MCC4026 Metal Red Gold, 7.1cm, 10g

Vobler DUO Spearhead Ryuki 71S, MCC4026 Metal Red Gold, 7.1cm, 10g

duo73753

Livrare 48-72 ore

90,37Lei

Vobler DUO Spearhead Ryuki 50S, ADA4093 UV Pink Chart Yamame OB, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, ADA4093 UV Pink Chart Yamame OB, 5cm, 4.5g

duo85398

Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 50S, DRA4051 Chart Head Yamame, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, DRA4051 Chart Head Yamame, 5cm, 4.5g

duo68929

Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 80S SW, AOA0220 Astro Red Head, 8cm, 12g

Vobler Duo Spearhead Ryuki 80S SW, AOA0220 Astro Red Head, 8cm, 12g

duo06560

Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 50S SW, ADA0088 Prism Ivory, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S SW, ADA0088 Prism Ivory, 5cm, 4.5g

duo14367

Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 45S, ADA4013 Wakasagi, 4.5cm, 4g

Vobler Duo Spearhead Ryuki 45S, ADA4013 Wakasagi, 4.5cm, 4g

duo30803

Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 38S, ANI4010 Pearl Ayu, 3.8cm, 2.8g

Vobler Duo Spearhead Ryuki 38S, ANI4010 Pearl Ayu, 3.8cm, 2.8g

duo16989

Livrare 48-72 ore

69,02Lei

Vobler DUO Spreadhead Ryuki 80SP, ADA4068 Yamame Red Belly, 8cm, 5.6g

Vobler DUO Spreadhead Ryuki 80SP, ADA4068 Yamame Red Belly, 8cm, 5.6g

duo95410

Livrare 48-72 ore

76,15Lei

Carlig Offset Lestat DUO Realis Spin Hook, Mat Black, 1.8g, Nr.1/0, 3buc/pac

Carlig Offset Lestat DUO Realis Spin Hook, Mat Black, 1.8g, Nr.1/0, 3buc/pac

duo24557

Livrare 48-72 ore

48,69Lei

Vobler DUO Rough Trail Blazin 85, CPA0068 Midnight Gill, 8.5cm, 28g

Vobler DUO Rough Trail Blazin 85, CPA0068 Midnight Gill, 8.5cm, 28g

duo44401

Livrare 48-72 ore

92,41Lei

Vobler DUO Realis Fangbait 80DR, CMA3367 Chirai, 8cm, 11.5g

Vobler DUO Realis Fangbait 80DR, CMA3367 Chirai, 8cm, 11.5g

duo56039

Livrare 48-72 ore

102,58Lei

Afişare 641 - 660 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: 96.856 ms [By time] [By id] [By file]

1 (0.108)

SELECT data
FROM `oc_session`
WHERE session_id = '5f46e4cdb2e2f1117d98d49929'

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

2 (0.087)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.108)

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

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

4 (0.104)

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

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

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

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

7 (0.165)

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