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 (45079, 45071, 45018, 44953, 44952, 44945, 44395, 44331, 44298, 43979, 43948, 43855, 43565, 43378, 43215, 43129, 42905, 42790, 42788, 42729, 42662, 42589, 42510, 42330, 42257, 42218, 42213, 42163, 42092, 42029, 41992, 41854, 41835, 41583, 41581, 41530, 41487, 41195, 41128, 40979, 40803, 40377, 40272, 40218, 40118, 40022, 39947, 39926, 39415, 39301, 39160, 38978, 38728, 38500, 38419, 38317, 38315, 38296, 38281, 38121, 37998, 37941, 37880, 37700, 37234, 37188, 37187, 36956, 36919, 36896, 36612, 36516, 36372, 36145, 36108, 36101, 36100, 36073, 35937, 35897, 35657, 35604, 35512, 35428, 35308, 35201, 35160, 35113, 35000, 34908, 34556, 34077, 33828, 33770, 33177, 33090, 32862, 32735, 32476, 32364, 32342, 32169, 31789, 31757, 31706, 31682, 31588, 31546, 31377, 30933, 30874, 30861, 30310, 30242, 30222, 30039, 30001, 29467, 28948, 28846, 28531, 28382, 28152, 27693, 27608, 27584, 27424, 27421, 27402, 27233, 27183, 27148, 27042, 26766, 26480, 26276, 25889, 25705, 25305, 25195, 25147, 24851, 24796, 24501, 24440, 23349, 22123, 21893, 21834, 21478, 21191, 20580, 20104, 19062, 18990, 18024, 17875, 17704, 17378, 16955, 16512, 16510, 15674, 15532, 15459, 15092, 15042, 14919, 14837, 14817, 14803, 14801, 14685, 14620, 14435, 14304, 14085, 14048, 13719, 12923, 12838, 12529, 12200, 11158, 10837, 10643, 10226, 8276, 8697, 7734, 7721, 6918, 6907, 6794, 6764, 6763, 6762, 6527, 6375, 6140, 6055, 5738, 5450, 4941, 4299, 4197, 3972, 3628, 3606, 3586, 3263, 2955, 2891, 2622, 2468, 2187, 8874, 1243, 964, 601, 504, 275, 57, 40))
Run Time: 0.067998
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 224 | 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: 237, 0, 1714806624, {"thread-45018":["thread",45018],"thread-44952":["thread",44952],"thread-44395":["thread",44395],"thread-44331":["thread",44331],"thread-44298":["thread",44298],"thread-43979":["thread",43979],"thread-43948":["thread",43948],"thread-43855":["thread",43855],"thread-43565":["thread",43565],"thread-43215":["thread",43215],"thread-42905":["thread",42905],"thread-42790":["thread",42790],"thread-42788":["thread",42788],"thread-42729":["thread",42729],"thread-42589":["thread",42589],"thread-42510":["thread",42510],"thread-42257":["thread",42257],"thread-42218":["thread",42218],"thread-42163":["thread",42163],"thread-42092":["thread",42092],"thread-41992":["thread",41992],"thread-41854":["thread",41854],"thread-41583":["thread",41583],"thread-41530":["thread",41530],"thread-41487":["thread",41487],"thread-41195":["thread",41195],"thread-41128":["thread",41128],"thread-40979":["thread",40979],"thread-40803":["thread",40803],"thread-40377":["thread",40377],"thread-40218":["thread",40218],"thread-39415":["thread",39415],"thread-39301":["thread",39301],"thread-38978":["thread",38978],"thread-38419":["thread",38419],"thread-38317":["thread",38317],"thread-38315":["thread",38315],"thread-38296":["thread",38296],"thread-38281":["thread",38281],"thread-38121":["thread",38121],"thread-37998":["thread",37998],"thread-37941":["thread",37941],"thread-37700":["thread",37700],"thread-37234":["thread",37234],"thread-37187":["thread",37187],"thread-36919":["thread",36919],"thread-36896":["thread",36896],"thread-36612":["thread",36612],"thread-36516":["thread",36516],"thread-36108":["thread",36108],"thread-36100":["thread",36100],"thread-36073":["thread",36073],"thread-35937":["thread",35937],"thread-35897":["thread",35897],"thread-35604":["thread",35604],"thread-35428":["thread",35428],"thread-35308":["thread",35308],"thread-35201":["thread",35201],"thread-35160":["thread",35160],"thread-35113":["thread",35113],"thread-35000":["thread",35000],"thread-34908":["thread",34908],"thread-33770":["thread",33770],"thread-32476":["thread",32476],"thread-32364":["thread",32364],"thread-32342":["thread",32342],"thread-32169":["thread",32169],"thread-31789":["thread",31789],"thread-31757":["thread",31757],"thread-31706":["thread",31706],"thread-31682":["thread",31682],"thread-31546":["thread",31546],"thread-31377":["thread",31377],"thread-30933":["thread",30933],"thread-30861":["thread",30861],"thread-30310":["thread",30310],"thread-30242":["thread",30242],"thread-30222":["thread",30222],"thread-30039":["thread",30039],"thread-29467":["thread",29467],"thread-28846":["thread",28846],"thread-28382":["thread",28382],"thread-28152":["thread",28152],"thread-27693":["thread",27693],"thread-27608":["thread",27608],"thread-27584":["thread",27584],"thread-27424":["thread",27424],"thread-27421":["thread",27421],"thread-27402":["thread",27402],"thread-27233":["thread",27233],"thread-27148":["thread",27148],"thread-27042":["thread",27042],"thread-26766":["thread",26766],"thread-26480":["thread",26480],"thread-26276":["thread",26276],"thread-25705":["thread",25705],"thread-25305":["thread",25305],"thread-25195":["thread",25195],"thread-24851":["thread",24851],"thread-24796":["thread",24796],"thread-24501":["thread",24501],"thread-24440":["thread",24440],"thread-23349":["thread",23349],"thread-22123":["thread",22123],"thread-21893":["thread",21893],"thread-21834":["thread",21834],"thread-21478":["thread",21478],"thread-21191":["thread",21191],"thread-20104":["thread",20104],"thread-19062":["thread",19062],"thread-17875":["thread",17875],"thread-17704":["thread",17704],"thread-17378":["thread",17378],"thread-16955":["thread",16955],"thread-16510":["thread",16510],"thread-15674":["thread",15674],"thread-15532":["thread",15532],"thread-15459":["thread",15459],"thread-15092":["thread",15092],"thread-15042":["thread",15042],"thread-14837":["thread",14837],"thread-14817":["thread",14817],"thread-14801":["thread",14801],"thread-14685":["thread",14685],"thread-14620":["thread",14620],"thread-14435":["thread",14435],"thread-14304":["thread",14304],"thread-14085":["thread",14085],"thread-14048":["thread",14048],"thread-13719":["thread",13719],"thread-12923":["thread",12923],"thread-12529":["thread",12529],"thread-12200":["thread",12200],"thread-11158":["thread",11158],"thread-10837":["thread",10837],"thread-10643":["thread",10643],"thread-10226":["thread",10226],"thread-8276":["thread",8276],"thread-7734":["thread",7734],"thread-7721":["thread",7721],"thread-6918":["thread",6918],"thread-6907":["thread",6907],"thread-6763":["thread",6763],"thread-6762":["thread",6762],"thread-6527":["thread",6527],"thread-6375":["thread",6375],"thread-6140":["thread",6140],"thread-6055":["thread",6055],"thread-5450":["thread",5450],"thread-4941":["thread",4941],"thread-4299":["thread",4299],"thread-4197":["thread",4197],"thread-3972":["thread",3972],"thread-3628":["thread",3628],"thread-3606":["thread",3606],"thread-3586":["thread",3586],"thread-3263":["thread",3263],"thread-2955":["thread",2955],"thread-2891":["thread",2891],"thread-2622":["thread",2622],"thread-2468":["thread",2468],"thread-2187":["thread",2187],"thread-1243":["thread",1243],"thread-964":["thread",964],"thread-601":["thread",601],"thread-275":["thread",275],"thread-57":["thread",57]}, NULL, 1714803024
Run Time: 0.000546
- 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