Clarity II Férfi szőrtelenítés teljes arc területen (bajusz, áll, orca, vagy pajesz)

Clarity II Férfi szőrtelenítés teljes arc területen  (bajusz, áll, orca, vagy pajesz)
Clarity II Férfi szőrtelenítés teljes arc területen (bajusz, áll, orca, vagy pajesz)
SZMK-00201
54.000 Ft
Nettó ár: 42.520 Ft

Kérjük, válasszon méretet!

Arc
Kezelési terület (Arc) Bajusz, Áll, Orca, Pajesz
Kezelések alkalma (esemény)
Kezelések alkalma Bérlet
Nem
Nemek szerint Férfi
Márka
Kezelés neve Clarity II
Márka: Clarity II Készletállapot: Készleten
96.001 Ft
Nettó ár:75.591 Ft
Kosárba
Márka: Clarity II Készletállapot: Készleten
114.000 Ft
Nettó ár:89.764 Ft
Kosárba
Márka: Clarity II Készletállapot: Készleten
132.000 Ft
Nettó ár:103.937 Ft
Kosárba
Márka: Clarity II Készletállapot: Készleten
156.000 Ft
Nettó ár:122.835 Ft
Kosárba
Márka: Clarity II Készletállapot: Készleten
192.000 Ft
Nettó ár:151.181 Ft
Kosárba
Márka: Clarity II Készletállapot: Készleten
54.000 Ft
Nettó ár:42.520 Ft
Kosárba
Márka: Clarity II Készletállapot: Készleten
12.501 Ft
Nettó ár:9.843 Ft
Kosárba
Márka: Clarity II Készletállapot: Készleten
25.000 Ft
Nettó ár:19.685 Ft
Kosárba
Márka: Clarity II Készletállapot: Készleten
35.999 Ft
Nettó ár:28.346 Ft
Kosárba
Márka: Clarity II Készletállapot: Készleten
48.000 Ft
Nettó ár:37.795 Ft
Kosárba
Queries: 154, Total time: 95.701 ms [By time] [By id] [By file]
1 (0.071)
SET time_zone = '+00:00'
/var/www/vhosts/szegimedshop.com/httpdocs/system/framework.php:84
2 (0.498)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = '5767c2bb46c6abd78404eb0e89' AND `expire` > '2024-12-09 23:05:00'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/session/db.php:16
3 (0.278)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://szegimedshop.com/'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/controller/startup/startup.php:6
4 (3.564)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/controller/startup/startup.php:25
5 (0.121)
SET time_zone = '+01:00'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/controller/startup/startup.php:40
6 (0.313)
SELECT *
FROM oc_currency
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/cart/currency.php:10
7 (0.920)
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/vhosts/szegimedshop.com/httpdocs/system/library/cart/tax.php:16
8 (0.721)
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/vhosts/szegimedshop.com/httpdocs/system/library/cart/tax.php:44
9 (0.508)
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/vhosts/szegimedshop.com/httpdocs/system/library/cart/weight.php:10
10 (0.401)
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/vhosts/szegimedshop.com/httpdocs/system/library/cart/length.php:10
11 (0.278)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/cart/cart.php:15
12 (0.428)
SELECT new_url , code, store_id
FROM oc_redirect_manager
WHERE old_url = 'index.php?route=product/product&product_id=291' AND status = 1 AND store_id = 0 LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/controller/extension/module/redirect_manager_pro.php:46
13 (0.888)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/setting/event.php:4
14 (0.392)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '5767c2bb46c6abd78404eb0e89'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/cart/cart.php:45
15 (1.480)
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 (291) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/journal3/product.php:29
16 (0.244)
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 (291) GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/journal3/product.php:92
17 (0.285)
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 (291) 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/vhosts/szegimedshop.com/httpdocs/catalog/model/journal3/product.php:109
18 (31.078)
SELECT *
FROM `oc_journal3_module`
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/journal3/module.php:9
19 (1.368)
SHOW columns
from oc_product
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:12
20 (1.332)
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 = '291' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:21
21 (0.809)
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 = '291' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:327
22 (0.973)
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 = '291' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:332
23 (0.856)
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 = '291' AND a.attribute_group_id = '5' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:332
24 (0.835)
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 = '291' AND a.attribute_group_id = '11' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:332
25 (0.872)
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 = '291' AND a.attribute_group_id = '14' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:332
26 (0.283)
SELECT *
FROM oc_theme
WHERE store_id = '0'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/design/theme.php:12
27 (0.247)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '1'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/design/translation.php:18
28 (1.105)
SHOW columns
from oc_product
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:12
29 (1.080)
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 = '291' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:21
30 (0.215)
CREATE TABLE if not exists oc_mennyisegi_egyseg ( mennyisegi_egyseg_id int(11) AUTO_INCREMENT, language_id int(11), `name` varchar(32), PRIMARY KEY (mennyisegi_egyseg_id, language_id) ) engine=MyISAM default charset=UTF8
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/extension/module/mennyisegi_egyseg.php:6
31 (0.176)
SELECT *
FROM oc_mennyisegi_egyseg
WHERE mennyisegi_egyseg_id = '0' AND language_id = '1'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/extension/module/mennyisegi_egyseg.php:12
32 (0.230)
SELECT *
FROM oc_product_image
WHERE product_id = '291'
ORDER BY sort_order ASC
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:411
33 (0.338)
SELECT *
FROM oc_product_discount
WHERE product_id = '291' 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/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:405
34 (0.228)
SELECT *
FROM oc_product_to_category
WHERE product_id = '291'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
35 (0.277)
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 = '2'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
36 (1.101)
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 = '291' AND od.language_id = '1'
ORDER BY o.sort_order
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:355
37 (0.733)
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 = '291' AND pov.product_option_id = '53' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:360
38 (0.629)
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 = '291' AND pov.product_option_id = '54' AND ovd.language_id = '1'
ORDER BY ov.sort_order
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:360
39 (0.173)
SELECT `product_option_limit`
FROM `oc_product_option_limiter`
WHERE `product_id` = '291' AND `product_option_id` = '54'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:380
40 (0.195)
SELECT *
FROM oc_product_option_parent
WHERE product_id = '291' AND product_option_id = '53'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/controller/extension/module/dependent_options.php:123
41 (0.132)
SELECT *
FROM oc_product_option_parent
WHERE product_id = '291' AND product_option_id = '54'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/controller/extension/module/dependent_options.php:123
42 (0.533)
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 = '291' AND agd.language_id = '1' GROUP BY ag.attribute_group_id
ORDER BY ag.sort_order, agd.name
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:327
43 (0.892)
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 = '291' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:332
44 (0.839)
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 = '291' AND a.attribute_group_id = '5' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:332
45 (0.857)
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 = '291' AND a.attribute_group_id = '11' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:332
46 (0.860)
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 = '291' AND a.attribute_group_id = '14' AND ad.language_id = '1' AND pa.language_id = '1'
ORDER BY a.sort_order, ad.name
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:332
47 (0.337)
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 = 291 AND status = '1' AND pr.customer_group_id = '1'
ORDER BY sort_order ASC
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:553
48 (0.346)
UPDATE oc_product SET viewed = (viewed + 1)
WHERE product_id = '291'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:4
49 (0.211)
SELECT *
FROM oc_product_to_layout
WHERE product_id = '291' AND store_id = '0'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/catalog/product.php:429
50 (0.454)
SELECT *
FROM oc_layout_route
WHERE 'product/product' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/design/layout.php:4
51 (0.565)
SELECT c.category_id
FROM `oc_category` c
LEFT JOIN `oc_category_to_store` c2s ON (c.category_id = c2s.category_id)
LEFT JOIN `oc_product_to_category` p2c ON (c.category_id = p2c.category_id)
LEFT JOIN `oc_product` p ON (p2c.product_id = p.product_id)
LEFT JOIN `oc_product_to_store` p2s ON (p.product_id = p2s.product_id)
WHERE p2c.product_id IN (291) AND c.status = '1' AND c2s.store_id = '0' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' GROUP BY c.category_id
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/journal3/product.php:237
52 (2.903)
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 (2) 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 != '291'
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0, 10
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/journal3/product.php:279
53 (3.117)
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 (293,294,295,296,298,292,300,299,290,281) AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/journal3/product.php:29
54 (0.264)
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 (293,294,295,296,298,292,300,299,290,281) GROUP BY ps.product_id
ORDER BY ps.priority ASC, ps.price ASC
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/journal3/product.php:92
55 (0.330)
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 (293,294,295,296,298,292,300,299,290,281) 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/vhosts/szegimedshop.com/httpdocs/catalog/model/journal3/product.php:109
56 (0.212)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 293
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
57 (0.198)
SELECT *
FROM oc_product_to_category
WHERE product_id = '293'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
58 (0.218)
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 = '2'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
59 (0.154)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 28
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/journal3/productextras.php:239
60 (0.320)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 294
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
61 (0.211)
SELECT *
FROM oc_product_to_category
WHERE product_id = '294'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
62 (0.244)
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 = '2'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
63 (0.165)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 28
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/journal3/productextras.php:239
64 (0.195)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 295
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
65 (0.188)
SELECT *
FROM oc_product_to_category
WHERE product_id = '295'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
66 (0.209)
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 = '2'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
67 (0.148)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 28
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/journal3/productextras.php:239
68 (0.183)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 296
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
69 (0.182)
SELECT *
FROM oc_product_to_category
WHERE product_id = '296'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
70 (0.263)
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 = '2'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
71 (0.153)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 28
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/journal3/productextras.php:239
72 (0.182)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 298
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
73 (0.182)
SELECT *
FROM oc_product_to_category
WHERE product_id = '298'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
74 (0.206)
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 = '2'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
75 (0.148)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 28
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/journal3/productextras.php:239
76 (0.183)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 292
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
77 (0.177)
SELECT *
FROM oc_product_to_category
WHERE product_id = '292'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
78 (0.202)
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 = '2'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
79 (0.145)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 28
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/journal3/productextras.php:239
80 (0.194)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 300
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
81 (0.239)
SELECT *
FROM oc_product_to_category
WHERE product_id = '300'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
82 (0.207)
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 = '2'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
83 (0.145)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 28
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/journal3/productextras.php:239
84 (0.184)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 299
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
85 (0.176)
SELECT *
FROM oc_product_to_category
WHERE product_id = '299'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
86 (0.202)
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 = '2'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
87 (0.144)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 28
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/journal3/productextras.php:239
88 (0.177)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 290
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
89 (0.182)
SELECT *
FROM oc_product_to_category
WHERE product_id = '290'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
90 (0.199)
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 = '2'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
91 (0.148)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 28
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/journal3/productextras.php:239
92 (0.228)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 281
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
93 (0.194)
SELECT *
FROM oc_product_to_category
WHERE product_id = '281'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
94 (0.199)
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 = '2'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
95 (0.144)
SELECT *
FROM oc_manufacturer
WHERE manufacturer_id = 28
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/journal3/productextras.php:239
96 (0.550)
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 (291) AND op1.product_id NOT IN (291) AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' LIMIT 0, 10
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/journal3/product.php:371
97 (0.329)
SELECT p.product_id
FROM `oc_product` p
LEFT JOI