Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9627  AG06000046 06 661          View Edit Delete
9626  AG06000045 06 661          View Edit Delete
9625  AG06000044 06 661          View Edit Delete
9624  AG06000043 06 661          View Edit Delete
9623  AG06000042 06 661          View Edit Delete
9622  AG06000041 06 661          View Edit Delete
9621  AG06000040 06 661          View Edit Delete
9620  AG06000039 06 661          View Edit Delete
9619  AG06000038 06 661          View Edit Delete
9618  AG06000037 06 661          View Edit Delete
9617  AG06000036 06 661          View Edit Delete
9616  AG06000035 06 661          View Edit Delete
9615  AG06000034 06 661          View Edit Delete
9614  AG06000033 06 661          View Edit Delete
9613  AG06000032 06 661          View Edit Delete
9612  AG06000031 06 661          View Edit Delete
9611  AG06000030 06 661          View Edit Delete
9610  AG06000029 06 661          View Edit Delete
9609  AG06000028 06 661          View Edit Delete
9608  AG06000027 06 661          View Edit Delete

Page 280 of 373, showing 20 records out of 7458 total, starting on record 5581, ending on 5600

(default) 2 queries took 36 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`.`id` desc LIMIT 5580, 20202019
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 = 11117