Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9696  AG06000115 06 661          View Edit Delete
9688  AG06000107 06 661          View Edit Delete
9710  AG06000129 06 661          View Edit Delete
9708  AG06000127 06 661          View Edit Delete
9704  AG06000123 06 661          View Edit Delete
9712  AG06000131 06 661          View Edit Delete
9717  AG06000136 06 661          View Edit Delete
9715  AG06000134 06 661          View Edit Delete
9711  AG06000130 06 661          View Edit Delete
9703  AG06000122 06 661          View Edit Delete
9687  AG06000106 06 661          View Edit Delete
9724  AG06000143 06 661          View Edit Delete
9720  AG06000139 06 661          View Edit Delete
9728  AG06000147 06 661          View Edit Delete
9731  AG06000150 06 661          View Edit Delete
9727  AG06000146 06 661          View Edit Delete
9719  AG06000138 06 661          View Edit Delete
9718  AG06000137 06 661          View Edit Delete
9686  AG06000105 06 661          View Edit Delete
9622  AG06000041 06 661          View Edit Delete

Page 15 of 373, showing 20 records out of 7458 total, starting on record 281, ending on 300

(default) 2 queries took 25 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 280, 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 = 11118