Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5568  AG01001720 01 002          View Edit Delete
5543  AG01001272 01 002          View Edit Delete
5502  AG02000003 02 51          View Edit Delete
6285  AG01002994 01 010          View Edit Delete
5610  AG01001828 01 006          View Edit Delete
5501  AG02000002 02 51          View Edit Delete
5500  AG02000001 02 51          View Edit Delete
9588  AG06000007 06 661          View Edit Delete
9595  AG06000014 06 661          View Edit Delete
9591  AG06000010 06 661          View Edit Delete
9589  AG06000008 06 661          View Edit Delete
9596  AG06000015 06 661          View Edit Delete
9587  AG06000006 06 661          View Edit Delete
9592  AG06000011 06 661          View Edit Delete
9590  AG06000009 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9594  AG06000013 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete
9593  AG06000012 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete

Page 8 of 373, showing 20 records out of 7458 total, starting on record 141, ending on 160

(default) 2 queries took 23 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 140, 2020206
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