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 (132079, 132075, 132026, 131915, 131850, 131821, 131548, 131535, 131196, 131171, 131119, 131101, 130931, 130821, 130802, 130712, 130674, 130638, 130621, 130620, 130606, 130589, 130565, 130532, 130453, 130428, 130401, 130341, 130246, 130219, 130138, 130135, 130103, 130102, 130065, 130060, 130003, 129900, 129885, 129882, 129867, 129866, 129741, 129723, 129620, 129523, 129419, 129403, 129397, 129373, 129367, 129366, 129365, 129359, 129319, 129318, 129317, 129226, 129210, 129196, 129097, 129074, 129009, 129006, 128985, 128919, 128908, 128887, 128864, 128858, 128836, 128822, 128809, 128805, 128745, 128743, 128725, 128679, 128570, 128539, 128422, 128419, 128173, 128141, 128043, 128041, 128001, 127971, 127935, 127930, 127881, 127864, 127729, 127715, 127698, 127640, 127575, 127564, 127549, 127436, 127409, 127399, 127398, 127331, 127318, 127317, 127303, 127266, 127245, 127239, 127229, 127202, 127167, 127083, 127069, 127051, 127013, 126982, 126901, 126798, 126779, 126777, 126690, 126634, 126599, 126585, 126580, 126500, 126485, 126474, 126473, 126471, 126442, 126424, 126353, 126234, 126194, 126167, 126066, 126063, 125994, 125959, 125946, 125815, 125767, 125700, 125646, 125614, 125545, 125445, 125362, 125306, 125246, 125152, 125131, 125062, 125027, 124935, 124925, 124873, 124759, 124685, 124628, 124520, 124391, 124100, 124091, 124062, 124041, 123871, 123864, 123788, 123714, 123686, 123685, 123684, 123683, 123682, 123681, 123621, 123581, 123564, 123235, 123233, 123230, 123158, 123056, 123054, 123046, 123038, 122998, 122994, 122967, 122965, 122964, 122963, 122962, 122961, 122859, 122846))
Run Time: 0.139097
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: 3641, 0, 1714635331, {"thread-132079":["thread",132079],"thread-132075":["thread",132075],"thread-132026":["thread",132026],"thread-131915":["thread",131915],"thread-131850":["thread",131850],"thread-131821":["thread",131821],"thread-131548":["thread",131548],"thread-131535":["thread",131535],"thread-131196":["thread",131196],"thread-131171":["thread",131171],"thread-131119":["thread",131119],"thread-131101":["thread",131101],"thread-130931":["thread",130931],"thread-130821":["thread",130821],"thread-130802":["thread",130802],"thread-130712":["thread",130712],"thread-130674":["thread",130674],"thread-130638":["thread",130638],"thread-130621":["thread",130621],"thread-130620":["thread",130620],"thread-130606":["thread",130606],"thread-130589":["thread",130589],"thread-130565":["thread",130565],"thread-130532":["thread",130532],"thread-130453":["thread",130453],"thread-130428":["thread",130428],"thread-130401":["thread",130401],"thread-130341":["thread",130341],"thread-130246":["thread",130246],"thread-130219":["thread",130219],"thread-130138":["thread",130138],"thread-130135":["thread",130135],"thread-130103":["thread",130103],"thread-130102":["thread",130102],"thread-130065":["thread",130065],"thread-130060":["thread",130060],"thread-130003":["thread",130003],"thread-129900":["thread",129900],"thread-129885":["thread",129885],"thread-129882":["thread",129882],"thread-129867":["thread",129867],"thread-129866":["thread",129866],"thread-129741":["thread",129741],"thread-129723":["thread",129723],"thread-129620":["thread",129620],"thread-129523":["thread",129523],"thread-129419":["thread",129419],"thread-129403":["thread",129403],"thread-129397":["thread",129397],"thread-129373":["thread",129373],"thread-129367":["thread",129367],"thread-129366":["thread",129366],"thread-129365":["thread",129365],"thread-129359":["thread",129359],"thread-129319":["thread",129319],"thread-129318":["thread",129318],"thread-129317":["thread",129317],"thread-129226":["thread",129226],"thread-129210":["thread",129210],"thread-129196":["thread",129196],"thread-129097":["thread",129097],"thread-129074":["thread",129074],"thread-129009":["thread",129009],"thread-129006":["thread",129006],"thread-128985":["thread",128985],"thread-128919":["thread",128919],"thread-128908":["thread",128908],"thread-128887":["thread",128887],"thread-128864":["thread",128864],"thread-128858":["thread",128858],"thread-128836":["thread",128836],"thread-128822":["thread",128822],"thread-128809":["thread",128809],"thread-128805":["thread",128805],"thread-128745":["thread",128745],"thread-128743":["thread",128743],"thread-128725":["thread",128725],"thread-128679":["thread",128679],"thread-128570":["thread",128570],"thread-128539":["thread",128539],"thread-128422":["thread",128422],"thread-128419":["thread",128419],"thread-128173":["thread",128173],"thread-128141":["thread",128141],"thread-128043":["thread",128043],"thread-128041":["thread",128041],"thread-128001":["thread",128001],"thread-127971":["thread",127971],"thread-127935":["thread",127935],"thread-127930":["thread",127930],"thread-127881":["thread",127881],"thread-127864":["thread",127864],"thread-127729":["thread",127729],"thread-127715":["thread",127715],"thread-127698":["thread",127698],"thread-127640":["thread",127640],"thread-127575":["thread",127575],"thread-127564":["thread",127564],"thread-127549":["thread",127549],"thread-127436":["thread",127436],"thread-127409":["thread",127409],"thread-127399":["thread",127399],"thread-127398":["thread",127398],"thread-127331":["thread",127331],"thread-127318":["thread",127318],"thread-127317":["thread",127317],"thread-127303":["thread",127303],"thread-127266":["thread",127266],"thread-127245":["thread",127245],"thread-127239":["thread",127239],"thread-127229":["thread",127229],"thread-127202":["thread",127202],"thread-127167":["thread",127167],"thread-127083":["thread",127083],"thread-127069":["thread",127069],"thread-127051":["thread",127051],"thread-127013":["thread",127013],"thread-126982":["thread",126982],"thread-126901":["thread",126901],"thread-126798":["thread",126798],"thread-126779":["thread",126779],"thread-126777":["thread",126777],"thread-126690":["thread",126690],"thread-126634":["thread",126634],"thread-126599":["thread",126599],"thread-126585":["thread",126585],"thread-126580":["thread",126580],"thread-126500":["thread",126500],"thread-126485":["thread",126485],"thread-126474":["thread",126474],"thread-126473":["thread",126473],"thread-126471":["thread",126471],"thread-126442":["thread",126442],"thread-126424":["thread",126424],"thread-126353":["thread",126353],"thread-126234":["thread",126234],"thread-126194":["thread",126194],"thread-126167":["thread",126167],"thread-126066":["thread",126066],"thread-126063":["thread",126063],"thread-125994":["thread",125994],"thread-125959":["thread",125959],"thread-125946":["thread",125946],"thread-125815":["thread",125815],"thread-125767":["thread",125767],"thread-125700":["thread",125700],"thread-125646":["thread",125646],"thread-125614":["thread",125614],"thread-125545":["thread",125545],"thread-125445":["thread",125445],"thread-125362":["thread",125362],"thread-125306":["thread",125306],"thread-125246":["thread",125246],"thread-125152":["thread",125152],"thread-125131":["thread",125131],"thread-125062":["thread",125062],"thread-125027":["thread",125027],"thread-124935":["thread",124935],"thread-124925":["thread",124925],"thread-124873":["thread",124873],"thread-124759":["thread",124759],"thread-124685":["thread",124685],"thread-124628":["thread",124628],"thread-124520":["thread",124520],"thread-124391":["thread",124391],"thread-124100":["thread",124100],"thread-124091":["thread",124091],"thread-124062":["thread",124062],"thread-124041":["thread",124041],"thread-123871":["thread",123871],"thread-123864":["thread",123864],"thread-123788":["thread",123788],"thread-123714":["thread",123714],"thread-123686":["thread",123686],"thread-123685":["thread",123685],"thread-123684":["thread",123684],"thread-123683":["thread",123683],"thread-123682":["thread",123682],"thread-123681":["thread",123681],"thread-123621":["thread",123621],"thread-123581":["thread",123581],"thread-123564":["thread",123564],"thread-123235":["thread",123235],"thread-123233":["thread",123233],"thread-123230":["thread",123230],"thread-123158":["thread",123158],"thread-123056":["thread",123056],"thread-123054":["thread",123054],"thread-123046":["thread",123046],"thread-123038":["thread",123038],"thread-122998":["thread",122998],"thread-122994":["thread",122994],"thread-122967":["thread",122967],"thread-122965":["thread",122965],"thread-122964":["thread",122964],"thread-122963":["thread",122963],"thread-122962":["thread",122962],"thread-122961":["thread",122961],"thread-122859":["thread",122859],"thread-122846":["thread",122846]}, , 1714631731
Run Time: 0.000824
- 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