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 (182808, 182095, 181954, 181537, 180918, 180833, 180796, 180567, 180489, 177952, 176375, 176369, 175948, 175532, 175242, 174982, 174962, 174854, 174616, 170620, 169766, 169484, 168644, 163992, 163787, 160358, 159600, 158924, 157494, 157255, 157088, 157003, 156826, 156825, 156084, 155348, 155312, 149280, 148187, 147282, 132988, 132889, 132723, 132633, 132049, 131962, 131772, 131757, 131648, 131510, 131204, 131200, 131183, 130998, 130927, 130877, 130549, 129446, 128791, 127492, 127226, 127148, 127094, 126960, 126753, 126682, 125748, 124729, 124139, 124076, 124075, 123876, 123229, 122946, 121627, 121341, 121250, 120463, 119136, 119126, 119100, 118077, 115448, 115251, 114912, 114461, 114395, 114289, 114288, 112265, 112045, 111709, 111623, 109780, 109530, 108767, 108649, 107414, 107046, 106336, 106206, 106177, 105183, 105053, 104922, 104476, 104321, 104187, 103758, 103205, 103168, 103167, 102974, 98997, 98728, 98724, 98643, 98444, 98376, 98359, 98059, 98053, 96548, 96159, 95337, 94884, 93878, 93630, 91404, 90006, 89869, 88693, 88637, 88025, 87045, 86971, 85836, 85447, 84907, 84628, 84301, 83805, 83011, 82988, 82717, 82072, 81503, 79830, 78956, 78901, 78705, 78372, 78234, 76686, 76106, 76035, 75891, 75732, 75641, 75551, 75548, 75433, 75092, 75052, 74777, 74661, 74659, 74648, 74633, 74631, 74505, 74488, 74268, 74206, 74021, 73954, 73942, 73933, 73880, 73866, 73751, 73668, 73519, 73386, 72623, 72014, 71907, 71400, 71292, 70296, 70072, 69881, 69709, 68732))
Run Time: 0.147658
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 194 | 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: 174, 0, 1715980016, {"thread-182808":["thread",182808],"thread-182095":["thread",182095],"thread-181954":["thread",181954],"thread-181537":["thread",181537],"thread-180918":["thread",180918],"thread-180833":["thread",180833],"thread-180796":["thread",180796],"thread-180567":["thread",180567],"thread-180489":["thread",180489],"ams_article-5161":["ams_article",5161],"thread-177952":["thread",177952],"ams_article-5125":["ams_article",5125],"thread-176375":["thread",176375],"thread-176369":["thread",176369],"ams_article-5098":["ams_article",5098],"thread-175948":["thread",175948],"ams_article-5083":["ams_article",5083],"thread-175532":["thread",175532],"thread-175242":["thread",175242],"thread-174982":["thread",174982],"thread-174962":["thread",174962],"thread-174854":["thread",174854],"thread-174616":["thread",174616],"ams_article-4985":["ams_article",4985],"ams_article-4946":["ams_article",4946],"thread-170620":["thread",170620],"thread-169766":["thread",169766],"thread-169484":["thread",169484],"thread-168644":["thread",168644],"thread-163992":["thread",163992],"thread-163787":["thread",163787],"thread-160358":["thread",160358],"thread-159600":["thread",159600],"thread-158924":["thread",158924],"thread-157494":["thread",157494],"thread-157255":["thread",157255],"thread-157088":["thread",157088],"thread-157003":["thread",157003],"thread-156826":["thread",156826],"thread-156825":["thread",156825],"thread-156084":["thread",156084],"thread-155348":["thread",155348],"thread-155312":["thread",155312],"thread-149280":["thread",149280],"thread-148187":["thread",148187],"thread-147282":["thread",147282],"thread-132988":["thread",132988],"thread-132889":["thread",132889],"thread-132723":["thread",132723],"thread-132633":["thread",132633],"thread-132049":["thread",132049],"thread-131962":["thread",131962],"thread-131772":["thread",131772],"thread-131757":["thread",131757],"thread-131648":["thread",131648],"thread-131510":["thread",131510],"thread-131204":["thread",131204],"thread-131200":["thread",131200],"thread-131183":["thread",131183],"thread-130998":["thread",130998],"thread-130927":["thread",130927],"thread-130877":["thread",130877],"thread-130549":["thread",130549],"thread-129446":["thread",129446],"thread-128791":["thread",128791],"thread-127492":["thread",127492],"thread-127226":["thread",127226],"thread-127148":["thread",127148],"thread-127094":["thread",127094],"thread-126960":["thread",126960],"thread-126753":["thread",126753],"thread-126682":["thread",126682],"thread-125748":["thread",125748],"thread-124729":["thread",124729],"thread-124139":["thread",124139],"thread-124076":["thread",124076],"thread-124075":["thread",124075],"thread-123876":["thread",123876],"thread-123229":["thread",123229],"thread-122946":["thread",122946],"thread-121627":["thread",121627],"thread-121341":["thread",121341],"thread-121250":["thread",121250],"thread-120463":["thread",120463],"thread-119136":["thread",119136],"thread-119126":["thread",119126],"thread-119100":["thread",119100],"thread-118077":["thread",118077],"thread-115448":["thread",115448],"thread-115251":["thread",115251],"thread-114912":["thread",114912],"thread-114461":["thread",114461],"thread-114395":["thread",114395],"thread-114289":["thread",114289],"thread-114288":["thread",114288],"thread-112265":["thread",112265],"thread-112045":["thread",112045],"thread-111709":["thread",111709],"thread-111623":["thread",111623],"thread-109780":["thread",109780],"thread-109530":["thread",109530],"thread-108767":["thread",108767],"thread-108649":["thread",108649],"thread-107414":["thread",107414],"thread-107046":["thread",107046],"thread-106336":["thread",106336],"thread-106206":["thread",106206],"thread-106177":["thread",106177],"thread-105183":["thread",105183],"thread-105053":["thread",105053],"thread-104922":["thread",104922],"thread-104476":["thread",104476],"thread-104321":["thread",104321],"thread-104187":["thread",104187],"thread-103758":["thread",103758],"thread-103205":["thread",103205],"thread-103168":["thread",103168],"thread-103167":["thread",103167],"thread-102974":["thread",102974],"thread-98997":["thread",98997],"thread-98728":["thread",98728],"thread-98724":["thread",98724],"thread-98643":["thread",98643],"thread-98444":["thread",98444],"thread-98376":["thread",98376],"thread-98359":["thread",98359],"thread-98059":["thread",98059],"thread-98053":["thread",98053],"thread-96548":["thread",96548],"thread-96159":["thread",96159],"thread-95337":["thread",95337],"thread-94884":["thread",94884],"thread-93878":["thread",93878],"thread-93630":["thread",93630],"thread-91404":["thread",91404],"thread-90006":["thread",90006],"thread-89869":["thread",89869],"thread-88693":["thread",88693],"thread-88637":["thread",88637],"thread-88025":["thread",88025],"thread-87045":["thread",87045],"thread-86971":["thread",86971],"thread-85836":["thread",85836],"thread-85447":["thread",85447],"thread-84907":["thread",84907],"thread-84628":["thread",84628],"thread-84301":["thread",84301],"thread-83805":["thread",83805],"thread-83011":["thread",83011],"thread-82988":["thread",82988],"thread-82717":["thread",82717],"thread-82072":["thread",82072],"thread-81503":["thread",81503],"thread-79830":["thread",79830],"thread-78956":["thread",78956],"thread-78901":["thread",78901],"thread-78705":["thread",78705],"thread-78372":["thread",78372],"thread-78234":["thread",78234],"thread-76686":["thread",76686],"thread-76106":["thread",76106],"thread-76035":["thread",76035],"thread-75891":["thread",75891],"thread-75732":["thread",75732],"thread-75641":["thread",75641],"thread-75551":["thread",75551],"thread-75548":["thread",75548],"thread-75433":["thread",75433],"thread-75092":["thread",75092],"thread-75052":["thread",75052],"thread-74777":["thread",74777],"thread-74661":["thread",74661],"thread-74659":["thread",74659],"thread-74648":["thread",74648],"thread-74633":["thread",74633],"thread-74631":["thread",74631],"thread-74505":["thread",74505],"thread-74488":["thread",74488],"thread-74268":["thread",74268],"thread-74206":["thread",74206],"thread-74021":["thread",74021],"thread-73954":["thread",73954],"thread-73942":["thread",73942],"thread-73933":["thread",73933],"thread-73880":["thread",73880],"thread-73866":["thread",73866],"thread-73751":["thread",73751],"thread-73668":["thread",73668],"thread-73519":["thread",73519],"thread-73386":["thread",73386],"thread-72623":["thread",72623],"thread-72014":["thread",72014],"thread-71907":["thread",71907],"thread-71400":["thread",71400],"thread-71292":["thread",71292],"thread-70296":["thread",70296],"thread-70072":["thread",70072],"thread-69881":["thread",69881],"thread-69709":["thread",69709],"thread-68732":["thread",68732]}, , 1715976416
Run Time: 0.000201
- 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