2026-04-28 17:06:08|INFO|mt_ss getSsInfoFromSession|sessionUserName:
2026-04-28 17:06:23|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:06:23|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3MTY4LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjM2OH0.u7KZmMENI1N-j-RlpO5TZFj1qjD532yxEDcZ5JVrbAg
2026-04-28 17:06:23|INFO|customerList|params:{} customerNameKensaku=ア
2026-04-28 17:06:23|SQL|[#1 - 2.03ms - 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-04-28 17:06:25|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:06:25|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3MTY4LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjM2OH0.u7KZmMENI1N-j-RlpO5TZFj1qjD532yxEDcZ5JVrbAg
2026-04-28 17:06:25|INFO|carList|params:{"customerId":"21"}
2026-04-28 17:06:25|SQL|[#1 - 2.43ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '21'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:06:25|INFO|getCarByCustomerId|Existing Cars [{"CarID":1588,"VIN":"GE6-1598575","Number":"\u65b0\u6f5f502\u30808470","customer_ID":21},{"CarID":1733,"VIN":"H92W-0558741","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","customer_ID":21},{"CarID":1579,"VIN":"L175S-1126135","Number":"\u5bcc\u5c71581\u30468564","customer_ID":21}]
2026-04-28 17:06:25|SQL|[#2 - 0.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:06:25|SQL|[#3 - 0.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1588, 1733, 1579));|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:08:02|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:08:03|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3MTY4LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjM2OH0.u7KZmMENI1N-j-RlpO5TZFj1qjD532yxEDcZ5JVrbAg
2026-04-28 17:08:03|INFO|carList|params:{"customerId":"21"}
2026-04-28 17:08:03|SQL|[#1 - 1.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '21'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:08:03|INFO|getCarByCustomerId|Existing Cars [{"CarID":1588,"VIN":"GE6-1598575","Number":"\u65b0\u6f5f502\u30808470","customer_ID":21},{"CarID":1733,"VIN":"H92W-0558741","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","customer_ID":21},{"CarID":1579,"VIN":"L175S-1126135","Number":"\u5bcc\u5c71581\u30468564","customer_ID":21}]
2026-04-28 17:08:03|SQL|[#2 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:08:03|SQL|[#3 - 0.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1588, 1733, 1579));|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:08:05|INFO|mt_ss getSsInfoFromSession|sessionUserName:
2026-04-28 17:08:05|INFO|mt_ss getSsInfoFromSession|sessionUserName:
2026-04-28 17:08:13|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:08:13|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3Mjg1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjQ4NX0.5f214SuYXUOlj06DU1EIbkQEha1MZR3fLzWMsDCz_zA
2026-04-28 17:08:13|INFO|customerList|params:{} customerNameKensaku=ア
2026-04-28 17:08:13|SQL|[#1 - 0.56ms - 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-04-28 17:08:15|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:08:15|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3Mjg1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjQ4NX0.5f214SuYXUOlj06DU1EIbkQEha1MZR3fLzWMsDCz_zA
2026-04-28 17:08:15|INFO|carList|params:{"customerId":"41"}
2026-04-28 17:08:15|SQL|[#1 - 1.58ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '41'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:08:15|INFO|getCarByCustomerId|Existing Cars [{"CarID":1636,"VIN":"NHP10-6404613","Number":"\u5bcc\u5c71530\u30681636","customer_ID":41}]
2026-04-28 17:08:15|SQL|[#2 - 0.36ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:08:15|SQL|[#3 - 0.45ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1636));|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:09:36|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:09:36|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3Mjg1LCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjQ4NX0.5f214SuYXUOlj06DU1EIbkQEha1MZR3fLzWMsDCz_zA
2026-04-28 17:09:36|INFO|carList|params:{"customerId":"41"}
2026-04-28 17:09:36|SQL|[#1 - 1.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '41'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:09:36|INFO|getCarByCustomerId|Existing Cars [{"CarID":1636,"VIN":"NHP10-6404613","Number":"\u5bcc\u5c71530\u30681636","customer_ID":41}]
2026-04-28 17:09:36|SQL|[#2 - 0.32ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:09:36|SQL|[#3 - 0.43ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1636));|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:09:41|INFO|mt_ss getSsInfoFromSession|sessionUserName:
2026-04-28 17:09:41|INFO|mt_ss getSsInfoFromSession|sessionUserName:
2026-04-28 17:09:47|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:09:48|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3MzgxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjU4MX0.erRvV5quDEVAqN75TqQPWCxIbGcB-Xu0omNVIDRS3Ro
2026-04-28 17:09:48|INFO|customerList|params:{} customerNameKensaku=ア
2026-04-28 17:09:50|SQL|[#1 - 0.85ms - 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-04-28 17:09:53|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:09:53|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3MzgxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjU4MX0.erRvV5quDEVAqN75TqQPWCxIbGcB-Xu0omNVIDRS3Ro
2026-04-28 17:09:53|INFO|carList|params:{"customerId":"21"}
2026-04-28 17:09:53|SQL|[#1 - 1.48ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '21'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:09:53|INFO|getCarByCustomerId|Existing Cars [{"CarID":1588,"VIN":"GE6-1598575","Number":"\u65b0\u6f5f502\u30808470","customer_ID":21},{"CarID":1733,"VIN":"H92W-0558741","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","customer_ID":21},{"CarID":1579,"VIN":"L175S-1126135","Number":"\u5bcc\u5c71581\u30468564","customer_ID":21}]
2026-04-28 17:09:53|SQL|[#2 - 0.31ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:09:53|SQL|[#3 - 0.95ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1588, 1733, 1579));|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:10:46|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:10:46|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3MzgxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjU4MX0.erRvV5quDEVAqN75TqQPWCxIbGcB-Xu0omNVIDRS3Ro
2026-04-28 17:10:46|INFO|carList|params:{"customerId":"21"}
2026-04-28 17:10:46|SQL|[#1 - 1.48ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '21'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:10:46|INFO|getCarByCustomerId|Existing Cars [{"CarID":1588,"VIN":"GE6-1598575","Number":"\u65b0\u6f5f502\u30808470","customer_ID":21},{"CarID":1733,"VIN":"H92W-0558741","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","customer_ID":21},{"CarID":1579,"VIN":"L175S-1126135","Number":"\u5bcc\u5c71581\u30468564","customer_ID":21}]
2026-04-28 17:10:46|SQL|[#2 - 0.35ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:10:46|SQL|[#3 - 0.51ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1588, 1733, 1579));|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:10:56|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:10:56|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3MzgxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjU4MX0.erRvV5quDEVAqN75TqQPWCxIbGcB-Xu0omNVIDRS3Ro
2026-04-28 17:10:56|INFO|carList|params:{"customerId":"21"}
2026-04-28 17:10:56|SQL|[#1 - 1.09ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '21'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:10:56|INFO|getCarByCustomerId|Existing Cars [{"CarID":1588,"VIN":"GE6-1598575","Number":"\u65b0\u6f5f502\u30808470","customer_ID":21},{"CarID":1733,"VIN":"H92W-0558741","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","customer_ID":21},{"CarID":1579,"VIN":"L175S-1126135","Number":"\u5bcc\u5c71581\u30468564","customer_ID":21}]
2026-04-28 17:10:56|SQL|[#2 - 0.25ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:10:56|SQL|[#3 - 0.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1588, 1733, 1579));|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:10:57|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3MzgxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjU4MX0.erRvV5quDEVAqN75TqQPWCxIbGcB-Xu0omNVIDRS3Ro
2026-04-28 17:10:57|INFO|carList|params:{"customerId":"21"}
2026-04-28 17:10:57|SQL|[#1 - 2.16ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '21'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:10:57|INFO|getCarByCustomerId|Existing Cars [{"CarID":1588,"VIN":"GE6-1598575","Number":"\u65b0\u6f5f502\u30808470","customer_ID":21},{"CarID":1733,"VIN":"H92W-0558741","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","customer_ID":21},{"CarID":1579,"VIN":"L175S-1126135","Number":"\u5bcc\u5c71581\u30468564","customer_ID":21}]
2026-04-28 17:10:57|SQL|[#2 - 0.37ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:10:57|SQL|[#3 - 0.51ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1588, 1733, 1579));|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:11:08|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:11:08|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3MzgxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjU4MX0.erRvV5quDEVAqN75TqQPWCxIbGcB-Xu0omNVIDRS3Ro
2026-04-28 17:11:08|INFO|carList|params:{"customerId":"21"}
2026-04-28 17:11:08|SQL|[#1 - 1.64ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '21'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:11:08|INFO|getCarByCustomerId|Existing Cars [{"CarID":1588,"VIN":"GE6-1598575","Number":"\u65b0\u6f5f502\u30808470","customer_ID":21},{"CarID":1733,"VIN":"H92W-0558741","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","customer_ID":21},{"CarID":1579,"VIN":"L175S-1126135","Number":"\u5bcc\u5c71581\u30468564","customer_ID":21}]
2026-04-28 17:11:08|SQL|[#2 - 0.33ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:11:08|SQL|[#3 - 0.52ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1588, 1733, 1579));|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:11:12|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3MzgxLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjU4MX0.erRvV5quDEVAqN75TqQPWCxIbGcB-Xu0omNVIDRS3Ro
2026-04-28 17:11:12|INFO|carList|params:{"customerId":"21"}
2026-04-28 17:11:12|SQL|[#1 - 2.17ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '21'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:11:12|INFO|getCarByCustomerId|Existing Cars [{"CarID":1588,"VIN":"GE6-1598575","Number":"\u65b0\u6f5f502\u30808470","customer_ID":21},{"CarID":1733,"VIN":"H92W-0558741","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","customer_ID":21},{"CarID":1579,"VIN":"L175S-1126135","Number":"\u5bcc\u5c71581\u30468564","customer_ID":21}]
2026-04-28 17:11:12|SQL|[#2 - 0.66ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:11:12|SQL|[#3 - 3.47ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1588, 1733, 1579));|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:11:23|INFO|mt_ss getSsInfoFromSession|sessionUserName:
2026-04-28 17:11:23|INFO|mt_ss getSsInfoFromSession|sessionUserName:
2026-04-28 17:11:28|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:11:28|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3NDgzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjY4M30.Vh6GL1FBoNfceFrHWKjnKrfqFNXJmqjpImdVh85p01A
2026-04-28 17:11:28|INFO|customerList|params:{} customerNameKensaku=ア
2026-04-28 17:11:28|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-04-28 17:11:29|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:11:29|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3NDgzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjY4M30.Vh6GL1FBoNfceFrHWKjnKrfqFNXJmqjpImdVh85p01A
2026-04-28 17:11:29|INFO|carList|params:{"customerId":"21"}
2026-04-28 17:11:29|SQL|[#1 - 1.72ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '21'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:11:29|INFO|getCarByCustomerId|Existing Cars [{"CarID":1588,"VIN":"GE6-1598575","Number":"\u65b0\u6f5f502\u30808470","customer_ID":21},{"CarID":1733,"VIN":"H92W-0558741","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","customer_ID":21},{"CarID":1579,"VIN":"L175S-1126135","Number":"\u5bcc\u5c71581\u30468564","customer_ID":21}]
2026-04-28 17:11:29|SQL|[#2 - 0.39ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:11:29|SQL|[#3 - 0.54ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1588, 1733, 1579));|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:12:30|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:12:30|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3NDgzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjY4M30.Vh6GL1FBoNfceFrHWKjnKrfqFNXJmqjpImdVh85p01A
2026-04-28 17:12:30|INFO|carList|params:{"customerId":"21"}
2026-04-28 17:12:30|SQL|[#1 - 1.28ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '21'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:12:30|INFO|getCarByCustomerId|Existing Cars [{"CarID":1588,"VIN":"GE6-1598575","Number":"\u65b0\u6f5f502\u30808470","customer_ID":21},{"CarID":1733,"VIN":"H92W-0558741","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","customer_ID":21},{"CarID":1579,"VIN":"L175S-1126135","Number":"\u5bcc\u5c71581\u30468564","customer_ID":21}]
2026-04-28 17:12:30|SQL|[#2 - 0.26ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:12:30|SQL|[#3 - 0.38ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1588, 1733, 1579));|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:12:33|INFO|mt_ss getSsInfoFromSession|sessionUserName:
2026-04-28 17:12:33|INFO|mt_ss getSsInfoFromSession|sessionUserName:
2026-04-28 17:12:38|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:12:39|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3NTUzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjc1M30.tLQb06Rw5NubLTEAMeMA8VZVbtVotnabfL9OPrM3cS4
2026-04-28 17:12:39|INFO|customerList|params:{} customerNameKensaku=ア
2026-04-28 17:12:39|SQL|[#1 - 0.47ms - 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-04-28 17:12:41|INFO|JwtAuthorizationFilter check|authorization:
2026-04-28 17:12:41|INFO|JwtAuthorizationFilter check|authorization:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpc3MiOiJodHRwOi8vd3d3LnNoaW1hcnMubmV0IiwiaWF0IjoxNzc3MzY3NTUzLCJkYXRhIjp7Im9yZGVySWQiOm51bGwsInV1aWQiOm51bGx9LCJzY29wZXMiOiJyb2xlX2FjY2VzcyIsImV4cCI6MTc3NzYyNjc1M30.tLQb06Rw5NubLTEAMeMA8VZVbtVotnabfL9OPrM3cS4
2026-04-28 17:12:41|INFO|carList|params:{"customerId":"21"}
2026-04-28 17:12:41|SQL|[#1 - 1.41ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(104):    App\Model\Cars\DatCars::getCarByCustomerId()    u433670985_test.dat_cars    SELECT max(CarID) as CarID, VIN,Number, customer_ID FROM `dat_cars` where customer_ID = :customer_ID and Dalete_Date is null and Number is not null group by VIN,Number, customer_ID;; -- '21'|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:12:41|INFO|getCarByCustomerId|Existing Cars [{"CarID":1588,"VIN":"GE6-1598575","Number":"\u65b0\u6f5f502\u30808470","customer_ID":21},{"CarID":1733,"VIN":"H92W-0558741","Number":"\u5bcc\u5c71\u3000\uff15\uff18\uff10\u3000\u3061\u3000\uff13\uff15\uff17\uff15","customer_ID":21},{"CarID":1579,"VIN":"L175S-1126135","Number":"\u5bcc\u5c71581\u30468564","customer_ID":21}]
2026-04-28 17:12:41|SQL|[#2 - 0.4ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Domain/Cars/DatCars.php(107):    PhalApi\Model\DataModel::getList()    u433670985_test.mt_ss    SELECT * FROM mt_ss LIMIT 0,100;|{"request":{"service":"App.Cars_Cars.carList"}}
2026-04-28 17:12:41|SQL|[#3 - 0.44ms - SQL]/home/u433670985/domains/test.yaog.tech/public_html/phpapi/src/app/Api/Cars/Cars.php(362):    App\Domain\Cars\DatCars::getCarListByCustomerId()    u433670985_test.dat_cars    SELECT * FROM dat_cars WHERE (CarID IN (1588, 1733, 1579));|{"request":{"service":"App.Cars_Cars.carList"}}