1.背景
研发同事查询electric_invoice表数据,在商用产生大量的该表的慢查询。由于是慢查询所以找DBA添加 索引。添加索引和线上慢查询同时执行导致,慢查询处于《Waiting for table metadata lock》错误中。
当时用户无法支付,支付回调慢等情况。这种情况持续30分钟左右。用户投诉也蜂拥而至。
2.读库上,show processlist 出现大量的 Waiting for table metadata lock。
数据库实例是1个主库,3个读库。主库dml操作将同步到读库。事务走主库,查询走读库。
3.慢查询在读库,索引执行在主库。主库执行成功。读库上,同步索引与数据库慢查询进行冲突。查询将产生Waiting for table metadata lock。DBA主库上执行索引添加后,静等同步到从库。但是该表的慢查询不断。
4.假设Mysql,在查询的时候,发现索引正在建立,会不会等待索引建立完毕后开始使用索引,进行查询。如果不用索引则数据上查询遍历即可。
5.假设Mysql,在表上执行ddl操作的时候,所有读和写均应该停止。如果这个表的记录数很大,大到几千万级别,索引添加这个操作需要一定时间,但是也不会超过5分钟吧。
6.表上执行索引的时候,如果有事务,那么主库上执行也会受影响,DBA会执行的第一时间将发现危险。所以主库执行索引是没问题。
7.这次慢查询产生是从读库产生的,所以关闭慢查询产生的读库实例3。慢查询没有了。同时关闭其他2个读库。读库同步主库的索引完成以后,开启接口应用的查询。不会再查询出现《Waiting for table metadata lock》错误。
附
慢查询日志
2019-06-13 16:40:01
xxx商(只读实例003)用慢sql相关信息:
USER:elchyeob0
IP:100.104.10.7:55771
TIME:2610S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0ec15604125916457530d11fb/9// *//*DRDS /10.3.13.2/eee666f91406000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1631111311788088584'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:14915
TIME:2396S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604128056857164d069c/9// *//*DRDS /10.3.13.3/eee674097800000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635642794617877364'
,
'1634467848290053473'
,
'1633848958552914026'
,
'1633737955880217482'
,
'1633218583540543193'
,
'1632657080093523117'
,
'1632411889694672913'
,
'1631927532015072638'
,
'1631314273334470864'
,
'1630678957326083539'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.189:7048
TIME:2617S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd10515604125847724242d07eb/9// *//*DRDS /10.3.13.2/eee6668db403000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1634381182255765799'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:60864
TIME:2211S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604129901924512d0813/9// *//*DRDS /10.3.13.1/eee67f4c6404000/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968641389451726464)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.7:4567
TIME:1516S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0ec15604136856902989d11fb/9// *//*DRDS /10.3.13.3/eee6a9bf8c06000/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968641011756666496)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.209:1167
TIME:1211S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd02715604139900686588d0628/9// *//*DRDS /10.3.13.2/eee6bc537402000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1634381182255765799'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.152:14061
TIME:2419S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0d215604127820981456d11d3/9// *//*DRDS /10.3.13.1/eee67298ec05001/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968641629424733312, 1968641355353999104)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.35:35472
TIME:2416S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd16b15604127858148789d06e8/9// *//*DRDS /10.3.13.1/eee672d2fc01000/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968641629424733312, 1968641355353999104)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.35:34249
TIME:2105S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd16b15604130966925413d06e8/9// *//*DRDS /10.3.13.2/eee685cc7401000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636008757670460702'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.114:48785
TIME:2629S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd06415604125725141230d1294/9// *//*DRDS /10.3.13.3/eee665ce2c07000/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968641591040101888, 1968641423528398080)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.132:22472
TIME:2622S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604125797824218d0813/9// *//*DRDS /10.3.13.1/eee6663fbc04000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636207288801857924'
,
'1636133947012331607'
,
'1635767482707903022'
,
'1635765405645586192'
,
'1635590359281076528'
,
'1635413053079028613'
,
'1635228343767925052'
,
'1635094680040376309'
,
'1634680662865786683'
,
'1632498725509140532'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:22473
TIME:2626S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604125756254097d0813/9// *//*DRDS /10.3.13.3/eee665fec804001/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1631833022410044938'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.35:65104
TIME:2452S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd16b15604127499047770d06e8/9// *//*DRDS /10.3.13.2/eee670a1e001001/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636203287509216975'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.7:58583
TIME:1105S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0ec15604140960222721d11fb/9// *//*DRDS /10.3.13.3/eee6c2cafc06000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635538522709442346'
,
'1635282931780952654'
,
'1635090688385229669'
,
'1634982202658818977'
,
'1634907686818561094'
,
'1634674012532540867'
,
'1634611124326376710'
,
'1634456637334892017'
,
'1634349347373092595'
,
'1634272157348433572'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:22458
TIME:2419S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604127821886098d069c/9// *//*DRDS /10.3.13.1/eee6729a5400000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636203287509216975'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.209:39653
TIME:2222S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd02715604129798847951d0628/9// *//*DRDS /10.3.13.2/eee67eab5402000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1629135476228103764'
,
'1629129138531994807'
,
'75a5702b_478b_11e9_a971_7cd30ae00894'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.189:55680
TIME:2630S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd10515604125716073701d07eb/9// *//*DRDS /10.3.13.3/eee665c00003000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636185952596537944'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.152:47781
TIME:1399S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0d215604138024851030d11d3/9// *//*DRDS /10.3.13.3/eee6b0e07805000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636204806918931383'
,
'1632947210552393303'
,
'1632324457466967701'
,
'1631632653453110660'
,
'1631384591730254081'
,
'1630708526150073014'
,
'1630384918517298176'
,
'1630020325110482389'
,
'1629952473222353017'
,
'1629921688077476010'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.189:28292
TIME:1709S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd10515604134920526732d07eb/9// *//*DRDS /10.3.13.1/eee69dedf403000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1634240363155693947'
,
'1634239135795393598'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.152:19093
TIME:2116S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0d215604130857944996d11d3/9// *//*DRDS /10.3.13.3/eee685222c05000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636008757670460702'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.209:17444
TIME:1330S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd02715604138710301655d0628/9// *//*DRDS /10.3.13.1/eee6b50f7c02000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636133629268595608'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.35:57594
TIME:2632S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd16b15604125699502926d06e8/9// *//*DRDS /10.3.13.1/eee665a61c01000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1631833022410044938'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.114:50288
TIME:2407S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd06415604127949651147d1294/9// *//*DRDS /10.3.13.1/eee67361f807000/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968641629424733312, 1968641355353999104)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.114:53131
TIME:2624S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd06415604125772111350d1294/9// *//*DRDS /10.3.13.3/eee666179007000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635497733687090160'
,
'1635111939308782075'
,
'1634108632217978348'
,
'1633740163389620933'
,
'1632854333189030775'
,
'1632394511122447482'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:42229
TIME:2419S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604127821076086d069c/9// *//*DRDS /10.3.13.1/eee672991000000/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968641629424733312, 1968641355353999104)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.152:57510
TIME:1717S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0d215604134849076694d11d3/9// *//*DRDS /10.3.13.2/eee69d7e5005000/ */SELECT inv.ORDER_END_TIME,inv.PARK_NAME,inv.PLATE_NUMBER,inv.ACTUAL_PAY,inv.PARK_RECORD_ID,inv.ORDER_TYPE
FROM
(SELECT b.ORDER_END_TIME ORDER_END_TIME,p.PARK_NAME PARK_NAME,b.PLATE_NUMBER PLATE_NUMBER,
b.ACTUAL_PAY ACTUAL_PAY,b.PARK_RECORD_ID PARK_RECORD_ID,e.PARK_RECORD_ID bprid,e.ORDER_TYPE ORDER_TYPE
FROM sa_settlement_b b
INNER JOIN bd_park p
ON b.PARK_ID = p.PARK_ID
LEFT JOIN electronic_invoice e
ON b.PARK_RECORD_ID = e.PARK_RECORD_ID
WHERE b.D = 0
AND b.SHOULD_PAY > 0
AND b.ACTUAL_PAY > 0
AND b.CAR_ID IN
(
1968641591040101888
,
1968641423528398080
)
) inv
WHERE inv.bprid IS NULL
ORDER BY inv.ORDER_END_TIME DESC limit 0,20
========================================================================
USER:elchyeob0
IP:100.104.10.107:7556
TIME:2549S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604126520322913d069c/9// *//*DRDS /10.3.13.1/eee66aa8a400001/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636098809553533660'
,
'1633570916044672796'
,
'1629390557056863165'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.209:18550
TIME:1236S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd02715604139656915142d0628/9// *//*DRDS /10.3.13.3/eee6bad69002000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635544856741820057'
,
'1634910574003370520'
,
'1634290229586175787'
,
'1633642768700027308'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:4842
TIME:2419S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604127821083219d0813/9// *//*DRDS /10.3.13.1/eee672991004001/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968641629424733312, 1968641355353999104)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.7:52120
TIME:1686S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0ec15604135158474021d11fb/9// *//*DRDS /10.3.13.3/eee69f61c006000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635392596411987402'
,
'1634683038695733094'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.7:52428
TIME:2614S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0ec15604125876457135d11fb/9// *//*DRDS /10.3.13.2/eee666ba9806000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636207288801857924'
,
'1636133947012331607'
,
'1635767482707903022'
,
'1635765405645586192'
,
'1635590359281076528'
,
'1635413053079028613'
,
'1635228343767925052'
,
'1635094680040376309'
,
'1634680662865786683'
,
'1632498725509140532'
)
and STATE=1 and D=0
========================================================================
USER:gaochang_group
IP:210.12.140.34:47869
TIME:5746S,
STATE:Sending data
SQL: /* ApplicationName=DataGrip 2018.2.2 */ select count(1)
from invoice_serial iis
left join electronic_invoice ei on iis.INVOICE_NUM = ei.INVOICE_NUM and ei.USER_ID
where 1=1
========================================================================
USER:gaochang_group
IP:210.12.140.34:22494
TIME:5709S,
STATE:Sending data
SQL: /* ApplicationName=DataGrip 2018.2.2 */ select count(1)
from invoice_serial iis
left join electronic_invoice ei on iis.INVOICE_NUM = ei.INVOICE_NUM and ei.USER_ID and ei.D = 0
where 1=1
========================================================================
USER:gaochang_group
IP:210.12.140.34:9771
TIME:5694S,
STATE:Sending data
SQL: /* ApplicationName=DataGrip 2018.2.2 */ select count(1)
from invoice_serial iis
left join electronic_invoice ei on iis.INVOICE_NUM = ei.INVOICE_NUM and ei.USER_ID and ei.D = 0
where 1=1
and iis.D = 0
========================================================================
USER:gaochang_group
IP:210.12.140.34:55004
TIME:5679S,
STATE:Sending data
SQL: /* ApplicationName=DataGrip 2018.2.2 */ select count(1)
from invoice_serial iis
left join electronic_invoice ei on iis.INVOICE_NUM = ei.INVOICE_NUM and ei.D = 0
where 1=1
and iis.D = 0
========================================================================
USER:elchyeob0
IP:100.104.10.189:47907
TIME:2412S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd10515604127898664431d07eb/9// *//*DRDS /10.3.13.2/eee673124c03000/ */SELECT inv.ORDER_END_TIME,inv.PARK_NAME,inv.PLATE_NUMBER,inv.ACTUAL_PAY,inv.PARK_RECORD_ID,inv.ORDER_TYPE
FROM
(SELECT b.ORDER_END_TIME ORDER_END_TIME,p.PARK_NAME PARK_NAME,b.PLATE_NUMBER PLATE_NUMBER,
b.ACTUAL_PAY ACTUAL_PAY,b.PARK_RECORD_ID PARK_RECORD_ID,e.PARK_RECORD_ID bprid,e.ORDER_TYPE ORDER_TYPE
FROM sa_settlement_b b
INNER JOIN bd_park p
ON b.PARK_ID = p.PARK_ID
LEFT JOIN electronic_invoice e
ON b.PARK_RECORD_ID = e.PARK_RECORD_ID
WHERE b.D = 0
AND b.SHOULD_PAY > 0
AND b.ACTUAL_PAY > 0
AND b.CAR_ID IN
(
1968641629424733312
,
1968641355353999104
)
) inv
WHERE inv.bprid IS NULL
ORDER BY inv.ORDER_END_TIME DESC limit 0,10
========================================================================
USER:elchyeob0
IP:100.104.10.189:47908
TIME:1846S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd10515604133557141535d07eb/9// *//*DRDS /10.3.13.3/eee6959ba803000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636207836897776126'
,
'1635548085857845520'
,
'1631655362910226971'
,
'1631470417725105395'
,
'1631381746617424098'
,
'1631289988805042419'
,
'1630565971132430166'
,
'1630475927267845719'
,
'1629755738769340978'
,
'1629297405832739886'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.114:44288
TIME:1956S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd06415604132457906987d1294/9// *//*DRDS /10.3.13.3/eee68ee61c07000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636116571184173418'
,
'1636109438594092148'
,
'1635850438766018477'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:18939
TIME:2132S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604130699047060d0813/9// *//*DRDS /10.3.13.2/eee68429e404000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636008757670460702'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:18940
TIME:2381S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604128206704475d0813/9// *//*DRDS /10.3.13.1/eee674f39c04000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636203287509216975'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:18941
TIME:2163S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604130389316046d0813/9// *//*DRDS /10.3.13.1/eee68245f004000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636199020052361330'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.7:1727
TIME:1507S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0ec15604136945243476d11fb/9// *//*DRDS /10.3.13.1/eee6aa499406000/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968641011756666496)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.35:4927
TIME:1493S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd16b15604137080812797d06e8/9// *//*DRDS /10.3.13.1/eee6ab1d6801000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635576428765387581'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:26945
TIME:2196S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604130056846691d069c/9// *//*DRDS /10.3.13.3/eee6803e7400000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1629135476228103764'
,
'1629129138531994807'
,
'75a5702b_478b_11e9_a971_7cd30ae00894'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:26976
TIME:2217S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604129844656300d069c/9// *//*DRDS /10.3.13.1/eee67ef2e800000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1629135476228103764'
,
'1629129138531994807'
,
'75a5702b_478b_11e9_a971_7cd30ae00894'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.189:48133
TIME:2219S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd10515604129826174527d07eb/9// *//*DRDS /10.3.13.1/eee67ed60803000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1630829887956759079'
,
'1630737866202029263'
,
'ecbd239d_4e94_11e9_a971_7cd30ae00894'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:27068
TIME:1871S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604133303602121d069c/9// *//*DRDS /10.3.13.1/eee6940f8400000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636116571184173418'
,
'1636109438594092148'
,
'1635850438766018477'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.35:5090
TIME:1726S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd16b15604134757562589d06e8/9// *//*DRDS /10.3.13.3/eee69cef5401001/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968641597203858048, 1968641625120968064)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.132:19213
TIME:1672S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604135299074623d0813/9// *//*DRDS /10.3.13.2/eee6a03d7004000/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968640635389415424)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.107:27084
TIME:1793S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604134089045634d069c/9// *//*DRDS /10.3.13.3/eee698dac400000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636188497169647787'
,
'1630682313116355877'
,
'1630670402952899227'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:19232
TIME:2022S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604131790124366d0813/9// *//*DRDS /10.3.13.1/eee68ad2b404000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636008757670460702'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:19233
TIME:1208S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604139932214100d0813/9// *//*DRDS /10.3.13.1/eee6bc84b804000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636204979446363682'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.152:33058
TIME:1667S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0d215604135348018132d11d3/9// *//*DRDS /10.3.13.3/eee6a089e805000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636133629268595608'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.189:48294
TIME:1476S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd10515604137258026261d07eb/9// *//*DRDS /10.3.13.3/eee6ac324c03000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636032710493339721'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:19318
TIME:1409S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604137920625404d0813/9// *//*DRDS /10.3.13.1/eee6b03d9804000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1633584152780472752'
,
'1632856645729028392'
,
'1631480189211947419'
,
'1630142843267849786'
,
'1629416308954137098'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.114:44668
TIME:1849S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd06415604133520412600d1294/9// *//*DRDS /10.3.13.1/eee695624807000/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968640635389415424)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.114:44736
TIME:1389S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd06415604138120588202d1294/9// *//*DRDS /10.3.13.1/eee6b1760c07000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635644850014520068'
,
'1630022121457493516'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:27303
TIME:1685S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604135167963610d069c/9// *//*DRDS /10.3.13.1/eee69f709400000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636033695088388386'
,
'1634124833889459245'
,
'1633491764916520154'
,
'1633291293398405835'
,
'1633114468853517780'
,
'1633041098182004429'
,
'1633040564090845696'
,
'1632018160592895310'
,
'1631474338109597062'
,
'1630294898819210770'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.35:5375
TIME:1629S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd16b15604135720156637d06e8/9// *//*DRDS /10.3.13.1/eee6a2cf6001000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636018528666531774'
,
'1634737897395468545'
,
'1633959842808871636'
,
'1633593018064864451'
,
'1633141807858585794'
,
'1632231972066568666'
,
'1630783935317324060'
,
'1630777670830661989'
,
'89fab88f_4d11_11e9_a971_7cd30ae00894'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.114:44851
TIME:1231S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd06415604139700335336d1294/9// *//*DRDS /10.3.13.2/eee6bb1a6807000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1633007804112451299'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.189:48517
TIME:1682S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd10515604135199807472d07eb/9// *//*DRDS /10.3.13.3/eee69fa25403000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636123527088190193'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.189:48518
TIME:1062S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd10515604141399303850d07eb/9// *//*DRDS /10.3.13.2/eee6c5790c03000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1634118841401348285'
,
'1633647291064648978'
,
'1629792924862518683'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:27384
TIME:1503S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604136981702829d069c/9// *//*DRDS /10.3.13.1/eee6aa828800000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635210890293816942'
,
'1634927827205764057'
,
'1633924553289770340'
,
'1632952994927482608'
,
'1632917866713977888'
,
'1632828435817566023'
,
'1632730314151301263'
,
'1632694069970868971'
,
'1632640241535847369'
,
'1632462096374477925'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:27385
TIME:1679S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604135224194127d069c/9// *//*DRDS /10.3.13.3/eee69fc87000000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635576428765387581'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:27386
TIME:1171S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604140301385523d069c/9// *//*DRDS /10.3.13.1/eee6bec58c00000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636195231743351885'
,
'1636109204557136937'
,
'1635855961368345291'
,
'1635207934344429599'
,
'1634918196480838767'
,
'1634846021600154436'
,
'1629241439857679564'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.152:33329
TIME:1449S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0d215604137520268137d11d3/9// *//*DRDS /10.3.13.1/eee6adcc0c05000/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968640635389415424)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.152:33358
TIME:1472S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0d215604137299247544d11d3/9// *//*DRDS /10.3.13.2/eee6ac72b405000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636192496452156086'
,
'1635742667365156566'
,
'1634827611259546078'
,
'1633023768951555026'
,
'1632932173557279655'
,
'1632832898533958876'
,
'1632682140175994376'
,
'1631841222688512894'
,
'1631675443775014141'
,
'1630478375390806573'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:27443
TIME:1256S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604139457602440d069c/9// *//*DRDS /10.3.13.3/eee6b99f2400000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636204341303972939'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:19651
TIME:1173S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604140282095649d0813/9// *//*DRDS /10.3.13.2/eee6bea76404000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636199917869348230'
,
'1634491303238580090'
,
'1633853291948410914'
,
'1631415436772915282'
,
'bba79101_4af2_11e9_a971_7cd30ae00894'
,
'3e69c98a_49f6_11e9_a971_7cd30ae00894'
,
'23213c55_47a9_11e9_a971_7cd30ae00894'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.7:2365
TIME:1432S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0ec15604137698847486d11fb/9// *//*DRDS /10.3.13.2/eee6aee31406000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635544856741820057'
,
'1634910574003370520'
,
'1634290229586175787'
,
'1633642768700027308'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.35:5535
TIME:1282S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd16b15604139199218925d06e8/9// *//*DRDS /10.3.13.2/eee6b80b6801001/ */SELECT inv.ORDER_END_TIME,inv.PARK_NAME,inv.PLATE_NUMBER,inv.ACTUAL_PAY,inv.PARK_RECORD_ID,inv.ORDER_TYPE
FROM
(SELECT b.ORDER_END_TIME ORDER_END_TIME,p.PARK_NAME PARK_NAME,b.PLATE_NUMBER PLATE_NUMBER,
b.ACTUAL_PAY ACTUAL_PAY,b.PARK_RECORD_ID PARK_RECORD_ID,e.PARK_RECORD_ID bprid,e.ORDER_TYPE ORDER_TYPE
FROM sa_settlement_b b
INNER JOIN bd_park p
ON b.PARK_ID = p.PARK_ID
LEFT JOIN electronic_invoice e
ON b.PARK_RECORD_ID = e.PARK_RECORD_ID
WHERE b.D = 0
AND b.SHOULD_PAY > 0
AND b.ACTUAL_PAY > 0
AND b.CAR_ID IN
(
1968641493868874496
,
1968641560713595136
)
) inv
WHERE inv.bprid IS NULL
ORDER BY inv.ORDER_END_TIME DESC limit 0,20
========================================================================
USER:elchyeob0
IP:100.104.10.209:33436
TIME:1187S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd02715604140146246910d0628/9// *//*DRDS /10.3.13.2/eee6bdd32402000/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968641563114669824)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.152:33483
TIME:906S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0d215604142956924104d11d3/9// *//*DRDS /10.3.13.3/eee6cefad405000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1634404666832859672'
,
'1632588582409480405'
,
'1631747731762479822'
,
'1630305745067061428'
,
'1630031309213545388'
,
'1629864231745631236'
,
'1629318261907664695'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.189:48674
TIME:1201S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd10515604140009597980d07eb/9// *//*DRDS /10.3.13.1/eee6bcfda003000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'875b9deb_4ef1_11e9_a971_7cd30ae00894'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.7:2401
TIME:1449S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0ec15604137520156455d11fb/9// *//*DRDS /10.3.13.1/eee6adcbe006001/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636032710493339721'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.7:2407
TIME:1276S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0ec15604139257055882d11fb/9// *//*DRDS /10.3.13.3/eee6b865c806000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1634378595023458825'
,
'1632774304346179560'
,
'1630385441183108051'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.7:2413
TIME:892S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0ec15604143090351189d11fb/9// *//*DRDS /10.3.13.3/eee6cfcb5006000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636033695088388386'
,
'1634124833889459245'
,
'1633491764916520154'
,
'1633291293398405835'
,
'1633114468853517780'
,
'1633041098182004429'
,
'1633040564090845696'
,
'1632018160592895310'
,
'1631474338109597062'
,
'1630294898819210770'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.7:2414
TIME:1196S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0ec15604140057308181d11fb/9// *//*DRDS /10.3.13.3/eee6bd482806000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1634118841401348285'
,
'1633647291064648978'
,
'1629792924862518683'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.189:48693
TIME:746S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd10515604144556198200d07eb/9// *//*DRDS /10.3.13.1/eee6d8bdb003000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635544856741820057'
,
'1634910574003370520'
,
'1634290229586175787'
,
'1633642768700027308'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.152:33519
TIME:1332S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0d215604138696783141d11d3/9// *//*DRDS /10.3.13.1/eee6b4fa5c05001/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1634381182255765799'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.114:45085
TIME:571S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd06415604146302513926d1294/9// *//*DRDS /10.3.13.1/eee6e3665007000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1629029509670903734'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.152:33561
TIME:993S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0d215604142088707971d11d3/9// *//*DRDS /10.3.13.2/eee6c9ae3c05000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'30e6d161_4a10_11e9_a971_7cd30ae00894'
,
'05b89735_49f7_11e9_a971_7cd30ae00894'
,
'75c90d46_49f6_11e9_a971_7cd30ae00894'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.152:33562
TIME:1208S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0d215604139932077663d11d3/9// *//*DRDS /10.3.13.1/eee6bc848005000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635999483954213572'
,
'1635932839132301959'
,
'1635392599303960028'
,
'1635094785155936040'
,
'1634848527351842467'
,
'1632237041713460807'
,
'1630563927061443349'
,
'a75befc7_4ae4_11e9_a971_7cd30ae00894'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.152:33594
TIME:829S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0d215604143724346778d11d3/9// *//*DRDS /10.3.13.3/eee6d3a9ec05000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635998839517218525'
,
'1635908627685445261'
,
'1635756328131498547'
,
'1635364716451730600'
,
'1635274509219017289'
,
'1635098064443152518'
,
'1635002793301383311'
,
'1634911933194866056'
,
'1634727355389873017'
,
'1634636692411387155'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:19816
TIME:1175S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604140263325506d0813/9// *//*DRDS /10.3.13.2/eee6be8a1404000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1634118841401348285'
,
'1633647291064648978'
,
'1629792924862518683'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.35:5696
TIME:595S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd16b15604146064264877d06e8/9// *//*DRDS /10.3.13.1/eee6e1f20c01000/ */SELECT count(*) FROM (SELECT b.ORDER_END_TIME ORDER_END_TIME, p.PARK_NAME PARK_NAME, b.PLATE_NUMBER PLATE_NUMBER, b.ACTUAL_PAY ACTUAL_PAY, b.PARK_RECORD_ID PARK_RECORD_ID, e.PARK_RECORD_ID bprid, e.ORDER_TYPE ORDER_TYPE FROM sa_settlement_b b INNER JOIN bd_park p ON b.PARK_ID = p.PARK_ID LEFT JOIN electronic_invoice e ON b.PARK_RECORD_ID = e.PARK_RECORD_ID WHERE b.D = 0 AND b.SHOULD_PAY > 0 AND b.ACTUAL_PAY > 0 AND b.CAR_ID IN (1968641593997135872)) inv WHERE inv.bprid IS NULL
========================================================================
USER:elchyeob0
IP:100.104.10.209:33621
TIME:736S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd02715604144658144528d0628/9// *//*DRDS /10.3.13.3/eee6d95cfc02001/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635996961879375632'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:27713
TIME:902S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604142999125717d069c/9// *//*DRDS /10.3.13.2/eee6cf3cc400000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635549512881676219'
,
'1634096444153577304'
,
'1633371937464943144'
,
'1631935956373257829'
,
'1629957672741680733'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.107:27724
TIME:740S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd05515604144617332922d069c/9// *//*DRDS /10.3.13.1/eee6d91d3800000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1634381182255765799'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:19902
TIME:1029S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604141721373741d0813/9// *//*DRDS /10.3.13.1/eee6c7704404000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635034853369970856'
,
'1635010746068772027'
,
'1634947450071455937'
,
'1633318174885714430'
,
'1631855108637634848'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.132:19903
TIME:771S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd0cd15604144304686311d0813/9// *//*DRDS /10.3.13.2/eee6d734b404000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1636008955640550285'
,
'1635490645130878068'
,
'1634850502708609011'
,
'1634017878246166710'
,
'1634017787910293107'
,
'1630315392094180219'
,
'c1c27cc8_4ab7_11e9_a971_7cd30ae00894'
,
'a14ef404_4a05_11e9_a971_7cd30ae00894'
,
'906eac40_4852_11e9_a971_7cd30ae00894'
)
and STATE=1 and D=0
========================================================================
USER:elchyeob0
IP:100.104.10.189:48897
TIME:1104S,
STATE:Waiting for table metadata lock
SQL: /* 0afbd10515604140979472686d07eb/9// *//*DRDS /10.3.13.3/eee6c2e91003000/ */select INVOICE_ID,PARK_RECORD_ID,INVOICE_NUM,INVOICE_WAY,PAY_TYPE,MONEY,CREATE_TIME,STATE,order_type,USER_ID,PHONE_NUMBER
from electronic_invoice
where PARK_RECORD_ID in
(
'1635034853369970856'
,
'1635010746068772027'
,
'1634947450071455937'
,
'1633318174885714430'
,
'1631855108637634848'
)
and STATE=1 and D=0