Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10155  AG06000574 06 661          View Edit Delete
10157  AG06000576 06 661          View Edit Delete
9791  AG06000210 06 661          View Edit Delete
10067  AG06000486 06 661          View Edit Delete
9931  AG06000350 06 661          View Edit Delete
9926  AG06000345 06 661          View Edit Delete
9927  AG06000346 06 661          View Edit Delete
10287  AG06000706 06 661          View Edit Delete
10289  AG06000708 06 661          View Edit Delete
10072  AG06000491 06 661          View Edit Delete
9792  AG06000211 06 661          View Edit Delete
9638  AG06000057 06 661          View Edit Delete
9885  AG06000304 06 661          View Edit Delete
9798  AG06000217 06 661          View Edit Delete
9797  AG06000216 06 661          View Edit Delete
9800  AG06000219 06 661          View Edit Delete
9802  AG06000221 06 661          View Edit Delete
9801  AG06000220 06 661          View Edit Delete
9799  AG06000218 06 661          View Edit Delete
9803  AG06000222 06 661          View Edit Delete

Page 50 of 373, showing 20 records out of 7458 total, starting on record 981, ending on 1000

(default) 2 queries took 26 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`.`company_cd` desc LIMIT 980, 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 = 11117