space.php

OStack程序员社区-中国程序员成长平台 › 门户 › 编程› PHP›PHP编程经验

原作者: [db:作者] 来自: [db:来源] 收藏邀请

天云信息技术有限公司 | 苏ICP备16033617号

0.275 ms

SELECT * FROM uchome_session WHERE uid='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uchome_session	-	system	PRIMARY	-	-	-	1	100.00	-

0.575 ms

SELECT sf.*, s.* FROM uchome_space s LEFT JOIN uchome_spacefield sf ON sf.uid=s.uid WHERE s.uid='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	-	const	PRIMARY	PRIMARY	3	const	1	100.00	-

3	0.204 ms	UPDATE uchome_session SET `lastactivity`='1533236926' WHERE `uid`='1'
3	Info	Rows matched: 1 Changed: 1 Warnings: 0

0.336 ms

SELECT * FROM uchome_cron WHERE available>'0' AND nextrun<='1533236926' ORDER BY nextrun LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uchome_cron	-	ALL	nextrun	-	-	-	5	33.33	Using where; Using filesort

5	0.243 ms	UPDATE uchome_cron SET `lastrun`='1533236926', `nextrun`='1533237120' WHERE `cronid`='4'
5	Info	Rows matched: 1 Changed: 1 Warnings: 0

0.277 ms

SELECT nextrun FROM uchome_cron WHERE available>'0' ORDER BY nextrun LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uchome_cron	-	index	nextrun	nextrun	5	-	5	100.00	Using where; Using index; Using filesort

7	0.227 ms	REPLACE INTO uchome_config (`var`, `datavalue`) VALUES ('cronnextrun', '1533237000')

0.271 ms

SELECT * FROM uchome_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uchome_config	-	ALL	-	-	-	-	65	100.00	-

0.638 ms

SELECT * FROM uchome_spaceinfo WHERE uid='1' AND type IN ('base', 'contact')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uchome_spaceinfo	-	ref	uid	uid	3	const	21	20.00	Using where

0.831 ms

SELECT * FROM uchome_feed WHERE uid='1' ORDER BY dateline DESC LIMIT 0,20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uchome_feed	-	ref	uid	uid	3	const	40	100.00	Using where

0.331 ms

SELECT * FROM uchome_friend WHERE uid='1' AND status='1' ORDER BY num DESC, dateline DESC LIMIT 0,16

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uchome_friend	-	ref	PRIMARY,status	status	4	const,const	1	50.00	Using where

0.349 ms

SELECT * FROM uchome_visitor WHERE uid='1' ORDER BY dateline DESC LIMIT 0,16

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uchome_visitor	-	ref	PRIMARY,dateline	dateline	3	const	1	100.00	Using where

0.392 ms

SELECT b.uid, b.blogid, b.subject, b.dateline, b.pic, b.picflag, b.viewnum, b.replynum, b.friend, b.password, bf.message, bf.target_ids FROM uchome_blog b LEFT JOIN uchome_blogfield bf ON bf.blogid=b.blogid WHERE b.uid='1' ORDER BY b.dateline DESC LIMIT 0,5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	b	-	ref	uid	uid	3	const	3	100.00	Using where

0.255 ms

SELECT * FROM uchome_album WHERE uid='1' ORDER BY updatetime DESC LIMIT 0,6

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uchome_album	-	system	uid	-	-	-	1	100.00	-

0.472 ms

SELECT * FROM uchome_comment WHERE id='1' AND idtype='uid' ORDER BY dateline DESC LIMIT 0,5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uchome_comment	-	ref	id	id	45	const,const	2	100.00	Using where

0.229 ms

SELECT * FROM uchome_session WHERE uid = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uchome_session	-	system	PRIMARY	-	-	-	1	100.00	-

0.304 ms

SELECT * FROM uchome_magicuselog WHERE uid='1' AND mid='gift' LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	uchome_magicuselog	-	ref	uid	uid	35	const,const	1	100.00	-

1	$_COOKIE['pma_lang']	zh_CN
2	$_COOKIE['pma_collation_connection']	utf8_unicode_ci
3	$_COOKIE['RFaw_2132_saltkey']	Cv26oFVk
4	$_COOKIE['RFaw_2132_lastvisit']	1532910433
5	$_COOKIE['pma_iv-1']	zj4hZ8RrY75Ep7OlAQXkRQ==
6	$_COOKIE['pmaUser-1']	1CGG71Wnu3sFtX8IDrMtNw==
7	$_COOKIE['PHPSESSID']	l95ummcj6joh4b17du608jjl15
8	$_COOKIE['Hm_lvt_8cb2b52dc2b6f7c0a7ff6decd80187f7']	1532888584,1532912770,1532945982,1533191716
9	$_COOKIE['uchome_loginuser']	root
10	$_COOKIE['prohistoy']	2xcf1xcfxcfxcfxcfxcfxcfxcf
11	$_COOKIE['uchome_space_top_show']	1
12	$_COOKIE['uchome_space_top_credit']	1
13	$_COOKIE['uchome_space_top_experience']	1
14	$_COOKIE['Example_auth']	594f92s4OqYqD6s8to8yXjQTCJ+R9l16Qu3p/2PCcgD4qME
15	$_COOKIE['uchome_auth']	ece5ryhCeG2YLIkxmBm4zlOVRgpnIgplemrWSWsP72ysdVtOAeaUIXfzFUZvrdp+xjdIjAk4zkLDgEPI9kMx
16	$_COOKIE['RFaw_2132_sid']	sn7r7d
17	$_COOKIE['RFaw_2132_lastact']	1533212701 uc.php
18	$_COOKIE['uchome_space_top_friendnum']	1
19	$_COOKIE['uchome_space_top_viewnum']	2
20	$_COOKIE['read_feed_ids']	21,14
21	$_COOKIE['uchome_pic_sequence']	1
22	$_COOKIE['uchome_viewuids']	3_4_5_6
23	$_COOKIE['uchome_synfriend']	1
24	$_COOKIE['uchome_sendmail']	1
25	$_COOKIE['Hm_lpvt_8cb2b52dc2b6f7c0a7ff6decd80187f7']	1533236786
26	$_COOKIE['uchome_checkpm']	1

1	D:\UCenter_\wwwroot\shop\home\space.php
2	D:\UCenter_\wwwroot\shop\home\common.php
3	D:\UCenter_\wwwroot\shop\home\ver.php
4	D:\UCenter_\wwwroot\shop\home\config.php
5	D:\UCenter_\wwwroot\shop\home\source\function_common.php
6	D:\UCenter_\wwwroot\shop\home\source\class_mysql.php
7	D:\UCenter_\wwwroot\shop\home\data\data_config.php
8	D:\UCenter_\wwwroot\shop\home\data\data_app.php
9	D:\UCenter_\wwwroot\shop\home\data\data_userapp.php
10	D:\UCenter_\wwwroot\shop\home\data\data_ad.php
11	D:\UCenter_\wwwroot\shop\home\data\data_magic.php
12	D:\UCenter_\wwwroot\shop\home\data\data_creditrule.php
13	D:\UCenter_\wwwroot\shop\home\data\data_usergroup_1.php
14	D:\UCenter_\wwwroot\shop\home\source\function_cron.php
15	D:\UCenter_\wwwroot\shop\home\source\cron\getfeed.php
16	D:\UCenter_\wwwroot\shop\home\uc_client\client.php
17	D:\UCenter_\wwwroot\shop\home\uc_client\lib\db.class.php
18	D:\UCenter_\wwwroot\shop\home\uc_client\model\base.php
19	D:\UCenter_\wwwroot\shop\home\uc_client\control\feed.php
20	D:\UCenter_\wwwroot\shop\home\uc_client\data\cache\settings.php
21	D:\UCenter_\wwwroot\shop\home\uc_client\data\cache\apps.php
22	D:\UCenter_\wwwroot\shop\home\uc_client\model\misc.php
23	D:\UCenter_\wwwroot\shop\home\source\function_cache.php
24	D:\UCenter_\wwwroot\shop\home\source\space_index.php
25	D:\UCenter_\wwwroot\shop\home\source\function_cp.php
26	D:\UCenter_\wwwroot\shop\home\language\lang_source.php
27	D:\UCenter_\wwwroot\shop\home\data\data_usergroup.php
28	D:\UCenter_\wwwroot\shop\home\source\function_template.php
29	D:\UCenter_\wwwroot\shop\home\data\tpl_cache\template_default_space_index.php
30	D:\UCenter_\wwwroot\shop\home\source\inc_debug.php

1	$_SERVER['PROCESSOR_ARCHITEW6432']	AMD64
2	$_SERVER['_FCGI_X_PIPE_']	\\.\pipe\IISFCGI-aeb5be8d-990f-4537-9d14-9100a6c68c0a
3	$_SERVER['PHPRC']	C:\Program Files (x86)\php\v5.4\
4	$_SERVER['PHP_FCGI_MAX_REQUESTS']	10000
5	$_SERVER['ALLUSERSPROFILE']	C:\ProgramData
6	$_SERVER['APPDATA']	C:\Windows\system32\config\systemprofile\AppData\Roaming
7	$_SERVER['APP_POOL_CONFIG']	C:\inetpub\temp\apppools\concw\concw.config
8	$_SERVER['APP_POOL_ID']	concw
9	$_SERVER['CLASSPATH']	.;C:\Program Files\Java\jdk-10.0.1\lib;C:\Program Files\Java\jdk-10.0.1\lib\dt.jar;C:\Program Files\Java\jdk-10.0.1\lib\tools.jar
10	$_SERVER['CommonProgramFiles']	C:\Program Files (x86)\Common Files
11	$_SERVER['CommonProgramFiles(x86)']	C:\Program Files (x86)\Common Files
12	$_SERVER['CommonProgramW6432']	C:\Program Files\Common Files
13	$_SERVER['COMPUTERNAME']	DESKTOP-82KV2VM
14	$_SERVER['ComSpec']	C:\Windows\system32\cmd.exe
15	$_SERVER['FSHARPINSTALLDIR']	C:\Program Files (x86)\Microsoft SDKs\F#\10.1\Framework\v4.0\
16	$_SERVER['JAVA_HOME']	C:\Program Files\Java\jdk-10.0.1
17	$_SERVER['LOCALAPPDATA']	C:\Windows\system32\config\systemprofile\AppData\Local
18	$_SERVER['NUMBER_OF_PROCESSORS']	8
19	$_SERVER['OS']	Windows_NT
20	$_SERVER['Path']	C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Windows\system32\inetsrv;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\dotnet\;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Users\llskj\AppData\Local\Microsoft\WindowsApps;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files\Microsoft SQL Server\130\DTS\Binn\;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\;C:\ProgramData\ComposerSetup\bin;C:\Program Files\TortoiseSVN\bin;C:\Program Files\Java\jdk-10.0.1\bin;C:\Program Files\Java\jdk-10.0.1\jre\bin;C:\Users\llskj\.dotnet\tools
21	$_SERVER['PATHEXT']	.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.MSC
22	$_SERVER['PROCESSOR_ARCHITECTURE']	x86
23	$_SERVER['PROCESSOR_IDENTIFIER']	Intel64 Family 6 Model 60 Stepping 3, GenuineIntel
24	$_SERVER['PROCESSOR_LEVEL']	6
25	$_SERVER['PROCESSOR_REVISION']	3c03
26	$_SERVER['ProgramData']	C:\ProgramData
27	$_SERVER['ProgramFiles']	C:\Program Files (x86)
28	$_SERVER['ProgramFiles(x86)']	C:\Program Files (x86)
29	$_SERVER['ProgramW6432']	C:\Program Files
30	$_SERVER['PSModulePath']	C:\Program Files\WindowsPowerShell\Modules;C:\Windows\system32\WindowsPowerShell\v1.0\Modules;C:\Program Files (x86)\Microsoft SQL Server\130\Tools\PowerShell\Modules\
31	$_SERVER['PUBLIC']	C:\Users\Public
32	$_SERVER['SystemDrive']	C:
33	$_SERVER['SystemRoot']	C:\Windows
34	$_SERVER['TEMP']	C:\Windows\TEMP
35	$_SERVER['TMP']	C:\Windows\TEMP
36	$_SERVER['USERDOMAIN']	WORKGROUP
37	$_SERVER['USERNAME']	DESKTOP-82KV2VM$
38	$_SERVER['USERPROFILE']	C:\Windows\system32\config\systemprofile
39	$_SERVER['windir']	C:\Windows
40	$_SERVER['ORIG_PATH_INFO']	/home/space.php
41	$_SERVER['URL']	/home/space.php
42	$_SERVER['SERVER_SOFTWARE']	Microsoft-IIS/10.0
43	$_SERVER['SERVER_PROTOCOL']	HTTP/1.1
44	$_SERVER['SERVER_PORT_SECURE']	0
45	$_SERVER['SERVER_PORT']	80
46	$_SERVER['SERVER_NAME']	localhost
47	$_SERVER['SCRIPT_NAME']	/home/space.php
48	$_SERVER['SCRIPT_FILENAME']	D:\UCenter_\wwwroot\shop\home\space.php
49	$_SERVER['REQUEST_URI']	/home/space.php
50	$_SERVER['REQUEST_METHOD']	GET
51	$_SERVER['REMOTE_USER']
52	$_SERVER['REMOTE_PORT']	39173
53	$_SERVER['REMOTE_HOST']	::1
54	$_SERVER['REMOTE_ADDR']	::1
55	$_SERVER['QUERY_STRING']
56	$_SERVER['PATH_TRANSLATED']	D:\UCenter_\wwwroot\shop\home\space.php
57	$_SERVER['LOGON_USER']
58	$_SERVER['LOCAL_ADDR']	::1
59	$_SERVER['INSTANCE_META_PATH']	/LM/W3SVC/2
60	$_SERVER['INSTANCE_NAME']	CONCW
61	$_SERVER['INSTANCE_ID']	2
62	$_SERVER['HTTPS_SERVER_SUBJECT']
63	$_SERVER['HTTPS_SERVER_ISSUER']
64	$_SERVER['HTTPS_SECRETKEYSIZE']
65	$_SERVER['HTTPS_KEYSIZE']
66	$_SERVER['HTTPS']	off
67	$_SERVER['GATEWAY_INTERFACE']	CGI/1.1
68	$_SERVER['DOCUMENT_ROOT']	D:\UCenter_\wwwroot\shop
69	$_SERVER['CONTENT_TYPE']
70	$_SERVER['CONTENT_LENGTH']	0
71	$_SERVER['CERT_SUBJECT']
72	$_SERVER['CERT_SERIALNUMBER']
73	$_SERVER['CERT_ISSUER']
74	$_SERVER['CERT_FLAGS']
75	$_SERVER['CERT_COOKIE']
76	$_SERVER['AUTH_USER']
77	$_SERVER['AUTH_PASSWORD']
78	$_SERVER['AUTH_TYPE']
79	$_SERVER['APPL_PHYSICAL_PATH']	D:\UCenter_\wwwroot\shop\
80	$_SERVER['APPL_MD_PATH']	/LM/W3SVC/2/ROOT
81	$_SERVER['IIS_UrlRewriteModule']	7.1.1980.0
82	$_SERVER['HTTP_UPGRADE_INSECURE_REQUESTS']	1
83	$_SERVER['HTTP_USER_AGENT']	Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36
84	$_SERVER['HTTP_REFERER']	http://localhost/home/space.php?do=home
85	$_SERVER['HTTP_HOST']	localhost
86	$_SERVER['HTTP_COOKIE']	pma_lang=zh_CN; pma_collation_connection=utf8_unicode_ci; RFaw_2132_saltkey=Cv26oFVk; RFaw_2132_lastvisit=1532910433; pma_iv-1=zj4hZ8RrY75Ep7OlAQXkRQ%3D%3D; pmaUser-1=1CGG71Wnu3sFtX8IDrMtNw%3D%3D; PHPSESSID=l95ummcj6joh4b17du608jjl15; Hm_lvt_8cb2b52dc2b6f7c0a7ff6decd80187f7=1532888584,1532912770,1532945982,1533191716; uchome_loginuser=root; prohistoy=2xcf1xcfxcfxcfxcfxcfxcfxcf; uchome_space_top_show=1; uchome_space_top_credit=1; uchome_space_top_experience=1; Example_auth=594f92s4OqYqD6s8to8yXjQTCJ%2BR9l16Qu3p%2F2PCcgD4qME; uchome_auth=ece5ryhCeG2YLIkxmBm4zlOVRgpnIgplemrWSWsP72ysdVtOAeaUIXfzFUZvrdp%2BxjdIjAk4zkLDgEPI9kMx; RFaw_2132_sid=sn7r7d; RFaw_2132_lastact=1533212701%09uc.php%09; uchome_space_top_friendnum=1; uchome_space_top_viewnum=2; read_feed_ids=21%2C14; uchome_pic_sequence=1; uchome_viewuids=3_4_5_6; uchome_synfriend=1; uchome_sendmail=1; Hm_lpvt_8cb2b52dc2b6f7c0a7ff6decd80187f7=1533236786; uchome_checkpm=1
87	$_SERVER['HTTP_ACCEPT_LANGUAGE']	zh-CN,zh;q=0.9
88	$_SERVER['HTTP_ACCEPT_ENCODING']	gzip, deflate, br
89	$_SERVER['HTTP_ACCEPT']	text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,/;q=0.8
90	$_SERVER['HTTP_CONNECTION']	keep-alive
91	$_SERVER['FCGI_ROLE']	RESPONDER
92	$_SERVER['PHP_SELF']	/home/space.php
93	$_SERVER['REQUEST_TIME_FLOAT']	1533236926.9852
94	$_SERVER['REQUEST_TIME']	1533236926