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 (218635, 218581, 218359, 218263, 217945, 217897, 215935, 214513, 214189, 213808, 212653, 211906, 211873, 211142, 211030, 210745, 210205, 206755, 201769, 201256, 200995, 200407, 200281, 199984, 199573, 199564, 199501, 199126, 198886, 197398, 195031, 194683, 194134, 193411, 192490, 191317, 190993, 190957, 187138, 186511, 185659, 183868, 182578, 182347, 181885, 181705, 180445, 178108, 176761, 175270, 175195, 174560, 173092, 171942, 171485, 171101, 168828, 168384, 168363, 167877, 165339, 164941, 163285, 162901, 162646, 158938, 158638, 157084, 156685, 156367, 155527, 154582, 153343, 145496, 144583, 142109, 141821, 135330, 135026, 134345, 133817, 131393, 128593, 127584, 125756, 125664, 125651, 125374, 125258, 124675, 124642, 124574, 124412, 123874, 122692, 121144, 120594, 120489, 118931, 118902, 118380, 116952, 116578, 115241, 114837, 113706, 113560, 111785, 111419, 111348, 111068, 110950, 110752, 110401, 110252, 109147, 107973, 107925, 107642, 107577, 107502, 105977, 105660, 104669, 103941, 103884, 103728, 102953, 102880, 102740, 101433, 98217, 98125, 97841, 97507, 97450, 96418, 95395, 94826, 94383, 93249, 93230, 93058, 92766))
Run Time: 0.010024
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 144 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,forum.xf_node_Node_2.node_id | 1 | Using where |
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Mvc/Entity/Finder.php at line 1379
- XF\Mvc\Entity\Finder->fetch() in src/XF/Mvc/Entity/Manager.php at line 212
- XF\Mvc\Entity\Manager->findByIds() in src/XF/App.php at line 2710
- XF\App->findByContentType() in src/XF/Tag/AbstractHandler.php at line 62
- XF\Tag\AbstractHandler->getContent() in src/XF/Repository/Tag.php at line 729
- XF\Repository\Tag->getResultSetData() in src/XF/ResultSet.php at line 228
- XF\ResultSet->loadResultsData() in src/XF/ResultSet.php at line 212
- XF\ResultSet->limitToViewableResults() in src/XF/Pub/Controller/Tag.php at line 136
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- 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: 727, 0, 1714281159, {"thread-218635":["thread",218635],"thread-218581":["thread",218581],"thread-218359":["thread",218359],"thread-218263":["thread",218263],"thread-217945":["thread",217945],"thread-217897":["thread",217897],"thread-215935":["thread",215935],"thread-214513":["thread",214513],"thread-214189":["thread",214189],"thread-213808":["thread",213808],"thread-212653":["thread",212653],"thread-211906":["thread",211906],"thread-211873":["thread",211873],"thread-211142":["thread",211142],"thread-211030":["thread",211030],"thread-210745":["thread",210745],"thread-210205":["thread",210205],"thread-206755":["thread",206755],"thread-201769":["thread",201769],"thread-201256":["thread",201256],"thread-200995":["thread",200995],"thread-200407":["thread",200407],"thread-200281":["thread",200281],"thread-199984":["thread",199984],"thread-199573":["thread",199573],"thread-199564":["thread",199564],"thread-199501":["thread",199501],"thread-199126":["thread",199126],"thread-198886":["thread",198886],"thread-197398":["thread",197398],"thread-195031":["thread",195031],"thread-194683":["thread",194683],"thread-194134":["thread",194134],"thread-193411":["thread",193411],"thread-192490":["thread",192490],"thread-191317":["thread",191317],"thread-190993":["thread",190993],"thread-190957":["thread",190957],"thread-187138":["thread",187138],"thread-186511":["thread",186511],"thread-185659":["thread",185659],"thread-183868":["thread",183868],"thread-182578":["thread",182578],"thread-182347":["thread",182347],"thread-181885":["thread",181885],"thread-181705":["thread",181705],"thread-180445":["thread",180445],"thread-178108":["thread",178108],"thread-176761":["thread",176761],"thread-175270":["thread",175270],"thread-175195":["thread",175195],"thread-174560":["thread",174560],"thread-173092":["thread",173092],"thread-171942":["thread",171942],"thread-171485":["thread",171485],"thread-171101":["thread",171101],"thread-168828":["thread",168828],"thread-168384":["thread",168384],"thread-168363":["thread",168363],"thread-167877":["thread",167877],"thread-165339":["thread",165339],"thread-164941":["thread",164941],"thread-163285":["thread",163285],"thread-162901":["thread",162901],"thread-162646":["thread",162646],"thread-158938":["thread",158938],"thread-158638":["thread",158638],"thread-157084":["thread",157084],"thread-156685":["thread",156685],"thread-156367":["thread",156367],"thread-155527":["thread",155527],"thread-154582":["thread",154582],"thread-153343":["thread",153343],"thread-145496":["thread",145496],"thread-144583":["thread",144583],"thread-142109":["thread",142109],"thread-141821":["thread",141821],"thread-135330":["thread",135330],"thread-135026":["thread",135026],"thread-134345":["thread",134345],"thread-133817":["thread",133817],"thread-131393":["thread",131393],"thread-128593":["thread",128593],"thread-127584":["thread",127584],"thread-125756":["thread",125756],"thread-125664":["thread",125664],"thread-125651":["thread",125651],"thread-125374":["thread",125374],"thread-125258":["thread",125258],"thread-124675":["thread",124675],"thread-124642":["thread",124642],"thread-124574":["thread",124574],"thread-124412":["thread",124412],"thread-123874":["thread",123874],"thread-122692":["thread",122692],"thread-121144":["thread",121144],"thread-120594":["thread",120594],"thread-120489":["thread",120489],"thread-118931":["thread",118931],"thread-118902":["thread",118902],"thread-118380":["thread",118380],"thread-116952":["thread",116952],"thread-116578":["thread",116578],"thread-115241":["thread",115241],"thread-114837":["thread",114837],"thread-113706":["thread",113706],"thread-113560":["thread",113560],"thread-111785":["thread",111785],"thread-111419":["thread",111419],"thread-111348":["thread",111348],"thread-111068":["thread",111068],"thread-110950":["thread",110950],"thread-110752":["thread",110752],"thread-110401":["thread",110401],"thread-110252":["thread",110252],"thread-109147":["thread",109147],"thread-107973":["thread",107973],"thread-107925":["thread",107925],"thread-107642":["thread",107642],"thread-107577":["thread",107577],"thread-107502":["thread",107502],"thread-105977":["thread",105977],"thread-105660":["thread",105660],"thread-104669":["thread",104669],"thread-103941":["thread",103941],"thread-103884":["thread",103884],"thread-103728":["thread",103728],"thread-102953":["thread",102953],"thread-102880":["thread",102880],"thread-102740":["thread",102740],"thread-101433":["thread",101433],"thread-98217":["thread",98217],"thread-98125":["thread",98125],"thread-97841":["thread",97841],"thread-97507":["thread",97507],"thread-97450":["thread",97450],"thread-96418":["thread",96418],"thread-95395":["thread",95395],"thread-94826":["thread",94826],"thread-94383":["thread",94383],"thread-93249":["thread",93249],"thread-93230":["thread",93230],"thread-93058":["thread",93058],"thread-92766":["thread",92766]}, , 1714277559
Run Time: 0.000453
- XF\Db\Mysqli\Statement->execute() in src/XF/Db/AbstractAdapter.php at line 94
- XF\Db\AbstractAdapter->query() in src/XF/Db/AbstractAdapter.php at line 218
- XF\Db\AbstractAdapter->insert() in src/XF/Mvc/Entity/Entity.php at line 1510
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1242
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 149
- XF\Pub\Controller\Tag->actionTag() in src/XF/Mvc/Dispatcher.php at line 350
- XF\Mvc\Dispatcher->dispatchClass() in src/XF/Mvc/Dispatcher.php at line 257
- XF\Mvc\Dispatcher->dispatchFromMatch() in src/XF/Mvc/Dispatcher.php at line 113
- XF\Mvc\Dispatcher->dispatchLoop() in src/XF/Mvc/Dispatcher.php at line 55
- XF\Mvc\Dispatcher->run() in src/XF/App.php at line 2337
- XF\App->run() in src/XF.php at line 488
- XF::runApp() in index.php at line 20