bill cron : 0 15 14 * * ? &{dev fa06b6949da968c298d906275cd18078 96a1d22a28c83ff23ab3ad3c69eda2e9 279298823@qq.com 279298823@qq.com 279298823@qq.com / 279298823@qq.com {root hly@1353406 rm-2vc722159701x853mho.mysql.cn-chengdu.rds.aliyuncs.com:3306 utf8 10 100 0} {127.0.0.1:6379 hly@1353406 0 100 10 1 false} { false} {/gd_microservice {tcp gd_crontab 60 db_gd_access_log 5 {100 7 30 true} gd-crontab-svc 0} {tcp gd_management 60 db_gd_management 5 {100 7 30 true} gd-management-svc 0} {tcp gd_vehicle 60 db_gd_vehicle 5 {100 7 30 true} gd-vehicle-svc 0}} { } { 0} 0 15 14 * * ? 0 25 15 * * ? 500 500 2000} 0.0.0.0:40008 [172.24.3.23:22379] [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.BeginTx / 0.5ms] - [START TRANSACTION] [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.QueryRow / 1.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675641600` 2023/02/06 09:31:00 server.go:174: INFO : server pid:3561 [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.Query / 3.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675641600`, `1675645200` [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675638000` [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675638000`, `1675641600` [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675634400` [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675634400`, `1675638000` [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.Query / 0.2ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675630800` [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.Query / 2.1ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675630800`, `1675634400` [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675627200` [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.Query / 1.1ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675627200`, `1675630800` [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675623600` [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675623600`, `1675627200` [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675620000` [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675620000`, `1675623600` [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.QueryRow / 0.5ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675616400` [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.Query / 1.1ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675616400`, `1675620000` [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675612800` [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.Query / 1.1ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675612800`, `1675616400` [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675609200` [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675609200`, `1675612800` [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675605600` [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675605600`, `1675609200` [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675602000` [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675602000`, `1675605600` [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:01 -[Queries/default] - [ OK / db.QueryRow / 0.5ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675598400` [ORM]2023/02/06 09:31:02 -[Queries/default] - [ OK / db.Query / 0.9ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675598400`, `1675602000` [ORM]2023/02/06 09:31:02 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 09:31:02 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675641600` [ORM]2023/02/06 09:31:02 -[Queries/default] - [FAIL / db.Query / 0.3ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist [ORM]2023/02/06 09:31:02 -[Queries/default] - [ OK / db.Query / 0.7ms] - [select create_time as date, provider_api_id, merchant_id, api_id, merchant_name, api_name, count(state) as total, sum(state=1) as success, sum(code<>20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp = ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675645200`, `1675648800` [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675641600` [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.Query / 1.1ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675641600`, `1675645200` [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675638000` [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675638000`, `1675641600` [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675634400` [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.Query / 1.2ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675634400`, `1675638000` [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675630800` [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675630800`, `1675634400` [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.QueryRow / 0.7ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675627200` [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675627200`, `1675630800` [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:00 -[Queries/default] - [ OK / db.QueryRow / 0.7ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675623600` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675623600`, `1675627200` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675620000` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 1.1ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675620000`, `1675623600` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675616400` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 4.3ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675616400`, `1675620000` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 2.9ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.7ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675612800` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675612800`, `1675616400` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675609200` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 1.8ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675609200`, `1675612800` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675605600` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 1.1ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675605600`, `1675609200` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675602000` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675602000`, `1675605600` [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.7ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675645200` [ORM]2023/02/06 10:02:01 -[Queries/default] - [FAIL / db.Query / 0.3ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist [ORM]2023/02/06 10:02:01 -[Queries/default] - [ OK / db.Query / 0.7ms] - [select create_time as date, provider_api_id, merchant_id, api_id, merchant_name, api_name, count(state) as total, sum(state=1) as success, sum(code<>20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp = ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675648800`, `1675652400` [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675645200` [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675645200`, `1675648800` [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675641600` [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.Query / 1.1ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675641600`, `1675645200` [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675638000` [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.Query / 1.1ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675638000`, `1675641600` [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675634400` [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675634400`, `1675638000` [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675630800` [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675630800`, `1675634400` [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:00 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675627200` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 1.1ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675627200`, `1675630800` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675623600` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675623600`, `1675627200` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675620000` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 1.1ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675620000`, `1675623600` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675616400` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675616400`, `1675620000` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675612800` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 1.8ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675612800`, `1675616400` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675609200` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675609200`, `1675612800` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.7ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675605600` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 1.0ms] - [select create_time as date, merchant_name, api_id, merchant_id, group_concat(distinct merchant_data_api_id) as merchant_data_api_id, api_name,count(state) as total ,sum(code=0 or code=20001 or code=20002 or code=10002 or code=10001) as valid,sum(code=0 or code=20001 ) as success ,sum(code=0) as query,count(distinct case when code = 0 then search end) as nonredundant_query,count(distinct case when code = 0 or code=20001 or code=20002 or code=10002 or code=10001 then search end) as nonredundant,sum(is_reuse and state=1) as reuse, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed, sum(code=10001 or code=10002) as platform_error, sum(code=20002) as provider_error,api_id from t_gd_access_log_day as a where timestamp >= ? and timestamp < ? and merchant_data_api_id > 0 group by create_time, merchant_id, api_id order by timestamp] - `1675605600`, `1675609200` [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 0.3ms] - [select api_id from t_gd_callback_ids where service_type=101] [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.QueryRow / 0.6ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675648800` [ORM]2023/02/06 11:02:01 -[Queries/default] - [FAIL / db.Query / 0.3ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist [ORM]2023/02/06 11:02:01 -[Queries/default] - [ OK / db.Query / 0.7ms] - [select create_time as date, provider_api_id, merchant_id, api_id, merchant_name, api_name, count(state) as total, sum(state=1) as success, sum(code<>20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp 20001 and state=1) as query, sum(state<>1) as failed,sum(code=20001) as query_no_record, avg(elapsed) as avg_elapsed, sum(elapsed) as sum_elapsed from t_gd_thirdpart_log_day as a where timestamp >= ? and timestamp