Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9824  AG06000243 06 661          View Edit Delete
9822  AG06000241 06 661          View Edit Delete
9827  AG06000246 06 661          View Edit Delete
9829  AG06000248 06 661          View Edit Delete
9828  AG06000247 06 661          View Edit Delete
9826  AG06000245 06 661          View Edit Delete
9831  AG06000250 06 661          View Edit Delete
9833  AG06000252 06 661          View Edit Delete
9832  AG06000251 06 661          View Edit Delete
9830  AG06000249 06 661          View Edit Delete
9834  AG06000253 06 661          View Edit Delete
9836  AG06000255 06 661          View Edit Delete
9810  AG06000229 06 661          View Edit Delete
9814  AG06000233 06 661          View Edit Delete
9841  AG06000260 06 661          View Edit Delete
9843  AG06000262 06 661          View Edit Delete
9844  AG06000263 06 661          View Edit Delete
9842  AG06000261 06 661          View Edit Delete
9839  AG06000258 06 661          View Edit Delete
9812  AG06000231 06 661          View Edit Delete

Page 52 of 373, showing 20 records out of 7458 total, starting on record 1021, ending on 1040

(default) 2 queries took 26 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 1020, 2020209
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