SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000124
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 96
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 152
- XF\Db\AbstractAdapter->fetchOne() in src/XF/PermissionCache.php at line 34
- XF\PermissionCache->getGlobalPerms() in src/XF/PermissionSet.php at line 35
- XF\PermissionSet->hasGlobalPermission() in src/XF/Entity/User.php at line 1219
- XF\Entity\User->hasPermission() in src/XF/Pub/Controller/AbstractController.php at line 245
- XF\Pub\Controller\AbstractController->assertViewingPermissions() in src/XF/Pub/Controller/AbstractController.php at line 23
- XF\Pub\Controller\AbstractController->preDispatchType() in src/XF/Mvc/Controller.php at line 126
- XF\Mvc\Controller->preDispatch() in src/XF/Mvc/Dispatcher.php at line 351
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_tl_post_reply_root_PostReplyRoot_2`.*, `xf_es_thread_similar_XFES_SimilarThreads_3`.*, `xf_forum_Forum_4`.*, `xf_node_Node_5`.*, `xf_permission_cache_content_Permissions_6`.*
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_tl_post_reply_root` AS `xf_tl_post_reply_root_PostReplyRoot_2` ON (`xf_tl_post_reply_root_PostReplyRoot_2`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_es_thread_similar` AS `xf_es_thread_similar_XFES_SimilarThreads_3` ON (`xf_es_thread_similar_XFES_SimilarThreads_3`.`thread_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_4` ON (`xf_forum_Forum_4`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_5` ON (`xf_node_Node_5`.`node_id` = `xf_forum_Forum_4`.`node_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_6` ON (`xf_permission_cache_content_Permissions_6`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_6`.`content_id` = `xf_node_Node_5`.`node_id` AND `xf_permission_cache_content_Permissions_6`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` = '988457')
LIMIT 1
Run Time: 0.025554
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_tl_post_reply_root_PostReplyRoot_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_es_thread_similar_XFES_SimilarThreads_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_4 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_5 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_6 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1397
- XF\Mvc\Entity\Finder->fetchOne() in src/XF/Mvc/Entity/Manager.php at line 151
- XF\Mvc\Entity\Manager->find() in src/XF/Pub/Controller/Thread.php at line 1635
- XF\Pub\Controller\Thread->assertViewableThread() in src/XF/Pub/Controller/Thread.php at line 17
- XF\Pub\Controller\Thread->actionIndex() in src/addons/OzzModz/WhoReadThread/XF/Pub/Controller/Thread.php at line 11
- OzzModz\WhoReadThread\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/PostReply/XF/Pub/Controller/Thread.php at line 18
- Truonglv\PostReply\XF\Pub\Controller\Thread->actionIndex() in src/addons/TickTackk/SignatureOnce/XF/Pub/Controller/Thread.php at line 32
- TickTackk\SignatureOnce\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- 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_permission_combination_PermissionCombination_5`.*, `xf_session_activity_Activity_6`.*, `xf_tl_post_reply_item_PostReplyItem_7`.*, `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.*
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`, ''))
LEFT JOIN `xf_tl_post_reply_item` AS `xf_tl_post_reply_item_PostReplyItem_7` ON (`xf_tl_post_reply_item_PostReplyItem_7`.`post_id` = `xf_post`.`post_id`)
LEFT JOIN `xf_tck_signature_once_container_first_user_content` AS `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8` ON (`xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`user_id` = `xf_post`.`user_id` AND `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`container_type` = 'thread' AND `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`container_id` = `xf_post`.`thread_id` AND `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`content_type` = 'post')
WHERE (`xf_post`.`thread_id` = 988457) 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.040973
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_score_date | thread_id_post_date | 4 | const | 1 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_5 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_user_User_1.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_6 | eq_ref | PRIMARY | PRIMARY | 22 | cmclubcom_xf2xx.xf_user_User_1.user_id,func | 1 | Using where |
SIMPLE | xf_tl_post_reply_item_PostReplyItem_7 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_post.post_id | 1 | |
SIMPLE | xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8 | eq_ref | user_id_container_type_container_id_content_type,container_type_container_id | user_id_container_type_container_id_content_type | 62 | cmclubcom_xf2xx.xf_post.user_id,const,const,const | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Pub/Controller/Thread.php at line 65
- XF\Pub\Controller\Thread->actionIndex() in src/addons/OzzModz/WhoReadThread/XF/Pub/Controller/Thread.php at line 11
- OzzModz\WhoReadThread\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/PostReply/XF/Pub/Controller/Thread.php at line 18
- Truonglv\PostReply\XF\Pub\Controller\Thread->actionIndex() in src/addons/TickTackk/SignatureOnce/XF/Pub/Controller/Thread.php at line 32
- TickTackk\SignatureOnce\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT `xf_unfurl_result`.*
FROM `xf_unfurl_result`
WHERE (`xf_unfurl_result`.`result_id` IN (30667, 30668, 30669, 30670, 30671))
Run Time: 0.010727
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_unfurl_result | range | PRIMARY | PRIMARY | 4 | | 5 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/XF/Repository/Unfurl.php at line 92
- XF\Repository\Unfurl->addUnfurlsToContent() in src/XF/ControllerPlugin/Thread.php at line 59
- XF\ControllerPlugin\Thread->fetchExtraContentForPostsFullView() in src/XF/Pub/Controller/Thread.php at line 110
- XF\Pub\Controller\Thread->actionIndex() in src/addons/OzzModz/WhoReadThread/XF/Pub/Controller/Thread.php at line 11
- OzzModz\WhoReadThread\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/PostReply/XF/Pub/Controller/Thread.php at line 18
- Truonglv\PostReply\XF\Pub\Controller\Thread->actionIndex() in src/addons/TickTackk/SignatureOnce/XF/Pub/Controller/Thread.php at line 32
- TickTackk\SignatureOnce\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
-- XFDB=noForceAllWrite
INSERT INTO xf_thread_view
(thread_id, total)
VALUES
(? , 1)
ON DUPLICATE KEY UPDATE
total = total + 1
Params: 988457
Run Time: 0.000119
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Repository/Thread.php at line 194
- XF\Repository\Thread->logThreadView() in src/XF/Pub/Controller/Thread.php at line 141
- XF\Pub\Controller\Thread->actionIndex() in src/addons/OzzModz/WhoReadThread/XF/Pub/Controller/Thread.php at line 11
- OzzModz\WhoReadThread\XF\Pub\Controller\Thread->actionIndex() in src/addons/Truonglv/PostReply/XF/Pub/Controller/Thread.php at line 18
- Truonglv\PostReply\XF\Pub\Controller\Thread->actionIndex() in src/addons/TickTackk/SignatureOnce/XF/Pub/Controller/Thread.php at line 32
- TickTackk\SignatureOnce\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- 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_permission_combination_PermissionCombination_5`.*, `xf_session_activity_Activity_6`.*, `xf_tl_post_reply_item_PostReplyItem_7`.*, `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.*
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`, ''))
LEFT JOIN `xf_tl_post_reply_item` AS `xf_tl_post_reply_item_PostReplyItem_7` ON (`xf_tl_post_reply_item_PostReplyItem_7`.`post_id` = `xf_post`.`post_id`)
LEFT JOIN `xf_tck_signature_once_container_first_user_content` AS `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8` ON (`xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`user_id` = `xf_post`.`user_id` AND `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`container_type` = 'thread' AND `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`container_id` = `xf_post`.`thread_id` AND `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`content_type` = 'post')
WHERE (1 = 0)
Run Time: 0.000953
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 96
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1430
- XF\Mvc\Entity\Finder->fetch() in src/addons/Truonglv/PostReply/Repository/Item.php at line 46
- Truonglv\PostReply\Repository\Item->addRepliesIntoPosts() in src/addons/Truonglv/PostReply/XF/Pub/Controller/Thread.php at line 37
- Truonglv\PostReply\XF\Pub\Controller\Thread->actionIndex() in src/addons/TickTackk/SignatureOnce/XF/Pub/Controller/Thread.php at line 32
- TickTackk\SignatureOnce\XF\Pub\Controller\Thread->actionIndex() in src/XF/Mvc/Dispatcher.php at line 352
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 259
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 115
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 57
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20
SELECT view_date
FROM xf_session_activity
WHERE user_id = ? AND unique_key = ?
Params: 0, "