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

SQL History (13)

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

• 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 = 'c71c555134c0ad3e17efe5a560d1d35d' LIMIT 0, 1
• Time:0.002177

• 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='c71c555134c0ad3e17efe5a560d1d35d',uid='0',ip_address='104.167.77.90',content='',last_time='1775697261',last_url='/article/82694.html',is_mobile='0',user_agent='Mozilla/5.0 (Windows NT 10.0; WOW64; Trident/7.0; rv:11.0) like Gecko'
• Time:0.002953
• Query4:SELECT * FROM modoer_articles a LEFT JOIN modoer_article_data ad ON (a.articleid = ad.articleid) WHERE a.articleid = '82694' LIMIT 0, 1
• Time:0.004540

• id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
  1	SIMPLE	a		const	PRIMARY	PRIMARY	3	const	1	100.00

• Exec 5:UPDATE modoer_articles SET pageview=pageview+'1' WHERE articleid = '82694'
• Time:0.003022
• Query6:SELECT * FROM modoer_subject WHERE sid = '98860' LIMIT 0, 1
• Time:0.002321

• 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_youhua WHERE sid = '98860' LIMIT 0, 1
• Time:0.002299

• id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
  1	SIMPLE	modoer_subject_youhua		const	PRIMARY,idx_sid	PRIMARY	3	const	1	100.00

• Query8:SELECT * FROM modoer_subjectgrade
• Time:0.002156

• 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 articleid,subject,thumb,catid,picture,dateline FROM modoer_articles WHERE status=1 AND havepic=1 AND city_id=2943 AND catid=134 AND articleid!=82694 ORDER BY pageview DESC LIMIT 0,4
• Time:0.002499

• id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
  1	SIMPLE	modoer_articles		range	PRIMARY,city_id,idx_city_id,idx_status_pic_city_pageview,idx_status_city_dateline	city_id	7		2	4.86	Using index condition; Using where; Using filesort

• Query10:SELECT askid,subject,expiredtime,dateline FROM modoer_asks WHERE success=0 AND status=1 AND expiredtime>1775697261 AND city_id IN (0,2943) ORDER BY dateline DESC LIMIT 0,5
• Time:0.004448

• 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

• Query11:SELECT * FROM modoer_subject WHERE sid = '98860' LIMIT 0, 1
• Time:0.002291

• 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

• Query12:SELECT * FROM modoer_subject_youhua WHERE sid = '98860' LIMIT 0, 1
• Time:0.002215

• id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
  1	SIMPLE	modoer_subject_youhua		const	PRIMARY,idx_sid	PRIMARY	3	const	1	100.00

• Query13:SELECT articleid,subject,catid,picture,introduce,thumb,dateline,digg,comments FROM modoer_articles WHERE status=1 AND havepic=1 AND city_id IN (0,2943) AND articleid!=82694 ORDER BY dateline DESC LIMIT 0,4
• Time:0.002493

• id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
  1	SIMPLE	modoer_articles		index	PRIMARY,city_id,idx_city_id,idx_status_pic_city_pageview,idx_status_city_dateline	idx_dateline	4		7	0.71	Using where; Backward index scan

file autoload (36)

• 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/lib/seo.php
• core/model/seosetting_class.php
• core/modules/article/model/seosetting_class.php
• core/modules/article/model/article_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/cutpage.php
• core/lib/template.php
• core/model/area_class.php

file included_files (89)

• 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/article/common.php
• core/lib/ipaddress.php
• data/cachefiles/article_config.php
• core/lib/seo.php
• core/modules/article/model/seosetting_class.php
• core/model/seosetting_class.php
• core/modules/article/detail.php
• core/modules/article/model/article_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_3.php
• data/cachefiles/item_field_3.php
• core/modules/item/model/fielddetail_class.php
• core/model/fielddetail_class.php
• core/lib/mxml.php
• core/modules/item/component/grade_class.php
• core/modules/item/inc/variable.php
• core/modules/item/model/grade_class.php
• core/lib/cutpage.php
• core/modules/article/helper/misc.php
• data/cachefiles/article_category.php
• core/lib/template.php
• data/cachefiles/modoer_templates.php
• data/templates/main/blue_article_detail.htm.php
• data/templates/main/blue_modoer_header_new.htm.php
• data/cachefiles/modoer_menu_1.php
• core/helper/query.php
• core/helper/display.php
• core/model/area_class.php
• data/cachefiles/modoer_area_rel.php
• core/lang/CH/global.php
• core/modules/adv/helper/display.php
• data/cachefiles/adv_place.php
• data/templates/block/adv_8.lock.php
• data/datacall/ca/cache_0_c8365697_054f3bca.php
• data/datacall/21/cache_0_14d71035_76973d21.php
• core/modules/item/helper/query.php
• data/cachefiles/modoer_area_7445.php
• data/cachefiles/item_category_258.php
• core/modules/article/helper/display.php
• data/templates/main/blue_modoer_footer_new.htm.php
• baidu_js_push.php

helper include (8)

• core/helper/cache.php
• core/helper/sql.php
• core/modules/article/helper/misc.php
• core/helper/query.php
• core/helper/display.php
• core/modules/adv/helper/display.php
• core/modules/item/helper/query.php
• core/modules/article/helper/display.php

cache load (22)

• ./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/article_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_3.php
• ./data/cachefiles/item_field_3.php
• ./data/cachefiles/article_category.php
• ./data/cachefiles/modoer_templates.php
• ./data/cachefiles/modoer_menu_1.php
• ./data/cachefiles/modoer_area_rel.php
• ./data/cachefiles/adv_place.php
• data/datacall/ca/cache_0_c8365697_054f3bca.php
• data/datacall/21/cache_0_14d71035_76973d21.php
• ./data/cachefiles/modoer_area_7445.php
• ./data/cachefiles/item_category_258.php

cache write (4)

• data/datacall/ec/cache_0_14d71035_ae0491ec.php
• data/datacall/7e/cache_0_14d71035_ca4a5c7e.php
• data/datacall/99/cache_0_8b45d156_44eb6299.php
• data/datacall/9e/cache_0_14d71035_f14bb69e.php

cache dbcache (4)

• array ( 'cache_key' => 'comm_dbcache_expire', 'cache_value' => '1775695472', 'update_time' => '1775695472', 'expire_time' => '0', )
• array ( 'cache_key' => 'comm_session_expire', 'cache_value' => '1775696675', 'update_time' => '1775696675', 'expire_time' => '0', )
• array ( 'cache_key' => 'comm_session_online', 'cache_value' => '3785 1775696721', 'update_time' => '1775696721', 'expire_time' => '0', )
• array ( 'cache_key' => 'comm_task_nexttime', 'cache_value' => '1775752200', 'update_time' => '1775695473', 'expire_time' => '0', )

input GET (5)

• m = article
• act = detail
• id = 82694
• page = 1
• offset = 20