Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9673  AG06000092 06 661          View Edit Delete
9671  AG06000090 06 661          View Edit Delete
9677  AG06000096 06 661          View Edit Delete
9679  AG06000098 06 661          View Edit Delete
9678  AG06000097 06 661          View Edit Delete
9676  AG06000095 06 661          View Edit Delete
9681  AG06000100 06 661          View Edit Delete
9683  AG06000102 06 661          View Edit Delete
9682  AG06000101 06 661          View Edit Delete
9680  AG06000099 06 661          View Edit Delete
9595  AG06000014 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete
9596  AG06000015 06 661          View Edit Delete
9594  AG06000013 06 661          View Edit Delete
9599  AG06000018 06 661          View Edit Delete
9601  AG06000020 06 661          View Edit Delete
9600  AG06000019 06 661          View Edit Delete
9598  AG06000017 06 661          View Edit Delete
9604  AG06000023 06 661          View Edit Delete
9603  AG06000022 06 661          View Edit Delete

Page 26 of 373, showing 20 records out of 7458 total, starting on record 501, ending on 520

(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`.`modified` asc LIMIT 500, 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