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 (181955, 181753, 174400, 174399, 169445, 169357, 168181, 166052, 165741, 165489, 165217, 165107, 165106, 164825, 164586, 163848, 162766, 161985, 161062, 160612, 158483, 158482, 158455, 157971, 157798, 155793, 155791, 155749, 155748, 155725, 155685, 147801, 147343, 147264, 146764, 146746, 145639, 145349, 145344, 144663, 144463, 144385, 144358, 144246, 144048, 144041, 144032, 143988, 143424, 142255, 142241, 142154, 139302, 139297, 139260, 139227, 139225, 139221, 139206, 139197, 138378, 138256, 138160, 138113, 138039, 138032, 137974, 137969, 137963, 134617, 133637, 133511, 133508, 133486, 133408, 133394, 133367, 132939, 132935, 132931))
Run Time: 0.044362
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 80 | 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: 34451, 0, 1716633783, {"thread-181955":["thread",181955],"thread-181753":["thread",181753],"thread-174400":["thread",174400],"thread-174399":["thread",174399],"thread-169445":["thread",169445],"thread-169357":["thread",169357],"thread-168181":["thread",168181],"thread-166052":["thread",166052],"thread-165741":["thread",165741],"thread-165489":["thread",165489],"thread-165217":["thread",165217],"thread-165107":["thread",165107],"thread-165106":["thread",165106],"thread-164825":["thread",164825],"thread-164586":["thread",164586],"thread-163848":["thread",163848],"thread-162766":["thread",162766],"thread-161985":["thread",161985],"thread-161062":["thread",161062],"thread-160612":["thread",160612],"thread-158483":["thread",158483],"thread-158482":["thread",158482],"thread-158455":["thread",158455],"thread-157971":["thread",157971],"thread-157798":["thread",157798],"thread-155793":["thread",155793],"thread-155791":["thread",155791],"thread-155749":["thread",155749],"thread-155748":["thread",155748],"thread-155725":["thread",155725],"thread-155685":["thread",155685],"thread-147801":["thread",147801],"thread-147343":["thread",147343],"thread-147264":["thread",147264],"thread-146764":["thread",146764],"thread-146746":["thread",146746],"thread-145639":["thread",145639],"thread-145349":["thread",145349],"thread-145344":["thread",145344],"thread-144663":["thread",144663],"thread-144463":["thread",144463],"thread-144385":["thread",144385],"thread-144358":["thread",144358],"thread-144246":["thread",144246],"thread-144048":["thread",144048],"thread-144041":["thread",144041],"thread-144032":["thread",144032],"thread-143988":["thread",143988],"thread-143424":["thread",143424],"thread-142255":["thread",142255],"thread-142241":["thread",142241],"thread-142154":["thread",142154],"thread-139302":["thread",139302],"thread-139297":["thread",139297],"thread-139260":["thread",139260],"thread-139227":["thread",139227],"thread-139225":["thread",139225],"thread-139221":["thread",139221],"thread-139206":["thread",139206],"thread-139197":["thread",139197],"thread-138378":["thread",138378],"thread-138256":["thread",138256],"thread-138160":["thread",138160],"thread-138113":["thread",138113],"thread-138039":["thread",138039],"thread-138032":["thread",138032],"thread-137974":["thread",137974],"thread-137969":["thread",137969],"thread-137963":["thread",137963],"thread-134617":["thread",134617],"thread-133637":["thread",133637],"thread-133511":["thread",133511],"thread-133508":["thread",133508],"thread-133486":["thread",133486],"thread-133408":["thread",133408],"thread-133394":["thread",133394],"thread-133367":["thread",133367],"thread-132939":["thread",132939],"thread-132935":["thread",132935],"thread-132931":["thread",132931]}, , 1716630183
Run Time: 0.000303
- 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