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 (44265, 44151, 44150, 44081, 42229, 39598, 39373, 39360, 39359, 39335, 36874, 36860, 35194, 35193, 35192, 35191, 35190, 35189, 35188, 35187, 35186, 35185, 35184, 35183, 35182, 35181, 35180, 35179, 35178, 35177, 35176, 35175, 35174, 35173, 35172, 35171, 35170, 35169, 35168, 35167, 35166, 35165, 35164, 35163, 35162, 35161, 35160, 35159, 35158, 35157, 35156, 35155, 35154, 35153, 35152, 35151, 35150, 35149, 35148, 35147, 35146, 35145, 35144, 35143, 35142, 35141, 35140, 35139, 35138, 35137, 35136, 35135, 35134, 35133, 35132, 35131, 35130, 35129, 35128, 35127, 35126, 35125, 35124, 35123, 35122, 35121, 35120, 35119, 35118, 35117, 35116, 35115, 35114, 35113, 35112, 35111, 35110, 35109, 35108, 35107, 35106, 35105, 35104, 35103, 35102, 35101, 35100, 35099, 35098, 35097, 35096, 35095, 35094, 35093, 35092, 35091, 35090, 35089, 35088, 35087, 35086, 35085, 35084, 35083, 35082, 35081, 35080, 35079, 35078, 35077, 35076, 35073, 35072, 35071, 35070, 35069, 35068, 35067, 35066, 35065, 35064, 35063, 35062, 35061, 35060, 35059, 35058, 35057, 35056, 35055, 35054, 35053, 35052, 35051, 35050, 35049, 35048, 35047, 35046, 35045, 35044, 35043, 35042, 35041, 35040, 35039, 35038, 35037, 35036, 35035, 35034, 35033, 35032, 35031, 35030, 35029, 35028, 35027, 35026, 35025, 35024, 35023, 35022, 35021, 35020, 35019, 35018, 35017, 35016, 35015, 35014, 35013, 35012, 35011, 35010, 35009, 35008, 35007, 35006, 35005))
Run Time: 0.015452
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 | import4.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | import4.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,import4.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 1387
- 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 2719
- 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 2345
- XF\App->run() in src/XF.php at line 512
- 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: 5805, 0, 1715226462, {"thread-44265":["thread",44265],"thread-44151":["thread",44151],"thread-44150":["thread",44150],"thread-44081":["thread",44081],"thread-42229":["thread",42229],"thread-39598":["thread",39598],"thread-39373":["thread",39373],"thread-39360":["thread",39360],"thread-39359":["thread",39359],"thread-39335":["thread",39335],"thread-36874":["thread",36874],"thread-36860":["thread",36860],"thread-35194":["thread",35194],"thread-35193":["thread",35193],"thread-35192":["thread",35192],"thread-35191":["thread",35191],"thread-35190":["thread",35190],"thread-35189":["thread",35189],"thread-35188":["thread",35188],"thread-35187":["thread",35187],"thread-35186":["thread",35186],"thread-35185":["thread",35185],"thread-35184":["thread",35184],"thread-35183":["thread",35183],"thread-35182":["thread",35182],"thread-35181":["thread",35181],"thread-35180":["thread",35180],"thread-35179":["thread",35179],"thread-35178":["thread",35178],"thread-35177":["thread",35177],"thread-35176":["thread",35176],"thread-35175":["thread",35175],"thread-35174":["thread",35174],"thread-35173":["thread",35173],"thread-35172":["thread",35172],"thread-35171":["thread",35171],"thread-35170":["thread",35170],"thread-35169":["thread",35169],"thread-35168":["thread",35168],"thread-35167":["thread",35167],"thread-35166":["thread",35166],"thread-35165":["thread",35165],"thread-35164":["thread",35164],"thread-35163":["thread",35163],"thread-35162":["thread",35162],"thread-35161":["thread",35161],"thread-35160":["thread",35160],"thread-35159":["thread",35159],"thread-35158":["thread",35158],"thread-35157":["thread",35157],"thread-35156":["thread",35156],"thread-35155":["thread",35155],"thread-35154":["thread",35154],"thread-35153":["thread",35153],"thread-35152":["thread",35152],"thread-35151":["thread",35151],"thread-35150":["thread",35150],"thread-35149":["thread",35149],"thread-35148":["thread",35148],"thread-35147":["thread",35147],"thread-35146":["thread",35146],"thread-35145":["thread",35145],"thread-35144":["thread",35144],"thread-35143":["thread",35143],"thread-35142":["thread",35142],"thread-35141":["thread",35141],"thread-35140":["thread",35140],"thread-35139":["thread",35139],"thread-35138":["thread",35138],"thread-35137":["thread",35137],"thread-35136":["thread",35136],"thread-35135":["thread",35135],"thread-35134":["thread",35134],"thread-35133":["thread",35133],"thread-35132":["thread",35132],"thread-35131":["thread",35131],"thread-35130":["thread",35130],"thread-35129":["thread",35129],"thread-35128":["thread",35128],"thread-35127":["thread",35127],"thread-35126":["thread",35126],"thread-35125":["thread",35125],"thread-35124":["thread",35124],"thread-35123":["thread",35123],"thread-35122":["thread",35122],"thread-35121":["thread",35121],"thread-35120":["thread",35120],"thread-35119":["thread",35119],"thread-35118":["thread",35118],"thread-35117":["thread",35117],"thread-35116":["thread",35116],"thread-35115":["thread",35115],"thread-35114":["thread",35114],"thread-35113":["thread",35113],"thread-35112":["thread",35112],"thread-35111":["thread",35111],"thread-35110":["thread",35110],"thread-35109":["thread",35109],"thread-35108":["thread",35108],"thread-35107":["thread",35107],"thread-35106":["thread",35106],"thread-35105":["thread",35105],"thread-35104":["thread",35104],"thread-35103":["thread",35103],"thread-35102":["thread",35102],"thread-35101":["thread",35101],"thread-35100":["thread",35100],"thread-35099":["thread",35099],"thread-35098":["thread",35098],"thread-35097":["thread",35097],"thread-35096":["thread",35096],"thread-35095":["thread",35095],"thread-35094":["thread",35094],"thread-35093":["thread",35093],"thread-35092":["thread",35092],"thread-35091":["thread",35091],"thread-35090":["thread",35090],"thread-35089":["thread",35089],"thread-35088":["thread",35088],"thread-35087":["thread",35087],"thread-35086":["thread",35086],"thread-35085":["thread",35085],"thread-35084":["thread",35084],"thread-35083":["thread",35083],"thread-35082":["thread",35082],"thread-35081":["thread",35081],"thread-35080":["thread",35080],"thread-35079":["thread",35079],"thread-35078":["thread",35078],"thread-35077":["thread",35077],"thread-35076":["thread",35076],"thread-35073":["thread",35073],"thread-35072":["thread",35072],"thread-35071":["thread",35071],"thread-35070":["thread",35070],"thread-35069":["thread",35069],"thread-35068":["thread",35068],"thread-35067":["thread",35067],"thread-35066":["thread",35066],"thread-35065":["thread",35065],"thread-35064":["thread",35064],"thread-35063":["thread",35063],"thread-35062":["thread",35062],"thread-35061":["thread",35061],"thread-35060":["thread",35060],"thread-35059":["thread",35059],"thread-35058":["thread",35058],"thread-35057":["thread",35057],"thread-35056":["thread",35056],"thread-35055":["thread",35055],"thread-35054":["thread",35054],"thread-35053":["thread",35053],"thread-35052":["thread",35052],"thread-35051":["thread",35051],"thread-35050":["thread",35050],"thread-35049":["thread",35049],"thread-35048":["thread",35048],"thread-35047":["thread",35047],"thread-35046":["thread",35046],"thread-35045":["thread",35045],"thread-35044":["thread",35044],"thread-35043":["thread",35043],"thread-35042":["thread",35042],"thread-35041":["thread",35041],"thread-35040":["thread",35040],"thread-35039":["thread",35039],"thread-35038":["thread",35038],"thread-35037":["thread",35037],"thread-35036":["thread",35036],"thread-35035":["thread",35035],"thread-35034":["thread",35034],"thread-35033":["thread",35033],"thread-35032":["thread",35032],"thread-35031":["thread",35031],"thread-35030":["thread",35030],"thread-35029":["thread",35029],"thread-35028":["thread",35028],"thread-35027":["thread",35027],"thread-35026":["thread",35026],"thread-35025":["thread",35025],"thread-35024":["thread",35024],"thread-35023":["thread",35023],"thread-35022":["thread",35022],"thread-35021":["thread",35021],"thread-35020":["thread",35020],"thread-35019":["thread",35019],"thread-35018":["thread",35018],"thread-35017":["thread",35017],"thread-35016":["thread",35016],"thread-35015":["thread",35015],"thread-35014":["thread",35014],"thread-35013":["thread",35013],"thread-35012":["thread",35012],"thread-35011":["thread",35011],"thread-35010":["thread",35010],"thread-35009":["thread",35009],"thread-35008":["thread",35008],"thread-35007":["thread",35007],"thread-35006":["thread",35006],"thread-35005":["thread",35005]}, , 1715222862
Run Time: 0.002323
- 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 1512
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1244
- 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 2345
- XF\App->run() in src/XF.php at line 512
- XF::runApp() in index.php at line 20