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 (182848, 181531, 181466, 181350, 180401, 179215, 178689, 177512, 177381, 177327, 176584, 176448, 176232, 175900, 175410, 174738, 174581, 174452, 174423, 173845, 173557, 173553, 173038, 173035, 173034, 171007, 170908, 170681, 170526, 170517, 170508, 170418, 170245, 169422, 168017, 167933, 167215, 166991, 166954, 166646, 166330, 165902, 165892, 165394, 165237, 165066, 163916, 163878, 163743, 163466, 163413, 163324, 163293, 162607, 162589, 162240, 162084, 161505, 161319, 160730, 160480, 160055, 159716, 159487, 159251, 159070, 158781, 158457, 158052, 157899, 157600, 157504, 157413, 157298, 157028, 156396, 156070, 155977, 155668, 155589, 155553, 155115, 155109, 154971, 154969, 154916, 154874, 154826, 154715, 154528, 154469, 154241, 154114, 152479, 152284, 152266, 79996, 25834))
Run Time: 0.040166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 98 | 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: 3379, 0, 1715574462, {"thread-182848":["thread",182848],"thread-181531":["thread",181531],"thread-181466":["thread",181466],"thread-181350":["thread",181350],"thread-180401":["thread",180401],"thread-179215":["thread",179215],"thread-178689":["thread",178689],"thread-177512":["thread",177512],"thread-177381":["thread",177381],"thread-177327":["thread",177327],"thread-176584":["thread",176584],"thread-176448":["thread",176448],"thread-176232":["thread",176232],"thread-175900":["thread",175900],"thread-175410":["thread",175410],"thread-174738":["thread",174738],"thread-174581":["thread",174581],"thread-174452":["thread",174452],"thread-174423":["thread",174423],"thread-173845":["thread",173845],"thread-173557":["thread",173557],"thread-173553":["thread",173553],"thread-173038":["thread",173038],"thread-173035":["thread",173035],"thread-173034":["thread",173034],"thread-171007":["thread",171007],"thread-170908":["thread",170908],"thread-170681":["thread",170681],"thread-170526":["thread",170526],"thread-170517":["thread",170517],"thread-170508":["thread",170508],"thread-170418":["thread",170418],"thread-170245":["thread",170245],"thread-169422":["thread",169422],"thread-168017":["thread",168017],"thread-167933":["thread",167933],"thread-167215":["thread",167215],"thread-166991":["thread",166991],"thread-166954":["thread",166954],"thread-166646":["thread",166646],"thread-166330":["thread",166330],"thread-165902":["thread",165902],"thread-165892":["thread",165892],"thread-165394":["thread",165394],"thread-165237":["thread",165237],"thread-165066":["thread",165066],"thread-163916":["thread",163916],"thread-163878":["thread",163878],"thread-163743":["thread",163743],"thread-163466":["thread",163466],"thread-163413":["thread",163413],"thread-163324":["thread",163324],"thread-163293":["thread",163293],"thread-162607":["thread",162607],"thread-162589":["thread",162589],"thread-162240":["thread",162240],"thread-162084":["thread",162084],"thread-161505":["thread",161505],"thread-161319":["thread",161319],"thread-160730":["thread",160730],"thread-160480":["thread",160480],"thread-160055":["thread",160055],"thread-159716":["thread",159716],"thread-159487":["thread",159487],"thread-159251":["thread",159251],"thread-159070":["thread",159070],"thread-158781":["thread",158781],"thread-158457":["thread",158457],"thread-158052":["thread",158052],"thread-157899":["thread",157899],"thread-157600":["thread",157600],"thread-157504":["thread",157504],"thread-157413":["thread",157413],"thread-157298":["thread",157298],"thread-157028":["thread",157028],"thread-156396":["thread",156396],"thread-156070":["thread",156070],"thread-155977":["thread",155977],"thread-155668":["thread",155668],"thread-155589":["thread",155589],"thread-155553":["thread",155553],"thread-155115":["thread",155115],"thread-155109":["thread",155109],"thread-154971":["thread",154971],"thread-154969":["thread",154969],"thread-154916":["thread",154916],"thread-154874":["thread",154874],"thread-154826":["thread",154826],"thread-154715":["thread",154715],"thread-154528":["thread",154528],"thread-154469":["thread",154469],"thread-154241":["thread",154241],"thread-154114":["thread",154114],"thread-152479":["thread",152479],"thread-152284":["thread",152284],"thread-152266":["thread",152266],"thread-79996":["thread",79996],"thread-25834":["thread",25834]}, , 1715570862
Run Time: 0.000171
- 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