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 (43037, 42981, 42943, 42782, 42681, 42295, 41821, 41786, 41619, 41524, 39766, 39722, 39625, 39562, 39439, 39428, 38930, 38897, 38848, 38814, 38785, 38667, 38333, 38248, 38239, 37954, 37829, 37739, 37684, 37606, 37546, 37473, 37355, 37096, 36987, 36882, 36755, 36701, 36386, 36036, 35986, 35899, 35843, 35596, 35078, 35072, 35063, 34973, 34601, 34244, 34163, 33979, 33941, 33874, 33280, 33262, 33140, 33101, 32971, 32846, 32844, 32779, 32765, 32726, 32713, 32567, 32545, 32536, 32366, 32344, 32313, 31936, 31800, 31790, 31603, 31542, 31450, 31405, 31399, 31371, 31360, 31278, 31100, 31049, 31003, 30986, 30884, 30765, 30746, 30687, 30129, 30053, 30019, 29974, 29807, 29681, 29649, 29580, 29529, 29522, 29461, 28966, 28885, 28726, 28423, 28162, 27912, 27883, 27581, 27500, 27440, 26844, 26674, 26557, 26524, 26234, 25962, 25695, 25579, 25367, 24803, 24761, 24346, 24231, 23847, 23815, 23807, 23754, 23744, 23589, 23240, 23200, 23064, 22492, 22270, 21904, 21832, 21788, 21733, 21732, 21305, 21174, 21170, 21120, 21111, 20818, 20767, 20508, 20504, 20450, 19914, 19821, 19729, 19712, 19507, 18639, 18582, 18337, 18334, 18171, 18006, 17877, 17247, 17182, 17003, 16935, 16791, 16657, 16563, 16290, 16019, 15891, 15854, 15848, 15847, 15676, 15549, 15403, 15237, 15212, 12300, 12230, 12064, 11977, 11908, 11904, 11876, 10921, 10860, 10435, 10300, 8154, 7899, 7679, 7645, 7409, 7364, 6886, 6112, 5557, 5366, 5206, 5153, 5032, 4699, 4435, 3978, 3809, 2716, 2655, 2391, 2281, 2278, 2266, 2023, 1897, 1731, 1653, 1550, 1285, 813, 388, 283, 256, 60, 17))
Run Time: 0.107986
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 226 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,squattheplanet.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 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: 713, 0, 1714495258, {"thread-43037":["thread",43037],"thread-42981":["thread",42981],"thread-42943":["thread",42943],"thread-42782":["thread",42782],"thread-42681":["thread",42681],"thread-42295":["thread",42295],"thread-41821":["thread",41821],"thread-41786":["thread",41786],"thread-41619":["thread",41619],"thread-41524":["thread",41524],"thread-39766":["thread",39766],"thread-39722":["thread",39722],"thread-39625":["thread",39625],"thread-39562":["thread",39562],"thread-39439":["thread",39439],"thread-39428":["thread",39428],"thread-38930":["thread",38930],"thread-38897":["thread",38897],"thread-38814":["thread",38814],"thread-38785":["thread",38785],"thread-38667":["thread",38667],"thread-38333":["thread",38333],"thread-38248":["thread",38248],"thread-38239":["thread",38239],"thread-37954":["thread",37954],"thread-37829":["thread",37829],"thread-37739":["thread",37739],"thread-37684":["thread",37684],"thread-37606":["thread",37606],"thread-37546":["thread",37546],"thread-37473":["thread",37473],"thread-37355":["thread",37355],"thread-37096":["thread",37096],"thread-36987":["thread",36987],"thread-36882":["thread",36882],"thread-36755":["thread",36755],"thread-36701":["thread",36701],"thread-36386":["thread",36386],"thread-36036":["thread",36036],"thread-35986":["thread",35986],"thread-35899":["thread",35899],"thread-35843":["thread",35843],"thread-35596":["thread",35596],"thread-35078":["thread",35078],"thread-35072":["thread",35072],"thread-35063":["thread",35063],"thread-34973":["thread",34973],"thread-34601":["thread",34601],"thread-34244":["thread",34244],"thread-34163":["thread",34163],"thread-33979":["thread",33979],"thread-33941":["thread",33941],"thread-33874":["thread",33874],"thread-33280":["thread",33280],"thread-33262":["thread",33262],"thread-33140":["thread",33140],"thread-33101":["thread",33101],"thread-32971":["thread",32971],"thread-32846":["thread",32846],"thread-32844":["thread",32844],"thread-32779":["thread",32779],"thread-32765":["thread",32765],"thread-32726":["thread",32726],"thread-32713":["thread",32713],"thread-32567":["thread",32567],"thread-32545":["thread",32545],"thread-32536":["thread",32536],"thread-32366":["thread",32366],"thread-32344":["thread",32344],"thread-32313":["thread",32313],"thread-31936":["thread",31936],"thread-31800":["thread",31800],"thread-31790":["thread",31790],"thread-31603":["thread",31603],"thread-31542":["thread",31542],"thread-31450":["thread",31450],"thread-31405":["thread",31405],"thread-31399":["thread",31399],"thread-31371":["thread",31371],"thread-31360":["thread",31360],"thread-31278":["thread",31278],"thread-31100":["thread",31100],"thread-31049":["thread",31049],"thread-31003":["thread",31003],"thread-30986":["thread",30986],"thread-30884":["thread",30884],"thread-30765":["thread",30765],"thread-30746":["thread",30746],"thread-30687":["thread",30687],"thread-30129":["thread",30129],"thread-30053":["thread",30053],"thread-30019":["thread",30019],"thread-29974":["thread",29974],"thread-29807":["thread",29807],"thread-29681":["thread",29681],"thread-29649":["thread",29649],"thread-29580":["thread",29580],"thread-29529":["thread",29529],"thread-29522":["thread",29522],"thread-29461":["thread",29461],"thread-28966":["thread",28966],"thread-28885":["thread",28885],"thread-28726":["thread",28726],"thread-28423":["thread",28423],"thread-28162":["thread",28162],"thread-27912":["thread",27912],"thread-27883":["thread",27883],"thread-27581":["thread",27581],"thread-27500":["thread",27500],"thread-27440":["thread",27440],"thread-26844":["thread",26844],"thread-26674":["thread",26674],"thread-26557":["thread",26557],"thread-26524":["thread",26524],"thread-26234":["thread",26234],"thread-25962":["thread",25962],"thread-25695":["thread",25695],"thread-25579":["thread",25579],"thread-25367":["thread",25367],"thread-24803":["thread",24803],"thread-24761":["thread",24761],"thread-24346":["thread",24346],"thread-24231":["thread",24231],"thread-23847":["thread",23847],"thread-23815":["thread",23815],"thread-23807":["thread",23807],"thread-23754":["thread",23754],"thread-23744":["thread",23744],"thread-23589":["thread",23589],"thread-23240":["thread",23240],"thread-23200":["thread",23200],"thread-23064":["thread",23064],"thread-22492":["thread",22492],"thread-22270":["thread",22270],"thread-21904":["thread",21904],"thread-21832":["thread",21832],"thread-21788":["thread",21788],"thread-21733":["thread",21733],"thread-21732":["thread",21732],"thread-21305":["thread",21305],"thread-21174":["thread",21174],"thread-21170":["thread",21170],"thread-21120":["thread",21120],"thread-21111":["thread",21111],"thread-20818":["thread",20818],"thread-20767":["thread",20767],"thread-20508":["thread",20508],"thread-20504":["thread",20504],"thread-20450":["thread",20450],"thread-19914":["thread",19914],"thread-19821":["thread",19821],"thread-19729":["thread",19729],"thread-19712":["thread",19712],"thread-19507":["thread",19507],"thread-18639":["thread",18639],"thread-18582":["thread",18582],"thread-18337":["thread",18337],"thread-18334":["thread",18334],"thread-18171":["thread",18171],"thread-18006":["thread",18006],"thread-17877":["thread",17877],"thread-17247":["thread",17247],"thread-17182":["thread",17182],"thread-17003":["thread",17003],"thread-16935":["thread",16935],"thread-16791":["thread",16791],"thread-16657":["thread",16657],"thread-16563":["thread",16563],"thread-16290":["thread",16290],"thread-16019":["thread",16019],"thread-15891":["thread",15891],"thread-15854":["thread",15854],"thread-15848":["thread",15848],"thread-15847":["thread",15847],"thread-15676":["thread",15676],"thread-15549":["thread",15549],"thread-15403":["thread",15403],"thread-15237":["thread",15237],"thread-15212":["thread",15212],"thread-12300":["thread",12300],"thread-12230":["thread",12230],"thread-12064":["thread",12064],"thread-11977":["thread",11977],"thread-11908":["thread",11908],"thread-11904":["thread",11904],"thread-11876":["thread",11876],"thread-10921":["thread",10921],"thread-10860":["thread",10860],"thread-10435":["thread",10435],"thread-10300":["thread",10300],"thread-8154":["thread",8154],"thread-7899":["thread",7899],"thread-7679":["thread",7679],"thread-7645":["thread",7645],"thread-7409":["thread",7409],"thread-7364":["thread",7364],"thread-6886":["thread",6886],"thread-6112":["thread",6112],"thread-5557":["thread",5557],"thread-5366":["thread",5366],"thread-5206":["thread",5206],"thread-5153":["thread",5153],"thread-5032":["thread",5032],"thread-4699":["thread",4699],"thread-4435":["thread",4435],"thread-3978":["thread",3978],"thread-3809":["thread",3809],"thread-2716":["thread",2716],"thread-2655":["thread",2655],"thread-2391":["thread",2391],"thread-2281":["thread",2281],"thread-2278":["thread",2278],"thread-2266":["thread",2266],"thread-2023":["thread",2023],"thread-1897":["thread",1897],"thread-1731":["thread",1731],"thread-1653":["thread",1653],"thread-1550":["thread",1550],"thread-1285":["thread",1285],"thread-813":["thread",813],"thread-388":["thread",388],"thread-283":["thread",283],"thread-256":["thread",256],"thread-60":["thread",60]}, NULL, 1714491658
Run Time: 0.002935
- 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