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
36400  長芋  ながいも  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2023-01-05 14:54:15  MG00000001  View Edit Delete
36500  やまのいも  やまのいも  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
36600  玉ねぎ  たまねぎ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
36700  ニンニク  にんにく  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2023-01-05 14:54:55  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
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
37200  生姜  しょうが  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
37300  唐辛子  とうがらし  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  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
37410  きのめ  きのめ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
37411  さんしょう(葉)  さんしょう(は)  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
37440  かいわれ  かいわれ  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
37500  しそ  しそ  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
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
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
37700  ハーブ類  はーぶるい  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete
37701  ルッコラ  るっこら  01  2017-01-06 00:00:00    2017-01-06 10:10:38  MG00000001  2017-01-06 10:22:08  MG00000001  View Edit Delete
37710  バジル  ばじる  01  2016-08-01 00:00:00    2016-08-26 17:04:06  MG00000001  2016-08-26 17:04:06  MG00000001  View Edit Delete

Page 4 of 9, showing 20 records out of 161 total, starting on record 61, ending on 80

(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 LIMIT 60, 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