2025-07-05 09:04:28|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"}
2025-07-05 09:04:28|SQL|[#1 - 0.57ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = 'admin') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2025-07-05 09:04:28|INFO|mt_ss login|user:{"ID":18,"category":9,"ss_name":"admin","display_name":null,"en_name":"admin","section":null,"section_id":null,"log_in":"admin","pw":"urutoraman1","manager_flag":1,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":1,"rent_a_car":1,"towing":null,"Delete_date":null,"line_openid":"C","zip":null,"address":null,"telno":null,"faxno":null}
2025-07-05 09:04:28|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1751677468,"data":{"ssid":18}}
2025-07-05 09:04:28|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:28|INFO|orderList|shopId:
2025-07-05 09:04:28|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1751677468,"data":{"ssid":18},"scopes":"role_access","exp":1751681068}
2025-07-05 09:04:28|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-07-05 09:04:28|INFO|getOrderList|担当者所属的店铺id:18
2025-07-05 09:04:28|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(167):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-05 09:04:28|SQL|[#2 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-05 09:04:28|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-07-05 09:04:28|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-05 09:04:28|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-05 09:04:28|SQL|[#3 - 3.95ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(212):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-05 09:04:28|INFO|getOrderList|查询结果条数:128
2025-07-05 09:04:28|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:28|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-07-05 09:04:28|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:28|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1751677468,"data":{"ssid":18},"scopes":"role_access","exp":1751681068}
2025-07-05 09:04:28|SQL|[#1 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-07-05 09:04:28|SQL|[#2 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(63):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (category <> ?) LIMIT 0,100; -- 9|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}}
2025-07-05 09:04:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:30|INFO|getOrderDetailInfo|orderId:220
2025-07-05 09:04:30|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 = '220') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:04:30|SQL|[#2 - 0.5ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1489);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:04:30|SQL|[#3 - 1.97ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 496) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:04:30|SQL|[#4 - 8.56ms - 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 = 500) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:04:30|SQL|[#5 - 0.41ms - 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-07-05 09:04:30|SQL|[#6 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 7) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:04:30|SQL|[#7 - 0.38ms - 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-07-05 09:04:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:30|SQL|[#1 - 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.Discount_Discount.list"}}
2025-07-05 09:04:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:30|INFO|getCarPhotos|params:{"orderId":"220"}
2025-07-05 09:04:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:30|INFO|getOrderPdfs|params:{"orderId":"220"}
2025-07-05 09:04:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:30|SQL|[#1 - 0.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-07-05 09:04:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:31|SQL|[#1 - 0.49ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = '9');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-07-05 09:04:31|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:31|INFO|viewImg|params:{"path":"\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/cars\/","fileName":"220_1748053751851_car.jpg"}
2025-07-05 09:04:31|INFO|viewImg|imgPath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/cars/220_1748053751851_car.jpg
2025-07-05 09:04:34|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:34|INFO|orderList|shopId:
2025-07-05 09:04:34|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1751677468,"data":{"ssid":18},"scopes":"role_access","exp":1751681068}
2025-07-05 09:04:34|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-07-05 09:04:34|INFO|getOrderList|担当者所属的店铺id:18
2025-07-05 09:04:34|SQL|[#1 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(167):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-05 09:04:34|SQL|[#2 - 0.14ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-05 09:04:34|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-07-05 09:04:34|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-05 09:04:34|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-05 09:04:34|SQL|[#3 - 2.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(212):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-05 09:04:34|INFO|getOrderList|查询结果条数:128
2025-07-05 09:04:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:37|INFO|getOrderDetailInfo|orderId:222
2025-07-05 09:04:37|SQL|[#1 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '222') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:04:37|SQL|[#2 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1549);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:04:37|SQL|[#3 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 156) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:04:37|SQL|[#4 - 1.01ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 510) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:04:37|SQL|[#5 - 0.12ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:04:37|SQL|[#6 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 14) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:04:37|SQL|[#7 - 0.14ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:04:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:37|SQL|[#1 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-07-05 09:04:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:37|INFO|getCarPhotos|params:{"orderId":"222"}
2025-07-05 09:04:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:37|INFO|getOrderPdfs|params:{"orderId":"222"}
2025-07-05 09:04:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:37|SQL|[#1 - 0.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-07-05 09:04:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:37|SQL|[#1 - 0.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = '11');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-07-05 09:04:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:04:41|INFO|orderList|shopId:
2025-07-05 09:04:41|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1751677468,"data":{"ssid":18},"scopes":"role_access","exp":1751681068}
2025-07-05 09:04:41|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-07-05 09:04:41|INFO|getOrderList|担当者所属的店铺id:18
2025-07-05 09:04:41|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(167):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-05 09:04:41|SQL|[#2 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-05 09:04:41|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-07-05 09:04:41|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-05 09:04:41|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-05 09:04:41|SQL|[#3 - 1.01ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(212):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-05 09:04:41|INFO|getOrderList|查询结果条数:128
2025-07-05 09:07:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:06|INFO|getCarPhotos|params:{"orderId":"220"}
2025-07-05 09:07:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:06|INFO|getOrderDetailInfo|orderId:220
2025-07-05 09:07:06|SQL|[#1 - 0.53ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '220') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:06|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 CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1489);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:06|SQL|[#3 - 0.78ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 496) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:06|SQL|[#4 - 1.99ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 500) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:06|SQL|[#5 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:06|SQL|[#6 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 7) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:06|SQL|[#7 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:06|INFO|getOrderPdfs|params:{"orderId":"220"}
2025-07-05 09:07:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:06|SQL|[#1 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-07-05 09:07:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:06|INFO|viewImg|params:{"path":"\/home\/u433670985\/domains\/test.yaog.tech\/public_html\/phpapi\/config\/..\/..\/..\/public_html\/car\/detail\/upload\/cars\/","fileName":"220_1748053751851_car.jpg"}
2025-07-05 09:07:06|INFO|viewImg|imgPath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/cars/220_1748053751851_car.jpg
2025-07-05 09:07:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:06|SQL|[#1 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-07-05 09:07:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:06|SQL|[#1 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = '9');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-07-05 09:07:09|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:09|INFO|orderList|shopId:
2025-07-05 09:07:09|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1751677468,"data":{"ssid":18},"scopes":"role_access","exp":1751681068}
2025-07-05 09:07:09|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-07-05 09:07:09|INFO|getOrderList|担当者所属的店铺id:18
2025-07-05 09:07:09|SQL|[#1 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(167):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-05 09:07:09|SQL|[#2 - 0.14ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-05 09:07:09|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-07-05 09:07:09|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-05 09:07:09|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-05 09:07:09|SQL|[#3 - 0.97ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(212):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-05 09:07:09|INFO|getOrderList|查询结果条数:128
2025-07-05 09:07:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:11|SQL|[#1 - 0.17ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-07-05 09:07:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:11|INFO|getCarPhotos|params:{"orderId":"222"}
2025-07-05 09:07:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:11|INFO|getOrderPdfs|params:{"orderId":"222"}
2025-07-05 09:07:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:11|INFO|getOrderDetailInfo|orderId:222
2025-07-05 09:07:11|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 = '222') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:11|SQL|[#2 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1549);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:11|SQL|[#3 - 0.53ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 156) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:11|SQL|[#4 - 1.46ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 510) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:11|SQL|[#5 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:11|SQL|[#6 - 0.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 14) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:11|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-07-05 09:07:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:11|SQL|[#1 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/DatDiscountRecordDetail.php(16):    App\Model\Discount\DatDiscountRecordDetail::getDiscountByRecordId()    u433670985_test.dat_discount_record_detail    SELECT * FROM dat_discount_record_detail WHERE (discount_record_id = '11');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-07-05 09:07:11|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:11|SQL|[#1 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-07-05 09:07:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:13|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 = '222') LIMIT 1;|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-07-05 09:07:13|SQL|[#2 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1549);|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-07-05 09:07:13|SQL|[#3 - 0.45ms - 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 = 1549) LIMIT 1;|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-07-05 09:07:13|SQL|[#4 - 0.47ms - 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 = 1549);|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-07-05 09:07:13|SQL|[#5 - 0.5ms - 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-GSE20'|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-07-05 09:07:13|SQL|[#6 - 0.23ms - 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 = 14) LIMIT 1;|{"request":{"service":"App.Order_Order.GetOrderInfo"}}
2025-07-05 09:07:13|SQL|[#7 - 0.49ms - 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-07-05 09:07:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:13|SQL|[#1 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '18');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-07-05 09:07:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:13|SQL|[#1 - 2.67ms - 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-07') LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-07-05 09:07:13|SQL|[#2 - 17.99ms - 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-07', '2025-07-01', '2025-08-01', '2025-07-01', '2025-08-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-07-05 09:07:13|SQL|[#3 - 4.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-07') AND (ssid = '1') AND (special_flag = 0) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-07-05 09:07:13|SQL|[#4 - 0.79ms - 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-07', '1', '2025-07-01', '2025-08-01', '2025-07-01', '2025-08-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-07-05 09:07:13|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-07') AND (special_flag = 1) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-07-05 09:07:13|SQL|[#6 - 0.65ms - 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-07', '2025-07-01', '2025-08-01', '2025-07-01', '2025-08-01'|{"request":{"service":"App.OrderDetail_OrderDetail.getCarStorageReservationInfo"}}
2025-07-05 09:07:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:13|SQL|[#1 - 0.77ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(323):    App\Model\Reserve\MtWorkStation::getListByMonth()    u433670985_test.mt_work_station    SELECT * FROM mt_work_station WHERE (month = '2025-07');|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:13|SQL|[#2 - 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-07', 121|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:13|SQL|[#3 - 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-07', 122|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:13|SQL|[#4 - 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-07', 123|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:13|SQL|[#5 - 0.33ms - 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-07', 124|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:13|SQL|[#6 - 0.32ms - 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-07', 125|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:13|SQL|[#7 - 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-07', 126|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:13|SQL|[#8 - 0.33ms - 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-07', 127|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:13|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-07', 128|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:13|SQL|[#10 - 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-07', 172|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:13|SQL|[#11 - 0.24ms - 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-07', 173|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:13|SQL|[#12 - 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-07', 174|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:13|SQL|[#13 - 0.51ms - 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 = 7);|{"request":{"service":"App.OrderDetail_OrderDetail.getWorkStationConfig"}}
2025-07-05 09:07:52|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:52|INFO|getOrderDetailInfo|orderId:222
2025-07-05 09:07:52|SQL|[#1 - 0.47ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '222') LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:52|SQL|[#2 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1549);|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:52|SQL|[#3 - 0.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(25):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT * FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 156) LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:52|SQL|[#4 - 0.97ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_repair_estimate_detail    SELECT * FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 510) ORDER BY sort asc LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:52|SQL|[#5 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:52|SQL|[#6 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(70):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 14) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:52|SQL|[#7 - 0.17ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(78):    App\Model\Repair\MtCustomerBasicFee::getById()    u433670985_test.mt_customer_basic_fee    SELECT * FROM mt_customer_basic_fee WHERE (id = 1) LIMIT 1;|{"request":{"service":"App.OrderDetail_OrderDetail.getOrderDetailInfo"}}
2025-07-05 09:07:52|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:52|INFO|getCarPhotos|params:{"orderId":"222"}
2025-07-05 09:07:52|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:52|INFO|getOrderPdfs|params:{"orderId":"222"}
2025-07-05 09:07:52|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:52|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Discount/MtDiscount.php(21):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_discount    SELECT * FROM mt_discount LIMIT 0,100;|{"request":{"service":"App.Discount_Discount.list"}}
2025-07-05 09:07:52|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:52|SQL|[#1 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '1');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2025-07-05 09:07:52|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjc3NDY4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTE2ODEwNjh9.bhWSh4WAqb0KLmpIa6npUyBAReeNW1BKpDhpMPgrIg8
2025-07-05 09:07:52|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 = '11');|{"request":{"service":"App.Discount_Discount.listByRecordId"}}
2025-07-05 10:11:41|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUxNjEwMjcwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MTg2OTQ3MH0.Lnn1m3djXO02JXPn9Y11AYi5mWP7TNCpziS9TiYxM3E
2025-07-05 10:11:41|INFO|logout|params:{"orderId":"353","timestamp":"1751610139"}
2025-07-05 10:11:41|SQL|[#1 - 0.93ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_order_uuid    SELECT * FROM dat_order_uuid WHERE (order_id = '353') AND (ts <= ?) LIMIT 0,1; -- '1751610139'|{"request":{"service":"App.Order_Order.logout"}}
2025-07-05 10:11:41|SQL|[#2 - 0.15ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatOrderUuid.php(53):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_order_uuid    SELECT * FROM dat_order_uuid WHERE (order_id = '353') LIMIT 0,100;|{"request":{"service":"App.Order_Order.logout"}}
2025-07-05 10:11:41|SQL|[#3 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Order/Order.php(1311):    App\Domain\Order\DatOrderUuid::deleteByOrderId()    u433670985_test.dat_order_uuid    DELETE FROM dat_order_uuid WHERE (id = 450);|{"request":{"service":"App.Order_Order.logout"}}
2025-07-05 10:11:41|INFO|logout|delete count:1
2025-07-05 10:11:41|SQL|[#4 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `check_state` = 0 WHERE (order_id = '353');|{"request":{"service":"App.Order_Order.logout"}}