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
31910  青ねぎ  あおねぎ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
30210  赤かぶ  あかかぶ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
91004  あげ  あげ  03  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
33100  アスパラ  あすぱら  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2023-04-18 08:42:02  MG00000001  View Edit Delete
41260  甘夏  あまなつ  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2023-04-13 09:54: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
46000  イチゴ  いちご  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
45800  いちじく  いちじく  02  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
41300  伊予柑  いよかん  02  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
35100  インゲン  いんげん  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2022-12-28 09:36:54  MG00000001  View Edit Delete
35230  うすいえんどう  うすいえんどう  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
32400  うど  うど  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
39200  梅  うめ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
34950  うり  うり  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
38400  えのき茸  えのきだけ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
38604  エリンギ  えりんぎ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
35200  えんどう豆  えんどう  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
37560  大葉  おおば  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2017-02-27 16:43:41  MG00000001  View Edit Delete

Page 1 of 9, showing 20 records out of 161 total, starting on record 1, ending on 20

< previous123456789
(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 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