Cmp Products

Id Trader Company Cd Co Product Cd Co Product Nm Co Product Reciept Nm Co Product Fk Limited User Use Start Day Use End Day Created Insert User Modified Update User Actions
263  01  002  20110237  野菜    やさい    2016-08-29 00:00:00    2016-08-30 12:24:39  MG00000001  2022-05-10 09:38:50  MG00000001  View Edit Delete
1287  01  005  24014  レモン パック    れもんぱっく    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
2567  01  006  7123  野菜  産直野菜123  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5127  02  51  348  観葉植物    かんようしょくぶつ    2017-12-04 00:00:00            View Edit Delete
5383  02  53  13  農産物13    のうさんぶつ13    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6151  01  006  7240  野菜  産直野菜240  やさい    2018-04-02 00:00:00    2018-04-02 19:37:34  MG00000001  2018-04-02 19:37:34  MG00000001  View Edit Delete
6407  02  51  142  白うり    しろうり    2018-07-19 00:00:00    2018-07-19 10:37:28  MG00000001  2018-07-19 10:37:28  MG00000001  View Edit Delete
6919  08  96  602  なし(豊水)    なしほうすい    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7175  08  97  512  いよかん    いよかん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7687  01  102  2400033508517   オクラ    おくら    2019-05-20 00:00:00            View Edit Delete
7943  03  62  24  農産物24    のうさんぶつ24    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
10759  02  51  784  ミント    みんと    2021-07-14 00:00:00    2021-07-14 15:41:41  MG00000001  2021-07-14 15:41:41  MG00000001  View Edit Delete
11015  06  661  00014  ごぼう    ごぼう    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 09:38:17  MG00000001  View Edit Delete
11271  06  661  00272  かりん    かりん    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11527  06  661  00528  女峰    にょほう    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11783  06  661  00795  仏花(正月用)大    ぶっかしょうがつようだい    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12039  06  661  01053  ペンタス苗    ぺんたすなえ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12295  04  710  89647  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
12551  01  053  61151  農産物    のうさんぶつ    2022-07-29 00:00:00    2022-07-29 13:16:29  MG00000001  2022-07-29 13:16:29  MG00000001  View Edit Delete
12807  01  056  32784  農産物    のうさんぶつ    2022-08-22 00:00:00    2022-08-22 12:42:10  MG00000001  2022-08-22 12:42:10  MG00000001  View Edit Delete

Page 60 of 2156, showing 20 records out of 43118 total, starting on record 1181, ending on 1200

(default) 2 queries took 30 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `CmpProduct`.`id`, `CmpProduct`.`trader_id`, `CmpProduct`.`company_cd`, `CmpProduct`.`co_product_cd`, `CmpProduct`.`co_product_nm`, `CmpProduct`.`co_product_reciept_nm`, `CmpProduct`.`co_product_fk`, `CmpProduct`.`sys_product_cd`, `CmpProduct`.`farmer_linked_flag`, `CmpProduct`.`limited_user_id`, `CmpProduct`.`barcode_generate_pattern`, `CmpProduct`.`barcode_display_format`, `CmpProduct`.`use_start_day`, `CmpProduct`.`use_end_day`, `CmpProduct`.`created`, `CmpProduct`.`insert_user`, `CmpProduct`.`modified`, `CmpProduct`.`update_user` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1 ORDER BY `CmpProduct`.`use_end_day` asc LIMIT 1180, 20202021
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1119