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

Pelete Dybamite Baits Robin Red 20mm 900gr

  • Producător: Dynamite Baits
  • Cod produs: dy085
  • Disponibilitate: Exclusiv Online(Livrare48-72ore)

42,00Lei

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

1 opinii / Spune-ţi opinia

Produse Similare
Pelete de Carlig Dynamite Baits Wowsers Pink 7mm

Pelete de Carlig Dynamite Baits Wowsers Pink 7mm

28,00Lei

Pelete de Carlig Dynamite Baits Wowsers 9mm Pink

Pelete de Carlig Dynamite Baits Wowsers 9mm Pink

28,00Lei

Pelete de Carlig Dynamite Baits Wowsers 9mm Orange

Pelete de Carlig Dynamite Baits Wowsers 9mm Orange

28,00Lei

Pelete de Carlig Dynamite Baits Wowsers 7mm White

Pelete de Carlig Dynamite Baits Wowsers 7mm White

28,00Lei

Pelete de Carlig Dynamite Baits Wowsers 9mm White

Pelete de Carlig Dynamite Baits Wowsers 9mm White

28,00Lei

Pelete de Carlig Dynamite Baits Wowsers 7mm Purple

Pelete de Carlig Dynamite Baits Wowsers 7mm Purple

28,00Lei

Pelete de Carlig Dynamite Baits Wowsers 9mm Purple

Pelete de Carlig Dynamite Baits Wowsers 9mm Purple

28,00Lei

Pelete Dynamite Baits Wowsers Pink ES-L 5mm

Pelete Dynamite Baits Wowsers Pink ES-L 5mm

28,00Lei

Pelete Dynamite Baits Wowsers Orange ES-B 5mm

Pelete Dynamite Baits Wowsers Orange ES-B 5mm

28,00Lei

Pelete Dynamite Baits Wowsers White ES-Z 5mm

Pelete Dynamite Baits Wowsers White ES-Z 5mm

28,00Lei

Pelete de Carlig Dynamite Baits Wowsers Orange ES-B 3mm

Pelete de Carlig Dynamite Baits Wowsers Orange ES-B 3mm

28,00Lei

Pelete de Carlig Dynamite Baits Wowsers White ES-Z 3mm

Pelete de Carlig Dynamite Baits Wowsers White ES-Z 3mm

28,00Lei

PELETE DYNAMITE BAITS 21MM PRE-GAURITE HALIBUT 900GR

PELETE DYNAMITE BAITS 21MM PRE-GAURITE HALIBUT 900GR

35,00Lei

Pelete Dynamite Baits Swim Stim Red Krill Carp 900Gr 6mm

Pelete Dynamite Baits Swim Stim Red Krill Carp 900Gr 6mm

35,00Lei

Pelete Dynamite Baits Swim Stim Red Krill Carp 900Gr 8mm

Pelete Dynamite Baits Swim Stim Red Krill Carp 900Gr 8mm

35,00Lei

Pelete Dynamite Baits Super Fishmeal Slow Sinking YELLOW/RED
Pelete Dynamite Baits Super Fishmeal Pop-Up YELLOW/RED

Pelete Dynamite Baits Super Fishmeal Pop-Up YELLOW/RED

34,00Lei

Pelete Dynamite Baits The Source 8mm Pre-Drilled 350Gr

Pelete Dynamite Baits The Source 8mm Pre-Drilled 350Gr

25,00Lei

Pelete Dynamite Baits The Source Pellets 14mm Pre -Drilled 350Gr
Pelete Dynamite Baits Krill Drilled Hook 8mm

Pelete Dynamite Baits Krill Drilled Hook 8mm

35,00Lei

Pelete Dynamite Baits Marine Halibut 900Gr 8mm

Pelete Dynamite Baits Marine Halibut 900Gr 8mm

35,00Lei

PELETE GAURITE DYNAMITE BAITS THE SURCE 21MM -20%

PELETE GAURITE DYNAMITE BAITS THE SURCE 21MM

20,00Lei 25,00Lei

PELETE DYNAMITE BAITS MARINE HALIBUT 3MM

PELETE DYNAMITE BAITS MARINE HALIBUT 3MM

35,00Lei

PELETE DYNAMITE BAITS MARINE HALIBUT 6MM

PELETE DYNAMITE BAITS MARINE HALIBUT 6MM

35,00Lei

PELETE DYNAMITE BAITS MARINE HALIBUT 10MM

PELETE DYNAMITE BAITS MARINE HALIBUT 10MM

35,00Lei

PELETE DYNAMITE BAITS MARINE HALIBUT 14MM

PELETE DYNAMITE BAITS MARINE HALIBUT 14MM

35,00Lei

PELETE GAURITE DYNAMITE BAITS MARINE HALIBUT 8MM

PELETE GAURITE DYNAMITE BAITS MARINE HALIBUT 8MM

23,00Lei

PELETE GAURITE DYNAMITE BAITS MARINE HALIBUT 21MM

PELETE GAURITE DYNAMITE BAITS MARINE HALIBUT 21MM

23,00Lei

PELETE PENTRU CARLIG DYNAMITE BAITS MARINE HALIBUT 22MM -20%

PELETE PENTRU CARLIG DYNAMITE BAITS MARINE HALIBUT 22MM

63,00Lei 79,00Lei

PELETE PENTRU CARLIG DYNAMITE BAITS BLODIED EEL 22MM -20%

PELETE PENTRU CARLIG DYNAMITE BAITS BLODIED EEL 22MM

63,00Lei 79,00Lei

PELETE PENTRU CARLIG DYNAMITE BAITS SQUID AND OCTOPUS 22MM -30%

PELETE PENTRU CARLIG DYNAMITE BAITS SQUID AND OCTOPUS 22MM

55,00Lei 79,00Lei

PELETE GAURITE DYNAMITE BAITS MARINE HALIBUT 8MM

PELETE GAURITE DYNAMITE BAITS MARINE HALIBUT 8MM

35,00Lei

PELETE DYNAMITE BAITS SWIM STIM AMINO ORIGINAL PELLETS 3MM

PELETE DYNAMITE BAITS SWIM STIM AMINO ORIGINAL PELLETS 3MM

35,00Lei

PELETE DYNAMITE BAITS SWIM STIM BETAIN GREEN 3MM

PELETE DYNAMITE BAITS SWIM STIM BETAIN GREEN 3MM

35,00Lei

PELETE DYNAMITE BAITS SWIM STIM BETAIN GREEN 6MM

PELETE DYNAMITE BAITS SWIM STIM BETAIN GREEN 6MM

35,00Lei

PELETE DYNAMITE BAITS SWIM STIM BETAIN GREEN 8MM

PELETE DYNAMITE BAITS SWIM STIM BETAIN GREEN 8MM

35,00Lei

PELETE DYNAMITE BAITS SWIM STIM RED KRILL CARP 3MM

PELETE DYNAMITE BAITS SWIM STIM RED KRILL CARP 3MM

35,00Lei

Pelete Dynamite Baits Super Fishmeal Slow Sinking White/Brown

Pelete Dynamite Baits Super Fishmeal Slow Sinking White/Brown

34,00Lei

Pelete Dynamite Baits Super Fishmeal Pop-up - White/Brown

Pelete Dynamite Baits Super Fishmeal Pop-up - White/Brown

34,00Lei

PELETE DYNAMITE BAITS ROBIN RED CARP PELLET 2MM

PELETE DYNAMITE BAITS ROBIN RED CARP PELLET 2MM

42,00Lei

Pelete Dynamite Baits Complex-T 4mm 900g

Pelete Dynamite Baits Complex-T 4mm 900g

40,99Lei

Pelete Dynamite Baits Complex-T 6mm 900g

Pelete Dynamite Baits Complex-T 6mm 900g

40,99Lei

Pelete Dynamite Baits Complex-T 8mm 900g

Pelete Dynamite Baits Complex-T 8mm 900g

40,99Lei

Pelete Dynamite Baits Monster Tigernut 4mm 900g

Pelete Dynamite Baits Monster Tigernut 4mm 900g

39,00Lei

Pelete Dynamite Baits Monster Tigernut 6mm 900g

Pelete Dynamite Baits Monster Tigernut 6mm 900g

39,00Lei

Pelete Dynamite Baits Monster Tigernut 8mm 900g -21%

Pelete Dynamite Baits Monster Tigernut 8mm 900g

30,90Lei 39,00Lei

Pelete de Carlig Dynamite Baits Swim Stim Durable Hook Pellets Red Krill 4mm
Pelete de Carlig Dynamite Baits Swim Stim Durable Hook Pellets Red Krill 6mm
Pelete Dynamite Baits Carp Pellets 2mm 700g

Pelete Dynamite Baits Carp Pellets 2mm 700g

25,00Lei

Pelete Dynamite Baits Carp Pellets 4mm 700g

Pelete Dynamite Baits Carp Pellets 4mm 700g

25,00Lei

PELETE DYNAMITE BAITS CARP PELLETS 700G 6MM

PELETE DYNAMITE BAITS CARP PELLETS 700G 6MM

25,00Lei

PELETE DYNAMITE BAITS CARP PELLETS 700G 8MM

PELETE DYNAMITE BAITS CARP PELLETS 700G 8MM

25,00Lei

PELETE DYNAMITE BAITS CARP PELLETS 700G 11MM

PELETE DYNAMITE BAITS CARP PELLETS 700G 11MM

25,00Lei

Pelete De Carlig Dynamite Baits Swim Stim Durable Hook Pellets 6mm Betanine Green
Pelete De Carlig Dynamite Baits Swim Stim Durable Hook Pellets 4mm Betanine Green
Pelete De Carlig Dynamite Baits Swim Stim Durable Hook Pellets 4mm Amino Original
Pelete De Carlig Dynamite Baits Swim Stim Durable Hook Pellets 6mm Amino Original
Pelete De Carlig Dynamite Baits Swim Stim Durable Hook Pellets 6mm White Amino Original -23%
Pelete De Carlig Dynamite Baits Swim Stim Durable Hook Pellets 4mm White Amino Original
Pelete De Carlig Dynamite Baits Swim Stim Durable Hook Pellets 6mm Yellow F1 Amino
Pelete De Carlig Dynamite Baits Swim Stim Durable Hook Pellets 4mm Yellow F1 Amino
PELETE DYNAMITE BAITS SWIM STIM Red Krill Carp 2 mm

PELETE DYNAMITE BAITS SWIM STIM Red Krill Carp 2 mm

35,00Lei

Pelete Dynamite Baits Durable Hook Big Fish Floating Krill 12mm
Pelete Dynamite Baits Durable Hook Pellet Big Fish 12mm Sweet Tiger
Pelete Dynamite Baits Durable Hook Pellet Big Fish 12mm Alb

Pelete Dynamite Baits Durable Hook Pellet Big Fish 12mm Alb

35,00Lei

PELETE DE CARLIG DYNAMITE BAITS BELACHAN HOOK PELLETS 22mm

PELETE DE CARLIG DYNAMITE BAITS BELACHAN HOOK PELLETS 22mm

79,00Lei

PELETE DE CARLIG DYNAMITE BAITS BELACHAN HOOK PELLETS 30mm

PELETE DE CARLIG DYNAMITE BAITS BELACHAN HOOK PELLETS 30mm

79,00Lei

PELETE DYNAMITE BAITS FLURO POP-UP PELLETS BELACHAN 22mm

PELETE DYNAMITE BAITS FLURO POP-UP PELLETS BELACHAN 22mm

79,00Lei

Pelete Dynamite Baits Method Feeder Carp Pellet 2mm 1.8kg

Pelete Dynamite Baits Method Feeder Carp Pellet 2mm 1.8kg

59,00Lei

Pelete Dynamite Baits Swim Stim Amino Original 2mm, 900g

Pelete Dynamite Baits Swim Stim Amino Original 2mm, 900g

35,00Lei

Pelete Dynamite Baits Swim Stim F1 Sweet 2mm, 900g

Pelete Dynamite Baits Swim Stim F1 Sweet 2mm, 900g

35,00Lei

Pelete Dynamite Baits Swim Stim F1 Sweet 4mm, 900g

Pelete Dynamite Baits Swim Stim F1 Sweet 4mm, 900g

35,00Lei

Pelete Dynamite Baits Swim Stim F1 Sweet 6mm, 900g

Pelete Dynamite Baits Swim Stim F1 Sweet 6mm, 900g

35,00Lei

Pelete Dynamite Baits Swim Stim F1 Sweet 8mm, 900g

Pelete Dynamite Baits Swim Stim F1 Sweet 8mm, 900g

35,00Lei

Pelete Dynamite Baits Cata Pellets, 6mm, 1,8kg

Pelete Dynamite Baits Cata Pellets, 6mm, 1,8kg

51,00Lei

Pelete Dynamite Baits Cata Pellets, 8mm, 1,8kg

Pelete Dynamite Baits Cata Pellets, 8mm, 1,8kg

51,00Lei

Pelete Dynamite Baits Durable Hook Pellet Source 12mm

Pelete Dynamite Baits Durable Hook Pellet Source 12mm

27,00Lei

Pelete Dynamite Baits Durable Hook Pellet Source 6mm

Pelete Dynamite Baits Durable Hook Pellet Source 6mm

27,00Lei

Pelete Dynamite Baits Durable Hook Pellet Source 8mm

Pelete Dynamite Baits Durable Hook Pellet Source 8mm

27,00Lei

Pelete Dynamite Baits Durable Hook Pellet Strawberry 6mm

Pelete Dynamite Baits Durable Hook Pellet Strawberry 6mm

27,00Lei

Pelete Dynamite Baits Durable Hook Pellet Sweetcorn 6mm

Pelete Dynamite Baits Durable Hook Pellet Sweetcorn 6mm

27,00Lei

Pelete Dynamite Baits Durable Hook Pellet Tutti-Frutti 6mm

Pelete Dynamite Baits Durable Hook Pellet Tutti-Frutti 6mm

27,00Lei

Pelete Dynamite Baits Durable Hook Pellet Garlic 6mm

Pelete Dynamite Baits Durable Hook Pellet Garlic 6mm

28,00Lei

Pelete Dynamite Baits Durable Hook Pellet Sweet Banoffi 6mm

Pelete Dynamite Baits Durable Hook Pellet Sweet Banoffi 6mm

27,00Lei

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

Peletele Dybamite Baits Robin Red de 20mm sunt o alegere excelentă pentru pescarii care caută o momeală eficientă și de încredere. Iată o descriere detaliată a acestui produs:

  1. Aroma Robin Red: Aceste pelete sunt impregnate cu aroma intensă și distinctivă a Robin Red, o combinație de arome puternice și ingrediente atrăgătoare, cunoscută pentru capacitatea sa de a atrage o gamă largă de specii de pești. Aroma lor puternică este un stimulent pentru apetitul peștilor și îi atrage în zona de pescuit.

  2. Dimensiune versatilă: Cu un diametru de 20mm, aceste pelete sunt mai mari decât cele de 15mm, ceea ce le face potrivite pentru a fi folosite în situații în care se dorește atragerea peștilor mai mari sau în ape mai adânci. Dimensiunea lor le face să fie ideale pentru pescuitul de crap, dar pot fi folosite și pentru alte specii mari de pești prădători.

  3. Textură durabilă: Peletele au o textură solidă și rezistentă, care le permite să reziste la inmuiere în apă pentru o perioadă mai lungă de timp, menținându-și aroma și atracția. Această durabilitate îi face să fie potrivite pentru utilizarea în pescuitul de lungă durată, fără a-și pierde eficacitatea.

  4. Ambalaj practic: Peletele sunt ambalate într-un recipient sigilat, care păstrează prospețimea și calitatea lor. Acest ambalaj practic este ușor de transportat și depozitat, oferind pescarului acces rapid și comod la momeală atunci când este necesar.

  5. Potrivite pentru diverse tehnici de pescuit: Aceste pelete sunt ideale pentru a fi folosite în diverse tehnici de pescuit, inclusiv în monturile cu fir sau cu plumb pierdut. Ele pot fi utilizate și în sistemele de hrănire și hrănire, adaptându-se astfel preferințelor și nevoilor fiecărui pescar.

Peletele Dybamite Baits Robin Red de 20mm sunt o momeală de înaltă calitate, concepută pentru a maximiza șansele de succes în pescuit. Fiind durabile, atrăgătoare și versatile, aceste pelete sunt un instrument esențial în trusa de pescuit a oricărui pescar entuziast.

Caracteristici
Tip Produs Pelete
Model Dynamite
Diametru (mm) 20
Aroma Robin Red
Culoare Rosu
Compozitie Fishmeal
Mod de Ambalare (Cantitate) 900 g
Alte Specificatii Inapt consumului uman
Review-uri (1 de review-uri)
4
1 de review-uri
5 stele
0
4 stele
1
3 stele
0
2 stele
0
1 stea
0

0

Achizitie verificata

100%

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: PELETE DYBAMITE BAITS ROBIN RED 20MM 900GR dy085 Pelete Pentru Nadit Pelete Pentru Nadit Dynamite Baits Dynamite Baits

Queries: 43, Total time: 4.586 ms [By time] [By id] [By file]
1 (0.076)
SELECT data
FROM `oc_session`
WHERE session_id = 'a059e577f8135aaf54f067fe3b'
/var/www/clients/client1/web1/web/system/library/session/db.php:23
2 (0.113)
SELECT *
FROM oc_platforma_promovari LIMIT 1
/var/www/clients/client1/web1/web/index.php:128
3 (0.090)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/clients/client1/web1/web/index.php:313
4 (0.071)
SELECT *
FROM oc_currency
/var/www/clients/client1/web1/web/system/library/currency.php:17
5 (0.203)
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.219)
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.100)
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.094)
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.068)
SELECT `trigger`, `action`
FROM oc_event
/var/www/clients/client1/web1/web/index.php:414
10 (0.099)
SELECT *
FROM oc_url_alias
WHERE keyword = 'pelete-dybamite-baits-robin-red-20mm-900gr.html'
/var/www/clients/client1/web1/web/catalog/controller/common/seo_url.php:48
11 (0.085)
SELECT category_id
FROM oc_product_to_category
WHERE product_id = '10540' 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 = '141'
ORDER BY cp.level ASC, c.sort_order ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/product.php:1519
13 (0.128)
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 = '91' 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.118)
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 = '141' 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.091)
SELECT *
FROM `oc_module`
WHERE `code` = 'similar_products'
ORDER BY `name`
/var/www/clients/client1/web1/web/catalog/model/extension/module.php:5
16 (0.137)
SELECT *
FROM `oc_product_locatie`
WHERE product_id = '10540' 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
17 (0.108)
SELECT *
FROM `oc_product_locatie`
WHERE product_id = '10540' 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
18 (0.086)
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.129)
SELECT COUNT(1) AS total, rating
FROM `oc_review`
WHERE `product_id` = '10540' AND status=1 GROUP BY rating
ORDER BY rating ASC
/var/www/clients/client1/web1/web/catalog/model/catalog/review.php:125
20 (0.107)
SELECT COUNT(1) AS total
FROM `oc_review`
WHERE `product_id` = '10540' AND status=1 AND verificat = '1' GROUP BY product_id
/var/www/clients/client1/web1/web/catalog/model/catalog/review.php:134
21 (0.176)
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 = '10540' 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
22 (0.217)
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 = '10540' 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
23 (0.125)
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` = 10540 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
24 (0.101)
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
25 (0.094)
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
26 (0.094)
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
27 (0.095)
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
28 (0.137)
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 '%"10540"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/productbundles.php:106
29 (0.133)
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 '%"10540"%' LIMIT 0, 1000
/var/www/clients/client1/web1/web/catalog/model/module/product_recomandate.php:106
30 (0.068)
SELECT *
FROM oc_module
WHERE module_id = '31'
/var/www/clients/client1/web1/web/catalog/model/extension/module.php:11
31 (0.125)
SELECT *
FROM oc_product
WHERE product_id = '10540'
/var/www/clients/client1/web1/web/catalog/model/module/similar_products.php:92
32 (0.108)
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
33 (0.097)
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
34 (0.062)
SELECT *
FROM oc_module
WHERE module_id = '1218'
/var/www/clients/client1/web1/web/catalog/model/extension/module.php:11
35 (0.061)
SELECT *
FROM oc_module
WHERE module_id = '1190'
/var/www/clients/client1/web1/web/catalog/model/extension/module.php:11
36 (0.062)
SELECT *
FROM oc_module
WHERE module_id = '1221'
/var/www/clients/client1/web1/web/catalog/model/extension/module.php:11
37 (0.113)
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
38 (0.070)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
39 (0.093)
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
40 (0.090)
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
41 (0.077)
SELECT *
FROM oc_platforma_promovari
/var/www/clients/client1/web1/web/catalog/model/common/platforma.php:4
42 (0.082)
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
43 (0.063)
SELECT *
FROM oc_module
WHERE module_id = '1192'
/var/www/clients/client1/web1/web/catalog/model/extension/module.php:11