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 (218260, 218083, 217486, 214045, 211771, 211690, 210753, 210255, 209839, 207874, 207223, 203599, 202822, 202288, 202240, 201757, 201334, 200815, 200071, 200017, 199252, 197008, 196609, 195031, 192805, 192019, 188731, 188044, 185947, 184474, 183400, 182302, 181852, 181546, 180850, 179587, 177964, 176794, 174667, 174455, 174226, 168021, 167628, 166395, 166275, 165273, 162829, 162004, 160024, 159778, 155590, 155533, 155143, 154243, 154189, 154156, 152128, 151753, 148367, 146249, 145643, 144325, 143318, 141683, 140733, 139371, 138036, 136932, 135993, 135143, 133655, 130658, 130625, 129100, 128478, 128078, 128075, 127375, 127360, 127342, 126602, 126555, 125808, 125587, 125188, 124290, 124188, 123723, 123534, 123350, 121187, 120841, 120564, 120553, 120382, 119868, 119708, 119436, 119068, 118706, 118402, 118070, 118001, 117864, 116693, 116065, 113849, 113313, 112685, 112415, 111739, 111434, 111349, 110442, 109446, 109261, 108700, 108478, 107529, 106757, 106254, 106253, 106252, 106057, 106046, 105992, 105708, 105592, 105491, 105109, 105083, 103460, 103430, 102821, 102650, 102130, 102127, 101953, 101937, 100024, 99989, 99092, 98026, 97951, 97568, 97185, 96594, 96467, 95974, 95962, 95731, 95629, 95167, 94813, 94736, 94364, 93439, 92043, 92028, 91938, 91625))
Run Time: 0.006239
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 161 | 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: 331, 0, 1714238501, {"thread-218260":["thread",218260],"thread-218083":["thread",218083],"thread-217486":["thread",217486],"thread-214045":["thread",214045],"thread-211771":["thread",211771],"thread-211690":["thread",211690],"thread-210753":["thread",210753],"thread-210255":["thread",210255],"thread-209839":["thread",209839],"thread-207874":["thread",207874],"thread-207223":["thread",207223],"thread-203599":["thread",203599],"thread-202822":["thread",202822],"thread-202288":["thread",202288],"thread-202240":["thread",202240],"thread-201757":["thread",201757],"thread-201334":["thread",201334],"thread-200815":["thread",200815],"thread-200071":["thread",200071],"thread-200017":["thread",200017],"thread-199252":["thread",199252],"thread-197008":["thread",197008],"thread-196609":["thread",196609],"thread-195031":["thread",195031],"thread-192805":["thread",192805],"thread-192019":["thread",192019],"thread-188731":["thread",188731],"thread-188044":["thread",188044],"thread-185947":["thread",185947],"thread-184474":["thread",184474],"thread-183400":["thread",183400],"thread-182302":["thread",182302],"thread-181852":["thread",181852],"thread-181546":["thread",181546],"thread-180850":["thread",180850],"thread-179587":["thread",179587],"thread-177964":["thread",177964],"thread-176794":["thread",176794],"thread-174667":["thread",174667],"thread-174455":["thread",174455],"thread-174226":["thread",174226],"thread-168021":["thread",168021],"thread-167628":["thread",167628],"thread-166395":["thread",166395],"thread-166275":["thread",166275],"thread-165273":["thread",165273],"thread-162829":["thread",162829],"thread-162004":["thread",162004],"thread-160024":["thread",160024],"thread-159778":["thread",159778],"thread-155590":["thread",155590],"thread-155533":["thread",155533],"thread-155143":["thread",155143],"thread-154243":["thread",154243],"thread-154189":["thread",154189],"thread-154156":["thread",154156],"thread-152128":["thread",152128],"thread-151753":["thread",151753],"thread-148367":["thread",148367],"thread-146249":["thread",146249],"thread-145643":["thread",145643],"thread-144325":["thread",144325],"thread-143318":["thread",143318],"thread-141683":["thread",141683],"thread-140733":["thread",140733],"thread-139371":["thread",139371],"thread-138036":["thread",138036],"thread-136932":["thread",136932],"thread-135993":["thread",135993],"thread-135143":["thread",135143],"thread-133655":["thread",133655],"thread-130658":["thread",130658],"thread-130625":["thread",130625],"thread-129100":["thread",129100],"thread-128478":["thread",128478],"thread-128078":["thread",128078],"thread-128075":["thread",128075],"thread-127375":["thread",127375],"thread-127360":["thread",127360],"thread-127342":["thread",127342],"thread-126602":["thread",126602],"thread-126555":["thread",126555],"thread-125808":["thread",125808],"thread-125587":["thread",125587],"thread-125188":["thread",125188],"thread-124290":["thread",124290],"thread-124188":["thread",124188],"thread-123723":["thread",123723],"thread-123534":["thread",123534],"thread-123350":["thread",123350],"thread-121187":["thread",121187],"thread-120841":["thread",120841],"thread-120564":["thread",120564],"thread-120553":["thread",120553],"thread-120382":["thread",120382],"thread-119868":["thread",119868],"thread-119708":["thread",119708],"thread-119436":["thread",119436],"thread-119068":["thread",119068],"thread-118706":["thread",118706],"thread-118402":["thread",118402],"thread-118070":["thread",118070],"thread-118001":["thread",118001],"thread-117864":["thread",117864],"thread-116693":["thread",116693],"thread-116065":["thread",116065],"thread-113849":["thread",113849],"thread-113313":["thread",113313],"thread-112685":["thread",112685],"thread-112415":["thread",112415],"thread-111739":["thread",111739],"thread-111434":["thread",111434],"thread-111349":["thread",111349],"thread-110442":["thread",110442],"thread-109446":["thread",109446],"thread-109261":["thread",109261],"thread-108700":["thread",108700],"thread-108478":["thread",108478],"thread-107529":["thread",107529],"thread-106757":["thread",106757],"thread-106254":["thread",106254],"thread-106253":["thread",106253],"thread-106252":["thread",106252],"thread-106057":["thread",106057],"thread-106046":["thread",106046],"thread-105992":["thread",105992],"thread-105708":["thread",105708],"thread-105592":["thread",105592],"thread-105491":["thread",105491],"thread-105109":["thread",105109],"thread-105083":["thread",105083],"thread-103460":["thread",103460],"thread-103430":["thread",103430],"thread-102821":["thread",102821],"thread-102650":["thread",102650],"thread-102130":["thread",102130],"thread-102127":["thread",102127],"thread-101953":["thread",101953],"thread-101937":["thread",101937],"thread-100024":["thread",100024],"thread-99989":["thread",99989],"thread-99092":["thread",99092],"thread-98026":["thread",98026],"thread-97951":["thread",97951],"thread-97568":["thread",97568],"thread-97185":["thread",97185],"thread-96594":["thread",96594],"thread-96467":["thread",96467],"thread-95974":["thread",95974],"thread-95962":["thread",95962],"thread-95731":["thread",95731],"thread-95629":["thread",95629],"thread-95167":["thread",95167],"thread-94813":["thread",94813],"thread-94736":["thread",94736],"thread-94364":["thread",94364],"thread-93439":["thread",93439],"thread-92043":["thread",92043],"thread-92028":["thread",92028],"thread-91938":["thread",91938],"thread-91625":["thread",91625]}, , 1714234901
Run Time: 0.000826
- 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