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 (26540, 26538, 26537, 26536, 26535, 26534, 26533, 26532, 26530, 26528, 26527, 26526, 26525, 26524, 26523, 26522, 26521, 26520, 26519, 26518, 26517, 26516, 26515, 26513, 26512, 26511, 26510, 26508, 26507, 26506, 26505, 26504, 26503, 26502, 26501, 26500, 26498, 26497, 26496, 26495, 26494, 26493, 26492, 26491, 26490, 26489, 26488, 26487, 26486, 26485, 26484, 26483, 26481, 26480, 26479, 26478, 26477, 26476, 26475, 26474, 26473, 26472, 26471, 26470, 26469, 26468, 26467, 26465, 26464, 26462, 26460, 26459, 26458, 26457, 26456, 26455, 26454, 26453, 26452, 26451, 26450, 26449, 26448, 26446, 26445, 26444, 26442, 26440, 26439, 26437, 26436, 26435, 26434, 26433, 26432, 26431, 26430, 26429, 26428, 26427, 26426, 26425, 26424, 26423, 26421, 26420, 26419, 26418, 26417, 26416, 26415, 26414, 26413, 26412, 26411, 26410, 26409, 26408, 26407, 26406, 26405, 26404, 26403, 26402, 26401, 26400, 26399, 26398, 26397, 26396, 26395, 26394, 26393, 26392, 26390, 26389, 26388, 26387, 26386, 26385, 26384, 26383, 26382, 26381, 26380, 26379, 26378, 26377, 26376, 26375, 26374, 26373, 26372, 26371, 26369, 26368, 26367, 26366, 26365, 26364, 26363, 26362, 26361, 26360, 26359, 26358, 26357, 26356, 26355, 26354, 26353, 26352, 26351, 26350, 26349, 26348, 26347, 26345, 26344, 26343, 26342, 26341, 26340, 26339, 26338, 26337, 26336, 26335, 26334, 26333, 26332, 26331, 26330, 26329, 26328, 26327, 26326, 26325, 26324, 26323))
Run Time: 0.014681
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: 1277, 0, 1715089834, {"thread-26540":["thread",26540],"thread-26538":["thread",26538],"thread-26537":["thread",26537],"thread-26536":["thread",26536],"thread-26535":["thread",26535],"thread-26534":["thread",26534],"thread-26533":["thread",26533],"thread-26532":["thread",26532],"thread-26530":["thread",26530],"thread-26528":["thread",26528],"thread-26527":["thread",26527],"thread-26526":["thread",26526],"thread-26525":["thread",26525],"thread-26524":["thread",26524],"thread-26523":["thread",26523],"thread-26522":["thread",26522],"thread-26521":["thread",26521],"thread-26520":["thread",26520],"thread-26519":["thread",26519],"thread-26518":["thread",26518],"thread-26517":["thread",26517],"thread-26516":["thread",26516],"thread-26515":["thread",26515],"thread-26513":["thread",26513],"thread-26512":["thread",26512],"thread-26511":["thread",26511],"thread-26510":["thread",26510],"thread-26508":["thread",26508],"thread-26507":["thread",26507],"thread-26506":["thread",26506],"thread-26505":["thread",26505],"thread-26504":["thread",26504],"thread-26503":["thread",26503],"thread-26502":["thread",26502],"thread-26501":["thread",26501],"thread-26500":["thread",26500],"thread-26498":["thread",26498],"thread-26497":["thread",26497],"thread-26496":["thread",26496],"thread-26495":["thread",26495],"thread-26494":["thread",26494],"thread-26493":["thread",26493],"thread-26492":["thread",26492],"thread-26491":["thread",26491],"thread-26490":["thread",26490],"thread-26489":["thread",26489],"thread-26488":["thread",26488],"thread-26487":["thread",26487],"thread-26486":["thread",26486],"thread-26485":["thread",26485],"thread-26484":["thread",26484],"thread-26483":["thread",26483],"thread-26481":["thread",26481],"thread-26480":["thread",26480],"thread-26479":["thread",26479],"thread-26478":["thread",26478],"thread-26477":["thread",26477],"thread-26476":["thread",26476],"thread-26475":["thread",26475],"thread-26474":["thread",26474],"thread-26473":["thread",26473],"thread-26472":["thread",26472],"thread-26471":["thread",26471],"thread-26470":["thread",26470],"thread-26469":["thread",26469],"thread-26468":["thread",26468],"thread-26467":["thread",26467],"thread-26465":["thread",26465],"thread-26464":["thread",26464],"thread-26462":["thread",26462],"thread-26460":["thread",26460],"thread-26459":["thread",26459],"thread-26458":["thread",26458],"thread-26457":["thread",26457],"thread-26456":["thread",26456],"thread-26455":["thread",26455],"thread-26454":["thread",26454],"thread-26453":["thread",26453],"thread-26452":["thread",26452],"thread-26451":["thread",26451],"thread-26450":["thread",26450],"thread-26449":["thread",26449],"thread-26448":["thread",26448],"thread-26446":["thread",26446],"thread-26445":["thread",26445],"thread-26444":["thread",26444],"thread-26442":["thread",26442],"thread-26440":["thread",26440],"thread-26439":["thread",26439],"thread-26437":["thread",26437],"thread-26436":["thread",26436],"thread-26435":["thread",26435],"thread-26434":["thread",26434],"thread-26433":["thread",26433],"thread-26432":["thread",26432],"thread-26431":["thread",26431],"thread-26430":["thread",26430],"thread-26429":["thread",26429],"thread-26428":["thread",26428],"thread-26427":["thread",26427],"thread-26426":["thread",26426],"thread-26425":["thread",26425],"thread-26424":["thread",26424],"thread-26423":["thread",26423],"thread-26421":["thread",26421],"thread-26420":["thread",26420],"thread-26419":["thread",26419],"thread-26418":["thread",26418],"thread-26417":["thread",26417],"thread-26416":["thread",26416],"thread-26415":["thread",26415],"thread-26414":["thread",26414],"thread-26413":["thread",26413],"thread-26412":["thread",26412],"thread-26411":["thread",26411],"thread-26410":["thread",26410],"thread-26409":["thread",26409],"thread-26408":["thread",26408],"thread-26407":["thread",26407],"thread-26406":["thread",26406],"thread-26405":["thread",26405],"thread-26404":["thread",26404],"thread-26403":["thread",26403],"thread-26402":["thread",26402],"thread-26401":["thread",26401],"thread-26400":["thread",26400],"thread-26399":["thread",26399],"thread-26398":["thread",26398],"thread-26397":["thread",26397],"thread-26396":["thread",26396],"thread-26395":["thread",26395],"thread-26394":["thread",26394],"thread-26393":["thread",26393],"thread-26392":["thread",26392],"thread-26390":["thread",26390],"thread-26389":["thread",26389],"thread-26388":["thread",26388],"thread-26387":["thread",26387],"thread-26386":["thread",26386],"thread-26385":["thread",26385],"thread-26384":["thread",26384],"thread-26383":["thread",26383],"thread-26382":["thread",26382],"thread-26381":["thread",26381],"thread-26380":["thread",26380],"thread-26379":["thread",26379],"thread-26378":["thread",26378],"thread-26377":["thread",26377],"thread-26376":["thread",26376],"thread-26375":["thread",26375],"thread-26374":["thread",26374],"thread-26373":["thread",26373],"thread-26372":["thread",26372],"thread-26371":["thread",26371],"thread-26369":["thread",26369],"thread-26368":["thread",26368],"thread-26367":["thread",26367],"thread-26366":["thread",26366],"thread-26365":["thread",26365],"thread-26364":["thread",26364],"thread-26363":["thread",26363],"thread-26362":["thread",26362],"thread-26361":["thread",26361],"thread-26360":["thread",26360],"thread-26359":["thread",26359],"thread-26358":["thread",26358],"thread-26357":["thread",26357],"thread-26356":["thread",26356],"thread-26355":["thread",26355],"thread-26354":["thread",26354],"thread-26353":["thread",26353],"thread-26352":["thread",26352],"thread-26351":["thread",26351],"thread-26350":["thread",26350],"thread-26349":["thread",26349],"thread-26348":["thread",26348],"thread-26347":["thread",26347],"thread-26345":["thread",26345],"thread-26344":["thread",26344],"thread-26343":["thread",26343],"thread-26342":["thread",26342],"thread-26341":["thread",26341],"thread-26340":["thread",26340],"thread-26339":["thread",26339],"thread-26338":["thread",26338],"thread-26337":["thread",26337],"thread-26336":["thread",26336],"thread-26335":["thread",26335],"thread-26334":["thread",26334],"thread-26333":["thread",26333],"thread-26332":["thread",26332],"thread-26331":["thread",26331],"thread-26330":["thread",26330],"thread-26329":["thread",26329],"thread-26328":["thread",26328],"thread-26327":["thread",26327],"thread-26326":["thread",26326],"thread-26325":["thread",26325],"thread-26324":["thread",26324],"thread-26323":["thread",26323]}, , 1715086234
Run Time: 0.000972
- 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