Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6347  AG01003014 01 010          View Edit Delete
6344  AG01003012 01 010          View Edit Delete
6343  AG01003011 01 010          View Edit Delete
6322  AG01003001 01 010          View Edit Delete
6323  AG01003002 01 010          View Edit Delete
6324  AG01003003 01 010          View Edit Delete
6326  AG01003004 01 010          View Edit Delete
6327  AG01003005 01 010          View Edit Delete
6639  AG01001299 01 005  2017-10-20 19:37:32  MG00000001  2017-10-20 19:37:32  MG00000001  View Edit Delete
6641  AG01001301 01 005  2017-10-20 19:37:32  MG00000001  2017-10-20 19:37:32  MG00000001  View Edit Delete
6640  AG01001300 01 005  2017-10-20 19:37:32  MG00000001  2017-10-20 19:37:32  MG00000001  View Edit Delete
6638  AG01001298 01 005  2017-10-20 19:37:32  MG00000001  2017-10-20 19:37:32  MG00000001  View Edit Delete
6643  AG01001303 01 005  2017-10-20 19:37:32  MG00000001  2017-10-20 19:37:32  MG00000001  View Edit Delete
6333  AG01003006 01 010          View Edit Delete
6334  AG01003007 01 010          View Edit Delete
6335  AG01003008 01 010          View Edit Delete
6336  AG01002649 01 004  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
6338  AG01003009 01 003          View Edit Delete
6339  AG01003010 01 010          View Edit Delete
6642  AG01001302 01 005  2017-10-20 19:37:32  MG00000001  2017-10-20 19:37:32  MG00000001  View Edit Delete

Page 19 of 373, showing 20 records out of 7458 total, starting on record 361, ending on 380

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