Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9814  AG06000233 06 661          View Edit Delete
9846  AG06000265 06 661          View Edit Delete
9843  AG06000262 06 661          View Edit Delete
9850  AG06000269 06 661          View Edit Delete
9854  AG06000273 06 661          View Edit Delete
9852  AG06000271 06 661          View Edit Delete
9849  AG06000268 06 661          View Edit Delete
9842  AG06000261 06 661          View Edit Delete
9860  AG06000279 06 661          View Edit Delete
9859  AG06000278 06 661          View Edit Delete
9856  AG06000275 06 661          View Edit Delete
9862  AG06000281 06 661          View Edit Delete
9861  AG06000280 06 661          View Edit Delete
9855  AG06000274 06 661          View Edit Delete
9841  AG06000260 06 661          View Edit Delete
9813  AG06000232 06 661          View Edit Delete
9812  AG06000231 06 661          View Edit Delete
9811  AG06000230 06 661          View Edit Delete
9587  AG06000006 06 661          View Edit Delete
9586  AG06000005 06 661          View Edit Delete

Page 59 of 373, showing 20 records out of 7458 total, starting on record 1161, ending on 1180

(default) 2 queries took 26 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 1160, 2020209
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