Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
9663  AG06000082 06 661          View Edit Delete
10164  AG06000583 06 661          View Edit Delete
9833  AG06000252 06 661          View Edit Delete
9835  AG06000254 06 661          View Edit Delete
9841  AG06000260 06 661          View Edit Delete
9852  AG06000271 06 661          View Edit Delete
9846  AG06000265 06 661          View Edit Delete
9851  AG06000270 06 661          View Edit Delete
9847  AG06000266 06 661          View Edit Delete
9843  AG06000262 06 661          View Edit Delete
9840  AG06000259 06 661          View Edit Delete
9855  AG06000274 06 661          View Edit Delete
9856  AG06000275 06 661          View Edit Delete
9868  AG06000287 06 661          View Edit Delete
10409  AG06000828 06 661          View Edit Delete
9845  AG06000264 06 661          View Edit Delete
9854  AG06000273 06 661          View Edit Delete
9858  AG06000277 06 661          View Edit Delete
9860  AG06000279 06 661          View Edit Delete
9857  AG06000276 06 661          View Edit Delete

Page 55 of 373, showing 20 records out of 7458 total, starting on record 1081, ending on 1100

(default) 2 queries took 24 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 1080, 2020208
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