Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
7095  AG01003294 01 010          View Edit Delete
6998  AG02000061 02 51          View Edit Delete
9604  AG06000023 06 661          View Edit Delete
7099  AG01003305 01 010          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
5500  AG02000001 02 51          View Edit Delete
5501  AG02000002 02 51          View Edit Delete
5502  AG02000003 02 51          View Edit Delete
5503  AG02000004 02 51          View Edit Delete
5504  AG02000005 02 51          View Edit Delete
5505  AG02000006 02 51          View Edit Delete
5506  AG02000007 02 51          View Edit Delete
5507  AG02000008 02 51          View Edit Delete
5508  AG02000009 02 51          View Edit Delete
5510  AG02000011 02 51          View Edit Delete
5511  AG02000012 02 51          View Edit Delete
5512  AG02000013 02 51          View Edit Delete
5513  AG02000014 02 51          View Edit Delete
5514  AG02000015 02 51          View Edit Delete
5515  AG02000016 02 51          View Edit Delete

Page 13 of 373, showing 20 records out of 7458 total, starting on record 241, ending on 260

(default) 2 queries took 21 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 240, 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 = 11116