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 (183047, 182866, 182599, 182078, 181711, 181564, 181301, 180719, 180656, 180624, 180479, 180386, 180240, 180197, 180073, 178587, 178119, 177139, 168883, 168462, 168059, 167566, 167409, 166883, 165793, 164713, 164357, 162126, 161833, 160831, 160825, 159462, 157297, 156001, 155315, 154914, 152278, 142142, 137564, 137540, 135539, 132896, 131997, 128856, 128173, 124376, 124062, 123593, 122081, 122067, 121512, 119504, 118150, 115506, 114017, 113971, 113280, 113176, 112983, 112915, 112831, 112469, 112428, 110564, 109854, 109346, 108258, 106751, 106403, 105467, 104189, 101634, 101317, 100248, 99968, 99760, 94606, 94581, 94571, 94419, 94413, 94372, 93990, 91196, 90952, 89435, 87614, 87499, 87216, 86978, 86098, 85690, 84950, 81891, 77452, 77451, 76748, 75234, 75018, 74959, 73574, 73519, 73367, 72867, 72014, 71475, 71293, 70653, 70652, 70262, 69095, 68854, 68652, 67817, 66892, 64273, 62380, 62223, 61829, 60743, 59792, 58583, 56761, 51755, 50427, 44143, 41495, 39751, 39026, 28833, 23848, 22597, 20285, 19888, 18136, 17677, 3093))
Run Time: 0.103991
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 137 | 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: 2437, 0, 1715155429, {"thread-183047":["thread",183047],"thread-182866":["thread",182866],"thread-182599":["thread",182599],"thread-182078":["thread",182078],"thread-181711":["thread",181711],"thread-181564":["thread",181564],"thread-181301":["thread",181301],"thread-180719":["thread",180719],"thread-180656":["thread",180656],"thread-180624":["thread",180624],"thread-180479":["thread",180479],"thread-180386":["thread",180386],"thread-180240":["thread",180240],"thread-180197":["thread",180197],"thread-180073":["thread",180073],"thread-178587":["thread",178587],"thread-178119":["thread",178119],"thread-177139":["thread",177139],"thread-168883":["thread",168883],"thread-168462":["thread",168462],"thread-168059":["thread",168059],"thread-167566":["thread",167566],"thread-167409":["thread",167409],"thread-166883":["thread",166883],"thread-165793":["thread",165793],"thread-164713":["thread",164713],"thread-164357":["thread",164357],"thread-162126":["thread",162126],"thread-161833":["thread",161833],"thread-160831":["thread",160831],"thread-160825":["thread",160825],"thread-159462":["thread",159462],"thread-157297":["thread",157297],"thread-156001":["thread",156001],"thread-155315":["thread",155315],"thread-154914":["thread",154914],"thread-152278":["thread",152278],"thread-142142":["thread",142142],"thread-137564":["thread",137564],"thread-137540":["thread",137540],"thread-135539":["thread",135539],"thread-132896":["thread",132896],"thread-131997":["thread",131997],"thread-128856":["thread",128856],"thread-128173":["thread",128173],"thread-124376":["thread",124376],"thread-124062":["thread",124062],"thread-123593":["thread",123593],"thread-122081":["thread",122081],"thread-122067":["thread",122067],"thread-121512":["thread",121512],"thread-119504":["thread",119504],"thread-118150":["thread",118150],"thread-115506":["thread",115506],"thread-114017":["thread",114017],"thread-113971":["thread",113971],"thread-113280":["thread",113280],"thread-113176":["thread",113176],"thread-112983":["thread",112983],"thread-112915":["thread",112915],"thread-112831":["thread",112831],"thread-112469":["thread",112469],"thread-112428":["thread",112428],"thread-110564":["thread",110564],"thread-109854":["thread",109854],"thread-109346":["thread",109346],"thread-108258":["thread",108258],"thread-106751":["thread",106751],"thread-106403":["thread",106403],"thread-105467":["thread",105467],"thread-104189":["thread",104189],"thread-101634":["thread",101634],"thread-101317":["thread",101317],"thread-100248":["thread",100248],"thread-99968":["thread",99968],"thread-99760":["thread",99760],"thread-94606":["thread",94606],"thread-94581":["thread",94581],"thread-94571":["thread",94571],"thread-94419":["thread",94419],"thread-94413":["thread",94413],"thread-94372":["thread",94372],"thread-93990":["thread",93990],"thread-91196":["thread",91196],"thread-90952":["thread",90952],"thread-89435":["thread",89435],"thread-87614":["thread",87614],"thread-87499":["thread",87499],"thread-87216":["thread",87216],"thread-86978":["thread",86978],"thread-86098":["thread",86098],"thread-85690":["thread",85690],"thread-84950":["thread",84950],"thread-81891":["thread",81891],"thread-77452":["thread",77452],"thread-77451":["thread",77451],"thread-76748":["thread",76748],"thread-75234":["thread",75234],"thread-75018":["thread",75018],"thread-74959":["thread",74959],"thread-73574":["thread",73574],"thread-73519":["thread",73519],"thread-73367":["thread",73367],"thread-72867":["thread",72867],"thread-72014":["thread",72014],"thread-71475":["thread",71475],"thread-71293":["thread",71293],"thread-70653":["thread",70653],"thread-70652":["thread",70652],"thread-70262":["thread",70262],"thread-69095":["thread",69095],"thread-68854":["thread",68854],"thread-68652":["thread",68652],"thread-67817":["thread",67817],"thread-66892":["thread",66892],"thread-64273":["thread",64273],"thread-62380":["thread",62380],"thread-62223":["thread",62223],"thread-61829":["thread",61829],"thread-60743":["thread",60743],"thread-59792":["thread",59792],"thread-58583":["thread",58583],"thread-56761":["thread",56761],"thread-51755":["thread",51755],"thread-50427":["thread",50427],"thread-44143":["thread",44143],"thread-41495":["thread",41495],"thread-39751":["thread",39751],"thread-39026":["thread",39026],"thread-28833":["thread",28833],"thread-23848":["thread",23848],"thread-22597":["thread",22597],"thread-20285":["thread",20285],"thread-19888":["thread",19888],"thread-18136":["thread",18136],"thread-17677":["thread",17677],"thread-3093":["thread",3093]}, , 1715151829
Run Time: 0.000245
- 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