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
30100  大根  だいこん  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2017-02-27 19:54:42  MG00000001  View Edit Delete
38600  きのこ類  きのこるい  01  2017-03-30 00:00:00    2017-03-30 11:41:29  MG00000001  2017-03-30 11:41:29  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
47563  まくわ瓜  まくわうり  02  2016-08-01 00:00:00  2017-05-15 00:00:00  2016-08-26 17:04:06  MG00000001  2017-05-15 16:14:45  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
49571  ブラックベリー  ぶらっくべりー  02  2017-05-15 00:00:00    2017-05-15 17:11:21  MG00000001  2017-05-15 17:11:21  MG00000001  View Edit Delete
32700  せり  せり  01  2017-05-15 00:00:00    2017-05-15 17:24:37  MG00000001  2017-05-15 17:24:37  MG00000001  View Edit Delete
39500  木の実  きのみ  01  2017-05-15 00:00:00    2017-05-15 17:34:49  MG00000001  2017-05-15 17:34:49  MG00000001  View Edit Delete
37301  万願寺とうがらし  まんがんじとうがらし  01  2016-08-01 00:00:00  2017-05-15 00:00:00  2016-08-26 17:04:06  MG00000001  2017-05-15 17:39:24  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
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
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
44700  さくらんぼ  さくらんぼ  02  2018-09-25 00:00:00    2018-09-25 16:13:01  MG00000001  2018-09-25 16:13:01  MG00000001  View Edit Delete
49430  マンゴー  まんごー  02  2018-09-26 00:00:00    2018-09-26 15:05:10  MG00000001  2018-09-26 15:05:10  MG00000001  View Edit Delete
38110  しいたけ  しいたけ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2019-02-22 16:19:47  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
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
90010  果菜類  かさいるい  01  2020-09-18 00:00:00    2020-09-18 15:47:55  MG00000005  2020-09-18 15:47:55  MG00000005  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
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

Page 7 of 9, showing 20 records out of 161 total, starting on record 121, ending on 140

(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`.`modified` asc LIMIT 120, 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