Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6343  AG01003011 01 010          View Edit Delete
6344  AG01003012 01 010          View Edit Delete
6347  AG01003014 01 010          View Edit Delete
6348  AG02000044 02 51          View Edit Delete
6349  AG02000045 02 51          View Edit Delete
6350  AG02000046 02 51          View Edit Delete
6351  AG01003015 01 010          View Edit Delete
6352  AG02000047 02 51          View Edit Delete
6353  AG02000048 02 51          View Edit Delete
6354  AG02000049 02 51          View Edit Delete
6357  AG02000050 02 51          View Edit Delete
6358  AG02000051 02 51          View Edit Delete
6363  AG02000052 02 51          View Edit Delete
6364  AG02000053 02 51          View Edit Delete
6365  AG02000054 02 51          View Edit Delete
6376  AG02000055 02 51          View Edit Delete
6377  AG02000056 02 51          View Edit Delete
6378  AG02000057 02 51          View Edit Delete
6379  AG02000058 02 51          View Edit Delete
6380  AG02000059 02 51          View Edit Delete

Page 20 of 373, showing 20 records out of 7458 total, starting on record 381, ending on 400

(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`.`modified` asc LIMIT 380, 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