Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9592  AG06000011 06 661          View Edit Delete
9728  AG06000147 06 661          View Edit Delete
9944  AG06000363 06 661          View Edit Delete
9947  AG06000366 06 661          View Edit Delete
9589  AG06000008 06 661          View Edit Delete
9988  AG06000407 06 661          View Edit Delete
9591  AG06000010 06 661          View Edit Delete
9593  AG06000012 06 661          View Edit Delete
9594  AG06000013 06 661          View Edit Delete
9595  AG06000014 06 661          View Edit Delete
9596  AG06000015 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
9730  AG06000149 06 661          View Edit Delete
9817  AG06000236 06 661          View Edit Delete
9729  AG06000148 06 661          View Edit Delete
9726  AG06000145 06 661          View Edit Delete
9942  AG06000361 06 661          View Edit Delete
9943  AG06000362 06 661          View Edit Delete
9588  AG06000007 06 661          View Edit Delete
9590  AG06000009 06 661          View Edit Delete

Page 33 of 373, showing 20 records out of 7458 total, starting on record 641, ending on 660

(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`.`company_cd` desc LIMIT 640, 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