Actualités


Debugging Information
ColdFusion Server Standard 11,0,15,311399
Template /journal_detail.cfm
Time Stamp 17-Feb-19 11:31 PM
Locale French (Belgian)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 107.23.176.162
Host Name 107.23.176.162


Execution Time

Total Time Avg Time Count Template
54 ms 54 ms 1 CFC[ E:/Sites/somzee.be/www/application.cfc | onRequest(/journal_detail.cfm) ] from E:/Sites/somzee.be/www/application.cfc
52 ms 52 ms 1 top level E:\Sites\somzee.be\www\journal_detail.cfm
17 ms 17 ms 1 E:/Sites/somzee.be/www/_widget_lastblogs.cfm
11 ms 11 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogs(status = true, BlogId = 102) ] from E:/Sites/somzee.be/www/somzee.cfc
8 ms 4 ms 2 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogComments(blogid = 102) ] from E:/Sites/somzee.be/www/somzee.cfc
8 ms 8 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogs(order = Blogs.datemodified desc, status = true) ] from E:/Sites/somzee.be/www/somzee.cfc
8 ms 8 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogs(order = Blogs.datemodified desc, status = true, top = 2) ] from E:/Sites/somzee.be/www/somzee.cfc
4 ms 4 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogComments(Order = id_blogcomments desc, Top = 2) ] from E:/Sites/somzee.be/www/somzee.cfc
4 ms 4 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogComments(status = true, blogid = 104) ] from E:/Sites/somzee.be/www/somzee.cfc
4 ms 4 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogComments(status = true, blogid = 105) ] from E:/Sites/somzee.be/www/somzee.cfc
4 ms 4 ms 1 E:/Sites/somzee.be/www/_form_comment.cfm
4 ms 4 ms 1 E:/Sites/somzee.be/www/_widget_lastcomments.cfm
1 ms 1 ms 1 E:/Sites/somzee.be/www/_footer.cfm
0 ms 0 ms 1 CFC[ E:/Sites/somzee.be/www/application.cfc | onRequestEnd(/journal_detail.cfm) ] from E:/Sites/somzee.be/www/application.cfc
0 ms 0 ms 1 CFC[ E:/Sites/somzee.be/www/application.cfc | onRequestStart(/journal_detail.cfm) ] from E:/Sites/somzee.be/www/application.cfc
0 ms 0 ms 1 CFC[ E:/Sites/somzee.be/www/application.cfc | onSessionStart() ] from E:/Sites/somzee.be/www/application.cfc
0 ms 0 ms 1 E:/Sites/somzee.be/www/_copyright.cfm
0 ms 0 ms 1 E:/Sites/somzee.be/www/_header.cfm
4 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
58 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

GetAllBlogs (Datasource=somzee, Time=10ms, Records=1) in E:\Sites\somzee.be\www\somzee.cfc @ 23:31:55.055
			SELECT  
			Blogs.id_blog
			, Blogs.uuid
			, Blogs.categid
			, Categories.categname
			, Categories.icon
			, Categories.group
			, Blogs.placeid
			, Blogs.title
			, Blogs.accesstype
			, Blogs.skills
			, Blogs.desc
			, Blogs.ref
			, Blogs.street
			, Blogs.number
			, Blogs.cityid
			, Blogs.begindate
			, Blogs.enddate
			, Blogs.blogdate
			, Blogs.datecreated
			, Blogs.datemodified
			, Blogs.createdbyid
            , Peoples.FirstName
            , Peoples.LastName
			, Blogs.modifiedbyid
			, Blogs.status
			
			FROM ((Categories RIGHT JOIN Blogs ON Categories.id_categories = Blogs.categid) LEFT JOIN Places ON Blogs.placeid = Places.id_places) LEFT JOIN Peoples ON Blogs.createdbyid = Peoples.id_peoples
			WHERE ( (1=1)
			
				AND Blogs.id_blog = ? 
			AND ((Blogs.status)=True)
									
			)
			
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 102

GetAllBlogs (Datasource=somzee, Time=7ms, Records=51) in E:\Sites\somzee.be\www\somzee.cfc @ 23:31:55.055
			SELECT  
			Blogs.id_blog
			, Blogs.uuid
			, Blogs.categid
			, Categories.categname
			, Categories.icon
			, Categories.group
			, Blogs.placeid
			, Blogs.title
			, Blogs.accesstype
			, Blogs.skills
			, Blogs.desc
			, Blogs.ref
			, Blogs.street
			, Blogs.number
			, Blogs.cityid
			, Blogs.begindate
			, Blogs.enddate
			, Blogs.blogdate
			, Blogs.datecreated
			, Blogs.datemodified
			, Blogs.createdbyid
            , Peoples.FirstName
            , Peoples.LastName
			, Blogs.modifiedbyid
			, Blogs.status
			
			FROM ((Categories RIGHT JOIN Blogs ON Categories.id_categories = Blogs.categid) LEFT JOIN Places ON Blogs.placeid = Places.id_places) LEFT JOIN Peoples ON Blogs.createdbyid = Peoples.id_peoples
			WHERE ( (1=1)
			
			AND ((Blogs.status)=True)
									
			)
			
				ORDER BY Blogs.datemodified desc 
GetCategories (Datasource=, Time=0ms, Records=8) in E:\Sites\somzee.be\www\journal_detail.cfm @ 23:31:55.055
select [group] as groupname, count(id_blog) as countofid
from GetBlogs
group by [group]
order by [group]
GetAllBlogComments (Datasource=somzee, Time=3ms, Records=0) in E:\Sites\somzee.be\www\somzee.cfc @ 23:31:55.055
			SELECT BlogComments.id_blogcomments, BlogComments.Blogid, BlogComments.peopleid, BlogComments.fullname, BlogComments.email, BlogComments.comment, BlogComments.status, BlogComments.createdate, Blogs.title
			FROM BlogComments LEFT JOIN Blogs ON BlogComments.blogid = Blogs.id_blog
			WHERE ( (1=1)
			
				AND BlogComments.Blogid = ? 							
			)
			
				ORDER BY createdate 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 102

GetAllBlogComments (Datasource=somzee, Time=4ms, Records=0) in E:\Sites\somzee.be\www\somzee.cfc @ 23:31:55.055
			SELECT BlogComments.id_blogcomments, BlogComments.Blogid, BlogComments.peopleid, BlogComments.fullname, BlogComments.email, BlogComments.comment, BlogComments.status, BlogComments.createdate, Blogs.title
			FROM BlogComments LEFT JOIN Blogs ON BlogComments.blogid = Blogs.id_blog
			WHERE ( (1=1)
			
				AND BlogComments.Blogid = ? 							
			)
			
				ORDER BY createdate 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 102

GetAllBlogs (Datasource=somzee, Time=8ms, Records=2) in E:\Sites\somzee.be\www\somzee.cfc @ 23:31:55.055
			SELECT TOP 2  
			Blogs.id_blog
			, Blogs.uuid
			, Blogs.categid
			, Categories.categname
			, Categories.icon
			, Categories.group
			, Blogs.placeid
			, Blogs.title
			, Blogs.accesstype
			, Blogs.skills
			, Blogs.desc
			, Blogs.ref
			, Blogs.street
			, Blogs.number
			, Blogs.cityid
			, Blogs.begindate
			, Blogs.enddate
			, Blogs.blogdate
			, Blogs.datecreated
			, Blogs.datemodified
			, Blogs.createdbyid
            , Peoples.FirstName
            , Peoples.LastName
			, Blogs.modifiedbyid
			, Blogs.status
			
			FROM ((Categories RIGHT JOIN Blogs ON Categories.id_categories = Blogs.categid) LEFT JOIN Places ON Blogs.placeid = Places.id_places) LEFT JOIN Peoples ON Blogs.createdbyid = Peoples.id_peoples
			WHERE ( (1=1)
			
			AND ((Blogs.status)=True)
									
			)
			
				ORDER BY Blogs.datemodified desc 
GetAllBlogComments (Datasource=somzee, Time=4ms, Records=0) in E:\Sites\somzee.be\www\somzee.cfc @ 23:31:55.055
			SELECT BlogComments.id_blogcomments, BlogComments.Blogid, BlogComments.peopleid, BlogComments.fullname, BlogComments.email, BlogComments.comment, BlogComments.status, BlogComments.createdate, Blogs.title
			FROM BlogComments LEFT JOIN Blogs ON BlogComments.blogid = Blogs.id_blog
			WHERE ( (1=1)
			
				AND BlogComments.Blogid = ? 
				AND BlogComments.status = ? 							
			)
			
				ORDER BY createdate 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 105
Parameter #2(cf_sql_bit) = YES

GetAllBlogComments (Datasource=somzee, Time=3ms, Records=2) in E:\Sites\somzee.be\www\somzee.cfc @ 23:31:55.055
			SELECT BlogComments.id_blogcomments, BlogComments.Blogid, BlogComments.peopleid, BlogComments.fullname, BlogComments.email, BlogComments.comment, BlogComments.status, BlogComments.createdate, Blogs.title
			FROM BlogComments LEFT JOIN Blogs ON BlogComments.blogid = Blogs.id_blog
			WHERE ( (1=1)
			
				AND BlogComments.Blogid = ? 
				AND BlogComments.status = ? 							
			)
			
				ORDER BY createdate 
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 104
Parameter #2(cf_sql_bit) = YES

GetAllBlogComments (Datasource=somzee, Time=3ms, Records=2) in E:\Sites\somzee.be\www\somzee.cfc @ 23:31:55.055
			SELECT TOP 2 BlogComments.id_blogcomments, BlogComments.Blogid, BlogComments.peopleid, BlogComments.fullname, BlogComments.email, BlogComments.comment, BlogComments.status, BlogComments.createdate, Blogs.title
			FROM BlogComments LEFT JOIN Blogs ON BlogComments.blogid = Blogs.id_blog
			WHERE ( (1=1)
										
			)
			
				ORDER BY id_blogcomments desc 


Scope Variables

Application Variables:
applicationname=somzee.be
captchakey=S0mz33
doc_path=
lastdate=0
query_cachedwithin=0.0416666666667
query_db=somzee
site_path=E:\Sites\somzee.be\www\
site_url=http://www.somzee.be/
suppresserrors=False
tomail=didier.nactergal@gmail.com
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=E:\Sites\somzee.be\www\journal_detail.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=somzee.be
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=www.somzee.be
PATH_INFO=
PATH_TRANSLATED=E:\Sites\somzee.be\www\journal_detail.cfm
QUERY_STRING=blogid=102
REMOTE_ADDR=107.23.176.162
REMOTE_HOST=107.23.176.162
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/journal_detail.cfm
SERVER_NAME=somzee.be
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/8.5
WEB_SERVER_API=
Client Variables:
cfid=1710675
cftoken=c7d6893a8e2ebb21-E7DF8569-FA16-3E97-89931468BADD8931
hitcount=1
lastvisit={ts '2019-02-17 23:31:55'}
timecreated={ts '2019-02-17 23:31:55'}
urltoken=CFID=1710675&CFTOKEN=c7d6893a8e2ebb21-E7DF8569-FA16-3E97-89931468BADD8931
Cookie Variables:
CFID=1710675
CFTOKEN=c7d6893a8e2ebb21-E7DF8569-FA16-3E97-89931468BADD8931
Request Parameters:
__FusionReactor=YES
Session Variables:
cfid=1710675
cftoken=c7d6893a8e2ebb21-E7DF8569-FA16-3E97-89931468BADD8931
language=FR
member=0
responsible=0
sessionid=SOMZEE.BE_1710675_c7d6893a8e2ebb21-E7DF8569-FA16-3E97-89931468BADD8931
urltoken=CFID=1710675&CFTOKEN=c7d6893a8e2ebb21-E7DF8569-FA16-3E97-89931468BADD8931
userblogid=0
useremail=
userid=0
username=
URL Parameters:
blogid=102
Debug Rendering Time: 5 ms