Sportex

Sportex

Sortare după:

Lanseta Sportex Morion Stalker Selection 10ft 3.00m 3.25lbs

Lanseta Sportex Morion Stalker Selection 10ft 3.00m 3.25lbs

mo142423

Livrare 48-72 ore

1.520,00Lei

Lanseta Sportex Rapid Spin 240 20g

Lanseta Sportex Rapid Spin 240 20g

rp2401

Livrare imediată!

659,00Lei

Varf Feeder Sportex Exclusive Feeder Heavy 4.20m/2.0oz

Varf Feeder Sportex Exclusive Feeder Heavy 4.20m/2.0oz

hf4219a2

Livrare 48-72 ore

97,00Lei

TRICOU Sportex POLO SHIRT SPORTEX CLASSIC NAVY XL

TRICOU Sportex POLO SHIRT SPORTEX CLASSIC NAVY XL

s503023

Livrare 48-72 ore

130,00Lei(-20%) 103,99Lei

LANSETA SPORTEX TOP CAT SPIN 275 60-120gr

LANSETA SPORTEX TOP CAT SPIN 275 60-120gr

tw2706

Livrare 48-72 ore

1.350,00Lei

LANSETA SPORTEX NOVA JIG RS-2 2.65M 60G 2seg

LANSETA SPORTEX NOVA JIG RS-2 2.65M 60G 2seg

pt2603

Livrare 48-72 ore

1.069,00Lei

LANSETA SPORTEX D.N.A CS-2 3.96M 3.75LBS 2SEG

LANSETA SPORTEX D.N.A CS-2 3.96M 3.75LBS 2SEG

dn145335

Livrare imediată!

1.870,00Lei(-20%) 1.496,00Lei

Lanseta Sportex Jig-Xpert Pike Baitcast 255, 28-85g

Lanseta Sportex Jig-Xpert Pike Baitcast 255, 28-85g

jx2504

Livrare 48-72 ore

870,00Lei

LANSETA SPORTEX HYPERION XT 2.70M 55-90G

LANSETA SPORTEX HYPERION XT 2.70M 55-90G

hp2714

Livrare 48-72 ore

2.075,00Lei(-30%) 1.452,00Lei

Lanseta Sportex MAGNIFIC FINESSE L 205 1.6-8gr

Lanseta Sportex MAGNIFIC FINESSE L 205 1.6-8gr

mg2001

Livrare 48-72 ore

1.510,00Lei(-25%) 1.133,00Lei

Lanseta Sportex XCLUSIVE FEEDER NT MEDIUM HEAVY 360 100-190gr

Lanseta Sportex XCLUSIVE FEEDER NT MEDIUM HEAVY 360 100-190gr

mh3618

Livrare 48-72 ore

1.410,00Lei(-25%) 1.058,01Lei

LANSETA SPORTEX CAPTOR RS-2 SPIN 2.10M 10G 2SEG

LANSETA SPORTEX CAPTOR RS-2 SPIN 2.10M 10G 2SEG

cp2111

Livrare 48-72 ore

889,00Lei

Lanseta Sportex Jig-Xpert Perch 235 4-19g

Lanseta Sportex Jig-Xpert Perch 235 4-19g

jx2301

Livrare 48-72 ore

789,01Lei

Lanseta Sportex BLACK PEARL GT-3 240 40gr Casting

Lanseta Sportex BLACK PEARL GT-3 240 40gr Casting

bp2412

Livrare 48-72 ore

670,01Lei(-25%) 503,00Lei

Lanseta Sportex CATFIRE BOAT 280 150-300gr

Lanseta Sportex CATFIRE BOAT 280 150-300gr

cf2818

Livrare 48-72 ore

899,00Lei(-30%) 629,00Lei

GEANTA SPORTEX EVA PLIABILA

GEANTA SPORTEX EVA PLIABILA

s321010

Livrare 48-72 ore

165,01Lei

LANSETA SPORTEX HYDRA SPIRIT 2.70M 40G 2SEG

LANSETA SPORTEX HYDRA SPIRIT 2.70M 40G 2SEG

hy2702

Livrare imediată!

1.020,00Lei

Lanseta Sportex Catapult Cs-4 Carp 13ft 3.96m 3.75lbs

Lanseta Sportex Catapult Cs-4 Carp 13ft 3.96m 3.75lbs

ca143379

Livrare 48-72 ore

1.260,00Lei

Lanseta Sportex Rapid Spin 270 60g

Lanseta Sportex Rapid Spin 270 60g

rp2703

Livrare imediată!

730,01Lei

Varf Feeder Sportex Rapid Method Feeder 3.60m/3.0oz

Varf Feeder Sportex Rapid Method Feeder 3.60m/3.0oz

mf3622a2

Livrare imediată!

69,00Lei(-32%) 47,01Lei

Afişare 281 - 300 din 391 (20 pagini)

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

1 (0.115)

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

/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.091)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Sportex'

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

4 (0.130)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '192' AND m2s.store_id = '0'

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

5 (37.557)

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

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

6 (48.771)

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 = '192' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 280,20

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

7 (0.121)

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