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 (132416, 132138, 131999, 131484, 131305, 131304, 131222, 131179, 130792, 130789, 130788, 130668, 130640, 130426, 130175, 130066, 130044, 129972, 129854, 129830, 129795, 129667, 129590, 129588, 129586, 129277, 129218, 128926, 128898, 128895, 128894, 128892, 128554, 128416, 128396, 128167, 128087, 128044, 127858, 127556, 127434, 127430, 127428, 127392, 127391, 127340, 127262, 127257, 127157, 126939, 126938, 126877, 126707, 126679, 126675, 126647, 126358, 126296, 126125, 126124, 125794, 125790, 125212, 124908, 124490, 124158, 121771, 119828, 119827, 119651, 119124, 117983, 117982, 117850, 117644, 116302, 115971, 114930, 114528, 114390, 114385, 113620, 113029, 112908, 112143, 112082, 111990, 111398, 110934, 110667, 109348, 107980, 107313, 107215, 106122, 103682, 103681, 100966, 100513, 100231, 100176, 100127, 99825, 98726, 98431, 97913, 97903, 93926, 93111, 92892, 90453, 89559, 89057, 87945))
Run Time: 0.052691
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 114 | 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: 19040, 0, 1714336306, {"thread-132416":["thread",132416],"thread-132138":["thread",132138],"thread-131999":["thread",131999],"thread-131484":["thread",131484],"thread-131305":["thread",131305],"thread-131304":["thread",131304],"thread-131222":["thread",131222],"thread-131179":["thread",131179],"thread-130792":["thread",130792],"thread-130789":["thread",130789],"thread-130788":["thread",130788],"thread-130668":["thread",130668],"thread-130640":["thread",130640],"thread-130426":["thread",130426],"thread-130175":["thread",130175],"thread-130066":["thread",130066],"thread-130044":["thread",130044],"thread-129972":["thread",129972],"thread-129854":["thread",129854],"thread-129830":["thread",129830],"thread-129795":["thread",129795],"thread-129667":["thread",129667],"thread-129590":["thread",129590],"thread-129588":["thread",129588],"thread-129586":["thread",129586],"thread-129277":["thread",129277],"thread-129218":["thread",129218],"thread-128926":["thread",128926],"thread-128898":["thread",128898],"thread-128895":["thread",128895],"thread-128894":["thread",128894],"thread-128892":["thread",128892],"thread-128554":["thread",128554],"thread-128416":["thread",128416],"thread-128396":["thread",128396],"thread-128167":["thread",128167],"thread-128087":["thread",128087],"thread-128044":["thread",128044],"thread-127858":["thread",127858],"thread-127556":["thread",127556],"thread-127434":["thread",127434],"thread-127430":["thread",127430],"thread-127428":["thread",127428],"thread-127392":["thread",127392],"thread-127391":["thread",127391],"thread-127340":["thread",127340],"thread-127262":["thread",127262],"thread-127257":["thread",127257],"thread-127157":["thread",127157],"thread-126939":["thread",126939],"thread-126938":["thread",126938],"thread-126877":["thread",126877],"thread-126707":["thread",126707],"thread-126679":["thread",126679],"thread-126675":["thread",126675],"thread-126647":["thread",126647],"thread-126358":["thread",126358],"thread-126296":["thread",126296],"thread-126125":["thread",126125],"thread-126124":["thread",126124],"thread-125794":["thread",125794],"thread-125790":["thread",125790],"thread-125212":["thread",125212],"thread-124908":["thread",124908],"thread-124490":["thread",124490],"thread-124158":["thread",124158],"thread-121771":["thread",121771],"thread-119828":["thread",119828],"thread-119827":["thread",119827],"thread-119651":["thread",119651],"thread-119124":["thread",119124],"thread-117983":["thread",117983],"thread-117982":["thread",117982],"thread-117850":["thread",117850],"thread-117644":["thread",117644],"thread-116302":["thread",116302],"thread-115971":["thread",115971],"thread-114930":["thread",114930],"thread-114528":["thread",114528],"thread-114390":["thread",114390],"thread-114385":["thread",114385],"thread-113620":["thread",113620],"thread-113029":["thread",113029],"thread-112908":["thread",112908],"thread-112143":["thread",112143],"thread-112082":["thread",112082],"thread-111990":["thread",111990],"thread-111398":["thread",111398],"thread-110934":["thread",110934],"thread-110667":["thread",110667],"thread-109348":["thread",109348],"thread-107980":["thread",107980],"thread-107313":["thread",107313],"thread-107215":["thread",107215],"thread-106122":["thread",106122],"thread-103682":["thread",103682],"thread-103681":["thread",103681],"thread-100966":["thread",100966],"thread-100513":["thread",100513],"thread-100231":["thread",100231],"thread-100176":["thread",100176],"thread-100127":["thread",100127],"thread-99825":["thread",99825],"thread-98726":["thread",98726],"thread-98431":["thread",98431],"thread-97913":["thread",97913],"thread-97903":["thread",97903],"thread-93926":["thread",93926],"thread-93111":["thread",93111],"thread-92892":["thread",92892],"thread-90453":["thread",90453],"thread-89559":["thread",89559],"thread-89057":["thread",89057],"thread-87945":["thread",87945]}, , 1714332706
Run Time: 0.000309
- 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