的店铺 - 运营动脉

— 运行信息( 0.1236 秒):

［SQL语句］

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

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.000201s ]

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

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 2340,12; [ RunTime:0.087168s ]

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.000310s ]

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

［其他信息］

服务器信息：nginx/1.26.3

会话ID：h51lcln9d2ujjgo37u7gc6uuun

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

文档

阅读排行