[2023-05-17T16:37:21+08:00][sql] CONNECT:[ UseTime:0.064471s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:21+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.049962s ] [2023-05-17T16:37:21+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'website_shop' AND `name` = 'shop_login_logo' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.043378s ] [2023-05-17T16:37:21+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'website_shop' AND `name` = 'shop_login_image' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.041091s ] [2023-05-17T16:37:21+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'website_shop' AND `name` = 'shop_login_title' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.041351s ] [2023-05-17T16:37:27+08:00][sql] CONNECT:[ UseTime:0.071231s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.046035s ] [2023-05-17T16:37:27+08:00][sql] SELECT `a`.* FROM `ls_shop_admin` `a` INNER JOIN `ls_shop` `s` ON `s`.`id`=`a`.`shop_id` WHERE `a`.`account` = 'admin' AND `a`.`del` = 0 LIMIT 1 [ RunTime:0.043804s ] [2023-05-17T16:37:27+08:00][sql] SELECT `a`.`id`,`a`.`account`,`a`.`name`,`role_id`,`shop_id`,`s`.`name` AS `shop_name` FROM `ls_shop_admin` `a` INNER JOIN `ls_shop` `s` ON `s`.`id`=`a`.`shop_id` WHERE `a`.`account` = 'admin' AND `a`.`del` = 0 LIMIT 1 [ RunTime:0.043628s ] [2023-05-17T16:37:27+08:00][sql] UPDATE `ls_shop_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1684312647 WHERE `account` = 'admin' [ RunTime:0.045449s ] [2023-05-17T16:37:28+08:00][sql] CONNECT:[ UseTime:0.055064s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.035169s ] [2023-05-17T16:37:28+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.054452s ] [2023-05-17T16:37:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.063546s ] [2023-05-17T16:37:28+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'website_shop' AND `name` = 'shop_admin_logo' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.035235s ] [2023-05-17T16:37:28+08:00][sql] SELECT * FROM `ls_dev_shop_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.048150s ] [2023-05-17T16:37:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.047512s ] [2023-05-17T16:37:28+08:00][sql] SELECT `name` FROM `ls_shop_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.031693s ] [2023-05-17T16:37:30+08:00][sql] CONNECT:[ UseTime:0.089116s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.046370s ] [2023-05-17T16:37:30+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.042733s ] [2023-05-17T16:37:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.045415s ] [2023-05-17T16:37:30+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.054577s ] [2023-05-17T16:37: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 1684166400 AND 1684252799 [ RunTime:0.042524s ] [2023-05-17T16:37: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.043583s ] [2023-05-17T16:37:30+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.042411s ] [2023-05-17T16:37: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 1684166400 AND 1684252799 [ RunTime:0.042808s ] [2023-05-17T16:37: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.042338s ] [2023-05-17T16:37:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.045644s ] [2023-05-17T16:37: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.049251s ] [2023-05-17T16:37: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 1684166400 AND 1684252799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.046914s ] [2023-05-17T16:37: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.044082s ] [2023-05-17T16:37:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.053988s ] [2023-05-17T16:37: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.042811s ] [2023-05-17T16:37: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 1684166400 AND 1684252799 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.042898s ] [2023-05-17T16:37: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.046246s ] [2023-05-17T16:37:30+08:00][sql] CONNECT:[ UseTime:0.098695s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.058747s ] [2023-05-17T16:37:30+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.057382s ] [2023-05-17T16:37:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.062389s ] [2023-05-17T16:37:30+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.056257s ] [2023-05-17T16:37:31+08:00][sql] CONNECT:[ UseTime:0.062376s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.040390s ] [2023-05-17T16:37:31+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.038109s ] [2023-05-17T16:37:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.040835s ] [2023-05-17T16:37: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.039370s ] [2023-05-17T16:37:33+08:00][sql] CONNECT:[ UseTime:0.067313s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.048183s ] [2023-05-17T16:37:33+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.044882s ] [2023-05-17T16:37:33+08:00][sql] CONNECT:[ UseTime:0.070218s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.049299s ] [2023-05-17T16:37:33+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.046749s ] [2023-05-17T16:37:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.051662s ] [2023-05-17T16:37:33+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1682956800 AND 1683043199 AND `pay_status` > 0 [ RunTime:0.053943s ] [2023-05-17T16:37:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.049143s ] [2023-05-17T16:37: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 1682956800 AND 1683043199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047078s ] [2023-05-17T16:37: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.048212s ] [2023-05-17T16:37: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.063945s ] [2023-05-17T16:37: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.053659s ] [2023-05-17T16:37: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.049892s ] [2023-05-17T16:37: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.047224s ] [2023-05-17T16:37: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.047192s ] [2023-05-17T16:37: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.046931s ] [2023-05-17T16:37: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.047315s ] [2023-05-17T16:37: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.047310s ] [2023-05-17T16:37: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.047053s ] [2023-05-17T16:37: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.047152s ] [2023-05-17T16:37: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.046966s ] [2023-05-17T16:37: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.047216s ] [2023-05-17T16:37: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.047012s ] [2023-05-17T16:37: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.047076s ] [2023-05-17T16:37: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.047323s ] [2023-05-17T16:37: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.047234s ] [2023-05-17T16:37: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.047253s ] [2023-05-17T16:37: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.047098s ] [2023-05-17T16:37: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.046829s ] [2023-05-17T16:37: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.049172s ] [2023-05-17T16:37: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.046581s ] [2023-05-17T16:37: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.047115s ] [2023-05-17T16:37: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.046695s ] [2023-05-17T16:37: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.046593s ] [2023-05-17T16:37: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.049621s ] [2023-05-17T16:37: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.054551s ] [2023-05-17T16:37: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.061516s ] [2023-05-17T16:37:33+08:00][sql] CONNECT:[ UseTime:0.069076s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.041441s ] [2023-05-17T16:37:33+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.042894s ] [2023-05-17T16:37:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_bank` [ RunTime:0.040427s ] [2023-05-17T16:37:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_bank` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.037604s ] [2023-05-17T16:37:33+08:00][sql] SELECT `id`,`shop_id`,`name`,`branch`,`nickname`,`account`,`del`,`create_time`,`update_time` FROM `ls_shop_bank` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.038447s ] [2023-05-17T16:37:34+08:00][sql] CONNECT:[ UseTime:0.047048s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.055304s ] [2023-05-17T16:37:34+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.064981s ] [2023-05-17T16:37:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.074064s ] [2023-05-17T16:37:34+08:00][sql] SELECT `logo`,`background`,`cover`,`banner` FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.036307s ] [2023-05-17T16:37:38+08:00][sql] CONNECT:[ UseTime:0.116132s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.103226s ] [2023-05-17T16:37:38+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.117202s ] [2023-05-17T16:37:39+08:00][sql] CONNECT:[ UseTime:0.153446s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.107505s ] [2023-05-17T16:37:39+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.099401s ] [2023-05-17T16:37:40+08:00][sql] CONNECT:[ UseTime:0.103304s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.054660s ] [2023-05-17T16:37:40+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.052544s ] [2023-05-17T16:37:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.055142s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683648000 AND 1684252799 AND `shop_id` = 3 [ RunTime:0.052897s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 AND `shop_id` = 3 [ RunTime:0.052969s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 AND `shop_id` = 3 [ RunTime:0.052647s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 AND `shop_id` = 3 [ RunTime:0.068317s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 AND `shop_id` = 3 [ RunTime:0.064558s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 AND `shop_id` = 3 [ RunTime:0.052665s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 AND `shop_id` = 3 [ RunTime:0.060962s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 AND `shop_id` = 3 [ RunTime:0.067284s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 AND `shop_id` = 3 [ RunTime:0.053140s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 AND `shop_id` = 3 [ RunTime:0.053016s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 AND `shop_id` = 3 [ RunTime:0.052990s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 AND `shop_id` = 3 [ RunTime:0.052797s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683907200 AND 1683993599 AND `shop_id` = 3 [ RunTime:0.052519s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1683993600 AND 1684079999 AND `shop_id` = 3 [ RunTime:0.053025s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1684080000 AND 1684166399 AND `shop_id` = 3 [ RunTime:0.052712s ] [2023-05-17T16:37:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_shop_stat` WHERE `create_time` BETWEEN 1684166400 AND 1684252799 AND `shop_id` = 3 [ RunTime:0.053052s ] [2023-05-17T16:37:42+08:00][sql] CONNECT:[ UseTime:0.045612s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.031507s ] [2023-05-17T16:37:42+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.028924s ] [2023-05-17T16:37:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.030763s ] [2023-05-17T16:37:42+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'express' AND `name` = 'way' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.029118s ] [2023-05-17T16:37:42+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kd100' AND `name` = 'appkey' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.029378s ] [2023-05-17T16:37:42+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kd100' AND `name` = 'appsecret' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.029053s ] [2023-05-17T16:37:42+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kdniao' AND `name` = 'appkey' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.029096s ] [2023-05-17T16:37:42+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kdniao' AND `name` = 'appsecret' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.029020s ] [2023-05-17T16:37:42+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kdniao' AND `name` = 'type' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.029212s ] [2023-05-17T16:37:42+08:00][sql] CONNECT:[ UseTime:0.064170s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.046065s ] [2023-05-17T16:37:42+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.043314s ] [2023-05-17T16:37:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.043007s ] [2023-05-17T16:37:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.041239s ] [2023-05-17T16:37:42+08:00][sql] SELECT * FROM `ls_freight` WHERE `shop_id` = 3 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.040456s ] [2023-05-17T16:37:44+08:00][sql] CONNECT:[ UseTime:0.062365s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.043878s ] [2023-05-17T16:37:44+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.041071s ] [2023-05-17T16:37:44+08:00][sql] CONNECT:[ UseTime:0.089476s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.055020s ] [2023-05-17T16:37:44+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.052734s ] [2023-05-17T16:37:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_account_log` [ RunTime:0.055335s ] [2023-05-17T16:37:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_account_log` `SAL` INNER JOIN `ls_shop` `S` ON `S`.`id`=`SAL`.`shop_id` WHERE `shop_id` = 3 [ RunTime:0.052890s ] [2023-05-17T16:37:44+08:00][sql] SELECT `SAL`.*,S.name,S.logo,S.type FROM `ls_shop_account_log` `SAL` INNER JOIN `ls_shop` `S` ON `S`.`id`=`SAL`.`shop_id` WHERE `shop_id` = 3 ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.053934s ] [2023-05-17T16:37:46+08:00][sql] CONNECT:[ UseTime:0.068592s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.048039s ] [2023-05-17T16:37:46+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.044675s ] [2023-05-17T16:37:46+08:00][sql] CONNECT:[ UseTime:0.067483s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.047351s ] [2023-05-17T16:37:46+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.045076s ] [2023-05-17T16:37:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_live_room` [ RunTime:0.049262s ] [2023-05-17T16:37:46+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_live_room` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.044975s ] [2023-05-17T16:37:46+08:00][sql] SELECT * FROM `ls_live_room` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.045561s ] [2023-05-17T16:37:51+08:00][sql] CONNECT:[ UseTime:0.148004s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.064606s ] [2023-05-17T16:37:51+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.059927s ] [2023-05-17T16:37:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.062344s ] [2023-05-17T16:37:51+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'image' AND `shop_id` = 3 LIMIT 1 [ RunTime:0.060813s ] [2023-05-17T16:37:51+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'type' AND `shop_id` = 3 LIMIT 1 [ RunTime:0.062982s ] [2023-05-17T16:37:51+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'wechat' AND `shop_id` = 3 LIMIT 1 [ RunTime:0.059685s ] [2023-05-17T16:37:51+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'phone' AND `shop_id` = 3 LIMIT 1 [ RunTime:0.067191s ] [2023-05-17T16:37:51+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'business_time' AND `shop_id` = 3 LIMIT 1 [ RunTime:0.066401s ] [2023-05-17T16:37:58+08:00][sql] CONNECT:[ UseTime:0.114573s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.036905s ] [2023-05-17T16:37:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.029758s ] [2023-05-17T16:37:58+08:00][sql] CONNECT:[ UseTime:0.096011s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:37:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.065025s ] [2023-05-17T16:37:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.060090s ] [2023-05-17T16:37:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_kefu` [ RunTime:0.051984s ] [2023-05-17T16:37:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_kefu` `k` INNER JOIN `ls_shop_admin` `a` ON `a`.`id`=`k`.`admin_id` WHERE `a`.`del` = 0 AND `k`.`del` = 0 AND `k`.`shop_id` = 3 [ RunTime:0.072698s ] [2023-05-17T16:37:58+08:00][sql] SELECT `k`.*,`a`.`account` FROM `ls_kefu` `k` INNER JOIN `ls_shop_admin` `a` ON `a`.`id`=`k`.`admin_id` WHERE `a`.`del` = 0 AND `k`.`del` = 0 AND `k`.`shop_id` = 3 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.069501s ] [2023-05-17T16:38:00+08:00][sql] CONNECT:[ UseTime:0.079298s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:38:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.053590s ] [2023-05-17T16:38:00+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.050468s ] [2023-05-17T16:38:01+08:00][sql] CONNECT:[ UseTime:0.110644s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:38:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.058836s ] [2023-05-17T16:38:01+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.056176s ] [2023-05-17T16:38:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_coupon` [ RunTime:0.060174s ] [2023-05-17T16:38:01+08:00][sql] UPDATE `ls_coupon` SET `status` = 0 , `update_time` = 1684312681 WHERE `send_time_start` < 1684312681 AND `send_time_end` < 1684312681 AND `status` = 1 AND `shop_id` = 3 [ RunTime:0.056779s ] [2023-05-17T16:38:01+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_coupon` WHERE `del` = 0 AND `shop_id` = 3 AND `status` = 1 [ RunTime:0.056381s ] [2023-05-17T16:38:01+08:00][sql] SELECT `id`,`name`,`money`,`use_goods_type`,use_goods_type as use_goods_type_desc,`condition_type`,`condition_money`,condition_type as condition_type_desc,`send_total_type`,send_total_type as send_total_type_desc,`send_total`,`get_type`,get_type as get_type_desc,`status`,status as statusDesc,`send_time_start`,`send_time_end`,send_time_start as send_time,`use_time_type`,`use_time_start`,`use_time_end`,`use_time`,use_time_type as use_time_desc,`create_time` FROM `ls_coupon` WHERE `del` = 0 AND `shop_id` = 3 AND `status` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.057469s ] [2023-05-17T16:38:04+08:00][sql] CONNECT:[ UseTime:0.084559s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:38:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.059117s ] [2023-05-17T16:38:04+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.057031s ] [2023-05-17T16:38:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.059353s ] [2023-05-17T16:38:04+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.056973s ] [2023-05-17T16:38:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.059591s ] [2023-05-17T16:38:04+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.056715s ] [2023-05-17T16:38:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.059529s ] [2023-05-17T16:38:04+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.056891s ] [2023-05-17T16:38:04+08:00][sql] CONNECT:[ UseTime:0.063060s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:38:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.034635s ] [2023-05-17T16:38:04+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.029140s ] [2023-05-17T16:38:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.032099s ] [2023-05-17T16:38:04+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.030711s ] [2023-05-17T16:38:04+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.031301s ] [2023-05-17T16:39:38+08:00][sql] CONNECT:[ UseTime:0.080346s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:39:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.056492s ] [2023-05-17T16:39:38+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.053056s ] [2023-05-17T16:39:38+08:00][sql] SELECT * FROM `ls_dev_shop_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.054445s ] [2023-05-17T16:39:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.055394s ] [2023-05-17T16:39:38+08:00][sql] SELECT `name` FROM `ls_shop_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.052998s ] [2023-05-17T16:39:39+08:00][sql] CONNECT:[ UseTime:0.066953s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:39:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.056778s ] [2023-05-17T16:39:39+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.066691s ] [2023-05-17T16:39:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.047730s ] [2023-05-17T16:39:39+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.042963s ] [2023-05-17T16:39:39+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684166400 AND 1684252799 [ RunTime:0.045965s ] [2023-05-17T16:39:39+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.046143s ] [2023-05-17T16:39:39+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.042766s ] [2023-05-17T16:39:39+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 1684166400 AND 1684252799 [ RunTime:0.046464s ] [2023-05-17T16:39:39+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.043123s ] [2023-05-17T16:39:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.043353s ] [2023-05-17T16:39:39+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.046955s ] [2023-05-17T16:39:39+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.060067s ] [2023-05-17T16:39:39+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.041122s ] [2023-05-17T16:39:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.043074s ] [2023-05-17T16:39:39+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.040576s ] [2023-05-17T16:39:39+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 1684166400 AND 1684252799 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.040852s ] [2023-05-17T16:39:39+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.041185s ] [2023-05-17T16:39:40+08:00][sql] CONNECT:[ UseTime:0.060268s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:39:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.041623s ] [2023-05-17T16:39:40+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.050153s ] [2023-05-17T16:39:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.035622s ] [2023-05-17T16:39:40+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.034017s ] [2023-05-17T16:39:41+08:00][sql] CONNECT:[ UseTime:0.175218s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:39:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.121748s ] [2023-05-17T16:39:41+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.084376s ] [2023-05-17T16:39:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.054994s ] [2023-05-17T16:39:41+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.051902s ] [2023-05-17T16:39:42+08:00][sql] CONNECT:[ UseTime:0.095533s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:39:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.071366s ] [2023-05-17T16:39:42+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.057318s ] [2023-05-17T16:39:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.060025s ] [2023-05-17T16:39:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1682956800 AND 1683043199 AND `pay_status` > 0 [ RunTime:0.064832s ] [2023-05-17T16:39:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.061412s ] [2023-05-17T16:39:42+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 1682956800 AND 1683043199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.057968s ] [2023-05-17T16:39:42+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.062109s ] [2023-05-17T16:39:42+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.058844s ] [2023-05-17T16:39:42+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.062470s ] [2023-05-17T16:39:42+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.083644s ] [2023-05-17T16:39:42+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.122885s ] [2023-05-17T16:39:42+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.102571s ] [2023-05-17T16:39:42+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.121717s ] [2023-05-17T16:39:42+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.119821s ] [2023-05-17T16:39:42+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.128176s ] [2023-05-17T16:39:42+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.071202s ] [2023-05-17T16:39:42+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.057778s ] [2023-05-17T16:39:42+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.069037s ] [2023-05-17T16:39:42+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.059304s ] [2023-05-17T16:39:42+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.063360s ] [2023-05-17T16:39:42+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.058301s ] [2023-05-17T16:39:42+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.059404s ] [2023-05-17T16:39:42+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.060038s ] [2023-05-17T16:39:42+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.071553s ] [2023-05-17T16:39:42+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.059531s ] [2023-05-17T16:39:42+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.062176s ] [2023-05-17T16:39:42+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.059989s ] [2023-05-17T16:39:42+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.058856s ] [2023-05-17T16:39:42+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.061156s ] [2023-05-17T16:39:42+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.075696s ] [2023-05-17T16:39:42+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.120204s ] [2023-05-17T16:39:42+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.108431s ] [2023-05-17T16:39:42+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.075309s ] [2023-05-17T16:39:42+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.070069s ] [2023-05-17T16:42:17+08:00][sql] CONNECT:[ UseTime:0.068495s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:42:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.048127s ] [2023-05-17T16:42:17+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.045230s ] [2023-05-17T16:42:17+08:00][sql] SELECT * FROM `ls_dev_shop_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.046612s ] [2023-05-17T16:42:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.047817s ] [2023-05-17T16:42:17+08:00][sql] SELECT `name` FROM `ls_shop_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.046179s ] [2023-05-17T16:42:18+08:00][sql] CONNECT:[ UseTime:0.106679s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:42:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.058839s ] [2023-05-17T16:42:18+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.045291s ] [2023-05-17T16:42:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.076248s ] [2023-05-17T16:42:18+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.060328s ] [2023-05-17T16:42:18+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1684166400 AND 1684252799 [ RunTime:0.053840s ] [2023-05-17T16:42:18+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.048411s ] [2023-05-17T16:42:18+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.044774s ] [2023-05-17T16:42:18+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 1684166400 AND 1684252799 [ RunTime:0.044972s ] [2023-05-17T16:42:18+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.052233s ] [2023-05-17T16:42:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.048159s ] [2023-05-17T16:42:18+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.045268s ] [2023-05-17T16:42:18+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.044957s ] [2023-05-17T16:42:18+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.045189s ] [2023-05-17T16:42:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.047713s ] [2023-05-17T16:42:18+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.045308s ] [2023-05-17T16:42:18+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 1684166400 AND 1684252799 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.045215s ] [2023-05-17T16:42:18+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.045225s ] [2023-05-17T16:42:19+08:00][sql] CONNECT:[ UseTime:0.065822s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:42:19+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.043635s ] [2023-05-17T16:42:19+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.041059s ] [2023-05-17T16:42:19+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.043323s ] [2023-05-17T16:42:19+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.040935s ] [2023-05-17T16:42:20+08:00][sql] CONNECT:[ UseTime:0.051514s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:42:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.033244s ] [2023-05-17T16:42:20+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.029703s ] [2023-05-17T16:42:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.031142s ] [2023-05-17T16:42:20+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.029368s ] [2023-05-17T16:42:20+08:00][sql] CONNECT:[ UseTime:0.079302s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:42:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.046853s ] [2023-05-17T16:42:20+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.044751s ] [2023-05-17T16:42:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.047242s ] [2023-05-17T16:42:20+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1682956800 AND 1683043199 AND `pay_status` > 0 [ RunTime:0.044685s ] [2023-05-17T16:42:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.046844s ] [2023-05-17T16:42:20+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 1682956800 AND 1683043199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.049108s ] [2023-05-17T16:42:20+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.045408s ] [2023-05-17T16:42:20+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.047907s ] [2023-05-17T16:42:20+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.052129s ] [2023-05-17T16:42:20+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.056323s ] [2023-05-17T16:42:20+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.046394s ] [2023-05-17T16:42:20+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.045949s ] [2023-05-17T16:42:20+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.045434s ] [2023-05-17T16:42:20+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.044942s ] [2023-05-17T16:42:20+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.044997s ] [2023-05-17T16:42:20+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.045077s ] [2023-05-17T16:42:20+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.045036s ] [2023-05-17T16:42:20+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.044884s ] [2023-05-17T16:42:20+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.045094s ] [2023-05-17T16:42:20+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.045007s ] [2023-05-17T16:42:20+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.050348s ] [2023-05-17T16:42:20+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.045804s ] [2023-05-17T16:42:20+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.045532s ] [2023-05-17T16:42:20+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.044905s ] [2023-05-17T16:42:20+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.051650s ] [2023-05-17T16:42:20+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.047688s ] [2023-05-17T16:42:20+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.051923s ] [2023-05-17T16:42:20+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.044924s ] [2023-05-17T16:42:20+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.045165s ] [2023-05-17T16:42:20+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.045028s ] [2023-05-17T16:42:20+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.045054s ] [2023-05-17T16:42:20+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.045178s ] [2023-05-17T16:42:20+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.044900s ] [2023-05-17T16:42:20+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.045005s ] [2023-05-17T16:42:20+08:00][sql] CONNECT:[ UseTime:0.078081s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:42:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.051711s ] [2023-05-17T16:42:20+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.049024s ] [2023-05-17T16:42:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.049716s ] [2023-05-17T16:42:20+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.047457s ] [2023-05-17T16:42:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.049711s ] [2023-05-17T16:42:20+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.047202s ] [2023-05-17T16:42:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.049577s ] [2023-05-17T16:42:20+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.049911s ] [2023-05-17T16:42:21+08:00][sql] CONNECT:[ UseTime:0.070371s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:42:21+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.053211s ] [2023-05-17T16:42:21+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.053843s ] [2023-05-17T16:42:21+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.046020s ] [2023-05-17T16:42:21+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.045053s ] [2023-05-17T16:42:21+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.047171s ] [2023-05-17T16:45:51+08:00][sql] CONNECT:[ UseTime:0.098187s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:45:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.062222s ] [2023-05-17T16:45:51+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.059337s ] [2023-05-17T16:45:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.062208s ] [2023-05-17T16:45:51+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.060162s ] [2023-05-17T16:45:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.062182s ] [2023-05-17T16:45:51+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.059914s ] [2023-05-17T16:45:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.062390s ] [2023-05-17T16:45:51+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.059631s ] [2023-05-17T16:45:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.062421s ] [2023-05-17T16:45:51+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.059823s ] [2023-05-17T16:45:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.061543s ] [2023-05-17T16:45:51+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.059703s ] [2023-05-17T16:45:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.061667s ] [2023-05-17T16:45:51+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.059741s ] [2023-05-17T16:46:38+08:00][sql] CONNECT:[ UseTime:0.048847s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:46:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.031735s ] [2023-05-17T16:46:38+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.030408s ] [2023-05-17T16:46:38+08:00][sql] CONNECT:[ UseTime:0.054976s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:46:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.040078s ] [2023-05-17T16:46:38+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.035829s ] [2023-05-17T16:46:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.038777s ] [2023-05-17T16:46:38+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.036529s ] [2023-05-17T16:46:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.036026s ] [2023-05-17T16:46:39+08:00][sql] CONNECT:[ UseTime:0.081917s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:46:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.045639s ] [2023-05-17T16:46:39+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.043032s ] [2023-05-17T16:46:43+08:00][sql] CONNECT:[ UseTime:0.058202s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:46:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.031821s ] [2023-05-17T16:46:43+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.029225s ] [2023-05-17T16:46:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.032027s ] [2023-05-17T16:46:43+08:00][sql] SELECT `name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 AND `name` = '挖掘机' LIMIT 1 [ RunTime:0.030337s ] [2023-05-17T16:46:43+08:00][sql] INSERT INTO `ls_shop_goods_category` SET `name` = '挖掘机' , `sort` = 255 , `is_show` = 1 , `remark` = '' , `del` = 0 , `shop_id` = 3 , `create_time` = 1684313203 , `update_time` = 1684313203 [ RunTime:0.030041s ] [2023-05-17T16:46:43+08:00][sql] CONNECT:[ UseTime:0.091857s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:46:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.061237s ] [2023-05-17T16:46:43+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.055875s ] [2023-05-17T16:46:44+08:00][sql] CONNECT:[ UseTime:0.066350s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:46:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.050319s ] [2023-05-17T16:46:44+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.044169s ] [2023-05-17T16:46:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.048112s ] [2023-05-17T16:46:44+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.045287s ] [2023-05-17T16:46:44+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.044367s ] [2023-05-17T16:46:56+08:00][sql] CONNECT:[ UseTime:0.069375s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:46:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.038574s ] [2023-05-17T16:46:56+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.035938s ] [2023-05-17T16:46:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.037821s ] [2023-05-17T16:46:56+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.036883s ] [2023-05-17T16:46:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.038053s ] [2023-05-17T16:46:56+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.035708s ] [2023-05-17T16:46:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.037997s ] [2023-05-17T16:46:56+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.036109s ] [2023-05-17T16:46:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.038180s ] [2023-05-17T16:46:56+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.036318s ] [2023-05-17T16:46:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.038645s ] [2023-05-17T16:46:56+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.035918s ] [2023-05-17T16:46:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.038166s ] [2023-05-17T16:46:56+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.035737s ] [2023-05-17T16:51:24+08:00][sql] CONNECT:[ UseTime:0.059986s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:51:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.042578s ] [2023-05-17T16:51:24+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.044020s ] [2023-05-17T16:51:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.042138s ] [2023-05-17T16:51:24+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.039998s ] [2023-05-17T16:51:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.045753s ] [2023-05-17T16:51:24+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.053157s ] [2023-05-17T16:51:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.042240s ] [2023-05-17T16:51:24+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.040116s ] [2023-05-17T16:51:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.046824s ] [2023-05-17T16:51:24+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.040074s ] [2023-05-17T16:51:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.052942s ] [2023-05-17T16:51:24+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.039820s ] [2023-05-17T16:51:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.041845s ] [2023-05-17T16:51:24+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.040791s ] [2023-05-17T16:51:55+08:00][sql] CONNECT:[ UseTime:0.089751s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:51:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.062096s ] [2023-05-17T16:51:55+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.059617s ] [2023-05-17T16:51:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.061648s ] [2023-05-17T16:51:55+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.059826s ] [2023-05-17T16:51:56+08:00][sql] CONNECT:[ UseTime:0.116434s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:51:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.067229s ] [2023-05-17T16:51:56+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.063404s ] [2023-05-17T16:51:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.064061s ] [2023-05-17T16:51:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.063811s ] [2023-05-17T16:51:56+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.061997s ] [2023-05-17T16:52:07+08:00][sql] CONNECT:[ UseTime:0.047087s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:52:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.031075s ] [2023-05-17T16:52:07+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.033503s ] [2023-05-17T16:52:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.031322s ] [2023-05-17T16:52:07+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.028604s ] [2023-05-17T16:52:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.032461s ] [2023-05-17T16:52:07+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = 'dd8eb54c0add4f76a0c34882d38198a82.jpg' , `uri` = 'uploads/images/20230517165207b1e112098.jpg' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684313527 [ RunTime:0.028906s ] [2023-05-17T16:52:07+08:00][sql] CONNECT:[ UseTime:0.050045s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:52:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.035356s ] [2023-05-17T16:52:07+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.033297s ] [2023-05-17T16:52:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.035304s ] [2023-05-17T16:52:07+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.033643s ] [2023-05-17T16:52:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.035529s ] [2023-05-17T16:52:07+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = 'dd8eb54c0add4f76a0c34882d38198a8.jpg' , `uri` = 'uploads/images/20230517165207391d58263.jpg' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684313527 [ RunTime:0.033423s ] [2023-05-17T16:53:23+08:00][sql] CONNECT:[ UseTime:0.069394s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:53:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.045985s ] [2023-05-17T16:53:23+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.044565s ] [2023-05-17T16:53:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.045928s ] [2023-05-17T16:53:23+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.044237s ] [2023-05-17T16:53:23+08:00][sql] CONNECT:[ UseTime:0.053857s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:53:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.031386s ] [2023-05-17T16:53:23+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.028482s ] [2023-05-17T16:53:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.043139s ] [2023-05-17T16:53:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.028641s ] [2023-05-17T16:53:23+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.028985s ] [2023-05-17T16:53:41+08:00][sql] CONNECT:[ UseTime:0.057847s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:53:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.030824s ] [2023-05-17T16:53:41+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.029179s ] [2023-05-17T16:53:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.031445s ] [2023-05-17T16:53:41+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.047614s ] [2023-05-17T16:53:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.031122s ] [2023-05-17T16:53:41+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = '015ac2599e3530a80121ad7bdbfa66.jpg@1280w_1l_2o_100sh.jpg' , `uri` = 'uploads/images/20230517165341bbb854714.jpg' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684313621 [ RunTime:0.028822s ] [2023-05-17T16:53:51+08:00][sql] CONNECT:[ UseTime:0.075250s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:53:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.046890s ] [2023-05-17T16:53:51+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.044007s ] [2023-05-17T16:53:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.046679s ] [2023-05-17T16:53:51+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.044618s ] [2023-05-17T16:53:51+08:00][sql] CONNECT:[ UseTime:0.068429s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:53:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.048307s ] [2023-05-17T16:53:51+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.048872s ] [2023-05-17T16:53:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.047120s ] [2023-05-17T16:53:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.044716s ] [2023-05-17T16:53:51+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.045486s ] [2023-05-17T16:53:56+08:00][sql] CONNECT:[ UseTime:0.051276s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:53:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.035943s ] [2023-05-17T16:53:56+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.033516s ] [2023-05-17T16:53:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.035629s ] [2023-05-17T16:53:56+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.034795s ] [2023-05-17T16:53:57+08:00][sql] CONNECT:[ UseTime:0.053386s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:53:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.033613s ] [2023-05-17T16:53:57+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.028550s ] [2023-05-17T16:53:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.051179s ] [2023-05-17T16:53:57+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.028719s ] [2023-05-17T16:53:57+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.029273s ] [2023-05-17T16:54:10+08:00][sql] CONNECT:[ UseTime:0.086528s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:54:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.053280s ] [2023-05-17T16:54:10+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.052509s ] [2023-05-17T16:54:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.052624s ] [2023-05-17T16:54:10+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.053025s ] [2023-05-17T16:54:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.053161s ] [2023-05-17T16:54:10+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = '202009300928178235.png' , `uri` = 'uploads/images/20230517165410a78de8178.png' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684313650 [ RunTime:0.050749s ] [2023-05-17T16:54:23+08:00][sql] CONNECT:[ UseTime:0.070532s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:54:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.049256s ] [2023-05-17T16:54:23+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.046049s ] [2023-05-17T16:54:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.048453s ] [2023-05-17T16:54:23+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.046644s ] [2023-05-17T16:54:23+08:00][sql] CONNECT:[ UseTime:0.111589s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:54:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.060781s ] [2023-05-17T16:54:23+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.058302s ] [2023-05-17T16:54:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.061175s ] [2023-05-17T16:54:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.058618s ] [2023-05-17T16:54:23+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.059269s ] [2023-05-17T16:55:44+08:00][sql] CONNECT:[ UseTime:0.090901s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:55:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.056438s ] [2023-05-17T16:55:44+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.053268s ] [2023-05-17T16:55:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.055838s ] [2023-05-17T16:55:44+08:00][sql] SELECT * FROM `ls_goods` WHERE `del` = 0 AND `name` = 'SY16C迷你挖掘机' AND `shop_id` = 3 LIMIT 1 [ RunTime:0.054221s ] [2023-05-17T16:55:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.055883s ] [2023-05-17T16:55:44+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.054575s ] [2023-05-17T16:55:50+08:00][sql] CONNECT:[ UseTime:0.050792s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:55:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.034380s ] [2023-05-17T16:55:50+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.031653s ] [2023-05-17T16:55:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.034195s ] [2023-05-17T16:55:50+08:00][sql] SELECT * FROM `ls_goods` WHERE `del` = 0 AND `name` = 'SY16C迷你挖掘机' AND `shop_id` = 3 LIMIT 1 [ RunTime:0.032868s ] [2023-05-17T16:55:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.034116s ] [2023-05-17T16:55:50+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.032626s ] [2023-05-17T16:55:50+08:00][sql] SELECT * FROM `ls_goods` WHERE `code` = 'SY16C' AND `del` = 0 [ RunTime:0.032906s ] [2023-05-17T16:55:50+08:00][sql] SELECT `is_product_audit` FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.031796s ] [2023-05-17T16:55:50+08:00][sql] INSERT INTO `ls_goods` SET `type` = 0 , `name` = 'SY16C迷你挖掘机' , `code` = 'SY16C' , `shop_id` = 3 , `shop_cate_id` = 3 , `first_cate_id` = 1 , `second_cate_id` = 8 , `third_cate_id` = 0 , `unit_id` = 13 , `brand_id` = 1 , `supplier_id` = 0 , `status` = 1 , `image` = 'uploads/images/20230517165341bbb854714.jpg' , `video` = '' , `remark` = '' , `content` = '' , `sort` = 255 , `spec_type` = 1 , `max_price` = '36999' , `min_price` = '36999' , `market_price` = '38999' , `stock` = 1000 , `express_type` = 1 , `express_money` = 0 , `express_template_id` = 0 , `is_recommend` = 1 , `create_time` = 1684313749 , `update_time` = 1684313749 , `stock_warn` = 0 , `poster` = '' , `is_show_stock` = 0 , `is_member` = 0 , `audit_status` = 0 , `delivery_type` = '1' , `after_pay` = 1 , `after_delivery` = 1 , `delivery_content` = '' [ RunTime:0.032595s ] [2023-05-17T16:55:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.034177s ] [2023-05-17T16:55:50+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 9 , `uri` = 'uploads/images/20230517165341bbb854714.jpg' [ RunTime:0.031810s ] [2023-05-17T16:55:50+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 9 , `uri` = 'uploads/images/20230517165410a78de8178.png' [ RunTime:0.032349s ] [2023-05-17T16:55:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.033994s ] [2023-05-17T16:55:50+08:00][sql] INSERT INTO `ls_goods_spec` SET `goods_id` = 9 , `name` = '默认' [ RunTime:0.031678s ] [2023-05-17T16:55:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.034547s ] [2023-05-17T16:55:50+08:00][sql] INSERT INTO `ls_goods_spec_value` SET `spec_id` = 14 , `goods_id` = 9 , `value` = '默认' [ RunTime:0.031975s ] [2023-05-17T16:55:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.034415s ] [2023-05-17T16:55:50+08:00][sql] INSERT INTO `ls_goods_item` SET `image` = 'uploads/images/20230517165341bbb854714.jpg' , `goods_id` = 9 , `spec_value_ids` = '31' , `spec_value_str` = '默认' , `market_price` = '38999' , `price` = '36999' , `stock` = 1000 , `volume` = '3' , `weight` = '1850' , `bar_code` = '' , `chengben_price` = '16999' [ RunTime:0.032427s ] [2023-05-17T16:55:52+08:00][sql] CONNECT:[ UseTime:0.084228s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:55:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.055486s ] [2023-05-17T16:55:52+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.052670s ] [2023-05-17T16:55:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.055374s ] [2023-05-17T16:55:52+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.053261s ] [2023-05-17T16:55:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.054820s ] [2023-05-17T16:55:52+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.052550s ] [2023-05-17T16:55:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.055283s ] [2023-05-17T16:55:52+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.054712s ] [2023-05-17T16:55:52+08:00][sql] CONNECT:[ UseTime:0.095543s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:55:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.058813s ] [2023-05-17T16:55:52+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.053634s ] [2023-05-17T16:55:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.056088s ] [2023-05-17T16:55:52+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.055262s ] [2023-05-17T16:55:52+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.053516s ] [2023-05-17T16:56:02+08:00][sql] CONNECT:[ UseTime:0.072317s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T16:56:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.048456s ] [2023-05-17T16:56:02+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.037742s ] [2023-05-17T16:56:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.040573s ] [2023-05-17T16:56:02+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.039072s ] [2023-05-17T16:56:02+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 [ RunTime:0.038074s ] [2023-05-17T17:02:16+08:00][sql] CONNECT:[ UseTime:0.085003s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:02:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.044761s ] [2023-05-17T17:02:16+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.042656s ] [2023-05-17T17:02:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.044951s ] [2023-05-17T17:02:16+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.042690s ] [2023-05-17T17:02:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.050076s ] [2023-05-17T17:02:16+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.042537s ] [2023-05-17T17:02:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.045229s ] [2023-05-17T17:02:16+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.043371s ] [2023-05-17T17:02:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.045114s ] [2023-05-17T17:02:16+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.042668s ] [2023-05-17T17:02:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.044560s ] [2023-05-17T17:02:16+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.042818s ] [2023-05-17T17:02:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.044582s ] [2023-05-17T17:02:16+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.042579s ] [2023-05-17T17:02:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.046754s ] [2023-05-17T17:02:16+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 9 LIMIT 1 [ RunTime:0.043707s ] [2023-05-17T17:02:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.045769s ] [2023-05-17T17:02:16+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 9 [ RunTime:0.042693s ] [2023-05-17T17:02:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.044290s ] [2023-05-17T17:02:16+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 9 [ RunTime:0.043215s ] [2023-05-17T17:02:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.046302s ] [2023-05-17T17:02:16+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 9 [ RunTime:0.042738s ] [2023-05-17T17:02:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.047640s ] [2023-05-17T17:02:16+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 9 [ RunTime:0.043298s ] [2023-05-17T17:02:20+08:00][sql] CONNECT:[ UseTime:0.080290s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:02:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.049357s ] [2023-05-17T17:02:20+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.046776s ] [2023-05-17T17:02:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_bargain` [ RunTime:0.049252s ] [2023-05-17T17:02:20+08:00][sql] SELECT * FROM `ls_bargain` WHERE `goods_id` = 9 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.047918s ] [2023-05-17T17:02:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_seckill_goods` [ RunTime:0.049574s ] [2023-05-17T17:02:20+08:00][sql] SELECT * FROM `ls_seckill_goods` WHERE `goods_id` = 9 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.047866s ] [2023-05-17T17:02:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_team_activity` [ RunTime:0.049189s ] [2023-05-17T17:02:20+08:00][sql] SELECT * FROM `ls_team_activity` WHERE `goods_id` = 9 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.047927s ] [2023-05-17T17:02:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.049731s ] [2023-05-17T17:02:20+08:00][sql] SELECT * FROM `ls_goods` WHERE `del` = 0 AND `name` = 'SY16C迷你挖掘机' AND `shop_id` = 3 AND `id` <> 9 LIMIT 1 [ RunTime:0.048063s ] [2023-05-17T17:02:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.049614s ] [2023-05-17T17:02:20+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.047959s ] [2023-05-17T17:02:20+08:00][sql] SELECT * FROM `ls_goods` WHERE `code` = 'SY16C' AND `del` = 0 AND `id` <> 9 [ RunTime:0.048049s ] [2023-05-17T17:02:20+08:00][sql] SELECT `spec_type` FROM `ls_goods` WHERE `id` = 9 LIMIT 1 [ RunTime:0.047583s ] [2023-05-17T17:02:20+08:00][sql] SELECT `audit_status` FROM `ls_goods` WHERE `id` = 9 LIMIT 1 [ RunTime:0.047253s ] [2023-05-17T17:02:20+08:00][sql] UPDATE `ls_goods` SET `name` = 'SY16C迷你挖掘机' , `code` = 'SY16C' , `shop_cate_id` = 3 , `first_cate_id` = 1 , `second_cate_id` = 15 , `third_cate_id` = 0 , `brand_id` = 1 , `unit_id` = 13 , `supplier_id` = 0 , `status` = 1 , `image` = 'uploads/images/20230517165341bbb854714.jpg' , `video` = '' , `remark` = '' , `content` = '' , `sort` = 255 , `spec_type` = 1 , `max_price` = '36999.00' , `min_price` = '36999.00' , `market_price` = '38999.00' , `stock` = 1000 , `express_type` = 1 , `express_money` = 0 , `express_template_id` = 0 , `is_recommend` = 1 , `update_time` = 1684314139 , `stock_warn` = 0 , `poster` = '' , `is_show_stock` = 0 , `is_member` = 0 , `delivery_type` = '1' , `after_pay` = 1 , `after_delivery` = 1 , `delivery_content` = '' WHERE `id` = 9 [ RunTime:0.051703s ] [2023-05-17T17:02:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.049104s ] [2023-05-17T17:02:20+08:00][sql] DELETE FROM `ls_goods_image` WHERE `goods_id` = 9 [ RunTime:0.046942s ] [2023-05-17T17:02:20+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 9 , `uri` = 'uploads/images/20230517165341bbb854714.jpg' [ RunTime:0.046813s ] [2023-05-17T17:02:20+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 9 , `uri` = 'uploads/images/20230517165410a78de8178.png' [ RunTime:0.046863s ] [2023-05-17T17:02:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_distribution_goods` [ RunTime:0.049346s ] [2023-05-17T17:02:20+08:00][sql] SELECT `id` FROM `ls_distribution_goods` WHERE ( `goods_id` = 9 ) AND `ls_distribution_goods`.`delete_time` IS NULL [ RunTime:0.047223s ] [2023-05-17T17:02:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.050758s ] [2023-05-17T17:02:20+08:00][sql] UPDATE `ls_goods_item` SET `image` = 'uploads/images/20230517165341bbb854714.jpg' , `market_price` = '38999.00' , `price` = '36999.00' , `chengben_price` = '16999.00' , `stock` = 1000 , `weight` = '1850.000' , `volume` = '3.000' , `bar_code` = '' WHERE `goods_id` = 9 [ RunTime:0.047238s ] [2023-05-17T17:02:22+08:00][sql] CONNECT:[ UseTime:0.060761s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:02:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.049982s ] [2023-05-17T17:02:22+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.040296s ] [2023-05-17T17:02:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.043018s ] [2023-05-17T17:02:22+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.040550s ] [2023-05-17T17:02:23+08:00][sql] CONNECT:[ UseTime:0.044761s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:02:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.032202s ] [2023-05-17T17:02:23+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.030179s ] [2023-05-17T17:02:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.033724s ] [2023-05-17T17:02:23+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.030241s ] [2023-05-17T17:02:23+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 [ RunTime:0.032840s ] [2023-05-17T17:03:50+08:00][sql] CONNECT:[ UseTime:0.095006s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:03:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.067024s ] [2023-05-17T17:03:50+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.063106s ] [2023-05-17T17:03:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.137441s ] [2023-05-17T17:03:50+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.059451s ] [2023-05-17T17:03:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 [ RunTime:0.061285s ] [2023-05-17T17:03:51+08:00][sql] CONNECT:[ UseTime:0.079638s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:03:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.055272s ] [2023-05-17T17:03:51+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.052272s ] [2023-05-17T17:03:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.054812s ] [2023-05-17T17:03:51+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.053615s ] [2023-05-17T17:03:51+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.052589s ] [2023-05-17T17:03:52+08:00][sql] CONNECT:[ UseTime:0.074891s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:03:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.049662s ] [2023-05-17T17:03:52+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.041854s ] [2023-05-17T17:03:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.043991s ] [2023-05-17T17:03:52+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.042261s ] [2023-05-17T17:03:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.044375s ] [2023-05-17T17:03:52+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.041596s ] [2023-05-17T17:03:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.043949s ] [2023-05-17T17:03:52+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.041746s ] [2023-05-17T17:03:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.043692s ] [2023-05-17T17:03:52+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.041666s ] [2023-05-17T17:03:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.043929s ] [2023-05-17T17:03:52+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.041934s ] [2023-05-17T17:03:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.044129s ] [2023-05-17T17:03:52+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.041732s ] [2023-05-17T17:04:20+08:00][sql] CONNECT:[ UseTime:0.088880s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:04:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.061235s ] [2023-05-17T17:04:20+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.058612s ] [2023-05-17T17:04:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.060896s ] [2023-05-17T17:04:20+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.059094s ] [2023-05-17T17:04:21+08:00][sql] CONNECT:[ UseTime:0.079497s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:04:21+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.063800s ] [2023-05-17T17:04:21+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.052296s ] [2023-05-17T17:04:21+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.054890s ] [2023-05-17T17:04:21+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.052811s ] [2023-05-17T17:04:21+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.059544s ] [2023-05-17T17:04:32+08:00][sql] CONNECT:[ UseTime:0.089160s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:04:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.061826s ] [2023-05-17T17:04:32+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.058939s ] [2023-05-17T17:04:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.061195s ] [2023-05-17T17:04:32+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.059797s ] [2023-05-17T17:04:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.061287s ] [2023-05-17T17:04:32+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = '8u4m0yihpswbx9t1.png' , `uri` = 'uploads/images/2023051717043165fb31460.png' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684314271 [ RunTime:0.058883s ] [2023-05-17T17:04:34+08:00][sql] CONNECT:[ UseTime:0.067137s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:04:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.046929s ] [2023-05-17T17:04:34+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.044647s ] [2023-05-17T17:04:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.045217s ] [2023-05-17T17:04:34+08:00][sql] SELECT `id`,`shop_id`,`name`,`pid`,`type`,`level`,`sort`,`del`,`create_time`,`update_time` FROM `ls_file_cate` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.043364s ] [2023-05-17T17:04:40+08:00][sql] CONNECT:[ UseTime:0.045244s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:04:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.031071s ] [2023-05-17T17:04:40+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.028795s ] [2023-05-17T17:04:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.031073s ] [2023-05-17T17:04:40+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.029289s ] [2023-05-17T17:04:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.031252s ] [2023-05-17T17:04:40+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = 've48ur9lnd2xzmwq.jpg' , `uri` = 'uploads/images/20230517170439c834e7097.jpg' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684314279 [ RunTime:0.029753s ] [2023-05-17T17:05:04+08:00][sql] CONNECT:[ UseTime:0.077678s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:05:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.055747s ] [2023-05-17T17:05:04+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.051681s ] [2023-05-17T17:05:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.053980s ] [2023-05-17T17:05:04+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.054789s ] [2023-05-17T17:05:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.058860s ] [2023-05-17T17:05:04+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = 'j2mv3ksfwc7hgza4.png' , `uri` = 'uploads/images/20230517170503279dd1258.png' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684314303 [ RunTime:0.051811s ] [2023-05-17T17:05:05+08:00][sql] CONNECT:[ UseTime:0.087993s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:05:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.059246s ] [2023-05-17T17:05:05+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.057314s ] [2023-05-17T17:05:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.059376s ] [2023-05-17T17:05:05+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.058727s ] [2023-05-17T17:05:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.062573s ] [2023-05-17T17:05:05+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = 'bop9iq30n54kjt8z.png' , `uri` = 'uploads/images/2023051717050458e355901.png' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684314304 [ RunTime:0.057121s ] [2023-05-17T17:05:11+08:00][sql] CONNECT:[ UseTime:0.087404s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:05:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.064123s ] [2023-05-17T17:05:11+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.056821s ] [2023-05-17T17:05:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.058921s ] [2023-05-17T17:05:11+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.056876s ] [2023-05-17T17:05:12+08:00][sql] CONNECT:[ UseTime:0.061050s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:05:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.043960s ] [2023-05-17T17:05:12+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.042827s ] [2023-05-17T17:05:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.042523s ] [2023-05-17T17:05:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.040326s ] [2023-05-17T17:05:12+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.041242s ] [2023-05-17T17:05:17+08:00][sql] CONNECT:[ UseTime:0.058344s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:05:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.036120s ] [2023-05-17T17:05:17+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.041258s ] [2023-05-17T17:05:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.035650s ] [2023-05-17T17:05:17+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.034255s ] [2023-05-17T17:05:17+08:00][sql] CONNECT:[ UseTime:0.073026s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:05:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.050675s ] [2023-05-17T17:05:17+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.054335s ] [2023-05-17T17:05:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.050635s ] [2023-05-17T17:05:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.048619s ] [2023-05-17T17:05:17+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.049643s ] [2023-05-17T17:05:58+08:00][sql] CONNECT:[ UseTime:0.050837s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:05:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.032423s ] [2023-05-17T17:05:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.029301s ] [2023-05-17T17:05:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.032445s ] [2023-05-17T17:05:58+08:00][sql] SELECT * FROM `ls_goods` WHERE `del` = 0 AND `name` = 'SY35U（国四）' AND `shop_id` = 3 LIMIT 1 [ RunTime:0.031082s ] [2023-05-17T17:05:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.034283s ] [2023-05-17T17:05:58+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.031213s ] [2023-05-17T17:05:58+08:00][sql] SELECT `is_product_audit` FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.030080s ] [2023-05-17T17:05:58+08:00][sql] SELECT * FROM `ls_goods` WHERE `code` = 90139967 AND `shop_id` = 3 AND `del` = 0 LIMIT 1 [ RunTime:0.030584s ] [2023-05-17T17:05:58+08:00][sql] INSERT INTO `ls_goods` SET `type` = 0 , `name` = 'SY35U（国四）' , `code` = 90139967 , `shop_id` = 3 , `shop_cate_id` = 3 , `first_cate_id` = 1 , `second_cate_id` = 15 , `third_cate_id` = 0 , `unit_id` = 13 , `brand_id` = 1 , `supplier_id` = 0 , `status` = 0 , `image` = 'uploads/images/2023051717043165fb31460.png' , `video` = '' , `remark` = '国四标准' , `content` = '' , `sort` = 255 , `spec_type` = 1 , `max_price` = '49900' , `min_price` = '49900' , `market_price` = '59900' , `stock` = 1000 , `express_type` = 1 , `express_money` = 0 , `express_template_id` = 0 , `is_recommend` = 0 , `create_time` = 1684314357 , `update_time` = 1684314357 , `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.030475s ] [2023-05-17T17:05:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.031432s ] [2023-05-17T17:05:58+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 10 , `uri` = 'uploads/images/2023051717050458e355901.png' [ RunTime:0.031117s ] [2023-05-17T17:05:58+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 10 , `uri` = 'uploads/images/20230517170503279dd1258.png' [ RunTime:0.030550s ] [2023-05-17T17:05:58+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 10 , `uri` = 'uploads/images/2023051717043165fb31460.png' [ RunTime:0.029658s ] [2023-05-17T17:05:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.033142s ] [2023-05-17T17:05:58+08:00][sql] INSERT INTO `ls_goods_spec` SET `goods_id` = 10 , `name` = '默认' [ RunTime:0.030293s ] [2023-05-17T17:05:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.032217s ] [2023-05-17T17:05:58+08:00][sql] INSERT INTO `ls_goods_spec_value` SET `spec_id` = 15 , `goods_id` = 10 , `value` = '默认' [ RunTime:0.030060s ] [2023-05-17T17:05:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.032092s ] [2023-05-17T17:05:58+08:00][sql] INSERT INTO `ls_goods_item` SET `image` = 'uploads/images/2023051717043165fb31460.png' , `goods_id` = 10 , `spec_value_ids` = '32' , `spec_value_str` = '默认' , `market_price` = '59900' , `price` = '49900' , `stock` = 1000 , `volume` = '0.12' , `weight` = '3780' , `bar_code` = '' , `chengben_price` = '39900' [ RunTime:0.029907s ] [2023-05-17T17:05:59+08:00][sql] CONNECT:[ UseTime:0.061247s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:05:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.040437s ] [2023-05-17T17:05:59+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.038209s ] [2023-05-17T17:05:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.040754s ] [2023-05-17T17:05:59+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.038798s ] [2023-05-17T17:05:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.040714s ] [2023-05-17T17:05:59+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.038071s ] [2023-05-17T17:05:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.040792s ] [2023-05-17T17:05:59+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.038588s ] [2023-05-17T17:06:00+08:00][sql] CONNECT:[ UseTime:0.090410s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:06:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.060442s ] [2023-05-17T17:06:00+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.059286s ] [2023-05-17T17:06:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.067760s ] [2023-05-17T17:06:00+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.076783s ] [2023-05-17T17:06:00+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.112428s ] [2023-05-17T17:06:03+08:00][sql] CONNECT:[ UseTime:0.105417s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:06:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.053456s ] [2023-05-17T17:06:03+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.071709s ] [2023-05-17T17:06:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.073613s ] [2023-05-17T17:06:03+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.059838s ] [2023-05-17T17:06:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 [ RunTime:0.032310s ] [2023-05-17T17:06:05+08:00][sql] CONNECT:[ UseTime:0.093499s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:06:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.061035s ] [2023-05-17T17:06:05+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.047381s ] [2023-05-17T17:06:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.051459s ] [2023-05-17T17:06:05+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.048221s ] [2023-05-17T17:06:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.049951s ] [2023-05-17T17:06:05+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.047543s ] [2023-05-17T17:06:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.049944s ] [2023-05-17T17:06:05+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.048945s ] [2023-05-17T17:06:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.050889s ] [2023-05-17T17:06:05+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.048038s ] [2023-05-17T17:06:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.049432s ] [2023-05-17T17:06:05+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.047735s ] [2023-05-17T17:06:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.051460s ] [2023-05-17T17:06:05+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.048533s ] [2023-05-17T17:06:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.049988s ] [2023-05-17T17:06:05+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 10 LIMIT 1 [ RunTime:0.048584s ] [2023-05-17T17:06:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.049667s ] [2023-05-17T17:06:05+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 10 [ RunTime:0.047728s ] [2023-05-17T17:06:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.050017s ] [2023-05-17T17:06:05+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 10 [ RunTime:0.048593s ] [2023-05-17T17:06:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.049698s ] [2023-05-17T17:06:05+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 10 [ RunTime:0.047561s ] [2023-05-17T17:06:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.049616s ] [2023-05-17T17:06:05+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 10 [ RunTime:0.047654s ] [2023-05-17T17:06:08+08:00][sql] CONNECT:[ UseTime:0.087572s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:06:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.060670s ] [2023-05-17T17:06:08+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.057722s ] [2023-05-17T17:06:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.060530s ] [2023-05-17T17:06:08+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.059137s ] [2023-05-17T17:06:09+08:00][sql] CONNECT:[ UseTime:0.059103s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:06:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.051188s ] [2023-05-17T17:06:09+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.045059s ] [2023-05-17T17:06:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.043476s ] [2023-05-17T17:06:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.050292s ] [2023-05-17T17:06:09+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.040363s ] [2023-05-17T17:06:13+08:00][sql] CONNECT:[ UseTime:0.053606s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:06:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.031346s ] [2023-05-17T17:06:13+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.029132s ] [2023-05-17T17:06:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_bargain` [ RunTime:0.031383s ] [2023-05-17T17:06:13+08:00][sql] SELECT * FROM `ls_bargain` WHERE `goods_id` = 10 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.030166s ] [2023-05-17T17:06:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_seckill_goods` [ RunTime:0.031734s ] [2023-05-17T17:06:13+08:00][sql] SELECT * FROM `ls_seckill_goods` WHERE `goods_id` = 10 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.030449s ] [2023-05-17T17:06:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_team_activity` [ RunTime:0.031570s ] [2023-05-17T17:06:13+08:00][sql] SELECT * FROM `ls_team_activity` WHERE `goods_id` = 10 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.029853s ] [2023-05-17T17:06:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.078174s ] [2023-05-17T17:06:13+08:00][sql] SELECT * FROM `ls_goods` WHERE `del` = 0 AND `name` = 'SY35U（国四）' AND `shop_id` = 3 AND `id` <> 10 LIMIT 1 [ RunTime:0.030123s ] [2023-05-17T17:06:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.031606s ] [2023-05-17T17:06:13+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.030297s ] [2023-05-17T17:06:13+08:00][sql] SELECT * FROM `ls_goods` WHERE `code` = '90139967' AND `del` = 0 AND `id` <> 10 [ RunTime:0.030318s ] [2023-05-17T17:06:13+08:00][sql] SELECT `spec_type` FROM `ls_goods` WHERE `id` = 10 LIMIT 1 [ RunTime:0.029310s ] [2023-05-17T17:06:13+08:00][sql] SELECT `audit_status` FROM `ls_goods` WHERE `id` = 10 LIMIT 1 [ RunTime:0.029143s ] [2023-05-17T17:06:13+08:00][sql] UPDATE `ls_goods` SET `name` = 'SY35U（国四）' , `code` = '90139967' , `shop_cate_id` = 3 , `first_cate_id` = 1 , `second_cate_id` = 15 , `third_cate_id` = 0 , `brand_id` = 1 , `unit_id` = 13 , `supplier_id` = 0 , `status` = 0 , `image` = 'uploads/images/2023051717043165fb31460.png' , `video` = '' , `remark` = '国四标准' , `content` = '' , `sort` = 255 , `spec_type` = 1 , `max_price` = '49900.00' , `min_price` = '49900.00' , `market_price` = '59900.00' , `stock` = 1000 , `express_type` = 1 , `express_money` = 0 , `express_template_id` = 0 , `is_recommend` = 0 , `update_time` = 1684314373 , `stock_warn` = 0 , `poster` = '' , `is_show_stock` = 0 , `is_member` = 1 , `delivery_type` = '1' , `after_pay` = 1 , `after_delivery` = 1 , `delivery_content` = '' WHERE `id` = 10 [ RunTime:0.030005s ] [2023-05-17T17:06:13+08:00][sql] SELECT `id` FROM `ls_goods` WHERE ( `id` = 10 AND `status` <> 1 ) OR ( `id` = 10 AND `del` <> 0 ) OR ( `id` = 10 AND `audit_status` = 2 ) [ RunTime:0.029329s ] [2023-05-17T17:06:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_collect` [ RunTime:0.031793s ] [2023-05-17T17:06:13+08:00][sql] UPDATE `ls_goods_collect` SET `status` = 0 , `update_time` = 1684314373 WHERE `goods_id` = 10 [ RunTime:0.029292s ] [2023-05-17T17:06:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.031002s ] [2023-05-17T17:06:13+08:00][sql] DELETE FROM `ls_goods_image` WHERE `goods_id` = 10 [ RunTime:0.029052s ] [2023-05-17T17:06:13+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 10 , `uri` = 'uploads/images/2023051717050458e355901.png' [ RunTime:0.029329s ] [2023-05-17T17:06:13+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 10 , `uri` = 'uploads/images/20230517170503279dd1258.png' [ RunTime:0.029534s ] [2023-05-17T17:06:13+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 10 , `uri` = 'uploads/images/2023051717043165fb31460.png' [ RunTime:0.030021s ] [2023-05-17T17:06:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_distribution_goods` [ RunTime:0.031045s ] [2023-05-17T17:06:13+08:00][sql] SELECT `id` FROM `ls_distribution_goods` WHERE ( `goods_id` = 10 ) AND `ls_distribution_goods`.`delete_time` IS NULL [ RunTime:0.029354s ] [2023-05-17T17:06:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.031707s ] [2023-05-17T17:06:13+08:00][sql] UPDATE `ls_goods_item` SET `image` = 'uploads/images/2023051717043165fb31460.png' , `market_price` = '59900.00' , `price` = '49900.00' , `chengben_price` = '39900.00' , `stock` = 1000 , `weight` = '3780.000' , `volume` = '0.120' , `bar_code` = '' WHERE `goods_id` = 10 [ RunTime:0.029584s ] [2023-05-17T17:06:15+08:00][sql] CONNECT:[ UseTime:0.072589s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:06:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.041728s ] [2023-05-17T17:06:15+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.042404s ] [2023-05-17T17:06:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.038780s ] [2023-05-17T17:06:15+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.035627s ] [2023-05-17T17:06:16+08:00][sql] CONNECT:[ UseTime:0.044302s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:06:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.031748s ] [2023-05-17T17:06:16+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.029488s ] [2023-05-17T17:06:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.031922s ] [2023-05-17T17:06:16+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.030659s ] [2023-05-17T17:06:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 [ RunTime:0.029355s ] [2023-05-17T17:06:47+08:00][sql] CONNECT:[ UseTime:0.074271s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:06:47+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.058497s ] [2023-05-17T17:06:47+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.046863s ] [2023-05-17T17:06:47+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.049874s ] [2023-05-17T17:06:47+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.048194s ] [2023-05-17T17:06:47+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.047113s ] [2023-05-17T17:06:50+08:00][sql] CONNECT:[ UseTime:0.089464s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:06:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.049286s ] [2023-05-17T17:06:50+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.043278s ] [2023-05-17T17:06:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.048437s ] [2023-05-17T17:06:50+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.044530s ] [2023-05-17T17:06:50+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.044562s ] [2023-05-17T17:06:54+08:00][sql] CONNECT:[ UseTime:0.064864s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:06:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.059985s ] [2023-05-17T17:06:54+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.038024s ] [2023-05-17T17:06:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.042385s ] [2023-05-17T17:06:54+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.038988s ] [2023-05-17T17:06:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 [ RunTime:0.038706s ] [2023-05-17T17:06:58+08:00][sql] CONNECT:[ UseTime:0.086827s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:06:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.055969s ] [2023-05-17T17:06:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.046266s ] [2023-05-17T17:06:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.048684s ] [2023-05-17T17:06:58+08:00][sql] SELECT * FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` 1 ) OR ( `id` = 10 AND `del` <> 0 ) OR ( `id` = 10 AND `audit_status` = 2 ) [ RunTime:0.046081s ] [2023-05-17T17:07:05+08:00][sql] CONNECT:[ UseTime:0.090462s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:07:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.050451s ] [2023-05-17T17:07:05+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.047977s ] [2023-05-17T17:07:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.051406s ] [2023-05-17T17:07:05+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.048517s ] [2023-05-17T17:07:06+08:00][sql] CONNECT:[ UseTime:0.048460s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:07:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.037880s ] [2023-05-17T17:07:06+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.031932s ] [2023-05-17T17:07:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.035747s ] [2023-05-17T17:07:06+08:00][sql] SELECT * FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 0 AND `del` = 0 AND `audit_status` = 1 ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.035535s ] [2023-05-17T17:07:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 0 AND `del` = 0 AND `audit_status` = 1 [ RunTime:0.032512s ] [2023-05-17T17:07:06+08:00][sql] CONNECT:[ UseTime:0.084118s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:07:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.049052s ] [2023-05-17T17:07:06+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.048674s ] [2023-05-17T17:07:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.049567s ] [2023-05-17T17:07:06+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.047947s ] [2023-05-17T17:07:06+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.046817s ] [2023-05-17T17:44:13+08:00][sql] CONNECT:[ UseTime:0.067346s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:44:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.041139s ] [2023-05-17T17:44:13+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.038407s ] [2023-05-17T17:44:18+08:00][sql] CONNECT:[ UseTime:0.122846s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:44:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.059993s ] [2023-05-17T17:44:18+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.056893s ] [2023-05-17T17:44:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.061455s ] [2023-05-17T17:44:18+08:00][sql] SELECT `name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 AND `name` = '起重机' LIMIT 1 [ RunTime:0.057168s ] [2023-05-17T17:44:18+08:00][sql] INSERT INTO `ls_shop_goods_category` SET `name` = '起重机' , `sort` = 255 , `is_show` = 1 , `remark` = '' , `del` = 0 , `shop_id` = 3 , `create_time` = 1684316657 , `update_time` = 1684316657 [ RunTime:0.057022s ] [2023-05-17T17:44:18+08:00][sql] CONNECT:[ UseTime:0.079732s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:44:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.058868s ] [2023-05-17T17:44:18+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.059978s ] [2023-05-17T17:44:18+08:00][sql] CONNECT:[ UseTime:0.076042s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:44:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.049837s ] [2023-05-17T17:44:18+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.044462s ] [2023-05-17T17:44:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.043776s ] [2023-05-17T17:44:18+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.041644s ] [2023-05-17T17:44:18+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.040684s ] [2023-05-17T17:44:23+08:00][sql] CONNECT:[ UseTime:0.092224s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:44:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.054818s ] [2023-05-17T17:44:23+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.047523s ] [2023-05-17T17:44:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.049959s ] [2023-05-17T17:44:23+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.048280s ] [2023-05-17T17:44:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.050251s ] [2023-05-17T17:44:23+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.047547s ] [2023-05-17T17:44:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.062762s ] [2023-05-17T17:44:23+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.049819s ] [2023-05-17T17:44:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.052937s ] [2023-05-17T17:44:23+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.050372s ] [2023-05-17T17:44:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.049977s ] [2023-05-17T17:44:23+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.047948s ] [2023-05-17T17:44:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.049676s ] [2023-05-17T17:44:23+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.047638s ] [2023-05-17T17:44:51+08:00][sql] CONNECT:[ UseTime:0.074802s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:44:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.050280s ] [2023-05-17T17:44:51+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.045131s ] [2023-05-17T17:44:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.057068s ] [2023-05-17T17:44:51+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.081677s ] [2023-05-17T17:44:52+08:00][sql] CONNECT:[ UseTime:0.083290s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:44:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.060293s ] [2023-05-17T17:44:52+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.051631s ] [2023-05-17T17:44:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.052513s ] [2023-05-17T17:44:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.051105s ] [2023-05-17T17:44:52+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.051149s ] [2023-05-17T17:44:58+08:00][sql] CONNECT:[ UseTime:0.050991s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:44:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.043462s ] [2023-05-17T17:44:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.028942s ] [2023-05-17T17:44:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.030662s ] [2023-05-17T17:44:58+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.028880s ] [2023-05-17T17:44:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.033738s ] [2023-05-17T17:44:58+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = '20220413134731_177.jpg' , `uri` = 'uploads/images/202305171744589476e0343.jpg' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684316698 [ RunTime:0.029205s ] [2023-05-17T17:44:59+08:00][sql] CONNECT:[ UseTime:0.044316s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.031425s ] [2023-05-17T17:44:59+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.029271s ] [2023-05-17T17:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.031136s ] [2023-05-17T17:44:59+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.029230s ] [2023-05-17T17:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.031313s ] [2023-05-17T17:44:59+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = '20210426155537_280.jpg' , `uri` = 'uploads/images/20230517174459e51929103.jpg' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684316699 [ RunTime:0.029354s ] [2023-05-17T17:44:59+08:00][sql] CONNECT:[ UseTime:0.059878s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.042290s ] [2023-05-17T17:44:59+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.039421s ] [2023-05-17T17:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.041929s ] [2023-05-17T17:44:59+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.039983s ] [2023-05-17T17:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.041980s ] [2023-05-17T17:44:59+08:00][sql] INSERT INTO `ls_file` SET `cid` = 0 , `type` = 10 , `name` = 'u=1707957934,2070585543&fm=199&app=68&f=JPEG.jpg' , `uri` = 'uploads/images/20230517174459df6c40975.jpg' , `shop_id` = 3 , `user_id` = 0 , `create_time` = 1684316699 [ RunTime:0.054090s ] [2023-05-17T17:45:07+08:00][sql] CONNECT:[ UseTime:0.049520s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:45:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.045388s ] [2023-05-17T17:45:07+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.028795s ] [2023-05-17T17:45:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.045651s ] [2023-05-17T17:45:07+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.029191s ] [2023-05-17T17:45:08+08:00][sql] CONNECT:[ UseTime:0.095963s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:45:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.064430s ] [2023-05-17T17:45:08+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.062234s ] [2023-05-17T17:45:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.064482s ] [2023-05-17T17:45:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.062647s ] [2023-05-17T17:45:08+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.063151s ] [2023-05-17T17:45:40+08:00][sql] CONNECT:[ UseTime:0.086177s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:45:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.048310s ] [2023-05-17T17:45:40+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.041815s ] [2023-05-17T17:45:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_file_cate` [ RunTime:0.044179s ] [2023-05-17T17:45:40+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.042285s ] [2023-05-17T17:45:40+08:00][sql] CONNECT:[ UseTime:0.088709s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:45:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.053259s ] [2023-05-17T17:45:40+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.043761s ] [2023-05-17T17:45:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_file` [ RunTime:0.054081s ] [2023-05-17T17:45:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_file` WHERE `del` = 0 AND `type` = 10 AND `shop_id` = 3 [ RunTime:0.043149s ] [2023-05-17T17:45:40+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.043918s ] [2023-05-17T17:45:56+08:00][sql] CONNECT:[ UseTime:0.101026s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:45:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.056557s ] [2023-05-17T17:45:56+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.053107s ] [2023-05-17T17:45:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.070578s ] [2023-05-17T17:45:56+08:00][sql] SELECT * FROM `ls_goods` WHERE `del` = 0 AND `name` = '雷萨重机FTC25X5（国六）汽车起重机' AND `shop_id` = 3 LIMIT 1 [ RunTime:0.063177s ] [2023-05-17T17:45:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.064302s ] [2023-05-17T17:45:56+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.071002s ] [2023-05-17T17:45:56+08:00][sql] SELECT `is_product_audit` FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.061451s ] [2023-05-17T17:45:56+08:00][sql] SELECT * FROM `ls_goods` WHERE `code` = 89384155 AND `shop_id` = 3 AND `del` = 0 LIMIT 1 [ RunTime:0.063510s ] [2023-05-17T17:45:56+08:00][sql] INSERT INTO `ls_goods` SET `type` = 0 , `name` = '雷萨重机FTC25X5（国六）汽车起重机' , `code` = 89384155 , `shop_id` = 3 , `shop_cate_id` = 4 , `first_cate_id` = 1 , `second_cate_id` = 8 , `third_cate_id` = 0 , `unit_id` = 13 , `brand_id` = 1 , `supplier_id` = 0 , `status` = 1 , `image` = 'uploads/images/20230517174459e51929103.jpg' , `video` = '' , `remark` = '' , `content` = '' , `sort` = 255 , `spec_type` = 1 , `max_price` = '200000' , `min_price` = '200000' , `market_price` = '220000' , `stock` = 1000 , `express_type` = 1 , `express_money` = 0 , `express_template_id` = 0 , `is_recommend` = 0 , `create_time` = 1684316755 , `update_time` = 1684316755 , `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.097633s ] [2023-05-17T17:45:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.063121s ] [2023-05-17T17:45:56+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 11 , `uri` = 'uploads/images/20230517174459e51929103.jpg' [ RunTime:0.073052s ] [2023-05-17T17:45:56+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 11 , `uri` = 'uploads/images/202305171744589476e0343.jpg' [ RunTime:0.068279s ] [2023-05-17T17:45:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.063556s ] [2023-05-17T17:45:56+08:00][sql] INSERT INTO `ls_goods_spec` SET `goods_id` = 11 , `name` = '默认' [ RunTime:0.052903s ] [2023-05-17T17:45:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.054868s ] [2023-05-17T17:45:56+08:00][sql] INSERT INTO `ls_goods_spec_value` SET `spec_id` = 16 , `goods_id` = 11 , `value` = '默认' [ RunTime:0.052950s ] [2023-05-17T17:45:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.055710s ] [2023-05-17T17:45:56+08:00][sql] INSERT INTO `ls_goods_item` SET `image` = 'uploads/images/20230517174459e51929103.jpg' , `goods_id` = 11 , `spec_value_ids` = '33' , `spec_value_str` = '默认' , `market_price` = '220000' , `price` = '200000' , `stock` = 1000 , `volume` = '1' , `weight` = '25000' , `bar_code` = '' , `chengben_price` = '150000' [ RunTime:0.053186s ] [2023-05-17T17:45:58+08:00][sql] CONNECT:[ UseTime:0.084358s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:45:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.056271s ] [2023-05-17T17:45:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.053722s ] [2023-05-17T17:45:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.055798s ] [2023-05-17T17:45:58+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.053740s ] [2023-05-17T17:45:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.055690s ] [2023-05-17T17:45:58+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.053710s ] [2023-05-17T17:45:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.055727s ] [2023-05-17T17:45:58+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.058008s ] [2023-05-17T17:45:58+08:00][sql] CONNECT:[ UseTime:0.076763s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:45:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.057772s ] [2023-05-17T17:45:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.052105s ] [2023-05-17T17:45:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.048921s ] [2023-05-17T17:45: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.047610s ] [2023-05-17T17:45: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.047555s ] [2023-05-17T17:46:16+08:00][sql] CONNECT:[ UseTime:0.113683s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:46:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.062092s ] [2023-05-17T17:46:16+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.059569s ] [2023-05-17T17:46:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.062392s ] [2023-05-17T17:46:16+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.060734s ] [2023-05-17T17:46:16+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 [ RunTime:0.059790s ] [2023-05-17T17:46:18+08:00][sql] CONNECT:[ UseTime:0.092685s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:46:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.046296s ] [2023-05-17T17:46:18+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.040366s ] [2023-05-17T17:46:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.042524s ] [2023-05-17T17:46:18+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.041301s ] [2023-05-17T17:46:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.043016s ] [2023-05-17T17:46:18+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.040842s ] [2023-05-17T17:46:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.043046s ] [2023-05-17T17:46:18+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.040969s ] [2023-05-17T17:46:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.042802s ] [2023-05-17T17:46:18+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.040396s ] [2023-05-17T17:46:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.042240s ] [2023-05-17T17:46:18+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.040770s ] [2023-05-17T17:46:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.042913s ] [2023-05-17T17:46:18+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.040660s ] [2023-05-17T17:46:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.042830s ] [2023-05-17T17:46:18+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 11 LIMIT 1 [ RunTime:0.041966s ] [2023-05-17T17:46:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.043011s ] [2023-05-17T17:46:18+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 11 [ RunTime:0.040860s ] [2023-05-17T17:46:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.043013s ] [2023-05-17T17:46:18+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 11 [ RunTime:0.041071s ] [2023-05-17T17:46:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.042690s ] [2023-05-17T17:46:18+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 11 [ RunTime:0.040846s ] [2023-05-17T17:46:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.042636s ] [2023-05-17T17:46:18+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 11 [ RunTime:0.040807s ] [2023-05-17T17:46:29+08:00][sql] CONNECT:[ UseTime:0.093067s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:46:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.059075s ] [2023-05-17T17:46:29+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.056673s ] [2023-05-17T17:46:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_bargain` [ RunTime:0.058901s ] [2023-05-17T17:46:29+08:00][sql] SELECT * FROM `ls_bargain` WHERE `goods_id` = 11 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.057253s ] [2023-05-17T17:46:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_seckill_goods` [ RunTime:0.058716s ] [2023-05-17T17:46:29+08:00][sql] SELECT * FROM `ls_seckill_goods` WHERE `goods_id` = 11 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.057369s ] [2023-05-17T17:46:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_team_activity` [ RunTime:0.058551s ] [2023-05-17T17:46:29+08:00][sql] SELECT * FROM `ls_team_activity` WHERE `goods_id` = 11 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.059985s ] [2023-05-17T17:46:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.059027s ] [2023-05-17T17:46:29+08:00][sql] SELECT * FROM `ls_goods` WHERE `del` = 0 AND `name` = '雷萨重机FTC25X5（国六）汽车起重机' AND `shop_id` = 3 AND `id` <> 11 LIMIT 1 [ RunTime:0.057525s ] [2023-05-17T17:46:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.059712s ] [2023-05-17T17:46:29+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.058401s ] [2023-05-17T17:46:29+08:00][sql] SELECT * FROM `ls_goods` WHERE `code` = '89384155' AND `del` = 0 AND `id` <> 11 [ RunTime:0.059013s ] [2023-05-17T17:46:29+08:00][sql] SELECT `spec_type` FROM `ls_goods` WHERE `id` = 11 LIMIT 1 [ RunTime:0.056538s ] [2023-05-17T17:46:29+08:00][sql] SELECT `audit_status` FROM `ls_goods` WHERE `id` = 11 LIMIT 1 [ RunTime:0.056394s ] [2023-05-17T17:46:29+08:00][sql] UPDATE `ls_goods` SET `name` = '雷萨重机FTC25X5（国六）汽车起重机' , `code` = '89384155' , `shop_cate_id` = 4 , `first_cate_id` = 1 , `second_cate_id` = 8 , `third_cate_id` = 0 , `brand_id` = 1 , `unit_id` = 13 , `supplier_id` = 0 , `status` = 1 , `image` = 'uploads/images/20230517174459e51929103.jpg' , `video` = '' , `remark` = '' , `content` = '

1、性能：同平台开发，超越25T平台产品

主臂采用BS700MC高强钢板，加高40毫米加宽20毫米全面优化的U型大圆弧截面，,采用单板臂头，提高搭接长度；

主臂行业最长达43米，支腿跨距达行业最大的6.4米，活动支腿加宽40毫米、加高30毫米；

6+1吨活动配重使起重能力全面提升5-10%左右。

2、高效：作业速度高于竞品，低速动作更平稳

变幅油缸内径达到到240MM；

变量双泵合流和107ml/r卷扬变量马达，单绳空载速度达145米/分钟，单绳满载速度达90米/分钟，领先行业；

慢速档精准操控，最低稳定速度更低，动作更平稳。

伸缩与副卷扬同时动作，且主臂自由组合伸缩，工作效率提升10-15%；

3、节能：行业首创I-ECON 节能技术，节油15%

自动根据负载识别该工况最低油耗的发动机转速；

发动机自动从当前状态匹配到最低油耗转速；

不受用户主观操作影响，无论用户操作力度如何变化，发动机始终处于最节油状态

4、舒适：驾乘与工作环境更舒心

欧曼最新一代驾驶室，电动门窗、中控门锁，雷萨固定式卧铺，免去用前用后的折叠，随时可用；

后悬架采用橡胶悬架系统（板簧悬架可选）；

回转与上车空调液压系统互不干扰；

5、智能：人机互换系统

手柄智能集成“动作+油门”，无需脚控踏板，大幅降低操作强度；

增加车身控制器，实现灯光、雨刮等集中逻辑控制，提升整车智能化控制水平，有效提高车身控制的可靠性；


' , `sort` = 255 , `spec_type` = 1 , `max_price` = '200000.00' , `min_price` = '200000.00' , `market_price` = '220000.00' , `stock` = 1000 , `express_type` = 1 , `express_money` = 0 , `express_template_id` = 0 , `is_recommend` = 0 , `update_time` = 1684316789 , `stock_warn` = 0 , `poster` = '' , `is_show_stock` = 0 , `is_member` = 1 , `delivery_type` = '1' , `after_pay` = 1 , `after_delivery` = 1 , `delivery_content` = '' WHERE `id` = 11 [ RunTime:0.058009s ] [2023-05-17T17:46:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.059141s ] [2023-05-17T17:46:29+08:00][sql] DELETE FROM `ls_goods_image` WHERE `goods_id` = 11 [ RunTime:0.057001s ] [2023-05-17T17:46:29+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 11 , `uri` = 'uploads/images/20230517174459e51929103.jpg' [ RunTime:0.058515s ] [2023-05-17T17:46:29+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 11 , `uri` = 'uploads/images/202305171744589476e0343.jpg' [ RunTime:0.065417s ] [2023-05-17T17:46:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_distribution_goods` [ RunTime:0.066884s ] [2023-05-17T17:46:29+08:00][sql] SELECT `id` FROM `ls_distribution_goods` WHERE ( `goods_id` = 11 ) AND `ls_distribution_goods`.`delete_time` IS NULL [ RunTime:0.080487s ] [2023-05-17T17:46:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.070959s ] [2023-05-17T17:46:29+08:00][sql] UPDATE `ls_goods_item` SET `image` = 'uploads/images/20230517174459e51929103.jpg' , `market_price` = '220000.00' , `price` = '200000.00' , `chengben_price` = '150000.00' , `stock` = 1000 , `weight` = '25000.000' , `volume` = '1.000' , `bar_code` = '' WHERE `goods_id` = 11 [ RunTime:0.058496s ] [2023-05-17T17:46:31+08:00][sql] CONNECT:[ UseTime:0.069802s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:46:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.046481s ] [2023-05-17T17:46:31+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.043722s ] [2023-05-17T17:46:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.043858s ] [2023-05-17T17:46:31+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.042643s ] [2023-05-17T17:46:31+08:00][sql] CONNECT:[ UseTime:0.101342s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-17T17:46:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.045778s ] [2023-05-17T17:46:31+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.050771s ] [2023-05-17T17:46:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.045852s ] [2023-05-17T17:46:31+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.051462s ] [2023-05-17T17:46:31+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 [ RunTime:0.046117s ]