Cressi Ultra Stretch Nero 2.5mm

Name: Cressi Ultra Stretch Nero 2.5mm
Brand: Cressi
SKU: 4126
Price: 29.9900 EUR
Availability: InStock

Κωδικός: 4126

Τα καλ΄τσάκια Ultra Stretch θεωρούνται εδώ και χρόνια μια από τις πιο πετυχημένες σειρές της Ιταλικής εταιρείας αφού συνδυάζουν μοναδική εφαρμογή, υψηλή ποιότητα και χαμηλό κόστος.

Δείτε τα όλα

Άμεσα Διαθέσιμο

29,99 € -15%

25,49 €

Μέγεθος

Δείτε όλα τα προϊόντα

Περιγραφή

Με εσωτερικό υλικό Metallite...

Τα συγκεκριμένα καλτσάκια της Cressi είναι λεπτά, high-stretch από neoprene πάχους 2,5 χιλιοστών, με αντιολισθητικό πέλμα.

Το εσωτερικό τους είναι με Metallite για εύκολο φόρεμα και τέλεια εφαρμογή.
Τα Ultra Stretch Nero της Cressi μπορούν να φορεθούν τόσο με ανοιχτό πέδιλο όσο και με πέδιλο κλειστού τύπου για περισσότερη ζέστη ή προστασία του ποδιού.

Προτείνουμε να πάρετε μικρότερο νούμερο από αυτό που συνήθως φοράτε, καθώς διαθέτουν μεγάλη γραμμή.

Προδιαγραφές προϊόντος

Πάχος: 2.5mm

Χρώμα: Γκρι

Κατασκευαστής: Cressi

Υλικό: Neopren / Metallite

Κατηγορία: Καλτσάκια

Cod Μέγεθος Νο EU

LX433002 Medium 39-40

LX433002 Large 41-42

LX433004 XLarge 43-45

Διάλεξε τον τρόπο πληρωμής που σου ταιριάζει

Δωρεάν αποστολή για αγορές άνω των 70€

Παραλαβή από κατάστημά μας

Follow Us

Βοήθεια

Επικοινωνία

Συχνές Ερωτήσεις

Οδηγός αγοράς

Λογαριασμός

Πληροφορίες

Όροι χρήσης

Πολιτική απορρήτου

Πολιτική Coookies

Ασφάλεια συναλλαγών

Θα μας βρείτε

210 2400157

Εθνικής Αντιστάσεως 59,
Αχαρναί 13672,
Ελλάδα

Δευτ & Τετάρτ : 9:00 - 16:00
Τριτ & Πεμ& Παρ: 9:00 - 19:00
Σαβ : 9:00 - 16:00

fishingplanet.gr © 2026 - Created by onepixel

Queries: 118, Total time: 33.049 ms [By time] [By id] [By file]
1 (0.114)

SELECT *
FROM oc_setting
WHERE `key` = 'config_timezone' AND store_id = '0'
/home/fp2026/public_html/fishingplanet/system/framework.php:87
2 (0.112)

SET time_zone = '+03:00'
/home/fp2026/public_html/fishingplanet/system/framework.php:94
3 (0.951)

DELETE
FROM `oc_session`
WHERE `expire` < '2026-05-19 11:14:24'
/home/fp2026/public_html/fishingplanet/system/library/session/db.php:54
4 (0.140)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
5 (0.346)

SELECT `data`
FROM `oc_session`
WHERE `session_id` = '4d08a25f591ea198a9d609f8cf' AND `expire` > '2026-05-19 11:14:24'
/home/fp2026/public_html/fishingplanet/system/library/session/db.php:17
6 (0.085)

SELECT *
FROM oc_store
WHERE REPLACE(`url`, 'www.', '') = 'http://test.fishingplanet.gr/'
/home/fp2026/public_html/fishingplanet/catalog/controller/startup/startup.php:20
7 (0.576)

SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/fp2026/public_html/fishingplanet/catalog/controller/startup/startup.php:37
8 (0.134)

SET time_zone = '+03:00'
/home/fp2026/public_html/fishingplanet/catalog/controller/startup/startup.php:52
9 (0.121)

SELECT *
FROM oc_currency
/home/fp2026/public_html/fishingplanet/system/library/cart/currency.php:16
10 (0.101)

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 = '8' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/fp2026/public_html/fishingplanet/system/library/cart/tax.php:18
11 (0.077)

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 = '8' AND z2gz.country_id = '84' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/fp2026/public_html/fishingplanet/system/library/cart/tax.php:46
12 (0.075)

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'
/home/fp2026/public_html/fishingplanet/system/library/cart/weight.php:12
13 (0.086)

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'
/home/fp2026/public_html/fishingplanet/system/library/cart/length.php:12
14 (0.505)

DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:21
15 (0.170)

SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/home/fp2026/public_html/fishingplanet/catalog/model/setting/event.php:4
16 (0.131)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/product' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
17 (0.107)

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 = '86' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:4
18 (1.168)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 = '8' 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '8') AS reward, (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 lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_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(*) 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)
WHERE p.product_id = '3159' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:22
19 (0.073)

SELECT *
FROM oc_product_newtabcontent
WHERE product_id = '3159' AND language_id = '2'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:26
20 (0.176)

SELECT *
FROM oc_product_to_category
WHERE product_id = '3159' AND category_id IN(86)
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:855
21 (0.087)

SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'recently_viewed'
/home/fp2026/public_html/fishingplanet/catalog/model/extension/module/recently_viewed.php:23
22 (0.095)

SELECT *
FROM oc_product_image
WHERE product_id = '3159'
ORDER BY sort_order ASC
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:527
23 (0.097)

SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '18' AND m2s.store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/manufacturer.php:4
24 (0.096)

SELECT *
FROM oc_product_tech po
LEFT JOIN `oc_tech` o ON (po.tech_id = o.tech_id)
LEFT JOIN oc_tech_description od ON (o.tech_id = od.tech_id)
WHERE po.product_id = '3159' AND od.language_id = '2'
ORDER BY o.sort_order
/home/fp2026/public_html/fishingplanet/catalog/model/tool/onepixel.php:255
25 (0.069)

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '3159'
/home/fp2026/public_html/fishingplanet/catalog/model/tool/onepixel.php:45
26 (0.299)

SELECT *
FROM oc_product_discount
WHERE product_id = '3159' AND customer_group_id = '8' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW()))
ORDER BY quantity ASC, priority ASC, price ASC
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:507
27 (0.100)

SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '3159' AND od.language_id = '2'
ORDER BY o.sort_order
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:452
28 (0.101)

SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '3159' AND pov.product_option_id = '1589' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:457
29 (0.090)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/captcha/recaptcha' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
30 (0.081)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'extension/captcha/recaptcha'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
31 (0.159)

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 = '3159' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:424
32 (0.069)

SELECT a.attribute_id, 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 = '3159' AND a.attribute_group_id = '20' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:429
33 (0.059)

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 = '3159' AND agd.language_id = '2' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/home/fp2026/public_html/fishingplanet/catalog/model/tool/onepixel.php:308
34 (0.053)

SELECT a.attribute_id, 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 = '3159' AND a.attribute_group_id = '20' AND a.featured = '1' AND ad.language_id = '2' AND pa.language_id = '2'
ORDER BY a.sort_order, ad.name
/home/fp2026/public_html/fishingplanet/catalog/model/tool/onepixel.php:313
35 (0.513)

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 = '3159' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:549
36 (0.914)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 = '8' 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '8') AS reward, (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 lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_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(*) 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)
WHERE p.product_id = '4501' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:22
37 (0.078)

SELECT *
FROM oc_product_newtabcontent
WHERE product_id = '4501' AND language_id = '2'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:26
38 (0.094)

SELECT rd.*
FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 2 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id
WHERE pr.product_id = 3159 AND status = '1' AND pr.customer_group_id = '8'
ORDER BY sort_order ASC
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:804
39 (14.534)

UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '3159'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:4
40 (0.151)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '3159' AND store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:573
41 (0.078)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:4
42 (0.078)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_left'
ORDER BY sort_order
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:14
43 (0.073)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/column_left'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
44 (0.095)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '3159' AND store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:573
45 (0.083)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:4
46 (0.122)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'column_right'
ORDER BY sort_order
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:14
47 (0.097)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/column_right'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
48 (0.145)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '3159' AND store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:573
49 (0.132)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:4
50 (0.076)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_top'
ORDER BY sort_order
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:14
51 (0.088)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/content_top'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
52 (0.142)

SELECT *
FROM oc_product_to_layout
WHERE product_id = '3159' AND store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:573
53 (0.210)

SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:4
54 (0.076)

SELECT *
FROM oc_layout_module
WHERE layout_id = '2' AND position = 'content_bottom'
ORDER BY sort_order
/home/fp2026/public_html/fishingplanet/catalog/model/design/layout.php:14
55 (0.071)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/content_bottom'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
56 (0.087)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/footer' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
57 (0.080)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/gconsent' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
58 (0.223)

SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/information.php:10
59 (0.111)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/footer'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
60 (0.103)

SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/setting/extension.php:4
61 (0.087)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
62 (1.289)

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '8' 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 = '8' 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 points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.customer_group_id = '8') AS reward, (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 lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_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(*) 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)
WHERE p.product_id = '3159' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:22
63 (0.086)

SELECT *
FROM oc_product_newtabcontent
WHERE product_id = '3159' AND language_id = '2'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:26
64 (0.077)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/social_meta'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
65 (0.136)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
66 (0.148)

SELECT *
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.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
67 (0.192)

SELECT *
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.parent_id = '188' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
68 (0.106)

SELECT *
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.parent_id = '154' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
69 (0.203)

SELECT *
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.parent_id = '70' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
70 (0.085)

SELECT *
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.parent_id = '110' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
71 (0.087)

SELECT *
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.parent_id = '91' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
72 (0.085)

SELECT *
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.parent_id = '128' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
73 (0.078)

SELECT *
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.parent_id = '288' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
74 (0.091)

SELECT *
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.parent_id = '531' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
75 (0.221)

SELECT *
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.parent_id = '400' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
76 (0.176)

SELECT *
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.parent_id = '86' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
77 (0.088)

SELECT *
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.parent_id = '87' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
78 (0.094)

SELECT *
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.parent_id = '113' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
79 (0.091)

SELECT *
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.parent_id = '121' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
80 (0.131)

SELECT *
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.parent_id = '557' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
81 (0.122)

SELECT *
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.parent_id = '206' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
82 (0.088)

SELECT *
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.parent_id = '350' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
83 (0.095)

SELECT *
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.parent_id = '325' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
84 (0.102)

SELECT *
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.parent_id = '633' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
85 (0.095)

SELECT *
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.parent_id = '641' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
86 (0.153)

SELECT *
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.parent_id = '671' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
87 (0.084)

SELECT *
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.parent_id = '674' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
88 (0.093)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/menumega'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
89 (0.112)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4d08a25f591ea198a9d609f8cf'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
90 (0.088)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/cart_items'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
91 (0.127)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/language' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
92 (0.091)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/language'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
93 (0.118)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/currency' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
94 (0.088)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/currency'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
95 (0.091)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/search' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
96 (0.075)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/search'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
97 (0.123)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/cart' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
98 (0.081)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4d08a25f591ea198a9d609f8cf'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
99 (0.069)

SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/setting/extension.php:4
100 (0.093)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/sub_total' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
101 (0.067)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4d08a25f591ea198a9d609f8cf'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
102 (0.078)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4d08a25f591ea198a9d609f8cf'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
103 (0.084)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/total' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
104 (0.078)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4d08a25f591ea198a9d609f8cf'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
105 (0.069)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '4d08a25f591ea198a9d609f8cf'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
106 (0.086)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/cart'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
107 (0.126)

SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'el-gr')
/home/fp2026/public_html/fishingplanet/catalog/model/design/translation.php:6
108 (0.164)

SELECT *
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.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
109 (0.153)

SELECT *
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.parent_id = '188' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
110 (0.218)

SELECT *
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.parent_id = '400' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
111 (0.236)

SELECT *
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.parent_id = '86' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
112 (0.132)

SELECT *
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.parent_id = '557' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
113 (0.097)

SELECT *
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.parent_id = '206' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
114 (0.155)

SELECT *
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.parent_id = '633' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
115 (0.212)

SELECT *
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.parent_id = '671' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/fp2026/public_html/fishingplanet/catalog/model/catalog/category.php:10
116 (0.099)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/menu'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
117 (0.175)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'common/header'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4
118 (0.125)

SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'tackle' AND route = 'product/product'
/home/fp2026/public_html/fishingplanet/catalog/model/design/theme.php:4

0

Cressi Ultra Stretch Nero 2.5mm

25,49 €

Xifias Camo Green

77,90 €

Περιγραφή

Με εσωτερικό υλικό Metallite...

Προδιαγραφές προϊόντος

Cod	Μέγεθος	Νο EU
LX433002	Medium	39-40
LX433002	Large	41-42
LX433004	XLarge	43-45

0

Cressi Ultra Stretch Nero 2.5mm

25,49 €

Σχετικά Προϊόντα

Xifias Camo Green

77,90 €

Περιγραφή

Με εσωτερικό υλικό Metallite...

Προδιαγραφές προϊόντος