Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9677  AG06000096 06 661          View Edit Delete
9674  AG06000093 06 661          View Edit Delete
9675  AG06000094 06 661          View Edit Delete
9673  AG06000092 06 661          View Edit Delete
9672  AG06000091 06 661          View Edit Delete
9671  AG06000090 06 661          View Edit Delete
9670  AG06000089 06 661          View Edit Delete
9669  AG06000088 06 661          View Edit Delete
9668  AG06000087 06 661          View Edit Delete
9667  AG06000086 06 661          View Edit Delete
9666  AG06000085 06 661          View Edit Delete
9665  AG06000084 06 661          View Edit Delete
9664  AG06000083 06 661          View Edit Delete
9663  AG06000082 06 661          View Edit Delete
9662  AG06000081 06 661          View Edit Delete
9661  AG06000080 06 661          View Edit Delete
9660  AG06000079 06 661          View Edit Delete
9659  AG06000078 06 661          View Edit Delete
9658  AG06000077 06 661          View Edit Delete
9657  AG06000076 06 661          View Edit Delete

Page 44 of 373, showing 20 records out of 7458 total, starting on record 861, ending on 880

(default) 2 queries took 28 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`.`created` asc LIMIT 860, 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 = 11120