Bine ati venit la centrul de infrumusetare BEAUTY SCORPION SALON SPA!
Salonul nostru dispune de un personal calificat si cu multi ani de experienta in domeniu, bine pregatit, conectat in permanenta la trendurile noi.
Folosim cele mai noi produse si de inalta calitate astfel incat sa multumim toate clientele noastre.
Servicii oferite:
Spalat si coafat -30-45Ron
Manichiura+Pedichiura OPI -40Ron
Unghii false+Pedichiura -120Ron
Curatare faciala+Pensat -70Ron
10xElectrostimulare 45' -100Ron
7XMasaj anticelulitic 50' -300Ron
7xImpachetari ciocolata/parafango in capsula SPA -250 Ron
7xImpachetari crema termosudatie in patura termica -180 Ron
7xVacuum -170 Ron
7xUltrasunete -140 Ron
Adresa: str. Sfanta Maria, nr. 96, ap. 2, Bucuresti Telefon: 021.224.21.90021.224.21.90, 0768.211.4880768.211.488, 0734.511.1250734.511.125 Website: www.beauty-scorpion-spa.ro
Program:
Luni - Vineri 09:00-21:00
Sambata: 09:00-19:00
Profita acum de promotiile speciale:
Vopsit si coafat cu produse profesionale Oyster, Italia - doar 90 lei, indiferent de numarul de tuburi
Tratament cosmetic facial cu produse profesionale ANUBIS, Spania - numai 50 lei
SELECT * FROM cms_meta WHERE 1 AND status='1' AND url LIKE 'http://www.divahaircosmetics.ro/saloane/scorpion-turda' LIMIT 0,1 [Rows: 0] [Time: 0.0001]
SELECT * FROM cms_meta WHERE 1 AND status='1' AND url LIKE 'http://www.divahaircosmetics.ro/saloane%' LIMIT 0,1 [Rows: 0] [Time: 0.0001]
### Header processing(end) ###
SELECT id,nume,url_key FROM branduri WHERE 1 AND id!=3 ORDER BY id ASC [Rows: 2] [Time: 0.0001]
SELECT url_key FROM produse_categorii WHERE 1 AND status='1' AND id_brand='1' ORDER BY ord ASC LIMIT 0,1 [Rows: 1] [Time: 0.0001]
SELECT id, nume_link, url_key FROM produse_categorii WHERE 1 AND status='1' AND id_brand='1' AND (id IN (SELECT id_categorie FROM produse_categorii WHERE status=1) OR id_categorie=0) ORDER BY ord ASC [Rows: 5] [Time: 0.0001]
SELECT url_key FROM produse_categorii WHERE 1 AND status='1' AND id_categorie='2' ORDER BY ord ASC LIMIT 0,1 [Rows: 0] [Time: 0.0001]
SELECT url_key FROM produse_categorii WHERE 1 AND status='1' AND id_categorie='4' ORDER BY ord ASC LIMIT 0,1 [Rows: 0] [Time: 0.0001]
SELECT url_key FROM produse_categorii WHERE 1 AND status='1' AND id_categorie='5' ORDER BY ord ASC LIMIT 0,1 [Rows: 0] [Time: 0.0001]
SELECT url_key FROM produse_categorii WHERE 1 AND status='1' AND id_categorie='3' ORDER BY ord ASC LIMIT 0,1 [Rows: 0] [Time: 0.0001]
SELECT url_key FROM produse_categorii WHERE 1 AND status='1' AND id_categorie='63' ORDER BY ord ASC LIMIT 0,1 [Rows: 0] [Time: 0.0001]
SELECT url_key FROM produse_categorii WHERE 1 AND status='1' AND id_brand='2' ORDER BY ord ASC LIMIT 0,1 [Rows: 1] [Time: 0.0001]
SELECT id, nume_link, url_key FROM produse_categorii WHERE 1 AND status='1' AND id_brand='2' AND (id IN (SELECT id_categorie FROM produse_categorii WHERE status=1) OR id_categorie=0) ORDER BY ord ASC [Rows: 4] [Time: 0.0001]
SELECT url_key FROM produse_categorii WHERE 1 AND status='1' AND id_categorie='19' ORDER BY ord ASC LIMIT 0,1 [Rows: 1] [Time: 0.0001]
SELECT url_key FROM produse_categorii WHERE 1 AND status='1' AND id_categorie='36' ORDER BY ord ASC LIMIT 0,1 [Rows: 1] [Time: 0.0001]
SELECT url_key FROM produse_categorii WHERE 1 AND status='1' AND id_categorie='46' ORDER BY ord ASC LIMIT 0,1 [Rows: 1] [Time: 0.0001]
SELECT url_key FROM produse_categorii WHERE 1 AND status='1' AND id_categorie='62' ORDER BY ord ASC LIMIT 0,1 [Rows: 0] [Time: 0.0001]
SELECT id, titlu, nume_link FROM cms_pagini WHERE 1 AND `status`=1 AND `nume`='testimoniale' ORDER BY `ord` ASC [Rows: 2] [Time: 0.0001]
SELECT * FROM articole WHERE 1 AND `publish`=1 ORDER BY `data` DESC LIMIT 0,5 [Rows: 5] [Time: 0.0001]
SELECT nume, data, url_key, (SELECT imagine FROM albume_poze WHERE `cover`=1 AND `id_album`=albume.id LIMIT 1) AS imagine FROM albume WHERE 1 AND `status`=1 ORDER BY `data` DESC LIMIT 0,3 [Rows: 3] [Time: 0.0001]
SELECT id, nume, poza, url_key FROM cms_saloane WHERE 1 AND `status`=1 ORDER BY RAND() LIMIT 0,1 [Rows: 1] [Time: 0.0005]
SELECT id, nume, poza, url_key FROM cms_stilisti WHERE 1 AND `status`=1 ORDER BY RAND() LIMIT 0,1 [Rows: 1] [Time: 0.0002]
SELECT id, nume, link, imagine FROM parteneri WHERE 1 AND `status`=1 AND `tip`=1 ORDER BY `ord` ASC [Rows: 12] [Time: 0.0001]
SELECT id, nume, link, imagine FROM parteneri WHERE 1 AND `status`=1 AND `tip`=2 ORDER BY `ord` ASC [Rows: 6] [Time: 0.0001]
### Box Right processing(end) ###
SELECT nume_link, url_key FROM cms_pagini WHERE 1 AND `status`='1' ORDER BY `ord` ASC [Rows: 5] [Time: 0.0001]