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 (182822, 182781, 182572, 182434, 182417, 182372, 182207, 181852, 181720, 181452, 181417, 181290, 181289, 181263, 181050, 181012, 180726, 180299, 180292, 179500, 179472, 179271, 179018, 178710, 178067, 177988, 177666, 177372, 177279, 176634, 176551, 176531, 176505, 176468, 176441, 176299, 176217, 176189, 176187, 175827, 175741, 175592, 175563, 175200, 175017, 174941, 174878, 174297, 174268, 174109, 173920, 173831, 173604, 173598, 173038, 173035, 172858, 172650, 172452, 172291, 171971, 171788, 171623, 171545, 171195, 170293, 169642, 169421, 169011, 168651, 168560, 168430, 168187, 168164, 168086, 167182, 167088, 166388, 166371, 166301, 166292, 165753, 165750, 165404, 165252, 165245, 165241, 164966, 164961, 164651, 164590, 164538, 164537, 164165, 163519, 163380, 163114, 162870, 162869, 162802, 162563, 162541, 162276, 162049, 161869, 161375, 161226, 160363, 160255, 160190, 159921, 159826, 159750, 159712, 159686, 159533, 159057, 159056, 159055, 158931, 158851, 158104, 158072, 158017, 158004, 157599, 157577, 157501, 156963, 156943, 156762, 156660, 156577, 156205, 156034, 155918, 155838, 155745, 155496, 155495, 155494, 155474, 155368, 155214, 155171, 155025, 154976, 154935, 154886, 154872, 154871, 154822, 154821, 154816, 154754, 154697, 154651, 154642, 154639, 154638, 154579, 154554, 154493, 154492, 154491, 154208, 154129, 153824, 153590, 153586, 153517, 153499, 153200, 153077, 152884, 152856, 152797, 152751, 152599, 152483, 152167, 152067, 152036, 151917, 151877, 151777, 149280, 138939, 138079, 133714, 132842, 132183, 132169, 132094, 132056, 132044))
Run Time: 0.071636
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 196 | 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: 25, 0, 1714284729, {"thread-182822":["thread",182822],"thread-182781":["thread",182781],"thread-182572":["thread",182572],"thread-182434":["thread",182434],"thread-182417":["thread",182417],"thread-182372":["thread",182372],"thread-182207":["thread",182207],"thread-181852":["thread",181852],"thread-181452":["thread",181452],"thread-181417":["thread",181417],"thread-181290":["thread",181290],"thread-181289":["thread",181289],"thread-181263":["thread",181263],"thread-181050":["thread",181050],"thread-181012":["thread",181012],"thread-180726":["thread",180726],"thread-180299":["thread",180299],"thread-180292":["thread",180292],"thread-179500":["thread",179500],"thread-179472":["thread",179472],"thread-179271":["thread",179271],"thread-179018":["thread",179018],"thread-178710":["thread",178710],"thread-178067":["thread",178067],"thread-177988":["thread",177988],"thread-177666":["thread",177666],"thread-177372":["thread",177372],"thread-177279":["thread",177279],"thread-176634":["thread",176634],"thread-176551":["thread",176551],"thread-176531":["thread",176531],"thread-176505":["thread",176505],"thread-176468":["thread",176468],"thread-176441":["thread",176441],"thread-176299":["thread",176299],"thread-176217":["thread",176217],"thread-176189":["thread",176189],"thread-176187":["thread",176187],"thread-175827":["thread",175827],"thread-175741":["thread",175741],"thread-175592":["thread",175592],"thread-175563":["thread",175563],"thread-175200":["thread",175200],"thread-175017":["thread",175017],"thread-174941":["thread",174941],"thread-174878":["thread",174878],"thread-174297":["thread",174297],"thread-174268":["thread",174268],"thread-174109":["thread",174109],"thread-173920":["thread",173920],"thread-173831":["thread",173831],"thread-173604":["thread",173604],"thread-173038":["thread",173038],"thread-173035":["thread",173035],"thread-172858":["thread",172858],"thread-172650":["thread",172650],"thread-172452":["thread",172452],"thread-172291":["thread",172291],"thread-171971":["thread",171971],"thread-171788":["thread",171788],"thread-171623":["thread",171623],"thread-171545":["thread",171545],"thread-171195":["thread",171195],"thread-170293":["thread",170293],"thread-169642":["thread",169642],"thread-169421":["thread",169421],"thread-169011":["thread",169011],"thread-168651":["thread",168651],"thread-168430":["thread",168430],"thread-168164":["thread",168164],"thread-168086":["thread",168086],"thread-167182":["thread",167182],"thread-167088":["thread",167088],"thread-166388":["thread",166388],"thread-166371":["thread",166371],"thread-166301":["thread",166301],"thread-166292":["thread",166292],"thread-165750":["thread",165750],"thread-165404":["thread",165404],"thread-165252":["thread",165252],"thread-164966":["thread",164966],"thread-164961":["thread",164961],"thread-164651":["thread",164651],"thread-164538":["thread",164538],"thread-164165":["thread",164165],"thread-163519":["thread",163519],"thread-163380":["thread",163380],"thread-163114":["thread",163114],"thread-162802":["thread",162802],"thread-162563":["thread",162563],"thread-162276":["thread",162276],"thread-161869":["thread",161869],"thread-161375":["thread",161375],"thread-161226":["thread",161226],"thread-160363":["thread",160363],"thread-160190":["thread",160190],"thread-159826":["thread",159826],"thread-159750":["thread",159750],"thread-159712":["thread",159712],"thread-159686":["thread",159686],"thread-159057":["thread",159057],"thread-159056":["thread",159056],"thread-159055":["thread",159055],"thread-158931":["thread",158931],"thread-158851":["thread",158851],"thread-158104":["thread",158104],"thread-158072":["thread",158072],"thread-158017":["thread",158017],"thread-158004":["thread",158004],"thread-157599":["thread",157599],"thread-157577":["thread",157577],"thread-157501":["thread",157501],"thread-156963":["thread",156963],"thread-156943":["thread",156943],"thread-156762":["thread",156762],"thread-156660":["thread",156660],"thread-156205":["thread",156205],"thread-155918":["thread",155918],"thread-155838":["thread",155838],"ams_article-4202":["ams_article",4202],"thread-155745":["thread",155745],"thread-155474":["thread",155474],"thread-155214":["thread",155214],"thread-155171":["thread",155171],"thread-155025":["thread",155025],"thread-154935":["thread",154935],"thread-154886":["thread",154886],"thread-154872":["thread",154872],"thread-154871":["thread",154871],"tl_group-107":["tl_group",107],"thread-154816":["thread",154816],"thread-154754":["thread",154754],"thread-154697":["thread",154697],"thread-154642":["thread",154642],"thread-154639":["thread",154639],"thread-154638":["thread",154638],"thread-154579":["thread",154579],"thread-154554":["thread",154554],"thread-154493":["thread",154493],"thread-154492":["thread",154492],"thread-154491":["thread",154491],"thread-154208":["thread",154208],"thread-154129":["thread",154129],"thread-153824":["thread",153824],"thread-153590":["thread",153590],"thread-153586":["thread",153586],"thread-153517":["thread",153517],"thread-153499":["thread",153499],"thread-153200":["thread",153200],"thread-153077":["thread",153077],"thread-152884":["thread",152884],"thread-152856":["thread",152856],"thread-152599":["thread",152599],"thread-152483":["thread",152483],"thread-152067":["thread",152067],"thread-152036":["thread",152036],"thread-151917":["thread",151917],"thread-151877":["thread",151877],"thread-149280":["thread",149280],"thread-138939":["thread",138939],"thread-138079":["thread",138079],"ams_article-2985":["ams_article",2985],"thread-133714":["thread",133714],"thread-132842":["thread",132842],"thread-132183":["thread",132183],"thread-132169":["thread",132169],"thread-132094":["thread",132094],"thread-132056":["thread",132056],"thread-132044":["thread",132044]}, , 1714281129
Run Time: 0.000285
- 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