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 (183828, 183721, 183060, 182971, 182754, 182065, 182061, 180737, 180216, 180044, 179990, 178772, 178598, 177344, 176950, 175749, 175531, 174252, 173092, 173005, 172340, 172304, 171938, 170123, 169903, 169509, 169274, 168748, 168475, 166531, 164932, 163657, 163249, 163096, 163002, 162926, 162617, 160450, 160055, 159948, 159858, 159669, 159435, 157231, 156804, 156405, 155003, 154705, 151711, 151400, 146769, 143468, 141162, 137750, 132581, 132024, 128699, 128664, 127890, 127739, 127536, 126743, 126453, 124055, 123991, 123013, 122617, 118558, 110491, 109786, 105232, 102583, 99901, 98595, 97218, 96618, 96056, 96022, 95937, 95643, 95548, 95207, 94861, 94859, 94741, 94669, 94663, 93378, 92486, 90265, 90116, 88029, 88022, 87965, 87742, 86981, 84957, 84538, 82095, 81833, 81823, 81822, 81753, 81740, 80978, 80516, 79372, 77944, 77529, 77528, 76987, 73940, 73561, 73166, 71724, 71430, 71162, 71094, 70509, 70502, 70487, 70382, 69009, 68332, 68130, 66637, 65652, 65048, 64737, 64385, 64356, 63109, 62931, 61749, 61613, 58301, 56286, 54350, 52651, 52213, 46466, 43202, 41498, 41165, 40220, 40054, 39979, 39978, 39972, 39971, 39732, 39731, 39563, 39468, 35847, 35776, 35758, 35746, 35327, 34956, 33837, 32334, 28350, 28234, 27304, 27166, 27134, 17433, 2083))
Run Time: 0.077410
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 169 | 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: 575, 0, 1717063109, {"thread-183828":["thread",183828],"thread-183721":["thread",183721],"thread-183060":["thread",183060],"thread-182971":["thread",182971],"thread-182754":["thread",182754],"thread-182065":["thread",182065],"thread-182061":["thread",182061],"thread-180737":["thread",180737],"thread-180216":["thread",180216],"thread-180044":["thread",180044],"thread-179990":["thread",179990],"thread-178772":["thread",178772],"thread-178598":["thread",178598],"thread-177344":["thread",177344],"thread-176950":["thread",176950],"thread-175749":["thread",175749],"thread-175531":["thread",175531],"thread-174252":["thread",174252],"thread-173092":["thread",173092],"thread-173005":["thread",173005],"thread-172340":["thread",172340],"thread-172304":["thread",172304],"thread-171938":["thread",171938],"thread-170123":["thread",170123],"thread-169903":["thread",169903],"thread-169509":["thread",169509],"thread-169274":["thread",169274],"thread-168748":["thread",168748],"thread-168475":["thread",168475],"thread-166531":["thread",166531],"thread-164932":["thread",164932],"thread-163657":["thread",163657],"thread-163249":["thread",163249],"thread-163096":["thread",163096],"thread-163002":["thread",163002],"thread-162926":["thread",162926],"thread-162617":["thread",162617],"thread-160450":["thread",160450],"thread-160055":["thread",160055],"thread-159948":["thread",159948],"thread-159858":["thread",159858],"thread-159669":["thread",159669],"thread-159435":["thread",159435],"thread-157231":["thread",157231],"thread-156804":["thread",156804],"thread-156405":["thread",156405],"thread-155003":["thread",155003],"thread-154705":["thread",154705],"thread-151711":["thread",151711],"thread-151400":["thread",151400],"thread-146769":["thread",146769],"thread-143468":["thread",143468],"thread-141162":["thread",141162],"thread-137750":["thread",137750],"thread-132581":["thread",132581],"thread-132024":["thread",132024],"thread-128699":["thread",128699],"thread-128664":["thread",128664],"thread-127890":["thread",127890],"thread-127739":["thread",127739],"thread-127536":["thread",127536],"thread-126743":["thread",126743],"thread-126453":["thread",126453],"thread-124055":["thread",124055],"thread-123991":["thread",123991],"thread-123013":["thread",123013],"thread-122617":["thread",122617],"thread-118558":["thread",118558],"thread-110491":["thread",110491],"thread-109786":["thread",109786],"thread-105232":["thread",105232],"thread-102583":["thread",102583],"thread-99901":["thread",99901],"thread-98595":["thread",98595],"thread-97218":["thread",97218],"thread-96618":["thread",96618],"thread-96056":["thread",96056],"thread-96022":["thread",96022],"thread-95937":["thread",95937],"thread-95643":["thread",95643],"thread-95548":["thread",95548],"thread-95207":["thread",95207],"thread-94861":["thread",94861],"thread-94859":["thread",94859],"thread-94741":["thread",94741],"thread-94669":["thread",94669],"thread-94663":["thread",94663],"thread-93378":["thread",93378],"thread-92486":["thread",92486],"thread-90265":["thread",90265],"thread-90116":["thread",90116],"thread-88029":["thread",88029],"thread-88022":["thread",88022],"thread-87965":["thread",87965],"thread-87742":["thread",87742],"thread-86981":["thread",86981],"thread-84957":["thread",84957],"thread-84538":["thread",84538],"thread-82095":["thread",82095],"thread-81833":["thread",81833],"thread-81823":["thread",81823],"thread-81822":["thread",81822],"thread-81753":["thread",81753],"thread-81740":["thread",81740],"thread-80978":["thread",80978],"thread-80516":["thread",80516],"thread-79372":["thread",79372],"thread-77944":["thread",77944],"thread-77529":["thread",77529],"thread-77528":["thread",77528],"thread-76987":["thread",76987],"thread-73940":["thread",73940],"thread-73561":["thread",73561],"thread-73166":["thread",73166],"thread-71724":["thread",71724],"thread-71430":["thread",71430],"thread-71162":["thread",71162],"thread-71094":["thread",71094],"thread-70509":["thread",70509],"thread-70502":["thread",70502],"thread-70487":["thread",70487],"thread-70382":["thread",70382],"thread-69009":["thread",69009],"thread-68332":["thread",68332],"thread-68130":["thread",68130],"thread-66637":["thread",66637],"thread-65652":["thread",65652],"thread-65048":["thread",65048],"thread-64737":["thread",64737],"thread-64385":["thread",64385],"thread-64356":["thread",64356],"thread-63109":["thread",63109],"thread-62931":["thread",62931],"thread-61749":["thread",61749],"thread-61613":["thread",61613],"thread-58301":["thread",58301],"thread-56286":["thread",56286],"thread-54350":["thread",54350],"thread-52651":["thread",52651],"thread-52213":["thread",52213],"thread-46466":["thread",46466],"thread-43202":["thread",43202],"thread-41498":["thread",41498],"thread-41165":["thread",41165],"thread-40220":["thread",40220],"thread-40054":["thread",40054],"thread-39979":["thread",39979],"thread-39978":["thread",39978],"thread-39972":["thread",39972],"thread-39971":["thread",39971],"thread-39732":["thread",39732],"thread-39731":["thread",39731],"thread-39563":["thread",39563],"thread-39468":["thread",39468],"thread-35847":["thread",35847],"thread-35776":["thread",35776],"thread-35758":["thread",35758],"thread-35746":["thread",35746],"thread-35327":["thread",35327],"thread-34956":["thread",34956],"thread-33837":["thread",33837],"thread-32334":["thread",32334],"thread-28350":["thread",28350],"thread-28234":["thread",28234],"thread-27304":["thread",27304],"thread-27166":["thread",27166],"thread-27134":["thread",27134],"thread-17433":["thread",17433],"thread-2083":["thread",2083]}, , 1717059509
Run Time: 0.000548
- 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