Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
10028  AG06000447 06 661          View Edit Delete
10026  AG06000445 06 661          View Edit Delete
10031  AG06000450 06 661          View Edit Delete
10033  AG06000452 06 661          View Edit Delete
10032  AG06000451 06 661          View Edit Delete
10030  AG06000449 06 661          View Edit Delete
10035  AG06000454 06 661          View Edit Delete
10037  AG06000456 06 661          View Edit Delete
10036  AG06000455 06 661          View Edit Delete
10034  AG06000453 06 661          View Edit Delete
10039  AG06000458 06 661          View Edit Delete
10041  AG06000460 06 661          View Edit Delete
10040  AG06000459 06 661          View Edit Delete
10038  AG06000457 06 661          View Edit Delete
10042  AG06000461 06 661          View Edit Delete
10148  AG06000567 06 661          View Edit Delete
10166  AG06000585 06 661          View Edit Delete
10179  AG06000598 06 661          View Edit Delete
10302  AG06000721 06 661          View Edit Delete
10023  AG06000442 06 661          View Edit Delete

Page 62 of 373, showing 20 records out of 7458 total, starting on record 1221, ending on 1240

(default) 2 queries took 27 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`.`company_cd` desc LIMIT 1220, 20202010
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