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 (182456, 182217, 181473, 177519, 176876, 175498, 172980, 172975, 171741, 170812, 170760, 169674, 169611, 169409, 168990, 168287, 167660, 167640, 166890, 165871, 165809, 165808, 165804, 164658, 163840, 163798, 163381, 162988, 162987, 162794, 162417, 162415, 162135, 161390, 159599, 159016, 158875, 158748, 158746, 157822, 157341, 157219, 156346, 156052, 155404, 153954, 153723, 153312, 152007, 151807, 150734, 143452, 143166, 138257, 138031, 133535, 128295, 128094, 127575, 127193, 127176, 126551, 125365, 125141, 125134, 125131, 124487, 123411, 123408, 123407, 123261, 123033, 122602, 122486, 121723, 121045, 120891, 118720, 118639, 118601, 118591, 118589, 118588, 115580, 115464, 115167, 114998, 114483, 113724, 112994, 112992, 112690, 112689, 112387, 112106, 111269, 110154, 110066, 109841, 109674, 108927, 108878, 108683, 108592, 107602, 107053, 105351, 103813, 103080, 103077, 102462, 102269, 102226, 101877, 101584, 99504, 98989, 97931, 97450, 96649, 96231, 95540, 95137, 94745, 94324, 93918, 93322, 87799, 86311, 85530, 82769, 81794, 81388, 80998, 80241, 78286, 75289, 74493, 71280, 69587, 69497, 68238, 68089, 67627, 67321, 66477, 64770, 62241, 61333, 60548, 56834, 54734, 53357, 52172, 50982, 48802, 48711, 48707, 48199, 47046, 46692, 45607, 42134))
Run Time: 0.101986
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 163 | 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: 6117, 0, 1714885359, {"thread-182456":["thread",182456],"thread-182217":["thread",182217],"thread-181473":["thread",181473],"thread-177519":["thread",177519],"thread-176876":["thread",176876],"thread-175498":["thread",175498],"thread-172980":["thread",172980],"thread-172975":["thread",172975],"thread-171741":["thread",171741],"thread-170812":["thread",170812],"thread-170760":["thread",170760],"thread-169674":["thread",169674],"thread-169611":["thread",169611],"thread-169409":["thread",169409],"thread-168990":["thread",168990],"thread-168287":["thread",168287],"thread-167660":["thread",167660],"thread-167640":["thread",167640],"thread-166890":["thread",166890],"thread-165871":["thread",165871],"thread-165809":["thread",165809],"thread-165808":["thread",165808],"thread-165804":["thread",165804],"thread-164658":["thread",164658],"thread-163840":["thread",163840],"thread-163798":["thread",163798],"thread-163381":["thread",163381],"thread-162988":["thread",162988],"thread-162987":["thread",162987],"thread-162794":["thread",162794],"thread-162417":["thread",162417],"thread-162415":["thread",162415],"thread-162135":["thread",162135],"thread-161390":["thread",161390],"thread-159016":["thread",159016],"thread-158875":["thread",158875],"thread-158748":["thread",158748],"thread-158746":["thread",158746],"thread-157822":["thread",157822],"thread-157341":["thread",157341],"thread-157219":["thread",157219],"thread-156346":["thread",156346],"thread-156052":["thread",156052],"thread-155404":["thread",155404],"thread-153954":["thread",153954],"thread-153723":["thread",153723],"thread-153312":["thread",153312],"thread-152007":["thread",152007],"thread-151807":["thread",151807],"thread-150734":["thread",150734],"thread-143452":["thread",143452],"thread-143166":["thread",143166],"thread-138257":["thread",138257],"thread-138031":["thread",138031],"thread-133535":["thread",133535],"thread-128295":["thread",128295],"thread-128094":["thread",128094],"thread-127575":["thread",127575],"thread-127193":["thread",127193],"thread-127176":["thread",127176],"thread-126551":["thread",126551],"thread-125365":["thread",125365],"thread-125141":["thread",125141],"thread-125134":["thread",125134],"thread-125131":["thread",125131],"thread-124487":["thread",124487],"thread-123411":["thread",123411],"thread-123408":["thread",123408],"thread-123407":["thread",123407],"thread-123261":["thread",123261],"thread-123033":["thread",123033],"thread-122602":["thread",122602],"thread-122486":["thread",122486],"thread-121723":["thread",121723],"thread-121045":["thread",121045],"thread-120891":["thread",120891],"thread-118720":["thread",118720],"thread-118639":["thread",118639],"thread-118601":["thread",118601],"thread-118591":["thread",118591],"thread-118589":["thread",118589],"thread-118588":["thread",118588],"thread-115580":["thread",115580],"thread-115464":["thread",115464],"thread-115167":["thread",115167],"thread-114998":["thread",114998],"thread-114483":["thread",114483],"thread-113724":["thread",113724],"thread-112994":["thread",112994],"thread-112992":["thread",112992],"thread-112690":["thread",112690],"thread-112689":["thread",112689],"thread-112387":["thread",112387],"thread-112106":["thread",112106],"thread-111269":["thread",111269],"thread-110154":["thread",110154],"thread-110066":["thread",110066],"thread-109841":["thread",109841],"thread-109674":["thread",109674],"thread-108927":["thread",108927],"thread-108878":["thread",108878],"thread-108683":["thread",108683],"thread-108592":["thread",108592],"thread-107602":["thread",107602],"thread-107053":["thread",107053],"thread-105351":["thread",105351],"thread-103813":["thread",103813],"thread-103080":["thread",103080],"thread-103077":["thread",103077],"thread-102462":["thread",102462],"thread-102269":["thread",102269],"thread-102226":["thread",102226],"thread-101877":["thread",101877],"thread-101584":["thread",101584],"thread-99504":["thread",99504],"thread-98989":["thread",98989],"thread-97931":["thread",97931],"thread-97450":["thread",97450],"thread-96649":["thread",96649],"thread-96231":["thread",96231],"thread-95540":["thread",95540],"thread-95137":["thread",95137],"thread-94745":["thread",94745],"thread-94324":["thread",94324],"thread-93918":["thread",93918],"thread-93322":["thread",93322],"thread-87799":["thread",87799],"thread-86311":["thread",86311],"thread-85530":["thread",85530],"thread-82769":["thread",82769],"thread-81794":["thread",81794],"thread-81388":["thread",81388],"thread-80998":["thread",80998],"thread-80241":["thread",80241],"thread-78286":["thread",78286],"thread-75289":["thread",75289],"thread-74493":["thread",74493],"thread-71280":["thread",71280],"thread-69587":["thread",69587],"thread-69497":["thread",69497],"thread-68238":["thread",68238],"thread-68089":["thread",68089],"thread-67627":["thread",67627],"thread-67321":["thread",67321],"thread-66477":["thread",66477],"thread-64770":["thread",64770],"thread-62241":["thread",62241],"thread-61333":["thread",61333],"thread-60548":["thread",60548],"thread-56834":["thread",56834],"thread-54734":["thread",54734],"thread-53357":["thread",53357],"thread-52172":["thread",52172],"thread-50982":["thread",50982],"thread-48802":["thread",48802],"thread-48711":["thread",48711],"thread-48707":["thread",48707],"thread-48199":["thread",48199],"thread-47046":["thread",47046],"thread-46692":["thread",46692],"thread-45607":["thread",45607],"thread-42134":["thread",42134]}, , 1714881759
Run Time: 0.000515
- 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