2019-06-04电商pv、uv
<h2>电商PV\UV数据</h2>
<p>连接数据库 rm-wz90v23c907w8n5nmo.mysql.rds.aliyuncs.com 用户名-shopping 密码-izyDTnDZJNkjGj1J</p>
<p><strong>进入表shop_goods_info中</strong>
<img src="https://www.showdoc.cc/server/api/common/visitfile/sign/62b04e97710710e1dfb8c7296d555bbc?showdoc=.jpg" alt="" /></p>
<p><strong>查看商品id</strong>
<img src="https://www.showdoc.cc/server/api/common/visitfile/sign/a45183dfe63859e0fdd43280de5d014b?showdoc=.jpg" alt="" /></p>
<p><strong>选择查询searchpv&uv</strong>
<img src="https://www.showdoc.cc/server/api/common/visitfile/sign/161f347831d1321b2da1defee5d30148?showdoc=.jpg" alt="" /></p>
<p><strong>替换gid后运行</strong>
<img src="https://www.showdoc.cc/server/api/common/visitfile/sign/94474c135a02875351ef78d00811718d?showdoc=.jpg" alt="" /></p>
<p><strong>结果1、结果2分别为pv和uv</strong>
<img src="https://www.showdoc.cc/server/api/common/visitfile/sign/c50d51e72f0fc590462ffb546c7e7a23?showdoc=.jpg" alt="" /></p>
<pre><code>SELECT count(id) as pv
FROM shop_visit_log
Where gid = 9
AND create_time > '2019-05-15 00:00:00';
</code></pre>
<pre><code>SELECT count(DISTINCT openid) as uv
FROM shop_visit_log
Where gid = 9
AND create_time > '2019-05-15 00:00:00';</code></pre>