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 (183171, 182950, 182253, 182132, 181173, 180190, 180020, 179391, 179014, 178972, 178717, 178162, 178149, 177267, 177213, 176618, 176363, 176039, 175743, 174062, 172942, 172419, 171870, 171315, 170967, 170508, 170418, 169274, 169122, 169086, 169078, 168945, 168435, 168152, 167431, 167259, 167087, 165958, 165328, 165092, 164822, 163585, 163282, 162902, 162690, 162657, 162656, 162201, 161782, 160517, 160268, 159728, 159727, 159517, 159338, 158766, 158757, 158600, 158393, 158389, 158286, 158242, 158060, 157829, 157691, 157428, 157383, 157085, 156923, 156761, 156585, 156583, 156396, 156337, 156299, 156205, 156117, 155259, 155202, 154668, 154614, 154553, 153881, 153048, 152759, 152100, 94012, 80012, 78686))
Run Time: 0.041076
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 89 | 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: 16083, 0, 1715995984, {"thread-183171":["thread",183171],"thread-182950":["thread",182950],"thread-182253":["thread",182253],"thread-182132":["thread",182132],"thread-181173":["thread",181173],"thread-180190":["thread",180190],"thread-180020":["thread",180020],"thread-179391":["thread",179391],"thread-179014":["thread",179014],"thread-178972":["thread",178972],"thread-178717":["thread",178717],"thread-178162":["thread",178162],"thread-178149":["thread",178149],"thread-177267":["thread",177267],"thread-177213":["thread",177213],"thread-176618":["thread",176618],"thread-176363":["thread",176363],"thread-176039":["thread",176039],"thread-175743":["thread",175743],"thread-174062":["thread",174062],"thread-172942":["thread",172942],"thread-172419":["thread",172419],"thread-171870":["thread",171870],"thread-171315":["thread",171315],"thread-170967":["thread",170967],"thread-170508":["thread",170508],"thread-170418":["thread",170418],"thread-169274":["thread",169274],"thread-169122":["thread",169122],"thread-169086":["thread",169086],"thread-169078":["thread",169078],"thread-168945":["thread",168945],"thread-168435":["thread",168435],"thread-168152":["thread",168152],"thread-167431":["thread",167431],"thread-167259":["thread",167259],"thread-167087":["thread",167087],"thread-165958":["thread",165958],"thread-165328":["thread",165328],"thread-165092":["thread",165092],"thread-164822":["thread",164822],"thread-163585":["thread",163585],"thread-163282":["thread",163282],"thread-162902":["thread",162902],"thread-162690":["thread",162690],"thread-162657":["thread",162657],"thread-162656":["thread",162656],"thread-162201":["thread",162201],"thread-161782":["thread",161782],"thread-160517":["thread",160517],"thread-160268":["thread",160268],"thread-159728":["thread",159728],"thread-159727":["thread",159727],"thread-159517":["thread",159517],"thread-159338":["thread",159338],"thread-158766":["thread",158766],"thread-158757":["thread",158757],"thread-158600":["thread",158600],"thread-158393":["thread",158393],"thread-158389":["thread",158389],"thread-158286":["thread",158286],"thread-158242":["thread",158242],"thread-158060":["thread",158060],"thread-157829":["thread",157829],"thread-157691":["thread",157691],"thread-157428":["thread",157428],"thread-157383":["thread",157383],"thread-157085":["thread",157085],"thread-156923":["thread",156923],"thread-156761":["thread",156761],"thread-156585":["thread",156585],"thread-156583":["thread",156583],"thread-156396":["thread",156396],"thread-156337":["thread",156337],"thread-156299":["thread",156299],"thread-156205":["thread",156205],"thread-156117":["thread",156117],"thread-155259":["thread",155259],"thread-155202":["thread",155202],"thread-154668":["thread",154668],"thread-154614":["thread",154614],"thread-154553":["thread",154553],"thread-153881":["thread",153881],"thread-153048":["thread",153048],"thread-152759":["thread",152759],"thread-152100":["thread",152100],"thread-94012":["thread",94012],"thread-80012":["thread",80012],"thread-78686":["thread",78686]}, , 1715992384
Run Time: 0.000819
- 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