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
36700  ニンニク  にんにく  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2023-01-05 14:54:55  MG00000001  View Edit Delete
91011  花・木  はなき  99  2017-05-15 00:00:00    2017-05-15 16:19:20  MG00000001  2022-03-11 11:00:11  MG00000001  View Edit Delete
33420  グリーンリーフレタス  ぐりーんりーふれたす  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
37410  きのめ  きのめ  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
91006  漬物  つけもの  03  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
32600  春菊  しゅんぎく  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
49100  バナナ  ばなな  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
90004  根菜  こんさい  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
31500  小松菜  こまつな  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
44600  あんず  あんず  02  2020-07-28 00:00:00    2020-07-28 10:16:58  MG00000005  2020-07-28 10:16:58  MG00000005  View Edit Delete
39200  梅  うめ  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
41410  レモン  れもん  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
38300  なめこ  なめこ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
99999  未設定  みせってい  99  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
33920  菜の花  なのはな  01  2017-01-23 00:00:00    2017-01-23 17:24:15  MG00000001  2017-01-23 17:24:15  MG00000001  View Edit Delete
30400  ごぼう  ごぼう  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
91012  中国野菜  ちゅうごくやさい  01  2018-08-20 00:00:00    2018-08-20 16:55:59  MG00000001  2018-08-20 16:55:59  MG00000001  View Edit Delete
37560  大葉  おおば  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2017-02-27 16:43:41  MG00000001  View Edit Delete

Page 4 of 9, showing 20 records out of 161 total, starting on record 61, ending on 80

(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 ORDER BY `SysProduct`.`del_flg` desc LIMIT 60, 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