Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9716  AG06000135 06 661          View Edit Delete
9708  AG06000127 06 661          View Edit Delete
9730  AG06000149 06 661          View Edit Delete
9728  AG06000147 06 661          View Edit Delete
9724  AG06000143 06 661          View Edit Delete
9732  AG06000151 06 661          View Edit Delete
9737  AG06000156 06 661          View Edit Delete
9735  AG06000154 06 661          View Edit Delete
9731  AG06000150 06 661          View Edit Delete
9723  AG06000142 06 661          View Edit Delete
9707  AG06000126 06 661          View Edit Delete
9744  AG06000163 06 661          View Edit Delete
9740  AG06000159 06 661          View Edit Delete
9748  AG06000167 06 661          View Edit Delete
9751  AG06000170 06 661          View Edit Delete
9747  AG06000166 06 661          View Edit Delete
9739  AG06000158 06 661          View Edit Delete
9738  AG06000157 06 661          View Edit Delete
9706  AG06000125 06 661          View Edit Delete
9642  AG06000061 06 661          View Edit Delete

Page 16 of 373, showing 20 records out of 7458 total, starting on record 301, ending on 320

(default) 2 queries took 25 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 300, 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 = 11118