Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9616  AG06000035 06 661          View Edit Delete
9607  AG06000026 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete
9588  AG06000007 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9595  AG06000014 06 661          View Edit Delete
9591  AG06000010 06 661          View Edit Delete
9599  AG06000018 06 661          View Edit Delete
9604  AG06000023 06 661          View Edit Delete
9602  AG06000021 06 661          View Edit Delete
9598  AG06000017 06 661          View Edit Delete
9590  AG06000009 06 661          View Edit Delete
9612  AG06000031 06 661          View Edit Delete
9610  AG06000029 06 661          View Edit Delete
9606  AG06000025 06 661          View Edit Delete
9614  AG06000033 06 661          View Edit Delete
9617  AG06000036 06 661          View Edit Delete
9613  AG06000032 06 661          View Edit Delete
9605  AG06000024 06 661          View Edit Delete
9589  AG06000008 06 661          View Edit Delete

Page 9 of 373, showing 20 records out of 7458 total, starting on record 161, ending on 180

(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`.`insert_user` asc LIMIT 160, 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 = 11117