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 (107461, 106391, 105700, 105414, 105250, 104812, 104750, 104567, 103184, 100924, 100722, 99910, 99605, 99103, 98929, 97956, 97784, 97703, 97342, 97155, 97096, 96907, 95526, 95210, 94102, 93726, 93187, 92896, 92196, 92144, 91113, 90815, 90359, 89884, 89696, 89621, 89511, 89137, 88559, 88503, 88416, 87928, 87754, 87538, 87322, 87288, 87211, 86924, 86918, 86905, 85513, 84255, 82925, 82778, 81722, 81102, 81094, 80903, 80370, 79759, 79119, 76628, 76435, 76424, 76276, 75410, 75013, 74571, 74440, 74093, 73921, 73843, 73644, 73207, 72925, 72760, 72741, 72651, 72585, 72248, 71937, 71661, 71351, 71132, 70885, 70747, 70588, 69790, 69284, 69225, 69031, 68603, 68438, 68179, 67897, 66793, 66786, 66753, 66463, 65892, 65803, 65103, 64686, 64597, 64309))
Run Time: 0.008440
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 105 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | terrylove_forums.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,terrylove_forums.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: 57, 0, 1714973852, {"thread-107461":["thread",107461],"thread-106391":["thread",106391],"thread-105700":["thread",105700],"thread-105414":["thread",105414],"thread-105250":["thread",105250],"thread-104812":["thread",104812],"thread-104750":["thread",104750],"thread-104567":["thread",104567],"thread-103184":["thread",103184],"thread-100924":["thread",100924],"thread-100722":["thread",100722],"thread-99910":["thread",99910],"thread-99605":["thread",99605],"thread-99103":["thread",99103],"thread-98929":["thread",98929],"thread-97956":["thread",97956],"thread-97784":["thread",97784],"thread-97703":["thread",97703],"thread-97342":["thread",97342],"thread-97155":["thread",97155],"thread-97096":["thread",97096],"thread-96907":["thread",96907],"thread-95526":["thread",95526],"thread-95210":["thread",95210],"thread-94102":["thread",94102],"thread-93726":["thread",93726],"thread-93187":["thread",93187],"thread-92896":["thread",92896],"thread-92196":["thread",92196],"thread-92144":["thread",92144],"thread-91113":["thread",91113],"thread-90815":["thread",90815],"thread-90359":["thread",90359],"thread-89884":["thread",89884],"thread-89696":["thread",89696],"thread-89621":["thread",89621],"thread-89511":["thread",89511],"thread-89137":["thread",89137],"thread-88559":["thread",88559],"thread-88503":["thread",88503],"thread-88416":["thread",88416],"thread-87928":["thread",87928],"thread-87754":["thread",87754],"thread-87538":["thread",87538],"thread-87322":["thread",87322],"thread-87288":["thread",87288],"thread-87211":["thread",87211],"thread-86924":["thread",86924],"thread-86918":["thread",86918],"thread-86905":["thread",86905],"thread-85513":["thread",85513],"thread-84255":["thread",84255],"thread-82925":["thread",82925],"thread-82778":["thread",82778],"thread-81722":["thread",81722],"thread-81102":["thread",81102],"thread-81094":["thread",81094],"thread-80903":["thread",80903],"thread-80370":["thread",80370],"thread-79759":["thread",79759],"thread-79119":["thread",79119],"thread-76628":["thread",76628],"thread-76435":["thread",76435],"thread-76424":["thread",76424],"thread-76276":["thread",76276],"thread-75410":["thread",75410],"thread-75013":["thread",75013],"thread-74571":["thread",74571],"thread-74440":["thread",74440],"thread-74093":["thread",74093],"thread-73921":["thread",73921],"thread-73843":["thread",73843],"thread-73644":["thread",73644],"thread-73207":["thread",73207],"thread-72925":["thread",72925],"thread-72760":["thread",72760],"thread-72741":["thread",72741],"thread-72651":["thread",72651],"thread-72585":["thread",72585],"thread-72248":["thread",72248],"thread-71937":["thread",71937],"thread-71661":["thread",71661],"thread-71351":["thread",71351],"thread-71132":["thread",71132],"thread-70885":["thread",70885],"thread-70747":["thread",70747],"thread-70588":["thread",70588],"thread-69790":["thread",69790],"thread-69284":["thread",69284],"thread-69225":["thread",69225],"thread-69031":["thread",69031],"thread-68603":["thread",68603],"thread-68438":["thread",68438],"thread-68179":["thread",68179],"thread-67897":["thread",67897],"thread-66793":["thread",66793],"thread-66786":["thread",66786],"thread-66753":["thread",66753],"thread-66463":["thread",66463],"thread-65892":["thread",65892],"thread-65803":["thread",65803],"thread-65103":["thread",65103],"thread-64686":["thread",64686],"thread-64597":["thread",64597],"thread-64309":["thread",64309]}, NULL, 1714970252
Run Time: 0.000248
- 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