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 (183361, 183341, 183176, 183126, 183022, 183021, 182995, 182964, 182760, 182454, 182408, 182355, 182187, 182031, 181909, 181908, 181907, 181770, 181735, 181668, 181620, 181608, 181220, 181085, 180472, 180469, 180437, 180124, 180091, 179648, 179378, 179149, 179042, 178922, 178920, 178560, 178258, 178073, 178058, 178057, 177977, 177836, 177783, 177721, 177684, 177642, 177555, 177366, 177204, 177066, 176614, 176563, 176562, 175880, 175601, 175522, 175422, 175389, 175324, 175224, 175189, 175159, 175059, 174981, 174865, 174266, 173912, 173877, 173839, 173828, 173819, 173382, 173272, 173052, 172883, 172107, 172084, 171877, 171810, 171641, 171558, 171538, 171405, 171203, 171004, 170700, 170419, 170126, 170081, 169946, 169774, 169368, 169317, 169142, 168988, 168726, 168602, 168544, 168397, 168394, 167949, 167831, 167605, 167405, 167134, 167130, 167040, 167006, 166933, 166850, 166435, 166424, 166189, 166188, 165962, 165811, 165556, 165531, 165195, 164827, 164776, 164709, 164248, 164106, 164104, 163939, 163820, 163698, 163695, 163434, 163355, 163326, 163196, 163020, 163014, 162954, 162885, 162876, 162810, 162616, 162599, 162350, 162238, 162096, 161860, 161685, 161580, 161553, 161551, 161488, 160951, 160904, 160168, 159982, 159292, 159216, 159174, 159172, 159118, 159032, 158881, 158804, 158741, 158734, 158377, 157998, 157904, 157775, 157687, 157594, 157025, 156741, 156529, 156417, 156327, 156226, 156188, 156137, 155609, 155453, 155354, 154946, 154803, 154783, 154690, 154613, 154512, 154483, 154347, 154220, 154188, 154184, 154077, 153803, 153724, 153713, 153388, 153149, 153145, 153075))
Run Time: 0.067375
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 200 | 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: 311, 0, 1716206584, {"thread-183361":["thread",183361],"thread-183341":["thread",183341],"thread-183176":["thread",183176],"thread-183126":["thread",183126],"thread-183022":["thread",183022],"thread-183021":["thread",183021],"thread-182995":["thread",182995],"thread-182964":["thread",182964],"thread-182760":["thread",182760],"thread-182454":["thread",182454],"thread-182408":["thread",182408],"thread-182355":["thread",182355],"thread-182187":["thread",182187],"thread-182031":["thread",182031],"thread-181909":["thread",181909],"thread-181908":["thread",181908],"thread-181907":["thread",181907],"thread-181770":["thread",181770],"thread-181735":["thread",181735],"thread-181668":["thread",181668],"thread-181620":["thread",181620],"thread-181608":["thread",181608],"thread-181220":["thread",181220],"thread-181085":["thread",181085],"thread-180472":["thread",180472],"thread-180469":["thread",180469],"thread-180437":["thread",180437],"thread-180124":["thread",180124],"thread-180091":["thread",180091],"thread-179648":["thread",179648],"thread-179378":["thread",179378],"thread-179149":["thread",179149],"thread-179042":["thread",179042],"thread-178922":["thread",178922],"thread-178920":["thread",178920],"thread-178560":["thread",178560],"thread-178258":["thread",178258],"thread-178073":["thread",178073],"thread-178058":["thread",178058],"thread-178057":["thread",178057],"thread-177977":["thread",177977],"thread-177836":["thread",177836],"thread-177783":["thread",177783],"thread-177721":["thread",177721],"thread-177684":["thread",177684],"thread-177642":["thread",177642],"thread-177555":["thread",177555],"thread-177366":["thread",177366],"thread-177204":["thread",177204],"thread-177066":["thread",177066],"thread-176614":["thread",176614],"thread-176563":["thread",176563],"thread-176562":["thread",176562],"thread-175880":["thread",175880],"thread-175601":["thread",175601],"thread-175522":["thread",175522],"thread-175422":["thread",175422],"thread-175389":["thread",175389],"thread-175324":["thread",175324],"thread-175224":["thread",175224],"thread-175189":["thread",175189],"thread-175159":["thread",175159],"thread-175059":["thread",175059],"thread-174981":["thread",174981],"thread-174865":["thread",174865],"thread-174266":["thread",174266],"thread-173912":["thread",173912],"thread-173877":["thread",173877],"thread-173839":["thread",173839],"thread-173828":["thread",173828],"thread-173819":["thread",173819],"thread-173382":["thread",173382],"thread-173272":["thread",173272],"thread-173052":["thread",173052],"thread-172883":["thread",172883],"thread-172107":["thread",172107],"thread-172084":["thread",172084],"thread-171877":["thread",171877],"thread-171810":["thread",171810],"thread-171641":["thread",171641],"thread-171558":["thread",171558],"thread-171538":["thread",171538],"thread-171405":["thread",171405],"thread-171203":["thread",171203],"thread-171004":["thread",171004],"thread-170700":["thread",170700],"thread-170419":["thread",170419],"thread-170126":["thread",170126],"thread-170081":["thread",170081],"thread-169946":["thread",169946],"thread-169774":["thread",169774],"thread-169368":["thread",169368],"thread-169317":["thread",169317],"thread-169142":["thread",169142],"thread-168988":["thread",168988],"thread-168726":["thread",168726],"thread-168602":["thread",168602],"thread-168544":["thread",168544],"thread-168397":["thread",168397],"thread-168394":["thread",168394],"thread-167949":["thread",167949],"thread-167831":["thread",167831],"thread-167605":["thread",167605],"thread-167405":["thread",167405],"thread-167134":["thread",167134],"thread-167130":["thread",167130],"thread-167040":["thread",167040],"thread-167006":["thread",167006],"thread-166933":["thread",166933],"thread-166850":["thread",166850],"thread-166435":["thread",166435],"thread-166424":["thread",166424],"thread-166189":["thread",166189],"thread-166188":["thread",166188],"thread-165962":["thread",165962],"thread-165811":["thread",165811],"thread-165556":["thread",165556],"thread-165531":["thread",165531],"thread-165195":["thread",165195],"thread-164827":["thread",164827],"thread-164776":["thread",164776],"thread-164709":["thread",164709],"thread-164248":["thread",164248],"thread-164106":["thread",164106],"thread-164104":["thread",164104],"thread-163939":["thread",163939],"thread-163820":["thread",163820],"thread-163698":["thread",163698],"thread-163695":["thread",163695],"thread-163434":["thread",163434],"thread-163355":["thread",163355],"thread-163326":["thread",163326],"thread-163196":["thread",163196],"thread-163020":["thread",163020],"thread-163014":["thread",163014],"thread-162954":["thread",162954],"thread-162885":["thread",162885],"thread-162876":["thread",162876],"thread-162810":["thread",162810],"thread-162616":["thread",162616],"thread-162599":["thread",162599],"thread-162350":["thread",162350],"thread-162238":["thread",162238],"thread-162096":["thread",162096],"thread-161860":["thread",161860],"thread-161685":["thread",161685],"thread-161580":["thread",161580],"thread-161553":["thread",161553],"thread-161551":["thread",161551],"thread-161488":["thread",161488],"thread-160951":["thread",160951],"thread-160904":["thread",160904],"thread-160168":["thread",160168],"thread-159982":["thread",159982],"thread-159292":["thread",159292],"thread-159216":["thread",159216],"thread-159174":["thread",159174],"thread-159172":["thread",159172],"thread-159118":["thread",159118],"thread-159032":["thread",159032],"thread-158881":["thread",158881],"thread-158804":["thread",158804],"thread-158741":["thread",158741],"thread-158734":["thread",158734],"thread-158377":["thread",158377],"thread-157998":["thread",157998],"thread-157904":["thread",157904],"thread-157775":["thread",157775],"thread-157687":["thread",157687],"thread-157594":["thread",157594],"thread-157025":["thread",157025],"thread-156741":["thread",156741],"thread-156529":["thread",156529],"thread-156417":["thread",156417],"thread-156327":["thread",156327],"thread-156226":["thread",156226],"thread-156188":["thread",156188],"thread-156137":["thread",156137],"thread-155609":["thread",155609],"thread-155453":["thread",155453],"thread-155354":["thread",155354],"thread-154946":["thread",154946],"thread-154803":["thread",154803],"thread-154783":["thread",154783],"thread-154690":["thread",154690],"thread-154613":["thread",154613],"thread-154512":["thread",154512],"thread-154483":["thread",154483],"thread-154347":["thread",154347],"thread-154220":["thread",154220],"thread-154188":["thread",154188],"thread-154184":["thread",154184],"thread-154077":["thread",154077],"thread-153803":["thread",153803],"thread-153724":["thread",153724],"thread-153713":["thread",153713],"thread-153388":["thread",153388],"thread-153149":["thread",153149],"thread-153145":["thread",153145],"thread-153075":["thread",153075]}, , 1716202984
Run Time: 0.000250
- 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