Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9708  AG06000127 06 661          View Edit Delete
9711  AG06000130 06 661          View Edit Delete
9709  AG06000128 06 661          View Edit Delete
9833  AG06000252 06 661          View Edit Delete
9835  AG06000254 06 661          View Edit Delete
9843  AG06000262 06 661          View Edit Delete
9850  AG06000269 06 661          View Edit Delete
9841  AG06000260 06 661          View Edit Delete
9578  AG06000001 06 661  2022-03-09 15:28:43  MG00000001  2022-03-09 15:28:43  MG00000001  View Edit Delete
9580  AG06000002 06 661  2022-03-11 10:31:06  MG00000001  2022-03-11 10:31:06  MG00000001  View Edit Delete
9847  AG06000266 06 661          View Edit Delete
9822  AG06000241 06 661          View Edit Delete
9849  AG06000268 06 661          View Edit Delete
9595  AG06000014 06 661          View Edit Delete
9594  AG06000013 06 661          View Edit Delete
9584  AG06000003 06 661  2022-03-15 13:58:12  MG00000001  2022-03-15 13:58:12  MG00000001  View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9828  AG06000247 06 661          View Edit Delete
9825  AG06000244 06 661          View Edit Delete

Page 21 of 373, showing 20 records out of 7458 total, starting on record 401, ending on 420

(default) 2 queries took 24 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 400, 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 = 11117