Debugging Information
ColdFusion Server Enterprise 2016,0,13,316217
Template /directory/index.cfm
Time Stamp 16-Dec-19 03:13 PM
Locale English (US)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 10.225.240.11
Host Name 10.225.240.11


Execution Time

Total Time Avg Time Count Template
567 ms 567 ms 1 /opt/www/cfapps.flinders/directory/index.cfm
567 ms 567 ms 1 /opt/www/cfapps.flinders/directory/wheels/index.cfm
567 ms 567 ms 1 CFC[ /opt/www/cfapps.flinders/directory/Application.cfc | onRequest(/directory/index.cfm) ] from /opt/www/cfapps.flinders/directory/Application.cfc
566 ms 566 ms 1 CFC[ /opt/www/cfapps.flinders/directory/wheels/Dispatch.cfc | $request() ] from /opt/www/cfapps.flinders/directory/wheels/Dispatch.cfc
550 ms 550 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | $processAction() ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
35 ms 35 ms 1 CFC[ /opt/www/cfapps.flinders/directory/models/Users.cfc | findAll(returnas = objects, where = flinderspersonnotpublishsearch != 'TRUE' AND locationsearch != 'ASMS' AND firstname NOT LIKE '%DUPE' AND lastname NOT LIKE '%DUPE' AND ( (staffnumber IS NOT NULL AND empstatuscode IS NOT NULL AND ( empstatuscode NOT IN ('AFS','CA','HDRS','HP','OAWF','ON','PAIDC','PST','SH','ST','UNION') OR (empstatuscode IN ('CA','HP') AND telephonenumber IS NOT NULL) ) ) OR (persontype = 'X' AND telephonenumber IS NOT NULL) ) AND userid=100278, select = userid,staffnumber,telephonenumber1,fullname,ou,position1,location1,room1,oustructlevel1,oustructlevel2,oustructlevel3,oustructlevel4,oustructlevel5,email,staffprofile) ] from /opt/www/cfapps.flinders/directory/models/Users.cfc
29 ms 15 ms 2 /opt/www/cfapps.flinders/directory/root.cfm
27 ms 14 ms 2 CFC[ /opt/www/cfapps.flinders/directory/wheels/model/adapters/Oracle.cfc | $query(argumentCollection = [complex value]) ] from /opt/www/cfapps.flinders/directory/wheels/model/adapters/Oracle.cfc
21 ms 21 ms 1 CFC[ /opt/www/cfapps.flinders/directory/models/Users.cfc | count(where = flinderspersonnotpublishsearch != 'TRUE') ] from /opt/www/cfapps.flinders/directory/models/Users.cfc
14 ms 14 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | $createControllerObject([complex value]) ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
13 ms 13 ms 1 /opt/www/cfapps.flinders/directory/wheels/model.cfm
12 ms 12 ms 1 /opt/www/cfapps.flinders/directory/wheels/controller.cfm
9 ms 9 ms 1 /opt/www/cfapps.flinders/directory/wheels/functions.cfm
8 ms 8 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/functions.cfm
7 ms 7 ms 1 /opt/www/cfapps.flinders/directory/views/search/info.cfm
5 ms 5 ms 1 /opt/www/cfapps.flinders/directory/wheels/controller/appfunctions.cfm
5 ms 5 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/functions.cfm
4 ms 4 ms 1 /opt/www/cfapps.flinders/directory/wheels/controller/functions.cfm
3 ms 2 ms 2 /opt/www/cfapps.flinders/directory/wheels/global/functions.cfm
2 ms 2 ms 1 /opt/www/cfapps.flinders/directory/views/layout.cfm
2 ms 2 ms 1 /opt/www/cfapps.flinders/directory/views/templates/_common.cfm
2 ms 2 ms 1 /opt/www/cfapps.flinders/directory/wheels/global/appfunctions.cfm
1 ms 1 ms 1 /opt/www/cfapps.flinders/directory/views/search/_info.cfm
1 ms 1 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/rendering.cfm
1 ms 1 ms 1 CFC[ /opt/www/cfapps.flinders/directory/Application.cfc | onRequestStart(/directory/index.cfm) ] from /opt/www/cfapps.flinders/directory/Application.cfc
1 ms 1 ms 1 CFC[ /opt/www/cfapps.flinders/directory/Application.cfc | onSessionStart() ] from /opt/www/cfapps.flinders/directory/Application.cfc
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/config/app.cfm
0 ms 0 ms 3 /opt/www/cfapps.flinders/directory/events/functions.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/events/onrequestend.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/events/onrequeststart.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/events/onsessionstart.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/views/helpers.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/views/templates/_live-global-nav.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/caching.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/filters.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/flash.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/initialization.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/layouts.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/miscellaneous.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/processing.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/provides.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/redirection.cfm
0 ms 0 ms 2 /opt/www/cfapps.flinders/directory/wheels/controller/verifies.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onapplicationend.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onapplicationstart.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onerror.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onmissingtemplate.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onrequest.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onrequestend.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onrequeststart.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onsessionend.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/events/onsessionstart.cfm
0 ms 0 ms 3 /opt/www/cfapps.flinders/directory/wheels/global/cfml.cfm
0 ms 0 ms 3 /opt/www/cfapps.flinders/directory/wheels/global/internal.cfm
0 ms 0 ms 3 /opt/www/cfapps.flinders/directory/wheels/global/public.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/associations.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/calculations.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/callbacks.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/create.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/delete.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/errors.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/initialization.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/miscellaneous.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/nestedproperties.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/onmissingmethod.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/properties.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/read.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/serialize.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/sql.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/transactions.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/update.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/model/validations.cfm
0 ms 0 ms 3 /opt/www/cfapps.flinders/directory/wheels/plugins/injection.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/assets.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/dates.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/errors.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/forms.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/formsassociation.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/formsdate.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/formsdateobject.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/formsdateplain.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/formsobject.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/formsplain.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/links.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/miscellaneous.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/sanitize.cfm
0 ms 0 ms 1 /opt/www/cfapps.flinders/directory/wheels/view/text.cfm
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/Application.cfc | onRequestEnd(/directory/index.cfm) ] from /opt/www/cfapps.flinders/directory/Application.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | $flashClear() ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | $getControllerClassData() ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | $initControllerObject(PATH = controllers, METHOD = $initControllerObject, params = [complex value], FILENAME = Search, name = Search) ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | $performedRedirect() ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/controllers/Search.cfc | response() ] from /opt/www/cfapps.flinders/directory/controllers/Search.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/models/Users.cfc | $callback(afterFind, true) ] from /opt/www/cfapps.flinders/directory/models/Users.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/models/Users.cfc | $callback(afterInitialization, true) ] from /opt/www/cfapps.flinders/directory/models/Users.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/models/Users.cfc | $classData() ] from /opt/www/cfapps.flinders/directory/models/Users.cfc
0 ms 0 ms 1 CFC[ /opt/www/cfapps.flinders/directory/models/Users.cfc | $initModelObject(PATH = models, persisted = true, properties = [complex value], METHOD = $initModelObject, row = 1, FILENAME = Users, useFilterLists = NO, name = users, base = true) ] from /opt/www/cfapps.flinders/directory/models/Users.cfc
11 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
580 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

15:13:40.040 - Expression Exception - in /opt/www/cfapps.flinders/directory/wheels/controller/verifies.cfm : line 61
	    Element SESSIONMANAGEMENT is undefined in a Java object of type class coldfusion.runtime.StructBean.
	    


SQL Queries

query.name (Datasource=iam, Time=20ms, Records=1) in /opt/www/cfapps.flinders/directory/wheels/model/adapters/Base.cfc @ 15:13:40.040
SELECT COUNT(users.USERID) AS count
FROM users
WHERE
(nvl2(flinderspersonnotpublish,upper(flinderspersonnotpublish),'FALSE')) !=
?
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = TRUE

query.name (Datasource=iam, Time=4ms, Records=1) in /opt/www/cfapps.flinders/directory/wheels/model/adapters/Base.cfc @ 15:13:40.040
SELECT users.userid,users.staffnumber,(nvl(telephonenumber,'-')) AS telephonenumber1,(nvl2(title,title||' ','')||nvl(preffirstname,firstname)||' '||lastname) AS fullname,(
            CASE
                WHEN 
                    oustructlevel5 IS NOT NULL 
                    AND oustructlevel4 IS NOT NULL 
                    AND oustructlevel3 IS NOT NULL 
                    AND oustructlevel2 IS NOT NULL 
                    AND oustructlevel1 IS NOT NULL 
                    AND oustructlevel5 = oustructlevel4 
                    AND oustructlevel4 = oustructlevel3 
                    AND oustructlevel3 = oustructlevel2 
                    AND oustructlevel2 = oustructlevel1 
                    THEN oustructlevel1
                WHEN 
                    oustructlevel5 IS NOT NULL 
                    AND oustructlevel4 IS NOT NULL 
                    AND oustructlevel3 IS NOT NULL 
                    AND oustructlevel2 IS NOT NULL 
                    AND oustructlevel5 = oustructlevel4 
                    AND oustructlevel4 = oustructlevel3 
                    AND oustructlevel3 = oustructlevel2 
                    THEN oustructlevel2
                WHEN 
                    oustructlevel5 IS NOT NULL 
                    AND oustructlevel4 IS NOT NULL 
                    AND oustructlevel3 IS NOT NULL 
                    AND oustructlevel5 = oustructlevel4 
                    AND oustructlevel4 = oustructlevel3 
                    THEN oustructlevel2||', '||oustructlevel3
                WHEN 
                    oustructlevel5 IS NOT NULL 
                    AND oustructlevel4 IS NOT NULL 
                    AND oustructlevel5 = oustructlevel4 
                    THEN oustructlevel3||', '||oustructlevel4
                WHEN 
                    oustructlevel5 IS NOT NULL 
                    THEN oustructlevel4||', '||oustructlevel5
                ELSE '-'
            END
        ) AS ou,(nvl(position,'-')) AS position1,(nvl(location,'-')) AS location1,(nvl(room,'-')) AS room1,users.oustructlevel1,users.oustructlevel2,users.oustructlevel3,users.oustructlevel4,users.oustructlevel5,users.email,(
            CASE
                WHEN 
                    staffnumber IS NOT NULL 
                    AND empstatuscode IS NOT NULL 
                    THEN TRIM(LOWER(SUBSTR(email, 0, INSTR(email, '@')-1)))
                ELSE '-'
            END
        ) AS staffprofile
FROM users
WHERE
(nvl2(flinderspersonnotpublish,upper(flinderspersonnotpublish),'FALSE')) !=
?

        AND 
(nvl(location,'-')) !=
?

        AND 
users.FIRSTNAME NOT LIKE
?

        AND 
users.LASTNAME NOT LIKE
?

        AND (
            (
users.STAFFNUMBER IS NOT
NULL

                AND 
users.EMPSTATUSCODE IS NOT
NULL

                AND (
                    
users.EMPSTATUSCODE NOT IN
(?,?,?,?,?,?,?,?,?,?,?)

                    OR (
users.EMPSTATUSCODE IN
(?,?)
 AND 
users.TELEPHONENUMBER IS NOT
NULL
)
                )
            )
            OR (
users.PERSONTYPE =
?
 AND 
users.TELEPHONENUMBER IS NOT
NULL
)
        ) AND 
users.USERID =
?
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = TRUE
Parameter #2(CF_SQL_CHAR) = ASMS
Parameter #3(cf_sql_varchar) = %DUPE
Parameter #4(cf_sql_varchar) = %DUPE
Parameter #5(cf_sql_varchar) = AFS
Parameter #6(cf_sql_varchar) = CA
Parameter #7(cf_sql_varchar) = HDRS
Parameter #8(cf_sql_varchar) = HP
Parameter #9(cf_sql_varchar) = OAWF
Parameter #10(cf_sql_varchar) = ON
Parameter #11(cf_sql_varchar) = PAIDC
Parameter #12(cf_sql_varchar) = PST
Parameter #13(cf_sql_varchar) = SH
Parameter #14(cf_sql_varchar) = ST
Parameter #15(cf_sql_varchar) = UNION
Parameter #16(cf_sql_varchar) = CA
Parameter #17(cf_sql_varchar) = HP
Parameter #18(cf_sql_varchar) = X
Parameter #19(cf_sql_integer) = 100278


Scope Variables

Application Variables:
applicationname=6F417EA936F2CF04E4238AF94687606E
wheels=Struct (104)
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=/opt/www/cfapps.flinders/directory/index.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=on
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=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=www.flinders.edu.au
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=10.224.64.41
PATH_INFO=/search/info
PATH_TRANSLATED=/opt/www/cfapps.flinders/directory/index.cfm
QUERY_STRING=userid=100278
REMOTE_ADDR=10.225.240.11
REMOTE_HOST=10.225.240.11
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/directory/index.cfm
SERVER_NAME=www.flinders.edu.au
SERVER_PORT=443
SERVER_PORT_SECURE=1
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/2.4.6 (Red Hat Enterprise Linux) OpenSSL/1.0.2k-fips mod_jk/1.2.41
WEB_SERVER_API=
Cookie Variables:
CFID=1958149
CFTOKEN=98864b4fb0faa2e6-8230A6C8-D306-0710-38FB4F82E7065499
Request Parameters:
cgi=Struct (18)
wheels=Struct (9)
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
Session Variables:
cfid=1958149
cftoken=98864b4fb0faa2e6-8230A6C8-D306-0710-38FB4F82E7065499
flash=Struct (0)
sessionid=6F417EA936F2CF04E4238AF94687606E_1958149_98864b4fb0faa2e6-8230A6C8-D306-0710-38FB4F82E7065499
urltoken=CFID=1958149&CFTOKEN=98864b4fb0faa2e6-8230A6C8-D306-0710-38FB4F82E7065499
URL Parameters:
userid=100278
Debug Rendering Time: 9 ms