DUO

DUO

Sortare după:

Shad DUO Realis Versa Shad, F092 Pink Chart, 7.6cm, 10buc/pac

Shad DUO Realis Versa Shad, F092 Pink Chart, 7.6cm, 10buc/pac

duo80218

Livrare 48-72 ore

36,49Lei

Vobler DUO Realis Jerkbait 110SP, CCC3158 Ghost Gill, 11cm, 16.2g

Vobler DUO Realis Jerkbait 110SP, CCC3158 Ghost Gill, 11cm, 16.2g

duo66826

Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 85F, ACCZ402 Gunmetal M White Tiger, 8.5cm, 7.3g

Vobler DUO Realis Jerkbait 85F, ACCZ402 Gunmetal M White Tiger, 8.5cm, 7.3g

duo86241

Livrare 48-72 ore

75,13Lei

Vobler DUO Realis Rozante 77SP, CEA3375 ELT Chart, 7.7cm, 8.4g

Vobler DUO Realis Rozante 77SP, CEA3375 ELT Chart, 7.7cm, 8.4g

duo63181

Livrare 48-72 ore

78,18Lei

Vobler DUO Realis Rozante 63SP, DRA3050 Half Mirror Ayu, 6.3cm, 5g

Vobler DUO Realis Rozante 63SP, DRA3050 Half Mirror Ayu, 6.3cm, 5g

duo61456

Livrare 48-72 ore

73,08Lei

Shad DUO Bayruf BR Fish, F098 Ice Cube, 8.4cm, 7buc/pac

Shad DUO Bayruf BR Fish, F098 Ice Cube, 8.4cm, 7buc/pac

duo87262

Livrare 48-72 ore

42,59Lei

Spinnertail DUO Realis Spin 30, CCC3028 Ghost Chart, 3cm, 5g

Spinnertail DUO Realis Spin 30, CCC3028 Ghost Chart, 3cm, 5g

duo93198

Livrare 48-72 ore

69,02Lei

Vobler DUO Realis Jerkbait 100 SP 10cm 14.5g DRA3050 Half Mirrow Ayu

Vobler DUO Realis Jerkbait 100 SP 10cm 14.5g DRA3050 Half Mirrow Ayu

duo56650

Livrare imediată!

74,21Lei

Vobler DUO Ryuki 50S Takumi 5cm 4g ADA4068 Yamame Red Belly S

Vobler DUO Ryuki 50S Takumi 5cm 4g ADA4068 Yamame Red Belly S

duo33184

Livrare imediată!

69,02Lei

Vobler DUO Realis Apex Vibe F85, DEA3341 AM Edge, 8.5cm, 25g

Vobler DUO Realis Apex Vibe F85, DEA3341 AM Edge, 8.5cm, 25g

duo38295

Livrare 48-72 ore

82,24Lei

Vobler Duo Realis Vibration 68 G-Fix, Shadow Halo, 6.8cm, 21g

Vobler Duo Realis Vibration 68 G-Fix, Shadow Halo, 6.8cm, 21g

duo64464

Livrare imediată!

74,21Lei

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

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

duo31692

Livrare imediată!

71,16Lei

Shad DUO Realis Versa, F079 Dark Motor Oil UV, 10cm, 7buc/pac

Shad DUO Realis Versa, F079 Dark Motor Oil UV, 10cm, 7buc/pac

duo90125

Livrare 48-72 ore

39,54Lei

Vobler DUO Realis Rozante 77SP, ADA3197 Violet Gill YB, 7.7cm, 8.4g

Vobler DUO Realis Rozante 77SP, ADA3197 Violet Gill YB, 7.7cm, 8.4g

duo01626

Livrare 48-72 ore

78,18Lei

Inele Despicate DUO Original Split Ring, Nr.5, 12buc/plic

Inele Despicate DUO Original Split Ring, Nr.5, 12buc/plic

duo77693

Livrare 48-72 ore

13,10Lei

Vobler DUO Spearhead Ryuki Quattro 90S, CMA4083 Blue Back RB II, 9cm 14g

Vobler DUO Spearhead Ryuki Quattro 90S, CMA4083 Blue Back RB II, 9cm 14g

duo58088

Livrare 48-72 ore

130,03Lei

Shad DUO Realis Versa Shad, F081 Copper Red Gold, 7.6cm, 10buc/pac

Shad DUO Realis Versa Shad, F081 Copper Red Gold, 7.6cm, 10buc/pac

duo78413

Livrare 48-72 ore

36,49Lei

Shad DUO Realis Versa Pintail, F084 Lime Chartreuse UV, 7.6cm, 10buc/pac

Shad DUO Realis Versa Pintail, F084 Lime Chartreuse UV, 7.6cm, 10buc/pac

duo78567

Livrare 48-72 ore

36,49Lei

Vobler DUO Realis Jerkbait 110SP, ACC3338 Dragon Fruit Tiger, 11cm, 16.2g

Vobler DUO Realis Jerkbait 110SP, ACC3338 Dragon Fruit Tiger, 11cm, 16.2g

duo28227

Livrare 48-72 ore

80,21Lei

Vobler DUO Realis Jerkbait 120SP, CCC3816 Wakasagi ND, 12cm, 17.7g

Vobler DUO Realis Jerkbait 120SP, CCC3816 Wakasagi ND, 12cm, 17.7g

duo82796

Livrare 48-72 ore

86,31Lei

Afişare 881 - 900 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: 105.252 ms [By time] [By id] [By file]

1 (0.127)

SELECT data
FROM `oc_session`
WHERE session_id = '7617f4f081531985a0c26f41f5'

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

2 (0.127)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.129)

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

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

4 (0.111)

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

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

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

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

7 (0.122)

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