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 (49562, 47728, 47428, 46858, 46605, 46529, 46502, 46394, 46380, 46376, 46313, 46308, 46301, 46187, 45946, 45810, 45720, 45672, 45663, 45659, 45657, 45643, 45580, 45579, 45578, 45559, 45514, 45506, 45435, 45408, 45324, 45289, 45280, 45277, 45239, 45099, 44956, 44840, 44838, 44837, 44818, 44780, 44752, 44750, 44730, 44728, 44698, 44693, 44670, 44532, 44227, 44065, 43522, 43520, 42380, 42320, 42260, 42255, 42251, 42206, 42185, 42164, 42136, 42133, 42126, 41970, 41967, 41958, 41935, 41914, 41733, 41634, 41619, 41593, 41576, 41441, 41408, 41365, 41341, 41328, 41327, 41326, 41287, 41223, 41189, 41163, 41106, 41088, 41074, 41065, 41045, 41028, 40999, 40998, 40995, 40968, 40967, 40966, 40965, 40906, 40804, 40795, 40742, 40680, 40677, 40675, 40672, 40659, 40638, 40626, 40607, 40491, 40489, 40488, 40486, 40467, 40451, 40432, 40412, 40352, 40311, 40250, 40226, 40223, 40199, 40153, 40102, 40065, 40010, 39992, 39991, 39918, 39847, 39834, 39734, 39728, 39560, 39443, 39416, 39400, 39372, 37666, 37636, 34538, 34375, 27474, 21854, 9035, 6599, 6570, 6434, 6426, 6425, 6376, 6279, 3412, 3354, 3270, 3173, 3100, 2760, 2692, 2315, 2088, 1890, 1812, 1472, 1382, 1381, 1099, 202))
Run Time: 0.014327
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 171 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,import4.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 2719
- 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 2345
- XF\App->run() in src/XF.php at line 512
- 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: 495, 0, 1715938247, {"thread-49562":["thread",49562],"thread-47728":["thread",47728],"thread-47428":["thread",47428],"thread-46858":["thread",46858],"thread-46605":["thread",46605],"thread-46529":["thread",46529],"thread-46502":["thread",46502],"thread-46394":["thread",46394],"thread-46380":["thread",46380],"thread-46376":["thread",46376],"thread-46313":["thread",46313],"thread-46308":["thread",46308],"thread-46301":["thread",46301],"thread-46187":["thread",46187],"thread-45946":["thread",45946],"thread-45810":["thread",45810],"thread-45720":["thread",45720],"thread-45672":["thread",45672],"thread-45663":["thread",45663],"thread-45659":["thread",45659],"thread-45657":["thread",45657],"thread-45643":["thread",45643],"thread-45580":["thread",45580],"thread-45579":["thread",45579],"thread-45578":["thread",45578],"thread-45559":["thread",45559],"thread-45514":["thread",45514],"thread-45506":["thread",45506],"thread-45435":["thread",45435],"thread-45408":["thread",45408],"thread-45324":["thread",45324],"thread-45289":["thread",45289],"thread-45280":["thread",45280],"thread-45277":["thread",45277],"thread-45239":["thread",45239],"thread-45099":["thread",45099],"thread-44956":["thread",44956],"thread-44840":["thread",44840],"thread-44838":["thread",44838],"thread-44837":["thread",44837],"thread-44818":["thread",44818],"thread-44780":["thread",44780],"thread-44752":["thread",44752],"thread-44750":["thread",44750],"thread-44730":["thread",44730],"thread-44728":["thread",44728],"thread-44698":["thread",44698],"thread-44693":["thread",44693],"thread-44670":["thread",44670],"thread-44532":["thread",44532],"thread-44227":["thread",44227],"thread-44065":["thread",44065],"thread-43522":["thread",43522],"thread-43520":["thread",43520],"thread-42380":["thread",42380],"thread-42320":["thread",42320],"thread-42260":["thread",42260],"thread-42255":["thread",42255],"thread-42251":["thread",42251],"thread-42206":["thread",42206],"thread-42185":["thread",42185],"thread-42164":["thread",42164],"thread-42136":["thread",42136],"thread-42133":["thread",42133],"thread-42126":["thread",42126],"thread-41970":["thread",41970],"thread-41967":["thread",41967],"thread-41958":["thread",41958],"thread-41935":["thread",41935],"thread-41914":["thread",41914],"thread-41733":["thread",41733],"thread-41634":["thread",41634],"thread-41619":["thread",41619],"thread-41593":["thread",41593],"thread-41576":["thread",41576],"thread-41441":["thread",41441],"thread-41408":["thread",41408],"thread-41365":["thread",41365],"thread-41341":["thread",41341],"thread-41328":["thread",41328],"thread-41327":["thread",41327],"thread-41326":["thread",41326],"thread-41287":["thread",41287],"thread-41223":["thread",41223],"thread-41189":["thread",41189],"thread-41163":["thread",41163],"thread-41106":["thread",41106],"thread-41088":["thread",41088],"thread-41074":["thread",41074],"thread-41065":["thread",41065],"thread-41045":["thread",41045],"thread-41028":["thread",41028],"thread-40999":["thread",40999],"thread-40998":["thread",40998],"thread-40995":["thread",40995],"thread-40968":["thread",40968],"thread-40967":["thread",40967],"thread-40966":["thread",40966],"thread-40965":["thread",40965],"thread-40906":["thread",40906],"thread-40804":["thread",40804],"thread-40795":["thread",40795],"thread-40742":["thread",40742],"thread-40680":["thread",40680],"thread-40677":["thread",40677],"thread-40675":["thread",40675],"thread-40672":["thread",40672],"thread-40659":["thread",40659],"thread-40638":["thread",40638],"thread-40626":["thread",40626],"thread-40607":["thread",40607],"thread-40491":["thread",40491],"thread-40489":["thread",40489],"thread-40488":["thread",40488],"thread-40486":["thread",40486],"thread-40467":["thread",40467],"thread-40451":["thread",40451],"thread-40432":["thread",40432],"thread-40412":["thread",40412],"thread-40352":["thread",40352],"thread-40311":["thread",40311],"thread-40250":["thread",40250],"thread-40226":["thread",40226],"thread-40223":["thread",40223],"thread-40199":["thread",40199],"thread-40153":["thread",40153],"thread-40102":["thread",40102],"thread-40065":["thread",40065],"thread-40010":["thread",40010],"thread-39992":["thread",39992],"thread-39991":["thread",39991],"thread-39918":["thread",39918],"thread-39847":["thread",39847],"thread-39834":["thread",39834],"thread-39734":["thread",39734],"thread-39728":["thread",39728],"thread-39560":["thread",39560],"thread-39443":["thread",39443],"thread-39416":["thread",39416],"thread-39400":["thread",39400],"thread-39372":["thread",39372],"thread-37666":["thread",37666],"thread-37636":["thread",37636],"thread-34538":["thread",34538],"thread-34375":["thread",34375],"thread-27474":["thread",27474],"thread-21854":["thread",21854],"thread-9035":["thread",9035],"thread-6599":["thread",6599],"thread-6570":["thread",6570],"thread-6434":["thread",6434],"thread-6426":["thread",6426],"thread-6425":["thread",6425],"thread-6376":["thread",6376],"thread-6279":["thread",6279],"thread-3412":["thread",3412],"thread-3354":["thread",3354],"thread-3270":["thread",3270],"thread-3173":["thread",3173],"thread-3100":["thread",3100],"thread-2760":["thread",2760],"thread-2692":["thread",2692],"thread-2315":["thread",2315],"thread-2088":["thread",2088],"thread-1890":["thread",1890],"thread-1812":["thread",1812],"thread-1472":["thread",1472],"thread-1382":["thread",1382],"thread-1381":["thread",1381],"thread-1099":["thread",1099],"thread-202":["thread",202]}, , 1715934647
Run Time: 0.000668
- 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 1512
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1244
- 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 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20