Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9707  AG06000126 06 661          View Edit Delete
9706  AG06000125 06 661          View Edit Delete
9705  AG06000124 06 661          View Edit Delete
9704  AG06000123 06 661          View Edit Delete
9703  AG06000122 06 661          View Edit Delete
9702  AG06000121 06 661          View Edit Delete
9701  AG06000120 06 661          View Edit Delete
9700  AG06000119 06 661          View Edit Delete
9699  AG06000118 06 661          View Edit Delete
9698  AG06000117 06 661          View Edit Delete
9697  AG06000116 06 661          View Edit Delete
9696  AG06000115 06 661          View Edit Delete
9695  AG06000114 06 661          View Edit Delete
9694  AG06000113 06 661          View Edit Delete
9693  AG06000112 06 661          View Edit Delete
9692  AG06000111 06 661          View Edit Delete
9691  AG06000110 06 661          View Edit Delete
9690  AG06000109 06 661          View Edit Delete
9689  AG06000108 06 661          View Edit Delete
9688  AG06000107 06 661          View Edit Delete

Page 276 of 373, showing 20 records out of 7458 total, starting on record 5501, ending on 5520

(default) 2 queries took 34 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 5500, 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 = 11116