Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9909  AG06000328 06 661          View Edit Delete
9907  AG06000326 06 661          View Edit Delete
9912  AG06000331 06 661          View Edit Delete
9914  AG06000333 06 661          View Edit Delete
9913  AG06000332 06 661          View Edit Delete
9911  AG06000330 06 661          View Edit Delete
9916  AG06000335 06 661          View Edit Delete
9918  AG06000337 06 661          View Edit Delete
9917  AG06000336 06 661          View Edit Delete
9915  AG06000334 06 661          View Edit Delete
9920  AG06000339 06 661          View Edit Delete
9922  AG06000341 06 661          View Edit Delete
9921  AG06000340 06 661          View Edit Delete
9919  AG06000338 06 661          View Edit Delete
9923  AG06000342 06 661          View Edit Delete
9704  AG06000123 06 661          View Edit Delete
10280  AG06000699 06 661          View Edit Delete
10279  AG06000698 06 661          View Edit Delete
10174  AG06000593 06 661          View Edit Delete
9904  AG06000323 06 661          View Edit Delete

Page 56 of 373, showing 20 records out of 7458 total, starting on record 1101, ending on 1120

(default) 2 queries took 28 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 1100, 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 = 11118