Sys Products

Sys Product Cd Sys Product Nm Sys Product Fk Classify Cd Use Start Day Use End Day Del Flg Created Insert User Modified Update User Actions
34200  南瓜  かぼちゃ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
34270  ズッキーニ  ずっきーに  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
34300  茄子  なす  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2022-12-27 11:50:11  MG00000001  View Edit Delete
34400  トマト  とまと  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
34460  ミニとまと  みにとまと  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
34500  ピーマン  ぴーまん  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
34570  パプリカ  ぱぷりか  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
34600  ししとう  ししとう  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2022-03-14 15:43:37  MG00000001  View Edit Delete
34700  トウモロコシ  とうもろこし  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2022-12-27 11:50:53  MG00000001  View Edit Delete
34800  オクラ  おくら  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2022-10-19 10:58:01  MG00000001  View Edit Delete
34910  冬瓜  とうがん  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
34950  うり  うり  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
35100  インゲン  いんげん  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2022-12-28 09:36:54  MG00000001  View Edit Delete
35200  えんどう豆  えんどう  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
35230  うすいえんどう  うすいえんどう  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
35400  そらまめ  そらまめ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
35500  枝豆  えだまめ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2017-02-27 19:06:22  MG00000001  View Edit Delete
36100  サツマイモ  さつまいも  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2023-10-12 11:57:56  MG00000001  View Edit Delete
36200  ジャガイモ  じゃがいも  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2022-12-27 12:00:47  MG00000001  View Edit Delete
36300  里芋  さといも  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete

Page 3 of 9, showing 20 records out of 161 total, starting on record 41, ending on 60

(default) 2 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `SysProduct`.`sys_product_cd`, `SysProduct`.`sys_product_nm`, `SysProduct`.`sys_product_fk`, `SysProduct`.`classify_cd`, `SysProduct`.`use_start_day`, `SysProduct`.`use_end_day`, `SysProduct`.`del_flg`, `SysProduct`.`created`, `SysProduct`.`insert_user`, `SysProduct`.`modified`, `SysProduct`.`update_user`, `SysProdctClassify`.`classify_cd`, `SysProdctClassify`.`classify_nm`, `SysProdctClassify`.`classify_fk`, `SysProdctClassify`.`amount_not_sel_flg`, `SysProdctClassify`.`brc_not_print_flg`, `SysProdctClassify`.`del_flg`, `SysProdctClassify`.`created`, `SysProdctClassify`.`insert_user`, `SysProdctClassify`.`modified`, `SysProdctClassify`.`update_user` FROM `sato_agri`.`sys_products` AS `SysProduct` LEFT JOIN `sato_agri`.`sys_prodct_classify` AS `SysProdctClassify` ON (`SysProduct`.`classify_cd` = `SysProdctClassify`.`classify_cd`) WHERE 1 = 1 LIMIT 40, 2020201
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`sys_products` AS `SysProduct` LEFT JOIN `sato_agri`.`sys_prodct_classify` AS `SysProdctClassify` ON (`SysProduct`.`classify_cd` = `SysProdctClassify`.`classify_cd`) WHERE 1 = 1110