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 (45091, 45084, 44889, 43390, 43346, 43266, 43003, 42910, 42828, 42633, 42631, 42622, 42592, 42528, 42463, 42358, 42253, 41954, 41876, 41872, 41542, 41462, 41159, 40901, 40517, 40471, 40463, 40269, 40234, 40172, 39902, 39883, 39239, 39183, 39010, 38973, 38476, 38259, 38050, 38038, 37974, 37807, 37725, 37721, 37705, 37352, 37299, 37176, 36972, 36604, 36601, 36352, 36319, 36287, 36272, 35905, 35231, 35005, 34912, 34377, 34093, 34055, 34037, 33978, 33654, 33435, 33417, 32781, 32665, 32589, 32044, 31608, 31566, 31489, 31337, 31026, 30755, 30343, 30038, 29990, 29911, 29709, 29471, 29187, 29022, 29021, 28759, 28711, 28559, 28246, 28230, 27979, 27767, 27583, 27339, 26929, 26914, 26890, 26821, 26817, 26816, 26669, 26572, 26205, 26142, 26088, 25940, 25902, 25832, 25721, 25594, 25524, 25367, 25338, 25274, 24962, 24954, 24633, 24359, 24210, 24191, 24132, 24129, 24071, 24062, 23673, 23663, 23466, 23416, 23375, 23346, 23309, 23304, 23068, 23036, 22780, 22611, 22413, 22298, 22113, 21985, 21958, 21766, 21655, 21489, 21486, 21468, 21438, 21437, 21173, 21053, 20908, 20658, 20597, 20460, 20456, 20343, 20313, 20280, 20169, 20023, 20002, 19908, 19877, 19834, 19787, 19568, 19561, 19533, 19433, 19179, 19134, 19117, 19107, 19027, 18885, 18830, 18818, 18808, 18738, 18469, 18467, 18299, 18293, 18022, 17329, 17305, 17248, 16523, 16502, 15991, 15893, 15840, 15723, 15436, 15248, 15226, 15133, 14507, 11406, 10912, 10760, 10692, 10195, 10189, 7871, 7692, 6763, 6044, 6037, 5531, 5385, 4482, 4445, 4344, 4094, 3278, 3216, 3208, 2438, 2300, 1235, 1067))
Run Time: 0.087329
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 223 | 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: 3, 0, 1716152137, {"thread-45091":["thread",45091],"thread-45084":["thread",45084],"resource-459":["resource",459],"thread-44889":["thread",44889],"thread-43390":["thread",43390],"thread-43346":["thread",43346],"thread-43266":["thread",43266],"thread-43003":["thread",43003],"thread-42910":["thread",42910],"thread-42828":["thread",42828],"thread-42633":["thread",42633],"thread-42631":["thread",42631],"thread-42592":["thread",42592],"thread-42528":["thread",42528],"thread-42463":["thread",42463],"thread-42358":["thread",42358],"thread-42253":["thread",42253],"thread-41954":["thread",41954],"thread-41872":["thread",41872],"thread-41542":["thread",41542],"thread-41159":["thread",41159],"thread-40901":["thread",40901],"thread-40517":["thread",40517],"thread-40463":["thread",40463],"thread-40269":["thread",40269],"thread-40234":["thread",40234],"thread-40172":["thread",40172],"thread-39902":["thread",39902],"thread-39883":["thread",39883],"thread-39239":["thread",39239],"thread-39183":["thread",39183],"thread-39010":["thread",39010],"thread-38973":["thread",38973],"thread-38476":["thread",38476],"thread-38050":["thread",38050],"thread-38038":["thread",38038],"thread-37974":["thread",37974],"thread-37807":["thread",37807],"thread-37725":["thread",37725],"thread-37721":["thread",37721],"thread-37705":["thread",37705],"thread-37352":["thread",37352],"thread-37299":["thread",37299],"thread-37176":["thread",37176],"thread-36972":["thread",36972],"thread-36604":["thread",36604],"thread-36601":["thread",36601],"thread-36352":["thread",36352],"thread-36319":["thread",36319],"thread-36287":["thread",36287],"thread-36272":["thread",36272],"thread-35905":["thread",35905],"thread-35231":["thread",35231],"thread-35005":["thread",35005],"thread-34912":["thread",34912],"thread-34377":["thread",34377],"thread-34093":["thread",34093],"thread-34055":["thread",34055],"thread-34037":["thread",34037],"thread-33978":["thread",33978],"thread-33654":["thread",33654],"thread-33435":["thread",33435],"thread-33417":["thread",33417],"thread-32781":["thread",32781],"thread-32665":["thread",32665],"thread-32589":["thread",32589],"thread-32044":["thread",32044],"thread-31608":["thread",31608],"thread-31566":["thread",31566],"thread-31489":["thread",31489],"thread-31337":["thread",31337],"thread-31026":["thread",31026],"thread-30755":["thread",30755],"thread-30343":["thread",30343],"thread-30038":["thread",30038],"thread-29911":["thread",29911],"thread-29709":["thread",29709],"thread-29187":["thread",29187],"thread-29022":["thread",29022],"thread-29021":["thread",29021],"thread-28711":["thread",28711],"thread-28559":["thread",28559],"thread-28246":["thread",28246],"thread-28230":["thread",28230],"thread-27767":["thread",27767],"thread-27583":["thread",27583],"thread-27339":["thread",27339],"thread-26929":["thread",26929],"thread-26914":["thread",26914],"thread-26890":["thread",26890],"thread-26821":["thread",26821],"thread-26817":["thread",26817],"thread-26816":["thread",26816],"thread-26669":["thread",26669],"thread-26572":["thread",26572],"thread-26205":["thread",26205],"thread-26142":["thread",26142],"thread-26088":["thread",26088],"thread-25940":["thread",25940],"thread-25902":["thread",25902],"thread-25832":["thread",25832],"thread-25721":["thread",25721],"thread-25594":["thread",25594],"thread-25524":["thread",25524],"thread-25367":["thread",25367],"thread-25338":["thread",25338],"thread-25274":["thread",25274],"thread-24962":["thread",24962],"thread-24954":["thread",24954],"thread-24633":["thread",24633],"thread-24359":["thread",24359],"thread-24210":["thread",24210],"thread-24129":["thread",24129],"thread-24071":["thread",24071],"thread-24062":["thread",24062],"thread-23673":["thread",23673],"thread-23663":["thread",23663],"thread-23466":["thread",23466],"thread-23416":["thread",23416],"thread-23375":["thread",23375],"thread-23346":["thread",23346],"thread-23309":["thread",23309],"thread-23304":["thread",23304],"thread-23068":["thread",23068],"thread-23036":["thread",23036],"thread-22780":["thread",22780],"thread-22611":["thread",22611],"thread-22413":["thread",22413],"thread-22298":["thread",22298],"thread-22113":["thread",22113],"thread-21985":["thread",21985],"thread-21958":["thread",21958],"thread-21766":["thread",21766],"thread-21655":["thread",21655],"thread-21489":["thread",21489],"thread-21486":["thread",21486],"thread-21468":["thread",21468],"thread-21438":["thread",21438],"thread-21173":["thread",21173],"thread-21053":["thread",21053],"thread-20908":["thread",20908],"thread-20658":["thread",20658],"thread-20597":["thread",20597],"thread-20460":["thread",20460],"thread-20456":["thread",20456],"thread-20343":["thread",20343],"thread-20313":["thread",20313],"thread-20280":["thread",20280],"thread-20169":["thread",20169],"thread-20023":["thread",20023],"thread-20002":["thread",20002],"thread-19908":["thread",19908],"thread-19877":["thread",19877],"thread-19834":["thread",19834],"thread-19787":["thread",19787],"thread-19568":["thread",19568],"thread-19561":["thread",19561],"thread-19533":["thread",19533],"thread-19433":["thread",19433],"thread-19179":["thread",19179],"thread-19134":["thread",19134],"thread-19117":["thread",19117],"thread-19107":["thread",19107],"thread-19027":["thread",19027],"thread-18885":["thread",18885],"thread-18830":["thread",18830],"thread-18818":["thread",18818],"thread-18808":["thread",18808],"thread-18738":["thread",18738],"thread-18469":["thread",18469],"thread-18467":["thread",18467],"thread-18299":["thread",18299],"thread-18293":["thread",18293],"thread-18022":["thread",18022],"thread-17329":["thread",17329],"thread-17305":["thread",17305],"thread-17248":["thread",17248],"thread-16523":["thread",16523],"thread-16502":["thread",16502],"thread-15991":["thread",15991],"thread-15893":["thread",15893],"thread-15840":["thread",15840],"thread-15723":["thread",15723],"thread-15436":["thread",15436],"thread-15248":["thread",15248],"thread-15226":["thread",15226],"thread-15133":["thread",15133],"thread-14507":["thread",14507],"thread-11406":["thread",11406],"thread-10912":["thread",10912],"thread-10760":["thread",10760],"thread-10692":["thread",10692],"thread-10195":["thread",10195],"thread-10189":["thread",10189],"thread-7692":["thread",7692],"thread-6763":["thread",6763],"thread-6037":["thread",6037],"thread-5531":["thread",5531],"thread-5385":["thread",5385],"thread-4482":["thread",4482],"thread-4445":["thread",4445],"thread-4344":["thread",4344],"thread-4094":["thread",4094],"thread-3278":["thread",3278],"thread-3208":["thread",3208],"thread-2438":["thread",2438]}, NULL, 1716148537
Run Time: 0.000707
- 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