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
22  01  001  22  青ねぎ    あおねぎ    2016-08-29 00:00:00    2016-08-30 12:24:38  MG00000001  2016-08-30 12:24:38  MG00000001  View Edit Delete
1046  01  005  11061  フルーツトマト 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
1302  01  005  25013  果物 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
2582  01  006  7138  野菜  産直野菜138  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
2838  01  005  農産物    のうさんぶつ    2016-07-01 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
5142  07  81  20  農産物20    のうさんぶつ20    2017-12-21 00:00:00    2017-12-22 00:00:00  MD00000001  2017-12-22 00:00:00  MD00000001  View Edit Delete
5398  02  53  28  農産物28    のうさんぶつ28    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
6166  08  91  496241001056  ズッキーニ    ずっきーに    2018-04-12 00:00:00    2018-04-12 00:00:00  MG00000001  2018-04-12 00:00:00  MG00000001  View Edit Delete
6422  01  004  343332  野菜    やさい    2018-07-30 00:00:00    2018-07-30 18:25:51  MG00000001  2018-07-30 18:25:51  MG00000001  View Edit Delete
6678  01  004  499649  果実    かじつ    2018-08-09 00:00:00    2018-08-09 15:18:34  MG00000001  2018-08-09 15:18:34  MG00000001  View Edit Delete
6934  08  96  663  さくらんぼ(南陽)    さくらんぼなんよう    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 16:13:52  MG00000001  View Edit Delete
7190  08  97  559  りんご(ふじ)    りんごふじ    2018-09-25 00:00:00    2018-09-25 14:32:00  MG00000001  2018-09-25 14:32:00  MG00000001  View Edit Delete
7702  01  102  2400033508746   アスパラ    あすぱら    2019-05-20 00:00:00            View Edit Delete
7958  03  62  39  農産物39    のうさんぶつ39    2018-03-20 00:00:00    2018-03-20 00:00:00  MD00000001  2018-03-20 00:00:00  MD00000001  View Edit Delete
18454  01  006  7192  野菜  産直野菜192  やさい    2022-12-20 00:00:00    2022-12-20 15:50:51  MG00000001  2022-12-20 15:50:51  MG00000001  View Edit Delete
44054  01  911  100457  農産物8_0457    のうさんぶつ    2023-06-28 00:00:00    2023-06-28 13:45:27  MG00000001  2023-06-28 13:45:27  MG00000001  View Edit Delete
47638  01  032  51389  13890_農産物    のうさんぶつ    2023-09-29 00:00:00    2023-09-29 09:27:48  MG00000007  2023-09-29 09:27:48  MG00000007  View Edit Delete
47894  01  033  59313  59313_農産物  岡山農産09313  のうさんぶつ    2023-10-19 00:00:00    2023-10-19 13:27:40  MG00000007  2023-10-19 13:27:40  MG00000007  View Edit Delete
50966  01  036  105846  5846_農産物1    のうさんぶつ    2023-11-28 00:00:00    2023-11-28 09:39:26  MG00000007  2023-11-28 09:39:26  MG00000007  View Edit Delete
51478  01  033  50775  50775_農産物  岡山農産00775  のうさんぶつ    2024-01-18 00:00:00    2024-01-18 17:40:57  MG00000007  2024-01-18 17:40:57  MG00000007  View Edit Delete

Page 22 of 2156, showing 20 records out of 43118 total, starting on record 421, ending on 440

(default) 2 queries took 22 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 420, 20202015
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`cmp_products` AS `CmpProduct` WHERE 1 = 1117