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 (176022, 175853, 175852, 175375, 175209, 175061, 173648, 173372, 172653, 172639, 172489, 172402, 172219, 171734, 170711, 170685, 170670, 170664, 170500, 170496, 170468, 170466, 170462, 170446, 170425, 170424, 170423, 170404, 170373, 170369, 170348, 170344, 170329, 170253, 170199, 170188, 170182, 170140, 170114, 170112, 170065, 170043, 170005, 169817, 169719, 169584, 169492, 169491, 169398, 169378, 169237, 169142, 169032, 168921, 168920, 168155, 165839, 165691, 165629, 165185, 164555, 163804, 163740, 163722, 163491, 163391, 163350, 163284, 163091, 163003, 162967, 162752, 162701, 162597, 162176, 162107, 162030, 161849, 161713, 161661, 160856, 159014, 158977, 158764, 158675, 158608, 157425, 157422, 157394, 157211, 157065, 157035, 155363, 154994, 154983, 154286, 154247, 153850, 152362, 152242, 152213, 151989, 151581, 151507, 151191, 151103, 150981, 150980, 150839, 150786, 150707, 150592, 150542, 150346, 150268, 150174, 150098, 150097, 149909, 149853, 149733, 149555, 149511, 149415, 149210, 149168, 149105, 149062, 149052, 148915, 147381, 146514, 146352, 146351, 146214, 146203, 145978, 141704, 141576, 141536, 141416, 141348, 140248, 107854))
Run Time: 0.112036
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 144 | 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: 35653, 0, 1716301000, {"thread-176022":["thread",176022],"thread-175853":["thread",175853],"thread-175852":["thread",175852],"thread-175375":["thread",175375],"thread-175209":["thread",175209],"thread-175061":["thread",175061],"thread-173648":["thread",173648],"thread-173372":["thread",173372],"thread-172653":["thread",172653],"thread-172639":["thread",172639],"thread-172489":["thread",172489],"thread-172402":["thread",172402],"thread-172219":["thread",172219],"thread-171734":["thread",171734],"thread-170711":["thread",170711],"thread-170685":["thread",170685],"thread-170670":["thread",170670],"thread-170664":["thread",170664],"thread-170500":["thread",170500],"thread-170496":["thread",170496],"thread-170468":["thread",170468],"thread-170466":["thread",170466],"thread-170462":["thread",170462],"thread-170446":["thread",170446],"thread-170425":["thread",170425],"thread-170424":["thread",170424],"thread-170423":["thread",170423],"thread-170404":["thread",170404],"thread-170373":["thread",170373],"thread-170369":["thread",170369],"thread-170348":["thread",170348],"thread-170344":["thread",170344],"thread-170329":["thread",170329],"thread-170253":["thread",170253],"thread-170199":["thread",170199],"thread-170188":["thread",170188],"thread-170182":["thread",170182],"thread-170140":["thread",170140],"ams_article-4821":["ams_article",4821],"thread-170114":["thread",170114],"thread-170112":["thread",170112],"thread-170065":["thread",170065],"thread-170043":["thread",170043],"thread-170005":["thread",170005],"thread-169817":["thread",169817],"thread-169719":["thread",169719],"thread-169584":["thread",169584],"thread-169492":["thread",169492],"thread-169491":["thread",169491],"thread-169398":["thread",169398],"thread-169378":["thread",169378],"thread-169237":["thread",169237],"thread-169142":["thread",169142],"thread-169032":["thread",169032],"thread-168921":["thread",168921],"thread-168920":["thread",168920],"thread-168155":["thread",168155],"thread-165839":["thread",165839],"thread-165691":["thread",165691],"thread-165629":["thread",165629],"thread-165185":["thread",165185],"thread-164555":["thread",164555],"thread-163804":["thread",163804],"thread-163740":["thread",163740],"thread-163722":["thread",163722],"thread-163491":["thread",163491],"thread-163391":["thread",163391],"ams_article-4531":["ams_article",4531],"thread-163350":["thread",163350],"thread-163284":["thread",163284],"thread-163091":["thread",163091],"thread-163003":["thread",163003],"thread-162967":["thread",162967],"thread-162752":["thread",162752],"thread-162701":["thread",162701],"thread-162597":["thread",162597],"thread-162176":["thread",162176],"thread-162107":["thread",162107],"thread-162030":["thread",162030],"thread-161849":["thread",161849],"thread-161713":["thread",161713],"thread-161661":["thread",161661],"thread-160856":["thread",160856],"thread-159014":["thread",159014],"thread-158977":["thread",158977],"thread-158764":["thread",158764],"thread-158675":["thread",158675],"thread-158608":["thread",158608],"thread-157425":["thread",157425],"thread-157422":["thread",157422],"thread-157394":["thread",157394],"thread-157211":["thread",157211],"thread-157065":["thread",157065],"thread-157035":["thread",157035],"thread-155363":["thread",155363],"thread-154994":["thread",154994],"thread-154983":["thread",154983],"thread-154286":["thread",154286],"thread-154247":["thread",154247],"thread-153850":["thread",153850],"thread-152362":["thread",152362],"thread-152242":["thread",152242],"thread-152213":["thread",152213],"thread-151989":["thread",151989],"thread-151581":["thread",151581],"thread-151507":["thread",151507],"thread-151191":["thread",151191],"thread-151103":["thread",151103],"thread-150981":["thread",150981],"thread-150980":["thread",150980],"thread-150839":["thread",150839],"thread-150786":["thread",150786],"thread-150707":["thread",150707],"thread-150592":["thread",150592],"thread-150542":["thread",150542],"thread-150346":["thread",150346],"thread-150268":["thread",150268],"thread-150174":["thread",150174],"thread-150098":["thread",150098],"thread-150097":["thread",150097],"thread-149909":["thread",149909],"thread-149853":["thread",149853],"thread-149733":["thread",149733],"thread-149555":["thread",149555],"thread-149511":["thread",149511],"thread-149415":["thread",149415],"thread-149210":["thread",149210],"thread-149168":["thread",149168],"thread-149105":["thread",149105],"thread-149062":["thread",149062],"thread-149052":["thread",149052],"thread-148915":["thread",148915],"thread-147381":["thread",147381],"thread-146514":["thread",146514],"thread-146352":["thread",146352],"thread-146351":["thread",146351],"thread-146214":["thread",146214],"thread-146203":["thread",146203],"thread-145978":["thread",145978],"thread-141704":["thread",141704],"thread-141576":["thread",141576],"thread-141536":["thread",141536],"thread-141416":["thread",141416],"thread-141348":["thread",141348],"thread-140248":["thread",140248],"thread-107854":["thread",107854]}, , 1716297400
Run Time: 0.001004
- 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