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 (183442, 182811, 180186, 179026, 178815, 178683, 178534, 178453, 178025, 177911, 177663, 176901, 176755, 176578, 176484, 176402, 174737, 174704, 173094, 171630, 171420, 170319, 169006, 167955, 167187, 165327, 164355, 163688, 163409, 160046, 159322, 157791, 144487, 137292, 136653, 132789, 130956, 130176, 129582, 128622, 127604, 127564, 126445, 124553, 120580, 120533, 116902, 116726, 116675, 116219, 115917, 115091, 114550, 114297, 114224, 114149, 113834, 113076, 111173, 111151, 110403, 110331, 109670, 109607, 109512, 108555, 108110, 107380, 104538, 104446, 104147, 103504, 103431, 103002, 100948, 100494, 100261, 99904, 99283, 99206, 99122, 99103, 99009, 98993, 98961, 98872, 98832, 98006, 97831, 97717, 97716, 97715, 97714, 97654, 97555, 97524, 97292, 97206, 97117, 97102, 96344, 95802, 95393, 95180, 95101, 94883, 94594, 94513, 94093, 93535, 92541, 91859, 91494, 90402, 89967, 89188, 88115, 86261, 85715, 85517, 85509, 85490, 84190, 83948, 83888, 83553, 80239, 79952, 79895, 76744, 76003, 72856, 72742, 70098, 69795, 69163, 69050, 68531, 68304, 68227, 67442, 67056, 65565, 62662, 62183, 60831, 60703, 59234, 58131, 58129, 54782, 54602, 48751, 48681, 45054, 43547, 31723, 26595, 21146, 16123, 7143))
Run Time: 0.095154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 161 | 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: 1353, 0, 1715783156, {"thread-183442":["thread",183442],"thread-182811":["thread",182811],"thread-180186":["thread",180186],"thread-179026":["thread",179026],"thread-178815":["thread",178815],"thread-178683":["thread",178683],"thread-178534":["thread",178534],"thread-178453":["thread",178453],"thread-178025":["thread",178025],"thread-177911":["thread",177911],"thread-177663":["thread",177663],"thread-176901":["thread",176901],"ams_article-5120":["ams_article",5120],"thread-176755":["thread",176755],"thread-176578":["thread",176578],"thread-176484":["thread",176484],"thread-176402":["thread",176402],"thread-174737":["thread",174737],"thread-174704":["thread",174704],"thread-173094":["thread",173094],"ams_article-4929":["ams_article",4929],"thread-171630":["thread",171630],"thread-171420":["thread",171420],"thread-170319":["thread",170319],"thread-169006":["thread",169006],"thread-167955":["thread",167955],"thread-167187":["thread",167187],"thread-165327":["thread",165327],"thread-164355":["thread",164355],"thread-163688":["thread",163688],"thread-163409":["thread",163409],"thread-160046":["thread",160046],"thread-159322":["thread",159322],"thread-157791":["thread",157791],"thread-144487":["thread",144487],"thread-137292":["thread",137292],"thread-136653":["thread",136653],"thread-132789":["thread",132789],"thread-130956":["thread",130956],"thread-130176":["thread",130176],"thread-129582":["thread",129582],"thread-128622":["thread",128622],"thread-127604":["thread",127604],"thread-127564":["thread",127564],"thread-126445":["thread",126445],"thread-124553":["thread",124553],"thread-120580":["thread",120580],"thread-120533":["thread",120533],"thread-116902":["thread",116902],"thread-116726":["thread",116726],"thread-116675":["thread",116675],"thread-116219":["thread",116219],"thread-115917":["thread",115917],"thread-115091":["thread",115091],"thread-114550":["thread",114550],"thread-114297":["thread",114297],"thread-114224":["thread",114224],"thread-114149":["thread",114149],"thread-113834":["thread",113834],"thread-113076":["thread",113076],"thread-111173":["thread",111173],"thread-111151":["thread",111151],"thread-110403":["thread",110403],"thread-110331":["thread",110331],"thread-109670":["thread",109670],"thread-109607":["thread",109607],"thread-109512":["thread",109512],"thread-108555":["thread",108555],"thread-108110":["thread",108110],"thread-107380":["thread",107380],"thread-104538":["thread",104538],"thread-104446":["thread",104446],"thread-104147":["thread",104147],"thread-103504":["thread",103504],"thread-103431":["thread",103431],"thread-103002":["thread",103002],"thread-100948":["thread",100948],"thread-100494":["thread",100494],"thread-100261":["thread",100261],"thread-99904":["thread",99904],"thread-99283":["thread",99283],"thread-99206":["thread",99206],"thread-99122":["thread",99122],"thread-99103":["thread",99103],"thread-99009":["thread",99009],"thread-98993":["thread",98993],"thread-98961":["thread",98961],"thread-98872":["thread",98872],"thread-98832":["thread",98832],"thread-98006":["thread",98006],"thread-97831":["thread",97831],"thread-97717":["thread",97717],"thread-97716":["thread",97716],"thread-97715":["thread",97715],"thread-97714":["thread",97714],"thread-97654":["thread",97654],"thread-97555":["thread",97555],"thread-97524":["thread",97524],"thread-97292":["thread",97292],"thread-97206":["thread",97206],"thread-97117":["thread",97117],"thread-97102":["thread",97102],"thread-96344":["thread",96344],"thread-95802":["thread",95802],"thread-95393":["thread",95393],"thread-95180":["thread",95180],"thread-95101":["thread",95101],"thread-94883":["thread",94883],"thread-94594":["thread",94594],"thread-94513":["thread",94513],"thread-94093":["thread",94093],"thread-93535":["thread",93535],"thread-92541":["thread",92541],"thread-91859":["thread",91859],"thread-91494":["thread",91494],"thread-90402":["thread",90402],"thread-89967":["thread",89967],"thread-89188":["thread",89188],"thread-88115":["thread",88115],"thread-86261":["thread",86261],"thread-85715":["thread",85715],"thread-85517":["thread",85517],"thread-85509":["thread",85509],"thread-85490":["thread",85490],"thread-84190":["thread",84190],"thread-83948":["thread",83948],"thread-83888":["thread",83888],"thread-83553":["thread",83553],"thread-80239":["thread",80239],"thread-79952":["thread",79952],"thread-79895":["thread",79895],"thread-76744":["thread",76744],"thread-76003":["thread",76003],"thread-72856":["thread",72856],"thread-72742":["thread",72742],"thread-70098":["thread",70098],"thread-69795":["thread",69795],"thread-69163":["thread",69163],"thread-69050":["thread",69050],"thread-68531":["thread",68531],"thread-68304":["thread",68304],"thread-68227":["thread",68227],"thread-67442":["thread",67442],"thread-67056":["thread",67056],"thread-65565":["thread",65565],"thread-62662":["thread",62662],"thread-62183":["thread",62183],"thread-60831":["thread",60831],"thread-60703":["thread",60703],"thread-59234":["thread",59234],"thread-58131":["thread",58131],"thread-58129":["thread",58129],"thread-54782":["thread",54782],"thread-54602":["thread",54602],"thread-48751":["thread",48751],"thread-48681":["thread",48681],"thread-45054":["thread",45054],"thread-43547":["thread",43547],"thread-31723":["thread",31723],"thread-26595":["thread",26595],"thread-21146":["thread",21146],"thread-16123":["thread",16123],"thread-7143":["thread",7143]}, , 1715779556
Run Time: 0.000266
- 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