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
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
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
91018  ビーツ  びーつ  01  2024-02-27 00:00:00    2024-02-27 14:33:39  MG00000001  2024-02-27 14:33:39  MG00000001  View Edit Delete
91017  もやし  もやし  01  2022-03-11 00:00:00    2022-03-11 16:47:52  MG00000001  2022-03-11 16:47:52  MG00000001  View Edit Delete
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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

< previous123456789
(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`.`sys_product_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 = 1110