### Rewrite Rules ###
### Page processing ###
Colosseum Beauty Style Salon

Colosseum Beauty Style Salon

Colosseum Beauty Style Salon a inceput sa-si scrie propria poveste in anul 2010: o poveste despre un loc in care poti uita de toate, un loc cald, cu oameni atenti la nevoile celorlalti, in care invatam impreuna sa avem grija de frumusete. Unii dintre voi au aflat aceasta poveste si au spus-o mai departe.
In opinia Colosseum Beauty Style Salon, frumusetea reprezinta imaginea cartii de vizita a oricarei persoane care, pusa in valoare de mainile unor profesionisti capata stil, eleganta si mai ales personalitate vizuala… sa fim sinceri, cu totii ne dorim acest lucru!

Echipa noastra de profesionisti intelege frumusetea ca pe o provocare si urmareste ca in materie de coafor, frizerie, manechiura, pedichiura si cosmetica sa obtina cele mai bune rezultate la cele mai bune preturi.

Va stam la dispozitie cu personal atent selectionat, foarte bine pregatit si deosebit de amabil si primitor, cu aparatura de inalta performanta, produse profesionale de lux, exclusiviste, utilizate si apreciate in saloane de renume international, intr-un mediu deosebit de elegant si rafinat, toate acestea pentru a fi in masura sa satisfacem si cele mai exigente pretentii.

Si nu in ultimul rand, acordam o importanta deosebita preturilor practicate in salonul nostru ,venind in intampinarea cerintelor dumneavoastra cu tarife mai mult decat rezonabile, flexibile, dar si cu oferte speciale deosebite .


Pentru clientii fideli am realizat 3 carduri dupa cum urmeaza:

Card SILVER: pentru servicii realizate in salon cu valoare intre 100 si 200 lei - discount de 5%
Card GOLD: pentru servicii realizate in salon cu valoare intre 200 si 300 lei - discount de 10%
Card PLATINIUM: pentru servicii realizate in salon peste 300 lei - discount de 15%

Promotii luna martie

Coafor - 99 lei pentru vopsit cu Oyster cu numar nelimitat de tuburi si spalat
Manichiura si Pedichiura - BONUS tratament cu parafina
Cosmetica - la un epilat total, BONUS pensat forma sau simplu, in functie de necesitate


Program:
Marti-Vineri: 10:00-20:00
Sambata: 10:00-18:00
Duminica: inchis


Adresa: Str. Sibiu nr. 4, bl OD2, sc. 6, ap 182, parter, sector 6, Bucuresti
Telefon: 0737.252.0720737.252.072

Va asteptam cu drag in salonul nostru!


Alte saloane

ASISTENTA ONLINE

Program: 9:00 - 18:00


Telefon: 0755.748.555


E-mail: laura.raduta@divahaircosmetics.ro

SALOANE RECOMANDATE

Eda Studio

HAIR STYLIST RECOMANDAT

Adina Suiu

PARTENERI MEDIA

PARTENERI ONLINE


### Req ###
Array
(
    [0] => saloane
    [1] => colosseum-beauty-style-salon
)
### Req(end) ###
SELECT id FROM branduri WHERE 1 AND url_key='saloane' [Rows: 0] [Time: 0.0002]
SELECT id FROM cms_saloane WHERE 1 AND `status`=1 AND `url_key`='colosseum-beauty-style-salon' [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`=16 [Rows: 1] [Time: 0.0001]
SELECT * FROM cms_saloane WHERE 1 AND `status`=1 AND `id`<>16 ORDER BY `data` DESC LIMIT 0,10 [Rows: 10] [Time: 0.0002]
### Page processing(end) ###
### GET ###
Array
(
    [req] => saloane/colosseum-beauty-style-salon
    [page] => saloane.details
    [id_salon] => 16
)
### GET(end) ###
SELECT * FROM cms_meta WHERE 1 AND status='1' AND url LIKE 'http://www.divahaircosmetics.ro/saloane/colosseum-beauty-style-salon' 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.0002]
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.0002]
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.0007]
SELECT id, nume, poza, url_key FROM cms_stilisti WHERE 1 AND `status`=1 ORDER BY RAND() LIMIT 0,1 [Rows: 1] [Time: 0.0004]
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.0046]
### 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.0003]
### Footer processing(end) ###
Generated in: 0.033 seconds