Kamatsu Swivel K-241

Name: Kamatsu Swivel K-241
Brand: Kamatsu
SKU: 8864
Price: 1.3300 EUR
Availability: InStock

Κωδικός: 8864

Η σειρά K-241 της εταιρείας Kamatsu είναι παγκοσμίως γνωστά στην δύναμη, την αξιοπιστία αλλά και αντοχή στις φθορές.

Δείτε τα όλα

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

1,33 € -10%

1,20 €

Νούμερο

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

Περιγραφή

Με επικάλυψη από μαύρο χρώμιο...

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

Τα Kamatsu Swivel K-241 έχουν δοκιμαστεί σε πραγματικές συνθήκες και για τον λόγο αυτό τα αναγραφόμενα όρια αντοχή είναι πραγματικά.

Διαθέτουν πολύ ομαλή περιστροφή ενώ η επικάλυψη από μαύρο χρώμιο προσφέρει επιπλέον προστασία από την διάβρωση.

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

Χρώμα: Mαύρο

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

Τύπος: Με Rolling

Extra: Eπικάλυψη χρωμίου

Κατηγορία: Στριφτάρια

Μέγεθος Αντοχή Τεμάχια

Νο 2 38.00kg 10

Νο 4 35.00kg 10

Νο 6 30.00kg 10

Νο 8 19.00kg 10

Νο 10 14.00kg 10

No 12 11.00kg 10

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

Δωρεάν αποστολή για αγορές άνω των 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: 115, Total time: 32.710 ms [By time] [By id] [By file]
1 (0.072)

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

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

DELETE
FROM `oc_session`
WHERE `expire` < '2026-05-19 13:08:38'
/home/fp2026/public_html/fishingplanet/system/library/session/db.php:54
4 (0.086)

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.271)

SELECT `data`
FROM `oc_session`
WHERE `session_id` = '836fac174635dc59aafc9baee0' AND `expire` > '2026-05-19 13:08:38'
/home/fp2026/public_html/fishingplanet/system/library/session/db.php:17
6 (0.080)

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.553)

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.098)

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

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

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.062)

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.196)

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.097)

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.212)

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.126)

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.087)

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.109)

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

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 = '10736' 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.101)

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

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

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

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

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 = '10736' AND od.language_id = '2'
ORDER BY o.sort_order
/home/fp2026/public_html/fishingplanet/catalog/model/tool/onepixel.php:255
24 (0.080)

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '10736'
/home/fp2026/public_html/fishingplanet/catalog/model/tool/onepixel.php:45
25 (0.330)

SELECT *
FROM oc_product_discount
WHERE product_id = '10736' 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
26 (0.103)

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 = '10736' AND od.language_id = '2'
ORDER BY o.sort_order
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:452
27 (0.122)

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 = '10736' AND pov.product_option_id = '4883' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:457
28 (0.097)

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
29 (0.079)

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
30 (0.129)

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 = '10736' 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
31 (0.095)

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 = '10736' 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
32 (0.072)

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 = '10736' 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
33 (0.085)

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 = '10736' 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
34 (0.465)

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 = '10736' 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
35 (0.084)

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 = 10736 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
36 (16.865)

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

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

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
39 (0.094)

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
40 (0.077)

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
41 (0.119)

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

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
43 (0.066)

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
44 (0.066)

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
45 (0.090)

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

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
47 (0.086)

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
48 (0.064)

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
49 (0.081)

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

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
51 (0.055)

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
52 (0.053)

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
53 (0.094)

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
54 (0.098)

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
55 (0.208)

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
56 (0.090)

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
57 (0.105)

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

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
59 (1.601)

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 = '10736' 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
60 (0.080)

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

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
62 (0.101)

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
63 (0.117)

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
64 (0.126)

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
65 (0.068)

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
66 (0.108)

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
67 (0.072)

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
68 (0.075)

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
69 (0.060)

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
70 (0.075)

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
71 (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 = '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
72 (0.146)

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
73 (0.165)

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
74 (0.082)

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
75 (0.075)

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
76 (0.068)

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
77 (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 = '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
78 (0.123)

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
79 (0.143)

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
80 (0.103)

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
81 (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 = '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
82 (0.069)

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
83 (0.092)

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
84 (0.070)

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
85 (0.067)

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
86 (0.141)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '836fac174635dc59aafc9baee0'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
87 (0.064)

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
88 (0.080)

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
89 (0.072)

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
90 (0.089)

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
91 (0.076)

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
92 (0.071)

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
93 (0.071)

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
94 (0.075)

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
95 (0.063)

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '836fac174635dc59aafc9baee0'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
96 (0.059)

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

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
98 (0.083)

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

SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '836fac174635dc59aafc9baee0'
/home/fp2026/public_html/fishingplanet/system/library/cart/cart.php:42
100 (0.137)

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
101 (0.072)

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

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

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
104 (0.088)

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
105 (0.118)

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
106 (0.127)

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
107 (0.224)

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
108 (0.329)

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
109 (0.211)

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
110 (0.167)

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
111 (0.166)

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
112 (0.144)

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
113 (0.126)

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
114 (0.155)

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
115 (0.153)

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

Μέγεθος	Αντοχή	Τεμάχια
Νο 2	38.00kg	10
Νο 4	35.00kg	10
Νο 6	30.00kg	10
Νο 8	19.00kg	10
Νο 10	14.00kg	10
No 12	11.00kg	10