WordPress.org

Ready to get started?Download WordPress

Forums

Download Monitor
slow queries (1 post)

  1. fran_scrapy
    Member
    Posted 3 years ago #

    # Time: 101120 3:35:14
    # User@Host: xxxxxxxxx[xxxxxxxxxxxx] @ localhost []
    # Query_time: 2 Lock_time: 0 Rows_sent: 4 Rows_examined: 32
    use xxxxxxx;
    SELECT wp_download_monitor_taxonomies.*, COUNT(wp_download_monitor_relationships.taxonomy_id) as count
    FROM wp_download_monitor_taxonomies
    LEFT JOIN wp_download_monitor_relationships ON wp_download_monitor_taxonomies.id = wp_download_monitor_relationships.taxonomy_id
    WHERE wp_download_monitor_taxonomies.name != ''
    AND wp_download_monitor_taxonomies.id > 0
    GROUP BY wp_download_monitor_taxonomies.id
    ORDER BY wp_download_monitor_taxonomies.parent,wp_download_monitor_taxonomies.order, wp_download_monitor_taxonomies.id;

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic