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/202308/18.log

363 lines
48 KiB
Raw Permalink Blame History

[2023-08-18T13:39:12+08:00][sql] CONNECT:[ UseTime:0.065038s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:39:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.045146s ]
[2023-08-18T13:39:12+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.044091s ]
[2023-08-18T13:39:17+08:00][sql] CONNECT:[ UseTime:0.064422s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:39:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.044896s ]
[2023-08-18T13:39:17+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.044723s ]
[2023-08-18T13:39:17+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.042912s ]
[2023-08-18T13:39:17+08:00][sql] UPDATE `ls_shop_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1692337157 WHERE `account` = 'admin' [ RunTime:0.045204s ]
[2023-08-18T13:39:18+08:00][sql] CONNECT:[ UseTime:0.050961s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:39:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.037362s ]
[2023-08-18T13:39:18+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.033899s ]
[2023-08-18T13:39:18+08:00][sql] SELECT * FROM `ls_dev_shop_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.035398s ]
[2023-08-18T13:39:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.037339s ]
[2023-08-18T13:39:18+08:00][sql] SELECT `name` FROM `ls_shop_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.035543s ]
[2023-08-18T13:39:20+08:00][sql] CONNECT:[ UseTime:0.072467s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:39:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.050899s ]
[2023-08-18T13:39:20+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.050354s ]
[2023-08-18T13:39:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.052540s ]
[2023-08-18T13:39:20+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.049257s ]
[2023-08-18T13:39:20+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1692201600 AND 1692287999 [ RunTime:0.048465s ]
[2023-08-18T13:39:20+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 AND `create_time` BETWEEN 1692288000 AND 1692374399 [ RunTime:0.050372s ]
[2023-08-18T13:39:20+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 3 [ RunTime:0.048473s ]
[2023-08-18T13:39:20+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 1692201600 AND 1692287999 [ RunTime:0.049604s ]
[2023-08-18T13:39:20+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 1692288000 AND 1692374399 [ RunTime:0.048770s ]
[2023-08-18T13:39:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.050235s ]
[2023-08-18T13:39:20+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.048316s ]
[2023-08-18T13:39: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 1692201600 AND 1692287999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.048431s ]
[2023-08-18T13:39: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 1692288000 AND 1692374399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.048275s ]
[2023-08-18T13:39:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.049966s ]
[2023-08-18T13:39:20+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.048937s ]
[2023-08-18T13:39:20+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 1692201600 AND 1692287999 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.049583s ]
[2023-08-18T13:39:20+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 1692288000 AND 1692374399 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.048674s ]
[2023-08-18T13:39:20+08:00][sql] CONNECT:[ UseTime:0.053554s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:39:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.032116s ]
[2023-08-18T13:39:20+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.029195s ]
[2023-08-18T13:39:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.030813s ]
[2023-08-18T13:39: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.030139s ]
[2023-08-18T13:39:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.031458s ]
[2023-08-18T13:39:20+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 12 LIMIT 1 [ RunTime:0.030685s ]
[2023-08-18T13:39:20+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 9 LIMIT 1 [ RunTime:0.029343s ]
[2023-08-18T13:39:20+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 10 LIMIT 1 [ RunTime:0.029893s ]
[2023-08-18T13:39:20+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 11 LIMIT 1 [ RunTime:0.029443s ]
[2023-08-18T13:39:20+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 13 LIMIT 1 [ RunTime:0.029400s ]
[2023-08-18T13:39:20+08:00][sql] CONNECT:[ UseTime:0.076110s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:39:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.050680s ]
[2023-08-18T13:39:20+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.048387s ]
[2023-08-18T13:39:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.051782s ]
[2023-08-18T13:39:20+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.050811s ]
[2023-08-18T13:39:20+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.050965s ]
[2023-08-18T13:39:20+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 13 LIMIT 1 [ RunTime:0.048709s ]
[2023-08-18T13:39:21+08:00][sql] CONNECT:[ UseTime:0.061692s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:39:21+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.037449s ]
[2023-08-18T13:39:21+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.035062s ]
[2023-08-18T13:39:21+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.037579s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1690992000 AND 1691078399 AND `pay_status` > 0 [ RunTime:0.036223s ]
[2023-08-18T13:39:21+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.038037s ]
[2023-08-18T13:39:21+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 1690992000 AND 1691078399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.037706s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1691078400 AND 1691164799 AND `pay_status` > 0 [ RunTime:0.035316s ]
[2023-08-18T13:39:21+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 1691078400 AND 1691164799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.035590s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1691164800 AND 1691251199 AND `pay_status` > 0 [ RunTime:0.036169s ]
[2023-08-18T13:39:21+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 1691164800 AND 1691251199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.037025s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1691251200 AND 1691337599 AND `pay_status` > 0 [ RunTime:0.035345s ]
[2023-08-18T13:39:21+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 1691251200 AND 1691337599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.035478s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1691337600 AND 1691423999 AND `pay_status` > 0 [ RunTime:0.035289s ]
[2023-08-18T13:39:21+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 1691337600 AND 1691423999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.035181s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1691424000 AND 1691510399 AND `pay_status` > 0 [ RunTime:0.035579s ]
[2023-08-18T13:39:21+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 1691424000 AND 1691510399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.040136s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1691510400 AND 1691596799 AND `pay_status` > 0 [ RunTime:0.035267s ]
[2023-08-18T13:39:21+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 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.036151s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1691596800 AND 1691683199 AND `pay_status` > 0 [ RunTime:0.035465s ]
[2023-08-18T13:39:21+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 1691596800 AND 1691683199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.035492s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1691683200 AND 1691769599 AND `pay_status` > 0 [ RunTime:0.035436s ]
[2023-08-18T13:39:21+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 1691683200 AND 1691769599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.036022s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1691769600 AND 1691855999 AND `pay_status` > 0 [ RunTime:0.036062s ]
[2023-08-18T13:39:21+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 1691769600 AND 1691855999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.035628s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1691856000 AND 1691942399 AND `pay_status` > 0 [ RunTime:0.036162s ]
[2023-08-18T13:39:21+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 1691856000 AND 1691942399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.035423s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1691942400 AND 1692028799 AND `pay_status` > 0 [ RunTime:0.035772s ]
[2023-08-18T13:39:21+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 1691942400 AND 1692028799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.035808s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1692028800 AND 1692115199 AND `pay_status` > 0 [ RunTime:0.036998s ]
[2023-08-18T13:39:21+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 1692028800 AND 1692115199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.036449s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1692115200 AND 1692201599 AND `pay_status` > 0 [ RunTime:0.035754s ]
[2023-08-18T13:39:21+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 1692115200 AND 1692201599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.035861s ]
[2023-08-18T13:39:21+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 3 AND `create_time` BETWEEN 1692201600 AND 1692287999 AND `pay_status` > 0 [ RunTime:0.036181s ]
[2023-08-18T13:39:21+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 1692201600 AND 1692287999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.036299s ]
[2023-08-18T13:39:22+08:00][sql] CONNECT:[ UseTime:0.097470s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:39:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.062919s ]
[2023-08-18T13:39:22+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.059105s ]
[2023-08-18T13:39:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.060744s ]
[2023-08-18T13:39:22+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.076375s ]
[2023-08-18T13:39:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.073384s ]
[2023-08-18T13:39:22+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.066536s ]
[2023-08-18T13:39:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.060091s ]
[2023-08-18T13:39: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.058290s ]
[2023-08-18T13:39:22+08:00][sql] CONNECT:[ UseTime:0.131932s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:39:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.101059s ]
[2023-08-18T13:39:22+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.069220s ]
[2023-08-18T13:39:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.070402s ]
[2023-08-18T13:39:22+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.076035s ]
[2023-08-18T13:39:22+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.102032s ]
[2023-08-18T13:39:28+08:00][sql] CONNECT:[ UseTime:0.062030s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:39:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.042880s ]
[2023-08-18T13:39:28+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.044297s ]
[2023-08-18T13:39:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.061858s ]
[2023-08-18T13:39:28+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.042496s ]
[2023-08-18T13:39:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.043390s ]
[2023-08-18T13:39:28+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.041556s ]
[2023-08-18T13:39:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.044522s ]
[2023-08-18T13:39:28+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.041656s ]
[2023-08-18T13:39:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.043631s ]
[2023-08-18T13:39:28+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.041550s ]
[2023-08-18T13:39:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.043812s ]
[2023-08-18T13:39:28+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.042330s ]
[2023-08-18T13:39:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.042969s ]
[2023-08-18T13:39:28+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.041787s ]
[2023-08-18T13:39:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.045906s ]
[2023-08-18T13:39:28+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 19 LIMIT 1 [ RunTime:0.043113s ]
[2023-08-18T13:39:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.042886s ]
[2023-08-18T13:39:28+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 19 [ RunTime:0.055139s ]
[2023-08-18T13:39:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.043722s ]
[2023-08-18T13:39:28+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 19 [ RunTime:0.041343s ]
[2023-08-18T13:39:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.043610s ]
[2023-08-18T13:39:28+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 19 [ RunTime:0.041481s ]
[2023-08-18T13:39:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.043546s ]
[2023-08-18T13:39:28+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 19 [ RunTime:0.042144s ]
[2023-08-18T13:44:05+08:00][sql] CONNECT:[ UseTime:0.045111s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:44:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.041664s ]
[2023-08-18T13:44:05+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.029038s ]
[2023-08-18T13:44:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.030765s ]
[2023-08-18T13:44:05+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.029558s ]
[2023-08-18T13:44:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.031382s ]
[2023-08-18T13:44: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.029213s ]
[2023-08-18T13:44:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.030998s ]
[2023-08-18T13:44:05+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.029456s ]
[2023-08-18T13:44:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.031051s ]
[2023-08-18T13:44:05+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.031850s ]
[2023-08-18T13:44:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.031403s ]
[2023-08-18T13:44:05+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.035219s ]
[2023-08-18T13:44:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.031722s ]
[2023-08-18T13:44:05+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.029546s ]
[2023-08-18T13:44:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.031792s ]
[2023-08-18T13:44:05+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 19 LIMIT 1 [ RunTime:0.032791s ]
[2023-08-18T13:44:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.030788s ]
[2023-08-18T13:44:05+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 19 [ RunTime:0.030260s ]
[2023-08-18T13:44:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.031250s ]
[2023-08-18T13:44:05+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 19 [ RunTime:0.029864s ]
[2023-08-18T13:44:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.031942s ]
[2023-08-18T13:44:05+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 19 [ RunTime:0.029127s ]
[2023-08-18T13:44:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.031768s ]
[2023-08-18T13:44:05+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 19 [ RunTime:0.029357s ]
[2023-08-18T13:44:14+08:00][sql] CONNECT:[ UseTime:0.051933s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:44:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.036205s ]
[2023-08-18T13:44:14+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.034148s ]
[2023-08-18T13:44:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_bargain` [ RunTime:0.035634s ]
[2023-08-18T13:44:14+08:00][sql] SELECT * FROM `ls_bargain` WHERE `goods_id` = 19 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.035301s ]
[2023-08-18T13:44:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_seckill_goods` [ RunTime:0.037494s ]
[2023-08-18T13:44:14+08:00][sql] SELECT * FROM `ls_seckill_goods` WHERE `goods_id` = 19 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.035395s ]
[2023-08-18T13:44:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_team_activity` [ RunTime:0.036510s ]
[2023-08-18T13:44:14+08:00][sql] SELECT * FROM `ls_team_activity` WHERE `goods_id` = 19 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.035500s ]
[2023-08-18T13:44:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.036552s ]
[2023-08-18T13:44:14+08:00][sql] SELECT * FROM `ls_goods` WHERE `del` = 0 AND `name` = '电动吊篮ZLP630' AND `shop_id` = 3 AND `id` <> 19 LIMIT 1 [ RunTime:0.037906s ]
[2023-08-18T13:44:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.036858s ]
[2023-08-18T13:44:14+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.035666s ]
[2023-08-18T13:44:14+08:00][sql] SELECT * FROM `ls_goods` WHERE `code` = '25741303' AND `del` = 0 AND `id` <> 19 [ RunTime:0.039077s ]
[2023-08-18T13:44:14+08:00][sql] SELECT `spec_type` FROM `ls_goods` WHERE `id` = 19 LIMIT 1 [ RunTime:0.034000s ]
[2023-08-18T13:44:57+08:00][sql] CONNECT:[ UseTime:0.078913s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.056907s ]
[2023-08-18T13:44:57+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.062686s ]
[2023-08-18T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.086199s ]
[2023-08-18T13:44:57+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.096765s ]
[2023-08-18T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.062354s ]
[2023-08-18T13:44:57+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 3 ORDER BY `id` ASC [ RunTime:0.082163s ]
[2023-08-18T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.090502s ]
[2023-08-18T13:44:57+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.093868s ]
[2023-08-18T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.096988s ]
[2023-08-18T13:44:57+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.099178s ]
[2023-08-18T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.088914s ]
[2023-08-18T13:44:57+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.113461s ]
[2023-08-18T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.086670s ]
[2023-08-18T13:44:57+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.082856s ]
[2023-08-18T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.059516s ]
[2023-08-18T13:44:57+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 19 LIMIT 1 [ RunTime:0.057398s ]
[2023-08-18T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.066130s ]
[2023-08-18T13:44:57+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 19 [ RunTime:0.066425s ]
[2023-08-18T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.073368s ]
[2023-08-18T13:44:57+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 19 [ RunTime:0.120201s ]
[2023-08-18T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.112872s ]
[2023-08-18T13:44:57+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 19 [ RunTime:0.079752s ]
[2023-08-18T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.067166s ]
[2023-08-18T13:44:57+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 19 [ RunTime:0.056803s ]
[2023-08-18T13:45:16+08:00][sql] CONNECT:[ UseTime:0.062650s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:45:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.050000s ]
[2023-08-18T13:45:16+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.083420s ]
[2023-08-18T13:45:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_bargain` [ RunTime:0.047453s ]
[2023-08-18T13:45:16+08:00][sql] SELECT * FROM `ls_bargain` WHERE `goods_id` = 19 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.041937s ]
[2023-08-18T13:45:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_seckill_goods` [ RunTime:0.055148s ]
[2023-08-18T13:45:16+08:00][sql] SELECT * FROM `ls_seckill_goods` WHERE `goods_id` = 19 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.043250s ]
[2023-08-18T13:45:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_team_activity` [ RunTime:0.043119s ]
[2023-08-18T13:45:16+08:00][sql] SELECT * FROM `ls_team_activity` WHERE `goods_id` = 19 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.043158s ]
[2023-08-18T13:45:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.043752s ]
[2023-08-18T13:45:16+08:00][sql] SELECT * FROM `ls_goods` WHERE `del` = 0 AND `name` = '电动吊篮ZLP630' AND `shop_id` = 3 AND `id` <> 19 LIMIT 1 [ RunTime:0.044520s ]
[2023-08-18T13:45:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.044767s ]
[2023-08-18T13:45:16+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.043857s ]
[2023-08-18T13:45:16+08:00][sql] SELECT * FROM `ls_goods` WHERE `code` = '25741303' AND `del` = 0 AND `id` <> 19 [ RunTime:0.043576s ]
[2023-08-18T13:45:16+08:00][sql] SELECT `spec_type` FROM `ls_goods` WHERE `id` = 19 LIMIT 1 [ RunTime:0.046298s ]
[2023-08-18T13:45:16+08:00][sql] SELECT `audit_status` FROM `ls_goods` WHERE `id` = 19 LIMIT 1 [ RunTime:0.043451s ]
[2023-08-18T13:45:16+08:00][sql] UPDATE `ls_goods` SET `name` = '电动吊篮ZLP630' , `code` = '25741303' , `shop_cate_id` = 4 , `first_cate_id` = 1 , `second_cate_id` = 2 , `third_cate_id` = 3 , `brand_id` = 0 , `unit_id` = 13 , `supplier_id` = 0 , `status` = 1 , `image` = '/uploads/images/202308151520097c7120114.png' , `video` = '' , `remark` = '' , `content` = '' , `sort` = 255 , `spec_type` = 1 , `max_price` = '6500.00' , `min_price` = '6500.00' , `market_price` = '8000.00' , `stock` = 30 , `express_type` = 1 , `express_money` = 0 , `express_template_id` = 0 , `is_recommend` = 0 , `update_time` = 1692337515 , `stock_warn` = 0 , `poster` = '/uploads/images/20230815152024af0dc5485.png' , `is_show_stock` = 0 , `is_member` = 1 , `delivery_type` = '1' , `after_pay` = 1 , `after_delivery` = 1 , `delivery_content` = '' WHERE `id` = 19 [ RunTime:0.043149s ]
[2023-08-18T13:45:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.043123s ]
[2023-08-18T13:45:16+08:00][sql] DELETE FROM `ls_goods_image` WHERE `goods_id` = 19 [ RunTime:0.043779s ]
[2023-08-18T13:45:16+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 19 , `uri` = '/uploads/images/20230815152043a25ea3979.png' [ RunTime:0.084318s ]
[2023-08-18T13:45:16+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 19 , `uri` = '/uploads/images/20230815152024af0dc5485.png' [ RunTime:0.042536s ]
[2023-08-18T13:45:16+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 19 , `uri` = '/uploads/images/202308151520097c7120114.png' [ RunTime:0.042223s ]
[2023-08-18T13:45:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_distribution_goods` [ RunTime:0.046311s ]
[2023-08-18T13:45:16+08:00][sql] SELECT `id` FROM `ls_distribution_goods` WHERE ( `goods_id` = 19 ) AND `ls_distribution_goods`.`delete_time` IS NULL [ RunTime:0.042144s ]
[2023-08-18T13:45:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.049164s ]
[2023-08-18T13:45:16+08:00][sql] UPDATE `ls_goods_item` SET `image` = '/uploads/images/202308151520097c7120114.png' , `market_price` = '8000.00' , `price` = '6500.00' , `chengben_price` = '4000.00' , `stock` = 30 , `weight` = '630.000' , `volume` = '7.000' , `bar_code` = '' WHERE `goods_id` = 19 [ RunTime:0.045511s ]
[2023-08-18T13:45:17+08:00][sql] CONNECT:[ UseTime:0.056830s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:45:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.041598s ]
[2023-08-18T13:45:17+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.037865s ]
[2023-08-18T13:45:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.040060s ]
[2023-08-18T13:45:17+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.037428s ]
[2023-08-18T13:45:17+08:00][sql] CONNECT:[ UseTime:0.063122s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:45:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.044789s ]
[2023-08-18T13:45:17+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.046049s ]
[2023-08-18T13:45:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.044220s ]
[2023-08-18T13:45:17+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.045880s ]
[2023-08-18T13:45:17+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.043118s ]
[2023-08-18T13:47:59+08:00][sql] CONNECT:[ UseTime:0.058639s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:47:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.039328s ]
[2023-08-18T13:47:59+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.033778s ]
[2023-08-18T13:47:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.035466s ]
[2023-08-18T13:47:59+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.040044s ]
[2023-08-18T13:47:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.037903s ]
[2023-08-18T13:47: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.036295s ]
[2023-08-18T13:47:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.041612s ]
[2023-08-18T13:47:59+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.036867s ]
[2023-08-18T13:47:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.036527s ]
[2023-08-18T13:47:59+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.034004s ]
[2023-08-18T13:47:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.035563s ]
[2023-08-18T13:47:59+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.034744s ]
[2023-08-18T13:47:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.039845s ]
[2023-08-18T13:47:59+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.034643s ]
[2023-08-18T13:47:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.036148s ]
[2023-08-18T13:47:59+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 19 LIMIT 1 [ RunTime:0.035447s ]
[2023-08-18T13:47:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.035750s ]
[2023-08-18T13:47:59+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 19 [ RunTime:0.035005s ]
[2023-08-18T13:47:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.035164s ]
[2023-08-18T13:47:59+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 19 [ RunTime:0.038274s ]
[2023-08-18T13:47:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.035455s ]
[2023-08-18T13:47:59+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 19 [ RunTime:0.251134s ]
[2023-08-18T13:47:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.035164s ]
[2023-08-18T13:47:59+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 19 [ RunTime:0.034780s ]
[2023-08-18T13:48:12+08:00][sql] CONNECT:[ UseTime:0.061042s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:48:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.043362s ]
[2023-08-18T13:48:12+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.047302s ]
[2023-08-18T13:48:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_bargain` [ RunTime:0.045662s ]
[2023-08-18T13:48:12+08:00][sql] SELECT * FROM `ls_bargain` WHERE `goods_id` = 19 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.041540s ]
[2023-08-18T13:48:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_seckill_goods` [ RunTime:0.043768s ]
[2023-08-18T13:48:12+08:00][sql] SELECT * FROM `ls_seckill_goods` WHERE `goods_id` = 19 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.041419s ]
[2023-08-18T13:48:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_team_activity` [ RunTime:0.045045s ]
[2023-08-18T13:48:12+08:00][sql] SELECT * FROM `ls_team_activity` WHERE `goods_id` = 19 AND `del` = 0 AND `shop_id` = 3 LIMIT 1 [ RunTime:0.041889s ]
[2023-08-18T13:48:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.045137s ]
[2023-08-18T13:48:12+08:00][sql] SELECT * FROM `ls_goods` WHERE `del` = 0 AND `name` = '电动吊篮ZLP630' AND `shop_id` = 3 AND `id` <> 19 LIMIT 1 [ RunTime:0.042551s ]
[2023-08-18T13:48:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.042824s ]
[2023-08-18T13:48:12+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 3 LIMIT 1 [ RunTime:0.042232s ]
[2023-08-18T13:48:12+08:00][sql] SELECT * FROM `ls_goods` WHERE `code` = '25741303' AND `del` = 0 AND `id` <> 19 [ RunTime:0.047244s ]
[2023-08-18T13:48:12+08:00][sql] SELECT `spec_type` FROM `ls_goods` WHERE `id` = 19 LIMIT 1 [ RunTime:0.042575s ]
[2023-08-18T13:48:12+08:00][sql] SELECT `audit_status` FROM `ls_goods` WHERE `id` = 19 LIMIT 1 [ RunTime:0.041072s ]
[2023-08-18T13:48:12+08:00][sql] UPDATE `ls_goods` SET `name` = '电动吊篮ZLP630' , `code` = '25741303' , `shop_cate_id` = 4 , `first_cate_id` = 1 , `second_cate_id` = 2 , `third_cate_id` = 3 , `brand_id` = 0 , `brand_name` = '三一重工' , `unit_id` = 13 , `supplier_id` = 0 , `status` = 1 , `image` = '/uploads/images/202308151520097c7120114.png' , `video` = '' , `remark` = '' , `content` = '' , `sort` = 255 , `spec_type` = 1 , `max_price` = '6500.00' , `min_price` = '6500.00' , `market_price` = '8000.00' , `stock` = 30 , `express_type` = 1 , `express_money` = 0 , `express_template_id` = 0 , `is_recommend` = 0 , `update_time` = 1692337692 , `stock_warn` = 0 , `poster` = '/uploads/images/20230815152024af0dc5485.png' , `is_show_stock` = 0 , `is_member` = 1 , `delivery_type` = '1' , `after_pay` = 1 , `after_delivery` = 1 , `delivery_content` = '' WHERE `id` = 19 [ RunTime:0.042346s ]
[2023-08-18T13:48:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.042959s ]
[2023-08-18T13:48:12+08:00][sql] DELETE FROM `ls_goods_image` WHERE `goods_id` = 19 [ RunTime:0.042936s ]
[2023-08-18T13:48:12+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 19 , `uri` = '/uploads/images/20230815152043a25ea3979.png' [ RunTime:0.043528s ]
[2023-08-18T13:48:12+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 19 , `uri` = '/uploads/images/20230815152024af0dc5485.png' [ RunTime:0.040995s ]
[2023-08-18T13:48:12+08:00][sql] INSERT INTO `ls_goods_image` SET `goods_id` = 19 , `uri` = '/uploads/images/202308151520097c7120114.png' [ RunTime:0.044320s ]
[2023-08-18T13:48:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_distribution_goods` [ RunTime:0.044670s ]
[2023-08-18T13:48:12+08:00][sql] SELECT `id` FROM `ls_distribution_goods` WHERE ( `goods_id` = 19 ) AND `ls_distribution_goods`.`delete_time` IS NULL [ RunTime:0.042604s ]
[2023-08-18T13:48:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.043687s ]
[2023-08-18T13:48:12+08:00][sql] UPDATE `ls_goods_item` SET `image` = '/uploads/images/202308151520097c7120114.png' , `market_price` = '8000.00' , `price` = '6500.00' , `chengben_price` = '4000.00' , `stock` = 30 , `weight` = '630.000' , `volume` = '7.000' , `bar_code` = '' WHERE `goods_id` = 19 [ RunTime:0.042923s ]
[2023-08-18T13:48:14+08:00][sql] CONNECT:[ UseTime:0.052663s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:48:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.044922s ]
[2023-08-18T13:48:14+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.033332s ]
[2023-08-18T13:48:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.035488s ]
[2023-08-18T13:48:14+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 3 [ RunTime:0.033603s ]
[2023-08-18T13:48:14+08:00][sql] CONNECT:[ UseTime:0.054358s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:48:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.044456s ]
[2023-08-18T13:48:14+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.034823s ]
[2023-08-18T13:48:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.038939s ]
[2023-08-18T13:48:14+08:00][sql] SELECT * FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.040294s ]
[2023-08-18T13:48:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) [ RunTime:0.052839s ]
[2023-08-18T13:48:29+08:00][sql] CONNECT:[ UseTime:0.083157s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:48:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.055747s ]
[2023-08-18T13:48:29+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.053336s ]
[2023-08-18T13:48:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.055400s ]
[2023-08-18T13:48:29+08:00][sql] SELECT * FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 2 ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.056578s ]
[2023-08-18T13:48:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 2 [ RunTime:0.053065s ]
[2023-08-18T13:48:35+08:00][sql] CONNECT:[ UseTime:0.049258s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:48:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.031488s ]
[2023-08-18T13:48:35+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.031702s ]
[2023-08-18T13:48:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.033196s ]
[2023-08-18T13:48:35+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.032451s ]
[2023-08-18T13:48:35+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.030219s ]
[2023-08-18T13:48:39+08:00][sql] CONNECT:[ UseTime:0.050279s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:48:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.035337s ]
[2023-08-18T13:48:39+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.033993s ]
[2023-08-18T13:48:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.036140s ]
[2023-08-18T13:48:39+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.034586s ]
[2023-08-18T13:48:39+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 3 AND `del` <> 1 AND `audit_status` = 0 [ RunTime:0.034477s ]
[2023-08-18T13:48:40+08:00][sql] CONNECT:[ UseTime:0.129013s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:48:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.092772s ]
[2023-08-18T13:48:40+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.072026s ]
[2023-08-18T13:48:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.068455s ]
[2023-08-18T13:48:40+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.069150s ]
[2023-08-18T13:48:40+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.074498s ]
[2023-08-18T13:50:59+08:00][sql] CONNECT:[ UseTime:0.058540s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:50:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.044067s ]
[2023-08-18T13:50:59+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.038638s ]
[2023-08-18T13:50:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.040781s ]
[2023-08-18T13:50:59+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.039105s ]
[2023-08-18T13:50:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.041189s ]
[2023-08-18T13:50: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.039863s ]
[2023-08-18T13:50:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.042385s ]
[2023-08-18T13:50:59+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.038869s ]
[2023-08-18T13:50:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.042253s ]
[2023-08-18T13:50:59+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.039034s ]
[2023-08-18T13:50:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.040779s ]
[2023-08-18T13:50:59+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.038501s ]
[2023-08-18T13:50:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.040599s ]
[2023-08-18T13:50:59+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.039015s ]
[2023-08-18T13:50:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.041990s ]
[2023-08-18T13:50:59+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 19 LIMIT 1 [ RunTime:0.040415s ]
[2023-08-18T13:50:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.052396s ]
[2023-08-18T13:50:59+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 19 [ RunTime:0.047924s ]
[2023-08-18T13:50:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.040162s ]
[2023-08-18T13:50:59+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 19 [ RunTime:0.038990s ]
[2023-08-18T13:50:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.047642s ]
[2023-08-18T13:50:59+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 19 [ RunTime:0.048274s ]
[2023-08-18T13:50:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.049917s ]
[2023-08-18T13:50:59+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 19 [ RunTime:0.049165s ]
[2023-08-18T13:53:52+08:00][sql] CONNECT:[ UseTime:0.044670s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-08-18T13:53:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.032487s ]
[2023-08-18T13:53:52+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.048393s ]
[2023-08-18T13:53:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.035579s ]
[2023-08-18T13:53:52+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.029305s ]
[2023-08-18T13:53:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.032569s ]
[2023-08-18T13:53: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.029402s ]
[2023-08-18T13:53:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.033107s ]
[2023-08-18T13:53:52+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.031125s ]
[2023-08-18T13:53:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.031931s ]
[2023-08-18T13:53:52+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 3 [ RunTime:0.030606s ]
[2023-08-18T13:53:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.031245s ]
[2023-08-18T13:53:52+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.032627s ]
[2023-08-18T13:53:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.031097s ]
[2023-08-18T13:53:52+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 3 [ RunTime:0.031562s ]
[2023-08-18T13:53:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.033939s ]
[2023-08-18T13:53:52+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 19 LIMIT 1 [ RunTime:0.032188s ]
[2023-08-18T13:53:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.031718s ]
[2023-08-18T13:53:52+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 19 [ RunTime:0.029085s ]
[2023-08-18T13:53:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.032256s ]
[2023-08-18T13:53:52+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 19 [ RunTime:0.042935s ]
[2023-08-18T13:53:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.030625s ]
[2023-08-18T13:53:52+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 19 [ RunTime:0.028962s ]
[2023-08-18T13:53:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.033035s ]
[2023-08-18T13:53:52+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 19 [ RunTime:0.029092s ]