--------------------------------------------------------------- [ 2023-07-20T08:53:35+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E6%8E%92%E6%B0%94%E7%AE%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.040039s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.025391s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%排气管%' [ RunTime:0.011719s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%排气管%' limit 0,3000 [ RunTime:13.432617s ] --------------------------------------------------------------- [ 2023-07-20T08:54:32+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.037109s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T08:55:00+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.046875s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T08:55:01+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T08:55:17+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18088' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18088' , '排气管软管' , '工程机械设备配件' , 'PQGRG' , '拖拉机' , '根' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.016602s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18088' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18088' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18088' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18088' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18088' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2023-07-20T08:55:31+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E6%8E%92%E6%B0%94%E7%AE%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%排气管%' [ RunTime:0.009765s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%排气管%' limit 0,3000 [ RunTime:13.024414s ] --------------------------------------------------------------- [ 2023-07-20T08:55:58+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E5%88%B9%E8%BD%A6%E7%AE%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%刹车管%' [ RunTime:0.009766s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%刹车管%' limit 0,3000 [ RunTime:12.937500s ] --------------------------------------------------------------- [ 2023-07-20T08:56:28+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T08:56:47+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027343s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T08:56:47+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T08:57:04+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.048828s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.086915s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.005859s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.004883s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18089' LIMIT 1 [ RunTime:0.003906s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18089' , '刹车管' , '运输设备配件' , 'CCG' , '0.5m' , '根' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.003906s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.021484s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18089' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.003906s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18089' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18089' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18089' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18089' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T08:57:18+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.045898s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.011719s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T08:57:19+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E5%88%B9%E8%BD%A6%E7%AE%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.003907s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%刹车管%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%刹车管%' limit 0,3000 [ RunTime:13.316406s ] --------------------------------------------------------------- [ 2023-07-20T08:57:42+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.041015s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T08:57:42+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T08:57:48+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18090' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18090' , '刹车管' , '运输设备配件' , 'CCG' , '1m' , '根' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.017578s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18090' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18090' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18090' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18090' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18090' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T08:58:03+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E5%88%B9%E8%BD%A6%E7%AE%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.023438s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%刹车管%' [ RunTime:0.009765s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%刹车管%' limit 0,3000 [ RunTime:13.527344s ] --------------------------------------------------------------- [ 2023-07-20T08:58:39+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.045898s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.041992s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T08:58:56+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.038086s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T08:58:56+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.049805s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2023-07-20T08:59:08+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18091' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18091' , '刹车管' , '运输设备配件' , 'CCG' , '1.2m' , '根' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.016602s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18091' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18091' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18091' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18091' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18091' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2023-07-20T08:59:23+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E5%88%B9%E8%BD%A6%E7%AE%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.025390s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%刹车管%' [ RunTime:0.036133s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%刹车管%' limit 0,3000 [ RunTime:13.128906s ] --------------------------------------------------------------- [ 2023-07-20T08:59:38+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E7%A6%BB%E5%90%88%E5%99%A8&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%离合器%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%离合器%' limit 0,3000 [ RunTime:13.408203s ] --------------------------------------------------------------- [ 2023-07-20T09:17:42+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E5%88%B9%E8%BD%A6%E6%80%BB%E6%B3%B5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%刹车总泵%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%刹车总泵%' limit 0,3000 [ RunTime:12.931641s ] --------------------------------------------------------------- [ 2023-07-20T09:18:34+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E5%8F%B6%E5%AD%90%E6%9D%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.002930s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%叶子板%' [ RunTime:0.012695s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%叶子板%' limit 0,3000 [ RunTime:13.024414s ] --------------------------------------------------------------- [ 2023-07-20T09:19:40+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E7%9B%86%E8%A7%92%E9%BD%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032226s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%盆角齿%' [ RunTime:0.010742s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%盆角齿%' limit 0,3000 [ RunTime:13.681641s ] --------------------------------------------------------------- [ 2023-07-20T09:20:21+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E9%92%A2%E7%9B%86&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%钢盆%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%钢盆%' limit 0,3000 [ RunTime:13.505859s ] --------------------------------------------------------------- [ 2023-07-20T09:21:54+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.075195s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T09:22:18+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.020507s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T09:22:18+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.011718s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T09:22:41+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.040039s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18092' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18092' , '钢盆' , '运输设备配件' , 'GP' , '新时力拖拉机' , '个' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.025391s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18092' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18092' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18092' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18092' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18092' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T09:22:56+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E9%92%A2%E7%9B%86&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.038086s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.009766s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%钢盆%' [ RunTime:0.009766s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%钢盆%' limit 0,3000 [ RunTime:13.514649s ] --------------------------------------------------------------- [ 2023-07-20T09:23:10+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E6%8D%A2%E6%8C%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%换挡%' [ RunTime:0.009765s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%换挡%' limit 0,3000 [ RunTime:14.466797s ] --------------------------------------------------------------- [ 2023-07-20T09:23:24+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E6%8D%A2%E6%8C%A1&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%换挡%' [ RunTime:0.010742s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%换挡%' limit 0,3000 [ RunTime:13.878907s ] --------------------------------------------------------------- [ 2023-07-20T09:24:29+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E5%8D%87%E9%99%8D%E6%8B%89%E7%BA%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%升降拉线%' [ RunTime:0.009765s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%升降拉线%' limit 0,3000 [ RunTime:13.566407s ] --------------------------------------------------------------- [ 2023-07-20T09:24:50+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E6%8B%89%E7%BA%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%拉线%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%拉线%' limit 0,3000 [ RunTime:13.410156s ] --------------------------------------------------------------- [ 2023-07-20T09:25:52+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E6%89%93%E6%B0%94%E6%B3%B5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.037109s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%打气泵%' [ RunTime:0.012695s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%打气泵%' limit 0,3000 [ RunTime:13.324219s ] --------------------------------------------------------------- [ 2023-07-20T09:26:47+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033204s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T09:27:11+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032226s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.060547s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T09:27:11+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T09:27:29+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.036132s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18093' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18093' , '打气泵钢丝软管' , '运输设备配件' , 'DQBGSRG' , '2m' , '根' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.019531s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18093' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18093' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18093' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18093' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18093' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T09:27:44+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E6%89%93%E6%B0%94%E6%B3%B5&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%打气泵%' [ RunTime:0.010742s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%打气泵%' limit 0,3000 [ RunTime:13.342773s ] --------------------------------------------------------------- [ 2023-07-20T09:27:59+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E7%86%84%E7%81%AB%E6%8B%89%E7%BA%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%熄火拉线%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%熄火拉线%' limit 0,3000 [ RunTime:12.972656s ] --------------------------------------------------------------- [ 2023-07-20T09:28:40+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E6%B2%B9%E9%97%A8%E7%BA%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.018555s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%油门线%' [ RunTime:0.010742s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%油门线%' limit 0,3000 [ RunTime:13.129883s ] --------------------------------------------------------------- [ 2023-07-20T09:29:36+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E6%89%8B%E5%88%B9%E6%8B%89%E7%BA%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.038086s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%手刹拉线%' [ RunTime:0.011718s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%手刹拉线%' limit 0,3000 [ RunTime:13.564454s ] --------------------------------------------------------------- [ 2023-07-20T09:29:47+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T09:30:16+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T09:30:16+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T09:30:20+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18094' LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18094' , '手刹拉线' , '工程机械设备配件' , 'SCLX' , '叉车' , '根' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.020508s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18094' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18094' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18094' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18094' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18094' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2023-07-20T09:30:31+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.001954s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T09:30:35+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E6%89%8B%E5%88%B9%E6%8B%89%E7%BA%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%手刹拉线%' [ RunTime:0.009766s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%手刹拉线%' limit 0,3000 [ RunTime:13.129883s ] --------------------------------------------------------------- [ 2023-07-20T09:31:04+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.038086s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T09:31:05+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T09:31:21+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18095' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18095' , '手刹拉线' , '运输设备配件' , 'SCLX' , '帅铃T6' , '根' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.024414s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18095' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.008789s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18095' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18095' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.026367s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18095' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18095' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2023-07-20T09:31:36+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E6%89%8B%E5%88%B9%E6%8B%89%E7%BA%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.008789s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.005859s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%手刹拉线%' [ RunTime:0.011719s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%手刹拉线%' limit 0,3000 [ RunTime:13.664063s ] --------------------------------------------------------------- [ 2023-07-20T09:53:45+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026368s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%轴承%' [ RunTime:0.009766s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%轴承%' limit 0,3000 [ RunTime:13.886719s ] --------------------------------------------------------------- [ 2023-07-20T09:58:15+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.037109s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.003906s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T09:58:29+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T09:58:30+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.012696s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T09:58:45+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.047852s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18096' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18096' , '轴承' , '其他辅料' , 'ZC' , '32211' , '盘' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.014648s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18096' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18096' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18096' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.004883s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18096' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.004883s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18096' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2023-07-20T09:59:00+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.012696s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%轴承%' [ RunTime:0.009766s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%轴承%' limit 0,3000 [ RunTime:13.495118s ] --------------------------------------------------------------- [ 2023-07-20T10:00:30+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.041015s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.003906s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.032227s ] --------------------------------------------------------------- [ 2023-07-20T10:00:51+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T10:00:52+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T10:01:15+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.005860s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18097' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18097' , '轴承' , '其他辅料' , 'ZC' , '32208' , '盘' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.019531s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18097' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18097' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18097' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18097' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18097' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2023-07-20T10:01:28+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T10:01:30+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.018554s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%轴承%' [ RunTime:0.009765s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%轴承%' limit 0,3000 [ RunTime:13.536133s ] --------------------------------------------------------------- [ 2023-07-20T10:01:44+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028321s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2023-07-20T10:01:45+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.004882s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T10:02:03+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.044921s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18098' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18098' , '轴承' , '其他辅料' , 'ZC' , '32014' , '盘' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.023437s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18098' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18098' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18098' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18098' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18098' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T10:02:18+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.041992s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%轴承%' [ RunTime:0.010742s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%轴承%' limit 0,3000 [ RunTime:13.460938s ] --------------------------------------------------------------- [ 2023-07-20T11:13:55+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.013672s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T11:14:24+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.055664s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T11:14:25+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T11:14:47+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.033203s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.025390s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18099' LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18099' , '轴承' , '其他辅料' , 'ZC' , '30305' , '盘' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.050781s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18099' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18099' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18099' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18099' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18099' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2023-07-20T11:15:03+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%轴承%' [ RunTime:0.009766s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%轴承%' limit 0,3000 [ RunTime:13.857422s ] --------------------------------------------------------------- [ 2023-07-20T11:18:07+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E7%81%AF%E7%AC%BC%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%灯笼轴承%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%灯笼轴承%' limit 0,3000 [ RunTime:13.336914s ] --------------------------------------------------------------- [ 2023-07-20T11:18:28+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%轴承%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%轴承%' limit 0,3000 [ RunTime:13.353516s ] --------------------------------------------------------------- [ 2023-07-20T11:19:51+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.017578s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.004883s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T11:20:07+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.037109s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T11:20:07+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003907s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T11:20:32+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.037109s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18100' LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18100' , '灯笼轴承' , '其他辅料' , 'DLZC' , '6003' , '盘' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.020508s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18100' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18100' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18100' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18100' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18100' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2023-07-20T11:20:50+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%轴承%' [ RunTime:0.009766s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%轴承%' limit 0,3000 [ RunTime:16.941406s ] --------------------------------------------------------------- [ 2023-07-20T11:20:54+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E6%8E%A8%E5%8A%9B%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.002929s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%推力轴承%' [ RunTime:0.009765s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%推力轴承%' limit 0,3000 [ RunTime:13.377930s ] --------------------------------------------------------------- [ 2023-07-20T11:21:13+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.019532s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%轴承%' [ RunTime:0.010743s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%轴承%' limit 0,3000 [ RunTime:13.211914s ] --------------------------------------------------------------- [ 2023-07-20T11:23:21+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T11:23:47+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T11:23:48+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.022460s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T11:24:05+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.016602s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.038086s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18101' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18101' , '轴承' , '其他辅料' , 'ZC' , '140-5档' , '盘' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.015625s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18101' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18101' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18101' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18101' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18101' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2023-07-20T11:24:20+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%轴承%' [ RunTime:0.010742s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%轴承%' limit 0,3000 [ RunTime:13.375000s ] --------------------------------------------------------------- [ 2023-07-20T11:30:40+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.033204s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.040039s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.002929s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T11:30:54+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.024414s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.002929s ] --------------------------------------------------------------- [ 2023-07-20T11:30:55+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027343s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.002930s ] --------------------------------------------------------------- [ 2023-07-20T11:31:10+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.035156s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014648s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18102' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18102' , '轴承' , '其他辅料' , 'ZC' , '32314' , '盘' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.022461s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18102' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18102' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18102' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18102' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18102' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2023-07-20T11:31:14+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/goods_info.html [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.035157s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.020507s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `id` = 0 LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT depot.depotname AS depotname, IFNULL(S1.startdepot,0) AS startdepot, IFNULL(S1.startprice,0) AS startprice, IFNULL(S1.startmoney,0) AS startmoney, S1.position AS position FROM depot LEFT OUTER JOIN (SELECT * FROM `start` WHERE goodscode='' ) AS S1 ON depot.depotname = S1.depotname [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'units' ORDER BY `sort` ASC [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT `goodscode` FROM `goods` WHERE `goodscode` LIKE 'G1%' ORDER BY `goodscode` DESC LIMIT 1 [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T11:31:26+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%轴承%' [ RunTime:0.011719s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%轴承%' limit 0,3000 [ RunTime:13.549804s ] --------------------------------------------------------------- [ 2023-07-20T11:31:28+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goodscategory/showtree.html?type=goods [ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027343s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T11:31:29+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goodscategory/getdata.html [ sql ] [ DB ] CONNECT:[ UseTime:0.012695s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goodscategory` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `goodscategory` [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T11:31:43+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/goods/save_goods.html [ sql ] [ DB ] CONNECT:[ UseTime:0.020507s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.027344s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `goods` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `goods` WHERE `goodscode` = 'G18103' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `goods` (`goodscode` , `goodsname` , `goodscategory` , `pym` , `specification` , `unit` , `barcode` , `barcodeimg` , `manufacturer` , `inprice` , `saleprice` , `upperlimit` , `downlimit` , `goodsallocation` , `picture` , `note` , `erweima` , `ewmimg` , `field1` , `field2` , `field3` , `field4` , `field5`) VALUES ('G18103' , '轴承' , '其他辅料' , 'ZC' , '30613' , '盘' , '' , '' , '' , 0 , 0 , 20 , 0 , '' , '' , '' , '' , '' , '' , '' , '' , '' , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `start` [ RunTime:0.029297s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18103' , '纸浆厂仓库' , 0 , 0 , 0 , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18103' , '嘎西货场' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18103' , '铅锌矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000976s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18103' , '铜矿仓库' , 0 , 0 , 0 , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] INSERT INTO `start` (`goodscode` , `depotname` , `startdepot` , `startprice` , `startmoney` , `position`) VALUES ('G18103' , '嘎西仓储' , 0 , 0 , 0 , '') [ RunTime:0.000000s ] --------------------------------------------------------------- [ 2023-07-20T11:31:58+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=3000&field=goodsname&value=%E8%BD%B4%E6%89%BF&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.004883s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%轴承%' [ RunTime:0.009765s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%轴承%' limit 0,3000 [ RunTime:13.207031s ] --------------------------------------------------------------- [ 2023-07-20T14:02:11+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/dataquery/stock_search.html [ sql ] [ DB ] CONNECT:[ UseTime:0.053711s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.037109s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'stock' AND `show` = 1 ORDER BY `showid` [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T14:02:25+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.014648s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.019531s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '全部仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:13.584961s ] --------------------------------------------------------------- [ 2023-07-20T14:03:05+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&enddate=&field=goodsname&value=%E7%94%B5%E8%A1%A8%E7%AE%B1&zero=false&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.062500s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.034180s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%电表箱%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%电表箱%' limit 0,90 [ RunTime:13.298828s ] --------------------------------------------------------------- [ 2023-07-20T15:54:48+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&enddate=&field=goodsname&value=%E7%94%B5%E8%A1%A8&zero=false&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.006836s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.036133s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%电表%' [ RunTime:0.009765s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%电表%' limit 0,90 [ RunTime:13.385743s ] --------------------------------------------------------------- [ 2023-07-20T16:42:41+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/dataquery/stock_data.html?page=1&limit=90&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&enddate=&field=goodsname&value=%E4%BA%92%E6%84%9F%E5%99%A8&zero=false&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.040039s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%互感器%' [ RunTime:0.009766s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%互感器%' limit 0,90 [ RunTime:13.855468s ] --------------------------------------------------------------- [ 2023-07-20T16:46:30+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ sql ] [ DB ] CONNECT:[ UseTime:0.040039s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.029296s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-07-01' AND '2023-07-20' AND `depotname` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.030274s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-07-01' AND '2023-07-20' AND `depotname` = '铅锌矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.055664s ] --------------------------------------------------------------- [ 2023-07-20T16:46:40+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/bill/bill_info.html?type=CG [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.010742s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.021485s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = '' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'CG' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = '' [ RunTime:0.152343s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.002930s ] [ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE `makedate` = '2023-07-20' AND `type` = '采购入库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.038085s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.029297s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T16:46:50+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/custom/select_custom.html?dw=%E4%BE%9B%E5%BA%94%E5%95%86 [ sql ] [ DB ] CONNECT:[ UseTime:0.041016s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.038086s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'custom' AND `show` = 1 ORDER BY `showid` [ RunTime:0.003906s ] --------------------------------------------------------------- [ 2023-07-20T16:46:50+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/custom/selectcustom_data.html?dw=%E4%BE%9B%E5%BA%94%E5%95%86&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.017579s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `custom` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `custom` WHERE `type` LIKE '%供应商%' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT * FROM `custom` WHERE `type` LIKE '%供应商%' ORDER BY `id` DESC LIMIT 0,90 [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T16:47:41+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%85%A5%E5%BA%93&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93 [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.032227s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2023-07-20T16:47:55+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022460s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.016602s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:13.126953s ] --------------------------------------------------------------- [ 2023-07-20T16:48:07+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E7%9F%BF%E6%B3%89%E6%B0%B4&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.005859s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.067383s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%矿泉水%' [ RunTime:0.008789s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%矿泉水%' limit 0,90 [ RunTime:13.887695s ] --------------------------------------------------------------- [ 2023-07-20T16:48:21+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodsname&value=%E7%9F%BF%E6%B3%89%E6%B0%B4&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.014649s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodsname like '%矿泉水%' [ RunTime:0.009766s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodsname like '%矿泉水%' limit 0,90 [ RunTime:13.086914s ] --------------------------------------------------------------- [ 2023-07-20T16:49:03+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/bill/save_bill.html [ sql ] [ DB ] CONNECT:[ UseTime:0.041016s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'CG-2023-07-20-0001' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `custname` , `operator` , `originalcode` , `note`) VALUES ('采购入库' , '入库' , '2023-07-20 16:46:40' , 'CG-2023-07-20-0001' , '2023-07-20' , 'WYH' , '2023-07-20' , '铅锌矿仓库' , '嘎西芳芳' , 'WYH' , '' , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.029297s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G16828' , '小件矿泉水' , '小件' , '件' , 18 , 4 , 72 , '' , 18 , 'CG-2023-07-20-0001' , 1) [ RunTime:0.001953s ] --------------------------------------------------------------- [ 2023-07-20T16:49:05+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E9%87%87%E8%B4%AD%E5%85%A5%E5%BA%93&page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&custname=&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ sql ] [ DB ] CONNECT:[ UseTime:0.003907s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-07-01' AND '2023-07-20' AND `depotname` = '铅锌矿仓库' LIMIT 1 [ RunTime:0.040039s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '采购入库' AND `adddate` BETWEEN '2023-07-01' AND '2023-07-20' AND `depotname` = '铅锌矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.074219s ] --------------------------------------------------------------- [ 2023-07-20T17:04:38+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/bill/billshow.html?type=DC [ sql ] [ DB ] CONNECT:[ UseTime:0.066407s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.044922s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.002929s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.018554s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'DC' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fieldshow` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `fieldshow` WHERE `tablename` = 'dcbill' AND `show` = 1 ORDER BY `showid` [ RunTime:0.004883s ] --------------------------------------------------------------- [ 2023-07-20T17:04:39+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.013671s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022460s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.016601s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-07-01' AND '2023-07-20' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') LIMIT 1 [ RunTime:0.028320s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-07-01' AND '2023-07-20' AND `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.072265s ] --------------------------------------------------------------- [ 2023-07-20T17:04:56+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&depotname1=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.014649s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-07-01' AND '2023-07-20' AND `depotname` = '铅锌矿仓库' AND `depotname1` = '铜矿仓库' LIMIT 1 [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-07-01' AND '2023-07-20' AND `depotname` = '铅锌矿仓库' AND `depotname1` = '铜矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.057617s ] --------------------------------------------------------------- [ 2023-07-20T17:05:01+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/bill/bill_info.html?type=DC [ sql ] [ DB ] CONNECT:[ UseTime:0.011719s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.020508s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.021484s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = '' LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'DC' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = '' [ RunTime:0.128906s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.003907s ] [ sql ] [ SQL ] SELECT `billcode` FROM `bill` WHERE `makedate` = '2023-07-20' AND `type` = '调出仓库' ORDER BY `billid` DESC LIMIT 1 [ RunTime:0.038086s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001954s ] --------------------------------------------------------------- [ 2023-07-20T17:05:23+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/select_goods.html?inorout=%E5%87%BA%E5%BA%93&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93 [ sql ] [ DB ] CONNECT:[ UseTime:0.016602s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.030273s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] --------------------------------------------------------------- [ 2023-07-20T17:05:37+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90 [ sql ] [ DB ] CONNECT:[ UseTime:0.003906s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023438s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 [ RunTime:0.015625s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 limit 0,90 [ RunTime:13.083985s ] --------------------------------------------------------------- [ 2023-07-20T17:05:52+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodscode&value=17862&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.023437s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001954s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.022460s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%17862%' [ RunTime:0.006836s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodscode like '%17862%' limit 0,90 [ RunTime:13.772461s ] --------------------------------------------------------------- [ 2023-07-20T17:06:18+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/goods/selectgoods_data.html?depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&page=1&limit=90&field=goodscode&value=11191&goodscategory= [ sql ] [ DB ] CONNECT:[ UseTime:0.031250s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.025390s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] select id from goods where 1=1 and goodscode like '%11191%' [ RunTime:0.004883s ] [ sql ] [ SQL ] select * from(SELECT goods.*, '铅锌矿仓库' as depotname, IFNULL(t_num,0) AS t_num, IFNULL(t_price,0) AS t_price, IFNULL(t_money,0) AS t_money FROM goods LEFT OUTER JOIN ( SELECT goodscode, case WHEN sum(number * sign) = -0 THEN 0 ELSE sum(number * sign) END AS t_num, CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_price, sum(number * sign) * CASE WHEN sum(number * sign) = 0 THEN 0 ELSE sum(cbprice * sign * number) / sum(number * sign) END AS t_money FROM s_goodsnum1 WHERE adddate <= '2023-07-20' and depotname='铅锌矿仓库' GROUP BY goodscode ) AS depot ON depot.goodscode = goods.goodscode ) as S3 where 1=1 and goodscode like '%11191%' limit 0,90 [ RunTime:13.159179s ] --------------------------------------------------------------- [ 2023-07-20T17:06:56+08:00 ] 114.129.26.71 POST 103.45.248.127:8001/index/bill/save_bill.html [ sql ] [ DB ] CONNECT:[ UseTime:0.065430s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.031250s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.018555s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.035156s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'DC-2023-07-20-0001' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `depotname1` , `operator` , `originalcode` , `note`) VALUES ('调出仓库' , '出库' , '2023-07-20 17:05:01' , 'DC-2023-07-20-0001' , '2023-07-20' , 'WYH' , '2023-07-20' , '铅锌矿仓库' , '铜矿仓库' , 'WYH' , '' , '') [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `s_goodsnum` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE `depotname` = '铅锌矿仓库' AND `goodscode` = 'G17862' GROUP BY `goodscode` [ RunTime:8.689453s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.054688s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17862' , '电流互感器 ' , '30/300/5' , '个' , 85 , 3 , 255 , '' , 85 , 'DC-2023-07-20-0001' , -1) [ RunTime:0.001953s ] [ sql ] [ SQL ] SELECT IFNULL(sum(number*sign),0) AS t_num FROM `s_goodsnum` WHERE `depotname` = '铅锌矿仓库' AND `goodscode` = 'G11191' GROUP BY `goodscode` [ RunTime:7.450195s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G11191' , '三相电表' , '3*1.5（6）A' , '个' , 89 , 1 , 89 , '' , 89 , 'DC-2023-07-20-0001' , -1) [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `bill` (`type` , `inorout` , `newtime` , `billcode` , `makedate` , `maker` , `adddate` , `depotname` , `depotname1` , `operator` , `originalcode` , `note`) VALUES ('调入仓库' , '入库' , '2023-07-20 17:05:01' , 'DR-2023-07-20-0001' , '2023-07-20' , 'WYH' , '2023-07-20' , '铜矿仓库' , '铅锌矿仓库' , 'WYH' , '' , '') [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G17862' , '电流互感器 ' , '30/300/5' , '个' , 85 , 3 , 255 , '' , 85 , 'DR-2023-07-20-0001' , 1) [ RunTime:0.001953s ] [ sql ] [ SQL ] INSERT INTO `billdetail` (`goodscode` , `goodsname` , `specification` , `unit` , `price` , `number` , `money` , `detailnote` , `cbprice` , `billcode` , `sign`) VALUES ('G11191' , '三相电表' , '3*1.5（6）A' , '个' , 89 , 1 , 89 , '' , 89 , 'DR-2023-07-20-0001' , 1) [ RunTime:0.000976s ] --------------------------------------------------------------- [ 2023-07-20T17:06:58+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/bill/bill_data.html?type=%E8%B0%83%E5%87%BA%E4%BB%93%E5%BA%93&page=1&limit=90&startdate=&enddate=&depotname=%E9%93%85%E9%94%8C%E7%9F%BF%E4%BB%93%E5%BA%93&depotname1=%E9%93%9C%E7%9F%BF%E4%BB%93%E5%BA%93&billcode=&originalcode=&checkstatus=&operator=&maker=¬e= [ sql ] [ DB ] CONNECT:[ UseTime:0.013672s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.022461s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.000976s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.017578s ] [ sql ] [ SQL ] SELECT COUNT(billid) AS tp_count FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-07-01' AND '2023-07-20' AND `depotname` = '铅锌矿仓库' AND `depotname1` = '铜矿仓库' LIMIT 1 [ RunTime:0.035157s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `type` = '调出仓库' AND `adddate` BETWEEN '2023-07-01' AND '2023-07-20' AND `depotname` = '铅锌矿仓库' AND `depotname1` = '铜矿仓库' ORDER BY `billid` DESC LIMIT 0,90 [ RunTime:0.063477s ] --------------------------------------------------------------- [ 2023-07-20T17:07:21+08:00 ] 114.129.26.71 GET 103.45.248.127:8001/index/bill/bill_info.html?action=look&type=DC&billcode=DC-2023-07-20-0001 [ sql ] [ DB ] CONNECT:[ UseTime:0.015625s ] mysql:host=127.0.0.1;dbname=yck_sczz;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `softinfo` [ RunTime:0.026367s ] [ sql ] [ SQL ] SELECT * FROM `softinfo` LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `depot` [ RunTime:0.019532s ] [ sql ] [ SQL ] SELECT `depotname` FROM `depot` WHERE `depotname` IN ('纸浆厂仓库','铅锌矿仓库','铜矿仓库','嘎西仓储') ORDER BY `id` DESC [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `bill` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `bill` WHERE `billcode` = 'DC-2023-07-20-0001' LIMIT 1 [ RunTime:0.000977s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `configuration` [ RunTime:0.015625s ] [ sql ] [ SQL ] SELECT * FROM `configuration` WHERE `billtype` = 'DC' LIMIT 1 [ RunTime:0.001953s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `billdetail` [ RunTime:0.074219s ] [ sql ] [ SQL ] SELECT * FROM `billdetail` WHERE `billcode` = 'DC-2023-07-20-0001' [ RunTime:0.145508s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `other` [ RunTime:0.016602s ] [ sql ] [ SQL ] SELECT * FROM `other` WHERE `type` = 'department' ORDER BY `sort` ASC [ RunTime:0.002930s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `employee` [ RunTime:0.019531s ] [ sql ] [ SQL ] SELECT * FROM `employee` [ RunTime:0.001953s ]