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 (180144, 180010, 179781, 177631, 177208, 175743, 175180, 175005, 175004, 174963, 174939, 174548, 174422, 174373, 174313, 174244, 174238, 174192, 174119, 173946, 173723, 173707, 173179, 173178, 173176, 173159, 173158, 173155, 173059, 172948, 172838, 172637, 172521, 171948, 171795, 171547, 171546, 171370, 171340, 171152, 171104, 170811, 170756, 170632, 169890, 169866, 169819, 169791, 169638, 169630, 169597, 169229, 168485, 168085, 168078, 167991, 167775, 167538, 167269, 167245, 167239, 166883, 166794, 166706, 166504, 166259, 166104, 165327, 165324, 165323, 165142, 164971, 164412, 164339, 164136, 164045, 164011, 163922, 163752, 163751, 163504, 163416, 163405, 163154, 163132, 163015, 162814, 162806, 162747, 162660, 162376, 162372, 162269, 162229, 161999, 161995, 161988, 161866, 161841, 161633, 161624, 161542, 161462, 161367, 161259, 161177, 161088, 160986, 160623, 160619, 160436, 138478, 127017, 120418, 119732, 119297, 118661, 118387, 118379, 118378, 118338, 117989, 117887, 117789, 117761, 117705, 117635, 117544, 117541, 117532, 117524, 117435, 117292, 117252, 117130, 117129, 117128, 117096, 117095, 116984, 116983, 116862, 116830, 116801, 116800, 116799, 116727, 116675, 116587, 116571, 116537, 116499, 116492, 116435, 116419, 116344, 116196, 116187, 116090, 115753, 115637, 115468, 115328, 115285, 115205, 115144, 114999, 114960, 114933, 114892, 114708, 114434, 44294))
Run Time: 0.139878
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 173 | 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: 6456, 0, 1716375966, {"thread-180144":["thread",180144],"thread-180010":["thread",180010],"thread-179781":["thread",179781],"thread-177631":["thread",177631],"thread-177208":["thread",177208],"thread-175743":["thread",175743],"thread-175180":["thread",175180],"thread-175005":["thread",175005],"thread-175004":["thread",175004],"thread-174963":["thread",174963],"thread-174939":["thread",174939],"thread-174548":["thread",174548],"thread-174422":["thread",174422],"thread-174373":["thread",174373],"thread-174313":["thread",174313],"thread-174244":["thread",174244],"thread-174238":["thread",174238],"thread-174192":["thread",174192],"thread-174119":["thread",174119],"thread-173946":["thread",173946],"ams_article-4983":["ams_article",4983],"thread-173723":["thread",173723],"thread-173707":["thread",173707],"thread-173179":["thread",173179],"thread-173178":["thread",173178],"thread-173176":["thread",173176],"thread-173159":["thread",173159],"thread-173158":["thread",173158],"thread-173155":["thread",173155],"thread-173059":["thread",173059],"thread-172948":["thread",172948],"thread-172838":["thread",172838],"thread-172637":["thread",172637],"thread-172521":["thread",172521],"thread-171948":["thread",171948],"thread-171795":["thread",171795],"thread-171547":["thread",171547],"thread-171546":["thread",171546],"thread-171370":["thread",171370],"thread-171340":["thread",171340],"thread-171152":["thread",171152],"thread-171104":["thread",171104],"thread-170811":["thread",170811],"ams_article-4831":["ams_article",4831],"thread-170756":["thread",170756],"thread-170632":["thread",170632],"thread-169890":["thread",169890],"thread-169866":["thread",169866],"thread-169819":["thread",169819],"thread-169791":["thread",169791],"thread-169638":["thread",169638],"thread-169630":["thread",169630],"thread-169597":["thread",169597],"thread-169229":["thread",169229],"thread-168485":["thread",168485],"thread-168085":["thread",168085],"thread-168078":["thread",168078],"thread-167991":["thread",167991],"thread-167775":["thread",167775],"thread-167538":["thread",167538],"thread-167269":["thread",167269],"thread-167245":["thread",167245],"thread-167239":["thread",167239],"thread-166883":["thread",166883],"thread-166794":["thread",166794],"thread-166706":["thread",166706],"thread-166504":["thread",166504],"thread-166259":["thread",166259],"thread-166104":["thread",166104],"thread-165327":["thread",165327],"thread-165324":["thread",165324],"thread-165323":["thread",165323],"thread-165142":["thread",165142],"thread-164971":["thread",164971],"thread-164412":["thread",164412],"thread-164339":["thread",164339],"thread-164136":["thread",164136],"thread-164045":["thread",164045],"thread-164011":["thread",164011],"thread-163922":["thread",163922],"thread-163752":["thread",163752],"thread-163751":["thread",163751],"thread-163504":["thread",163504],"thread-163416":["thread",163416],"thread-163405":["thread",163405],"thread-163154":["thread",163154],"thread-163132":["thread",163132],"thread-163015":["thread",163015],"thread-162814":["thread",162814],"thread-162806":["thread",162806],"thread-162747":["thread",162747],"thread-162660":["thread",162660],"thread-162376":["thread",162376],"thread-162372":["thread",162372],"thread-162269":["thread",162269],"thread-162229":["thread",162229],"thread-161999":["thread",161999],"thread-161995":["thread",161995],"thread-161988":["thread",161988],"thread-161866":["thread",161866],"thread-161841":["thread",161841],"thread-161633":["thread",161633],"thread-161624":["thread",161624],"thread-161542":["thread",161542],"thread-161462":["thread",161462],"thread-161367":["thread",161367],"thread-161259":["thread",161259],"thread-161177":["thread",161177],"thread-161088":["thread",161088],"thread-160986":["thread",160986],"thread-160623":["thread",160623],"thread-160619":["thread",160619],"thread-160436":["thread",160436],"thread-138478":["thread",138478],"thread-127017":["thread",127017],"thread-120418":["thread",120418],"thread-119732":["thread",119732],"thread-119297":["thread",119297],"thread-118661":["thread",118661],"thread-118387":["thread",118387],"thread-118379":["thread",118379],"thread-118378":["thread",118378],"thread-118338":["thread",118338],"thread-117989":["thread",117989],"thread-117887":["thread",117887],"thread-117789":["thread",117789],"thread-117761":["thread",117761],"thread-117705":["thread",117705],"thread-117635":["thread",117635],"thread-117544":["thread",117544],"thread-117541":["thread",117541],"thread-117532":["thread",117532],"thread-117524":["thread",117524],"thread-117435":["thread",117435],"thread-117292":["thread",117292],"thread-117252":["thread",117252],"thread-117130":["thread",117130],"thread-117129":["thread",117129],"thread-117128":["thread",117128],"thread-117096":["thread",117096],"thread-117095":["thread",117095],"thread-116984":["thread",116984],"thread-116983":["thread",116983],"thread-116862":["thread",116862],"thread-116830":["thread",116830],"thread-116801":["thread",116801],"thread-116800":["thread",116800],"thread-116799":["thread",116799],"thread-116727":["thread",116727],"thread-116675":["thread",116675],"thread-116587":["thread",116587],"thread-116571":["thread",116571],"thread-116537":["thread",116537],"thread-116499":["thread",116499],"thread-116492":["thread",116492],"thread-116435":["thread",116435],"thread-116419":["thread",116419],"thread-116344":["thread",116344],"thread-116196":["thread",116196],"thread-116187":["thread",116187],"thread-116090":["thread",116090],"thread-115753":["thread",115753],"thread-115637":["thread",115637],"thread-115468":["thread",115468],"thread-115328":["thread",115328],"thread-115285":["thread",115285],"thread-115205":["thread",115205],"thread-115144":["thread",115144],"thread-114999":["thread",114999],"thread-114960":["thread",114960],"thread-114933":["thread",114933],"thread-114892":["thread",114892],"thread-114708":["thread",114708],"thread-114434":["thread",114434],"thread-44294":["thread",44294]}, , 1716372366
Run Time: 0.001053
- 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