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
2597  01  006  7153  野菜  産直野菜153  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
4133  01  006  7227  野菜  産直野菜227  やさい    2016-08-29 00:00:00    2017-10-20 19:37:34  MG00000001  2017-10-20 19:37:34  MG00000001  View Edit Delete
18469  01  006  7214  野菜  産直野菜214  やさい    2022-12-27 00:00:00    2022-12-27 10:34:56  MG00000001  2022-12-27 10:34:56  MG00000001  View Edit Delete
2598  01  006  7154  野菜  産直野菜154  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
4134  01  006  7228  ぶなしめじ  産直野菜228  ぶなしめじ    2016-08-29 00:00:00    2017-10-20 19:37:34  MG00000001  2017-10-20 19:37:34  MG00000001  View Edit Delete
2599  01  006  7155  野菜  産直野菜155  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
2600  01  006  7156  野菜  産直野菜156  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
2601  01  006  7157  野菜  産直野菜157  やさい    2017-02-27 00:00:00    2017-02-22 00:00:00  MG00000001      View Edit Delete
8245  01  006  7185  野菜  産直野菜185  やさい    2020-01-31 00:00:00    2020-01-31 09:07:34  MG00000001  2020-01-31 09:07:34  MG00000001  View Edit Delete
8246  01  006  7184  野菜  産直野菜184  やさい    2020-01-31 00:00:00    2020-01-31 09:13:32  MG00000001  2020-01-31 09:13:32  MG00000001  View Edit Delete
8247  01  006  7183  野菜  産直野菜183  やさい    2020-01-31 00:00:00    2020-01-31 09:22:38  MG00000001  2020-01-31 09:22:38  MG00000001  View Edit Delete
2892  01  006  7287  果物  産直野菜287  くだもの    2016-08-29 00:00:00    2017-04-18 13:36:00  MG00000001  2017-04-18 13:36:00  MG00000001  View Edit Delete
18509  01  006  7172  野菜  産直野菜172  やさい    2023-01-26 00:00:00    2023-01-26 15:18:49  MG00000001  2023-01-26 15:18:49  MG00000001  View Edit Delete
18510  01  006  7197  野菜  産直野菜197  やさい    2023-01-26 00:00:00    2023-01-26 15:19:55  MG00000001  2023-01-26 15:19:55  MG00000001  View Edit Delete
18511  01  006  7181  野菜  産直野菜181  やさい    2023-01-26 00:00:00    2023-01-26 15:21:11  MG00000001  2023-01-26 15:21:11  MG00000001  View Edit Delete
18512  01  006  7200  野菜  産直野菜200  やさい    2023-01-26 00:00:00    2023-01-26 15:22:23  MG00000001  2023-01-26 15:22:23  MG00000001  View Edit Delete
1404  01  006  7168  ブロッコリー  産直野菜168  ぶろっこりー    2016-08-29 00:00:00    2016-08-30 12:24:46  MG00000001  2016-08-30 12:24:46  MG00000001  View Edit Delete
1405  01  006  7169  キャベツ  産直野菜169  きゃべつ    2016-08-29 00:00:00    2016-08-30 12:24:46  MG00000001  2016-08-30 12:24:46  MG00000001  View Edit Delete
1406  01  006  7170  野菜  産直野菜170  やさい    2016-08-29 00:00:00    2016-08-30 12:24:46  MG00000001  2016-08-30 12:24:46  MG00000001  View Edit Delete
1407  01  006  7180  野菜  産直野菜180  やさい    2016-08-29 00:00:00    2016-08-30 12:24:46  MG00000001  2016-08-30 12:24:46  MG00000001  View Edit Delete

Page 67 of 2156, showing 20 records out of 43118 total, starting on record 1321, ending on 1340

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