Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9825  AG06000244 06 661          View Edit Delete
9817  AG06000236 06 661          View Edit Delete
9801  AG06000220 06 661          View Edit Delete
9769  AG06000188 06 661          View Edit Delete
9723  AG06000142 06 661          View Edit Delete
9844  AG06000263 06 661          View Edit Delete
9849  AG06000268 06 661          View Edit Delete
9847  AG06000266 06 661          View Edit Delete
9843  AG06000262 06 661          View Edit Delete
9835  AG06000254 06 661          View Edit Delete
9857  AG06000276 06 661          View Edit Delete
9855  AG06000274 06 661          View Edit Delete
9851  AG06000270 06 661          View Edit Delete
9859  AG06000278 06 661          View Edit Delete
9858  AG06000277 06 661          View Edit Delete
9850  AG06000269 06 661          View Edit Delete
9834  AG06000253 06 661          View Edit Delete
9833  AG06000252 06 661          View Edit Delete
9832  AG06000251 06 661          View Edit Delete
9722  AG06000141 06 661          View Edit Delete

Page 23 of 373, showing 20 records out of 7458 total, starting on record 441, ending on 460

(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`.`insert_user` asc LIMIT 440, 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