### Rewrite Rules ###
### Page processing ###
Scorpion Turda

Scorpion Turda

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


Contacteaza-ne acum pentru o programare!


Alte saloane

ASISTENTA ONLINE

Program: 9:00 - 18:00


Telefon: 0755.748.555


E-mail: laura.raduta@divahaircosmetics.ro

SALOANE RECOMANDATE

Dollys Beauty Salon

HAIR STYLIST RECOMANDAT

Silvia Bacrea

PARTENERI MEDIA

PARTENERI ONLINE


### Req ###
Array
(
    [0] => saloane
    [1] => scorpion-turda
)
### Req(end) ###
SELECT id FROM branduri WHERE 1 AND url_key='saloane' [Rows: 0] [Time: 0.0001]
SELECT id FROM cms_saloane WHERE 1 AND `status`=1 AND `url_key`='scorpion-turda' [Rows: 1] [Time: 0.0001]
### Rewrite Rules(end) ###
SELECT * FROM back_email WHERE 1 LIMIT 0,1 [Rows: 1] [Time: 0.0001]
SET group_concat_max_len = 500000 [Rows: 0] [Time: 0.0001]
### Box preload processing(end) ###
SELECT * FROM cms_saloane WHERE 1 AND `id`=15 [Rows: 1] [Time: 0.0001]
SELECT * FROM cms_saloane WHERE 1 AND `status`=1 AND `id`<>15 ORDER BY `data` DESC LIMIT 0,10 [Rows: 10] [Time: 0.0002]
### Page processing(end) ###
### GET ###
Array
(
    [req] => saloane/scorpion-turda
    [page] => saloane.details
    [id_salon] => 15
)
### GET(end) ###
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.0003]
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]
### Footer processing(end) ###
Generated in: 0.0128 seconds