The same SQL query 99 times on my pages (only pages) (3 posts)

  1. riversatile
    Posted 2 years ago #

    On my pages (not posts), there are 143 SQL queries !

    The following query appears 99 times :
    SELECT t.*, tt.* FROM xxx_terms AS t INNER JOIN xxx_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN xxx_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (443) ORDER BY t.name ASC
    This is the mess !

    Have you got any idea where they can come and what do they do ?

    Many thanks for your help.

  2. catacaustic
    very awesome
    Posted 2 years ago #

    Exactly what do you you mean by "appears"? is it a query that's being sent to the MySQL erver 99 times for every page, or is it actually appearing on the page?

    Either way there's a good chance that it's either your theme or some plugin that's causing that becuase that's not a standard query - especially as there's no place-holders et for the db table prefix. The way to see what's happening is to deactivate every plugin (yes, every one, I mean that), and change back to the default un-edited theme and see if the problem is still there. It most liekly wpon't be, spo go back and re-enable each plugin one-by-one and check after each one to see if the problem occurs again. This will let you see exactly what's causing the problem.

  3. riversatile
    Posted 2 years ago #


    It seems to be the plugin "Widget Logic"

Topic Closed

This topic has been closed to new replies.

About this Topic