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 (183215, 183173, 182314, 182157, 182128, 181778, 181582, 181538, 181472, 180858, 180774, 179870, 178840, 178747, 178690, 178589, 178569, 178465, 177905, 177198, 176790, 176674, 176332, 176264, 175632, 175094, 174945, 173837, 173811, 173768, 173638, 173346, 172557, 172005, 171978, 171794, 171782, 171638, 171146, 171003, 170866, 170646, 169710, 169278, 169004, 168855, 167583, 167157, 166952, 166782, 166691, 166149, 164893, 163615, 163559, 162618, 162243, 162225, 162086, 161760, 161370, 161265, 160153, 160022, 159904, 159891, 159854, 159761, 159639, 159466, 159435, 159106, 158855, 157883, 157861, 157859, 157707, 157427, 157343, 157339, 157104, 156449, 156071, 155862, 155444, 155274, 154528, 153726, 153725, 152748, 152585, 152281, 152233, 152080, 152059, 151950, 151936, 99946, 91524, 88083, 82346, 52040, 47576, 38339, 34719, 19647, 19604))
Run Time: 0.060965
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 107 | 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: 2616, 0, 1715408180, {"thread-183215":["thread",183215],"thread-183173":["thread",183173],"thread-182314":["thread",182314],"thread-182157":["thread",182157],"thread-182128":["thread",182128],"thread-181778":["thread",181778],"thread-181582":["thread",181582],"thread-181538":["thread",181538],"thread-181472":["thread",181472],"thread-180858":["thread",180858],"thread-180774":["thread",180774],"thread-179870":["thread",179870],"thread-178840":["thread",178840],"thread-178747":["thread",178747],"thread-178690":["thread",178690],"thread-178589":["thread",178589],"thread-178569":["thread",178569],"thread-178465":["thread",178465],"thread-177905":["thread",177905],"thread-177198":["thread",177198],"thread-176790":["thread",176790],"thread-176674":["thread",176674],"thread-176332":["thread",176332],"thread-176264":["thread",176264],"thread-175632":["thread",175632],"thread-175094":["thread",175094],"thread-174945":["thread",174945],"thread-173837":["thread",173837],"thread-173811":["thread",173811],"thread-173768":["thread",173768],"thread-173638":["thread",173638],"thread-173346":["thread",173346],"thread-172557":["thread",172557],"thread-172005":["thread",172005],"thread-171978":["thread",171978],"thread-171794":["thread",171794],"thread-171782":["thread",171782],"thread-171638":["thread",171638],"thread-171146":["thread",171146],"thread-171003":["thread",171003],"thread-170866":["thread",170866],"thread-170646":["thread",170646],"thread-169710":["thread",169710],"thread-169278":["thread",169278],"thread-169004":["thread",169004],"thread-168855":["thread",168855],"thread-167583":["thread",167583],"thread-167157":["thread",167157],"thread-166952":["thread",166952],"thread-166782":["thread",166782],"thread-166691":["thread",166691],"thread-166149":["thread",166149],"thread-164893":["thread",164893],"thread-163615":["thread",163615],"thread-163559":["thread",163559],"thread-162618":["thread",162618],"thread-162243":["thread",162243],"thread-162225":["thread",162225],"thread-162086":["thread",162086],"thread-161760":["thread",161760],"thread-161370":["thread",161370],"thread-161265":["thread",161265],"thread-160153":["thread",160153],"thread-160022":["thread",160022],"thread-159904":["thread",159904],"thread-159891":["thread",159891],"thread-159854":["thread",159854],"thread-159761":["thread",159761],"thread-159639":["thread",159639],"thread-159466":["thread",159466],"thread-159435":["thread",159435],"thread-159106":["thread",159106],"thread-158855":["thread",158855],"thread-157883":["thread",157883],"thread-157861":["thread",157861],"thread-157859":["thread",157859],"thread-157707":["thread",157707],"thread-157427":["thread",157427],"thread-157343":["thread",157343],"thread-157339":["thread",157339],"thread-157104":["thread",157104],"thread-156449":["thread",156449],"thread-156071":["thread",156071],"thread-155862":["thread",155862],"thread-155444":["thread",155444],"thread-155274":["thread",155274],"thread-154528":["thread",154528],"thread-153726":["thread",153726],"thread-153725":["thread",153725],"thread-152748":["thread",152748],"thread-152585":["thread",152585],"thread-152281":["thread",152281],"thread-152233":["thread",152233],"thread-152080":["thread",152080],"thread-152059":["thread",152059],"thread-151950":["thread",151950],"thread-151936":["thread",151936],"thread-99946":["thread",99946],"thread-91524":["thread",91524],"thread-88083":["thread",88083],"thread-82346":["thread",82346],"thread-52040":["thread",52040],"thread-47576":["thread",47576],"thread-38339":["thread",38339],"thread-34719":["thread",34719],"thread-19647":["thread",19647],"thread-19604":["thread",19604]}, , 1715404580
Run Time: 0.001125
- 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