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.
498 lines
80 KiB
498 lines
80 KiB
[2023-07-05T13:38:21+08:00][error] [10501]SQLSTATE[HY000] [2002] 由于目标计算机积极拒绝，无法连接。
|
|
[E:\waibao\ahbcqz\server\vendor\topthink\think-orm\src\db\PDOConnection.php:768]
|
|
[2023-07-05T13:38:29+08:00][error] [10501]SQLSTATE[HY000] [2002] 由于目标计算机积极拒绝，无法连接。
|
|
[E:\waibao\ahbcqz\server\vendor\topthink\think-orm\src\db\PDOConnection.php:768]
|
|
[2023-07-05T13:39:10+08:00][error] [10501]SQLSTATE[HY000] [1045] Access denied for user 'root'@'61.190.32.52' (using password: YES)[E:\waibao\ahbcqz\server\vendor\topthink\think-orm\src\db\PDOConnection.php:768]
|
|
[2023-07-05T13:39:28+08:00][error] [10501]SQLSTATE[HY000] [1045] Access denied for user 'root'@'61.190.32.52' (using password: YES)[E:\waibao\ahbcqz\server\vendor\topthink\think-orm\src\db\PDOConnection.php:768]
|
|
[2023-07-05T13:40:26+08:00][sql] CONNECT:[ UseTime:0.071079s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:40:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.049389s ]
|
|
[2023-07-05T13:40:26+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.051244s ]
|
|
[2023-07-05T13:40:26+08:00][sql] SELECT `id`,`account`,`name`,`role_id` FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.047321s ]
|
|
[2023-07-05T13:40:26+08:00][sql] UPDATE `ls_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1688535626 WHERE `account` = 'admin' [ RunTime:0.049865s ]
|
|
[2023-07-05T13:40:28+08:00][sql] CONNECT:[ UseTime:0.045358s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:40:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.031467s ]
|
|
[2023-07-05T13:40:28+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688535628 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.029951s ]
|
|
[2023-07-05T13:40:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.031362s ]
|
|
[2023-07-05T13:40:28+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.031748s ]
|
|
[2023-07-05T13:40:28+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.032381s ]
|
|
[2023-07-05T13:40:28+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.029173s ]
|
|
[2023-07-05T13:40:30+08:00][sql] CONNECT:[ UseTime:0.101250s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:40:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.061553s ]
|
|
[2023-07-05T13:40:30+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688535628 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.059216s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.062546s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.059697s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1688400000 AND 1688486399 [ RunTime:0.059890s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1688486400 AND 1688572799 [ RunTime:0.060185s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.061947s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1688400000 AND 1688486399 [ RunTime:0.062607s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1688486400 AND 1688572799 [ RunTime:0.059950s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.063821s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.059301s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1688400000 AND 1688486399 [ RunTime:0.069984s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1688486400 AND 1688572799 [ RunTime:0.059455s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.076859s ]
|
|
[2023-07-05T13:40:30+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.087022s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688400000 AND 1688486399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.076330s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688486400 AND 1688572799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.085474s ]
|
|
[2023-07-05T13:40:30+08:00][sql] CONNECT:[ UseTime:0.071690s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:40:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.054774s ]
|
|
[2023-07-05T13:40:30+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688535630 , `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.050497s ]
|
|
[2023-07-05T13:40:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.064330s ]
|
|
[2023-07-05T13:40:30+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.043865s ]
|
|
[2023-07-05T13:40:31+08:00][sql] CONNECT:[ UseTime:0.093179s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:40:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.055199s ]
|
|
[2023-07-05T13:40:31+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688535630 , `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.051106s ]
|
|
[2023-07-05T13:40:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.069181s ]
|
|
[2023-07-05T13:40:31+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.050992s ]
|
|
[2023-07-05T13:40:32+08:00][sql] CONNECT:[ UseTime:0.048549s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:40:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.044209s ]
|
|
[2023-07-05T13:40:32+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688535630 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.042470s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.037920s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687190400 AND 1687276799 AND `pay_status` > 0 [ RunTime:0.029653s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.042380s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687190400 AND 1687276799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052563s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687276800 AND 1687363199 AND `pay_status` > 0 [ RunTime:0.032454s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687276800 AND 1687363199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.032081s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687363200 AND 1687449599 AND `pay_status` > 0 [ RunTime:0.048432s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687363200 AND 1687449599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.060845s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687449600 AND 1687535999 AND `pay_status` > 0 [ RunTime:0.053262s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687449600 AND 1687535999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.046994s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687536000 AND 1687622399 AND `pay_status` > 0 [ RunTime:0.030190s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687536000 AND 1687622399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052907s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687622400 AND 1687708799 AND `pay_status` > 0 [ RunTime:0.037628s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687622400 AND 1687708799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.040072s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687708800 AND 1687795199 AND `pay_status` > 0 [ RunTime:0.045823s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687708800 AND 1687795199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.038835s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687795200 AND 1687881599 AND `pay_status` > 0 [ RunTime:0.034214s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687795200 AND 1687881599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.032495s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687881600 AND 1687967999 AND `pay_status` > 0 [ RunTime:0.030671s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687881600 AND 1687967999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.032532s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687968000 AND 1688054399 AND `pay_status` > 0 [ RunTime:0.036247s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687968000 AND 1688054399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.034708s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688054400 AND 1688140799 AND `pay_status` > 0 [ RunTime:0.047817s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688054400 AND 1688140799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.033998s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688140800 AND 1688227199 AND `pay_status` > 0 [ RunTime:0.042316s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688140800 AND 1688227199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.030195s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688227200 AND 1688313599 AND `pay_status` > 0 [ RunTime:0.030722s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688227200 AND 1688313599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.041667s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688313600 AND 1688399999 AND `pay_status` > 0 [ RunTime:0.030603s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688313600 AND 1688399999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.030232s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688400000 AND 1688486399 AND `pay_status` > 0 [ RunTime:0.030039s ]
|
|
[2023-07-05T13:40:32+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688400000 AND 1688486399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.050046s ]
|
|
[2023-07-05T13:40:32+08:00][sql] CONNECT:[ UseTime:0.044836s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:40:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.033533s ]
|
|
[2023-07-05T13:40:32+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688535632 , `uri` = '/admin/setting.CustomerService/index.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/setting_CustomerService\\/index_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.031958s ]
|
|
[2023-07-05T13:43:50+08:00][sql] CONNECT:[ UseTime:0.065136s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:43:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.043545s ]
|
|
[2023-07-05T13:43:50+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688535830 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.042011s ]
|
|
[2023-07-05T13:43:51+08:00][sql] CONNECT:[ UseTime:0.099481s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:43:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.069050s ]
|
|
[2023-07-05T13:43:51+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688535830 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.066466s ]
|
|
[2023-07-05T13:43:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.068200s ]
|
|
[2023-07-05T13:43:51+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 [ RunTime:0.066153s ]
|
|
[2023-07-05T13:43:51+08:00][sql] SELECT `a`.*,`u`.`nickname`,`u`.`avatar`,`u`.`sn` FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.067111s ]
|
|
[2023-07-05T13:43:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.069488s ]
|
|
[2023-07-05T13:43:51+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` IN (10,9,8,7,6,5,3) [ RunTime:0.067754s ]
|
|
[2023-07-05T13:43:51+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_category` [ RunTime:0.069444s ]
|
|
[2023-07-05T13:43:51+08:00][sql] SELECT * FROM `ls_community_category` WHERE `id` IN (8,5,4,1,10) [ RunTime:0.067141s ]
|
|
[2023-07-05T13:44:32+08:00][sql] CONNECT:[ UseTime:0.089646s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:44:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.056948s ]
|
|
[2023-07-05T13:44:32+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688535872 , `uri` = '/admin/setting.Basic/website.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/setting_Basic\\/website_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.054858s ]
|
|
[2023-07-05T13:44:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.058231s ]
|
|
[2023-07-05T13:44:32+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'website_platform' AND `name` = 'platform_contact' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.053119s ]
|
|
[2023-07-05T13:44:32+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'website_platform' AND `name` = 'platform_mobile' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.055838s ]
|
|
[2023-07-05T13:44:36+08:00][sql] CONNECT:[ UseTime:0.075794s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:44:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.052365s ]
|
|
[2023-07-05T13:44:36+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688535875 , `uri` = '/admin/setting.StorageConfig/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/setting_StorageConfig\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.052202s ]
|
|
[2023-07-05T13:44:36+08:00][sql] CONNECT:[ UseTime:0.102137s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:44:36+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.063294s ]
|
|
[2023-07-05T13:44:36+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688535876 , `uri` = '/admin/setting.StorageConfig/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/setting_StorageConfig\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.061736s ]
|
|
[2023-07-05T13:44:42+08:00][sql] CONNECT:[ UseTime:0.061863s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:44:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.048746s ]
|
|
[2023-07-05T13:44:42+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688535881 , `uri` = '/admin/setting.StorageConfig/changeEngine.html' , `type` = 'POST' , `param` = '{\"\\/admin\\/setting_StorageConfig\\/changeEngine_html\":\"\",\"engine\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.041241s ]
|
|
[2023-07-05T13:44:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.042133s ]
|
|
[2023-07-05T13:44:42+08:00][sql] SELECT * FROM `ls_config` WHERE `type` = 'storage' AND `name` = 'default' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.040753s ]
|
|
[2023-07-05T13:44:42+08:00][sql] UPDATE `ls_config` SET `value` = '' , `update_time` = 1688535882 WHERE `type` = 'storage' AND `name` = 'default' AND `shop_id` = 0 [ RunTime:0.045658s ]
|
|
[2023-07-05T13:44:42+08:00][sql] CONNECT:[ UseTime:0.080637s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:44:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.054934s ]
|
|
[2023-07-05T13:44:42+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'storage' AND `name` = 'default' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.056399s ]
|
|
[2023-07-05T13:44:42+08:00][sql] SELECT `name`,`value` FROM `ls_config` WHERE `type` = 'storage_engine' AND `shop_id` = 0 [ RunTime:0.053443s ]
|
|
[2023-07-05T13:44:42+08:00][error] [8]鏈�畾涔夋暟缁勭储寮�: domain[E:\waibao\ahbcqz\server\app\common\server\UrlServer.php:51]
|
|
[2023-07-05T13:44:45+08:00][error] [8]鏈�畾涔夋暟缁勭储寮�: domain[E:\waibao\ahbcqz\server\app\common\server\UrlServer.php:51]
|
|
[2023-07-05T13:44:49+08:00][error] [8]鏈�畾涔夋暟缁勭储寮�: domain[E:\waibao\ahbcqz\server\app\common\server\UrlServer.php:51]
|
|
[2023-07-05T13:49:31+08:00][error] [8]鏈�畾涔夋暟缁勭储寮�: domain[E:\waibao\ahbcqz\server\app\common\server\UrlServer.php:53]
|
|
[2023-07-05T13:56:02+08:00][sql] CONNECT:[ UseTime:0.126670s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:56:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.064316s ]
|
|
[2023-07-05T13:56:02+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536561 , `uri` = '/admin/index/index.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/index_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.040704s ]
|
|
[2023-07-05T13:56:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.044044s ]
|
|
[2023-07-05T13:56:02+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.054038s ]
|
|
[2023-07-05T13:56:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.042033s ]
|
|
[2023-07-05T13:56:02+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.052004s ]
|
|
[2023-07-05T13:56:03+08:00][sql] CONNECT:[ UseTime:0.084708s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:56:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.041006s ]
|
|
[2023-07-05T13:56:03+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536562 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.043795s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.041152s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.038756s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1688400000 AND 1688486399 [ RunTime:0.040948s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1688486400 AND 1688572799 [ RunTime:0.042176s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.036581s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1688400000 AND 1688486399 [ RunTime:0.037108s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1688486400 AND 1688572799 [ RunTime:0.036884s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.038656s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.036360s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1688400000 AND 1688486399 [ RunTime:0.036684s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1688486400 AND 1688572799 [ RunTime:0.037281s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.038640s ]
|
|
[2023-07-05T13:56:03+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.037053s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688400000 AND 1688486399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.037086s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688486400 AND 1688572799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.037439s ]
|
|
[2023-07-05T13:56:03+08:00][sql] CONNECT:[ UseTime:0.081330s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:56:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.055300s ]
|
|
[2023-07-05T13:56:03+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536563 , `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.065838s ]
|
|
[2023-07-05T13:56:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.072924s ]
|
|
[2023-07-05T13:56:03+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.067161s ]
|
|
[2023-07-05T13:56:04+08:00][sql] CONNECT:[ UseTime:0.083340s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:56:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.057378s ]
|
|
[2023-07-05T13:56:04+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536563 , `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.058780s ]
|
|
[2023-07-05T13:56:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.071273s ]
|
|
[2023-07-05T13:56:04+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.070912s ]
|
|
[2023-07-05T13:56:05+08:00][sql] CONNECT:[ UseTime:0.065631s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:56:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.044876s ]
|
|
[2023-07-05T13:56:05+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536563 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.043739s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.053101s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687190400 AND 1687276799 AND `pay_status` > 0 [ RunTime:0.043163s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.060237s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687190400 AND 1687276799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.056515s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687276800 AND 1687363199 AND `pay_status` > 0 [ RunTime:0.042934s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687276800 AND 1687363199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.042965s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687363200 AND 1687449599 AND `pay_status` > 0 [ RunTime:0.065148s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687363200 AND 1687449599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.043302s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687449600 AND 1687535999 AND `pay_status` > 0 [ RunTime:0.043146s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687449600 AND 1687535999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.043116s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687536000 AND 1687622399 AND `pay_status` > 0 [ RunTime:0.043630s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687536000 AND 1687622399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.046977s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687622400 AND 1687708799 AND `pay_status` > 0 [ RunTime:0.062979s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687622400 AND 1687708799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.047052s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687708800 AND 1687795199 AND `pay_status` > 0 [ RunTime:0.063534s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687708800 AND 1687795199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.072960s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687795200 AND 1687881599 AND `pay_status` > 0 [ RunTime:0.100819s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687795200 AND 1687881599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.074016s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687881600 AND 1687967999 AND `pay_status` > 0 [ RunTime:0.075466s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687881600 AND 1687967999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.070649s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687968000 AND 1688054399 AND `pay_status` > 0 [ RunTime:0.046589s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687968000 AND 1688054399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.058074s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688054400 AND 1688140799 AND `pay_status` > 0 [ RunTime:0.043340s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688054400 AND 1688140799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.048664s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688140800 AND 1688227199 AND `pay_status` > 0 [ RunTime:0.045844s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688140800 AND 1688227199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.046454s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688227200 AND 1688313599 AND `pay_status` > 0 [ RunTime:0.043522s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688227200 AND 1688313599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.043860s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688313600 AND 1688399999 AND `pay_status` > 0 [ RunTime:0.043347s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688313600 AND 1688399999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.043300s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688400000 AND 1688486399 AND `pay_status` > 0 [ RunTime:0.044104s ]
|
|
[2023-07-05T13:56:05+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688400000 AND 1688486399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.042990s ]
|
|
[2023-07-05T13:56:07+08:00][sql] CONNECT:[ UseTime:0.121367s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:56:07+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.055249s ]
|
|
[2023-07-05T13:56:07+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536566 , `uri` = '/admin/setting.CustomerService/index.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/setting_CustomerService\\/index_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.067305s ]
|
|
[2023-07-05T13:56:11+08:00][sql] CONNECT:[ UseTime:0.067085s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:56:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.045453s ]
|
|
[2023-07-05T13:56:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536571 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.044023s ]
|
|
[2023-07-05T13:56:12+08:00][sql] CONNECT:[ UseTime:0.085108s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:56:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.078378s ]
|
|
[2023-07-05T13:56:12+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536571 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.069322s ]
|
|
[2023-07-05T13:56:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.086693s ]
|
|
[2023-07-05T13:56:12+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 [ RunTime:0.052689s ]
|
|
[2023-07-05T13:56:12+08:00][sql] SELECT `a`.*,`u`.`nickname`,`u`.`avatar`,`u`.`sn` FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.053052s ]
|
|
[2023-07-05T13:56:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.054490s ]
|
|
[2023-07-05T13:56:12+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` IN (10,9,8,7,6,5,3) [ RunTime:0.052878s ]
|
|
[2023-07-05T13:56:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_category` [ RunTime:0.053801s ]
|
|
[2023-07-05T13:56:12+08:00][sql] SELECT * FROM `ls_community_category` WHERE `id` IN (8,5,4,1,10) [ RunTime:0.052948s ]
|
|
[2023-07-05T13:56:25+08:00][sql] CONNECT:[ UseTime:0.052549s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:56:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.043525s ]
|
|
[2023-07-05T13:56:25+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536584 , `uri` = '/admin/community.CommunityArticle/detail.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/detail_html\":\"\",\"id\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.032505s ]
|
|
[2023-07-05T13:56:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.035606s ]
|
|
[2023-07-05T13:56:25+08:00][sql] SELECT * FROM `ls_community_article` WHERE `id` = 10 LIMIT 1 [ RunTime:0.033286s ]
|
|
[2023-07-05T13:56:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.034884s ]
|
|
[2023-07-05T13:56:25+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` = 10 [ RunTime:0.033280s ]
|
|
[2023-07-05T13:56:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_topic` [ RunTime:0.034871s ]
|
|
[2023-07-05T13:56:25+08:00][sql] SELECT * FROM `ls_community_topic` WHERE `id` = 0 [ RunTime:0.033023s ]
|
|
[2023-07-05T13:56:25+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.034274s ]
|
|
[2023-07-05T13:56:25+08:00][sql] SELECT `id`,`nickname`,`sn` FROM `ls_user` WHERE `id` = 6 [ RunTime:0.032250s ]
|
|
[2023-07-05T13:56:26+08:00][sql] CONNECT:[ UseTime:0.105314s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:56:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.075655s ]
|
|
[2023-07-05T13:56:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536585 , `uri` = '/admin/community.CommunityArticle/detail.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/detail_html\":\"\",\"type\":\"comment\",\"id\":\"10\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.066390s ]
|
|
[2023-07-05T13:56:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_comment` [ RunTime:0.069406s ]
|
|
[2023-07-05T13:56:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_comment` WHERE `del` = 0 AND `article_id` = 10 [ RunTime:0.079170s ]
|
|
[2023-07-05T13:56:26+08:00][sql] SELECT * FROM `ls_community_comment` WHERE `del` = 0 AND `article_id` = 10 LIMIT 0,10 [ RunTime:0.072294s ]
|
|
[2023-07-05T13:56:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.068499s ]
|
|
[2023-07-05T13:56:26+08:00][sql] SELECT * FROM `ls_user` WHERE `id` = 4 [ RunTime:0.066644s ]
|
|
[2023-07-05T13:57:42+08:00][sql] CONNECT:[ UseTime:0.065550s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:57:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.045631s ]
|
|
[2023-07-05T13:57:42+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536662 , `uri` = '/admin/index/index.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/index_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.043976s ]
|
|
[2023-07-05T13:57:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.045767s ]
|
|
[2023-07-05T13:57:42+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.050624s ]
|
|
[2023-07-05T13:57:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.049641s ]
|
|
[2023-07-05T13:57:42+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.042827s ]
|
|
[2023-07-05T13:57:44+08:00][sql] CONNECT:[ UseTime:0.063441s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:57:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.045594s ]
|
|
[2023-07-05T13:57:44+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536663 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.044283s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.046880s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.044337s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1688400000 AND 1688486399 [ RunTime:0.042218s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1688486400 AND 1688572799 [ RunTime:0.050551s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.044594s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1688400000 AND 1688486399 [ RunTime:0.069621s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1688486400 AND 1688572799 [ RunTime:0.043395s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.045066s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.042778s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1688400000 AND 1688486399 [ RunTime:0.043189s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1688486400 AND 1688572799 [ RunTime:0.043085s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.042859s ]
|
|
[2023-07-05T13:57:44+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.041731s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688400000 AND 1688486399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.042665s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688486400 AND 1688572799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.043440s ]
|
|
[2023-07-05T13:57:44+08:00][sql] CONNECT:[ UseTime:0.090619s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:57:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.040969s ]
|
|
[2023-07-05T13:57:44+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536664 , `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.047994s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.040581s ]
|
|
[2023-07-05T13:57:44+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.039274s ]
|
|
[2023-07-05T13:57:44+08:00][sql] CONNECT:[ UseTime:0.100635s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:57:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.043300s ]
|
|
[2023-07-05T13:57:44+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536664 , `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.041732s ]
|
|
[2023-07-05T13:57:44+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.046972s ]
|
|
[2023-07-05T13:57:44+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.041670s ]
|
|
[2023-07-05T13:57:46+08:00][sql] CONNECT:[ UseTime:0.099816s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:57:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.043857s ]
|
|
[2023-07-05T13:57:46+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536664 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.045586s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.050818s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687190400 AND 1687276799 AND `pay_status` > 0 [ RunTime:0.040396s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.041742s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687190400 AND 1687276799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.041851s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687276800 AND 1687363199 AND `pay_status` > 0 [ RunTime:0.041889s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687276800 AND 1687363199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.039975s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687363200 AND 1687449599 AND `pay_status` > 0 [ RunTime:0.043978s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687363200 AND 1687449599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.041919s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687449600 AND 1687535999 AND `pay_status` > 0 [ RunTime:0.046599s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687449600 AND 1687535999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.043957s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687536000 AND 1687622399 AND `pay_status` > 0 [ RunTime:0.041006s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687536000 AND 1687622399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.043520s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687622400 AND 1687708799 AND `pay_status` > 0 [ RunTime:0.044471s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687622400 AND 1687708799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.041164s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687708800 AND 1687795199 AND `pay_status` > 0 [ RunTime:0.046246s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687708800 AND 1687795199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.097627s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687795200 AND 1687881599 AND `pay_status` > 0 [ RunTime:0.106493s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687795200 AND 1687881599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.080004s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687881600 AND 1687967999 AND `pay_status` > 0 [ RunTime:0.100088s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687881600 AND 1687967999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.066999s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1687968000 AND 1688054399 AND `pay_status` > 0 [ RunTime:0.049771s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1687968000 AND 1688054399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.046546s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688054400 AND 1688140799 AND `pay_status` > 0 [ RunTime:0.052331s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688054400 AND 1688140799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.045906s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688140800 AND 1688227199 AND `pay_status` > 0 [ RunTime:0.043758s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688140800 AND 1688227199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.041166s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688227200 AND 1688313599 AND `pay_status` > 0 [ RunTime:0.042189s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688227200 AND 1688313599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.040810s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688313600 AND 1688399999 AND `pay_status` > 0 [ RunTime:0.042075s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688313600 AND 1688399999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.052989s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1688400000 AND 1688486399 AND `pay_status` > 0 [ RunTime:0.056790s ]
|
|
[2023-07-05T13:57:46+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1688400000 AND 1688486399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.051896s ]
|
|
[2023-07-05T13:57:46+08:00][sql] CONNECT:[ UseTime:0.085254s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:57:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.054607s ]
|
|
[2023-07-05T13:57:46+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536666 , `uri` = '/admin/setting.CustomerService/index.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/setting_CustomerService\\/index_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.062265s ]
|
|
[2023-07-05T13:57:48+08:00][sql] CONNECT:[ UseTime:0.064037s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:57:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.048126s ]
|
|
[2023-07-05T13:57:48+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536668 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.047714s ]
|
|
[2023-07-05T13:57:49+08:00][sql] CONNECT:[ UseTime:0.056055s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:57:49+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.040878s ]
|
|
[2023-07-05T13:57:49+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536669 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.037032s ]
|
|
[2023-07-05T13:57:49+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.041144s ]
|
|
[2023-07-05T13:57:49+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 [ RunTime:0.038988s ]
|
|
[2023-07-05T13:57:49+08:00][sql] SELECT `a`.*,`u`.`nickname`,`u`.`avatar`,`u`.`sn` FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.038874s ]
|
|
[2023-07-05T13:57:49+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.041520s ]
|
|
[2023-07-05T13:57:49+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` IN (10,9,8,7,6,5,3) [ RunTime:0.042197s ]
|
|
[2023-07-05T13:57:49+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_category` [ RunTime:0.038631s ]
|
|
[2023-07-05T13:57:49+08:00][sql] SELECT * FROM `ls_community_category` WHERE `id` IN (8,5,4,1,10) [ RunTime:0.039798s ]
|
|
[2023-07-05T13:57:58+08:00][sql] CONNECT:[ UseTime:0.052326s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:57:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.036400s ]
|
|
[2023-07-05T13:57:58+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536678 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\",\"keyword\":\"\",\"content\":\"\",\"status\":\"\",\"start_time\":\"\",\"end_time\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.045965s ]
|
|
[2023-07-05T13:57:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.040696s ]
|
|
[2023-07-05T13:57:58+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 [ RunTime:0.030897s ]
|
|
[2023-07-05T13:57:58+08:00][sql] SELECT `a`.*,`u`.`nickname`,`u`.`avatar`,`u`.`sn` FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.036392s ]
|
|
[2023-07-05T13:57:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.034745s ]
|
|
[2023-07-05T13:57:58+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` IN (10,9,8,7,6,5,3) [ RunTime:0.036205s ]
|
|
[2023-07-05T13:57:58+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_category` [ RunTime:0.032558s ]
|
|
[2023-07-05T13:57:58+08:00][sql] SELECT * FROM `ls_community_category` WHERE `id` IN (8,5,4,1,10) [ RunTime:0.030164s ]
|
|
[2023-07-05T13:58:03+08:00][sql] CONNECT:[ UseTime:0.083904s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:58:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.058129s ]
|
|
[2023-07-05T13:58:03+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536683 , `uri` = '/admin/community.CommunityComment/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityComment\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.056940s ]
|
|
[2023-07-05T13:58:04+08:00][sql] CONNECT:[ UseTime:0.044401s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:58:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.032295s ]
|
|
[2023-07-05T13:58:04+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536683 , `uri` = '/admin/community.CommunityComment/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityComment\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.029764s ]
|
|
[2023-07-05T13:58:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_comment` [ RunTime:0.031927s ]
|
|
[2023-07-05T13:58:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_comment` `c` INNER JOIN `ls_user` `u` ON `u`.`id`=`c`.`user_id` WHERE `c`.`del` = 0 [ RunTime:0.029291s ]
|
|
[2023-07-05T13:58:04+08:00][sql] SELECT `c`.*,`u`.`nickname`,`u`.`avatar`,`u`.`sn` FROM `ls_community_comment` `c` INNER JOIN `ls_user` `u` ON `u`.`id`=`c`.`user_id` WHERE `c`.`del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.033596s ]
|
|
[2023-07-05T13:58:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.032409s ]
|
|
[2023-07-05T13:58:04+08:00][sql] SELECT `id`,`content`,`topic_id` FROM `ls_community_article` WHERE `id` IN (8,10) [ RunTime:0.029582s ]
|
|
[2023-07-05T13:58:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_topic` [ RunTime:0.031234s ]
|
|
[2023-07-05T13:58:04+08:00][sql] SELECT * FROM `ls_community_topic` WHERE `id` = 0 LIMIT 1 [ RunTime:0.029943s ]
|
|
[2023-07-05T13:58:04+08:00][sql] SELECT * FROM `ls_community_topic` WHERE `id` = 0 LIMIT 1 [ RunTime:0.029774s ]
|
|
[2023-07-05T13:58:05+08:00][sql] CONNECT:[ UseTime:0.070015s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:58:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.048852s ]
|
|
[2023-07-05T13:58:05+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536685 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.047343s ]
|
|
[2023-07-05T13:58:06+08:00][sql] CONNECT:[ UseTime:0.070160s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:58:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.056802s ]
|
|
[2023-07-05T13:58:06+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536685 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.045307s ]
|
|
[2023-07-05T13:58:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.048042s ]
|
|
[2023-07-05T13:58:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 [ RunTime:0.048060s ]
|
|
[2023-07-05T13:58:06+08:00][sql] SELECT `a`.*,`u`.`nickname`,`u`.`avatar`,`u`.`sn` FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.058045s ]
|
|
[2023-07-05T13:58:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.048079s ]
|
|
[2023-07-05T13:58:06+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` IN (10,9,8,7,6,5,3) [ RunTime:0.045748s ]
|
|
[2023-07-05T13:58:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_category` [ RunTime:0.049177s ]
|
|
[2023-07-05T13:58:06+08:00][sql] SELECT * FROM `ls_community_category` WHERE `id` IN (8,5,4,1,10) [ RunTime:0.061465s ]
|
|
[2023-07-05T13:58:29+08:00][sql] CONNECT:[ UseTime:0.043849s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:58:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.032942s ]
|
|
[2023-07-05T13:58:29+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536709 , `uri` = '/admin/community.CommunityArticle/detail.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/detail_html\":\"\",\"id\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.031009s ]
|
|
[2023-07-05T13:58:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.042348s ]
|
|
[2023-07-05T13:58:29+08:00][sql] SELECT * FROM `ls_community_article` WHERE `id` = 10 LIMIT 1 [ RunTime:0.030138s ]
|
|
[2023-07-05T13:58:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.033438s ]
|
|
[2023-07-05T13:58:29+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` = 10 [ RunTime:0.029651s ]
|
|
[2023-07-05T13:58:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_topic` [ RunTime:0.032217s ]
|
|
[2023-07-05T13:58:29+08:00][sql] SELECT * FROM `ls_community_topic` WHERE `id` = 0 [ RunTime:0.030276s ]
|
|
[2023-07-05T13:58:29+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.033607s ]
|
|
[2023-07-05T13:58:29+08:00][sql] SELECT `id`,`nickname`,`sn` FROM `ls_user` WHERE `id` = 6 [ RunTime:0.029329s ]
|
|
[2023-07-05T13:58:30+08:00][sql] CONNECT:[ UseTime:0.068557s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:58:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.057258s ]
|
|
[2023-07-05T13:58:30+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536709 , `uri` = '/admin/community.CommunityArticle/detail.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/detail_html\":\"\",\"type\":\"comment\",\"id\":\"10\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.092589s ]
|
|
[2023-07-05T13:58:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_comment` [ RunTime:0.084037s ]
|
|
[2023-07-05T13:58:30+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_comment` WHERE `del` = 0 AND `article_id` = 10 [ RunTime:0.041994s ]
|
|
[2023-07-05T13:58:30+08:00][sql] SELECT * FROM `ls_community_comment` WHERE `del` = 0 AND `article_id` = 10 LIMIT 0,10 [ RunTime:0.043761s ]
|
|
[2023-07-05T13:58:30+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.044407s ]
|
|
[2023-07-05T13:58:30+08:00][sql] SELECT * FROM `ls_user` WHERE `id` = 4 [ RunTime:0.057443s ]
|
|
[2023-07-05T13:58:50+08:00][sql] CONNECT:[ UseTime:0.124047s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:58:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.107152s ]
|
|
[2023-07-05T13:58:50+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536729 , `uri` = '/admin/community.CommunityArticle/detail.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/detail_html\":\"\",\"id\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.093300s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.066879s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SELECT * FROM `ls_community_article` WHERE `id` = 10 LIMIT 1 [ RunTime:0.084195s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.038758s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` = 10 [ RunTime:0.052367s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_topic` [ RunTime:0.037726s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SELECT * FROM `ls_community_topic` WHERE `id` = 0 [ RunTime:0.035968s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.036175s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SELECT `id`,`nickname`,`sn` FROM `ls_user` WHERE `id` = 6 [ RunTime:0.034147s ]
|
|
[2023-07-05T13:58:50+08:00][sql] CONNECT:[ UseTime:0.073525s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:58:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.050798s ]
|
|
[2023-07-05T13:58:50+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536730 , `uri` = '/admin/community.CommunityArticle/detail.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/detail_html\":\"\",\"type\":\"comment\",\"id\":\"10\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.049949s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_comment` [ RunTime:0.053163s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_comment` WHERE `del` = 0 AND `article_id` = 10 [ RunTime:0.048374s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SELECT * FROM `ls_community_comment` WHERE `del` = 0 AND `article_id` = 10 LIMIT 0,10 [ RunTime:0.072438s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.057212s ]
|
|
[2023-07-05T13:58:50+08:00][sql] SELECT * FROM `ls_user` WHERE `id` = 4 [ RunTime:0.062937s ]
|
|
[2023-07-05T13:59:08+08:00][sql] CONNECT:[ UseTime:0.071041s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:59:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.049193s ]
|
|
[2023-07-05T13:59:08+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536748 , `uri` = '/admin/community.CommunityArticle/detail.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/detail_html\":\"\",\"id\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.047289s ]
|
|
[2023-07-05T13:59:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.049300s ]
|
|
[2023-07-05T13:59:08+08:00][sql] SELECT * FROM `ls_community_article` WHERE `id` = 10 LIMIT 1 [ RunTime:0.048309s ]
|
|
[2023-07-05T13:59:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.048464s ]
|
|
[2023-07-05T13:59:08+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` = 10 [ RunTime:0.047539s ]
|
|
[2023-07-05T13:59:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_topic` [ RunTime:0.048977s ]
|
|
[2023-07-05T13:59:08+08:00][sql] SELECT * FROM `ls_community_topic` WHERE `id` = 0 [ RunTime:0.047534s ]
|
|
[2023-07-05T13:59:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.060402s ]
|
|
[2023-07-05T13:59:08+08:00][sql] SELECT `id`,`nickname`,`sn` FROM `ls_user` WHERE `id` = 6 [ RunTime:0.047095s ]
|
|
[2023-07-05T13:59:09+08:00][sql] CONNECT:[ UseTime:0.078832s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T13:59:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.046890s ]
|
|
[2023-07-05T13:59:09+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688536748 , `uri` = '/admin/community.CommunityArticle/detail.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/detail_html\":\"\",\"type\":\"comment\",\"id\":\"10\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.044298s ]
|
|
[2023-07-05T13:59:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_comment` [ RunTime:0.045361s ]
|
|
[2023-07-05T13:59:09+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_comment` WHERE `del` = 0 AND `article_id` = 10 [ RunTime:0.043899s ]
|
|
[2023-07-05T13:59:09+08:00][sql] SELECT * FROM `ls_community_comment` WHERE `del` = 0 AND `article_id` = 10 LIMIT 0,10 [ RunTime:0.044005s ]
|
|
[2023-07-05T13:59:09+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.045564s ]
|
|
[2023-07-05T13:59:09+08:00][sql] SELECT * FROM `ls_user` WHERE `id` = 4 [ RunTime:0.044147s ]
|
|
[2023-07-05T15:05:10+08:00][sql] CONNECT:[ UseTime:0.052579s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T15:05:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.035446s ]
|
|
[2023-07-05T15:05:10+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688540709 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\",\"keyword\":\"\",\"content\":\"\",\"status\":\"\",\"start_time\":\"\",\"end_time\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.033028s ]
|
|
[2023-07-05T15:05:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.048578s ]
|
|
[2023-07-05T15:05:10+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 [ RunTime:0.032324s ]
|
|
[2023-07-05T15:05:10+08:00][sql] SELECT `a`.*,`u`.`nickname`,`u`.`avatar`,`u`.`sn` FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.046339s ]
|
|
[2023-07-05T15:05:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.050060s ]
|
|
[2023-07-05T15:05:10+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` IN (11,10,9,8,7,6,5,3) [ RunTime:0.057695s ]
|
|
[2023-07-05T15:05:10+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_category` [ RunTime:0.035192s ]
|
|
[2023-07-05T15:05:10+08:00][sql] SELECT * FROM `ls_community_category` WHERE `id` IN (1,8,5,4,10) [ RunTime:0.035751s ]
|
|
[2023-07-05T15:05:18+08:00][sql] CONNECT:[ UseTime:0.052695s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T15:05:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.038302s ]
|
|
[2023-07-05T15:05:18+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688540717 , `uri` = '/admin/community.CommunitySetting/setting.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunitySetting\\/setting_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.034889s ]
|
|
[2023-07-05T15:05:18+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.038384s ]
|
|
[2023-07-05T15:05:18+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'community' AND `name` = 'audit_comment' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.039187s ]
|
|
[2023-07-05T15:05:27+08:00][sql] CONNECT:[ UseTime:0.091114s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T15:05:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.057865s ]
|
|
[2023-07-05T15:05:27+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688540726 , `uri` = '/admin/community.CommunityArticle/audit.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/audit_html\":\"\",\"id\":\"11\"}' , `ip` = '127.0.0.1' [ RunTime:0.074084s ]
|
|
[2023-07-05T15:05:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.074638s ]
|
|
[2023-07-05T15:05:27+08:00][sql] SELECT * FROM `ls_community_article` WHERE `id` = 11 LIMIT 1 [ RunTime:0.055096s ]
|
|
[2023-07-05T15:05:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.060303s ]
|
|
[2023-07-05T15:05:27+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` = 11 [ RunTime:0.053681s ]
|
|
[2023-07-05T15:05:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_topic` [ RunTime:0.081755s ]
|
|
[2023-07-05T15:05:27+08:00][sql] SELECT * FROM `ls_community_topic` WHERE `id` = 0 [ RunTime:0.054577s ]
|
|
[2023-07-05T15:05:27+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.065081s ]
|
|
[2023-07-05T15:05:27+08:00][sql] SELECT `id`,`nickname`,`sn` FROM `ls_user` WHERE `id` = 4 [ RunTime:0.066385s ]
|
|
[2023-07-05T15:05:31+08:00][sql] CONNECT:[ UseTime:0.076683s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T15:05:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.059932s ]
|
|
[2023-07-05T15:05:31+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688540730 , `uri` = '/admin/community.CommunityArticle/detail.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/detail_html\":\"\",\"id\":\"11\"}' , `ip` = '127.0.0.1' [ RunTime:0.045714s ]
|
|
[2023-07-05T15:05:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.044502s ]
|
|
[2023-07-05T15:05:31+08:00][sql] SELECT * FROM `ls_community_article` WHERE `id` = 11 LIMIT 1 [ RunTime:0.062536s ]
|
|
[2023-07-05T15:05:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.049192s ]
|
|
[2023-07-05T15:05:31+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` = 11 [ RunTime:0.048600s ]
|
|
[2023-07-05T15:05:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_topic` [ RunTime:0.058184s ]
|
|
[2023-07-05T15:05:31+08:00][sql] SELECT * FROM `ls_community_topic` WHERE `id` = 0 [ RunTime:0.047320s ]
|
|
[2023-07-05T15:05:31+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.044245s ]
|
|
[2023-07-05T15:05:31+08:00][sql] SELECT `id`,`nickname`,`sn` FROM `ls_user` WHERE `id` = 4 [ RunTime:0.049606s ]
|
|
[2023-07-05T15:05:32+08:00][sql] CONNECT:[ UseTime:0.049290s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T15:05:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.049781s ]
|
|
[2023-07-05T15:05:32+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688540731 , `uri` = '/admin/community.CommunityArticle/detail.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/detail_html\":\"\",\"type\":\"comment\",\"id\":\"11\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.032259s ]
|
|
[2023-07-05T15:05:32+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_comment` [ RunTime:0.031407s ]
|
|
[2023-07-05T15:05:32+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_comment` WHERE `del` = 0 AND `article_id` = 11 [ RunTime:0.030985s ]
|
|
[2023-07-05T15:05:32+08:00][sql] SELECT * FROM `ls_community_comment` WHERE `del` = 0 AND `article_id` = 11 LIMIT 0,10 [ RunTime:0.030329s ]
|
|
[2023-07-05T15:05:41+08:00][sql] CONNECT:[ UseTime:0.081782s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T15:05:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.058708s ]
|
|
[2023-07-05T15:05:41+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688540740 , `uri` = '/admin/community.CommunityArticle/del.html' , `type` = 'POST' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/del_html\":\"\",\"id\":\"11\"}' , `ip` = '127.0.0.1' [ RunTime:0.066723s ]
|
|
[2023-07-05T15:05:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.050879s ]
|
|
[2023-07-05T15:05:41+08:00][sql] SELECT * FROM `ls_community_article` WHERE `del` = 0 AND `id` = 11 LIMIT 1 [ RunTime:0.059269s ]
|
|
[2023-07-05T15:05:41+08:00][sql] SELECT * FROM `ls_community_article` WHERE `id` = 11 LIMIT 1 [ RunTime:0.065619s ]
|
|
[2023-07-05T15:05:41+08:00][sql] UPDATE `ls_community_article` SET `update_time` = 1688540741 , `del` = 1 WHERE `id` = 11 [ RunTime:0.052178s ]
|
|
[2023-07-05T15:21:11+08:00][sql] CONNECT:[ UseTime:0.084041s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T15:21:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.081526s ]
|
|
[2023-07-05T15:21:11+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688541670 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\",\"keyword\":\"\",\"content\":\"\",\"status\":\"\",\"start_time\":\"\",\"end_time\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.071992s ]
|
|
[2023-07-05T15:21:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.059630s ]
|
|
[2023-07-05T15:21:11+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 [ RunTime:0.060259s ]
|
|
[2023-07-05T15:21:11+08:00][sql] SELECT `a`.*,`u`.`nickname`,`u`.`avatar`,`u`.`sn` FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.070568s ]
|
|
[2023-07-05T15:21:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.058709s ]
|
|
[2023-07-05T15:21:11+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` IN (12,10,9,8,7,6,5,3) [ RunTime:0.057571s ]
|
|
[2023-07-05T15:21:11+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_category` [ RunTime:0.058244s ]
|
|
[2023-07-05T15:21:11+08:00][sql] SELECT * FROM `ls_community_category` WHERE `id` IN (1,8,5,4,10) [ RunTime:0.056716s ]
|
|
[2023-07-05T15:21:12+08:00][sql] CONNECT:[ UseTime:0.055192s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T15:21:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.040327s ]
|
|
[2023-07-05T15:21:12+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688541672 , `uri` = '/admin/community.CommunityArticle/audit.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/audit_html\":\"\",\"id\":\"12\"}' , `ip` = '127.0.0.1' [ RunTime:0.037082s ]
|
|
[2023-07-05T15:21:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.038798s ]
|
|
[2023-07-05T15:21:12+08:00][sql] SELECT * FROM `ls_community_article` WHERE `id` = 12 LIMIT 1 [ RunTime:0.038988s ]
|
|
[2023-07-05T15:21:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.039317s ]
|
|
[2023-07-05T15:21:12+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` = 12 [ RunTime:0.037162s ]
|
|
[2023-07-05T15:21:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_topic` [ RunTime:0.041427s ]
|
|
[2023-07-05T15:21:12+08:00][sql] SELECT * FROM `ls_community_topic` WHERE `id` = 0 [ RunTime:0.038384s ]
|
|
[2023-07-05T15:21:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.039296s ]
|
|
[2023-07-05T15:21:12+08:00][sql] SELECT `id`,`nickname`,`sn` FROM `ls_user` WHERE `id` = 4 [ RunTime:0.036464s ]
|
|
[2023-07-05T15:21:16+08:00][sql] CONNECT:[ UseTime:0.075717s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T15:21:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.067157s ]
|
|
[2023-07-05T15:21:16+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688541675 , `uri` = '/admin/community.CommunityArticle/audit.html' , `type` = 'POST' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/audit_html\":\"\",\"id\":\"12\",\"status\":\"1\",\"audit_remark\":\"111\"}' , `ip` = '127.0.0.1' [ RunTime:0.057605s ]
|
|
[2023-07-05T15:21:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.092233s ]
|
|
[2023-07-05T15:21:16+08:00][sql] SELECT * FROM `ls_community_article` WHERE `del` = 0 AND `id` = 12 LIMIT 1 [ RunTime:0.076277s ]
|
|
[2023-07-05T15:21:16+08:00][sql] SELECT * FROM `ls_community_article` WHERE `id` = 12 LIMIT 1 [ RunTime:0.048978s ]
|
|
[2023-07-05T15:21:16+08:00][sql] UPDATE `ls_community_article` SET `status` = 1 , `audit_remark` = '111' , `audit_time` = 1688541676 , `update_time` = 1688541676 WHERE `id` = 12 [ RunTime:0.071028s ]
|
|
[2023-07-05T15:21:16+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_follow` [ RunTime:0.063334s ]
|
|
[2023-07-05T15:21:16+08:00][sql] SELECT `user_id` FROM `ls_community_follow` WHERE `follow_id` = 4 AND `status` = 1 [ RunTime:0.050282s ]
|
|
[2023-07-05T15:21:17+08:00][sql] CONNECT:[ UseTime:0.076928s ] mysql:host=122.114.59.173;port=3306;dbname=ahbcqz;charset=utf8mb4
|
|
[2023-07-05T15:21:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.061460s ]
|
|
[2023-07-05T15:21:17+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1688541676 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.051229s ]
|
|
[2023-07-05T15:21:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.055798s ]
|
|
[2023-07-05T15:21:17+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 [ RunTime:0.051564s ]
|
|
[2023-07-05T15:21:17+08:00][sql] SELECT `a`.*,`u`.`nickname`,`u`.`avatar`,`u`.`sn` FROM `ls_community_article` `a` INNER JOIN `ls_user` `u` ON `u`.`id`=`a`.`user_id` WHERE `a`.`del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.052150s ]
|
|
[2023-07-05T15:21:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.052672s ]
|
|
[2023-07-05T15:21:17+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` IN (12,10,9,8,7,6,5,3) [ RunTime:0.051959s ]
|
|
[2023-07-05T15:21:17+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_category` [ RunTime:0.054806s ]
|
|
[2023-07-05T15:21:17+08:00][sql] SELECT * FROM `ls_community_category` WHERE `id` IN (1,8,5,4,10) [ RunTime:0.052504s ]
|
|
|