Page Time: 0.2167s

Memory: 46.4481 MB (Peak: 47.4829 MB)

Queries (15, time: 0.0056s, 2.6%)

  1. SELECT `xf_dbtech_security_session`.*
FROM `xf_dbtech_security_session`

WHERE (`xf_dbtech_security_session`.`session_id` = '080c5938cadb7ace4bdc7092aab1aa95')


LIMIT 1
    Run Time: 0.000129
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_dbtech_security_sessionconstPRIMARYPRIMARY34const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
    4. XF\Mvc\Entity\Manager->find() in src/addons/DBTech/Security/Listener.php at line 94
    5. DBTech\Security\Listener::appPubStartEnd() in src/XF/Extension.php at line 81
    6. XF\Extension->fire() in src/XF/App.php at line 2992
    7. XF\App->fire() in src/XF/Pub/App.php at line 202
    8. XF\Pub\App->start() in src/XF/App.php at line 2481
    9. XF\App->run() in src/XF.php at line 524
    10. XF::runApp() in index.php at line 19
  2. SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000088
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
    4. XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
    5. XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1219
    6. XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 245
    7. XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
    8. XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
    9. XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
    10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    14. XF\App->run() in src/XF.php at line 524
    15. XF::runApp() in index.php at line 19
  3. SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_es_thread_similar_XFES_SimilarThreads_2`.*, `xf_forum_Forum_3`.*, `xf_node_Node_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_es_thread_similar` AS `xf_es_thread_similar_XFES_SimilarThreads_2` ON (`xf_es_thread_similar_XFES_SimilarThreads_2`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_4` ON (`xf_node_Node_4`.`node_id` = `xf_forum_Forum_3`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_5` ON (`xf_permission_cache_content_Permissions_5`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_5`.`content_id` = `xf_node_Node_4`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` = '316502')


LIMIT 1
    Run Time: 0.000388
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadconstPRIMARYPRIMARY4const1 
    SIMPLExf_user_User_1constPRIMARYPRIMARY4const1 
    SIMPLExf_es_thread_similar_XFES_SimilarThreads_2constPRIMARYPRIMARY4const1 
    SIMPLExf_forum_Forum_3constPRIMARYPRIMARY4const1 
    SIMPLExf_node_Node_4constPRIMARYPRIMARY4const1 
    SIMPLExf_permission_cache_content_Permissions_5constPRIMARYPRIMARY35const,const,const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
    4. XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Thread.php at line 1635
    5. XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 17
    6. XF\Pub\Controller\Thread->actionIndex() in src/addons/Justin/ThreadModal/XF/Pub/Controller/Thread.php at line 11
    7. Justin\ThreadModal\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Actions/XF/Pub/Controller/Thread.php at line 11
    8. Snog\Actions\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
    9. XFMG\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    14. XF\App->run() in src/XF.php at line 524
    15. XF::runApp() in index.php at line 19
  4. SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_permission_combination_PermissionCombination_5`.*, `xf_session_activity_Activity_6`.*
FROM `xf_post`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_4` ON (`xf_user_privacy_Privacy_4`.`user_id` = `xf_user_User_1`.`user_id`)
LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_5` ON (`xf_permission_combination_PermissionCombination_5`.`permission_combination_id` = `xf_user_User_1`.`permission_combination_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_6` ON (`xf_session_activity_Activity_6`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_6`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
WHERE (`xf_post`.`thread_id` = 316502) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20)
ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
    Run Time: 0.001247
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_postrangethread_id_post_date,thread_id_position,thread_id_score_datethread_id_position8 20Using index condition; Using where; Using filesort
    SIMPLExf_user_User_1eq_refPRIMARYPRIMARY4rokslide_xf.xf_post.user_id1 
    SIMPLExf_user_option_Option_2eq_refPRIMARYPRIMARY4rokslide_xf.xf_user_User_1.user_id1Using where
    SIMPLExf_user_profile_Profile_3eq_refPRIMARYPRIMARY4rokslide_xf.xf_user_User_1.user_id1Using where
    SIMPLExf_user_privacy_Privacy_4eq_refPRIMARYPRIMARY4rokslide_xf.xf_user_User_1.user_id1Using where
    SIMPLExf_permission_combination_PermissionCombination_5eq_refPRIMARYPRIMARY4rokslide_xf.xf_user_User_1.permission_combination_id1Using where
    SIMPLExf_session_activity_Activity_6eq_refPRIMARYPRIMARY22rokslide_xf.xf_user_User_1.user_id,func1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Thread.php at line 65
    4. XF\Pub\Controller\Thread->actionIndex() in src/addons/Justin/ThreadModal/XF/Pub/Controller/Thread.php at line 11
    5. Justin\ThreadModal\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Actions/XF/Pub/Controller/Thread.php at line 11
    6. Snog\Actions\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
    7. XFMG\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    12. XF\App->run() in src/XF.php at line 524
    13. XF::runApp() in index.php at line 19
  5. SELECT `xf_attachment`.*, `xf_attachment_data_Data_1`.*, `xf_mg_media_item_XfmgMirrorMedia_2`.*, `xf_mg_category_Category_3`.*, `xf_permission_cache_content_Permissions_4`.*
FROM `xf_attachment`
LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_1` ON (`xf_attachment_data_Data_1`.`data_id` = `xf_attachment`.`data_id`)
LEFT JOIN `xf_mg_media_item` AS `xf_mg_media_item_XfmgMirrorMedia_2` ON (`xf_mg_media_item_XfmgMirrorMedia_2`.`media_id` = `xf_attachment_data_Data_1`.`xfmg_mirror_media_id`)
LEFT JOIN `xf_mg_category` AS `xf_mg_category_Category_3` ON (`xf_mg_category_Category_3`.`category_id` = `xf_mg_media_item_XfmgMirrorMedia_2`.`category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'xfmg_category' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_mg_category_Category_3`.`category_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
WHERE (`xf_attachment`.`content_type` = 'post' AND `xf_attachment`.`content_id` IN (3154946))
ORDER BY `xf_attachment`.`attach_date` ASC
    Run Time: 0.000347
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using index condition; Using where
    SIMPLExf_attachment_data_Data_1eq_refPRIMARYPRIMARY4rokslide_xf.xf_attachment.data_id1 
    SIMPLExf_mg_media_item_XfmgMirrorMedia_2eq_refPRIMARYPRIMARY4rokslide_xf.xf_attachment_data_Data_1.xfmg_mirror_media_id1Using where
    SIMPLExf_mg_category_Category_3eq_refPRIMARYPRIMARY4rokslide_xf.xf_mg_media_item_XfmgMirrorMedia_2.category_id1Using where
    SIMPLExf_permission_cache_content_Permissions_4eq_refPRIMARYPRIMARY35const,const,rokslide_xf.xf_mg_category_Category_3.category_id1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Attachment.php at line 241
    4. XF\Repository\Attachment->addAttachmentsToContent() in src/XF/ControllerPlugin/Thread.php at line 46
    5. XF\ControllerPlugin\Thread->fetchExtraContentForPostsFullView() in src/XF/Pub/Controller/Thread.php at line 110
    6. XF\Pub\Controller\Thread->actionIndex() in src/addons/Justin/ThreadModal/XF/Pub/Controller/Thread.php at line 11
    7. Justin\ThreadModal\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Actions/XF/Pub/Controller/Thread.php at line 11
    8. Snog\Actions\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
    9. XFMG\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    10. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    11. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    12. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    13. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    14. XF\App->run() in src/XF.php at line 524
    15. XF::runApp() in index.php at line 19
  6. -- XFDB=noForceAllWrite
INSERT INTO xf_thread_view
	(thread_id, total)
VALUES
	(? , 1)
ON DUPLICATE KEY UPDATE
	total = total + 1
    Params: 316502
    Run Time: 0.000042

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Repository/Thread.php at line 194
    3. XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 141
    4. XF\Pub\Controller\Thread->actionIndex() in src/addons/Justin/ThreadModal/XF/Pub/Controller/Thread.php at line 11
    5. Justin\ThreadModal\XF\Pub\Controller\Thread->actionIndex() in src/addons/Snog/Actions/XF/Pub/Controller/Thread.php at line 11
    6. Snog\Actions\XF\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
    7. XFMG\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    12. XF\App->run() in src/XF.php at line 524
    13. XF::runApp() in index.php at line 19
  7. SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
    Params: 0,
    Run Time: 0.000053
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_session_activityconstPRIMARYPRIMARY22const,const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
    3. XF\Db\AbstractAdapter->fetchOne() in src/XF/Repository/SessionActivity.php at line 134
    4. XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
    5. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
    6. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
    7. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
    8. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    9. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    10. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    12. XF\App->run() in src/XF.php at line 524
    13. XF::runApp() in index.php at line 19
  8. -- XFDB=noForceAllWrite
UPDATE xf_session_activity
SET
	ip = ?,
	controller_name = ?,
	controller_action = ?,
	view_state = ?,
	params = ?,
	view_date = ?,
	robot_key = ?
WHERE user_id = ? AND unique_key = ?
    Params: , XF\Pub\Controller\Thread, Index, valid, thread_id=316502, 1731266526, , 0,
    Run Time: 0.000057

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 227
    3. XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 85
    4. XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 45
    5. XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 360
    6. XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 385
    7. XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
    8. XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
    9. XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
    10. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    11. XF\App->run() in src/XF.php at line 524
    12. XF::runApp() in index.php at line 19
  9. SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*, `xf_template_MasterTemplate_2`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
LEFT JOIN `xf_template` AS `xf_template_MasterTemplate_2` ON (`xf_template_MasterTemplate_2`.`style_id` = 0 AND `xf_template_MasterTemplate_2`.`type` = 'public' AND `xf_template_MasterTemplate_2`.`title` = CONCAT('_siropu_ads_manager_ad_code.', `xf_siropu_ads_manager_ad`.`ad_id`))
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('code', 'banner', 'text', 'link', 'popup', 'background')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY `xf_siropu_ads_manager_ad`.`display_order` ASC
    Run Time: 0.001018
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_siropu_ads_manager_adreftype,status,status_display_orderstatus_display_order102const45Using where
    SIMPLExf_siropu_ads_manager_package_Package_1eq_refPRIMARYPRIMARY4rokslide_xf.xf_siropu_ads_manager_ad.package_id1 
    SIMPLExf_template_MasterTemplate_2eq_reftype_title_style_idtype_title_style_id128const,func,const1Using where

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 501
    4. Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 336
    5. Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 327
    6. Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 38
    7. Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
    8. XF\Extension->fire() in src/XF/App.php at line 2992
    9. XF\App->fire() in src/XF/App.php at line 2210
    10. XF\App->getGlobalTemplateData() in src/XF/App.php at line 2079
    11. XF\App->preRender() in src/XF/Pub/App.php at line 451
    12. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
    13. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    15. XF\App->run() in src/XF.php at line 524
    16. XF::runApp() in index.php at line 19
  10. SELECT `xf_siropu_ads_manager_ad`.*, `xf_siropu_ads_manager_package_Package_1`.*
FROM `xf_siropu_ads_manager_ad`
LEFT JOIN `xf_siropu_ads_manager_package` AS `xf_siropu_ads_manager_package_Package_1` ON (`xf_siropu_ads_manager_package_Package_1`.`package_id` = `xf_siropu_ads_manager_ad`.`package_id`)
WHERE (`xf_siropu_ads_manager_ad`.`type` IN ('keyword', 'affiliate')) AND (`xf_siropu_ads_manager_ad`.`status` = 'active')
ORDER BY RAND() ASC
    Run Time: 0.000503
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_siropu_ads_manager_adrangetype,status,status_display_ordertype102 2Using index condition; Using where; Using temporary; Using filesort
    SIMPLExf_siropu_ads_manager_package_Package_1eq_refPRIMARYPRIMARY4rokslide_xf.xf_siropu_ads_manager_ad.package_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 606
    4. Siropu\AdsManager\Template\Ad->loadFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 340
    5. Siropu\AdsManager\Template\Ad->setFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 331
    6. Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 38
    7. Siropu\AdsManager\Listener::templaterGlobalData() in src/XF/Extension.php at line 81
    8. XF\Extension->fire() in src/XF/App.php at line 2992
    9. XF\App->fire() in src/XF/App.php at line 2210
    10. XF\App->getGlobalTemplateData() in src/XF/App.php at line 2079
    11. XF\App->preRender() in src/XF/Pub/App.php at line 451
    12. XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 397
    13. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    14. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    15. XF\App->run() in src/XF.php at line 524
    16. XF::runApp() in index.php at line 19
  11. SELECT `xf_session_activity`.*
FROM `xf_session_activity`

WHERE (`xf_session_activity`.`user_id` = 69759) AND (`xf_session_activity`.`unique_key` = '69759')


LIMIT 1
    Run Time: 0.000135
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
    4. XF\Mvc\Entity\Manager->find() in src/XF/Mvc/Entity/Manager.php at line 359
    5. XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 404
    6. XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 196
    7. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 119
    8. XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 313
    9. XF\Entity\User->getLastActivity() in src/XF/Mvc/Entity/Entity.php at line 167
    10. XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 119
    11. XF\Mvc\Entity\Entity->__get() in src/XF/Entity/User.php at line 522
    12. XF\Entity\User->canViewOnlineStatus() in src/XF/Entity/User.php at line 241
    13. XF\Entity\User->isOnline() in src/XF/Template/Templater.php at line 1195
    14. XF\Template\Templater->method() in internal_data/code_cache/templates/l1/s4/public/message_macros.php at line 15
    15. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    16. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s4/public/post_macros.php at line 25
    17. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 991
    18. XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 927
    19. XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l1/s4/public/post_macros.php at line 165
    20. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 991
    21. XF\Template\Templater->renderExtensionInternal() in src/XF/Template/Templater.php at line 927
    22. XF\Template\Templater->renderExtension() in internal_data/code_cache/templates/l1/s4/public/post_macros.php at line 206
    23. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 828
    24. XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s4/public/thread_view.php at line 821
    25. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
    26. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    27. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    28. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
    29. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
    30. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
    31. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    32. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    33. XF\App->run() in src/XF.php at line 524
    34. XF::runApp() in index.php at line 19
  12. SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*
FROM `xf_thread`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_thread`.`thread_id` IN (373375, 379355, 363160, 376964, 373385, 376780, 375448, 376230, 364318, 359574, 360478, 373903, 369847, 363983, 378875, 372426, 362934, 376676, 365446, 320564)) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect')
ORDER BY `xf_thread`.`thread_id` ASC
    Run Time: 0.000837
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangePRIMARYPRIMARY4 20Using where
    SIMPLExf_user_User_1eq_refPRIMARYPRIMARY4rokslide_xf.xf_thread.user_id1 
    SIMPLExf_forum_Forum_2eq_refPRIMARYPRIMARY4rokslide_xf.xf_thread.node_id1 
    SIMPLExf_node_Node_3eq_refPRIMARYPRIMARY4rokslide_xf.xf_forum_Forum_2.node_id1Using where
    SIMPLExf_permission_cache_content_Permissions_4eq_refPRIMARYPRIMARY35const,const,rokslide_xf.xf_node_Node_3.node_id1Using where
    SIMPLExf_user_LastPoster_5eq_refPRIMARYPRIMARY4rokslide_xf.xf_thread.last_post_user_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/addons/XFES/Widget/SimilarThreads.php at line 107
    4. XFES\Widget\SimilarThreads->render() in internal_data/code_cache/widgets/_22_xfes_thread_view_below_quick_reply_similar_threads.php at line 5
    5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
    6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1940
    8. XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s4/public/thread_view.php at line 986
    9. XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1655
    10. XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
    11. XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 50
    12. XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 460
    13. XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 442
    14. XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 402
    15. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    16. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    17. XF\App->run() in src/XF.php at line 524
    18. XF::runApp() in index.php at line 19
  13. SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_permission_cache_content_Permissions_4`.*, `xf_user_LastPoster_5`.*
FROM `xf_thread` FORCE INDEX (`last_post_date`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_4` ON (`xf_permission_cache_content_Permissions_4`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_4`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_4`.`permission_combination_id` = '1')
LEFT JOIN `xf_user` AS `xf_user_LastPoster_5` ON (`xf_user_LastPoster_5`.`user_id` = `xf_thread`.`last_post_user_id`)
WHERE (`xf_forum_Forum_1`.`find_new` = 1) AND (`xf_thread`.`discussion_state` = 'visible') AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`last_post_date` > 1728674526)
ORDER BY `xf_thread`.`last_post_date` DESC

LIMIT 10
    Run Time: 0.000599
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangelast_post_datelast_post_date4 6555Using where
    SIMPLExf_forum_Forum_1eq_refPRIMARYPRIMARY4rokslide_xf.xf_thread.node_id1Using where
    SIMPLExf_node_Node_2eq_refPRIMARYPRIMARY4rokslide_xf.xf_thread.node_id1 
    SIMPLExf_user_User_3eq_refPRIMARYPRIMARY4rokslide_xf.xf_thread.user_id1 
    SIMPLExf_permission_cache_content_Permissions_4eq_refPRIMARYPRIMARY35const,const,rokslide_xf.xf_node_Node_2.node_id1Using where
    SIMPLExf_user_LastPoster_5eq_refPRIMARYPRIMARY4rokslide_xf.xf_thread.last_post_user_id1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
    3. XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewPosts.php at line 89
    4. XF\Widget\NewPosts->render() in internal_data/code_cache/widgets/_7_forum_overview_new_posts.php at line 5
    5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
    6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1940
    8. XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 554
    9. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2283
    10. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    11. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    13. XF\App->run() in src/XF.php at line 524
    14. XF::runApp() in index.php at line 19
  14. SELECT `xf_andy_rss_feed`.*
FROM `xf_andy_rss_feed`


ORDER BY `xf_andy_rss_feed`.`rss_feed_id` ASC
    Run Time: 0.000090
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_andy_rss_feedindex PRIMARY4 10 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1474
    3. XF\Mvc\Entity\Finder->fetchRaw() in src/addons/Andy/RSSFeed/Widget/RSSFeed.php at line 36
    4. Andy\RSSFeed\Widget\RSSFeed->render() in internal_data/code_cache/widgets/_15_latest_articles.php at line 5
    5. XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 7729
    6. XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
    7. XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1940
    8. XF\Template\Templater->widgetPosition() in src/XF/Pub/App.php at line 555
    9. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2283
    10. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    11. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    12. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    13. XF\App->run() in src/XF.php at line 524
    14. XF::runApp() in index.php at line 19
  15. SELECT `xf_addon`.*
FROM `xf_addon`

WHERE (`xf_addon`.`addon_id` = 'Tapatalk')


LIMIT 1
    Run Time: 0.000073
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_addonconstPRIMARYPRIMARY52const1 

    1. XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
    2. XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1397
    3. XF\Mvc\Entity\Finder->fetchOne() in src/addons/Tapatalk/Listener/Hook.php at line 22
    4. Tapatalk\Listener\Hook::templateHook() in src/XF/Extension.php at line 49
    5. XF\Extension->fire() in src/XF/App.php at line 2992
    6. XF\App->fire() in src/XF/Template/Templater.php at line 1614
    7. XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 565
    8. XF\Pub\App->renderPageHtml() in src/XF/App.php at line 2283
    9. XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 404
    10. XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 60
    11. XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2485
    12. XF\App->run() in src/XF.php at line 524
    13. XF::runApp() in index.php at line 19

Included Files (365, XenForo Classes: 139)

  1. index.php
  2. src/XF.php
  3. src/vendor/autoload.php
  4. src/vendor/composer/autoload_real.php
  5. src/vendor/composer/ClassLoader.php
  6. src/vendor/composer/autoload_static.php
  7. src/vendor/laminas/laminas-zendframework-bridge/src/autoload.php
  8. src/vendor/laminas/laminas-zendframework-bridge/src/Autoloader.php
  9. src/vendor/laminas/laminas-zendframework-bridge/src/RewriteRules.php
  10. src/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
  11. src/vendor/symfony/polyfill-php72/bootstrap.php
  12. src/vendor/symfony/polyfill-intl-idn/bootstrap.php
  13. src/vendor/symfony/polyfill-mbstring/bootstrap.php
  14. src/vendor/ralouphie/getallheaders/src/getallheaders.php
  15. src/vendor/guzzlehttp/promises/src/functions_include.php
  16. src/vendor/guzzlehttp/promises/src/functions.php
  17. src/vendor/guzzlehttp/psr7/src/functions_include.php
  18. src/vendor/guzzlehttp/psr7/src/functions.php
  19. src/vendor/guzzlehttp/guzzle/src/functions_include.php
  20. src/vendor/guzzlehttp/guzzle/src/functions.php
  21. src/vendor/paragonie/sodium_compat/autoload.php
  22. src/vendor/paragonie/sodium_compat/autoload-php7.php
  23. src/vendor/paragonie/sodium_compat/src/Compat.php
  24. src/vendor/paragonie/sodium_compat/lib/namespaced.php
  25. src/vendor/paragonie/sodium_compat/lib/sodium_compat.php
  26. src/vendor/paragonie/sodium_compat/lib/constants.php
  27. src/vendor/paragonie/sodium_compat/lib/php72compat.php
  28. src/vendor/paragonie/sodium_compat/lib/stream-xchacha20.php
  29. src/vendor/paragonie/sodium_compat/lib/ristretto255.php
  30. src/vendor/swiftmailer/swiftmailer/lib/swift_required.php
  31. src/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
  32. src/vendor/symfony/var-dumper/Resources/functions/dump.php
  33. src/vendor/dokuwiki/utf8/utf8.php
  34. src/XF/Http/Request.php
  35. src/XF/InputFilterer.php
  36. src/XF/Pub/App.php
  37. src/XF/App.php
  38. src/XF/Container.php
  39. src/config.php
  40. src/XF/DataRegistry.php
  41. src/XF/Db/Mysqli/Adapter.php
  42. src/XF/Db/AbstractAdapter.php
  43. src/XF/CacheFactory.php
  44. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FilesystemCache.php
  45. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FileCache.php
  46. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/CacheProvider.php
  47. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/Cache.php
  48. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/FlushableCache.php
  49. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/ClearableCache.php
  50. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiGetCache.php
  51. src/vendor/doctrine/cache/lib/Doctrine/Common/Cache/MultiPutCache.php
  52. src/XF/Extension.php
  53. src/XF/AddOn/Manager.php
  54. src/XF/ComposerAutoload.php
  55. src/addons/DBTech/Security/vendor/composer/autoload_namespaces.php
  56. src/addons/DBTech/Security/vendor/composer/autoload_psr4.php
  57. src/addons/DBTech/Security/vendor/composer/autoload_classmap.php
  58. src/addons/DBTech/Security/vendor/composer/autoload_files.php
  59. src/addons/DBTech/Security/vendor/beberlei/assert/lib/Assert/functions.php
  60. src/addons/DBTech/Security/vendor/symfony/deprecation-contracts/function.php
  61. src/addons/DBTech/Security/vendor/symfony/polyfill-php80/bootstrap.php
  62. src/addons/DBTech/Security/vendor/symfony/polyfill-ctype/bootstrap.php
  63. src/addons/DBTech/Security/vendor/ramsey/uuid/src/functions.php
  64. src/addons/DBTech/Security/vendor/symfony/polyfill-php73/bootstrap.php
  65. src/addons/DBTech/Security/vendor-custom/web-token/jwt-core/AlgorithmManager.php
  66. src/addons/TechDaddies/MailwizzSync/vendor/composer/autoload_namespaces.php
  67. src/addons/TechDaddies/MailwizzSync/vendor/composer/autoload_psr4.php
  68. src/addons/TechDaddies/MailwizzSync/vendor/composer/autoload_classmap.php
  69. src/addons/TechDaddies/MailwizzSync/vendor/composer/autoload_files.php
  70. src/addons/TechDaddies/MailwizzSync/vendor/twisted1919/mailwizz-php-sdk/MailWizzApi/autoload.php
  71. src/addons/TechDaddies/MailwizzSync/vendor/twisted1919/mailwizz-php-sdk/MailWizzApi/Autoloader.php
  72. src/addons/XFAws/_vendor/composer/autoload_namespaces.php
  73. src/addons/XFAws/_vendor/composer/autoload_psr4.php
  74. src/addons/XFAws/_vendor/composer/autoload_classmap.php
  75. src/addons/XFAws/_vendor/composer/autoload_files.php
  76. src/addons/XFAws/_vendor/mtdowling/jmespath.php/src/JmesPath.php
  77. src/addons/XFAws/_vendor/aws/aws-sdk-php/src/functions.php
  78. src/addons/DBTech/Security/Listener.php
  79. src/addons/Siropu/AdsManager/Listener.php
  80. src/addons/XFMG/Listener.php
  81. src/XF/Session/Session.php
  82. src/addons/DBTech/Security/XF/Session/Session.php
  83. src/addons/LiteSpeedCache/XF/Session/Session.php
  84. src/XF/Session/DbStorage.php
  85. src/XF/Session/StorageInterface.php
  86. src/XF/Util/Ip.php
  87. src/XF/Util/Random.php
  88. src/XF/Http/Response.php
  89. src/XF/Mvc/Entity/Manager.php
  90. src/XF/Mvc/Entity/ValueFormatter.php
  91. src/XF/Repository/User.php
  92. src/XF/Mvc/Entity/Repository.php
  93. src/addons/Tapatalk/XF/Repository/User.php
  94. src/XF/Entity/User.php
  95. src/XF/Mvc/Entity/Entity.php
  96. src/XF/Entity/LinkableInterface.php
  97. src/addons/XenCentral/Feedback/XF/Entity/User.php
  98. src/addons/DBTech/Security/XF/Entity/User.php
  99. src/addons/Siropu/AdsManager/XF/Entity/User.php
  100. src/addons/ThemeHouse/Donate/XF/Entity/User.php
  101. src/addons/XFMG/XF/Entity/User.php
  102. src/XF/Mvc/Entity/Structure.php
  103. src/XF/Entity/UserAuth.php
  104. src/addons/DBTech/Security/XF/Entity/UserAuth.php
  105. src/XF/Entity/UserOption.php
  106. src/addons/DBTech/Security/XF/Entity/UserOption.php
  107. src/XF/Entity/UserProfile.php
  108. src/XF/Entity/UserPrivacy.php
  109. src/addons/ThemeHouse/Donate/XF/Entity/UserPrivacy.php
  110. src/XF/Util/File.php
  111. src/XF/Language.php
  112. src/addons/DBTech/Security/Repository/Session.php
  113. src/addons/DBTech/Security/Entity/Session.php
  114. src/XF/Mvc/Entity/Finder.php
  115. src/XF/Db/Mysqli/Statement.php
  116. src/XF/Db/AbstractStatement.php
  117. src/XF/Mvc/Dispatcher.php
  118. src/XF/Mvc/Router.php
  119. src/addons/XF301VB/Mvc/Router.php
  120. src/addons/DBTech/Redirect/XF/Mvc/Router.php
  121. internal_data/dbtechRedirect/urlFormats.php
  122. src/XF/Mvc/RouteMatch.php
  123. src/XF/Util/Arr.php
  124. src/XF/Mvc/ParameterBag.php
  125. src/XF/Pub/Controller/Thread.php
  126. src/XF/Pub/Controller/AbstractController.php
  127. src/XF/Mvc/Controller.php
  128. src/addons/Justin/ThreadModal/XF/Pub/Controller/Thread.php
  129. src/addons/LiteSpeedCache/XF/Pub/Controller/Thread.php
  130. src/addons/Siropu/AdsManager/XF/Pub/Controller/Thread.php
  131. src/addons/Snog/Actions/XF/Pub/Controller/Thread.php
  132. src/addons/Truonglv/ThreadOwnerPerms/XF/Pub/Controller/Thread.php
  133. src/addons/XFES/XF/Pub/Controller/Thread.php
  134. src/addons/XFMG/XF/Pub/Controller/Thread.php
  135. src/XF/Util/Php.php
  136. src/XF/PermissionCache.php
  137. src/XF/PermissionSet.php
  138. src/addons/XenCentral/Feedback/Listener.php
  139. src/XF/Entity/Thread.php
  140. src/XF/Entity/ContentVoteTrait.php
  141. src/addons/Truonglv/ThreadOwnerPerms/XF/Entity/Thread.php
  142. src/addons/XFES/XF/Entity/Thread.php
  143. src/addons/XFMG/XF/Entity/Thread.php
  144. src/XF/Finder/Thread.php
  145. src/addons/XFES/Entity/ThreadSimilar.php
  146. src/XF/Entity/Forum.php
  147. src/XF/Entity/AbstractNode.php
  148. src/addons/XFES/XF/Entity/Forum.php
  149. src/addons/XFMG/XF/Entity/Forum.php
  150. src/XF/Entity/Node.php
  151. src/XF/Entity/BookmarkTrait.php
  152. src/addons/Tapatalk/XF/Entity/Node.php
  153. src/XF/Entity/PermissionCacheContent.php
  154. src/XF/Mvc/Entity/Proxyable.php
  155. src/XF/Mvc/Entity/FinderCollection.php
  156. src/XF/Mvc/Entity/AbstractCollection.php
  157. src/XF/ControllerPlugin/Node.php
  158. src/XF/ControllerPlugin/AbstractPlugin.php
  159. src/XF/ThreadType/Discussion.php
  160. src/XF/ThreadType/AbstractHandler.php
  161. src/XF/Repository/Thread.php
  162. src/addons/Tapatalk/XF/Repository/Thread.php
  163. src/addons/XFES/XF/Repository/Thread.php
  164. src/XF/ControllerPlugin/Thread.php
  165. src/XF/Str/Formatter.php
  166. src/addons/Tapatalk/XF/Str/Formatter.php
  167. src/XF/Repository/Post.php
  168. src/addons/Tapatalk/XF/Repository/Post.php
  169. src/XF/Entity/Post.php
  170. src/XF/Entity/QuotableInterface.php
  171. src/XF/BbCode/RenderableContentInterface.php
  172. src/XF/Entity/ReactionTrait.php
  173. src/addons/Truonglv/ThreadOwnerPerms/XF/Entity/Post.php
  174. src/addons/XFES/XF/Entity/Post.php
  175. src/addons/XFMG/XF/Entity/Post.php
  176. src/XF/Finder/Post.php
  177. src/XF/Entity/PermissionCombination.php
  178. src/XF/Entity/SessionActivity.php
  179. src/XF/Mvc/Entity/ArrayCollection.php
  180. src/XF/Repository/Attachment.php
  181. src/addons/Tapatalk/XF/Repository/Attachment.php
  182. src/XF/Entity/Attachment.php
  183. src/addons/XFMG/XF/Entity/Attachment.php
  184. src/XF/Entity/AttachmentData.php
  185. src/addons/XFMG/XF/Entity/AttachmentData.php
  186. src/addons/XFMG/Entity/MediaItem.php
  187. src/addons/XFMG/Entity/CommentableTrait.php
  188. src/addons/XFMG/Entity/RateableTrait.php
  189. src/addons/XFMG/Entity/Category.php
  190. src/XF/Entity/AbstractCategoryTree.php
  191. src/addons/XFMG/Repository/Category.php
  192. src/XF/Repository/AbstractCategoryTree.php
  193. src/XF/Phrase.php
  194. src/addons/XFMG/Repository/Media.php
  195. src/XF/Data/Robot.php
  196. src/addons/DBTech/Security/XF/Data/Robot.php
  197. src/addons/DBTech/Security/3rdParty/spiders.php
  198. src/XF/Repository/Unfurl.php
  199. src/XF/ThreadViewData.php
  200. src/XF/Repository/UserAlert.php
  201. src/addons/Tapatalk/XF/Repository/UserAlert.php
  202. src/XF/Repository/ThreadType.php
  203. src/XF/ForumType/Discussion.php
  204. src/XF/ForumType/AbstractHandler.php
  205. src/XF/ThreadType/Poll.php
  206. src/XF/Mvc/Reply/View.php
  207. src/XF/Mvc/Reply/AbstractReply.php
  208. src/XF/Repository/SessionActivity.php
  209. src/addons/LiteSpeedCache/Listener.php
  210. src/addons/Tapatalk/Listener/ControllerPostDispatch.php
  211. src/addons/XenCentral/Feedback/Repository/Activity.php
  212. src/addons/XenCentral/Feedback/Repository/FeedbackAbstractRepository.php
  213. src/XF/Style.php
  214. src/XF/Template/Templater.php
  215. src/XF/SubContainer/BbCode.php
  216. src/XF/SubContainer/AbstractSubContainer.php
  217. src/XF/SubContainer/Widget.php
  218. src/addons/ThemeHouse/Donate/Listener/TemplaterSetup.php
  219. src/addons/XFMG/Template/TemplaterSetup.php
  220. src/XF/CookieConsent.php
  221. src/XF/Captcha/Question.php
  222. src/XF/Captcha/AbstractCaptcha.php
  223. src/XF/Repository/Payment.php
  224. src/XF/Payment/PayPal.php
  225. src/XF/Payment/AbstractProvider.php
  226. src/addons/ThemeHouse/Donate/XF/Payment/PayPal.php
  227. src/XF/SimpleCache.php
  228. src/addons/Siropu/AdsManager/Template/Ad.php
  229. src/addons/Siropu/AdsManager/Util/Arr.php
  230. src/XF/Pub/Route/Category.php
  231. src/XF/Mvc/RouteBuiltLink.php
  232. src/addons/Siropu/AdsManager/Repository/Ad.php
  233. src/addons/Siropu/AdsManager/Entity/Ad.php
  234. src/addons/Siropu/AdsManager/Entity/AbstractEntity.php
  235. src/addons/Siropu/AdsManager/Finder/Ad.php
  236. src/addons/Siropu/AdsManager/Entity/Package.php
  237. src/XF/Entity/Template.php
  238. src/addons/DBTech/Security/XF/Entity/Template.php
  239. src/XF/Criteria/User.php
  240. src/XF/Criteria/AbstractCriteria.php
  241. src/XF/Criteria/Page.php
  242. src/addons/Siropu/AdsManager/XF/Criteria/Page.php
  243. src/addons/Siropu/AdsManager/Criteria/Device.php
  244. src/addons/Siropu/AdsManager/Vendor/MobileDetect/Mobile_Detect.php
  245. src/addons/Siropu/AdsManager/Criteria/Geo.php
  246. src/addons/Siropu/AdsManager/Vendor/MaxMind/autoload.php
  247. src/addons/Siropu/AdsManager/Vendor/MaxMind/composer/autoload_real.php
  248. src/addons/Siropu/AdsManager/Vendor/MaxMind/composer/autoload_static.php
  249. src/addons/Siropu/AdsManager/Vendor/MaxMind/geoip2/geoip2/src/Database/Reader.php
  250. src/addons/Siropu/AdsManager/Vendor/MaxMind/geoip2/geoip2/src/ProviderInterface.php
  251. src/addons/Siropu/AdsManager/Vendor/MaxMind/maxmind-db/reader/src/MaxMind/Db/Reader.php
  252. src/addons/Siropu/AdsManager/Criteria/Position.php
  253. src/XF/Mvc/Entity/FinderExpression.php
  254. src/XF/Mvc/Renderer/Html.php
  255. src/XF/Mvc/Renderer/AbstractRenderer.php
  256. src/XF/Mvc/View.php
  257. src/XF/Template/Template.php
  258. src/addons/Tapatalk/Listener/Hook.php
  259. src/addons/AL/OriginalPosterHighlight/Listener/TemplaterTemplatePreRender.php
  260. src/addons/AL/OriginalPosterHighlight/Listener/AppPubRenderPage.php
  261. internal_data/code_cache/templates/l1/s4/public/thread_view.php
  262. src/XF/Template/ExtensionSet.php
  263. src/XF/PreEscaped.php
  264. internal_data/code_cache/templates/l1/s4/public/metadata_macros.php
  265. src/XF/Template/MacroState.php
  266. src/XF/Util/Json.php
  267. internal_data/code_cache/templates/l1/s4/public/forum_macros.php
  268. internal_data/code_cache/templates/l1/s4/public/siropu_ads_manager_ad_macros.php
  269. internal_data/code_cache/templates/l1/s4/public/_ads.php
  270. internal_data/code_cache/templates/l1/s4/public/page_nav.php
  271. src/addons/Tapatalk/Listener/TemplatePostRender.php
  272. src/XF/CustomField/DefinitionSet.php
  273. src/XF/CustomField/Set.php
  274. internal_data/code_cache/templates/l1/s4/public/custom_fields_macros.php
  275. internal_data/code_cache/templates/l1/s4/public/post_macros.php
  276. internal_data/code_cache/templates/l1/s4/public/aloph_op_ribbon_text_post_indicator_xf21_higher.php
  277. internal_data/code_cache/templates/l1/s4/public/bookmark_macros.php
  278. internal_data/code_cache/templates/l1/s4/public/message_macros.php
  279. src/XF/Finder/SessionActivity.php
  280. internal_data/code_cache/templates/l1/s4/public/aloph_op_ribbon_user_avatar.php
  281. src/XF/Util/Color.php
  282. internal_data/code_cache/templates/l1/s4/public/xcfs_postbit_addon.php
  283. src/XF/BbCode/Parser.php
  284. src/XF/BbCode/RuleSet.php
  285. src/addons/Tapatalk/XF/BbCode/RuleSet.php
  286. src/XF/BbCode/Renderer/Html.php
  287. src/XF/BbCode/Renderer/AbstractRenderer.php
  288. src/XF/BbCode/Traverser.php
  289. src/addons/Tapatalk/XF/BbCode/Renderer/Html.php
  290. src/XF/Str/EmojiFormatter.php
  291. src/vendor/joypixels/emoji-toolkit/lib/php/src/Client.php
  292. src/vendor/joypixels/emoji-toolkit/lib/php/src/ClientInterface.php
  293. src/vendor/joypixels/emoji-toolkit/lib/php/src/Ruleset.php
  294. src/vendor/joypixels/emoji-toolkit/lib/php/src/RulesetInterface.php
  295. src/addons/Siropu/AdsManager/Service/Stats/Tracker.php
  296. src/XF/Service/AbstractService.php
  297. internal_data/code_cache/templates/l1/s4/public/bb_code_tag_attach.php
  298. internal_data/code_cache/templates/l1/s4/public/reaction_list_row.php
  299. internal_data/code_cache/templates/l1/s4/public/reactions_summary.php
  300. internal_data/code_cache/phrase_groups/l1/reaction_title.php
  301. internal_data/code_cache/phrase_groups/l1/reactions.php
  302. internal_data/code_cache/templates/l1/s4/public/bb_code_tag_quote.php
  303. internal_data/code_cache/widgets/_22_xfes_thread_view_below_quick_reply_similar_threads.php
  304. src/XF/Widget/WidgetConfig.php
  305. src/addons/XFES/Widget/SimilarThreads.php
  306. src/XF/Widget/AbstractWidget.php
  307. internal_data/code_cache/phrase_groups/l1/widget.php
  308. internal_data/code_cache/phrase_groups/l1/widget_def.php
  309. src/XF/Widget/WidgetRenderer.php
  310. internal_data/code_cache/templates/l1/s4/public/xfes_widget_similar_threads.php
  311. internal_data/code_cache/templates/l1/s4/public/thread_list_macros.php
  312. internal_data/code_cache/templates/l1/s4/public/share_page_macros.php
  313. internal_data/code_cache/widgets/_12_siropu_ads_manager_sticky.php
  314. src/addons/Siropu/AdsManager/Widget/FeaturedThreads.php
  315. internal_data/code_cache/navigation_cache.php
  316. src/XF/Pub/Route/Search.php
  317. src/XF/NoticeList.php
  318. internal_data/code_cache/widgets/_7_forum_overview_new_posts.php
  319. src/XF/Widget/NewPosts.php
  320. internal_data/code_cache/templates/l1/s4/public/widget_new_posts.php
  321. internal_data/code_cache/widgets/_25_Vode.php
  322. src/XF/Widget/Html.php
  323. internal_data/code_cache/templates/l1/s4/public/_widget_Vode.php
  324. internal_data/code_cache/templates/l1/s4/public/widget_html.php
  325. internal_data/code_cache/widgets/_9_forum_overview_forum_statistics.php
  326. src/XF/Widget/ForumStatistics.php
  327. internal_data/code_cache/templates/l1/s4/public/widget_forum_statistics.php
  328. internal_data/code_cache/widgets/_20_rokslide_ad_sidebar_yeti.php
  329. internal_data/code_cache/templates/l1/s4/public/_widget_rokslide_ad_sidebar_yeti.php
  330. internal_data/code_cache/widgets/_15_latest_articles.php
  331. src/addons/Andy/RSSFeed/Widget/RSSFeed.php
  332. src/addons/Andy/RSSFeed/Entity/RSSFeed.php
  333. internal_data/code_cache/templates/l1/s4/public/andy_rssfeed.php
  334. internal_data/code_cache/widgets/_21_rokslide_ad_admetrics_sidebar.php
  335. internal_data/code_cache/templates/l1/s4/public/_widget_rokslide_ad_admetrics_sidebar.php
  336. src/XF/Repository/AddOn.php
  337. src/addons/Tapatalk/XF/Repository/AddOn.php
  338. src/XF/Entity/AddOn.php
  339. mobiquo/smartbanner/head.inc.php
  340. internal_data/code_cache/templates/l1/s4/public/PAGE_CONTAINER.php
  341. internal_data/code_cache/templates/l1/s4/public/xb_custom_fonts.php
  342. internal_data/code_cache/templates/l1/s4/public/helper_js_global.php
  343. internal_data/code_cache/templates/l1/s4/public/font_awesome_setup.php
  344. internal_data/code_cache/templates/l1/s4/public/google_analytics.php
  345. internal_data/code_cache/templates/l1/s4/public/xb_head.php
  346. internal_data/code_cache/phrase_groups/l1/nav.php
  347. internal_data/code_cache/phrase_groups/l1/button.php
  348. internal_data/code_cache/templates/l1/s4/public/xb_subnav_right.php
  349. internal_data/code_cache/templates/l1/s4/public/xb_canvas_panel_top.php
  350. internal_data/code_cache/templates/l1/s4/public/xb_canvas_panel_bottom.php
  351. internal_data/code_cache/templates/l1/s4/public/xb_social_icons.php
  352. internal_data/code_cache/templates/l1/s4/public/browser_warning_macros.php
  353. internal_data/code_cache/templates/l1/s4/public/xb_welcome.php
  354. internal_data/code_cache/templates/l1/s4/public/xb_footer_links.php
  355. src/addons/DBTech/Security/Template/Callback/Copyright.php
  356. internal_data/code_cache/templates/l1/s4/public/debug_macros.php
  357. internal_data/code_cache/templates/l1/s4/public/siropu_ads_manager_ad_js.php
  358. internal_data/code_cache/templates/l1/s4/public/dbtech_security_fingerprint.php
  359. internal_data/code_cache/templates/l1/s4/public/xb_body_helper.php
  360. internal_data/code_cache/templates/l1/s4/public/xb_body.php
  361. src/addons/DBTech/Security/Repository/Watcher.php
  362. src/addons/DBTech/Security/Watcher/ConfigTamper.php
  363. src/addons/DBTech/Security/Watcher/AbstractHandler.php
  364. src/addons/DBTech/Security/Entity/Watcher.php
  365. src/XF/Debugger.php

DB Connection Stats

bytes_sent18921
bytes_received456676
packets_sent172
packets_received2338
protocol_overhead_in9352
protocol_overhead_out688
bytes_received_ok_packet0
bytes_received_eof_packet0
bytes_received_rset_header_packet522
bytes_received_rset_field_meta_packet0
bytes_received_rset_row_packet215
bytes_received_prepare_response_packet178576
bytes_received_change_user_packet276673
packets_sent_command85
packets_received_ok0
packets_received_eof0
packets_received_rset_header58
packets_received_rset_field_meta0
packets_received_rset_row30
packets_received_prepare_response2042
packets_received_change_user178
result_set_queries26
non_result_set_queries4
no_index_used1
bad_index_used0
slow_queries0
buffered_sets0
unbuffered_sets0
ps_buffered_sets26
ps_unbuffered_sets0
flushed_normal_sets0
flushed_ps_sets0
ps_prepared_never_executed0
ps_prepared_once_executed27
rows_fetched_from_server_normal0
rows_fetched_from_server_ps152
rows_buffered_from_client_normal0
rows_buffered_from_client_ps152
rows_fetched_from_client_normal_buffered0
rows_fetched_from_client_normal_unbuffered0
rows_fetched_from_client_ps_buffered0
rows_fetched_from_client_ps_unbuffered0
rows_fetched_from_client_ps_cursor0
rows_affected_normal0
rows_affected_ps0
rows_skipped_normal0
rows_skipped_ps152
copy_on_write_saved0
copy_on_write_performed0
command_buffer_too_small0
connect_success1
connect_failure0
connection_reused0
reconnect0
pconnect_success1
active_connections1
active_persistent_connections1
explicit_close0
implicit_close0
disconnect_close0
in_middle_of_command_close0
explicit_free_result0
implicit_free_result0
explicit_stmt_close0
implicit_stmt_close0
mem_emalloc_count0
mem_emalloc_amount0
mem_ecalloc_count0
mem_ecalloc_amount0
mem_erealloc_count0
mem_erealloc_amount0
mem_efree_count0
mem_efree_amount0
mem_malloc_count0
mem_malloc_amount0
mem_calloc_count0
mem_calloc_amount0
mem_realloc_count0
mem_realloc_amount0
mem_free_count0
mem_free_amount0
mem_estrndup_count0
mem_strndup_count0
mem_estrdup_count0
mem_strdup_count0
mem_edupl_count0
mem_dupl_count0
proto_text_fetched_null0
proto_text_fetched_bit0
proto_text_fetched_tinyint0
proto_text_fetched_short0
proto_text_fetched_int240
proto_text_fetched_int0
proto_text_fetched_bigint0
proto_text_fetched_decimal0
proto_text_fetched_float0
proto_text_fetched_double0
proto_text_fetched_date0
proto_text_fetched_year0
proto_text_fetched_time0
proto_text_fetched_datetime0
proto_text_fetched_timestamp0
proto_text_fetched_string0
proto_text_fetched_blob0
proto_text_fetched_enum0
proto_text_fetched_set0
proto_text_fetched_geometry0
proto_text_fetched_other0
proto_binary_fetched_null0
proto_binary_fetched_bit2327
proto_binary_fetched_tinyint0
proto_binary_fetched_short1300
proto_binary_fetched_int24507
proto_binary_fetched_int0
proto_binary_fetched_bigint4292
proto_binary_fetched_decimal42
proto_binary_fetched_float45
proto_binary_fetched_double243
proto_binary_fetched_date0
proto_binary_fetched_year0
proto_binary_fetched_time0
proto_binary_fetched_datetime0
proto_binary_fetched_timestamp0
proto_binary_fetched_string0
proto_binary_fetched_json2139
proto_binary_fetched_blob1365
proto_binary_fetched_enum0
proto_binary_fetched_set0
proto_binary_fetched_geometry0
proto_binary_fetched_other0
init_command_executed_count0
init_command_failed_count0
com_quit0
com_init_db0
com_query2
com_field_list0
com_create_db0
com_drop_db0
com_refresh0
com_shutdown0
com_statistics0
com_process_info0
com_connect0
com_process_kill0
com_debug0
com_ping0
com_time0
com_delayed_insert0
com_change_user0
com_binlog_dump0
com_table_dump0
com_connect_out0
com_register_slave0
com_stmt_prepare28
com_stmt_execute28
com_stmt_send_long_data0
com_stmt_close27
com_stmt_reset0
com_stmt_set_option0
com_stmt_fetch0
com_deamon0
bytes_received_real_data_normal0
bytes_received_real_data_ps270348