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 (182924, 179975, 179322, 178462, 176652, 175816, 170741, 168713, 168027, 165581, 165303, 164944, 164537, 164098, 163935, 162114, 161038, 161037, 160720, 160719, 160690, 160635, 160470, 158802, 156005, 155690, 155574, 155103, 154871, 153547, 153146, 131995, 131904, 131412, 130972, 130919, 130795, 130776, 130601, 130599, 130582, 130036, 129884, 129880, 129755, 129540, 129538, 129350, 129347, 128673, 128563, 128519, 128505, 128297, 127665, 127419, 127416, 127188, 127057, 126906, 126720, 126312, 126295, 126046, 126019, 125913, 125814, 125784, 125659, 125192, 125122, 125113, 125094, 124863, 124446, 124428, 124324, 124317, 124277, 124216, 124067, 124058, 123727, 123619, 123451, 123324, 123251, 123246, 123174, 123077, 123014, 122910, 122700, 122295, 122182, 122120, 122022, 121949, 121847, 121840, 120701, 120685, 120659, 120371, 120248, 119729, 118845, 118788, 118605, 118534, 117907, 117824, 117798, 117054, 116956, 116953, 116890, 116784, 116702, 116615, 116570, 116464, 116413, 116412, 116297, 116231, 116228, 116204, 116186, 116045, 115626, 115416, 115341, 114733, 114710, 114431, 114303, 114002, 113913, 113690, 113680, 113634, 113344, 113088, 112964, 112925, 111635, 111527, 111510, 111494, 110734, 110558, 110525, 110143, 109890, 109474, 108945, 108547, 108417, 108343, 108027, 107818, 107696, 107464, 106486, 106071, 105916, 105616, 105598, 104224, 104006, 103891, 103878, 103821, 103478, 103451, 103215, 103208, 102869, 102813, 102733, 102635, 102584, 102557, 102548, 102146, 102073, 102070, 101798, 101699, 101534, 101525, 101504, 101371, 101362, 101129, 101069, 101064, 100910, 100738))
Run Time: 0.082660
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 1178, 0, 1715862680, {"thread-182924":["thread",182924],"thread-179975":["thread",179975],"thread-179322":["thread",179322],"thread-178462":["thread",178462],"thread-176652":["thread",176652],"thread-175816":["thread",175816],"thread-170741":["thread",170741],"thread-168713":["thread",168713],"thread-168027":["thread",168027],"thread-165581":["thread",165581],"thread-165303":["thread",165303],"thread-164944":["thread",164944],"thread-164098":["thread",164098],"thread-163935":["thread",163935],"thread-160720":["thread",160720],"thread-160719":["thread",160719],"thread-160690":["thread",160690],"thread-160635":["thread",160635],"thread-160470":["thread",160470],"thread-158802":["thread",158802],"thread-156005":["thread",156005],"thread-155690":["thread",155690],"thread-155574":["thread",155574],"thread-155103":["thread",155103],"thread-154871":["thread",154871],"thread-153547":["thread",153547],"thread-153146":["thread",153146],"thread-131995":["thread",131995],"thread-131904":["thread",131904],"thread-131412":["thread",131412],"thread-130972":["thread",130972],"thread-130919":["thread",130919],"thread-130795":["thread",130795],"thread-130776":["thread",130776],"thread-130601":["thread",130601],"thread-130599":["thread",130599],"thread-130582":["thread",130582],"thread-130036":["thread",130036],"thread-129884":["thread",129884],"thread-129880":["thread",129880],"thread-129755":["thread",129755],"thread-129540":["thread",129540],"thread-129538":["thread",129538],"thread-129350":["thread",129350],"thread-129347":["thread",129347],"thread-128673":["thread",128673],"thread-128563":["thread",128563],"thread-128519":["thread",128519],"thread-128505":["thread",128505],"thread-128297":["thread",128297],"thread-127665":["thread",127665],"thread-127419":["thread",127419],"thread-127416":["thread",127416],"thread-127188":["thread",127188],"thread-127057":["thread",127057],"thread-126906":["thread",126906],"thread-126720":["thread",126720],"thread-126312":["thread",126312],"thread-126295":["thread",126295],"thread-126046":["thread",126046],"thread-126019":["thread",126019],"thread-125913":["thread",125913],"thread-125814":["thread",125814],"thread-125784":["thread",125784],"thread-125659":["thread",125659],"thread-125192":["thread",125192],"thread-125122":["thread",125122],"thread-125113":["thread",125113],"thread-125094":["thread",125094],"thread-124863":["thread",124863],"thread-124446":["thread",124446],"thread-124428":["thread",124428],"thread-124324":["thread",124324],"thread-124317":["thread",124317],"thread-124277":["thread",124277],"thread-124216":["thread",124216],"thread-124067":["thread",124067],"thread-124058":["thread",124058],"thread-123727":["thread",123727],"thread-123619":["thread",123619],"thread-123451":["thread",123451],"thread-123324":["thread",123324],"thread-123251":["thread",123251],"thread-123246":["thread",123246],"thread-123174":["thread",123174],"thread-123077":["thread",123077],"thread-123014":["thread",123014],"thread-122910":["thread",122910],"thread-122700":["thread",122700],"thread-122295":["thread",122295],"thread-122182":["thread",122182],"thread-122120":["thread",122120],"thread-122022":["thread",122022],"thread-121949":["thread",121949],"thread-121847":["thread",121847],"thread-121840":["thread",121840],"thread-120701":["thread",120701],"thread-120685":["thread",120685],"thread-120659":["thread",120659],"thread-120371":["thread",120371],"thread-120248":["thread",120248],"thread-119729":["thread",119729],"thread-118845":["thread",118845],"thread-118788":["thread",118788],"thread-118605":["thread",118605],"thread-118534":["thread",118534],"thread-117907":["thread",117907],"thread-117824":["thread",117824],"thread-117798":["thread",117798],"thread-117054":["thread",117054],"thread-116956":["thread",116956],"thread-116953":["thread",116953],"thread-116890":["thread",116890],"thread-116784":["thread",116784],"thread-116702":["thread",116702],"thread-116615":["thread",116615],"thread-116570":["thread",116570],"thread-116464":["thread",116464],"thread-116413":["thread",116413],"thread-116412":["thread",116412],"thread-116297":["thread",116297],"thread-116231":["thread",116231],"thread-116228":["thread",116228],"thread-116204":["thread",116204],"thread-116186":["thread",116186],"thread-116045":["thread",116045],"thread-115626":["thread",115626],"thread-115416":["thread",115416],"thread-115341":["thread",115341],"thread-114733":["thread",114733],"thread-114710":["thread",114710],"thread-114431":["thread",114431],"thread-114303":["thread",114303],"thread-114002":["thread",114002],"thread-113913":["thread",113913],"thread-113690":["thread",113690],"thread-113680":["thread",113680],"thread-113634":["thread",113634],"thread-113344":["thread",113344],"thread-113088":["thread",113088],"thread-112964":["thread",112964],"thread-112925":["thread",112925],"thread-111635":["thread",111635],"thread-111527":["thread",111527],"thread-111510":["thread",111510],"thread-111494":["thread",111494],"thread-110734":["thread",110734],"thread-110558":["thread",110558],"thread-110525":["thread",110525],"thread-110143":["thread",110143],"thread-109890":["thread",109890],"thread-109474":["thread",109474],"thread-108945":["thread",108945],"thread-108547":["thread",108547],"thread-108417":["thread",108417],"thread-108343":["thread",108343],"thread-108027":["thread",108027],"thread-107818":["thread",107818],"thread-107696":["thread",107696],"thread-107464":["thread",107464],"thread-106486":["thread",106486],"thread-106071":["thread",106071],"thread-105916":["thread",105916],"thread-105616":["thread",105616],"thread-105598":["thread",105598],"thread-104224":["thread",104224],"thread-104006":["thread",104006],"thread-103891":["thread",103891],"thread-103878":["thread",103878],"thread-103821":["thread",103821],"thread-103478":["thread",103478],"thread-103451":["thread",103451],"thread-103215":["thread",103215],"thread-103208":["thread",103208],"thread-102869":["thread",102869],"thread-102813":["thread",102813],"thread-102733":["thread",102733],"thread-102635":["thread",102635],"thread-102584":["thread",102584],"thread-102557":["thread",102557],"thread-102548":["thread",102548],"thread-102146":["thread",102146],"thread-102073":["thread",102073],"thread-102070":["thread",102070],"thread-101798":["thread",101798],"thread-101699":["thread",101699],"thread-101534":["thread",101534],"thread-101525":["thread",101525],"thread-101504":["thread",101504],"thread-101371":["thread",101371],"thread-101362":["thread",101362],"thread-101129":["thread",101129],"thread-101069":["thread",101069],"thread-101064":["thread",101064],"thread-100910":["thread",100910],"thread-100738":["thread",100738]}, , 1715859080
Run Time: 0.000634
- 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