Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9928  AG06000347 06 661          View Edit Delete
9930  AG06000349 06 661          View Edit Delete
9929  AG06000348 06 661          View Edit Delete
9927  AG06000346 06 661          View Edit Delete
9932  AG06000351 06 661          View Edit Delete
9934  AG06000353 06 661          View Edit Delete
9933  AG06000352 06 661          View Edit Delete
9931  AG06000350 06 661          View Edit Delete
9936  AG06000355 06 661          View Edit Delete
9938  AG06000357 06 661          View Edit Delete
9937  AG06000356 06 661          View Edit Delete
9935  AG06000354 06 661          View Edit Delete
9940  AG06000359 06 661          View Edit Delete
9942  AG06000361 06 661          View Edit Delete
9941  AG06000360 06 661          View Edit Delete
9939  AG06000358 06 661          View Edit Delete
9943  AG06000362 06 661          View Edit Delete
10035  AG06000454 06 661          View Edit Delete
10079  AG06000498 06 661          View Edit Delete
9924  AG06000343 06 661          View Edit Delete

Page 57 of 373, showing 20 records out of 7458 total, starting on record 1121, ending on 1140

(default) 2 queries took 28 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`.`company_cd` desc LIMIT 1120, 20202011
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