Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9665  AG06000084 06 661          View Edit Delete
9659  AG06000078 06 661          View Edit Delete
9675  AG06000094 06 661          View Edit Delete
9674  AG06000093 06 661          View Edit Delete
9671  AG06000090 06 661          View Edit Delete
9677  AG06000096 06 661          View Edit Delete
9680  AG06000099 06 661          View Edit Delete
9679  AG06000098 06 661          View Edit Delete
9676  AG06000095 06 661          View Edit Delete
9670  AG06000089 06 661          View Edit Delete
9658  AG06000077 06 661          View Edit Delete
9634  AG06000053 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9691  AG06000110 06 661          View Edit Delete
9690  AG06000109 06 661          View Edit Delete
9684  AG06000103 06 661          View Edit Delete
9683  AG06000102 06 661          View Edit Delete
9682  AG06000101 06 661          View Edit Delete
9681  AG06000100 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 29 of 373, showing 20 records out of 7458 total, starting on record 561, ending on 580

(default) 2 queries took 27 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`.`insert_user` asc LIMIT 560, 2020208
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 = 11119