Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10439  AG06000858 06 661          View Edit Delete
9908  AG06000327 06 661          View Edit Delete
9904  AG06000323 06 661          View Edit Delete
9912  AG06000331 06 661          View Edit Delete
9913  AG06000332 06 661          View Edit Delete
9924  AG06000343 06 661          View Edit Delete
9905  AG06000324 06 661          View Edit Delete
9871  AG06000290 06 661          View Edit Delete
9930  AG06000349 06 661          View Edit Delete
9874  AG06000293 06 661          View Edit Delete
9911  AG06000330 06 661          View Edit Delete
9915  AG06000334 06 661          View Edit Delete
9917  AG06000336 06 661          View Edit Delete
9914  AG06000333 06 661          View Edit Delete
9937  AG06000356 06 661          View Edit Delete
9941  AG06000360 06 661          View Edit Delete
9940  AG06000359 06 661          View Edit Delete
9943  AG06000362 06 661          View Edit Delete
9942  AG06000361 06 661          View Edit Delete
9875  AG06000294 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 27 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`.`trader_id` desc LIMIT 1120, 2020209
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