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 (183467, 183141, 182538, 182527, 181420, 180261, 180253, 180252, 180251, 180250, 180249, 180246, 180245, 180244, 180242, 179406, 179298, 179167, 176009, 176001, 175546, 175254, 173314, 173301, 170982, 170973, 170556, 170042, 169957, 168648, 168585, 168254, 168249, 167691, 166473, 166413, 166411, 166398, 166397, 166312, 166311, 166052, 165741, 165545, 165533, 165489, 165390, 165388, 165386, 165385, 165384, 165383, 165217, 164825, 164421, 164420, 164295, 164107, 164015, 164014, 163455, 162636, 162407, 162109, 162106, 161889, 158569, 158127, 157878, 157798, 156734, 156733, 156732, 156708, 156707, 156700, 156699, 156697, 156695, 156694, 156176, 155898, 155433, 155432, 155429, 155420, 155419, 155418, 155417, 155416, 155415, 155414, 155413, 155412, 155411, 155410, 155409, 155408, 155407, 155406, 153112, 153110, 152579, 152576, 68569, 60113))
Run Time: 0.038763
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 106 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 1387
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 214
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2729
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- 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 137
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 10499, 0, 1715925296, {"thread-183467":["thread",183467],"thread-183141":["thread",183141],"thread-182538":["thread",182538],"thread-182527":["thread",182527],"thread-181420":["thread",181420],"thread-180261":["thread",180261],"thread-180253":["thread",180253],"thread-180252":["thread",180252],"thread-180251":["thread",180251],"thread-180250":["thread",180250],"thread-180249":["thread",180249],"thread-180246":["thread",180246],"thread-180245":["thread",180245],"thread-180244":["thread",180244],"thread-180242":["thread",180242],"thread-179406":["thread",179406],"thread-179298":["thread",179298],"thread-179167":["thread",179167],"thread-176009":["thread",176009],"thread-176001":["thread",176001],"thread-175546":["thread",175546],"thread-175254":["thread",175254],"thread-173314":["thread",173314],"thread-173301":["thread",173301],"thread-170982":["thread",170982],"thread-170973":["thread",170973],"thread-170042":["thread",170042],"thread-169957":["thread",169957],"thread-168648":["thread",168648],"thread-168585":["thread",168585],"thread-168254":["thread",168254],"thread-168249":["thread",168249],"thread-167691":["thread",167691],"thread-166473":["thread",166473],"thread-166413":["thread",166413],"thread-166411":["thread",166411],"thread-166398":["thread",166398],"thread-166397":["thread",166397],"thread-166312":["thread",166312],"thread-166311":["thread",166311],"thread-166052":["thread",166052],"thread-165741":["thread",165741],"thread-165545":["thread",165545],"thread-165533":["thread",165533],"thread-165489":["thread",165489],"thread-165390":["thread",165390],"thread-165388":["thread",165388],"thread-165386":["thread",165386],"thread-165385":["thread",165385],"thread-165384":["thread",165384],"thread-165383":["thread",165383],"thread-165217":["thread",165217],"thread-164825":["thread",164825],"thread-164421":["thread",164421],"thread-164420":["thread",164420],"thread-164295":["thread",164295],"thread-164107":["thread",164107],"thread-164015":["thread",164015],"thread-164014":["thread",164014],"thread-163455":["thread",163455],"thread-162636":["thread",162636],"thread-162407":["thread",162407],"thread-162109":["thread",162109],"thread-162106":["thread",162106],"thread-161889":["thread",161889],"thread-158569":["thread",158569],"thread-158127":["thread",158127],"thread-157878":["thread",157878],"thread-157798":["thread",157798],"thread-156734":["thread",156734],"thread-156733":["thread",156733],"thread-156732":["thread",156732],"thread-156708":["thread",156708],"thread-156707":["thread",156707],"thread-156700":["thread",156700],"thread-156699":["thread",156699],"thread-156697":["thread",156697],"thread-156695":["thread",156695],"thread-156694":["thread",156694],"thread-156176":["thread",156176],"thread-155898":["thread",155898],"thread-155433":["thread",155433],"thread-155432":["thread",155432],"thread-155429":["thread",155429],"thread-155420":["thread",155420],"thread-155419":["thread",155419],"thread-155418":["thread",155418],"thread-155417":["thread",155417],"thread-155416":["thread",155416],"thread-155415":["thread",155415],"thread-155414":["thread",155414],"thread-155413":["thread",155413],"thread-155412":["thread",155412],"thread-155411":["thread",155411],"thread-155410":["thread",155410],"thread-155409":["thread",155409],"thread-155408":["thread",155408],"thread-155407":["thread",155407],"thread-155406":["thread",155406],"thread-153112":["thread",153112],"thread-153110":["thread",153110],"thread-152579":["thread",152579],"thread-152576":["thread",152576],"thread-68569":["thread",68569],"thread-60113":["thread",60113]}, , 1715921696
Run Time: 0.000343
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20