> Unicolors>Unicolors Azul Tutti-Frutti - Gel Tonalizante
Unicolors Azul Tutti-Frutti - Gel Tonalizante

Parcelamento
Parcelamento com juros a partir da 2º parcela pelo PagSeguro
Nas parcelas com juros é cobrada uma taxa de 2,98% ao mês e 26,82% ao ano

Unicolors Azul Tutti-Frutti - Gel Tonalizante

O Unicolors Azul Tutti-Frutti é um tonalizante em gel. Com essa textura, facilita a aplicação. O Gel Tonalizante Unicolors é super pigmentado, vegano, rende até 5x mais, sem amônia, sem parabenos, nanotecnológico e com colágeno vegetal, um poderoso ativo rico em aminoácidos, responsáveis pela elasticidade, resistência e flexibilidade da fibra capilar. Atenção: Unicolors não é um matizador

Veja mais detalhes

Mais detalhes

274

Novo

R$ 29,50

Calcular frete

Aguardando CEP

Mais informações

IMPORTANTE: A intensidade da cor irá variar conforme a altura de tom obtida na descoloração e a porosidade do cabelo. Sugerimos descolorir os cabelos até altura de 10.0 (Louro Claríssimo) para cores mais claras e até altura de 9.0 (Louro Muito Claro) para cores mais escuras. Confira imagem ao lado.

Modo de Uso: Com os cabelos limpos, secos e livres de produtos finalizadores, aplique o Unicolors na cor desejada e deixe agir por 20 minutos. Enxágue bem. Utilize o Gel Diluidor Beijinho de Coco para diluir o seu Gel Tonalizante e chegar a vários tons incríveis.

Precauções: Cuidado. Contém substâncias passíveis de causar irritação na pele de determinadas pessoas. Antes de usar, faça a prova de toque. Não usar nos cílios e sobrancelhas. Não aplicar se o couro cabeludo estiver irritado ou lesionado. Em caso de contato com os olhos, lave-os com água em abundância. Mantenha fora do alcance de crianças e animais domésticos.

Prova de Toque: Aplique uma pequena quantidade do produto no antebraço ou atrás da orelha e deixe agir por 20 minutos. Lave o local. Aguarde 24 horas e se neste período surgir irritação na pele, coceira ou ardência no local ou na proximidade, fica comprovada a hipersensibilidade da pessoa ao produto e, portanto, o mesmo não deve ser utilizado.

  • Comentários

    • Nenhuma avaliação de cliente no momento.

    Escreva sua opinião

    Unicolors Azul Tutti-Frutti - Gel Tonalizante

    Unicolors Azul Tutti-Frutti - Gel Tonalizante

    O Unicolors Azul Tutti-Frutti é um tonalizante em gel. Com essa textura, facilita a aplicação. O Gel Tonalizante Unicolors é super pigmentado, vegano, rende até 5x mais, sem amônia, sem parabenos, nanotecnológico e com colágeno vegetal, um poderoso ativo rico em aminoácidos, responsáveis pela elasticidade, resistência e flexibilidade da fibra capilar. Atenção: Unicolors não é um matizador

    Escreva sua opinião

    22 outros produtos na mesma categoria

    Unicolors Gel Diluidor Beijinho de Coco

    Unicolors Gel Diluidor Beijinho de Coco

    Unicolors Amarelo Quindim - Gel Tonalizante

    Unicolors Amarelo Quindim - Gel Tonalizante

    Unicolors Azul Marshmellow - Gel Tonalizante

    Unicolors Azul Marshmellow - Gel Tonalizante

    Unicolors Azul Baballoo - Gel Tonalizante

    Unicolors Azul Baballoo - Gel Tonalizante

    Unicolors Cobre Pé de Moleque - Gel Tonalizante

    Unicolors Cobre Pé de Moleque - Gel Tonalizante

    Unicolors Lilás Mousse de Uva - Gel Tonalizante

    Unicolors Lilás Mousse de Uva - Gel Tonalizante

    Unicolors Vinho Doce de Jabuticaba - Gel Tonalizante

    Unicolors Vinho Doce de Jabuticaba - Gel Tonalizante

    Unicolors Rosa Algodão Doce - Gel Tonalizante

    Unicolors Rosa Algodão Doce - Gel Tonalizante

    Unicolors Pink Chiclete - Gel Tonalizante

    Unicolors Pink Chiclete - Gel Tonalizante

    Unicolors Preto Azulado Cheesecake de Mirtillo - Gel Tonalizante

    Unicolors Preto Azulado Cheesecake de Mirtillo - Gel Tonalizante

    Unicolors Preto Arroxeado Frozen de Açaí - Gel Tonalizante

    Unicolors Preto Arroxeado Frozen de Açaí - Gel Tonalizante

    Unicolors Laranja Caramelo - Gel Tonalizante

    Unicolors Laranja Caramelo - Gel Tonalizante

    Unicolors Marsala Geleia de Amora - Gel Tonalizante

    Unicolors Marsala Geleia de Amora - Gel Tonalizante

    Unicolors Silver Maria Mole - Gel Tonalizante

    Unicolors Silver Maria Mole - Gel Tonalizante

    Unicolors Verde Doce de Figo - Gel Tonalizante

    Unicolors Verde Doce de Figo - Gel Tonalizante

    Unicolors Verde Bala de Menta - Gel Tonalizante

    Unicolors Verde Bala de Menta - Gel Tonalizante

    Unicolors Vermelho Maça do Amor - Gel Tonalizante

    Unicolors Vermelho Maça do Amor - Gel Tonalizante

    Unicolors Vermelho Goiabada - Gel Tonalizante

    Unicolors Vermelho Goiabada - Gel Tonalizante

    Unicolors Roxo Jujuba - Gel Tonalizante

    Unicolors Roxo Jujuba - Gel Tonalizante

    Unicolors Turquesa Alcaçuz - Gel Tonalizante

    Unicolors Turquesa Alcaçuz - Gel Tonalizante

    Unicolors Pink Cupcake - Gel Tonalizante

    Unicolors Pink Cupcake - Gel Tonalizante

    Unicolors Cinza Suspiro - Gel Tonalizante

    Unicolors Cinza Suspiro - Gel Tonalizante

    Clientes que compraram este produto também compraram...

    Anterior
    • Unicolors Vinho Doce de Jabuticaba - Gel Tonalizante

      Unicolors...


      O Unicolors Vinho Doce de Jabuticaba é um...

    • Unicolors Turquesa Alcaçuz - Gel Tonalizante

      Unicolors...


      O Unicolors Turquesa Alcaçuz é um tonalizante...

    • Unicolors Rosa Algodão Doce - Gel Tonalizante

      Unicolors...


      O Unicolors Rosa Algodão Doce é um tonalizante...

    • Unicolors Roxo Jujuba - Gel Tonalizante

      Unicolors...


      O Unicolors Roxo Jujuba é um tonalizante em...

    • Unicolors Azul Marshmellow - Gel Tonalizante

      Unicolors...


      O Unicolors Azul Marshmellow é um tonalizante...

    • Unicolors Pink Cupcake - Gel Tonalizante

      Unicolors...


      O Unicolors Pink Cupcake é um tonalizante em...

    • Unicolors Pink Chiclete - Gel Tonalizante

      Unicolors...


      O Unicolors Pink Chiclete é um tonalizante em...

    • Unicolors Lilás Mousse de Uva - Gel Tonalizante

      Unicolors...


      O Unicolors Amarelo Quindim é um tonalizante em...

    Próximo
    
    Load Time6604 ms - You'd better run your shop on a toaster
    Querying Time1078 ms
    Queries38
    Memory Peak Usage84.4 Mb
    Included Files251 files - 4.52 Mb
    PrestaShop Cache- Mb
    Global vars0.63 Mb
    PrestaShop Version1.6.1.1
    PHP Version5.5.14 (OK)
    MySQL Version5.5.37-log (Consider upgrading)
    Memory Limit134217728
    Max Execution Time240s
    Smarty Cacheenabled
    Smarty Compilationnever recompile
     TimeCumulated TimeMemory UsageMemory Peak Usage
    config 2033 ms 2033 ms 7.88 Mb 84.41 Mb
    __construct 0 ms 2033 ms - Mb 84.41 Mb
    init 299 ms 2332 ms 7.44 Mb 84.41 Mb
    checkAccess 0 ms 2332 ms - Mb 84.41 Mb
    setMedia 8 ms 2339 ms 0.07 Mb 84.41 Mb
    postProcess 0 ms 2339 ms - Mb 84.41 Mb
    initHeader 0 ms 2339 ms 0.01 Mb 84.41 Mb
    initContent 4036 ms 6375 ms 5.28 Mb 84.41 Mb
    initFooter 209 ms 6585 ms 0.15 Mb 84.41 Mb
    display 20 ms 6604 ms 1.18 Mb 84.41 Mb
    Hook Time Memory Usage
    hookproducttabcontent 180 ms - Mb
    hookdisplayHeader 150 ms - Mb
    hookproducttab 130 ms - Mb
    __construct 70 ms - Mb
    hookdisplayRightColumnProduct 60 ms - Mb
    hookproductfooter 20 ms - Mb
    hookextraleft 10 ms - Mb
    hookdisplayProductButtons 10 ms - Mb
    hookproductoutofstock 10 ms - Mb
    hookdisplayTop 10 ms - Mb
    hookdisplayNav 10 ms - Mb
    hookfooter 10 ms - Mb
    hookdisplayFooter 10 ms - Mb
    hookHeader 10 ms - Mb
    hookdisplayRightColumn - ms - Mb
    hookdisplayTopColumn - ms - Mb
    hookdisplayBanner - ms - Mb
    hooktop - ms - Mb
    hookdisplayLeftColumn - ms - Mb
    hookleftcolumn - ms - Mb
    hookdisplayFooterProduct - ms - Mb
    21 hooks 690 ms - Mb
    Module Time Memory Usage
    productcomments 320 ms - Mb
    bestwidget 140 ms - Mb
    productvideos 50 ms - Mb
    blocktopmenu 20 ms - Mb
    blockpermanentlinks 20 ms - Mb
    fkcorreiosg2 20 ms - Mb
    blockmanufacturer 10 ms - Mb
    blocksupplier 10 ms - Mb
    blocksocial 10 ms - Mb
    crossselling 10 ms - Mb
    blockstore 10 ms - Mb
    blocksharefb 10 ms - Mb
    blocknewsletter 10 ms - Mb
    notifymewhenstock 10 ms - Mb
    blockcms 10 ms - Mb
    productscategory 10 ms - Mb
    blockcart 10 ms - Mb
    fkparcelamentog2 10 ms - Mb
    ganalytics - ms - Mb
    sekeywords - ms - Mb
    pagesnotfound - ms - Mb
    fkpagseguroct - ms - Mb
    homefeatured - ms - Mb
    blocklayered - ms - Mb
    blockcurrencies - ms - Mb
    blockfacebook - ms - Mb
    blockcontact - ms - Mb
    blockspecials - ms - Mb
    blocktags - ms - Mb
    blocksearch - ms - Mb
    blocknewproducts - ms - Mb
    blockcategories - ms - Mb
    blockuserinfo - ms - Mb
    blockviewed - ms - Mb
    blockbestsellers - ms - Mb
    blockcontactinfos - ms - Mb
    36 modules 690 ms - Mb
    1. Stopwatch SQL
    2. Doubles
    3. Tables stress
    4. ObjectModel instances
    5. Included Files

    Stopwatch SQL - 38 queries

    Query Time (ms) Rows Filesort Group By Location 
    SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
    		 1025.8 285861 /classes/Configuration.php:150 
    SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=378
    		 11.1 5 /classes/Tag.php:200 
    SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2020-07-06 00:00:00",
INTERVAL 0 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 378 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
    		 4.1 1 Yes Yes /classes/Product.php:3562 
    SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
    		 2.1 0 /classes/Hook.php:131 
    SELECT SQL_NO_CACHE *
FROM `ps_li_product_video` pv
LEFT JOIN `ps_li_product_video_lang` pvl ON (pvl.id_li_product_video = pv.id_li_product_video AND pvl.`id_lang` = 1)
WHERE pv.`id_product` = 378
ORDER BY `position`
    		 1.7 24 Yes /modules/productvideos/classes/ProductVideosClass.php:71 
    SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='cbc3a29d4f3113536df4c50c0c3784a0' AND cache_id="blocksocial|1|1|58" AND compile_id="" LIMIT 1
    		 1.7 1 /classes/SmartyCustom.php:215 
    SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 378
AND image_shop.`cover` = 1 LIMIT 1
    		 1.6 2 /classes/Product.php:2710 
    SELECT SQL_NO_CACHE *
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 378
AND pc.`id_customer` = 0
ORDER BY pc.`date_add` DESC LIMIT 1
    		 1.6 1 Yes /modules/productcomments/ProductComment.php:137 
    SELECT SQL_NO_CACHE COUNT(pc.`id_product`) AS nbr
FROM `ps_product_comment` pc
WHERE `id_product` = 378 AND `validate` = 1
AND `grade` > 0 LIMIT 1
    		 1.6 1 /modules/productcomments/ProductComment.php:261 
    SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='8313f9825a0283f06187b5c71c049a69' AND cache_id="blockcms|2|1|1|58" AND compile_id="" LIMIT 1
    		 1.5 1 /classes/SmartyCustom.php:215 
    SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 58, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price` USE INDEX (id_product_2)
WHERE
`id_product` IN(0, 378) AND
`id_shop` IN(0, 1) AND
`id_currency` IN(0, 1) AND
`id_country` IN(0, 58) AND
`id_group` IN(0, 1) AND
`id_customer` IN(0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2020-07-06 06:00:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2020-07-06 06:00:00' <= `to`)
)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
    		 1.3 272 Yes /classes/SpecificPrice.php:302 
    SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='871ef309758644c4d905c136170a3037' AND cache_id="crossselling|productfooter|378|1|1|58" AND compile_id="" LIMIT 1
    		 1.3 1 /classes/SmartyCustom.php:215 
    SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='6d4021b6746a542135d3f9f7c5647a12' AND cache_id="blockcategories|1|1|58|127|1" AND compile_id="" LIMIT 1
    		 1.3 1 /classes/SmartyCustom.php:215 
    SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
    		 1.3 305 /classes/module/Module.php:2142 
    SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 378
ORDER BY `position`
    		 1.2 2 Yes /classes/Product.php:2690 
    SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 378
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
    		 1.2 1 /modules/productcomments/ProductComment.php:197 
    SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='073dfd0f5ca3fe5bd8645fb47489b8e5' AND cache_id="blocktopmenu|1|1|58|product|378" AND compile_id="" LIMIT 1
    		 1.2 1 /classes/SmartyCustom.php:215 
    SELECT SQL_NO_CACHE pcc.`id_product_comment_criterion`, pccl.`name`
FROM `ps_product_comment_criterion` pcc
LEFT JOIN `ps_product_comment_criterion_lang` pccl
ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion)
LEFT JOIN `ps_product_comment_criterion_product` pccp
ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 378)
LEFT JOIN `ps_product_comment_criterion_category` pccc
ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`)
LEFT JOIN `ps_product_shop` ps
ON (ps.id_category_default = pccc.id_category AND ps.id_product = 378)
WHERE pccl.`id_lang` = 1
AND (
pccp.id_product IS NOT NULL
OR ps.id_product IS NOT NULL
OR pcc.id_product_comment_criterion_type = 1
)
AND pcc.active = 1
GROUP BY pcc.id_product_comment_criterion
    		 1.2 1 Yes /modules/productcomments/ProductCommentCriterion.php:184 
    SELECT SQL_NO_CACHE pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion`
FROM `ps_product_comment` pc
LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`)
LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
WHERE pc.`id_product` = 378
AND pccl.`id_lang` = 1 AND pc.`validate` = 1
    		 1.1 1 /modules/productcomments/ProductComment.php:168 
    SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 378
    		 1.1 1 /classes/Product.php:5640 
    SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='75c1153aa129f4c3d71fbc5987ab6267' AND cache_id="productscategory|378|127|1|1|58" AND compile_id="" LIMIT 1
    		 1.1 1 /classes/SmartyCustom.php:215 
    SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `attribute`
FROM `ps_attribute` a
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 378
    		 1 1 /classes/Product.php:5583 
    SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e51976bfb8be421c53dc15d4e56323ad' AND cache_id="blocksearch-top|1|1|58" AND compile_id="" LIMIT 1
    		 0.9 1 /classes/SmartyCustom.php:215 
    SELECT SQL_NO_CACHE pc.`id_product_comment`,
(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = 1) as total_useful,
(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice, 
IF(c.id_customer, CONCAT(c.`firstname`, ' ',  LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title
FROM `ps_product_comment` pc
LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer`
WHERE pc.`id_product` = 378 AND pc.`validate` = 1
ORDER BY pc.`date_add` DESC
    		 0.9 1 Yes /modules/productcomments/ProductComment.php:114 
    SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 58, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price` USE INDEX (id_product_2)
WHERE `id_product` IN (0, 378)
AND `id_product_attribute` IN (0, 0)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 58)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2020-07-06 06:00:00' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2020-07-06 06:00:00' <= `to`)
)
AND id_cart IN (0, 0)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
    		 0.8 4 Yes /classes/SpecificPrice.php:236 
    SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 378 LIMIT 1
    		 0.8 1 /classes/Pack.php:251 
    SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE pl.id_lang = 1
AND pl.id_product = 378
AND product_shop.active = 1 LIMIT 1
    		 0.7 1 /classes/Meta.php:259 
    SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 378 LIMIT 1
    		 0.7 1 /classes/Pack.php:50 
    SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 378) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    		 0.7 1 /classes/stock/StockAvailable.php:670 
    SELECT SQL_NO_CACHE p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 378
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2020-07-06 00:00:00",
INTERVAL 0 DAY
)
) > 0
    		 0.7 0 /classes/Product.php:1247 
    SELECT SQL_NO_CACHE `id_product_download`
FROM `ps_product_download`
WHERE `id_product` = 378
AND `active` = 1
ORDER BY `id_product_download` DESC LIMIT 1
    		 0.6 0 /classes/ProductDownload.php:184 
    SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 378 AND `validate` = 1 LIMIT 1
    		 0.6 1 /modules/productcomments/ProductComment.php:240 
    SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
    		 0.6 1 /classes/SmartyCustom.php:95 
    SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 378) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    		 0.6 1 /classes/stock/StockAvailable.php:646 
    SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 378
AND id_shop = 1 LIMIT 1
    		 0.5 1 /classes/ObjectModel.php:1443 
    SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1
    		 0.4 1 /classes/cache/CacheFs.php:36 
    SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a105af890fb6ec9d6712e2c495c85004' AND cache_id="blockpermanentlinks-header|1|1|58" AND compile_id="" LIMIT 1
    		 0.4 1 /classes/SmartyCustom.php:215 
    SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
    		 0.4 1 /classes/SmartyCustom.php:142

    Doubles

    Tables stress

    8 smarty_lazy_cache
    6 product_comment
    5 product_shop
    3 stock_available
    3 image_shop
    3 product_attribute_shop
    3 product
    2 image_lang
    2 product_comment_criterion_lang
    2 configuration
    2 product_comment_criterion
    2 image
    2 product_attribute
    2 product_attribute_combination
    2 product_comment_usefulness
    2 attribute
    2 hook
    2 product_lang
    2 specific_price
    2 pack
    2 smarty_last_flush
    1 customer
    1 hook_alias
    1 li_product_video_lang
    1 configuration_lang
    1 product_comment_criterion_category
    1 product_comment_criterion_product
    1 li_product_video
    1 product_comment_grade
    1 accessory
    1 layered_indexable_attribute_lang_value
    1 tag
    1 product_tag
    1 hook_module_exceptions
    1 attribute_lang
    1 attribute_group_lang
    1 category_lang
    1 product_download
    1 attribute_shop
    1 manufacturer

    ObjectModel instances

    NameInstancesSource
    Address 5 /classes/Product.php [492]
    /classes/Product.php [5012]
    /classes/Product.php [2904]
    /controllers/front/ProductController.php [314]
    /controllers/front/ProductController.php [349]
    Product 3 /classes/Link.php [104]
    /controllers/front/ProductController.php [85]
    /modules/blockviewed/blockviewed.php [158]
    Language 2 /config/config.inc.php [195]
    /classes/Tools.php [498]
    Category 2 /controllers/front/ProductController.php [158]
    /classes/Link.php [177]
    Country 2 /config/config.inc.php [142]
    /classes/controller/FrontController.php [279]
    Manufacturer 1 /controllers/front/ProductController.php [268]
    Group 1 /classes/Cart.php [184]
    Currency 1 /classes/Tools.php [612]
    Theme 1 /config/config.inc.php [115]
    ShopGroup 1 /classes/shop/Shop.php [518]
    Customer 1 /config/config.inc.php [217]
    Shop 1 /config/config.inc.php [114]
    Cart 1 /classes/controller/FrontController.php [348]

    Included Files

    #Filename
    1/index.php
    2/config/config.inc.php
    3/config/defines.inc.php
    4/config/settings.inc.php
    5/config/autoload.php
    6/config/alias.php
    7/classes/PrestaShopAutoload.php
    8/cache/class_index.php
    9/config/bootstrap.php
    10/Core/Business/Core_Business_ContainerBuilder.php
    11/Core/Foundation/IoC/Core_Foundation_IoC_Container.php
    12/Adapter/Adapter_ServiceLocator.php
    13/classes/controller/Controller.php
    14/classes/ObjectModel.php
    15/Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php
    16/classes/db/Db.php
    17/classes/Tools.php
    18/classes/Context.php
    19/classes/shop/Shop.php
    20/classes/db/DbPDO.php
    21/classes/cache/Cache.php
    22/classes/cache/CacheFs.php
    23/classes/Configuration.php
    24/classes/Validate.php
    25/Adapter/Adapter_EntityMapper.php
    26/classes/db/DbQuery.php
    27/classes/Theme.php
    28/config/defines_uri.inc.php
    29/tools/htmlpurifier/HTMLPurifier.standalone.php
    30/classes/Language.php
    31/classes/Country.php
    32/classes/PrestaShopCollection.php
    33/classes/shop/ShopGroup.php
    34/classes/Cookie.php
    35/classes/Blowfish.php
    36/classes/Customer.php
    37/classes/Group.php
    38/classes/Link.php
    39/classes/shop/ShopUrl.php
    40/config/smarty.config.inc.php
    41/tools/smarty/Smarty.class.php
    42/tools/smarty/sysplugins/smarty_internal_data.php
    43/tools/smarty/sysplugins/smarty_internal_templatebase.php
    44/tools/smarty/sysplugins/smarty_internal_template.php
    45/tools/smarty/sysplugins/smarty_resource.php
    46/tools/smarty/sysplugins/smarty_internal_resource_file.php
    47/tools/smarty/sysplugins/smarty_cacheresource.php
    48/tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
    49/classes/SmartyCustom.php
    50/config/smartyfront.config.inc.php
    51/classes/Dispatcher.php
    52/classes/Hook.php
    53/tools/mobile_Detect/Mobile_Detect.php
    54/config/db_slave_server.inc.php
    55/controllers/front/ProductController.php
    56/classes/controller/FrontController.php
    57/themes/vp_cosmetics/lang/br.php
    58/classes/Currency.php
    59/classes/Cart.php
    60/classes/CartRule.php
    61/classes/Meta.php
    62/classes/Product.php
    63/classes/webservice/WebserviceRequest.php
    64/classes/Category.php
    65/classes/Manufacturer.php
    66/classes/Supplier.php
    67/classes/Address.php
    68/classes/tax/TaxManagerFactory.php
    69/classes/tax/TaxRulesTaxManager.php
    70/classes/tax/TaxManagerInterface.php
    71/Adapter/Adapter_Configuration.php
    72/Core/Business/Core_Business_ConfigurationInterface.php
    73/classes/tax/TaxCalculator.php
    74/classes/tax/Tax.php
    75/classes/Combination.php
    76/classes/SpecificPrice.php
    77/classes/GroupReduction.php
    78/classes/Tag.php
    79/classes/stock/StockAvailable.php
    80/classes/module/Module.php
    81/classes/Media.php
    82/modules/blockviewed/blockviewed.php
    83/classes/Translate.php
    84/modules/blockviewed/translations/br.php
    85/modules/blockcart/blockcart.php
    86/modules/blockcart/translations/br.php
    87/modules/blocksocial/blocksocial.php
    88/modules/blocksocial/translations/br.php
    89/modules/blockspecials/blockspecials.php
    90/modules/blockspecials/translations/br.php
    91/modules/blockcontact/blockcontact.php
    92/modules/blockcontact/translations/br.php
    93/modules/blockfacebook/blockfacebook.php
    94/modules/blockfacebook/translations/br.php
    95/modules/blocklayered/blocklayered.php
    96/modules/blocklayered/translations/br.php
    97/modules/blockcurrencies/blockcurrencies.php
    98/modules/blockcurrencies/translations/br.php
    99/modules/blockmanufacturer/blockmanufacturer.php
    100/modules/blockmanufacturer/translations/br.php
    101/modules/blockcms/blockcms.php
    102/modules/blockcms/BlockCMSModel.php
    103/modules/blockcms/translations/br.php
    104/modules/blocktags/blocktags.php
    105/modules/blocktags/translations/br.php
    106/modules/blocknewsletter/blocknewsletter.php
    107/modules/blocknewsletter/translations/br.php
    108/modules/blocksearch/blocksearch.php
    109/modules/blocksearch/translations/br.php
    110/modules/blockstore/blockstore.php
    111/modules/blockstore/translations/br.php
    112/modules/blocksupplier/blocksupplier.php
    113/modules/blocksupplier/translations/br.php
    114/modules/productcomments/productcomments.php
    115/modules/productcomments/translations/br.php
    116/modules/blockbestsellers/blockbestsellers.php
    117/modules/blockbestsellers/translations/br.php
    118/modules/homefeatured/homefeatured.php
    119/modules/homefeatured/translations/br.php
    120/modules/blockpermanentlinks/blockpermanentlinks.php
    121/modules/blockpermanentlinks/translations/br.php
    122/modules/blockuserinfo/blockuserinfo.php
    123/modules/blockuserinfo/translations/br.php
    124/modules/blocknewproducts/blocknewproducts.php
    125/modules/blocknewproducts/translations/br.php
    126/modules/blockcategories/blockcategories.php
    127/modules/blockcategories/translations/br.php
    128/modules/blockcontactinfos/blockcontactinfos.php
    129/modules/blockcontactinfos/translations/br.php
    130/modules/fkcorreiosg2/fkcorreiosg2.php
    131/modules/fkcorreiosg2/models/FKcorreiosg2Class.php
    132/modules/fkcorreiosg2/models/FKcorreiosg2FreteClass.php
    133/modules/fkcorreiosg2/models/CorreiosClass.php
    134/classes/module/CarrierModule.php
    135/modules/productscategory/productscategory.php
    136/modules/productscategory/translations/br.php
    137/modules/bestwidget/bestwidget.php
    138/modules/bestwidget/libs/config.php
    139/cache/smarty/cache/blockpermanentlinks_header/1/1/58/9f/6b/98/9f6b98bb550216cb52dd7763a4d54b792bf87ac2.blockpermanentlinks-header.tpl.php
    140/cache/smarty/compile/e5/18/dc/e518dc1f7c28a6035c1cdd0b57441e4f20a34377.file.bestwidget.tpl.php
    141/cache/smarty/compile/0e/8c/7d/0e8c7d3ad7ad97d21734b155c5e72fe3b6df490f.file.bestwidget-header.tpl.php
    142/tools/smarty/plugins/modifier.replace.php
    143/modules/blocktopmenu/blocktopmenu.php
    144/modules/blocktopmenu/menutoplinks.class.php
    145/modules/blocktopmenu/translations/br.php
    146/modules/fkpagseguroct/fkpagseguroct.php
    147/modules/fkpagseguroct/models/FKpagseguroctInterfaceClass.php
    148/modules/fkpagseguroct/models/cUrlClass.php
    149/modules/fkpagseguroct/models/XmlParserClass.php
    150/classes/PaymentModule.php
    151/modules/crossselling/crossselling.php
    152/modules/crossselling/translations/br.php
    153/modules/ganalytics/ganalytics.php
    154/modules/ganalytics/translations/br.php
    155/modules/productvideos/productvideos.php
    156/modules/productvideos/classes/ProductVideosClass.php
    157/modules/notifymewhenstock/notifymewhenstock.php
    158/modules/notifymewhenstock/classes/NotifyMail.php
    159/tools/swift/Swift.php
    160/tools/swift/Swift/ClassLoader.php
    161/tools/swift/Swift/LogContainer.php
    162/tools/swift/Swift/Log/DefaultLog.php
    163/tools/swift/Swift/Log.php
    164/tools/swift/Swift/ConnectionBase.php
    165/tools/swift/Swift/Connection.php
    166/tools/swift/Swift/ConnectionException.php
    167/tools/swift/Swift/Exception.php
    168/tools/swift/Swift/BadResponseException.php
    169/tools/swift/Swift/Cache.php
    170/tools/swift/Swift/CacheFactory.php
    171/tools/swift/Swift/Message.php
    172/tools/swift/Swift/Address.php
    173/tools/swift/Swift/AddressContainer.php
    174/tools/swift/Swift/Message/Mime.php
    175/tools/swift/Swift/File.php
    176/tools/swift/Swift/FileException.php
    177/tools/swift/Swift/Message/MimeException.php
    178/tools/swift/Swift/Message/Image.php
    179/tools/swift/Swift/Message/EmbeddedFile.php
    180/tools/swift/Swift/Message/Attachment.php
    181/tools/swift/Swift/Message/Part.php
    182/tools/swift/Swift/RecipientList.php
    183/tools/swift/Swift/Iterator/Array.php
    184/tools/swift/Swift/Iterator.php
    185/tools/swift/Swift/BatchMailer.php
    186/tools/swift/Swift/Events.php
    187/tools/swift/Swift/Events/Listener.php
    188/tools/swift/Swift/Connection/SMTP.php
    189/tools/swift/Swift/Authenticator.php
    190/tools/swift/Swift/Connection/NativeMail.php
    191/tools/swift/Swift/Plugin/MailSend.php
    192/tools/swift/Swift/Events/SendListener.php
    193/tools/swift/Swift/Events/BeforeSendListener.php
    194/tools/swift/Swift/Plugin/Decorator.php
    195/tools/swift/Swift/Plugin/Decorator/Replacements.php
    196/modules/notifymewhenstock/translations/br.php
    197/modules/notifymewhenstock/br.php
    198/Adapter/Adapter_AddressFactory.php
    199/Adapter/Adapter_ProductPriceCalculator.php
    200/classes/Customization.php
    201/cache/smarty/compile/dd/b9/da/ddb9da6d103a1eef32609f031bfd6c84afc2a551.file.blockcart.tpl.php
    202/tools/smarty/plugins/function.counter.php
    203/cache/smarty/compile/4d/d8/9f/4dd89fbc05c43e7e3613b447be5ab2c1773e33d2.file.blockuserinfo.tpl.php
    204/modules/pagesnotfound/pagesnotfound.php
    205/modules/pagesnotfound/translations/br.php
    206/modules/sekeywords/sekeywords.php
    207/classes/module/ModuleGraph.php
    208/modules/sekeywords/translations/br.php
    209/cache/smarty/cache/blocksearch_top/1/1/58/d1/60/16/d1601624f390c638a15e44392e75daf211a0d8e1.blocksearch-top.tpl.php
    210/cache/smarty/cache/blocktopmenu/1/1/58/product/378/d8/a1/da/d8a1da8abf688bf58803d32d4c8b88dc2ade4f61.blocktopmenu.tpl.php
    211/classes/Pack.php
    212/classes/ProductDownload.php
    213/cache/smarty/cache/productscategory/378/127/1/1/58/e4/0b/1a/e40b1aea389b255b1e152d8558f971200071dc0b.productscategory.tpl.php
    214/cache/smarty/cache/crossselling/productfooter/378/1/1/58/e7/f5/58/e7f5580f87218fefb2566d62eee77e1ef71d3157.crossselling.tpl.php
    215/classes/Image.php
    216/classes/ImageType.php
    217/classes/Feature.php
    218/modules/blocksharefb/blocksharefb.php
    219/modules/blocksharefb/translations/br.php
    220/cache/smarty/compile/b7/4e/72/b74e72d147ec6575834501277d7074630426c1d2.file.blocksharefb.tpl.php
    221/modules/fkparcelamentog2/fkparcelamentog2.php
    222/modules/fkparcelamentog2/models/FKparcg2Class.php
    223/cache/smarty/compile/0f/b6/c8/0fb6c89ef684c26354d75876d69699b769d277dd.file.simuladorProduto.tpl.php
    224/cache/smarty/compile/3a/dd/1b/3add1ba86487391b28df0b12b32cd6f867f0ca5a.file.buttonproduct.tpl.php
    225/cache/smarty/compile/ca/64/33/ca64333c2ceb310ec879f256f4a0e813a7612866.file.simuladorBoxAdicCarrinho.tpl.php
    226/modules/productcomments/ProductComment.php
    227/modules/productcomments/ProductCommentCriterion.php
    228/cache/smarty/compile/f9/54/59/f95459b5f6143dd88bbf83f58a47ad68cabd4d5d.file.tab.tpl.php
    229/cache/smarty/compile/f6/f7/e3/f6f7e35a2233c6426a0fb77a5f2188c195e77274.file.productcomments.tpl.php
    230/cache/smarty/cache/blocksocial/1/1/58/df/9b/d2/df9bd2af84f5eb3c6e3887bddcb51d172eff218d.blocksocial.tpl.php
    231/cache/smarty/cache/blockcategories/1/1/58/127/1/68/39/d4/6839d49633dfd54754208befb570a70dd465e171.blockcategories_footer.tpl.php
    232/cache/smarty/cache/blockcms/2/1/1/58/07/24/fb/0724fbaaac3c4aa9366121af99fae75e77b0a6dd.blockcms.tpl.php
    233/cache/smarty/compile/69/b1/7e/69b17eaec965936113c6d5d69742c048ca196e79.file.product.tpl.php
    234/tools/smarty/plugins/modifier.date_format.php
    235/tools/smarty/plugins/function.math.php
    236/cache/smarty/compile/41/c5/cf/41c5cf6fc51ca86eaafa4431ee9c974e99ac95ca.file.errors.tpl.php
    237/cache/smarty/compile/0e/4b/8c/0e4b8c024cda563f33e0093ee36aab67ad53fc7d.file.product-desc-default.tpl.php
    238/tools/smarty/plugins/function.cycle.php
    239/tools/smarty/plugins/shared.make_timestamp.php
    240/cache/smarty/compile/00/a5/e9/00a5e97f05fc484bcafa20c6d0388a8ae6b5082c.file.layout.tpl.php
    241/cache/smarty/compile/37/08/84/370884646cc7e6fa65bc8562321cb8a30780b3a8.file.header.tpl.php
    242/tools/smarty/plugins/function.implode.php
    243/cache/smarty/compile/71/d5/12/71d5121e08c9afd77897ba840ad3aeb3e48b4fe9.file.breadcrumb.tpl.php
    244/cache/smarty/compile/ee/83/12/ee831268423a65dfbe706fae4c666fde42fc634e.file.footer.tpl.php
    245/cache/smarty/compile/bf/53/f8/bf53f81dad255df20c133f124e32e029b276a4cf.file.global.tpl.php
    246/cache/smarty/compile/1a/1e/32/1a1e327e673bf5ac00bccf89383d713fa7be2bf1.file.javascript.tpl.php
    247/tools/smarty/plugins/shared.mb_str_replace.php