Bemutatkozás

Szolgáltatásainkban és kezeléseinkben a megszokott kozmetikai és szépészeti kezelésekkel ellentétben, kifejezetten orvosi háttér mellett történő, igazán hatékony kezelésekre fókuszálunk. Minden kezelést a szakterületnek megfelelő szakorvosunk indít el és zár le, ezzel is maximalizálva a várható eredményt.

Cégünk exkluzív lézeres stratégiai partnere az Alma Lasers, abszolút világvezető orvosi lézer technológiában, egyedülálló 20 éves nemzetközi tapasztalattal, több millió eredményes kezeléssel, kizárólag nagyértékű, sokat bizonyított gépekkel.

Orvoscentrumunk az Alma Lasers európai partnere, Közép-Európában egyedülálló lézer és orvosi műszerparkkal. A műszeres kezelések spektruma elsősorban non-ablatív, non-invazív és minimális invazív kezelésekre összpontosít, de széndioxid lézeres hámlasztástól, nőgyógyászati komfort kezeléseken át, az izzadás lézeres megszüntetéséig, széles területet fedünk le. Az esztétikai és komfort kezelések mellett diagnosztikával, tanácsadással, általános orvosi ellátással is foglalkozunk.

Egyedülálló szépészeti kezelések Egyedülálló eszközparkkal, a legmodernebb szépészeti eljárásokkal várjuk a Szegi Medical Szépészeti Centrumban. Versenyképes árak Nálunk kedvező árakat, kedvezményes árú kezeléscsomagokat talál, akcióinkban még jobb áron veheti igénybe szolgáltatásainkat. Kiemelkedő tudású szakorvosok Szakorvosaink nagy tudással és tapasztalattal rendelkeznek szakterületükön, a pácienseket türelemmel, empátiával várják.

Queries: 65, Total time: 48.358 ms [By time] [By id] [By file]
1 (0.054)
SET time_zone = '+00:00'
/var/www/vhosts/szegimedshop.com/httpdocs/system/framework.php:84
2 (0.260)
SELECT `data`
FROM `oc_session`
WHERE `session_id` = 'eabf9693a2f91780c06507da06' AND `expire` > '2024-09-08 00:31:54'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/session/db.php:16
3 (0.153)
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 (2.499)
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.089)
SET time_zone = '+02:00'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/controller/startup/startup.php:40
6 (0.212)
SELECT *
FROM oc_currency
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/cart/currency.php:10
7 (0.782)
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.359)
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.330)
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.408)
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.210)
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.274)
SELECT new_url , code, store_id
FROM oc_redirect_manager
WHERE old_url = 'index.php?information_id=4&route=information/information' 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.485)
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.269)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'eabf9693a2f91780c06507da06'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/cart/cart.php:45
15 (0.293)
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
16 (0.378)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '4' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/catalog/information.php:4
17 (0.279)
SELECT *
FROM oc_information_to_layout
WHERE information_id = '4' AND store_id = '0'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/catalog/information.php:16
18 (0.363)
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 (0) 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:424
19 (0.404)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 481
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
20 (0.254)
SELECT *
FROM oc_product_to_category
WHERE product_id = '481'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
21 (0.301)
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 = '1'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
22 (0.338)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 515
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
23 (0.233)
SELECT *
FROM oc_product_to_category
WHERE product_id = '515'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
24 (0.245)
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 = '4'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
25 (0.331)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 204
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
26 (0.232)
SELECT *
FROM oc_product_to_category
WHERE product_id = '204'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
27 (0.250)
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 = '1'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
28 (0.217)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 316
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
29 (0.228)
SELECT *
FROM oc_product_to_category
WHERE product_id = '316'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
30 (0.236)
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 = '1'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
31 (0.202)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 320
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
32 (0.197)
SELECT *
FROM oc_product_to_category
WHERE product_id = '320'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
33 (0.226)
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 = '1'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
34 (0.205)
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
35 (0.199)
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
36 (0.224)
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
37 (0.202)
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
38 (0.201)
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
39 (0.239)
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
40 (0.532)
SELECT m.name
from oc_manufacturer m
left join oc_product p on m.manufacturer_id = p.manufacturer_id
WHERE p.product_id = 214
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:163
41 (0.276)
SELECT *
FROM oc_product_to_category
WHERE product_id = '214'
ORDER BY category_id DESC LIMIT 1
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:129
42 (0.251)
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 = '1'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:157
43 (0.230)
SELECT *
FROM oc_theme
WHERE store_id = '0'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/catalog/model/design/theme.php:12
44 (0.513)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/setting/setting.php:6
45 (0.502)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/setting/setting.php:6
46 (0.413)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/setting/setting.php:6
47 (26.649)
SELECT *
FROM `oc_journal3_module`
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/journal3/module.php:9
48 (0.628)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'isenselabs_gdpr'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/setting/setting.php:6
49 (0.268)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/setting/extension.php:4
50 (0.266)
SELECT *
FROM oc_country
WHERE country_id = '97'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/tagmanager.php:1056
51 (0.441)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'eabf9693a2f91780c06507da06'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/cart/cart.php:45
52 (0.210)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/setting/extension.php:4
53 (0.342)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'eabf9693a2f91780c06507da06'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/cart/cart.php:45
54 (0.328)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'eabf9693a2f91780c06507da06'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/cart/cart.php:45
55 (0.233)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/cart/customer.php:122
56 (0.335)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'eabf9693a2f91780c06507da06'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/cart/cart.php:45
57 (0.327)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'eabf9693a2f91780c06507da06'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/cart/cart.php:45
58 (0.369)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'eabf9693a2f91780c06507da06'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/cart/cart.php:45
59 (0.229)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/setting/extension.php:4
60 (0.329)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'eabf9693a2f91780c06507da06'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/cart/cart.php:45
61 (0.264)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'eabf9693a2f91780c06507da06'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/cart/cart.php:45
62 (0.228)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/var/www/vhosts/szegimedshop.com/httpdocs/system/library/cart/customer.php:122
63 (0.328)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = 'eabf9693a2f91780c06507da06'
/var/www/vhosts/szegimedshop.com/httpdocs/storage/modification/system/library/cart/cart.php:45
64 (0.498)
SELECT DISTINCT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i.information_id = '4' AND id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/catalog/information.php:4
65 (0.508)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `code` = 'advertise_google'
/var/www/vhosts/szegimedshop.com/httpdocs/catalog/model/setting/setting.php:6