Actualités

  • Vous êtes ici:
  • Pages
  • Journal

Debugging Information
ColdFusion Server Standard 11,0,15,311399
Template /journal.cfm
Time Stamp 17-Feb-19 11:18 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
105 ms 105 ms 1 CFC[ E:/Sites/somzee.be/www/application.cfc | onRequest(/journal.cfm) ] from E:/Sites/somzee.be/www/application.cfc
103 ms 103 ms 1 top level E:\Sites\somzee.be\www\journal.cfm
31 ms 31 ms 1 E:/Sites/somzee.be/www/_widget_lastblogs.cfm
24 ms 24 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogs(order = Blogs.blogdate desc, status = true) ] from E:/Sites/somzee.be/www/somzee.cfc
16 ms 16 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
8 ms 8 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogComments(blogid = 71) ] from E:/Sites/somzee.be/www/somzee.cfc
6 ms 6 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
6 ms 6 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogComments(status = true, blogid = 105) ] from E:/Sites/somzee.be/www/somzee.cfc
6 ms 6 ms 1 E:/Sites/somzee.be/www/_widget_lastcomments.cfm
5 ms 5 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogComments(blogid = 74) ] from E:/Sites/somzee.be/www/somzee.cfc
5 ms 5 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogComments(blogid = 76) ] from E:/Sites/somzee.be/www/somzee.cfc
5 ms 5 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | GetAllBlogComments(blogid = 79) ] from E:/Sites/somzee.be/www/somzee.cfc
5 ms 5 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(blogid = 82) ] from E:/Sites/somzee.be/www/somzee.cfc
2 ms 2 ms 1 E:/Sites/somzee.be/www/_footer.cfm
1 ms 1 ms 1 CFC[ E:/Sites/somzee.be/www/application.cfc | onSessionStart() ] from E:/Sites/somzee.be/www/application.cfc
1 ms 1 ms 1 CFC[ E:/Sites/somzee.be/www/somzee.cfc | createPagination(argumentCollection = [complex value]) ] from E:/Sites/somzee.be/www/somzee.cfc
0 ms 0 ms 1 CFC[ E:/Sites/somzee.be/www/application.cfc | onRequestEnd(/journal.cfm) ] from E:/Sites/somzee.be/www/application.cfc
0 ms 0 ms 1 CFC[ E:/Sites/somzee.be/www/application.cfc | onRequestStart(/journal.cfm) ] 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
6 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
112 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time

SQL Queries

GetAllBlogs (Datasource=somzee, Time=23ms, Records=51) in E:\Sites\somzee.be\www\somzee.cfc @ 23:18:26.026
			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.blogdate desc
GetCategories (Datasource=, Time=1ms, Records=8) in E:\Sites\somzee.be\www\journal.cfm @ 23:18:26.026
select [group] as groupname, count(id_blog) as countofid
from GetBlogs
group by [group]
order by [group]
GetAllBlogs (Datasource=somzee, Time=15ms, Records=2) in E:\Sites\somzee.be\www\somzee.cfc @ 23:18:26.026
			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=6ms, Records=0) in E:\Sites\somzee.be\www\somzee.cfc @ 23:18:26.026
			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=5ms, Records=2) in E:\Sites\somzee.be\www\somzee.cfc @ 23:18:26.026
			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=5ms, Records=2) in E:\Sites\somzee.be\www\somzee.cfc @ 23:18:26.026
			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
GetAllBlogComments (Datasource=somzee, Time=5ms, Records=0) in E:\Sites\somzee.be\www\somzee.cfc @ 23:18:26.026
			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) = 79

GetAllBlogComments (Datasource=somzee, Time=3ms, Records=0) in E:\Sites\somzee.be\www\somzee.cfc @ 23:18:26.026
			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) = 82

GetAllBlogComments (Datasource=somzee, Time=5ms, Records=0) in E:\Sites\somzee.be\www\somzee.cfc @ 23:18:26.026
			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) = 76

GetAllBlogComments (Datasource=somzee, Time=5ms, Records=0) in E:\Sites\somzee.be\www\somzee.cfc @ 23:18:26.026
			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) = 74

GetAllBlogComments (Datasource=somzee, Time=7ms, Records=0) in E:\Sites\somzee.be\www\somzee.cfc @ 23:18:26.026
			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) = 71

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.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.cfm
QUERY_STRING=page=5
REMOTE_ADDR=107.23.176.162
REMOTE_HOST=107.23.176.162
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/journal.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=1710651
cftoken=61feca17bde842bc-E76402C7-FA16-3E97-8993BCE0C89E9EBA
hitcount=1
lastvisit={ts '2019-02-17 23:18:26'}
timecreated={ts '2019-02-17 23:18:26'}
urltoken=CFID=1710651&CFTOKEN=61feca17bde842bc-E76402C7-FA16-3E97-8993BCE0C89E9EBA

Cookie Variables:
CFID=1710651
CFTOKEN=61feca17bde842bc-E76402C7-FA16-3E97-8993BCE0C89E9EBA

Request Parameters:
__FusionReactor=YES

Session Variables:
cfid=1710651
cftoken=61feca17bde842bc-E76402C7-FA16-3E97-8993BCE0C89E9EBA
language=FR
member=0
responsible=0
sessionid=SOMZEE.BE_1710651_61feca17bde842bc-E76402C7-FA16-3E97-8993BCE0C89E9EBA
urltoken=CFID=1710651&CFTOKEN=61feca17bde842bc-E76402C7-FA16-3E97-8993BCE0C89E9EBA
userblogid=0
useremail=
userid=0
username=

URL Parameters:
page=5
Debug Rendering Time: 9 ms