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 (183585, 183191, 183100, 182915, 181628, 181426, 181216, 180831, 180815, 180669, 179153, 178558, 178456, 178111, 178071, 177676, 177651, 177328, 176358, 176319, 176085, 176010, 175881, 175674, 174045, 173880, 172930, 172011, 171963, 171896, 171745, 171736, 171704, 171698, 171697, 171662, 171611, 171513, 171061, 170886, 170317, 170038, 170036, 169614, 169604, 169603, 168788, 168309, 167505, 167257, 166920, 166865, 166776, 166556, 166411, 166397, 166005, 165692, 165191, 165094, 163986, 163960, 163956, 163923, 163633, 163606, 163229, 161285, 160889, 160839, 160832, 160708, 160173, 160025, 159547, 159546, 159525, 158942, 158828, 158810, 158569, 158122, 158066, 157886, 157882, 157500, 157474, 157283, 157264, 157167, 156757, 156532, 156531, 156383, 156234, 156078, 155933, 155541, 155410, 155394, 155355, 155325, 155313, 155109, 154940, 154795, 154125, 153973, 153860, 153717, 153562, 153139, 153114, 152772, 151789, 149560, 140320, 140057, 139450, 129791, 127523, 123625, 123067, 120673, 119984, 117559, 114655, 112501, 108370, 107107, 104407, 103548, 102054, 101515, 93514, 93299, 90010, 89656, 78398, 78394, 58790, 58215, 53263, 49626, 30062, 29313, 27416, 27368, 17868, 3623, 2242, 2241))
Run Time: 0.078109
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 152 | 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: 598, 0, 1716112509, {"thread-183585":["thread",183585],"thread-183191":["thread",183191],"thread-183100":["thread",183100],"thread-182915":["thread",182915],"thread-181628":["thread",181628],"thread-181426":["thread",181426],"thread-181216":["thread",181216],"thread-180831":["thread",180831],"thread-180815":["thread",180815],"thread-180669":["thread",180669],"thread-179153":["thread",179153],"thread-178558":["thread",178558],"thread-178456":["thread",178456],"thread-178111":["thread",178111],"thread-178071":["thread",178071],"thread-177676":["thread",177676],"thread-177651":["thread",177651],"thread-177328":["thread",177328],"thread-176358":["thread",176358],"thread-176319":["thread",176319],"thread-176085":["thread",176085],"thread-176010":["thread",176010],"thread-175881":["thread",175881],"thread-175674":["thread",175674],"thread-174045":["thread",174045],"thread-173880":["thread",173880],"thread-172930":["thread",172930],"thread-172011":["thread",172011],"thread-171963":["thread",171963],"thread-171896":["thread",171896],"thread-171745":["thread",171745],"thread-171736":["thread",171736],"thread-171704":["thread",171704],"thread-171698":["thread",171698],"thread-171697":["thread",171697],"thread-171662":["thread",171662],"thread-171611":["thread",171611],"thread-171513":["thread",171513],"thread-171061":["thread",171061],"thread-170886":["thread",170886],"thread-170317":["thread",170317],"thread-170038":["thread",170038],"thread-170036":["thread",170036],"thread-169614":["thread",169614],"thread-169604":["thread",169604],"thread-169603":["thread",169603],"thread-168788":["thread",168788],"thread-168309":["thread",168309],"thread-167505":["thread",167505],"thread-167257":["thread",167257],"thread-166920":["thread",166920],"thread-166865":["thread",166865],"thread-166776":["thread",166776],"thread-166556":["thread",166556],"thread-166411":["thread",166411],"thread-166397":["thread",166397],"thread-166005":["thread",166005],"thread-165692":["thread",165692],"thread-165191":["thread",165191],"thread-165094":["thread",165094],"thread-163986":["thread",163986],"thread-163960":["thread",163960],"thread-163956":["thread",163956],"thread-163923":["thread",163923],"thread-163633":["thread",163633],"thread-163606":["thread",163606],"thread-163229":["thread",163229],"thread-161285":["thread",161285],"thread-160889":["thread",160889],"thread-160839":["thread",160839],"thread-160832":["thread",160832],"thread-160708":["thread",160708],"thread-160173":["thread",160173],"thread-160025":["thread",160025],"thread-159547":["thread",159547],"thread-159546":["thread",159546],"thread-159525":["thread",159525],"thread-158942":["thread",158942],"thread-158828":["thread",158828],"thread-158810":["thread",158810],"thread-158569":["thread",158569],"thread-158122":["thread",158122],"thread-158066":["thread",158066],"thread-157886":["thread",157886],"thread-157882":["thread",157882],"thread-157500":["thread",157500],"thread-157474":["thread",157474],"thread-157283":["thread",157283],"thread-157264":["thread",157264],"thread-157167":["thread",157167],"thread-156757":["thread",156757],"thread-156532":["thread",156532],"thread-156531":["thread",156531],"thread-156383":["thread",156383],"thread-156234":["thread",156234],"thread-156078":["thread",156078],"thread-155933":["thread",155933],"thread-155541":["thread",155541],"thread-155410":["thread",155410],"thread-155394":["thread",155394],"thread-155355":["thread",155355],"thread-155325":["thread",155325],"thread-155313":["thread",155313],"thread-155109":["thread",155109],"thread-154940":["thread",154940],"thread-154795":["thread",154795],"thread-154125":["thread",154125],"thread-153973":["thread",153973],"thread-153860":["thread",153860],"thread-153717":["thread",153717],"thread-153562":["thread",153562],"thread-153139":["thread",153139],"thread-153114":["thread",153114],"thread-152772":["thread",152772],"thread-151789":["thread",151789],"thread-149560":["thread",149560],"thread-140320":["thread",140320],"thread-140057":["thread",140057],"thread-139450":["thread",139450],"thread-129791":["thread",129791],"thread-127523":["thread",127523],"thread-123625":["thread",123625],"thread-123067":["thread",123067],"thread-120673":["thread",120673],"thread-119984":["thread",119984],"thread-117559":["thread",117559],"thread-114655":["thread",114655],"thread-112501":["thread",112501],"thread-108370":["thread",108370],"thread-107107":["thread",107107],"thread-104407":["thread",104407],"thread-103548":["thread",103548],"thread-102054":["thread",102054],"thread-101515":["thread",101515],"thread-93514":["thread",93514],"thread-93299":["thread",93299],"thread-90010":["thread",90010],"thread-89656":["thread",89656],"thread-78398":["thread",78398],"thread-78394":["thread",78394],"thread-58790":["thread",58790],"thread-58215":["thread",58215],"thread-53263":["thread",53263],"thread-49626":["thread",49626],"thread-30062":["thread",30062],"thread-29313":["thread",29313],"thread-27416":["thread",27416],"thread-27368":["thread",27368],"thread-17868":["thread",17868],"thread-3623":["thread",3623],"thread-2242":["thread",2242],"thread-2241":["thread",2241]}, , 1716108909
Run Time: 0.000499
- 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