Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5506  AG02000007 02 51          View Edit Delete
5551  AG01001278 01 002          View Edit Delete
5590  AG01001805 01 002          View Edit Delete
5581  AG01001265 01 002          View Edit Delete
5547  AG01001892 01 002          View Edit Delete
5516  AG02000017 02 51          View Edit Delete
5505  AG02000006 02 51          View Edit Delete
5504  AG02000005 02 51          View Edit Delete
5522  AG02000023 02 51          View Edit Delete
5538  AG01001269 01 002          View Edit Delete
5533  AG02000034 02 51          View Edit Delete
5520  AG02000021 02 51          View Edit Delete
5510  AG02000011 02 51          View Edit Delete
5559  AG01002724 01 002          View Edit Delete
5557  AG01001931 01 002          View Edit Delete
5544  AG01001569 01 002          View Edit Delete
5576  AG01001844 01 002          View Edit Delete
5597  AG01001852 01 002          View Edit Delete
5568  AG01001720 01 002          View Edit Delete
5552  AG01002709 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 25 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 40, 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 = 11119