DUO

DUO

Sortare după:

Vobler DUO Luayu VIB, CCC4517 Aoriayu, 10cm, 15g

Vobler DUO Luayu VIB, CCC4517 Aoriayu, 10cm, 15g

duo91542

Livrare 48-72 ore

128,01Lei

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, F098 Ice Cube, 12.5cm, 5buc/pac

Shad DUO Realis Versa Shad Fat, F098 Ice Cube, 12.5cm, 5buc/pac

duo87798

Livrare 48-72 ore

52,76Lei

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

duo78468

Livrare 48-72 ore

36,49Lei

Vobler DUO Realis Jerkbait 100SP, CCC3254 D Shad, 10cm, 14.5g

Vobler DUO Realis Jerkbait 100SP, CCC3254 D Shad, 10cm, 14.5g

duo14497

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Jerkbait 120SP, ACC3708 Neo Pearl UV Limited, 12cm, 17.7g

Vobler DUO Realis Jerkbait 120SP, ACC3708 Neo Pearl UV Limited, 12cm, 17.7g

duo69138

Livrare 48-72 ore

86,31Lei

Vobler DUO Realis Jerkbait 85SP, ASA3146 Gold Perch, 8.5cm, 8g

Vobler DUO Realis Jerkbait 85SP, ASA3146 Gold Perch, 8.5cm, 8g

duo66069

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Rozante 63SP, ADA3199 Mat Rider OB, 6.3cm, 5g

Vobler DUO Realis Rozante 63SP, ADA3199 Mat Rider OB, 6.3cm, 5g

duo01619

Livrare 48-72 ore

73,08Lei

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

Afişare 1221 - 1240 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: 93.310 ms [By time] [By id] [By file]

1 (0.101)

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

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

2 (0.126)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.131)

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

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

4 (0.119)

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

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

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

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

7 (0.139)

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