SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('addOns', 'addOnsComposer', 'autoJobRun', 'bbCodeMedia', 'classExtensions', 'codeEventListeners', 'connectedAccountCount', 'contentTypes', 'displayStyles', 'helpPageCount', 'languages', 'masterStyleProperties', 'nodeTypes', 'options', 'reactions', 'reportCounts', 'simpleCache', 'smilies', 'unapprovedCounts', 'userBanners', 'userTitleLadder', 'userUpgradeCount', 'widgetCache', 'widgetDefinition', 'widgetPosition', 'bannedIps', 'bbCodeCustom', 'discouragedIps', 'notices', 'noticesLastReset', 'routeFilters', 'routesPublic', 'styles', 'userFieldsInfo', 'threadFieldsInfo', 'threadPrefixes')
Run Time: 0.000733
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 36 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/App.php at line 1759
- XF\App->preLoadData() in src/XF/App.php at line 1747
- XF\App->setup() in src/XF/Pub/App.php at line 89
- XF\Pub\App->setup() in src/XF.php at line 364
- XF::setupApp() in src/XF.php at line 387
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000103
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 32
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 926
- XF\Entity\User->hasPermission() in src/addons/SV/ModeratorEssentials/XF/Entity/User.php at line 29
- SV\ModeratorEssentials\XF\Entity\User->canViewModeratorPanel() in src/addons/SV/ModeratorEssentials/XF/Entity/User.php at line 52
- SV\ModeratorEssentials\XF\Entity\User->canViewModeratorLogCounts() in src/addons/SV/ModeratorEssentials/Listener.php at line 44
- SV\ModeratorEssentials\Listener::appPubStartEnd()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2654
- XF\App->fire() in src/XF/Pub/App.php at line 192
- XF\Pub\App->start() in src/XF/App.php at line 2180
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_post_FirstPost_2`.*, `xf_user_User_3`.*, `xf_user_option_Option_4`.*, `xf_user_profile_Profile_5`.*, `xf_user_privacy_Privacy_6`.*, `xf_session_activity_Activity_7`.*, `xf_sv_content_mentions_Mentions_8`.*, `xf_thfeature_feature_THFeature_9`.*, `xf_forum_Forum_10`.*, `xf_node_Node_11`.*, `xf_permission_cache_content_Permissions_12`.*
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_post` AS `xf_post_FirstPost_2` ON (`xf_post_FirstPost_2`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_3` ON (`xf_user_User_3`.`user_id` = `xf_post_FirstPost_2`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_4` ON (`xf_user_option_Option_4`.`user_id` = `xf_user_User_3`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_5` ON (`xf_user_profile_Profile_5`.`user_id` = `xf_user_User_3`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_6` ON (`xf_user_privacy_Privacy_6`.`user_id` = `xf_user_User_3`.`user_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_7` ON (`xf_session_activity_Activity_7`.`user_id` = `xf_user_User_3`.`user_id` AND `xf_session_activity_Activity_7`.`unique_key` = CONCAT(`xf_user_User_3`.`user_id`, ''))
LEFT JOIN `xf_sv_content_mentions` AS `xf_sv_content_mentions_Mentions_8` ON (`xf_sv_content_mentions_Mentions_8`.`content_type` = 'post' AND `xf_sv_content_mentions_Mentions_8`.`content_id` = `xf_post_FirstPost_2`.`post_id`)
LEFT JOIN `xf_thfeature_feature` AS `xf_thfeature_feature_THFeature_9` ON (`xf_thfeature_feature_THFeature_9`.`content_type` = 'thread' AND `xf_thfeature_feature_THFeature_9`.`content_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_10` ON (`xf_forum_Forum_10`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_11` ON (`xf_node_Node_11`.`node_id` = `xf_forum_Forum_10`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_12` ON (`xf_permission_cache_content_Permissions_12`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_12`.`content_id` = `xf_node_Node_11`.`node_id` AND `xf_permission_cache_content_Permissions_12`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` = '50734')
LIMIT 1
Run Time: 0.001936
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_post_FirstPost_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_option_Option_4 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_profile_Profile_5 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_privacy_Privacy_6 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_session_activity_Activity_7 | const | PRIMARY | PRIMARY | 22 | const,const | 0 | Unique row not found |
SIMPLE | xf_sv_content_mentions_Mentions_8 | const | PRIMARY | PRIMARY | 31 | const,const | 0 | Unique row not found |
SIMPLE | xf_thfeature_feature_THFeature_9 | ALL | | | | | 24 | Using where |
SIMPLE | xf_forum_Forum_10 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_11 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_forum_Forum_10.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_12 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,smokingm_db.xf_node_Node_11.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Thread.php at line 1372
- XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 12
- XF\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/Feature/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\Feature\XF\Pub\Controller\Thread->actionIndex() in src/addons/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php at line 31
- SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/AlertImprovements/XF/Pub/Controller/Thread.php at line 24
- SV\AlertImprovements\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/ModeratorEssentials/XF/Pub/Controller/Thread.php at line 28
- SV\ModeratorEssentials\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_session_activity_Activity_5`.*, `xf_sv_content_mentions_Mentions_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_session_activity` AS `xf_session_activity_Activity_5` ON (`xf_session_activity_Activity_5`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_5`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, ''))
LEFT JOIN `xf_sv_content_mentions` AS `xf_sv_content_mentions_Mentions_6` ON (`xf_sv_content_mentions_Mentions_6`.`content_type` = 'post' AND `xf_sv_content_mentions_Mentions_6`.`content_id` = `xf_post`.`post_id`)
WHERE (`xf_post`.`thread_id` = 50734) 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.001389
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 5 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_5 | eq_ref | PRIMARY | PRIMARY | 22 | smokingm_db.xf_user_User_1.user_id,func | 1 | Using where |
SIMPLE | xf_sv_content_mentions_Mentions_6 | eq_ref | PRIMARY | PRIMARY | 31 | const,smokingm_db.xf_post.post_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Thread.php at line 35
- XF\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/Feature/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\Feature\XF\Pub\Controller\Thread->actionIndex() in src/addons/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php at line 31
- SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/AlertImprovements/XF/Pub/Controller/Thread.php at line 24
- SV\AlertImprovements\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/ModeratorEssentials/XF/Pub/Controller/Thread.php at line 28
- SV\ModeratorEssentials\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT alert_id
FROM xf_user_alert
WHERE alerted_user_id = ?
AND view_date = 0
AND event_date < ?
AND content_type IN ('post')
AND content_id IN (10069, 10070, 10093, 10103, 10449)
Params: 0, 1575755996
Run Time: 0.000360
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_alert | range | alertedUserId_eventDate,contentType_contentId,viewDate_eventDate | alertedUserId_eventDate | 8 | | 1 | Using index condition; Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 170
- XF\Db\AbstractAdapter->fetchAllColumn() in src/addons/SV/AlertImprovements/XF/Repository/UserAlert.php at line 681
- SV\AlertImprovements\XF\Repository\UserAlert->markAlertsReadForContentIds() in src/addons/SV/AlertImprovements/XF/Repository/UserAlert.php at line 638
- SV\AlertImprovements\XF\Repository\UserAlert->markUserAlertsReadForContent() in src/XF/Pub/Controller/Thread.php at line 57
- XF\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/Feature/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\Feature\XF\Pub\Controller\Thread->actionIndex() in src/addons/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php at line 31
- SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/AlertImprovements/XF/Pub/Controller/Thread.php at line 24
- SV\AlertImprovements\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/ModeratorEssentials/XF/Pub/Controller/Thread.php at line 28
- SV\ModeratorEssentials\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
INSERT INTO xf_thread_view
(thread_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 50734
Run Time: 0.000096
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/Thread.php at line 193
- XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 90
- XF\Pub\Controller\Thread->actionIndex() in src/addons/ThemeHouse/Feature/XF/Pub/Controller/Thread.php at line 12
- ThemeHouse\Feature\XF\Pub\Controller\Thread->actionIndex() in src/addons/EWR/Porta/Pub/Controller/Thread.php at line 11
- EWR\Porta\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php at line 31
- SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/AlertImprovements/XF/Pub/Controller/Thread.php at line 24
- SV\AlertImprovements\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/ModeratorEssentials/XF/Pub/Controller/Thread.php at line 28
- SV\ModeratorEssentials\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `ewr_porta_articles`.*
FROM `ewr_porta_articles`
WHERE (`ewr_porta_articles`.`thread_id` = 50734)
LIMIT 1
Run Time: 0.000185
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 364
- XF\Mvc\Entity\Manager->getRelation() in src/XF/Mvc/Entity/Entity.php at line 385
- XF\Mvc\Entity\Entity->getRelation() in src/XF/Mvc/Entity/Entity.php at line 177
- XF\Mvc\Entity\Entity->get() in src/XF/Mvc/Entity/Entity.php at line 101
- XF\Mvc\Entity\Entity->__get() in src/addons/EWR/Porta/Pub/Controller/Thread.php at line 22
- EWR\Porta\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php at line 31
- SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/AlertImprovements/XF/Pub/Controller/Thread.php at line 24
- SV\AlertImprovements\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/ModeratorEssentials/XF/Pub/Controller/Thread.php at line 28
- SV\ModeratorEssentials\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `ewr_porta_features`.*
FROM `ewr_porta_features`
WHERE (`ewr_porta_features`.`thread_id` = 50734)
LIMIT 1
Run Time: 0.000196
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/addons/EWR/Porta/Repository/Feature.php at line 22
- EWR\Porta\Repository\Feature->fetchFeatureByThread() in src/addons/EWR/Porta/Pub/Controller/Thread.php at line 53
- EWR\Porta\Pub\Controller\Thread->actionIndex() in src/addons/XFMG/XF/Pub/Controller/Thread.php at line 11
- XFMG\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/Showcase/XF/Pub/Controller/Thread.php at line 11
- XenAddons\Showcase\XF\Pub\Controller\Thread->actionIndex() in src/addons/XenAddons/AMS/XF/Pub/Controller/Thread.php at line 11
- XenAddons\AMS\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/UserEssentials/XF/Pub/Controller/Thread.php at line 31
- SV\UserEssentials\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/AlertImprovements/XF/Pub/Controller/Thread.php at line 24
- SV\AlertImprovements\XF\Pub\Controller\Thread->actionIndex() in src/addons/SV/ModeratorEssentials/XF/Pub/Controller/Thread.php at line 28
- SV\ModeratorEssentials\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT INTO xf_session_activity
(`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XF\Pub\Controller\Thread, Index, valid, thread_id=50734, 1575755996,
Run Time: 0.000208
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Repository/SessionActivity.php at line 158
- XF\Repository\SessionActivity->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 81
- XF\Pub\Controller\AbstractController->updateSessionActivity() in src/XF/Pub/Controller/AbstractController.php at line 41
- XF\Pub\Controller\AbstractController->postDispatchType() in src/XF/Mvc/Controller.php at line 284
- XF\Mvc\Controller->postDispatch() in src/XF/Mvc/Dispatcher.php at line 383
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
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.000243
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status_display_order | 77 | const | 29 | Using where |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_siropu_ads_manager_ad.package_id | 1 | |
SIMPLE | xf_template_MasterTemplate_2 | eq_ref | type_title_style_id | type_title_style_id | 128 | const,func,const | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 441
- Siropu\AdsManager\Template\Ad->prepareAdsForDisplay() in src/addons/Siropu/AdsManager/Template/Ad.php at line 306
- Siropu\AdsManager\Template\Ad->setAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 297
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 38
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2654
- XF\App->fire() in src/XF/App.php at line 1922
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1800
- XF\App->preRender() in src/XF/Pub/App.php at line 432
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
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.001821
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_siropu_ads_manager_ad | ref | type,status,status_display_order | status | 77 | const | 29 | Using index condition; Using where; Using temporary; Using filesort |
SIMPLE | xf_siropu_ads_manager_package_Package_1 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_siropu_ads_manager_ad.package_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Siropu/AdsManager/Template/Ad.php at line 546
- Siropu\AdsManager\Template\Ad->loadFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 310
- Siropu\AdsManager\Template\Ad->setFilterAds() in src/addons/Siropu/AdsManager/Template/Ad.php at line 301
- Siropu\AdsManager\Template\Ad->__construct() in src/addons/Siropu/AdsManager/Listener.php at line 38
- Siropu\AdsManager\Listener::templaterGlobalData()
- call_user_func_array() in src/XF/Extension.php at line 67
- XF\Extension->fire() in src/XF/App.php at line 2654
- XF\App->fire() in src/XF/App.php at line 1922
- XF\App->getGlobalTemplateData() in src/XF/App.php at line 1800
- XF\App->preRender() in src/XF/Pub/App.php at line 432
- XF\Pub\App->preRender() in src/XF/Mvc/Dispatcher.php at line 395
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
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` > 1573163996)
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 10
Run Time: 0.000520
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | last_post_date | last_post_date | 4 | | 1094 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_thread.node_id | 1 | Using where |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_thread.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_thread.user_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_4 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,smokingm_db.xf_node_Node_2.node_id | 1 | Using where |
SIMPLE | xf_user_LastPoster_5 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_thread.last_post_user_id | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/XF/Widget/NewPosts.php at line 87
- XF\Widget\NewPosts->render() in internal_data/code_cache/widgets/_9_forum_overview_new_posts.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6678
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1639
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s16/public/thread_view.php at line 742
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_wte_widget_cache`.*
FROM `xf_wte_widget_cache`
WHERE (`xf_wte_widget_cache`.`cache_id` = '6e096ae1c09efa4c028a9f0db1b6087b')
LIMIT 1
Run Time: 0.000062
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_wte_widget_cache | const | PRIMARY | PRIMARY | 34 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1261
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 149
- XF\Mvc\Entity\Manager->find() in src/addons/Truonglv/WidgetThreadEnhance/Repository/Cache.php at line 18
- Truonglv\WidgetThreadEnhance\Repository\Cache->findById() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 372
- Truonglv\WidgetThreadEnhance\Widget\Threads->getThreadIdsFromCache() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 341
- Truonglv\WidgetThreadEnhance\Widget\Threads->getThreadIds() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 70
- Truonglv\WidgetThreadEnhance\Widget\Threads->render() in internal_data/code_cache/widgets/_32_PopularThreads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6678
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1639
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s16/public/thread_view.php at line 742
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*
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`)
WHERE (`xf_thread`.`thread_id` IN (293022, 293031, 293002, 293007, 293055, 292977, 293046, 292983, 292991, 292992)) AND (`xf_thread`.`discussion_state` = 'visible')
Run Time: 0.000291
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 10 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_thread.user_id | 1 | |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | smokingm_db.xf_forum_Forum_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1294
- XF\Mvc\Entity\Finder->fetch() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 102
- Truonglv\WidgetThreadEnhance\Widget\Threads->render() in internal_data/code_cache/widgets/_32_PopularThreads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6678
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1639
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s16/public/thread_view.php at line 742
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 135
Run Time: 0.000074
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 936
- XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
- XF\Entity\AbstractNode->canView() in src/XF/Entity/Thread.php at line 61
- XF\Entity\Thread->canView() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 110
- Truonglv\WidgetThreadEnhance\Widget\Threads->render() in internal_data/code_cache/widgets/_32_PopularThreads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6678
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1639
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s16/public/thread_view.php at line 742
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 106
Run Time: 0.000061
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 936
- XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
- XF\Entity\AbstractNode->canView() in src/XF/Entity/Thread.php at line 61
- XF\Entity\Thread->canView() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 110
- Truonglv\WidgetThreadEnhance\Widget\Threads->render() in internal_data/code_cache/widgets/_32_PopularThreads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6678
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1639
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s16/public/thread_view.php at line 742
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 107
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 150
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 73
- XF\PermissionCache->getContentPerms() in src/XF/PermissionSet.php at line 51
- XF\PermissionSet->hasContentPermission() in src/XF/Entity/User.php at line 936
- XF\Entity\User->hasNodePermission() in src/XF/Entity/AbstractNode.php at line 31
- XF\Entity\AbstractNode->canView() in src/XF/Entity/Thread.php at line 61
- XF\Entity\Thread->canView() in src/addons/Truonglv/WidgetThreadEnhance/Widget/Threads.php at line 110
- Truonglv\WidgetThreadEnhance\Widget\Threads->render() in internal_data/code_cache/widgets/_32_PopularThreads.php at line 5
- XF\SubContainer\Widget->{closure}() in src/XF/Template/Templater.php at line 6678
- XF\Template\Templater->renderWidgetClosure() in src/XF/SubContainer/Widget.php at line 168
- XF\SubContainer\Widget->getCompiledWidget() in src/XF/Template/Templater.php at line 1639
- XF\Template\Templater->widgetPosition() in internal_data/code_cache/templates/l1/s16/public/thread_view.php at line 742
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Template/Template.php at line 24
- XF\Template\Template->render() in src/XF/Mvc/Renderer/Html.php at line 48
- XF\Mvc\Renderer\Html->renderView() in src/XF/Mvc/Dispatcher.php at line 458
- XF\Mvc\Dispatcher->renderView() in src/XF/Mvc/Dispatcher.php at line 440
- XF\Mvc\Dispatcher->renderReply() in src/XF/Mvc/Dispatcher.php at line 400
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('forumStatistics')
Run Time: 0.000055
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 175
- XF\Db\AbstractAdapter->fetchPairs() in src/XF/DataRegistry.php at line 138
- XF\DataRegistry->readFromDb() in src/XF/DataRegistry.php at line 83
- XF\DataRegistry->get() in src/XF/DataRegistry.php at line 226
- XF\DataRegistry->offsetGet() in src/XF/App.php at line 1650
- XF\App->XF\{closure}() in src/XF/Container.php at line 28
- XF\Container->offsetGet() in src/XF/App.php at line 2257
- XF\App->__get() in src/XF/Widget/ForumStatistics.php at line 10
- XF\Widget\ForumStatistics->render() in src/XF/Template/Templater.php at line 1675
- XF\Template\Templater->renderWidget() in internal_data/code_cache/templates/l1/s16/public/xb_footer.php at line 40
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 706
- XF\Template\Templater->callMacro() in internal_data/code_cache/templates/l1/s16/public/xb_footer.php at line 235
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Template/Templater.php at line 1393
- XF\Template\Templater->includeTemplate() in internal_data/code_cache/templates/l1/s16/public/PAGE_CONTAINER.php at line 1991
- XF\Template\Templater->{closure}() in src/XF/Template/Templater.php at line 1320
- XF\Template\Templater->renderTemplate() in src/XF/Pub/App.php at line 544
- XF\Pub\App->renderPageHtml() in src/XF/App.php at line 1995
- XF\App->renderPage() in src/XF/Mvc/Dispatcher.php at line 402
- XF\Mvc\Dispatcher->render() in src/XF/Mvc/Dispatcher.php at line 58
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20
bytes_sent | 21023 |
bytes_received | 1238585 |
packets_sent | 208 |
packets_received | 2476 |
protocol_overhead_in | 9904 |
protocol_overhead_out | 832 |
bytes_received_ok_packet | 0 |
bytes_received_eof_packet | 0 |
bytes_received_rset_header_packet | 684 |
bytes_received_rset_field_meta_packet | 0 |
bytes_received_rset_row_packet | 206 |
bytes_received_prepare_response_packet | 183818 |
bytes_received_change_user_packet | 1053069 |
packets_sent_command | 103 |
packets_received_ok | 0 |
packets_received_eof | 0 |
packets_received_rset_header | 76 |
packets_received_rset_field_meta | 0 |
packets_received_rset_row | 36 |
packets_received_prepare_response | 2154 |
packets_received_change_user | 174 |
result_set_queries | 32 |
non_result_set_queries | 4 |
no_index_used | 1 |
bad_index_used | 0 |
slow_queries | 0 |
buffered_sets | 0 |
unbuffered_sets | 0 |
ps_buffered_sets | 32 |
ps_unbuffered_sets | 0 |
flushed_normal_sets | 0 |
flushed_ps_sets | 0 |
ps_prepared_never_executed | 0 |
ps_prepared_once_executed | 33 |
rows_fetched_from_server_normal | 0 |
rows_fetched_from_server_ps | 142 |
rows_buffered_from_client_normal | 0 |
rows_buffered_from_client_ps | 142 |
rows_fetched_from_client_normal_buffered | 0 |
rows_fetched_from_client_normal_unbuffered | 0 |
rows_fetched_from_client_ps_buffered | 0 |
rows_fetched_from_client_ps_unbuffered | 0 |
rows_fetched_from_client_ps_cursor | 0 |
rows_affected_normal | 0 |
rows_affected_ps | 0 |
rows_skipped_normal | 0 |
rows_skipped_ps | 142 |
copy_on_write_saved | 0 |
copy_on_write_performed | 0 |
command_buffer_too_small | 0 |
connect_success | 1 |
connect_failure | 0 |
connection_reused | 0 |
reconnect | 0 |
pconnect_success | 1 |
active_connections | 1 |
active_persistent_connections | 1 |
explicit_close | 0 |
implicit_close | 0 |
disconnect_close | 0 |
in_middle_of_command_close | 0 |
explicit_free_result | 0 |
implicit_free_result | 0 |
explicit_stmt_close | 0 |
implicit_stmt_close | 0 |
mem_emalloc_count | 0 |
mem_emalloc_amount | 0 |
mem_ecalloc_count | 0 |
mem_ecalloc_amount | 0 |
mem_erealloc_count | 0 |
mem_erealloc_amount | 0 |
mem_efree_count | 0 |
mem_efree_amount | 0 |
mem_malloc_count | 0 |
mem_malloc_amount | 0 |
mem_calloc_count | 0 |
mem_calloc_amount | 0 |
mem_realloc_count | 0 |
mem_realloc_amount | 0 |
mem_free_count | 0 |
mem_free_amount | 0 |
mem_estrndup_count | 0 |
mem_strndup_count | 0 |
mem_estrdup_count | 0 |
mem_strdup_count | 0 |
mem_edupl_count | 0 |
mem_dupl_count | 0 |
proto_text_fetched_null | 0 |
proto_text_fetched_bit | 0 |
proto_text_fetched_tinyint | 0 |
proto_text_fetched_short | 0 |
proto_text_fetched_int24 | 0 |
proto_text_fetched_int | 0 |
proto_text_fetched_bigint | 0 |
proto_text_fetched_decimal | 0 |
proto_text_fetched_float | 0 |
proto_text_fetched_double | 0 |
proto_text_fetched_date | 0 |
proto_text_fetched_year | 0 |
proto_text_fetched_time | 0 |
proto_text_fetched_datetime | 0 |
proto_text_fetched_timestamp | 0 |
proto_text_fetched_string | 0 |
proto_text_fetched_blob | 0 |
proto_text_fetched_enum | 0 |
proto_text_fetched_set | 0 |
proto_text_fetched_geometry | 0 |
proto_text_fetched_other | 0 |
proto_binary_fetched_null | 0 |
proto_binary_fetched_bit | 287 |
proto_binary_fetched_tinyint | 0 |
proto_binary_fetched_short | 791 |
proto_binary_fetched_int24 | 202 |
proto_binary_fetched_int | 0 |
proto_binary_fetched_bigint | 2465 |
proto_binary_fetched_decimal | 88 |
proto_binary_fetched_float | 145 |
proto_binary_fetched_double | 0 |
proto_binary_fetched_date | 0 |
proto_binary_fetched_year | 0 |
proto_binary_fetched_time | 0 |
proto_binary_fetched_datetime | 0 |
proto_binary_fetched_timestamp | 0 |
proto_binary_fetched_string | 0 |
proto_binary_fetched_json | 1430 |
proto_binary_fetched_blob | 1167 |
proto_binary_fetched_enum | 0 |
proto_binary_fetched_set | 0 |
proto_binary_fetched_geometry | 0 |
proto_binary_fetched_other | 0 |
init_command_executed_count | 0 |
init_command_failed_count | 0 |
com_quit | 0 |
com_init_db | 0 |
com_query | 2 |
com_field_list | 0 |
com_create_db | 0 |
com_drop_db | 0 |
com_refresh | 0 |
com_shutdown | 0 |
com_statistics | 0 |
com_process_info | 0 |
com_connect | 0 |
com_process_kill | 0 |
com_debug | 0 |
com_ping | 0 |
com_time | 0 |
com_delayed_insert | 0 |
com_change_user | 0 |
com_binlog_dump | 0 |
com_table_dump | 0 |
com_connect_out | 0 |
com_register_slave | 0 |
com_stmt_prepare | 34 |
com_stmt_execute | 34 |
com_stmt_send_long_data | 0 |
com_stmt_close | 33 |
com_stmt_reset | 0 |
com_stmt_set_option | 0 |
com_stmt_fetch | 0 |
com_deamon | 0 |
bytes_received_real_data_normal | 0 |
bytes_received_real_data_ps | 1048326 |