Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9814  AG06000233 06 661          View Edit Delete
9819  AG06000238 06 661          View Edit Delete
9817  AG06000236 06 661          View Edit Delete
9822  AG06000241 06 661          View Edit Delete
9820  AG06000239 06 661          View Edit Delete
9825  AG06000244 06 661          View Edit Delete
9823  AG06000242 06 661          View Edit Delete
9826  AG06000245 06 661          View Edit Delete
9827  AG06000246 06 661          View Edit Delete
9828  AG06000247 06 661          View Edit Delete
9829  AG06000248 06 661          View Edit Delete
9830  AG06000249 06 661          View Edit Delete
9831  AG06000250 06 661          View Edit Delete
9832  AG06000251 06 661          View Edit Delete
9833  AG06000252 06 661          View Edit Delete
9834  AG06000253 06 661          View Edit Delete
9835  AG06000254 06 661          View Edit Delete
9836  AG06000255 06 661          View Edit Delete
9837  AG06000256 06 661          View Edit Delete
9838  AG06000257 06 661          View Edit Delete

Page 38 of 373, showing 20 records out of 7458 total, starting on record 741, ending on 760

(default) 2 queries took 23 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`.`trader_id` desc LIMIT 740, 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 = 11116