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 (183939, 183807, 183648, 183611, 182879, 181917, 181907, 180963, 180962, 180961, 180773, 180336, 179503, 178613, 177832, 177781, 176608, 175462, 175057, 173839, 173619, 173540, 173474, 171394, 169600, 169541, 169371, 169106, 168699, 168543, 168178, 167878, 167843, 167611, 167546, 167273, 166500, 166486, 166472, 166471, 166470, 166469, 166305, 166263, 166042, 166041, 166035, 166023, 165925, 165811, 165418, 165414, 165398, 165387, 165382, 165381, 165380, 165379, 165378, 165239, 165220, 165040, 164820, 164623, 164421, 164295, 163462, 163427, 162107, 161235, 160329, 160071, 159919, 159391, 159274, 158882, 158838, 158468, 158392, 158140, 158098, 158071, 157027, 155980, 155428, 155074, 155072, 155069, 155068, 154984, 154980, 154728, 154501, 154309, 153729, 153510, 153145, 152500, 151170, 150572, 143271, 142158, 138260, 130321, 129293, 129057, 127823, 127571, 122252, 121897, 121180, 120892, 120803, 120763, 120484, 120216, 118880, 118587, 118007, 117927, 117825, 117797, 117780, 117652, 117287, 115561, 115514, 114161, 113927, 113544, 113461, 113413, 113061, 112840, 112327, 112236, 112057, 111735, 111731, 111321, 110308, 110279, 109984, 108451, 108170, 106355, 106194, 105989, 105046, 105014, 104975, 103637, 103543, 103143, 102001, 101661, 101035, 100276, 98393, 97677, 96568, 96481, 96156, 95923, 93405, 92568, 89207, 76006, 71068, 69248, 69104, 68642, 68074, 67255, 66854, 61025, 56968, 54885, 53141, 52101, 49750, 47527, 46625, 21818, 19617, 9993, 9646, 1173))
Run Time: 0.119034
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 188 | 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: 300, 0, 1717010494, {"thread-183939":["thread",183939],"thread-183807":["thread",183807],"thread-183648":["thread",183648],"thread-183611":["thread",183611],"thread-182879":["thread",182879],"thread-181917":["thread",181917],"thread-181907":["thread",181907],"thread-180963":["thread",180963],"thread-180962":["thread",180962],"thread-180961":["thread",180961],"thread-180773":["thread",180773],"thread-180336":["thread",180336],"thread-179503":["thread",179503],"thread-178613":["thread",178613],"thread-177832":["thread",177832],"thread-177781":["thread",177781],"thread-176608":["thread",176608],"thread-175462":["thread",175462],"thread-175057":["thread",175057],"thread-173839":["thread",173839],"thread-173619":["thread",173619],"thread-173540":["thread",173540],"thread-173474":["thread",173474],"thread-171394":["thread",171394],"thread-169600":["thread",169600],"thread-169541":["thread",169541],"thread-169371":["thread",169371],"thread-169106":["thread",169106],"thread-168699":["thread",168699],"thread-168543":["thread",168543],"thread-168178":["thread",168178],"thread-167878":["thread",167878],"thread-167843":["thread",167843],"thread-167611":["thread",167611],"thread-167546":["thread",167546],"thread-167273":["thread",167273],"thread-166500":["thread",166500],"thread-166486":["thread",166486],"thread-166472":["thread",166472],"thread-166471":["thread",166471],"thread-166470":["thread",166470],"thread-166469":["thread",166469],"thread-166305":["thread",166305],"thread-166263":["thread",166263],"thread-166042":["thread",166042],"thread-166041":["thread",166041],"thread-166035":["thread",166035],"thread-166023":["thread",166023],"thread-165925":["thread",165925],"thread-165811":["thread",165811],"thread-165418":["thread",165418],"thread-165414":["thread",165414],"thread-165398":["thread",165398],"thread-165387":["thread",165387],"thread-165382":["thread",165382],"thread-165381":["thread",165381],"thread-165380":["thread",165380],"thread-165379":["thread",165379],"thread-165378":["thread",165378],"thread-165239":["thread",165239],"thread-165220":["thread",165220],"thread-165040":["thread",165040],"thread-164820":["thread",164820],"thread-164623":["thread",164623],"thread-164421":["thread",164421],"thread-164295":["thread",164295],"thread-163462":["thread",163462],"thread-163427":["thread",163427],"thread-162107":["thread",162107],"thread-161235":["thread",161235],"thread-160329":["thread",160329],"thread-160071":["thread",160071],"thread-159919":["thread",159919],"thread-159391":["thread",159391],"thread-159274":["thread",159274],"thread-158882":["thread",158882],"thread-158838":["thread",158838],"thread-158468":["thread",158468],"thread-158392":["thread",158392],"thread-158140":["thread",158140],"thread-158098":["thread",158098],"thread-158071":["thread",158071],"thread-157027":["thread",157027],"thread-155980":["thread",155980],"thread-155428":["thread",155428],"thread-155074":["thread",155074],"thread-155072":["thread",155072],"thread-155069":["thread",155069],"thread-155068":["thread",155068],"thread-154984":["thread",154984],"thread-154980":["thread",154980],"thread-154728":["thread",154728],"thread-154501":["thread",154501],"thread-154309":["thread",154309],"thread-153729":["thread",153729],"thread-153510":["thread",153510],"thread-153145":["thread",153145],"thread-151170":["thread",151170],"thread-150572":["thread",150572],"thread-143271":["thread",143271],"thread-142158":["thread",142158],"thread-138260":["thread",138260],"thread-130321":["thread",130321],"thread-129293":["thread",129293],"thread-129057":["thread",129057],"thread-127823":["thread",127823],"thread-127571":["thread",127571],"thread-122252":["thread",122252],"thread-121897":["thread",121897],"thread-121180":["thread",121180],"thread-120892":["thread",120892],"thread-120803":["thread",120803],"thread-120763":["thread",120763],"thread-120484":["thread",120484],"thread-120216":["thread",120216],"thread-118880":["thread",118880],"thread-118587":["thread",118587],"thread-118007":["thread",118007],"thread-117927":["thread",117927],"thread-117825":["thread",117825],"thread-117797":["thread",117797],"thread-117780":["thread",117780],"thread-117652":["thread",117652],"thread-117287":["thread",117287],"thread-115561":["thread",115561],"thread-115514":["thread",115514],"thread-114161":["thread",114161],"thread-113927":["thread",113927],"thread-113544":["thread",113544],"thread-113461":["thread",113461],"thread-113413":["thread",113413],"thread-113061":["thread",113061],"thread-112840":["thread",112840],"thread-112327":["thread",112327],"thread-112236":["thread",112236],"thread-112057":["thread",112057],"thread-111735":["thread",111735],"thread-111731":["thread",111731],"thread-111321":["thread",111321],"thread-110308":["thread",110308],"thread-110279":["thread",110279],"thread-109984":["thread",109984],"thread-108451":["thread",108451],"thread-108170":["thread",108170],"thread-106355":["thread",106355],"thread-106194":["thread",106194],"thread-105989":["thread",105989],"thread-105046":["thread",105046],"thread-105014":["thread",105014],"thread-104975":["thread",104975],"thread-103637":["thread",103637],"thread-103543":["thread",103543],"thread-103143":["thread",103143],"thread-102001":["thread",102001],"thread-101661":["thread",101661],"thread-101035":["thread",101035],"thread-100276":["thread",100276],"thread-98393":["thread",98393],"thread-97677":["thread",97677],"thread-96568":["thread",96568],"thread-96481":["thread",96481],"thread-96156":["thread",96156],"thread-95923":["thread",95923],"thread-93405":["thread",93405],"thread-92568":["thread",92568],"thread-89207":["thread",89207],"thread-76006":["thread",76006],"thread-71068":["thread",71068],"thread-69248":["thread",69248],"thread-69104":["thread",69104],"thread-68642":["thread",68642],"thread-68074":["thread",68074],"thread-67255":["thread",67255],"thread-66854":["thread",66854],"thread-61025":["thread",61025],"thread-56968":["thread",56968],"thread-54885":["thread",54885],"thread-53141":["thread",53141],"thread-52101":["thread",52101],"thread-49750":["thread",49750],"thread-47527":["thread",47527],"thread-46625":["thread",46625],"thread-21818":["thread",21818],"thread-19617":["thread",19617],"thread-9993":["thread",9993],"thread-9646":["thread",9646],"thread-1173":["thread",1173]}, , 1717006894
Run Time: 0.007857
- 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