Advertisement
Guest User

Query log

a guest
May 15th, 2012
165
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 12.66 KB | None | 0 0
  1. Query 'from Hotel': started
  2. Query 'from Hotel': 1st run (pilot)
  3. Hibernate: select hotel0_.id as id1_, hotel0_.airport as airport1_, hotel0_.carHire as carHire1_, hotel0_.casino as casino1_, hotel0_.checkIn as checkIn1_, hotel0_.checkOutEnd as checkOut6_1_, hotel0_.checkOutStart as checkOut7_1_, hotel0_.city as city1_, hotel0_.country as country1_, hotel0_.currentVersionind as current10_1_, hotel0_.distanceToAirport as distanc11_1_, hotel0_.fitnessCentre as fitness12_1_, hotel0_.indoorPool as indoorPool1_, hotel0_.latitude as latitude1_, hotel0_.laundry as laundry1_, hotel0_.longitude as longitude1_, hotel0_.name as name1_, hotel0_.opened as opened1_, hotel0_.outdoorPool as outdoor19_1_, hotel0_.parking as parking1_, hotel0_.parkingSpace as parking21_1_, hotel0_.petsAllowed as petsAll22_1_, hotel0_.priceValue as priceValue1_, hotel0_.priority as priority1_, hotel0_.sauna as sauna1_, hotel0_.storeys as storeys1_, hotel0_.summary as summary1_, hotel0_.version as version1_, hotel0_.wifi as wifi1_ from Hotel hotel0_
  4. took 2079ms.
  5. Query 'from Hotel': 1
  6. Hibernate: select hotel0_.id as id1_, hotel0_.airport as airport1_, hotel0_.carHire as carHire1_, hotel0_.casino as casino1_, hotel0_.checkIn as checkIn1_, hotel0_.checkOutEnd as checkOut6_1_, hotel0_.checkOutStart as checkOut7_1_, hotel0_.city as city1_, hotel0_.country as country1_, hotel0_.currentVersionind as current10_1_, hotel0_.distanceToAirport as distanc11_1_, hotel0_.fitnessCentre as fitness12_1_, hotel0_.indoorPool as indoorPool1_, hotel0_.latitude as latitude1_, hotel0_.laundry as laundry1_, hotel0_.longitude as longitude1_, hotel0_.name as name1_, hotel0_.opened as opened1_, hotel0_.outdoorPool as outdoor19_1_, hotel0_.parking as parking1_, hotel0_.parkingSpace as parking21_1_, hotel0_.petsAllowed as petsAll22_1_, hotel0_.priceValue as priceValue1_, hotel0_.priority as priority1_, hotel0_.sauna as sauna1_, hotel0_.storeys as storeys1_, hotel0_.summary as summary1_, hotel0_.version as version1_, hotel0_.wifi as wifi1_ from Hotel hotel0_
  7. took 1606ms.
  8. Query 'from Hotel': 2
  9. Hibernate: select hotel0_.id as id1_, hotel0_.airport as airport1_, hotel0_.carHire as carHire1_, hotel0_.casino as casino1_, hotel0_.checkIn as checkIn1_, hotel0_.checkOutEnd as checkOut6_1_, hotel0_.checkOutStart as checkOut7_1_, hotel0_.city as city1_, hotel0_.country as country1_, hotel0_.currentVersionind as current10_1_, hotel0_.distanceToAirport as distanc11_1_, hotel0_.fitnessCentre as fitness12_1_, hotel0_.indoorPool as indoorPool1_, hotel0_.latitude as latitude1_, hotel0_.laundry as laundry1_, hotel0_.longitude as longitude1_, hotel0_.name as name1_, hotel0_.opened as opened1_, hotel0_.outdoorPool as outdoor19_1_, hotel0_.parking as parking1_, hotel0_.parkingSpace as parking21_1_, hotel0_.petsAllowed as petsAll22_1_, hotel0_.priceValue as priceValue1_, hotel0_.priority as priority1_, hotel0_.sauna as sauna1_, hotel0_.storeys as storeys1_, hotel0_.summary as summary1_, hotel0_.version as version1_, hotel0_.wifi as wifi1_ from Hotel hotel0_
  10. took 1464ms.
  11. Query 'from Hotel': 3
  12. Hibernate: select hotel0_.id as id1_, hotel0_.airport as airport1_, hotel0_.carHire as carHire1_, hotel0_.casino as casino1_, hotel0_.checkIn as checkIn1_, hotel0_.checkOutEnd as checkOut6_1_, hotel0_.checkOutStart as checkOut7_1_, hotel0_.city as city1_, hotel0_.country as country1_, hotel0_.currentVersionind as current10_1_, hotel0_.distanceToAirport as distanc11_1_, hotel0_.fitnessCentre as fitness12_1_, hotel0_.indoorPool as indoorPool1_, hotel0_.latitude as latitude1_, hotel0_.laundry as laundry1_, hotel0_.longitude as longitude1_, hotel0_.name as name1_, hotel0_.opened as opened1_, hotel0_.outdoorPool as outdoor19_1_, hotel0_.parking as parking1_, hotel0_.parkingSpace as parking21_1_, hotel0_.petsAllowed as petsAll22_1_, hotel0_.priceValue as priceValue1_, hotel0_.priority as priority1_, hotel0_.sauna as sauna1_, hotel0_.storeys as storeys1_, hotel0_.summary as summary1_, hotel0_.version as version1_, hotel0_.wifi as wifi1_ from Hotel hotel0_
  13. took 1514ms.
  14. Query 'from Hotel': 4
  15. Hibernate: select hotel0_.id as id1_, hotel0_.airport as airport1_, hotel0_.carHire as carHire1_, hotel0_.casino as casino1_, hotel0_.checkIn as checkIn1_, hotel0_.checkOutEnd as checkOut6_1_, hotel0_.checkOutStart as checkOut7_1_, hotel0_.city as city1_, hotel0_.country as country1_, hotel0_.currentVersionind as current10_1_, hotel0_.distanceToAirport as distanc11_1_, hotel0_.fitnessCentre as fitness12_1_, hotel0_.indoorPool as indoorPool1_, hotel0_.latitude as latitude1_, hotel0_.laundry as laundry1_, hotel0_.longitude as longitude1_, hotel0_.name as name1_, hotel0_.opened as opened1_, hotel0_.outdoorPool as outdoor19_1_, hotel0_.parking as parking1_, hotel0_.parkingSpace as parking21_1_, hotel0_.petsAllowed as petsAll22_1_, hotel0_.priceValue as priceValue1_, hotel0_.priority as priority1_, hotel0_.sauna as sauna1_, hotel0_.storeys as storeys1_, hotel0_.summary as summary1_, hotel0_.version as version1_, hotel0_.wifi as wifi1_ from Hotel hotel0_
  16. took 1555ms.
  17. Query 'from Hotel': 5
  18. Hibernate: select hotel0_.id as id1_, hotel0_.airport as airport1_, hotel0_.carHire as carHire1_, hotel0_.casino as casino1_, hotel0_.checkIn as checkIn1_, hotel0_.checkOutEnd as checkOut6_1_, hotel0_.checkOutStart as checkOut7_1_, hotel0_.city as city1_, hotel0_.country as country1_, hotel0_.currentVersionind as current10_1_, hotel0_.distanceToAirport as distanc11_1_, hotel0_.fitnessCentre as fitness12_1_, hotel0_.indoorPool as indoorPool1_, hotel0_.latitude as latitude1_, hotel0_.laundry as laundry1_, hotel0_.longitude as longitude1_, hotel0_.name as name1_, hotel0_.opened as opened1_, hotel0_.outdoorPool as outdoor19_1_, hotel0_.parking as parking1_, hotel0_.parkingSpace as parking21_1_, hotel0_.petsAllowed as petsAll22_1_, hotel0_.priceValue as priceValue1_, hotel0_.priority as priority1_, hotel0_.sauna as sauna1_, hotel0_.storeys as storeys1_, hotel0_.summary as summary1_, hotel0_.version as version1_, hotel0_.wifi as wifi1_ from Hotel hotel0_
  19. took 1409ms.
  20. Query 'from Hotel': average time = 1509.6ms.
  21. Query 'select * from Hotel': started
  22. Query 'select * from Hotel': 1st run (pilot)
  23. took 1176ms.
  24. Query 'select * from Hotel': 1
  25. took 1075ms.
  26. Query 'select * from Hotel': 2
  27. took 1075ms.
  28. Query 'select * from Hotel': 3
  29. took 1075ms.
  30. Query 'select * from Hotel': 4
  31. took 1075ms.
  32. Query 'select * from Hotel': 5
  33. took 1075ms.
  34. Query 'select * from Hotel': average time = 1075.0ms.
  35. Query 'from Hotel': started
  36. Query 'from Hotel': 1st run (pilot)
  37. Hibernate: select hotel0_.id as id1_, hotel0_.airport as airport1_, hotel0_.carHire as carHire1_, hotel0_.casino as casino1_, hotel0_.checkIn as checkIn1_, hotel0_.checkOutEnd as checkOut6_1_, hotel0_.checkOutStart as checkOut7_1_, hotel0_.city as city1_, hotel0_.country as country1_, hotel0_.currentVersionind as current10_1_, hotel0_.distanceToAirport as distanc11_1_, hotel0_.fitnessCentre as fitness12_1_, hotel0_.indoorPool as indoorPool1_, hotel0_.latitude as latitude1_, hotel0_.laundry as laundry1_, hotel0_.longitude as longitude1_, hotel0_.name as name1_, hotel0_.opened as opened1_, hotel0_.outdoorPool as outdoor19_1_, hotel0_.parking as parking1_, hotel0_.parkingSpace as parking21_1_, hotel0_.petsAllowed as petsAll22_1_, hotel0_.priceValue as priceValue1_, hotel0_.priority as priority1_, hotel0_.sauna as sauna1_, hotel0_.storeys as storeys1_, hotel0_.summary as summary1_, hotel0_.version as version1_, hotel0_.wifi as wifi1_ from Hotel hotel0_
  38. took 1666ms.
  39. Query 'from Hotel': 1
  40. Hibernate: select hotel0_.id as id1_, hotel0_.airport as airport1_, hotel0_.carHire as carHire1_, hotel0_.casino as casino1_, hotel0_.checkIn as checkIn1_, hotel0_.checkOutEnd as checkOut6_1_, hotel0_.checkOutStart as checkOut7_1_, hotel0_.city as city1_, hotel0_.country as country1_, hotel0_.currentVersionind as current10_1_, hotel0_.distanceToAirport as distanc11_1_, hotel0_.fitnessCentre as fitness12_1_, hotel0_.indoorPool as indoorPool1_, hotel0_.latitude as latitude1_, hotel0_.laundry as laundry1_, hotel0_.longitude as longitude1_, hotel0_.name as name1_, hotel0_.opened as opened1_, hotel0_.outdoorPool as outdoor19_1_, hotel0_.parking as parking1_, hotel0_.parkingSpace as parking21_1_, hotel0_.petsAllowed as petsAll22_1_, hotel0_.priceValue as priceValue1_, hotel0_.priority as priority1_, hotel0_.sauna as sauna1_, hotel0_.storeys as storeys1_, hotel0_.summary as summary1_, hotel0_.version as version1_, hotel0_.wifi as wifi1_ from Hotel hotel0_
  41. took 1436ms.
  42. Query 'from Hotel': 2
  43. Hibernate: select hotel0_.id as id1_, hotel0_.airport as airport1_, hotel0_.carHire as carHire1_, hotel0_.casino as casino1_, hotel0_.checkIn as checkIn1_, hotel0_.checkOutEnd as checkOut6_1_, hotel0_.checkOutStart as checkOut7_1_, hotel0_.city as city1_, hotel0_.country as country1_, hotel0_.currentVersionind as current10_1_, hotel0_.distanceToAirport as distanc11_1_, hotel0_.fitnessCentre as fitness12_1_, hotel0_.indoorPool as indoorPool1_, hotel0_.latitude as latitude1_, hotel0_.laundry as laundry1_, hotel0_.longitude as longitude1_, hotel0_.name as name1_, hotel0_.opened as opened1_, hotel0_.outdoorPool as outdoor19_1_, hotel0_.parking as parking1_, hotel0_.parkingSpace as parking21_1_, hotel0_.petsAllowed as petsAll22_1_, hotel0_.priceValue as priceValue1_, hotel0_.priority as priority1_, hotel0_.sauna as sauna1_, hotel0_.storeys as storeys1_, hotel0_.summary as summary1_, hotel0_.version as version1_, hotel0_.wifi as wifi1_ from Hotel hotel0_
  44. took 1608ms.
  45. Query 'from Hotel': 3
  46. Hibernate: select hotel0_.id as id1_, hotel0_.airport as airport1_, hotel0_.carHire as carHire1_, hotel0_.casino as casino1_, hotel0_.checkIn as checkIn1_, hotel0_.checkOutEnd as checkOut6_1_, hotel0_.checkOutStart as checkOut7_1_, hotel0_.city as city1_, hotel0_.country as country1_, hotel0_.currentVersionind as current10_1_, hotel0_.distanceToAirport as distanc11_1_, hotel0_.fitnessCentre as fitness12_1_, hotel0_.indoorPool as indoorPool1_, hotel0_.latitude as latitude1_, hotel0_.laundry as laundry1_, hotel0_.longitude as longitude1_, hotel0_.name as name1_, hotel0_.opened as opened1_, hotel0_.outdoorPool as outdoor19_1_, hotel0_.parking as parking1_, hotel0_.parkingSpace as parking21_1_, hotel0_.petsAllowed as petsAll22_1_, hotel0_.priceValue as priceValue1_, hotel0_.priority as priority1_, hotel0_.sauna as sauna1_, hotel0_.storeys as storeys1_, hotel0_.summary as summary1_, hotel0_.version as version1_, hotel0_.wifi as wifi1_ from Hotel hotel0_
  47. took 1577ms.
  48. Query 'from Hotel': 4
  49. Hibernate: select hotel0_.id as id1_, hotel0_.airport as airport1_, hotel0_.carHire as carHire1_, hotel0_.casino as casino1_, hotel0_.checkIn as checkIn1_, hotel0_.checkOutEnd as checkOut6_1_, hotel0_.checkOutStart as checkOut7_1_, hotel0_.city as city1_, hotel0_.country as country1_, hotel0_.currentVersionind as current10_1_, hotel0_.distanceToAirport as distanc11_1_, hotel0_.fitnessCentre as fitness12_1_, hotel0_.indoorPool as indoorPool1_, hotel0_.latitude as latitude1_, hotel0_.laundry as laundry1_, hotel0_.longitude as longitude1_, hotel0_.name as name1_, hotel0_.opened as opened1_, hotel0_.outdoorPool as outdoor19_1_, hotel0_.parking as parking1_, hotel0_.parkingSpace as parking21_1_, hotel0_.petsAllowed as petsAll22_1_, hotel0_.priceValue as priceValue1_, hotel0_.priority as priority1_, hotel0_.sauna as sauna1_, hotel0_.storeys as storeys1_, hotel0_.summary as summary1_, hotel0_.version as version1_, hotel0_.wifi as wifi1_ from Hotel hotel0_
  50. took 1433ms.
  51. Query 'from Hotel': 5
  52. Hibernate: select hotel0_.id as id1_, hotel0_.airport as airport1_, hotel0_.carHire as carHire1_, hotel0_.casino as casino1_, hotel0_.checkIn as checkIn1_, hotel0_.checkOutEnd as checkOut6_1_, hotel0_.checkOutStart as checkOut7_1_, hotel0_.city as city1_, hotel0_.country as country1_, hotel0_.currentVersionind as current10_1_, hotel0_.distanceToAirport as distanc11_1_, hotel0_.fitnessCentre as fitness12_1_, hotel0_.indoorPool as indoorPool1_, hotel0_.latitude as latitude1_, hotel0_.laundry as laundry1_, hotel0_.longitude as longitude1_, hotel0_.name as name1_, hotel0_.opened as opened1_, hotel0_.outdoorPool as outdoor19_1_, hotel0_.parking as parking1_, hotel0_.parkingSpace as parking21_1_, hotel0_.petsAllowed as petsAll22_1_, hotel0_.priceValue as priceValue1_, hotel0_.priority as priority1_, hotel0_.sauna as sauna1_, hotel0_.storeys as storeys1_, hotel0_.summary as summary1_, hotel0_.version as version1_, hotel0_.wifi as wifi1_ from Hotel hotel0_
  53. took 1494ms.
  54. Query 'from Hotel': average time = 1509.6ms.
  55. Query 'select * from Hotel': started
  56. Query 'select * from Hotel': 1st run (pilot)
  57. took 1154ms.
  58. Query 'select * from Hotel': 1
  59. took 1074ms.
  60. Query 'select * from Hotel': 2
  61. took 1075ms.
  62. Query 'select * from Hotel': 3
  63. took 1110ms.
  64. Query 'select * from Hotel': 4
  65. took 1075ms.
  66. Query 'select * from Hotel': 5
  67. took 1074ms.
  68. Query 'select * from Hotel': average time = 1081.6ms.
  69. End
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement