户口迁入_

SQL History (58)

Connect MySQL
Time:0.017186
Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002366
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_dbcache range PRIMARY PRIMARY 600 4 100.00 Using where
Query2:SELECT * FROM modoer_session WHERE uniq = 'aca1b8044a4504dd1b85ae20ecb39db4' LIMIT 0, 1
Time:0.002360
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_session const uniq uniq 96 const 1 100.00
Query3:SELECT *,m.groupid FROM modoer_asks a left join modoer_members m ON (a.uid = m.uid) WHERE askid = '4377' LIMIT 0, 1
Time:0.002439
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE a const PRIMARY PRIMARY 4 const 1 100.00
Exec 4:UPDATE modoer_asks SET views=views+'1' WHERE askid = '4377'
Time:0.002942
Query5:SELECT * FROM modoer_subject WHERE sid = '11204' LIMIT 0, 1
Time:0.002361
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_subject const PRIMARY PRIMARY 3 const 1 100.00
Query6:SELECT * FROM modoer_subject_my WHERE sid = '11204' LIMIT 0, 1
Time:0.019658
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_subject_my const PRIMARY PRIMARY 3 const 1 100.00
Query7:SELECT * FROM modoer_subjectgrade
Time:0.002316
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_subjectgrade ALL 1 100.00
Query8:SELECT * FROM modoer_category WHERE pid = '745'
Time:0.002402
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 4 100.00
Query9:SELECT * FROM modoer_category WHERE pid = '747'
Time:0.003226
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query10:SELECT * FROM modoer_category WHERE pid = '754'
Time:0.002375
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query11:SELECT * FROM modoer_category WHERE pid = '769'
Time:0.002307
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query12:SELECT * FROM modoer_category WHERE pid = '871'
Time:0.002317
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query13:SELECT * FROM modoer_category WHERE pid = '704'
Time:0.002438
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 4 100.00
Query14:SELECT * FROM modoer_category WHERE pid = '765'
Time:0.004669
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query15:SELECT * FROM modoer_category WHERE pid = '766'
Time:0.002455
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query16:SELECT * FROM modoer_category WHERE pid = '767'
Time:0.002381
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query17:SELECT * FROM modoer_category WHERE pid = '768'
Time:0.002382
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query18:SELECT * FROM modoer_category WHERE pid = '282'
Time:0.008692
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 20 100.00
Query19:SELECT * FROM modoer_category WHERE pid = '776'
Time:0.002406
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query20:SELECT * FROM modoer_category WHERE pid = '777'
Time:0.002377
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query21:SELECT * FROM modoer_category WHERE pid = '778'
Time:0.002308
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query22:SELECT * FROM modoer_category WHERE pid = '779'
Time:0.002323
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query23:SELECT * FROM modoer_category WHERE pid = '780'
Time:0.002328
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query24:SELECT * FROM modoer_category WHERE pid = '781'
Time:0.002276
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query25:SELECT * FROM modoer_category WHERE pid = '782'
Time:0.002351
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query26:SELECT * FROM modoer_category WHERE pid = '783'
Time:0.002296
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query27:SELECT * FROM modoer_category WHERE pid = '784'
Time:0.002310
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query28:SELECT * FROM modoer_category WHERE pid = '785'
Time:0.002351
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query29:SELECT * FROM modoer_category WHERE pid = '786'
Time:0.004266
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query30:SELECT * FROM modoer_category WHERE pid = '787'
Time:0.002971
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query31:SELECT * FROM modoer_category WHERE pid = '788'
Time:0.002316
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query32:SELECT * FROM modoer_category WHERE pid = '789'
Time:0.005155
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query33:SELECT * FROM modoer_category WHERE pid = '790'
Time:0.004986
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query34:SELECT * FROM modoer_category WHERE pid = '791'
Time:0.003085
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query35:SELECT * FROM modoer_category WHERE pid = '792'
Time:0.002337
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query36:SELECT * FROM modoer_category WHERE pid = '793'
Time:0.002366
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query37:SELECT * FROM modoer_category WHERE pid = '810'
Time:0.002369
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query38:SELECT * FROM modoer_category WHERE pid = '811'
Time:0.002290
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query39:SELECT * FROM modoer_category WHERE pid = '752'
Time:0.002383
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 3 100.00
Query40:SELECT * FROM modoer_category WHERE pid = '875'
Time:0.002361
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query41:SELECT * FROM modoer_category WHERE pid = '876'
Time:0.009787
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query42:SELECT * FROM modoer_category WHERE pid = '877'
Time:0.002526
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query43:SELECT * FROM modoer_category WHERE pid = '750'
Time:0.009965
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 8 100.00
Query44:SELECT * FROM modoer_category WHERE pid = '770'
Time:0.002510
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query45:SELECT * FROM modoer_category WHERE pid = '771'
Time:0.003848
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query46:SELECT * FROM modoer_category WHERE pid = '772'
Time:0.002518
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query47:SELECT * FROM modoer_category WHERE pid = '773'
Time:0.002647
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query48:SELECT * FROM modoer_category WHERE pid = '774'
Time:0.002301
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query49:SELECT * FROM modoer_category WHERE pid = '775'
Time:0.002317
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query50:SELECT * FROM modoer_category WHERE pid = '806'
Time:0.002243
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query51:SELECT * FROM modoer_category WHERE pid = '874'
Time:0.002519
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query52:SELECT * FROM modoer_category WHERE pid = '755'
Time:0.003285
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 3 100.00
Query53:SELECT * FROM modoer_category WHERE pid = '756'
Time:0.002322
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query54:SELECT * FROM modoer_category WHERE pid = '757'
Time:0.002338
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query55:SELECT * FROM modoer_category WHERE pid = '758'
Time:0.002280
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query56:SELECT * FROM modoer_category WHERE pid = '726'
Time:0.002410
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query57:SELECT * FROM modoer_category WHERE pid = '794'
Time:0.002365
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_category ref pid pid 3 const 1 100.00
Query58:SELECT askid,subject,expiredtime,dateline FROM modoer_asks WHERE success=0 AND status=1 AND expiredtime>1775688879 AND city_id IN (0,8587) ORDER BY dateline DESC LIMIT 0,8
Time:0.004481
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_asks ALL expiredtime 4037 0.20 Using where; Using filesort

我来回答：	回答即可获得积分，答案被采纳则获得悬赏分以及奖励 10 分。
	上传图片
参考资料：	如果您的答案是从其他地方引用，请表明出处。

工商服务

财会税务

资质审批

政府扶持

企业认证

知识产权

综合服务

户口迁入

SQL History (58)

file autoload (32)

file included_files (91)

helper include (9)

cache load (27)

cache dbcache (4)

input GET (5)

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	modoer_dbcache		range	PRIMARY	PRIMARY	600		4	100.00	Using where