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 (218566, 218497, 218089, 218014, 213337, 212671, 212272, 210742, 210538, 210034, 208696, 207580, 205687, 201967, 200377, 199000, 198472, 194017, 193825, 192775, 191992, 190474, 190384, 189727, 188974, 188665, 184915, 184225, 181888, 180514, 180460, 179995, 177484, 177452, 174679, 174163, 174112, 173335, 173155, 173149, 172585, 171822, 171116, 167571, 167454, 166395, 165495, 164941, 164689, 163537, 162907, 159301, 157873, 156637, 154156, 153673, 153670, 153664, 153661, 153658, 153655, 146591, 146258, 141593, 141204, 138003, 132026, 128113, 128098, 127758, 127062, 125555, 125476, 125188, 125018, 124081, 123653, 123238, 123235, 122799, 122686, 122484, 122459, 121271, 120371, 120370, 117685, 117633, 114658, 110825, 109166, 108678, 108629, 108616, 108483, 108314, 108167, 108048, 106400, 105277, 105152, 105013, 104925, 104506, 104316, 104009, 103884, 103239, 103109, 102855, 102285, 100865, 100034, 99521, 98562, 98263, 98075, 95605, 95477, 95395, 95369, 95211, 93894, 93893, 93147, 93014, 93012, 91529, 90998, 90975, 90974))
Run Time: 0.010916
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 131 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,forum.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2710
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- 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: 51, 0, 1715424722, {"thread-218566":["thread",218566],"thread-218497":["thread",218497],"thread-218089":["thread",218089],"thread-218014":["thread",218014],"thread-213337":["thread",213337],"thread-212671":["thread",212671],"thread-212272":["thread",212272],"thread-210742":["thread",210742],"thread-210538":["thread",210538],"thread-210034":["thread",210034],"thread-208696":["thread",208696],"thread-207580":["thread",207580],"thread-205687":["thread",205687],"thread-201967":["thread",201967],"thread-200377":["thread",200377],"thread-199000":["thread",199000],"thread-198472":["thread",198472],"thread-194017":["thread",194017],"thread-193825":["thread",193825],"thread-192775":["thread",192775],"thread-191992":["thread",191992],"thread-190474":["thread",190474],"thread-190384":["thread",190384],"thread-189727":["thread",189727],"thread-188974":["thread",188974],"thread-188665":["thread",188665],"thread-184915":["thread",184915],"thread-184225":["thread",184225],"thread-181888":["thread",181888],"thread-180514":["thread",180514],"thread-180460":["thread",180460],"thread-179995":["thread",179995],"thread-177484":["thread",177484],"thread-177452":["thread",177452],"thread-174679":["thread",174679],"thread-174163":["thread",174163],"thread-174112":["thread",174112],"thread-173335":["thread",173335],"thread-173155":["thread",173155],"thread-173149":["thread",173149],"thread-172585":["thread",172585],"thread-171822":["thread",171822],"thread-171116":["thread",171116],"thread-167571":["thread",167571],"thread-167454":["thread",167454],"thread-166395":["thread",166395],"thread-165495":["thread",165495],"thread-164941":["thread",164941],"thread-164689":["thread",164689],"thread-163537":["thread",163537],"thread-162907":["thread",162907],"thread-159301":["thread",159301],"thread-157873":["thread",157873],"thread-156637":["thread",156637],"thread-154156":["thread",154156],"thread-153673":["thread",153673],"thread-153670":["thread",153670],"thread-153664":["thread",153664],"thread-153661":["thread",153661],"thread-153658":["thread",153658],"thread-153655":["thread",153655],"thread-146591":["thread",146591],"thread-146258":["thread",146258],"thread-141593":["thread",141593],"thread-141204":["thread",141204],"thread-138003":["thread",138003],"thread-132026":["thread",132026],"thread-128113":["thread",128113],"thread-128098":["thread",128098],"thread-127758":["thread",127758],"thread-127062":["thread",127062],"thread-125555":["thread",125555],"thread-125476":["thread",125476],"thread-125188":["thread",125188],"thread-125018":["thread",125018],"thread-124081":["thread",124081],"thread-123653":["thread",123653],"thread-123238":["thread",123238],"thread-123235":["thread",123235],"thread-122799":["thread",122799],"thread-122686":["thread",122686],"thread-122484":["thread",122484],"thread-122459":["thread",122459],"thread-121271":["thread",121271],"thread-120371":["thread",120371],"thread-120370":["thread",120370],"thread-117685":["thread",117685],"thread-117633":["thread",117633],"thread-114658":["thread",114658],"thread-110825":["thread",110825],"thread-109166":["thread",109166],"thread-108678":["thread",108678],"thread-108629":["thread",108629],"thread-108616":["thread",108616],"thread-108483":["thread",108483],"thread-108314":["thread",108314],"thread-108167":["thread",108167],"thread-108048":["thread",108048],"thread-106400":["thread",106400],"thread-105277":["thread",105277],"thread-105152":["thread",105152],"thread-105013":["thread",105013],"thread-104925":["thread",104925],"thread-104506":["thread",104506],"thread-104316":["thread",104316],"thread-104009":["thread",104009],"thread-103884":["thread",103884],"thread-103239":["thread",103239],"thread-103109":["thread",103109],"thread-102855":["thread",102855],"thread-102285":["thread",102285],"thread-100865":["thread",100865],"thread-100034":["thread",100034],"thread-99521":["thread",99521],"thread-98562":["thread",98562],"thread-98263":["thread",98263],"thread-98075":["thread",98075],"thread-95605":["thread",95605],"thread-95477":["thread",95477],"thread-95395":["thread",95395],"thread-95369":["thread",95369],"thread-95211":["thread",95211],"thread-93894":["thread",93894],"thread-93893":["thread",93893],"thread-93147":["thread",93147],"thread-93014":["thread",93014],"thread-93012":["thread",93012],"thread-91529":["thread",91529],"thread-90998":["thread",90998],"thread-90975":["thread",90975],"thread-90974":["thread",90974]}, , 1715421122
Run Time: 0.000564
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1510
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20