Delphin


Suport Delphin D STICK 32 50

Suport Delphin D STICK 32 50

101000668
Livrare imediată!

49,82Lei

Carlige Delphin offset lestat BOMB! HeavyShank / 5pcs 3g 3/0 -38%

Carlige Delphin offset lestat BOMB! HeavyShank / 5pcs 3g 3/0

101002014
Livrare imediată!

21,01Lei(-38%) 13,10Lei

Fir Textil Delphin TROUTERA roz 0.045mm 4lbs 130m -45%

Fir Textil Delphin TROUTERA roz 0.045mm 4lbs 130m

101002698
Livrare imediată!

87,00Lei(-45%) 47,67Lei

Suport Delphin feeder EVA SmallBEND -44%

Suport Delphin feeder EVA SmallBEND

101001472
Livrare imediată!

40,00Lei(-44%) 22,25Lei

Montură Delphin FLR Loop 12cm, 0.22mm, BARB Nr.6, 6buc/pac -50%

Montură Delphin FLR Loop 12cm, 0.22mm, BARB Nr.6, 6buc/pac

101000256
Livrare imediată!

18,00Lei(-50%) 9,03Lei

Carlige Delphin HKD ISEAMA NR.1/0 -50%

Carlige Delphin HKD ISEAMA NR.1/0

622010100
Livrare imediată!

12,00Lei(-50%) 5,98Lei

Cap Jig Fara Guler Delphin BOMB 7.50G NR.2/0 -40%

Cap Jig Fara Guler Delphin BOMB 7.50G NR.2/0

665075020
Livrare imediată!

15,00Lei(-40%) 9,03Lei

Agrafe Delphin A 01 BN NR.14 -29%

Agrafe Delphin A 01 BN NR.14

969a01014
Livrare imediată!

7,01Lei(-29%) 4,97Lei

Jig Delphin cu spin pentru fixarea nălucii BOMB! / 5pcs 15gr nr.7/0 -38%

Jig Delphin cu spin pentru fixarea nălucii BOMB! / 5pcs 15gr nr.7/0

101001926
Livrare imediată!

26,00Lei(-38%) 16,15Lei

Plumb Dropshot Delphin Bomb, 3.5gr, 5buc/pac -36%

Plumb Dropshot Delphin Bomb, 3.5gr, 5buc/pac

965925003
Livrare imediată!

11,00Lei(-36%) 7,01Lei

Lanseta Delphin Capri Tele 3.60M 180g

Lanseta Delphin Capri Tele 3.60M 180g

150852366
Livrare imediată!

232,83Lei

Carlig Delphin HKD RIGER TEFCON NR.8 -50%

Carlig Delphin HKD RIGER TEFCON NR.8

622710008
Livrare imediată!

16,00Lei(-50%) 8,02Lei

Montura Delphin THE END Skin rig 20cm 25lbs NR.4 -31%

Montura Delphin THE END Skin rig 20cm 25lbs NR.4

830410624
Livrare imediată!

22,00Lei(-31%) 15,13Lei

Jig Delphin cu spin pentru fixarea nălucii BOMB! / 5pcs 7.5gr nr.1 -38%

Jig Delphin cu spin pentru fixarea nălucii BOMB! / 5pcs 7.5gr nr.1

101001897
Livrare imediată!

13,00Lei(-38%) 8,02Lei

Snur Pentru Ochelari Delphin SWIM Negru -31%

Snur Pentru Ochelari Delphin SWIM Negru

920121700
Livrare imediată!

16,00Lei(-31%) 11,07Lei

Carlig Delphin HKD Feeder SMUTER NR.8 -42%

Carlig Delphin HKD Feeder SMUTER NR.8

622060008
Livrare imediată!

12,00Lei(-42%) 7,01Lei

SHAD DELPHIN BOMB RIPPA 10CM SPRING -42%

SHAD DELPHIN BOMB RIPPA 10CM SPRING

690031008
Livrare imediată!

19,00Lei(-42%) 11,07Lei

Varfuri Feeder Delphin FDR-T 5buc 18 cm -39%

Varfuri Feeder Delphin FDR-T 5buc 18 cm

935002018
Livrare imediată!

9,99Lei(-39%) 6,07Lei

GALEATA PLIABILA PRO FL 8.5L CU SFOARA

GALEATA PLIABILA PRO FL 8.5L CU SFOARA

64-9596
Livrare 24-48 ore

46,65Lei

Carlige Delphin HKD KEIRU NR.12 -36%

Carlige Delphin HKD KEIRU NR.12

622025012
Livrare imediată!

11,00Lei(-36%) 7,01Lei

Afişare 41 - 60 din 201 (11 pagini)
Queries: 7, Total time: 84.456 ms [By time] [By id] [By file]
1 (0.080)
SELECT data
FROM `oc_session`
WHERE session_id = '7ad6e6e5fbb4bf977d9cce946e'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.082)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.124)
SELECT *
FROM oc_url_alias
WHERE keyword = 'delphin.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.109)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '469' AND m2s.store_id = '3'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (36.867)
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 = '3' AND p.manufacturer_id = '469'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (47.056)
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 = '3' AND p.manufacturer_id = '469' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 40,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.138)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '3' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37