Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5520  AG02000021 02 51          View Edit Delete
5500  AG02000001 02 51          View Edit Delete
5523  AG02000024 02 51          View Edit Delete
5519  AG02000020 02 51          View Edit Delete
5501  AG02000002 02 51          View Edit Delete
5534  AG02000035 02 51          View Edit Delete
5542  AG01001687 01 002          View Edit Delete
5506  AG02000007 02 51          View Edit Delete
5527  AG02000028 02 51          View Edit Delete
5547  AG01001892 01 002          View Edit Delete
5521  AG02000022 02 51          View Edit Delete
5507  AG02000008 02 51          View Edit Delete
5538  AG01001269 01 002          View Edit Delete
5522  AG02000023 02 51          View Edit Delete
5530  AG02000031 02 51          View Edit Delete
5510  AG02000011 02 51          View Edit Delete
5514  AG02000015 02 51          View Edit Delete
5518  AG02000019 02 51          View Edit Delete
5502  AG02000003 02 51          View Edit Delete
5513  AG02000014 02 51          View Edit Delete

Page 2 of 373, showing 20 records out of 7458 total, starting on record 21, ending on 40

(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`.`created` asc LIMIT 20, 2020205
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 = 11118