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 (183407, 183299, 183280, 183179, 182822, 182255, 182158, 182029, 181957, 181786, 181731, 181106, 180919, 180503, 180207, 179248, 178844, 178772, 178511, 178462, 178122, 177847, 177846, 177761, 177633, 177335, 176950, 176193, 176164, 176132, 175785, 175749, 175692, 175570, 175362, 174848, 174710, 174687, 174444, 174402, 173843, 173611, 173279, 173268, 173241, 173192, 173037, 172828, 172626, 172583, 172544, 171719, 171710, 171280, 171100, 170723, 170380, 170298, 170206, 170083, 170019, 169796, 169536, 169520, 169078, 168557, 168209, 168150, 167967, 167752, 167187, 166457, 165821, 165599, 165563, 165523, 165446, 165301, 164866, 164818, 164613, 164398, 164353, 163278, 163260, 163234, 163149, 163002, 162894, 162712, 162433, 162318, 162257, 162231, 162201, 161728, 161544, 161501, 161418, 161332, 161198, 161173, 160814, 160744, 160609, 160439, 160259, 160224, 160176, 160142, 160133, 160034, 159869, 159846, 159577, 159555, 159517, 159493, 159312, 158971, 158847, 158389, 158001, 157861, 157859, 157699, 157561, 157309, 157260, 156865, 156792, 156492, 156416, 155777, 155723, 155551, 155319, 155259, 155006, 154926, 154832, 154827, 154706, 154219, 153558, 153458, 152740, 152483, 152385, 151863, 151774, 151144, 141846, 109033, 94343, 94107, 88114, 79535, 64228, 52120, 24383, 15710, 15264))
Run Time: 0.051773
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 163 | 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: 2215, 0, 1716100896, {"thread-183407":["thread",183407],"thread-183299":["thread",183299],"thread-183280":["thread",183280],"thread-183179":["thread",183179],"thread-182822":["thread",182822],"thread-182255":["thread",182255],"thread-182158":["thread",182158],"thread-182029":["thread",182029],"thread-181957":["thread",181957],"thread-181786":["thread",181786],"thread-181731":["thread",181731],"thread-181106":["thread",181106],"thread-180919":["thread",180919],"thread-180503":["thread",180503],"thread-180207":["thread",180207],"thread-179248":["thread",179248],"thread-178844":["thread",178844],"thread-178772":["thread",178772],"thread-178511":["thread",178511],"thread-178462":["thread",178462],"thread-177847":["thread",177847],"thread-177846":["thread",177846],"thread-177761":["thread",177761],"thread-177633":["thread",177633],"thread-177335":["thread",177335],"thread-176950":["thread",176950],"thread-176193":["thread",176193],"thread-176164":["thread",176164],"thread-176132":["thread",176132],"thread-175785":["thread",175785],"thread-175749":["thread",175749],"thread-175692":["thread",175692],"thread-175570":["thread",175570],"thread-175362":["thread",175362],"thread-174848":["thread",174848],"thread-174710":["thread",174710],"thread-174687":["thread",174687],"thread-174444":["thread",174444],"thread-174402":["thread",174402],"thread-173843":["thread",173843],"thread-173611":["thread",173611],"thread-173279":["thread",173279],"thread-173268":["thread",173268],"thread-173241":["thread",173241],"thread-173192":["thread",173192],"thread-173037":["thread",173037],"thread-172828":["thread",172828],"thread-172626":["thread",172626],"thread-172583":["thread",172583],"thread-172544":["thread",172544],"thread-171719":["thread",171719],"thread-171710":["thread",171710],"thread-171280":["thread",171280],"thread-171100":["thread",171100],"thread-170723":["thread",170723],"thread-170380":["thread",170380],"thread-170298":["thread",170298],"thread-170206":["thread",170206],"thread-170083":["thread",170083],"thread-170019":["thread",170019],"thread-169796":["thread",169796],"thread-169536":["thread",169536],"thread-169520":["thread",169520],"thread-169078":["thread",169078],"thread-168557":["thread",168557],"thread-168209":["thread",168209],"thread-168150":["thread",168150],"thread-167967":["thread",167967],"thread-167752":["thread",167752],"thread-167187":["thread",167187],"thread-166457":["thread",166457],"thread-165821":["thread",165821],"thread-165599":["thread",165599],"thread-165563":["thread",165563],"thread-165523":["thread",165523],"thread-165446":["thread",165446],"thread-164866":["thread",164866],"thread-164818":["thread",164818],"thread-164613":["thread",164613],"thread-164398":["thread",164398],"thread-164353":["thread",164353],"thread-163278":["thread",163278],"thread-163260":["thread",163260],"thread-163234":["thread",163234],"thread-163149":["thread",163149],"thread-163002":["thread",163002],"thread-162894":["thread",162894],"thread-162712":["thread",162712],"thread-162433":["thread",162433],"thread-162318":["thread",162318],"thread-162257":["thread",162257],"thread-162231":["thread",162231],"thread-162201":["thread",162201],"thread-161728":["thread",161728],"thread-161544":["thread",161544],"thread-161501":["thread",161501],"thread-161418":["thread",161418],"thread-161332":["thread",161332],"thread-161198":["thread",161198],"thread-161173":["thread",161173],"thread-160814":["thread",160814],"thread-160744":["thread",160744],"thread-160609":["thread",160609],"thread-160439":["thread",160439],"thread-160259":["thread",160259],"thread-160224":["thread",160224],"thread-160176":["thread",160176],"thread-160142":["thread",160142],"thread-160133":["thread",160133],"thread-160034":["thread",160034],"thread-159869":["thread",159869],"thread-159846":["thread",159846],"thread-159555":["thread",159555],"thread-159517":["thread",159517],"thread-159312":["thread",159312],"thread-158971":["thread",158971],"thread-158847":["thread",158847],"thread-158389":["thread",158389],"thread-158001":["thread",158001],"thread-157861":["thread",157861],"thread-157859":["thread",157859],"thread-157699":["thread",157699],"thread-157561":["thread",157561],"thread-157309":["thread",157309],"thread-157260":["thread",157260],"thread-156865":["thread",156865],"thread-156792":["thread",156792],"thread-156492":["thread",156492],"thread-155777":["thread",155777],"thread-155723":["thread",155723],"thread-155551":["thread",155551],"thread-155319":["thread",155319],"thread-155259":["thread",155259],"thread-155006":["thread",155006],"thread-154926":["thread",154926],"thread-154832":["thread",154832],"thread-154827":["thread",154827],"thread-154706":["thread",154706],"thread-154219":["thread",154219],"thread-153558":["thread",153558],"thread-153458":["thread",153458],"thread-152740":["thread",152740],"thread-152483":["thread",152483],"thread-151863":["thread",151863],"thread-151774":["thread",151774],"thread-151144":["thread",151144],"thread-141846":["thread",141846],"thread-109033":["thread",109033],"thread-94343":["thread",94343],"thread-94107":["thread",94107],"thread-88114":["thread",88114],"thread-79535":["thread",79535],"thread-64228":["thread",64228],"thread-52120":["thread",52120],"thread-24383":["thread",24383],"thread-15710":["thread",15710],"thread-15264":["thread",15264]}, , 1716097296
Run Time: 0.000226
- 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