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; ?>

Evner: MySQL, PHP, WordPress

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

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

Projekt ID: #6053771

3 freelancere byder i gennemsnit $34 på 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 !! Flere

$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 [url removed, login to view] area of expertise is design the web site and implement the functional aspects in software technolgies like ph Flere

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