pentatonicfunk

Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter pentatonicfunk

    (@pentatonicfunk)

    note, it might need better approach overall, even specify only ids, in general that query is slow.

    SELECT wp_qe_posts.ID
FROM wp_qe_posts
INNER JOIN wp_qe_postmeta
ON ( wp_qe_posts.ID = wp_qe_postmeta.post_id )
INNER JOIN wp_qe_postmeta AS mt1
ON ( wp_qe_posts.ID = mt1.post_id )
WHERE 1=1
AND ( wp_qe_postmeta.meta_key = 'job_entry_viewed'
AND ( ( mt1.meta_key = 'job_entry_viewed'
AND mt1.meta_value = 'no' ) ) )
AND ((wp_qe_posts.post_type = 'job-entry'
AND (wp_qe_posts.post_status = 'publish'
OR wp_qe_posts.post_status = 'future'
OR wp_qe_posts.post_status = 'draft'
OR wp_qe_posts.post_status = 'pending')))
GROUP BY wp_qe_posts.ID
ORDER BY wp_qe_posts.post_date DESC
---	
WP_Query->get_posts
WP_Query->query
WP_Query->__construct
Job_Postings_Helper::get_new_entries
JobPostType::register
do_action('init')
require_once('wp-settings.php')
require_once('wp-config.php')
require_once('wp-load.php')
require_once('wp-admin/admin.php')
---	
5.1495 seconds to complete

    @kocakserdar7 try to apply the code in mu-plugin.php

Viewing 2 replies - 1 through 2 (of 2 total)