Παραγγελίες μετά τις 7/8 αποστέλλονται από 25/8, με σειρά προτεραιότητας

Το καλάθι αγορών είναι άδειο!

ΔΩΡΕΑΝ ΜΕΤΑΦΟΡΙΚΑ για αγορές άνω των 70€

Behr S2

Name: Behr S2
Brand: Behr
SKU: 2170
Price: 12.4500 EUR
Availability: OutOfStock

Κωδικός: 2170

Βομβητής ψαρέματος κατάλληλος για όλα τα καλάμια με φωτεινή αλλά και ηχητική ειδοποίηση

Δείτε τα όλα

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

Περιγραφή

Με έξυπνο σχεδιασμό...

Ο νέος βομβητής της Γερμανικής εταιρείας με μοναδική σχέση ποιότητας-τιμής..

Βασικός αλλά αξιόπιστος βομβητής με πολύ έξυπνο σχεδιασμό, και κόκκινη φωτεινή ένδειξη αλλά και πολύ δυνατή ηχητική ειδοποίηση.

Ιδανικό για ψάρεμα Casting ή ψάρεμα με τεχνητά δολώματα.

Ο βομβητής θα σας ενημερώσει αμέσως, μόλις το ψάρι τσιμπήσει.

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

Είδος: Ειδοποιητές

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

Τύπος: Ηχητικός

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

Δωρεάν αποστολή για αγορές άνω των 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: 129, Total time: 392.617 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.099)

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

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

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

SELECT `data`
FROM `oc_session`
WHERE `session_id` = '96c3e084dd40c61d8c98ea037f' AND `expire` > '2026-05-19 11:18:28'
/home/fp2026/public_html/fishingplanet/system/library/session/db.php:17
6 (0.072)

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

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

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

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

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

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

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

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

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

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

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 (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 = '4579' 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
18 (0.130)

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

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

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

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

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

SELECT category_id
FROM oc_product_to_category
WHERE product_id = '4579'
/home/fp2026/public_html/fishingplanet/catalog/model/tool/onepixel.php:45
24 (0.508)

SELECT *
FROM oc_product_discount
WHERE product_id = '4579' 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
25 (0.109)

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

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

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

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 = '4579' 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
29 (0.078)

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 = '4579' 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
30 (0.090)

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 = '4579' 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
31 (0.071)

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 = '4579' 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
32 (0.980)

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 = '4579' 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
33 (1.358)

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 = '4516' 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
34 (0.068)

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

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 = '5048' 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
36 (0.062)

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

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 = '5210' 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
38 (0.066)

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

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 = '6175' 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
40 (0.081)

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

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 = '6270' 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
42 (0.065)

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

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 = '8222' 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
44 (0.068)

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

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 = '13336' 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
46 (0.083)

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

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 = '14295' 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
48 (0.070)

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

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 = 4579 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
50 (365.761)

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

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

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

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

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

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

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

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
58 (0.112)

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

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

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
61 (0.157)

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

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

SELECT *
FROM oc_product_to_layout
WHERE product_id = '4579' AND store_id = '0'
/home/fp2026/public_html/fishingplanet/system/storage/modification/catalog/model/catalog/product.php:573
64 (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
65 (0.081)

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

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

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

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

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

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
71 (0.111)

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

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

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 = '4579' 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
74 (0.086)

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

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

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

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

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

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
81 (0.180)

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
82 (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 = '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
83 (0.151)

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

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

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

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
87 (0.284)

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

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

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

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

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
92 (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 = '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
93 (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 = '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
94 (0.186)

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
95 (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 = '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
96 (0.149)

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
97 (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
98 (0.125)

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
99 (0.175)

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
100 (0.193)

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

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
102 (0.148)

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
103 (0.162)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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
119 (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 = '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
120 (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 = '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
121 (0.133)

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
122 (0.130)

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
123 (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 = '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
124 (0.113)

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
125 (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 = '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
126 (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 = '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
127 (0.048)

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

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

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

Behr S2

Behr Air Pump 2 Speed

13,45 €

Βελόνα Δολώματος Stonfo I

3,20 €

Tp Sta Super Brilhante 28619

5,70 €

Βελόνα Δολώματος Stonfo II

3,70 €

Black Diamond Bait Elastic 100m

1,50 €

Oceanic Air Pump II

10,80 €

Primus AP-2102

15,00 €

Delphin A-Pump Mini II Speed

9,45 €

Περιγραφή

Με έξυπνο σχεδιασμό...

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

0

Behr S2

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

13,45 €

3,20 €

5,70 €

3,70 €

1,50 €

10,80 €

15,00 €

9,45 €

Περιγραφή

Με έξυπνο σχεδιασμό...

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