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 (183260, 183251, 182290, 181922, 181888, 180249, 179510, 178422, 178407, 178354, 177965, 177905, 176873, 176322, 174275, 173871, 173798, 173299, 172415, 172278, 172223, 171903, 171795, 171778, 171315, 170553, 170272, 170211, 169900, 169807, 169127, 169004, 168993, 168258, 167128, 166497, 166238, 165626, 163223, 162582, 162558, 162292, 162206, 160766, 160320, 159604, 159370, 159173, 155917, 154132, 150485, 138971, 138442, 135248, 122817, 122816, 121883, 118056, 117653, 117526, 117404, 116970, 116683, 116576, 116555, 101927, 101669, 101132, 100398, 95828, 94748, 83536, 78172, 73816, 73697, 73608, 70559, 70337, 69590, 68881, 64929, 62949, 55373, 55372, 54531, 54138, 49915, 49866, 48506, 43348, 41790, 29110, 27690, 27677, 23518, 13791, 12898, 1345))
Run Time: 0.043958
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 98 | 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: 1978, 0, 1715833073, {"thread-183260":["thread",183260],"thread-183251":["thread",183251],"thread-182290":["thread",182290],"thread-181922":["thread",181922],"thread-181888":["thread",181888],"thread-180249":["thread",180249],"thread-179510":["thread",179510],"thread-178422":["thread",178422],"thread-178407":["thread",178407],"thread-178354":["thread",178354],"thread-177965":["thread",177965],"thread-177905":["thread",177905],"thread-176873":["thread",176873],"thread-176322":["thread",176322],"thread-174275":["thread",174275],"thread-173871":["thread",173871],"thread-173798":["thread",173798],"thread-173299":["thread",173299],"thread-172415":["thread",172415],"thread-172278":["thread",172278],"thread-172223":["thread",172223],"thread-171903":["thread",171903],"thread-171795":["thread",171795],"thread-171778":["thread",171778],"thread-171315":["thread",171315],"thread-170553":["thread",170553],"thread-170272":["thread",170272],"thread-170211":["thread",170211],"thread-169900":["thread",169900],"thread-169807":["thread",169807],"thread-169127":["thread",169127],"thread-169004":["thread",169004],"thread-168993":["thread",168993],"thread-168258":["thread",168258],"tl_group-243":["tl_group",243],"thread-167128":["thread",167128],"thread-166497":["thread",166497],"thread-166238":["thread",166238],"thread-165626":["thread",165626],"thread-163223":["thread",163223],"thread-162582":["thread",162582],"thread-162558":["thread",162558],"thread-162292":["thread",162292],"thread-162206":["thread",162206],"thread-160766":["thread",160766],"thread-160320":["thread",160320],"thread-159604":["thread",159604],"thread-159370":["thread",159370],"thread-159173":["thread",159173],"thread-155917":["thread",155917],"thread-150485":["thread",150485],"thread-138971":["thread",138971],"thread-138442":["thread",138442],"thread-135248":["thread",135248],"thread-122817":["thread",122817],"thread-122816":["thread",122816],"thread-121883":["thread",121883],"thread-118056":["thread",118056],"thread-117653":["thread",117653],"thread-117526":["thread",117526],"thread-117404":["thread",117404],"thread-116970":["thread",116970],"thread-116683":["thread",116683],"thread-116576":["thread",116576],"thread-116555":["thread",116555],"thread-101927":["thread",101927],"thread-101669":["thread",101669],"thread-101132":["thread",101132],"thread-100398":["thread",100398],"thread-95828":["thread",95828],"thread-94748":["thread",94748],"thread-83536":["thread",83536],"thread-78172":["thread",78172],"thread-73816":["thread",73816],"thread-73697":["thread",73697],"thread-73608":["thread",73608],"thread-70559":["thread",70559],"thread-70337":["thread",70337],"thread-69590":["thread",69590],"thread-68881":["thread",68881],"thread-64929":["thread",64929],"thread-62949":["thread",62949],"thread-55373":["thread",55373],"thread-55372":["thread",55372],"thread-54531":["thread",54531],"thread-54138":["thread",54138],"thread-49915":["thread",49915],"thread-49866":["thread",49866],"thread-48506":["thread",48506],"thread-43348":["thread",43348],"thread-41790":["thread",41790],"thread-29110":["thread",29110],"thread-27690":["thread",27690],"thread-27677":["thread",27677],"thread-23518":["thread",23518],"thread-13791":["thread",13791],"thread-12898":["thread",12898],"thread-1345":["thread",1345]}, , 1715829473
Run Time: 0.000308
- 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