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.
145 lines
25 KiB
145 lines
25 KiB
[2023-05-22T13:53:08+08:00][sql] CONNECT:[ UseTime:0.061667s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-22T13:53:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.036883s ]
|
|
[2023-05-22T13:53:08+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.033100s ]
|
|
[2023-05-22T13:53:08+08:00][sql] SELECT `id`,`account`,`name`,`role_id` FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.032711s ]
|
|
[2023-05-22T13:53:08+08:00][sql] UPDATE `ls_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1684734788 WHERE `account` = 'admin' [ RunTime:0.034618s ]
|
|
[2023-05-22T13:53:10+08:00][sql] CONNECT:[ UseTime:0.064094s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-22T13:53:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.050098s ]
|
|
[2023-05-22T13:53:10+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1684734789 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.040599s ]
|
|
[2023-05-22T13:53:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.042971s ]
|
|
[2023-05-22T13:53:10+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.043155s ]
|
|
[2023-05-22T13:53:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.047488s ]
|
|
[2023-05-22T13:53:10+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.043106s ]
|
|
[2023-05-22T13:53:11+08:00][sql] CONNECT:[ UseTime:0.044248s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-22T13:53:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.037108s ]
|
|
[2023-05-22T13:53:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1684734790 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.029891s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.033284s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.032633s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1684598400 AND 1684684799 [ RunTime:0.029630s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1684684800 AND 1684771199 [ RunTime:0.029626s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.029685s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1684598400 AND 1684684799 [ RunTime:0.029781s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1684684800 AND 1684771199 [ RunTime:0.035280s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.033416s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.032135s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1684598400 AND 1684684799 [ RunTime:0.029641s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1684684800 AND 1684771199 [ RunTime:0.031423s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.031572s ]
|
|
[2023-05-22T13:53:11+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.031885s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684598400 AND 1684684799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.029786s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684684800 AND 1684771199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.030059s ]
|
|
[2023-05-22T13:53:11+08:00][sql] CONNECT:[ UseTime:0.066317s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-22T13:53:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.031951s ]
|
|
[2023-05-22T13:53:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1684734791 , `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.029057s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.032292s ]
|
|
[2023-05-22T13:53:11+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.029883s ]
|
|
[2023-05-22T13:53:11+08:00][sql] CONNECT:[ UseTime:0.065574s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-22T13:53:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.031735s ]
|
|
[2023-05-22T13:53:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1684734791 , `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.029527s ]
|
|
[2023-05-22T13:53:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.032226s ]
|
|
[2023-05-22T13:53:11+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.029421s ]
|
|
[2023-05-22T13:53:13+08:00][sql] CONNECT:[ UseTime:0.078354s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-22T13:53:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.038045s ]
|
|
[2023-05-22T13:53:13+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1684734791 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.035762s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.038841s ]
|
|
[2023-05-22T13:53:13+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.036036s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.040807s ]
|
|
[2023-05-22T13:53:13+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.036354s ]
|
|
[2023-05-22T13:53:13+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.036691s ]
|
|
[2023-05-22T13:53:13+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.036483s ]
|
|
[2023-05-22T13:53:13+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.040059s ]
|
|
[2023-05-22T13:53:13+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.041212s ]
|
|
[2023-05-22T13:53:13+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.037207s ]
|
|
[2023-05-22T13:53:13+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.043008s ]
|
|
[2023-05-22T13:53:13+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.038165s ]
|
|
[2023-05-22T13:53:13+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.039506s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 AND `pay_status` > 0 [ RunTime:0.068129s ]
|
|
[2023-05-22T13:53:13+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.075967s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683907200 AND 1683993599 AND `pay_status` > 0 [ RunTime:0.084302s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683907200 AND 1683993599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.056510s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683993600 AND 1684079999 AND `pay_status` > 0 [ RunTime:0.049207s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683993600 AND 1684079999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.037972s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684080000 AND 1684166399 AND `pay_status` > 0 [ RunTime:0.056503s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684080000 AND 1684166399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.070884s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684166400 AND 1684252799 AND `pay_status` > 0 [ RunTime:0.057495s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684166400 AND 1684252799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052286s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684252800 AND 1684339199 AND `pay_status` > 0 [ RunTime:0.050392s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684252800 AND 1684339199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.077088s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684339200 AND 1684425599 AND `pay_status` > 0 [ RunTime:0.036260s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684339200 AND 1684425599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.037703s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684425600 AND 1684511999 AND `pay_status` > 0 [ RunTime:0.063328s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684425600 AND 1684511999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.080164s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684512000 AND 1684598399 AND `pay_status` > 0 [ RunTime:0.089004s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684512000 AND 1684598399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.076513s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684598400 AND 1684684799 AND `pay_status` > 0 [ RunTime:0.048291s ]
|
|
[2023-05-22T13:53:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684598400 AND 1684684799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.053470s ]
|
|
[2023-05-22T13:53:39+08:00][sql] CONNECT:[ UseTime:0.058162s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-22T13:53:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.036865s ]
|
|
[2023-05-22T13:53:39+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1684734819 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.036823s ]
|
|
[2023-05-22T13:53:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.036852s ]
|
|
[2023-05-22T13:53:39+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.035639s ]
|
|
[2023-05-22T13:53:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.039899s ]
|
|
[2023-05-22T13:53:39+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.033881s ]
|
|
[2023-05-22T13:53:40+08:00][sql] CONNECT:[ UseTime:0.074901s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-22T13:53:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.052814s ]
|
|
[2023-05-22T13:53:40+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1684734819 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.049953s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.052804s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.049996s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1684598400 AND 1684684799 [ RunTime:0.049644s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1684684800 AND 1684771199 [ RunTime:0.049526s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.051086s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1684598400 AND 1684684799 [ RunTime:0.059583s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1684684800 AND 1684771199 [ RunTime:0.049944s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.052255s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.051298s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1684598400 AND 1684684799 [ RunTime:0.049720s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1684684800 AND 1684771199 [ RunTime:0.050599s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.052521s ]
|
|
[2023-05-22T13:53:40+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.050002s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684598400 AND 1684684799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.049808s ]
|
|
[2023-05-22T13:53:40+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684684800 AND 1684771199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.055809s ]
|
|
[2023-05-22T13:53:41+08:00][sql] CONNECT:[ UseTime:0.078966s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-22T13:53:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.047618s ]
|
|
[2023-05-22T13:53:41+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1684734821 , `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.045796s ]
|
|
[2023-05-22T13:53:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.049702s ]
|
|
[2023-05-22T13:53: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.045446s ]
|
|
[2023-05-22T13:53:41+08:00][sql] CONNECT:[ UseTime:0.088441s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-22T13:53:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.050277s ]
|
|
[2023-05-22T13:53:41+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1684734821 , `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.047198s ]
|
|
[2023-05-22T13:53:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.050190s ]
|
|
[2023-05-22T13:53: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.047350s ]
|
|
[2023-05-22T13:53:43+08:00][sql] CONNECT:[ UseTime:0.078757s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-05-22T13:53:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.047419s ]
|
|
[2023-05-22T13:53:43+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1684734821 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.044824s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.047105s ]
|
|
[2023-05-22T13:53:43+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.045969s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.048951s ]
|
|
[2023-05-22T13:53:43+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.067729s ]
|
|
[2023-05-22T13:53:43+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.065661s ]
|
|
[2023-05-22T13:53:43+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.045067s ]
|
|
[2023-05-22T13:53:43+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.045629s ]
|
|
[2023-05-22T13:53:43+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.045506s ]
|
|
[2023-05-22T13:53:43+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.044946s ]
|
|
[2023-05-22T13:53:43+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.045586s ]
|
|
[2023-05-22T13:53:43+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.044843s ]
|
|
[2023-05-22T13:53:43+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.045008s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683820800 AND 1683907199 AND `pay_status` > 0 [ RunTime:0.045111s ]
|
|
[2023-05-22T13:53:43+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.060957s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683907200 AND 1683993599 AND `pay_status` > 0 [ RunTime:0.062106s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683907200 AND 1683993599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.058756s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683993600 AND 1684079999 AND `pay_status` > 0 [ RunTime:0.057251s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683993600 AND 1684079999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045769s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684080000 AND 1684166399 AND `pay_status` > 0 [ RunTime:0.045129s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684080000 AND 1684166399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044865s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684166400 AND 1684252799 AND `pay_status` > 0 [ RunTime:0.066136s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684166400 AND 1684252799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044859s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684252800 AND 1684339199 AND `pay_status` > 0 [ RunTime:0.044697s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684252800 AND 1684339199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.044940s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684339200 AND 1684425599 AND `pay_status` > 0 [ RunTime:0.058989s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684339200 AND 1684425599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.060917s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684425600 AND 1684511999 AND `pay_status` > 0 [ RunTime:0.069847s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684425600 AND 1684511999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.067103s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684512000 AND 1684598399 AND `pay_status` > 0 [ RunTime:0.058029s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684512000 AND 1684598399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.068726s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1684598400 AND 1684684799 AND `pay_status` > 0 [ RunTime:0.057571s ]
|
|
[2023-05-22T13:53:43+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1684598400 AND 1684684799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.066945s ]
|
|
|