C:\AppServ\MySQL\bin\mysqld, Version: 8.0.17 (MySQL Community Server - GPL). started with:
TCP Port: 3306, Named Pipe: MySQL
Time Id Command Argument
2025-02-08T02:56:55.043616Z 245141 Query SHOW WARNINGS
2025-02-08T02:56:55.044958Z 245141 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:56:55.047895Z 245141 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:56:55.049829Z 245141 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:56:55.052185Z 245141 Query SELECT '
Warning: Undefined array key 0 in C:\AppServ\www\api\station_info.php on line 8
'
2025-02-08T02:56:55.065334Z 245141 Query SHOW WARNINGS
2025-02-08T02:56:55.065641Z 245141 Query SELECT @@lower_case_table_names
2025-02-08T02:56:55.097493Z 245141 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:56:55.100049Z 245141 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:56:55.102015Z 245141 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:56:55.104410Z 245141 Query SET global general_log='OFF'
C:\AppServ\MySQL\bin\mysqld, Version: 8.0.17 (MySQL Community Server - GPL). started with:
TCP Port: 3306, Named Pipe: MySQL
Time Id Command Argument
2025-02-08T02:57:21.542333Z 245145 Query SHOW WARNINGS
2025-02-08T02:57:21.543620Z 245145 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:21.589945Z 245146 Quit
2025-02-08T02:57:21.590003Z 245145 Quit
2025-02-08T02:57:22.318541Z 240348 Init DB keyway
2025-02-08T02:57:22.346536Z 240348 Query SELECT * FROM reset_cnt WHERE City = 'Taipei' AND SID = '88' AND status = 0
2025-02-08T02:57:22.366485Z 240348 Query UPDATE reset_cnt SET status = 1 WHERE City = 'Taipei' AND SID = '88' AND status = 0
2025-02-08T02:57:25.669866Z 245147 Connect root@localhost on using TCP/IP
2025-02-08T02:57:25.670042Z 245147 Query SELECT @@version, @@version_comment
2025-02-08T02:57:25.671435Z 245147 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:25.671541Z 245147 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:25.675506Z 245148 Connect root@localhost on using TCP/IP
2025-02-08T02:57:25.682269Z 245147 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:25.692758Z 245147 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:25.726558Z 245147 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:25.752407Z 245148 Quit
2025-02-08T02:57:25.752464Z 245147 Quit
2025-02-08T02:57:25.774647Z 245149 Connect root@localhost on using TCP/IP
2025-02-08T02:57:25.774775Z 245149 Query SELECT @@version, @@version_comment
2025-02-08T02:57:25.776099Z 245149 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:25.776188Z 245149 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:25.779366Z 245150 Connect root@localhost on using TCP/IP
2025-02-08T02:57:25.785521Z 245149 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:25.794927Z 245149 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:25.805083Z 245150 Quit
2025-02-08T02:57:25.805140Z 245149 Quit
2025-02-08T02:57:26.358761Z 213990 Init DB keyway
2025-02-08T02:57:26.396632Z 213990 Query SELECT * FROM reset_cnt WHERE City = 'Taipei' AND SID = '63' AND status = 0
2025-02-08T02:57:26.419613Z 213990 Query UPDATE reset_cnt SET status = 1 WHERE City = 'Taipei' AND SID = '63' AND status = 0
2025-02-08T02:57:27.728703Z 245151 Connect root@localhost on using TCP/IP
2025-02-08T02:57:27.728831Z 245151 Query SELECT @@version, @@version_comment
2025-02-08T02:57:27.730278Z 245151 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:27.730396Z 245151 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:27.733633Z 245152 Connect root@localhost on using TCP/IP
2025-02-08T02:57:27.740052Z 245151 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:27.750170Z 245151 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:27.760460Z 245152 Quit
2025-02-08T02:57:27.760503Z 245151 Quit
2025-02-08T02:57:28.016586Z 13 Init DB keyway
2025-02-08T02:57:28.016804Z 13 Query SELECT * FROM lpr_station where local_auto = 'T'
2025-02-08T02:57:28.438643Z 245153 Connect root@localhost on using TCP/IP
2025-02-08T02:57:28.438768Z 245153 Query SELECT @@version, @@version_comment
2025-02-08T02:57:28.440192Z 245153 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:28.440297Z 245153 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:28.443585Z 245154 Connect root@localhost on using TCP/IP
2025-02-08T02:57:28.449827Z 245153 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:28.459596Z 245153 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:28.466341Z 245153 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:28.468584Z 245153 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:28.474140Z 245153 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:28.484457Z 245153 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:28.486365Z 245153 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:28.494488Z 245153 Query SET global general_log_file='C:\\AppServ\\www\\api\\station_info.php'
C:\AppServ\MySQL\bin\mysqld, Version: 8.0.17 (MySQL Community Server - GPL). started with:
TCP Port: 3306, Named Pipe: MySQL
Time Id Command Argument
2025-02-08T02:57:28.511367Z 245153 Query SHOW WARNINGS
2025-02-08T02:57:28.512492Z 245153 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:28.553089Z 245154 Quit
2025-02-08T02:57:28.553090Z 245153 Quit
2025-02-08T02:57:32.328576Z 240348 Init DB keyway
2025-02-08T02:57:32.356542Z 240348 Query SELECT * FROM reset_cnt WHERE City = 'Taipei' AND SID = '88' AND status = 0
2025-02-08T02:57:32.376601Z 240348 Query UPDATE reset_cnt SET status = 1 WHERE City = 'Taipei' AND SID = '88' AND status = 0
2025-02-08T02:57:34.986601Z 245155 Connect root@localhost on using TCP/IP
2025-02-08T02:57:34.986767Z 245155 Query SELECT @@version, @@version_comment
2025-02-08T02:57:34.988196Z 245155 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:34.988299Z 245155 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:34.991634Z 245156 Connect root@localhost on using TCP/IP
2025-02-08T02:57:34.997879Z 245155 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:35.007333Z 245155 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:35.035588Z 245155 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:35.059483Z 245156 Quit
2025-02-08T02:57:35.059532Z 245155 Quit
2025-02-08T02:57:35.081492Z 245157 Connect root@localhost on using TCP/IP
2025-02-08T02:57:35.081613Z 245157 Query SELECT @@version, @@version_comment
2025-02-08T02:57:35.083022Z 245157 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:35.083126Z 245157 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:35.086382Z 245158 Connect root@localhost on using TCP/IP
2025-02-08T02:57:35.092647Z 245157 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:35.102109Z 245157 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:35.112468Z 245158 Quit
2025-02-08T02:57:35.112497Z 245157 Quit
2025-02-08T02:57:36.378865Z 213990 Init DB keyway
2025-02-08T02:57:36.414720Z 213990 Query SELECT * FROM reset_cnt WHERE City = 'Taipei' AND SID = '63' AND status = 0
2025-02-08T02:57:36.439784Z 213990 Query UPDATE reset_cnt SET status = 1 WHERE City = 'Taipei' AND SID = '63' AND status = 0
2025-02-08T02:57:38.013040Z 13 Init DB keyway
2025-02-08T02:57:38.013212Z 13 Query SELECT * FROM lpr_station where local_auto = 'T'
2025-02-08T02:57:39.487253Z 245159 Connect root@localhost on using TCP/IP
2025-02-08T02:57:39.487394Z 245159 Query SELECT @@version, @@version_comment
2025-02-08T02:57:39.488829Z 245159 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:39.488939Z 245159 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:39.502448Z 245160 Connect root@localhost on using TCP/IP
2025-02-08T02:57:39.508612Z 245159 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:39.518475Z 245159 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:39.553821Z 245160 Quit
2025-02-08T02:57:39.553889Z 245159 Quit
2025-02-08T02:57:39.919684Z 245161 Connect root@localhost on using TCP/IP
2025-02-08T02:57:39.919853Z 245161 Query SELECT @@version, @@version_comment
2025-02-08T02:57:39.921215Z 245161 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:39.921300Z 245161 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:39.924554Z 245162 Connect root@localhost on using TCP/IP
2025-02-08T02:57:39.930788Z 245161 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:39.940187Z 245161 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:39.950231Z 245162 Quit
2025-02-08T02:57:39.950276Z 245161 Quit
2025-02-08T02:57:41.218462Z 245163 Connect root@localhost on using TCP/IP
2025-02-08T02:57:41.218625Z 245163 Query SELECT @@version, @@version_comment
2025-02-08T02:57:41.219992Z 245163 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:41.220091Z 245163 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:41.223507Z 245164 Connect root@localhost on using TCP/IP
2025-02-08T02:57:41.230201Z 245163 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:41.242110Z 245163 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:41.249269Z 245163 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:41.251583Z 245163 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:41.257498Z 245163 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:41.268491Z 245163 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:41.270636Z 245163 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:41.289901Z 245163 Query SELECT '
Warning: Undefined array key 0 in C:\AppServ\www\api\station_info.php on line 135
'
2025-02-08T02:57:41.308686Z 245163 Query SHOW WARNINGS
2025-02-08T02:57:41.308892Z 245163 Query SELECT @@lower_case_table_names
2025-02-08T02:57:41.339411Z 245163 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:41.377791Z 245164 Quit
2025-02-08T02:57:41.377844Z 245163 Quit
2025-02-08T02:57:41.506084Z 25365 Query SELECT table_name FROM cnt_class where type= 0
2025-02-08T02:57:41.506683Z 25365 Query SELECT COUNT(*) FROM history_red WHERE plate = 'AXB-9969'and time = '2025-02-08 10:56:48'and type = 0
2025-02-08T02:57:41.525915Z 25365 Query INSERT INTO history_red(sid,date,time,type,picname,videoname,plate,car_type,speed,car_tp,area,red,ViolationTimestamp,StartTimestamp,lane) values('132','2025-02-08','2025-02-08 10:56:48','0','"20250208105648_010871A_1001.jpg,20250208105648_010871B_1001.jpg"','"20250208105648_010871_1001.mp4"','AXB-9969','22','---','1','LA','---','','1738983402163','1')
2025-02-08T02:57:41.534093Z 25365 Query SHOW WARNINGS
2025-02-08T02:57:42.351589Z 240348 Init DB keyway
2025-02-08T02:57:42.371763Z 240348 Query SELECT * FROM reset_cnt WHERE City = 'Taipei' AND SID = '88' AND status = 0
2025-02-08T02:57:42.401555Z 240348 Query UPDATE reset_cnt SET status = 1 WHERE City = 'Taipei' AND SID = '88' AND status = 0
2025-02-08T02:57:44.770331Z 245165 Connect root@localhost on using TCP/IP
2025-02-08T02:57:44.770472Z 245165 Query SELECT @@version, @@version_comment
2025-02-08T02:57:44.771949Z 245165 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:44.772058Z 245165 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:44.775498Z 245166 Connect root@localhost on using TCP/IP
2025-02-08T02:57:44.781659Z 245165 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:44.791232Z 245165 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:44.819436Z 245165 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:44.844682Z 245166 Quit
2025-02-08T02:57:44.844740Z 245165 Quit
2025-02-08T02:57:44.881060Z 245167 Connect root@localhost on using TCP/IP
2025-02-08T02:57:44.881196Z 245167 Query SELECT @@version, @@version_comment
2025-02-08T02:57:44.882670Z 245167 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:44.882773Z 245167 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:44.896395Z 245168 Connect root@localhost on using TCP/IP
2025-02-08T02:57:44.903089Z 245167 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:44.914393Z 245167 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:44.925555Z 245168 Quit
2025-02-08T02:57:44.925605Z 245167 Quit
2025-02-08T02:57:46.388820Z 213990 Init DB keyway
2025-02-08T02:57:46.428752Z 213990 Query SELECT * FROM reset_cnt WHERE City = 'Taipei' AND SID = '63' AND status = 0
2025-02-08T02:57:46.459758Z 213990 Query UPDATE reset_cnt SET status = 1 WHERE City = 'Taipei' AND SID = '63' AND status = 0
2025-02-08T02:57:48.015800Z 13 Init DB keyway
2025-02-08T02:57:48.015973Z 13 Query SELECT * FROM lpr_station where local_auto = 'T'
2025-02-08T02:57:48.954101Z 245169 Connect root@localhost on using TCP/IP
2025-02-08T02:57:48.954247Z 245169 Query SELECT @@version, @@version_comment
2025-02-08T02:57:48.955659Z 245169 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:48.955783Z 245169 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:48.959293Z 245170 Connect root@localhost on using TCP/IP
2025-02-08T02:57:48.965623Z 245169 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:48.975830Z 245169 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:49.011552Z 245170 Quit
2025-02-08T02:57:49.011632Z 245169 Quit
2025-02-08T02:57:49.474492Z 245171 Connect root@localhost on using TCP/IP
2025-02-08T02:57:49.474636Z 245171 Query SELECT @@version, @@version_comment
2025-02-08T02:57:49.476033Z 245171 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:49.476138Z 245171 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:49.479314Z 245172 Connect root@localhost on using TCP/IP
2025-02-08T02:57:49.485363Z 245171 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:49.494564Z 245171 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:49.504275Z 245172 Quit
2025-02-08T02:57:49.504314Z 245171 Quit
2025-02-08T02:57:50.865151Z 245173 Connect root@localhost on using TCP/IP
2025-02-08T02:57:50.865320Z 245173 Query SELECT @@version, @@version_comment
2025-02-08T02:57:50.866768Z 245173 Query SET NAMES 'utf8mb4' COLLATE 'utf8mb4_general_ci'
2025-02-08T02:57:50.866872Z 245173 Query SET lc_messages = 'zh_TW'
2025-02-08T02:57:50.870157Z 245174 Connect root@localhost on using TCP/IP
2025-02-08T02:57:50.876251Z 245173 Query SELECT `SCHEMA_NAME` FROM `INFORMATION_SCHEMA`.`SCHEMATA`
2025-02-08T02:57:50.885714Z 245173 Query SET collation_connection = 'utf8mb4_unicode_ci'
2025-02-08T02:57:50.892225Z 245173 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:50.894421Z 245173 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:50.901017Z 245173 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:50.910914Z 245173 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:50.912790Z 245173 Query SHOW SESSION VARIABLES LIKE 'FOREIGN_KEY_CHECKS'
2025-02-08T02:57:50.920815Z 245173 Query SET global general_log='OFF'