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 (182035, 181821, 180957, 180903, 180834, 180761, 180686, 180002, 179778, 178338, 176851, 176639, 176392, 176361, 175758, 175747, 175519, 175518, 175517, 175320, 173703, 173509, 173491, 173002, 172539, 172144, 172030, 170826, 170422, 169602, 169271, 168673, 168662, 168661, 168658, 168633, 168452, 167981, 167888, 167759, 167556, 167260, 166859, 166198, 166081, 166079, 164138, 163983, 163539, 163426, 163389, 162578, 160672, 158082, 158044, 156249, 155946, 155217, 154467, 154186, 154154, 153984, 153891, 153537, 153267, 153028, 152633, 152504, 145145, 138454, 137785, 131353, 130513, 130456, 130455, 129094, 128860, 128807, 127989, 127869, 127667, 127080, 126732, 126599, 126285, 125836, 124559, 124314, 124312, 124311, 124300, 119105, 114557, 113879, 112066, 111616, 111207, 110174, 109758, 109485, 109359, 109189, 107728, 105830, 105761, 103430, 103257, 103153, 99977, 97447, 96149, 95671, 95364, 92526, 91152, 87568, 87203, 80553, 76725, 76713, 75916, 71140, 68090, 66884, 64396, 57463, 54219, 53444, 50752, 50751, 49883, 36252, 12740, 12165, 4075, 5048))
Run Time: 0.080288
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 136 | 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: 1291, 0, 1715636262, {"thread-182035":["thread",182035],"thread-181821":["thread",181821],"thread-180957":["thread",180957],"thread-180903":["thread",180903],"thread-180834":["thread",180834],"thread-180761":["thread",180761],"thread-180686":["thread",180686],"thread-180002":["thread",180002],"thread-179778":["thread",179778],"thread-178338":["thread",178338],"thread-176851":["thread",176851],"thread-176639":["thread",176639],"thread-176392":["thread",176392],"thread-176361":["thread",176361],"thread-175758":["thread",175758],"thread-175747":["thread",175747],"thread-175519":["thread",175519],"thread-175518":["thread",175518],"thread-175517":["thread",175517],"thread-175320":["thread",175320],"thread-173703":["thread",173703],"thread-173509":["thread",173509],"thread-173491":["thread",173491],"thread-173002":["thread",173002],"thread-172539":["thread",172539],"thread-172144":["thread",172144],"thread-172030":["thread",172030],"thread-170826":["thread",170826],"thread-170422":["thread",170422],"thread-169602":["thread",169602],"thread-169271":["thread",169271],"thread-168673":["thread",168673],"thread-168662":["thread",168662],"thread-168661":["thread",168661],"thread-168658":["thread",168658],"thread-168633":["thread",168633],"thread-168452":["thread",168452],"thread-167981":["thread",167981],"thread-167888":["thread",167888],"thread-167759":["thread",167759],"thread-167556":["thread",167556],"thread-167260":["thread",167260],"thread-166859":["thread",166859],"thread-166198":["thread",166198],"thread-166081":["thread",166081],"thread-166079":["thread",166079],"thread-164138":["thread",164138],"thread-163983":["thread",163983],"thread-163539":["thread",163539],"thread-163426":["thread",163426],"thread-163389":["thread",163389],"thread-162578":["thread",162578],"thread-160672":["thread",160672],"thread-158082":["thread",158082],"thread-158044":["thread",158044],"thread-156249":["thread",156249],"thread-155946":["thread",155946],"thread-155217":["thread",155217],"thread-154467":["thread",154467],"thread-154186":["thread",154186],"thread-154154":["thread",154154],"thread-153984":["thread",153984],"thread-153891":["thread",153891],"thread-153537":["thread",153537],"thread-153267":["thread",153267],"thread-153028":["thread",153028],"thread-152633":["thread",152633],"thread-152504":["thread",152504],"thread-145145":["thread",145145],"thread-138454":["thread",138454],"thread-137785":["thread",137785],"thread-131353":["thread",131353],"thread-130513":["thread",130513],"thread-130456":["thread",130456],"thread-130455":["thread",130455],"thread-129094":["thread",129094],"thread-128860":["thread",128860],"thread-128807":["thread",128807],"thread-127989":["thread",127989],"thread-127869":["thread",127869],"thread-127667":["thread",127667],"thread-127080":["thread",127080],"thread-126732":["thread",126732],"thread-126599":["thread",126599],"thread-126285":["thread",126285],"thread-125836":["thread",125836],"thread-124559":["thread",124559],"thread-124314":["thread",124314],"thread-124312":["thread",124312],"thread-124311":["thread",124311],"thread-124300":["thread",124300],"thread-119105":["thread",119105],"thread-114557":["thread",114557],"thread-113879":["thread",113879],"thread-112066":["thread",112066],"thread-111616":["thread",111616],"thread-111207":["thread",111207],"thread-110174":["thread",110174],"thread-109758":["thread",109758],"thread-109485":["thread",109485],"thread-109359":["thread",109359],"thread-109189":["thread",109189],"thread-107728":["thread",107728],"thread-105830":["thread",105830],"thread-105761":["thread",105761],"thread-103430":["thread",103430],"thread-103257":["thread",103257],"thread-103153":["thread",103153],"thread-99977":["thread",99977],"thread-97447":["thread",97447],"thread-96149":["thread",96149],"thread-95671":["thread",95671],"thread-95364":["thread",95364],"thread-92526":["thread",92526],"thread-91152":["thread",91152],"thread-87568":["thread",87568],"thread-87203":["thread",87203],"thread-80553":["thread",80553],"thread-76725":["thread",76725],"thread-76713":["thread",76713],"thread-75916":["thread",75916],"thread-71140":["thread",71140],"thread-68090":["thread",68090],"thread-66884":["thread",66884],"thread-64396":["thread",64396],"thread-57463":["thread",57463],"thread-54219":["thread",54219],"thread-53444":["thread",53444],"thread-50752":["thread",50752],"thread-50751":["thread",50751],"thread-49883":["thread",49883],"thread-36252":["thread",36252],"thread-12740":["thread",12740],"thread-12165":["thread",12165],"thread-4075":["thread",4075],"thread-5048":["thread",5048]}, , 1715632662
Run Time: 0.000485
- 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