2026-05-12 12:23:02|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"}
2026-05-12 12:23:02|SQL|[#1 - 0.78ms - 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"}}
2026-05-12 12:23:02|INFO|mt_ss login|user:{"ID":18,"category":9,"ss_name":"admin","display_name":null,"en_name":"admin","section":null,"section_id":null,"log_in":"admin","pw":"urutoraman1","manager_flag":1,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":1,"rent_a_car":1,"towing":null,"Delete_date":null,"line_openid":"C","zip":null,"address":null,"telno":null,"faxno":null}
2026-05-12 12:23:02|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1778559782,"data":{"ssid":18}}
2026-05-12 12:23:03|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:03|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:03|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5NzgyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzODJ9.rO1XmzI6j-rMVY9WQF0WUup-AQzcG9HfkT1HGeCT9rA
2026-05-12 12:23:03|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1778559782,"data":{"ssid":18},"scopes":"role_access","exp":1778563382}
2026-05-12 12:23:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5NzgyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzODJ9.rO1XmzI6j-rMVY9WQF0WUup-AQzcG9HfkT1HGeCT9rA
2026-05-12 12:23:03|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2026-05-12 12:23:03|SQL|[#2 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(63):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (category <> ?) LIMIT 0,100; -- 9|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2026-05-12 12:23:03|SQL|[#1 - 0.44ms - 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"}}
2026-05-12 12:23:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5NzgyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzODJ9.rO1XmzI6j-rMVY9WQF0WUup-AQzcG9HfkT1HGeCT9rA
2026-05-12 12:23:03|INFO|orderList|shopId:
2026-05-12 12:23:03|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1778559782,"data":{"ssid":18},"scopes":"role_access","exp":1778563382}
2026-05-12 12:23:03|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2026-05-12 12:23:03|INFO|getOrderList|担当者所属的店铺id:18
2026-05-12 12:23:03|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-05-12 12:23:03|SQL|[#2 - 0.22ms - 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"}}
2026-05-12 12:23:03|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}]
2026-05-12 12:23:03|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}]}
2026-05-12 12:23:03|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}]}
2026-05-12 12:23:03|SQL|[#3 - 4.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT 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"}}
2026-05-12 12:23:03|INFO|getOrderList|查询结果条数:147
2026-05-12 12:23:04|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5NzgyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzODJ9.rO1XmzI6j-rMVY9WQF0WUup-AQzcG9HfkT1HGeCT9rA
2026-05-12 12:23:04|INFO|orderList|shopId:
2026-05-12 12:23:04|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1778559782,"data":{"ssid":18},"scopes":"role_access","exp":1778563382}
2026-05-12 12:23:04|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2026-05-12 12:23:04|INFO|getOrderList|担当者所属的店铺id:18
2026-05-12 12:23:04|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-05-12 12:23:04|SQL|[#2 - 0.21ms - 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"}}
2026-05-12 12:23:04|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}]
2026-05-12 12:23:04|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}]}
2026-05-12 12:23:04|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}]}
2026-05-12 12:23:04|SQL|[#3 - 1.42ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT 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"}}
2026-05-12 12:23:04|INFO|getOrderList|查询结果条数:147
2026-05-12 12:23:06|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5NzgyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzODJ9.rO1XmzI6j-rMVY9WQF0WUup-AQzcG9HfkT1HGeCT9rA
2026-05-12 12:23:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5NzgyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzODJ9.rO1XmzI6j-rMVY9WQF0WUup-AQzcG9HfkT1HGeCT9rA
2026-05-12 12:23:06|SQL|[#1 - 3.76ms - 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"}}
2026-05-12 12:23:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5NzgyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzODJ9.rO1XmzI6j-rMVY9WQF0WUup-AQzcG9HfkT1HGeCT9rA
2026-05-12 12:23:06|INFO|getOrderDetailInfo|orderId:220
2026-05-12 12:23:06|SQL|[#1 - 3.61ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '220') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5NzgyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzODJ9.rO1XmzI6j-rMVY9WQF0WUup-AQzcG9HfkT1HGeCT9rA
2026-05-12 12:23:06|INFO|getCarPhotos|params:{"orderId":"220"}
2026-05-12 12:23:06|INFO|getOrderPdfs|params:{"orderId":"220"}
2026-05-12 12:23:06|SQL|[#2 - 2.21ms - 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 = 1489);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:06|SQL|[#3 - 7.25ms - 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 = 496) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:06|SQL|[#4 - 10.18ms - 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 = 549) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:06|SQL|[#5 - 8.14ms - 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"}}
2026-05-12 12:23:06|SQL|[#6 - 0.3ms - 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 = 7) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:06|SQL|[#7 - 0.58ms - 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"}}
2026-05-12 12:23:06|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5NzgyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzODJ9.rO1XmzI6j-rMVY9WQF0WUup-AQzcG9HfkT1HGeCT9rA
2026-05-12 12:23:06|INFO|viewImg|params:{"path":"\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/cars\/","fileName":"220_1748053751851_car.jpg"}
2026-05-12 12:23:06|INFO|viewImg|imgPath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/cars/220_1748053751851_car.jpg
2026-05-12 12:23:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5NzgyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzODJ9.rO1XmzI6j-rMVY9WQF0WUup-AQzcG9HfkT1HGeCT9rA
2026-05-12 12:23:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5NzgyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzODJ9.rO1XmzI6j-rMVY9WQF0WUup-AQzcG9HfkT1HGeCT9rA
2026-05-12 12:23:06|SQL|[#1 - 0.59ms - 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 = '9');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2026-05-12 12:23:06|SQL|[#1 - 3.16ms - 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"}}
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5NzgyLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzODJ9.rO1XmzI6j-rMVY9WQF0WUup-AQzcG9HfkT1HGeCT9rA
2026-05-12 12:23:07|INFO|updateToken|jwt:{"iss":"http:\/\/www.shimars.net","iat":1778559782,"data":{"ssid":18},"scopes":"role_access","exp":1778563382}
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:07|INFO|getOrderDetailInfo|orderId:220
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:08|SQL|[#1 - 0.46ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '220') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:08|SQL|[#2 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1489);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:08|SQL|[#3 - 0.69ms - 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 = 496) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:08|SQL|[#4 - 1.88ms - 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 = 549) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:08|SQL|[#5 - 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.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:08|SQL|[#1 - 1.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtMechanic.php(12):    App\Model\Repair\MtMechanic::queryList()    u433670985_test.mt_mechanic    SELECT ID,name FROM mt_mechanic WHERE (Delete_date is null);|{"request":{"service":"App.OrderDetail_OrderDetail.getAllMcStaffName"}}
2026-05-12 12:23:08|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 = 7) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:08|SQL|[#7 - 0.26ms - 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"}}
2026-05-12 12:23:08|SQL|[#1 - 5.43ms - 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"}}
2026-05-12 12:23:08|SQL|[#2 - 0.62ms - 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"}}
2026-05-12 12:23:08|SQL|[#3 - 0.41ms - 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"}}
2026-05-12 12:23:08|SQL|[#1 - 0.8ms - 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"}}
2026-05-12 12:23:08|SQL|[#1 - 0.43ms - 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 = ? ; -- '220'|{"request":{"service":"App.OrderDetail_OrderDetail.getCustomerBasicFee"}}
2026-05-12 12:23:08|SQL|[#1 - 2.02ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatMcMemo.php(12):    App\Model\Repair\DatMcMemo::getMcMemoByOrderId()    u433670985_test.dat_mc_memo    SELECT * FROM dat_mc_memo WHERE (Order_ID = '220') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getDefaultStaffName"}}
2026-05-12 12:23:08|SQL|[#1 - 1.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatMcMemo.php(12):    App\Model\Repair\DatMcMemo::getMcMemoByOrderId()    u433670985_test.dat_mc_memo    SELECT * FROM dat_mc_memo WHERE (Order_ID = '220') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}}
2026-05-12 12:23:08|SQL|[#1 - 0.67ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '220') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:08|SQL|[#1 - 0.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '220') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}}
2026-05-12 12:23:08|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 = 1489);|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:08|SQL|[#2 - 0.38ms - 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 = 1489);|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}}
2026-05-12 12:23:08|SQL|[#3 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Order/Order.php(2424):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 1);|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:08|SQL|[#2 - 0.46ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '220') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}}
2026-05-12 12:23:08|SQL|[#4 - 0.28ms - 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 = 7) LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:08|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 = 496) LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:08|SQL|[#3 - 2.17ms - 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 = 549) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}}
2026-05-12 12:23:08|SQL|[#6 - 0.7ms - 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"}}
2026-05-12 12:23:08|INFO|doSaveBudget|Start handler miscellaneousExpensesDetailList
2026-05-12 12:23:08|INFO|doSaveBudget|End handler miscellaneousExpensesDetailList
2026-05-12 12:23:08|SQL|[#3 - 4.9ms - 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-H82W') AND (NOT repair_item = ?) LIMIT 0,20; -- 'メモ'|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}}
2026-05-12 12:23:08|SQL|[#7 - 2.04ms - 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 = 549) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:08|SQL|[#8 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = 9);|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:08|SQL|[#9 - 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.Order_Order.getBudgetData"}}
2026-05-12 12:23:08|SQL|[#4 - 1.77ms - 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-H82W') AND (NOT repair_item = ?); -- 'メモ'|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}}
2026-05-12 12:23:08|SQL|[#10 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '220') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:08|SQL|[#11 - 0.71ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatDepositWithdrawalRecord.php(45):    App\Model\Repair\DatDepositWithdrawalRecord::listByDepositWithdrawalRecordId()    u433670985_test.dat_deposit_withdrawal_record    SELECT * FROM dat_deposit_withdrawal_record WHERE (deposit_withdrawal_record_id = 10);|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:08|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"},{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u6e2c\u5b9a","category":"\u5927\u9879\u76ee1","category_detail":"\u4e2d\u9879\u76ee1"}]}
2026-05-12 12:23:08|SQL|[#12 - 16.65ms - 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ヶ月点検料'), ('基本料金', '測定', '保安検査', '保安確認検査料'), ('基本料金', '測定', '大项目1', '中项目1')));|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:08|INFO|doSaveBudget|Start handler repairEstimateDetailList
2026-05-12 12:23:08|INFO|doSaveBudget|End handler repairEstimateDetailList
2026-05-12 12:23:08|INFO|doSaveBudget|Start handler discounts
2026-05-12 12:23:08|INFO|doSaveBudget|End handler discounts
2026-05-12 12:23:08|INFO|doSaveBudget|Start handler depositWithdrawalRecords
2026-05-12 12:23:08|INFO|doSaveBudget|End handler depositWithdrawalRecords
2026-05-12 12:23:08|INFO|doSaveBudget|final data: {"cost1":0,"cost2":0,"cost3":0,"cost4":0,"weightPrice":1,"carTaxPrice":1000,"insurancePrice":5740,"paperPrice":1800,"servicePrice":0,"checkPrice":0,"maintenancePrice":0,"partsPrice":0,"repairPrice":0,"securityPrice":0,"otherPrices":0,"discountPrice":2454,"payed":12446,"priceTotal":8541,"total":6087,"toPayTotal":6359,"tax":0}
2026-05-12 12:23:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:08|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"}}
2026-05-12 12:23:18|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:18|INFO|updateToken|jwt:{"iss":"http:\/\/www.shimars.net","iat":1778559787,"data":{"ssid":18},"scopes":"role_access","exp":1809663787}
2026-05-12 12:23:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:18|INFO|getOrderPdfs|params:{"orderId":"220"}
2026-05-12 12:23:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:18|INFO|getCarPhotos|params:{"orderId":"220"}
2026-05-12 12:23:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzg3LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE4MDk2NjM3ODd9.MnU1OxpO1EeiztbwspEkHN8S5il1jWIsd2Vbh5biVU8
2026-05-12 12:23:18|INFO|getOrderDetailInfo|orderId:220
2026-05-12 12:23:18|SQL|[#1 - 0.29ms - 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"}}
2026-05-12 12:23:18|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '220') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:18|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 = 1489);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:18|SQL|[#3 - 0.79ms - 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 = 496) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:18|SQL|[#4 - 1.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 = 549) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:18|SQL|[#5 - 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.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:18|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 = 7) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:18|SQL|[#7 - 0.24ms - 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"}}
2026-05-12 12:23:18|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzk4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzOTh9.uRDwPRX13Gg4CUJL_XvN-2XFwWIE_SZMDElsm1Gh1mo
2026-05-12 12:23:18|INFO|viewImg|params:{"path":"\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/cars\/","fileName":"220_1748053751851_car.jpg"}
2026-05-12 12:23:18|INFO|viewImg|imgPath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/cars/220_1748053751851_car.jpg
2026-05-12 12:23:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzk4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzOTh9.uRDwPRX13Gg4CUJL_XvN-2XFwWIE_SZMDElsm1Gh1mo
2026-05-12 12:23:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzk4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzOTh9.uRDwPRX13Gg4CUJL_XvN-2XFwWIE_SZMDElsm1Gh1mo
2026-05-12 12:23:18|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 = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2026-05-12 12:23:18|SQL|[#1 - 0.32ms - 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 = '9');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2026-05-12 12:23:19|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:19|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5Nzk4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Nzg1NjMzOTh9.uRDwPRX13Gg4CUJL_XvN-2XFwWIE_SZMDElsm1Gh1mo
2026-05-12 12:23:19|INFO|orderList|shopId:
2026-05-12 12:23:19|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1778559798,"data":{"ssid":18},"scopes":"role_access","exp":1778563398}
2026-05-12 12:23:19|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2026-05-12 12:23:19|INFO|getOrderList|担当者所属的店铺id:18
2026-05-12 12:23:19|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-05-12 12:23:19|SQL|[#2 - 0.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2026-05-12 12:23:19|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}]
2026-05-12 12:23:19|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}]}
2026-05-12 12:23:19|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}]}
2026-05-12 12:23:19|SQL|[#3 - 1.52ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT 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"}}
2026-05-12 12:23:19|INFO|getOrderList|查询结果条数:147
2026-05-12 12:23:23|INFO|mt_ss login|params:{"loginId":"530170","pw":"6366"}
2026-05-12 12:23:23|SQL|[#1 - 0.41ms - 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 = '530170') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2026-05-12 12:23:23|INFO|mt_ss login|user:{"ID":2,"category":1,"ss_name":"\u5927\u9580\u5c0f\u6cc9SS","display_name":"Dr.Drive\u5927\u9580\u5c0f\u6cc9\u5e97","en_name":"","section":"\u5449\u897f","section_id":1,"log_in":"530170","pw":"6366","manager_flag":1,"comp_1":"\uff84\uff90\uff7e\uff77","comp_2":"\u5b87\u4f50\u7f8e","comp_3":"\u677e\u5009\u77f3\u6cb9","comp_4":null,"comp_5":null,"test_marketing_flag":null,"rent_a_car":null,"towing":null,"Delete_date":null,"line_openid":"Uc2f645c41a6809b080a7735f2fc03f15","zip":null,"address":"\u5c04\u6c34\u5e02\u5c0f\u6cc9200-1","telno":"0766-26-3335","faxno":null}
2026-05-12 12:23:23|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1778559803,"data":{"ssid":2}}
2026-05-12 12:23:23|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:23|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODAzLCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3ODU2MzQwM30.PVolXS2WEfcENcplnERTvHGX_h3XvUr63fci1ja0FB8
2026-05-12 12:23:23|INFO|orderList|shopId:
2026-05-12 12:23:23|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1778559803,"data":{"ssid":2},"scopes":"role_access","exp":1778563403}
2026-05-12 12:23:23|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":2,"$freeword":null,"$orderId":null}
2026-05-12 12:23:23|INFO|getOrderList|担当者所属的店铺id:2
2026-05-12 12:23:23|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(170):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 2);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-05-12 12:23:23|INFO|getOrderList|担当者所属的店铺ids:2
2026-05-12 12:23:23|INFO|getOrderList|where:{"Shop_ID":2}
2026-05-12 12:23:23|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":2}
2026-05-12 12:23:23|SQL|[#2 - 1.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(215):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT 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 = 2);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-05-12 12:23:23|INFO|getOrderList|查询结果条数:50
2026-05-12 12:23:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODAzLCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3ODU2MzQwM30.PVolXS2WEfcENcplnERTvHGX_h3XvUr63fci1ja0FB8
2026-05-12 12:23:23|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1778559803,"data":{"ssid":2},"scopes":"role_access","exp":1778563403}
2026-05-12 12:23:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODAzLCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3ODU2MzQwM30.PVolXS2WEfcENcplnERTvHGX_h3XvUr63fci1ja0FB8
2026-05-12 12:23:23|SQL|[#1 - 0.36ms - 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 = 2);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2026-05-12 12:23: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"}}
2026-05-12 12:23:26|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODAzLCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3ODU2MzQwM30.PVolXS2WEfcENcplnERTvHGX_h3XvUr63fci1ja0FB8
2026-05-12 12:23:26|INFO|getOrderDetailInfo|orderId:261
2026-05-12 12:23:26|SQL|[#1 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '261') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:26|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 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 = 1584);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:26|SQL|[#3 - 0.7ms - 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 = 517) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:26|SQL|[#4 - 1.87ms - 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 = 552) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:26|SQL|[#5 - 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.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:26|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 = 22) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:26|SQL|[#7 - 0.22ms - 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"}}
2026-05-12 12:23:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODAzLCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3ODU2MzQwM30.PVolXS2WEfcENcplnERTvHGX_h3XvUr63fci1ja0FB8
2026-05-12 12:23:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODAzLCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3ODU2MzQwM30.PVolXS2WEfcENcplnERTvHGX_h3XvUr63fci1ja0FB8
2026-05-12 12:23:26|INFO|getCarPhotos|params:{"orderId":"261"}
2026-05-12 12:23:26|SQL|[#1 - 0.46ms - 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"}}
2026-05-12 12:23:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODAzLCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3ODU2MzQwM30.PVolXS2WEfcENcplnERTvHGX_h3XvUr63fci1ja0FB8
2026-05-12 12:23:26|INFO|getOrderPdfs|params:{"orderId":"261"}
2026-05-12 12:23:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODAzLCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3ODU2MzQwM30.PVolXS2WEfcENcplnERTvHGX_h3XvUr63fci1ja0FB8
2026-05-12 12:23:26|SQL|[#1 - 0.43ms - 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"}}
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODAzLCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3ODU2MzQwM30.PVolXS2WEfcENcplnERTvHGX_h3XvUr63fci1ja0FB8
2026-05-12 12:23:27|INFO|updateToken|jwt:{"iss":"http:\/\/www.shimars.net","iat":1778559803,"data":{"ssid":2},"scopes":"role_access","exp":1778563403}
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODA3LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTgwOTY2MzgwN30.tc1JABlAJrDASbDhHUWnavslAhqmxT61CF_nrs2ymT4
2026-05-12 12:23:27|INFO|getOrderDetailInfo|orderId:261
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:27|SQL|[#1 - 0.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '261') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:27|SQL|[#2 - 0.38ms - 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 = 1584);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:27|SQL|[#3 - 0.78ms - 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 = 517) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:27|SQL|[#4 - 1.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 = 552) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:27|SQL|[#5 - 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.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:27|SQL|[#6 - 0.28ms - 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 = 22) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:27|SQL|[#7 - 0.28ms - 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"}}
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODA3LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTgwOTY2MzgwN30.tc1JABlAJrDASbDhHUWnavslAhqmxT61CF_nrs2ymT4
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODA3LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTgwOTY2MzgwN30.tc1JABlAJrDASbDhHUWnavslAhqmxT61CF_nrs2ymT4
2026-05-12 12:23:27|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtMechanic.php(12):    App\Model\Repair\MtMechanic::queryList()    u433670985_test.mt_mechanic    SELECT ID,name FROM mt_mechanic WHERE (Delete_date is null);|{"request":{"service":"App.OrderDetail_OrderDetail.getAllMcStaffName"}}
2026-05-12 12:23:27|SQL|[#1 - 0.32ms - 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"}}
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODA3LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTgwOTY2MzgwN30.tc1JABlAJrDASbDhHUWnavslAhqmxT61CF_nrs2ymT4
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODA3LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTgwOTY2MzgwN30.tc1JABlAJrDASbDhHUWnavslAhqmxT61CF_nrs2ymT4
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODA3LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTgwOTY2MzgwN30.tc1JABlAJrDASbDhHUWnavslAhqmxT61CF_nrs2ymT4
2026-05-12 12:23:27|SQL|[#1 - 1.02ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatMcMemo.php(12):    App\Model\Repair\DatMcMemo::getMcMemoByOrderId()    u433670985_test.dat_mc_memo    SELECT * FROM dat_mc_memo WHERE (Order_ID = '261') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getDefaultStaffName"}}
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODA3LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTgwOTY2MzgwN30.tc1JABlAJrDASbDhHUWnavslAhqmxT61CF_nrs2ymT4
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODA3LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTgwOTY2MzgwN30.tc1JABlAJrDASbDhHUWnavslAhqmxT61CF_nrs2ymT4
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODA3LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTgwOTY2MzgwN30.tc1JABlAJrDASbDhHUWnavslAhqmxT61CF_nrs2ymT4
2026-05-12 12:23:27|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '261') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:27|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 = 1584);|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:27|SQL|[#3 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Order/Order.php(2424):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 2);|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:27|SQL|[#4 - 0.28ms - 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 = 22) LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc4NTU5ODA3LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTgwOTY2MzgwN30.tc1JABlAJrDASbDhHUWnavslAhqmxT61CF_nrs2ymT4
2026-05-12 12:23:27|SQL|[#5 - 0.73ms - 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 = 517) LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:27|SQL|[#1 - 0.42ms - 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 = ? ; -- '261'|{"request":{"service":"App.OrderDetail_OrderDetail.getCustomerBasicFee"}}
2026-05-12 12:23:27|SQL|[#6 - 0.23ms - 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"}}
2026-05-12 12:23:27|INFO|doSaveBudget|Start handler miscellaneousExpensesDetailList
2026-05-12 12:23:27|INFO|doSaveBudget|End handler miscellaneousExpensesDetailList
2026-05-12 12:23:27|SQL|[#1 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '261') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}}
2026-05-12 12:23:27|SQL|[#1 - 0.99ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatMcMemo.php(12):    App\Model\Repair\DatMcMemo::getMcMemoByOrderId()    u433670985_test.dat_mc_memo    SELECT * FROM dat_mc_memo WHERE (Order_ID = '261') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}}
2026-05-12 12:23:27|SQL|[#2 - 0.49ms - 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 = 1584);|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}}
2026-05-12 12:23:27|SQL|[#7 - 1.3ms - 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 = 552) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:27|SQL|[#2 - 0.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '261') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}}
2026-05-12 12:23:27|SQL|[#3 - 0.58ms - 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"}}
2026-05-12 12:23:27|SQL|[#8 - 0.22ms - 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"}}
2026-05-12 12:23:27|SQL|[#9 - 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.Order_Order.getBudgetData"}}
2026-05-12 12:23:27|SQL|[#1 - 0.25ms - 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"}}
2026-05-12 12:23:27|SQL|[#1 - 0.38ms - 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"}}
2026-05-12 12:23:27|SQL|[#10 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(39):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '261') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2026-05-12 12:23:27|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"},{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u70b9\u691c","category":"\u30cf\u30f3\u30c9\u30eb","category_detail":"\u30cf\u30f3\u30c9\u30eb\u304c\u305f\u3064\u304d"}]}
2026-05-12 12:23:27|SQL|[#2 - 0.23ms - 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"}}
2026-05-12 12:23:27|SQL|[#3 - 0.23ms - 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"}}
2026-05-12 12:23:27|SQL|[#3 - 1.85ms - 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 = 552) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}}
2026-05-12 12:23:27|SQL|[#4 - 2.09ms - 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"}}
2026-05-12 12:23:27|SQL|[#11 - 10.61ms - 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"}}
2026-05-12 12:23:27|INFO|doSaveBudget|Start handler repairEstimateDetailList
2026-05-12 12:23:27|INFO|doSaveBudget|End handler repairEstimateDetailList
2026-05-12 12:23:27|INFO|doSaveBudget|Start handler discounts
2026-05-12 12:23:27|INFO|doSaveBudget|End handler discounts
2026-05-12 12:23:27|INFO|doSaveBudget|Start handler depositWithdrawalRecords
2026-05-12 12:23:27|INFO|doSaveBudget|End handler depositWithdrawalRecords
2026-05-12 12:23:27|INFO|doSaveBudget|final data: {"cost1":0,"cost2":0,"cost3":0,"cost4":0,"weightPrice":0,"carTaxPrice":0,"insurancePrice":0,"paperPrice":0,"servicePrice":0,"checkPrice":9800,"maintenancePrice":0,"partsPrice":0,"repairPrice":0,"securityPrice":0,"otherPrices":0,"discountPrice":0,"payed":0,"priceTotal":9800,"total":9800,"toPayTotal":-9800,"tax":891}