Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9947  AG06000366 06 661          View Edit Delete
9946  AG06000365 06 661          View Edit Delete
9945  AG06000364 06 661          View Edit Delete
9944  AG06000363 06 661          View Edit Delete
9943  AG06000362 06 661          View Edit Delete
9942  AG06000361 06 661          View Edit Delete
9941  AG06000360 06 661          View Edit Delete
9940  AG06000359 06 661          View Edit Delete
9939  AG06000358 06 661          View Edit Delete
9938  AG06000357 06 661          View Edit Delete
9937  AG06000356 06 661          View Edit Delete
9936  AG06000355 06 661          View Edit Delete
9935  AG06000354 06 661          View Edit Delete
9934  AG06000353 06 661          View Edit Delete
9933  AG06000352 06 661          View Edit Delete
9932  AG06000351 06 661          View Edit Delete
9931  AG06000350 06 661          View Edit Delete
9930  AG06000349 06 661          View Edit Delete
9929  AG06000348 06 661          View Edit Delete
9928  AG06000347 06 661          View Edit Delete

Page 264 of 373, showing 20 records out of 7458 total, starting on record 5261, ending on 5280

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