Current Affairs Links

July 2008
Sun	Mon	Tue	Wed	Thu	Fri	Sat
<< <		> >>
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

Debug info

Timers
Category	Time	%	Count
total	1.041	100.00%	1
skin/_main.inc	0.914	87.80%	1
categories_plugin_(#7)	0.515	49.47%	1
sql_queries	0.353	33.91%	32
main.inc	0.110	10.57%	1
plugins_register	0.015	1.44%	6
calendar_plugin_(#5)	0.013	1.25%	1
_blog_main.inc	0.010	0.96%	1
captcha_img_plugin_(#9)	0.007	0.67%	2
archives_plugin_(#6)	0.007	0.67%	1
abstractsettings_GeneralSettings_get	0.005	0.48%	130
+ 6 < 0.005s

Database queries: 32.
Memory usage: 13.47 MB
Memory peak usage: 13.51 MB

Debug messages

note:

Loading Item(papers_please) into cache
Retrieving Item(papers_please) from cache

captcha_img_plugin_9:

Plugin has deprecated AppendPluginRegister method. Use PluginInit instead.
Found font file (/home/grahamsh/public_html/b2evo/plugins/fonts/hockey.ttf)
Checking given TrueType-Array: (1)
Valid TrueType-files: (1)
Private key is: (FT6@%L)
Public key is: (DB ID 6a66aea88ae188e7132599f6a692b800)

captcha_img_plugin_?:

T_() method called through plugin constructor!
T_() method called through plugin constructor!

dataobjects:

Loading Blog(currentlinks) into cache
Loading User(1) into cache

deprecated:

Plugin has deprecated AppendPluginRegister method. Use PluginInit instead.

detectblog:

No blog param received, checking extra path...
Found a potential URL blog name: currentlinks

hit:

IP: 38.103.63.18
UserAgent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Referer: false; type=direct
Remote Host:
log(): Recording the hit.

locale:

default_locale from conf: en-US
default_locale from DB: en-US
default_locale from HTTP_ACCEPT: en-US
$evo_charset follows $io_charset (iso-8859-1).
Set DB connection charset: latin1
evo_charset: iso-8859-1
io_charset: iso-8859-1
Activating blog locale: en-US

login:

login: NULL
pass: empty

memory:

Len of serialized $cache_imgsize: 2
Len of serialized $cache_File: 2

params:

param(-): tempskin as string
init $global_param_list
memorize_param: tempskin string default=
param(-): cookieb2evosession as string
memorize_param: locale string default=
param(-): login_action typed to array, new value=Array
param(-): blog set to NULL
memorize_param: blog integer default=
param(-): blog typed to integer, new value=4
memorize_param: blog integer default=0
param(-): p set to NULL
memorize_param: p integer default=
param(-): title as string
memorize_param: title string default=
param(-): m set to NULL
memorize_param: m integer default=
param(-): w typed to integer, new value=-1
memorize_param: w integer default=-1
param(-): dstart set to NULL
memorize_param: dstart integer default=
param(-): unit as string
memorize_param: unit string default=
param(-): cat matched against /^[*\-]?([0-9]+(,[0-9]+)*)?$/
memorize_param: cat string default=
param(-): catsel typed to array, new value=Array
memorize_param: catsel array default=Array
param(-): author is empty: ok
memorize_param: author string default=
param(-): order as string
memorize_param: order string default=DESC
param(-): orderby as string
memorize_param: orderby string default=
param(-): posts typed to integer, new value=0
memorize_param: posts integer default=0
param(-): paged set to NULL
memorize_param: paged integer default=
param(-): poststart set to NULL
memorize_param: poststart integer default=
param(-): postend set to NULL
memorize_param: postend integer default=
param(-): s as string
memorize_param: s string default=
param(-): sentence as string
memorize_param: sentence string default=AND
param(-): exact set to NULL
memorize_param: exact integer default=
param(-): preview typed to integer, new value=0
memorize_param: preview integer default=0
param(-): calendar as string
memorize_param: calendar string default=
param(-): page set to NULL
memorize_param: page integer default=
param(-): more typed to integer, new value=0
memorize_param: more integer default=0
param(-): c as string
memorize_param: c string default=
param(-): tb typed to integer, new value=0
memorize_param: tb integer default=0
param(-): pb typed to integer, new value=0
memorize_param: pb integer default=0
param(-): disp as string
memorize_param: disp string default=posts
param(-): stats typed to integer, new value=0
param(-): tempskin as string
memorize_param: tempskin string default=
blog_baseuri: "/b2evo///"
Extra path info found! path_string=index.php/currentlinks/2008/02/28/papers_please
Ignoring *.php in extra path info
Ignoring stub file in extra path info
Setting year from extra path info. $m=2008
Setting month from extra path info. $m=200802
Setting day from extra path info. $m=20080228
param(-): results_page typed to integer, new value=1
memorize_param: results_page integer default=1
memorize_param: results_order string default=
param(-): template as string
memorize_param: template string default=main
regenerate_url(): Using full URL because of $base_tag_set.
param(-): results_page typed to integer, new value=1
memorize_param: results_page integer default=1
memorize_param: results_order string default=
param(-): results_archivelist_page typed to integer, new value=1
memorize_param: results_archivelist_page integer default=1
param(-): results_archivelist_order as string
memorize_param: results_archivelist_order string default=
regenerate_url(): Using full URL because of $base_tag_set.
regenerate_url(): Using full URL because of $base_tag_set.

plugins:

Loading plugin events.
Trigger event SessionLoaded
No registered plugins.
Trigger event CachePageContent (first true)
No registered plugins.
Trigger event CacheObjects (first true)
No registered plugins.
Trigger event CacheObjects (first true)
No registered plugins.
Trigger event CacheObjects (first true)
No registered plugins.
Trigger event CacheObjects (first true)
No registered plugins.
Trigger event CacheObjects (first true)
No registered plugins.
Trigger event CacheObjects (first true)
No registered plugins.
Trigger event CacheObjects (first true)
No registered plugins.
Trigger event CacheObjects (first true)
No registered plugins.
Trigger event CacheObjects (first true)
No registered plugins.
Trigger event CacheObjects (first true)
No registered plugins.
Trigger event AlternateAuthentication (first true)
No registered plugins.
Trigger event AfterLoginAnonymousUser
No registered plugins.
Trigger event BeforeBlogDisplay
Registered plugin IDs: 11
get_by_ID(): Instantiate Plugin (ID 11).
Loading plugins table data.
register(): gallery_plugin, ID: 11, priority: 60, classfile_path: [/home/grahamsh/public_html/b2evo/plugins/gallery_plugin/_gallery.plugin.php]
Loading plugin class file: gallery_plugin
Calling gallery_plugin(#11)->BeforeBlogDisplay( )
Trigger event GetProvidedSkins (first return)
No registered plugins.
Trigger event SkinBeginHtmlHead
Registered plugin IDs: 11
Calling gallery_plugin(#11)->SkinBeginHtmlHead( )
Trigger event ItemViewsIncreased
No registered plugins.
Trigger event ItemCanComment (first return)
Registered plugin IDs: 8
get_by_ID(): Instantiate Plugin (ID 8).
register(): basic_antispam_plugin, ID: 8, priority: 60, classfile_path: [/home/grahamsh/public_html/b2evo/plugins/basic_antispam_plugin/_basic_antispam.plugin.php]
Loading plugin class file: basic_antispam_plugin
Calling basic_antispam_plugin(#8)->ItemCanComment( )
Calling basic_antispam_plugin(#8)->GetDefaultSettings( )
Trigger event ItemCanComment (first return)
Registered plugin IDs: 8
Calling basic_antispam_plugin(#8)->ItemCanComment( )
Trigger event DisplayCommentToolbar
No registered plugins.
Trigger event DisplayCommentFormFieldset
Registered plugin IDs: 9
get_by_ID(): Instantiate Plugin (ID 9).
register(): captcha_img_plugin, ID: 9, priority: 50, classfile_path: [/home/grahamsh/public_html/b2evo/plugins/_captcha_img.plugin.php]
Loading plugin class file: captcha_img_plugin
Calling captcha_img_plugin(#9)->DisplayCommentFormFieldset( )
Calling captcha_img_plugin(#9)->GetDefaultSettings( )
Trigger event DisplayCommentFormButton
No registered plugins.
get_by_ID(): Instantiate Plugin (ID 5).
register(): calendar_plugin, ID: 5, priority: 20, classfile_path: [/home/grahamsh/public_html/b2evo/plugins/_calendar.plugin.php]
Loading plugin class file: calendar_plugin
Calling calendar_plugin(#5)->SkinTag( )
get_by_ID(): Instantiate Plugin (ID 7).
register(): categories_plugin, ID: 7, priority: 60, classfile_path: [/home/grahamsh/public_html/b2evo/plugins/_categories.plugin.php]
Loading plugin class file: categories_plugin
Calling categories_plugin(#7)->SkinTag( )
get_by_ID(): Instantiate Plugin (ID 6).
register(): archives_plugin, ID: 6, priority: 50, classfile_path: [/home/grahamsh/public_html/b2evo/plugins/_archives.plugin.php]
Loading plugin class file: archives_plugin
Calling archives_plugin(#6)->SkinTag( )
Trigger event CacheIsCollectingContent (first true)
No registered plugins.
Trigger event AppendHitLog (first true)
No registered plugins.

session:

cookie_domain=.grahamshevlin.com
cookie_path=/b2evo///
No session cookie received.
ID (generated): 541644
Cookie sent.

settings:

GeneralSettings::get( db_version// ): '9350'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( default_locale// ): 'en-US'
GeneralSettings::get( posts_per_page// ): '50'
GeneralSettings::get( what_to_show// ): 'posts'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( fm_enable_roots_blog// ): [DEFAULT]: '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( permalink_type// ): 'urltitle'
GeneralSettings::get( permalink_type// ): 'urltitle'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( reloadpage_timeout// ): '300'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( permalink_type// ): 'urltitle'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
PluginSettings::get( 8/allow_anon_comments/ ): '1'
GeneralSettings::get( permalink_type// ): 'urltitle'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
PluginSettings::get( 8/allow_anon_comments/ ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( newusers_level// ): '1'
PluginSettings::get( 9/use_for_anonymous/ ): '1'
PluginSettings::get( 9/TTF_folder/ ): 'fonts/'
PluginSettings::get( 9/minchars/ ): '4'
PluginSettings::get( 9/maxchars/ ): '6'
PluginSettings::get( 9/validchars/ ): 'abcdefghjkmnpqrstuvwxyz23456789?@#$%&*ABCDEFGHJKLMNPQRSTUVWXYZ23456789?@#$%&*'
PluginSettings::get( 9/case_sensitive/ ): '0'
PluginSettings::get( 9/case_sensitive/ ): '0'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( time_difference// ): '-3600'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( archive_mode// ): 'monthly'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( newusers_canregister// ): '0'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( links_extrapath// ): '1'
GeneralSettings::get( auto_prune_stats_mode// ): 'off'
GeneralSettings::get( log_public_hits// ): '1'

skin:

No skin forced.
$default_skin = custom
Forced skin: custom

timer:

Starting timer total
Starting timer main.inc
Starting timer abstractsettings_GeneralSettings_get
Starting timer sql_queries
Starting timer Hit::get_remote_host
Starting timer plugin_init
Starting timer _blog_main.inc
Starting timer plugins_register
Starting timer gallery_plugin_(#11)
Starting timer skin/_main.inc
Starting timer basic_antispam_plugin_(#8)
Starting timer plugins_inst_Settings
Starting timer abstractsettings_PluginSettings_get
Starting timer captcha_img_plugin_(#9)
Starting timer calendar_plugin_(#5)
Starting timer categories_plugin_(#7)
Starting timer archives_plugin_(#6)

vars:

Getting ReqURI from REQUEST_URI
$ReqHost: http://grahamshevlin.com
$ReqURI: /b2evo///index.php/currentlinks/2008/02/28/papers_please
$ReqPath: /b2evo///index.php/currentlinks/2008/02/28/papers_please
Hash key: 64

DB

DB queries: 32

Query #1:


      SELECT set_name, set_value
      
FROM evo_settings

Rows: 43 – Time: 0.0001s (0.04%)

Query #2:


      SELECT agnt_ID 
FROM evo_useragents
       
WHERE agnt_signature = "CCBot/1.0 (+http://www.commoncrawl.org/bot.html)"
         
  AND agnt_type = "unknown"

Rows: 1 – Time: 0.0001s (0.03%)

Query #3:

INSERT INTO evo_sessions( sess_key, sess_lastseen, sess_ipaddress )
        
VALUES (
          'k8yWu7h409ceuVlsOulIai9X6T96u91p',
          '2008-07-04 10:26:29',
          '38.103.63.18'
        )

Rows: 1 – Time: 0.0002s (0.07%)

Query #4: Loading plugin events


        SELECT pevt_plug_ID, pevt_event
          
FROM evo_pluginevents INNER JOIN evo_plugins ON pevt_plug_ID = plug_ID
         
WHERE pevt_enabled > 0
         
  AND plug_status = "enabled"
         
ORDER BY plug_priority, plug_classname

Rows: 35 – Time: 0.0001s (0.03%)

Query #5:

SELECT
            loc_locale, loc_charset, loc_datefmt, loc_timefmt, loc_startofweek,
            loc_name, loc_messages, loc_priority, loc_enabled
            
FROM evo_locales 
ORDER BY loc_priority

Rows: 44 – Time: 0.0002s (0.05%)

Query #6:

SET NAMES latin1

Rows: 0 – Time: 0.0001s (0.03%)

Query #7:


        SELECT *
          
FROM evo_blogs
         
WHERE blog_urlname = 'currentlinks'

Rows: 1 – Time: 0.0001s (0.03%)

Query #8: Get ID list for Item List (Main|Lastpostdate) Query

SELECT DISTINCT post_ID 
FROM evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID
                  INNER JOIN evo_categories ON postcat_cat_ID = cat_ID 
WHERE (post_urltitle = 'papers_please') 
  AND (cat_blog_ID = 4) 
  AND ( ( post_status IN ('published') ) ) 
  AND (post_datestart <= '2008-07-04 10:26:29') 
ORDER BY post_datestart DESC

Rows: 1 – Time: 0.0005s (0.15%)

Query #9: Get data for Item List (Main|Lastpostdate) Query

SELECT *
                      
FROM evo_posts 
WHERE post_ID IN (1056)
                        
ORDER BY post_datestart DESC

Rows: 1 – Time: 0.0002s (0.05%)

Query #10: loading CAT cache

SELECT cat_ID, cat_parent_ID, cat_name, cat_blog_ID
            
FROM evo_categories
            
ORDER BY cat_name

Rows: 120 – Time: 0.0001s (0.03%)

Query #11: Get result count


        SELECT COUNT( DISTINCT post_ID )
        
FROM evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID
          INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
          
WHERE (post_urltitle = 'papers_please') 
  AND (cat_blog_ID = 4) 
  AND ( ( post_status IN ('published') ) ) 
  AND (post_datestart <= '2008-07-04 10:26:29')

Rows: 1 – Time: 0.0003s (0.08%)

Query #12:


      SELECT plug_ID, plug_priority, plug_classname, plug_code, plug_name, plug_shortdesc, plug_apply_rendering, plug_status, plug_version, plug_spam_weight
        
FROM evo_plugins
       
WHERE plug_status = "enabled"
       
ORDER BY plug_priority, plug_classname

Rows: 12 – Time: 0.0001s (0.02%)

Query #13:

SELECT *
                
FROM evo_posts
               
WHERE post_urltitle = 'papers_please'

Rows: 1 – Time: 0.0003s (0.07%)

Query #14: DataObjectCache::get_by_ID()

SELECT *
                  
FROM evo_users
                 
WHERE user_ID = 1

Rows: 1 – Time: 0.0001s (0.03%)

Query #15:

SELECT postcat_post_ID, postcat_cat_ID
            
FROM evo_postcats
            
WHERE postcat_post_ID IN (1056)
            
ORDER BY postcat_post_ID, postcat_cat_ID

Rows: 1 – Time: 0.0001s (0.02%)

Query #16: Hit: Check for reload


          SELECT hit_ID
            
FROM evo_hitlog INNER JOIN evo_useragents
              ON hit_agnt_ID = agnt_ID
           
WHERE hit_datetime > "2008-07-04 10:21:29"
             
  AND hit_remote_addr = '38.103.63.18'
             
  AND hit_uri = "/b2evo///index.php/currentlinks/2008/02/28/papers_please"
             
  AND agnt_signature = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
           
LIMIT 1

Rows: 0 – Time: 0.0799s (22.62%)

Query #17:

UPDATE evo_posts
                    SET post_views = post_views + 1
                  
WHERE post_ID = 1056

Rows: 1 – Time: 0.0003s (0.10%)

Query #18: Check prerendered item content


          SELECT itpr_content_prerendered
            
FROM evo_item__prerendering
           
WHERE itpr_itm_ID = 1056
             
  AND itpr_format = "htmlbody"
             
  AND itpr_renderers = "b2evALnk.b2WPAutP"

Rows: 1 – Time: 0.0001s (0.02%)

Query #19:


      SELECT pset_plug_ID, pset_name, pset_value
      
FROM evo_pluginsettings 
WHERE pset_plug_ID = "8"

Rows: 5 – Time: 0.0001s (0.03%)

Query #20:

SELECT comment_post_ID, comment_type, comment_status, COUNT(*) AS type_count
                
FROM evo_comments
               
WHERE comment_post_ID IN (1056)
               
GROUP BY comment_post_ID, comment_type, comment_status

Rows: 0 – Time: 0.0001s (0.02%)

Query #21:

SELECT DISTINCT evo_comments.*
                  
FROM evo_comments INNER JOIN evo_posts ON comment_post_ID = post_ID  
WHERE comment_post_ID = 1056 
  AND comment_type IN ('comment','pingback')  
  AND comment_status IN ('published') 
  AND  ( post_status IN ('published') ) 
ORDER BY comment_date ASC

Rows: 0 – Time: 0.0004s (0.11%)

Query #22:


      SELECT pset_plug_ID, pset_name, pset_value
      
FROM evo_pluginsettings 
WHERE pset_plug_ID = "9"

Rows: 18 – Time: 0.0001s (0.03%)

Query #23:

SELECT COUNT(*) 
FROM evo_plugin_captcha_img_9_data 
WHERE cpt_public = "6a66aea88ae188e7132599f6a692b800"

Rows: 1 – Time: 0.0002s (0.05%)

Query #24:

INSERT INTO evo_plugin_captcha_img_9_data
      ( cpt_public, cpt_private, cpt_sess_ID, cpt_timestamp ) 
VALUES
      ( '6a66aea88ae188e7132599f6a692b800', 'FT6@%L', 541644, 
FROM_UNIXTIME(1215181589) )

Rows: 1 – Time: 0.0002s (0.05%)

Query #25:

SELECT COUNT(DISTINCT post_ID) AS item_count,
                          YEAR(post_datestart), MONTH(post_datestart),
                          DAYOFMONTH(post_datestart) AS myday
                  
FROM (evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID)
                    INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
                  
WHERE YEAR(post_datestart) = "2008"
                    
  AND MONTH(post_datestart) = "07"
                     
  AND (cat_blog_ID = 4) 
  AND ( ( post_status IN ('published') ) ) 
  AND (post_datestart <= '2008-07-04 10:26:29')
                  
GROUP BY myday 
                  
ORDER BY post_datestart DESC

Rows: 0 – Time: 0.0019s (0.52%)

Query #26: blog_load_cache()

SELECT * 
FROM evo_blogs 
ORDER BY blog_ID

Rows: 10 – Time: 0.0002s (0.04%)

Query #27: Load postcounts

SELECT postcat_cat_ID AS cat_ID, COUNT(*) AS cat_postcount 
FROM evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID
                  INNER JOIN evo_categories ON postcat_cat_ID = cat_ID  
WHERE (cat_blog_ID = 4) 
  AND ( ( post_status IN ('published') ) ) 
  AND (post_datestart <= '2008-07-04 10:26:29')
            
GROUP BY cat_ID

Rows: 17 – Time: 0.0021s (0.60%)

Query #28:

SELECT VERSION()

Rows: 1 – Time: 0.0002s (0.06%)

Query #29:

SELECT COUNT( DISTINCT YEAR(post_datestart), MONTH(post_datestart) )  
FROM evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID
                  INNER JOIN evo_categories ON postcat_cat_ID = cat_ID  
WHERE (cat_blog_ID = 4) 
  AND ( ( post_status IN ('published') ) ) 
  AND (post_datestart <= '2008-07-04 10:26:30')

Rows: 1 – Time: 0.0021s (0.59%)

Query #30:

SELECT SQL_CALC_FOUND_ROWS YEAR(post_datestart) AS year, MONTH(post_datestart) AS month,
                                  COUNT(DISTINCT postcat_post_ID) AS count  
FROM evo_posts INNER JOIN evo_postcats ON post_ID = postcat_post_ID
                  INNER JOIN evo_categories ON postcat_cat_ID = cat_ID  
WHERE (cat_blog_ID = 4) 
  AND ( ( post_status IN ('published') ) ) 
  AND (post_datestart <= '2008-07-04 10:26:30')
                          
GROUP BY year, month
                          
ORDER BY year DESC, month DESC 
LIMIT 0, 12

Rows: 12 – Time: 0.0019s (0.55%)

Query #31: Sessions: get list of relevant users.


      SELECT sess_user_ID
        
FROM evo_sessions
       
WHERE sess_lastseen > "2008-07-04 10:21:29"
         
  AND sess_key IS NOT NULL

Rows: 39 – Time: 0.2588s (73.31%)

Query #32: Record the hit


      INSERT INTO evo_hitlog(
        hit_sess_ID, hit_datetime, hit_uri, hit_referer_type,
        hit_referer, hit_referer_dom_ID, hit_blog_ID, hit_remote_addr, hit_agnt_ID )
      
VALUES( "541644", 
FROM_UNIXTIME(1215181589), "/b2evo///index.php/currentlinks/2008/02/28/papers_please", "direct", "", NULL, 4, "38.103.63.18", 3956
      )

Rows: 1 – Time: 0.0004s (0.12%)

Total rows: 371

Papers Please!

02/28/08

Papers Please!

Comments, Pingbacks:

Leave a comment: