2025-07-12 08:53:16|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjExNzQ2LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjQ3MDk0Nn0.ott5WAzjxINC_7Dv-QR57w4idiMwlXXA5Fcq6bABg2Q
2025-07-12 08:53:16|INFO|uploadImg|params:{"file":{"name":"1752210265892.jpg","type":"image\/jpeg","tmp_name":"\/tmp\/phpg6FGhQ","error":0,"size":1505109},"orderId":"406","fileName":"report.jpg"}
2025-07-12 08:53:16|INFO|uploadImg|imgPath:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/406_report.jpg
2025-07-12 08:53:17|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjExNzQ2LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjQ3MDk0Nn0.ott5WAzjxINC_7Dv-QR57w4idiMwlXXA5Fcq6bABg2Q
2025-07-12 08:53:17|INFO|uploadDataV2|車両情報：{"carId":1783,"customerId":105,"number":"\u5bcc\u5c71580\u30613575","vin":"H92W-0558741","syodoDate":"2010-3-01","year":"2010(H22)","katashiki":"DBA-H92W","katashikiShitei":"15411","ruibetsu":"2001","gendouki":"3G83","drive":"\u8a2d\u5b9a\u5024\u7121\u3057","nenryou":"01","syaken":"2027-3-29","millage":74000,"delivaryDate":"2025-5-21","keijyou":"\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3\u30ef\u30b4\u30f3","jyuuryou":"800","syoyuusyaName":"\u4f7f\u7528\u8005\u306b\u540c\u3058","syoyuusyaAddress":"A","shiyousyaName":"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9","shiyousyaAddress":"A"}
2025-07-12 08:53:17|INFO|uploadDataV2|車検見積もり：[]
2025-07-12 08:53:17|INFO|uploadDataV2|一般整备：[]
2025-07-12 08:53:17|SQL|[#1 - 0.78ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '406') LIMIT 1;|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#2 - 0.42ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Order/Order.php(1819):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#3 - 0.62ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtCustomerBasicFee.php(17):    App\Model\Repair\MtCustomerBasicFee::findBasicFeeByOrderId()    u433670985_test.mt_customer_basic_fee     SELECT cbf.* FROM dat_syaken_order_list ord \n            LEFT JOIN dat_customer cust on ord.Customer_ID = cust.base_customerID\n            LEFT JOIN mt_customer_basic_fee cbf on cust.basic_fee_id = cbf.id\n            where ord.Order_ID = ? ; -- '406'|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|INFO|updateCarsInfo|update dat_cars data:{"customer_ID":105,"Number":"\u5bcc\u5c71580\u30613575","VIN":"H92W-0558741","syodo_date":"2010-3-01","katashiki":"DBA-H92W","Katashiki_Shitei":"15411","ruibetsu":"2001","gendouki":"3G83","drive":"\u8a2d\u5b9a\u5024\u7121\u3057","nenryou":"01","Syaken":"2027-3-29","Millage":74000,"Delivary_Date":"2025-5-21","keijyou":"\u30b9\u30c6\u30fc\u30b7\u30e7\u30f3\u30ef\u30b4\u30f3","jyuuryou":"800","syoyuusya_name":"\u4f7f\u7528\u8005\u306b\u540c\u3058","syoyuusya_address":"A","shiyousya_name":"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9","shiyousya_address":"A","Registry_Name":"\u4f7f\u7528\u8005\u306b\u540c\u3058","Registry_Address":"A","ex_shiyousya_name":"\u682a\u5f0f\u4f1a\u793e\u3000\uff33\uff28\uff29\uff2d\uff21\u30ab\u30fc\u30e9\u30a4\u30d5\u30b3\u30cd\u30af\u30c6\u30c3\u30c9","ex_shiyousya_address":"A","Year":"2010(H22)"}
2025-07-12 08:53:17|SQL|[#4 - 0.73ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(92):    App\Model\Cars\DatCars::updateCarsInfo()    u433670985_test.dat_cars    UPDATE dat_cars SET `customer_ID` = 105, `Number` = '富山580ち3575', `VIN` = 'H92W-0558741', `syodo_date` = '2010-3-01', `katashiki` = 'DBA-H92W', `Katashiki_Shitei` = '15411', `ruibetsu` = '2001', `gendouki` = '3G83', `drive` = '設定値無し', `nenryou` = '01', `Syaken` = '2027-3-29', `Millage` = 74000, `Delivary_Date` = '2025-5-21', `keijyou` = 'ステーションワゴン', `jyuuryou` = '800', `syoyuusya_name` = '使用者に同じ', `syoyuusya_address` = 'A', `shiyousya_name` = '株式会社　ＳＨＩＭＡカーライフコネクテッド', `shiyousya_address` = 'A', `Registry_Name` = '使用者に同じ', `Registry_Address` = 'A', `ex_shiyousya_name` = '株式会社　ＳＨＩＭＡカーライフコネクテッド', `ex_shiyousya_address` = 'A', `Year` = '2010(H22)' WHERE (CarID = 1783);|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|INFO|uploadDataV2|customerBasicFee: {"id":1,"customer":"\u4e00\u822c","lever_rate":7000,"vehicle_inspection_basic_fee":8909,"security_inspection_fee":15000,"tie_rod_end_boot_replacement":3000,"lower_ball_boots_replacement":4000,"drive_shaft_boot_replacement":7000,"toein_adjustment":2800,"stabilizer_link_replacement":3000}
2025-07-12 08:53:17|SQL|[#5 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(36):    PhalApi\Model\DataModel::insert()    u433670985_test.mt_miscellaneous_expenses    INSERT  INTO mt_miscellaneous_expenses (`create_time`) VALUES ('2025-07-12 08:53:17');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#6 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '406') LIMIT 1;|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#7 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID = 1783);|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#8 - 0.67ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Miscellaneous/DatMiscellaneousExpensesDetail.php(63):    PhalApi\Model\DataModel::insertMore()    u433670985_test.dat_miscellaneous_expenses_detail    INSERT  INTO dat_miscellaneous_expenses_detail (`miscellaneous_expenses_id`, `item`, `months`, `amount`, `create_time`) VALUES (522, '重量税', NULL, NULL, '2025-07-12 08:53:17'), (522, '自賠責', NULL, NULL, '2025-07-12 08:53:17'), (522, '印紙', NULL, NULL, '2025-07-12 08:53:17');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#9 - 0.55ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `miscellaneous_expenses_id` = 522 WHERE (order_id = '406');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#10 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '406') LIMIT 1;|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#11 - 1.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(367):    PhalApi\Model\DataModel::sum()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT SUM(amount) FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 522);|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#12 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `deposit_withdrawal_total` = 0 WHERE (order_id = '406');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#13 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(298):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_tax    SELECT * FROM mt_tax LIMIT 0,100;|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#14 - 0.19ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '406') LIMIT 1;|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#15 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID = 1783);|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#16 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/MtRepairEstimate.php(16):    PhalApi\Model\DataModel::insert()    u433670985_test.mt_repair_estimate    INSERT  INTO mt_repair_estimate (`create_time`) VALUES ('2025-07-12 08:53:17');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#17 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `repair_estimate_id` = 515 WHERE (order_id = 406);|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#18 - 0.59ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(85):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_repair_estimate_detail    INSERT  INTO dat_repair_estimate_detail (`is_hidden`, `flag`, `category_detail`, `repair_item`, `classification`, `repair_estimate_id`, `create_time`, `katashiki`) VALUES (0, 0, '車検整備', 'メモ', 'メモ', 515, '2025-07-12 08:53:17', 'DBA-H92W');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#19 - 0.14ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(85):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_repair_estimate_detail    INSERT  INTO dat_repair_estimate_detail (`is_hidden`, `flag`, `category_detail`, `repair_item`, `classification`, `category`, `pieces`, `request_unit_price`, `request_price`, `request_total_price`, `remark`, `judge_type`, `repair_estimate_id`, `create_time`, `katashiki`) VALUES (0, 0, '法定24ヶ月点検料', '基本料金', '点検', '法定点検', 1, 8909, 8909, 9800.000000, '必須', 1, 515, '2025-07-12 08:53:17', 'DBA-H92W');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#20 - 0.13ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(85):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_repair_estimate_detail    INSERT  INTO dat_repair_estimate_detail (`is_hidden`, `flag`, `category_detail`, `repair_item`, `classification`, `repair_estimate_id`, `create_time`, `katashiki`) VALUES (0, 0, '《日常点検・シビアコンディション特殊装置点検を含む》', 'メモ', 'メモ', 515, '2025-07-12 08:53:17', 'DBA-H92W');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#21 - 0.12ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(85):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_repair_estimate_detail    INSERT  INTO dat_repair_estimate_detail (`is_hidden`, `flag`, `category_detail`, `repair_item`, `classification`, `repair_estimate_id`, `create_time`, `katashiki`) VALUES (0, 0, '※詳細は別紙分解整備記録簿を御参照下さい', 'メモ', 'メモ', 515, '2025-07-12 08:53:17', 'DBA-H92W');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#22 - 0.11ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(85):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_repair_estimate_detail    INSERT  INTO dat_repair_estimate_detail (`is_hidden`, `flag`, `category_detail`, `repair_item`, `classification`, `category`, `pieces`, `request_unit_price`, `request_price`, `request_total_price`, `remark`, `judge_type`, `repair_estimate_id`, `create_time`, `katashiki`) VALUES (0, 0, '保安確認検査料', '基本料金', '測定', '保安検査', 1, 15000, 15000, 16500.000000, '必須', 1, 515, '2025-07-12 08:53:17', 'DBA-H92W');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#23 - 0.11ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(85):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_repair_estimate_detail    INSERT  INTO dat_repair_estimate_detail (`is_hidden`, `flag`, `category_detail`, `repair_item`, `classification`, `repair_estimate_id`, `create_time`, `katashiki`) VALUES (0, 0, '◆点検の結果必要となった追加整備・部品◆', 'メモ', 'メモ', 515, '2025-07-12 08:53:17', 'DBA-H92W');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#24 - 0.12ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(85):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_repair_estimate_detail    INSERT  INTO dat_repair_estimate_detail (`is_hidden`, `flag`, `category_detail`, `repair_item`, `classification`, `repair_estimate_id`, `create_time`, `katashiki`) VALUES (0, 0, '超撥水洗車サービス', 'メモ', 'メモ', 515, '2025-07-12 08:53:17', 'DBA-H92W');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#25 - 0.11ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(85):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_repair_estimate_detail    INSERT  INTO dat_repair_estimate_detail (`is_hidden`, `flag`, `category_detail`, `repair_item`, `classification`, `repair_estimate_id`, `create_time`, `katashiki`) VALUES (0, 0, 'やらなければ車検に通らない箇所', 'メモ', 'メモ', 515, '2025-07-12 08:53:17', 'DBA-H92W');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#26 - 0.12ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(85):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_repair_estimate_detail    INSERT  INTO dat_repair_estimate_detail (`is_hidden`, `flag`, `category_detail`, `repair_item`, `classification`, `repair_estimate_id`, `create_time`, `katashiki`) VALUES (0, 0, '車検は通りますが危険な箇所', 'メモ', 'メモ', 515, '2025-07-12 08:53:17', 'DBA-H92W');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#27 - 0.11ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(85):    PhalApi\Model\DataModel::insert()    u433670985_test.dat_repair_estimate_detail    INSERT  INTO dat_repair_estimate_detail (`is_hidden`, `flag`, `category_detail`, `repair_item`, `classification`, `repair_estimate_id`, `create_time`, `katashiki`) VALUES (0, 0, '以下はご提案まで', 'メモ', 'メモ', 515, '2025-07-12 08:53:17', 'DBA-H92W');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#28 - 0.1ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Repair/DatRepairEstimateDetail.php(87):    PhalApi\Model\DataModel::deleteIds()    u433670985_test.dat_repair_estimate_detail    DELETE FROM dat_repair_estimate_detail WHERE ((id) IS NOT NULL AND id IS NULL);|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|INFO|MtRepairUnitPrice|where:{"(repair_item, classification, category, category_detail)":[{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u70b9\u691c","category":"\u6cd5\u5b9a\u70b9\u691c","category_detail":"\u6cd5\u5b9a24\u30f6\u6708\u70b9\u691c\u6599"},{"repair_item":"\u57fa\u672c\u6599\u91d1","classification":"\u6e2c\u5b9a","category":"\u4fdd\u5b89\u691c\u67fb","category_detail":"\u4fdd\u5b89\u78ba\u8a8d\u691c\u67fb\u6599"}]}
2025-07-12 08:53:17|SQL|[#29 - 1.03ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/OrderDetail.php(124):    App\Model\Repair\MtRepairUnitPrice::fetchList()    u433670985_test.mt_repair_unit_price    SELECT * FROM mt_repair_unit_price WHERE ((repair_item, classification, category, category_detail) IN (('基本料金', '点検', '法定点検', '法定24ヶ月点検料'), ('基本料金', '測定', '保安検査', '保安確認検査料')));|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#30 - 0.2ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '406') LIMIT 1;|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#31 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(367):    PhalApi\Model\DataModel::sum()    u433670985_test.dat_miscellaneous_expenses_detail    SELECT SUM(amount) FROM dat_miscellaneous_expenses_detail WHERE (miscellaneous_expenses_id = 522);|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#32 - 7.8ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(379):    PhalApi\Model\DataModel::sum()    u433670985_test.dat_repair_estimate_detail    SELECT SUM(request_total_price) FROM dat_repair_estimate_detail WHERE (repair_estimate_id = 515) AND (judge_type <> ?); -- 2|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#33 - 0.17ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `deposit_withdrawal_total` = -26300 WHERE (order_id = '406');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:53:17|SQL|[#34 - 0.17ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(106):    App\Model\Order\DatSyakenOrderList::updateOrderInfo()    u433670985_test.dat_syaken_order_list    UPDATE dat_syaken_order_list SET `state` = 5, `Car_ID` = 1783, `reply_date` = '2025-07-12 08:53' WHERE (order_id = '406');|{"request":{"service":"App.Order_Order.uploadDataV2"}}
2025-07-12 08:55:46|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjEwMDg4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTIyMTM2ODh9.qdDMu__JdAfVbxDGh4sB504GXq05Y0Ovc65LP1dkXbw
2025-07-12 08:55:46|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjEwMDg4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTIyMTM2ODh9.qdDMu__JdAfVbxDGh4sB504GXq05Y0Ovc65LP1dkXbw
2025-07-12 08:55:46|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjEwMDg4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTIyMTM2ODh9.qdDMu__JdAfVbxDGh4sB504GXq05Y0Ovc65LP1dkXbw
2025-07-12 08:59:34|INFO|checkSourceUpdate|file:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../appview/dist.zip
2025-07-12 08:59:34|INFO|checkSourceUpdate|crc32:854971ee
2025-07-12 08:59:34|INFO|downloadSrc|file:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../appview/dist.zip
2025-07-12 08:59:34|INFO|downloadSrc|size:2364565
2025-07-12 08:59:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjEwMDg4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTIyMTM2ODh9.qdDMu__JdAfVbxDGh4sB504GXq05Y0Ovc65LP1dkXbw
2025-07-12 08:59:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjEwMDg4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTIyMTM2ODh9.qdDMu__JdAfVbxDGh4sB504GXq05Y0Ovc65LP1dkXbw
2025-07-12 08:59:48|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjEwMDg4LCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTIyMTM2ODh9.qdDMu__JdAfVbxDGh4sB504GXq05Y0Ovc65LP1dkXbw
2025-07-12 08:59:51|INFO|mt_ss login|params:{"loginId":"admin","pw":"urutoraman1"}
2025-07-12 08:59:51|SQL|[#1 - 0.47ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/vendor/phalapi/kernal/src/Model/DataModel.php(165):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (log_in = 'admin') LIMIT 0,1;|{"request":{"service":"App.AdminUser_MtSsUser.Login"}}
2025-07-12 08:59:51|INFO|mt_ss login|user:{"ID":18,"category":9,"ss_name":"admin","display_name":null,"en_name":"admin","section":null,"section_id":null,"log_in":"admin","pw":"urutoraman1","manager_flag":1,"comp_1":null,"comp_2":null,"comp_3":null,"comp_4":null,"comp_5":null,"test_marketing_flag":1,"rent_a_car":1,"towing":null,"Delete_date":null,"line_openid":"C","zip":null,"address":null,"telno":null,"faxno":null}
2025-07-12 08:59:51|INFO|mt_ss login|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752281991,"data":{"ssid":18}}
2025-07-12 08:59:51|INFO|JwtAuthorizationFilter check|authorization:bearer eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjgxOTkxLCJkYXRhIjp7InNzaWQiOjE4fSwic2NvcGVzIjoicm9sZV9hY2Nlc3MiLCJleHAiOjE3NTIyODU1OTF9.5ZpGxQKwUijV4k-8-9aw8sy5PtHhMtUJ7-bmjz6VhcQ
2025-07-12 08:59:51|INFO|orderList|shopId:
2025-07-12 08:59:51|INFO|orderList|jwt:{"iss":"http:\/\/www.shimars.net","iat":1752281991,"data":{"ssid":18},"scopes":"role_access","exp":1752285591}
2025-07-12 08:59:51|INFO|orderList|params:{"serviceStatus":null,"state":null,"shopId":18,"$freeword":null,"$orderId":null}
2025-07-12 08:59:51|INFO|getOrderList|担当者所属的店铺id:18
2025-07-12 08:59:51|SQL|[#1 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(167):    App\Domain\AdminUser\MtSs::get()    u433670985_test.mt_ss    SELECT * FROM mt_ss WHERE (id = 18);|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-12 08:59:51|SQL|[#2 - 0.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/AdminUser/MtSs.php(35):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT ID FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-12 08:59:51|INFO|getOrderList|担当者所属的店铺ids:[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]
2025-07-12 08:59:51|INFO|getOrderList|where:{"Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-12 08:59:51|INFO|listOrderInfosWithCarAndCustomer|aWhere:{"A.state NOT":[-1,3,-9,12,-12],"A.Shop_ID":[{"ID":1},{"ID":2},{"ID":3},{"ID":4},{"ID":5},{"ID":6},{"ID":7},{"ID":8},{"ID":9},{"ID":10},{"ID":11},{"ID":12},{"ID":13},{"ID":14},{"ID":15},{"ID":16},{"ID":17},{"ID":18},{"ID":19},{"ID":20},{"ID":21},{"ID":22}]}
2025-07-12 08:59:51|SQL|[#3 - 2.88ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(212):    App\Model\Order\DatSyakenOrderList::listOrderInfosWithCarAndCustomer()    u433670985_test.dat_syaken_order_list    SELECT A.*, Car.Car_Name, Car.VIN, Car.Number, Customer.customer_name, Customer.name,reservation.ss_storage_date FROM dat_syaken_order_list AS A LEFT JOIN dat_cars AS Car ON A.Car_ID = Car.CarID LEFT JOIN dat_customer AS Customer ON A.Customer_ID = Customer.base_customerID LEFT JOIN (SELECT res.Order_ID,max(res.ss_storage_date) as ss_storage_date FROM dat_cars_storage_reservation as res where 1=1 group by res.Order_ID) AS reservation ON A.Order_ID = reservation.Order_ID WHERE (A.state NOT IN (-1, 3, -9, 12, -12)) AND (A.Shop_ID IN ((1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19), (20), (21), (22)));|{"request":{"service":"App.Order_Order.OrderList"}}
2025-07-12 08:59:51|INFO|getOrderList|查询结果条数:126
2025-07-12 08:59:59|INFO|qrCodePng|orderId:406
2025-07-12 08:59:59|INFO|qrCodePng|aes encrypt：u8jQS9LgADKEX2WDaTeOf2
2025-07-12 08:59:59|INFO|qrCodePng|base64 encode:dThqUVM5TGdBREtFWDJXRGFUZU9mMiA0MDY=
2025-07-12 09:00:04|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjgxOTgwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjU0MTE4MH0.Mganq5WifCeVtkhPhZHN24hstskv0wr5bJicFJQmtGE
2025-07-12 09:00:04|SQL|[#1 - 0.96ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/MtObdError.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_obd_error    SELECT * FROM mt_obd_error LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.getObdErrorInfo"}}
2025-07-12 09:00:05|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjgxOTgwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjU0MTE4MH0.Mganq5WifCeVtkhPhZHN24hstskv0wr5bJicFJQmtGE
2025-07-12 09:00:05|INFO|verification|params:{"orderId":"406","uuid":"00d7289d-5b93-4363-87fb-5fe4714b8f93","ciphertext":"u8jQS9LgADKEX2WDaTeOf2"}
2025-07-12 09:00:05|INFO|verification|aes decrypt:406
2025-07-12 09:00:05|SQL|[#1 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '406') LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:00:05|SQL|[#2 - 0.62ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatOrderUuid.php(21):    App\Model\Order\DatOrderUuid::getUuidByOrderId()    u433670985_test.dat_order_uuid    SELECT uuid FROM dat_order_uuid WHERE (order_id = '406') LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:00:05|SQL|[#3 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatOrderUuid.php(42):    App\Model\Order\DatOrderUuid::updateOrderUuid()    u433670985_test.dat_order_uuid    UPDATE dat_order_uuid SET `ts` = 1752282005 WHERE (order_id = '406');|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:00:05|SQL|[#4 - 0.27ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1783);|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:00:05|SQL|[#5 - 0.48ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Filmthickness/DatVcFilmThickness.php(24):    App\Model\Filmthickness\DatVcFilmThickness::findFilmThicknessByCarId()    u433670985_test.dat_vc_film_thickness    SELECT * FROM dat_vc_film_thickness WHERE (car_id = 1783) LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:00:05|SQL|[#6 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/DatVcObd.php(55):    App\Model\OBD\DatVcObd::getObdErrorListByCarId()    u433670985_test.dat_vc_obd    SELECT obd.error_no,oe.message FROM dat_vc_obd AS obd LEFT JOIN mt_obd_error AS oe ON obd.error_no = oe.error_no WHERE (obd.car_id = 1783);|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:00:05|SQL|[#7 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/MtObdUnitPrice.php(20):    App\Model\OBD\MtObdUnitPrice::getObdUnitPriceByKatashiki()    u433670985_test.mt_obd_unit_price    SELECT error_no,price FROM `mt_obd_unit_price` \n        where katashiki = :katashiki and price is not null\n        order by error_no; -- 'DBA-H92W'|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:00:05|SQL|[#8 - 0.21ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 105) LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:00:05|SQL|[#9 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/FormCtrl/MtVcFormCtrl.php(14):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_vc_form_ctrl    SELECT * FROM mt_vc_form_ctrl WHERE (view_id = 'car') LIMIT 0,100;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:00:05|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjgxOTgwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjU0MTE4MH0.Mganq5WifCeVtkhPhZHN24hstskv0wr5bJicFJQmtGE
2025-07-12 09:00:05|SQL|[#1 - 0.49ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Quote/DatVehicleInspectionQuote.php(24):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_vehicle_inspection_quote    SELECT * FROM dat_vehicle_inspection_quote WHERE (service = '2') LIMIT 0,100;|{"request":{"service":"App.Quote_VehicleInspectionQuote.vehicleInspectionQuoteInfo"}}
2025-07-12 09:00:05|SQL|[#2 - 1.09ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Quote/DatVehicleInspectionQuote.php(25):    App\Model\Quote\DatVehicleInspectionQuote::getVehicleInspectionQuoteDetailInfo()    u433670985_test.dat_vehicle_inspection_quote    SELECT q.title,qd.id,qd.vehicle_inspection_quote_id,qd.answer FROM dat_vehicle_inspection_quote AS q LEFT JOIN dat_vehicle_inspection_quote_detail AS qd ON q.id = qd.vehicle_inspection_quote_id;|{"request":{"service":"App.Quote_VehicleInspectionQuote.vehicleInspectionQuoteInfo"}}
2025-07-12 09:00:09|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjgxOTgwLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjU0MTE4MH0.Mganq5WifCeVtkhPhZHN24hstskv0wr5bJicFJQmtGE
2025-07-12 09:00:09|INFO|downloadImg|params:{"orderId":"406","fileName":"report.jpg"}
2025-07-12 09:00:09|INFO|downloadImg|img path url:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/406_report.jpg
2025-07-12 09:03:13|INFO|checkSourceUpdate|file:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../appview/dist.zip
2025-07-12 09:03:13|INFO|checkSourceUpdate|crc32:854971ee
2025-07-12 09:04:51|INFO|checkSourceUpdate|file:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../appview/dist.zip
2025-07-12 09:04:51|INFO|checkSourceUpdate|crc32:854971ee
2025-07-12 09:04:58|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjgyMjk0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjU0MTQ5NH0.9bfQrudFRmEAA6k3uB3lEh73z_UoSaRdexrpFaEjBhU
2025-07-12 09:04:58|SQL|[#1 - 0.34ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/MtObdError.php(19):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_obd_error    SELECT * FROM mt_obd_error LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.getObdErrorInfo"}}
2025-07-12 09:05:06|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjgyMjk0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjU0MTQ5NH0.9bfQrudFRmEAA6k3uB3lEh73z_UoSaRdexrpFaEjBhU
2025-07-12 09:05:06|INFO|verification|params:{"orderId":"406","uuid":"00d7289d-5b93-4363-87fb-5fe4714b8f93","ciphertext":"u8jQS9LgADKEX2WDaTeOf2"}
2025-07-12 09:05:06|INFO|verification|aes decrypt:406
2025-07-12 09:05:06|SQL|[#1 - 0.55ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatSyakenOrderList.php(38):    App\Model\Order\DatSyakenOrderList::findOrderByOrderId()    u433670985_test.dat_syaken_order_list    SELECT * FROM dat_syaken_order_list WHERE (order_id = '406') LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:05:06|SQL|[#2 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatOrderUuid.php(21):    App\Model\Order\DatOrderUuid::getUuidByOrderId()    u433670985_test.dat_order_uuid    SELECT uuid FROM dat_order_uuid WHERE (order_id = '406') LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:05:06|SQL|[#3 - 0.17ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Order/DatOrderUuid.php(42):    App\Model\Order\DatOrderUuid::updateOrderUuid()    u433670985_test.dat_order_uuid    UPDATE dat_order_uuid SET `ts` = 1752282306 WHERE (order_id = '406');|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:05:06|SQL|[#4 - 0.42ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(26):    App\Model\Cars\DatCars::get()    u433670985_test.dat_cars    SELECT CarID,customer_ID,make,Number,VIN,syodo_date,katashiki,Katashiki_Shitei,ruibetsu,gendouki,drive,nenryou,Syaken,Millage,Year,Car_Name,Grade,Color,LastModify_Date,Inspection_Date,Delivary_Date,keijyou,jyuuryou,syoyuusya_name,syoyuusya_address,shiyousya_name,shiyousya_address,ex_shiyousya_name,ex_shiyousya_address,Registry_Name,Registry_Address FROM dat_cars WHERE (CarID = 1783);|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:05:06|SQL|[#5 - 0.23ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Filmthickness/DatVcFilmThickness.php(24):    App\Model\Filmthickness\DatVcFilmThickness::findFilmThicknessByCarId()    u433670985_test.dat_vc_film_thickness    SELECT * FROM dat_vc_film_thickness WHERE (car_id = 1783) LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:05:06|SQL|[#6 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/DatVcObd.php(55):    App\Model\OBD\DatVcObd::getObdErrorListByCarId()    u433670985_test.dat_vc_obd    SELECT obd.error_no,oe.message FROM dat_vc_obd AS obd LEFT JOIN mt_obd_error AS oe ON obd.error_no = oe.error_no WHERE (obd.car_id = 1783);|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:05:06|SQL|[#7 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/OBD/MtObdUnitPrice.php(20):    App\Model\OBD\MtObdUnitPrice::getObdUnitPriceByKatashiki()    u433670985_test.mt_obd_unit_price    SELECT error_no,price FROM `mt_obd_unit_price` \n        where katashiki = :katashiki and price is not null\n        order by error_no; -- 'DBA-H92W'|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:05:06|SQL|[#8 - 0.24ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Customer/DatCustomer.php(24):    App\Model\Customer\DatCustomer::findCustomerByCustomerId()    u433670985_test.dat_customer    SELECT * FROM dat_customer WHERE (base_customerID = 105) LIMIT 1;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:05:06|SQL|[#9 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/FormCtrl/MtVcFormCtrl.php(14):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_vc_form_ctrl    SELECT * FROM mt_vc_form_ctrl WHERE (view_id = 'car') LIMIT 0,100;|{"request":{"service":"App.Order_Order.Verification"}}
2025-07-12 09:05:06|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjgyMjk0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjU0MTQ5NH0.9bfQrudFRmEAA6k3uB3lEh73z_UoSaRdexrpFaEjBhU
2025-07-12 09:05:06|SQL|[#1 - 0.29ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Quote/DatVehicleInspectionQuote.php(24):    PhalApi\Model\DataModel::getList()    u433670985_test.dat_vehicle_inspection_quote    SELECT * FROM dat_vehicle_inspection_quote WHERE (service = '2') LIMIT 0,100;|{"request":{"service":"App.Quote_VehicleInspectionQuote.vehicleInspectionQuoteInfo"}}
2025-07-12 09:05:06|SQL|[#2 - 0.69ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Quote/DatVehicleInspectionQuote.php(25):    App\Model\Quote\DatVehicleInspectionQuote::getVehicleInspectionQuoteDetailInfo()    u433670985_test.dat_vehicle_inspection_quote    SELECT q.title,qd.id,qd.vehicle_inspection_quote_id,qd.answer FROM dat_vehicle_inspection_quote AS q LEFT JOIN dat_vehicle_inspection_quote_detail AS qd ON q.id = qd.vehicle_inspection_quote_id;|{"request":{"service":"App.Quote_VehicleInspectionQuote.vehicleInspectionQuoteInfo"}}
2025-07-12 09:05:10|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjgyMjk0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjU0MTQ5NH0.9bfQrudFRmEAA6k3uB3lEh73z_UoSaRdexrpFaEjBhU
2025-07-12 09:05:10|INFO|checkImgSourceUpdate|params:{"orderId":"406","fileName":"406","crc32":"3eef1e84"}
2025-07-12 09:05:10|INFO|checkImgSourceUpdate|filesize:1505109
2025-07-12 09:05:10|INFO|checkImgSourceUpdate|file:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/406_report.jpg
2025-07-12 09:05:10|INFO|checkImgSourceUpdate|crc32:3eef1e84
2025-07-12 09:05:25|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzUyMjgyMjk0LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc1MjU0MTQ5NH0.9bfQrudFRmEAA6k3uB3lEh73z_UoSaRdexrpFaEjBhU
2025-07-12 09:05:25|INFO|checkImgSourceUpdate|params:{"orderId":"406","fileName":"406","crc32":"3eef1e84"}
2025-07-12 09:05:25|INFO|checkImgSourceUpdate|filesize:1505109
2025-07-12 09:05:25|INFO|checkImgSourceUpdate|file:/home/u433670985/domains/test.yaog.tech/public_html/phpapi/config/../../../public_html/car/detail/upload/zebra/406_report.jpg
2025-07-12 09:05:25|INFO|checkImgSourceUpdate|crc32:3eef1e84