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 (177012, 176652, 176648, 176624, 176622, 176459, 176405, 176354, 176346, 176344, 176321, 176301, 176296, 176294, 176291, 176284, 174392, 167088, 163683, 160098, 157037, 154928, 154380, 154290, 154252, 154100, 154062, 154014, 153937, 153856, 153848, 153646, 153470, 153458, 153410, 153382, 153333, 153158, 153136, 152885, 152830, 152620, 152323, 152024, 152017, 152013, 151979, 151973, 151948, 151911, 151891, 151857, 151737, 151389, 151034, 150907, 150881, 150871, 150869, 150868, 150867, 150848, 150741, 150697, 150668, 150666, 150665, 150602, 150600, 150527, 150462, 150422, 150199, 150107, 150024, 149786, 149502, 149468, 149461, 148589, 148453, 148382, 148121, 147886, 147883, 147881, 147780, 147759, 147472, 147136, 147125, 147065, 146969, 146734, 146714, 146654, 146509, 146436, 146396, 146081, 145939, 145800, 145799, 145794, 145696, 145620, 145312, 145263, 145234, 145217, 145145, 145102, 145045, 144953, 144789, 144747, 144728, 144661, 144576, 144320, 143862, 143814, 143812, 143591, 143486, 143459, 143063, 142968, 142856, 142809, 142744, 142710, 142699, 142660, 142623, 142144, 142033, 141875, 141660, 141561, 141471, 141470))
Run Time: 0.091205
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 142 | 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: 8632, 0, 1714883850, {"thread-177012":["thread",177012],"thread-176652":["thread",176652],"thread-176648":["thread",176648],"thread-176624":["thread",176624],"thread-176622":["thread",176622],"thread-176459":["thread",176459],"thread-176405":["thread",176405],"thread-176354":["thread",176354],"thread-176346":["thread",176346],"thread-176344":["thread",176344],"thread-176321":["thread",176321],"thread-176301":["thread",176301],"thread-176296":["thread",176296],"thread-176294":["thread",176294],"thread-176291":["thread",176291],"tl_group-320":["tl_group",320],"thread-176284":["thread",176284],"thread-174392":["thread",174392],"tl_group-287":["tl_group",287],"thread-167088":["thread",167088],"thread-163683":["thread",163683],"ams_article-4451":["ams_article",4451],"thread-160098":["thread",160098],"thread-157037":["thread",157037],"ams_article-4134":["ams_article",4134],"thread-154928":["thread",154928],"ams_article-4121":["ams_article",4121],"thread-154380":["thread",154380],"thread-154290":["thread",154290],"thread-154252":["thread",154252],"thread-154100":["thread",154100],"thread-154062":["thread",154062],"thread-154014":["thread",154014],"thread-153937":["thread",153937],"ams_article-4069":["ams_article",4069],"thread-153856":["thread",153856],"thread-153848":["thread",153848],"thread-153646":["thread",153646],"thread-153470":["thread",153470],"thread-153458":["thread",153458],"thread-153410":["thread",153410],"thread-153382":["thread",153382],"ams_article-4021":["ams_article",4021],"thread-153333":["thread",153333],"thread-153158":["thread",153158],"thread-153136":["thread",153136],"thread-152885":["thread",152885],"thread-152830":["thread",152830],"ams_article-3997":["ams_article",3997],"thread-152620":["thread",152620],"thread-152323":["thread",152323],"ams_article-3946":["ams_article",3946],"thread-152024":["thread",152024],"thread-152017":["thread",152017],"thread-152013":["thread",152013],"thread-151979":["thread",151979],"thread-151973":["thread",151973],"thread-151948":["thread",151948],"thread-151911":["thread",151911],"thread-151891":["thread",151891],"thread-151857":["thread",151857],"thread-151737":["thread",151737],"thread-151389":["thread",151389],"tl_group-6":["tl_group",6],"ams_article-3889":["ams_article",3889],"thread-151034":["thread",151034],"ams_article-3868":["ams_article",3868],"ams_article-3861":["ams_article",3861],"thread-150907":["thread",150907],"thread-150881":["thread",150881],"thread-150871":["thread",150871],"thread-150869":["thread",150869],"thread-150868":["thread",150868],"thread-150867":["thread",150867],"thread-150848":["thread",150848],"ams_article-3850":["ams_article",3850],"thread-150741":["thread",150741],"ams_article-3844":["ams_article",3844],"thread-150697":["thread",150697],"thread-150668":["thread",150668],"thread-150666":["thread",150666],"thread-150665":["thread",150665],"thread-150602":["thread",150602],"thread-150600":["thread",150600],"ams_article-3829":["ams_article",3829],"thread-150527":["thread",150527],"ams_article-3816":["ams_article",3816],"thread-150462":["thread",150462],"ams_article-3812":["ams_article",3812],"thread-150422":["thread",150422],"thread-150199":["thread",150199],"thread-150107":["thread",150107],"thread-150024":["thread",150024],"thread-149786":["thread",149786],"ams_article-3760":["ams_article",3760],"thread-149502":["thread",149502],"thread-149468":["thread",149468],"thread-149461":["thread",149461],"ams_article-3733":["ams_article",3733],"ams_article-3722":["ams_article",3722],"ams_article-3715":["ams_article",3715],"thread-148589":["thread",148589],"thread-148453":["thread",148453],"thread-148382":["thread",148382],"thread-148121":["thread",148121],"thread-147886":["thread",147886],"thread-147883":["thread",147883],"thread-147881":["thread",147881],"thread-147780":["thread",147780],"thread-147759":["thread",147759],"thread-147472":["thread",147472],"ams_article-3581":["ams_article",3581],"thread-147136":["thread",147136],"thread-147125":["thread",147125],"thread-147065":["thread",147065],"ams_article-3572":["ams_article",3572],"thread-146969":["thread",146969],"ams_article-3538":["ams_article",3538],"thread-146734":["thread",146734],"thread-146714":["thread",146714],"thread-146654":["thread",146654],"thread-146509":["thread",146509],"thread-146436":["thread",146436],"ams_article-3517":["ams_article",3517],"thread-146396":["thread",146396],"thread-146081":["thread",146081],"ams_article-3490":["ams_article",3490],"thread-145939":["thread",145939],"ams_article-3465":["ams_article",3465],"thread-145800":["thread",145800],"thread-145799":["thread",145799],"thread-145794":["thread",145794],"thread-145696":["thread",145696],"thread-145620":["thread",145620],"ams_article-3453":["ams_article",3453],"ams_article-3446":["ams_article",3446],"thread-145312":["thread",145312],"thread-145263":["thread",145263],"thread-145234":["thread",145234],"thread-145217":["thread",145217],"thread-145145":["thread",145145],"thread-145102":["thread",145102],"thread-145045":["thread",145045],"thread-144953":["thread",144953],"ams_article-3428":["ams_article",3428],"ams_article-3422":["ams_article",3422],"thread-144789":["thread",144789],"thread-144747":["thread",144747],"thread-144728":["thread",144728],"ams_article-3417":["ams_article",3417],"thread-144661":["thread",144661],"ams_article-3416":["ams_article",3416],"ams_article-3414":["ams_article",3414],"thread-144576":["thread",144576],"ams_article-3406":["ams_article",3406],"thread-144320":["thread",144320],"thread-143862":["thread",143862],"thread-143814":["thread",143814],"thread-143812":["thread",143812],"ams_article-3386":["ams_article",3386],"ams_article-3382":["ams_article",3382],"ams_article-3376":["ams_article",3376],"thread-143591":["thread",143591],"ams_article-3369":["ams_article",3369],"thread-143486":["thread",143486],"thread-143459":["thread",143459],"ams_article-3362":["ams_article",3362],"ams_article-3354":["ams_article",3354],"ams_article-3345":["ams_article",3345],"ams_article-3337":["ams_article",3337],"ams_article-3333":["ams_article",3333],"thread-143063":["thread",143063],"thread-142968":["thread",142968],"ams_article-3318":["ams_article",3318],"thread-142856":["thread",142856],"thread-142809":["thread",142809],"ams_article-3305":["ams_article",3305],"thread-142744":["thread",142744],"thread-142710":["thread",142710],"thread-142699":["thread",142699],"ams_article-3303":["ams_article",3303],"thread-142660":["thread",142660],"thread-142623":["thread",142623],"ams_article-3298":["ams_article",3298],"ams_article-3292":["ams_article",3292],"ams_article-3272":["ams_article",3272],"thread-142144":["thread",142144],"ams_article-3269":["ams_article",3269],"ams_article-3265":["ams_article",3265],"thread-142033":["thread",142033],"thread-141875":["thread",141875],"ams_article-3254":["ams_article",3254],"thread-141660":["thread",141660],"thread-141561":["thread",141561],"ams_article-3241":["ams_article",3241],"thread-141471":["thread",141471],"thread-141470":["thread",141470],"ams_article-3225":["ams_article",3225]}, , 1714880250
Run Time: 0.000904
- 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