Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10147  AG06000566 06 661          View Edit Delete
10146  AG06000565 06 661          View Edit Delete
10145  AG06000564 06 661          View Edit Delete
10144  AG06000563 06 661          View Edit Delete
10143  AG06000562 06 661          View Edit Delete
10142  AG06000561 06 661          View Edit Delete
10141  AG06000560 06 661          View Edit Delete
10140  AG06000559 06 661          View Edit Delete
10139  AG06000558 06 661          View Edit Delete
10138  AG06000557 06 661          View Edit Delete
10137  AG06000556 06 661          View Edit Delete
10136  AG06000555 06 661          View Edit Delete
10135  AG06000554 06 661          View Edit Delete
10134  AG06000553 06 661          View Edit Delete
10133  AG06000552 06 661          View Edit Delete
10132  AG06000551 06 661          View Edit Delete
10131  AG06000550 06 661          View Edit Delete
10130  AG06000549 06 661          View Edit Delete
10129  AG06000548 06 661          View Edit Delete
10128  AG06000547 06 661          View Edit Delete

Page 254 of 373, showing 20 records out of 7458 total, starting on record 5061, ending on 5080

(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 5060, 20202018
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