Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9992  AG06000411 06 661          View Edit Delete
9994  AG06000413 06 661          View Edit Delete
9993  AG06000412 06 661          View Edit Delete
9991  AG06000410 06 661          View Edit Delete
9996  AG06000415 06 661          View Edit Delete
9998  AG06000417 06 661          View Edit Delete
9997  AG06000416 06 661          View Edit Delete
9995  AG06000414 06 661          View Edit Delete
10000  AG06000419 06 661          View Edit Delete
10002  AG06000421 06 661          View Edit Delete
10001  AG06000420 06 661          View Edit Delete
9999  AG06000418 06 661          View Edit Delete
10003  AG06000422 06 661          View Edit Delete
10004  AG06000423 06 661          View Edit Delete
10463  AG06000882 06 661          View Edit Delete
10484  AG06000903 06 661          View Edit Delete
10490  AG06000909 06 661          View Edit Delete
10138  AG06000557 06 661          View Edit Delete
10117  AG06000536 06 661          View Edit Delete
9983  AG06000402 06 661          View Edit Delete

Page 60 of 373, showing 20 records out of 7458 total, starting on record 1181, ending on 1200

(default) 2 queries took 25 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 1180, 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 = 11116