2025-09-05 11:52:42|INFO|JwtAuthorizationFilter check|authorization:
2025-09-05 11:52:42|INFO|JwtAuthorizationFilter check|authorization:
2025-09-05 11:52:55|INFO|mt_ss login|params:{"loginId":"530170","pw":"5366"}
2025-09-05 11:52:55|SQL|[#1 - 0.51ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = '530170') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2025-09-05 11:52:55|INFO|mt_ss login|user:{"ID":2,"category":1,"ss_name":"\u5927\u9580\u5c0f\u6cc9SS","display_name":"Dr.Drive\u5927\u9580\u5c0f\u6cc9\u5e97","en_name":"","section":"\u5449\u897f","section_id":1,"log_in":"530170","pw":"6366","manager_flag":1,"comp_1":"\uff84\uff90\uff7e\uff77","comp_2":"\u5b87\u4f50\u7f8e","comp_3":"\u677e\u5009\u77f3\u6cb9","comp_4":null,"comp_5":null,"test_marketing_flag":null,"rent_a_car":null,"towing":null,"Delete_date":null,"line_openid":"Uc2f645c41a6809b080a7735f2fc03f15","zip":null,"address":"\u5c04\u6c34\u5e02\u5c0f\u6cc9200-1","telno":"0766-26-3335","faxno":null}
2025-09-05 11:53:59|INFO|mt_ss login|params:{"loginId":"530170","pw":"6366"}
2025-09-05 11:53:59|SQL|[#1 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = '530170') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2025-09-05 11:53:59|INFO|mt_ss login|user:{"ID":2,"category":1,"ss_name":"\u5927\u9580\u5c0f\u6cc9SS","display_name":"Dr.Drive\u5927\u9580\u5c0f\u6cc9\u5e97","en_name":"","section":"\u5449\u897f","section_id":1,"log_in":"530170","pw":"6366","manager_flag":1,"comp_1":"\uff84\uff90\uff7e\uff77","comp_2":"\u5b87\u4f50\u7f8e","comp_3":"\u677e\u5009\u77f3\u6cb9","comp_4":null,"comp_5":null,"test_marketing_flag":null,"rent_a_car":null,"towing":null,"Delete_date":null,"line_openid":"Uc2f645c41a6809b080a7735f2fc03f15","zip":null,"address":"\u5c04\u6c34\u5e02\u5c0f\u6cc9200-1","telno":"0766-26-3335","faxno":null}
2025-09-05 11:53:59|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1757044439,"data":{"ssid":2}}
2025-09-05 11:53:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDM5LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODAzOX0.us71wHhxf0CEASxuhEXSArA-NiHKfvtULs1L3mbTosY
2025-09-05 11:53:59|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"}}
2025-09-05 11:53:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDM5LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODAzOX0.us71wHhxf0CEASxuhEXSArA-NiHKfvtULs1L3mbTosY
2025-09-05 11:53:59|INFO|orderList|shopId:
2025-09-05 11:53:59|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1757044439,"data":{"ssid":2},"scopes":"role_access","exp":1757048039}
2025-09-05 11:53:59|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":2,"$freeword":null,"$orderId":null}
2025-09-05 11:53:59|INFO|getOrderList|担当者所属的店铺id:2
2025-09-05 11:53:59|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 = 2);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-09-05 11:53:59|INFO|getOrderList|担当者所属的店铺ids:2
2025-09-05 11:53:59|INFO|getOrderList|where:{"Shop_ID":2}
2025-09-05 11:53:59|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":2}
2025-09-05 11:53:59|SQL|[#2 - 3.39ms - 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 = 2);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-09-05 11:53:59|INFO|getOrderList|查询结果条数:43
2025-09-05 11:53:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDM5LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODAzOX0.us71wHhxf0CEASxuhEXSArA-NiHKfvtULs1L3mbTosY
2025-09-05 11:53:59|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1757044439,"data":{"ssid":2},"scopes":"role_access","exp":1757048039}
2025-09-05 11:53:59|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 2);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-09-05 11:54:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDM5LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODAzOX0.us71wHhxf0CEASxuhEXSArA-NiHKfvtULs1L3mbTosY
2025-09-05 11:54:03|INFO|getOrderDetailInfo|orderId:270
2025-09-05 11:54:03|SQL|[#1 - 1.08ms - 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 = '270') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:03|SQL|[#2 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT 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 = 1591);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:03|SQL|[#3 - 2.47ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 386) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:03|SQL|[#4 - 12.05ms - 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 = 153) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:03|SQL|[#5 - 0.54ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:03|SQL|[#6 - 0.32ms - 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 = 10) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:03|SQL|[#7 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDM5LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODAzOX0.us71wHhxf0CEASxuhEXSArA-NiHKfvtULs1L3mbTosY
2025-09-05 11:54:03|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"}}
2025-09-05 11:54:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDM5LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODAzOX0.us71wHhxf0CEASxuhEXSArA-NiHKfvtULs1L3mbTosY
2025-09-05 11:54:03|INFO|getCarPhotos|params:{"orderId":"270"}
2025-09-05 11:54:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDM5LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODAzOX0.us71wHhxf0CEASxuhEXSArA-NiHKfvtULs1L3mbTosY
2025-09-05 11:54:03|INFO|getOrderPdfs|params:{"orderId":"270"}
2025-09-05 11:54:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDM5LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODAzOX0.us71wHhxf0CEASxuhEXSArA-NiHKfvtULs1L3mbTosY
2025-09-05 11:54:03|SQL|[#1 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-09-05 11:54:05|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDM5LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODAzOX0.us71wHhxf0CEASxuhEXSArA-NiHKfvtULs1L3mbTosY
2025-09-05 11:54:05|INFO|updateToken|jwt:{"iss":"http:\/\/www.shimars.net","iat":1757044439,"data":{"ssid":2},"scopes":"role_access","exp":1757048039}
2025-09-05 11:54:05|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ1LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc4ODE0ODQ0NX0._o7l1YbyZKHpNyehuf0CxsGilLFlFTHR9dIE-foW7WU
2025-09-05 11:54:05|SQL|[#1 - 0.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(298):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_tax    SELECT * FROM mt_tax LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getTax"}}
2025-09-05 11:54:05|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ1LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc4ODE0ODQ0NX0._o7l1YbyZKHpNyehuf0CxsGilLFlFTHR9dIE-foW7WU
2025-09-05 11:54:05|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 = '270') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}}
2025-09-05 11:54:05|SQL|[#2 - 1.74ms - 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 = 153) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairEstimateList"}}
2025-09-05 11:54:05|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ1LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc4ODE0ODQ0NX0._o7l1YbyZKHpNyehuf0CxsGilLFlFTHR9dIE-foW7WU
2025-09-05 11:54:05|SQL|[#1 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtCustomerBasicFee.php(17):    App\Model\Repair\MtCustomerBasicFee::findBasicFeeByOrderId()    u433670985_test.mt_customer_basic_fee     SELECT cbf.* FROM dat_syaken_order_list ord \n            LEFT JOIN dat_customer cust on ord.Customer_ID = cust.base_customerID\n            LEFT JOIN mt_customer_basic_fee cbf on cust.basic_fee_id = cbf.id\n            where ord.Order_ID = ? ; -- '270'|{"request":{"service":"App.OrderDetail_OrderDetail.getCustomerBasicFee"}}
2025-09-05 11:54:05|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ1LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc4ODE0ODQ0NX0._o7l1YbyZKHpNyehuf0CxsGilLFlFTHR9dIE-foW7WU
2025-09-05 11:54:05|SQL|[#1 - 0.49ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtRepairItem.php(18):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_repair_item    SELECT * FROM mt_repair_item LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}}
2025-09-05 11:54:05|SQL|[#2 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(209):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_repair_classification    SELECT * FROM mt_repair_classification LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}}
2025-09-05 11:54:05|SQL|[#3 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(213):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_repair_remarks    SELECT * FROM mt_repair_remarks LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getRepairItemList"}}
2025-09-05 11:54:05|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ1LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc4ODE0ODQ0NX0._o7l1YbyZKHpNyehuf0CxsGilLFlFTHR9dIE-foW7WU
2025-09-05 11:54:05|SQL|[#1 - 0.38ms - 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 = '270') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2025-09-05 11:54:05|SQL|[#2 - 0.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID = 1591);|{"request":{"service":"App.Order_Order.getBudgetData"}}
2025-09-05 11:54:05|SQL|[#3 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Order/Order.php(2385):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 2);|{"request":{"service":"App.Order_Order.getBudgetData"}}
2025-09-05 11:54:05|SQL|[#4 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 10) LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2025-09-05 11:54:05|SQL|[#5 - 0.62ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 386) LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2025-09-05 11:54:05|SQL|[#6 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/MtMiscellaneousExpensesItem.php(11):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_miscellaneous_expenses_item    SELECT * FROM mt_miscellaneous_expenses_item LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2025-09-05 11:54:05|INFO|doSaveBudget|Start handler miscellaneousExpensesDetailList
2025-09-05 11:54:05|INFO|doSaveBudget|End handler miscellaneousExpensesDetailList
2025-09-05 11:54:05|SQL|[#7 - 1.03ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 153) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2025-09-05 11:54:05|SQL|[#8 - 0.14ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id IS NULL);|{"request":{"service":"App.Order_Order.getBudgetData"}}
2025-09-05 11:54:05|SQL|[#9 - 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.Order_Order.getBudgetData"}}
2025-09-05 11:54:05|SQL|[#10 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '270') LIMIT 1;|{"request":{"service":"App.Order_Order.getBudgetData"}}
2025-09-05 11:54:05|INFO|MtRepairUnitPrice|where:{"(repair_item, classification, category, category_detail)":[{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u70b9\u691c","category":"\u6cd5\u5b9a\u70b9\u691c","category_detail":"\u6cd5\u5b9a24\u30f6\u6708\u70b9\u691c\u6599"},{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u6e2c\u5b9a","category":"\u4fdd\u5b89\u691c\u67fb","category_detail":"\u4fdd\u5b89\u78ba\u8a8d\u691c\u67fb\u6599"}]}
2025-09-05 11:54:05|SQL|[#11 - 1.02ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtRepairUnitPrice.php(32):    App\Model\Repair\MtRepairUnitPrice::fetchList()    u433670985_test.mt_repair_unit_price    SELECT * FROM mt_repair_unit_price WHERE ((repair_item, classification, category, category_detail) IN (('基本料金', '点検', '法定点検', '法定24ヶ月点検料'), ('基本料金', '測定', '保安検査', '保安確認検査料')));|{"request":{"service":"App.Order_Order.getBudgetData"}}
2025-09-05 11:54:05|INFO|doSaveBudget|Start handler repairEstimateDetailList
2025-09-05 11:54:05|INFO|doSaveBudget|End handler repairEstimateDetailList
2025-09-05 11:54:05|INFO|doSaveBudget|Start handler discounts
2025-09-05 11:54:05|INFO|doSaveBudget|End handler discounts
2025-09-05 11:54:05|INFO|doSaveBudget|Start handler depositWithdrawalRecords
2025-09-05 11:54:05|INFO|doSaveBudget|End handler depositWithdrawalRecords
2025-09-05 11:54:05|INFO|doSaveBudget|final data: {"cost1":0,"cost2":0,"cost3":0,"cost4":0,"weightPrice":1000,"carTaxPrice":0,"insurancePrice":0,"paperPrice":0,"servicePrice":0,"checkPrice":0,"maintenancePrice":0,"partsPrice":0,"repairPrice":0,"securityPrice":0,"otherPrices":0,"discountPrice":0,"payed":0,"priceTotal":1000,"total":1000,"toPayTotal":-1000,"tax":0}
2025-09-05 11:54:05|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ1LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc4ODE0ODQ0NX0._o7l1YbyZKHpNyehuf0CxsGilLFlFTHR9dIE-foW7WU
2025-09-05 11:54:05|INFO|getOrderDetailInfo|orderId:270
2025-09-05 11:54:05|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 = '270') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:05|SQL|[#2 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1591);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:05|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 = 386) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:05|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 = 153) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:05|SQL|[#5 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:05|SQL|[#6 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 10) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:05|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"}}
2025-09-05 11:54:05|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ1LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc4ODE0ODQ0NX0._o7l1YbyZKHpNyehuf0CxsGilLFlFTHR9dIE-foW7WU
2025-09-05 11:54:05|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 = '270') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}}
2025-09-05 11:54:05|SQL|[#2 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID = 1591);|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}}
2025-09-05 11:54:05|SQL|[#3 - 3.58ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(30):    App\Model\Repair\DatRepairEstimateDetail::getListV1()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (katashiki = 'Ful') AND (NOT repair_item = ?) LIMIT 0,20; -- 'メモ'|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}}
2025-09-05 11:54:05|SQL|[#4 - 1.58ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(41):    App\Model\Repair\DatRepairEstimateDetail::totalByKatashikiAndKeyWord()    u433670985_test.dat_repair_estimate_detail    SELECT COUNT(id) FROM dat_repair_estimate_detail WHERE (katashiki = 'Ful') AND (NOT repair_item = ?); -- 'メモ'|{"request":{"service":"App.OrderDetail_OrderDetail.getHistoryRepairEstimateList"}}
2025-09-05 11:54:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ1LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc4ODE0ODQ0NX0._o7l1YbyZKHpNyehuf0CxsGilLFlFTHR9dIE-foW7WU
2025-09-05 11:54:08|INFO|getOrderPdfs|params:{"orderId":"270"}
2025-09-05 11:54:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ1LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc4ODE0ODQ0NX0._o7l1YbyZKHpNyehuf0CxsGilLFlFTHR9dIE-foW7WU
2025-09-05 11:54:08|INFO|updateToken|jwt:{"iss":"http:\/\/www.shimars.net","iat":1757044445,"data":{"ssid":2},"scopes":"role_access","exp":1788148445}
2025-09-05 11:54:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ1LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc4ODE0ODQ0NX0._o7l1YbyZKHpNyehuf0CxsGilLFlFTHR9dIE-foW7WU
2025-09-05 11:54:08|INFO|getOrderDetailInfo|orderId:270
2025-09-05 11:54:08|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 = '270') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:08|SQL|[#2 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1591);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:08|SQL|[#3 - 0.59ms - 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 = 386) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:08|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 = 153) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:08|SQL|[#5 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:08|SQL|[#6 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 10) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:08|SQL|[#7 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ1LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc4ODE0ODQ0NX0._o7l1YbyZKHpNyehuf0CxsGilLFlFTHR9dIE-foW7WU
2025-09-05 11:54:08|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-09-05 11:54:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ1LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc4ODE0ODQ0NX0._o7l1YbyZKHpNyehuf0CxsGilLFlFTHR9dIE-foW7WU
2025-09-05 11:54:08|INFO|getCarPhotos|params:{"orderId":"270"}
2025-09-05 11:54:09|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:09|SQL|[#1 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-09-05 11:54:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:18|INFO|orderList|shopId:
2025-09-05 11:54:18|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1757044448,"data":{"ssid":2},"scopes":"role_access","exp":1757048048}
2025-09-05 11:54:18|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":2,"$freeword":null,"$orderId":null}
2025-09-05 11:54:18|INFO|getOrderList|担当者所属的店铺id:2
2025-09-05 11:54:18|SQL|[#1 - 0.26ms - 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 = 2);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-09-05 11:54:18|INFO|getOrderList|担当者所属的店铺ids:2
2025-09-05 11:54:18|INFO|getOrderList|where:{"Shop_ID":2}
2025-09-05 11:54:18|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":2}
2025-09-05 11:54:18|SQL|[#2 - 0.76ms - 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 = 2);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-09-05 11:54:18|INFO|getOrderList|查询结果条数:43
2025-09-05 11:54:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:27|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"}}
2025-09-05 11:54:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:27|INFO|getOrderDetailInfo|orderId:356
2025-09-05 11:54:27|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 = '356') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:27|SQL|[#2 - 0.25ms - 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 = 1736);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:27|SQL|[#3 - 0.14ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id IS NULL) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:27|SQL|[#4 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id IS NULL) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:27|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"}}
2025-09-05 11:54:27|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 = 95) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:27|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"}}
2025-09-05 11:54:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:27|INFO|getCarPhotos|params:{"orderId":"356"}
2025-09-05 11:54:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:27|INFO|getOrderPdfs|params:{"orderId":"356"}
2025-09-05 11:54:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:27|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-09-05 11:54:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:37|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-09-05 11:54:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:37|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 = '356') LIMIT 1;|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:54:37|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 = 1736);|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:54:37|SQL|[#3 - 0.43ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Filmthickness/DatVcFilmThickness.php(24):    App\Model\Filmthickness\DatVcFilmThickness::findFilmThicknessByCarId()    u433670985_test.dat_vc_film_thickness    SELECT * FROM dat_vc_film_thickness WHERE (car_id = 1736) LIMIT 1;|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:54:37|SQL|[#4 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/DatVcObd.php(55):    App\Model\OBD\DatVcObd::getObdErrorListByCarId()    u433670985_test.dat_vc_obd    SELECT obd.error_no,oe.message FROM dat_vc_obd AS obd LEFT JOIN mt_obd_error AS oe ON obd.error_no = oe.error_no WHERE (obd.car_id = 1736);|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:54:37|SQL|[#5 - 0.17ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 95) LIMIT 1;|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:54:37|SQL|[#6 - 0.43ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/FormCtrl/MtVcFormCtrl.php(14):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_vc_form_ctrl    SELECT * FROM mt_vc_form_ctrl WHERE (view_id = 'car') LIMIT 0,100;|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:54:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:37|SQL|[#1 - 2.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(23):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_p_car    SELECT * FROM mt_p_car WHERE (month = '2025-09') LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:54:37|SQL|[#2 - 1.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(25):    App\Model\Repair\DatCarsStorageReservation::findPCarUseData()    u433670985_test.dat_cars_storage_reservation     select p.car_id,p.car_num,p.car_name,p.stop_start_time,p.stop_end_time,csr.p_use_start_date,csr.p_use_return_date,cus.customer_name,cus.name,ss.ss_name,csr.Order_ID,csr.ss_storage_date \n                    from mt_p_car as p \n                    left join dat_cars_storage_reservation as csr on p.car_num = csr.p_car_num\n                    left join dat_customer as cus on csr.customer_id = cus.base_customerID\n                    left join mt_ss as ss on csr.ssid = ss.ID\n                    where  p.month = ? and ((csr.p_use_start_date >= ?  and csr.p_use_start_date < ?) or (csr.p_use_return_date >= ?  and csr.p_use_return_date < ?)) order by csr.p_use_start_date; -- '2025-09', '2025-09-01', '2025-10-01', '2025-09-01', '2025-10-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:54:37|SQL|[#3 - 3.51ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(55):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_d_car    SELECT * FROM mt_d_car WHERE (month = '2025-09') AND (ssid = '2') AND (special_flag = 0) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:54:37|SQL|[#4 - 0.83ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(57):    App\Model\Repair\DatCarsStorageReservation::findDCarUseData()    u433670985_test.dat_cars_storage_reservation     select d.car_id,d.car_num,d.car_name,d.stop_start_time,d.stop_end_time,csr.d_use_start_date,csr.d_use_return_date,cus.customer_name,cus.name,ss.ss_name,csr.Order_ID,csr.ss_storage_date \n                    from mt_d_car as d \n                    left join dat_cars_storage_reservation as csr on d.car_num = csr.d_car_num\n                    left join dat_customer as cus on csr.customer_id = cus.base_customerID\n                    left join mt_ss as ss on csr.ssid = ss.ID\n                    where d.special_flag = 0 and d.month = ? and d.ssid = ? and  ((csr.d_use_start_date >= ?  and csr.d_use_start_date < ?) or (csr.d_use_return_date >= ? and csr.d_use_return_date < ?))  order by csr.d_use_start_date; -- '2025-09', '2', '2025-09-01', '2025-10-01', '2025-09-01', '2025-10-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:54:37|SQL|[#5 - 0.78ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(86):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_d_car    SELECT * FROM mt_d_car WHERE (month = '2025-09') AND (special_flag = 1) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:54:37|SQL|[#6 - 0.73ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(88):    App\Model\Repair\DatCarsStorageReservation::findDSpecialCarUseData()    u433670985_test.dat_cars_storage_reservation     select d.car_id,d.car_num,d.car_name,d.stop_start_time,d.stop_end_time,csr.d_use_start_date,csr.d_use_return_date,cus.customer_name,cus.name,csr.Order_ID,csr.ss_storage_date \n                    from mt_d_car as d \n                    left join dat_cars_storage_reservation as csr on d.car_num = csr.d_car_num\n                    left join dat_customer as cus on csr.customer_id = cus.base_customerID\n                    where d.month = ? and d.special_flag = 1 and  ((csr.d_use_start_date >= ?  and csr.d_use_start_date < ?) or (csr.d_use_return_date >= ? and csr.d_use_return_date < ?))  order by csr.d_use_start_date ; -- '2025-09', '2025-09-01', '2025-10-01', '2025-09-01', '2025-10-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:54:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:37|SQL|[#1 - 0.43ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(321):    App\Model\Reserve\MtWorkStation::getSSListByMonth()    u433670985_test.mt_work_station    SELECT * FROM mt_work_station WHERE (month = '2025-09') AND (mc_only = 0);|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:54:37|SQL|[#2 - 0.56ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 137|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:54:37|SQL|[#3 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 138|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:54:37|SQL|[#4 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 139|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:54:37|SQL|[#5 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 140|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:54:37|SQL|[#6 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 141|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:54:37|SQL|[#7 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 142|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:54:37|SQL|[#8 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 143|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:54:37|SQL|[#9 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 144|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:54:37|SQL|[#10 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(355):    App\Model\Reserve\MtWorkDate::getHolidayList()    u433670985_test.mt_work_date    SELECT * FROM mt_work_date WHERE (year = '2025') AND (month = 9);|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:54:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:59|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-09-05 11:54:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:59|INFO|getCarPhotos|params:{"orderId":"356"}
2025-09-05 11:54:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:59|INFO|getOrderDetailInfo|orderId:356
2025-09-05 11:54:59|SQL|[#1 - 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 = '356') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:59|SQL|[#2 - 0.25ms - 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 = 1736);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:59|SQL|[#3 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id IS NULL) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:59|SQL|[#4 - 0.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 IS NULL) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:59|SQL|[#5 - 0.14ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:59|SQL|[#6 - 0.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 95) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:59|SQL|[#7 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:54:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:59|INFO|getOrderPdfs|params:{"orderId":"356"}
2025-09-05 11:54:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:59|SQL|[#1 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id IS NULL);|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-09-05 11:54:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:54:59|SQL|[#1 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-09-05 11:55:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:00|INFO|orderList|shopId:
2025-09-05 11:55:00|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1757044448,"data":{"ssid":2},"scopes":"role_access","exp":1757048048}
2025-09-05 11:55:00|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":2,"$freeword":null,"$orderId":null}
2025-09-05 11:55:00|INFO|getOrderList|担当者所属的店铺id:2
2025-09-05 11:55:00|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 = 2);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-09-05 11:55:00|INFO|getOrderList|担当者所属的店铺ids:2
2025-09-05 11:55:00|INFO|getOrderList|where:{"Shop_ID":2}
2025-09-05 11:55:00|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":2}
2025-09-05 11:55:00|SQL|[#2 - 0.94ms - 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 = 2);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-09-05 11:55:00|INFO|getOrderList|查询结果条数:43
2025-09-05 11:55:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:06|INFO|getOrderPdfs|params:{"orderId":"389"}
2025-09-05 11:55:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:06|SQL|[#1 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-09-05 11:55:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:06|INFO|getCarPhotos|params:{"orderId":"389"}
2025-09-05 11:55:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:06|INFO|getOrderDetailInfo|orderId:389
2025-09-05 11:55:06|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 = '389') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:55:06|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 = 1768);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:55:06|SQL|[#3 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id IS NULL) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:55:06|SQL|[#4 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id IS NULL) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:55:06|SQL|[#5 - 0.42ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:55:06|SQL|[#6 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 23) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:55:06|SQL|[#7 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-09-05 11:55:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:07|SQL|[#1 - 0.43ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-09-05 11:55:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:07|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id IS NULL);|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-09-05 11:55:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:08|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '389') LIMIT 1;|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:55:08|SQL|[#2 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1768);|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:55:08|SQL|[#3 - 0.58ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Filmthickness/DatVcFilmThickness.php(24):    App\Model\Filmthickness\DatVcFilmThickness::findFilmThicknessByCarId()    u433670985_test.dat_vc_film_thickness    SELECT * FROM dat_vc_film_thickness WHERE (car_id = 1768) LIMIT 1;|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:55:08|SQL|[#4 - 0.69ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/DatVcObd.php(55):    App\Model\OBD\DatVcObd::getObdErrorListByCarId()    u433670985_test.dat_vc_obd    SELECT obd.error_no,oe.message FROM dat_vc_obd AS obd LEFT JOIN mt_obd_error AS oe ON obd.error_no = oe.error_no WHERE (obd.car_id = 1768);|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:55:08|SQL|[#5 - 0.51ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/MtObdUnitPrice.php(20):    App\Model\OBD\MtObdUnitPrice::getObdUnitPriceByKatashiki()    u433670985_test.mt_obd_unit_price    SELECT error_no,price FROM `mt_obd_unit_price` \n        where katashiki = :katashiki and price is not null\n        order by error_no; -- 'DBA-K13'|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:55:08|SQL|[#6 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 23) LIMIT 1;|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:55:08|SQL|[#7 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/FormCtrl/MtVcFormCtrl.php(14):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_vc_form_ctrl    SELECT * FROM mt_vc_form_ctrl WHERE (view_id = 'car') LIMIT 0,100;|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-09-05 11:55:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:08|SQL|[#1 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-09-05 11:55:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:08|SQL|[#1 - 0.64ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(23):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_p_car    SELECT * FROM mt_p_car WHERE (month = '2025-09') LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:08|SQL|[#2 - 1.68ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(25):    App\Model\Repair\DatCarsStorageReservation::findPCarUseData()    u433670985_test.dat_cars_storage_reservation     select p.car_id,p.car_num,p.car_name,p.stop_start_time,p.stop_end_time,csr.p_use_start_date,csr.p_use_return_date,cus.customer_name,cus.name,ss.ss_name,csr.Order_ID,csr.ss_storage_date \n                    from mt_p_car as p \n                    left join dat_cars_storage_reservation as csr on p.car_num = csr.p_car_num\n                    left join dat_customer as cus on csr.customer_id = cus.base_customerID\n                    left join mt_ss as ss on csr.ssid = ss.ID\n                    where  p.month = ? and ((csr.p_use_start_date >= ?  and csr.p_use_start_date < ?) or (csr.p_use_return_date >= ?  and csr.p_use_return_date < ?)) order by csr.p_use_start_date; -- '2025-09', '2025-09-01', '2025-10-01', '2025-09-01', '2025-10-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:08|SQL|[#3 - 1.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(55):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_d_car    SELECT * FROM mt_d_car WHERE (month = '2025-09') AND (ssid = '2') AND (special_flag = 0) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:08|SQL|[#4 - 1.14ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(57):    App\Model\Repair\DatCarsStorageReservation::findDCarUseData()    u433670985_test.dat_cars_storage_reservation     select d.car_id,d.car_num,d.car_name,d.stop_start_time,d.stop_end_time,csr.d_use_start_date,csr.d_use_return_date,cus.customer_name,cus.name,ss.ss_name,csr.Order_ID,csr.ss_storage_date \n                    from mt_d_car as d \n                    left join dat_cars_storage_reservation as csr on d.car_num = csr.d_car_num\n                    left join dat_customer as cus on csr.customer_id = cus.base_customerID\n                    left join mt_ss as ss on csr.ssid = ss.ID\n                    where d.special_flag = 0 and d.month = ? and d.ssid = ? and  ((csr.d_use_start_date >= ?  and csr.d_use_start_date < ?) or (csr.d_use_return_date >= ? and csr.d_use_return_date < ?))  order by csr.d_use_start_date; -- '2025-09', '2', '2025-09-01', '2025-10-01', '2025-09-01', '2025-10-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:08|SQL|[#5 - 0.7ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(86):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_d_car    SELECT * FROM mt_d_car WHERE (month = '2025-09') AND (special_flag = 1) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:08|SQL|[#6 - 0.91ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(88):    App\Model\Repair\DatCarsStorageReservation::findDSpecialCarUseData()    u433670985_test.dat_cars_storage_reservation     select d.car_id,d.car_num,d.car_name,d.stop_start_time,d.stop_end_time,csr.d_use_start_date,csr.d_use_return_date,cus.customer_name,cus.name,csr.Order_ID,csr.ss_storage_date \n                    from mt_d_car as d \n                    left join dat_cars_storage_reservation as csr on d.car_num = csr.d_car_num\n                    left join dat_customer as cus on csr.customer_id = cus.base_customerID\n                    where d.month = ? and d.special_flag = 1 and  ((csr.d_use_start_date >= ?  and csr.d_use_start_date < ?) or (csr.d_use_return_date >= ? and csr.d_use_return_date < ?))  order by csr.d_use_start_date ; -- '2025-09', '2025-09-01', '2025-10-01', '2025-09-01', '2025-10-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:08|SQL|[#1 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(321):    App\Model\Reserve\MtWorkStation::getSSListByMonth()    u433670985_test.mt_work_station    SELECT * FROM mt_work_station WHERE (month = '2025-09') AND (mc_only = 0);|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:08|SQL|[#2 - 0.81ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 137|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:08|SQL|[#3 - 0.73ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 138|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:08|SQL|[#4 - 0.53ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 139|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:08|SQL|[#5 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 140|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:08|SQL|[#6 - 0.84ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 141|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:08|SQL|[#7 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 142|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:08|SQL|[#8 - 0.42ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 143|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:08|SQL|[#9 - 0.43ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 144|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:08|SQL|[#10 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(355):    App\Model\Reserve\MtWorkDate::getHolidayList()    u433670985_test.mt_work_date    SELECT * FROM mt_work_date WHERE (year = '2025') AND (month = 9);|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:18|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:18|SQL|[#1 - 1.01ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(398):    App\Model\Reserve\MtPCar::getPCarList()    u433670985_test.mt_p_car    SELECT c.id,c.car_num,c.car_name,CONCAT(c.car_id,?,c.car_name) as car_full_name,c.display_name,CONCAT(c.car_id,?,c.display_name) as display_full_name from mt_p_car c \n        where c.month = ? \n        and ((c.stop_start_time is null or c.stop_start_time > ? )or (c.stop_end_time is null or c.stop_end_time < ?)) \n        and c.car_num not in (SELECT distinct dr.p_car_num from dat_cars_storage_reservation dr \n        where (dr.p_use_start_date <= ?  and dr.p_use_return_date >= ?) \n        or (dr.p_use_start_date <= ?  and dr.p_use_return_date >= ?) \n        or (dr.p_use_start_date >= ? and dr.p_use_return_date <= ?)); -- ':', ':', '2025-09', '2025-09-09 00:00:00', '2025-09-03 00:00:00', '2025-09-03 00:00:00', '2025-09-03 00:00:00', '2025-09-09 00:00:00', '2025-09-09 00:00:00', '2025-09-03 00:00:00', '2025-09-09 00:00:00'|{"request":{"service":"App.OrderDetail_OrderDetail.getPCarList"}}
2025-09-05 11:55:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:26|SQL|[#1 - 1.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(414):    App\Model\Reserve\MtDCar::getDCarList()    u433670985_test.mt_d_car    SELECT c.id,c.car_num,c.car_name,CONCAT(c.car_id,?,c.car_name) as car_full_name from mt_d_car c \n        where c.month = ?  and ((c.ssid = ? and c.special_flag = 0) or c.special_flag = 1 )\n        and ((c.stop_start_time is null or c.stop_start_time > ? )or (c.stop_end_time is null or c.stop_end_time < ?)) \n        and c.car_num not in (SELECT distinct dr.d_car_num from dat_cars_storage_reservation dr \n        where (dr.d_use_start_date <= ?  and dr.d_use_return_date >= ?) \n        or (dr.d_use_start_date <= ?  and dr.d_use_return_date >= ?) \n        or (dr.d_use_start_date >= ? and dr.d_use_return_date <= ?)); -- ':', '2025-09', '2', '2025-09-13 00:00:00', '2025-09-11 00:00:00', '2025-09-11 00:00:00', '2025-09-11 00:00:00', '2025-09-13 00:00:00', '2025-09-13 00:00:00', '2025-09-11 00:00:00', '2025-09-13 00:00:00'|{"request":{"service":"App.OrderDetail_OrderDetail.getDCarList"}}
2025-09-05 11:55:27|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:27|SQL|[#1 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(444):    App\Model\Repair\DatCarsStorageReservation::getStorageDateByOrderId()    u433670985_test.dat_cars_storage_reservation    SELECT * FROM dat_cars_storage_reservation WHERE (Order_ID = '389') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.saveCarStorageReservation"}}
2025-09-05 11:55:27|SQL|[#2 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(451):    App\Model\Reserve\MtWorkStation::getInfoById()    u433670985_test.mt_work_station    SELECT * FROM mt_work_station WHERE (id = '137') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.saveCarStorageReservation"}}
2025-09-05 11:55:27|SQL|[#3 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(452):    App\Model\Repair\DatCarsStorageReservation::getStorageReservationByStationMonth()    u433670985_test.dat_cars_storage_reservation    SELECT * FROM dat_cars_storage_reservation WHERE (station_date = '2025-09') AND (station_days = '3') AND (station_id = '137') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.saveCarStorageReservation"}}
2025-09-05 11:55:27|SQL|[#4 - 5.48ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Model/Repair/DatCarsStorageReservation.php(91):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_cars_storage_reservation    INSERT  INTO dat_cars_storage_reservation (`customer_id`, `car_id`, `car_inspection_date`, `mc_approval_date`, `ss_storage_date`, `self_training`, `p_use_start_date`, `p_use_return_date`, `p_car_name`, `d_use_start_date`, `d_use_return_date`, `d_car_name`, `ssid`, `station_date`, `station_days`, `station_id`, `p_car_num`, `d_car_num`, `Order_ID`, `create_time`) VALUES ('23', '1768', '2024-07-29', '2025-09-05 11:55:27', '2025-09-03 00:00:00', '0', '2025-09-03 00:00:00', '2025-09-09 00:00:00', 'スズキ・アルト', '2025-09-11 00:00:00', '2025-09-13 00:00:00', 'D1:スズキ・ＭＲワゴン', '2', '2025-09', '3', '137', '富山581つ3766', '富山580も7245', '389', '2025-09-05 11:55:27');|{"request":{"service":"App.OrderDetail_OrderDetail.saveCarStorageReservation"}}
2025-09-05 11:55:28|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:28|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(321):    App\Model\Reserve\MtWorkStation::getSSListByMonth()    u433670985_test.mt_work_station    SELECT * FROM mt_work_station WHERE (month = '2025-09') AND (mc_only = 0);|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:28|SQL|[#2 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 137|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:28|SQL|[#3 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 138|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:28|SQL|[#4 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 139|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:28|SQL|[#5 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 140|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:28|SQL|[#6 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 141|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:28|SQL|[#7 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 142|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:28|SQL|[#8 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 143|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:28|SQL|[#9 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 144|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:28|SQL|[#10 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(355):    App\Model\Reserve\MtWorkDate::getHolidayList()    u433670985_test.mt_work_date    SELECT * FROM mt_work_date WHERE (year = '2025') AND (month = 9);|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:28|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:28|SQL|[#1 - 0.54ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(23):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_p_car    SELECT * FROM mt_p_car WHERE (month = '2025-09') LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:28|SQL|[#2 - 1.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(25):    App\Model\Repair\DatCarsStorageReservation::findPCarUseData()    u433670985_test.dat_cars_storage_reservation     select p.car_id,p.car_num,p.car_name,p.stop_start_time,p.stop_end_time,csr.p_use_start_date,csr.p_use_return_date,cus.customer_name,cus.name,ss.ss_name,csr.Order_ID,csr.ss_storage_date \n                    from mt_p_car as p \n                    left join dat_cars_storage_reservation as csr on p.car_num = csr.p_car_num\n                    left join dat_customer as cus on csr.customer_id = cus.base_customerID\n                    left join mt_ss as ss on csr.ssid = ss.ID\n                    where  p.month = ? and ((csr.p_use_start_date >= ?  and csr.p_use_start_date < ?) or (csr.p_use_return_date >= ?  and csr.p_use_return_date < ?)) order by csr.p_use_start_date; -- '2025-09', '2025-09-01', '2025-10-01', '2025-09-01', '2025-10-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:28|SQL|[#3 - 0.69ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(55):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_d_car    SELECT * FROM mt_d_car WHERE (month = '2025-09') AND (ssid = '2') AND (special_flag = 0) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:28|SQL|[#4 - 1.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(57):    App\Model\Repair\DatCarsStorageReservation::findDCarUseData()    u433670985_test.dat_cars_storage_reservation     select d.car_id,d.car_num,d.car_name,d.stop_start_time,d.stop_end_time,csr.d_use_start_date,csr.d_use_return_date,cus.customer_name,cus.name,ss.ss_name,csr.Order_ID,csr.ss_storage_date \n                    from mt_d_car as d \n                    left join dat_cars_storage_reservation as csr on d.car_num = csr.d_car_num\n                    left join dat_customer as cus on csr.customer_id = cus.base_customerID\n                    left join mt_ss as ss on csr.ssid = ss.ID\n                    where d.special_flag = 0 and d.month = ? and d.ssid = ? and  ((csr.d_use_start_date >= ?  and csr.d_use_start_date < ?) or (csr.d_use_return_date >= ? and csr.d_use_return_date < ?))  order by csr.d_use_start_date; -- '2025-09', '2', '2025-09-01', '2025-10-01', '2025-09-01', '2025-10-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:28|SQL|[#5 - 0.62ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(86):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_d_car    SELECT * FROM mt_d_car WHERE (month = '2025-09') AND (special_flag = 1) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:28|SQL|[#6 - 1.08ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(88):    App\Model\Repair\DatCarsStorageReservation::findDSpecialCarUseData()    u433670985_test.dat_cars_storage_reservation     select d.car_id,d.car_num,d.car_name,d.stop_start_time,d.stop_end_time,csr.d_use_start_date,csr.d_use_return_date,cus.customer_name,cus.name,csr.Order_ID,csr.ss_storage_date \n                    from mt_d_car as d \n                    left join dat_cars_storage_reservation as csr on d.car_num = csr.d_car_num\n                    left join dat_customer as cus on csr.customer_id = cus.base_customerID\n                    where d.month = ? and d.special_flag = 1 and  ((csr.d_use_start_date >= ?  and csr.d_use_start_date < ?) or (csr.d_use_return_date >= ? and csr.d_use_return_date < ?))  order by csr.d_use_start_date ; -- '2025-09', '2025-09-01', '2025-10-01', '2025-09-01', '2025-10-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:43|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:43|SQL|[#1 - 0.46ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(409):    App\Model\Reserve\MtDCar::checkDCarState()    u433670985_test.mt_d_car    SELECT dr.id from dat_cars_storage_reservation dr where dr.d_car_num = ? and dr.id <> ?  and ((dr.d_use_start_date <= ?  and dr.d_use_return_date >= ?) \n        or (dr.d_use_start_date <= ?  and dr.d_use_return_date >= ?) \n        or (dr.d_use_start_date >= ? and dr.d_use_return_date <= ?)); -- '富山580も7245', '267', '2025-09-11 00:00:00', '2025-09-11 00:00:00', '2025-09-13 00:00:00', '2025-09-13 00:00:00', '2025-09-11 00:00:00', '2025-09-13 00:00:00'|{"request":{"service":"App.OrderDetail_OrderDetail.getDCarList"}}
2025-09-05 11:55:43|SQL|[#2 - 1.08ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(411):    App\Model\Reserve\MtDCar::getCurrentDCar()    u433670985_test.mt_d_car    SELECT c.id,c.car_num,c.car_name,CONCAT(c.car_id,?,c.car_name) as car_full_name from mt_d_car c \n        where c.month = ? and c.car_num = ?; -- ':', '2025-09', '富山580も7245'|{"request":{"service":"App.OrderDetail_OrderDetail.getDCarList"}}
2025-09-05 11:55:43|SQL|[#3 - 1.52ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(414):    App\Model\Reserve\MtDCar::getDCarList()    u433670985_test.mt_d_car    SELECT c.id,c.car_num,c.car_name,CONCAT(c.car_id,?,c.car_name) as car_full_name from mt_d_car c \n        where c.month = ?  and ((c.ssid = ? and c.special_flag = 0) or c.special_flag = 1 )\n        and ((c.stop_start_time is null or c.stop_start_time > ? )or (c.stop_end_time is null or c.stop_end_time < ?)) \n        and c.car_num not in (SELECT distinct dr.d_car_num from dat_cars_storage_reservation dr \n        where (dr.d_use_start_date <= ?  and dr.d_use_return_date >= ?) \n        or (dr.d_use_start_date <= ?  and dr.d_use_return_date >= ?) \n        or (dr.d_use_start_date >= ? and dr.d_use_return_date <= ?)); -- ':', '2025-09', '2', '2025-09-13 00:00:00', '2025-09-11 00:00:00', '2025-09-11 00:00:00', '2025-09-11 00:00:00', '2025-09-13 00:00:00', '2025-09-13 00:00:00', '2025-09-11 00:00:00', '2025-09-13 00:00:00'|{"request":{"service":"App.OrderDetail_OrderDetail.getDCarList"}}
2025-09-05 11:55:43|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:43|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(393):    App\Model\Reserve\MtPCar::checkPCarState()    u433670985_test.mt_p_car    SELECT dr.id from dat_cars_storage_reservation dr \n        where dr.p_car_num = ? and dr.id <> ? and ((dr.p_use_start_date <= ?  and dr.p_use_return_date >= ?) \n        or (dr.p_use_start_date <= ?  and dr.p_use_return_date >= ?) \n        or (dr.p_use_start_date >= ? and dr.p_use_return_date <= ?)); -- '富山581つ3766', '267', '2025-09-03 00:00:00', '2025-09-03 00:00:00', '2025-09-09 00:00:00', '2025-09-09 00:00:00', '2025-09-03 00:00:00', '2025-09-09 00:00:00'|{"request":{"service":"App.OrderDetail_OrderDetail.getPCarList"}}
2025-09-05 11:55:43|SQL|[#2 - 0.5ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(395):    App\Model\Reserve\MtPCar::getCurrentPCar()    u433670985_test.mt_p_car    SELECT c.id,c.car_num,c.car_name,CONCAT(c.car_id,?,c.car_name) as car_full_name,c.display_name,CONCAT(c.car_id,?,c.display_name) as display_full_name from mt_p_car c \n        where c.month = ? and c.car_num = ?; -- ':', ':', '2025-09', '富山581つ3766'|{"request":{"service":"App.OrderDetail_OrderDetail.getPCarList"}}
2025-09-05 11:55:43|SQL|[#3 - 0.67ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(398):    App\Model\Reserve\MtPCar::getPCarList()    u433670985_test.mt_p_car    SELECT c.id,c.car_num,c.car_name,CONCAT(c.car_id,?,c.car_name) as car_full_name,c.display_name,CONCAT(c.car_id,?,c.display_name) as display_full_name from mt_p_car c \n        where c.month = ? \n        and ((c.stop_start_time is null or c.stop_start_time > ? )or (c.stop_end_time is null or c.stop_end_time < ?)) \n        and c.car_num not in (SELECT distinct dr.p_car_num from dat_cars_storage_reservation dr \n        where (dr.p_use_start_date <= ?  and dr.p_use_return_date >= ?) \n        or (dr.p_use_start_date <= ?  and dr.p_use_return_date >= ?) \n        or (dr.p_use_start_date >= ? and dr.p_use_return_date <= ?)); -- ':', ':', '2025-09', '2025-09-09 00:00:00', '2025-09-03 00:00:00', '2025-09-03 00:00:00', '2025-09-03 00:00:00', '2025-09-09 00:00:00', '2025-09-09 00:00:00', '2025-09-03 00:00:00', '2025-09-09 00:00:00'|{"request":{"service":"App.OrderDetail_OrderDetail.getPCarList"}}
2025-09-05 11:55:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:47|SQL|[#1 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(393):    App\Model\Reserve\MtPCar::checkPCarState()    u433670985_test.mt_p_car    SELECT dr.id from dat_cars_storage_reservation dr \n        where dr.p_car_num = ? and dr.id <> ? and ((dr.p_use_start_date <= ?  and dr.p_use_return_date >= ?) \n        or (dr.p_use_start_date <= ?  and dr.p_use_return_date >= ?) \n        or (dr.p_use_start_date >= ? and dr.p_use_return_date <= ?)); -- '富山581つ3766', '267', '2025-09-03 00:00:00', '2025-09-03 00:00:00', '2025-09-10 00:00:00', '2025-09-10 00:00:00', '2025-09-03 00:00:00', '2025-09-10 00:00:00'|{"request":{"service":"App.OrderDetail_OrderDetail.getPCarList"}}
2025-09-05 11:55:47|SQL|[#2 - 0.68ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(395):    App\Model\Reserve\MtPCar::getCurrentPCar()    u433670985_test.mt_p_car    SELECT c.id,c.car_num,c.car_name,CONCAT(c.car_id,?,c.car_name) as car_full_name,c.display_name,CONCAT(c.car_id,?,c.display_name) as display_full_name from mt_p_car c \n        where c.month = ? and c.car_num = ?; -- ':', ':', '2025-09', '富山581つ3766'|{"request":{"service":"App.OrderDetail_OrderDetail.getPCarList"}}
2025-09-05 11:55:47|SQL|[#3 - 1.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(398):    App\Model\Reserve\MtPCar::getPCarList()    u433670985_test.mt_p_car    SELECT c.id,c.car_num,c.car_name,CONCAT(c.car_id,?,c.car_name) as car_full_name,c.display_name,CONCAT(c.car_id,?,c.display_name) as display_full_name from mt_p_car c \n        where c.month = ? \n        and ((c.stop_start_time is null or c.stop_start_time > ? )or (c.stop_end_time is null or c.stop_end_time < ?)) \n        and c.car_num not in (SELECT distinct dr.p_car_num from dat_cars_storage_reservation dr \n        where (dr.p_use_start_date <= ?  and dr.p_use_return_date >= ?) \n        or (dr.p_use_start_date <= ?  and dr.p_use_return_date >= ?) \n        or (dr.p_use_start_date >= ? and dr.p_use_return_date <= ?)); -- ':', ':', '2025-09', '2025-09-10 00:00:00', '2025-09-03 00:00:00', '2025-09-03 00:00:00', '2025-09-03 00:00:00', '2025-09-10 00:00:00', '2025-09-10 00:00:00', '2025-09-03 00:00:00', '2025-09-10 00:00:00'|{"request":{"service":"App.OrderDetail_OrderDetail.getPCarList"}}
2025-09-05 11:55:52|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:52|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(427):    App\Model\Reserve\MtPCar::checkPCarState()    u433670985_test.mt_p_car    SELECT dr.id from dat_cars_storage_reservation dr \n        where dr.p_car_num = ? and dr.id <> ? and ((dr.p_use_start_date <= ?  and dr.p_use_return_date >= ?) \n        or (dr.p_use_start_date <= ?  and dr.p_use_return_date >= ?) \n        or (dr.p_use_start_date >= ? and dr.p_use_return_date <= ?)); -- '富山581つ3766', '267', '2025-09-03 00:00:00', '2025-09-03 00:00:00', '2025-09-10 00:00:00', '2025-09-10 00:00:00', '2025-09-03 00:00:00', '2025-09-10 00:00:00'|{"request":{"service":"App.OrderDetail_OrderDetail.saveCarStorageReservation"}}
2025-09-05 11:55:52|SQL|[#2 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(436):    App\Model\Reserve\MtDCar::checkDCarState()    u433670985_test.mt_d_car    SELECT dr.id from dat_cars_storage_reservation dr where dr.d_car_num = ? and dr.id <> ?  and ((dr.d_use_start_date <= ?  and dr.d_use_return_date >= ?) \n        or (dr.d_use_start_date <= ?  and dr.d_use_return_date >= ?) \n        or (dr.d_use_start_date >= ? and dr.d_use_return_date <= ?)); -- '富山580も7245', '267', '2025-09-11 00:00:00', '2025-09-11 00:00:00', '2025-09-13 00:00:00', '2025-09-13 00:00:00', '2025-09-11 00:00:00', '2025-09-13 00:00:00'|{"request":{"service":"App.OrderDetail_OrderDetail.saveCarStorageReservation"}}
2025-09-05 11:55:52|SQL|[#3 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(451):    App\Model\Reserve\MtWorkStation::getInfoById()    u433670985_test.mt_work_station    SELECT * FROM mt_work_station WHERE (id = '137') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.saveCarStorageReservation"}}
2025-09-05 11:55:52|SQL|[#4 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(452):    App\Model\Repair\DatCarsStorageReservation::getStorageReservationByStationMonth()    u433670985_test.dat_cars_storage_reservation    SELECT * FROM dat_cars_storage_reservation WHERE (station_date = '2025-09') AND (station_days = '3') AND (station_id = '137') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.saveCarStorageReservation"}}
2025-09-05 11:55:52|SQL|[#5 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(477):    App\Model\Repair\DatCarsStorageReservation::getStorageReservationById()    u433670985_test.dat_cars_storage_reservation    SELECT * FROM dat_cars_storage_reservation WHERE (id = '267') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.saveCarStorageReservation"}}
2025-09-05 11:55:52|SQL|[#6 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(503):    App\Model\Repair\DatCarsStorageReservation::saveCarsStorageReservation()    u433670985_test.dat_cars_storage_reservation    UPDATE dat_cars_storage_reservation SET `id` = '267', `customer_id` = '23', `car_id` = '1768', `car_inspection_date` = '2024-07-29', `mc_approval_date` = '2025-09-05 11:55:52', `ss_storage_date` = '2025-09-03 00:00:00', `self_training` = '0', `p_use_start_date` = '2025-09-03 00:00:00', `p_use_return_date` = '2025-09-10 00:00:00', `p_car_name` = 'スズキ・アルト', `d_use_start_date` = '2025-09-11 00:00:00', `d_use_return_date` = '2025-09-13 00:00:00', `d_car_name` = 'D1:スズキ・ＭＲワゴン', `ssid` = '2', `station_date` = '2025-09', `station_days` = '3', `station_id` = '137', `p_car_num` = '富山581つ3766', `d_car_num` = '富山580も7245', `Order_ID` = '389', `update_time` = '2025-09-05 11:55:52' WHERE (id = '267');|{"request":{"service":"App.OrderDetail_OrderDetail.saveCarStorageReservation"}}
2025-09-05 11:55:53|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:53|SQL|[#1 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(321):    App\Model\Reserve\MtWorkStation::getSSListByMonth()    u433670985_test.mt_work_station    SELECT * FROM mt_work_station WHERE (month = '2025-09') AND (mc_only = 0);|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:53|SQL|[#2 - 0.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 137|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:53|SQL|[#3 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 138|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:53|SQL|[#4 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 139|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:53|SQL|[#5 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 140|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:53|SQL|[#6 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 141|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:53|SQL|[#7 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 142|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:53|SQL|[#8 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 143|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:53|SQL|[#9 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(334):    App\Model\Repair\DatCarsStorageReservation::getListByStationMonthV2()    u433670985_test.dat_cars_storage_reservation    select csr.*,cus.customer_name,cus.name,car.Car_Name,ms.en_name,ms.ss_name from dat_cars_storage_reservation as csr\nleft join dat_customer as cus on csr.customer_id = cus.base_customerID\nleft join dat_cars as car on csr.car_id = car.CarID\nleft join mt_ss as ms on csr.ssid = ms.ID\nwhere csr.station_date = ? and station_id = ? ; -- '2025-09', 144|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:53|SQL|[#10 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(355):    App\Model\Reserve\MtWorkDate::getHolidayList()    u433670985_test.mt_work_date    SELECT * FROM mt_work_date WHERE (year = '2025') AND (month = 9);|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-09-05 11:55:53|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzU3MDQ0NDQ4LCJkYXRhIjp7InNzaWQiOjJ9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1NzA0ODA0OH0.Qy2nI7xZg_366h27ika24lejGjUMKsghASBOy16wQzk
2025-09-05 11:55:53|SQL|[#1 - 0.76ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(23):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_p_car    SELECT * FROM mt_p_car WHERE (month = '2025-09') LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:53|SQL|[#2 - 1.57ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(25):    App\Model\Repair\DatCarsStorageReservation::findPCarUseData()    u433670985_test.dat_cars_storage_reservation     select p.car_id,p.car_num,p.car_name,p.stop_start_time,p.stop_end_time,csr.p_use_start_date,csr.p_use_return_date,cus.customer_name,cus.name,ss.ss_name,csr.Order_ID,csr.ss_storage_date \n                    from mt_p_car as p \n                    left join dat_cars_storage_reservation as csr on p.car_num = csr.p_car_num\n                    left join dat_customer as cus on csr.customer_id = cus.base_customerID\n                    left join mt_ss as ss on csr.ssid = ss.ID\n                    where  p.month = ? and ((csr.p_use_start_date >= ?  and csr.p_use_start_date < ?) or (csr.p_use_return_date >= ?  and csr.p_use_return_date < ?)) order by csr.p_use_start_date; -- '2025-09', '2025-09-01', '2025-10-01', '2025-09-01', '2025-10-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:53|SQL|[#3 - 1.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(55):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_d_car    SELECT * FROM mt_d_car WHERE (month = '2025-09') AND (ssid = '2') AND (special_flag = 0) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:53|SQL|[#4 - 1.93ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(57):    App\Model\Repair\DatCarsStorageReservation::findDCarUseData()    u433670985_test.dat_cars_storage_reservation     select d.car_id,d.car_num,d.car_name,d.stop_start_time,d.stop_end_time,csr.d_use_start_date,csr.d_use_return_date,cus.customer_name,cus.name,ss.ss_name,csr.Order_ID,csr.ss_storage_date \n                    from mt_d_car as d \n                    left join dat_cars_storage_reservation as csr on d.car_num = csr.d_car_num\n                    left join dat_customer as cus on csr.customer_id = cus.base_customerID\n                    left join mt_ss as ss on csr.ssid = ss.ID\n                    where d.special_flag = 0 and d.month = ? and d.ssid = ? and  ((csr.d_use_start_date >= ?  and csr.d_use_start_date < ?) or (csr.d_use_return_date >= ? and csr.d_use_return_date < ?))  order by csr.d_use_start_date; -- '2025-09', '2', '2025-09-01', '2025-10-01', '2025-09-01', '2025-10-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:53|SQL|[#5 - 1.04ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(86):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_d_car    SELECT * FROM mt_d_car WHERE (month = '2025-09') AND (special_flag = 1) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-09-05 11:55:53|SQL|[#6 - 1.51ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatCarsStorageReservation.php(88):    App\Model\Repair\DatCarsStorageReservation::findDSpecialCarUseData()    u433670985_test.dat_cars_storage_reservation     select d.car_id,d.car_num,d.car_name,d.stop_start_time,d.stop_end_time,csr.d_use_start_date,csr.d_use_return_date,cus.customer_name,cus.name,csr.Order_ID,csr.ss_storage_date \n                    from mt_d_car as d \n                    left join dat_cars_storage_reservation as csr on d.car_num = csr.d_car_num\n                    left join dat_customer as cus on csr.customer_id = cus.base_customerID\n                    where d.month = ? and d.special_flag = 1 and  ((csr.d_use_start_date >= ?  and csr.d_use_start_date < ?) or (csr.d_use_return_date >= ? and csr.d_use_return_date < ?))  order by csr.d_use_start_date ; -- '2025-09', '2025-09-01', '2025-10-01', '2025-09-01', '2025-10-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}