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 (183469, 183428, 183061, 183025, 181565, 180904, 180395, 180034, 180030, 179766, 179686, 179114, 177985, 177929, 177390, 177309, 176819, 176781, 176293, 176171, 175827, 175555, 174749, 173918, 173837, 172869, 172544, 172252, 171428, 171359, 170560, 170522, 169314, 168598, 167709, 166730, 166573, 165668, 164894, 163796, 163295, 163226, 163074, 162292, 160744, 160359, 160240, 160189, 159979, 159538, 159534, 159270, 158971, 157860, 157741, 157626, 157463, 157003, 156628, 154665, 154657, 154470, 154287, 154001, 153523, 153469, 152572, 152030, 151802, 151144, 148342, 147731, 145385, 142913, 142287, 141491, 141323, 137726, 137207, 135417, 133088, 132608, 132481, 132167, 132153, 132130, 132126, 132112, 132087, 132063, 132052, 132022, 132015, 131988, 131929, 131880, 131855, 131790, 131756, 131700, 131696, 131603, 131580, 131575, 131561, 131541, 131494, 131431, 131381, 131296, 131289, 131195, 131125, 130978, 130958, 130955, 130908, 130901, 130853, 130628, 130528, 130526, 130429, 130383, 130378, 130283, 130263, 130249, 130227, 130184, 130087, 130071, 130062, 129849, 129847, 129705, 129602, 129581, 129542, 129537, 129389, 129372, 129369, 129337, 129333, 129305, 129280, 129148, 129106, 129027, 128958, 128882, 128753, 128635, 128627, 128624, 128559, 128525, 128512, 128489, 128480, 128424, 128369, 128358, 128346, 128334, 128332, 128330, 128328, 128249, 128187, 128106, 128080, 127848, 127841, 127772, 127697, 127679, 127418, 127408, 127233, 127121, 127101, 127089, 127031, 126964, 126909, 126880, 126812, 126788, 126786, 126785, 126736, 126681, 126644, 126641, 126631, 126547, 126464, 126374))
Run Time: 0.087992
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 2581, 0, 1716998109, {"thread-183469":["thread",183469],"thread-183428":["thread",183428],"thread-183061":["thread",183061],"thread-183025":["thread",183025],"thread-181565":["thread",181565],"thread-180904":["thread",180904],"thread-180395":["thread",180395],"thread-180034":["thread",180034],"thread-180030":["thread",180030],"thread-179766":["thread",179766],"thread-179686":["thread",179686],"thread-179114":["thread",179114],"thread-177985":["thread",177985],"thread-177929":["thread",177929],"thread-177390":["thread",177390],"thread-177309":["thread",177309],"thread-176819":["thread",176819],"thread-176781":["thread",176781],"thread-176293":["thread",176293],"thread-176171":["thread",176171],"thread-175827":["thread",175827],"thread-175555":["thread",175555],"thread-174749":["thread",174749],"thread-173918":["thread",173918],"thread-173837":["thread",173837],"thread-172869":["thread",172869],"thread-172544":["thread",172544],"thread-172252":["thread",172252],"thread-171428":["thread",171428],"thread-171359":["thread",171359],"thread-170560":["thread",170560],"thread-170522":["thread",170522],"thread-169314":["thread",169314],"thread-168598":["thread",168598],"thread-167709":["thread",167709],"thread-166730":["thread",166730],"thread-166573":["thread",166573],"thread-165668":["thread",165668],"thread-164894":["thread",164894],"thread-163796":["thread",163796],"thread-163295":["thread",163295],"thread-163226":["thread",163226],"thread-163074":["thread",163074],"thread-162292":["thread",162292],"thread-160744":["thread",160744],"thread-160359":["thread",160359],"thread-160240":["thread",160240],"thread-160189":["thread",160189],"thread-159979":["thread",159979],"thread-159538":["thread",159538],"thread-159534":["thread",159534],"thread-159270":["thread",159270],"thread-158971":["thread",158971],"thread-157860":["thread",157860],"thread-157741":["thread",157741],"thread-157626":["thread",157626],"thread-157463":["thread",157463],"thread-157003":["thread",157003],"thread-156628":["thread",156628],"thread-154665":["thread",154665],"thread-154657":["thread",154657],"thread-154470":["thread",154470],"thread-154287":["thread",154287],"thread-154001":["thread",154001],"thread-153523":["thread",153523],"thread-153469":["thread",153469],"thread-152572":["thread",152572],"thread-152030":["thread",152030],"thread-151802":["thread",151802],"thread-151144":["thread",151144],"thread-148342":["thread",148342],"thread-147731":["thread",147731],"thread-145385":["thread",145385],"thread-142913":["thread",142913],"thread-142287":["thread",142287],"thread-141491":["thread",141491],"thread-141323":["thread",141323],"thread-137726":["thread",137726],"thread-137207":["thread",137207],"thread-135417":["thread",135417],"thread-133088":["thread",133088],"thread-132608":["thread",132608],"thread-132481":["thread",132481],"thread-132167":["thread",132167],"thread-132153":["thread",132153],"thread-132130":["thread",132130],"thread-132126":["thread",132126],"thread-132112":["thread",132112],"thread-132087":["thread",132087],"thread-132063":["thread",132063],"thread-132052":["thread",132052],"thread-132022":["thread",132022],"thread-132015":["thread",132015],"thread-131988":["thread",131988],"thread-131929":["thread",131929],"thread-131880":["thread",131880],"thread-131855":["thread",131855],"thread-131790":["thread",131790],"thread-131756":["thread",131756],"thread-131700":["thread",131700],"thread-131696":["thread",131696],"thread-131603":["thread",131603],"thread-131580":["thread",131580],"thread-131575":["thread",131575],"thread-131561":["thread",131561],"thread-131541":["thread",131541],"thread-131494":["thread",131494],"thread-131431":["thread",131431],"thread-131381":["thread",131381],"thread-131296":["thread",131296],"thread-131289":["thread",131289],"thread-131195":["thread",131195],"thread-131125":["thread",131125],"thread-130978":["thread",130978],"thread-130958":["thread",130958],"thread-130955":["thread",130955],"thread-130908":["thread",130908],"thread-130901":["thread",130901],"thread-130853":["thread",130853],"thread-130628":["thread",130628],"thread-130528":["thread",130528],"thread-130526":["thread",130526],"thread-130429":["thread",130429],"thread-130383":["thread",130383],"thread-130378":["thread",130378],"thread-130283":["thread",130283],"thread-130263":["thread",130263],"thread-130249":["thread",130249],"thread-130227":["thread",130227],"thread-130184":["thread",130184],"thread-130087":["thread",130087],"thread-130071":["thread",130071],"thread-130062":["thread",130062],"thread-129849":["thread",129849],"thread-129847":["thread",129847],"thread-129705":["thread",129705],"thread-129602":["thread",129602],"thread-129581":["thread",129581],"thread-129542":["thread",129542],"thread-129537":["thread",129537],"thread-129389":["thread",129389],"thread-129372":["thread",129372],"thread-129369":["thread",129369],"thread-129337":["thread",129337],"thread-129333":["thread",129333],"thread-129305":["thread",129305],"thread-129280":["thread",129280],"thread-129148":["thread",129148],"thread-129106":["thread",129106],"thread-129027":["thread",129027],"thread-128958":["thread",128958],"thread-128882":["thread",128882],"thread-128753":["thread",128753],"thread-128635":["thread",128635],"thread-128627":["thread",128627],"thread-128624":["thread",128624],"thread-128559":["thread",128559],"thread-128525":["thread",128525],"thread-128512":["thread",128512],"thread-128489":["thread",128489],"thread-128480":["thread",128480],"thread-128424":["thread",128424],"thread-128369":["thread",128369],"thread-128358":["thread",128358],"thread-128346":["thread",128346],"thread-128334":["thread",128334],"thread-128332":["thread",128332],"thread-128330":["thread",128330],"thread-128328":["thread",128328],"thread-128249":["thread",128249],"thread-128187":["thread",128187],"thread-128106":["thread",128106],"thread-128080":["thread",128080],"thread-127848":["thread",127848],"thread-127841":["thread",127841],"thread-127772":["thread",127772],"thread-127697":["thread",127697],"thread-127679":["thread",127679],"thread-127418":["thread",127418],"thread-127408":["thread",127408],"thread-127233":["thread",127233],"thread-127121":["thread",127121],"thread-127101":["thread",127101],"thread-127089":["thread",127089],"thread-127031":["thread",127031],"thread-126964":["thread",126964],"thread-126909":["thread",126909],"thread-126880":["thread",126880],"thread-126812":["thread",126812],"thread-126788":["thread",126788],"thread-126786":["thread",126786],"thread-126785":["thread",126785],"thread-126736":["thread",126736],"thread-126681":["thread",126681],"thread-126644":["thread",126644],"thread-126641":["thread",126641],"thread-126631":["thread",126631],"thread-126547":["thread",126547],"thread-126464":["thread",126464],"thread-126374":["thread",126374]}, , 1716994509
Run Time: 0.000734
- 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