To journey is to live (H.C. Andersen)

This collection ©2018 by Jan Kirk • ContactHelp

CCMS
AJAX Debug log
Clear

Debug info

HTTP Response code: 200
$content_type_header: Content-type: text/html; charset=utf-8
$disp: single -- detail: single
$robots_index:
$robots_follow:
72 SQL queries executed in 0.050 seconds   scroll down to details

Timers
CategoryTime%Count
total0.142100.00%1
first_flush0.142100.00%1
_MAIN.inc0.0139.15%1
_init_db0.0053.52%1
SQL QUERIES0.05035.21%72
abstractsettings_GeneralSettings_get0.0021.41%144
init modules0.0021.41%1
plugin_init0.0021.41%2
_init_hit0.0021.41%2
index.php0.0128.45%1
convert_charset0.0053.52%1644
_BLOG_MAIN.inc0.0064.23%1
abstractsettings_CollectionSettings_get0.0053.52%250
SKIN DISPLAY0.10876.06%1
PageCache0.01913.38%1
Read cache file0.01913.38%1
Cache file processing0.09264.79%1
skin_init0.0085.63%1
skin_include(_html_header.inc.php)0.01510.56%1
plugins_register0.0074.93%27
wikitables_plugin_(#28)0.0021.41%1
siteskin_include(_site_body_header.inc.php)0.02114.79%1
skin_include($disp$)0.03021.13%1
skin_include(_item_block.inc.php)0.03021.13%1
skin_container(Item Single Header)0.0021.41%1
Widget->display(item_info_line)0.0021.41%1
skin_container(Item Single)0.0117.75%1
Widget->display(item_content)0.0096.34%1
skin_include(_item_content.inc.php)0.0096.34%1
skin_include(_item_feedback.inc.php)0.01611.27%1
skin_include(_item_comment.inc.php)0.0085.63%1
shutdown0.0032.11%1
+ 41 queries < 1%
Opcode cache: OPCache

User cache: none

Memory usage: 19 MB
Memory peak usage: 19 MB
Len of serialized $cache_imgsize: 281
Len of serialized $cache_File: 2

Debug messages

_init_login | detectblog | filters | locale | pagecache | request | skins | timer

detectblog:

  • No blog param received, checking extra path...
  • Found a potential URL collection name: test-post-on-front-page (in: http://www.ourspiritwalk.com/index.php/test-post-on-front-page)
  • No match.
  • Looking up absolute url : http://www.ourspiritwalk.com/
  • Checking for epxlicit "blog" param
  • Using default blog 1

filters:

  • Saving filterset CommentList_filters_coll1

locale:

  • Set DB connection charset: utf8
  • Login: default_locale from conf: en-US
  • Login: default_locale from DB: en-GB
  • Login: default_locale from HTTP_ACCEPT: en-GB
  • evo_charset: utf-8
  • io_charset: utf-8
  • Activating blog locale: en-GB
  • We need to load a new translation file to translate: "No results"
  • T_: Messages file does not exist or is not readable: /var/www/jankirk.net/public_html/ourspiritwalk/locales/en_US/_global.php
  • We need to load a new translation file to translate: "Javascript WYSIWYG editor"
  • T_: Messages file does not exist or is not readable: /var/www/jankirk.net/public_html/ourspiritwalk/plugins/tinymce_plugin/locales/en_US/_global.php
  • We need to load a new translation file to translate: "Post to your Twitter account when you post to your blog"
  • T_: Messages file does not exist or is not readable: /var/www/jankirk.net/public_html/ourspiritwalk/plugins/twitter_plugin/locales/en_US/_global.php
  • We need to load a new translation file to translate: "Absolute URLs (starting with %s or %s) in brackets"
  • T_: Messages file does not exist or is not readable: /var/www/jankirk.net/public_html/ourspiritwalk/plugins/shortlinks_plugin/locales/en_US/_global.php
  • We need to load a new translation file to translate: "Search list for posts"
  • T_: Messages file does not exist or is not readable: /var/www/jankirk.net/public_html/ourspiritwalk/plugins/custom_tags_plugin/locales/en_US/_global.php
  • We need to load a new translation file to translate: "Search list for posts"
  • T_: Messages file does not exist or is not readable: /var/www/jankirk.net/public_html/ourspiritwalk/plugins/gmcode_plugin/locales/en_US/_global.php
  • We need to load a new translation file to translate: "Enter custom definitions above."
  • T_: Messages file does not exist or is not readable: /var/www/jankirk.net/public_html/ourspiritwalk/plugins/autolinks_plugin/locales/en_US/_global.php

pagecache:

  • URL being cached: http://www.ourspiritwalk.com/index.php/test-post-on-front-page
  • Cache file: /var/www/jankirk.net/public_html/ourspiritwalk/_cache/c1/088f5782fec7fbd8eb245e103d7a3a25.page
  • Retrieving from cache!
  • Cache age: 1612 min 32 sec
  • Collecting started
  • Cache updated!

request:

  • vars: vars: Getting ReqURI from REQUEST_URI
  • vars: $ReqHost: http://www.ourspiritwalk.com
  • vars: $ReqURI: /index.php/test-post-on-front-page
  • vars: $ReqPath: /index.php/test-post-on-front-page
  • Hit: IP: 54.224.220.72
  • Hit: UserAgent: CCBot/2.0 (https://commoncrawl.org/faq/)
  • Hit: Referer: false; type=direct
  • Hit: Remote Host(NO nslookup):
  • Session: cookie_domain=ourspiritwalk.com
  • Session: cookie_path=/
  • Session: No session cookie received.
  • Session: ID (generated): 85745
  • Session: Cookie sent.
  • Transaction name: Home:single
  • Session: Session data[CommentList_filters_coll1] updated. Expire in: -.
  • Session: Session data[CommentList_filters_coll1_refresh_time] updated. Expire in: -.
  • Hash key: 82
  • Hit: Recording the hit.
  • Hit:detect_useragent(): Agent name:
  • Hit:detect_useragent(): Agent platform:
  • Session: Session data saved!

skins:

  • Selected skin: bootstrap_main_skin
  • blog_main: include skins/bootstrap_main_skin/index.main.php (default handler)
  • skin_init: $disp=single
  • skin_init: $disp=single / $disp_detail=single / $seo_page_type=Single post page
  • skin_include (Item #169): /var/www/jankirk.net/public_html/ourspiritwalk/skins_fallback_v6/_html_header.inc.php
  • siteskin_include: skins_site/_skin_init.inc.php
  • siteskin_include: skins_site/_site_body_header.inc.php
  • skin_include (Item #169): /var/www/jankirk.net/public_html/ourspiritwalk/skins_fallback_v6/_single.disp.php
  • skin_include (Item #169): /var/www/jankirk.net/public_html/ourspiritwalk/skins_fallback_v6/_item_block.inc.php
  • skin_include (Item #169): /var/www/jankirk.net/public_html/ourspiritwalk/skins_fallback_v6/_item_content.inc.php
  • skin_include (Item #169): /var/www/jankirk.net/public_html/ourspiritwalk/skins_fallback_v6/_item_feedback.inc.php
  • skin_include (Item #169): /var/www/jankirk.net/public_html/ourspiritwalk/skins_fallback_v6/_item_comment.inc.php
  • skin_include (Item #169): /var/www/jankirk.net/public_html/ourspiritwalk/skins_fallback_v6/_item_workflow.inc.php
  • skin_include (Item #169): /var/www/jankirk.net/public_html/ourspiritwalk/skins_fallback_v6/_item_meta_comments.inc.php
  • siteskin_include: skins_site/_site_body_footer.inc.php
  • skin_include (-): /var/www/jankirk.net/public_html/ourspiritwalk/skins_fallback_v5/_html_footer.inc.php

timer:

  • total resumed at 0.000
  •     _init_base resumed at 0.000
  •         first_flush resumed at 0.000
  •             _MAIN.inc resumed at 0.000
  •             _init_base paused at 0.001 (+0.0008)
  •             _init_db resumed at 0.000
  •             _init_db paused at 0.005 (+0.0051)
  •             init modules resumed at 0.000
  •             init modules paused at 0.002 (+0.0021)
  •             plugin_init resumed at 0.000
  •             plugin_init paused at 0.001 (+0.0011)
  •             _init_hit resumed at 0.000
  •                 Hit::get_remote_host resumed at 0.000
  •                 Hit::get_remote_host paused at 0.000 (+0.0000)
  •             _init_hit paused at 0.002 (+0.0021)
  •             _init_session resumed at 0.000
  •                 _init_session__new resumed at 0.000
  •                 _init_session__new paused at 0.001 (+0.0010)
  •                 _init_session__new stopped at 0.001
  •                 _init_session__plugin resumed at 0.000
  •                 _init_session__plugin paused at 0.000 (+0.0000)
  •                 _init_session__plugin stopped at 0.000
  •                 _init_session__user_settings resumed at 0.000
  •                 _init_session__user_settings paused at 0.000 (+0.0001)
  •                 _init_session__user_settings stopped at 0.000
  •             _init_session paused at 0.001 (+0.0013)
  •             _init_login resumed at 0.000
  •             _init_login paused at 0.000 (+0.0003)
  •             _init_session resumed at 0.001
  •                 _init_session__locale resumed at 0.000
  •                 _init_session__locale paused at 0.000 (+0.0000)
  •                 _init_session__locale stopped at 0.000
  •             _init_session paused at 0.001 (+0.0000)
  •             _init_hit resumed at 0.002
  •             _init_hit paused at 0.002 (+0.0000)
  •             suspect_user_by_IP resumed at 0.000
  •             suspect_user_by_IP paused at 0.000 (+0.0000)
  •             suspect_user_by_IP stopped at 0.000
  •         _MAIN.inc paused at 0.013 (+0.0133)
  •         index.php resumed at 0.000
  •             Blog constructor resumed at 0.000
  •             Blog constructor paused at 0.000 (+0.0000)
  •         index.php paused at 0.012 (+0.0116)
  •         _BLOG_MAIN.inc resumed at 0.000
  •         _BLOG_MAIN.inc paused at 0.006 (+0.0056)
  •         SKIN DISPLAY resumed at 0.000
  •             PageCache resumed at 0.000
  •                 Read cache file resumed at 0.000
  •                 Read cache file paused at 0.019 (+0.0189)
  •                 Cache file processing resumed at 0.000
  •                 PageCache paused at 0.019 (+0.0192)
  •                 skin_init resumed at 0.000
  •                     Blog constructor resumed at 0.000
  •                     Blog constructor paused at 0.000 (+0.0000)
  •                 skin_init paused at 0.008 (+0.0081)
  •                 Skin:display_init resumed at 0.000
  •                 Skin:display_init paused at 0.001 (+0.0009)
  •                 skin_include(_html_header.inc.php) resumed at 0.000
  •                     siteskin_include(_skin_init.inc.php) resumed at 0.000
  •                     siteskin_include(_skin_init.inc.php) paused at 0.000 (+0.0001)
  •                     plugins_register resumed at 0.000
  •                     plugins_register paused at 0.001 (+0.0006)
  •                     tinymce_plugin_(#10) resumed at 0.000
  •                     tinymce_plugin_(#10) paused at 0.000 (+0.0000)
  •                     plugins_register resumed at 0.001
  •                     plugins_register paused at 0.001 (+0.0006)
  •                     wikitables_plugin_(#28) resumed at 0.000
  •                         plugin_init resumed at 0.001
  •                         plugin_init paused at 0.002 (+0.0012)
  •                     wikitables_plugin_(#28) paused at 0.002 (+0.0016)
  •                     plugins_register resumed at 0.001
  •                     plugins_register paused at 0.002 (+0.0003)
  •                     twitter_plugin_(#11) resumed at 0.000
  •                         plugins_inst_UserSettings resumed at 0.000
  •                             twitter_plugin_(#11) resumed at 0.000
  •                             twitter_plugin_(#11) paused at 0.000 (+0.0000)
  •                         plugins_inst_UserSettings paused at 0.000 (+0.0002)
  •                     twitter_plugin_(#11) paused at 0.000 (+0.0006)
  • Warning: tried to pause already paused 'twitter_plugin_(#11)'.
  •                     plugins_register resumed at 0.002
  •                     plugins_register paused at 0.002 (+0.0002)
  •                     flowplayer_plugin_(#12) resumed at 0.000
  •                     flowplayer_plugin_(#12) paused at 0.000 (+0.0002)
  •                     plugins_register resumed at 0.002
  •                     plugins_register paused at 0.002 (+0.0002)
  •                     html5_mediaelementjs_plugin_(#16) resumed at 0.000
  •                     html5_mediaelementjs_plugin_(#16) paused at 0.001 (+0.0006)
  •                     plugins_register resumed at 0.002
  •                     plugins_register paused at 0.002 (+0.0002)
  •                     html5_videojs_plugin_(#17) resumed at 0.000
  •                     html5_videojs_plugin_(#17) paused at 0.000 (+0.0002)
  •                     plugins_register resumed at 0.002
  •                     plugins_register paused at 0.002 (+0.0002)
  •                     widescroll_plugin_(#31) resumed at 0.000
  •                     widescroll_plugin_(#31) paused at 0.000 (+0.0001)
  •                 skin_include(_html_header.inc.php) paused at 0.015 (+0.0154)
  •                 siteskin_include(_site_body_header.inc.php) resumed at 0.000
  •                 siteskin_include(_site_body_header.inc.php) paused at 0.021 (+0.0211)
  •                 skin_container(Page Top) resumed at 0.000
  •                     Widget->display(social_links) resumed at 0.000
  •                     Widget->display(social_links) paused at 0.001 (+0.0010)
  •                 skin_container(Page Top) paused at 0.001 (+0.0011)
  •                 skin_container(Header) resumed at 0.000
  •                     Widget->display(coll_title) resumed at 0.000
  •                     Widget->display(coll_title) paused at 0.000 (+0.0002)
  •                     Widget->display(coll_tagline) resumed at 0.000
  •                     Widget->display(coll_tagline) paused at 0.000 (+0.0001)
  •                 skin_container(Header) paused at 0.000 (+0.0004)
  •                 skin_container(Menu) resumed at 0.000
  •                 skin_container(Menu) paused at 0.000 (+0.0000)
  •                 skin_include($disp$) resumed at 0.000
  •                     skin_include(_item_block.inc.php) resumed at 0.000
  •                         skin_container(Item Single Header) resumed at 0.000
  •                             Widget->display(item_info_line) resumed at 0.000
  •                             Widget->display(item_info_line) paused at 0.002 (+0.0019)
  •                         skin_container(Item Single Header) paused at 0.002 (+0.0020)
  •                         skin_container(Item Single) resumed at 0.000
  •                             Widget->display(item_content) resumed at 0.000
  •                                 skin_include(_item_content.inc.php) resumed at 0.000
  •                                     plugins_register resumed at 0.002
  •                                     plugins_register paused at 0.003 (+0.0002)
  •                                     plugins_register resumed at 0.003
  •                                     plugins_register paused at 0.003 (+0.0003)
  •                                     plugins_register resumed at 0.003
  •                                     plugins_register paused at 0.003 (+0.0002)
  •                                     plugins_register resumed at 0.003
  •                                     plugins_register paused at 0.003 (+0.0003)
  •                                     plugins_register resumed at 0.003
  •                                     plugins_register paused at 0.004 (+0.0002)
  •                                     plugins_register resumed at 0.004
  •                                     plugins_register paused at 0.004 (+0.0002)
  •                                     plugins_register resumed at 0.004
  •                                     plugins_register paused at 0.004 (+0.0003)
  •                                     plugins_register resumed at 0.004
  •                                     plugins_register paused at 0.004 (+0.0002)
  •                                     plugins_register resumed at 0.004
  •                                     plugins_register paused at 0.004 (+0.0002)
  •                                     plugins_register resumed at 0.004
  •                                     plugins_register paused at 0.005 (+0.0002)
  •                                     plugins_register resumed at 0.005
  •                                     plugins_register paused at 0.005 (+0.0003)
  •                                     plugins_register resumed at 0.005
  •                                     plugins_register paused at 0.005 (+0.0002)
  •                                     plugins_register resumed at 0.005
  •                                     plugins_register paused at 0.005 (+0.0002)
  •                                     plugins_register resumed at 0.005
  •                                     plugins_register paused at 0.005 (+0.0002)
  •                                     plugins_register resumed at 0.005
  •                                     plugins_register paused at 0.006 (+0.0002)
  •                                     plugins_register resumed at 0.006
  •                                     plugins_register paused at 0.006 (+0.0002)
  •                                     plugins_register resumed at 0.006
  •                                     plugins_register paused at 0.006 (+0.0002)
  •                                     plugins_register resumed at 0.006
  •                                     plugins_register paused at 0.006 (+0.0002)
  •                                     plugins_register resumed at 0.006
  •                                     plugins_register paused at 0.006 (+0.0002)
  •                                     plugins_register resumed at 0.006
  •                                     plugins_register paused at 0.007 (+0.0002)
  •                                 skin_include(_item_content.inc.php) paused at 0.009 (+0.0091)
  •                             Widget->display(item_content) paused at 0.009 (+0.0093)
  •                             Widget->display(item_attachments) resumed at 0.000
  •                             Widget->display(item_attachments) paused at 0.001 (+0.0008)
  •                             Widget->display(item_link) resumed at 0.000
  •                             Widget->display(item_link) paused at 0.000 (+0.0002)
  •                             Widget->display(item_tags) resumed at 0.000
  •                             Widget->display(item_tags) paused at 0.000 (+0.0002)
  •                             Widget->display(item_seen_by) resumed at 0.000
  •                             Widget->display(item_seen_by) paused at 0.000 (+0.0002)
  •                             Widget->display(item_vote) resumed at 0.000
  •                             Widget->display(item_vote) paused at 0.000 (+0.0002)
  •                         skin_container(Item Single) paused at 0.011 (+0.0111)
  •                         skin_include(_item_feedback.inc.php) resumed at 0.000
  •                             skin_include(_item_comment.inc.php) resumed at 0.000
  •                                 basic_antispam_plugin_(#14) resumed at 0.000
  •                                     plugins_inst_Settings resumed at 0.000
  •                                         basic_antispam_plugin_(#14) resumed at 0.000
  •                                         basic_antispam_plugin_(#14) paused at 0.000 (+0.0001)
  •                                     plugins_inst_Settings paused at 0.000 (+0.0004)
  •                                 basic_antispam_plugin_(#14) paused at 0.000 (+0.0012)
  • Warning: tried to pause already paused 'basic_antispam_plugin_(#14)'.
  •                             skin_include(_item_comment.inc.php) paused at 0.008 (+0.0076)
  •                         skin_include(_item_feedback.inc.php) paused at 0.016 (+0.0157)
  •                         skin_include(_item_workflow.inc.php) resumed at 0.000
  •                         skin_include(_item_workflow.inc.php) paused at 0.000 (+0.0001)
  •                         skin_include(_item_meta_comments.inc.php) resumed at 0.000
  •                         skin_include(_item_meta_comments.inc.php) paused at 0.000 (+0.0001)
  •                     skin_include(_item_block.inc.php) paused at 0.030 (+0.0298)
  •                 skin_include($disp$) paused at 0.030 (+0.0301)
  •                 skin_container(Footer) resumed at 0.000
  •                 skin_container(Footer) paused at 0.000 (+0.0000)
  •                 siteskin_include(_site_body_footer.inc.php) resumed at 0.000
  •                 siteskin_include(_site_body_footer.inc.php) paused at 0.000 (+0.0001)
  •                 skin_include(_html_footer.inc.php) resumed at 0.000
  •                 skin_include(_html_footer.inc.php) paused at 0.000 (+0.0001)
  •             PageCache paused at 0.019 (+0.1084)
  • Warning: tried to pause already paused 'PageCache'.
  •         SKIN DISPLAY paused at 0.108 (+0.1084)
  •         shutdown resumed at 0.000

DB

Config DB Username: jankirk_net
Config DB Database: jankirk_net_db2
Config DB Host: mysql88.unoeuro.com
Config DB tables prefix: evo_
Config DB connection charset: 
Current DB charset: utf8
DB queries: 72

Query #1: Force MySQL "strict" mode (and make sure server is not configured with a weird incompatible mode)

SET sql_mode = "TRADITIONAL"
Rows: 0 – Time: 0.0002s (0.43%)

Query #2: Load settings from T_settings

SELECT set_name, set_value
  FROM evo_settings
Rows: 67 – Time: 0.0006s (1.26%)

Query #3: 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: 124 – Time: 0.0009s (1.78%)

Query #4:

SELECT loc_locale, loc_datefmt, loc_longdatefmt, loc_extdatefmt, loc_input_datefmt, loc_timefmt, loc_shorttimefmt, loc_input_timefmt, loc_startofweek,
            loc_name, loc_messages, loc_priority, loc_transliteration_map, loc_enabled
  FROM evo_locales
 ORDER BY loc_priority
Rows: 1 – Time: 0.0005s (0.92%)

Query #5:

INSERT INTO evo_sessions( sess_key, sess_start_ts, sess_lastseen_ts, sess_ipaddress, sess_device )
VALUES (
          'oBiqOlsOGzEzl8iA9LNSkChXObzZ9Bqc',
          FROM_UNIXTIME(1534461883),
          FROM_UNIXTIME(1534461883),
          '54.224.220.72',
          ''
        )
Rows: 1 – Time: 0.0004s (0.73%)

Query #6:

SELECT *
  FROM evo_blogs
 WHERE blog_urlname = 'test-post-on-front-page'
Rows: 0 – Time: 0.0058s (11.73%)

Query #7: Blog::get_by_url()

SELECT *
  FROM evo_blogs
 WHERE ( blog_access_type = "absolute"
   AND ( 'http://www.ourspiritwalk.com/' LIKE CONCAT( blog_siteurl, "%" )
    OR 'https://www.ourspiritwalk.com/' LIKE CONCAT( blog_siteurl, "%" ) ) )
    OR ( blog_access_type = "subdom"
   AND '://www.ourspiritwalk.com/' LIKE CONCAT( "://", blog_urlname, ".ourspiritwalk.com/%" ) )
Rows: 0 – Time: 0.0038s (7.74%)

Query #8: DataObjectCache::get_by_ID()

SELECT *
  FROM evo_blogs
 WHERE (blog_ID = '1')
 ORDER BY blog_order
Rows: 1 – Time: 0.0005s (0.93%)

Query #9: Load settings from T_coll_settings

SELECT cset_coll_ID, cset_name, cset_value
  FROM evo_coll_settings
 WHERE cset_coll_ID = '1'
Rows: 73 – Time: 0.0005s (0.98%)

Query #10: DataObjectCache::get_by_name()

SELECT *
  FROM evo_slug
 WHERE (slug_title = 'test-post-on-front-page')
 ORDER BY slug_title
Rows: 1 – Time: 0.0003s (0.56%)

Query #11: DataObjectCache::get_by_ID()

SELECT *
  FROM evo_items__item
 WHERE (post_ID = '169')
 ORDER BY post_ID
Rows: 1 – Time: 0.0004s (0.86%)

Query #12:

SELECT count( cat_ID )
  FROM evo_categories, evo_postcats
 WHERE evo_categories.cat_ID = evo_postcats.postcat_cat_ID
   and evo_categories.cat_blog_ID = 1
   and evo_postcats.postcat_post_ID = 169
Rows: 1 – Time: 0.0004s (0.82%)

Query #13: Loading ItemType(ALL) into cache

SELECT *
  FROM evo_items__type
 ORDER BY ityp_ID
Rows: 18 – Time: 0.0004s (0.86%)

Query #14: DataObjectCache::get_by_ID()

SELECT *
  FROM evo_skins__skin
 WHERE (skin_ID = '2')
 ORDER BY skin_name
Rows: 1 – Time: 0.0004s (0.72%)

Query #15: Loading Blog(ALL) into cache

SELECT *
  FROM evo_blogs
 ORDER BY blog_order ASC, blog_ID ASC
Rows: 2 – Time: 0.0006s (1.20%)

Query #16: Get custom fields for items sort options

SELECT DISTINCT( CONCAT( "custom_", itcf_type, "_", itcf_name ) ), itcf_name
  FROM evo_items__type_custom_field
 INNER JOIN evo_items__type ON ityp_ID = itcf_ityp_ID
 INNER JOIN evo_items__type_coll ON itc_ityp_ID = ityp_ID
 WHERE ityp_usage = "post"
   AND (itc_coll_ID = '1')
Rows: 0 – Time: 0.0006s (1.15%)

Query #17: $MainList - ItemList2::Query() Step 1: Get ID list

SELECT DISTINCT post_ID
  FROM evo_items__item
 INNER JOIN evo_categories ON post_main_cat_ID = cat_ID
  LEFT JOIN evo_items__type ON ityp_ID = post_ityp_ID
 WHERE ( 1 )
   AND (ityp_usage IN ( 'post' ))
   AND (post_urltitle = 'test-post-on-front-page')
   AND (post_datestart <= '2018-08-17 01:24')
   AND (( cat_blog_ID IN ( 1,8 )
   AND ( ( post_status IN ( 'published' ) ) ) ))
 ORDER BY post_datestart DESC, post_ID DESC
Rows: 1 – Time: 0.0003s (0.70%)

Query #18: $MainList - ItemList2::Query() Step 2

SELECT *
  FROM evo_items__item
 WHERE post_ID IN (169)
 ORDER BY post_datestart DESC, post_ID DESC
Rows: 1 – Time: 0.0003s (0.69%)

Query #19: Load the category associations for items

SELECT postcat_post_ID AS post_ID, postcat_cat_ID AS cat_ID
  FROM evo_postcats
 WHERE postcat_post_ID IN ( '169' )
 ORDER BY postcat_post_ID, postcat_cat_ID
Rows: 1 – Time: 0.0003s (0.53%)

Query #20: Load settings from T_items__item_settings

SELECT iset_item_ID, iset_name, iset_value
  FROM evo_items__item_settings
 WHERE iset_item_ID = '169'
Rows: 5 – Time: 0.0010s (2.03%)

Query #21: Loading Chapter(ALL) into cache

SELECT *
  FROM evo_categories
 ORDER BY cat_name
Rows: 5 – Time: 0.0003s (0.66%)

Query #22: Load settings from T_global__cache

SELECT cach_name, cach_cache
  FROM evo_global__cache
Rows: 7 – Time: 0.0004s (0.79%)

Query #23: Get list of widgets for collection

SELECT *
  FROM evo_widget
 WHERE wi_coll_ID = 1
   AND wi_enabled = 1
 ORDER BY wi_sco_name, wi_order
Rows: 44 – Time: 0.0005s (1.04%)

Query #24: Loading plugins table data

SELECT plug_ID, plug_priority, plug_classname, plug_code, plug_name, plug_shortdesc, plug_status, plug_version, plug_spam_weight
  FROM evo_plugins
 WHERE plug_status = 'enabled'
 ORDER BY plug_priority, plug_classname
Rows: 27 – Time: 0.0015s (2.92%)

Query #25: 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
 ORDER BY plug_priority, plug_classname
Rows: 215 – Time: 0.0008s (1.52%)

Query #26: DataObjectCache::get_by_ID()

SELECT *
  FROM evo_users
 WHERE (user_ID = '1')
 ORDER BY user_ID
Rows: 1 – Time: 0.0005s (0.93%)

Query #27: Load settings from T_pluginusersettings

SELECT puset_plug_ID, puset_user_ID, puset_name, puset_value
  FROM evo_pluginusersettings
 WHERE puset_plug_ID = '11'
Rows: 0 – Time: 0.0003s (0.61%)

Query #28: Get tags for items

SELECT itag_itm_ID, tag_name
  FROM evo_items__itemtag
 INNER JOIN evo_items__tag ON itag_tag_ID = tag_ID
 WHERE itag_itm_ID IN ('169')
 ORDER BY tag_name
Rows: 0 – Time: 0.0005s (1.08%)

Query #29: get_attachment_LinkList

SELECT l.* , CASE WHEN link_position = "cover" THEN 1 WHEN link_position IN ( "teaser", "teaserperm", "teaserlink" ) THEN 2 ELSE 3 END AS link_priority
  FROM evo_links AS l
 INNER JOIN evo_files ON link_file_ID = file_ID
 WHERE link_itm_ID = 169
   AND (link_position IN ( 'cover','teaser','teaserperm','teaserlink','inline' ))
   AND (file_type = 'image'
    OR file_type IS NULL)
 ORDER BY link_priority ASC, link_order ASC
 LIMIT 1000
Rows: 0 – Time: 0.0006s (1.12%)

Query #30:

SELECT uf_ID, ufdf_ID, uf_varchar, ufdf_duplicated, ufdf_type, ufdf_name, ufdf_icon_name, ufdf_code, ufgp_ID, ufgp_name
  FROM evo_users__fields
 INNER JOIN evo_users__fielddefs ON uf_ufdf_ID = ufdf_ID
 INNER JOIN evo_users__fieldgroups ON ufdf_ufgp_ID = ufgp_ID
 WHERE uf_user_ID = 1
   AND ufdf_required != "hidden"
 ORDER BY ufgp_order, ufdf_order, uf_ID
Rows: 1 – Time: 0.0005s (1.02%)

Query #31:

SELECT ufdf_ID, ufdf_type, ufdf_name, ufdf_required, ufdf_options, ufdf_duplicated
  FROM evo_users__fielddefs
Rows: 29 – Time: 0.0003s (0.57%)

Query #32: get_attachment_LinkList

SELECT l.* , CASE WHEN link_position = "cover" THEN 1 WHEN link_position IN ( "teaser", "teaserperm", "teaserlink" ) THEN 2 ELSE 3 END AS link_priority
  FROM evo_links AS l
 INNER JOIN evo_files ON link_file_ID = file_ID
 WHERE link_itm_ID = 169
   AND (link_position IN ( 'cover','teaser','teaserperm','teaserlink','inline' ))
   AND (file_type = 'image'
    OR file_type IS NULL)
 ORDER BY link_priority ASC, link_order ASC
 LIMIT 1000
Rows: 0 – Time: 0.0004s (0.78%)

Query #33:

SELECT *
  FROM evo_skins__skin
 WHERE skin_folder = '_rss2'
Rows: 1 – Time: 0.0002s (0.43%)

Query #34:

SELECT *
  FROM evo_skins__skin
 WHERE skin_folder = '_atom'
Rows: 1 – Time: 0.0002s (0.42%)

Query #35: Load public blog list

SELECT *
  FROM evo_blogs
 WHERE ( blog_in_bloglist = "public" )
 ORDER BY blog_order ASC, blog_ID ASC
Rows: 2 – Time: 0.0003s (0.69%)

Query #36: Get the ItemType rows to load the objects into the cache by DataObjectCache->load_where()

SELECT *
  FROM evo_items__type
 WHERE ityp_usage = "page"
 ORDER BY ityp_ID
Rows: 1 – Time: 0.0004s (0.72%)

Query #37: Loading ItemType(ALL) into cache

SELECT *
  FROM evo_items__type
 ORDER BY ityp_ID
Rows: 18 – Time: 0.0004s (0.71%)

Query #38: Get custom fields for items sort options

SELECT DISTINCT( CONCAT( "custom_", itcf_type, "_", itcf_name ) ), itcf_name
  FROM evo_items__type_custom_field
 INNER JOIN evo_items__type ON ityp_ID = itcf_ityp_ID
 INNER JOIN evo_items__type_coll ON itc_ityp_ID = ityp_ID
 WHERE ityp_usage = "post"
   AND (itc_coll_ID = '1')
Rows: 0 – Time: 0.0005s (1.00%)

Query #39: coll_page_list_Widget - ItemListLight::count_total_rows()

SELECT COUNT( DISTINCT post_ID )
  FROM evo_items__item
 INNER JOIN evo_categories ON post_main_cat_ID = cat_ID
  LEFT JOIN evo_items__type ON ityp_ID = post_ityp_ID
 WHERE ( cat_blog_ID IN ( '1' ))
   AND (ityp_usage IN ( 'page' ))
   AND (post_datestart <= '2018-08-17 01:24')
   AND (( cat_blog_ID IN ( 1 )
   AND ( ( post_status IN ( 'published' ) ) ) ))
Rows: 1 – Time: 0.0004s (0.83%)

Query #40: Check if user #1 is owner of at least one collection

SELECT blog_ID
  FROM evo_blogs
 WHERE blog_owner_user_ID = '1'
 LIMIT 1
Rows: 1 – Time: 0.0020s (3.95%)

Query #41: Load public blog list

SELECT *
  FROM evo_blogs
 WHERE ( blog_in_bloglist = "public" )
 ORDER BY blog_order ASC, blog_ID ASC
Rows: 2 – Time: 0.0005s (0.97%)

Query #42: Get the ItemType rows to load the objects into the cache by DataObjectCache->load_where()

SELECT *
  FROM evo_items__type
 WHERE ityp_usage = "page"
 ORDER BY ityp_ID
Rows: 1 – Time: 0.0027s (5.50%)

Query #43: Loading ItemType(ALL) into cache

SELECT *
  FROM evo_items__type
 ORDER BY ityp_ID
Rows: 18 – Time: 0.0023s (4.69%)

Query #44: Get custom fields for items sort options

SELECT DISTINCT( CONCAT( "custom_", itcf_type, "_", itcf_name ) ), itcf_name
  FROM evo_items__type_custom_field
 INNER JOIN evo_items__type ON ityp_ID = itcf_ityp_ID
 INNER JOIN evo_items__type_coll ON itc_ityp_ID = ityp_ID
 WHERE ityp_usage = "post"
   AND (itc_coll_ID = '1')
Rows: 0 – Time: 0.0005s (0.97%)

Query #45: coll_page_list_Widget - ItemListLight::count_total_rows()

SELECT COUNT( DISTINCT post_ID )
  FROM evo_items__item
 INNER JOIN evo_categories ON post_main_cat_ID = cat_ID
  LEFT JOIN evo_items__type ON ityp_ID = post_ityp_ID
 WHERE ( cat_blog_ID IN ( '1' ))
   AND (ityp_usage IN ( 'page' ))
   AND (post_datestart <= '2018-08-17 01:24')
   AND (( cat_blog_ID IN ( 1 )
   AND ( ( post_status IN ( 'published' ) ) ) ))
Rows: 1 – Time: 0.0005s (0.96%)

Query #46:

SELECT ufdf_ID, "0" AS uf_ID, ufdf_type, ufdf_code, ufdf_name, ufdf_icon_name, "" AS uf_varchar, ufdf_required,
            ufdf_options, ufdf_suggest, ufdf_duplicated, ufgp_ID, ufgp_name
  FROM evo_users__fielddefs
  LEFT JOIN evo_users__fieldgroups ON ufdf_ufgp_ID = ufgp_ID
 WHERE ufdf_type = "url"
   AND ufdf_icon_name IS NOT NULL
Rows: 10 – Time: 0.0005s (1.00%)

Query #47: Get custom fields for items sort options

SELECT DISTINCT( CONCAT( "custom_", itcf_type, "_", itcf_name ) ), itcf_name
  FROM evo_items__type_custom_field
 INNER JOIN evo_items__type ON ityp_ID = itcf_ityp_ID
 INNER JOIN evo_items__type_coll ON itc_ityp_ID = ityp_ID
 WHERE ityp_usage = "post"
   AND (itc_coll_ID = '1')
Rows: 0 – Time: 0.0004s (0.76%)

Query #48: $MainList - Get ID of next item

SELECT DISTINCT post_ID
  FROM evo_items__item
 INNER JOIN evo_categories ON post_main_cat_ID = cat_ID
  LEFT JOIN evo_items__type ON ityp_ID = post_ityp_ID
 WHERE ( 1 )
   AND (ityp_usage IN ( 'post' ))
   AND (post_datestart <= '2018-08-17 01:24')
   AND (( cat_blog_ID IN ( 1,8 )
   AND ( ( post_status IN ( 'published' ) ) ) ))
   AND (post_datestart > '2018-04-17 09:53:00'
    OR ( post_datestart = '2018-04-17 09:53:00'
   AND post_ID > '169' ))
 ORDER BY post_datestart ASC, post_ID ASC
 LIMIT 1
Rows: 0 – Time: 0.0005s (1.03%)

Query #49: Get custom fields for items sort options

SELECT DISTINCT( CONCAT( "custom_", itcf_type, "_", itcf_name ) ), itcf_name
  FROM evo_items__type_custom_field
 INNER JOIN evo_items__type ON ityp_ID = itcf_ityp_ID
 INNER JOIN evo_items__type_coll ON itc_ityp_ID = ityp_ID
 WHERE ityp_usage = "post"
   AND (itc_coll_ID = '1')
Rows: 0 – Time: 0.0003s (0.65%)

Query #50: $MainList - Get ID of next item

SELECT DISTINCT post_ID
  FROM evo_items__item
 INNER JOIN evo_categories ON post_main_cat_ID = cat_ID
  LEFT JOIN evo_items__type ON ityp_ID = post_ityp_ID
 WHERE ( 1 )
   AND (ityp_usage IN ( 'post' ))
   AND (post_datestart <= '2018-08-17 01:24')
   AND (( cat_blog_ID IN ( 1,8 )
   AND ( ( post_status IN ( 'published' ) ) ) ))
   AND (post_datestart < '2018-04-17 09:53:00'
    OR ( post_datestart = '2018-04-17 09:53:00'
   AND post_ID < '169' ))
 ORDER BY post_datestart DESC, post_ID DESC
 LIMIT 1
Rows: 1 – Time: 0.0006s (1.11%)

Query #51: DataObjectCache::get_by_ID()

SELECT *
  FROM evo_items__item
 WHERE (post_ID = '146')
 ORDER BY post_ID
Rows: 1 – Time: 0.0003s (0.66%)

Query #52:

SELECT count( cat_ID )
  FROM evo_categories, evo_postcats
 WHERE evo_categories.cat_ID = evo_postcats.postcat_cat_ID
   and evo_categories.cat_blog_ID = 1
   and evo_postcats.postcat_post_ID = 146
Rows: 1 – Time: 0.0004s (0.76%)

Query #53: Load settings from T_coll_settings

SELECT cset_coll_ID, cset_name, cset_value
  FROM evo_coll_settings
 WHERE cset_coll_ID = '8'
Rows: 202 – Time: 0.0005s (0.94%)

Query #54: Loading Group(ALL) into cache

SELECT *
  FROM evo_groups
 ORDER BY grp_level DESC, grp_name ASC
Rows: 7 – Time: 0.0005s (1.02%)

Query #55: get_attachment_LinkList

SELECT l.*
  FROM evo_links AS l
 WHERE link_itm_ID = 169
   AND (link_position IN ( 'teaser','teaserperm','teaserlink' ))
 ORDER BY link_order
 LIMIT 1000
Rows: 0 – Time: 0.0005s (0.91%)

Query #56: Preload prerendered item content for MainList/ItemList (htmlbody)

SELECT itpr_itm_ID, itpr_format, itpr_renderers, itpr_content_prerendered
  FROM evo_items__prerendering
 WHERE itpr_itm_ID IN ('169')
   AND itpr_format = 'htmlbody'
Rows: 1 – Time: 0.0005s (0.93%)

Query #57: get_attachment_LinkList

SELECT l.*
  FROM evo_links AS l
 WHERE link_itm_ID = 169
   AND (link_position IN ( 'aftermore' ))
 ORDER BY link_order
 LIMIT 1000
Rows: 0 – Time: 0.0004s (0.81%)

Query #58: get_attachment_LinkList

SELECT l.*
  FROM evo_links AS l
 WHERE link_itm_ID = 169
   AND (link_position IN ( 'cover','teaser','teaserperm','teaserlink','aftermore','attachment' ))
 ORDER BY link_order
 LIMIT 1000
Rows: 0 – Time: 0.0003s (0.65%)

Query #59:

SELECT comment_item_ID, comment_type, comment_status, COUNT(*) AS type_count
  FROM evo_comments
  LEFT JOIN evo_items__item_settings as expiry_setting ON comment_item_ID = iset_item_ID
   AND iset_name = "comment_expiry_delay"
 WHERE ( ( comment_status IN ( 'published' ) ) )
   AND (expiry_setting.iset_value IS NULL
    OR expiry_setting.iset_value = ""
    OR TIMESTAMPDIFF(SECOND, comment_date, '2018-08-16 21:54:43') < expiry_setting.iset_value)
   AND (comment_item_ID IN (169))
 GROUP BY comment_item_ID, comment_type, comment_status
Rows: 2 – Time: 0.0008s (1.61%)

Query #60: Count each published comments rating grouped by active/expired status and by rating value

SELECT comment_rating, count( comment_ID ) AS cnt, IF( iset_value IS NULL
    OR iset_value = ""
    OR TIMESTAMPDIFF(SECOND, comment_date, '2018-08-17 01:24:43') < iset_value, "active", "expired" ) as expiry_status
  FROM evo_comments
  LEFT JOIN evo_items__item_settings ON iset_item_ID = comment_item_ID
   AND iset_name = "comment_expiry_delay"
 WHERE comment_item_ID = 169
   AND ( ( ( comment_status IN ( 'published' ) ) ) )
 GROUP BY expiry_status, comment_rating
 ORDER BY comment_rating DESC
Rows: 1 – Time: 0.0005s (1.03%)

Query #61: CommentList2::count_total_rows()

SELECT COUNT( comment_ID)
  FROM evo_comments
  LEFT JOIN evo_items__item_settings as expiry_setting ON iset_item_ID = comment_item_ID
   AND iset_name = "comment_expiry_delay"
 WHERE ( ( ( comment_status IN ( 'published' ) ) ) )
   AND (comment_type IN ('comment','pingback'))
   AND (comment_item_ID IN (
SELECT DISTINCT post_ID
  FROM evo_items__item
 INNER JOIN evo_categories ON post_main_cat_ID = cat_ID
 WHERE (post_ID = 169)
   AND (( cat_blog_ID IN ( 1,8 )
   AND ( ( post_status IN ( 'published' ) ) ) )) ))
   AND (expiry_setting.iset_value IS NULL
    OR expiry_setting.iset_value = ""
    OR TIMESTAMPDIFF(SECOND, comment_date, '2018-08-17 01:24:43') < expiry_setting.iset_value)
Rows: 1 – Time: 0.0007s (1.43%)

Query #62: CommentList2::Query() Step 1: Get ID list

SELECT comment_ID
  FROM evo_comments
  LEFT JOIN evo_items__item_settings as expiry_setting ON iset_item_ID = comment_item_ID
   AND iset_name = "comment_expiry_delay"
 WHERE ( ( ( comment_status IN ( 'published' ) ) ) )
   AND (comment_type IN ('comment','pingback'))
   AND (comment_item_ID IN (
SELECT DISTINCT post_ID
  FROM evo_items__item
 INNER JOIN evo_categories ON post_main_cat_ID = cat_ID
 WHERE (post_ID = 169)
   AND (( cat_blog_ID IN ( 1,8 )
   AND ( ( post_status IN ( 'published' ) ) ) )) ))
   AND (expiry_setting.iset_value IS NULL
    OR expiry_setting.iset_value = ""
    OR TIMESTAMPDIFF(SECOND, comment_date, '2018-08-17 01:24:43') < expiry_setting.iset_value)
 ORDER BY comment_date ASC, comment_ID ASC
 LIMIT 1000
Rows: 1 – Time: 0.0006s (1.13%)

Query #63: CommentList2::Query() Step 2

SELECT *
  FROM evo_comments
 WHERE comment_ID IN (5)
 ORDER BY comment_date ASC, comment_ID ASC
Rows: 1 – Time: 0.0003s (0.64%)

Query #64: Load settings from T_pluginsettings

SELECT pset_plug_ID, pset_name, pset_value
  FROM evo_pluginsettings
 WHERE pset_plug_ID = '14'
Rows: 0 – Time: 0.0005s (0.97%)

Query #65: Get the links by user ID #1

SELECT *
  FROM evo_links
 WHERE link_usr_ID = '1'
 ORDER BY link_file_ID
Rows: 1 – Time: 0.0004s (0.82%)

Query #66: Get the File rows to load the objects into the cache by DataObjectCache->load_where()

SELECT *
  FROM evo_files
 WHERE file_ID IN ( 13 )
 ORDER BY file_ID
Rows: 1 – Time: 0.0003s (0.66%)

Query #67: Loading Filetype(ALL) into cache

SELECT *
  FROM evo_filetypes
 ORDER BY ftyp_extensions
Rows: 24 – Time: 0.0005s (1.09%)

Query #68: Get the links by comment ID #5

SELECT *
  FROM evo_links
 WHERE link_cmt_ID = '5'
 ORDER BY link_file_ID
Rows: 0 – Time: 0.0004s (0.77%)

Query #69: Preload prerendered comments content (htmlbody)

SELECT cmpr_cmt_ID, cmpr_format, cmpr_renderers, cmpr_content_prerendered
  FROM evo_comments__prerendering
 WHERE cmpr_cmt_ID IN ( 5 )
   AND (cmpr_format = 'htmlbody')
Rows: 1 – Time: 0.0004s (0.77%)

Query #70:

SELECT comment_item_ID, comment_type, comment_status, COUNT(*) AS type_count
  FROM evo_comments
  LEFT JOIN evo_items__item_settings as expiry_setting ON comment_item_ID = iset_item_ID
   AND iset_name = "comment_expiry_delay"
 WHERE ( comment_status IN ( 'published','community','protected','review','private','draft','deprecated' ) )
   AND (expiry_setting.iset_value IS NULL
    OR expiry_setting.iset_value = ""
    OR TIMESTAMPDIFF(SECOND, comment_date, '2018-08-16 21:54:43') < expiry_setting.iset_value)
   AND (comment_item_ID IN (169))
 GROUP BY comment_item_ID, comment_type, comment_status
Rows: 2 – Time: 0.0006s (1.14%)

Query #71: Record the hit

INSERT DELAYED INTO evo_hitlog ( hit_datetime, hit_uri, hit_disp, hit_ctrl, hit_action, hit_type, hit_referer_type, hit_referer, hit_referer_dom_ID, hit_keyphrase_keyp_ID, hit_keyphrase, hit_serprank, hit_coll_ID, hit_remote_addr, hit_agent_type, hit_agent_ID, hit_response_code, hit_method, hit_sess_ID )
VALUES ( FROM_UNIXTIME( 1534461883 ), '/index.php/test-post-on-front-page', 'single', '', '', 'standard', 'direct', '', NULL, NULL, '', NULL, '1', '54.224.220.72', 'unknown', NULL, '200', 'GET', '85745' )
Rows: 1 – Time: 0.0011s (2.29%)

Query #72: Session::dbsave()

UPDATE evo_sessions SET
        sess_lastseen_ts = FROM_UNIXTIME(1534461883),
        sess_data = 'a:2:{s:25:\"CommentList_filters_coll1\";a:2:{i:0;N;i:1;a:30:{s:13:\"filter_preset\";N;s:10:\"author_IDs\";N;s:6:\"author\";N;s:12:\"author_email\";N;s:10:\"author_url\";N;s:9:\"url_match\";s:1:\"=\";s:16:\"include_emptyurl\";N;s:9:\"author_IP\";N;s:7:\"post_ID\";s:3:\"169\";s:10:\"comment_ID\";N;s:15:\"comment_ID_list\";N;s:13:\"rating_toshow\";N;s:11:\"rating_turn\";s:5:\"above\";s:12:\"rating_limit\";i:1;s:8:\"keywords\";N;s:6:\"phrase\";s:3:\"AND\";s:5:\"exact\";i:0;s:8:\"statuses\";a:5:{i:0;s:9:\"published\";i:1;s:9:\"community\";i:2;s:9:\"protected\";i:3;s:7:\"private\";i:4;s:6:\"review\";}s:15:\"expiry_statuses\";a:1:{i:0;s:6:\"active\";}s:5:\"types\";a:2:{i:0;s:7:\"comment\";i:1;s:8:\"pingback\";}s:7:\"orderby\";s:4:\"date\";s:5:\"order\";s:3:\"ASC\";s:8:\"comments\";i:1000;s:4:\"page\";i:1;s:8:\"featured\";N;s:13:\"timestamp_min\";N;s:13:\"timestamp_max\";N;s:17:\"threaded_comments\";s:1:\"0\";s:9:\"user_perm\";N;s:5:\"limit\";i:1000;}}s:38:\"CommentList_filters_coll1_refresh_time\";a:2:{i:0;N;i:1;d:1534460400;}}',
        sess_ipaddress = '54.224.220.72',
        sess_key = 'oBiqOlsOGzEzl8iA9LNSkChXObzZ9Bqc'
 WHERE sess_ID = 85745
Rows: 1 – Time: 0.0003s (0.63%)

Total rows: 935
Measured time: 0.0497s
Profiled time: 0.0000s