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 (24332, 24327, 24269, 24152, 24151, 24112, 24086, 24062, 24053, 24019, 24010, 23981, 23942, 23934, 23921, 23909, 23907, 23899, 23873, 23859, 23835, 23803, 23733, 23707, 23678, 23618, 23578, 23211, 23196, 23150, 23135, 23091, 23090, 23065, 23026, 23013, 22908, 22885, 22875, 22871, 22836, 22793, 22789, 22782, 22751, 22728, 22723, 22715, 22706, 22618, 22512, 22492, 22434, 22410, 22346, 22322, 22321, 22320, 22250, 22219, 22203, 22190, 22179, 22009, 21976, 21937, 21916, 21892, 21791, 21508, 21455, 21402, 21393, 21354, 21350, 21349, 21337, 21242, 21168, 21167, 21122, 21045, 21044, 21013, 20950, 20842, 20824, 20820, 20804, 20722, 20666, 20651, 20645, 20633, 20630, 20611, 20574, 20549, 20442, 20434, 20421, 20397, 20389, 20352, 20308, 20300, 20274, 20243, 20241, 20216, 20100, 20080, 20035, 19989, 19956, 19940, 19893, 19868, 19821, 19818, 19800, 19715, 19677, 19655, 19616, 19541, 19305, 19262, 19245, 19187, 19157, 19121, 19076, 19073, 19071, 18998, 18824, 18794, 18628, 18623, 18622, 18564, 18520, 18500, 18474, 18465, 18285, 18270, 18221, 18215, 18114, 17894, 17861, 17855, 17801, 17793, 17774, 17696, 17670, 17668, 17620, 17618, 17617, 17616, 17578, 17576, 17554, 17552, 17533, 17516, 17489, 17477, 17402, 17399, 17108, 17021, 17020, 17019, 17018, 17017, 17016, 17015, 17014, 17013, 16965, 16964, 16887, 16886, 16885, 16884, 16825, 16786, 16785))
Run Time: 0.029550
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 193 | 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: 32, 0, 1714238531, {"thread-24332":["thread",24332],"thread-24327":["thread",24327],"thread-24269":["thread",24269],"thread-24152":["thread",24152],"thread-24151":["thread",24151],"thread-24112":["thread",24112],"thread-24086":["thread",24086],"thread-24062":["thread",24062],"thread-24053":["thread",24053],"thread-24019":["thread",24019],"thread-24010":["thread",24010],"thread-23981":["thread",23981],"thread-23942":["thread",23942],"thread-23934":["thread",23934],"thread-23921":["thread",23921],"thread-23909":["thread",23909],"thread-23907":["thread",23907],"thread-23899":["thread",23899],"thread-23873":["thread",23873],"thread-23859":["thread",23859],"thread-23835":["thread",23835],"thread-23803":["thread",23803],"thread-23733":["thread",23733],"thread-23707":["thread",23707],"thread-23678":["thread",23678],"thread-23618":["thread",23618],"thread-23578":["thread",23578],"thread-23211":["thread",23211],"thread-23196":["thread",23196],"thread-23150":["thread",23150],"thread-23135":["thread",23135],"thread-23091":["thread",23091],"thread-23090":["thread",23090],"thread-23065":["thread",23065],"thread-23026":["thread",23026],"thread-23013":["thread",23013],"thread-22908":["thread",22908],"thread-22885":["thread",22885],"thread-22875":["thread",22875],"thread-22871":["thread",22871],"thread-22836":["thread",22836],"thread-22793":["thread",22793],"thread-22789":["thread",22789],"thread-22782":["thread",22782],"thread-22751":["thread",22751],"thread-22728":["thread",22728],"thread-22723":["thread",22723],"thread-22715":["thread",22715],"thread-22706":["thread",22706],"thread-22618":["thread",22618],"thread-22512":["thread",22512],"thread-22492":["thread",22492],"thread-22434":["thread",22434],"thread-22410":["thread",22410],"thread-22346":["thread",22346],"thread-22322":["thread",22322],"thread-22321":["thread",22321],"thread-22320":["thread",22320],"thread-22250":["thread",22250],"thread-22219":["thread",22219],"thread-22203":["thread",22203],"thread-22190":["thread",22190],"thread-22179":["thread",22179],"thread-22009":["thread",22009],"thread-21976":["thread",21976],"thread-21937":["thread",21937],"thread-21916":["thread",21916],"thread-21892":["thread",21892],"thread-21791":["thread",21791],"thread-21508":["thread",21508],"thread-21455":["thread",21455],"thread-21402":["thread",21402],"thread-21393":["thread",21393],"thread-21354":["thread",21354],"thread-21350":["thread",21350],"thread-21349":["thread",21349],"thread-21337":["thread",21337],"thread-21242":["thread",21242],"thread-21168":["thread",21168],"thread-21167":["thread",21167],"thread-21122":["thread",21122],"thread-21045":["thread",21045],"thread-21044":["thread",21044],"thread-21013":["thread",21013],"thread-20950":["thread",20950],"thread-20842":["thread",20842],"thread-20824":["thread",20824],"thread-20820":["thread",20820],"thread-20804":["thread",20804],"thread-20722":["thread",20722],"thread-20666":["thread",20666],"thread-20651":["thread",20651],"thread-20645":["thread",20645],"thread-20633":["thread",20633],"thread-20630":["thread",20630],"thread-20611":["thread",20611],"thread-20574":["thread",20574],"thread-20549":["thread",20549],"thread-20442":["thread",20442],"thread-20434":["thread",20434],"thread-20421":["thread",20421],"thread-20397":["thread",20397],"thread-20389":["thread",20389],"thread-20352":["thread",20352],"thread-20308":["thread",20308],"thread-20300":["thread",20300],"thread-20274":["thread",20274],"thread-20243":["thread",20243],"thread-20241":["thread",20241],"thread-20216":["thread",20216],"thread-20100":["thread",20100],"thread-20080":["thread",20080],"thread-20035":["thread",20035],"thread-19989":["thread",19989],"thread-19956":["thread",19956],"thread-19940":["thread",19940],"thread-19893":["thread",19893],"thread-19868":["thread",19868],"thread-19821":["thread",19821],"thread-19818":["thread",19818],"thread-19800":["thread",19800],"thread-19715":["thread",19715],"thread-19677":["thread",19677],"thread-19655":["thread",19655],"thread-19616":["thread",19616],"thread-19541":["thread",19541],"thread-19305":["thread",19305],"thread-19262":["thread",19262],"thread-19245":["thread",19245],"thread-19187":["thread",19187],"thread-19157":["thread",19157],"thread-19121":["thread",19121],"thread-19076":["thread",19076],"thread-19073":["thread",19073],"thread-19071":["thread",19071],"thread-18998":["thread",18998],"thread-18824":["thread",18824],"thread-18794":["thread",18794],"thread-18628":["thread",18628],"thread-18623":["thread",18623],"thread-18622":["thread",18622],"thread-18564":["thread",18564],"thread-18520":["thread",18520],"thread-18500":["thread",18500],"thread-18474":["thread",18474],"thread-18465":["thread",18465],"thread-18285":["thread",18285],"thread-18270":["thread",18270],"thread-18221":["thread",18221],"thread-18215":["thread",18215],"thread-18114":["thread",18114],"thread-17894":["thread",17894],"thread-17861":["thread",17861],"thread-17855":["thread",17855],"thread-17801":["thread",17801],"thread-17793":["thread",17793],"thread-17774":["thread",17774],"thread-17696":["thread",17696],"thread-17670":["thread",17670],"thread-17668":["thread",17668],"thread-17620":["thread",17620],"thread-17618":["thread",17618],"thread-17617":["thread",17617],"thread-17616":["thread",17616],"thread-17578":["thread",17578],"thread-17576":["thread",17576],"thread-17554":["thread",17554],"thread-17552":["thread",17552],"thread-17533":["thread",17533],"thread-17516":["thread",17516],"thread-17489":["thread",17489],"thread-17477":["thread",17477],"thread-17402":["thread",17402],"thread-17399":["thread",17399],"thread-17108":["thread",17108],"thread-17021":["thread",17021],"thread-17020":["thread",17020],"thread-17019":["thread",17019],"thread-17018":["thread",17018],"thread-17017":["thread",17017],"thread-17016":["thread",17016],"thread-17015":["thread",17015],"thread-17014":["thread",17014],"thread-17013":["thread",17013],"thread-16965":["thread",16965],"thread-16964":["thread",16964],"thread-16887":["thread",16887],"thread-16886":["thread",16886],"thread-16885":["thread",16885],"thread-16884":["thread",16884],"thread-16825":["thread",16825],"thread-16786":["thread",16786],"thread-16785":["thread",16785]}, NULL, 1714234931
Run Time: 0.000851
- 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