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 (183017, 182688, 182620, 182589, 182364, 182072, 180367, 179284, 179025, 179000, 178940, 178889, 178758, 178563, 178501, 177904, 177496, 176952, 176849, 176535, 176327, 176307, 176077, 175827, 175464, 175290, 173723, 173158, 172268, 170803, 170148, 169495, 169199, 169112, 167192, 167187, 167026, 167015, 166802, 166210, 165481, 165184, 164427, 164261, 164210, 163743, 163369, 163004, 162254, 161335, 161250, 161201, 161132, 159992, 159981, 159922, 159781, 159768, 159766, 159718, 159709, 159708, 159143, 159104, 158247, 157888, 157879, 157868, 157804, 157634, 157594, 157484, 157214, 156924, 155968, 155868, 155854, 155853, 155851, 155742, 155740, 155738, 155737, 155544, 155538, 155434, 155425, 154150, 153680, 153654, 153509, 152873, 152861, 152652, 152535, 152196, 151943, 150973, 150463, 149744, 148682, 148353, 148311, 147518, 147485, 147278, 147275, 147274, 147271, 147242, 147137, 146770, 146105, 145908, 145848, 145723, 143966, 143807, 143580, 143184, 143013, 142167, 141727, 140941, 140676, 139957, 139942, 139760, 139580, 139578, 139577, 139575, 139572, 139569, 139518, 139497, 139372, 138790, 138246, 138132, 138131, 136763, 136718, 136714, 136605, 136561, 135993, 135728, 135544, 135276, 135247, 135238, 135215, 135141, 135126, 134894, 134891, 134850, 134849, 134766, 134432, 134160, 134020, 133976, 133970, 133948, 133795, 133794, 133437, 133085, 132086, 132052, 131596, 131594, 131593, 131592, 131591, 131584, 131368, 131326, 131323, 131236, 131211, 131097, 131096, 131084, 131029, 130971, 130536, 130472, 129915, 129765, 129113, 126635))
Run Time: 0.094827
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 194 | 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: 559, 0, 1715760549, {"thread-183017":["thread",183017],"thread-182688":["thread",182688],"thread-182620":["thread",182620],"thread-182589":["thread",182589],"thread-182364":["thread",182364],"thread-182072":["thread",182072],"thread-180367":["thread",180367],"thread-179284":["thread",179284],"thread-179025":["thread",179025],"thread-179000":["thread",179000],"thread-178940":["thread",178940],"thread-178889":["thread",178889],"thread-178758":["thread",178758],"thread-178563":["thread",178563],"thread-178501":["thread",178501],"tl_group-333":["tl_group",333],"thread-177904":["thread",177904],"thread-177496":["thread",177496],"thread-176952":["thread",176952],"thread-176849":["thread",176849],"thread-176535":["thread",176535],"thread-176327":["thread",176327],"thread-176307":["thread",176307],"thread-176077":["thread",176077],"thread-175827":["thread",175827],"thread-175464":["thread",175464],"thread-175290":["thread",175290],"thread-173723":["thread",173723],"thread-173158":["thread",173158],"thread-172268":["thread",172268],"thread-170803":["thread",170803],"thread-170148":["thread",170148],"thread-169495":["thread",169495],"thread-169199":["thread",169199],"thread-169112":["thread",169112],"ams_article-4760":["ams_article",4760],"thread-167192":["thread",167192],"thread-167187":["thread",167187],"thread-167026":["thread",167026],"thread-167015":["thread",167015],"thread-166802":["thread",166802],"thread-166210":["thread",166210],"thread-165481":["thread",165481],"thread-165184":["thread",165184],"thread-164427":["thread",164427],"thread-164261":["thread",164261],"thread-164210":["thread",164210],"thread-163743":["thread",163743],"thread-163369":["thread",163369],"thread-163004":["thread",163004],"thread-162254":["thread",162254],"thread-161335":["thread",161335],"thread-161250":["thread",161250],"thread-161201":["thread",161201],"thread-161132":["thread",161132],"thread-159992":["thread",159992],"thread-159981":["thread",159981],"thread-159922":["thread",159922],"thread-159781":["thread",159781],"thread-159768":["thread",159768],"thread-159766":["thread",159766],"thread-159718":["thread",159718],"thread-159709":["thread",159709],"thread-159708":["thread",159708],"thread-159143":["thread",159143],"thread-159104":["thread",159104],"thread-158247":["thread",158247],"thread-157888":["thread",157888],"thread-157879":["thread",157879],"thread-157868":["thread",157868],"thread-157804":["thread",157804],"thread-157634":["thread",157634],"thread-157594":["thread",157594],"thread-157484":["thread",157484],"thread-157214":["thread",157214],"thread-156924":["thread",156924],"tl_group-137":["tl_group",137],"thread-155968":["thread",155968],"thread-155868":["thread",155868],"thread-155854":["thread",155854],"thread-155853":["thread",155853],"thread-155851":["thread",155851],"thread-155742":["thread",155742],"thread-155740":["thread",155740],"thread-155738":["thread",155738],"thread-155737":["thread",155737],"thread-155544":["thread",155544],"thread-155538":["thread",155538],"thread-155434":["thread",155434],"thread-155425":["thread",155425],"thread-154150":["thread",154150],"thread-153680":["thread",153680],"thread-153654":["thread",153654],"thread-153509":["thread",153509],"tl_group-82":["tl_group",82],"thread-152873":["thread",152873],"thread-152861":["thread",152861],"thread-152652":["thread",152652],"thread-152535":["thread",152535],"thread-152196":["thread",152196],"ams_article-3938":["ams_article",3938],"thread-151943":["thread",151943],"thread-150973":["thread",150973],"thread-150463":["thread",150463],"thread-149744":["thread",149744],"thread-148682":["thread",148682],"thread-148353":["thread",148353],"thread-148311":["thread",148311],"thread-147518":["thread",147518],"thread-147485":["thread",147485],"thread-147278":["thread",147278],"thread-147275":["thread",147275],"thread-147274":["thread",147274],"thread-147271":["thread",147271],"thread-147242":["thread",147242],"thread-147137":["thread",147137],"thread-146770":["thread",146770],"thread-146105":["thread",146105],"thread-145908":["thread",145908],"thread-145848":["thread",145848],"thread-145723":["thread",145723],"thread-143966":["thread",143966],"thread-143807":["thread",143807],"thread-143580":["thread",143580],"thread-143184":["thread",143184],"thread-143013":["thread",143013],"thread-142167":["thread",142167],"thread-141727":["thread",141727],"thread-140941":["thread",140941],"thread-140676":["thread",140676],"thread-139957":["thread",139957],"thread-139942":["thread",139942],"thread-139760":["thread",139760],"thread-139580":["thread",139580],"thread-139578":["thread",139578],"thread-139577":["thread",139577],"thread-139575":["thread",139575],"thread-139572":["thread",139572],"thread-139569":["thread",139569],"thread-139518":["thread",139518],"thread-139497":["thread",139497],"thread-139372":["thread",139372],"thread-138790":["thread",138790],"thread-138246":["thread",138246],"thread-138132":["thread",138132],"thread-138131":["thread",138131],"thread-136763":["thread",136763],"thread-136718":["thread",136718],"thread-136714":["thread",136714],"thread-136605":["thread",136605],"thread-136561":["thread",136561],"thread-135993":["thread",135993],"thread-135728":["thread",135728],"thread-135544":["thread",135544],"thread-135276":["thread",135276],"thread-135247":["thread",135247],"thread-135238":["thread",135238],"thread-135215":["thread",135215],"thread-135141":["thread",135141],"thread-135126":["thread",135126],"thread-134894":["thread",134894],"thread-134891":["thread",134891],"thread-134850":["thread",134850],"thread-134849":["thread",134849],"thread-134766":["thread",134766],"thread-134432":["thread",134432],"thread-134160":["thread",134160],"thread-134020":["thread",134020],"thread-133976":["thread",133976],"thread-133970":["thread",133970],"thread-133948":["thread",133948],"thread-133795":["thread",133795],"thread-133794":["thread",133794],"thread-133437":["thread",133437],"thread-133085":["thread",133085],"thread-132086":["thread",132086],"thread-132052":["thread",132052],"thread-131596":["thread",131596],"thread-131594":["thread",131594],"thread-131593":["thread",131593],"thread-131592":["thread",131592],"thread-131591":["thread",131591],"thread-131584":["thread",131584],"thread-131368":["thread",131368],"thread-131326":["thread",131326],"thread-131323":["thread",131323],"thread-131236":["thread",131236],"thread-131211":["thread",131211],"thread-131097":["thread",131097],"thread-131096":["thread",131096],"thread-131084":["thread",131084],"thread-131029":["thread",131029],"thread-130971":["thread",130971],"thread-130536":["thread",130536],"thread-130472":["thread",130472],"thread-129915":["thread",129915],"thread-129765":["thread",129765],"thread-129113":["thread",129113],"thread-126635":["thread",126635]}, , 1715756949
Run Time: 0.000383
- 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