Contractors

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

Page 131 of 373, showing 20 records out of 7458 total, starting on record 2601, ending on 2620

(default) 2 queries took 26 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 LIMIT 2600, 2020209
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