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
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
37600  みょうが  みょうが  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  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
34460  ミニとまと  みにとまと  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
32500  みつば  みつば  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
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
31310  水菜  みずな  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2017-02-27 19:25:56  MG00000001  View Edit Delete
40100  みかん  みかん  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
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
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
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
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
41390  ポンカン  ぽんかん  02  2017-02-27 00:00:00    2017-02-27 16:38:04  MG00000001  2017-02-27 16:38:04  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
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
33300  ブロッコリー  ぶろっこりー  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  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

Page 2 of 9, showing 20 records out of 161 total, starting on record 21, ending on 40

(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` desc LIMIT 20, 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