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
12  01  001  12  いんげん    いんげん    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1036  01  005  11012  きゅうり 2P    きゅうり2    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1292  01  005  24031  グレープフルーツホワイト 1P    ぐれーぷふるーつほわいと1    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1548  01  007  6210  キャベツ  近郷野菜110  きゃべつ    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2572  01  006  7128  野菜  産直野菜128  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5132  07  81  10  農産物10    のうさんぶつ10    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5388  02  53  18  農産物18    のうさんぶつ18    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6156  02  54  78565  農産物    のうさんぶつ    2018-04-11 00:00:00    2018-04-11 00:00:00  MG00000001  2018-04-11 00:00:00  MG00000001  View Edit Delete
6412  05  71  89793  農産物    のうさんぶつ    2018-07-30 00:00:00    2018-07-30 14:36:45  MG00000001  2018-07-30 14:36:45  MG00000001  View Edit Delete
6668  02  52  1995  農産物    のうさんぶつ    2018-08-02 00:00:00    2018-08-02 09:05:50  MG00000001  2018-08-02 09:05:50  MG00000001  View Edit Delete
6924  08  96  622  ネクタリン    ねくたりん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7180  08  97  517  清見オレンジ    きよみおれんじ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7692  01  102  2400033508593   ズッキーニ    ずっきーに    2019-05-20 00:00:00            View Edit Delete
7948  03  62  29  農産物29    のうさんぶつ29    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
18444  01  113  20905275  野菜⑥    やさい    2022-12-19 00:00:00    2022-12-19 12:59:30  MG00000001  2022-12-19 12:59:30  MG00000001  View Edit Delete
47628  01  032  51369  13690_農産物    のうさんぶつ    2023-09-29 00:00:00    2023-09-29 09:14:35  MG00000007  2023-09-29 09:14:35  MG00000007  View Edit Delete
47884  01  033  59303  59303_農産物  岡山農産09303  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:08:55  MG00000007  2023-10-19 13:08:55  MG00000007  View Edit Delete
49676  01  031  820608  820608_農産物8    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 11:49:03  MG00000007  2023-10-25 11:49:03  MG00000007  View Edit Delete
50956  01  037  114894  4894_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:16:50  MG00000007  2023-11-28 09:16:50  MG00000007  View Edit Delete
51468  01  033  50809  50809_農産物  岡山農産00809  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:24:05  MG00000007  2024-01-18 17:24:05  MG00000007  View Edit Delete

Page 12 of 2156, showing 20 records out of 43118 total, starting on record 221, ending on 240

(default) 2 queries took 22 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`.`limited_user_id` asc LIMIT 220, 20202015
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117