Advertisement
Guest User

Untitled

a guest
Oct 20th, 2015
544
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 4.66 KB | None | 0 0
  1. SQL LOG While debugging line by line!
  2.  
  3. getOne()
  4. 151020 14:56:43  1549 Query set session transaction read only
  5.          1549 Query SET autocommit=0
  6.          1549 Query commit
  7.          1549 Query SET autocommit=1
  8.          1549 Query select @@session.tx_read_only
  9.          1549 Query set session transaction read write
  10.          1549 Query select flight0_.id as id1_4_0_, flight0_.airline_id as airline11_4_0_, flight0_.arrival_airport_id as arrival12_4_0_, flight0_.arrival_date as arrival_2_4_0_, flight0_.arrival_gate as arrival_3_4_0_, flight0_.arrival_terminal as arrival_4_4_0_, flight0_.departure_airport_id as departu13_4_0_, flight0_.departure_date as departur5_4_0_, flight0_.departure_gate as departur6_4_0_, flight0_.departure_terminal as departur7_4_0_, flight0_.flight_number as flight_n8_4_0_, flight0_.flight_status_id as flight_14_4_0_, flight0_.new_arrival_date as new_arri9_4_0_, flight0_.new_departure_date as new_dep10_4_0_, airline1_.id as id1_0_1_, airline1_.iata_code as iata_cod2_0_1_, airline1_.icao_code as icao_cod3_0_1_, airline1_.name as name4_0_1_, airline1_.phone_number as phone_nu5_0_1_, airport2_.id as id1_1_2_, airport2_.active as active2_1_2_, airport2_.address as address3_1_2_, airport2_.city as city4_1_2_, airport2_.city_code as city_cod5_1_2_, airport2_.country as country6_1_2_, airport2_.gps_coordinates as gps_coor7_1_2_, airport2_.iata_code as iata_cod8_1_2_, airport2_.name as name9_1_2_, airport2_.region as region10_1_2_, airport2_.state as state11_1_2_, airport2_.timezone as timezon12_1_2_, airport3_.id as id1_1_3_, airport3_.active as active2_1_3_, airport3_.address as address3_1_3_, airport3_.city as city4_1_3_, airport3_.city_code as city_cod5_1_3_, airport3_.country as country6_1_3_, airport3_.gps_coordinates as gps_coor7_1_3_, airport3_.iata_code as iata_cod8_1_3_, airport3_.name as name9_1_3_, airport3_.region as region10_1_3_, airport3_.state as state11_1_3_, airport3_.timezone as timezon12_1_3_, flightstat4_.id as id1_6_4_, flightstat4_.code as code2_6_4_, flightstat4_.description as descript3_6_4_ from flight flight0_ inner join airline airline1_ on flight0_.airline_id=airline1_.id inner join airport airport2_ on flight0_.arrival_airport_id=airport2_.id inner join airport airport3_ on flight0_.departure_airport_id=airport3_.id inner join flight_status flightstat4_ on flight0_.flight_status_id=flightstat4_.id where flight0_.id=6
  11.          1549 Query SHOW WARNINGS
  12.  
  13.  
  14. findOne()
  15. 151020 14:55:19  1539 Query set session transaction read only
  16.          1539 Query SET autocommit=0
  17.          1539 Query select flight0_.id as id1_4_0_, flight0_.airline_id as airline11_4_0_, flight0_.arrival_airport_id as arrival12_4_0_, flight0_.arrival_date as arrival_2_4_0_, flight0_.arrival_gate as arrival_3_4_0_, flight0_.arrival_terminal as arrival_4_4_0_, flight0_.departure_airport_id as departu13_4_0_, flight0_.departure_date as departur5_4_0_, flight0_.departure_gate as departur6_4_0_, flight0_.departure_terminal as departur7_4_0_, flight0_.flight_number as flight_n8_4_0_, flight0_.flight_status_id as flight_14_4_0_, flight0_.new_arrival_date as new_arri9_4_0_, flight0_.new_departure_date as new_dep10_4_0_, airline1_.id as id1_0_1_, airline1_.iata_code as iata_cod2_0_1_, airline1_.icao_code as icao_cod3_0_1_, airline1_.name as name4_0_1_, airline1_.phone_number as phone_nu5_0_1_, airport2_.id as id1_1_2_, airport2_.active as active2_1_2_, airport2_.address as address3_1_2_, airport2_.city as city4_1_2_, airport2_.city_code as city_cod5_1_2_, airport2_.country as country6_1_2_, airport2_.gps_coordinates as gps_coor7_1_2_, airport2_.iata_code as iata_cod8_1_2_, airport2_.name as name9_1_2_, airport2_.region as region10_1_2_, airport2_.state as state11_1_2_, airport2_.timezone as timezon12_1_2_, airport3_.id as id1_1_3_, airport3_.active as active2_1_3_, airport3_.address as address3_1_3_, airport3_.city as city4_1_3_, airport3_.city_code as city_cod5_1_3_, airport3_.country as country6_1_3_, airport3_.gps_coordinates as gps_coor7_1_3_, airport3_.iata_code as iata_cod8_1_3_, airport3_.name as name9_1_3_, airport3_.region as region10_1_3_, airport3_.state as state11_1_3_, airport3_.timezone as timezon12_1_3_, flightstat4_.id as id1_6_4_, flightstat4_.code as code2_6_4_, flightstat4_.description as descript3_6_4_ from flight flight0_ inner join airline airline1_ on flight0_.airline_id=airline1_.id inner join airport airport2_ on flight0_.arrival_airport_id=airport2_.id inner join airport airport3_ on flight0_.departure_airport_id=airport3_.id inner join flight_status flightstat4_ on flight0_.flight_status_id=flightstat4_.id where flight0_.id=6
  18.          1539 Query SHOW WARNINGS
  19.          1539 Query commit
  20.          1539 Query SET autocommit=1
  21.          1539 Query select @@session.tx_read_only
  22.          1539 Query set session transaction read write
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement