的店铺 - 运营动脉

— 运行信息( 0.1228 秒):

［SQL语句］

SELECT data FROM `test_jiuniao_net` . `jiuniao_common_session` WHERE (sessionid = '6ttf9dfsj846mn5nn774p9kbc5') LIMIT 1; [ RunTime:0.000189s ]

SELECT a.id,a.userid,a.name shopname,a.logo,a.introduction,a.views,a.favorite,b.name groupname,c.isauth,c.authtype,c.fans,c.follow FROM `test_jiuniao_net` . `jiuniao_member_shop` a INNER JOIN jiuniao_member_shop_group b ON a.groupid=b.groupid INNER JOIN jiuniao_member c ON a.userid=c.userid WHERE (a.id = '1' AND a.status = '1' AND b.status = '1') LIMIT 1; [ RunTime:0.000175s ]

SELECT COUNT(*) AS total FROM `test_jiuniao_net` . `jiuniao_wenku_content` WHERE `status`=1 AND `userid`=10000; [ RunTime:0.012481s ]

SELECT contentid,catid,title,pic,views,pagenum,fileext,url,istui,isvip,vipfree FROM `test_jiuniao_net` . `jiuniao_wenku_content` WHERE `status`=1 AND `userid`=10000 ORDER BY posttime DESC LIMIT 2448,12; [ RunTime:0.085063s ]

SELECT b.contentid,b.title,b.url,b.fileext FROM `test_jiuniao_net` . `jiuniao_wenku_rank` a INNER JOIN jiuniao_wenku_content b ON a.contentid=b.contentid WHERE b.status=1 AND b.convert_status=3 AND b.userid=10000 ORDER BY a.views desc LIMIT 10; [ RunTime:0.000385s ]

SELECT * FROM `test_jiuniao_net` . `jiuniao_module` WHERE (module = 'kefu') LIMIT 1; [ RunTime:0.000185s ]

［其他信息］

服务器信息：nginx/1.26.3

会话ID：6ttf9dfsj846mn5nn774p9kbc5

微信扫码分享或点击分享到

文档

阅读排行