[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` = '' , `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` = '' , `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 ]