库存出现负数 mysql_前台支付商品成功后，sku表库存，购买数量会重复执行减操作好几次了，导致库存为负数...

**

_### 测试下来问题出现在，支付成功后这个节点，反复执行了好几次了product_sku 字段的更新。

**_

[ 2020-01-08T16:51:06+08:00 ] 140.207.54.76 POST /addons/xshop/pay/notify/paytype/wechat/paymethod/miniapp

[运行时间：0.114282s] [吞吐率：8.75req/s] [内存消耗：5,085.39kb] [文件加载：177]

[ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.000027s ]

[ info ] [ CACHE ] INIT File

[ info ] [ BEHAVIOR ] Run addonsepayEpay @app_init [ RunTime:0.003393s ]

[ info ] [ BEHAVIOR ] Run Closure @app_init [ RunTime:0.003420s ]

[ info ] [ LANG ] C:phpstudy_proWWWfshopthinkphplangzh-cn.php

[ info ] [ ROUTE ] array (

'type' => 'method',

'method' =>

array (0 => '\think\addons\Route',

1 => 'execute',

),

'var' =>

array (

),

)

[ info ] [ HEADER ] array (

'content-type' => 'text/xml',

'user-agent' => 'Mozilla/4.0',

'host' => '*',

'content-length' => '774',

'pragma' => 'no-cache',

'connection' => 'close',

'accept' => '/',

)

[ info ] [ PARAM ] array (

'addon' => 'xshop',

'controller' => 'pay',

'action' => 'notify',

'paytype' => 'wechat',

'paymethod' => 'miniapp',

)

[ info ] [ RUN ] thinkaddonsRoute->execute[ C:phpstudy_proWWWfshopvendorkarsonzhangfastadmin-addonssrcaddonsRoute.php ]

[ info ] [ LANG ] C:phpstudy_proWWWfshoppublic/../application/commonlangzh-cnaddon.php

[ info ] [ BEHAVIOR ] Run appcommonbehaviorCommon @addon_begin [ RunTime:0.002233s ]

[ info ] [ TOKEN ] INIT Mysql

[ info ] [ DB ] INIT mysql

[ info ] [ BEHAVIOR ] Run addonsxshopbehaviororderPayOkListener @xshop_order_pay_ok [ RunTime:0.015182s ]

[ info ] [ BEHAVIOR ] Run addonsxshopgrouponbehaviororderUpdateGroupon @xshop_order_pay_ok [ RunTime:0.000451s ]

[ info ] [ DB ] INIT mysql

[ info ] [ LOG ] INIT File

[ sql ] [ DB ] CONNECT:[ UseTime:0.001347s ] mysql:host=127.0.0.1;dbname=fshop;charset=utf8

[ sql ] [ SQL ] SHOW COLUMNS FROM f_user_token [ RunTime:0.001119s ]

[ sql ] [ SQL ] SELECT * FROM f_user_token WHERE token = 'd8aa945b8448d8a41ab99c04b04f9e522294b47c' LIMIT 1 [ RunTime:0.000542s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM f_xshop_order [ RunTime:0.000993s ]

[ sql ] [ SQL ] SELECT * FROM f_xshop_order WHERE ( order_sn = 'O2020010851515257' ) AND f_xshop_order.delete_time IS NULL LIMIT 1 [ RunTime:0.000680s ]

[ sql ] [ SQL ] UPDATE f_xshop_order SET is_pay=1,pay_time=1578473466,status=1,pay_type='wechat',pay_method='miniapp',payed_price=0.01,order_sn_re='O2020010851515257RE5402306',update_time=1578473466 WHERE id = 16 [ RunTime:0.002487s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM f_xshop_order_product [ RunTime:0.002212s ]

[ sql ] [ SQL ] SELECT * FROM f_xshop_order_product WHERE order_id = 16 [ RunTime:0.000666s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM f_xshop_product [ RunTime:0.000948s ]

[ sql ] [ SQL ] UPDATE f_xshop_product SET sold_count=sold_count+1 WHERE id = 45 [ RunTime:0.002919s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM f_xshop_product_sku [ RunTime:0.000893s ]

[ sql ] [ SQL ] UPDATE f_xshop_product_sku SET sold_count=sold_count+1 WHERE id = 44 [ RunTime:0.002575s ]

[ sql ] [ SQL ] UPDATE f_xshop_product_sku SET stock=stock-1 WHERE id = 44 [ RunTime:0.001722s ]

[ sql ] [ DB ] CONNECT:[ UseTime:0.001019s ] mysql:host=127.0.0.1;dbname=fshop;charset=utf8

[ sql ] [ SQL ] SELECT * FROM f_xshop_order WHERE ( order_sn = 'O2020010851515257' ) AND f_xshop_order.delete_time IS NULL LIMIT 1 [ RunTime:0.001594s ]

[ sql ] [ SQL ] SELECT * FROM f_xshop_order_product WHERE order_id = 16 [ RunTime:0.001400s ]

[ sql ] [ SQL ] SELECT * FROM f_xshop_product_sku WHERE id IN (44) [ RunTime:0.000557s ]

[ sql ] [ SQL ] SELECT * FROM f_xshop_product WHERE id IN (45) ORDER BY category_id [ RunTime:0.000504s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM f_xshop_unit [ RunTime:0.000727s ]

[ sql ] [ SQL ] SELECT * FROM f_xshop_unit WHERE id IN (0) [ RunTime:0.000534s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM f_user [ RunTime:0.001076s ]

[ sql ] [ SQL ] SELECT * FROM f_user WHERE id = 1776 LIMIT 1 [ RunTime:0.000510s ]

[ sql ] [ SQL ] SHOW COLUMNS FROM f_xshop_template [ RunTime:0.001703s ]

[ sql ] [ SQL ] SELECT * FROM f_xshop_template WHERE code = 'LocalOrderPrintTemplate' LIMIT 1 [ RunTime:0.000394s ]

[ error ] [0]模板不存在[C:phpstudy_proWWWfshopapplicationadminmodelxshopTemplate.php:34]

-

最后还会报模板错误，这里需要什么模板？

另外还发现后台订单列表，已支付的订单退款出问题【报错】

更改订单状态为已支付的时候也会出问题。出现的问题也是模板不存在