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/12.log

294 lines
40 KiB
Raw Permalink Blame History

[2023-05-12T10:12:03+08:00][sql] CONNECT:[ UseTime:0.001093s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.003394s ]
[2023-05-12T10:12:03+08:00][sql] SELECT `a`.* FROM `ls_shop_admin` `a` INNER JOIN `ls_shop` `s` ON `s`.`id`=`a`.`shop_id` WHERE `a`.`account` = '777777' AND `a`.`del` = 0 LIMIT 1 [ RunTime:0.000881s ]
[2023-05-12T10:12:03+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` = '777777' AND `a`.`del` = 0 LIMIT 1 [ RunTime:0.000289s ]
[2023-05-12T10:12:03+08:00][sql] UPDATE `ls_shop_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1683857523 WHERE `account` = '777777' [ RunTime:0.000686s ]
[2023-05-12T10:12:05+08:00][sql] CONNECT:[ UseTime:0.001151s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.011451s ]
[2023-05-12T10:12:05+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000244s ]
[2023-05-12T10:12:05+08:00][sql] SELECT * FROM `ls_dev_shop_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.000500s ]
[2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.009685s ]
[2023-05-12T10:12:05+08:00][sql] SELECT `name` FROM `ls_shop_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000263s ]
[2023-05-12T10:12:05+08:00][sql] CONNECT:[ UseTime:0.001168s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003338s ]
[2023-05-12T10:12:05+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000217s ]
[2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.003156s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 2 [ RunTime:0.000284s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 2 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.000210s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 2 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000177s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 2 [ RunTime:0.000183s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 2 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.000169s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `shop_id` = 2 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000158s ]
[2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.010097s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000359s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000247s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000215s ]
[2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.013565s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 2 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.000359s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.000252s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_goods_click` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `user_id` ) `_group_count_` [ RunTime:0.000212s ]
[2023-05-12T10:12:05+08:00][sql] CONNECT:[ UseTime:0.001047s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003090s ]
[2023-05-12T10:12:05+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000271s ]
[2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.003566s ]
[2023-05-12T10:12:05+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` = 2 AND `o`.`pay_status` > 0 GROUP BY `og`.`goods_id` ORDER BY `order_amount` DESC LIMIT 5 [ RunTime:0.009276s ]
[2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.000812s ]
[2023-05-12T10:12:05+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000209s ]
[2023-05-12T10:12:05+08:00][sql] CONNECT:[ UseTime:0.022271s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003316s ]
[2023-05-12T10:12:05+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000287s ]
[2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.003398s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682524800 AND 1682611199 AND `pay_status` > 0 [ RunTime:0.000263s ]
[2023-05-12T10:12:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_stat` [ RunTime:0.002951s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682524800 AND 1682611199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000272s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682611200 AND 1682697599 AND `pay_status` > 0 [ RunTime:0.000191s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682611200 AND 1682697599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000214s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682697600 AND 1682783999 AND `pay_status` > 0 [ RunTime:0.000182s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682697600 AND 1682783999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000204s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682784000 AND 1682870399 AND `pay_status` > 0 [ RunTime:0.000173s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682784000 AND 1682870399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000203s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682870400 AND 1682956799 AND `pay_status` > 0 [ RunTime:0.000174s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682870400 AND 1682956799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000193s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682956800 AND 1683043199 AND `pay_status` > 0 [ RunTime:0.000171s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1682956800 AND 1683043199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000287s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683043200 AND 1683129599 AND `pay_status` > 0 [ RunTime:0.000239s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683043200 AND 1683129599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000257s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683129600 AND 1683215999 AND `pay_status` > 0 [ RunTime:0.000188s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000252s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683216000 AND 1683302399 AND `pay_status` > 0 [ RunTime:0.000187s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683216000 AND 1683302399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000220s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683302400 AND 1683388799 AND `pay_status` > 0 [ RunTime:0.000183s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683302400 AND 1683388799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000251s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683388800 AND 1683475199 AND `pay_status` > 0 [ RunTime:0.000213s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683388800 AND 1683475199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000197s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683475200 AND 1683561599 AND `pay_status` > 0 [ RunTime:0.000172s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683475200 AND 1683561599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000255s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683561600 AND 1683647999 AND `pay_status` > 0 [ RunTime:0.000176s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683561600 AND 1683647999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000188s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683648000 AND 1683734399 AND `pay_status` > 0 [ RunTime:0.000161s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683648000 AND 1683734399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000183s ]
[2023-05-12T10:12:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683734400 AND 1683820799 AND `pay_status` > 0 [ RunTime:0.000159s ]
[2023-05-12T10:12:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_shop_stat` WHERE `shop_id` = 2 AND `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000181s ]
[2023-05-12T10:12:06+08:00][sql] CONNECT:[ UseTime:0.001270s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.002941s ]
[2023-05-12T10:12:06+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000321s ]
[2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_click` [ RunTime:0.003118s ]
[2023-05-12T10:12:06+08:00][sql] SELECT goods_id,count(DISTINCT user_id) as visited_num FROM `ls_goods_click` WHERE `shop_id` = 2 GROUP BY `goods_id` ORDER BY `visited_num` DESC LIMIT 5 [ RunTime:0.000530s ]
[2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003849s ]
[2023-05-12T10:12:06+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000270s ]
[2023-05-12T10:12:06+08:00][sql] SELECT `name`,`image` FROM `ls_goods` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000209s ]
[2023-05-12T10:12:06+08:00][sql] CONNECT:[ UseTime:0.001121s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003121s ]
[2023-05-12T10:12:06+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000194s ]
[2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.003346s ]
[2023-05-12T10:12:06+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.000264s ]
[2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.002893s ]
[2023-05-12T10:12:06+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 2 ORDER BY `id` ASC [ RunTime:0.000225s ]
[2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003498s ]
[2023-05-12T10:12:06+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 AND `shop_id` = 2 [ RunTime:0.000538s ]
[2023-05-12T10:12:06+08:00][sql] CONNECT:[ UseTime:0.001121s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003153s ]
[2023-05-12T10:12:06+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000204s ]
[2023-05-12T10:12:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003278s ]
[2023-05-12T10:12:06+08:00][sql] SELECT * FROM `ls_goods` WHERE `shop_id` = 2 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.000512s ]
[2023-05-12T10:12:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` WHERE `shop_id` = 2 AND `status` = 1 AND `del` = 0 AND `audit_status` = 1 AND ( `stock` >=stock_warn ) [ RunTime:0.000248s ]
[2023-05-12T10:12:10+08:00][sql] CONNECT:[ UseTime:0.001141s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003320s ]
[2023-05-12T10:12:10+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000248s ]
[2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.003080s ]
[2023-05-12T10:12:10+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.000251s ]
[2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.002832s ]
[2023-05-12T10:12:10+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 2 ORDER BY `id` ASC [ RunTime:0.000231s ]
[2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.003166s ]
[2023-05-12T10:12:10+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.000354s ]
[2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.002932s ]
[2023-05-12T10:12:10+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000231s ]
[2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.002849s ]
[2023-05-12T10:12:10+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.000211s ]
[2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.002781s ]
[2023-05-12T10:12:10+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 2 [ RunTime:0.000186s ]
[2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003428s ]
[2023-05-12T10:12:10+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000391s ]
[2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.003133s ]
[2023-05-12T10:12:10+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 8 [ RunTime:0.000262s ]
[2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.002819s ]
[2023-05-12T10:12:10+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 8 [ RunTime:0.000224s ]
[2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.002766s ]
[2023-05-12T10:12:10+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 8 [ RunTime:0.000182s ]
[2023-05-12T10:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.002829s ]
[2023-05-12T10:12:10+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 8 [ RunTime:0.000316s ]
[2023-05-12T10:16:27+08:00][sql] CONNECT:[ UseTime:0.001138s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003816s ]
[2023-05-12T10:16:27+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000271s ]
[2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.003027s ]
[2023-05-12T10:16:27+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.000246s ]
[2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.003570s ]
[2023-05-12T10:16:27+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 2 ORDER BY `id` ASC [ RunTime:0.000492s ]
[2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.003091s ]
[2023-05-12T10:16:27+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.000216s ]
[2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.002849s ]
[2023-05-12T10:16:27+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000195s ]
[2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.002810s ]
[2023-05-12T10:16:27+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.000197s ]
[2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.003443s ]
[2023-05-12T10:16:27+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 2 [ RunTime:0.000291s ]
[2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003438s ]
[2023-05-12T10:16:27+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 7 LIMIT 1 [ RunTime:0.000354s ]
[2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.002791s ]
[2023-05-12T10:16:27+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 7 [ RunTime:0.000194s ]
[2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.003009s ]
[2023-05-12T10:16:27+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 7 [ RunTime:0.000291s ]
[2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.003703s ]
[2023-05-12T10:16:27+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 7 [ RunTime:0.000261s ]
[2023-05-12T10:16:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.002812s ]
[2023-05-12T10:16:27+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 7 [ RunTime:0.000195s ]
[2023-05-12T10:16:32+08:00][sql] CONNECT:[ UseTime:0.001159s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:16:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003193s ]
[2023-05-12T10:16:32+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000208s ]
[2023-05-12T10:16:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.007637s ]
[2023-05-12T10:16:32+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'type' AND `shop_id` = 2 LIMIT 1 [ RunTime:0.000402s ]
[2023-05-12T10:16:32+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'wechat' AND `shop_id` = 2 LIMIT 1 [ RunTime:0.000359s ]
[2023-05-12T10:16:32+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'phone' AND `shop_id` = 2 LIMIT 1 [ RunTime:0.000321s ]
[2023-05-12T10:16:32+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'shop_customer_service' AND `name` = 'business_time' AND `shop_id` = 2 LIMIT 1 [ RunTime:0.000335s ]
[2023-05-12T10:16:40+08:00][sql] CONNECT:[ UseTime:0.001243s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:16:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003158s ]
[2023-05-12T10:16:40+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000204s ]
[2023-05-12T10:16:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.003257s ]
[2023-05-12T10:16:40+08:00][sql] SELECT `id`,`cid`,`type`,`name`,`nickname`,`mobile`,`wallet`,`logo`,`background`,`license`,`keywords`,`intro`,`weight`,`trade_service_fee`,`weekdays`,`service_mobile`,`province_id`,`city_id`,`district_id`,`address`,`longitude`,`latitude`,`refund_address`,`run_start_time`,`run_end_time`,`is_run`,`is_freeze`,`is_product_audit`,`is_recommend`,`del`,`expire_time`,`create_time`,`update_time`,`score`,`star`,`visited_num`,`is_distribution`,`is_pay`,`cover`,`banner`,`business_license`,`other_qualifications`,`open_invoice`,`spec_invoice`,`delivery_type` FROM `ls_shop` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000361s ]
[2023-05-12T10:16:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.002844s ]
[2023-05-12T10:16:40+08:00][sql] SELECT * FROM `ls_shop_category` WHERE `id` = 1 [ RunTime:0.000207s ]
[2023-05-12T10:16:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.003014s ]
[2023-05-12T10:16:40+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'map' AND `name` = 'tx_map_key' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000254s ]
[2023-05-12T10:16:58+08:00][sql] CONNECT:[ UseTime:0.001163s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:16:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003167s ]
[2023-05-12T10:16:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000191s ]
[2023-05-12T10:16:58+08:00][sql] CONNECT:[ UseTime:0.001110s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:16:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003444s ]
[2023-05-12T10:16:58+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000224s ]
[2023-05-12T10:16:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_bank` [ RunTime:0.007398s ]
[2023-05-12T10:16:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_bank` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000261s ]
[2023-05-12T10:16:58+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` = 2 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000211s ]
[2023-05-12T10:17:03+08:00][sql] CONNECT:[ UseTime:0.001185s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003429s ]
[2023-05-12T10:17:03+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000222s ]
[2023-05-12T10:17:08+08:00][sql] CONNECT:[ UseTime:0.001186s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003140s ]
[2023-05-12T10:17:08+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000196s ]
[2023-05-12T10:17:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.003052s ]
[2023-05-12T10:17:08+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'express' AND `name` = 'way' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000243s ]
[2023-05-12T10:17:08+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kd100' AND `name` = 'appkey' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000224s ]
[2023-05-12T10:17:08+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kd100' AND `name` = 'appsecret' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000255s ]
[2023-05-12T10:17:08+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kdniao' AND `name` = 'appkey' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000235s ]
[2023-05-12T10:17:08+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kdniao' AND `name` = 'appsecret' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000226s ]
[2023-05-12T10:17:08+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'kdniao' AND `name` = 'type' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000290s ]
[2023-05-12T10:17:08+08:00][sql] CONNECT:[ UseTime:0.001185s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000735s ]
[2023-05-12T10:17:08+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000223s ]
[2023-05-12T10:17:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.003080s ]
[2023-05-12T10:17:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_freight` WHERE `shop_id` = 2 [ RunTime:0.000439s ]
[2023-05-12T10:17:08+08:00][sql] SELECT * FROM `ls_freight` WHERE `shop_id` = 2 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000276s ]
[2023-05-12T10:17:11+08:00][sql] CONNECT:[ UseTime:0.001211s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000747s ]
[2023-05-12T10:17:11+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000191s ]
[2023-05-12T10:17:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.003058s ]
[2023-05-12T10:17:11+08:00][sql] SELECT * FROM `ls_shop_role` WHERE `del` = 0 [ RunTime:0.000221s ]
[2023-05-12T10:17:11+08:00][sql] CONNECT:[ UseTime:0.001226s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000723s ]
[2023-05-12T10:17:11+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000184s ]
[2023-05-12T10:17:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.003208s ]
[2023-05-12T10:17:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.003089s ]
[2023-05-12T10:17:11+08:00][sql] SELECT `id`,`name` FROM `ls_shop_role` WHERE `del` = 0 [ RunTime:0.000370s ]
[2023-05-12T10:17:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_admin` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000214s ]
[2023-05-12T10:17:11+08:00][sql] SELECT * FROM `ls_shop_admin` WHERE `del` = 0 AND `shop_id` = 2 LIMIT 0,10 [ RunTime:0.000218s ]
[2023-05-12T10:17:15+08:00][sql] CONNECT:[ UseTime:0.001140s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000717s ]
[2023-05-12T10:17:15+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000195s ]
[2023-05-12T10:17:15+08:00][sql] CONNECT:[ UseTime:0.001135s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.001067s ]
[2023-05-12T10:17:15+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000205s ]
[2023-05-12T10:17:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role_auth_index` [ RunTime:0.003421s ]
[2023-05-12T10:17:15+08:00][sql] SELECT `m`.`name` AS `name`,`r`.`role_id` AS `role_id` FROM `ls_shop_role_auth_index` `r` INNER JOIN `ls_dev_shop_auth` `m` ON `r`.`menu_auth_id`=`m`.`id` WHERE `m`.`del` = 0 ORDER BY `sort` DESC [ RunTime:0.004825s ]
[2023-05-12T10:17:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_role` [ RunTime:0.003286s ]
[2023-05-12T10:17:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop_role` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000246s ]
[2023-05-12T10:17:15+08:00][sql] SELECT * FROM `ls_shop_role` WHERE `del` = 0 AND `shop_id` = 2 LIMIT 0,10 [ RunTime:0.000192s ]
[2023-05-12T10:17:24+08:00][sql] CONNECT:[ UseTime:0.001136s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000726s ]
[2023-05-12T10:17:24+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000214s ]
[2023-05-12T10:17:28+08:00][sql] CONNECT:[ UseTime:0.001412s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000776s ]
[2023-05-12T10:17:28+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000194s ]
[2023-05-12T10:17:28+08:00][sql] CONNECT:[ UseTime:0.001113s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000949s ]
[2023-05-12T10:17:28+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000280s ]
[2023-05-12T10:17:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_kefu` [ RunTime:0.008394s ]
[2023-05-12T10:17:28+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` = 2 [ RunTime:0.003186s ]
[2023-05-12T10:17:28+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` = 2 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.000348s ]
[2023-05-12T10:17:29+08:00][sql] CONNECT:[ UseTime:0.001213s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.003121s ]
[2023-05-12T10:17:29+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000214s ]
[2023-05-12T10:17:29+08:00][sql] CONNECT:[ UseTime:0.001178s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000772s ]
[2023-05-12T10:17:29+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000275s ]
[2023-05-12T10:17:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_kefu_lang` [ RunTime:0.006687s ]
[2023-05-12T10:17:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_kefu_lang` WHERE `shop_id` = 2 [ RunTime:0.000226s ]
[2023-05-12T10:17:29+08:00][sql] SELECT * FROM `ls_kefu_lang` WHERE `shop_id` = 2 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.000191s ]
[2023-05-12T10:17:33+08:00][sql] CONNECT:[ UseTime:0.001819s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000932s ]
[2023-05-12T10:17:33+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000229s ]
[2023-05-12T10:17:33+08:00][sql] CONNECT:[ UseTime:0.001151s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000737s ]
[2023-05-12T10:17:33+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000182s ]
[2023-05-12T10:17:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_printer_config` [ RunTime:0.006798s ]
[2023-05-12T10:17:33+08:00][sql] SELECT * FROM `ls_printer_config` WHERE `shop_id` = 2 AND `del` = 0 LIMIT 1 [ RunTime:0.000424s ]
[2023-05-12T10:17:33+08:00][sql] INSERT INTO `ls_printer_config` SET `name` = '易联云' , `shop_id` = 2 , `client_id` = 0 , `client_secret` = 0 , `type` = 1 , `update_time` = 1683857853 [ RunTime:0.000303s ]
[2023-05-12T10:17:33+08:00][sql] SELECT * FROM `ls_printer_config` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000239s ]
[2023-05-12T10:17:34+08:00][sql] CONNECT:[ UseTime:0.001178s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000803s ]
[2023-05-12T10:17:34+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000201s ]
[2023-05-12T10:17:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.003697s ]
[2023-05-12T10:17:34+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'printer' AND `name` = 'yly_template' AND `shop_id` = 2 LIMIT 1 [ RunTime:0.000308s ]
[2023-05-12T10:17:35+08:00][sql] CONNECT:[ UseTime:0.001178s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000751s ]
[2023-05-12T10:17:35+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000198s ]
[2023-05-12T10:17:35+08:00][sql] CONNECT:[ UseTime:0.001140s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000734s ]
[2023-05-12T10:17:35+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000194s ]
[2023-05-12T10:17:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_printer` [ RunTime:0.007147s ]
[2023-05-12T10:17:35+08:00][sql] SELECT * FROM `ls_printer` `p` WHERE `p`.`del` = 0 AND `p`.`shop_id` = 2 ORDER BY `p`.`id` DESC LIMIT 0,10 [ RunTime:0.000280s ]
[2023-05-12T10:17:37+08:00][sql] CONNECT:[ UseTime:0.001288s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000892s ]
[2023-05-12T10:17:37+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000227s ]
[2023-05-12T10:17:38+08:00][sql] CONNECT:[ UseTime:0.001114s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000953s ]
[2023-05-12T10:17:38+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000194s ]
[2023-05-12T10:17:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_live_room` [ RunTime:0.007093s ]
[2023-05-12T10:17:38+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_live_room` WHERE `del` = 0 AND `shop_id` = 2 [ RunTime:0.000251s ]
[2023-05-12T10:17:38+08:00][sql] SELECT * FROM `ls_live_room` WHERE `del` = 0 AND `shop_id` = 2 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000247s ]
[2023-05-12T10:17:41+08:00][sql] CONNECT:[ UseTime:0.001134s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000854s ]
[2023-05-12T10:17:41+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000257s ]
[2023-05-12T10:17:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_distribution_order_goods` [ RunTime:0.010365s ]
[2023-05-12T10:17:41+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_distribution_order_goods` WHERE `shop_id` = 2 AND `status` = 2 [ RunTime:0.000349s ]
[2023-05-12T10:17:41+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_distribution_order_goods` WHERE `shop_id` = 2 AND `status` = 2 AND `settlement_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000195s ]
[2023-05-12T10:17:41+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_distribution_order_goods` WHERE `shop_id` = 2 AND `status` = 1 [ RunTime:0.000165s ]
[2023-05-12T10:17:41+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_distribution_order_goods` WHERE `shop_id` = 2 AND `status` = 1 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000163s ]
[2023-05-12T10:17:41+08:00][sql] SELECT sum(dog.money) AS `total_money`,`og`.`image` AS `goods_image`,`og`.`goods_name` FROM `ls_distribution_order_goods` `dog` LEFT JOIN `ls_order_goods` `og` ON `og`.`id`=`dog`.`order_goods_id` WHERE `dog`.`shop_id` = 2 AND `dog`.`status` = 2 GROUP BY `dog`.`money`,`og`.`image`,`og`.`goods_name` ORDER BY `total_money` DESC LIMIT 10 [ RunTime:0.002952s ]
[2023-05-12T10:17:42+08:00][sql] CONNECT:[ UseTime:0.001136s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000752s ]
[2023-05-12T10:17:42+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000188s ]
[2023-05-12T10:17:42+08:00][sql] CONNECT:[ UseTime:0.001137s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000741s ]
[2023-05-12T10:17:42+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000191s ]
[2023-05-12T10:17:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_coupon` [ RunTime:0.008456s ]
[2023-05-12T10:17:42+08:00][sql] UPDATE `ls_coupon` SET `status` = 0 , `update_time` = 1683857862 WHERE `send_time_start` < 1683857862 AND `send_time_end` < 1683857862 AND `status` = 1 AND `shop_id` = 2 [ RunTime:0.000250s ]
[2023-05-12T10:17:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_coupon` WHERE `del` = 0 AND `shop_id` = 2 AND `status` = 1 [ RunTime:0.000198s ]
[2023-05-12T10:17:42+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` = 2 AND `status` = 1 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000289s ]
[2023-05-12T10:17:43+08:00][sql] CONNECT:[ UseTime:0.001156s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000765s ]
[2023-05-12T10:17:43+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000197s ]
[2023-05-12T10:17:43+08:00][sql] CONNECT:[ UseTime:0.001105s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_shop_auth` [ RunTime:0.000796s ]
[2023-05-12T10:17:43+08:00][sql] SELECT `uri` FROM `ls_dev_shop_auth` WHERE `id` IN ('') [ RunTime:0.000189s ]
[2023-05-12T10:17:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_order_invoice` [ RunTime:0.007430s ]
[2023-05-12T10:17:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_order_invoice` `i` INNER JOIN `ls_order` `o` ON `o`.`id`=`i`.`order_id` WHERE `o`.`shop_id` = 2 [ RunTime:0.002525s ]
[2023-05-12T10:17:43+08:00][sql] SELECT `i`.*,`o`.`order_sn`,`o`.`order_amount`,`order_status`,`o`.`create_time` AS `order_create_time` FROM `ls_order_invoice` `i` INNER JOIN `ls_order` `o` ON `o`.`id`=`i`.`order_id` WHERE `o`.`shop_id` = 2 ORDER BY `i`.`id` DESC LIMIT 0,10 [ RunTime:0.000320s ]