Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9578  AG06000001 06 661  2022-03-09 15:28:43  MG00000001  2022-03-09 15:28:43  MG00000001  View Edit Delete
9620  AG06000039 06 661          View Edit Delete
9618  AG06000037 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete
9598  AG06000017 06 661          View Edit Delete
9587  AG06000006 06 661          View Edit Delete
9624  AG06000043 06 661          View Edit Delete
9629  AG06000048 06 661          View Edit Delete
9635  AG06000054 06 661          View Edit Delete
9631  AG06000050 06 661          View Edit Delete
9615  AG06000034 06 661          View Edit Delete
9613  AG06000032 06 661          View Edit Delete
9640  AG06000059 06 661          View Edit Delete
9637  AG06000056 06 661          View Edit Delete
9619  AG06000038 06 661          View Edit Delete
10028  AG06000447 06 661          View Edit Delete
9621  AG06000040 06 661          View Edit Delete
9632  AG06000051 06 661          View Edit Delete
9638  AG06000057 06 661          View Edit Delete
9639  AG06000058 06 661          View Edit Delete

Page 31 of 373, showing 20 records out of 7458 total, starting on record 601, ending on 620

(default) 2 queries took 23 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 600, 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 = 11116