LOG:  duration: 125.000 ms  parse S_3324:
 select odpaymente0_.id as id66_, odpaymente0_.ASObject as ASObject66_, odpaymente0_.id_baseCurrency as id3_66_, odpaymente0_.id_currency as id4_66_, odpaymente0_.dateCommit as dateCommit66_, odpaymente0_.dateCreate as dateCreate66_, odpaymente0_.numberField as numberFi7_66_, odpaymente0_.originalPaymentNumber as original8_66_, odpaymente0_.paymentClass as paymentC9_66_, odpaymente0_.paymentStatus as payment10_66_, odpaymente0_.paymentType as payment11_66_, odpaymente0_.id_Purchase as id15_66_, odpaymente0_.success_processed as success12_66_, odpaymente0_.sumPay as sumPay66_, odpaymente0_.sumPayBaseCurrency as sumPayB14_66_, odpaymente0_1_.amount as amount123_, odpaymente0_1_.authcode as authcode123_, odpaymente0_1_.bank_type as bank3_123_, odpaymente0_1_.bankid as bankid123_, odpaymente0_1_.card_hash as card5_123_, odpaymente0_1_.cardType as cardType123_, odpaymente0_1_.cardnumber as cardnumber123_, odpaymente0_1_.cashtransdate as cashtran8_123_, odpaymente0_1_.cashtransid as cashtran9_123_, odpaymente0_1_.hostTransId as hostTra10_123_, odpaymente0_1_.merchantid as merchantid123_, odpaymente0_1_.message as message123_, odpaymente0_1_.operationCode as operati13_123_, odpaymente0_1_.refNumber as refNumber123_, odpaymente0_1_.responseCode as respons15_123_, odpaymente0_1_.resultCode as resultCode123_, odpaymente0_1_.status as status123_, odpaymente0_1_.terminalid as terminalid123_, odpaymente0_3_.accountId as accountId129_, odpaymente0_3_.accountType as accountT2_129_, odpaymente0_3_.authCode as authCode129_, odpaymente0_3_.cancelBonuses as cancelBo4_129_, odpaymente0_3_.cardNumber as cardNumber129_, odpaymente0_4_.card_number as card1_131_, odpaymente0_4_.partner_id as partner2_131_, odpaymente0_4_.terminal_id as terminal3_131_, odpaymente0_4_.transaction_id as transact4_131_, odpaymente0_5_.ChangeCash as ChangeCash132_, odpaymente0_6_.datetime_act as datetime1_135_, odpaymente0_6_.slip_act as slip2_135_, odpaymente0_6_.id_trans_act as id3_135_, odpaymente0_6_.balance as balance135_, odpaymente0_6_.clientID as clientID135_, odpaymente0_6_.clientIDType as clientID6_135_, odpaymente0_6_.datetime_deact as datetime7_135_, odpaymente0_6_.slip_deact as slip8_135_, odpaymente0_6_.id_trans_deact as id9_135_, odpaymente0_6_.location as location135_, odpaymente0_6_.online_deact as online11_135_, odpaymente0_6_.partnerID as partnerID135_, odpaymente0_6_.terminal as terminal135_, odpaymente0_7_.activationDateTime as activati1_137_, odpaymente0_7_.activationSlip as activati2_137_, odpaymente0_7_.activationTransactionID as activati3_137_, odpaymente0_7_.balance as balance137_, odpaymente0_7_.clientID as clientID137_, odpaymente0_7_.clientIDType as clientID6_137_, odpaymente0_7_.deactivationDateTime as deactiva7_137_, odpaymente0_7_.deactivationSlip as deactiva8_137_, odpaymente0_7_.deactivationTransactionID as deactiva9_137_, odpaymente0_7_.location as location137_, odpaymente0_7_.online_deact as online11_137_, odpaymente0_7_.partnerID as partnerID137_, odpaymente0_7_.terminal as terminal137_, odpaymente0_8_.bank as bank139_, odpaymente0_8_.bankProduct as bankProd2_139_, odpaymente0_8_.contractNum as contract3_139_, odpaymente0_8_.FIO as FIO139_, odpaymente0_9_.amount as amount141_, odpaymente0_9_.authCode as authCode141_, odpaymente0_9_.cardNumberTail as cardNumb3_141_, odpaymente0_9_.checkNumber as checkNum4_141_, odpaymente0_10_.amountCard as amountCard142_, odpaymente0_10_.cardNumber as cardNumber142_, odpaymente0_11_.cancelBonuses as cancelBo1_147_, odpaymente0_11_.cardNumber as cardNumber147_, case when odpaymente0_2_.id is not null then 2 when odpaymente0_1_.id is not null then 1 when odpaymente0_3_.id is not null then 3 when odpaymente0_4_.id is not null then 4 when odpaymente0_5_.id is not null then 5 when odpaymente0_6_.id is not null then 6 when odpaymente0_7_.id is not null then 7 when odpaymente0_8_.id is not null then 8 when odpaymente0_9_.id is not null then 9 when odpaymente0_10_.id is not null then 10 when odpaymente0_11_.id is not null then 11 when odpaymente0_.id is not null then 0 end as clazz_ 
from OD_Payment odpaymente0_ 
left outer join od_bankcardpayment odpaymente0_1_ on odpaymente0_.id=odpaymente0_1_.id
left outer join od_childrencardpayment odpaymente0_2_ on odpaymente0_.id=odpaymente0_2_.id 
left outer join od_payment_bonus_card odpaymente0_3_ on odpaymente0_.id=odpaymente0_3_.id 
left outer join od_payment_bonus_sberbank odpaymente0_4_ on odpaymente0_.id=odpaymente0_4_.id
left outer join OD_CashPayment odpaymente0_5_ on odpaymente0_.id=odpaymente0_5_.id 
left outer join od_payment_cft_gift_card odpaymente0_6_ on odpaymente0_.id=odpaymente0_6_.id
left outer join od_payment_cft_gift_egc odpaymente0_7_ on odpaymente0_.id=odpaymente0_7_.id
left outer join od_payment_consumer_credit odpaymente0_8_ on odpaymente0_.id=odpaymente0_8_.id
left outer join od_payment_external_bank_terminal odpaymente0_9_ on odpaymente0_.id=odpaymente0_9_.id
left outer join od_payment_gift_card odpaymente0_10_ on odpaymente0_.id=odpaymente0_10_.id 
left outer join od_payment_siebel_bonus_card odpaymente0_11_ on odpaymente0_.id=odpaymente0_11_.id 
where (odpaymente0_.paymentClass in ($1 , $2)) and (odpaymente0_.id_Purchase in ($3 , $4))

duration: 204.000 ms  bind <s_635>
select *
 from in_files  
 where status=$1 
 order by receive_date 
 limit $2
[BIND] DETAIL:  parameters: $1 = '0', $2 = '100'

 [vxid:149/121022 txid:0] [PARSE] LOG:  duration: 422.000 ms  parse S_2: select distinct advertisea0_.id as id307_, advertisea0_.cash_number as cash2_307_, advertisea0_.file_name as file3_307_, advertisea0_.import_date as import4_307_, advertisea0_.objects_count as objects5_307_, advertisea0_.shop_number as shop6_307_ from discounts_file_for_cashes advertisea0_ where (advertisea0_.cash_number is null or advertisea0_.cash_number=$1) and (advertisea0_.shop_number is null or advertisea0_.shop_number=$2) and advertisea0_.id>$3
[vxid:315/191690 txid:0] [PARSE] LOG:  duration: 110.000 ms  parse <unnamed>: select min(trsfilepac0_.packet_id) as col_0_0_ from trs_file_packets_for_send trsfilepac0_ where trsfilepac0_.data_type=$1 and trsfilepac0_.shop_number=$2 and trsfilepac0_.cash_number=$3 and trsfilepac0_.packet_id>$4 limit $5
[vxid:213/499 txid:0] [PARSE] LOG:  duration: 563.000 ms  parse <unnamed>: select trsfilelas0_.cash_number as cash1_514_0_, trsfilelas0_.data_type as data2_514_0_, trsfilelas0_.shop_number as shop3_514_0_, trsfilelas0_.packet_id as packet4_514_0_ from trs_file_packets_last trsfilelas0_ where trsfilelas0_.cash_number=$1 and trsfilelas0_.data_type=$2 and trsfilelas0_.shop_number=$3
[vxid:422/117930 txid:0] [PARSE] LOG:  duration: 672.000 ms  parse <unnamed>: select trsfilelas0_.cash_number as cash1_514_0_, trsfilelas0_.data_type as data2_514_0_, trsfilelas0_.shop_number as shop3_514_0_, trsfilelas0_.packet_id as packet4_514_0_ from trs_file_packets_last trsfilelas0_ where trsfilelas0_.cash_number=$1 and trsfilelas0_.data_type=$2 and trsfilelas0_.shop_number=$3
[vxid:316/152196 txid:0] [PARSE] LOG:  duration: 625.000 ms  parse <unnamed>: select trsfilelas0_.cash_number as cash1_514_0_, trsfilelas0_.data_type as data2_514_0_, trsfilelas0_.shop_number as shop3_514_0_, trsfilelas0_.packet_id as packet4_514_0_ from trs_file_packets_last trsfilelas0_ where trsfilelas0_.cash_number=$1 and trsfilelas0_.data_type=$2 and trsfilelas0_.shop_number=$3
[vxid:204/11093 txid:0] [PARSE] LOG:  duration: 547.000 ms  parse <unnamed>: select trsfilelas0_.cash_number as cash1_514_0_, trsfilelas0_.data_type as data2_514_0_, trsfilelas0_.shop_number as shop3_514_0_, trsfilelas0_.packet_id as packet4_514_0_ from trs_file_packets_last trsfilelas0_ where trsfilelas0_.cash_number=$1 and trsfilelas0_.data_type=$2 and trsfilelas0_.shop_number=$3
[vxid:108/50676 txid:0] [PARSE] LOG:  duration: 500.000 ms  parse S_2: select distinct advertisea0_.id as id307_, advertisea0_.cash_number as cash2_307_, advertisea0_.file_name as file3_307_, advertisea0_.import_date as import4_307_, advertisea0_.objects_count as objects5_307_, advertisea0_.shop_number as shop6_307_ from discounts_file_for_cashes advertisea0_ where (advertisea0_.cash_number is null or advertisea0_.cash_number=$1) and (advertisea0_.shop_number is null or advertisea0_.shop_number=$2) and advertisea0_.id>$3 
[vxid:490/281239 txid:0] [BIND] LOG:  duration: 110.000 ms  bind <unnamed>: select min(trsfilepac0_.packet_id) as col_0_0_ from trs_file_packets_for_send trsfilepac0_ where trsfilepac0_.data_type=$1 and trsfilepac0_.shop_number=$2 and trsfilepac0_.cash_number=$3 and trsfilepac0_.packet_id>$4 limit $5
[vxid:490/281239 txid:0] [BIND] DETAIL:  parameters: $1 = 'CASH_TEMPLATE', $2 = '24', $3 = '3', $4 = '574', $5 = '2'
[vxid:447/449 txid:0] [BIND] LOG:  duration: 110.000 ms  bind <unnamed>: select min(trsfilepac0_.packet_id) as col_0_0_ from trs_file_packets_for_send trsfilepac0_ where trsfilepac0_.data_type=$1 and trsfilepac0_.shop_number=$2 and trsfilepac0_.cash_number=$3 and trsfilepac0_.packet_id>$4 limit $5
[vxid:447/449 txid:0] [BIND] DETAIL:  parameters: $1 = 'cards_props', $2 = '117', $3 = '1', $4 = '24', $5 = '2'