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 (103342, 103297, 102842, 102516, 101137, 100788, 100664, 100596, 100586, 100581, 100176, 98169, 97430, 97408, 97300, 96757, 96531, 96377, 96024, 95801, 95726, 95698, 94404, 93898, 93300, 92997, 92979, 92792, 92785, 92610, 92510, 92300, 92142, 92125, 92114, 92112, 92109, 92029, 91988, 91947, 89597, 89024, 88838, 88766, 86854, 86712, 86602, 86505, 86297, 86240, 85834, 84576, 83982, 83444, 79589, 78678, 76865, 76392, 76317, 75194, 75139, 74984, 73964, 73873, 73852, 73541, 69818, 72377, 67137, 64512, 63456, 62503, 61079, 61034, 60792, 71474, 71586, 71617, 71623, 71626, 60183, 71637, 59119, 56338, 56158, 55301, 54778, 54321, 54080, 53960, 52475, 51577, 51244, 50899, 50554, 50107, 49132, 48502, 48259, 48157, 48043, 47061, 45569, 45512, 45503, 45380, 41249, 40983, 40863, 40801, 40744, 39374, 37280, 36967, 36194, 36017, 35486, 34789, 34776, 33012, 32163, 31686, 31614, 30922, 30202, 29829, 28123, 27474, 26981, 27164, 26295, 26197, 25899, 25650, 25646, 25610, 25323, 24986, 24814, 24683, 24516, 24442, 23980, 23692, 23661, 23545, 23192, 22899, 22497, 22431, 22167, 21625, 21610, 20583, 19147, 18375, 17624, 16342, 15251, 11252, 8092, 8009, 7435, 4933, 4811, 4743, 3523, 3242, 2989, 2750, 1117, 875, 4889, 603, 430, 263, 262, 261))
Run Time: 0.002491
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 178 | 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: 264, 0, 1714823990, {"thread-103342":["thread",103342],"thread-103297":["thread",103297],"thread-102842":["thread",102842],"thread-102516":["thread",102516],"thread-101137":["thread",101137],"thread-100788":["thread",100788],"thread-100664":["thread",100664],"thread-100596":["thread",100596],"thread-100586":["thread",100586],"thread-100581":["thread",100581],"thread-100176":["thread",100176],"thread-98169":["thread",98169],"thread-97430":["thread",97430],"thread-97408":["thread",97408],"thread-97300":["thread",97300],"thread-96757":["thread",96757],"thread-96531":["thread",96531],"thread-96377":["thread",96377],"thread-96024":["thread",96024],"thread-95801":["thread",95801],"thread-95726":["thread",95726],"thread-95698":["thread",95698],"thread-94404":["thread",94404],"thread-93300":["thread",93300],"thread-92997":["thread",92997],"thread-92979":["thread",92979],"thread-92792":["thread",92792],"thread-92785":["thread",92785],"thread-92610":["thread",92610],"thread-92510":["thread",92510],"thread-92300":["thread",92300],"thread-92142":["thread",92142],"thread-92114":["thread",92114],"thread-92112":["thread",92112],"thread-92109":["thread",92109],"thread-92029":["thread",92029],"thread-91988":["thread",91988],"thread-91947":["thread",91947],"thread-89597":["thread",89597],"thread-89024":["thread",89024],"thread-88838":["thread",88838],"thread-88766":["thread",88766],"thread-86854":["thread",86854],"thread-86712":["thread",86712],"thread-86602":["thread",86602],"thread-86505":["thread",86505],"thread-86297":["thread",86297],"thread-86240":["thread",86240],"thread-85834":["thread",85834],"thread-84576":["thread",84576],"thread-83982":["thread",83982],"thread-83444":["thread",83444],"thread-79589":["thread",79589],"thread-78678":["thread",78678],"thread-76865":["thread",76865],"thread-76392":["thread",76392],"thread-76317":["thread",76317],"thread-75194":["thread",75194],"thread-75139":["thread",75139],"thread-74984":["thread",74984],"thread-73964":["thread",73964],"thread-73873":["thread",73873],"thread-73852":["thread",73852],"thread-73541":["thread",73541],"thread-69818":["thread",69818],"thread-72377":["thread",72377],"thread-67137":["thread",67137],"thread-64512":["thread",64512],"thread-63456":["thread",63456],"thread-62503":["thread",62503],"thread-61079":["thread",61079],"thread-61034":["thread",61034],"thread-60792":["thread",60792],"thread-71474":["thread",71474],"thread-71586":["thread",71586],"thread-71617":["thread",71617],"thread-71623":["thread",71623],"thread-71626":["thread",71626],"thread-60183":["thread",60183],"thread-71637":["thread",71637],"thread-59119":["thread",59119],"thread-56338":["thread",56338],"thread-56158":["thread",56158],"thread-55301":["thread",55301],"thread-54778":["thread",54778],"thread-54321":["thread",54321],"thread-54080":["thread",54080],"thread-53960":["thread",53960],"thread-52475":["thread",52475],"thread-51577":["thread",51577],"thread-51244":["thread",51244],"thread-50899":["thread",50899],"thread-50554":["thread",50554],"thread-50107":["thread",50107],"thread-49132":["thread",49132],"thread-48502":["thread",48502],"thread-48259":["thread",48259],"thread-48157":["thread",48157],"thread-48043":["thread",48043],"thread-47061":["thread",47061],"thread-45569":["thread",45569],"thread-45512":["thread",45512],"thread-45503":["thread",45503],"thread-45380":["thread",45380],"thread-41249":["thread",41249],"thread-40983":["thread",40983],"thread-40863":["thread",40863],"thread-40801":["thread",40801],"thread-40744":["thread",40744],"thread-39374":["thread",39374],"thread-37280":["thread",37280],"thread-36967":["thread",36967],"thread-36194":["thread",36194],"thread-36017":["thread",36017],"thread-35486":["thread",35486],"thread-34789":["thread",34789],"thread-34776":["thread",34776],"thread-33012":["thread",33012],"thread-32163":["thread",32163],"thread-31686":["thread",31686],"thread-31614":["thread",31614],"thread-30922":["thread",30922],"thread-30202":["thread",30202],"thread-29829":["thread",29829],"thread-28123":["thread",28123],"thread-27474":["thread",27474],"thread-26981":["thread",26981],"thread-27164":["thread",27164],"thread-26295":["thread",26295],"thread-26197":["thread",26197],"thread-25899":["thread",25899],"thread-25650":["thread",25650],"thread-25646":["thread",25646],"thread-25610":["thread",25610],"thread-25323":["thread",25323],"thread-24986":["thread",24986],"thread-24814":["thread",24814],"thread-24683":["thread",24683],"thread-24516":["thread",24516],"thread-24442":["thread",24442],"thread-23980":["thread",23980],"thread-23692":["thread",23692],"thread-23661":["thread",23661],"thread-23545":["thread",23545],"thread-23192":["thread",23192],"thread-22899":["thread",22899],"thread-22497":["thread",22497],"thread-22431":["thread",22431],"thread-22167":["thread",22167],"thread-21625":["thread",21625],"thread-21610":["thread",21610],"thread-20583":["thread",20583],"thread-19147":["thread",19147],"thread-18375":["thread",18375],"thread-17624":["thread",17624],"thread-16342":["thread",16342],"thread-15251":["thread",15251],"thread-11252":["thread",11252],"thread-8092":["thread",8092],"thread-8009":["thread",8009],"thread-7435":["thread",7435],"thread-4933":["thread",4933],"thread-4811":["thread",4811],"thread-4743":["thread",4743],"thread-3523":["thread",3523],"thread-3242":["thread",3242],"thread-2989":["thread",2989],"thread-2750":["thread",2750],"thread-1117":["thread",1117],"thread-875":["thread",875],"thread-4889":["thread",4889],"thread-603":["thread",603],"thread-430":["thread",430],"thread-263":["thread",263],"thread-262":["thread",262],"thread-261":["thread",261]}, NULL, 1714820390
Run Time: 0.000107
- 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