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 (183343, 181237, 180890, 180880, 180806, 180592, 180225, 180217, 180031, 179809, 179647, 179540, 179409, 178095, 177757, 177327, 176967, 176953, 176583, 176572, 176402, 174017, 173766, 173115, 173066, 172915, 172401, 171752, 171551, 171318, 170525, 170336, 169090, 169028, 168831, 167070, 166851, 166576, 166231, 166074, 165902, 165851, 165224, 165031, 164706, 164577, 164554, 164432, 164052, 163624, 163322, 163040, 162334, 162202, 161726, 161254, 161091, 160416, 160307, 160054, 159225, 158617, 158505, 158340, 158264, 157829, 157819, 157815, 157031, 156859, 156115, 155859, 155829, 155641, 154047, 154024, 153381, 153314, 153292, 151694, 70835))
Run Time: 0.054347
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 81 | 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: 13575, 0, 1716628566, {"thread-183343":["thread",183343],"thread-181237":["thread",181237],"thread-180890":["thread",180890],"thread-180880":["thread",180880],"thread-180806":["thread",180806],"thread-180592":["thread",180592],"thread-180225":["thread",180225],"thread-180217":["thread",180217],"thread-180031":["thread",180031],"thread-179809":["thread",179809],"thread-179647":["thread",179647],"thread-179540":["thread",179540],"thread-179409":["thread",179409],"thread-178095":["thread",178095],"thread-177757":["thread",177757],"thread-177327":["thread",177327],"thread-176967":["thread",176967],"thread-176953":["thread",176953],"thread-176583":["thread",176583],"thread-176572":["thread",176572],"thread-176402":["thread",176402],"thread-174017":["thread",174017],"thread-173766":["thread",173766],"thread-173115":["thread",173115],"thread-173066":["thread",173066],"thread-172915":["thread",172915],"thread-172401":["thread",172401],"thread-171752":["thread",171752],"thread-171551":["thread",171551],"thread-171318":["thread",171318],"thread-170525":["thread",170525],"thread-170336":["thread",170336],"thread-169090":["thread",169090],"thread-169028":["thread",169028],"thread-168831":["thread",168831],"thread-167070":["thread",167070],"thread-166851":["thread",166851],"thread-166576":["thread",166576],"thread-166231":["thread",166231],"thread-166074":["thread",166074],"thread-165902":["thread",165902],"thread-165851":["thread",165851],"thread-165224":["thread",165224],"thread-165031":["thread",165031],"thread-164706":["thread",164706],"thread-164577":["thread",164577],"thread-164554":["thread",164554],"thread-164432":["thread",164432],"thread-164052":["thread",164052],"thread-163624":["thread",163624],"thread-163322":["thread",163322],"thread-163040":["thread",163040],"thread-162334":["thread",162334],"thread-162202":["thread",162202],"thread-161726":["thread",161726],"thread-161254":["thread",161254],"thread-161091":["thread",161091],"thread-160416":["thread",160416],"thread-160307":["thread",160307],"thread-160054":["thread",160054],"thread-159225":["thread",159225],"thread-158617":["thread",158617],"thread-158505":["thread",158505],"thread-158340":["thread",158340],"thread-158264":["thread",158264],"thread-157829":["thread",157829],"thread-157819":["thread",157819],"thread-157815":["thread",157815],"thread-157031":["thread",157031],"thread-156859":["thread",156859],"thread-156115":["thread",156115],"thread-155859":["thread",155859],"thread-155829":["thread",155829],"thread-155641":["thread",155641],"thread-154047":["thread",154047],"thread-154024":["thread",154024],"thread-153381":["thread",153381],"thread-153314":["thread",153314],"thread-153292":["thread",153292],"thread-151694":["thread",151694],"thread-70835":["thread",70835]}, , 1716624966
Run Time: 0.000156
- 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