Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5581  AG01001265 01 002          View Edit Delete
5515  AG02000016 02 51          View Edit Delete
5545  AG01001633 01 002          View Edit Delete
5552  AG01002709 01 002          View Edit Delete
5554  AG01001307 01 002          View Edit Delete
5511  AG02000012 02 51          View Edit Delete
5521  AG02000022 02 51          View Edit Delete
5534  AG02000035 02 51          View Edit Delete
5540  AG01001264 01 002          View Edit Delete
5523  AG02000024 02 51          View Edit Delete
5505  AG02000006 02 51          View Edit Delete
5506  AG02000007 02 51          View Edit Delete
5590  AG01001805 01 002          View Edit Delete
6287  AG01002996 01 010          View Edit Delete
6296  AG03000005 03 61          View Edit Delete
6298  AG03000007 03 61          View Edit Delete
6289  AG01002998 01 010          View Edit Delete
5578  AG01001713 01 002          View Edit Delete
5606  AG01001265 01 006          View Edit Delete
5609  AG01001579 01 006          View Edit Delete

Page 4 of 373, showing 20 records out of 7458 total, starting on record 61, ending on 80

(default) 2 queries took 24 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`.`insert_user` asc LIMIT 60, 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 = 11118