Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9593  AG06000012 06 661          View Edit Delete
9591  AG06000010 06 661          View Edit Delete
9596  AG06000015 06 661          View Edit Delete
9597  AG06000016 06 661          View Edit Delete
9595  AG06000014 06 661          View Edit Delete
6285  AG01002994 01 010          View Edit Delete
6286  AG01002995 01 010          View Edit Delete
6287  AG01002996 01 010          View Edit Delete
6288  AG01002997 01 010          View Edit Delete
6289  AG01002998 01 010          View Edit Delete
6290  AG01002999 01 010          View Edit Delete
6291  AG01003000 01 010          View Edit Delete
6292  AG03000001 03 61          View Edit Delete
6293  AG03000002 03 61          View Edit Delete
6294  AG03000003 03 61          View Edit Delete
6295  AG03000004 03 61          View Edit Delete
6296  AG03000005 03 61          View Edit Delete
6297  AG03000006 03 61          View Edit Delete
6298  AG03000007 03 61          View Edit Delete
6299  AG03000008 03 61          View Edit Delete

Page 17 of 373, showing 20 records out of 7458 total, starting on record 321, ending on 340

(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`.`modified` asc LIMIT 320, 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