Your Cart

Adidas MLS Pro Ball

Adidas MLS Pro Ball
Adidas MLS Pro Ball
Adidas MLS Pro Ball
Adidas MLS Pro Ball
Adidas MLS Pro Ball
Adidas MLS Pro Ball
Adidas MLS Pro Ball
Adidas MLS Pro Ball
Adidas MLS Pro Ball
h57824
33.990 Ft
Nettó ár: 33.990 Ft
Eredeti termék
100%-ban eredeti termékek!
Szavatossági idő 2 év
Minden termékünkre
Indoklás nélküli elállás
Visszaküldeheted 14 napig
Kiszállítás: MPL 1990 Ft
1-2 munkanap
Márka: AdidasAdidas Készletállapot: Készleten
14.990 Ft
Nettó ár:14.990 Ft
Kosárba
Márka: AdidasAdidas Készletállapot: Készleten
13.990 Ft
Nettó ár:13.990 Ft
Kosárba
Márka: AdidasAdidas Készletállapot: Készleten
33.990 Ft
Nettó ár:33.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
29.990 Ft
Nettó ár:29.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
33.990 Ft
Nettó ár:33.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
34.990 Ft
Nettó ár:34.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
34.990 Ft
Nettó ár:34.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
34.990 Ft
Nettó ár:34.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
29.990 Ft
Nettó ár:29.990 Ft
Kosárba
Márka: NikeNike Készletállapot: Készleten
31.990 Ft
Nettó ár:31.990 Ft
Kosárba
Queries: 253, Total time: 97.958 ms [By time] [By id] [By file]
1 (3.446)
SET time_zone = '+00:00'
/var/www/html/focicipobolt_hu/public_html/system/framework.php:84
2 (0.138)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '8014dcaa64b226bc84143fbca9' AND `expire` > '2024-11-21 06:23:31'
/var/www/html/focicipobolt_hu/public_html/system/library/session/db.php:16
3 (1.490)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://focicipobolt.hu/'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/startup.php:6
4 (3.072)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/startup.php:25
5 (1.468)
SET time_zone = '+01:00'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/startup.php:40
6 (1.487)
SELECT *
FROM oc_currency
/var/www/html/focicipobolt_hu/public_html/system/library/cart/currency.php:10
7 (0.776)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '97' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4259')
ORDER BY tr1.priority ASC
/var/www/html/focicipobolt_hu/public_html/system/library/cart/tax.php:16
8 (0.537)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '97' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '4259')
ORDER BY tr1.priority ASC
/var/www/html/focicipobolt_hu/public_html/system/library/cart/tax.php:44
9 (0.206)
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 = '1'
/var/www/html/focicipobolt_hu/public_html/system/library/cart/weight.php:10
10 (0.249)
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 = '1'
/var/www/html/focicipobolt_hu/public_html/system/library/cart/length.php:10
11 (0.367)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/cart/cart.php:15
12 (0.144)
SELECT new_url , code, store_id
FROM oc_redirect_manager
WHERE old_url = 'adidas-mls-pro-ball' AND status = 1 AND store_id = 0 LIMIT 1
/var/www/html/focicipobolt_hu/public_html/catalog/controller/extension/module/redirect_manager_pro.php:46
13 (0.637)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/var/www/html/focicipobolt_hu/public_html/catalog/model/setting/event.php:4
14 (0.518)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/var/www/html/focicipobolt_hu/public_html/catalog/model/setting/setting.php:6
15 (0.458)
SELECT *
FROM oc_seo_url
WHERE keyword = 'adidas-mls-pro-ball' AND store_id = '0'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:34
16 (0.494)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8014dcaa64b226bc84143fbca9'
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/cart/cart.php:45
17 (3.497)
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 = '1' 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 = '1' 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 = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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 IN (7241) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:29
18 (0.288)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.date_end != '0000-00-00' AND ps.date_end > NOW()) AND product_id IN (7241) GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:97
19 (0.440)
SELECT pi.product_id, pi.image
FROM oc_product_image pi
INNER JOIN ( SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (7241) GROUP BY product_id ) pi2
WHERE pi.product_id = pi2.product_id AND pi.sort_order = pi2.sort_order GROUP BY product_id
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:117
20 (1.069)
SELECT *
FROM oc_theme
WHERE store_id = '0'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/design/theme.php:12
21 (27.291)
SELECT *
FROM `oc_journal3_module`
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/module.php:9
22 (0.897)
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 = '1' 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 = '1' 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 = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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 = '7241' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/catalog/product.php:11
23 (0.205)
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 = '7241' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/catalog/product.php:315
24 (0.093)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/design/translation.php:18
25 (6.668)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
26 (0.143)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
27 (0.224)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
28 (0.695)
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 = '1' 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 = '1' 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 = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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 = '7241' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/catalog/product.php:11
29 (0.189)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
30 (0.224)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=7241' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
31 (0.160)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
32 (0.185)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=7241' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
33 (0.121)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
34 (0.119)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
35 (0.138)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
36 (0.110)
SELECT *
FROM oc_seo_url
WHERE `query` = 'manufacturer_id=14' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
37 (0.140)
SELECT *
FROM oc_product_image
WHERE product_id = '7241'
ORDER BY sort_order ASC
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/catalog/product.php:399
38 (0.108)
SELECT *
FROM oc_product_discount
WHERE product_id = '7241' AND customer_group_id = '1' 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
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/catalog/product.php:393
39 (0.100)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7241'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
40 (0.141)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
41 (0.535)
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 = '7241' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/catalog/product.php:343
42 (0.247)
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 = '7241' AND pov.product_option_id = '10265' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/catalog/product.php:348
43 (0.166)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
44 (0.181)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=7241' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
45 (0.180)
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 = '7241' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/catalog/product.php:315
46 (0.156)
SELECT rd.*
FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id
WHERE pr.product_id = 7241 AND status = '1' AND pr.customer_group_id = '1'
ORDER BY sort_order ASC
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/catalog/product.php:541
47 (0.131)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '7241'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/catalog/product.php:4
48 (0.116)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '7241' AND store_id = '0'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/catalog/product.php:417
49 (0.193)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/catalog/model/design/layout.php:4
50 (0.533)
SELECT p.post_id, p.image, p.date_created as date, p.views, pd.name, pd.description, a.username, a.firstname, a.lastname, ( SELECT count(*)
FROM `oc_journal3_blog_comments` bc
WHERE bc.post_id = p.post_id AND bc.status = 1 AND bc.parent_id = 0 ) as comments
FROM `oc_journal3_blog_post` p
LEFT JOIN `oc_journal3_blog_post_to_product` p2p ON p.post_id = p2p.post_id
LEFT JOIN `oc_journal3_blog_post_description` pd ON p.post_id = pd.post_id
LEFT JOIN `oc_user` a ON p.author_id = a.user_id
WHERE pd.language_id = '1' AND p2p.product_id = 7241 AND p.date_created <= NOW() AND p.status = 1
ORDER BY pd.name ASC LIMIT 0, 8
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/blog.php:322
51 (0.114)
SELECT *
FROM `oc_product_to_category`
WHERE product_id = '7241'
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:208
52 (1.312)
SELECT *
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_product_to_category` p2c ON (p.product_id = p2c.product_id)
LEFT JOIN `oc_category` c ON (c.category_id = p2c.category_id)
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id IN (103) AND p.status = '1' AND p.date_available <= NOW() AND pd.language_id = '1' AND p2s.store_id = '0' AND c.status = '1' AND c2s.store_id = '0' AND p.product_id != '7241' AND p.quantity > 0
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 10
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:279
53 (1.487)
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 = '1' 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 = '1' 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 = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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 IN (7093,7094,7317,5288,7161,7162,5473,6210,5203,6209) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:29
54 (0.236)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.date_end != '0000-00-00' AND ps.date_end > NOW()) AND product_id IN (7093,7094,7317,5288,7161,7162,5473,6210,5203,6209) GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:97
55 (0.375)
SELECT pi.product_id, pi.image
FROM oc_product_image pi
INNER JOIN ( SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (7093,7094,7317,5288,7161,7162,5473,6210,5203,6209) GROUP BY product_id ) pi2
WHERE pi.product_id = pi2.product_id AND pi.sort_order = pi2.sort_order GROUP BY product_id
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:117
56 (0.112)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 7093
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
57 (0.118)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7093'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
58 (0.108)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
59 (0.096)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 7093
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
60 (0.136)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7093'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
61 (0.119)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
62 (6.121)
SELECT *
FROM oc_seo_url
WHERE store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/journal3/url.php:102
63 (0.380)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 14
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/journal3/productextras.php:240
64 (0.146)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 7094
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
65 (0.160)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7094'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
66 (0.143)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
67 (0.092)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 7094
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
68 (0.089)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7094'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
69 (0.094)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
70 (0.072)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 14
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/journal3/productextras.php:240
71 (0.132)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 7317
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
72 (0.155)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7317'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
73 (0.151)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
74 (0.102)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 7317
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
75 (0.109)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7317'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
76 (0.137)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
77 (0.117)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 14
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/journal3/productextras.php:240
78 (0.143)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5288
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
79 (0.101)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5288'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
80 (0.097)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
81 (0.119)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5288
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
82 (0.088)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5288'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
83 (0.095)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
84 (0.075)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/journal3/productextras.php:240
85 (0.126)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 7161
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
86 (0.091)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7161'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
87 (0.100)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
88 (0.105)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 7161
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
89 (0.087)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7161'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
90 (0.090)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
91 (0.072)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/journal3/productextras.php:240
92 (0.101)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 7162
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
93 (0.111)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7162'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
94 (0.092)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
95 (0.086)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 7162
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
96 (0.098)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7162'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
97 (0.092)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
98 (0.070)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/journal3/productextras.php:240
99 (0.098)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5473
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
100 (0.085)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5473'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
101 (0.093)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
102 (0.083)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5473
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
103 (0.091)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5473'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
104 (0.106)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
105 (0.071)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/journal3/productextras.php:240
106 (0.112)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6210
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
107 (0.091)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6210'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
108 (0.125)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
109 (0.093)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6210
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
110 (0.086)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6210'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
111 (0.118)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
112 (0.083)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/journal3/productextras.php:240
113 (0.121)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5203
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
114 (0.129)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5203'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
115 (0.107)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
116 (0.087)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5203
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
117 (0.124)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5203'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
118 (0.136)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
119 (0.124)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/journal3/productextras.php:240
120 (0.114)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6209
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
121 (0.094)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6209'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
122 (0.106)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
123 (0.108)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6209
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
124 (0.088)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6209'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
125 (0.096)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
126 (0.108)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 13
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/journal3/productextras.php:240
127 (0.539)
SELECT DISTINCT op1.product_id
FROM `oc_order_product` op1
LEFT JOIN `oc_order_product` op2 ON op1.order_id = op2.order_id
LEFT JOIN `oc_product` p ON (op1.product_id = p.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE op2.product_id IN (7241) AND op1.product_id NOT IN (7241) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.quantity > 0 LIMIT 0, 10
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:371
128 (0.237)
SELECT p.product_id
FROM `oc_product` p
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p.product_id IN (7241) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.quantity > 0
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:424
129 (0.604)
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 = '1' 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 = '1' 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 = '1' LIMIT 1) AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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 IN (7241) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:29
130 (0.158)
SELECT *
FROM oc_product_special ps
WHERE ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND ps.date_end != '0000-00-00' AND ps.date_end > NOW()) AND product_id IN (7241) GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:97
131 (0.257)
SELECT pi.product_id, pi.image
FROM oc_product_image pi
INNER JOIN ( SELECT product_id, MIN(sort_order) AS sort_order
FROM oc_product_image
WHERE product_id IN (7241) GROUP BY product_id ) pi2
WHERE pi.product_id = pi2.product_id AND pi.sort_order = pi2.sort_order GROUP BY product_id
/var/www/html/focicipobolt_hu/public_html/catalog/model/journal3/product.php:117
132 (0.122)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 7241
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
133 (0.147)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7241'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
134 (0.135)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
135 (0.120)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 7241
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
136 (0.110)
SELECT *
FROM oc_product_to_category
WHERE product_id = '7241'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
137 (0.097)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '103'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
138 (0.115)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6330
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
139 (0.119)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6330'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
140 (0.101)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
141 (0.142)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6330
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
142 (0.119)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6330'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
143 (0.104)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
144 (0.105)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6318
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
145 (0.090)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6318'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
146 (0.096)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
147 (0.084)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 6318
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
148 (0.144)
SELECT *
FROM oc_product_to_category
WHERE product_id = '6318'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
149 (0.103)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
150 (0.126)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5925
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
151 (0.089)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5925'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
152 (0.095)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
153 (0.086)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 5925
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
154 (0.089)
SELECT *
FROM oc_product_to_category
WHERE product_id = '5925'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
155 (0.151)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
156 (0.105)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 4168
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
157 (0.094)
SELECT *
FROM oc_product_to_category
WHERE product_id = '4168'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
158 (0.094)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
159 (0.087)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 4168
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
160 (0.085)
SELECT *
FROM oc_product_to_category
WHERE product_id = '4168'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
161 (0.093)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
162 (0.110)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 3652
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
163 (0.089)
SELECT *
FROM oc_product_to_category
WHERE product_id = '3652'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
164 (0.093)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
165 (0.086)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 3652
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
166 (0.082)
SELECT *
FROM oc_product_to_category
WHERE product_id = '3652'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
167 (0.093)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
168 (0.113)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2190
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
169 (0.088)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2190'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
170 (0.092)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '109'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
171 (0.089)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '80'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
172 (0.083)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 2190
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
173 (0.082)
SELECT *
FROM oc_product_to_category
WHERE product_id = '2190'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
174 (0.087)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '109'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
175 (0.085)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '80'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
176 (0.109)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 3716
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
177 (0.089)
SELECT *
FROM oc_product_to_category
WHERE product_id = '3716'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
178 (0.092)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
179 (0.083)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 3716
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
180 (0.083)
SELECT *
FROM oc_product_to_category
WHERE product_id = '3716'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
181 (0.091)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '115'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
182 (0.127)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 4756
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
183 (0.089)
SELECT *
FROM oc_product_to_category
WHERE product_id = '4756'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
184 (0.142)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '100'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
185 (0.096)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '83'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
186 (0.088)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '80'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
187 (0.083)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 4756
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:163
188 (0.097)
SELECT *
FROM oc_product_to_category
WHERE product_id = '4756'
ORDER BY category_id DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:129
189 (0.135)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '100'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
190 (0.104)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '83'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
191 (0.091)
SELECT c.category_id, cd1.name AS name, c.parent_id
FROM oc_category c
LEFT JOIN oc_category_description cd1 ON (c.category_id = cd1.category_id)
WHERE cd1.language_id = '1' AND c.category_id = '80'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:157
192 (0.331)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/var/www/html/focicipobolt_hu/public_html/catalog/model/setting/setting.php:6
193 (0.225)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
194 (0.148)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/return/add' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
195 (0.126)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/sitemap' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
196 (0.141)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/tracking' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
197 (0.165)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
198 (0.123)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/voucher' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
199 (0.137)
SELECT *
FROM oc_seo_url
WHERE `query` = 'affiliate/login' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
200 (0.136)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
201 (0.114)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
202 (0.128)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
203 (0.163)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
204 (0.160)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/newsletter' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
205 (0.537)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/var/www/html/focicipobolt_hu/public_html/catalog/model/setting/setting.php:6
206 (0.268)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/html/focicipobolt_hu/public_html/catalog/model/setting/extension.php:4
207 (0.123)
SELECT *
FROM oc_country
WHERE country_id = '97'
/var/www/html/focicipobolt_hu/public_html/system/library/tagmanager.php:1056
208 (0.221)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
209 (0.155)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
210 (0.125)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
211 (0.143)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
212 (0.162)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
213 (0.119)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
214 (0.113)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
215 (0.113)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
216 (0.150)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/transaction' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
217 (0.137)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/download' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
218 (0.150)
SELECT *
FROM oc_seo_url
WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
219 (0.172)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
220 (0.164)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
221 (0.139)
SELECT *
FROM oc_seo_url
WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
222 (0.177)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
223 (0.223)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
224 (0.195)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=7241' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
225 (0.156)
SELECT *
FROM oc_seo_url
WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
226 (0.160)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
227 (0.243)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=7241' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
228 (0.182)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/search' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
229 (0.177)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8014dcaa64b226bc84143fbca9'
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/cart/cart.php:45
230 (0.097)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/html/focicipobolt_hu/public_html/catalog/model/setting/extension.php:4
231 (0.133)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8014dcaa64b226bc84143fbca9'
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/cart/cart.php:45
232 (0.114)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8014dcaa64b226bc84143fbca9'
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/cart/cart.php:45
233 (0.111)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/html/focicipobolt_hu/public_html/system/library/cart/customer.php:122
234 (0.121)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8014dcaa64b226bc84143fbca9'
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/cart/cart.php:45
235 (0.115)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8014dcaa64b226bc84143fbca9'
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/cart/cart.php:45
236 (0.171)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
237 (0.132)
SELECT *
FROM oc_seo_url
WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
238 (0.133)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8014dcaa64b226bc84143fbca9'
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/cart/cart.php:45
239 (0.100)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/html/focicipobolt_hu/public_html/catalog/model/setting/extension.php:4
240 (0.122)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8014dcaa64b226bc84143fbca9'
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/cart/cart.php:45
241 (0.107)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8014dcaa64b226bc84143fbca9'
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/cart/cart.php:45
242 (0.086)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/html/focicipobolt_hu/public_html/system/library/cart/customer.php:122
243 (0.122)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '8014dcaa64b226bc84143fbca9'
/var/www/html/focicipobolt_hu/public_html/storage/modification/system/library/cart/cart.php:45
244 (0.993)
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 = '1' 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 = '1' 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 = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') 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 = '1') 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 = '1') 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 = '7241' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/model/catalog/product.php:11
245 (0.242)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
246 (0.273)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=7241' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
247 (0.175)
SELECT r.review_id, r.author, r.rating, r.text, p.product_id, pd.name, p.price, p.image, r.date_added
FROM oc_review r
LEFT JOIN oc_product p ON (r.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
WHERE p.product_id = '7241' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '1'
ORDER BY r.date_added DESC LIMIT 1
/var/www/html/focicipobolt_hu/public_html/catalog/controller/journal3/seo.php:335
248 (0.289)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/var/www/html/focicipobolt_hu/public_html/catalog/model/setting/setting.php:6
249 (0.203)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/search' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
250 (0.163)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:116
251 (0.205)
SELECT *
FROM oc_seo_url
WHERE `query` = 'product_id=7241' AND store_id = '0' AND language_id = '1'
/var/www/html/focicipobolt_hu/public_html/storage/modification/catalog/controller/startup/seo_url.php:105
252 (0.329)
SELECT *
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
WHERE m.manufacturer_id = '14' AND m2s.store_id = '0'
/var/www/html/focicipobolt_hu/public_html/catalog/model/catalog/manufacturer.php:4
253 (0.410)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/var/www/html/focicipobolt_hu/public_html/catalog/model/setting/setting.php:6