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 (182472, 172223, 171966, 166952, 158763, 157760, 154980, 154791, 154763, 154592, 154508, 154308, 154300, 154205, 154202, 154187, 154024, 153908, 153907, 153857, 153854, 153749, 153741, 153740, 153725, 153419, 153280, 153210, 153161, 153142, 153078, 152930, 152912, 152875, 152770, 152585, 152545, 152529, 152351, 152332, 152309, 152298, 152217, 152186, 152058, 151851, 97001, 86043, 77913, 76230, 61536, 19774))
Run Time: 0.032801
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 52 | 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: 2638, 0, 1716098766, {"thread-182472":["thread",182472],"thread-172223":["thread",172223],"thread-171966":["thread",171966],"thread-166952":["thread",166952],"thread-158763":["thread",158763],"thread-157760":["thread",157760],"thread-154980":["thread",154980],"thread-154791":["thread",154791],"thread-154763":["thread",154763],"thread-154592":["thread",154592],"thread-154508":["thread",154508],"thread-154308":["thread",154308],"thread-154300":["thread",154300],"thread-154205":["thread",154205],"thread-154202":["thread",154202],"thread-154187":["thread",154187],"thread-154024":["thread",154024],"thread-153908":["thread",153908],"thread-153907":["thread",153907],"thread-153854":["thread",153854],"thread-153749":["thread",153749],"thread-153741":["thread",153741],"thread-153740":["thread",153740],"thread-153725":["thread",153725],"thread-153419":["thread",153419],"thread-153280":["thread",153280],"thread-153210":["thread",153210],"thread-153161":["thread",153161],"thread-153142":["thread",153142],"thread-153078":["thread",153078],"thread-152930":["thread",152930],"thread-152912":["thread",152912],"thread-152875":["thread",152875],"thread-152770":["thread",152770],"thread-152585":["thread",152585],"thread-152545":["thread",152545],"thread-152529":["thread",152529],"thread-152351":["thread",152351],"thread-152332":["thread",152332],"thread-152309":["thread",152309],"thread-152298":["thread",152298],"thread-152217":["thread",152217],"thread-152186":["thread",152186],"thread-152058":["thread",152058],"thread-151851":["thread",151851],"thread-97001":["thread",97001],"thread-86043":["thread",86043],"thread-77913":["thread",77913],"thread-76230":["thread",76230],"thread-61536":["thread",61536],"thread-19774":["thread",19774]}, , 1716095166
Run Time: 0.000192
- 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