Rapala


63,00Lei

Vobler RAPALA X-Light Shad, PUPU, 4cm, 4g

fns04 pupu
Livrare 48-72ore

45,01Lei

39,00Lei

VOBLER RAPALA J07 FT JOINTED

j07 ft
Livrare imediată!

49,00Lei

Vobler RAPALA Flat Rap FLR08, CH, 8cm, 7g

flr08 ch
Livrare imediată!

51,00Lei

Vobler Rapala Shallow Shad Rap 5cm 5gr ALB

ssr05 alb
Livrare imediată!

47,01Lei

VOBLER RAPALA SHADOW RAP 11CM AS

sdr11 as
Livrare 48-72ore

59,00Lei

VOBLER RAPALA SHAD RAP RS 7CM CLN

srrs07 cln
Livrare 48-72ore

49,00Lei

VOBLER RAPALA HUSKY JERK 6CM / 3GR HSD

hj06 hsd
Livrare 48-72ore

42,00Lei

VOBLER RAPALA RATTLIN' 8CM / 22GR S

rnr08 s
Livrare 48-72ore

42,00Lei

359,00Lei

Aerator Rapala Automat Compact

rcddfa
Livrare 48-72ore

209,00Lei(-19%) 169,00Lei

46,01Lei

Vobler RAPALA DT04 Dives-To, PGS, 5cm, 9g

dt04 pgs
Livrare imediată!

49,00Lei

46,01Lei

54,00Lei

52,00Lei

65,00Lei

Forfecuta Rapala 13cm

rcdpls
Livrare 48-72ore

99,00Lei(-17%) 82,00Lei

61,00Lei

Afişare 901 - 920 din 1150 (58 pagini)
Queries: 21, Total time: 99.994 ms [By time] [By id] [By file]
1 (0.153)
SELECT data
FROM `oc_session`
WHERE session_id = 'd60a04266ae3eac9c3a21a13c2'
/var/www/clients/client1/web1/web/system/library/session/db.php:24
2 (0.104)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:453
3 (0.139)
SELECT *
FROM oc_url_alias
WHERE keyword = 'Rapala'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
4 (0.135)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '117' AND m2s.store_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/manufacturer.php:4
5 (42.601)
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 = '117'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1699
6 (55.177)
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 = '117' GROUP BY p.product_id
ORDER BY p.sort_order ASC LIMIT 900,20
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:440
7 (0.104)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
8 (0.120)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
9 (0.119)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
10 (0.099)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
11 (0.121)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
12 (0.118)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
13 (0.123)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
14 (0.116)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
15 (0.117)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
16 (0.117)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
17 (0.118)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
18 (0.120)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
19 (0.124)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
20 (0.071)
SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:130
21 (0.098)
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