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 (181706, 181594, 181375, 181230, 180510, 180291, 180207, 179811, 179060, 179056, 178110, 178095, 177446, 176186, 168117, 161479, 157378, 125222, 124128, 121665, 120797, 116907, 114180, 113825, 113771, 110984, 110766, 110451, 110410, 110401, 110121, 109903, 109865, 109429, 109146, 109039, 108800, 108743, 108646, 108632, 108385, 108335, 108269, 108268, 107937, 107918, 107917, 107862, 107861, 107804, 107641, 107593, 107499, 107028, 106623, 106399, 100277, 97307, 97244, 93970, 91438, 91158, 90418, 88932, 88756, 87907, 87216, 87125, 86765, 86638, 85498, 84023, 84022, 83878, 83063, 82663, 82583, 82351, 80712, 80665, 80657, 80349, 80206, 80065, 79926, 78949, 78940, 78499, 78388, 77800, 77018, 76483, 76107, 75860, 75607, 75534, 75460, 75457, 75416, 74742, 74078, 73567, 73463, 72864, 72252, 72228, 71705, 71042, 70835, 70645, 70535, 70501, 69922, 69865, 69659, 69503, 69424, 68732, 67868, 67674, 67661, 67050, 66381, 65529, 64713, 63069, 62714, 61967, 60392, 59160, 58951, 58556, 58207, 57663, 57022, 56804, 55968, 55767, 53431, 53103, 53092, 50805, 50322, 49271, 49211, 49040, 48973, 48797, 48649, 48252, 48163, 47901, 47862, 47774, 47421, 46991, 46439, 46198, 45286, 44222, 43987, 43532, 42117, 41645, 41644, 39044, 39008, 36877, 32566, 32197, 29313, 24194, 15844, 15264, 9786, 7441))
Run Time: 0.078443
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 176 | 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: 1371, 0, 1715604187, {"thread-181706":["thread",181706],"thread-181594":["thread",181594],"thread-181375":["thread",181375],"thread-181230":["thread",181230],"thread-180510":["thread",180510],"thread-180291":["thread",180291],"thread-180207":["thread",180207],"thread-179811":["thread",179811],"thread-179060":["thread",179060],"thread-179056":["thread",179056],"thread-178110":["thread",178110],"thread-178095":["thread",178095],"thread-177446":["thread",177446],"thread-176186":["thread",176186],"thread-168117":["thread",168117],"thread-161479":["thread",161479],"thread-157378":["thread",157378],"thread-125222":["thread",125222],"thread-124128":["thread",124128],"thread-121665":["thread",121665],"thread-120797":["thread",120797],"thread-116907":["thread",116907],"thread-114180":["thread",114180],"thread-113825":["thread",113825],"thread-113771":["thread",113771],"thread-110984":["thread",110984],"thread-110766":["thread",110766],"thread-110451":["thread",110451],"thread-110410":["thread",110410],"thread-110401":["thread",110401],"thread-110121":["thread",110121],"thread-109903":["thread",109903],"thread-109865":["thread",109865],"thread-109429":["thread",109429],"thread-109146":["thread",109146],"thread-109039":["thread",109039],"thread-108800":["thread",108800],"thread-108743":["thread",108743],"thread-108646":["thread",108646],"thread-108632":["thread",108632],"thread-108385":["thread",108385],"thread-108335":["thread",108335],"thread-108269":["thread",108269],"thread-108268":["thread",108268],"thread-107937":["thread",107937],"thread-107918":["thread",107918],"thread-107917":["thread",107917],"thread-107862":["thread",107862],"thread-107861":["thread",107861],"thread-107804":["thread",107804],"thread-107641":["thread",107641],"thread-107593":["thread",107593],"thread-107499":["thread",107499],"thread-107028":["thread",107028],"thread-106623":["thread",106623],"thread-106399":["thread",106399],"thread-100277":["thread",100277],"thread-97307":["thread",97307],"thread-97244":["thread",97244],"thread-93970":["thread",93970],"thread-91438":["thread",91438],"thread-91158":["thread",91158],"thread-90418":["thread",90418],"thread-88932":["thread",88932],"thread-88756":["thread",88756],"thread-87907":["thread",87907],"thread-87216":["thread",87216],"thread-87125":["thread",87125],"thread-86765":["thread",86765],"thread-86638":["thread",86638],"thread-85498":["thread",85498],"thread-84023":["thread",84023],"thread-84022":["thread",84022],"thread-83878":["thread",83878],"thread-83063":["thread",83063],"thread-82663":["thread",82663],"thread-82583":["thread",82583],"thread-82351":["thread",82351],"thread-80712":["thread",80712],"thread-80665":["thread",80665],"thread-80657":["thread",80657],"thread-80349":["thread",80349],"thread-80206":["thread",80206],"thread-80065":["thread",80065],"thread-79926":["thread",79926],"thread-78949":["thread",78949],"thread-78940":["thread",78940],"thread-78499":["thread",78499],"thread-78388":["thread",78388],"thread-77800":["thread",77800],"thread-77018":["thread",77018],"thread-76483":["thread",76483],"thread-76107":["thread",76107],"thread-75860":["thread",75860],"thread-75607":["thread",75607],"thread-75534":["thread",75534],"thread-75460":["thread",75460],"thread-75457":["thread",75457],"thread-75416":["thread",75416],"thread-74742":["thread",74742],"thread-74078":["thread",74078],"thread-73567":["thread",73567],"thread-73463":["thread",73463],"thread-72864":["thread",72864],"thread-72252":["thread",72252],"thread-72228":["thread",72228],"thread-71705":["thread",71705],"thread-71042":["thread",71042],"thread-70835":["thread",70835],"thread-70645":["thread",70645],"thread-70535":["thread",70535],"thread-70501":["thread",70501],"thread-69922":["thread",69922],"thread-69865":["thread",69865],"thread-69659":["thread",69659],"thread-69503":["thread",69503],"thread-69424":["thread",69424],"thread-68732":["thread",68732],"thread-67868":["thread",67868],"thread-67674":["thread",67674],"thread-67661":["thread",67661],"thread-67050":["thread",67050],"thread-66381":["thread",66381],"thread-65529":["thread",65529],"thread-64713":["thread",64713],"thread-63069":["thread",63069],"thread-62714":["thread",62714],"thread-61967":["thread",61967],"thread-60392":["thread",60392],"thread-59160":["thread",59160],"thread-58951":["thread",58951],"thread-58556":["thread",58556],"thread-58207":["thread",58207],"thread-57663":["thread",57663],"thread-57022":["thread",57022],"thread-56804":["thread",56804],"thread-55968":["thread",55968],"thread-55767":["thread",55767],"thread-53431":["thread",53431],"thread-53103":["thread",53103],"thread-53092":["thread",53092],"thread-50805":["thread",50805],"thread-50322":["thread",50322],"thread-49271":["thread",49271],"thread-49211":["thread",49211],"thread-49040":["thread",49040],"thread-48973":["thread",48973],"thread-48797":["thread",48797],"thread-48649":["thread",48649],"thread-48252":["thread",48252],"thread-48163":["thread",48163],"thread-47901":["thread",47901],"thread-47862":["thread",47862],"thread-47774":["thread",47774],"thread-47421":["thread",47421],"thread-46991":["thread",46991],"thread-46439":["thread",46439],"thread-46198":["thread",46198],"thread-45286":["thread",45286],"thread-44222":["thread",44222],"thread-43987":["thread",43987],"thread-43532":["thread",43532],"thread-42117":["thread",42117],"thread-41645":["thread",41645],"thread-41644":["thread",41644],"thread-39044":["thread",39044],"thread-39008":["thread",39008],"thread-36877":["thread",36877],"thread-32566":["thread",32566],"thread-32197":["thread",32197],"thread-29313":["thread",29313],"thread-24194":["thread",24194],"thread-15844":["thread",15844],"thread-15264":["thread",15264],"thread-9786":["thread",9786],"thread-7441":["thread",7441]}, , 1715600587
Run Time: 0.000409
- 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