SELECT `xf_thread`.*, `xf_seo_package_metadata_SEOPackageMetadata_1`.*, `xf_forum_Forum_2`.*, `xf_node_Node_3`.*, `xf_user_User_4`.*, `xf_post_FirstPost_5`.*, `xf_permission_cache_content_Permissions_6`.*
FROM `xf_thread`
LEFT JOIN `xf_seo_package_metadata` AS `xf_seo_package_metadata_SEOPackageMetadata_1` ON (`xf_seo_package_metadata_SEOPackageMetadata_1`.`content_type` = 'thread' AND `xf_seo_package_metadata_SEOPackageMetadata_1`.`content_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_forum` AS `xf_forum_Forum_2` ON (`xf_forum_Forum_2`.`node_id` = `xf_thread`.`node_id`)
LEFT JOIN `xf_node` AS `xf_node_Node_3` ON (`xf_node_Node_3`.`node_id` = `xf_forum_Forum_2`.`node_id`)
LEFT JOIN `xf_user` AS `xf_user_User_4` ON (`xf_user_User_4`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_post` AS `xf_post_FirstPost_5` ON (`xf_post_FirstPost_5`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_6` ON (`xf_permission_cache_content_Permissions_6`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_6`.`content_id` = `xf_node_Node_3`.`node_id` AND `xf_permission_cache_content_Permissions_6`.`permission_combination_id` = '1')
WHERE (`xf_thread`.`thread_id` IN (24463, 24332, 24234, 24194, 24193, 24112, 24053, 24041, 24006, 24005, 23986, 23983, 23981, 23979, 23914, 23909, 23907, 23866, 23757, 23752, 23716, 23707, 23692, 23678, 23640, 23638, 23633, 23603, 23578, 23446, 23383, 23268, 23231, 23229, 23191, 23152, 23150, 23114, 23113, 23091, 23065, 23026, 23004, 22929, 22908, 22899, 22897, 22885, 22875, 22871, 22838, 22817, 22761, 22751, 22729, 22723, 22716, 22706, 22704, 22675, 22644, 22643, 22618, 22576, 22572, 22546, 22523, 22434, 22423, 22410, 22370, 22354, 22352, 22333, 22322, 22320, 22296, 22219, 22193, 22110, 22097, 21996, 21937, 21847, 21838, 21826, 21825, 21752, 21724, 21508, 21267, 21241, 21203, 21199, 21168, 21167, 21130, 21058, 21057, 21014, 20945, 20926, 20918, 20891, 20874, 20832, 20805, 20651, 20630, 20617, 20611, 20577, 20574, 20549, 20448, 20432, 20421, 20413, 20281, 20241, 20113, 20100, 20084, 20078, 20047, 20041, 20035, 19990, 19948, 19940, 19868, 19832, 19800, 19778, 19777, 19624, 19508, 19416, 19354, 19350, 19230, 19228, 19188, 19187, 19121, 19059, 19036, 18926, 18922, 18884, 18883, 18867, 18842, 18792, 18780, 18751, 18657, 18628, 18582, 18535, 18520, 18519, 18474, 18465, 18442, 18429, 18306, 18285, 18214, 18122, 18114, 18083, 18000, 17924, 17894, 17861, 17801, 17793, 17774, 17734, 17668, 17620, 17618, 17594, 17554, 17552, 17516, 17515, 17511, 17489, 17477, 17384, 17287, 17270, 17202, 17153, 17109, 17078, 17073, 17055))
Run Time: 0.027469
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_seo_package_metadata_SEOPackageMetadata_1 | eq_ref | PRIMARY | PRIMARY | 156 | const,u769187343_pokemon_xf_new.xf_thread.thread_id | 1 | Using where |
SIMPLE | xf_forum_Forum_2 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_3 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_forum_Forum_2.node_id | 1 | Using where |
SIMPLE | xf_user_User_4 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_5 | eq_ref | PRIMARY | PRIMARY | 4 | u769187343_pokemon_xf_new.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_6 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,u769187343_pokemon_xf_new.xf_node_Node_3.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: 3, 0, 1714841895, {"thread-24463":["thread",24463],"thread-24332":["thread",24332],"thread-24234":["thread",24234],"thread-24194":["thread",24194],"thread-24193":["thread",24193],"thread-24112":["thread",24112],"thread-24053":["thread",24053],"thread-24041":["thread",24041],"thread-24006":["thread",24006],"thread-24005":["thread",24005],"thread-23986":["thread",23986],"thread-23983":["thread",23983],"thread-23981":["thread",23981],"thread-23979":["thread",23979],"thread-23914":["thread",23914],"thread-23909":["thread",23909],"thread-23907":["thread",23907],"thread-23866":["thread",23866],"thread-23757":["thread",23757],"thread-23752":["thread",23752],"thread-23716":["thread",23716],"thread-23707":["thread",23707],"thread-23692":["thread",23692],"thread-23678":["thread",23678],"thread-23640":["thread",23640],"thread-23638":["thread",23638],"thread-23633":["thread",23633],"thread-23603":["thread",23603],"thread-23578":["thread",23578],"thread-23446":["thread",23446],"thread-23383":["thread",23383],"thread-23268":["thread",23268],"thread-23231":["thread",23231],"thread-23229":["thread",23229],"thread-23191":["thread",23191],"thread-23152":["thread",23152],"thread-23150":["thread",23150],"thread-23114":["thread",23114],"thread-23113":["thread",23113],"thread-23091":["thread",23091],"thread-23065":["thread",23065],"thread-23026":["thread",23026],"thread-23004":["thread",23004],"thread-22929":["thread",22929],"thread-22908":["thread",22908],"thread-22899":["thread",22899],"thread-22897":["thread",22897],"thread-22885":["thread",22885],"thread-22875":["thread",22875],"thread-22871":["thread",22871],"thread-22838":["thread",22838],"thread-22817":["thread",22817],"thread-22761":["thread",22761],"thread-22751":["thread",22751],"thread-22729":["thread",22729],"thread-22723":["thread",22723],"thread-22716":["thread",22716],"thread-22706":["thread",22706],"thread-22704":["thread",22704],"thread-22675":["thread",22675],"thread-22644":["thread",22644],"thread-22643":["thread",22643],"thread-22618":["thread",22618],"thread-22576":["thread",22576],"thread-22572":["thread",22572],"thread-22546":["thread",22546],"thread-22523":["thread",22523],"thread-22434":["thread",22434],"thread-22423":["thread",22423],"thread-22410":["thread",22410],"thread-22370":["thread",22370],"thread-22354":["thread",22354],"thread-22352":["thread",22352],"thread-22333":["thread",22333],"thread-22322":["thread",22322],"thread-22320":["thread",22320],"thread-22296":["thread",22296],"thread-22219":["thread",22219],"thread-22193":["thread",22193],"thread-22110":["thread",22110],"thread-22097":["thread",22097],"thread-21996":["thread",21996],"thread-21937":["thread",21937],"thread-21847":["thread",21847],"thread-21838":["thread",21838],"thread-21826":["thread",21826],"thread-21825":["thread",21825],"thread-21752":["thread",21752],"thread-21724":["thread",21724],"thread-21508":["thread",21508],"thread-21267":["thread",21267],"thread-21241":["thread",21241],"thread-21203":["thread",21203],"thread-21199":["thread",21199],"thread-21168":["thread",21168],"thread-21167":["thread",21167],"thread-21130":["thread",21130],"thread-21058":["thread",21058],"thread-21057":["thread",21057],"thread-21014":["thread",21014],"thread-20945":["thread",20945],"thread-20926":["thread",20926],"thread-20918":["thread",20918],"thread-20891":["thread",20891],"thread-20874":["thread",20874],"thread-20832":["thread",20832],"thread-20805":["thread",20805],"thread-20651":["thread",20651],"thread-20630":["thread",20630],"thread-20617":["thread",20617],"thread-20611":["thread",20611],"thread-20577":["thread",20577],"thread-20574":["thread",20574],"thread-20549":["thread",20549],"thread-20448":["thread",20448],"thread-20432":["thread",20432],"thread-20421":["thread",20421],"thread-20413":["thread",20413],"thread-20281":["thread",20281],"thread-20241":["thread",20241],"thread-20113":["thread",20113],"thread-20100":["thread",20100],"thread-20084":["thread",20084],"thread-20078":["thread",20078],"thread-20047":["thread",20047],"thread-20041":["thread",20041],"thread-20035":["thread",20035],"thread-19990":["thread",19990],"thread-19948":["thread",19948],"thread-19940":["thread",19940],"thread-19868":["thread",19868],"thread-19832":["thread",19832],"thread-19800":["thread",19800],"thread-19778":["thread",19778],"thread-19777":["thread",19777],"thread-19624":["thread",19624],"thread-19508":["thread",19508],"thread-19416":["thread",19416],"thread-19354":["thread",19354],"thread-19350":["thread",19350],"thread-19230":["thread",19230],"thread-19228":["thread",19228],"thread-19188":["thread",19188],"thread-19187":["thread",19187],"thread-19121":["thread",19121],"thread-19059":["thread",19059],"thread-19036":["thread",19036],"thread-18926":["thread",18926],"thread-18922":["thread",18922],"thread-18884":["thread",18884],"thread-18883":["thread",18883],"thread-18867":["thread",18867],"thread-18842":["thread",18842],"thread-18792":["thread",18792],"thread-18780":["thread",18780],"thread-18751":["thread",18751],"thread-18657":["thread",18657],"thread-18628":["thread",18628],"thread-18582":["thread",18582],"thread-18535":["thread",18535],"thread-18520":["thread",18520],"thread-18519":["thread",18519],"thread-18474":["thread",18474],"thread-18465":["thread",18465],"thread-18442":["thread",18442],"thread-18429":["thread",18429],"thread-18306":["thread",18306],"thread-18285":["thread",18285],"thread-18214":["thread",18214],"thread-18122":["thread",18122],"thread-18114":["thread",18114],"thread-18083":["thread",18083],"thread-18000":["thread",18000],"thread-17924":["thread",17924],"thread-17894":["thread",17894],"thread-17861":["thread",17861],"thread-17801":["thread",17801],"thread-17793":["thread",17793],"thread-17774":["thread",17774],"thread-17734":["thread",17734],"thread-17668":["thread",17668],"thread-17620":["thread",17620],"thread-17618":["thread",17618],"thread-17594":["thread",17594],"thread-17554":["thread",17554],"thread-17552":["thread",17552],"thread-17516":["thread",17516],"thread-17515":["thread",17515],"thread-17511":["thread",17511],"thread-17489":["thread",17489],"thread-17477":["thread",17477],"thread-17384":["thread",17384],"thread-17287":["thread",17287],"thread-17270":["thread",17270],"thread-17202":["thread",17202],"thread-17153":["thread",17153],"thread-17109":["thread",17109],"thread-17078":["thread",17078],"thread-17073":["thread",17073],"thread-17055":["thread",17055]}, NULL, 1714838295
Run Time: 0.001128
- 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