Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9957  AG06000376 06 661          View Edit Delete
9956  AG06000375 06 661          View Edit Delete
9953  AG06000372 06 661          View Edit Delete
9947  AG06000366 06 661          View Edit Delete
9935  AG06000354 06 661          View Edit Delete
9963  AG06000382 06 661          View Edit Delete
9960  AG06000379 06 661          View Edit Delete
9967  AG06000386 06 661          View Edit Delete
9970  AG06000389 06 661          View Edit Delete
9969  AG06000388 06 661          View Edit Delete
9966  AG06000385 06 661          View Edit Delete
9959  AG06000378 06 661          View Edit Delete
9972  AG06000391 06 661          View Edit Delete
9971  AG06000390 06 661          View Edit Delete
9958  AG06000377 06 661          View Edit Delete
9934  AG06000353 06 661          View Edit Delete
9886  AG06000305 06 661          View Edit Delete
9783  AG06000202 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 38 of 373, showing 20 records out of 7458 total, starting on record 741, ending on 760

(default) 2 queries took 32 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`.`insert_user` asc LIMIT 740, 20202011
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 = 11121