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
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
48000  スイカ  すいか  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
49100  バナナ  ばなな  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
49200  パインアップル  ぱいんあっぷる  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
49300  キウイフルーツ  きういふるーつ  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  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
49540  ブルーベリー  ぶるーべりー  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  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
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
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
90002  葉物  はもの  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
90003  豆類  まめるい  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
90004  根菜  こんさい  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
90005  いも  いも  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
90007  果物  くだもの  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
90008  柑橘類  かんきつるい  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
90009  ほおずき  ほおずき  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  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

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`.`sys_product_cd` 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