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 (18880, 14581, 14554, 14297, 14296, 14294, 14293, 14131, 13875, 13794, 13793, 13733, 13731, 13729, 13726, 13498, 13497, 13474, 13470, 13382, 13381, 13323, 13251, 13214, 13041, 12902, 12854, 12853, 12828, 12726, 12433, 12432, 12214, 12085, 12014, 11944, 11830, 11796, 11785, 11726, 11724, 11644, 11607, 11593, 11585, 11557, 11518, 11517, 11457, 11446, 11435, 11429, 11402, 11400, 11394, 11383, 11371, 11369, 11363, 11360, 11347, 11346, 11340, 11332, 11329, 11309, 11296, 11295, 11290, 11275, 11265, 11247, 11224, 11200, 11178, 11167, 11159, 11152, 11148, 11147, 11129, 11121, 11113, 11080, 11075, 11072, 11064, 11031, 11028, 11022, 11012, 10964, 10942, 10899, 10897, 10892, 10820, 10753, 10688, 10687, 10686, 10679, 10676, 10633, 10620, 10619, 10598, 10590, 10579, 10576, 10550, 10533, 10532, 10530, 10527, 10520, 10505, 10503, 10502, 10501, 10495, 10482, 10480, 10474, 10467, 10461, 10444, 10442, 10441, 10439, 10424, 10423, 10414, 10412, 10403, 10401, 10384, 10374, 10373, 10367, 10365, 10364, 10362, 10359, 10357, 10356, 10335, 10272, 10261, 10259, 10214, 10201, 10199, 10173, 10102, 10096, 10076, 10072, 10048, 10042, 10036, 9710, 9599, 9541, 9425, 9293, 9291, 9290, 9289, 9287, 9202, 9172, 9170, 9136, 9131, 9095, 8980, 8835, 8829, 8808, 8762, 8754, 8669, 8651, 8643, 8640, 8631, 8597, 8565, 8533, 8336, 8294, 8282, 8241, 8198, 8197, 8196, 8195, 8184, 8117))
Run Time: 0.004950
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 | foru_12.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | foru_12.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,foru_12.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 13, 0, 1716099006, {"thread-18880":["thread",18880],"thread-14581":["thread",14581],"thread-14554":["thread",14554],"thread-14297":["thread",14297],"thread-14296":["thread",14296],"thread-14294":["thread",14294],"thread-14293":["thread",14293],"thread-14131":["thread",14131],"thread-13875":["thread",13875],"thread-13794":["thread",13794],"thread-13793":["thread",13793],"thread-13733":["thread",13733],"thread-13731":["thread",13731],"thread-13729":["thread",13729],"thread-13726":["thread",13726],"thread-13498":["thread",13498],"thread-13497":["thread",13497],"thread-13474":["thread",13474],"thread-13470":["thread",13470],"thread-13382":["thread",13382],"thread-13381":["thread",13381],"thread-13323":["thread",13323],"thread-13251":["thread",13251],"thread-13214":["thread",13214],"thread-13041":["thread",13041],"thread-12902":["thread",12902],"thread-12854":["thread",12854],"thread-12853":["thread",12853],"thread-12828":["thread",12828],"thread-12726":["thread",12726],"thread-12433":["thread",12433],"thread-12432":["thread",12432],"thread-12214":["thread",12214],"thread-12085":["thread",12085],"thread-12014":["thread",12014],"thread-11944":["thread",11944],"thread-11830":["thread",11830],"thread-11796":["thread",11796],"thread-11785":["thread",11785],"thread-11726":["thread",11726],"thread-11724":["thread",11724],"thread-11644":["thread",11644],"thread-11607":["thread",11607],"thread-11593":["thread",11593],"thread-11585":["thread",11585],"thread-11557":["thread",11557],"thread-11518":["thread",11518],"thread-11517":["thread",11517],"thread-11457":["thread",11457],"thread-11446":["thread",11446],"thread-11435":["thread",11435],"thread-11429":["thread",11429],"thread-11402":["thread",11402],"thread-11400":["thread",11400],"thread-11394":["thread",11394],"thread-11383":["thread",11383],"thread-11371":["thread",11371],"thread-11369":["thread",11369],"thread-11363":["thread",11363],"thread-11360":["thread",11360],"thread-11347":["thread",11347],"thread-11346":["thread",11346],"thread-11340":["thread",11340],"thread-11332":["thread",11332],"thread-11329":["thread",11329],"thread-11309":["thread",11309],"thread-11296":["thread",11296],"thread-11295":["thread",11295],"thread-11290":["thread",11290],"thread-11275":["thread",11275],"thread-11265":["thread",11265],"thread-11247":["thread",11247],"thread-11224":["thread",11224],"thread-11200":["thread",11200],"thread-11178":["thread",11178],"thread-11167":["thread",11167],"thread-11159":["thread",11159],"thread-11148":["thread",11148],"thread-11147":["thread",11147],"thread-11129":["thread",11129],"thread-11121":["thread",11121],"thread-11113":["thread",11113],"thread-11080":["thread",11080],"thread-11075":["thread",11075],"thread-11072":["thread",11072],"thread-11064":["thread",11064],"thread-11031":["thread",11031],"thread-11028":["thread",11028],"thread-11022":["thread",11022],"thread-11012":["thread",11012],"thread-10964":["thread",10964],"thread-10942":["thread",10942],"thread-10899":["thread",10899],"thread-10897":["thread",10897],"thread-10892":["thread",10892],"thread-10820":["thread",10820],"thread-10753":["thread",10753],"thread-10688":["thread",10688],"thread-10687":["thread",10687],"thread-10686":["thread",10686],"thread-10676":["thread",10676],"thread-10633":["thread",10633],"thread-10620":["thread",10620],"thread-10619":["thread",10619],"thread-10598":["thread",10598],"thread-10590":["thread",10590],"thread-10579":["thread",10579],"thread-10576":["thread",10576],"thread-10550":["thread",10550],"thread-10533":["thread",10533],"thread-10530":["thread",10530],"thread-10527":["thread",10527],"thread-10520":["thread",10520],"thread-10505":["thread",10505],"thread-10503":["thread",10503],"thread-10502":["thread",10502],"thread-10501":["thread",10501],"thread-10495":["thread",10495],"thread-10482":["thread",10482],"thread-10480":["thread",10480],"thread-10474":["thread",10474],"thread-10467":["thread",10467],"thread-10461":["thread",10461],"thread-10444":["thread",10444],"thread-10442":["thread",10442],"thread-10441":["thread",10441],"thread-10439":["thread",10439],"thread-10424":["thread",10424],"thread-10423":["thread",10423],"thread-10414":["thread",10414],"thread-10412":["thread",10412],"thread-10403":["thread",10403],"thread-10401":["thread",10401],"thread-10384":["thread",10384],"thread-10374":["thread",10374],"thread-10373":["thread",10373],"thread-10367":["thread",10367],"thread-10365":["thread",10365],"thread-10364":["thread",10364],"thread-10362":["thread",10362],"thread-10359":["thread",10359],"thread-10357":["thread",10357],"thread-10356":["thread",10356],"thread-10335":["thread",10335],"thread-10272":["thread",10272],"thread-10261":["thread",10261],"thread-10259":["thread",10259],"thread-10214":["thread",10214],"thread-10201":["thread",10201],"thread-10199":["thread",10199],"thread-10173":["thread",10173],"thread-10102":["thread",10102],"thread-10096":["thread",10096],"thread-10076":["thread",10076],"thread-10072":["thread",10072],"thread-10048":["thread",10048],"thread-10042":["thread",10042],"thread-10036":["thread",10036],"thread-9710":["thread",9710],"thread-9599":["thread",9599],"thread-9541":["thread",9541],"thread-9425":["thread",9425],"thread-9293":["thread",9293],"thread-9291":["thread",9291],"thread-9290":["thread",9290],"thread-9289":["thread",9289],"thread-9287":["thread",9287],"thread-9202":["thread",9202],"thread-9172":["thread",9172],"thread-9170":["thread",9170],"thread-9136":["thread",9136],"thread-9131":["thread",9131],"thread-9095":["thread",9095],"thread-8980":["thread",8980],"thread-8835":["thread",8835],"thread-8829":["thread",8829],"thread-8808":["thread",8808],"thread-8762":["thread",8762],"thread-8754":["thread",8754],"thread-8669":["thread",8669],"thread-8643":["thread",8643],"thread-8640":["thread",8640],"thread-8631":["thread",8631],"thread-8597":["thread",8597],"thread-8565":["thread",8565],"thread-8533":["thread",8533],"thread-8336":["thread",8336],"thread-8282":["thread",8282],"thread-8241":["thread",8241],"thread-8198":["thread",8198],"thread-8197":["thread",8197],"thread-8196":["thread",8196],"thread-8195":["thread",8195],"thread-8184":["thread",8184],"thread-8117":["thread",8117]}, NULL, 1716095406
Run Time: 0.000158
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20