Pó Descolorante Exclusive Blond 500g
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

Pó Descolorante Exclusive Blond 500g

O revolucionário Pó descolorante Exclusive Blond é um descolorante capilar que tem alto poder de clareamento permitindo alcançar os tons loiros perolados e platinados mais claros com resultados puros e luminosos, além de deixar os fios mais saudáveis. 

Veja mais detalhes

Mais detalhes

189

Novo

R$ 88,00

Aguardando CEP

Mais informações

O revolucionário Pó descolorante Exclusive Blond é um descolorante capilar que tem alto pode de clareamento permitindo alcançar os tons loiros perolados e platinados mais claros com resultados puros e luminosos, além de deixar os fios mais saudáveis. Sua formulação é apropriada para profissionais que são especialistas em loiros e é composta por Queratina, que recupera o fio durante o processo de descoloração e mantém a resistência da fibra e um Blend de 10 óleos com: Algodão, Macadâmia Abacate, Germem de Trigo, Milho, Óleo de Girassol, Cártamo, Semente de Linhaça e Seme Di Lino que tratam o cabelo, controlam o pH e mantém a umidade do fio para que o clareamento ocorra de maneira segura garantindo a qualidade suprema do cabelo loiro.

Com sua textura de alta aderência, não incha evitando o risco de manchar, não camufla, pois tem efeito translúcido White que permite visualizar e controlar todo o processo de clareamento dos fios, facilitando a visibilidade da cor real e possui ainda o Anti Yellow, agente anti-amarelamento que atua junto do pigmento Feomelanina para reduzir os tons amarelos. Pode ser utilizado em todos os serviços de descoloração: mechas no papel, touca, ao ar livre e clareamento global.

Preparo: Em um recipiente não metálico misture na proporção de 1 medida de Pó Descolorante para 2 medidas de Água Oxigenada na volumagem adequada para a técnica escolhida, até obter uma consistência homogênea e cremosa.

Modo de Usar: Aplique a mistura com um pincel e use luvas adequadas. Faça uma prova de toque antes de aplicar o produto. O tempo de ação deverá ser controlado pelo profissional em função do grau de clareamento desejado. Após o tempo de pausa enxaguar com água morna e shampoo.

Precauções: Cuidado. Contém substâncias passíveis de causar irritação na pele de determinadas pessoas. Antes de usar, faça a prova de toque. Pode causar reação alérgica. Não usar nos cílios e sobrancelhas. Não aplicar se o couro cabeludo estiver irritado ou lesionado. Evitar contato com os olhos. Em caso de contato com os olhos, lavar imediatamente com água em abundância. Usar luvas adequadas. Contém Amônia. Manter fora do alcance das crianças. Guardar o produto ao abrigo da luz, em local seco e fresco, com tampa bem fechada.

Prova de Toque: Prepare um pouco desse produto como se fosse utilizá-lo. Aplique no antebraço ou atrás da orelha. Deixe agir por 30 minutos. Lave o local. Aguarde 24 horas e se neste período surgir irritação na pele, coceira ou ardência no local ou na proximidade, fica comprovada a hipersensibilidade da pessoa ao produto e, portanto, o produto não deve ser utilizado.

 USO PROFISSIONAL: 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

    Pó Descolorante Exclusive Blond 500g

    Pó Descolorante Exclusive Blond 500g

    O revolucionário Pó descolorante Exclusive Blond é um descolorante capilar que tem alto poder de clareamento permitindo alcançar os tons loiros perolados e platinados mais claros com resultados puros e luminosos, além de deixar os fios mais saudáveis. 

    Escreva sua opinião

    9 outros produtos na mesma categoria

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

    Anterior
    • Loção Reveladora Exclusive Blond 30 Volumes - 900 ml

      Loção...


      A Loção Reveladora Exclusive Blond 30 volumes,...

    • Mulheres Superpoderosas - Máscara de Hidratação para Arrasar 230g

      Mulheres...


      A Máscara de Hidratação para Arrasar foi...

    • Coloração 11.13 - Loiro Platino Mate Intenso Exclusive Blond 60g

      Coloração...


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

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

      Gloss...


      Tratamento desamarelador para cabelos loiros...

    • Loção Reveladora 4 Volumes - 90ml

      Loção...


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

    • Coloração 1.0 - Preto 60g

      Coloração...


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

    • Coloração 11.89 - Loiro Platino Pérola Intenso 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 é...

    • Estabilizador de pH Banho de Vinagre Capilar

      Estabilizado...


      O Estabilizador de pH – Passo 1 – da linha...

    • Platinagem Exclusive Blond Champagne - Efeito Perolado - 350 ml

      Platinagem...


      A Platinagem da Linha Exclusive Blond age como...

    Próximo
    
    Load Time5733 ms - You'd better run your shop on a toaster
    Querying Time1521 ms
    Queries86
    Memory Peak Usage82.1 Mb
    Included Files251 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 2103 ms 2103 ms 5.31 Mb 82.11 Mb
    __construct 0 ms 2104 ms - Mb 82.11 Mb
    init 66 ms 2169 ms 4.35 Mb 82.11 Mb
    checkAccess 0 ms 2169 ms - Mb 82.11 Mb
    setMedia 8 ms 2178 ms 0.26 Mb 82.11 Mb
    postProcess 0 ms 2178 ms - Mb 82.11 Mb
    initHeader 0 ms 2178 ms 0.01 Mb 82.11 Mb
    initContent 3502 ms 5680 ms 14.51 Mb 82.11 Mb
    initFooter 27 ms 5707 ms 0.16 Mb 82.11 Mb
    display 26 ms 5733 ms 1.41 Mb 82.11 Mb
    Hook Time Memory Usage
    hookdisplayHeader 2650 ms - Mb
    hookdisplayNav 400 ms - Mb
    __construct 120 ms - Mb
    hookHeader 110 ms - Mb
    hookproductfooter 50 ms - Mb
    hookproducttab 20 ms - Mb
    hookdisplayRightColumnProduct 20 ms - Mb
    hookproducttabcontent 20 ms - Mb
    hookdisplayTop 20 ms - Mb
    hooktop 20 ms 0.25 Mb
    hookfooter 10 ms - Mb
    hookdisplayTopColumn 10 ms - Mb
    hookdisplayFooter - ms - Mb
    hookdisplayProductButtons - ms - Mb
    hookproductoutofstock - ms - Mb
    hookdisplayRightColumn - ms - Mb
    hookdisplayBanner - ms - Mb
    hookdisplayLeftColumn - ms - Mb
    hookleftcolumn - ms - Mb
    hookdisplayFooterProduct - ms - Mb
    hookextraleft - ms - Mb
    21 hooks 3450 ms 0.25 Mb
    Module Time Memory Usage
    bestwidget 2650 ms - Mb
    blockpermanentlinks 380 ms - Mb
    productcomments 50 ms - Mb
    blocktopmenu 50 ms - Mb
    productscategory 40 ms - Mb
    blockviewed 30 ms - Mb
    notifymewhenstock 30 ms - Mb
    crossselling 30 ms - Mb
    blocksearch 20 ms - Mb
    fkpagseguroct 20 ms - Mb
    productvideos 20 ms - Mb
    fkcorreiosg2 20 ms - Mb
    blocktags 10 ms - Mb
    blockcategories 10 ms - Mb
    blockcontactinfos 10 ms - Mb
    ganalytics 10 ms - Mb
    blocksharefb 10 ms - Mb
    fkparcelamentog2 10 ms - Mb
    sekeywords 10 ms - Mb
    blocksupplier 10 ms - Mb
    blockcms 10 ms - Mb
    blockcurrencies 10 ms - Mb
    blockcart 10 ms 0.25 Mb
    pagesnotfound - ms - Mb
    homefeatured - ms - Mb
    blockfacebook - ms - Mb
    blockcontact - ms - Mb
    blockspecials - ms - Mb
    blocksocial - ms - Mb
    blocklayered - ms - Mb
    blockmanufacturer - ms - Mb
    blockuserinfo - ms - Mb
    blockbestsellers - ms - Mb
    blockstore - ms - Mb
    blocknewsletter - ms - Mb
    blocknewproducts - ms - Mb
    36 modules 3450 ms 0.25 Mb

    Stopwatch SQL - 86 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`)
    1081.7 293829 /classes/Configuration.php:150
    SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
    265.5 1 /classes/SmartyCustom.php:95
    SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
    WHERE `template_hash`='a105af890fb6ec9d6712e2c495c85004' AND cache_id="blockpermanentlinks-header|1|1|58" AND compile_id="" LIMIT 1
    70 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
    34.2 1 /classes/SmartyCustom.php:142
    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` = 115
    AND `active` = 1
    AND cg.`id_group` =1
    GROUP BY c.`id_category`
    ORDER BY `level_depth` ASC, category_shop.`position` ASC
    6.8 1 Yes Yes /classes/Category.php:658
    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 (279,280,281,295)
    GROUP BY p.id_product LIMIT 1
    6.4 4 Yes Yes /classes/Pack.php:276
    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` = 255 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
    GROUP BY product_shop.id_product
    5.1 1 Yes Yes /classes/Product.php:3562
    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|255" AND compile_id="" LIMIT 1
    2.4 1 /classes/SmartyCustom.php:215
    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 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` = 279
    GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
    1.5 3 Yes /classes/Pack.php:196
    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` = 255
    1.4 1 /classes/Product.php:5583
    SELECT SQL_NO_CACHE `id_product_download`
    FROM `ps_product_download`
    WHERE `id_product` = 255
    AND `active` = 1
    ORDER BY `id_product_download` DESC LIMIT 1
    1.3 0 /classes/ProductDownload.php:184
    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` = 258) 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, 279)
    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:10:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-01-18 10:10: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 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, 260)
    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:10:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-01-18 10:10: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 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` = 255
    0.9 1 /classes/Product.php:5640
    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, 255) 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:10:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-01-18 10:10:00' <= `to`)
    )
    ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
    0.9 331 Yes /classes/SpecificPrice.php:302
    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` = 279) AND (b.`id_shop` = 1) LIMIT 1
    0.9 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` = 260) AND (b.`id_shop` = 1) LIMIT 1
    0.9 1 /Adapter/Adapter_EntityMapper.php:61
    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` = 255) LIMIT 1
    0.9 1 /Adapter/Adapter_EntityMapper.php:61
    SELECT SQL_NO_CACHE id_product_item, id_product_attribute_item, quantity FROM `ps_pack` where id_product_pack = 279
    0.8 3 /classes/Pack.php:122
    SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
    WHERE `id_shop` IN (1)
    0.8 305 /classes/module/Module.php:2142
    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 <= 19
    AND c.nright >= 20
    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
    0.8 17 Yes /classes/Tools.php:1301
    SELECT SQL_NO_CACHE *
    FROM `ps_product_comment` pc
    WHERE pc.`id_product` = 255
    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 `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 = 255
    AND product_shop.active = 1 LIMIT 1
    0.8 1 /classes/Meta.php:259
    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` = 255 AND pc.`validate` = 1
    ORDER BY pc.`date_add` DESC
    0.8 1 Yes /modules/productcomments/ProductComment.php:114
    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|255|115|1|1|58" AND compile_id="" LIMIT 1
    0.8 1 /classes/SmartyCustom.php:215
    SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 58, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
    FROM `ps_specific_price` USE INDEX (id_product_2)
    WHERE `id_product` IN (0, 258)
    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:10:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-01-18 10:10: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 SUM(quantity)
    FROM `ps_stock_available`
    WHERE (id_product = 258) 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 = 279 LIMIT 1
    0.7 1 /classes/Pack.php:75
    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` = 255) AND (b.`id_shop` = 1) LIMIT 1
    0.7 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`='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` = 255
    AND image_shop.`cover` = 1 LIMIT 1
    0.7 1 /classes/Product.php:2710
    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, 255)
    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:10:00' >= `from`)
    AND
    (`to` = '0000-00-00 00:00:00' OR '2020-01-18 10:10:00' <= `to`)
    )
    AND id_cart IN (0, 0)
    AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
    0.7 4 Yes /classes/SpecificPrice.php:236
    SELECT SQL_NO_CACHE 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` = 255
    AND pccl.`id_lang` = 1 AND pc.`validate` = 1
    0.6 1 /modules/productcomments/ProductComment.php:168
    SELECT SQL_NO_CACHE *
    FROM `ps_product_lang`
    WHERE `id_product` = 255 AND `id_shop` = 1
    0.6 1 /Adapter/Adapter_EntityMapper.php:68
    SELECT SQL_NO_CACHE id_shop
    FROM `ps_category_shop`
    WHERE `id_category` = 115
    AND id_shop = 1 LIMIT 1
    0.6 1 /classes/ObjectModel.php:1443
    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` = 255)
    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 = 255)
    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.6 1 Yes /modules/productcomments/ProductCommentCriterion.php:184
    SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
    FROM `ps_pack` a
    WHERE a.`id_product_item` = 255 LIMIT 1
    0.6 4 /classes/Pack.php:251
    SELECT SQL_NO_CACHE depends_on_stock
    FROM `ps_stock_available`
    WHERE (id_product = 258) 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 COUNT(*) FROM `ps_pack` WHERE id_product_pack = 260 LIMIT 1
    0.6 1 /classes/Pack.php:50
    SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
    FROM `ps_specific_price_priority`
    WHERE `id_product` = 258
    ORDER BY `id_specific_price_priority` DESC LIMIT 1
    0.6 1 /classes/SpecificPrice.php:188
    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 nleft, nright, level_depth
    FROM ps_category
    WHERE id_category = 115 LIMIT 1
    0.6 1 /classes/Category.php:1468
    SELECT SQL_NO_CACHE `reduction`
    FROM `ps_product_group_reduction_cache`
    WHERE `id_product` = 260 AND `id_group` = 1 LIMIT 1
    0.6 0 /classes/GroupReduction.php:149
    SELECT SQL_NO_CACHE out_of_stock
    FROM `ps_stock_available`
    WHERE (id_product = 258) 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 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 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 = 255
    AND DATEDIFF(
    product_shop.`date_add`,
    DATE_SUB(
    "2020-01-18 00:00:00",
    INTERVAL 0 DAY
    )
    ) > 0
    0.5 0 /classes/Product.php:1247
    SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
    FROM `ps_specific_price_priority`
    WHERE `id_product` = 260
    ORDER BY `id_specific_price_priority` DESC LIMIT 1
    0.5 1 /classes/SpecificPrice.php:188
    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` = 255
    ORDER BY `position`
    0.5 24 Yes /modules/productvideos/classes/ProductVideosClass.php:71
    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` = 279)
    0.5 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`='871ef309758644c4d905c136170a3037' AND cache_id="crossselling|productfooter|255|1|1|58" AND compile_id="" LIMIT 1
    0.5 1 /classes/SmartyCustom.php:215
    SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 255 LIMIT 1
    0.5 1 /classes/Pack.php:50
    SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
    FROM `ps_specific_price_priority`
    WHERE `id_product` = 279
    ORDER BY `id_specific_price_priority` DESC LIMIT 1
    0.5 1 /classes/SpecificPrice.php:188
    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` = 255
    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`='8313f9825a0283f06187b5c71c049a69' AND cache_id="blockcms|2|1|1|58" AND compile_id="" LIMIT 1
    0.5 1 /classes/SmartyCustom.php:215
    SELECT SQL_NO_CACHE 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` = 260)
    0.5 1 /classes/Product.php:2961
    SELECT SQL_NO_CACHE COUNT(pc.`id_product`) AS nbr
    FROM `ps_product_comment` pc
    WHERE `id_product` = 255 AND `validate` = 1
    AND `grade` > 0 LIMIT 1
    0.5 1 /modules/productcomments/ProductComment.php:261
    SELECT SQL_NO_CACHE (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
    FROM `ps_product_comment` pc
    WHERE pc.`id_product` = 255
    AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
    0.5 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`='6d4021b6746a542135d3f9f7c5647a12' AND cache_id="blockcategories|1|1|58|115|1" AND compile_id="" LIMIT 1
    0.5 1 /classes/SmartyCustom.php:215
    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` = 115 LIMIT 1
    0.5 0 /classes/Category.php:1053
    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` = 258)
    0.5 1 /classes/Product.php:2961
    SELECT SQL_NO_CACHE `id_tax_rules_group`
    FROM `ps_product_shop`
    WHERE `id_product` = 279 AND id_shop=1 LIMIT 1
    0.5 1 /classes/Product.php:4996
    SELECT SQL_NO_CACHE COUNT(`id_product_comment`) AS "nbr"
    FROM `ps_product_comment` pc
    WHERE `id_product` = 255 AND `validate` = 1 LIMIT 1
    0.5 1 /modules/productcomments/ProductComment.php:240
    SELECT SQL_NO_CACHE cl.`link_rewrite`
    FROM `ps_category_lang` cl
    WHERE `id_lang` = 1
    AND cl.id_shop = 1 
    AND cl.`id_category` = 107 LIMIT 1
    0.4 1 /classes/Category.php:1053
    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`=255
    0.4 2 /classes/Tag.php:200
    SELECT SQL_NO_CACHE SUM(quantity)
    FROM `ps_stock_available`
    WHERE (id_product = 279) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.4 1 /classes/stock/StockAvailable.php:378
    SELECT SQL_NO_CACHE `reduction`
    FROM `ps_product_group_reduction_cache`
    WHERE `id_product` = 279 AND `id_group` = 1 LIMIT 1
    0.4 0 /classes/GroupReduction.php:149
    SELECT SQL_NO_CACHE `reduction`
    FROM `ps_product_group_reduction_cache`
    WHERE `id_product` = 258 AND `id_group` = 1 LIMIT 1
    0.4 0 /classes/GroupReduction.php:149
    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` = 115) AND (b.`id_shop` = 1) LIMIT 1
    0.4 1 /Adapter/Adapter_EntityMapper.php:61
    SELECT SQL_NO_CACHE SUM(quantity)
    FROM `ps_stock_available`
    WHERE (id_product = 260) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.4 1 /classes/stock/StockAvailable.php:378
    SELECT SQL_NO_CACHE depends_on_stock
    FROM `ps_stock_available`
    WHERE (id_product = 260) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.4 1 /classes/stock/StockAvailable.php:646
    SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
    FROM `ps_specific_price_priority`
    WHERE `id_product` = 255
    ORDER BY `id_specific_price_priority` DESC LIMIT 1
    0.4 1 /classes/SpecificPrice.php:188
    SELECT SQL_NO_CACHE cl.`link_rewrite`
    FROM `ps_category_lang` cl
    WHERE `id_lang` = 1
    AND cl.id_shop = 1 
    AND cl.`id_category` = 115 LIMIT 1
    0.4 1 /classes/Category.php:1053
    SELECT SQL_NO_CACHE SUM(quantity)
    FROM `ps_stock_available`
    WHERE (id_product = 255) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.4 1 /classes/stock/StockAvailable.php:378
    SELECT SQL_NO_CACHE depends_on_stock
    FROM `ps_stock_available`
    WHERE (id_product = 255) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.4 1 /classes/stock/StockAvailable.php:646
    SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 258 LIMIT 1
    0.4 1 /classes/Pack.php:50
    SELECT SQL_NO_CACHE `reduction`
    FROM `ps_product_group_reduction_cache`
    WHERE `id_product` = 255 AND `id_group` = 1 LIMIT 1
    0.4 0 /classes/GroupReduction.php:149
    SELECT SQL_NO_CACHE `id_tax_rules_group`
    FROM `ps_product_shop`
    WHERE `id_product` = 258 AND id_shop=1 LIMIT 1
    0.3 1 /classes/Product.php:4996
    SELECT SQL_NO_CACHE out_of_stock
    FROM `ps_stock_available`
    WHERE (id_product = 260) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.3 1 /classes/stock/StockAvailable.php:670
    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` = 255)
    0.3 1 /classes/Product.php:2961
    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` = 255 AND ctg.`id_group` = 1 LIMIT 1
    0.3 1 /classes/Product.php:4880
    SELECT SQL_NO_CACHE `id_tax_rules_group`
    FROM `ps_product_shop`
    WHERE `id_product` = 260 AND id_shop=1 LIMIT 1
    0.3 1 /classes/Product.php:4996
    SELECT SQL_NO_CACHE `id_tax_rules_group`
    FROM `ps_product_shop`
    WHERE `id_product` = 255 AND id_shop=1 LIMIT 1
    0.3 1 /classes/Product.php:4996
    SELECT SQL_NO_CACHE id_shop
    FROM `ps_product_shop`
    WHERE `id_product` = 255
    AND id_shop = 1 LIMIT 1
    0.3 1 /classes/ObjectModel.php:1443
    SELECT SQL_NO_CACHE out_of_stock
    FROM `ps_stock_available`
    WHERE (id_product = 255) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
    0.3 1 /classes/stock/StockAvailable.php:670

    Doubles

    4
    			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
    4
    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)
    
    4
    			SELECT `reduction`
    			FROM `ps_product_group_reduction_cache`
    			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
    4
    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
    4
    				SELECT `priority`, `id_specific_price_priority`
    				FROM `ps_specific_price_priority`
    				WHERE `id_product` = XX
    				ORDER BY `id_specific_price_priority` DESC LIMIT XX
    4
    							SELECT `id_tax_rules_group`
    							FROM `ps_product_shop`
    							WHERE `id_product` = XX AND id_shop=XX LIMIT XX
    4
    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
    3
    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
    3
    SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = XX LIMIT XX
    3
    			SELECT cl.`link_rewrite`
    			FROM `ps_category_lang` cl
    			WHERE `id_lang` = XX
    			 AND cl.id_shop = XX 
    			AND cl.`id_category` = XX LIMIT XX
    3
    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

    Tables stress

    20 product_shop
    14 product
    11 stock_available
    9 product_lang
    8 smarty_lazy_cache
    8 category_lang
    7 pack
    6 product_comment
    5 specific_price
    5 image_shop
    4 category_shop
    4 product_attribute_shop
    4 image_lang
    4 category
    4 specific_price_priority
    4 product_group_reduction_cache
    2 attribute
    2 product_attribute_combination
    2 product_attribute
    2 product_comment_usefulness
    2 hook
    2 product_comment_criterion
    2 image
    2 configuration
    2 category_group
    2 smarty_last_flush
    2 product_comment_criterion_lang
    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 7 /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]
    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/255/d8/a1/da/d8a1da8abf688bf58803d32d4c8b88dc2ade4f61.blocktopmenu.tpl.php
    211/classes/Pack.php
    212/classes/ProductDownload.php
    213/cache/smarty/cache/productscategory/255/115/1/1/58/e4/0b/1a/e40b1aea389b255b1e152d8558f971200071dc0b.productscategory.tpl.php
    214/cache/smarty/cache/crossselling/productfooter/255/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/115/1/68/39/d4/6839d49633dfd54754208befb570a70dd465e171.blockcategories_footer.tpl.php
    232/cache/smarty/cache/blockcms/2/1/1/58/07/24/fb/0724fbaaac3c4aa9366121af99fae75e77b0a6dd.blockcms.tpl.php
    233/cache/smarty/compile/69/b1/7e/69b17eaec965936113c6d5d69742c048ca196e79.file.product.tpl.php
    234/tools/smarty/plugins/modifier.date_format.php
    235/tools/smarty/plugins/function.math.php
    236/cache/smarty/compile/41/c5/cf/41c5cf6fc51ca86eaafa4431ee9c974e99ac95ca.file.errors.tpl.php
    237/cache/smarty/compile/0e/4b/8c/0e4b8c024cda563f33e0093ee36aab67ad53fc7d.file.product-desc-default.tpl.php
    238/tools/smarty/plugins/function.cycle.php
    239/tools/smarty/plugins/shared.make_timestamp.php
    240/cache/smarty/compile/00/a5/e9/00a5e97f05fc484bcafa20c6d0388a8ae6b5082c.file.layout.tpl.php
    241/cache/smarty/compile/37/08/84/370884646cc7e6fa65bc8562321cb8a30780b3a8.file.header.tpl.php
    242/tools/smarty/plugins/function.implode.php
    243/cache/smarty/compile/71/d5/12/71d5121e08c9afd77897ba840ad3aeb3e48b4fe9.file.breadcrumb.tpl.php
    244/cache/smarty/compile/ee/83/12/ee831268423a65dfbe706fae4c666fde42fc634e.file.footer.tpl.php
    245/cache/smarty/compile/bf/53/f8/bf53f81dad255df20c133f124e32e029b276a4cf.file.global.tpl.php
    246/cache/smarty/compile/1a/1e/32/1a1e327e673bf5ac00bccf89383d713fa7be2bf1.file.javascript.tpl.php
    247/tools/smarty/plugins/shared.mb_str_replace.php