C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090731 7:15:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 4 Rows_examined: 5 use openbravopos; SELECT ID, NAME, APPPASSWORD, CARD, ROLE, IMAGE FROM PEOPLE WHERE VISIBLE = TRUE; # Time: 090731 7:24:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, IMAGE FROM FLOORS ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 29 Rows_examined: 29 SELECT ID, NAME, X, Y, FLOOR FROM PLACES ORDER BY FLOOR; # Time: 090731 7:25:00 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 7:48:55 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `applications`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `attribute`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `attributeinstance`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `attributeset`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `attributesetinstance`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `attributeuse`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `attributevalue`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 34 Rows_examined: 34 SELECT /*!40001 SQL_NO_CACHE */ * FROM `categories`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 266 Rows_examined: 266 SELECT /*!40001 SQL_NO_CACHE */ * FROM `closedcash`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT /*!40001 SQL_NO_CACHE */ * FROM `customers`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `floors`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `locations`; # Time: 090731 7:48:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 2 Lock_time: 0 Rows_sent: 34450 Rows_examined: 34450 SELECT /*!40001 SQL_NO_CACHE */ * FROM `payments`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 5 Rows_examined: 5 SELECT /*!40001 SQL_NO_CACHE */ * FROM `people`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 29 Rows_examined: 29 SELECT /*!40001 SQL_NO_CACHE */ * FROM `places`; # Time: 090731 7:48:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 2 Lock_time: 0 Rows_sent: 418 Rows_examined: 418 SELECT /*!40001 SQL_NO_CACHE */ * FROM `products`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 404 Rows_examined: 404 SELECT /*!40001 SQL_NO_CACHE */ * FROM `products_cat`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 436 Rows_examined: 436 SELECT /*!40001 SQL_NO_CACHE */ * FROM `products_com`; # Time: 090731 7:49:00 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 1 Lock_time: 0 Rows_sent: 34438 Rows_examined: 34438 SELECT /*!40001 SQL_NO_CACHE */ * FROM `receipts`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `reservation_customers`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `reservations`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 51 Rows_examined: 51 SELECT /*!40001 SQL_NO_CACHE */ * FROM `resources`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 5 Rows_examined: 5 SELECT /*!40001 SQL_NO_CACHE */ * FROM `roles`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `sharedtickets`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 405 Rows_examined: 405 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockcurrent`; # Time: 090731 7:49:04 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 3 Lock_time: 0 Rows_sent: 149435 Rows_examined: 149435 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 385 Rows_examined: 385 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stocklevel`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT /*!40001 SQL_NO_CACHE */ * FROM `taxcategories`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `taxcustcategories`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `taxes`; # Time: 090731 7:49:06 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 2 Lock_time: 0 Rows_sent: 34427 Rows_examined: 34427 SELECT /*!40001 SQL_NO_CACHE */ * FROM `taxlines`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `thirdparties`; # Time: 090731 7:49:17 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 156214 Rows_examined: 156214 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; # Time: 090731 7:49:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 1 Lock_time: 0 Rows_sent: 34438 Rows_examined: 34438 SELECT /*!40001 SQL_NO_CACHE */ * FROM `tickets`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketsnum`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketsnum_payment`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketsnum_refund`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090731 7:51:06 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 4 Rows_examined: 5 use openbravopos; SELECT ID, NAME, APPPASSWORD, CARD, ROLE, IMAGE FROM PEOPLE WHERE VISIBLE = TRUE; # Time: 090731 7:51:24 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, IMAGE FROM FLOORS ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 29 Rows_examined: 29 SELECT ID, NAME, X, Y, FLOOR FROM PLACES ORDER BY FLOOR; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 8:03:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34433; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:05:49 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34434; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:09:44 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34435; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:10:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34436; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:10:26 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34437; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:12:43 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34438; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:13:19 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34439; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:13:47 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34440; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:17:06 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34441; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:23:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34442; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:29:33 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34443; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:30:27 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34444; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:30:45 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34445; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:31:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34446; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:33:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34447; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:34:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34448; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:34:32 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34449; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:35:23 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34450; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:44:44 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34451; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:46:55 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34452; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:48:17 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34453; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:49:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34454; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:53:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34455; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:57:04 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34456; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 8:58:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34457; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:01:25 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34458; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:02:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34459; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:02:27 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34460; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:05:28 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34461; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:07:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34462; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:11:32 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34463; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:12:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34464; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:15:08 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34465; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:16:33 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34466; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:18:03 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34467; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:21:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34468; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:22:15 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34469; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:22:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34470; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:23:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34471; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:28:35 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34472; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:28:55 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34473; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:29:19 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34474; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:29:37 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34475; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:29:55 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34476; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:32:49 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34477; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:37:58 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34478; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:38:55 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34479; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:41:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34480; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:43:06 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34481; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:43:35 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34482; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:44:09 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34483; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:44:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34484; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:44:49 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34485; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:45:56 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34486; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:50:23 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34487; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:50:42 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34488; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:53:27 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34489; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:54:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34490; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:54:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34491; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:54:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34492; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 9:58:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34493; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:05:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34494; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:11:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34495; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:12:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34496; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:13:00 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34497; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:14:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34498; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:21:25 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34499; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:24:08 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34500; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:26:52 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34501; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:32:36 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34502; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:35:22 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 2 Lock_time: 0 Rows_sent: 1 Rows_examined: 68993 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'; # Time: 090731 10:35:26 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 68997 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'GROUP BY TAXCATEGORIES.NAME; # Time: 090731 10:35:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 7 Rows_examined: 7 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 10:44:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34503; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:53:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34504; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:54:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34505; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 10:56:09 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34506; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:02:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34507; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:05:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34508; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:09:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34509; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:15:44 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34510; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:27:36 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34511; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:33:44 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34512; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:43:36 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34513; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:46:28 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34514; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:51:30 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34515; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:52:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34516; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:55:17 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34517; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:55:49 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34518; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:57:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34519; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 11:58:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34520; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:05:45 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34521; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:08:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34522; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:10:03 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34523; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:16:01 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34524; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:26:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34525; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:29:05 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34526; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:37:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34527; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:39:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34528; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:43:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34529; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:44:13 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34530; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:45:32 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34531; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:48:34 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34532; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:49:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34533; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:50:47 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 3 SELECT ID, TAXID, SEARCHKEY, NAME FROM CUSTOMERS WHERE VISIBLE = TRUE AND (1=1) ORDER BY NAME; # Time: 090731 12:50:51 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34534; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:51:05 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34535; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:52:09 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34536; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:58:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34537; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:59:15 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34538; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 12:59:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34539; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:00:06 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34540; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:01:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34541; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:02:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34542; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:12:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34543; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:13:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 69075 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'; # Time: 090731 13:13:54 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 69079 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'GROUP BY TAXCATEGORIES.NAME; # Time: 090731 13:14:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 7 Rows_examined: 7 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 13:17:10 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34544; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:22:23 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34545; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:25:08 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34546; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:30:13 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34547; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:31:10 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34548; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:31:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34549; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:33:10 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34550; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:37:20 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34551; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:45:09 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34552; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:46:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34553; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 13:47:34 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34554; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:01:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34555; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:07:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34556; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:10:01 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34557; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:16:51 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34558; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:18:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34559; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:19:05 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34560; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:21:23 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34561; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:22:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34562; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:23:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34563; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:28:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34564; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:29:36 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34565; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:30:52 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34566; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:38:55 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34567; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:41:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34568; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:42:22 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34569; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:44:49 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34570; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:46:17 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34571; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:47:35 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34572; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 14:53:35 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 69133 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'; # Time: 090731 14:53:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 69137 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'GROUP BY TAXCATEGORIES.NAME; # Time: 090731 14:53:40 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 15:00:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34573; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:02:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34574; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:12:34 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34575; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:14:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34576; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:15:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34577; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:15:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34578; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:16:17 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34579; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:17:35 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34580; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:22:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34581; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:24:47 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 2 Lock_time: 0 Rows_sent: 1 Rows_examined: 69151 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'; # Time: 090731 15:24:51 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 69155 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'GROUP BY TAXCATEGORIES.NAME; # Time: 090731 15:24:55 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 2 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 15:30:04 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34582; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:30:29 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34583; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:31:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34584; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:39:51 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 69157 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'; # Time: 090731 15:39:55 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 69161 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'GROUP BY TAXCATEGORIES.NAME; # Time: 090731 15:39:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 15:40:33 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34585; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:41:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34586; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 15:54:56 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34587; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:00:28 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34588; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:04:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34589; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:11:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34590; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:17:49 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34591; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:18:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34592; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:18:58 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34593; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:19:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34594; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:19:32 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34595; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:25:28 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34596; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:27:26 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34597; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:30:22 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34598; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:34:44 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34599; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:41:27 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34600; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:52:26 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 69189 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'; # Time: 090731 16:52:30 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 69193 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'GROUP BY TAXCATEGORIES.NAME; # Time: 090731 16:52:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 2 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 16:56:08 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34601; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 16:56:47 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34602; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 17:04:58 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 69193 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'; # Time: 090731 17:05:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 69197 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'GROUP BY TAXCATEGORIES.NAME; # Time: 090731 17:05:08 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 2 Rows_examined: 2 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 17:14:52 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34603; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 17:17:56 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34604; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 17:34:10 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34605; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 17:35:15 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34606; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 17:38:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34607; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 17:40:19 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34608; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 17:50:35 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34609; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 17:52:08 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34610; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 18:10:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34611; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 18:16:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 69211 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'; # Time: 090731 18:16:52 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 69215 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'GROUP BY TAXCATEGORIES.NAME; # Time: 090731 18:16:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 5 Rows_examined: 5 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 18:19:20 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34612; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 18:27:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34613; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 18:34:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34614; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 18:39:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34615; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 18:41:08 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34616; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 18:41:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34617; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 18:47:05 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34618; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 19:19:51 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34619; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 19:21:51 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34620; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 19:31:49 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34621; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 19:38:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34622; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 19:46:37 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34623; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 19:48:22 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34624; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 20:01:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34625; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 20:03:24 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 69239 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'; # Time: 090731 20:03:28 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 4 Lock_time: 0 Rows_sent: 1 Rows_examined: 69243 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'GROUP BY TAXCATEGORIES.NAME; # Time: 090731 20:03:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 7 Rows_examined: 7 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 20:07:55 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34626; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 20:09:13 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34627; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 20:29:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34628; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 20:35:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34629; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 20:40:47 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34630; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 20:41:01 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34631; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 20:49:40 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34632; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 20:57:03 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34633; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 20:58:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34634; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 21:03:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SET insert_id=34635; UPDATE TICKETSNUM SET ID = LAST_INSERT_ID(ID + 1); # Time: 090731 21:44:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 4 Rows_examined: 5 SELECT ID, NAME, APPPASSWORD, CARD, ROLE, IMAGE FROM PEOPLE WHERE VISIBLE = TRUE; # Time: 090731 21:45:03 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 4 Rows_examined: 5 SELECT ID, NAME, APPPASSWORD, CARD, ROLE, IMAGE FROM PEOPLE WHERE VISIBLE = TRUE; # Time: 090731 21:45:30 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, IMAGE FROM FLOORS ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 29 Rows_examined: 29 SELECT ID, NAME, X, Y, FLOOR FROM PLACES ORDER BY FLOOR; # Time: 090731 21:45:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 21:45:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 4 Rows_examined: 5 SELECT ID, NAME, APPPASSWORD, CARD, ROLE, IMAGE FROM PEOPLE WHERE VISIBLE = TRUE; # Time: 090731 21:45:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT ID, NAME FROM TAXCATEGORIES ORDER BY NAME; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME FROM SHAREDTICKETS ORDER BY ID; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT ID, NAME, CATEGORY, CUSTCATEGORY, PARENTID, RATE, RATECASCADE, RATEORDER FROM TAXES ORDER BY NAME; # Time: 090731 21:45:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `applications`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `attribute`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `attributeinstance`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `attributeset`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `attributesetinstance`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `attributeuse`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `attributevalue`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 34 Rows_examined: 34 SELECT /*!40001 SQL_NO_CACHE */ * FROM `categories`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 266 Rows_examined: 266 SELECT /*!40001 SQL_NO_CACHE */ * FROM `closedcash`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT /*!40001 SQL_NO_CACHE */ * FROM `customers`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `floors`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `locations`; # Time: 090731 21:45:54 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 1 Lock_time: 0 Rows_sent: 34653 Rows_examined: 34653 SELECT /*!40001 SQL_NO_CACHE */ * FROM `payments`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 5 Rows_examined: 5 SELECT /*!40001 SQL_NO_CACHE */ * FROM `people`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 29 Rows_examined: 29 SELECT /*!40001 SQL_NO_CACHE */ * FROM `places`; # Time: 090731 21:45:55 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 1 Lock_time: 0 Rows_sent: 418 Rows_examined: 418 SELECT /*!40001 SQL_NO_CACHE */ * FROM `products`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 404 Rows_examined: 404 SELECT /*!40001 SQL_NO_CACHE */ * FROM `products_cat`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 436 Rows_examined: 436 SELECT /*!40001 SQL_NO_CACHE */ * FROM `products_com`; # Time: 090731 21:45:56 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 34641 Rows_examined: 34641 SELECT /*!40001 SQL_NO_CACHE */ * FROM `receipts`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `reservation_customers`; # Time: 090731 21:45:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `reservations`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 51 Rows_examined: 51 SELECT /*!40001 SQL_NO_CACHE */ * FROM `resources`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 5 Rows_examined: 5 SELECT /*!40001 SQL_NO_CACHE */ * FROM `roles`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `sharedtickets`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 405 Rows_examined: 405 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockcurrent`; # Time: 090731 21:46:01 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 4 Lock_time: 0 Rows_sent: 150223 Rows_examined: 150223 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 385 Rows_examined: 385 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stocklevel`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 3 Rows_examined: 3 SELECT /*!40001 SQL_NO_CACHE */ * FROM `taxcategories`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `taxcustcategories`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `taxes`; # Time: 090731 21:46:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 1 Lock_time: 0 Rows_sent: 34630 Rows_examined: 34630 SELECT /*!40001 SQL_NO_CACHE */ * FROM `taxlines`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 0 Rows_examined: 0 SELECT /*!40001 SQL_NO_CACHE */ * FROM `thirdparties`; # Time: 090731 21:46:15 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 157026 Rows_examined: 157026 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; # Time: 090731 21:46:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 1 Lock_time: 0 Rows_sent: 34641 Rows_examined: 34641 SELECT /*!40001 SQL_NO_CACHE */ * FROM `tickets`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketsnum`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketsnum_payment`; # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 0 Lock_time: 0 Rows_sent: 1 Rows_examined: 1 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketsnum_refund`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090731 21:47:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 1 Lock_time: 1 Rows_sent: 4 Rows_examined: 5 use openbravopos; SELECT ID, NAME, APPPASSWORD, CARD, ROLE, IMAGE FROM PEOPLE WHERE VISIBLE = TRUE; # Time: 090731 21:49:24 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 5 Lock_time: 0 Rows_sent: 34641 Rows_examined: 34641 SELECT * FROM receipts order by datenew desc; # Time: 090731 21:51:36 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 69259 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc'; # Time: 090731 21:51:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 3 Lock_time: 0 Rows_sent: 1 Rows_examined: 69263 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '9d61b898-9ccf-484f-b80f-22c17b7b85bc' GROUP BY TAXCATEGORIES.NAME; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090731 22:03:36 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 157026 Rows_examined: 157026 use openbravopos; SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090801 22:02:08 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 158117 Rows_examined: 158117 use openbravopos; SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090802 16:28:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 14 Lock_time: 0 Rows_sent: 158845 Rows_examined: 158845 use openbravopos; SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090803 17:36:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 159376 Rows_examined: 159376 use openbravopos; SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090804 17:54:43 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 14 Lock_time: 0 Rows_sent: 159911 Rows_examined: 159911 use openbravopos; SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090805 12:01:54 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 70701 use openbravopos; SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '4220c78f-490b-467a-b468-18be926d0529'GROUP BY TAXCATEGORIES.NAME; # Time: 090805 12:52:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 70721 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '4220c78f-490b-467a-b468-18be926d0529'GROUP BY TAXCATEGORIES.NAME; # Time: 090805 13:39:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 70743 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '4220c78f-490b-467a-b468-18be926d0529'GROUP BY TAXCATEGORIES.NAME; # Time: 090805 14:03:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 70763 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '4220c78f-490b-467a-b468-18be926d0529'GROUP BY TAXCATEGORIES.NAME; # Time: 090805 14:42:46 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 70783 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '4220c78f-490b-467a-b468-18be926d0529'GROUP BY TAXCATEGORIES.NAME; # Time: 090805 15:18:58 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 70807 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '4220c78f-490b-467a-b468-18be926d0529'GROUP BY TAXCATEGORIES.NAME; # Time: 090805 17:17:32 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 70841 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '4220c78f-490b-467a-b468-18be926d0529'GROUP BY TAXCATEGORIES.NAME; # Time: 090805 17:37:52 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 16 Lock_time: 0 Rows_sent: 160365 Rows_examined: 160365 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090806 12:57:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 70999 use openbravopos; SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '9a15fbfa-838d-496e-b325-4b6f7806e37b'GROUP BY TAXCATEGORIES.NAME; # Time: 090806 13:28:27 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71023 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '9a15fbfa-838d-496e-b325-4b6f7806e37b'GROUP BY TAXCATEGORIES.NAME; # Time: 090806 17:30:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 17 Lock_time: 0 Rows_sent: 160818 Rows_examined: 160818 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090807 19:13:22 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71459 use openbravopos; SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'd2ec30c0-06ae-49ae-bd4e-76a00df6e61d'GROUP BY TAXCATEGORIES.NAME; # Time: 090807 20:48:58 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71485 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'd2ec30c0-06ae-49ae-bd4e-76a00df6e61d'; # Time: 090807 20:49:04 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71489 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'd2ec30c0-06ae-49ae-bd4e-76a00df6e61d'GROUP BY TAXCATEGORIES.NAME; # Time: 090807 22:14:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71493 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'd2ec30c0-06ae-49ae-bd4e-76a00df6e61d'; # Time: 090807 22:14:08 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71497 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'd2ec30c0-06ae-49ae-bd4e-76a00df6e61d'GROUP BY TAXCATEGORIES.NAME; # Time: 090807 22:21:33 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71493 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'd2ec30c0-06ae-49ae-bd4e-76a00df6e61d'; # Time: 090807 22:21:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71497 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'd2ec30c0-06ae-49ae-bd4e-76a00df6e61d'GROUP BY TAXCATEGORIES.NAME; # Time: 090807 23:45:32 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71497 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'd2ec30c0-06ae-49ae-bd4e-76a00df6e61d'; # Time: 090807 23:45:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71501 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'd2ec30c0-06ae-49ae-bd4e-76a00df6e61d'GROUP BY TAXCATEGORIES.NAME; # Time: 090807 23:49:34 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 17 Lock_time: 0 Rows_sent: 161608 Rows_examined: 161608 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090808 10:10:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71607 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 10:10:37 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71611 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 11:43:35 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71683 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 11:43:42 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71687 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 12:15:11 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71717 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 12:15:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71721 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 13:40:44 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71771 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 13:40:51 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71775 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 14:09:36 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71777 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 14:09:42 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71781 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 14:32:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71797 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 14:32:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71801 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 14:58:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 71813 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 14:58:47 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71817 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 15:42:43 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71833 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 15:42:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71837 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 15:52:49 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 1 Rows_examined: 71843 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 15:52:56 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71847 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 18:48:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71895 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 18:48:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71899 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 20:54:27 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71911 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 20:54:34 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71915 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 21:59:13 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71931 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 21:59:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 71935 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 22:18:05 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 71933 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 22:18:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71937 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 22:52:28 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 71935 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'; # Time: 090808 22:52:36 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 71939 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6785c6e3-4e46-4a54-9e8d-af2bac06b444'GROUP BY TAXCATEGORIES.NAME; # Time: 090808 23:19:40 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 18 Lock_time: 0 Rows_sent: 162740 Rows_examined: 162740 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090809 11:21:22 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 72069 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'; # Time: 090809 11:21:30 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 72073 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'GROUP BY TAXCATEGORIES.NAME; # Time: 090809 12:04:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 72107 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'; # Time: 090809 12:04:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 9 Lock_time: 0 Rows_sent: 1 Rows_examined: 72111 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'GROUP BY TAXCATEGORIES.NAME; # Time: 090809 12:51:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 72143 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'; # Time: 090809 12:51:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 9 Lock_time: 0 Rows_sent: 1 Rows_examined: 72147 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'GROUP BY TAXCATEGORIES.NAME; # Time: 090809 13:22:11 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 72159 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'; # Time: 090809 13:22:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 1 Rows_examined: 72163 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'GROUP BY TAXCATEGORIES.NAME; # Time: 090809 13:36:03 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 72175 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'; # Time: 090809 13:36:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 9 Lock_time: 0 Rows_sent: 1 Rows_examined: 72179 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'GROUP BY TAXCATEGORIES.NAME; # Time: 090809 14:39:55 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 72217 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'; # Time: 090809 14:40:05 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 1 Rows_examined: 72221 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'GROUP BY TAXCATEGORIES.NAME; # Time: 090809 15:44:27 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 72251 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'; # Time: 090809 15:44:37 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 1 Rows_examined: 72255 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'GROUP BY TAXCATEGORIES.NAME; # Time: 090809 15:50:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 72253 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'; # Time: 090809 15:50:17 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 1 Rows_examined: 72257 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'GROUP BY TAXCATEGORIES.NAME; # Time: 090809 16:56:40 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 72261 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'; # Time: 090809 16:56:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 1 Rows_examined: 72265 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '529cb035-5d31-4039-b54e-3e9815ce93b4'GROUP BY TAXCATEGORIES.NAME; # Time: 090809 17:11:27 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 20 Lock_time: 0 Rows_sent: 163629 Rows_examined: 163629 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090810 9:42:03 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 72321 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'; # Time: 090810 9:42:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 72325 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'GROUP BY TAXCATEGORIES.NAME; # Time: 090810 10:55:35 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 1 Rows_examined: 72371 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'; # Time: 090810 10:55:46 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 72375 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'GROUP BY TAXCATEGORIES.NAME; # Time: 090810 12:23:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 1 Rows_examined: 72415 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'; # Time: 090810 12:23:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 72419 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'GROUP BY TAXCATEGORIES.NAME; # Time: 090810 13:32:52 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 9 Lock_time: 0 Rows_sent: 1 Rows_examined: 72441 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'; # Time: 090810 13:33:03 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 72445 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'GROUP BY TAXCATEGORIES.NAME; # Time: 090810 14:29:28 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 9 Lock_time: 0 Rows_sent: 1 Rows_examined: 72475 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'; # Time: 090810 14:29:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 72479 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'GROUP BY TAXCATEGORIES.NAME; # Time: 090810 15:09:30 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 9 Lock_time: 0 Rows_sent: 1 Rows_examined: 72493 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'; # Time: 090810 15:09:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 72497 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'GROUP BY TAXCATEGORIES.NAME; # Time: 090810 16:05:19 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 1 Rows_examined: 72509 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'; # Time: 090810 16:05:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 1 Rows_examined: 72513 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'GROUP BY TAXCATEGORIES.NAME; # Time: 090810 16:54:01 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 9 Lock_time: 0 Rows_sent: 1 Rows_examined: 72517 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'; # Time: 090810 16:54:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 72521 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'GROUP BY TAXCATEGORIES.NAME; # Time: 090810 17:33:20 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 9 Lock_time: 0 Rows_sent: 1 Rows_examined: 72521 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'; # Time: 090810 17:33:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 72525 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '500c5851-2df7-4aa1-938e-4591f9e5b88b'GROUP BY TAXCATEGORIES.NAME; # Time: 090810 17:40:06 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 22 Lock_time: 0 Rows_sent: 164176 Rows_examined: 164176 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090811 10:48:45 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 1 Rows_examined: 72643 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'; # Time: 090811 10:48:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 1 Rows_examined: 72647 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'GROUP BY TAXCATEGORIES.NAME; # Time: 090811 12:07:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 1 Rows_examined: 72677 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'; # Time: 090811 12:08:00 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 1 Rows_examined: 72681 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'GROUP BY TAXCATEGORIES.NAME; # Time: 090811 12:58:10 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 72707 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'; # Time: 090811 12:58:22 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 1 Rows_examined: 72711 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'GROUP BY TAXCATEGORIES.NAME; # Time: 090811 13:41:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 72739 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'; # Time: 090811 13:42:03 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 1 Rows_examined: 72743 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'GROUP BY TAXCATEGORIES.NAME; # Time: 090811 14:10:26 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 1 Rows_examined: 72759 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'; # Time: 090811 14:10:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 1 Rows_examined: 72763 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'GROUP BY TAXCATEGORIES.NAME; # Time: 090811 14:39:23 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 1 Rows_examined: 72775 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'; # Time: 090811 14:39:36 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 1 Rows_examined: 72779 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'GROUP BY TAXCATEGORIES.NAME; # Time: 090811 15:58:03 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 1 Rows_examined: 72821 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'; # Time: 090811 15:58:17 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 14 Lock_time: 0 Rows_sent: 1 Rows_examined: 72825 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'GROUP BY TAXCATEGORIES.NAME; # Time: 090811 17:33:34 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 1 Rows_examined: 72841 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'; # Time: 090811 17:33:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 14 Lock_time: 0 Rows_sent: 1 Rows_examined: 72845 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '50eb3bd9-fe97-462b-86b3-c231d22bcd85'GROUP BY TAXCATEGORIES.NAME; # Time: 090811 17:49:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 157673 Rows_examined: 157673 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090811 17:50:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 23 Lock_time: 0 Rows_sent: 164755 Rows_examined: 164755 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090812 9:08:26 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 1 Rows_examined: 72901 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'; # Time: 090812 9:08:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 15 Lock_time: 0 Rows_sent: 1 Rows_examined: 72905 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'GROUP BY TAXCATEGORIES.NAME; # Time: 090812 12:18:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 1 Rows_examined: 72977 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'; # Time: 090812 12:18:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 15 Lock_time: 0 Rows_sent: 1 Rows_examined: 72981 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'GROUP BY TAXCATEGORIES.NAME; # Time: 090812 13:35:29 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 1 Rows_examined: 73009 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'; # Time: 090812 13:35:45 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 16 Lock_time: 0 Rows_sent: 1 Rows_examined: 73013 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'GROUP BY TAXCATEGORIES.NAME; # Time: 090812 13:40:54 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 14 Lock_time: 0 Rows_sent: 1 Rows_examined: 73011 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'; # Time: 090812 13:41:10 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 16 Lock_time: 0 Rows_sent: 1 Rows_examined: 73015 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'GROUP BY TAXCATEGORIES.NAME; # Time: 090812 14:09:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 14 Lock_time: 0 Rows_sent: 1 Rows_examined: 73031 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'; # Time: 090812 14:09:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 16 Lock_time: 0 Rows_sent: 1 Rows_examined: 73035 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'GROUP BY TAXCATEGORIES.NAME; # Time: 090812 14:33:40 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 14 Lock_time: 0 Rows_sent: 1 Rows_examined: 73047 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'; # Time: 090812 14:33:56 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 16 Lock_time: 0 Rows_sent: 1 Rows_examined: 73051 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'GROUP BY TAXCATEGORIES.NAME; # Time: 090812 15:17:23 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 14 Lock_time: 0 Rows_sent: 1 Rows_examined: 73067 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'; # Time: 090812 15:17:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 16 Lock_time: 0 Rows_sent: 1 Rows_examined: 73071 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'GROUP BY TAXCATEGORIES.NAME; # Time: 090812 17:05:46 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 15 Lock_time: 0 Rows_sent: 1 Rows_examined: 73099 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'; # Time: 090812 17:06:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 16 Lock_time: 0 Rows_sent: 1 Rows_examined: 73103 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '1ed70acc-90ca-4ef8-ac13-01257a2f21e8'GROUP BY TAXCATEGORIES.NAME; # Time: 090812 17:32:27 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 158101 Rows_examined: 158101 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090812 17:32:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 25 Lock_time: 0 Rows_sent: 165206 Rows_examined: 165206 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090813 11:51:05 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 16 Lock_time: 0 Rows_sent: 1 Rows_examined: 73237 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'fd1ea701-2cfb-4dc7-a63f-8f4eea0d7e21'; # Time: 090813 11:51:23 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 18 Lock_time: 0 Rows_sent: 1 Rows_examined: 73241 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'fd1ea701-2cfb-4dc7-a63f-8f4eea0d7e21'GROUP BY TAXCATEGORIES.NAME; # Time: 090813 13:38:23 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 18 Lock_time: 0 Rows_sent: 1 Rows_examined: 73301 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'fd1ea701-2cfb-4dc7-a63f-8f4eea0d7e21'; # Time: 090813 13:38:44 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 21 Lock_time: 0 Rows_sent: 1 Rows_examined: 73305 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'fd1ea701-2cfb-4dc7-a63f-8f4eea0d7e21'GROUP BY TAXCATEGORIES.NAME; # Time: 090813 14:28:23 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 18 Lock_time: 0 Rows_sent: 1 Rows_examined: 73331 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'fd1ea701-2cfb-4dc7-a63f-8f4eea0d7e21'; # Time: 090813 14:28:44 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 21 Lock_time: 0 Rows_sent: 1 Rows_examined: 73335 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'fd1ea701-2cfb-4dc7-a63f-8f4eea0d7e21'GROUP BY TAXCATEGORIES.NAME; # Time: 090813 15:22:32 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 18 Lock_time: 0 Rows_sent: 1 Rows_examined: 73357 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'fd1ea701-2cfb-4dc7-a63f-8f4eea0d7e21'; # Time: 090813 15:22:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 21 Lock_time: 0 Rows_sent: 1 Rows_examined: 73361 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'fd1ea701-2cfb-4dc7-a63f-8f4eea0d7e21'GROUP BY TAXCATEGORIES.NAME; # Time: 090813 17:21:45 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 18 Lock_time: 0 Rows_sent: 1 Rows_examined: 73393 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'fd1ea701-2cfb-4dc7-a63f-8f4eea0d7e21'; # Time: 090813 17:22:05 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 20 Lock_time: 0 Rows_sent: 1 Rows_examined: 73397 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'fd1ea701-2cfb-4dc7-a63f-8f4eea0d7e21'GROUP BY TAXCATEGORIES.NAME; # Time: 090813 17:33:55 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 6 Lock_time: 0 Rows_sent: 158566 Rows_examined: 158566 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090813 17:34:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 24 Lock_time: 0 Rows_sent: 165701 Rows_examined: 165701 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090814 15:32:17 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 22 Lock_time: 0 Rows_sent: 1 Rows_examined: 73679 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '164d9b58-b9da-46d4-b2d1-d67269a34003'; # Time: 090814 15:32:42 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 25 Lock_time: 0 Rows_sent: 1 Rows_examined: 73683 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '164d9b58-b9da-46d4-b2d1-d67269a34003'GROUP BY TAXCATEGORIES.NAME; # Time: 090814 17:37:33 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 22 Lock_time: 0 Rows_sent: 1 Rows_examined: 73721 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '164d9b58-b9da-46d4-b2d1-d67269a34003'; # Time: 090814 17:37:58 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 25 Lock_time: 0 Rows_sent: 1 Rows_examined: 73725 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '164d9b58-b9da-46d4-b2d1-d67269a34003'GROUP BY TAXCATEGORIES.NAME; # Time: 090814 19:48:01 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 23 Lock_time: 0 Rows_sent: 1 Rows_examined: 73757 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '164d9b58-b9da-46d4-b2d1-d67269a34003'; # Time: 090814 19:48:26 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 25 Lock_time: 0 Rows_sent: 1 Rows_examined: 73761 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '164d9b58-b9da-46d4-b2d1-d67269a34003'GROUP BY TAXCATEGORIES.NAME; # Time: 090814 20:31:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 22 Lock_time: 0 Rows_sent: 1 Rows_examined: 73761 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '164d9b58-b9da-46d4-b2d1-d67269a34003'; # Time: 090814 20:32:15 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 25 Lock_time: 0 Rows_sent: 1 Rows_examined: 73765 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '164d9b58-b9da-46d4-b2d1-d67269a34003'GROUP BY TAXCATEGORIES.NAME; # Time: 090814 22:01:33 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 23 Lock_time: 0 Rows_sent: 1 Rows_examined: 73771 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '164d9b58-b9da-46d4-b2d1-d67269a34003'; # Time: 090814 22:01:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 26 Lock_time: 0 Rows_sent: 1 Rows_examined: 73775 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '164d9b58-b9da-46d4-b2d1-d67269a34003'GROUP BY TAXCATEGORIES.NAME; # Time: 090814 22:16:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 23 Lock_time: 0 Rows_sent: 1 Rows_examined: 73771 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '164d9b58-b9da-46d4-b2d1-d67269a34003'; # Time: 090814 22:16:42 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 26 Lock_time: 0 Rows_sent: 1 Rows_examined: 73775 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '164d9b58-b9da-46d4-b2d1-d67269a34003'GROUP BY TAXCATEGORIES.NAME; # Time: 090814 22:29:49 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 7 Lock_time: 0 Rows_sent: 159270 Rows_examined: 159270 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090814 22:30:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 25 Lock_time: 0 Rows_sent: 166436 Rows_examined: 166436 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090815 11:20:28 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 24 Lock_time: 0 Rows_sent: 1 Rows_examined: 73953 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'; # Time: 090815 11:20:56 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 28 Lock_time: 0 Rows_sent: 1 Rows_examined: 73957 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'GROUP BY TAXCATEGORIES.NAME; # Time: 090815 12:26:29 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 25 Lock_time: 0 Rows_sent: 1 Rows_examined: 73999 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'; # Time: 090815 12:26:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 28 Lock_time: 0 Rows_sent: 1 Rows_examined: 74003 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'GROUP BY TAXCATEGORIES.NAME; # Time: 090815 13:36:33 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 27 Lock_time: 0 Rows_sent: 1 Rows_examined: 74037 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'; # Time: 090815 13:37:00 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 27 Lock_time: 0 Rows_sent: 1 Rows_examined: 74041 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'GROUP BY TAXCATEGORIES.NAME; # Time: 090815 14:16:45 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 26 Lock_time: 0 Rows_sent: 1 Rows_examined: 74053 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'; # Time: 090815 14:17:13 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 28 Lock_time: 0 Rows_sent: 1 Rows_examined: 74057 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'GROUP BY TAXCATEGORIES.NAME; # Time: 090815 15:23:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 27 Lock_time: 0 Rows_sent: 1 Rows_examined: 74085 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'; # Time: 090815 15:23:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 29 Lock_time: 0 Rows_sent: 1 Rows_examined: 74089 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'GROUP BY TAXCATEGORIES.NAME; # Time: 090815 16:23:11 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 27 Lock_time: 0 Rows_sent: 1 Rows_examined: 74119 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'; # Time: 090815 16:23:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 30 Lock_time: 0 Rows_sent: 1 Rows_examined: 74123 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'GROUP BY TAXCATEGORIES.NAME; # Time: 090815 19:06:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 27 Lock_time: 0 Rows_sent: 1 Rows_examined: 74145 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'; # Time: 090815 19:06:37 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 30 Lock_time: 0 Rows_sent: 1 Rows_examined: 74149 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'GROUP BY TAXCATEGORIES.NAME; # Time: 090815 21:03:37 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 27 Lock_time: 0 Rows_sent: 1 Rows_examined: 74151 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'; # Time: 090815 21:04:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 30 Lock_time: 0 Rows_sent: 1 Rows_examined: 74155 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'GROUP BY TAXCATEGORIES.NAME; # Time: 090815 21:08:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 27 Lock_time: 0 Rows_sent: 1 Rows_examined: 74151 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'; # Time: 090815 21:08:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 29 Lock_time: 0 Rows_sent: 1 Rows_examined: 74155 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'GROUP BY TAXCATEGORIES.NAME; # Time: 090815 22:34:04 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 28 Lock_time: 0 Rows_sent: 1 Rows_examined: 74153 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'; # Time: 090815 22:34:34 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 30 Lock_time: 0 Rows_sent: 1 Rows_examined: 74157 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'GROUP BY TAXCATEGORIES.NAME; # Time: 090815 23:18:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 28 Lock_time: 0 Rows_sent: 1 Rows_examined: 74155 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'; # Time: 090815 23:18:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 29 Lock_time: 0 Rows_sent: 1 Rows_examined: 74159 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '030d1582-e0b2-4e9f-916e-40afd8800f88'GROUP BY TAXCATEGORIES.NAME; # Time: 090815 23:25:22 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 8 Lock_time: 0 Rows_sent: 160272 Rows_examined: 160272 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090815 23:25:50 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 27 Lock_time: 0 Rows_sent: 167471 Rows_examined: 167471 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090816 10:46:49 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 29 Lock_time: 0 Rows_sent: 1 Rows_examined: 74279 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '90971a3b-bd9d-4f65-aedb-4b8fc0f9dc52'; # Time: 090816 10:47:20 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 31 Lock_time: 0 Rows_sent: 1 Rows_examined: 74283 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '90971a3b-bd9d-4f65-aedb-4b8fc0f9dc52'GROUP BY TAXCATEGORIES.NAME; # Time: 090816 11:28:17 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 29 Lock_time: 0 Rows_sent: 1 Rows_examined: 74319 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '90971a3b-bd9d-4f65-aedb-4b8fc0f9dc52'; # Time: 090816 11:28:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 31 Lock_time: 0 Rows_sent: 1 Rows_examined: 74323 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '90971a3b-bd9d-4f65-aedb-4b8fc0f9dc52'GROUP BY TAXCATEGORIES.NAME; # Time: 090816 12:12:40 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 29 Lock_time: 0 Rows_sent: 1 Rows_examined: 74343 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '90971a3b-bd9d-4f65-aedb-4b8fc0f9dc52'; # Time: 090816 12:13:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 32 Lock_time: 0 Rows_sent: 1 Rows_examined: 74347 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '90971a3b-bd9d-4f65-aedb-4b8fc0f9dc52'GROUP BY TAXCATEGORIES.NAME; # Time: 090816 13:14:30 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 29 Lock_time: 0 Rows_sent: 1 Rows_examined: 74375 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '90971a3b-bd9d-4f65-aedb-4b8fc0f9dc52'; # Time: 090816 13:15:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 32 Lock_time: 0 Rows_sent: 1 Rows_examined: 74379 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '90971a3b-bd9d-4f65-aedb-4b8fc0f9dc52'GROUP BY TAXCATEGORIES.NAME; # Time: 090816 16:10:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 30 Lock_time: 0 Rows_sent: 1 Rows_examined: 74457 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '90971a3b-bd9d-4f65-aedb-4b8fc0f9dc52'; # Time: 090816 16:10:47 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 33 Lock_time: 0 Rows_sent: 1 Rows_examined: 74461 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '90971a3b-bd9d-4f65-aedb-4b8fc0f9dc52'GROUP BY TAXCATEGORIES.NAME; # Time: 090816 16:46:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 30 Lock_time: 0 Rows_sent: 1 Rows_examined: 74459 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '90971a3b-bd9d-4f65-aedb-4b8fc0f9dc52'; # Time: 090816 16:46:47 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 33 Lock_time: 0 Rows_sent: 1 Rows_examined: 74463 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '90971a3b-bd9d-4f65-aedb-4b8fc0f9dc52'GROUP BY TAXCATEGORIES.NAME; # Time: 090816 17:02:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 9 Lock_time: 0 Rows_sent: 161080 Rows_examined: 161080 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090816 17:02:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 28 Lock_time: 0 Rows_sent: 168289 Rows_examined: 168289 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090817 10:19:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 33 Lock_time: 0 Rows_sent: 1 Rows_examined: 74559 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '09ee841a-aa8f-4252-8ae8-fb492db2c994'; # Time: 090817 10:20:15 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 34 Lock_time: 0 Rows_sent: 1 Rows_examined: 74563 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '09ee841a-aa8f-4252-8ae8-fb492db2c994'GROUP BY TAXCATEGORIES.NAME; # Time: 090817 13:41:01 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 33 Lock_time: 0 Rows_sent: 1 Rows_examined: 74663 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '09ee841a-aa8f-4252-8ae8-fb492db2c994'; # Time: 090817 13:41:37 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 36 Lock_time: 0 Rows_sent: 1 Rows_examined: 74667 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '09ee841a-aa8f-4252-8ae8-fb492db2c994'GROUP BY TAXCATEGORIES.NAME; # Time: 090817 15:43:30 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 35 Lock_time: 0 Rows_sent: 1 Rows_examined: 74717 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '09ee841a-aa8f-4252-8ae8-fb492db2c994'; # Time: 090817 15:44:06 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 36 Lock_time: 0 Rows_sent: 1 Rows_examined: 74721 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '09ee841a-aa8f-4252-8ae8-fb492db2c994'GROUP BY TAXCATEGORIES.NAME; # Time: 090817 16:22:10 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 36 Lock_time: 0 Rows_sent: 1 Rows_examined: 74739 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '09ee841a-aa8f-4252-8ae8-fb492db2c994'; # Time: 090817 16:22:47 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 37 Lock_time: 0 Rows_sent: 1 Rows_examined: 74743 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '09ee841a-aa8f-4252-8ae8-fb492db2c994'GROUP BY TAXCATEGORIES.NAME; # Time: 090817 17:27:35 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 35 Lock_time: 0 Rows_sent: 1 Rows_examined: 74749 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '09ee841a-aa8f-4252-8ae8-fb492db2c994'; # Time: 090817 17:28:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 37 Lock_time: 0 Rows_sent: 1 Rows_examined: 74753 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '09ee841a-aa8f-4252-8ae8-fb492db2c994'GROUP BY TAXCATEGORIES.NAME; # Time: 090817 17:41:22 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 161669 Rows_examined: 161669 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090817 17:41:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 29 Lock_time: 0 Rows_sent: 168912 Rows_examined: 168912 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090818 9:24:32 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 36 Lock_time: 0 Rows_sent: 1 Rows_examined: 74815 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '4e5880db-aebf-453f-a4c0-b0f8cc2ad2f7'; # Time: 090818 9:25:11 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 39 Lock_time: 0 Rows_sent: 1 Rows_examined: 74819 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '4e5880db-aebf-453f-a4c0-b0f8cc2ad2f7'GROUP BY TAXCATEGORIES.NAME; # Time: 090818 14:21:58 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 37 Lock_time: 0 Rows_sent: 1 Rows_examined: 74955 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '4e5880db-aebf-453f-a4c0-b0f8cc2ad2f7'; # Time: 090818 14:22:37 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 39 Lock_time: 0 Rows_sent: 1 Rows_examined: 74959 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '4e5880db-aebf-453f-a4c0-b0f8cc2ad2f7'GROUP BY TAXCATEGORIES.NAME; # Time: 090818 17:15:05 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 38 Lock_time: 0 Rows_sent: 1 Rows_examined: 75007 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '4e5880db-aebf-453f-a4c0-b0f8cc2ad2f7'; # Time: 090818 17:15:45 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 40 Lock_time: 0 Rows_sent: 1 Rows_examined: 75011 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '4e5880db-aebf-453f-a4c0-b0f8cc2ad2f7'GROUP BY TAXCATEGORIES.NAME; # Time: 090818 17:31:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 162091 Rows_examined: 162091 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090818 17:32:11 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 30 Lock_time: 0 Rows_sent: 169354 Rows_examined: 169354 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090819 14:12:32 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 41 Lock_time: 0 Rows_sent: 1 Rows_examined: 75193 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'c242b10d-c013-4676-a653-7541dc3ed335'; # Time: 090819 14:13:15 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 43 Lock_time: 0 Rows_sent: 1 Rows_examined: 75197 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'c242b10d-c013-4676-a653-7541dc3ed335'GROUP BY TAXCATEGORIES.NAME; # Time: 090819 16:07:09 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 42 Lock_time: 0 Rows_sent: 1 Rows_examined: 75241 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'c242b10d-c013-4676-a653-7541dc3ed335'; # Time: 090819 16:07:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 44 Lock_time: 0 Rows_sent: 1 Rows_examined: 75245 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'c242b10d-c013-4676-a653-7541dc3ed335'GROUP BY TAXCATEGORIES.NAME; # Time: 090819 16:56:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 41 Lock_time: 0 Rows_sent: 1 Rows_examined: 75255 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'c242b10d-c013-4676-a653-7541dc3ed335'; # Time: 090819 16:56:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 43 Lock_time: 0 Rows_sent: 1 Rows_examined: 75259 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'c242b10d-c013-4676-a653-7541dc3ed335'GROUP BY TAXCATEGORIES.NAME; # Time: 090819 17:19:53 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 41 Lock_time: 0 Rows_sent: 1 Rows_examined: 75259 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'c242b10d-c013-4676-a653-7541dc3ed335'; # Time: 090819 17:20:37 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 44 Lock_time: 0 Rows_sent: 1 Rows_examined: 75263 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'c242b10d-c013-4676-a653-7541dc3ed335'GROUP BY TAXCATEGORIES.NAME; # Time: 090819 17:32:17 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 162462 Rows_examined: 162462 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090819 17:32:49 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 30 Lock_time: 0 Rows_sent: 169750 Rows_examined: 169750 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090820 12:18:05 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 43 Lock_time: 0 Rows_sent: 1 Rows_examined: 75421 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'f7ba5483-c5e0-4906-bfdd-d4069fc76aa4'; # Time: 090820 12:18:52 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 47 Lock_time: 0 Rows_sent: 1 Rows_examined: 75425 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'f7ba5483-c5e0-4906-bfdd-d4069fc76aa4'GROUP BY TAXCATEGORIES.NAME; # Time: 090820 13:41:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 45 Lock_time: 0 Rows_sent: 1 Rows_examined: 75471 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'f7ba5483-c5e0-4906-bfdd-d4069fc76aa4'; # Time: 090820 13:42:25 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 47 Lock_time: 0 Rows_sent: 1 Rows_examined: 75475 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'f7ba5483-c5e0-4906-bfdd-d4069fc76aa4'GROUP BY TAXCATEGORIES.NAME; # Time: 090820 14:19:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 46 Lock_time: 0 Rows_sent: 1 Rows_examined: 75499 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'f7ba5483-c5e0-4906-bfdd-d4069fc76aa4'; # Time: 090820 14:20:28 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 47 Lock_time: 0 Rows_sent: 1 Rows_examined: 75503 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'f7ba5483-c5e0-4906-bfdd-d4069fc76aa4'GROUP BY TAXCATEGORIES.NAME; # Time: 090820 15:03:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 46 Lock_time: 0 Rows_sent: 1 Rows_examined: 75517 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'f7ba5483-c5e0-4906-bfdd-d4069fc76aa4'; # Time: 090820 15:04:36 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 48 Lock_time: 0 Rows_sent: 1 Rows_examined: 75521 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'f7ba5483-c5e0-4906-bfdd-d4069fc76aa4'GROUP BY TAXCATEGORIES.NAME; # Time: 090820 15:49:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 45 Lock_time: 0 Rows_sent: 1 Rows_examined: 75527 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'f7ba5483-c5e0-4906-bfdd-d4069fc76aa4'; # Time: 090820 15:50:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 48 Lock_time: 0 Rows_sent: 1 Rows_examined: 75531 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'f7ba5483-c5e0-4906-bfdd-d4069fc76aa4'GROUP BY TAXCATEGORIES.NAME; # Time: 090820 17:21:11 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 46 Lock_time: 0 Rows_sent: 1 Rows_examined: 75547 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'f7ba5483-c5e0-4906-bfdd-d4069fc76aa4'; # Time: 090820 17:22:00 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 49 Lock_time: 0 Rows_sent: 1 Rows_examined: 75551 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'f7ba5483-c5e0-4906-bfdd-d4069fc76aa4'GROUP BY TAXCATEGORIES.NAME; # Time: 090820 17:44:08 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 162877 Rows_examined: 162877 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090820 17:44:44 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 34 Lock_time: 0 Rows_sent: 170192 Rows_examined: 170192 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090821 15:49:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 48 Lock_time: 0 Rows_sent: 1 Rows_examined: 75827 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'e141f4e4-855e-4ea2-9a81-6fa4991f1d0e'; # Time: 090821 15:50:40 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 52 Lock_time: 0 Rows_sent: 1 Rows_examined: 75831 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'e141f4e4-855e-4ea2-9a81-6fa4991f1d0e'GROUP BY TAXCATEGORIES.NAME; # Time: 090821 17:33:27 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 49 Lock_time: 0 Rows_sent: 1 Rows_examined: 75871 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'e141f4e4-855e-4ea2-9a81-6fa4991f1d0e'; # Time: 090821 17:34:19 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 52 Lock_time: 0 Rows_sent: 1 Rows_examined: 75875 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'e141f4e4-855e-4ea2-9a81-6fa4991f1d0e'GROUP BY TAXCATEGORIES.NAME; # Time: 090821 17:46:54 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 49 Lock_time: 0 Rows_sent: 1 Rows_examined: 75875 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'e141f4e4-855e-4ea2-9a81-6fa4991f1d0e'; # Time: 090821 17:47:47 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 53 Lock_time: 0 Rows_sent: 1 Rows_examined: 75879 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'e141f4e4-855e-4ea2-9a81-6fa4991f1d0e'GROUP BY TAXCATEGORIES.NAME; # Time: 090821 21:31:36 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 50 Lock_time: 0 Rows_sent: 1 Rows_examined: 75923 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'e141f4e4-855e-4ea2-9a81-6fa4991f1d0e'; # Time: 090821 21:32:30 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 54 Lock_time: 0 Rows_sent: 1 Rows_examined: 75927 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'e141f4e4-855e-4ea2-9a81-6fa4991f1d0e'GROUP BY TAXCATEGORIES.NAME; # Time: 090821 22:50:04 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 50 Lock_time: 0 Rows_sent: 1 Rows_examined: 75937 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'e141f4e4-855e-4ea2-9a81-6fa4991f1d0e'; # Time: 090821 22:50:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 53 Lock_time: 0 Rows_sent: 1 Rows_examined: 75941 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'e141f4e4-855e-4ea2-9a81-6fa4991f1d0e'GROUP BY TAXCATEGORIES.NAME; # Time: 090821 23:00:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 51 Lock_time: 0 Rows_sent: 1 Rows_examined: 75937 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'e141f4e4-855e-4ea2-9a81-6fa4991f1d0e'; # Time: 090821 23:01:34 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 53 Lock_time: 0 Rows_sent: 1 Rows_examined: 75941 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'e141f4e4-855e-4ea2-9a81-6fa4991f1d0e'GROUP BY TAXCATEGORIES.NAME; # Time: 090821 23:11:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 10 Lock_time: 0 Rows_sent: 163661 Rows_examined: 163661 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090821 23:12:33 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 34 Lock_time: 0 Rows_sent: 170993 Rows_examined: 170993 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090822 13:46:30 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 53 Lock_time: 0 Rows_sent: 1 Rows_examined: 76183 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'cc3e3601-a150-4a16-8d94-13ea78a2767c'; # Time: 090822 13:47:25 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 55 Lock_time: 0 Rows_sent: 1 Rows_examined: 76187 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'cc3e3601-a150-4a16-8d94-13ea78a2767c'GROUP BY TAXCATEGORIES.NAME; # Time: 090822 15:39:01 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 55 Lock_time: 0 Rows_sent: 1 Rows_examined: 76231 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'cc3e3601-a150-4a16-8d94-13ea78a2767c'; # Time: 090822 15:39:58 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 57 Lock_time: 0 Rows_sent: 1 Rows_examined: 76235 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'cc3e3601-a150-4a16-8d94-13ea78a2767c'GROUP BY TAXCATEGORIES.NAME; # Time: 090822 17:21:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 55 Lock_time: 0 Rows_sent: 1 Rows_examined: 76279 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'cc3e3601-a150-4a16-8d94-13ea78a2767c'; # Time: 090822 17:22:15 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 57 Lock_time: 0 Rows_sent: 1 Rows_examined: 76283 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'cc3e3601-a150-4a16-8d94-13ea78a2767c'GROUP BY TAXCATEGORIES.NAME; # Time: 090822 22:45:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 56 Lock_time: 0 Rows_sent: 1 Rows_examined: 76321 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'cc3e3601-a150-4a16-8d94-13ea78a2767c'; # Time: 090822 22:46:19 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 58 Lock_time: 0 Rows_sent: 1 Rows_examined: 76325 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'cc3e3601-a150-4a16-8d94-13ea78a2767c'GROUP BY TAXCATEGORIES.NAME; # Time: 090822 22:55:20 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 56 Lock_time: 0 Rows_sent: 1 Rows_examined: 76321 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'cc3e3601-a150-4a16-8d94-13ea78a2767c'; # Time: 090822 22:56:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 58 Lock_time: 0 Rows_sent: 1 Rows_examined: 76325 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'cc3e3601-a150-4a16-8d94-13ea78a2767c'GROUP BY TAXCATEGORIES.NAME; # Time: 090822 23:16:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 11 Lock_time: 0 Rows_sent: 164665 Rows_examined: 164665 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090822 23:16:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 34 Lock_time: 0 Rows_sent: 172027 Rows_examined: 172027 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090823 11:27:38 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 58 Lock_time: 0 Rows_sent: 1 Rows_examined: 76481 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'ad1ede3f-defe-4e41-8e76-dbafd1dc791a'; # Time: 090823 11:28:37 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 59 Lock_time: 0 Rows_sent: 1 Rows_examined: 76485 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'ad1ede3f-defe-4e41-8e76-dbafd1dc791a'GROUP BY TAXCATEGORIES.NAME; # Time: 090823 13:04:15 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 58 Lock_time: 0 Rows_sent: 1 Rows_examined: 76559 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'ad1ede3f-defe-4e41-8e76-dbafd1dc791a'; # Time: 090823 13:05:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 61 Lock_time: 0 Rows_sent: 1 Rows_examined: 76563 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'ad1ede3f-defe-4e41-8e76-dbafd1dc791a'GROUP BY TAXCATEGORIES.NAME; # Time: 090823 16:17:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 60 Lock_time: 0 Rows_sent: 1 Rows_examined: 76619 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'ad1ede3f-defe-4e41-8e76-dbafd1dc791a'; # Time: 090823 16:18:16 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 62 Lock_time: 0 Rows_sent: 1 Rows_examined: 76623 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'ad1ede3f-defe-4e41-8e76-dbafd1dc791a'GROUP BY TAXCATEGORIES.NAME; # Time: 090823 16:38:25 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 165419 Rows_examined: 165419 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090823 16:39:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 36 Lock_time: 0 Rows_sent: 172793 Rows_examined: 172793 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090824 12:15:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 60 Lock_time: 0 Rows_sent: 1 Rows_examined: 76729 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '371a4b3b-a48a-4def-8ca1-1a56fc9b7015'; # Time: 090824 12:16:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 62 Lock_time: 0 Rows_sent: 1 Rows_examined: 76733 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '371a4b3b-a48a-4def-8ca1-1a56fc9b7015'GROUP BY TAXCATEGORIES.NAME; # Time: 090824 13:54:23 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 61 Lock_time: 0 Rows_sent: 1 Rows_examined: 76791 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '371a4b3b-a48a-4def-8ca1-1a56fc9b7015'; # Time: 090824 13:55:25 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 62 Lock_time: 0 Rows_sent: 1 Rows_examined: 76795 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '371a4b3b-a48a-4def-8ca1-1a56fc9b7015'GROUP BY TAXCATEGORIES.NAME; # Time: 090824 15:42:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 62 Lock_time: 0 Rows_sent: 1 Rows_examined: 76837 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '371a4b3b-a48a-4def-8ca1-1a56fc9b7015'; # Time: 090824 15:43:11 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 64 Lock_time: 0 Rows_sent: 1 Rows_examined: 76841 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '371a4b3b-a48a-4def-8ca1-1a56fc9b7015'GROUP BY TAXCATEGORIES.NAME; # Time: 090824 17:10:03 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 63 Lock_time: 0 Rows_sent: 1 Rows_examined: 76873 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '371a4b3b-a48a-4def-8ca1-1a56fc9b7015'; # Time: 090824 17:11:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 64 Lock_time: 0 Rows_sent: 1 Rows_examined: 76877 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '371a4b3b-a48a-4def-8ca1-1a56fc9b7015'GROUP BY TAXCATEGORIES.NAME; # Time: 090824 17:25:30 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 165835 Rows_examined: 165835 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090824 17:26:08 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 36 Lock_time: 0 Rows_sent: 173241 Rows_examined: 173241 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090825 13:59:46 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 64 Lock_time: 0 Rows_sent: 1 Rows_examined: 77069 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '0cfd19e9-0a4a-48e9-9a57-81270cfe7ad4'; # Time: 090825 14:00:52 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 66 Lock_time: 0 Rows_sent: 1 Rows_examined: 77073 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '0cfd19e9-0a4a-48e9-9a57-81270cfe7ad4'GROUP BY TAXCATEGORIES.NAME; # Time: 090825 14:59:27 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 64 Lock_time: 0 Rows_sent: 1 Rows_examined: 77103 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '0cfd19e9-0a4a-48e9-9a57-81270cfe7ad4'; # Time: 090825 15:00:34 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 67 Lock_time: 0 Rows_sent: 1 Rows_examined: 77107 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '0cfd19e9-0a4a-48e9-9a57-81270cfe7ad4'GROUP BY TAXCATEGORIES.NAME; # Time: 090825 16:35:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 64 Lock_time: 0 Rows_sent: 1 Rows_examined: 77139 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '0cfd19e9-0a4a-48e9-9a57-81270cfe7ad4'; # Time: 090825 16:37:06 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 67 Lock_time: 0 Rows_sent: 1 Rows_examined: 77143 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '0cfd19e9-0a4a-48e9-9a57-81270cfe7ad4'GROUP BY TAXCATEGORIES.NAME; # Time: 090825 17:18:03 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 64 Lock_time: 0 Rows_sent: 1 Rows_examined: 77147 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '0cfd19e9-0a4a-48e9-9a57-81270cfe7ad4'; # Time: 090825 17:19:10 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 67 Lock_time: 0 Rows_sent: 1 Rows_examined: 77151 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '0cfd19e9-0a4a-48e9-9a57-81270cfe7ad4'GROUP BY TAXCATEGORIES.NAME; # Time: 090825 17:37:25 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 166338 Rows_examined: 166338 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090825 17:38:03 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 36 Lock_time: 0 Rows_sent: 173763 Rows_examined: 173763 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090826 9:06:44 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 65 Lock_time: 0 Rows_sent: 1 Rows_examined: 77179 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6b08141d-7157-4600-91a1-eaea88bdd900'; # Time: 090826 9:07:51 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 67 Lock_time: 0 Rows_sent: 1 Rows_examined: 77183 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6b08141d-7157-4600-91a1-eaea88bdd900'GROUP BY TAXCATEGORIES.NAME; # Time: 090826 14:15:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 65 Lock_time: 0 Rows_sent: 1 Rows_examined: 77335 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6b08141d-7157-4600-91a1-eaea88bdd900'; # Time: 090826 14:16:56 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 68 Lock_time: 0 Rows_sent: 1 Rows_examined: 77339 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6b08141d-7157-4600-91a1-eaea88bdd900'GROUP BY TAXCATEGORIES.NAME; # Time: 090826 15:05:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 66 Lock_time: 0 Rows_sent: 1 Rows_examined: 77355 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6b08141d-7157-4600-91a1-eaea88bdd900'; # Time: 090826 15:06:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 68 Lock_time: 0 Rows_sent: 1 Rows_examined: 77359 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6b08141d-7157-4600-91a1-eaea88bdd900'GROUP BY TAXCATEGORIES.NAME; # Time: 090826 16:39:11 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 66 Lock_time: 0 Rows_sent: 1 Rows_examined: 77385 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6b08141d-7157-4600-91a1-eaea88bdd900'; # Time: 090826 16:40:20 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 69 Lock_time: 0 Rows_sent: 1 Rows_examined: 77389 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6b08141d-7157-4600-91a1-eaea88bdd900'GROUP BY TAXCATEGORIES.NAME; # Time: 090826 17:34:15 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 67 Lock_time: 0 Rows_sent: 1 Rows_examined: 77401 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '6b08141d-7157-4600-91a1-eaea88bdd900'; # Time: 090826 17:35:24 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 69 Lock_time: 0 Rows_sent: 1 Rows_examined: 77405 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '6b08141d-7157-4600-91a1-eaea88bdd900'GROUP BY TAXCATEGORIES.NAME; # Time: 090826 17:54:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 166737 Rows_examined: 166737 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090826 17:54:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 39 Lock_time: 0 Rows_sent: 174182 Rows_examined: 174182 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090827 9:20:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 68 Lock_time: 0 Rows_sent: 1 Rows_examined: 77487 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'; # Time: 090827 9:21:41 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 70 Lock_time: 0 Rows_sent: 1 Rows_examined: 77491 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'GROUP BY TAXCATEGORIES.NAME; # Time: 090827 10:30:09 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 68 Lock_time: 0 Rows_sent: 1 Rows_examined: 77531 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'; # Time: 090827 10:31:21 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 72 Lock_time: 0 Rows_sent: 1 Rows_examined: 77535 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'GROUP BY TAXCATEGORIES.NAME; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090827 13:55:40 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 69 Lock_time: 0 Rows_sent: 1 Rows_examined: 77615 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'; # Time: 090827 13:56:51 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 71 Lock_time: 0 Rows_sent: 1 Rows_examined: 77619 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'GROUP BY TAXCATEGORIES.NAME; # Time: 090827 13:58:12 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 68 Lock_time: 0 Rows_sent: 1 Rows_examined: 77615 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'; # Time: 090827 13:59:23 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 71 Lock_time: 0 Rows_sent: 1 Rows_examined: 77619 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'GROUP BY TAXCATEGORIES.NAME; # Time: 090827 15:25:48 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 70 Lock_time: 0 Rows_sent: 1 Rows_examined: 77647 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'; # Time: 090827 15:26:59 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 71 Lock_time: 0 Rows_sent: 1 Rows_examined: 77651 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'GROUP BY TAXCATEGORIES.NAME; # Time: 090827 16:17:32 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 69 Lock_time: 0 Rows_sent: 1 Rows_examined: 77665 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'; # Time: 090827 16:18:43 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 71 Lock_time: 0 Rows_sent: 1 Rows_examined: 77669 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'GROUP BY TAXCATEGORIES.NAME; # Time: 090827 17:06:10 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 69 Lock_time: 0 Rows_sent: 1 Rows_examined: 77685 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'; # Time: 090827 17:07:22 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 72 Lock_time: 0 Rows_sent: 1 Rows_examined: 77689 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'dd6c3b5b-1e8a-4fc2-87c7-129db734db9e'GROUP BY TAXCATEGORIES.NAME; # Time: 090827 17:37:20 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 167172 Rows_examined: 167172 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090827 17:38:02 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 40 Lock_time: 0 Rows_sent: 174639 Rows_examined: 174639 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090828 14:54:33 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 71 Lock_time: 0 Rows_sent: 1 Rows_examined: 77953 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '97e07e37-802e-4cba-9c20-23e67e221384'; # Time: 090828 14:55:46 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 73 Lock_time: 0 Rows_sent: 1 Rows_examined: 77957 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '97e07e37-802e-4cba-9c20-23e67e221384'GROUP BY TAXCATEGORIES.NAME; # Time: 090828 17:19:43 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 71 Lock_time: 0 Rows_sent: 1 Rows_examined: 77995 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '97e07e37-802e-4cba-9c20-23e67e221384'; # Time: 090828 17:20:57 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 74 Lock_time: 0 Rows_sent: 1 Rows_examined: 77999 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '97e07e37-802e-4cba-9c20-23e67e221384'GROUP BY TAXCATEGORIES.NAME; # Time: 090828 18:11:26 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 71 Lock_time: 0 Rows_sent: 1 Rows_examined: 78005 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '97e07e37-802e-4cba-9c20-23e67e221384'; # Time: 090828 18:12:40 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 74 Lock_time: 0 Rows_sent: 1 Rows_examined: 78009 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '97e07e37-802e-4cba-9c20-23e67e221384'GROUP BY TAXCATEGORIES.NAME; # Time: 090828 22:40:58 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 74 Lock_time: 0 Rows_sent: 1 Rows_examined: 78057 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '97e07e37-802e-4cba-9c20-23e67e221384'; # Time: 090828 22:42:14 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 76 Lock_time: 0 Rows_sent: 1 Rows_examined: 78061 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '97e07e37-802e-4cba-9c20-23e67e221384'GROUP BY TAXCATEGORIES.NAME; # Time: 090829 13:09:13 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 74 Lock_time: 0 Rows_sent: 1 Rows_examined: 78297 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '039e77a2-e4c4-45b1-b3c0-d9df673583ed'; # Time: 090829 13:10:30 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 77 Lock_time: 0 Rows_sent: 1 Rows_examined: 78301 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '039e77a2-e4c4-45b1-b3c0-d9df673583ed'GROUP BY TAXCATEGORIES.NAME; # Time: 090829 15:09:13 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 75 Lock_time: 0 Rows_sent: 1 Rows_examined: 78365 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '039e77a2-e4c4-45b1-b3c0-d9df673583ed'; # Time: 090829 15:10:30 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 77 Lock_time: 0 Rows_sent: 1 Rows_examined: 78369 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '039e77a2-e4c4-45b1-b3c0-d9df673583ed'GROUP BY TAXCATEGORIES.NAME; # Time: 090829 17:44:46 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 75 Lock_time: 0 Rows_sent: 1 Rows_examined: 78419 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '039e77a2-e4c4-45b1-b3c0-d9df673583ed'; # Time: 090829 17:46:04 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 78 Lock_time: 0 Rows_sent: 1 Rows_examined: 78423 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '039e77a2-e4c4-45b1-b3c0-d9df673583ed'GROUP BY TAXCATEGORIES.NAME; # Time: 090829 21:52:36 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 76 Lock_time: 0 Rows_sent: 1 Rows_examined: 78477 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '039e77a2-e4c4-45b1-b3c0-d9df673583ed'; # Time: 090829 21:53:54 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 78 Lock_time: 0 Rows_sent: 1 Rows_examined: 78481 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '039e77a2-e4c4-45b1-b3c0-d9df673583ed'GROUP BY TAXCATEGORIES.NAME; # Time: 090829 22:33:18 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 81 Lock_time: 0 Rows_sent: 1 Rows_examined: 78481 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = '039e77a2-e4c4-45b1-b3c0-d9df673583ed'; # Time: 090829 22:34:40 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 82 Lock_time: 0 Rows_sent: 1 Rows_examined: 78485 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = '039e77a2-e4c4-45b1-b3c0-d9df673583ed'GROUP BY TAXCATEGORIES.NAME; # Time: 090829 22:47:49 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 13 Lock_time: 0 Rows_sent: 169053 Rows_examined: 169053 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090829 22:48:31 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 40 Lock_time: 0 Rows_sent: 176565 Rows_examined: 176565 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument # Time: 090830 11:29:56 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 77 Lock_time: 0 Rows_sent: 1 Rows_examined: 78627 use openbravopos; SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'd0bfbfc8-a0c2-4b13-a504-34f6153a9a08'; # Time: 090830 11:31:15 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 79 Lock_time: 0 Rows_sent: 1 Rows_examined: 78631 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'd0bfbfc8-a0c2-4b13-a504-34f6153a9a08'GROUP BY TAXCATEGORIES.NAME; # Time: 090830 13:52:39 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 77 Lock_time: 0 Rows_sent: 1 Rows_examined: 78719 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'd0bfbfc8-a0c2-4b13-a504-34f6153a9a08'; # Time: 090830 13:53:58 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 79 Lock_time: 0 Rows_sent: 1 Rows_examined: 78723 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'd0bfbfc8-a0c2-4b13-a504-34f6153a9a08'GROUP BY TAXCATEGORIES.NAME; # Time: 090830 16:21:28 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 79 Lock_time: 0 Rows_sent: 1 Rows_examined: 78771 SELECT SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND RECEIPTS.MONEY = 'd0bfbfc8-a0c2-4b13-a504-34f6153a9a08'; # Time: 090830 16:22:51 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 83 Lock_time: 0 Rows_sent: 1 Rows_examined: 78775 SELECT TAXCATEGORIES.NAME, SUM(TAXLINES.AMOUNT) FROM RECEIPTS, TAXLINES, TAXES, TAXCATEGORIES WHERE RECEIPTS.ID = TAXLINES.RECEIPT AND TAXLINES.TAXID = TAXES.ID AND TAXES.CATEGORY = TAXCATEGORIES.ID AND RECEIPTS.MONEY = 'd0bfbfc8-a0c2-4b13-a504-34f6153a9a08'GROUP BY TAXCATEGORIES.NAME; # Time: 090830 16:24:07 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 12 Lock_time: 0 Rows_sent: 169807 Rows_examined: 169807 SELECT /*!40001 SQL_NO_CACHE */ * FROM `stockdiary`; # Time: 090830 16:24:52 # User@Host: root[root] @ localhost [127.0.0.1] # Query_time: 43 Lock_time: 0 Rows_sent: 177329 Rows_examined: 177329 SELECT /*!40001 SQL_NO_CACHE */ * FROM `ticketlines`; C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version: 5.0.51b-community-nt-log (MySQL Community Edition (GPL)). started with: TCP Port: 3306, Named Pipe: (null) Time Id Command Argument