Archive Directory

AJAX Debug log
Clear

Debug info

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

Timers
CategoryTime%Count
total0.166100.00%1
first_flush0.166100.00%1
_MAIN.inc0.01710.24%1
_init_db0.0063.61%1
SQL QUERIES0.05432.53%62
abstractsettings_GeneralSettings_get0.0021.20%129
init modules0.0031.81%1
plugin_init0.0021.20%2
_init_hit0.0031.81%2
_init_session0.0021.20%2
index.php0.0021.20%1
_BLOG_MAIN.inc0.0053.01%1
convert_charset0.0053.01%2303
abstractsettings_CollectionSettings_get0.0063.61%513
SKIN DISPLAY0.13681.93%1
PageCache0.01810.84%1
Read cache file0.01810.84%1
Cache file processing0.12474.70%1
skin_init0.0021.20%1
abstractsettings_AbstractSettings_get0.0021.20%2
skin_include(_html_header.inc.php)0.0074.22%1
plugins_register0.0021.20%9
wikitables_plugin_(#28)0.0021.20%1
skin_include(_body_header.inc.php)0.02313.86%1
siteskin_include(_site_body_header.inc.php)0.01810.84%1
skin_container(Menu)0.0042.41%1
Widget->display(coll_page_list)0.0031.81%1
skin_include($disp$)0.0106.02%1
archives_plugin_(#6)0.0021.20%1
skin_include(_sidebar.inc.php)0.06237.35%1
skin_container(Sidebar)0.03722.29%1
Widget->display(coll_media_index)0.02816.87%1
Widget->display(coll_post_list)0.0137.83%1
skin_container(Sidebar 2)0.02414.46%1
Widget->display(coll_comment_list)0.0116.63%1
shutdown0.0063.61%1
+ 27 queries < 1%
Opcode cache: OPCache

User cache: none

Memory usage: 17 MB
Memory peak usage: 17 MB
Len of serialized $cache_imgsize: 1102
Len of serialized $cache_File: 2

Debug messages

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

detectblog:

  • No blog param received, checking extra path...
  • Found a potential URL collection name: camino (in: http://www.ourspiritwalk.com/index.php/camino/)
  • Found matching blog: 8

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: "Front Page"
  • 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

pagecache:

  • URL being cached: http://www.ourspiritwalk.com/index.php/camino/?disp=arcdir
  • Cache file: /var/www/jankirk.net/public_html/ourspiritwalk/_cache/c8/bd00a55e347a101319b547c2d677576c.page
  • Retrieving from cache!
  • Cache age: 6291 min 49 sec
  • Collecting started
  • Cache updated!

request:

  • vars: vars: Getting ReqURI from REQUEST_URI
  • vars: $ReqHost: http://www.ourspiritwalk.com
  • vars: $ReqURI: /index.php/camino/?disp=arcdir
  • vars: $ReqPath: /index.php/camino/
  • Hit: IP: 54.92.193.89
  • 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): 108506
  • Session: Cookie sent.
  • Transaction name: Camino:arcdir
  • Hit: Recording the hit.
  • Hit:detect_useragent(): Agent name:
  • Hit:detect_useragent(): Agent platform:
  • Session: Session is up to date and does not need to be saved.

skins:

  • Selected skin: business_skin
  • blog_main: include skins/business_skin/index.main.php (default handler)
  • skin_init: $disp=arcdir
  • skin_init: $disp=arcdir / $disp_detail=arcdir / $seo_page_type=Date archive directory
  • skin_include (-): /var/www/jankirk.net/public_html/ourspiritwalk/skins_fallback_v6/_html_header.inc.php
  • siteskin_include: skins_site/_skin_init.inc.php
  • skin_include (-): /var/www/jankirk.net/public_html/ourspiritwalk/skins/business_skin/_body_header.inc.php
  • siteskin_include: skins_site/_site_body_header.inc.php
  • skin_include (-): /var/www/jankirk.net/public_html/ourspiritwalk/skins/business_skin/_arcdir.disp.php
  • skin_include (-): /var/www/jankirk.net/public_html/ourspiritwalk/skins/business_skin/_sidebar.inc.php
  • skin_include (-): /var/www/jankirk.net/public_html/ourspiritwalk/skins/business_skin/_body_footer.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.0012)
  •             _init_db resumed at 0.000
  •             _init_db paused at 0.006 (+0.0060)
  •             init modules resumed at 0.000
  •             init modules paused at 0.003 (+0.0026)
  •             plugin_init resumed at 0.000
  •             plugin_init paused at 0.001 (+0.0013)
  •             _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.003 (+0.0030)
  •             _init_session resumed at 0.000
  •                 _init_session__new resumed at 0.000
  •                 _init_session__new paused at 0.001 (+0.0013)
  •                 _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.002 (+0.0016)
  •             _init_login resumed at 0.000
  •             _init_login paused at 0.000 (+0.0003)
  •             _init_session resumed at 0.002
  •                 _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.002 (+0.0000)
  •             _init_hit resumed at 0.003
  •             _init_hit paused at 0.003 (+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.017 (+0.0168)
  •         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.002 (+0.0016)
  •         _BLOG_MAIN.inc resumed at 0.000
  •         _BLOG_MAIN.inc paused at 0.005 (+0.0045)
  •         SKIN DISPLAY resumed at 0.000
  •             PageCache resumed at 0.000
  •                 Read cache file resumed at 0.000
  •                 Read cache file paused at 0.018 (+0.0178)
  •                 Cache file processing resumed at 0.000
  •                 PageCache paused at 0.018 (+0.0181)
  •                 skin_init resumed at 0.000
  •                 skin_init paused at 0.002 (+0.0016)
  •                 Skin:display_init resumed at 0.000
  •                 Skin:display_init paused at 0.001 (+0.0011)
  •                 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.000 (+0.0005)
  •                     tinymce_plugin_(#10) resumed at 0.000
  •                     tinymce_plugin_(#10) paused at 0.000 (+0.0000)
  •                     plugins_register resumed at 0.000
  •                     plugins_register paused at 0.001 (+0.0004)
  •                     wikitables_plugin_(#28) resumed at 0.000
  •                         plugin_init resumed at 0.001
  •                         plugin_init paused at 0.002 (+0.0011)
  •                     wikitables_plugin_(#28) paused at 0.002 (+0.0015)
  •                     plugins_register resumed at 0.001
  •                     plugins_register paused at 0.001 (+0.0003)
  •                     twitter_plugin_(#11) resumed at 0.000
  •                     twitter_plugin_(#11) paused at 0.000 (+0.0001)
  •                     plugins_register resumed at 0.001
  •                     plugins_register paused at 0.001 (+0.0002)
  •                     flowplayer_plugin_(#12) resumed at 0.000
  •                     flowplayer_plugin_(#12) paused at 0.000 (+0.0002)
  •                     plugins_register resumed at 0.001
  •                     plugins_register paused at 0.002 (+0.0002)
  •                     html5_mediaelementjs_plugin_(#16) resumed at 0.000
  •                     html5_mediaelementjs_plugin_(#16) paused at 0.000 (+0.0003)
  •                     plugins_register resumed at 0.002
  •                     plugins_register paused at 0.002 (+0.0001)
  •                     html5_videojs_plugin_(#17) resumed at 0.000
  •                     html5_videojs_plugin_(#17) paused at 0.000 (+0.0001)
  •                     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.007 (+0.0073)
  •                 skin_include(_body_header.inc.php) resumed at 0.000
  •                     siteskin_include(_site_body_header.inc.php) resumed at 0.000
  •                         Blog constructor resumed at 0.000
  •                         Blog constructor paused at 0.000 (+0.0000)
  •                     siteskin_include(_site_body_header.inc.php) paused at 0.018 (+0.0180)
  •                     skin_container(Header) resumed at 0.000
  •                         Widget->display(coll_title) resumed at 0.000
  •                         Widget->display(coll_title) paused at 0.000 (+0.0001)
  •                         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.0003)
  •                     skin_container(Menu) resumed at 0.000
  •                         Widget->display(basic_menu_link) resumed at 0.000
  •                         Widget->display(basic_menu_link) paused at 0.000 (+0.0002)
  •                         Widget->display(coll_page_list) resumed at 0.000
  •                         Widget->display(coll_page_list) paused at 0.003 (+0.0030)
  •                         Widget->display(basic_menu_link) resumed at 0.000
  •                         Widget->display(basic_menu_link) paused at 0.000 (+0.0003)
  •                         Widget->display(basic_menu_link) resumed at 0.000
  •                         Widget->display(basic_menu_link) paused at 0.000 (+0.0003)
  •                         Widget->display(basic_menu_link) resumed at 0.000
  •                         Widget->display(basic_menu_link) paused at 0.000 (+0.0003)
  •                     skin_container(Menu) paused at 0.004 (+0.0043)
  •                 skin_include(_body_header.inc.php) paused at 0.023 (+0.0226)
  •                 skin_include($disp$) resumed at 0.000
  •                     plugins_register resumed at 0.002
  •                     plugins_register paused at 0.002 (+0.0002)
  •                     archives_plugin_(#6) resumed at 0.000
  •                     archives_plugin_(#6) paused at 0.002 (+0.0022)
  •                 skin_include($disp$) paused at 0.010 (+0.0102)
  •                 skin_include(_sidebar.inc.php) resumed at 0.000
  •                     skin_container(Sidebar) resumed at 0.000
  •                         Widget->display(coll_media_index) resumed at 0.000
  •                         Widget->display(coll_media_index) paused at 0.028 (+0.0282)
  •                         Widget->display(coll_post_list) resumed at 0.000
  •                         Widget->display(coll_post_list) paused at 0.008 (+0.0084)
  •                     skin_container(Sidebar) paused at 0.037 (+0.0371)
  •                     skin_container(Sidebar 2) resumed at 0.000
  •                         Widget->display(coll_post_list) resumed at 0.000
  •                         Widget->display(coll_post_list) paused at 0.013 (+0.0131)
  •                         Widget->display(coll_comment_list) resumed at 0.000
  •                             plugins_register resumed at 0.002
  •                             plugins_register paused at 0.002 (+0.0002)
  •                             basic_antispam_plugin_(#14) resumed at 0.000
  •                             basic_antispam_plugin_(#14) paused at 0.000 (+0.0000)
  •                             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.0002)
  •                             basic_antispam_plugin_(#14) paused at 0.000 (+0.0013)
  • Warning: tried to pause already paused 'basic_antispam_plugin_(#14)'.
  •                             basic_antispam_plugin_(#14) resumed at 0.000
  •                             basic_antispam_plugin_(#14) paused at 0.000 (+0.0001)
  •                         Widget->display(coll_comment_list) paused at 0.011 (+0.0111)
  •                     skin_container(Sidebar 2) paused at 0.024 (+0.0243)
  •                 skin_include(_sidebar.inc.php) paused at 0.062 (+0.0616)
  •                 skin_include(_body_footer.inc.php) resumed at 0.000
  •                     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(_body_footer.inc.php) paused at 0.001 (+0.0006)
  •                 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.018 (+0.1364)
  • Warning: tried to pause already paused 'PageCache'.
  •         SKIN DISPLAY paused at 0.136 (+0.1365)
  •         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: 62

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.0003s (0.49%)

Query #2: Load settings from T_settings

SELECT set_name, set_value
  FROM evo_settings
Rows: 67 – Time: 0.0010s (1.93%)

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.0012s (2.16%)

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.0014s (2.61%)

Query #5:

INSERT INTO evo_sessions( sess_key, sess_start_ts, sess_lastseen_ts, sess_ipaddress, sess_device )
VALUES (
          'jBnIQqUnkGmXDqSbXHUgX4uX1R7Bmwbk',
          FROM_UNIXTIME(1542161276),
          FROM_UNIXTIME(1542161276),
          '54.92.193.89',
          ''
        )
Rows: 1 – Time: 0.0006s (1.13%)

Query #6:

SELECT *
  FROM evo_blogs
 WHERE blog_urlname = 'camino'
Rows: 1 – Time: 0.0006s (1.15%)

Query #7: 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.0022s (3.99%)

Query #8: DataObjectCache::get_by_ID()

SELECT *
  FROM evo_skins__skin
 WHERE (skin_ID = '12')
 ORDER BY skin_name
Rows: 1 – Time: 0.0006s (1.19%)

Query #9: Load settings from T_global__cache

SELECT cach_name, cach_cache
  FROM evo_global__cache
Rows: 7 – Time: 0.0013s (2.43%)

Query #10: Get list of widgets for collection

SELECT *
  FROM evo_widget
 WHERE wi_coll_ID = 8
   AND wi_enabled = 1
 ORDER BY wi_sco_name, wi_order
Rows: 38 – Time: 0.0008s (1.52%)

Query #11: 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.0006s (1.07%)

Query #12: 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.43%)

Query #13: 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.0004s (0.75%)

Query #14: 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.0006s (1.19%)

Query #15: Loading ItemType(ALL) into cache

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

Query #16: 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.91%)

Query #17: 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.0008s (1.40%)

Query #18: 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-11-14 03:07')
   AND (( cat_blog_ID IN ( 1 )
   AND ( ( post_status IN ( 'published' ) ) ) ))
Rows: 1 – Time: 0.0027s (4.97%)

Query #19: DataObjectCache::get_by_ID()

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

Query #20: 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.0003s (0.53%)

Query #21: 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.83%)

Query #22: 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.0005s (0.85%)

Query #23: Loading ItemType(ALL) into cache

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

Query #24: 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.82%)

Query #25: 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-11-14 03:07')
   AND (( cat_blog_ID IN ( 1 )
   AND ( ( post_status IN ( 'published' ) ) ) ))
Rows: 1 – Time: 0.0004s (0.71%)

Query #26: 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.80%)

Query #27: Loading ItemType(ALL) into cache

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

Query #28: 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 = '8')
Rows: 6 – Time: 0.0004s (0.79%)

Query #29: 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 = 8 )
   AND (ityp_usage IN ( 'page' ))
   AND (post_datestart <= '2018-11-14 03:07')
   AND ( ( ( post_status IN ( 'published' ) ) ) )
Rows: 1 – Time: 0.0005s (0.87%)

Query #30: Results::run_query()

SELECT SQL_CALC_FOUND_ROWS EXTRACT(YEAR
  FROM post_datestart) AS year, EXTRACT(MONTH
  FROM post_datestart) AS month,
                                  COUNT(DISTINCT postcat_post_ID) AS count
  FROM evo_items__item
 INNER JOIN evo_postcats ON post_ID = postcat_post_ID
 INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
  LEFT JOIN evo_items__type ON ityp_ID = post_ityp_ID
 WHERE ( cat_blog_ID = 8 )
   AND ( ( ( post_status IN ( 'published' ) ) ) )
   AND (post_datestart <= '2018-11-14 03:07')
   AND (ityp_usage IN ( 'post' ))
 GROUP BY year, month
 ORDER BY year DESC, month DESC
Rows: 2 – Time: 0.0016s (2.88%)

Query #31: Media index widget

SELECT post_ID, post_datestart, post_datemodified, post_main_cat_ID, post_urltitle, post_canonical_slug_ID,
                  post_tiny_slug_ID, post_ityp_ID, post_title, post_excerpt, post_url, file_ID, file_creator_user_ID, file_type,
                  file_title, file_root_type, file_root_ID, file_path, file_alt, file_desc, file_path_hash
  FROM evo_items__item
 INNER JOIN evo_links ON post_ID = link_itm_ID
 INNER JOIN evo_files ON link_file_ID = file_ID
 INNER JOIN evo_postcats ON post_ID = postcat_post_ID
 INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
 WHERE ( cat_blog_ID = 8 )
   AND ( ( ( post_status IN ( 'published' ) ) ) )
   AND (( file_type = "image" )
    OR ( file_type IS NULL ))
   AND (post_datestart <= '2018-11-14 03:07')
   AND (link_position != "cover")
   AND (post_ityp_ID = 1)
 GROUP BY link_ID
 ORDER BY RAND() ASC, post_ID ASC, link_ID ASC
 LIMIT 8
Rows: 8 – Time: 0.0057s (10.57%)

Query #32: Loading Chapter(ALL) into cache

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

Query #33: Loading Filetype(ALL) into cache

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

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

SELECT *
  FROM evo_items__type
 WHERE ityp_usage = "post"
 ORDER BY ityp_ID
Rows: 8 – Time: 0.0007s (1.27%)

Query #35: Loading ItemType(ALL) into cache

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

Query #36: 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 = '8')
Rows: 6 – Time: 0.0005s (0.86%)

Query #37: coll_post_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 = 8 )
   AND (ityp_usage IN ( 'post' ))
   AND (post_datestart <= '2018-11-14 03:07')
   AND ( ( ( post_status IN ( 'published' ) ) ) )
Rows: 1 – Time: 0.0009s (1.60%)

Query #38: coll_post_list_Widget - ItemListLight::query()

SELECT DISTINCT post_ID, post_datestart, post_datemodified, post_title, post_url,
                  post_excerpt, post_urltitle, post_canonical_slug_ID, post_tiny_slug_ID, post_main_cat_ID, post_ityp_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 = 8 )
   AND (ityp_usage IN ( 'post' ))
   AND (post_datestart <= '2018-11-14 03:07')
   AND ( ( ( post_status IN ( 'published' ) ) ) )
 ORDER BY post_datestart DESC, post_ID DESC
 LIMIT 100
Rows: 39 – Time: 0.0015s (2.70%)

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

SELECT *
  FROM evo_items__type
 WHERE ityp_usage = "post"
 ORDER BY ityp_ID
Rows: 8 – Time: 0.0004s (0.66%)

Query #40: Loading ItemType(ALL) into cache

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

Query #41: 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 = '8')
Rows: 6 – Time: 0.0005s (0.85%)

Query #42: coll_post_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 = 8 )
   AND (ityp_usage IN ( 'post' ))
   AND (post_datestart <= '2018-11-14 03:07')
   AND ( ( ( post_status IN ( 'published' ) ) ) )
Rows: 1 – Time: 0.0008s (1.52%)

Query #43: coll_post_list_Widget - ItemListLight::query()

SELECT DISTINCT post_ID, post_datestart, post_datemodified, post_title, post_url,
                  post_excerpt, post_urltitle, post_canonical_slug_ID, post_tiny_slug_ID, post_main_cat_ID, post_ityp_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 = 8 )
   AND (ityp_usage IN ( 'post' ))
   AND (post_datestart <= '2018-11-14 03:07')
   AND ( ( ( post_status IN ( 'published' ) ) ) )
 ORDER BY RAND() DESC, post_ID DESC
 LIMIT 10
Rows: 10 – Time: 0.0013s (2.47%)

Query #44: Get category associations with given item #142

SELECT postcat_cat_ID
  FROM evo_postcats
 WHERE postcat_post_ID = '142'
 ORDER BY postcat_cat_ID
Rows: 1 – Time: 0.0004s (0.65%)

Query #45: Get category associations with given item #112

SELECT postcat_cat_ID
  FROM evo_postcats
 WHERE postcat_post_ID = '112'
 ORDER BY postcat_cat_ID
Rows: 1 – Time: 0.0002s (0.46%)

Query #46: Get category associations with given item #127

SELECT postcat_cat_ID
  FROM evo_postcats
 WHERE postcat_post_ID = '127'
 ORDER BY postcat_cat_ID
Rows: 1 – Time: 0.0002s (0.32%)

Query #47: Get category associations with given item #119

SELECT postcat_cat_ID
  FROM evo_postcats
 WHERE postcat_post_ID = '119'
 ORDER BY postcat_cat_ID
Rows: 1 – Time: 0.0003s (0.47%)

Query #48: Get category associations with given item #126

SELECT postcat_cat_ID
  FROM evo_postcats
 WHERE postcat_post_ID = '126'
 ORDER BY postcat_cat_ID
Rows: 1 – Time: 0.0002s (0.42%)

Query #49: Get category associations with given item #110

SELECT postcat_cat_ID
  FROM evo_postcats
 WHERE postcat_post_ID = '110'
 ORDER BY postcat_cat_ID
Rows: 1 – Time: 0.0002s (0.36%)

Query #50: Get category associations with given item #102

SELECT postcat_cat_ID
  FROM evo_postcats
 WHERE postcat_post_ID = '102'
 ORDER BY postcat_cat_ID
Rows: 1 – Time: 0.0023s (4.29%)

Query #51: Get category associations with given item #128

SELECT postcat_cat_ID
  FROM evo_postcats
 WHERE postcat_post_ID = '128'
 ORDER BY postcat_cat_ID
Rows: 1 – Time: 0.0029s (5.30%)

Query #52: Get category associations with given item #138

SELECT postcat_cat_ID
  FROM evo_postcats
 WHERE postcat_post_ID = '138'
 ORDER BY postcat_cat_ID
Rows: 1 – Time: 0.0002s (0.41%)

Query #53: Get category associations with given item #131

SELECT postcat_cat_ID
  FROM evo_postcats
 WHERE postcat_post_ID = '131'
 ORDER BY postcat_cat_ID
Rows: 1 – Time: 0.0002s (0.41%)

Query #54: 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','trackback','pingback'))
   AND (comment_item_ID IN (
SELECT DISTINCT post_ID
  FROM evo_items__item
 INNER JOIN evo_postcats ON post_ID = postcat_post_ID
 INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
 WHERE ( cat_blog_ID = 8 )
   AND ( ( ( post_status IN ( 'published' ) ) ) ) ))
   AND (expiry_setting.iset_value IS NULL
    OR expiry_setting.iset_value = ""
    OR TIMESTAMPDIFF(SECOND, comment_date, '2018-11-14 03:07:56') < expiry_setting.iset_value)
Rows: 1 – Time: 0.0009s (1.76%)

Query #55: 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','trackback','pingback'))
   AND (comment_item_ID IN (
SELECT DISTINCT post_ID
  FROM evo_items__item
 INNER JOIN evo_postcats ON post_ID = postcat_post_ID
 INNER JOIN evo_categories ON postcat_cat_ID = cat_ID
 WHERE ( cat_blog_ID = 8 )
   AND ( ( ( post_status IN ( 'published' ) ) ) ) ))
   AND (expiry_setting.iset_value IS NULL
    OR expiry_setting.iset_value = ""
    OR TIMESTAMPDIFF(SECOND, comment_date, '2018-11-14 03:07:56') < expiry_setting.iset_value)
 ORDER BY comment_date DESC, comment_ID DESC
 LIMIT 20
Rows: 3 – Time: 0.0005s (0.85%)

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

SELECT *
  FROM evo_comments
 WHERE comment_ID IN (3,2,1)
 ORDER BY comment_date DESC, comment_ID DESC
Rows: 3 – Time: 0.0004s (0.72%)

Query #57: DataObjectCache::get_by_ID()

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

Query #58: DataObjectCache::get_by_ID()

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

Query #59: Loading Group(ALL) into cache

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

Query #60: 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.0009s (1.62%)

Query #61: DataObjectCache::get_by_ID()

SELECT *
  FROM evo_users
 WHERE (user_ID = '10')
 ORDER BY user_ID
Rows: 1 – Time: 0.0003s (0.60%)

Query #62: 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( 1542161276 ), '/index.php/camino/?disp=arcdir', 'arcdir', '', '', 'standard', 'direct', '', NULL, NULL, '', NULL, '8', '54.92.193.89', 'unknown', NULL, '200', 'GET', '108506' )
Rows: 1 – Time: 0.0050s (9.28%)

Total rows: 1011
Measured time: 0.0540s
Profiled time: 0.0000s