Print

[copperminepro]

I've been trying to track down this query from the slow log but sadly I have no idea where it is coming from.. It's the number 2 contender in my slow query log (next to getting users upload counts by cpmfetch  )

Now, I know on the gallery index this query appears for picture counts on albums, which I really would like to keep intact.

The query appears like this:

SELECT * FROM cpg1411_pictures WHERE approved = 'YES' AND aid IN (2,3,4,5,6,7,8,9,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29 ----------------------- ,549,550,551)

So it's checking something like 551 albums... Is this the query that checks the total number of pictures? It's frequently taking 2 seconds to execute.

Where can I find this query? What is this query doing?