DUO

DUO

Sortare după:

Vobler DUO Spearhead Ryuki 50S Takumi, AJO4064 Ivory Yamame OB, 5cm, 4g

Vobler DUO Spearhead Ryuki 50S Takumi, AJO4064 Ivory Yamame OB, 5cm, 4g

duo45835

Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 45S, ACC4810 Ayu ND, 4.5cm, 4g

Vobler Duo Spearhead Ryuki 45S, ACC4810 Ayu ND, 4.5cm, 4g

duo61883

Livrare 48-72 ore

69,02Lei

Vobler Duo Spearhead Ryuki 38S, AHA4006 Ayu OB, 3.8cm, 2.8g

Vobler Duo Spearhead Ryuki 38S, AHA4006 Ayu OB, 3.8cm, 2.8g

duo16965

Livrare 48-72 ore

69,02Lei

Vobler DUO Spreadhead Ryuki 80S, ANA4056 Golden Yamame, 8cm, 12g

Vobler DUO Spreadhead Ryuki 80S, ANA4056 Golden Yamame, 8cm, 12g

duo97950

Livrare 48-72 ore

76,15Lei

Vobler DUO Rough Trail Blazin 92, CPA0678 Burning Gold Sardine, 9.2cm, 40g

Vobler DUO Rough Trail Blazin 92, CPA0678 Burning Gold Sardine, 9.2cm, 40g

duo78635

Livrare 48-72 ore

98,51Lei

Vobler DUO Realis Fangbait 80DR, ACC3302 Albino, 8cm, 11.5g

Vobler DUO Realis Fangbait 80DR, ACC3302 Albino, 8cm, 11.5g

duo55995

Livrare 48-72 ore

102,58Lei

Cicada DUO Metal Garage Plate Jig, PPA0026 Red Gold, 7cm, 430g

Cicada DUO Metal Garage Plate Jig, PPA0026 Red Gold, 7cm, 430g

duo35492

Livrare 48-72 ore

62,92Lei

Vobler DUO Realis Rozante 63MR, CCC3505 Morning Mist, 6.3cm, 6.8g

Vobler DUO Realis Rozante 63MR, CCC3505 Morning Mist, 6.3cm, 6.8g

duo51270

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Jerkbait 100DR SP, CCC3176 Morning Dawn, 10cm, 15.6g

Vobler DUO Realis Jerkbait 100DR SP, CCC3176 Morning Dawn, 10cm, 15.6g

duo30565

Livrare 48-72 ore

75,13Lei

Ancore DUO Spearhead Ryuki RK-TR, Nr.8, 18buc/pac

Ancore DUO Spearhead Ryuki RK-TR, Nr.8, 18buc/pac

duo99947

Livrare 48-72 ore

61,92Lei

Vobler DUO Onimasu Kagura 88S, ASA4507 Kurokin, 8.8cm, 19g

Vobler DUO Onimasu Kagura 88S, ASA4507 Kurokin, 8.8cm, 19g

duo84209

Livrare 48-72 ore

112,75Lei

Vobler DUO Spearhead Ryuki 70S, ANA4032 Itou RB, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, ANA4032 Itou RB, 7cm, 9g

duo97905

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Crank 48MR Kabuki Floating, Matt Tiger, 4.8cm, 10.5g

Vobler DUO Realis Crank 48MR Kabuki Floating, Matt Tiger, 4.8cm, 10.5g

duo50280

Livrare imediată!

71,16Lei

Vobler DUO Realis Crank 50SSR Kabuki, CCC3307 Omnicraw II, 5cm, 8.4g

Vobler DUO Realis Crank 50SSR Kabuki, CCC3307 Omnicraw II, 5cm, 8.4g

duo20702

Livrare imediată!

71,16Lei

Vobler DUO Tide Minnow 75 Sprint, AHA0001 Red Head Holo, 7.5cm, 11g

Vobler DUO Tide Minnow 75 Sprint, AHA0001 Red Head Holo, 7.5cm, 11g

duo64652

Livrare 48-72 ore

85,29Lei

Vobler DUO Tetra Works Toto 48HS Heavy Sinking, GJA0101 Zebra Glow, 4.8cm, 4.3g

Vobler DUO Tetra Works Toto 48HS Heavy Sinking, GJA0101 Zebra Glow, 4.8cm, 4.3g

duo60824

Livrare 48-72 ore

69,02Lei

Vobler DUO Terrif DC-12 Type 1, AHA0010 Ayu, 12cm, 18g

Vobler DUO Terrif DC-12 Type 1, AHA0010 Ayu, 12cm, 18g

duo68295

Livrare 48-72 ore

102,58Lei

Vobler DUO Spearhead Ryuki 71S, ADA4019 Pink Yamame, 7.1cm, 10g

Vobler DUO Spearhead Ryuki 71S, ADA4019 Pink Yamame, 7.1cm, 10g

duo73685

Livrare 48-72 ore

90,37Lei

Vobler DUO Spearhead Ryuki 70S, ADA4013 Wakasagi, 7cm, 9g

Vobler DUO Spearhead Ryuki 70S, ADA4013 Wakasagi, 7cm, 9g

duo43339

Livrare 48-72 ore

75,13Lei

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

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

duo30957

Livrare 48-72 ore

69,02Lei

Afişare 601 - 620 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: 83.036 ms [By time] [By id] [By file]

1 (0.086)

SELECT data
FROM `oc_session`
WHERE session_id = '9ddba5635ce024f7229295ef2f'

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

2 (0.085)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.116)

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

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

4 (0.108)

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

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

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

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

7 (0.101)

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