gistfile1.txt

query: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
params: []
query: "START TRANSACTION"
params: null
query: SELECT DISTINCT id0 FROM (SELECT g0_.id AS id0, g0_.guest_id AS guest_id1, g0_.property_id AS property_id2, g0_.token AS token3, g0_.confirmation_code AS confirmation_code4, g0_.room_number AS room_number5, g0_.checkin_date_time AS checkin_date_time6, g0_.booking_date AS booking_date7, g0_.checkin_date AS checkin_date8, g0_.is_checked_in AS is_checked_in9, g0_.checkout_date AS checkout_date10, g0_.trip_type AS trip_type11, g0_.room_type AS room_type12, g0_.room_rate AS room_rate13, g0_.reservation_source AS reservation_source14, g0_.reservation_amount AS reservation_amount15, g0_.is_from_pms AS is_from_pms16, g0_.guest_list_import_history_id AS guest_list_import_history_id17, g0_.hash AS hash18, g0_.debug_hash AS debug_hash19, g0_.private_id AS private_id20, g0_.email AS email21, g0_.phone AS phone22, g0_.average_room_rate AS average_room_rate23, g0_.title AS title24, g0_.online_checkin_at AS online_checkin_at25, g0_.first_name AS first_name26, g0_.last_name AS last_name27, g0_.address1 AS address128, g0_.address2 AS address229, g0_.city AS city30, g0_.state AS state31, g0_.country AS country32, g0_.zipCode AS zipCode33, g0_.gender AS gender34, g0_.dob AS dob35, g0_.loyalty_number AS loyalty_number36, g0_.pin AS pin37, g0_.profile_image_url AS profile_image_url38, g0_.rateCode AS rateCode39, g0_.statusCode AS statusCode40, g0_.vipCode AS vipCode41, g0_.confirmation_status AS confirmation_status42 FROM GuestStay g0_ WHERE g0_.property_id = ? AND g0_.hash = ? AND g0_.is_from_pms = ? FOR UPDATE) dctrn_result LIMIT 1 OFFSET 0
params: [4,"6c6c81f7b0a5d44e1e9b34afb0926812",true]
query: SET SESSION TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
params: []
query: SELECT g0_.id AS id0, g0_.guest_id AS guest_id1, g0_.property_id AS property_id2, g0_.method AS method3, g0_.value AS value4, g0_.sanitized_value AS sanitized_value5, g0_.created_at AS created_at6, g0_.updated_at AS updated_at7, g0_.is_from_pms AS is_from_pms8, g0_.is_valid AS is_valid9, g0_.guest_list_import_history_id AS guest_list_import_history_id10, g0_.is_primary AS is_primary11, g0_.guest_id AS guest_id12, g0_.property_id AS property_id13, g0_.guest_list_import_history_id AS guest_list_import_history_id14 FROM GuestContact g0_ WHERE (g0_.sanitized_value = ? AND g0_.method = ?) AND g0_.property_id = ? AND g0_.guest_id = ? AND g0_.is_from_pms = ? LIMIT 1 FOR UPDATE
params: ["+15419211017","sms",4,null,true]
query: SELECT g0_.id AS id0, g0_.guest_id AS guest_id1, g0_.property_id AS property_id2, g0_.method AS method3, g0_.value AS value4, g0_.sanitized_value AS sanitized_value5, g0_.created_at AS created_at6, g0_.updated_at AS updated_at7, g0_.is_from_pms AS is_from_pms8, g0_.is_valid AS is_valid9, g0_.guest_list_import_history_id AS guest_list_import_history_id10, g0_.is_primary AS is_primary11, g0_.guest_id AS guest_id12, g0_.property_id AS property_id13, g0_.guest_list_import_history_id AS guest_list_import_history_id14 FROM GuestContact g0_ WHERE (g0_.sanitized_value = ? AND g0_.method = ?) AND g0_.property_id = ? AND g0_.guest_id = ? AND g0_.is_from_pms = ? LIMIT 1 FOR UPDATE
params: ["+15419211017","sms",4,null,false]
query: SELECT c0_.id AS id0, c0_.property_id AS property_id1, c0_.checkin_email_settings AS checkin_email_settings2, c0_.email_subject AS email_subject3, c0_.is_custom_html AS is_custom_html4, c0_.custom_html AS custom_html5, c0_.is_managed AS is_managed6, c0_.deliver_days_before AS deliver_days_before7, c0_.is_active AS is_active8, c0_.property_id AS property_id9 FROM CheckinSetting c0_ WHERE c0_.property_id = ?
params: [4]
query: INSERT INTO Guest (push_id, created_at, updated_at, guest_identity_id, guest_list_import_history_id) VALUES (?, ?, ?, ?, ?)
params: {"1":null,"2":{"date":"2014-05-13 23:38:18","timezone_type":3,"timezone":"UTC"},"3":{"date":"2014-05-13 23:38:18","timezone_type":3,"timezone":"UTC"},"4":null,"5":11147}
query: INSERT INTO GuestContact (guest_id, property_id, method, value, sanitized_value, created_at, updated_at, is_from_pms, is_valid, guest_list_import_history_id, is_primary) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
params: {"1":2904707,"2":"4","3":"sms","4":"541-921-1017","5":"+15419211017","6":{"date":"2014-05-13 23:38:18","timezone_type":3,"timezone":"UTC"},"7":{"date":"2014-05-13 23:38:18","timezone_type":3,"timezone":"UTC"},"8":true,"9":true,"10":11147,"11":0}
query: INSERT INTO GuestContact (guest_id, property_id, method, value, sanitized_value, created_at, updated_at, is_from_pms, is_valid, guest_list_import_history_id, is_primary) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
params: {"1":2904707,"2":"4","3":"sms","4":"541-921-1017","5":"+15419211017","6":{"date":"2014-05-13 23:38:18","timezone_type":3,"timezone":"UTC"},"7":{"date":"2014-05-13 23:38:18","timezone_type":3,"timezone":"UTC"},"8":false,"9":true,"10":11147,"11":1}
query: INSERT INTO GuestStay (guest_id, property_id, token, confirmation_code, room_number, checkin_date_time, booking_date, checkin_date, is_checked_in, checkout_date, trip_type, room_type, room_rate, reservation_source, reservation_amount, is_from_pms, guest_list_import_history_id, hash, debug_hash, private_id, email, phone, average_room_rate, title, online_checkin_at, first_name, last_name, address1, address2, city, state, country, zipCode, gender, dob, loyalty_number, pin, profile_image_url, rateCode, statusCode, vipCode, confirmation_status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
params: {"1":2904707,"2":"4","3":null,"4":"10010290158","5":"416","6":null,"7":null,"8":{"date":"2014-05-12 00:00:00","timezone_type":3,"timezone":"UTC"},"9":null,"10":{"date":"2014-05-14 00:00:00","timezone_type":3,"timezone":"UTC"},"11":null,"12":null,"13":"100.00","14":null,"15":null,"16":true,"17":11147,"18":"6c6c81f7b0a5d44e1e9b34afb0926812","19":null,"20":"53263bc73911639bbabde960ec0e754d","21":null,"22":"541-921-1017","23":"100.00","24":null,"25":null,"26":"Gary","27":"Peters","28":"4900 Hilltop Ln","29":null,"30":"Neskowin","31":"OR","32":"US","33":"97149","34":null,"35":null,"36":null,"37":null,"38":null,"39":null,"40":null,"41":null,"42":"VALID"}
query: UPDATE GuestContact SET updated_at = ? WHERE id = ?
params: [{"date":"2014-05-13 23:38:18","timezone_type":3,"timezone":"UTC"},1744919]
query: UPDATE GuestContact SET updated_at = ? WHERE id = ?
params: [{"date":"2014-05-13 23:38:18","timezone_type":3,"timezone":"UTC"},1744920]
query: UPDATE GuestContact SET updated_at = ? WHERE id = ?
params: [{"date":"2014-05-13 23:38:18","timezone_type":3,"timezone":"UTC"},1744921]
query: UPDATE GuestContact SET updated_at = ? WHERE id = ?
params: [{"date":"2014-05-13 23:38:18","timezone_type":3,"timezone":"UTC"},1744922]
query: SELECT g0_.id AS id0, g0_.push_id AS push_id1, g0_.created_at AS created_at2, g0_.updated_at AS updated_at3, g0_.guest_identity_id AS guest_identity_id4, g0_.guest_list_import_history_id AS guest_list_import_history_id5, g0_.guest_identity_id AS guest_identity_id6, g0_.guest_list_import_history_id AS guest_list_import_history_id7 FROM Guest g0_ WHERE g0_.id = ?
params: [2904707]
query: SELECT g0_.id AS id0, g0_.push_id AS push_id1, g0_.created_at AS created_at2, g0_.updated_at AS updated_at3, g0_.guest_identity_id AS guest_identity_id4, g0_.guest_list_import_history_id AS guest_list_import_history_id5, g0_.guest_identity_id AS guest_identity_id6, g0_.guest_list_import_history_id AS guest_list_import_history_id7 FROM Guest g0_ WHERE g0_.id = ?
params: [2904707]