SELECT `xf_thread`.*, `xf_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_user_User_3`.*, `xf_post_FirstPost_4`.*, `xf_permission_cache_content_Permissions_5`.*
FROM `xf_thread`
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_post` AS `xf_post_FirstPost_4` ON (`xf_post_FirstPost_4`.`post_id` = `xf_thread`.`first_post_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_2`.`node_id` AND `xf_permission_cache_content_Permissions_5`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (53391, 53298, 53180, 53018, 52929, 52106, 52085, 52084, 48058, 47235, 47233, 47218, 47217, 47216, 47215, 47211, 47194, 47193, 47189, 47187, 47179, 47178, 47174, 47167, 47165, 47164, 47161, 47153, 47135, 47134, 47119, 47117, 47113, 47088, 47072, 47067, 47056, 47054, 46899, 46815, 46777, 46687, 46673, 46668, 46617, 46616, 46601, 46566, 46563, 46549, 46547, 46515, 46513, 46508, 46505, 46489, 46487, 46486, 46455, 46452, 46451, 46443, 46436, 46429, 46425, 46424, 46423, 46420, 46419, 46418, 46416, 46409, 46405, 46401, 46390, 46388, 46386, 46383, 46380, 46378, 46375, 46372, 46371, 46370, 46369, 46363, 46362, 46360, 46358, 46356, 46344, 46342, 46341, 46337))
Run Time: 0.114076
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 94 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | thxforg_thxf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thxforg_thxf.xf_node_Node_2.node_id | 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 1445
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 226
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 3006
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 77
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 731
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 230
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 214
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 138
- XF\Pub\Controller\Tag->actionTag() 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 2592
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20
INSERT INTO `xf_tag_result_cache` (`tag_id`, `user_id`, `expiry_date`, `results`, `result_cache_id`, `cache_date`) VALUES (?, ?, ?, ?, ?, ?)
Params: 5, 0, 1714320221, {"thread-53391":["thread",53391],"thread-53298":["thread",53298],"thread-53180":["thread",53180],"thread-53018":["thread",53018],"thread-52929":["thread",52929],"thread-52106":["thread",52106],"thread-52085":["thread",52085],"thread-52084":["thread",52084],"thread-48058":["thread",48058],"resource-61":["resource",61],"resource-57":["resource",57],"resource-30":["resource",30],"thread-47235":["thread",47235],"thread-47233":["thread",47233],"thread-47218":["thread",47218],"thread-47217":["thread",47217],"thread-47216":["thread",47216],"thread-47215":["thread",47215],"thread-47211":["thread",47211],"thread-47194":["thread",47194],"thread-47193":["thread",47193],"thread-47189":["thread",47189],"thread-47187":["thread",47187],"thread-47179":["thread",47179],"thread-47178":["thread",47178],"thread-47174":["thread",47174],"thread-47167":["thread",47167],"thread-47165":["thread",47165],"thread-47164":["thread",47164],"thread-47161":["thread",47161],"thread-47135":["thread",47135],"thread-47134":["thread",47134],"thread-47119":["thread",47119],"thread-47117":["thread",47117],"thread-47113":["thread",47113],"thread-47088":["thread",47088],"thread-47072":["thread",47072],"thread-47067":["thread",47067],"thread-47056":["thread",47056],"thread-47054":["thread",47054],"thread-46899":["thread",46899],"thread-46815":["thread",46815],"thread-46777":["thread",46777],"thread-46687":["thread",46687],"thread-46673":["thread",46673],"thread-46668":["thread",46668],"thread-46617":["thread",46617],"thread-46616":["thread",46616],"thread-46601":["thread",46601],"thread-46566":["thread",46566],"thread-46563":["thread",46563],"thread-46549":["thread",46549],"thread-46547":["thread",46547],"thread-46515":["thread",46515],"thread-46513":["thread",46513],"thread-46508":["thread",46508],"thread-46505":["thread",46505],"thread-46489":["thread",46489],"thread-46487":["thread",46487],"thread-46486":["thread",46486],"thread-46455":["thread",46455],"thread-46452":["thread",46452],"thread-46451":["thread",46451],"thread-46443":["thread",46443],"thread-46436":["thread",46436],"thread-46429":["thread",46429],"thread-46425":["thread",46425],"thread-46424":["thread",46424],"thread-46423":["thread",46423],"thread-46420":["thread",46420],"thread-46419":["thread",46419],"thread-46418":["thread",46418],"thread-46416":["thread",46416],"thread-46409":["thread",46409],"thread-46405":["thread",46405],"thread-46401":["thread",46401],"thread-46390":["thread",46390],"thread-46388":["thread",46388],"thread-46386":["thread",46386],"thread-46383":["thread",46383],"thread-46380":["thread",46380],"thread-46378":["thread",46378],"thread-46375":["thread",46375],"thread-46372":["thread",46372],"thread-46371":["thread",46371],"thread-46370":["thread",46370],"thread-46369":["thread",46369],"thread-46363":["thread",46363],"thread-46362":["thread",46362],"thread-46360":["thread",46360],"thread-46358":["thread",46358],"thread-46356":["thread",46356],"thread-46344":["thread",46344],"thread-46342":["thread",46342],"thread-46341":["thread",46341],"thread-46337":["thread",46337]}, NULL, 1714316621
Run Time: 0.003123
- 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 220
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1558
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1290
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- XF\Pub\Controller\Tag->actionTag() 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 2592
- XF\App->run() in src/XF.php at line 532
- XF::runApp() in index.php at line 20