Edit Users Pickup Point
--:
--:
(default) 2 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS `count` FROM `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` WHERE `UsersPickupPoint`.`farmer_id` = 'AG01001272'110
2SELECT `UsersPickupPoint`.`farmer_id`, `UsersPickupPoint`.`pickup_point_id`, `UsersPickupPoint`.`use_start_day`, `UsersPickupPoint`.`use_end_day`, `UsersPickupPoint`.`created`, `UsersPickupPoint`.`insert_user`, `UsersPickupPoint`.`modified`, `UsersPickupPoint`.`update_user`, `PickupPoint`.`id`, `PickupPoint`.`pickup_point_cd`, `PickupPoint`.`trader_id`, `PickupPoint`.`locality_id`, `PickupPoint`.`locality_cd`, `PickupPoint`.`pickup_point_nm`, `PickupPoint`.`pickup_point_fk`, `PickupPoint`.`use_start_day`, `PickupPoint`.`use_end_day`, `PickupPoint`.`margin_price_yen`, `PickupPoint`.`remain_label_roll`, `PickupPoint`.`threshold_label_roll`, `PickupPoint`.`inventory_label_roll`, `PickupPoint`.`inventory_date`, `PickupPoint`.`created`, `PickupPoint`.`insert_user`, `PickupPoint`.`modified`, `PickupPoint`.`update_user`, `PickupPoint`.`password` FROM `sato_agri`.`users_pickup_points` AS `UsersPickupPoint` LEFT JOIN `sato_agri`.`pickup_points` AS `PickupPoint` ON (`UsersPickupPoint`.`pickup_point_id` = `PickupPoint`.`id`) WHERE `UsersPickupPoint`.`farmer_id` = 'AG01001272' LIMIT 1110