Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9850  AG06000269 06 661          View Edit Delete
9856  AG06000275 06 661          View Edit Delete
9859  AG06000278 06 661          View Edit Delete
9858  AG06000277 06 661          View Edit Delete
9855  AG06000274 06 661          View Edit Delete
9849  AG06000268 06 661          View Edit Delete
9866  AG06000285 06 661          View Edit Delete
9865  AG06000284 06 661          View Edit Delete
9863  AG06000282 06 661          View Edit Delete
9860  AG06000279 06 661          View Edit Delete
9848  AG06000267 06 661          View Edit Delete
9872  AG06000291 06 661          View Edit Delete
9869  AG06000288 06 661          View Edit Delete
9875  AG06000294 06 661          View Edit Delete
9874  AG06000293 06 661          View Edit Delete
9868  AG06000287 06 661          View Edit Delete
9867  AG06000286 06 661          View Edit Delete
9847  AG06000266 06 661          View Edit Delete
9799  AG06000218 06 661          View Edit Delete
9721  AG06000140 06 661          View Edit Delete

Page 25 of 373, showing 20 records out of 7458 total, starting on record 481, ending on 500

(default) 2 queries took 25 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`.`update_user` asc LIMIT 480, 2020207
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