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 (182908, 182619, 182508, 182480, 182314, 182310, 181108, 179823, 179419, 179268, 179266, 179231, 179158, 179004, 178785, 178589, 178328, 177998, 177508, 177435, 177431, 177237, 177114, 176962, 176951, 176829, 175840, 175539, 175232, 174899, 174783, 174767, 174736, 174527, 174456, 174205, 173603, 173595, 173589, 173537, 173393, 172843, 172496, 172404, 172395, 172292, 171231, 171097, 170868, 170550, 170437, 170417, 169956, 169619, 167766, 167086, 167008, 165830, 164974, 163954, 163656, 163361, 159794, 159180, 159038, 158598, 158302, 158291, 156828, 155731, 153990, 153601, 153350, 153330, 152970, 152566, 152518, 152301, 152219, 151890, 151689, 140733, 132091, 131946, 131744, 131697, 131492, 131345, 131338, 130922, 130595, 130206, 130035, 129862, 129841, 129838, 129512, 129424, 129245, 129206, 128344, 128341, 128260, 128234, 128232, 128175, 128050, 127894, 127499, 127464, 127367, 127209, 126826, 126613, 126524, 126400, 126189, 126121, 126116, 126080, 126039, 125672, 125465, 125288, 125069, 125017, 124580, 124568, 124381, 124370, 124246, 124019, 123990, 123953, 123768, 123716, 123514, 123474, 123444, 123120, 123073, 122956, 122934, 122758, 122505, 122291, 122266, 122122, 122117, 121789, 121778, 121128, 121093, 120979, 120820, 120608, 120529, 120500, 120477, 120234, 120108, 119950, 119390, 119324, 119160, 119090, 119000, 118960, 118892, 118891, 118836, 118773, 118502, 118315, 118280, 118243, 118225, 118163, 118140, 118091, 117961, 117950, 117841, 117725, 117716, 117621, 117616, 117579, 117539, 117518, 117484, 117477, 117366, 117264, 117237, 117196, 117172, 117170, 117066, 116957))
Run Time: 0.086792
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: 736, 0, 1714972981, {"thread-182908":["thread",182908],"thread-182619":["thread",182619],"thread-182508":["thread",182508],"thread-182480":["thread",182480],"thread-182314":["thread",182314],"thread-182310":["thread",182310],"thread-181108":["thread",181108],"thread-179823":["thread",179823],"thread-179419":["thread",179419],"thread-179268":["thread",179268],"thread-179266":["thread",179266],"thread-179231":["thread",179231],"thread-179158":["thread",179158],"thread-179004":["thread",179004],"thread-178785":["thread",178785],"thread-178589":["thread",178589],"thread-178328":["thread",178328],"thread-177998":["thread",177998],"thread-177508":["thread",177508],"thread-177435":["thread",177435],"thread-177431":["thread",177431],"thread-177237":["thread",177237],"thread-177114":["thread",177114],"thread-176962":["thread",176962],"thread-176951":["thread",176951],"thread-176829":["thread",176829],"thread-175840":["thread",175840],"thread-175539":["thread",175539],"thread-175232":["thread",175232],"thread-174899":["thread",174899],"thread-174783":["thread",174783],"thread-174767":["thread",174767],"thread-174736":["thread",174736],"thread-174527":["thread",174527],"thread-174456":["thread",174456],"thread-174205":["thread",174205],"thread-173603":["thread",173603],"thread-173595":["thread",173595],"thread-173589":["thread",173589],"thread-173537":["thread",173537],"thread-173393":["thread",173393],"thread-172843":["thread",172843],"thread-172496":["thread",172496],"thread-172404":["thread",172404],"thread-172395":["thread",172395],"thread-172292":["thread",172292],"thread-171231":["thread",171231],"thread-171097":["thread",171097],"thread-170868":["thread",170868],"thread-170550":["thread",170550],"thread-170437":["thread",170437],"thread-170417":["thread",170417],"thread-169956":["thread",169956],"thread-169619":["thread",169619],"thread-167766":["thread",167766],"thread-167086":["thread",167086],"thread-167008":["thread",167008],"thread-165830":["thread",165830],"thread-164974":["thread",164974],"thread-163954":["thread",163954],"thread-163656":["thread",163656],"thread-163361":["thread",163361],"thread-159794":["thread",159794],"thread-159180":["thread",159180],"thread-159038":["thread",159038],"thread-158598":["thread",158598],"thread-158302":["thread",158302],"thread-158291":["thread",158291],"thread-156828":["thread",156828],"thread-155731":["thread",155731],"thread-153990":["thread",153990],"thread-153601":["thread",153601],"thread-153350":["thread",153350],"thread-153330":["thread",153330],"thread-152970":["thread",152970],"thread-152566":["thread",152566],"thread-152518":["thread",152518],"thread-152301":["thread",152301],"thread-152219":["thread",152219],"thread-151890":["thread",151890],"thread-151689":["thread",151689],"thread-140733":["thread",140733],"thread-132091":["thread",132091],"thread-131946":["thread",131946],"thread-131744":["thread",131744],"thread-131697":["thread",131697],"thread-131492":["thread",131492],"thread-131345":["thread",131345],"thread-131338":["thread",131338],"thread-130922":["thread",130922],"thread-130595":["thread",130595],"thread-130206":["thread",130206],"thread-130035":["thread",130035],"thread-129862":["thread",129862],"thread-129841":["thread",129841],"thread-129838":["thread",129838],"thread-129512":["thread",129512],"thread-129424":["thread",129424],"thread-129245":["thread",129245],"thread-129206":["thread",129206],"thread-128344":["thread",128344],"thread-128341":["thread",128341],"thread-128260":["thread",128260],"thread-128234":["thread",128234],"thread-128232":["thread",128232],"thread-128175":["thread",128175],"thread-128050":["thread",128050],"thread-127894":["thread",127894],"thread-127499":["thread",127499],"thread-127464":["thread",127464],"thread-127367":["thread",127367],"thread-127209":["thread",127209],"thread-126826":["thread",126826],"thread-126613":["thread",126613],"thread-126524":["thread",126524],"thread-126400":["thread",126400],"thread-126189":["thread",126189],"thread-126121":["thread",126121],"thread-126116":["thread",126116],"thread-126080":["thread",126080],"thread-126039":["thread",126039],"thread-125672":["thread",125672],"thread-125465":["thread",125465],"thread-125288":["thread",125288],"thread-125069":["thread",125069],"thread-125017":["thread",125017],"thread-124580":["thread",124580],"thread-124568":["thread",124568],"thread-124381":["thread",124381],"thread-124370":["thread",124370],"thread-124246":["thread",124246],"thread-124019":["thread",124019],"thread-123990":["thread",123990],"thread-123953":["thread",123953],"thread-123768":["thread",123768],"thread-123716":["thread",123716],"thread-123514":["thread",123514],"thread-123474":["thread",123474],"thread-123444":["thread",123444],"thread-123120":["thread",123120],"thread-123073":["thread",123073],"thread-122956":["thread",122956],"thread-122934":["thread",122934],"thread-122758":["thread",122758],"thread-122505":["thread",122505],"thread-122291":["thread",122291],"thread-122266":["thread",122266],"thread-122122":["thread",122122],"thread-122117":["thread",122117],"thread-121789":["thread",121789],"thread-121778":["thread",121778],"thread-121128":["thread",121128],"thread-121093":["thread",121093],"thread-120979":["thread",120979],"thread-120820":["thread",120820],"thread-120608":["thread",120608],"thread-120529":["thread",120529],"thread-120500":["thread",120500],"thread-120477":["thread",120477],"thread-120234":["thread",120234],"thread-120108":["thread",120108],"thread-119950":["thread",119950],"thread-119390":["thread",119390],"thread-119324":["thread",119324],"thread-119160":["thread",119160],"thread-119090":["thread",119090],"thread-119000":["thread",119000],"thread-118960":["thread",118960],"thread-118892":["thread",118892],"thread-118891":["thread",118891],"thread-118836":["thread",118836],"thread-118773":["thread",118773],"thread-118502":["thread",118502],"thread-118315":["thread",118315],"thread-118280":["thread",118280],"thread-118243":["thread",118243],"thread-118225":["thread",118225],"thread-118163":["thread",118163],"thread-118140":["thread",118140],"thread-118091":["thread",118091],"thread-117961":["thread",117961],"thread-117950":["thread",117950],"thread-117841":["thread",117841],"thread-117725":["thread",117725],"thread-117716":["thread",117716],"thread-117621":["thread",117621],"thread-117616":["thread",117616],"thread-117579":["thread",117579],"thread-117539":["thread",117539],"thread-117518":["thread",117518],"thread-117484":["thread",117484],"thread-117477":["thread",117477],"thread-117366":["thread",117366],"thread-117264":["thread",117264],"thread-117237":["thread",117237],"thread-117196":["thread",117196],"thread-117172":["thread",117172],"thread-117170":["thread",117170],"thread-117066":["thread",117066],"thread-116957":["thread",116957]}, , 1714969381
Run Time: 0.000553
- 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