Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5559  AG01002724 01 002          View Edit Delete
5554  AG01001307 01 002          View Edit Delete
5543  AG01001272 01 002          View Edit Delete
5584  AG01001257 01 002          View Edit Delete
5581  AG01001265 01 002          View Edit Delete
5568  AG01001720 01 002          View Edit Delete
5590  AG01001805 01 002          View Edit Delete
5607  AG01001266 01 006          View Edit Delete
5602  AG01001559 01 002          View Edit Delete
5588  AG01001828 01 002          View Edit Delete
5563  AG01001704 01 002          View Edit Delete
5542  AG01001687 01 002          View Edit Delete
5501  AG02000002 02 51          View Edit Delete
6286  AG01002995 01 010          View Edit Delete
6294  AG03000003 03 61          View Edit Delete
6293  AG03000002 03 61          View Edit Delete
6285  AG01002994 01 010          View Edit Delete
5610  AG01001828 01 006          View Edit Delete
5609  AG01001579 01 006          View Edit Delete
5500  AG02000001 02 51          View Edit Delete

Page 5 of 373, showing 20 records out of 7458 total, starting on record 81, ending on 100

(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`.`insert_user` asc LIMIT 80, 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