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 (183396, 183052, 181970, 181666, 181552, 181446, 181293, 181234, 180968, 180866, 180628, 180351, 180332, 179942, 179860, 179747, 179430, 179237, 179035, 179033, 178992, 178968, 178806, 178571, 178547, 178461, 177906, 177761, 177432, 177335, 177118, 177058, 176663, 176629, 176358, 176357, 176082, 176003, 175786, 175597, 175369, 174415, 174213, 173944, 173881, 173876, 173666, 173469, 173399, 173390, 173159, 173127, 173049, 172949, 172642, 172327, 172294, 172228, 172186, 172170, 171996, 171840, 171765, 171537, 171431, 171228, 171096, 170981, 170960, 170820, 170801, 170743, 170420, 169916, 169594, 169416, 169173, 168994, 168960, 168837, 168692, 168570, 168557, 168109, 167979, 167546, 167246, 166947, 166861, 166743, 166672, 166546, 166325, 166294, 166273, 165970, 165514, 164890, 164563, 163970, 163562, 163465, 163421, 163318, 162735, 162727, 162370, 161909, 161195, 161047, 160859, 160467, 160466, 160295, 160257, 160231, 160057, 160047, 159835, 159740, 159648, 159605, 159559, 159418, 159373, 159196, 159031, 158997, 158916, 158690, 158615, 158585, 158367, 158020, 157991, 157921, 157879, 157857, 157743, 157621, 157173, 157090, 156896, 156475, 156220, 156101, 156085, 156037, 155987, 155937, 155891, 155824, 155800, 155687, 155380, 155357, 155311, 155153, 154968, 154378, 154291, 154289, 154263, 153879, 153833, 153756, 153715))
Run Time: 0.120118
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 167 | 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: 2294, 0, 1716202502, {"thread-183396":["thread",183396],"thread-183052":["thread",183052],"thread-181970":["thread",181970],"thread-181666":["thread",181666],"thread-181552":["thread",181552],"thread-181446":["thread",181446],"thread-181293":["thread",181293],"thread-181234":["thread",181234],"thread-180968":["thread",180968],"thread-180866":["thread",180866],"thread-180628":["thread",180628],"thread-180351":["thread",180351],"thread-180332":["thread",180332],"thread-179942":["thread",179942],"thread-179860":["thread",179860],"thread-179747":["thread",179747],"thread-179430":["thread",179430],"thread-179237":["thread",179237],"thread-179035":["thread",179035],"thread-179033":["thread",179033],"thread-178992":["thread",178992],"thread-178968":["thread",178968],"thread-178806":["thread",178806],"thread-178571":["thread",178571],"thread-178547":["thread",178547],"thread-178461":["thread",178461],"thread-177906":["thread",177906],"thread-177761":["thread",177761],"thread-177432":["thread",177432],"thread-177335":["thread",177335],"thread-177118":["thread",177118],"thread-177058":["thread",177058],"thread-176663":["thread",176663],"thread-176629":["thread",176629],"thread-176358":["thread",176358],"thread-176357":["thread",176357],"thread-176082":["thread",176082],"thread-176003":["thread",176003],"thread-175786":["thread",175786],"thread-175597":["thread",175597],"thread-175369":["thread",175369],"thread-174415":["thread",174415],"thread-174213":["thread",174213],"thread-173944":["thread",173944],"thread-173881":["thread",173881],"thread-173876":["thread",173876],"thread-173666":["thread",173666],"thread-173469":["thread",173469],"thread-173399":["thread",173399],"thread-173390":["thread",173390],"thread-173159":["thread",173159],"thread-173127":["thread",173127],"thread-173049":["thread",173049],"thread-172949":["thread",172949],"thread-172642":["thread",172642],"thread-172327":["thread",172327],"thread-172294":["thread",172294],"ams_article-4901":["ams_article",4901],"thread-172228":["thread",172228],"thread-172186":["thread",172186],"thread-172170":["thread",172170],"ams_article-4893":["ams_article",4893],"thread-171996":["thread",171996],"thread-171840":["thread",171840],"thread-171765":["thread",171765],"ams_article-4873":["ams_article",4873],"thread-171537":["thread",171537],"thread-171431":["thread",171431],"thread-171228":["thread",171228],"thread-171096":["thread",171096],"thread-170981":["thread",170981],"thread-170960":["thread",170960],"thread-170820":["thread",170820],"thread-170801":["thread",170801],"thread-170743":["thread",170743],"ams_article-4830":["ams_article",4830],"thread-170420":["thread",170420],"thread-169916":["thread",169916],"thread-169594":["thread",169594],"thread-169416":["thread",169416],"thread-169173":["thread",169173],"thread-168994":["thread",168994],"thread-168960":["thread",168960],"ams_article-4790":["ams_article",4790],"thread-168837":["thread",168837],"ams_article-4783":["ams_article",4783],"thread-168692":["thread",168692],"thread-168570":["thread",168570],"thread-168557":["thread",168557],"thread-168109":["thread",168109],"thread-167979":["thread",167979],"ams_article-4755":["ams_article",4755],"ams_article-4753":["ams_article",4753],"thread-167546":["thread",167546],"ams_article-4739":["ams_article",4739],"thread-167246":["thread",167246],"ams_article-4737":["ams_article",4737],"ams_article-4734":["ams_article",4734],"thread-166947":["thread",166947],"thread-166861":["thread",166861],"thread-166743":["thread",166743],"thread-166672":["thread",166672],"thread-166546":["thread",166546],"thread-166325":["thread",166325],"thread-166294":["thread",166294],"thread-166273":["thread",166273],"thread-165970":["thread",165970],"thread-165514":["thread",165514],"thread-164890":["thread",164890],"ams_article-4641":["ams_article",4641],"thread-164563":["thread",164563],"ams_article-4569":["ams_article",4569],"thread-163970":["thread",163970],"thread-163562":["thread",163562],"thread-163465":["thread",163465],"thread-163421":["thread",163421],"ams_article-4529":["ams_article",4529],"ams_article-4526":["ams_article",4526],"thread-163318":["thread",163318],"ams_article-4521":["ams_article",4521],"ams_article-4505":["ams_article",4505],"ams_article-4502":["ams_article",4502],"thread-162735":["thread",162735],"thread-162727":["thread",162727],"thread-162370":["thread",162370],"ams_article-4484":["ams_article",4484],"ams_article-4483":["ams_article",4483],"thread-161909":["thread",161909],"ams_article-4466":["ams_article",4466],"thread-161195":["thread",161195],"ams_article-4445":["ams_article",4445],"ams_article-4444":["ams_article",4444],"thread-161047":["thread",161047],"thread-160859":["thread",160859],"thread-160467":["thread",160467],"thread-160466":["thread",160466],"ams_article-4423":["ams_article",4423],"thread-160295":["thread",160295],"thread-160257":["thread",160257],"thread-160231":["thread",160231],"thread-160057":["thread",160057],"thread-160047":["thread",160047],"thread-159835":["thread",159835],"thread-159740":["thread",159740],"thread-159648":["thread",159648],"ams_article-4389":["ams_article",4389],"thread-159605":["thread",159605],"thread-159559":["thread",159559],"thread-159418":["thread",159418],"thread-159373":["thread",159373],"thread-159196":["thread",159196],"ams_article-4360":["ams_article",4360],"thread-159031":["thread",159031],"thread-158997":["thread",158997],"thread-158916":["thread",158916],"ams_article-4355":["ams_article",4355],"thread-158690":["thread",158690],"thread-158615":["thread",158615],"thread-158585":["thread",158585],"thread-158367":["thread",158367],"ams_article-4331":["ams_article",4331],"thread-158020":["thread",158020],"thread-157991":["thread",157991],"thread-157921":["thread",157921],"thread-157879":["thread",157879],"thread-157857":["thread",157857],"thread-157743":["thread",157743],"ams_article-4298":["ams_article",4298],"thread-157621":["thread",157621],"thread-157173":["thread",157173],"thread-157090":["thread",157090],"thread-156896":["thread",156896],"thread-156475":["thread",156475],"thread-156220":["thread",156220],"thread-156101":["thread",156101],"thread-156085":["thread",156085],"thread-156037":["thread",156037],"ams_article-4217":["ams_article",4217],"thread-155987":["thread",155987],"ams_article-4213":["ams_article",4213],"thread-155937":["thread",155937],"ams_article-4206":["ams_article",4206],"thread-155891":["thread",155891],"thread-155824":["thread",155824],"thread-155800":["thread",155800],"thread-155687":["thread",155687],"thread-155380":["thread",155380],"thread-155357":["thread",155357],"thread-155311":["thread",155311],"thread-155153":["thread",155153],"thread-154968":["thread",154968],"thread-154378":["thread",154378],"thread-154291":["thread",154291],"thread-154289":["thread",154289],"thread-154263":["thread",154263],"thread-153879":["thread",153879],"thread-153833":["thread",153833],"thread-153756":["thread",153756],"thread-153715":["thread",153715]}, , 1716198902
Run Time: 0.000388
- 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