2026-01-16 08:53:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 10:52:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 10:54:39|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 10:58:55|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 11:03:15|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 11:08:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 11:25:33|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 11:25:33|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 11:25:56|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 11:26:05|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 11:26:32|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 11:26:32|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 11:28:08|INFO|mt_ss getSsInfoFromSession|sessionUserName: 2026-01-16 11:28:45|INFO|JwtAuthorizationFilter check|authorization: 2026-01-16 12:12:14|INFO|mt_ss getSsInfoFromSession|sessionUserName: 2026-01-16 12:12:29|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM2NzM0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5NTkzNH0.Ue1tRi8Hk7QuCuqB8Nmo9pp2YR_j1v2n-kkuelfz5FQ 2026-01-16 12:12:29|INFO|customerList|params:{} customerNameKensaku=アップロード 2026-01-16 12:12:29|SQL|[#1 - 3.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(35): App\Model\Customer\DatCustomer::queryList() u433670985_test.dat_customer SELECT ctm.base_customerID as customerId,ctm.customer_name as customerName,ctm.name,ctm.customer_telnumber as customerTelnumber,ss.ss_name as ssName FROM dat_customer AS ctm LEFT JOIN mt_ss AS ss ON ctm.shop_id = ss.ID WHERE (ctm.delete_date is null and concat(ctm.kensaku, ctm.customer_name_kensaku) LIKE ?); -- '%アップロード%'|{"request":{"service":"App.Customer_Customer.customerList"}} 2026-01-16 12:12:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 12:12:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 12:22:51|INFO|mt_ss getSsInfoFromSession|sessionUserName: 2026-01-16 12:23:09|INFO|JwtAuthorizationFilter check|authorization: 2026-01-16 12:23:09|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM3MzcxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5NjU3MX0.t3nSWYnpdElyYMvyi7IILvkUbwUcMS6zCP_XID6UYcw 2026-01-16 12:23:09|INFO|customerList|params:{} customerNameKensaku=アップロード 2026-01-16 12:23:09|SQL|[#1 - 0.43ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(35): App\Model\Customer\DatCustomer::queryList() u433670985_test.dat_customer SELECT ctm.base_customerID as customerId,ctm.customer_name as customerName,ctm.name,ctm.customer_telnumber as customerTelnumber,ss.ss_name as ssName FROM dat_customer AS ctm LEFT JOIN mt_ss AS ss ON ctm.shop_id = ss.ID WHERE (ctm.delete_date is null and concat(ctm.kensaku, ctm.customer_name_kensaku) LIKE ?); -- '%アップロード%'|{"request":{"service":"App.Customer_Customer.customerList"}} 2026-01-16 12:23:16|INFO|JwtAuthorizationFilter check|authorization: 2026-01-16 12:23:16|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM3MzcxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5NjU3MX0.t3nSWYnpdElyYMvyi7IILvkUbwUcMS6zCP_XID6UYcw 2026-01-16 12:23:16|INFO|customerList|params:{} customerNameKensaku=ア 2026-01-16 12:23:16|SQL|[#1 - 0.49ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(35): App\Model\Customer\DatCustomer::queryList() u433670985_test.dat_customer SELECT ctm.base_customerID as customerId,ctm.customer_name as customerName,ctm.name,ctm.customer_telnumber as customerTelnumber,ss.ss_name as ssName FROM dat_customer AS ctm LEFT JOIN mt_ss AS ss ON ctm.shop_id = ss.ID WHERE (ctm.delete_date is null and concat(ctm.kensaku, ctm.customer_name_kensaku) LIKE ?); -- '%ア%'|{"request":{"service":"App.Customer_Customer.customerList"}} 2026-01-16 12:35:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 12:37:25|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 12:39:48|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 12:41:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 12:41:41|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"} 2026-01-16 12:41:41|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 = 'admin') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}} 2026-01-16 12:41:41|INFO|mt_ss login|user:{"ID":18,"category":9,"ss_name":"admin","display_name":null,"en_name":"admin","section":null,"section_id":null,"log_in":"admin","pw":"urutoraman1","manager_flag":1,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":1,"rent_a_car":1,"towing":null,"Delete_date":null,"line_openid":"C","zip":null,"address":null,"telno":null,"faxno":null} 2026-01-16 12:41:41|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768538501,"data":{"ssid":18}} 2026-01-16 12:41:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM4NTAxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njg1NDIxMDF9.AvkTKmTyRwPzbLEurln4VTFGd5N_cRVDC0pXdnW7p4E 2026-01-16 12:41:41|INFO|orderList|shopId: 2026-01-16 12:41:41|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768538501,"data":{"ssid":18},"scopes":"role_access","exp":1768542101} 2026-01-16 12:41:41|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null} 2026-01-16 12:41:41|INFO|getOrderList|担当者所属的店铺id:18 2026-01-16 12:41:41|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 = 18);|{"request":{"service":"App.Order_Order.OrderList"}} 2026-01-16 12:41:41|SQL|[#2 - 0.14ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35): PhalApi\Model\DataModel::getList() u433670985_test.mt_ss SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}} 2026-01-16 12:41: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}] 2026-01-16 12:41: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}]} 2026-01-16 12:41: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}]} 2026-01-16 12:41:41|SQL|[#3 - 7.03ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(214): App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer() u433670985_test.dat_syaken_order_list SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}} 2026-01-16 12:41:41|INFO|getOrderList|查询结果条数:140 2026-01-16 12:41:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM4NTAxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njg1NDIxMDF9.AvkTKmTyRwPzbLEurln4VTFGd5N_cRVDC0pXdnW7p4E 2026-01-16 12:41:41|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(52): PhalApi\Model\DataModel::getList() u433670985_test.mt_ss SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.AdminUser_MtSsUser.GetAllSS"}} 2026-01-16 12:41:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM4NTAxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3Njg1NDIxMDF9.AvkTKmTyRwPzbLEurln4VTFGd5N_cRVDC0pXdnW7p4E 2026-01-16 12:41:41|INFO|getSubSS|jwt:{"iss":"http:\/\/www.shimars.net","iat":1768538501,"data":{"ssid":18},"scopes":"role_access","exp":1768542101} 2026-01-16 12:41:41|SQL|[#1 - 0.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(59): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}} 2026-01-16 12:41:41|SQL|[#2 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(63): PhalApi\Model\DataModel::getList() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (category <> ?) LIMIT 0,100; -- 9|{"request":{"service":"App.AdminUser_MtSsUser.GetSubSS"}} 2026-01-16 12:44:13|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 12:44:36|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4MjgwMzM4LCJkYXRhIjp7InNzaWQiOjIyfSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NjgyODM5Mzh9.2DbWx_NZ81k2hs0nMnStopRxsWitl-Z0nV57uNZ3wRU 2026-01-16 12:47:52|INFO|JwtAuthorizationFilter check|authorization:undefined undefined 2026-01-16 12:47:52|ERROR|App.Order_Order.getSalesByYear|UnexpectedValueException: Wrong number of segments in /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/firebase/php-jwt/src/JWT.php:109 Stack trace: #0 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Filter/JwtAuthorizationFilter.php(43): Firebase\JWT\JWT::decode('undefined undef...', Object(Firebase\JWT\Key)) #1 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Api.php(259): App\Filter\JwtAuthorizationFilter->check() #2 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Api.php(95): PhalApi\Api->filterCheck() #3 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/ApiFactory.php(78): PhalApi\Api->init() #4 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/PhalApi.php(51): PhalApi\ApiFactory::generateService() #5 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/public/index.php(9): PhalApi\PhalApi->response() #6 {main} 2026-01-16 12:48:05|INFO|JwtAuthorizationFilter check|authorization:undefined undefined 2026-01-16 12:48:05|ERROR|App.Order_Order.getSalesByYear|UnexpectedValueException: Wrong number of segments in /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/firebase/php-jwt/src/JWT.php:109 Stack trace: #0 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Filter/JwtAuthorizationFilter.php(43): Firebase\JWT\JWT::decode('undefined undef...', Object(Firebase\JWT\Key)) #1 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Api.php(259): App\Filter\JwtAuthorizationFilter->check() #2 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Api.php(95): PhalApi\Api->filterCheck() #3 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/ApiFactory.php(78): PhalApi\Api->init() #4 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/PhalApi.php(51): PhalApi\ApiFactory::generateService() #5 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/public/index.php(9): PhalApi\PhalApi->response() #6 {main} 2026-01-16 12:49:55|INFO|JwtAuthorizationFilter check|authorization:undefined 2026-01-16 12:49:55|ERROR|App.Order_Order.getSalesByYear|UnexpectedValueException: Wrong number of segments in /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/firebase/php-jwt/src/JWT.php:109 Stack trace: #0 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Filter/JwtAuthorizationFilter.php(43): Firebase\JWT\JWT::decode('undefined', Object(Firebase\JWT\Key)) #1 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Api.php(259): App\Filter\JwtAuthorizationFilter->check() #2 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Api.php(95): PhalApi\Api->filterCheck() #3 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/ApiFactory.php(78): PhalApi\Api->init() #4 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/PhalApi.php(51): PhalApi\ApiFactory::generateService() #5 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/public/index.php(9): PhalApi\PhalApi->response() #6 {main} 2026-01-16 12:49:57|INFO|JwtAuthorizationFilter check|authorization:undefined 2026-01-16 12:49:57|ERROR|App.Order_Order.getSalesByYear|UnexpectedValueException: Wrong number of segments in /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/firebase/php-jwt/src/JWT.php:109 Stack trace: #0 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Filter/JwtAuthorizationFilter.php(43): Firebase\JWT\JWT::decode('undefined', Object(Firebase\JWT\Key)) #1 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Api.php(259): App\Filter\JwtAuthorizationFilter->check() #2 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Api.php(95): PhalApi\Api->filterCheck() #3 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/ApiFactory.php(78): PhalApi\Api->init() #4 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/PhalApi.php(51): PhalApi\ApiFactory::generateService() #5 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/public/index.php(9): PhalApi\PhalApi->response() #6 {main} 2026-01-16 12:50:46|INFO|JwtAuthorizationFilter check|authorization:undefined 2026-01-16 12:50:46|ERROR|App.Order_Order.getSalesByYear|UnexpectedValueException: Wrong number of segments in /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/firebase/php-jwt/src/JWT.php:109 Stack trace: #0 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Filter/JwtAuthorizationFilter.php(43): Firebase\JWT\JWT::decode('undefined', Object(Firebase\JWT\Key)) #1 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Api.php(259): App\Filter\JwtAuthorizationFilter->check() #2 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Api.php(95): PhalApi\Api->filterCheck() #3 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/ApiFactory.php(78): PhalApi\Api->init() #4 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/PhalApi.php(51): PhalApi\ApiFactory::generateService() #5 /home/u433670985/domains/test.yaog.tech/public_html/phpapi/public/index.php(9): PhalApi\PhalApi->response() #6 {main} 2026-01-16 12:52:24|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM5MTQ0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5ODM0NH0.zJ_cYdoWvMTxD4KtLSxxWScCCIm83UYpR5SYiO7WfKo 2026-01-16 12:52:24|SQL|[#1 - 1.86ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:52:24|SQL|[#2 - 1.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:52:42|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM5MTYyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5ODM2Mn0.GiQopkpkL7bKjshkletqZeUawxipE94oO1sVSn7ZmV4 2026-01-16 12:52:42|SQL|[#1 - 1.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:52:42|SQL|[#2 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:52:50|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM5MTcwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5ODM3MH0.f362cKKYhBLghPjLilbn6Q02M5rjKPmMlkzj08rWkrk 2026-01-16 12:52:50|SQL|[#1 - 0.75ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:52:50|SQL|[#2 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:55:37|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM5MTcwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5ODM3MH0.f362cKKYhBLghPjLilbn6Q02M5rjKPmMlkzj08rWkrk 2026-01-16 12:55:37|SQL|[#1 - 16.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-4-01', '2025-5-01', '2025-4-01', '2025-5-01', '2025-4-01', '2025-5-01', '2025-4-01', '2025-5-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 12:55:39|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM5MzM4LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5ODUzOH0.I7PPG_3HoIu3wEVRQnTLX5-WrPYJzKJNLZT2BSQBZxQ 2026-01-16 12:55:39|SQL|[#1 - 0.94ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:55:39|SQL|[#2 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:55:40|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM5MzM4LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5ODUzOH0.I7PPG_3HoIu3wEVRQnTLX5-WrPYJzKJNLZT2BSQBZxQ 2026-01-16 12:55:40|SQL|[#1 - 18.94ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 12:57:38|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM5NDU3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5ODY1N30.ODPMSeQvU0JryYsanmWhFxAhywXPndX95QNDYBaMWrw 2026-01-16 12:57:38|SQL|[#1 - 0.79ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:57:38|SQL|[#2 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:59:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM5NDU3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5ODY1N30.ODPMSeQvU0JryYsanmWhFxAhywXPndX95QNDYBaMWrw 2026-01-16 12:59:08|SQL|[#1 - 0.66ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2026-04-01', '2027-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:59:08|SQL|[#2 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2026', 2027|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:59:17|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM5NDU3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5ODY1N30.ODPMSeQvU0JryYsanmWhFxAhywXPndX95QNDYBaMWrw 2026-01-16 12:59:17|SQL|[#1 - 1.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2024-04-01', '2025-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:59:17|SQL|[#2 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2024', 2025|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:59:20|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM5NDU3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5ODY1N30.ODPMSeQvU0JryYsanmWhFxAhywXPndX95QNDYBaMWrw 2026-01-16 12:59:20|SQL|[#1 - 0.92ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:59:20|SQL|[#2 - 0.51ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 12:59:58|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM5NDU3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5ODY1N30.ODPMSeQvU0JryYsanmWhFxAhywXPndX95QNDYBaMWrw 2026-01-16 12:59:58|SQL|[#1 - 6.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 13:19:44|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTM5NDU3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODc5ODY1N30.ODPMSeQvU0JryYsanmWhFxAhywXPndX95QNDYBaMWrw 2026-01-16 13:19:44|SQL|[#1 - 3.91ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 14:16:29|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTQ0MTg5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgwMzM4OX0.ex8kfL9Yud0HVwYd2qVL0fmMTE6I4WHGzAO5CZ3yZq8 2026-01-16 14:16:29|SQL|[#1 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-16 14:16:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTQ0MTg5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgwMzM4OX0.ex8kfL9Yud0HVwYd2qVL0fmMTE6I4WHGzAO5CZ3yZq8 2026-01-16 14:16:30|SQL|[#1 - 0.83ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 14:16:30|SQL|[#2 - 0.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 14:25:19|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTQ0MTg5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgwMzM4OX0.ex8kfL9Yud0HVwYd2qVL0fmMTE6I4WHGzAO5CZ3yZq8 2026-01-16 14:25:19|SQL|[#1 - 0.83ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 14:25:19|SQL|[#2 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 14:25:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTQ0MTg5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgwMzM4OX0.ex8kfL9Yud0HVwYd2qVL0fmMTE6I4WHGzAO5CZ3yZq8 2026-01-16 14:25:23|SQL|[#1 - 0.65ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2026-04-01', '2027-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 14:25:23|SQL|[#2 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2026', 2027|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 14:25:26|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTQ0MTg5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgwMzM4OX0.ex8kfL9Yud0HVwYd2qVL0fmMTE6I4WHGzAO5CZ3yZq8 2026-01-16 14:25:26|SQL|[#1 - 0.86ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 14:25:26|SQL|[#2 - 0.22ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:04:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUwNjQ4LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgwOTg0OH0.WiKmNlZUT-xyrPECRs7Fpfawpqrvyv-qQHug4Lfxzkk 2026-01-16 16:04:08|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 = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-16 16:04:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUwNjQ4LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgwOTg0OH0.WiKmNlZUT-xyrPECRs7Fpfawpqrvyv-qQHug4Lfxzkk 2026-01-16 16:04:08|SQL|[#1 - 1.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:04:08|SQL|[#2 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:05:17|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUwNzE2LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgwOTkxNn0.84B2i6EIarG3Ezpy6FTM0cKimzqolFe7H2plIGcO9mw 2026-01-16 16:05:17|SQL|[#1 - 0.53ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-16 16:05:17|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUwNzE2LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgwOTkxNn0.84B2i6EIarG3Ezpy6FTM0cKimzqolFe7H2plIGcO9mw 2026-01-16 16:05:17|SQL|[#1 - 0.68ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:05:17|SQL|[#2 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:08:59|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUwOTM5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDEzOX0.a6A5scJFpxNoCWVh5laqx87DbguAVp0Y7RP7T-ukwQI 2026-01-16 16:08:59|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 = '18');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-16 16:09:00|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUwOTM5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDEzOX0.a6A5scJFpxNoCWVh5laqx87DbguAVp0Y7RP7T-ukwQI 2026-01-16 16:09:00|SQL|[#1 - 0.89ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:09:00|SQL|[#2 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:09:14|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUwOTM5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDEzOX0.a6A5scJFpxNoCWVh5laqx87DbguAVp0Y7RP7T-ukwQI 2026-01-16 16:09:14|SQL|[#1 - 0.96ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:09:14|SQL|[#2 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:09:31|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUwOTM5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDEzOX0.a6A5scJFpxNoCWVh5laqx87DbguAVp0Y7RP7T-ukwQI 2026-01-16 16:09:31|SQL|[#1 - 4.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 16:09:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUwOTc1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDE3NX0.I8BYdtjBsVN8AwA-rNiJepeETmWbxB2HsND5lF8qJ9o 2026-01-16 16:09:35|SQL|[#1 - 0.28ms - 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"}} 2026-01-16 16:09:35|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUwOTc1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDE3NX0.I8BYdtjBsVN8AwA-rNiJepeETmWbxB2HsND5lF8qJ9o 2026-01-16 16:09:35|SQL|[#1 - 0.7ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:09:35|SQL|[#2 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:10:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUxMDQ3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDI0N30.jPHjZu2HU0Ako96zwAQoY8xEebpEkuhmPPQm3uz5bFI 2026-01-16 16:10:47|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 = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-16 16:10:47|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUxMDQ3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDI0N30.jPHjZu2HU0Ako96zwAQoY8xEebpEkuhmPPQm3uz5bFI 2026-01-16 16:10:47|SQL|[#1 - 0.8ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:10:47|SQL|[#2 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:11:55|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUxMTE1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDMxNX0._BxzkUqexk-699wbg2X2AtKq5SAACp3PWp0-aMb04yQ 2026-01-16 16:11:55|SQL|[#1 - 0.42ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-16 16:11:56|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUxMTE1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDMxNX0._BxzkUqexk-699wbg2X2AtKq5SAACp3PWp0-aMb04yQ 2026-01-16 16:11:56|SQL|[#1 - 4.62ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:11:56|SQL|[#2 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:11:57|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUxMTE1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDMxNX0._BxzkUqexk-699wbg2X2AtKq5SAACp3PWp0-aMb04yQ 2026-01-16 16:11:58|SQL|[#1 - 4.05ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 16:12:02|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUxMTIyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDMyMn0.CrwiYvZX8Me6Tz8m3YC03xh7ESPTaAQ35Uqx6iExcnQ 2026-01-16 16:12:02|SQL|[#1 - 0.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-16 16:12:03|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUxMTIyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDMyMn0.CrwiYvZX8Me6Tz8m3YC03xh7ESPTaAQ35Uqx6iExcnQ 2026-01-16 16:12:03|SQL|[#1 - 1.06ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:12:03|SQL|[#2 - 0.49ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:12:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUxMTIyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDMyMn0.CrwiYvZX8Me6Tz8m3YC03xh7ESPTaAQ35Uqx6iExcnQ 2026-01-16 16:12:07|SQL|[#1 - 3.89ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-6-01', '2025-7-01', '2025-6-01', '2025-7-01', '2025-6-01', '2025-7-01', '2025-6-01', '2025-7-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 16:12:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUxMTI4LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDMyOH0.KcLVXnAtMGykgmcpWU3mxUw8kO4HrakssZHx973yu8M 2026-01-16 16:12:08|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 = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-16 16:12:09|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUxMTI4LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMDMyOH0.KcLVXnAtMGykgmcpWU3mxUw8kO4HrakssZHx973yu8M 2026-01-16 16:12:09|SQL|[#1 - 0.98ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:12:09|SQL|[#2 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:46:41|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzMjAxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjQwMX0.wX8ta6Y_Cser9OXSBhgHZ67zi254TFe5Nl-9ncXEY7w 2026-01-16 16:46:41|SQL|[#1 - 0.42ms - 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 = '12');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-16 16:46:42|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzMjAxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjQwMX0.wX8ta6Y_Cser9OXSBhgHZ67zi254TFe5Nl-9ncXEY7w 2026-01-16 16:46:42|SQL|[#1 - 1.02ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:46:42|SQL|[#2 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:46:43|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzMjAxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjQwMX0.wX8ta6Y_Cser9OXSBhgHZ67zi254TFe5Nl-9ncXEY7w 2026-01-16 16:46:43|SQL|[#1 - 3.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-6-01', '2025-7-01', '2025-6-01', '2025-7-01', '2025-6-01', '2025-7-01', '2025-6-01', '2025-7-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 16:46:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzMjAxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjQwMX0.wX8ta6Y_Cser9OXSBhgHZ67zi254TFe5Nl-9ncXEY7w 2026-01-16 16:46:48|SQL|[#1 - 3.05ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-6-01', '2025-7-01', '2025-6-01', '2025-7-01', '2025-6-01', '2025-7-01', '2025-6-01', '2025-7-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 16:52:43|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzNTYzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjc2M30.DVNeGC6VUqAcA4QE5F223aOyIxXrHVMs9WQyq6JZmPs 2026-01-16 16:52:43|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = '');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-16 16:52:52|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzNTcyLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjc3Mn0.cO6fMi7cfJNQRy9KJyi-RqSzzMDhXi9wLYVXkajFiGk 2026-01-16 16:52:52|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = '');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-16 16:53:16|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzNTk1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjc5NX0.bRejejVBLQ7lY35OmbsfabEdNqJcXX9etVA6jKWUO00 2026-01-16 16:53:17|SQL|[#1 - 1.81ms - 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"}} 2026-01-16 16:53:17|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzNTk1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjc5NX0.bRejejVBLQ7lY35OmbsfabEdNqJcXX9etVA6jKWUO00 2026-01-16 16:53:17|SQL|[#1 - 0.72ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:53:17|SQL|[#2 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:54:30|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzNjY5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjg2OX0.Kh6nTD_uV27YzoJQvgQI6vqO2acd5iPTqSrYEik0wtI 2026-01-16 16:54:30|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245): App\Domain\AdminUser\MtSs::get() u433670985_test.mt_ss SELECT * FROM mt_ss WHERE (id = '');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}} 2026-01-16 16:55:04|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzNjY5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjg2OX0.Kh6nTD_uV27YzoJQvgQI6vqO2acd5iPTqSrYEik0wtI 2026-01-16 16:55:04|SQL|[#1 - 1.04ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(536): App\Model\Order\DatSyakenOrderList::listBySalesByYear() u433670985_test.dat_syaken_order_list select DATE_FORMAT(a.ss_return_date,'%Y') years,DATE_FORMAT(a.ss_return_date,'%m') months,count(a.Order_ID) sales_num,sum(a.a1-a.deposit_withdrawal_total) sales_total,sum(a.deposit_withdrawal_total) deposit_total from (SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,o.deposit_withdrawal_record_id,SUM(CASE WHEN dw.type = 2 THEN -dw.amount ELSE dw.amount END) AS a1,o.deposit_withdrawal_total FROM dat_syaken_order_list as o left join dat_deposit_withdrawal_record as dw on dw.deposit_withdrawal_record_id = o.deposit_withdrawal_record_id where service !=1 and state <> -9 and cancel_flag = 0 and ss_return_date between :startDate and :endDate GROUP BY o.deposit_withdrawal_record_id, o.Order_ID ) as a GROUP BY years,months; -- '2025-04-01', '2026-04-01'|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:55:04|SQL|[#2 - 0.54ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Sales/MtMcBudget.php(13): App\Model\Sales\MtMcBudget::getBudgetByYear() u433670985_test.mt_mc_budget SELECT * FROM mt_mc_budget WHERE ((year = ? and month >= 4)) OR ((year = ? and month < 4)); -- '2025', 2026|{"request":{"service":"App.Order_Order.getSalesByYear"}} 2026-01-16 16:55:06|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzNjY5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjg2OX0.Kh6nTD_uV27YzoJQvgQI6vqO2acd5iPTqSrYEik0wtI 2026-01-16 16:55:06|SQL|[#1 - 6.79ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 16:56:39|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzNjY5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjg2OX0.Kh6nTD_uV27YzoJQvgQI6vqO2acd5iPTqSrYEik0wtI 2026-01-16 16:56:39|SQL|[#1 - 3.79ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 16:59:05|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzNjY5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjg2OX0.Kh6nTD_uV27YzoJQvgQI6vqO2acd5iPTqSrYEik0wtI 2026-01-16 16:59:05|SQL|[#1 - 4.55ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 17:02:24|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzNjY5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjg2OX0.Kh6nTD_uV27YzoJQvgQI6vqO2acd5iPTqSrYEik0wtI 2026-01-16 17:02:24|SQL|[#1 - 6.51ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}} 2026-01-16 17:05:08|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NTUzNjY5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODgxMjg2OX0.Kh6nTD_uV27YzoJQvgQI6vqO2acd5iPTqSrYEik0wtI 2026-01-16 17:05:08|SQL|[#1 - 6.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528): App\Model\Order\DatSyakenOrderList::listBySales() u433670985_test.dat_syaken_order_list SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,\n(IFNULL(re1.a1, 0) + IFNULL(re2.a2, 0)-IFNULL(re4.a4, 0)-IFNULL(o.extra_discount, 0)) AS total,\no.deposit_withdrawal_record_id,o.miscellaneous_expenses_id,o.repair_estimate_id,o.deposit_withdrawal_total\nFROM dat_syaken_order_list as o LEFT JOIN dat_cars AS c on c.CarID = o.Car_ID LEFT JOIN dat_customer as cu on cu.base_customerID = o.Customer_ID \nleft join (SELECT o1.Order_ID,re.repair_estimate_id, SUM(re.request_total_price) as a1 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_repair_estimate_detail as re on re.repair_estimate_id = o1.repair_estimate_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \nAND re.is_hidden !=1 AND re.repair_item != 'メモ' AND re.judge_type!=2 GROUP BY o1.repair_estimate_id, o1.Order_ID )as re1 ON re1.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,re.miscellaneous_expenses_id, SUM(re.amount) as a2 FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_miscellaneous_expenses_detail as re on re.miscellaneous_expenses_id = o1.miscellaneous_expenses_id \nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.miscellaneous_expenses_id, o1.Order_ID )as re2 ON re2.Order_ID = o.Order_ID \nleft join (SELECT o1.Order_ID,o1.discount_record_id,SUM(price) AS a4,o1.deposit_withdrawal_total FROM dat_syaken_order_list as o1 \nLEFT JOIN dat_discount_record_detail as dw on dw.discount_record_id = o1.discount_record_id\nwhere cancel_flag != 1 and state != -9 and service !=1 and ss_return_date between ? and ? \n GROUP BY o1.discount_record_id, o1.Order_ID )as re4 ON re4.Order_ID = o.Order_ID \nWHERE o.cancel_flag != 1 and o.state != -9 and o.service !=1 and o.ss_return_date between ? and ? ORDER BY `o`.`ss_return_date` ASC; -- '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01', '2025-5-01', '2025-6-01'|{"request":{"service":"App.Order_Order.getSalesList"}}