Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
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
6333  AG01003006 01 010          View Edit Delete
6334  AG01003007 01 010          View Edit Delete
6335  AG01003008 01 010          View Edit Delete
14394  AG01003009 01 031  2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
6338  AG01003009 01 003          View Edit Delete
6339  AG01003010 01 010          View Edit Delete
6343  AG01003011 01 010          View Edit Delete
6344  AG01003012 01 010          View Edit Delete
8073  AG01003013 01 002  2018-09-06 09:06:24  MG00000001  2018-09-06 09:06:24  MG00000001  View Edit Delete
14853  AG01003013 01 033  2023-04-13 14:41:44  MG00000001  2023-04-13 14:41:44  MG00000001  View Edit Delete
13821  AG01003013 01 032  2023-03-27 10:18:00  MG00000001  2023-03-27 10:18:00  MG00000001  View Edit Delete
14434  AG01003013 01 031  2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete
6347  AG01003014 01 010          View Edit Delete
6351  AG01003015 01 010          View Edit Delete
7137  AG01003017 01 002  2017-11-30 14:42:18  MG00000001  2017-11-30 14:42:18  MG00000001  View Edit Delete
14359  AG01003019 01 031  2023-04-04 11:00:50  MG00000001  2023-04-04 11:00:50  MG00000001  View Edit Delete

Page 28 of 373, showing 20 records out of 7458 total, starting on record 541, ending on 560

(default) 2 queries took 25 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`.`farmer_id` asc LIMIT 540, 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 = 11117