Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9639  AG06000058 06 661          View Edit Delete
9648  AG06000067 06 661          View Edit Delete
9649  AG06000068 06 661          View Edit Delete
9643  AG06000062 06 661          View Edit Delete
9638  AG06000057 06 661          View Edit Delete
9622  AG06000041 06 661          View Edit Delete
9655  AG06000074 06 661          View Edit Delete
9651  AG06000070 06 661          View Edit Delete
9654  AG06000073 06 661          View Edit Delete
9666  AG06000085 06 661          View Edit Delete
9664  AG06000083 06 661          View Edit Delete
9658  AG06000077 06 661          View Edit Delete
9653  AG06000072 06 661          View Edit Delete
9665  AG06000084 06 661          View Edit Delete
9672  AG06000091 06 661          View Edit Delete
9667  AG06000086 06 661          View Edit Delete
9652  AG06000071 06 661          View Edit Delete
9618  AG06000037 06 661          View Edit Delete
9670  AG06000089 06 661          View Edit Delete
9620  AG06000039 06 661          View Edit Delete

Page 12 of 373, showing 20 records out of 7458 total, starting on record 221, ending on 240

(default) 2 queries took 24 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 220, 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 = 11118