[ 2023-06-09T18:05:40+08:00 ] 58.219.6.34 /xmt/XCX.php/index/getpersonal?uno=100208000101060000000018
INFO: [ app_init ] --START--
INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000019s ]
INFO: [ app_init ] --END-- [ RunTime:0.000756s ]
INFO: [ app_begin ] --START--
INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.001046s ]
INFO: [ app_begin ] --END-- [ RunTime:0.001161s ]
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='100208000101060000000018' [ RunTime:0.004766s ]

[ 2023-06-09T18:05:40+08:00 ] 58.219.6.34 /xmt/XCX.php/index/getpersonal?uno=100208000101060000000018
INFO: [ app_init ] --START--
INFO: Run Behavior\BuildLiteBehavior [ RunTime:0.000011s ]
INFO: [ app_init ] --END-- [ RunTime:0.000681s ]
INFO: [ app_begin ] --START--
INFO: Run Behavior\ReadHtmlCacheBehavior [ RunTime:0.001148s ]
INFO: [ app_begin ] --END-- [ RunTime:0.001212s ]
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='100208000101060000000018' [ RunTime:0.007721s ]