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 (45073, 45064, 44975, 44863, 43329, 43302, 43224, 43030, 42811, 42613, 42180, 41938, 41899, 41890, 41623, 41555, 41156, 40646, 40637, 40629, 40475, 39920, 39686, 39561, 39514, 39392, 39380, 39361, 39315, 39293, 39273, 39093, 38834, 38759, 38558, 38387, 38351, 38273, 38071, 37937, 37829, 37750, 37660, 37534, 41538, 37448, 37373, 37208, 37085, 36926, 36810, 36803, 36780, 36760, 36528, 36306, 36294, 35934, 35625, 35167, 34794, 34723, 34714, 34544, 34387, 34350, 34187, 34177, 34168, 34126, 33994, 33920, 33537, 33389, 33372, 33209, 33112, 33057, 33005, 32385, 32200, 31949, 31190, 30686, 30051, 29909, 29850, 29837, 29367, 29041, 28733, 28728, 28714, 28252, 28213, 28102, 28077, 28035, 27921, 27919, 27857, 27739, 27604, 27404, 27292, 27160, 27111, 27011, 26968, 26934, 26930, 26929, 26810, 26796, 26585, 26582, 26525, 26439, 26342, 26076, 25852, 25737, 25562, 25544, 25508, 25501, 25472, 25209, 24847, 24734, 24507, 24321, 24210, 24152, 24131, 24071, 24048, 23827, 23739, 23646, 23624, 23437, 23373, 23353, 22697, 22527, 22513, 22374, 22151, 22098, 21875, 21751, 21191, 21063, 20988, 20975, 20836, 20685, 20534, 20458, 20386, 20314, 20026, 20025, 19851, 19800, 19774, 19738, 19698, 19686, 19682, 19675, 19624, 19491, 19420, 19348, 19324, 19132, 19044, 18897, 18889, 18827, 18587, 18571, 18521, 18435, 18419, 18257, 18178, 17843, 17458, 17453, 17402, 17284, 17136, 17017, 16953, 16852, 16793, 16659, 16502, 16385, 16198, 16020, 15999, 15978, 15800, 15750, 15561, 15466, 15308, 15271, 15270, 15207, 15177, 15156, 14984, 14801, 14798, 14704, 14649, 14570, 14524, 14477, 14321, 14206, 14195, 14194, 14193, 14131, 14060, 13648, 12692, 12630, 12600, 12513, 12341, 12312, 12192, 11785, 11702, 11617, 11568, 11550, 11499, 11457, 11391, 11109, 11078, 10945))
Run Time: 0.081025
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: 64, 0, 1714151815, {"thread-45073":["thread",45073],"thread-44975":["thread",44975],"thread-44863":["thread",44863],"thread-43329":["thread",43329],"thread-43224":["thread",43224],"thread-43030":["thread",43030],"thread-42613":["thread",42613],"thread-41938":["thread",41938],"thread-41890":["thread",41890],"thread-41623":["thread",41623],"thread-41555":["thread",41555],"thread-41156":["thread",41156],"thread-40646":["thread",40646],"thread-40637":["thread",40637],"thread-40475":["thread",40475],"thread-39920":["thread",39920],"thread-39686":["thread",39686],"thread-39561":["thread",39561],"thread-39514":["thread",39514],"thread-39392":["thread",39392],"thread-39380":["thread",39380],"thread-39315":["thread",39315],"thread-39293":["thread",39293],"thread-39273":["thread",39273],"thread-39093":["thread",39093],"thread-38834":["thread",38834],"thread-38759":["thread",38759],"thread-38558":["thread",38558],"thread-38387":["thread",38387],"thread-38273":["thread",38273],"thread-38071":["thread",38071],"thread-37937":["thread",37937],"thread-37829":["thread",37829],"thread-37750":["thread",37750],"thread-37660":["thread",37660],"thread-41538":["thread",41538],"thread-37448":["thread",37448],"thread-37373":["thread",37373],"thread-37085":["thread",37085],"thread-36810":["thread",36810],"thread-36803":["thread",36803],"thread-36780":["thread",36780],"thread-36760":["thread",36760],"thread-36528":["thread",36528],"thread-36306":["thread",36306],"thread-36294":["thread",36294],"thread-35934":["thread",35934],"thread-35625":["thread",35625],"thread-35167":["thread",35167],"thread-34794":["thread",34794],"thread-34723":["thread",34723],"thread-34714":["thread",34714],"thread-34544":["thread",34544],"thread-34387":["thread",34387],"thread-34187":["thread",34187],"thread-34177":["thread",34177],"thread-34168":["thread",34168],"thread-34126":["thread",34126],"thread-33994":["thread",33994],"thread-33920":["thread",33920],"thread-33537":["thread",33537],"thread-33389":["thread",33389],"thread-33372":["thread",33372],"thread-33209":["thread",33209],"thread-33112":["thread",33112],"thread-33057":["thread",33057],"thread-32385":["thread",32385],"thread-32200":["thread",32200],"thread-31949":["thread",31949],"thread-31190":["thread",31190],"thread-30686":["thread",30686],"thread-30051":["thread",30051],"thread-29909":["thread",29909],"thread-29850":["thread",29850],"thread-29837":["thread",29837],"thread-29367":["thread",29367],"thread-29041":["thread",29041],"thread-28733":["thread",28733],"thread-28714":["thread",28714],"thread-28252":["thread",28252],"thread-28213":["thread",28213],"thread-28102":["thread",28102],"thread-28077":["thread",28077],"thread-28035":["thread",28035],"thread-27921":["thread",27921],"thread-27919":["thread",27919],"thread-27857":["thread",27857],"thread-27739":["thread",27739],"thread-27604":["thread",27604],"thread-27404":["thread",27404],"thread-27292":["thread",27292],"thread-27160":["thread",27160],"thread-27111":["thread",27111],"thread-27011":["thread",27011],"thread-26968":["thread",26968],"thread-26934":["thread",26934],"thread-26930":["thread",26930],"thread-26929":["thread",26929],"thread-26810":["thread",26810],"thread-26585":["thread",26585],"thread-26582":["thread",26582],"thread-26525":["thread",26525],"thread-26439":["thread",26439],"thread-26342":["thread",26342],"thread-26076":["thread",26076],"thread-25852":["thread",25852],"thread-25737":["thread",25737],"thread-25562":["thread",25562],"thread-25544":["thread",25544],"thread-25508":["thread",25508],"thread-25501":["thread",25501],"thread-25472":["thread",25472],"thread-24847":["thread",24847],"thread-24734":["thread",24734],"thread-24507":["thread",24507],"thread-24321":["thread",24321],"thread-24210":["thread",24210],"thread-24152":["thread",24152],"thread-24131":["thread",24131],"thread-24071":["thread",24071],"thread-24048":["thread",24048],"thread-23827":["thread",23827],"thread-23739":["thread",23739],"thread-23646":["thread",23646],"thread-23624":["thread",23624],"thread-23437":["thread",23437],"thread-23373":["thread",23373],"thread-23353":["thread",23353],"thread-22697":["thread",22697],"thread-22527":["thread",22527],"thread-22513":["thread",22513],"thread-22374":["thread",22374],"thread-22151":["thread",22151],"thread-22098":["thread",22098],"thread-21751":["thread",21751],"thread-21191":["thread",21191],"thread-21063":["thread",21063],"thread-20988":["thread",20988],"thread-20975":["thread",20975],"thread-20836":["thread",20836],"thread-20685":["thread",20685],"thread-20458":["thread",20458],"thread-20386":["thread",20386],"thread-20026":["thread",20026],"thread-20025":["thread",20025],"thread-19851":["thread",19851],"thread-19800":["thread",19800],"thread-19774":["thread",19774],"thread-19738":["thread",19738],"thread-19698":["thread",19698],"thread-19686":["thread",19686],"thread-19682":["thread",19682],"thread-19675":["thread",19675],"thread-19624":["thread",19624],"thread-19491":["thread",19491],"thread-19420":["thread",19420],"thread-19348":["thread",19348],"thread-19324":["thread",19324],"thread-19132":["thread",19132],"thread-19044":["thread",19044],"thread-18897":["thread",18897],"thread-18889":["thread",18889],"thread-18827":["thread",18827],"thread-18587":["thread",18587],"thread-18571":["thread",18571],"thread-18521":["thread",18521],"thread-18435":["thread",18435],"thread-18419":["thread",18419],"thread-18257":["thread",18257],"thread-18178":["thread",18178],"thread-17843":["thread",17843],"thread-17458":["thread",17458],"thread-17453":["thread",17453],"thread-17402":["thread",17402],"thread-17284":["thread",17284],"thread-17136":["thread",17136],"thread-17017":["thread",17017],"thread-16953":["thread",16953],"thread-16852":["thread",16852],"thread-16793":["thread",16793],"thread-16659":["thread",16659],"thread-16502":["thread",16502],"thread-16385":["thread",16385],"thread-16198":["thread",16198],"thread-16020":["thread",16020],"thread-15999":["thread",15999],"thread-15978":["thread",15978],"thread-15800":["thread",15800],"thread-15750":["thread",15750],"thread-15561":["thread",15561],"thread-15466":["thread",15466],"thread-15308":["thread",15308],"thread-15271":["thread",15271],"thread-15270":["thread",15270],"thread-15207":["thread",15207],"thread-15177":["thread",15177],"thread-15156":["thread",15156],"thread-14984":["thread",14984],"thread-14801":["thread",14801],"thread-14798":["thread",14798],"thread-14704":["thread",14704],"thread-14649":["thread",14649],"thread-14570":["thread",14570],"thread-14524":["thread",14524],"thread-14477":["thread",14477],"thread-14321":["thread",14321],"thread-14206":["thread",14206],"thread-14195":["thread",14195],"thread-14194":["thread",14194],"thread-14193":["thread",14193],"thread-14131":["thread",14131],"thread-14060":["thread",14060],"thread-13648":["thread",13648],"thread-12692":["thread",12692],"thread-12630":["thread",12630],"thread-12600":["thread",12600],"thread-12513":["thread",12513],"thread-12341":["thread",12341],"thread-12312":["thread",12312],"thread-12192":["thread",12192],"thread-11785":["thread",11785],"thread-11702":["thread",11702],"thread-11617":["thread",11617],"thread-11568":["thread",11568],"thread-11550":["thread",11550],"thread-11499":["thread",11499],"thread-11457":["thread",11457],"thread-11391":["thread",11391],"thread-11109":["thread",11109],"thread-11078":["thread",11078],"thread-10945":["thread",10945]}, NULL, 1714148215
Run Time: 0.000680
- 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