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 (183522, 183050, 182752, 182683, 182279, 181800, 181594, 181178, 179114, 178109, 177575, 176449, 175777, 175683, 175414, 174998, 174990, 174426, 174119, 173005, 172694, 171501, 170807, 170311, 169319, 168894, 168701, 168558, 168168, 167491, 167462, 167376, 167176, 165371, 165249, 163955, 163602, 163601, 163427, 163271, 162970, 162519, 161892, 160522, 159056, 158792, 158668, 158145, 158052, 157439, 156705, 156692, 155824, 154236, 153896, 153587, 153134, 152809, 152293, 149263, 149039, 149025, 148905, 138255, 131924, 130891, 127121, 114485, 85688, 75860, 73625, 69555, 62486, 60516, 58556, 57599, 56881, 53604, 51600, 31564))
Run Time: 0.037914
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 80 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 1387
- 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 2729
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 4364, 0, 1716269875, {"thread-183522":["thread",183522],"thread-183050":["thread",183050],"thread-182752":["thread",182752],"thread-182683":["thread",182683],"thread-182279":["thread",182279],"thread-181800":["thread",181800],"thread-181594":["thread",181594],"thread-181178":["thread",181178],"thread-179114":["thread",179114],"thread-178109":["thread",178109],"thread-177575":["thread",177575],"thread-176449":["thread",176449],"thread-175777":["thread",175777],"thread-175683":["thread",175683],"thread-175414":["thread",175414],"thread-174998":["thread",174998],"thread-174990":["thread",174990],"thread-174426":["thread",174426],"thread-174119":["thread",174119],"thread-173005":["thread",173005],"thread-172694":["thread",172694],"thread-171501":["thread",171501],"thread-170807":["thread",170807],"thread-170311":["thread",170311],"thread-169319":["thread",169319],"thread-168894":["thread",168894],"thread-168701":["thread",168701],"thread-168558":["thread",168558],"thread-168168":["thread",168168],"thread-167491":["thread",167491],"thread-167462":["thread",167462],"thread-167376":["thread",167376],"thread-167176":["thread",167176],"ams_article-4731":["ams_article",4731],"thread-165371":["thread",165371],"thread-165249":["thread",165249],"thread-163955":["thread",163955],"thread-163602":["thread",163602],"thread-163601":["thread",163601],"thread-163427":["thread",163427],"thread-163271":["thread",163271],"thread-162970":["thread",162970],"thread-162519":["thread",162519],"thread-161892":["thread",161892],"thread-160522":["thread",160522],"thread-159056":["thread",159056],"thread-158792":["thread",158792],"thread-158668":["thread",158668],"thread-158145":["thread",158145],"thread-158052":["thread",158052],"thread-157439":["thread",157439],"thread-156705":["thread",156705],"thread-156692":["thread",156692],"thread-155824":["thread",155824],"ams_article-4145":["ams_article",4145],"thread-154236":["thread",154236],"thread-153896":["thread",153896],"thread-153587":["thread",153587],"thread-153134":["thread",153134],"thread-152809":["thread",152809],"thread-152293":["thread",152293],"ams_article-3855":["ams_article",3855],"ams_article-3854":["ams_article",3854],"thread-149263":["thread",149263],"ams_article-3716":["ams_article",3716],"thread-149039":["thread",149039],"thread-149025":["thread",149025],"thread-148905":["thread",148905],"ams_article-3669":["ams_article",3669],"thread-138255":["thread",138255],"thread-131924":["thread",131924],"thread-130891":["thread",130891],"thread-127121":["thread",127121],"thread-114485":["thread",114485],"thread-85688":["thread",85688],"thread-75860":["thread",75860],"thread-73625":["thread",73625],"thread-69555":["thread",69555],"thread-62486":["thread",62486],"thread-60516":["thread",60516],"thread-58556":["thread",58556],"thread-57599":["thread",57599],"thread-56881":["thread",56881],"thread-53604":["thread",53604],"thread-51600":["thread",51600],"thread-31564":["thread",31564]}, , 1716266275
Run Time: 0.001049
- 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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20