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 (219232, 216955, 216250, 214918, 214804, 214759, 214570, 213139, 211084, 210829, 210233, 210111, 209446, 208831, 208624, 208615, 207952, 207874, 206809, 205246, 204502, 203629, 202648, 201529, 200560, 197833, 192514, 191032, 189841, 189616, 186757, 185956, 184903, 183640, 183151, 182752, 182032, 180763, 180514, 180115, 179995, 178300, 177649, 176365, 175282, 175081, 174733, 174073, 171767, 171179, 169557, 168753, 168276, 166404, 165561, 165099, 163831, 161809, 161623, 161122, 160060, 159430, 159247, 158704, 157099, 156655, 153877, 152287, 151567, 149755, 146687, 146330, 146183, 145643, 144241, 141959, 140901, 139362, 139359, 137475, 136764, 136029, 135333, 129498, 129404, 128995, 128615, 128478, 128108, 127719, 127074, 126732, 126187, 125880, 125555, 125258, 125115, 124504, 124128, 123713, 123487, 122444, 121221, 120957, 120819, 120818, 120753, 120717, 120521, 120504, 120449, 120284, 120233, 119704, 118975, 117795, 117744, 117687, 117682, 117680, 117320, 117289, 117221, 116819, 115144, 114826, 114531, 114117, 113675, 112784, 112456, 111735, 111244, 111188, 110973, 110857, 110803, 110604, 110371, 110261, 110063, 109745, 109254, 108314, 108021, 107893, 107888, 107478, 107411, 107233, 107041, 106898, 106894, 106547, 106510, 106307, 106290, 106253, 106132, 106075, 105613, 105606, 105558, 105486, 105444, 105352, 105254, 105002, 104316, 103957, 103937, 103871, 103833, 103610, 103600, 103468, 103359, 103043, 103012, 102723, 102347, 102330, 102062, 101857, 101492, 100921, 100722, 100400, 100288, 99713, 99515, 99426, 98816, 98558, 98395, 98225, 98046, 97292, 97112, 96840, 96384, 96327, 95748, 95565, 95308, 95298, 95063, 94982, 94683, 94518, 93988, 92912, 92540, 92433, 92360, 92266, 91706, 91489))
Run Time: 0.013062
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 218 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,forum.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2710
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- 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: 275, 0, 1715055917, {"thread-219232":["thread",219232],"thread-216955":["thread",216955],"thread-216250":["thread",216250],"thread-214918":["thread",214918],"thread-214804":["thread",214804],"thread-214759":["thread",214759],"thread-214570":["thread",214570],"thread-213139":["thread",213139],"thread-211084":["thread",211084],"thread-210829":["thread",210829],"thread-210233":["thread",210233],"thread-210111":["thread",210111],"thread-209446":["thread",209446],"thread-208831":["thread",208831],"thread-208624":["thread",208624],"thread-208615":["thread",208615],"thread-207952":["thread",207952],"thread-207874":["thread",207874],"thread-206809":["thread",206809],"thread-205246":["thread",205246],"thread-204502":["thread",204502],"thread-203629":["thread",203629],"thread-202648":["thread",202648],"thread-201529":["thread",201529],"thread-200560":["thread",200560],"thread-197833":["thread",197833],"thread-192514":["thread",192514],"thread-191032":["thread",191032],"thread-189841":["thread",189841],"thread-189616":["thread",189616],"thread-186757":["thread",186757],"thread-185956":["thread",185956],"thread-184903":["thread",184903],"thread-183640":["thread",183640],"thread-183151":["thread",183151],"thread-182752":["thread",182752],"thread-182032":["thread",182032],"thread-180763":["thread",180763],"thread-180514":["thread",180514],"thread-180115":["thread",180115],"thread-179995":["thread",179995],"thread-178300":["thread",178300],"thread-177649":["thread",177649],"thread-176365":["thread",176365],"thread-175282":["thread",175282],"thread-175081":["thread",175081],"thread-174733":["thread",174733],"thread-174073":["thread",174073],"thread-171767":["thread",171767],"thread-171179":["thread",171179],"thread-169557":["thread",169557],"thread-168753":["thread",168753],"thread-168276":["thread",168276],"thread-166404":["thread",166404],"thread-165561":["thread",165561],"thread-165099":["thread",165099],"thread-163831":["thread",163831],"thread-161809":["thread",161809],"thread-161623":["thread",161623],"thread-161122":["thread",161122],"thread-160060":["thread",160060],"thread-159430":["thread",159430],"thread-159247":["thread",159247],"thread-158704":["thread",158704],"thread-157099":["thread",157099],"thread-156655":["thread",156655],"thread-153877":["thread",153877],"thread-152287":["thread",152287],"thread-151567":["thread",151567],"thread-149755":["thread",149755],"thread-146687":["thread",146687],"thread-146330":["thread",146330],"thread-146183":["thread",146183],"thread-145643":["thread",145643],"thread-144241":["thread",144241],"thread-141959":["thread",141959],"thread-140901":["thread",140901],"thread-139362":["thread",139362],"thread-139359":["thread",139359],"thread-137475":["thread",137475],"thread-136764":["thread",136764],"thread-136029":["thread",136029],"thread-135333":["thread",135333],"thread-129498":["thread",129498],"thread-129404":["thread",129404],"thread-128995":["thread",128995],"thread-128615":["thread",128615],"thread-128478":["thread",128478],"thread-128108":["thread",128108],"thread-127719":["thread",127719],"thread-127074":["thread",127074],"thread-126732":["thread",126732],"thread-126187":["thread",126187],"thread-125880":["thread",125880],"thread-125555":["thread",125555],"thread-125258":["thread",125258],"thread-125115":["thread",125115],"thread-124504":["thread",124504],"thread-124128":["thread",124128],"thread-123713":["thread",123713],"thread-123487":["thread",123487],"thread-122444":["thread",122444],"thread-121221":["thread",121221],"thread-120957":["thread",120957],"thread-120819":["thread",120819],"thread-120818":["thread",120818],"thread-120753":["thread",120753],"thread-120717":["thread",120717],"thread-120521":["thread",120521],"thread-120504":["thread",120504],"thread-120449":["thread",120449],"thread-120284":["thread",120284],"thread-120233":["thread",120233],"thread-119704":["thread",119704],"thread-118975":["thread",118975],"thread-117795":["thread",117795],"thread-117744":["thread",117744],"thread-117687":["thread",117687],"thread-117682":["thread",117682],"thread-117680":["thread",117680],"thread-117320":["thread",117320],"thread-117289":["thread",117289],"thread-117221":["thread",117221],"thread-116819":["thread",116819],"thread-115144":["thread",115144],"thread-114826":["thread",114826],"thread-114531":["thread",114531],"thread-114117":["thread",114117],"thread-113675":["thread",113675],"thread-112784":["thread",112784],"thread-112456":["thread",112456],"thread-111735":["thread",111735],"thread-111244":["thread",111244],"thread-111188":["thread",111188],"thread-110973":["thread",110973],"thread-110857":["thread",110857],"thread-110803":["thread",110803],"thread-110604":["thread",110604],"thread-110371":["thread",110371],"thread-110261":["thread",110261],"thread-110063":["thread",110063],"thread-109745":["thread",109745],"thread-109254":["thread",109254],"thread-108314":["thread",108314],"thread-108021":["thread",108021],"thread-107893":["thread",107893],"thread-107888":["thread",107888],"thread-107478":["thread",107478],"thread-107411":["thread",107411],"thread-107233":["thread",107233],"thread-107041":["thread",107041],"thread-106898":["thread",106898],"thread-106894":["thread",106894],"thread-106547":["thread",106547],"thread-106510":["thread",106510],"thread-106307":["thread",106307],"thread-106290":["thread",106290],"thread-106253":["thread",106253],"thread-106132":["thread",106132],"thread-106075":["thread",106075],"thread-105613":["thread",105613],"thread-105606":["thread",105606],"thread-105558":["thread",105558],"thread-105486":["thread",105486],"thread-105444":["thread",105444],"thread-105352":["thread",105352],"thread-105254":["thread",105254],"thread-105002":["thread",105002],"thread-104316":["thread",104316],"thread-103957":["thread",103957],"thread-103937":["thread",103937],"thread-103871":["thread",103871],"thread-103833":["thread",103833],"thread-103610":["thread",103610],"thread-103600":["thread",103600],"thread-103468":["thread",103468],"thread-103359":["thread",103359],"thread-103043":["thread",103043],"thread-103012":["thread",103012],"thread-102723":["thread",102723],"thread-102347":["thread",102347],"thread-102330":["thread",102330],"thread-102062":["thread",102062],"thread-101857":["thread",101857],"thread-101492":["thread",101492],"thread-100921":["thread",100921],"thread-100722":["thread",100722],"thread-100400":["thread",100400],"thread-100288":["thread",100288],"thread-99713":["thread",99713],"thread-99515":["thread",99515],"thread-99426":["thread",99426],"thread-98816":["thread",98816],"thread-98558":["thread",98558],"thread-98395":["thread",98395],"thread-98225":["thread",98225],"thread-98046":["thread",98046],"thread-97292":["thread",97292],"thread-97112":["thread",97112],"thread-96840":["thread",96840],"thread-96384":["thread",96384],"thread-96327":["thread",96327],"thread-95748":["thread",95748],"thread-95565":["thread",95565],"thread-95308":["thread",95308],"thread-95298":["thread",95298],"thread-95063":["thread",95063],"thread-94982":["thread",94982],"thread-94683":["thread",94683],"thread-94518":["thread",94518],"thread-93988":["thread",93988],"thread-92912":["thread",92912],"thread-92540":["thread",92540],"thread-92433":["thread",92433],"thread-92360":["thread",92360],"thread-92266":["thread",92266],"thread-91706":["thread",91706],"thread-91489":["thread",91489]}, , 1715052317
Run Time: 0.000612
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1510
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20