{"id":293,"date":"2015-09-22T12:43:18","date_gmt":"2015-09-22T12:43:18","guid":{"rendered":"http:\/\/www.eminozlem.com\/?p=293"},"modified":"2015-09-22T12:57:44","modified_gmt":"2015-09-22T12:57:44","slug":"fastest-way-to-get-1-post-id-in-wordpress","status":"publish","type":"post","link":"https:\/\/eminozlem.com\/tr\/fastest-way-to-get-1-post-id-in-wordpress\/","title":{"rendered":"Fastest way to get 1 post->ID in WordPress"},"content":{"rendered":"

So all you need is a post->ID whats the fastest way to get it ?<\/p>\n

<\/i> Jump to conclusion<\/a> or lets evaluate our options here:<\/p>\n

query_posts()<\/code>, get_posts()<\/code>,wp_query()<\/code>, $wpdb<\/code><\/p>\n

As a rule of thumb, usually we can say $wpdb > wp_query > get_posts > query_posts, meaning; you should almost never ever use query_posts<\/code>. And usually between the two, wp_query.<\/code> performs better over get_posts<\/code> in most situations, and querying the db directly via $wpdb is often the most efficient way eventhough wp_query is safer.<\/p>\n

For results there is no difference, you will end up with 1 ID.<\/p>\n

\"gp1idsspUntitled-1\"<\/a><\/p>\n

Like I said above query_posts is almost never needed, lets get that out of the way with a simple query_posts vs get_posts test:<\/p>\n

\"gpvssgpp\"<\/a><\/p>\n

That leaves us with wp_query, get_posts and $wpdb. Lets take a look at get_posts vs wp_query. (Please note that I’ve used 3 different WP_query args sets, you can see all the functions below)<\/p>\n

\"gg2Clipboard01\"<\/a><\/p>\n

The difference is not all that big, but get_posts is the winner compared to __wp_query_add_args_no_cache .( wpquery with additional args for optimal performance )<\/p>\n

So lets pick a winner is it gonna be get_posts or $wpdb ? As expected $wpdb is the clear winner here:<\/p>\n

\"wpdbwwUntitled-1\"<\/a><\/p>\n

Concluison: If all you need is 1 random post->ID, simply use $wpdb<\/p>\n

Here are all the functions used:<\/p>\n

\tfunction eo_get_an_id_queryposts() {\r\n\t\t$get_one_id_args = array(\r\n\t\t\t'orderby' => 'rand',\r\n\t\t\t'posts_per_page' => '1',\r\n\t\t\t'fields' => 'ids'\r\n\t\t);\r\n\t\t$rand_post_id_arr = query_posts( $get_one_id_args );\r\n\t\t$rand_post_id = $rand_post_id_arr[0];\r\n\t\t\/\/ intval it because id returns as string\r\n\t\treturn intval($rand_post_id);\r\n\t}\r\n\tfunction eo_get_an_id_getposts() {\r\n\t\t$get_one_id_args = array(\r\n\t\t\t'orderby' => 'rand',\r\n\t\t\t'posts_per_page' => '1',\r\n\t\t\t'fields' => 'ids'\r\n\t\t);\r\n\t\t$rand_post_id_arr = get_posts( $get_one_id_args );\r\n\t\t$rand_post_id = $rand_post_id_arr[0];\r\n\t\t\/\/ intval it because id returns as string\r\n\t\treturn intval($rand_post_id);\r\n\t}\r\n\t\r\n\tfunction eo_get_an_id_wpquery_min_args() {\r\n\t\t$get_one_id_args = array(\r\n\t\t\t'orderby' => 'rand',\r\n\t\t\t'posts_per_page' => '1',\r\n\t\t);\r\n\t\t$get_an_id_qy = new WP_Query( $get_one_id_args );\r\n\t\t$get_an_id_qy_result_arr = $get_an_id_qy->posts;\r\n\t\t\/\/ no point on going forward if no posts found.\r\n\t\tif( empty($get_an_id_qy_result_arr) ) return false;\r\n\t\t\/\/ Get the->ID from the post object.\r\n\t\t$rand_post_obj = $get_an_id_qy_result_arr[0];\r\n\t\t$rand_post_id = $rand_post_obj->ID ;\r\n\t\treturn $rand_post_id;\r\n\t}\r\n\tfunction eo_get_an_id_wpquery_add_args() {\r\n\t\t$get_one_id_args = array(\r\n\t\t\t'orderby' => 'rand',\r\n\t\t\t'posts_per_page' => '1',\r\n\t\t\t'fields' => 'ids'\r\n\t\t);\r\n\t\t$get_an_id_qy = new WP_Query( $get_one_id_args );\r\n\t\t$get_an_id_qy_result_arr = $get_an_id_qy->posts;\r\n\t\t\/\/ no point on going forward if no posts found.\r\n\t\tif( empty($get_an_id_qy_result_arr) ) return false;\r\n\t\t$rand_post_id = $get_an_id_qy_result_arr[0];\r\n\t\t\/\/ intval it because id returns as string\r\n\t\treturn intval($rand_post_id);\r\n\r\n\t}\r\n\t\r\n\tfunction eo_get_an_id_wpquery_add_args_nocache() {\r\n\t\t$get_one_id_args = array(\r\n\t\t\t'orderby' => 'rand',\r\n\t\t\t'posts_per_page' => '1',\r\n\t\t\t'fields' => 'ids',\r\n\t\t\t'no_found_rows' => true,\r\n\t\t\t'cache_results'=>false,\r\n\t\t\t'update_post_term_cache' => false,\r\n\t\t\t'update_post_meta_cache' => false,\r\n\t\t);\r\n\t\t$get_an_id_qy = new WP_Query( $get_one_id_args );\r\n\t\t$get_an_id_qy_result_arr = $get_an_id_qy->posts;\r\n\t\t\/\/ no point on going forward if no posts found.\r\n\t\tif( empty($get_an_id_qy_result_arr) ) return false;\r\n\t\t$rand_post_id = $get_an_id_qy_result_arr[0];\r\n\t\t\/\/ intval it because id returns as string\r\n\t\treturn intval($rand_post_id);\r\n\r\n\t}\r\n\tfunction eo_get_an_id_add_wpdb() {\r\n\t\tglobal $wpdb;\r\n\t\t$rand_post_id = $wpdb->get_var(\"SELECT ID FROM $wpdb->posts WHERE post_status = 'publish' AND post_type = 'post' ORDER BY RAND() LIMIT 1\");\r\n\t\t\/\/ intval it because id returns as string\r\n\t\treturn intval($rand_post_id);\r\n\t}<\/pre>\n","protected":false},"excerpt":{"rendered":"
So all you need is a post->ID whats the fastest way to get it ? Jump to conclusion or lets evaluate our options here: query_posts(), get_posts(),wp_query(), $wpdb As a rule of thumb, usually we can say $wpdb > wp_query > get_posts > query_posts, meaning; you should almost never ever use query_posts. And usually between the…<\/p>\n","protected":false},"author":1,"featured_media":301,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-293","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-web"],"acf":[],"_links":{"self":[{"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/posts\/293","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/comments?post=293"}],"version-history":[{"count":0,"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/posts\/293\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/media\/301"}],"wp:attachment":[{"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/media?parent=293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/categories?post=293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/eminozlem.com\/tr\/wp-json\/wp\/v2\/tags?post=293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}