Same wordpress Query running like 100-times, what is this?!!

M4GN3T · Dec 19, 2010

Hi Guys,

Im trying to reduce querys on my big blogs, but i keep running into one query thats in my logs like a 100 times everytime on a pageload. Does anyone know what this is, what it does and how i can get rid of it??

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (3222) ORDER BY t.name ASC

SELECT t.*, tt.* FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN wp_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (3189) ORDER BY t.name ASC

And as u can see the only thing that changes is the tr.object_id..what does this query do guys?

Because this one gets requested so much,

M4GN3T · Dec 21, 2010

no one can help me with this ?

876Fearless · Dec 21, 2010

Maybe your database is corrupt?

Remington · Dec 22, 2010

what does this query do

It looks like it's constructing some form of list. The tr.object_id would be the list items, and the ORDER BY t.name ASC determines how they're displayed. (By whatever the t.name is, and in ASCending order, in this case).

dannyhw · Dec 22, 2010

It has to do with tags and categories.

M4GN3T · Dec 22, 2010

So that means its rolling out the Tag Cloud then or something?..

Same wordpress Query running like 100-times, what is this?!!

M4GN3T

Junior Member

M4GN3T

Junior Member

876Fearless

Newbie

Remington

Regular Member

dannyhw

Senior Member

M4GN3T

Junior Member

Main Menu

Marketplace

Making Money

BlackHat World