Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9606  AG06000025 06 661          View Edit Delete
9594  AG06000013 06 661          View Edit Delete
9614  AG06000033 06 661          View Edit Delete
9612  AG06000031 06 661          View Edit Delete
9601  AG06000020 06 661          View Edit Delete
9598  AG06000017 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete
9620  AG06000039 06 661          View Edit Delete
9609  AG06000028 06 661          View Edit Delete
9608  AG06000027 06 661          View Edit Delete
9622  AG06000041 06 661          View Edit Delete
9623  AG06000042 06 661          View Edit Delete
9616  AG06000035 06 661          View Edit Delete
9613  AG06000032 06 661          View Edit Delete
9628  AG06000047 06 661          View Edit Delete
9627  AG06000046 06 661          View Edit Delete
9615  AG06000034 06 661          View Edit Delete
9585  AG06000004 06 661          View Edit Delete
9848  AG06000267 06 661          View Edit Delete
9845  AG06000264 06 661          View Edit Delete

Page 22 of 373, showing 20 records out of 7458 total, starting on record 421, ending on 440

(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`.`trader_id` desc LIMIT 420, 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