Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10474  AG06000893 06 661          View Edit Delete
10467  AG06000886 06 661          View Edit Delete
9599  AG06000018 06 661          View Edit Delete
9592  AG06000011 06 661          View Edit Delete
9611  AG06000030 06 661          View Edit Delete
9609  AG06000028 06 661          View Edit Delete
9606  AG06000025 06 661          View Edit Delete
9613  AG06000032 06 661          View Edit Delete
9617  AG06000036 06 661          View Edit Delete
9615  AG06000034 06 661          View Edit Delete
9612  AG06000031 06 661          View Edit Delete
9605  AG06000024 06 661          View Edit Delete
9591  AG06000010 06 661          View Edit Delete
9619  AG06000038 06 661          View Edit Delete
9618  AG06000037 06 661          View Edit Delete
9590  AG06000009 06 661          View Edit Delete
9589  AG06000008 06 661          View Edit Delete
9588  AG06000007 06 661          View Edit Delete
9587  AG06000006 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete

Page 52 of 373, showing 20 records out of 7458 total, starting on record 1021, ending on 1040

(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 1020, 2020208
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