Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10367  AG06000786 06 661          View Edit Delete
10366  AG06000785 06 661          View Edit Delete
10365  AG06000784 06 661          View Edit Delete
10364  AG06000783 06 661          View Edit Delete
10363  AG06000782 06 661          View Edit Delete
10362  AG06000781 06 661          View Edit Delete
10361  AG06000780 06 661          View Edit Delete
10360  AG06000779 06 661          View Edit Delete
10359  AG06000778 06 661          View Edit Delete
10358  AG06000777 06 661          View Edit Delete
10357  AG06000776 06 661          View Edit Delete
10356  AG06000775 06 661          View Edit Delete
10355  AG06000774 06 661          View Edit Delete
10354  AG06000773 06 661          View Edit Delete
10353  AG06000772 06 661          View Edit Delete
10352  AG06000771 06 661          View Edit Delete
10351  AG06000770 06 661          View Edit Delete
10350  AG06000769 06 661          View Edit Delete
10349  AG06000768 06 661          View Edit Delete
10348  AG06000767 06 661          View Edit Delete

Page 243 of 373, showing 20 records out of 7458 total, starting on record 4841, ending on 4860

(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 4840, 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