Pioneer SGL 120cm

Name: Pioneer SGL 120cm
Brand: Pioneer
SKU: 8905
Price: 12.3900 EUR
Availability: OutOfStock

Κωδικός: 8905

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

Δείτε τα όλα

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

Περιγραφή

Από ανθεκτικό Nylon...

Οι νέες θήκες καλαμιών SGL της εταιρείας Pioneer είναι κατασκευασμένες από ανθεκτικό Nylon εξασφαλίζοντας την υψηλή προστασία σε φθορές των καλαμιών που συνήθως προέρχονται κατά την μεταφορά.

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

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

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

Διαστάσεις: 120 x 17cm

Θέσεις: 1 Θέση

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

Μήκος: 120cm

Extra: 1 Πλευρική θήκη

Κατηγορία: Θήκες Καλαμιών

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

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

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

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

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

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

SELECT `data`
FROM `oc_session`
WHERE `session_id` = 'ecdc5509573765a9203f33ac66' AND `expire` > '2026-05-19 14:48:43'
/home/fp2026/public_html/fishingplanet/system/library/session/db.php:17
6 (0.081)

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

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

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

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

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

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

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

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

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

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

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 = '583' 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.969)

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 = '10777' 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.102)

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

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

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

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

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

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

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

SELECT *
FROM oc_product_discount
WHERE product_id = '10777' 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.085)

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 = '10777' 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.120)

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

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

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 = '10777' 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.108)

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 = '10777' 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.111)

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 = '10777' 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.086)

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 = '10777' 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.700)

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 = '10777' 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.105)

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 = 10777 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 (2.980)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 = '10777' 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.082)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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