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 (57018, 56588, 56388, 55801, 54157, 53671, 53640, 53301, 52323, 51658, 50893, 50775, 50528, 49519, 49090, 48633, 48076, 47673, 47544, 47505, 46836, 46825, 46152, 46011, 44142, 43332, 43176, 42775, 42756, 42338, 42140, 41721, 41293, 40987, 40720, 39541, 37746, 37247, 37193, 36144, 36113, 35995, 35917, 35696, 35573, 34921, 34482, 33590, 33529, 32987, 32978, 32506, 32139, 31973, 31458, 31339, 31173, 30971, 30892, 30487, 30042, 29738, 29397, 29168, 28431, 28340, 28063, 28019, 27429, 27388, 27312, 27272, 27066, 27057, 26983, 26637, 23632, 23589, 22930, 21999, 20591, 20383, 20207, 20188, 18646, 18525, 17848, 17539, 15376, 15356, 14553, 14515, 14138, 13698, 13157, 12866, 12855, 12663, 10753, 10253, 9956, 9934, 9411, 8128, 7937, 7596, 7565, 7061, 6906, 4582, 4090, 2229, 2126, 2050))
Run Time: 0.022210
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 114 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | dark_db13795.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | dark_db13795.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | dark_db13795.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | dark_db13795.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dark_db13795.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 1294
- 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 2549
- 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 2184
- XF\App->run() in src/XF.php at line 391
- 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: 94, 0, 1715761386, {"thread-57018":["thread",57018],"thread-56588":["thread",56588],"thread-56388":["thread",56388],"thread-55801":["thread",55801],"thread-54157":["thread",54157],"thread-53671":["thread",53671],"thread-53640":["thread",53640],"thread-53301":["thread",53301],"thread-52323":["thread",52323],"thread-51658":["thread",51658],"thread-50893":["thread",50893],"thread-50775":["thread",50775],"thread-50528":["thread",50528],"thread-49519":["thread",49519],"thread-49090":["thread",49090],"thread-48633":["thread",48633],"thread-48076":["thread",48076],"thread-47673":["thread",47673],"thread-47544":["thread",47544],"thread-47505":["thread",47505],"thread-46836":["thread",46836],"thread-46825":["thread",46825],"thread-46152":["thread",46152],"thread-46011":["thread",46011],"thread-44142":["thread",44142],"thread-43332":["thread",43332],"thread-43176":["thread",43176],"thread-42775":["thread",42775],"thread-42756":["thread",42756],"thread-42338":["thread",42338],"thread-42140":["thread",42140],"thread-41721":["thread",41721],"thread-41293":["thread",41293],"thread-40987":["thread",40987],"thread-40720":["thread",40720],"thread-39541":["thread",39541],"thread-37746":["thread",37746],"thread-37247":["thread",37247],"thread-37193":["thread",37193],"thread-36144":["thread",36144],"thread-36113":["thread",36113],"thread-35995":["thread",35995],"thread-35917":["thread",35917],"thread-35696":["thread",35696],"thread-35573":["thread",35573],"thread-34921":["thread",34921],"thread-34482":["thread",34482],"thread-33590":["thread",33590],"thread-33529":["thread",33529],"thread-32987":["thread",32987],"thread-32978":["thread",32978],"thread-32506":["thread",32506],"thread-32139":["thread",32139],"thread-31973":["thread",31973],"thread-31458":["thread",31458],"thread-31339":["thread",31339],"thread-31173":["thread",31173],"thread-30971":["thread",30971],"thread-30892":["thread",30892],"thread-30487":["thread",30487],"thread-30042":["thread",30042],"thread-29738":["thread",29738],"thread-29397":["thread",29397],"thread-29168":["thread",29168],"thread-28431":["thread",28431],"thread-28340":["thread",28340],"thread-28063":["thread",28063],"thread-28019":["thread",28019],"thread-27429":["thread",27429],"thread-27388":["thread",27388],"thread-27312":["thread",27312],"thread-27272":["thread",27272],"thread-27066":["thread",27066],"thread-27057":["thread",27057],"thread-26983":["thread",26983],"thread-26637":["thread",26637],"thread-23632":["thread",23632],"thread-23589":["thread",23589],"thread-22930":["thread",22930],"thread-21999":["thread",21999],"thread-20591":["thread",20591],"thread-20383":["thread",20383],"thread-20207":["thread",20207],"thread-20188":["thread",20188],"thread-18646":["thread",18646],"thread-18525":["thread",18525],"thread-17848":["thread",17848],"thread-17539":["thread",17539],"thread-15376":["thread",15376],"thread-15356":["thread",15356],"thread-14553":["thread",14553],"thread-14515":["thread",14515],"thread-14138":["thread",14138],"thread-13698":["thread",13698],"thread-13157":["thread",13157],"thread-12866":["thread",12866],"thread-12855":["thread",12855],"thread-12663":["thread",12663],"thread-10753":["thread",10753],"thread-10253":["thread",10253],"thread-9956":["thread",9956],"thread-9934":["thread",9934],"thread-9411":["thread",9411],"thread-8128":["thread",8128],"thread-7937":["thread",7937],"thread-7596":["thread",7596],"thread-7565":["thread",7565],"thread-7061":["thread",7061],"thread-6906":["thread",6906],"thread-4582":["thread",4582],"thread-4090":["thread",4090],"thread-2229":["thread",2229],"thread-2126":["thread",2126],"thread-2050":["thread",2050]}, , 1715757786
Run Time: 0.000390
- 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 1463
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1195
- 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 2184
- XF\App->run() in src/XF.php at line 391
- XF::runApp() in index.php at line 20