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 (343254, 337637, 302098, 297955, 292008, 286088, 277976, 273185, 271728, 268951, 268331, 268329, 268022, 267978, 267966, 267747, 266829, 266220, 265658, 264809, 264264, 264131, 263946, 263770, 263590, 263477, 263171, 263062, 262785, 262784, 262539, 262214, 262133, 262063, 261776, 261774, 261199, 260822, 260317, 260282, 259461, 259075, 259066, 258887, 258361, 257298, 256514, 255681, 254993, 254746, 254563, 254480, 254477, 253017, 250860, 249985, 249984, 249571, 249548, 249275, 249152, 247836, 246987, 246751, 246623, 245276, 244778, 244685, 244476, 244283, 244042, 243867, 243835, 243674, 243642, 243233, 242665, 242067, 242065, 241792, 241489, 240511, 235229, 235218, 235180, 234242, 234092, 233313, 233312, 233311, 232702, 232532, 230911, 230842, 230666, 230433, 230248, 229503, 227979, 227482, 227455, 227404, 227219, 226959, 226925, 226201, 223572, 223460, 223214, 222471, 222313, 221145, 220633, 218693, 218601, 218508, 217976, 217957, 217816, 213318, 208529, 208347, 207760, 207753, 207614, 206763, 205401, 204427, 202689, 202191, 201785, 201666, 200589, 200247, 198848, 195720, 126438, 42760))
Run Time: 0.006051
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 138 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xenforo.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xenforo.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xenforo.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xenforo.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xenforo.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2673
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 488
- 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: 385, 0, 1711705375, {"thread-343254":["thread",343254],"thread-337637":["thread",337637],"thread-302098":["thread",302098],"thread-297955":["thread",297955],"thread-292008":["thread",292008],"thread-286088":["thread",286088],"thread-277976":["thread",277976],"thread-273185":["thread",273185],"thread-271728":["thread",271728],"thread-268951":["thread",268951],"thread-268331":["thread",268331],"thread-268329":["thread",268329],"thread-268022":["thread",268022],"thread-267978":["thread",267978],"thread-267966":["thread",267966],"thread-267747":["thread",267747],"thread-266829":["thread",266829],"thread-266220":["thread",266220],"thread-265658":["thread",265658],"thread-264809":["thread",264809],"thread-264264":["thread",264264],"thread-264131":["thread",264131],"thread-263946":["thread",263946],"thread-263770":["thread",263770],"thread-263590":["thread",263590],"thread-263477":["thread",263477],"thread-263171":["thread",263171],"thread-263062":["thread",263062],"thread-262785":["thread",262785],"thread-262784":["thread",262784],"thread-262539":["thread",262539],"thread-262214":["thread",262214],"thread-262133":["thread",262133],"thread-262063":["thread",262063],"thread-261776":["thread",261776],"thread-261774":["thread",261774],"thread-261199":["thread",261199],"thread-260822":["thread",260822],"thread-260317":["thread",260317],"thread-260282":["thread",260282],"thread-259461":["thread",259461],"thread-259075":["thread",259075],"thread-259066":["thread",259066],"thread-258887":["thread",258887],"thread-258361":["thread",258361],"thread-257298":["thread",257298],"thread-255681":["thread",255681],"thread-254993":["thread",254993],"thread-254746":["thread",254746],"thread-254563":["thread",254563],"thread-254480":["thread",254480],"thread-254477":["thread",254477],"thread-250860":["thread",250860],"thread-249984":["thread",249984],"thread-249571":["thread",249571],"thread-249548":["thread",249548],"thread-249275":["thread",249275],"thread-249152":["thread",249152],"thread-247836":["thread",247836],"thread-246987":["thread",246987],"thread-246751":["thread",246751],"thread-246623":["thread",246623],"thread-245276":["thread",245276],"thread-244778":["thread",244778],"thread-244685":["thread",244685],"thread-244476":["thread",244476],"thread-244283":["thread",244283],"thread-244042":["thread",244042],"thread-243867":["thread",243867],"thread-243835":["thread",243835],"thread-243674":["thread",243674],"thread-243642":["thread",243642],"thread-243233":["thread",243233],"thread-242665":["thread",242665],"thread-242067":["thread",242067],"thread-242065":["thread",242065],"thread-241792":["thread",241792],"thread-241489":["thread",241489],"thread-240511":["thread",240511],"thread-235229":["thread",235229],"thread-235218":["thread",235218],"thread-235180":["thread",235180],"thread-234242":["thread",234242],"thread-234092":["thread",234092],"thread-233313":["thread",233313],"thread-233312":["thread",233312],"thread-233311":["thread",233311],"thread-232532":["thread",232532],"thread-230911":["thread",230911],"thread-230842":["thread",230842],"thread-230666":["thread",230666],"thread-230433":["thread",230433],"thread-230248":["thread",230248],"thread-229503":["thread",229503],"thread-227482":["thread",227482],"thread-227455":["thread",227455],"thread-227404":["thread",227404],"thread-227219":["thread",227219],"thread-226959":["thread",226959],"thread-226925":["thread",226925],"thread-226201":["thread",226201],"thread-223460":["thread",223460],"thread-223214":["thread",223214],"thread-222471":["thread",222471],"thread-222313":["thread",222313],"thread-221145":["thread",221145],"thread-220633":["thread",220633],"thread-218693":["thread",218693],"thread-218601":["thread",218601],"thread-218508":["thread",218508],"thread-217976":["thread",217976],"thread-217957":["thread",217957],"thread-217816":["thread",217816],"thread-213318":["thread",213318],"thread-208529":["thread",208529],"thread-208347":["thread",208347],"thread-207760":["thread",207760],"thread-207753":["thread",207753],"thread-206763":["thread",206763],"thread-205401":["thread",205401],"thread-204427":["thread",204427],"thread-202689":["thread",202689],"thread-202191":["thread",202191],"thread-201785":["thread",201785],"thread-201666":["thread",201666],"thread-200589":["thread",200589],"thread-200247":["thread",200247],"thread-198848":["thread",198848],"thread-195720":["thread",195720],"thread-126438":["thread",126438]}, , 1711701775
Run Time: 0.000169
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 221
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1510
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 261
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2300
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20