[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 ]