<code id="ekucy"></code>

SQL History (57)

• Connect MySQL
• Time:0.015247
• Query1:SELECT * FROM modoer_dbcache WHERE cache_key IN ('comm_dbcache_expire','comm_task_nexttime','comm_session_expire','comm_session_online')
• Time:0.002255

• 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 = '2caf4e37df4d3cd7508f554a8b2d5889' LIMIT 0, 1
• Time:0.002107

• id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
  1	SIMPLE										no matching row in const table

• Exec 3:INSERT modoer_session SET uniq='2caf4e37df4d3cd7508f554a8b2d5889',uid='0',ip_address='104.167.77.90',content='',last_time='1775693498',last_url='/ask/78422.html',is_mobile='0',user_agent='Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko'
• Time:0.002939
• Query4:SELECT *,m.groupid FROM modoer_asks a left join modoer_members m ON (a.uid = m.uid) WHERE askid = '78422' LIMIT 0, 1
• Time:0.002234

• 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 5:UPDATE modoer_asks SET views=views+'1' WHERE askid = '78422'
• Time:0.002838
• Query6:SELECT a.*,m.groupid FROM modoer_ask_answer a left join modoer_members m ON (a.uid = m.uid) WHERE askid = '78422' AND bestanswer = '0' AND status = '1' ORDER BY a.dateline DESC LIMIT 0, 20
• Time:0.002233

• 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

• Query7:SELECT * FROM modoer_category WHERE pid = '745'
• Time:0.002142

• 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

• Query8:SELECT * FROM modoer_category WHERE pid = '747'
• Time:0.002064

• 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

• Query9:SELECT * FROM modoer_category WHERE pid = '754'
• Time:0.002075

• 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 = '769'
• Time:0.002050

• 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 = '871'
• Time:0.002080

• 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 = '704'
• Time:0.002157

• 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

• Query13:SELECT * FROM modoer_category WHERE pid = '765'
• Time:0.002098

• 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 = '766'
• Time:0.002072

• 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 = '767'
• Time:0.002097

• 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 = '768'
• Time:0.002071

• 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 = '282'
• Time:0.002156

• 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

• Query18:SELECT * FROM modoer_category WHERE pid = '776'
• Time:0.002058

• 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 = '777'
• Time:0.002135

• 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 = '778'
• Time:0.002127

• 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 = '779'
• Time:0.002093

• 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 = '780'
• Time:0.002079

• 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 = '781'
• Time:0.002075

• 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 = '782'
• Time:0.002066

• 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 = '783'
• Time:0.002076

• 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 = '784'
• Time:0.002038

• 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 = '785'
• Time:0.002114

• 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 = '786'
• Time:0.002056

• 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 = '787'
• Time:0.002069

• 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 = '788'
• Time:0.002086

• 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 = '789'
• Time:0.002103

• 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 = '790'
• Time:0.002084

• 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 = '791'
• Time:0.002070

• 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 = '792'
• Time:0.002056

• 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 = '793'
• Time:0.002072

• 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 = '810'
• Time:0.002082

• 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 = '811'
• Time:0.002080

• 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 = '752'
• Time:0.002125

• 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

• Query39:SELECT * FROM modoer_category WHERE pid = '875'
• Time:0.002112

• 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 = '876'
• Time:0.002124

• 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 = '877'
• Time:0.002083

• 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 = '750'
• Time:0.002085

• 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

• Query43:SELECT * FROM modoer_category WHERE pid = '770'
• Time:0.002076

• 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 = '771'
• Time:0.002062

• 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 = '772'
• Time:0.002107

• 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 = '773'
• Time:0.002077

• 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 = '774'
• Time:0.002169

• 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 = '775'
• Time:0.002116

• 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 = '806'
• Time:0.002083

• 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 = '874'
• Time:0.002035

• 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 = '755'
• Time:0.002190

• 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

• Query52:SELECT * FROM modoer_category WHERE pid = '756'
• Time:0.002103

• 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 = '757'
• Time:0.002118

• 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 = '758'
• Time:0.002096

• 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 = '726'
• Time:0.002076

• 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 = '794'
• Time:0.002163

• 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 askid,subject,expiredtime,dateline FROM modoer_asks WHERE success=0 AND status=1 AND expiredtime>1775693498 AND city_id IN (0,2943) ORDER BY dateline DESC LIMIT 0,8
• Time:0.004388

• 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

file autoload (25)

• core/lib/trace.php
• core/lib/activerecord.php
• core/lib/mysql.php
• core/lib/sqlbuild.php
• core/lib/base.php
• core/lib/model.php
• core/model/dbcache_class.php
• core/lib/cache.php
• core/model/session_class.php
• core/lib/hook.php
• core/lib/url.php
• core/lib/domain.php
• core/lib/module.php
• core/lib/subsite.php
• core/lib/city.php
• core/modules/member/model/user_class.php
• core/modules/member/model/login_class.php
• core/modules/member/model/member_class.php
• core/model/datacall_class.php
• core/lib/ipaddress.php
• core/modules/ask/model/ask_class.php
• core/modules/ask/model/answer_class.php
• core/lib/template.php
• core/modules/item/model/category_class.php
• core/model/area_class.php

file included_files (78)

• index.php
• core/init.php
• data/config.php
• core/version.php
• core/function.php
• core/loader.php
• core/lib/trace.php
• core/helper/cache.php
• core/lib/activerecord.php
• core/lib/mysql.php
• core/lib/sqlbuild.php
• core/model/dbcache_class.php
• core/lib/model.php
• core/lib/base.php
• core/lib/cache.php
• data/cachefiles/modoer_modules.php
• data/cachefiles/modoer_config.php
• core/model/session_class.php
• core/lib/hook.php
• core/modules/item/inc/hook.php
• core/modules/article/inc/hook.php
• core/modules/review/inc/hook.php
• core/modules/weixin/inc/hook.php
• core/modules/comment/inc/hook.php
• data/cachefiles/comment_config.php
• core/modules/member/inc/hook.php
• core/modules/mylist/inc/hook.php
• core/modules/ask/inc/hook.php
• core/lib/url.php
• core/lib/domain.php
• core/lib/module.php
• data/cachefiles/member_config.php
• core/lib/subsite.php
• core/lib/city.php
• data/cachefiles/modoer_area.php
• core/modules/member/model/user_class.php
• core/modules/member/model/login_class.php
• core/modules/member/model/member_class.php
• data/cachefiles/member_usergroup_1.php
• core/model/datacall_class.php
• core/modules/ask/common.php
• core/lib/ipaddress.php
• data/cachefiles/ask_config.php
• core/modules/ask/detail.php
• core/modules/ask/model/ask_class.php
• core/modules/ask/model/answer_class.php
• core/lib/template.php
• data/cachefiles/modoer_templates.php
• data/templates/main/blue_ask_detail.htm.php
• core/modules/ask/helper/misc.php
• data/templates/main/blue_modoer_header_ask1.htm.php
• baidu_js_push.php
• data/cachefiles/modoer_menu_1.php
• core/modules/item/helper/query.php
• core/modules/item/model/category_class.php
• data/cachefiles/item_config.php
• data/cachefiles/item_category_rel.php
• data/cachefiles/item_category_281.php
• data/datacall/14/cache_0_14d71035_a380d314.php
• data/datacall/84/cache_0_14d71035_c0c38d84.php
• data/datacall/fa/cache_0_14d71035_1cb088fa.php
• data/datacall/d4/cache_0_14d71035_8160f6d4.php
• data/datacall/cb/cache_0_14d71035_e5a361cb.php
• data/datacall/7b/cache_0_14d71035_514a087b.php
• data/datacall/f9/cache_0_14d71035_c40fe8f9.php
• core/helper/query.php
• core/helper/display.php
• core/model/area_class.php
• data/cachefiles/modoer_area_rel.php
• data/cachefiles/ask_category.php
• core/modules/ask/helper/display.php
• core/modules/member/helper/display.php
• data/cachefiles/member_usergroup.php
• data/templates/main/blue_ask_answer_post_v2.htm.php
• data/datacall/0b/cache_0_14d71035_4dfe7e0b.php
• data/datacall/a9/cache_0_8b45d156_5bb876a9.php
• core/modules/item/helper/display.php
• data/templates/main/blue_modoer_footer_v2.htm.php

helper include (8)

• core/helper/cache.php
• core/modules/ask/helper/misc.php
• core/modules/item/helper/query.php
• core/helper/query.php
• core/helper/display.php
• core/modules/ask/helper/display.php
• core/modules/member/helper/display.php
• core/modules/item/helper/display.php

cache load (24)

• ./data/cachefiles/modoer_modules.php
• ./data/cachefiles/modoer_config.php
• ./data/cachefiles/comment_config.php
• ./data/cachefiles/member_config.php
• ./data/cachefiles/modoer_area.php
• ./data/cachefiles/member_usergroup_1.php
• ./data/cachefiles/ask_config.php
• ./data/cachefiles/modoer_templates.php
• ./data/cachefiles/modoer_menu_1.php
• ./data/cachefiles/item_config.php
• ./data/cachefiles/item_category_rel.php
• ./data/cachefiles/item_category_281.php
• data/datacall/14/cache_0_14d71035_a380d314.php
• data/datacall/84/cache_0_14d71035_c0c38d84.php
• data/datacall/fa/cache_0_14d71035_1cb088fa.php
• data/datacall/d4/cache_0_14d71035_8160f6d4.php
• data/datacall/cb/cache_0_14d71035_e5a361cb.php
• data/datacall/7b/cache_0_14d71035_514a087b.php
• data/datacall/f9/cache_0_14d71035_c40fe8f9.php
• ./data/cachefiles/modoer_area_rel.php
• ./data/cachefiles/ask_category.php
• ./data/cachefiles/member_usergroup.php
• data/datacall/0b/cache_0_14d71035_4dfe7e0b.php
• data/datacall/a9/cache_0_8b45d156_5bb876a9.php

cache dbcache (4)

• array ( 'cache_key' => 'comm_dbcache_expire', 'cache_value' => '1775691871', 'update_time' => '1775691871', 'expire_time' => '0', )
• array ( 'cache_key' => 'comm_session_expire', 'cache_value' => '1775693073', 'update_time' => '1775693073', 'expire_time' => '0', )
• array ( 'cache_key' => 'comm_session_online', 'cache_value' => '4490 1775693189', 'update_time' => '1775693189', 'expire_time' => '0', )
• array ( 'cache_key' => 'comm_task_nexttime', 'cache_value' => '1775752200', 'update_time' => '1775691871', 'expire_time' => '0', )

input GET (5)

• m = ask
• act = detail
• id = 78422
• page = 1
• offset = 20