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 (182019, 181976, 181922, 181857, 181824, 181811, 181126, 181125, 180316, 180311, 179705, 179653, 177271, 177255, 176777, 171835, 171672, 169565, 169563, 169425, 168465, 168022, 167815, 164410, 164271, 164089, 164033, 163390, 163194, 163154, 163050, 162233, 162204, 162171, 162169, 162103, 161512, 160736, 159448, 158305, 158227, 158178, 157895, 157702, 157234, 156944, 156937, 156875, 156796, 156533, 156476, 156460, 156273, 156161, 156130, 156128, 156121, 156116, 155992, 155948, 155835, 154318, 154037, 153628, 153627, 153251, 129562, 127564, 126420, 116759, 116424, 115981, 106591, 96949, 74738, 73342, 68910, 64280, 54049, 46536, 46490, 45761, 44154, 43381, 42555, 42283, 41934, 41932, 41861, 41855, 15436, 10274, 4060, 4053, 4065, 4075, 1973, 1929, 1849, 1810))
Run Time: 0.052728
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 100 | 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: 521, 0, 1715936751, {"thread-182019":["thread",182019],"thread-181976":["thread",181976],"thread-181922":["thread",181922],"thread-181857":["thread",181857],"thread-181824":["thread",181824],"thread-181811":["thread",181811],"thread-181126":["thread",181126],"thread-181125":["thread",181125],"thread-180316":["thread",180316],"thread-180311":["thread",180311],"thread-179705":["thread",179705],"thread-179653":["thread",179653],"thread-177271":["thread",177271],"thread-177255":["thread",177255],"thread-176777":["thread",176777],"thread-171835":["thread",171835],"thread-169565":["thread",169565],"thread-169563":["thread",169563],"thread-169425":["thread",169425],"thread-168465":["thread",168465],"thread-168022":["thread",168022],"thread-167815":["thread",167815],"thread-164410":["thread",164410],"thread-164271":["thread",164271],"thread-164033":["thread",164033],"thread-163390":["thread",163390],"thread-163194":["thread",163194],"thread-163154":["thread",163154],"thread-163050":["thread",163050],"thread-162233":["thread",162233],"thread-162204":["thread",162204],"thread-162171":["thread",162171],"thread-162169":["thread",162169],"thread-162103":["thread",162103],"thread-161512":["thread",161512],"thread-160736":["thread",160736],"thread-159448":["thread",159448],"thread-158305":["thread",158305],"thread-158227":["thread",158227],"thread-158178":["thread",158178],"thread-157702":["thread",157702],"thread-157234":["thread",157234],"thread-156944":["thread",156944],"thread-156937":["thread",156937],"thread-156875":["thread",156875],"thread-156796":["thread",156796],"thread-156533":["thread",156533],"thread-156476":["thread",156476],"thread-156460":["thread",156460],"thread-156273":["thread",156273],"thread-156161":["thread",156161],"thread-156130":["thread",156130],"thread-156128":["thread",156128],"thread-156121":["thread",156121],"thread-156116":["thread",156116],"thread-155992":["thread",155992],"thread-155948":["thread",155948],"thread-155835":["thread",155835],"thread-154318":["thread",154318],"thread-154037":["thread",154037],"thread-153628":["thread",153628],"thread-153627":["thread",153627],"thread-153251":["thread",153251],"thread-129562":["thread",129562],"thread-127564":["thread",127564],"thread-126420":["thread",126420],"thread-116759":["thread",116759],"thread-116424":["thread",116424],"thread-115981":["thread",115981],"thread-106591":["thread",106591],"thread-96949":["thread",96949],"thread-74738":["thread",74738],"thread-73342":["thread",73342],"thread-68910":["thread",68910],"thread-64280":["thread",64280],"thread-54049":["thread",54049],"thread-46536":["thread",46536],"thread-46490":["thread",46490],"thread-45761":["thread",45761],"thread-44154":["thread",44154],"thread-43381":["thread",43381],"thread-42555":["thread",42555],"thread-42283":["thread",42283],"thread-41934":["thread",41934],"thread-41932":["thread",41932],"thread-41861":["thread",41861],"thread-41855":["thread",41855],"thread-15436":["thread",15436],"thread-10274":["thread",10274],"thread-4060":["thread",4060],"thread-4053":["thread",4053],"thread-4065":["thread",4065],"thread-4075":["thread",4075],"thread-1973":["thread",1973],"thread-1929":["thread",1929],"thread-1849":["thread",1849],"thread-1810":["thread",1810]}, , 1715933151
Run Time: 0.000821
- 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