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
12112  01  111  01094  赤たまねぎ    あかたまねぎ    2022-05-09 00:00:00    2022-05-09 11:08:58  MG00000001  2022-05-09 11:08:58  MG00000001  View Edit Delete
12880  01  113  20905251  野菜②    やさい    2022-09-06 00:00:00    2022-09-06 17:03:14  MG00000001  2022-12-19 12:57:43  MG00000001  View Edit Delete
13136  01  002  20110346  野菜    やさい    2022-09-30 00:00:00    2022-09-30 15:17:39  MG00000001  2022-09-30 15:17:39  MG00000001  View Edit Delete
18512  01  006  7200  野菜  産直野菜200  やさい    2023-01-26 00:00:00    2023-01-26 15:22:23  MG00000001  2023-01-26 15:22:23  MG00000001  View Edit Delete
42576  01  114  12520  2520_農産物1    のうさんぶつ    2023-04-18 00:00:00    2023-04-18 11:57:40  MG00000001  2023-04-18 11:57:40  MG00000001  View Edit Delete
43344  01  113  20905280  05280_農産物    のうさんぶつ    2023-05-30 00:00:00    2023-05-30 11:00:47  MG00000001  2023-05-30 11:00:47  MG00000001  View Edit Delete
47696  01  035  117560  2511756000000_農産物  産地直送 花6  のうさんぶつ    2023-10-12 00:00:00    2023-10-12 14:46:07  MG00000007  2023-10-12 14:46:07  MG00000007  View Edit Delete
47952  01  036  105562  5562_農産物4    のうさんぶつ    2023-10-20 00:00:00    2023-10-20 12:08:34  MG00000007  2023-10-20 12:08:34  MG00000007  View Edit Delete
51024  01  036  109184  9184_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 15:52:01  MG00000007  2023-11-28 15:52:01  MG00000007  View Edit Delete
1105  01  005  14063  玉葱 3P    たまねぎ3    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
2641  02  51  178  レモン    れもん    2017-02-27 00:00:00            View Edit Delete
5201  07  81  79  農産物79    のうさんぶつ79    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5457  02  53  87  農産物87    のうさんぶつ87    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6225  02  51  261  はるか    はるか    2018-05-22 00:00:00    2018-05-22 13:44:13  MG00000001  2018-05-22 13:44:13  MG00000001  View Edit Delete
6481  01  004  472739  果物    くだもの    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6737  01  002  20110643  野菜    やさい    2018-09-04 00:00:00    2018-09-04 09:22:01  MG00000001  2018-09-04 09:22:01  MG00000001  View Edit Delete
6993  01  002  20110567  野菜    やさい    2018-10-11 00:00:00    2018-10-11 10:32:39  MG00000001  2018-10-11 10:32:39  MG00000001  View Edit Delete
7249  08  97  997  野菜    やさい    2018-10-31 00:00:00    2018-10-31 11:47:00  MG00000001  2018-10-31 11:47:00  MG00000001  View Edit Delete
8017  03  62  98  農産物98    のうさんぶつ98    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
12113  01  111  01007  サラダほうれん草    さらだほうれんそう    2022-05-09 00:00:00    2022-05-09 11:18:55  MG00000001  2022-05-09 11:18:55  MG00000001  View Edit Delete

Page 82 of 2156, showing 20 records out of 43118 total, starting on record 1621, ending on 1640

(default) 2 queries took 28 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 1620, 20202020
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118