Locality

Id
9  
Trader
01  
Locality Cd
36  
Locality Nm
徳島県  
Use Start Day
2016-08-29 00:00:00  
Use End Day
 
Created
2016-08-30 12:23:16  
Insert User
MG00000001  
Modified
2016-08-30 12:23:16  
Update User
MG00000001  
(default) 3 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COUNT(*) AS `count` FROM `sato_agri`.`localities` AS `Locality` WHERE `Locality`.`id` = 9110
2SELECT `Locality`.`id`, `Locality`.`trader_id`, `Locality`.`locality_cd`, `Locality`.`locality_nm`, `Locality`.`use_start_day`, `Locality`.`use_end_day`, `Locality`.`created`, `Locality`.`insert_user`, `Locality`.`modified`, `Locality`.`update_user`, `Trader`.`id`, `Trader`.`formal_trader_nm`, `Trader`.`formal_trader_fk`, `Trader`.`designation_file`, `Trader`.`use_start_day`, `Trader`.`use_end_day`, `Trader`.`margin_price_yen`, `Trader`.`created`, `Trader`.`insert_user`, `Trader`.`modified`, `Trader`.`update_user` FROM `sato_agri`.`localities` AS `Locality` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`Locality`.`trader_id` = `Trader`.`id`) WHERE `Locality`.`id` = 9 LIMIT 1110
3SELECT `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`.`pickup_points` AS `PickupPoint` WHERE `PickupPoint`.`locality_id` = (9)18180