Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10708  AG06001127 06 661          View Edit Delete
10707  AG06001126 06 661          View Edit Delete
10706  AG06001125 06 661          View Edit Delete
10705  AG06001124 06 661          View Edit Delete
10704  AG06001123 06 661          View Edit Delete
10703  AG06001122 06 661          View Edit Delete
10702  AG06001121 06 661          View Edit Delete
10701  AG06001120 06 661          View Edit Delete
10700  AG06001119 06 661          View Edit Delete
10699  AG06001118 06 661          View Edit Delete
10698  AG06001117 06 661          View Edit Delete
10697  AG06001116 06 661          View Edit Delete
10696  AG06001115 06 661          View Edit Delete
10695  AG06001114 06 661          View Edit Delete
10694  AG06001113 06 661          View Edit Delete
10693  AG06001112 06 661          View Edit Delete
10692  AG06001111 06 661          View Edit Delete
10691  AG06001110 06 661          View Edit Delete
10690  AG06001109 06 661          View Edit Delete
10689  AG06001108 06 661          View Edit Delete

Page 11 of 373, showing 20 records out of 7458 total, starting on record 201, ending on 220

(default) 2 queries took 24 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 200, 2020207
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