海关完税凭证出现重号现象

SQL History (59)

Connect MySQL
Time:0.015997
Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
Time:0.002352
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.002265
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 = '4179' LIMIT 0, 1
Time:0.002407
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 = '4179'
Time:0.002972
Query5:SELECT a.*,m.groupid FROM modoer_ask_answer a left join modoer_members m ON (a.uid = m.uid) WHERE askid = '4179' AND bestanswer = '0' AND status = '1' ORDER BY a.dateline DESC LIMIT 0, 20
Time:0.002375
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE a ref dateline,askid dateline 3 const 1 5.00 Using where; Backward index scan
Query6:SELECT * FROM modoer_subject WHERE sid = '11759' LIMIT 0, 1
Time:0.002317
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
Query7:SELECT * FROM modoer_subject_my WHERE sid = '11759' LIMIT 0, 1
Time:0.008923
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
Query8:SELECT * FROM modoer_subjectgrade
Time:0.002253
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE modoer_subjectgrade ALL 1 100.00
Query9:SELECT * FROM modoer_category WHERE pid = '745'
Time:0.002299
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
Query10:SELECT * FROM modoer_category WHERE pid = '747'
Time:0.002258
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 = '754'
Time:0.002227
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 = '769'
Time:0.002332
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 = '871'
Time:0.002250
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
Query14:SELECT * FROM modoer_category WHERE pid = '704'
Time:0.002258
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
Query15:SELECT * FROM modoer_category WHERE pid = '765'
Time:0.002281
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 = '766'
Time:0.002286
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 = '767'
Time:0.002233
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 = '768'
Time:0.002231
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
Query19:SELECT * FROM modoer_category WHERE pid = '282'
Time:0.002314
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
Query20:SELECT * FROM modoer_category WHERE pid = '776'
Time:0.002312
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 = '777'
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
Query22:SELECT * FROM modoer_category WHERE pid = '778'
Time:0.003082
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 = '779'
Time:0.002315
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 = '780'
Time:0.002281
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 = '781'
Time:0.002273
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 = '782'
Time:0.002300
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 = '783'
Time:0.002335
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 = '784'
Time:0.002264
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 = '785'
Time:0.002279
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 = '786'
Time:0.002225
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 = '787'
Time:0.002274
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 = '788'
Time:0.002236
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 = '789'
Time:0.002294
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 = '790'
Time:0.002249
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 = '791'
Time:0.002331
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 = '792'
Time:0.002391
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 = '793'
Time:0.002306
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 = '810'
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 1 100.00
Query39:SELECT * FROM modoer_category WHERE pid = '811'
Time:0.002334
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
Query40:SELECT * FROM modoer_category WHERE pid = '752'
Time:0.002255
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
Query41:SELECT * FROM modoer_category WHERE pid = '875'
Time:0.002318
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 = '876'
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
Query43:SELECT * FROM modoer_category WHERE pid = '877'
Time:0.002339
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
Query44:SELECT * FROM modoer_category WHERE pid = '750'
Time:0.002339
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
Query45:SELECT * FROM modoer_category WHERE pid = '770'
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
Query46:SELECT * FROM modoer_category WHERE pid = '771'
Time:0.002278
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 = '772'
Time:0.002245
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 = '773'
Time:0.002275
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 = '774'
Time:0.002354
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 = '775'
Time:0.002297
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 = '806'
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
Query52:SELECT * FROM modoer_category WHERE pid = '874'
Time:0.002269
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
Query53:SELECT * FROM modoer_category WHERE pid = '755'
Time:0.002320
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
Query54:SELECT * FROM modoer_category WHERE pid = '756'
Time:0.002246
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 = '757'
Time:0.002303
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 = '758'
Time:0.002270
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 = '726'
Time:0.002304
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 * FROM modoer_category WHERE pid = '794'
Time:0.002274
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
Query59:SELECT askid,subject,expiredtime,dateline FROM modoer_asks WHERE success=0 AND status=1 AND expiredtime>1775688870 AND city_id IN (0,7175) ORDER BY dateline DESC LIMIT 0,8
Time:0.004590
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 (59)

file autoload (32)

file included_files (93)

helper include (10)

cache load (28)

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