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
14  01  001  14  一寸豆    いっすんまめ    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1038  01  005  11014  きゅうり パック    きゅうりぱっく    2016-07-01 00:00:00    2016-08-30 12:24:44  MG00000001  2016-08-30 12:24:44  MG00000001  View Edit Delete
1294  01  005  24033  グレープフルーツホワイト 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
2574  01  006  7130  野菜  産直野菜130  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
5134  07  81  12  農産物12    のうさんぶつ12    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5390  02  53  20  農産物20    のうさんぶつ20    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6158  02  51  763  コスレタス    こすれたす    2018-04-11 00:00:00    2018-04-11 00:00:00  MG00000001  2018-04-11 00:00:00  MG00000001  View Edit Delete
6414  01  004  343095  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6670  01  004  343647  野菜    やさい    2018-08-09 00:00:00    2018-08-09 14:58:52  MG00000001  2018-08-09 15:10:10  MG00000001  View Edit Delete
6926  08  96  642  すもも    すもも    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7182  08  97  551  りんご    りんご    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7694  01  102  2400033508623   モロヘイヤ    もろへいや    2019-05-20 00:00:00            View Edit Delete
7950  03  62  31  農産物31    のうさんぶつ31    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
18446  01  113  20904959  野菜②    やさい    2022-12-19 00:00:00    2022-12-19 13:25:10  MG00000001  2022-12-19 13:25:10  MG00000001  View Edit Delete
44046  04  710  99448  農産物    のうさんぶつ    2023-06-28 00:00:00    2023-06-28 08:56:05  MG00000001  2023-06-28 08:56:05  MG00000001  View Edit Delete
47630  01  032  51371  13710_農産物    のうさんぶつ    2023-09-29 00:00:00    2023-09-29 09:17:51  MG00000007  2023-09-29 09:17:51  MG00000007  View Edit Delete
47886  01  033  59305  59305_農産物  岡山農産09305  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:11:53  MG00000007  2023-10-19 13:11:53  MG00000007  View Edit Delete
49678  01  031  820610  820610_農産物10    のうさんぶつ    2023-10-25 00:00:00    2023-10-25 11:58:54  MG00000007  2023-10-25 11:58:54  MG00000007  View Edit Delete
50958  01  036  105838  5838_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:22:03  MG00000007  2023-11-28 09:22:03  MG00000007  View Edit Delete
51470  01  033  50811  50811_農産物  岡山農産00811  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:26:13  MG00000007  2024-01-18 17:26:13  MG00000007  View Edit Delete

Page 14 of 2156, showing 20 records out of 43118 total, starting on record 261, ending on 280

(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`.`limited_user_id` asc LIMIT 260, 20202016
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1118