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 (181647, 181496, 181427, 178714, 178712, 172550, 171884, 168187, 167555, 167414, 166515, 166514, 166090, 164119, 160934, 160444, 160255, 160163, 159823, 158073, 157924, 157856, 155048, 143460, 134169, 132182, 131574, 131543, 131295, 130794, 130648, 130619, 130594, 130502, 130254, 130237, 129836, 129820, 129054, 128857, 128832, 128381, 128235, 128229, 128019, 126962, 126871, 126015, 125609, 124839, 124432, 124431, 123677, 123640, 123220, 123170, 123155, 123154, 122754, 122710, 122623, 122336, 122319, 122173, 122149, 121704, 121696, 121483, 120458, 119481, 119004, 118479, 118424, 117638, 117522, 117369, 117139, 117094, 116999, 116998, 116837, 116836, 116835, 116834, 116503, 116423, 116369, 116364, 116082, 115810, 115801, 115687, 115388, 115354, 115353, 114995, 113563, 113216, 112732, 111552, 111371, 110456, 110330, 109846, 109712, 109218, 107533, 106522, 106339, 105418, 105241, 105003, 103023, 102989, 102977, 102835, 102763, 102563, 102508, 101572, 101471, 101297, 101257, 101120, 101119, 101089, 101076, 101075, 100305, 100158, 99931, 99907, 99886, 99864, 99838, 99713, 99658, 99298, 99295, 99251, 98865, 98716, 98294, 97867, 97558, 96852, 96783, 96727, 96699, 96324, 96202, 96157, 95731, 95729, 95517, 95471, 95470, 95403, 95397, 95246, 95244, 95219, 95165, 95163, 95160, 95158, 94868, 94670, 94517, 94516, 94189, 94135, 94086, 93742, 93291, 92956, 92661, 92185, 91899, 91890, 91888, 91649, 91646, 91194, 91188, 91141, 91140, 91139, 91137, 90420, 90246, 89746, 89552, 89488, 89438, 89168, 89124, 89100, 89062, 89060))
Run Time: 0.101718
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: 123, 0, 1714235791, {"thread-178712":["thread",178712],"thread-172550":["thread",172550],"thread-171884":["thread",171884],"thread-167555":["thread",167555],"thread-167414":["thread",167414],"thread-166515":["thread",166515],"thread-166514":["thread",166514],"thread-166090":["thread",166090],"thread-164119":["thread",164119],"thread-160934":["thread",160934],"thread-160444":["thread",160444],"thread-160163":["thread",160163],"thread-159823":["thread",159823],"thread-158073":["thread",158073],"thread-157856":["thread",157856],"thread-155048":["thread",155048],"thread-143460":["thread",143460],"thread-134169":["thread",134169],"thread-132182":["thread",132182],"thread-131574":["thread",131574],"thread-131543":["thread",131543],"thread-131295":["thread",131295],"thread-130794":["thread",130794],"thread-130648":["thread",130648],"thread-130619":["thread",130619],"thread-130594":["thread",130594],"thread-130502":["thread",130502],"thread-130237":["thread",130237],"thread-129836":["thread",129836],"thread-129820":["thread",129820],"thread-129054":["thread",129054],"thread-128832":["thread",128832],"thread-128381":["thread",128381],"thread-128235":["thread",128235],"thread-128229":["thread",128229],"thread-128019":["thread",128019],"thread-126962":["thread",126962],"thread-126871":["thread",126871],"thread-126015":["thread",126015],"thread-125609":["thread",125609],"thread-124839":["thread",124839],"thread-124432":["thread",124432],"thread-124431":["thread",124431],"thread-123677":["thread",123677],"thread-123640":["thread",123640],"thread-123220":["thread",123220],"thread-123170":["thread",123170],"thread-123154":["thread",123154],"thread-122710":["thread",122710],"thread-122623":["thread",122623],"thread-122336":["thread",122336],"thread-122319":["thread",122319],"thread-122173":["thread",122173],"thread-122149":["thread",122149],"thread-121704":["thread",121704],"thread-121696":["thread",121696],"thread-121483":["thread",121483],"thread-120458":["thread",120458],"thread-119481":["thread",119481],"thread-119004":["thread",119004],"thread-118479":["thread",118479],"thread-118424":["thread",118424],"thread-117522":["thread",117522],"thread-117369":["thread",117369],"thread-117139":["thread",117139],"thread-117094":["thread",117094],"thread-116364":["thread",116364],"thread-116082":["thread",116082],"thread-115810":["thread",115810],"thread-115801":["thread",115801],"thread-115687":["thread",115687],"thread-115388":["thread",115388],"thread-115354":["thread",115354],"thread-115353":["thread",115353],"thread-114995":["thread",114995],"thread-113216":["thread",113216],"thread-111552":["thread",111552],"thread-111371":["thread",111371],"thread-110456":["thread",110456],"thread-110330":["thread",110330],"thread-109846":["thread",109846],"thread-106522":["thread",106522],"thread-106339":["thread",106339],"thread-105418":["thread",105418],"thread-105241":["thread",105241],"thread-105003":["thread",105003],"thread-103023":["thread",103023],"thread-102989":["thread",102989],"thread-102977":["thread",102977],"thread-102835":["thread",102835],"thread-102763":["thread",102763],"thread-102563":["thread",102563],"thread-102508":["thread",102508],"thread-101572":["thread",101572],"thread-101471":["thread",101471],"thread-101297":["thread",101297],"thread-101257":["thread",101257],"thread-101120":["thread",101120],"thread-101119":["thread",101119],"thread-101089":["thread",101089],"thread-100305":["thread",100305],"thread-100158":["thread",100158],"thread-99931":["thread",99931],"thread-99907":["thread",99907],"thread-99886":["thread",99886],"thread-99864":["thread",99864],"thread-99838":["thread",99838],"thread-99713":["thread",99713],"thread-99658":["thread",99658],"thread-99298":["thread",99298],"thread-99295":["thread",99295],"thread-98865":["thread",98865],"thread-98716":["thread",98716],"thread-98294":["thread",98294],"thread-97867":["thread",97867],"thread-97558":["thread",97558],"thread-96852":["thread",96852],"thread-96783":["thread",96783],"thread-96727":["thread",96727],"thread-96699":["thread",96699],"thread-96324":["thread",96324],"thread-96202":["thread",96202],"thread-95731":["thread",95731],"thread-95729":["thread",95729],"thread-95517":["thread",95517],"thread-95471":["thread",95471],"thread-95470":["thread",95470],"thread-95397":["thread",95397],"thread-95246":["thread",95246],"thread-95244":["thread",95244],"thread-95165":["thread",95165],"thread-95163":["thread",95163],"thread-95160":["thread",95160],"thread-95158":["thread",95158],"thread-94868":["thread",94868],"thread-94670":["thread",94670],"thread-94517":["thread",94517],"thread-94516":["thread",94516],"thread-94189":["thread",94189],"thread-94135":["thread",94135],"thread-94086":["thread",94086],"thread-93742":["thread",93742],"thread-93291":["thread",93291],"thread-92956":["thread",92956],"thread-92661":["thread",92661],"thread-92185":["thread",92185],"thread-91899":["thread",91899],"thread-91890":["thread",91890],"thread-91649":["thread",91649],"thread-91194":["thread",91194],"thread-91188":["thread",91188],"thread-91141":["thread",91141],"thread-91140":["thread",91140],"thread-91139":["thread",91139],"thread-90246":["thread",90246],"thread-89746":["thread",89746],"thread-89552":["thread",89552],"thread-89488":["thread",89488],"thread-89438":["thread",89438],"thread-89168":["thread",89168],"thread-89124":["thread",89124],"thread-89100":["thread",89100],"thread-89062":["thread",89062]}, , 1714232191
Run Time: 0.001481
- 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