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 (101412, 101154, 100558, 100513, 100034, 99161, 98711, 98634, 98119, 97931, 96863, 96570, 96284, 96191, 94935, 94923, 94835, 94655, 93197, 92743, 92544, 92487, 92486, 89894, 89777, 89389, 88838, 87211, 87200, 86900, 86254, 84384, 84186, 83920, 83655, 82299, 81868, 79038, 78995, 78824, 77033, 76915, 76896, 75674, 75498, 75181, 75107, 74971, 74180, 74127, 72720, 72651, 69321, 68849, 67997, 72290, 72255, 67047, 66744, 66630, 66143, 65875, 65842, 63173, 71658, 59550, 71995, 59037, 72073, 71935, 58663, 58403, 58357, 56968, 56925, 56771, 56653, 55117, 55042, 54884, 54741, 54574, 54173, 53182, 53140, 53025, 52114, 51548, 51306, 50756, 50019, 49037, 48176, 47559, 47116, 46631, 46427, 45723, 44582, 44493, 44133, 44019, 43170, 42614, 41877, 41332, 41255, 41250, 40808, 40685, 39368, 38839, 38795, 38278, 37705, 37629, 37315, 35840, 35722, 35642, 35646, 35311, 35233, 36064, 35035, 34846, 34668, 34440, 34008, 33713, 32586, 31842, 31526, 30793, 30206, 28780, 28709, 27012, 26811, 26734, 26115, 25720, 25277, 25004, 24900, 24755, 24734, 24685, 24604, 24365, 24364, 24282, 24068, 23660, 23496, 23490, 23428, 23401, 22043, 18929, 18046, 17346, 16985, 16392, 14529, 13098, 11821, 11185, 9826, 9637, 9252, 7973, 7368, 7285, 5438, 3318, 2266, 2262, 2095, 411))
Run Time: 0.002495
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 180 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | blutschwerter_forum.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,blutschwerter_forum.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 2870
- 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 138
- 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 2487
- 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: 1593, 0, 1714824223, {"thread-101412":["thread",101412],"thread-101154":["thread",101154],"thread-100558":["thread",100558],"thread-100513":["thread",100513],"thread-100034":["thread",100034],"thread-99161":["thread",99161],"thread-98711":["thread",98711],"thread-98634":["thread",98634],"thread-98119":["thread",98119],"thread-97931":["thread",97931],"thread-96863":["thread",96863],"thread-96570":["thread",96570],"thread-96284":["thread",96284],"thread-96191":["thread",96191],"thread-94935":["thread",94935],"thread-94923":["thread",94923],"thread-94835":["thread",94835],"thread-94655":["thread",94655],"thread-93197":["thread",93197],"thread-92743":["thread",92743],"thread-92544":["thread",92544],"thread-92487":["thread",92487],"thread-92486":["thread",92486],"thread-89894":["thread",89894],"thread-89777":["thread",89777],"thread-89389":["thread",89389],"thread-88838":["thread",88838],"thread-87211":["thread",87211],"thread-87200":["thread",87200],"thread-86900":["thread",86900],"thread-86254":["thread",86254],"thread-84384":["thread",84384],"thread-84186":["thread",84186],"thread-83920":["thread",83920],"thread-83655":["thread",83655],"thread-82299":["thread",82299],"thread-81868":["thread",81868],"thread-79038":["thread",79038],"thread-78995":["thread",78995],"thread-78824":["thread",78824],"thread-77033":["thread",77033],"thread-76915":["thread",76915],"thread-76896":["thread",76896],"thread-75674":["thread",75674],"thread-75498":["thread",75498],"thread-75181":["thread",75181],"thread-75107":["thread",75107],"thread-74971":["thread",74971],"thread-74180":["thread",74180],"thread-74127":["thread",74127],"thread-72720":["thread",72720],"thread-72651":["thread",72651],"thread-69321":["thread",69321],"thread-68849":["thread",68849],"thread-67997":["thread",67997],"thread-72290":["thread",72290],"thread-72255":["thread",72255],"thread-67047":["thread",67047],"thread-66744":["thread",66744],"thread-66630":["thread",66630],"thread-66143":["thread",66143],"thread-65875":["thread",65875],"thread-65842":["thread",65842],"thread-63173":["thread",63173],"thread-71658":["thread",71658],"thread-59550":["thread",59550],"thread-71995":["thread",71995],"thread-59037":["thread",59037],"thread-72073":["thread",72073],"thread-71935":["thread",71935],"thread-58663":["thread",58663],"thread-58403":["thread",58403],"thread-58357":["thread",58357],"thread-56968":["thread",56968],"thread-56925":["thread",56925],"thread-56771":["thread",56771],"thread-56653":["thread",56653],"thread-55117":["thread",55117],"thread-55042":["thread",55042],"thread-54884":["thread",54884],"thread-54741":["thread",54741],"thread-54574":["thread",54574],"thread-54173":["thread",54173],"thread-53182":["thread",53182],"thread-53140":["thread",53140],"thread-53025":["thread",53025],"thread-52114":["thread",52114],"thread-51548":["thread",51548],"thread-51306":["thread",51306],"thread-50756":["thread",50756],"thread-50019":["thread",50019],"thread-49037":["thread",49037],"thread-48176":["thread",48176],"thread-47559":["thread",47559],"thread-47116":["thread",47116],"thread-46631":["thread",46631],"thread-46427":["thread",46427],"thread-45723":["thread",45723],"thread-44582":["thread",44582],"thread-44493":["thread",44493],"thread-44133":["thread",44133],"thread-44019":["thread",44019],"thread-43170":["thread",43170],"thread-42614":["thread",42614],"thread-41877":["thread",41877],"thread-41332":["thread",41332],"thread-41255":["thread",41255],"thread-41250":["thread",41250],"thread-40808":["thread",40808],"thread-40685":["thread",40685],"thread-39368":["thread",39368],"thread-38839":["thread",38839],"thread-38795":["thread",38795],"thread-38278":["thread",38278],"thread-37705":["thread",37705],"thread-37629":["thread",37629],"thread-37315":["thread",37315],"thread-35840":["thread",35840],"thread-35722":["thread",35722],"thread-35642":["thread",35642],"thread-35646":["thread",35646],"thread-35311":["thread",35311],"thread-35233":["thread",35233],"thread-36064":["thread",36064],"thread-35035":["thread",35035],"thread-34846":["thread",34846],"thread-34668":["thread",34668],"thread-34440":["thread",34440],"thread-34008":["thread",34008],"thread-33713":["thread",33713],"thread-32586":["thread",32586],"thread-31842":["thread",31842],"thread-31526":["thread",31526],"thread-30793":["thread",30793],"thread-30206":["thread",30206],"thread-28780":["thread",28780],"thread-28709":["thread",28709],"thread-27012":["thread",27012],"thread-26811":["thread",26811],"thread-26734":["thread",26734],"thread-26115":["thread",26115],"thread-25720":["thread",25720],"thread-25277":["thread",25277],"thread-25004":["thread",25004],"thread-24900":["thread",24900],"thread-24755":["thread",24755],"thread-24734":["thread",24734],"thread-24685":["thread",24685],"thread-24604":["thread",24604],"thread-24365":["thread",24365],"thread-24364":["thread",24364],"thread-24282":["thread",24282],"thread-24068":["thread",24068],"thread-23660":["thread",23660],"thread-23496":["thread",23496],"thread-23490":["thread",23490],"thread-23428":["thread",23428],"thread-23401":["thread",23401],"thread-22043":["thread",22043],"thread-18929":["thread",18929],"thread-18046":["thread",18046],"thread-17346":["thread",17346],"thread-16985":["thread",16985],"thread-16392":["thread",16392],"thread-14529":["thread",14529],"thread-13098":["thread",13098],"thread-11821":["thread",11821],"thread-11185":["thread",11185],"thread-9826":["thread",9826],"thread-9637":["thread",9637],"thread-9252":["thread",9252],"thread-7973":["thread",7973],"thread-7368":["thread",7368],"thread-7285":["thread",7285],"thread-5438":["thread",5438],"thread-3318":["thread",3318],"thread-2266":["thread",2266],"thread-2262":["thread",2262],"thread-2095":["thread",2095],"thread-411":["thread",411]}, NULL, 1714820623
Run Time: 0.000094
- 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 1526
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1258
- XF\Mvc\Entity\Entity->save() in src/XF/Pub/Controller/Tag.php at line 151
- 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 2487
- XF\App->run() in src/XF.php at line 524
- XF::runApp() in index.php at line 20