**************************mima_b2b_Login()2022/4/23 10:12:01*************************
paramter0:1001
paramter1:oDppT5LtV4auB_IwyKBJodU-F7TM
Api.Helper.Exceptions.KatException: 密码错误
   在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token)
**************************************************************************************

**************************************************************************************
[意料之外的错误] ----- 2022-04-23 10:12:01
[错误信息] => 密码错误

[sql] => select a.oper_id,
                   a.oper_name,
                   a.oper_pwd,
                   a.open_id,
                   (case when isnull(c.cust_level, 1) = '' then '1' else isnull(c.cust_level, 1) end) as cus_level,
                   c.is_branch,
                   b.supcust_no,
                   c.supcust_group
            from sa_t_mobile_oper as a
                     inner join sa_t_mobile_data_main as b on a.oper_id = b.oper_id
                     left join bi_t_supcust_info as c on b.supcust_no = c.supcust_no
            where a.oper_id = '1001' or a.login_no = '1001'

[详细] =>    在 Api.BLL.b2b.CustomerService.mima_b2b_Login(String oper_id, String pwd, String open_id, B2B_Oper& oper, String& token)
   在 Api.SingOut.b2b.mina.oper.login(String card_id, String vip_pass, String is_bind, String open_id)

[路由] => Api.SingOut.b2b.mina.SingOut.b2b.mina.oper , [方法] => login 
[入参] => {"card_id":"1001","vip_pass":"","is_bind":"1","open_id":"oDppT5LtV4auB_IwyKBJodU-F7TM"}

**************************************************************************************


**************************GetClsGoods2022/4/23 11:10:56*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0701% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:10:57*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0702% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:11:01*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0702% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:11:15*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:11:27*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:11:28*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:11:28*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:11:29*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:12:57*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:13:01*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:13:12*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:20:18*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:20:19*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:20:21*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:20:22*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:25:14*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:25:55*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1701% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:25:56*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:26:25*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:26:31*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:26:38*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1701% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:26:40*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:27:41*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:27:43*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1701% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:27:44*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:27:58*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:27:59*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1401% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:28:00*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:28:01*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0901% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:28:01*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0701% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:28:02*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0501% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:28:03*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0301% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:28:12*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0301% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:28:13*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:28:14*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0202% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:28:14*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0203% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:40:17*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:40:21*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '0201% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:40:23*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:40:37*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1701% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:40:38*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:40:39*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1701% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:40:39*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 11:42:07*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetGoodsListByName22022/4/23 12:17:47*************************
paramter0:select count(*) total_count
                from goods a
                where ('白菜' = '' or a.goods_name like '%白菜%')
                  and a.cls_id in (select cls_id from goods_cls where isnull(is_show_mall, '0') = '1' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:15
测试2
**************************************************************************************


**************************GetGoodsListByName22022/4/23 12:17:51*************************
paramter0:select count(*) total_count
                from goods a
                where ('白菜' = '' or a.goods_name like '%白菜%')
                  and a.cls_id in (select cls_id from goods_cls where isnull(is_show_mall, '0') = '1' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:15
测试2
**************************************************************************************


**************************GetGoodsListByName22022/4/23 12:17:52*************************
paramter0:select count(*) total_count
                from goods a
                where ('白菜' = '' or a.goods_name like '%白菜%')
                  and a.cls_id in (select cls_id from goods_cls where isnull(is_show_mall, '0') = '1' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:15
测试2
**************************************************************************************


**************************GetGoodsListByName22022/4/23 12:17:57*************************
paramter0:select count(*) total_count
                from goods a
                where ('生菜' = '' or a.goods_name like '%生菜%')
                  and a.cls_id in (select cls_id from goods_cls where isnull(is_show_mall, '0') = '1' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:4
测试2
**************************************************************************************


**************************GetGoodsListByName22022/4/23 12:17:59*************************
paramter0:select count(*) total_count
                from goods a
                where ('生菜' = '' or a.goods_name like '%生菜%')
                  and a.cls_id in (select cls_id from goods_cls where isnull(is_show_mall, '0') = '1' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:4
测试2
**************************************************************************************


**************************GetGoodsListByName22022/4/23 12:18:04*************************
paramter0:select count(*) total_count
                from goods a
                where ('土猪' = '' or a.goods_name like '%土猪%')
                  and a.cls_id in (select cls_id from goods_cls where isnull(is_show_mall, '0') = '1' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:43
测试2
**************************************************************************************


**************************GetGoodsListByName22022/4/23 12:18:05*************************
paramter0:select count(*) total_count
                from goods a
                where ('土猪' = '' or a.goods_name like '%土猪%')
                  and a.cls_id in (select cls_id from goods_cls where isnull(is_show_mall, '0') = '1' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:43
测试2
**************************************************************************************


**************************GetGoodsListByName22022/4/23 12:18:06*************************
paramter0:select count(*) total_count
                from goods a
                where ('土猪' = '' or a.goods_name like '%土猪%')
                  and a.cls_id in (select cls_id from goods_cls where isnull(is_show_mall, '0') = '1' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:43
测试2
**************************************************************************************


**************************GetGoodsListByName22022/4/23 12:18:07*************************
paramter0:select count(*) total_count
                from goods a
                where ('土猪' = '' or a.goods_name like '%土猪%')
                  and a.cls_id in (select cls_id from goods_cls where isnull(is_show_mall, '0') = '1' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:43
测试2
**************************************************************************************


**************************GetGoodsListByName22022/4/23 12:18:09*************************
paramter0:select count(*) total_count
                from goods a
                where ('土猪' = '' or a.goods_name like '%土猪%')
                  and a.cls_id in (select cls_id from goods_cls where isnull(is_show_mall, '0') = '1' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:43
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:09*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:14*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:15*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:16*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:17*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:18*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:20*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:21*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:23*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:29*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:30*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:33*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:35*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:36*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:40*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:44*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:45*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:46*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:46*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:47*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:48*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:51*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:53*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:53*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:55*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:56*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************


**************************GetClsGoods2022/4/23 12:19:56*************************
paramter0:select count(*) as total_count
                from goods a
                where a.cls_id in (select cls_id
                                   from goods_cls
                                   where isnull(is_show_mall, '0') = '1'
                                     and cls_no like '1601% ' )
                  and a.status = '1'
                  and isnull(a.is_show_mall, '0') = '1' 
paramter1:0
测试2
**************************************************************************************