blogwire

Here’s a screenshot of p3plugin profiler. cpd is using 58%. Is this normal?
https://www.blogwire.ca/temp/cpd.jpg

Count per Day - DEBUG: 0.328 s 1.Server: Apache
PHP: 5.4.29
mySQL Server: 5.5.37-35.1
mySQL Client: 5.5.37-35.1
WordPress: 3.9.1
Count per Day: 3.2.10
Time for Count per Day: 2014-07-03 07:04
URL: www.blogwire.ca/wp-admin/index.php?page=cpd_metaboxes
Referrer: https://www.blogwire.ca/wp-admin/options-general.php?page=count-per-day/counter-options.php
PHP-Memory: peak: 31.04 MB, limit: 256M
2.POST:
 array(0) { }
3.SESSION:
 array(1) { ["cpd_wp"]=> string(28) "/home3/bloglink/public_html/" }
4.Table:
bl_cpd_counter: id = int(10)   ip = int(10) unsigned   client = varchar(150)   date = date   page = mediumint(9)   country = char(2)   referer = varchar(100)
5.Options:
 version = 3.2.10
 onlinetime = 300
 user = 0
 user_level = 0
 autocount = 1
 dashboard_posts = 5
 dashboard_last_posts = 5
 dashboard_last_days = 7
 show_in_lists = 0
 chart_days = 30
 chart_height = 200
 countries = 25
 startdate =
 startcount =
 startreads =
 anoip = 0
 massbotlimit = 25
 clients = Firefox, MSIE, Chrome, Safari, Opera
 ajax = 1
 debug = 1
 referers = 0
 referers_cut = 0
 localref = 0
 dashboard_referers = 10
 referers_last_days = 7
 no_front_css = 1
 whocansee = publish_posts
 backup_part = 10000
 chart_old = 0

6.ChartReads 274 : 0.01206 - 27.41 MB
 SELECT COUNT(*) count, c.date FROM bl_cpd_counter c WHERE c.date BETWEEN '2014-06-04' AND '2014-07-03' GROUP BY c.date

7.ChartVisitors 289 : 0.01147 - 27.43 MB
 SELECT COUNT(*) count, t.date FROM ( SELECT COUNT(*) count, date FROM bl_cpd_counter GROUP BY date, ip ) AS t WHERE t.date BETWEEN '2014-06-04' AND '2014-07-03' GROUP BY t.date

8.getReadsAll 474 : 0.00028 - 27.38 MB
SELECT COUNT(*) FROM bl_cpd_counter

9.getReadsToday 497 : 0.00027 - 27.38 MB
SELECT COUNT(*) FROM bl_cpd_counter WHERE date = '2014-07-03'

10.getReadsYesterday 517 : 0.00019 - 27.38 MB
SELECT COUNT(*) FROM bl_cpd_counter WHERE date = DATE_SUB('2014-07-03', INTERVAL 1 DAY)

11.getReadsLastWeek 537 : 0.00066 - 27.38 MB
SELECT COUNT(*) FROM bl_cpd_counter WHERE date >= DATE_SUB('2014-07-03', INTERVAL 7 DAY)

12.getReadsThisMonth 559 : 0.00013 - 27.38 MB
SELECT COUNT(*) FROM bl_cpd_counter WHERE date >= '2014-07-01';

13.getUserAll 463 : 0.01492 - 27.39 MB
SELECT 1 FROM bl_cpd_counter GROUP BY date, ip

14.getUserToday 486 : 0.00039 - 27.39 MB
SELECT 1 FROM bl_cpd_counter WHERE date = '2014-07-03' GROUP BY ip

15.getUserYesterday 507 : 0.00020 - 27.39 MB
SELECT 1 FROM bl_cpd_counter WHERE date = DATE_SUB('2014-07-03', INTERVAL 1 DAY) GROUP BY ip

16.getUserLastWeek 527 : 0.00078 - 27.39 MB
SELECT 1 FROM bl_cpd_counter WHERE date >= DATE_SUB('2014-07-03', INTERVAL 7 DAY) GROUP BY date, ip;

17.getUserThisMonth 548 : 0.00020 - 27.39 MB
SELECT 1 FROM bl_cpd_counter WHERE date >= '2014-07-01' GROUP BY date, ip;

18.getUserPerDay 685 : 0.00177 - 27.39 MB
SELECT 1 FROM bl_cpd_counter WHERE date > '2014-06-25' AND date < '2014-07-03' GROUP BY ip, date

19.getDayWithMostReads 969 : 0.01090 - 27.39 MB
 SELECT date, COUNT(id) count FROM bl_cpd_counter GROUP BY date ORDER BY count DESC LIMIT 1

20.getDayWithMostVisitors 993 : 0.02385 - 27.39 MB
 SELECT t.date, count(*) count FROM ( SELECT count(*) count, date, page FROM bl_cpd_counter GROUP BY date, ip ) AS t GROUP BY t.date ORDER BY count DESC LIMIT 1

21.getUserPerMonths 569 : 0.02199 - 27.39 MB
SELECT LEFT(date,7) month FROM bl_cpd_counter GROUP BY year(date), month(date) ORDER BY date DESC

22.getUserPerMonth 577 : 0.01558 - 27.39 MB
SELECT 1 FROM bl_cpd_counter WHERE LEFT(date,7) = '2014-07' GROUP BY date, ip

23.getUserPerMonth 577 : 0.01810 - 27.40 MB
SELECT 1 FROM bl_cpd_counter WHERE LEFT(date,7) = '2014-06' GROUP BY date, ip

24.getCountries 1233 : 0.03252 - 27.45 MB
SELECT country, COUNT(*) c FROM bl_cpd_counter WHERE ip > 0 GROUP BY country ORDER BY c DESC

25.getCountries 1233 : 0.03370 - 27.45 MB
SELECT country, COUNT(*) c FROM ( SELECT country, COUNT(*) c FROM bl_cpd_counter WHERE ip > 0 GROUP BY country, date, ip ) as t GROUP BY country ORDER BY c desc

26.getReadsPerMonths 605 : 0.02398 - 27.40 MB
SELECT COUNT(*) count, LEFT(date,7) month FROM bl_cpd_counter GROUP BY year(date), month(date) ORDER BY date DESC

27.getUserPerPost 6491011 : 0.04171 - 29.73 MB
 SELECT COUNT(*) count, page FROM bl_cpd_counter WHERE page GROUP BY page

28.getUserPerPost 649 1071 : 0.01175 - 29.74 MB
 SELECT temp_outer.* FROM ( SELECT CASE p.id WHEN 999 THEN 231 WHEN 52 THEN 81 WHEN 17082 THEN 80 WHEN -2288 THEN 69 WHEN -30 THEN 69 ELSE 0 END count, p.id post_id, p.post_title post, '' tag_cat_name, '' tag_cat_slug, '' tax FROM bl_posts p WHERE p.id IN (999,52,17082,-2288,-30) GROUP BY p.id UNION SELECT CASE -t.term_id WHEN 999 THEN 231 WHEN 52 THEN 81 WHEN 17082 THEN 80 WHEN -2288 THEN 69 WHEN -30 THEN 69 ELSE 0 END count, t.term_id post_id, '' post, t.name tag_cat_name, t.slug tag_cat_slug, x.taxonomy tax FROM bl_terms t LEFT JOIN bl_term_taxonomy x ON x.term_id = t.term_id WHERE -t.term_id IN (999,52,17082,-2288,-30) GROUP BY t.term_id ) temp_outer ORDER BY count DESC

29.getMostVisitedPosts1011 : 0.04909 - 27.53 MB
 SELECT COUNT(c.id) count, c.page post_id, p.post_title post, t.name tag_cat_name, t.slug tag_cat_slug, x.taxonomy tax FROM bl_cpd_counter c LEFT JOIN bl_posts p ON p.id = c.page LEFT JOIN bl_terms t ON t.term_id = 0 - c.page LEFT JOIN bl_term_taxonomy x ON x.term_id = t.term_id WHERE c.date >= '2014-06-26' GROUP BY c.page ORDER BY count DESC LIMIT 5

30.getVisitedPostsOnDay1011 : 0.00107 - 27.52 MB
 SELECT COUNT(c.id) count, c.page post_id, p.post_title post, t.name tag_cat_name, t.slug tag_cat_slug, x.taxonomy tax FROM bl_cpd_counter c LEFT JOIN bl_posts p ON p.id = c.page LEFT JOIN bl_terms t ON t.term_id = 0 - c.page LEFT JOIN bl_term_taxonomy x ON x.term_id = t.term_id WHERE c.date = '2014-07-03' GROUP BY c.page ORDER BY count DESC LIMIT 100

31.showFields : 0.00264 - 27.54 MB
SHOW FIELDS FROM <code>bl_cpd_counter</code>

GeoIP: d_ir=755 f_ile=644 f_open=true g_zopen=true a_llow_url_fopen=true

[Moderator Note: Please post log files between backticks or use the code button.]

I find this plugin excellent but a huge resource drain. With p3tools it is 56% just for CpD…Any suggestions to reduce server load?
Thanks