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 (103656, 103389, 101976, 101773, 100866, 100541, 100458, 99437, 99421, 98380, 98122, 97917, 97676, 97081, 96947, 96899, 96846, 96844, 96822, 96803, 96763, 96639, 96519, 96302, 96244, 96000, 95984, 95899, 95727, 95686, 95587, 95435, 95310, 94914, 94664, 94648, 94055, 94038, 93959, 93621, 93567, 93467, 93341, 93324, 92967, 92881, 92868, 92823, 92813, 92245, 92151, 92125, 92104, 91960, 91952, 91934, 91848, 91696, 91507, 92273, 91447, 91441, 89939, 89827, 89721, 89702, 89681, 89953, 89566, 89528, 89452, 89447, 89423, 89386, 89341, 88905, 88790, 88788, 88774, 88700, 88590, 88287, 88255, 88250, 88194, 88184, 88161, 88148, 88136, 88022, 87993, 87973, 87939, 87926, 87737, 87720, 87618, 87500, 86961, 86891, 86781, 86716, 86492, 86379, 85380, 85081, 85039, 84523, 83820, 83730, 83709, 83505, 82785, 82309, 82056, 81938, 80814, 80638, 80554, 80437, 80051, 79873, 79225, 77291, 77131, 77035, 76706, 76482, 76392, 76369, 76322, 76303, 76296, 76290, 76251, 76097, 76077, 76007, 75914, 75898, 75683, 75664, 75563, 75507, 75414, 75409, 75398, 75366, 75315, 75259, 75232, 75064, 74863, 74828, 74738, 74717, 74622, 74551, 74515, 74487, 74425, 74424, 74372, 74141, 74097, 73987, 73892, 73821, 73648, 73541, 73498, 73487, 72922, 72909, 72667, 72393, 72384, 72332, 68277, 68169, 67047, 25727, 72234, 72230, 72229, 72224, 72209, 62449, 61849, 72143, 72112, 71514, 71518, 71532, 71662, 71647, 71650, 71664, 71717, 71716, 71672, 71675, 71710, 71827, 71891, 71828, 71888, 71904, 71906, 71937, 71944, 71917, 71924, 71943, 71942, 71856, 71946, 71953, 71952, 71998, 72005, 72013, 71875, 72050, 72046, 71916, 72006, 59447, 71663, 71648, 71736, 72049, 72065, 71889, 72017, 72048, 72047, 72036, 72084, 72100, 71945, 71947, 58799, 58510, 57742, 55678, 53158, 52695, 52461, 51278, 50566, 50428, 50239, 49513, 49315, 48438, 47116, 46385, 45882, 44933, 44845, 44426, 44392, 43651, 43451, 42889, 42614, 41760, 41745, 41396, 41047, 41021, 40920, 40785, 40777, 40645, 40611, 39194, 39120, 38133, 36588, 36324, 36163, 36161, 34549, 33565, 33249, 32551, 31782, 31142, 30113, 29996, 29901, 29450, 28709, 27850, 27446, 26165, 26041, 25282, 24689, 24591, 23753, 23298, 23256, 21899, 21832, 21729, 21410, 21176, 21118, 21001, 20926, 20527, 19796, 19617, 18441, 18035, 17553, 17514, 17504, 17197, 16990, 16977, 16691, 16613, 16262, 14664, 13126, 12786, 12708, 11986, 11950, 11016, 10898, 10895, 10453, 10298, 9416, 9312, 9018, 8772, 8574, 8373, 8330, 8327, 8295, 7610, 7442, 7271, 7119, 6751, 6423, 6422, 6042, 5980, 5527, 5383, 5333, 5233, 11224, 3973, 3872, 3870, 3825, 3379, 3361, 3332, 3318, 3030, 2313, 2266, 2264, 2054, 1976, 11177, 1693, 1618, 1598, 1507, 1458, 1389, 1387, 1369, 1296, 1292, 1248, 1170, 1137, 1041, 1013, 1011, 959, 796, 750, 747, 710, 652, 631, 587, 577, 576, 573, 536, 452, 440, 346, 270, 269, 222, 185))
Run Time: 0.005459
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 411 | 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: 703, 0, 1714193934, {"thread-103656":["thread",103656],"thread-101976":["thread",101976],"thread-101773":["thread",101773],"thread-100866":["thread",100866],"thread-100541":["thread",100541],"thread-100458":["thread",100458],"thread-99437":["thread",99437],"thread-99421":["thread",99421],"thread-98380":["thread",98380],"thread-98122":["thread",98122],"thread-97917":["thread",97917],"thread-97676":["thread",97676],"thread-97081":["thread",97081],"thread-96947":["thread",96947],"thread-96899":["thread",96899],"thread-96846":["thread",96846],"thread-96844":["thread",96844],"thread-96822":["thread",96822],"thread-96803":["thread",96803],"thread-96763":["thread",96763],"thread-96639":["thread",96639],"thread-96519":["thread",96519],"thread-96302":["thread",96302],"thread-96244":["thread",96244],"thread-96000":["thread",96000],"thread-95984":["thread",95984],"thread-95899":["thread",95899],"thread-95727":["thread",95727],"thread-95686":["thread",95686],"thread-95587":["thread",95587],"thread-95435":["thread",95435],"thread-95310":["thread",95310],"thread-94914":["thread",94914],"thread-94664":["thread",94664],"thread-94648":["thread",94648],"thread-94055":["thread",94055],"thread-94038":["thread",94038],"thread-93959":["thread",93959],"thread-93621":["thread",93621],"thread-93567":["thread",93567],"thread-93467":["thread",93467],"thread-93341":["thread",93341],"thread-93324":["thread",93324],"thread-92967":["thread",92967],"thread-92881":["thread",92881],"thread-92868":["thread",92868],"thread-92823":["thread",92823],"thread-92813":["thread",92813],"thread-92245":["thread",92245],"thread-92151":["thread",92151],"thread-92104":["thread",92104],"thread-91960":["thread",91960],"thread-91952":["thread",91952],"thread-91934":["thread",91934],"thread-91848":["thread",91848],"thread-91696":["thread",91696],"thread-91507":["thread",91507],"thread-92273":["thread",92273],"thread-91447":["thread",91447],"thread-91441":["thread",91441],"thread-89939":["thread",89939],"thread-89827":["thread",89827],"thread-89721":["thread",89721],"thread-89702":["thread",89702],"thread-89681":["thread",89681],"thread-89953":["thread",89953],"thread-89566":["thread",89566],"thread-89528":["thread",89528],"thread-89452":["thread",89452],"thread-89447":["thread",89447],"thread-89423":["thread",89423],"thread-89386":["thread",89386],"thread-89341":["thread",89341],"thread-88905":["thread",88905],"thread-88790":["thread",88790],"thread-88788":["thread",88788],"thread-88774":["thread",88774],"thread-88700":["thread",88700],"thread-88590":["thread",88590],"thread-88287":["thread",88287],"thread-88255":["thread",88255],"thread-88250":["thread",88250],"thread-88194":["thread",88194],"thread-88184":["thread",88184],"thread-88161":["thread",88161],"thread-88148":["thread",88148],"thread-88136":["thread",88136],"thread-88022":["thread",88022],"thread-87993":["thread",87993],"thread-87973":["thread",87973],"thread-87939":["thread",87939],"thread-87926":["thread",87926],"thread-87737":["thread",87737],"thread-87720":["thread",87720],"thread-87618":["thread",87618],"thread-87500":["thread",87500],"thread-86961":["thread",86961],"thread-86891":["thread",86891],"thread-86781":["thread",86781],"thread-86716":["thread",86716],"thread-86492":["thread",86492],"thread-86379":["thread",86379],"thread-85380":["thread",85380],"thread-85081":["thread",85081],"thread-85039":["thread",85039],"thread-84523":["thread",84523],"thread-83820":["thread",83820],"thread-83730":["thread",83730],"thread-83709":["thread",83709],"thread-83505":["thread",83505],"thread-82785":["thread",82785],"thread-82309":["thread",82309],"thread-82056":["thread",82056],"thread-81938":["thread",81938],"thread-80814":["thread",80814],"thread-80638":["thread",80638],"thread-80554":["thread",80554],"thread-80437":["thread",80437],"thread-80051":["thread",80051],"thread-79873":["thread",79873],"thread-79225":["thread",79225],"thread-77291":["thread",77291],"thread-77131":["thread",77131],"thread-77035":["thread",77035],"thread-76706":["thread",76706],"thread-76482":["thread",76482],"thread-76392":["thread",76392],"thread-76369":["thread",76369],"thread-76322":["thread",76322],"thread-76303":["thread",76303],"thread-76296":["thread",76296],"thread-76290":["thread",76290],"thread-76251":["thread",76251],"thread-76097":["thread",76097],"thread-76077":["thread",76077],"thread-76007":["thread",76007],"thread-75914":["thread",75914],"thread-75898":["thread",75898],"thread-75683":["thread",75683],"thread-75664":["thread",75664],"thread-75563":["thread",75563],"thread-75507":["thread",75507],"thread-75414":["thread",75414],"thread-75409":["thread",75409],"thread-75398":["thread",75398],"thread-75366":["thread",75366],"thread-75315":["thread",75315],"thread-75259":["thread",75259],"thread-75232":["thread",75232],"thread-75064":["thread",75064],"thread-74863":["thread",74863],"thread-74828":["thread",74828],"thread-74738":["thread",74738],"thread-74717":["thread",74717],"thread-74622":["thread",74622],"thread-74551":["thread",74551],"thread-74515":["thread",74515],"thread-74487":["thread",74487],"thread-74425":["thread",74425],"thread-74424":["thread",74424],"thread-74372":["thread",74372],"thread-74141":["thread",74141],"thread-74097":["thread",74097],"thread-73987":["thread",73987],"thread-73892":["thread",73892],"thread-73821":["thread",73821],"thread-73648":["thread",73648],"thread-73541":["thread",73541],"thread-73498":["thread",73498],"thread-73487":["thread",73487],"thread-72922":["thread",72922],"thread-72909":["thread",72909],"thread-72667":["thread",72667],"thread-72393":["thread",72393],"thread-72384":["thread",72384],"thread-72332":["thread",72332],"thread-68277":["thread",68277],"thread-68169":["thread",68169],"thread-67047":["thread",67047],"thread-25727":["thread",25727],"thread-72234":["thread",72234],"thread-72230":["thread",72230],"thread-72229":["thread",72229],"thread-72224":["thread",72224],"thread-72209":["thread",72209],"thread-62449":["thread",62449],"thread-61849":["thread",61849],"thread-72143":["thread",72143],"thread-72112":["thread",72112],"thread-71514":["thread",71514],"thread-71518":["thread",71518],"thread-71532":["thread",71532],"thread-71662":["thread",71662],"thread-71647":["thread",71647],"thread-71650":["thread",71650],"thread-71664":["thread",71664],"thread-71717":["thread",71717],"thread-71716":["thread",71716],"thread-71672":["thread",71672],"thread-71675":["thread",71675],"thread-71710":["thread",71710],"thread-71827":["thread",71827],"thread-71891":["thread",71891],"thread-71828":["thread",71828],"thread-71888":["thread",71888],"thread-71904":["thread",71904],"thread-71906":["thread",71906],"thread-71937":["thread",71937],"thread-71944":["thread",71944],"thread-71917":["thread",71917],"thread-71924":["thread",71924],"thread-71943":["thread",71943],"thread-71942":["thread",71942],"thread-71856":["thread",71856],"thread-71946":["thread",71946],"thread-71953":["thread",71953],"thread-71952":["thread",71952],"thread-71998":["thread",71998],"thread-72005":["thread",72005],"thread-72013":["thread",72013],"thread-71875":["thread",71875],"thread-72050":["thread",72050],"thread-72046":["thread",72046],"thread-71916":["thread",71916],"thread-72006":["thread",72006],"thread-59447":["thread",59447],"thread-71663":["thread",71663],"thread-71648":["thread",71648],"thread-71736":["thread",71736],"thread-72049":["thread",72049],"thread-72065":["thread",72065],"thread-71889":["thread",71889],"thread-72017":["thread",72017],"thread-72048":["thread",72048],"thread-72047":["thread",72047],"thread-72036":["thread",72036],"thread-72084":["thread",72084],"thread-72100":["thread",72100],"thread-71945":["thread",71945],"thread-71947":["thread",71947],"thread-58799":["thread",58799],"thread-58510":["thread",58510],"thread-57742":["thread",57742],"thread-55678":["thread",55678],"thread-53158":["thread",53158],"thread-52695":["thread",52695],"thread-52461":["thread",52461],"thread-51278":["thread",51278],"thread-50566":["thread",50566],"thread-50428":["thread",50428],"thread-50239":["thread",50239],"thread-49513":["thread",49513],"thread-49315":["thread",49315],"thread-48438":["thread",48438],"thread-47116":["thread",47116],"thread-46385":["thread",46385],"thread-45882":["thread",45882],"thread-44933":["thread",44933],"thread-44845":["thread",44845],"thread-44426":["thread",44426],"thread-44392":["thread",44392],"thread-43651":["thread",43651],"thread-43451":["thread",43451],"thread-42889":["thread",42889],"thread-42614":["thread",42614],"thread-41760":["thread",41760],"thread-41745":["thread",41745],"thread-41396":["thread",41396],"thread-41047":["thread",41047],"thread-41021":["thread",41021],"thread-40920":["thread",40920],"thread-40785":["thread",40785],"thread-40777":["thread",40777],"thread-40645":["thread",40645],"thread-40611":["thread",40611],"thread-39194":["thread",39194],"thread-39120":["thread",39120],"thread-38133":["thread",38133],"thread-36588":["thread",36588],"thread-36324":["thread",36324],"thread-36163":["thread",36163],"thread-36161":["thread",36161],"thread-34549":["thread",34549],"thread-33565":["thread",33565],"thread-33249":["thread",33249],"thread-32551":["thread",32551],"thread-31782":["thread",31782],"thread-31142":["thread",31142],"thread-30113":["thread",30113],"thread-29996":["thread",29996],"thread-29901":["thread",29901],"thread-29450":["thread",29450],"thread-28709":["thread",28709],"thread-27850":["thread",27850],"thread-27446":["thread",27446],"thread-26165":["thread",26165],"thread-26041":["thread",26041],"thread-25282":["thread",25282],"thread-24689":["thread",24689],"thread-24591":["thread",24591],"thread-23753":["thread",23753],"thread-23298":["thread",23298],"thread-23256":["thread",23256],"thread-21899":["thread",21899],"thread-21832":["thread",21832],"thread-21729":["thread",21729],"thread-21410":["thread",21410],"thread-21176":["thread",21176],"thread-21118":["thread",21118],"thread-21001":["thread",21001],"thread-20926":["thread",20926],"thread-20527":["thread",20527],"thread-19796":["thread",19796],"thread-19617":["thread",19617],"thread-18441":["thread",18441],"thread-18035":["thread",18035],"thread-17553":["thread",17553],"thread-17514":["thread",17514],"thread-17504":["thread",17504],"thread-17197":["thread",17197],"thread-16990":["thread",16990],"thread-16977":["thread",16977],"thread-16691":["thread",16691],"thread-16613":["thread",16613],"thread-16262":["thread",16262],"thread-14664":["thread",14664],"thread-13126":["thread",13126],"thread-12786":["thread",12786],"thread-12708":["thread",12708],"thread-11986":["thread",11986],"thread-11950":["thread",11950],"thread-11016":["thread",11016],"thread-10898":["thread",10898],"thread-10895":["thread",10895],"thread-10453":["thread",10453],"thread-10298":["thread",10298],"thread-9416":["thread",9416],"thread-9312":["thread",9312],"thread-9018":["thread",9018],"thread-8772":["thread",8772],"thread-8574":["thread",8574],"thread-8373":["thread",8373],"thread-8330":["thread",8330],"thread-8327":["thread",8327],"thread-8295":["thread",8295],"thread-7610":["thread",7610],"thread-7442":["thread",7442],"thread-7271":["thread",7271],"thread-7119":["thread",7119],"thread-6751":["thread",6751],"thread-6423":["thread",6423],"thread-6422":["thread",6422],"thread-6042":["thread",6042],"thread-5980":["thread",5980],"thread-5527":["thread",5527],"thread-5383":["thread",5383],"thread-5333":["thread",5333],"thread-5233":["thread",5233],"thread-11224":["thread",11224],"thread-3973":["thread",3973],"thread-3872":["thread",3872],"thread-3870":["thread",3870],"thread-3825":["thread",3825],"thread-3379":["thread",3379],"thread-3361":["thread",3361],"thread-3332":["thread",3332],"thread-3318":["thread",3318],"thread-3030":["thread",3030],"thread-2313":["thread",2313],"thread-2266":["thread",2266],"thread-2264":["thread",2264],"thread-2054":["thread",2054],"thread-1976":["thread",1976],"thread-11177":["thread",11177],"thread-1693":["thread",1693],"thread-1618":["thread",1618],"thread-1598":["thread",1598],"thread-1507":["thread",1507],"thread-1458":["thread",1458],"thread-1389":["thread",1389],"thread-1387":["thread",1387],"thread-1369":["thread",1369],"thread-1296":["thread",1296],"thread-1292":["thread",1292],"thread-1248":["thread",1248],"thread-1170":["thread",1170],"thread-1137":["thread",1137],"thread-1041":["thread",1041],"thread-1013":["thread",1013],"thread-1011":["thread",1011],"thread-959":["thread",959],"thread-796":["thread",796],"thread-750":["thread",750],"thread-747":["thread",747],"thread-710":["thread",710],"thread-652":["thread",652],"thread-631":["thread",631],"thread-587":["thread",587],"thread-577":["thread",577],"thread-576":["thread",576],"thread-573":["thread",573],"thread-536":["thread",536],"thread-452":["thread",452],"thread-440":["thread",440],"thread-346":["thread",346],"thread-270":["thread",270],"thread-269":["thread",269],"thread-222":["thread",222],"thread-185":["thread",185]}, NULL, 1714190334
Run Time: 0.000186
- 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