Optimize main wordpress query for high traffic site

This is my main wordpress query on index which is working, I need it written in the most efficient way (db wise) - I do not need to query post_meta

It might already be written the best way but wanted to see


if (is_home()) {

global $wp_query;

add_filter( 'posts_where' , 'posts_where' );

function posts_where( $where ) {

global $wpdb;

$where .= " AND post_content LIKE '%seen%seen%seen%'";

return $where;


$wp_query->set("tag__not_in", array(12728));

$wp_query->set("category__not_in", array(219,1649,2369,989,1169,969,1909,729,689,1869,81,2269,929,173));

$wp_query->get_posts(); } ?>

<?php if (have_posts()) : ?>

<?php while ( have_posts() ) : the_post(); ?>

<?php get_template_part( 'content' ); ?>

<?php endwhile; ?>

<?php else : ?>

<?php endif; ?>

Færdigheder: MySQL, PHP, WordPress

Se mere: db query, wordpress mysql query, php mysql optimize, query optimize, optimize wordpress site, optimize php mysql, optimize php wordpress, query optimize mysql, optimize php traffic, optimize wordpress php, optimize index, 729, wordpress mysql optimize, mysql optimize, php mysql array, php high traffic, optimize mysql high traffic, content php wordpress, optimize query mysql, mysql need optimize, mysql optimize query, optimize mysql query, optimize traffic mysql, optimize mysql php, mysql query traffic

Om arbejdsgiveren:
( 134 bedømmelser ) Houston, United States

Projekt-ID: #6053771

3 freelancere byder i gennemsnit $34 for dette job


Dear Sir, We claim to get it done perfectly for you EXACTLY in the way you want it - Kindly give we a chance and we will prove myself - Ready to prove our words, let's get it done right away and I mean RIGHT AWAY !! Mere

$54 USD på 1 dag
(56 bedømmelser)

I am chirag, Let me resolve it Please give me ftp access so i can resolve it right now Thanks Chirag

$29 USD på 1 dag
(41 bedømmelser)

Hi, I have 3+ years experience in wordpress. I have created lots of wordpress theme and plugin. I can complete your requirement with my confidence. So please come on chat with me. I can start work now . Thanks,

$25 USD på 1 dag
(10 bedømmelser)

We are '3stechmind' team of dedicated software professionals developing the web projects for our clients.Our area of expertise is design the web site and implement the functional aspects in software technolgies like ph Mere

$24 USD på 1 dag
(2 bedømmelser)