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
5512  AG02000013 02 51          View Edit Delete
5506  AG02000007 02 51          View Edit Delete
5507  AG02000008 02 51          View Edit Delete
5522  AG02000023 02 51          View Edit Delete
5503  AG02000004 02 51          View Edit Delete
5504  AG02000005 02 51          View Edit Delete
5514  AG02000015 02 51          View Edit Delete
5502  AG02000003 02 51          View Edit Delete
5581  AG01001265 01 002          View Edit Delete
5518  AG02000019 02 51          View Edit Delete
5515  AG02000016 02 51          View Edit Delete
5531  AG02000032 02 51          View Edit Delete
5555  AG01001918 01 002          View Edit Delete
5557  AG01001931 01 002          View Edit Delete
5576  AG01001844 01 002          View Edit Delete
5552  AG01002709 01 002          View Edit Delete
5547  AG01001892 01 002          View Edit Delete
5578  AG01001713 01 002          View Edit Delete

Page 3 of 373, showing 20 records out of 7458 total, starting on record 41, ending on 60

(default) 2 queries took 22 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 40, 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 = 11117