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 (182255, 181406, 177458, 177171, 175509, 175415, 174105, 173792, 173733, 169256, 167518, 167279, 163080, 163066, 162893, 159186, 159158, 158739, 158547, 157820, 154930, 154068, 139906, 136859, 136099, 134892, 132181, 131532, 130465, 129903, 128477, 128310, 125222, 123693, 123330, 123114, 122133, 120143, 118856, 115375, 114789, 114496, 114242, 114180, 113825, 113771, 113373, 112520, 111285, 110984, 110766, 110401, 110121, 109903, 109865, 109429, 109146, 109039, 108800, 108743, 108646, 108632, 108412, 108385, 108335, 108269, 108268, 107937, 107918, 107917, 107862, 107861, 107804, 107641, 107633, 107593, 107499, 107181, 106623, 106399, 105767, 105591, 104864, 103645, 103162, 102626, 102464, 101721, 101641, 101256, 101029, 100439, 99981, 99399, 99366, 97818, 97022, 96521, 96480, 94493, 92957, 92465, 91509, 91081, 90923, 89154, 89150, 88791, 88430, 88115, 88059, 86638, 86030, 85719, 84382, 83339, 82576, 80359, 79758, 79192, 76244, 75693, 74211, 73577, 72870, 72546, 70979, 70430, 65296, 65236, 63425, 60707, 54038, 52625, 51997, 51954, 51372, 50020, 49563, 41735, 38785, 28405, 27881))
Run Time: 0.112769
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 143 | 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: 3744, 0, 1716009152, {"thread-182255":["thread",182255],"thread-181406":["thread",181406],"thread-177458":["thread",177458],"thread-177171":["thread",177171],"thread-175509":["thread",175509],"thread-175415":["thread",175415],"thread-174105":["thread",174105],"thread-173792":["thread",173792],"thread-173733":["thread",173733],"thread-169256":["thread",169256],"thread-167518":["thread",167518],"thread-167279":["thread",167279],"thread-163080":["thread",163080],"thread-163066":["thread",163066],"thread-162893":["thread",162893],"thread-159186":["thread",159186],"thread-159158":["thread",159158],"thread-158739":["thread",158739],"thread-158547":["thread",158547],"thread-157820":["thread",157820],"thread-154930":["thread",154930],"thread-154068":["thread",154068],"thread-139906":["thread",139906],"thread-136859":["thread",136859],"thread-136099":["thread",136099],"thread-134892":["thread",134892],"thread-132181":["thread",132181],"thread-131532":["thread",131532],"thread-130465":["thread",130465],"thread-129903":["thread",129903],"thread-128477":["thread",128477],"thread-128310":["thread",128310],"thread-125222":["thread",125222],"thread-123693":["thread",123693],"thread-123330":["thread",123330],"thread-123114":["thread",123114],"thread-122133":["thread",122133],"thread-120143":["thread",120143],"thread-118856":["thread",118856],"thread-115375":["thread",115375],"thread-114789":["thread",114789],"thread-114496":["thread",114496],"thread-114242":["thread",114242],"thread-114180":["thread",114180],"thread-113825":["thread",113825],"thread-113771":["thread",113771],"thread-113373":["thread",113373],"thread-112520":["thread",112520],"thread-111285":["thread",111285],"thread-110984":["thread",110984],"thread-110766":["thread",110766],"thread-110401":["thread",110401],"thread-110121":["thread",110121],"thread-109903":["thread",109903],"thread-109865":["thread",109865],"thread-109429":["thread",109429],"thread-109146":["thread",109146],"thread-109039":["thread",109039],"thread-108800":["thread",108800],"thread-108743":["thread",108743],"thread-108646":["thread",108646],"thread-108632":["thread",108632],"thread-108412":["thread",108412],"thread-108385":["thread",108385],"thread-108335":["thread",108335],"thread-108269":["thread",108269],"thread-108268":["thread",108268],"thread-107937":["thread",107937],"thread-107918":["thread",107918],"thread-107917":["thread",107917],"thread-107862":["thread",107862],"thread-107861":["thread",107861],"thread-107804":["thread",107804],"thread-107641":["thread",107641],"thread-107633":["thread",107633],"thread-107593":["thread",107593],"thread-107499":["thread",107499],"thread-107181":["thread",107181],"thread-106623":["thread",106623],"thread-106399":["thread",106399],"thread-105767":["thread",105767],"thread-105591":["thread",105591],"thread-104864":["thread",104864],"thread-103645":["thread",103645],"thread-103162":["thread",103162],"thread-102626":["thread",102626],"thread-102464":["thread",102464],"thread-101721":["thread",101721],"thread-101641":["thread",101641],"thread-101256":["thread",101256],"thread-101029":["thread",101029],"thread-100439":["thread",100439],"thread-99981":["thread",99981],"thread-99399":["thread",99399],"thread-99366":["thread",99366],"thread-97818":["thread",97818],"thread-97022":["thread",97022],"thread-96521":["thread",96521],"thread-96480":["thread",96480],"thread-94493":["thread",94493],"thread-92957":["thread",92957],"thread-92465":["thread",92465],"thread-91509":["thread",91509],"thread-91081":["thread",91081],"thread-90923":["thread",90923],"thread-89154":["thread",89154],"thread-89150":["thread",89150],"thread-88791":["thread",88791],"thread-88430":["thread",88430],"thread-88115":["thread",88115],"thread-88059":["thread",88059],"thread-86638":["thread",86638],"thread-86030":["thread",86030],"thread-85719":["thread",85719],"thread-84382":["thread",84382],"thread-83339":["thread",83339],"thread-82576":["thread",82576],"thread-80359":["thread",80359],"thread-79758":["thread",79758],"thread-79192":["thread",79192],"thread-76244":["thread",76244],"thread-75693":["thread",75693],"thread-74211":["thread",74211],"thread-73577":["thread",73577],"thread-72870":["thread",72870],"thread-72546":["thread",72546],"thread-70979":["thread",70979],"thread-70430":["thread",70430],"thread-65296":["thread",65296],"thread-65236":["thread",65236],"thread-63425":["thread",63425],"thread-60707":["thread",60707],"thread-54038":["thread",54038],"thread-52625":["thread",52625],"thread-51997":["thread",51997],"thread-51954":["thread",51954],"thread-51372":["thread",51372],"thread-50020":["thread",50020],"thread-49563":["thread",49563],"thread-41735":["thread",41735],"thread-38785":["thread",38785],"thread-28405":["thread",28405],"thread-27881":["thread",27881]}, , 1716005552
Run Time: 0.000738
- 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