Pentru o livrare cat mai rapida va recomandam sa alegeti produse cu stoc in Magazin fizic si in Depozit Online. Produsele cu Stoc furnizor au termen de livrare mai mare si pot intarzia comanda dvs.
articole de pescuit Gama variata de produse

La Claumar Pescar poti alege simplu si rapid dintr-o gama variata de articole de pescuit.

transport gratuit Transport Gratuit

Comenzile peste 300 lei pot beneficia de transport gratuit.

Vezi mai multe detalii

plata in rate Plata cu cardul

Plata cu cardul in rate fara dobanda.

Vezi mai multe detalii

suport Suport 10-18

Suportul telefonic este 10-18. Orice intrebare ai avea, stim ca nu poate astepta. Apeleaza serviciul Suport 10-18! Un consultant asteapta sa iti preia apelul in intervalul orar 10-18 de luni pana vineri.

Vezi mai multe detalii

returnare Returnare simplu in 14 zile

Retur simplu in 14 zile.

Vezi mai multe detalii

Vobler Rapala X-rap Jointed Shad, 13cm, 46g, Gold

  • Producător: Rapala
  • Cod produs: xjs13 g
  • Disponibilitate: Exclusiv Online(Livrare48-72ore)

79,00Lei

Stoc Magazin fizicStoc Depozit ClaumarStoc Furnizor
Alertă preț!
 0725894115

0 opinii / Spune-ţi opinia

Produse Similare
Vobler Rapala X-Rap Peto, Culoare ARB, 14cm, 39g

Vobler Rapala X-Rap Peto, Culoare ARB, 14cm, 39g

84,00Lei

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

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

51,00Lei

COADA DE REZERVA VOBLER RAPALA X-RAP PETO SPARE TAIL CULOARE PEL 3BUC/BLISTER
VOBLER RAPALA X-RAP

VOBLER RAPALA X-RAP

59,00Lei

Vobler Rapala X-Rap 10 XR10 ROL

Vobler Rapala X-Rap 10 XR10 ROL

59,00Lei

VOBLER RAPALA X-RAP 10CM SFCU

VOBLER RAPALA X-RAP 10CM SFCU

59,00Lei

Vobler Rapala X-Rap 3x Minnow SXRM10 YG

Vobler Rapala X-Rap 3x Minnow SXRM10 YG

59,00Lei

Vobler Rapala X-Rap 6cm/4gr. CLN

Vobler Rapala X-Rap 6cm/4gr. CLN

51,00Lei

Vobler Rapala X-Rap 6cm/4gr. GGH

Vobler Rapala X-Rap 6cm/4gr. GGH

51,00Lei

Vobler Rapala X-Rap 6cm/4gr. S

Vobler Rapala X-Rap 6cm/4gr. S

51,00Lei

Vobler Rapala X-Rap 6cm/4gr. SB

Vobler Rapala X-Rap 6cm/4gr. SB

51,00Lei

Vobler Rapala X-Rap 8cm 7gr. OG

Vobler Rapala X-Rap 8cm 7gr. OG

55,00Lei

VOBLER RAPALA X-RAP 8CM FTU

VOBLER RAPALA X-RAP 8CM FTU

55,00Lei

VOBLER RAPALA X-RAP COUNTDOWN 5CM / 4GR GGH

VOBLER RAPALA X-RAP COUNTDOWN 5CM / 4GR GGH

52,00Lei

VOBLER RAPALA X-RAP COUNTDOWN 5CM / 4GR S

VOBLER RAPALA X-RAP COUNTDOWN 5CM / 4GR S

52,00Lei

VOBLER RAPALA X-RAP COUNTDOWN 7CM / 10GR GGH

VOBLER RAPALA X-RAP COUNTDOWN 7CM / 10GR GGH

55,00Lei

Vobler Rapala X-Rap Countdown Culoare FTU 7cm 10g

Vobler Rapala X-Rap Countdown Culoare FTU 7cm 10g

55,00Lei

Vobler Rapala X-Rap Countdown Culoare OG 7cm 10g

Vobler Rapala X-Rap Countdown Culoare OG 7cm 10g

55,00Lei

Vobler Rapala X-Rap Countdown Culoare RTL 5cm 4g

Vobler Rapala X-Rap Countdown Culoare RTL 5cm 4g

52,00Lei

Vobler Rapala X-Rap Countdown Culoare RTL 7cm 10g

Vobler Rapala X-Rap Countdown Culoare RTL 7cm 10g

55,00Lei

Vobler Rapala X-Rap Countdown Culoare TRL 5cm 4g

Vobler Rapala X-Rap Countdown Culoare TRL 5cm 4g

52,00Lei

Vobler Rapala X-Rap Countdown Culoare TRL 7cm 10g

Vobler Rapala X-Rap Countdown Culoare TRL 7cm 10g

55,00Lei

Vobler Rapala X-Rap Culoare MD 8cm 7g

Vobler Rapala X-Rap Culoare MD 8cm 7g

55,00Lei

Vobler Rapala X-Rap Culoare P 10cm 13g

Vobler Rapala X-Rap Culoare P 10cm 13g

59,00Lei

Vobler Rapala X-Rap Culoare PEL 6cm 4g

Vobler Rapala X-Rap Culoare PEL 6cm 4g

51,00Lei

Vobler Rapala X-Rap Culoare RTL 4cm 2g

Vobler Rapala X-Rap Culoare RTL 4cm 2g

51,00Lei

Vobler Rapala X-Rap Culoare SB 8cm 7g

Vobler Rapala X-Rap Culoare SB 8cm 7g

55,00Lei

VOBLER RAPALA X-RAP JOINTED SHAD 13GR FT

VOBLER RAPALA X-RAP JOINTED SHAD 13GR FT

79,00Lei

VOBLER RAPALA X-RAP JOINTED SHAD 13GR PK

VOBLER RAPALA X-RAP JOINTED SHAD 13GR PK

79,00Lei

VOBLER RAPALA X-RAP JOINTED SHAD CULOARE BSD 13CM 46G

VOBLER RAPALA X-RAP JOINTED SHAD CULOARE BSD 13CM 46G

79,00Lei

Vobler Rapala X-Rap Jointed Shad Culoare P 13cm 46g

Vobler Rapala X-Rap Jointed Shad Culoare P 13cm 46g

79,00Lei

VOBLER RAPALA X-RAP JOINTED SHAD CULOARE PEL 13CM 46G

VOBLER RAPALA X-RAP JOINTED SHAD CULOARE PEL 13CM 46G

79,00Lei

VOBLER RAPALA X-RAP OTUS 17CM 40G OG

VOBLER RAPALA X-RAP OTUS 17CM 40G OG

84,00Lei

VOBLER RAPALA X-RAP OTUS 17CM 40G SCRB

VOBLER RAPALA X-RAP OTUS 17CM 40G SCRB

84,00Lei

VOBLER RAPALA X-RAP OTUS CULOARE ARB 25CM 90G

VOBLER RAPALA X-RAP OTUS CULOARE ARB 25CM 90G

99,00Lei

VOBLER RAPALA X-RAP OTUS CULOARE HLW 25CM 90G

VOBLER RAPALA X-RAP OTUS CULOARE HLW 25CM 90G

99,00Lei

VOBLER RAPALA X-RAP OTUS CULOARE HTP 17CM 40G

VOBLER RAPALA X-RAP OTUS CULOARE HTP 17CM 40G

84,00Lei

VOBLER RAPALA X-RAP OTUS CULOARE MRC 17CM 40G

VOBLER RAPALA X-RAP OTUS CULOARE MRC 17CM 40G

84,00Lei

VOBLER RAPALA X-RAP OTUS CULOARE MRC 25CM 90G

VOBLER RAPALA X-RAP OTUS CULOARE MRC 25CM 90G

99,00Lei

VOBLER RAPALA X-RAP OTUS CULOARE OG 25CM 90G

VOBLER RAPALA X-RAP OTUS CULOARE OG 25CM 90G

99,00Lei

VOBLER RAPALA X-RAP OTUS CULOARE PEL 17CM 40G

VOBLER RAPALA X-RAP OTUS CULOARE PEL 17CM 40G

84,00Lei

VOBLER RAPALA X-RAP OTUS CULOARE PEL 25CM 90G

VOBLER RAPALA X-RAP OTUS CULOARE PEL 25CM 90G

99,00Lei

VOBLER RAPALA X-RAP OTUS CULOARE PGG 17CM 40G

VOBLER RAPALA X-RAP OTUS CULOARE PGG 17CM 40G

84,00Lei

VOBLER RAPALA X-RAP OTUS CULOARE SCRR 25CM 90G

VOBLER RAPALA X-RAP OTUS CULOARE SCRR 25CM 90G

99,00Lei

Vobler Rapala X-Rap Otus Whitefish 17cm 40g

Vobler Rapala X-Rap Otus Whitefish 17cm 40g

84,00Lei

VOBLER RAPALA X-RAP PETO 14CM 39G RTL

VOBLER RAPALA X-RAP PETO 14CM 39G RTL

84,00Lei

VOBLER RAPALA X-RAP PETO 14CM 39G SCRB

VOBLER RAPALA X-RAP PETO 14CM 39G SCRB

84,00Lei

VOBLER RAPALA X-RAP PETO 14CM 39G SIIK

VOBLER RAPALA X-RAP PETO 14CM 39G SIIK

84,00Lei

VOBLER RAPALA X-RAP PETO 14CM 39G UV5

VOBLER RAPALA X-RAP PETO 14CM 39G UV5

84,00Lei

VOBLER RAPALA X-RAP PETO BLUE GHOST 20CM 83G

VOBLER RAPALA X-RAP PETO BLUE GHOST 20CM 83G

99,00Lei

VOBLER RAPALA X-RAP PETO CULOARE ARB 14CM 39G

VOBLER RAPALA X-RAP PETO CULOARE ARB 14CM 39G

84,00Lei

VOBLER RAPALA X-RAP PETO CULOARE HTIP 14CM 39G

VOBLER RAPALA X-RAP PETO CULOARE HTIP 14CM 39G

84,00Lei

VOBLER RAPALA X-RAP PETO CULOARE HTP 14CM 39G

VOBLER RAPALA X-RAP PETO CULOARE HTP 14CM 39G

84,00Lei

VOBLER RAPALA X-RAP PETO CULOARE OG 14CM 39G

VOBLER RAPALA X-RAP PETO CULOARE OG 14CM 39G

84,00Lei

VOBLER RAPALA X-RAP PETO CULOARE PCK 14CM 39G

VOBLER RAPALA X-RAP PETO CULOARE PCK 14CM 39G

84,00Lei

VOBLER RAPALA X-RAP PETO CULOARE PEL 14CM 39G

VOBLER RAPALA X-RAP PETO CULOARE PEL 14CM 39G

84,00Lei

VOBLER RAPALA X-RAP PETO CULOARE ROL 14CM 39G

VOBLER RAPALA X-RAP PETO CULOARE ROL 14CM 39G

84,00Lei

VOBLER RAPALA X-RAP PETO CULOARE SCRR 14CM 39G

VOBLER RAPALA X-RAP PETO CULOARE SCRR 14CM 39G

84,00Lei

VOBLER RAPALA X-RAP PETO CULOARE SMB 14CM 39G

VOBLER RAPALA X-RAP PETO CULOARE SMB 14CM 39G

84,00Lei

VOBLER RAPALA X-RAP PETO CULOARE TWZ 14CM 39G

VOBLER RAPALA X-RAP PETO CULOARE TWZ 14CM 39G

84,00Lei

VOBLER RAPALA X-RAP PETO LIVE PERCH 20CM 83G

VOBLER RAPALA X-RAP PETO LIVE PERCH 20CM 83G

99,00Lei

VOBLER RAPALA X-RAP S

VOBLER RAPALA X-RAP S

55,00Lei

Vobler Rapala X-Rap Saltwater Subwalk Culoare BNC 7cm 13g

Vobler Rapala X-Rap Saltwater Subwalk Culoare BNC 7cm 13g

65,00Lei

Vobler Rapala X-Rap Saltwater Subwalk Culoare GO 7cm 13g

Vobler Rapala X-Rap Saltwater Subwalk Culoare GO 7cm 13g

65,00Lei

Vobler Rapala X-Rap Saltwater Subwalk Culoare GO 9cm 20g

Vobler Rapala X-Rap Saltwater Subwalk Culoare GO 9cm 20g

71,00Lei

Vobler Rapala X-Rap Saltwater Subwalk Culoare MBS 7cm 13g

Vobler Rapala X-Rap Saltwater Subwalk Culoare MBS 7cm 13g

65,00Lei

Vobler Rapala X-Rap Saltwater Subwalk Culoare MBS 9cm 20g

Vobler Rapala X-Rap Saltwater Subwalk Culoare MBS 9cm 20g

71,00Lei

Vobler Rapala X-Rap Saltwater Subwalk Culoare OG 9cm 20g

Vobler Rapala X-Rap Saltwater Subwalk Culoare OG 9cm 20g

71,00Lei

Vobler Rapala X-Rap Saltwater Subwalk Culoare PF 7cm 13g

Vobler Rapala X-Rap Saltwater Subwalk Culoare PF 7cm 13g

65,00Lei

Vobler Rapala X-Rap Saltwater Subwalk Culoare PF 9cm 20g

Vobler Rapala X-Rap Saltwater Subwalk Culoare PF 9cm 20g

71,00Lei

Vobler Rapala X-Rap Saltwater SubWalk SXRSB09 9cm 20g Silver

Vobler Rapala X-Rap Saltwater SubWalk SXRSB09 9cm 20g Silver

71,00Lei

VOBLER RAPALA X-RAP SCOOP CULOARE UV5 14CM 68G

VOBLER RAPALA X-RAP SCOOP CULOARE UV5 14CM 68G

73,99Lei

VOBLER RAPALA X-RAP SHAD SHALLOW CULOARE G 6CM 9G

VOBLER RAPALA X-RAP SHAD SHALLOW CULOARE G 6CM 9G

59,00Lei

Vobler Rapala X-Rap Twitchin Minnow Culoare BNC 10cm 14g

Vobler Rapala X-Rap Twitchin Minnow Culoare BNC 10cm 14g

61,00Lei

Vobler Rapala X-Rap Twitchin Minnow Culoare BNC 12cm 26g

Vobler Rapala X-Rap Twitchin Minnow Culoare BNC 12cm 26g

63,00Lei

Vobler Rapala X-Rap Twitchin Minnow Culoare FUS 10cm 14g

Vobler Rapala X-Rap Twitchin Minnow Culoare FUS 10cm 14g

61,00Lei

Vobler Rapala X-Rap Twitchin Minnow Culoare FUS 12cm 26g

Vobler Rapala X-Rap Twitchin Minnow Culoare FUS 12cm 26g

63,00Lei

Vobler Rapala X-Rap Twitchin Minnow Culoare GO 10cm 14g

Vobler Rapala X-Rap Twitchin Minnow Culoare GO 10cm 14g

61,00Lei

Vobler Rapala X-Rap Twitchin Minnow Culoare GO 12cm 26g

Vobler Rapala X-Rap Twitchin Minnow Culoare GO 12cm 26g

63,00Lei

Vobler Rapala X-Rap Twitchin Minnow Culoare OG 10cm 14g

Vobler Rapala X-Rap Twitchin Minnow Culoare OG 10cm 14g

61,00Lei

Vobler Rapala X-Rap Twitchin Minnow Culoare OG 12cm 26g

Vobler Rapala X-Rap Twitchin Minnow Culoare OG 12cm 26g

63,00Lei

Vobler Rapala X-Rap Twitchin Minnow Culoare S 10cm 14g

Vobler Rapala X-Rap Twitchin Minnow Culoare S 10cm 14g

61,00Lei

Vobler Rapala X-Rap Twitchin Mullet Culoare FUS 8cm 13g

Vobler Rapala X-Rap Twitchin Mullet Culoare FUS 8cm 13g

64,00Lei

Vobler Rapala X-Rap Twitchin Mullet Culoare MBS 8cm 13g

Vobler Rapala X-Rap Twitchin Mullet Culoare MBS 8cm 13g

64,00Lei

Vobler Rapala X-Rap Twitchin Mullet Culoare OG 8cm 13g

Vobler Rapala X-Rap Twitchin Mullet Culoare OG 8cm 13g

64,00Lei

Vobler Rapala X-Rap Twitchin Mullet Culoare PF 8cm 13g

Vobler Rapala X-Rap Twitchin Mullet Culoare PF 8cm 13g

64,00Lei

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE FT 8CM 13G

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE FT 8CM 13G

54,00Lei

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE GGIU 8CM 13G

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE GGIU 8CM 13G

54,00Lei

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE HLW 8CM 13G

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE HLW 8CM 13G

54,00Lei

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE MRC 8CM 13G

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE MRC 8CM 13G

54,00Lei

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE PEL 8CM 13G

VOBLER RAPALA X-RAP TWITCHIN SHAD CULOARE PEL 8CM 13G

54,00Lei

VOBLER RAPALA YP X-RAP SHAD

VOBLER RAPALA YP X-RAP SHAD

62,00Lei

Afişare 136 - 15 din 15 (1 pagini)
Descriere

Vobler Rapala X-Rap Jointed Shad, 13cm, 46g, Gold


Rapala X-Rap Jointed Shad este un vobler de tip swimbait, foarte receptiv la actiunea varfului lansetei.
Este un vobler versatil ce se poate adapta la o varietate de stiluri, fiind o alegere excelenta pentru pescuitul in locuri cu obstacole submerse, datorita mobilitatii iesite din comun.
Voblerul dispune de calitatile premium ale liniei X-Rap, are o adancime de evolutie de maximum 2.4m, iar actiunea sa lenta si seducatoare declanseaza atacul rapitorilor. Corpul fabricat din material rezistent la muscaturile pestilor, ochii 3D si doua ancore nr.2/0 VMC Black Nickel, completeaza echiparea de top a modelului X-Rap Jointed Shad. Lungimea de 13cm recomanda aceasta naluca in special pentru pescuitul salaului, stiucii si al somnului.

  • Ochi 3D holografic
  • 2x Ancore VMC Black Nickel, nr.2/0

Caracteristici
Tip Naluca Swimbait
Model X-Rap Jointed Shad
Lungime (cm) 13
Greutate (g) 46 g
Tip Evolutie Suspending
Adancime Evolutie (m) 1.2 - 2.4m
Culoare Multicolor
Material Plastic
Barbeta Da
Articulat Da
Nr. Ancore 2
Marime Ancore 2/0
Nr. Buc/Pac 1
Review-uri (0 de review-uri)
0
0 de review-uri
5 stele
0
4 stele
0
3 stele
0
2 stele
0
1 stea
0

0

Achizitie verificata

0%

Reviews pozitive

Detii sau ai utilizat produsul?
Spune-ti parerea acordand o nota produsului
Spune-ţi opinia
Adauga un review
Spune-ţi opinia

Linkuri utile: Vobler Rapala X-Rap Jointed Shad 13cm 46g Gold xjs13 g Voblere Suspending Voblere Suspending Rapala Rapala

Queries: 45, Total time: 214.907 ms [By time] [By id] [By file]
1 (0.102)
SELECT data
FROM `oc_session`
WHERE session_id = '09bea460131e388b51a8305c55'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.106)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.120)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/clients/client1/web1/web/index.php:313
4 (0.096)
SELECT *
FROM oc_currency
/var/www/clients/client1/web1/web/system/library/currency.php:17
5 (0.220)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:32
6 (0.167)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/var/www/clients/client1/web1/web/system/library/tax.php:60
7 (0.128)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/var/www/clients/client1/web1/web/system/library/weight.php:12
8 (0.123)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/var/www/clients/client1/web1/web/system/library/length.php:12
9 (0.055)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:414
10 (0.085)
SELECT *
FROM oc_url_alias
WHERE keyword = 'vobler-rapala-x-rap-jointed-shad,-13cm,-46g,-gold.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
11 (0.114)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '177533' LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1516
12 (0.122)
SELECT cp.*
FROM oc_category c JOIN oc_category_path cp ON (c.category_id = cp.category_id)
LEFT JOIN oc_category_path l ON (c.category_id = l.category_id AND c.category_id = l.path_id)
WHERE c.category_id = '414'
ORDER BY cp.level ASC, c.sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1519
13 (0.124)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '220' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:22
14 (0.158)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '355' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:22
15 (0.158)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '414' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:22
16 (0.083)
SELECT *
FROM `oc_module`
WHERE `code` = 'similar_products'
ORDER BY `name`
/var/www/clients/client1/web1/web/catalog/model/extension/module.php:5
17 (0.112)
SELECT *
FROM `oc_product_locatie`
WHERE product_id = '177533' AND baza_date LIKE 'magazin_ffb'
ORDER BY LENGTH(camera), camera ASC, LENGTH(rand), rand ASC, LENGTH(raft), raft ASC, LENGTH(alveola), alveola ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:20
18 (0.091)
SELECT *
FROM `oc_product_locatie`
WHERE product_id = '177533' AND baza_date LIKE 'magazin_claumar'
ORDER BY LENGTH(camera), camera ASC, LENGTH(rand), rand ASC, LENGTH(raft), raft ASC, LENGTH(alveola), alveola ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:20
19 (0.077)
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.106)
SELECT COUNT(1) AS total, rating
FROM `oc_review`
WHERE `product_id` = '177533' AND status=1 GROUP BY rating
ORDER BY rating ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/review.php:125
21 (0.088)
SELECT COUNT(1) AS total
FROM `oc_review`
WHERE `product_id` = '177533' AND status=1 AND verificat = '1' GROUP BY product_id
/var/www/clients/client1/web1/web/catalog/model/catalog/review.php:134
22 (0.150)
SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added, r.verificat, r.apreciat, r.depreciat
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '177533' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
ORDER BY r.date_added DESC LIMIT 0,100
/var/www/clients/client1/web1/web/catalog/model/catalog/review.php:170
23 (0.254)
SELECT *
FROM oc_product_related pr
LEFT JOIN oc_product p ON (pr.related_id = p.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pr.product_id = '177533' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1392
24 (0.117)
SELECT `pd`.*
FROM `oc_product_recurring` `pp` JOIN `oc_recurring_description` `pd` ON `pd`.`language_id` = 2 AND `pd`.`recurring_id` = `pp`.`recurring_id` JOIN `oc_recurring` `p` ON `p`.`recurring_id` = `pd`.`recurring_id`
WHERE `product_id` = 177533 AND `status` = 1 AND `customer_group_id` = 1
ORDER BY `sort_order` ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1657
25 (0.139)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
26 (0.124)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
27 (0.127)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
28 (0.123)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
29 (0.182)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '1' AND `date_available` <= NOW() AND `customer_type` = 0 AND `products_show` LIKE '%"177533"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
30 (0.165)
SELECT *
FROM `oc_pb_bundles`
WHERE `products` != '' AND `status`= '1' AND type = '0' AND `date_available` <= NOW() AND `customer_type` = 0 AND `products_show` LIKE '%"177533"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
31 (0.103)
SELECT *
FROM oc_module
WHERE module_id = '31'
/var/www/clients/client1/web1/web/catalog/model/extension/module.php:11
32 (0.159)
SELECT *
FROM oc_product
WHERE product_id = '177533'
/var/www/clients/client1/web1/web/catalog/model/module/similar_products.php:92
33 (209.355)
SELECT SQL_CALC_FOUND_ROWS *
FROM ((SELECT p.product_id, pd.name
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id AND pd.language_id = '2')
WHERE p.product_id <> '177533' AND p.status = '1' AND p.date_available <= NOW() AND (pd.name LIKE '%Vobler%' AND pd.name LIKE '%Rapala%' AND pd.name LIKE '%X-Rap%') AND p.quantity > '0')) AS tbl
ORDER BY name ASC
/var/www/clients/client1/web1/web/catalog/model/module/similar_products.php:387
34 (0.223)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
35 (0.142)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
36 (0.065)
SELECT *
FROM oc_module
WHERE module_id = '1218'
/var/www/clients/client1/web1/web/catalog/model/extension/module.php:11
37 (0.095)
SELECT *
FROM oc_module
WHERE module_id = '1190'
/var/www/clients/client1/web1/web/catalog/model/extension/module.php:11
38 (0.097)
SELECT *
FROM oc_module
WHERE module_id = '1221'
/var/www/clients/client1/web1/web/catalog/model/extension/module.php:11
39 (0.158)
SELECT *
FROM oc_banner_image bi
LEFT JOIN oc_banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id)
WHERE bi.banner_id = '24' AND bid.language_id = '2'
ORDER BY bi.sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/design/banner.php:4
40 (0.100)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
41 (0.127)
SELECT layout_id
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:4
42 (0.120)
SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/clients/client1/web1/web/catalog/model/design/layout.php:14
43 (0.131)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
44 (0.113)
SELECT *
FROM `oc_mxt_setting`
WHERE store_id = '0' AND name = 'lichidare_stoc'
/var/www/clients/client1/web1/web/catalog/model/catalog/category.php:32
45 (0.104)
SELECT *
FROM oc_module
WHERE module_id = '1192'
/var/www/clients/client1/web1/web/catalog/model/extension/module.php:11