Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: AND aid IN query - help  (Read 1893 times)

0 Members and 1 Guest are viewing this topic.

copperminepro

  • Contributor
  • Coppermine novice
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 48
AND aid IN query - help
« on: February 25, 2008, 02:25:05 am »

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?




Logged
Pages: [1]   Go Up
 

Page created in 0.014 seconds with 19 queries.