jianglong
/
server_ahbcqz
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
安徽博创起重服务端程序
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
33 Commits
1 Branch
0 Tags
86 MiB
 
 
 
 
 
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
server_ahbcqz/runtime/shop/log/202305/18.log

526 lines
79 KiB
Raw Permalink Blame History

[2023-05-18T09:44:08+08:00][sql] CONNECT:[ UseTime:0.055969s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.036412s ]
[2023-05-18T09:44:08+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.034230s ]
[2023-05-18T09:44:08+08:00][sql] SELECT * FROM `ls_dev_shop_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.035261s ]
[2023-05-18T09:44:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.036592s ]
[2023-05-18T09:44:08+08:00][sql] SELECT `name` FROM `ls_shop_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.035141s ]
[2023-05-18T09:44:10+08:00][sql] CONNECT:[ UseTime:0.095408s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.069373s ]
[2023-05-18T09:44:10+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.083464s ]
[2023-05-18T09:44:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.127260s ]
[2023-05-18T09:44:10+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.128233s ]
[2023-05-18T09:44:10+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 [ RunTime:0.106633s ]
[2023-05-18T09:44:10+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684339200 AND 1684425599 [ RunTime:0.077024s ]
[2023-05-18T09:44:10+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.047671s ]
[2023-05-18T09:44:10+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 [ RunTime:0.047585s ]
[2023-05-18T09:44:10+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684339200 AND 1684425599 [ RunTime:0.047814s ]
[2023-05-18T09:44:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.064397s ]
[2023-05-18T09:44:10+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 GROUP BY `ip` ) `_group_count_` [ RunTime:0.110060s ]
[2023-05-18T09:44:10+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.116215s ]
[2023-05-18T09:44:10+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684339200 AND 1684425599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.087113s ]
[2023-05-18T09:44:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.082789s ]
[2023-05-18T09:44:10+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 3 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.080930s ]
[2023-05-18T09:44:10+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.088703s ]
[2023-05-18T09:44:10+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684339200 AND 1684425599 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.084996s ]
[2023-05-18T09:44:12+08:00][sql] CONNECT:[ UseTime:0.048327s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.065799s ]
[2023-05-18T09:44:12+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.030618s ]
[2023-05-18T09:44:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.034719s ]
[2023-05-18T09:44:12+08:00][sql] SELECT goods_id,count(DISTINCT user_id) as visited_num FROM `ls_goods_click` WHERE `shop_id` = 3 GROUP BY `goods_id` ORDER BY `visited_num` DESC LIMIT 5 [ RunTime:0.032894s ]
[2023-05-18T09:44:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.033531s ]
[2023-05-18T09:44:12+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 9 LIMIT 1 [ RunTime:0.030552s ]
[2023-05-18T09:44:12+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 11 LIMIT 1 [ RunTime:0.030940s ]
[2023-05-18T09:44:12+08:00][sql] CONNECT:[ UseTime:0.107139s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.060087s ]
[2023-05-18T09:44:12+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.060272s ]
[2023-05-18T09:44:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.060677s ]
[2023-05-18T09:44:12+08:00][sql] SELECT sum(o.order_amount) as order_amount,`og`.`goods_id` FROM `ls_order` `o` INNER JOIN `ls_order_goods` `og` ON `og`.`order_id`=`o`.`id` WHERE `o`.`shop_id` = 3 AND `o`.`pay_status` > 0 GROUP BY `og`.`goods_id` ORDER BY `order_amount` DESC LIMIT 5 [ RunTime:0.057909s ]
[2023-05-18T09:44:12+08:00][sql] CONNECT:[ UseTime:0.080435s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.050124s ]
[2023-05-18T09:44:12+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.047286s ]
[2023-05-18T09:44:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.049689s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683043200 AND 1683129599 AND `pay_status` > 0 [ RunTime:0.048327s ]
[2023-05-18T09:44:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.049719s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683043200 AND 1683129599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047476s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683129600 AND 1683215999 AND `pay_status` > 0 [ RunTime:0.050537s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.069578s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683216000 AND 1683302399 AND `pay_status` > 0 [ RunTime:0.087535s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683216000 AND 1683302399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.048616s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683302400 AND 1683388799 AND `pay_status` > 0 [ RunTime:0.049663s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683302400 AND 1683388799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.049700s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683388800 AND 1683475199 AND `pay_status` > 0 [ RunTime:0.048323s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683388800 AND 1683475199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047256s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683475200 AND 1683561599 AND `pay_status` > 0 [ RunTime:0.049550s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683475200 AND 1683561599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.048674s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683561600 AND 1683647999 AND `pay_status` > 0 [ RunTime:0.054017s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683561600 AND 1683647999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.068652s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683648000 AND 1683734399 AND `pay_status` > 0 [ RunTime:0.049487s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683648000 AND 1683734399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.076012s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683734400 AND 1683820799 AND `pay_status` > 0 [ RunTime:0.048686s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047792s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683820800 AND 1683907199 AND `pay_status` > 0 [ RunTime:0.047207s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047456s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683907200 AND 1683993599 AND `pay_status` > 0 [ RunTime:0.054517s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683907200 AND 1683993599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047403s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683993600 AND 1684079999 AND `pay_status` > 0 [ RunTime:0.050076s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683993600 AND 1684079999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.053541s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684080000 AND 1684166399 AND `pay_status` > 0 [ RunTime:0.063390s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684080000 AND 1684166399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047568s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684166400 AND 1684252799 AND `pay_status` > 0 [ RunTime:0.059650s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684166400 AND 1684252799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.064476s ]
[2023-05-18T09:44:12+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 AND `pay_status` > 0 [ RunTime:0.057438s ]
[2023-05-18T09:44:12+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047841s ]
[2023-05-18T09:44:13+08:00][sql] CONNECT:[ UseTime:0.063566s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.046028s ]
[2023-05-18T09:44:13+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.048424s ]
[2023-05-18T09:44:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.043358s ]
[2023-05-18T09:44:13+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.057324s ]
[2023-05-18T09:44:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.047931s ]
[2023-05-18T09:44:13+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.046791s ]
[2023-05-18T09:44:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.091466s ]
[2023-05-18T09:44:13+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.083915s ]
[2023-05-18T09:44:14+08:00][sql] CONNECT:[ UseTime:0.116115s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.045260s ]
[2023-05-18T09:44:14+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.045845s ]
[2023-05-18T09:44:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.050660s ]
[2023-05-18T09:44:14+08:00][sql] SELECT * FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.068528s ]
[2023-05-18T09:44:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) [ RunTime:0.107020s ]
[2023-05-18T09:44:20+08:00][sql] CONNECT:[ UseTime:0.065112s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.045459s ]
[2023-05-18T09:44:20+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.042750s ]
[2023-05-18T09:44:22+08:00][sql] CONNECT:[ UseTime:0.087773s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.074211s ]
[2023-05-18T09:44:22+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.058810s ]
[2023-05-18T09:44:22+08:00][sql] CONNECT:[ UseTime:0.050948s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.036168s ]
[2023-05-18T09:44:22+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.036315s ]
[2023-05-18T09:44:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.035188s ]
[2023-05-18T09:44:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.033174s ]
[2023-05-18T09:44:22+08:00][sql] SELECT * FROM `ls_freight` WHERE `shop_id` = 3 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.034115s ]
[2023-05-18T09:44:26+08:00][sql] CONNECT:[ UseTime:0.052217s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.036709s ]
[2023-05-18T09:44:26+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.040359s ]
[2023-05-18T09:44:56+08:00][sql] CONNECT:[ UseTime:0.183072s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.468636s ]
[2023-05-18T09:44:56+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.048893s ]
[2023-05-18T09:44:56+08:00][sql] SELECT * FROM `ls_dev_shop_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.050350s ]
[2023-05-18T09:44:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.053946s ]
[2023-05-18T09:44:56+08:00][sql] SELECT `name` FROM `ls_shop_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.049798s ]
[2023-05-18T09:44:58+08:00][sql] CONNECT:[ UseTime:0.178709s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.129826s ]
[2023-05-18T09:44:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.117744s ]
[2023-05-18T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.121568s ]
[2023-05-18T09:44:58+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.121209s ]
[2023-05-18T09:44:58+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 [ RunTime:0.123280s ]
[2023-05-18T09:44:58+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684339200 AND 1684425599 [ RunTime:0.080224s ]
[2023-05-18T09:44:58+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.060643s ]
[2023-05-18T09:44:58+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 [ RunTime:0.066166s ]
[2023-05-18T09:44:58+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684339200 AND 1684425599 [ RunTime:0.086979s ]
[2023-05-18T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.117485s ]
[2023-05-18T09:44:58+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 GROUP BY `ip` ) `_group_count_` [ RunTime:0.129018s ]
[2023-05-18T09:44:58+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.124959s ]
[2023-05-18T09:44:58+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684339200 AND 1684425599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.095976s ]
[2023-05-18T09:44:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.061795s ]
[2023-05-18T09:44:58+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 3 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.061414s ]
[2023-05-18T09:44:58+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.060434s ]
[2023-05-18T09:44:58+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684339200 AND 1684425599 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.060442s ]
[2023-05-18T09:44:59+08:00][sql] CONNECT:[ UseTime:0.090162s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.066756s ]
[2023-05-18T09:44:59+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.056317s ]
[2023-05-18T09:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.064329s ]
[2023-05-18T09:44:59+08:00][sql] SELECT sum(o.order_amount) as order_amount,`og`.`goods_id` FROM `ls_order` `o` INNER JOIN `ls_order_goods` `og` ON `og`.`order_id`=`o`.`id` WHERE `o`.`shop_id` = 3 AND `o`.`pay_status` > 0 GROUP BY `og`.`goods_id` ORDER BY `order_amount` DESC LIMIT 5 [ RunTime:0.082926s ]
[2023-05-18T09:44:59+08:00][sql] CONNECT:[ UseTime:0.080590s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.061699s ]
[2023-05-18T09:44:59+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.049186s ]
[2023-05-18T09:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.053169s ]
[2023-05-18T09:44:59+08:00][sql] SELECT goods_id,count(DISTINCT user_id) as visited_num FROM `ls_goods_click` WHERE `shop_id` = 3 GROUP BY `goods_id` ORDER BY `visited_num` DESC LIMIT 5 [ RunTime:0.075744s ]
[2023-05-18T09:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.057273s ]
[2023-05-18T09:44:59+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 9 LIMIT 1 [ RunTime:0.039882s ]
[2023-05-18T09:44:59+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 11 LIMIT 1 [ RunTime:0.039720s ]
[2023-05-18T09:45:01+08:00][sql] CONNECT:[ UseTime:0.088370s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.066970s ]
[2023-05-18T09:45:01+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.055896s ]
[2023-05-18T09:45:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.063641s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683043200 AND 1683129599 AND `pay_status` > 0 [ RunTime:0.083386s ]
[2023-05-18T09:45:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.047541s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683043200 AND 1683129599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.046032s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683129600 AND 1683215999 AND `pay_status` > 0 [ RunTime:0.047257s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045526s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683216000 AND 1683302399 AND `pay_status` > 0 [ RunTime:0.045917s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683216000 AND 1683302399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045519s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683302400 AND 1683388799 AND `pay_status` > 0 [ RunTime:0.050076s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683302400 AND 1683388799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.048716s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683388800 AND 1683475199 AND `pay_status` > 0 [ RunTime:0.068010s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683388800 AND 1683475199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.046080s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683475200 AND 1683561599 AND `pay_status` > 0 [ RunTime:0.047122s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683475200 AND 1683561599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045859s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683561600 AND 1683647999 AND `pay_status` > 0 [ RunTime:0.056004s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683561600 AND 1683647999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.077914s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683648000 AND 1683734399 AND `pay_status` > 0 [ RunTime:0.089562s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683648000 AND 1683734399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.083603s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683734400 AND 1683820799 AND `pay_status` > 0 [ RunTime:0.080584s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047785s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683820800 AND 1683907199 AND `pay_status` > 0 [ RunTime:0.046461s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.093556s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683907200 AND 1683993599 AND `pay_status` > 0 [ RunTime:0.060055s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683907200 AND 1683993599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052696s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683993600 AND 1684079999 AND `pay_status` > 0 [ RunTime:0.109603s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683993600 AND 1684079999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.073058s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684080000 AND 1684166399 AND `pay_status` > 0 [ RunTime:0.048380s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684080000 AND 1684166399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.049382s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684166400 AND 1684252799 AND `pay_status` > 0 [ RunTime:0.047698s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684166400 AND 1684252799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.051882s ]
[2023-05-18T09:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 AND `pay_status` > 0 [ RunTime:0.061806s ]
[2023-05-18T09:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.099980s ]
[2023-05-18T09:45:27+08:00][sql] CONNECT:[ UseTime:0.046300s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.033936s ]
[2023-05-18T09:45:27+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.032293s ]
[2023-05-18T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.032543s ]
[2023-05-18T09:45:27+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.041485s ]
[2023-05-18T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.036462s ]
[2023-05-18T09:45:27+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.031380s ]
[2023-05-18T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.032216s ]
[2023-05-18T09:45:27+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.039169s ]
[2023-05-18T09:45:27+08:00][sql] CONNECT:[ UseTime:0.078117s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.083234s ]
[2023-05-18T09:45:27+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.076779s ]
[2023-05-18T09:45:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.063085s ]
[2023-05-18T09:45:27+08:00][sql] SELECT * FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.055675s ]
[2023-05-18T09:45:27+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) [ RunTime:0.052632s ]
[2023-05-18T09:45:29+08:00][sql] CONNECT:[ UseTime:0.083336s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.091746s ]
[2023-05-18T09:45:29+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.093907s ]
[2023-05-18T09:45:29+08:00][sql] SELECT * FROM `ls_dev_shop_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.052797s ]
[2023-05-18T09:45:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.041677s ]
[2023-05-18T09:45:29+08:00][sql] SELECT `name` FROM `ls_shop_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.041658s ]
[2023-05-18T09:45:30+08:00][sql] CONNECT:[ UseTime:0.097482s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.096716s ]
[2023-05-18T09:45:30+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.064772s ]
[2023-05-18T09:45:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.066984s ]
[2023-05-18T09:45:30+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.059885s ]
[2023-05-18T09:45:30+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 [ RunTime:0.060377s ]
[2023-05-18T09:45:30+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684339200 AND 1684425599 [ RunTime:0.060520s ]
[2023-05-18T09:45:30+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.059968s ]
[2023-05-18T09:45:30+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 [ RunTime:0.062095s ]
[2023-05-18T09:45:30+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684339200 AND 1684425599 [ RunTime:0.064537s ]
[2023-05-18T09:45:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.065757s ]
[2023-05-18T09:45:30+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 GROUP BY `ip` ) `_group_count_` [ RunTime:0.062886s ]
[2023-05-18T09:45:30+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.072103s ]
[2023-05-18T09:45:30+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684339200 AND 1684425599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.062309s ]
[2023-05-18T09:45:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.069825s ]
[2023-05-18T09:45:30+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 3 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.071242s ]
[2023-05-18T09:45:30+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.080522s ]
[2023-05-18T09:45:30+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684339200 AND 1684425599 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.060401s ]
[2023-05-18T09:45:31+08:00][sql] CONNECT:[ UseTime:0.098213s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.067596s ]
[2023-05-18T09:45:31+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.062436s ]
[2023-05-18T09:45:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.198442s ]
[2023-05-18T09:45:31+08:00][sql] SELECT sum(o.order_amount) as order_amount,`og`.`goods_id` FROM `ls_order` `o` INNER JOIN `ls_order_goods` `og` ON `og`.`order_id`=`o`.`id` WHERE `o`.`shop_id` = 3 AND `o`.`pay_status` > 0 GROUP BY `og`.`goods_id` ORDER BY `order_amount` DESC LIMIT 5 [ RunTime:0.061520s ]
[2023-05-18T09:45:31+08:00][sql] CONNECT:[ UseTime:0.087272s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.063191s ]
[2023-05-18T09:45:31+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.055860s ]
[2023-05-18T09:45:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.058643s ]
[2023-05-18T09:45:31+08:00][sql] SELECT goods_id,count(DISTINCT user_id) as visited_num FROM `ls_goods_click` WHERE `shop_id` = 3 GROUP BY `goods_id` ORDER BY `visited_num` DESC LIMIT 5 [ RunTime:0.057785s ]
[2023-05-18T09:45:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.201480s ]
[2023-05-18T09:45:31+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 9 LIMIT 1 [ RunTime:0.080895s ]
[2023-05-18T09:45:31+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 11 LIMIT 1 [ RunTime:0.057373s ]
[2023-05-18T09:45:32+08:00][sql] CONNECT:[ UseTime:0.068502s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.051277s ]
[2023-05-18T09:45:32+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.049558s ]
[2023-05-18T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.105354s ]
[2023-05-18T09:45:32+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.090040s ]
[2023-05-18T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.075293s ]
[2023-05-18T09:45:32+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.050128s ]
[2023-05-18T09:45:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.065535s ]
[2023-05-18T09:45:32+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.049825s ]
[2023-05-18T09:45:33+08:00][sql] CONNECT:[ UseTime:0.070172s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.078746s ]
[2023-05-18T09:45:33+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.055908s ]
[2023-05-18T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.082781s ]
[2023-05-18T09:45:33+08:00][sql] SELECT * FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.070730s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) [ RunTime:0.065639s ]
[2023-05-18T09:45:33+08:00][sql] CONNECT:[ UseTime:0.072393s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.052365s ]
[2023-05-18T09:45:33+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.054670s ]
[2023-05-18T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.048810s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683043200 AND 1683129599 AND `pay_status` > 0 [ RunTime:0.044670s ]
[2023-05-18T09:45:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.047334s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683043200 AND 1683129599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045115s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683129600 AND 1683215999 AND `pay_status` > 0 [ RunTime:0.045220s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047123s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683216000 AND 1683302399 AND `pay_status` > 0 [ RunTime:0.044990s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683216000 AND 1683302399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045968s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683302400 AND 1683388799 AND `pay_status` > 0 [ RunTime:0.070608s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683302400 AND 1683388799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045342s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683388800 AND 1683475199 AND `pay_status` > 0 [ RunTime:0.045080s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683388800 AND 1683475199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.049465s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683475200 AND 1683561599 AND `pay_status` > 0 [ RunTime:0.055802s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683475200 AND 1683561599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050511s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683561600 AND 1683647999 AND `pay_status` > 0 [ RunTime:0.050465s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683561600 AND 1683647999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.101698s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683648000 AND 1683734399 AND `pay_status` > 0 [ RunTime:0.094343s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683648000 AND 1683734399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.071111s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683734400 AND 1683820799 AND `pay_status` > 0 [ RunTime:0.053722s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.067598s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683820800 AND 1683907199 AND `pay_status` > 0 [ RunTime:0.052037s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045923s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683907200 AND 1683993599 AND `pay_status` > 0 [ RunTime:0.048335s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683907200 AND 1683993599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.051571s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683993600 AND 1684079999 AND `pay_status` > 0 [ RunTime:0.052208s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1683993600 AND 1684079999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.076876s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684080000 AND 1684166399 AND `pay_status` > 0 [ RunTime:0.064690s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684080000 AND 1684166399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.080499s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684166400 AND 1684252799 AND `pay_status` > 0 [ RunTime:0.078744s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684166400 AND 1684252799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.075427s ]
[2023-05-18T09:45:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 AND `pay_status` > 0 [ RunTime:0.104467s ]
[2023-05-18T09:45:33+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1684252800 AND 1684339199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.122236s ]
[2023-05-18T09:45:35+08:00][sql] CONNECT:[ UseTime:0.177533s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.124076s ]
[2023-05-18T09:45:35+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.378382s ]
[2023-05-18T09:45:35+08:00][sql] CONNECT:[ UseTime:0.142923s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.059289s ]
[2023-05-18T09:45:35+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.052241s ]
[2023-05-18T09:45:35+08:00][sql] CONNECT:[ UseTime:0.127420s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.052882s ]
[2023-05-18T09:45:35+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.039731s ]
[2023-05-18T09:45:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.054592s ]
[2023-05-18T09:45:35+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.062382s ]
[2023-05-18T09:45:35+08:00][sql] SELECT * FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 LIMIT 0,10 [ RunTime:0.064870s ]
[2023-05-18T09:45:36+08:00][sql] CONNECT:[ UseTime:0.081324s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.050045s ]
[2023-05-18T09:45:36+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.030372s ]
[2023-05-18T09:45:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.032465s ]
[2023-05-18T09:45:36+08:00][sql] SELECT * FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.046079s ]
[2023-05-18T09:45:36+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.049364s ]
[2023-05-18T09:45:37+08:00][sql] CONNECT:[ UseTime:0.178472s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.117844s ]
[2023-05-18T09:45:37+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.107065s ]
[2023-05-18T09:45:45+08:00][sql] CONNECT:[ UseTime:0.158154s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.070866s ]
[2023-05-18T09:45:45+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.085510s ]
[2023-05-18T09:45:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.059832s ]
[2023-05-18T09:45:45+08:00][sql] SELECT `name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 AND `name` = '运输机' LIMIT 1 [ RunTime:0.081709s ]
[2023-05-18T09:45:45+08:00][sql] INSERT INTO `ls_shop_goods_category` SET `name` = '运输机' , `sort` = 255 , `is_show` = 1 , `remark` = '' , `del` = 0 , `shop_id` = 3 , `create_time` = 1684374345 , `update_time` = 1684374345 [ RunTime:0.092995s ]
[2023-05-18T09:45:46+08:00][sql] CONNECT:[ UseTime:0.071188s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.040682s ]
[2023-05-18T09:45:46+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.034726s ]
[2023-05-18T09:45:46+08:00][sql] CONNECT:[ UseTime:0.074173s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:45:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.055035s ]
[2023-05-18T09:45:46+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.047106s ]
[2023-05-18T09:45:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.066292s ]
[2023-05-18T09:45:46+08:00][sql] SELECT * FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.087261s ]
[2023-05-18T09:45:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.061045s ]
[2023-05-18T09:46:29+08:00][sql] CONNECT:[ UseTime:0.053248s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:46:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.045256s ]
[2023-05-18T09:46:29+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.034190s ]
[2023-05-18T09:46:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.045473s ]
[2023-05-18T09:46:29+08:00][sql] SELECT * FROM `ls_shop_goods_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.043969s ]
[2023-05-18T09:46:32+08:00][sql] CONNECT:[ UseTime:0.072473s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:46:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.050193s ]
[2023-05-18T09:46:32+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.052717s ]
[2023-05-18T09:46:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.053650s ]
[2023-05-18T09:46:32+08:00][sql] SELECT `name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 AND `id` <> 5 AND `name` = '配件产品' LIMIT 1 [ RunTime:0.073353s ]
[2023-05-18T09:46:32+08:00][sql] UPDATE `ls_shop_goods_category` SET `name` = '配件产品' , `sort` = 255 , `is_show` = 1 , `remark` = '' , `del` = 0 , `shop_id` = 3 , `update_time` = 1684374392 WHERE `id` = 5 [ RunTime:0.050866s ]
[2023-05-18T09:46:33+08:00][sql] CONNECT:[ UseTime:0.057875s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:46:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.038784s ]
[2023-05-18T09:46:33+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.036693s ]
[2023-05-18T09:46:34+08:00][sql] CONNECT:[ UseTime:0.072326s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:46:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.063113s ]
[2023-05-18T09:46:34+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.074721s ]
[2023-05-18T09:46:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.095037s ]
[2023-05-18T09:46:34+08:00][sql] SELECT * FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.108964s ]
[2023-05-18T09:46:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.105191s ]
[2023-05-18T09:48:48+08:00][sql] CONNECT:[ UseTime:0.174983s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:48:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.193774s ]
[2023-05-18T09:48:48+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.105333s ]
[2023-05-18T09:48:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.076424s ]
[2023-05-18T09:48:48+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.060383s ]
[2023-05-18T09:48:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.056225s ]
[2023-05-18T09:48:48+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.053131s ]
[2023-05-18T09:48:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.051967s ]
[2023-05-18T09:48:48+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.073106s ]
[2023-05-18T09:48:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.071533s ]
[2023-05-18T09:48:48+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.060819s ]
[2023-05-18T09:48:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.095070s ]
[2023-05-18T09:48:48+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.052883s ]
[2023-05-18T09:48:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.065637s ]
[2023-05-18T09:48:48+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.056768s ]
[2023-05-18T09:49:48+08:00][sql] CONNECT:[ UseTime:0.077902s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:49:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.072513s ]
[2023-05-18T09:49:48+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.066294s ]
[2023-05-18T09:49:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.069746s ]
[2023-05-18T09:49:48+08:00][sql] SELECT * FROM `ls_file_cate` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.052324s ]
[2023-05-18T09:49:48+08:00][sql] CONNECT:[ UseTime:0.050748s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:49:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.054242s ]
[2023-05-18T09:49:48+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.038428s ]
[2023-05-18T09:49:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.035467s ]
[2023-05-18T09:49:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.033916s ]
[2023-05-18T09:49:48+08:00][sql] SELECT `id`,`name`,`cid`,`type`,`uri`,`create_time`,`del`,`shop_id`,`user_id` FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.034556s ]
[2023-05-18T09:49:54+08:00][sql] CONNECT:[ UseTime:0.058266s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.056090s ]
[2023-05-18T09:49:54+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.088123s ]
[2023-05-18T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.063244s ]
[2023-05-18T09:49:54+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.051233s ]
[2023-05-18T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.079341s ]
[2023-05-18T09:49:54+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = '6b2d6de2ea859fabc5372b42431cd706.jpg' , `uri` = 'uploads/images/202305180949544500b8064.jpg' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684374594 [ RunTime:0.063111s ]
[2023-05-18T09:49:54+08:00][sql] CONNECT:[ UseTime:0.069485s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.064510s ]
[2023-05-18T09:49:54+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.095978s ]
[2023-05-18T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.081941s ]
[2023-05-18T09:49:54+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.070464s ]
[2023-05-18T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.100533s ]
[2023-05-18T09:49:54+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = '9614fb3e26388a90df538fdcab3ed564.jpg' , `uri` = 'uploads/images/20230518094954c8e7d1602.jpg' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684374594 [ RunTime:0.064183s ]
[2023-05-18T09:49:54+08:00][sql] CONNECT:[ UseTime:0.078115s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.089286s ]
[2023-05-18T09:49:54+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.083517s ]
[2023-05-18T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.064551s ]
[2023-05-18T09:49:54+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.074454s ]
[2023-05-18T09:49:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.092077s ]
[2023-05-18T09:49:54+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = '288453cc448415def94a3d57475fa4f1.jpg' , `uri` = 'uploads/images/202305180949540f5838572.jpg' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684374594 [ RunTime:0.064146s ]
[2023-05-18T09:49:55+08:00][sql] CONNECT:[ UseTime:0.084904s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:49:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.086569s ]
[2023-05-18T09:49:55+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.055562s ]
[2023-05-18T09:49:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.061581s ]
[2023-05-18T09:49:55+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.067334s ]
[2023-05-18T09:49:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.064284s ]
[2023-05-18T09:49:55+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = 'XiYO7UgUJRDKIEvNL.nQMusiifyO.hd8YOxXSTxtFTsYVzZhG.jpg' , `uri` = 'uploads/images/202305180949550f6460403.jpg' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684374595 [ RunTime:0.055706s ]
[2023-05-18T09:50:10+08:00][sql] CONNECT:[ UseTime:0.100163s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:50:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.051599s ]
[2023-05-18T09:50:10+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.057394s ]
[2023-05-18T09:50:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.071983s ]
[2023-05-18T09:50:10+08:00][sql] SELECT * FROM `ls_file_cate` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.059592s ]
[2023-05-18T09:50:11+08:00][sql] CONNECT:[ UseTime:0.121504s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:50:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.058308s ]
[2023-05-18T09:50:11+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.060074s ]
[2023-05-18T09:50:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.076352s ]
[2023-05-18T09:50:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.078283s ]
[2023-05-18T09:50:11+08:00][sql] SELECT `id`,`name`,`cid`,`type`,`uri`,`create_time`,`del`,`shop_id`,`user_id` FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.064040s ]
[2023-05-18T09:54:50+08:00][sql] CONNECT:[ UseTime:0.094121s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:54:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.064829s ]
[2023-05-18T09:54:50+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.063474s ]
[2023-05-18T09:54:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.064564s ]
[2023-05-18T09:54:50+08:00][sql] SELECT * FROM `ls_file_cate` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 ORDER BY `id` ASC,`sort` DESC [ RunTime:0.062771s ]
[2023-05-18T09:54:50+08:00][sql] CONNECT:[ UseTime:0.076033s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:54:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.064783s ]
[2023-05-18T09:54:50+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.050937s ]
[2023-05-18T09:54:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.054071s ]
[2023-05-18T09:54:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.050653s ]
[2023-05-18T09:54:50+08:00][sql] SELECT `id`,`name`,`cid`,`type`,`uri`,`create_time`,`del`,`shop_id`,`user_id` FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 ORDER BY `id` DESC LIMIT 0,20 [ RunTime:0.052199s ]
[2023-05-18T09:54:55+08:00][sql] CONNECT:[ UseTime:0.050551s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:54:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.036492s ]
[2023-05-18T09:54:55+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.033989s ]
[2023-05-18T09:54:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.036953s ]
[2023-05-18T09:54:55+08:00][sql] SELECT * FROM `ls_goods` WHERE `del` = 0 AND `name` = '泵车/车载泵/拖泵 S管' AND `shop_id` = 3 LIMIT 1 [ RunTime:0.034968s ]
[2023-05-18T09:54:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.036784s ]
[2023-05-18T09:54:55+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.035849s ]
[2023-05-18T09:54:55+08:00][sql] SELECT `is_product_audit` FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.034271s ]
[2023-05-18T09:54:55+08:00][sql] SELECT * FROM `ls_goods` WHERE `code` = 73258256 AND `shop_id` = 3 AND `del` = 0 LIMIT 1 [ RunTime:0.035589s ]
[2023-05-18T09:54:55+08:00][sql] INSERT INTO `ls_goods` SET `type` = 0 , `name` = '泵车/车载泵/拖泵 S管' , `code` = 73258256 , `shop_id` = 3 , `shop_cate_id` = 5 , `first_cate_id` = 6 , `second_cate_id` = 11 , `third_cate_id` = 0 , `unit_id` = 14 , `brand_id` = 0 , `supplier_id` = 0 , `status` = 0 , `image` = 'uploads/images/20230518094954c8e7d1602.jpg' , `video` = '' , `remark` = '泵车/车载泵/拖泵S管，适用于三一重工泵车/车载泵/拖泵各机型' , `content` = '<img src=\"/uploads/images/202305180949550f6460403.jpg\">' , `sort` = 255 , `spec_type` = 2 , `max_price` = '4550' , `min_price` = '4180' , `market_price` = '4180' , `stock` = 3000 , `express_type` = 1 , `express_money` = 0 , `express_template_id` = 0 , `is_recommend` = 0 , `create_time` = 1684374895 , `update_time` = 1684374895 , `stock_warn` = 0 , `poster` = '' , `is_show_stock` = 0 , `is_member` = 1 , `audit_status` = 0 , `delivery_type` = '1' , `after_pay` = 1 , `after_delivery` = 1 , `delivery_content` = '' [ RunTime:0.034588s ]
[2023-05-18T09:54:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.037928s ]
[2023-05-18T09:54:55+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 12 , `uri` = 'uploads/images/20230518094954c8e7d1602.jpg' [ RunTime:0.033684s ]
[2023-05-18T09:54:55+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 12 , `uri` = 'uploads/images/202305180949540f5838572.jpg' [ RunTime:0.039654s ]
[2023-05-18T09:54:55+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 12 , `uri` = 'uploads/images/202305180949544500b8064.jpg' [ RunTime:0.033392s ]
[2023-05-18T09:54:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.035927s ]
[2023-05-18T09:54:55+08:00][sql] INSERT INTO `ls_goods_spec` (`goods_id` , `name`) VALUES ( 12,'S管规格' ) [ RunTime:0.033759s ]
[2023-05-18T09:54:55+08:00][sql] SELECT `name`,`id` FROM `ls_goods_spec` WHERE `goods_id` = 12 AND `name` = 'S管规格' [ RunTime:0.033992s ]
[2023-05-18T09:54:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.036243s ]
[2023-05-18T09:54:55+08:00][sql] INSERT INTO `ls_goods_spec_value` (`goods_id` , `spec_id` , `value`) VALUES ( 12,17,'泵车 S管260/SY5375' ) , ( 12,17,'拖泵S管200/60C1816' ) , ( 12,17,'泵车/车载S管230/C12037' ) [ RunTime:0.033859s ]
[2023-05-18T09:54:55+08:00][sql] SELECT `value`,`id` FROM `ls_goods_spec_value` WHERE `goods_id` = 12 [ RunTime:0.037108s ]
[2023-05-18T09:54:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.036512s ]
[2023-05-18T09:54:55+08:00][sql] INSERT INTO `ls_goods_item` (`spec_value_str` , `market_price` , `price` , `chengben_price` , `stock` , `weight` , `volume` , `bar_code` , `spec_value_ids` , `image` , `goods_id`) VALUES ( '泵车 S管260/SY5375','4550','4550','4550',1000,'10','0.02','','34','',12 ) , ( '拖泵S管200/60C1816','4180','4180','4180',1000,'10','10','','35','',12 ) , ( '泵车/车载S管230/C12037','4200','4200','4200',1000,'10','10','','36','',12 ) [ RunTime:0.037249s ]
[2023-05-18T09:54:57+08:00][sql] CONNECT:[ UseTime:0.067600s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:54:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.048746s ]
[2023-05-18T09:54:57+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.044860s ]
[2023-05-18T09:54:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.048887s ]
[2023-05-18T09:54:57+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.045428s ]
[2023-05-18T09:54:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.047370s ]
[2023-05-18T09:54:57+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.044659s ]
[2023-05-18T09:54:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.051572s ]
[2023-05-18T09:54:57+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.046135s ]
[2023-05-18T09:54:58+08:00][sql] CONNECT:[ UseTime:0.067766s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:54:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.047627s ]
[2023-05-18T09:54:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.045082s ]
[2023-05-18T09:54:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.047800s ]
[2023-05-18T09:54:58+08:00][sql] SELECT * FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.046093s ]
[2023-05-18T09:54:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) [ RunTime:0.046470s ]
[2023-05-18T09:55:01+08:00][sql] CONNECT:[ UseTime:0.060564s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:55:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.039871s ]
[2023-05-18T09:55:01+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.036859s ]
[2023-05-18T09:55:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.039354s ]
[2023-05-18T09:55:01+08:00][sql] SELECT * FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.037360s ]
[2023-05-18T09:55:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 [ RunTime:0.036058s ]
[2023-05-18T09:55:02+08:00][sql] CONNECT:[ UseTime:0.053974s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:55:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.037843s ]
[2023-05-18T09:55:02+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.029636s ]
[2023-05-18T09:55:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.032443s ]
[2023-05-18T09:55:02+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.033189s ]
[2023-05-18T09:55:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.033848s ]
[2023-05-18T09:55:02+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.032828s ]
[2023-05-18T09:55:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.037468s ]
[2023-05-18T09:55:02+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.030143s ]
[2023-05-18T09:55:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.031975s ]
[2023-05-18T09:55:02+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.029471s ]
[2023-05-18T09:55:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.031668s ]
[2023-05-18T09:55:02+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.029700s ]
[2023-05-18T09:55:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.033932s ]
[2023-05-18T09:55:02+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.030193s ]
[2023-05-18T09:55:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.032173s ]
[2023-05-18T09:55:02+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 12 LIMIT 1 [ RunTime:0.032484s ]
[2023-05-18T09:55:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.032874s ]
[2023-05-18T09:55:02+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 12 [ RunTime:0.029797s ]
[2023-05-18T09:55:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.031450s ]
[2023-05-18T09:55:02+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 12 [ RunTime:0.048845s ]
[2023-05-18T09:55:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.031833s ]
[2023-05-18T09:55:02+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 12 [ RunTime:0.041199s ]
[2023-05-18T09:55:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.032194s ]
[2023-05-18T09:55:02+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 12 [ RunTime:0.029912s ]
[2023-05-18T09:55:15+08:00][sql] CONNECT:[ UseTime:0.084559s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:55:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.084265s ]
[2023-05-18T09:55:15+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.054256s ]
[2023-05-18T09:55:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_bargain` [ RunTime:0.062161s ]
[2023-05-18T09:55:15+08:00][sql] SELECT * FROM `ls_bargain` WHERE `goods_id` = 12 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.057231s ]
[2023-05-18T09:55:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_seckill_goods` [ RunTime:0.057250s ]
[2023-05-18T09:55:15+08:00][sql] SELECT * FROM `ls_seckill_goods` WHERE `goods_id` = 12 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.054690s ]
[2023-05-18T09:55:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_team_activity` [ RunTime:0.064194s ]
[2023-05-18T09:55:15+08:00][sql] SELECT * FROM `ls_team_activity` WHERE `goods_id` = 12 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.054571s ]
[2023-05-18T09:55:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.057390s ]
[2023-05-18T09:55:15+08:00][sql] SELECT * FROM `ls_goods` WHERE `del` = 0 AND `name` = '泵车/车载泵/拖泵 S管' AND `shop_id` = 3 AND `id` <> 12 LIMIT 1 [ RunTime:0.056671s ]
[2023-05-18T09:55:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.063006s ]
[2023-05-18T09:55:15+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.054622s ]
[2023-05-18T09:55:15+08:00][sql] SELECT * FROM `ls_goods` WHERE `code` = '73258256' AND `del` = 0 AND `id` <> 12 [ RunTime:0.055195s ]
[2023-05-18T09:55:15+08:00][sql] SELECT `spec_type` FROM `ls_goods` WHERE `id` = 12 LIMIT 1 [ RunTime:0.054512s ]
[2023-05-18T09:55:15+08:00][sql] SELECT `audit_status` FROM `ls_goods` WHERE `id` = 12 LIMIT 1 [ RunTime:0.054384s ]
[2023-05-18T09:55:15+08:00][sql] UPDATE `ls_goods` SET `name` = '泵车/车载泵/拖泵 S管' , `code` = '73258256' , `shop_cate_id` = 5 , `first_cate_id` = 6 , `second_cate_id` = 11 , `third_cate_id` = 0 , `brand_id` = 0 , `unit_id` = 14 , `supplier_id` = 0 , `status` = 1 , `image` = 'uploads/images/20230518094954c8e7d1602.jpg' , `video` = '' , `remark` = '泵车/车载泵/拖泵S管，适用于三一重工泵车/车载泵/拖泵各机型' , `content` = '<img src=\"/uploads/images/202305180949550f6460403.jpg\">' , `sort` = 255 , `spec_type` = 2 , `max_price` = '4550.00' , `min_price` = '4180.00' , `market_price` = '4180.00' , `stock` = 3000 , `express_type` = 1 , `express_money` = 0 , `express_template_id` = 0 , `is_recommend` = 1 , `update_time` = 1684374913 , `stock_warn` = 0 , `poster` = '' , `is_show_stock` = 0 , `is_member` = 1 , `delivery_type` = '1' , `after_pay` = 1 , `after_delivery` = 1 , `delivery_content` = '' WHERE `id` = 12 [ RunTime:0.065980s ]
[2023-05-18T09:55:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.057083s ]
[2023-05-18T09:55:15+08:00][sql] DELETE FROM `ls_goods_image` WHERE `goods_id` = 12 [ RunTime:0.056834s ]
[2023-05-18T09:55:15+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 12 , `uri` = 'uploads/images/20230518094954c8e7d1602.jpg' [ RunTime:0.055765s ]
[2023-05-18T09:55:15+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 12 , `uri` = 'uploads/images/202305180949540f5838572.jpg' [ RunTime:0.055956s ]
[2023-05-18T09:55:15+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 12 , `uri` = 'uploads/images/202305180949544500b8064.jpg' [ RunTime:0.060423s ]
[2023-05-18T09:55:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_distribution_goods` [ RunTime:0.065691s ]
[2023-05-18T09:55:15+08:00][sql] SELECT `id` FROM `ls_distribution_goods` WHERE ( `goods_id` = 12 ) AND `ls_distribution_goods`.`delete_time` IS NULL [ RunTime:0.077695s ]
[2023-05-18T09:55:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.064991s ]
[2023-05-18T09:55:15+08:00][sql] UPDATE `ls_goods_spec` SET `name` = 'S管规格' WHERE `goods_id` = 12 AND `id` = 17 [ RunTime:0.072796s ]
[2023-05-18T09:55:15+08:00][sql] SELECT `id` FROM `ls_goods_spec` WHERE `goods_id` = 12 [ RunTime:0.062014s ]
[2023-05-18T09:55:15+08:00][sql] SELECT `name`,`id` FROM `ls_goods_spec` WHERE `goods_id` = 12 AND `name` = 'S管规格' [ RunTime:0.070014s ]
[2023-05-18T09:55:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.077811s ]
[2023-05-18T09:55:15+08:00][sql] UPDATE `ls_goods_spec_value` SET `goods_id` = 12 , `spec_id` = 17 , `value` = '泵车 S管260/SY5375' WHERE `id` = 34 [ RunTime:0.074096s ]
[2023-05-18T09:55:15+08:00][sql] UPDATE `ls_goods_spec_value` SET `goods_id` = 12 , `spec_id` = 17 , `value` = '拖泵S管200/60C1816' WHERE `id` = 35 [ RunTime:0.076583s ]
[2023-05-18T09:55:15+08:00][sql] UPDATE `ls_goods_spec_value` SET `goods_id` = 12 , `spec_id` = 17 , `value` = '泵车/车载S管230/C12037' WHERE `id` = 36 [ RunTime:0.077051s ]
[2023-05-18T09:55:15+08:00][sql] SELECT `id` FROM `ls_goods_spec_value` WHERE `goods_id` = 12 [ RunTime:0.079182s ]
[2023-05-18T09:55:15+08:00][sql] SELECT `value`,`id` FROM `ls_goods_spec_value` WHERE `goods_id` = 12 [ RunTime:0.073816s ]
[2023-05-18T09:55:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.082825s ]
[2023-05-18T09:55:15+08:00][sql] UPDATE `ls_goods_item` SET `spec_value_str` = '泵车 S管260/SY5375' , `market_price` = '4550.00' , `price` = '4550.00' , `chengben_price` = '4550.00' , `stock` = 1000 , `weight` = '10.000' , `volume` = '0.020' , `bar_code` = '' , `spec_value_ids` = '34' , `image` = '' , `goods_id` = 12 WHERE `id` = 44 [ RunTime:0.095234s ]
[2023-05-18T09:55:15+08:00][sql] UPDATE `ls_goods_item` SET `spec_value_str` = '拖泵S管200/60C1816' , `market_price` = '4180.00' , `price` = '4180.00' , `chengben_price` = '4180.00' , `stock` = 1000 , `weight` = '10.000' , `volume` = '10.000' , `bar_code` = '' , `spec_value_ids` = '35' , `image` = '' , `goods_id` = 12 WHERE `id` = 45 [ RunTime:0.101233s ]
[2023-05-18T09:55:15+08:00][sql] UPDATE `ls_goods_item` SET `spec_value_str` = '泵车/车载S管230/C12037' , `market_price` = '4200.00' , `price` = '4200.00' , `chengben_price` = '4200.00' , `stock` = 1000 , `weight` = '10.000' , `volume` = '10.000' , `bar_code` = '' , `spec_value_ids` = '36' , `image` = '' , `goods_id` = 12 WHERE `id` = 46 [ RunTime:0.091998s ]
[2023-05-18T09:55:15+08:00][sql] SELECT `id` FROM `ls_goods_item` WHERE `goods_id` = 12 [ RunTime:0.104500s ]
[2023-05-18T09:55:19+08:00][sql] CONNECT:[ UseTime:0.154833s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:55:19+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.086731s ]
[2023-05-18T09:55:19+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.115873s ]
[2023-05-18T09:55:19+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.078717s ]
[2023-05-18T09:55:19+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.106734s ]
[2023-05-18T09:55:19+08:00][sql] CONNECT:[ UseTime:0.155054s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-18T09:55:19+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.084072s ]
[2023-05-18T09:55:19+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.091888s ]
[2023-05-18T09:55:19+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.099850s ]
[2023-05-18T09:55:19+08:00][sql] SELECT * FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.096387s ]
[2023-05-18T09:55:19+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 [ RunTime:0.087964s ]