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 (179939, 172026, 167635, 163683, 158053, 157864, 156620, 153841, 132045, 131965, 131688, 131667, 131490, 131397, 129872, 128752, 128722, 127515, 123217, 123172, 122423, 122218, 121615, 121250, 120988, 120895, 120894, 120610, 120609, 120442, 120441, 120402, 120381, 120230, 120210, 120187, 119990, 119753, 119700, 119699, 119652, 119623, 119616, 119510, 119477, 115249, 105285, 104698, 104690, 104453, 104287, 104132, 103801, 103790, 103785, 103762, 103693, 103692, 103677, 103626, 103505, 103397, 103350, 93938, 91334, 75118, 75117, 70088, 69486, 66095, 65824, 65295, 63403, 54424, 51105))
Run Time: 0.049922
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 75 | 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: 8057, 0, 1715155927, {"thread-179939":["thread",179939],"thread-172026":["thread",172026],"tl_group-268":["tl_group",268],"thread-167635":["thread",167635],"thread-163683":["thread",163683],"thread-158053":["thread",158053],"thread-157864":["thread",157864],"thread-156620":["thread",156620],"thread-153841":["thread",153841],"thread-132045":["thread",132045],"thread-131965":["thread",131965],"thread-131688":["thread",131688],"thread-131667":["thread",131667],"thread-131490":["thread",131490],"thread-131397":["thread",131397],"thread-129872":["thread",129872],"thread-128752":["thread",128752],"thread-128722":["thread",128722],"thread-127515":["thread",127515],"thread-123217":["thread",123217],"thread-123172":["thread",123172],"thread-122423":["thread",122423],"thread-122218":["thread",122218],"thread-121615":["thread",121615],"thread-121250":["thread",121250],"thread-120988":["thread",120988],"thread-120895":["thread",120895],"thread-120894":["thread",120894],"thread-120610":["thread",120610],"thread-120609":["thread",120609],"thread-120442":["thread",120442],"thread-120441":["thread",120441],"thread-120402":["thread",120402],"thread-120381":["thread",120381],"thread-120230":["thread",120230],"thread-120210":["thread",120210],"thread-120187":["thread",120187],"thread-119990":["thread",119990],"thread-119753":["thread",119753],"thread-119700":["thread",119700],"thread-119699":["thread",119699],"thread-119652":["thread",119652],"thread-119623":["thread",119623],"thread-119616":["thread",119616],"thread-119510":["thread",119510],"thread-119477":["thread",119477],"thread-115249":["thread",115249],"thread-105285":["thread",105285],"thread-104698":["thread",104698],"thread-104690":["thread",104690],"thread-104453":["thread",104453],"thread-104287":["thread",104287],"thread-104132":["thread",104132],"thread-103801":["thread",103801],"thread-103790":["thread",103790],"thread-103785":["thread",103785],"thread-103762":["thread",103762],"thread-103693":["thread",103693],"thread-103692":["thread",103692],"thread-103677":["thread",103677],"thread-103626":["thread",103626],"thread-103505":["thread",103505],"thread-103397":["thread",103397],"thread-103350":["thread",103350],"thread-93938":["thread",93938],"thread-91334":["thread",91334],"thread-75118":["thread",75118],"thread-75117":["thread",75117],"thread-70088":["thread",70088],"thread-69486":["thread",69486],"thread-66095":["thread",66095],"thread-65824":["thread",65824],"thread-65295":["thread",65295],"thread-63403":["thread",63403],"thread-54424":["thread",54424],"thread-51105":["thread",51105]}, , 1715152327
Run Time: 0.000110
- 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