DUO

DUO

Sortare după:

Spinnertail DUO Realis Spin 38, CCC3028 Ghost Chart, 3.8cm, 11g

Spinnertail DUO Realis Spin 38, CCC3028 Ghost Chart, 3.8cm, 11g

duo04184

Livrare 48-72 ore

69,02Lei

Vobler DUO Tetra Works Toto Fat 35F, MCC0522 UV Silver Slash B, 3.5cm, 1.8g

Vobler DUO Tetra Works Toto Fat 35F, MCC0522 UV Silver Slash B, 3.5cm, 1.8g

duo55889

Livrare 48-72 ore

69,02Lei

Vobler DUO Tetra Works Kurakura SF, GBA0291 Red Isome, 3cm, 2.5g

Vobler DUO Tetra Works Kurakura SF, GBA0291 Red Isome, 3cm, 2.5g

duo91958

Livrare 48-72 ore

72,07Lei

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

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

duo57395

Livrare 48-72 ore

41,58Lei

Vobler DUO Spearhead Ryuki 80S, ANA4010 Ayu, 8cm, 12g

Vobler DUO Spearhead Ryuki 80S, ANA4010 Ayu, 8cm, 12g

duo43599

Livrare 48-72 ore

76,15Lei

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

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

duo15517

Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 70S, GPA4009 River Bait, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, GPA4009 River Bait, 7cm, 9g

duo11441

Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 50S, ANA4076 Pink Clown Yamame, 5cm, 4.5g

Vobler DUO Spearhead Ryuki 50S, ANA4076 Pink Clown Yamame, 5cm, 4.5g

duo72664

Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 60S, ADA4071 Hokkaido, 6cm, 6.5g

Vobler DUO Spearhead Ryuki 60S, ADA4071 Hokkaido, 6cm, 6.5g

duo87210

Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki 51S, ANA4010 Ayu, 5.1cm, 5.5g

Vobler DUO Spearhead Ryuki 51S, ANA4010 Ayu, 5.1cm, 5.5g

duo61453

Livrare 48-72 ore

75,13Lei

Vobler DUO Spearhead Ryuki 46S, ADA4019 Pink Yamame, 4.6cm, 5g

Vobler DUO Spearhead Ryuki 46S, ADA4019 Pink Yamame, 4.6cm, 5g

duo61262

Livrare 48-72 ore

77,16Lei

Vobler Duo Spearhead Ryuki 45S, ANA4134 Lake Yamame, 4.5cm, 4g

Vobler Duo Spearhead Ryuki 45S, ANA4134 Lake Yamame, 4.5cm, 4g

duo85070

Livrare 48-72 ore

69,02Lei

Vobler DUO Rough Trail Aomasa Lightning 190F, CPA0523 Pink Head Silver, 19cm, 74g

Vobler DUO Rough Trail Aomasa Lightning 190F, CPA0523 Pink Head Silver, 19cm, 74g

duo77010

Livrare 48-72 ore

204,26Lei

Spinnertail DUO Realis Spin 40, ACC3016 Blue Back Chart, 4cm, 14g

Spinnertail DUO Realis Spin 40, ACC3016 Blue Back Chart, 4cm, 14g

duo50228

Livrare 48-72 ore

69,02Lei

Vobler DUO Spreadhead Ryuki 80SP, MCC4036 Rainbow Trout, 8cm, 5.6g

Vobler DUO Spreadhead Ryuki 80SP, MCC4036 Rainbow Trout, 8cm, 5.6g

duo95434

Livrare 48-72 ore

76,15Lei

Vobler DUO Spearhead Ryuki 70F, ADA3058 Prism Gill, 7cm, 5.3g

Vobler DUO Spearhead Ryuki 70F, ADA3058 Prism Gill, 7cm, 5.3g

duo63672

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Spinbait 62 Alpha, ADA3058 Prism Gill, 6.2cm, 10.9g

Vobler DUO Realis Spinbait 62 Alpha, ADA3058 Prism Gill, 6.2cm, 10.9g

duo44067

Livrare 48-72 ore

70,03Lei

Cicada DUO Metal Garage Plate Jig, PHA0011 Sardine, 8cm, 40g

Cicada DUO Metal Garage Plate Jig, PHA0011 Sardine, 8cm, 40g

duo35713

Livrare 48-72 ore

70,03Lei

Cicada DUO Metal Garage Plate Jig, PHA0034 Sayori, 6.5cm, 20g

Cicada DUO Metal Garage Plate Jig, PHA0034 Sayori, 6.5cm, 20g

duo35454

Livrare 48-72 ore

56,82Lei

Vobler DUO Realis Shad 57MR SP, CCC3260 Ghost Wakasagi, 5.7cm, 4.8g

Vobler DUO Realis Shad 57MR SP, CCC3260 Ghost Wakasagi, 5.7cm, 4.8g

duo19287

Livrare 48-72 ore

72,07Lei

Afişare 561 - 580 din 1283 (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: 91.932 ms [By time] [By id] [By file]

1 (0.199)

SELECT data
FROM `oc_session`
WHERE session_id = '626a15b023d5eb32407d8ab572'

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

2 (0.093)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.130)

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

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

4 (0.122)

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

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

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

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

7 (0.130)

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