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 (113245, 113185, 113153, 112498, 110578, 110343, 110008, 110004, 109871, 108507, 108359, 108211, 108203, 107919, 107910, 107909, 107880, 107840, 107698, 107662, 107259, 106975, 106582, 106081, 105652, 104847, 104782, 104114, 102696, 100496, 100420, 100121, 100042, 99745, 99558, 98695, 98395, 98169, 98168, 97879, 97851, 97816, 97349, 97164, 97156, 97106, 97021, 96909, 96831, 96830, 96583, 96222, 96137, 96120, 96119, 96092, 96027, 95871, 95677, 95611, 95603, 95602, 95590, 95571, 94966, 94930, 94825, 93885, 93879, 93173, 93051, 92825, 92746, 92711, 92710, 92328, 92305, 92141, 91989, 91719, 91299, 90696, 90628, 90627, 89538, 89265, 88896, 88281, 88143, 88046, 87149, 87009, 86987, 86867, 86654, 86608, 86605, 86580, 86115, 86085, 86059, 85352, 85190, 85040, 84872, 84842, 84835, 84761, 84692, 84682, 84679, 84675, 84565, 84485, 84310, 84266, 84242, 84241, 83938, 83927, 83897, 83861, 83803, 83778, 83747, 83454, 83344, 83340, 83157, 82939, 82934, 82932, 82414, 82378, 82286, 81897, 81660, 80828, 79343, 79267, 77948, 76251, 15448))
Run Time: 0.132526
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 143 | 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: 15866, 0, 1715234167, {"thread-113245":["thread",113245],"thread-113185":["thread",113185],"thread-113153":["thread",113153],"thread-112498":["thread",112498],"thread-110578":["thread",110578],"thread-110343":["thread",110343],"thread-110008":["thread",110008],"thread-110004":["thread",110004],"thread-109871":["thread",109871],"thread-108507":["thread",108507],"thread-108359":["thread",108359],"thread-108211":["thread",108211],"thread-108203":["thread",108203],"thread-107919":["thread",107919],"thread-107910":["thread",107910],"thread-107909":["thread",107909],"thread-107880":["thread",107880],"thread-107840":["thread",107840],"thread-107698":["thread",107698],"thread-107662":["thread",107662],"thread-107259":["thread",107259],"thread-106975":["thread",106975],"thread-106582":["thread",106582],"thread-106081":["thread",106081],"thread-105652":["thread",105652],"thread-104847":["thread",104847],"thread-104782":["thread",104782],"thread-104114":["thread",104114],"thread-102696":["thread",102696],"thread-100496":["thread",100496],"thread-100420":["thread",100420],"thread-100121":["thread",100121],"thread-100042":["thread",100042],"thread-99745":["thread",99745],"thread-99558":["thread",99558],"thread-98695":["thread",98695],"thread-98395":["thread",98395],"thread-98169":["thread",98169],"thread-98168":["thread",98168],"thread-97879":["thread",97879],"thread-97851":["thread",97851],"thread-97816":["thread",97816],"thread-97349":["thread",97349],"thread-97164":["thread",97164],"thread-97156":["thread",97156],"thread-97106":["thread",97106],"thread-97021":["thread",97021],"thread-96909":["thread",96909],"thread-96831":["thread",96831],"thread-96830":["thread",96830],"thread-96583":["thread",96583],"thread-96222":["thread",96222],"thread-96137":["thread",96137],"thread-96120":["thread",96120],"thread-96119":["thread",96119],"thread-96092":["thread",96092],"thread-96027":["thread",96027],"thread-95871":["thread",95871],"thread-95677":["thread",95677],"thread-95611":["thread",95611],"thread-95603":["thread",95603],"thread-95602":["thread",95602],"thread-95590":["thread",95590],"thread-95571":["thread",95571],"thread-94966":["thread",94966],"thread-94930":["thread",94930],"thread-94825":["thread",94825],"thread-93885":["thread",93885],"thread-93879":["thread",93879],"thread-93173":["thread",93173],"thread-93051":["thread",93051],"thread-92825":["thread",92825],"thread-92746":["thread",92746],"thread-92711":["thread",92711],"thread-92710":["thread",92710],"thread-92328":["thread",92328],"thread-92305":["thread",92305],"thread-92141":["thread",92141],"thread-91989":["thread",91989],"thread-91719":["thread",91719],"thread-91299":["thread",91299],"thread-90696":["thread",90696],"thread-90628":["thread",90628],"thread-90627":["thread",90627],"thread-89538":["thread",89538],"thread-89265":["thread",89265],"thread-88896":["thread",88896],"thread-88281":["thread",88281],"thread-88143":["thread",88143],"thread-88046":["thread",88046],"thread-87149":["thread",87149],"thread-87009":["thread",87009],"thread-86987":["thread",86987],"thread-86867":["thread",86867],"thread-86654":["thread",86654],"thread-86608":["thread",86608],"thread-86605":["thread",86605],"thread-86580":["thread",86580],"thread-86115":["thread",86115],"thread-86085":["thread",86085],"thread-86059":["thread",86059],"thread-85352":["thread",85352],"thread-85190":["thread",85190],"thread-85040":["thread",85040],"thread-84872":["thread",84872],"thread-84842":["thread",84842],"thread-84835":["thread",84835],"thread-84761":["thread",84761],"thread-84692":["thread",84692],"thread-84682":["thread",84682],"thread-84679":["thread",84679],"thread-84675":["thread",84675],"thread-84565":["thread",84565],"thread-84485":["thread",84485],"thread-84310":["thread",84310],"thread-84266":["thread",84266],"thread-84242":["thread",84242],"thread-84241":["thread",84241],"thread-83938":["thread",83938],"thread-83927":["thread",83927],"thread-83897":["thread",83897],"thread-83861":["thread",83861],"thread-83803":["thread",83803],"thread-83778":["thread",83778],"thread-83747":["thread",83747],"thread-83454":["thread",83454],"thread-83344":["thread",83344],"thread-83340":["thread",83340],"thread-83157":["thread",83157],"thread-82939":["thread",82939],"thread-82934":["thread",82934],"thread-82932":["thread",82932],"thread-82414":["thread",82414],"thread-82378":["thread",82378],"thread-82286":["thread",82286],"thread-81897":["thread",81897],"thread-81660":["thread",81660],"thread-80828":["thread",80828],"thread-79343":["thread",79343],"thread-79267":["thread",79267],"thread-77948":["thread",77948],"thread-76251":["thread",76251],"thread-15448":["thread",15448]}, , 1715230567
Run Time: 0.000838
- 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