Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6297  AG03000006 03 61          View Edit Delete
6293  AG03000002 03 61          View Edit Delete
6285  AG01002994 01 010          View Edit Delete
5568  AG01001720 01 002          View Edit Delete
5519  AG02000020 02 51          View Edit Delete
5362  AG01001307 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5368  AG01001888 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5366  AG01001305 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5361  AG01001258 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5350  AG01001687 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5389  AG01001551 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5384  AG01001844 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5371  AG01001704 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5392  AG01001257 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5391  AG01002588 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5369  AG01001250 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5349  AG01001739 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5348  AG01001264 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5346  AG01001269 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5344  AG01001516 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete

Page 7 of 373, showing 20 records out of 7458 total, starting on record 121, ending on 140

(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`.`update_user` asc LIMIT 120, 2020206
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 = 11118