2019-10-21 16:14:48 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:14:52 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2018-12-03 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2018-12-03 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:15:15 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2017-01-31 05:00:00' AND '2019-03-30 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2017-01-31 05:00:00' AND '2019-03-30 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:15:23 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:15:27 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2018-12-03 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2018-12-03 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:15:49 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:15:58 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:15:59 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:16:03 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:16:28 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:19:42 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:20:05 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:20:50 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:20:51 - DEBUG --> Before: 2019-10-21 16:20:51 - DEBUG --> DateStart: 2019-09-21 16:20:50 2019-10-21 16:20:51 - DEBUG --> DateEnd: 2019-10-21 16:20:50 2019-10-21 16:20:51 - DEBUG --> After: 2019-10-21 16:20:51 - DEBUG --> DateStart: 2019-09-21 05:00:00 2019-10-21 16:20:51 - DEBUG --> DateEnd: 2019-10-21 05:00:00 2019-10-21 16:21:24 - DEBUG --> Before: 2019-10-21 16:21:24 - DEBUG --> DateStart: 2019-09-21 16:21:24 2019-10-21 16:21:24 - DEBUG --> DateEnd: 2019-10-21 16:21:24 2019-10-21 16:21:24 - DEBUG --> After: 2019-10-21 16:21:24 - DEBUG --> DateStart: 2019-09-21 05:00:00 2019-10-21 16:21:24 - DEBUG --> DateEnd: 2019-10-21 05:00:00 2019-10-21 16:21:24 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:21:56 - DEBUG --> Before: 2019-10-21 16:21:56 - DEBUG --> DateStart: 2019-09-21 16:21:56 2019-10-21 16:21:56 - DEBUG --> DateEnd: 2019-10-21 16:21:56 2019-10-21 16:21:56 - DEBUG --> After: 2019-10-21 16:21:56 - DEBUG --> DateStart: 2019-09-21 05:00:00 2019-10-21 16:21:56 - DEBUG --> DateEnd: 2019-10-21 05:00:00 2019-10-21 16:21:56 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:22:15 - DEBUG --> Before: 2019-10-21 16:22:15 - DEBUG --> DateStart: 2019-09-21 16:22:15 2019-10-21 16:22:15 - DEBUG --> DateEnd: 2019-10-21 16:22:15 2019-10-21 16:22:15 - DEBUG --> After: 2019-10-21 16:22:15 - DEBUG --> DateStart: 2019-09-21 05:00:00 2019-10-21 16:22:15 - DEBUG --> DateEnd: 2019-10-21 05:00:00 2019-10-21 16:22:15 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:25:16 - DEBUG --> Before: 2019-10-21 16:25:16 - DEBUG --> DateStart: 2019-09-21 16:25:16 2019-10-21 16:25:16 - DEBUG --> DateEnd: 2019-10-21 16:25:16 2019-10-21 16:25:16 - DEBUG --> After: 2019-10-21 16:25:16 - DEBUG --> DateStart: 2019-09-21 05:00:00 2019-10-21 16:25:16 - DEBUG --> DateEnd: 2019-10-21 05:00:00 2019-10-21 16:25:16 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:26:23 - DEBUG --> Before: 2019-10-21 16:26:23 - DEBUG --> DateStart: 2019-09-21 16:26:23 2019-10-21 16:26:23 - DEBUG --> DateEnd: 2019-10-21 16:26:23 2019-10-21 16:26:23 - DEBUG --> After: 2019-10-21 16:26:23 - DEBUG --> DateStart: 2019-09-21 05:00:00 2019-10-21 16:26:23 - DEBUG --> DateEnd: 2019-10-21 05:00:00 2019-10-21 16:26:23 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:28:05 - DEBUG --> Before: 2019-10-21 16:28:05 - DEBUG --> DateStart: 2019-09-21 16:28:05 2019-10-21 16:28:05 - DEBUG --> DateEnd: 2019-10-21 16:28:05 2019-10-21 16:28:05 - DEBUG --> After: 2019-10-21 16:28:05 - DEBUG --> DateStart: 2019-09-21 05:00:00 2019-10-21 16:28:05 - DEBUG --> DateEnd: 2019-10-21 05:00:00 2019-10-21 16:28:06 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:28:49 - DEBUG --> Before: 2019-10-21 16:28:49 - DEBUG --> DateStart: 2019-09-21 16:28:49 2019-10-21 16:28:49 - DEBUG --> DateEnd: 2019-10-21 16:28:49 2019-10-21 16:28:49 - DEBUG --> After: 2019-10-21 16:28:49 - DEBUG --> DateStart: 2019-09-21 05:00:00 2019-10-21 16:28:49 - DEBUG --> DateEnd: 2019-10-21 05:00:00 2019-10-21 16:28:49 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:29:02 - DEBUG --> Before: 2019-10-21 16:29:02 - DEBUG --> DateStart: 2019-09-21 16:29:02 2019-10-21 16:29:02 - DEBUG --> DateEnd: 2019-10-21 16:29:02 2019-10-21 16:29:02 - DEBUG --> After: 2019-10-21 16:29:02 - DEBUG --> DateStart: 2019-09-21 05:00:00 2019-10-21 16:29:02 - DEBUG --> DateEnd: 2019-10-21 05:00:00 2019-10-21 16:29:02 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2019-10-21 16:30:47 - DEBUG --> Before: 2019-10-21 16:30:47 - DEBUG --> DateStart: 2019-09-21 16:30:47 2019-10-21 16:30:47 - DEBUG --> DateEnd: 2019-10-21 16:30:47 2019-10-21 16:30:47 - DEBUG --> After: 2019-10-21 16:30:47 - DEBUG --> DateStart: 2019-09-21 05:00:00 2019-10-21 16:30:47 - DEBUG --> DateEnd: 2019-10-21 05:00:00 2019-10-21 16:30:47 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-08-23 05:00:00' AND '2019-10-23 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2020-02-24 17:17:06 - DEBUG --> Before: 2020-02-24 17:17:06 - DEBUG --> DateStart: 2020-02-01 05:01:00 2020-02-24 17:17:06 - DEBUG --> DateEnd: 2020-02-24 17:17:06 2020-02-24 17:17:06 - DEBUG --> After: 2020-02-24 17:17:06 - DEBUG --> DateStart: 2020-02-01 05:00:00 2020-02-24 17:17:06 - DEBUG --> DateEnd: 2020-02-24 05:00:00 2020-02-24 17:18:05 - DEBUG --> Before: 2020-02-24 17:18:05 - DEBUG --> DateStart: 2020-02-01 05:01:00 2020-02-24 17:18:05 - DEBUG --> DateEnd: 2020-02-24 17:18:05 2020-02-24 17:18:05 - DEBUG --> After: 2020-02-24 17:18:05 - DEBUG --> DateStart: 2020-02-01 05:00:00 2020-02-24 17:18:05 - DEBUG --> DateEnd: 2020-02-24 05:00:00 2020-02-24 17:18:11 - DEBUG --> Before: 2020-02-24 17:18:11 - DEBUG --> DateStart: 2020-01-25 17:18:11 2020-02-24 17:18:11 - DEBUG --> DateEnd: 2020-02-24 17:18:11 2020-02-24 17:18:11 - DEBUG --> After: 2020-02-24 17:18:11 - DEBUG --> DateStart: 2020-01-25 05:00:00 2020-02-24 17:18:11 - DEBUG --> DateEnd: 2020-02-24 05:00:00 2020-02-24 17:18:11 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-12-27 05:00:00' AND '2020-02-26 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-12-27 05:00:00' AND '2020-02-26 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2020-02-24 17:18:14 - DEBUG --> Before: 2020-02-24 17:18:14 - DEBUG --> DateStart: 2020-02-01 05:01:00 2020-02-24 17:18:14 - DEBUG --> DateEnd: 2020-02-24 17:18:14 2020-02-24 17:18:14 - DEBUG --> After: 2020-02-24 17:18:14 - DEBUG --> DateStart: 2020-02-01 05:00:00 2020-02-24 17:18:14 - DEBUG --> DateEnd: 2020-02-24 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-05 12:31:13 - DEBUG --> Last 30: 2021-01-06 05:00:00 to 2021-02-06 05:00:00 2021-02-12 11:04:24 - DEBUG --> Array Sum for (Mon) - 234 2021-02-12 11:04:24 - DEBUG --> Array Sum for (Tue) - 214 2021-02-12 11:04:24 - DEBUG --> Array Sum for (Wed) - 205 2021-02-12 11:04:24 - DEBUG --> Array Sum for (Thu) - 159 2021-02-12 11:04:24 - DEBUG --> Array Sum for (Fri) - 207 2021-02-12 11:04:24 - DEBUG --> Array Sum for (Sat) - 286 2021-02-12 11:04:24 - DEBUG --> Array Sum for (Sun) - 131 2021-02-12 11:05:25 - DEBUG --> Array Sum for (Mon) - 234 2021-02-12 11:05:25 - DEBUG --> Array Sum for (Tue) - 214 2021-02-12 11:05:25 - DEBUG --> Array Sum for (Wed) - 205 2021-02-12 11:05:25 - DEBUG --> Array Sum for (Thu) - 159 2021-02-12 11:05:25 - DEBUG --> Array Sum for (Fri) - 207 2021-02-12 11:05:25 - DEBUG --> Array Sum for (Sat) - 286 2021-02-12 11:05:25 - DEBUG --> Array Sum for (Sun) - 131 2021-04-24 13:05:10 - DEBUG --> 2 2021-04-24 13:05:25 - DEBUG --> 2 2021-04-24 13:05:47 - DEBUG --> pc00 2021-04-24 13:05:56 - DEBUG --> 2 2021-04-24 13:23:42 - DEBUG --> 2 2021-04-24 13:51:10 - DEBUG --> 2 2021-04-24 13:58:25 - DEBUG --> 2 2021-04-24 13:59:42 - DEBUG --> 2 2021-04-27 10:51:18 - DEBUG --> 2 2021-04-27 10:51:30 - DEBUG --> 2 2021-04-27 10:52:26 - DEBUG --> 2 2021-04-27 10:53:09 - DEBUG --> 2 2021-04-27 10:54:16 - DEBUG --> pc00 2021-04-27 15:31:13 - DEBUG --> pc00 2021-04-27 15:53:46 - DEBUG --> pc00 2021-11-15 13:26:43 - DEBUG --> 2021-11-01 05:00:00 - 2021-12-02 05:00:00 2021-11-15 13:26:48 - DEBUG --> 2021-11-01 05:00:00 - 2021-12-01 05:00:00 2021-11-15 13:27:00 - DEBUG --> SELECT texts.timestamp, texts.customerID, customers.firstName, customers.lastName, customers.phone, CEIL(ROUND((UNIX_TIMESTAMP(timestamp)/texts.customerID)*100000)/100000) as combined FROM texts INNER JOIN customers ON texts.customerID = customers.customerID WHERE texts.timestamp BETWEEN '2021-11-01 05:00:00' AND '2021-11-17 05:00:00' AND type = 0 GROUP BY combined ORDER BY texts.id DESC 2022-04-11 16:47:21 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2022-02-11 05:00:00' AND '2022-04-13 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2022-02-11 05:00:00' AND '2022-04-13 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2022-04-11 16:47:46 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2020-11-29 05:00:00' AND '2022-01-31 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2020-11-29 05:00:00' AND '2022-01-31 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2022-04-11 16:47:53 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-11-29 05:00:00' AND '2022-01-31 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2019-11-29 05:00:00' AND '2022-01-31 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2022-04-11 16:48:35 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2022-02-11 05:00:00' AND '2022-04-13 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2022-02-11 05:00:00' AND '2022-04-13 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2022-05-11 13:56:29 - DEBUG --> Last 30: 2022-04-11 05:00:00 to 2022-05-12 05:00:00 2023-02-28 20:46:05 - ERROR --> DB ERROR:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = NULL' at line 1 2023-02-28 20:46:57 - ERROR --> DB ERROR:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = NULL' at line 1 2023-02-28 20:47:22 - ERROR --> DB ERROR:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = NULL' at line 1 2023-02-28 20:47:41 - ERROR --> DB ERROR:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = NULL' at line 1 2023-02-28 20:49:02 - ERROR --> DB ERROR:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = NULL' at line 1 2023-02-28 20:49:09 - ERROR --> DB ERROR:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = NULL' at line 1 2023-02-28 20:49:41 - ERROR --> DB ERROR:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = NULL' at line 1 2023-02-28 20:50:16 - ERROR --> DB ERROR:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = NULL' at line 1 2023-02-28 20:50:46 - ERROR --> DB ERROR:SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'key = 'RUVDHPWSA'' at line 1 2023-02-28 20:51:19 - DEBUG --> Key is invalid 2023-02-28 20:53:54 - DEBUG --> Key is invalid 2023-02-28 20:54:47 - DEBUG --> Key:RUVDHPWSA is invalid 2023-02-28 20:55:34 - DEBUG --> Count:0 2023-02-28 20:55:34 - DEBUG --> Key:RUVDHPWSA is invalid 2023-02-28 20:57:03 - DEBUG --> Count:0 2023-02-28 20:57:03 - DEBUG --> Key:RUVDHPWSA is invalid 2023-02-28 20:58:39 - DEBUG --> Key is invalid 2023-02-28 21:00:20 - DEBUG --> Key is valid 2023-02-28 21:02:45 - DEBUG --> Key is invalid 2023-02-28 21:03:15 - DEBUG --> Key is invalid 2023-02-28 21:03:37 - DEBUG --> Key is invalid 2023-02-28 21:03:38 - DEBUG --> Key is invalid 2023-02-28 21:04:46 - DEBUG --> Key is invalid 2023-02-28 21:04:46 - DEBUG --> Key is invalid 2023-02-28 21:05:07 - DEBUG --> Key is invalid 2023-02-28 21:05:07 - DEBUG --> Key is invalid 2023-02-28 21:05:15 - DEBUG --> Key is invalid 2023-02-28 21:05:15 - DEBUG --> Key is invalid 2023-02-28 21:05:56 - DEBUG --> Key is invalid 2023-02-28 21:05:56 - DEBUG --> Key is invalid 2023-02-28 21:06:49 - DEBUG --> Key is invalid 2023-02-28 21:07:05 - DEBUG --> Key is invalid 2023-02-28 21:07:44 - DEBUG --> Key is invalid 2023-02-28 21:07:44 - DEBUG --> Key is invalid 2023-02-28 21:08:28 - DEBUG --> Key is valid 2023-02-28 21:08:28 - DEBUG --> Key is valid 2023-02-28 21:13:46 - DEBUG --> Key is valid 2023-02-28 21:13:53 - DEBUG --> Key is valid 2023-02-28 21:13:57 - DEBUG --> Key is valid 2023-02-28 21:14:09 - DEBUG --> Key is valid 2023-02-28 21:22:59 - DEBUG --> Key is valid 2023-02-28 21:32:20 - DEBUG --> Key is valid 2023-02-28 21:32:20 - ERROR --> DB ERROR:SQLSTATE[42S22]: Column not found: 1054 Unknown column 'typeNum' in 'field list' 2023-02-28 21:32:20 - DEBUG --> Key is valid 2023-02-28 21:32:20 - DEBUG --> Key is valid 2023-02-28 21:32:20 - ERROR --> DB ERROR:SQLSTATE[42S22]: Column not found: 1054 Unknown column 'typeNum' in 'field list' 2023-02-28 21:32:20 - DEBUG --> Key is valid 2023-02-28 21:32:22 - DEBUG --> Key is valid 2023-02-28 21:32:22 - ERROR --> DB ERROR:SQLSTATE[42S22]: Column not found: 1054 Unknown column 'typeNum' in 'field list' 2023-02-28 21:32:22 - DEBUG --> Key is valid 2023-02-28 21:33:41 - DEBUG --> Key is valid 2023-02-28 21:33:41 - ERROR --> DB ERROR:SQLSTATE[42S22]: Column not found: 1054 Unknown column 'typeNum' in 'field list' 2023-02-28 21:34:19 - DEBUG --> Key is valid 2023-02-28 21:34:19 - ERROR --> DB ERROR:SQLSTATE[42S22]: Column not found: 1054 Unknown column 'typeNum' in 'field list' 2023-02-28 21:35:15 - DEBUG --> Key is valid 2023-02-28 21:37:26 - DEBUG --> Key is valid 2023-02-28 21:37:26 - DEBUG --> TypeNumArray: ["ou00","pc00","se00"] 2023-02-28 21:37:57 - DEBUG --> Key is valid 2023-02-28 21:37:57 - DEBUG --> TypeNumArray: Array ( [0] => ou00 [1] => pc00 [2] => se00 ) 2023-02-28 21:38:16 - DEBUG --> Key is valid 2023-02-28 21:38:16 - DEBUG --> TypeNum: ou00 2023-02-28 21:38:16 - DEBUG --> TypeNum: pc00 2023-02-28 21:38:16 - DEBUG --> TypeNum: se00 2023-02-28 21:39:05 - DEBUG --> Key is valid 2023-02-28 21:39:35 - DEBUG --> Key is valid 2023-02-28 21:40:03 - DEBUG --> Key is valid 2023-02-28 21:40:05 - DEBUG --> Key is valid 2023-02-28 21:40:06 - DEBUG --> Key is valid 2023-02-28 21:43:32 - DEBUG --> Key is valid 2023-02-28 21:43:44 - DEBUG --> Key is valid 2023-02-28 21:43:44 - DEBUG --> Key is valid 2023-03-01 15:51:44 - DEBUG --> Key is valid 2023-03-01 15:51:44 - DEBUG --> Key is valid 2023-03-01 15:51:53 - DEBUG --> Key is invalid 2023-03-01 15:51:53 - DEBUG --> Key is invalid 2023-03-01 15:51:54 - DEBUG --> Key is valid 2023-03-01 15:51:54 - DEBUG --> Key is valid 2023-03-01 15:55:44 - DEBUG --> Key is valid 2023-03-01 15:55:55 - DEBUG --> Key is valid 2023-03-01 15:56:26 - DEBUG --> Key is valid 2023-03-01 15:56:26 - DEBUG --> Key is valid 2023-03-01 15:56:38 - DEBUG --> Key is valid 2023-03-01 15:56:40 - DEBUG --> Key is valid 2023-03-01 15:56:40 - DEBUG --> Key is valid 2023-03-01 16:07:20 - DEBUG --> Key is valid 2023-03-01 16:16:09 - DEBUG --> Key is valid 2023-03-01 16:16:09 - DEBUG --> Key is valid 2023-03-01 16:16:22 - DEBUG --> Key is valid 2023-03-01 16:16:22 - DEBUG --> Key is valid 2023-03-01 16:16:26 - DEBUG --> Key is valid 2023-03-01 16:16:26 - DEBUG --> Key is valid 2023-03-01 16:16:39 - DEBUG --> Key is invalid 2023-03-01 16:16:39 - DEBUG --> Key is invalid 2023-03-01 16:16:39 - DEBUG --> Key is valid 2023-03-01 16:16:39 - DEBUG --> Key is valid 2023-03-01 16:22:43 - DEBUG --> Key is valid 2023-03-01 16:22:52 - DEBUG --> Key is valid 2023-03-01 16:23:39 - DEBUG --> Key is valid 2023-03-01 16:24:11 - DEBUG --> Key is valid 2023-03-01 16:25:11 - DEBUG --> Key is valid 2023-03-01 16:25:11 - DEBUG --> Key is valid 2023-03-01 16:27:12 - DEBUG --> Key is valid 2023-03-01 16:27:12 - DEBUG --> Key is valid 2023-03-01 16:28:28 - DEBUG --> Key is valid 2023-03-01 16:28:28 - DEBUG --> Key is valid 2023-03-01 16:30:31 - DEBUG --> Key is valid 2023-03-01 16:30:35 - DEBUG --> Key is valid 2023-03-01 16:30:35 - DEBUG --> Key is valid 2023-03-01 16:31:19 - DEBUG --> Key is valid 2023-03-01 16:31:19 - DEBUG --> Key is valid 2023-03-01 16:31:34 - DEBUG --> Key is valid 2023-03-01 16:31:34 - DEBUG --> Key is valid 2023-03-01 16:40:09 - DEBUG --> Key is valid 2023-03-01 16:40:26 - DEBUG --> Key is valid 2023-03-01 16:46:51 - DEBUG --> Key is valid 2023-03-01 16:48:42 - DEBUG --> Key is valid 2023-03-01 16:49:18 - DEBUG --> Key is valid 2023-03-01 16:49:18 - DEBUG --> Getting queue data for store: ou00 2023-03-01 16:49:18 - DEBUG --> Getting queue data for store: pc00 2023-03-01 16:49:19 - DEBUG --> Getting queue data for store: 2023-03-01 16:49:30 - DEBUG --> Key is valid 2023-03-01 16:49:30 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 16:49:30 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 16:49:30 - DEBUG --> Getting queue data for store: 2023-03-01 16:50:36 - DEBUG --> Key is valid 2023-03-01 16:50:36 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 16:50:36 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 16:50:36 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 16:52:53 - DEBUG --> Key is valid 2023-03-01 16:52:53 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 16:53:25 - DEBUG --> Key is valid 2023-03-01 16:53:25 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 16:53:26 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 16:53:26 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 16:54:02 - DEBUG --> Key is valid 2023-03-01 16:54:02 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 16:54:03 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 16:54:03 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 16:55:11 - DEBUG --> Key is valid 2023-03-01 16:55:11 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 16:55:12 - DEBUG --> Key is valid 2023-03-01 16:55:13 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 16:55:13 - DEBUG --> Key is valid 2023-03-01 16:55:13 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 16:56:02 - DEBUG --> Key is valid 2023-03-01 16:56:02 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 16:56:02 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 16:56:02 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 16:56:08 - DEBUG --> Key is valid 2023-03-01 16:56:08 - DEBUG --> Key is valid 2023-03-01 16:56:08 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 16:56:08 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 16:56:08 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 16:56:09 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 16:56:09 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 16:56:09 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 17:01:48 - DEBUG --> Key is valid 2023-03-01 17:01:48 - DEBUG --> Key is valid 2023-03-01 17:01:48 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 17:01:48 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 17:01:48 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 17:01:56 - DEBUG --> Key is invalid 2023-03-01 17:01:57 - DEBUG --> Key is invalid 2023-03-01 17:02:35 - DEBUG --> Key is valid 2023-03-01 17:02:35 - DEBUG --> Key is valid 2023-03-01 17:02:35 - DEBUG --> Key is valid 2023-03-01 17:02:35 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 17:02:35 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 17:02:35 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 17:03:42 - DEBUG --> Key is invalid 2023-03-01 17:03:42 - DEBUG --> Key is invalid 2023-03-01 17:03:43 - DEBUG --> Key is valid 2023-03-01 17:03:43 - DEBUG --> Key is valid 2023-03-01 17:03:43 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 17:03:43 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 17:03:43 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 17:04:46 - DEBUG --> Key is valid 2023-03-01 17:04:46 - DEBUG --> Key is valid 2023-03-01 17:08:21 - DEBUG --> Key is valid 2023-03-01 17:20:25 - DEBUG --> Key is valid 2023-03-01 17:20:25 - DEBUG --> Key is valid 2023-03-01 17:20:25 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 17:20:25 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 17:20:26 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 17:20:34 - DEBUG --> Key is valid 2023-03-01 17:20:34 - DEBUG --> Key is valid 2023-03-01 17:20:34 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 17:20:34 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 17:20:34 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 17:20:47 - DEBUG --> Key is invalid 2023-03-01 17:20:47 - DEBUG --> Key is invalid 2023-03-01 17:20:48 - DEBUG --> Key is valid 2023-03-01 17:20:48 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 17:20:48 - DEBUG --> Key is valid 2023-03-01 17:20:48 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 17:20:48 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 17:21:55 - DEBUG --> Key is valid 2023-03-01 17:21:55 - DEBUG --> Key is valid 2023-03-01 17:22:02 - DEBUG --> Key is valid 2023-03-01 17:22:02 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 17:22:02 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 17:22:03 - DEBUG --> Key is valid 2023-03-01 17:22:03 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 17:22:03 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 17:22:03 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 17:22:03 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 17:22:17 - DEBUG --> Key is invalid 2023-03-01 17:22:17 - DEBUG --> Key is invalid 2023-03-01 17:22:18 - DEBUG --> Key is valid 2023-03-01 17:22:18 - DEBUG --> Key is valid 2023-03-01 17:22:18 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 17:22:18 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 17:22:18 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 17:22:51 - DEBUG --> Key is valid 2023-03-01 17:22:51 - DEBUG --> Key is valid 2023-03-01 17:22:51 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 17:22:51 - DEBUG --> Key is valid 2023-03-01 17:22:51 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 17:22:52 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 19:36:04 - DEBUG --> Key is valid 2023-03-01 19:36:04 - DEBUG --> Key is valid 2023-03-01 19:36:04 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 19:36:04 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 19:36:05 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 20:30:16 - DEBUG --> Key is valid 2023-03-01 20:30:19 - DEBUG --> Key is valid 2023-03-01 20:30:19 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 20:30:20 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 20:30:20 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 20:30:40 - DEBUG --> Key is invalid 2023-03-01 20:30:40 - DEBUG --> Key is invalid 2023-03-01 20:30:41 - DEBUG --> Key is valid 2023-03-01 20:30:41 - DEBUG --> Key is valid 2023-03-01 20:30:41 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 20:30:41 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 20:30:42 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 20:41:47 - DEBUG --> Key is valid 2023-03-01 20:41:47 - DEBUG --> Key is valid 2023-03-01 20:42:24 - DEBUG --> Key is valid 2023-03-01 20:42:24 - DEBUG --> Key is valid 2023-03-01 20:47:28 - DEBUG --> Key is valid 2023-03-01 20:47:28 - DEBUG --> Key is valid 2023-03-01 20:47:34 - DEBUG --> Key is valid 2023-03-01 20:47:34 - DEBUG --> Key is valid 2023-03-01 20:47:55 - DEBUG --> Key is valid 2023-03-01 20:47:55 - DEBUG --> Key is valid 2023-03-01 20:57:30 - DEBUG --> Key is valid 2023-03-01 20:57:30 - DEBUG --> Key is valid 2023-03-01 20:57:30 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 20:57:30 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 20:57:31 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 20:57:34 - DEBUG --> Key is valid 2023-03-01 20:57:34 - DEBUG --> Key is valid 2023-03-01 21:02:46 - DEBUG --> Key is valid 2023-03-01 21:02:46 - DEBUG --> Key is valid 2023-03-01 21:03:24 - DEBUG --> Key is valid 2023-03-01 21:03:24 - DEBUG --> Key is valid 2023-03-01 21:03:24 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 21:03:24 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 21:03:24 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 21:03:28 - DEBUG --> Key is valid 2023-03-01 21:03:28 - DEBUG --> Key is valid 2023-03-01 21:03:41 - DEBUG --> Key is invalid 2023-03-01 21:03:41 - DEBUG --> Key is invalid 2023-03-01 21:03:42 - DEBUG --> Key is valid 2023-03-01 21:03:42 - DEBUG --> Key is valid 2023-03-01 21:03:42 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-01 21:03:42 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-01 21:03:42 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-01 21:09:27 - DEBUG --> Key is valid 2023-03-01 21:09:27 - DEBUG --> Key is valid 2023-03-01 21:09:45 - DEBUG --> Key is valid 2023-03-01 21:09:45 - DEBUG --> Key is valid 2023-03-02 9:31:45 - DEBUG --> Key is valid 2023-03-02 9:31:45 - DEBUG --> Key is valid 2023-03-02 10:41:03 - DEBUG --> Key is valid 2023-03-02 10:41:03 - DEBUG --> Key is valid 2023-03-02 10:41:03 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-02 10:41:03 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-02 10:41:03 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-02 10:41:10 - DEBUG --> Key is valid 2023-03-02 10:41:10 - DEBUG --> Key is valid 2023-03-02 11:49:33 - DEBUG --> Key is valid 2023-03-02 11:49:33 - DEBUG --> Key is valid 2023-03-02 11:49:33 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-02 11:49:33 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-02 11:49:34 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-02 11:49:51 - DEBUG --> Key is valid 2023-03-02 11:49:51 - DEBUG --> Key is valid 2023-03-02 11:49:51 - DEBUG --> Key is valid 2023-03-02 11:49:51 - DEBUG --> Getting queue data for store: kiosk_ou00 2023-03-02 11:49:51 - DEBUG --> Getting queue data for store: kiosk_pc00 2023-03-02 11:49:51 - DEBUG --> Getting queue data for store: kiosk_se00 2023-03-02 11:50:32 - DEBUG --> Key is valid 2023-03-02 11:50:32 - DEBUG --> Key is valid 2023-11-28 12:48:20 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 12:48:20 - DEBUG --> pc00 2023-11-28 12:49:12 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 12:49:12 - DEBUG --> pc00 2023-11-28 12:56:35 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 12:56:35 - DEBUG --> pc00 2023-11-28 12:56:41 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 12:56:41 - DEBUG --> pc00 2023-11-28 12:56:59 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 12:56:59 - DEBUG --> pc00 2023-11-28 12:57:03 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 12:57:03 - DEBUG --> pc00 2023-11-28 12:57:21 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 12:57:21 - DEBUG --> pc00 2023-11-28 12:57:27 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 12:57:27 - DEBUG --> pc00 2023-11-28 12:57:56 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 12:57:56 - DEBUG --> pc00 2023-11-28 13:11:11 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:11:11 - DEBUG --> pc00 2023-11-28 13:12:25 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:12:25 - DEBUG --> pc00 2023-11-28 13:12:31 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:12:31 - DEBUG --> pc00 2023-11-28 13:12:52 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:12:52 - DEBUG --> pc00 2023-11-28 13:15:36 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:15:36 - DEBUG --> pc00 2023-11-28 13:16:02 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:16:02 - DEBUG --> pc00 2023-11-28 13:16:46 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:16:46 - DEBUG --> pc00 2023-11-28 13:17:01 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:17:01 - DEBUG --> pc00 2023-11-28 13:20:03 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:20:03 - DEBUG --> pc00 2023-11-28 13:20:28 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:20:28 - DEBUG --> pc00 2023-11-28 13:20:46 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:20:46 - DEBUG --> pc00 2023-11-28 13:21:21 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:21:21 - DEBUG --> pc00 2023-11-28 13:26:56 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:26:56 - DEBUG --> pc00 2023-11-28 13:55:56 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:55:56 - DEBUG --> pc00 2023-11-28 13:56:03 - DEBUG --> Date:2023-11-28 05:00:00 2023-11-28 13:56:03 - DEBUG --> pc00 2023-12-01 11:19:23 - DEBUG --> Date:2023-12-01 05:00:00 2023-12-01 11:19:23 - DEBUG --> pc00 2023-12-01 11:19:26 - DEBUG --> Date:2023-11-30 05:00:00 2023-12-01 11:19:26 - DEBUG --> pc00 2023-12-01 11:19:28 - DEBUG --> Date:2023-11-29 05:00:00 2023-12-01 11:19:28 - DEBUG --> pc00 2023-12-01 11:19:30 - DEBUG --> Date:2023-11-28 05:00:00 2023-12-01 11:19:30 - DEBUG --> pc00 2023-12-01 11:24:10 - DEBUG --> Date:2023-12-01 05:00:00 2023-12-01 11:24:10 - DEBUG --> pc00 2023-12-01 11:25:23 - DEBUG --> Date:2023-12-01 05:00:00 2023-12-01 11:25:23 - DEBUG --> pc00 2023-12-01 11:25:26 - DEBUG --> Date:2023-11-28 05:00:00 2023-12-01 11:25:26 - DEBUG --> pc00 2023-12-01 11:26:01 - DEBUG --> Date:2023-12-01 05:00:00 2023-12-01 11:26:01 - DEBUG --> pc00 2023-12-01 11:26:06 - DEBUG --> Date:2023-11-28 05:00:00 2023-12-01 11:26:06 - DEBUG --> pc00 2023-12-01 11:26:40 - DEBUG --> Date:2023-12-01 05:00:00 2023-12-01 11:26:40 - DEBUG --> pc00 2023-12-01 11:26:43 - DEBUG --> Date:2023-11-28 05:00:00 2023-12-01 11:26:43 - DEBUG --> pc00 2023-12-01 11:27:38 - DEBUG --> Date:2023-12-01 05:00:00 2023-12-01 11:27:38 - DEBUG --> pc00 2023-12-01 11:27:41 - DEBUG --> Date:2023-11-28 05:00:00 2023-12-01 11:27:41 - DEBUG --> pc00 2023-12-01 11:27:59 - DEBUG --> Date:2023-12-01 05:00:00 2023-12-01 11:28:00 - DEBUG --> pc00 2023-12-01 11:28:06 - DEBUG --> Date:2023-11-28 05:00:00 2023-12-01 11:28:06 - DEBUG --> pc00 2023-12-01 11:31:00 - DEBUG --> Date:2023-12-01 05:00:00 2023-12-01 11:31:00 - DEBUG --> pc00 2023-12-01 11:31:03 - DEBUG --> Date:2023-11-28 05:00:00 2023-12-01 11:31:03 - DEBUG --> pc00 2023-12-01 11:37:28 - DEBUG --> Date:2023-12-01 05:00:00 2023-12-01 11:37:28 - DEBUG --> pc00 2023-12-01 11:37:59 - DEBUG --> Date:2023-12-01 05:00:00 2023-12-01 11:37:59 - DEBUG --> pc00 2023-12-01 11:38:14 - DEBUG --> Date:2023-11-28 05:00:00 2023-12-01 11:38:14 - DEBUG --> pc00 2023-12-01 11:38:17 - DEBUG --> Date:2023-11-29 05:00:00 2023-12-01 11:38:17 - DEBUG --> pc00 2023-12-01 11:38:19 - DEBUG --> Date:2023-11-28 05:00:00 2023-12-01 11:38:19 - DEBUG --> pc00 2025-03-06 12:00:31 - DEBUG --> Before: 2025-03-06 12:00:31 - DEBUG --> DateStart: 2025-03-01 05:01:00 2025-03-06 12:00:31 - DEBUG --> DateEnd: 2025-03-06 12:00:31 2025-03-06 12:00:31 - DEBUG --> After: 2025-03-06 12:00:31 - DEBUG --> DateStart: 2025-03-01 05:00:00 2025-03-06 12:00:31 - DEBUG --> DateEnd: 2025-03-06 05:00:00 2025-03-06 12:03:50 - DEBUG --> Before: 2025-03-06 12:03:50 - DEBUG --> DateStart: 2025-03-01 05:01:00 2025-03-06 12:03:50 - DEBUG --> DateEnd: 2025-03-06 12:03:50 2025-03-06 12:03:50 - DEBUG --> After: 2025-03-06 12:03:50 - DEBUG --> DateStart: 2025-03-01 05:00:00 2025-03-06 12:03:50 - DEBUG --> DateEnd: 2025-03-06 05:00:00 2025-03-06 12:05:09 - DEBUG --> Before: 2025-03-06 12:05:09 - DEBUG --> DateStart: 2025-03-01 05:01:00 2025-03-06 12:05:09 - DEBUG --> DateEnd: 2025-03-06 12:05:09 2025-03-06 12:05:09 - DEBUG --> After: 2025-03-06 12:05:09 - DEBUG --> DateStart: 2025-03-01 05:00:00 2025-03-06 12:05:09 - DEBUG --> DateEnd: 2025-03-06 05:00:00 2025-03-06 12:05:29 - DEBUG --> Before: 2025-03-06 12:05:29 - DEBUG --> DateStart: 2025-03-01 05:01:00 2025-03-06 12:05:29 - DEBUG --> DateEnd: 2025-03-06 12:05:29 2025-03-06 12:05:29 - DEBUG --> After: 2025-03-06 12:05:29 - DEBUG --> DateStart: 2025-03-01 05:00:00 2025-03-06 12:05:29 - DEBUG --> DateEnd: 2025-03-06 05:00:00 2025-03-06 12:06:01 - DEBUG --> Before: 2025-03-06 12:06:01 - DEBUG --> DateStart: 2025-03-01 05:01:00 2025-03-06 12:06:01 - DEBUG --> DateEnd: 2025-03-06 12:06:01 2025-03-06 12:06:01 - DEBUG --> After: 2025-03-06 12:06:01 - DEBUG --> DateStart: 2025-03-01 05:00:00 2025-03-06 12:06:01 - DEBUG --> DateEnd: 2025-03-06 05:00:00 2025-03-06 12:06:13 - DEBUG --> Before: 2025-03-06 12:06:13 - DEBUG --> DateStart: 2025-03-01 05:01:00 2025-03-06 12:06:13 - DEBUG --> DateEnd: 2025-03-06 12:06:13 2025-03-06 12:06:13 - DEBUG --> After: 2025-03-06 12:06:13 - DEBUG --> DateStart: 2025-03-01 05:00:00 2025-03-06 12:06:13 - DEBUG --> DateEnd: 2025-03-06 05:00:00 2025-03-06 12:06:30 - DEBUG --> Before: 2025-03-06 12:06:30 - DEBUG --> DateStart: 2025-03-01 05:01:00 2025-03-06 12:06:30 - DEBUG --> DateEnd: 2025-03-06 12:06:30 2025-03-06 12:06:30 - DEBUG --> After: 2025-03-06 12:06:30 - DEBUG --> DateStart: 2025-03-01 05:00:00 2025-03-06 12:06:30 - DEBUG --> DateEnd: 2025-03-06 05:00:00 2025-03-06 12:07:03 - DEBUG --> Before: 2025-03-06 12:07:03 - DEBUG --> DateStart: 2025-03-01 05:01:00 2025-03-06 12:07:03 - DEBUG --> DateEnd: 2025-03-06 12:07:03 2025-03-06 12:07:03 - DEBUG --> After: 2025-03-06 12:07:03 - DEBUG --> DateStart: 2025-03-01 05:00:00 2025-03-06 12:07:03 - DEBUG --> DateEnd: 2025-03-06 05:00:00 2025-03-06 12:11:10 - DEBUG --> Before: 2025-03-06 12:11:10 - DEBUG --> DateStart: 2025-03-01 05:01:00 2025-03-06 12:11:10 - DEBUG --> DateEnd: 2025-03-06 12:11:10 2025-03-06 12:11:10 - DEBUG --> After: 2025-03-06 12:11:10 - DEBUG --> DateStart: 2025-03-01 05:00:00 2025-03-06 12:11:10 - DEBUG --> DateEnd: 2025-03-06 05:00:00 2025-03-06 12:32:49 - DEBUG --> Before: 2025-03-06 12:32:49 - DEBUG --> DateStart: 2025-03-01 05:01:00 2025-03-06 12:32:49 - DEBUG --> DateEnd: 2025-03-06 12:32:49 2025-03-06 12:32:49 - DEBUG --> After: 2025-03-06 12:32:49 - DEBUG --> DateStart: 2025-03-01 05:00:00 2025-03-06 12:32:49 - DEBUG --> DateEnd: 2025-03-06 05:00:00 2025-07-18 13:27:27 - DEBUG --> Starting Latest Stats 2025-07-18 13:27:27 - DEBUG --> Finished Latest Stats 2025-11-26 16:49:36 - INFO --> changeMPC called 2025-11-26 16:49:38 - INFO --> changeMPC called 2025-11-26 16:49:38 - INFO --> changeMPC called 2025-11-26 16:49:39 - INFO --> changeMPC called 2025-11-26 16:49:40 - INFO --> changeMPC called 2025-11-26 16:49:52 - DEBUG --> Date:2025-11-26 05:00:00 2025-11-26 16:49:52 - DEBUG --> pc00 2025-11-26 16:50:02 - DEBUG --> Date:2025-11-26 05:00:00 2025-11-26 16:50:02 - DEBUG --> pc00 2025-12-01 10:47:06 - DEBUG --> SELECT texts.timestamp, texts.customerID, customers.firstName, customers.lastName, customers.phone, CEIL(ROUND((UNIX_TIMESTAMP(timestamp)/texts.customerID)*100000)/100000) as combined FROM texts INNER JOIN customers ON texts.customerID = customers.customerID WHERE texts.timestamp BETWEEN '2025-12-01 05:00:00' AND '2025-12-03 05:00:00' AND type = 0 GROUP BY combined ORDER BY texts.id DESC 2025-12-01 12:38:42 - DEBUG --> Date:2025-12-01 05:00:00 2025-12-01 12:38:42 - DEBUG --> Date:2025-12-01 05:00:00 2025-12-01 12:38:42 - DEBUG --> pc00 2025-12-01 12:38:42 - DEBUG --> pc00 2025-12-01 16:34:26 - DEBUG --> Date:2025-12-01 05:00:00 2025-12-01 16:34:26 - DEBUG --> Date:2025-12-01 05:00:00 2025-12-01 16:34:27 - DEBUG --> pc00 2025-12-01 16:34:27 - DEBUG --> pc00 2025-12-01 18:39:58 - DEBUG --> Starting Latest Stats 2025-12-01 18:39:58 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:39:58 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:39:58 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:39:58 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:39:58 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:39:58 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:39:58 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:39:58 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:39:58 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:39:58 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:39:58 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:39:58 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:39:58 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:39:58 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:39:58 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:39:58 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:39:58 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:39:58 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:39:58 - DEBUG --> Finished Latest Stats 2025-12-01 18:40:11 - DEBUG --> Starting Latest Stats 2025-12-01 18:40:11 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:40:11 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:40:11 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:40:11 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:40:11 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:40:11 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:40:11 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:40:11 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:40:11 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:40:11 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:40:11 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:40:11 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:40:11 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:40:11 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:40:11 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:40:11 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:40:11 - DEBUG --> Starting Get Latest Store Stats for pc80923 2025-12-01 18:40:11 - DEBUG --> No buy queue data found for store pc80923 2025-12-01 18:40:11 - DEBUG --> Finished Latest Stats 2025-12-01 18:41:41 - DEBUG --> Date:2025-12-01 05:00:00 2025-12-01 18:41:41 - DEBUG --> pc00 2025-12-01 18:41:41 - DEBUG --> Date:2025-12-01 05:00:00 2025-12-01 18:41:41 - DEBUG --> pc00 2025-12-01 19:11:01 - DEBUG --> Date:2025-12-01 05:00:00 2025-12-01 19:11:01 - DEBUG --> Date:2025-12-01 05:00:00 2025-12-01 19:11:01 - DEBUG --> pc00 2025-12-01 19:11:01 - DEBUG --> pc00 2025-12-03 13:00:27 - DEBUG --> SELECT texts.timestamp, texts.customerID, customers.firstName, customers.lastName, customers.phone, CEIL(ROUND((UNIX_TIMESTAMP(timestamp)/texts.customerID)*100000)/100000) as combined FROM texts INNER JOIN customers ON texts.customerID = customers.customerID WHERE texts.timestamp BETWEEN '2025-12-01 05:00:00' AND '2025-12-05 05:00:00' AND type = 0 GROUP BY combined ORDER BY texts.id DESC 2025-12-03 16:29:04 - DEBUG --> Date:2025-12-03 05:00:00 2025-12-03 16:29:04 - DEBUG --> pc00 2025-12-03 16:29:04 - DEBUG --> Date:2025-12-03 05:00:00 2025-12-03 16:29:04 - DEBUG --> pc00 2025-12-03 16:32:07 - DEBUG --> Date:2025-12-03 05:00:00 2025-12-03 16:32:07 - DEBUG --> pc00 2025-12-03 16:32:07 - DEBUG --> Date:2025-12-03 05:00:00 2025-12-03 16:32:07 - DEBUG --> pc00 2025-12-03 17:46:37 - DEBUG --> Date:2025-12-03 05:00:00 2025-12-03 17:46:37 - DEBUG --> ou00 2025-12-03 17:46:37 - DEBUG --> Date:2025-12-03 05:00:00 2025-12-03 17:46:37 - DEBUG --> ou00 2025-12-03 17:52:12 - DEBUG --> Date:2025-12-03 05:00:00 2025-12-03 17:52:12 - DEBUG --> pc00 2025-12-03 17:52:12 - DEBUG --> Date:2025-12-03 05:00:00 2025-12-03 17:52:12 - DEBUG --> pc00 2025-12-03 20:02:18 - DEBUG --> Date:2025-12-03 05:00:00 2025-12-03 20:02:18 - DEBUG --> pc00 2025-12-03 20:02:18 - DEBUG --> Date:2025-12-03 05:00:00 2025-12-03 20:02:18 - DEBUG --> pc00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:33:39 - DEBUG --> Last 30: 2025-11-04 05:00:00 to 2025-12-05 05:00:00 2025-12-04 14:44:36 - DEBUG --> DateStart: 2025-12-01 05:01:00 2025-12-04 14:44:36 - DEBUG --> DateEnd: 2025-12-04 14:44:36 2025-12-04 15:06:00 - DEBUG --> DateStart: 2025-11-04 15:06:00 2025-12-04 15:06:00 - DEBUG --> DateEnd: 2025-12-04 15:06:00 2025-12-04 15:06:00 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-06 05:00:00' AND '2025-12-06 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-06 05:00:00' AND '2025-12-06 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2025-12-04 15:06:05 - DEBUG --> DateStart: 2025-11-04 15:06:05 2025-12-04 15:06:05 - DEBUG --> DateEnd: 2025-12-04 15:06:05 2025-12-04 15:06:05 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-06 05:00:00' AND '2025-12-06 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-06 05:00:00' AND '2025-12-06 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2025-12-04 15:06:10 - DEBUG --> Array Sum for (Mon) - 1228 2025-12-04 15:06:10 - DEBUG --> Array Sum for (Tue) - 1127 2025-12-04 15:06:10 - DEBUG --> Array Sum for (Wed) - 919 2025-12-04 15:06:10 - DEBUG --> Array Sum for (Thu) - 779 2025-12-04 15:06:10 - DEBUG --> Array Sum for (Fri) - 911 2025-12-04 15:06:10 - DEBUG --> Array Sum for (Sat) - 1027 2025-12-04 15:06:10 - DEBUG --> Array Sum for (Sun) - 738 2025-12-04 15:06:44 - DEBUG --> DateStart: 2025-12-01 05:01:00 2025-12-04 15:06:44 - DEBUG --> DateEnd: 2025-12-04 15:06:44 2025-12-04 15:10:19 - DEBUG --> DateStart: 2025-12-01 05:01:00 2025-12-04 15:10:19 - DEBUG --> DateEnd: 2025-12-04 15:10:19 2025-12-04 15:18:11 - DEBUG --> DateStart: 2025-12-01 05:01:00 2025-12-04 15:18:11 - DEBUG --> DateEnd: 2025-12-04 15:18:11 2025-12-04 15:19:58 - DEBUG --> DateStart: 2025-11-04 15:19:58 2025-12-04 15:19:58 - DEBUG --> DateEnd: 2025-12-04 15:19:58 2025-12-04 15:19:58 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-06 05:00:00' AND '2025-12-06 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-06 05:00:00' AND '2025-12-06 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2025-12-04 15:20:02 - DEBUG --> DateStart: 2025-11-04 15:20:02 2025-12-04 15:20:02 - DEBUG --> DateEnd: 2025-12-04 15:20:02 2025-12-04 15:20:02 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-06 05:00:00' AND '2025-12-06 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-06 05:00:00' AND '2025-12-06 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2025-12-04 15:20:06 - DEBUG --> Array Sum for (Mon) - 1228 2025-12-04 15:20:06 - DEBUG --> Array Sum for (Tue) - 1127 2025-12-04 15:20:06 - DEBUG --> Array Sum for (Wed) - 919 2025-12-04 15:20:06 - DEBUG --> Array Sum for (Thu) - 779 2025-12-04 15:20:06 - DEBUG --> Array Sum for (Fri) - 911 2025-12-04 15:20:06 - DEBUG --> Array Sum for (Sat) - 1027 2025-12-04 15:20:06 - DEBUG --> Array Sum for (Sun) - 738 2025-12-08 7:57:46 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-10 05:00:00' AND '2025-12-10 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-10 05:00:00' AND '2025-12-10 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2025-12-08 9:48:09 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-10 05:00:00' AND '2025-12-10 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-10 05:00:00' AND '2025-12-10 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2025-12-08 9:48:12 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-10 05:00:00' AND '2025-12-10 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-10-10 05:00:00' AND '2025-12-10 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2025-12-08 9:48:15 - DEBUG --> Array Sum for (Mon) - 1163 2025-12-08 9:48:15 - DEBUG --> Array Sum for (Tue) - 1127 2025-12-08 9:48:15 - DEBUG --> Array Sum for (Wed) - 919 2025-12-08 9:48:15 - DEBUG --> Array Sum for (Thu) - 786 2025-12-08 9:48:15 - DEBUG --> Array Sum for (Fri) - 859 2025-12-08 9:48:15 - DEBUG --> Array Sum for (Sat) - 943 2025-12-08 9:48:15 - DEBUG --> Array Sum for (Sun) - 707 2025-12-08 10:12:28 - DEBUG --> Date:2025-12-08 05:00:00 2025-12-08 10:12:28 - DEBUG --> Date:2025-12-08 05:00:00 2025-12-08 10:12:28 - DEBUG --> ou00 2025-12-08 10:12:28 - DEBUG --> ou00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:22:16 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:30:03 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 10:36:58 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:27:49 - DEBUG --> Last 30: 2025-11-08 05:00:00 to 2025-12-09 05:00:00 2025-12-08 11:39:07 - DEBUG --> Date:2025-12-08 05:00:00 2025-12-08 11:39:07 - DEBUG --> ou00 2025-12-08 11:39:07 - DEBUG --> Date:2025-12-08 05:00:00 2025-12-08 11:39:07 - DEBUG --> ou00 2025-12-09 7:52:31 - DEBUG --> Date:2025-12-09 05:00:00 2025-12-09 7:52:31 - DEBUG --> Date:2025-12-09 05:00:00 2025-12-09 7:52:31 - DEBUG --> ou00 2025-12-09 7:52:31 - DEBUG --> ou00 2025-12-15 11:34:18 - DEBUG --> Date:2025-12-15 05:00:00 2025-12-15 11:34:18 - DEBUG --> Date:2025-12-15 05:00:00 2025-12-15 11:34:18 - DEBUG --> pc00 2025-12-15 11:34:18 - DEBUG --> pc00 2025-12-31 11:05:01 - DEBUG --> Array Sum for (Mon) - 940 2025-12-31 11:05:01 - DEBUG --> Array Sum for (Tue) - 898 2025-12-31 11:05:01 - DEBUG --> Array Sum for (Wed) - 820 2025-12-31 11:05:01 - DEBUG --> Array Sum for (Thu) - 679 2025-12-31 11:05:01 - DEBUG --> Array Sum for (Fri) - 736 2025-12-31 11:05:01 - DEBUG --> Array Sum for (Sat) - 841 2025-12-31 11:05:01 - DEBUG --> Array Sum for (Sun) - 638 2025-12-31 11:05:25 - DEBUG --> DateStart: 2025-12-01 05:01:00 2025-12-31 11:05:25 - DEBUG --> DateEnd: 2025-12-31 11:05:25 2025-12-31 11:05:31 - DEBUG --> DateStart: 2025-12-01 11:05:31 2025-12-31 11:05:31 - DEBUG --> DateEnd: 2025-12-31 11:05:31 2025-12-31 11:05:31 - DEBUG --> SELECT FLOOR(0_sortDelay/totalSortCount) as sortDelayAvg, FLOOR(0_sortTime/totalSortCount) as sortTimeAvg, FLOOR(0_delayFromSortToProcess/totalSortCount) as sortToProcessDelayAvg, FLOOR(0_processTime/totalSortCount) as processTimeAvgWithSorter, FLOOR(1_processDelay/totalNonSortCount) as processDelayAvgWithoutSorter, FLOOR(1_processTime/totalNonSortCount) as processTimeAvgWithoutSorter FROM (SELECT SUM(UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered )) AS 0_sortDelay, SUM(UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted )) AS 0_sortTime, SUM(UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted )) AS 0_delayFromSortToProcess, SUM(UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted )) AS 0_processTime, COUNT(*) as totalSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-11-02 05:00:00' AND '2026-01-02 05:00:00') AND sorterID >0 AND sortCompleted != '0000-00-00 00:00:00' AND isProcessed !=0 AND (UNIX_TIMESTAMP( sortStarted ) - UNIX_TIMESTAMP( timeEntered ) > 0) AND (UNIX_TIMESTAMP( sortCompleted ) - UNIX_TIMESTAMP( sortStarted ) > 0) AND (UNIX_TIMESTAMP( timeStarted ) - UNIX_TIMESTAMP( sortCompleted ) > 0) AND (UNIX_TIMESTAMP( timeCompleted ) - UNIX_TIMESTAMP( timeStarted ) > 0)) AS A, (SELECT SUM(UNIX_TIMESTAMP(timeStarted) - UNIX_TIMESTAMP(timeEntered)) as 1_processDelay, SUM(UNIX_TIMESTAMP(timeCompleted) - UNIX_TIMESTAMP(timeStarted)) as 1_processTime, COUNT(*) as totalNonSortCount FROM buyQueue WHERE (timeEntered BETWEEN '2025-11-02 05:00:00' AND '2026-01-02 05:00:00') AND sorterID = 0 AND isProcessed !=0 ) AS B 2025-12-31 11:37:24 - DEBUG --> Array Sum for (Mon) - 940 2025-12-31 11:37:24 - DEBUG --> Array Sum for (Tue) - 898 2025-12-31 11:37:24 - DEBUG --> Array Sum for (Wed) - 821 2025-12-31 11:37:24 - DEBUG --> Array Sum for (Thu) - 679 2025-12-31 11:37:24 - DEBUG --> Array Sum for (Fri) - 736 2025-12-31 11:37:24 - DEBUG --> Array Sum for (Sat) - 841 2025-12-31 11:37:24 - DEBUG --> Array Sum for (Sun) - 638 2025-12-31 11:39:28 - DEBUG --> Array Sum for (Mon) - 940 2025-12-31 11:39:28 - DEBUG --> Array Sum for (Tue) - 898 2025-12-31 11:39:28 - DEBUG --> Array Sum for (Wed) - 821 2025-12-31 11:39:28 - DEBUG --> Array Sum for (Thu) - 679 2025-12-31 11:39:28 - DEBUG --> Array Sum for (Fri) - 736 2025-12-31 11:39:28 - DEBUG --> Array Sum for (Sat) - 841 2025-12-31 11:39:28 - DEBUG --> Array Sum for (Sun) - 638 2025-12-31 11:52:24 - DEBUG --> DateStart: 2025-12-01 05:01:00 2025-12-31 11:52:24 - DEBUG --> DateEnd: 2025-12-31 11:52:24 2026-02-05 15:14:57 - DEBUG --> Date:2026-02-05 05:00:00 2026-02-05 15:14:57 - DEBUG --> Date:2026-02-05 05:00:00 2026-02-05 15:14:57 - DEBUG --> ou00 2026-02-05 15:14:57 - DEBUG --> ou00 2026-02-05 15:33:01 - DEBUG --> Date:2026-02-05 05:00:00 2026-02-05 15:33:01 - DEBUG --> Date:2026-02-05 05:00:00 2026-02-05 15:33:01 - DEBUG --> ou00 2026-02-05 15:33:01 - DEBUG --> ou00 2026-02-10 8:35:56 - DEBUG --> Date:2026-02-10 05:00:00 2026-02-10 8:35:56 - DEBUG --> Date:2026-02-10 05:00:00 2026-02-10 8:35:56 - DEBUG --> pc00 2026-02-10 8:35:56 - DEBUG --> pc00 2026-02-10 8:36:10 - DEBUG --> Date:2026-02-10 05:00:00 2026-02-10 8:36:10 - DEBUG --> Date:2026-02-10 05:00:00 2026-02-10 8:36:10 - DEBUG --> ou00 2026-02-10 8:36:10 - DEBUG --> ou00 2026-02-11 13:18:39 - DEBUG --> Date:2026-02-11 05:00:00 2026-02-11 13:18:39 - DEBUG --> Date:2026-02-11 05:00:00 2026-02-11 13:18:39 - DEBUG --> ou00 2026-02-11 13:18:39 - DEBUG --> ou00