2026-01-10 08:41:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY3OTQ5ODYyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njc5NTM0NjJ9._ThX_ZE3TFWIJbVWrCit89tZMmPCmXqBqujOpA7UVbw
2026-01-10 08:41:41|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 08:41:41|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 08:41:41|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 08:41:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY3OTQ5ODYyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njc5NTM0NjJ9._ThX_ZE3TFWIJbVWrCit89tZMmPCmXqBqujOpA7UVbw
2026-01-10 08:41:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY3OTQ5ODYyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njc5NTM0NjJ9._ThX_ZE3TFWIJbVWrCit89tZMmPCmXqBqujOpA7UVbw
2026-01-10 08:41:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY3OTQ5ODYyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njc5NTM0NjJ9._ThX_ZE3TFWIJbVWrCit89tZMmPCmXqBqujOpA7UVbw
2026-01-10 08:41:42|INFO|mt_ss login|params:{"loginId":"mecha","pw":"6630_Mecha"}
2026-01-10 08:41:42|SQL|[#1 - 0.6ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = 'mecha') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2026-01-10 08:41:42|INFO|mt_ss login|user:{"ID":22,"category":2,"ss_name":"MC","display_name":null,"en_name":"mecha","section":null,"section_id":4,"log_in":"mecha","pw":"6630_Mecha","manager_flag":0,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":null,"rent_a_car":null,"towing":null,"Delete_date":null,"line_openid":"4aHxP8CIZAnRDcfexnWoX90e7ij0gNefQCBYGemP2jZ","zip":null,"address":null,"telno":null,"faxno":null}
2026-01-10 08:41:42|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768005702,"data":{"ssid":22}}
2026-01-10 08:41:42|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 08:41:42|INFO|orderList|shopId:
2026-01-10 08:41:42|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768005702,"data":{"ssid":22},"scopes":"role_access","exp":1768009302}
2026-01-10 08:41:42|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":22,"$freeword":null,"$orderId":null}
2026-01-10 08:41:42|INFO|getOrderList|担当者所属的店铺id:22
2026-01-10 08:41:42|SQL|[#1 - 0.3ms - 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 = 22);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 08:41:42|SQL|[#2 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 08:41:42|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-01-10 08:41:42|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-01-10 08:41:42|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-01-10 08:41:42|SQL|[#3 - 4.73ms - 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"}}
2026-01-10 08:41:42|INFO|getOrderList|查询结果条数:140
2026-01-10 08:41:45|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 08:41:45|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 08:41:45|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 08:41:45|INFO|getOrderDetailInfo|orderId:220
2026-01-10 08:41:45|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 08:41:45|INFO|getCarPhotos|params:{"orderId":"220"}
2026-01-10 08:41:45|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 08:41:45|SQL|[#1 - 0.73ms - 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-01-10 08:41:45|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 08:41:45|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 08:41:45|INFO|getOrderPdfs|params:{"orderId":"220"}
2026-01-10 08:41:45|SQL|[#1 - 2.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 08:41:45|SQL|[#1 - 0.84ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 08:41:45|SQL|[#2 - 0.54ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 08:41:45|SQL|[#1 - 63.94ms - 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 = '220') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 08:41:45|SQL|[#2 - 0.55ms - 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-01-10 08:41:45|SQL|[#3 - 2.17ms - 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-01-10 08:41:45|SQL|[#4 - 8.68ms - 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 = 522) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 08:41:45|SQL|[#5 - 0.21ms - 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-01-10 08:41:45|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 = 7) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 08:41:45|SQL|[#7 - 0.5ms - 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-01-10 08:41:45|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 08:41:45|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 08:41:45|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-01-10 08:41:45|INFO|viewImg|imgPath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/cars/220_1748053751851_car.jpg
2026-01-10 08:41:45|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 08:41:45|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 08:41:45|SQL|[#1 - 0.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 = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2026-01-10 08:41:45|SQL|[#1 - 0.56ms - 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-01-10 09:13:38|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 09:13:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 09:13:38|INFO|orderList|shopId:
2026-01-10 09:13:38|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768005702,"data":{"ssid":22},"scopes":"role_access","exp":1768009302}
2026-01-10 09:13:38|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":22,"$freeword":null,"$orderId":null}
2026-01-10 09:13:38|INFO|getOrderList|担当者所属的店铺id:22
2026-01-10 09:13:38|SQL|[#1 - 0.28ms - 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 = 22);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 09:13:38|SQL|[#2 - 0.14ms - 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-01-10 09:13:38|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-01-10 09:13:38|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-01-10 09:13:38|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-01-10 09:13:38|SQL|[#3 - 1.02ms - 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"}}
2026-01-10 09:13:38|INFO|getOrderList|查询结果条数:140
2026-01-10 09:13:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 09:13:40|SQL|[#1 - 0.71ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 09:13:40|SQL|[#2 - 0.82ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 09:13:53|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 09:13:53|SQL|[#1 - 1.06ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2024-04-01', '2025-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 09:13:53|SQL|[#2 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2024', 2025|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 09:13:57|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 09:13:57|SQL|[#1 - 0.96ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 09:13:57|SQL|[#2 - 0.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 09:19:32|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 09:19:32|SQL|[#1 - 2.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-6-01', '2025-7-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:24:10|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDA1NzAyLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMDkzMDJ9.Fd89glgukvb5InztECIC7LvoT8WMBtXf2lYaynvPIQE
2026-01-10 10:24:11|INFO|mt_ss login|params:{"loginId":"mecha","pw":"6630_Mecha"}
2026-01-10 10:24:11|SQL|[#1 - 0.46ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = 'mecha') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2026-01-10 10:24:11|INFO|mt_ss login|user:{"ID":22,"category":2,"ss_name":"MC","display_name":null,"en_name":"mecha","section":null,"section_id":4,"log_in":"mecha","pw":"6630_Mecha","manager_flag":0,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":null,"rent_a_car":null,"towing":null,"Delete_date":null,"line_openid":"4aHxP8CIZAnRDcfexnWoX90e7ij0gNefQCBYGemP2jZ","zip":null,"address":null,"telno":null,"faxno":null}
2026-01-10 10:24:11|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768011851,"data":{"ssid":22}}
2026-01-10 10:24:12|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 10:24:12|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 10:24:12|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 10:24:12|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:24:12|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:24:12|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768011851,"data":{"ssid":22},"scopes":"role_access","exp":1768015451}
2026-01-10 10:24:12|SQL|[#1 - 0.45ms - 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-01-10 10:24:12|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 22);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2026-01-10 10:24:12|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:24:12|INFO|orderList|shopId:
2026-01-10 10:24:12|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768011851,"data":{"ssid":22},"scopes":"role_access","exp":1768015451}
2026-01-10 10:24:12|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":22,"$freeword":null,"$orderId":null}
2026-01-10 10:24:12|INFO|getOrderList|担当者所属的店铺id:22
2026-01-10 10:24:12|SQL|[#1 - 0.48ms - 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 = 22);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 10:24:12|SQL|[#2 - 0.32ms - 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-01-10 10:24:12|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-01-10 10:24:12|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-01-10 10:24:12|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-01-10 10:24:12|SQL|[#3 - 1.93ms - 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"}}
2026-01-10 10:24:12|INFO|getOrderList|查询结果条数:140
2026-01-10 10:24:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:24:14|SQL|[#1 - 0.76ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 10:24:14|SQL|[#2 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 10:24:16|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:24:16|SQL|[#1 - 1.52ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:24:22|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:24:22|SQL|[#1 - 1.89ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:24:24|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:24:24|SQL|[#1 - 1.59ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:25:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:25:00|SQL|[#1 - 1.8ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:25:15|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:25:15|SQL|[#1 - 0.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '1' WHERE (order_id = '282');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-01-10 10:25:53|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:25:54|SQL|[#1 - 1.93ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:27:01|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:27:01|SQL|[#1 - 1.51ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:27:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:27:07|SQL|[#1 - 1.94ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:27:10|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:27:10|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '0' WHERE (order_id = '282');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-01-10 10:27:15|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:27:15|SQL|[#1 - 1.74ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:28:16|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:28:16|SQL|[#1 - 1.69ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:36:20|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:20|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '1' WHERE (order_id = '282');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-01-10 10:36:25|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:25|SQL|[#1 - 1.52ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:36:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:27|SQL|[#1 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '0' WHERE (order_id = '282');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-01-10 10:36:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:27|SQL|[#1 - 1.42ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:36:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:30|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '1' WHERE (order_id = '282');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-01-10 10:36:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:30|SQL|[#1 - 1.72ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:36:32|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:32|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '1' WHERE (order_id = '387');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-01-10 10:36:32|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:32|SQL|[#1 - 1.62ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:36:36|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:36|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '0' WHERE (order_id = '282');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-01-10 10:36:36|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:36|SQL|[#1 - 1.78ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:36:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:38|SQL|[#1 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '0' WHERE (order_id = '387');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-01-10 10:36:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:38|SQL|[#1 - 1.69ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:36:55|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:55|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '1' WHERE (order_id = '282');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-01-10 10:36:55|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:36:55|SQL|[#1 - 1.86ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:38:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:38:23|SQL|[#1 - 1.64ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:40:21|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:40:21|SQL|[#1 - 1.76ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:44:33|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:44:33|SQL|[#1 - 1.6ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:45:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:45:58|SQL|[#1 - 1.81ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:46:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:46:13|SQL|[#1 - 1.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:50:26|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 10:50:38|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"}
2026-01-10 10:50:38|SQL|[#1 - 0.57ms - 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-01-10 10:50:38|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-01-10 10:50:38|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768013438,"data":{"ssid":18}}
2026-01-10 10:50:38|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 10:50:38|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 10:50:38|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 10:50:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDEzNDM4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTcwMzh9.dNYb_CUGLdwrsmcf7eQKcI_NbDMDToj5BBlnYwwiyjs
2026-01-10 10:50:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDEzNDM4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTcwMzh9.dNYb_CUGLdwrsmcf7eQKcI_NbDMDToj5BBlnYwwiyjs
2026-01-10 10:50:38|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768013438,"data":{"ssid":18},"scopes":"role_access","exp":1768017038}
2026-01-10 10:50:38|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}}
2026-01-10 10:50:38|SQL|[#1 - 0.28ms - 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-01-10 10:50:38|SQL|[#2 - 0.25ms - 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-01-10 10:50:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDEzNDM4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTcwMzh9.dNYb_CUGLdwrsmcf7eQKcI_NbDMDToj5BBlnYwwiyjs
2026-01-10 10:50:38|INFO|orderList|shopId:
2026-01-10 10:50:38|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768013438,"data":{"ssid":18},"scopes":"role_access","exp":1768017038}
2026-01-10 10:50:38|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2026-01-10 10:50:38|INFO|getOrderList|担当者所属的店铺id:18
2026-01-10 10:50:38|SQL|[#1 - 0.28ms - 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"}}
2026-01-10 10:50:38|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-01-10 10:50:38|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-01-10 10:50:38|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-01-10 10:50:38|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-01-10 10:50:38|SQL|[#3 - 1.48ms - 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"}}
2026-01-10 10:50:38|INFO|getOrderList|查询结果条数:140
2026-01-10 10:50:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDEzNDM4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTcwMzh9.dNYb_CUGLdwrsmcf7eQKcI_NbDMDToj5BBlnYwwiyjs
2026-01-10 10:50:40|SQL|[#1 - 0.66ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 10:50:40|SQL|[#2 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 10:50:45|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDEzNDM4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTcwMzh9.dNYb_CUGLdwrsmcf7eQKcI_NbDMDToj5BBlnYwwiyjs
2026-01-10 10:50:45|SQL|[#1 - 1.5ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:56:20|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:56:20|SQL|[#1 - 1.84ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:56:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDEzNDM4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTcwMzh9.dNYb_CUGLdwrsmcf7eQKcI_NbDMDToj5BBlnYwwiyjs
2026-01-10 10:56:42|SQL|[#1 - 1.87ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:58:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 10:58:13|SQL|[#1 - 1.84ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 10:58:24|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDEzNDM4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTcwMzh9.dNYb_CUGLdwrsmcf7eQKcI_NbDMDToj5BBlnYwwiyjs
2026-01-10 10:58:24|SQL|[#1 - 2.08ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 11:21:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:21:41|SQL|[#1 - 1.18ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 11:21:41|SQL|[#2 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 11:21:42|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:21:42|SQL|[#1 - 0.88ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 11:21:42|SQL|[#2 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 11:21:46|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:21:46|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:21:46|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:21:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:21:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:21:47|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768011851,"data":{"ssid":22},"scopes":"role_access","exp":1768015451}
2026-01-10 11:21:47|SQL|[#1 - 0.47ms - 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-01-10 11:21:47|SQL|[#1 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 22);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2026-01-10 11:21:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:21:47|INFO|orderList|shopId:
2026-01-10 11:21:47|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768011851,"data":{"ssid":22},"scopes":"role_access","exp":1768015451}
2026-01-10 11:21:47|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":22,"$freeword":null,"$orderId":null}
2026-01-10 11:21:47|INFO|getOrderList|担当者所属的店铺id:22
2026-01-10 11:21:47|SQL|[#1 - 0.35ms - 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 = 22);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 11:21:47|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"}}
2026-01-10 11:21:47|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-01-10 11:21:47|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-01-10 11:21:47|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-01-10 11:21:47|SQL|[#3 - 1.16ms - 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"}}
2026-01-10 11:21:47|INFO|getOrderList|查询结果条数:140
2026-01-10 11:21:54|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:21:54|SQL|[#1 - 1.06ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 11:21:54|SQL|[#2 - 0.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 11:21:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:21:58|SQL|[#1 - 1.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-6-01', '2025-7-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 11:22:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:07|SQL|[#1 - 0.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '1' WHERE (order_id = '395');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-01-10 11:22:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:08|SQL|[#1 - 1.9ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-6-01', '2025-7-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 11:22:20|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:20|SQL|[#1 - 0.46ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '0' WHERE (order_id = '395');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-01-10 11:22:20|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:21|SQL|[#1 - 1.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-6-01', '2025-7-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 11:22:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:23|SQL|[#1 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `collection_flag` = '1' WHERE (order_id = '395');|{"request":{"service":"App.Order_Order.updateCollectionFlag"}}
2026-01-10 11:22:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:23|SQL|[#1 - 1.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS payed 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 dat_deposit_withdrawal_record AS dw ON A.deposit_withdrawal_record_id = dw.deposit_withdrawal_record_id WHERE (A.service <> ?) AND (A.ss_return_date BETWEEN ? AND ?) GROUP BY A.Order_ID,A.deposit_withdrawal_record_id; -- 1, '2025-6-01', '2025-7-01'|{"request":{"service":"App.Order_Order.getSalesList"}}
2026-01-10 11:22:29|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:29|SQL|[#1 - 1.08ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536):    App\Model\Order\DatSyakenOrderList::listBySalesByYear()    u433670985_test.dat_syaken_order_list    select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total  from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 11:22:29|SQL|[#2 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13):    App\Model\Sales\MtMcBudget::getBudgetByYear()    u433670985_test.mt_mc_budget    SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}}
2026-01-10 11:22:30|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:22:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:30|INFO|orderList|shopId:
2026-01-10 11:22:30|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768011851,"data":{"ssid":22},"scopes":"role_access","exp":1768015451}
2026-01-10 11:22:30|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":22,"$freeword":null,"$orderId":null}
2026-01-10 11:22:30|INFO|getOrderList|担当者所属的店铺id:22
2026-01-10 11:22:30|SQL|[#1 - 0.28ms - 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 = 22);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 11:22:30|SQL|[#2 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 11:22:30|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-01-10 11:22:30|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-01-10 11:22:30|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-01-10 11:22:30|SQL|[#3 - 1.14ms - 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"}}
2026-01-10 11:22:30|INFO|getOrderList|查询结果条数:140
2026-01-10 11:22:33|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:33|INFO|orderList|shopId:
2026-01-10 11:22:33|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768011851,"data":{"ssid":22},"scopes":"role_access","exp":1768015451}
2026-01-10 11:22:33|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":22,"$freeword":null,"$orderId":"395"}
2026-01-10 11:22:33|INFO|getOrderList|担当者所属的店铺id:22
2026-01-10 11:22:33|SQL|[#1 - 0.45ms - 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 = 22);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 11:22:33|SQL|[#2 - 0.27ms - 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-01-10 11:22:33|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-01-10 11:22:33|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}],"Order_ID":"395"}
2026-01-10 11:22:33|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}],"A.Order_ID":"395"}
2026-01-10 11:22:33|SQL|[#3 - 0.6ms - 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.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22))) AND (A.Order_ID = '395');|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 11:22:33|INFO|getOrderList|查询结果条数:1
2026-01-10 11:22:40|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:22:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:40|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:22:40|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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:22:40|SQL|[#2 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:22:40|SQL|[#3 - 1.96ms - 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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:22:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:40|SQL|[#1 - 0.72ms - 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-01-10 11:22:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:40|INFO|getCarPhotos|params:{"orderId":"395"}
2026-01-10 11:22:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:40|SQL|[#4 - 8.14ms - 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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:22:40|INFO|getOrderPdfs|params:{"orderId":"395"}
2026-01-10 11:22:40|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-01-10 11:22:40|SQL|[#6 - 0.19ms - 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"}}
2026-01-10 11:22:40|SQL|[#7 - 0.53ms - 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-01-10 11:22:40|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:22:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:40|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 = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2026-01-10 11:22:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:40|SQL|[#1 - 0.56ms - 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 = '38');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2026-01-10 11:22:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:51|SQL|[#1 - 0.48ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '395') LIMIT 1;|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:51|SQL|[#2 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecord.php(21):    App\Model\Discount\MtDiscount::getByIds()    u433670985_test.mt_discount    SELECT * FROM mt_discount WHERE (id IN (4, 3));|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:51|SQL|[#3 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecord.php(28):    App\Model\Discount\DatDiscountRecordDetail::removeDiscountByRecordId()    u433670985_test.dat_discount_record_detail    DELETE FROM dat_discount_record_detail WHERE (discount_record_id = 38);|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:51|SQL|[#4 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecord.php(38):    PhalApi\Model\DataModel::insertMore()    u433670985_test.dat_discount_record_detail    INSERT  INTO dat_discount_record_detail (`discount_record_id`, `discount_id`, `price`) VALUES (38, 3, 1000), (38, 4, 1000);|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:51|SQL|[#5 - 0.18ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `discount_record_id` = 38 WHERE (order_id = '395');|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:51|SQL|[#6 - 0.26ms - 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 = '395') LIMIT 1;|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:51|SQL|[#7 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(354):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_deposit_withdrawal_record    SELECT * FROM dat_deposit_withdrawal_record WHERE (deposit_withdrawal_record_id = 43) LIMIT 0,100;|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:51|SQL|[#8 - 0.54ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(369):    PhalApi\Model\DataModel::sum()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT SUM(amount) FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 514);|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:51|SQL|[#9 - 1.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(381):    PhalApi\Model\DataModel::sum()    u433670985_test.dat_repair_estimate_detail    SELECT SUM(request_total_price) FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 509) AND (judge_type <> ?); -- 2|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:51|SQL|[#10 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(393):    PhalApi\Model\DataModel::sum()    u433670985_test.dat_discount_record_detail    SELECT SUM(price) FROM dat_discount_record_detail WHERE (discount_record_id = 38);|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:51|SQL|[#11 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `deposit_withdrawal_total` = 1000 WHERE (order_id = '395');|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:52|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:22:52|SQL|[#1 - 0.43ms - 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 = '395') LIMIT 1;|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:52|SQL|[#2 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecord.php(21):    App\Model\Discount\MtDiscount::getByIds()    u433670985_test.mt_discount    SELECT * FROM mt_discount WHERE (id IN (4));|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:52|SQL|[#3 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecord.php(28):    App\Model\Discount\DatDiscountRecordDetail::removeDiscountByRecordId()    u433670985_test.dat_discount_record_detail    DELETE FROM dat_discount_record_detail WHERE (discount_record_id = 38);|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:52|SQL|[#4 - 0.18ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecord.php(38):    PhalApi\Model\DataModel::insertMore()    u433670985_test.dat_discount_record_detail    INSERT  INTO dat_discount_record_detail (`discount_record_id`, `discount_id`, `price`) VALUES (38, 4, 1000);|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:52|SQL|[#5 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `discount_record_id` = 38 WHERE (order_id = '395');|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:52|SQL|[#6 - 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 = '395') LIMIT 1;|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:52|SQL|[#7 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(354):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_deposit_withdrawal_record    SELECT * FROM dat_deposit_withdrawal_record WHERE (deposit_withdrawal_record_id = 43) LIMIT 0,100;|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:52|SQL|[#8 - 0.47ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(369):    PhalApi\Model\DataModel::sum()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT SUM(amount) FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 514);|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:52|SQL|[#9 - 1.5ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(381):    PhalApi\Model\DataModel::sum()    u433670985_test.dat_repair_estimate_detail    SELECT SUM(request_total_price) FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 509) AND (judge_type <> ?); -- 2|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:52|SQL|[#10 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(393):    PhalApi\Model\DataModel::sum()    u433670985_test.dat_discount_record_detail    SELECT SUM(price) FROM dat_discount_record_detail WHERE (discount_record_id = 38);|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:22:52|SQL|[#11 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `deposit_withdrawal_total` = 0 WHERE (order_id = '395');|{"request":{"service":"App.Order_Order.doSaveDicounts"}}
2026-01-10 11:23:02|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:23:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:23:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:23:03|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:23:03|SQL|[#1 - 0.33ms - 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-01-10 11:23:03|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:23:03|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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:23:03|SQL|[#3 - 0.66ms - 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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:23:03|SQL|[#4 - 1.5ms - 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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:23:03|SQL|[#5 - 0.22ms - 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-01-10 11:23:03|SQL|[#6 - 0.26ms - 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"}}
2026-01-10 11:23:03|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"}}
2026-01-10 11:23:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:23:03|INFO|getOrderPdfs|params:{"orderId":"395"}
2026-01-10 11:23:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:23:03|INFO|getCarPhotos|params:{"orderId":"395"}
2026-01-10 11:23:03|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:23:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:23:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:23:03|SQL|[#1 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = '38');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2026-01-10 11:23:03|SQL|[#1 - 0.69ms - 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-01-10 11:24:09|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:24:09|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:24:09|SQL|[#1 - 0.47ms - 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-01-10 11:24:09|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:24:09|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:24:09|SQL|[#1 - 0.44ms - 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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:09|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:24:09|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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:09|INFO|getCarPhotos|params:{"orderId":"395"}
2026-01-10 11:24:09|SQL|[#3 - 0.74ms - 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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:09|SQL|[#4 - 1.65ms - 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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:09|SQL|[#5 - 0.22ms - 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-01-10 11:24:09|SQL|[#6 - 0.47ms - 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"}}
2026-01-10 11:24:09|SQL|[#7 - 1.18ms - 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-01-10 11:24:09|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:24:09|INFO|getOrderPdfs|params:{"orderId":"395"}
2026-01-10 11:24:09|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:24:09|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:24:09|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:24:09|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-01-10 11:24:09|SQL|[#1 - 0.33ms - 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 = '38');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2026-01-10 11:24:19|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:24:19|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:24:19|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:24:20|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:24:20|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:24:20|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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:20|SQL|[#2 - 0.85ms - 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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:20|SQL|[#3 - 0.66ms - 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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:20|SQL|[#4 - 1.67ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:20|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"}}
2026-01-10 11:24:20|SQL|[#6 - 0.2ms - 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"}}
2026-01-10 11:24:20|SQL|[#7 - 0.18ms - 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-01-10 11:24:20|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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:20|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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:20|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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:20|SQL|[#4 - 1.61ms - 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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:20|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"}}
2026-01-10 11:24:20|SQL|[#6 - 0.19ms - 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"}}
2026-01-10 11:24:20|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"}}
2026-01-10 11:24:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:24:23|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:24:23|SQL|[#1 - 0.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:23|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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:23|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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:23|SQL|[#4 - 1.79ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:23|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"}}
2026-01-10 11:24:23|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 = 23) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:23|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"}}
2026-01-10 11:24:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:24:23|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:24:24|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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:24|SQL|[#2 - 0.23ms - 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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:24|SQL|[#3 - 0.39ms - 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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:24|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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:24|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"}}
2026-01-10 11:24:24|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 = 23) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:24:24|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"}}
2026-01-10 11:25:06|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:25:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:25:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:25:06|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:25:06|SQL|[#1 - 0.35ms - 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-01-10 11:25:06|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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:06|SQL|[#2 - 0.28ms - 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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:06|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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:06|SQL|[#4 - 1.75ms - 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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:06|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"}}
2026-01-10 11:25:06|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 = 23) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:06|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"}}
2026-01-10 11:25:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:25:06|INFO|getCarPhotos|params:{"orderId":"395"}
2026-01-10 11:25:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:25:06|INFO|getOrderPdfs|params:{"orderId":"395"}
2026-01-10 11:25:06|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:25:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:25:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:25:06|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 = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2026-01-10 11:25:06|SQL|[#1 - 0.43ms - 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 = '38');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2026-01-10 11:25:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:25:08|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:25:08|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:25:08|SQL|[#1 - 0.3ms - 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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25: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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:08|SQL|[#3 - 0.41ms - 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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:08|SQL|[#4 - 1ms - 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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:08|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"}}
2026-01-10 11:25:08|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 = 23) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:08|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"}}
2026-01-10 11:25:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:25:08|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:25:08|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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:08|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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:08|SQL|[#3 - 0.54ms - 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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:08|SQL|[#4 - 1.64ms - 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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:08|SQL|[#5 - 0.39ms - 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-01-10 11:25:08|SQL|[#6 - 0.25ms - 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"}}
2026-01-10 11:25: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"}}
2026-01-10 11:25:27|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:25:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:25:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDExODUxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTU0NTF9.vYb6f9yI_vIwdiVm_bnCstfj8ifeC0MmazXDwX4LINM
2026-01-10 11:25:31|INFO|mt_ss login|params:{"loginId":"mecha","pw":"6630_Mecha"}
2026-01-10 11:25:31|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 = 'mecha') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2026-01-10 11:25:31|INFO|mt_ss login|user:{"ID":22,"category":2,"ss_name":"MC","display_name":null,"en_name":"mecha","section":null,"section_id":4,"log_in":"mecha","pw":"6630_Mecha","manager_flag":0,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":null,"rent_a_car":null,"towing":null,"Delete_date":null,"line_openid":"4aHxP8CIZAnRDcfexnWoX90e7ij0gNefQCBYGemP2jZ","zip":null,"address":null,"telno":null,"faxno":null}
2026-01-10 11:25:31|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768015531,"data":{"ssid":22}}
2026-01-10 11:25:31|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:25:31|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:25:31|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:25:32|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:25:32|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:25:32|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768015531,"data":{"ssid":22},"scopes":"role_access","exp":1768019131}
2026-01-10 11:25:32|SQL|[#1 - 0.28ms - 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-01-10 11:25:32|SQL|[#1 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 22);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2026-01-10 11:25:32|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:25:32|INFO|orderList|shopId:
2026-01-10 11:25:32|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768015531,"data":{"ssid":22},"scopes":"role_access","exp":1768019131}
2026-01-10 11:25:32|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":22,"$freeword":null,"$orderId":null}
2026-01-10 11:25:32|INFO|getOrderList|担当者所属的店铺id:22
2026-01-10 11:25:32|SQL|[#1 - 0.28ms - 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 = 22);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 11:25:32|SQL|[#2 - 0.14ms - 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-01-10 11:25:32|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-01-10 11:25:32|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-01-10 11:25:32|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-01-10 11:25:32|SQL|[#3 - 1.04ms - 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"}}
2026-01-10 11:25:32|INFO|getOrderList|查询结果条数:140
2026-01-10 11:25:38|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:25:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:25:38|INFO|orderList|shopId:
2026-01-10 11:25:38|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768015531,"data":{"ssid":22},"scopes":"role_access","exp":1768019131}
2026-01-10 11:25:38|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":22,"$freeword":null,"$orderId":"395"}
2026-01-10 11:25:38|INFO|getOrderList|担当者所属的店铺id:22
2026-01-10 11:25:38|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 = 22);|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 11:25:38|SQL|[#2 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 11:25:38|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-01-10 11:25:38|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}],"Order_ID":"395"}
2026-01-10 11:25:38|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}],"A.Order_ID":"395"}
2026-01-10 11:25:38|SQL|[#3 - 0.56ms - 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.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22))) AND (A.Order_ID = '395');|{"request":{"service":"App.Order_Order.OrderList"}}
2026-01-10 11:25:38|INFO|getOrderList|查询结果条数:1
2026-01-10 11:25:40|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:25:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:25:40|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:25:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:25:40|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"}}
2026-01-10 11:25:40|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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:40|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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:25:40|SQL|[#3 - 0.41ms - 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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:40|INFO|getCarPhotos|params:{"orderId":"395"}
2026-01-10 11:25:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:25:40|INFO|getOrderPdfs|params:{"orderId":"395"}
2026-01-10 11:25:40|SQL|[#4 - 1.2ms - 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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:40|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"}}
2026-01-10 11:25:40|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 = 23) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:40|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"}}
2026-01-10 11:25:40|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:25:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:25:40|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"}}
2026-01-10 11:25:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:25:40|SQL|[#1 - 0.25ms - 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 = '38');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2026-01-10 11:25:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:25:41|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:25:41|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:25:41|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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:41|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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:41|SQL|[#3 - 0.61ms - 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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:41|SQL|[#4 - 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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:41|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"}}
2026-01-10 11:25:41|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 = 23) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:41|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"}}
2026-01-10 11:25:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:25:41|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:25:42|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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:42|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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:42|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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:42|SQL|[#4 - 1ms - 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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:42|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-01-10 11:25:42|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 = 23) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:25:42|SQL|[#7 - 0.18ms - 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-01-10 11:26:39|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:26:39|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:26:39|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:26:39|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:26:39|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:26:39|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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:26:39|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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:26:39|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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:26:39|SQL|[#4 - 1.02ms - 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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:26:39|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"}}
2026-01-10 11:26:39|SQL|[#6 - 0.2ms - 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"}}
2026-01-10 11:26:39|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"}}
2026-01-10 11:26:39|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:26:39|SQL|[#2 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:26:39|SQL|[#3 - 0.65ms - 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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:26:39|SQL|[#4 - 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 = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:26:39|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-01-10 11:26:39|SQL|[#6 - 0.19ms - 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"}}
2026-01-10 11:26:39|SQL|[#7 - 0.18ms - 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-01-10 11:45:15|INFO|JwtAuthorizationFilter check|authorization:
2026-01-10 11:45:15|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:45:15|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MDE1NTMxLCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgwMTkxMzF9.znFAFnQacPCzhQbTv87MsPybU5cbKCIEvpVIxvr5C7Y
2026-01-10 11:45:15|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:45:15|INFO|getOrderDetailInfo|orderId:395
2026-01-10 11:45:15|SQL|[#1 - 0.39ms - 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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:45:15|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 = '395') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:45:15|SQL|[#2 - 0.28ms - 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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:45:15|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 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 = 1773);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:45:15|SQL|[#3 - 0.6ms - 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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:45:15|SQL|[#3 - 0.61ms - 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 = 514) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:45:15|SQL|[#4 - 1.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:45:15|SQL|[#4 - 1.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 509) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2026-01-10 11:45:15|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"}}
2026-01-10 11:45:15|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"}}
2026-01-10 11:45:15|SQL|[#6 - 0.2ms - 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"}}
2026-01-10 11:45:15|SQL|[#6 - 0.26ms - 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"}}
2026-01-10 11:45:15|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"}}
2026-01-10 11:45:15|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"}}