Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9936  AG06000355 06 661          View Edit Delete
9937  AG06000356 06 661          View Edit Delete
9938  AG06000357 06 661          View Edit Delete
9939  AG06000358 06 661          View Edit Delete
9940  AG06000359 06 661          View Edit Delete
9941  AG06000360 06 661          View Edit Delete
9942  AG06000361 06 661          View Edit Delete
9943  AG06000362 06 661          View Edit Delete
9944  AG06000363 06 661          View Edit Delete
9945  AG06000364 06 661          View Edit Delete
9946  AG06000365 06 661          View Edit Delete
9947  AG06000366 06 661          View Edit Delete
9948  AG06000367 06 661          View Edit Delete
9949  AG06000368 06 661          View Edit Delete
9950  AG06000369 06 661          View Edit Delete
9951  AG06000370 06 661          View Edit Delete
9952  AG06000371 06 661          View Edit Delete
9822  AG06000241 06 661          View Edit Delete
9828  AG06000247 06 661          View Edit Delete
9829  AG06000248 06 661          View Edit Delete

Page 26 of 373, showing 20 records out of 7458 total, starting on record 501, ending on 520

(default) 2 queries took 22 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`.`trader_id` desc LIMIT 500, 2020206
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 = 11116