Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6305  AG03000014 03 61          View Edit Delete
6301  AG03000010 03 61          View Edit Delete
6309  AG03000018 03 61          View Edit Delete
6314  AG03000023 03 61          View Edit Delete
6312  AG03000021 03 61          View Edit Delete
6308  AG03000017 03 61          View Edit Delete
6300  AG03000009 03 61          View Edit Delete
5610  AG01001828 01 006          View Edit Delete
6321  AG03000030 03 61          View Edit Delete
6317  AG03000026 03 61          View Edit Delete
6326  AG01003004 01 010          View Edit Delete
6331  AG02000039 02 51          View Edit Delete
6329  AG02000037 02 51          View Edit Delete
6324  AG01003003 01 010          View Edit Delete
6316  AG03000025 03 61          View Edit Delete
6333  AG01003006 01 010          View Edit Delete
6332  AG02000040 02 51          View Edit Delete
6315  AG03000024 03 61          View Edit Delete
5609  AG01001579 01 006          View Edit Delete
5500  AG02000001 02 51          View Edit Delete

Page 6 of 373, showing 20 records out of 7458 total, starting on record 101, ending on 120

(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 100, 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