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 (102727, 93280, 81166, 81108, 81061, 48751, 48666, 45592, 45527, 45456, 45187, 45181, 45078, 45006, 45001, 44994, 44604, 44597, 44534, 44354, 44336, 44330, 44320, 44307, 44048, 44018, 43713, 43561, 43383, 43363, 43331, 43329, 43313, 43289, 43150, 43143, 43086, 42676, 42526, 42366, 42284, 42216, 42213, 42203, 42187, 42151, 42086, 42082, 41995, 41993, 41943, 41935, 41931, 41851, 41849, 41720, 41657, 41614, 41519, 41311, 41300, 41212, 41071, 40990, 40964, 40895, 40892, 40788, 40757, 40731, 40689, 40677, 40641, 40634, 40598, 40537, 40519, 40486, 40446, 40401, 40395, 40228, 40210, 40187, 40177, 39816, 39815, 39403, 39377, 39052, 38979, 38915, 38755, 38705, 38310, 38138, 38077, 37923, 37694, 37680, 37492, 37425, 37141, 36606, 36370, 36208, 35886, 35745, 35620, 35474, 35214, 35049, 35046, 34826, 34805, 34743, 34406, 33638, 33480, 33449, 33216, 33213, 33162, 32939, 32824, 32025, 32023, 31884, 31723, 31560, 31428, 31183, 30443, 30367, 30252, 30107, 28891, 28162))
Run Time: 0.067124
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 138 | 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: 3792, 0, 1715923538, {"thread-102727":["thread",102727],"thread-93280":["thread",93280],"thread-81166":["thread",81166],"thread-81108":["thread",81108],"thread-81061":["thread",81061],"thread-48751":["thread",48751],"thread-45592":["thread",45592],"thread-45527":["thread",45527],"thread-45456":["thread",45456],"thread-45187":["thread",45187],"thread-45181":["thread",45181],"thread-45078":["thread",45078],"thread-45006":["thread",45006],"thread-45001":["thread",45001],"thread-44994":["thread",44994],"thread-44604":["thread",44604],"thread-44597":["thread",44597],"thread-44534":["thread",44534],"thread-44354":["thread",44354],"thread-44336":["thread",44336],"thread-44330":["thread",44330],"thread-44320":["thread",44320],"thread-44307":["thread",44307],"thread-44048":["thread",44048],"thread-44018":["thread",44018],"thread-43713":["thread",43713],"thread-43561":["thread",43561],"thread-43383":["thread",43383],"thread-43363":["thread",43363],"thread-43331":["thread",43331],"thread-43329":["thread",43329],"thread-43313":["thread",43313],"thread-43289":["thread",43289],"thread-43150":["thread",43150],"thread-43143":["thread",43143],"thread-43086":["thread",43086],"thread-42676":["thread",42676],"thread-42526":["thread",42526],"thread-42366":["thread",42366],"thread-42284":["thread",42284],"thread-42216":["thread",42216],"thread-42213":["thread",42213],"thread-42203":["thread",42203],"thread-42187":["thread",42187],"thread-42151":["thread",42151],"thread-42086":["thread",42086],"thread-42082":["thread",42082],"thread-41995":["thread",41995],"thread-41993":["thread",41993],"thread-41943":["thread",41943],"thread-41935":["thread",41935],"thread-41931":["thread",41931],"thread-41851":["thread",41851],"thread-41849":["thread",41849],"thread-41720":["thread",41720],"thread-41657":["thread",41657],"thread-41614":["thread",41614],"thread-41519":["thread",41519],"thread-41311":["thread",41311],"thread-41300":["thread",41300],"thread-41212":["thread",41212],"thread-41071":["thread",41071],"thread-40990":["thread",40990],"thread-40964":["thread",40964],"thread-40895":["thread",40895],"thread-40892":["thread",40892],"thread-40788":["thread",40788],"thread-40757":["thread",40757],"thread-40731":["thread",40731],"thread-40689":["thread",40689],"thread-40677":["thread",40677],"thread-40641":["thread",40641],"thread-40634":["thread",40634],"thread-40598":["thread",40598],"thread-40537":["thread",40537],"thread-40519":["thread",40519],"thread-40486":["thread",40486],"thread-40446":["thread",40446],"thread-40401":["thread",40401],"thread-40395":["thread",40395],"thread-40228":["thread",40228],"thread-40210":["thread",40210],"thread-40187":["thread",40187],"thread-40177":["thread",40177],"thread-39816":["thread",39816],"thread-39815":["thread",39815],"thread-39403":["thread",39403],"thread-39377":["thread",39377],"thread-39052":["thread",39052],"thread-38979":["thread",38979],"thread-38915":["thread",38915],"thread-38755":["thread",38755],"thread-38705":["thread",38705],"thread-38310":["thread",38310],"thread-38138":["thread",38138],"thread-38077":["thread",38077],"thread-37923":["thread",37923],"thread-37694":["thread",37694],"thread-37680":["thread",37680],"thread-37492":["thread",37492],"thread-37425":["thread",37425],"thread-37141":["thread",37141],"thread-36606":["thread",36606],"thread-36370":["thread",36370],"thread-36208":["thread",36208],"thread-35886":["thread",35886],"thread-35745":["thread",35745],"thread-35620":["thread",35620],"thread-35474":["thread",35474],"thread-35214":["thread",35214],"thread-35049":["thread",35049],"thread-35046":["thread",35046],"thread-34826":["thread",34826],"thread-34805":["thread",34805],"thread-34743":["thread",34743],"thread-34406":["thread",34406],"thread-33638":["thread",33638],"thread-33480":["thread",33480],"thread-33449":["thread",33449],"thread-33216":["thread",33216],"thread-33213":["thread",33213],"thread-33162":["thread",33162],"thread-32939":["thread",32939],"thread-32824":["thread",32824],"thread-32025":["thread",32025],"thread-32023":["thread",32023],"thread-31884":["thread",31884],"thread-31723":["thread",31723],"thread-31560":["thread",31560],"thread-31428":["thread",31428],"thread-31183":["thread",31183],"thread-30443":["thread",30443],"thread-30367":["thread",30367],"thread-30252":["thread",30252],"thread-30107":["thread",30107],"thread-28891":["thread",28891],"thread-28162":["thread",28162]}, , 1715919938
Run Time: 0.000783
- 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