Label Logs

Id User Farmer Product Arrival Day Trader Company Cd Company Product Cd Company Product Nm Company Product Reciept Nm Sys Product Cd Shop Cd Label Issue Number Real Issue Number Price Amount Recycling Mark Flg Issue Day Brc Info Brc Shipment Product Characters Brc Shipment Product Cd Brc Price Cd Brc Price Characters Locality Cd Pickup Point Cd Amount Not Sel Flg Brc Not Print Flg Print Status Created Insert User Modified Update User Actions
418286  AG01003665 2020-08-06 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
37560  ALL9  20  20  130  2020-08-04 00:00:00  1778766501305  17787665  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2020-08-04 09:51:17  AG01003665      View Edit Delete
1139950  AG01003629 2023-06-15 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
32800  ALL9  40  40  100  2023-06-13 00:00:00  1778673201008  17786732  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-06-13 09:10:59  AG01003629      View Edit Delete
289518  AG01003372 2019-11-12 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34460  ALL9  23  23  320  2019-11-11 00:00:00  1778400203206  17784002  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2019-11-11 15:53:24  AG01003372      View Edit Delete
551918  AG01003380 2021-05-18 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
33420  ALL9  300  300  128  2021-05-11 00:00:00  1778453101283  17784531  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2021-05-11 09:48:24  AG01003380      View Edit Delete
356078  AG01003538 2020-04-11 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
38100  ALL9  65  65  480  2020-04-10 00:00:00  1778635704806  17786357  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2020-04-10 15:20:10  AG01003538      View Edit Delete
159982  AG01003022 2018-12-13 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
30300  ALL9  150  150  150  2018-12-11 00:00:00  1778233401503  17782334  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2018-12-11 10:55:17  AG01003022      View Edit Delete
816110  AG01003372 2022-04-30 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34400  ALL9  230  2022-04-29 00:00:00  1778400102301  17784001  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-04-29 15:35:32  AG01003372      View Edit Delete
1405934  AG01003372 1734130 2024-01-16 00:00:00  01  031 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34400  ALL9  11  11  300  2024-01-15 00:00:00  1778400103001  17784001  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-15 13:08:45  AG01003372      View Edit Delete
1014510  AG01003372 2023-01-07 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34400  ALL9  130  130  320  2023-01-06 00:00:00  1778400103209  17784001  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-01-06 15:08:36  AG01003372      View Edit Delete
426222  AG01003027 2020-08-18 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34100  ALL9  200  2020-08-18 00:00:00  1778300302009  17783003  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2020-08-18 08:38:34  AG01003027      View Edit Delete
1016302  AG01003538 2023-01-10 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
38100  ALL9  10  10  480  2023-01-09 00:00:00  1778635704806  17786357  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-01-09 14:44:43  AG01003538      View Edit Delete
951022  AG01003629 2022-10-15 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
32800  ALL9  52  52  100  2022-10-15 00:00:00  1778673201008  17786732  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-10-15 09:07:48  AG01003629      View Edit Delete
1017838  AG01003372 2023-01-12 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34400  ALL9  13  13  280  2023-01-11 00:00:00  1778400102806  17784001  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2023-01-11 13:51:30  AG01003372      View Edit Delete
952558  AG01003538 2022-10-18 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
38100  ALL9  20  20  480  2022-10-17 00:00:00  1778635704806  17786357  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-10-17 14:08:50  AG01003538      View Edit Delete
1412590  AG01003380 1734071 2024-02-29 00:00:00  01  031 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
33420  ALL9  330  330  148  2024-01-20 00:00:00  1778450201481  17784502  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2024-01-20 09:18:45  AG01003380      View Edit Delete
757998  AG01003372 2022-01-22 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34400  ALL9  298  2022-01-21 00:00:00  1778400102981  17784001  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2022-01-21 13:29:14  AG01003372      View Edit Delete
562158  AG01003538 2021-05-27 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
38100  ALL9  100  100  290  2021-05-26 00:00:00  1778635702901  17786357  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2021-05-26 13:01:12  AG01003538      View Edit Delete
431342  AG01003665 2020-08-27 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
39630  ALL9  130  2020-08-27 00:00:00  1778762301305  17787623  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2020-08-27 09:26:32  AG01003665      View Edit Delete
170734  AG01003372 2019-01-17 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
34400  ALL9  64  64  330  2019-01-16 00:00:00  1778400103308  17784001  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2019-01-16 14:18:49  AG01003372      View Edit Delete
695278  AG01003538 2021-10-28 00:00:00  01  001 
Notice (8): Undefined index: company_product_cd [APP/View/LabelLogs/index.ctp, line 53]
 
Notice (8): Undefined index: company_product_nm [APP/View/LabelLogs/index.ctp, line 54]
 
Notice (8): Undefined index: company_product_reciept_nm [APP/View/LabelLogs/index.ctp, line 55]
 
33710  ALL9  33  33  98  2021-10-28 00:00:00  1778638500986  17786385  24  24001 
Notice (8): Undefined index: brc_not_print_flg [APP/View/LabelLogs/index.ctp, line 72]
 
2021-10-28 08:28:51  AG01003538      View Edit Delete

Page 899 of 70806, showing 20 records out of 1416111 total, starting on record 17961, ending on 17980

(default) 2 queries took 7802 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `LabelLog`.`id`, `LabelLog`.`user_id`, `LabelLog`.`farmer_product_id`, `LabelLog`.`sameday_sequence_no`, `LabelLog`.`arrival_day`, `LabelLog`.`trader_id`, `LabelLog`.`company_cd`, `LabelLog`.`co_product_cd`, `LabelLog`.`co_product_nm`, `LabelLog`.`co_product_reciept_nm`, `LabelLog`.`sys_product_cd`, `LabelLog`.`sys_product_nm`, `LabelLog`.`display_product_nm`, `LabelLog`.`display_product_fk`, `LabelLog`.`shop_cd`, `LabelLog`.`label_issue_number`, `LabelLog`.`Real_issue_number`, `LabelLog`.`price`, `LabelLog`.`amount`, `LabelLog`.`recycling_mark_flg`, `LabelLog`.`issue_day`, `LabelLog`.`brc_info`, `LabelLog`.`brc_shipment_product_characters`, `LabelLog`.`brc_shipment_product_cd`, `LabelLog`.`brc_price_cd`, `LabelLog`.`brc_price_characters`, `LabelLog`.`brc_type_flag`, `LabelLog`.`brc_mid_flag`, `LabelLog`.`val_pos_pattern`, `LabelLog`.`mid_checkdigit_flag`, `LabelLog`.`locality_cd`, `LabelLog`.`locality_nm`, `LabelLog`.`pickup_point_cd`, `LabelLog`.`amount_not_sel_flg`, `LabelLog`.`print_Status`, `LabelLog`.`created`, `LabelLog`.`insert_user`, `LabelLog`.`modified`, `LabelLog`.`update_user`, `User`.`id`, `User`.`login_id`, `User`.`user_nm`, `User`.`user_fk`, `User`.`user_type`, `User`.`password`, `User`.`mail_address_1`, `User`.`mail_address_2`, `User`.`login_rock_flg`, `User`.`last_login_day`, `User`.`use_start_day`, `User`.`use_end_day`, `User`.`del_flg`, `User`.`init_pass_flg`, `User`.`created`, `User`.`insert_user`, `User`.`modified`, `User`.`update_user`, `FarmerProduct`.`id`, `FarmerProduct`.`farmer_id`, `FarmerProduct`.`trader_id`, `FarmerProduct`.`cmp_product_id`, `FarmerProduct`.`company_cd`, `FarmerProduct`.`co_product_cd`, `FarmerProduct`.`sys_product_cd`, `FarmerProduct`.`display_product_nm`, `FarmerProduct`.`display_product_fk`, `FarmerProduct`.`display_locality`, `FarmerProduct`.`farmer_edit_status`, `FarmerProduct`.`brc_shipment_product_characters`, `FarmerProduct`.`brc_shipment_product_cd`, `FarmerProduct`.`brc_price_cd`, `FarmerProduct`.`brc_price_characters`, `FarmerProduct`.`company_shipment_cd`, `FarmerProduct`.`brc_type_flag`, `FarmerProduct`.`brc_mid_flag`, `FarmerProduct`.`val_pos_pattern`, `FarmerProduct`.`mid_checkdigit_flag`, `FarmerProduct`.`shipment_start_month`, `FarmerProduct`.`shipment_end_month`, `FarmerProduct`.`use_start_day`, `FarmerProduct`.`use_end_day`, `FarmerProduct`.`del_flg`, `FarmerProduct`.`created`, `FarmerProduct`.`insert_user`, `FarmerProduct`.`modified`, `FarmerProduct`.`update_user` FROM `sato_agri`.`label_logs` AS `LabelLog` LEFT JOIN `sato_agri`.`users` AS `User` ON (`LabelLog`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmer_products` AS `FarmerProduct` ON (`LabelLog`.`farmer_product_id` = `FarmerProduct`.`id`) WHERE 1 = 1 ORDER BY `LabelLog`.`pickup_point_cd` asc LIMIT 17960, 2020201490
2SELECT COUNT(*) AS `count` FROM `sato_agri`.`label_logs` AS `LabelLog` LEFT JOIN `sato_agri`.`users` AS `User` ON (`LabelLog`.`user_id` = `User`.`id`) LEFT JOIN `sato_agri`.`farmer_products` AS `FarmerProduct` ON (`LabelLog`.`farmer_product_id` = `FarmerProduct`.`id`) WHERE 1 = 1116312