Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
2006  AG01000900 01 002  2016-08-30 12:24:19  MG00000001  2016-08-30 12:24:19  MG00000001  View Edit Delete
5541  AG01001739 01 002          View Edit Delete
7792  AG01003488 01 002  2018-06-17 23:27:26  MG00000001  2018-06-17 23:27:26  MG00000001  View Edit Delete
5545  AG01001633 01 002          View Edit Delete
7796  AG01003498 01 002  2018-06-17 23:36:01  MG00000001  2018-06-17 23:36:01  MG00000001  View Edit Delete
5551  AG01001278 01 002          View Edit Delete
5557  AG01001931 01 002          View Edit Delete
5572  AG01001874 01 002          View Edit Delete
5558  AG01001305 01 002          View Edit Delete
5549  AG01001741 01 002          View Edit Delete
5538  AG01001269 01 002          View Edit Delete
5555  AG01001918 01 002          View Edit Delete
7136  AG01003019 01 002  2017-11-30 14:42:18  MG00000001  2017-11-30 14:42:18  MG00000001  View Edit Delete
7799  AG01003505 01 002  2018-06-17 23:40:02  MG00000001  2018-06-17 23:40:02  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
7797  AG01003501 01 002  2018-06-17 23:38:08  MG00000001  2018-06-17 23:38:08  MG00000001  View Edit Delete
1835  AG01000851 01 002  2016-08-30 12:24:18  MG00000001  2016-08-30 12:24:18  MG00000001  View Edit Delete
7212  AG01003368 01 002  2018-01-30 09:41:12  MG00000001  2018-01-30 09:41:12  MG00000001  View Edit Delete
5547  AG01001892 01 002          View Edit Delete
7798  AG01003503 01 002  2018-06-17 23:38:55  MG00000001  2018-06-17 23:38:55  MG00000001  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`.`company_cd` 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