Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5530  AG02000031 02 51          View Edit Delete
5523  AG02000024 02 51          View Edit Delete
5538  AG01001269 01 002          View Edit Delete
5544  AG01001569 01 002          View Edit Delete
5542  AG01001687 01 002          View Edit Delete
5534  AG02000035 02 51          View Edit Delete
5522  AG02000023 02 51          View Edit Delete
5505  AG02000006 02 51          View Edit Delete
5554  AG01001307 01 002          View Edit Delete
5549  AG01001741 01 002          View Edit Delete
5559  AG01002724 01 002          View Edit Delete
5572  AG01001874 01 002          View Edit Delete
5563  AG01001704 01 002          View Edit Delete
5558  AG01001305 01 002          View Edit Delete
5547  AG01001892 01 002          View Edit Delete
5578  AG01001713 01 002          View Edit Delete
5576  AG01001844 01 002          View Edit Delete
5545  AG01001633 01 002          View Edit Delete
5504  AG02000005 02 51          View Edit Delete
5344  AG01001516 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete

Page 6 of 373, showing 20 records out of 7458 total, starting on record 101, ending on 120

(default) 2 queries took 24 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`.`update_user` asc LIMIT 100, 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 = 11118