14 Combo - The Super Shampoo Mágico 1000ml + Máscara antiemborrachamento
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

Kit The Super Shampoo Mágico 1000ml + Máscara antiemborrachamento

Kit composto por: The SUPER Shampoo Mágico 1000ml e Máscara Reconstrutora Antiemborrachamento 300g

Veja mais detalhes

Mais detalhes

Novo

R$ 289,89 R$ 144,95 -50%

Oferta!

Aguardando CEP

Mais informações

O THE SUPER Shampoo Mágico é um produto com alta tecnologia que promove a reestruturação das fibras capilares, promovendo o liso perfeito e duradouro.

Cabelos super lisos com apenas uma lavagem. É super prático!

  • SUPER FORÇA
    Com Whey Protein, fortalece a fibra capilar proporcionando muito brilho e leveza, principalmente em cabelos tingidos e descoloridos.

  • SUPER MOVIMENTO
    Com Colágeno Hidrolisado a absorção se torna melhor e mais eficaz, proporcionando movimento e maciez.

  • SUPER SAUDÁVEL
    O THE SUPER Shampoo Mágico é livre de parabenos, sem sal e 0% formol! 

Modo de Usar: Molhe os cabelos e com o auxílio de uma toalha, retire o excesso de água. Em seguida, aplique o THE SUPER Shampoo Mágico em toda a extensão dos fios, fazendo movimentos leves e circulares até formar uma espuma densa e abundante. Evite esfregar muito o couro cabeludo. Não se deve acrescentar água para fazer espuma. Deixe o produto agir de 20 a 40 minutos. Após esse tempo, retire completamente o produtudo do cabelo com água em abundância. Seque os fios completamente com o auxílio de um secador. Divida o cabelo em mechas finas e pranche de forma lenta e contínua da raiz as pontas de 5 a 7 vezes por mecha. IMPORTANTE: a temperatura da prancha deve estar entre 180ºC e 230ºC (375ºF a 450ºF)

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.

USO PROFISSIONAL

-

Máscara Reconstrutora Antiemborrachamento, promove reconstrução e hidratação profunda dos fios. Com fórmula rica em Geleia Real, Proteínas do Leite e Óleo de Coco reestrutura e reequilibra o pH do cabelo, especialmente dos fios submetidos à coloração, descoloração, alisamento e permanente. Sua ação melhora a estrutura da fibra capilar deixando o cabelo visivelmente restaurado com brilho, maciez e vida.

Tratamento para cabelos extremamente danificados e emborrachados.

Modo de Usar: Após enxaguar os fios, aplique a Máscara Reconstrutora Antiemborrachamento - mecha a mecha. Massageie os fios e deixe o produto agir por 10 minutos na touca plástica ou térmica. Enxague e finalize.

Precauções: Uso adulto externo. Manter fora do alcance das crianças e em local fresco e ventilado. Em caso de contato acidental com os olhos, enxaguar imediatamente com água em abundância. Havendo irritação, suspender o uso e procurar orientação médica.

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

    Escreva sua opinião

    Kit The Super Shampoo Mágico 1000ml + Máscara antiemborrachamento

    Kit The Super Shampoo Mágico 1000ml + Máscara antiemborrachamento

    Kit composto por: The SUPER Shampoo Mágico 1000ml e Máscara Reconstrutora Antiemborrachamento 300g

    Escreva sua opinião

    17 outros produtos na mesma categoria

    Conteúdo do pacote

    
    Load Time4747 ms - You'd better run your shop on a toaster
    Querying Time1171 ms
    Queries43
    Memory Peak Usage83.1 Mb
    Included Files252 files - 4.54 Mb
    PrestaShop Cache0.01 Mb
    Global vars0.64 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 2111 ms 2111 ms 6.53 Mb 83.06 Mb
    __construct 0 ms 2111 ms - Mb 83.06 Mb
    init 189 ms 2300 ms 6.63 Mb 83.06 Mb
    checkAccess 0 ms 2300 ms - Mb 83.06 Mb
    setMedia 9 ms 2308 ms 0.07 Mb 83.06 Mb
    postProcess 0 ms 2308 ms - Mb 83.06 Mb
    initHeader 0 ms 2308 ms 0.01 Mb 83.06 Mb
    initContent 2316 ms 4624 ms 13.86 Mb 83.06 Mb
    initFooter 99 ms 4723 ms 0.16 Mb 83.06 Mb
    display 24 ms 4747 ms 1.65 Mb 83.06 Mb
    Hook Time Memory Usage
    hookproducttab 100 ms - Mb
    hookproducttabcontent 100 ms - Mb
    __construct 90 ms - Mb
    hookdisplayHeader 80 ms - Mb
    hookHeader 70 ms - Mb
    hookdisplayRightColumnProduct 30 ms - Mb
    hooktop 20 ms - Mb
    hookfooter 20 ms - Mb
    hookdisplayTop 10 ms - Mb
    hookproductoutofstock 10 ms - Mb
    hookdisplayProductButtons - ms - Mb
    hookextraleft - ms - Mb
    hookdisplayFooter - ms - Mb
    hookdisplayRightColumn - ms - Mb
    hookdisplayBanner - ms - Mb
    hookdisplayNav - ms - Mb
    hookdisplayTopColumn - ms - Mb
    hookdisplayLeftColumn - ms - Mb
    hookdisplayFooterProduct - ms - Mb
    hookleftcolumn - ms - Mb
    hookproductfooter - ms - Mb
    21 hooks 530 ms - Mb
    Module Time Memory Usage
    productcomments 200 ms - Mb
    bestwidget 70 ms - Mb
    blockviewed 50 ms - Mb
    notifymewhenstock 30 ms - Mb
    productvideos 30 ms - Mb
    blockcart 20 ms - Mb
    blocktopmenu 20 ms - Mb
    crossselling 10 ms - Mb
    fkpagseguroct 10 ms - Mb
    fkparcelamentog2 10 ms - Mb
    blocksearch 10 ms - Mb
    blocknewsletter 10 ms - Mb
    blockcurrencies 10 ms - Mb
    productscategory 10 ms - Mb
    blockcategories 10 ms - Mb
    blockcms 10 ms - Mb
    fkcorreiosg2 10 ms - Mb
    blockuserinfo 10 ms - Mb
    ganalytics - ms - Mb
    blocksharefb - ms - Mb
    sekeywords - ms - Mb
    pagesnotfound - ms - Mb
    homefeatured - ms - Mb
    blockfacebook - ms - Mb
    blocklayered - ms - Mb
    blockcontact - ms - Mb
    blockspecials - ms - Mb
    blocksocial - ms - Mb
    blockmanufacturer - ms - Mb
    blocktags - ms - Mb
    blockpermanentlinks - ms - Mb
    blocknewproducts - ms - Mb
    blockbestsellers - ms - Mb
    blocksupplier - ms - Mb
    blockstore - ms - Mb
    blockcontactinfos - ms - Mb
    36 modules 530 ms - Mb

    Stopwatch SQL - 43 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`)
    1110.3 291339 /classes/Configuration.php:150
    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` = 289
    23.6 1 /classes/Product.php:5640
    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(
    "2019-12-09 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` = 289 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
    GROUP BY product_shop.id_product
    5.4 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_hook_module_exceptions`
    WHERE `id_shop` IN (1)
    1.2 305 /classes/module/Module.php:2142
    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, 247)
    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 '2019-12-09 11:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2019-12-09 11: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
    1.2 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` = 289 AND pc.`validate` = 1
    ORDER BY pc.`date_add` DESC
    1.1 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, 289) 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 '2019-12-09 11:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2019-12-09 11:04:00' <= `to`)
    )
    ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
    1 442 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, 222)
    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 '2019-12-09 11:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2019-12-09 11: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
    1 4 Yes /classes/SpecificPrice.php:236
    SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1
    1 1 /classes/cache/CacheFs.php:36
    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` = 289
    0.9 1 /classes/Product.php:5583
    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` = 289
    ORDER BY `position`
    0.9 24 Yes /modules/productvideos/classes/ProductVideosClass.php:71
    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, 289)
    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 '2019-12-09 11:04:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2019-12-09 11: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 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` = 289
    AND pccl.`id_lang` = 1 AND pc.`validate` = 1
    0.9 1 /modules/productcomments/ProductComment.php:168
    SELECT SQL_NO_CACHE *
    FROM `ps_product` a
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 289) LIMIT 1
    0.8 1 /Adapter/Adapter_EntityMapper.php:61
    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|289" AND compile_id="" LIMIT 1
    0.8 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` = 289)
    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 = 289)
    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
    0.8 1 Yes /modules/productcomments/ProductCommentCriterion.php:184
    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`=289
    0.8 1 /classes/Tag.php:200
    SELECT SQL_NO_CACHE *
    FROM `ps_product_lang`
    WHERE `id_product` = 289 AND `id_shop` = 1
    0.8 1 /Adapter/Adapter_EntityMapper.php:68
    SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
    FROM `ps_product_comment` pc
    WHERE pc.`id_product` = 289
    AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
    0.8 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`='75c1153aa129f4c3d71fbc5987ab6267' AND cache_id="productscategory|289|113|1|1|58" AND compile_id="" LIMIT 1
    0.8 1 /classes/SmartyCustom.php:215
    SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
    FROM `ps_product_comment` pc
    WHERE `id_product` = 289 AND `validate` = 1 LIMIT 1
    0.8 1 /modules/productcomments/ProductComment.php:240
    SELECT SQL_NO_CACHE ctg.`id_group`
    FROM `ps_category_product` cp
    INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
    WHERE cp.`id_product` = 289 AND ctg.`id_group` = 1 LIMIT 1
    0.7 2 /classes/Product.php:4880
    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.7 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.7 1 /classes/SmartyCustom.php:95
    SELECT SQL_NO_CACHE *
    FROM `ps_product_comment` pc
    WHERE pc.`id_product` = 289
    AND pc.`id_customer` = 0
    ORDER BY pc.`date_add` DESC LIMIT 1
    0.7 1 Yes /modules/productcomments/ProductComment.php:137
    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.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` = 289
    AND image_shop.`cover` = 1 LIMIT 1
    0.7 1 /classes/Product.php:2710
    SELECT SQL_NO_CACHE out_of_stock
    FROM `ps_stock_available`
    WHERE (id_product = 289) 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 COUNT(*) FROM `ps_pack` WHERE id_product_pack = 289 LIMIT 1
    0.7 2 /classes/Pack.php:50
    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 = 289
    AND product_shop.active = 1 LIMIT 1
    0.7 1 /classes/Meta.php:259
    SELECT SQL_NO_CACHE COUNT(pc.`id_product`) AS nbr
    FROM `ps_product_comment` pc
    WHERE `id_product` = 289 AND `validate` = 1
    AND `grade` > 0 LIMIT 1
    0.7 1 /modules/productcomments/ProductComment.php:261
    SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
    FROM `ps_pack` a
    WHERE a.`id_product_item` = 289 LIMIT 1
    0.6 1 /classes/Pack.php:251
    SELECT SQL_NO_CACHE `id_product_download`
    FROM `ps_product_download`
    WHERE `id_product` = 289
    AND `active` = 1
    ORDER BY `id_product_download` DESC LIMIT 1
    0.6 0 /classes/ProductDownload.php:184
    SELECT SQL_NO_CACHE depends_on_stock
    FROM `ps_stock_available`
    WHERE (id_product = 289) 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 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` = 289
    ORDER BY `position`
    0.6 1 Yes /classes/Product.php:2690
    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|289|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|113|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`='cbc3a29d4f3113536df4c50c0c3784a0' AND cache_id="blocksocial|1|1|58" AND compile_id="" LIMIT 1
    0.6 1 /classes/SmartyCustom.php:215
    SELECT SQL_NO_CACHE id_shop
    FROM `ps_product_shop`
    WHERE `id_product` = 289
    AND id_shop = 1 LIMIT 1
    0.5 1 /classes/ObjectModel.php:1443
    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 = 289
    AND DATEDIFF(
    product_shop.`date_add`,
    DATE_SUB(
    "2019-12-09 00:00:00",
    INTERVAL 0 DAY
    )
    ) > 0
    0.4 0 /classes/Product.php:1247
    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

    3
    			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

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

    ObjectModel instances

    NameInstancesSource
    Product 9 /classes/Link.php [104]
    /controllers/front/ProductController.php [85]
    /modules/blockviewed/blockviewed.php [158]
    /classes/Pack.php [125]
    /classes/Pack.php [125]
    /classes/Link.php [104]
    /classes/Link.php [104]
    /classes/Link.php [104]
    /classes/Link.php [104]
    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/289/d8/a1/da/d8a1da8abf688bf58803d32d4c8b88dc2ade4f61.blocktopmenu.tpl.php
    211/classes/Pack.php
    212/classes/ProductDownload.php
    213/cache/smarty/cache/productscategory/289/113/1/1/58/e4/0b/1a/e40b1aea389b255b1e152d8558f971200071dc0b.productscategory.tpl.php
    214/cache/smarty/cache/crossselling/productfooter/289/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/113/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/cache/smarty/compile/31/e3/4e/31e34e3ca0c64628166e0875721ce5f9b496a82d.file.product-list.tpl.php
    240/tools/smarty/plugins/shared.make_timestamp.php
    241/cache/smarty/compile/00/a5/e9/00a5e97f05fc484bcafa20c6d0388a8ae6b5082c.file.layout.tpl.php
    242/cache/smarty/compile/37/08/84/370884646cc7e6fa65bc8562321cb8a30780b3a8.file.header.tpl.php
    243/tools/smarty/plugins/function.implode.php
    244/cache/smarty/compile/71/d5/12/71d5121e08c9afd77897ba840ad3aeb3e48b4fe9.file.breadcrumb.tpl.php
    245/cache/smarty/compile/ee/83/12/ee831268423a65dfbe706fae4c666fde42fc634e.file.footer.tpl.php
    246/cache/smarty/compile/bf/53/f8/bf53f81dad255df20c133f124e32e029b276a4cf.file.global.tpl.php
    247/cache/smarty/compile/1a/1e/32/1a1e327e673bf5ac00bccf89383d713fa7be2bf1.file.javascript.tpl.php
    248/tools/smarty/plugins/shared.mb_str_replace.php