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
1568  01  007  6230  青ねぎ  近郷野菜130  あおねぎ    2016-08-29 00:00:00    2016-08-30 12:24:47  MG00000001  2016-08-30 12:24:47  MG00000001  View Edit Delete
5222  01  002  20110430  青ねぎ    あおねぎ    2018-01-09 00:00:00    2018-01-09 12:24:39  MG00000001  2018-01-09 12:24:39  MG00000001  View Edit Delete
8579  01  004  343545  青ねぎ    あおねぎ    2020-09-29 00:00:00    2020-09-29 10:44:51  MG00000005  2021-03-25 10:40:48  MG00000005  View Edit Delete
7301  02  51  564  青ネギ    あおねぎ    2019-02-19 00:00:00    2019-02-19 09:12:01  MG00000001  2020-01-07 16:37:45  MG00000001  View Edit Delete
1418  01  007  6009  青ねぎ  近郷野菜10  あおねぎ    2016-08-29 00:00:00    2016-08-30 12:24:46  MG00000001  2016-08-30 12:24:46  MG00000001  View Edit Delete
3985  01  003  22  青ねぎ    あおねぎ    2017-03-15 00:00:00            View Edit Delete
1441  01  007  6032  青ネギ  近郷野菜33  あおねぎ    2016-08-29 00:00:00    2016-08-30 12:24:46  MG00000001  2016-08-30 12:24:46  MG00000001  View Edit Delete
11972  06  661  00985  青ネギ    あおねぎ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
17108  01  066  017  青ねぎ    あおねぎ    2022-10-21 00:00:00    2022-10-21 14:11:11  MG00000001  2022-10-21 14:11:11  MG00000001  View Edit Delete
12246  01  002  20110002  青ねぎ    あおねぎ    2022-06-22 00:00:00    2022-06-22 10:37:26  MG00000001  2022-06-22 10:37:26  MG00000001  View Edit Delete
7654  01  102  2400033507701   あおねぎ    あおねぎ    2019-05-20 00:00:00            View Edit Delete
7655  01  102  2400033507725   あおねぎ    あおねぎ    2019-05-20 00:00:00            View Edit Delete
11634  06  661  00635  青ネギ苗    あおねぎなえ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-09 15:35:29  MG00000001  View Edit Delete
11064  06  661  00063  青ねぎ(葉ねぎ)    あおねぎはねぎ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 14:39:34  MG00000001  View Edit Delete
1081  01  005  12164  青葱 パック    あおねぎぱっく    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1080  01  005  12161  青葱 1P    あおねぎ1    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
8160  02  51  374  青パパイヤ    あおぱぱいや    2019-11-25 00:00:00    2019-11-25 11:44:44  MG00000001  2019-11-25 11:44:44  MG00000001  View Edit Delete
12123  01  111  19357  赤えんどう    あかえんどう    2022-05-09 00:00:00    2022-05-09 12:05:59  MG00000001  2022-05-09 12:05:59  MG00000001  View Edit Delete
17095  01  066  004  赤かぶ    あかかぶ    2022-10-21 00:00:00    2022-10-21 14:11:11  MG00000001  2022-10-21 14:43:58  MG00000001  View Edit Delete
11048  06  661  00047  赤キャベツ    あかきゃべつ    2022-03-09 00:00:00    2022-03-09 15:35:29  MG00000001  2022-03-10 14:33:19  MG00000001  View Edit Delete

Page 2 of 2156, showing 20 records out of 43118 total, starting on record 21, ending on 40

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