Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9842  AG06000261 06 661          View Edit Delete
9847  AG06000266 06 661          View Edit Delete
9849  AG06000268 06 661          View Edit Delete
9848  AG06000267 06 661          View Edit Delete
9846  AG06000265 06 661          View Edit Delete
9851  AG06000270 06 661          View Edit Delete
9853  AG06000272 06 661          View Edit Delete
9852  AG06000271 06 661          View Edit Delete
9850  AG06000269 06 661          View Edit Delete
9854  AG06000273 06 661          View Edit Delete
9856  AG06000275 06 661          View Edit Delete
9831  AG06000250 06 661          View Edit Delete
9834  AG06000253 06 661          View Edit Delete
9861  AG06000280 06 661          View Edit Delete
9863  AG06000282 06 661          View Edit Delete
9864  AG06000283 06 661          View Edit Delete
9862  AG06000281 06 661          View Edit Delete
9859  AG06000278 06 661          View Edit Delete
9832  AG06000251 06 661          View Edit Delete
10431  AG06000850 06 661          View Edit Delete

Page 53 of 373, showing 20 records out of 7458 total, starting on record 1041, ending on 1060

(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 1040, 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