Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6316  AG03000025 03 61          View Edit Delete
6317  AG03000026 03 61          View Edit Delete
6318  AG03000027 03 61          View Edit Delete
6319  AG03000028 03 61          View Edit Delete
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
6288  AG01002997 01 010          View Edit Delete

Page 6 of 373, showing 20 records out of 7458 total, starting on record 101, ending on 120

(default) 2 queries took 22 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 100, 2020205
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