Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6379  AG02000058 02 51          View Edit Delete
6365  AG02000054 02 51          View Edit Delete
6351  AG01003015 01 010          View Edit Delete
6330  AG02000038 02 51          View Edit Delete
6297  AG03000006 03 61          View Edit Delete
5514  AG02000015 02 51          View Edit Delete
5519  AG02000020 02 51          View Edit Delete
5517  AG02000018 02 51          View Edit Delete
5513  AG02000014 02 51          View Edit Delete
5504  AG02000005 02 51          View Edit Delete
5530  AG02000031 02 51          View Edit Delete
5528  AG02000029 02 51          View Edit Delete
5521  AG02000022 02 51          View Edit Delete
5533  AG02000034 02 51          View Edit Delete
5531  AG02000032 02 51          View Edit Delete
5520  AG02000021 02 51          View Edit Delete
5503  AG02000004 02 51          View Edit Delete
5502  AG02000003 02 51          View Edit Delete
5501  AG02000002 02 51          View Edit Delete
5500  AG02000001 02 51          View Edit Delete

Page 7 of 373, showing 20 records out of 7458 total, starting on record 121, ending on 140

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