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 (141253, 131944, 131484, 131222, 131210, 131182, 130830, 130828, 130331, 130044, 129828, 129543, 129532, 129234, 128984, 128963, 128951, 128780, 128488, 128360, 128044, 127985, 127875, 127873, 127479, 127305, 126877, 126835, 126693, 126692, 126686, 126679, 126675, 126626, 126624, 126555, 126506, 126502, 126499, 126296, 126221, 126210, 126157, 126148, 126077, 125952, 125864, 125794, 125792, 125790, 125472, 125396, 125212, 124937, 124908, 124789, 124750, 124715, 124702, 124563, 124535, 124531, 124505, 124497, 124495, 124472, 124455, 124429, 124391, 124380, 124217, 124158, 123757, 123752, 123709, 123488, 123430, 123410, 123409, 123401, 123337, 123278, 123177, 123170, 122959, 122888, 122757, 122739, 122732, 122504, 122401, 122325, 122263, 121691, 121479, 121343, 121195, 121105, 120976, 120826, 120562, 120414, 119694, 119594, 119544, 119369, 119307, 119258, 119118, 119050, 119001, 118865, 118832, 118242, 118113, 118041, 117850, 117813, 117696, 117395, 116326, 116320, 116071, 116061, 116022, 115976, 115971, 115964, 115877, 115876, 115766, 115763, 115761, 115743, 115728, 115685, 115676, 115567, 114961, 114869, 114725, 114724, 114713, 114702, 114634, 114604, 114501, 114500, 114405, 114403, 114399, 114398, 114304, 114237, 114221, 114174, 113885, 113851, 113665, 113620, 113300, 113140, 112565, 112494, 112322, 112321, 111996, 111867, 111561, 110842, 110803, 110762, 110738, 110714, 110651, 110561, 110409, 110310, 110171, 109713, 109707, 109385, 109183, 109006, 108942, 108930, 108015, 107279, 106758, 106757, 106423, 106114, 105932, 105899, 105763, 105584, 105450, 105228, 105221, 105001))
Run Time: 0.111217
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: 19138, 0, 1715836541, {"thread-141253":["thread",141253],"thread-131944":["thread",131944],"thread-131484":["thread",131484],"thread-131222":["thread",131222],"thread-131210":["thread",131210],"thread-131182":["thread",131182],"thread-130830":["thread",130830],"thread-130828":["thread",130828],"thread-130331":["thread",130331],"thread-130044":["thread",130044],"thread-129828":["thread",129828],"thread-129543":["thread",129543],"thread-129532":["thread",129532],"thread-129234":["thread",129234],"thread-128984":["thread",128984],"thread-128963":["thread",128963],"thread-128951":["thread",128951],"thread-128780":["thread",128780],"thread-128488":["thread",128488],"thread-128360":["thread",128360],"thread-128044":["thread",128044],"thread-127985":["thread",127985],"thread-127875":["thread",127875],"thread-127873":["thread",127873],"thread-127479":["thread",127479],"thread-127305":["thread",127305],"thread-126877":["thread",126877],"thread-126835":["thread",126835],"thread-126693":["thread",126693],"thread-126692":["thread",126692],"thread-126686":["thread",126686],"thread-126679":["thread",126679],"thread-126675":["thread",126675],"thread-126626":["thread",126626],"thread-126624":["thread",126624],"thread-126555":["thread",126555],"thread-126506":["thread",126506],"thread-126502":["thread",126502],"thread-126499":["thread",126499],"thread-126296":["thread",126296],"thread-126221":["thread",126221],"thread-126210":["thread",126210],"thread-126157":["thread",126157],"thread-126148":["thread",126148],"thread-126077":["thread",126077],"thread-125952":["thread",125952],"thread-125864":["thread",125864],"thread-125794":["thread",125794],"thread-125792":["thread",125792],"thread-125790":["thread",125790],"thread-125472":["thread",125472],"thread-125396":["thread",125396],"thread-125212":["thread",125212],"thread-124937":["thread",124937],"thread-124908":["thread",124908],"thread-124789":["thread",124789],"thread-124750":["thread",124750],"thread-124715":["thread",124715],"thread-124702":["thread",124702],"thread-124563":["thread",124563],"thread-124535":["thread",124535],"thread-124531":["thread",124531],"thread-124505":["thread",124505],"thread-124497":["thread",124497],"thread-124495":["thread",124495],"thread-124472":["thread",124472],"thread-124455":["thread",124455],"thread-124429":["thread",124429],"thread-124391":["thread",124391],"thread-124380":["thread",124380],"thread-124217":["thread",124217],"thread-124158":["thread",124158],"thread-123757":["thread",123757],"thread-123752":["thread",123752],"thread-123709":["thread",123709],"thread-123488":["thread",123488],"thread-123430":["thread",123430],"thread-123410":["thread",123410],"thread-123409":["thread",123409],"thread-123401":["thread",123401],"thread-123337":["thread",123337],"thread-123278":["thread",123278],"thread-123177":["thread",123177],"thread-123170":["thread",123170],"thread-122959":["thread",122959],"thread-122888":["thread",122888],"thread-122757":["thread",122757],"thread-122739":["thread",122739],"thread-122732":["thread",122732],"thread-122504":["thread",122504],"thread-122401":["thread",122401],"thread-122325":["thread",122325],"thread-122263":["thread",122263],"thread-121691":["thread",121691],"thread-121479":["thread",121479],"thread-121343":["thread",121343],"thread-121195":["thread",121195],"thread-121105":["thread",121105],"thread-120976":["thread",120976],"thread-120826":["thread",120826],"thread-120562":["thread",120562],"thread-120414":["thread",120414],"thread-119694":["thread",119694],"thread-119594":["thread",119594],"thread-119544":["thread",119544],"thread-119369":["thread",119369],"thread-119307":["thread",119307],"thread-119258":["thread",119258],"thread-119118":["thread",119118],"thread-119050":["thread",119050],"thread-119001":["thread",119001],"thread-118865":["thread",118865],"thread-118832":["thread",118832],"thread-118242":["thread",118242],"thread-118113":["thread",118113],"thread-118041":["thread",118041],"thread-117850":["thread",117850],"thread-117813":["thread",117813],"thread-117696":["thread",117696],"thread-117395":["thread",117395],"thread-116326":["thread",116326],"thread-116320":["thread",116320],"thread-116071":["thread",116071],"thread-116061":["thread",116061],"thread-116022":["thread",116022],"thread-115976":["thread",115976],"thread-115971":["thread",115971],"thread-115964":["thread",115964],"thread-115877":["thread",115877],"thread-115876":["thread",115876],"thread-115766":["thread",115766],"thread-115763":["thread",115763],"thread-115761":["thread",115761],"thread-115743":["thread",115743],"thread-115728":["thread",115728],"thread-115685":["thread",115685],"thread-115676":["thread",115676],"thread-115567":["thread",115567],"thread-114961":["thread",114961],"thread-114869":["thread",114869],"thread-114725":["thread",114725],"thread-114724":["thread",114724],"thread-114713":["thread",114713],"thread-114702":["thread",114702],"thread-114634":["thread",114634],"thread-114604":["thread",114604],"thread-114501":["thread",114501],"thread-114500":["thread",114500],"thread-114405":["thread",114405],"thread-114403":["thread",114403],"thread-114399":["thread",114399],"thread-114398":["thread",114398],"thread-114304":["thread",114304],"thread-114237":["thread",114237],"thread-114221":["thread",114221],"thread-114174":["thread",114174],"thread-113885":["thread",113885],"thread-113851":["thread",113851],"thread-113665":["thread",113665],"thread-113620":["thread",113620],"thread-113300":["thread",113300],"thread-113140":["thread",113140],"thread-112565":["thread",112565],"thread-112494":["thread",112494],"thread-112322":["thread",112322],"thread-112321":["thread",112321],"thread-111996":["thread",111996],"thread-111867":["thread",111867],"thread-111561":["thread",111561],"thread-110842":["thread",110842],"thread-110803":["thread",110803],"thread-110762":["thread",110762],"thread-110738":["thread",110738],"thread-110714":["thread",110714],"thread-110651":["thread",110651],"thread-110561":["thread",110561],"thread-110409":["thread",110409],"thread-110310":["thread",110310],"thread-110171":["thread",110171],"thread-109713":["thread",109713],"thread-109707":["thread",109707],"thread-109385":["thread",109385],"thread-109183":["thread",109183],"thread-109006":["thread",109006],"thread-108942":["thread",108942],"thread-108930":["thread",108930],"thread-108015":["thread",108015],"thread-107279":["thread",107279],"thread-106758":["thread",106758],"thread-106757":["thread",106757],"thread-106423":["thread",106423],"thread-106114":["thread",106114],"thread-105932":["thread",105932],"thread-105899":["thread",105899],"thread-105763":["thread",105763],"thread-105584":["thread",105584],"thread-105450":["thread",105450],"thread-105228":["thread",105228],"thread-105221":["thread",105221],"thread-105001":["thread",105001]}, , 1715832941
Run Time: 0.000635
- 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