Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9990  AG06000409 06 661          View Edit Delete
9991  AG06000410 06 661          View Edit Delete
9992  AG06000411 06 661          View Edit Delete
9993  AG06000412 06 661          View Edit Delete
9994  AG06000413 06 661          View Edit Delete
9995  AG06000414 06 661          View Edit Delete
9996  AG06000415 06 661          View Edit Delete
9997  AG06000416 06 661          View Edit Delete
9998  AG06000417 06 661          View Edit Delete
9999  AG06000418 06 661          View Edit Delete
10000  AG06000419 06 661          View Edit Delete
10001  AG06000420 06 661          View Edit Delete
10002  AG06000421 06 661          View Edit Delete
10003  AG06000422 06 661          View Edit Delete
10004  AG06000423 06 661          View Edit Delete
10005  AG06000424 06 661          View Edit Delete
10006  AG06000425 06 661          View Edit Delete
10007  AG06000426 06 661          View Edit Delete
10008  AG06000427 06 661          View Edit Delete
10009  AG06000428 06 661          View Edit Delete

Page 113 of 373, showing 20 records out of 7458 total, starting on record 2241, ending on 2260

(default) 2 queries took 27 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` asc LIMIT 2240, 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 = 11118