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 (45093, 45082, 45081, 45073, 45060, 45046, 45028, 45019, 45014, 45012, 44987, 44986, 44977, 44976, 44972, 44970, 44948, 44937, 44935, 44927, 44925, 44922, 44874, 43420, 43317, 43313, 43221, 43215, 43086, 43030, 43021, 43002, 42979, 42843, 42713, 42622, 42580, 42528, 42432, 42358, 42351, 42035, 42005, 41927, 41906, 41852, 41849, 41553, 41548, 41462, 41371, 40989, 40855, 40838, 40806, 40650, 40523, 40519, 40360, 40283, 40245, 39789, 39482, 39468, 39467, 39372, 39202, 39195, 39092, 39026, 39004, 38992, 38990, 38978, 38952, 38581, 38518, 38508, 38368, 38280, 38240, 38187, 38043, 37947, 37900, 37733, 37684, 37671, 37641, 37584, 37432, 37387, 37349, 37286, 37106, 37093, 37063, 37062, 37046, 36992, 36919, 36898, 36745, 36742, 36708, 36367, 36288, 36173, 36165, 36125, 35934, 35831, 35736, 35606, 35596, 35402, 35401, 35221, 35078, 35042, 34994, 34828, 34802, 34787, 34722, 34618, 34558, 34297, 34244, 34173, 34157, 34126, 34083, 34043, 33994, 33884, 33770, 33748, 33742, 33717, 33678, 33598, 33577, 33232, 33195, 33112, 33070, 32911, 32895, 32893, 32749, 32640, 32538, 32403, 32337, 32294, 32062, 32028, 32023, 31918, 31874, 31800, 31766, 31744, 31731, 31721, 31706, 31688, 31665, 31630, 31542, 31511, 31479, 31477, 31249, 31238, 31195, 31154, 31153, 31121, 31048, 31041, 31033, 30994, 30925, 30901, 30865, 30862, 30703, 30570, 30524, 30481, 30347, 30334, 30257, 30222, 30162, 30148, 30108, 30079, 30064, 30021, 30016, 30001, 29931, 29910, 29905, 29715, 29701, 29690, 29474, 29339, 29337, 29282, 29279, 29276, 29253, 29225, 29213, 29205, 29092, 29081, 29020, 29019, 28975, 28882, 28877, 28808, 28800, 28635, 28440, 28424, 28212, 28180, 28113, 28038, 28032, 28021, 28000, 27982, 27930, 27929, 27928, 27900, 27884, 27876, 27849, 27792, 27739, 27704))
Run Time: 0.070761
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 250 | 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: 51, 0, 1714929595, {"thread-45093":["thread",45093],"thread-45082":["thread",45082],"thread-45081":["thread",45081],"thread-45073":["thread",45073],"thread-45060":["thread",45060],"thread-45046":["thread",45046],"thread-45028":["thread",45028],"thread-45019":["thread",45019],"thread-45014":["thread",45014],"thread-45012":["thread",45012],"thread-44986":["thread",44986],"thread-44977":["thread",44977],"thread-44976":["thread",44976],"thread-44972":["thread",44972],"thread-44970":["thread",44970],"thread-44948":["thread",44948],"thread-44937":["thread",44937],"thread-44935":["thread",44935],"thread-44927":["thread",44927],"thread-44925":["thread",44925],"thread-43420":["thread",43420],"thread-43317":["thread",43317],"thread-43313":["thread",43313],"thread-43221":["thread",43221],"thread-43215":["thread",43215],"thread-43086":["thread",43086],"thread-43030":["thread",43030],"thread-43021":["thread",43021],"thread-42979":["thread",42979],"thread-42843":["thread",42843],"thread-42713":["thread",42713],"thread-42580":["thread",42580],"thread-42528":["thread",42528],"thread-42432":["thread",42432],"thread-42358":["thread",42358],"thread-42351":["thread",42351],"thread-42035":["thread",42035],"thread-42005":["thread",42005],"thread-41927":["thread",41927],"thread-41906":["thread",41906],"thread-41852":["thread",41852],"thread-41849":["thread",41849],"thread-41553":["thread",41553],"thread-41548":["thread",41548],"thread-41371":["thread",41371],"thread-40989":["thread",40989],"thread-40855":["thread",40855],"thread-40806":["thread",40806],"thread-40523":["thread",40523],"thread-40519":["thread",40519],"thread-40360":["thread",40360],"thread-40283":["thread",40283],"thread-40245":["thread",40245],"thread-39482":["thread",39482],"thread-39467":["thread",39467],"thread-39372":["thread",39372],"thread-39202":["thread",39202],"thread-39195":["thread",39195],"thread-39092":["thread",39092],"thread-39026":["thread",39026],"thread-39004":["thread",39004],"thread-38992":["thread",38992],"thread-38990":["thread",38990],"thread-38978":["thread",38978],"thread-38952":["thread",38952],"thread-38581":["thread",38581],"thread-38518":["thread",38518],"thread-38508":["thread",38508],"thread-38368":["thread",38368],"thread-38280":["thread",38280],"thread-38240":["thread",38240],"thread-38187":["thread",38187],"thread-38043":["thread",38043],"thread-37947":["thread",37947],"thread-37900":["thread",37900],"thread-37733":["thread",37733],"thread-37684":["thread",37684],"thread-37671":["thread",37671],"thread-37641":["thread",37641],"thread-37432":["thread",37432],"thread-37387":["thread",37387],"thread-37349":["thread",37349],"thread-37106":["thread",37106],"thread-37093":["thread",37093],"thread-37063":["thread",37063],"thread-37046":["thread",37046],"thread-36992":["thread",36992],"thread-36919":["thread",36919],"thread-36898":["thread",36898],"thread-36745":["thread",36745],"thread-36708":["thread",36708],"thread-36367":["thread",36367],"thread-36288":["thread",36288],"thread-36173":["thread",36173],"thread-36165":["thread",36165],"thread-36125":["thread",36125],"thread-35934":["thread",35934],"thread-35831":["thread",35831],"thread-35736":["thread",35736],"thread-35606":["thread",35606],"thread-35596":["thread",35596],"thread-35402":["thread",35402],"thread-35401":["thread",35401],"thread-35078":["thread",35078],"thread-35042":["thread",35042],"thread-34994":["thread",34994],"thread-34828":["thread",34828],"thread-34802":["thread",34802],"thread-34787":["thread",34787],"thread-34722":["thread",34722],"thread-34618":["thread",34618],"thread-34558":["thread",34558],"thread-34297":["thread",34297],"thread-34244":["thread",34244],"thread-34173":["thread",34173],"thread-34157":["thread",34157],"thread-34126":["thread",34126],"thread-34083":["thread",34083],"thread-34043":["thread",34043],"thread-33994":["thread",33994],"thread-33770":["thread",33770],"thread-33748":["thread",33748],"thread-33742":["thread",33742],"thread-33717":["thread",33717],"thread-33678":["thread",33678],"thread-33598":["thread",33598],"thread-33577":["thread",33577],"thread-33232":["thread",33232],"thread-33112":["thread",33112],"thread-33070":["thread",33070],"thread-32895":["thread",32895],"thread-32893":["thread",32893],"thread-32749":["thread",32749],"thread-32640":["thread",32640],"thread-32403":["thread",32403],"thread-32062":["thread",32062],"thread-32028":["thread",32028],"thread-32023":["thread",32023],"thread-31918":["thread",31918],"thread-31874":["thread",31874],"thread-31800":["thread",31800],"thread-31766":["thread",31766],"thread-31744":["thread",31744],"thread-31731":["thread",31731],"thread-31721":["thread",31721],"thread-31706":["thread",31706],"thread-31688":["thread",31688],"thread-31665":["thread",31665],"thread-31630":["thread",31630],"thread-31542":["thread",31542],"thread-31511":["thread",31511],"thread-31479":["thread",31479],"thread-31249":["thread",31249],"thread-31195":["thread",31195],"thread-31154":["thread",31154],"thread-31153":["thread",31153],"thread-31121":["thread",31121],"thread-31048":["thread",31048],"thread-31041":["thread",31041],"thread-31033":["thread",31033],"thread-30994":["thread",30994],"thread-30925":["thread",30925],"thread-30901":["thread",30901],"thread-30862":["thread",30862],"thread-30703":["thread",30703],"thread-30570":["thread",30570],"thread-30524":["thread",30524],"thread-30481":["thread",30481],"thread-30347":["thread",30347],"thread-30334":["thread",30334],"thread-30222":["thread",30222],"thread-30162":["thread",30162],"thread-30148":["thread",30148],"thread-30108":["thread",30108],"thread-30079":["thread",30079],"thread-30064":["thread",30064],"thread-30021":["thread",30021],"thread-30016":["thread",30016],"thread-29931":["thread",29931],"thread-29905":["thread",29905],"thread-29715":["thread",29715],"thread-29701":["thread",29701],"thread-29474":["thread",29474],"thread-29339":["thread",29339],"thread-29337":["thread",29337],"thread-29282":["thread",29282],"thread-29279":["thread",29279],"thread-29276":["thread",29276],"thread-29253":["thread",29253],"thread-29213":["thread",29213],"thread-29205":["thread",29205],"thread-29092":["thread",29092],"thread-29081":["thread",29081],"thread-29020":["thread",29020],"thread-29019":["thread",29019],"thread-28975":["thread",28975],"thread-28882":["thread",28882],"thread-28877":["thread",28877],"thread-28808":["thread",28808],"thread-28800":["thread",28800],"thread-28635":["thread",28635],"thread-28440":["thread",28440],"thread-28424":["thread",28424],"thread-28212":["thread",28212],"thread-28180":["thread",28180],"thread-28113":["thread",28113],"thread-28038":["thread",28038],"thread-28032":["thread",28032],"thread-28021":["thread",28021],"thread-27982":["thread",27982],"thread-27930":["thread",27930],"thread-27929":["thread",27929],"thread-27928":["thread",27928],"thread-27900":["thread",27900],"thread-27884":["thread",27884],"thread-27876":["thread",27876],"thread-27792":["thread",27792],"thread-27739":["thread",27739],"thread-27704":["thread",27704]}, NULL, 1714925995
Run Time: 0.000772
- 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