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 (182766, 181523, 181344, 176519, 175829, 175209, 173753, 173481, 172411, 171988, 170822, 169349, 168745, 166589, 165461, 165419, 163982, 162771, 161329, 160799, 160172, 159954, 159705, 159198, 159166, 159123, 158188, 158122, 158048, 158047, 158046, 158045, 158044, 157652, 157474, 157473, 157472, 157471, 157335, 157333, 157332, 157315, 157283, 157282, 155931, 155888, 155713, 155674, 155507, 155392, 155391, 155208, 154629, 154467, 154466, 154125, 154119, 153501, 153357, 153354, 153351, 153110, 153095, 151970, 112258, 107753, 85016, 78195, 76692, 76483, 53615))
Run Time: 0.049416
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 71 | 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: 8786, 0, 1715940912, {"thread-182766":["thread",182766],"thread-181523":["thread",181523],"thread-181344":["thread",181344],"thread-176519":["thread",176519],"thread-175829":["thread",175829],"thread-175209":["thread",175209],"thread-173753":["thread",173753],"thread-173481":["thread",173481],"thread-172411":["thread",172411],"thread-171988":["thread",171988],"thread-170822":["thread",170822],"thread-169349":["thread",169349],"thread-168745":["thread",168745],"thread-166589":["thread",166589],"thread-165461":["thread",165461],"thread-165419":["thread",165419],"thread-163982":["thread",163982],"thread-162771":["thread",162771],"thread-161329":["thread",161329],"thread-160799":["thread",160799],"thread-160172":["thread",160172],"thread-159954":["thread",159954],"thread-159705":["thread",159705],"thread-159198":["thread",159198],"thread-159166":["thread",159166],"thread-159123":["thread",159123],"thread-158188":["thread",158188],"thread-158122":["thread",158122],"thread-158048":["thread",158048],"thread-158047":["thread",158047],"thread-158046":["thread",158046],"thread-158045":["thread",158045],"thread-158044":["thread",158044],"thread-157652":["thread",157652],"thread-157474":["thread",157474],"thread-157473":["thread",157473],"thread-157472":["thread",157472],"thread-157471":["thread",157471],"thread-157335":["thread",157335],"thread-157333":["thread",157333],"thread-157332":["thread",157332],"thread-157315":["thread",157315],"thread-157283":["thread",157283],"thread-157282":["thread",157282],"thread-155931":["thread",155931],"thread-155888":["thread",155888],"thread-155713":["thread",155713],"thread-155674":["thread",155674],"thread-155507":["thread",155507],"thread-155392":["thread",155392],"thread-155391":["thread",155391],"thread-155208":["thread",155208],"thread-154629":["thread",154629],"thread-154467":["thread",154467],"thread-154466":["thread",154466],"thread-154125":["thread",154125],"thread-154119":["thread",154119],"thread-153501":["thread",153501],"thread-153357":["thread",153357],"thread-153354":["thread",153354],"thread-153351":["thread",153351],"thread-153110":["thread",153110],"thread-153095":["thread",153095],"thread-151970":["thread",151970],"thread-112258":["thread",112258],"thread-107753":["thread",107753],"thread-85016":["thread",85016],"thread-78195":["thread",78195],"thread-76692":["thread",76692],"thread-76483":["thread",76483],"thread-53615":["thread",53615]}, , 1715937312
Run Time: 0.000383
- 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