Support » Plugin: Shortcake (Shortcode UI) » Slow Database Queries

  • kevinpowertv

    (@kevinpowertv)


    I’m having a lot of issues with this plugin and causing slow queries in my database. I’m running a multisite network and using this network activated. The slow queries are below:

    
    SELECT ID 
    FROM wp_42_posts 
    WHERE post_type = 'attachment' 
    AND post_mime_type LIKE 'audio%' 
    LIMIT 1 /* From [www.MySite.com/wp-admin/] in [/wp-content/plugins/shortcode-ui/inc/class-shortcode-ui.php:235] */	
    +
    wp_enqueue_media
    0.2589
    SELECT ID 
    FROM wp_42_posts 
    WHERE post_type = 'attachment' 
    AND post_mime_type LIKE 'video%' 
    LIMIT 1 /* From [www.MySite.com/wp-admin/] in [/wp-content/plugins/shortcode-ui/inc/class-shortcode-ui.php:235] */	
    +
    wp_enqueue_media
    0.2431
    SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month 
    FROM wp_42_posts 
    WHERE post_type = 'attachment' 
    ORDER BY post_date DESC /* From [www.MySite.com/wp-admin/] in [/wp-content/plugins/shortcode-ui/inc/class-shortcode-ui.php:235] */	
    +
    wp_enqueue_media
    0.1777
    
    Additionally, I receiving an error on a broken dependency on the main master site:
    
    Broken Dependencies		
    
    shortcode-ui
    http://www.MySite.com/wp-content/plugins/shortcode-ui/shortcode-ui.js	
    backbone
    jquery
    mce-view
    shortcode-ui-js-hooks (missing)
    1.0.3
    

    Any help would be great because my site is CRAWLING because of these errors. Thanks!

  • The topic ‘Slow Database Queries’ is closed to new replies.