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 (183046, 182622, 182206, 181399, 181398, 181384, 181333, 180618, 180107, 179372, 178348, 177940, 177333, 176816, 176626, 176315, 176272, 176117, 175666, 175661, 175660, 175503, 175497, 175489, 175409, 175334, 175236, 174214, 173905, 173332, 173327, 173312, 171615, 171156, 170639, 170098, 169884, 169829, 168547, 167630, 167324, 166918, 165926, 165907, 164268, 163823, 163766, 163720, 163486, 162152, 159228, 158950, 158835, 158394, 158329, 157557, 157304, 157189, 153599, 153338, 153272, 152696, 152096, 151202, 150567, 146657, 145669, 143801, 143784, 143166, 141954, 139650, 139420, 135135, 133670))
Run Time: 0.039097
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 75 | 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: 34555, 0, 1716131038, {"thread-183046":["thread",183046],"thread-182622":["thread",182622],"thread-182206":["thread",182206],"thread-181399":["thread",181399],"thread-181398":["thread",181398],"thread-181384":["thread",181384],"thread-181333":["thread",181333],"thread-180618":["thread",180618],"thread-180107":["thread",180107],"thread-179372":["thread",179372],"thread-178348":["thread",178348],"thread-177940":["thread",177940],"thread-177333":["thread",177333],"thread-176816":["thread",176816],"thread-176626":["thread",176626],"thread-176315":["thread",176315],"thread-176272":["thread",176272],"thread-176117":["thread",176117],"thread-175666":["thread",175666],"thread-175661":["thread",175661],"thread-175660":["thread",175660],"thread-175503":["thread",175503],"thread-175497":["thread",175497],"thread-175489":["thread",175489],"thread-175409":["thread",175409],"thread-175334":["thread",175334],"thread-175236":["thread",175236],"thread-174214":["thread",174214],"thread-173905":["thread",173905],"thread-173332":["thread",173332],"thread-173327":["thread",173327],"thread-173312":["thread",173312],"thread-171615":["thread",171615],"thread-171156":["thread",171156],"thread-170639":["thread",170639],"thread-170098":["thread",170098],"thread-169884":["thread",169884],"thread-169829":["thread",169829],"thread-168547":["thread",168547],"thread-167630":["thread",167630],"thread-167324":["thread",167324],"thread-166918":["thread",166918],"thread-165926":["thread",165926],"thread-165907":["thread",165907],"thread-164268":["thread",164268],"thread-163823":["thread",163823],"thread-163766":["thread",163766],"thread-163720":["thread",163720],"thread-163486":["thread",163486],"thread-162152":["thread",162152],"thread-159228":["thread",159228],"thread-158950":["thread",158950],"thread-158835":["thread",158835],"thread-158394":["thread",158394],"thread-158329":["thread",158329],"thread-157557":["thread",157557],"thread-157304":["thread",157304],"thread-157189":["thread",157189],"thread-153599":["thread",153599],"thread-153338":["thread",153338],"thread-153272":["thread",153272],"thread-152696":["thread",152696],"thread-152096":["thread",152096],"thread-151202":["thread",151202],"thread-150567":["thread",150567],"thread-146657":["thread",146657],"thread-145669":["thread",145669],"thread-143801":["thread",143801],"thread-143784":["thread",143784],"thread-143166":["thread",143166],"thread-141954":["thread",141954],"thread-139650":["thread",139650],"thread-139420":["thread",139420],"thread-135135":["thread",135135],"thread-133670":["thread",133670]}, , 1716127438
Run Time: 0.000268
- 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