[09/28/2023 11:00:51], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:00:51' WHERE id= '98';
[09/28/2023 11:00:51], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695898851','43.239.53.130');
[09/28/2023 11:00:52], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_00_51_1695898851_96.json', 'e1p/28_09_2023/response_valuation_sqtech_11_00_51_1695898851_96.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_00_51_1695898851_96.json', 'expediapackage', '2023-09-28 11:00:52', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:01:33], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:01:33' WHERE id= '98';
[09/28/2023 11:01:33], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695898893','43.239.53.130');
[09/28/2023 11:01:33], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_01_33_1695898893_7.json', 'e1p/28_09_2023/response_valuation_sqtech_11_01_33_1695898893_7.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_01_33_1695898893_7.json', 'expediapackage', '2023-09-28 11:01:33', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:01:34], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:01:34' WHERE id= '98';
[09/28/2023 11:01:34], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695898894','43.239.53.130');
[09/28/2023 11:01:34], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_01_34_1695898894_73.json', 'e1p/28_09_2023/response_valuation_sqtech_11_01_34_1695898894_73.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_01_34_1695898894_73.json', 'expediapackage', '2023-09-28 11:01:34', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:02:39], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:02:39' WHERE id= '98';
[09/28/2023 11:02:39], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695898959','43.239.53.130');
[09/28/2023 11:02:40], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_02_39_1695898959_28.json', 'e1p/28_09_2023/response_valuation_sqtech_11_02_39_1695898959_28.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_02_39_1695898959_28.json', 'expediapackage', '2023-09-28 11:02:40', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:03:30], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:03:30' WHERE id= '98';
[09/28/2023 11:03:31], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695899011','43.239.53.130');
[09/28/2023 11:03:32], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_03_31_1695899011_56.json', 'e1p/28_09_2023/response_valuation_sqtech_11_03_31_1695899011_56.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_03_31_1695899011_56.json', 'expediapackage', '2023-09-28 11:03:32', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:05:47], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:05:47' WHERE id= '98';
[09/28/2023 11:05:47], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695899147','43.239.53.130');
[09/28/2023 11:05:47], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_05_47_1695899147_19.json', 'e1p/28_09_2023/response_valuation_sqtech_11_05_47_1695899147_19.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_05_47_1695899147_19.json', 'expediapackage', '2023-09-28 11:05:47', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:06:55], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:06:55' WHERE id= '98';
[09/28/2023 11:06:55], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695899215','43.239.53.130');
[09/28/2023 11:06:55], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_06_55_1695899215_47.json', 'e1p/28_09_2023/response_valuation_sqtech_11_06_55_1695899215_47.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_06_55_1695899215_47.json', 'expediapackage', '2023-09-28 11:06:55', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:07:43], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:07:43' WHERE id= '98';
[09/28/2023 11:07:43], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695899263','43.239.53.130');
[09/28/2023 11:07:43], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_07_43_1695899263_35.json', 'e1p/28_09_2023/response_valuation_sqtech_11_07_43_1695899263_35.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_07_43_1695899263_35.json', 'expediapackage', '2023-09-28 11:07:43', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:08:03], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:08:03' WHERE id= '98';
[09/28/2023 11:08:03], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695899283','43.239.53.130');
[09/28/2023 11:08:03], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_08_03_1695899283_4.json', 'e1p/28_09_2023/response_valuation_sqtech_11_08_03_1695899283_4.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_08_03_1695899283_4.json', 'expediapackage', '2023-09-28 11:08:03', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:09:32], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:09:32' WHERE id= '98';
[09/28/2023 11:09:32], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695899372','43.239.53.130');
[09/28/2023 11:09:33], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_09_32_1695899372_48.json', 'e1p/28_09_2023/response_valuation_sqtech_11_09_32_1695899372_48.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_09_32_1695899372_48.json', 'expediapackage', '2023-09-28 11:09:33', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:12:00], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:12:00' WHERE id= '98';
[09/28/2023 11:12:00], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695899520','43.239.53.130');
[09/28/2023 11:12:01], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_12_00_1695899520_92.json', 'e1p/28_09_2023/response_valuation_sqtech_11_12_00_1695899520_92.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_12_00_1695899520_92.json', 'expediapackage', '2023-09-28 11:12:01', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:13:11], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:13:11' WHERE id= '98';
[09/28/2023 11:13:11], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695899591','43.239.53.130');
[09/28/2023 11:13:12], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_13_11_1695899591_90.json', 'e1p/28_09_2023/response_valuation_sqtech_11_13_11_1695899591_90.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_13_11_1695899591_90.json', 'expediapackage', '2023-09-28 11:13:12', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:13:45], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:13:45' WHERE id= '98';
[09/28/2023 11:13:45], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695899625','43.239.53.130');
[09/28/2023 11:13:45], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_13_45_1695899625_65.json', 'e1p/28_09_2023/response_valuation_sqtech_11_13_45_1695899625_65.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_13_45_1695899625_65.json', 'expediapackage', '2023-09-28 11:13:45', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:14:27], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:14:27' WHERE id= '98';
[09/28/2023 11:14:27], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695899667','43.239.53.130');
[09/28/2023 11:14:27], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_14_27_1695899667_36.json', 'e1p/28_09_2023/response_valuation_sqtech_11_14_27_1695899667_36.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_14_27_1695899667_36.json', 'expediapackage', '2023-09-28 11:14:27', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:14:41], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:14:41' WHERE id= '98';
[09/28/2023 11:14:41], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695899681','43.239.53.130');
[09/28/2023 11:14:42], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_14_41_1695899681_35.json', 'e1p/28_09_2023/response_valuation_sqtech_11_14_41_1695899681_35.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_14_41_1695899681_35.json', 'expediapackage', '2023-09-28 11:14:42', '', '6adc30018c4b5e2f527ffa85fb6d99c6993a8e191bde9a3aa09f0c59c71b8ee7', '0');
[09/28/2023 11:55:44], [file name :-/home/otrams/public_html/beta/agent_login.php],update agents set last_login_date = '2023-09-28 11:55:44',login_attempt=0 where id = '7839';
[09/28/2023 11:55:44], [file name :-/home/otrams/public_html/beta/agent_login.php],INSERT INTO psa_login_log  SET username = 'sqtech', user_type = 'A', branch_id = '28', login_datetime = '2023-09-28 11:55:44', ip = '43.239.53.130', action = 'Login' ;
[09/28/2023 11:55:44], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:55:44' WHERE id= '96';
[09/28/2023 11:55:50], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:55:50' WHERE id= '96';
[09/28/2023 11:55:51], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:55:51' WHERE id= '96';
[09/28/2023 11:55:53], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:55:53' WHERE id= '96';
[09/28/2023 11:55:54], [file name :-/home/otrams/public_html/beta/get_city_list.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:55:54' WHERE id= '96';
[09/28/2023 11:56:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:56:00' WHERE id= '96';
[09/28/2023 11:56:00], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'phuket' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/09/30' , departure_date = '2023/10/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-09-28 11:56:00' , site_id = '' , country_code = '136' , city_code = '71351' , ratings = '3.0,4.0,5.0,SC' , selected_currency = 'SAR' , currency_code = 'SAR' , web_service = '' ;
[09/28/2023 11:56:01], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:56:01' WHERE id= '96';
[09/28/2023 11:56:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_03_1695902163_44.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_03_1695902163_44.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_03_1695902163_44.json', 'expediapackage', '2023-09-28 11:56:03', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=5&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:03.21'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.404'
            , error_description = ''
            , memory_used = '1293280'
            WHERE id = '8510';
[09/28/2023 11:56:03], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_03_1695902163_100.json', 'e1/28_09_2023/response_availability_sqtech_11_56_03_1695902163_100.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_03_1695902163_100.json', 'expedia', '2023-09-28 11:56:03', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:03], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=5&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:03.26'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.571'
            , error_description = ''
            , memory_used = '1292288'
            WHERE id = '8511';
[09/28/2023 11:56:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_03_1695902163_93.json', 'e1/28_09_2023/response_availability_sqtech_11_56_03_1695902163_93.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_03_1695902163_93.json', 'expedia', '2023-09-28 11:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_03_1695902163_12.json', 'e1/28_09_2023/response_availability_sqtech_11_56_03_1695902163_12.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_03_1695902163_12.json', 'expedia', '2023-09-28 11:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_03_1695902163_84.json', 'e1/28_09_2023/response_availability_sqtech_11_56_03_1695902163_84.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_03_1695902163_84.json', 'expedia', '2023-09-28 11:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_03_1695902163_49.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_03_1695902163_49.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_03_1695902163_49.json', 'expediapackage', '2023-09-28 11:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_03_1695902163_52.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_03_1695902163_52.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_03_1695902163_52.json', 'expediapackage', '2023-09-28 11:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_03_1695902163_31.json', 'e1/28_09_2023/response_availability_sqtech_11_56_03_1695902163_31.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_03_1695902163_31.json', 'expedia', '2023-09-28 11:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:04], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_03_1695902163_59.json', 'e1/28_09_2023/response_availability_sqtech_11_56_03_1695902163_59.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_03_1695902163_59.json', 'expedia', '2023-09-28 11:56:04', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_03_1695902163_30.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_03_1695902163_30.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_03_1695902163_30.json', 'expediapackage', '2023-09-28 11:56:05', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_03_1695902163_90.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_03_1695902163_90.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_03_1695902163_90.json', 'expediapackage', '2023-09-28 11:56:05', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=1&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:03.17'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.743'
            , error_description = ''
            , memory_used = '37546856'
            WHERE id = '8512';
[09/28/2023 11:56:05], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_03_1695902163_89.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_03_1695902163_89.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_03_1695902163_89.json', 'expediapackage', '2023-09-28 11:56:05', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=3&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:03.17'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.965'
            , error_description = ''
            , memory_used = '40549128'
            WHERE id = '8515';
[09/28/2023 11:56:05], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=3&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:03.17'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.976'
            , error_description = ''
            , memory_used = '32316760'
            WHERE id = '8517';
[09/28/2023 11:56:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=2&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:03.18'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.171'
            , error_description = ''
            , memory_used = '38890280'
            WHERE id = '8513';
[09/28/2023 11:56:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=4&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:03.17'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.368'
            , error_description = ''
            , memory_used = '31179920'
            WHERE id = '8516';
[09/28/2023 11:56:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=4&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:03.22'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.425'
            , error_description = ''
            , memory_used = '26983520'
            WHERE id = '8518';
[09/28/2023 11:56:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=1&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:03.27'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.441'
            , error_description = ''
            , memory_used = '45158696'
            WHERE id = '8519';
[09/28/2023 11:56:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=0&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:03.55'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.727'
            , error_description = ''
            , memory_used = '40043624'
            WHERE id = '8514';
[09/28/2023 11:56:06], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=0&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:03.25'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.969'
            , error_description = ''
            , memory_used = '46252384'
            WHERE id = '8520';
[09/28/2023 11:56:07], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=2&total_request=6&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:03.16'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '4.137'
            , error_description = ''
            , memory_used = '47680744'
            WHERE id = '8521';
[09/28/2023 11:56:07], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:56:07' WHERE id= '96';
[09/28/2023 11:56:07], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:56:07' WHERE id= '96';
[09/28/2023 11:56:13], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:56:13' WHERE id= '96';
[09/28/2023 11:56:23], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:56:23' WHERE id= '96';
[09/28/2023 11:56:23], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'phuket' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/09/30' , departure_date = '2023/10/01' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-09-28 11:56:23' , site_id = '' , country_code = '136' , city_code = '71351' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[09/28/2023 11:56:24], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:56:24' WHERE id= '96';
[09/28/2023 11:56:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_24_1695902184_2.json', 'e1/28_09_2023/response_availability_sqtech_11_56_24_1695902184_2.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_2.json', 'expedia', '2023-09-28 11:56:24', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=7&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.502'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.362'
            , error_description = ''
            , memory_used = '1292472'
            WHERE id = '8522';
[09/28/2023 11:56:24], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_24_1695902184_93.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_24_1695902184_93.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_93.json', 'expediapackage', '2023-09-28 11:56:24', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:24], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=7&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.502'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.386'
            , error_description = ''
            , memory_used = '1293664'
            WHERE id = '8523';
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_24_1695902184_93.json', 'e1/28_09_2023/response_availability_sqtech_11_56_24_1695902184_93.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_93.json', 'expedia', '2023-09-28 11:56:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=6&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.502'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.627'
            , error_description = ''
            , memory_used = '4399240'
            WHERE id = '8524';
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_24_1695902184_86.json', 'e1/28_09_2023/response_availability_sqtech_11_56_24_1695902184_86.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_86.json', 'expedia', '2023-09-28 11:56:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_24_1695902184_81.json', 'e1/28_09_2023/response_availability_sqtech_11_56_24_1695902184_81.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_81.json', 'expedia', '2023-09-28 11:56:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_24_1695902184_61.json', 'e1/28_09_2023/response_availability_sqtech_11_56_24_1695902184_61.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_61.json', 'expedia', '2023-09-28 11:56:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_24_1695902184_92.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_24_1695902184_92.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_92.json', 'expediapackage', '2023-09-28 11:56:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=6&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.502'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.866'
            , error_description = ''
            , memory_used = '5265680'
            WHERE id = '8528';
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_24_1695902184_50.json', 'e1/28_09_2023/response_availability_sqtech_11_56_24_1695902184_50.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_50.json', 'expedia', '2023-09-28 11:56:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=4&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.502'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.997'
            , error_description = ''
            , memory_used = '23819360'
            WHERE id = '8525';
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=0&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.059'
            , error_description = ''
            , memory_used = '30244528'
            WHERE id = '8527';
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=3&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.087'
            , error_description = ''
            , memory_used = '34090688'
            WHERE id = '8526';
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_24_1695902184_47.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_24_1695902184_47.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_47.json', 'expediapackage', '2023-09-28 11:56:25', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=5&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.294'
            , error_description = ''
            , memory_used = '35223200'
            WHERE id = '8529';
[09/28/2023 11:56:25], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=4&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.444'
            , error_description = ''
            , memory_used = '30694216'
            WHERE id = '8530';
[09/28/2023 11:56:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_24_1695902184_24.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_24_1695902184_24.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_24.json', 'expediapackage', '2023-09-28 11:56:26', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_24_1695902184_62.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_24_1695902184_62.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_62.json', 'expediapackage', '2023-09-28 11:56:26', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:26], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_24_1695902184_29.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_24_1695902184_29.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_29.json', 'expediapackage', '2023-09-28 11:56:26', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=2&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.881'
            , error_description = ''
            , memory_used = '35895680'
            WHERE id = '8532';
[09/28/2023 11:56:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=3&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.895'
            , error_description = ''
            , memory_used = '42342184'
            WHERE id = '8531';
[09/28/2023 11:56:26], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=0&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.089'
            , error_description = ''
            , memory_used = '34138632'
            WHERE id = '8533';
[09/28/2023 11:56:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_24_1695902184_23.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_24_1695902184_23.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_23.json', 'expediapackage', '2023-09-28 11:56:27', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=1&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.940'
            , error_description = ''
            , memory_used = '36869400'
            WHERE id = '8534';
[09/28/2023 11:56:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_56_24_1695902184_11.json', 'e1p/28_09_2023/response_availability_sqtech_11_56_24_1695902184_11.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_11.json', 'expediapackage', '2023-09-28 11:56:27', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:27], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=5&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.409'
            , error_description = ''
            , memory_used = '40275504'
            WHERE id = '8535';
[09/28/2023 11:56:27], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_24_1695902184_33.json', 'e1/28_09_2023/response_availability_sqtech_11_56_24_1695902184_33.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_33.json', 'expedia', '2023-09-28 11:56:27', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:28], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=1&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '3.741'
            , error_description = ''
            , memory_used = '29377776'
            WHERE id = '8536';
[09/28/2023 11:56:29], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_56_24_1695902184_10.json', 'e1/28_09_2023/response_availability_sqtech_11_56_24_1695902184_10.json', 'e1/28_09_2023/response_header_availability_sqtech_11_56_24_1695902184_10.json', 'expedia', '2023-09-28 11:56:29', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:29], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=2&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:56:24.501'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '5.403'
            , error_description = ''
            , memory_used = '30371232'
            WHERE id = '8537';
[09/28/2023 11:56:29], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:56:29' WHERE id= '96';
[09/28/2023 11:56:30], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:56:30' WHERE id= '96';
[09/28/2023 11:56:33], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:56:33' WHERE id= '96';
[09/28/2023 11:56:38], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:56:38' WHERE id= '96';
[09/28/2023 11:56:39], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:56:39' WHERE id= '96';
[09/28/2023 11:56:39], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695902199','43.239.53.130');
[09/28/2023 11:56:39], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_56_39_1695902199_45.json', 'e1p/28_09_2023/response_valuation_sqtech_11_56_39_1695902199_45.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_56_39_1695902199_45.json', 'expediapackage', '2023-09-28 11:56:39', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:56:39], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Oyo 75321 Gemma Patong', 'phuket', '136', '7839', '', '28', '', 'hotelcancellationpolicy', '2023-09-28 :11:56:39','');
[09/28/2023 11:57:34], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:57:34' WHERE id= '96';
[09/28/2023 11:57:34], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:57:34' WHERE id= '96';
[09/28/2023 11:57:34], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695902254','43.239.53.130');
[09/28/2023 11:57:35], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_57_34_1695902254_65.json', 'e1p/28_09_2023/response_valuation_sqtech_11_57_34_1695902254_65.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_57_34_1695902254_65.json', 'expediapackage', '2023-09-28 11:57:35', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:57:35], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Oyo 75321 Gemma Patong', 'phuket', '136', '7839', '', '28', '', 'hotelcancellationpolicy', '2023-09-28 :11:57:35','');
[09/28/2023 11:57:44], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:57:44' WHERE id= '96';
[09/28/2023 11:57:45], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:57:45' WHERE id= '96';
[09/28/2023 11:57:45], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695902265','43.239.53.130');
[09/28/2023 11:57:45], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_57_45_1695902265_22.json', 'e1p/28_09_2023/response_valuation_sqtech_11_57_45_1695902265_22.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_57_45_1695902265_22.json', 'expediapackage', '2023-09-28 11:57:45', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:27], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:58:27' WHERE id= '96';
[09/28/2023 11:58:32], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:58:32' WHERE id= '96';
[09/28/2023 11:58:47], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:58:47' WHERE id= '96';
[09/28/2023 11:58:47], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'phuket' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/10/18' , departure_date = '2023/10/19' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-09-28 11:58:47' , site_id = '' , country_code = '136' , city_code = '71351' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[09/28/2023 11:58:49], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:58:49' WHERE id= '96';
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_58_50_1695902330_97.json', 'e1/28_09_2023/response_availability_sqtech_11_58_50_1695902330_97.json', 'e1/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_97.json', 'expedia', '2023-09-28 11:58:50', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=7&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:49.999'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.222'
            , error_description = ''
            , memory_used = '1292464'
            WHERE id = '8541';
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_58_50_1695902330_1.json', 'e1p/28_09_2023/response_availability_sqtech_11_58_50_1695902330_1.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_1.json', 'expediapackage', '2023-09-28 11:58:50', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=7&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.0'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.286'
            , error_description = ''
            , memory_used = '1293648'
            WHERE id = '8542';
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_58_50_1695902330_45.json', 'e1p/28_09_2023/response_availability_sqtech_11_58_50_1695902330_45.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_45.json', 'expediapackage', '2023-09-28 11:58:50', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=6&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:49.999'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.722'
            , error_description = ''
            , memory_used = '6103600'
            WHERE id = '8543';
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_58_50_1695902330_47.json', 'e1/28_09_2023/response_availability_sqtech_11_58_50_1695902330_47.json', 'e1/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_47.json', 'expedia', '2023-09-28 11:58:50', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_58_50_1695902330_4.json', 'e1/28_09_2023/response_availability_sqtech_11_58_50_1695902330_4.json', 'e1/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_4.json', 'expedia', '2023-09-28 11:58:50', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=6&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.3'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.883'
            , error_description = ''
            , memory_used = '4965592'
            WHERE id = '8544';
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_58_50_1695902330_68.json', 'e1/28_09_2023/response_availability_sqtech_11_58_50_1695902330_68.json', 'e1/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_68.json', 'expedia', '2023-09-28 11:58:50', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_58_50_1695902330_65.json', 'e1/28_09_2023/response_availability_sqtech_11_58_50_1695902330_65.json', 'e1/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_65.json', 'expedia', '2023-09-28 11:58:50', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_58_50_1695902330_78.json', 'e1/28_09_2023/response_availability_sqtech_11_58_50_1695902330_78.json', 'e1/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_78.json', 'expedia', '2023-09-28 11:58:50', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:50], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_58_50_1695902330_23.json', 'e1/28_09_2023/response_availability_sqtech_11_58_50_1695902330_23.json', 'e1/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_23.json', 'expedia', '2023-09-28 11:58:50', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:51], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_58_50_1695902330_2.json', 'e1/28_09_2023/response_availability_sqtech_11_58_50_1695902330_2.json', 'e1/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_2.json', 'expedia', '2023-09-28 11:58:51', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:51], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_58_50_1695902330_88.json', 'e1p/28_09_2023/response_availability_sqtech_11_58_50_1695902330_88.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_88.json', 'expediapackage', '2023-09-28 11:58:51', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:51], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_58_50_1695902330_92.json', 'e1p/28_09_2023/response_availability_sqtech_11_58_50_1695902330_92.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_92.json', 'expediapackage', '2023-09-28 11:58:51', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=1&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.0'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.625'
            , error_description = ''
            , memory_used = '40559776'
            WHERE id = '8545';
[09/28/2023 11:58:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=4&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.1'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.674'
            , error_description = ''
            , memory_used = '34471168'
            WHERE id = '8546';
[09/28/2023 11:58:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=2&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.1'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.675'
            , error_description = ''
            , memory_used = '39687760'
            WHERE id = '8547';
[09/28/2023 11:58:51], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_58_50_1695902330_12.json', 'e1p/28_09_2023/response_availability_sqtech_11_58_50_1695902330_12.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_12.json', 'expediapackage', '2023-09-28 11:58:51', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:51], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_58_50_1695902330_52.json', 'e1p/28_09_2023/response_availability_sqtech_11_58_50_1695902330_52.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_52.json', 'expediapackage', '2023-09-28 11:58:51', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:51], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_58_50_1695902330_80.json', 'e1p/28_09_2023/response_availability_sqtech_11_58_50_1695902330_80.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_80.json', 'expediapackage', '2023-09-28 11:58:51', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:51], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=0&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.0'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.897'
            , error_description = ''
            , memory_used = '41719512'
            WHERE id = '8549';
[09/28/2023 11:58:51], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_58_50_1695902330_60.json', 'e1p/28_09_2023/response_availability_sqtech_11_58_50_1695902330_60.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_58_50_1695902330_60.json', 'expediapackage', '2023-09-28 11:58:51', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:58:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=5&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.1'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.073'
            , error_description = ''
            , memory_used = '48088792'
            WHERE id = '8550';
[09/28/2023 11:58:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=3&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.1'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.098'
            , error_description = ''
            , memory_used = '50092152'
            WHERE id = '8548';
[09/28/2023 11:58:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=2&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.1'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.291'
            , error_description = ''
            , memory_used = '47093264'
            WHERE id = '8551';
[09/28/2023 11:58:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=1&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.1'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.371'
            , error_description = ''
            , memory_used = '48104992'
            WHERE id = '8554';
[09/28/2023 11:58:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=0&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.1'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.405'
            , error_description = ''
            , memory_used = '47522712'
            WHERE id = '8552';
[09/28/2023 11:58:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=5&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.2'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.472'
            , error_description = ''
            , memory_used = '52404664'
            WHERE id = '8553';
[09/28/2023 11:58:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=4&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.2'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.712'
            , error_description = ''
            , memory_used = '44175792'
            WHERE id = '8556';
[09/28/2023 11:58:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=3&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:58:50.2'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.792'
            , error_description = ''
            , memory_used = '60544888'
            WHERE id = '8555';
[09/28/2023 11:58:53], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:58:53' WHERE id= '96';
[09/28/2023 11:58:55], [file name :-/home/otrams/public_html/beta/ajax/manualKeepAlive.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:58:55' WHERE id= '96';
[09/28/2023 11:58:58], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:58:58' WHERE id= '96';
[09/28/2023 11:59:04], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:04' WHERE id= '96';
[09/28/2023 11:59:05], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:05' WHERE id= '96';
[09/28/2023 11:59:05], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695902345','43.239.53.130');
[09/28/2023 11:59:05], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_59_05_1695902345_52.json', 'e1p/28_09_2023/response_valuation_sqtech_11_59_05_1695902345_52.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_59_05_1695902345_52.json', 'expediapackage', '2023-09-28 11:59:05', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:05], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO hotel_logs (hotelname, city_name, country_code, agent_id, wh_agent_id, branch_id, site_id, type, create_date,web_service)
			VALUES ('Oyo 75321 Gemma Patong', 'phuket', '136', '7839', '', '28', '', 'hotelcancellationpolicy', '2023-09-28 :11:59:05','');
[09/28/2023 11:59:10], [file name :-/home/otrams/public_html/beta/m1_write_cache.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:10' WHERE id= '96';
[09/28/2023 11:59:10], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:10' WHERE id= '96';
[09/28/2023 11:59:10], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695902350','43.239.53.130');
[09/28/2023 11:59:11], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'valuation', 'e1p/28_09_2023/request_valuation_sqtech_11_59_10_1695902350_14.json', 'e1p/28_09_2023/response_valuation_sqtech_11_59_10_1695902350_14.json', 'e1p/28_09_2023/response_header_valuation_sqtech_11_59_10_1695902350_14.json', 'expediapackage', '2023-09-28 11:59:11', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:18], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:18' WHERE id= '96';
[09/28/2023 11:59:21], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:21' WHERE id= '96';
[09/28/2023 11:59:24], [file name :-/home/otrams/public_html/beta/frontendfunc.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:24' WHERE id= '96';
[09/28/2023 11:59:32], [file name :-/home/otrams/public_html/beta/book_now.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:32' WHERE id= '96';
[09/28/2023 11:59:32], [file name :-/home/otrams/public_html/beta/book_now.php],INSERT INTO autogenerator_reservation (reservation_id, remote_id) VALUES ('1695902372','43.239.53.130');
[09/28/2023 11:59:33], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:33' WHERE id= '96';
[09/28/2023 11:59:33], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into bookings set  source_type = 'expediapackage', reservation_id = '788', create_date = '2023-09-28 11:59:33', agent_id = '7839', parent_agent_id = '7839', agent_ref_no = '', nationality = 'Indian', city_id = 'phuket', country_id = '136', current_status = 'inprocess-booking', is_xml = '0', display_room_rate = '8.57', display_currency_code = 'USD', native_room_rate = '8.57', native_currency_code = 'USD', supplier_profile_id = '43', service_type = 'hotel', service_date = '2023/10/18', check_out_date = '2023/10/19', sub_user_id = '', booking_status = '1', leader_title = 'Mr', leader_first_name = 'sujay', leader_last_name = 'Raut', status_date = '2023-09-28 11:59:33';
[09/28/2023 11:59:33], [file name :-/home/otrams/public_html/beta/confirm_booking.php],UPDATE
		bookings
		SET
		booking_branch_id= '28'
		WHERE
		id='28'
		;
[09/28/2023 11:59:33], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into bookings_details(booking_id,reservation_id,supplier_id,total_rooms,total_adults,total_children,total_infants,rate_description ,rate_code,
				hotel_id,hotel_name,hotel_address1,hotel_phone,hotel_rating,total_nights,arrival_date,departure_date,room_rate_code,hotel_img)values('28','788','','1','2','0','-','','','7826104','OYO 75321 Gemma Patong','I Karoon, Soi Nanairoumjai, Karon','66-0-20261271','3.0','1','2023/10/18','2023/10/19','','https://beta.astrabookings.com//cpfv3/images/?image=aHR0cHM6Ly9pLnRyYXZlbGFwaS5jb20vaG90ZWxzLzgwMDAwMDAvNzgzMDAwMC83ODI2MjAwLzc4MjYxMDQvNTlkYzkyZWNfYi5qcGc=');
[09/28/2023 11:59:33], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into booking_room_detail set  booking_id = '28', booking_detail_id = '1', room_type_code = '', room_name = 'double', room_type_description = 'FullBed Standard Double Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Members exclusive price)</font></b><br>(1 Double Bed)', display_nightly_rates = 'a:1:{i:0;a:2:{s:18:"displayNightlyRate";d:8.5700000000000003;s:25:"displayNightlyRateDisplay";s:151:"Rate - 8.57,Currency Multiplier(USD-USD) - 1.00000, Markup - 0% , Supplier Commission - 0.6 USD, Marketing Fee - 0.6  USD Discount - 0  #expediapackage";}}', native_nightly_rates = 'a:1:{i:0;a:1:{s:17:"nativeNightlyRate";d:8.5700000000000003;}}', native_room_rate_total = '8.57', display_room_rate_total = '8.57', number_of_rooms = '1', room_category = 'FullBed Standard Double Room(Room Only)- <font color=\'red\'>Package Deal</font> <b><font color=\'#265db7\'>(Members exclusive price)</font></b><br>(1 Double Bed)', meal_basis = 'Room Only';
[09/28/2023 11:59:33], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '28', booking_detail_id = '1', rid = '33', room = '0', salutations = 'Mr', first_name = 'sujay', last_name = 'Raut', passenger_type = 'adult', age = '';
[09/28/2023 11:59:33], [file name :-/home/otrams/public_html/beta/confirm_booking.php], insert into passangers set  booking_id = '28', booking_detail_id = '1', rid = '33', room = '0', salutations = 'Mr', first_name = 'TBAA', last_name = 'TBAA', passenger_type = 'adult', age = '';
[09/28/2023 11:59:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'reservation', 'e1p/28_09_2023/request_reservation_sqtech_11_59_33_1695902373_62.json', 'e1p/28_09_2023/response_reservation_sqtech_11_59_33_1695902373_62.json', 'e1p/28_09_2023/response_header_reservation_sqtech_11_59_33_1695902373_62.json', 'expediapackage', '2023-09-28 11:59:34', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings set  special_remark = '', itenirary_id = '7690612330206', confirmation_number = '7690612330206', display_discount = '0', cancellation_policy = 'Free cancellation up to  12:59:59 on  2023-10-12<br>If you cancel between 2023-10-12 13:00:00 and 2023-10-18 00:00:00 , you will be charged 8.57 USD<br>No show is subject to a 100 % cancellation charge<br><br/><b>Amendment Policy</b><br/>
		Please note that most hotels treat changes in pax details, room category and dates as a cancellation of the booking, and charges will apply according to the cancellation policy.
		Late amendment charges may apply if requested after 13:00 on 12th of October 2023.
		Confirmation of amendments is subject to availability and rates at the time of making the amendment.', supplier_cancellation_policy = '', current_status = 'confirmed', expiration_date = '2023-10-12 11:00:00', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free self parking, Free WiFi<br><br><b>Deal:</b> Members exclusive price,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', consultant_id = 'Demo@User', sales_manager_id = '0', admin_booked = '0', email_id = '', leader_phone = '', agent_currency_multiplier = '3.7507', ip_addr = '43.239.53.130', comment_contract = ' Bed Type Selection is not guaranteed.<br/><span style=\'color: red;\'><strong>Note</strong>: Nightly rates might be calculated based on the average of Total Rate</span><br><br><b>Amenities:</b>Free self parking, Free WiFi<br><br><b>Deal:</b> Members exclusive price,<br><br/><br/><br/><b>Checkin Start Time :</b> , <br/><b>Checkin End Time :</b> , <br/><b>Min Checkin Age :</b> , <br/><b>Checkout Time :</b> ,<br/><b>Instructions :</b> ,<br/><b>Special Instructions :</b> ,<br/><b>Important Note :</b> Agent agree that this rate is being sold with approved transport component.', backoffice_user = 'v3alpha', customer_id = '', applied_multiplier='1.00000',  applied_markup='0',  agent_markup='0',  basecurrency_multiplier='1.00000',  basecurrency_multiplier_native='1.00000',  parent_agent_id='7839',  sub_agent_rate='0',  agent_rate='8.57',  applicable_service_tax='0',  supplier_rate='8.57',  uid='6b9cfabc93bda703f5dd7e3d401485b2'  where id='28';
[09/28/2023 11:59:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update bookings_details set touricoRoomResId ='', gta_item_confirm_ref='' , special_request='' where booking_id ='28';
[09/28/2023 11:59:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into booking_lat_long(booking_id,latitude,longitude) values ('28','7.883317','98.296885');
[09/28/2023 11:59:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into `user_logs` set `username`= 'sqtech',`create_date`= '2023-09-28 11:59:34',`log_type`= 'Loyalty Tier Accumulated Points',`sql_query`= 'select id,current_status,display_currency_code,agent_rate,sub_agent_rate,display_room_rate,wh_agent_rate,wh_sub_agent_rate  from bookings where id=\&#039;28\&#039;',`log_description`= 'Loyalty Accumulated Points :0 Added For Booking ID -28 And Booking Status - confirmed',`ip`= '43.239.53.130';
[09/28/2023 11:59:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],insert into user_log_link Set `user_logs_id`='231', `entity`='BookingId', `value`='28' ;
[09/28/2023 11:59:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_status (reservation_id,booking_id,status,create_date,memo,agent_id,ip_address,admin,modify_by) VALUES ('788','28','confirmed','2023-09-28 11:59:34','Booking confirmed. Booked by Back Office v3alpha on behalf of Agent - Sujay  Test(CD7839)','7839','43.239.53.130','0','7839');
[09/28/2023 11:59:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_cancellation_policy(booking_id,from_date,supplier_from_date,to_date,supplier_to_date,supplier_charge,agent_charge,lead_time,create_date,applied_agent_charges)  VALUES('28','2023-10-12 13:00:00','2023-10-16 13:00:00','2023-10-18 00:00:00','2023-10-22 00:00:00','8.57','8.57','96','2023-09-28 11:59:34','8.57');
[09/28/2023 11:59:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update posted_bookings set booking_id='28',status='1' where reservation_id='788' and booking_id ='0';
[09/28/2023 11:59:34], [file name :-/home/otrams/public_html/beta/confirm_booking.php],update xmllogs set reservation_id='28' where agent_logs_id='0' and source_type='expediapackage';
[09/28/2023 11:59:35], [file name :-/home/otrams/public_html/beta/confirm_booking.php],INSERT INTO booking_commission set agent_commission='',  supplier_commission='0.6',  commission_tax='',  booking_id ='28',  supplier_tax='0.9',  supplier_base_fare='7.67',  supplier_commissionable_fare='0.6'able_fare,  retension='100',  commission_percent='0',  create_date ='2023-09-28 11:59:35';
[09/28/2023 11:59:42], [file name :-/home/otrams/public_html/beta/hotel_search.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:42' WHERE id= '96';
[09/28/2023 11:59:50], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:50' WHERE id= '96';
[09/28/2023 11:59:50], [file name :-/home/otrams/public_html/beta/hotel_search_list.php],INSERT INTO agent_logs SET  agent_id = '7839' , sub_agent_id = '' , sub_user_id = '0' , branch_id = '28' , ip = '43.239.53.130' , city = 'phuket' , service_name = '' , country_of_residence = '106' , service_type = 'hotel' , arrival_date = '2023/10/04' , departure_date = '2023/10/05' , nights = '1' , nationality = '106' , room_types = '2' , room_type='[{"numberOfAdults":2}]' , available='0' , create_date = '2023-09-28 11:59:50' , site_id = '' , country_code = '136' , city_code = '71351' , ratings = '1.0,2.0,3.0,4.0,5.0,SC' , selected_currency = 'USD' , currency_code = 'USD' , web_service = '' ;
[09/28/2023 11:59:51], [file name :-/home/otrams/public_html/beta/xml_all.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:51' WHERE id= '96';
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_59_51_1695902391_60.json', 'e1/28_09_2023/response_availability_sqtech_11_59_51_1695902391_60.json', 'e1/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_60.json', 'expedia', '2023-09-28 11:59:52', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=7&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.180'
            , error_description = ''
            , memory_used = '1292496'
            WHERE id = '8560';
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_59_51_1695902391_6.json', 'e1p/28_09_2023/response_availability_sqtech_11_59_51_1695902391_6.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_6.json', 'expediapackage', '2023-09-28 11:59:52', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=7&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.255'
            , error_description = ''
            , memory_used = '1293680'
            WHERE id = '8561';
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_59_51_1695902391_42.json', 'e1/28_09_2023/response_availability_sqtech_11_59_51_1695902391_42.json', 'e1/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_42.json', 'expedia', '2023-09-28 11:59:52', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=6&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.523'
            , error_description = ''
            , memory_used = '4979800'
            WHERE id = '8562';
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_59_51_1695902391_49.json', 'e1p/28_09_2023/response_availability_sqtech_11_59_51_1695902391_49.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_49.json', 'expediapackage', '2023-09-28 11:59:52', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_59_51_1695902391_96.json', 'e1/28_09_2023/response_availability_sqtech_11_59_51_1695902391_96.json', 'e1/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_96.json', 'expedia', '2023-09-28 11:59:52', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=6&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '0.780'
            , error_description = ''
            , memory_used = '6012832'
            WHERE id = '8563';
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_59_51_1695902391_12.json', 'e1/28_09_2023/response_availability_sqtech_11_59_51_1695902391_12.json', 'e1/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_12.json', 'expedia', '2023-09-28 11:59:52', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_59_51_1695902391_3.json', 'e1/28_09_2023/response_availability_sqtech_11_59_51_1695902391_3.json', 'e1/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_3.json', 'expedia', '2023-09-28 11:59:52', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_59_51_1695902391_27.json', 'e1/28_09_2023/response_availability_sqtech_11_59_51_1695902391_27.json', 'e1/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_27.json', 'expedia', '2023-09-28 11:59:52', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_59_51_1695902391_19.json', 'e1/28_09_2023/response_availability_sqtech_11_59_51_1695902391_19.json', 'e1/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_19.json', 'expedia', '2023-09-28 11:59:52', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:52], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=2&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.038'
            , error_description = ''
            , memory_used = '36502576'
            WHERE id = '8564';
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1/28_09_2023/request_availability_sqtech_11_59_51_1695902391_14.json', 'e1/28_09_2023/response_availability_sqtech_11_59_51_1695902391_14.json', 'e1/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_14.json', 'expedia', '2023-09-28 11:59:53', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=1&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.211'
            , error_description = ''
            , memory_used = '37397080'
            WHERE id = '8565';
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=0&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.273'
            , error_description = ''
            , memory_used = '38661208'
            WHERE id = '8566';
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=4&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.285'
            , error_description = ''
            , memory_used = '31182904'
            WHERE id = '8568';
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=5&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.311'
            , error_description = ''
            , memory_used = '43244704'
            WHERE id = '8567';
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_59_51_1695902391_35.json', 'e1p/28_09_2023/response_availability_sqtech_11_59_51_1695902391_35.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_35.json', 'expediapackage', '2023-09-28 11:59:53', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_59_51_1695902391_86.json', 'e1p/28_09_2023/response_availability_sqtech_11_59_51_1695902391_86.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_86.json', 'expediapackage', '2023-09-28 11:59:53', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expedia&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=3&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.570'
            , error_description = ''
            , memory_used = '42930352'
            WHERE id = '8569';
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_59_51_1695902391_66.json', 'e1p/28_09_2023/response_availability_sqtech_11_59_51_1695902391_66.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_66.json', 'expediapackage', '2023-09-28 11:59:53', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_59_51_1695902391_4.json', 'e1p/28_09_2023/response_availability_sqtech_11_59_51_1695902391_4.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_4.json', 'expediapackage', '2023-09-28 11:59:53', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_59_51_1695902391_57.json', 'e1p/28_09_2023/response_availability_sqtech_11_59_51_1695902391_57.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_57.json', 'expediapackage', '2023-09-28 11:59:53', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],INSERT INTO xmllogs(reservation_id, type, request_path, response_path, header_path, source_type, create_date, header, session_id, agent_logs_id)
                VALUE ('', 'availability', 'e1p/28_09_2023/request_availability_sqtech_11_59_51_1695902391_21.json', 'e1p/28_09_2023/response_availability_sqtech_11_59_51_1695902391_21.json', 'e1p/28_09_2023/response_header_availability_sqtech_11_59_51_1695902391_21.json', 'expediapackage', '2023-09-28 11:59:53', '', 'd6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e', '0');
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=2&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.775'
            , error_description = ''
            , memory_used = '42395680'
            WHERE id = '8570';
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=4&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '1.834'
            , error_description = ''
            , memory_used = '39244592'
            WHERE id = '8571';
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=1&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.022'
            , error_description = ''
            , memory_used = '43338576'
            WHERE id = '8573';
[09/28/2023 11:59:53], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=0&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.067'
            , error_description = ''
            , memory_used = '42223856'
            WHERE id = '8574';
[09/28/2023 11:59:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=3&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.076'
            , error_description = ''
            , memory_used = '51006160'
            WHERE id = '8572';
[09/28/2023 11:59:54], [file name :-/home/otrams/public_html/beta/call.php],UPDATE xmllogs SET
            hotel_count = ''
            , request_url = '/call.php?s=expediapackage&sessionid=d6566f27dc086654b17e412075e10c1f07dc1e4eeae5a1872e1bab7b8e36263e&xml_user_id=7839&db_caching=1&erequest=5&total_request=8&web_service=no&ip=43.239.53.130&browser=GoogleChrome%2F114.0.0.0%28linux%29&hotels_ids=&expediaRapidApi=&agent_country=106'
            , http_hit_time = '2023-09-28 11:59:51.926'
            , request_start_time = '0.000'
            , parsing_start_time = '0.000'
            , mapping_complete_time = '0.000'
            , mongo_start_time = '0.000'
            , search_end_time = '0.000'
            , total_duration = '2.151'
            , error_description = ''
            , memory_used = '46087576'
            WHERE id = '8575';
[09/28/2023 11:59:54], [file name :-/home/otrams/public_html/beta/m1_hotel_search_listing.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:54' WHERE id= '96';
[09/28/2023 11:59:57], [file name :-/home/otrams/public_html/beta/ajax/list_hotel.php],UPDATE user_sessions_ip SET update_date = '2023-09-28 11:59:57' WHERE id= '96';
