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

1066 lines
152 KiB
Raw Permalink Blame History

[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` = '<img src=\"/uploads/images/20230517165207391d58263.jpg\">' , `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` = '<img src=\"/uploads/images/20230517165207391d58263.jpg\">' , `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` = '<img src=\"/uploads/images/20230517170439c834e7097.jpg\">' , `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` <stock_warn ) ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.046849s ]
[2023-05-17T17:06: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.045771s ]
[2023-05-17T17:07:00+08:00][sql] CONNECT:[ UseTime:0.073503s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-17T17:07:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.065369s ]
[2023-05-17T17:07:00+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.047954s ]
[2023-05-17T17:07:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.050754s ]
[2023-05-17T17:07:00+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.049297s ]
[2023-05-17T17:07:00+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.048359s ]
[2023-05-17T17:07:03+08:00][sql] CONNECT:[ UseTime:0.078792s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-17T17:07:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.048768s ]
[2023-05-17T17:07:03+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.045724s ]
[2023-05-17T17:07:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.048370s ]
[2023-05-17T17:07:03+08:00][sql] SELECT `stock` FROM `ls_goods` WHERE `id` = 10 LIMIT 1 [ RunTime:0.045647s ]
[2023-05-17T17:07:03+08:00][sql] UPDATE `ls_goods` SET `status` = 1 , `update_time` = 1684314423 WHERE `id` = 10 [ RunTime:0.048481s ]
[2023-05-17T17:07:03+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.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` = '<img src=\"/uploads/images/20230517174459df6c40975.jpg\">' , `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` = '<p>1、性能：同平台开发，超越25T平台产品</p><p>主臂采用BS700MC高强钢板，加高40毫米加宽20毫米全面优化的U型大圆弧截面，,采用单板臂头，提高搭接长度；</p><p>主臂行业最长达43米，支腿跨距达行业最大的6.4米，活动支腿加宽40毫米、加高30毫米；</p><p>6+1吨活动配重使起重能力全面提升5-10%左右。</p><p>2、高效：作业速度高于竞品，低速动作更平稳</p><p>变幅油缸内径达到到240MM；</p><p>变量双泵合流和107ml/r卷扬变量马达，单绳空载速度达145米/分钟，单绳满载速度达90米/分钟，领先行业；</p><p>慢速档精准操控，最低稳定速度更低，动作更平稳。</p><p>伸缩与副卷扬同时动作，且主臂自由组合伸缩，工作效率提升10-15%；</p><p>3、节能：行业首创I-ECON&nbsp;节能技术，节油15%</p><p>自动根据负载识别该工况最低油耗的发动机转速；</p><p>发动机自动从当前状态匹配到最低油耗转速；</p><p>不受用户主观操作影响，无论用户操作力度如何变化，发动机始终处于最节油状态</p><p>4、舒适：驾乘与工作环境更舒心</p><p>欧曼最新一代驾驶室，电动门窗、中控门锁，雷萨固定式卧铺，免去用前用后的折叠，随时可用；</p><p>后悬架采用橡胶悬架系统（板簧悬架可选）；</p><p>回转与上车空调液压系统互不干扰；</p><p>5、智能：人机互换系统</p><p>手柄智能集成“动作+油门”，无需脚控踏板，大幅降低操作强度；</p><p><span>增加车身控制器，实现灯光、雨刮等集中逻辑控制，提升整车智能化控制水平，有效提高车身控制的可靠性；</span></p><p><span><br></span></p><p><img src=\"/uploads/images/20230517174459df6c40975.jpg\"></p>' , `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 ]