[ 2023-06-25T14:47:05+08:00 ] 223.104.148.22 /xmt/XCX.php/index/getpersonal?uno=
INFO: [ app_init ] --START--
INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000014s ]
INFO: [ app_init ] --END-- [ RunTime:0.019453s ]
INFO: [ app_begin ] --START--
INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.027246s ]
INFO: [ app_begin ] --END-- [ RunTime:0.027309s ]
SQL: SELECT
					a.*,v0.name vname,v1.name vname1,v2.name vname2,v3.name vname3,
					(SELECT COUNT(DISTINCT b.weight) FROM xmt_village_user b WHERE a.weight<b.weight  and a.vno = b.vno)+1 AS rank
				FROM
					xmt_village_user a
				left join xmt_village v0 on a.vno = v0.no and v0.del=0
				left join xmt_village v1 on a.vno1 = v1.no and v1.del=0
				left join xmt_village v2 on a.vno2 = v2.no and v2.del=0
				left join xmt_village v3 on a.vno3 = v3.no and v3.del=0
				WHERE a.del=0  AND a.uno='' [ RunTime:0.004765s ]

[ 2023-06-25T14:47:05+08:00 ] 223.104.148.22 /xmt/XCX.php/index/getpersonal?uno=
INFO: [ app_init ] --START--
INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000014s ]
INFO: [ app_init ] --END-- [ RunTime:0.019376s ]
INFO: [ app_begin ] --START--
INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.027240s ]
INFO: [ app_begin ] --END-- [ RunTime:0.027296s ]
SQL: SELECT
					a.*,v0.name vname,v1.name vname1,v2.name vname2,v3.name vname3,
					(SELECT COUNT(DISTINCT b.weight) FROM xmt_village_user b WHERE a.weight<b.weight  and a.vno = b.vno)+1 AS rank
				FROM
					xmt_village_user a
				left join xmt_village v0 on a.vno = v0.no and v0.del=0
				left join xmt_village v1 on a.vno1 = v1.no and v1.del=0
				left join xmt_village v2 on a.vno2 = v2.no and v2.del=0
				left join xmt_village v3 on a.vno3 = v3.no and v3.del=0
				WHERE a.del=0  AND a.uno='' [ RunTime:0.004003s ]