Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL LOG While debugging line by line!
- getOne()
- 151020 14:56:43 1549 Query set session transaction read only
- 1549 Query SET autocommit=0
- 1549 Query commit
- 1549 Query SET autocommit=1
- 1549 Query select @@session.tx_read_only
- 1549 Query set session transaction read write
- 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
- 1549 Query SHOW WARNINGS
- findOne()
- 151020 14:55:19 1539 Query set session transaction read only
- 1539 Query SET autocommit=0
- 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
- 1539 Query SHOW WARNINGS
- 1539 Query commit
- 1539 Query SET autocommit=1
- 1539 Query select @@session.tx_read_only
- 1539 Query set session transaction read write
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement