Cormoran

Cormoran

Sortare după:

PICHET TELEESCOPIC CORMORAN PRO CARP L=60-110CM

PICHET TELEESCOPIC CORMORAN PRO CARP L=60-110CM

a6.11.09060

Livrare imediată!

48,09Lei

FIR TEXTIL CORMORAN CORASTRONG VERDE 028MM/18,2KG/135M

FIR TEXTIL CORMORAN CORASTRONG VERDE 028MM/18,2KG/135M

c.32.013528

Livrare 24-48 ore

21,95Lei

CORMORAN MONTURA CLASIC RIG T4 NR.2/2BUC

CORMORAN MONTURA CLASIC RIG T4 NR.2/2BUC

a.11.02303.2

Livrare 24-48 ore

21,86Lei(-45%) 12,12Lei

LANSETA CORMORAN 3+3BUC.SPECILAND SRP FEEDER 3,90/60-180G

LANSETA CORMORAN 3+3BUC.SPECILAND SRP FEEDER 3,90/60-180G

c.25.5180399

Livrare 24-48 ore

434,35Lei(-18%) 354,32Lei

Kit Cormoran Pro Carp Chod Rig Set Mud

Kit Cormoran Pro Carp Chod Rig Set Mud

a.11.00221

Livrare imediată!

21,90Lei(-55%) 9,91Lei

OSCILANTA CORMORAN CORA-Z 50MM/16G SILVER/RED SC.

OSCILANTA CORMORAN CORA-Z 50MM/16G SILVER/RED SC.

f.50.861016

Stoc epuizat

11,27Lei(-30%) 7,87Lei

Lanseta Cormoran GF Feeder Pro H 3.60m, 50-150g, 3+3SEG

Lanseta Cormoran GF Feeder Pro H 3.60m, 50-150g, 3+3SEG

c.25.2150367

Livrare imediată!

366,25Lei(-18%) 298,92Lei

Lingura oscilanta Cormoran Toro UL6 2.8cm 1.8g Fabre 30

Lingura oscilanta Cormoran Toro UL6 2.8cm 1.8g Fabre 30

f.50.88630

Livrare 24-48 ore

16,14Lei(-33%) 10,84Lei

SALOPETA CORMORAN NEOPREN MAR.42/43

SALOPETA CORMORAN NEOPREN MAR.42/43

a8.94.03243

Livrare 24-48 ore

692,39Lei(-10%) 624,15Lei

VARGA CORMORAN TELE EUROCOR 6,00M

VARGA CORMORAN TELE EUROCOR 6,00M

c.26.00601

Livrare imediată!

101,33Lei

VARF CORMORAN PT.FEEDER SHORT TRACK RED 3,05OZ Model 2

VARF CORMORAN PT.FEEDER SHORT TRACK RED 3,05OZ Model 2

c.25.2170300r

Livrare 24-48 ore

47,55Lei(-18%) 39,03Lei

Pensta Cleste Cormoran pentru Inele Despicate 16.5cm

Pensta Cleste Cormoran pentru Inele Despicate 16.5cm

a.84.11001

Livrare imediată!

36,72Lei(-17%) 30,38Lei

VOBLER CORMORAN COR F2 CARP 3.5CM 2.5G

VOBLER CORMORAN COR F2 CARP 3.5CM 2.5G

f3.53.04361

Livrare imediată!

32,98Lei

VARF CORMORAN FEEDER SPECILAND SRP YELLOW 2,50OZ

VARF CORMORAN FEEDER SPECILAND SRP YELLOW 2,50OZ

c.25.5150y

Livrare imediată!

56,72Lei

SHAD CORMORAN CRAZY FIN RTF 10CM UV HERRING 6G 2BUC/PLIC

SHAD CORMORAN CRAZY FIN RTF 10CM UV HERRING 6G 2BUC/PLIC

f1.51.890910

Livrare imediată!

18,19Lei

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Farbe 20

Lingura oscilanta Cormoran Toro UL4 2.5cm 1.6g Farbe 20

f.50.88420

Livrare 24-48 ore

16,14Lei(-33%) 10,84Lei

Vobler Cormoran Cor SLS2 Hot Ayu, 3.5cm, 2.0g, 1buc/pac

Vobler Cormoran Cor SLS2 Hot Ayu, 3.5cm, 2.0g, 1buc/pac

f3.53.04464

Livrare 24-48 ore

26,77Lei

AGRAFA+VARTEJ CORMORAN NR.10 / 30KG / 7BUC/PLIC

AGRAFA+VARTEJ CORMORAN NR.10 / 30KG / 7BUC/PLIC

a7.80.00010

Livrare imediată!

7,25Lei

SET TEAM CORMORAN 3PCS. MANUSA+CUTIT+ASCUTITOR

SET TEAM CORMORAN 3PCS. MANUSA+CUTIT+ASCUTITOR

h.c.82.11000

Livrare imediată!

111,90Lei

Vobler Cormoran Minnow N35 Dying Roach 8.5cm, 7g

Vobler Cormoran Minnow N35 Dying Roach 8.5cm, 7g

f3.53.001857

Livrare 24-48 ore

37,52Lei(-27%) 27,26Lei

|<
<
6
7
8
9
10
11
12
13
14
>
>|

Afişare 201 - 220 din 279 (14 pagini)

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

1 (0.080)

SELECT data
FROM `oc_session`
WHERE session_id = '92be6cbd7e1ceb5671ecec92b9'

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

2 (0.081)

SELECT `trigger`, `action`
FROM oc_event

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

3 (0.115)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Cormoran'

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

4 (0.129)

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

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

5 (34.758)

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

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

6 (44.513)

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

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

7 (0.128)

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