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 (37625, 37624, 37623, 37622, 37621, 37620, 37619, 37618, 37617, 37616, 37615, 37614, 37613, 37612, 37611, 37610, 37609, 37608, 37607, 37606, 37605, 37604, 37603, 37602, 37601, 37600, 37599, 37598, 37597, 37596, 37595, 37594, 37593, 37592, 37591, 37590, 37589, 37588, 37587, 37586, 37585, 37584, 37583, 37582, 37581, 37580, 37579, 37578, 37577, 37576, 37575, 37574, 37573, 37572, 37571, 37570, 37569, 37568, 37567, 37565, 37564, 37563, 37562, 37561, 37560, 37559, 37558, 37557, 37556, 37555, 37554, 37553, 37552, 37551, 37550, 37549, 37548, 37547, 37546, 37545, 37544, 37543, 37542, 37541, 37540, 37539, 37538, 37537, 37536, 37535, 37534, 37533, 37532, 37531, 37530, 37529, 37528, 37527, 37526, 37525, 37524, 37523, 37522, 37521, 37520, 37519, 37518, 37517, 37516, 37515, 37514, 37513, 37512, 37511, 37510, 37509, 37508, 37507, 37506, 37505, 37504, 37503, 37502, 37501, 37500, 37499, 37498, 37497, 37496, 37495, 37494, 37493, 37492, 37491, 37490, 37489, 37488, 37487, 37486, 37485, 37484, 37483, 37482, 37481, 37480, 37479, 37478, 37477, 37476, 37475, 37474, 37473, 37472, 37471, 37470, 37469, 37468, 37467, 37466, 37465, 37464, 37463, 37462, 37461, 37460, 37459, 37458, 37457, 37456, 37455, 37454, 37453, 37452, 37451, 37450, 37449, 37448, 37447, 37446, 37445, 37444, 37443, 37442, 37441, 37440, 37439, 37438, 37437, 37436, 37435, 37434, 37433, 37432, 37431, 37430, 37429, 37428, 37427, 37426, 37425))
Run Time: 0.018677
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: 5750, 0, 1715638654, {"thread-37625":["thread",37625],"thread-37624":["thread",37624],"thread-37623":["thread",37623],"thread-37622":["thread",37622],"thread-37621":["thread",37621],"thread-37620":["thread",37620],"thread-37619":["thread",37619],"thread-37618":["thread",37618],"thread-37617":["thread",37617],"thread-37616":["thread",37616],"thread-37615":["thread",37615],"thread-37614":["thread",37614],"thread-37613":["thread",37613],"thread-37612":["thread",37612],"thread-37611":["thread",37611],"thread-37610":["thread",37610],"thread-37609":["thread",37609],"thread-37608":["thread",37608],"thread-37607":["thread",37607],"thread-37606":["thread",37606],"thread-37605":["thread",37605],"thread-37604":["thread",37604],"thread-37603":["thread",37603],"thread-37602":["thread",37602],"thread-37601":["thread",37601],"thread-37600":["thread",37600],"thread-37599":["thread",37599],"thread-37598":["thread",37598],"thread-37597":["thread",37597],"thread-37596":["thread",37596],"thread-37595":["thread",37595],"thread-37594":["thread",37594],"thread-37593":["thread",37593],"thread-37592":["thread",37592],"thread-37591":["thread",37591],"thread-37590":["thread",37590],"thread-37589":["thread",37589],"thread-37588":["thread",37588],"thread-37587":["thread",37587],"thread-37586":["thread",37586],"thread-37585":["thread",37585],"thread-37584":["thread",37584],"thread-37583":["thread",37583],"thread-37582":["thread",37582],"thread-37581":["thread",37581],"thread-37580":["thread",37580],"thread-37579":["thread",37579],"thread-37578":["thread",37578],"thread-37577":["thread",37577],"thread-37576":["thread",37576],"thread-37575":["thread",37575],"thread-37574":["thread",37574],"thread-37573":["thread",37573],"thread-37572":["thread",37572],"thread-37571":["thread",37571],"thread-37570":["thread",37570],"thread-37569":["thread",37569],"thread-37568":["thread",37568],"thread-37567":["thread",37567],"thread-37565":["thread",37565],"thread-37564":["thread",37564],"thread-37563":["thread",37563],"thread-37562":["thread",37562],"thread-37561":["thread",37561],"thread-37560":["thread",37560],"thread-37559":["thread",37559],"thread-37558":["thread",37558],"thread-37557":["thread",37557],"thread-37556":["thread",37556],"thread-37555":["thread",37555],"thread-37554":["thread",37554],"thread-37553":["thread",37553],"thread-37552":["thread",37552],"thread-37551":["thread",37551],"thread-37550":["thread",37550],"thread-37549":["thread",37549],"thread-37548":["thread",37548],"thread-37547":["thread",37547],"thread-37546":["thread",37546],"thread-37545":["thread",37545],"thread-37544":["thread",37544],"thread-37543":["thread",37543],"thread-37542":["thread",37542],"thread-37541":["thread",37541],"thread-37540":["thread",37540],"thread-37539":["thread",37539],"thread-37538":["thread",37538],"thread-37537":["thread",37537],"thread-37536":["thread",37536],"thread-37535":["thread",37535],"thread-37534":["thread",37534],"thread-37533":["thread",37533],"thread-37532":["thread",37532],"thread-37531":["thread",37531],"thread-37530":["thread",37530],"thread-37529":["thread",37529],"thread-37528":["thread",37528],"thread-37527":["thread",37527],"thread-37526":["thread",37526],"thread-37525":["thread",37525],"thread-37524":["thread",37524],"thread-37523":["thread",37523],"thread-37522":["thread",37522],"thread-37521":["thread",37521],"thread-37520":["thread",37520],"thread-37519":["thread",37519],"thread-37518":["thread",37518],"thread-37517":["thread",37517],"thread-37516":["thread",37516],"thread-37515":["thread",37515],"thread-37514":["thread",37514],"thread-37513":["thread",37513],"thread-37512":["thread",37512],"thread-37511":["thread",37511],"thread-37510":["thread",37510],"thread-37509":["thread",37509],"thread-37508":["thread",37508],"thread-37507":["thread",37507],"thread-37506":["thread",37506],"thread-37505":["thread",37505],"thread-37504":["thread",37504],"thread-37503":["thread",37503],"thread-37502":["thread",37502],"thread-37501":["thread",37501],"thread-37500":["thread",37500],"thread-37499":["thread",37499],"thread-37498":["thread",37498],"thread-37497":["thread",37497],"thread-37496":["thread",37496],"thread-37495":["thread",37495],"thread-37494":["thread",37494],"thread-37493":["thread",37493],"thread-37492":["thread",37492],"thread-37491":["thread",37491],"thread-37490":["thread",37490],"thread-37489":["thread",37489],"thread-37488":["thread",37488],"thread-37487":["thread",37487],"thread-37486":["thread",37486],"thread-37485":["thread",37485],"thread-37484":["thread",37484],"thread-37483":["thread",37483],"thread-37482":["thread",37482],"thread-37481":["thread",37481],"thread-37480":["thread",37480],"thread-37479":["thread",37479],"thread-37478":["thread",37478],"thread-37477":["thread",37477],"thread-37476":["thread",37476],"thread-37475":["thread",37475],"thread-37474":["thread",37474],"thread-37473":["thread",37473],"thread-37472":["thread",37472],"thread-37471":["thread",37471],"thread-37470":["thread",37470],"thread-37469":["thread",37469],"thread-37468":["thread",37468],"thread-37467":["thread",37467],"thread-37466":["thread",37466],"thread-37465":["thread",37465],"thread-37464":["thread",37464],"thread-37463":["thread",37463],"thread-37462":["thread",37462],"thread-37461":["thread",37461],"thread-37460":["thread",37460],"thread-37459":["thread",37459],"thread-37458":["thread",37458],"thread-37457":["thread",37457],"thread-37456":["thread",37456],"thread-37455":["thread",37455],"thread-37454":["thread",37454],"thread-37453":["thread",37453],"thread-37452":["thread",37452],"thread-37451":["thread",37451],"thread-37450":["thread",37450],"thread-37449":["thread",37449],"thread-37448":["thread",37448],"thread-37447":["thread",37447],"thread-37446":["thread",37446],"thread-37445":["thread",37445],"thread-37444":["thread",37444],"thread-37443":["thread",37443],"thread-37442":["thread",37442],"thread-37441":["thread",37441],"thread-37440":["thread",37440],"thread-37439":["thread",37439],"thread-37438":["thread",37438],"thread-37437":["thread",37437],"thread-37436":["thread",37436],"thread-37435":["thread",37435],"thread-37434":["thread",37434],"thread-37433":["thread",37433],"thread-37432":["thread",37432],"thread-37431":["thread",37431],"thread-37430":["thread",37430],"thread-37429":["thread",37429],"thread-37428":["thread",37428],"thread-37427":["thread",37427],"thread-37426":["thread",37426],"thread-37425":["thread",37425]}, , 1715635054
Run Time: 0.000665
- 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