DUO

DUO

Sortare după:

Vobler DUO Realis Fangbait 80DR, CPA3255 PG Red Head, 8cm, 11.5g

Vobler DUO Realis Fangbait 80DR, CPA3255 PG Red Head, 8cm, 11.5g

duo55971

Livrare 48-72 ore

102,58Lei

Cicada DUO Metal Garage Plate Jig, ACC0016 Mat Pink, 6.5cm, 20g

Cicada DUO Metal Garage Plate Jig, ACC0016 Mat Pink, 6.5cm, 20g

duo35300

Livrare 48-72 ore

56,82Lei

Vobler DUO Realis Shad 57MR SP, ADA3058 Prism Gill, 5.7cm, 4.8g

Vobler DUO Realis Shad 57MR SP, ADA3058 Prism Gill, 5.7cm, 4.8g

duo19218

Livrare 48-72 ore

72,07Lei

Vobler DUO Realis Jerkbait 100DR SP, DRA3050 Half Mirror Ayu, 10cm, 15.6g

Vobler DUO Realis Jerkbait 100DR SP, DRA3050 Half Mirror Ayu, 10cm, 15.6g

duo65218

Livrare 48-72 ore

75,13Lei

Cutie DUO TetraWorks Run and Gun Case, Black / Gold Logo, 17.5x10.5x3.8cm

duo41011

Livrare 48-72 ore

92,41Lei

Vobler DUO Onimasu Kagura 77S, CCC4524 Ruri Yamame, 7.7cm, 12.5g

Vobler DUO Onimasu Kagura 77S, CCC4524 Ruri Yamame, 7.7cm, 12.5g

duo84339

Livrare 48-72 ore

108,68Lei

Vobler DUO Bayruf Bulk 95F, ACC0077 Ginrin Mat Chart, 9.5cm, 14g

Vobler DUO Bayruf Bulk 95F, ACC0077 Ginrin Mat Chart, 9.5cm, 14g

duo98459

Livrare 48-72 ore

109,70Lei

Spinnertail DUO Realis Spin 35 CCC3510 Sight Chart Gill, 3.5cm, 7g

Spinnertail DUO Realis Spin 35 CCC3510 Sight Chart Gill, 3.5cm, 7g

duo93341

Livrare 48-72 ore

69,02Lei

Vobler DUO Tetra Works Toto 48HS Heavy Sinking, AQA0313 Pink Candy GB, 4.8cm, 4.3g

Vobler DUO Tetra Works Toto 48HS Heavy Sinking, AQA0313 Pink Candy GB, 4.8cm, 4.3g

duo76412

Livrare 48-72 ore

69,02Lei

Vobler DUO Tide Minnow 75 Sprint, CPB0054 Genkai Sardine, 7.5cm, 11g

Vobler DUO Tide Minnow 75 Sprint, CPB0054 Genkai Sardine, 7.5cm, 11g

duo80621

Livrare 48-72 ore

85,29Lei

Vobler DUO Terrif DC-12 Type 1, GFN0094 Chigomori Sardine, 12cm, 18g

Vobler DUO Terrif DC-12 Type 1, GFN0094 Chigomori Sardine, 12cm, 18g

duo20170

Livrare 48-72 ore

102,58Lei

Vobler DUO Spearhead Ryuki 71S, ADA4090 UV RGG Yamame OB, 7.1cm, 10g

Vobler DUO Spearhead Ryuki 71S, ADA4090 UV RGG Yamame OB, 7.1cm, 10g

duo85718

Livrare 48-72 ore

90,37Lei

Vobler DUO Spearhead Ryuki 70S, AHA4006 Ayu OB, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, AHA4006 Ayu OB, 7cm, 9g

duo11434

Livrare 48-72 ore

75,13Lei

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, ADA4019 Pink Yamame, 4.5cm, 4g

Vobler Duo Spearhead Ryuki 45S, ADA4019 Pink Yamame, 4.5cm, 4g

duo30810

Livrare 48-72 ore

69,02Lei

Vobler DUO Realis Vibration 68 G-FIX, CCC3351 LG Ghost Gill, 6.8cm, 21g

Vobler DUO Realis Vibration 68 G-FIX, CCC3351 LG Ghost Gill, 6.8cm, 21g

duo74439

Livrare 48-72 ore

75,13Lei

Vobler DUO Spreadhead Ryuki 70SP, CRA3061 Komochi Wakasagi, 7cm, 4.1g

Vobler DUO Spreadhead Ryuki 70SP, CRA3061 Komochi Wakasagi, 7cm, 4.1g

duo95380

Livrare 48-72 ore

75,13Lei

Afişare 361 - 380 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: 90.857 ms [By time] [By id] [By file]

1 (0.094)

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

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

2 (0.099)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.118)

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

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

4 (0.105)

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

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

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

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

7 (0.095)

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