### Rewrite Rules ###
### Page processing ###
Vopsea de par profesionala | Oyster
oyster

Vopsea de par profesionala, cu si fara amoniac, pentru un par sanatos si stralucitor!

Par vopsit, dar sanatos si plin de stralucire! Te invitam sa descoperi paletarul de vopsea de par profesionala din brandul Oyster, Italia. Prezenta pe piata beauty din Romania incepand cu 2011 exclusiv prin intermediul companiei Diva Hair Cosmetics. Vopsea de par profesionala, disponibila in doua variante: PerlaColor, vopsea cu amoniac si PerlaColor Purity, vopsea fara amoniac. Alege acum nuanta care te defineste din gama bogata de peste 95 nuante moderne pentru linia de vopsea cu amoniac si din cele 34 nuante pentru linia de vopsea fara amoniac. Rezultate excelente inca de la prima aplicare, fara a agresa firul de par. Culoarea rezista timp indelungat pe firul de par. 

Oxidanti, pudra decoloranta, kit pentru decapaj si masti colorante Directa.

 

 

 


ASISTENTA ONLINE

Program: 9:00 - 18:00


Telefon: 0755.748.555


E-mail: laura.raduta@divahaircosmetics.ro


SALOANE RECOMANDATE

Ameenas Nails&Beauty

HAIR STYLIST RECOMANDAT

Silvia Bacrea

PARTENERI MEDIA

PARTENERI ONLINE


### Req ###
Array
(
    [0] => oyster
    [1] => colorare
    [2] => pagina
    [3] => 2
)
### Req(end) ###
SELECT id FROM branduri WHERE 1 AND url_key='oyster' [Rows: 1] [Time: 0.0002]
SELECT id FROM produse_categorii WHERE 1 AND status='1' AND url_key='colorare' AND id_brand='1' [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 branduri WHERE 1 AND  id='1' [Rows: 1] [Time: 0.0004]
SELECT * FROM produse_categorii WHERE 1 AND status='1' AND id='2' [Rows: 1] [Time: 0.0003]
SELECT COUNT(*) FROM produse WHERE 1 AND status='1' AND id_categorie='2' [Rows: 1] [Time: 0.0007]
SELECT * FROM produse WHERE 1 AND status='1' AND id_categorie='2' ORDER BY ord ASC LIMIT 15,15 [Rows: 3] [Time: 0.0006]
### Page processing(end) ###
### GET ###
Array
(
    [req] => oyster/colorare/pagina/2
    [id_brand] => 1
    [page] => produse.brand
    [id_categorie] => 2
    [nr_pag] => 2
)
### GET(end) ###
SELECT * FROM cms_meta WHERE 1 AND status='1' AND url LIKE 'http://www.divahaircosmetics.ro/oyster/colorare/pagina/2' LIMIT 0,1 [Rows: 0] [Time: 0.0002]
SELECT * FROM cms_meta WHERE 1 AND status='1' AND url LIKE 'http://www.divahaircosmetics.ro/oyster/colorare/pagina%' LIMIT 0,1 [Rows: 0] [Time: 0.0002]
### 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 slider WHERE 1 AND `status`=1 AND id_brand='1' [Rows: 1] [Time: 0.0001]
SELECT COUNT(produse_categorii.id) FROM produse_categorii WHERE 1 AND id_categorie='2' AND status=1 [Rows: 1] [Time: 0.0004]
SELECT id, nume_link, url_key FROM produse_categorii WHERE 1 AND status='1' AND id_brand='1'  AND id NOT IN (SELECT id_categorie FROM produse_categorii WHERE status=1) ORDER BY ord ASC [Rows: 5] [Time: 0.0005]
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.0003]
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.0219 seconds