[2023-05-10T14:55:25+08:00][sql] CONNECT:[ UseTime:0.024107s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-10T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.006469s ] [2023-05-10T14:55:25+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.000352s ] [2023-05-10T14:55:25+08:00][sql] SELECT `id`,`account`,`name`,`role_id` FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.000169s ] [2023-05-10T14:55:25+08:00][sql] UPDATE `ls_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1683701725 WHERE `account` = 'admin' [ RunTime:0.000566s ] [2023-05-10T14:55:25+08:00][sql] CONNECT:[ UseTime:0.011929s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-10T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.007018s ] [2023-05-10T14:55:25+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683701725 , `uri` = '/admin/index/index.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/index_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000175s ] [2023-05-10T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.006349s ] [2023-05-10T14:55:25+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.000446s ] [2023-05-10T14:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.005473s ] [2023-05-10T14:55:25+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000166s ] [2023-05-10T14:55:26+08:00][sql] CONNECT:[ UseTime:0.013347s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-10T14:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002405s ] [2023-05-10T14:55:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683701726 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.000153s ] [2023-05-10T14:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.001475s ] [2023-05-10T14:55:26+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.000383s ] [2023-05-10T14:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.001344s ] [2023-05-10T14:55:26+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000127s ] [2023-05-10T14:55:26+08:00][sql] CONNECT:[ UseTime:0.019950s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-10T14:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.001500s ] [2023-05-10T14:55:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683701726 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000105s ] [2023-05-10T14:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.000475s ] [2023-05-10T14:55:26+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.000108s ] [2023-05-10T14:55:26+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683561600 AND 1683647999 [ RunTime:0.000133s ] [2023-05-10T14:55:26+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683648000 AND 1683734399 [ RunTime:0.000069s ] [2023-05-10T14:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.000105s ] [2023-05-10T14:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683561600 AND 1683647999 [ RunTime:0.000113s ] [2023-05-10T14:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683648000 AND 1683734399 [ RunTime:0.000060s ] [2023-05-10T14:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.000380s ] [2023-05-10T14:55:26+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.000068s ] [2023-05-10T14:55:26+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683561600 AND 1683647999 [ RunTime:0.000061s ] [2023-05-10T14:55:26+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683648000 AND 1683734399 [ RunTime:0.000050s ] [2023-05-10T14:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.001447s ] [2023-05-10T14:55:26+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.000208s ] [2023-05-10T14:55:26+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.000130s ] [2023-05-10T14:55:26+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.000104s ] [2023-05-10T14:55:28+08:00][sql] CONNECT:[ UseTime:0.014127s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-10T14:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002620s ] [2023-05-10T14:55:28+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683701727 , `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.000173s ] [2023-05-10T14:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.001844s ] [2023-05-10T14:55:28+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.000156s ] [2023-05-10T14:55:28+08:00][sql] CONNECT:[ UseTime:0.016754s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-10T14:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002841s ] [2023-05-10T14:55:28+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683701727 , `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.000135s ] [2023-05-10T14:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.000515s ] [2023-05-10T14:55:28+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.001396s ] [2023-05-10T14:55:28+08:00][sql] CONNECT:[ UseTime:0.017442s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-10T14:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002651s ] [2023-05-10T14:55:28+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683701727 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000199s ] [2023-05-10T14:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.000494s ] [2023-05-10T14:55:28+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682352000 AND 1682438399 AND `pay_status` > 0 [ RunTime:0.000156s ] [2023-05-10T14:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.001461s ] [2023-05-10T14:55:28+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682352000 AND 1682438399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000312s ] [2023-05-10T14:55:28+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682438400 AND 1682524799 AND `pay_status` > 0 [ RunTime:0.000251s ] [2023-05-10T14:55:28+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682438400 AND 1682524799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000274s ] [2023-05-10T14:55:28+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.000226s ] [2023-05-10T14:55:28+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.000267s ] [2023-05-10T14:55:28+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.000123s ] [2023-05-10T14:55:28+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.000125s ] [2023-05-10T14:55:28+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.000074s ] [2023-05-10T14:55:28+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.000075s ] [2023-05-10T14:55:28+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.000061s ] [2023-05-10T14:55:28+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.000066s ] [2023-05-10T14:55:28+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.000058s ] [2023-05-10T14:55:28+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.000062s ] [2023-05-10T14:55:28+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.000057s ] [2023-05-10T14:55:28+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.000061s ] [2023-05-10T14:55:28+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.000055s ] [2023-05-10T14:55:28+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.000060s ] [2023-05-10T14:55:28+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.000055s ] [2023-05-10T14:55:28+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.000059s ] [2023-05-10T14:55:28+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.000057s ] [2023-05-10T14:55:28+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.000204s ] [2023-05-10T14:55:28+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.000096s ] [2023-05-10T14:55:28+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.000081s ] [2023-05-10T14:55:28+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.000060s ] [2023-05-10T14:55:28+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.000064s ] [2023-05-10T14:55:28+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.000057s ] [2023-05-10T14:55:28+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.000061s ] [2023-05-10T14:55:28+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.000060s ] [2023-05-10T14:55:28+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.000091s ] [2023-05-10T14:55:36+08:00][sql] CONNECT:[ UseTime:0.014595s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.001647s ] [2023-05-10T14:55:36+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683701736 , `uri` = '/admin/order.Order/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/order_Order\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000156s ] [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.000537s ] [2023-05-10T14:55:36+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.001712s ] [2023-05-10T14:55:36+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.000504s ] [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_order_goods` [ RunTime:0.000387s ] [2023-05-10T14:55:36+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.000177s ] [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.000477s ] [2023-05-10T14:55:36+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar`,`level`,`mobile`,`sex`,`create_time` FROM `ls_user` WHERE `id` IN (2,1) [ RunTime:0.000191s ] [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.000768s ] [2023-05-10T14:55:36+08:00][sql] SELECT `id`,`name`,`type`,`logo`,`mobile`,`open_invoice`,`spec_invoice` FROM `ls_shop` WHERE `id` = 2 [ RunTime:0.000249s ] [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.000529s ] [2023-05-10T14:55:36+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 [ RunTime:0.000131s ] [2023-05-10T14:55:36+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `order_status` = 0 [ RunTime:0.000158s ] [2023-05-10T14:55:36+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `order_status` = 1 [ RunTime:0.000112s ] [2023-05-10T14:55:36+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `order_status` = 2 [ RunTime:0.000094s ] [2023-05-10T14:55:36+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `order_status` = 3 [ RunTime:0.000088s ] [2023-05-10T14:55:36+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `order_status` = 4 [ RunTime:0.000086s ] [2023-05-10T14:55:36+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` [ RunTime:0.000143s ] [2023-05-10T14:55:36+08:00][sql] CONNECT:[ UseTime:0.020688s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.001506s ] [2023-05-10T14:55:36+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683701736 , `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.000115s ] [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.000430s ] [2023-05-10T14:55:36+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.002596s ] [2023-05-10T14:55:36+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.000426s ] [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_order_goods` [ RunTime:0.000294s ] [2023-05-10T14:55:36+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.000125s ] [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.000352s ] [2023-05-10T14:55:36+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar`,`level`,`mobile`,`sex`,`create_time` FROM `ls_user` WHERE `id` IN (2,1) [ RunTime:0.000103s ] [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.000321s ] [2023-05-10T14:55:36+08:00][sql] SELECT `id`,`name`,`type`,`logo`,`mobile`,`open_invoice`,`spec_invoice` FROM `ls_shop` WHERE `id` = 2 [ RunTime:0.000086s ] [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.001195s ] [2023-05-10T14:55:36+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 [ RunTime:0.000086s ] [2023-05-10T14:55:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_region` [ RunTime:0.001430s ] [2023-05-10T14:55:36+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.000140s ] [2023-05-10T14:55:36+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.000113s ] [2023-05-10T14:55:36+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.000086s ] [2023-05-10T14:55:36+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.000077s ] [2023-05-10T14:56:26+08:00][sql] CONNECT:[ UseTime:0.017513s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-10T14:56:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.001736s ] [2023-05-10T14:56:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683701786 , `uri` = '/admin/order.order/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/order_order\\/lists_html\":\"\",\"type\":\"\",\"page\":\"1\",\"limit\":\"10\",\"search_key\":\"order_sn\",\"keyword\":\"\",\"shop_name\":\"\",\"goods_name\":\"\",\"order_type\":\"\",\"order_source\":\"\",\"pay_way\":\"\",\"delivery_type\":\"\",\"start_time\":\"\",\"end_time\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000186s ] [2023-05-10T14:56:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.001545s ] [2023-05-10T14:56:26+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.001737s ] [2023-05-10T14:56:26+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.000541s ] [2023-05-10T14:56:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_order_goods` [ RunTime:0.000416s ] [2023-05-10T14:56:26+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.000175s ] [2023-05-10T14:56:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.000444s ] [2023-05-10T14:56:26+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar`,`level`,`mobile`,`sex`,`create_time` FROM `ls_user` WHERE `id` IN (2,1) [ RunTime:0.000156s ] [2023-05-10T14:56:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.000469s ] [2023-05-10T14:56:26+08:00][sql] SELECT `id`,`name`,`type`,`logo`,`mobile`,`open_invoice`,`spec_invoice` FROM `ls_shop` WHERE `id` = 2 [ RunTime:0.000154s ] [2023-05-10T14:56:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.001383s ] [2023-05-10T14:56:26+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 [ RunTime:0.000134s ] [2023-05-10T14:56:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_region` [ RunTime:0.001501s ] [2023-05-10T14:56:26+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.000172s ] [2023-05-10T14:56:26+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.000168s ] [2023-05-10T14:56:26+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.000152s ] [2023-05-10T14:56:26+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.000144s ] [2023-05-10T14:57:02+08:00][sql] CONNECT:[ UseTime:0.013633s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4 [2023-05-10T14:57:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.001545s ] [2023-05-10T14:57:02+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683701822 , `uri` = '/admin/order.order/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/order_order\\/lists_html\":\"\",\"type\":\"\",\"page\":\"1\",\"limit\":\"10\",\"search_key\":\"order_sn\",\"keyword\":\"\",\"shop_name\":\"\",\"goods_name\":\"\",\"order_type\":\"\",\"order_source\":\"\",\"pay_way\":\"\",\"delivery_type\":\"\",\"start_time\":\"\",\"end_time\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000164s ] [2023-05-10T14:57:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.000509s ] [2023-05-10T14:57:02+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.001710s ] [2023-05-10T14:57:02+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.000527s ] [2023-05-10T14:57:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_order_goods` [ RunTime:0.000643s ] [2023-05-10T14:57:02+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.000251s ] [2023-05-10T14:57:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.000713s ] [2023-05-10T14:57:02+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar`,`level`,`mobile`,`sex`,`create_time` FROM `ls_user` WHERE `id` IN (2,1) [ RunTime:0.000399s ] [2023-05-10T14:57:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.001112s ] [2023-05-10T14:57:02+08:00][sql] SELECT `id`,`name`,`type`,`logo`,`mobile`,`open_invoice`,`spec_invoice` FROM `ls_shop` WHERE `id` = 2 [ RunTime:0.000228s ] [2023-05-10T14:57:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.001359s ] [2023-05-10T14:57:02+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 [ RunTime:0.000138s ] [2023-05-10T14:57:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_region` [ RunTime:0.000386s ] [2023-05-10T14:57:02+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.000156s ] [2023-05-10T14:57:02+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.000170s ] [2023-05-10T14:57:02+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.000211s ] [2023-05-10T14:57:02+08:00][sql] SELECT `name` FROM `ls_dev_region` WHERE `id` IN (110000,110100,110101) ORDER BY `level` ASC [ RunTime:0.000207s ]