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 (43302, 42811, 42016, 41991, 41760, 41540, 41511, 41505, 41357, 41118, 41067, 40988, 40880, 40748, 40120, 39793, 39704, 39229, 39192, 39186, 39171, 39113, 39075, 38974, 38546, 38471, 38165, 38107, 37771, 37649, 37543, 37439, 37308, 37232, 37193, 37170, 37024, 36921, 36914, 36751, 36745, 36694, 36618, 36577, 36551, 36507, 36098, 35951, 35888, 35846, 35839, 35659, 35400, 34975, 34965, 34935, 34868, 34799, 34691, 34682, 34571, 34562, 34471, 34154, 34015, 33975, 33550, 33385, 33197, 33029, 32929, 32586, 32568, 32564, 32477, 32461, 32394, 32281, 32280, 32275, 32274, 32273, 32272, 32271, 32270, 32269, 32164, 32145, 32124, 32071, 31967, 31878, 31772, 31763, 31753, 31751, 31334, 31319, 31288, 31128, 31079, 31075, 31060, 31028, 30826, 30642, 30462, 30384, 30159, 30006, 29997, 29962, 29960, 29922, 29842, 29741, 29734, 29566, 29409, 29362, 29149, 28936, 28624, 28560, 28443, 28362, 28340, 28302, 28299, 28269, 28228, 28078, 27963, 27613, 27548, 27275, 27224, 27055, 26878, 26877, 26817, 26471, 26358, 26199, 25770, 25608, 25595, 25359, 25284, 25181, 25057, 25039, 24770, 24465, 24457, 24268, 24226, 24206, 24205, 24189, 24022, 23791, 23706, 23643, 23633, 23610, 23536, 23498, 23454, 23429, 23265, 23254, 23026, 22604, 22232, 21894, 21509, 21460, 21360, 21308, 21044, 20972, 20957, 20826, 20619, 20572, 20542, 20413, 20398, 20313, 20140, 19989, 19775, 19737, 19736, 19707, 19579, 19461, 19372, 19369, 19368, 19333, 19332, 19312, 19306, 19305, 19303, 19302, 19301, 19215, 19204, 19172, 19129, 19034, 19007, 18654, 18652, 18350, 18293, 18291, 18262, 18228, 18183, 18092, 18045, 17841, 17781, 17728, 17565, 17434, 17407, 17385, 17317, 17236, 17221, 17141, 17053, 17039, 16746, 16678, 16559, 16524, 16487, 16486, 16320, 16275, 16269, 16120, 16115, 15812))
Run Time: 0.083382
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 250 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | squattheplanet.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,squattheplanet.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 1430
- 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 2866
- 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 2483
- 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: 217, 0, 1716015415, {"thread-42016":["thread",42016],"thread-41760":["thread",41760],"thread-41540":["thread",41540],"thread-41511":["thread",41511],"thread-41505":["thread",41505],"thread-41357":["thread",41357],"thread-41118":["thread",41118],"thread-41067":["thread",41067],"thread-40988":["thread",40988],"thread-40880":["thread",40880],"thread-40748":["thread",40748],"thread-40120":["thread",40120],"thread-39704":["thread",39704],"thread-39192":["thread",39192],"thread-39186":["thread",39186],"thread-39171":["thread",39171],"thread-39113":["thread",39113],"thread-39075":["thread",39075],"thread-38974":["thread",38974],"thread-38546":["thread",38546],"thread-38471":["thread",38471],"thread-38165":["thread",38165],"thread-38107":["thread",38107],"thread-37771":["thread",37771],"thread-37649":["thread",37649],"thread-37543":["thread",37543],"thread-37439":["thread",37439],"thread-37308":["thread",37308],"thread-37232":["thread",37232],"thread-37193":["thread",37193],"thread-37170":["thread",37170],"thread-37024":["thread",37024],"thread-36921":["thread",36921],"thread-36914":["thread",36914],"thread-36751":["thread",36751],"thread-36745":["thread",36745],"thread-36694":["thread",36694],"thread-36618":["thread",36618],"thread-36577":["thread",36577],"thread-36551":["thread",36551],"thread-36507":["thread",36507],"thread-36098":["thread",36098],"thread-35951":["thread",35951],"thread-35888":["thread",35888],"thread-35846":["thread",35846],"thread-35839":["thread",35839],"thread-35659":["thread",35659],"thread-35400":["thread",35400],"thread-34975":["thread",34975],"thread-34965":["thread",34965],"thread-34935":["thread",34935],"thread-34868":["thread",34868],"thread-34799":["thread",34799],"thread-34691":["thread",34691],"thread-34682":["thread",34682],"thread-34571":["thread",34571],"thread-34562":["thread",34562],"thread-34471":["thread",34471],"thread-34154":["thread",34154],"thread-34015":["thread",34015],"thread-33975":["thread",33975],"thread-33550":["thread",33550],"thread-33385":["thread",33385],"thread-33197":["thread",33197],"thread-33029":["thread",33029],"thread-32929":["thread",32929],"thread-32586":["thread",32586],"thread-32568":["thread",32568],"thread-32564":["thread",32564],"thread-32477":["thread",32477],"thread-32461":["thread",32461],"thread-32394":["thread",32394],"thread-32281":["thread",32281],"thread-32280":["thread",32280],"thread-32275":["thread",32275],"thread-32274":["thread",32274],"thread-32273":["thread",32273],"thread-32272":["thread",32272],"thread-32271":["thread",32271],"thread-32270":["thread",32270],"thread-32269":["thread",32269],"thread-32164":["thread",32164],"thread-32145":["thread",32145],"thread-32124":["thread",32124],"thread-32071":["thread",32071],"thread-31967":["thread",31967],"thread-31878":["thread",31878],"thread-31772":["thread",31772],"thread-31763":["thread",31763],"thread-31753":["thread",31753],"thread-31751":["thread",31751],"thread-31334":["thread",31334],"thread-31319":["thread",31319],"thread-31288":["thread",31288],"thread-31128":["thread",31128],"thread-31079":["thread",31079],"thread-31075":["thread",31075],"thread-31060":["thread",31060],"thread-31028":["thread",31028],"thread-30826":["thread",30826],"thread-30642":["thread",30642],"thread-30462":["thread",30462],"thread-30384":["thread",30384],"thread-30159":["thread",30159],"thread-30006":["thread",30006],"thread-29997":["thread",29997],"thread-29962":["thread",29962],"thread-29960":["thread",29960],"thread-29922":["thread",29922],"thread-29842":["thread",29842],"thread-29741":["thread",29741],"thread-29734":["thread",29734],"thread-29566":["thread",29566],"thread-29409":["thread",29409],"thread-29362":["thread",29362],"thread-29149":["thread",29149],"thread-28936":["thread",28936],"thread-28624":["thread",28624],"thread-28560":["thread",28560],"thread-28443":["thread",28443],"thread-28362":["thread",28362],"thread-28340":["thread",28340],"thread-28302":["thread",28302],"thread-28299":["thread",28299],"thread-28269":["thread",28269],"thread-28228":["thread",28228],"thread-28078":["thread",28078],"thread-27963":["thread",27963],"thread-27613":["thread",27613],"thread-27548":["thread",27548],"thread-27275":["thread",27275],"thread-27224":["thread",27224],"thread-27055":["thread",27055],"thread-26878":["thread",26878],"thread-26877":["thread",26877],"thread-26817":["thread",26817],"thread-26471":["thread",26471],"thread-26358":["thread",26358],"thread-26199":["thread",26199],"thread-25770":["thread",25770],"thread-25608":["thread",25608],"thread-25595":["thread",25595],"thread-25359":["thread",25359],"thread-25284":["thread",25284],"thread-25181":["thread",25181],"thread-25057":["thread",25057],"thread-25039":["thread",25039],"thread-24770":["thread",24770],"thread-24465":["thread",24465],"thread-24457":["thread",24457],"thread-24268":["thread",24268],"thread-24226":["thread",24226],"thread-24206":["thread",24206],"thread-24205":["thread",24205],"thread-24189":["thread",24189],"thread-24022":["thread",24022],"thread-23791":["thread",23791],"thread-23706":["thread",23706],"thread-23643":["thread",23643],"thread-23633":["thread",23633],"thread-23610":["thread",23610],"thread-23536":["thread",23536],"thread-23498":["thread",23498],"thread-23454":["thread",23454],"thread-23429":["thread",23429],"thread-23265":["thread",23265],"thread-23254":["thread",23254],"thread-23026":["thread",23026],"thread-22604":["thread",22604],"thread-22232":["thread",22232],"thread-21894":["thread",21894],"thread-21509":["thread",21509],"thread-21460":["thread",21460],"thread-21360":["thread",21360],"thread-21308":["thread",21308],"thread-21044":["thread",21044],"thread-20972":["thread",20972],"thread-20957":["thread",20957],"thread-20826":["thread",20826],"thread-20619":["thread",20619],"thread-20572":["thread",20572],"thread-20542":["thread",20542],"thread-20413":["thread",20413],"thread-20398":["thread",20398],"thread-20313":["thread",20313],"thread-20140":["thread",20140],"thread-19989":["thread",19989],"thread-19775":["thread",19775],"thread-19737":["thread",19737],"thread-19736":["thread",19736],"thread-19707":["thread",19707],"thread-19579":["thread",19579],"thread-19461":["thread",19461],"thread-19372":["thread",19372],"thread-19369":["thread",19369],"thread-19368":["thread",19368],"thread-19333":["thread",19333],"thread-19332":["thread",19332],"thread-19312":["thread",19312],"thread-19306":["thread",19306],"thread-19305":["thread",19305],"thread-19303":["thread",19303],"thread-19302":["thread",19302],"thread-19301":["thread",19301],"thread-19215":["thread",19215],"thread-19204":["thread",19204],"thread-19172":["thread",19172],"thread-19129":["thread",19129],"thread-19034":["thread",19034],"thread-19007":["thread",19007],"thread-18654":["thread",18654],"thread-18652":["thread",18652],"thread-18350":["thread",18350],"thread-18293":["thread",18293],"thread-18291":["thread",18291],"thread-18262":["thread",18262],"thread-18228":["thread",18228],"thread-18183":["thread",18183],"thread-18092":["thread",18092],"thread-18045":["thread",18045],"thread-17841":["thread",17841],"thread-17781":["thread",17781],"thread-17728":["thread",17728],"thread-17565":["thread",17565],"thread-17434":["thread",17434],"thread-17407":["thread",17407],"thread-17385":["thread",17385],"thread-17317":["thread",17317],"thread-17236":["thread",17236],"thread-17221":["thread",17221],"thread-17141":["thread",17141],"thread-17053":["thread",17053],"thread-17039":["thread",17039],"thread-16746":["thread",16746],"thread-16678":["thread",16678],"thread-16559":["thread",16559],"thread-16524":["thread",16524],"thread-16487":["thread",16487],"thread-16486":["thread",16486],"thread-16320":["thread",16320],"thread-16275":["thread",16275],"thread-16269":["thread",16269],"thread-16120":["thread",16120],"thread-16115":["thread",16115],"thread-15812":["thread",15812]}, NULL, 1716011815
Run Time: 0.000682
- 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 1521
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1253
- 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 2483
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20