Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6334  AG01003007 01 010          View Edit Delete
6339  AG01003010 01 010          View Edit Delete
6619  AG01001279 01 005  2017-10-20 19:37:32  MG00000001  2017-10-20 19:37:32  MG00000001  View Edit Delete
6618  AG01001278 01 005  2017-10-20 19:37:32  MG00000001  2017-10-20 19:37:32  MG00000001  View Edit Delete
6338  AG01003009 01 003          View Edit Delete
6333  AG01003006 01 010          View Edit Delete
6327  AG01003005 01 010          View Edit Delete
6326  AG01003004 01 010          View Edit Delete
6622  AG01001282 01 005  2017-10-20 19:37:32  MG00000001  2017-10-20 19:37:32  MG00000001  View Edit Delete
6617  AG01001277 01 005  2017-10-20 19:37:32  MG00000001  2017-10-20 19:37:32  MG00000001  View Edit Delete
6609  AG01001269 01 005  2017-10-20 19:37:32  MG00000001  2017-10-20 19:37:32  MG00000001  View Edit Delete
6351  AG01003015 01 010          View Edit Delete
6621  AG01001281 01 005  2017-10-20 19:37:32  MG00000001  2017-10-20 19:37:32  MG00000001  View Edit Delete
6347  AG01003014 01 010          View Edit Delete
6470  AG01001168 01 006  2017-10-20 19:37:30  MG00000001  2017-10-20 19:37:30  MG00000001  View Edit Delete
6587  AG01001247 01 005  2017-10-20 19:37:31  MG00000001  2017-10-20 19:37:31  MG00000001  View Edit Delete
6344  AG01003012 01 010          View Edit Delete
6343  AG01003011 01 010          View Edit Delete
6324  AG01003003 01 010          View Edit Delete
6323  AG01003002 01 010          View Edit Delete

Page 18 of 373, showing 20 records out of 7458 total, starting on record 341, ending on 360

(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` asc LIMIT 340, 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 = 11117