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 (35607, 35606, 35605, 35604, 35603, 35602, 35601, 35600, 35599, 35598, 35597, 35596, 35595, 35594, 35593, 35592, 35591, 35590, 35589, 35588, 35587, 35586, 35585, 35584, 35583, 35582, 35581, 35580, 35579, 35578, 35577, 35576, 35575, 35574, 35573, 35572, 35571, 35570, 35569, 35568, 35567, 35566, 35565, 35564, 35563, 35562, 35561, 35560, 35559, 35558, 35557, 35556, 35555, 35554, 35553, 35552, 35551, 35550, 35549, 35548, 35547, 35546, 35545, 35544, 35543, 35542, 35541, 35540, 35539, 35538, 35537, 35536, 35535, 35534, 35533, 35532, 35531, 35530, 35529, 35528, 35527, 35526, 35525, 35524, 35523, 35522, 35521, 35520, 35519, 35518, 35517, 35516, 35515, 35514, 35513, 35512, 35511, 35510, 35509, 35508, 35507, 35506, 35505, 35504, 35503, 35502, 35501, 35500, 35499, 35498, 35497, 35496, 35495, 35494, 35493, 35492, 35491, 35490, 35489, 35488, 35487, 35486, 35485, 35484, 35483, 35482, 35481, 35480, 35479, 35478, 35477, 35476, 35475, 35474, 35473, 35472, 35471, 35470, 35469, 35468, 35467, 35466, 35465, 35464, 35463, 35462, 35461, 35460, 35459, 35458, 35457, 35456, 35455, 35454, 35453, 35452, 35451, 35450, 35449, 35448, 35447, 35446, 35445, 35444, 35443, 35442, 35441, 35440, 35439, 35438, 35437, 35436, 35435, 35434, 35433, 35432, 35431, 35430, 35429, 35428, 35427, 35426, 35425, 35424, 35423, 35422, 35421, 35420, 35419, 35418, 35416, 35415, 35414, 35413, 35412, 35411, 35410, 35409, 35408, 35407))
Run Time: 0.012851
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: 5933, 0, 1715576378, {"thread-35607":["thread",35607],"thread-35606":["thread",35606],"thread-35605":["thread",35605],"thread-35604":["thread",35604],"thread-35603":["thread",35603],"thread-35602":["thread",35602],"thread-35601":["thread",35601],"thread-35600":["thread",35600],"thread-35599":["thread",35599],"thread-35598":["thread",35598],"thread-35597":["thread",35597],"thread-35596":["thread",35596],"thread-35595":["thread",35595],"thread-35594":["thread",35594],"thread-35593":["thread",35593],"thread-35592":["thread",35592],"thread-35591":["thread",35591],"thread-35590":["thread",35590],"thread-35589":["thread",35589],"thread-35588":["thread",35588],"thread-35587":["thread",35587],"thread-35586":["thread",35586],"thread-35585":["thread",35585],"thread-35584":["thread",35584],"thread-35583":["thread",35583],"thread-35582":["thread",35582],"thread-35581":["thread",35581],"thread-35580":["thread",35580],"thread-35579":["thread",35579],"thread-35578":["thread",35578],"thread-35577":["thread",35577],"thread-35576":["thread",35576],"thread-35575":["thread",35575],"thread-35574":["thread",35574],"thread-35573":["thread",35573],"thread-35572":["thread",35572],"thread-35571":["thread",35571],"thread-35570":["thread",35570],"thread-35569":["thread",35569],"thread-35568":["thread",35568],"thread-35567":["thread",35567],"thread-35566":["thread",35566],"thread-35565":["thread",35565],"thread-35564":["thread",35564],"thread-35563":["thread",35563],"thread-35562":["thread",35562],"thread-35561":["thread",35561],"thread-35560":["thread",35560],"thread-35559":["thread",35559],"thread-35558":["thread",35558],"thread-35557":["thread",35557],"thread-35556":["thread",35556],"thread-35555":["thread",35555],"thread-35554":["thread",35554],"thread-35553":["thread",35553],"thread-35552":["thread",35552],"thread-35551":["thread",35551],"thread-35550":["thread",35550],"thread-35549":["thread",35549],"thread-35548":["thread",35548],"thread-35547":["thread",35547],"thread-35546":["thread",35546],"thread-35545":["thread",35545],"thread-35544":["thread",35544],"thread-35543":["thread",35543],"thread-35542":["thread",35542],"thread-35541":["thread",35541],"thread-35540":["thread",35540],"thread-35539":["thread",35539],"thread-35538":["thread",35538],"thread-35537":["thread",35537],"thread-35536":["thread",35536],"thread-35535":["thread",35535],"thread-35534":["thread",35534],"thread-35533":["thread",35533],"thread-35532":["thread",35532],"thread-35531":["thread",35531],"thread-35530":["thread",35530],"thread-35529":["thread",35529],"thread-35528":["thread",35528],"thread-35527":["thread",35527],"thread-35526":["thread",35526],"thread-35525":["thread",35525],"thread-35524":["thread",35524],"thread-35523":["thread",35523],"thread-35522":["thread",35522],"thread-35521":["thread",35521],"thread-35520":["thread",35520],"thread-35519":["thread",35519],"thread-35518":["thread",35518],"thread-35517":["thread",35517],"thread-35516":["thread",35516],"thread-35515":["thread",35515],"thread-35514":["thread",35514],"thread-35513":["thread",35513],"thread-35512":["thread",35512],"thread-35511":["thread",35511],"thread-35510":["thread",35510],"thread-35509":["thread",35509],"thread-35508":["thread",35508],"thread-35507":["thread",35507],"thread-35506":["thread",35506],"thread-35505":["thread",35505],"thread-35504":["thread",35504],"thread-35503":["thread",35503],"thread-35502":["thread",35502],"thread-35501":["thread",35501],"thread-35500":["thread",35500],"thread-35499":["thread",35499],"thread-35498":["thread",35498],"thread-35497":["thread",35497],"thread-35496":["thread",35496],"thread-35495":["thread",35495],"thread-35494":["thread",35494],"thread-35493":["thread",35493],"thread-35492":["thread",35492],"thread-35491":["thread",35491],"thread-35490":["thread",35490],"thread-35489":["thread",35489],"thread-35488":["thread",35488],"thread-35487":["thread",35487],"thread-35486":["thread",35486],"thread-35485":["thread",35485],"thread-35484":["thread",35484],"thread-35483":["thread",35483],"thread-35482":["thread",35482],"thread-35481":["thread",35481],"thread-35480":["thread",35480],"thread-35479":["thread",35479],"thread-35478":["thread",35478],"thread-35477":["thread",35477],"thread-35476":["thread",35476],"thread-35475":["thread",35475],"thread-35474":["thread",35474],"thread-35473":["thread",35473],"thread-35472":["thread",35472],"thread-35471":["thread",35471],"thread-35470":["thread",35470],"thread-35469":["thread",35469],"thread-35468":["thread",35468],"thread-35467":["thread",35467],"thread-35466":["thread",35466],"thread-35465":["thread",35465],"thread-35464":["thread",35464],"thread-35463":["thread",35463],"thread-35462":["thread",35462],"thread-35461":["thread",35461],"thread-35460":["thread",35460],"thread-35459":["thread",35459],"thread-35458":["thread",35458],"thread-35457":["thread",35457],"thread-35456":["thread",35456],"thread-35455":["thread",35455],"thread-35454":["thread",35454],"thread-35453":["thread",35453],"thread-35452":["thread",35452],"thread-35451":["thread",35451],"thread-35450":["thread",35450],"thread-35449":["thread",35449],"thread-35448":["thread",35448],"thread-35447":["thread",35447],"thread-35446":["thread",35446],"thread-35445":["thread",35445],"thread-35444":["thread",35444],"thread-35443":["thread",35443],"thread-35442":["thread",35442],"thread-35441":["thread",35441],"thread-35440":["thread",35440],"thread-35439":["thread",35439],"thread-35438":["thread",35438],"thread-35437":["thread",35437],"thread-35436":["thread",35436],"thread-35435":["thread",35435],"thread-35434":["thread",35434],"thread-35433":["thread",35433],"thread-35432":["thread",35432],"thread-35431":["thread",35431],"thread-35430":["thread",35430],"thread-35429":["thread",35429],"thread-35428":["thread",35428],"thread-35427":["thread",35427],"thread-35426":["thread",35426],"thread-35425":["thread",35425],"thread-35424":["thread",35424],"thread-35423":["thread",35423],"thread-35422":["thread",35422],"thread-35421":["thread",35421],"thread-35420":["thread",35420],"thread-35419":["thread",35419],"thread-35418":["thread",35418],"thread-35416":["thread",35416],"thread-35415":["thread",35415],"thread-35414":["thread",35414],"thread-35413":["thread",35413],"thread-35412":["thread",35412],"thread-35411":["thread",35411],"thread-35410":["thread",35410],"thread-35409":["thread",35409],"thread-35408":["thread",35408],"thread-35407":["thread",35407]}, , 1715572778
Run Time: 0.000627
- 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