Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10368  AG06000787 06 661          View Edit Delete
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

Page 28 of 373, showing 20 records out of 7458 total, starting on record 541, ending on 560

(default) 2 queries took 24 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`.`farmer_id` desc LIMIT 540, 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 = 11117