Maver

Maver

Sortare după:

FIR MONOFILAMENT MAVER SMART ELITE FLUOROCARBON 100M 0.106MM

FIR MONOFILAMENT MAVER SMART ELITE FLUOROCARBON 100M 0.106MM

725106

Livrare 48-72 ore

28,00Lei

FIR MONOFILAMENT MAVER STONE RIVER SINNKING 600M 0.30MM

FIR MONOFILAMENT MAVER STONE RIVER SINNKING 600M 0.30MM

670030

Livrare 48-72 ore

57,00Lei

VARGA MAVER IT SUPERLITIUM MEDIUM MX 8M

VARGA MAVER IT SUPERLITIUM MEDIUM MX 8M

8444b800

Livrare 48-72 ore

3.900,00Lei

FIR MONOFILAMENT MAVER ELITE NO GRAVITY FLUO 300M 0.316MM

FIR MONOFILAMENT MAVER ELITE NO GRAVITY FLUO 300M 0.316MM

727316

Livrare 48-72 ore

85,00Lei(-50%) 42,49Lei

COSULET MAVER JURASSIC CAGE FEEDER RIVER 80g

COSULET MAVER JURASSIC CAGE FEEDER RIVER 80g

00416080

Livrare 48-72 ore

18,00Lei(-20%) 14,40Lei

CARLIGE LEGATE MAVER JURASSIC J13 NR 4-0.26

CARLIGE LEGATE MAVER JURASSIC J13 NR 4-0.26

j1300426

Livrare imediată!

8,00Lei(-30%) 5,60Lei

COSULET MAVER JURASSIC DISTANCE FEEDER 25X40MM 40g

COSULET MAVER JURASSIC DISTANCE FEEDER 25X40MM 40g

00421040

Livrare 48-72 ore

20,50Lei(-20%) 16,40Lei

CARLIGE MAVER KATANA SERIA MATCH KM3 NR 26 BRONZ

CARLIGE MAVER KATANA SERIA MATCH KM3 NR 26 BRONZ

km03a026

Livrare imediată!

12,50Lei

Vartej Maver cu Agrafa si Margea Culisanta, 10buc/pac

Vartej Maver cu Agrafa si Margea Culisanta, 10buc/pac

00429001

Livrare 48-72 ore

34,00Lei(-20%) 27,20Lei

CARLIGE MAVER KATANA SERIA SEA KS2 NR 16 Black Nickel

CARLIGE MAVER KATANA SERIA SEA KS2 NR 16 Black Nickel

ks02a016

Livrare 48-72 ore

10,00Lei

VARTEJ MAVER MV-R STEEL Nr.16 60kg 10BUC/PLIC

VARTEJ MAVER MV-R STEEL Nr.16 60kg 10BUC/PLIC

01567016

Livrare 48-72 ore

22,00Lei(-20%) 17,60Lei

CARLIGE MAVER KATANA SERIA CRAP 0.4B NR 10 BARBLESS

CARLIGE MAVER KATANA SERIA CRAP 0.4B NR 10 BARBLESS

04bkca10

Livrare 48-72 ore

13,99Lei

AGRAFA MAVER MV-R MONSTER STEEL NR.18 20kg 10buc/plic

AGRAFA MAVER MV-R MONSTER STEEL NR.18 20kg 10buc/plic

01574018

Livrare 48-72 ore

8,00Lei(-20%) 6,40Lei

Pompa Aer Maver

Pompa Aer Maver

2958000

Livrare imediată!

114,00Lei(-22%) 88,90Lei

CAP MINCIOG MAVER MATCH CAUCIUCAT 50X40CM

CAP MINCIOG MAVER MATCH CAUCIUCAT 50X40CM

1972001

Livrare imediată!

117,00Lei(-20%) 93,61Lei

FIR MONOFILAMENT MAVER SMART ZERO P12 150M 0.229MM

FIR MONOFILAMENT MAVER SMART ZERO P12 150M 0.229MM

666229

Livrare 48-72 ore

30,00Lei(-40%) 18,00Lei

VARGA MAVER GRIZZLY 23 TRT 6M

VARGA MAVER GRIZZLY 23 TRT 6M

4613b600

Livrare 48-72 ore

992,00Lei

APICALE VARF INTERN NR 1 - 2.8 MM MAVER

APICALE VARF INTERN NR 1 - 2.8 MM MAVER

j500

Livrare 48-72 ore

6,50Lei

VARF MAVER GRIZZLY 123 PLUS 6 7 8MT

VARF MAVER GRIZZLY 123 PLUS 6 7 8MT

s435200a

Livrare imediată!

145,00Lei

CUTIE PLUMBI MAVER SUPERCALIBRAT 12-2

CUTIE PLUMBI MAVER SUPERCALIBRAT 12-2

87000

Livrare imediată!

96,00Lei

Afişare 1761 - 1780 din 1784 (90 pagini)

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

1 (0.158)

SELECT data
FROM `oc_session`
WHERE session_id = '6e13885699a9588c6772a7c66c'

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

2 (0.114)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.110)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Maver'

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

4 (0.100)

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

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

5 (41.136)

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

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

6 (62.186)

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 = '2' AND p.manufacturer_id = '49' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 1760,20

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

7 (0.204)

SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '2' AND name = 'lichidare_stoc'

/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:37