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 (24268, 24185, 24024, 24016, 24006, 24005, 23961, 23908, 23816, 23707, 23692, 23678, 23640, 23638, 23628, 23568, 23465, 23464, 23446, 23445, 23412, 23229, 23172, 23152, 23070, 23068, 23027, 23008, 23005, 23004, 22908, 22875, 22838, 22805, 22797, 22783, 22761, 22759, 22756, 22751, 22747, 22740, 22739, 22727, 22721, 22714, 22704, 22694, 22686, 22675, 22663, 22644, 22639, 22617, 22606, 22579, 22546, 22523, 22498, 22434, 22426, 22423, 22354, 22352, 22297, 22239, 22222, 22203, 22184, 22179, 22158, 22136, 22110, 22097, 22032, 22013, 21996, 21900, 21858, 21847, 21809, 21802, 21766, 21753, 21719, 21706, 21693, 21671, 21637, 21636, 21595, 21594, 21586, 21541, 21533, 21532, 21531, 21530, 21485, 21429, 21412, 21393, 21362, 21323, 21309, 21291, 21252, 21249, 21218, 21183, 21167, 21145, 21105, 21094, 21067, 21038, 21035, 20945, 20922, 20905, 20899, 20854, 20848, 20818, 20778, 20651, 20597, 20376, 20364, 20357, 20352, 20291, 20078, 20077, 20076, 20047, 19940, 19907, 19778, 19743, 19715, 19677, 19667, 19557, 19365, 19354, 19245, 19230, 19187, 19177, 19037, 19033, 18926, 18754, 18751, 18705, 18658, 18628, 18623, 18615, 18594, 18500, 18411, 18218, 18214, 18139, 18038, 17991, 17734, 17668, 17620, 17554, 17552, 17511, 17326, 17270, 17116, 17074, 17027, 17022, 17001, 16960, 16936, 16825, 16789, 16781, 16673))
Run Time: 0.024608
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 187 | 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: 11, 0, 1716133566, {"thread-24268":["thread",24268],"thread-24185":["thread",24185],"thread-24024":["thread",24024],"thread-24016":["thread",24016],"thread-24006":["thread",24006],"thread-24005":["thread",24005],"thread-23961":["thread",23961],"thread-23908":["thread",23908],"thread-23816":["thread",23816],"thread-23707":["thread",23707],"thread-23692":["thread",23692],"thread-23678":["thread",23678],"thread-23640":["thread",23640],"thread-23638":["thread",23638],"thread-23628":["thread",23628],"thread-23568":["thread",23568],"thread-23465":["thread",23465],"thread-23464":["thread",23464],"thread-23446":["thread",23446],"thread-23445":["thread",23445],"thread-23412":["thread",23412],"thread-23229":["thread",23229],"thread-23172":["thread",23172],"thread-23152":["thread",23152],"thread-23070":["thread",23070],"thread-23068":["thread",23068],"thread-23027":["thread",23027],"thread-23008":["thread",23008],"thread-23005":["thread",23005],"thread-23004":["thread",23004],"thread-22908":["thread",22908],"thread-22875":["thread",22875],"thread-22838":["thread",22838],"thread-22805":["thread",22805],"thread-22797":["thread",22797],"thread-22783":["thread",22783],"thread-22761":["thread",22761],"thread-22759":["thread",22759],"thread-22756":["thread",22756],"thread-22751":["thread",22751],"thread-22747":["thread",22747],"thread-22740":["thread",22740],"thread-22739":["thread",22739],"thread-22727":["thread",22727],"thread-22721":["thread",22721],"thread-22714":["thread",22714],"thread-22704":["thread",22704],"thread-22694":["thread",22694],"thread-22686":["thread",22686],"thread-22675":["thread",22675],"thread-22663":["thread",22663],"thread-22644":["thread",22644],"thread-22639":["thread",22639],"thread-22617":["thread",22617],"thread-22606":["thread",22606],"thread-22579":["thread",22579],"thread-22546":["thread",22546],"thread-22523":["thread",22523],"thread-22498":["thread",22498],"thread-22434":["thread",22434],"thread-22426":["thread",22426],"thread-22423":["thread",22423],"thread-22354":["thread",22354],"thread-22352":["thread",22352],"thread-22297":["thread",22297],"thread-22239":["thread",22239],"thread-22222":["thread",22222],"thread-22203":["thread",22203],"thread-22184":["thread",22184],"thread-22179":["thread",22179],"thread-22158":["thread",22158],"thread-22136":["thread",22136],"thread-22110":["thread",22110],"thread-22097":["thread",22097],"thread-22032":["thread",22032],"thread-22013":["thread",22013],"thread-21996":["thread",21996],"thread-21900":["thread",21900],"thread-21858":["thread",21858],"thread-21847":["thread",21847],"thread-21809":["thread",21809],"thread-21802":["thread",21802],"thread-21766":["thread",21766],"thread-21753":["thread",21753],"thread-21719":["thread",21719],"thread-21706":["thread",21706],"thread-21693":["thread",21693],"thread-21671":["thread",21671],"thread-21637":["thread",21637],"thread-21636":["thread",21636],"thread-21595":["thread",21595],"thread-21594":["thread",21594],"thread-21586":["thread",21586],"thread-21541":["thread",21541],"thread-21533":["thread",21533],"thread-21532":["thread",21532],"thread-21531":["thread",21531],"thread-21530":["thread",21530],"thread-21485":["thread",21485],"thread-21429":["thread",21429],"thread-21412":["thread",21412],"thread-21393":["thread",21393],"thread-21362":["thread",21362],"thread-21323":["thread",21323],"thread-21309":["thread",21309],"thread-21291":["thread",21291],"thread-21252":["thread",21252],"thread-21249":["thread",21249],"thread-21218":["thread",21218],"thread-21183":["thread",21183],"thread-21167":["thread",21167],"thread-21145":["thread",21145],"thread-21105":["thread",21105],"thread-21094":["thread",21094],"thread-21067":["thread",21067],"thread-21038":["thread",21038],"thread-21035":["thread",21035],"thread-20945":["thread",20945],"thread-20922":["thread",20922],"thread-20905":["thread",20905],"thread-20899":["thread",20899],"thread-20854":["thread",20854],"thread-20848":["thread",20848],"thread-20818":["thread",20818],"thread-20778":["thread",20778],"thread-20651":["thread",20651],"thread-20597":["thread",20597],"thread-20376":["thread",20376],"thread-20364":["thread",20364],"thread-20357":["thread",20357],"thread-20352":["thread",20352],"thread-20291":["thread",20291],"thread-20078":["thread",20078],"thread-20077":["thread",20077],"thread-20076":["thread",20076],"thread-20047":["thread",20047],"thread-19940":["thread",19940],"thread-19907":["thread",19907],"thread-19778":["thread",19778],"thread-19743":["thread",19743],"thread-19715":["thread",19715],"thread-19677":["thread",19677],"thread-19667":["thread",19667],"thread-19557":["thread",19557],"thread-19365":["thread",19365],"thread-19354":["thread",19354],"thread-19245":["thread",19245],"thread-19230":["thread",19230],"thread-19187":["thread",19187],"thread-19177":["thread",19177],"thread-19037":["thread",19037],"thread-19033":["thread",19033],"thread-18926":["thread",18926],"thread-18754":["thread",18754],"thread-18751":["thread",18751],"thread-18705":["thread",18705],"thread-18658":["thread",18658],"thread-18628":["thread",18628],"thread-18623":["thread",18623],"thread-18615":["thread",18615],"thread-18594":["thread",18594],"thread-18500":["thread",18500],"thread-18411":["thread",18411],"thread-18218":["thread",18218],"thread-18214":["thread",18214],"thread-18139":["thread",18139],"thread-18038":["thread",18038],"thread-17991":["thread",17991],"thread-17734":["thread",17734],"thread-17668":["thread",17668],"thread-17620":["thread",17620],"thread-17554":["thread",17554],"thread-17552":["thread",17552],"thread-17511":["thread",17511],"thread-17326":["thread",17326],"thread-17270":["thread",17270],"thread-17116":["thread",17116],"thread-17074":["thread",17074],"thread-17027":["thread",17027],"thread-17022":["thread",17022],"thread-17001":["thread",17001],"thread-16960":["thread",16960],"thread-16936":["thread",16936],"thread-16825":["thread",16825],"thread-16789":["thread",16789],"thread-16781":["thread",16781],"thread-16673":["thread",16673]}, NULL, 1716129966
Run Time: 0.001483
- 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