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 (7216423, 7212985, 7206668, 7206351, 7205991, 7205751, 7205745, 7205511, 7203842, 7201899, 7201711, 7199653, 7199413, 7199301, 7198806, 7198495, 7197629, 7195625, 7190854, 7187131, 7185973, 7185068, 7184759, 7182687, 7182142, 7181518, 7180825, 7180442, 7179488, 7177499, 7177080, 7176245, 7175699, 7175668, 7175455, 7175304, 7174306, 7173560, 7171489, 7169763, 7169509, 7169484, 7169460, 7168563, 7165128, 7164400, 7160641, 7158024, 7156374, 7152646, 7152179, 7150290, 7150178, 7149867, 7149846, 7149656, 7148422, 7145004, 7144520, 7142977, 7140617, 7139650, 7138594, 7138569, 7138543, 7134918, 7134240, 7134123, 7134079, 7133034, 7132668, 7126732, 7120172, 7118381, 7117009, 7114736, 7114573, 7114036, 7112706, 7109976, 7109703, 7108803, 7107619, 7106286, 7102033, 7100527, 7097156, 7096754, 7096212, 7084606, 7084103, 7081050, 7077859, 7077434, 7077364, 7074991, 7074544, 7073455, 7072653, 7072031, 7071706, 7066964, 7066950, 7063875, 7062295, 7060439, 7057986, 7054826, 7053825, 7052846, 7043222, 7033185, 7032915, 7031289, 7026659, 7023595, 7022016, 7019271, 7017827, 7016832, 7015680, 7011438, 7011048, 7008676, 7008432, 7006399, 7003704, 7003456, 7002971, 7002890, 7001527, 6993566, 6989434, 6984828, 6978633, 6977646, 6975239, 6973519, 6969076, 6967126, 6868184, 6732690, 6610902, 6605966, 6281142, 239564, 235508, 228483, 224964, 217671, 211524, 197041, 196534, 190470, 188198, 179610, 174391, 172634, 160403, 154417, 13830, 13825, 13756, 13708, 13679, 13650, 13637, 13560, 13557, 13548, 13449, 13448, 13370, 13333, 13305, 13290, 13204, 13186, 13177, 13169, 13159, 13150, 13139, 13133, 13113, 13101, 13085, 12927, 12920, 12892, 12825, 12790, 12781, 12777, 12677, 12612, 12557, 12556, 12543, 12516))
Run Time: 0.009922
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 | production_xf.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | production_xf.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,production_xf.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 1430
- 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 2870
- 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 138
- 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 2487
- XF\App->run() in src/XF.php at line 524
- 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: 434, 0, 1714387633, {"thread-7216423":["thread",7216423],"thread-7212985":["thread",7212985],"thread-7206668":["thread",7206668],"thread-7206351":["thread",7206351],"thread-7205991":["thread",7205991],"thread-7205751":["thread",7205751],"thread-7205745":["thread",7205745],"thread-7205511":["thread",7205511],"thread-7203842":["thread",7203842],"thread-7201899":["thread",7201899],"thread-7201711":["thread",7201711],"thread-7199653":["thread",7199653],"thread-7199413":["thread",7199413],"thread-7199301":["thread",7199301],"thread-7198806":["thread",7198806],"thread-7198495":["thread",7198495],"thread-7197629":["thread",7197629],"thread-7195625":["thread",7195625],"thread-7190854":["thread",7190854],"thread-7187131":["thread",7187131],"thread-7185973":["thread",7185973],"thread-7185068":["thread",7185068],"thread-7184759":["thread",7184759],"thread-7182687":["thread",7182687],"thread-7182142":["thread",7182142],"thread-7181518":["thread",7181518],"thread-7180825":["thread",7180825],"thread-7180442":["thread",7180442],"thread-7179488":["thread",7179488],"thread-7177499":["thread",7177499],"thread-7177080":["thread",7177080],"thread-7176245":["thread",7176245],"thread-7175699":["thread",7175699],"thread-7175668":["thread",7175668],"thread-7175455":["thread",7175455],"thread-7175304":["thread",7175304],"thread-7174306":["thread",7174306],"thread-7173560":["thread",7173560],"thread-7171489":["thread",7171489],"thread-7169763":["thread",7169763],"thread-7169509":["thread",7169509],"thread-7169484":["thread",7169484],"thread-7169460":["thread",7169460],"thread-7168563":["thread",7168563],"thread-7165128":["thread",7165128],"thread-7164400":["thread",7164400],"thread-7160641":["thread",7160641],"thread-7158024":["thread",7158024],"thread-7156374":["thread",7156374],"thread-7152646":["thread",7152646],"thread-7152179":["thread",7152179],"thread-7150290":["thread",7150290],"thread-7150178":["thread",7150178],"thread-7149867":["thread",7149867],"thread-7149846":["thread",7149846],"thread-7149656":["thread",7149656],"thread-7148422":["thread",7148422],"thread-7145004":["thread",7145004],"thread-7144520":["thread",7144520],"thread-7142977":["thread",7142977],"thread-7140617":["thread",7140617],"thread-7139650":["thread",7139650],"thread-7138594":["thread",7138594],"thread-7138569":["thread",7138569],"thread-7138543":["thread",7138543],"thread-7134918":["thread",7134918],"thread-7134240":["thread",7134240],"thread-7134123":["thread",7134123],"thread-7134079":["thread",7134079],"thread-7133034":["thread",7133034],"thread-7132668":["thread",7132668],"thread-7126732":["thread",7126732],"thread-7120172":["thread",7120172],"thread-7118381":["thread",7118381],"thread-7117009":["thread",7117009],"thread-7114736":["thread",7114736],"thread-7114573":["thread",7114573],"thread-7114036":["thread",7114036],"thread-7112706":["thread",7112706],"thread-7109976":["thread",7109976],"thread-7109703":["thread",7109703],"thread-7108803":["thread",7108803],"thread-7107619":["thread",7107619],"thread-7106286":["thread",7106286],"thread-7102033":["thread",7102033],"thread-7100527":["thread",7100527],"thread-7097156":["thread",7097156],"thread-7096754":["thread",7096754],"thread-7096212":["thread",7096212],"thread-7084606":["thread",7084606],"thread-7084103":["thread",7084103],"thread-7081050":["thread",7081050],"thread-7077859":["thread",7077859],"thread-7077434":["thread",7077434],"thread-7077364":["thread",7077364],"thread-7074991":["thread",7074991],"thread-7074544":["thread",7074544],"thread-7073455":["thread",7073455],"thread-7072653":["thread",7072653],"thread-7072031":["thread",7072031],"thread-7071706":["thread",7071706],"thread-7066964":["thread",7066964],"thread-7066950":["thread",7066950],"thread-7063875":["thread",7063875],"thread-7062295":["thread",7062295],"thread-7060439":["thread",7060439],"thread-7057986":["thread",7057986],"thread-7054826":["thread",7054826],"thread-7053825":["thread",7053825],"thread-7052846":["thread",7052846],"thread-7043222":["thread",7043222],"thread-7033185":["thread",7033185],"thread-7032915":["thread",7032915],"thread-7031289":["thread",7031289],"thread-7026659":["thread",7026659],"thread-7023595":["thread",7023595],"thread-7022016":["thread",7022016],"thread-7019271":["thread",7019271],"thread-7017827":["thread",7017827],"thread-7016832":["thread",7016832],"thread-7015680":["thread",7015680],"thread-7011438":["thread",7011438],"thread-7011048":["thread",7011048],"thread-7008676":["thread",7008676],"thread-7008432":["thread",7008432],"thread-7006399":["thread",7006399],"thread-7003704":["thread",7003704],"thread-7003456":["thread",7003456],"thread-7002971":["thread",7002971],"thread-7002890":["thread",7002890],"thread-7001527":["thread",7001527],"thread-6993566":["thread",6993566],"thread-6989434":["thread",6989434],"thread-6984828":["thread",6984828],"thread-6978633":["thread",6978633],"thread-6977646":["thread",6977646],"thread-6975239":["thread",6975239],"thread-6973519":["thread",6973519],"thread-6969076":["thread",6969076],"thread-6967126":["thread",6967126],"thread-6868184":["thread",6868184],"thread-6732690":["thread",6732690],"thread-6610902":["thread",6610902],"thread-6605966":["thread",6605966],"thread-6281142":["thread",6281142],"thread-239564":["thread",239564],"thread-235508":["thread",235508],"thread-228483":["thread",228483],"thread-224964":["thread",224964],"thread-217671":["thread",217671],"thread-211524":["thread",211524],"thread-197041":["thread",197041],"thread-196534":["thread",196534],"thread-190470":["thread",190470],"thread-188198":["thread",188198],"thread-179610":["thread",179610],"thread-174391":["thread",174391],"thread-172634":["thread",172634],"thread-160403":["thread",160403],"thread-154417":["thread",154417],"thread-13830":["thread",13830],"thread-13825":["thread",13825],"thread-13756":["thread",13756],"thread-13708":["thread",13708],"thread-13679":["thread",13679],"thread-13650":["thread",13650],"thread-13637":["thread",13637],"thread-13560":["thread",13560],"thread-13557":["thread",13557],"thread-13548":["thread",13548],"thread-13449":["thread",13449],"thread-13448":["thread",13448],"thread-13370":["thread",13370],"thread-13333":["thread",13333],"thread-13305":["thread",13305],"thread-13290":["thread",13290],"thread-13204":["thread",13204],"thread-13186":["thread",13186],"thread-13177":["thread",13177],"thread-13169":["thread",13169],"thread-13159":["thread",13159],"thread-13150":["thread",13150],"thread-13139":["thread",13139],"thread-13133":["thread",13133],"thread-13113":["thread",13113],"thread-13101":["thread",13101],"thread-13085":["thread",13085],"thread-12927":["thread",12927],"thread-12920":["thread",12920],"thread-12892":["thread",12892],"thread-12825":["thread",12825],"thread-12790":["thread",12790],"thread-12781":["thread",12781],"thread-12777":["thread",12777],"thread-12677":["thread",12677],"thread-12612":["thread",12612],"thread-12557":["thread",12557],"thread-12556":["thread",12556],"thread-12543":["thread",12543],"thread-12516":["thread",12516]}, NULL, 1714384033
Run Time: 0.000527
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20