Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6320  AG03000029 03 61          View Edit Delete
6321  AG03000030 03 61          View Edit Delete
6322  AG01003001 01 010          View Edit Delete
6323  AG01003002 01 010          View Edit Delete
6324  AG01003003 01 010          View Edit Delete
6326  AG01003004 01 010          View Edit Delete
6327  AG01003005 01 010          View Edit Delete
6328  AG02000036 02 51          View Edit Delete
6329  AG02000037 02 51          View Edit Delete
6330  AG02000038 02 51          View Edit Delete
6331  AG02000039 02 51          View Edit Delete
6332  AG02000040 02 51          View Edit Delete
6333  AG01003006 01 010          View Edit Delete
6334  AG01003007 01 010          View Edit Delete
6335  AG01003008 01 010          View Edit Delete
9645  AG06000064 06 661          View Edit Delete
6338  AG01003009 01 003          View Edit Delete
6339  AG01003010 01 010          View Edit Delete
6341  AG02000041 02 51          View Edit Delete
6342  AG02000042 02 51          View Edit Delete

Page 19 of 373, showing 20 records out of 7458 total, starting on record 361, ending on 380

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