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 (164858, 164819, 155256, 155251, 155243, 155242, 155240, 155152, 155128, 155126, 154917, 154858, 154854, 154850, 154849, 154846, 154560, 154559, 154477, 154057, 153983, 150455, 146651, 146649, 146634, 146631, 146630, 146535, 146343, 146323, 146321, 146320, 146195, 145957, 145946, 145846, 145833, 145831, 145830, 145823, 145818, 145780, 145744, 145742, 145700, 145698, 145695, 145630, 145546, 145033, 144891, 144887, 144778, 144673, 144670, 144420, 141572, 141209, 140870, 140631, 139721, 139238, 139236, 138691, 138680, 138615, 138613, 138611, 138610, 138607, 138606, 138139, 137977, 137953, 137365, 137360, 137355, 137344, 137337, 137215, 136743, 136731, 136672, 135315, 135039, 135038, 135031, 134967, 134880, 134739, 134737, 134736, 134735, 134677, 134666, 134606, 134602, 134598, 134596, 134594, 134521, 134398, 134209, 134061, 134057, 134053, 134051, 134045, 134042, 134039, 134034, 133825, 133822, 133820, 133816, 133814, 133811, 133731, 133677, 131779, 131768, 131702, 131694, 131692, 131691, 131690, 131682, 131680, 131537, 131225, 131224, 131208, 131163, 131162, 131161, 131160, 131159, 131158, 131157, 131156, 131155, 130534, 130468, 130467, 130462, 130416, 130413, 130302, 130244, 130222, 130194, 129961, 129937, 129934, 129925, 129743, 129595, 129594, 129565, 129307, 129210, 129205, 129194, 129192, 129117, 129112, 129111, 128500, 128483, 128482, 128355, 128345, 128342, 128293, 128281, 128162, 128122, 128121, 128099, 128098, 128068, 128052, 128032, 128031, 128018, 127960, 127899, 127693, 127662, 127660, 127659, 127658, 127621, 127618, 127520, 127496, 127424, 127276, 127202, 127191))
Run Time: 0.118781
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 31211, 0, 1714863998, {"thread-164858":["thread",164858],"thread-164819":["thread",164819],"thread-155256":["thread",155256],"thread-155251":["thread",155251],"thread-155243":["thread",155243],"thread-155242":["thread",155242],"thread-155240":["thread",155240],"thread-155152":["thread",155152],"thread-155128":["thread",155128],"thread-155126":["thread",155126],"thread-154917":["thread",154917],"thread-154858":["thread",154858],"thread-154854":["thread",154854],"thread-154850":["thread",154850],"thread-154849":["thread",154849],"thread-154846":["thread",154846],"thread-154560":["thread",154560],"thread-154559":["thread",154559],"thread-154477":["thread",154477],"thread-154057":["thread",154057],"thread-153983":["thread",153983],"thread-150455":["thread",150455],"thread-146651":["thread",146651],"thread-146649":["thread",146649],"thread-146634":["thread",146634],"thread-146631":["thread",146631],"thread-146630":["thread",146630],"thread-146535":["thread",146535],"thread-146343":["thread",146343],"thread-146323":["thread",146323],"thread-146321":["thread",146321],"thread-146320":["thread",146320],"thread-146195":["thread",146195],"thread-145957":["thread",145957],"thread-145946":["thread",145946],"thread-145846":["thread",145846],"thread-145833":["thread",145833],"thread-145831":["thread",145831],"thread-145830":["thread",145830],"thread-145823":["thread",145823],"thread-145818":["thread",145818],"thread-145780":["thread",145780],"thread-145744":["thread",145744],"thread-145742":["thread",145742],"thread-145700":["thread",145700],"thread-145698":["thread",145698],"thread-145695":["thread",145695],"thread-145630":["thread",145630],"thread-145546":["thread",145546],"thread-145033":["thread",145033],"thread-144891":["thread",144891],"thread-144887":["thread",144887],"thread-144778":["thread",144778],"thread-144673":["thread",144673],"thread-144670":["thread",144670],"thread-144420":["thread",144420],"thread-141572":["thread",141572],"thread-141209":["thread",141209],"thread-140870":["thread",140870],"thread-140631":["thread",140631],"thread-139721":["thread",139721],"thread-139238":["thread",139238],"thread-139236":["thread",139236],"thread-138691":["thread",138691],"thread-138680":["thread",138680],"thread-138615":["thread",138615],"thread-138613":["thread",138613],"thread-138611":["thread",138611],"thread-138610":["thread",138610],"thread-138607":["thread",138607],"thread-138606":["thread",138606],"thread-138139":["thread",138139],"thread-137977":["thread",137977],"thread-137953":["thread",137953],"thread-137365":["thread",137365],"thread-137360":["thread",137360],"thread-137355":["thread",137355],"thread-137344":["thread",137344],"thread-137337":["thread",137337],"thread-137215":["thread",137215],"thread-136743":["thread",136743],"thread-136731":["thread",136731],"thread-136672":["thread",136672],"thread-135315":["thread",135315],"thread-135039":["thread",135039],"thread-135038":["thread",135038],"thread-135031":["thread",135031],"thread-134967":["thread",134967],"thread-134880":["thread",134880],"thread-134739":["thread",134739],"thread-134737":["thread",134737],"thread-134736":["thread",134736],"thread-134735":["thread",134735],"thread-134677":["thread",134677],"thread-134666":["thread",134666],"thread-134606":["thread",134606],"thread-134602":["thread",134602],"thread-134598":["thread",134598],"thread-134596":["thread",134596],"thread-134594":["thread",134594],"thread-134521":["thread",134521],"thread-134398":["thread",134398],"thread-134209":["thread",134209],"thread-134061":["thread",134061],"thread-134057":["thread",134057],"thread-134053":["thread",134053],"thread-134051":["thread",134051],"thread-134045":["thread",134045],"thread-134042":["thread",134042],"thread-134039":["thread",134039],"thread-134034":["thread",134034],"thread-133825":["thread",133825],"thread-133822":["thread",133822],"thread-133820":["thread",133820],"thread-133816":["thread",133816],"thread-133814":["thread",133814],"thread-133811":["thread",133811],"thread-133731":["thread",133731],"thread-133677":["thread",133677],"thread-131779":["thread",131779],"thread-131768":["thread",131768],"thread-131702":["thread",131702],"thread-131694":["thread",131694],"thread-131692":["thread",131692],"thread-131691":["thread",131691],"thread-131690":["thread",131690],"thread-131682":["thread",131682],"thread-131680":["thread",131680],"thread-131537":["thread",131537],"thread-131225":["thread",131225],"thread-131224":["thread",131224],"thread-131208":["thread",131208],"thread-131163":["thread",131163],"thread-131162":["thread",131162],"thread-131161":["thread",131161],"thread-131160":["thread",131160],"thread-131159":["thread",131159],"thread-131158":["thread",131158],"thread-131157":["thread",131157],"thread-131156":["thread",131156],"thread-131155":["thread",131155],"thread-130534":["thread",130534],"thread-130468":["thread",130468],"thread-130467":["thread",130467],"thread-130462":["thread",130462],"thread-130416":["thread",130416],"thread-130413":["thread",130413],"thread-130302":["thread",130302],"thread-130244":["thread",130244],"thread-130222":["thread",130222],"thread-130194":["thread",130194],"thread-129961":["thread",129961],"thread-129937":["thread",129937],"thread-129934":["thread",129934],"thread-129925":["thread",129925],"thread-129743":["thread",129743],"thread-129595":["thread",129595],"thread-129594":["thread",129594],"thread-129565":["thread",129565],"thread-129307":["thread",129307],"thread-129210":["thread",129210],"thread-129205":["thread",129205],"thread-129194":["thread",129194],"thread-129192":["thread",129192],"thread-129117":["thread",129117],"thread-129112":["thread",129112],"thread-129111":["thread",129111],"thread-128500":["thread",128500],"thread-128483":["thread",128483],"thread-128482":["thread",128482],"thread-128355":["thread",128355],"thread-128345":["thread",128345],"thread-128342":["thread",128342],"thread-128293":["thread",128293],"thread-128281":["thread",128281],"thread-128162":["thread",128162],"thread-128122":["thread",128122],"thread-128121":["thread",128121],"thread-128099":["thread",128099],"thread-128098":["thread",128098],"thread-128068":["thread",128068],"thread-128052":["thread",128052],"thread-128032":["thread",128032],"thread-128031":["thread",128031],"thread-128018":["thread",128018],"thread-127960":["thread",127960],"thread-127899":["thread",127899],"thread-127693":["thread",127693],"thread-127662":["thread",127662],"thread-127660":["thread",127660],"thread-127659":["thread",127659],"thread-127658":["thread",127658],"thread-127621":["thread",127621],"thread-127618":["thread",127618],"thread-127520":["thread",127520],"thread-127496":["thread",127496],"thread-127424":["thread",127424],"thread-127276":["thread",127276],"thread-127202":["thread",127202],"thread-127191":["thread",127191]}, , 1714860398
Run Time: 0.000717
- 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