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 (182613, 182527, 182112, 181210, 180910, 180402, 180069, 179049, 178914, 176737, 176250, 175093, 171720, 166169, 165935, 165934, 163829, 163762, 163442, 162648, 162584, 162547, 162543, 162493, 162485, 162479, 162446, 162298, 162142, 160846, 160844, 160145, 160144, 160137, 160136, 157425, 156974, 156698, 156696, 156315, 156304, 156302, 153532, 153408, 153159, 152287, 152254, 151983, 149120, 137027, 136342, 135957, 127331, 125050, 125047, 122328, 120843, 120832, 120749, 120697, 120204, 117517, 115395, 115194, 114767, 114418, 113301, 109667, 109269, 108551, 107754, 106670, 102277, 100922, 97929, 97277, 95868, 94071, 91854, 90981, 86099, 85642, 81138, 80668, 80014, 79007, 78816, 74066, 72093, 71576, 66352, 57944, 57332, 56568, 54362, 53686, 51602, 51583, 51388, 50279, 42693, 36693, 29096, 27716, 18818, 8756, 8387, 5745))
Run Time: 0.064388
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 108 | 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: 1158, 0, 1715920379, {"thread-182613":["thread",182613],"thread-182527":["thread",182527],"thread-182112":["thread",182112],"thread-181210":["thread",181210],"thread-180910":["thread",180910],"thread-180402":["thread",180402],"thread-180069":["thread",180069],"thread-179049":["thread",179049],"thread-178914":["thread",178914],"thread-176737":["thread",176737],"thread-176250":["thread",176250],"thread-175093":["thread",175093],"thread-171720":["thread",171720],"thread-166169":["thread",166169],"thread-165935":["thread",165935],"thread-165934":["thread",165934],"thread-163829":["thread",163829],"thread-163762":["thread",163762],"thread-163442":["thread",163442],"thread-162648":["thread",162648],"thread-162584":["thread",162584],"thread-162547":["thread",162547],"thread-162543":["thread",162543],"thread-162493":["thread",162493],"thread-162485":["thread",162485],"thread-162479":["thread",162479],"thread-162446":["thread",162446],"thread-162298":["thread",162298],"thread-162142":["thread",162142],"thread-160846":["thread",160846],"thread-160844":["thread",160844],"thread-160145":["thread",160145],"thread-160144":["thread",160144],"thread-160137":["thread",160137],"thread-160136":["thread",160136],"thread-157425":["thread",157425],"thread-156974":["thread",156974],"thread-156698":["thread",156698],"thread-156696":["thread",156696],"thread-156315":["thread",156315],"thread-156304":["thread",156304],"thread-156302":["thread",156302],"thread-153532":["thread",153532],"thread-153408":["thread",153408],"thread-153159":["thread",153159],"thread-152287":["thread",152287],"thread-152254":["thread",152254],"thread-151983":["thread",151983],"thread-149120":["thread",149120],"thread-137027":["thread",137027],"thread-136342":["thread",136342],"thread-135957":["thread",135957],"thread-127331":["thread",127331],"thread-125050":["thread",125050],"thread-125047":["thread",125047],"thread-122328":["thread",122328],"thread-120843":["thread",120843],"thread-120832":["thread",120832],"thread-120749":["thread",120749],"thread-120697":["thread",120697],"thread-120204":["thread",120204],"thread-117517":["thread",117517],"thread-115395":["thread",115395],"thread-115194":["thread",115194],"thread-114767":["thread",114767],"thread-114418":["thread",114418],"thread-113301":["thread",113301],"thread-109667":["thread",109667],"thread-109269":["thread",109269],"thread-108551":["thread",108551],"thread-107754":["thread",107754],"thread-106670":["thread",106670],"thread-102277":["thread",102277],"thread-100922":["thread",100922],"thread-97929":["thread",97929],"thread-97277":["thread",97277],"thread-95868":["thread",95868],"thread-94071":["thread",94071],"thread-91854":["thread",91854],"thread-90981":["thread",90981],"thread-86099":["thread",86099],"thread-85642":["thread",85642],"thread-81138":["thread",81138],"thread-80668":["thread",80668],"thread-80014":["thread",80014],"thread-79007":["thread",79007],"thread-78816":["thread",78816],"thread-74066":["thread",74066],"thread-72093":["thread",72093],"thread-71576":["thread",71576],"thread-66352":["thread",66352],"thread-57944":["thread",57944],"thread-57332":["thread",57332],"thread-56568":["thread",56568],"thread-54362":["thread",54362],"thread-53686":["thread",53686],"thread-51602":["thread",51602],"thread-51583":["thread",51583],"thread-51388":["thread",51388],"thread-50279":["thread",50279],"thread-42693":["thread",42693],"thread-36693":["thread",36693],"thread-29096":["thread",29096],"thread-27716":["thread",27716],"thread-18818":["thread",18818],"thread-8756":["thread",8756],"thread-8387":["thread",8387],"thread-5745":["thread",5745]}, , 1715916779
Run Time: 0.000492
- 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