Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9676  AG06000095 06 661          View Edit Delete
9674  AG06000093 06 661          View Edit Delete
9673  AG06000092 06 661          View Edit Delete
9675  AG06000094 06 661          View Edit Delete
9672  AG06000091 06 661          View Edit Delete
9671  AG06000090 06 661          View Edit Delete
9667  AG06000086 06 661          View Edit Delete
9666  AG06000085 06 661          View Edit Delete
9665  AG06000084 06 661          View Edit Delete
9669  AG06000088 06 661          View Edit Delete
9668  AG06000087 06 661          View Edit Delete
9670  AG06000089 06 661          View Edit Delete
9616  AG06000035 06 661          View Edit Delete
9615  AG06000034 06 661          View Edit Delete
9621  AG06000040 06 661          View Edit Delete
9620  AG06000039 06 661          View Edit Delete
9619  AG06000038 06 661          View Edit Delete
9623  AG06000042 06 661          View Edit Delete
9622  AG06000041 06 661          View Edit Delete
9618  AG06000037 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 25 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`.`created` asc 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 = 11118