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 (241558, 236737, 231102, 231101, 229826, 229780, 211523, 210451, 210449, 210447, 206559, 202426, 202262, 190556, 185092, 184365, 184291, 178666, 175462, 174639, 172624, 169219, 166814, 161371, 155373, 153301, 152032, 147146, 141685, 141587, 134639, 133420, 132100, 128395, 126105, 125884, 125181, 122906, 121761, 121608, 121432, 121412, 121296, 121051, 120601, 119612, 119052, 117051, 115652, 115453, 115044, 114492, 114263, 113533, 113211, 113085, 112841, 112556, 112271, 110892, 110706, 109997, 109971, 109848, 109595, 109466, 109181, 109027, 108609, 108578, 108252, 107598, 106931, 106782, 106760, 106690, 106084, 105873, 105209, 104917, 104822, 104538, 104537, 104534, 103320, 103182, 102916, 102698, 102680, 102679, 102635, 102606, 102592, 102473, 102459, 102382, 102295, 102156, 102098, 101540, 101364, 101275, 101184, 101116, 100691, 100525, 100364, 100350, 99871, 99815, 99813, 99517, 99048, 98864, 98801, 98442, 98220, 97961, 97909, 97850, 97716, 97681, 97102, 96943, 96926, 96734, 96106, 95776, 49040, 17391, 13624))
Run Time: 0.007846
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 | sammyboy_xenforo.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | sammyboy_xenforo.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | sammyboy_xenforo.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | sammyboy_xenforo.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,sammyboy_xenforo.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 1430
- 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 2866
- 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 2483
- XF\App->run() in src/XF.php at line 525
- 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: 337, 0, 1717256319, {"thread-241558":["thread",241558],"thread-236737":["thread",236737],"thread-231102":["thread",231102],"thread-231101":["thread",231101],"thread-229826":["thread",229826],"thread-229780":["thread",229780],"thread-211523":["thread",211523],"thread-210451":["thread",210451],"thread-210449":["thread",210449],"thread-210447":["thread",210447],"thread-206559":["thread",206559],"thread-202426":["thread",202426],"thread-202262":["thread",202262],"thread-190556":["thread",190556],"thread-185092":["thread",185092],"thread-184365":["thread",184365],"thread-184291":["thread",184291],"thread-178666":["thread",178666],"thread-175462":["thread",175462],"thread-174639":["thread",174639],"thread-172624":["thread",172624],"thread-169219":["thread",169219],"thread-166814":["thread",166814],"thread-161371":["thread",161371],"thread-155373":["thread",155373],"thread-153301":["thread",153301],"thread-152032":["thread",152032],"thread-147146":["thread",147146],"thread-141685":["thread",141685],"thread-141587":["thread",141587],"thread-134639":["thread",134639],"thread-133420":["thread",133420],"thread-132100":["thread",132100],"thread-128395":["thread",128395],"thread-126105":["thread",126105],"thread-125884":["thread",125884],"thread-125181":["thread",125181],"thread-122906":["thread",122906],"thread-121761":["thread",121761],"thread-121608":["thread",121608],"thread-121432":["thread",121432],"thread-121412":["thread",121412],"thread-121296":["thread",121296],"thread-121051":["thread",121051],"thread-120601":["thread",120601],"thread-119612":["thread",119612],"thread-119052":["thread",119052],"thread-117051":["thread",117051],"thread-115652":["thread",115652],"thread-115453":["thread",115453],"thread-115044":["thread",115044],"thread-114492":["thread",114492],"thread-114263":["thread",114263],"thread-113533":["thread",113533],"thread-113211":["thread",113211],"thread-113085":["thread",113085],"thread-112841":["thread",112841],"thread-112556":["thread",112556],"thread-112271":["thread",112271],"thread-110892":["thread",110892],"thread-110706":["thread",110706],"thread-109997":["thread",109997],"thread-109971":["thread",109971],"thread-109848":["thread",109848],"thread-109595":["thread",109595],"thread-109466":["thread",109466],"thread-109181":["thread",109181],"thread-109027":["thread",109027],"thread-108609":["thread",108609],"thread-108578":["thread",108578],"thread-108252":["thread",108252],"thread-107598":["thread",107598],"thread-106931":["thread",106931],"thread-106782":["thread",106782],"thread-106760":["thread",106760],"thread-106690":["thread",106690],"thread-106084":["thread",106084],"thread-105873":["thread",105873],"thread-105209":["thread",105209],"thread-104917":["thread",104917],"thread-104822":["thread",104822],"thread-104538":["thread",104538],"thread-104537":["thread",104537],"thread-104534":["thread",104534],"thread-103320":["thread",103320],"thread-103182":["thread",103182],"thread-102916":["thread",102916],"thread-102698":["thread",102698],"thread-102680":["thread",102680],"thread-102679":["thread",102679],"thread-102635":["thread",102635],"thread-102606":["thread",102606],"thread-102592":["thread",102592],"thread-102473":["thread",102473],"thread-102459":["thread",102459],"thread-102382":["thread",102382],"thread-102295":["thread",102295],"thread-102156":["thread",102156],"thread-102098":["thread",102098],"thread-101540":["thread",101540],"thread-101364":["thread",101364],"thread-101275":["thread",101275],"thread-101184":["thread",101184],"thread-101116":["thread",101116],"thread-100691":["thread",100691],"thread-100525":["thread",100525],"thread-100364":["thread",100364],"thread-100350":["thread",100350],"thread-99871":["thread",99871],"thread-99815":["thread",99815],"thread-99813":["thread",99813],"thread-99517":["thread",99517],"thread-99048":["thread",99048],"thread-98864":["thread",98864],"thread-98801":["thread",98801],"thread-98442":["thread",98442],"thread-98220":["thread",98220],"thread-97961":["thread",97961],"thread-97909":["thread",97909],"thread-97850":["thread",97850],"thread-97716":["thread",97716],"thread-97681":["thread",97681],"thread-97102":["thread",97102],"thread-96943":["thread",96943],"thread-96926":["thread",96926],"thread-96734":["thread",96734],"thread-96106":["thread",96106],"thread-95776":["thread",95776],"thread-49040":["thread",49040],"thread-17391":["thread",17391],"thread-13624":["thread",13624]}, NULL, 1717252719
Run Time: 0.000334
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- 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 2483
- XF\App->run() in src/XF.php at line 525
- XF::runApp() in index.php at line 20