Contractors

Id Farmer Trader Company Cd Created Insert User Modified Update User Actions
6338  AG01003009 01 003          View Edit Delete
6336  AG01002649 01 004  2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
6335  AG01003008 01 010          View Edit Delete
6334  AG01003007 01 010          View Edit Delete
6333  AG01003006 01 010          View Edit Delete
6332  AG02000040 02 51          View Edit Delete
6331  AG02000039 02 51          View Edit Delete
6330  AG02000038 02 51          View Edit Delete
6329  AG02000037 02 51          View Edit Delete
6328  AG02000036 02 51          View Edit Delete
6327  AG01003005 01 010          View Edit Delete
6326  AG01003004 01 010          View Edit Delete
6324  AG01003003 01 010          View Edit Delete
6323  AG01003002 01 010          View Edit Delete
6322  AG01003001 01 010          View Edit Delete
6321  AG03000030 03 61          View Edit Delete
6320  AG03000029 03 61          View Edit Delete
6319  AG03000028 03 61          View Edit Delete
6318  AG03000027 03 61          View Edit Delete
6317  AG03000026 03 61          View Edit Delete

Page 355 of 373, showing 20 records out of 7458 total, starting on record 7081, ending on 7100

(default) 2 queries took 48 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 7080, 20202031
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