SELECT `xf_xa_ams_article`.*, `xf_user_User_1`.*, `xf_xa_ams_category_Category_2`.*, `xf_permission_cache_content_Permissions_3`.*
FROM `xf_xa_ams_article`
LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_xa_ams_article`.`user_id`)
LEFT JOIN `xf_xa_ams_category` AS `xf_xa_ams_category_Category_2` ON (`xf_xa_ams_category_Category_2`.`category_id` = `xf_xa_ams_article`.`category_id`)
LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_3` ON (`xf_permission_cache_content_Permissions_3`.`content_type` = 'ams_category' AND `xf_permission_cache_content_Permissions_3`.`content_id` = `xf_xa_ams_category_Category_2`.`category_id` AND `xf_permission_cache_content_Permissions_3`.`permission_combination_id` = '1')
WHERE (`xf_xa_ams_article`.`article_id` IN (4921, 4913, 4900, 4897, 4893, 4891, 4873, 4815, 4775, 4741, 4739, 4737, 4736, 4734, 4725, 4701, 4671, 4643, 4641, 4637, 4631, 4615, 4612, 4609, 4608, 4606, 4605, 4598, 4597, 4594, 4586, 4584, 4582, 4569, 4558, 4525, 4506, 4502, 4484, 4477, 4470, 4469, 4463, 4460, 4446, 4445, 4442, 4438, 4425, 4423, 4400, 4398, 4371, 4350, 4345, 4331, 4329, 4328, 4305, 4298, 4293, 4282, 4274, 4272, 4268, 4267, 4264, 4263, 4252))
Run Time: 0.006603
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_xa_ams_article | range | PRIMARY | PRIMARY | 4 | | 69 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_xa_ams_article.user_id | 1 | |
SIMPLE | xf_xa_ams_category_Category_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_xa_ams_article.category_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_3 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.xf_xa_ams_category_Category_2.category_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 2729
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20
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 (172294, 172090, 171765, 171561, 171537, 171491, 169915, 169893, 169830, 169594, 169395, 168692, 168477, 168278, 168093, 167985, 167974, 167884, 167730, 167594, 167587, 167322, 167246, 167242, 167229, 167147, 166861, 166672, 166490, 166361, 166273, 166143, 165739, 165687, 165514, 164797, 164563, 164491, 163970, 163489, 163429, 163421, 163318, 163315, 162841, 162799, 162734, 162727, 162606, 162581, 162370, 162213, 161759, 161748, 161571, 161560, 161195, 161047, 160859, 160507, 160295, 160231, 160167, 159922, 159875, 159578, 159418, 159196, 159184, 159084, 159010, 158997, 158995, 158916, 158903, 158690, 158667, 158615, 158585, 158490, 158405, 158102, 158101, 158075, 157921, 157879, 157857, 157854, 157743, 157621, 157468, 157225, 157090, 157054, 156968, 156887, 156868, 156566, 156125))
Run Time: 0.054994
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | PRIMARY | PRIMARY | 4 | | 99 | Using where |
SIMPLE | xf_forum_Forum_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.node_id | 1 | |
SIMPLE | xf_node_Node_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_1.node_id | 1 | Using where |
SIMPLE | xf_user_User_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.user_id | 1 | |
SIMPLE | xf_post_FirstPost_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_thread.first_post_id | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_5 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.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 2729
- 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 2351
- XF\App->run() in src/XF.php at line 517
- 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: 38585, 0, 1714724072, {"ams_article-4921":["ams_article",4921],"ams_article-4913":["ams_article",4913],"thread-172294":["thread",172294],"ams_article-4900":["ams_article",4900],"ams_article-4897":["ams_article",4897],"ams_article-4893":["ams_article",4893],"ams_article-4891":["ams_article",4891],"thread-172090":["thread",172090],"thread-171765":["thread",171765],"ams_article-4873":["ams_article",4873],"thread-171561":["thread",171561],"thread-171537":["thread",171537],"thread-171491":["thread",171491],"thread-169915":["thread",169915],"thread-169893":["thread",169893],"ams_article-4815":["ams_article",4815],"thread-169830":["thread",169830],"thread-169594":["thread",169594],"thread-169395":["thread",169395],"thread-168692":["thread",168692],"thread-168477":["thread",168477],"ams_article-4775":["ams_article",4775],"thread-168278":["thread",168278],"thread-168093":["thread",168093],"thread-167985":["thread",167985],"thread-167974":["thread",167974],"thread-167884":["thread",167884],"thread-167730":["thread",167730],"thread-167594":["thread",167594],"thread-167587":["thread",167587],"ams_article-4741":["ams_article",4741],"ams_article-4739":["ams_article",4739],"thread-167322":["thread",167322],"thread-167246":["thread",167246],"ams_article-4737":["ams_article",4737],"thread-167242":["thread",167242],"thread-167229":["thread",167229],"ams_article-4736":["ams_article",4736],"ams_article-4734":["ams_article",4734],"thread-167147":["thread",167147],"thread-166861":["thread",166861],"ams_article-4725":["ams_article",4725],"thread-166672":["thread",166672],"thread-166490":["thread",166490],"thread-166361":["thread",166361],"thread-166273":["thread",166273],"thread-166143":["thread",166143],"ams_article-4701":["ams_article",4701],"thread-165739":["thread",165739],"thread-165687":["thread",165687],"thread-165514":["thread",165514],"ams_article-4671":["ams_article",4671],"thread-164797":["thread",164797],"ams_article-4643":["ams_article",4643],"ams_article-4641":["ams_article",4641],"ams_article-4637":["ams_article",4637],"ams_article-4631":["ams_article",4631],"ams_article-4615":["ams_article",4615],"thread-164563":["thread",164563],"ams_article-4612":["ams_article",4612],"ams_article-4609":["ams_article",4609],"ams_article-4608":["ams_article",4608],"ams_article-4606":["ams_article",4606],"ams_article-4605":["ams_article",4605],"thread-164491":["thread",164491],"ams_article-4598":["ams_article",4598],"ams_article-4597":["ams_article",4597],"ams_article-4594":["ams_article",4594],"ams_article-4586":["ams_article",4586],"ams_article-4584":["ams_article",4584],"ams_article-4582":["ams_article",4582],"ams_article-4569":["ams_article",4569],"thread-163970":["thread",163970],"ams_article-4558":["ams_article",4558],"thread-163489":["thread",163489],"thread-163429":["thread",163429],"thread-163421":["thread",163421],"ams_article-4525":["ams_article",4525],"thread-163318":["thread",163318],"thread-163315":["thread",163315],"ams_article-4506":["ams_article",4506],"ams_article-4502":["ams_article",4502],"thread-162841":["thread",162841],"thread-162799":["thread",162799],"thread-162734":["thread",162734],"thread-162727":["thread",162727],"thread-162606":["thread",162606],"thread-162581":["thread",162581],"thread-162370":["thread",162370],"ams_article-4484":["ams_article",4484],"thread-162213":["thread",162213],"ams_article-4477":["ams_article",4477],"ams_article-4470":["ams_article",4470],"ams_article-4469":["ams_article",4469],"thread-161759":["thread",161759],"thread-161748":["thread",161748],"ams_article-4463":["ams_article",4463],"thread-161571":["thread",161571],"thread-161560":["thread",161560],"ams_article-4460":["ams_article",4460],"thread-161195":["thread",161195],"ams_article-4446":["ams_article",4446],"ams_article-4445":["ams_article",4445],"thread-161047":["thread",161047],"thread-160859":["thread",160859],"ams_article-4442":["ams_article",4442],"ams_article-4438":["ams_article",4438],"thread-160507":["thread",160507],"ams_article-4425":["ams_article",4425],"ams_article-4423":["ams_article",4423],"thread-160295":["thread",160295],"thread-160231":["thread",160231],"thread-160167":["thread",160167],"thread-159922":["thread",159922],"thread-159875":["thread",159875],"ams_article-4400":["ams_article",4400],"ams_article-4398":["ams_article",4398],"thread-159578":["thread",159578],"thread-159418":["thread",159418],"ams_article-4371":["ams_article",4371],"thread-159196":["thread",159196],"thread-159184":["thread",159184],"thread-159084":["thread",159084],"thread-159010":["thread",159010],"thread-158997":["thread",158997],"thread-158995":["thread",158995],"thread-158916":["thread",158916],"thread-158903":["thread",158903],"ams_article-4350":["ams_article",4350],"thread-158690":["thread",158690],"thread-158667":["thread",158667],"ams_article-4345":["ams_article",4345],"thread-158615":["thread",158615],"thread-158585":["thread",158585],"thread-158490":["thread",158490],"thread-158405":["thread",158405],"ams_article-4331":["ams_article",4331],"thread-158102":["thread",158102],"thread-158101":["thread",158101],"thread-158075":["thread",158075],"ams_article-4329":["ams_article",4329],"ams_article-4328":["ams_article",4328],"thread-157921":["thread",157921],"thread-157879":["thread",157879],"thread-157857":["thread",157857],"thread-157854":["thread",157854],"thread-157743":["thread",157743],"ams_article-4305":["ams_article",4305],"ams_article-4298":["ams_article",4298],"thread-157621":["thread",157621],"ams_article-4293":["ams_article",4293],"thread-157468":["thread",157468],"ams_article-4282":["ams_article",4282],"thread-157225":["thread",157225],"ams_article-4274":["ams_article",4274],"thread-157090":["thread",157090],"ams_article-4272":["ams_article",4272],"thread-157054":["thread",157054],"ams_article-4268":["ams_article",4268],"ams_article-4267":["ams_article",4267],"thread-156968":["thread",156968],"thread-156887":["thread",156887],"thread-156868":["thread",156868],"ams_article-4264":["ams_article",4264],"ams_article-4263":["ams_article",4263],"ams_article-4252":["ams_article",4252],"thread-156566":["thread",156566],"thread-156125":["thread",156125]}, , 1714720472
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 1514
- XF\Mvc\Entity\Entity->_saveToSource() in src/XF/Mvc/Entity/Entity.php at line 1246
- 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 2351
- XF\App->run() in src/XF.php at line 517
- XF::runApp() in index.php at line 20