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 (4223388, 4223381, 4223378, 4223377, 4223366, 4223357, 4223345, 4223334, 4223328, 4223322, 4223311, 4223293, 4223264, 4223261, 4223253, 4223251, 4223238, 4223225, 4223209, 4223207, 4223188, 4223179, 4223169, 4223154, 4223153, 4223152, 4223151, 4223150, 4223149, 4223148, 4223147, 4223146, 4223145, 4223144, 4223143, 4223142, 4223141, 4223140, 4223139, 4223138, 4223137, 4223136, 4223135, 4223134, 4223133, 4223132, 4223131, 4223130, 4223129, 4223128, 4223127, 4223126, 4223125, 4223124, 4223123, 4223122, 4223121, 4223120, 4223119, 4223118, 4223117, 4223116, 4223115, 4223114, 4223113, 4223112, 4223111, 4223110, 4223109, 4223108, 4223107, 4223106, 4223105, 4223104, 4223103, 4223102, 4223101, 4223100, 4223099, 4223098, 4223097, 4223096, 4223095, 4223094, 4223093, 4223092, 4223091, 4223090, 4223089, 4223088, 4223087, 4223086, 4223085, 4223084, 4223083, 4223082, 4223081, 4223080, 4223079, 4223078, 4223077, 4223076, 4223075, 4222567, 4223074, 4222563, 4222548, 4222534, 4222509, 4222489, 4222458, 4222456, 4222451, 4222472, 4222471, 4223073, 4222470, 4222469, 4223072, 4222468, 4222467, 4222466, 4223071, 4223070, 4223069, 4222400, 4222396, 4222388, 4222387, 4222376, 4222364, 4222354, 4222350, 4223068, 4223067, 4223066, 4223065, 4223064, 4223063, 4223062, 4223061, 4223060, 4223059, 4223058, 4223057, 4223056, 4223055, 4223054, 4223053, 4223052, 4223051, 4223050, 4223049, 4223048))
Run Time: 0.018824
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 154 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | thesims.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | thesims.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | thesims.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | thesims.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,thesims.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2710
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- 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: 424, 0, 1715592173, {"thread-4223388":["thread",4223388],"thread-4223381":["thread",4223381],"thread-4223378":["thread",4223378],"thread-4223377":["thread",4223377],"thread-4223366":["thread",4223366],"thread-4223357":["thread",4223357],"thread-4223345":["thread",4223345],"thread-4223334":["thread",4223334],"thread-4223328":["thread",4223328],"thread-4223322":["thread",4223322],"thread-4223311":["thread",4223311],"thread-4223293":["thread",4223293],"thread-4223264":["thread",4223264],"thread-4223261":["thread",4223261],"thread-4223253":["thread",4223253],"thread-4223251":["thread",4223251],"thread-4223238":["thread",4223238],"thread-4223225":["thread",4223225],"thread-4223209":["thread",4223209],"thread-4223207":["thread",4223207],"thread-4223188":["thread",4223188],"thread-4223179":["thread",4223179],"thread-4223169":["thread",4223169],"thread-4223154":["thread",4223154],"thread-4223153":["thread",4223153],"thread-4223152":["thread",4223152],"thread-4223151":["thread",4223151],"thread-4223150":["thread",4223150],"thread-4223149":["thread",4223149],"thread-4223148":["thread",4223148],"thread-4223147":["thread",4223147],"thread-4223146":["thread",4223146],"thread-4223145":["thread",4223145],"thread-4223144":["thread",4223144],"thread-4223143":["thread",4223143],"thread-4223142":["thread",4223142],"thread-4223141":["thread",4223141],"thread-4223140":["thread",4223140],"thread-4223139":["thread",4223139],"thread-4223138":["thread",4223138],"thread-4223137":["thread",4223137],"thread-4223136":["thread",4223136],"thread-4223135":["thread",4223135],"thread-4223134":["thread",4223134],"thread-4223133":["thread",4223133],"thread-4223132":["thread",4223132],"thread-4223131":["thread",4223131],"thread-4223130":["thread",4223130],"thread-4223129":["thread",4223129],"thread-4223128":["thread",4223128],"thread-4223127":["thread",4223127],"thread-4223126":["thread",4223126],"thread-4223125":["thread",4223125],"thread-4223124":["thread",4223124],"thread-4223123":["thread",4223123],"thread-4223122":["thread",4223122],"thread-4223121":["thread",4223121],"thread-4223120":["thread",4223120],"thread-4223119":["thread",4223119],"thread-4223118":["thread",4223118],"thread-4223117":["thread",4223117],"thread-4223116":["thread",4223116],"thread-4223115":["thread",4223115],"thread-4223114":["thread",4223114],"thread-4223113":["thread",4223113],"thread-4223112":["thread",4223112],"thread-4223111":["thread",4223111],"thread-4223110":["thread",4223110],"thread-4223109":["thread",4223109],"thread-4223108":["thread",4223108],"thread-4223107":["thread",4223107],"thread-4223106":["thread",4223106],"thread-4223105":["thread",4223105],"thread-4223104":["thread",4223104],"thread-4223103":["thread",4223103],"thread-4223102":["thread",4223102],"thread-4223101":["thread",4223101],"thread-4223100":["thread",4223100],"thread-4223099":["thread",4223099],"thread-4223098":["thread",4223098],"thread-4223097":["thread",4223097],"thread-4223096":["thread",4223096],"thread-4223095":["thread",4223095],"thread-4223094":["thread",4223094],"thread-4223093":["thread",4223093],"thread-4223092":["thread",4223092],"thread-4223091":["thread",4223091],"thread-4223090":["thread",4223090],"thread-4223089":["thread",4223089],"thread-4223088":["thread",4223088],"thread-4223087":["thread",4223087],"thread-4223086":["thread",4223086],"thread-4223085":["thread",4223085],"thread-4223084":["thread",4223084],"thread-4223083":["thread",4223083],"thread-4223082":["thread",4223082],"thread-4223081":["thread",4223081],"thread-4223080":["thread",4223080],"thread-4223079":["thread",4223079],"thread-4223078":["thread",4223078],"thread-4223077":["thread",4223077],"thread-4223076":["thread",4223076],"thread-4223075":["thread",4223075],"thread-4222567":["thread",4222567],"thread-4223074":["thread",4223074],"thread-4222563":["thread",4222563],"thread-4222548":["thread",4222548],"thread-4222534":["thread",4222534],"thread-4222509":["thread",4222509],"thread-4222489":["thread",4222489],"thread-4222458":["thread",4222458],"thread-4222456":["thread",4222456],"thread-4222451":["thread",4222451],"thread-4222472":["thread",4222472],"thread-4222471":["thread",4222471],"thread-4223073":["thread",4223073],"thread-4222470":["thread",4222470],"thread-4222469":["thread",4222469],"thread-4223072":["thread",4223072],"thread-4222468":["thread",4222468],"thread-4222467":["thread",4222467],"thread-4222466":["thread",4222466],"thread-4223071":["thread",4223071],"thread-4223070":["thread",4223070],"thread-4223069":["thread",4223069],"thread-4222400":["thread",4222400],"thread-4222396":["thread",4222396],"thread-4222388":["thread",4222388],"thread-4222387":["thread",4222387],"thread-4222376":["thread",4222376],"thread-4222364":["thread",4222364],"thread-4222354":["thread",4222354],"thread-4222350":["thread",4222350],"thread-4223068":["thread",4223068],"thread-4223067":["thread",4223067],"thread-4223066":["thread",4223066],"thread-4223065":["thread",4223065],"thread-4223064":["thread",4223064],"thread-4223063":["thread",4223063],"thread-4223062":["thread",4223062],"thread-4223061":["thread",4223061],"thread-4223060":["thread",4223060],"thread-4223059":["thread",4223059],"thread-4223058":["thread",4223058],"thread-4223057":["thread",4223057],"thread-4223056":["thread",4223056],"thread-4223055":["thread",4223055],"thread-4223054":["thread",4223054],"thread-4223053":["thread",4223053],"thread-4223052":["thread",4223052],"thread-4223051":["thread",4223051],"thread-4223050":["thread",4223050],"thread-4223049":["thread",4223049],"thread-4223048":["thread",4223048]}, , 1715588573
Run Time: 0.000226
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1510
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20