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
7220  08  97  695  冷凍イチゴ    れいとういちご    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2023-02-06 14:46:41  MG00000001  View Edit Delete
11865  06  661  00878  麗紅(れいこう)    れいこう    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11871  06  661  00884  ルートパセリ    るーとぱせり    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
12037  06  661  01051  ルピナス苗    るぴなすなえ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
6951  08  96  714  ルピアレッド    るぴあれっど    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7224  08  97  714  ルピアレッド    るぴあれっど    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
11817  06  661  00830  ルッコラの花    るっこらのはな    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11100  06  661  00099  ルッコラ    るっこら    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
6034  08  93  496241001037  ルッコラ    るっこら    2018-03-20 00:00:00    2018-03-20 11:25:12  MG00000001  2018-03-20 11:25:12  MG00000001  View Edit Delete
5532  08  91  496241001037  ルッコラ    るっこら    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
5548  02  51  566  ルッコラ    るっこら    2018-03-09 00:00:00    2018-03-09 14:07:39  MG00000001  2018-03-05 00:00:00  MG00000001  View Edit Delete
11673  06  661  00683  るこう草    るこうそう    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
6005  08  93  496241001008  リーフレタス(レッド)    りーふれたす(れっど)    2018-03-20 00:00:00    2018-03-20 11:25:12  MG00000001  2018-03-20 11:25:12  MG00000001  View Edit Delete
5503  08  91  496241001008  リーフレタス(レッド)    りーふれたす(れっど)    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
6004  08  93  496241001007  リーフレタス(グリーン)    りーふれたす(ぐりーん)    2018-03-20 00:00:00    2018-03-20 11:25:12  MG00000001  2018-03-20 11:25:12  MG00000001  View Edit Delete
5502  08  91  496241001007  リーフレタス(グリーン)    りーふれたす(ぐりーん)    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
11056  06  661  00055  リーフレタス    りーふれたす    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 14:35:47  MG00000001  View Edit Delete
13139  01  051  27127  リーフレタス    りーふれたす    2022-10-03 00:00:00    2022-10-03 10:40:43  MG00000001  2022-10-03 10:40:43  MG00000001  View Edit Delete
18369  01  002  20905265  リーフレタス    りーふれたす    2022-11-28 00:00:00    2022-11-28 12:21:37  MG00000001  2022-11-28 12:21:37  MG00000001  View Edit Delete
9519  02  51  368  リーキ    りーき    2021-03-09 00:00:00    2021-03-09 12:03:59  MG00000005  2021-03-09 12:03:59  MG00000005  View Edit Delete

Page 7 of 2156, showing 20 records out of 43118 total, starting on record 121, ending on 140

(default) 2 queries took 29 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`.`co_product_fk` desc LIMIT 120, 20202022
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117