Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5563  AG01001704 01 002          View Edit Delete
5549  AG01001741 01 002          View Edit Delete
1324  AG01000700 01 002  2016-08-30 12:24:15  MG00000001  2016-08-30 12:24:15  MG00000001  View Edit Delete
7935  AG01003541 01 002  2018-07-11 10:57:28  MG00000001  2018-07-11 10:57:28  MG00000001  View Edit Delete
5559  AG01002724 01 002          View Edit Delete
7433  AG01003382 01 002  2018-04-02 09:41:12  MG00000001  2018-04-02 09:41:12  MG00000001  View Edit Delete
7794  AG01003495 01 002  2018-06-17 23:29:16  MG00000001  2018-06-17 23:29:16  MG00000001  View Edit Delete
7803  AG01003515 01 002  2018-06-17 23:42:13  MG00000001  2018-06-17 23:42:13  MG00000001  View Edit Delete
5557  AG01001931 01 002          View Edit Delete
7212  AG01003368 01 002  2018-01-30 09:41:12  MG00000001  2018-01-30 09:41:12  MG00000001  View Edit Delete
7793  AG01003493 01 002  2018-06-17 23:28:36  MG00000001  2018-06-17 23:28:36  MG00000001  View Edit Delete
5336  AG00000000 01 002  2016-08-22 11:35:44  MG00000001  2016-08-22 11:35:44  MG00000001  View Edit Delete
8056  AG01003556 01 002  2018-09-04 13:24:28  MG00000001  2018-09-04 13:24:28  MG00000001  View Edit Delete
5588  AG01001828 01 002          View Edit Delete
1365  AG01000711 01 002  2016-08-30 12:24:15  MG00000001  2016-08-30 12:24:15  MG00000001  View Edit Delete
7136  AG01003019 01 002  2017-11-30 14:42:18  MG00000001  2017-11-30 14:42:18  MG00000001  View Edit Delete
8054  AG01002755 01 002  2018-09-04 13:06:51  MG00000001  2018-09-04 13:06:51  MG00000001  View Edit Delete
5572  AG01001874 01 002          View Edit Delete
8059  AG01002018 01 002  2018-09-05 09:24:48  MG00000001  2018-09-05 09:24:48  MG00000001  View Edit Delete
5554  AG01001307 01 002          View Edit Delete

Page 4 of 373, showing 20 records out of 7458 total, starting on record 61, ending on 80

(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`.`company_cd` asc LIMIT 60, 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 = 11117