Traders Farmers

Farmer Trader Farmer Cd Created Insert User Modified Update User Actions
AG01003005 01 400021          View Edit Delete
AG01003006 01 400022          View Edit Delete
AG01003007 01 400023          View Edit Delete
AG01003008 01 400024          View Edit Delete
AG01003009 01 290824          View Edit Delete
AG01003010 01 400025          View Edit Delete
AG01003011 01 400026          View Edit Delete
AG01003012 01 400027          View Edit Delete
AG01003013 01 370162          View Edit Delete
AG01003014 01 400028          View Edit Delete
AG01003015 01 400029          View Edit Delete
AG01003016 01 260043          View Edit Delete
AG01003017 01 260044          View Edit Delete
AG01003018 01 360764  2017-09-15 00:00:00  MG00000001  2018-07-31 15:56:47  MG00000001  View Edit Delete
AG01003019 01 260045  2017-09-15 00:00:00  MG00000001  2021-12-07 12:46:48  MG00000001  View Edit Delete
AG01003020 01 240001  2017-09-15 00:00:00        View Edit Delete
AG01003021 01 240002  2017-09-15 00:00:00        View Edit Delete
AG01003022 01 240003  2017-09-25 00:00:00        View Edit Delete
AG01003023 01 240004  2017-09-25 00:00:00        View Edit Delete
AG01003024 01 240005  2017-09-25 00:00:00        View Edit Delete

Page 15 of 251, showing 20 records out of 5002 total, starting on record 281, ending on 300

(default) 2 queries took 17 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`.`trader_id` asc LIMIT 280, 2020205
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 = 11112