Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5451  AG01001281 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5453  AG01001561 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5459  AG01001836 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5475  AG01001294 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5492  AG01001775 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5499  AG01001931 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5554  AG01001307 01 002          View Edit Delete
15677  AG01006032 01 033  2024-03-15 14:33:43  TR01000110  2024-03-15 14:33:43  TR01000110  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

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

(default) 2 queries took 26 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`.`trader_id` asc LIMIT 240, 2020207
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