Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9899  AG06000318 06 661          View Edit Delete
9900  AG06000319 06 661          View Edit Delete
9904  AG06000323 06 661          View Edit Delete
9905  AG06000324 06 661          View Edit Delete
9907  AG06000326 06 661          View Edit Delete
9908  AG06000327 06 661          View Edit Delete
9910  AG06000329 06 661          View Edit Delete
9911  AG06000330 06 661          View Edit Delete
9912  AG06000331 06 661          View Edit Delete
9913  AG06000332 06 661          View Edit Delete
9916  AG06000335 06 661          View Edit Delete
9917  AG06000336 06 661          View Edit Delete
9919  AG06000338 06 661          View Edit Delete
9920  AG06000339 06 661          View Edit Delete
9923  AG06000342 06 661          View Edit Delete
9924  AG06000343 06 661          View Edit Delete
9926  AG06000345 06 661          View Edit Delete
9927  AG06000346 06 661          View Edit Delete
9931  AG06000350 06 661          View Edit Delete
9932  AG06000351 06 661          View Edit Delete

Page 28 of 373, showing 20 records out of 7458 total, starting on record 541, ending on 560

(default) 2 queries took 26 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 540, 2020208
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