Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
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
10528  AG06000947 06 661          View Edit Delete

Page 234 of 373, showing 20 records out of 7458 total, starting on record 4661, ending on 4680

(default) 2 queries took 35 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`.`id` desc LIMIT 4660, 20202018
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