2026-01-23 11:12:07|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY4NjM1NTE3LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2ODg5NDcxN30.JDMelmQva24wooTbIzMUWViyrJtSM55HZV3bhJYYTFw
2026-01-23 11:44:15|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5MTM5ODU1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTM5OTA1NX0.kbpgTG5fPSEpJjRR2UxvAdBKxjaCmJ9YDPOTawCA6Fw
2026-01-23 11:44:15|SQL|[#1 - 0.69ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2026-01-23 11:44:16|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5MTM5ODU1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTM5OTA1NX0.kbpgTG5fPSEpJjRR2UxvAdBKxjaCmJ9YDPOTawCA6Fw
2026-01-23 11:44:16|SQL|[#1 - 2.52ms - 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-23 11:44:16|SQL|[#2 - 0.63ms - 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-23 11:44:16|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5MTM5ODU1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTM5OTA1NX0.kbpgTG5fPSEpJjRR2UxvAdBKxjaCmJ9YDPOTawCA6Fw
2026-01-23 11:44:16|SQL|[#1 - 1.38ms - 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-23 11:44:16|SQL|[#2 - 0.39ms - 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-23 11:48:17|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5MTM5ODU1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTM5OTA1NX0.kbpgTG5fPSEpJjRR2UxvAdBKxjaCmJ9YDPOTawCA6Fw
2026-01-23 11:48:17|SQL|[#1 - 13.93ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(528):    App\Model\Order\DatSyakenOrderList::listBySales()    u433670985_test.dat_syaken_order_list    SELECT o.Order_ID,o.Complete_Date,o.ss_return_date,c.Number,c.Car_Name,o.Customer_ID,cu.customer_name,cu.name,o.collection_flag,\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-23 11:48:19|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5MTQwMDk5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTM5OTI5OX0.nsgJxi6oFpO8QXltyMynZ7jjCTLa-BCypLVzMxpK6jE
2026-01-23 11:48:19|SQL|[#1 - 0.3ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/AdminUser/MtSsUser.php(245):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = '2');|{"request":{"service":"App.AdminUser_MtSsUser.getSSInfoById"}}
2026-01-23 11:48:20|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5MTQwMDk5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTM5OTI5OX0.nsgJxi6oFpO8QXltyMynZ7jjCTLa-BCypLVzMxpK6jE
2026-01-23 11:48:20|SQL|[#1 - 1.2ms - 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-23 11:48:20|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-23 11:48:23|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzY5MTQwMDk5LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc2OTM5OTI5OX0.nsgJxi6oFpO8QXltyMynZ7jjCTLa-BCypLVzMxpK6jE
2026-01-23 11:48:23|SQL|[#1 - 8.38ms - 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,o.collection_flag,\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"}}