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.041 seconds   scroll down to details

Timers
CategoryTime%Count
total0.120100.00%1
first_flush0.11999.17%1
_MAIN.inc0.01915.83%1
_init_db0.0097.50%1
SQL QUERIES0.04134.17%62
abstractsettings_GeneralSettings_get0.0021.67%129
init modules0.0032.50%1
plugin_init0.0032.50%2
_init_hit0.0032.50%2
_init_session0.0021.67%2
index.php0.0021.67%1
_BLOG_MAIN.inc0.0032.50%1
convert_charset0.0032.50%2303
abstractsettings_CollectionSettings_get0.0065.00%513
SKIN DISPLAY0.09478.33%1
PageCache0.0054.17%1
Read cache file0.0054.17%1
Cache file processing0.09075.00%1
skin_include(_html_header.inc.php)0.01411.67%1
plugins_register0.0032.50%9
wikitables_plugin_(#28)0.0021.67%1
skin_include(_body_header.inc.php)0.02420.00%1
siteskin_include(_site_body_header.inc.php)0.02016.67%1
skin_container(Menu)0.0043.33%1
Widget->display(coll_page_list)0.0032.50%1
skin_include($disp$)0.0032.50%1
archives_plugin_(#6)0.0021.67%1
skin_include(_sidebar.inc.php)0.03831.67%1
skin_container(Sidebar)0.02016.67%1
Widget->display(coll_media_index)0.01310.83%1
Widget->display(coll_post_list)0.0086.67%1
skin_container(Sidebar 2)0.01815.00%1
Widget->display(coll_comment_list)0.0108.33%1
+ 30 queries < 1%
Opcode cache: OPCache

User cache: none

Memory usage: 17 MB
Memory peak usage: 17 MB
Len of serialized $cache_imgsize: 1097
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: 3018 min 51 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.167.47.248
  • 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): 186002
  • 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.0009)
  •             _init_db resumed at 0.000
  •             _init_db paused at 0.009 (+0.0089)
  •             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.0012)
  •             _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.0028)
  •             _init_session resumed at 0.000
  •                 _init_session__new resumed at 0.000
  •                 _init_session__new paused at 0.001 (+0.0014)
  •                 _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.0017)
  •             _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.019 (+0.0192)
  •         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.003 (+0.0031)
  •         SKIN DISPLAY resumed at 0.000
  •             PageCache resumed at 0.000
  •                 Read cache file resumed at 0.000
  •                 Read cache file paused at 0.005 (+0.0049)
  •                 Cache file processing resumed at 0.000
  •                 PageCache paused at 0.005 (+0.0052)
  •                 skin_init resumed at 0.000
  •                 skin_init paused at 0.001 (+0.0008)
  •                 Skin:display_init resumed at 0.000
  •                 Skin:display_init paused at 0.001 (+0.0015)
  •                 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.0002)
  •                     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.0005)
  •                     wikitables_plugin_(#28) resumed at 0.000
  •                         plugin_init resumed at 0.001
  •                         plugin_init paused at 0.003 (+0.0018)
  •                     wikitables_plugin_(#28) paused at 0.002 (+0.0023)
  •                     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.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.0005)
  •                     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.014 (+0.0143)
  •                 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.020 (+0.0201)
  •                     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.0002)
  •                     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.0001)
  •                         Widget->display(coll_page_list) resumed at 0.000
  •                         Widget->display(coll_page_list) paused at 0.003 (+0.0029)
  •                         Widget->display(basic_menu_link) resumed at 0.000
  •                         Widget->display(basic_menu_link) paused at 0.000 (+0.0002)
  •                         Widget->display(basic_menu_link) resumed at 0.000
  •                         Widget->display(basic_menu_link) paused at 0.000 (+0.0001)
  •                         Widget->display(basic_menu_link) resumed at 0.000
  •                         Widget->display(basic_menu_link) paused at 0.000 (+0.0001)
  •                     skin_container(Menu) paused at 0.004 (+0.0036)
  •                 skin_include(_body_header.inc.php) paused at 0.024 (+0.0241)
  •                 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.0017)
  •                 skin_include($disp$) paused at 0.003 (+0.0031)
  •                 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.013 (+0.0126)
  •                         Widget->display(coll_post_list) resumed at 0.000
  •                         Widget->display(coll_post_list) paused at 0.007 (+0.0069)
  •                     skin_container(Sidebar) paused at 0.020 (+0.0201)
  •                     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.008 (+0.0079)
  •                         Widget->display(coll_comment_list) resumed at 0.000
  •                             plugins_register resumed at 0.002
  •                             plugins_register paused at 0.003 (+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.0008)
  • 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.010 (+0.0096)
  •                     skin_container(Sidebar 2) paused at 0.018 (+0.0176)
  •                 skin_include(_sidebar.inc.php) paused at 0.038 (+0.0378)
  •                 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.005 (+0.0937)
  • Warning: tried to pause already paused 'PageCache'.
  •         SKIN DISPLAY paused at 0.094 (+0.0937)
  •         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.0002s (0.47%)

Query #2: Load settings from T_settings

SELECT set_name, set_value
  FROM evo_settings
Rows: 67 – Time: 0.0013s (3.05%)

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 (2.11%)

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.0006s (1.39%)

Query #5:

INSERT INTO evo_sessions( sess_key, sess_start_ts, sess_lastseen_ts, sess_ipaddress, sess_device )
VALUES (
          'nrerWAwAjFn0D15D1kbXCfAjuHyx7ksF',
          FROM_UNIXTIME(1558565268),
          FROM_UNIXTIME(1558565268),
          '54.167.47.248',
          ''
        )
Rows: 1 – Time: 0.0005s (1.21%)

Query #6:

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

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.0006s (1.51%)

Query #8: DataObjectCache::get_by_ID()

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

Query #9: Load settings from T_global__cache

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

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.0005s (1.21%)

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.0033s (7.94%)

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

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.0018s (4.39%)

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.0024s (5.90%)

Query #15: Loading ItemType(ALL) into cache

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

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.0018s (4.39%)

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.0006s (1.50%)

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 <= '2019-05-23 00:47')
   AND (( cat_blog_ID IN ( 1 )
   AND ( ( post_status IN ( 'published' ) ) ) ))
Rows: 1 – Time: 0.0006s (1.49%)

Query #19: DataObjectCache::get_by_ID()

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

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.68%)

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

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

Query #23: Loading ItemType(ALL) into cache

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

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.0003s (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 <= '2019-05-23 00:47')
   AND (( cat_blog_ID IN ( 1 )
   AND ( ( post_status IN ( 'published' ) ) ) ))
Rows: 1 – Time: 0.0004s (0.98%)

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.0005s (1.26%)

Query #27: Loading ItemType(ALL) into cache

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

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 (1.00%)

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 <= '2019-05-23 00:47')
   AND ( ( ( post_status IN ( 'published' ) ) ) )
Rows: 1 – Time: 0.0004s (0.98%)

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 <= '2019-05-23 00:47')
   AND (ityp_usage IN ( 'post' ))
 GROUP BY year, month
 ORDER BY year DESC, month DESC
Rows: 2 – Time: 0.0012s (2.78%)

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 <= '2019-05-23 00:47')
   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.0031s (7.35%)

Query #32: Loading Chapter(ALL) into cache

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

Query #33: Loading Filetype(ALL) into cache

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

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.0004s (1.02%)

Query #35: Loading ItemType(ALL) into cache

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

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.0004s (0.90%)

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 <= '2019-05-23 00:47')
   AND ( ( ( post_status IN ( 'published' ) ) ) )
Rows: 1 – Time: 0.0007s (1.67%)

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 <= '2019-05-23 00:47')
   AND ( ( ( post_status IN ( 'published' ) ) ) )
 ORDER BY post_datestart DESC, post_ID DESC
 LIMIT 100
Rows: 39 – Time: 0.0013s (3.15%)

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.87%)

Query #40: Loading ItemType(ALL) into cache

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

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.0004s (0.86%)

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 <= '2019-05-23 00:47')
   AND ( ( ( post_status IN ( 'published' ) ) ) )
Rows: 1 – Time: 0.0008s (1.86%)

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 <= '2019-05-23 00:47')
   AND ( ( ( post_status IN ( 'published' ) ) ) )
 ORDER BY RAND() DESC, post_ID DESC
 LIMIT 10
Rows: 10 – Time: 0.0013s (3.13%)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Query #53: 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.49%)

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, '2019-05-23 00:47:48') < expiry_setting.iset_value)
Rows: 1 – Time: 0.0011s (2.54%)

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, '2019-05-23 00:47:48') < expiry_setting.iset_value)
 ORDER BY comment_date DESC, comment_ID DESC
 LIMIT 20
Rows: 3 – Time: 0.0005s (1.14%)

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.87%)

Query #57: DataObjectCache::get_by_ID()

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

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.82%)

Query #59: Loading Group(ALL) into cache

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

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.0004s (1.00%)

Query #61: DataObjectCache::get_by_ID()

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

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( 1558565268 ), '/index.php/camino/?disp=arcdir', 'arcdir', '', '', 'standard', 'direct', '', NULL, NULL, '', NULL, '8', '54.167.47.248', 'unknown', NULL, '200', 'GET', '186002' )
Rows: 1 – Time: 0.0005s (1.15%)

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