gistfile1.txt

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: ["+13105532482","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: ["+13105532482","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 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":null,"2":"4","3":"email","4":"scnmilliken@gmail.com","5":"scnmilliken@gmail.com","6":{"date":"2014-05-07 22:01:30","timezone_type":3,"timezone":"UTC"},"7":{"date":"2014-05-07 22:01:30","timezone_type":3,"timezone":"UTC"},"8":true,"9":true,"10":10157,"11":0}
query: "ROLLBACK"
params: null