Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10107  AG06000526 06 661          View Edit Delete
10106  AG06000525 06 661          View Edit Delete
10105  AG06000524 06 661          View Edit Delete
10104  AG06000523 06 661          View Edit Delete
10103  AG06000522 06 661          View Edit Delete
10102  AG06000521 06 661          View Edit Delete
10101  AG06000520 06 661          View Edit Delete
10100  AG06000519 06 661          View Edit Delete
10099  AG06000518 06 661          View Edit Delete
10098  AG06000517 06 661          View Edit Delete
10097  AG06000516 06 661          View Edit Delete
10096  AG06000515 06 661          View Edit Delete
10095  AG06000514 06 661          View Edit Delete
10094  AG06000513 06 661          View Edit Delete
10093  AG06000512 06 661          View Edit Delete
10092  AG06000511 06 661          View Edit Delete
10091  AG06000510 06 661          View Edit Delete
10090  AG06000509 06 661          View Edit Delete
10089  AG06000508 06 661          View Edit Delete
10088  AG06000507 06 661          View Edit Delete

Page 256 of 373, showing 20 records out of 7458 total, starting on record 5101, ending on 5120

(default) 2 queries took 37 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 5100, 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 = 11118