Find extreme long query on ps 1.7.6.X SELECT COUNT ( DISTINCTROW `id_product` ) FROM

[Matteo]

Hi, i'm tring to find where this parts of a query is used in the prestashop core, with no luck. This is the most resource consuming query our database run every day, there is someone that can help me undestood where this query is called and why?

 

i've only a truncated parts of the query in my sql log:

 

SELECT

  COUNT ( DISTINCTROW `id_product` )

FROM

  `ps_specific_price`

WHERE

  `id_product` != ?

LIMIT

  ?

 

[wepresta]

Hello,

active _PS_DEBUG_PROFILING_ = true and try to find out more about it