Relax


STRUNA RELAX SURFLON MICRO ULTRA BLACK 3buc/plic 21kg 30cm

STRUNA RELAX SURFLON MICRO ULTRA BLACK 3buc/plic 21kg 30cm

rla19b-30c21t
Livrare imediată!

30,00Lei

Turbo Twister Relax 6.5cm Laminat Blister TL007

Turbo Twister Relax 6.5cm Laminat Blister TL007

trt3-tl007-b
Livrare imediată!

6,00Lei

SHAD, RELAX, TEXAS, LAMINAT, L059, 10CM, 4buc/plic, tx4-l059-b, Shad-uri, Shad-uri Relax, Relax

SHAD, RELAX, TEXAS, LAMINAT, L059, 10CM, 4buc/plic, tx4-l059-b, Shad-uri, Shad-uri Relax, Relax

tx4-l059-b
Livrare imediată!

9,00Lei

SHAD, RELAX, TEXAS, LAMINAT, S093, 10CM, 4BUC/PLIC, tx4-s093-b, Shad-uri, Shad-uri Relax, Relax

SHAD, RELAX, TEXAS, LAMINAT, S093, 10CM, 4BUC/PLIC, tx4-s093-b, Shad-uri, Shad-uri Relax, Relax

tx4-s093-b
Livrare 48-72ore

9,00Lei

Shad, Relax, Kopyto, Tiger, TG002, 6.2cm, 4buc/plic, bls25-tg002-b, Shad-uri, Shad-uri Relax, Relax

Shad, Relax, Kopyto, Tiger, TG002, 6.2cm, 4buc/plic, bls25-tg002-b, Shad-uri, Shad-uri Relax, Relax

bls25-tg002-b
Livrare 48-72ore

9,00Lei

Grub, Relax, Turbo, Twister, Laminat, TL021,, 11cm,, 4buc/pac, trt5-tl021-b, Grub-uri, Grub-uri Relax, Relax
Shad, Relax, Stinger, Standard, SS017,, 5cm,, 1g,, 8buc/plic, ss2-ss017-b, Shad-uri, Shad-uri Relax, Relax

Shad, Relax, Stinger, Standard, SS017,, 5cm,, 1g,, 8buc/plic, ss2-ss017-b, Shad-uri, Shad-uri Relax, Relax

ss2-ss017-b
Livrare imediată!

11,00Lei

Grub, Relax, Turbo, Twister, Standard, TS422,, 11cm,, 8g,, 4buc/pac, trt5-ts422-b, Grub-uri, Grub-uri Relax, Relax
Shad, Relax, Lures, KOPYTO, Tiger,, TG029,, 7.5cm,, 7.0g,, 4buc/pac, bls3-tg029-b, Shad-uri, Shad-uri Relax, Relax
BILE TUNGSTEN SLOTTED BEADS 2.8MM FLUO YELLOW 10 buc/plic

BILE TUNGSTEN SLOTTED BEADS 2.8MM FLUO YELLOW 10 buc/plic

tsb28-fy
Livrare 48-72ore

7,00Lei

STRUNA RELAX SURFLON MICRO ULTRA BLACK 3buc/plic 12kg 35cm

STRUNA RELAX SURFLON MICRO ULTRA BLACK 3buc/plic 12kg 35cm

rla19b-35c12t
Livrare 48-72ore

31,00Lei

Turbo, Twister, Relax, 6.5cm, Standard, Blister, TS215, trt3-ts215-b, Grub-uri, Grub-uri Relax, Relax -25%

Turbo, Twister, Relax, 6.5cm, Standard, Blister, TS215, trt3-ts215-b, Grub-uri, Grub-uri Relax, Relax

trt3-ts215-b
Livrare imediată!

6,00Lei(-25%) 4,50Lei

SHAD, RELAX, TEXAS, LAMINAT, L017, 10CM, 4buc/plic, tx4-l017-b, Shad-uri, Shad-uri Relax, Relax

SHAD, RELAX, TEXAS, LAMINAT, L017, 10CM, 4buc/plic, tx4-l017-b, Shad-uri, Shad-uri Relax, Relax

tx4-l017-b
Livrare imediată!

9,00Lei

SHAD, RELAX, TEXAS, LAMINAT, L658, 10CM, 4buc/plic, tx4-l658-b, Shad-uri, Shad-uri Relax, Relax

SHAD, RELAX, TEXAS, LAMINAT, L658, 10CM, 4buc/plic, tx4-l658-b, Shad-uri, Shad-uri Relax, Relax

tx4-l658-b
Livrare imediată!

9,00Lei

TWISTER RELAX STANDARD TS011 3CM 8BUC/PLIC -25%

TWISTER RELAX STANDARD TS011 3CM 8BUC/PLIC

vr34-ts011-b
Livrare imediată!

6,00Lei(-25%) 4,50Lei

Shad Relax Texas Laminated 6.5cm L318 4buc/plic -33%

Shad Relax Texas Laminated 6.5cm L318 4buc/plic

tx25-l318-b
Livrare imediată!

9,00Lei(-33%) 6,00Lei

Shad, Relax, Kopyto, Floating, F056, 6.2cm, 4buc/plic, bls25-f056-b, Shad-uri, Shad-uri Relax, Relax

Shad, Relax, Kopyto, Floating, F056, 6.2cm, 4buc/plic, bls25-f056-b, Shad-uri, Shad-uri Relax, Relax

bls25-f056-b
Livrare 48-72ore

9,00Lei

Shad Relax Stinger Standard SS006, 5cm, 1g, 8buc/plic

Shad Relax Stinger Standard SS006, 5cm, 1g, 8buc/plic

ss2-ss006-b
Livrare imediată!

11,00Lei

Grub Relax Turbo Twister Standard TS018, 11cm, 8g, 4buc/pac

Grub Relax Turbo Twister Standard TS018, 11cm, 8g, 4buc/pac

trt5-ts018-b
Livrare imediată!

8,00Lei

Shad, Relax, Lures, KOPYTO, Floating,, F002,, 7.5cm,, 6.5g,, 4buc/pac, bls3-f002-b, Shad-uri, Shad-uri Relax, Relax
Afişare 1 - 20 din 1424 (72 pagini)
Queries: 18, Total time: 93.136 ms [By time] [By id] [By file]
1 (0.112)
SELECT data
FROM `oc_session`
WHERE session_id = '020357628953c2107b4dba9302'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.073)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.121)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:422
4 (0.139)
SELECT *
FROM oc_url_alias
WHERE keyword = 'relax.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
5 (0.132)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '48' AND m2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
6 (37.115)
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 = '48'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1650
7 (54.410)
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, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, p.viewed, p.price
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 = '48' 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:432
8 (0.102)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.086)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.079)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.079)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
12 (0.082)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
13 (0.078)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
14 (0.101)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
15 (0.104)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
16 (0.099)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"TACKLE SHOP ARENA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
17 (0.124)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
18 (0.100)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:38