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: http://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.]
