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 (108849, 107882, 107625, 107623, 107327, 107302, 107098, 106875, 106776, 106090, 105932, 105688, 105229, 105021, 104783, 104657, 104486, 104200, 103096, 103081, 102941, 101716, 101702, 101517, 101356, 101181, 101180, 100694, 100332, 99978, 99942, 99802, 99704, 99401, 99390, 98801, 98670, 98544, 98396, 98356, 98351, 98327, 98047, 97784, 97682, 97538, 97199, 96599, 96301, 96241, 96177, 95988, 95582, 95578, 95564, 95529, 95399, 94788, 94702, 94640, 94599, 94328, 94292, 94030, 93992, 93870, 93813, 92686, 92600, 92267, 92128, 91762, 91725, 91606, 91579, 91297, 91250, 91200, 91189, 91084, 91057, 90986, 90703, 90661, 90564, 90454, 90365, 90313, 90174, 90154, 89912, 89876, 89440, 89241, 89151, 89126, 89075, 88299, 87967, 87743, 87711, 87514, 87415, 87338, 87255, 87242, 87233, 87165, 87139, 86930, 86818, 86757, 86183, 86099, 85938, 85806, 85559, 85238, 85054, 84760, 83900, 83100, 82678, 82549, 82204, 82088, 82012, 81899, 81543, 81531, 80933, 80310, 80260, 80249, 79962, 79594, 79447, 79075, 78537, 78143, 76917, 76567, 76486, 76460, 76030, 76028, 75990, 75682, 75639, 75293, 75266, 74828, 74717, 74697, 74689, 74047, 73700, 73291, 72793, 72383, 72014, 71582, 71219, 71131, 71128, 70999, 70828, 70715, 69847, 69745, 69452, 69198, 69105, 69043, 68872, 68808, 68434, 67542, 67495, 66852, 66780, 66463, 66017, 65793))
Run Time: 0.712113
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 184 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,terrylove_forums.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 1430
- 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 2866
- 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 2483
- XF\App->run() in src/XF.php at line 524
- 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: 640, 0, 1715778459, {"thread-108849":["thread",108849],"thread-107882":["thread",107882],"thread-107625":["thread",107625],"thread-107623":["thread",107623],"thread-107327":["thread",107327],"thread-107302":["thread",107302],"thread-107098":["thread",107098],"thread-106875":["thread",106875],"thread-106776":["thread",106776],"thread-106090":["thread",106090],"thread-105932":["thread",105932],"thread-105688":["thread",105688],"thread-105229":["thread",105229],"thread-105021":["thread",105021],"thread-104783":["thread",104783],"thread-104657":["thread",104657],"thread-104486":["thread",104486],"thread-104200":["thread",104200],"thread-103096":["thread",103096],"thread-103081":["thread",103081],"thread-102941":["thread",102941],"thread-101716":["thread",101716],"thread-101702":["thread",101702],"thread-101517":["thread",101517],"thread-101356":["thread",101356],"thread-101181":["thread",101181],"thread-101180":["thread",101180],"thread-100694":["thread",100694],"thread-100332":["thread",100332],"thread-99978":["thread",99978],"thread-99942":["thread",99942],"thread-99802":["thread",99802],"thread-99704":["thread",99704],"thread-99401":["thread",99401],"thread-99390":["thread",99390],"thread-98801":["thread",98801],"thread-98670":["thread",98670],"thread-98544":["thread",98544],"thread-98396":["thread",98396],"thread-98356":["thread",98356],"thread-98351":["thread",98351],"thread-98327":["thread",98327],"thread-98047":["thread",98047],"thread-97784":["thread",97784],"thread-97682":["thread",97682],"thread-97538":["thread",97538],"thread-97199":["thread",97199],"thread-96599":["thread",96599],"thread-96301":["thread",96301],"thread-96241":["thread",96241],"thread-96177":["thread",96177],"thread-95988":["thread",95988],"thread-95582":["thread",95582],"thread-95578":["thread",95578],"thread-95564":["thread",95564],"thread-95529":["thread",95529],"thread-95399":["thread",95399],"thread-94788":["thread",94788],"thread-94702":["thread",94702],"thread-94640":["thread",94640],"thread-94599":["thread",94599],"thread-94328":["thread",94328],"thread-94292":["thread",94292],"thread-94030":["thread",94030],"thread-93992":["thread",93992],"thread-93870":["thread",93870],"thread-93813":["thread",93813],"thread-92686":["thread",92686],"thread-92600":["thread",92600],"thread-92267":["thread",92267],"thread-92128":["thread",92128],"thread-91762":["thread",91762],"thread-91725":["thread",91725],"thread-91606":["thread",91606],"thread-91579":["thread",91579],"thread-91297":["thread",91297],"thread-91250":["thread",91250],"thread-91200":["thread",91200],"thread-91189":["thread",91189],"thread-91084":["thread",91084],"thread-91057":["thread",91057],"thread-90986":["thread",90986],"thread-90703":["thread",90703],"thread-90661":["thread",90661],"thread-90564":["thread",90564],"thread-90454":["thread",90454],"thread-90365":["thread",90365],"thread-90313":["thread",90313],"thread-90174":["thread",90174],"thread-90154":["thread",90154],"thread-89912":["thread",89912],"thread-89876":["thread",89876],"thread-89440":["thread",89440],"thread-89241":["thread",89241],"thread-89151":["thread",89151],"thread-89126":["thread",89126],"thread-89075":["thread",89075],"thread-88299":["thread",88299],"thread-87967":["thread",87967],"thread-87743":["thread",87743],"thread-87711":["thread",87711],"thread-87514":["thread",87514],"thread-87415":["thread",87415],"thread-87338":["thread",87338],"thread-87255":["thread",87255],"thread-87242":["thread",87242],"thread-87233":["thread",87233],"thread-87165":["thread",87165],"thread-87139":["thread",87139],"thread-86930":["thread",86930],"thread-86818":["thread",86818],"thread-86757":["thread",86757],"thread-86183":["thread",86183],"thread-86099":["thread",86099],"thread-85938":["thread",85938],"thread-85806":["thread",85806],"thread-85559":["thread",85559],"thread-85238":["thread",85238],"thread-85054":["thread",85054],"thread-84760":["thread",84760],"thread-83900":["thread",83900],"thread-83100":["thread",83100],"thread-82678":["thread",82678],"thread-82549":["thread",82549],"thread-82204":["thread",82204],"thread-82088":["thread",82088],"thread-82012":["thread",82012],"thread-81899":["thread",81899],"thread-81543":["thread",81543],"thread-81531":["thread",81531],"thread-80933":["thread",80933],"thread-80310":["thread",80310],"thread-80260":["thread",80260],"thread-80249":["thread",80249],"thread-79962":["thread",79962],"thread-79594":["thread",79594],"thread-79447":["thread",79447],"thread-79075":["thread",79075],"thread-78537":["thread",78537],"thread-78143":["thread",78143],"thread-76917":["thread",76917],"thread-76567":["thread",76567],"thread-76486":["thread",76486],"thread-76460":["thread",76460],"thread-76030":["thread",76030],"thread-76028":["thread",76028],"thread-75990":["thread",75990],"thread-75682":["thread",75682],"thread-75639":["thread",75639],"thread-75293":["thread",75293],"thread-75266":["thread",75266],"thread-74828":["thread",74828],"thread-74717":["thread",74717],"thread-74697":["thread",74697],"thread-74689":["thread",74689],"thread-74047":["thread",74047],"thread-73700":["thread",73700],"thread-73291":["thread",73291],"thread-72793":["thread",72793],"thread-72383":["thread",72383],"thread-72014":["thread",72014],"thread-71582":["thread",71582],"thread-71219":["thread",71219],"thread-71131":["thread",71131],"thread-71128":["thread",71128],"thread-70999":["thread",70999],"thread-70828":["thread",70828],"thread-70715":["thread",70715],"thread-69847":["thread",69847],"thread-69745":["thread",69745],"thread-69452":["thread",69452],"thread-69198":["thread",69198],"thread-69105":["thread",69105],"thread-69043":["thread",69043],"thread-68872":["thread",68872],"thread-68808":["thread",68808],"thread-68434":["thread",68434],"thread-67542":["thread",67542],"thread-67495":["thread",67495],"thread-66852":["thread",66852],"thread-66780":["thread",66780],"thread-66463":["thread",66463],"thread-66017":["thread",66017],"thread-65793":["thread",65793]}, NULL, 1715774859
Run Time: 0.000332
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- 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 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20