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

735 lines
122 KiB
Raw Permalink Blame History

[2023-05-12T10:10:34+08:00][sql] CONNECT:[ UseTime:0.008384s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:10:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.017267s ]
[2023-05-12T10:10:34+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.002073s ]
[2023-05-12T10:10:34+08:00][sql] SELECT `id`,`account`,`name`,`role_id` FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.000286s ]
[2023-05-12T10:10:34+08:00][sql] UPDATE `ls_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1683857434 WHERE `account` = 'admin' [ RunTime:0.001781s ]
[2023-05-12T10:10:36+08:00][sql] CONNECT:[ UseTime:0.017210s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:10:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.011363s ]
[2023-05-12T10:10:36+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857436 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.000513s ]
[2023-05-12T10:10:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.010414s ]
[2023-05-12T10:10:36+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.000693s ]
[2023-05-12T10:10:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.009302s ]
[2023-05-12T10:10:36+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000287s ]
[2023-05-12T10:10:36+08:00][sql] CONNECT:[ UseTime:0.001280s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:10:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003811s ]
[2023-05-12T10:10:36+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857436 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000182s ]
[2023-05-12T10:10:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.012713s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.001339s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.000194s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000189s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.000153s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.000140s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000166s ]
[2023-05-12T10:10:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.013685s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.000393s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.000138s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000102s ]
[2023-05-12T10:10:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.010596s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` GROUP BY `ip` ) `_group_count_` [ RunTime:0.000328s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000345s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000155s ]
[2023-05-12T10:10:36+08:00][sql] CONNECT:[ UseTime:0.001044s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:10:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003064s ]
[2023-05-12T10:10:36+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857436 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000146s ]
[2023-05-12T10:10:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.003509s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 AND `pay_status` > 0 [ RunTime:0.000224s ]
[2023-05-12T10:10:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.003173s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000327s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 AND `pay_status` > 0 [ RunTime:0.000143s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000200s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 AND `pay_status` > 0 [ RunTime:0.000123s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000158s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 AND `pay_status` > 0 [ RunTime:0.000112s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000144s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 AND `pay_status` > 0 [ RunTime:0.000108s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000144s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 AND `pay_status` > 0 [ RunTime:0.000107s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000139s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 AND `pay_status` > 0 [ RunTime:0.000105s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000137s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 AND `pay_status` > 0 [ RunTime:0.000105s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000139s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 AND `pay_status` > 0 [ RunTime:0.000104s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000180s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 AND `pay_status` > 0 [ RunTime:0.000107s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000145s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 AND `pay_status` > 0 [ RunTime:0.000104s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000138s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 AND `pay_status` > 0 [ RunTime:0.000103s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000134s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 AND `pay_status` > 0 [ RunTime:0.000108s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000174s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 AND `pay_status` > 0 [ RunTime:0.000106s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000183s ]
[2023-05-12T10:10:36+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 AND `pay_status` > 0 [ RunTime:0.000105s ]
[2023-05-12T10:10:36+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000139s ]
[2023-05-12T10:10:37+08:00][sql] CONNECT:[ UseTime:0.011505s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:10:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003433s ]
[2023-05-12T10:10:37+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857437 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"1\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000160s ]
[2023-05-12T10:10:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.003224s ]
[2023-05-12T10:10:37+08:00][sql] SELECT `o`.`shop_id`,sum(o.order_amount) as order_amount,`s`.`logo`,`s`.`name` FROM `ls_order` `o` INNER JOIN `ls_shop` `s` ON `s`.`id`=`o`.`shop_id` WHERE `order_amount` > 0 AND `pay_status` > 0 GROUP BY `shop_id` ORDER BY `order_amount` DESC LIMIT 5 [ RunTime:0.016480s ]
[2023-05-12T10:10:37+08:00][sql] CONNECT:[ UseTime:0.020761s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:10:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003446s ]
[2023-05-12T10:10:37+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857437 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"2\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000178s ]
[2023-05-12T10:10:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.003126s ]
[2023-05-12T10:10:37+08:00][sql] SELECT `id`,`logo`,`name`,`visited_num` FROM `ls_shop` WHERE `visited_num` > 0 ORDER BY `visited_num` DESC LIMIT 5 [ RunTime:0.000204s ]
[2023-05-12T10:10:39+08:00][sql] CONNECT:[ UseTime:0.017188s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:10:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003110s ]
[2023-05-12T10:10:39+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857439 , `uri` = '/admin/goods.Goods/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/goods_Goods\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000154s ]
[2023-05-12T10:10:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.011901s ]
[2023-05-12T10:10:39+08:00][sql] SELECT `id`,`id`,`name`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 [ RunTime:0.000206s ]
[2023-05-12T10:10:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.009862s ]
[2023-05-12T10:10:39+08:00][sql] SELECT `id`,`status`,`stock`,`stock_warn`,`audit_status`,`del` FROM `ls_goods` WHERE `del` <> 1 [ RunTime:0.000410s ]
[2023-05-12T10:10:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_column` [ RunTime:0.008879s ]
[2023-05-12T10:10:39+08:00][sql] SELECT `id`,`name` FROM `ls_goods_column` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.000201s ]
[2023-05-12T10:10:40+08:00][sql] CONNECT:[ UseTime:0.001027s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:10:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003078s ]
[2023-05-12T10:10:40+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857440 , `uri` = '/admin/goods.goods/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/goods_goods\\/lists_html\":\"\",\"type\":\"1\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000368s ]
[2023-05-12T10:10:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003499s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `g`.`id`,`g`.`image`,`g`.`spec_type`,`g`.`name`,`g`.`min_price`,`g`.`max_price`,`g`.`sales_actual`,`g`.`stock`,`g`.`sort_weight`,`g`.`create_time`,`g`.`column_ids`,`g`.`audit_status`,`g`.`audit_remark`,s.id as shop_id,s.name as shop_name,s.logo as shop_logo,s.type as shop_type FROM `ls_goods` `g` LEFT JOIN `ls_shop` `s` ON `s`.`id`=`g`.`shop_id` WHERE `g`.`status` = 1 AND `g`.`del` = 0 AND `g`.`audit_status` = 1 ORDER BY `g`.`create_time` DESC LIMIT 0,10 [ RunTime:0.002669s ]
[2023-05-12T10:10:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_goods` `g` LEFT JOIN `ls_shop` `s` ON `s`.`id`=`g`.`shop_id` WHERE `g`.`status` = 1 AND `g`.`del` = 0 AND `g`.`audit_status` = 1 [ RunTime:0.000195s ]
[2023-05-12T10:10:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_column` [ RunTime:0.003008s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000151s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000099s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000088s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000086s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000095s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000083s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000081s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000083s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000091s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000082s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000081s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000079s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000088s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000081s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000079s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000149s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000136s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000140s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000097s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000149s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000102s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000083s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000103s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000083s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000104s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000083s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000080s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000079s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000090s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000080s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000079s ]
[2023-05-12T10:10:40+08:00][sql] SELECT `name` FROM `ls_goods_column` WHERE `id` = 5 LIMIT 1 [ RunTime:0.000084s ]
[2023-05-12T10:10:43+08:00][sql] CONNECT:[ UseTime:0.001530s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:10:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003417s ]
[2023-05-12T10:10:43+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857443 , `uri` = '/admin/goods.goods/setInfo.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/goods_goods\\/setInfo_html\":\"\",\"goods_id\":\"8\"}' , `ip` = '127.0.0.1' [ RunTime:0.000188s ]
[2023-05-12T10:10:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003071s ]
[2023-05-12T10:10:43+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000276s ]
[2023-05-12T10:10:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_column` [ RunTime:0.002729s ]
[2023-05-12T10:10:43+08:00][sql] SELECT `id`,`name` FROM `ls_goods_column` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.000208s ]
[2023-05-12T10:10:48+08:00][sql] CONNECT:[ UseTime:0.001471s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:10:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003204s ]
[2023-05-12T10:10:48+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857448 , `uri` = '/admin/goods.goods/view.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/goods_goods\\/view_html\":\"\",\"goods_id\":\"8\"}' , `ip` = '127.0.0.1' [ RunTime:0.000197s ]
[2023-05-12T10:10:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.003071s ]
[2023-05-12T10:10:48+08:00][sql] SELECT `shop_id` FROM `ls_goods` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000205s ]
[2023-05-12T10:10:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_category` [ RunTime:0.002855s ]
[2023-05-12T10:10:48+08:00][sql] SELECT `name`,`id`,`pid`,`level` FROM `ls_goods_category` WHERE `del` = 0 ORDER BY `sort` DESC [ RunTime:0.000232s ]
[2023-05-12T10:10:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_goods_category` [ RunTime:0.011465s ]
[2023-05-12T10:10:48+08:00][sql] SELECT `id`,`name` FROM `ls_shop_goods_category` WHERE `del` = 0 AND `shop_id` = 2 ORDER BY `id` ASC [ RunTime:0.000264s ]
[2023-05-12T10:10:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_brand` [ RunTime:0.011174s ]
[2023-05-12T10:10:48+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_brand` WHERE `del` = 0 AND `is_show` = 1 [ RunTime:0.000255s ]
[2023-05-12T10:10:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_supplier` [ RunTime:0.010309s ]
[2023-05-12T10:10:48+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_supplier` WHERE `del` = 0 [ RunTime:0.000287s ]
[2023-05-12T10:10:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_unit` [ RunTime:0.008799s ]
[2023-05-12T10:10:48+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_goods_unit` WHERE `del` = 0 [ RunTime:0.000392s ]
[2023-05-12T10:10:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_freight` [ RunTime:0.008836s ]
[2023-05-12T10:10:48+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_freight` WHERE `shop_id` = 2 [ RunTime:0.000203s ]
[2023-05-12T10:10:48+08:00][sql] SELECT * FROM `ls_goods` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000704s ]
[2023-05-12T10:10:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_image` [ RunTime:0.008958s ]
[2023-05-12T10:10:48+08:00][sql] SELECT * FROM `ls_goods_image` WHERE `goods_id` = 8 [ RunTime:0.000225s ]
[2023-05-12T10:10:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_item` [ RunTime:0.010101s ]
[2023-05-12T10:10:48+08:00][sql] SELECT * FROM `ls_goods_item` WHERE `goods_id` = 8 [ RunTime:0.000264s ]
[2023-05-12T10:10:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec` [ RunTime:0.011066s ]
[2023-05-12T10:10:48+08:00][sql] SELECT * FROM `ls_goods_spec` WHERE `goods_id` = 8 [ RunTime:0.000242s ]
[2023-05-12T10:10:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods_spec_value` [ RunTime:0.011439s ]
[2023-05-12T10:10:48+08:00][sql] SELECT * FROM `ls_goods_spec_value` WHERE `goods_id` = 8 [ RunTime:0.000245s ]
[2023-05-12T10:11:06+08:00][sql] CONNECT:[ UseTime:0.001123s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:11:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003168s ]
[2023-05-12T10:11:06+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857466 , `uri` = '/admin/shop.Store/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000208s ]
[2023-05-12T10:11:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.011816s ]
[2023-05-12T10:11:06+08:00][sql] SELECT `id`,`name`,`image`,`sort`,`del`,`create_time`,`update_time` FROM `ls_shop_category` WHERE `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000311s ]
[2023-05-12T10:11:06+08:00][sql] CONNECT:[ UseTime:0.001146s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:11:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003119s ]
[2023-05-12T10:11:06+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857466 , `uri` = '/admin/shop.Store/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000196s ]
[2023-05-12T10:11:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.003370s ]
[2023-05-12T10:11:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop` WHERE `del` = 0 AND ( del=0 ) [ RunTime:0.000253s ]
[2023-05-12T10:11:06+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 `del` = 0 AND ( del=0 ) ORDER BY `id` DESC,`weight` ASC LIMIT 0,10 [ RunTime:0.000375s ]
[2023-05-12T10:11:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.003274s ]
[2023-05-12T10:11:06+08:00][sql] SELECT * FROM `ls_shop_category` WHERE `id` = 1 [ RunTime:0.000226s ]
[2023-05-12T10:11:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.011151s ]
[2023-05-12T10:11:06+08:00][sql] SELECT * FROM `ls_shop_admin` WHERE `shop_id` IN (2,1) [ RunTime:0.000512s ]
[2023-05-12T10:11:11+08:00][sql] CONNECT:[ UseTime:0.001154s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:11:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003040s ]
[2023-05-12T10:11:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857471 , `uri` = '/admin/login/logout.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/login\\/logout_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000203s ]
[2023-05-12T10:11:22+08:00][sql] CONNECT:[ UseTime:0.001164s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:11:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.003304s ]
[2023-05-12T10:11:22+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = '777777' AND `del` = 0 LIMIT 1 [ RunTime:0.000303s ]
[2023-05-12T10:11:26+08:00][sql] CONNECT:[ UseTime:0.001146s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:11:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.003068s ]
[2023-05-12T10:11:26+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = '777777' AND `del` = 0 LIMIT 1 [ RunTime:0.000262s ]
[2023-05-12T10:11:58+08:00][sql] CONNECT:[ UseTime:0.001295s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:11:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.003672s ]
[2023-05-12T10:11:58+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.000328s ]
[2023-05-12T10:11:58+08:00][sql] SELECT `id`,`account`,`name`,`role_id` FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.000225s ]
[2023-05-12T10:11:58+08:00][sql] UPDATE `ls_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1683857518 WHERE `account` = 'admin' [ RunTime:0.001267s ]
[2023-05-12T10:12:00+08:00][sql] CONNECT:[ UseTime:0.001117s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003084s ]
[2023-05-12T10:12:00+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857520 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.000237s ]
[2023-05-12T10:12:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.003246s ]
[2023-05-12T10:12:00+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.000626s ]
[2023-05-12T10:12:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.003350s ]
[2023-05-12T10:12:00+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000230s ]
[2023-05-12T10:12:00+08:00][sql] CONNECT:[ UseTime:0.001117s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000702s ]
[2023-05-12T10:12:00+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857520 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000196s ]
[2023-05-12T10:12:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.003222s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.000209s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.000191s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000166s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.000151s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.000162s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000154s ]
[2023-05-12T10:12:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.003376s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.000219s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.000170s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.000147s ]
[2023-05-12T10:12:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.002837s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` GROUP BY `ip` ) `_group_count_` [ RunTime:0.000338s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000326s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000254s ]
[2023-05-12T10:12:00+08:00][sql] CONNECT:[ UseTime:0.001157s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000772s ]
[2023-05-12T10:12:00+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857520 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000205s ]
[2023-05-12T10:12:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.000875s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 AND `pay_status` > 0 [ RunTime:0.000269s ]
[2023-05-12T10:12:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.000590s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000366s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 AND `pay_status` > 0 [ RunTime:0.000237s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000298s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 AND `pay_status` > 0 [ RunTime:0.000193s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000211s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 AND `pay_status` > 0 [ RunTime:0.000194s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000187s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 AND `pay_status` > 0 [ RunTime:0.000161s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000180s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 AND `pay_status` > 0 [ RunTime:0.000156s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000175s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 AND `pay_status` > 0 [ RunTime:0.000156s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000174s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 AND `pay_status` > 0 [ RunTime:0.000154s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000306s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 AND `pay_status` > 0 [ RunTime:0.000182s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000241s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 AND `pay_status` > 0 [ RunTime:0.000174s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000192s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 AND `pay_status` > 0 [ RunTime:0.000165s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000186s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 AND `pay_status` > 0 [ RunTime:0.000154s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000172s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 AND `pay_status` > 0 [ RunTime:0.000154s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000228s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 AND `pay_status` > 0 [ RunTime:0.000167s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000230s ]
[2023-05-12T10:12:00+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 AND `pay_status` > 0 [ RunTime:0.000158s ]
[2023-05-12T10:12:00+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000184s ]
[2023-05-12T10:12:01+08:00][sql] CONNECT:[ UseTime:0.019968s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000873s ]
[2023-05-12T10:12:01+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857520 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"1\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000310s ]
[2023-05-12T10:12:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.001002s ]
[2023-05-12T10:12:01+08:00][sql] SELECT `o`.`shop_id`,sum(o.order_amount) as order_amount,`s`.`logo`,`s`.`name` FROM `ls_order` `o` INNER JOIN `ls_shop` `s` ON `s`.`id`=`o`.`shop_id` WHERE `order_amount` > 0 AND `pay_status` > 0 GROUP BY `shop_id` ORDER BY `order_amount` DESC LIMIT 5 [ RunTime:0.003093s ]
[2023-05-12T10:12:02+08:00][sql] CONNECT:[ UseTime:0.001161s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:12:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000769s ]
[2023-05-12T10:12:02+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857521 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"2\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000202s ]
[2023-05-12T10:12:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.000790s ]
[2023-05-12T10:12:02+08:00][sql] SELECT `id`,`logo`,`name`,`visited_num` FROM `ls_shop` WHERE `visited_num` > 0 ORDER BY `visited_num` DESC LIMIT 5 [ RunTime:0.000305s ]
[2023-05-12T10:17:49+08:00][sql] CONNECT:[ UseTime:0.001459s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:49+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000751s ]
[2023-05-12T10:17:49+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857869 , `uri` = '/admin/setting.CustomerService/index.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/setting_CustomerService\\/index_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000227s ]
[2023-05-12T10:17:52+08:00][sql] CONNECT:[ UseTime:0.001151s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003151s ]
[2023-05-12T10:17:52+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857872 , `uri` = '/admin/shop.Store/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000218s ]
[2023-05-12T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.003371s ]
[2023-05-12T10:17:52+08:00][sql] SELECT `id`,`name`,`image`,`sort`,`del`,`create_time`,`update_time` FROM `ls_shop_category` WHERE `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000288s ]
[2023-05-12T10:17:52+08:00][sql] CONNECT:[ UseTime:0.001116s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003457s ]
[2023-05-12T10:17:52+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857872 , `uri` = '/admin/shop.Store/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000226s ]
[2023-05-12T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.000900s ]
[2023-05-12T10:17:52+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop` WHERE `del` = 0 AND ( del=0 ) [ RunTime:0.000270s ]
[2023-05-12T10:17:52+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 `del` = 0 AND ( del=0 ) ORDER BY `id` DESC,`weight` ASC LIMIT 0,10 [ RunTime:0.000406s ]
[2023-05-12T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.002910s ]
[2023-05-12T10:17:52+08:00][sql] SELECT * FROM `ls_shop_category` WHERE `id` = 1 [ RunTime:0.000197s ]
[2023-05-12T10:17:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.003346s ]
[2023-05-12T10:17:52+08:00][sql] SELECT * FROM `ls_shop_admin` WHERE `shop_id` IN (2,1) [ RunTime:0.000276s ]
[2023-05-12T10:17:59+08:00][sql] CONNECT:[ UseTime:0.001171s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:17:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003079s ]
[2023-05-12T10:17:59+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857879 , `uri` = '/admin/shop.Store/edit.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/edit_html\":\"\",\"id\":\"2\"}' , `ip` = '127.0.0.1' [ RunTime:0.000203s ]
[2023-05-12T10:17:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.003473s ]
[2023-05-12T10:17:59+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000552s ]
[2023-05-12T10:17:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.003026s ]
[2023-05-12T10:17:59+08:00][sql] SELECT `id`,`name`,`image`,`sort`,`del`,`create_time`,`update_time` FROM `ls_shop_category` WHERE `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000264s ]
[2023-05-12T10:17:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.002781s ]
[2023-05-12T10:17:59+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'map' AND `name` = 'tx_map_key' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000213s ]
[2023-05-12T10:18:22+08:00][sql] CONNECT:[ UseTime:0.001168s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:18:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000773s ]
[2023-05-12T10:18:22+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857902 , `uri` = '/admin/shop.Store/edit.html' , `type` = 'POST' , `param` = '{\"\\/admin\\/shop_Store\\/edit_html\":\"\",\"name\":\"大G数码集团\",\"type\":\"2\",\"delivery_type\":[\"1\"],\"cid\":\"1\",\"nickname\":\"天才小熊猫\",\"mobile\":\"13467913467\",\"logo\":\"http:\\/\\/loca.ahbcqz.com\\/uploads\\/images\\/20210623171320939155531.png\",\"province_id\":\"620000\",\"city_id\":\"620100\",\"district_id\":\"620102\",\"address\":\"\",\"longitude\":\"\",\"latitude\":\"\",\"keywords\":\"7777\",\"intro\":\"这是一家专注于数码领域的独角兽公司，我们的征途的星辰大海！！！\",\"expire_time\":\"2030-06-23 00:00:00\",\"trade_service_fee\":\"0\",\"is_product_audit\":\"0\",\"is_run\":\"1\",\"is_freeze\":\"0\",\"id\":\"2\"}' , `ip` = '127.0.0.1' [ RunTime:0.000252s ]
[2023-05-12T10:18:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.003813s ]
[2023-05-12T10:18:22+08:00][sql] UPDATE `ls_shop` SET `cid` = 1 , `type` = 2 , `name` = '大G数码集团' , `nickname` = '天才小熊猫' , `mobile` = '13467913467' , `logo` = 'uploads/images/20210623171320939155531.png' , `keywords` = '7777' , `intro` = '这是一家专注于数码领域的独角兽公司，我们的征途的星辰大海！！！' , `trade_service_fee` = '0' , `is_run` = 1 , `is_freeze` = 0 , `is_product_audit` = 0 , `expire_time` = 1908374400 , `province_id` = 620000 , `city_id` = 620100 , `district_id` = 620102 , `address` = '' , `longitude` = '' , `latitude` = '' , `delivery_type` = '1' , `update_time` = 1683857902 WHERE `id` = 2 [ RunTime:0.000384s ]
[2023-05-12T10:18:22+08:00][sql] CONNECT:[ UseTime:0.001195s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:18:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000705s ]
[2023-05-12T10:18:22+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857902 , `uri` = '/admin/shop.Store/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000204s ]
[2023-05-12T10:18:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.000768s ]
[2023-05-12T10:18:22+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop` WHERE `del` = 0 AND ( del=0 ) [ RunTime:0.000229s ]
[2023-05-12T10:18:22+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 `del` = 0 AND ( del=0 ) ORDER BY `id` DESC,`weight` ASC LIMIT 0,10 [ RunTime:0.000427s ]
[2023-05-12T10:18:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.000576s ]
[2023-05-12T10:18:22+08:00][sql] SELECT * FROM `ls_shop_category` WHERE `id` = 1 [ RunTime:0.000260s ]
[2023-05-12T10:18:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.003508s ]
[2023-05-12T10:18:22+08:00][sql] SELECT * FROM `ls_shop_admin` WHERE `shop_id` IN (2,1) [ RunTime:0.000300s ]
[2023-05-12T10:18:24+08:00][sql] CONNECT:[ UseTime:0.001126s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:18:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000716s ]
[2023-05-12T10:18:24+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857904 , `uri` = '/admin/shop.Store/set.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/set_html\":\"\",\"id\":\"2\"}' , `ip` = '127.0.0.1' [ RunTime:0.000204s ]
[2023-05-12T10:18:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.003651s ]
[2023-05-12T10:18:24+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000393s ]
[2023-05-12T10:18:28+08:00][sql] CONNECT:[ UseTime:0.001198s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:18:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000777s ]
[2023-05-12T10:18:28+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857908 , `uri` = '/admin/shop.Store/set.html' , `type` = 'POST' , `param` = '{\"\\/admin\\/shop_Store\\/set_html\":\"\",\"is_recommend\":\"0\",\"is_distribution\":\"0\",\"is_pay\":\"0\",\"weight\":\"0\",\"id\":\"2\"}' , `ip` = '127.0.0.1' [ RunTime:0.000254s ]
[2023-05-12T10:18:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.000790s ]
[2023-05-12T10:18:28+08:00][sql] UPDATE `ls_shop` SET `is_distribution` = 0 , `is_recommend` = 0 , `is_pay` = 0 , `weight` = 0 , `update_time` = 1683857908 WHERE `id` = 2 [ RunTime:0.000323s ]
[2023-05-12T10:18:28+08:00][sql] CONNECT:[ UseTime:0.001181s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:18:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000762s ]
[2023-05-12T10:18:28+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857908 , `uri` = '/admin/shop.Store/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000277s ]
[2023-05-12T10:18:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.000915s ]
[2023-05-12T10:18:28+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop` WHERE `del` = 0 AND ( del=0 ) [ RunTime:0.000238s ]
[2023-05-12T10:18:28+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 `del` = 0 AND ( del=0 ) ORDER BY `id` DESC,`weight` ASC LIMIT 0,10 [ RunTime:0.000398s ]
[2023-05-12T10:18:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.003176s ]
[2023-05-12T10:18:28+08:00][sql] SELECT * FROM `ls_shop_category` WHERE `id` = 1 [ RunTime:0.000226s ]
[2023-05-12T10:18:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.002865s ]
[2023-05-12T10:18:28+08:00][sql] SELECT * FROM `ls_shop_admin` WHERE `shop_id` IN (2,1) [ RunTime:0.000233s ]
[2023-05-12T10:18:32+08:00][sql] CONNECT:[ UseTime:0.001110s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:18:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000699s ]
[2023-05-12T10:18:32+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857912 , `uri` = '/admin/shop.Store/set.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/set_html\":\"\",\"id\":\"1\"}' , `ip` = '127.0.0.1' [ RunTime:0.000205s ]
[2023-05-12T10:18:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.000822s ]
[2023-05-12T10:18:32+08:00][sql] SELECT * FROM `ls_shop` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000453s ]
[2023-05-12T10:18:34+08:00][sql] CONNECT:[ UseTime:0.001321s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:18:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000743s ]
[2023-05-12T10:18:34+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857914 , `uri` = '/admin/shop.Store/set.html' , `type` = 'POST' , `param` = '{\"\\/admin\\/shop_Store\\/set_html\":\"\",\"is_recommend\":\"0\",\"is_distribution\":\"0\",\"is_pay\":\"0\",\"weight\":\"0\",\"id\":\"1\"}' , `ip` = '127.0.0.1' [ RunTime:0.000243s ]
[2023-05-12T10:18:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.003314s ]
[2023-05-12T10:18:34+08:00][sql] UPDATE `ls_shop` SET `is_distribution` = 0 , `is_recommend` = 0 , `is_pay` = 0 , `weight` = 0 , `update_time` = 1683857914 WHERE `id` = 1 [ RunTime:0.000257s ]
[2023-05-12T10:18:34+08:00][sql] CONNECT:[ UseTime:0.001139s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T10:18:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000740s ]
[2023-05-12T10:18:34+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683857914 , `uri` = '/admin/shop.Store/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000244s ]
[2023-05-12T10:18:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.000948s ]
[2023-05-12T10:18:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop` WHERE `del` = 0 AND ( del=0 ) [ RunTime:0.000290s ]
[2023-05-12T10:18:34+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 `del` = 0 AND ( del=0 ) ORDER BY `id` DESC,`weight` ASC LIMIT 0,10 [ RunTime:0.000507s ]
[2023-05-12T10:18:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.003165s ]
[2023-05-12T10:18:34+08:00][sql] SELECT * FROM `ls_shop_category` WHERE `id` = 1 [ RunTime:0.000225s ]
[2023-05-12T10:18:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.002945s ]
[2023-05-12T10:18:34+08:00][sql] SELECT * FROM `ls_shop_admin` WHERE `shop_id` IN (2,1) [ RunTime:0.000227s ]
[2023-05-12T19:34:31+08:00][sql] CONNECT:[ UseTime:0.086995s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.060022s ]
[2023-05-12T19:34:31+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891271 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.057830s ]
[2023-05-12T19:34:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.060398s ]
[2023-05-12T19:34:31+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.060560s ]
[2023-05-12T19:34:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.060425s ]
[2023-05-12T19:34:31+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.057628s ]
[2023-05-12T19:34:32+08:00][sql] CONNECT:[ UseTime:0.057999s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.041190s ]
[2023-05-12T19:34:32+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891271 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.039049s ]
[2023-05-12T19:34:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.040969s ]
[2023-05-12T19:34:32+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.038337s ]
[2023-05-12T19:34:32+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.038686s ]
[2023-05-12T19:34:32+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.038446s ]
[2023-05-12T19:34:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.038277s ]
[2023-05-12T19:34:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.038233s ]
[2023-05-12T19:34:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.038371s ]
[2023-05-12T19:34:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.040873s ]
[2023-05-12T19:34:32+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.038209s ]
[2023-05-12T19:34:32+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.038293s ]
[2023-05-12T19:34:32+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.038471s ]
[2023-05-12T19:34:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.040672s ]
[2023-05-12T19:34:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` GROUP BY `ip` ) `_group_count_` [ RunTime:0.038297s ]
[2023-05-12T19:34:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038259s ]
[2023-05-12T19:34:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038263s ]
[2023-05-12T19:34:33+08:00][sql] CONNECT:[ UseTime:0.052143s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.036682s ]
[2023-05-12T19:34:33+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891272 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"1\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.083975s ]
[2023-05-12T19:34:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.037167s ]
[2023-05-12T19:34:33+08:00][sql] SELECT `o`.`shop_id`,sum(o.order_amount) as order_amount,`s`.`logo`,`s`.`name` FROM `ls_order` `o` INNER JOIN `ls_shop` `s` ON `s`.`id`=`o`.`shop_id` WHERE `order_amount` > 0 AND `pay_status` > 0 GROUP BY `shop_id` ORDER BY `order_amount` DESC LIMIT 5 [ RunTime:0.034715s ]
[2023-05-12T19:34:33+08:00][sql] CONNECT:[ UseTime:0.077357s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.053630s ]
[2023-05-12T19:34:33+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891272 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"2\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.051803s ]
[2023-05-12T19:34:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.053542s ]
[2023-05-12T19:34:33+08:00][sql] SELECT `id`,`logo`,`name`,`visited_num` FROM `ls_shop` WHERE `visited_num` > 0 ORDER BY `visited_num` DESC LIMIT 5 [ RunTime:0.051506s ]
[2023-05-12T19:34:34+08:00][sql] CONNECT:[ UseTime:0.071005s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.049598s ]
[2023-05-12T19:34:34+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891273 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.047460s ]
[2023-05-12T19:34:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.050669s ]
[2023-05-12T19:34:34+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.049046s ]
[2023-05-12T19:34:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.049256s ]
[2023-05-12T19:34:34+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.047334s ]
[2023-05-12T19:34:34+08:00][sql] CONNECT:[ UseTime:0.079591s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.055229s ]
[2023-05-12T19:34:34+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891272 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.077290s ]
[2023-05-12T19:34:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.072096s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 AND `pay_status` > 0 [ RunTime:0.052907s ]
[2023-05-12T19:34:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.055124s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.053140s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 AND `pay_status` > 0 [ RunTime:0.053036s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.053171s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 AND `pay_status` > 0 [ RunTime:0.052841s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052908s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 AND `pay_status` > 0 [ RunTime:0.052870s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.053040s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 AND `pay_status` > 0 [ RunTime:0.053029s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.053115s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 AND `pay_status` > 0 [ RunTime:0.052817s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052764s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 AND `pay_status` > 0 [ RunTime:0.052628s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052684s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 AND `pay_status` > 0 [ RunTime:0.052658s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052829s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 AND `pay_status` > 0 [ RunTime:0.052642s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052947s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 AND `pay_status` > 0 [ RunTime:0.052839s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.053801s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 AND `pay_status` > 0 [ RunTime:0.052710s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.053013s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 AND `pay_status` > 0 [ RunTime:0.052782s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052828s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 AND `pay_status` > 0 [ RunTime:0.052836s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052579s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 AND `pay_status` > 0 [ RunTime:0.052809s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052658s ]
[2023-05-12T19:34:34+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 AND `pay_status` > 0 [ RunTime:0.053183s ]
[2023-05-12T19:34:34+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052827s ]
[2023-05-12T19:34:35+08:00][sql] CONNECT:[ UseTime:0.053365s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.044479s ]
[2023-05-12T19:34:35+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891274 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.035340s ]
[2023-05-12T19:34:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.037597s ]
[2023-05-12T19:34:35+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.034996s ]
[2023-05-12T19:34:35+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.034993s ]
[2023-05-12T19:34:35+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.035145s ]
[2023-05-12T19:34:35+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.035157s ]
[2023-05-12T19:34:35+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.035324s ]
[2023-05-12T19:34:35+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.035108s ]
[2023-05-12T19:34:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.037963s ]
[2023-05-12T19:34:35+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.035236s ]
[2023-05-12T19:34:35+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.035194s ]
[2023-05-12T19:34:35+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.035213s ]
[2023-05-12T19:34:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.037117s ]
[2023-05-12T19:34:35+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` GROUP BY `ip` ) `_group_count_` [ RunTime:0.035159s ]
[2023-05-12T19:34:35+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.035276s ]
[2023-05-12T19:34:35+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.035294s ]
[2023-05-12T19:34:35+08:00][sql] CONNECT:[ UseTime:0.051984s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.036948s ]
[2023-05-12T19:34:35+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891275 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"1\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.034606s ]
[2023-05-12T19:34:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.036777s ]
[2023-05-12T19:34:35+08:00][sql] SELECT `o`.`shop_id`,sum(o.order_amount) as order_amount,`s`.`logo`,`s`.`name` FROM `ls_order` `o` INNER JOIN `ls_shop` `s` ON `s`.`id`=`o`.`shop_id` WHERE `order_amount` > 0 AND `pay_status` > 0 GROUP BY `shop_id` ORDER BY `order_amount` DESC LIMIT 5 [ RunTime:0.035230s ]
[2023-05-12T19:34:35+08:00][sql] CONNECT:[ UseTime:0.053247s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.037291s ]
[2023-05-12T19:34:35+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891275 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"2\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.035427s ]
[2023-05-12T19:34:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.037314s ]
[2023-05-12T19:34:35+08:00][sql] SELECT `id`,`logo`,`name`,`visited_num` FROM `ls_shop` WHERE `visited_num` > 0 ORDER BY `visited_num` DESC LIMIT 5 [ RunTime:0.035441s ]
[2023-05-12T19:34:37+08:00][sql] CONNECT:[ UseTime:0.049657s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.035662s ]
[2023-05-12T19:34:37+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891276 , `uri` = '/admin/order.Order/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/order_Order\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.033241s ]
[2023-05-12T19:34:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.035142s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT `o`.*,s.name as shop_name,`u`.`level`,count(*) AS think_count FROM `ls_order` `o` INNER JOIN `ls_shop` `s` ON `s`.`id`=`o`.`shop_id` INNER JOIN `ls_user` `u` ON `u`.`id`=`o`.`user_id` INNER JOIN `ls_order_goods` `g` ON `g`.`order_id`=`o`.`id` GROUP BY `o`.`id` ) `_group_count_` [ RunTime:0.034814s ]
[2023-05-12T19:34:37+08:00][sql] SELECT `o`.*,s.name as shop_name,`u`.`level` FROM `ls_order` `o` INNER JOIN `ls_shop` `s` ON `s`.`id`=`o`.`shop_id` INNER JOIN `ls_user` `u` ON `u`.`id`=`o`.`user_id` INNER JOIN `ls_order_goods` `g` ON `g`.`order_id`=`o`.`id` GROUP BY `o`.`id` ORDER BY `o`.`id` DESC LIMIT 0,10 [ RunTime:0.034925s ]
[2023-05-12T19:34:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_order_goods` [ RunTime:0.035116s ]
[2023-05-12T19:34:37+08:00][sql] SELECT `id`,`order_id`,`goods_id`,`item_id`,`goods_name`,`goods_price`,`spec_value`,`image`,`goods_num`,`is_comment`,`refund_status`,`commission_ratio`,`total_pay_price` FROM `ls_order_goods` WHERE `order_id` IN (4,3,2,1) [ RunTime:0.033922s ]
[2023-05-12T19:34:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.034922s ]
[2023-05-12T19:34:37+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar`,`level`,`mobile`,`sex`,`create_time` FROM `ls_user` WHERE `id` IN (2,1) [ RunTime:0.033381s ]
[2023-05-12T19:34:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.035782s ]
[2023-05-12T19:34:37+08:00][sql] SELECT `id`,`name`,`type`,`logo`,`mobile`,`open_invoice`,`spec_invoice` FROM `ls_shop` WHERE `id` = 2 [ RunTime:0.033654s ]
[2023-05-12T19:34:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.035152s ]
[2023-05-12T19:34:37+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 [ RunTime:0.032816s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `order_status` = 0 [ RunTime:0.032839s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `order_status` = 1 [ RunTime:0.032774s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `order_status` = 2 [ RunTime:0.032868s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `order_status` = 3 [ RunTime:0.032883s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `order_status` = 4 [ RunTime:0.032920s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` [ RunTime:0.032875s ]
[2023-05-12T19:34:37+08:00][sql] CONNECT:[ UseTime:0.071720s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.046036s ]
[2023-05-12T19:34:37+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891275 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.044802s ]
[2023-05-12T19:34:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.051317s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 AND `pay_status` > 0 [ RunTime:0.044373s ]
[2023-05-12T19:34:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.046182s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044399s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 AND `pay_status` > 0 [ RunTime:0.044471s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044603s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 AND `pay_status` > 0 [ RunTime:0.044438s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044648s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 AND `pay_status` > 0 [ RunTime:0.044597s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044385s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 AND `pay_status` > 0 [ RunTime:0.044335s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044330s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 AND `pay_status` > 0 [ RunTime:0.044055s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044280s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 AND `pay_status` > 0 [ RunTime:0.044403s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044253s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 AND `pay_status` > 0 [ RunTime:0.044070s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044057s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 AND `pay_status` > 0 [ RunTime:0.044112s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044217s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 AND `pay_status` > 0 [ RunTime:0.044182s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044228s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 AND `pay_status` > 0 [ RunTime:0.044385s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044406s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 AND `pay_status` > 0 [ RunTime:0.044175s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044202s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 AND `pay_status` > 0 [ RunTime:0.044221s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044298s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 AND `pay_status` > 0 [ RunTime:0.044488s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044244s ]
[2023-05-12T19:34:37+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 AND `pay_status` > 0 [ RunTime:0.044113s ]
[2023-05-12T19:34:37+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044135s ]
[2023-05-12T19:34:38+08:00][sql] CONNECT:[ UseTime:0.078543s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.054773s ]
[2023-05-12T19:34:38+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891277 , `uri` = '/admin/order.order/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/order_order\\/lists_html\":\"\",\"type\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.052204s ]
[2023-05-12T19:34:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.098261s ]
[2023-05-12T19:34:38+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT `o`.*,s.name as shop_name,`u`.`level`,count(*) AS think_count FROM `ls_order` `o` INNER JOIN `ls_shop` `s` ON `s`.`id`=`o`.`shop_id` INNER JOIN `ls_user` `u` ON `u`.`id`=`o`.`user_id` INNER JOIN `ls_order_goods` `g` ON `g`.`order_id`=`o`.`id` GROUP BY `o`.`id` ) `_group_count_` [ RunTime:0.054280s ]
[2023-05-12T19:34:38+08:00][sql] SELECT `o`.*,s.name as shop_name,`u`.`level` FROM `ls_order` `o` INNER JOIN `ls_shop` `s` ON `s`.`id`=`o`.`shop_id` INNER JOIN `ls_user` `u` ON `u`.`id`=`o`.`user_id` INNER JOIN `ls_order_goods` `g` ON `g`.`order_id`=`o`.`id` GROUP BY `o`.`id` ORDER BY `o`.`id` DESC LIMIT 0,10 [ RunTime:0.054048s ]
[2023-05-12T19:34:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_order_goods` [ RunTime:0.054079s ]
[2023-05-12T19:34:38+08:00][sql] SELECT `id`,`order_id`,`goods_id`,`item_id`,`goods_name`,`goods_price`,`spec_value`,`image`,`goods_num`,`is_comment`,`refund_status`,`commission_ratio`,`total_pay_price` FROM `ls_order_goods` WHERE `order_id` IN (4,3,2,1) [ RunTime:0.052638s ]
[2023-05-12T19:34:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.054218s ]
[2023-05-12T19:34:38+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar`,`level`,`mobile`,`sex`,`create_time` FROM `ls_user` WHERE `id` IN (2,1) [ RunTime:0.052560s ]
[2023-05-12T19:34:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.054237s ]
[2023-05-12T19:34:38+08:00][sql] SELECT `id`,`name`,`type`,`logo`,`mobile`,`open_invoice`,`spec_invoice` FROM `ls_shop` WHERE `id` = 2 [ RunTime:0.052239s ]
[2023-05-12T19:34:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.054067s ]
[2023-05-12T19:34:38+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 [ RunTime:0.051879s ]
[2023-05-12T19:34:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_region` [ RunTime:0.054294s ]
[2023-05-12T19:34:38+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.052042s ]
[2023-05-12T19:34:38+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.052055s ]
[2023-05-12T19:34:38+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.052348s ]
[2023-05-12T19:34:38+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.052666s ]
[2023-05-12T19:34:39+08:00][sql] CONNECT:[ UseTime:0.064995s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.045389s ]
[2023-05-12T19:34:39+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891279 , `uri` = '/admin/user.User/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_User\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.042974s ]
[2023-05-12T19:34:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.045708s ]
[2023-05-12T19:34:39+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 ORDER BY `growth_value` ASC [ RunTime:0.043353s ]
[2023-05-12T19:34:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_tag` [ RunTime:0.045101s ]
[2023-05-12T19:34:39+08:00][sql] SELECT `id`,`name` FROM `ls_user_tag` WHERE `del` = 0 ORDER BY `id` DESC [ RunTime:0.043187s ]
[2023-05-12T19:34:40+08:00][sql] CONNECT:[ UseTime:0.064284s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.045330s ]
[2023-05-12T19:34:40+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891279 , `uri` = '/admin/user.user/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_user\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.042804s ]
[2023-05-12T19:34:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.044952s ]
[2023-05-12T19:34:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE `del` = 0 [ RunTime:0.042594s ]
[2023-05-12T19:34:40+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar`,`level`,`total_order_amount`,`tag_ids`,`client`,`login_time`,`create_time`,`user_growth`,`user_money`,`earnings`,`first_leader`,`disable` FROM `ls_user` WHERE `del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.043420s ]
[2023-05-12T19:34:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.044676s ]
[2023-05-12T19:34:40+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 [ RunTime:0.043352s ]
[2023-05-12T19:34:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_tag` [ RunTime:0.044953s ]
[2023-05-12T19:34:40+08:00][sql] SELECT `id`,`name` FROM `ls_user_tag` WHERE `del` = 0 [ RunTime:0.042984s ]
[2023-05-12T19:34:40+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.042964s ]
[2023-05-12T19:34:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE ( `first_leader` = 2 OR `second_leader` = 2 ) AND `del` = 0 [ RunTime:0.042912s ]
[2023-05-12T19:34:40+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.043041s ]
[2023-05-12T19:34:40+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE ( `first_leader` = 1 OR `second_leader` = 1 ) AND `del` = 0 [ RunTime:0.043187s ]
[2023-05-12T19:34:50+08:00][sql] CONNECT:[ UseTime:0.068747s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:34:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.048066s ]
[2023-05-12T19:34:50+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891290 , `uri` = '/admin/user.user/edit.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_user\\/edit_html\":\"\",\"id\":\"2\"}' , `ip` = '127.0.0.1' [ RunTime:0.045702s ]
[2023-05-12T19:34:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.047605s ]
[2023-05-12T19:34:50+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar`,`mobile`,`sex`,`birthday`,`tag_ids`,`remark`,`user_money`,`user_growth`,`user_integral`,`earnings`,`disable` FROM `ls_user` WHERE `del` = 0 AND `id` = 2 LIMIT 1 [ RunTime:0.045840s ]
[2023-05-12T19:34:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_tag` [ RunTime:0.047117s ]
[2023-05-12T19:34:50+08:00][sql] SELECT `id`,`name` FROM `ls_user_tag` WHERE `del` = 0 ORDER BY `id` DESC [ RunTime:0.045705s ]
[2023-05-12T19:35:04+08:00][sql] CONNECT:[ UseTime:0.060404s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:35:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.042680s ]
[2023-05-12T19:35:04+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891303 , `uri` = '/admin/user.user/adjustAccount.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_user\\/adjustAccount_html\":\"\",\"id\":\"2\"}' , `ip` = '127.0.0.1' [ RunTime:0.040015s ]
[2023-05-12T19:35:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.042553s ]
[2023-05-12T19:35:04+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar`,`mobile`,`sex`,`birthday`,`tag_ids`,`remark`,`user_money`,`user_growth`,`user_integral`,`earnings`,`disable` FROM `ls_user` WHERE `del` = 0 AND `id` = 2 LIMIT 1 [ RunTime:0.040510s ]
[2023-05-12T19:35:11+08:00][sql] CONNECT:[ UseTime:0.044291s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:35:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.031615s ]
[2023-05-12T19:35:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891311 , `uri` = '/admin/user.user/adjustAccount.html' , `type` = 'POST' , `param` = '{\"\\/admin\\/user_user\\/adjustAccount_html\":\"\",\"id\":\"2\",\"type\":\"money\",\"money_handle\":\"1\",\"money\":\"1000\",\"money_remark\":\"\",\"growth\":\"\",\"growth_remark\":\"\",\"now_integral\":\"0\",\"integral\":\"\",\"integral_remark\":\"\",\"earnings\":\"\",\"earnings_remark\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.029153s ]
[2023-05-12T19:35:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.031573s ]
[2023-05-12T19:35:11+08:00][sql] SELECT * FROM `ls_user` WHERE `del` = 0 AND `id` = 2 LIMIT 1 [ RunTime:0.029889s ]
[2023-05-12T19:35:14+08:00][sql] CONNECT:[ UseTime:0.050189s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:35:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.035407s ]
[2023-05-12T19:35:14+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891313 , `uri` = '/admin/user.user/adjustAccount.html' , `type` = 'POST' , `param` = '{\"\\/admin\\/user_user\\/adjustAccount_html\":\"\",\"id\":\"2\",\"type\":\"money\",\"money_handle\":\"1\",\"money\":\"1000\",\"money_remark\":\"1111\",\"growth\":\"\",\"growth_remark\":\"\",\"now_integral\":\"0\",\"integral\":\"\",\"integral_remark\":\"\",\"earnings\":\"\",\"earnings_remark\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.033242s ]
[2023-05-12T19:35:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.035475s ]
[2023-05-12T19:35:14+08:00][sql] SELECT * FROM `ls_user` WHERE `del` = 0 AND `id` = 2 LIMIT 1 [ RunTime:0.034017s ]
[2023-05-12T19:35:14+08:00][sql] SELECT * FROM `ls_user` WHERE `id` = 2 LIMIT 1 [ RunTime:0.034245s ]
[2023-05-12T19:35:14+08:00][sql] UPDATE `ls_user` SET `user_money` = 1000750.96 , `update_time` = 1683891314 WHERE `id` = 2 [ RunTime:0.033332s ]
[2023-05-12T19:35:14+08:00][sql] SELECT * FROM `ls_user` WHERE `id` = 2 LIMIT 1 [ RunTime:0.034228s ]
[2023-05-12T19:35:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_account_log` [ RunTime:0.035598s ]
[2023-05-12T19:35:14+08:00][sql] SELECT * FROM `ls_account_log` WHERE `log_sn` = '202305121935147546' LIMIT 1 [ RunTime:0.034297s ]
[2023-05-12T19:35:14+08:00][sql] INSERT INTO `ls_account_log` SET `log_sn` = '202305121935147546' , `user_id` = 2 , `source_type` = 100 , `source_id` = 0 , `source_sn` = '' , `change_amount` = '1000' , `left_amount` = '1000750.96' , `remark` = '1111' , `extra` = '' , `change_type` = 1 , `create_time` = 1683891314 [ RunTime:0.033460s ]
[2023-05-12T19:35:15+08:00][sql] CONNECT:[ UseTime:0.072754s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T19:35:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.049904s ]
[2023-05-12T19:35:15+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683891314 , `uri` = '/admin/user.user/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_user\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.047611s ]
[2023-05-12T19:35:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.049714s ]
[2023-05-12T19:35:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE `del` = 0 [ RunTime:0.047270s ]
[2023-05-12T19:35:15+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar`,`level`,`total_order_amount`,`tag_ids`,`client`,`login_time`,`create_time`,`user_growth`,`user_money`,`earnings`,`first_leader`,`disable` FROM `ls_user` WHERE `del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.048117s ]
[2023-05-12T19:35:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.049678s ]
[2023-05-12T19:35:15+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 [ RunTime:0.047472s ]
[2023-05-12T19:35:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_tag` [ RunTime:0.049596s ]
[2023-05-12T19:35:15+08:00][sql] SELECT `id`,`name` FROM `ls_user_tag` WHERE `del` = 0 [ RunTime:0.047987s ]
[2023-05-12T19:35:15+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.048394s ]
[2023-05-12T19:35:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE ( `first_leader` = 2 OR `second_leader` = 2 ) AND `del` = 0 [ RunTime:0.047272s ]
[2023-05-12T19:35:15+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.047364s ]
[2023-05-12T19:35:15+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE ( `first_leader` = 1 OR `second_leader` = 1 ) AND `del` = 0 [ RunTime:0.047549s ]
[2023-05-12T21:04:10+08:00][sql] CONNECT:[ UseTime:0.050726s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.035505s ]
[2023-05-12T21:04:10+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683896650 , `uri` = '/admin/login/logout.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/login\\/logout_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.033425s ]
[2023-05-12T21:04:19+08:00][sql] CONNECT:[ UseTime:0.044601s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:19+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.032211s ]
[2023-05-12T21:04:19+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.030015s ]
[2023-05-12T21:04:19+08:00][sql] SELECT `id`,`account`,`name`,`role_id` FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.029487s ]
[2023-05-12T21:04:19+08:00][sql] UPDATE `ls_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1683896659 WHERE `account` = 'admin' [ RunTime:0.031701s ]
[2023-05-12T21:04:21+08:00][sql] CONNECT:[ UseTime:0.067824s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:21+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.047040s ]
[2023-05-12T21:04:21+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683896661 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.044855s ]
[2023-05-12T21:04:21+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.046976s ]
[2023-05-12T21:04:21+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.046780s ]
[2023-05-12T21:04:21+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.046984s ]
[2023-05-12T21:04:21+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.044762s ]
[2023-05-12T21:04:22+08:00][sql] CONNECT:[ UseTime:0.048699s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.034421s ]
[2023-05-12T21:04:22+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683896661 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.033508s ]
[2023-05-12T21:04:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.034747s ]
[2023-05-12T21:04:22+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.032013s ]
[2023-05-12T21:04:22+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.032088s ]
[2023-05-12T21:04:22+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.032120s ]
[2023-05-12T21:04:22+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.032295s ]
[2023-05-12T21:04:22+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.032294s ]
[2023-05-12T21:04:22+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.032209s ]
[2023-05-12T21:04:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.034839s ]
[2023-05-12T21:04:22+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.032313s ]
[2023-05-12T21:04:22+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.032334s ]
[2023-05-12T21:04:22+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.032074s ]
[2023-05-12T21:04:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.034908s ]
[2023-05-12T21:04:22+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` GROUP BY `ip` ) `_group_count_` [ RunTime:0.032122s ]
[2023-05-12T21:04:22+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.032087s ]
[2023-05-12T21:04:22+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.032121s ]
[2023-05-12T21:04:22+08:00][sql] CONNECT:[ UseTime:0.059199s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.040972s ]
[2023-05-12T21:04:22+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683896662 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"1\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.039764s ]
[2023-05-12T21:04:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.042072s ]
[2023-05-12T21:04:22+08:00][sql] SELECT `o`.`shop_id`,sum(o.order_amount) as order_amount,`s`.`logo`,`s`.`name` FROM `ls_order` `o` INNER JOIN `ls_shop` `s` ON `s`.`id`=`o`.`shop_id` WHERE `order_amount` > 0 AND `pay_status` > 0 GROUP BY `shop_id` ORDER BY `order_amount` DESC LIMIT 5 [ RunTime:0.039683s ]
[2023-05-12T21:04:22+08:00][sql] CONNECT:[ UseTime:0.069715s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.048246s ]
[2023-05-12T21:04:22+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683896662 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"2\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.046177s ]
[2023-05-12T21:04:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.048724s ]
[2023-05-12T21:04:22+08:00][sql] SELECT `id`,`logo`,`name`,`visited_num` FROM `ls_shop` WHERE `visited_num` > 0 ORDER BY `visited_num` DESC LIMIT 5 [ RunTime:0.046460s ]
[2023-05-12T21:04:24+08:00][sql] CONNECT:[ UseTime:0.076450s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.052689s ]
[2023-05-12T21:04:24+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683896662 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.050454s ]
[2023-05-12T21:04:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.052520s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 AND `pay_status` > 0 [ RunTime:0.050313s ]
[2023-05-12T21:04:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.052597s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050701s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 AND `pay_status` > 0 [ RunTime:0.050482s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050561s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 AND `pay_status` > 0 [ RunTime:0.050513s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050461s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 AND `pay_status` > 0 [ RunTime:0.050334s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050579s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 AND `pay_status` > 0 [ RunTime:0.050454s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050946s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 AND `pay_status` > 0 [ RunTime:0.050754s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050577s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 AND `pay_status` > 0 [ RunTime:0.050802s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050991s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 AND `pay_status` > 0 [ RunTime:0.050734s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050662s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 AND `pay_status` > 0 [ RunTime:0.050687s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050500s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 AND `pay_status` > 0 [ RunTime:0.050374s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050641s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 AND `pay_status` > 0 [ RunTime:0.050734s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050753s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 AND `pay_status` > 0 [ RunTime:0.050742s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050780s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 AND `pay_status` > 0 [ RunTime:0.050712s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050753s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 AND `pay_status` > 0 [ RunTime:0.050748s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050665s ]
[2023-05-12T21:04:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 AND `pay_status` > 0 [ RunTime:0.050983s ]
[2023-05-12T21:04:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050781s ]
[2023-05-12T21:04:33+08:00][sql] CONNECT:[ UseTime:0.091728s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.063470s ]
[2023-05-12T21:04:33+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683896673 , `uri` = '/admin/login/logout.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/login\\/logout_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.061046s ]
[2023-05-12T21:04:38+08:00][sql] CONNECT:[ UseTime:0.071630s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:38+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.050027s ]
[2023-05-12T21:04:38+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.048270s ]
[2023-05-12T21:04:38+08:00][sql] SELECT `id`,`account`,`name`,`role_id` FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.047593s ]
[2023-05-12T21:04:38+08:00][sql] UPDATE `ls_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1683896678 WHERE `account` = 'admin' [ RunTime:0.049598s ]
[2023-05-12T21:04:40+08:00][sql] CONNECT:[ UseTime:0.043659s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.030886s ]
[2023-05-12T21:04:40+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683896679 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.028615s ]
[2023-05-12T21:04:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.031104s ]
[2023-05-12T21:04:40+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.030478s ]
[2023-05-12T21:04:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.031210s ]
[2023-05-12T21:04:40+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.028661s ]
[2023-05-12T21:04:41+08:00][sql] CONNECT:[ UseTime:0.067925s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.047575s ]
[2023-05-12T21:04:41+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683896680 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.045224s ]
[2023-05-12T21:04:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.048034s ]
[2023-05-12T21:04:41+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.044973s ]
[2023-05-12T21:04:41+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.045067s ]
[2023-05-12T21:04:41+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.045139s ]
[2023-05-12T21:04:41+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.045212s ]
[2023-05-12T21:04:41+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.044950s ]
[2023-05-12T21:04:41+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.045146s ]
[2023-05-12T21:04:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.047708s ]
[2023-05-12T21:04:41+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.044741s ]
[2023-05-12T21:04:41+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 [ RunTime:0.045126s ]
[2023-05-12T21:04:41+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 [ RunTime:0.044930s ]
[2023-05-12T21:04:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.047253s ]
[2023-05-12T21:04:41+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` GROUP BY `ip` ) `_group_count_` [ RunTime:0.045371s ]
[2023-05-12T21:04:41+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045065s ]
[2023-05-12T21:04:41+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045008s ]
[2023-05-12T21:04:41+08:00][sql] CONNECT:[ UseTime:0.057292s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.038000s ]
[2023-05-12T21:04:41+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683896681 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"2\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.035761s ]
[2023-05-12T21:04:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.038145s ]
[2023-05-12T21:04:41+08:00][sql] SELECT `id`,`logo`,`name`,`visited_num` FROM `ls_shop` WHERE `visited_num` > 0 ORDER BY `visited_num` DESC LIMIT 5 [ RunTime:0.036038s ]
[2023-05-12T21:04:41+08:00][sql] CONNECT:[ UseTime:0.086664s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.059127s ]
[2023-05-12T21:04:41+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683896681 , `uri` = '/admin/index/shop.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/shop_html\":\"\",\"type\":\"1\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.057347s ]
[2023-05-12T21:04:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.059544s ]
[2023-05-12T21:04:41+08:00][sql] SELECT `o`.`shop_id`,sum(o.order_amount) as order_amount,`s`.`logo`,`s`.`name` FROM `ls_order` `o` INNER JOIN `ls_shop` `s` ON `s`.`id`=`o`.`shop_id` WHERE `order_amount` > 0 AND `pay_status` > 0 GROUP BY `shop_id` ORDER BY `order_amount` DESC LIMIT 5 [ RunTime:0.057558s ]
[2023-05-12T21:04:42+08:00][sql] CONNECT:[ UseTime:0.047886s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-12T21:04:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.034063s ]
[2023-05-12T21:04:42+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683896681 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.031686s ]
[2023-05-12T21:04:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.033821s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 AND `pay_status` > 0 [ RunTime:0.031607s ]
[2023-05-12T21:04:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.033256s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031810s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 AND `pay_status` > 0 [ RunTime:0.031821s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031599s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 AND `pay_status` > 0 [ RunTime:0.031519s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031504s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 AND `pay_status` > 0 [ RunTime:0.031535s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031654s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 AND `pay_status` > 0 [ RunTime:0.031451s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031725s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 AND `pay_status` > 0 [ RunTime:0.031651s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.032256s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 AND `pay_status` > 0 [ RunTime:0.031735s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031842s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 AND `pay_status` > 0 [ RunTime:0.031811s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031831s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 AND `pay_status` > 0 [ RunTime:0.031715s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031783s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 AND `pay_status` > 0 [ RunTime:0.031767s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683302400 AND 1683388799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031658s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 AND `pay_status` > 0 [ RunTime:0.031981s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683388800 AND 1683475199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031742s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 AND `pay_status` > 0 [ RunTime:0.031592s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683475200 AND 1683561599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031726s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 AND `pay_status` > 0 [ RunTime:0.031598s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031883s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 AND `pay_status` > 0 [ RunTime:0.031692s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031696s ]
[2023-05-12T21:04:42+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 AND `pay_status` > 0 [ RunTime:0.031678s ]
[2023-05-12T21:04:42+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683734400 AND 1683820799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.031759s ]