1 Star 0 Fork 1.3K

李人人/mallplus+商城+APP+SaaS+uniapp+wechat

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
文件
克隆/下载
新建文本文档.txt 1.95 KB
一键复制 编辑 原始数据 按行查看 历史
1439226817@qq.com 提交于 2019-07-02 09:46 . 商品浏览记录
SELECT * from pms_sku_stock where product_id=62;
SELECT * from pms_product_attribute_value where product_id=62; -- (存储产品参数信息的表)
SELECT * from pms_product_attribute where product_attribute_category_id=3; -- (商品属性参数表)
SELECT * from pms_product_attribute_category where id =3; -- (产品属性分类表)
SELECT * from pms_product_category where id=62; -- 产品分类)
SELECT * from pms_product_full_reduction where product_id=62; -- (产品满减表(只针对同商品))
SELECT * from pms_product_ladder where product_id=62; -- (产品阶梯价格表(只针对同商品))
SELECT * from pms_product_operate_log where product_id=62;
SELECT * from pms_product_vertify_record where product_id=62;
SELECT * from sys_user;
SELECT * from sys_role;
SELECT * FROM sys_user_role;
SELECT * from sys_permission where pid=0;
SELECT * from sys_permission where pid=1;
SELECT * from sys_permission where pid=4;
SELECT * from sys_role_permission;
SELECT method, count(1) count,
sum(time_min)/1000 as sum,
sum(time_min)/count(1)/1000 avgMin ,
sum(case when time_min>100 then time_min else 0 end)/1000 as sum1,
sum(case when time_min>300 then time_min else 0 end)/1000 as sum2,
sum(case when time_min>600 then time_min else 0 end)/1000 as sum3,
sum(case when time_min>1000 then time_min else 0 end)/1000 as sum4,
sum(case when time_min>1500 then time_min else 0 end)/1000 as sum5,
sum(case when time_min>3000 then time_min else 0 end)/1000 as sum6,
sum(case when time_min>100 then 1 else 0 end) as count1,
sum(case when time_min>300 then 1 else 0 end) as count2,
sum(case when time_min>600 then 1 else 0 end) as count3,
sum(case when time_min>1000 then 1 else 0 end) as count4,
sum(case when time_min>1500 then 1 else 0 end) as count5,
sum(case when time_min>3000 then 1 else 0 end) as count6
from sys_admin_log where 1=1
group by method order by avgMin desc
limit 100
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
Java
1
https://gitee.com/li_renren/mallplus.git
git@gitee.com:li_renren/mallplus.git
li_renren
mallplus
mallplus+商城+APP+SaaS+uniapp+wechat
master

搜索帮助