Contractors

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

Page 46 of 373, showing 20 records out of 7458 total, starting on record 901, ending on 920

(default) 2 queries took 30 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`.`farmer_id` desc LIMIT 900, 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 = 11119