Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9790  AG06000209 06 661          View Edit Delete
9784  AG06000203 06 661          View Edit Delete
9772  AG06000191 06 661          View Edit Delete
9748  AG06000167 06 661          View Edit Delete
9718  AG06000137 06 661          View Edit Delete
9805  AG06000224 06 661          View Edit Delete
9808  AG06000227 06 661          View Edit Delete
9807  AG06000226 06 661          View Edit Delete
9804  AG06000223 06 661          View Edit Delete
9798  AG06000217 06 661          View Edit Delete
9814  AG06000233 06 661          View Edit Delete
9813  AG06000232 06 661          View Edit Delete
9810  AG06000229 06 661          View Edit Delete
9816  AG06000235 06 661          View Edit Delete
9815  AG06000234 06 661          View Edit Delete
9809  AG06000228 06 661          View Edit Delete
9797  AG06000216 06 661          View Edit Delete
9796  AG06000215 06 661          View Edit Delete
9795  AG06000214 06 661          View Edit Delete
9717  AG06000136 06 661          View Edit Delete

Page 23 of 373, showing 20 records out of 7458 total, starting on record 441, ending on 460

(default) 2 queries took 25 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Contractor`.`id`, `Contractor`.`farmer_id`, `Contractor`.`trader_id`, `Contractor`.`company_cd`, `Contractor`.`created`, `Contractor`.`insert_user`, `Contractor`.`modified`, `Contractor`.`update_user`, `Farmer`.`user_id`, `Farmer`.`agreement_start_day`, `Farmer`.`agreement_end_day`, `Farmer`.`plan_code`, `Farmer`.`agreement_amount`, `Farmer`.`rental_printer_sn`, `Farmer`.`rental_tablet_sn`, `Farmer`.`rental_tablet_tel`, `Farmer`.`rental_tablet_gmail`, `Farmer`.`label_flg`, `Farmer`.`seal_flg`, `Farmer`.`blog_flg`, `Farmer`.`log_save_number`, `Farmer`.`user_post_number`, `Farmer`.`user_address`, `Farmer`.`user_tel`, `Farmer`.`qr_url`, `Farmer`.`notification_file`, `Farmer`.`plain_password`, `Farmer`.`admin_memo`, `Farmer`.`biz_browser_authorized_devices_count`, `Farmer`.`biz_browser_authorized_devices_limit`, `Farmer`.`created`, `Farmer`.`insert_user`, `Farmer`.`modified`, `Farmer`.`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`.`contractors` AS `Contractor` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Contractor`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`Contractor`.`trader_id` = `Trader`.`id`) WHERE 1 = 1 ORDER BY `Contractor`.`update_user` asc LIMIT 440, 2020207
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`contractors` AS `Contractor` LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`Contractor`.`farmer_id` = `Farmer`.`user_id`) LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`Contractor`.`trader_id` = `Trader`.`id`) WHERE 1 = 11118