Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10548  AG06000967 06 661          View Edit Delete
10547  AG06000966 06 661          View Edit Delete
10546  AG06000965 06 661          View Edit Delete
10545  AG06000964 06 661          View Edit Delete
10544  AG06000963 06 661          View Edit Delete
10543  AG06000962 06 661          View Edit Delete
10542  AG06000961 06 661          View Edit Delete
10541  AG06000960 06 661          View Edit Delete
10540  AG06000959 06 661          View Edit Delete
10539  AG06000958 06 661          View Edit Delete
10538  AG06000957 06 661          View Edit Delete
10537  AG06000956 06 661          View Edit Delete
10536  AG06000955 06 661          View Edit Delete
10535  AG06000954 06 661          View Edit Delete
10534  AG06000953 06 661          View Edit Delete
10533  AG06000952 06 661          View Edit Delete
10532  AG06000951 06 661          View Edit Delete
10531  AG06000950 06 661          View Edit Delete
10530  AG06000949 06 661          View Edit Delete
10529  AG06000948 06 661          View Edit Delete

Page 19 of 373, showing 20 records out of 7458 total, starting on record 361, ending on 380

(default) 2 queries took 31 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`.`farmer_id` desc LIMIT 360, 2020209
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 = 11122