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 (181781, 181645, 181389, 181269, 179645, 179572, 179533, 179393, 179348, 177571, 176993, 176414, 176174, 176012, 175828, 175813, 175280, 175136, 175005, 174555, 174151, 174038, 173743, 173529, 173440, 173229, 172928, 172710, 171978, 171260, 171123, 171071, 170585, 170457, 170184, 167084, 166107, 165983, 165494, 165328, 164339, 164236, 164064, 163791, 162418, 161332, 160783, 160460, 159663, 159570, 158534, 158525, 158130, 157773, 157352, 156102, 155515, 155307, 154315, 153982, 153885, 153293, 153269, 153207, 152257, 151938, 151846, 151790, 139885, 116872, 114069, 112589, 111158, 106359, 99519, 88907, 85903, 85228, 82196, 81755, 76658, 74029, 66000, 65935, 65124, 63097, 57734, 57733, 56034, 49693, 49643, 42499, 39756))
Run Time: 0.032523
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 93 | 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: 5797, 0, 1716128147, {"thread-181781":["thread",181781],"thread-181645":["thread",181645],"thread-181389":["thread",181389],"thread-181269":["thread",181269],"thread-179645":["thread",179645],"thread-179572":["thread",179572],"thread-179533":["thread",179533],"thread-179393":["thread",179393],"thread-179348":["thread",179348],"thread-177571":["thread",177571],"thread-176993":["thread",176993],"thread-176414":["thread",176414],"thread-176174":["thread",176174],"thread-176012":["thread",176012],"thread-175828":["thread",175828],"thread-175813":["thread",175813],"thread-175280":["thread",175280],"thread-175136":["thread",175136],"thread-175005":["thread",175005],"thread-174555":["thread",174555],"thread-174151":["thread",174151],"thread-174038":["thread",174038],"thread-173743":["thread",173743],"thread-173529":["thread",173529],"thread-173440":["thread",173440],"thread-173229":["thread",173229],"thread-172928":["thread",172928],"thread-172710":["thread",172710],"thread-171978":["thread",171978],"thread-171260":["thread",171260],"thread-171123":["thread",171123],"thread-171071":["thread",171071],"thread-170585":["thread",170585],"thread-170457":["thread",170457],"thread-170184":["thread",170184],"thread-167084":["thread",167084],"thread-166107":["thread",166107],"thread-165983":["thread",165983],"thread-165494":["thread",165494],"thread-165328":["thread",165328],"thread-164339":["thread",164339],"thread-164236":["thread",164236],"thread-164064":["thread",164064],"thread-163791":["thread",163791],"thread-162418":["thread",162418],"thread-161332":["thread",161332],"thread-160783":["thread",160783],"thread-160460":["thread",160460],"thread-159663":["thread",159663],"thread-159570":["thread",159570],"thread-158534":["thread",158534],"thread-158525":["thread",158525],"thread-158130":["thread",158130],"thread-157773":["thread",157773],"thread-157352":["thread",157352],"thread-156102":["thread",156102],"thread-155515":["thread",155515],"thread-155307":["thread",155307],"thread-154315":["thread",154315],"thread-153982":["thread",153982],"thread-153885":["thread",153885],"thread-153293":["thread",153293],"thread-153269":["thread",153269],"thread-153207":["thread",153207],"thread-152257":["thread",152257],"thread-151938":["thread",151938],"thread-151846":["thread",151846],"thread-151790":["thread",151790],"thread-139885":["thread",139885],"thread-116872":["thread",116872],"thread-114069":["thread",114069],"thread-112589":["thread",112589],"thread-111158":["thread",111158],"thread-106359":["thread",106359],"thread-99519":["thread",99519],"thread-88907":["thread",88907],"thread-85903":["thread",85903],"thread-85228":["thread",85228],"thread-82196":["thread",82196],"thread-81755":["thread",81755],"thread-76658":["thread",76658],"thread-74029":["thread",74029],"thread-66000":["thread",66000],"thread-65935":["thread",65935],"thread-65124":["thread",65124],"thread-63097":["thread",63097],"thread-57734":["thread",57734],"thread-57733":["thread",57733],"thread-56034":["thread",56034],"thread-49693":["thread",49693],"thread-49643":["thread",49643],"thread-42499":["thread",42499],"thread-39756":["thread",39756]}, , 1716124547
Run Time: 0.000467
- 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