Rapala

Sortare după:

Ochelari Polarizati Rapala Precision Vision Gear, Luiza Grey

evg-608bm

Livrare 48-72ore

629,00Lei

Vobler, Rapala, Precision, Xtreme, Pencil, Freshwater, PXRP127, AYU,, 12.7cm,, 26g, pxrp127 ayu, Voblere Floating, Voblere Floating Rapala, Rapala

pxrp127 ayu

Livrare 48-72ore

59,00Lei

, Vobler, Rapala, BX, Skitter, Frog, 5.5cm/13g,, culoare, Live, Leopard, Frog, bxsf05 lfl, Voblere Floating, Voblere Floating Rapala, Rapala

bxsf05 lfl

Livrare 48-72ore

62,00Lei

Lingurita Oscilanta Rapala Kallan, Purple Tiger 11cm, 26g

kal26 pt

Livrare 48-72ore

69,00Lei

Lingura Oscilanta Rapala Nauvo Live Herring 6.6cm 19g

nav19 hrl

Livrare 48-72ore

43,99Lei

Cutie Accesorii Rapala Tackle Tray 2760F RTT276OF

rtt276of

Livrare 48-72ore

79,00Lei

, Vobler, Rapala, BX, Skitter, Frog, BXSF04, NIA, 4.5cm,, 7.5g, bxsf04 nia, Voblere Floating, Voblere Floating Rapala, Rapala

bxsf04 nia

Livrare 48-72ore

59,00Lei

Vobler, Rapala, Precision, Xtreme, Pencil, Freshwater, PXRP107, EB,, 10.7cm,, 21g, pxrp107 eb, Voblere Floating, Voblere Floating Rapala, Rapala

pxrp107 eb

Livrare 48-72ore

57,00Lei

Vobler Rapala Precision Extreme Mavrik Custom, BBZ, 14g, 11cm

pxrmc110 bbz

Livrare 48-72ore

79,00Lei

VOBLER RAPALA X-RAP OTUS 17CM 40G OG

xrou17 og

Livrare imediată!

84,00Lei

Vobler Rapala Countdown Elite Gilded Gold Shad 5.5cm 5g

cde55 gdgs

Livrare imediată!

67,00Lei

, Vobler, Rapala, X-Light, Crank, Shallow, Runner, FNCS03, GFR,, 3.5cm,, 4g, fncs03 gfr, Voblere Floating, Voblere Floating Rapala, Rapala

fncs03 gfr

Livrare 48-72ore

42,00Lei

Vobler, Rapala, Precision, Xtreme, Pencil, Freshwater, PXRP87, CLN,, 8.7cm,, 12g, pxrp87 cln, Voblere Floating, Voblere Floating Rapala, Rapala

pxrp87 cln

Livrare 48-72ore

54,00Lei

Vobler Rapala Jack Deep, HAY, 10g, 7cm

sdrjd07 hh

Livrare 48-72ore

62,00Lei

VOBLER RAPALA SHAD DANCER 7 cm 15 g DCW

sdd07 dcw

Livrare 48-72ore

49,00Lei

Waders Rapala X-Protect, marimea L

23730-1(l)

Livrare 48-72ore

999,01Lei

Lingurita Oscilanta Rapala Harmaja, Halloween 11.6cm, 31g

har31 hlw

Livrare 48-72ore

49,00Lei

Vobler Rapala X-Rap, Culoare PG, 6cm, 4g

xr06 pg

Livrare imediată!

51,00Lei

Lingura Oscilanta Rapala Nauvo Stickleback 9.5cm 37g

nav37 stb

Livrare 48-72ore

49,00Lei

Ochelari Polarizati Rapala Precision Vision Gear, Brehat Grey

evg-910bm

Livrare 48-72ore

629,00Lei

Afişare 141 - 160 din 990 (50 pagini)

Queries: 36, Total time: 86.917 ms [By time] [By id] [By file]

1 (0.084)

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

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

2 (0.076)

SELECT *
FROM oc_platforma_promovari LIMIT 1

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

3 (0.094)

SELECT `trigger`, `action`
FROM oc_event

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

4 (0.111)

SELECT *
FROM oc_url_alias
WHERE keyword = 'Rapala'

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

5 (0.111)

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

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

6 (35.490)

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

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

7 (46.464)

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

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

8 (0.648)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '170534' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'

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

9 (0.173)

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '170534' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

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

10 (0.189)

SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '170534' AND a.attribute_group_id = '16' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

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

11 (0.076)

SELECT *
FROM oc_product_image
WHERE product_id = '170534'
ORDER BY sort_order ASC

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

12 (0.557)

SELECT DISTINCT *, p.product_id, pd.name AS name, p.image, m.name AS manufacturer, (SELECT p2sb.product_id
FROM oc_product_to_store p2sb
WHERE p2sb.product_id = p.product_id AND p2sb.store_id = '1') AS blackfriday, (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, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (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 COUNT(1) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
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)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN (SELECT os.product_id, os.magazin AS comenzi_magazin, os.online AS comenzi_online
FROM oc_order_stoc os GROUP BY os.product_id) opp ON (opp.product_id = p.product_id)
WHERE p.product_id = '219144' AND pd.language_id = '2' AND p.status = '1' AND p.price > '0' AND p2s.store_id = '0'

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

13 (0.163)

SELECT ag.attribute_group_id, agd.name
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id)
LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id)
WHERE pa.product_id = '219144' AND agd.language_id = '2' AND ag.attribute_group_id NOT IN (54) GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name

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

14 (0.159)

SELECT a.attribute_id, a.arata, ad.name, pa.text
FROM oc_product_attribute pa
LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id)
LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id)
WHERE pa.product_id = '219144' AND a.attribute_group_id = '23' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name

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

15 (0.105)

SELECT *
FROM oc_product_image
WHERE product_id = '219144'
ORDER BY sort_order ASC

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

16 (0.079)

SELECT *
FROM oc_stock_status
WHERE furnizor LIKE '%"RAPALA VMC ROMANIA SRL"%' AND language_id = '2'