Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9808  AG06000227 06 661          View Edit Delete
9811  AG06000230 06 661          View Edit Delete
9807  AG06000226 06 661          View Edit Delete
9799  AG06000218 06 661          View Edit Delete
9798  AG06000217 06 661          View Edit Delete
9766  AG06000185 06 661          View Edit Delete
9702  AG06000121 06 661          View Edit Delete
9628  AG06000047 06 661          View Edit Delete
9624  AG06000043 06 661          View Edit Delete
9617  AG06000036 06 661          View Edit Delete
9609  AG06000028 06 661          View Edit Delete
9593  AG06000012 06 661          View Edit Delete
9643  AG06000062 06 661          View Edit Delete
9646  AG06000065 06 661          View Edit Delete
9642  AG06000061 06 661          View Edit Delete
9634  AG06000053 06 661          View Edit Delete
9633  AG06000052 06 661          View Edit Delete
9632  AG06000051 06 661          View Edit Delete
9670  AG06000089 06 661          View Edit Delete
9631  AG06000050 06 661          View Edit Delete

Page 19 of 373, showing 20 records out of 7458 total, starting on record 361, ending on 380

(default) 2 queries took 24 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 360, 2020207
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