Using TimeTrex 2.0.2, Windows XP SP2, XAMPP 1.6.3: Apache 2.2.4 - MySQL 5.0.45 - PHP 5.2.3
This is MySQL debug info after trying to sort by Employee Name - Ascending:
(mysqlt): SET SESSION sql_mode='ansi'
(mysqlt): select session_id,user_id,ip_address,created_date,updated_date from authentication WHERE session_id =
'0773cc8a5edbd381bd44e70b944f71da' AND ip_address = '192.168.1.181' AND updated_date >= 1185396354
(mysqlt): update authentication set updated_date = 1185410754 where session_id = '0773cc8a5edbd381bd44e70b944f71da' (mysqlt): SET SESSION time_zone='US/Eastern'
(mysqlt): select * from station where company_id = '1' AND station_id = 'de6800de9b9bcc1761fe7089058ae611' AND deleted = 0
(mysqlt): select * from cron WHERE deleted = 0 ORDER BY last_run_date DESC LIMIT 1
(mysqlt): select d.severity_id as severity_id, count(*) as count from exception as a LEFT JOIN user_date as b ON a.user_date_id = b.id LEFT JOIN users as c ON b.user_id = c.id LEFT JOIN exception_policy as d ON a.exception_policy_id = d.id LEFT JOIN pay_period as e ON b.pay_period_id = e.id where b.user_id = '1' AND b.date_stamp < '2007-07-25' AND e.status_id = 10 AND NOT EXISTS ( select z.id from request as z where z.user_date_id = a.user_date_id AND z.status_id = 30 ) AND ( a.deleted = 0 AND b.deleted = 0 AND e.deleted=0) GROUP BY d.severity_id ORDER BY d.severity_id desc
(mysqlt): select name FROM bread_crumb WHERE user_id = '1' AND name = 'Whos In' LIMIT 1
(mysqlt): UPDATE bread_crumb SET url = '/timetrex/interface/report/ActiveShiftList.php?sort_column=d.last_name&sort_order=asc&page=', created_date = 1185410755 WHERE user_id = '1' AND name = 'Whos In'
(mysqlt): select * from branch where company_id = '1' AND deleted = 0
(mysqlt): select * from department where company_id = '1' AND deleted = 0 c:\xampp\htdocs\timetrex\temp\/e5/adodb_e52a03a0fd4c6c188ca377794c9a31a6.cache reloaded, ttl=85408 [ select * from punch where id = -1 ]
(mysqlt): select a.id as punch_id, a.punch_control_id as punch_control_id, a.type_id as type_id, a.status_id as status_id, a.time_stamp as time_stamp, b.user_date_id as user_date_id, b.branch_id as branch_id, b.department_id as department_id, b.job_id as job_id, b.job_item_id as job_item_id, c.user_id as user_id, e.type_id as station_type_id, e.description as station_description from punch as a LEFT JOIN punch_control as b ON a.punch_control_id = b.id LEFT JOIN user_date as c ON b.user_date_id = c.id LEFT JOIN users as d ON c.user_id = d.id LEFT JOIN station as e ON a.station_id = e.id LEFT JOIN ( select tmp2_d.id, max(tmp2_a.time_stamp) as max_punch_time_stamp from punch as tmp2_a LEFT JOIN punch_control as tmp2_b ON tmp2_a.punch_control_id = tmp2_b.id LEFT JOIN user_date as tmp2_c ON tmp2_b.user_date_id = tmp2_c.id LEFT JOIN users as tmp2_d ON tmp2_c.user_id = tmp2_d.id WHERE tmp2_d.company_id = '1' AND tmp2_c.date_stamp >= '2007-07-24' AND tmp2_c.date_stamp <= '2007-07-26' AND tmp2_a.time_stamp is not null group by tmp2_d.id ) as tmp2 ON c.user_id = tmp2.id AND a.time_stamp = tmp2.max_punch_time_stamp WHERE tmp2.id IS NOT NULL AND d.company_id = '1' AND c.date_stamp >= '2007-07-24' AND c.date_stamp <= '2007-07-26' AND (a.deleted = 0 AND b.deleted =0 AND c.deleted = 0 AND d.deleted = 0) order by d.last_name asc
(mysqlt): SELECT name,url FROM bread_crumb WHERE user_id = '1' ORDER BY created_date DESC LIMIT 5
Debug Buffer
============================================================================
Memory Usage: 9463912
----------------------------------------------------------------------------
DEBUG [205]: [Function](): URI: /timetrex/interface/report/ActiveShiftList.php?sort_column=d.last_name&sort_order=asc&page=
DEBUG [207]: [Function](): Production: 1
DEBUG [491]: Authentication::Check(): Session Name: SessionID
DEBUG [497]: Authentication::Check(): Session ID: 0773cc8a5edbd381bd44e70b944f71da
DEBUG [302]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:0773cc8a5edbd381bd44e70b944f71da
DEBUG [78]: Authentication::getIdle(): Idle Seconds Allowed: 14400
DEBUG [302]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:0773cc8a5edbd381bd44e70b944f71da
DEBUG [67]: [Function](): User Authenticated: admin Created Date: 1185410391
DEBUG [1689]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [100]: TTDate::setTimeZone(): Setting TimeZone: US/Eastern
DEBUG [129]: TTDate::setDateFormat(): Setting Default Date Format: m/d/Y
DEBUG [143]: TTDate::setTimeFormat(): Setting Default Time Format: g:i A
DEBUG [157]: TTDate::setTimeUnitFormat(): Setting Default Time Unit Format: 10
DEBUG [98]: [Function](): Locale Cookie: en_US
DEBUG [235]: TTi18n::getLanguageFromLocale(): Locale: en_US
DEBUG [106]: [Function](): User Preference Language matches cookie!
DEBUG [270]: TTi18n::setLocale(): Attempting to set Locale to: en_US Category: 0 Current Locale:
DEBUG [273]: TTi18n::setLocale(): Attempting to set Locale to: en_US
DEBUG [275]: TTi18n::setLocale(): Failed setting i18n locale: en_US
DEBUG [287]: TTi18n::setLocale(): Setting translator normalized locale to: en_US
DEBUG [305]: TTi18n::setLocale(): Set Locale To: en_US
DEBUG [1689]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [1094]: UserPreferenceFactory::isPreferencesComplete(): User Preferences IS Complete:
DEBUG [134]: [Function](): Station ID Cookie found! de6800de9b9bcc1761fe7089058ae611
DEBUG [241]: [Function](): UnRead Messages: 0
DEBUG [48]: BreadCrumb::setCrumb(): Dropping Bread Crumb: Whos In URL: /timetrex/interface/report/ActiveShiftList.php?sort_column=d.last_name&sort_order=asc&page=
============================================================================
============================================================================
PROFILER OUTPUT
============================================================================
Calls Time Routine
-----------------------------------------------------------------------------
1 92.9050 ms (10.46 %) Authentication::Check()
1 54.4291 ms (6.13 %) Interface.inc - Check for Exceptions
1 51.4321 ms (5.79 %) Interface.inc - Check for UNREAD messages...
1 4.8869 ms (0.55 %) getEmptyRecordSet()
1 0.1371 ms (0.02 %) multiSort()
1 509.6209 ms (57.35 %) unprofiled
175.1668 ms (19.71 %) Missed
============================================================================
888.5779 ms (100.00 %) OVERALL TIME
============================================================================