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 (183199, 183174, 183122, 183034, 182650, 181637, 180808, 180476, 180236, 179829, 179730, 179501, 179284, 179014, 178771, 176722, 176674, 176633, 176587, 176378, 176312, 176292, 175941, 175886, 175789, 175566, 175071, 174462, 174260, 174188, 174063, 173844, 173527, 173511, 172413, 172354, 172305, 171821, 171541, 169967, 169505, 169411, 169340, 168530, 167496, 167270, 167243, 167176, 166817, 166293, 165655, 165603, 163975, 163662, 163595, 163321, 162933, 162850, 162622, 162564, 161993, 161778, 161684, 161342, 161338, 161248, 160372, 159968, 159914, 159604, 159370, 159311, 158272, 157619, 157505, 157451, 155949, 155553, 155521, 154401, 154046, 153928, 153593, 153538, 153277, 152948, 152415, 152186, 151851, 151846, 89591, 62486))
Run Time: 0.032641
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 92 | 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: 11180, 0, 1715803172, {"thread-183199":["thread",183199],"thread-183174":["thread",183174],"thread-183122":["thread",183122],"thread-183034":["thread",183034],"thread-182650":["thread",182650],"thread-181637":["thread",181637],"thread-180808":["thread",180808],"thread-180476":["thread",180476],"thread-180236":["thread",180236],"thread-179829":["thread",179829],"thread-179730":["thread",179730],"thread-179501":["thread",179501],"thread-179284":["thread",179284],"thread-179014":["thread",179014],"thread-178771":["thread",178771],"thread-176722":["thread",176722],"thread-176674":["thread",176674],"thread-176633":["thread",176633],"thread-176587":["thread",176587],"thread-176378":["thread",176378],"thread-176312":["thread",176312],"thread-176292":["thread",176292],"thread-175941":["thread",175941],"thread-175886":["thread",175886],"thread-175789":["thread",175789],"thread-175566":["thread",175566],"thread-175071":["thread",175071],"thread-174462":["thread",174462],"thread-174260":["thread",174260],"thread-174188":["thread",174188],"thread-174063":["thread",174063],"thread-173844":["thread",173844],"thread-173527":["thread",173527],"thread-173511":["thread",173511],"thread-172413":["thread",172413],"thread-172354":["thread",172354],"thread-172305":["thread",172305],"thread-171821":["thread",171821],"thread-171541":["thread",171541],"thread-169967":["thread",169967],"thread-169505":["thread",169505],"thread-169411":["thread",169411],"thread-169340":["thread",169340],"thread-168530":["thread",168530],"thread-167496":["thread",167496],"thread-167270":["thread",167270],"thread-167243":["thread",167243],"thread-167176":["thread",167176],"thread-166817":["thread",166817],"thread-166293":["thread",166293],"thread-165655":["thread",165655],"thread-165603":["thread",165603],"thread-163975":["thread",163975],"thread-163662":["thread",163662],"thread-163595":["thread",163595],"thread-163321":["thread",163321],"thread-162933":["thread",162933],"thread-162850":["thread",162850],"thread-162622":["thread",162622],"thread-162564":["thread",162564],"thread-161993":["thread",161993],"thread-161778":["thread",161778],"thread-161684":["thread",161684],"thread-161342":["thread",161342],"thread-161338":["thread",161338],"thread-161248":["thread",161248],"thread-159968":["thread",159968],"thread-159914":["thread",159914],"thread-159604":["thread",159604],"thread-159370":["thread",159370],"thread-159311":["thread",159311],"thread-158272":["thread",158272],"thread-157619":["thread",157619],"thread-157505":["thread",157505],"thread-157451":["thread",157451],"thread-155949":["thread",155949],"thread-155553":["thread",155553],"thread-155521":["thread",155521],"thread-154401":["thread",154401],"thread-154046":["thread",154046],"thread-153928":["thread",153928],"thread-153593":["thread",153593],"thread-153538":["thread",153538],"thread-153277":["thread",153277],"thread-152948":["thread",152948],"thread-152415":["thread",152415],"thread-152186":["thread",152186],"thread-151851":["thread",151851],"thread-151846":["thread",151846],"thread-89591":["thread",89591],"thread-62486":["thread",62486]}, , 1715799572
Run Time: 0.000401
- 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