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 (141935, 129025, 128494, 128336, 128312, 128259, 127498, 127126, 127053, 123725, 123646, 123443, 123432, 123313, 123302, 123192, 123187, 123182, 123167, 123130, 123102, 122096, 122064, 121161, 120378, 120365, 120350, 120287, 120109, 119334, 119277, 119189, 119142, 119122, 119120, 119023, 119007, 118876, 118677, 118461, 118126, 117847, 114670, 114557, 114464, 112760, 112415, 112297, 112142, 111934, 111897, 111717, 111640, 111462, 111246, 110502, 110501, 110326, 110284, 109653, 109652, 109651, 109058, 109029, 107830, 107673, 107298, 106827, 105308, 103332, 103236, 103126, 102534, 102533, 102532, 102530, 102528, 101931, 101927, 99573, 98075, 97546, 93278, 93026, 90304, 89931, 89283, 87096, 86704, 86398, 86153, 86146, 86119, 85097, 84989, 83912, 83282, 82583, 82558, 80983, 79154, 78873, 78417, 77788, 77781, 77592, 77340, 76240, 75892, 75876, 75652, 74559, 74518, 74081, 73239, 72556, 71109, 70989, 70940, 70613, 69533, 69146, 68823, 68821, 68802, 68691, 68654, 67819, 67657, 67656, 67634, 67391, 67139, 66970, 65689, 65637, 64903, 64888, 64881, 64151, 63641, 63406, 63210, 62928, 62822, 62661, 62638, 62482, 62268, 61990, 61755, 61708, 61700, 61617, 61582, 61574, 61370, 61367, 60784, 60583, 60475, 60371, 60297, 60295, 60278, 59842, 59729, 59551, 58747, 58477, 58389, 58320, 58316, 58315, 58121, 57714, 57358, 57334, 57257, 57255, 57173, 56949, 56887, 56722, 56433, 56432, 56219, 55952, 52721, 52399, 52010, 51987, 51667, 51654, 51643, 51509, 51449, 51266, 51251, 49298))
Run Time: 0.128167
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: 6829, 0, 1716008453, {"thread-141935":["thread",141935],"thread-129025":["thread",129025],"thread-128494":["thread",128494],"thread-128336":["thread",128336],"thread-128312":["thread",128312],"thread-128259":["thread",128259],"thread-127498":["thread",127498],"thread-127126":["thread",127126],"thread-127053":["thread",127053],"thread-123725":["thread",123725],"thread-123646":["thread",123646],"thread-123443":["thread",123443],"thread-123432":["thread",123432],"thread-123313":["thread",123313],"thread-123302":["thread",123302],"thread-123192":["thread",123192],"thread-123187":["thread",123187],"thread-123182":["thread",123182],"thread-123167":["thread",123167],"thread-123130":["thread",123130],"thread-123102":["thread",123102],"thread-122096":["thread",122096],"thread-122064":["thread",122064],"thread-121161":["thread",121161],"thread-120378":["thread",120378],"thread-120365":["thread",120365],"thread-120350":["thread",120350],"thread-120287":["thread",120287],"thread-120109":["thread",120109],"thread-119334":["thread",119334],"thread-119277":["thread",119277],"thread-119189":["thread",119189],"thread-119142":["thread",119142],"thread-119122":["thread",119122],"thread-119120":["thread",119120],"thread-119023":["thread",119023],"thread-119007":["thread",119007],"thread-118876":["thread",118876],"thread-118677":["thread",118677],"thread-118461":["thread",118461],"thread-118126":["thread",118126],"thread-117847":["thread",117847],"thread-114670":["thread",114670],"thread-114557":["thread",114557],"thread-114464":["thread",114464],"thread-112760":["thread",112760],"thread-112415":["thread",112415],"thread-112297":["thread",112297],"thread-112142":["thread",112142],"thread-111934":["thread",111934],"thread-111897":["thread",111897],"thread-111717":["thread",111717],"thread-111640":["thread",111640],"thread-111462":["thread",111462],"thread-111246":["thread",111246],"thread-110502":["thread",110502],"thread-110501":["thread",110501],"thread-110326":["thread",110326],"thread-110284":["thread",110284],"thread-109653":["thread",109653],"thread-109652":["thread",109652],"thread-109651":["thread",109651],"thread-109058":["thread",109058],"thread-109029":["thread",109029],"thread-107830":["thread",107830],"thread-107673":["thread",107673],"thread-107298":["thread",107298],"thread-106827":["thread",106827],"thread-105308":["thread",105308],"thread-103332":["thread",103332],"thread-103236":["thread",103236],"thread-103126":["thread",103126],"thread-102534":["thread",102534],"thread-102533":["thread",102533],"thread-102532":["thread",102532],"thread-102530":["thread",102530],"thread-102528":["thread",102528],"thread-101931":["thread",101931],"thread-101927":["thread",101927],"thread-99573":["thread",99573],"thread-98075":["thread",98075],"thread-97546":["thread",97546],"thread-93278":["thread",93278],"thread-93026":["thread",93026],"thread-90304":["thread",90304],"thread-89931":["thread",89931],"thread-89283":["thread",89283],"thread-87096":["thread",87096],"thread-86704":["thread",86704],"thread-86398":["thread",86398],"thread-86153":["thread",86153],"thread-86146":["thread",86146],"thread-86119":["thread",86119],"thread-85097":["thread",85097],"thread-84989":["thread",84989],"thread-83912":["thread",83912],"thread-83282":["thread",83282],"thread-82583":["thread",82583],"thread-82558":["thread",82558],"thread-80983":["thread",80983],"thread-79154":["thread",79154],"thread-78873":["thread",78873],"thread-78417":["thread",78417],"thread-77788":["thread",77788],"thread-77781":["thread",77781],"thread-77592":["thread",77592],"thread-77340":["thread",77340],"thread-76240":["thread",76240],"thread-75892":["thread",75892],"thread-75876":["thread",75876],"thread-75652":["thread",75652],"thread-74559":["thread",74559],"thread-74518":["thread",74518],"thread-74081":["thread",74081],"thread-73239":["thread",73239],"thread-72556":["thread",72556],"thread-71109":["thread",71109],"thread-70989":["thread",70989],"thread-70940":["thread",70940],"thread-70613":["thread",70613],"thread-69533":["thread",69533],"thread-69146":["thread",69146],"thread-68823":["thread",68823],"thread-68821":["thread",68821],"thread-68802":["thread",68802],"thread-68691":["thread",68691],"thread-68654":["thread",68654],"thread-67819":["thread",67819],"thread-67657":["thread",67657],"thread-67656":["thread",67656],"thread-67634":["thread",67634],"thread-67391":["thread",67391],"thread-67139":["thread",67139],"thread-66970":["thread",66970],"thread-65689":["thread",65689],"thread-65637":["thread",65637],"thread-64903":["thread",64903],"thread-64888":["thread",64888],"thread-64881":["thread",64881],"thread-64151":["thread",64151],"thread-63641":["thread",63641],"thread-63406":["thread",63406],"thread-63210":["thread",63210],"thread-62928":["thread",62928],"thread-62822":["thread",62822],"thread-62661":["thread",62661],"thread-62638":["thread",62638],"thread-62482":["thread",62482],"thread-62268":["thread",62268],"thread-61990":["thread",61990],"thread-61755":["thread",61755],"thread-61708":["thread",61708],"thread-61700":["thread",61700],"thread-61617":["thread",61617],"thread-61582":["thread",61582],"thread-61574":["thread",61574],"thread-61370":["thread",61370],"thread-61367":["thread",61367],"thread-60784":["thread",60784],"thread-60583":["thread",60583],"thread-60475":["thread",60475],"thread-60371":["thread",60371],"thread-60297":["thread",60297],"thread-60295":["thread",60295],"thread-60278":["thread",60278],"thread-59842":["thread",59842],"thread-59729":["thread",59729],"thread-59551":["thread",59551],"thread-58747":["thread",58747],"thread-58477":["thread",58477],"thread-58389":["thread",58389],"thread-58320":["thread",58320],"thread-58316":["thread",58316],"thread-58315":["thread",58315],"thread-58121":["thread",58121],"thread-57714":["thread",57714],"thread-57358":["thread",57358],"thread-57334":["thread",57334],"thread-57257":["thread",57257],"thread-57255":["thread",57255],"thread-57173":["thread",57173],"thread-56949":["thread",56949],"thread-56887":["thread",56887],"thread-56722":["thread",56722],"thread-56433":["thread",56433],"thread-56432":["thread",56432],"thread-56219":["thread",56219],"thread-55952":["thread",55952],"thread-52721":["thread",52721],"thread-52399":["thread",52399],"thread-52010":["thread",52010],"thread-51987":["thread",51987],"thread-51667":["thread",51667],"thread-51654":["thread",51654],"thread-51643":["thread",51643],"thread-51509":["thread",51509],"thread-51449":["thread",51449],"thread-51266":["thread",51266],"thread-51251":["thread",51251],"thread-49298":["thread",49298]}, , 1716004853
Run Time: 0.001295
- 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