Máscara Restauradora Noblesse K - 800g

Videos Magic

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

Máscara Restauradora Noblesse K - 800g

Um produto. Doze benefícios. Com a máscara Noblesse K., você tem um tratamento completo em um produto que, além de cuidar dos cabelos, é ideal para diluir os matizadores da Magic.

Veja mais detalhes

Mais detalhes

214

Novo

R$ 52,80

Aguardando CEP

Mais informações

Um produto. Doze benefícios.

O CC CREAM CAPILAR 12 em 1 é uma máscara multifunções, ideal para quem deseja fazer vários tratamentos ao mesmo tempo. Possui, em sua composição, ativos compatíveis com todos os tipos de cabelos, podendo ser usado no dia a dia. Além disso, seu pH ácido sela o fio, dando brilho, hidratação, controle antifrizz e reposição de toda a massa capilar perdida por meio dos processos químicos. Sua fórmula é ideal para quem quer diluir os matizadores e melhorar o equilíbrio na tonalidade desejada com maior durabilidade.

Os 12 benefícios:

1. Ação antioxidante

2. Brilho intenso

3. Controle de volume

4. Eliminação do efeito “build up” (acúmulo de resíduos que resultam em cabelos pesados e sem movimento)

5. Hidratação dos fios

6. Prevenção de pontas duplas

7. Proteção da cor

8. Proteção térmica

9. Redução do frizz

10. Reposição de massa

11. Selamento de cutículas

12. Nutrição


Modo de usar como tratamento:

Após lavar os cabelos com shampoo, aplique a máscara Noblesse K. nos cabelos levemente úmidos. Massageie suavemente mecha por mecha do comprimento até as pontas. Deixe agir por 15 minutos. Em seguida, enxágue abundantemente.

Modo de usar diluído em matizadores:

Após lavar os cabelos com shampoo, dilua o matizador de sua preferência na máscara Noblesse K., na proporção de 2 para 1, isto é, 2 porções da Noblesse K. para 1 porção do seu matizador preferido Magic Profissional. Faça o teste em uma mecha antes. Assim, você saberá o resultado com maior precisão. Siga as intruções de uso do matizador.

Precauções:

Manter fora do alcance de crianças. Uso externo adulto. Em caso de contato com os olhos, enxágue com água em abundância. Havendo irritação, suspenda o uso. Caso a irritação persista, procure orientação médica.

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

    Escreva sua opinião

    Máscara Restauradora Noblesse K - 800g

    Máscara Restauradora Noblesse K - 800g

    Um produto. Doze benefícios. Com a máscara Noblesse K., você tem um tratamento completo em um produto que, além de cuidar dos cabelos, é ideal para diluir os matizadores da Magic.

    Escreva sua opinião

    6 outros produtos na mesma categoria

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

    Anterior
    • Kit Plástica dos Fios + Shampoo Ativador Coffee Break

      Kit Plástica...


      Uma pausa para o liso perfeito! Dê uma pausa...

    • Sérum Fortalecedor Sobran Fix

      Sérum...


      Ativa e acelera o crescimento natural Sobran...

    • Magic Plex Exclusive Blond 90 ml

      Magic Plex...


      O sistema Magic Plex penetra no fio mais rápido...

    • Platinagem Exclusive Blond Champagne - Efeito Perolado - 350 ml

      Platinagem...


      A Platinagem da Linha Exclusive Blond age como...

    • Coloração 12.11 - Loiro Extra Claro Cinza Intenso Platinado Exclusive Blond 60g

      Coloração...


      A Coloração em Creme Exclusive Blond promove...

    • Coloração 9.89 - Loiro Muito Claro Pérola Exclusive Blond 60g

      Coloração...


      A Coloração em Creme Exclusive Blond promove...

    • Loção Reveladora 30 Volumes - 90ml

      Loção...


      A Loção Reveladora Exclusive Magic 30 Volumes é...

    • Booster Mix 0.6 - Corretor Vermelho 60g

      Booster Mix...


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

    • Mini Matizador Magic Color - Efeito Prata - 100ml

      Mini...


      Tratamento desamarelador para cabelos loiros...

    • Condicionador Rapunzel 300 ml

      Condicionado...


      O Condicionador Rapunzel tem sua fórmula...

    Próximo
    
    Load Time6534 ms - You'd better run your shop on a toaster
    Querying Time1098 ms
    Queries94
    Memory Peak Usage83.3 Mb
    Included Files252 files - 4.52 Mb
    PrestaShop Cache0.01 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 2015 ms 2015 ms 6.49 Mb 83.29 Mb
    __construct 0 ms 2015 ms - Mb 83.29 Mb
    init 468 ms 2483 ms 6.34 Mb 83.29 Mb
    checkAccess 0 ms 2483 ms - Mb 83.29 Mb
    setMedia 12 ms 2495 ms 0.26 Mb 83.29 Mb
    postProcess 0 ms 2495 ms - Mb 83.29 Mb
    initHeader 0 ms 2495 ms 0.01 Mb 83.29 Mb
    initContent 3906 ms 6401 ms 14.65 Mb 83.29 Mb
    initFooter 112 ms 6513 ms 0.16 Mb 83.29 Mb
    display 21 ms 6534 ms 1.41 Mb 83.29 Mb
    Hook Time Memory Usage
    hookproducttabcontent 130 ms - Mb
    __construct 110 ms - Mb
    hookHeader 110 ms - Mb
    hookdisplayHeader 100 ms - Mb
    hookproducttab 90 ms - Mb
    hookdisplayRightColumnProduct 30 ms - Mb
    hookproductfooter 10 ms - Mb
    hookdisplayProductButtons 10 ms - Mb
    hooktop 10 ms - Mb
    hookdisplayNav 10 ms - Mb
    hookdisplayTop 10 ms - Mb
    hookproductoutofstock - ms - Mb
    hookfooter - ms - Mb
    hookdisplayFooter - 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 620 ms - Mb
    Module Time Memory Usage
    productcomments 220 ms - Mb
    bestwidget 100 ms - Mb
    blockviewed 100 ms - Mb
    notifymewhenstock 20 ms - Mb
    productvideos 20 ms - Mb
    fkcorreiosg2 20 ms - Mb
    blocksearch 20 ms - Mb
    blockpermanentlinks 20 ms - Mb
    productscategory 20 ms - Mb
    blocktopmenu 10 ms - Mb
    blockuserinfo 10 ms - Mb
    ganalytics 10 ms - Mb
    fkparcelamentog2 10 ms - Mb
    blockcart 10 ms - Mb
    blocknewsletter 10 ms - Mb
    blocklayered 10 ms - Mb
    blockcms 10 ms - Mb
    crossselling - ms - Mb
    fkpagseguroct - ms - Mb
    sekeywords - ms - Mb
    pagesnotfound - ms - Mb
    blocksharefb - ms - Mb
    homefeatured - ms - Mb
    blockfacebook - ms - Mb
    blockcurrencies - ms - Mb
    blockcontact - ms - Mb
    blockspecials - ms - Mb
    blocksocial - ms - Mb
    blockmanufacturer - ms - Mb
    blocktags - ms - Mb
    blocknewproducts - ms - Mb
    blockcategories - ms - Mb
    blockbestsellers - ms - Mb
    blocksupplier - ms - Mb
    blockstore - ms - Mb
    blockcontactinfos - ms - Mb
    36 modules 620 ms - Mb

    Stopwatch SQL - 94 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`)
    1013.9 289181 /classes/Configuration.php:150
    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 = 312
    AND product_shop.active = 1 LIMIT 1
    8 1 /classes/Meta.php:259
    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-01-18 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` = 312 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 c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
    FROM `ps_category` c
    INNER JOIN ps_category_shop category_shop
    ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
    LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1  AND cl.id_shop = 1 )
    LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
    WHERE `id_parent` = 116
    AND `active` = 1
    AND cg.`id_group` =1
    GROUP BY c.`id_category`
    ORDER BY `level_depth` ASC, category_shop.`position` ASC
    3.8 1 Yes Yes /classes/Category.php:658
    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.*, product_shop.*, pl.*, image_shop.`id_image` id_image, il.`legend`, cl.`name` AS category_default, a.quantity AS pack_quantity, product_shop.`id_category_default`, a.id_product_pack, a.id_product_attribute_item
    FROM `ps_pack` a
    LEFT JOIN `ps_product` p ON p.id_product = a.id_product_item
    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_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)
    INNER JOIN ps_product_shop product_shop
    ON (product_shop.id_product = p.id_product AND product_shop.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 
    WHERE product_shop.`id_shop` = 1
    AND a.`id_product_pack` = 314
    GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
    1.7 4 Yes /classes/Pack.php:196
    SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
    WHERE `id_shop` IN (1)
    1.6 305 /classes/module/Module.php:2142
    SELECT SQL_NO_CACHE p.*, product_shop.*, pl.*, image_shop.`id_image` id_image, il.`legend`, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute
    FROM `ps_product` p
    NATURAL LEFT JOIN `ps_product_lang` pl
    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_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)
    WHERE pl.`id_lang` = 1
    AND pl.id_shop = 1 
    AND p.`id_product` IN (314)
    GROUP BY p.id_product LIMIT 1
    1.5 0 Yes /classes/Pack.php:276
    SELECT SQL_NO_CACHE *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 310) AND (b.`id_shop` = 1) LIMIT 1
    1.3 1 /Adapter/Adapter_EntityMapper.php:61
    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, 314)
    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-01-18 10:05:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-01-18 10:05: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.3 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, 310)
    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-01-18 10:05:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-01-18 10:05: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 *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 309) AND (b.`id_shop` = 1) LIMIT 1
    1.2 1 /Adapter/Adapter_EntityMapper.php:61
    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, 309)
    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-01-18 10:05:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-01-18 10:05: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 *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 312) AND (b.`id_shop` = 1) LIMIT 1
    1.1 1 /Adapter/Adapter_EntityMapper.php:61
    SELECT SQL_NO_CACHE *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 314) AND (b.`id_shop` = 1) LIMIT 1
    1.1 1 /Adapter/Adapter_EntityMapper.php:61
    SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
    FROM ps_category c
    LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
    INNER JOIN ps_category_shop category_shop
    ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
    WHERE c.nleft <= 12
    AND c.nright >= 13
    AND c.nleft >= 2
    AND c.nright <= 43
    AND cl.id_lang = 1
    AND c.active = 1
    AND c.level_depth > 1
    ORDER BY c.level_depth ASC
    1.1 17 Yes /classes/Tools.php:1301
    SELECT SQL_NO_CACHE *
    FROM `ps_category` a
    LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
    LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
    WHERE (a.`id_category` = 116) AND (b.`id_shop` = 1) LIMIT 1
    1 1 /Adapter/Adapter_EntityMapper.php:61
    SELECT SQL_NO_CACHE *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
    WHERE (a.`id_product` = 311) AND (b.`id_shop` = 1) LIMIT 1
    1 1 /Adapter/Adapter_EntityMapper.php:61
    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, 312) 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-01-18 10:05:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-01-18 10:05:00' <= `to`)
    )
    ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
    1 331 Yes /classes/SpecificPrice.php:302
    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` = 312) LIMIT 1
    0.8 1 /Adapter/Adapter_EntityMapper.php:61
    SELECT SQL_NO_CACHE *
    FROM `ps_product_comment` pc
    WHERE pc.`id_product` = 312
    AND pc.`id_customer` = 0
    ORDER BY pc.`date_add` DESC LIMIT 1
    0.8 1 Yes /modules/productcomments/ProductComment.php:137
    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, 312)
    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-01-18 10:05:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-01-18 10:05: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, 311)
    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-01-18 10:05:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-01-18 10:05: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` = 312 AND pc.`validate` = 1
    ORDER BY pc.`date_add` DESC
    0.8 1 Yes /modules/productcomments/ProductComment.php:114
    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` = 312
    0.8 1 /classes/Product.php:5583
    SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
    FROM `ps_pack` a
    WHERE a.`id_product_item` = 312 LIMIT 1
    0.8 1 /classes/Pack.php:251
    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` = 312
    0.8 1 /classes/Product.php:5640
    SELECT SQL_NO_CACHE *
    FROM `ps_product_lang`
    WHERE `id_product` = 312 AND `id_shop` = 1
    0.8 1 /Adapter/Adapter_EntityMapper.php:68
    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` = 312
    AND image_shop.`cover` = 1 LIMIT 1
    0.8 1 /classes/Product.php:2710
    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` = 312
    ORDER BY `position`
    0.8 24 Yes /modules/productvideos/classes/ProductVideosClass.php:71
    SELECT SQL_NO_CACHE id_product_item, id_product_attribute_item, quantity FROM `ps_pack` where id_product_pack = 314
    0.8 4 /classes/Pack.php:122
    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` = 312
    AND pccl.`id_lang` = 1 AND pc.`validate` = 1
    0.8 1 /modules/productcomments/ProductComment.php:168
    SELECT SQL_NO_CACHE SUM(quantity)
    FROM `ps_stock_available`
    WHERE (id_product = 314) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.8 1 /classes/stock/StockAvailable.php:378
    SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_item = 314 LIMIT 1
    0.8 1 /classes/Pack.php:75
    SELECT SQL_NO_CACHE SUM(quantity)
    FROM `ps_stock_available`
    WHERE (id_product = 309) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.8 1 /classes/stock/StockAvailable.php:378
    SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
    FROM `ps_specific_price_priority`
    WHERE `id_product` = 314
    ORDER BY `id_specific_price_priority` DESC LIMIT 1
    0.8 1 /classes/SpecificPrice.php:188
    SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
    0 as id_product_attribute
    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` = 311)
    0.7 1 /classes/Product.php:2961
    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 nleft, nright, level_depth
    FROM ps_category
    WHERE id_category = 116 LIMIT 1
    0.7 1 /classes/Category.php:1468
    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` = 312 AND ctg.`id_group` = 1 LIMIT 1
    0.7 2 /classes/Product.php:4880
    SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 311 LIMIT 1
    0.7 1 /classes/Pack.php:50
    SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 310 LIMIT 1
    0.7 1 /classes/Pack.php:50
    SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
    0 as id_product_attribute
    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` = 309)
    0.7 1 /classes/Product.php:2961
    SELECT SQL_NO_CACHE id_shop
    FROM `ps_product_shop`
    WHERE `id_product` = 312
    AND id_shop = 1 LIMIT 1
    0.7 1 /classes/ObjectModel.php:1443
    SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
    0 as id_product_attribute
    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` = 312)
    0.7 1 /classes/Product.php:2961
    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.7 1 /classes/SmartyCustom.php:215
    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`=312
    0.7 5 /classes/Tag.php:200
    SELECT SQL_NO_CACHE `reduction`
    FROM `ps_product_group_reduction_cache`
    WHERE `id_product` = 310 AND `id_group` = 1 LIMIT 1
    0.7 0 /classes/GroupReduction.php:149
    SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
    0 as id_product_attribute
    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` = 314)
    0.7 1 /classes/Product.php:2961
    SELECT SQL_NO_CACHE COUNT(pc.`id_product`) AS nbr
    FROM `ps_product_comment` pc
    WHERE `id_product` = 312 AND `validate` = 1
    AND `grade` > 0 LIMIT 1
    0.7 1 /modules/productcomments/ProductComment.php:261
    SELECT SQL_NO_CACHE `reduction`
    FROM `ps_product_group_reduction_cache`
    WHERE `id_product` = 311 AND `id_group` = 1 LIMIT 1
    0.7 0 /classes/GroupReduction.php:149
    SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
    FROM `ps_specific_price_priority`
    WHERE `id_product` = 311
    ORDER BY `id_specific_price_priority` DESC LIMIT 1
    0.7 1 /classes/SpecificPrice.php:188
    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|116|1" AND compile_id="" LIMIT 1
    0.7 1 /classes/SmartyCustom.php:215
    SELECT SQL_NO_CACHE out_of_stock
    FROM `ps_stock_available`
    WHERE (id_product = 311) 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 `reduction`
    FROM `ps_product_group_reduction_cache`
    WHERE `id_product` = 309 AND `id_group` = 1 LIMIT 1
    0.7 0 /classes/GroupReduction.php:149
    SELECT SQL_NO_CACHE `reduction`
    FROM `ps_product_group_reduction_cache`
    WHERE `id_product` = 312 AND `id_group` = 1 LIMIT 1
    0.7 0 /classes/GroupReduction.php:149
    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|312|116|1|1|58" AND compile_id="" LIMIT 1
    0.7 1 /classes/SmartyCustom.php:215
    SELECT SQL_NO_CACHE SUM(quantity)
    FROM `ps_stock_available`
    WHERE (id_product = 312) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.6 1 /classes/stock/StockAvailable.php:378
    SELECT SQL_NO_CACHE cl.`link_rewrite`
    FROM `ps_category_lang` cl
    WHERE `id_lang` = 0
    AND cl.id_shop = 1 
    AND cl.`id_category` = 116 LIMIT 1
    0.6 0 /classes/Category.php:1053
    SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 309 LIMIT 1
    0.6 1 /classes/Pack.php:50
    SELECT SQL_NO_CACHE `id_tax_rules_group`
    FROM `ps_product_shop`
    WHERE `id_product` = 312 AND id_shop=1 LIMIT 1
    0.6 1 /classes/Product.php:4996
    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 `id_tax_rules_group`
    FROM `ps_product_shop`
    WHERE `id_product` = 310 AND id_shop=1 LIMIT 1
    0.6 1 /classes/Product.php:4996
    SELECT SQL_NO_CACHE SUM(quantity)
    FROM `ps_stock_available`
    WHERE (id_product = 310) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.6 1 /classes/stock/StockAvailable.php:378
    SELECT SQL_NO_CACHE depends_on_stock
    FROM `ps_stock_available`
    WHERE (id_product = 309) 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 depends_on_stock
    FROM `ps_stock_available`
    WHERE (id_product = 311) 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 `priority`, `id_specific_price_priority`
    FROM `ps_specific_price_priority`
    WHERE `id_product` = 310
    ORDER BY `id_specific_price_priority` DESC LIMIT 1
    0.6 1 /classes/SpecificPrice.php:188
    SELECT SQL_NO_CACHE out_of_stock
    FROM `ps_stock_available`
    WHERE (id_product = 310) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.6 1 /classes/stock/StockAvailable.php:670
    SELECT SQL_NO_CACHE out_of_stock
    FROM `ps_stock_available`
    WHERE (id_product = 312) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.6 1 /classes/stock/StockAvailable.php:670
    SELECT SQL_NO_CACHE `id_tax_rules_group`
    FROM `ps_product_shop`
    WHERE `id_product` = 309 AND id_shop=1 LIMIT 1
    0.6 1 /classes/Product.php:4996
    SELECT SQL_NO_CACHE id_shop
    FROM `ps_category_shop`
    WHERE `id_category` = 116
    AND id_shop = 1 LIMIT 1
    0.6 1 /classes/ObjectModel.php:1443
    SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1
    0.6 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`='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 (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
    FROM `ps_product_comment` pc
    WHERE pc.`id_product` = 312
    AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
    0.6 1 /modules/productcomments/ProductComment.php:197
    SELECT SQL_NO_CACHE out_of_stock
    FROM `ps_stock_available`
    WHERE (id_product = 309) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.6 1 /classes/stock/StockAvailable.php:670
    SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
    FROM `ps_product_comment` pc
    WHERE `id_product` = 312 AND `validate` = 1 LIMIT 1
    0.6 1 /modules/productcomments/ProductComment.php:240
    SELECT SQL_NO_CACHE `id_tax_rules_group`
    FROM `ps_product_shop`
    WHERE `id_product` = 311 AND id_shop=1 LIMIT 1
    0.6 1 /classes/Product.php:4996
    SELECT SQL_NO_CACHE `id_tax_rules_group`
    FROM `ps_product_shop`
    WHERE `id_product` = 314 AND id_shop=1 LIMIT 1
    0.6 1 /classes/Product.php:4996
    SELECT SQL_NO_CACHE `id_product_download`
    FROM `ps_product_download`
    WHERE `id_product` = 312
    AND `active` = 1
    ORDER BY `id_product_download` DESC LIMIT 1
    0.6 0 /classes/ProductDownload.php:184
    SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 312 LIMIT 1
    0.6 1 /classes/Pack.php:50
    SELECT SQL_NO_CACHE depends_on_stock
    FROM `ps_stock_available`
    WHERE (id_product = 312) 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 SUM(quantity)
    FROM `ps_stock_available`
    WHERE (id_product = 311) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.5 1 /classes/stock/StockAvailable.php:378
    SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
    0 as id_product_attribute
    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` = 310)
    0.5 1 /classes/Product.php:2961
    SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
    FROM `ps_specific_price_priority`
    WHERE `id_product` = 309
    ORDER BY `id_specific_price_priority` DESC LIMIT 1
    0.5 1 /classes/SpecificPrice.php:188
    SELECT SQL_NO_CACHE `reduction`
    FROM `ps_product_group_reduction_cache`
    WHERE `id_product` = 314 AND `id_group` = 1 LIMIT 1
    0.5 0 /classes/GroupReduction.php:149
    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` = 312)
    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 = 312)
    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.5 1 Yes /modules/productcomments/ProductCommentCriterion.php:184
    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|312|1|1|58" AND compile_id="" LIMIT 1
    0.5 1 /classes/SmartyCustom.php:215
    SELECT SQL_NO_CACHE depends_on_stock
    FROM `ps_stock_available`
    WHERE (id_product = 310) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.5 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` = 312
    ORDER BY `position`
    0.5 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`='073dfd0f5ca3fe5bd8645fb47489b8e5' AND cache_id="blocktopmenu|1|1|58|product|312" AND compile_id="" LIMIT 1
    0.5 1 /classes/SmartyCustom.php:215
    SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
    FROM `ps_specific_price_priority`
    WHERE `id_product` = 312
    ORDER BY `id_specific_price_priority` DESC LIMIT 1
    0.5 1 /classes/SpecificPrice.php:188
    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 = 312
    AND DATEDIFF(
    product_shop.`date_add`,
    DATE_SUB(
    "2020-01-18 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

    5
    			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
    5
    SELECT product_shop.`price`, product_shop.`ecotax`,
    XX as id_product_attribute
    FROM `ps_product` p
    INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX)
    WHERE (p.`id_product` = XX)
    
    5
    							SELECT `id_tax_rules_group`
    							FROM `ps_product_shop`
    							WHERE `id_product` = XX AND id_shop=XX LIMIT XX
    5
    SELECT SUM(quantity)
    FROM `ps_stock_available`
    WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
    5
    				SELECT `priority`, `id_specific_price_priority`
    				FROM `ps_specific_price_priority`
    				WHERE `id_product` = XX
    				ORDER BY `id_specific_price_priority` DESC LIMIT XX
    5
    			SELECT `reduction`
    			FROM `ps_product_group_reduction_cache`
    			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
    5
    SELECT *
    FROM `ps_product` a
    LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
    LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
    WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
    4
    SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
    4
    SELECT depends_on_stock
    FROM `ps_stock_available`
    WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
    4
    SELECT out_of_stock
    FROM `ps_stock_available`
    WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX

    Tables stress

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

    ObjectModel instances

    NameInstancesSource
    Product 8 /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]
    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]
    Category 3 /controllers/front/ProductController.php [158]
    /classes/Link.php [177]
    /classes/Link.php [177]
    Country 2 /config/config.inc.php [142]
    /classes/controller/FrontController.php [279]
    Language 2 /config/config.inc.php [195]
    /classes/Tools.php [498]
    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/312/d8/a1/da/d8a1da8abf688bf58803d32d4c8b88dc2ade4f61.blocktopmenu.tpl.php
    211/classes/Pack.php
    212/classes/ProductDownload.php
    213/cache/smarty/cache/productscategory/312/116/1/1/58/e4/0b/1a/e40b1aea389b255b1e152d8558f971200071dc0b.productscategory.tpl.php
    214/cache/smarty/cache/crossselling/productfooter/312/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/cache/smarty/compile/f7/85/67/f78567ff50fcd5bc265aece25ad6cc8518ba69ff.file.productvideos16.tpl.php
    222/modules/fkparcelamentog2/fkparcelamentog2.php
    223/modules/fkparcelamentog2/models/FKparcg2Class.php
    224/cache/smarty/compile/0f/b6/c8/0fb6c89ef684c26354d75876d69699b769d277dd.file.simuladorProduto.tpl.php
    225/cache/smarty/compile/3a/dd/1b/3add1ba86487391b28df0b12b32cd6f867f0ca5a.file.buttonproduct.tpl.php
    226/cache/smarty/compile/ca/64/33/ca64333c2ceb310ec879f256f4a0e813a7612866.file.simuladorBoxAdicCarrinho.tpl.php
    227/modules/productcomments/ProductComment.php
    228/modules/productcomments/ProductCommentCriterion.php
    229/cache/smarty/compile/f9/54/59/f95459b5f6143dd88bbf83f58a47ad68cabd4d5d.file.tab.tpl.php
    230/cache/smarty/compile/f6/f7/e3/f6f7e35a2233c6426a0fb77a5f2188c195e77274.file.productcomments.tpl.php
    231/cache/smarty/cache/blocksocial/1/1/58/df/9b/d2/df9bd2af84f5eb3c6e3887bddcb51d172eff218d.blocksocial.tpl.php
    232/cache/smarty/cache/blockcategories/1/1/58/116/1/68/39/d4/6839d49633dfd54754208befb570a70dd465e171.blockcategories_footer.tpl.php
    233/cache/smarty/cache/blockcms/2/1/1/58/07/24/fb/0724fbaaac3c4aa9366121af99fae75e77b0a6dd.blockcms.tpl.php
    234/cache/smarty/compile/69/b1/7e/69b17eaec965936113c6d5d69742c048ca196e79.file.product.tpl.php
    235/tools/smarty/plugins/modifier.date_format.php
    236/tools/smarty/plugins/function.math.php
    237/cache/smarty/compile/41/c5/cf/41c5cf6fc51ca86eaafa4431ee9c974e99ac95ca.file.errors.tpl.php
    238/cache/smarty/compile/0e/4b/8c/0e4b8c024cda563f33e0093ee36aab67ad53fc7d.file.product-desc-default.tpl.php
    239/tools/smarty/plugins/function.cycle.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