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 (44998, 44997, 44995, 43620, 43158, 43033, 42293, 42230, 41966, 40474, 40198, 39998, 39905, 39728, 39230, 38503, 38488, 38261, 38223, 38111, 38091, 37895, 37783, 37360, 37215, 36824, 36784, 36753, 36453, 36238, 36229, 35787, 35447, 35366, 35193, 34570, 34478, 34106, 33950, 33931, 33588, 33581, 33429, 33381, 33224, 33204, 33138, 32910, 32265, 31898, 31323, 30930, 30856, 30697, 30652, 30357, 30304, 30245, 30228, 30032, 29965, 29900, 29899, 29881, 29822, 29777, 29758, 29683, 29628, 29574, 29550, 29425, 29371, 29345, 29135, 29128, 28998, 28985, 28767, 28703, 28628, 28558, 28080, 27795, 27525, 27409, 27232, 27122, 26706, 26677, 26495, 26319, 26130, 26100, 25817, 25137, 24471, 24262, 23374, 22768, 22732, 22701, 22537, 19346, 19241, 19234, 19233, 18542, 16340, 15598, 15492, 14108, 12536, 12833, 12832, 11621, 11387, 11011, 10776, 10389, 10148, 9843, 9768, 7842, 4661, 4025, 2623))
Run Time: 0.041717
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 127 | 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: 46, 0, 1713864887, {"thread-44998":["thread",44998],"thread-44997":["thread",44997],"thread-44995":["thread",44995],"thread-43620":["thread",43620],"thread-43033":["thread",43033],"thread-42293":["thread",42293],"thread-42230":["thread",42230],"thread-41966":["thread",41966],"thread-40474":["thread",40474],"thread-40198":["thread",40198],"thread-39998":["thread",39998],"thread-39905":["thread",39905],"thread-39728":["thread",39728],"thread-39230":["thread",39230],"thread-38503":["thread",38503],"thread-38488":["thread",38488],"thread-38111":["thread",38111],"thread-38091":["thread",38091],"thread-37895":["thread",37895],"thread-37783":["thread",37783],"thread-37360":["thread",37360],"thread-37215":["thread",37215],"thread-36824":["thread",36824],"thread-36784":["thread",36784],"thread-36753":["thread",36753],"thread-36453":["thread",36453],"thread-36238":["thread",36238],"thread-35787":["thread",35787],"thread-35447":["thread",35447],"thread-35366":["thread",35366],"thread-35193":["thread",35193],"thread-34570":["thread",34570],"thread-34478":["thread",34478],"thread-34106":["thread",34106],"thread-33950":["thread",33950],"thread-33931":["thread",33931],"thread-33588":["thread",33588],"thread-33581":["thread",33581],"thread-33429":["thread",33429],"thread-33381":["thread",33381],"thread-33224":["thread",33224],"thread-33138":["thread",33138],"thread-32910":["thread",32910],"thread-32265":["thread",32265],"thread-31898":["thread",31898],"thread-31323":["thread",31323],"thread-30930":["thread",30930],"thread-30856":["thread",30856],"thread-30697":["thread",30697],"thread-30652":["thread",30652],"thread-30357":["thread",30357],"thread-30304":["thread",30304],"thread-30245":["thread",30245],"thread-30228":["thread",30228],"thread-30032":["thread",30032],"thread-29965":["thread",29965],"thread-29900":["thread",29900],"thread-29899":["thread",29899],"thread-29881":["thread",29881],"thread-29822":["thread",29822],"thread-29777":["thread",29777],"thread-29758":["thread",29758],"thread-29683":["thread",29683],"thread-29628":["thread",29628],"thread-29574":["thread",29574],"thread-29550":["thread",29550],"thread-29425":["thread",29425],"thread-29371":["thread",29371],"thread-29345":["thread",29345],"thread-29135":["thread",29135],"thread-29128":["thread",29128],"thread-28998":["thread",28998],"thread-28985":["thread",28985],"thread-28767":["thread",28767],"thread-28703":["thread",28703],"thread-28628":["thread",28628],"thread-28558":["thread",28558],"thread-28080":["thread",28080],"thread-27795":["thread",27795],"thread-27525":["thread",27525],"thread-27409":["thread",27409],"thread-27232":["thread",27232],"thread-27122":["thread",27122],"thread-26706":["thread",26706],"thread-26677":["thread",26677],"thread-26495":["thread",26495],"thread-26130":["thread",26130],"thread-26100":["thread",26100],"thread-25817":["thread",25817],"thread-25137":["thread",25137],"thread-24471":["thread",24471],"thread-24262":["thread",24262],"thread-23374":["thread",23374],"thread-22768":["thread",22768],"thread-22732":["thread",22732],"thread-22701":["thread",22701],"thread-22537":["thread",22537],"thread-19346":["thread",19346],"thread-19241":["thread",19241],"thread-19234":["thread",19234],"thread-19233":["thread",19233],"thread-18542":["thread",18542],"thread-15598":["thread",15598],"thread-15492":["thread",15492],"thread-14108":["thread",14108],"thread-12536":["thread",12536],"thread-12832":["thread",12832],"thread-11621":["thread",11621],"thread-11387":["thread",11387],"thread-11011":["thread",11011],"thread-10776":["thread",10776],"thread-10389":["thread",10389],"thread-10148":["thread",10148],"thread-9843":["thread",9843],"thread-7842":["thread",7842],"thread-4025":["thread",4025],"thread-2623":["thread",2623]}, NULL, 1713861287
Run Time: 0.000616
- 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