Delphin

Delphin

Sortare după:

Husa ușoară Delphin Light SPACE C2G

Husa ușoară Delphin Light SPACE C2G

101002386

Livrare imediată!

101,00Lei(-41%) 59,90Lei

Montura feeder Delphin FLR Loop / 6buc 8cm carlig 8

Montura feeder Delphin FLR Loop / 6buc 8cm carlig 8

101001024

Livrare imediată!

18,00Lei(-45%) 9,90Lei

Papuci Delphin OCTO verde Marime 37

Papuci Delphin OCTO verde Marime 37

101002451

Livrare imediată!

61,00Lei(-35%) 39,90Lei

Husa 2 compartimente Delphin CLASSA 130 cm

Husa 2 compartimente Delphin CLASSA 130 cm

101000456

Livrare imediată!

190,00Lei(-47%) 99,90Lei

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

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

101000256

Livrare imediată!

18,00Lei(-56%) 7,90Lei

Papuci Delphin OCTO Albastru Marime 40

Papuci Delphin OCTO Albastru Marime 40

101002563

Livrare imediată!

61,00Lei(-41%) 35,90Lei

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

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

101002016

Livrare imediată!

23,00Lei(-57%) 9,90Lei

Fir Textil Delphin TROUTERA roz 0.045mm 4lbs 130m

Fir Textil Delphin TROUTERA roz 0.045mm 4lbs 130m

101002698

Livrare imediată!

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

Clopotel Delphin din plastic 1buc 14

Clopotel Delphin din plastic 1buc 14

830906214

Livrare imediată!

5,00Lei

Mănuși din Fleece Delphin Camp, Marime XL

Mănuși din Fleece Delphin Camp, Marime XL

750001046

Livrare imediată!

64,00Lei(-53%) 29,90Lei

Montura feeder Delphin Proxi 8 Quickstop / 6buc 8cm carlig 8

Montura feeder Delphin Proxi 8 Quickstop / 6buc 8cm carlig 8

101001035

Livrare imediată!

23,00Lei(-48%) 11,90Lei

Papuci Delphin OCTO Albastru Marime 37

Papuci Delphin OCTO Albastru Marime 37

101002461

Livrare imediată!

61,00Lei

Pantaloni de trening Delphin RAWER M

Pantaloni de trening Delphin RAWER M

101000630

Livrare imediată!

179,00Lei(-39%) 109,90Lei

Tricou Delphin ICWT S

Tricou Delphin ICWT S

101001862

Livrare imediată!

82,00Lei(-44%) 45,90Lei

Tricou Delphin FEEDER L

Tricou Delphin FEEDER L

101002238

Livrare imediată!

87,00Lei(-43%) 49,90Lei

Montura Crap Konger Leadcore Rig with Bolt-Lock Safety Clip, Camo, 75cm, 45lbs, 3buc/pac

Montura Crap Konger Leadcore Rig with Bolt-Lock Safety Clip, Camo, 75cm, 45lbs, 3buc/pac

120206590000002

Livrare imediată!

21,21Lei

Galeata Patrata cu Capac Delphin Classa Verde, 5L

Galeata Patrata cu Capac Delphin Classa Verde, 5L

101003032

Livrare imediată!

18,00Lei

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

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

101002017

Livrare imediată!

25,00Lei(-32%) 16,90Lei

Fir Textil Delphin TROUTERA roz 0.065mm 6lbs 130m

Fir Textil Delphin TROUTERA roz 0.065mm 6lbs 130m

101002699

Livrare imediată!

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

Fir Textil Delphin Nexo 8 Premium Braid Line Galben 130m 0.08mm 11lbs 4.98Kg

Fir Textil Delphin Nexo 8 Premium Braid Line Galben 130m 0.08mm 11lbs 4.98Kg

101000042

Livrare imediată!

108,00Lei(-35%) 69,90Lei

1
2
3
4
5
6
7
8
9
>
>|

Afişare 1 - 20 din 250 (13 pagini)

Queries: 7, Total time: 79.060 ms [By time] [By id] [By file]

1 (0.154)

SELECT data
FROM `oc_session`
WHERE session_id = '0e69c399da3b97844234c0c0fd'

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

2 (0.141)

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 = 'delphin.html'

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

4 (0.167)

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 = '0'

/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4

5 (36.915)

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 = '469'

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

6 (41.486)

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 = '469' 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:440

7 (0.091)

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