Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
7828  AG07000004 07 84  2018-06-26 10:19:33  MG00000001  2018-06-26 10:19:33  MG00000001  View Edit Delete
7827  AG07000003 07 84  2018-06-26 10:19:04  MG00000001  2018-06-26 10:19:04  MG00000001  View Edit Delete
7825  AG07000002 07 84  2018-06-25 20:25:48  MG00000001  2018-06-25 20:25:48  MG00000001  View Edit Delete
7379  AG07000001 07 82  2018-02-28 09:17:17  MG00000001  2018-02-28 09:17:37  MG00000001  View Edit Delete
7752  AG07000001 07 83  2018-06-07 19:15:52  MG00000001  2018-06-07 19:15:52  MG00000001  View Edit Delete
7826  AG07000001 07 84  2018-06-26 10:18:38  MG00000001  2018-06-26 10:18:38  MG00000001  View Edit Delete
7148  AG07000001 07 81  2017-12-04 14:42:18  MG00000001  2017-12-04 14:42:18  MG00000001  View Edit Delete
10741  AG06001160 06 661          View Edit Delete
10740  AG06001159 06 661          View Edit Delete
10739  AG06001158 06 661          View Edit Delete
10738  AG06001157 06 661          View Edit Delete
10737  AG06001156 06 661          View Edit Delete
10736  AG06001155 06 661          View Edit Delete
10735  AG06001154 06 661          View Edit Delete
10734  AG06001153 06 661          View Edit Delete
10733  AG06001152 06 661          View Edit Delete
10732  AG06001151 06 661          View Edit Delete
10731  AG06001150 06 661          View Edit Delete
10730  AG06001149 06 661          View Edit Delete
10729  AG06001148 06 661          View Edit Delete

Page 9 of 373, showing 20 records out of 7458 total, starting on record 161, ending on 180

(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`.`farmer_id` desc LIMIT 160, 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