Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
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
9988  AG06000407 06 661          View Edit Delete

Page 261 of 373, showing 20 records out of 7458 total, starting on record 5201, ending on 5220

(default) 2 queries took 36 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` desc LIMIT 5200, 20202019
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