19.log 32 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198
  1. ---------------------------------------------------------------
  2. [2022-01-19T11:13:30+08:00] 127.0.0.1 POST renrenjie.com/agent/login
  3. [ sql ] [ DB ] CONNECT:[ UseTime:0.010013s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  4. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.003898s ]
  5. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `username` = '13655558888' ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000374s ]
  6. [ sql ] [ SQL ] UPDATE `ins_agent_system_users` SET `last_login_time` = 1642562010 , `updated_at` = 1642562010 WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 [ RunTime:0.000661s ]
  7. ---------------------------------------------------------------
  8. [2022-01-19T11:13:31+08:00] 127.0.0.1 GET renrenjie.com/agent/config
  9. [ sql ] [ DB ] CONNECT:[ UseTime:0.002767s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  10. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_config` [ RunTime:0.004202s ]
  11. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_config` WHERE ( `web` = 1 ) AND `ins_agent_system_config`.`deleted_at` = 0 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.002907s ]
  12. ---------------------------------------------------------------
  13. [2022-01-19T11:13:32+08:00] 127.0.0.1 GET renrenjie.com/agent/person
  14. [ sql ] [ DB ] CONNECT:[ UseTime:0.014876s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  15. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.004512s ]
  16. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000352s ]
  17. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001268s ]
  18. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_operate_log` WHERE ( `user_id` = 44 AND `route` = '/agent/person' AND `operate` = 'get' AND `query` = '[]' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.020737s ]
  19. [ sql ] [ SQL ] UPDATE `ins_agent_system_operate_log` SET `user_id` = 44 , `route` = '/agent/person' , `operate` = 'get' , `query` = '[]' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 2 , `updated_at` = 1642562012 WHERE ( `id` = 46221 ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 [ RunTime:0.001915s ]
  20. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000507s ]
  21. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.004091s ]
  22. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000500s ]
  23. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_roles` [ RunTime:0.004073s ]
  24. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_roles` WHERE ( `name` = 'motor_agent_176' ) AND `ins_agent_system_roles`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000372s ]
  25. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions` [ RunTime:0.003841s ]
  26. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/permission/roles' AND `policy` = 'get' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000448s ]
  27. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/permission/roles' AND `policy` = 'post' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000336s ]
  28. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/permission/roles/:id' AND `policy` = 'put' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000342s ]
  29. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/permission/roles/:id' AND `policy` = 'delete' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000276s ]
  30. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/permission/roles/perm/:id' AND `policy` = 'get' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000257s ]
  31. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/permission/roles/auth/:id' AND `policy` = 'put' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000254s ]
  32. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/permission/users' AND `policy` = 'get' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000255s ]
  33. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/permission/users' AND `policy` = 'post' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000585s ]
  34. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/permission/users/:ids' AND `policy` = 'put' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000453s ]
  35. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/permission/users/:id' AND `policy` = 'delete' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000473s ]
  36. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/permission/users/:id/roles' AND `policy` = 'get' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000447s ]
  37. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = 'skill' AND `policy` = 'get' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000491s ]
  38. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/store/stats/index' AND `policy` = 'get' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000440s ]
  39. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/finance/log/index' AND `policy` = 'get' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000391s ]
  40. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/finance/withdraw/index' AND `policy` = 'get' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000374s ]
  41. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/order/taxi/index' AND `policy` = 'get' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000377s ]
  42. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/order/taxi/dispense/id/:id' AND `policy` = 'post' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000380s ]
  43. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/order/taxi/complete/id/:id' AND `policy` = 'post' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000378s ]
  44. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `url` = '/order/taxi/delete/id/:id' AND `policy` = 'delete' ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000381s ]
  45. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_roles` [ RunTime:0.001394s ]
  46. [ sql ] [ SQL ] SELECT `permission_idx` FROM `ins_agent_system_permissions_roles` WHERE `role_id` = 44 LIMIT 1 [ RunTime:0.000552s ]
  47. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 1 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000268s ]
  48. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 2 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000241s ]
  49. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 3 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000209s ]
  50. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 4 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000201s ]
  51. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 10 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000204s ]
  52. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 17 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000199s ]
  53. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 58 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000198s ]
  54. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 101 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000199s ]
  55. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 102 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000199s ]
  56. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 151 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000153s ]
  57. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 152 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000151s ]
  58. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 153 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000150s ]
  59. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 145 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000252s ]
  60. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 146 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000256s ]
  61. [ sql ] [ SQL ] SELECT `id`,`parent_id`,`name`,`url`,`policy`,`icon`,`type` FROM `ins_agent_system_permissions` WHERE ( `id` = 150 ) AND `ins_agent_system_permissions`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000288s ]
  62. ---------------------------------------------------------------
  63. [2022-01-19T11:13:40+08:00] 127.0.0.1 GET renrenjie.com/agent/store/stats/index
  64. [ sql ] [ DB ] CONNECT:[ UseTime:0.003984s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  65. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.004859s ]
  66. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000287s ]
  67. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.005773s ]
  68. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000458s ]
  69. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001409s ]
  70. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_operate_log` WHERE ( `user_id` = 44 AND `route` = '/agent/store/stats/index' AND `operate` = 'get' AND `query` = '[]' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.011040s ]
  71. [ sql ] [ SQL ] INSERT INTO `ins_agent_system_operate_log` (`user_id` , `route` , `operate` , `query` , `ip` , `os` , `browser` , `created_at` , `updated_at`) VALUES (44 , '/agent/store/stats/index' , 'get' , '[]' , '127.0.0.1' , 'Windows' , 'Chrome' , 1642562019 , 1642562019) [ RunTime:0.001172s ]
  72. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000387s ]
  73. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_taxi_order` [ RunTime:0.005891s ]
  74. [ sql ] [ SQL ] SELECT * FROM `ins_taxi_order` WHERE ( `area_id` = 450107 AND `status` IN (0,2,3,4) ) AND `ins_taxi_order`.`deleted_at` = 0 [ RunTime:0.029669s ]
  75. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_order_paylog` [ RunTime:0.004375s ]
  76. [ sql ] [ SQL ] SELECT `order_idx`,`out_trade_no`,`total_price`,`pay_type` FROM `ins_order_paylog` WHERE ( `pay_price` > 0 AND `pay_price` > 0 AND `order_idx` IN (2,3,4,5,6,7,8,12,13,14,15,16,17,24,25,30,31,32,33,38,39,47,59,60,68,77,113,114,115,116,117,118,119,173,221,227,2234,2235,2236,2237,2256,4923,14003,15494,15947,15950,15951,15954) ) AND `ins_order_paylog`.`deleted_at` = 0 [ RunTime:0.022677s ]
  77. [ error ] [2]array_column() expects parameter 1 to be array, string given
  78. ---------------------------------------------------------------
  79. [2022-01-19T11:14:08+08:00] 127.0.0.1 GET renrenjie.com/agent/store/stats/index
  80. [ sql ] [ DB ] CONNECT:[ UseTime:0.005780s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  81. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.004057s ]
  82. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000243s ]
  83. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.003895s ]
  84. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000351s ]
  85. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001151s ]
  86. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_operate_log` WHERE ( `user_id` = 44 AND `route` = '/agent/store/stats/index' AND `operate` = 'get' AND `query` = '[]' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.010720s ]
  87. [ sql ] [ SQL ] UPDATE `ins_agent_system_operate_log` SET `user_id` = 44 , `route` = '/agent/store/stats/index' , `operate` = 'get' , `query` = '[]' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 2 , `updated_at` = 1642562048 WHERE ( `id` = 46222 ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 [ RunTime:0.039509s ]
  88. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000318s ]
  89. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_taxi_order` [ RunTime:0.005104s ]
  90. [ sql ] [ SQL ] SELECT * FROM `ins_taxi_order` WHERE ( `area_id` = 450107 AND `status` IN (0,2,3,4) ) AND `ins_taxi_order`.`deleted_at` = 0 [ RunTime:0.010311s ]
  91. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_order_paylog` [ RunTime:0.004887s ]
  92. [ sql ] [ SQL ] SELECT `order_idx`,`out_trade_no`,`total_price`,`pay_type` FROM `ins_order_paylog` WHERE ( `pay_price` > 0 AND `pay_price` > 0 AND `order_idx` IN (2,3,4,5,6,7,8,12,13,14,15,16,17,24,25,30,31,32,33,38,39,47,59,60,68,77,113,114,115,116,117,118,119,173,221,227,2234,2235,2236,2237,2256,4923,14003,15494,15947,15950,15951,15954) ) AND `ins_order_paylog`.`deleted_at` = 0 [ RunTime:0.009562s ]
  93. ---------------------------------------------------------------
  94. [2022-01-19T11:14:18+08:00] 127.0.0.1 GET renrenjie.com/agent/store/stats/index
  95. [ sql ] [ DB ] CONNECT:[ UseTime:0.003412s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  96. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.005520s ]
  97. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000292s ]
  98. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.006150s ]
  99. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000497s ]
  100. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001344s ]
  101. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_operate_log` WHERE ( `user_id` = 44 AND `route` = '/agent/store/stats/index' AND `operate` = 'get' AND `query` = '[]' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.009709s ]
  102. [ sql ] [ SQL ] UPDATE `ins_agent_system_operate_log` SET `user_id` = 44 , `route` = '/agent/store/stats/index' , `operate` = 'get' , `query` = '[]' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 3 , `updated_at` = 1642562058 WHERE ( `id` = 46222 ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 [ RunTime:0.002038s ]
  103. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000324s ]
  104. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_taxi_order` [ RunTime:0.003776s ]
  105. [ sql ] [ SQL ] SELECT * FROM `ins_taxi_order` WHERE ( `area_id` = 450107 AND `status` IN (0,2,3,4) ) AND `ins_taxi_order`.`deleted_at` = 0 [ RunTime:0.010229s ]
  106. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_order_paylog` [ RunTime:0.003812s ]
  107. [ sql ] [ SQL ] SELECT `order_idx`,`out_trade_no`,`total_price`,`pay_type` FROM `ins_order_paylog` WHERE ( `pay_price` > 0 AND `pay_price` > 0 AND `order_idx` IN (2,3,4,5,6,7,8,12,13,14,15,16,17,24,25,30,31,32,33,38,39,47,59,60,68,77,113,114,115,116,117,118,119,173,221,227,2234,2235,2236,2237,2256,4923,14003,15494,15947,15950,15951,15954) ) AND `ins_order_paylog`.`deleted_at` = 0 [ RunTime:0.009629s ]
  108. ---------------------------------------------------------------
  109. [2022-01-19T11:15:09+08:00] 127.0.0.1 GET renrenjie.com/agent/store/stats/index
  110. [ sql ] [ DB ] CONNECT:[ UseTime:0.002593s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  111. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.003873s ]
  112. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000261s ]
  113. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.003904s ]
  114. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000384s ]
  115. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001556s ]
  116. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_operate_log` WHERE ( `user_id` = 44 AND `route` = '/agent/store/stats/index' AND `operate` = 'get' AND `query` = '[]' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.010881s ]
  117. [ sql ] [ SQL ] UPDATE `ins_agent_system_operate_log` SET `user_id` = 44 , `route` = '/agent/store/stats/index' , `operate` = 'get' , `query` = '[]' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 4 , `updated_at` = 1642562109 WHERE ( `id` = 46222 ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 [ RunTime:0.012362s ]
  118. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000411s ]
  119. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_taxi_order` [ RunTime:0.004549s ]
  120. [ sql ] [ SQL ] SELECT * FROM `ins_taxi_order` WHERE ( `area_id` = 450107 AND `status` IN (0,2,3,4) ) AND `ins_taxi_order`.`deleted_at` = 0 [ RunTime:0.010061s ]
  121. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_order_paylog` [ RunTime:0.003991s ]
  122. [ sql ] [ SQL ] SELECT `order_idx`,`out_trade_no`,`total_price`,`pay_type` FROM `ins_order_paylog` WHERE ( `pay_price` > 0 AND `pay_price` > 0 AND `order_idx` IN (2,3,4,5,6,7,8,12,13,14,15,16,17,24,25,30,31,32,33,38,39,47,59,60,68,77,113,114,115,116,117,118,119,173,221,227,2234,2235,2236,2237,2256,4923,14003,15494,15947,15950,15951,15954) ) AND `ins_order_paylog`.`deleted_at` = 0 [ RunTime:0.009561s ]
  123. [ error ] [2]array_column() expects parameter 1 to be array, object given
  124. ---------------------------------------------------------------
  125. [2022-01-19T11:15:56+08:00] 127.0.0.1 GET renrenjie.com/agent/store/stats/index
  126. [ sql ] [ DB ] CONNECT:[ UseTime:0.002625s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  127. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.004002s ]
  128. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000280s ]
  129. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.003740s ]
  130. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000344s ]
  131. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001179s ]
  132. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_operate_log` WHERE ( `user_id` = 44 AND `route` = '/agent/store/stats/index' AND `operate` = 'get' AND `query` = '[]' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.010098s ]
  133. [ sql ] [ SQL ] UPDATE `ins_agent_system_operate_log` SET `user_id` = 44 , `route` = '/agent/store/stats/index' , `operate` = 'get' , `query` = '[]' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 5 , `updated_at` = 1642562156 WHERE ( `id` = 46222 ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 [ RunTime:0.002280s ]
  134. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000411s ]
  135. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_taxi_order` [ RunTime:0.000745s ]
  136. [ sql ] [ SQL ] SELECT * FROM `ins_taxi_order` WHERE ( `area_id` = 450107 AND `status` IN (0,2,3,4) ) AND `ins_taxi_order`.`deleted_at` = 0 [ RunTime:0.010569s ]
  137. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_order_paylog` [ RunTime:0.003967s ]
  138. [ sql ] [ SQL ] SELECT `order_idx`,`out_trade_no`,`total_price`,`pay_type` FROM `ins_order_paylog` WHERE ( `pay_price` > 0 AND `pay_price` > 0 AND `order_idx` IN (2,3,4,5,6,7,8,12,13,14,15,16,17,24,25,30,31,32,33,38,39,47,59,60,68,77,113,114,115,116,117,118,119,173,221,227,2234,2235,2236,2237,2256,4923,14003,15494,15947,15950,15951,15954) ) AND `ins_order_paylog`.`deleted_at` = 0 [ RunTime:0.009624s ]
  139. [ sql ] [ SQL ] SELECT * FROM `ins_taxi_order` WHERE ( `area_id` = 450107 AND `status` IN (0,2,3,4) AND `created_at` BETWEEN 1642521600 AND 1642607999 ) AND `ins_taxi_order`.`deleted_at` = 0 [ RunTime:0.010110s ]
  140. [ sql ] [ SQL ] SELECT * FROM `ins_taxi_order` WHERE ( `area_id` = 450107 AND `status` IN (0,2,3,4) AND `created_at` BETWEEN 1640966400 AND 1643644799 ) AND `ins_taxi_order`.`deleted_at` = 0 [ RunTime:0.010685s ]
  141. [ sql ] [ SQL ] SELECT `order_idx`,`out_trade_no`,`total_price`,`pay_type` FROM `ins_order_paylog` WHERE ( `pay_price` > 0 AND `pay_price` > 0 AND `order_idx` IN (15947,15950,15951,15954) ) AND `ins_order_paylog`.`deleted_at` = 0 [ RunTime:0.008616s ]
  142. [ sql ] [ SQL ] SELECT * FROM `ins_taxi_order` WHERE ( `area_id` = 450107 AND `status` IN (0,2,3,4) AND `created_at` BETWEEN 1640966400 AND 1672502399 ) AND `ins_taxi_order`.`deleted_at` = 0 [ RunTime:0.010154s ]
  143. [ sql ] [ SQL ] SELECT `order_idx`,`out_trade_no`,`total_price`,`pay_type` FROM `ins_order_paylog` WHERE ( `pay_price` > 0 AND `pay_price` > 0 AND `order_idx` IN (15947,15950,15951,15954) ) AND `ins_order_paylog`.`deleted_at` = 0 [ RunTime:0.008541s ]
  144. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_order` [ RunTime:0.003978s ]
  145. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1640966400 AND 1643558400 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.001231s ]
  146. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1643644800 AND 1645977600 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000303s ]
  147. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1646064000 AND 1648656000 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000249s ]
  148. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1648742400 AND 1651248000 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000244s ]
  149. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1651334400 AND 1653926400 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000242s ]
  150. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1654012800 AND 1656518400 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000238s ]
  151. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1656604800 AND 1659196800 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000238s ]
  152. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1659283200 AND 1661875200 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000241s ]
  153. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1661961600 AND 1664467200 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000239s ]
  154. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1664553600 AND 1667145600 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000239s ]
  155. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1667232000 AND 1669737600 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000237s ]
  156. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1669824000 AND 1672416000 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000421s ]
  157. ---------------------------------------------------------------
  158. [2022-01-19T11:17:03+08:00] 127.0.0.1 GET renrenjie.com/agent/store/stats/index
  159. [ sql ] [ DB ] CONNECT:[ UseTime:0.002585s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
  160. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.004364s ]
  161. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000335s ]
  162. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.004081s ]
  163. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000377s ]
  164. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001225s ]
  165. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_operate_log` WHERE ( `user_id` = 44 AND `route` = '/agent/store/stats/index' AND `operate` = 'get' AND `query` = '[]' AND `ip` = '127.0.0.1' AND `os` = 'Windows' AND `browser` = 'Chrome' ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.010452s ]
  166. [ sql ] [ SQL ] UPDATE `ins_agent_system_operate_log` SET `user_id` = 44 , `route` = '/agent/store/stats/index' , `operate` = 'get' , `query` = '[]' , `ip` = '127.0.0.1' , `os` = 'Windows' , `browser` = 'Chrome' , `count` = 6 , `updated_at` = 1642562223 WHERE ( `id` = 46222 ) AND `ins_agent_system_operate_log`.`deleted_at` = 0 [ RunTime:0.001944s ]
  167. [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000317s ]
  168. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_taxi_order` [ RunTime:0.004818s ]
  169. [ sql ] [ SQL ] SELECT * FROM `ins_taxi_order` WHERE ( `area_id` = 450107 AND `status` IN (0,2,3,4) ) AND `ins_taxi_order`.`deleted_at` = 0 [ RunTime:0.010038s ]
  170. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_order_paylog` [ RunTime:0.004628s ]
  171. [ sql ] [ SQL ] SELECT `order_idx`,`out_trade_no`,`total_price`,`pay_type` FROM `ins_order_paylog` WHERE ( `is_pay` = 1 AND `order_idx` IN (2,3,4,5,6,7,8,12,13,14,15,16,17,24,25,30,31,32,33,38,39,47,59,60,68,77,113,114,115,116,117,118,119,173,221,227,2234,2235,2236,2237,2256,4923,14003,15494,15947,15950,15951,15954) ) AND `ins_order_paylog`.`deleted_at` = 0 [ RunTime:0.007296s ]
  172. [ sql ] [ SQL ] SELECT * FROM `ins_taxi_order` WHERE ( `area_id` = 450107 AND `status` IN (0,2,3,4) AND `created_at` BETWEEN 1642521600 AND 1642607999 ) AND `ins_taxi_order`.`deleted_at` = 0 [ RunTime:0.011643s ]
  173. [ sql ] [ SQL ] SELECT * FROM `ins_taxi_order` WHERE ( `area_id` = 450107 AND `status` IN (0,2,3,4) AND `created_at` BETWEEN 1640966400 AND 1643644799 ) AND `ins_taxi_order`.`deleted_at` = 0 [ RunTime:0.010006s ]
  174. [ sql ] [ SQL ] SELECT `order_idx`,`out_trade_no`,`total_price`,`pay_type` FROM `ins_order_paylog` WHERE ( `is_pay` = 1 AND `order_idx` IN (15947,15950,15951,15954) ) AND `ins_order_paylog`.`deleted_at` = 0 [ RunTime:0.006392s ]
  175. [ sql ] [ SQL ] SELECT * FROM `ins_taxi_order` WHERE ( `area_id` = 450107 AND `status` IN (0,2,3,4) AND `created_at` BETWEEN 1640966400 AND 1672502399 ) AND `ins_taxi_order`.`deleted_at` = 0 [ RunTime:0.010388s ]
  176. [ sql ] [ SQL ] SELECT `order_idx`,`out_trade_no`,`total_price`,`pay_type` FROM `ins_order_paylog` WHERE ( `is_pay` = 1 AND `order_idx` IN (15947,15950,15951,15954) ) AND `ins_order_paylog`.`deleted_at` = 0 [ RunTime:0.006285s ]
  177. [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_order` [ RunTime:0.003867s ]
  178. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1640966400 AND 1643558400 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000311s ]
  179. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1643644800 AND 1645977600 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000252s ]
  180. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1646064000 AND 1648656000 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000242s ]
  181. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1648742400 AND 1651248000 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000240s ]
  182. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1651334400 AND 1653926400 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000242s ]
  183. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1654012800 AND 1656518400 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000237s ]
  184. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1656604800 AND 1659196800 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000240s ]
  185. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1659283200 AND 1661875200 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000238s ]
  186. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1661961600 AND 1664467200 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000237s ]
  187. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1664553600 AND 1667145600 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000239s ]
  188. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1667232000 AND 1669737600 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000246s ]
  189. [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `ins_goods_order` WHERE ( `created_at` BETWEEN 1669824000 AND 1672416000 ) AND `ins_goods_order`.`deleted_at` = 0 [ RunTime:0.000310s ]