Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9738  AG06000157 06 661          View Edit Delete
9736  AG06000155 06 661          View Edit Delete
9741  AG06000160 06 661          View Edit Delete
9743  AG06000162 06 661          View Edit Delete
9742  AG06000161 06 661          View Edit Delete
9740  AG06000159 06 661          View Edit Delete
9744  AG06000163 06 661          View Edit Delete
7095  AG01003294 01 010          View Edit Delete
7099  AG01003305 01 010          View Edit Delete
9657  AG06000076 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
9663  AG06000082 06 661          View Edit Delete
9665  AG06000084 06 661          View Edit Delete
9664  AG06000083 06 661          View Edit Delete
9662  AG06000081 06 661          View Edit Delete
9658  AG06000077 06 661          View Edit Delete
9667  AG06000086 06 661          View Edit Delete
9666  AG06000085 06 661          View Edit Delete

Page 30 of 373, showing 20 records out of 7458 total, starting on record 581, ending on 600

(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 ORDER BY `Contractor`.`modified` asc LIMIT 580, 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 = 11119