Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
11409  AG01004947 01 002  2022-08-16 15:34:11  MG00000001  2022-08-16 15:34:11  MG00000001  View Edit Delete
11598  AG01005133 01 002  2022-08-31 20:12:42  MG00000005  2022-08-31 20:12:42  MG00000005  View Edit Delete
10818  AG01004695 01 002  2022-05-16 10:08:42  MG00000001  2022-05-16 10:08:42  MG00000001  View Edit Delete
10981  AG01004821 01 002  2022-06-20 11:38:15  MG00000001  2022-06-20 11:38:15  MG00000001  View Edit Delete
9502  AG01004076 01 002  2021-11-19 08:52:07  MG00000001  2021-11-19 08:52:07  MG00000001  View Edit Delete
5554  AG01001307 01 002          View Edit Delete
5557  AG01001931 01 002          View Edit Delete
5555  AG01001918 01 002          View Edit Delete
5553  AG01001258 01 002          View Edit Delete
5552  AG01002709 01 002          View Edit Delete
5551  AG01001278 01 002          View Edit Delete
5549  AG01001741 01 002          View Edit Delete
5547  AG01001892 01 002          View Edit Delete
5545  AG01001633 01 002          View Edit Delete
5544  AG01001569 01 002          View Edit Delete
5543  AG01001272 01 002          View Edit Delete
5542  AG01001687 01 002          View Edit Delete
5541  AG01001739 01 002          View Edit Delete
5540  AG01001264 01 002          View Edit Delete
5538  AG01001269 01 002          View Edit Delete

Page 13 of 373, showing 20 records out of 7458 total, starting on record 241, ending on 260

(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 240, 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