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 (219883, 219718, 219259, 219133, 219040, 218539, 218176, 217819, 217201, 216406, 216346, 216307, 216271, 215230, 215200, 214414, 214255, 213529, 213121, 212782, 212302, 212161, 211906, 210205, 210011, 208561, 207268, 206707, 206521, 206311, 205486, 204364, 203908, 203287, 203020, 202858, 202567, 202051, 200995, 200689, 199951, 199948, 199198, 198070, 198064, 196399, 196222, 195121, 195046, 194986, 193648, 192448, 189043, 188668, 187708, 186772, 185608, 183784, 183460, 182662, 182614, 182308, 181747, 181141, 181003, 180826, 176872, 176647, 176362, 176023, 175705, 174163, 173842, 173494, 173431, 172108, 171767, 171059, 169053, 168429, 166854, 166398, 165920, 165264, 165255, 165204, 164758, 162208, 161425, 160348, 157039, 155083, 154579, 153847, 152440, 151672, 150277, 149602, 147971, 147368, 146246, 145295, 144944, 143384, 141195, 140202, 139659, 136362, 135456, 135023, 134228, 134003, 132857, 131552, 131354, 131297, 131216, 130946, 130475, 129743, 129668, 129436, 129334, 128908, 128503, 127936, 127790, 127371, 127271, 127052, 126445, 126415, 125921, 125627, 125476, 125361, 125263, 125253, 124988, 124688, 123723, 123515, 123450, 123325, 122825, 122692, 122186, 122045, 121896, 120948, 120654, 120511, 120277, 119949, 119863, 118813, 118689, 117896, 117538, 117468, 117347, 117016, 116724, 116718, 116708, 116665, 116594, 116276, 115886, 115768, 115317, 115262, 115007, 114988, 114891, 113668, 113560, 113415, 113306, 112822, 112688, 112565, 112489, 112355, 112181, 111920, 111797, 111796, 111503, 111458, 111448, 111435, 111376, 111203, 111054, 110923, 110879, 110795, 110792, 110632, 110566, 110531, 110529, 110343, 110252, 110007, 109979, 109923, 109701, 109408, 109365, 108649, 108644, 108443, 108197, 108045, 108033, 107600, 107411, 107127, 106983, 106687, 106570, 106318, 106311, 105697, 105591, 105533, 105171, 105119, 105027, 104998, 104434, 104374, 104233, 104220, 103674, 103225, 103108, 103095, 102880, 102835, 102775, 102463, 101679, 101070, 100809, 100754, 100724, 100722, 100697, 100569, 100557, 100297, 100269, 100095, 99989, 99363, 98891, 98217, 97980, 97908, 97844, 97450, 97392, 97370, 97304, 96925, 96653, 96085, 95567, 95395, 95343, 95231, 94999, 94982, 94759, 94559, 94532, 94345, 94213, 93738, 93347, 93292, 93096, 92850, 92101, 91988, 91798, 91721, 91425, 91045))
Run Time: 0.010004
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 292 | 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: 106, 0, 1716307811, {"thread-219883":["thread",219883],"thread-219718":["thread",219718],"thread-219259":["thread",219259],"thread-219133":["thread",219133],"thread-219040":["thread",219040],"thread-218539":["thread",218539],"thread-218176":["thread",218176],"thread-217819":["thread",217819],"thread-217201":["thread",217201],"thread-216406":["thread",216406],"thread-216346":["thread",216346],"thread-216307":["thread",216307],"thread-216271":["thread",216271],"thread-215230":["thread",215230],"thread-215200":["thread",215200],"thread-214414":["thread",214414],"thread-214255":["thread",214255],"thread-213529":["thread",213529],"thread-213121":["thread",213121],"thread-212782":["thread",212782],"thread-212302":["thread",212302],"thread-212161":["thread",212161],"thread-211906":["thread",211906],"thread-210205":["thread",210205],"thread-210011":["thread",210011],"thread-208561":["thread",208561],"thread-207268":["thread",207268],"thread-206707":["thread",206707],"thread-206521":["thread",206521],"thread-206311":["thread",206311],"thread-205486":["thread",205486],"thread-204364":["thread",204364],"thread-203908":["thread",203908],"thread-203287":["thread",203287],"thread-203020":["thread",203020],"thread-202858":["thread",202858],"thread-202567":["thread",202567],"thread-202051":["thread",202051],"thread-200995":["thread",200995],"thread-200689":["thread",200689],"thread-199951":["thread",199951],"thread-199948":["thread",199948],"thread-199198":["thread",199198],"thread-198070":["thread",198070],"thread-198064":["thread",198064],"thread-196399":["thread",196399],"thread-196222":["thread",196222],"thread-195121":["thread",195121],"thread-195046":["thread",195046],"thread-194986":["thread",194986],"thread-193648":["thread",193648],"thread-192448":["thread",192448],"thread-189043":["thread",189043],"thread-188668":["thread",188668],"thread-187708":["thread",187708],"thread-186772":["thread",186772],"thread-185608":["thread",185608],"thread-183784":["thread",183784],"thread-183460":["thread",183460],"thread-182662":["thread",182662],"thread-182614":["thread",182614],"thread-182308":["thread",182308],"thread-181747":["thread",181747],"thread-181141":["thread",181141],"thread-181003":["thread",181003],"thread-180826":["thread",180826],"thread-176872":["thread",176872],"thread-176647":["thread",176647],"thread-176362":["thread",176362],"thread-176023":["thread",176023],"thread-175705":["thread",175705],"thread-174163":["thread",174163],"thread-173842":["thread",173842],"thread-173494":["thread",173494],"thread-173431":["thread",173431],"thread-172108":["thread",172108],"thread-171767":["thread",171767],"thread-171059":["thread",171059],"thread-169053":["thread",169053],"thread-168429":["thread",168429],"thread-166854":["thread",166854],"thread-166398":["thread",166398],"thread-165920":["thread",165920],"thread-165264":["thread",165264],"thread-165255":["thread",165255],"thread-165204":["thread",165204],"thread-164758":["thread",164758],"thread-162208":["thread",162208],"thread-161425":["thread",161425],"thread-160348":["thread",160348],"thread-157039":["thread",157039],"thread-155083":["thread",155083],"thread-154579":["thread",154579],"thread-153847":["thread",153847],"thread-152440":["thread",152440],"thread-151672":["thread",151672],"thread-150277":["thread",150277],"thread-149602":["thread",149602],"thread-147971":["thread",147971],"thread-147368":["thread",147368],"thread-146246":["thread",146246],"thread-145295":["thread",145295],"thread-144944":["thread",144944],"thread-143384":["thread",143384],"thread-141195":["thread",141195],"thread-140202":["thread",140202],"thread-139659":["thread",139659],"thread-136362":["thread",136362],"thread-135456":["thread",135456],"thread-135023":["thread",135023],"thread-134228":["thread",134228],"thread-134003":["thread",134003],"thread-132857":["thread",132857],"thread-131552":["thread",131552],"thread-131354":["thread",131354],"thread-131297":["thread",131297],"thread-131216":["thread",131216],"thread-130946":["thread",130946],"thread-130475":["thread",130475],"thread-129743":["thread",129743],"thread-129668":["thread",129668],"thread-129436":["thread",129436],"thread-129334":["thread",129334],"thread-128908":["thread",128908],"thread-128503":["thread",128503],"thread-127936":["thread",127936],"thread-127790":["thread",127790],"thread-127371":["thread",127371],"thread-127271":["thread",127271],"thread-127052":["thread",127052],"thread-126445":["thread",126445],"thread-126415":["thread",126415],"thread-125921":["thread",125921],"thread-125627":["thread",125627],"thread-125476":["thread",125476],"thread-125361":["thread",125361],"thread-125263":["thread",125263],"thread-125253":["thread",125253],"thread-124988":["thread",124988],"thread-124688":["thread",124688],"thread-123723":["thread",123723],"thread-123515":["thread",123515],"thread-123450":["thread",123450],"thread-123325":["thread",123325],"thread-122825":["thread",122825],"thread-122692":["thread",122692],"thread-122186":["thread",122186],"thread-122045":["thread",122045],"thread-121896":["thread",121896],"thread-120948":["thread",120948],"thread-120654":["thread",120654],"thread-120511":["thread",120511],"thread-120277":["thread",120277],"thread-119949":["thread",119949],"thread-119863":["thread",119863],"thread-118813":["thread",118813],"thread-118689":["thread",118689],"thread-117896":["thread",117896],"thread-117538":["thread",117538],"thread-117468":["thread",117468],"thread-117347":["thread",117347],"thread-117016":["thread",117016],"thread-116724":["thread",116724],"thread-116718":["thread",116718],"thread-116708":["thread",116708],"thread-116665":["thread",116665],"thread-116594":["thread",116594],"thread-116276":["thread",116276],"thread-115886":["thread",115886],"thread-115768":["thread",115768],"thread-115317":["thread",115317],"thread-115262":["thread",115262],"thread-115007":["thread",115007],"thread-114988":["thread",114988],"thread-114891":["thread",114891],"thread-113668":["thread",113668],"thread-113560":["thread",113560],"thread-113415":["thread",113415],"thread-113306":["thread",113306],"thread-112822":["thread",112822],"thread-112688":["thread",112688],"thread-112565":["thread",112565],"thread-112489":["thread",112489],"thread-112355":["thread",112355],"thread-112181":["thread",112181],"thread-111920":["thread",111920],"thread-111797":["thread",111797],"thread-111796":["thread",111796],"thread-111503":["thread",111503],"thread-111458":["thread",111458],"thread-111448":["thread",111448],"thread-111435":["thread",111435],"thread-111376":["thread",111376],"thread-111203":["thread",111203],"thread-111054":["thread",111054],"thread-110923":["thread",110923],"thread-110879":["thread",110879],"thread-110795":["thread",110795],"thread-110792":["thread",110792],"thread-110632":["thread",110632],"thread-110566":["thread",110566],"thread-110531":["thread",110531],"thread-110529":["thread",110529],"thread-110343":["thread",110343],"thread-110252":["thread",110252],"thread-110007":["thread",110007],"thread-109979":["thread",109979],"thread-109923":["thread",109923],"thread-109701":["thread",109701],"thread-109408":["thread",109408],"thread-109365":["thread",109365],"thread-108649":["thread",108649],"thread-108644":["thread",108644],"thread-108443":["thread",108443],"thread-108197":["thread",108197],"thread-108045":["thread",108045],"thread-108033":["thread",108033],"thread-107600":["thread",107600],"thread-107411":["thread",107411],"thread-107127":["thread",107127],"thread-106983":["thread",106983],"thread-106687":["thread",106687],"thread-106570":["thread",106570],"thread-106318":["thread",106318],"thread-106311":["thread",106311],"thread-105697":["thread",105697],"thread-105591":["thread",105591],"thread-105533":["thread",105533],"thread-105171":["thread",105171],"thread-105119":["thread",105119],"thread-105027":["thread",105027],"thread-104998":["thread",104998],"thread-104434":["thread",104434],"thread-104374":["thread",104374],"thread-104233":["thread",104233],"thread-104220":["thread",104220],"thread-103674":["thread",103674],"thread-103225":["thread",103225],"thread-103108":["thread",103108],"thread-103095":["thread",103095],"thread-102880":["thread",102880],"thread-102835":["thread",102835],"thread-102775":["thread",102775],"thread-102463":["thread",102463],"thread-101679":["thread",101679],"thread-101070":["thread",101070],"thread-100809":["thread",100809],"thread-100754":["thread",100754],"thread-100724":["thread",100724],"thread-100722":["thread",100722],"thread-100697":["thread",100697],"thread-100569":["thread",100569],"thread-100557":["thread",100557],"thread-100297":["thread",100297],"thread-100269":["thread",100269],"thread-100095":["thread",100095],"thread-99989":["thread",99989],"thread-99363":["thread",99363],"thread-98891":["thread",98891],"thread-98217":["thread",98217],"thread-97980":["thread",97980],"thread-97908":["thread",97908],"thread-97844":["thread",97844],"thread-97450":["thread",97450],"thread-97392":["thread",97392],"thread-97370":["thread",97370],"thread-97304":["thread",97304],"thread-96925":["thread",96925],"thread-96653":["thread",96653],"thread-96085":["thread",96085],"thread-95567":["thread",95567],"thread-95395":["thread",95395],"thread-95343":["thread",95343],"thread-95231":["thread",95231],"thread-94999":["thread",94999],"thread-94982":["thread",94982],"thread-94759":["thread",94759],"thread-94559":["thread",94559],"thread-94532":["thread",94532],"thread-94345":["thread",94345],"thread-94213":["thread",94213],"thread-93738":["thread",93738],"thread-93347":["thread",93347],"thread-93292":["thread",93292],"thread-93096":["thread",93096],"thread-92850":["thread",92850],"thread-92101":["thread",92101],"thread-91988":["thread",91988],"thread-91798":["thread",91798],"thread-91721":["thread",91721],"thread-91425":["thread",91425],"thread-91045":["thread",91045]}, , 1716304211
Run Time: 0.000687
- 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