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 (183319, 183172, 182631, 182584, 182525, 182255, 181948, 181212, 180896, 180680, 180191, 179869, 179750, 178672, 177920, 177298, 176942, 176268, 176104, 175867, 175249, 174887, 174194, 174093, 174060, 173643, 173612, 173586, 173254, 172559, 172027, 172005, 171573, 171019, 170002, 168887, 168275, 167650, 167307, 166623, 166363, 165749, 165320, 164679, 163577, 163494, 162893, 162658, 161804, 161774, 160518, 158125, 157960, 157739, 157696, 156804, 154046, 153635, 153473, 153135, 151824, 131933, 130433, 107239, 101582, 96688, 94439, 94203, 94196, 91544, 90032, 81427, 80726, 65421, 63245, 61600, 60499, 54985, 43403, 36056, 33754, 32659, 8786, 2579))
Run Time: 0.039450
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 84 | 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: 668, 0, 1715805869, {"thread-183319":["thread",183319],"thread-183172":["thread",183172],"thread-182631":["thread",182631],"thread-182584":["thread",182584],"thread-182525":["thread",182525],"thread-182255":["thread",182255],"ams_article-5313":["ams_article",5313],"thread-181948":["thread",181948],"thread-181212":["thread",181212],"thread-180896":["thread",180896],"thread-180680":["thread",180680],"thread-180191":["thread",180191],"thread-179869":["thread",179869],"thread-179750":["thread",179750],"thread-178672":["thread",178672],"thread-177920":["thread",177920],"thread-177298":["thread",177298],"thread-176942":["thread",176942],"thread-176268":["thread",176268],"thread-176104":["thread",176104],"thread-175867":["thread",175867],"thread-175249":["thread",175249],"thread-174887":["thread",174887],"thread-174194":["thread",174194],"thread-174093":["thread",174093],"thread-174060":["thread",174060],"thread-173643":["thread",173643],"thread-173612":["thread",173612],"thread-173586":["thread",173586],"thread-173254":["thread",173254],"thread-172559":["thread",172559],"thread-172027":["thread",172027],"thread-172005":["thread",172005],"thread-171573":["thread",171573],"thread-171019":["thread",171019],"thread-170002":["thread",170002],"thread-168887":["thread",168887],"thread-168275":["thread",168275],"thread-167650":["thread",167650],"thread-167307":["thread",167307],"thread-166623":["thread",166623],"thread-166363":["thread",166363],"thread-165749":["thread",165749],"thread-165320":["thread",165320],"thread-164679":["thread",164679],"thread-163577":["thread",163577],"thread-163494":["thread",163494],"thread-162893":["thread",162893],"thread-162658":["thread",162658],"thread-161804":["thread",161804],"thread-161774":["thread",161774],"thread-160518":["thread",160518],"thread-158125":["thread",158125],"thread-157960":["thread",157960],"thread-157739":["thread",157739],"thread-157696":["thread",157696],"thread-156804":["thread",156804],"thread-154046":["thread",154046],"thread-153635":["thread",153635],"thread-153473":["thread",153473],"thread-153135":["thread",153135],"thread-131933":["thread",131933],"thread-130433":["thread",130433],"thread-107239":["thread",107239],"thread-101582":["thread",101582],"thread-96688":["thread",96688],"thread-94439":["thread",94439],"thread-94203":["thread",94203],"thread-94196":["thread",94196],"thread-91544":["thread",91544],"thread-90032":["thread",90032],"thread-81427":["thread",81427],"thread-80726":["thread",80726],"thread-65421":["thread",65421],"thread-63245":["thread",63245],"thread-61600":["thread",61600],"thread-60499":["thread",60499],"thread-54985":["thread",54985],"thread-43403":["thread",43403],"thread-36056":["thread",36056],"thread-33754":["thread",33754],"thread-32659":["thread",32659],"thread-8786":["thread",8786],"thread-2579":["thread",2579]}, , 1715802269
Run Time: 0.000185
- 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