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
01  001  06  ししとう    ししとう    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1286  01  005  24013  レモン 3P    れもん3    2016-07-01 00:00:00    2016-08-30 12:24:45  MG00000001  2016-08-30 12:24:45  MG00000001  View Edit Delete
1542  01  007  6204  アーリーレッド  近郷野菜104  あーりーれっど    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
2566  01  006  7122  野菜  産直野菜122  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5126  02  51  320  ユリ    ゆり    2017-12-04 00:00:00            View Edit Delete
5382  02  53  12  農産物12    のうさんぶつ12    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6150  02  51  533  わらび    わらび    2018-03-29 00:00:00    2018-03-29 00:00:00  MG00000001  2018-03-29 00:00:00  MG00000001  View Edit Delete
6406  08  95  005766660000  平塚キタアカリ(小)    ひらつかきたあかりしょう    2018-07-13 00:00:00    2018-07-13 18:59:21  MG00000001  2018-07-13 18:59:21  MG00000001  View Edit Delete
6918  08  96  601  なし(幸水)    なしこうすい    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7174  08  97  511  甘夏みかん    あまなつみかん    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7686  01  102  2400033508500   こかぶ    こかぶ    2019-05-20 00:00:00            View Edit Delete
7942  03  62  23  農産物23    のうさんぶつ23    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
11014  06  661  00013  ミニニンジン    みににんじん    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 09:38:04  MG00000001  View Edit Delete
11270  06  661  00271  あけび    あけび    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11526  06  661  00527  さがほのか    さがほのか    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11782  06  661  00794  安納芋    あんのういも    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12038  06  661  01052  ロベリア苗    ろべりあなえ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12294  04  710  89646  農産物    のうさんぶつ    2022-06-23 00:00:00    2022-06-23 11:26:53  MG00000001  2022-06-23 11:26:53  MG00000001  View Edit Delete
12550  01  053  61108  農産物    のうさんぶつ    2022-07-29 00:00:00    2022-07-29 13:16:29  MG00000001  2022-07-29 13:16:29  MG00000001  View Edit Delete
12806  01  056  32783  農産物    のうさんぶつ    2022-08-22 00:00:00    2022-08-22 12:42:10  MG00000001  2022-08-22 12:42:10  MG00000001  View Edit Delete

Page 52 of 2156, showing 20 records out of 43118 total, starting on record 1021, ending on 1040

(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`.`use_end_day` desc LIMIT 1020, 20202019
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1119