Contractors

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

Page 354 of 373, showing 20 records out of 7458 total, starting on record 7061, ending on 7080

(default) 2 queries took 60 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`.`id` desc LIMIT 7060, 20202042
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