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 (183008, 182969, 182936, 182289, 181821, 181662, 181492, 181490, 181470, 181388, 181336, 181318, 181276, 181251, 181201, 175970, 174420, 172471, 172393, 172272, 163606, 162401, 162186, 161559, 161558, 161557, 161556, 161555, 161554, 159384, 159375, 159364, 159306, 159305, 158900, 158844, 158840, 158623, 158168, 157968, 157686, 157499, 157252, 157163, 157118, 157098, 156907, 156886, 156823, 156763, 156557, 156452, 156359, 156357, 156326, 156152, 156018, 155983, 155870, 155658, 155654, 155652, 155580, 155534, 155490, 155447, 155402, 155297, 155221, 155183, 155112, 155028, 154986, 154954, 154853, 154536, 154339, 154094, 153825, 153821, 153820, 153643, 152903, 152859, 152775, 152632, 152531, 151606, 146267, 145934, 145911, 145346, 145175, 144998, 144943, 144564, 144560, 144449, 144360, 144123, 144079, 143970, 143378, 143340, 143073, 143011, 142719, 142468, 142415, 142203, 142126, 141992, 141870, 141817, 141773, 141675, 141518, 140343, 140338, 140331, 140299, 140286, 140281, 140246, 140120, 139798, 139754, 139750, 139745, 139743, 139738, 139731, 139709, 139703, 139683, 139681, 139650, 139643, 139584, 139498, 139420, 139414, 139384, 139212, 139129, 139036, 138993, 138983, 138978, 138934, 138922, 138867, 138823, 138756, 138755, 138722, 138605, 138585, 138507, 138251, 138243, 138238, 138234, 138221, 138164, 138158, 138102, 138085, 138027, 137973, 137825, 137768, 137669, 137602, 137463, 137081, 136994, 136958, 136929, 136634, 136393, 136392, 136127, 136071, 136055, 135937, 135186))
Run Time: 0.141331
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 187 | 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: 34938, 0, 1717161435, {"thread-183008":["thread",183008],"thread-182969":["thread",182969],"thread-182936":["thread",182936],"thread-182289":["thread",182289],"ams_article-5292":["ams_article",5292],"thread-181821":["thread",181821],"thread-181662":["thread",181662],"thread-181492":["thread",181492],"thread-181490":["thread",181490],"thread-181470":["thread",181470],"thread-181388":["thread",181388],"thread-181336":["thread",181336],"thread-181318":["thread",181318],"thread-181276":["thread",181276],"thread-181251":["thread",181251],"thread-181201":["thread",181201],"thread-175970":["thread",175970],"thread-174420":["thread",174420],"thread-172471":["thread",172471],"thread-172393":["thread",172393],"thread-172272":["thread",172272],"ams_article-4902":["ams_article",4902],"thread-163606":["thread",163606],"thread-162401":["thread",162401],"thread-162186":["thread",162186],"thread-161559":["thread",161559],"thread-161558":["thread",161558],"thread-161557":["thread",161557],"thread-161556":["thread",161556],"thread-161555":["thread",161555],"thread-161554":["thread",161554],"thread-159384":["thread",159384],"thread-159375":["thread",159375],"thread-159364":["thread",159364],"thread-159306":["thread",159306],"thread-159305":["thread",159305],"thread-158900":["thread",158900],"thread-158844":["thread",158844],"thread-158840":["thread",158840],"thread-158623":["thread",158623],"thread-158168":["thread",158168],"thread-157968":["thread",157968],"thread-157686":["thread",157686],"thread-157499":["thread",157499],"thread-157252":["thread",157252],"thread-157163":["thread",157163],"thread-157118":["thread",157118],"thread-157098":["thread",157098],"thread-156907":["thread",156907],"thread-156886":["thread",156886],"thread-156823":["thread",156823],"thread-156763":["thread",156763],"thread-156557":["thread",156557],"thread-156452":["thread",156452],"thread-156359":["thread",156359],"thread-156357":["thread",156357],"thread-156326":["thread",156326],"thread-156152":["thread",156152],"thread-156018":["thread",156018],"thread-155983":["thread",155983],"thread-155870":["thread",155870],"thread-155658":["thread",155658],"thread-155654":["thread",155654],"thread-155652":["thread",155652],"thread-155580":["thread",155580],"thread-155534":["thread",155534],"thread-155490":["thread",155490],"thread-155447":["thread",155447],"thread-155402":["thread",155402],"thread-155297":["thread",155297],"thread-155221":["thread",155221],"thread-155183":["thread",155183],"thread-155112":["thread",155112],"thread-155028":["thread",155028],"thread-154986":["thread",154986],"thread-154954":["thread",154954],"thread-154853":["thread",154853],"thread-154536":["thread",154536],"thread-154339":["thread",154339],"thread-154094":["thread",154094],"thread-153825":["thread",153825],"thread-153821":["thread",153821],"thread-153820":["thread",153820],"thread-153643":["thread",153643],"thread-152903":["thread",152903],"thread-152859":["thread",152859],"thread-152775":["thread",152775],"thread-152632":["thread",152632],"thread-152531":["thread",152531],"thread-151606":["thread",151606],"thread-146267":["thread",146267],"thread-145934":["thread",145934],"thread-145911":["thread",145911],"thread-145346":["thread",145346],"thread-145175":["thread",145175],"thread-144998":["thread",144998],"thread-144943":["thread",144943],"thread-144564":["thread",144564],"thread-144560":["thread",144560],"thread-144449":["thread",144449],"thread-144360":["thread",144360],"thread-144123":["thread",144123],"thread-144079":["thread",144079],"thread-143970":["thread",143970],"thread-143378":["thread",143378],"thread-143340":["thread",143340],"thread-143073":["thread",143073],"thread-143011":["thread",143011],"thread-142719":["thread",142719],"thread-142468":["thread",142468],"thread-142415":["thread",142415],"thread-142203":["thread",142203],"thread-142126":["thread",142126],"thread-141992":["thread",141992],"thread-141870":["thread",141870],"thread-141817":["thread",141817],"thread-141773":["thread",141773],"thread-141675":["thread",141675],"thread-141518":["thread",141518],"thread-140343":["thread",140343],"thread-140338":["thread",140338],"thread-140331":["thread",140331],"thread-140299":["thread",140299],"thread-140286":["thread",140286],"thread-140281":["thread",140281],"thread-140246":["thread",140246],"thread-140120":["thread",140120],"thread-139798":["thread",139798],"thread-139754":["thread",139754],"thread-139750":["thread",139750],"thread-139745":["thread",139745],"thread-139743":["thread",139743],"thread-139738":["thread",139738],"thread-139731":["thread",139731],"thread-139709":["thread",139709],"thread-139703":["thread",139703],"thread-139683":["thread",139683],"thread-139681":["thread",139681],"thread-139650":["thread",139650],"thread-139643":["thread",139643],"thread-139584":["thread",139584],"thread-139498":["thread",139498],"thread-139420":["thread",139420],"thread-139414":["thread",139414],"thread-139384":["thread",139384],"thread-139212":["thread",139212],"thread-139129":["thread",139129],"thread-139036":["thread",139036],"thread-138993":["thread",138993],"thread-138983":["thread",138983],"thread-138978":["thread",138978],"thread-138934":["thread",138934],"thread-138922":["thread",138922],"thread-138867":["thread",138867],"thread-138823":["thread",138823],"thread-138756":["thread",138756],"thread-138755":["thread",138755],"thread-138722":["thread",138722],"thread-138605":["thread",138605],"thread-138585":["thread",138585],"thread-138507":["thread",138507],"thread-138251":["thread",138251],"thread-138243":["thread",138243],"thread-138238":["thread",138238],"thread-138234":["thread",138234],"thread-138221":["thread",138221],"thread-138164":["thread",138164],"thread-138158":["thread",138158],"thread-138102":["thread",138102],"thread-138085":["thread",138085],"thread-138027":["thread",138027],"thread-137973":["thread",137973],"thread-137825":["thread",137825],"thread-137768":["thread",137768],"thread-137669":["thread",137669],"thread-137602":["thread",137602],"thread-137463":["thread",137463],"thread-137081":["thread",137081],"thread-136994":["thread",136994],"thread-136958":["thread",136958],"thread-136929":["thread",136929],"thread-136634":["thread",136634],"thread-136393":["thread",136393],"thread-136392":["thread",136392],"thread-136127":["thread",136127],"thread-136071":["thread",136071],"thread-136055":["thread",136055],"thread-135937":["thread",135937],"thread-135186":["thread",135186]}, , 1717157835
Run Time: 0.000240
- 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