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 (183631, 183554, 183388, 182303, 182224, 182211, 181904, 181898, 181769, 181695, 181624, 180297, 180060, 179778, 179287, 178497, 178469, 178444, 178357, 178315, 178207, 178189, 176699, 176695, 176664, 176600, 176581, 176438, 176179, 175853, 175852, 175375, 175061, 174182, 174181, 174146, 173982, 173956, 173933, 173762, 173648, 173372, 173098, 172663, 172653, 172639, 172579, 172577, 172489, 172402, 172365, 172325, 172219, 171734, 171718, 171644, 171586, 170670, 170664, 170604, 170496, 170468, 170466, 170462, 170446, 170425, 170424, 170423, 170373, 170369, 170348, 170344, 170323, 170253, 170199, 170188, 170182, 170169, 170156, 170140, 170114, 170112, 170065, 170005, 169886, 169817, 169719, 169584, 169514, 169492, 169398, 169240, 169237, 169208, 169177, 169142, 169032, 168670, 168576, 168405, 168404, 168344, 168155, 168133, 167761, 167702, 166493, 166492, 165870, 165842, 165839, 165715, 165691, 165635, 165629, 165519, 165185, 164840, 164821, 164022, 164012, 163974, 163927, 163869, 163804, 163755, 163722, 163711, 163491, 163403, 163397, 163391, 163350, 163284, 163091, 163003, 162967, 162956, 162851, 162752, 162701, 162597, 162476, 162372, 162367, 162348, 162299, 162251, 162239, 162233, 162204, 162176, 162169, 162107, 162030, 162029, 161849, 161723, 161713, 161661, 161647, 161465, 161285, 161284, 161283, 161207, 161205, 161190, 161130, 161054, 161029, 161024, 161022, 161021, 161019, 161015, 161013, 161012, 161007, 161005, 161004, 161003, 161002, 161001, 160999, 160998, 160994, 160856, 159372, 159340, 159152, 159042, 159014, 158989, 158977, 158833, 158764, 158675, 158621))
Run Time: 0.103404
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 199 | 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: 1647, 0, 1716178328, {"thread-183631":["thread",183631],"thread-183554":["thread",183554],"thread-183388":["thread",183388],"thread-182303":["thread",182303],"thread-182224":["thread",182224],"thread-182211":["thread",182211],"thread-181904":["thread",181904],"thread-181898":["thread",181898],"thread-181769":["thread",181769],"thread-181695":["thread",181695],"thread-181624":["thread",181624],"thread-180297":["thread",180297],"thread-180060":["thread",180060],"thread-179778":["thread",179778],"thread-179287":["thread",179287],"thread-178497":["thread",178497],"thread-178469":["thread",178469],"thread-178444":["thread",178444],"thread-178357":["thread",178357],"thread-178315":["thread",178315],"thread-178207":["thread",178207],"thread-178189":["thread",178189],"thread-176699":["thread",176699],"thread-176695":["thread",176695],"thread-176664":["thread",176664],"thread-176600":["thread",176600],"thread-176581":["thread",176581],"thread-176438":["thread",176438],"thread-176179":["thread",176179],"thread-175853":["thread",175853],"thread-175852":["thread",175852],"thread-175375":["thread",175375],"thread-175061":["thread",175061],"thread-174182":["thread",174182],"thread-174181":["thread",174181],"thread-174146":["thread",174146],"thread-173982":["thread",173982],"thread-173956":["thread",173956],"thread-173933":["thread",173933],"thread-173762":["thread",173762],"thread-173648":["thread",173648],"thread-173372":["thread",173372],"thread-173098":["thread",173098],"thread-172663":["thread",172663],"thread-172653":["thread",172653],"thread-172639":["thread",172639],"thread-172579":["thread",172579],"thread-172577":["thread",172577],"thread-172489":["thread",172489],"thread-172402":["thread",172402],"thread-172365":["thread",172365],"thread-172325":["thread",172325],"thread-172219":["thread",172219],"thread-171734":["thread",171734],"thread-171718":["thread",171718],"thread-171644":["thread",171644],"thread-171586":["thread",171586],"thread-170670":["thread",170670],"thread-170664":["thread",170664],"thread-170604":["thread",170604],"thread-170496":["thread",170496],"thread-170468":["thread",170468],"thread-170466":["thread",170466],"thread-170462":["thread",170462],"thread-170446":["thread",170446],"thread-170425":["thread",170425],"thread-170424":["thread",170424],"thread-170423":["thread",170423],"thread-170373":["thread",170373],"thread-170369":["thread",170369],"thread-170348":["thread",170348],"thread-170344":["thread",170344],"thread-170323":["thread",170323],"thread-170253":["thread",170253],"thread-170199":["thread",170199],"thread-170188":["thread",170188],"thread-170182":["thread",170182],"thread-170169":["thread",170169],"thread-170156":["thread",170156],"thread-170140":["thread",170140],"thread-170114":["thread",170114],"thread-170112":["thread",170112],"thread-170065":["thread",170065],"thread-170005":["thread",170005],"thread-169886":["thread",169886],"thread-169817":["thread",169817],"thread-169719":["thread",169719],"thread-169584":["thread",169584],"thread-169514":["thread",169514],"thread-169492":["thread",169492],"thread-169398":["thread",169398],"thread-169240":["thread",169240],"thread-169237":["thread",169237],"thread-169208":["thread",169208],"thread-169177":["thread",169177],"thread-169142":["thread",169142],"thread-169032":["thread",169032],"thread-168670":["thread",168670],"thread-168576":["thread",168576],"thread-168405":["thread",168405],"thread-168404":["thread",168404],"thread-168344":["thread",168344],"thread-168155":["thread",168155],"thread-168133":["thread",168133],"thread-167761":["thread",167761],"thread-167702":["thread",167702],"thread-166493":["thread",166493],"thread-166492":["thread",166492],"thread-165870":["thread",165870],"thread-165842":["thread",165842],"thread-165839":["thread",165839],"thread-165715":["thread",165715],"thread-165691":["thread",165691],"thread-165635":["thread",165635],"thread-165629":["thread",165629],"thread-165519":["thread",165519],"thread-165185":["thread",165185],"thread-164840":["thread",164840],"thread-164821":["thread",164821],"thread-164022":["thread",164022],"thread-164012":["thread",164012],"thread-163974":["thread",163974],"thread-163927":["thread",163927],"thread-163869":["thread",163869],"thread-163804":["thread",163804],"thread-163755":["thread",163755],"thread-163722":["thread",163722],"thread-163711":["thread",163711],"thread-163491":["thread",163491],"thread-163403":["thread",163403],"thread-163397":["thread",163397],"thread-163391":["thread",163391],"thread-163350":["thread",163350],"thread-163284":["thread",163284],"thread-163091":["thread",163091],"thread-163003":["thread",163003],"thread-162967":["thread",162967],"thread-162956":["thread",162956],"thread-162851":["thread",162851],"thread-162752":["thread",162752],"thread-162701":["thread",162701],"thread-162597":["thread",162597],"thread-162476":["thread",162476],"thread-162372":["thread",162372],"thread-162367":["thread",162367],"thread-162348":["thread",162348],"thread-162299":["thread",162299],"thread-162251":["thread",162251],"thread-162239":["thread",162239],"thread-162233":["thread",162233],"thread-162204":["thread",162204],"thread-162176":["thread",162176],"thread-162169":["thread",162169],"ams_article-4474":["ams_article",4474],"thread-162107":["thread",162107],"thread-162030":["thread",162030],"thread-162029":["thread",162029],"thread-161849":["thread",161849],"thread-161723":["thread",161723],"thread-161713":["thread",161713],"thread-161661":["thread",161661],"thread-161647":["thread",161647],"thread-161465":["thread",161465],"thread-161285":["thread",161285],"thread-161284":["thread",161284],"thread-161283":["thread",161283],"thread-161207":["thread",161207],"thread-161205":["thread",161205],"thread-161190":["thread",161190],"thread-161130":["thread",161130],"thread-161054":["thread",161054],"thread-161029":["thread",161029],"thread-161024":["thread",161024],"thread-161022":["thread",161022],"thread-161021":["thread",161021],"thread-161019":["thread",161019],"thread-161015":["thread",161015],"thread-161013":["thread",161013],"thread-161012":["thread",161012],"thread-161007":["thread",161007],"thread-161005":["thread",161005],"thread-161004":["thread",161004],"thread-161003":["thread",161003],"thread-161002":["thread",161002],"thread-161001":["thread",161001],"thread-160999":["thread",160999],"thread-160998":["thread",160998],"thread-160994":["thread",160994],"thread-160856":["thread",160856],"thread-159372":["thread",159372],"thread-159340":["thread",159340],"thread-159152":["thread",159152],"thread-159042":["thread",159042],"thread-159014":["thread",159014],"thread-158989":["thread",158989],"thread-158977":["thread",158977],"thread-158833":["thread",158833],"thread-158764":["thread",158764],"thread-158675":["thread",158675],"thread-158621":["thread",158621]}, , 1716174728
Run Time: 0.000218
- 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