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 (182591, 182588, 180937, 180276, 180272, 178459, 178380, 175325, 174295, 174293, 173016, 171731, 171669, 171668, 169236, 168333, 166201, 165435, 165344, 165007, 163929, 163822, 163040, 162847, 162614, 162252, 162173, 162161, 162068, 162067, 161665, 160922, 160131, 158943, 158828, 158810, 158441, 157913, 157730, 157457, 156918, 156344, 155647, 155309, 153647, 153619, 153567, 152421, 152309, 152257, 151761, 151739, 128038))
Run Time: 0.041963
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 53 | 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: 32438, 0, 1716044529, {"thread-182591":["thread",182591],"thread-182588":["thread",182588],"thread-180937":["thread",180937],"thread-180276":["thread",180276],"thread-180272":["thread",180272],"thread-178459":["thread",178459],"thread-178380":["thread",178380],"thread-175325":["thread",175325],"thread-174295":["thread",174295],"thread-174293":["thread",174293],"thread-173016":["thread",173016],"thread-171731":["thread",171731],"thread-169236":["thread",169236],"thread-168333":["thread",168333],"thread-166201":["thread",166201],"thread-165435":["thread",165435],"thread-165344":["thread",165344],"thread-165007":["thread",165007],"thread-163929":["thread",163929],"thread-163822":["thread",163822],"thread-163040":["thread",163040],"thread-162847":["thread",162847],"thread-162614":["thread",162614],"thread-162252":["thread",162252],"thread-162173":["thread",162173],"thread-162068":["thread",162068],"thread-162067":["thread",162067],"thread-161665":["thread",161665],"thread-160922":["thread",160922],"thread-160131":["thread",160131],"thread-158943":["thread",158943],"thread-158828":["thread",158828],"thread-158810":["thread",158810],"thread-158441":["thread",158441],"thread-157913":["thread",157913],"thread-157730":["thread",157730],"thread-157457":["thread",157457],"thread-156918":["thread",156918],"thread-156344":["thread",156344],"thread-155647":["thread",155647],"thread-155309":["thread",155309],"thread-153647":["thread",153647],"thread-153619":["thread",153619],"thread-153567":["thread",153567],"thread-152421":["thread",152421],"thread-152309":["thread",152309],"thread-152257":["thread",152257],"thread-151761":["thread",151761],"tl_group-3":["tl_group",3],"thread-128038":["thread",128038]}, , 1716040929
Run Time: 0.003306
- 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