DUO

DUO

Sortare după:

Spinnertail DUO Realis Spin 38 SW, MCC3515 UV Silver Shirasu, 3.8cm, 11g

Spinnertail DUO Realis Spin 38 SW, MCC3515 UV Silver Shirasu, 3.8cm, 11g

duo63365

Livrare 48-72 ore

69,02Lei

Vobler DUO Jerkbait 85 SP 8.5cm 8g AJO0091 Ivory Halo

Vobler DUO Jerkbait 85 SP 8.5cm 8g AJO0091 Ivory Halo

duo26728

Livrare imediată!

75,13Lei

Vobler DUO Realis Apex Vibe F85, DPA3268 Bronze Gill, 8.5cm, 25g

Vobler DUO Realis Apex Vibe F85, DPA3268 Bronze Gill, 8.5cm, 25g

duo38318

Livrare 48-72 ore

82,24Lei

Vobler DUO BayRuf Manic Fish 75, GLA0231 Bloody Rainbow, 7.5cm, 7.6g

Vobler DUO BayRuf Manic Fish 75, GLA0231 Bloody Rainbow, 7.5cm, 7.6g

duo69377

Livrare 48-72 ore

69,02Lei

Shad DUO Bayruf BR Fish, S039 Gold Red, 8.4cm, 7buc/pac

Shad DUO Bayruf BR Fish, S039 Gold Red, 8.4cm, 7buc/pac

duo68827

Livrare 48-72 ore

42,59Lei

Vobler Duo Realis Vibration 62 G-Fix, Ghost Gill, 6.2cm, 14.5g

Vobler Duo Realis Vibration 62 G-Fix, Ghost Gill, 6.2cm, 14.5g

duo86541

Livrare imediată!

74,21Lei

Vobler Duo Realis Vibration 65 Nitro, Glitter Shad, 5.5cm, 11.5g

Vobler Duo Realis Vibration 65 Nitro, Glitter Shad, 5.5cm, 11.5g

duo19614

Livrare imediată!

71,16Lei

Shad DUO Realis Versa Pintail, F088 Light Pro Blue, 10cm, 7buc/pac

Shad DUO Realis Versa Pintail, F088 Light Pro Blue, 10cm, 7buc/pac

duo90408

Livrare 48-72 ore

39,54Lei

Shad DUO Realis Versa Shad Fat, F018 Green Pumpkin Red Flake, 12.5cm, 5buc/pac

Shad DUO Realis Versa Shad Fat, F018 Green Pumpkin Red Flake, 12.5cm, 5buc/pac

duo83318

Livrare 48-72 ore

52,76Lei

Shad DUO Realis Versa Pintail, F085 Sexy Shad UV, 12.5cm, 5buc/pac

Shad DUO Realis Versa Pintail, F085 Sexy Shad UV, 12.5cm, 5buc/pac

duo83424

Livrare 48-72 ore

48,69Lei

Vobler DUO Realis Jerkbait 110SP, CCCZ104 Emerald Shiner ND, 11cm, 16.2g

Vobler DUO Realis Jerkbait 110SP, CCCZ104 Emerald Shiner ND, 11cm, 16.2g

duo04054

Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 85F, ASAZ400 Gunmetal M Silver Tiger, 8.5cm, 7.3g

Vobler DUO Realis Jerkbait 85F, ASAZ400 Gunmetal M Silver Tiger, 8.5cm, 7.3g

duo86227

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Rozante 77SP, DPA4009 River Bait, 7.7cm, 8.4g

Vobler DUO Realis Rozante 77SP, DPA4009 River Bait, 7.7cm, 8.4g

duo31517

Livrare 48-72 ore

78,18Lei

Shad DUO Bayruf BR Fish, F102 Brown Zircon, 8.4cm, 7buc/pac

Shad DUO Bayruf BR Fish, F102 Brown Zircon, 8.4cm, 7buc/pac

duo87309

Livrare 48-72 ore

42,59Lei

Spinnertail DUO Realis Spin 30, CDA4054 Black Gold OB, 3cm, 5g

Spinnertail DUO Realis Spin 30, CDA4054 Black Gold OB, 3cm, 5g

duo93143

Livrare 48-72 ore

69,02Lei

Vobler DUO Ryuki 45S 4.5cm 4g ASI4044 Full Chart Yamame S

Vobler DUO Ryuki 45S 4.5cm 4g ASI4044 Full Chart Yamame S

duo68813

Livrare 48-72 ore

69,02Lei

Vobler DUO Ryuki 60S 6cm 6.5g ANA4834 S

Vobler DUO Ryuki 60S 6cm 6.5g ANA4834 S

duo80600

Livrare 48-72 ore

69,02Lei

Vobler DUO Spearhead Ryuki Quattro 70S, GDA4068 Yamame Red Belly, 7cm 5.7g

Vobler DUO Spearhead Ryuki Quattro 70S, GDA4068 Yamame Red Belly, 7cm 5.7g

duo41752

Livrare 48-72 ore

110,72Lei

Vobler Duo Realis Vibration 62 G-Fix, Funky Gill, 6.2cm, 14.5g

Vobler Duo Realis Vibration 62 G-Fix, Funky Gill, 6.2cm, 14.5g

duo70595

Livrare imediată!

74,21Lei

Vobler Duo Realis Vibration 62 Apex Tune, Omnicraw RB, 6.2cm, 9.7g

Vobler Duo Realis Vibration 62 Apex Tune, Omnicraw RB, 6.2cm, 9.7g

duo31678

Livrare imediată!

71,16Lei

Afişare 841 - 860 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: 121.087 ms [By time] [By id] [By file]

1 (0.182)

SELECT data
FROM `oc_session`
WHERE session_id = 'abaa7a02420465db97944684b1'

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

2 (0.096)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.106)

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

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

4 (0.101)

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

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

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

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

7 (0.116)

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