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 (180930, 180759, 180548, 180519, 180392, 180391, 180312, 180203, 180202, 179062, 178646, 177458, 177339, 177135, 176314, 176281, 176137, 176062, 175924, 175689, 175483, 175253, 174612, 174398, 174325, 174072, 173584, 172913, 172909, 172747, 172537, 172289, 171883, 171747, 171743, 171607, 171487, 171344, 171284, 171171, 171017, 171001, 170995, 170994, 170922, 170879, 170867, 170384, 169908, 169578, 169438, 169238, 169113, 169094, 168958, 168927, 168756, 168755, 168753, 168734, 168608, 168462, 168348, 168347, 168119, 168084, 167867, 167839, 166996, 166577, 166258, 166249, 166230, 165645, 165094, 164674, 164503, 164134, 163441, 163394, 163378, 163377, 163376, 163375, 163374, 163373, 163372, 163371, 162188, 161931, 161676, 161675, 161670, 161519, 160167, 160100, 159625, 159129, 158984, 158910, 158405, 158376, 158351, 158267, 158002, 157995, 157872, 157745, 157716, 157431, 157430, 157323, 157002, 156941, 156930, 156912, 156893, 156379, 156306, 156259, 156258, 156250, 156248, 156164, 156125, 155930, 155897, 155660, 155617, 155546, 155204, 155189, 155145, 155138, 155123, 154782, 154419, 154226, 153631, 152811, 151205, 149762, 149561, 149506, 149443, 149429, 144507, 144294, 144283, 137534, 137509, 137508, 134664, 134662, 134660, 132498, 132425, 130515, 130343, 130341))
Run Time: 0.116167
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 160 | 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: 37355, 0, 1714883809, {"thread-180930":["thread",180930],"thread-180759":["thread",180759],"thread-180548":["thread",180548],"thread-180519":["thread",180519],"thread-180392":["thread",180392],"thread-180391":["thread",180391],"thread-180312":["thread",180312],"thread-180203":["thread",180203],"thread-180202":["thread",180202],"thread-179062":["thread",179062],"thread-178646":["thread",178646],"thread-177458":["thread",177458],"thread-177339":["thread",177339],"thread-177135":["thread",177135],"thread-176314":["thread",176314],"thread-176281":["thread",176281],"thread-176137":["thread",176137],"thread-176062":["thread",176062],"ams_article-5088":["ams_article",5088],"thread-175924":["thread",175924],"thread-175689":["thread",175689],"thread-175483":["thread",175483],"thread-175253":["thread",175253],"thread-174612":["thread",174612],"thread-174398":["thread",174398],"thread-174325":["thread",174325],"thread-174072":["thread",174072],"thread-173584":["thread",173584],"ams_article-4925":["ams_article",4925],"thread-172913":["thread",172913],"thread-172909":["thread",172909],"ams_article-4922":["ams_article",4922],"thread-172747":["thread",172747],"thread-172537":["thread",172537],"thread-172289":["thread",172289],"ams_article-4890":["ams_article",4890],"thread-171883":["thread",171883],"thread-171747":["thread",171747],"thread-171743":["thread",171743],"thread-171607":["thread",171607],"thread-171487":["thread",171487],"ams_article-4868":["ams_article",4868],"thread-171344":["thread",171344],"thread-171284":["thread",171284],"thread-171171":["thread",171171],"thread-171017":["thread",171017],"thread-171001":["thread",171001],"thread-170995":["thread",170995],"thread-170994":["thread",170994],"thread-170922":["thread",170922],"thread-170879":["thread",170879],"thread-170867":["thread",170867],"thread-170384":["thread",170384],"ams_article-4827":["ams_article",4827],"thread-169908":["thread",169908],"thread-169578":["thread",169578],"thread-169438":["thread",169438],"thread-169238":["thread",169238],"thread-169113":["thread",169113],"thread-169094":["thread",169094],"thread-168958":["thread",168958],"thread-168927":["thread",168927],"thread-168756":["thread",168756],"thread-168755":["thread",168755],"thread-168753":["thread",168753],"thread-168734":["thread",168734],"thread-168608":["thread",168608],"thread-168462":["thread",168462],"thread-168348":["thread",168348],"thread-168347":["thread",168347],"thread-168119":["thread",168119],"thread-168084":["thread",168084],"thread-167867":["thread",167867],"thread-167839":["thread",167839],"thread-166996":["thread",166996],"thread-166577":["thread",166577],"thread-166258":["thread",166258],"thread-166249":["thread",166249],"thread-166230":["thread",166230],"thread-165645":["thread",165645],"thread-165094":["thread",165094],"thread-164674":["thread",164674],"thread-164503":["thread",164503],"thread-164134":["thread",164134],"tl_group-204":["tl_group",204],"thread-163441":["thread",163441],"thread-163394":["thread",163394],"thread-163378":["thread",163378],"thread-163377":["thread",163377],"thread-163376":["thread",163376],"thread-163375":["thread",163375],"thread-163374":["thread",163374],"thread-163373":["thread",163373],"thread-163372":["thread",163372],"thread-163371":["thread",163371],"thread-162188":["thread",162188],"thread-161931":["thread",161931],"thread-161676":["thread",161676],"thread-161675":["thread",161675],"thread-161670":["thread",161670],"thread-161519":["thread",161519],"thread-160167":["thread",160167],"thread-160100":["thread",160100],"thread-159625":["thread",159625],"thread-159129":["thread",159129],"thread-158984":["thread",158984],"thread-158910":["thread",158910],"thread-158405":["thread",158405],"thread-158376":["thread",158376],"thread-158351":["thread",158351],"thread-158267":["thread",158267],"thread-158002":["thread",158002],"thread-157995":["thread",157995],"thread-157872":["thread",157872],"thread-157745":["thread",157745],"thread-157716":["thread",157716],"ams_article-4305":["ams_article",4305],"thread-157431":["thread",157431],"thread-157430":["thread",157430],"thread-157323":["thread",157323],"thread-157002":["thread",157002],"thread-156941":["thread",156941],"thread-156930":["thread",156930],"thread-156912":["thread",156912],"thread-156893":["thread",156893],"thread-156379":["thread",156379],"thread-156306":["thread",156306],"thread-156259":["thread",156259],"thread-156258":["thread",156258],"thread-156250":["thread",156250],"thread-156248":["thread",156248],"thread-156164":["thread",156164],"thread-156125":["thread",156125],"thread-155930":["thread",155930],"thread-155897":["thread",155897],"thread-155660":["thread",155660],"thread-155617":["thread",155617],"thread-155546":["thread",155546],"thread-155204":["thread",155204],"thread-155189":["thread",155189],"thread-155145":["thread",155145],"thread-155138":["thread",155138],"thread-155123":["thread",155123],"tl_group-108":["tl_group",108],"thread-154782":["thread",154782],"thread-154419":["thread",154419],"thread-154226":["thread",154226],"thread-153631":["thread",153631],"thread-152811":["thread",152811],"thread-151205":["thread",151205],"thread-149762":["thread",149762],"thread-149561":["thread",149561],"thread-149506":["thread",149506],"thread-149443":["thread",149443],"thread-149429":["thread",149429],"thread-144507":["thread",144507],"thread-144294":["thread",144294],"thread-144283":["thread",144283],"thread-137534":["thread",137534],"thread-137509":["thread",137509],"thread-137508":["thread",137508],"thread-134664":["thread",134664],"thread-134662":["thread",134662],"thread-134660":["thread",134660],"thread-132498":["thread",132498],"thread-132425":["thread",132425],"thread-130515":["thread",130515],"thread-130343":["thread",130343],"thread-130341":["thread",130341]}, , 1714880209
Run Time: 0.000236
- 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