Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6313  AG03000022 03 61          View Edit Delete
6316  AG03000025 03 61          View Edit Delete
6315  AG03000024 03 61          View Edit Delete
6308  AG03000017 03 61          View Edit Delete
6307  AG03000016 03 61          View Edit Delete
5583  AG01002588 01 002          View Edit Delete
5590  AG01001805 01 002          View Edit Delete
5588  AG01001828 01 002          View Edit Delete
5600  AG01001579 01 002          View Edit Delete
5597  AG01001852 01 002          View Edit Delete
5607  AG01001266 01 006          View Edit Delete
5606  AG01001265 01 006          View Edit Delete
5610  AG01001828 01 006          View Edit Delete
5609  AG01001579 01 006          View Edit Delete
6287  AG01002996 01 010          View Edit Delete
6286  AG01002995 01 010          View Edit Delete
6289  AG01002998 01 010          View Edit Delete
6288  AG01002997 01 010          View Edit Delete
6292  AG03000001 03 61          View Edit Delete
6291  AG01003000 01 010          View Edit Delete

Page 10 of 373, showing 20 records out of 7458 total, starting on record 181, ending on 200

(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`.`created` asc LIMIT 180, 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