WordPress.org

Ready to get started?Download WordPress

Forums

SLOW LOG - SQL Queries (2 posts)

  1. qdubois
    Member
    Posted 2 years ago #

    Dear all,

    it seems that my server enconter issue since i updated to wp 3.3.2. Two queries are eating alive our server, we have installed nice cache plugin (wp-super-cache) and we still have a lot of issues.

    here they are :

    SELECT ID, post_author, post_date, post_date_gmt, post_status, post_name, post_modified, post_modified_gmt, post_parent, post_type FROM wp_posts WHERE ( (post_status = 'publish' AND (post_type = 'post' OR post_type = '')) OR (post_status = 'publish' AND post_type = 'page') ) AND post_password='' ORDER BY post_modified DESC;

    and

    SELECT SQL_CALC_FOUND_ROWS wp_posts.* FROM wp_posts INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (5,350,398,567,1350,1748,1702,1743,1752,1754,1755,1756,1757,1758,1759,1761,1762,1763,1764,1765,1766,1768,1769,1770,1771,1774,1777,1778,1779,1789,1790,1791,1792,1793,1794,1795,1796,1797,1798,1799,1800,1801,1802,1803,1804,1805,1806,1807,1831,1825,1821,1823,1827,1828,1829,1830,1832,1833,1836,1842,1838,1839,1840,1841,1843,1844,1845,1846,1847,1857,1858,1853,1854,1855,1856) AND wp_posts.ID NOT IN (
    SELECT object_id
    FROM wp_term_relationships
    WHERE term_taxonomy_id IN (351)
    ) ) AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish') GROUP BY wp_posts.ID ORDER BY wp_posts.post_date DESC LIMIT 0, 6;

    Could you help us?

    thank a lot

    q

  2. qdubois
    Member
    Posted 2 years ago #

    any ideas?

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.