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 (103967, 102912, 101976, 101203, 101184, 100957, 100633, 100242, 100124, 100079, 100060, 100059, 100058, 100057, 100056, 100055, 100054, 99580, 99230, 99202, 99077, 99075, 99058, 98405, 98136, 98131, 98043, 97681, 97242, 97239, 97229, 96951, 96779, 96481, 96436, 96248, 96005, 95981, 95631, 95131, 95040, 94466, 94147, 93542, 94299, 93104, 92974, 92897, 92751, 92634, 91775, 91711, 89898, 89890, 89891, 89470, 89097, 88932, 88635, 87950, 87212, 92133, 86942, 82424, 82327, 80666, 80478, 79851, 79530, 78990, 78848, 78777, 78001, 77741, 76755, 76754, 76753, 76752, 76708, 76270, 76129, 75466, 74555, 72950, 70271, 70211, 70122, 68820, 67582, 67329, 65925, 59451, 59241, 58689, 58141, 55854, 55842, 52413, 51308, 45832, 43813, 43455, 43405, 43081, 42521, 41314, 39215, 38950, 38095, 37923, 37826, 36121, 35680, 35446, 35125, 33471, 30282, 27612, 26239, 26102, 26027, 24365, 21419, 20411, 19875, 16802, 16317, 16315, 16302, 16188, 14132, 13403, 11347, 11211, 11184, 11175, 11126, 11120, 10777, 10317, 10067, 7801, 6709, 6427, 6314, 6056, 4832, 1889, 1881, 1878))
Run Time: 0.002092
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 150 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,blutschwerter_forum.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 290, 0, 1714106285, {"thread-103967":["thread",103967],"thread-102912":["thread",102912],"thread-101976":["thread",101976],"thread-101203":["thread",101203],"thread-101184":["thread",101184],"thread-100957":["thread",100957],"thread-100633":["thread",100633],"thread-100242":["thread",100242],"thread-100124":["thread",100124],"thread-100079":["thread",100079],"thread-100060":["thread",100060],"thread-100059":["thread",100059],"thread-100058":["thread",100058],"thread-100057":["thread",100057],"thread-100056":["thread",100056],"thread-100055":["thread",100055],"thread-100054":["thread",100054],"thread-99580":["thread",99580],"thread-99230":["thread",99230],"thread-99202":["thread",99202],"thread-99077":["thread",99077],"thread-99075":["thread",99075],"thread-99058":["thread",99058],"thread-98405":["thread",98405],"thread-98136":["thread",98136],"thread-98131":["thread",98131],"thread-98043":["thread",98043],"thread-97681":["thread",97681],"thread-97242":["thread",97242],"thread-97239":["thread",97239],"thread-97229":["thread",97229],"thread-96951":["thread",96951],"thread-96779":["thread",96779],"thread-96481":["thread",96481],"thread-96436":["thread",96436],"thread-96248":["thread",96248],"thread-96005":["thread",96005],"thread-95981":["thread",95981],"thread-95631":["thread",95631],"thread-95131":["thread",95131],"thread-95040":["thread",95040],"thread-94466":["thread",94466],"thread-94147":["thread",94147],"thread-93542":["thread",93542],"thread-94299":["thread",94299],"thread-93104":["thread",93104],"thread-92974":["thread",92974],"thread-92897":["thread",92897],"thread-92751":["thread",92751],"thread-92634":["thread",92634],"thread-91775":["thread",91775],"thread-91711":["thread",91711],"thread-89898":["thread",89898],"thread-89890":["thread",89890],"thread-89891":["thread",89891],"thread-89470":["thread",89470],"thread-89097":["thread",89097],"thread-88932":["thread",88932],"thread-88635":["thread",88635],"thread-87950":["thread",87950],"thread-87212":["thread",87212],"thread-92133":["thread",92133],"thread-86942":["thread",86942],"thread-82424":["thread",82424],"thread-82327":["thread",82327],"thread-80666":["thread",80666],"thread-80478":["thread",80478],"thread-79851":["thread",79851],"thread-79530":["thread",79530],"thread-78990":["thread",78990],"thread-78848":["thread",78848],"thread-78777":["thread",78777],"thread-78001":["thread",78001],"thread-77741":["thread",77741],"thread-76755":["thread",76755],"thread-76754":["thread",76754],"thread-76753":["thread",76753],"thread-76752":["thread",76752],"thread-76708":["thread",76708],"thread-76270":["thread",76270],"thread-76129":["thread",76129],"thread-75466":["thread",75466],"thread-74555":["thread",74555],"thread-72950":["thread",72950],"thread-70271":["thread",70271],"thread-70211":["thread",70211],"thread-70122":["thread",70122],"thread-68820":["thread",68820],"thread-67582":["thread",67582],"thread-67329":["thread",67329],"thread-65925":["thread",65925],"thread-59451":["thread",59451],"thread-59241":["thread",59241],"thread-58689":["thread",58689],"thread-58141":["thread",58141],"thread-55854":["thread",55854],"thread-55842":["thread",55842],"thread-52413":["thread",52413],"thread-51308":["thread",51308],"thread-45832":["thread",45832],"thread-43813":["thread",43813],"thread-43455":["thread",43455],"thread-43405":["thread",43405],"thread-43081":["thread",43081],"thread-42521":["thread",42521],"thread-41314":["thread",41314],"thread-39215":["thread",39215],"thread-38950":["thread",38950],"thread-38095":["thread",38095],"thread-37923":["thread",37923],"thread-37826":["thread",37826],"thread-36121":["thread",36121],"thread-35680":["thread",35680],"thread-35446":["thread",35446],"thread-35125":["thread",35125],"thread-33471":["thread",33471],"thread-30282":["thread",30282],"thread-27612":["thread",27612],"thread-26239":["thread",26239],"thread-26102":["thread",26102],"thread-26027":["thread",26027],"thread-24365":["thread",24365],"thread-21419":["thread",21419],"thread-20411":["thread",20411],"thread-19875":["thread",19875],"thread-16802":["thread",16802],"thread-16317":["thread",16317],"thread-16315":["thread",16315],"thread-16302":["thread",16302],"thread-16188":["thread",16188],"thread-14132":["thread",14132],"thread-13403":["thread",13403],"thread-11347":["thread",11347],"thread-11211":["thread",11211],"thread-11184":["thread",11184],"thread-11175":["thread",11175],"thread-11126":["thread",11126],"thread-11120":["thread",11120],"thread-10777":["thread",10777],"thread-10317":["thread",10317],"thread-10067":["thread",10067],"thread-7801":["thread",7801],"thread-6709":["thread",6709],"thread-6427":["thread",6427],"thread-6314":["thread",6314],"thread-6056":["thread",6056],"thread-4832":["thread",4832],"thread-1889":["thread",1889],"thread-1881":["thread",1881],"thread-1878":["thread",1878]}, NULL, 1714102685
Run Time: 0.000094
- 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 1526
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1258
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20