Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG03000008 03 SR008  2017-05-11 00:00:00        View Edit Delete
AG03000001 03 SR001  2017-05-11 00:00:00        View Edit Delete
AG02000010 02 MZ010  2017-02-22 00:00:00  MG00000001      View Edit Delete
AG03000004 03 SR004  2017-05-11 00:00:00        View Edit Delete
AG02000059 02 MZ059  2017-08-02 00:00:00  MG00000001      View Edit Delete
AG02000043 02 MZ043  2017-08-02 00:00:00  MG00000001      View Edit Delete
AG01003007 01 400023          View Edit Delete
AG01003012 01 400027          View Edit Delete
AG01003010 01 400025          View Edit Delete
AG01003006 01 400022          View Edit Delete
AG01002998 01 400015          View Edit Delete
AG01003022 01 240003  2017-09-25 00:00:00        View Edit Delete
AG01003020 01 240001  2017-09-15 00:00:00        View Edit Delete
AG01003014 01 400028          View Edit Delete
AG01003024 01 240005  2017-09-25 00:00:00        View Edit Delete
AG01003023 01 240004  2017-09-25 00:00:00        View Edit Delete
AG01003013 01 370162          View Edit Delete
AG01002997 01 400014          View Edit Delete
AG01002996 01 400013          View Edit Delete
AG01002995 01 400012          View Edit Delete

Page 7 of 251, showing 20 records out of 5002 total, starting on record 121, ending on 140

(default) 2 queries took 15 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `TradersFarmer`.`farmer_id`, `TradersFarmer`.`trader_id`, `TradersFarmer`.`farmer_cd`, `TradersFarmer`.`created`, `TradersFarmer`.`insert_user`, `TradersFarmer`.`modified`, `TradersFarmer`.`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`, `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` FROM `sato_agri`.`traders_farmers` AS `TradersFarmer` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`TradersFarmer`.`trader_id` = `Trader`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`TradersFarmer`.`farmer_id` = `Farmer`.`user_id`) WHERE 1 = 1 ORDER BY `TradersFarmer`.`update_user` asc LIMIT 120, 2020204
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`traders_farmers` AS `TradersFarmer` LEFT JOIN `sato_agri`.`traders` AS `Trader` ON (`TradersFarmer`.`trader_id` = `Trader`.`id`) LEFT JOIN `sato_agri`.`farmers` AS `Farmer` ON (`TradersFarmer`.`farmer_id` = `Farmer`.`user_id`) WHERE 1 = 11111