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 (45004, 44960, 44959, 43825, 43225, 42652, 42454, 42011, 41630, 41493, 41425, 40885, 40768, 40464, 40317, 40310, 40170, 40069, 39997, 39665, 39506, 39498, 37922, 37472, 36905, 36499, 36313, 36273, 36079, 36078, 35115, 34739, 34428, 34175, 34101, 33787, 33757, 33685, 33500, 33473, 33316, 33147, 33135, 33121, 32804, 32639, 32373, 32174, 32137, 31936, 31621, 31608, 31581, 31519, 31171, 31132, 30986, 30569, 30158, 30059, 29791, 29253, 28934, 28877, 28743, 27845, 27487, 27453, 27358, 27296, 26964, 26579, 26386, 26174, 26164, 25917, 25533, 25127, 24692, 24562, 24472, 23859, 23730, 23692, 23293, 22673, 22483, 22392, 21906, 21410, 20941, 20144, 19934, 19895, 19812, 19780, 19496, 19406, 19217, 19115, 19017, 18855, 18786, 18472, 18454, 18304, 18303, 18005, 17941, 17617, 17352, 17278, 17235, 16705, 16571, 16469, 16293, 15942, 15912, 15813, 15656, 14904, 14899, 14775, 14727, 14499, 14496, 14097, 13749, 13649, 12816, 12177, 12158, 12146, 12122, 11901, 11508, 11444, 11184, 11131, 11072, 11018, 10987, 10876, 10555, 10408, 10233, 8394, 8373, 7705, 7626, 7458, 7437, 7388, 7047, 6931, 6905, 6619, 5973, 5786, 5680, 5349, 4915, 4856, 4281, 4278, 4176, 4135, 4007, 3939, 3919, 3876, 3831, 3663, 3345, 3252, 2744, 2717, 2689, 2571, 2340, 2220, 2153, 2056, 1992, 1980, 1851, 1700, 1647, 1594, 1326, 1300, 1248, 1223, 1204, 1130, 1047, 762, 689, 682, 445, 237, 186, 122, 84, 72, 19))
Run Time: 0.086829
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 207 | 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: 143, 0, 1714843217, {"thread-45004":["thread",45004],"thread-44960":["thread",44960],"thread-44959":["thread",44959],"thread-43825":["thread",43825],"thread-42652":["thread",42652],"thread-42454":["thread",42454],"thread-41630":["thread",41630],"thread-41493":["thread",41493],"thread-41425":["thread",41425],"thread-40885":["thread",40885],"thread-40768":["thread",40768],"thread-40464":["thread",40464],"thread-40317":["thread",40317],"thread-40310":["thread",40310],"thread-40170":["thread",40170],"thread-40069":["thread",40069],"thread-39997":["thread",39997],"thread-39506":["thread",39506],"thread-39498":["thread",39498],"thread-37922":["thread",37922],"thread-37472":["thread",37472],"thread-36499":["thread",36499],"thread-36313":["thread",36313],"thread-36273":["thread",36273],"thread-36079":["thread",36079],"thread-35115":["thread",35115],"thread-34739":["thread",34739],"thread-34428":["thread",34428],"thread-34175":["thread",34175],"thread-34101":["thread",34101],"thread-33787":["thread",33787],"thread-33757":["thread",33757],"thread-33685":["thread",33685],"thread-33500":["thread",33500],"thread-33473":["thread",33473],"thread-33316":["thread",33316],"thread-33147":["thread",33147],"thread-33135":["thread",33135],"thread-33121":["thread",33121],"thread-32804":["thread",32804],"thread-32639":["thread",32639],"thread-32373":["thread",32373],"thread-32174":["thread",32174],"thread-32137":["thread",32137],"thread-31936":["thread",31936],"thread-31621":["thread",31621],"thread-31608":["thread",31608],"thread-31581":["thread",31581],"thread-31519":["thread",31519],"thread-31171":["thread",31171],"thread-31132":["thread",31132],"thread-30986":["thread",30986],"thread-30569":["thread",30569],"thread-30158":["thread",30158],"thread-30059":["thread",30059],"thread-29791":["thread",29791],"thread-29253":["thread",29253],"thread-28934":["thread",28934],"thread-28877":["thread",28877],"thread-28743":["thread",28743],"thread-27845":["thread",27845],"thread-27487":["thread",27487],"thread-27453":["thread",27453],"thread-27358":["thread",27358],"thread-27296":["thread",27296],"thread-26964":["thread",26964],"thread-26579":["thread",26579],"thread-26386":["thread",26386],"thread-26174":["thread",26174],"thread-26164":["thread",26164],"thread-25917":["thread",25917],"thread-25533":["thread",25533],"thread-25127":["thread",25127],"thread-24692":["thread",24692],"thread-24562":["thread",24562],"thread-24472":["thread",24472],"thread-23859":["thread",23859],"thread-23730":["thread",23730],"thread-23692":["thread",23692],"thread-23293":["thread",23293],"thread-22673":["thread",22673],"thread-22483":["thread",22483],"thread-22392":["thread",22392],"thread-21906":["thread",21906],"thread-21410":["thread",21410],"thread-20941":["thread",20941],"thread-20144":["thread",20144],"thread-19934":["thread",19934],"thread-19895":["thread",19895],"thread-19780":["thread",19780],"thread-19496":["thread",19496],"thread-19406":["thread",19406],"thread-19217":["thread",19217],"thread-19115":["thread",19115],"thread-19017":["thread",19017],"thread-18855":["thread",18855],"thread-18786":["thread",18786],"thread-18472":["thread",18472],"thread-18454":["thread",18454],"thread-18304":["thread",18304],"thread-18303":["thread",18303],"thread-18005":["thread",18005],"thread-17941":["thread",17941],"thread-17617":["thread",17617],"thread-17352":["thread",17352],"thread-17278":["thread",17278],"thread-17235":["thread",17235],"thread-16705":["thread",16705],"thread-16571":["thread",16571],"thread-16469":["thread",16469],"thread-16293":["thread",16293],"thread-15942":["thread",15942],"thread-15912":["thread",15912],"thread-15813":["thread",15813],"thread-15656":["thread",15656],"thread-14904":["thread",14904],"thread-14899":["thread",14899],"thread-14775":["thread",14775],"thread-14727":["thread",14727],"thread-14499":["thread",14499],"thread-14496":["thread",14496],"thread-14097":["thread",14097],"thread-13749":["thread",13749],"thread-13649":["thread",13649],"thread-12816":["thread",12816],"thread-12177":["thread",12177],"thread-12158":["thread",12158],"thread-12122":["thread",12122],"thread-11901":["thread",11901],"thread-11508":["thread",11508],"thread-11444":["thread",11444],"thread-11184":["thread",11184],"thread-11131":["thread",11131],"thread-11072":["thread",11072],"thread-10987":["thread",10987],"thread-10876":["thread",10876],"thread-10555":["thread",10555],"thread-10408":["thread",10408],"thread-10233":["thread",10233],"thread-8394":["thread",8394],"thread-8373":["thread",8373],"thread-7705":["thread",7705],"thread-7626":["thread",7626],"thread-7458":["thread",7458],"thread-7437":["thread",7437],"thread-7388":["thread",7388],"thread-7047":["thread",7047],"thread-6931":["thread",6931],"thread-6905":["thread",6905],"thread-6619":["thread",6619],"thread-5786":["thread",5786],"thread-5680":["thread",5680],"thread-5349":["thread",5349],"thread-4915":["thread",4915],"thread-4856":["thread",4856],"thread-4281":["thread",4281],"thread-4278":["thread",4278],"thread-4176":["thread",4176],"thread-4135":["thread",4135],"thread-4007":["thread",4007],"thread-3939":["thread",3939],"thread-3919":["thread",3919],"thread-3876":["thread",3876],"thread-3831":["thread",3831],"thread-3663":["thread",3663],"thread-3345":["thread",3345],"thread-3252":["thread",3252],"thread-2744":["thread",2744],"thread-2717":["thread",2717],"thread-2689":["thread",2689],"thread-2571":["thread",2571],"thread-2340":["thread",2340],"thread-2220":["thread",2220],"thread-2153":["thread",2153],"thread-2056":["thread",2056],"thread-1992":["thread",1992],"thread-1980":["thread",1980],"thread-1851":["thread",1851],"thread-1700":["thread",1700],"thread-1647":["thread",1647],"thread-1594":["thread",1594],"thread-1326":["thread",1326],"thread-1300":["thread",1300],"thread-1248":["thread",1248],"thread-1223":["thread",1223],"thread-1204":["thread",1204],"thread-1130":["thread",1130],"thread-1047":["thread",1047],"thread-762":["thread",762],"thread-689":["thread",689],"thread-682":["thread",682],"thread-445":["thread",445],"thread-237":["thread",237],"thread-186":["thread",186],"thread-122":["thread",122],"thread-84":["thread",84],"thread-72":["thread",72],"thread-19":["thread",19]}, NULL, 1714839617
Run Time: 0.001160
- 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