jianglong
/
server_ahbcqz
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
安徽博创起重服务端程序
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.
33 Commits
1 Branch
0 Tags
86 MiB
 
 
 
 
 
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
server_ahbcqz/runtime/admin/log/202305/05.log

350 lines
57 KiB
Raw Permalink Blame History

[2023-05-05T14:16:00+08:00][sql] CONNECT:[ UseTime:0.025081s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_admin` [ RunTime:0.008778s ]
[2023-05-05T14:16:00+08:00][sql] SELECT * FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.000412s ]
[2023-05-05T14:16:00+08:00][sql] SELECT `id`,`account`,`name`,`role_id` FROM `ls_admin` WHERE `account` = 'admin' AND `del` = 0 LIMIT 1 [ RunTime:0.000160s ]
[2023-05-05T14:16:00+08:00][sql] UPDATE `ls_admin` SET `login_ip` = '127.0.0.1' , `login_time` = 1683267360 WHERE `account` = 'admin' [ RunTime:0.001174s ]
[2023-05-05T14:16:00+08:00][sql] CONNECT:[ UseTime:0.013773s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.007021s ]
[2023-05-05T14:16:00+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267360 , `uri` = '/admin/index/index.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/index_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000159s ]
[2023-05-05T14:16:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.006208s ]
[2023-05-05T14:16:00+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.000520s ]
[2023-05-05T14:16:00+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.006379s ]
[2023-05-05T14:16:00+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000155s ]
[2023-05-05T14:16:01+08:00][sql] CONNECT:[ UseTime:0.021613s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003751s ]
[2023-05-05T14:16:01+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267361 , `uri` = '/admin/' , `type` = 'GET' , `param` = '[]' , `ip` = '127.0.0.1' [ RunTime:0.000162s ]
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_auth` [ RunTime:0.003092s ]
[2023-05-05T14:16:01+08:00][sql] SELECT * FROM `ls_dev_auth` WHERE `type` = 1 AND `del` = 0 AND `disable` = 0 ORDER BY `sort` DESC [ RunTime:0.000492s ]
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_role` [ RunTime:0.003125s ]
[2023-05-05T14:16:01+08:00][sql] SELECT `name` FROM `ls_role` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000170s ]
[2023-05-05T14:16:01+08:00][sql] CONNECT:[ UseTime:0.019485s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002962s ]
[2023-05-05T14:16:01+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267361 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000155s ]
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.006769s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.000195s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683129600 AND 1683215999 [ RunTime:0.000125s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683216000 AND 1683302399 [ RunTime:0.000105s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.000100s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683129600 AND 1683215999 [ RunTime:0.000109s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `create_time` BETWEEN 1683216000 AND 1683302399 [ RunTime:0.000098s ]
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.002883s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.000270s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 [ RunTime:0.000182s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 [ RunTime:0.000178s ]
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.002767s ]
[2023-05-05T14:16: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.000259s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000301s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683216000 AND 1683302399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000205s ]
[2023-05-05T14:16:01+08:00][sql] CONNECT:[ UseTime:0.000857s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003114s ]
[2023-05-05T14:16:01+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267361 , `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.000162s ]
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.003202s ]
[2023-05-05T14:16:01+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.002756s ]
[2023-05-05T14:16:01+08:00][sql] CONNECT:[ UseTime:0.019844s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003592s ]
[2023-05-05T14:16:01+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267361 , `uri` = '/admin/index/stat.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/index\\/stat_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000195s ]
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.003520s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1681920000 AND 1682006399 AND `pay_status` > 0 [ RunTime:0.000248s ]
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_stat` [ RunTime:0.002959s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1681920000 AND 1682006399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000302s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682006400 AND 1682092799 AND `pay_status` > 0 [ RunTime:0.000160s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682006400 AND 1682092799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000231s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682092800 AND 1682179199 AND `pay_status` > 0 [ RunTime:0.000134s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682092800 AND 1682179199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000171s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682179200 AND 1682265599 AND `pay_status` > 0 [ RunTime:0.000132s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682179200 AND 1682265599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000164s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682265600 AND 1682351999 AND `pay_status` > 0 [ RunTime:0.000124s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682265600 AND 1682351999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000221s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682352000 AND 1682438399 AND `pay_status` > 0 [ RunTime:0.000123s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682352000 AND 1682438399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000201s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682438400 AND 1682524799 AND `pay_status` > 0 [ RunTime:0.000119s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682438400 AND 1682524799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000160s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 AND `pay_status` > 0 [ RunTime:0.000121s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000212s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 AND `pay_status` > 0 [ RunTime:0.000126s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000214s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 AND `pay_status` > 0 [ RunTime:0.000127s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000157s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 AND `pay_status` > 0 [ RunTime:0.000114s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000154s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 AND `pay_status` > 0 [ RunTime:0.000113s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000154s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 AND `pay_status` > 0 [ RunTime:0.000119s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000152s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 AND `pay_status` > 0 [ RunTime:0.000113s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000140s ]
[2023-05-05T14:16:01+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 AND `pay_status` > 0 [ RunTime:0.000110s ]
[2023-05-05T14:16:01+08:00][sql] SELECT COUNT(*) AS think_count FROM ( SELECT count(id) AS think_count FROM `ls_stat` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 GROUP BY `ip` ) `_group_count_` [ RunTime:0.000152s ]
[2023-05-05T14:16:01+08:00][sql] CONNECT:[ UseTime:0.000998s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003192s ]
[2023-05-05T14:16:01+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267361 , `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.000203s ]
[2023-05-05T14:16:01+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.003155s ]
[2023-05-05T14:16:01+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.000263s ]
[2023-05-05T14:16:03+08:00][sql] CONNECT:[ UseTime:0.000967s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003192s ]
[2023-05-05T14:16:03+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267362 , `uri` = '/admin/user.User/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_User\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000227s ]
[2023-05-05T14:16:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.007223s ]
[2023-05-05T14:16:03+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 ORDER BY `growth_value` ASC [ RunTime:0.000293s ]
[2023-05-05T14:16:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_tag` [ RunTime:0.006432s ]
[2023-05-05T14:16:03+08:00][sql] SELECT `id`,`name` FROM `ls_user_tag` WHERE `del` = 0 ORDER BY `id` DESC [ RunTime:0.000241s ]
[2023-05-05T14:16:03+08:00][sql] CONNECT:[ UseTime:0.001025s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002908s ]
[2023-05-05T14:16:03+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267363 , `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.000199s ]
[2023-05-05T14:16:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.003295s ]
[2023-05-05T14:16:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE `del` = 0 [ RunTime:0.000229s ]
[2023-05-05T14:16:03+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.000231s ]
[2023-05-05T14:16:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_level` [ RunTime:0.002726s ]
[2023-05-05T14:16:03+08:00][sql] SELECT `id`,`name` FROM `ls_user_level` WHERE `del` = 0 [ RunTime:0.000192s ]
[2023-05-05T14:16:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_tag` [ RunTime:0.002798s ]
[2023-05-05T14:16:03+08:00][sql] SELECT `id`,`name` FROM `ls_user_tag` WHERE `del` = 0 [ RunTime:0.000185s ]
[2023-05-05T14:16:03+08:00][sql] SELECT `id`,`sn`,`nickname`,`avatar` FROM `ls_user` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000188s ]
[2023-05-05T14:16:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user` WHERE ( `first_leader` = 1 OR `second_leader` = 1 ) AND `del` = 0 [ RunTime:0.000185s ]
[2023-05-05T14:16:03+08:00][sql] CONNECT:[ UseTime:0.000969s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002996s ]
[2023-05-05T14:16:03+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267363 , `uri` = '/admin/user.Tag/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_Tag\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000196s ]
[2023-05-05T14:16:04+08:00][sql] CONNECT:[ UseTime:0.001059s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002934s ]
[2023-05-05T14:16:04+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267364 , `uri` = '/admin/user.tag/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_tag\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000252s ]
[2023-05-05T14:16:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_tag` [ RunTime:0.002716s ]
[2023-05-05T14:16:04+08:00][sql] SELECT * FROM `ls_user_tag` WHERE `del` = 0 LIMIT 0,10 [ RunTime:0.000268s ]
[2023-05-05T14:16:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user_tag` WHERE `del` = 0 [ RunTime:0.000249s ]
[2023-05-05T14:16:04+08:00][sql] CONNECT:[ UseTime:0.000966s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002914s ]
[2023-05-05T14:16:04+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267364 , `uri` = '/admin/user.Right/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_Right\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000198s ]
[2023-05-05T14:16:04+08:00][sql] CONNECT:[ UseTime:0.000972s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002936s ]
[2023-05-05T14:16:04+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267364 , `uri` = '/admin/user.right/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_right\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000199s ]
[2023-05-05T14:16:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_right` [ RunTime:0.006739s ]
[2023-05-05T14:16:04+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user_right` WHERE `del` = 0 [ RunTime:0.000225s ]
[2023-05-05T14:16:04+08:00][sql] SELECT * FROM `ls_user_right` WHERE `del` = 0 ORDER BY `sort` DESC LIMIT 0,10 [ RunTime:0.000230s ]
[2023-05-05T14:16:06+08:00][sql] CONNECT:[ UseTime:0.000971s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002920s ]
[2023-05-05T14:16:06+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267366 , `uri` = '/admin/account_log.AccountLog/growthLists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/account_log_AccountLog\\/growthLists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000197s ]
[2023-05-05T14:16:06+08:00][sql] CONNECT:[ UseTime:0.001018s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002878s ]
[2023-05-05T14:16:06+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267366 , `uri` = '/admin/account_log.account_log/growthLists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/account_log_account_log\\/growthLists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000200s ]
[2023-05-05T14:16:06+08:00][sql] SHOW FULL COLUMNS FROM `ls_account_log` [ RunTime:0.006798s ]
[2023-05-05T14:16:06+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_account_log` `al` LEFT JOIN `ls_user` `u` ON `u`.`id`=`al`.`user_id` WHERE `al`.`source_type` IN (300,301,303,302,304,305) [ RunTime:0.002724s ]
[2023-05-05T14:16:06+08:00][sql] SELECT `al`.*,`u`.`nickname`,`u`.`sn`,`u`.`mobile` FROM `ls_account_log` `al` LEFT JOIN `ls_user` `u` ON `u`.`id`=`al`.`user_id` WHERE `al`.`source_type` IN (300,301,303,302,304,305) ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.000309s ]
[2023-05-05T14:16:08+08:00][sql] CONNECT:[ UseTime:0.001010s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.003329s ]
[2023-05-05T14:16:08+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267368 , `uri` = '/admin/user.Ship/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_Ship\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000212s ]
[2023-05-05T14:16:08+08:00][sql] CONNECT:[ UseTime:0.000957s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.002947s ]
[2023-05-05T14:16:08+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267368 , `uri` = '/admin/user.ship/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/user_ship\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000228s ]
[2023-05-05T14:16:08+08:00][sql] SHOW FULL COLUMNS FROM `ls_user_ship` [ RunTime:0.007685s ]
[2023-05-05T14:16:08+08:00][sql] SELECT * FROM `ls_user_ship` WHERE `del` = 0 LIMIT 0,10 [ RunTime:0.000282s ]
[2023-05-05T14:16:08+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_user_ship` WHERE `del` = 0 [ RunTime:0.000207s ]
[2023-05-05T14:16:41+08:00][sql] CONNECT:[ UseTime:0.020130s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000498s ]
[2023-05-05T14:16:41+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267401 , `uri` = '/admin/complain.Complain/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/complain_Complain\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000136s ]
[2023-05-05T14:16:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_complain_category` [ RunTime:0.004849s ]
[2023-05-05T14:16:41+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_complain_category` WHERE `del` = 0 AND `is_show` = 1 ORDER BY `id` DESC [ RunTime:0.000188s ]
[2023-05-05T14:16:41+08:00][sql] CONNECT:[ UseTime:0.013917s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000487s ]
[2023-05-05T14:16:41+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267401 , `uri` = '/admin/complain.Complain/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/complain_Complain\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000130s ]
[2023-05-05T14:16:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_complain` [ RunTime:0.005666s ]
[2023-05-05T14:16:41+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_complain` WHERE `del` = 0 [ RunTime:0.000185s ]
[2023-05-05T14:16:41+08:00][sql] SELECT `id`,`uid`,`cid`,`image`,`content`,`is_complate`,`del`,`create_time`,`update_time`,`remark`,`sort` FROM `ls_complain` WHERE `del` = 0 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.000156s ]
[2023-05-05T14:16:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_complain_category` [ RunTime:0.002531s ]
[2023-05-05T14:16:41+08:00][sql] SELECT * FROM `ls_complain_category` WHERE `id` IN (5,6) [ RunTime:0.000279s ]
[2023-05-05T14:16:41+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.003052s ]
[2023-05-05T14:16:41+08:00][sql] SELECT * FROM `ls_user` WHERE `id` = 1 [ RunTime:0.001276s ]
[2023-05-05T14:16:47+08:00][sql] CONNECT:[ UseTime:0.016472s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:47+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000495s ]
[2023-05-05T14:16:47+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267407 , `uri` = '/admin/complain.ComplainCategory/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/complain_ComplainCategory\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000134s ]
[2023-05-05T14:16:48+08:00][sql] CONNECT:[ UseTime:0.018451s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:16:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000603s ]
[2023-05-05T14:16:48+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267408 , `uri` = '/admin/complain.ComplainCategory/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/complain_ComplainCategory\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000131s ]
[2023-05-05T14:16:48+08:00][sql] SHOW FULL COLUMNS FROM `ls_complain_category` [ RunTime:0.001296s ]
[2023-05-05T14:16:48+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_complain_category` WHERE `del` = 0 [ RunTime:0.000142s ]
[2023-05-05T14:16:48+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_complain_category` WHERE `del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000122s ]
[2023-05-05T14:17:37+08:00][sql] CONNECT:[ UseTime:0.014218s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:17:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000490s ]
[2023-05-05T14:17:37+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267457 , `uri` = '/admin/setting.MarketingConfig/orderAward.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/setting_MarketingConfig\\/orderAward_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000133s ]
[2023-05-05T14:17:37+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.001343s ]
[2023-05-05T14:17:37+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'order_award' AND `name` = 'award_ratio' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000167s ]
[2023-05-05T14:17:42+08:00][sql] CONNECT:[ UseTime:0.018935s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:17:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000506s ]
[2023-05-05T14:17:42+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267462 , `uri` = '/admin/distribution.Center/center.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/distribution_Center\\/center_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000138s ]
[2023-05-05T14:17:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_distribution_order_goods` [ RunTime:0.005256s ]
[2023-05-05T14:17:42+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_distribution_order_goods` WHERE `status` = 2 [ RunTime:0.000157s ]
[2023-05-05T14:17:42+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_distribution_order_goods` WHERE `status` = 2 AND `settlement_time` BETWEEN 1683216000 AND 1683302399 [ RunTime:0.000130s ]
[2023-05-05T14:17:42+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_distribution_order_goods` WHERE `status` = 1 [ RunTime:0.000098s ]
[2023-05-05T14:17:42+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_distribution_order_goods` WHERE `status` = 1 AND `create_time` BETWEEN 1683216000 AND 1683302399 [ RunTime:0.000099s ]
[2023-05-05T14:17:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_distribution` [ RunTime:0.005126s ]
[2023-05-05T14:17:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_distribution` WHERE ( `is_distribution` = 1 ) AND `ls_distribution`.`delete_time` IS NULL [ RunTime:0.000180s ]
[2023-05-05T14:17:42+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_distribution` WHERE `ls_distribution`.`delete_time` IS NULL [ RunTime:0.000105s ]
[2023-05-05T14:17:42+08:00][sql] SELECT sum(dog.money) AS `total_money`,`og`.`image` AS `goods_image`,`og`.`goods_name` FROM `ls_distribution_order_goods` `dog` LEFT JOIN `ls_order_goods` `og` ON `og`.`id`=`dog`.`order_goods_id` WHERE `dog`.`status` = 2 GROUP BY `dog`.`money`,`og`.`image`,`og`.`goods_name` ORDER BY `total_money` DESC LIMIT 10 [ RunTime:0.004175s ]
[2023-05-05T14:17:42+08:00][sql] SELECT sum(dog.money) AS `total_money`,`u`.`avatar`,`u`.`nickname` FROM `ls_distribution_order_goods` `dog` LEFT JOIN `ls_user` `u` ON `u`.`id`=`dog`.`user_id` WHERE `dog`.`status` = 2 GROUP BY `dog`.`money`,`u`.`avatar`,`u`.`nickname` ORDER BY `total_money` DESC LIMIT 10 [ RunTime:0.001456s ]
[2023-05-05T14:17:42+08:00][sql] CONNECT:[ UseTime:0.018873s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:17:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000753s ]
[2023-05-05T14:17:42+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267462 , `uri` = '/admin/content.Resource/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_Resource\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000161s ]
[2023-05-05T14:17:42+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.005091s ]
[2023-05-05T14:17:42+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.000346s ]
[2023-05-05T14:17:43+08:00][sql] CONNECT:[ UseTime:0.023358s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:17:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000446s ]
[2023-05-05T14:17:43+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267462 , `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.000099s ]
[2023-05-05T14:17:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource` [ RunTime:0.004768s ]
[2023-05-05T14:17:43+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_resource` WHERE `del` = 0 [ RunTime:0.000132s ]
[2023-05-05T14:17:43+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` FROM `ls_resource` WHERE `del` = 0 ORDER BY `sort` ASC LIMIT 0,10 [ RunTime:0.000134s ]
[2023-05-05T14:17:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.001197s ]
[2023-05-05T14:17:43+08:00][sql] SELECT * FROM `ls_resource_category` WHERE `id` = 5 [ RunTime:0.000098s ]
[2023-05-05T14:17:43+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_region` [ RunTime:0.004171s ]
[2023-05-05T14:17:43+08:00][sql] SELECT `id`,`id`,`name` FROM `ls_dev_region` [ RunTime:0.002855s ]
[2023-05-05T14:18:03+08:00][sql] CONNECT:[ UseTime:0.011450s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:18:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000476s ]
[2023-05-05T14:18:03+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267483 , `uri` = '/admin/content.ResourceCategory/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_ResourceCategory\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000134s ]
[2023-05-05T14:18:03+08:00][sql] CONNECT:[ UseTime:0.016253s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:18:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000494s ]
[2023-05-05T14:18:03+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267483 , `uri` = '/admin/content.ResourceCategory/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/content_ResourceCategory\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000135s ]
[2023-05-05T14:18:03+08:00][sql] SHOW FULL COLUMNS FROM `ls_resource_category` [ RunTime:0.001336s ]
[2023-05-05T14:18:03+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_resource_category` WHERE `del` = 0 [ RunTime:0.000143s ]
[2023-05-05T14:18:03+08:00][sql] SELECT `id`,`name`,`is_show`,`del`,`create_time`,`update_time` FROM `ls_resource_category` WHERE `del` = 0 ORDER BY `id` DESC LIMIT 0,10 [ RunTime:0.000121s ]
[2023-05-05T14:19:05+08:00][sql] CONNECT:[ UseTime:0.001067s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:19:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000769s ]
[2023-05-05T14:19:05+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267544 , `uri` = '/admin/wechat.Oa/setoa.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/wechat_Oa\\/setoa_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000136s ]
[2023-05-05T14:19:26+08:00][sql] CONNECT:[ UseTime:0.017221s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:19:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000591s ]
[2023-05-05T14:19:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267566 , `uri` = '/admin/decoration.Ad/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/decoration_Ad\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000134s ]
[2023-05-05T14:19:26+08:00][sql] CONNECT:[ UseTime:0.024326s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:19:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000497s ]
[2023-05-05T14:19:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267566 , `uri` = '/admin/decoration.Ad/getPositionList.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/decoration_Ad\\/getPositionList_html\":\"\",\"terminal\":\"1\"}' , `ip` = '127.0.0.1' [ RunTime:0.000197s ]
[2023-05-05T14:19:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_ad_position` [ RunTime:0.000407s ]
[2023-05-05T14:19:26+08:00][sql] SELECT `id`,`name`,`height`,`width` FROM `ls_ad_position` WHERE `del` = 0 AND `terminal` = 1 AND `status` = 1 [ RunTime:0.000166s ]
[2023-05-05T14:19:26+08:00][sql] CONNECT:[ UseTime:0.015724s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:19:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000433s ]
[2023-05-05T14:19:26+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267566 , `uri` = '/admin/decoration.Ad/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/decoration_Ad\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\",\"terminal\":\"1\"}' , `ip` = '127.0.0.1' [ RunTime:0.000175s ]
[2023-05-05T14:19:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_ad` [ RunTime:0.001492s ]
[2023-05-05T14:19:26+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_ad` `A` INNER JOIN `ls_ad_position` `AP` ON `A`.`pid`=`AP`.`id` WHERE `A`.`del` = 0 AND `A`.`terminal` = '1' [ RunTime:0.001751s ]
[2023-05-05T14:19:26+08:00][sql] SELECT `A`.*,AP.name as pname FROM `ls_ad` `A` INNER JOIN `ls_ad_position` `AP` ON `A`.`pid`=`AP`.`id` WHERE `A`.`del` = 0 AND `A`.`terminal` = '1' ORDER BY `A`.`sort` ASC,`A`.`id` DESC LIMIT 0,10 [ RunTime:0.000316s ]
[2023-05-05T14:19:26+08:00][sql] SHOW FULL COLUMNS FROM `ls_goods` [ RunTime:0.001452s ]
[2023-05-05T14:19:26+08:00][sql] SELECT `name`,`min_price`,`max_price` FROM `ls_goods` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000108s ]
[2023-05-05T14:19:26+08:00][sql] SELECT `name`,`min_price`,`max_price` FROM `ls_goods` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000089s ]
[2023-05-05T14:19:26+08:00][sql] SELECT `name`,`min_price`,`max_price` FROM `ls_goods` WHERE `id` = 4 LIMIT 1 [ RunTime:0.000068s ]
[2023-05-05T14:19:26+08:00][sql] SELECT `name`,`min_price`,`max_price` FROM `ls_goods` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000061s ]
[2023-05-05T14:19:34+08:00][sql] CONNECT:[ UseTime:0.010236s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:19:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000536s ]
[2023-05-05T14:19:34+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267573 , `uri` = '/admin/shop.Store/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000133s ]
[2023-05-05T14:19:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.005217s ]
[2023-05-05T14:19:34+08:00][sql] SELECT `id`,`name`,`image`,`sort`,`del`,`create_time`,`update_time` FROM `ls_shop_category` WHERE `del` = 0 ORDER BY `id` DESC,`sort` DESC [ RunTime:0.000215s ]
[2023-05-05T14:19:34+08:00][sql] CONNECT:[ UseTime:0.018800s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:19:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000829s ]
[2023-05-05T14:19:34+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267574 , `uri` = '/admin/shop.Store/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/shop_Store\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000148s ]
[2023-05-05T14:19:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.001549s ]
[2023-05-05T14:19:34+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_shop` WHERE `del` = 0 AND ( del=0 ) [ RunTime:0.000175s ]
[2023-05-05T14:19:34+08:00][sql] SELECT `id`,`cid`,`type`,`name`,`nickname`,`mobile`,`wallet`,`logo`,`background`,`license`,`keywords`,`intro`,`weight`,`trade_service_fee`,`weekdays`,`service_mobile`,`province_id`,`city_id`,`district_id`,`address`,`longitude`,`latitude`,`refund_address`,`run_start_time`,`run_end_time`,`is_run`,`is_freeze`,`is_product_audit`,`is_recommend`,`del`,`expire_time`,`create_time`,`update_time`,`score`,`star`,`visited_num`,`is_distribution`,`is_pay`,`cover`,`banner`,`business_license`,`other_qualifications`,`open_invoice`,`spec_invoice`,`delivery_type` FROM `ls_shop` WHERE `del` = 0 AND ( del=0 ) ORDER BY `id` DESC,`weight` ASC LIMIT 0,10 [ RunTime:0.000233s ]
[2023-05-05T14:19:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_category` [ RunTime:0.001282s ]
[2023-05-05T14:19:34+08:00][sql] SELECT * FROM `ls_shop_category` WHERE `id` = 1 [ RunTime:0.000133s ]
[2023-05-05T14:19:34+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_admin` [ RunTime:0.004859s ]
[2023-05-05T14:19:34+08:00][sql] SELECT * FROM `ls_shop_admin` WHERE `shop_id` IN (2,1) [ RunTime:0.000171s ]
[2023-05-05T14:19:39+08:00][sql] CONNECT:[ UseTime:0.022941s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:19:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000672s ]
[2023-05-05T14:19:39+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267579 , `uri` = '/admin/system.Crontab/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/system_Crontab\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000210s ]
[2023-05-05T14:19:39+08:00][sql] CONNECT:[ UseTime:0.019814s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:19:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000479s ]
[2023-05-05T14:19:39+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267579 , `uri` = '/admin/system.Crontab/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/system_Crontab\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000133s ]
[2023-05-05T14:19:39+08:00][sql] SHOW FULL COLUMNS FROM `ls_dev_crontab` [ RunTime:0.008165s ]
[2023-05-05T14:19:39+08:00][sql] SELECT `id`,`name`,`type`,type as type_desc,`command`,last_time as last_time_str,`expression`,`parameter`,`status`,`error`,`time`,`max_time`,`system` FROM `ls_dev_crontab` ORDER BY `system` DESC [ RunTime:0.000203s ]
[2023-05-05T14:19:45+08:00][sql] CONNECT:[ UseTime:0.012607s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:19:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000523s ]
[2023-05-05T14:19:45+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267585 , `uri` = '/admin/finance.Finance/center.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/finance_Finance\\/center_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000135s ]
[2023-05-05T14:19:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_order` [ RunTime:0.000849s ]
[2023-05-05T14:19:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_settlement` [ RunTime:0.004656s ]
[2023-05-05T14:19:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop_withdrawal` [ RunTime:0.004949s ]
[2023-05-05T14:19:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_withdraw_apply` [ RunTime:0.005586s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`trade_service_fee`) AS think_sum FROM `ls_shop_settlement` [ RunTime:0.000149s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`poundage`) AS think_sum FROM `ls_withdraw_apply` WHERE `status` = 3 [ RunTime:0.000273s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`poundage_amount`) AS think_sum FROM `ls_shop_withdrawal` [ RunTime:0.000143s ]
[2023-05-05T14:19:45+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.000187s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 [ RunTime:0.000119s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `shipping_status` = 0 AND `pay_status` = 2 AND `refund_status` IN (1,2) [ RunTime:0.000204s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`or`.`order_amount`) AS think_sum FROM `ls_order` `o` INNER JOIN `ls_order_refund` `or` ON `or`.`order_id`=`o`.`id` WHERE `o`.`shipping_status` = 0 AND `or`.`refund_status` <> 1 [ RunTime:0.004582s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`as`.`refund_price`) AS think_sum FROM `ls_order` `o` INNER JOIN `ls_after_sale` `as` ON `as`.`order_id`=`o`.`id` WHERE `o`.`shipping_status` = 1 AND `as`.`status` = 6 [ RunTime:0.004093s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`as`.`refund_price`) AS think_sum FROM `ls_order` `o` INNER JOIN `ls_after_sale` `as` ON `as`.`order_id`=`o`.`id` WHERE `o`.`shipping_status` = 1 AND `as`.`status` = 5 [ RunTime:0.000137s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`deal_order_count`) AS think_sum FROM `ls_shop_settlement` [ RunTime:0.000094s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`business_money`) AS think_sum FROM `ls_shop_settlement` [ RunTime:0.000079s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`order_amount`) AS think_sum FROM `ls_order` WHERE `pay_status` > 0 AND `settle_id` = 0 [ RunTime:0.000242s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`distribution_money`) AS think_sum FROM `ls_shop_settlement` [ RunTime:0.000172s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`entry_account_money`) AS think_sum FROM `ls_shop_settlement` [ RunTime:0.000104s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`apply_amount`) AS think_sum FROM `ls_shop_withdrawal` WHERE `status` = 2 [ RunTime:0.000241s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`apply_amount`) AS think_sum FROM `ls_shop_withdrawal` WHERE `status` = 1 [ RunTime:0.000109s ]
[2023-05-05T14:19:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_shop` [ RunTime:0.001475s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`wallet`) AS think_sum FROM `ls_shop` [ RunTime:0.000140s ]
[2023-05-05T14:19:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.000424s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`user_money`) AS think_sum FROM `ls_user` WHERE `del` = 0 [ RunTime:0.000126s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`dog`.`money`) AS think_sum FROM `ls_order` `o` INNER JOIN `ls_order_goods` `og` ON `og`.`order_id`=`o`.`id` INNER JOIN `ls_distribution_order_goods` `dog` ON `dog`.`order_goods_id`=`og`.`id` WHERE `o`.`settle_id` = 1 AND `dog`.`status` = 2 [ RunTime:0.002378s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_withdraw_apply` WHERE `status` = 3 [ RunTime:0.000146s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`money`) AS think_sum FROM `ls_withdraw_apply` WHERE `status` = 2 [ RunTime:0.000098s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`earnings`) AS think_sum FROM `ls_user` WHERE `del` = 0 [ RunTime:0.000093s ]
[2023-05-05T14:19:45+08:00][sql] SHOW FULL COLUMNS FROM `ls_account_log` [ RunTime:0.001344s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`change_amount`) AS think_sum FROM `ls_account_log` WHERE `change_type` = 1 AND `source_type` IN (200,201,202,203,204,206,207,205,208,209,210,211,212,213,214) [ RunTime:0.000153s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`change_amount`) AS think_sum FROM `ls_account_log` WHERE `source_type` = 202 [ RunTime:0.000100s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`change_amount`) AS think_sum FROM `ls_account_log` WHERE `change_type` = 2 AND `source_type` IN (200,201,202,203,204,206,207,205,208,209,210,211,212,213,214) [ RunTime:0.000109s ]
[2023-05-05T14:19:45+08:00][sql] SELECT SUM(`change_amount`) AS think_sum FROM `ls_account_log` WHERE `source_type` = 212 [ RunTime:0.000086s ]
[2023-05-05T14:19:46+08:00][sql] CONNECT:[ UseTime:0.017682s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:19:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000501s ]
[2023-05-05T14:19:46+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267586 , `uri` = '/admin/Statistics/member.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/Statistics\\/member_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000140s ]
[2023-05-05T14:19:46+08:00][sql] CONNECT:[ UseTime:0.023242s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:19:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000475s ]
[2023-05-05T14:19:46+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267586 , `uri` = '/admin/statistics/member.html' , `type` = 'POST' , `param` = '{\"\\/admin\\/statistics\\/member_html\":\"\",\"start_time\":\"\",\"end_time\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000129s ]
[2023-05-05T14:19:46+08:00][sql] SHOW FULL COLUMNS FROM `ls_user` [ RunTime:0.001422s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` [ RunTime:0.000124s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682611200 AND 1683215999 [ RunTime:0.000206s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1681920000 AND 1682006399 [ RunTime:0.000167s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682006400 AND 1682092799 [ RunTime:0.000109s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682092800 AND 1682179199 [ RunTime:0.000087s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682179200 AND 1682265599 [ RunTime:0.000081s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682265600 AND 1682351999 [ RunTime:0.000079s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682352000 AND 1682438399 [ RunTime:0.000080s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682438400 AND 1682524799 [ RunTime:0.000081s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682524800 AND 1682611199 [ RunTime:0.000077s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682611200 AND 1682697599 [ RunTime:0.000077s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682697600 AND 1682783999 [ RunTime:0.000075s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682784000 AND 1682870399 [ RunTime:0.000076s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682870400 AND 1682956799 [ RunTime:0.000076s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1682956800 AND 1683043199 [ RunTime:0.000076s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683043200 AND 1683129599 [ RunTime:0.000077s ]
[2023-05-05T14:19:46+08:00][sql] SELECT COUNT(`id`) AS think_count FROM `ls_user` WHERE `create_time` BETWEEN 1683129600 AND 1683215999 [ RunTime:0.000075s ]
[2023-05-05T14:19:47+08:00][sql] CONNECT:[ UseTime:0.025440s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:19:47+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000507s ]
[2023-05-05T14:19:47+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267587 , `uri` = '/admin/setting.Basic/website.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/setting_Basic\\/website_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000135s ]
[2023-05-05T14:19:47+08:00][sql] SHOW FULL COLUMNS FROM `ls_config` [ RunTime:0.002008s ]
[2023-05-05T14:19:47+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'website_platform' AND `name` = 'platform_contact' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000185s ]
[2023-05-05T14:19:47+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'website_platform' AND `name` = 'platform_mobile' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000179s ]
[2023-05-05T14:19:47+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'website_shop' AND `name` = 'shop_default_logo' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000266s ]
[2023-05-05T14:19:47+08:00][sql] SELECT `value` FROM `ls_config` WHERE `type` = 'website_shop' AND `name` = 'shop_default_bg' AND `shop_id` = 0 LIMIT 1 [ RunTime:0.000183s ]
[2023-05-05T14:20:02+08:00][sql] CONNECT:[ UseTime:0.015244s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:20:02+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000499s ]
[2023-05-05T14:20:02+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267602 , `uri` = '/admin/setting.CustomerService/index.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/setting_CustomerService\\/index_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000137s ]
[2023-05-05T14:20:04+08:00][sql] CONNECT:[ UseTime:0.017638s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:20:04+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000528s ]
[2023-05-05T14:20:04+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267604 , `uri` = '/admin/community.CommunityArticle/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityArticle\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000245s ]
[2023-05-05T14:20:05+08:00][sql] CONNECT:[ UseTime:0.011786s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:20:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000474s ]
[2023-05-05T14:20:05+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267605 , `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.000136s ]
[2023-05-05T14:20:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article` [ RunTime:0.001790s ]
[2023-05-05T14:20:05+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.001182s ]
[2023-05-05T14:20:05+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.000202s ]
[2023-05-05T14:20:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_article_image` [ RunTime:0.004940s ]
[2023-05-05T14:20:05+08:00][sql] SELECT * FROM `ls_community_article_image` WHERE `article_id` IN (2,1) [ RunTime:0.000165s ]
[2023-05-05T14:20:05+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_category` [ RunTime:0.005118s ]
[2023-05-05T14:20:05+08:00][sql] SELECT * FROM `ls_community_category` WHERE `id` IN (2,0) [ RunTime:0.000183s ]
[2023-05-05T14:20:12+08:00][sql] CONNECT:[ UseTime:0.021652s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:20:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000533s ]
[2023-05-05T14:20:12+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267612 , `uri` = '/admin/community.CommunityComment/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityComment\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000320s ]
[2023-05-05T14:20:12+08:00][sql] CONNECT:[ UseTime:0.019161s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:20:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000481s ]
[2023-05-05T14:20:12+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267612 , `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.000134s ]
[2023-05-05T14:20:12+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_comment` [ RunTime:0.005138s ]
[2023-05-05T14:20:12+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.001597s ]
[2023-05-05T14:20:12+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.000159s ]
[2023-05-05T14:20:14+08:00][sql] CONNECT:[ UseTime:0.016704s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:20:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000503s ]
[2023-05-05T14:20:14+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267614 , `uri` = '/admin/community.CommunityCategory/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityCategory\\/lists_html\":\"\"}' , `ip` = '127.0.0.1' [ RunTime:0.000134s ]
[2023-05-05T14:20:14+08:00][sql] CONNECT:[ UseTime:0.021476s ] mysql:host=127.0.0.1;port=3306;dbname=ahbcqz;charset=utf8mb4
[2023-05-05T14:20:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_system_log` [ RunTime:0.000655s ]
[2023-05-05T14:20:14+08:00][sql] INSERT INTO `ls_system_log` SET `admin_id` = 1 , `name` = 'admin' , `account` = 'admin' , `create_time` = 1683267614 , `uri` = '/admin/community.CommunityCategory/lists.html' , `type` = 'GET' , `param` = '{\"\\/admin\\/community_CommunityCategory\\/lists_html\":\"\",\"page\":\"1\",\"limit\":\"10\"}' , `ip` = '127.0.0.1' [ RunTime:0.000103s ]
[2023-05-05T14:20:14+08:00][sql] SHOW FULL COLUMNS FROM `ls_community_category` [ RunTime:0.001343s ]
[2023-05-05T14:20:14+08:00][sql] SELECT COUNT(*) AS think_count FROM `ls_community_category` WHERE `del` = 0 [ RunTime:0.000116s ]
[2023-05-05T14:20:14+08:00][sql] SELECT `id`,`name`,`sort`,`is_show`,`create_time`,`update_time`,`del` FROM `ls_community_category` WHERE `del` = 0 ORDER BY `sort` ASC,`id` DESC LIMIT 0,10 [ RunTime:0.000102s ]