Type Name Status InnoDB ===================================== 2023-04-12 11:11:50 0x7f45b83a5700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 22 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 12334020 srv_active, 0 srv_shutdown, 4305 srv_idle srv_master_thread log flush and writes: 12338264 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 850067256 --Thread 139938912179968 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139935487661824 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 1 --Thread 139938821461760 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139937418151680 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932403111680 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932379457280 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139935482746624 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938822690560 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932358117120 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139931467888384 has waited at dict0dict.cc line 880 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938812245760 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929737185024 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938898048768 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929704314624 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938798728960 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932311422720 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 1 --Thread 139938899277568 has waited at dict0dict.cc line 880 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 1 --Thread 140599983843072 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 1 --Thread 139935475988224 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 1 --Thread 139938788009728 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 1 --Thread 139938813781760 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 1 --Thread 139938801800960 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 1 --Thread 139938807637760 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938819311360 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139933749491456 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938816239360 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139935533434624 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938797192960 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938782447360 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938784597760 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938813474560 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139931486627584 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 1 --Thread 139938809788160 has waited at dict0dict.cc line 326 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938818389760 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938907264768 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139937477441280 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929725511424 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139933777544960 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938903578368 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929734727424 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938807023360 has waited at dict0dict.cc line 880 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929709537024 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139937480206080 has waited at dict0dict.cc line 880 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938898970368 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139939162883840 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938791356160 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932253218560 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929760061184 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938788624128 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938795964160 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932315723520 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139931483248384 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938808559360 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938800879360 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938914637568 has waited at dict0dict.cc line 880 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139937451943680 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938809173760 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932382836480 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929403770624 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139939163498240 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938913408768 has waited at ha_innodb.cc line 15252 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938789238528 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929718445824 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929454294784 has waited at dict0dict.cc line 880 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938902963968 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938793813760 has waited at dict0dict.cc line 880 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139939163191040 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929690797824 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139933782152960 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938814088960 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932276369152 has waited at dict0dict.cc line 880 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938817160960 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938811324160 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929764669184 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932302481152 has waited at dict0dict.cc line 326 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929822115584 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938785212160 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139933265880832 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929711073024 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932360881920 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139935525754624 has waited at dict0dict.cc line 880 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938906343168 has waited at dict0dict.cc line 326 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938821154560 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938908800768 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139933737010944 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932235093760 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139937441191680 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938786780928 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938810095360 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139933780924160 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139937440270080 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139933317306112 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 1 --Thread 139932206216960 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938910951168 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929709844224 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938801493760 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139939164727040 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938895283968 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938791970560 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938915251968 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139939162269440 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139935505479424 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139939164419840 has waited at dict0dict.cc line 880 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932378535680 has waited at dict0dict.cc line 326 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938800572160 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139929776957184 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938816546560 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139932429838080 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139937466689280 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938915866368 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938914023168 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 --Thread 139938815317760 has waited at ha_innodb.cc line 14345 for 0.00 seconds the semaphore: Mutex at 0x55d24de5b840, Mutex DICT_SYS created dict0dict.cc:824, lock var 0 OS WAIT ARRAY INFO: signal count 63316202540 RW-shared spins 150693592370, rounds 234173489309, OS waits 648477931 RW-excl spins 4844637588, rounds 9230689185, OS waits 35967306 RW-sx spins 28929481, rounds 277833667, OS waits 1972008 Spin rounds per wait: 1.55 RW-shared, 1.91 RW-excl, 9.60 RW-sx ------------------------ LATEST FOREIGN KEY ERROR ------------------------ 2023-04-12 11:10:52 0x7f460b9d8700 Transaction: TRANSACTION 54548028127, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1128, 1 row lock(s) MySQL thread id 3291454522, OS thread handle 139938819311360, query id 113824429299 58.76.184.32 ltcare Update INSERT INTO hompy_counter ( hpmfkey /* 홈페이지 FK */ , hpcdate /* 일자 */ , hpctcnt /* 방문횟수 */ ) VALUES ( '' /* 홈페이지 FK */ , '20230412' /* 일자 * Foreign key constraint fails for table `ltcare`.`hompy_counter`: , CONSTRAINT `hompy_counter_ibfk_1` FOREIGN KEY (`hpmfkey`) REFERENCES `hompy_master` (`hpmmgno`) ON DELETE CASCADE in parent table, in index PRIMARY tuple: DATA TUPLE: 5 fields; 0: len 4; hex 80000000; asc ;; 1: len 8; hex 3230323330343132; asc 20230412;; 2: len 6; hex 000cb350dadf; asc P ;; 3: len 7; hex c40005fcdc1bba; asc ;; 4: len 4; hex 80000001; asc ;; But in parent table `ltcare`.`hompy_master`, in index PRIMARY, the closest match we can find is record: PHYSICAL RECORD: n_fields 24; compact format; info bits 0 0: len 4; hex 80000001; asc ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 80000004; asc ;; 4: len 4; hex 80000001; asc ;; 5: len 26; hex ecbc80ec96b4ed8facec9a94ec9691ec9b9028eb8db0ebaaa829; asc ( );; 6: len 8; hex 3230313630313031; asc 20160101;; 7: len 8; hex 3230393931323331; asc 20991231;; 8: len 4; hex 64656d6f; asc demo;; 9: len 1; hex 31; asc 1;; 10: len 10; hex 31323038313537343635; asc 1208157465;; 11: len 0; hex ; asc ;; 12: len 11; hex 3332383230303030303539; asc 32820000059;; 13: len 0; hex ; asc ;; 14: len 1; hex 32; asc 2;; 15: len 2; hex 8002; asc ;; 16: len 2; hex 82a4; asc ;; 17: len 4; hex 20202020; asc ;; 18: len 1; hex 31; asc 1;; 19: len 4; hex 80000000; asc ;; 20: len 18; hex 73736b616e674068616e67616e672e636f6d; asc sskang@hangang.com;; 21: len 13; hex 3031302d373631382d35313834; asc 010-7618-5184;; 22: len 5; hex 9998e2e6f9; asc ;; 23: len 5; hex 99af8d0578; asc x;; ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2023-04-12 11:11:50 0x7f4544279700 *** (1) TRANSACTION: TRANSACTION 54548046518, ACTIVE 0 sec starting index read mysql tables in use 3, locked 3 LOCK WAIT 4 lock struct(s), heap size 1128, 3 row lock(s) MySQL thread id 3291485604, OS thread handle 139929764669184, query id 113825670645 58.76.184.38 ltcare Updating UPDATE family_app_counsel SET facstat = '1' , facrrdt = '20230412111150' , facrpwk = '543210' , facrpwn = '김지선' , facrpwt = '사무국장' WHERE ctmfkey = '22475' AND faafkey = '34159' AND facstat = '0' AND factype = '2' *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 20627 page no 716 n bits 1272 index ctmfkey of table `ltcare`.`family_app_counsel` trx id 54548046518 lock_mode X waiting Record lock, heap no 25 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80006f27; asc o';; *** (2) TRANSACTION: TRANSACTION 54548046471, ACTIVE 1 sec fetching rows mysql tables in use 3, locked 3 97 lock struct(s), heap size 24696, 1567 row lock(s) MySQL thread id 3291485508, OS thread handle 139935472916224, query id 113825667489 58.76.184.36 ltcare Updating UPDATE family_app_counsel SET facstat = '1' , facrrdt = '20230412111149' , facrpwk = '543210' , facrpwn = '김지선' , facrpwt = '사무국장' WHERE ctmfkey = '22475' AND faafkey = '30567' AND facstat = '0' AND factype = '2' *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 20627 page no 716 n bits 1272 index ctmfkey of table `ltcare`.`family_app_counsel` trx id 54548046471 lock_mode X Record lock, heap no 1 PHYSICAL RECORD: n_fields 1; compact format; info bits 0 0: len 8; hex 73757072656d756d; asc supremum;; Record lock, heap no 25 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80006f27; asc o';; Record lock, heap no 26 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80006f2e; asc o.;; Record lock, heap no 27 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80006f31; asc o1;; Record lock, heap no 28 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80006f6b; asc ok;; Record lock, heap no 29 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80006f6c; asc ol;; Record lock, heap no 30 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80006f7a; asc oz;; Record lock, heap no 31 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80006f7d; asc o};; Record lock, heap no 32 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80006f83; asc o ;; Record lock, heap no 33 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80006fc9; asc o ;; Record lock, heap no 34 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80006fd9; asc o ;; Record lock, heap no 35 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80006fda; asc o ;; Record lock, heap no 36 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007022; asc p";; Record lock, heap no 37 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000702c; asc p,;; Record lock, heap no 38 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007037; asc p7;; Record lock, heap no 39 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000703e; asc p>;; Record lock, heap no 40 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000703f; asc p?;; Record lock, heap no 41 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007051; asc pQ;; Record lock, heap no 42 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007054; asc pT;; Record lock, heap no 43 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000705f; asc p_;; Record lock, heap no 44 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007060; asc p`;; Record lock, heap no 45 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007064; asc pd;; Record lock, heap no 46 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007065; asc pe;; Record lock, heap no 47 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000706c; asc pl;; Record lock, heap no 48 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007074; asc pt;; Record lock, heap no 49 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000707b; asc p{;; Record lock, heap no 50 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000707c; asc p|;; Record lock, heap no 51 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007080; asc p ;; Record lock, heap no 52 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007082; asc p ;; Record lock, heap no 53 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007084; asc p ;; Record lock, heap no 54 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007085; asc p ;; Record lock, heap no 55 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007086; asc p ;; Record lock, heap no 56 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007087; asc p ;; Record lock, heap no 57 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007088; asc p ;; Record lock, heap no 58 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007089; asc p ;; Record lock, heap no 59 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000708a; asc p ;; Record lock, heap no 60 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000708c; asc p ;; Record lock, heap no 61 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000708d; asc p ;; Record lock, heap no 62 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000708e; asc p ;; Record lock, heap no 63 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007091; asc p ;; Record lock, heap no 64 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000709a; asc p ;; Record lock, heap no 65 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000709c; asc p ;; Record lock, heap no 66 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000709f; asc p ;; Record lock, heap no 67 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070a9; asc p ;; Record lock, heap no 68 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070ab; asc p ;; Record lock, heap no 69 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070ac; asc p ;; Record lock, heap no 70 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070ad; asc p ;; Record lock, heap no 71 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070ae; asc p ;; Record lock, heap no 72 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070af; asc p ;; Record lock, heap no 73 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070b0; asc p ;; Record lock, heap no 74 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070b1; asc p ;; Record lock, heap no 75 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070b2; asc p ;; Record lock, heap no 76 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070b3; asc p ;; Record lock, heap no 77 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070b6; asc p ;; Record lock, heap no 78 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070c4; asc p ;; Record lock, heap no 79 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070c5; asc p ;; Record lock, heap no 80 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070c7; asc p ;; Record lock, heap no 81 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070fe; asc p ;; Record lock, heap no 82 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800070ff; asc p ;; Record lock, heap no 83 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007118; asc q ;; Record lock, heap no 84 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007119; asc q ;; Record lock, heap no 85 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000711d; asc q ;; Record lock, heap no 86 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007120; asc q ;; Record lock, heap no 87 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007162; asc qb;; Record lock, heap no 88 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007177; asc qw;; Record lock, heap no 89 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007178; asc qx;; Record lock, heap no 90 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000717e; asc q~;; Record lock, heap no 91 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007180; asc q ;; Record lock, heap no 92 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007181; asc q ;; Record lock, heap no 93 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800071c1; asc q ;; Record lock, heap no 94 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800071d8; asc q ;; Record lock, heap no 95 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800071d9; asc q ;; Record lock, heap no 96 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800071da; asc q ;; Record lock, heap no 97 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007213; asc r ;; Record lock, heap no 98 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007214; asc r ;; Record lock, heap no 99 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007224; asc r$;; Record lock, heap no 100 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007226; asc r&;; Record lock, heap no 101 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007227; asc r';; Record lock, heap no 102 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007241; asc rA;; Record lock, heap no 103 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007242; asc rB;; Record lock, heap no 104 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007256; asc rV;; Record lock, heap no 105 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007267; asc rg;; Record lock, heap no 106 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007268; asc rh;; Record lock, heap no 107 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007269; asc ri;; Record lock, heap no 108 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007271; asc rq;; Record lock, heap no 109 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007273; asc rs;; Record lock, heap no 110 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007286; asc r ;; Record lock, heap no 111 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007287; asc r ;; Record lock, heap no 112 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007288; asc r ;; Record lock, heap no 113 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000728d; asc r ;; Record lock, heap no 114 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072a2; asc r ;; Record lock, heap no 115 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072a4; asc r ;; Record lock, heap no 116 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072ab; asc r ;; Record lock, heap no 117 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072ac; asc r ;; Record lock, heap no 118 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072b2; asc r ;; Record lock, heap no 119 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072b3; asc r ;; Record lock, heap no 120 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072b4; asc r ;; Record lock, heap no 121 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072b5; asc r ;; Record lock, heap no 122 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072b7; asc r ;; Record lock, heap no 123 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072b8; asc r ;; Record lock, heap no 124 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072b9; asc r ;; Record lock, heap no 125 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072ba; asc r ;; Record lock, heap no 126 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072bf; asc r ;; Record lock, heap no 127 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072ea; asc r ;; Record lock, heap no 128 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072eb; asc r ;; Record lock, heap no 129 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072ec; asc r ;; Record lock, heap no 130 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072ed; asc r ;; Record lock, heap no 131 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072ee; asc r ;; Record lock, heap no 132 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072ef; asc r ;; Record lock, heap no 133 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072f0; asc r ;; Record lock, heap no 134 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072f1; asc r ;; Record lock, heap no 135 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072f2; asc r ;; Record lock, heap no 136 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072f5; asc r ;; Record lock, heap no 137 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072f6; asc r ;; Record lock, heap no 138 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072f8; asc r ;; Record lock, heap no 139 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072f9; asc r ;; Record lock, heap no 140 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072fb; asc r ;; Record lock, heap no 141 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800072fc; asc r ;; Record lock, heap no 142 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007303; asc s ;; Record lock, heap no 143 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007304; asc s ;; Record lock, heap no 144 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007305; asc s ;; Record lock, heap no 145 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007306; asc s ;; Record lock, heap no 146 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007308; asc s ;; Record lock, heap no 147 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007309; asc s ;; Record lock, heap no 148 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000730b; asc s ;; Record lock, heap no 149 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000730c; asc s ;; Record lock, heap no 150 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000730d; asc s ;; Record lock, heap no 151 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000730f; asc s ;; Record lock, heap no 152 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007310; asc s ;; Record lock, heap no 153 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007311; asc s ;; Record lock, heap no 154 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007312; asc s ;; Record lock, heap no 155 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007313; asc s ;; Record lock, heap no 156 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007314; asc s ;; Record lock, heap no 157 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007315; asc s ;; Record lock, heap no 158 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007316; asc s ;; Record lock, heap no 159 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007317; asc s ;; Record lock, heap no 160 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007318; asc s ;; Record lock, heap no 161 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007328; asc s(;; Record lock, heap no 162 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007329; asc s);; Record lock, heap no 163 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000732a; asc s*;; Record lock, heap no 164 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000732b; asc s+;; Record lock, heap no 165 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000732e; asc s.;; Record lock, heap no 166 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007330; asc s0;; Record lock, heap no 167 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000733d; asc s=;; Record lock, heap no 168 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000733e; asc s>;; Record lock, heap no 169 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007340; asc s@;; Record lock, heap no 170 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007341; asc sA;; Record lock, heap no 171 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007342; asc sB;; Record lock, heap no 172 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007343; asc sC;; Record lock, heap no 173 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007344; asc sD;; Record lock, heap no 174 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007345; asc sE;; Record lock, heap no 175 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007346; asc sF;; Record lock, heap no 176 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007347; asc sG;; Record lock, heap no 177 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007348; asc sH;; Record lock, heap no 178 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000734b; asc sK;; Record lock, heap no 179 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000734d; asc sM;; Record lock, heap no 180 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000734e; asc sN;; Record lock, heap no 181 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007352; asc sR;; Record lock, heap no 182 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007353; asc sS;; Record lock, heap no 183 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007355; asc sU;; Record lock, heap no 184 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007356; asc sV;; Record lock, heap no 185 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007357; asc sW;; Record lock, heap no 186 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007358; asc sX;; Record lock, heap no 187 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000735c; asc s\\;; Record lock, heap no 188 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000735d; asc s];; Record lock, heap no 189 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000735e; asc s^;; Record lock, heap no 190 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000735f; asc s_;; Record lock, heap no 191 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007361; asc sa;; Record lock, heap no 192 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007363; asc sc;; Record lock, heap no 193 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007364; asc sd;; Record lock, heap no 194 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007365; asc se;; Record lock, heap no 195 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007366; asc sf;; Record lock, heap no 196 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007367; asc sg;; Record lock, heap no 197 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007369; asc si;; Record lock, heap no 198 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000736b; asc sk;; Record lock, heap no 199 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000736d; asc sm;; Record lock, heap no 200 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000736f; asc so;; Record lock, heap no 201 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007370; asc sp;; Record lock, heap no 202 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007371; asc sq;; Record lock, heap no 203 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007372; asc sr;; Record lock, heap no 204 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007373; asc ss;; Record lock, heap no 205 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007374; asc st;; Record lock, heap no 206 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007377; asc sw;; Record lock, heap no 207 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007379; asc sy;; Record lock, heap no 208 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800073a6; asc s ;; Record lock, heap no 209 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800073b7; asc s ;; Record lock, heap no 210 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800073b8; asc s ;; Record lock, heap no 211 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800073be; asc s ;; Record lock, heap no 212 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800073d0; asc s ;; Record lock, heap no 213 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800073d9; asc s ;; Record lock, heap no 214 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800073f6; asc s ;; Record lock, heap no 215 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800073fa; asc s ;; Record lock, heap no 216 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000740e; asc t ;; Record lock, heap no 217 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007411; asc t ;; Record lock, heap no 218 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007447; asc tG;; Record lock, heap no 219 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007467; asc tg;; Record lock, heap no 220 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007469; asc ti;; Record lock, heap no 221 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000746b; asc tk;; Record lock, heap no 222 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000746c; asc tl;; Record lock, heap no 223 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000746d; asc tm;; Record lock, heap no 224 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000746e; asc tn;; Record lock, heap no 225 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000746f; asc to;; Record lock, heap no 226 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007471; asc tq;; Record lock, heap no 227 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000749c; asc t ;; Record lock, heap no 228 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800074b7; asc t ;; Record lock, heap no 229 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800074b8; asc t ;; Record lock, heap no 230 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800074c1; asc t ;; Record lock, heap no 231 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800074c3; asc t ;; Record lock, heap no 232 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800074ce; asc t ;; Record lock, heap no 233 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800074d0; asc t ;; Record lock, heap no 234 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800074ee; asc t ;; Record lock, heap no 235 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800074f2; asc t ;; Record lock, heap no 236 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800074f8; asc t ;; Record lock, heap no 237 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800074fd; asc t ;; Record lock, heap no 238 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007501; asc u ;; Record lock, heap no 239 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007508; asc u ;; Record lock, heap no 240 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007509; asc u ;; Record lock, heap no 241 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007513; asc u ;; Record lock, heap no 242 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007525; asc u%;; Record lock, heap no 243 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007531; asc u1;; Record lock, heap no 244 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000753e; asc u>;; Record lock, heap no 245 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000753f; asc u?;; Record lock, heap no 246 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007542; asc uB;; Record lock, heap no 247 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007543; asc uC;; Record lock, heap no 248 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007546; asc uF;; Record lock, heap no 249 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000754a; asc uJ;; Record lock, heap no 250 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000755e; asc u^;; Record lock, heap no 251 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000755f; asc u_;; Record lock, heap no 252 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007573; asc us;; Record lock, heap no 253 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000757b; asc u{;; Record lock, heap no 254 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000758b; asc u ;; Record lock, heap no 255 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000758c; asc u ;; Record lock, heap no 256 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000758d; asc u ;; Record lock, heap no 257 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000758e; asc u ;; Record lock, heap no 258 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000758f; asc u ;; Record lock, heap no 259 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007590; asc u ;; Record lock, heap no 260 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000759c; asc u ;; Record lock, heap no 261 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000759d; asc u ;; Record lock, heap no 262 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000759e; asc u ;; Record lock, heap no 263 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000759f; asc u ;; Record lock, heap no 264 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075a0; asc u ;; Record lock, heap no 265 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075a1; asc u ;; Record lock, heap no 266 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075a2; asc u ;; Record lock, heap no 267 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075a8; asc u ;; Record lock, heap no 268 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075ba; asc u ;; Record lock, heap no 269 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075bd; asc u ;; Record lock, heap no 270 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075be; asc u ;; Record lock, heap no 271 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075c0; asc u ;; Record lock, heap no 272 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075c1; asc u ;; Record lock, heap no 273 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075c2; asc u ;; Record lock, heap no 274 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075c3; asc u ;; Record lock, heap no 275 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075c4; asc u ;; Record lock, heap no 276 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075c5; asc u ;; Record lock, heap no 277 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075c6; asc u ;; Record lock, heap no 278 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075cd; asc u ;; Record lock, heap no 279 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075d9; asc u ;; Record lock, heap no 280 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075da; asc u ;; Record lock, heap no 281 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800075db; asc u ;; Record lock, heap no 282 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007605; asc v ;; Record lock, heap no 283 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000760e; asc v ;; Record lock, heap no 284 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007613; asc v ;; Record lock, heap no 285 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007615; asc v ;; Record lock, heap no 286 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007616; asc v ;; Record lock, heap no 287 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007637; asc v7;; Record lock, heap no 288 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000764a; asc vJ;; Record lock, heap no 289 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000764c; asc vL;; Record lock, heap no 290 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000764e; asc vN;; Record lock, heap no 291 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000764f; asc vO;; Record lock, heap no 292 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000766b; asc vk;; Record lock, heap no 293 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000766d; asc vm;; Record lock, heap no 294 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000767b; asc v{;; Record lock, heap no 295 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000767f; asc v ;; Record lock, heap no 296 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800076b2; asc v ;; Record lock, heap no 297 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800076b3; asc v ;; Record lock, heap no 298 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800076dd; asc v ;; Record lock, heap no 299 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800076e0; asc v ;; Record lock, heap no 300 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800076e3; asc v ;; Record lock, heap no 301 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800076f6; asc v ;; Record lock, heap no 302 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800076f7; asc v ;; Record lock, heap no 303 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007706; asc w ;; Record lock, heap no 304 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007710; asc w ;; Record lock, heap no 305 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007711; asc w ;; Record lock, heap no 306 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007713; asc w ;; Record lock, heap no 307 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007719; asc w ;; Record lock, heap no 308 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007738; asc w8;; Record lock, heap no 309 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007739; asc w9;; Record lock, heap no 310 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000773a; asc w:;; Record lock, heap no 311 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000776a; asc wj;; Record lock, heap no 312 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000776f; asc wo;; Record lock, heap no 313 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007779; asc wy;; Record lock, heap no 314 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007782; asc w ;; Record lock, heap no 315 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007784; asc w ;; Record lock, heap no 316 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000778e; asc w ;; Record lock, heap no 317 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000778f; asc w ;; Record lock, heap no 318 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007791; asc w ;; Record lock, heap no 319 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007795; asc w ;; Record lock, heap no 320 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000779a; asc w ;; Record lock, heap no 321 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000779b; asc w ;; Record lock, heap no 322 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077b5; asc w ;; Record lock, heap no 323 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077b9; asc w ;; Record lock, heap no 324 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077ba; asc w ;; Record lock, heap no 325 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077bb; asc w ;; Record lock, heap no 326 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077bc; asc w ;; Record lock, heap no 327 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077be; asc w ;; Record lock, heap no 328 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077c4; asc w ;; Record lock, heap no 329 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077d0; asc w ;; Record lock, heap no 330 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077d3; asc w ;; Record lock, heap no 331 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077d4; asc w ;; Record lock, heap no 332 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077d6; asc w ;; Record lock, heap no 333 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077dd; asc w ;; Record lock, heap no 334 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077ed; asc w ;; Record lock, heap no 335 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077ee; asc w ;; Record lock, heap no 336 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077f5; asc w ;; Record lock, heap no 337 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077fb; asc w ;; Record lock, heap no 338 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800077ff; asc w ;; Record lock, heap no 339 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007805; asc x ;; Record lock, heap no 340 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007806; asc x ;; Record lock, heap no 341 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000780b; asc x ;; Record lock, heap no 342 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000781a; asc x ;; Record lock, heap no 343 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000781b; asc x ;; Record lock, heap no 344 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000781c; asc x ;; Record lock, heap no 345 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007820; asc x ;; Record lock, heap no 346 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007838; asc x8;; Record lock, heap no 347 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000783c; asc x<;; Record lock, heap no 348 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007848; asc xH;; Record lock, heap no 349 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007855; asc xU;; Record lock, heap no 350 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007856; asc xV;; Record lock, heap no 351 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007857; asc xW;; Record lock, heap no 352 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007858; asc xX;; Record lock, heap no 353 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007859; asc xY;; Record lock, heap no 354 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000785a; asc xZ;; Record lock, heap no 355 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000785b; asc x[;; Record lock, heap no 356 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007862; asc xb;; Record lock, heap no 357 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007864; asc xd;; Record lock, heap no 358 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007866; asc xf;; Record lock, heap no 359 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007867; asc xg;; Record lock, heap no 360 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007868; asc xh;; Record lock, heap no 361 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007872; asc xr;; Record lock, heap no 362 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007873; asc xs;; Record lock, heap no 363 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007874; asc xt;; Record lock, heap no 364 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007875; asc xu;; Record lock, heap no 365 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007876; asc xv;; Record lock, heap no 366 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007877; asc xw;; Record lock, heap no 367 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000787a; asc xz;; Record lock, heap no 368 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000787f; asc x ;; Record lock, heap no 369 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007888; asc x ;; Record lock, heap no 370 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000788b; asc x ;; Record lock, heap no 371 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800078cd; asc x ;; Record lock, heap no 372 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800078cf; asc x ;; Record lock, heap no 373 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800078d0; asc x ;; Record lock, heap no 374 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800078d1; asc x ;; Record lock, heap no 375 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800078d2; asc x ;; Record lock, heap no 376 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800078d7; asc x ;; Record lock, heap no 377 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800078ef; asc x ;; Record lock, heap no 378 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800078f4; asc x ;; Record lock, heap no 379 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800078f5; asc x ;; Record lock, heap no 380 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800078fa; asc x ;; Record lock, heap no 381 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007902; asc y ;; Record lock, heap no 382 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007903; asc y ;; Record lock, heap no 383 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007904; asc y ;; Record lock, heap no 384 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000790c; asc y ;; Record lock, heap no 385 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000790d; asc y ;; Record lock, heap no 386 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007924; asc y$;; Record lock, heap no 387 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007925; asc y%;; Record lock, heap no 388 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000793b; asc y;;; Record lock, heap no 389 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000793c; asc y<;; Record lock, heap no 390 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000793d; asc y=;; Record lock, heap no 391 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000793e; asc y>;; Record lock, heap no 392 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007940; asc y@;; Record lock, heap no 393 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007941; asc yA;; Record lock, heap no 394 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007942; asc yB;; Record lock, heap no 395 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007944; asc yD;; Record lock, heap no 396 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007945; asc yE;; Record lock, heap no 397 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007947; asc yG;; Record lock, heap no 398 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007954; asc yT;; Record lock, heap no 399 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007955; asc yU;; Record lock, heap no 400 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007956; asc yV;; Record lock, heap no 401 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007957; asc yW;; Record lock, heap no 402 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007958; asc yX;; Record lock, heap no 403 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007959; asc yY;; Record lock, heap no 404 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000795b; asc y[;; Record lock, heap no 405 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007988; asc y ;; Record lock, heap no 406 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000798a; asc y ;; Record lock, heap no 407 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 8000798b; asc y ;; Record lock, heap no 408 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007997; asc y ;; Record lock, heap no 409 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007999; asc y ;; Record lock, heap no 410 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800079ae; asc y ;; Record lock, heap no 411 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800079af; asc y ;; Record lock, heap no 412 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800079b1; asc y ;; Record lock, heap no 413 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800079b3; asc y ;; Record lock, heap no 414 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800079b8; asc y ;; Record lock, heap no 415 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800079b9; asc y ;; Record lock, heap no 416 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800079d0; asc y ;; Record lock, heap no 417 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800079d7; asc y ;; Record lock, heap no 418 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800079dc; asc y ;; Record lock, heap no 419 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 800079fc; asc y ;; Record lock, heap no 420 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a02; asc z ;; Record lock, heap no 421 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a03; asc z ;; Record lock, heap no 422 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a04; asc z ;; Record lock, heap no 423 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a0a; asc z ;; Record lock, heap no 424 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a0c; asc z ;; Record lock, heap no 425 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a16; asc z ;; Record lock, heap no 426 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a17; asc z ;; Record lock, heap no 427 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a18; asc z ;; Record lock, heap no 428 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a19; asc z ;; Record lock, heap no 429 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a1c; asc z ;; Record lock, heap no 430 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a1d; asc z ;; Record lock, heap no 431 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a1f; asc z ;; Record lock, heap no 432 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a20; asc z ;; Record lock, heap no 433 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a21; asc z!;; Record lock, heap no 434 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a23; asc z#;; Record lock, heap no 435 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a24; asc z$;; Record lock, heap no 436 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a26; asc z&;; Record lock, heap no 437 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a27; asc z';; Record lock, heap no 438 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a28; asc z(;; Record lock, heap no 439 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a31; asc z1;; Record lock, heap no 440 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a46; asc zF;; Record lock, heap no 441 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a47; asc zG;; Record lock, heap no 442 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a48; asc zH;; Record lock, heap no 443 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a49; asc zI;; Record lock, heap no 444 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a4a; asc zJ;; Record lock, heap no 445 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a56; asc zV;; Record lock, heap no 446 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a62; asc zb;; Record lock, heap no 447 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a63; asc zc;; Record lock, heap no 448 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a67; asc zg;; Record lock, heap no 449 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a6e; asc zn;; Record lock, heap no 450 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a6f; asc zo;; Record lock, heap no 451 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a70; asc zp;; Record lock, heap no 452 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a71; asc zq;; Record lock, heap no 453 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a72; asc zr;; Record lock, heap no 454 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a73; asc zs;; Record lock, heap no 455 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a74; asc zt;; Record lock, heap no 456 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a75; asc zu;; Record lock, heap no 457 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a76; asc zv;; Record lock, heap no 458 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a77; asc zw;; Record lock, heap no 459 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a7e; asc z~;; Record lock, heap no 460 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a7f; asc z ;; Record lock, heap no 461 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a80; asc z ;; Record lock, heap no 462 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a83; asc z ;; Record lock, heap no 463 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a84; asc z ;; Record lock, heap no 464 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a87; asc z ;; Record lock, heap no 465 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a88; asc z ;; Record lock, heap no 466 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a89; asc z ;; Record lock, heap no 467 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a8b; asc z ;; Record lock, heap no 468 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a99; asc z ;; Record lock, heap no 469 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a9a; asc z ;; Record lock, heap no 470 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a9b; asc z ;; Record lock, heap no 471 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a9c; asc z ;; Record lock, heap no 472 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a9d; asc z ;; Record lock, heap no 473 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a9e; asc z ;; Record lock, heap no 474 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007a9f; asc z ;; Record lock, heap no 475 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007aa0; asc z ;; Record lock, heap no 476 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007aa1; asc z ;; Record lock, heap no 477 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007aa2; asc z ;; Record lock, heap no 478 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007aa3; asc z ;; Record lock, heap no 479 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007aa4; asc z ;; Record lock, heap no 480 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007aa5; asc z ;; Record lock, heap no 481 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007aa6; asc z ;; Record lock, heap no 482 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007aa7; asc z ;; Record lock, heap no 483 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007aaf; asc z ;; Record lock, heap no 484 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007ab4; asc z ;; Record lock, heap no 485 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007ab6; asc z ;; Record lock, heap no 486 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007ab7; asc z ;; Record lock, heap no 487 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007abd; asc z ;; Record lock, heap no 488 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007abe; asc z ;; Record lock, heap no 489 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007abf; asc z ;; Record lock, heap no 490 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007ac0; asc z ;; Record lock, heap no 491 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007ac1; asc z ;; Record lock, heap no 492 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007ac2; asc z ;; Record lock, heap no 493 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007ac3; asc z ;; Record lock, heap no 494 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007ac6; asc z ;; Record lock, heap no 495 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007ad7; asc z ;; Record lock, heap no 496 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007adb; asc z ;; Record lock, heap no 497 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007adc; asc z ;; Record lock, heap no 498 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b07; asc { ;; Record lock, heap no 499 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b08; asc { ;; Record lock, heap no 500 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b09; asc { ;; Record lock, heap no 501 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b11; asc { ;; Record lock, heap no 502 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b12; asc { ;; Record lock, heap no 503 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b13; asc { ;; Record lock, heap no 504 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b14; asc { ;; Record lock, heap no 505 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b15; asc { ;; Record lock, heap no 506 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b16; asc { ;; Record lock, heap no 507 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b17; asc { ;; Record lock, heap no 508 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b18; asc { ;; Record lock, heap no 509 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b19; asc { ;; Record lock, heap no 510 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b1a; asc { ;; Record lock, heap no 511 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b1b; asc { ;; Record lock, heap no 512 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b1c; asc { ;; Record lock, heap no 513 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b1d; asc { ;; Record lock, heap no 514 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b1e; asc { ;; Record lock, heap no 515 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b1f; asc { ;; Record lock, heap no 516 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b20; asc { ;; Record lock, heap no 517 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b21; asc {!;; Record lock, heap no 518 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b22; asc {";; Record lock, heap no 519 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b23; asc {#;; Record lock, heap no 520 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b24; asc {$;; Record lock, heap no 521 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b25; asc {%;; Record lock, heap no 522 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b26; asc {&;; Record lock, heap no 523 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b27; asc {';; Record lock, heap no 524 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b29; asc {);; Record lock, heap no 525 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b2a; asc {*;; Record lock, heap no 526 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b2b; asc {+;; Record lock, heap no 527 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b2c; asc {,;; Record lock, heap no 528 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b2d; asc {-;; Record lock, heap no 529 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b2f; asc {/;; Record lock, heap no 530 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b3d; asc {=;; Record lock, heap no 531 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b4d; asc {M;; Record lock, heap no 532 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b51; asc {Q;; Record lock, heap no 533 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b52; asc {R;; Record lock, heap no 534 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b55; asc {U;; Record lock, heap no 535 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b5b; asc {[;; Record lock, heap no 536 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b5c; asc {\\;; Record lock, heap no 537 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b5d; asc {];; Record lock, heap no 538 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b5e; asc {^;; Record lock, heap no 539 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b5f; asc {_;; Record lock, heap no 540 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b63; asc {c;; Record lock, heap no 541 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b64; asc {d;; Record lock, heap no 542 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b65; asc {e;; Record lock, heap no 543 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b7c; asc {|;; Record lock, heap no 544 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b7d; asc {};; Record lock, heap no 545 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b7e; asc {~;; Record lock, heap no 546 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b7f; asc { ;; Record lock, heap no 547 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b80; asc { ;; Record lock, heap no 548 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b81; asc { ;; Record lock, heap no 549 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b82; asc { ;; Record lock, heap no 550 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b83; asc { ;; Record lock, heap no 551 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b84; asc { ;; Record lock, heap no 552 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b85; asc { ;; Record lock, heap no 553 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b86; asc { ;; Record lock, heap no 554 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b87; asc { ;; Record lock, heap no 555 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b89; asc { ;; Record lock, heap no 556 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b8a; asc { ;; Record lock, heap no 557 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b8b; asc { ;; Record lock, heap no 558 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b8c; asc { ;; Record lock, heap no 559 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b8d; asc { ;; Record lock, heap no 560 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b8e; asc { ;; Record lock, heap no 561 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b8f; asc { ;; Record lock, heap no 562 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b90; asc { ;; Record lock, heap no 563 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b91; asc { ;; Record lock, heap no 564 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b92; asc { ;; Record lock, heap no 565 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007b94; asc { ;; Record lock, heap no 566 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007ba3; asc { ;; Record lock, heap no 567 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007baa; asc { ;; Record lock, heap no 568 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bab; asc { ;; Record lock, heap no 569 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bac; asc { ;; Record lock, heap no 570 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bad; asc { ;; Record lock, heap no 571 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bae; asc { ;; Record lock, heap no 572 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007baf; asc { ;; Record lock, heap no 573 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bb0; asc { ;; Record lock, heap no 574 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bb1; asc { ;; Record lock, heap no 575 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bb2; asc { ;; Record lock, heap no 576 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bb3; asc { ;; Record lock, heap no 577 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bb4; asc { ;; Record lock, heap no 578 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bb5; asc { ;; Record lock, heap no 579 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bb6; asc { ;; Record lock, heap no 580 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bb7; asc { ;; Record lock, heap no 581 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bc1; asc { ;; Record lock, heap no 582 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bca; asc { ;; Record lock, heap no 583 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bcb; asc { ;; Record lock, heap no 585 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bd3; asc { ;; Record lock, heap no 586 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bdb; asc { ;; Record lock, heap no 587 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bdc; asc { ;; Record lock, heap no 588 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007be1; asc { ;; Record lock, heap no 589 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007be2; asc { ;; Record lock, heap no 590 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007be3; asc { ;; Record lock, heap no 591 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007beb; asc { ;; Record lock, heap no 592 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bec; asc { ;; Record lock, heap no 593 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bed; asc { ;; Record lock, heap no 594 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bee; asc { ;; Record lock, heap no 595 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bf0; asc { ;; Record lock, heap no 596 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bf1; asc { ;; Record lock, heap no 597 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bf2; asc { ;; Record lock, heap no 598 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bf5; asc { ;; Record lock, heap no 599 PHYSICAL RECORD: n_fields 2; compact format; info bits 0 0: len 4; hex 800057cb; asc W ;; 1: len 4; hex 80007bfa; asc { ;; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 20627 page no 482 n bits 128 index PRIMARY of table `ltcare`.`family_app_counsel` trx id 54548046471 lock_mode X locks rec but not gap waiting Record lock, heap no 5 PHYSICAL RECORD: n_fields 18; compact format; info bits 0 0: len 4; hex 80007ea8; asc ~ ;; 1: len 6; hex 000000000000; asc ;; 2: len 7; hex 80000000000000; asc ;; 3: len 4; hex 800057cb; asc W ;; 4: len 4; hex 8000856f; asc o;; 5: len 1; hex 32; asc 2;; 6: len 14; hex 3230323330313133313635343434; asc 20230113165444;; 7: len 30; hex eca080ed9dacebb680ebaaa8eb8b9820eab099ec9db420ec82aceca78420; asc ; (total 68 bytes); 8: len 1; hex 31; asc 1;; 9: len 4; hex 80000000; asc ;; 10: len 0; hex ; asc ;; 11: len 0; hex ; asc ;; 12: len 14; hex 3230323330313133313635373332; asc 20230113165732;; 13: len 4; hex 800849fa; asc I ;; 14: len 9; hex eab980eca095ed9884; asc ;; 15: len 15; hex ec82aced9a8cebb3b5eca780ec82ac; asc ;; 16: len 5; hex 99af1b0dad; asc ;; 17: len 5; hex 99af1b0e60; asc `;; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 54548046792 Purge done for trx's n:o < 54548045460 undo n:o < 0 state: running History list length 574 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 54548046791, ACTIVE 0 sec 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299573912, not started returning various info to MariaDB mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299611856, ACTIVE 0 sec starting index read mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291486004, OS thread handle 139929790473984, query id 113825687639 58.76.184.36 ltcare Statistics SELECT * FROM center_service_time WHERE ctmfkey = '42193' ---TRANSACTION 422075298954160, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299489592, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299342032, not started returning various info to MariaDB mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299299872, not started returning various info to MariaDB mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299283008, not started returning various info to MariaDB mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299274576, not started returning various info to MariaDB mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298722280, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298810816, not started returning various info to MariaDB mysql tables in use 61, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299603424, ACTIVE 0 sec mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291486007, OS thread handle 139938808559360, query id 113825687469 58.76.184.38 ltcare Creating sort index SELECT * , (SELECT COUNT(*) FROM patient_master pam LEFT JOIN patient_state_history psh \t\t ON psh.pshmgno = (SELECT temp_psh.pshmgno \t\t \t\t\t\t\t FROM patient_state_history temp_psh \t\t \t\t\t\t\tWHERE temp_psh.ctmfkey = pam.ctmfkey \t\t \t\t\t\t\t AND temp_psh.pamfkey = pam.pammgno \t\t \t\t\t\t\t AND temp_psh.pshdate <= date_format(now(), '%Y%m%d') \t\t \t\t\t\t\tORDER BY temp_ps Trx read view will not see trx with id >= 54548046791, sees < 54548046302 ---TRANSACTION 422075299599208, ACTIVE 0 sec mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291486009, OS thread handle 139938812245760, query id 113825687455 58.76.184.38 ltcare Unlocking tables SELECT nummgno FROM nursing_master WHERE ctmfkey = '3436' AND pamfkey = '149365' ---TRANSACTION 422075299594992, ACTIVE 0 sec starting index read mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291486008, OS thread handle 139939163191040, query id 113825687443 58.76.184.38 ltcare Statistics SELECT a.* , IFNULL(ssh.sshstat, '1') sshstat , IFNULL( (SELECT sjhkind FROM staff_job_history WHERE stmfkey = a.stmmgno AND sjhdate<=DATE_FORMAT( NOW(), '%Y%m%d' ) ORDER BY sjhdate DESC, sjhmgno DESC LIMIT 1) , a.stmjknd ) stmjknd FROM staff_master a LEFT JOIN staff_state_history ssh ON ssh.sshmgno = ( SELECT temp_ssh.sshmgno FROM staff_state_histor Trx read view will not see trx with id >= 54548046792, sees < 54548046302 ---TRANSACTION 422075299569696, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299565480, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299544400, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299527536, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299506456, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299295656, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299046912, ACTIVE 0 sec fetching rows mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291486005, OS thread handle 139932429838080, query id 113825687365 58.76.184.38 ltcare Creating sort index SELECT * , (SELECT COUNT(*) FROM patient_master pam LEFT JOIN patient_state_history psh \t\t ON psh.pshmgno = (SELECT temp_psh.pshmgno \t\t \t\t\t\t\t FROM patient_state_history temp_psh \t\t \t\t\t\t\tWHERE temp_psh.ctmfkey = pam.ctmfkey \t\t \t\t\t\t\t AND temp_psh.pamfkey = pam.pammgno \t\t \t\t\t\t\t AND temp_psh.pshdate <= date_format(now(), '%Y%m%d') \t\t \t\t\t\t\tORDER BY temp_ps Trx read view will not see trx with id >= 54548046791, sees < 54548046302 ---TRANSACTION 422075298667472, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299034264, ACTIVE 0 sec fetching rows mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291486000, OS thread handle 139938896205568, query id 113825687287 58.76.184.36 ltcare Creating sort index SELECT * , (SELECT COUNT(*) FROM patient_master pam LEFT JOIN patient_state_history psh \t\t ON psh.pshmgno = (SELECT temp_psh.pshmgno \t\t \t\t\t\t\t FROM patient_state_history temp_psh \t\t \t\t\t\t\tWHERE temp_psh.ctmfkey = pam.ctmfkey \t\t \t\t\t\t\t AND temp_psh.pamfkey = pam.pammgno \t\t \t\t\t\t\t AND temp_psh.pshdate <= date_format(now(), '%Y%m%d') \t\t \t\t\t\t\tORDER BY temp_ps Trx read view will not see trx with id >= 54548046775, sees < 54548046302 ---TRANSACTION 422075298785520, ACTIVE 0 sec starting index read mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485996, OS thread handle 139938796885760, query id 113825687659 58.76.184.36 ltcare Sending data SELECT COUNT(*) FROM patient_out pao LEFT JOIN patient_discharge pad ON pad.ctmfkey = pao.ctmfkey AND pad.pamfkey = pao.pamfkey AND pad.padotdt = pao.paotodt AND pad.padottm = CONCAT( pao.paotoht, pao.paotomt ) AND pad.padotap = 'Y' AND pao.paogubn = '2' WHERE pao.ctmfkey = '8741' AND pao.pamfkey = '825969' ---TRANSACTION 422075299173392, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485976, OS thread handle 139938915866368, query id 113825687183 58.76.184.38 ltcare Statistics SELECT a.* , IF(prmtype = 'P', pgm.pgmname, a.pgmname) pgmname , IF(prmtype = 'P', psc.pscmgno, a.pscfkey) pscfkey , IF(prmtype = 'P', psc.pscname, a.prmpscn) prmpscn , IF(prmtype = 'P', psc.psckdcd, a.psckdcd) psckdcd , IF(prmtype = 'P', prl.prlname, a.prmprln) prmprln , CASE WHEN a.stmgubn = 'S' THEN (SELECT stmsign FROM staff_master x WHERE x.ctmfkey = a.ctmfkey AND x.stmmgno = a.stmfkey) Trx read view will not see trx with id >= 54548046779, sees < 54548046302 ---TRANSACTION 422075299392624, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 37, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485983, OS thread handle 139938816546560, query id 113825687131 58.76.184.36 ltcare Statistics SELECT * , IF(LENGTH(ctmregn) = 10 AND ctmpbrn = ctmregn AND LENGTH(ctmpbid) > 0, '1','0') AS popbill_use , (SELECT COUNT(*) FROM center_care_group WHERE ctmfkey = a.ctmmgno) care_group_count , (SELECT rsmfkey FROM reseller_center_map WHERE ctmfkey = a.ctmmgno) rsmfkey , (SELECT rcmstat FROM reseller_center_map WHERE ctmfkey = a.ctmmgno) rcmstat , (SELECT stmname FROM staff_master WHERE stmmgno = cta.stmfky2) stmnam2 , (SELECT stmname FROM staff_ Trx read view will not see trx with id >= 54548046775, sees < 54548046302 ---TRANSACTION 422075299084856, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299245064, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299443216, not started returning various info to MariaDB mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299430568, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298650608, not started returning various info to MariaDB mysql tables in use 95, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299422136, not started returning various info to MariaDB mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299388408, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299118584, ACTIVE 0 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485982, OS thread handle 139929714759424, query id 113825686599 58.76.184.38 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046768, sees < 54548046302 ---TRANSACTION 422075298633744, ACTIVE 0 sec mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485978, OS thread handle 139932445198080, query id 113825686781 58.76.184.38 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046775, sees < 54548046302 ---TRANSACTION 422075299067992, not started returning various info to MariaDB mysql tables in use 13, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298718064, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299105936, ACTIVE 0 sec fetching rows mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485968, OS thread handle 139937418151680, query id 113825687548 58.76.184.36 ltcare Creating sort index SELECT * FROM send_notice_history a LEFT JOIN patient_consult b ON b.ctmfkey = a.ctmfkey AND b.pamfkey = a.pamfkey AND b.snhfkey = a.snhmgno WHERE a.ctmfkey = '10241' AND a.snlfkey = 'SVCSUPY' AND FIND_IN_SET('655404', doclist) ORDER BY a.snhmgno DESC Trx read view will not see trx with id >= 54548046792, sees < 54548046302 ---TRANSACTION 422075299379976, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299261928, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299186040, ACTIVE 0 sec starting index read mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485889, OS thread handle 139932212053760, query id 113825687524 58.76.184.34 ltcare Sending data SELECT a.* , (SELECT COUNT(*) FROM center_room x, patient_room_history y, patient_master z WHERE x.ctmfkey = y.ctmfkey AND y.ctmfkey = a.ctmfkey AND x.ctrmgno = y.ctrfkey AND x.ctbfkey = a.ctbmgno AND y.ctmfkey = z.ctmfkey AND y.pamfkey = z.pammgno) AS used_history_count -- 2022/03/07 윤관석 : 고도화 전 건물목록 조회에 있던 조회내용임, 건물목록에 나오던 정보 -- (SELECT COUNT(*) -- FROM center_room -- WHERE ctbfkey = ctbmgno) ro Trx read view will not see trx with id >= 54548046785, sees < 54548046302 ---TRANSACTION 422075299337816, not started returning various info to MariaDB mysql tables in use 15, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299160744, ACTIVE 0 sec fetching rows mysql tables in use 72, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485969, OS thread handle 139938809480960, query id 113825686349 58.76.184.36 ltcare Sending data SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230412' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046764, sees < 54548046302 ---TRANSACTION 422075299316736, not started returning various info to MariaDB mysql tables in use 79, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298907784, ACTIVE 0 sec fetching rows mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485965, OS thread handle 139939167491840, query id 113825685739 58.76.184.36 ltcare Creating sort index SELECT * , (SELECT COUNT(*) FROM patient_master pam LEFT JOIN patient_state_history psh \t\t ON psh.pshmgno = (SELECT temp_psh.pshmgno \t\t \t\t\t\t\t FROM patient_state_history temp_psh \t\t \t\t\t\t\tWHERE temp_psh.ctmfkey = pam.ctmfkey \t\t \t\t\t\t\t AND temp_psh.pamfkey = pam.pammgno \t\t \t\t\t\t\t AND temp_psh.pshdate <= date_format(now(), '%Y%m%d') \t\t \t\t\t\t\tORDER BY temp_ps Trx read view will not see trx with id >= 54548046754, sees < 54548046302 ---TRANSACTION 422075298924648, ACTIVE 0 sec starting index read mysql tables in use 69, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485961, OS thread handle 139932274525952, query id 113825685550 58.76.184.36 ltcare Sending data SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230412' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046757, sees < 54548046302 ---TRANSACTION 422075298629528, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298659040, not started returning various info to MariaDB mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299346248, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299076424, ACTIVE 0 sec mysql tables in use 95, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485924, OS thread handle 139938893440768, query id 113825685629 58.76.184.36 ltcare Creating sort index WITH date_range AS ( SELECT yyyymmdd FROM date_range WHERE yyyymmdd BETWEEN '20230410' AND '20230416' ) , pam_list AS ( SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(pl.mr, ',', copy_num.num), ',', -1) pammgno FROM copy_num INNER JOIN (SELECT '83726' mr FROM DUAL) pl ON CHAR_LENGTH(pl.mr)-CHAR_LENGTH(REPLACE(pl.mr, ',', ''))>=copy_num.num-1 Trx read view will not see trx with id >= 54548046770, sees < 54548046302 ---TRANSACTION 422075298983672, not started returning various info to MariaDB mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298756008, ACTIVE 0 sec mysql tables in use 70, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485931, OS thread handle 139938906343168, query id 113825685577 58.76.184.38 ltcare Executing SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230412' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046758, sees < 54548046302 ---TRANSACTION 422075298600016, ACTIVE 0 sec fetching rows mysql tables in use 26, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485941, OS thread handle 139938781832960, query id 113825684673 58.76.184.36 ltcare Sending data SELECT stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.stmmgno <> staff_master.stmmgno A Trx read view will not see trx with id >= 54548046756, sees < 54548046302 ---TRANSACTION 422075298578936, ACTIVE 0 sec mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485943, OS thread handle 139939163498240, query id 113825687099 58.76.184.38 ltcare Sending data SELECT t.* , remain_cnt - IFNULL(r_sayvcnt, 0) AS final_remain_cnt FROM ( SELECT s.* , SUM( IFNULL( s.vcnt, 0 ) - IFNULL( s.ucnt, 0 ) ) OVER(PARTITION BY s.stmmgno, s.year ORDER BY s.month) AS remain_cnt , SUM( sayvcnt ) OVER(PARTITION BY s.stmmgno, s.year ORDER BY s.month) AS r_sayvcnt FROM ( SELECT a.* Trx read view will not see trx with id >= 54548046775, sees < 54548046302 ---TRANSACTION 422075298971024, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298949944, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298890920, ACTIVE 0 sec mysql tables in use 68, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485935, OS thread handle 139932302481152, query id 113825684860 58.76.184.36 ltcare Executing SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230412' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046754, sees < 54548046302 ---TRANSACTION 54548046779, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 1, locked 0 4 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 3291485934, OS thread handle 139939162269440, query id 113825687586 58.76.184.36 ltcare Statistics SELECT * FROM center_service_time WHERE ctmfkey = '10729' ---TRANSACTION 422075299190256, ACTIVE 0 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485930, OS thread handle 139938907571968, query id 113825686714 58.76.184.38 ltcare Sending data SELECT SUM( IF( SUBSTR( x.yyyymmdd, 1, 6 ) = '202305' AND x.date_s IS NULL AND x.day_s NOT IN('5', '6'), 1, 0 ) * 8 ) AS gijun_time , SUM( IF( x.date_s IS NOT NULL AND ( x.yyyymmdd = '' OR x.yyyymmdd = '' ), 1, 0 ) ) AS carryable FROM ( SELECT * , DATE_FORMAT( DATE_ADD(a.yyyymmdd, INTERVAL 1 day), '%Y%m%d' ) AS date_n , WEEKDAY( a.yyyymmdd ) AS day_s , WEEKDAY( DATE_FORMAT( DATE_ADD(a.yyyymmd Trx read view will not see trx with id >= 54548046764, sees < 54548046302 ---TRANSACTION 422075298865624, not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298831896, ACTIVE 0 sec fetching rows mysql tables in use 74, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485928, OS thread handle 139938916480768, query id 113825685506 58.76.184.38 ltcare Sending data SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230412' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046760, sees < 54548046302 ---TRANSACTION 422075299561264, not started returning various info to MariaDB mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299557048, not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 54548046770, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 2, locked 0 5 lock struct(s), heap size 1128, 7 row lock(s), undo log entries 5 MySQL thread id 3291485922, OS thread handle 139938809173760, query id 113825687581 58.76.184.38 ltcare Statistics SELECT pamname, pammgno FROM patient_master a , nursing_master b WHERE a.ctmfkey = b.ctmfkey AND a.pammgno = b.pamfkey AND a.ctmfkey = '42181' AND b.nummgno = '800667' ---TRANSACTION 422075299207120, ACTIVE 0 sec mysql tables in use 58, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485916, OS thread handle 139932378535680, query id 113825685790 58.76.184.38 ltcare Executing SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230412' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046758, sees < 54548046302 ---TRANSACTION 422075299139664, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 55, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485891, OS thread handle 139932206216960, query id 113825687077 58.76.184.38 ltcare Statistics SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230412' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046775, sees < 54548046302 ---TRANSACTION 422075299131232, not started returning various info to MariaDB mysql tables in use 8, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 54548046738, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 1, locked 0 7 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 1 MySQL thread id 3291485903, OS thread handle 139937477441280, query id 113825687553 58.76.184.38 ltcare Statistics WITH p AS ( SELECT '20230412' AS prmdate , '1040' AS prmfrtm , '1140' AS prmtotm , '22069' AS ctmfkey , '740397' AS pamfkey FROM DUAL ) SELECT twkampn , twksttm , twkentm , ROUND( TIMESTAMPDIFF( MINUTE, TIMEST Trx read view will not see trx with id >= 54548046744, sees < 54548046302 ---TRANSACTION 422075299540184, ACTIVE 0 sec fetching rows mysql tables in use 51, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485917, OS thread handle 139938783676160, query id 113825684867 58.76.184.36 ltcare Sending data SELECT DISTINCT tdh.y_flag , ( SELECT COUNT(*) FROM care_contents WHERE camfkey = (SELECT cammgno FROM care_master WHERE pamfkey = patient_master.pammgno AND ctmfkey = patient_master.ctmfkey) AND care_contents.cacdate = '20230412' AND care_contents.cacname REGEXP ('^cts[1-3]') ) carecnt , ( SELECT IF(cdspsn1 <> '',cdspsn1,cdspsn2) FROM care_daily_service, care_master WHERE camfkey = cammgno and pamfkey = pammgno AND care_master.ctmfkey = patient_master Trx read view will not see trx with id >= 54548046749, sees < 54548046302 ---TRANSACTION 422075299523320, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299498024, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299439000, ACTIVE 0 sec starting index read mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485905, OS thread handle 139932368869120, query id 113825687669 58.76.184.38 ltcare Sending data SELECT * FROM care_toilet_diaper_record WHERE camfkey = '640692' AND ctrdate = '20230403' ORDER BY ctrtime ---TRANSACTION 54548046772, ACTIVE 0 sec mysql tables in use 1, locked 0 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1 MySQL thread id 3291485907, OS thread handle 139938902963968, query id 113825687378 58.76.184.36 ltcare Creating sort index SELECT * FROM patient_out WHERE ctmfkey = '20903' AND pamfkey = '655210' AND ('202304121606' BETWEEN CONCAT(paofrdt, paofrht, paofrmt) AND CONCAT(IF(paotodt = '', '99991231', paotodt) , IF(paotoht = '', '23', paotoht) , IF(paotomt = '', '59', paotomt))) ORDER BY paomgno DESC LIMIT 1 ---TRANSACTION 422075299219768, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299059560, not started getting list of referencing foreign keys 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 54548046768, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 37, locked 0 6 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 2 MySQL thread id 3291485896, OS thread handle 139932311422720, query id 113825687349 58.76.184.36 ltcare Statistics SELECT * , IF(LENGTH(ctmregn) = 10 AND ctmpbrn = ctmregn AND LENGTH(ctmpbid) > 0, '1','0') AS popbill_use , (SELECT COUNT(*) FROM center_care_group WHERE ctmfkey = a.ctmmgno) care_group_count , (SELECT rsmfkey FROM reseller_center_map WHERE ctmfkey = a.ctmmgno) rsmfkey , (SELECT rcmstat FROM reseller_center_map WHERE ctmfkey = a.ctmmgno) rcmstat , (SELECT stmname FROM staff_master WHERE stmmgno = cta.stmfky2) stmnam2 , (SELECT stmname FROM staff_ Trx read view will not see trx with id >= 54548046771, sees < 54548046302 ---TRANSACTION 422075299401056, not started returning various info to MariaDB mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299396840, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299384192, not started returning various info to MariaDB mysql tables in use 5, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299013184, not started returning various info to MariaDB mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299375760, ACTIVE 0 sec mysql tables in use 17, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485898, OS thread handle 139938790160128, query id 113825682908 58.76.184.36 ltcare Sending data WITH a AS ( SELECT * FROM program_group_master WHERE ctmfkey = '4019' AND pgmmgno = '11634' ) SELECT pam.* , pam.pammgno AS pamfkey , pln.chpmgno, pln.ctmfkey, pln.stmfkey, pln.pgmfkey, pln.chpsldt , pmo.paofrdt, pmo.paotodt, pmo.paohoyn, pmo.paomgno -- 외박 , pmos.* -- 외출 Trx read view will not see trx with id >= 54548046709, sees < 54548046302 ---TRANSACTION 422075299164960, not started returning various info to MariaDB mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 54548046739, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 4, locked 0 7 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 6 MySQL thread id 3291485884, OS thread handle 139932382836480, query id 113825687423 58.76.184.36 ltcare Statistics SELECT *, (SELECT stmname FROM staff_master WHERE stmmgno = camcsk0) camcsn0, (SELECT stmname FROM staff_master WHERE stmmgno = camcsk1) camcsn1, (SELECT stmname FROM staff_master WHERE stmmgno = camcsk2) camcsn2 FROM care_master WHERE ctmfkey = '7325' AND pamfkey = '564698' Trx read view will not see trx with id >= 54548046741, sees < 54548046302 ---TRANSACTION 422075299051128, not started returning various info to MariaDB mysql tables in use 7, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299253496, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 11, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485894, OS thread handle 139938810095360, query id 113825687202 58.76.184.36 ltcare Statistics SELECT * -- , (SELECT stmmgno FROM staff_master WHERE stmmgno = carwtsk) carwtsk -- , (SELECT stmmgno FROM staff_master WHERE stmmgno = carwts2) carwts2 , CASE WHEN carwgbn = 'S' THEN (SELECT stmmgno FROM staff_master WHERE stmmgno = carwtsk) WHEN carwgbn = 'V' THEN (SELECT svmmgno FROM staff_volunteer_manage WHERE svmmgno = carwtsk) ELSE carwtsk END AS carwtsk , CASE WHEN carwgb2 = 'S' THEN (SELECT stmmgn Trx read view will not see trx with id >= 54548046776, sees < 54548046302 ---TRANSACTION 422075299270360, ACTIVE 0 sec mysql tables in use 56, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485888, OS thread handle 139938793813760, query id 113825686653 58.76.184.36 ltcare Executing SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230412' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046768, sees < 54548046302 ---TRANSACTION 422075299169176, not started returning various info to MariaDB mysql tables in use 7, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299148096, ACTIVE 0 sec mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485881, OS thread handle 139938905114368, query id 113825682808 58.76.184.36 ltcare Sending data SELECT SUM( IF( SUBSTR( x.yyyymmdd, 1, 6 ) = '202209' AND x.date_s IS NULL AND x.day_s NOT IN('5', '6'), 1, 0 ) * 8 ) AS gijun_time , SUM( IF( x.date_s IS NOT NULL AND ( x.yyyymmdd = '20220929' OR x.yyyymmdd = '' ), 1, 0 ) ) AS carryable FROM ( SELECT * , DATE_FORMAT( DATE_ADD(a.yyyymmdd, INTERVAL 1 day), '%Y%m%d' ) AS date_n , WEEKDAY( a.yyyymmdd ) AS day_s , WEEKDAY( DATE_FORMAT( DATE_ADD(a Trx read view will not see trx with id >= 54548046707, sees < 54548046302 ---TRANSACTION 422075299177608, not started returning various info to MariaDB mysql tables in use 67, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298848760, not started returning various info to MariaDB mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299232416, ACTIVE 0 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485855, OS thread handle 139938786166528, query id 113825681188 58.76.184.36 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046696, sees < 54548046302 ---TRANSACTION 54548046773, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 1, locked 0 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1 MySQL thread id 3291485858, OS thread handle 139938814088960, query id 113825687500 58.76.184.36 ltcare Statistics SELECT COUNT(*) FROM staff_master WHERE ctmfkey = '3933' AND stmmgno = '91901' Trx read view will not see trx with id >= 54548046776, sees < 54548046302 ---TRANSACTION 422075298912000, ACTIVE 0 sec mysql tables in use 75, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485856, OS thread handle 139938807023360, query id 113825683684 58.76.184.34 ltcare Sending data SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230412' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046731, sees < 54548046302 ---TRANSACTION 422075298869840, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 74, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485847, OS thread handle 139931467888384, query id 113825686801 58.76.184.36 ltcare Creating sort index SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230410' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230410' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230410' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046775, sees < 54548046302 ---TRANSACTION 54548046713, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 1, locked 0 12 lock struct(s), heap size 1128, 9 row lock(s), undo log entries 5 MySQL thread id 3291485850, OS thread handle 139938819311360, query id 113825687682 58.76.184.38 ltcare Statistics SELECT * FROM transport_work WHERE ctmfkey = '20992' AND twkmgno = '89965845' Trx read view will not see trx with id >= 54548046718, sees < 54548046302 ---TRANSACTION 422075299030048, not started mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298751792, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298958376, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 54548046692, ACTIVE 0 sec 11 lock struct(s), heap size 1128, 6 row lock(s), undo log entries 2 MySQL thread id 3291485849, OS thread handle 139932253218560, query id 113825687700 58.76.184.38 ltcare Init SELECT * FROM patient_out WHERE ctmfkey = '6779' AND pamfkey = '526511' AND paotwkk = '93352108' ORDER BY paofrdt, paofrht, paofrmt, paotodt, paotoht, paotomt Trx read view will not see trx with id >= 54548046702, sees < 54548046302 ---TRANSACTION 422075299198688, not started returning various info to MariaDB mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299519104, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485844, OS thread handle 139938784597760, query id 113825687453 58.76.184.38 ltcare Statistics SELECT *, (SELECT stmname FROM staff_master WHERE stmmgno = camcsk0) camcsn0, (SELECT stmname FROM staff_master WHERE stmmgno = camcsk1) camcsn1, (SELECT stmname FROM staff_master WHERE stmmgno = camcsk2) camcsn2 FROM care_master WHERE ctmfkey = '1605' AND pamfkey = '806465' Trx read view will not see trx with id >= 54548046785, sees < 54548046302 ---TRANSACTION 422075299502240, not started returning various info to MariaDB mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 54548046719, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 37, locked 0 6 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 6 MySQL thread id 3291485837, OS thread handle 139933782152960, query id 113825687218 58.76.184.38 ltcare Statistics SELECT * , IF(LENGTH(ctmregn) = 10 AND ctmpbrn = ctmregn AND LENGTH(ctmpbid) > 0, '1','0') AS popbill_use , (SELECT COUNT(*) FROM center_care_group WHERE ctmfkey = a.ctmmgno) care_group_count , (SELECT rsmfkey FROM reseller_center_map WHERE ctmfkey = a.ctmmgno) rsmfkey , (SELECT rcmstat FROM reseller_center_map WHERE ctmfkey = a.ctmmgno) rcmstat , (SELECT stmname FROM staff_master WHERE stmmgno = cta.stmfky2) stmnam2 , (SELECT stmname FROM staff_ Trx read view will not see trx with id >= 54548046720, sees < 54548046302 ---TRANSACTION 422075298684336, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299287224, not started returning various info to MariaDB mysql tables in use 7, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298743360, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 94, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485835, OS thread handle 140599983843072, query id 113825686878 58.76.184.36 ltcare Statistics WITH date_range AS ( SELECT yyyymmdd FROM date_range WHERE yyyymmdd BETWEEN '20230412' AND '20230412' ) , pam_list AS ( SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(pl.mr, ',', copy_num.num), ',', -1) pammgno FROM copy_num INNER JOIN (SELECT '785007' mr FROM DUAL) pl ON CHAR_LENGTH(pl.mr)-CHAR_LENGTH(REPLACE(pl.mr, ',', ''))>=copy_num.num-1 Trx read view will not see trx with id >= 54548046785, sees < 54548046302 ---TRANSACTION 422075299223984, ACTIVE 0 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485825, OS thread handle 139931477411584, query id 113825679798 58.76.184.38 ltcare Creating sort index SELECT dppmgno, ctmfkey, dpp_tbl, dpp_txt, dpptkey, dppgubn, dppname, dpppkey, dppknd1, dppknd2, dppsidt, dppptxt , IF( dppmtel <> '' , dppmtel , CASE WHEN dppgubn = 'S' THEN (SELECT stmmtel FROM staff_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.stmmgno = document_people.dpppkey) WHEN dppgubn = 'P' THEN (SELECT pammtel FROM patient_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.pammgno = document_people.dpppkey) W Trx read view will not see trx with id >= 54548046669, sees < 54548046302 ---TRANSACTION 422075299093288, not started mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299063776, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 28, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485824, OS thread handle 139938811324160, query id 113825687223 58.76.184.38 ltcare Statistics WITH date_range AS ( SELECT yyyymmdd FROM date_range WHERE yyyymmdd BETWEEN '20230412' AND '20230412' ) , pam_list AS ( SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(pl.mr, ',', copy_num.num), ',', -1) pammgno FROM copy_num INNER JOIN (SELECT '746385' mr FROM DUAL) pl ON CHAR_LENGTH(pl.mr)-CHAR_LENGTH(REPLACE(pl.mr, ',', ''))>=copy_num.num-1 Trx read view will not see trx with id >= 54548046776, sees < 54548046302 ---TRANSACTION 422075298701200, not started returning various info to MariaDB mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 54548046702, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 1, locked 0 7 lock struct(s), heap size 1128, 8 row lock(s), undo log entries 8 MySQL thread id 3291485818, OS thread handle 139933749491456, query id 113825687433 58.76.184.36 ltcare Statistics SELECT * FROM center_service_time WHERE ctmfkey = '3537' Trx read view will not see trx with id >= 54548046703, sees < 54548046302 ---TRANSACTION 422075299097504, ACTIVE 0 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485814, OS thread handle 139933280757504, query id 113825680409 58.76.184.38 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046685, sees < 54548046302 ---TRANSACTION 422075298979456, not started returning various info to MariaDB mysql tables in use 5, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298903568, not started mysql tables in use 76, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298916216, ACTIVE 0 sec mysql tables in use 68, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485762, OS thread handle 139931458684672, query id 113825685002 58.76.184.36 ltcare Executing SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230412' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046753, sees < 54548046302 ---TRANSACTION 422075299514888, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299510672, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299464296, not started returning various info to MariaDB mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298608448, ACTIVE 0 sec starting index read mysql tables in use 152, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485790, OS thread handle 139938900199168, query id 113825679082 58.76.184.36 ltcare Creating sort index SELECT * , IF( cssresn = '1' , IF( current_year_last_indt < 20210201 , IF( DATE_FORMAT(DATE_ADD(STR_TO_DATE(current_year_last_indt, '%Y%m%d'), INTERVAL 14 DAY), '%Y%m%d') < csssldt , 'red' , 'black' ) , IF( Trx read view will not see trx with id >= 54548046669, sees < 54548046302 ---TRANSACTION 422075298798168, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 63, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485786, OS thread handle 139938818389760, query id 113825686799 58.76.184.38 ltcare Statistics SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230412' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230412' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046774, sees < 54548046302 ---TRANSACTION 422075299582344, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 7, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485785, OS thread handle 139938813474560, query id 113825687257 58.76.184.38 ltcare Statistics SELECT COUNT(1) exist_cnt FROM ( SELECT a.stmmgno , a.ctmfkey , a.stmiden , a.stmpass , a.stmname , a.stmnumb , a.stmmalf , a.stmbsdt , a.stmcgrp , a.stmauth , a.stmwgbn , a.stmmtel , a.stmotel , a.stmzcod Trx read view will not see trx with id >= 54548046776, sees < 54548046302 ---TRANSACTION 422075299358896, ACTIVE 0 sec starting index read mysql tables in use 59, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485766, OS thread handle 139938796271360, query id 113825678159 58.76.184.36 ltcare Sending data SELECT DISTINCT current_yc.*, current_yk.*, current_hs.*, current_ns.*, current_pp.*, cpp07_01 + cpp07_02 + cpp07_03 + cpp07_04 + cpp07_05 + cpp07_06 + cpp07_07 + cpp07_08 + cpp07_09 + cpp07_10 + cpp07_11 AS cpp07_tt, twkinfl, twksttm, IF(twkchck = 'Y' OR twkfrst = 'Y', twkrlst, twksttm) twk_start, IF(twkchck = 'Y' OR twktost = 'Y', twkrlen, twkentm) twk_end, ( SELECT COUNT(*) FROM nursing_daily_nursing WHERE numfkey = (SELECT nummgno FROM nursing_master WHERE nursing_master.ctmfkey = patient_master.ctmfkey AND pamfkey Trx read view will not see trx with id >= 54548046703, sees < 54548046302 ---TRANSACTION 422075299548616, ACTIVE 0 sec fetching rows mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485780, OS thread handle 139935472916224, query id 113825682886 58.76.184.38 ltcare Sending data SELECT pamfkey FROM visit_work WHERE ctmfkey = '42438' AND vwkstdt LIKE '202303%' AND vwkampl <> 'E' AND vwkampl <> '' GROUP BY pamfkey Trx read view will not see trx with id >= 54548046707, sees < 54548046302 ---TRANSACTION 422075299535968, ACTIVE 0 sec starting index read mysql tables in use 95, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485768, OS thread handle 139938799957760, query id 113825685732 58.76.184.36 ltcare Sending data WITH date_range AS ( SELECT yyyymmdd FROM date_range WHERE yyyymmdd BETWEEN '20230410' AND '20230416' ) , pam_list AS ( SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(pl.mr, ',', copy_num.num), ',', -1) pammgno FROM copy_num INNER JOIN (SELECT '708399' mr FROM DUAL) pl ON CHAR_LENGTH(pl.mr)-CHAR_LENGTH(REPLACE(pl.mr, ',', ''))>=copy_num.num-1 Trx read view will not see trx with id >= 54548046774, sees < 54548046302 ---TRANSACTION 422075299493808, not started returning various info to MariaDB mysql tables in use 70, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299202904, ACTIVE 0 sec starting index read mysql tables in use 26, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485760, OS thread handle 139929666385664, query id 113825677636 58.76.184.36 ltcare Sending data SELECT stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.stmmgno <> staff_master.stmmgno A Trx read view will not see trx with id >= 54548046629, sees < 54548046302 ---TRANSACTION 422075299320952, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 54548046677, ACTIVE 0 sec fetching rows mysql tables in use 4, locked 4 9 lock struct(s), heap size 1128, 383 row lock(s), undo log entries 3 MySQL thread id 3291485767, OS thread handle 139938910336768, query id 113825687090 58.76.184.38 ltcare Sending data INSERT INTO transport_work_map_cost_master(twkfkey, csmfkey) SELECT twkmgno, '13810531' FROM transport_work WHERE ctmfkey = '7012' AND pamfkey = '359007' AND twkstdt LIKE '202303%' AND (twkstat > '1' OR twkampl = 'E') Trx read view will not see trx with id >= 54548046680, sees < 54548046302 ---TRANSACTION 422075299485376, not started returning various info to MariaDB mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299460080, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298671688, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298591584, not started returning various info to MariaDB mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299333600, ACTIVE 0 sec fetching rows mysql tables in use 24, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485734, OS thread handle 139938894055168, query id 113825677735 58.76.184.36 ltcare Creating sort index WITH date_info AS ( SELECT yyyymmdd , IF(WEEKOFYEAR(yyyymmdd) BETWEEN month_first_day_week_of_year AND month_last_day_week_of_year, WEEKOFYEAR(yyyymmdd), IF(WEEKOFYEAR(yyyymmdd) > month_last_day_week_of_year, month_first_day_week_of_year, month_last_day_week_of_year)) AS week_of_year , month_first_day , month_last_day FROM ( SELECT IF(month_first_day_week_day = 0, month_first_day, DATE_FORMAT(DATE_ADD(mont Trx read view will not see trx with id >= 54548046628, sees < 54548046302 ---TRANSACTION 422075299329384, ACTIVE 0 sec mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485745, OS thread handle 139938899891968, query id 113825678694 58.76.184.38 ltcare Sending data SELECT SUM( IF( SUBSTR( x.yyyymmdd, 1, 6 ) = '202304' AND x.date_s IS NULL AND x.day_s NOT IN('5', '6'), 1, 0 ) * 8 ) AS gijun_time , SUM( IF( x.date_s IS NOT NULL AND ( x.yyyymmdd = '' OR x.yyyymmdd = '' ), 1, 0 ) ) AS carryable FROM ( SELECT * , DATE_FORMAT( DATE_ADD(a.yyyymmdd, INTERVAL 1 day), '%Y%m%d' ) AS date_n , WEEKDAY( a.yyyymmdd ) AS day_s , WEEKDAY( DATE_FORMAT( DATE_ADD(a.yyyymmd Trx read view will not see trx with id >= 54548046644, sees < 54548046302 ---TRANSACTION 422075299291440, ACTIVE 0 sec fetching rows mysql tables in use 34, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485739, OS thread handle 139939296016128, query id 113825682736 58.76.184.38 ltcare Creating sort index SELECT res.* FROM ( SELECT ppp.* , IF( ppp.ctmgubn <= '2' , IF( ppp.pamotdt IS NOT NULL AND ppp.padredt = '' , 'X' , IF( ppp.pamotdt IS NULL OR ppp.padredt <= ppp.e_date , IF( ppp.paofrdt IS NOT NULL AND ppp.paotodt >= ppp.e_date Trx read view will not see trx with id >= 54548046708, sees < 54548046302 ---TRANSACTION 422075299156528, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298878272, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298616880, ACTIVE 0 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485731, OS thread handle 139938823919360, query id 113825677246 58.76.184.36 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046623, sees < 54548046302 ---TRANSACTION 54548046714, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 2, locked 0 6 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 8 MySQL thread id 3291485726, OS thread handle 139938822690560, query id 113825687606 58.76.184.36 ltcare Statistics SELECT SUM(IF(twk.twkmgno IS NOT NULL, 1, 0)) twk_cnt , SUM(IF(twk.twkinfl IS NOT NULL AND twk.twkinfl = '0', 1, 0)) absence_cnt FROM care_master cam LEFT JOIN transport_work twk ON twk.ctmfkey = cam.ctmfkey AND twk.pamfkey = cam.pamfkey AND twk.twkstdt = '20230412' WHERE cam.ctmfkey = '12525' AND cam.cammgno = '561540' Trx read view will not see trx with id >= 54548046715, sees < 54548046302 ---TRANSACTION 422075298928864, not started returning various info to MariaDB mysql tables in use 28, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299017400, not started returning various info to MariaDB mysql tables in use 1, locked 1 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298857192, ACTIVE 0 sec mysql tables in use 6, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485707, OS thread handle 139938809788160, query id 113825687174 58.76.184.38 ltcare Sending data SELECT twk.pamfkey pammgno, wla.wlaover , SUM(IF( 1 = 1 AND twkradt <> 'Y' AND 1 = 1, 1, 0)) plan_cnt , SUM(IF( 1 = 1 AND twkradt = 'Y' AND 1 = 1, 1, 0)) corona_plan_cnt , SUM(IF( 1 = 1 , twkamtp , ( FORMAT(TIME_TO_SEC(TIMEDIFF( CONCAT(SUBSTRING(twk.twkentm, 1, 2), ':', SUBSTRING(twk.twkentm, 3, 4)) , CONCAT(SUBSTRING(twk.twksttm, 1, 2), ':', SUBSTRING(twk.twksttm, 3, 4)) ) Trx read view will not see trx with id >= 54548046775, sees < 54548046302 ---TRANSACTION 422075298583152, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299038480, not started returning various info to MariaDB mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298739144, ACTIVE 0 sec mysql tables in use 17, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485685, OS thread handle 139938811631360, query id 113825685950 58.76.184.36 ltcare Creating sort index WITH param AS ( SELECT 9893 AS ctmmgno , '20230410' AS s_date , '20230416' AS e_date ) , patient AS ( SELECT yyyymmdd, ctmmgno, pammgno, ctmfkey, pamname, pammalf, pamcgrp, pamindt, pamotdt, pamottm , paomgno, paogubn, paofrdt, paofrtm, paotodt, paototm , IF( pamindt > yyyymmdd , 'X' , IF( pamotdt <> '' AND pamotdt <> yyyymmdd AND (padredt = '' OR ( padredt <> '' AND pamotdt < padre Trx read view will not see trx with id >= 54548046757, sees < 54548046302 ---TRANSACTION 422075298945728, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298709632, not started returning various info to MariaDB mysql tables in use 67, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299426352, not started returning various info to MariaDB mysql tables in use 76, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298836112, ACTIVE 0 sec fetching rows mysql tables in use 25, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485675, OS thread handle 139929830717184, query id 113825686270 58.76.184.36 ltcare Sending data WITH drg AS ( SELECT yyyymmdd FROM date_range WHERE yyyymmdd BETWEEN '20230412' AND '20230412' ) , pam AS ( SELECT drg.yyyymmdd , ctm.ctmmgno , ctm.ctmgubn , pam.pammgno , pam.pamindt , pam.pamname , pam.pammalf , pam.pambsdt , (SELECT MAX(paomgno) Trx read view will not see trx with id >= 54548046760, sees < 54548046302 ---TRANSACTION 422075299607640, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299413704, ACTIVE 0 sec starting index read mysql tables in use 152, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485615, OS thread handle 139938905728768, query id 113825671498 58.76.184.36 ltcare Creating sort index SELECT * , IF( cssresn = '1' , IF( current_year_last_indt < 20210201 , IF( DATE_FORMAT(DATE_ADD(STR_TO_DATE(current_year_last_indt, '%Y%m%d'), INTERVAL 14 DAY), '%Y%m%d') < csssldt , 'red' , 'black' ) , IF( Trx read view will not see trx with id >= 54548046559, sees < 54548046302 ---TRANSACTION 422075299367328, ACTIVE 0 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485586, OS thread handle 139938804872960, query id 113825671128 58.76.184.38 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046535, sees < 54548046302 ---TRANSACTION 422075299472728, ACTIVE 0 sec starting index read mysql tables in use 8, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485578, OS thread handle 139929711380224, query id 113825671841 58.76.184.38 ltcare Creating sort index WITH date_range AS ( SELECT yyyymmdd FROM date_range WHERE yyyymmdd BETWEEN '20230401' AND '20230430' ) , disuse_list AS ( SELECT a.dmmmgno , a.dmmckdt , b.dmcname , b.dmc1hdt , b.dmcmgno , (SELECT MAX(dmmmgno) FROM daily_medical_disinfection_master x W Trx read view will not see trx with id >= 54548046538, sees < 54548046302 ---TRANSACTION 54548046591, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 67, locked 0 13 lock struct(s), heap size 1128, 17 row lock(s), undo log entries 12 MySQL thread id 3291485555, OS thread handle 139931483248384, query id 113825687110 58.76.184.36 ltcare Statistics SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20230301' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20230301' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20230301' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046594, sees < 54548046302 ---TRANSACTION 422075298625312, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298789736, ACTIVE 0 sec fetching rows mysql tables in use 58, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485502, OS thread handle 139939162576640, query id 113825684780 58.76.184.38 ltcare Sending data WITH w_stc AS ( -- 출퇴근 데이타 없이 비고만 있는 데이타 SELECT CONCAT(stmfkey, '_', stcyymm, stcdddd, '_', 0) AS stc_key , ctmfkey , stmfkey , CONCAT( stcyymm, stcdddd ) AS date , '' AS frtm , '' AS totm , stcbigo , 1 AS col , '' AS inf Trx read view will not see trx with id >= 54548046756, sees < 54548046302 ---TRANSACTION 422075299042696, not started returning various info to MariaDB mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 54548046747, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 1, locked 0 5 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 2 MySQL thread id 3291485507, OS thread handle 139938898048768, query id 113825687517 58.76.184.36 ltcare Statistics SELECT pallevl FROM patient_level WHERE ctmfkey = '4869' AND pamfkey = 161617 AND '202304' BETWEEN SUBSTRING(palfrdt, 1, 6) AND SUBSTRING(paltodt, 1, 6) ORDER BY CASE WHEN pallevl = '1' THEN 1 WHEN pallevl = '2' THEN 2 WHEN pallevl = '3' THEN 3 WHEN pallevl = '4' THEN 4 WHEN pallevl = '5' THEN 5 WHEN pallevl = 'i' THEN 6 WHEN pallevl = 'E' THEN Trx read view will not see trx with id >= 54548046750, sees < 54548046302 ---TRANSACTION 422075298781304, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299152312, ACTIVE 1 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485414, OS thread handle 139938814703360, query id 113825664271 58.76.184.36 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046438, sees < 54548046271 ---TRANSACTION 422075299586560, ACTIVE 1 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485411, OS thread handle 139937481742080, query id 113825663254 58.76.184.38 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046420, sees < 54548046271 ---TRANSACTION 422075299110152, not started returning various info to MariaDB mysql tables in use 6, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299236632, ACTIVE 0 sec mysql tables in use 55, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485385, OS thread handle 139932276369152, query id 113825686329 58.76.184.38 ltcare Sending data SELECT *, CONCAT(center_room.ctbfkey, '_', center_room.ctrflor, '_', center_room.ctrgrup) ctbflor, (SELECT twkinfl FROM transport_work WHERE pamfkey = pammgno AND twkstdt LIKE '20211214' ORDER BY twkmgno DESC LIMIT 1) twkinfl, (SELECT cttdate FROM contract_master WHERE '20211214' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcdate, (SELECT cttstdt FROM contract_master WHERE '20211214' BETWEEN cttstdt AND cttendt AND pamfkey = pammgno ORDER BY cttdate DESC, cttmgno DESC LIMIT 1) pvcfrdt, ( Trx read view will not see trx with id >= 54548046764, sees < 54548046302 ---TRANSACTION 422075299181824, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299405272, ACTIVE 1 sec starting index read mysql tables in use 8, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485388, OS thread handle 139938806101760, query id 113825664240 58.76.184.36 ltcare Creating sort index WITH date_range AS ( SELECT yyyymmdd FROM date_range WHERE yyyymmdd BETWEEN '20230401' AND '20230430' ) , disuse_list AS ( SELECT a.dmmmgno , a.dmmckdt , b.dmcname , b.dmc1hdt , b.dmcmgno , (SELECT MAX(dmmmgno) FROM daily_medical_disinfection_master x W Trx read view will not see trx with id >= 54548046428, sees < 54548046271 ---TRANSACTION 422075299308304, ACTIVE 0 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485361, OS thread handle 139932367947520, query id 113825679379 58.76.184.38 ltcare Creating sort index SELECT dppmgno, ctmfkey, dpp_tbl, dpp_txt, dpptkey, dppgubn, dppname, dpppkey, dppknd1, dppknd2, dppsidt, dppptxt , IF( dppmtel <> '' , dppmtel , CASE WHEN dppgubn = 'S' THEN (SELECT stmmtel FROM staff_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.stmmgno = document_people.dpppkey) WHEN dppgubn = 'P' THEN (SELECT pammtel FROM patient_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.pammgno = document_people.dpppkey) W Trx read view will not see trx with id >= 54548046661, sees < 54548046302 ---TRANSACTION 422075299325168, ACTIVE 1 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485370, OS thread handle 139931492157184, query id 113825661889 58.76.184.36 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046401, sees < 54548046271 ---TRANSACTION 54548046732, ACTIVE 0 sec 7 lock struct(s), heap size 1128, 3 row lock(s), undo log entries 1 MySQL thread id 3291485367, OS thread handle 139929667307264, query id 113825685831 58.76.184.36 ltcare Trx read view will not see trx with id >= 54548046735, sees < 54548046302 ---TRANSACTION 54548046409, ACTIVE 1 sec fetching rows mysql tables in use 1, locked 0 16 lock struct(s), heap size 1128, 15 row lock(s), undo log entries 4 MySQL thread id 3291485324, OS thread handle 139933747955456, query id 113825672474 58.76.184.36 ltcare Sending data SELECT * FROM cost_prepay_detail WHERE cpdiogb = 'O' AND cpdrgno = '13808995' Trx read view will not see trx with id >= 54548046412, sees < 54548046271 ---TRANSACTION 422075299578128, ACTIVE 0 sec mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485341, OS thread handle 139938825762560, query id 113825678364 58.76.184.38 ltcare Sending data WITH w_sd AS ( SELECT s.* FROM ( SELECT MIN( DATE_FORMAT( solar_date, '%Y%m%d' ) ) AS date_s , spename FROM lunar2solar a , cal_specialday b WHERE DATE_FORMAT( solar_date, '%Y%m' ) LIKE '2023%' AND ( mmdd <> '0501' ) AND ( ( b.solar = ' Trx read view will not see trx with id >= 54548046636, sees < 54548046302 ---TRANSACTION 422075299127016, ACTIVE 1 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485275, OS thread handle 139938785519360, query id 113825658517 58.76.184.38 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046360, sees < 54548045946 ---TRANSACTION 422075299122800, ACTIVE 1 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485286, OS thread handle 139938804565760, query id 113825659087 58.76.184.38 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046364, sees < 54548045946 ---TRANSACTION 422075299114368, ACTIVE 1 sec fetching rows mysql tables in use 24, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485211, OS thread handle 139938817468160, query id 113825656706 58.76.184.38 ltcare Creating sort index WITH date_info AS ( SELECT yyyymmdd , IF(WEEKOFYEAR(yyyymmdd) BETWEEN month_first_day_week_of_year AND month_last_day_week_of_year, WEEKOFYEAR(yyyymmdd), IF(WEEKOFYEAR(yyyymmdd) > month_last_day_week_of_year, month_first_day_week_of_year, month_last_day_week_of_year)) AS week_of_year , month_first_day , month_last_day FROM ( SELECT IF(month_first_day_week_day = 0, month_first_day, DATE_FORMAT(DATE_ADD(mont Trx read view will not see trx with id >= 54548046324, sees < 54548045762 ---TRANSACTION 422075298937296, ACTIVE 1 sec fetching rows mysql tables in use 58, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485195, OS thread handle 139938812860160, query id 113825664945 58.76.184.38 ltcare Sending data WITH w_stc AS ( -- 출퇴근 데이타 없이 비고만 있는 데이타 SELECT CONCAT(stmfkey, '_', stcyymm, stcdddd, '_', 0) AS stc_key , ctmfkey , stmfkey , CONCAT( stcyymm, stcdddd ) AS date , '' AS frtm , '' AS totm , stcbigo , 1 AS col , '' AS inf Trx read view will not see trx with id >= 54548046458, sees < 54548046271 ---TRANSACTION 54548046302, ACTIVE 1 sec fetching rows mysql tables in use 24, locked 0 20 lock struct(s), heap size 1128, 861 row lock(s), undo log entries 5 MySQL thread id 3291485203, OS thread handle 139938799036160, query id 113825657968 58.76.184.36 ltcare Sending data WITH w_holy AS ( SELECT x.* FROM ( SELECT * , DATE_FORMAT( DATE_ADD(a.yyyymmdd, INTERVAL 1 day), '%Y%m%d' ) AS date_n , WEEKDAY( a.yyyymmdd ) AS day_s , WEEKDAY( DATE_FORMAT( DATE_ADD(a.yyyymmdd, INTERVAL 1 day), '%Y%m%d' ) ) AS day_n FROM date_range a LEFT JOIN Trx read view will not see trx with id >= 54548046310, sees < 54548045762 ---TRANSACTION 422075299455864, ACTIVE 1 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485201, OS thread handle 140599983535872, query id 113825656104 58.76.184.38 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046316, sees < 54548045762 ---TRANSACTION 54548046644, ACTIVE 0 sec 26 lock struct(s), heap size 3488, 1828 row lock(s), undo log entries 3 MySQL thread id 3291485202, OS thread handle 139938900813568, query id 113825687663 58.76.184.38 ltcare Writing to net SELECT pla.*, csc.* , ( SELECT SUM(IF(twk.twkampt = '3' OR twk.twkampt = '4' OR twk.twkampt = '7', 1, 0)) FROM transport_work twk WHERE twk.ctmfkey = ctm.ctmmgno AND twk.pamfkey = pam.pammgno AND twk.twkstdt LIKE CONCAT(cal.yymm, '%') ) patient_limit_amount_plan_cnt FROM patient_master pam INNER JOIN center_master ctm ON ctm.ctmmgno = pam.ctmfkey LEFT JOIN ( SELECT '202304' Trx read view will not see trx with id >= 54548046650, sees < 54548046302 ---TRANSACTION 422075299476944, ACTIVE 1 sec fetching rows mysql tables in use 10, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485175, OS thread handle 139938906957568, query id 113825669771 58.76.184.38 ltcare Sending data SELECT olc.*, IFNULL(olg.olgname, '개인') olgname , IF(t.dt BETWEEN SUBSTRING(IF(olc.olcfrdt <> '', olc.olcfrdt, '10000101'), 1, LENGTH(t.dt)) AND SUBSTRING(IF(olc.olctodt <> '', olc.olctodt, '99991231'), 1, LENGTH(t.dt)) , '1', 'X' ) olcstat -- 2021.04.09 김학주 기록인 경우 dpp_tbl : program_plan_master, 일정인 경우 dpp_tbl : program_item 조회하도록 수정 -- , (SELECT COUNT(*) Trx read view will not see trx with id >= 54548046510, sees < 54548046302 ---TRANSACTION 422075299228200, ACTIVE 1 sec starting index read mysql tables in use 20, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485142, OS thread handle 139938820540160, query id 113825653269 58.76.184.38 ltcare Sending data SELECT a.* , cst_excel.* , IF(pout.out_time_list, 'Y','') twkotfl , pout.out_time_list , pout.out_min_sum , pln.twhsttm AS pln_sttm , pln.twhentm AS pln_entm , pln.twhamtp AS pln_amtp , pln.tsfcode AS pln_code , CASE pln.tsfcode WHEN 'DDD' THEN '일별 급여비용' WHEN 'DMM' THEN '월별 급여비용' ELSE (SELECT dsfname FROM Trx read view will not see trx with id >= 54548046264, sees < 54548045762 ---TRANSACTION 422075299434784, ACTIVE 1 sec mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485113, OS thread handle 139929777571584, query id 113825652939 58.76.184.36 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046267, sees < 54548045762 ---TRANSACTION 422075299055344, ACTIVE 0 sec fetching rows mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485092, OS thread handle 139938816853760, query id 113825686268 58.76.184.36 ltcare Creating sort index SELECT * , (SELECT COUNT(*) FROM patient_master pam LEFT JOIN patient_state_history psh \t\t ON psh.pshmgno = (SELECT temp_psh.pshmgno \t\t \t\t\t\t\t FROM patient_state_history temp_psh \t\t \t\t\t\t\tWHERE temp_psh.ctmfkey = pam.ctmfkey \t\t \t\t\t\t\t AND temp_psh.pamfkey = pam.pammgno \t\t \t\t\t\t\t AND temp_psh.pshdate <= date_format(now(), '%Y%m%d') \t\t \t\t\t\t\tORDER BY temp_ps Trx read view will not see trx with id >= 54548046760, sees < 54548046302 ---TRANSACTION 422075299363112, not started returning various info to MariaDB mysql tables in use 7, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298874056, ACTIVE 1 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291485068, OS thread handle 139933263116032, query id 113825651540 58.76.184.36 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046255, sees < 54548045762 ---TRANSACTION 422075298734928, not started returning various info to MariaDB mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298840328, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 6, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484980, OS thread handle 139929704314624, query id 113825687408 58.76.184.36 ltcare Statistics SELECT in_out.* FROM ( SELECT pam_in.pamindt, IFNULL(out_psh.pshdate, '99991231') pamotdt, IFNULL(before_out_psh.pshdate, '10000101') before_pamotdt FROM ( SELECT 0 idx, pam.ctmfkey, pam.pammgno, pam.pamindt FROM patient_master pam WHERE pam.ctmfkey = '10897' AND pam.pammgno = '454864' UNION SELECT in_psh.idx, in_psh.ctm Trx read view will not see trx with id >= 54548046791, sees < 54548046302 ---TRANSACTION 422075299215552, ACTIVE 2 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484971, OS thread handle 139938893747968, query id 113825646786 58.76.184.38 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046198, sees < 54548045762 ---TRANSACTION 422075299135448, ACTIVE 2 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484973, OS thread handle 139938803029760, query id 113825647477 58.76.184.38 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046202, sees < 54548045762 ---TRANSACTION 422075298675904, not started returning various info to MariaDB mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299194472, ACTIVE 0 sec starting index read mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484930, OS thread handle 139938781525760, query id 113825682483 58.76.184.36 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046707, sees < 54548046302 ---TRANSACTION 422075299312520, ACTIVE 2 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484919, OS thread handle 139938759726848, query id 113825645394 58.76.184.36 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548046184, sees < 54548045762 ---TRANSACTION 54548046750, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 6, locked 0 4 lock struct(s), heap size 1128, 2 row lock(s), undo log entries 1 MySQL thread id 3291484885, OS thread handle 139938798728960, query id 113825687593 58.76.184.36 ltcare Statistics SELECT dsfcode, dsfcst4 dsfbfee, csccmfg, 477 twkmmdf, dsfname FROM (SELECT * , CASE WHEN dsfcode = 'D01' THEN IF(LENGTH(IFNULL(cnrtst1, dsfcst1)) > 0, IFNULL(cnrtst1, dsfcst1), dsfcst1) WHEN dsfcode = 'D02' THEN IF(LENGTH(IFNULL(cnrtst2, dsfcst1)) > 0, IFNULL(cnrtst2, dsfcst1), dsfcst1) WHEN dsfcode = 'D03' THEN IF(LENGTH(IFNULL(cnrtst3, dsfcst1)) > 0, IFNULL(cnrtst3, dsfcst1), dsfcst1) WHEN dsfcode = 'D04' THEN IF(LENGT Trx read view will not see trx with id >= 54548046753, sees < 54548046302 ---TRANSACTION 54548046658, ACTIVE 0 sec mysql tables in use 1, locked 0 21 lock struct(s), heap size 1128, 478 row lock(s), undo log entries 1 MySQL thread id 3291484870, OS thread handle 139939164419840, query id 113825687460 58.76.184.36 ltcare Creating sort index SELECT pallevl FROM patient_level WHERE ctmfkey = '7330' AND pamfkey = 331488 AND '202304' BETWEEN SUBSTRING(palfrdt, 1, 6) AND SUBSTRING(paltodt, 1, 6) ORDER BY CASE WHEN pallevl = '1' THEN 1 WHEN pallevl = '2' THEN 2 WHEN pallevl = '3' THEN 3 WHEN pallevl = '4' THEN 4 WHEN pallevl = '5' THEN 5 WHEN pallevl = 'i' THEN 6 WHEN pallevl = 'E' THEN Trx read view will not see trx with id >= 54548046663, sees < 54548046302 ---TRANSACTION 422075298966808, ACTIVE 1 sec fetching rows mysql tables in use 10, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484846, OS thread handle 139935474145024, query id 113825658612 58.76.184.38 ltcare Sending data SELECT olc.*, IFNULL(olg.olgname, '개인') olgname , IF(t.dt BETWEEN SUBSTRING(IF(olc.olcfrdt <> '', olc.olcfrdt, '10000101'), 1, LENGTH(t.dt)) AND SUBSTRING(IF(olc.olctodt <> '', olc.olctodt, '99991231'), 1, LENGTH(t.dt)) , '1', 'X' ) olcstat -- 2021.04.09 김학주 기록인 경우 dpp_tbl : program_plan_master, 일정인 경우 dpp_tbl : program_item 조회하도록 수정 -- , (SELECT COUNT(*) Trx read view will not see trx with id >= 54548046357, sees < 54548045762 ---TRANSACTION 422075299468512, ACTIVE 2 sec fetching rows mysql tables in use 24, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484757, OS thread handle 139938822383360, query id 113825639215 58.76.184.38 ltcare Sending data WITH date_info AS ( SELECT yyyymmdd , IF(WEEKOFYEAR(yyyymmdd) BETWEEN month_first_day_week_of_year AND month_last_day_week_of_year, WEEKOFYEAR(yyyymmdd), IF(WEEKOFYEAR(yyyymmdd) > month_last_day_week_of_year, month_first_day_week_of_year, month_last_day_week_of_year)) AS week_of_year , month_first_day , month_last_day FROM ( SELECT IF(month_first_day_week_day = 0, month_first_day, DATE_FORMAT(DATE_ADD(mont Trx read view will not see trx with id >= 54548046092, sees < 54548045762 ---TRANSACTION 422075299350464, not started returning various info to MariaDB mysql tables in use 2, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299304088, not started returning various info to MariaDB mysql tables in use 10, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 54548046774, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 1, locked 0 2 lock struct(s), heap size 1128, 1 row lock(s), undo log entries 1 MySQL thread id 3291484726, OS thread handle 139939162883840, query id 113825687412 58.76.184.36 ltcare Statistics SELECT * FROM transport_work_amtp_history WHERE twkfkey = '91624691' Trx read view will not see trx with id >= 54548046776, sees < 54548046302 ---TRANSACTION 422075299249280, not started returning various info to MariaDB mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299025832, not started returning various info to MariaDB mysql tables in use 5, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075299089072, ACTIVE 2 sec starting index read mysql tables in use 8, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484658, OS thread handle 139937477748480, query id 113825637105 58.76.184.36 ltcare Creating sort index WITH date_range AS ( SELECT yyyymmdd FROM date_range WHERE yyyymmdd BETWEEN '20220601' AND '20220630' ) , disuse_list AS ( SELECT a.dmmmgno , a.dmmckdt , b.dmcname , b.dmc1hdt , b.dmcmgno , (SELECT MAX(dmmmgno) FROM daily_medical_disinfection_master x W Trx read view will not see trx with id >= 54548046072, sees < 54548045762 ---TRANSACTION 422075299240848, ACTIVE 0 sec fetching rows mysql tables in use 42, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484610, OS thread handle 139929712609024, query id 113825684662 58.76.184.36 ltcare Sending data SELECT a.pamfkey /* 수급자 FK */ , b.pamname /* 수급자명 */ , b.pammalf /* 성별 */ , b.pambsdt /* 생일(나이구할때 사용됨) */ , a.chpsldt /* 계획수립일 */ Trx read view will not see trx with id >= 54548046738, sees < 54548046302 ---TRANSACTION 422075299211336, ACTIVE 1 sec starting index read mysql tables in use 23, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484587, OS thread handle 139931478333184, query id 113825659159 58.76.184.36 ltcare Sending data SELECT t.* , (t.srsiguk + t.srsigun + t.srsijan + t.srsigoy + t.srsisan) AS srsiamt -- 기관부담금 총액 FROM ( SELECT sph.ctmfkey , sph.stmfkey , sph.sphgubn , IF(stm.stmjknd IN (4,8,4,8,8,4,8,4,8,22,4,7,8,22,4,7,8) , stm.stmjknd , IF(SUBSTRING(stm.sjhdate, 1, 6) = SUBSTRING('20230228', 1, 6) AND SUBSTRING(s Trx read view will not see trx with id >= 54548046364, sees < 54548045946 ---TRANSACTION 422075298604232, ACTIVE 0 sec starting index read mysql tables in use 7, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484549, OS thread handle 139932371633920, query id 113825687656 58.76.184.34 ltcare Statistics SELECT a.* , IF(prmtype = 'P', pgm.pgmname, a.pgmname) pgmname , IF(prmtype = 'P', psc.pscmgno, a.pscfkey) pscfkey , IF(prmtype = 'P', psc.pscname, a.prmpscn) prmpscn , IF(prmtype = 'P', psc.psckdcd, a.psckdcd) psckdcd , IF(prmtype = 'P', prl.prlname, a.prmprln) prmprln , CASE WHEN a.stmgubn = 'S' THEN (SELECT stmsign FROM staff_master x WHERE x.ctmfkey = a.ctmfkey AND x.stmmgno = a.stmfkey) ---TRANSACTION 422075299021616, ACTIVE 3 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484366, OS thread handle 139929764361984, query id 113825625766 58.76.184.36 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548045931, sees < 54548045556 ---TRANSACTION 422075298827680, not started returning various info to MariaDB mysql tables in use 1, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298962592, ACTIVE 0 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484290, OS thread handle 139938788316928, query id 113825676967 58.76.184.38 ltcare Creating sort index SELECT dppmgno, ctmfkey, dpp_tbl, dpp_txt, dpptkey, dppgubn, dppname, dpppkey, dppknd1, dppknd2, dppsidt, dppptxt , IF( dppmtel <> '' , dppmtel , CASE WHEN dppgubn = 'S' THEN (SELECT stmmtel FROM staff_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.stmmgno = document_people.dpppkey) WHEN dppgubn = 'P' THEN (SELECT pammtel FROM patient_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.pammgno = document_people.dpppkey) W Trx read view will not see trx with id >= 54548046620, sees < 54548046302 ---TRANSACTION 422075298844544, ACTIVE 3 sec fetching rows mysql tables in use 5, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484074, OS thread handle 139929779107584, query id 113825630984 58.76.184.36 ltcare Sending data SELECT a.* , IFNULL( (SELECT pthtype FROM patient_type_history x WHERE x.ctmfkey = a.ctmfkey AND x.pamfkey = b.pammgno AND x.pthdate <= '20230431' ORDER BY pthdate DESC LIMIT 1), pamtype) pamtype , ( SELECT IF( csltype <> 'S' , pafprnm , ( CASE WHEN cslsnto = pafftl1 THEN paffnm1 WHEN cslsnto = pafftl2 THEN paffnm2 ELSE pafprnm END ) ) FROM patient_family WHERE p Trx read view will not see trx with id >= 54548045994, sees < 54548045556 ---TRANSACTION 422075298852976, ACTIVE 3 sec fetching rows mysql tables in use 4, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484081, OS thread handle 139938819004160, query id 113825617564 58.76.184.36 ltcare Sending data SELECT swrmgno, ctmfkey, swrstmk, swrstmn, pamfkey, swrpnme, swrtype, swrygsc, swrygjb, swrygij , swrygus, swrygyy, swryggj, swrygjh, swrkymp, swrkyny, swrkybb, swrkyn2, swrkyb2, swrijny , swrijbb, swrijpk, swrijpn, swrscny, swrscbb, swrscpk, swrscpn, swrptdw, swrptct, swrhiny , swrhijc, swrhisk, swrhisn, swrvsdt, swrvsft, swrvstt, swrvspl, swrvsyn, swrvsrs, swrvssk , swrvssn, swv_key, swrcrdt, swrupdt , SUBSTRING(swrvsdt, 5, 2) mm , (SELEC Trx read view will not see trx with id >= 54548045803, sees < 54548045310 ---TRANSACTION 54548046727, ACTIVE 0 sec getting list of referencing foreign keys 12 lock struct(s), heap size 1128, 1117 row lock(s), undo log entries 1 MySQL thread id 3291484066, OS thread handle 139932389902080, query id 113825687692 58.76.184.38 ltcare Opening tables UPDATE transport_work SET twkltst = '0', twkampt = '1', twkstdt = '20230410', -- VARCHAR(8) NOT NULL COMMENT '* 시작 YYYYMMDD', twksttm = '0854', -- VARCHAR(6) NOT NULL COMMENT '* 시작 HHMMSS', twkendt = '20230410', -- VARCHAR(8) NOT NULL COMMENT '* 종료 YYYYMMDD', t Trx read view will not see trx with id >= 54548046735, sees < 54548046302 ---TRANSACTION 422075299080640, ACTIVE 4 sec fetching rows mysql tables in use 29, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291484023, OS thread handle 139929737799424, query id 113825613389 58.76.184.36 ltcare Sending data SELECT swptime, swpvccd, work_plan_cnt, stmmgno, stmstat, stmcgrp, stmname, stmmalf, stmjknd, stmcmkd, stmindt, stmindt_init, stmotdt, sshdate, stmbsdt, stmwgbn, stmmtel, stmzcod, stmpadr, stmradr, stmotel, stmfmly, stmfedu, stmvsyo, stmvsmo, stmvsga, stmiden, stmnumb, stmeml, stmstdt, stmeddt, stmnote, stmw4cn, usmusid, usmusyn, ctbfkey, CONCAT(ctbfkey, '_', ctbflor, '_', ctbgrup) ctbflor, ctrfkey, (SELECT COUNT(*) FROM staff_master x WHERE x.ctmfkey = staff_master.ctmfkey AND x.s Trx read view will not see trx with id >= 54548045731, sees < 54548045310 ---TRANSACTION 422075298987888, ACTIVE 0 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291483926, OS thread handle 139938814396160, query id 113825673680 58.76.184.36 ltcare Creating sort index SELECT dppmgno, ctmfkey, dpp_tbl, dpp_txt, dpptkey, dppgubn, dppname, dpppkey, dppknd1, dppknd2, dppsidt, dppptxt , IF( dppmtel <> '' , dppmtel , CASE WHEN dppgubn = 'S' THEN (SELECT stmmtel FROM staff_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.stmmgno = document_people.dpppkey) WHEN dppgubn = 'P' THEN (SELECT pammtel FROM patient_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.pammgno = document_people.dpppkey) W Trx read view will not see trx with id >= 54548046571, sees < 54548046302 ---TRANSACTION 422075298612664, ACTIVE 0 sec returning various info to MariaDB mysql tables in use 3, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291483893, OS thread handle 139931486627584, query id 113825687300 58.76.184.36 ltcare Statistics SELECT a.* , IF(prmtype = 'P', pgm.pgmname, a.pgmname) pgmname , IF(prmtype = 'P', psc.pscmgno, a.pscfkey) pscfkey , IF(prmtype = 'P', psc.pscname, a.prmpscn) prmpscn , IF(prmtype = 'P', psc.psckdcd, a.psckdcd) psckdcd , IF(prmtype = 'P', prl.prlname, a.prmprln) prmprln , CASE WHEN a.stmgubn = 'S' THEN (SELECT stmsign FROM staff_master x WHERE x.ctmfkey = a.ctmfkey AND x.stmmgno = a.stmfkey) Trx read view will not see trx with id >= 54548046776, sees < 54548046302 ---TRANSACTION 422075299008968, ACTIVE 1 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291483868, OS thread handle 139938783368960, query id 113825652941 58.76.184.36 ltcare Creating sort index SELECT dppmgno, ctmfkey, dpp_tbl, dpp_txt, dpptkey, dppgubn, dppname, dpppkey, dppknd1, dppknd2, dppsidt, dppptxt , IF( dppmtel <> '' , dppmtel , CASE WHEN dppgubn = 'S' THEN (SELECT stmmtel FROM staff_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.stmmgno = document_people.dpppkey) WHEN dppgubn = 'P' THEN (SELECT pammtel FROM patient_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.pammgno = document_people.dpppkey) W Trx read view will not see trx with id >= 54548046259, sees < 54548045762 ---TRANSACTION 422075298920432, ACTIVE 4 sec fetching rows mysql tables in use 10, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291483864, OS thread handle 139933752870656, query id 113825611580 58.76.184.36 ltcare Sending data SELECT olc.*, IFNULL(olg.olgname, '개인') olgname , IF(t.dt BETWEEN SUBSTRING(IF(olc.olcfrdt <> '', olc.olcfrdt, '10000101'), 1, LENGTH(t.dt)) AND SUBSTRING(IF(olc.olctodt <> '', olc.olctodt, '99991231'), 1, LENGTH(t.dt)) , '1', 'X' ) olcstat -- 2021.04.09 김학주 기록인 경우 dpp_tbl : program_plan_master, 일정인 경우 dpp_tbl : program_item 조회하도록 수정 -- , (SELECT COUNT(*) Trx read view will not see trx with id >= 54548045680, sees < 54548045310 ---TRANSACTION 54548046775, ACTIVE 0 sec 4 lock struct(s), heap size 1128, 2 row lock(s) MySQL thread id 3291483848, OS thread handle 139937451943680, query id 113825687708 58.76.184.36 ltcare Init SELECT GROUP_CONCAT(bigo ORDER BY odr, frtm, p_name, totm SEPARATOR ', ') bigo FROM ( SELECT * FROM ( SELECT prr.prrnote bigo , CONCAT(prm.prmfrht, prm.prmfrmt) frtm , CONCAT(prm.prmtoht, prm.prmtomt) totm , '1' odr , prm.prmprln p_name FROM program_plan_record prr Trx read view will not see trx with id >= 54548046792, sees < 54548046302 ---TRANSACTION 422075298574720, ACTIVE 1 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291483745, OS thread handle 139938819618560, query id 113825665144 58.76.184.38 ltcare Creating sort index SELECT dppmgno, ctmfkey, dpp_tbl, dpp_txt, dpptkey, dppgubn, dppname, dpppkey, dppknd1, dppknd2, dppsidt, dppptxt , IF( dppmtel <> '' , dppmtel , CASE WHEN dppgubn = 'S' THEN (SELECT stmmtel FROM staff_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.stmmgno = document_people.dpppkey) WHEN dppgubn = 'P' THEN (SELECT pammtel FROM patient_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.pammgno = document_people.dpppkey) W Trx read view will not see trx with id >= 54548046442, sees < 54548046271 ---TRANSACTION 422075299004752, ACTIVE 4 sec fetching rows mysql tables in use 24, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291483725, OS thread handle 139931500451584, query id 113825600885 58.76.184.36 ltcare Sending data WITH date_info AS ( SELECT yyyymmdd , IF(WEEKOFYEAR(yyyymmdd) BETWEEN month_first_day_week_of_year AND month_last_day_week_of_year, WEEKOFYEAR(yyyymmdd), IF(WEEKOFYEAR(yyyymmdd) > month_last_day_week_of_year, month_first_day_week_of_year, month_last_day_week_of_year)) AS week_of_year , month_first_day , month_last_day FROM ( SELECT IF(month_first_day_week_day = 0, month_first_day, DATE_FORMAT(DATE_ADD(mont Trx read view will not see trx with id >= 54548045460, sees < 54548045127 ---TRANSACTION 422075298764440, ACTIVE 0 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291483419, OS thread handle 139938818696960, query id 113825685480 58.76.184.38 ltcare Creating sort index SELECT dppmgno, ctmfkey, dpp_tbl, dpp_txt, dpptkey, dppgubn, dppname, dpppkey, dppknd1, dppknd2, dppsidt, dppptxt , IF( dppmtel <> '' , dppmtel , CASE WHEN dppgubn = 'S' THEN (SELECT stmmtel FROM staff_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.stmmgno = document_people.dpppkey) WHEN dppgubn = 'P' THEN (SELECT pammtel FROM patient_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.pammgno = document_people.dpppkey) W Trx read view will not see trx with id >= 54548046753, sees < 54548046302 ---TRANSACTION 422075298941512, ACTIVE 0 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291483242, OS thread handle 139935511009024, query id 113825686184 58.76.184.38 ltcare Creating sort index SELECT dppmgno, ctmfkey, dpp_tbl, dpp_txt, dpptkey, dppgubn, dppname, dpppkey, dppknd1, dppknd2, dppsidt, dppptxt , IF( dppmtel <> '' , dppmtel , CASE WHEN dppgubn = 'S' THEN (SELECT stmmtel FROM staff_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.stmmgno = document_people.dpppkey) WHEN dppgubn = 'P' THEN (SELECT pammtel FROM patient_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.pammgno = document_people.dpppkey) W Trx read view will not see trx with id >= 54548046758, sees < 54548046302 ---TRANSACTION 422075298621096, ACTIVE 3 sec fetching rows mysql tables in use 42, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291482497, OS thread handle 139933289350912, query id 113825632208 58.76.184.38 ltcare Sending data SELECT a.pamfkey /* 수급자 FK */ , b.pamname /* 수급자명 */ , b.pammalf /* 성별 */ , b.pambsdt /* 생일(나이구할때 사용됨) */ , a.chpsldt /* 계획수립일 */ Trx read view will not see trx with id >= 54548046012, sees < 54548045762 ---TRANSACTION 422075298688552, ACTIVE 2 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291482154, OS thread handle 139938794428160, query id 113825644233 58.76.184.38 ltcare Creating sort index SELECT dppmgno, ctmfkey, dpp_tbl, dpp_txt, dpptkey, dppgubn, dppname, dpppkey, dppknd1, dppknd2, dppsidt, dppptxt , IF( dppmtel <> '' , dppmtel , CASE WHEN dppgubn = 'S' THEN (SELECT stmmtel FROM staff_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.stmmgno = document_people.dpppkey) WHEN dppgubn = 'P' THEN (SELECT pammtel FROM patient_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.pammgno = document_people.dpppkey) W Trx read view will not see trx with id >= 54548046170, sees < 54548045762 ---TRANSACTION 422075298637960, ACTIVE 1 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291481139, OS thread handle 139932450420480, query id 113825663526 58.76.184.38 ltcare Creating sort index SELECT dppmgno, ctmfkey, dpp_tbl, dpp_txt, dpptkey, dppgubn, dppname, dpppkey, dppknd1, dppknd2, dppsidt, dppptxt , IF( dppmtel <> '' , dppmtel , CASE WHEN dppgubn = 'S' THEN (SELECT stmmtel FROM staff_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.stmmgno = document_people.dpppkey) WHEN dppgubn = 'P' THEN (SELECT pammtel FROM patient_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.pammgno = document_people.dpppkey) W Trx read view will not see trx with id >= 54548046421, sees < 54548046271 ---TRANSACTION 422075298768656, ACTIVE 1 sec fetching rows mysql tables in use 9, locked 0 0 lock struct(s), heap size 1128, 0 row lock(s) MySQL thread id 3291480558, OS thread handle 139932347057920, query id 113825657913 58.76.184.36 ltcare Creating sort index SELECT dppmgno, ctmfkey, dpp_tbl, dpp_txt, dpptkey, dppgubn, dppname, dpppkey, dppknd1, dppknd2, dppsidt, dppptxt , IF( dppmtel <> '' , dppmtel , CASE WHEN dppgubn = 'S' THEN (SELECT stmmtel FROM staff_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.stmmgno = document_people.dpppkey) WHEN dppgubn = 'P' THEN (SELECT pammtel FROM patient_master x WHERE x.ctmfkey = document_people.ctmfkey AND x.pammgno = document_people.dpppkey) W Trx read view will not see trx with id >= 54548046338, sees < 54548045762 ---TRANSACTION 422075298823464, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298793952, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298933080, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298696984, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298899352, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298772872, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298760224, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298646392, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298705416, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298595800, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298726496, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298886704, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298806600, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298663256, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298587368, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298819248, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298802384, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298861408, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298680120, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298882488, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298730712, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298654824, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298713848, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298642176, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298570504, not started 0 lock struct(s), heap size 1128, 0 row lock(s) ---TRANSACTION 422075298566288, not started 0 lock struct(s), heap size 1128, 0 row lock(s) -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 279269814 OS file reads, 2572986541 OS file writes, 515772783 OS fsyncs 0 pending reads, 1 pending writes 67.13 reads/s, 16384 avg bytes/read, 411.21 writes/s, 98.22 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 85096, seg size 85098, 5848389 merges merged operations: insert 14566990, delete mark 8204801, delete 1945614 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 160435843, node heap has 211965 buffer(s) Hash table size 160435843, node heap has 336313 buffer(s) Hash table size 160435843, node heap has 137169 buffer(s) Hash table size 160435843, node heap has 110020 buffer(s) Hash table size 160435843, node heap has 88004 buffer(s) Hash table size 160435843, node heap has 476894 buffer(s) Hash table size 160435843, node heap has 183676 buffer(s) Hash table size 160435843, node heap has 228185 buffer(s) 1733590.02 hash searches/s, 375615.06 non-hash searches/s --- LOG --- Log sequence number 15625314725476 Log flushed up to 15625314722565 Pages flushed up to 15623769983326 Last checkpoint at 15623769785548 0 pending log flushes, 0 pending chkp writes 1805864539 log i/o's done, 283.45 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 649076932608 Dictionary memory allocated 4099200 Buffer pool size 38782236 Free buffers 8179 Database pages 37001828 Old database pages 13658716 Modified db pages 575337 Percent of dirty pages(LRU & free pages): 1.555 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 3364857735, not young 17498534086 1211.44 youngs/s, 2853.42 non-youngs/s Pages read 279268629, created 37400844, written 646637477 67.13 reads/s, 9.23 creates/s, 105.50 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 37001828, unzip_LRU len: 0 I/O sum[66384]:cur[808], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 4848308 Free buffers 1021 Database pages 4625587 Old database pages 1707472 Modified db pages 74060 Percent of dirty pages(LRU & free pages): 1.601 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 422084539, not young 2221271417 164.40 youngs/s, 330.67 non-youngs/s Pages read 35008791, created 4671266, written 82989262 7.14 reads/s, 2.73 creates/s, 13.91 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 4625587, unzip_LRU len: 0 I/O sum[8298]:cur[101], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 4847704 Free buffers 1022 Database pages 4624853 Old database pages 1707201 Modified db pages 71422 Percent of dirty pages(LRU & free pages): 1.544 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 420633831, not young 2177512066 151.27 youngs/s, 193.45 non-youngs/s Pages read 34790917, created 4675319, written 80773643 8.14 reads/s, 2.91 creates/s, 12.27 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 4624853, unzip_LRU len: 0 I/O sum[8298]:cur[101], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 4847704 Free buffers 1024 Database pages 4625335 Old database pages 1707379 Modified db pages 71792 Percent of dirty pages(LRU & free pages): 1.552 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 420313224, not young 2168455954 158.04 youngs/s, 602.70 non-youngs/s Pages read 34847575, created 4678917, written 80639984 7.55 reads/s, 0.09 creates/s, 14.73 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 4625335, unzip_LRU len: 0 I/O sum[8298]:cur[101], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 4847704 Free buffers 1022 Database pages 4625425 Old database pages 1707412 Modified db pages 71711 Percent of dirty pages(LRU & free pages): 1.550 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 414192446, not young 2102745737 166.54 youngs/s, 428.12 non-youngs/s Pages read 34184841, created 4673069, written 80829131 10.68 reads/s, 0.32 creates/s, 13.32 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 4625425, unzip_LRU len: 0 I/O sum[8298]:cur[101], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 4847704 Free buffers 1026 Database pages 4625196 Old database pages 1707327 Modified db pages 71939 Percent of dirty pages(LRU & free pages): 1.555 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 426924566, not young 2265597055 151.17 youngs/s, 282.35 non-youngs/s Pages read 35453824, created 4654779, written 80826262 8.32 reads/s, 0.68 creates/s, 14.45 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 4625196, unzip_LRU len: 0 I/O sum[8298]:cur[101], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 4847704 Free buffers 1022 Database pages 4624888 Old database pages 1707214 Modified db pages 71656 Percent of dirty pages(LRU & free pages): 1.549 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 421450225, not young 2150153257 142.95 youngs/s, 314.44 non-youngs/s Pages read 35060645, created 4674496, written 80159687 7.14 reads/s, 0.68 creates/s, 12.27 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 4624888, unzip_LRU len: 0 I/O sum[8298]:cur[101], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 4847704 Free buffers 1020 Database pages 4626005 Old database pages 1707626 Modified db pages 71606 Percent of dirty pages(LRU & free pages): 1.548 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 416301453, not young 2187350372 145.13 youngs/s, 312.62 non-youngs/s Pages read 34649085, created 4684718, written 80015400 8.36 reads/s, 0.77 creates/s, 12.27 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 4626005, unzip_LRU len: 0 I/O sum[8298]:cur[101], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 4847704 Free buffers 1022 Database pages 4624539 Old database pages 1707085 Modified db pages 71151 Percent of dirty pages(LRU & free pages): 1.538 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 422957451, not young 2225448228 131.95 youngs/s, 389.07 non-youngs/s Pages read 35272951, created 4688280, written 80404108 9.82 reads/s, 1.05 creates/s, 12.27 writes/s Buffer pool hit rate 999 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 4624539, unzip_LRU len: 0 I/O sum[8298]:cur[101], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 117 read views open inside InnoDB Process ID=149565, Main thread ID=139939203237632, state: sleeping Number of rows inserted 2714260011, updated 932741390, deleted 826435445, read 95438149960032 477.71 inserts/s, 80.04 updates/s, 115.40 deletes/s, 16665798.24 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 1 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================