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 (103931, 103639, 103347, 101752, 100853, 100582, 100163, 100131, 99900, 99877, 98875, 98872, 98711, 98584, 98424, 98030, 97161, 97145, 96889, 95219, 96646, 96462, 96252, 96222, 96116, 96110, 96070, 96065, 96061, 95895, 95326, 95314, 94572, 94293, 94129, 93850, 93831, 93710, 93697, 93664, 93597, 93314, 92291, 91887, 91845, 91834, 89773, 89725, 89622, 89188, 88765, 88488, 88197, 87019, 86940, 86829, 84139, 82008, 82003, 82002, 80863, 79646, 79368, 78670, 78667, 78659, 78331, 78040, 77796, 77065, 77064, 76286, 76284, 76279, 76277, 76239, 76231, 76221, 75638, 75622, 75526, 75426, 75303, 74968, 74931, 74886, 74884, 74744, 74670, 74667, 74026, 72837, 72832, 70126, 69885, 69796, 69424, 69040, 68470, 67532, 67516, 67506, 65279, 65080, 65001, 64999, 64996, 63721, 61684, 71522, 71521, 58551, 58435, 58279, 57505, 57357, 57209, 57127, 57060, 55722, 55677, 55109, 54881, 54455, 54135, 53443, 53436, 53434, 53242, 52881, 52682, 52681, 52487, 52486, 52218, 51933, 51754, 50468, 48791, 48713, 46950, 46848, 45805, 45481, 44231, 44133, 43140, 42942, 42926, 42367, 42020, 40688, 39724, 39452, 39075, 38695, 37906, 37892, 58752, 34686, 33869, 32250, 31514, 30842, 30466, 29430, 29091, 27796, 27143, 26767, 26581, 25464, 25385, 24097, 23757, 23232, 22845, 22562, 22194, 22111, 21741, 21591, 21547, 20711, 19657, 19614, 17333, 14856, 13624, 10729, 9505, 5151, 4925, 337))
Run Time: 0.002439
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 194 | 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: 104, 0, 1711662985, {"thread-103931":["thread",103931],"thread-103639":["thread",103639],"thread-103347":["thread",103347],"thread-101752":["thread",101752],"thread-100853":["thread",100853],"thread-100582":["thread",100582],"thread-100163":["thread",100163],"thread-100131":["thread",100131],"thread-99900":["thread",99900],"thread-99877":["thread",99877],"thread-98875":["thread",98875],"thread-98872":["thread",98872],"thread-98711":["thread",98711],"thread-98584":["thread",98584],"thread-98424":["thread",98424],"thread-98030":["thread",98030],"thread-97161":["thread",97161],"thread-97145":["thread",97145],"thread-96889":["thread",96889],"thread-95219":["thread",95219],"thread-96646":["thread",96646],"thread-96462":["thread",96462],"thread-96252":["thread",96252],"thread-96222":["thread",96222],"thread-96116":["thread",96116],"thread-96110":["thread",96110],"thread-96070":["thread",96070],"thread-96065":["thread",96065],"thread-96061":["thread",96061],"thread-95895":["thread",95895],"thread-95326":["thread",95326],"thread-95314":["thread",95314],"thread-94572":["thread",94572],"thread-94293":["thread",94293],"thread-94129":["thread",94129],"thread-93850":["thread",93850],"thread-93831":["thread",93831],"thread-93710":["thread",93710],"thread-93697":["thread",93697],"thread-93664":["thread",93664],"thread-93597":["thread",93597],"thread-93314":["thread",93314],"thread-92291":["thread",92291],"thread-91887":["thread",91887],"thread-91845":["thread",91845],"thread-91834":["thread",91834],"thread-89773":["thread",89773],"thread-89725":["thread",89725],"thread-89622":["thread",89622],"thread-89188":["thread",89188],"thread-88765":["thread",88765],"thread-88488":["thread",88488],"thread-88197":["thread",88197],"thread-87019":["thread",87019],"thread-86940":["thread",86940],"thread-86829":["thread",86829],"thread-84139":["thread",84139],"thread-82008":["thread",82008],"thread-82003":["thread",82003],"thread-82002":["thread",82002],"thread-80863":["thread",80863],"thread-79646":["thread",79646],"thread-79368":["thread",79368],"thread-78670":["thread",78670],"thread-78667":["thread",78667],"thread-78659":["thread",78659],"thread-78331":["thread",78331],"thread-78040":["thread",78040],"thread-77796":["thread",77796],"thread-77065":["thread",77065],"thread-77064":["thread",77064],"thread-76286":["thread",76286],"thread-76284":["thread",76284],"thread-76279":["thread",76279],"thread-76277":["thread",76277],"thread-76239":["thread",76239],"thread-76231":["thread",76231],"thread-76221":["thread",76221],"thread-75638":["thread",75638],"thread-75622":["thread",75622],"thread-75526":["thread",75526],"thread-75426":["thread",75426],"thread-75303":["thread",75303],"thread-74968":["thread",74968],"thread-74931":["thread",74931],"thread-74886":["thread",74886],"thread-74884":["thread",74884],"thread-74744":["thread",74744],"thread-74670":["thread",74670],"thread-74667":["thread",74667],"thread-74026":["thread",74026],"thread-72837":["thread",72837],"thread-72832":["thread",72832],"thread-70126":["thread",70126],"thread-69885":["thread",69885],"thread-69796":["thread",69796],"thread-69424":["thread",69424],"thread-69040":["thread",69040],"thread-68470":["thread",68470],"thread-67532":["thread",67532],"thread-67516":["thread",67516],"thread-67506":["thread",67506],"thread-65279":["thread",65279],"thread-65080":["thread",65080],"thread-65001":["thread",65001],"thread-64999":["thread",64999],"thread-64996":["thread",64996],"thread-63721":["thread",63721],"thread-61684":["thread",61684],"thread-71522":["thread",71522],"thread-71521":["thread",71521],"thread-58551":["thread",58551],"thread-58435":["thread",58435],"thread-58279":["thread",58279],"thread-57505":["thread",57505],"thread-57357":["thread",57357],"thread-57209":["thread",57209],"thread-57127":["thread",57127],"thread-57060":["thread",57060],"thread-55722":["thread",55722],"thread-55677":["thread",55677],"thread-55109":["thread",55109],"thread-54881":["thread",54881],"thread-54455":["thread",54455],"thread-54135":["thread",54135],"thread-53443":["thread",53443],"thread-53436":["thread",53436],"thread-53434":["thread",53434],"thread-53242":["thread",53242],"thread-52881":["thread",52881],"thread-52682":["thread",52682],"thread-52681":["thread",52681],"thread-52487":["thread",52487],"thread-52486":["thread",52486],"thread-52218":["thread",52218],"thread-51933":["thread",51933],"thread-51754":["thread",51754],"thread-50468":["thread",50468],"thread-48791":["thread",48791],"thread-48713":["thread",48713],"thread-46950":["thread",46950],"thread-46848":["thread",46848],"thread-45805":["thread",45805],"thread-45481":["thread",45481],"thread-44231":["thread",44231],"thread-44133":["thread",44133],"thread-43140":["thread",43140],"thread-42942":["thread",42942],"thread-42926":["thread",42926],"thread-42367":["thread",42367],"thread-42020":["thread",42020],"thread-40688":["thread",40688],"thread-39724":["thread",39724],"thread-39452":["thread",39452],"thread-39075":["thread",39075],"thread-38695":["thread",38695],"thread-37906":["thread",37906],"thread-37892":["thread",37892],"thread-58752":["thread",58752],"thread-34686":["thread",34686],"thread-33869":["thread",33869],"thread-32250":["thread",32250],"thread-31514":["thread",31514],"thread-30842":["thread",30842],"thread-30466":["thread",30466],"thread-29430":["thread",29430],"thread-29091":["thread",29091],"thread-27796":["thread",27796],"thread-27143":["thread",27143],"thread-26767":["thread",26767],"thread-26581":["thread",26581],"thread-25464":["thread",25464],"thread-25385":["thread",25385],"thread-24097":["thread",24097],"thread-23757":["thread",23757],"thread-23232":["thread",23232],"thread-22845":["thread",22845],"thread-22562":["thread",22562],"thread-22194":["thread",22194],"thread-22111":["thread",22111],"thread-21741":["thread",21741],"thread-21591":["thread",21591],"thread-21547":["thread",21547],"thread-20711":["thread",20711],"thread-19657":["thread",19657],"thread-19614":["thread",19614],"thread-17333":["thread",17333],"thread-14856":["thread",14856],"thread-13624":["thread",13624],"thread-10729":["thread",10729],"thread-9505":["thread",9505],"thread-5151":["thread",5151],"thread-4925":["thread",4925],"thread-337":["thread",337]}, NULL, 1711659385
Run Time: 0.000100
- 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