2025-08-27 13:36:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MTEyNDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYxMTYwNzF9.VMQQCbVrt8MJkPW6NU33ZKXdN3VUrH500_9xNOkMvVc 2025-08-27 13:36:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MTEyNDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYxMTYwNzF9.VMQQCbVrt8MJkPW6NU33ZKXdN3VUrH500_9xNOkMvVc 2025-08-27 13:36:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MTEyNDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYxMTYwNzF9.VMQQCbVrt8MJkPW6NU33ZKXdN3VUrH500_9xNOkMvVc 2025-08-27 13:36:44|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"} 2025-08-27 13:36:44|SQL|[#1 - 0.39ms - 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-08-27 13:36:44|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-08-27 13:36:44|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273004,"data":{"ssid":18}} 2025-08-27 13:36:44|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:36:44|INFO|orderList|shopId: 2025-08-27 13:36:44|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273004,"data":{"ssid":18},"scopes":"role_access","exp":1756276604} 2025-08-27 13:36:44|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null} 2025-08-27 13:36:44|INFO|getOrderList|担当者所属的店铺id:18 2025-08-27 13:36:44|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(169): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}} 2025-08-27 13:36:44|SQL|[#2 - 0.19ms - 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-08-27 13:36:44|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-08-27 13:36:44|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-08-27 13:36:44|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-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-08-27 13:36:44|SQL|[#3 - 1.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(214): 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 res.Order_ID,max(res.ss_storage_date) as 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, -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-08-27 13:36:44|INFO|getOrderList|查询结果条数:131 2025-08-27 13:37:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:37:00|INFO|getOrderDetailInfo|orderId:408 2025-08-27 13:37:00|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 = '408') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:00|SQL|[#2 - 0.37ms - 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 = 1785);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:00|SQL|[#3 - 0.2ms - 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-08-27 13:37:00|SQL|[#4 - 0.24ms - 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-08-27 13:37:00|SQL|[#5 - 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.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:00|SQL|[#6 - 0.27ms - 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-08-27 13:37:00|SQL|[#7 - 0.27ms - 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-08-27 13:37:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:37:00|INFO|getCarPhotos|params:{"orderId":"408"} 2025-08-27 13:37:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:37:00|INFO|getOrderPdfs|params:{"orderId":"408"} 2025-08-27 13:37:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:37:00|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-08-27 13:37:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:37:00|SQL|[#1 - 7.29ms - 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 = '18');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2025-08-27 13:37:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:37:06|INFO|orderList|shopId: 2025-08-27 13:37:06|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273004,"data":{"ssid":18},"scopes":"role_access","exp":1756276604} 2025-08-27 13:37:06|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null} 2025-08-27 13:37:06|INFO|getOrderList|担当者所属的店铺id:18 2025-08-27 13:37:06|SQL|[#1 - 0.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(169): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}} 2025-08-27 13:37:06|SQL|[#2 - 0.25ms - 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-08-27 13:37: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-08-27 13:37: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}]} 2025-08-27 13:37:06|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-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-08-27 13:37:06|SQL|[#3 - 1.68ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(214): 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 res.Order_ID,max(res.ss_storage_date) as 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, -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-08-27 13:37:06|INFO|getOrderList|查询结果条数:131 2025-08-27 13:37:12|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:37:12|INFO|getOrderDetailInfo|orderId:250 2025-08-27 13:37:13|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 = '250') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:13|SQL|[#2 - 0.36ms - 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 = 1574);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:13|SQL|[#3 - 0.68ms - 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 = 308) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:13|SQL|[#4 - 1.9ms - 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 = 92) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:13|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-08-27 13:37:13|SQL|[#6 - 0.22ms - 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 = 20) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:13|SQL|[#7 - 0.21ms - 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-08-27 13:37:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:37:13|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-08-27 13:37:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:37:13|INFO|getOrderPdfs|params:{"orderId":"250"} 2025-08-27 13:37:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:37:13|INFO|getCarPhotos|params:{"orderId":"250"} 2025-08-27 13:37:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:37:13|SQL|[#1 - 0.34ms - 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-08-27 13:37:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDA0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2MDR9.UgqAFqWrHHf1n4JWlD_7byzIDw3HZMwB790_hpI6-FM 2025-08-27 13:37:14|INFO|updateToken|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273004,"data":{"ssid":18},"scopes":"role_access","exp":1756276604} 2025-08-27 13:37:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:14|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtCustomerBasicFee.php(17): App\Model\Repair\MtCustomerBasicFee::findBasicFeeByOrderId() u433670985_test.mt_customer_basic_fee SELECT cbf.* FROM dat_syaken_order_list ord \n LEFT JOIN dat_customer cust on ord.Customer_ID = cust.base_customerID\n LEFT JOIN mt_customer_basic_fee cbf on cust.basic_fee_id = cbf.id\n where ord.Order_ID = ? ; -- '250'|{"request":{"service":"App.OrderDetail_OrderDetail.getCustomerBasicFee"}} 2025-08-27 13:37:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:14|SQL|[#1 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtRepairItem.php(18): PhalApi\Model\DataModel::getList() u433670985_test.mt_repair_item SELECT * FROM mt_repair_item LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}} 2025-08-27 13:37:14|SQL|[#2 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(209): PhalApi\Model\DataModel::getList() u433670985_test.mt_repair_classification SELECT * FROM mt_repair_classification LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}} 2025-08-27 13:37:14|SQL|[#3 - 0.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(213): PhalApi\Model\DataModel::getList() u433670985_test.mt_repair_remarks SELECT * FROM mt_repair_remarks LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}} 2025-08-27 13:37:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:14|SQL|[#1 - 0.24ms - 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 = '250') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}} 2025-08-27 13:37:14|SQL|[#2 - 0.93ms - 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 = 92) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}} 2025-08-27 13:37:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:14|SQL|[#1 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(298): PhalApi\Model\DataModel::getList() u433670985_test.mt_tax SELECT * FROM mt_tax LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getTax"}} 2025-08-27 13:37:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:14|INFO|getOrderDetailInfo|orderId:250 2025-08-27 13:37:14|SQL|[#1 - 0.31ms - 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 = '250') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37: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 = 1574);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:14|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 = 308) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:14|SQL|[#4 - 0.99ms - 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 = 92) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:14|SQL|[#5 - 0.18ms - 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-08-27 13:37:14|SQL|[#6 - 0.23ms - 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 = 20) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:14|SQL|[#7 - 0.17ms - 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-08-27 13:37:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:14|SQL|[#1 - 0.34ms - 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 = '250') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:14|SQL|[#2 - 0.41ms - 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 * FROM dat_cars WHERE (CarID = 1574);|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:14|SQL|[#3 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Order/Order.php(2385): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 1);|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:14|SQL|[#4 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = 20) LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:14|SQL|[#5 - 0.63ms - 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 = 308) LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:14|SQL|[#6 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/MtMiscellaneousExpensesItem.php(11): PhalApi\Model\DataModel::getList() u433670985_test.mt_miscellaneous_expenses_item SELECT * FROM mt_miscellaneous_expenses_item LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:14|INFO|doSaveBudget|Start handler miscellaneousExpensesDetailList 2025-08-27 13:37:14|INFO|doSaveBudget|End handler miscellaneousExpensesDetailList 2025-08-27 13:37:14|SQL|[#7 - 1.63ms - 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 = 92) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:14|SQL|[#8 - 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 IS NULL);|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:14|SQL|[#9 - 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.Order_Order.getBudgetData"}} 2025-08-27 13:37:14|SQL|[#10 - 0.21ms - 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 = '250') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:14|INFO|doSaveBudget|Start handler repairEstimateDetailList 2025-08-27 13:37:14|INFO|doSaveBudget|End handler repairEstimateDetailList 2025-08-27 13:37:14|INFO|doSaveBudget|Start handler discounts 2025-08-27 13:37:14|INFO|doSaveBudget|End handler discounts 2025-08-27 13:37:14|INFO|doSaveBudget|Start handler depositWithdrawalRecords 2025-08-27 13:37:14|INFO|doSaveBudget|End handler depositWithdrawalRecords 2025-08-27 13:37:14|INFO|doSaveBudget|final data: {"cost1":0,"cost2":0,"cost3":0,"cost4":0,"weightPrice":0,"carTaxPrice":0,"insurancePrice":0,"paperPrice":0,"servicePrice":0,"checkPrice":0,"maintenancePrice":0,"partsPrice":0,"repairPrice":0,"securityPrice":0,"otherPrices":0,"discountPrice":0,"payed":0,"priceTotal":0,"total":0,"toPayTotal":0,"tax":0} 2025-08-27 13:37:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:14|SQL|[#1 - 0.25ms - 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 = '250') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}} 2025-08-27 13:37:14|SQL|[#2 - 0.31ms - 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 * FROM dat_cars WHERE (CarID = 1574);|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}} 2025-08-27 13:37:14|SQL|[#3 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(30): App\Model\Repair\DatRepairEstimateDetail::getListV1() u433670985_test.dat_repair_estimate_detail SELECT * FROM dat_repair_estimate_detail WHERE (katashiki = 'DBA-K13') AND (NOT repair_item = ?) LIMIT 0,20; -- 'メモ'|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}} 2025-08-27 13:37:14|SQL|[#4 - 2.04ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(41): App\Model\Repair\DatRepairEstimateDetail::totalByKatashikiAndKeyWord() u433670985_test.dat_repair_estimate_detail SELECT COUNT(id) FROM dat_repair_estimate_detail WHERE (katashiki = 'DBA-K13') AND (NOT repair_item = ?); -- 'メモ'|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}} 2025-08-27 13:37:21|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:21|SQL|[#1 - 0.29ms - 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 = '250') LIMIT 1;|{"request":{"service":"App.Order_Order.checkReserveState"}} 2025-08-27 13:37:21|SQL|[#2 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(125): App\Model\Repair\DatCarsStorageReservation::getStorageDateByOrderId() u433670985_test.dat_cars_storage_reservation SELECT * FROM dat_cars_storage_reservation WHERE (Order_ID = '250') LIMIT 1;|{"request":{"service":"App.Order_Order.checkReserveState"}} 2025-08-27 13:37:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:26|INFO|updateToken|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273034,"data":{"ssid":18},"scopes":"role_access","exp":1787377034} 2025-08-27 13:37:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:26|INFO|getCarPhotos|params:{"orderId":"250"} 2025-08-27 13:37:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:26|INFO|getOrderDetailInfo|orderId:250 2025-08-27 13:37:26|SQL|[#1 - 0.34ms - 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 = '250') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:26|SQL|[#2 - 0.36ms - 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 = 1574);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:26|SQL|[#3 - 0.45ms - 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 = 308) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:26|SQL|[#4 - 0.98ms - 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 = 92) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:26|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-08-27 13:37:26|SQL|[#6 - 0.22ms - 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 = 20) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:26|SQL|[#7 - 0.2ms - 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-08-27 13:37:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:26|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-08-27 13:37:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDM0LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwMzR9.hnoLgMlr8w9lECNGeUV8DjWq1clsirKS61wHXeTsll8 2025-08-27 13:37:26|INFO|getOrderPdfs|params:{"orderId":"250"} 2025-08-27 13:37:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:27|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 = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2025-08-27 13:37:28|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:28|INFO|orderList|shopId: 2025-08-27 13:37:28|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273046,"data":{"ssid":18},"scopes":"role_access","exp":1756276646} 2025-08-27 13:37:28|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null} 2025-08-27 13:37:28|INFO|getOrderList|担当者所属的店铺id:18 2025-08-27 13:37:28|SQL|[#1 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(169): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}} 2025-08-27 13:37:28|SQL|[#2 - 0.26ms - 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-08-27 13:37:28|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-08-27 13:37:28|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-08-27 13:37:28|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-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-08-27 13:37:28|SQL|[#3 - 1.84ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(214): 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 res.Order_ID,max(res.ss_storage_date) as 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, -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-08-27 13:37:28|INFO|getOrderList|查询结果条数:131 2025-08-27 13:37:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:38|INFO|getOrderDetailInfo|orderId:354 2025-08-27 13:37:38|SQL|[#1 - 0.29ms - 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 = '354') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:38|SQL|[#2 - 0.24ms - 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 = 1734);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:38|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-08-27 13:37:38|SQL|[#4 - 0.13ms - 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-08-27 13:37:38|SQL|[#5 - 0.12ms - 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-08-27 13:37:38|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 = 94) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:38|SQL|[#7 - 0.13ms - 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-08-27 13:37:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:38|INFO|getCarPhotos|params:{"orderId":"354"} 2025-08-27 13:37:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:38|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-08-27 13:37:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:38|INFO|getOrderPdfs|params:{"orderId":"354"} 2025-08-27 13:37:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:38|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 = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2025-08-27 13:37:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:41|INFO|orderList|shopId: 2025-08-27 13:37:41|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273046,"data":{"ssid":18},"scopes":"role_access","exp":1756276646} 2025-08-27 13:37:41|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null} 2025-08-27 13:37:41|INFO|getOrderList|担当者所属的店铺id:18 2025-08-27 13:37:41|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(169): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}} 2025-08-27 13:37:41|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-08-27 13:37:41|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-08-27 13:37:41|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-08-27 13:37:41|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-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-08-27 13:37:41|SQL|[#3 - 1.01ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(214): 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 res.Order_ID,max(res.ss_storage_date) as 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, -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-08-27 13:37:41|INFO|getOrderList|查询结果条数:131 2025-08-27 13:37:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:49|INFO|getOrderDetailInfo|orderId:382 2025-08-27 13:37:49|SQL|[#1 - 0.28ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:49|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 = 1761);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:49|SQL|[#3 - 0.46ms - 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 = 478) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:49|SQL|[#4 - 1.15ms - 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 = 452) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:49|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-08-27 13:37:49|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 = 102) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:49|SQL|[#7 - 0.23ms - 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-08-27 13:37:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:49|INFO|getOrderPdfs|params:{"orderId":"382"} 2025-08-27 13:37:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:49|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-08-27 13:37:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:49|INFO|getCarPhotos|params:{"orderId":"382"} 2025-08-27 13:37:49|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:49|SQL|[#1 - 0.34ms - 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 = '10');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2025-08-27 13:37:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDQ2LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzY2NDZ9.uv2Cvx0-h0Of2xjPLq--TdCUMUHW2BOwk5gfAtAzenc 2025-08-27 13:37:51|INFO|updateToken|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273046,"data":{"ssid":18},"scopes":"role_access","exp":1756276646} 2025-08-27 13:37:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:37:51|SQL|[#1 - 0.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtCustomerBasicFee.php(17): App\Model\Repair\MtCustomerBasicFee::findBasicFeeByOrderId() u433670985_test.mt_customer_basic_fee SELECT cbf.* FROM dat_syaken_order_list ord \n LEFT JOIN dat_customer cust on ord.Customer_ID = cust.base_customerID\n LEFT JOIN mt_customer_basic_fee cbf on cust.basic_fee_id = cbf.id\n where ord.Order_ID = ? ; -- '382'|{"request":{"service":"App.OrderDetail_OrderDetail.getCustomerBasicFee"}} 2025-08-27 13:37:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:37:51|SQL|[#1 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(298): PhalApi\Model\DataModel::getList() u433670985_test.mt_tax SELECT * FROM mt_tax LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getTax"}} 2025-08-27 13:37:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:37:51|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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}} 2025-08-27 13:37:51|SQL|[#2 - 1.69ms - 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 = 452) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}} 2025-08-27 13:37:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:37:51|SQL|[#1 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtRepairItem.php(18): PhalApi\Model\DataModel::getList() u433670985_test.mt_repair_item SELECT * FROM mt_repair_item LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}} 2025-08-27 13:37:51|SQL|[#2 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(209): PhalApi\Model\DataModel::getList() u433670985_test.mt_repair_classification SELECT * FROM mt_repair_classification LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}} 2025-08-27 13:37:51|SQL|[#3 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(213): PhalApi\Model\DataModel::getList() u433670985_test.mt_repair_remarks SELECT * FROM mt_repair_remarks LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}} 2025-08-27 13:37:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:37:51|SQL|[#1 - 0.4ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:51|SQL|[#2 - 0.4ms - 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 * FROM dat_cars WHERE (CarID = 1761);|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:51|SQL|[#3 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Order/Order.php(2385): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 10);|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:51|SQL|[#4 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = 102) LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:51|SQL|[#5 - 0.43ms - 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 = 478) LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:51|SQL|[#6 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/MtMiscellaneousExpensesItem.php(11): PhalApi\Model\DataModel::getList() u433670985_test.mt_miscellaneous_expenses_item SELECT * FROM mt_miscellaneous_expenses_item LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:51|INFO|doSaveBudget|Start handler miscellaneousExpensesDetailList 2025-08-27 13:37:51|INFO|doSaveBudget|End handler miscellaneousExpensesDetailList 2025-08-27 13:37:51|SQL|[#7 - 0.96ms - 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 = 452) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:51|SQL|[#8 - 0.18ms - 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.Order_Order.getBudgetData"}} 2025-08-27 13:37:51|SQL|[#9 - 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.Order_Order.getBudgetData"}} 2025-08-27 13:37:51|SQL|[#10 - 0.28ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:51|INFO|MtRepairUnitPrice|where:{"(repair_item, classification, category, category_detail)":[{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u70b9\u691c","category":"\u6cd5\u5b9a\u70b9\u691c","category_detail":"\u6cd5\u5b9a24\u30f6\u6708\u70b9\u691c\u6599"},{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u6e2c\u5b9a","category":"\u4fdd\u5b89\u691c\u67fb","category_detail":"\u4fdd\u5b89\u78ba\u8a8d\u691c\u67fb\u6599"}]} 2025-08-27 13:37:51|SQL|[#11 - 0.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtRepairUnitPrice.php(32): App\Model\Repair\MtRepairUnitPrice::fetchList() u433670985_test.mt_repair_unit_price SELECT * FROM mt_repair_unit_price WHERE ((repair_item, classification, category, category_detail) IN (('基本料金', '点検', '法定点検', '法定24ヶ月点検料'), ('基本料金', '測定', '保安検査', '保安確認検査料')));|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:37:51|INFO|doSaveBudget|Start handler repairEstimateDetailList 2025-08-27 13:37:51|INFO|doSaveBudget|End handler repairEstimateDetailList 2025-08-27 13:37:51|INFO|doSaveBudget|Start handler discounts 2025-08-27 13:37:51|INFO|doSaveBudget|End handler discounts 2025-08-27 13:37:51|INFO|doSaveBudget|Start handler depositWithdrawalRecords 2025-08-27 13:37:51|INFO|doSaveBudget|End handler depositWithdrawalRecords 2025-08-27 13:37:51|INFO|doSaveBudget|final data: {"cost1":0,"cost2":0,"cost3":0,"cost4":0,"weightPrice":0,"carTaxPrice":0,"insurancePrice":0,"paperPrice":0,"servicePrice":16500,"checkPrice":9800,"maintenancePrice":0,"partsPrice":0,"repairPrice":0,"securityPrice":0,"otherPrices":0,"discountPrice":0,"payed":0,"priceTotal":26300,"total":26300,"toPayTotal":-26300,"tax":2391} 2025-08-27 13:37:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:37:51|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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}} 2025-08-27 13:37:51|SQL|[#2 - 0.53ms - 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 * FROM dat_cars WHERE (CarID = 1761);|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}} 2025-08-27 13:37:51|SQL|[#3 - 0.63ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(30): App\Model\Repair\DatRepairEstimateDetail::getListV1() u433670985_test.dat_repair_estimate_detail SELECT * FROM dat_repair_estimate_detail WHERE (katashiki = 'DBA-K13') AND (NOT repair_item = ?) LIMIT 0,20; -- 'メモ'|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}} 2025-08-27 13:37:51|SQL|[#4 - 1.81ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(41): App\Model\Repair\DatRepairEstimateDetail::totalByKatashikiAndKeyWord() u433670985_test.dat_repair_estimate_detail SELECT COUNT(id) FROM dat_repair_estimate_detail WHERE (katashiki = 'DBA-K13') AND (NOT repair_item = ?); -- 'メモ'|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}} 2025-08-27 13:37:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:37:51|INFO|getOrderDetailInfo|orderId:382 2025-08-27 13:37:51|SQL|[#1 - 0.28ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:51|SQL|[#2 - 0.24ms - 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 = 1761);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:51|SQL|[#3 - 0.38ms - 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 = 478) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:51|SQL|[#4 - 1.03ms - 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 = 452) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:51|SQL|[#5 - 0.15ms - 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-08-27 13:37:51|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 = 102) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:37:51|SQL|[#7 - 0.16ms - 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-08-27 13:37:54|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:37:55|SQL|[#1 - 0.34ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.Order_Order.checkReserveState"}} 2025-08-27 13:37:55|SQL|[#2 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(125): App\Model\Repair\DatCarsStorageReservation::getStorageDateByOrderId() u433670985_test.dat_cars_storage_reservation SELECT * FROM dat_cars_storage_reservation WHERE (Order_ID = '382') LIMIT 1;|{"request":{"service":"App.Order_Order.checkReserveState"}} 2025-08-27 13:37:55|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:37:55|SQL|[#1 - 0.35ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.doOrderCompleteNotify"}} 2025-08-27 13:37:55|SQL|[#2 - 0.35ms - 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 = 1761);|{"request":{"service":"App.OrderDetail_OrderDetail.doOrderCompleteNotify"}} 2025-08-27 13:37:55|SQL|[#3 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/OrderDetail/OrderDetail.php(293): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 10);|{"request":{"service":"App.OrderDetail_OrderDetail.doOrderCompleteNotify"}} 2025-08-27 13:37:55|SQL|[#4 - 0.26ms - 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.OrderDetail_OrderDetail.doOrderCompleteNotify"}} 2025-08-27 13:37:55|SQL|[#5 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineUser.php(68): App\Model\Line\DatLineUser::getLineUserIdBySsid() u433670985_test.dat_line_user SELECT c.userId from dat_line_user c \n where c.ssid = ? or c.ssid = ?; -- 10, 22|{"request":{"service":"App.OrderDetail_OrderDetail.doOrderCompleteNotify"}} 2025-08-27 13:37:55|SQL|[#6 - 1.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(26): PhalApi\Model\DataModel::insert() u433670985_test.dat_line_msg INSERT INTO dat_line_msg (`message`, `to_openid`, `Order_ID`) VALUES ('🚗整備依頼を受け付けました。（魚津、ベンツ１２３４３４５６７７８８８０９０９８７６５４３２２、富山531ね729）', 'U426b11482f563780d87d53b7b1f4fb2f,U691e9035dd6d9966a633ee9202cb3ac1,Uca06f5a1b8b52c5debf2a8e679977ac5', '382');|{"request":{"service":"App.OrderDetail_OrderDetail.doOrderCompleteNotify"}} 2025-08-27 13:47:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:47:00|SQL|[#1 - 0.42ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.doEstimateCompleteNotify"}} 2025-08-27 13:47:00|INFO|doEstimateCompleteNotify|orderInfo:{"Order_ID":382,"Customer_ID":102,"Car_ID":1761,"Shop_ID":10,"staff":null,"Enquite_Date":null,"Tenken_Date":null,"Mitsumori_Date":null,"Arrival_Date":"2025-03-24 18:08:00","Complete_Date":null,"Delivary_Date":null,"Void_reason":null,"contact_id":null,"check_state":1,"service":2,"state":6,"remark":null,"questionnaire_answer_id":158,"general_order_id":null,"vehicle_inspection_quote_answer_id":null,"car_photo":null,"reason":null,"miscellaneous_expenses_id":478,"repair_estimate_id":452,"deposit_withdrawal_record_id":null,"discount_record_id":null,"deposit_withdrawal_total":"-26300.00","extra_discount":null,"new_flag":0,"cancel_flag":0,"recept_date":"2025-03-24 18:04:00","reply_date":"2025-03-24 18:07:00","mc_stock_date":null,"settle_date":null,"ss_return_date":null,"delivered_date":null,"syaken_send_date":null} 2025-08-27 13:47:00|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 = 1761);|{"request":{"service":"App.OrderDetail_OrderDetail.doEstimateCompleteNotify"}} 2025-08-27 13:47:00|INFO|doEstimateCompleteNotify|carInfo:{"carId":1761,"customerId":102,"number":"\u5bcc\u5c71531\u306d729","make":null,"vin":"K13-381017","syodoDate":"2015-07-01","katashiki":"DBA-K13","katashikiShitei":16470,"ruibetsu":18,"gendouki":"HR12","drive":"2WD","nenryou":1,"syaken":"2007-06-07","millage":955,"year":"2015(H27)","carName":"\u30d9\u30f3\u30c4\uff11\uff12\uff13\uff14\uff13\uff14\uff15\uff16\uff17\uff17\uff18\uff18\uff18\uff10\uff19\uff10\uff19\uff18\uff17\uff16\uff15\uff14\uff13\uff12\uff12","grade":null,"color":null,"lastModifyDate":"2025-05-21 04:16:20","Inspection_Date":"2025-03-24","delivaryDate":"2025-03-30","keijyou":"H","jyuuryou":1,"syoyuusyaName":"H","syoyuusyaAddress":"J","shiyousyaName":"J","shiyousyaAddress":"N","ex_shiyousya_name":"J","ex_shiyousya_address":"N","Registry_Name":"H","Registry_Address":"J"} 2025-08-27 13:47:00|SQL|[#3 - 0.25ms - 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.OrderDetail_OrderDetail.doEstimateCompleteNotify"}} 2025-08-27 13:47:00|SQL|[#4 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineUser.php(68): App\Model\Line\DatLineUser::getLineUserIdBySsid() u433670985_test.dat_line_user SELECT c.userId from dat_line_user c \n where c.ssid = ? or c.ssid = ?; -- 10, NULL|{"request":{"service":"App.OrderDetail_OrderDetail.doEstimateCompleteNotify"}} 2025-08-27 13:47:00|SQL|[#5 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = 102) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.doEstimateCompleteNotify"}} 2025-08-27 13:47:00|SQL|[#6 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(26): PhalApi\Model\DataModel::insert() u433670985_test.dat_line_msg INSERT INTO dat_line_msg (`message`, `to_openid`, `Order_ID`) VALUES ('🚗メカニックセンターからの見積完了連絡：（鈴木七瀬、ベンツ１２３４３４５６７７８８８０９０９８７６５４３２２、富山531ね729）', 'Uca06f5a1b8b52c5debf2a8e679977ac5', '382');|{"request":{"service":"App.OrderDetail_OrderDetail.doEstimateCompleteNotify"}} 2025-08-27 13:47:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:47:08|INFO|getOrderDetailInfo|orderId:382 2025-08-27 13:47:08|SQL|[#1 - 0.28ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:08|SQL|[#2 - 0.27ms - 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 = 1761);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:08|SQL|[#3 - 0.49ms - 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 = 478) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:08|SQL|[#4 - 1.27ms - 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 = 452) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:08|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-08-27 13:47:08|SQL|[#6 - 0.23ms - 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 = 102) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:08|SQL|[#7 - 0.2ms - 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-08-27 13:47:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:47:08|INFO|updateToken|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273071,"data":{"ssid":18},"scopes":"role_access","exp":1787377071} 2025-08-27 13:47:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:47:08|INFO|getOrderPdfs|params:{"orderId":"382"} 2025-08-27 13:47:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:47:08|INFO|getCarPhotos|params:{"orderId":"382"} 2025-08-27 13:47:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:47:08|SQL|[#1 - 0.23ms - 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-08-27 13:47:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczMDcxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzcwNzF9.7A2bAOnY0GY_jnCbRsCPCMosLJhs6JzME_ozMNauT3E 2025-08-27 13:47:08|SQL|[#1 - 0.26ms - 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 = '10');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2025-08-27 13:47:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjI4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzcyMjh9.5mFtxJpoFyxQAjsf18IoQmdhAaC1VuxiU7VIqEj-GaM 2025-08-27 13:47:11|INFO|getOrderDetailInfo|orderId:382 2025-08-27 13:47:11|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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:11|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 = 1761);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:11|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 = 478) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:11|SQL|[#4 - 0.99ms - 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 = 452) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:11|SQL|[#5 - 0.17ms - 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-08-27 13:47:11|SQL|[#6 - 0.21ms - 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 = 102) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:11|SQL|[#7 - 0.17ms - 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-08-27 13:47:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjI4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzcyMjh9.5mFtxJpoFyxQAjsf18IoQmdhAaC1VuxiU7VIqEj-GaM 2025-08-27 13:47:11|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 = '10');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2025-08-27 13:47:45|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjI4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzcyMjh9.5mFtxJpoFyxQAjsf18IoQmdhAaC1VuxiU7VIqEj-GaM 2025-08-27 13:47:45|SQL|[#1 - 0.4ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.Order_Order.doUpdateCarInfo"}} 2025-08-27 13:47:45|SQL|[#2 - 0.21ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.Order_Order.doUpdateCarInfo"}} 2025-08-27 13:47:45|SQL|[#3 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Order/Order.php(636): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 10);|{"request":{"service":"App.Order_Order.doUpdateCarInfo"}} 2025-08-27 13:47:45|INFO|uploadData|update dat_cars data:{"car_Name":"","ex_shiyousya_name":"J","ex_shiyousya_address":"N","Registry_Name":"H","Registry_Address":"J","number":"\u5bcc\u5c71585\u306d8358","vin":"K13-381017","syodo_Date":"2015-07-01","katashiki":"DBA-K13","katashiki_Shitei":16470,"ruibetsu":18,"gendouki":"HR12","drive":"2WD","nenryou":1,"syaken":"2007-06-07","millage":955,"year":"2015(H27)","grade":null,"make":null,"customer_ID":102} 2025-08-27 13:47:45|SQL|[#4 - 0.18ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = 102) LIMIT 1;|{"request":{"service":"App.Order_Order.doUpdateCarInfo"}} 2025-08-27 13:47:45|SQL|[#5 - 0.18ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(58): App\Model\Customer\DatCustomer::updateCustomer() u433670985_test.dat_customer UPDATE dat_customer SET `base_customerID` = 102, `Customer_ID` = NULL, `shop_id` = '10', `customer_name` = '七瀬', `customer_name_kensaku` = 'ナナセ', `ZIP_Code` = 9370014, `customer_address` = '富山県魚津市青柳', `Customer_address_2` = '1-1-1302', `customer_telnumber` = '08096585487', `customer_cellnumber` = NULL, `remarks` = NULL, `do_not_access` = NULL, `last_modify_staff` = NULL, `create_date` = NULL, `last_modify_date` = NULL, `delete_date` = NULL, `name` = '鈴木', `kensaku` = 'スズキ', `contact_address` = NULL, `basic_fee_id` = 1 WHERE (base_customerID = 102);|{"request":{"service":"App.Order_Order.doUpdateCarInfo"}} 2025-08-27 13:47:45|SQL|[#6 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(66): App\Model\Cars\DatCars::get() u433670985_test.dat_cars SELECT * FROM dat_cars WHERE (CarID = 1761);|{"request":{"service":"App.Order_Order.doUpdateCarInfo"}} 2025-08-27 13:47:45|SQL|[#7 - 1.98ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(92): App\Model\Cars\DatCars::updateCarsInfo() u433670985_test.dat_cars UPDATE dat_cars SET `car_Name` = '', `ex_shiyousya_name` = 'J', `ex_shiyousya_address` = 'N', `Registry_Name` = 'H', `Registry_Address` = 'J', `number` = '富山585ね8358', `vin` = 'K13-381017', `syodo_Date` = '2015-07-01', `katashiki` = 'DBA-K13', `katashiki_Shitei` = 16470, `ruibetsu` = 18, `gendouki` = 'HR12', `drive` = '2WD', `nenryou` = 1, `syaken` = '2007-06-07', `millage` = 955, `year` = '2015(H27)', `grade` = NULL, `make` = NULL, `customer_ID` = 102 WHERE (CarID = 1761);|{"request":{"service":"App.Order_Order.doUpdateCarInfo"}} 2025-08-27 13:47:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjI4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzcyMjh9.5mFtxJpoFyxQAjsf18IoQmdhAaC1VuxiU7VIqEj-GaM 2025-08-27 13:47:48|INFO|getOrderPdfs|params:{"orderId":"382"} 2025-08-27 13:47:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjI4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzcyMjh9.5mFtxJpoFyxQAjsf18IoQmdhAaC1VuxiU7VIqEj-GaM 2025-08-27 13:47:48|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-08-27 13:47:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjI4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzcyMjh9.5mFtxJpoFyxQAjsf18IoQmdhAaC1VuxiU7VIqEj-GaM 2025-08-27 13:47:48|INFO|getCarPhotos|params:{"orderId":"382"} 2025-08-27 13:47:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjI4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzcyMjh9.5mFtxJpoFyxQAjsf18IoQmdhAaC1VuxiU7VIqEj-GaM 2025-08-27 13:47:48|INFO|getOrderDetailInfo|orderId:382 2025-08-27 13:47:48|SQL|[#1 - 0.24ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:48|SQL|[#2 - 0.2ms - 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 = 1761);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:48|SQL|[#3 - 0.4ms - 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 = 478) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:48|SQL|[#4 - 0.99ms - 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 = 452) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:48|SQL|[#5 - 0.12ms - 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-08-27 13:47:48|SQL|[#6 - 0.16ms - 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 = 102) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:48|SQL|[#7 - 0.13ms - 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-08-27 13:47:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjI4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzcyMjh9.5mFtxJpoFyxQAjsf18IoQmdhAaC1VuxiU7VIqEj-GaM 2025-08-27 13:47:48|SQL|[#1 - 0.27ms - 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 = '10');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2025-08-27 13:47:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjI4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzcyMjh9.5mFtxJpoFyxQAjsf18IoQmdhAaC1VuxiU7VIqEj-GaM 2025-08-27 13:47:48|SQL|[#1 - 0.18ms - 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-08-27 13:47:50|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjI4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzcyMjh9.5mFtxJpoFyxQAjsf18IoQmdhAaC1VuxiU7VIqEj-GaM 2025-08-27 13:47:50|INFO|updateToken|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273628,"data":{"ssid":18},"scopes":"role_access","exp":1756277228} 2025-08-27 13:47:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjcwLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzc2NzB9.us_qCFsiH2Yr-3nb6kVfhmuKDjD8vnQffHxap2K6C4o 2025-08-27 13:47:51|SQL|[#1 - 0.51ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtCustomerBasicFee.php(17): App\Model\Repair\MtCustomerBasicFee::findBasicFeeByOrderId() u433670985_test.mt_customer_basic_fee SELECT cbf.* FROM dat_syaken_order_list ord \n LEFT JOIN dat_customer cust on ord.Customer_ID = cust.base_customerID\n LEFT JOIN mt_customer_basic_fee cbf on cust.basic_fee_id = cbf.id\n where ord.Order_ID = ? ; -- '382'|{"request":{"service":"App.OrderDetail_OrderDetail.getCustomerBasicFee"}} 2025-08-27 13:47:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjcwLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzc2NzB9.us_qCFsiH2Yr-3nb6kVfhmuKDjD8vnQffHxap2K6C4o 2025-08-27 13:47:51|SQL|[#1 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(298): PhalApi\Model\DataModel::getList() u433670985_test.mt_tax SELECT * FROM mt_tax LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getTax"}} 2025-08-27 13:47:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjcwLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzc2NzB9.us_qCFsiH2Yr-3nb6kVfhmuKDjD8vnQffHxap2K6C4o 2025-08-27 13:47:51|SQL|[#1 - 0.36ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}} 2025-08-27 13:47:51|SQL|[#2 - 1.33ms - 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 = 452) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}} 2025-08-27 13:47:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjcwLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzc2NzB9.us_qCFsiH2Yr-3nb6kVfhmuKDjD8vnQffHxap2K6C4o 2025-08-27 13:47:51|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtRepairItem.php(18): PhalApi\Model\DataModel::getList() u433670985_test.mt_repair_item SELECT * FROM mt_repair_item LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}} 2025-08-27 13:47:51|SQL|[#2 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(209): PhalApi\Model\DataModel::getList() u433670985_test.mt_repair_classification SELECT * FROM mt_repair_classification LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}} 2025-08-27 13:47:51|SQL|[#3 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(213): PhalApi\Model\DataModel::getList() u433670985_test.mt_repair_remarks SELECT * FROM mt_repair_remarks LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}} 2025-08-27 13:47:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjcwLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzc2NzB9.us_qCFsiH2Yr-3nb6kVfhmuKDjD8vnQffHxap2K6C4o 2025-08-27 13:47:51|SQL|[#1 - 0.35ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}} 2025-08-27 13:47:51|SQL|[#2 - 0.39ms - 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 * FROM dat_cars WHERE (CarID = 1761);|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}} 2025-08-27 13:47:51|SQL|[#3 - 0.46ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(30): App\Model\Repair\DatRepairEstimateDetail::getListV1() u433670985_test.dat_repair_estimate_detail SELECT * FROM dat_repair_estimate_detail WHERE (katashiki = 'DBA-K13') AND (NOT repair_item = ?) LIMIT 0,20; -- 'メモ'|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}} 2025-08-27 13:47:51|SQL|[#4 - 1.76ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(41): App\Model\Repair\DatRepairEstimateDetail::totalByKatashikiAndKeyWord() u433670985_test.dat_repair_estimate_detail SELECT COUNT(id) FROM dat_repair_estimate_detail WHERE (katashiki = 'DBA-K13') AND (NOT repair_item = ?); -- 'メモ'|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}} 2025-08-27 13:47:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjcwLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzc2NzB9.us_qCFsiH2Yr-3nb6kVfhmuKDjD8vnQffHxap2K6C4o 2025-08-27 13:47:51|SQL|[#1 - 0.29ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:47:51|SQL|[#2 - 0.51ms - 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 * FROM dat_cars WHERE (CarID = 1761);|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:47:51|SQL|[#3 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Order/Order.php(2385): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 10);|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:47:51|SQL|[#4 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = 102) LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:47:51|SQL|[#5 - 0.42ms - 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 = 478) LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:47:51|SQL|[#6 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/MtMiscellaneousExpensesItem.php(11): PhalApi\Model\DataModel::getList() u433670985_test.mt_miscellaneous_expenses_item SELECT * FROM mt_miscellaneous_expenses_item LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:47:51|INFO|doSaveBudget|Start handler miscellaneousExpensesDetailList 2025-08-27 13:47:51|INFO|doSaveBudget|End handler miscellaneousExpensesDetailList 2025-08-27 13:47:51|SQL|[#7 - 1.01ms - 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 = 452) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:47:51|SQL|[#8 - 0.13ms - 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.Order_Order.getBudgetData"}} 2025-08-27 13:47:51|SQL|[#9 - 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.Order_Order.getBudgetData"}} 2025-08-27 13:47:51|SQL|[#10 - 0.2ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:47:51|INFO|MtRepairUnitPrice|where:{"(repair_item, classification, category, category_detail)":[{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u70b9\u691c","category":"\u6cd5\u5b9a\u70b9\u691c","category_detail":"\u6cd5\u5b9a24\u30f6\u6708\u70b9\u691c\u6599"},{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u6e2c\u5b9a","category":"\u4fdd\u5b89\u691c\u67fb","category_detail":"\u4fdd\u5b89\u78ba\u8a8d\u691c\u67fb\u6599"}]} 2025-08-27 13:47:51|SQL|[#11 - 0.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtRepairUnitPrice.php(32): App\Model\Repair\MtRepairUnitPrice::fetchList() u433670985_test.mt_repair_unit_price SELECT * FROM mt_repair_unit_price WHERE ((repair_item, classification, category, category_detail) IN (('基本料金', '点検', '法定点検', '法定24ヶ月点検料'), ('基本料金', '測定', '保安検査', '保安確認検査料')));|{"request":{"service":"App.Order_Order.getBudgetData"}} 2025-08-27 13:47:51|INFO|doSaveBudget|Start handler repairEstimateDetailList 2025-08-27 13:47:51|INFO|doSaveBudget|End handler repairEstimateDetailList 2025-08-27 13:47:51|INFO|doSaveBudget|Start handler discounts 2025-08-27 13:47:51|INFO|doSaveBudget|End handler discounts 2025-08-27 13:47:51|INFO|doSaveBudget|Start handler depositWithdrawalRecords 2025-08-27 13:47:51|INFO|doSaveBudget|End handler depositWithdrawalRecords 2025-08-27 13:47:51|INFO|doSaveBudget|final data: {"cost1":0,"cost2":0,"cost3":0,"cost4":0,"weightPrice":0,"carTaxPrice":0,"insurancePrice":0,"paperPrice":0,"servicePrice":16500,"checkPrice":9800,"maintenancePrice":0,"partsPrice":0,"repairPrice":0,"securityPrice":0,"otherPrices":0,"discountPrice":0,"payed":0,"priceTotal":26300,"total":26300,"toPayTotal":-26300,"tax":2391} 2025-08-27 13:47:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjcwLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzc2NzB9.us_qCFsiH2Yr-3nb6kVfhmuKDjD8vnQffHxap2K6C4o 2025-08-27 13:47:51|INFO|getOrderDetailInfo|orderId:382 2025-08-27 13:47:51|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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:51|SQL|[#2 - 0.27ms - 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 = 1761);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:51|SQL|[#3 - 0.42ms - 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 = 478) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:51|SQL|[#4 - 0.95ms - 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 = 452) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:51|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-08-27 13:47:51|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 = 102) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}} 2025-08-27 13:47:51|SQL|[#7 - 0.19ms - 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-08-27 13:47:54|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjcwLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzc2NzB9.us_qCFsiH2Yr-3nb6kVfhmuKDjD8vnQffHxap2K6C4o 2025-08-27 13:47:54|SQL|[#1 - 0.23ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.Order_Order.checkReserveState"}} 2025-08-27 13:47:54|SQL|[#2 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(125): App\Model\Repair\DatCarsStorageReservation::getStorageDateByOrderId() u433670985_test.dat_cars_storage_reservation SELECT * FROM dat_cars_storage_reservation WHERE (Order_ID = '382') LIMIT 1;|{"request":{"service":"App.Order_Order.checkReserveState"}} 2025-08-27 13:47:54|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjcwLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzc2NzB9.us_qCFsiH2Yr-3nb6kVfhmuKDjD8vnQffHxap2K6C4o 2025-08-27 13:47:54|SQL|[#1 - 0.27ms - 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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.doOrderCompleteNotify"}} 2025-08-27 13:47:54|SQL|[#2 - 0.22ms - 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 = 1761);|{"request":{"service":"App.OrderDetail_OrderDetail.doOrderCompleteNotify"}} 2025-08-27 13:47:54|SQL|[#3 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/OrderDetail/OrderDetail.php(293): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 10);|{"request":{"service":"App.OrderDetail_OrderDetail.doOrderCompleteNotify"}} 2025-08-27 13:47:54|SQL|[#4 - 0.17ms - 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.OrderDetail_OrderDetail.doOrderCompleteNotify"}} 2025-08-27 13:47:54|SQL|[#5 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineUser.php(68): App\Model\Line\DatLineUser::getLineUserIdBySsid() u433670985_test.dat_line_user SELECT c.userId from dat_line_user c \n where c.ssid = ? or c.ssid = ?; -- 10, 22|{"request":{"service":"App.OrderDetail_OrderDetail.doOrderCompleteNotify"}} 2025-08-27 13:47:54|SQL|[#6 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(26): PhalApi\Model\DataModel::insert() u433670985_test.dat_line_msg INSERT INTO dat_line_msg (`message`, `to_openid`, `Order_ID`) VALUES ('🚗整備依頼を受け付けました。（魚津、、富山585ね8358）', 'U426b11482f563780d87d53b7b1f4fb2f,U691e9035dd6d9966a633ee9202cb3ac1,Uca06f5a1b8b52c5debf2a8e679977ac5', '382');|{"request":{"service":"App.OrderDetail_OrderDetail.doOrderCompleteNotify"}} 2025-08-27 13:47:57|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczNjcwLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3ODczNzc2NzB9.us_qCFsiH2Yr-3nb6kVfhmuKDjD8vnQffHxap2K6C4o 2025-08-27 13:47:57|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 = '382') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.doEstimateCompleteNotify"}} 2025-08-27 13:47:57|INFO|doEstimateCompleteNotify|orderInfo:{"Order_ID":382,"Customer_ID":102,"Car_ID":1761,"Shop_ID":10,"staff":null,"Enquite_Date":null,"Tenken_Date":null,"Mitsumori_Date":null,"Arrival_Date":"2025-03-24 18:08:00","Complete_Date":null,"Delivary_Date":null,"Void_reason":null,"contact_id":null,"check_state":1,"service":2,"state":6,"remark":null,"questionnaire_answer_id":158,"general_order_id":null,"vehicle_inspection_quote_answer_id":null,"car_photo":null,"reason":null,"miscellaneous_expenses_id":478,"repair_estimate_id":452,"deposit_withdrawal_record_id":null,"discount_record_id":null,"deposit_withdrawal_total":"-26300.00","extra_discount":null,"new_flag":0,"cancel_flag":0,"recept_date":"2025-03-24 18:04:00","reply_date":"2025-03-24 18:07:00","mc_stock_date":null,"settle_date":null,"ss_return_date":null,"delivered_date":null,"syaken_send_date":null} 2025-08-27 13:47:57|SQL|[#2 - 0.32ms - 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 = 1761);|{"request":{"service":"App.OrderDetail_OrderDetail.doEstimateCompleteNotify"}} 2025-08-27 13:47:57|INFO|doEstimateCompleteNotify|carInfo:{"carId":1761,"customerId":102,"number":"\u5bcc\u5c71585\u306d8358","make":null,"vin":"K13-381017","syodoDate":"2015-07-01","katashiki":"DBA-K13","katashikiShitei":16470,"ruibetsu":18,"gendouki":"HR12","drive":"2WD","nenryou":1,"syaken":"2007-06-07","millage":955,"year":"2015(H27)","carName":"","grade":null,"color":null,"lastModifyDate":"2025-08-27 05:47:45","Inspection_Date":"2025-03-24","delivaryDate":"2025-03-30","keijyou":"H","jyuuryou":1,"syoyuusyaName":"H","syoyuusyaAddress":"J","shiyousyaName":"J","shiyousyaAddress":"N","ex_shiyousya_name":"J","ex_shiyousya_address":"N","Registry_Name":"H","Registry_Address":"J"} 2025-08-27 13:47:57|SQL|[#3 - 0.28ms - 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.OrderDetail_OrderDetail.doEstimateCompleteNotify"}} 2025-08-27 13:47:57|SQL|[#4 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineUser.php(68): App\Model\Line\DatLineUser::getLineUserIdBySsid() u433670985_test.dat_line_user SELECT c.userId from dat_line_user c \n where c.ssid = ? or c.ssid = ?; -- 10, NULL|{"request":{"service":"App.OrderDetail_OrderDetail.doEstimateCompleteNotify"}} 2025-08-27 13:47:57|SQL|[#5 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24): App\Model\Customer\DatCustomer::findCustomerByCustomerId() u433670985_test.dat_customer SELECT * FROM dat_customer WHERE (base_customerID = 102) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.doEstimateCompleteNotify"}} 2025-08-27 13:47:57|SQL|[#6 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(26): PhalApi\Model\DataModel::insert() u433670985_test.dat_line_msg INSERT INTO dat_line_msg (`message`, `to_openid`, `Order_ID`) VALUES ('🚗メカニックセンターからの見積完了連絡：（鈴木七瀬、、富山585ね8358）', 'Uca06f5a1b8b52c5debf2a8e679977ac5', '382');|{"request":{"service":"App.OrderDetail_OrderDetail.doEstimateCompleteNotify"}} 2025-08-27 13:52:12|INFO|mt_ss login|params:{"loginId":"530156","pw":"9438"} 2025-08-27 13:52:12|SQL|[#1 - 0.52ms - 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 = '530156') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}} 2025-08-27 13:52:12|INFO|mt_ss login|user:{"ID":10,"category":1,"ss_name":"\u9b5a\u6d25","display_name":"Dr.Drive\u9b5a\u6d25SS","en_name":"","section":"\u5449\u6771","section_id":2,"log_in":"530156","pw":"9438","manager_flag":0,"comp_1":"\uff84\uff90\uff7e\uff77","comp_2":"\u91d1\u6ca2\uff74\uff88\uff99\uff77\uff9e\uff70","comp_3":"","comp_4":null,"comp_5":null,"test_marketing_flag":null,"rent_a_car":null,"towing":null,"Delete_date":null,"line_openid":"ds48QClYSEUexbwsbE2UX9OyidzNiAffdaAwNZkriX2","zip":"937-0041","address":"\u9b5a\u6d25\u5e02\u5409\u5cf61-6-16","telno":"0765-24-9438","faxno":null} 2025-08-27 13:52:12|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273932,"data":{"ssid":10}} 2025-08-27 13:52:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczOTMyLCJkYXRhIjp7InNzaWQiOjEwfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzc1MzJ9.BmEFFhAWMSImtunr7BEF_kcV8uB85w08zqcX_pEnA9k 2025-08-27 13:52:13|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273932,"data":{"ssid":10},"scopes":"role_access","exp":1756277532} 2025-08-27 13:52:13|SQL|[#1 - 0.38ms - 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 = 10);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}} 2025-08-27 13:52:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczOTMyLCJkYXRhIjp7InNzaWQiOjEwfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzc1MzJ9.BmEFFhAWMSImtunr7BEF_kcV8uB85w08zqcX_pEnA9k 2025-08-27 13:52:13|SQL|[#1 - 0.4ms - 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-08-27 13:52:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2MjczOTMyLCJkYXRhIjp7InNzaWQiOjEwfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyNzc1MzJ9.BmEFFhAWMSImtunr7BEF_kcV8uB85w08zqcX_pEnA9k 2025-08-27 13:52:13|INFO|orderList|shopId: 2025-08-27 13:52:13|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756273932,"data":{"ssid":10},"scopes":"role_access","exp":1756277532} 2025-08-27 13:52:13|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":10,"$freeword":null,"$orderId":null} 2025-08-27 13:52:13|INFO|getOrderList|担当者所属的店铺id:10 2025-08-27 13:52:13|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(169): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 10);|{"request":{"service":"App.Order_Order.OrderList"}} 2025-08-27 13:52:13|INFO|getOrderList|担当者所属的店铺ids:10 2025-08-27 13:52:13|INFO|getOrderList|where:{"Shop_ID":10} 2025-08-27 13:52:13|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":10} 2025-08-27 13:52:13|SQL|[#2 - 0.97ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(214): 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 res.Order_ID,max(res.ss_storage_date) as 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, -12)) AND (A.Shop_ID = 10);|{"request":{"service":"App.Order_Order.OrderList"}} 2025-08-27 13:52:13|INFO|getOrderList|查询结果条数:17 2025-08-27 14:27:01|SQL|[#1 - 0.46ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(45): App\Model\Line\DatLineMsg::getLastSendTime() u433670985_test.dat_line_msg SELECT send_time FROM dat_line_msg WHERE (send_time is not null) ORDER BY send_time DESC LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:01|INFO|sendLine|lastSendTime:{"send_time":"2025-08-25 17:11:19"} 2025-08-27 14:27:01|SQL|[#2 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(55): App\Model\Line\DatLineMsg::getToSendMessage() u433670985_test.dat_line_msg SELECT * FROM dat_line_msg WHERE (status = 0) ORDER BY create_time LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:01|INFO|sendLine|toUserId:U426b11482f563780d87d53b7b1f4fb2f, msg: 🚗整備依頼を受け付けました。（魚津、ベンツ１２３４３４５６７７８８８０９０９８７６５４３２２、富山531ね729） 2025-08-27 14:27:01|INFO|sendLine|data:{"to":"U426b11482f563780d87d53b7b1f4fb2f","messages":[{"type":"text","text":"\ud83d\ude97\u6574\u5099\u4f9d\u983c\u3092\u53d7\u3051\u4ed8\u3051\u307e\u3057\u305f\u3002\uff08\u9b5a\u6d25\u3001\u30d9\u30f3\u30c4\uff11\uff12\uff13\uff14\uff13\uff14\uff15\uff16\uff17\uff17\uff18\uff18\uff18\uff10\uff19\uff10\uff19\uff18\uff17\uff16\uff15\uff14\uff13\uff12\uff12\u3001\u5bcc\u5c71531\u306d729\uff09"}]} 2025-08-27 14:27:01|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204621509820553\",\"quoteToken\":\"fv0nCrvOF2c84_J3gcFcRU0UofXNAUHlFonH_WlhA9yFinY5zDq7kqE8R-XTWm8UqvBz67C3DmCOYlykMvZNgiT9Gi3Nb34TSMrKpRYLooIeId2_SA6hDh7sX5h755Ud6ItGscFMsszXzl1CuZWk0w\"}]}" 2025-08-27 14:27:01|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204621509820553\",\"quoteToken\":\"fv0nCrvOF2c84_J3gcFcRU0UofXNAUHlFonH_WlhA9yFinY5zDq7kqE8R-XTWm8UqvBz67C3DmCOYlykMvZNgiT9Gi3Nb34TSMrKpRYLooIeId2_SA6hDh7sX5h755Ud6ItGscFMsszXzl1CuZWk0w\"}]}" 2025-08-27 14:27:01|INFO|sendLine|toUserId:U691e9035dd6d9966a633ee9202cb3ac1, msg: 🚗整備依頼を受け付けました。（魚津、ベンツ１２３４３４５６７７８８８０９０９８７６５４３２２、富山531ね729） 2025-08-27 14:27:01|INFO|sendLine|data:{"to":"U691e9035dd6d9966a633ee9202cb3ac1","messages":[{"type":"text","text":"\ud83d\ude97\u6574\u5099\u4f9d\u983c\u3092\u53d7\u3051\u4ed8\u3051\u307e\u3057\u305f\u3002\uff08\u9b5a\u6d25\u3001\u30d9\u30f3\u30c4\uff11\uff12\uff13\uff14\uff13\uff14\uff15\uff16\uff17\uff17\uff18\uff18\uff18\uff10\uff19\uff10\uff19\uff18\uff17\uff16\uff15\uff14\uff13\uff12\uff12\u3001\u5bcc\u5c71531\u306d729\uff09"}]} 2025-08-27 14:27:02|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204621543637524\",\"quoteToken\":\"C7vpWEk0BH7gGoM4ndeUrWdrAPaUbOmn5dw2qqU0nJa8b7Yhyqz493xNGBIBM-iG84N6joxkPs7pA54DygAfWSqZ0bnJSxp5q91hzK9GAz-XGHb8FVPMzCQDxd5j9-XXoaqHV6AVpGGV7bDpFRnqEA\"}]}" 2025-08-27 14:27:02|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204621543637524\",\"quoteToken\":\"C7vpWEk0BH7gGoM4ndeUrWdrAPaUbOmn5dw2qqU0nJa8b7Yhyqz493xNGBIBM-iG84N6joxkPs7pA54DygAfWSqZ0bnJSxp5q91hzK9GAz-XGHb8FVPMzCQDxd5j9-XXoaqHV6AVpGGV7bDpFRnqEA\"}]}" 2025-08-27 14:27:02|INFO|sendLine|toUserId:Uca06f5a1b8b52c5debf2a8e679977ac5, msg: 🚗整備依頼を受け付けました。（魚津、ベンツ１２３４３４５６７７８８８０９０９８７６５４３２２、富山531ね729） 2025-08-27 14:27:02|INFO|sendLine|data:{"to":"Uca06f5a1b8b52c5debf2a8e679977ac5","messages":[{"type":"text","text":"\ud83d\ude97\u6574\u5099\u4f9d\u983c\u3092\u53d7\u3051\u4ed8\u3051\u307e\u3057\u305f\u3002\uff08\u9b5a\u6d25\u3001\u30d9\u30f3\u30c4\uff11\uff12\uff13\uff14\uff13\uff14\uff15\uff16\uff17\uff17\uff18\uff18\uff18\uff10\uff19\uff10\uff19\uff18\uff17\uff16\uff15\uff14\uff13\uff12\uff12\u3001\u5bcc\u5c71531\u306d729\uff09"}]} 2025-08-27 14:27:02|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204622079721627\",\"quoteToken\":\"q5d_SLnRqsU0KwcOfaojnUX-bM1hS0pR8Q_NCK4zzAr2YB9p1I6c6GYxjqhCeGIsmCp_6FwQ7r4d7eDbqs_lDGQOHA1XtF_IqUT67jwXcgjQvkCzEv9prLRGjQUUL_I5a-QyxhuEiZGJoW3R_Rn5_w\"}]}" 2025-08-27 14:27:02|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204622079721627\",\"quoteToken\":\"q5d_SLnRqsU0KwcOfaojnUX-bM1hS0pR8Q_NCK4zzAr2YB9p1I6c6GYxjqhCeGIsmCp_6FwQ7r4d7eDbqs_lDGQOHA1XtF_IqUT67jwXcgjQvkCzEv9prLRGjQUUL_I5a-QyxhuEiZGJoW3R_Rn5_w\"}]}" 2025-08-27 14:27:02|SQL|[#3 - 0.99ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/Index.php(167): App\Domain\Line\DatLineMsg::update() u433670985_test.dat_line_msg UPDATE dat_line_msg SET `id` = 365, `create_time` = '2025-08-27 05:37:55', `status` = 1, `send_time` = '2025-08-27 14:27:02', `message` = '🚗整備依頼を受け付けました。（魚津、ベンツ１２３４３４５６７７８８８０９０９８７６５４３２２、富山531ね729）', `to_openid` = 'U426b11482f563780d87d53b7b1f4fb2f,U691e9035dd6d9966a633ee9202cb3ac1,Uca06f5a1b8b52c5debf2a8e679977ac5', `Order_ID` = 382 WHERE (id = 365);|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:22|SQL|[#1 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(45): App\Model\Line\DatLineMsg::getLastSendTime() u433670985_test.dat_line_msg SELECT send_time FROM dat_line_msg WHERE (send_time is not null) ORDER BY send_time DESC LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:22|INFO|sendLine|lastSendTime:{"send_time":"2025-08-27 14:27:02"} 2025-08-27 14:27:22|SQL|[#2 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(55): App\Model\Line\DatLineMsg::getToSendMessage() u433670985_test.dat_line_msg SELECT * FROM dat_line_msg WHERE (status = 0) ORDER BY create_time LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:22|INFO|sendLine|toUserId:Uca06f5a1b8b52c5debf2a8e679977ac5, msg: 🚗メカニックセンターからの見積完了連絡：（鈴木七瀬、ベンツ１２３４３４５６７７８８８０９０９８７６５４３２２、富山531ね729） 2025-08-27 14:27:22|INFO|sendLine|data:{"to":"Uca06f5a1b8b52c5debf2a8e679977ac5","messages":[{"type":"text","text":"\ud83d\ude97\u30e1\u30ab\u30cb\u30c3\u30af\u30bb\u30f3\u30bf\u30fc\u304b\u3089\u306e\u898b\u7a4d\u5b8c\u4e86\u9023\u7d61\uff1a\uff08\u9234\u6728\u4e03\u702c\u3001\u30d9\u30f3\u30c4\uff11\uff12\uff13\uff14\uff13\uff14\uff15\uff16\uff17\uff17\uff18\uff18\uff18\uff10\uff19\uff10\uff19\uff18\uff17\uff16\uff15\uff14\uff13\uff12\uff12\u3001\u5bcc\u5c71531\u306d729\uff09"}]} 2025-08-27 14:27:22|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204656171549102\",\"quoteToken\":\"JwXJbe17PtRaVhwGyWmXC3rS5fVtbawtTyy54nWwgb2fkrES521LO7d2XSFwkccbgdWpNCX9BtvNO9RXY1dB6pCORxguBP2ldqaAaIjYDDNhquzsM3kZ0gBw17vl9_47GSXexxW4PNRVO8ICnR7clw\"}]}" 2025-08-27 14:27:22|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204656171549102\",\"quoteToken\":\"JwXJbe17PtRaVhwGyWmXC3rS5fVtbawtTyy54nWwgb2fkrES521LO7d2XSFwkccbgdWpNCX9BtvNO9RXY1dB6pCORxguBP2ldqaAaIjYDDNhquzsM3kZ0gBw17vl9_47GSXexxW4PNRVO8ICnR7clw\"}]}" 2025-08-27 14:27:22|SQL|[#3 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/Index.php(167): App\Domain\Line\DatLineMsg::update() u433670985_test.dat_line_msg UPDATE dat_line_msg SET `id` = 366, `create_time` = '2025-08-27 05:47:00', `status` = 1, `send_time` = '2025-08-27 14:27:22', `message` = '🚗メカニックセンターからの見積完了連絡：（鈴木七瀬、ベンツ１２３４３４５６７７８８８０９０９８７６５４３２２、富山531ね729）', `to_openid` = 'Uca06f5a1b8b52c5debf2a8e679977ac5', `Order_ID` = 382 WHERE (id = 366);|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:25|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(45): App\Model\Line\DatLineMsg::getLastSendTime() u433670985_test.dat_line_msg SELECT send_time FROM dat_line_msg WHERE (send_time is not null) ORDER BY send_time DESC LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:25|INFO|sendLine|lastSendTime:{"send_time":"2025-08-27 14:27:22"} 2025-08-27 14:27:25|SQL|[#2 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(55): App\Model\Line\DatLineMsg::getToSendMessage() u433670985_test.dat_line_msg SELECT * FROM dat_line_msg WHERE (status = 0) ORDER BY create_time LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:25|INFO|sendLine|toUserId:U426b11482f563780d87d53b7b1f4fb2f, msg: 🚗整備依頼を受け付けました。（魚津、、富山585ね8358） 2025-08-27 14:27:25|INFO|sendLine|data:{"to":"U426b11482f563780d87d53b7b1f4fb2f","messages":[{"type":"text","text":"\ud83d\ude97\u6574\u5099\u4f9d\u983c\u3092\u53d7\u3051\u4ed8\u3051\u307e\u3057\u305f\u3002\uff08\u9b5a\u6d25\u3001\u3001\u5bcc\u5c71585\u306d8358\uff09"}]} 2025-08-27 14:27:25|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204661590852268\",\"quoteToken\":\"Retzr_4bfr4zArE2Fw9Ir0Il3k1nwYjjWuMM007UcTMBCHwimCTmZ9TnrkwGY-GokPF6jxrK0QLs6sG7E3RvmbBvU_F96QPuZSg35B_NJKR2x9NflkQc5plg_n3mMRanOvWJnwPXEHfysPLGDfpMiw\"}]}" 2025-08-27 14:27:25|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204661590852268\",\"quoteToken\":\"Retzr_4bfr4zArE2Fw9Ir0Il3k1nwYjjWuMM007UcTMBCHwimCTmZ9TnrkwGY-GokPF6jxrK0QLs6sG7E3RvmbBvU_F96QPuZSg35B_NJKR2x9NflkQc5plg_n3mMRanOvWJnwPXEHfysPLGDfpMiw\"}]}" 2025-08-27 14:27:25|INFO|sendLine|toUserId:U691e9035dd6d9966a633ee9202cb3ac1, msg: 🚗整備依頼を受け付けました。（魚津、、富山585ね8358） 2025-08-27 14:27:25|INFO|sendLine|data:{"to":"U691e9035dd6d9966a633ee9202cb3ac1","messages":[{"type":"text","text":"\ud83d\ude97\u6574\u5099\u4f9d\u983c\u3092\u53d7\u3051\u4ed8\u3051\u307e\u3057\u305f\u3002\uff08\u9b5a\u6d25\u3001\u3001\u5bcc\u5c71585\u306d8358\uff09"}]} 2025-08-27 14:27:26|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204661808431520\",\"quoteToken\":\"deErhmL3Lr1pWsBUsYecZSXwzWlpTuPspGW3IaZFUEpQJBiJCBePiwP8OTrt5cmJ800yCPOngYH5zmRea9JXlVlvhe9B9UGPTEZHqimv2Z9AwfWkiNbgbrrCDX1CkhuleBZqUaU53WDPQVzaDrnGaQ\"}]}" 2025-08-27 14:27:26|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204661808431520\",\"quoteToken\":\"deErhmL3Lr1pWsBUsYecZSXwzWlpTuPspGW3IaZFUEpQJBiJCBePiwP8OTrt5cmJ800yCPOngYH5zmRea9JXlVlvhe9B9UGPTEZHqimv2Z9AwfWkiNbgbrrCDX1CkhuleBZqUaU53WDPQVzaDrnGaQ\"}]}" 2025-08-27 14:27:26|INFO|sendLine|toUserId:Uca06f5a1b8b52c5debf2a8e679977ac5, msg: 🚗整備依頼を受け付けました。（魚津、、富山585ね8358） 2025-08-27 14:27:26|INFO|sendLine|data:{"to":"Uca06f5a1b8b52c5debf2a8e679977ac5","messages":[{"type":"text","text":"\ud83d\ude97\u6574\u5099\u4f9d\u983c\u3092\u53d7\u3051\u4ed8\u3051\u307e\u3057\u305f\u3002\uff08\u9b5a\u6d25\u3001\u3001\u5bcc\u5c71585\u306d8358\uff09"}]} 2025-08-27 14:27:26|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204661993505367\",\"quoteToken\":\"oi0Hd6W9U_t1qWr0An0TRZq6TToZtJYnr-DGeLiAv7cKJkJUubQ0Dq8rkiIfgHotO1lcXk0F1HNSXxu5H7lFfjk0YvgZhDDMhyAxZ1AswLCAS2qd7P3sKN7S6qiO_mSE3QeSOH-iYVgyexbNkkmYEA\"}]}" 2025-08-27 14:27:26|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204661993505367\",\"quoteToken\":\"oi0Hd6W9U_t1qWr0An0TRZq6TToZtJYnr-DGeLiAv7cKJkJUubQ0Dq8rkiIfgHotO1lcXk0F1HNSXxu5H7lFfjk0YvgZhDDMhyAxZ1AswLCAS2qd7P3sKN7S6qiO_mSE3QeSOH-iYVgyexbNkkmYEA\"}]}" 2025-08-27 14:27:26|SQL|[#3 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/Index.php(167): App\Domain\Line\DatLineMsg::update() u433670985_test.dat_line_msg UPDATE dat_line_msg SET `id` = 367, `create_time` = '2025-08-27 05:47:54', `status` = 1, `send_time` = '2025-08-27 14:27:26', `message` = '🚗整備依頼を受け付けました。（魚津、、富山585ね8358）', `to_openid` = 'U426b11482f563780d87d53b7b1f4fb2f,U691e9035dd6d9966a633ee9202cb3ac1,Uca06f5a1b8b52c5debf2a8e679977ac5', `Order_ID` = 382 WHERE (id = 367);|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:29|SQL|[#1 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(45): App\Model\Line\DatLineMsg::getLastSendTime() u433670985_test.dat_line_msg SELECT send_time FROM dat_line_msg WHERE (send_time is not null) ORDER BY send_time DESC LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:29|INFO|sendLine|lastSendTime:{"send_time":"2025-08-27 14:27:26"} 2025-08-27 14:27:29|SQL|[#2 - 0.47ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(55): App\Model\Line\DatLineMsg::getToSendMessage() u433670985_test.dat_line_msg SELECT * FROM dat_line_msg WHERE (status = 0) ORDER BY create_time LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:29|INFO|sendLine|toUserId:Uca06f5a1b8b52c5debf2a8e679977ac5, msg: 🚗メカニックセンターからの見積完了連絡：（鈴木七瀬、、富山585ね8358） 2025-08-27 14:27:29|INFO|sendLine|data:{"to":"Uca06f5a1b8b52c5debf2a8e679977ac5","messages":[{"type":"text","text":"\ud83d\ude97\u30e1\u30ab\u30cb\u30c3\u30af\u30bb\u30f3\u30bf\u30fc\u304b\u3089\u306e\u898b\u7a4d\u5b8c\u4e86\u9023\u7d61\uff1a\uff08\u9234\u6728\u4e03\u702c\u3001\u3001\u5bcc\u5c71585\u306d8358\uff09"}]} 2025-08-27 14:27:29|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204667278066430\",\"quoteToken\":\"jR9bfDIUsV4v1U-4H9aJWuxx31sXnFYU-B7Z_8w5XJZX6e8Ix7LvZzQSPhN0JX460SMomk3iw1VJsPSdmsAtHpBEDxuevwIxGzSS3auOexIqHhLi9JrHxro1QPXSQEdaqSjUyezIF7XJAlQrBqs-ng\"}]}" 2025-08-27 14:27:29|INFO|sendLine|response:"{\"sentMessages\":[{\"id\":\"576204667278066430\",\"quoteToken\":\"jR9bfDIUsV4v1U-4H9aJWuxx31sXnFYU-B7Z_8w5XJZX6e8Ix7LvZzQSPhN0JX460SMomk3iw1VJsPSdmsAtHpBEDxuevwIxGzSS3auOexIqHhLi9JrHxro1QPXSQEdaqSjUyezIF7XJAlQrBqs-ng\"}]}" 2025-08-27 14:27:29|SQL|[#3 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Task/Index.php(167): App\Domain\Line\DatLineMsg::update() u433670985_test.dat_line_msg UPDATE dat_line_msg SET `id` = 368, `create_time` = '2025-08-27 05:47:57', `status` = 1, `send_time` = '2025-08-27 14:27:29', `message` = '🚗メカニックセンターからの見積完了連絡：（鈴木七瀬、、富山585ね8358）', `to_openid` = 'Uca06f5a1b8b52c5debf2a8e679977ac5', `Order_ID` = 382 WHERE (id = 368);|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:31|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(45): App\Model\Line\DatLineMsg::getLastSendTime() u433670985_test.dat_line_msg SELECT send_time FROM dat_line_msg WHERE (send_time is not null) ORDER BY send_time DESC LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:31|INFO|sendLine|lastSendTime:{"send_time":"2025-08-27 14:27:29"} 2025-08-27 14:27:31|SQL|[#2 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(55): App\Model\Line\DatLineMsg::getToSendMessage() u433670985_test.dat_line_msg SELECT * FROM dat_line_msg WHERE (status = 0) ORDER BY create_time LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:35|SQL|[#1 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(45): App\Model\Line\DatLineMsg::getLastSendTime() u433670985_test.dat_line_msg SELECT send_time FROM dat_line_msg WHERE (send_time is not null) ORDER BY send_time DESC LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:27:35|INFO|sendLine|lastSendTime:{"send_time":"2025-08-27 14:27:29"} 2025-08-27 14:27:35|SQL|[#2 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(55): App\Model\Line\DatLineMsg::getToSendMessage() u433670985_test.dat_line_msg SELECT * FROM dat_line_msg WHERE (status = 0) ORDER BY create_time LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:36:22|INFO|checkSourceUpdate|file:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../appview/dist.zip 2025-08-27 14:36:22|INFO|checkSourceUpdate|crc32:854971ee 2025-08-27 14:39:25|SQL|[#1 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(45): App\Model\Line\DatLineMsg::getLastSendTime() u433670985_test.dat_line_msg SELECT send_time FROM dat_line_msg WHERE (send_time is not null) ORDER BY send_time DESC LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:39:25|INFO|sendLine|lastSendTime:{"send_time":"2025-08-27 14:27:29"} 2025-08-27 14:39:25|SQL|[#2 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(55): App\Model\Line\DatLineMsg::getToSendMessage() u433670985_test.dat_line_msg SELECT * FROM dat_line_msg WHERE (status = 0) ORDER BY create_time LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:49:46|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(45): App\Model\Line\DatLineMsg::getLastSendTime() u433670985_test.dat_line_msg SELECT send_time FROM dat_line_msg WHERE (send_time is not null) ORDER BY send_time DESC LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:49:46|INFO|sendLine|lastSendTime:{"send_time":"2025-08-27 14:27:29"} 2025-08-27 14:49:46|SQL|[#2 - 0.18ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(55): App\Model\Line\DatLineMsg::getToSendMessage() u433670985_test.dat_line_msg SELECT * FROM dat_line_msg WHERE (status = 0) ORDER BY create_time LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 14:51:03|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjAwMTU5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjQ1OTM1OX0.j2VJxmgCPblt32agVqK_zeip_GUrxRIc6a5q9uB7rCU 2025-08-27 14:51:03|INFO|mt_ss getSsInfoFromSession|sessionUserName: 2025-08-27 14:54:23|INFO|mt_ss login|params:{"loginId":"530156","pw":"9438"} 2025-08-27 14:54:23|SQL|[#1 - 0.32ms - 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 = '530156') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}} 2025-08-27 14:54:23|INFO|mt_ss login|user:{"ID":10,"category":1,"ss_name":"\u9b5a\u6d25","display_name":"Dr.Drive\u9b5a\u6d25SS","en_name":"","section":"\u5449\u6771","section_id":2,"log_in":"530156","pw":"9438","manager_flag":0,"comp_1":"\uff84\uff90\uff7e\uff77","comp_2":"\u91d1\u6ca2\uff74\uff88\uff99\uff77\uff9e\uff70","comp_3":"","comp_4":null,"comp_5":null,"test_marketing_flag":null,"rent_a_car":null,"towing":null,"Delete_date":null,"line_openid":"ds48QClYSEUexbwsbE2UX9OyidzNiAffdaAwNZkriX2","zip":"937-0041","address":"\u9b5a\u6d25\u5e02\u5409\u5cf61-6-16","telno":"0765-24-9438","faxno":null} 2025-08-27 14:54:23|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756277663,"data":{"ssid":10}} 2025-08-27 14:54:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2Mjc3NjYzLCJkYXRhIjp7InNzaWQiOjEwfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyODEyNjN9.Mh_P6JsYYxAkIbot7ccSyxhpwPSATcIwQREMxivi47U 2025-08-27 14:54:23|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756277663,"data":{"ssid":10},"scopes":"role_access","exp":1756281263} 2025-08-27 14:54:23|SQL|[#1 - 38.3ms - 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 = 10);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}} 2025-08-27 14:54:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2Mjc3NjYzLCJkYXRhIjp7InNzaWQiOjEwfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyODEyNjN9.Mh_P6JsYYxAkIbot7ccSyxhpwPSATcIwQREMxivi47U 2025-08-27 14:54:23|SQL|[#1 - 0.39ms - 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-08-27 14:54:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU2Mjc3NjYzLCJkYXRhIjp7InNzaWQiOjEwfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTYyODEyNjN9.Mh_P6JsYYxAkIbot7ccSyxhpwPSATcIwQREMxivi47U 2025-08-27 14:54:23|INFO|orderList|shopId: 2025-08-27 14:54:23|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1756277663,"data":{"ssid":10},"scopes":"role_access","exp":1756281263} 2025-08-27 14:54:23|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":10,"$freeword":null,"$orderId":null} 2025-08-27 14:54:23|INFO|getOrderList|担当者所属的店铺id:10 2025-08-27 14:54:23|SQL|[#1 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(169): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 10);|{"request":{"service":"App.Order_Order.OrderList"}} 2025-08-27 14:54:23|INFO|getOrderList|担当者所属的店铺ids:10 2025-08-27 14:54:23|INFO|getOrderList|where:{"Shop_ID":10} 2025-08-27 14:54:23|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":10} 2025-08-27 14:54:23|SQL|[#2 - 1.11ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(214): 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 res.Order_ID,max(res.ss_storage_date) as 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, -12)) AND (A.Shop_ID = 10);|{"request":{"service":"App.Order_Order.OrderList"}} 2025-08-27 14:54:23|INFO|getOrderList|查询结果条数:17 2025-08-27 15:02:31|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(45): App\Model\Line\DatLineMsg::getLastSendTime() u433670985_test.dat_line_msg SELECT send_time FROM dat_line_msg WHERE (send_time is not null) ORDER BY send_time DESC LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}} 2025-08-27 15:02:31|INFO|sendLine|lastSendTime:{"send_time":"2025-08-27 14:27:29"} 2025-08-27 15:02:31|SQL|[#2 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Line/DatLineMsg.php(55): App\Model\Line\DatLineMsg::getToSendMessage() u433670985_test.dat_line_msg SELECT * FROM dat_line_msg WHERE (status = 0) ORDER BY create_time LIMIT 1;|{"request":{"service":"App.Task_Index.sendLine"}}