2025-06-17 08:59:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMDM4MzA4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAwNDE5MDh9.V7sZCrYAP0kKSjvsCK5Wo7YXMTNwjG-b-8YyfnIm0ak
2025-06-17 08:59:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMDM4MzA4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAwNDE5MDh9.V7sZCrYAP0kKSjvsCK5Wo7YXMTNwjG-b-8YyfnIm0ak
2025-06-17 08:59:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMDM4MzA4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAwNDE5MDh9.V7sZCrYAP0kKSjvsCK5Wo7YXMTNwjG-b-8YyfnIm0ak
2025-06-17 09:41:49|INFO|mt_ss login|params:{"loginId":"mecha","pw":"6630_Mecha"}
2025-06-17 09:41:49|SQL|[#1 - 0.58ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = 'mecha') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2025-06-17 09:41:49|INFO|mt_ss login|user:{"ID":22,"category":2,"ss_name":"MC","display_name":null,"en_name":"mecha","section":null,"section_id":4,"log_in":"mecha","pw":"6630_Mecha","manager_flag":0,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":null,"rent_a_car":null,"towing":null,"Delete_date":null,"line_openid":"4aHxP8CIZAnRDcfexnWoX90e7ij0gNefQCBYGemP2jZ","zip":null,"address":null,"telno":null,"faxno":null}
2025-06-17 09:41:49|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750124509,"data":{"ssid":22}}
2025-06-17 09:41:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTI0NTA5LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxMjgxMDl9.qk4tRb70ZnP1b8olMXhED9K41cPoXdgmYcw-CW90gdU
2025-06-17 09:41:49|INFO|orderList|shopId:
2025-06-17 09:41:49|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750124509,"data":{"ssid":22},"scopes":"role_access","exp":1750128109}
2025-06-17 09:41:49|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":22,"$freeword":null,"$orderId":null}
2025-06-17 09:41:49|INFO|getOrderList|担当者所属的店铺id:22
2025-06-17 09:41:49|SQL|[#1 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 22);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 09:41:49|SQL|[#2 - 0.12ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 09:41:49|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-06-17 09:41:49|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-06-17 09:41:49|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-06-17 09:41:49|SQL|[#3 - 3.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT max(res.id) as id,res.Order_ID,res.ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 09:41:49|INFO|getOrderList|查询结果条数:131
2025-06-17 09:41:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTI0NTA5LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxMjgxMDl9.qk4tRb70ZnP1b8olMXhED9K41cPoXdgmYcw-CW90gdU
2025-06-17 09:41:49|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750124509,"data":{"ssid":22},"scopes":"role_access","exp":1750128109}
2025-06-17 09:41:49|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 22);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-06-17 09:41:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTI0NTA5LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxMjgxMDl9.qk4tRb70ZnP1b8olMXhED9K41cPoXdgmYcw-CW90gdU
2025-06-17 09:41:49|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}}
2025-06-17 16:47:02|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"}
2025-06-17 16:47:02|SQL|[#1 - 0.67ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = 'admin') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2025-06-17 16:47:02|INFO|mt_ss login|user:{"ID":18,"category":9,"ss_name":"admin","display_name":null,"en_name":"admin","section":null,"section_id":null,"log_in":"admin","pw":"urutoraman1","manager_flag":1,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":1,"rent_a_car":1,"towing":null,"Delete_date":null,"line_openid":"C","zip":null,"address":null,"telno":null,"faxno":null}
2025-06-17 16:47:02|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150022,"data":{"ssid":18}}
2025-06-17 16:47:02|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:47:02|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:47:02|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:47:02|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMDIyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM2MjJ9.lzptixmuf2dT74dqf9u262rp3G0CaZtBsaLYU6V8lA8
2025-06-17 16:47:02|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}}
2025-06-17 16:47:02|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMDIyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM2MjJ9.lzptixmuf2dT74dqf9u262rp3G0CaZtBsaLYU6V8lA8
2025-06-17 16:47:02|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150022,"data":{"ssid":18},"scopes":"role_access","exp":1750153622}
2025-06-17 16:47:02|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-06-17 16:47:02|SQL|[#2 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(63):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (category <> ?) LIMIT 0,100; -- 9|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-06-17 16:47:02|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMDIyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM2MjJ9.lzptixmuf2dT74dqf9u262rp3G0CaZtBsaLYU6V8lA8
2025-06-17 16:47:02|INFO|orderList|shopId:
2025-06-17 16:47:02|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150022,"data":{"ssid":18},"scopes":"role_access","exp":1750153622}
2025-06-17 16:47:02|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-06-17 16:47:02|INFO|getOrderList|担当者所属的店铺id:18
2025-06-17 16:47:02|SQL|[#1 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:47:02|SQL|[#2 - 0.56ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:47:02|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-06-17 16:47:02|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-06-17 16:47:02|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-06-17 16:47:02|SQL|[#3 - 4.52ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT max(res.id) as id,res.Order_ID,res.ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:47:02|INFO|getOrderList|查询结果条数:131
2025-06-17 16:48:25|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"}
2025-06-17 16:48:25|SQL|[#1 - 0.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = 'admin') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2025-06-17 16:48:25|INFO|mt_ss login|user:{"ID":18,"category":9,"ss_name":"admin","display_name":null,"en_name":"admin","section":null,"section_id":null,"log_in":"admin","pw":"urutoraman1","manager_flag":1,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":1,"rent_a_car":1,"towing":null,"Delete_date":null,"line_openid":"C","zip":null,"address":null,"telno":null,"faxno":null}
2025-06-17 16:48:25|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150105,"data":{"ssid":18}}
2025-06-17 16:48:26|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:48:26|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:48:26|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:48:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:26|INFO|orderList|shopId:
2025-06-17 16:48:26|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150105,"data":{"ssid":18},"scopes":"role_access","exp":1750153705}
2025-06-17 16:48:26|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-06-17 16:48:26|INFO|getOrderList|担当者所属的店铺id:18
2025-06-17 16:48:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:26|SQL|[#1 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:48:26|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150105,"data":{"ssid":18},"scopes":"role_access","exp":1750153705}
2025-06-17 16:48:26|SQL|[#2 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:48:26|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-06-17 16:48:26|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-06-17 16:48:26|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-06-17 16:48:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:26|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-06-17 16:48:26|SQL|[#1 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}}
2025-06-17 16:48:26|SQL|[#2 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(63):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (category <> ?) LIMIT 0,100; -- 9|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-06-17 16:48:26|SQL|[#3 - 1.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT max(res.id) as id,res.Order_ID,res.ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:48:26|INFO|getOrderList|查询结果条数:131
2025-06-17 16:48:35|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:48:36|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:36|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:36|INFO|getOrderDetailInfo|orderId:397
2025-06-17 16:48:36|SQL|[#1 - 0.52ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-06-17 16:48:36|SQL|[#1 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '397') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:36|SQL|[#2 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1775);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:36|SQL|[#3 - 0.12ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id IS NULL) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:36|SQL|[#4 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id IS NULL) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:36|SQL|[#5 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:36|SQL|[#6 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 23) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:36|SQL|[#7 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:36|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:36|INFO|getCarPhotos|params:{"orderId":"397"}
2025-06-17 16:48:36|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:36|INFO|getOrderPdfs|params:{"orderId":"397"}
2025-06-17 16:48:36|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:36|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '22');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-06-17 16:48:49|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:48:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:49|INFO|orderList|shopId:
2025-06-17 16:48:49|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150105,"data":{"ssid":18},"scopes":"role_access","exp":1750153705}
2025-06-17 16:48:49|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-06-17 16:48:49|INFO|getOrderList|担当者所属的店铺id:18
2025-06-17 16:48:49|SQL|[#1 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:48:49|SQL|[#2 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:48:49|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-06-17 16:48:49|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-06-17 16:48:49|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-06-17 16:48:49|SQL|[#3 - 1.18ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT max(res.id) as id,res.Order_ID,res.ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:48:49|INFO|getOrderList|查询结果条数:131
2025-06-17 16:48:56|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:48:56|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:56|INFO|orderList|shopId:
2025-06-17 16:48:56|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150105,"data":{"ssid":18},"scopes":"role_access","exp":1750153705}
2025-06-17 16:48:56|INFO|orderList|params:{"serviceStatus":null,"state":"11","shopId":18,"$freeword":null,"$orderId":null}
2025-06-17 16:48:56|INFO|getOrderList|担当者所属的店铺id:18
2025-06-17 16:48:56|SQL|[#1 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:48:56|SQL|[#2 - 0.11ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:48:56|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-06-17 16:48:56|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}],"state":"11"}
2025-06-17 16:48:56|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}],"A.state":"11"}
2025-06-17 16:48:56|SQL|[#3 - 0.57ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT max(res.id) as id,res.Order_ID,res.ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22))) AND (A.state = '11');|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:48:56|INFO|getOrderList|查询结果条数:1
2025-06-17 16:48:58|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:48:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:58|INFO|getOrderDetailInfo|orderId:222
2025-06-17 16:48:58|SQL|[#1 - 0.48ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '222') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:58|SQL|[#2 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1549);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:58|INFO|getOrderPdfs|params:{"orderId":"222"}
2025-06-17 16:48:58|SQL|[#3 - 1.89ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 156) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:58|INFO|getCarPhotos|params:{"orderId":"222"}
2025-06-17 16:48:58|SQL|[#1 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-06-17 16:48:58|SQL|[#4 - 9.79ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 510) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:58|SQL|[#5 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:58|SQL|[#6 - 0.17ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 14) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:58|SQL|[#7 - 0.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:48:59|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:48:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:48:59|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-06-17 16:48:59|SQL|[#1 - 0.52ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = '11');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-06-17 16:56:55|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:56:55|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:56:55|INFO|orderList|shopId:
2025-06-17 16:56:55|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150105,"data":{"ssid":18},"scopes":"role_access","exp":1750153705}
2025-06-17 16:56:55|INFO|orderList|params:{"serviceStatus":null,"state":"11","shopId":18,"$freeword":null,"$orderId":null}
2025-06-17 16:56:55|INFO|getOrderList|担当者所属的店铺id:18
2025-06-17 16:56:55|SQL|[#1 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:56:55|SQL|[#2 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:56:55|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-06-17 16:56:55|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}],"state":"11"}
2025-06-17 16:56:55|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}],"A.state":"11"}
2025-06-17 16:56:55|SQL|[#3 - 0.91ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT max(res.id) as id,res.Order_ID,res.ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22))) AND (A.state = '11');|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:56:55|INFO|getOrderList|查询结果条数:1
2025-06-17 16:56:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:56:58|INFO|orderList|shopId:
2025-06-17 16:56:58|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150105,"data":{"ssid":18},"scopes":"role_access","exp":1750153705}
2025-06-17 16:56:58|INFO|orderList|params:{"serviceStatus":null,"state":"7","shopId":18,"$freeword":null,"$orderId":null}
2025-06-17 16:56:58|INFO|getOrderList|担当者所属的店铺id:18
2025-06-17 16:56:58|SQL|[#1 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:56:58|SQL|[#2 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:56:58|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-06-17 16:56:58|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}],"state":"7"}
2025-06-17 16:56:58|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}],"A.state":"7"}
2025-06-17 16:56:58|SQL|[#3 - 0.6ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT max(res.id) as id,res.Order_ID,res.ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22))) AND (A.state = '7');|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:56:58|INFO|getOrderList|查询结果条数:9
2025-06-17 16:56:59|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:56:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:56:59|INFO|getOrderDetailInfo|orderId:259
2025-06-17 16:56:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:56:59|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '259') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:56:59|INFO|getCarPhotos|params:{"orderId":"259"}
2025-06-17 16:56:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:56:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:56:59|INFO|getOrderPdfs|params:{"orderId":"259"}
2025-06-17 16:56:59|SQL|[#2 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 0);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:56:59|SQL|[#3 - 0.62ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 345) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:56:59|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-06-17 16:56:59|SQL|[#4 - 1.47ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 143) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:56:59|SQL|[#5 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:56:59|SQL|[#6 - 0.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 12) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:56:59|SQL|[#7 - 0.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:56:59|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:57:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:57:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:57:00|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-06-17 16:57:00|SQL|[#1 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id IS NULL);|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-06-17 16:57:05|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:57:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:57:06|INFO|orderList|shopId:
2025-06-17 16:57:06|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150105,"data":{"ssid":18},"scopes":"role_access","exp":1750153705}
2025-06-17 16:57:06|INFO|orderList|params:{"serviceStatus":null,"state":"7","shopId":18,"$freeword":null,"$orderId":null}
2025-06-17 16:57:06|INFO|getOrderList|担当者所属的店铺id:18
2025-06-17 16:57:06|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:57:06|SQL|[#2 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:57:06|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-06-17 16:57:06|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}],"state":"7"}
2025-06-17 16:57:06|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}],"A.state":"7"}
2025-06-17 16:57:06|SQL|[#3 - 0.83ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT max(res.id) as id,res.Order_ID,res.ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22))) AND (A.state = '7');|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:57:06|INFO|getOrderList|查询结果条数:9
2025-06-17 16:57:10|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:57:10|INFO|orderList|shopId:
2025-06-17 16:57:10|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150105,"data":{"ssid":18},"scopes":"role_access","exp":1750153705}
2025-06-17 16:57:10|INFO|orderList|params:{"serviceStatus":null,"state":"12","shopId":18,"$freeword":null,"$orderId":null}
2025-06-17 16:57:10|INFO|getOrderList|担当者所属的店铺id:18
2025-06-17 16:57:10|SQL|[#1 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:57:10|SQL|[#2 - 0.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:57:10|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-06-17 16:57:10|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}],"state":"12"}
2025-06-17 16:57:10|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}],"A.state":"12"}
2025-06-17 16:57:10|SQL|[#3 - 0.79ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT max(res.id) as id,res.Order_ID,res.ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22))) AND (A.state = '12');|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 16:57:10|INFO|getOrderList|查询结果条数:38
2025-06-17 16:57:14|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:57:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:57:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:57:14|INFO|getOrderPdfs|params:{"orderId":"225"}
2025-06-17 16:57:14|INFO|getCarPhotos|params:{"orderId":"225"}
2025-06-17 16:57:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:57:14|INFO|getOrderDetailInfo|orderId:225
2025-06-17 16:57:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:57:14|SQL|[#1 - 0.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '225') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:57:14|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-06-17 16:57:14|SQL|[#2 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1551);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:57:14|SQL|[#3 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 172) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:57:14|SQL|[#4 - 0.97ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 454) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:57:14|SQL|[#5 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:57:14|SQL|[#6 - 0.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 14) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:57:14|SQL|[#7 - 0.12ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 16:57:14|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 16:57:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:57:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 16:57:14|SQL|[#1 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-06-17 16:57:14|SQL|[#1 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = '12');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-06-17 17:04:27|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 17:04:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:04:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:04:27|INFO|getOrderDetailInfo|orderId:225
2025-06-17 17:04:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:04:27|INFO|getCarPhotos|params:{"orderId":"225"}
2025-06-17 17:04:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:04:27|INFO|getOrderPdfs|params:{"orderId":"225"}
2025-06-17 17:04:27|SQL|[#1 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-06-17 17:04:27|SQL|[#1 - 0.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '225') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:27|SQL|[#2 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1551);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:27|SQL|[#3 - 0.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 172) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:27|SQL|[#4 - 1.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 454) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:27|SQL|[#5 - 0.11ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:27|SQL|[#6 - 0.18ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 14) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:27|SQL|[#7 - 0.14ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:28|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 17:04:28|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:04:28|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:04:28|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-06-17 17:04:28|SQL|[#1 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = '12');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-06-17 17:04:35|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 17:04:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:04:35|INFO|getOrderDetailInfo|orderId:225
2025-06-17 17:04:35|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '225') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:04:35|SQL|[#2 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1551);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:35|INFO|getCarPhotos|params:{"orderId":"225"}
2025-06-17 17:04:35|SQL|[#3 - 0.52ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 172) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:04:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:04:35|INFO|getOrderPdfs|params:{"orderId":"225"}
2025-06-17 17:04:35|SQL|[#1 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-06-17 17:04:35|SQL|[#4 - 1.67ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 454) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:35|SQL|[#5 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:35|SQL|[#6 - 0.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 14) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:35|SQL|[#7 - 0.12ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:04:35|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 17:04:36|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:04:36|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:04:36|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-06-17 17:04:36|SQL|[#1 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = '12');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-06-17 17:06:12|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 17:06:12|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:06:12|INFO|getOrderDetailInfo|orderId:225
2025-06-17 17:06:12|SQL|[#1 - 0.46ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '225') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:12|SQL|[#2 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1551);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:12|SQL|[#3 - 0.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 172) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:12|SQL|[#4 - 1.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 454) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:12|SQL|[#5 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:12|SQL|[#6 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 14) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:12|SQL|[#7 - 0.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:12|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:06:12|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:06:12|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:06:12|INFO|getOrderPdfs|params:{"orderId":"225"}
2025-06-17 17:06:12|INFO|getCarPhotos|params:{"orderId":"225"}
2025-06-17 17:06:12|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-06-17 17:06:13|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 17:06:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:06:13|SQL|[#1 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-06-17 17:06:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:06:13|SQL|[#1 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = '12');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-06-17 17:06:47|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 17:06:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:06:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:06:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:06:47|INFO|getOrderDetailInfo|orderId:225
2025-06-17 17:06:47|INFO|getOrderPdfs|params:{"orderId":"225"}
2025-06-17 17:06:47|INFO|getCarPhotos|params:{"orderId":"225"}
2025-06-17 17:06:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:06:47|SQL|[#1 - 0.47ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '225') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:47|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-06-17 17:06:47|SQL|[#2 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1551);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:47|SQL|[#3 - 0.47ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 172) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:47|SQL|[#4 - 1.83ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 454) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:47|SQL|[#5 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:47|SQL|[#6 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 14) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:47|SQL|[#7 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-06-17 17:06:47|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 17:06:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:06:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:06:48|SQL|[#1 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = '12');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-06-17 17:06:48|SQL|[#1 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-06-17 17:07:00|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 17:07:00|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 17:07:00|INFO|JwtAuthorizationFilter check|authorization:
2025-06-17 17:07:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:07:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:07:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUwMTUwMTA1LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTAxNTM3MDV9.GQrxXKQG214nFbOp3LWgnaRymcQnAkVRlhULreQ659w
2025-06-17 17:07:00|INFO|orderList|shopId:
2025-06-17 17:07:00|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150105,"data":{"ssid":18},"scopes":"role_access","exp":1750153705}
2025-06-17 17:07:00|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1750150105,"data":{"ssid":18},"scopes":"role_access","exp":1750153705}
2025-06-17 17:07:00|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-06-17 17:07:00|INFO|getOrderList|担当者所属的店铺id:18
2025-06-17 17:07:00|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}}
2025-06-17 17:07:00|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-06-17 17:07:00|SQL|[#1 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 17:07:00|SQL|[#2 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 17:07:00|SQL|[#2 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(63):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (category <> ?) LIMIT 0,100; -- 9|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-06-17 17:07:00|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-06-17 17:07:00|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-06-17 17:07:00|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-06-17 17:07:00|SQL|[#3 - 1.01ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT max(res.id) as id,res.Order_ID,res.ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-06-17 17:07:00|INFO|getOrderList|查询结果条数:131