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 (46203, 17227, 17226, 17225, 17224, 17223, 17222, 17221, 17220, 17219, 17218, 17217, 17215, 17214, 17213, 17212, 17211, 17210, 17209, 17208, 17207, 17205, 17204, 17202, 17201, 17200, 17199, 17198, 17197, 17196, 17193, 17192, 17191, 17190, 17189, 17188, 17187, 17186, 17184, 17183, 17182, 17180, 17178, 17177, 17176, 17175, 17174, 17173, 17172, 17171, 17170, 17169, 17168, 17167, 17166, 17165, 17164, 17163, 17162, 17161, 17160, 17159, 17158, 17157, 17156, 17155, 17153, 17152, 17151, 17150, 17149, 17148, 17147, 17146, 17145, 17144, 17143, 17142, 17141, 17140, 17139, 17138, 17137, 17136, 17135, 17134, 17132, 17131, 17130, 17129, 17128, 17127, 17126, 17125, 17124, 17123, 17122, 17121, 17120, 17119, 17118, 17117, 17116, 17115, 17114, 17113, 17112, 17111, 17110, 17109, 17108, 17107, 17106, 17105, 17104, 17103, 17102, 17101, 17100, 17099, 17098, 17097, 17096, 17095, 17093, 17092, 17091, 17090, 17089, 17088, 17087, 17086, 17085, 17084, 17083, 17082, 17081, 17080, 17079, 17078, 17076, 17075, 17074, 17073, 17070, 17069, 17068, 17067, 17065, 17064, 17063, 17062, 17061, 17060, 17059, 17058, 17057, 17056, 17055, 17054, 17053, 17052, 17051, 17050, 17049, 17048, 17047, 17046, 17045, 17044, 17043, 17042, 17041, 17040, 17039, 17038, 17037, 17036, 17035, 17034, 17033, 17032, 17031, 17030, 17029, 17028, 17027, 17026, 17025, 17024, 17023, 17022, 17021, 17020, 17019, 17018, 17017, 17016, 17015, 17014))
Run Time: 0.009740
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: 5707, 0, 1716195996, {"thread-46203":["thread",46203],"thread-17227":["thread",17227],"thread-17226":["thread",17226],"thread-17225":["thread",17225],"thread-17224":["thread",17224],"thread-17223":["thread",17223],"thread-17222":["thread",17222],"thread-17221":["thread",17221],"thread-17220":["thread",17220],"thread-17219":["thread",17219],"thread-17218":["thread",17218],"thread-17217":["thread",17217],"thread-17215":["thread",17215],"thread-17214":["thread",17214],"thread-17213":["thread",17213],"thread-17212":["thread",17212],"thread-17211":["thread",17211],"thread-17210":["thread",17210],"thread-17209":["thread",17209],"thread-17208":["thread",17208],"thread-17207":["thread",17207],"thread-17205":["thread",17205],"thread-17204":["thread",17204],"thread-17202":["thread",17202],"thread-17201":["thread",17201],"thread-17200":["thread",17200],"thread-17199":["thread",17199],"thread-17198":["thread",17198],"thread-17197":["thread",17197],"thread-17196":["thread",17196],"thread-17193":["thread",17193],"thread-17192":["thread",17192],"thread-17191":["thread",17191],"thread-17190":["thread",17190],"thread-17189":["thread",17189],"thread-17188":["thread",17188],"thread-17187":["thread",17187],"thread-17186":["thread",17186],"thread-17184":["thread",17184],"thread-17183":["thread",17183],"thread-17182":["thread",17182],"thread-17180":["thread",17180],"thread-17178":["thread",17178],"thread-17177":["thread",17177],"thread-17176":["thread",17176],"thread-17175":["thread",17175],"thread-17174":["thread",17174],"thread-17173":["thread",17173],"thread-17172":["thread",17172],"thread-17171":["thread",17171],"thread-17170":["thread",17170],"thread-17169":["thread",17169],"thread-17168":["thread",17168],"thread-17167":["thread",17167],"thread-17166":["thread",17166],"thread-17165":["thread",17165],"thread-17164":["thread",17164],"thread-17163":["thread",17163],"thread-17162":["thread",17162],"thread-17161":["thread",17161],"thread-17160":["thread",17160],"thread-17159":["thread",17159],"thread-17158":["thread",17158],"thread-17157":["thread",17157],"thread-17156":["thread",17156],"thread-17155":["thread",17155],"thread-17153":["thread",17153],"thread-17152":["thread",17152],"thread-17151":["thread",17151],"thread-17150":["thread",17150],"thread-17149":["thread",17149],"thread-17148":["thread",17148],"thread-17147":["thread",17147],"thread-17146":["thread",17146],"thread-17145":["thread",17145],"thread-17144":["thread",17144],"thread-17143":["thread",17143],"thread-17142":["thread",17142],"thread-17141":["thread",17141],"thread-17140":["thread",17140],"thread-17139":["thread",17139],"thread-17138":["thread",17138],"thread-17137":["thread",17137],"thread-17136":["thread",17136],"thread-17135":["thread",17135],"thread-17134":["thread",17134],"thread-17132":["thread",17132],"thread-17131":["thread",17131],"thread-17130":["thread",17130],"thread-17129":["thread",17129],"thread-17128":["thread",17128],"thread-17127":["thread",17127],"thread-17126":["thread",17126],"thread-17125":["thread",17125],"thread-17124":["thread",17124],"thread-17123":["thread",17123],"thread-17122":["thread",17122],"thread-17121":["thread",17121],"thread-17120":["thread",17120],"thread-17119":["thread",17119],"thread-17118":["thread",17118],"thread-17117":["thread",17117],"thread-17116":["thread",17116],"thread-17115":["thread",17115],"thread-17114":["thread",17114],"thread-17113":["thread",17113],"thread-17112":["thread",17112],"thread-17111":["thread",17111],"thread-17110":["thread",17110],"thread-17109":["thread",17109],"thread-17108":["thread",17108],"thread-17107":["thread",17107],"thread-17106":["thread",17106],"thread-17105":["thread",17105],"thread-17104":["thread",17104],"thread-17103":["thread",17103],"thread-17102":["thread",17102],"thread-17101":["thread",17101],"thread-17100":["thread",17100],"thread-17099":["thread",17099],"thread-17098":["thread",17098],"thread-17097":["thread",17097],"thread-17096":["thread",17096],"thread-17095":["thread",17095],"thread-17093":["thread",17093],"thread-17092":["thread",17092],"thread-17091":["thread",17091],"thread-17090":["thread",17090],"thread-17089":["thread",17089],"thread-17088":["thread",17088],"thread-17087":["thread",17087],"thread-17086":["thread",17086],"thread-17085":["thread",17085],"thread-17084":["thread",17084],"thread-17083":["thread",17083],"thread-17082":["thread",17082],"thread-17081":["thread",17081],"thread-17080":["thread",17080],"thread-17079":["thread",17079],"thread-17078":["thread",17078],"thread-17076":["thread",17076],"thread-17075":["thread",17075],"thread-17074":["thread",17074],"thread-17073":["thread",17073],"thread-17070":["thread",17070],"thread-17069":["thread",17069],"thread-17068":["thread",17068],"thread-17067":["thread",17067],"thread-17065":["thread",17065],"thread-17064":["thread",17064],"thread-17063":["thread",17063],"thread-17062":["thread",17062],"thread-17061":["thread",17061],"thread-17060":["thread",17060],"thread-17059":["thread",17059],"thread-17058":["thread",17058],"thread-17057":["thread",17057],"thread-17056":["thread",17056],"thread-17055":["thread",17055],"thread-17054":["thread",17054],"thread-17053":["thread",17053],"thread-17052":["thread",17052],"thread-17051":["thread",17051],"thread-17050":["thread",17050],"thread-17049":["thread",17049],"thread-17048":["thread",17048],"thread-17047":["thread",17047],"thread-17046":["thread",17046],"thread-17045":["thread",17045],"thread-17044":["thread",17044],"thread-17043":["thread",17043],"thread-17042":["thread",17042],"thread-17041":["thread",17041],"thread-17040":["thread",17040],"thread-17039":["thread",17039],"thread-17038":["thread",17038],"thread-17037":["thread",17037],"thread-17036":["thread",17036],"thread-17035":["thread",17035],"thread-17034":["thread",17034],"thread-17033":["thread",17033],"thread-17032":["thread",17032],"thread-17031":["thread",17031],"thread-17030":["thread",17030],"thread-17029":["thread",17029],"thread-17028":["thread",17028],"thread-17027":["thread",17027],"thread-17026":["thread",17026],"thread-17025":["thread",17025],"thread-17024":["thread",17024],"thread-17023":["thread",17023],"thread-17022":["thread",17022],"thread-17021":["thread",17021],"thread-17020":["thread",17020],"thread-17019":["thread",17019],"thread-17018":["thread",17018],"thread-17017":["thread",17017],"thread-17016":["thread",17016],"thread-17015":["thread",17015],"thread-17014":["thread",17014]}, , 1716192396
Run Time: 0.000635
- 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