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 (147341, 147339, 147327, 147323, 147044, 147035, 147031, 146978, 146938, 146816, 146795, 146599, 146596, 146591, 146586, 146585, 146496, 146493, 146387, 146180, 146173, 146064, 146062, 146059, 145902, 145834, 145833, 145832, 145823, 145813, 145803, 145558, 145536, 145422, 145387, 145383, 145345, 145333, 145313, 145273, 145222, 145170, 145104, 145006, 144896, 144855, 144848, 144792, 144791, 144786, 144689, 144686, 144648, 144600, 144599, 144593, 144592, 144569, 144514, 144505, 144496, 144456, 144454, 144400, 144369, 144216, 144212, 144180, 144129, 144074, 143991, 143986, 143985, 143959, 143902, 143844, 143837, 143835, 143623, 143399, 143362, 143354, 143309, 143305, 143304, 143302, 143234, 143207, 143199, 143164, 143160, 143159, 142766, 142716, 142710, 142649, 142599, 142597, 142593, 142475, 142470, 126149, 142412, 142195, 142081, 141994, 141993, 141992, 141986, 141949, 141939, 141936, 141775, 141772, 141771, 141681, 141624, 141478, 141416, 141397, 141390, 141284, 141283, 141146, 141129, 140972, 140888, 140653, 140638, 140628, 140567, 140451, 140447, 140446, 140278, 140249, 140243, 140188, 140149, 140122, 140097, 139874, 139781, 139754, 139726, 139715, 139655, 139646, 139559, 139543, 139499, 139441, 139436, 139399, 139380, 139362, 139256, 139187, 139180, 139166, 139145, 139129, 139113, 139088, 139081, 139074, 138953, 138947, 138924, 138877, 138793, 138768, 138696, 138695, 138586, 138534, 138277, 138270, 138162, 138150, 138025, 138023, 137791, 137782, 137766, 137672, 137670, 137646, 137617, 137616, 137614, 137502, 137480, 137473, 137471, 137426, 137424, 137406, 137302, 137225))
Run Time: 0.030969
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 | carder_admin_bd.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_forum_Forum_1.node_id | 1 | |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | carder_admin_bd.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,carder_admin_bd.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 1392
- 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 2731
- 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 2353
- XF\App->run() in src/XF.php at line 524
- 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: 5538, 0, 1716232879, {"thread-147341":["thread",147341],"thread-147339":["thread",147339],"thread-147327":["thread",147327],"thread-147323":["thread",147323],"thread-147044":["thread",147044],"thread-147035":["thread",147035],"thread-147031":["thread",147031],"thread-146978":["thread",146978],"thread-146938":["thread",146938],"thread-146816":["thread",146816],"thread-146795":["thread",146795],"thread-146599":["thread",146599],"thread-146596":["thread",146596],"thread-146591":["thread",146591],"thread-146586":["thread",146586],"thread-146585":["thread",146585],"thread-146496":["thread",146496],"thread-146493":["thread",146493],"thread-146387":["thread",146387],"thread-146180":["thread",146180],"thread-146173":["thread",146173],"thread-146064":["thread",146064],"thread-146062":["thread",146062],"thread-146059":["thread",146059],"thread-145902":["thread",145902],"thread-145834":["thread",145834],"thread-145833":["thread",145833],"thread-145832":["thread",145832],"thread-145823":["thread",145823],"thread-145813":["thread",145813],"thread-145803":["thread",145803],"thread-145558":["thread",145558],"thread-145536":["thread",145536],"thread-145422":["thread",145422],"thread-145387":["thread",145387],"thread-145383":["thread",145383],"thread-145345":["thread",145345],"thread-145333":["thread",145333],"thread-145313":["thread",145313],"thread-145273":["thread",145273],"thread-145222":["thread",145222],"thread-145170":["thread",145170],"thread-145104":["thread",145104],"thread-145006":["thread",145006],"thread-144896":["thread",144896],"thread-144855":["thread",144855],"thread-144848":["thread",144848],"thread-144792":["thread",144792],"thread-144791":["thread",144791],"thread-144786":["thread",144786],"thread-144689":["thread",144689],"thread-144686":["thread",144686],"thread-144648":["thread",144648],"thread-144600":["thread",144600],"thread-144599":["thread",144599],"thread-144593":["thread",144593],"thread-144592":["thread",144592],"thread-144569":["thread",144569],"thread-144514":["thread",144514],"thread-144505":["thread",144505],"thread-144496":["thread",144496],"thread-144456":["thread",144456],"thread-144454":["thread",144454],"thread-144400":["thread",144400],"thread-144369":["thread",144369],"thread-144216":["thread",144216],"thread-144212":["thread",144212],"thread-144180":["thread",144180],"thread-144129":["thread",144129],"thread-144074":["thread",144074],"thread-143991":["thread",143991],"thread-143986":["thread",143986],"thread-143985":["thread",143985],"thread-143959":["thread",143959],"thread-143902":["thread",143902],"thread-143844":["thread",143844],"thread-143837":["thread",143837],"thread-143835":["thread",143835],"thread-143623":["thread",143623],"thread-143399":["thread",143399],"thread-143362":["thread",143362],"thread-143354":["thread",143354],"thread-143309":["thread",143309],"thread-143305":["thread",143305],"thread-143304":["thread",143304],"thread-143302":["thread",143302],"thread-143234":["thread",143234],"thread-143207":["thread",143207],"thread-143199":["thread",143199],"thread-143164":["thread",143164],"thread-143160":["thread",143160],"thread-143159":["thread",143159],"thread-142766":["thread",142766],"thread-142716":["thread",142716],"thread-142710":["thread",142710],"thread-142649":["thread",142649],"thread-142599":["thread",142599],"thread-142597":["thread",142597],"thread-142593":["thread",142593],"thread-142475":["thread",142475],"thread-142470":["thread",142470],"thread-126149":["thread",126149],"thread-142412":["thread",142412],"thread-142195":["thread",142195],"thread-142081":["thread",142081],"thread-141994":["thread",141994],"thread-141993":["thread",141993],"thread-141992":["thread",141992],"thread-141986":["thread",141986],"thread-141949":["thread",141949],"thread-141939":["thread",141939],"thread-141936":["thread",141936],"thread-141775":["thread",141775],"thread-141772":["thread",141772],"thread-141771":["thread",141771],"thread-141681":["thread",141681],"thread-141624":["thread",141624],"thread-141478":["thread",141478],"thread-141416":["thread",141416],"thread-141397":["thread",141397],"thread-141390":["thread",141390],"thread-141284":["thread",141284],"thread-141283":["thread",141283],"thread-141146":["thread",141146],"thread-141129":["thread",141129],"thread-140972":["thread",140972],"thread-140888":["thread",140888],"thread-140653":["thread",140653],"thread-140638":["thread",140638],"thread-140628":["thread",140628],"thread-140567":["thread",140567],"thread-140451":["thread",140451],"thread-140447":["thread",140447],"thread-140446":["thread",140446],"thread-140278":["thread",140278],"thread-140249":["thread",140249],"thread-140243":["thread",140243],"thread-140188":["thread",140188],"thread-140149":["thread",140149],"thread-140122":["thread",140122],"thread-140097":["thread",140097],"thread-139874":["thread",139874],"thread-139781":["thread",139781],"thread-139754":["thread",139754],"thread-139726":["thread",139726],"thread-139715":["thread",139715],"thread-139655":["thread",139655],"thread-139646":["thread",139646],"thread-139559":["thread",139559],"thread-139543":["thread",139543],"thread-139499":["thread",139499],"thread-139441":["thread",139441],"thread-139436":["thread",139436],"thread-139399":["thread",139399],"thread-139380":["thread",139380],"thread-139362":["thread",139362],"thread-139256":["thread",139256],"thread-139187":["thread",139187],"thread-139180":["thread",139180],"thread-139166":["thread",139166],"thread-139145":["thread",139145],"thread-139129":["thread",139129],"thread-139113":["thread",139113],"thread-139088":["thread",139088],"thread-139081":["thread",139081],"thread-139074":["thread",139074],"thread-138953":["thread",138953],"thread-138947":["thread",138947],"thread-138924":["thread",138924],"thread-138877":["thread",138877],"thread-138793":["thread",138793],"thread-138768":["thread",138768],"thread-138696":["thread",138696],"thread-138695":["thread",138695],"thread-138586":["thread",138586],"thread-138534":["thread",138534],"thread-138277":["thread",138277],"thread-138270":["thread",138270],"thread-138162":["thread",138162],"thread-138150":["thread",138150],"thread-138025":["thread",138025],"thread-138023":["thread",138023],"thread-137791":["thread",137791],"thread-137782":["thread",137782],"thread-137766":["thread",137766],"thread-137672":["thread",137672],"thread-137670":["thread",137670],"thread-137646":["thread",137646],"thread-137617":["thread",137617],"thread-137616":["thread",137616],"thread-137614":["thread",137614],"thread-137502":["thread",137502],"thread-137480":["thread",137480],"thread-137473":["thread",137473],"thread-137471":["thread",137471],"thread-137426":["thread",137426],"thread-137424":["thread",137424],"thread-137406":["thread",137406],"thread-137302":["thread",137302],"thread-137225":["thread",137225]}, NULL, 1716229279
Run Time: 0.001861
- 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 1516
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1248
- 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 2353
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20