### Rewrite Rules ###
### Page processing ###
Sampon anti-pigment galben GO COLOR ICEBLOND
oyster

Sampon anti-pigment galben GO COLOR ICEBLOND

Sampon anti-pigment galben GO COLOR ICEBLOND

DESCRIERE: Sampon anti-pigment galben special pentru neutralizarea tonurilor nedorite de galben. Curata delicat scalpul si fibra capilara. Sporeste stralucirea si intensitatea cromatica a parului blond natural sau blond vopsit, pentru a accentua reflexele platinate reci.

Are efect antioxidant, impiedicand astfel formarea radicalilor liberi si protejeaza impotriva imbatranirii.

UTILIZARE: Se aplica pe parul umed, se lasa sa actioneze 3-5 minute, apoi se clateste.

CANTITATE:  250 ml.


  Lotiune de curatare a vopselei de pe piele Go Color Cleaner

LUCREZI IN DOMENIU SI VREI SA TESTEZI GRATUIT ACEST PRODUS?
Suna acum la numarul de telefon
0751.195.643
sau completeaza formularul de mai jos si te vom contacta noi!



Oferta valabila pentru persoanele care lucreaza ca Hair Stylist sau Manager la un salon de coafura!

Alege alt produs:


ASISTENTA ONLINE

Program: 9:00 - 18:00


Telefon: 0755.748.555


E-mail: laura.raduta@divahaircosmetics.ro


SALOANE RECOMANDATE

Eriks Salon

HAIR STYLIST RECOMANDAT

Silvia Bacrea

PARTENERI MEDIA

PARTENERI ONLINE


### Req ###
Array
(
    [0] => oyster
    [1] => colorare
    [2] => sampon-anti---ln---pigment-galben-go-color-iceblond
)
### 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]
SELECT id FROM produse WHERE 1 AND status='1' AND id_brand='1' AND url_key='sampon-anti---ln---pigment-galben-go-color-iceblond' [Rows: 1] [Time: 0.0008]
### 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 produse.*, produse_categorii.url_key AS url_key_categorie, branduri.url_key as url_key_brand FROM produse LEFT JOIN produse_categorii ON  produse.id_categorie = produse_categorii.id LEFT JOIN branduri ON  produse_categorii.id_brand = branduri.id WHERE 1 AND produse.status = '1' AND produse_categorii.status = '1' AND produse_categorii.id_brand>0 AND produse.id = '336' AND produse.id_categorie = '2' [Rows: 1] [Time: 0.0005]
SELECT * FROM cms_diverse WHERE 1 AND status='1' AND nume = 'form_mostra' [Rows: 1] [Time: 0.0001]
SELECT * FROM cms_diverse WHERE 1 AND status='1' AND nume = 'form_mostra_subsol' [Rows: 1] [Time: 0.0001]
SELECT url_key, titlu, imagine FROM produse WHERE 1 AND status = '1' AND id_categorie = '2'  AND id_brand = '1' AND id != 336 ORDER BY ord ASC [Rows: 17] [Time: 0.0006]
SELECT produse_categorii.url_key AS url_key_categorie, produse.url_key, branduri.url_key as url_key_brand, produse.titlu, produse.imagine FROM produse LEFT JOIN produse_categorii ON  produse.id_categorie = produse_categorii.id LEFT JOIN branduri ON  produse_categorii.id_brand = branduri.id  WHERE 1 AND produse.status = '1' AND produse_categorii.status='1' AND produse_categorii.id_brand>0 AND produse.id IN (336) AND produse.id != 336 [Rows: 0] [Time: 0.0002]
SELECT produse.*, produse_categorii.url_key AS url_key_categorie,  branduri.url_key as url_key_brand FROM produse LEFT JOIN produse_categorii ON  produse.id_categorie = produse_categorii.id LEFT JOIN branduri ON  produse_categorii.id_brand = branduri.id WHERE 1 AND produse.status = '1' AND produse_categorii.status = '1' AND produse_categorii.id_brand>0 AND produse.id>'336' AND produse.id_categorie = '2' ORDER BY produse.id ASC [Rows: 3] [Time: 0.0005]
SELECT produse.*, produse_categorii.url_key AS url_key_categorie,  brand.url_key as url_key_brand FROM produse LEFT JOIN produse_categorii ON  produse.id_categorie = produse_categorii.id LEFT JOIN branduri ON  produse_categorii.id_brand = branduri.id WHERE 1 AND produse.status = '1' AND produse_categorii.status = '1' AND produse_categorii.id_brand>0 AND produse.id<'336' AND produse.id_categorie = '2' ORDER BY produse.id ASC [Rows: -1] [Time: 0.0002]
Unknown column 'brand.url_key' in 'field list'
### Page processing(end) ###
### GET ###
Array
(
    [req] => oyster/colorare/sampon-anti---ln---pigment-galben-go-color-iceblond
    [id_brand] => 1
    [page] => produse.produs
    [id_categorie] => 2
    [id_produs] => 336
)
### GET(end) ###
SELECT * FROM cms_meta WHERE 1 AND status='1' AND url LIKE 'http://www.divahaircosmetics.ro/oyster/colorare/sampon-anti---ln---pigment-galben-go-color-iceblond' 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%' 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 slider WHERE 1 AND `status`=1 AND id_brand='1' [Rows: 1] [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.0006]
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.0216 seconds