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;

chatGpt

     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;
测试