Начало Каталог Помощ
Регистрация Вход
gd-backend
/
gd_crontab
2
0
Разклонения 0
Файлове Задачи 0 Заявки за сливане 0 Уики
ИН на ревизия: ff815c134a
Клонове Маркери
gd_crontab
/
nohup.out

nohup.out 91 KB
История Директен файл

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282 
  1. bill cron : 0 15 14 * * ?
    2. 

  2. &{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]
    3. 

  3. [ORM]2023/02/06 09:31:00  -[Queries/default] - [  OK /  db.BeginTx /     0.5ms] - [START TRANSACTION]
    4. 

  4. [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`
    5. 

  5. 2023/02/06 09:31:00 server.go:174: INFO : server pid:3561
    6. 

  6. [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`
    7. 

  7. [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]
    8. 

  8. [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`
    9. 

  9. [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`
    10. 

  10. [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]
    11. 

  11. [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`
    12. 

  12. [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`
    13. 

  13. [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]
    14. 

  14. [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`
    15. 

  15. [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`
    16. 

  16. [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]
    17. 

  17. [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`
    18. 

  18. [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`
    19. 

  19. [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]
    20. 

  20. [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`
    21. 

  21. [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`
    22. 

  22. [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]
    23. 

  23. [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`
    24. 

  24. [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`
    25. 

  25. [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]
    26. 

  26. [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`
    27. 

  27. [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`
    28. 

  28. [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]
    29. 

  29. [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`
    30. 

  30. [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`
    31. 

  31. [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]
    32. 

  32. [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`
    33. 

  33. [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`
    34. 

  34. [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]
    35. 

  35. [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`
    36. 

  36. [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`
    37. 

  37. [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]
    38. 

  38. [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`
    39. 

  39. [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`
    40. 

  40. [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]
    41. 

  41. [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`
    42. 

  42. [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`
    43. 

  43. [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]
    44. 

  44. [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`
    45. 

  45. [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
    46. 

  46. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675641600`, `1675645200`
    47. 

  47. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    48. 

  48. [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` = ? ] - `1675638000`
    49. 

  49. [ORM]2023/02/06 09:31:02  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    50. 

  50. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675638000`, `1675641600`
    51. 

  51. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.5ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    52. 

  52. [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` = ? ] - `1675634400`
    53. 

  53. [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
    54. 

  54. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675634400`, `1675638000`
    55. 

  55. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    56. 

  56. [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` = ? ] - `1675630800`
    57. 

  57. [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
    58. 

  58. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675630800`, `1675634400`
    59. 

  59. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    60. 

  60. [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` = ? ] - `1675627200`
    61. 

  61. [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
    62. 

  62. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675627200`, `1675630800`
    63. 

  63. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    64. 

  64. [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` = ? ] - `1675623600`
    65. 

  65. [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
    66. 

  66. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675623600`, `1675627200`
    67. 

  67. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    68. 

  68. [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` = ? ] - `1675620000`
    69. 

  69. [ORM]2023/02/06 09:31:02  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    70. 

  70. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675620000`, `1675623600`
    71. 

  71. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    72. 

  72. [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` = ? ] - `1675616400`
    73. 

  73. [ORM]2023/02/06 09:31:02  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    74. 

  74. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675616400`, `1675620000`
    75. 

  75. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    76. 

  76. [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` = ? ] - `1675612800`
    77. 

  77. [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
    78. 

  78. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.8ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675612800`, `1675616400`
    79. 

  79. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.4ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    80. 

  80. [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` = ? ] - `1675609200`
    81. 

  81. [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
    82. 

  82. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675609200`, `1675612800`
    83. 

  83. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    84. 

  84. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK / db.QueryRow /     0.7ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675605600`
    85. 

  85. [ORM]2023/02/06 09:31:02  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    86. 

  86. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675605600`, `1675609200`
    87. 

  87. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    88. 

  88. [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` = ? ] - `1675602000`
    89. 

  89. [ORM]2023/02/06 09:31:02  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    90. 

  90. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675602000`, `1675605600`
    91. 

  91. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    92. 

  92. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK / db.QueryRow /     0.5ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675598400`
    93. 

  93. [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
    94. 

  94. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675598400`, `1675602000`
    95. 

  95. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    96. 

  96. [ORM]2023/02/06 09:31:02  -[Queries/default] - [  OK /   tx.Commit /     0.3ms] - [COMMIT]
    97. 

  97. [ORM]2023/02/06 10:02:00  -[Queries/default] - [  OK /  db.BeginTx /     0.3ms] - [START TRANSACTION]
    98. 

  98. [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` = ? ] - `1675645200`
    99. 

  99. [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] - `1675645200`, `1675648800`
    100. 

  100. [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]
    101. 

  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`
    102. 

  102. [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`
    103. 

  103. [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]
    104. 

  104. [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`
    105. 

  105. [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`
    106. 

  106. [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]
    107. 

  107. [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`
    108. 

  108. [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`
    109. 

  109. [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]
    110. 

  110. [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`
    111. 

  111. [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`
    112. 

  112. [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]
    113. 

  113. [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`
    114. 

  114. [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`
    115. 

  115. [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]
    116. 

  116. [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`
    117. 

  117. [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`
    118. 

  118. [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]
    119. 

  119. [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`
    120. 

  120. [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`
    121. 

  121. [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]
    122. 

  122. [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`
    123. 

  123. [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`
    124. 

  124. [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]
    125. 

  125. [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`
    126. 

  126. [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`
    127. 

  127. [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]
    128. 

  128. [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`
    129. 

  129. [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`
    130. 

  130. [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]
    131. 

  131. [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`
    132. 

  132. [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`
    133. 

  133. [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]
    134. 

  134. [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`
    135. 

  135. [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`
    136. 

  136. [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]
    137. 

  137. [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`
    138. 

  138. [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
    139. 

  139. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675645200`, `1675648800`
    140. 

  140. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    141. 

  141. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK / db.QueryRow /     0.5ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675641600`
    142. 

  142. [ORM]2023/02/06 10:02:01  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    143. 

  143. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675641600`, `1675645200`
    144. 

  144. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    145. 

  145. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK / db.QueryRow /     0.5ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675638000`
    146. 

  146. [ORM]2023/02/06 10:02:01  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    147. 

  147. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675638000`, `1675641600`
    148. 

  148. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    149. 

  149. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK / db.QueryRow /     0.6ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675634400`
    150. 

  150. [ORM]2023/02/06 10:02:01  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    151. 

  151. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675634400`, `1675638000`
    152. 

  152. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    153. 

  153. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK / db.QueryRow /     0.6ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675630800`
    154. 

  154. [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
    155. 

  155. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675630800`, `1675634400`
    156. 

  156. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    157. 

  157. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK / db.QueryRow /     0.6ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675627200`
    158. 

  158. [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
    159. 

  159. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675627200`, `1675630800`
    160. 

  160. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    161. 

  161. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK / db.QueryRow /     0.6ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675623600`
    162. 

  162. [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
    163. 

  163. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675623600`, `1675627200`
    164. 

  164. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    165. 

  165. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK / db.QueryRow /     0.6ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675620000`
    166. 

  166. [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
    167. 

  167. [ORM]2023/02/06 10:02:01  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675620000`, `1675623600`
    168. 

  168. [ORM]2023/02/06 10:02:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    169. 

  169. [ORM]2023/02/06 10:02:02  -[Queries/default] - [  OK / db.QueryRow /     0.6ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675616400`
    170. 

  170. [ORM]2023/02/06 10:02:02  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    171. 

  171. [ORM]2023/02/06 10:02: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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675616400`, `1675620000`
    172. 

  172. [ORM]2023/02/06 10:02:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    173. 

  173. [ORM]2023/02/06 10:02:02  -[Queries/default] - [  OK / db.QueryRow /     0.5ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675612800`
    174. 

  174. [ORM]2023/02/06 10:02:02  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    175. 

  175. [ORM]2023/02/06 10:02: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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675612800`, `1675616400`
    176. 

  176. [ORM]2023/02/06 10:02:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    177. 

  177. [ORM]2023/02/06 10:02:02  -[Queries/default] - [  OK / db.QueryRow /     0.7ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675609200`
    178. 

  178. [ORM]2023/02/06 10:02:02  -[Queries/default] - [FAIL /    db.Query /     0.3ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    179. 

  179. [ORM]2023/02/06 10:02: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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675609200`, `1675612800`
    180. 

  180. [ORM]2023/02/06 10:02:02  -[Queries/default] - [  OK /    db.Query /     0.4ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    181. 

  181. [ORM]2023/02/06 10:02:02  -[Queries/default] - [  OK / db.QueryRow /     0.5ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675605600`
    182. 

  182. [ORM]2023/02/06 10:02:02  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    183. 

  183. [ORM]2023/02/06 10:02: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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675605600`, `1675609200`
    184. 

  184. [ORM]2023/02/06 10:02:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    185. 

  185. [ORM]2023/02/06 10:02:02  -[Queries/default] - [  OK / db.QueryRow /     0.6ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675602000`
    186. 

  186. [ORM]2023/02/06 10:02:02  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    187. 

  187. [ORM]2023/02/06 10:02: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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675602000`, `1675605600`
    188. 

  188. [ORM]2023/02/06 10:02:02  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    189. 

  189. [ORM]2023/02/06 10:02:02  -[Queries/default] - [  OK /   tx.Commit /     0.2ms] - [COMMIT]
    190. 

  190. [ORM]2023/02/06 11:02:00  -[Queries/default] - [  OK /  db.BeginTx /     0.3ms] - [START TRANSACTION]
    191. 

  191. [ORM]2023/02/06 11:02:00  -[Queries/default] - [  OK / db.QueryRow /     0.7ms] - [SELECT COUNT(*) FROM `t_gd_report_hour` T0 WHERE T0.`hour` = ? ] - `1675648800`
    192. 

  192. [ORM]2023/02/06 11: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] - `1675648800`, `1675652400`
    193. 

  193. [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]
    194. 

  194. [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`
    195. 

  195. [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`
    196. 

  196. [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]
    197. 

  197. [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`
    198. 

  198. [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`
    199. 

  199. [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]
    200. 

  200. [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`
    201. 

  201. [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`
    202. 

  202. [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]
    203. 

  203. [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`
    204. 

  204. [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`
    205. 

  205. [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]
    206. 

  206. [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`
    207. 

  207. [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`
    208. 

  208. [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]
    209. 

  209. [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`
    210. 

  210. [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`
    211. 

  211. [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]
    212. 

  212. [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`
    213. 

  213. [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`
    214. 

  214. [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]
    215. 

  215. [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`
    216. 

  216. [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`
    217. 

  217. [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]
    218. 

  218. [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`
    219. 

  219. [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`
    220. 

  220. [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]
    221. 

  221. [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`
    222. 

  222. [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`
    223. 

  223. [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]
    224. 

  224. [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`
    225. 

  225. [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`
    226. 

  226. [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]
    227. 

  227. [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`
    228. 

  228. [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`
    229. 

  229. [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]
    230. 

  230. [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`
    231. 

  231. [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
    232. 

  232. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675648800`, `1675652400`
    233. 

  233. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    234. 

  234. [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` = ? ] - `1675645200`
    235. 

  235. [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
    236. 

  236. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675645200`, `1675648800`
    237. 

  237. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    238. 

  238. [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` = ? ] - `1675641600`
    239. 

  239. [ORM]2023/02/06 11:02:01  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    240. 

  240. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675641600`, `1675645200`
    241. 

  241. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    242. 

  242. [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` = ? ] - `1675638000`
    243. 

  243. [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
    244. 

  244. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675638000`, `1675641600`
    245. 

  245. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    246. 

  246. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK / db.QueryRow /     0.5ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675634400`
    247. 

  247. [ORM]2023/02/06 11:02:01  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    248. 

  248. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675634400`, `1675638000`
    249. 

  249. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    250. 

  250. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK / db.QueryRow /     0.5ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675630800`
    251. 

  251. [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
    252. 

  252. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675630800`, `1675634400`
    253. 

  253. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    254. 

  254. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK / db.QueryRow /     0.5ms] - [SELECT COUNT(*) FROM `t_gd_provider_report_hour` T0 WHERE T0.`hour` = ? ] - `1675627200`
    255. 

  255. [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
    256. 

  256. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675627200`, `1675630800`
    257. 

  257. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    258. 

  258. [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` = ? ] - `1675623600`
    259. 

  259. [ORM]2023/02/06 11:02:01  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    260. 

  260. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675623600`, `1675627200`
    261. 

  261. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    262. 

  262. [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` = ? ] - `1675620000`
    263. 

  263. [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
    264. 

  264. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675620000`, `1675623600`
    265. 

  265. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    266. 

  266. [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` = ? ] - `1675616400`
    267. 

  267. [ORM]2023/02/06 11:02:01  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    268. 

  268. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675616400`, `1675620000`
    269. 

  269. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    270. 

  270. [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` = ? ] - `1675612800`
    271. 

  271. [ORM]2023/02/06 11:02:01  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    272. 

  272. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.6ms] - [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675612800`, `1675616400`
    273. 

  273. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    274. 

  274. [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` = ? ] - `1675609200`
    275. 

  275. [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
    276. 

  276. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675609200`, `1675612800`
    277. 

  277. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    278. 

  278. [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` = ? ] - `1675605600`
    279. 

  279. [ORM]2023/02/06 11:02:01  -[Queries/default] - [FAIL /    db.Query /     0.2ms] - [select * from mishi_ids] - Error 1146: Table 'db_gd_access_log.mishi_ids' doesn't exist
    280. 

  280. [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 <? group by create_time, merchant_id, api_id,provider_api_id order by merchant_id, api_id, provider_api_id, timestamp] - `1675605600`, `1675609200`
    281. 

  281. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /    db.Query /     0.3ms] - [select provider_api_id from t_gd_callback_ids where service_type=101]
    282. 

  282. [ORM]2023/02/06 11:02:01  -[Queries/default] - [  OK /   tx.Commit /     0.2ms] - [COMMIT]
    283.