Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
5512  AG02000013 02 51          View Edit Delete
5511  AG02000012 02 51          View Edit Delete
5510  AG02000011 02 51          View Edit Delete
5508  AG02000009 02 51          View Edit Delete
5507  AG02000008 02 51          View Edit Delete
5506  AG02000007 02 51          View Edit Delete
5505  AG02000006 02 51          View Edit Delete
5504  AG02000005 02 51          View Edit Delete
5503  AG02000004 02 51          View Edit Delete
5502  AG02000003 02 51          View Edit Delete
5501  AG02000002 02 51          View Edit Delete
5500  AG02000001 02 51          View Edit Delete
5499  AG01001931 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5492  AG01001775 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5475  AG01001294 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5459  AG01001836 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5453  AG01001561 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5451  AG01001281 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5447  AG01001870 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete
5446  AG01002725 01 006  2017-02-24 00:00:00  MG00000001      View Edit Delete

Page 361 of 373, showing 20 records out of 7458 total, starting on record 7201, ending on 7220

(default) 2 queries took 42 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`.`id` desc LIMIT 7200, 20202025
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