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 (179287, 179150, 178910, 178177, 176665, 176661, 176036, 174181, 174146, 172489, 172053, 171715, 171714, 171172, 169432, 169061, 168918, 168312, 167256, 167254, 166626, 165938, 163991, 163983, 163965, 163934, 163609, 159138, 159014, 158764, 158675, 157618, 157374, 155541, 155427, 154824, 153072, 152898, 151622, 150668, 150666, 150665, 150600, 145793, 139356, 133139, 129301, 128430, 126599, 125257, 124762, 121115, 120936, 120831, 120640, 120521, 120271, 119693, 117698, 117683, 117557, 114489, 114395, 114344, 114330, 114244, 114106, 114105, 112006, 111556, 110342, 110298, 109651, 107830, 105830, 104640, 104344, 103724, 102275, 101867, 99586, 98682, 97907, 97575, 97547, 92037, 91485, 91152, 87605, 87370, 85890, 85486, 82413, 78339, 75712, 72892, 72891, 72819, 71726, 71151, 70446, 66164, 64755, 62676, 61436, 61195, 58976, 58241, 57610, 54236, 52676, 52097, 49690, 49053, 47196, 46236, 43028, 35983, 19765, 12476, 1973, 1966, 1929))
Run Time: 0.277367
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 123 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 1387
- 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 2729
- 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 137
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 552, 0, 1716173508, {"thread-179287":["thread",179287],"thread-179150":["thread",179150],"thread-178910":["thread",178910],"thread-178177":["thread",178177],"thread-176665":["thread",176665],"thread-176661":["thread",176661],"thread-176036":["thread",176036],"thread-174181":["thread",174181],"thread-174146":["thread",174146],"thread-172489":["thread",172489],"thread-172053":["thread",172053],"tl_group-276":["tl_group",276],"thread-171715":["thread",171715],"thread-171714":["thread",171714],"thread-171172":["thread",171172],"thread-169432":["thread",169432],"thread-169061":["thread",169061],"thread-168918":["thread",168918],"thread-168312":["thread",168312],"thread-167256":["thread",167256],"thread-167254":["thread",167254],"thread-166626":["thread",166626],"thread-165938":["thread",165938],"thread-163991":["thread",163991],"thread-163983":["thread",163983],"thread-163934":["thread",163934],"thread-163609":["thread",163609],"thread-159138":["thread",159138],"thread-159014":["thread",159014],"thread-158764":["thread",158764],"thread-158675":["thread",158675],"thread-157618":["thread",157618],"thread-157374":["thread",157374],"thread-155541":["thread",155541],"thread-155427":["thread",155427],"thread-154824":["thread",154824],"thread-153072":["thread",153072],"thread-151622":["thread",151622],"thread-150668":["thread",150668],"thread-150666":["thread",150666],"thread-150665":["thread",150665],"thread-150600":["thread",150600],"thread-145793":["thread",145793],"thread-139356":["thread",139356],"thread-133139":["thread",133139],"thread-129301":["thread",129301],"thread-128430":["thread",128430],"thread-126599":["thread",126599],"thread-125257":["thread",125257],"thread-124762":["thread",124762],"thread-121115":["thread",121115],"thread-120936":["thread",120936],"thread-120831":["thread",120831],"thread-120640":["thread",120640],"thread-120521":["thread",120521],"thread-120271":["thread",120271],"thread-119693":["thread",119693],"thread-117698":["thread",117698],"thread-117683":["thread",117683],"thread-117557":["thread",117557],"thread-114489":["thread",114489],"thread-114395":["thread",114395],"thread-114344":["thread",114344],"thread-114330":["thread",114330],"thread-114244":["thread",114244],"thread-114106":["thread",114106],"thread-114105":["thread",114105],"thread-112006":["thread",112006],"thread-111556":["thread",111556],"thread-110342":["thread",110342],"thread-110298":["thread",110298],"thread-109651":["thread",109651],"thread-107830":["thread",107830],"thread-105830":["thread",105830],"thread-104640":["thread",104640],"thread-104344":["thread",104344],"thread-103724":["thread",103724],"thread-102275":["thread",102275],"thread-101867":["thread",101867],"thread-99586":["thread",99586],"thread-98682":["thread",98682],"thread-97907":["thread",97907],"thread-97575":["thread",97575],"thread-97547":["thread",97547],"thread-92037":["thread",92037],"thread-91485":["thread",91485],"thread-91152":["thread",91152],"thread-87605":["thread",87605],"thread-87370":["thread",87370],"thread-85890":["thread",85890],"thread-85486":["thread",85486],"thread-82413":["thread",82413],"thread-78339":["thread",78339],"thread-75712":["thread",75712],"thread-72892":["thread",72892],"thread-72891":["thread",72891],"thread-72819":["thread",72819],"thread-71726":["thread",71726],"thread-71151":["thread",71151],"thread-70446":["thread",70446],"thread-66164":["thread",66164],"thread-64755":["thread",64755],"thread-62676":["thread",62676],"thread-61436":["thread",61436],"thread-61195":["thread",61195],"thread-58976":["thread",58976],"thread-58241":["thread",58241],"thread-57610":["thread",57610],"thread-54236":["thread",54236],"thread-52676":["thread",52676],"thread-52097":["thread",52097],"thread-49690":["thread",49690],"thread-49053":["thread",49053],"thread-47196":["thread",47196],"thread-46236":["thread",46236],"thread-43028":["thread",43028],"thread-35983":["thread",35983],"thread-19765":["thread",19765],"thread-12476":["thread",12476],"thread-1973":["thread",1973],"thread-1966":["thread",1966],"thread-1929":["thread",1929]}, , 1716169908
Run Time: 0.005462
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 150
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20