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 (183346, 181868, 181548, 181336, 178921, 178719, 178413, 178276, 178239, 177727, 177599, 176318, 174684, 173929, 173012, 171780, 170786, 170128, 170047, 170024, 170016, 170015, 169957, 169598, 169595, 168788, 168657, 167519, 164702, 164674, 164584, 163408, 163084, 162929, 162551, 162153, 161484, 160833, 160827, 160711, 160512, 159284, 158897, 158582, 158048, 157368, 157126, 157062, 156631, 156460, 156459, 156379, 156196, 155487, 155145, 154384, 154131, 153027, 152842, 152772, 152074, 145793, 145405, 143064, 141044, 139748, 139692, 135609, 135226, 134195, 134194, 133992, 133560, 133494, 133030, 131511, 130871, 130870, 130786, 130517, 130341, 130173, 129991, 129643, 129240, 128716, 128430, 127152, 126520, 125707, 125067, 124618, 124056, 123847, 123656, 123626, 123443, 123432, 123065, 122050, 121316, 121309, 121081, 120996, 120936, 120593, 120592, 120278, 120274, 119404, 119186, 119039, 118952, 118941, 118743, 118739, 118321, 118245, 117371, 116283, 115495, 115306, 114657, 114244, 111147, 110889, 110515, 110223, 108946, 108500, 107536, 107178, 106875, 106528, 105352, 104677, 104101, 103539, 103513, 103429, 103402, 103126, 103043, 103022, 103021, 98521, 95932, 93646, 91302, 91031, 90870, 90443, 90440, 89676, 84945, 83425, 82347, 80465, 73988, 68259, 48440, 48236, 27193))
Run Time: 0.147433
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 163 | 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: 12966, 0, 1715985737, {"thread-183346":["thread",183346],"thread-181868":["thread",181868],"thread-181548":["thread",181548],"thread-181336":["thread",181336],"thread-178921":["thread",178921],"thread-178719":["thread",178719],"thread-178413":["thread",178413],"thread-178276":["thread",178276],"thread-178239":["thread",178239],"thread-177727":["thread",177727],"thread-177599":["thread",177599],"thread-176318":["thread",176318],"thread-174684":["thread",174684],"thread-173929":["thread",173929],"thread-173012":["thread",173012],"thread-171780":["thread",171780],"thread-170786":["thread",170786],"thread-170128":["thread",170128],"thread-170047":["thread",170047],"thread-170024":["thread",170024],"thread-170016":["thread",170016],"thread-170015":["thread",170015],"thread-169957":["thread",169957],"thread-169598":["thread",169598],"thread-169595":["thread",169595],"thread-168788":["thread",168788],"thread-168657":["thread",168657],"thread-167519":["thread",167519],"thread-164674":["thread",164674],"thread-164584":["thread",164584],"thread-163408":["thread",163408],"thread-163084":["thread",163084],"thread-162929":["thread",162929],"thread-162551":["thread",162551],"thread-162153":["thread",162153],"thread-161484":["thread",161484],"thread-160833":["thread",160833],"thread-160827":["thread",160827],"thread-160711":["thread",160711],"thread-160512":["thread",160512],"thread-159284":["thread",159284],"thread-158897":["thread",158897],"thread-158582":["thread",158582],"thread-158048":["thread",158048],"thread-157368":["thread",157368],"thread-157126":["thread",157126],"thread-157062":["thread",157062],"thread-156631":["thread",156631],"thread-156460":["thread",156460],"thread-156459":["thread",156459],"thread-156379":["thread",156379],"thread-156196":["thread",156196],"thread-155487":["thread",155487],"thread-155145":["thread",155145],"thread-154384":["thread",154384],"thread-154131":["thread",154131],"thread-153027":["thread",153027],"thread-152842":["thread",152842],"thread-152772":["thread",152772],"thread-152074":["thread",152074],"thread-145793":["thread",145793],"thread-145405":["thread",145405],"thread-143064":["thread",143064],"thread-141044":["thread",141044],"thread-139748":["thread",139748],"thread-139692":["thread",139692],"thread-135609":["thread",135609],"thread-135226":["thread",135226],"thread-134195":["thread",134195],"thread-134194":["thread",134194],"thread-133992":["thread",133992],"thread-133560":["thread",133560],"thread-133494":["thread",133494],"thread-133030":["thread",133030],"thread-131511":["thread",131511],"thread-130871":["thread",130871],"thread-130870":["thread",130870],"thread-130786":["thread",130786],"thread-130517":["thread",130517],"thread-130341":["thread",130341],"thread-130173":["thread",130173],"thread-129991":["thread",129991],"thread-129643":["thread",129643],"thread-129240":["thread",129240],"thread-128716":["thread",128716],"thread-128430":["thread",128430],"thread-127152":["thread",127152],"thread-126520":["thread",126520],"thread-125707":["thread",125707],"thread-125067":["thread",125067],"thread-124618":["thread",124618],"thread-124056":["thread",124056],"thread-123847":["thread",123847],"thread-123656":["thread",123656],"thread-123626":["thread",123626],"thread-123443":["thread",123443],"thread-123432":["thread",123432],"thread-123065":["thread",123065],"thread-122050":["thread",122050],"thread-121316":["thread",121316],"thread-121309":["thread",121309],"thread-121081":["thread",121081],"thread-120996":["thread",120996],"thread-120936":["thread",120936],"thread-120593":["thread",120593],"thread-120592":["thread",120592],"thread-120278":["thread",120278],"thread-120274":["thread",120274],"thread-119404":["thread",119404],"thread-119186":["thread",119186],"thread-119039":["thread",119039],"thread-118952":["thread",118952],"thread-118941":["thread",118941],"thread-118743":["thread",118743],"thread-118739":["thread",118739],"thread-118321":["thread",118321],"thread-118245":["thread",118245],"thread-117371":["thread",117371],"thread-116283":["thread",116283],"thread-115495":["thread",115495],"thread-115306":["thread",115306],"thread-114657":["thread",114657],"thread-114244":["thread",114244],"thread-111147":["thread",111147],"thread-110889":["thread",110889],"thread-110515":["thread",110515],"thread-110223":["thread",110223],"thread-108946":["thread",108946],"thread-108500":["thread",108500],"thread-107536":["thread",107536],"thread-107178":["thread",107178],"thread-106875":["thread",106875],"thread-106528":["thread",106528],"thread-105352":["thread",105352],"thread-104677":["thread",104677],"thread-104101":["thread",104101],"thread-103539":["thread",103539],"thread-103513":["thread",103513],"thread-103429":["thread",103429],"thread-103402":["thread",103402],"thread-103126":["thread",103126],"thread-103043":["thread",103043],"thread-103022":["thread",103022],"thread-103021":["thread",103021],"thread-98521":["thread",98521],"thread-95932":["thread",95932],"thread-93646":["thread",93646],"thread-91302":["thread",91302],"thread-91031":["thread",91031],"thread-90870":["thread",90870],"thread-90443":["thread",90443],"thread-90440":["thread",90440],"thread-89676":["thread",89676],"thread-84945":["thread",84945],"thread-83425":["thread",83425],"thread-82347":["thread",82347],"thread-80465":["thread",80465],"thread-73988":["thread",73988],"thread-68259":["thread",68259],"thread-48440":["thread",48440],"thread-48236":["thread",48236],"thread-27193":["thread",27193]}, , 1715982137
Run Time: 0.000487
- 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