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 (103819, 103389, 101622, 101268, 101028, 100613, 100596, 99510, 99455, 98662, 97956, 97829, 97686, 97471, 97371, 96644, 96430, 96293, 96067, 94171, 93860, 93138, 92785, 92114, 92112, 92109, 91929, 91915, 91914, 91675, 91641, 89611, 89050, 88889, 88584, 87236, 86408, 86329, 85603, 85258, 84006, 83877, 83730, 83307, 82724, 81474, 80714, 79605, 75196, 74946, 74895, 74894, 74290, 73764, 72443, 69208, 69149, 67964, 67814, 66781, 65683, 64303, 63102, 61358, 71506, 71505, 71535, 71634, 71713, 71763, 71783, 71787, 71789, 71795, 72016, 72030, 71782, 71659, 58996, 71780, 71581, 71592, 58191, 55463, 54991, 54413, 54077, 52457, 51761, 51379, 50478, 49788, 48448, 46322, 46269, 45694, 45031, 44829, 44635, 44361, 43961, 43663, 43653, 43564, 43554, 43529, 43512, 43386, 43217, 42784, 42620, 42433, 41907, 41905, 41904, 41705, 41606, 40758, 40486, 38091, 37889, 37183, 36878, 36588, 34439, 33319, 32527, 32090, 32261, 31976, 31298, 31079, 31070, 30699, 30511, 29739, 29673, 29641, 28961, 28661, 28657, 27595, 27543, 26647, 26570, 26354, 25818, 25772, 25412, 25289, 24597, 24279, 23904, 23173, 22476, 22428, 22039, 21877, 21700, 21499, 21296, 20966, 20848, 20724, 19856, 19163, 18809, 17972, 17926, 17798, 17675, 31594, 17562, 17370, 17090, 16714, 16580, 16545, 14133, 13922, 11771, 11322, 11241, 10982, 9849, 7414, 7088, 5811, 5682, 5567, 5349, 5323, 5322, 5271, 5236, 5143, 5048, 4844, 4837, 4689, 4543, 4197, 4135, 3268, 3265, 38338, 241, 198))
Run Time: 0.002742
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 208 | 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: 292, 0, 1714050858, {"thread-103819":["thread",103819],"thread-101622":["thread",101622],"thread-101268":["thread",101268],"thread-101028":["thread",101028],"thread-100613":["thread",100613],"thread-100596":["thread",100596],"thread-99510":["thread",99510],"thread-99455":["thread",99455],"thread-98662":["thread",98662],"thread-97956":["thread",97956],"thread-97829":["thread",97829],"thread-97686":["thread",97686],"thread-97471":["thread",97471],"thread-97371":["thread",97371],"thread-96644":["thread",96644],"thread-96430":["thread",96430],"thread-96293":["thread",96293],"thread-96067":["thread",96067],"thread-94171":["thread",94171],"thread-93860":["thread",93860],"thread-93138":["thread",93138],"thread-92785":["thread",92785],"thread-92114":["thread",92114],"resource-97":["resource",97],"thread-92112":["thread",92112],"resource-96":["resource",96],"thread-92109":["thread",92109],"thread-91929":["thread",91929],"thread-91915":["thread",91915],"thread-91914":["thread",91914],"thread-91675":["thread",91675],"thread-91641":["thread",91641],"thread-89611":["thread",89611],"thread-89050":["thread",89050],"thread-88889":["thread",88889],"thread-88584":["thread",88584],"thread-87236":["thread",87236],"thread-86408":["thread",86408],"thread-86329":["thread",86329],"thread-85603":["thread",85603],"thread-85258":["thread",85258],"thread-84006":["thread",84006],"thread-83877":["thread",83877],"thread-83730":["thread",83730],"thread-83307":["thread",83307],"thread-82724":["thread",82724],"thread-81474":["thread",81474],"thread-80714":["thread",80714],"thread-79605":["thread",79605],"thread-75196":["thread",75196],"thread-74946":["thread",74946],"thread-74895":["thread",74895],"thread-74894":["thread",74894],"thread-74290":["thread",74290],"thread-73764":["thread",73764],"thread-72443":["thread",72443],"thread-69208":["thread",69208],"thread-69149":["thread",69149],"thread-67964":["thread",67964],"thread-67814":["thread",67814],"thread-66781":["thread",66781],"thread-65683":["thread",65683],"thread-64303":["thread",64303],"thread-63102":["thread",63102],"thread-61358":["thread",61358],"thread-71506":["thread",71506],"thread-71505":["thread",71505],"thread-71535":["thread",71535],"thread-71634":["thread",71634],"thread-71713":["thread",71713],"thread-71763":["thread",71763],"thread-71783":["thread",71783],"thread-71787":["thread",71787],"thread-71789":["thread",71789],"thread-71795":["thread",71795],"thread-72016":["thread",72016],"thread-72030":["thread",72030],"thread-71782":["thread",71782],"thread-71659":["thread",71659],"thread-58996":["thread",58996],"thread-71780":["thread",71780],"thread-71581":["thread",71581],"thread-71592":["thread",71592],"thread-58191":["thread",58191],"thread-55463":["thread",55463],"thread-54991":["thread",54991],"thread-54413":["thread",54413],"thread-54077":["thread",54077],"thread-52457":["thread",52457],"thread-51761":["thread",51761],"thread-51379":["thread",51379],"thread-50478":["thread",50478],"thread-49788":["thread",49788],"thread-48448":["thread",48448],"thread-46322":["thread",46322],"thread-46269":["thread",46269],"thread-45694":["thread",45694],"thread-45031":["thread",45031],"thread-44829":["thread",44829],"thread-44635":["thread",44635],"thread-44361":["thread",44361],"thread-43961":["thread",43961],"thread-43663":["thread",43663],"thread-43653":["thread",43653],"thread-43564":["thread",43564],"thread-43554":["thread",43554],"thread-43529":["thread",43529],"thread-43512":["thread",43512],"thread-43386":["thread",43386],"thread-43217":["thread",43217],"thread-42784":["thread",42784],"thread-42620":["thread",42620],"thread-42433":["thread",42433],"thread-41907":["thread",41907],"thread-41905":["thread",41905],"thread-41904":["thread",41904],"thread-41705":["thread",41705],"thread-41606":["thread",41606],"thread-40758":["thread",40758],"thread-40486":["thread",40486],"thread-38091":["thread",38091],"thread-37889":["thread",37889],"thread-37183":["thread",37183],"thread-36878":["thread",36878],"thread-36588":["thread",36588],"thread-34439":["thread",34439],"thread-33319":["thread",33319],"thread-32527":["thread",32527],"thread-32090":["thread",32090],"thread-32261":["thread",32261],"thread-31976":["thread",31976],"thread-31298":["thread",31298],"thread-31079":["thread",31079],"thread-31070":["thread",31070],"thread-30699":["thread",30699],"thread-30511":["thread",30511],"thread-29739":["thread",29739],"thread-29673":["thread",29673],"thread-29641":["thread",29641],"thread-28961":["thread",28961],"thread-28661":["thread",28661],"thread-28657":["thread",28657],"thread-27595":["thread",27595],"thread-27543":["thread",27543],"thread-26647":["thread",26647],"thread-26570":["thread",26570],"thread-26354":["thread",26354],"thread-25818":["thread",25818],"thread-25772":["thread",25772],"thread-25412":["thread",25412],"thread-25289":["thread",25289],"thread-24597":["thread",24597],"thread-24279":["thread",24279],"thread-23904":["thread",23904],"thread-23173":["thread",23173],"thread-22476":["thread",22476],"thread-22428":["thread",22428],"thread-22039":["thread",22039],"thread-21877":["thread",21877],"thread-21700":["thread",21700],"thread-21499":["thread",21499],"thread-21296":["thread",21296],"thread-20966":["thread",20966],"thread-20848":["thread",20848],"thread-20724":["thread",20724],"thread-19856":["thread",19856],"thread-19163":["thread",19163],"thread-18809":["thread",18809],"thread-17972":["thread",17972],"thread-17926":["thread",17926],"thread-17798":["thread",17798],"thread-17675":["thread",17675],"thread-31594":["thread",31594],"thread-17562":["thread",17562],"thread-17370":["thread",17370],"thread-17090":["thread",17090],"thread-16714":["thread",16714],"thread-16580":["thread",16580],"thread-16545":["thread",16545],"thread-14133":["thread",14133],"thread-13922":["thread",13922],"thread-11771":["thread",11771],"thread-11322":["thread",11322],"thread-11241":["thread",11241],"thread-10982":["thread",10982],"thread-9849":["thread",9849],"thread-7414":["thread",7414],"thread-7088":["thread",7088],"thread-5811":["thread",5811],"thread-5682":["thread",5682],"thread-5567":["thread",5567],"thread-5349":["thread",5349],"thread-5323":["thread",5323],"thread-5322":["thread",5322],"thread-5271":["thread",5271],"thread-5236":["thread",5236],"thread-5143":["thread",5143],"thread-5048":["thread",5048],"thread-4844":["thread",4844],"thread-4837":["thread",4837],"thread-4689":["thread",4689],"thread-4543":["thread",4543],"thread-4197":["thread",4197],"thread-4135":["thread",4135],"thread-3268":["thread",3268],"thread-3265":["thread",3265],"thread-38338":["thread",38338],"thread-241":["thread",241],"thread-198":["thread",198]}, NULL, 1714047258
Run Time: 0.000121
- 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