USE information_schema;
select table_name,table_rows from tables where TABLE_SCHEMA = 'mallplus1' order by table_rows desc;

 if(type===1){
          return 'ios首页轮播';
        }else if(type===2){
          return 'android首页轮播';
        }
        else if(type===3){
            return 'pc首页轮播';
        }else if(type===4){
            return 'h5首页轮播';
        }else if(type===5){
            return '小程序首页轮播';
        }


沈兄~能把数据抓出来吗？https://map.beijing.gov.cn/category?categoryId=xx


SELECT * from pms_product where product_attribute_category_id=1 ;
SELECT * from pms_sku_stock where product_id=26;
SELECT * from pms_product_attribute_value  where product_id=26;
SELECT * from pms_product_attribute  where product_attribute_category_id=3;
SELECT * from pms_product_attribute where id in (SELECT product_attribute_id from pms_product_attribute_value  where product_id=26);
SELECT * from pms_product_category_attribute_relation where product_attribute_id in (SELECT product_attribute_id from pms_product_attribute_value  where product_id=26);;

SELECT * from pms_product_attribute_category where id =3;
SELECT * from pms_product_category where id=19;

SELECT * from pms_product_full_reduction where product_id=26;
SELECT * from pms_product_ladder where product_id=26;
SELECT * from pms_product_operate_log where product_id=26;
SELECT * from pms_product_vertify_record where product_id=26;

SELECT * from pms_product_attribute ;
SELECT * from pms_product_attribute_category;

SELECT * from ums_member ;
SELECT * from sms_home_advertise;
SELECT * from ums_member_receive_address ;

select * from oms_cart_item where member_id=17;
select * from oms_order where member_id=17;
select * from oms_order_item where order_id=51;
SELECT * from sms_coupon;
SELECT * from sms_coupon_history;
SELECT * from sms_coupon_product_relation;
SELECT * from sms_coupon_product_category_relation;

SELECT * from oms_order_setting;


接口需求
1、会员获得的君米排位赛。描述：获得的君米是会员发帖其他人给予的打赏（自身购买的除外），每篇文章每位会员只能打赏一次。
2、后台设计两个奖品栏，第二栏为VIP会员追加的奖励。
3、此活动是所有会员的评选，设计关系的关联。
4、排位名次前端需求按君米数实时更新。



http://ext.dcloud.net.cn/plugin?id=214
http://ext.dcloud.net.cn/plugin?id=465
http://ext.dcloud.net.cn/plugin?id=232
http://ext.dcloud.net.cn/plugin?id=271
http://ext.dcloud.net.cn/plugin?id=467
http://ext.dcloud.net.cn/plugin?id=235
http://ext.dcloud.net.cn/plugin?id=434 水印
http://ext.dcloud.net.cn/plugin?id=417 物流
http://ext.dcloud.net.cn/plugin?id=305 优惠券
http://ext.dcloud.net.cn/plugin?id=299 城市选择
http://ext.dcloud.net.cn/?page=33 评价模版
http://ext.dcloud.net.cn/plugin?id=214 圆环统计
http://ext.dcloud.net.cn/plugin?id=104 cms