DUO

DUO

Sortare după:

Vobler DUO Realis Jerkbait 100SP, ANAZ174 Sagoshi Silver, 10cm, 14.5g

Vobler DUO Realis Jerkbait 100SP, ANAZ174 Sagoshi Silver, 10cm, 14.5g

duo77188

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Jerkbait 110SP, GEA3009 Pro Blue Ghost, 11cm, 16.2g

Vobler DUO Realis Jerkbait 110SP, GEA3009 Pro Blue Ghost, 11cm, 16.2g

duo66758

Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 85SP, ACC3228 Beast Bone, 8.5cm, 8g

Vobler DUO Realis Jerkbait 85SP, ACC3228 Beast Bone, 8.5cm, 8g

duo74521

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Rozante 63SP, CSA3237 Inakko, 6.3cm, 5g

Vobler DUO Realis Rozante 63SP, CSA3237 Inakko, 6.3cm, 5g

duo01183

Livrare 48-72 ore

73,08Lei

Shad DUO Bayruf BR Fish, S044 Lime Gold, 8.4cm, 7buc/pac

Shad DUO Bayruf BR Fish, S044 Lime Gold, 8.4cm, 7buc/pac

duo68872

Livrare 48-72 ore

42,59Lei

Vobler DUO Realis Shinmushi, CCC3406 Clown Bug, 4.0cm, 5.7g

Vobler DUO Realis Shinmushi, CCC3406 Clown Bug, 4.0cm, 5.7g

duo75023

Livrare 48-72 ore

72,07Lei

Vobler DUO Realis Jerkbait 100 SP 10cm 14.5g ADA3081 Prism Shad

Vobler DUO Realis Jerkbait 100 SP 10cm 14.5g ADA3081 Prism Shad

duo56636

Livrare imediată!

74,21Lei

Vobler DUO Ryuki 45S 4.5cm 4g SMA4083 Blue Back RB S

Vobler DUO Ryuki 45S 4.5cm 4g SMA4083 Blue Back RB S

duo28890

Livrare imediată!

69,02Lei

Vobler DUO Realis Crank Mid Roller 40F 4cm 5.3g AJA3055 Chart Gill Halo F

Vobler DUO Realis Crank Mid Roller 40F 4cm 5.3g AJA3055 Chart Gill Halo F

duo37106

Livrare 48-72 ore

72,07Lei

Vobler Duo Realis Vibration 68 G-Fix, Tule Perch ND, 6.8cm, 21g

Vobler Duo Realis Vibration 68 G-Fix, Tule Perch ND, 6.8cm, 21g

duo85131

Livrare imediată!

74,21Lei

Vobler Duo Realis Vibration 62 Apex Tune, AM Hasu, 6.2cm, 9.7g

Vobler Duo Realis Vibration 62 Apex Tune, AM Hasu, 6.2cm, 9.7g

duo31777

Livrare imediată!

71,16Lei

Shad DUO Realis Versa, F078 Gold Flash Shad, 10cm, 7buc/pac

Shad DUO Realis Versa, F078 Gold Flash Shad, 10cm, 7buc/pac

duo90118

Livrare 48-72 ore

39,54Lei

Shad DUO Realis Versa Pintail, F087 Young Melon, 10cm, 7buc/pac

Shad DUO Realis Versa Pintail, F087 Young Melon, 10cm, 7buc/pac

duo90392

Livrare 48-72 ore

39,54Lei

Inele Despicate DUO Original Split Ring, Nr.3.5, 18buc/plic

Inele Despicate DUO Original Split Ring, Nr.3.5, 18buc/plic

duo16668

Livrare 48-72 ore

13,10Lei

Vobler DUO Spearhead Ryuki Quattro 90S, CDA4140 Lime Yamame OB, 9cm 14g

Vobler DUO Spearhead Ryuki Quattro 90S, CDA4140 Lime Yamame OB, 9cm 14g

duo58101

Livrare 48-72 ore

130,03Lei

Shad DUO Realis Versa Shad Fat, F091 Baby Bass, 17.8cm, 3buc/pac

Shad DUO Realis Versa Shad Fat, F091 Baby Bass, 17.8cm, 3buc/pac

duo88160

Livrare 48-72 ore

85,29Lei

Shad DUO Realis Versa Shad, F091 Baby Bass, 7.6cm, 10buc/pac

Shad DUO Realis Versa Shad, F091 Baby Bass, 7.6cm, 10buc/pac

duo80201

Livrare 48-72 ore

36,49Lei

Shad DUO Realis Versa Pintail, F018 Green Pumpkin Red Flake, 7.6cm, 10buc/pac

Shad DUO Realis Versa Pintail, F018 Green Pumpkin Red Flake, 7.6cm, 10buc/pac

duo80287

Livrare 48-72 ore

36,49Lei

Vobler DUO Realis Jerkbait 110SP, CCC3108 Ghost Pearl, 11cm, 16.2g

Vobler DUO Realis Jerkbait 110SP, CCC3108 Ghost Pearl, 11cm, 16.2g

duo73531

Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 85F, ACCZ401 S Red Orange Tiger, 8.5cm, 7.3g

Vobler DUO Realis Jerkbait 85F, ACCZ401 S Red Orange Tiger, 8.5cm, 7.3g

duo86234

Livrare 48-72 ore

75,13Lei

Afişare 1021 - 1040 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: 92.174 ms [By time] [By id] [By file]

1 (0.142)

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

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

2 (0.103)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.115)

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

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

4 (0.115)

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

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

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

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

7 (0.100)

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