This week only. Pastebin PRO Accounts Christmas Special! Don't miss out!Want more features on Pastebin? Sign Up, it's FREE!
Guest

Untitled

By: a guest on Aug 27th, 2012  |  syntax: None  |  size: 4.66 KB  |  views: 25  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Query Number: 1
  2. WP Query Object:
  3. object(WP_Query)#226 (43) {
  4.   ["query_vars"]=>
  5.   &array(55) {
  6.     ["error"]=>
  7.     string(0) ""
  8.     ["m"]=>
  9.     int(0)
  10.     ["p"]=>
  11.     int(0)
  12.     ["post_parent"]=>
  13.     string(0) ""
  14.     ["subpost"]=>
  15.     string(0) ""
  16.     ["subpost_id"]=>
  17.     string(0) ""
  18.     ["attachment"]=>
  19.     string(0) ""
  20.     ["attachment_id"]=>
  21.     int(0)
  22.     ["name"]=>
  23.     string(0) ""
  24.     ["static"]=>
  25.     string(0) ""
  26.     ["pagename"]=>
  27.     string(0) ""
  28.     ["page_id"]=>
  29.     int(0)
  30.     ["second"]=>
  31.     string(0) ""
  32.     ["minute"]=>
  33.     string(0) ""
  34.     ["hour"]=>
  35.     string(0) ""
  36.     ["day"]=>
  37.     int(0)
  38.     ["monthnum"]=>
  39.     int(0)
  40.     ["year"]=>
  41.     int(0)
  42.     ["w"]=>
  43.     int(0)
  44.     ["category_name"]=>
  45.     string(0) ""
  46.     ["tag"]=>
  47.     string(0) ""
  48.     ["cat"]=>
  49.     string(0) ""
  50.     ["tag_id"]=>
  51.     string(0) ""
  52.     ["author_name"]=>
  53.     string(0) ""
  54.     ["feed"]=>
  55.     string(0) ""
  56.     ["tb"]=>
  57.     string(0) ""
  58.     ["paged"]=>
  59.     int(0)
  60.     ["comments_popup"]=>
  61.     string(0) ""
  62.     ["meta_key"]=>
  63.     string(0) ""
  64.     ["meta_value"]=>
  65.     string(0) ""
  66.     ["preview"]=>
  67.     string(0) ""
  68.     ["s"]=>
  69.     string(0) ""
  70.     ["sentence"]=>
  71.     string(0) ""
  72.     ["fields"]=>
  73.     string(0) ""
  74.     ["category__in"]=>
  75.     array(0) {
  76.     }
  77.     ["category__not_in"]=>
  78.     array(0) {
  79.     }
  80.     ["category__and"]=>
  81.     array(0) {
  82.     }
  83.     ["post__in"]=>
  84.     array(0) {
  85.     }
  86.     ["post__not_in"]=>
  87.     array(0) {
  88.     }
  89.     ["tag__in"]=>
  90.     array(0) {
  91.     }
  92.     ["tag__not_in"]=>
  93.     array(0) {
  94.     }
  95.     ["tag__and"]=>
  96.     array(0) {
  97.     }
  98.     ["tag_slug__in"]=>
  99.     array(0) {
  100.     }
  101.     ["tag_slug__and"]=>
  102.     array(0) {
  103.     }
  104.     ["ignore_sticky_posts"]=>
  105.     bool(false)
  106.     ["suppress_filters"]=>
  107.     bool(false)
  108.     ["cache_results"]=>
  109.     bool(true)
  110.     ["update_post_term_cache"]=>
  111.     bool(true)
  112.     ["update_post_meta_cache"]=>
  113.     bool(true)
  114.     ["post_type"]=>
  115.     string(0) ""
  116.     ["posts_per_page"]=>
  117.     int(10)
  118.     ["nopaging"]=>
  119.     bool(false)
  120.     ["comments_per_page"]=>
  121.     string(2) "50"
  122.     ["no_found_rows"]=>
  123.     bool(false)
  124.     ["order"]=>
  125.     string(4) "DESC"
  126.   }
  127.   ["tax_query"]=>
  128.   object(WP_Tax_Query)#16 (2) {
  129.     ["queries"]=>
  130.     array(0) {
  131.     }
  132.     ["relation"]=>
  133.     string(3) "AND"
  134.   }
  135.   ["meta_query"]=>
  136.   object(WP_Meta_Query)#180 (2) {
  137.     ["queries"]=>
  138.     array(0) {
  139.     }
  140.     ["relation"]=>
  141.     NULL
  142.   }
  143.   ["post_count"]=>
  144.   int(0)
  145.   ["current_post"]=>
  146.   int(-1)
  147.   ["in_the_loop"]=>
  148.   bool(false)
  149.   ["comment_count"]=>
  150.   int(0)
  151.   ["current_comment"]=>
  152.   int(-1)
  153.   ["found_posts"]=>
  154.   int(0)
  155.   ["max_num_pages"]=>
  156.   int(0)
  157.   ["max_num_comment_pages"]=>
  158.   int(0)
  159.   ["is_single"]=>
  160.   bool(false)
  161.   ["is_preview"]=>
  162.   bool(false)
  163.   ["is_page"]=>
  164.   bool(false)
  165.   ["is_archive"]=>
  166.   bool(false)
  167.   ["is_date"]=>
  168.   bool(false)
  169.   ["is_year"]=>
  170.   bool(false)
  171.   ["is_month"]=>
  172.   bool(false)
  173.   ["is_day"]=>
  174.   bool(false)
  175.   ["is_time"]=>
  176.   bool(false)
  177.   ["is_author"]=>
  178.   bool(false)
  179.   ["is_category"]=>
  180.   bool(false)
  181.   ["is_tag"]=>
  182.   bool(false)
  183.   ["is_tax"]=>
  184.   bool(false)
  185.   ["is_search"]=>
  186.   bool(false)
  187.   ["is_feed"]=>
  188.   bool(false)
  189.   ["is_comment_feed"]=>
  190.   bool(false)
  191.   ["is_trackback"]=>
  192.   bool(false)
  193.   ["is_home"]=>
  194.   bool(true)
  195.   ["is_404"]=>
  196.   bool(false)
  197.   ["is_comments_popup"]=>
  198.   bool(false)
  199.   ["is_paged"]=>
  200.   bool(false)
  201.   ["is_admin"]=>
  202.   bool(false)
  203.   ["is_attachment"]=>
  204.   bool(false)
  205.   ["is_singular"]=>
  206.   bool(false)
  207.   ["is_robots"]=>
  208.   bool(false)
  209.   ["is_posts_page"]=>
  210.   bool(false)
  211.   ["is_post_type_archive"]=>
  212.   bool(false)
  213.   ["query_vars_hash"]=>
  214.   string(32) "b52c7201ac0659efd0fc727f3f37d361"
  215.   ["query_vars_changed"]=>
  216.   bool(false)
  217.   ["thumbnails_cached"]=>
  218.   bool(false)
  219.   ["query"]=>
  220.   array(0) {
  221.   }
  222.   ["request"]=>
  223.   string(217) "SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')  ORDER BY wp_posts.post_date DESC LIMIT 0, 10"
  224. }
  225. Original SQL Query:
  226. string(217) "SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')  ORDER BY wp_posts.post_date DESC LIMIT 0, 10"
  227. Result SQL Query:
  228. string(334) "SELECT SQL_CALC_FOUND_ROWS  wp_posts.* FROM wp_posts  LEFT JOIN wp_q2w3_post_order ON (wp_posts.ID = wp_q2w3_post_order.post_id AND wp_q2w3_post_order.post_type = 'post') WHERE 1=1  AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')  ORDER BY wp_posts.post_date DESC LIMIT 0, 10"
clone this paste RAW Paste Data