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
91016  苗  なえ  99  2022-03-11 00:00:00    2022-03-11 12:42:36  MG00000001  2022-03-11 12:42:36  MG00000001  View Edit Delete
91010  米  こめ  99  2017-05-15 00:00:00    2017-05-15 16:19:07  MG00000001  2017-05-15 16:19:07  MG00000001  View Edit Delete
99998  その他  そのた  99  2018-05-25 00:00:00    2018-05-25 11:06:24  MG00000001  2018-05-25 11:06:24  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
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
91014  麦  むぎ  99  2021-03-08 00:00:00    2021-03-08 17:25:52  MG00000005  2021-03-08 17:25:52  MG00000005  View Edit Delete
90000  農産物  のうさんぶつ  99  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
91015  肉類  にくるい  99  2022-03-10 00:00:00    2022-03-10 15:07:32  MG00000001  2022-03-10 15:07:32  MG00000001  View Edit Delete
90011  穀物  こくもつ  99  2021-01-18 00:00:00    2021-01-18 17:36:31  MG00000005  2021-01-18 17:36:31  MG00000005  View Edit Delete
91001  加工品(BC無)  かこうひんばーこーどなし  04  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
91009  たまご  たまご  03  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
91005  お茶  おちゃ  03  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
91013  紅茶  こうちゃ  03  2021-01-22 00:00:00    2021-01-22 15:26:30  MG00000005  2021-01-22 15:26:30  MG00000005  View Edit Delete
91000  加工品(BC有)  かこうひんばーこーどあり  03  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
91002  雑貨  ざっか  03  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
91007  餅  もち  03  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
91003  豆腐  とうふ  03  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
91008  菓子  かし  03  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
91004  あげ  あげ  03  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete

Page 1 of 9, showing 20 records out of 161 total, starting on record 1, ending on 20

< previous123456789
(default) 2 queries took 2 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`.`classify_cd` desc LIMIT 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 = 1111