You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
159 lines
26 KiB
159 lines
26 KiB
[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 ]
|
|
|