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
32300  ふき  ふき  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
38620  まいたけ  まいたけ  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
31320  みぶ菜  みぶな  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
37850  むかご  むかご  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
33706  サンチュ  さんちゅ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
30200  かぶ  かぶ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
90006  ゴーヤ  ごーや  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
37412  さんしょう(実)  さんしょう(み)  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
32800  にら  にら  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
31800  ほうれん草  ほうれんそう  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
39330  すだち  すだち  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
38500  しめじ茸  しめじ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  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
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
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

Page 5 of 9, showing 20 records out of 161 total, starting on record 81, ending on 100

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