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 (183100, 183068, 182035, 181996, 181628, 181426, 181386, 181353, 181244, 181216, 181187, 181174, 181131, 180281, 180160, 179665, 179153, 179134, 178967, 178456, 178111, 177750, 177651, 176897, 176716, 176554, 176358, 176357, 176085, 176010, 176003, 175936, 175881, 175795, 175674, 175002, 174941, 174468, 174045, 173921, 173897, 173880, 172825, 172351, 172131, 172106, 172011, 171963, 171896, 171738, 171736, 171698, 171697, 171662, 171626, 171611, 170996, 170886, 170846, 170790, 170556, 170392, 170317, 169624, 169617, 169614, 169604, 169603, 169080, 169064, 169061, 169060, 169053, 168866, 168788, 168470, 168341, 168309, 168170, 168089, 167888, 167505, 166923, 166776, 166556, 166411, 166404, 166397, 166199, 166124, 166081, 166079, 166005, 165794, 165790, 165787, 165781, 165692, 165592, 165518, 165211, 165094, 164814, 164717, 164119, 163956, 163923, 163837, 163732, 163633, 163606, 163229, 162255, 162153, 162009, 161484, 161285, 160920, 160889, 160832, 160708, 160528, 160173, 160160, 160159, 159635, 159547, 159546, 159525, 159335, 159284, 159117, 158942, 158828, 158810, 158569, 158066, 158065, 157953, 157933, 157886, 157716, 157675, 157578, 157563, 157531, 157500, 157368, 157282, 157167, 156786, 156717, 156715, 156713, 156689, 156532, 156531, 156459, 156383, 156234, 156078, 155541, 155394, 155355, 155313, 155260, 155109, 154940, 154934, 154907, 154795, 154694, 154658, 154523, 154230, 154125, 153973, 153860, 153717, 153596, 153562, 153334, 153114, 153043, 153038, 153028, 152772, 152760, 152704, 152611, 152352, 151789, 97514, 68061, 67873, 67186, 66870, 66368, 65415, 65363))
Run Time: 0.101586
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: 73, 0, 1714714522, {"thread-183100":["thread",183100],"thread-183068":["thread",183068],"thread-182035":["thread",182035],"thread-181996":["thread",181996],"thread-181628":["thread",181628],"thread-181426":["thread",181426],"thread-181386":["thread",181386],"thread-181353":["thread",181353],"thread-181244":["thread",181244],"thread-181216":["thread",181216],"thread-181187":["thread",181187],"thread-181174":["thread",181174],"thread-181131":["thread",181131],"thread-180281":["thread",180281],"thread-180160":["thread",180160],"thread-179665":["thread",179665],"thread-179153":["thread",179153],"thread-179134":["thread",179134],"thread-178967":["thread",178967],"thread-178456":["thread",178456],"thread-178111":["thread",178111],"thread-177750":["thread",177750],"thread-177651":["thread",177651],"thread-176897":["thread",176897],"thread-176716":["thread",176716],"thread-176554":["thread",176554],"thread-176358":["thread",176358],"thread-176357":["thread",176357],"thread-176085":["thread",176085],"thread-176010":["thread",176010],"thread-176003":["thread",176003],"thread-175936":["thread",175936],"thread-175881":["thread",175881],"thread-175795":["thread",175795],"thread-175674":["thread",175674],"thread-175002":["thread",175002],"thread-174941":["thread",174941],"thread-174468":["thread",174468],"thread-174045":["thread",174045],"thread-173921":["thread",173921],"thread-173897":["thread",173897],"thread-173880":["thread",173880],"thread-172825":["thread",172825],"thread-172351":["thread",172351],"thread-172131":["thread",172131],"thread-172106":["thread",172106],"thread-172011":["thread",172011],"thread-171963":["thread",171963],"thread-171896":["thread",171896],"thread-171738":["thread",171738],"thread-171736":["thread",171736],"thread-171698":["thread",171698],"thread-171697":["thread",171697],"thread-171662":["thread",171662],"thread-171626":["thread",171626],"thread-171611":["thread",171611],"thread-170996":["thread",170996],"thread-170886":["thread",170886],"thread-170846":["thread",170846],"thread-170790":["thread",170790],"thread-170392":["thread",170392],"thread-170317":["thread",170317],"thread-169624":["thread",169624],"thread-169617":["thread",169617],"thread-169614":["thread",169614],"thread-169604":["thread",169604],"thread-169603":["thread",169603],"thread-169080":["thread",169080],"thread-169064":["thread",169064],"thread-169061":["thread",169061],"thread-169060":["thread",169060],"thread-169053":["thread",169053],"thread-168866":["thread",168866],"thread-168788":["thread",168788],"thread-168470":["thread",168470],"thread-168341":["thread",168341],"thread-168309":["thread",168309],"thread-168170":["thread",168170],"thread-168089":["thread",168089],"thread-167888":["thread",167888],"thread-167505":["thread",167505],"thread-166923":["thread",166923],"thread-166776":["thread",166776],"thread-166556":["thread",166556],"thread-166411":["thread",166411],"thread-166404":["thread",166404],"thread-166397":["thread",166397],"thread-166199":["thread",166199],"thread-166124":["thread",166124],"thread-166081":["thread",166081],"thread-166079":["thread",166079],"thread-166005":["thread",166005],"thread-165794":["thread",165794],"thread-165790":["thread",165790],"thread-165787":["thread",165787],"thread-165781":["thread",165781],"thread-165692":["thread",165692],"thread-165592":["thread",165592],"thread-165518":["thread",165518],"thread-165211":["thread",165211],"thread-165094":["thread",165094],"thread-164814":["thread",164814],"thread-164717":["thread",164717],"thread-164119":["thread",164119],"thread-163956":["thread",163956],"thread-163923":["thread",163923],"thread-163837":["thread",163837],"thread-163732":["thread",163732],"thread-163633":["thread",163633],"thread-163606":["thread",163606],"thread-163229":["thread",163229],"thread-162255":["thread",162255],"thread-162153":["thread",162153],"thread-162009":["thread",162009],"thread-161484":["thread",161484],"thread-161285":["thread",161285],"thread-160920":["thread",160920],"thread-160889":["thread",160889],"thread-160832":["thread",160832],"thread-160708":["thread",160708],"thread-160528":["thread",160528],"thread-160173":["thread",160173],"thread-160160":["thread",160160],"thread-160159":["thread",160159],"thread-159635":["thread",159635],"thread-159547":["thread",159547],"thread-159546":["thread",159546],"thread-159525":["thread",159525],"thread-159335":["thread",159335],"thread-159284":["thread",159284],"thread-159117":["thread",159117],"thread-158942":["thread",158942],"thread-158828":["thread",158828],"thread-158810":["thread",158810],"thread-158569":["thread",158569],"thread-158066":["thread",158066],"thread-158065":["thread",158065],"thread-157953":["thread",157953],"thread-157933":["thread",157933],"thread-157886":["thread",157886],"thread-157716":["thread",157716],"thread-157675":["thread",157675],"thread-157578":["thread",157578],"thread-157563":["thread",157563],"thread-157531":["thread",157531],"thread-157500":["thread",157500],"thread-157368":["thread",157368],"thread-157282":["thread",157282],"thread-157167":["thread",157167],"thread-156786":["thread",156786],"thread-156717":["thread",156717],"thread-156715":["thread",156715],"thread-156713":["thread",156713],"thread-156689":["thread",156689],"thread-156532":["thread",156532],"thread-156531":["thread",156531],"thread-156459":["thread",156459],"thread-156383":["thread",156383],"thread-156234":["thread",156234],"thread-156078":["thread",156078],"thread-155541":["thread",155541],"thread-155394":["thread",155394],"thread-155355":["thread",155355],"thread-155313":["thread",155313],"thread-155260":["thread",155260],"thread-155109":["thread",155109],"thread-154940":["thread",154940],"thread-154934":["thread",154934],"thread-154907":["thread",154907],"thread-154795":["thread",154795],"thread-154694":["thread",154694],"thread-154658":["thread",154658],"thread-154523":["thread",154523],"thread-154230":["thread",154230],"thread-154125":["thread",154125],"thread-153973":["thread",153973],"thread-153860":["thread",153860],"thread-153717":["thread",153717],"thread-153596":["thread",153596],"thread-153562":["thread",153562],"thread-153334":["thread",153334],"thread-153114":["thread",153114],"thread-153043":["thread",153043],"thread-153038":["thread",153038],"thread-153028":["thread",153028],"thread-152772":["thread",152772],"thread-152760":["thread",152760],"thread-152704":["thread",152704],"thread-152611":["thread",152611],"thread-152352":["thread",152352],"thread-151789":["thread",151789],"thread-97514":["thread",97514],"thread-68061":["thread",68061],"thread-67873":["thread",67873],"thread-67186":["thread",67186],"thread-66870":["thread",66870],"thread-66368":["thread",66368],"thread-65415":["thread",65415],"thread-65363":["thread",65363]}, , 1714710922
Run Time: 0.000178
- 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