[2023-10-23 05:30:21][sql]:CONNECT:[ UseTime:0.000289s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-23 05:30:21][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.001097s ]
[2023-10-23 05:30:21][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000219s ]
[2023-10-23 05:30:21][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000866s ]
[2023-10-23 05:30:21][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000178s ]
[2023-10-23 05:30:21][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000179s ]
[2023-10-23 05:30:21][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000832s ]
[2023-10-23 05:30:21][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000816s ]
[2023-10-23 05:30:21][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000588s ]
[2023-10-23 05:30:22][sql]:CONNECT:[ UseTime:0.000274s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-23 05:30:22][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000926s ]
[2023-10-23 05:30:22][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000182s ]
[2023-10-23 05:30:22][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000715s ]
[2023-10-23 05:30:22][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000153s ]
[2023-10-23 05:30:22][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000132s ]
[2023-10-23 05:30:22][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000710s ]
[2023-10-23 05:30:22][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000679s ]
[2023-10-23 05:30:22][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000558s ]
[2023-10-23 05:30:22][sql]:SELECT `id`,`auth_ids`,`head_img`,`username`,`phone`,`remark`,`login_num`,`sort`,`status`,`create_time`,`update_time`,`homepage_id` FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000140s ]
[2023-10-23 05:30:22][sql]:CONNECT:[ UseTime:0.000259s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-23 05:30:22][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000817s ]
[2023-10-23 05:30:22][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000160s ]
[2023-10-23 05:30:22][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000694s ]
[2023-10-23 05:30:22][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000152s ]
[2023-10-23 05:30:22][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000122s ]
[2023-10-23 05:30:22][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000700s ]
[2023-10-23 05:30:22][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000660s ]
[2023-10-23 05:30:22][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000544s ]
[2023-10-23 05:30:22][sql]:SELECT `id`,`auth_ids`,`head_img`,`username`,`phone`,`remark`,`login_num`,`sort`,`status`,`create_time`,`update_time`,`homepage_id` FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000139s ]
[2023-10-23 09:29:23][sql]:CONNECT:[ UseTime:0.000293s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-23 09:29:23][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000977s ]
[2023-10-23 09:29:23][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000199s ]
[2023-10-23 09:29:23][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000782s ]
[2023-10-23 09:29:23][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000189s ]
[2023-10-23 09:29:23][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000166s ]
[2023-10-23 09:29:23][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000773s ]
[2023-10-23 09:29:23][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000728s ]
[2023-10-23 09:29:23][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000569s ]
[2023-10-23 09:29:23][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000739s ]
[2023-10-23 09:29:23][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-23'  AND `round_end_date` >= '2023-10-23' LIMIT 1 [ RunTime:0.000179s ]
[2023-10-23 09:29:23][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-23 09:29:23][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000162s ]
[2023-10-23 09:29:23][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-23 09:29:23][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000415s ]
[2023-10-23 09:29:23][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000160s ]
[2023-10-23 09:29:23][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000158s ]
[2023-10-23 09:29:23][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000164s ]
[2023-10-23 09:29:23][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000410s ]
[2023-10-23 09:29:23][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-23 09:29:23][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000158s ]
[2023-10-23 09:29:23][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-23 09:29:23][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000405s ]
[2023-10-23 09:29:23][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000166s ]
[2023-10-23 09:29:23][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000160s ]
[2023-10-23 09:29:23][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000168s ]
[2023-10-23 09:29:23][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000397s ]
[2023-10-23 09:29:23][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_sign` [ RunTime:0.000761s ]
[2023-10-23 09:29:23][sql]:SELECT COUNT(*) AS think_count FROM `ea_mall_customer_sign` `sign` INNER JOIN `ea_mall_badge_lang` `l` ON `l`.`main_id`=`sign`.`badge_id` WHERE  `sign_type` = 'normal'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 LIMIT 1 [ RunTime:0.000210s ]
[2023-10-23 09:29:23][sql]:SELECT * FROM `ea_mall_customer_sign` `sign` INNER JOIN `ea_mall_badge_lang` `l` ON `l`.`main_id`=`sign`.`badge_id` WHERE  `sign_type` = 'normal'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 ORDER BY `finish_time` DESC LIMIT 15,15 [ RunTime:0.000269s ]
[2023-10-23 10:50:08][sql]:CONNECT:[ UseTime:0.000277s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-23 10:50:08][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000945s ]
[2023-10-23 10:50:08][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000176s ]
[2023-10-23 10:50:08][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000702s ]
[2023-10-23 10:50:08][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000151s ]
[2023-10-23 10:50:08][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000130s ]
[2023-10-23 10:50:08][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000726s ]
[2023-10-23 10:50:08][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000661s ]
[2023-10-23 10:50:08][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000558s ]
[2023-10-23 10:50:08][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000719s ]
[2023-10-23 10:50:08][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-23'  AND `round_end_date` >= '2023-10-23' LIMIT 1 [ RunTime:0.000150s ]
[2023-10-23 10:50:08][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000134s ]
[2023-10-23 10:50:08][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000125s ]
[2023-10-23 10:50:08][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000119s ]
[2023-10-23 10:50:08][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000376s ]
[2023-10-23 10:50:08][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000115s ]
[2023-10-23 10:50:08][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000132s ]
[2023-10-23 10:50:08][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000117s ]
[2023-10-23 10:50:08][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000414s ]
[2023-10-23 10:50:08][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000118s ]
[2023-10-23 10:50:08][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000131s ]
[2023-10-23 10:50:08][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000114s ]
[2023-10-23 10:50:08][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000361s ]
[2023-10-23 10:50:08][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000116s ]
[2023-10-23 10:50:08][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000127s ]
[2023-10-23 10:50:08][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000109s ]
[2023-10-23 10:50:08][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000357s ]
[2023-10-23 10:50:09][sql]:CONNECT:[ UseTime:0.000266s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-23 10:50:09][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000932s ]
[2023-10-23 10:50:09][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000187s ]
[2023-10-23 10:50:09][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000740s ]
[2023-10-23 10:50:09][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000150s ]
[2023-10-23 10:50:09][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000144s ]
[2023-10-23 10:50:09][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000698s ]
[2023-10-23 10:50:09][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000669s ]
[2023-10-23 10:50:09][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000553s ]
[2023-10-23 10:50:09][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000704s ]
[2023-10-23 10:50:09][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-23'  AND `round_end_date` >= '2023-10-23' LIMIT 1 [ RunTime:0.000157s ]
[2023-10-23 10:50:09][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000117s ]
[2023-10-23 10:50:09][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000128s ]
[2023-10-23 10:50:09][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000114s ]
[2023-10-23 10:50:09][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000398s ]
[2023-10-23 10:50:09][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000125s ]
[2023-10-23 10:50:09][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000137s ]
[2023-10-23 10:50:09][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000113s ]
[2023-10-23 10:50:09][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000362s ]
[2023-10-23 10:50:09][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000124s ]
[2023-10-23 10:50:09][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000126s ]
[2023-10-23 10:50:09][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000114s ]
[2023-10-23 10:50:09][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000361s ]
[2023-10-23 10:50:09][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000127s ]
[2023-10-23 10:50:09][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000123s ]
[2023-10-23 10:50:09][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000158s ]
[2023-10-23 10:50:09][sql]:SELECT DISTINCT  `node` FROM `ea_system_node` WHERE  ( id IN ( SELECT DISTINCT  `node_id` FROM `ea_system_auth_node` WHERE  ( auth_id IN ( SELECT DISTINCT  `id` FROM `ea_system_auth` WHERE  `id` = 1 ) ) ) ) [ RunTime:0.000354s ]
[2023-10-23 10:50:09][sql]:SHOW FULL COLUMNS FROM `ea_mall_problem` [ RunTime:0.000706s ]
[2023-10-23 10:50:09][sql]:SELECT COUNT(*) AS think_count FROM `ea_mall_problem` `model` WHERE  `round_id` = 11 LIMIT 1 [ RunTime:0.000137s ]
[2023-10-23 10:50:09][sql]:SELECT * FROM `ea_mall_problem` `model` WHERE  `round_id` = 11 ORDER BY `problem_id` LIMIT 0,15 [ RunTime:0.000120s ]