Delalande


Set Shad-uri Delalande Shad GT Fire Tiger, 9cm, 4buc

Set Shad-uri Delalande Shad GT Fire Tiger, 9cm, 4buc

005509frt
Livrare 48-72 ore

17,50Lei

Shad Delalande GT Pearl Blue/Black Back 9cm 4buc/plic

Shad Delalande GT Pearl Blue/Black Back 9cm 4buc/plic

005508pbbkb
Livrare 48-72 ore

17,50Lei

Twister Delaland Miss Shad 8 Cm Red Head 4 Buc

Twister Delaland Miss Shad 8 Cm Red Head 4 Buc

005408btr
Livrare 48-72 ore

18,20Lei

Shad Delalande Skeleton 11cm Jungle 88

Shad Delalande Skeleton 11cm Jungle 88

3520519885938
Livrare imediată!

6,90Lei

TWISTERE, DELALANDE, SANDRA, 9CM, FIRE, TIGER, 4, BUC, 006020frt, Grub-uri, Grub-uri Delalande, Delalande

TWISTERE, DELALANDE, SANDRA, 9CM, FIRE, TIGER, 4, BUC, 006020frt, Grub-uri, Grub-uri Delalande, Delalande

006020frt
Livrare imediată!

19,60Lei

Set Shad-uri Delalande Shad GT Pearl Blue/Bleu Back, 9cm, 4buc

Set Shad-uri Delalande Shad GT Pearl Blue/Bleu Back, 9cm, 4buc

005509pbblb
Livrare imediată!

17,50Lei

Grub Delalande King 8cm Chartreuse 10buc/plic

Grub Delalande King 8cm Chartreuse 10buc/plic

245004018
Livrare imediată!

9,31Lei

Twister Delaland Shad 10 Cm White Red Head 4 Buc

Twister Delaland Shad 10 Cm White Red Head 4 Buc

005504btr
Livrare imediată!

13,20Lei

Shad Delalande Skeleton 8cm Spy 69

Shad Delalande Skeleton 8cm Spy 69

3520519888779
Livrare imediată!

3,50Lei

Shad Delalande Skeleton 8cm White Red Head 61

Shad Delalande Skeleton 8cm White Red Head 61

3520519845185
Livrare imediată!

3,70Lei

Grub Delalande Sandra Chartreuse Red Back, 9cm, 4buc/plic -29%

Grub Delalande Sandra Chartreuse Red Back, 9cm, 4buc/plic

006020cdr
Livrare imediată!

19,60Lei(-29%) 13,99Lei

Grub Delalande King 8cm White 10buc/plic -37%

Grub Delalande King 8cm White 10buc/plic

245004010
Livrare imediată!

9,31Lei(-37%) 5,90Lei

Twister Delaland Shad 8 Cm White 4 Buc

Twister Delaland Shad 8 Cm White 4 Buc

005514b
Livrare imediată!

8,29Lei

Shad Delalande Skeleton 11cm Sky Blue 111

Shad Delalande Skeleton 11cm Sky Blue 111

3520519894275
Livrare imediată!

6,90Lei

Shad Delalande Skeleton 11cm White Red Head 61

Shad Delalande Skeleton 11cm White Red Head 61

3520519845192
Livrare imediată!

6,90Lei

Grub, Delalande, Sandra, Fluo, Yellow, Red, Head,, 9cm,, 4buc/plic, 006020fyrh, Grub-uri, Grub-uri Delalande, Delalande
Shad Delalande 7.5cm Chartreuse 5buc/plic -30%

Shad Delalande 7.5cm Chartreuse 5buc/plic

005513cp
Livrare imediată!

9,90Lei(-30%) 6,90Lei

Twister, Delaland, Sandra, 9cm, Cm, White, 4, Buc, 006020b, Grub-uri, Grub-uri Delalande, Delalande

Twister, Delaland, Sandra, 9cm, Cm, White, 4, Buc, 006020b, Grub-uri, Grub-uri Delalande, Delalande

006020b
Livrare imediată!

19,60Lei

Set Shad-uriDelalande Shad Pearl Black Back, 7.5cm, 5buc

Set Shad-uriDelalande Shad Pearl Black Back, 7.5cm, 5buc

005503no
Livrare imediată!

9,90Lei

Twister, Delalande, Sandra, Pearl, Black, Red, Head, 9cm, 4buc/plic, 006020pbrh, Grub-uri, Grub-uri Delalande, Delalande
Afişare 1 - 20 din 23 (2 pagini)
Queries: 9, Total time: 49.247 ms [By time] [By id] [By file]
1 (0.070)
SELECT data
FROM `oc_session`
WHERE session_id = 'eddc9bbbe78a0245ecf3cf659d'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.061)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.102)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.135)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Delalande'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.131)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '322' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (22.233)
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 = '2' AND p.manufacturer_id = '322'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1661
7 (26.315)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '2' AND p.manufacturer_id = '322' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 0,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:438
8 (0.102)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
9 (0.098)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38