| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198 |
- ---------------------------------------------------------------
- [2022-01-19T11:13:30+08:00] 127.0.0.1 POST renrenjie.com/agent/login
- [ sql ] [ DB ] CONNECT:[ UseTime:0.010013s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.003898s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `username` = '13655558888' ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000374s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2022-01-19T11:13:31+08:00] 127.0.0.1 GET renrenjie.com/agent/config
- [ sql ] [ DB ] CONNECT:[ UseTime:0.002767s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_config` [ RunTime:0.004202s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2022-01-19T11:13:32+08:00] 127.0.0.1 GET renrenjie.com/agent/person
- [ sql ] [ DB ] CONNECT:[ UseTime:0.014876s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.004512s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000352s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001268s ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000507s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.004091s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000500s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_roles` [ RunTime:0.004073s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions` [ RunTime:0.003841s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_roles` [ RunTime:0.001394s ]
- [ sql ] [ SQL ] SELECT `permission_idx` FROM `ins_agent_system_permissions_roles` WHERE `role_id` = 44 LIMIT 1 [ RunTime:0.000552s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- ---------------------------------------------------------------
- [2022-01-19T11:13:40+08:00] 127.0.0.1 GET renrenjie.com/agent/store/stats/index
- [ sql ] [ DB ] CONNECT:[ UseTime:0.003984s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.004859s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000287s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.005773s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000458s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001409s ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000387s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_taxi_order` [ RunTime:0.005891s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_order_paylog` [ RunTime:0.004375s ]
- [ 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 ]
- [ error ] [2]array_column() expects parameter 1 to be array, string given
- ---------------------------------------------------------------
- [2022-01-19T11:14:08+08:00] 127.0.0.1 GET renrenjie.com/agent/store/stats/index
- [ sql ] [ DB ] CONNECT:[ UseTime:0.005780s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.004057s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000243s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.003895s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000351s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001151s ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000318s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_taxi_order` [ RunTime:0.005104s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_order_paylog` [ RunTime:0.004887s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2022-01-19T11:14:18+08:00] 127.0.0.1 GET renrenjie.com/agent/store/stats/index
- [ sql ] [ DB ] CONNECT:[ UseTime:0.003412s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.005520s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000292s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.006150s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000497s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001344s ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000324s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_taxi_order` [ RunTime:0.003776s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_order_paylog` [ RunTime:0.003812s ]
- [ 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 ]
- ---------------------------------------------------------------
- [2022-01-19T11:15:09+08:00] 127.0.0.1 GET renrenjie.com/agent/store/stats/index
- [ sql ] [ DB ] CONNECT:[ UseTime:0.002593s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.003873s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000261s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.003904s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000384s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001556s ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000411s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_taxi_order` [ RunTime:0.004549s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_order_paylog` [ RunTime:0.003991s ]
- [ 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 ]
- [ error ] [2]array_column() expects parameter 1 to be array, object given
- ---------------------------------------------------------------
- [2022-01-19T11:15:56+08:00] 127.0.0.1 GET renrenjie.com/agent/store/stats/index
- [ sql ] [ DB ] CONNECT:[ UseTime:0.002625s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.004002s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000280s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.003740s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000344s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001179s ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000411s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_taxi_order` [ RunTime:0.000745s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_order_paylog` [ RunTime:0.003967s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_order` [ RunTime:0.003978s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- ---------------------------------------------------------------
- [2022-01-19T11:17:03+08:00] 127.0.0.1 GET renrenjie.com/agent/store/stats/index
- [ sql ] [ DB ] CONNECT:[ UseTime:0.002585s ] mysql:host=localhost;port=3306;dbname=renrenjie_com;charset=utf8
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_users` [ RunTime:0.004364s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000335s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_permissions_access` [ RunTime:0.004081s ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_permissions_access` [ RunTime:0.000377s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_agent_system_operate_log` [ RunTime:0.001225s ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SELECT * FROM `ins_agent_system_users` WHERE ( `id` = 44 ) AND `ins_agent_system_users`.`deleted_at` = 0 LIMIT 1 [ RunTime:0.000317s ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_taxi_order` [ RunTime:0.004818s ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_order_paylog` [ RunTime:0.004628s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ sql ] [ SQL ] SHOW COLUMNS FROM `ins_goods_order` [ RunTime:0.003867s ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
- [ 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 ]
|