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 (130917, 130385, 130363, 129853, 129784, 126867, 125278, 123383, 123372, 123168, 122742, 122741, 122403, 121591, 121396, 120552, 120510, 118975, 118541, 117061, 116268, 116215, 115973, 115046, 113569, 112221, 112010, 111975, 111956, 111904, 111459, 109847, 109287, 109254, 109106, 109094, 108992, 108768, 108647, 108287, 107853, 107389, 107162, 106878, 106715, 106239, 106158, 106086, 106020, 105865, 105801, 105782, 105780, 105779, 105691, 105688, 105435, 105106, 104998, 103918, 103716, 103256, 103183, 102628, 101778, 101050, 100991, 100785, 99947, 99770, 98475, 98111, 97982, 97650, 97192, 97092, 96777, 96734, 95500, 95357, 95126, 95077, 94918, 94780, 94742, 94655, 94596, 94195, 94111, 94047, 93710, 93549, 93386, 93198, 92052, 92008, 91677, 91582, 91461, 91336, 90245, 90214, 90034, 89633, 88829, 88243, 88222, 88097, 88067, 88000, 87944, 87885, 87632, 87573, 87544, 87293, 87272, 87136, 86732, 86709, 86455, 86403, 86339, 86312, 86242, 86113, 85763, 85731, 85247, 85011, 84993, 84552, 84532, 83784, 83699, 83595, 83302, 83288, 83259, 83189, 83036, 82844, 82794, 82735, 82734))
Run Time: 0.067813
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 145 | 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: 17411, 0, 1714889418, {"thread-130917":["thread",130917],"thread-130385":["thread",130385],"thread-130363":["thread",130363],"thread-129853":["thread",129853],"thread-129784":["thread",129784],"thread-126867":["thread",126867],"thread-125278":["thread",125278],"thread-123383":["thread",123383],"thread-123372":["thread",123372],"thread-123168":["thread",123168],"thread-122742":["thread",122742],"thread-122741":["thread",122741],"thread-122403":["thread",122403],"thread-121591":["thread",121591],"thread-121396":["thread",121396],"thread-120552":["thread",120552],"thread-120510":["thread",120510],"thread-118975":["thread",118975],"thread-118541":["thread",118541],"thread-117061":["thread",117061],"thread-116268":["thread",116268],"thread-116215":["thread",116215],"thread-115973":["thread",115973],"thread-115046":["thread",115046],"thread-113569":["thread",113569],"thread-112221":["thread",112221],"thread-112010":["thread",112010],"thread-111975":["thread",111975],"thread-111956":["thread",111956],"thread-111904":["thread",111904],"thread-111459":["thread",111459],"thread-109847":["thread",109847],"thread-109287":["thread",109287],"thread-109254":["thread",109254],"thread-109106":["thread",109106],"thread-109094":["thread",109094],"thread-108992":["thread",108992],"thread-108768":["thread",108768],"thread-108647":["thread",108647],"thread-108287":["thread",108287],"thread-107853":["thread",107853],"thread-107389":["thread",107389],"thread-107162":["thread",107162],"thread-106878":["thread",106878],"thread-106715":["thread",106715],"thread-106239":["thread",106239],"thread-106158":["thread",106158],"thread-106086":["thread",106086],"thread-106020":["thread",106020],"thread-105865":["thread",105865],"thread-105801":["thread",105801],"thread-105782":["thread",105782],"thread-105780":["thread",105780],"thread-105779":["thread",105779],"thread-105691":["thread",105691],"thread-105688":["thread",105688],"thread-105435":["thread",105435],"thread-105106":["thread",105106],"thread-104998":["thread",104998],"thread-103918":["thread",103918],"thread-103716":["thread",103716],"thread-103256":["thread",103256],"thread-103183":["thread",103183],"thread-102628":["thread",102628],"thread-101778":["thread",101778],"thread-101050":["thread",101050],"thread-100991":["thread",100991],"thread-100785":["thread",100785],"thread-99947":["thread",99947],"thread-99770":["thread",99770],"thread-98475":["thread",98475],"thread-98111":["thread",98111],"thread-97982":["thread",97982],"thread-97650":["thread",97650],"thread-97192":["thread",97192],"thread-97092":["thread",97092],"thread-96777":["thread",96777],"thread-96734":["thread",96734],"thread-95500":["thread",95500],"thread-95357":["thread",95357],"thread-95126":["thread",95126],"thread-95077":["thread",95077],"thread-94918":["thread",94918],"thread-94780":["thread",94780],"thread-94742":["thread",94742],"thread-94655":["thread",94655],"thread-94596":["thread",94596],"thread-94195":["thread",94195],"thread-94111":["thread",94111],"thread-94047":["thread",94047],"thread-93710":["thread",93710],"thread-93549":["thread",93549],"thread-93386":["thread",93386],"thread-93198":["thread",93198],"thread-92052":["thread",92052],"thread-92008":["thread",92008],"thread-91677":["thread",91677],"thread-91582":["thread",91582],"thread-91461":["thread",91461],"thread-91336":["thread",91336],"thread-90245":["thread",90245],"thread-90214":["thread",90214],"thread-90034":["thread",90034],"thread-89633":["thread",89633],"thread-88829":["thread",88829],"thread-88243":["thread",88243],"thread-88222":["thread",88222],"thread-88097":["thread",88097],"thread-88067":["thread",88067],"thread-88000":["thread",88000],"thread-87944":["thread",87944],"thread-87885":["thread",87885],"thread-87632":["thread",87632],"thread-87573":["thread",87573],"thread-87544":["thread",87544],"thread-87293":["thread",87293],"thread-87272":["thread",87272],"thread-87136":["thread",87136],"thread-86732":["thread",86732],"thread-86709":["thread",86709],"thread-86455":["thread",86455],"thread-86403":["thread",86403],"thread-86339":["thread",86339],"thread-86312":["thread",86312],"thread-86242":["thread",86242],"thread-86113":["thread",86113],"thread-85763":["thread",85763],"thread-85731":["thread",85731],"thread-85247":["thread",85247],"thread-85011":["thread",85011],"thread-84993":["thread",84993],"thread-84552":["thread",84552],"thread-84532":["thread",84532],"thread-83784":["thread",83784],"thread-83699":["thread",83699],"thread-83595":["thread",83595],"thread-83302":["thread",83302],"thread-83288":["thread",83288],"thread-83259":["thread",83259],"thread-83189":["thread",83189],"thread-83036":["thread",83036],"thread-82844":["thread",82844],"thread-82794":["thread",82794],"thread-82735":["thread",82735],"thread-82734":["thread",82734]}, , 1714885818
Run Time: 0.000572
- 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