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 (45104, 45084, 45059, 43821, 43392, 43346, 43266, 43215, 43214, 43179, 43104, 43052, 43027, 43009, 43003, 42886, 42861, 42826, 42806, 42791, 42774, 42736, 42411, 42268, 42222, 42081, 42026, 41954, 41750, 41616, 41596, 41559, 41510, 41118, 40945, 40787, 40560, 40554, 40435, 40430, 40395, 40394, 40355, 40343, 40272, 40261, 39911, 39873, 39789, 39461, 39412, 39397, 39183, 38960, 38720, 38622, 38499, 38473, 38472, 38461, 38323, 38216, 37919, 37878, 37829, 37709, 37688, 37382, 37366, 37289, 37120, 37098, 36982, 36972, 36968, 36961, 36898, 36875, 36868, 36864, 36849, 36744, 36521, 36414, 36407, 36404, 36353, 36352, 36319, 36272, 36140, 36053, 36033, 35894, 35775, 35773, 35612, 35500, 35283, 35231, 35127, 35087, 35004, 34994, 34909, 34888, 34839, 34801, 34793, 34772, 34481, 34393, 34384, 34354, 34226, 34217, 34214, 34181, 34046, 33984, 33958, 33765, 33759, 33735, 33733, 33561, 33552, 33550, 33534, 33530, 33008, 32956, 32764, 32733, 32706, 32666, 32665, 32601, 32268, 32010, 31933, 31839, 31823, 31815, 31789, 31725, 31710, 31681, 31608, 31599, 31566, 31511, 31437, 31401, 31387, 31385, 31342, 31339, 31326, 31321, 31318, 31274, 31263, 31229, 31204, 31174, 31124, 31112, 31071, 31028, 31018, 31012, 30986, 30976, 30923, 30922, 30920, 30858, 30857, 30824, 30805, 30763, 30728, 30711, 30699, 30663, 30611, 30512, 30330, 30326, 30310, 30250, 30235, 30210, 30095, 30067, 30040, 30037, 29997, 29915, 29886, 29865, 29836, 29827, 29781, 29716, 29708, 29686, 29650, 29599, 29412, 29389, 29379, 29374, 29364, 29274, 29258, 29187, 29151, 29150, 29149, 29147, 29071, 29067, 28992, 28983, 28936, 28932, 28898, 28868, 28861, 28816, 28812, 28765, 28756, 28755, 28736, 28711, 28651, 28640, 28576, 28550, 28525, 28515, 28480, 28447, 28419, 28408, 28374, 28361))
Run Time: 0.120366
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: 711, 0, 1716009797, {"thread-45104":["thread",45104],"thread-45084":["thread",45084],"thread-45059":["thread",45059],"thread-43821":["thread",43821],"thread-43346":["thread",43346],"thread-43266":["thread",43266],"thread-43215":["thread",43215],"thread-43214":["thread",43214],"thread-43104":["thread",43104],"thread-43027":["thread",43027],"thread-43009":["thread",43009],"thread-43003":["thread",43003],"thread-42886":["thread",42886],"thread-42806":["thread",42806],"thread-42791":["thread",42791],"thread-42774":["thread",42774],"thread-42411":["thread",42411],"thread-42268":["thread",42268],"thread-42222":["thread",42222],"thread-42081":["thread",42081],"thread-41954":["thread",41954],"thread-41616":["thread",41616],"thread-41559":["thread",41559],"thread-41510":["thread",41510],"thread-41118":["thread",41118],"thread-40787":["thread",40787],"thread-40554":["thread",40554],"thread-40435":["thread",40435],"thread-40430":["thread",40430],"thread-40395":["thread",40395],"thread-40355":["thread",40355],"thread-40343":["thread",40343],"thread-40261":["thread",40261],"thread-39911":["thread",39911],"thread-39873":["thread",39873],"thread-39412":["thread",39412],"thread-39397":["thread",39397],"thread-39183":["thread",39183],"thread-38960":["thread",38960],"thread-38720":["thread",38720],"thread-38622":["thread",38622],"thread-38499":["thread",38499],"thread-38472":["thread",38472],"thread-38461":["thread",38461],"thread-38323":["thread",38323],"thread-38216":["thread",38216],"thread-37919":["thread",37919],"thread-37878":["thread",37878],"thread-37829":["thread",37829],"thread-37688":["thread",37688],"thread-37382":["thread",37382],"thread-37366":["thread",37366],"thread-37289":["thread",37289],"thread-37120":["thread",37120],"thread-37098":["thread",37098],"thread-36972":["thread",36972],"thread-36968":["thread",36968],"thread-36961":["thread",36961],"thread-36898":["thread",36898],"thread-36875":["thread",36875],"thread-36868":["thread",36868],"thread-36864":["thread",36864],"thread-36849":["thread",36849],"thread-36744":["thread",36744],"thread-36521":["thread",36521],"thread-36414":["thread",36414],"thread-36407":["thread",36407],"thread-36404":["thread",36404],"thread-36353":["thread",36353],"thread-36352":["thread",36352],"thread-36319":["thread",36319],"thread-36272":["thread",36272],"thread-36140":["thread",36140],"thread-36033":["thread",36033],"thread-35894":["thread",35894],"thread-35500":["thread",35500],"thread-35283":["thread",35283],"thread-35231":["thread",35231],"thread-35127":["thread",35127],"thread-35087":["thread",35087],"thread-34994":["thread",34994],"thread-34909":["thread",34909],"thread-34888":["thread",34888],"thread-34839":["thread",34839],"thread-34801":["thread",34801],"thread-34793":["thread",34793],"thread-34772":["thread",34772],"thread-34481":["thread",34481],"thread-34393":["thread",34393],"thread-34384":["thread",34384],"thread-34354":["thread",34354],"thread-34217":["thread",34217],"thread-34214":["thread",34214],"thread-34181":["thread",34181],"thread-34046":["thread",34046],"thread-33984":["thread",33984],"thread-33958":["thread",33958],"thread-33735":["thread",33735],"thread-33733":["thread",33733],"thread-33552":["thread",33552],"thread-33550":["thread",33550],"thread-33530":["thread",33530],"thread-33008":["thread",33008],"thread-32956":["thread",32956],"thread-32764":["thread",32764],"thread-32733":["thread",32733],"thread-32706":["thread",32706],"thread-32666":["thread",32666],"thread-32665":["thread",32665],"thread-32268":["thread",32268],"thread-32010":["thread",32010],"thread-31933":["thread",31933],"thread-31839":["thread",31839],"thread-31823":["thread",31823],"thread-31815":["thread",31815],"thread-31789":["thread",31789],"thread-31725":["thread",31725],"thread-31710":["thread",31710],"thread-31681":["thread",31681],"thread-31608":["thread",31608],"thread-31599":["thread",31599],"thread-31566":["thread",31566],"thread-31511":["thread",31511],"thread-31437":["thread",31437],"thread-31401":["thread",31401],"thread-31387":["thread",31387],"thread-31385":["thread",31385],"thread-31342":["thread",31342],"thread-31339":["thread",31339],"thread-31326":["thread",31326],"thread-31321":["thread",31321],"thread-31318":["thread",31318],"thread-31229":["thread",31229],"thread-31174":["thread",31174],"thread-31124":["thread",31124],"thread-31112":["thread",31112],"thread-31071":["thread",31071],"thread-31028":["thread",31028],"thread-31012":["thread",31012],"thread-30986":["thread",30986],"thread-30976":["thread",30976],"thread-30923":["thread",30923],"thread-30922":["thread",30922],"thread-30805":["thread",30805],"thread-30728":["thread",30728],"thread-30699":["thread",30699],"thread-30611":["thread",30611],"thread-30512":["thread",30512],"thread-30330":["thread",30330],"thread-30326":["thread",30326],"thread-30310":["thread",30310],"thread-30250":["thread",30250],"thread-30235":["thread",30235],"thread-30210":["thread",30210],"thread-30095":["thread",30095],"thread-29997":["thread",29997],"thread-29915":["thread",29915],"thread-29886":["thread",29886],"thread-29865":["thread",29865],"thread-29827":["thread",29827],"thread-29781":["thread",29781],"thread-29716":["thread",29716],"thread-29708":["thread",29708],"thread-29412":["thread",29412],"thread-29389":["thread",29389],"thread-29374":["thread",29374],"thread-29364":["thread",29364],"thread-29258":["thread",29258],"thread-29187":["thread",29187],"thread-29151":["thread",29151],"thread-29149":["thread",29149],"thread-29147":["thread",29147],"thread-29071":["thread",29071],"thread-29067":["thread",29067],"thread-28983":["thread",28983],"thread-28936":["thread",28936],"thread-28932":["thread",28932],"thread-28898":["thread",28898],"thread-28868":["thread",28868],"thread-28861":["thread",28861],"thread-28812":["thread",28812],"thread-28765":["thread",28765],"thread-28756":["thread",28756],"thread-28755":["thread",28755],"thread-28711":["thread",28711],"thread-28651":["thread",28651],"thread-28640":["thread",28640],"thread-28576":["thread",28576],"thread-28550":["thread",28550],"thread-28525":["thread",28525],"thread-28480":["thread",28480],"thread-28447":["thread",28447],"thread-28419":["thread",28419]}, NULL, 1716006197
Run Time: 0.001212
- 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