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 (182608, 180487, 177436, 177104, 176154, 174428, 173742, 170981, 168613, 168587, 167276, 165006, 164719, 163033, 162976, 162417, 162415, 161053, 160489, 159946, 159933, 159104, 157958, 153597, 152432, 151836, 151723, 151101, 148463, 143054, 140163, 132442, 132136, 132087, 132029, 131534, 129401, 129212, 129028, 128972, 128939, 128216, 127419, 127394, 125312, 125280, 125277, 122885, 121208, 121156, 121056, 121035, 120581, 119217, 118936, 118407, 118338, 116556, 114922, 114638, 114104, 106635, 106604, 105767, 105560, 105048, 100742, 99380, 99325, 99322, 98642, 97991, 92456, 84036, 80298, 72916, 69007, 60586, 59190, 50908, 50833, 50622, 48682, 46148, 24423, 23137, 21907, 11664, 4705, 3496, 2962, 1422, 1421, 1135, 1128, 866))
Run Time: 0.065353
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 96 | 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: 272, 0, 1715005666, {"thread-182608":["thread",182608],"thread-180487":["thread",180487],"thread-177436":["thread",177436],"thread-177104":["thread",177104],"thread-176154":["thread",176154],"thread-174428":["thread",174428],"thread-173742":["thread",173742],"thread-170981":["thread",170981],"thread-168613":["thread",168613],"thread-168587":["thread",168587],"thread-167276":["thread",167276],"thread-165006":["thread",165006],"thread-164719":["thread",164719],"thread-163033":["thread",163033],"thread-162976":["thread",162976],"thread-162417":["thread",162417],"thread-162415":["thread",162415],"thread-161053":["thread",161053],"thread-160489":["thread",160489],"thread-159933":["thread",159933],"thread-159104":["thread",159104],"thread-157958":["thread",157958],"thread-153597":["thread",153597],"thread-152432":["thread",152432],"thread-151836":["thread",151836],"thread-151723":["thread",151723],"thread-151101":["thread",151101],"thread-148463":["thread",148463],"thread-143054":["thread",143054],"thread-140163":["thread",140163],"thread-132442":["thread",132442],"thread-132136":["thread",132136],"thread-132087":["thread",132087],"thread-132029":["thread",132029],"thread-131534":["thread",131534],"thread-129401":["thread",129401],"thread-129212":["thread",129212],"thread-129028":["thread",129028],"thread-128972":["thread",128972],"thread-128939":["thread",128939],"thread-128216":["thread",128216],"thread-127419":["thread",127419],"thread-127394":["thread",127394],"thread-125312":["thread",125312],"thread-125280":["thread",125280],"thread-125277":["thread",125277],"thread-122885":["thread",122885],"thread-121208":["thread",121208],"thread-121156":["thread",121156],"thread-121056":["thread",121056],"thread-121035":["thread",121035],"thread-120581":["thread",120581],"thread-119217":["thread",119217],"thread-118936":["thread",118936],"thread-118407":["thread",118407],"thread-118338":["thread",118338],"thread-116556":["thread",116556],"thread-114922":["thread",114922],"thread-114638":["thread",114638],"thread-114104":["thread",114104],"thread-106635":["thread",106635],"thread-106604":["thread",106604],"thread-105767":["thread",105767],"thread-105560":["thread",105560],"thread-105048":["thread",105048],"thread-100742":["thread",100742],"thread-99380":["thread",99380],"thread-99325":["thread",99325],"thread-99322":["thread",99322],"thread-98642":["thread",98642],"thread-97991":["thread",97991],"thread-92456":["thread",92456],"thread-84036":["thread",84036],"thread-80298":["thread",80298],"thread-72916":["thread",72916],"thread-69007":["thread",69007],"thread-60586":["thread",60586],"thread-59190":["thread",59190],"thread-50908":["thread",50908],"thread-50833":["thread",50833],"thread-50622":["thread",50622],"thread-48682":["thread",48682],"thread-46148":["thread",46148],"thread-24423":["thread",24423],"thread-23137":["thread",23137],"thread-21907":["thread",21907],"thread-11664":["thread",11664],"thread-4705":["thread",4705],"thread-3496":["thread",3496],"thread-2962":["thread",2962],"thread-1422":["thread",1422],"thread-1421":["thread",1421],"thread-1135":["thread",1135],"thread-1128":["thread",1128],"thread-866":["thread",866]}, , 1715002066
Run Time: 0.000275
- 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