MESSE09: MPC5000 Version 2

Debugging Information

/news/news2.cfm (/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news2.cfm)

User Agent:

Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

Lucee (Gelert) Os 5.4.5.23 (CFML Version 2016,0,03,300357)
Time Stamp	Apr 23, 2024 3:40 PM
Time Zone	UTC
Locale	English (us)
Remote IP	127.0.0.1
Host Name	sonicstate.com
Architecture	64bit

Execution Time

92.9 ms Total

0.185 ms	Startup/Compilation
-1.285 ms	Application
93.9 ms	Query

Templates

17 Templates Executed

Total (ms)	Load (ms)	App (ms)	Query (ms)	Count	Average (ms)	Template	Order
23.2	0.014	0	41.8	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news2.cfm	5
18.5	0.01	4.56	13.9	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	17
16.1	0.007	1.33	14.8	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/comp_listing.cfm	14
12.2	0.01	4.12	8.09	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/video/show_vids_jw.cfm	9
7.65	0.011	0.35	7.29	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/aff_search/more_aff.cfm	10
7.38	0.011	0.15	7.21	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/man_social.cfm	11
2.13	0.005	1.47	0.656	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	16
4.96	0.051	4.91	0	3	1.63	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news_nav.cfm	7
0.221	0.001	0.22	0	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/nav/settings/news.cfm	2
0.138	0.002	0.136	0	2	0.068	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/nav/cookin_.cfm	4
0.058	0.018	0.04	0	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/nammfooter.cfm	12
0.03	0.01	0.02	0	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/ads/newzz/zz_15.cfm	13
0.011	0	0.01	0	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/nav/settings/server_settings.cfm	3
0.019	0.009	0.009	0	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/m/mail_box.cfm	15
0.013	0.005	0.007	0	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/mobile2/mob_detect.cfm	6
0.006	0.002	0.003	0	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/nav/ga_code.cfm	8
0.01	0.01	0	0	1	-	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/Application.cfm	1

Implicit Variable Access

45 Implicit Variable Accesses

Template	Line	Scope	Var	Count
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/comp_listing.cfm	20	query	CDATE	10
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/comp_listing.cfm	20	query	SLUG	5
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/comp_listing.cfm	20	query	HEADLINE	5
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news2.cfm	207	query	NTYPE	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news2.cfm	207	query	NTYPE2	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news_nav.cfm	292	query	SLUG	13
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news_nav.cfm	292	query	CATEGORYTEXT	13
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	66	query	CURRENTROW	5
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	67	query	YTID	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	68	query	YTID	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	70	query	FEATURED	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	73	query	PIC1	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	74	query	NEWSID	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	75	query	PIC1	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	82	query	AUD	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	82	query	VID	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	95	query	CDATE	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	95	query	SLUG	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	100	query	CDATE	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	100	query	SLUG	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	100	query	HEADLINE	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	107	query	CDATE	4
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	107	query	HEADLINE	4
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	107	query	SLUG	4
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	54	query	CURRENTROW	20
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	117	query	YTID	6
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	118	query	YTID	2
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	120	query	FEATURED	6
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	121	query	YTID	5
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	124	query	PIC1	6
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	125	query	PIC1	6
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	127	query	VID	6
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	127	query	AUD	6
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	130	query	NEWSID	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	133	query	PIC1	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	141	query	CDATE	6
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	141	query	AMPED	6
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	141	query	SLUG	6
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	142	query	HEADLINE	11
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	144	query	HEADLINE	4
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	147	query	STRAP	6
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/video/show_vids_jw.cfm	128	query	MP4	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/video/show_vids_jw.cfm	149	query	MP3	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/video/show_vids_jw.cfm	154	query	DL	1
/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/video/show_vids_jw.cfm	168	query	DURATION	3

Datasource Information

16 Queries Executed (Total Records: 109; Total Time: 93.9 ms; Total Open Connections: 3)

General

Name	Open Connections	Max Connections
do_mysql	3	INF

SQL Queries

	Name	Records	Time	Usage	Datasource	Source	Line	Cached
	ncats	25	0 ms	33%	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news2.cfm	5	Yes
SQL select * from news_cat Query column usage the following columns are NOT used: keywords categorytext descr zone
	variables.list	1	14.2 ms	70%	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news2.cfm	11	No
SQL select news_items.multipage ,news_items.ialign ,news_items.icaption , news_items.live_blog,news_items.lb_startid, news_items.tz ,news_items.lb_vote, news_items.story , news_items.gallery , news_items.amped , news_items.rrp , news_items.ytid , news_items.lb_status , news_items.social_headline , news_items.newsid , news_items.slug , news_items.cdate , news_items.aff_box , news_items.has_poll , news_items.keywords , news_items.text1 , news_items.headline , news_items.ntype ,news_items.ntype2, news_items.thumbonly , news_items.manid , news_items.strap , news_items.pic1 , news_items.vid , news_items.release , news_items.aud, news_cat.slug as cslug, news_cat.categorytext, news_cat.keywords as catkeys from news_items,news_cat where news_items.active = 1 and DATE_FORMAT(news_items.cdate,'%Y/%m/%d') = '2009/04/03' AND news_items.ntype=news_cat.catid AND news_items.slug = 'messe09-mpc5000-v2' order by cdate desc limit 0,1 Query column usage the following columns are NOT used: lb_startid lb_vote tz catkeys thumbonly social_headline cslug icaption ialign aud
	getmedia	1	13.7 ms	0%	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news2.cfm	53	No
SQL select * from rich_media where frn_newsid=8289 and isactive=1 limit 0,1 Query column usage None of the columns are used
		0	13.7 ms	-	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news2.cfm	130	No
SQL insert into page_count_temp set frn_newsid =8289
	menu	13	0 ms	33%	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news_nav.cfm	281	Yes
SQL SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ; select * from news_cat where zone='gen' order by catid asc Limit 0,13 ;SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ ; Query column usage the following columns are NOT used: keywords descr zone catid
	sourceparams	1	0.13 ms	100%		/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/news2.cfm	205	No
SQL Select slug from ncats where catid=1 Query column usage All columns are used
	getmedia	1	8.09 ms	20%	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/video/show_vids_jw.cfm	7	No
SQL select id,frn_newsid, frn_article_id, frn_synthid, frn_modelid,frn_manid, vfile, hi, lo, isactive, mcaption, summary, isaudio, ram, mov, wmv, mp4, mp3, flv, ytid, utube, wav, toptail, zoom, dl, duration, poster_img_4040, soniclab, feature, dv, showvid, showprefix,showprefix, featured, trackinglink, ptime from rich_media where frn_newsid= 8289 and isactive=1 Query column usage the following columns are NOT used: isaudio isactive mov dv ptime zoom showprefix lo showvid trackinglink frn_modelid wmv ram frn_synthid wav hi frn_newsid soniclab id poster_img_4040 frn_manid frn_article_id featured utube summary feature toptail mcaption
	rml	0	7.29 ms	0%	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/aff_search/more_aff.cfm	50	No
SQL SELECT vendor_link as prodlink,frn_newsid,vendor,frn_manid,vendor as vendor_id from ret_links WHERE ret_links.frn_newsid=8289 Query column usage None of the columns are used
	manlinks	0	7.21 ms	0%	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/man_social.cfm	2	No
SQL select * from s_id_man where manid=0 Query column usage None of the columns are used
	colist	5	14.8 ms	20%	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/comp_listing.cfm	3	No
SQL SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ; select news_items.comm_count,news_items.featured,news_items.headline,news_items.ntype, news_items.ntype2, news_items.strap, news_items.newsid, news_items.ytid,news_items.pic1, news_items.manid, news_items.cdate,news_items.aud,news_items.vid,news_items.ntype,news_items.slug,news_items.active from news_items where active=1 and text1='' and newsid <> 8289 order by cdate desc limit 0,5 ;SET SESSION TRANSACTION ISOLATION LEVEL REPEATABLE READ ; Query column usage the following columns are NOT used: ytid ntype2 newsid comm_count vid pic1 ntype active featured aud manid strap
	more_list	30	0 ms	100%	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	29	Yes
SQL select news_items.comm_count,news_items.featured,news_items.headline,news_items.ntype, news_items.ntype2, news_items.strap, news_items.newsid, news_items.ytid,news_items.pic1, news_items.manid, news_items.cdate,news_items.aud,news_items.vid,news_items.ntype,news_items.slug,news_items.active from news_items where news_items.active=1 and news_items.amped <> 1 group by news_items.newsid order by news_items.cdate desc limit 0,30 Query column usage All columns are used
	q	5	0.656 ms	60%		/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/related.cfm	56	No
SQL SELECT * FROM more_list WHERE newsid IN('39531','39547','39558','39536','39534','39536') Query column usage the following columns are NOT used: ntype2 comm_count ntype active manid strap
	n_popvideos	20	0 ms	92%	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	44	Yes
SQL select sticky, featured,news_items.headline,news_items.strap,news_items.pic1,news_items.slug,news_items.newsid,news_items.cdate,news_items.amped, news_items.vid,news_items.aud,news_items.ytid,news_items.views, '' as sorter from news_items where active=1 and (featured=1 or cat_feature=1) and ytid <> 'NULL' and news_items.cdate between date_sub(now(),INTERVAL 70 DAY) and now() Query column usage the following columns are NOT used: sticky
	sticky_vid2	0	0 ms	0%	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	57	Yes
SQL select featured,headline,strap,pic1,slug,newsid,cdate,amped, vid,aud,ytid,views from news_items where active=1 and sticky =1 Query column usage None of the columns are used
	b_popvideos	6	0.208 ms	91%		/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	63	No
SQL select featured,headline,strap,pic1,slug,newsid,cdate,amped, vid,aud,ytid,views from n_popvideos order by sorter Query column usage the following columns are NOT used: views
	isvid	1	13.7 ms	0%	do_mysql	/opt/lucee/tomcat/webapps/sonicstate/sonicstate.com/news/tools/side_videos.cfm	128	No
SQL select vfile from rich_media where frn_newsid=39496 limit 0,1 Query column usage None of the columns are used

Before you go.
Sonicstate have just launched a weekly newsletter, sign up for for the latest news, exclusive offers and more here..

MESSE09: MPC5000 Version 2

Want Our Newsletter?

More Stories:

More...

Before you go. Sonicstate have just launched a weekly newsletter, sign up for for the latest news, exclusive offers and more here..

MESSE09: MPC5000 Version 2

Want Our Newsletter?

More Stories:

More...

Before you go.
Sonicstate have just launched a weekly newsletter, sign up for for the latest news, exclusive offers and more here..