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
8606  01  002  20110441  赤玉葱    あかたまねぎ    2020-10-15 00:00:00    2020-10-15 15:48:42  MG00000005  2020-10-15 15:48:42  MG00000005  View Edit Delete
8607  01  002  20110442  野菜    やさい    2020-10-15 00:00:00    2020-10-15 15:49:40  MG00000005  2022-05-10 15:52:28  MG00000001  View Edit Delete
8608  01  002  20110426  野菜    やさい    2020-11-02 00:00:00    2020-11-02 09:51:08  MG00000005  2020-11-02 09:51:08  MG00000005  View Edit Delete
8609  01  011  68692  農産物    のうさんぶつ    2020-11-04 00:00:00    2020-11-04 09:27:54  MG00000005  2020-11-04 09:27:54  MG00000005  View Edit Delete
8610  01  002  20120232  果実    かじつ    2020-11-16 00:00:00    2020-11-16 15:04:03  MG00000005  2020-11-16 15:04:03  MG00000005  View Edit Delete
8611  01  002  20110403  野菜    やさい    2020-11-16 00:00:00    2020-11-16 15:11:21  MG00000005  2020-11-16 15:11:21  MG00000005  View Edit Delete
8612  01  002  20110342  野菜    やさい    2020-11-16 00:00:00    2020-11-16 15:13:49  MG00000005  2020-11-16 15:13:49  MG00000005  View Edit Delete
8613  05  71  99050  農産物    のうさんぶつ    2020-11-17 00:00:00    2020-11-17 09:56:08  MG00000005  2020-11-17 09:56:08  MG00000005  View Edit Delete
8614  05  71  99060  農産物    のうさんぶつ    2020-12-09 00:00:00    2020-12-09 14:55:13  MG00000005  2020-12-09 14:55:13  MG00000005  View Edit Delete
8615  02  51  954  ユコウ(柚香)    ゆこう    2020-12-18 00:00:00    2020-12-18 14:48:42  MG00000005  2020-12-18 14:48:42  MG00000005  View Edit Delete
8616  01  011  99999  農産物    のうさんぶつ    2021-01-13 00:00:00    2021-01-13 16:54:59  MG00000005  2021-01-13 16:54:59  MG00000005  View Edit Delete
9015  02  55  2138052  農産物    のうさんぶつ    2021-01-20 00:00:00    2021-01-20 13:11:10  MG00000005  2021-01-20 13:11:10  MG00000005  View Edit Delete
9105  02  51  202  小玉スイカ    こだますいか    2021-01-29 00:00:00    2021-01-29 15:23:24  MG00000005  2021-01-29 15:23:24  MG00000005  View Edit Delete
9118  01  011  68626  農産物    のうさんぶつ    2021-02-17 00:00:00    2021-02-17 14:36:03  MG00000005  2021-02-17 14:36:03  MG00000005  View Edit Delete
9119  01  011  68623  農産物    のうさんぶつ    2021-02-26 00:00:00    2021-02-26 16:05:23  MG00000005  2021-02-26 16:05:23  MG00000005  View Edit Delete
9120  02  56  00  農産物00    のうさんぶつ00    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
9121  02  56  01  農産物01    のうさんぶつ01    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
9122  02  56  02  農産物02    のうさんぶつ02    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
9123  02  56  03  農産物03    のうさんぶつ03    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete
9124  02  56  04  農産物04    のうさんぶつ04    2018-02-09 00:00:00    2018-02-09 00:00:00  MD00000001  2018-02-09 00:00:00  MD00000001  View Edit Delete

Page 174 of 2156, showing 20 records out of 43118 total, starting on record 3461, ending on 3480

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