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 (7216438, 7208798, 7205805, 7205804, 7203472, 7203322, 7202391, 7201608, 7201476, 7199925, 7199832, 7194493, 7190091, 7185513, 7185192, 7185127, 7184823, 7184807, 7184531, 7184111, 7182416, 7178369, 7176245, 7173093, 7173025, 7171660, 7169972, 7169484, 7155769, 7154124, 7153126, 7151985, 7147930, 7144693, 7140776, 7139567, 7138977, 7132685, 7130657, 7123063, 7114221, 7114220, 7110551, 7106466, 7093160, 7092801, 7090677, 7090379, 7090241, 7090020, 7089331, 7085102, 7082952, 7082845, 7079953, 7070630, 7055135, 7045721, 7021673, 7010233, 7007814, 7004578, 7000937, 216851, 216816))
Run Time: 0.009164
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 65 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 2870
- 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 138
- 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 2487
- 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: 9732, 0, 1714541308, {"thread-7216438":["thread",7216438],"thread-7208798":["thread",7208798],"thread-7205805":["thread",7205805],"thread-7205804":["thread",7205804],"thread-7203472":["thread",7203472],"thread-7203322":["thread",7203322],"thread-7202391":["thread",7202391],"thread-7201608":["thread",7201608],"thread-7201476":["thread",7201476],"thread-7199925":["thread",7199925],"thread-7199832":["thread",7199832],"thread-7194493":["thread",7194493],"thread-7190091":["thread",7190091],"thread-7185513":["thread",7185513],"thread-7185192":["thread",7185192],"thread-7185127":["thread",7185127],"thread-7184823":["thread",7184823],"thread-7184807":["thread",7184807],"thread-7184531":["thread",7184531],"thread-7184111":["thread",7184111],"thread-7182416":["thread",7182416],"thread-7178369":["thread",7178369],"thread-7176245":["thread",7176245],"thread-7173093":["thread",7173093],"thread-7173025":["thread",7173025],"thread-7171660":["thread",7171660],"thread-7169972":["thread",7169972],"thread-7169484":["thread",7169484],"thread-7155769":["thread",7155769],"thread-7154124":["thread",7154124],"thread-7153126":["thread",7153126],"thread-7151985":["thread",7151985],"thread-7147930":["thread",7147930],"thread-7144693":["thread",7144693],"thread-7140776":["thread",7140776],"thread-7139567":["thread",7139567],"thread-7138977":["thread",7138977],"thread-7132685":["thread",7132685],"thread-7130657":["thread",7130657],"thread-7123063":["thread",7123063],"thread-7114221":["thread",7114221],"thread-7114220":["thread",7114220],"thread-7110551":["thread",7110551],"thread-7106466":["thread",7106466],"thread-7093160":["thread",7093160],"thread-7092801":["thread",7092801],"thread-7090677":["thread",7090677],"thread-7090379":["thread",7090379],"thread-7090241":["thread",7090241],"thread-7090020":["thread",7090020],"thread-7089331":["thread",7089331],"thread-7085102":["thread",7085102],"thread-7082952":["thread",7082952],"thread-7082845":["thread",7082845],"thread-7079953":["thread",7079953],"thread-7070630":["thread",7070630],"thread-7055135":["thread",7055135],"thread-7045721":["thread",7045721],"thread-7021673":["thread",7021673],"thread-7010233":["thread",7010233],"thread-7007814":["thread",7007814],"thread-7004578":["thread",7004578],"thread-7000937":["thread",7000937],"thread-216851":["thread",216851],"thread-216816":["thread",216816]}, NULL, 1714537708
Run Time: 0.001014
- 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 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20