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 (7206668, 7203520, 7203318, 7197209, 7192559, 7192454, 7187223, 7186376, 7183633, 7174399, 7172697, 7160131, 7149679, 7140617, 7136813, 7135354, 7125055, 7121396, 7119940, 7110648, 7110402, 7109299, 7105549, 7103521, 7102431, 7100594, 7089035, 7085072, 7084978, 7083060, 7080471, 7072167, 7066003, 7065678, 7051466, 7044577, 7036152, 7028215, 7014560, 7013949, 7011879, 7003793, 6980437, 6975630, 6965475, 6964501, 6732690, 6484137, 242095, 240014, 235266, 226030, 218218, 216613, 212201, 208562, 204427, 202182, 198487, 196725, 191067, 189888, 185026, 181747, 177846, 176666, 174883, 174391, 173123, 166527, 162218, 160974, 160947, 160335, 160299, 13803, 13795, 13683, 13679, 13632, 13610, 13552, 13466, 13356, 13040, 12986, 12970, 12735, 12602, 12557, 12546, 12460, 12458, 12407, 12389, 12343, 12331, 12279, 12193, 12150, 12145, 12045, 11975, 11966, 11949, 11676, 11576, 11556, 11452, 11432, 11418, 11367, 11366, 11315, 10980, 10863, 10847, 10820, 10453, 10341, 10326, 10234, 10106, 10099, 10081, 9899, 9722, 9644, 9466, 9460, 9388, 9335, 9331, 9034, 8956, 8879, 8815, 8807, 8746, 8652, 8399, 8357, 8305, 8187, 8125, 8079, 8004, 7929, 7921, 7818, 7791, 7572, 7501, 7455, 7420, 6976, 6901, 6878, 6872, 6819, 6772, 6611, 6462, 6460, 6364, 6064, 6009, 5822, 5720, 5629, 5252, 5217, 5120, 5064, 5032, 5018, 5013, 4991, 4928, 4848, 4760, 4742, 4700, 4654, 4642, 4563, 4561, 4555, 4547, 4459, 4417, 4409, 4307, 3930, 3807, 3796, 3795, 3782, 3768, 3644))
Run Time: 0.010474
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 2870
- 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 138
- 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 2487
- 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: 187, 0, 1714291978, {"thread-7206668":["thread",7206668],"thread-7203520":["thread",7203520],"thread-7203318":["thread",7203318],"thread-7197209":["thread",7197209],"thread-7192559":["thread",7192559],"thread-7192454":["thread",7192454],"thread-7187223":["thread",7187223],"thread-7186376":["thread",7186376],"thread-7183633":["thread",7183633],"thread-7174399":["thread",7174399],"thread-7172697":["thread",7172697],"thread-7160131":["thread",7160131],"thread-7149679":["thread",7149679],"thread-7140617":["thread",7140617],"thread-7136813":["thread",7136813],"thread-7135354":["thread",7135354],"thread-7125055":["thread",7125055],"thread-7121396":["thread",7121396],"thread-7119940":["thread",7119940],"thread-7110648":["thread",7110648],"thread-7110402":["thread",7110402],"thread-7109299":["thread",7109299],"thread-7105549":["thread",7105549],"thread-7103521":["thread",7103521],"thread-7102431":["thread",7102431],"thread-7100594":["thread",7100594],"thread-7089035":["thread",7089035],"thread-7085072":["thread",7085072],"thread-7084978":["thread",7084978],"thread-7083060":["thread",7083060],"thread-7080471":["thread",7080471],"thread-7072167":["thread",7072167],"thread-7066003":["thread",7066003],"thread-7065678":["thread",7065678],"thread-7051466":["thread",7051466],"thread-7044577":["thread",7044577],"thread-7036152":["thread",7036152],"thread-7028215":["thread",7028215],"thread-7014560":["thread",7014560],"thread-7013949":["thread",7013949],"thread-7011879":["thread",7011879],"thread-7003793":["thread",7003793],"thread-6980437":["thread",6980437],"thread-6975630":["thread",6975630],"thread-6965475":["thread",6965475],"thread-6964501":["thread",6964501],"thread-6732690":["thread",6732690],"thread-6484137":["thread",6484137],"thread-242095":["thread",242095],"thread-240014":["thread",240014],"thread-235266":["thread",235266],"thread-226030":["thread",226030],"thread-218218":["thread",218218],"thread-216613":["thread",216613],"thread-212201":["thread",212201],"thread-208562":["thread",208562],"thread-204427":["thread",204427],"thread-202182":["thread",202182],"thread-198487":["thread",198487],"thread-196725":["thread",196725],"thread-191067":["thread",191067],"thread-189888":["thread",189888],"thread-185026":["thread",185026],"thread-181747":["thread",181747],"thread-177846":["thread",177846],"thread-176666":["thread",176666],"thread-174883":["thread",174883],"thread-174391":["thread",174391],"thread-173123":["thread",173123],"thread-166527":["thread",166527],"thread-162218":["thread",162218],"thread-160974":["thread",160974],"thread-160947":["thread",160947],"thread-160335":["thread",160335],"thread-160299":["thread",160299],"thread-13803":["thread",13803],"thread-13795":["thread",13795],"thread-13683":["thread",13683],"thread-13679":["thread",13679],"thread-13632":["thread",13632],"thread-13610":["thread",13610],"thread-13552":["thread",13552],"thread-13466":["thread",13466],"thread-13356":["thread",13356],"thread-13040":["thread",13040],"thread-12986":["thread",12986],"thread-12970":["thread",12970],"thread-12735":["thread",12735],"thread-12602":["thread",12602],"thread-12557":["thread",12557],"thread-12546":["thread",12546],"thread-12460":["thread",12460],"thread-12458":["thread",12458],"thread-12407":["thread",12407],"thread-12389":["thread",12389],"thread-12343":["thread",12343],"thread-12331":["thread",12331],"thread-12279":["thread",12279],"thread-12193":["thread",12193],"thread-12150":["thread",12150],"thread-12145":["thread",12145],"thread-12045":["thread",12045],"thread-11975":["thread",11975],"thread-11966":["thread",11966],"thread-11949":["thread",11949],"thread-11676":["thread",11676],"thread-11576":["thread",11576],"thread-11556":["thread",11556],"thread-11452":["thread",11452],"thread-11432":["thread",11432],"thread-11418":["thread",11418],"thread-11367":["thread",11367],"thread-11366":["thread",11366],"thread-11315":["thread",11315],"thread-10980":["thread",10980],"thread-10863":["thread",10863],"thread-10847":["thread",10847],"thread-10820":["thread",10820],"thread-10453":["thread",10453],"thread-10341":["thread",10341],"thread-10326":["thread",10326],"thread-10234":["thread",10234],"thread-10106":["thread",10106],"thread-10099":["thread",10099],"thread-10081":["thread",10081],"thread-9899":["thread",9899],"thread-9722":["thread",9722],"thread-9644":["thread",9644],"thread-9466":["thread",9466],"thread-9460":["thread",9460],"thread-9388":["thread",9388],"thread-9335":["thread",9335],"thread-9331":["thread",9331],"thread-9034":["thread",9034],"thread-8956":["thread",8956],"thread-8879":["thread",8879],"thread-8815":["thread",8815],"thread-8807":["thread",8807],"thread-8746":["thread",8746],"thread-8652":["thread",8652],"thread-8399":["thread",8399],"thread-8357":["thread",8357],"thread-8305":["thread",8305],"thread-8187":["thread",8187],"thread-8125":["thread",8125],"thread-8079":["thread",8079],"thread-8004":["thread",8004],"thread-7929":["thread",7929],"thread-7921":["thread",7921],"thread-7818":["thread",7818],"thread-7791":["thread",7791],"thread-7572":["thread",7572],"thread-7501":["thread",7501],"thread-7455":["thread",7455],"thread-7420":["thread",7420],"thread-6976":["thread",6976],"thread-6901":["thread",6901],"thread-6878":["thread",6878],"thread-6872":["thread",6872],"thread-6819":["thread",6819],"thread-6772":["thread",6772],"thread-6611":["thread",6611],"thread-6462":["thread",6462],"thread-6460":["thread",6460],"thread-6364":["thread",6364],"thread-6064":["thread",6064],"thread-6009":["thread",6009],"thread-5822":["thread",5822],"thread-5720":["thread",5720],"thread-5629":["thread",5629],"thread-5252":["thread",5252],"thread-5217":["thread",5217],"thread-5120":["thread",5120],"thread-5064":["thread",5064],"thread-5032":["thread",5032],"thread-5018":["thread",5018],"thread-5013":["thread",5013],"thread-4991":["thread",4991],"thread-4928":["thread",4928],"thread-4848":["thread",4848],"thread-4760":["thread",4760],"thread-4742":["thread",4742],"thread-4700":["thread",4700],"thread-4654":["thread",4654],"thread-4642":["thread",4642],"thread-4563":["thread",4563],"thread-4561":["thread",4561],"thread-4555":["thread",4555],"thread-4547":["thread",4547],"thread-4459":["thread",4459],"thread-4417":["thread",4417],"thread-4409":["thread",4409],"thread-4307":["thread",4307],"thread-3930":["thread",3930],"thread-3807":["thread",3807],"thread-3796":["thread",3796],"thread-3795":["thread",3795],"thread-3782":["thread",3782],"thread-3768":["thread",3768],"thread-3644":["thread",3644]}, NULL, 1714288378
Run Time: 0.000487
- 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 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20