回复 2# 玻璃屋女孩
不登陆 首页 没提示·登陆后
http://my.bzcms.cn/space.php?do=home 或者其他页面 下面显示·
0.457 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
-
2
0.483 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
-
3
0.425 ms
SELECT * FROM uchome_userapp WHERE uid='1' ORDER BY menuorder DESC
Explain
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
uchome_userapp
ref
uid,menuorder,displayorder
menuorder
3
const
10
Using where
4
0.618 ms
UPDATE uchome_session SET `lastactivity`='1265006247' WHERE `uid`='1'
Info
Rows matched: 1 Changed: 1 Warnings: 0
5
0.744 ms
SELECT * FROM uchome_feed USE INDEX(dateline) WHERE uid IN ('0',6,14,12,10,15,13,11,9,8,7,5,2,3,4) ORDER BY dateline DESC LIMIT 0,100
Explain
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
uchome_feed
index
-
dateline
4
-
131
Using where
6
0.415 ms
SELECT COUNT(*) FROM uchome_report WHERE new='1'
Explain
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
-
-
-
-
-
-
-
Impossible WHERE noticed after reading const tables
7
0.394 ms
SELECT COUNT(*) FROM uchome_event WHERE grade='0'
Explain
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
-
-
-
-
-
-
-
Impossible WHERE noticed after reading const tables
8
0.345 ms
SELECT * FROM uchome_data WHERE var='newspacelist' LIMIT 1
Explain
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
uchome_data
const
PRIMARY
PRIMARY
42
const
1
-
9
0.362 ms
SELECT * FROM uchome_visitor WHERE uid='1' ORDER BY dateline DESC LIMIT 0,12
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
Using where
10
0.599 ms
SELECT * FROM uchome_session WHERE uid IN ('15','14','13','7')
Explain
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
-
-
-
-
-
-
-
Impossible WHERE noticed after reading const tables
11
0.602 ms
SELECT * FROM uchome_session WHERE uid IN (6,14,12,10,15,13,11,9,8,7,5,2,3,4) ORDER BY lastactivity DESC LIMIT 0,15
Explain
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
-
-
-
-
-
-
-
Impossible WHERE noticed after reading const tables
12
0.329 ms
SELECT fuid AS uid, fusername AS username, num FROM uchome_friend WHERE uid='1' AND status='1' ORDER BY num DESC, dateline DESC LIMIT 0,30
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
14
Using where
13
0.4 ms
SELECT * FROM uchome_usertask WHERE uid='1'
Explain
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
uchome_usertask
ref
PRIMARY
PRIMARY
3
const
3
-
14
0.341 ms
SELECT s.uid,s.username,s.name,s.namestatus,s.groupid,sf.birthyear,sf.birthmonth,sf.birthday FROM uchome_spacefield sf LEFT JOIN uchome_space s ON s.uid=sf.uid WHERE (sf.uid IN (6,14,12,10,15,13,11,9,8,7,5,2,3,4)) AND ((sf.birthmonth='1' AND sf.birthday>='29') OR (sf.birthmonth='2' AND sf.birthday<='8' AND sf.birthday>'0'))
Explain
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
sf
ALL
PRIMARY
-
-
-
15
Using where
15
0.957 ms
SELECT * FROM uchome_feed USE INDEX(hot) WHERE dateline>='1264833447' ORDER BY hot DESC LIMIT 0,10
Explain
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
uchome_feed
index
-
hot
3
-
131
Using where
16
0.339 ms
SELECT * FROM uchome_topic ORDER BY lastpost DESC LIMIT 0,1
Explain
id
select_type
table
type
possible_keys
key
key_len
ref
rows
Extra
1
SIMPLE
uchome_topic
system
-
-
-
-
-
const row not found
1
$_COOKIE['uchome_loginuser']
admintyty555
2
$_COOKIE['uchome_mytemplate']
green
3
$_COOKIE['uchome_sendmail']
1
4
$_COOKIE['uchome_checkpm']
1
5
$_COOKIE['PHPSESSID']
453as35kfv6llps669ogfqlrg4
6
$_COOKIE['uchome_auth']
c7c8UgNdZ4r2D2HZy48C+dn8sWRss3GXC8xJjZ/tA3nWAAUpHnmCtJeMVLeInplCmJr2FzDq386ytmpzjt/s
1
D:\wwwroot\uchome\web\space.php
2
D:\wwwroot\uchome\web\common.php
3
D:\wwwroot\uchome\web\ver.php
4
D:\wwwroot\uchome\web\config.php
5
D:\wwwroot\uchome\web\source\function_common.php
6
D:\wwwroot\uchome\web\source\class_mysql.php
7
D:\wwwroot\uchome\web\data\data_config.php
8
D:\wwwroot\uchome\web\data\data_app.php
9
D:\wwwroot\uchome\web\data\data_userapp.php
10
D:\wwwroot\uchome\web\data\data_ad.php
11
D:\wwwroot\uchome\web\data\data_magic.php
12
D:\wwwroot\uchome\web\data\data_usergroup_1.php
13
D:\wwwroot\uchome\web\source\space_feed.php
14
D:\wwwroot\uchome\web\source\function_space.php
15
D:\wwwroot\uchome\web\data\data_task.php
16
D:\wwwroot\uchome\web\language\lang_source.php
17
D:\wwwroot\uchome\web\data\tpl_cache\template_green_space_feed.php
18
D:\wwwroot\uchome\web\data\data_usergroup.php
19
D:\wwwroot\uchome\web\source\inc_debug.php
1
$_SERVER['ALL_HTTP']
HTTP_CONNECTION:Keep-Alive HTTP_ACCEPT:*/* HTTP_ACCEPT_ENCODING:gzip, deflate HTTP_ACCEPT_LANGUAGE:zh-cn HTTP_COOKIE:uchome_loginuser=admin; uchome_mytemplate=green; uchome_sendmail=1; uchome_checkpm=1; PHPSESSID=453ae35kfv6llpsg69ogfqlrg4; uchome_auth=c7c8UgNdZ4r2D2HZy48C%2Bdn8sWRss3GXC8xJjZ%2FtA3nWAAUpHnmCtJeMVLeInplCmJr2FzDq386ytmpzjt%2Fs HTTP_HOST:my.bzcms.cn HTTP_REFERER:http://my.bzcms.cn/space.php?do=home HTTP_USER_AGENT:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; TencentTraveler 4.0) HTTP_X_REWRITE_URL:/space.php?do=home
2
$_SERVER['HTTPS']
off
3
$_SERVER['SCRIPT_NAME']
/space.php
4
$_SERVER['HTTP_COOKIE']
uchome_loginuser=admintyty555; uchome_mytemplate=green; uchome_sendmail=1; uchome_checkpm=1; PHPSESSID=453ae35kfv6llpsg69ogfqlrg4; uchome_auth=c7c8UgNdZ4r2D2HZy48C%2Bdn8sWRss3GXC8xJjZ%2FtA3nWAAUpHnmCtJeMVLeInplCmJr2FzDq386ytmpzjt%2Fs
5
$_SERVER['AUTH_PASSWORD']
6
$_SERVER['AUTH_TYPE']
7
$_SERVER['AUTH_USER']
8
$_SERVER['CONTENT_LENGTH']
0
9
$_SERVER['CONTENT_TYPE']
10
$_SERVER['PATH_TRANSLATED']
D:\wwwroot\uchome\web
11
$_SERVER['QUERY_STRING']
do=home
12
$_SERVER['REMOTE_ADDR']
124.132.26.180
13
$_SERVER['REMOTE_HOST']
124.132.26.180
14
$_SERVER['REMOTE_USER']
15
$_SERVER['REQUEST_METHOD']
GET
16
$_SERVER['SERVER_NAME']
my.bzcms.cn
17
$_SERVER['SERVER_PORT']
80
18
$_SERVER['SERVER_PROTOCOL']
HTTP/1.1
19
$_SERVER['SERVER_SOFTWARE']
Microsoft-IIS/6.0
20
$_SERVER['APPL_MD_PATH']
/LM/W3SVC/99990062/root
21
$_SERVER['APPL_PHYSICAL_PATH']
D:\wwwroot\uchome\web\
22
$_SERVER['INSTANCE_ID']
99990062
23
$_SERVER['INSTANCE_META_PATH']
/LM/W3SVC/99990062
24
$_SERVER['LOGON_USER']
25
$_SERVER['REQUEST_URI']
/space.php?do=home
26
$_SERVER['URL']
/space.php?do=home
27
$_SERVER['SCRIPT_FILENAME']
D:\wwwroot\uchome\web\space.php
28
$_SERVER['ORIG_PATH_INFO']
/space.php
29
$_SERVER['PATH_INFO']
30
$_SERVER['ORIG_PATH_TRANSLATED']
D:\wwwroot\uchome\web\space.php
31
$_SERVER['DOCUMENT_ROOT']
D:\wwwroot\uchome\web
32
$_SERVER['PHP_SELF']
/space.php
33
$_SERVER['HTTP_CONNECTION']
Keep-Alive
34
$_SERVER['HTTP_ACCEPT']
*/*
35
$_SERVER['HTTP_ACCEPT_ENCODING']
gzip, deflate
36
$_SERVER['HTTP_ACCEPT_LANGUAGE']
zh-cn
37
$_SERVER['HTTP_HOST']
my.bzcms.cn
38
$_SERVER['HTTP_REFERER']
http://my.bzcms.cn/space.php?do=home
39
$_SERVER['HTTP_USER_AGENT']
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; TencentTraveler 4.0)
40
$_SERVER['HTTP_X_REWRITE_URL']
/space.php?do=home
41
$_SERVER['REQUEST_TIME']
1265006247
42
$_SERVER['argv']
Array
43
$_SERVER['argc']
1 |