Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5583  AG01002588 01 002          View Edit Delete
5584  AG01001257 01 002          View Edit Delete
5588  AG01001828 01 002          View Edit Delete
5590  AG01001805 01 002          View Edit Delete
5597  AG01001852 01 002          View Edit Delete
5600  AG01001579 01 002          View Edit Delete
5602  AG01001559 01 002          View Edit Delete
5606  AG01001265 01 006          View Edit Delete
5607  AG01001266 01 006          View Edit Delete
5609  AG01001579 01 006          View Edit Delete
5610  AG01001828 01 006          View Edit Delete
6996  AG02000060 02 51          View Edit Delete
6995  AG01003292 01 010          View Edit Delete
6380  AG02000059 02 51          View Edit Delete
6998  AG02000061 02 51          View Edit Delete
7099  AG01003305 01 010          View Edit Delete
7095  AG01003294 01 010          View Edit Delete
6997  AG01003293 01 010          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9664  AG06000083 06 661          View Edit Delete

Page 16 of 373, showing 20 records out of 7458 total, starting on record 301, ending on 320

(default) 2 queries took 22 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`.`created` asc LIMIT 300, 2020205
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