gistfile1.txt

query: "COMMIT"
params: null
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: [2756156]
query: SELECT t0.id AS id1, t0.name AS name2, t0.isStopped AS isStopped3, t0.lastConfigurationStoppedAt AS lastConfigurationStoppedAt4, t0.lastScriptStartedAt AS lastScriptStartedAt5 FROM CommandRunnerConfiguration t0 WHERE t0.name = ? LIMIT 1
params: ["revinate:guestList:manualImportProcess"]
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,"2bf6a888f4b17e87b398eec3097b9fe3",true]
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_ LEFT JOIN GuestContact g1_ ON g0_.id = g1_.guest_id WHERE g1_.value = ? AND g1_.method = ? LIMIT 1 OFFSET 0
params: ["scnmilliken@gmail.com","email"]
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: ["scnmilliken@gmail.com","email",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: ["scnmilliken@gmail.com","email",4,null,false]
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
~