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 (179920, 177554, 177506, 176168, 175470, 173391, 173294, 169178, 168137, 166726, 163170, 161815, 158256, 156047, 155255, 155250, 154047, 153378, 153012, 152969, 152383, 132045, 130911, 121961, 111297, 103196, 100723, 100423, 99200, 94291, 91369, 91359, 91284, 88663, 84628, 83971, 81843, 80487, 79513, 79234, 78249, 77665, 75190, 74995, 74921, 73617, 69903, 68640, 68171, 67686, 63451, 57049, 55483, 53893, 49877, 47702, 45223, 30177, 18399, 18331, 15217, 11918))
Run Time: 0.029026
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 62 | 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: 1872, 0, 1714288894, {"thread-179920":["thread",179920],"thread-177554":["thread",177554],"thread-177506":["thread",177506],"thread-176168":["thread",176168],"thread-175470":["thread",175470],"thread-173391":["thread",173391],"thread-173294":["thread",173294],"thread-169178":["thread",169178],"thread-168137":["thread",168137],"thread-166726":["thread",166726],"thread-163170":["thread",163170],"thread-161815":["thread",161815],"thread-158256":["thread",158256],"thread-156047":["thread",156047],"thread-155255":["thread",155255],"thread-155250":["thread",155250],"thread-154047":["thread",154047],"thread-153378":["thread",153378],"thread-153012":["thread",153012],"thread-152969":["thread",152969],"thread-152383":["thread",152383],"thread-132045":["thread",132045],"thread-130911":["thread",130911],"thread-121961":["thread",121961],"thread-111297":["thread",111297],"thread-103196":["thread",103196],"thread-100723":["thread",100723],"thread-100423":["thread",100423],"thread-99200":["thread",99200],"thread-94291":["thread",94291],"thread-91369":["thread",91369],"thread-91359":["thread",91359],"thread-91284":["thread",91284],"thread-88663":["thread",88663],"thread-84628":["thread",84628],"thread-83971":["thread",83971],"thread-81843":["thread",81843],"thread-80487":["thread",80487],"thread-79513":["thread",79513],"thread-79234":["thread",79234],"thread-78249":["thread",78249],"thread-77665":["thread",77665],"thread-75190":["thread",75190],"thread-74995":["thread",74995],"thread-74921":["thread",74921],"thread-73617":["thread",73617],"thread-69903":["thread",69903],"thread-68640":["thread",68640],"thread-68171":["thread",68171],"thread-67686":["thread",67686],"thread-63451":["thread",63451],"thread-57049":["thread",57049],"thread-55483":["thread",55483],"thread-53893":["thread",53893],"thread-49877":["thread",49877],"thread-47702":["thread",47702],"thread-45223":["thread",45223],"thread-30177":["thread",30177],"thread-18399":["thread",18399],"thread-18331":["thread",18331],"thread-15217":["thread",15217],"thread-11918":["thread",11918]}, , 1714285294
Run Time: 0.000263
- 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