Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9607  AG06000026 06 661          View Edit Delete
9595  AG06000014 06 661          View Edit Delete
9621  AG06000040 06 661          View Edit Delete
9629  AG06000048 06 661          View Edit Delete
9604  AG06000023 06 661          View Edit Delete
9605  AG06000024 06 661          View Edit Delete
9601  AG06000020 06 661          View Edit Delete
9615  AG06000034 06 661          View Edit Delete
9613  AG06000032 06 661          View Edit Delete
9609  AG06000028 06 661          View Edit Delete
9620  AG06000039 06 661          View Edit Delete
9616  AG06000035 06 661          View Edit Delete
9608  AG06000027 06 661          View Edit Delete
9627  AG06000046 06 661          View Edit Delete
9623  AG06000042 06 661          View Edit Delete
9628  AG06000047 06 661          View Edit Delete
9630  AG06000049 06 661          View Edit Delete
9622  AG06000041 06 661          View Edit Delete
9618  AG06000037 06 661          View Edit Delete
9600  AG06000019 06 661          View Edit Delete

Page 10 of 373, showing 20 records out of 7458 total, starting on record 181, ending on 200

(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 180, 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