Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5515  AG02000016 02 51          View Edit Delete
5516  AG02000017 02 51          View Edit Delete
5517  AG02000018 02 51          View Edit Delete
5518  AG02000019 02 51          View Edit Delete
5519  AG02000020 02 51          View Edit Delete
5520  AG02000021 02 51          View Edit Delete
5521  AG02000022 02 51          View Edit Delete
5522  AG02000023 02 51          View Edit Delete
5523  AG02000024 02 51          View Edit Delete
5527  AG02000028 02 51          View Edit Delete
5528  AG02000029 02 51          View Edit Delete
5529  AG02000030 02 51          View Edit Delete
5530  AG02000031 02 51          View Edit Delete
5531  AG02000032 02 51          View Edit Delete
5533  AG02000034 02 51          View Edit Delete
5534  AG02000035 02 51          View Edit Delete
5538  AG01001269 01 002          View Edit Delete
5540  AG01001264 01 002          View Edit Delete
5541  AG01001739 01 002          View Edit Delete
5542  AG01001687 01 002          View Edit Delete

Page 14 of 373, showing 20 records out of 7458 total, starting on record 261, ending on 280

(default) 2 queries took 19 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`.`id` asc LIMIT 260, 2020202
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