Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5547  AG01001892 01 002          View Edit Delete
5559  AG01002724 01 002          View Edit Delete
5583  AG01002588 01 002          View Edit Delete
5590  AG01001805 01 002          View Edit Delete
5553  AG01001258 01 002          View Edit Delete
5588  AG01001828 01 002          View Edit Delete
2006  AG01000900 01 002  2016-08-30 12:24:19  MG00000001  2016-08-30 12:24:19  MG00000001  View Edit Delete
1365  AG01000711 01 002  2016-08-30 12:24:15  MG00000001  2016-08-30 12:24:15  MG00000001  View Edit Delete
5543  AG01001272 01 002          View Edit Delete
1405  AG01000722 01 002  2016-08-30 12:24:16  MG00000001  2016-08-30 12:24:16  MG00000001  View Edit Delete
5542  AG01001687 01 002          View Edit Delete
5576  AG01001844 01 002          View Edit Delete
5563  AG01001704 01 002          View Edit Delete
2537  AG01001087 01 002  2016-08-30 12:24:22  MG00000001  2016-08-30 12:24:22  MG00000001  View Edit Delete
5578  AG01001713 01 002          View Edit Delete
5336  AG00000000 01 002  2016-08-22 11:35:44  MG00000001  2016-08-22 11:35:44  MG00000001  View Edit Delete
5538  AG01001269 01 002          View Edit Delete
5549  AG01001741 01 002          View Edit Delete
1835  AG01000851 01 002  2016-08-30 12:24:18  MG00000001  2016-08-30 12:24:18  MG00000001  View Edit Delete
1324  AG01000700 01 002  2016-08-30 12:24:15  MG00000001  2016-08-30 12:24:15  MG00000001  View Edit Delete

Page 2 of 373, showing 20 records out of 7458 total, starting on record 21, ending on 40

(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`.`company_cd` asc LIMIT 20, 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