phpMyProfiler Profile log of keralaonline.com on 24th March 2009

• SQL Duration: 12.678422  URL: /tag/erumely-town  TIME: Mar 24, 2009 12:14:59 pm
• No of Profiles: 5  View
• • 12.67778300Update kol_posts set post_hits = post_hits + 1 WHERE ID=21959

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00000	0.00000	0.00000	0.00000
    Table lock	12.67687	12.67687	36.54000	36.54000
    init	0.00005	0.00005	0.00000	0.00000
    Updating	0.00041	0.00041	0.00000	0.00000
    end	0.00040	0.00040	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00023000SELECT DATE_ADD(post_modified_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00000	0.00000	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00001	0.00001	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00005	0.00005	0.00000	0.00000
    end	0.00000	0.00000	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00020500SELECT DATE_ADD(post_date_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00001	0.00001	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00003	0.00003	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00015300SELECT * FROM kol_users WHERE ID = 10 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00000	0.00000	0.00000	0.00000
    statistics	0.00002	0.00002	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00002	0.00002	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00005100SELECT meta_key, meta_value FROM kol_usermeta WHERE user_id = 10

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
• SQL Duration: 2.719542  URL: /tag/saumya-vishwanathan  TIME: Mar 24, 2009 12:15:02 pm
• No of Profiles: 5  View
• • 2.65351700Update kol_posts set post_hits = post_hits + 1 WHERE ID=5194

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	2.65221	2.65221	3.69000	3.69000
    init	0.00015	0.00015	0.00000	0.00000
    Updating	0.00050	0.00050	0.00000	0.00000
    end	0.00056	0.00056	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00002	0.00002	0.00000	0.00000
    closing tables	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.06571200SELECT DATE_ADD(post_modified_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00005	0.00005	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.06544	0.06544	0.04000	0.04000
    init	0.00003	0.00003	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00002	0.00002	0.00000	0.00000
    preparing	0.00002	0.00002	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00006	0.00006	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00022900SELECT DATE_ADD(post_date_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00006	0.00006	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00001	0.00001	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00000	0.00000	0.00000	0.00000
    Sending data	0.00003	0.00003	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004200SELECT * FROM kol_users WHERE ID = 10 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004200SELECT meta_key, meta_value FROM kol_usermeta WHERE user_id = 10

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
• SQL Duration: 4.016413  URL: /tag/mangalam  TIME: Mar 24, 2009 12:15:07 pm
• No of Profiles: 5  View
• • 4.01581700Update kol_posts set post_hits = post_hits + 1 WHERE ID=21968

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	4.01495	4.01495	7.35000	7.35000
    init	0.00009	0.00009	0.00000	0.00000
    Updating	0.00046	0.00046	0.00000	0.00000
    end	0.00025	0.00025	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00031700SELECT DATE_ADD(post_modified_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00007	0.00007	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00002	0.00002	0.00000	0.00000
    preparing	0.00002	0.00002	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00006	0.00006	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00019400SELECT DATE_ADD(post_date_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00001	0.00001	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00000	0.00000	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00003	0.00003	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00000	0.00000	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004100SELECT * FROM kol_users WHERE ID = 10 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004400SELECT meta_key, meta_value FROM kol_usermeta WHERE user_id = 10

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
• SQL Duration: 0.000965  URL: /tag/justice-sr-banoormath  TIME: Mar 24, 2009 12:15:08 pm
• No of Profiles: 5  View
• • 0.00042600Update kol_posts set post_hits = post_hits + 1 WHERE ID=26126

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00001	0.00001	0.00000	0.00000
    init	0.00003	0.00003	0.00000	0.00000
    Updating	0.00025	0.00025	0.00000	0.00000
    end	0.00009	0.00009	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00024600SELECT DATE_ADD(post_modified_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00004	0.00004	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00003	0.00003	0.01000	0.01000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00004	0.00004	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00020200SELECT DATE_ADD(post_date_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00001	0.00001	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00000	0.00000	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00003	0.00003	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004400SELECT * FROM kol_users WHERE ID = 10 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004700SELECT meta_key, meta_value FROM kol_usermeta WHERE user_id = 10

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
• SQL Duration: 1.181864  URL: /category/Women  TIME: Mar 24, 2009 12:15:57 pm
• No of Profiles: 18  View
• • 0.00088800Update kol_posts set post_hits = post_hits + 1 WHERE ID=27503

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00000	0.00000	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00001	0.00001	0.00000	0.00000
    init	0.00003	0.00003	0.00000	0.00000
    Updating	0.00066	0.00066	0.01000	0.01000
    end	0.00011	0.00011	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00003	0.00003	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00033400SELECT DATE_ADD(post_modified_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00004	0.00004	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00000	0.00000	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00001	0.00001	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00005	0.00005	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00011	0.00011	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00019200SELECT DATE_ADD(post_date_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00001	0.00001	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00000	0.00000	0.00000	0.00000
    Sending data	0.00004	0.00004	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00000	0.00000	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004000SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN ('category') ORDER BY t.name ASC

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00856900SELECT SQL_CALC_FOUND_ROWS kol_posts.* FROM kol_posts INNER JOIN kol_term_relationships ON (kol_posts.ID = kol_term_relationships.object_id) INNER JOIN kol_term_taxonomy ON (kol_term_relationships.term_taxonomy_id = kol_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND kol_term_taxonomy.taxonomy = '

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00006	0.00006	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00004	0.00004	0.00000	0.00000
    optimizing	0.00002	0.00002	0.00000	0.00000
    statistics	0.00015	0.00015	0.00000	0.00000
    preparing	0.00002	0.00002	0.00000	0.00000
    Creating tmp table	0.00024	0.00024	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Copying to tmp table	0.00586	0.00586	0.01000	0.01000
    Sorting result	0.00089	0.00089	0.00000	0.00000
    Sending data	0.00076	0.00076	0.00000	0.00000
    end	0.00001	0.00000	0.00000	0.00000
    removing tmp table	0.00042	0.00042	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00006800SELECT FOUND_ROWS()

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    end	0.00000	0.00000	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00002900SELECT * FROM kol_users WHERE ID = 10 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00003900SELECT meta_key, meta_value FROM kol_usermeta WHERE user_id = 10

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 1.09103600SELECT SQL_CALC_FOUND_ROWS kol_posts.* FROM kol_posts INNER JOIN kol_term_relationships ON (kol_posts.ID = kol_term_relationships.object_id) INNER JOIN kol_term_taxonomy ON (kol_term_relationships.term_taxonomy_id = kol_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND kol_term_taxonomy.taxonomy = '

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00005	0.00005	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00003	0.00003	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00014	0.00014	0.00000	0.00000
    preparing	0.00002	0.00002	0.00000	0.00000
    Creating tmp table	0.00021	0.00021	0.00000	0.00000
    executing	0.00000	0.00000	0.00000	0.00000
    Copying to tmp table	1.08782	1.08782	3.35000	3.35000
    Sorting result	0.00119	0.00119	0.00000	0.00000
    Sending data	0.00090	0.00090	0.00000	0.00000
    end	0.00002	0.00001	0.00000	0.00000
    removing tmp table	0.00052	0.00052	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    storing result in query cache	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00002	0.00002	0.00000	0.00000
    closing tables	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00011600SELECT FOUND_ROWS()

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    executing	0.00002	0.00002	0.00000	0.00000
    end	0.00000	0.00000	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00293700SELECT t.*, tt.*, tr.object_id FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (25815, 25135, 25286, 25445, 24137, 2

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00007	0.00007	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00002	0.00002	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00004	0.00004	0.00000	0.00000
    optimizing	0.00002	0.00002	0.00000	0.00000
    statistics	0.00033	0.00033	0.00000	0.00000
    preparing	0.00003	0.00003	0.00000	0.00000
    Creating tmp table	0.00022	0.00022	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Copying to tmp table	0.00168	0.00168	0.01000	0.01000
    Sorting result	0.00015	0.00015	0.00000	0.00000
    Sending data	0.00019	0.00019	0.00000	0.00000
    end	0.00002	0.00001	0.00000	0.00000
    removing tmp table	0.00008	0.00008	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00071000SELECT post_id, meta_key, meta_value FROM kol_postmeta WHERE post_id IN (25815,25135,25286,25445,24137,25138,25092,24143,24138)

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00008	0.00008	0.00000	0.00000
    System lock	0.00000	0.00000	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00024	0.00024	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00000	0.00000	0.00000	0.00000
    Sending data	0.00026	0.00026	0.01000	0.01000
    end	0.00000	0.00000	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.06547800SELECT SQL_CALC_FOUND_ROWS kol_posts.* FROM kol_posts INNER JOIN kol_term_relationships ON (kol_posts.ID = kol_term_relationships.object_id) INNER JOIN kol_term_taxonomy ON (kol_term_relationships.term_taxonomy_id = kol_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND kol_term_taxonomy.taxonomy = '

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00006	0.00006	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00005	0.00005	0.00000	0.00000
    System lock	0.00000	0.00000	0.00000	0.00000
    Table lock	0.00009	0.00009	0.00000	0.00000
    init	0.00004	0.00004	0.00000	0.00000
    optimizing	0.00002	0.00002	0.00000	0.00000
    statistics	0.00023	0.00023	0.00000	0.00000
    preparing	0.00002	0.00002	0.00000	0.00000
    Creating tmp table	0.00025	0.00025	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Copying to tmp table	0.06253	0.06253	0.20000	0.20000
    Sorting result	0.00084	0.00084	0.00000	0.00000
    Sending data	0.00083	0.00083	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    removing tmp table	0.00044	0.00044	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00002	0.00002	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00011500SELECT FOUND_ROWS()

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    executing	0.00002	0.00002	0.00000	0.00000
    end	0.00000	0.00000	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00911700SELECT SQL_CALC_FOUND_ROWS kol_posts.* FROM kol_posts INNER JOIN kol_term_relationships ON (kol_posts.ID = kol_term_relationships.object_id) INNER JOIN kol_term_taxonomy ON (kol_term_relationships.term_taxonomy_id = kol_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND kol_posts.ID NOT IN (27503,252

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00010	0.00010	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00002	0.00002	0.00000	0.00000
    System lock	0.00000	0.00000	0.00000	0.00000
    Table lock	0.00004	0.00004	0.00000	0.00000
    init	0.00005	0.00005	0.00000	0.00000
    optimizing	0.00002	0.00002	0.00000	0.00000
    statistics	0.00024	0.00024	0.00000	0.00000
    preparing	0.00002	0.00002	0.00000	0.00000
    Creating tmp table	0.00026	0.00026	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Copying to tmp table	0.00624	0.00624	0.00000	0.00000
    Sorting result	0.00077	0.00077	0.01000	0.01000
    Sending data	0.00084	0.00084	0.00000	0.00000
    end	0.00002	0.00001	0.00000	0.00000
    removing tmp table	0.00041	0.00041	0.01000	0.01000
    query end	0.00000	0.00000	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00009400SELECT FOUND_ROWS()

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00176200SELECT t.*, tt.*, tr.object_id FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (24145, 24587, 24144, 24142, 24126, 2

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00006	0.00006	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00002	0.00002	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00003	0.00003	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00011	0.00011	0.01000	0.01000
    preparing	0.00002	0.00002	0.00000	0.00000
    Creating tmp table	0.00018	0.00018	0.00000	0.00000
    executing	0.00000	0.00000	0.00000	0.00000
    Copying to tmp table	0.00092	0.00092	0.00000	0.00000
    Sorting result	0.00010	0.00010	0.00000	0.00000
    Sending data	0.00014	0.00014	0.00000	0.00000
    end	0.00002	0.00001	0.00000	0.00000
    removing tmp table	0.00007	0.00007	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00034000SELECT post_id, meta_key, meta_value FROM kol_postmeta WHERE post_id IN (24145,24587,24144,24142,24126,22432)

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00007	0.00007	0.00000	0.00000
    preparing	0.00000	0.00000	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00014	0.00014	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    storing result in query cache	0.00002	0.00002	0.00000	0.00000
    freeing items	0.00000	0.00000	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
• SQL Duration: 255.217835  URL: /tag/3-killed-in-kayamkulam  TIME: Mar 24, 2009 12:23:32 pm
• No of Profiles: 6  View
• • 255.21753100Update kol_posts set post_hits = post_hits + 1 WHERE ID=27184

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00020	0.00020	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	251.73050	251.73050	82.60000	82.60000
    init	0.00008	0.00008	0.00000	0.00000
    Updating	0.00025	0.00025	0.00000	0.00000
    end	0.00004	0.00004	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00002	0.00002	0.00000	0.00000
    closing tables	3.48638	3.48638	1.34000	1.34000
    logging slow query	0.00002	0.00002	0.00000	0.00000

  
  
  
  • 0.00006000SELECT DATE_ADD(post_modified_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00005100SELECT DATE_ADD(post_date_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00006200SELECT * FROM kol_users WHERE ID = 10 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00005600SELECT meta_key, meta_value FROM kol_usermeta WHERE user_id = 10

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00007500SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'category' AND t.term_id = '46' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
• SQL Duration: 415.920646  URL: /tag/3-killed-in-kayamkulam  TIME: Mar 24, 2009 12:23:32 pm
• No of Profiles: 6  View
• • 414.17083800Update kol_posts set post_hits = post_hits + 1 WHERE ID=27184

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.35953	0.35953	0.14000	0.14000
    System lock	0.00002	0.00002	0.00000	0.00000
    Table lock	412.07218	412.07218	182.16000	182.16000
    init	0.00006	0.00006	0.00000	0.00000
    Updating	0.06488	0.06488	0.00000	0.00000
    end	0.00006	0.00006	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00002	0.00002	0.00000	0.00000
    closing tables	1.67405	1.67405	0.08000	0.08000
    logging slow query	0.00002	0.00002	0.00000	0.00000

  
  
  
  • 1.74932800SELECT DATE_ADD(post_modified_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00008	0.00008	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.56020	0.56020	0.37000	0.37000
    System lock	0.00002	0.00002	0.00000	0.00000
    Table lock	0.00004	0.00004	0.00000	0.00000
    init	0.00005	0.00005	0.01000	0.01000
    optimizing	0.00002	0.00002	0.00000	0.00000
    statistics	0.00003	0.00003	0.00000	0.00000
    preparing	0.00003	0.00003	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00012	0.00012	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	1.18865	1.18865	0.69000	0.69000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00030000SELECT DATE_ADD(post_date_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00007	0.00007	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00001	0.00001	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00004	0.00004	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00005800SELECT * FROM kol_users WHERE ID = 10 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00005600SELECT meta_key, meta_value FROM kol_usermeta WHERE user_id = 10

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00006600SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'category' AND t.term_id = '46' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
• SQL Duration: 0.000104  URL: /?s=sreekumaran-thampis  TIME: Mar 24, 2009 12:23:44 pm
• No of Profiles: 2  View
• • 0.00005500SELECT DATE_ADD(post_modified_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004900SELECT DATE_ADD(post_date_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
• SQL Duration: 8.512946  URL: /women/initiate-sex-man_21499.html  TIME: Mar 24, 2009 12:16:04 pm
• No of Profiles: 32  View
• • 1.71693000Update kol_posts set post_hits = post_hits + 1 WHERE ID=21499

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	1.71632	1.71632	2.15000	2.15000
    init	0.00003	0.00003	0.00000	0.00000
    Updating	0.00050	0.00050	0.01000	0.01000
    end	0.00002	0.00002	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004500SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'category' AND t.slug = 'women' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004500SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'category' AND t.slug = 'women' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004300SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'category' AND t.slug = 'women' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.33800400SELECT DATE_ADD(post_modified_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.33782	0.33782	0.25000	0.25000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00001	0.00001	0.00000	0.00000
    preparing	0.00000	0.00000	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00004	0.00004	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004400SELECT DATE_ADD(post_date_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004300SELECT * FROM kol_users WHERE ID = 10 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004600SELECT meta_key, meta_value FROM kol_usermeta WHERE user_id = 10

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004200SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'category' AND t.slug = 'women' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004400SELECT option_value FROM kol_options WHERE option_name = 'yarpp_auto_display' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00046300SELECT * FROM kol_comments WHERE comment_post_ID = 21499 AND comment_approved = '1' ORDER BY comment_date

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00005	0.00005	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00003	0.00003	0.00000	0.00000
    optimizing	0.00002	0.00002	0.00000	0.00000
    statistics	0.00013	0.00013	0.00000	0.00000
    preparing	0.00002	0.00002	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00006	0.00006	0.00000	0.00000
    Sending data	0.00004	0.00004	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00022400SELECT UNIX_TIMESTAMP(comment_date) time, comment_author_email, comment_author_IP, comment_date_gmt, comment_post_ID, comment_ID, user_id FROM kol_comments where comment_ID = 7779

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00004	0.00004	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00003	0.00003	0.00000	0.00000
    preparing	0.00000	0.00000	0.00000	0.00000
    executing	0.00000	0.00000	0.00000	0.00000
    Sending data	0.00003	0.00003	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00000	0.00000	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00055500SELECT meta_value FROM kol_postmeta WHERE post_id = 21499 and meta_key = '_7779'

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00029	0.00029	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00010	0.00010	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00002	0.00002	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004100SELECT UNIX_TIMESTAMP(comment_date) time, comment_author_email, comment_author_IP, comment_date_gmt, comment_post_ID, comment_ID, user_id FROM kol_comments where comment_ID = 7779

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004100SELECT meta_value FROM kol_postmeta WHERE post_id = 21499 and meta_key = '_7779'

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00020400SELECT UNIX_TIMESTAMP(comment_date) time, comment_author_email, comment_author_IP, comment_date_gmt, comment_post_ID, comment_ID, user_id FROM kol_comments where comment_ID = 7784

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00002	0.00002	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00000	0.00000	0.00000	0.00000
    Sending data	0.00002	0.00002	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00154100SELECT meta_value FROM kol_postmeta WHERE post_id = 21499 and meta_key = '_7784'

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00028	0.00028	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00000	0.00000	0.00000	0.00000
    Sending data	0.00010	0.00010	0.00000	0.00000
    end	0.00000	0.00000	0.00000	0.00000
    query end	0.00103	0.00103	0.00000	0.00000
    storing result in query cache	0.00002	0.00002	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004100SELECT UNIX_TIMESTAMP(comment_date) time, comment_author_email, comment_author_IP, comment_date_gmt, comment_post_ID, comment_ID, user_id FROM kol_comments where comment_ID = 7784

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00003900SELECT meta_value FROM kol_postmeta WHERE post_id = 21499 and meta_key = '_7784'

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.17680900DESC kol_comments

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00033	0.00016	0.00000	0.00000
    Opening tables	0.17620	0.08810	0.16000	0.08000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00001	0.00001	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00001	0.00001	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00010	0.00010	0.00000	0.00000
    end	0.00000	0.00000	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    removing tmp table	0.00007	0.00007	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004300SELECT option_value FROM kol_options WHERE option_name = 'yarpp_show_excerpt' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004500SELECT option_value FROM kol_options WHERE option_name = 'yarpp_show_pass_post' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00004000SELECT option_value FROM kol_options WHERE option_name = 'yarpp_past_only' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004000SELECT option_value FROM kol_options WHERE option_name = 'yarpp_cross_relate' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00000	0.00000	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 6.27691800SELECT *, (bodyscore * 0 + titlescore * 1 + tagscore * 1 + catscore * 0) AS score from ( select ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('him his tell bed sex massage confident home give yourself sexy won`t turn buy initiate light candles whisper favourite working')

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking query cache for query	0.00013	0.00013	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00002	0.00002	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00023	0.00023	0.00000	0.00000
    optimizing	0.00011	0.00002	0.00000	0.00000
    statistics	0.00042	0.00007	0.00000	0.00000
    preparing	0.00010	0.00002	0.00000	0.00000
    executing	0.88393	0.00001	2.41000	0.00002
    Sorting result	0.33434	0.11145	0.65000	0.21667
    Sending data	4.29593	0.00003	11.30000	0.00009
    FULLTEXT initialization	0.00411	0.00411	0.02000	0.02000
    init	0.00004	0.00004	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00004	0.00004	0.00000	0.00000
    closing tables	0.00003	0.00001	0.00000	0.00000
    removing tmp table	0.75743	0.25248	1.81000	0.60333
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00029600SELECT * FROM kol_posts WHERE ID = 21906 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00005	0.00005	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00003	0.00003	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00004	0.00004	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00000	0.00000	0.00000	0.00000
    Sending data	0.00004	0.00004	0.00000	0.00000
    end	0.00000	0.00000	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004400SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (21906) ORDER BY t.name ASC

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004400SELECT option_value FROM kol_options WHERE option_name = 'yarpp_promote_yarpp' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00007000SELECT SQL_CALC_FOUND_ROWS kol_posts.* FROM kol_posts INNER JOIN kol_term_relationships ON (kol_posts.ID = kol_term_relationships.object_id) INNER JOIN kol_term_taxonomy ON (kol_term_relationships.term_taxonomy_id = kol_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND kol_term_taxonomy.taxonomy = '

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00003	0.00003	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00008700SELECT FOUND_ROWS()

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00000	0.00000	0.00000	0.00000
    executing	0.00002	0.00002	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00003500SELECT t.*, tt.*, tr.object_id FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (27503, 25290, 25832, 25238, 26311) O

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004000SELECT post_id, meta_key, meta_value FROM kol_postmeta WHERE post_id IN (27503,25290,25832,25238,26311)

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
• SQL Duration: 13.704555  URL: /news/35-people-hurt-bus-accident_12066.html  TIME: Mar 24, 2009 12:14:59 pm
• No of Profiles: 42  View
• • 0.00980400Update kol_posts set post_hits = post_hits + 1 WHERE ID=12066

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00953	0.00953	0.01000	0.01000
    init	0.00003	0.00003	0.00000	0.00000
    Updating	0.00018	0.00018	0.00000	0.00000
    end	0.00002	0.00002	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00019600SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'category' AND t.slug = 'news' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00000	0.00000	0.00000	0.00000
    Table lock	0.00001	0.00001	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00006	0.00006	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00000	0.00000	0.00000	0.00000
    Sending data	0.00002	0.00002	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004200SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'category' AND t.slug = 'news' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004200SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'category' AND t.slug = 'news' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.01171100SELECT DATE_ADD(post_modified_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_modified_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.01143	0.01143	0.02000	0.02000
    init	0.00005	0.00005	0.00000	0.00000
    optimizing	0.00002	0.00002	0.00000	0.00000
    statistics	0.00002	0.00002	0.00000	0.00000
    preparing	0.00002	0.00002	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00006	0.00006	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00021900SELECT DATE_ADD(post_date_gmt, INTERVAL '19800' SECOND) FROM kol_posts WHERE post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00004	0.00004	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00001	0.00001	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sorting result	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00004	0.00004	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00015500SELECT * FROM kol_users WHERE ID = 10 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00000	0.00000	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00001	0.00001	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00002	0.00002	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00002	0.00002	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00031900SELECT meta_key, meta_value FROM kol_usermeta WHERE user_id = 10

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00003	0.00003	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00000	0.00000	0.00000	0.00000
    Sending data	0.00010	0.00010	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00005200SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy = 'category' AND t.slug = 'news' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004200SELECT option_value FROM kol_options WHERE option_name = 'yarpp_auto_display' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00000	0.00000	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00004400SELECT * FROM kol_comments WHERE comment_post_ID = 12066 AND comment_approved = '1' ORDER BY comment_date

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00093700DESC kol_comments

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00036	0.00018	0.00000	0.00000
    Opening tables	0.00022	0.00011	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00001	0.00001	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00001	0.00001	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00012	0.00012	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00002	0.00001	0.00000	0.00000
    removing tmp table	0.00011	0.00011	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004400SELECT option_value FROM kol_options WHERE option_name = 'yarpp_show_excerpt' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004200SELECT option_value FROM kol_options WHERE option_name = 'yarpp_show_pass_post' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004300SELECT option_value FROM kol_options WHERE option_name = 'yarpp_past_only' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00004700SELECT option_value FROM kol_options WHERE option_name = 'yarpp_cross_relate' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 13.41948200SELECT *, (bodyscore * 0 + titlescore * 1 + tagscore * 1 + catscore * 0) AS score from ( select ID, post_title, post_date, post_content, (MATCH (post_content) AGAINST ('against bus wall near said kuthuparamba injured police vehicle rammed slope negotiating crowded lost deshabandhu reading hospita

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00017	0.00017	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00002	0.00002	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00033	0.00033	0.00000	0.00000
    optimizing	0.00012	0.00002	0.00000	0.00000
    statistics	0.00049	0.00008	0.00000	0.00000
    preparing	0.00010	0.00002	0.00000	0.00000
    executing	0.47610	0.00000	1.74000	0.00001
    Sorting result	0.00956	0.00319	0.00000	0.00000
    Sending data	12.92574	0.00010	37.11000	0.00028
    FULLTEXT initialization	0.00172	0.00172	0.00000	0.00000
    init	0.00004	0.00004	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00005	0.00005	0.00000	0.00000
    closing tables	0.00004	0.00001	0.00000	0.00000
    removing tmp table	0.00489	0.00163	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.02723400SELECT * FROM kol_posts WHERE ID = 25700 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00005	0.00005	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.01975	0.01975	0.00000	0.00000
    init	0.00004	0.00004	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00724	0.00724	0.01000	0.01000
    preparing	0.00002	0.00002	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00004	0.00004	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00097700SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (25700) ORDER BY t.name ASC

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00005	0.00005	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00090	0.00090	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00062300SELECT * FROM kol_posts WHERE ID = 25384 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00003	0.00003	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00044	0.00044	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00049600SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (25384) ORDER BY t.name ASC

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00045	0.00045	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00058600SELECT * FROM kol_posts WHERE ID = 25149 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00002	0.00002	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00000	0.00000	0.00000	0.00000
    Sending data	0.00042	0.00042	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00054100SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (25149) ORDER BY t.name ASC

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00005	0.00005	0.00000	0.00000
    checking privileges on cached	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    sending cached result to clien	0.00047	0.00047	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00058500SELECT * FROM kol_posts WHERE ID = 25082 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00003	0.00003	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00042	0.00042	0.00000	0.00000
    end	0.00000	0.00000	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00051900SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (25082) ORDER BY t.name ASC

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00004	0.00004	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00045	0.00045	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00059000SELECT * FROM kol_posts WHERE ID = 24799 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00002	0.00002	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00042	0.00042	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00054700SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (24799) ORDER BY t.name ASC

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking query cache for query	0.00004	0.00004	0.00000	0.00000
    checking privileges on cached	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00049	0.00049	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.02910900SELECT * FROM kol_posts WHERE ID = 24011 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00002	0.00002	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00050	0.00050	0.00000	0.00000
    end	0.00013	0.00013	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00000	0.00000	0.00000	0.00000
    freeing items	0.02832	0.02832	0.07000	0.07000
    closing tables	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00087900SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (24011) ORDER BY t.name ASC

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00005	0.00005	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00079	0.00079	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00075800SELECT * FROM kol_posts WHERE ID = 23915 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00004	0.00004	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00000	0.00000	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00003	0.00003	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00003	0.00003	0.00000	0.00000
    preparing	0.00002	0.00002	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00048	0.00048	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    storing result in query cache	0.00003	0.00003	0.01000	0.01000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00058000SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (23915) ORDER BY t.name ASC

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking query cache for query	0.00004	0.00004	0.00000	0.00000
    checking privileges on cached	0.00004	0.00004	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    sending cached result to clien	0.00048	0.00048	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.01781300SELECT * FROM kol_posts WHERE ID = 23628 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00002	0.00002	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00002	0.00002	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.01762	0.01762	0.04000	0.04000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00002	0.00002	0.00000	0.00000
    closing tables	0.00002	0.00002	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00100100SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (23628) ORDER BY t.name ASC

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00006	0.00006	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00091	0.00091	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00081900SELECT * FROM kol_posts WHERE ID = 23333 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00005	0.00005	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00003	0.00003	0.00000	0.00000
    optimizing	0.00002	0.00002	0.00000	0.00000
    statistics	0.00005	0.00005	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00055	0.00055	0.00000	0.00000
    end	0.00000	0.00000	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00058300SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (23333) ORDER BY t.name ASC

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00006	0.00006	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00050	0.00050	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00065100SELECT * FROM kol_posts WHERE ID = 23064 LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00000	0.00000	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00003	0.00003	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00045	0.00045	0.00000	0.00000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00001	0.00001	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00054000SELECT t.*, tt.* FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category') AND tr.object_id IN (23064) ORDER BY t.name ASC

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00005	0.00005	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00046	0.00046	0.00000	0.00000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00073200SELECT option_value FROM kol_options WHERE option_name = 'yarpp_promote_yarpp' LIMIT 1

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00001	0.00001	0.00000	0.00000
    checking privileges on cached	0.00001	0.00001	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    sending cached result to clien	0.00070	0.00070	0.01000	0.01000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.16783300SELECT SQL_CALC_FOUND_ROWS kol_posts.* FROM kol_posts INNER JOIN kol_term_relationships ON (kol_posts.ID = kol_term_relationships.object_id) INNER JOIN kol_term_taxonomy ON (kol_term_relationships.term_taxonomy_id = kol_term_taxonomy.term_taxonomy_id) WHERE 1=1 AND kol_term_taxonomy.taxonomy = '

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00008	0.00008	0.00000	0.00000
    checking permissions	0.00001	0.00001	0.00000	0.00000
    Opening tables	0.00002	0.00002	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00004	0.00004	0.00000	0.00000
    init	0.00004	0.00004	0.00000	0.00000
    optimizing	0.00002	0.00002	0.00000	0.00000
    statistics	0.00017	0.00017	0.00000	0.00000
    preparing	0.00002	0.00002	0.00000	0.00000
    Creating tmp table	0.00029	0.00029	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Copying to tmp table	0.11278	0.11278	0.28000	0.28000
    Sorting result	0.00621	0.00621	0.02000	0.02000
    Sending data	0.04385	0.04385	0.16000	0.16000
    end	0.00001	0.00001	0.00000	0.00000
    removing tmp table	0.00423	0.00423	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00002	0.00002	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00053900SELECT FOUND_ROWS()

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00000	0.00000	0.00000	0.00000
    checking query cache for query	0.00003	0.00003	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    init	0.00001	0.00001	0.00000	0.00000
    optimizing	0.00000	0.00000	0.00000	0.00000
    executing	0.00044	0.00044	0.01000	0.01000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    freeing items	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000

  
  
  
  • 0.00109500SELECT t.*, tt.*, tr.object_id FROM kol_terms AS t INNER JOIN kol_term_taxonomy AS tt ON tt.term_id = t.term_id INNER JOIN kol_term_relationships AS tr ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy IN ('category', 'post_tag') AND tr.object_id IN (27514, 27431, 27420, 27415, 27408) O

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00002	0.00002	0.00000	0.00000
    checking privileges on cached	0.00000	0.00000	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    sending cached result to clien	0.00106	0.00106	0.01000	0.01000
    logging slow query	0.00001	0.00001	0.00000	0.00000

  
  
  
  • 0.00570400SELECT post_id, meta_key, meta_value FROM kol_postmeta WHERE post_id IN (27514,27431,27420,27415,27408)

  • state	sum_dur	avg_dur	sum_cpu	avg_cpu
    (initialization)	0.00001	0.00001	0.00000	0.00000
    checking query cache for query	0.00004	0.00004	0.00000	0.00000
    checking permissions	0.00000	0.00000	0.00000	0.00000
    Opening tables	0.00001	0.00001	0.00000	0.00000
    System lock	0.00001	0.00001	0.00000	0.00000
    Table lock	0.00003	0.00003	0.00000	0.00000
    init	0.00002	0.00002	0.00000	0.00000
    optimizing	0.00001	0.00001	0.00000	0.00000
    statistics	0.00009	0.00009	0.00000	0.00000
    preparing	0.00001	0.00001	0.00000	0.00000
    executing	0.00001	0.00001	0.00000	0.00000
    Sending data	0.00543	0.00543	0.01000	0.01000
    end	0.00001	0.00001	0.00000	0.00000
    query end	0.00000	0.00000	0.00000	0.00000
    storing result in query cache	0.00001	0.00001	0.00000	0.00000
    freeing items	0.00000	0.00000	0.00000	0.00000
    closing tables	0.00001	0.00001	0.00000	0.00000
    logging slow query	0.00000	0.00000	0.00000	0.00000