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.
777 lines
127 KiB
777 lines
127 KiB
[2023-08-10T13:44:51+08:00][sql] CONNECT:[ UseTime:0.070348s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:44:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.039568s ]
|
|
[2023-08-10T13:44:51+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.049934s ]
|
|
[2023-08-10T13:44:57+08:00][sql] CONNECT:[ UseTime:0.352141s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:44:57+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.074538s ]
|
|
[2023-08-10T13:44:57+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.051892s ]
|
|
[2023-08-10T13:44:57+08:00][sql] SELECT `id`,`account`,`name`,`role_id` FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.048003s ]
|
|
[2023-08-10T13:44:57+08:00][sql] UPDATE `ls_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1691646297 WHERE `account` = 'admin' [ RunTime:0.083692s ]
|
|
[2023-08-10T13:44:59+08:00][sql] CONNECT:[ UseTime:0.108146s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.063029s ]
|
|
[2023-08-10T13:44:59+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646298 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.065753s ]
|
|
[2023-08-10T13:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.075963s ]
|
|
[2023-08-10T13:44:59+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.086261s ]
|
|
[2023-08-10T13:44:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.086947s ]
|
|
[2023-08-10T13:44:59+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.091355s ]
|
|
[2023-08-10T13:45:01+08:00][sql] CONNECT:[ UseTime:0.094237s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:45:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.095537s ]
|
|
[2023-08-10T13:45:01+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646299 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.050683s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.073343s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.068935s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.056391s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.053612s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.056656s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.072973s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.070896s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.068408s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.072188s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.080652s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.087292s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.090511s ]
|
|
[2023-08-10T13:45:01+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.083078s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.075077s ]
|
|
[2023-08-10T13:45:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691596800 AND 1691683199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.084342s ]
|
|
[2023-08-10T13:45:02+08:00][sql] CONNECT:[ UseTime:0.145278s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:45:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.087215s ]
|
|
[2023-08-10T13:45:02+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646301 , `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.097886s ]
|
|
[2023-08-10T13:45:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.088256s ]
|
|
[2023-08-10T13:45:02+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.073703s ]
|
|
[2023-08-10T13:45:02+08:00][sql] CONNECT:[ UseTime:0.157137s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:45:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.184424s ]
|
|
[2023-08-10T13:45:02+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646301 , `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.091490s ]
|
|
[2023-08-10T13:45:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.077707s ]
|
|
[2023-08-10T13:45: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.093439s ]
|
|
[2023-08-10T13:45:04+08:00][sql] CONNECT:[ UseTime:0.139832s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:45:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.062717s ]
|
|
[2023-08-10T13:45:04+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646301 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.099369s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.080419s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690300800 AND 1690387199 AND `pay_status` > 0 [ RunTime:0.075491s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.063883s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690300800 AND 1690387199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.063713s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690387200 AND 1690473599 AND `pay_status` > 0 [ RunTime:0.059718s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690387200 AND 1690473599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045748s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690473600 AND 1690559999 AND `pay_status` > 0 [ RunTime:0.068840s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690473600 AND 1690559999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.063288s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690560000 AND 1690646399 AND `pay_status` > 0 [ RunTime:0.041128s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690560000 AND 1690646399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.043139s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690646400 AND 1690732799 AND `pay_status` > 0 [ RunTime:0.040343s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690646400 AND 1690732799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.054902s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690732800 AND 1690819199 AND `pay_status` > 0 [ RunTime:0.069496s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690732800 AND 1690819199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.067982s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690819200 AND 1690905599 AND `pay_status` > 0 [ RunTime:0.096221s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690819200 AND 1690905599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.099597s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690905600 AND 1690991999 AND `pay_status` > 0 [ RunTime:0.107039s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690905600 AND 1690991999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.105511s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690992000 AND 1691078399 AND `pay_status` > 0 [ RunTime:0.111505s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690992000 AND 1691078399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.089011s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691078400 AND 1691164799 AND `pay_status` > 0 [ RunTime:0.052391s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691078400 AND 1691164799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.043048s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691164800 AND 1691251199 AND `pay_status` > 0 [ RunTime:0.049571s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691164800 AND 1691251199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.055526s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691251200 AND 1691337599 AND `pay_status` > 0 [ RunTime:0.064530s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691251200 AND 1691337599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.096434s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691337600 AND 1691423999 AND `pay_status` > 0 [ RunTime:0.085000s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691337600 AND 1691423999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.068685s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691424000 AND 1691510399 AND `pay_status` > 0 [ RunTime:0.072664s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691424000 AND 1691510399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.071470s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 AND `pay_status` > 0 [ RunTime:0.090568s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.074196s ]
|
|
[2023-08-10T13:45:04+08:00][sql] CONNECT:[ UseTime:0.124819s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:45:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.088317s ]
|
|
[2023-08-10T13:45:04+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646304 , `uri` = '/admin/content.Resource/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.096148s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.095374s ]
|
|
[2023-08-10T13:45:04+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.099952s ]
|
|
[2023-08-10T13:45:05+08:00][sql] CONNECT:[ UseTime:0.053659s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:45:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.045245s ]
|
|
[2023-08-10T13:45:05+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646304 , `uri` = '/admin/content.Resource/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.058683s ]
|
|
[2023-08-10T13:45:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource` [ RunTime:0.069618s ]
|
|
[2023-08-10T13:45:05+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_resource` WHERE `del` = 0 [ RunTime:0.062377s ]
|
|
[2023-08-10T13:45:05+08:00][sql] SELECT `id`,`cid`,`title`,`image`,`content`,`visit`,`likes`,`download`,`sort`,`is_show`,`del`,`create_time`,`update_time`,`intro`,`path`,`price`,`type`,`province_id`,`city_id`,`district_id`,`sales_num` FROM `ls_resource` WHERE `del` = 0 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.241798s ]
|
|
[2023-08-10T13:45:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.072944s ]
|
|
[2023-08-10T13:45:05+08:00][sql] SELECT * FROM `ls_resource_category` WHERE `id` IN (6,7,10) [ RunTime:0.055477s ]
|
|
[2023-08-10T13:45:07+08:00][sql] CONNECT:[ UseTime:0.091373s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:45:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.057088s ]
|
|
[2023-08-10T13:45:07+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646307 , `uri` = '/admin/content.Resource/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.052995s ]
|
|
[2023-08-10T13:45:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.071755s ]
|
|
[2023-08-10T13:45:07+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.059006s ]
|
|
[2023-08-10T13:47:27+08:00][sql] CONNECT:[ UseTime:0.073686s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:47:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.047563s ]
|
|
[2023-08-10T13:47:27+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646447 , `uri` = '/admin/content.Resource/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.050254s ]
|
|
[2023-08-10T13:47:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.042877s ]
|
|
[2023-08-10T13:47:27+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.041863s ]
|
|
[2023-08-10T13:54:10+08:00][sql] CONNECT:[ UseTime:0.054078s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.037501s ]
|
|
[2023-08-10T13:54:10+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646849 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.036567s ]
|
|
[2023-08-10T13:54:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.037473s ]
|
|
[2023-08-10T13:54:10+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.040188s ]
|
|
[2023-08-10T13:54:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.037216s ]
|
|
[2023-08-10T13:54:10+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.035710s ]
|
|
[2023-08-10T13:54:10+08:00][sql] CONNECT:[ UseTime:0.071010s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.049118s ]
|
|
[2023-08-10T13:54:10+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646849 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.047542s ]
|
|
[2023-08-10T13:54:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.049458s ]
|
|
[2023-08-10T13:54:10+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.048780s ]
|
|
[2023-08-10T13:54:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.049976s ]
|
|
[2023-08-10T13:54:10+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.047699s ]
|
|
[2023-08-10T13:54:11+08:00][sql] CONNECT:[ UseTime:0.055319s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.039988s ]
|
|
[2023-08-10T13:54:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646850 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.037190s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.039987s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.036830s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.036988s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.036630s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.036579s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.036896s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.037708s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.041108s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.053059s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.064148s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.036633s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.038674s ]
|
|
[2023-08-10T13:54: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.037385s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.036473s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691596800 AND 1691683199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.036651s ]
|
|
[2023-08-10T13:54:11+08:00][sql] CONNECT:[ UseTime:0.051743s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.035936s ]
|
|
[2023-08-10T13:54:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646851 , `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.036201s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.039632s ]
|
|
[2023-08-10T13:54: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.034405s ]
|
|
[2023-08-10T13:54:11+08:00][sql] CONNECT:[ UseTime:0.063162s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.043499s ]
|
|
[2023-08-10T13:54:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646851 , `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.047436s ]
|
|
[2023-08-10T13:54:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.043868s ]
|
|
[2023-08-10T13:54: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.042221s ]
|
|
[2023-08-10T13:54:13+08:00][sql] CONNECT:[ UseTime:0.081569s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.047946s ]
|
|
[2023-08-10T13:54:13+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646853 , `uri` = '/admin/content.Resource/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.040658s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.045862s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.042412s ]
|
|
[2023-08-10T13:54:13+08:00][sql] CONNECT:[ UseTime:0.091311s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.064301s ]
|
|
[2023-08-10T13:54:13+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646851 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.060897s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.063485s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690300800 AND 1690387199 AND `pay_status` > 0 [ RunTime:0.061208s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.062531s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690300800 AND 1690387199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.061417s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690387200 AND 1690473599 AND `pay_status` > 0 [ RunTime:0.062029s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690387200 AND 1690473599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.061170s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690473600 AND 1690559999 AND `pay_status` > 0 [ RunTime:0.061086s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690473600 AND 1690559999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.061361s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690560000 AND 1690646399 AND `pay_status` > 0 [ RunTime:0.061139s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690560000 AND 1690646399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.061838s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690646400 AND 1690732799 AND `pay_status` > 0 [ RunTime:0.061169s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690646400 AND 1690732799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.061175s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690732800 AND 1690819199 AND `pay_status` > 0 [ RunTime:0.063595s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690732800 AND 1690819199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.067680s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690819200 AND 1690905599 AND `pay_status` > 0 [ RunTime:0.061405s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690819200 AND 1690905599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.063193s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690905600 AND 1690991999 AND `pay_status` > 0 [ RunTime:0.061333s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690905600 AND 1690991999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.062640s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690992000 AND 1691078399 AND `pay_status` > 0 [ RunTime:0.061007s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690992000 AND 1691078399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.061402s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691078400 AND 1691164799 AND `pay_status` > 0 [ RunTime:0.061374s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691078400 AND 1691164799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.070410s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691164800 AND 1691251199 AND `pay_status` > 0 [ RunTime:0.072834s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691164800 AND 1691251199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.063352s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691251200 AND 1691337599 AND `pay_status` > 0 [ RunTime:0.061022s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691251200 AND 1691337599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.062199s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691337600 AND 1691423999 AND `pay_status` > 0 [ RunTime:0.060964s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691337600 AND 1691423999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.064398s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691424000 AND 1691510399 AND `pay_status` > 0 [ RunTime:0.061362s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691424000 AND 1691510399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.061395s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 AND `pay_status` > 0 [ RunTime:0.061785s ]
|
|
[2023-08-10T13:54:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.063858s ]
|
|
[2023-08-10T13:54:14+08:00][sql] CONNECT:[ UseTime:0.068152s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.045609s ]
|
|
[2023-08-10T13:54:14+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646853 , `uri` = '/admin/content.Resource/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.043702s ]
|
|
[2023-08-10T13:54:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource` [ RunTime:0.046781s ]
|
|
[2023-08-10T13:54:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_resource` WHERE `del` = 0 [ RunTime:0.043343s ]
|
|
[2023-08-10T13:54:14+08:00][sql] SELECT `id`,`cid`,`title`,`image`,`content`,`visit`,`likes`,`download`,`sort`,`is_show`,`del`,`create_time`,`update_time`,`intro`,`path`,`price`,`type`,`province_id`,`city_id`,`district_id`,`sales_num` FROM `ls_resource` WHERE `del` = 0 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.192181s ]
|
|
[2023-08-10T13:54:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.055183s ]
|
|
[2023-08-10T13:54:14+08:00][sql] SELECT * FROM `ls_resource_category` WHERE `id` IN (6,7,10) [ RunTime:0.050982s ]
|
|
[2023-08-10T13:54:14+08:00][sql] CONNECT:[ UseTime:0.067798s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.046593s ]
|
|
[2023-08-10T13:54:14+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646854 , `uri` = '/admin/content.Resource/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.044349s ]
|
|
[2023-08-10T13:54:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.047177s ]
|
|
[2023-08-10T13:54:14+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.044980s ]
|
|
[2023-08-10T13:54:31+08:00][sql] CONNECT:[ UseTime:0.043656s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.030676s ]
|
|
[2023-08-10T13:54:31+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646870 , `uri` = '/admin/content.Resource/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.029142s ]
|
|
[2023-08-10T13:54:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.032117s ]
|
|
[2023-08-10T13:54:31+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.033175s ]
|
|
[2023-08-10T13:54:49+08:00][sql] CONNECT:[ UseTime:0.065195s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:49+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.047287s ]
|
|
[2023-08-10T13:54:49+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646889 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.056140s ]
|
|
[2023-08-10T13:54:49+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.043307s ]
|
|
[2023-08-10T13:54:49+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.042468s ]
|
|
[2023-08-10T13:54:49+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.042800s ]
|
|
[2023-08-10T13:54:49+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.047474s ]
|
|
[2023-08-10T13:54:50+08:00][sql] CONNECT:[ UseTime:0.083701s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.048745s ]
|
|
[2023-08-10T13:54:50+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646889 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.047497s ]
|
|
[2023-08-10T13:54:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.051017s ]
|
|
[2023-08-10T13:54:50+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.052790s ]
|
|
[2023-08-10T13:54:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.049161s ]
|
|
[2023-08-10T13:54:50+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.047304s ]
|
|
[2023-08-10T13:54:50+08:00][sql] CONNECT:[ UseTime:0.064954s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.046225s ]
|
|
[2023-08-10T13:54:50+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646889 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.044096s ]
|
|
[2023-08-10T13:54:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.045528s ]
|
|
[2023-08-10T13:54:50+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.045649s ]
|
|
[2023-08-10T13:54:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.045162s ]
|
|
[2023-08-10T13:54:50+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.043309s ]
|
|
[2023-08-10T13:54:51+08:00][sql] CONNECT:[ UseTime:0.050042s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.036011s ]
|
|
[2023-08-10T13:54:51+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646890 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.033448s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.035313s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.033540s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.033714s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.033641s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.033459s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.036860s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.034178s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.035828s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.033979s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.032972s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.042523s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.034595s ]
|
|
[2023-08-10T13:54:51+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.033737s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033470s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691596800 AND 1691683199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033675s ]
|
|
[2023-08-10T13:54:51+08:00][sql] CONNECT:[ UseTime:0.048702s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.034243s ]
|
|
[2023-08-10T13:54:51+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646891 , `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.032758s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.034560s ]
|
|
[2023-08-10T13:54:51+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.034011s ]
|
|
[2023-08-10T13:54:51+08:00][sql] CONNECT:[ UseTime:0.091069s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.062772s ]
|
|
[2023-08-10T13:54:51+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646891 , `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.060963s ]
|
|
[2023-08-10T13:54:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.066264s ]
|
|
[2023-08-10T13:54:51+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.061023s ]
|
|
[2023-08-10T13:54:52+08:00][sql] CONNECT:[ UseTime:0.057392s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.041603s ]
|
|
[2023-08-10T13:54:52+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646891 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.038118s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.042183s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690300800 AND 1690387199 AND `pay_status` > 0 [ RunTime:0.038291s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.039546s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690300800 AND 1690387199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.040591s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690387200 AND 1690473599 AND `pay_status` > 0 [ RunTime:0.040396s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690387200 AND 1690473599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038227s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690473600 AND 1690559999 AND `pay_status` > 0 [ RunTime:0.038020s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690473600 AND 1690559999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.039250s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690560000 AND 1690646399 AND `pay_status` > 0 [ RunTime:0.039524s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690560000 AND 1690646399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.039438s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690646400 AND 1690732799 AND `pay_status` > 0 [ RunTime:0.038893s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690646400 AND 1690732799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.039153s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690732800 AND 1690819199 AND `pay_status` > 0 [ RunTime:0.038327s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690732800 AND 1690819199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.039771s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690819200 AND 1690905599 AND `pay_status` > 0 [ RunTime:0.038299s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690819200 AND 1690905599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038654s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690905600 AND 1690991999 AND `pay_status` > 0 [ RunTime:0.039791s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690905600 AND 1690991999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038452s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690992000 AND 1691078399 AND `pay_status` > 0 [ RunTime:0.038098s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690992000 AND 1691078399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.037950s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691078400 AND 1691164799 AND `pay_status` > 0 [ RunTime:0.037907s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691078400 AND 1691164799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038215s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691164800 AND 1691251199 AND `pay_status` > 0 [ RunTime:0.044962s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691164800 AND 1691251199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052102s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691251200 AND 1691337599 AND `pay_status` > 0 [ RunTime:0.038591s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691251200 AND 1691337599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038650s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691337600 AND 1691423999 AND `pay_status` > 0 [ RunTime:0.037836s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691337600 AND 1691423999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.037906s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691424000 AND 1691510399 AND `pay_status` > 0 [ RunTime:0.037735s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691424000 AND 1691510399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038026s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 AND `pay_status` > 0 [ RunTime:0.038073s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038347s ]
|
|
[2023-08-10T13:54:52+08:00][sql] CONNECT:[ UseTime:0.057792s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.078828s ]
|
|
[2023-08-10T13:54:52+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646892 , `uri` = '/admin/user.User/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_User\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.038295s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.040662s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 ORDER BY `growth_value` ASC [ RunTime:0.039307s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_tag` [ RunTime:0.045107s ]
|
|
[2023-08-10T13:54:52+08:00][sql] SELECT `id`,`name` FROM `ls_user_tag` WHERE `del` = 0 ORDER BY `id` DESC [ RunTime:0.039449s ]
|
|
[2023-08-10T13:54:54+08:00][sql] CONNECT:[ UseTime:0.054422s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.037732s ]
|
|
[2023-08-10T13:54:54+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646892 , `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.036891s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.038224s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE `del` = 0 [ RunTime:0.036343s ]
|
|
[2023-08-10T13:54:54+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.036676s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.038081s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 [ RunTime:0.036184s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_tag` [ RunTime:0.037915s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT `id`,`name` FROM `ls_user_tag` WHERE `del` = 0 [ RunTime:0.035874s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.042956s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE ( `first_leader` = 8 OR `second_leader` = 8 ) AND `del` = 0 [ RunTime:0.036088s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.036133s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE ( `first_leader` = 6 OR `second_leader` = 6 ) AND `del` = 0 [ RunTime:0.036062s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.035906s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE ( `first_leader` = 5 OR `second_leader` = 5 ) AND `del` = 0 [ RunTime:0.036148s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.036893s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE ( `first_leader` = 4 OR `second_leader` = 4 ) AND `del` = 0 [ RunTime:0.039994s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.036783s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE ( `first_leader` = 3 OR `second_leader` = 3 ) AND `del` = 0 [ RunTime:0.039309s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.038712s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE ( `first_leader` = 2 OR `second_leader` = 2 ) AND `del` = 0 [ RunTime:0.053109s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.082709s ]
|
|
[2023-08-10T13:54:54+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE ( `first_leader` = 1 OR `second_leader` = 1 ) AND `del` = 0 [ RunTime:0.045331s ]
|
|
[2023-08-10T13:54:55+08:00][sql] CONNECT:[ UseTime:0.087627s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.060159s ]
|
|
[2023-08-10T13:54:55+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646895 , `uri` = '/admin/content.Resource/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.058458s ]
|
|
[2023-08-10T13:54:55+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.060817s ]
|
|
[2023-08-10T13:54:55+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.059130s ]
|
|
[2023-08-10T13:54:56+08:00][sql] CONNECT:[ UseTime:0.087785s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.057487s ]
|
|
[2023-08-10T13:54:56+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646895 , `uri` = '/admin/content.Resource/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.054704s ]
|
|
[2023-08-10T13:54:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource` [ RunTime:0.056263s ]
|
|
[2023-08-10T13:54:56+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_resource` WHERE `del` = 0 [ RunTime:0.054608s ]
|
|
[2023-08-10T13:54:56+08:00][sql] SELECT `id`,`cid`,`title`,`image`,`content`,`visit`,`likes`,`download`,`sort`,`is_show`,`del`,`create_time`,`update_time`,`intro`,`path`,`price`,`type`,`province_id`,`city_id`,`district_id`,`sales_num` FROM `ls_resource` WHERE `del` = 0 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.297826s ]
|
|
[2023-08-10T13:54:56+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.056370s ]
|
|
[2023-08-10T13:54:56+08:00][sql] SELECT * FROM `ls_resource_category` WHERE `id` IN (6,7,10) [ RunTime:0.056461s ]
|
|
[2023-08-10T13:54:58+08:00][sql] CONNECT:[ UseTime:0.070570s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:54:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.047713s ]
|
|
[2023-08-10T13:54:58+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646898 , `uri` = '/admin/content.Resource/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.034263s ]
|
|
[2023-08-10T13:54:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.035317s ]
|
|
[2023-08-10T13:54:58+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.033854s ]
|
|
[2023-08-10T13:55:23+08:00][sql] CONNECT:[ UseTime:0.081586s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.056778s ]
|
|
[2023-08-10T13:55:23+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646923 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.057467s ]
|
|
[2023-08-10T13:55:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.057776s ]
|
|
[2023-08-10T13:55:23+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.055814s ]
|
|
[2023-08-10T13:55:23+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.055568s ]
|
|
[2023-08-10T13:55:23+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.053912s ]
|
|
[2023-08-10T13:55:24+08:00][sql] CONNECT:[ UseTime:0.069164s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.047669s ]
|
|
[2023-08-10T13:55:24+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646923 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.051016s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.048947s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.045974s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.046375s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.045994s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.045753s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.046330s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.045442s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.048133s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.045722s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.046131s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.046246s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.048736s ]
|
|
[2023-08-10T13:55:24+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.047020s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.046116s ]
|
|
[2023-08-10T13:55:24+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691596800 AND 1691683199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045675s ]
|
|
[2023-08-10T13:55:25+08:00][sql] CONNECT:[ UseTime:0.043991s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.030509s ]
|
|
[2023-08-10T13:55:25+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646924 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.028822s ]
|
|
[2023-08-10T13:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.030170s ]
|
|
[2023-08-10T13: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.030098s ]
|
|
[2023-08-10T13:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.030232s ]
|
|
[2023-08-10T13:55:25+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.028404s ]
|
|
[2023-08-10T13:55:25+08:00][sql] CONNECT:[ UseTime:0.061912s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.043046s ]
|
|
[2023-08-10T13:55:25+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646924 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.042213s ]
|
|
[2023-08-10T13:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.043534s ]
|
|
[2023-08-10T13: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.042835s ]
|
|
[2023-08-10T13:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.043265s ]
|
|
[2023-08-10T13:55:25+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.041560s ]
|
|
[2023-08-10T13:55:25+08:00][sql] CONNECT:[ UseTime:0.064225s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.044194s ]
|
|
[2023-08-10T13:55:25+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646925 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.043918s ]
|
|
[2023-08-10T13:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.045282s ]
|
|
[2023-08-10T13: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.044795s ]
|
|
[2023-08-10T13:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.045408s ]
|
|
[2023-08-10T13:55:25+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.043189s ]
|
|
[2023-08-10T13:55:25+08:00][sql] CONNECT:[ UseTime:0.080477s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.057405s ]
|
|
[2023-08-10T13:55:25+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646925 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.054116s ]
|
|
[2023-08-10T13:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.056078s ]
|
|
[2023-08-10T13: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.057473s ]
|
|
[2023-08-10T13:55:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.062852s ]
|
|
[2023-08-10T13:55:25+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.053509s ]
|
|
[2023-08-10T13:55:26+08:00][sql] CONNECT:[ UseTime:0.080308s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.056981s ]
|
|
[2023-08-10T13:55:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646925 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.053749s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.059507s ]
|
|
[2023-08-10T13: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.054612s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.058180s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.059484s ]
|
|
[2023-08-10T13:55:26+08:00][sql] CONNECT:[ UseTime:0.068506s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.035124s ]
|
|
[2023-08-10T13:55:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646926 , `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.033721s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.037837s ]
|
|
[2023-08-10T13:55:26+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.037819s ]
|
|
[2023-08-10T13:55:26+08:00][sql] CONNECT:[ UseTime:0.079283s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.045279s ]
|
|
[2023-08-10T13:55:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646926 , `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.049295s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.048262s ]
|
|
[2023-08-10T13:55:26+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.044856s ]
|
|
[2023-08-10T13:55:26+08:00][sql] CONNECT:[ UseTime:0.057200s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.046768s ]
|
|
[2023-08-10T13:55:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646925 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.038003s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.039858s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690300800 AND 1690387199 AND `pay_status` > 0 [ RunTime:0.038056s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.040271s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690300800 AND 1690387199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038881s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690387200 AND 1690473599 AND `pay_status` > 0 [ RunTime:0.038496s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690387200 AND 1690473599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038487s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690473600 AND 1690559999 AND `pay_status` > 0 [ RunTime:0.038147s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690473600 AND 1690559999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.039706s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690560000 AND 1690646399 AND `pay_status` > 0 [ RunTime:0.038317s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690560000 AND 1690646399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.043369s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690646400 AND 1690732799 AND `pay_status` > 0 [ RunTime:0.041629s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690646400 AND 1690732799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.046230s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690732800 AND 1690819199 AND `pay_status` > 0 [ RunTime:0.039666s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690732800 AND 1690819199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038196s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690819200 AND 1690905599 AND `pay_status` > 0 [ RunTime:0.037992s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690819200 AND 1690905599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.042473s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690905600 AND 1690991999 AND `pay_status` > 0 [ RunTime:0.038221s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690905600 AND 1690991999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038479s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690992000 AND 1691078399 AND `pay_status` > 0 [ RunTime:0.038356s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690992000 AND 1691078399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.042187s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691078400 AND 1691164799 AND `pay_status` > 0 [ RunTime:0.040802s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691078400 AND 1691164799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.046989s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691164800 AND 1691251199 AND `pay_status` > 0 [ RunTime:0.037993s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691164800 AND 1691251199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038630s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691251200 AND 1691337599 AND `pay_status` > 0 [ RunTime:0.038705s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691251200 AND 1691337599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.040675s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691337600 AND 1691423999 AND `pay_status` > 0 [ RunTime:0.042223s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691337600 AND 1691423999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038336s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691424000 AND 1691510399 AND `pay_status` > 0 [ RunTime:0.038049s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691424000 AND 1691510399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038541s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 AND `pay_status` > 0 [ RunTime:0.039020s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038605s ]
|
|
[2023-08-10T13:55:26+08:00][sql] CONNECT:[ UseTime:0.061741s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.044587s ]
|
|
[2023-08-10T13:55:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646926 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.038572s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.042135s ]
|
|
[2023-08-10T13: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.058853s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.069095s ]
|
|
[2023-08-10T13:55:26+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.066057s ]
|
|
[2023-08-10T13:55:27+08:00][sql] CONNECT:[ UseTime:0.105598s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.045344s ]
|
|
[2023-08-10T13:55:27+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646926 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.043893s ]
|
|
[2023-08-10T13:55:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.052237s ]
|
|
[2023-08-10T13:55:27+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.054510s ]
|
|
[2023-08-10T13:55:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.046100s ]
|
|
[2023-08-10T13:55:27+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.043786s ]
|
|
[2023-08-10T13:55:28+08:00][sql] CONNECT:[ UseTime:0.099885s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.057414s ]
|
|
[2023-08-10T13:55:28+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646927 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.055932s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.057743s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.055097s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.055479s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.055929s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.055333s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.055374s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.055304s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.057746s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.055435s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.056100s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.055554s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.057671s ]
|
|
[2023-08-10T13:55:28+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.055779s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.055493s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691596800 AND 1691683199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.055707s ]
|
|
[2023-08-10T13:55:28+08:00][sql] CONNECT:[ UseTime:0.049439s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.034520s ]
|
|
[2023-08-10T13:55:28+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646928 , `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.033745s ]
|
|
[2023-08-10T13:55:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.035547s ]
|
|
[2023-08-10T13: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.033856s ]
|
|
[2023-08-10T13:55:29+08:00][sql] CONNECT:[ UseTime:0.069672s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.059798s ]
|
|
[2023-08-10T13:55:29+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646928 , `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.045719s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.048303s ]
|
|
[2023-08-10T13:55:29+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.045804s ]
|
|
[2023-08-10T13:55:29+08:00][sql] CONNECT:[ UseTime:0.050127s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.039971s ]
|
|
[2023-08-10T13:55:29+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646928 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.033823s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.034813s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690300800 AND 1690387199 AND `pay_status` > 0 [ RunTime:0.033021s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.035523s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690300800 AND 1690387199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.036463s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690387200 AND 1690473599 AND `pay_status` > 0 [ RunTime:0.034082s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690387200 AND 1690473599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033316s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690473600 AND 1690559999 AND `pay_status` > 0 [ RunTime:0.036854s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690473600 AND 1690559999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033559s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690560000 AND 1690646399 AND `pay_status` > 0 [ RunTime:0.033456s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690560000 AND 1690646399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033641s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690646400 AND 1690732799 AND `pay_status` > 0 [ RunTime:0.033356s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690646400 AND 1690732799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033514s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690732800 AND 1690819199 AND `pay_status` > 0 [ RunTime:0.033364s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690732800 AND 1690819199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.034130s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690819200 AND 1690905599 AND `pay_status` > 0 [ RunTime:0.034148s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690819200 AND 1690905599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033988s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690905600 AND 1690991999 AND `pay_status` > 0 [ RunTime:0.033328s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690905600 AND 1690991999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.034595s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690992000 AND 1691078399 AND `pay_status` > 0 [ RunTime:0.033511s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690992000 AND 1691078399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.035388s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691078400 AND 1691164799 AND `pay_status` > 0 [ RunTime:0.035324s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691078400 AND 1691164799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033647s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691164800 AND 1691251199 AND `pay_status` > 0 [ RunTime:0.034097s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691164800 AND 1691251199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.034735s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691251200 AND 1691337599 AND `pay_status` > 0 [ RunTime:0.033708s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691251200 AND 1691337599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033904s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691337600 AND 1691423999 AND `pay_status` > 0 [ RunTime:0.033543s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691337600 AND 1691423999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033930s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691424000 AND 1691510399 AND `pay_status` > 0 [ RunTime:0.033974s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691424000 AND 1691510399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033851s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 AND `pay_status` > 0 [ RunTime:0.036406s ]
|
|
[2023-08-10T13:55:29+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033476s ]
|
|
[2023-08-10T13:55:32+08:00][sql] CONNECT:[ UseTime:0.073097s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.050635s ]
|
|
[2023-08-10T13:55:32+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646932 , `uri` = '/admin/content.Resource/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.048954s ]
|
|
[2023-08-10T13:55:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.050700s ]
|
|
[2023-08-10T13:55:32+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.049555s ]
|
|
[2023-08-10T13:55:33+08:00][sql] CONNECT:[ UseTime:0.067403s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.047053s ]
|
|
[2023-08-10T13:55:33+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646932 , `uri` = '/admin/content.Resource/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.045448s ]
|
|
[2023-08-10T13:55:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource` [ RunTime:0.047064s ]
|
|
[2023-08-10T13:55:33+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_resource` WHERE `del` = 0 [ RunTime:0.045612s ]
|
|
[2023-08-10T13:55:33+08:00][sql] SELECT `id`,`cid`,`title`,`image`,`content`,`visit`,`likes`,`download`,`sort`,`is_show`,`del`,`create_time`,`update_time`,`intro`,`path`,`price`,`type`,`province_id`,`city_id`,`district_id`,`sales_num` FROM `ls_resource` WHERE `del` = 0 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.182406s ]
|
|
[2023-08-10T13:55:33+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.046140s ]
|
|
[2023-08-10T13:55:33+08:00][sql] SELECT * FROM `ls_resource_category` WHERE `id` IN (6,7,10) [ RunTime:0.044854s ]
|
|
[2023-08-10T13:55:34+08:00][sql] CONNECT:[ UseTime:0.061861s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:55:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.043310s ]
|
|
[2023-08-10T13:55:34+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646934 , `uri` = '/admin/content.Resource/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.041410s ]
|
|
[2023-08-10T13:55:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.044283s ]
|
|
[2023-08-10T13:55:34+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.044252s ]
|
|
[2023-08-10T13:56:09+08:00][sql] CONNECT:[ UseTime:0.051495s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.038845s ]
|
|
[2023-08-10T13:56:09+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646969 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.032379s ]
|
|
[2023-08-10T13:56:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.034246s ]
|
|
[2023-08-10T13:56:09+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.034194s ]
|
|
[2023-08-10T13:56:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.033536s ]
|
|
[2023-08-10T13:56:09+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.031866s ]
|
|
[2023-08-10T13:56:09+08:00][sql] CONNECT:[ UseTime:0.065621s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.046762s ]
|
|
[2023-08-10T13:56:09+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646969 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.043332s ]
|
|
[2023-08-10T13:56:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.045477s ]
|
|
[2023-08-10T13:56:09+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.045348s ]
|
|
[2023-08-10T13:56:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.044867s ]
|
|
[2023-08-10T13:56:09+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.043298s ]
|
|
[2023-08-10T13:56:09+08:00][sql] CONNECT:[ UseTime:0.062475s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.043104s ]
|
|
[2023-08-10T13:56:09+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646969 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.041441s ]
|
|
[2023-08-10T13:56:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.042997s ]
|
|
[2023-08-10T13:56:09+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.043069s ]
|
|
[2023-08-10T13:56:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.043349s ]
|
|
[2023-08-10T13:56:09+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.041409s ]
|
|
[2023-08-10T13:56:10+08:00][sql] CONNECT:[ UseTime:0.086819s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.059335s ]
|
|
[2023-08-10T13:56:10+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646969 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.059106s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.059792s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.059938s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.060868s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.058146s ]
|
|
[2023-08-10T13:56:10+08:00][sql] CONNECT:[ UseTime:0.043803s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.035442s ]
|
|
[2023-08-10T13:56:10+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646969 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.028794s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.032004s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.031482s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.030827s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.029384s ]
|
|
[2023-08-10T13:56:10+08:00][sql] CONNECT:[ UseTime:0.066209s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.045808s ]
|
|
[2023-08-10T13:56:10+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646969 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.044017s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.045795s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.048881s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.046445s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.043891s ]
|
|
[2023-08-10T13:56:10+08:00][sql] CONNECT:[ UseTime:0.063219s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.043299s ]
|
|
[2023-08-10T13:56:10+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646969 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.042141s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.043690s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.044075s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.044406s ]
|
|
[2023-08-10T13:56:10+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.042056s ]
|
|
[2023-08-10T13:56:11+08:00][sql] CONNECT:[ UseTime:0.050862s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.036229s ]
|
|
[2023-08-10T13:56:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646970 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.034293s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.036186s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.035818s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.034066s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.034408s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.034192s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.034707s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.034849s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.036597s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.034620s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 [ RunTime:0.033937s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1691596800 AND 1691683199 [ RunTime:0.034674s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.048386s ]
|
|
[2023-08-10T13:56: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.034720s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033935s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691596800 AND 1691683199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033950s ]
|
|
[2023-08-10T13:56:11+08:00][sql] CONNECT:[ UseTime:0.056984s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.040076s ]
|
|
[2023-08-10T13:56:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646971 , `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.038201s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.040500s ]
|
|
[2023-08-10T13:56: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.038477s ]
|
|
[2023-08-10T13:56:11+08:00][sql] CONNECT:[ UseTime:0.080777s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.056398s ]
|
|
[2023-08-10T13:56:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646971 , `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.054213s ]
|
|
[2023-08-10T13:56:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.059742s ]
|
|
[2023-08-10T13:56: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.056123s ]
|
|
[2023-08-10T13:56:12+08:00][sql] CONNECT:[ UseTime:0.044080s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.034130s ]
|
|
[2023-08-10T13:56:12+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646972 , `uri` = '/admin/content.Resource/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.034348s ]
|
|
[2023-08-10T13:56:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.033050s ]
|
|
[2023-08-10T13:56:12+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.030965s ]
|
|
[2023-08-10T13:56:13+08:00][sql] CONNECT:[ UseTime:0.070425s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.048559s ]
|
|
[2023-08-10T13:56:13+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646971 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.047266s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.051536s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690300800 AND 1690387199 AND `pay_status` > 0 [ RunTime:0.048432s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.049405s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690300800 AND 1690387199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047318s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690387200 AND 1690473599 AND `pay_status` > 0 [ RunTime:0.047306s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690387200 AND 1690473599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047914s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690473600 AND 1690559999 AND `pay_status` > 0 [ RunTime:0.047611s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690473600 AND 1690559999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052802s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690560000 AND 1690646399 AND `pay_status` > 0 [ RunTime:0.047268s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690560000 AND 1690646399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047443s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690646400 AND 1690732799 AND `pay_status` > 0 [ RunTime:0.047215s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690646400 AND 1690732799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047356s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690732800 AND 1690819199 AND `pay_status` > 0 [ RunTime:0.047870s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690732800 AND 1690819199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047195s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690819200 AND 1690905599 AND `pay_status` > 0 [ RunTime:0.047162s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690819200 AND 1690905599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047383s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690905600 AND 1690991999 AND `pay_status` > 0 [ RunTime:0.047104s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690905600 AND 1690991999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047356s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1690992000 AND 1691078399 AND `pay_status` > 0 [ RunTime:0.047254s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1690992000 AND 1691078399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047312s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691078400 AND 1691164799 AND `pay_status` > 0 [ RunTime:0.047309s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691078400 AND 1691164799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047376s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691164800 AND 1691251199 AND `pay_status` > 0 [ RunTime:0.047072s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691164800 AND 1691251199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047082s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691251200 AND 1691337599 AND `pay_status` > 0 [ RunTime:0.046984s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691251200 AND 1691337599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.046926s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691337600 AND 1691423999 AND `pay_status` > 0 [ RunTime:0.050679s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691337600 AND 1691423999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.049212s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691424000 AND 1691510399 AND `pay_status` > 0 [ RunTime:0.047463s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691424000 AND 1691510399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047429s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 AND `pay_status` > 0 [ RunTime:0.047728s ]
|
|
[2023-08-10T13:56:13+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1691510400 AND 1691596799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047205s ]
|
|
[2023-08-10T13:56:14+08:00][sql] CONNECT:[ UseTime:0.082998s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.061665s ]
|
|
[2023-08-10T13:56:14+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646973 , `uri` = '/admin/content.Resource/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.055499s ]
|
|
[2023-08-10T13:56:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource` [ RunTime:0.057462s ]
|
|
[2023-08-10T13:56:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_resource` WHERE `del` = 0 [ RunTime:0.054987s ]
|
|
[2023-08-10T13:56:14+08:00][sql] SELECT `id`,`cid`,`title`,`image`,`content`,`visit`,`likes`,`download`,`sort`,`is_show`,`del`,`create_time`,`update_time`,`intro`,`path`,`price`,`type`,`province_id`,`city_id`,`district_id`,`sales_num` FROM `ls_resource` WHERE `del` = 0 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.360492s ]
|
|
[2023-08-10T13:56:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.056473s ]
|
|
[2023-08-10T13:56:14+08:00][sql] SELECT * FROM `ls_resource_category` WHERE `id` IN (6,7,10) [ RunTime:0.055173s ]
|
|
[2023-08-10T13:56:15+08:00][sql] CONNECT:[ UseTime:0.062867s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:56:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.044043s ]
|
|
[2023-08-10T13:56:15+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691646975 , `uri` = '/admin/content.Resource/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.042271s ]
|
|
[2023-08-10T13:56:15+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.043971s ]
|
|
[2023-08-10T13:56:15+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.042394s ]
|
|
[2023-08-10T13:57:29+08:00][sql] CONNECT:[ UseTime:0.111935s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:57:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.038730s ]
|
|
[2023-08-10T13:57:29+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691647048 , `uri` = '/admin/content.Help/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.036672s ]
|
|
[2023-08-10T13:57:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.038862s ]
|
|
[2023-08-10T13:57:29+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.037040s ]
|
|
[2023-08-10T13:57:29+08:00][sql] CONNECT:[ UseTime:0.079246s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:57:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.051507s ]
|
|
[2023-08-10T13:57:29+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691647049 , `uri` = '/admin/content.Help/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.045457s ]
|
|
[2023-08-10T13:57:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_help` [ RunTime:0.048125s ]
|
|
[2023-08-10T13:57:29+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_help` WHERE `del` = 0 [ RunTime:0.045592s ]
|
|
[2023-08-10T13:57:29+08:00][sql] SELECT `id`,`cid`,`title`,`image`,`intro`,`content`,`visit`,`likes`,`sort`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help` WHERE `del` = 0 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.046282s ]
|
|
[2023-08-10T13:57:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.055161s ]
|
|
[2023-08-10T13:57:29+08:00][sql] SELECT * FROM `ls_help_category` WHERE `id` IN (5,6,11) [ RunTime:0.065438s ]
|
|
[2023-08-10T13:57:30+08:00][sql] CONNECT:[ UseTime:0.057351s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T13:57:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.040052s ]
|
|
[2023-08-10T13:57:30+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691647050 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.039074s ]
|
|
[2023-08-10T13:57:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.039767s ]
|
|
[2023-08-10T13:57:30+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.038667s ]
|
|
[2023-08-10T14:01:18+08:00][sql] CONNECT:[ UseTime:0.081350s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:01:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.054618s ]
|
|
[2023-08-10T14:01:18+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691647278 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.053602s ]
|
|
[2023-08-10T14:01:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.055598s ]
|
|
[2023-08-10T14:01:18+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.053872s ]
|
|
[2023-08-10T14:03:00+08:00][sql] CONNECT:[ UseTime:0.064333s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:03:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.045308s ]
|
|
[2023-08-10T14:03:00+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691647379 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.045342s ]
|
|
[2023-08-10T14:03:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.049681s ]
|
|
[2023-08-10T14:03:00+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.043030s ]
|
|
[2023-08-10T14:06:31+08:00][sql] CONNECT:[ UseTime:0.062540s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:06:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.084189s ]
|
|
[2023-08-10T14:06:31+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691647591 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.037305s ]
|
|
[2023-08-10T14:06:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.031069s ]
|
|
[2023-08-10T14:06:31+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.029547s ]
|
|
[2023-08-10T14:07:05+08:00][sql] CONNECT:[ UseTime:0.071924s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:07:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.049958s ]
|
|
[2023-08-10T14:07:05+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691647625 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.047657s ]
|
|
[2023-08-10T14:07:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.051409s ]
|
|
[2023-08-10T14:07:05+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.048277s ]
|
|
[2023-08-10T14:09:52+08:00][sql] CONNECT:[ UseTime:0.047952s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:09:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.034257s ]
|
|
[2023-08-10T14:09:52+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691647792 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.034825s ]
|
|
[2023-08-10T14:09:52+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.034425s ]
|
|
[2023-08-10T14:09:52+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.032753s ]
|
|
[2023-08-10T14:12:10+08:00][sql] CONNECT:[ UseTime:0.066816s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.046617s ]
|
|
[2023-08-10T14:12:10+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691647930 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.043631s ]
|
|
[2023-08-10T14:12:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.049091s ]
|
|
[2023-08-10T14:12:10+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.043780s ]
|
|
[2023-08-10T14:13:22+08:00][sql] CONNECT:[ UseTime:0.051146s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:13:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.036067s ]
|
|
[2023-08-10T14:13:22+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691648001 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.035680s ]
|
|
[2023-08-10T14:13:22+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.035810s ]
|
|
[2023-08-10T14:13:22+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.032808s ]
|
|
[2023-08-10T14:14:35+08:00][sql] CONNECT:[ UseTime:0.052842s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:14:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.035180s ]
|
|
[2023-08-10T14:14:35+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691648075 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.033670s ]
|
|
[2023-08-10T14:14:35+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.035464s ]
|
|
[2023-08-10T14:14:35+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.033771s ]
|
|
[2023-08-10T14:15:40+08:00][sql] CONNECT:[ UseTime:0.064215s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:15:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.043458s ]
|
|
[2023-08-10T14:15:40+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691648139 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.042427s ]
|
|
[2023-08-10T14:15:40+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.043274s ]
|
|
[2023-08-10T14:15:40+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.042582s ]
|
|
[2023-08-10T14:18:48+08:00][sql] CONNECT:[ UseTime:0.068713s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:18:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.047547s ]
|
|
[2023-08-10T14:18:48+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691648328 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.045569s ]
|
|
[2023-08-10T14:18:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.047647s ]
|
|
[2023-08-10T14:18:48+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.046427s ]
|
|
[2023-08-10T14:19:26+08:00][sql] CONNECT:[ UseTime:0.048414s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:19:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.031452s ]
|
|
[2023-08-10T14:19:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691648365 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.032399s ]
|
|
[2023-08-10T14:19:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.094912s ]
|
|
[2023-08-10T14:19:26+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.307535s ]
|
|
[2023-08-10T14:21:59+08:00][sql] CONNECT:[ UseTime:0.064087s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:21:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.053771s ]
|
|
[2023-08-10T14:21:59+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691648518 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.042180s ]
|
|
[2023-08-10T14:21:59+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.046376s ]
|
|
[2023-08-10T14:21:59+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.042532s ]
|
|
[2023-08-10T14:22:25+08:00][sql] CONNECT:[ UseTime:0.057806s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:22:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.040949s ]
|
|
[2023-08-10T14:22:25+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691648545 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.044259s ]
|
|
[2023-08-10T14:22:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.049460s ]
|
|
[2023-08-10T14:22:25+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.058494s ]
|
|
[2023-08-10T14:23:03+08:00][sql] CONNECT:[ UseTime:0.077944s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:23:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.053806s ]
|
|
[2023-08-10T14:23:03+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691648582 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.051820s ]
|
|
[2023-08-10T14:23:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.054255s ]
|
|
[2023-08-10T14:23:03+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.052615s ]
|
|
[2023-08-10T14:24:34+08:00][sql] CONNECT:[ UseTime:0.060623s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:24:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.041700s ]
|
|
[2023-08-10T14:24:34+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691648673 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.040190s ]
|
|
[2023-08-10T14:24:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.041842s ]
|
|
[2023-08-10T14:24:34+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.041146s ]
|
|
[2023-08-10T14:27:39+08:00][sql] CONNECT:[ UseTime:0.085709s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:27:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.064422s ]
|
|
[2023-08-10T14:27:39+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691648859 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.062891s ]
|
|
[2023-08-10T14:27:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.076311s ]
|
|
[2023-08-10T14:27:39+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.101124s ]
|
|
[2023-08-10T14:31:00+08:00][sql] CONNECT:[ UseTime:0.075781s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:31:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.049393s ]
|
|
[2023-08-10T14:31:00+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691649060 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.047673s ]
|
|
[2023-08-10T14:31:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.050072s ]
|
|
[2023-08-10T14:31:00+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.048158s ]
|
|
[2023-08-10T14:32:41+08:00][sql] CONNECT:[ UseTime:0.068808s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:32:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.046743s ]
|
|
[2023-08-10T14:32:41+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691649161 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.044493s ]
|
|
[2023-08-10T14:32:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.047597s ]
|
|
[2023-08-10T14:32:41+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.045800s ]
|
|
[2023-08-10T14:33:34+08:00][sql] CONNECT:[ UseTime:0.077448s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-08-10T14:33:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.058703s ]
|
|
[2023-08-10T14:33:34+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1691649213 , `uri` = '/admin/content.Help/add.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Help\\/add_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.051335s ]
|
|
[2023-08-10T14:33:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_help_category` [ RunTime:0.053445s ]
|
|
[2023-08-10T14:33:34+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_help_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.051568s ]
|
|
|