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

SQL History (60)

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

• 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 = '9c3e328a8669628460e30fe80f0f8c19' LIMIT 0, 1
• Time:0.002218

• 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='9c3e328a8669628460e30fe80f0f8c19',uid='0',ip_address='104.167.77.90',content='',last_time='1775844365',last_url='/ask/3442.html',is_mobile='0',user_agent='Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko'
• Time:0.003003
• Query4:SELECT *,m.groupid FROM modoer_asks a left join modoer_members m ON (a.uid = m.uid) WHERE askid = '3442' LIMIT 0, 1
• Time:0.002309

• 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 = '3442'
• Time:0.002824
• Query6:SELECT a.*,m.groupid FROM modoer_ask_answer a left join modoer_members m ON (a.uid = m.uid) WHERE askid = '3442' AND bestanswer = '0' AND status = '1' ORDER BY a.dateline DESC LIMIT 0, 20
• Time:0.002301

• 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_subject WHERE sid = '10619' LIMIT 0, 1
• Time:0.002221

• 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

• Query8:SELECT * FROM modoer_subject_my WHERE sid = '10619' LIMIT 0, 1
• Time:0.002237

• 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

• Query9:SELECT * FROM modoer_subjectgrade
• Time:0.002182

• id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
  1	SIMPLE	modoer_subjectgrade		ALL					1	100.00

• Query10:SELECT * FROM modoer_category WHERE pid = '745'
• 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	4	100.00

• Query11:SELECT * FROM modoer_category WHERE pid = '747'
• Time:0.002180

• 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 = '754'
• Time:0.002179

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

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

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

• 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

• Query16:SELECT * FROM modoer_category WHERE pid = '765'
• Time:0.002186

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

• Query18:SELECT * FROM modoer_category WHERE pid = '767'
• Time:0.002209

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

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

• 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

• Query21:SELECT * FROM modoer_category WHERE pid = '776'
• Time:0.002230

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

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

• Query24:SELECT * FROM modoer_category WHERE pid = '779'
• Time:0.002187

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

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

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

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

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

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

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

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

• Query33:SELECT * FROM modoer_category WHERE pid = '788'
• Time:0.002581

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

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

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

• Query37:SELECT * FROM modoer_category WHERE pid = '792'
• 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

• Query38:SELECT * FROM modoer_category WHERE pid = '793'
• Time:0.002305

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

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

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

• 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

• Query42:SELECT * FROM modoer_category WHERE pid = '875'
• Time:0.002193

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

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

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

• 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

• Query46:SELECT * FROM modoer_category WHERE pid = '770'
• 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

• Query47:SELECT * FROM modoer_category WHERE pid = '771'
• Time:0.002203

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

• Query49:SELECT * FROM modoer_category WHERE pid = '773'
• Time:0.002242

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

• Query51:SELECT * FROM modoer_category WHERE pid = '775'
• Time:0.002292

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

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

• Query54:SELECT * FROM modoer_category WHERE pid = '755'
• Time:0.002215

• 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

• Query55:SELECT * FROM modoer_category WHERE pid = '756'
• 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

• Query56:SELECT * FROM modoer_category WHERE pid = '757'
• Time:0.002195

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

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

• 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 * FROM modoer_category WHERE pid = '794'
• 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

• Query60:SELECT askid,subject,expiredtime,dateline FROM modoer_asks WHERE success=0 AND status=1 AND expiredtime>1775844365 AND city_id IN (0,2943) ORDER BY dateline DESC LIMIT 0,8
• Time:0.004479

• 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 (33)

• 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/modules/item/model/itembase_class.php
• core/modules/item/model/subject_class.php
• core/modules/item/model/field_class.php
• core/modules/item/model/category_class.php
• core/model/fielddetail_class.php
• core/modules/item/model/fielddetail_class.php
• core/lib/mxml.php
• core/modules/item/component/grade_class.php
• core/modules/item/model/grade_class.php
• core/lib/template.php
• core/model/area_class.php

file included_files (94)

• 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/modules/item/model/subject_class.php
• core/modules/item/model/itembase_class.php
• core/modules/item/model/field_class.php
• core/modules/item/model/fields/typelist.php
• core/helper/sql.php
• data/cachefiles/item_config.php
• core/modules/item/model/category_class.php
• data/cachefiles/item_category_rel.php
• data/cachefiles/item_category.php
• data/cachefiles/item_model_23.php
• data/cachefiles/item_field_23.php
• core/modules/item/model/fielddetail_class.php
• core/model/fielddetail_class.php
• core/lang/CH/item.php
• core/lib/mxml.php
• core/helper/passport.php
• core/modules/item/component/grade_class.php
• core/modules/item/inc/variable.php
• core/modules/item/model/grade_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
• 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 (10)

• core/helper/cache.php
• core/helper/sql.php
• core/helper/passport.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 (28)

• ./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
• core/modules/item/model/fields/typelist.php
• ./data/cachefiles/item_config.php
• ./data/cachefiles/item_category_rel.php
• ./data/cachefiles/item_category.php
• ./data/cachefiles/item_model_23.php
• ./data/cachefiles/item_field_23.php
• ./data/cachefiles/modoer_templates.php
• ./data/cachefiles/modoer_menu_1.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' => '1775844084', 'update_time' => '1775844084', 'expire_time' => '0', )
• array ( 'cache_key' => 'comm_session_expire', 'cache_value' => '1775844084', 'update_time' => '1775844084', 'expire_time' => '0', )
• array ( 'cache_key' => 'comm_session_online', 'cache_value' => '16890 1775844084', 'update_time' => '1775844084', 'expire_time' => '0', )
• array ( 'cache_key' => 'comm_task_nexttime', 'cache_value' => '1775849400', 'update_time' => '1775844084', 'expire_time' => '0', )

input GET (6)

• Pathinfo = ask/3442.html
• m = ask
• act = detail
• id = 3442
• page = 1
• offset = 20