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
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
33950  芽キャベツ  めきゃべつ  01  2017-01-31 00:00:00    2017-02-01 10:43:31  MG00000001  2017-02-01 10:43:31  MG00000001  View Edit Delete
47000  メロン  めろん  02  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
44000  桃  もも  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2023-01-12 15:20:53  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
39630  モロヘイヤ  もろへいや  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
90001  野菜  やさい  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
36500  やまのいも  やまのいも  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
39310  ゆず  ゆず  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
36800  らっきょう  らっきょう  01  2017-04-24 00:00:00    2017-04-24 10:03:45  MG00000001  2017-04-24 10:03:45  MG00000001  View Edit Delete
30910  ラディッシュ  らでぃっしゅ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
42000  りんご  りんご  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
37701  ルッコラ  るっこら  01  2017-01-06 00:00:00    2017-01-06 10:10:38  MG00000001  2017-01-06 10:22:08  MG00000001  View Edit Delete
33400  レタス  れたす  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
30600  レンコン  れんこん  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2022-12-28 10:08:30  MG00000001  View Edit Delete
37650  ローリエ  ろーりえ  01  2020-07-28 00:00:00    2020-07-28 13:29:11  MG00000005  2020-07-28 13:29:11  MG00000005  View Edit Delete
32100  わけぎ  わけぎ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
37100  ワサビ  わさび  01  2017-05-16 00:00:00    2017-05-16 09:24:08  MG00000001  2017-05-16 09:24:08  MG00000001  View Edit Delete

Page 8 of 9, showing 20 records out of 161 total, starting on record 141, ending on 160

(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_fk` asc LIMIT 140, 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