Mini Gloss Matizador 3D Mega Red - Efeito Vermelho Intenso - 100ml

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

Mini Gloss Matizador 3D Mega Red - Efeito Vermelho Intenso - 100ml

Sua fórmula possui aminoácidos importantes para a manutenção do cabelo. O gloss se adere aos fios como um adesivo e fixa por mais tempo a matização, diferenciando-se dos matizadores tradicionais.

Veja mais detalhes

Mais detalhes

158

Novo

R$ 25,44

Aguardando CEP

Mais informações

Mini Gloss Matizador 3D Mega Red neutraliza os tons oxidados adquiridos com passar do tempo. Possui efeito gloss proporcionado por glitters pigmentados e o composto 3D coacervado antirrotura que fornece os aminoácidos essenciais (cisteína, lisina, glicina, arginina e tirosina), oferecendo crescimento, reestruturação, fortalecimento, resistência e nutrição dos fios, além de queratina. Seu efeito é gradual e progressivo.

Teste de mechas:
Antes da aplicação, faça o teste em uma mecha do seu cabelo. 

Modo de uso:
Após lavar os cabelos com o shampoo de sua preferência, aplique o Mini Gloss Matizador 3D Mega Red no cabelo úmido, friccionando da raiz às pontas sem massagear. Deixe agir entre 15 e 30 minutos. Após atingir o tempo desejado, enxague abundantemente.

Precauções:
Uso adulto externo. Evite contato com os olhos. Em caso de irritação, suspenda o uso. Evite calor excessivo e mantenha fora do alcance de crianças e animais domésticos..

  • Comentários
  • Nenhuma avaliação de cliente no momento.

    Escreva sua opinião

    Mini Gloss Matizador 3D Mega Red - Efeito Vermelho Intenso - 100ml

    Mini Gloss Matizador 3D Mega Red - Efeito Vermelho Intenso - 100ml

    Sua fórmula possui aminoácidos importantes para a manutenção do cabelo. O gloss se adere aos fios como um adesivo e fixa por mais tempo a matização, diferenciando-se dos matizadores tradicionais.

    Escreva sua opinião

    25 outros produtos na mesma categoria

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

    Anterior
    • Mini Gloss Matizador 3D Ruivo Sensation - Efeito Ruivo Intenso - 100ml

      Mini Gloss...


      Tem esse nome por conter o aminoácido 3D à base...

    • Pó Descolorante Exclusive Blond 500g

      Pó...


      O revolucionário Pó descolorante Exclusive...

    • Mini Gloss Matizador 3D Marsala - Efeito Marsala Intenso - 100ml

      Mini Gloss...


      Tem esse nome por conter o aminoácido 3D à base...

    • Gloss Matizador 3D Platinum Branco - Efeito Platinado - 500ml

      Gloss...


      Tratamento desamarelador para cabelos loiros...

    • Máscara Restauradora Noblesse K - 300g

      Máscara...


      Um produto. Doze benefícios. Com a máscara...

    • Btox Capilar Coffee Break 300g

      Btox Capilar...


      O novo Botox Capilar Magic Color reduz o volume...

    • Coloração 55.62 - Castanho Claro Vermelho Irisado Especial 60g

      Coloração...


      A coloração em Creme Exclusive Magic promove...

    • Platinagem Exclusive Blond Champagne - Efeito Perolado - 150 ml

      Platinagem...


      A Platinagem da Linha Exclusive Blond age como...

    • Mini Shampoo Matizador 3D - 100ml

      Mini Shampoo...


      Loiro colorido e descolorido Efeito levemente...

    • Mini Gloss Matizador 3D Master Black - Efeito Preto Intenso - 100ml

      Mini Gloss...


      Tem esse nome por conter o aminoácido 3D à base...

    Próximo
    
    Load Time6904 ms - You'd better run your shop on a toaster
    Querying Time1136 ms
    Queries28
    Memory Peak Usage84.3 Mb
    Included Files251 files - 4.53 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 2196 ms 2196 ms 7.50 Mb 84.30 Mb
    __construct 0 ms 2196 ms - Mb 84.30 Mb
    init 102 ms 2298 ms 6.98 Mb 84.30 Mb
    checkAccess 0 ms 2298 ms - Mb 84.30 Mb
    setMedia 9 ms 2307 ms 0.07 Mb 84.30 Mb
    postProcess 0 ms 2307 ms - Mb 84.30 Mb
    initHeader 0 ms 2307 ms 0.01 Mb 84.30 Mb
    initContent 4391 ms 6698 ms 5.39 Mb 84.30 Mb
    initFooter 191 ms 6888 ms 0.15 Mb 84.30 Mb
    display 16 ms 6904 ms 0.47 Mb 84.30 Mb
    Hook Time Memory Usage
    hookdisplayHeader 190 ms - Mb
    __construct 90 ms - Mb
    hookproductfooter 50 ms - Mb
    hookHeader 50 ms - Mb
    hookproducttabcontent 40 ms - Mb
    hookproducttab 20 ms - Mb
    hookdisplayTop 10 ms - Mb
    hooktop 10 ms - Mb
    hookdisplayNav 10 ms - Mb
    hookdisplayRightColumnProduct 10 ms - Mb
    hookfooter 10 ms - Mb
    hookproductoutofstock - ms - Mb
    hookdisplayFooter - ms - Mb
    hookdisplayProductButtons - ms - Mb
    hookdisplayRightColumn - ms - Mb
    hookdisplayTopColumn - ms - Mb
    hookdisplayBanner - ms - Mb
    hookdisplayLeftColumn - ms - Mb
    hookleftcolumn - ms - Mb
    hookdisplayFooterProduct - ms - Mb
    hookextraleft - ms - Mb
    21 hooks 490 ms - Mb
    Module Time Memory Usage
    bestwidget 190 ms - Mb
    productcomments 70 ms - Mb
    productscategory 30 ms - Mb
    crossselling 20 ms - Mb
    notifymewhenstock 20 ms - Mb
    blocksearch 20 ms - Mb
    blockcart 20 ms - Mb
    fkparcelamentog2 20 ms - Mb
    blocktopmenu 10 ms - Mb
    blockstore 10 ms - Mb
    blockuserinfo 10 ms - Mb
    ganalytics 10 ms - Mb
    blockmanufacturer 10 ms - Mb
    blocklayered 10 ms - Mb
    blockcurrencies 10 ms - Mb
    blockpermanentlinks 10 ms - Mb
    blockcms 10 ms - Mb
    fkcorreiosg2 10 ms - Mb
    productvideos - ms - Mb
    blocksharefb - ms - Mb
    sekeywords - ms - Mb
    pagesnotfound - ms - Mb
    fkpagseguroct - ms - Mb
    homefeatured - ms - Mb
    blockfacebook - ms - Mb
    blocktags - ms - Mb
    blockcontact - ms - Mb
    blockspecials - ms - Mb
    blocksocial - ms - Mb
    blocknewsletter - ms - Mb
    blocksupplier - ms - Mb
    blockcategories - ms - Mb
    blocknewproducts - ms - Mb
    blockviewed - ms - Mb
    blockbestsellers - ms - Mb
    blockcontactinfos - ms - Mb
    36 modules 490 ms - Mb

    Stopwatch SQL - 28 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`)
    1109.6 292501 /classes/Configuration.php:150
    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-04-08 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` = 217 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
    GROUP BY product_shop.id_product
    4.4 1 Yes Yes /classes/Product.php:3562
    SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
    WHERE `id_shop` IN (1)
    2.6 305 /classes/module/Module.php:2142
    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 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 = 217
    AND DATEDIFF(
    product_shop.`date_add`,
    DATE_SUB(
    "2020-04-08 00:00:00",
    INTERVAL 0 DAY
    )
    ) > 0
    1.3 0 /classes/Product.php:1247
    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, 285)
    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-04-08 22:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-04-08 22:04: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.9 5 Yes /classes/SpecificPrice.php:236
    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, 217) 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-04-08 22:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-04-08 22:04:00' <= `to`)
    )
    ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
    0.9 132 Yes /classes/SpecificPrice.php:302
    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, 212)
    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-04-08 22:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-04-08 22:04: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.9 4 Yes /classes/SpecificPrice.php:236
    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, 213)
    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-04-08 22:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-04-08 22:04: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.9 4 Yes /classes/SpecificPrice.php:236
    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, 229)
    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-04-08 22:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-04-08 22:04: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 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` = 217 AND pc.`validate` = 1
    ORDER BY pc.`date_add` DESC
    0.8 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, 209)
    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-04-08 22:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-04-08 22:04: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 *, ( 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, 210)
    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-04-08 22:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-04-08 22:04: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 *, ( 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, 216)
    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-04-08 22:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-04-08 22:04: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 *, ( 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, 211)
    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-04-08 22:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-04-08 22:04: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 *, ( 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, 215)
    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-04-08 22:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-04-08 22:04: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 *, ( 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, 217)
    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-04-08 22:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-04-08 22:04: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.7 4 Yes /classes/SpecificPrice.php:236
    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
    0.6 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|101|1" AND compile_id="" LIMIT 1
    0.6 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`='871ef309758644c4d905c136170a3037' AND cache_id="crossselling|productfooter|217|1|1|58" AND compile_id="" LIMIT 1
    0.6 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`='75c1153aa129f4c3d71fbc5987ab6267' AND cache_id="productscategory|217|101|1|1|58" AND compile_id="" LIMIT 1
    0.6 1 /classes/SmartyCustom.php:215
    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 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.6 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`='073dfd0f5ca3fe5bd8645fb47489b8e5' AND cache_id="blocktopmenu|1|1|58|product|217" AND compile_id="" LIMIT 1
    0.5 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`='8313f9825a0283f06187b5c71c049a69' AND cache_id="blockcms|2|1|1|58" AND compile_id="" LIMIT 1
    0.5 1 /classes/SmartyCustom.php:215
    SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1
    0.5 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.3 1 /classes/SmartyCustom.php:142

    Doubles

    10
    			SELECT *, ( IF (`id_group` = XX, XX, XX) +  IF (`id_country` = XX, XX, XX) +  IF (`id_currency` = XX, XX, XX) +  IF (`id_shop` = XX, XX, XX) +  IF (`id_customer` = XX, XX, XX)) AS `score`
    				FROM `ps_specific_price` USE INDEX (id_product_XX)
    				WHERE `id_product` IN (XX, XX)
    				AND `id_product_attribute` IN (XX, XX)
    				AND `id_shop` IN (XX, XX)
    				AND `id_currency` IN (XX, XX)
    				AND `id_country` IN (XX, XX)
    				AND `id_group` IN (XX, XX)
    				AND `id_customer` IN (XX, XX)
    				AND
    				(
    					(`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`)
    					AND
    					(`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)
    				)
    				AND id_cart IN (XX, XX)
    				AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX

    Tables stress

    11 specific_price
    8 smarty_lazy_cache
    2 smarty_last_flush
    2 configuration
    2 product_shop
    2 product_comment_usefulness
    2 hook
    2 product
    1 image_lang
    1 manufacturer
    1 stock_available
    1 product_comment
    1 customer
    1 image_shop
    1 accessory
    1 hook_alias
    1 configuration_lang
    1 hook_module_exceptions
    1 product_attribute_shop
    1 product_lang
    1 category_lang

    ObjectModel instances

    NameInstancesSource
    Product 13 /classes/Link.php [104]
    /controllers/front/ProductController.php [85]
    /modules/blockviewed/blockviewed.php [158]
    /classes/Link.php [104]
    /classes/Pack.php [125]
    /classes/Pack.php [125]
    /classes/Pack.php [125]
    /classes/Pack.php [125]
    /classes/Pack.php [125]
    /classes/Pack.php [125]
    /classes/Pack.php [125]
    /classes/Pack.php [125]
    /classes/Pack.php [125]
    Address 6 /classes/Product.php [492]
    /classes/Product.php [5012]
    /classes/Product.php [2904]
    /controllers/front/ProductController.php [314]
    /controllers/front/ProductController.php [349]
    /classes/Product.php [4367]
    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/217/d8/a1/da/d8a1da8abf688bf58803d32d4c8b88dc2ade4f61.blocktopmenu.tpl.php
    211/classes/Pack.php
    212/classes/ProductDownload.php
    213/cache/smarty/cache/productscategory/217/101/1/1/58/e4/0b/1a/e40b1aea389b255b1e152d8558f971200071dc0b.productscategory.tpl.php
    214/cache/smarty/cache/crossselling/productfooter/217/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/101/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