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 (182930, 182928, 182755, 182697, 182494, 182178, 182121, 181606, 181605, 181604, 181603, 181363, 181219, 180352, 180341, 180258, 178205, 177203, 177100, 176955, 176645, 175623, 175059, 174522, 174195, 174186, 174073, 174048, 173878, 173819, 173108, 171810, 171557, 170527, 170081, 167195, 167194, 167193, 167141, 167139, 167138, 167137, 167136, 167135, 167134, 166839, 166288, 164677, 164582, 164578, 164544, 164228, 164041, 163501, 163067, 163020, 163014, 162012, 161094, 160945, 160941, 160168, 159118, 159051, 158320, 157402, 157174, 156723, 155066, 155065, 155064, 155063, 155061, 155017, 154557, 154064, 153673, 153607, 153541, 152139, 152127, 148249, 131123, 130986, 130479, 130003, 128973, 127417, 127293, 126169, 124534, 123694, 121577, 120860, 117609, 113443, 113373, 113280, 113176, 113044, 112042, 106409, 103432, 97833, 90754, 71654, 59619, 50877, 50866, 39195, 29741, 26972, 24765))
Run Time: 0.054418
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 113 | 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: 3234, 0, 1716097242, {"thread-182930":["thread",182930],"thread-182928":["thread",182928],"thread-182755":["thread",182755],"thread-182697":["thread",182697],"thread-182494":["thread",182494],"thread-182178":["thread",182178],"thread-182121":["thread",182121],"thread-181606":["thread",181606],"thread-181605":["thread",181605],"thread-181604":["thread",181604],"thread-181603":["thread",181603],"thread-181363":["thread",181363],"thread-181219":["thread",181219],"thread-180352":["thread",180352],"thread-180341":["thread",180341],"thread-180258":["thread",180258],"thread-178205":["thread",178205],"thread-177203":["thread",177203],"thread-177100":["thread",177100],"thread-176955":["thread",176955],"thread-176645":["thread",176645],"thread-175623":["thread",175623],"thread-175059":["thread",175059],"thread-174522":["thread",174522],"thread-174195":["thread",174195],"thread-174186":["thread",174186],"thread-174073":["thread",174073],"thread-174048":["thread",174048],"thread-173878":["thread",173878],"thread-173819":["thread",173819],"thread-173108":["thread",173108],"thread-171810":["thread",171810],"thread-171557":["thread",171557],"thread-170527":["thread",170527],"thread-170081":["thread",170081],"thread-167195":["thread",167195],"thread-167194":["thread",167194],"thread-167193":["thread",167193],"thread-167141":["thread",167141],"thread-167139":["thread",167139],"thread-167138":["thread",167138],"thread-167137":["thread",167137],"thread-167136":["thread",167136],"thread-167135":["thread",167135],"thread-167134":["thread",167134],"thread-166839":["thread",166839],"thread-166288":["thread",166288],"thread-164677":["thread",164677],"thread-164582":["thread",164582],"thread-164578":["thread",164578],"thread-164544":["thread",164544],"thread-164228":["thread",164228],"thread-164041":["thread",164041],"thread-163501":["thread",163501],"thread-163067":["thread",163067],"thread-163020":["thread",163020],"thread-163014":["thread",163014],"thread-162012":["thread",162012],"thread-161094":["thread",161094],"thread-160945":["thread",160945],"thread-160941":["thread",160941],"thread-160168":["thread",160168],"thread-159118":["thread",159118],"thread-159051":["thread",159051],"thread-158320":["thread",158320],"thread-157402":["thread",157402],"thread-157174":["thread",157174],"thread-156723":["thread",156723],"thread-155066":["thread",155066],"thread-155065":["thread",155065],"thread-155064":["thread",155064],"thread-155063":["thread",155063],"thread-155061":["thread",155061],"thread-155017":["thread",155017],"thread-154557":["thread",154557],"thread-154064":["thread",154064],"thread-153673":["thread",153673],"thread-153607":["thread",153607],"thread-153541":["thread",153541],"thread-152139":["thread",152139],"thread-152127":["thread",152127],"thread-148249":["thread",148249],"thread-131123":["thread",131123],"thread-130986":["thread",130986],"thread-130479":["thread",130479],"thread-130003":["thread",130003],"thread-128973":["thread",128973],"thread-127417":["thread",127417],"thread-127293":["thread",127293],"thread-126169":["thread",126169],"thread-124534":["thread",124534],"thread-123694":["thread",123694],"thread-121577":["thread",121577],"thread-120860":["thread",120860],"thread-117609":["thread",117609],"thread-113443":["thread",113443],"thread-113373":["thread",113373],"thread-113280":["thread",113280],"thread-113176":["thread",113176],"thread-113044":["thread",113044],"thread-112042":["thread",112042],"thread-106409":["thread",106409],"thread-103432":["thread",103432],"thread-97833":["thread",97833],"thread-90754":["thread",90754],"thread-71654":["thread",71654],"thread-59619":["thread",59619],"thread-50877":["thread",50877],"thread-50866":["thread",50866],"thread-39195":["thread",39195],"thread-29741":["thread",29741],"thread-26972":["thread",26972],"thread-24765":["thread",24765]}, , 1716093642
Run Time: 0.000369
- 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