[2023-10-28 22:00:18][sql]:CONNECT:[ UseTime:0.000258s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:00:18][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.001119s ]
[2023-10-28 22:00:18][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000202s ]
[2023-10-28 22:00:18][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000874s ]
[2023-10-28 22:00:18][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000185s ]
[2023-10-28 22:00:18][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000180s ]
[2023-10-28 22:00:18][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000872s ]
[2023-10-28 22:00:18][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000824s ]
[2023-10-28 22:00:18][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.000581s ]
[2023-10-28 22:00:19][sql]:CONNECT:[ UseTime:0.000258s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:00:19][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000964s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000185s ]
[2023-10-28 22:00:19][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000760s ]
[2023-10-28 22:00:19][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000148s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000135s ]
[2023-10-28 22:00:19][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000710s ]
[2023-10-28 22:00:19][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000672s ]
[2023-10-28 22:00:19][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.000551s ]
[2023-10-28 22:00:19][sql]:CONNECT:[ UseTime:0.000234s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:00:19][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000881s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000193s ]
[2023-10-28 22:00:19][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000774s ]
[2023-10-28 22:00:19][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000172s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000163s ]
[2023-10-28 22:00:19][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000767s ]
[2023-10-28 22:00:19][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000739s ]
[2023-10-28 22:00:19][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.000574s ]
[2023-10-28 22:00:19][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000735s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000171s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000173s ]
[2023-10-28 22:00:19][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000160s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000164s ]
[2023-10-28 22:00:19][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.000421s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:00:19][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000168s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-28 22:00:19][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.000400s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000158s ]
[2023-10-28 22:00:19][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000158s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-28 22:00:19][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.000420s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000151s ]
[2023-10-28 22:00:19][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000161s ]
[2023-10-28 22:00:19][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000164s ]
[2023-10-28 22:00:19][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.000403s ]
[2023-10-28 22:00:20][sql]:CONNECT:[ UseTime:0.000259s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:00:20][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000939s ]
[2023-10-28 22:00:20][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000177s ]
[2023-10-28 22:00:20][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000729s ]
[2023-10-28 22:00:20][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000222s ]
[2023-10-28 22:00:20][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000163s ]
[2023-10-28 22:00:20][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000729s ]
[2023-10-28 22:00:21][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000674s ]
[2023-10-28 22:00: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.000548s ]
[2023-10-28 22:00:21][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000698s ]
[2023-10-28 22:00:21][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000154s ]
[2023-10-28 22:00:21][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000132s ]
[2023-10-28 22:00:21][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000129s ]
[2023-10-28 22:00:21][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000123s ]
[2023-10-28 22:00: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.000374s ]
[2023-10-28 22:00:21][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000127s ]
[2023-10-28 22:00:21][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000148s ]
[2023-10-28 22:00:21][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000124s ]
[2023-10-28 22:00: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.000375s ]
[2023-10-28 22:00:21][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000121s ]
[2023-10-28 22:00:21][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000128s ]
[2023-10-28 22:00:21][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000112s ]
[2023-10-28 22:00: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.000358s ]
[2023-10-28 22:00:21][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000134s ]
[2023-10-28 22:00:21][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000124s ]
[2023-10-28 22:00:21][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000124s ]
[2023-10-28 22:00: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.000365s ]
[2023-10-28 22:00:21][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_prizes` [ RunTime:0.000748s ]
[2023-10-28 22:00:21][sql]:SELECT COUNT(*) AS think_count FROM `ea_mall_customer_prizes` `cp` INNER JOIN `ea_mall_prizes_lang` `l` ON `l`.`main_id`=`cp`.`prizes_id` WHERE  `lang` = 'cn'  AND `round_id` = 11 LIMIT 1 [ RunTime:0.000529s ]
[2023-10-28 22:00:21][sql]:SELECT * FROM `ea_mall_customer_prizes` `cp` INNER JOIN `ea_mall_prizes_lang` `l` ON `l`.`main_id`=`cp`.`prizes_id` WHERE  `lang` = 'cn'  AND `round_id` = 11 ORDER BY `update_time` DESC LIMIT 0,15 [ RunTime:0.000782s ]
[2023-10-28 22:01:03][sql]:CONNECT:[ UseTime:0.000258s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:01:03][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000974s ]
[2023-10-28 22:01:03][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000187s ]
[2023-10-28 22:01:03][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000739s ]
[2023-10-28 22:01:03][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000158s ]
[2023-10-28 22:01:03][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000140s ]
[2023-10-28 22:01:03][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000716s ]
[2023-10-28 22:01:03][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000661s ]
[2023-10-28 22:01:03][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-28 22:01:03][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000699s ]
[2023-10-28 22:01:03][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000149s ]
[2023-10-28 22:01:03][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000139s ]
[2023-10-28 22:01:03][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000129s ]
[2023-10-28 22:01:03][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000125s ]
[2023-10-28 22:01:03][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.000370s ]
[2023-10-28 22:01:03][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000123s ]
[2023-10-28 22:01:03][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000142s ]
[2023-10-28 22:01:03][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000124s ]
[2023-10-28 22:01:03][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.000356s ]
[2023-10-28 22:01:03][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000119s ]
[2023-10-28 22:01:03][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000127s ]
[2023-10-28 22:01:03][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000115s ]
[2023-10-28 22:01:03][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-28 22:01:03][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000122s ]
[2023-10-28 22:01:03][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000126s ]
[2023-10-28 22:01:03][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000115s ]
[2023-10-28 22:01:03][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.000373s ]
[2023-10-28 22:01:05][sql]:CONNECT:[ UseTime:0.000264s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:01:05][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000990s ]
[2023-10-28 22:01:05][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000202s ]
[2023-10-28 22:01:05][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000787s ]
[2023-10-28 22:01:05][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000187s ]
[2023-10-28 22:01:05][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000167s ]
[2023-10-28 22:01:05][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000802s ]
[2023-10-28 22:01:05][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000759s ]
[2023-10-28 22:01:05][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.000584s ]
[2023-10-28 22:01:05][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000785s ]
[2023-10-28 22:01:05][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000170s ]
[2023-10-28 22:01:05][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000164s ]
[2023-10-28 22:01:05][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000161s ]
[2023-10-28 22:01:05][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-28 22:01:05][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.000419s ]
[2023-10-28 22:01:05][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-28 22:01:05][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000167s ]
[2023-10-28 22:01:05][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000154s ]
[2023-10-28 22:01:05][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-28 22:01:05][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-28 22:01:05][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000159s ]
[2023-10-28 22:01:05][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000162s ]
[2023-10-28 22:01:05][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.000404s ]
[2023-10-28 22:01:05][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-28 22:01:05][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000164s ]
[2023-10-28 22:01:05][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000158s ]
[2023-10-28 22:01:05][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.000402s ]
[2023-10-28 22:01:05][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_sign` [ RunTime:0.000789s ]
[2023-10-28 22:01:05][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.001143s ]
[2023-10-28 22:01:05][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 0,15 [ RunTime:0.000952s ]
[2023-10-28 22:01:06][sql]:CONNECT:[ UseTime:0.000279s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:01:06][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000953s ]
[2023-10-28 22:01:06][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000182s ]
[2023-10-28 22:01:07][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000732s ]
[2023-10-28 22:01:07][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000158s ]
[2023-10-28 22:01:07][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000147s ]
[2023-10-28 22:01:07][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000701s ]
[2023-10-28 22:01:07][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000667s ]
[2023-10-28 22:01:07][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.000542s ]
[2023-10-28 22:01:07][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000707s ]
[2023-10-28 22:01:07][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000149s ]
[2023-10-28 22:01:07][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:01:07][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000148s ]
[2023-10-28 22:01:07][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000121s ]
[2023-10-28 22:01:07][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.000373s ]
[2023-10-28 22:01:07][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000119s ]
[2023-10-28 22:01:07][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000133s ]
[2023-10-28 22:01:07][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000136s ]
[2023-10-28 22:01:07][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.000359s ]
[2023-10-28 22:01:07][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000121s ]
[2023-10-28 22:01:07][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000123s ]
[2023-10-28 22:01:07][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000113s ]
[2023-10-28 22:01:07][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.000363s ]
[2023-10-28 22:01:07][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000115s ]
[2023-10-28 22:01:07][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000125s ]
[2023-10-28 22:01:07][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000117s ]
[2023-10-28 22:01:07][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.000373s ]
[2023-10-28 22:01:07][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_sign` [ RunTime:0.000733s ]
[2023-10-28 22:01:07][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.001124s ]
[2023-10-28 22:01:07][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 0,15 [ RunTime:0.000877s ]
[2023-10-28 22:01:10][sql]:CONNECT:[ UseTime:0.000274s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:01:10][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000953s ]
[2023-10-28 22:01:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000185s ]
[2023-10-28 22:01:10][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000720s ]
[2023-10-28 22:01:10][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000151s ]
[2023-10-28 22:01:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000133s ]
[2023-10-28 22:01:10][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000740s ]
[2023-10-28 22:01:10][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000673s ]
[2023-10-28 22:01:10][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.000559s ]
[2023-10-28 22:01:10][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000713s ]
[2023-10-28 22:01:10][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:01:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000119s ]
[2023-10-28 22:01:10][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000134s ]
[2023-10-28 22:01:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000115s ]
[2023-10-28 22:01:10][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.000393s ]
[2023-10-28 22:01:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000124s ]
[2023-10-28 22:01:10][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000188s ]
[2023-10-28 22:01:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000182s ]
[2023-10-28 22:01:10][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.000467s ]
[2023-10-28 22:01:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:01:10][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000163s ]
[2023-10-28 22:01:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000146s ]
[2023-10-28 22:01:10][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.000406s ]
[2023-10-28 22:01:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000122s ]
[2023-10-28 22:01:10][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000124s ]
[2023-10-28 22:01:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000117s ]
[2023-10-28 22:01:10][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-28 22:01:10][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_sign` [ RunTime:0.000767s ]
[2023-10-28 22:01:10][sql]:SELECT `sign`.`openid`,`l`.`title`,`sign`.`finish_time` 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 [ RunTime:0.001290s ]
[2023-10-28 22:02:11][sql]:CONNECT:[ UseTime:0.000275s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:02:11][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000977s ]
[2023-10-28 22:02:11][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000180s ]
[2023-10-28 22:02:11][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000778s ]
[2023-10-28 22:02:11][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000158s ]
[2023-10-28 22:02:11][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000150s ]
[2023-10-28 22:02:11][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000729s ]
[2023-10-28 22:02:11][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000652s ]
[2023-10-28 22:02:11][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.000543s ]
[2023-10-28 22:02:11][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000709s ]
[2023-10-28 22:02:11][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000152s ]
[2023-10-28 22:02:11][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000124s ]
[2023-10-28 22:02:11][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000120s ]
[2023-10-28 22:02:11][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000120s ]
[2023-10-28 22:02:11][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.000396s ]
[2023-10-28 22:02:11][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000127s ]
[2023-10-28 22:02:11][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000131s ]
[2023-10-28 22:02:11][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000125s ]
[2023-10-28 22:02:11][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.000378s ]
[2023-10-28 22:02:11][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000145s ]
[2023-10-28 22:02:11][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000127s ]
[2023-10-28 22:02:11][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000133s ]
[2023-10-28 22:02:11][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-28 22:02:11][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000119s ]
[2023-10-28 22:02:11][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000121s ]
[2023-10-28 22:02:11][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000114s ]
[2023-10-28 22:02:11][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.000374s ]
[2023-10-28 22:02:13][sql]:CONNECT:[ UseTime:0.000289s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:02:13][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000959s ]
[2023-10-28 22:02:13][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000207s ]
[2023-10-28 22:02:13][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000770s ]
[2023-10-28 22:02:13][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000157s ]
[2023-10-28 22:02:13][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000134s ]
[2023-10-28 22:02:13][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000744s ]
[2023-10-28 22:02:13][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000679s ]
[2023-10-28 22:02:13][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.000596s ]
[2023-10-28 22:02:13][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000737s ]
[2023-10-28 22:02:13][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000158s ]
[2023-10-28 22:02:13][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000124s ]
[2023-10-28 22:02:13][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000146s ]
[2023-10-28 22:02:13][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000117s ]
[2023-10-28 22:02:13][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.000377s ]
[2023-10-28 22:02:13][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000131s ]
[2023-10-28 22:02:13][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000126s ]
[2023-10-28 22:02:13][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000124s ]
[2023-10-28 22:02:13][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.000370s ]
[2023-10-28 22:02:13][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000123s ]
[2023-10-28 22:02:13][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000140s ]
[2023-10-28 22:02:13][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000118s ]
[2023-10-28 22:02:13][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.000369s ]
[2023-10-28 22:02:13][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000114s ]
[2023-10-28 22:02:13][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000133s ]
[2023-10-28 22:02:13][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000117s ]
[2023-10-28 22:02:13][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.000355s ]
[2023-10-28 22:02:13][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_sign` [ RunTime:0.000746s ]
[2023-10-28 22:02:13][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` = 'assist'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 LIMIT 1 [ RunTime:0.000843s ]
[2023-10-28 22:02:13][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` = 'assist'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 ORDER BY `finish_time` DESC LIMIT 0,15 [ RunTime:0.000875s ]
[2023-10-28 22:02:15][sql]:CONNECT:[ UseTime:0.000281s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:02:15][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000931s ]
[2023-10-28 22:02:15][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000178s ]
[2023-10-28 22:02:15][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000738s ]
[2023-10-28 22:02:15][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000158s ]
[2023-10-28 22:02:15][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000128s ]
[2023-10-28 22:02:15][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000727s ]
[2023-10-28 22:02:15][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000687s ]
[2023-10-28 22:02:15][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.000556s ]
[2023-10-28 22:02:15][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000707s ]
[2023-10-28 22:02:15][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000166s ]
[2023-10-28 22:02:15][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000116s ]
[2023-10-28 22:02:15][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000128s ]
[2023-10-28 22:02:15][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000112s ]
[2023-10-28 22:02:15][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.000406s ]
[2023-10-28 22:02:15][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000132s ]
[2023-10-28 22:02:15][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000124s ]
[2023-10-28 22:02:15][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000121s ]
[2023-10-28 22:02:15][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.000381s ]
[2023-10-28 22:02:15][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000130s ]
[2023-10-28 22:02:15][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000152s ]
[2023-10-28 22:02:15][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000129s ]
[2023-10-28 22:02:15][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-28 22:02:15][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000142s ]
[2023-10-28 22:02:15][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000132s ]
[2023-10-28 22:02:15][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000123s ]
[2023-10-28 22:02:15][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.000360s ]
[2023-10-28 22:02:15][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_sign` [ RunTime:0.000750s ]
[2023-10-28 22:02:15][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` = 'assist'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 LIMIT 1 [ RunTime:0.000827s ]
[2023-10-28 22:02:15][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` = 'assist'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 ORDER BY `finish_time` DESC LIMIT 0,15 [ RunTime:0.000836s ]
[2023-10-28 22:02:17][sql]:CONNECT:[ UseTime:0.000297s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:02:17][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000953s ]
[2023-10-28 22:02:17][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000188s ]
[2023-10-28 22:02:17][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000722s ]
[2023-10-28 22:02:17][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000153s ]
[2023-10-28 22:02:17][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000137s ]
[2023-10-28 22:02:17][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000713s ]
[2023-10-28 22:02:17][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000665s ]
[2023-10-28 22:02:17][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.000547s ]
[2023-10-28 22:02:17][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000705s ]
[2023-10-28 22:02:17][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000159s ]
[2023-10-28 22:02:17][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000127s ]
[2023-10-28 22:02:17][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000132s ]
[2023-10-28 22:02:17][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000116s ]
[2023-10-28 22:02:17][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.000386s ]
[2023-10-28 22:02:17][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000125s ]
[2023-10-28 22:02:17][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000135s ]
[2023-10-28 22:02:17][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000117s ]
[2023-10-28 22:02:17][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.000370s ]
[2023-10-28 22:02:17][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000116s ]
[2023-10-28 22:02:17][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000127s ]
[2023-10-28 22:02:17][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000110s ]
[2023-10-28 22:02:17][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-28 22:02:17][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000122s ]
[2023-10-28 22:02:17][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000125s ]
[2023-10-28 22:02:17][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000129s ]
[2023-10-28 22:02:17][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.000367s ]
[2023-10-28 22:02:17][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_sign` [ RunTime:0.000764s ]
[2023-10-28 22:02:17][sql]:SELECT `sign`.`openid`,`l`.`title`,`sign`.`finish_time` FROM `ea_mall_customer_sign` `sign` INNER JOIN `ea_mall_badge_lang` `l` ON `l`.`main_id`=`sign`.`badge_id` WHERE  `sign_type` = 'assist'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 [ RunTime:0.000882s ]
[2023-10-28 22:02:49][sql]:CONNECT:[ UseTime:0.000294s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:02:49][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000942s ]
[2023-10-28 22:02:49][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000189s ]
[2023-10-28 22:02:49][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000730s ]
[2023-10-28 22:02:49][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000153s ]
[2023-10-28 22:02:49][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000132s ]
[2023-10-28 22:02:49][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000737s ]
[2023-10-28 22:02:49][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000664s ]
[2023-10-28 22:02:49][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.000550s ]
[2023-10-28 22:02:49][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000712s ]
[2023-10-28 22:02:49][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000152s ]
[2023-10-28 22:02:49][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000122s ]
[2023-10-28 22:02:49][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000123s ]
[2023-10-28 22:02:49][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000116s ]
[2023-10-28 22:02:49][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.000383s ]
[2023-10-28 22:02:49][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000125s ]
[2023-10-28 22:02:49][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000126s ]
[2023-10-28 22:02:49][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000114s ]
[2023-10-28 22:02:49][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.000416s ]
[2023-10-28 22:02:49][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000125s ]
[2023-10-28 22:02:49][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000127s ]
[2023-10-28 22:02:49][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000113s ]
[2023-10-28 22:02:49][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.000368s ]
[2023-10-28 22:02:49][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000124s ]
[2023-10-28 22:02:49][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000131s ]
[2023-10-28 22:02:49][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000119s ]
[2023-10-28 22:02:49][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-28 22:02:50][sql]:CONNECT:[ UseTime:0.000270s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:02:50][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000980s ]
[2023-10-28 22:02:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000210s ]
[2023-10-28 22:02:50][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000822s ]
[2023-10-28 22:02:50][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000179s ]
[2023-10-28 22:02:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000181s ]
[2023-10-28 22:02:50][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000805s ]
[2023-10-28 22:02:50][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000756s ]
[2023-10-28 22:02:50][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.000583s ]
[2023-10-28 22:02:50][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000779s ]
[2023-10-28 22:02:50][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000171s ]
[2023-10-28 22:02:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000163s ]
[2023-10-28 22:02:50][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000171s ]
[2023-10-28 22:02:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000154s ]
[2023-10-28 22:02:50][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.000442s ]
[2023-10-28 22:02:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000157s ]
[2023-10-28 22:02:50][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000160s ]
[2023-10-28 22:02:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000154s ]
[2023-10-28 22:02:50][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.000421s ]
[2023-10-28 22:02:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:02:50][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000159s ]
[2023-10-28 22:02:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000150s ]
[2023-10-28 22:02:50][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-28 22:02:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-28 22:02:50][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000159s ]
[2023-10-28 22:02:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000161s ]
[2023-10-28 22:02:50][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.000401s ]
[2023-10-28 22:02:50][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_sign` [ RunTime:0.000806s ]
[2023-10-28 22:02:50][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` = 'answer'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 LIMIT 1 [ RunTime:0.000889s ]
[2023-10-28 22:02:50][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` = 'answer'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 ORDER BY `finish_time` DESC LIMIT 0,15 [ RunTime:0.000907s ]
[2023-10-28 22:02:52][sql]:CONNECT:[ UseTime:0.000305s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:02:52][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000988s ]
[2023-10-28 22:02:52][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000203s ]
[2023-10-28 22:02:52][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000795s ]
[2023-10-28 22:02:52][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000187s ]
[2023-10-28 22:02:52][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000181s ]
[2023-10-28 22:02:52][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000808s ]
[2023-10-28 22:02:52][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000768s ]
[2023-10-28 22:02:52][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.000573s ]
[2023-10-28 22:02:52][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000786s ]
[2023-10-28 22:02:52][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000170s ]
[2023-10-28 22:02:52][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000154s ]
[2023-10-28 22:02:52][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000178s ]
[2023-10-28 22:02:52][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000154s ]
[2023-10-28 22:02:52][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.000422s ]
[2023-10-28 22:02:52][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:02:52][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000159s ]
[2023-10-28 22:02:52][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000150s ]
[2023-10-28 22:02:52][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-28 22:02:52][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000150s ]
[2023-10-28 22:02:52][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000161s ]
[2023-10-28 22:02:52][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000149s ]
[2023-10-28 22:02:52][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.000395s ]
[2023-10-28 22:02:52][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000160s ]
[2023-10-28 22:02:52][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000157s ]
[2023-10-28 22:02:52][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:02:52][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.000421s ]
[2023-10-28 22:02:52][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_sign` [ RunTime:0.000805s ]
[2023-10-28 22:02:52][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` = 'answer'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 LIMIT 1 [ RunTime:0.000889s ]
[2023-10-28 22:02:52][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` = 'answer'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 ORDER BY `finish_time` DESC LIMIT 0,15 [ RunTime:0.000998s ]
[2023-10-28 22:02:55][sql]:CONNECT:[ UseTime:0.000266s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:02:55][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.001004s ]
[2023-10-28 22:02:55][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000217s ]
[2023-10-28 22:02:55][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000802s ]
[2023-10-28 22:02:55][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000179s ]
[2023-10-28 22:02:55][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000167s ]
[2023-10-28 22:02:55][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000804s ]
[2023-10-28 22:02:55][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000753s ]
[2023-10-28 22:02:55][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.000581s ]
[2023-10-28 22:02:55][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000765s ]
[2023-10-28 22:02:55][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000177s ]
[2023-10-28 22:02:55][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000163s ]
[2023-10-28 22:02:55][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000161s ]
[2023-10-28 22:02:55][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000155s ]
[2023-10-28 22:02:55][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.000433s ]
[2023-10-28 22:02:55][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:02:55][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000176s ]
[2023-10-28 22:02:55][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-28 22:02:55][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-28 22:02:55][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000171s ]
[2023-10-28 22:02:55][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000158s ]
[2023-10-28 22:02:55][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000157s ]
[2023-10-28 22:02:55][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.000424s ]
[2023-10-28 22:02:55][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:02:55][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000161s ]
[2023-10-28 22:02:55][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000163s ]
[2023-10-28 22:02:55][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.000395s ]
[2023-10-28 22:02:55][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_sign` [ RunTime:0.000809s ]
[2023-10-28 22:02:55][sql]:SELECT `sign`.`openid`,`l`.`title`,`sign`.`finish_time` FROM `ea_mall_customer_sign` `sign` INNER JOIN `ea_mall_badge_lang` `l` ON `l`.`main_id`=`sign`.`badge_id` WHERE  `sign_type` = 'answer'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 [ RunTime:0.000946s ]
[2023-10-28 22:03:26][sql]:CONNECT:[ UseTime:0.000274s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:03:26][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000971s ]
[2023-10-28 22:03:26][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000192s ]
[2023-10-28 22:03:26][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000730s ]
[2023-10-28 22:03:26][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000154s ]
[2023-10-28 22:03:26][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000149s ]
[2023-10-28 22:03:26][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000716s ]
[2023-10-28 22:03:26][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000656s ]
[2023-10-28 22:03:26][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.000540s ]
[2023-10-28 22:03:26][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000693s ]
[2023-10-28 22:03:26][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000156s ]
[2023-10-28 22:03:26][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000125s ]
[2023-10-28 22:03:26][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000128s ]
[2023-10-28 22:03:26][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000147s ]
[2023-10-28 22:03:26][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.000380s ]
[2023-10-28 22:03:26][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000124s ]
[2023-10-28 22:03:26][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000129s ]
[2023-10-28 22:03:26][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000116s ]
[2023-10-28 22:03:26][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.000368s ]
[2023-10-28 22:03:26][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000113s ]
[2023-10-28 22:03:26][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000125s ]
[2023-10-28 22:03:26][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000118s ]
[2023-10-28 22:03:26][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-28 22:03:26][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000120s ]
[2023-10-28 22:03:26][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000122s ]
[2023-10-28 22:03:26][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000112s ]
[2023-10-28 22:03:26][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-28 22:03:27][sql]:CONNECT:[ UseTime:0.000278s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:03:27][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000955s ]
[2023-10-28 22:03:27][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000187s ]
[2023-10-28 22:03:27][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000737s ]
[2023-10-28 22:03:27][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000180s ]
[2023-10-28 22:03:27][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000134s ]
[2023-10-28 22:03:27][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000733s ]
[2023-10-28 22:03:27][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000668s ]
[2023-10-28 22:03:27][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.000562s ]
[2023-10-28 22:03:27][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000724s ]
[2023-10-28 22:03:27][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000168s ]
[2023-10-28 22:03:27][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000122s ]
[2023-10-28 22:03:27][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000128s ]
[2023-10-28 22:03:27][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000114s ]
[2023-10-28 22:03:27][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.000373s ]
[2023-10-28 22:03:27][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000133s ]
[2023-10-28 22:03:27][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000132s ]
[2023-10-28 22:03:27][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000124s ]
[2023-10-28 22:03:27][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.000352s ]
[2023-10-28 22:03:27][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000116s ]
[2023-10-28 22:03:27][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000120s ]
[2023-10-28 22:03:27][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000115s ]
[2023-10-28 22:03:27][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.000375s ]
[2023-10-28 22:03:27][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000117s ]
[2023-10-28 22:03:27][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000128s ]
[2023-10-28 22:03:27][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000111s ]
[2023-10-28 22:03:27][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.000358s ]
[2023-10-28 22:03:27][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_sign` [ RunTime:0.000726s ]
[2023-10-28 22:03:27][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` = 'slogan'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 LIMIT 1 [ RunTime:0.000878s ]
[2023-10-28 22:03:27][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` = 'slogan'  AND `sign_status` = 1  AND `lang` = 'cn'  AND `round_id` = 11 ORDER BY `finish_time` DESC LIMIT 0,15 [ RunTime:0.000843s ]
[2023-10-28 22:03:45][sql]:CONNECT:[ UseTime:0.000273s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:03:45][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000997s ]
[2023-10-28 22:03:45][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000208s ]
[2023-10-28 22:03:45][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000802s ]
[2023-10-28 22:03:45][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000184s ]
[2023-10-28 22:03:45][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000164s ]
[2023-10-28 22:03:45][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000805s ]
[2023-10-28 22:03:45][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000758s ]
[2023-10-28 22:03:45][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.000582s ]
[2023-10-28 22:03:45][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000779s ]
[2023-10-28 22:03:45][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000170s ]
[2023-10-28 22:03:45][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:03:45][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000162s ]
[2023-10-28 22:03:45][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000154s ]
[2023-10-28 22:03:45][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.000434s ]
[2023-10-28 22:03:45][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:03:45][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000161s ]
[2023-10-28 22:03:45][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000163s ]
[2023-10-28 22:03:45][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.000431s ]
[2023-10-28 22:03:45][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:03:45][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000168s ]
[2023-10-28 22:03:45][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000169s ]
[2023-10-28 22:03:45][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-28 22:03:45][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000151s ]
[2023-10-28 22:03:45][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000167s ]
[2023-10-28 22:03:45][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000150s ]
[2023-10-28 22:03:45][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.000406s ]
[2023-10-28 22:03:46][sql]:CONNECT:[ UseTime:0.000284s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:03:46][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000945s ]
[2023-10-28 22:03:46][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000187s ]
[2023-10-28 22:03:46][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000730s ]
[2023-10-28 22:03:46][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000154s ]
[2023-10-28 22:03:46][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000132s ]
[2023-10-28 22:03:46][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000710s ]
[2023-10-28 22:03:46][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000674s ]
[2023-10-28 22:03:46][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.000554s ]
[2023-10-28 22:03:46][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000703s ]
[2023-10-28 22:03:46][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000150s ]
[2023-10-28 22:03:46][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000120s ]
[2023-10-28 22:03:46][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000130s ]
[2023-10-28 22:03:46][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000117s ]
[2023-10-28 22:03:46][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.000379s ]
[2023-10-28 22:03:46][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000122s ]
[2023-10-28 22:03:46][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000125s ]
[2023-10-28 22:03:46][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000116s ]
[2023-10-28 22:03:46][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.000368s ]
[2023-10-28 22:03:46][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000122s ]
[2023-10-28 22:03:46][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000141s ]
[2023-10-28 22:03:46][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000116s ]
[2023-10-28 22:03:46][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.000360s ]
[2023-10-28 22:03:46][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000114s ]
[2023-10-28 22:03:46][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000128s ]
[2023-10-28 22:03:46][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000111s ]
[2023-10-28 22:03:46][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-28 22:03:46][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer` [ RunTime:0.000769s ]
[2023-10-28 22:03:46][sql]:SELECT COUNT(*) AS think_count FROM `ea_mall_customer` WHERE  `is_register` = 1  AND `round_id` = 11 LIMIT 1 [ RunTime:0.001222s ]
[2023-10-28 22:03:46][sql]:SELECT * FROM `ea_mall_customer` WHERE  `is_register` = 1  AND `round_id` = 11 ORDER BY `update_time` DESC LIMIT 0,15 [ RunTime:0.001683s ]
[2023-10-28 22:03:47][sql]:CONNECT:[ UseTime:0.000285s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:03:47][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000968s ]
[2023-10-28 22:03:47][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000188s ]
[2023-10-28 22:03:47][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000776s ]
[2023-10-28 22:03:47][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000160s ]
[2023-10-28 22:03:47][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000134s ]
[2023-10-28 22:03:47][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000693s ]
[2023-10-28 22:03:47][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000658s ]
[2023-10-28 22:03:47][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.000538s ]
[2023-10-28 22:03:47][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000732s ]
[2023-10-28 22:03:47][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000177s ]
[2023-10-28 22:03:47][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000154s ]
[2023-10-28 22:03:47][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000169s ]
[2023-10-28 22:03:47][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-28 22:03:47][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-28 22:03:47][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000164s ]
[2023-10-28 22:03:47][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000162s ]
[2023-10-28 22:03:47][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:03:47][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.000459s ]
[2023-10-28 22:03:47][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:03:47][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000161s ]
[2023-10-28 22:03:47][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000150s ]
[2023-10-28 22:03:47][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.000420s ]
[2023-10-28 22:03:47][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000154s ]
[2023-10-28 22:03:47][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000159s ]
[2023-10-28 22:03:47][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000152s ]
[2023-10-28 22:03:47][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.000433s ]
[2023-10-28 22:03:47][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer` [ RunTime:0.000891s ]
[2023-10-28 22:03:47][sql]:SELECT COUNT(*) AS think_count FROM `ea_mall_customer` WHERE  `is_register` = 1  AND `round_id` = 11 LIMIT 1 [ RunTime:0.001270s ]
[2023-10-28 22:03:47][sql]:SELECT * FROM `ea_mall_customer` WHERE  `is_register` = 1  AND `round_id` = 11 ORDER BY `update_time` DESC LIMIT 0,15 [ RunTime:0.001732s ]
[2023-10-28 22:03:50][sql]:CONNECT:[ UseTime:0.000296s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:03:50][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000923s ]
[2023-10-28 22:03:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000183s ]
[2023-10-28 22:03:50][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000742s ]
[2023-10-28 22:03:50][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000149s ]
[2023-10-28 22:03:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000134s ]
[2023-10-28 22:03:50][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000718s ]
[2023-10-28 22:03:50][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000671s ]
[2023-10-28 22:03:50][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-28 22:03:50][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000706s ]
[2023-10-28 22:03:50][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000151s ]
[2023-10-28 22:03:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000117s ]
[2023-10-28 22:03:50][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000130s ]
[2023-10-28 22:03:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000113s ]
[2023-10-28 22:03:50][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.000382s ]
[2023-10-28 22:03:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000126s ]
[2023-10-28 22:03:50][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000121s ]
[2023-10-28 22:03:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000117s ]
[2023-10-28 22:03:50][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.000384s ]
[2023-10-28 22:03:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000118s ]
[2023-10-28 22:03:50][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000128s ]
[2023-10-28 22:03:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000111s ]
[2023-10-28 22:03:50][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.000360s ]
[2023-10-28 22:03:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000127s ]
[2023-10-28 22:03:50][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000121s ]
[2023-10-28 22:03:50][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000123s ]
[2023-10-28 22:03:50][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.000363s ]
[2023-10-28 22:03:50][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer` [ RunTime:0.000784s ]
[2023-10-28 22:03:50][sql]:SELECT * FROM `ea_mall_customer` WHERE  `is_register` = 1  AND `round_id` = 11 [ RunTime:0.002155s ]
[2023-10-28 22:05:12][sql]:CONNECT:[ UseTime:0.000277s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:05:12][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000959s ]
[2023-10-28 22:05:12][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000185s ]
[2023-10-28 22:05:12][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000753s ]
[2023-10-28 22:05:12][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000171s ]
[2023-10-28 22:05:12][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000140s ]
[2023-10-28 22:05:12][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000742s ]
[2023-10-28 22:05:12][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000682s ]
[2023-10-28 22:05:12][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.000557s ]
[2023-10-28 22:05:12][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000722s ]
[2023-10-28 22:05:12][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000176s ]
[2023-10-28 22:05:12][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000122s ]
[2023-10-28 22:05:12][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000138s ]
[2023-10-28 22:05:12][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000116s ]
[2023-10-28 22:05:12][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.000384s ]
[2023-10-28 22:05:12][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000122s ]
[2023-10-28 22:05:12][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000123s ]
[2023-10-28 22:05:12][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000120s ]
[2023-10-28 22:05:12][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-28 22:05:12][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000121s ]
[2023-10-28 22:05:12][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000129s ]
[2023-10-28 22:05:12][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000114s ]
[2023-10-28 22:05:12][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.000371s ]
[2023-10-28 22:05:12][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000111s ]
[2023-10-28 22:05:12][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000127s ]
[2023-10-28 22:05:12][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000109s ]
[2023-10-28 22:05:12][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.000363s ]
[2023-10-28 22:05:12][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_prizes` [ RunTime:0.000723s ]
[2023-10-28 22:05:12][sql]:SELECT COUNT(*) AS think_count FROM `ea_mall_customer_prizes` `cp` INNER JOIN `ea_mall_prizes_lang` `l` ON `l`.`main_id`=`cp`.`prizes_id` WHERE  `lang` = 'cn'  AND `round_id` = 11 LIMIT 1 [ RunTime:0.000487s ]
[2023-10-28 22:05:12][sql]:SELECT * FROM `ea_mall_customer_prizes` `cp` INNER JOIN `ea_mall_prizes_lang` `l` ON `l`.`main_id`=`cp`.`prizes_id` WHERE  `lang` = 'cn'  AND `round_id` = 11 ORDER BY `update_time` DESC LIMIT 0,15 [ RunTime:0.000746s ]
[2023-10-28 22:05:14][sql]:CONNECT:[ UseTime:0.000270s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:05:14][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000972s ]
[2023-10-28 22:05:14][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000198s ]
[2023-10-28 22:05:14][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000737s ]
[2023-10-28 22:05:14][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000154s ]
[2023-10-28 22:05:14][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000139s ]
[2023-10-28 22:05:14][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000720s ]
[2023-10-28 22:05:14][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000660s ]
[2023-10-28 22:05:14][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.000550s ]
[2023-10-28 22:05:14][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000723s ]
[2023-10-28 22:05:14][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000153s ]
[2023-10-28 22:05:14][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000127s ]
[2023-10-28 22:05:14][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000129s ]
[2023-10-28 22:05:14][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000135s ]
[2023-10-28 22:05:14][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-28 22:05:14][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000123s ]
[2023-10-28 22:05:14][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000130s ]
[2023-10-28 22:05:14][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000114s ]
[2023-10-28 22:05:14][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.000364s ]
[2023-10-28 22:05:14][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000122s ]
[2023-10-28 22:05:14][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000122s ]
[2023-10-28 22:05:14][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000118s ]
[2023-10-28 22:05:14][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-28 22:05:14][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000121s ]
[2023-10-28 22:05:14][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000127s ]
[2023-10-28 22:05:14][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000113s ]
[2023-10-28 22:05:14][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.000364s ]
[2023-10-28 22:05:14][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_prizes` [ RunTime:0.000744s ]
[2023-10-28 22:05:14][sql]:SELECT * FROM `ea_mall_customer_prizes` `cp` INNER JOIN `ea_mall_prizes_lang` `l` ON `l`.`main_id`=`cp`.`prizes_id` WHERE  `lang` = 'cn'  AND `round_id` = 11 [ RunTime:0.000664s ]
[2023-10-28 22:07:43][sql]:CONNECT:[ UseTime:0.000285s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:07:43][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000954s ]
[2023-10-28 22:07:43][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000174s ]
[2023-10-28 22:07:43][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000752s ]
[2023-10-28 22:07:43][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000155s ]
[2023-10-28 22:07:43][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000136s ]
[2023-10-28 22:07:43][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000692s ]
[2023-10-28 22:07:43][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000645s ]
[2023-10-28 22:07:43][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.000546s ]
[2023-10-28 22:07:43][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000710s ]
[2023-10-28 22:07:43][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000156s ]
[2023-10-28 22:07:43][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000123s ]
[2023-10-28 22:07:43][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000121s ]
[2023-10-28 22:07:43][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000128s ]
[2023-10-28 22:07:43][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-28 22:07:43][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000119s ]
[2023-10-28 22:07:43][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000140s ]
[2023-10-28 22:07:43][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000112s ]
[2023-10-28 22:07:43][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.000367s ]
[2023-10-28 22:07:43][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000135s ]
[2023-10-28 22:07:43][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000126s ]
[2023-10-28 22:07:43][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000120s ]
[2023-10-28 22:07:43][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.000356s ]
[2023-10-28 22:07:43][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000116s ]
[2023-10-28 22:07:43][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000121s ]
[2023-10-28 22:07:43][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000119s ]
[2023-10-28 22:07:43][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.000377s ]
[2023-10-28 22:07:43][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_prizes` [ RunTime:0.000748s ]
[2023-10-28 22:07:43][sql]:SELECT COUNT(*) AS think_count FROM `ea_mall_customer_prizes` `cp` INNER JOIN `ea_mall_prizes_lang` `l` ON `l`.`main_id`=`cp`.`prizes_id` WHERE  `title` LIKE '%勇士%'  AND `lang` = 'cn'  AND `round_id` = 11 LIMIT 1 [ RunTime:0.000534s ]
[2023-10-28 22:07:43][sql]:SELECT * FROM `ea_mall_customer_prizes` `cp` INNER JOIN `ea_mall_prizes_lang` `l` ON `l`.`main_id`=`cp`.`prizes_id` WHERE  `title` LIKE '%勇士%'  AND `lang` = 'cn'  AND `round_id` = 11 ORDER BY `update_time` DESC LIMIT 0,15 [ RunTime:0.000522s ]
[2023-10-28 22:08:10][sql]:CONNECT:[ UseTime:0.000257s ] mysql:host=127.0.0.1;port=3306;dbname=2023bmw_carnival;charset=utf8
[2023-10-28 22:08:10][sql]:SHOW FULL COLUMNS FROM `ea_system_admin` [ RunTime:0.000969s ]
[2023-10-28 22:08:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000182s ]
[2023-10-28 22:08:10][sql]:SHOW FULL COLUMNS FROM `ea_system_node` [ RunTime:0.000721s ]
[2023-10-28 22:08:10][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000153s ]
[2023-10-28 22:08:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000130s ]
[2023-10-28 22:08:10][sql]:SHOW FULL COLUMNS FROM `ea_system_auth` [ RunTime:0.000719s ]
[2023-10-28 22:08:10][sql]:SHOW FULL COLUMNS FROM `ea_system_auth_node` [ RunTime:0.000669s ]
[2023-10-28 22:08:10][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.000551s ]
[2023-10-28 22:08:10][sql]:SHOW FULL COLUMNS FROM `ea_mall_round` [ RunTime:0.000706s ]
[2023-10-28 22:08:10][sql]:SELECT * FROM `ea_mall_round` WHERE  `round_start_date` <= '2023-10-28'  AND `round_end_date` >= '2023-10-28' LIMIT 1 [ RunTime:0.000165s ]
[2023-10-28 22:08:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000139s ]
[2023-10-28 22:08:10][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000129s ]
[2023-10-28 22:08:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000131s ]
[2023-10-28 22:08:10][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.000366s ]
[2023-10-28 22:08:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000132s ]
[2023-10-28 22:08:10][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000140s ]
[2023-10-28 22:08:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000119s ]
[2023-10-28 22:08:10][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.000372s ]
[2023-10-28 22:08:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000121s ]
[2023-10-28 22:08:10][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000128s ]
[2023-10-28 22:08:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000113s ]
[2023-10-28 22:08:10][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.000368s ]
[2023-10-28 22:08:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2 LIMIT 1 [ RunTime:0.000122s ]
[2023-10-28 22:08:10][sql]:SELECT `id`,`node`,`title`,`type`,`is_auth` FROM `ea_system_node` [ RunTime:0.000122s ]
[2023-10-28 22:08:10][sql]:SELECT * FROM `ea_system_admin` WHERE  `id` = 2  AND `status` = 1 LIMIT 1 [ RunTime:0.000115s ]
[2023-10-28 22:08:10][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.000367s ]
[2023-10-28 22:08:10][sql]:SHOW FULL COLUMNS FROM `ea_mall_customer_prizes` [ RunTime:0.000772s ]
[2023-10-28 22:08:10][sql]:SELECT COUNT(*) AS think_count FROM `ea_mall_customer_prizes` `cp` INNER JOIN `ea_mall_prizes_lang` `l` ON `l`.`main_id`=`cp`.`prizes_id` WHERE  `title` LIKE '%勇士%'  AND `finish_time` = 2023-10-28 00:00:00  AND `lang` = 'cn'  AND `round_id` = 11 LIMIT 1 [ RunTime:0.000346s ]
[2023-10-28 22:08:10][sql]:SELECT * FROM `ea_mall_customer_prizes` `cp` INNER JOIN `ea_mall_prizes_lang` `l` ON `l`.`main_id`=`cp`.`prizes_id` WHERE  `title` LIKE '%勇士%'  AND `finish_time` = 2023-10-28 00:00:00  AND `lang` = 'cn'  AND `round_id` = 11 ORDER BY `update_time` DESC LIMIT 0,15 [ RunTime:0.000418s ]