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 (39279, 39278, 39277, 39276, 39275, 39274, 39273, 39272, 39271, 39270, 39269, 39268, 39267, 39266, 39265, 39264, 39263, 39262, 39261, 39260, 39259, 39258, 39257, 39256, 39255, 39254, 39253, 39252, 39251, 39250, 39249, 39248, 39247, 39246, 39245, 39244, 39243, 39242, 39241, 39240, 39239, 39238, 39237, 39236, 39235, 39234, 39233, 39232, 39231, 39230, 39229, 39228, 39227, 39226, 39225, 39224, 39223, 39222, 39221, 39220, 39219, 39218, 39217, 39216, 39215, 39214, 39213, 39212, 39211, 39210, 39209, 39208, 39207, 39206, 39205, 39204, 39203, 39202, 39201, 39200, 39199, 39198, 39197, 39196, 39195, 39194, 39193, 39192, 39191, 39190, 39189, 39188, 39187, 39186, 39185, 39184, 39183, 39182, 39181, 39180, 39179, 39178, 39177, 39176, 39175, 39174, 39173, 39172, 39171, 39170, 39169, 39168, 39167, 39166, 39165, 39164, 39163, 39162, 39161, 39160, 39159, 39158, 39157, 39156, 39155, 39154, 39153, 39152, 39151, 39150, 39149, 39148, 39147, 39146, 39145, 39144, 39143, 39142, 39141, 39140, 39139, 39138, 39137, 39136, 39135, 39134, 39133, 39132, 39131, 39130, 39129, 39128, 39127, 39126, 39125, 39124, 39123, 39122, 39121, 39120, 39119, 39118, 39117, 39116, 39115, 39114, 39113, 39112, 39111, 39110, 39109, 39108, 39107, 39106, 39105, 39104, 39103, 39102, 39101, 39100, 39099, 39098, 39097, 39096, 39095, 39094, 39093, 39092, 39091, 39090, 39089, 39088, 39087, 39086, 39085, 39084, 39083, 39082, 39081, 39080))
Run Time: 0.017821
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: 6639, 0, 1715665800, {"thread-39279":["thread",39279],"thread-39278":["thread",39278],"thread-39277":["thread",39277],"thread-39276":["thread",39276],"thread-39275":["thread",39275],"thread-39274":["thread",39274],"thread-39273":["thread",39273],"thread-39272":["thread",39272],"thread-39271":["thread",39271],"thread-39270":["thread",39270],"thread-39269":["thread",39269],"thread-39268":["thread",39268],"thread-39267":["thread",39267],"thread-39266":["thread",39266],"thread-39265":["thread",39265],"thread-39264":["thread",39264],"thread-39263":["thread",39263],"thread-39262":["thread",39262],"thread-39261":["thread",39261],"thread-39260":["thread",39260],"thread-39259":["thread",39259],"thread-39258":["thread",39258],"thread-39257":["thread",39257],"thread-39256":["thread",39256],"thread-39255":["thread",39255],"thread-39254":["thread",39254],"thread-39253":["thread",39253],"thread-39252":["thread",39252],"thread-39251":["thread",39251],"thread-39250":["thread",39250],"thread-39249":["thread",39249],"thread-39248":["thread",39248],"thread-39247":["thread",39247],"thread-39246":["thread",39246],"thread-39245":["thread",39245],"thread-39244":["thread",39244],"thread-39243":["thread",39243],"thread-39242":["thread",39242],"thread-39241":["thread",39241],"thread-39240":["thread",39240],"thread-39239":["thread",39239],"thread-39238":["thread",39238],"thread-39237":["thread",39237],"thread-39236":["thread",39236],"thread-39235":["thread",39235],"thread-39234":["thread",39234],"thread-39233":["thread",39233],"thread-39232":["thread",39232],"thread-39231":["thread",39231],"thread-39230":["thread",39230],"thread-39229":["thread",39229],"thread-39228":["thread",39228],"thread-39227":["thread",39227],"thread-39226":["thread",39226],"thread-39225":["thread",39225],"thread-39224":["thread",39224],"thread-39223":["thread",39223],"thread-39222":["thread",39222],"thread-39221":["thread",39221],"thread-39220":["thread",39220],"thread-39219":["thread",39219],"thread-39218":["thread",39218],"thread-39217":["thread",39217],"thread-39216":["thread",39216],"thread-39215":["thread",39215],"thread-39214":["thread",39214],"thread-39213":["thread",39213],"thread-39212":["thread",39212],"thread-39211":["thread",39211],"thread-39210":["thread",39210],"thread-39209":["thread",39209],"thread-39208":["thread",39208],"thread-39207":["thread",39207],"thread-39206":["thread",39206],"thread-39205":["thread",39205],"thread-39204":["thread",39204],"thread-39203":["thread",39203],"thread-39202":["thread",39202],"thread-39201":["thread",39201],"thread-39200":["thread",39200],"thread-39199":["thread",39199],"thread-39198":["thread",39198],"thread-39197":["thread",39197],"thread-39196":["thread",39196],"thread-39195":["thread",39195],"thread-39194":["thread",39194],"thread-39193":["thread",39193],"thread-39192":["thread",39192],"thread-39191":["thread",39191],"thread-39190":["thread",39190],"thread-39189":["thread",39189],"thread-39188":["thread",39188],"thread-39187":["thread",39187],"thread-39186":["thread",39186],"thread-39185":["thread",39185],"thread-39184":["thread",39184],"thread-39183":["thread",39183],"thread-39182":["thread",39182],"thread-39181":["thread",39181],"thread-39180":["thread",39180],"thread-39179":["thread",39179],"thread-39178":["thread",39178],"thread-39177":["thread",39177],"thread-39176":["thread",39176],"thread-39175":["thread",39175],"thread-39174":["thread",39174],"thread-39173":["thread",39173],"thread-39172":["thread",39172],"thread-39171":["thread",39171],"thread-39170":["thread",39170],"thread-39169":["thread",39169],"thread-39168":["thread",39168],"thread-39167":["thread",39167],"thread-39166":["thread",39166],"thread-39165":["thread",39165],"thread-39164":["thread",39164],"thread-39163":["thread",39163],"thread-39162":["thread",39162],"thread-39161":["thread",39161],"thread-39160":["thread",39160],"thread-39159":["thread",39159],"thread-39158":["thread",39158],"thread-39157":["thread",39157],"thread-39156":["thread",39156],"thread-39155":["thread",39155],"thread-39154":["thread",39154],"thread-39153":["thread",39153],"thread-39152":["thread",39152],"thread-39151":["thread",39151],"thread-39150":["thread",39150],"thread-39149":["thread",39149],"thread-39148":["thread",39148],"thread-39147":["thread",39147],"thread-39146":["thread",39146],"thread-39145":["thread",39145],"thread-39144":["thread",39144],"thread-39143":["thread",39143],"thread-39142":["thread",39142],"thread-39141":["thread",39141],"thread-39140":["thread",39140],"thread-39139":["thread",39139],"thread-39138":["thread",39138],"thread-39137":["thread",39137],"thread-39136":["thread",39136],"thread-39135":["thread",39135],"thread-39134":["thread",39134],"thread-39133":["thread",39133],"thread-39132":["thread",39132],"thread-39131":["thread",39131],"thread-39130":["thread",39130],"thread-39129":["thread",39129],"thread-39128":["thread",39128],"thread-39127":["thread",39127],"thread-39126":["thread",39126],"thread-39125":["thread",39125],"thread-39124":["thread",39124],"thread-39123":["thread",39123],"thread-39122":["thread",39122],"thread-39121":["thread",39121],"thread-39120":["thread",39120],"thread-39119":["thread",39119],"thread-39118":["thread",39118],"thread-39117":["thread",39117],"thread-39116":["thread",39116],"thread-39115":["thread",39115],"thread-39114":["thread",39114],"thread-39113":["thread",39113],"thread-39112":["thread",39112],"thread-39111":["thread",39111],"thread-39110":["thread",39110],"thread-39109":["thread",39109],"thread-39108":["thread",39108],"thread-39107":["thread",39107],"thread-39106":["thread",39106],"thread-39105":["thread",39105],"thread-39104":["thread",39104],"thread-39103":["thread",39103],"thread-39102":["thread",39102],"thread-39101":["thread",39101],"thread-39100":["thread",39100],"thread-39099":["thread",39099],"thread-39098":["thread",39098],"thread-39097":["thread",39097],"thread-39096":["thread",39096],"thread-39095":["thread",39095],"thread-39094":["thread",39094],"thread-39093":["thread",39093],"thread-39092":["thread",39092],"thread-39091":["thread",39091],"thread-39090":["thread",39090],"thread-39089":["thread",39089],"thread-39088":["thread",39088],"thread-39087":["thread",39087],"thread-39086":["thread",39086],"thread-39085":["thread",39085],"thread-39084":["thread",39084],"thread-39083":["thread",39083],"thread-39082":["thread",39082],"thread-39081":["thread",39081],"thread-39080":["thread",39080]}, , 1715662200
Run Time: 0.000583
- 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