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 (182081, 182032, 181706, 181594, 181230, 180510, 180291, 180207, 179811, 179060, 179056, 178226, 178110, 178095, 177848, 177847, 158359, 106904, 105126, 104037, 103245, 102369, 101504, 101373, 97548, 97080, 94605, 94449, 94375, 88614, 86765, 85719, 85670, 85644, 85206, 84962, 84955, 84494, 84357, 84290, 83339, 83284, 82907, 82802, 81566, 81389, 80555, 80371, 79192, 79159, 78882, 78817, 78588, 78450, 77506, 77434, 77172, 75930, 75627, 75536, 75501, 75254, 74607, 74382, 74304, 72806, 72378, 71654, 71151, 69459, 69428, 69258, 69135, 68813, 68769, 68490, 67400, 67312, 67286, 67084, 66996, 66952, 65052, 64763, 63953, 63867, 63864, 63680, 63429, 63262, 62627, 62166, 61671, 60964, 60876, 60318, 59512, 59455, 59340, 59240, 56146, 55935, 55682, 55410, 55162, 51729, 51142, 50935, 50203, 50114, 49960, 49687, 48514, 47682, 47343, 45976, 45456, 45078, 44644, 44244, 43809, 36435, 33497, 30259, 30180, 30043, 29080, 28607, 28528, 26553, 25668, 18492, 10716, 5098))
Run Time: 0.104308
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 134 | 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: 1107, 0, 1716011582, {"thread-182081":["thread",182081],"thread-182032":["thread",182032],"thread-181706":["thread",181706],"thread-181594":["thread",181594],"thread-181230":["thread",181230],"thread-180510":["thread",180510],"thread-180291":["thread",180291],"thread-180207":["thread",180207],"thread-179811":["thread",179811],"thread-179060":["thread",179060],"thread-179056":["thread",179056],"thread-178226":["thread",178226],"thread-178110":["thread",178110],"thread-178095":["thread",178095],"thread-177848":["thread",177848],"thread-177847":["thread",177847],"thread-158359":["thread",158359],"thread-106904":["thread",106904],"thread-105126":["thread",105126],"thread-104037":["thread",104037],"thread-103245":["thread",103245],"thread-102369":["thread",102369],"thread-101504":["thread",101504],"thread-101373":["thread",101373],"thread-97548":["thread",97548],"thread-97080":["thread",97080],"thread-94605":["thread",94605],"thread-94449":["thread",94449],"thread-94375":["thread",94375],"thread-88614":["thread",88614],"thread-86765":["thread",86765],"thread-85719":["thread",85719],"thread-85670":["thread",85670],"thread-85644":["thread",85644],"thread-85206":["thread",85206],"thread-84962":["thread",84962],"thread-84955":["thread",84955],"thread-84494":["thread",84494],"thread-84357":["thread",84357],"thread-84290":["thread",84290],"thread-83339":["thread",83339],"thread-83284":["thread",83284],"thread-82907":["thread",82907],"thread-82802":["thread",82802],"thread-81566":["thread",81566],"thread-81389":["thread",81389],"thread-80555":["thread",80555],"thread-80371":["thread",80371],"thread-79192":["thread",79192],"thread-79159":["thread",79159],"thread-78882":["thread",78882],"thread-78817":["thread",78817],"thread-78588":["thread",78588],"thread-78450":["thread",78450],"thread-77506":["thread",77506],"thread-77434":["thread",77434],"thread-77172":["thread",77172],"thread-75930":["thread",75930],"thread-75627":["thread",75627],"thread-75536":["thread",75536],"thread-75501":["thread",75501],"thread-75254":["thread",75254],"thread-74607":["thread",74607],"thread-74382":["thread",74382],"thread-74304":["thread",74304],"thread-72806":["thread",72806],"thread-72378":["thread",72378],"thread-71654":["thread",71654],"thread-71151":["thread",71151],"thread-69459":["thread",69459],"thread-69428":["thread",69428],"thread-69258":["thread",69258],"thread-69135":["thread",69135],"thread-68813":["thread",68813],"thread-68769":["thread",68769],"thread-68490":["thread",68490],"thread-67400":["thread",67400],"thread-67312":["thread",67312],"thread-67286":["thread",67286],"thread-67084":["thread",67084],"thread-66996":["thread",66996],"thread-66952":["thread",66952],"thread-65052":["thread",65052],"thread-64763":["thread",64763],"thread-63953":["thread",63953],"thread-63867":["thread",63867],"thread-63864":["thread",63864],"thread-63680":["thread",63680],"thread-63429":["thread",63429],"thread-63262":["thread",63262],"thread-62627":["thread",62627],"thread-62166":["thread",62166],"thread-61671":["thread",61671],"thread-60964":["thread",60964],"thread-60876":["thread",60876],"thread-60318":["thread",60318],"thread-59512":["thread",59512],"thread-59455":["thread",59455],"thread-59340":["thread",59340],"thread-59240":["thread",59240],"thread-56146":["thread",56146],"thread-55935":["thread",55935],"thread-55682":["thread",55682],"thread-55410":["thread",55410],"thread-55162":["thread",55162],"thread-51729":["thread",51729],"thread-51142":["thread",51142],"thread-50935":["thread",50935],"thread-50203":["thread",50203],"thread-50114":["thread",50114],"thread-49960":["thread",49960],"thread-49687":["thread",49687],"thread-48514":["thread",48514],"thread-47682":["thread",47682],"thread-47343":["thread",47343],"thread-45976":["thread",45976],"thread-45456":["thread",45456],"thread-45078":["thread",45078],"thread-44644":["thread",44644],"thread-44244":["thread",44244],"thread-43809":["thread",43809],"thread-36435":["thread",36435],"thread-33497":["thread",33497],"thread-30259":["thread",30259],"thread-30180":["thread",30180],"thread-30043":["thread",30043],"thread-29080":["thread",29080],"thread-28607":["thread",28607],"thread-28528":["thread",28528],"thread-26553":["thread",26553],"thread-25668":["thread",25668],"thread-18492":["thread",18492],"thread-10716":["thread",10716],"thread-5098":["thread",5098]}, , 1716007982
Run Time: 0.000579
- 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