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
12199  01  110  102563  桃(川中島)    もも    2022-06-06 00:00:00    2022-06-06 15:50:25  MG00000001  2022-06-06 15:50:25  MG00000001  View Edit Delete
18343  01  002  20110558  野菜    やさい    2022-11-21 00:00:00    2022-11-21 10:22:09  MG00000001  2022-11-21 10:22:09  MG00000001  View Edit Delete
46759  01  114  12740  2740_農産物1    のうさんぶつ    2023-09-12 00:00:00    2023-09-12 09:50:46  MG00000001  2023-09-12 09:50:46  MG00000001  View Edit Delete
47527  01  033  57744  57744_農産物  岡山農産07744  のうさんぶつ    2023-09-28 00:00:00    2023-09-28 13:06:26  MG00000007  2023-09-28 13:06:26  MG00000007  View Edit Delete
49831  01  031  820621  820621_農産物21    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 15:54:39  MG00000007  2023-10-25 15:54:39  MG00000007  View Edit Delete
50087  01  032  51392  13920_農産物    のうさんぶつ    2023-11-07 00:00:00    2023-11-07 10:54:53  MG00000007  2023-11-07 10:54:53  MG00000007  View Edit Delete
50599  01  036  105749  農産物5_5749    のうさんぶつ    2023-11-13 00:00:00    2023-11-13 16:30:47  MG00000007  2023-11-13 16:30:47  MG00000007  View Edit Delete
51111  01  033  50768  50768_農産物  岡山農産00768  のうさんぶつ    2023-12-07 00:00:00    2023-12-07 15:35:35  MG00000007  2023-12-07 15:35:35  MG00000007  View Edit Delete
51367  01  038  58735  58735_農産物  産直花08735  のうさんぶつ    2023-12-22 00:00:00    2023-12-22 14:38:04  MG00000007  2023-12-22 14:38:04  MG00000007  View Edit Delete
1192  01  005  18221  タカのつめ 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
1448  01  007  6039  カリフローレ  近郷野菜40  かりふろーれ    2016-08-29 00:00:00    2016-08-30 12:24:46  MG00000001  2016-08-30 12:24:46  MG00000001  View Edit Delete
2472  01  006  7028  野菜  産直野菜28  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
2728  01  002  20110324  野菜    やさい    2017-02-28 00:00:00            View Edit Delete
4008  01  003  45  スダチ    すだち    2017-03-15 00:00:00            View Edit Delete
5032  05  71  89649  農産物    のうさんぶつ    2017-11-01 00:00:00    2017-11-01 11:34:46  MG00000001  2017-11-01 11:34:46  MG00000001  View Edit Delete
5288  02  52  1693  農産物    のうさんぶつ    2018-02-08 00:00:00    2018-02-08 00:00:00  MG00000001  2018-02-08 00:00:00  MG00000001  View Edit Delete
5544  08  91  496241001049  パクチー    ぱくちー    2018-03-02 00:00:00    2018-03-02 00:00:00  MG00000001  2018-03-02 09:21:23  MG00000001  View Edit Delete
6056  03  61  09  農産物09    のうさんぶつ09    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
6312  08  94  040020390654  ジャガイモ (インカのめざめ) S    じゃがいもいんかのめざめえす    2018-06-29 00:00:00    2018-06-29 14:54:17  MG00000001  2018-06-29 14:54:17  MG00000001  View Edit Delete
6824  08  96  168  ミディトマト    みでぃとまと    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-26 14:37:32  MG00000001  View Edit Delete

Page 173 of 2156, showing 20 records out of 43118 total, starting on record 3441, ending on 3460

(default) 2 queries took 36 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 3440, 20202026
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 11110