Alloggio e Colazione
Scegli l’Hotel Casa Real Havana a Cuba con Travelnet e prenota online il tuo viaggio a Cuba!
Una delle migliori case private (casa particular) coloniali vicino al Campidoglio dell'Avana nel cuore della città vecchia: La Casa Real Havana! Il posto migliore dove trascorrere le tue giornate all'Avana! Questa casa molto accogliente ti darà la possibilità di soggiornare in un posto ancora "cubano" nel centro storico dell'Avana , la vera Avana!
Ecco perché il nome "Real Havana". Il fascino di una casa coloniale completamente ristrutturata ad Aprile 2019 fornirà un buon servizio durante il vostro soggiorno. Questa casa Particular a L'Avana si distingue per avere tutti i servizi inclusi nel suo prezzo: colazione, Wi-Fi, asciugacapelli, cassaforte e pulizia giornaliera. Dispone inoltre di aria condizionata, TV a schermo piatto e minibar (non incluso).
È possibile prenotare tutti i tipi di servizi a Cuba come voli per Cayo Largo e soggiorni negli hotel in tutta Cuba ad ottime tariffe. Per la sua posizione perfetta puoi anche raggiungere in 5 minuti a piedi il Parque Central, il Floridita, e in soli 10 minuti a piedi la famosa via Obispo, la Piazza Vecchia, la Bodeguita del Medio e la Plaza de La Catedral !! Ti aspettiamo !!!
I migliori Hotel all’Avana al miglior prezzo. Non perdere il tuo viaggio all’Avana.
L’esperienza unica di visitare l’Avana a bordo di un auto degli anni 50, rivivendo il glamour dell’epoca piu’ affascinante ... maggiori informazioni
Prenota ed acquista questa splendida escursione con Travelnetcuba!! Partenza verso la valle di Vinales in provincia di Pinar del Rio , la provinci... maggiori informazioni
Prelievo in jeep presso l'alloggio del cliente all'Avana. Possibilità esclusiva di avere la guida e l'accompagnamento di una guida ... maggiori informazioni
Copyright © Travelnet 2006-2024.
Tutti i diritti riservati
|
Aiuto per i pagamenti online | Chi siamo... | Termini e condizioni |
Contatti
CUSTOMER SUPPORT CUBA
Telefono
(+53) 7 8333977, (+53) 7 8310461
ORARIO DEL SERVIZIO CLIENTI:
Lun - Ver: 9 am - 5 pm (EST)
Sab: 9 am - 1 pm (EST)
Indirizzo:
Edificio. ATLANTIC, calle D angolo con 1ra, Vedado - La Habana
options: path_info_key: PATH_INFO path_info_array: SERVER http_port: null https_port: null default_format: null trust_proxy: true logging: '1' relative_url_root: null formats: { txt: text/plain, js: [application/javascript, application/x-javascript, text/javascript], css: text/css, json: [application/json, application/x-json], xml: [text/xml, application/xml, application/x-xml], rdf: application/rdf+xml, atom: application/atom+xml } no_script_name: false parameterHolder: action: view current_item: hotel destination: Hotel_822 h1_title: 'Prenota la tua vacanza a Avana nel Casa Real Havana al miglior prezzo' module: hotel parent: hotels seo_description: '' sf_culture: it slug: casa-real-havana attributeHolder: sf_route: 'sfDoctrineRoute Object()'
status: code: 200 text: OK options: http_protocol: HTTP/2.0 logging: '1' charset: utf-8 send_http_headers: false content_type: 'text/html; charset=utf-8' cookies: { } httpHeaders: Content-Type: 'text/html; charset=utf-8' javascripts: /responsive/vendors/jquery/dist/jquery.min.js: { } /responsive/vendors/bootstrap/dist/js/bootstrap.min.js: { } /responsive/vendors/bootstrap-select/dist/js/bootstrap-select.min.js: { } /responsive/vendors/jquery-timepicker/jquery.timepicker.min.js: { } /responsive/vendors/icheck/icheck.min.js: { } /responsive/vendors/jquery-ui/jquery-ui.min.js: { } /responsive/js/global-script.js: { } /responsive/vendors/animate/spin.min.js: { } /responsive/js/handlebars.js: { } /responsive/js/typeahead.bundle.min.js: { } '/responsive/js/common.js?v3.03': { } /responsive/js/jquery.validate.js: { } /responsive/js/underscore-min.js: { } '/responsive/js/hotel.js?4': { } '/responsive/js/facilityPopover.js?3': { } /responsive/js/cubappSwipe.js: { } /responsive/js/smooth-scroll.min.js: { } /responsive/js/goUp.js: { } /responsive/vendors/jquery-ui/datepicker-it.js: { } stylesheets: /responsive/vendors/bootstrap/dist/css/bootstrap.min.css: { } '/responsive/vendors/font-awesome/css/font-awesome.css?v=1': { } /responsive/vendors/icheck/flat/red.css: { } /responsive/vendors/bootstrap-select/dist/css/bootstrap-select.min.css: { } /responsive/vendors/jquery-ui/jquery-ui.min.css: { } /responsive/css/modal.css: { } '/responsive/css/dist/global.min.css?v4.3': { } /responsive/vendors/jquery-timepicker/jquery.timepicker.css: { } /responsive/css/typeahead.css: { } /responsive/css/custom-clamp.css: { } '/responsive/css/hotel.css?6': { } metas: language: it title: 'Prenota la tua vacanza a Avana nel Casa Real Havana al miglior prezzo' description: 'Prenota la tua vacanza a Cuba nel Casa Real Havana al miglior prezzo, Le migliori offerte per l'Casa Real Havana a Cuba' keywords: 'Prenota la tua vacanza a Avana nel Casa Real Havana al miglior prezzo a Cuba' robots: 'noindex,nofollow' httpMetas: Content-Type: 'text/html; charset=utf-8'
options: auto_shutdown: false culture: it default_culture: en use_flash: true logging: '1' timeout: 1800 attributeHolder: symfony/user/sfUser/attributes: { currency: EUR, currency_value: '1.058710', enabled_cultures: [es, en, it], http_404_referer: hotel.view-/responsive_dev.php/it/hotel-casa-real-havana_avana-cuba, jsonld_metas: { '@context': 'http://schema.org', '@type': TravelAgency, image: 'https://www.travelnetcuba.com/uploads/assets/whoweare/logo.png', priceRange: '25 USD - 10000 USD', additionalType: 'https://www.travelnetcuba.com/it/', name: 'Travelnet LTD', logo: 'https://www.travelnetcuba.com/uploads/assets/whoweare/logo.png', description: 'Oltre 25 anni di esperienza a Cuba. Prenota e paga online le migliori offerte di Hotels, Tour ed Escursioni a Cuba. Programma il tuo viaggio e le tue vacanze a Cuba ai migliori prezzi con Travelnet Cuba.', telephone: '(+53) 7 8333977, (+53) 7 8310461', hasMap: 'https://www.google.com.cu/maps/place/Travelnet+Cuba/@23.1429603,-82.398929,15z/data=!4m2!3m1!1s0x0:0x7ae56859f4882f4d?sa=X&ved=0ahUKEwiape-A643UAhWqx4MKHWu2BwEQ_BIIlgEwDQ', geo: { '@type': GeoCoordinates, latitude: '23.1429603', longitude: '-82.398929' }, url: 'https://www.travelnetcuba.com/it/', sameAs: ['https://www.facebook.com/travelnetcuba', 'https://twitter.com/Travelnet_Cuba', 'https://www.instagram.com/travelnetcuba/?hl=it', 'https://plus.google.com/+TravelnetCubaHavana', 'https://www.youtube.com/channel/UCVe7uKxtZXejX5QZgDVYMyA'], contactPoint: { '@type': ContactPoint, contactType: 'Customer Service', telephone: '(+53) 7 8333977', email: sales@travelnetcuba.com, contactOption: TollFree, areaServed: Cuba, availableLanguage: 'Italiano,Inglés,Español' }, address: { '@type': PostalAddress, addressCountry: Cuba, addressLocality: Habana, addressRegion: Vedado, postalCode: '10400', streetAddress: 'Edificio Atlantic, Calle D, Esquina con 1ra' }, department: [{ '@type': Organization, name: 'Travelnet Hoteles', url: 'https://www.travelnetcuba.com/it/hotel-cuba-alberghi' }, { '@type': Organization, name: 'Travelnet Tours', url: 'https://www.travelnetcuba.com/it/tours-di-cuba' }, { '@type': Organization, name: 'Travelnet Combinados', url: 'https://www.travelnetcuba.com/it/combos-di-cuba' }, { '@type': Organization, name: 'Travelnet excursiones', url: 'https://www.travelnetcuba.com/it/escursioni-a-cuba' }, { '@type': Organization, name: 'Travelnet vuelos nacionales', url: 'https://www.travelnetcuba.com/it/voli-nazional' }, { '@type': Organization, name: 'Travelnet autos', url: 'https://www.travelnetcuba.com/it/offerte-auto-cuba' }], aggregateRating: { '@type': AggregateRating, ratingValue: '4,7', reviewCount: '160', bestRating: '5' }, openingHoursSpecification: [{ '@type': OpeningHoursSpecification, dayOfWeek: [Monday, Tuesday, Wednesday, Thursday, Friday], opens: '09:00', closes: '17:00' }, { '@type': OpeningHoursSpecification, dayOfWeek: [Saturday], opens: '09:00', closes: '12:00' }] }, language: it, sf_currencies: { USD: '1.000000', EUR: '1.058710', CAD: '0.739322', CUP: '0.008333' } } culture: it authenticated: false credentials: { } lastRequest: 1715266455
app_ad_photo_big_height: 500 app_ad_photo_big_width: 1000 app_ad_photo_medium_height: 85 app_ad_photo_medium_width: 145 app_ad_photo_small_height: 50 app_ad_photo_small_width: 50 app_ad_photo_upload_dir: assets/ads app_adgroup_photo_big_height: 500 app_adgroup_photo_big_width: 1000 app_adgroup_photo_medium_height: 85 app_adgroup_photo_medium_width: 145 app_adgroup_photo_small_height: 50 app_adgroup_photo_small_width: 50 app_adgroup_photo_upload_dir: assets/ad_groups app_amf_comercio: 131551467398 app_amf_moneda: 978 app_amf_palabra: Q7uWO%j(Hra6nZ6k@^L@ app_breadcrumb_separator: ' » ' app_car_brand_big_height: 388 app_car_brand_big_width: 674 app_car_brand_medium_height: 105 app_car_brand_medium_width: 165 app_car_brand_small_height: 50 app_car_brand_small_width: 50 app_car_brand_upload_dir: assets/car_brands app_car_photo_big_height: 500 app_car_photo_big_width: 1000 app_car_photo_medium_height: 112 app_car_photo_medium_width: 227 app_car_photo_small_height: 75 app_car_photo_small_width: 120 app_car_photo_square_height: 50 app_car_photo_square_width: 50 app_car_photo_upload_dir: assets/cars app_collection_photo_big_height: 500 app_collection_photo_big_width: 1000 app_collection_photo_medium_height: 85 app_collection_photo_medium_width: 145 app_collection_photo_small_height: 50 app_collection_photo_small_width: 50 app_collection_photo_upload_dir: assets/collections app_contact_comercial: gferrara@travelnet.cu app_contact_director: lpaciello@travelnetcuba.com app_contact_sales: sales@travelnetcuba.com app_contact_sales_rusia: omar@travelnetcuba.com app_contact_webdeveloper: maikel.gonzalez@gmail.com app_cultures_default_currency: es: EUR en: USD it: EUR app_cultures_enabled: es: Español en: English it: Italiano ru: Ruso app_cultures_list: - it - es - en - ru app_destination_photo_big_height: 500 app_destination_photo_big_width: 1000 app_destination_photo_medium_height: 90 app_destination_photo_medium_width: 150 app_destination_photo_small_height: 75 app_destination_photo_small_width: 120 app_destination_photo_square_height: 50 app_destination_photo_square_width: 50 app_destination_photo_upload_dir: assets/destinations app_equipe_photo_big_height: 338 app_equipe_photo_big_width: 784 app_equipe_photo_upload_dir: assets/equipe app_flight_company_big_height: 500 app_flight_company_big_width: 1000 app_flight_company_height: 80 app_flight_company_medium_height: 174 app_flight_company_medium_width: 347 app_flight_company_small_height: 50 app_flight_company_small_width: 50 app_flight_company_upload_dir: assets/flight_company app_flight_company_width: 80 app_flight_route_height: 80 app_flight_route_upload_dir: assets/flight_route app_flight_route_width: 120 app_gallery_photo_big_height: 870 app_gallery_photo_big_width: 1200 app_gallery_photo_thumb_height: 200 app_gallery_photo_thumb_width: 200 app_gallery_photo_upload_dir: assets/gallery app_generic_photo_big_height: 500 app_generic_photo_big_width: 1000 app_generic_photo_medium_height: 174 app_generic_photo_medium_width: 347 app_generic_photo_small_height: 50 app_generic_photo_small_width: 50 app_generic_photo_upload_dir: assets/generic app_google_sitemap_default: url: 'http://www.travelnetcuba.com' freq: daily priority: 1 app_hotel_photo_big_height: 500 app_hotel_photo_big_width: 1000 app_hotel_photo_medium_height: 174 app_hotel_photo_medium_width: 347 app_hotel_photo_small_height: 75 app_hotel_photo_small_width: 120 app_hotel_photo_square_height: 50 app_hotel_photo_square_width: 50 app_hotel_photo_upload_dir: assets/hotels app_house_photo_big_height: 500 app_house_photo_big_width: 1000 app_house_photo_medium_height: 174 app_house_photo_medium_width: 347 app_house_photo_small_height: 75 app_house_photo_small_width: 120 app_house_photo_square_height: 50 app_house_photo_square_width: 50 app_house_photo_upload_dir: assets/houses app_images_dir_car: /images/cars/ app_images_dir_car_thumb: /images/cars/thumbnails/ app_images_dir_hotel: /images/hotels/ app_images_dir_hotel_thumb: /images/hotels/thumbnails/ app_max_items_x_page: 15 app_max_links_x_pager: 10 app_menues_list: top_menu: 'Menu Superior 2' main_menu: 'Menu Principal' top_menu_mini: 'Mini Menu Superior 1' top_menu_alt: 'Mini Menu Superior Alternativo 4' left_menu: 'Menu Lateral Izquierda' footer_menu: 'Menu Pie de página' top_footer_menu: 'Menues superior 2 y pie de página' hidden: Oculta app_office_db_webhook_url: 'http://localhost/matusalen_dev.php' app_office_server_ip: 192.168.0.100 app_ohMailChimp_aid: 276843c1359c24752c5a0acbb app_ohMailChimp_api_key: c9f4615f9a1affad76d4629531069c5c-us1 app_ohMailChimp_list_id: es: 6b0882eba5 en: 4803c4e415 it: 6e60382770 ru: 4803c4e415 all: 5a5df0040d app_proxy_host: 192.168.0.111 app_proxy_port: 3128 app_room_photo_big_height: 500 app_room_photo_big_width: 1000 app_room_photo_medium_height: 174 app_room_photo_medium_width: 347 app_room_photo_small_height: 75 app_room_photo_small_width: 120 app_room_photo_square_height: 50 app_room_photo_square_width: 50 app_room_photo_upload_dir: assets/hotel_rooms app_school_photo_big_height: 338 app_school_photo_big_width: 784 app_school_photo_upload_dir: assets/school app_templates_list: normal: Normal app_tour_photo_big_height: 500 app_tour_photo_big_width: 1000 app_tour_photo_medium_height: 174 app_tour_photo_medium_width: 347 app_tour_photo_small_height: 75 app_tour_photo_small_width: 120 app_tour_photo_square_height: 50 app_tour_photo_square_width: 50 app_tour_photo_upload_dir: assets/tours app_trip_photo_big_height: 500 app_trip_photo_big_width: 1000 app_trip_photo_medium_height: 174 app_trip_photo_medium_width: 347 app_trip_photo_small_height: 75 app_trip_photo_small_width: 120 app_trip_photo_square_height: 50 app_trip_photo_square_width: 50 app_trip_photo_upload_dir: assets/trips app_urchin_code: UA-6791462-2 app_ws_ns: 'http://www.e-resline.com/' app_ws_password: travelnet2013 app_ws_user: wstravelnet app_yacht_photo_big_height: 500 app_yacht_photo_big_width: 1000 app_yacht_photo_medium_height: 174 app_yacht_photo_medium_width: 347 app_yacht_photo_small_height: 50 app_yacht_photo_small_width: 50 app_yacht_photo_upload_dir: assets/yachts mod_hotel_enabled: true mod_hotel_view_class: sfPHP mod_main_enabled: true mod_main_view_class: sfPHP sf_admin_module_web_dir: /sfDoctrinePlugin sf_admin_web_dir: /sf/sf_admin sf_app: responsive sf_app_base_cache_dir: /var/www/travelnetcuba.com/cache/responsive sf_app_cache_dir: /var/www/travelnetcuba.com/cache/responsive/dev sf_app_config_dir: /var/www/travelnetcuba.com/apps/responsive/config sf_app_dir: /var/www/travelnetcuba.com/apps/responsive sf_app_i18n_dir: /var/www/travelnetcuba.com/apps/responsive/i18n sf_app_lib_dir: /var/www/travelnetcuba.com/apps/responsive/lib sf_app_module_dir: /var/www/travelnetcuba.com/apps/responsive/modules sf_app_template_dir: /var/www/travelnetcuba.com/apps/responsive/templates sf_apps_dir: /var/www/travelnetcuba.com/apps sf_cache: false sf_cache_dir: /var/www/travelnetcuba.com/cache sf_charset: utf-8 sf_check_lock: false sf_cli: false sf_compressed: false sf_config_cache_dir: /var/www/travelnetcuba.com/cache/responsive/dev/config sf_config_dir: /var/www/travelnetcuba.com/config sf_csrf_secret: false sf_data_dir: /var/www/travelnetcuba.com/data sf_debug: true sf_default_culture: en sf_enabled_modules: - default sf_environment: dev sf_error_404_action: error404 sf_error_404_module: main sf_error_reporting: 24575 sf_escaping_method: ESC_SPECIALCHARS sf_escaping_strategy: false sf_etag: false sf_file_link_format: null sf_i18n: on sf_i18n_cache_dir: /var/www/travelnetcuba.com/cache/responsive/dev/i18n sf_lib_dir: /var/www/travelnetcuba.com/lib sf_log_dir: /var/www/travelnetcuba.com/log sf_logging_enabled: true sf_login_action: login sf_login_module: default sf_module_cache_dir: /var/www/travelnetcuba.com/cache/responsive/dev/modules sf_module_disabled_action: disabled sf_module_disabled_module: default sf_no_script_name: false sf_orm: doctrine sf_plugins_dir: /var/www/travelnetcuba.com/plugins sf_psr_logger: false sf_root_dir: /var/www/travelnetcuba.com sf_secure_action: secure sf_secure_module: default sf_standard_helpers: - Partial - Form - Object - I18N - Cache - Tn - Responsive sf_symfony_lib_dir: /var/www/travelnetcuba.com/lib/symfony/lib sf_template_cache_dir: /var/www/travelnetcuba.com/cache/responsive/dev/template sf_test_cache_dir: /var/www/travelnetcuba.com/cache/responsive/dev/test sf_test_dir: /var/www/travelnetcuba.com/test sf_upload_dir: /var/www/travelnetcuba.com/web/uploads sf_upload_dir_name: uploads sf_use_database: true sf_web_debug: true sf_web_debug_web_dir: /sf/sf_web_debug sf_web_dir: /var/www/travelnetcuba.com/web symfony.asset.javascripts_included: true symfony.asset.stylesheets_included: true
cookie: { } env: { } files: { } get: { } post: { } server: CONTENT_LENGTH: '' CONTENT_TYPE: '' DOCUMENT_ROOT: /var/www/travelnetcuba.com/html DOCUMENT_URI: /responsive_dev.php/it/hotel-casa-real-havana_avana-cuba FCGI_ROLE: RESPONDER GATEWAY_INTERFACE: CGI/1.1 HOME: /var/www HTTPS: on HTTP_ACCEPT: '*/*' HTTP_HOST: www.travelnetcuba.com HTTP_REFERER: 'https://www.travelnetcuba.com/responsive_dev.php/it/hotel-casa-real-havana_la-habana-cuba?data%5Bcrs%5D=1&data%5Bdestination%5D=Hotel_822&data%5Bcheckin%5D=08-05-2019&data%5Bcheckout%5D=11-05-2019&data%5Badults%5D=2&data%5Bchilds%5D=0&data%5Bbudget%5D=0-1500&data%5Bcurrency%5D=USD' HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)' PHP_SELF: /responsive_dev.php QUERY_STRING: '' REDIRECT_STATUS: '200' REMOTE_ADDR: 3.144.77.71 REMOTE_PORT: '2520' REQUEST_METHOD: GET REQUEST_SCHEME: https REQUEST_TIME: 1715266455 REQUEST_TIME_FLOAT: 1715266455.9235 REQUEST_URI: /responsive_dev.php/it/hotel-casa-real-havana_avana-cuba SCRIPT_FILENAME: /var/www/travelnetcuba.com/html/responsive_dev.php SCRIPT_NAME: /responsive_dev.php SERVER_ADDR: 80.211.4.15 SERVER_NAME: 80.211.4.15 SERVER_PORT: '443' SERVER_PROTOCOL: HTTP/2.0 SERVER_SOFTWARE: nginx/1.18.0 USER: www-data session: { }
php: 7.4.11 os: 'Linux travelnet.travelnet.cu 5.4.0-172-generic #190-Ubuntu SMP Fri Feb 2 23:24:22 UTC 2024 x86_64' extensions: 18: 'bcmath (7.4.11)' 19: 'bz2 (7.4.11)' 20: 'calendar (7.4.11)' 13: 'cgi-fcgi (7.4.11)' 0: 'Core (7.4.11)' 21: 'ctype (7.4.11)' 1: 'date (7.4.11)' 22: 'dom (20031129)' 33: 'exif (7.4.11)' 24: 'FFI (7.4.11)' 25: 'fileinfo (7.4.11)' 6: 'filter (7.4.11)' 26: 'ftp (7.4.11)' 27: 'gd (7.4.11)' 28: 'gettext (7.4.11)' 7: 'hash (7.4.11)' 29: 'iconv (7.4.11)' 30: 'igbinary (3.1.2)' 31: 'intl (7.4.11)' 32: 'json (7.4.11)' 2: 'libxml (7.4.11)' 23: 'mbstring (7.4.11)' 55: 'memcached (3.1.4)' 34: 'msgpack (2.1.0)' 35: 'mysqli (7.4.11)' 15: 'mysqlnd (mysqlnd 7.4.11)' 3: 'openssl (7.4.11)' 4: 'pcre (7.4.11)' 16: 'PDO (7.4.11)' 36: 'pdo_mysql (7.4.11)' 37: 'pdo_sqlite (7.4.11)' 38: 'Phar (7.4.11)' 39: 'posix (7.4.11)' 40: 'readline (7.4.11)' 41: 'redis (5.3.1)' 8: 'Reflection (7.4.11)' 10: 'session (7.4.11)' 42: 'shmop (7.4.11)' 43: 'SimpleXML (7.4.11)' 44: 'sockets (7.4.11)' 12: 'sodium (7.4.11)' 9: 'SPL (7.4.11)' 45: 'sqlite3 (7.4.11)' 11: 'standard (7.4.11)' 14: 'swoole (4.5.3-alpha)' 46: 'sysvmsg (7.4.11)' 47: 'sysvsem (7.4.11)' 48: 'sysvshm (7.4.11)' 49: 'tidy (7.4.11)' 50: 'tokenizer (7.4.11)' 17: 'xml (7.4.11)' 51: 'xmlreader (7.4.11)' 52: 'xmlwriter (7.4.11)' 53: 'xsl (7.4.11)' 56: 'Zend OPcache (7.4.11)' 54: 'zip (1.15.6)' 5: 'zlib (7.4.11)'
version: 1.5.14-dev path: /var/www/travelnetcuba.com/lib/symfony/lib
Parameters:
$hotel
(Hotel)$params
(array)$rooms
(Doctrine_Collection)$destination
(Destination)$has_offers
(boolean)$photos
(Doctrine_Collection)$show_plan
(boolean)$facilities
(array)$trips
(Doctrine_Collection)$comments
(Doctrine_Collection)No parameters were passed to this template.
Parameters:
$options_for_destination
(string)Parameters:
$line_items
(array)$currency_choices
(array)Parameters:
$destination_name
(string)$hotels
(array)Parameters:
$product
(Hotel)$photos
(Doctrine_Collection)Parameters:
$hotel
(Hotel)No parameters were passed to this template.
No parameters were passed to this template.
Parameters:
$i18n_urls
(array)$destinations
(Doctrine_Collection)$cars
(Doctrine_Collection)$trip_destinations
(Doctrine_Collection)$tours
(Doctrine_Collection)$combos
(Doctrine_Collection)$info
(Cms)Parameters:
$i18n_urls
(array)$destinations
(Doctrine_Collection)$cars
(Doctrine_Collection)$trip_destinations
(Doctrine_Collection)$tours
(Doctrine_Collection)$combos
(Doctrine_Collection)$info
(Cms)# | type | message |
---|---|---|
1 | zxPatternI18NRouting | Connect sfRoute "headline_es" (/:sf_culture/covid19-informaciones-y-ofertas) |
2 | zxPatternI18NRouting | Connect sfRoute "headline_en" (/:sf_culture/covid19-informations-and-offers) |
3 | zxPatternI18NRouting | Connect sfRoute "headline_it" (/:sf_culture/covi19-informazioni-e-offerte) |
4 | zxPatternI18NRouting | Connect sfRoute "transaction_complete_es" (/:sf_culture/transaccion-completada) |
5 | zxPatternI18NRouting | Connect sfRoute "transaction_complete_en" (/:sf_culture/transaction-complete) |
6 | zxPatternI18NRouting | Connect sfRoute "transaction_status_es" (/:sf_culture/transaccion-estado) |
7 | zxPatternI18NRouting | Connect sfRoute "transaction_status_en" (/:sf_culture/transaction-status) |
8 | zxPatternI18NRouting | Connect sfDoctrineRoute "hotels_es" (/:sf_culture/hoteles-en-cuba) |
9 | zxPatternI18NRouting | Connect sfDoctrineRoute "hotels_en" (/:sf_culture/cuba-hotels) |
10 | zxPatternI18NRouting | Connect sfDoctrineRoute "hotels_it" (/:sf_culture/hotel-cuba-alberghi) |
11 | zxPatternI18NRouting | Connect sfDoctrineRoute "hotels_ru" (/:sf_culture/oteli-na-kube) |
12 | zxPatternI18NRouting | Connect sfDoctrineRoute "destination_es" (/:sf_culture/hoteles-en-:slug-cuba) |
13 | zxPatternI18NRouting | Connect sfDoctrineRoute "destination_en" (/:sf_culture/hotels-in-:slug-cuba) |
14 | zxPatternI18NRouting | Connect sfDoctrineRoute "destination_it" (/:sf_culture/hotel-alberghi-:slug-cuba) |
15 | zxPatternI18NRouting | Connect sfDoctrineRoute "destination_ru" (/:sf_culture/oteli-na-:slug-kuba) |
16 | zxPatternI18NRouting | Connect sfRoute "offers_es" (/:sf_culture/ofertas-especiales) |
17 | zxPatternI18NRouting | Connect sfRoute "offers_it" (/:sf_culture/offerte-speciali) |
18 | zxPatternI18NRouting | Connect sfRoute "offers_ru" (/:sf_culture/specialnye-predlozheniya) |
19 | zxPatternI18NRouting | Connect sfDoctrineRoute "hotel_ru" (/:sf_culture/otel-:slug_:destination-kuba) |
20 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_hotel_es" (/:sf_culture/reservar-hotel-:slug-cuba) |
21 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_hotel_it" (/:sf_culture/prenotazione-hotel-:slug-cuba) |
22 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_hotel_ru" (/:sf_culture/zabronirovat-otel-:slug-kuba) |
23 | zxPatternI18NRouting | Connect sfRoute "search_hotel_es" (/:sf_culture/buscar-ofertas-de-hoteles) |
24 | zxPatternI18NRouting | Connect sfRoute "search_hotel_en" (/:sf_culture/search-hotel-offers) |
25 | zxPatternI18NRouting | Connect sfRoute "search_hotel_it" (/:sf_culture/cerca-offerte-hotel) |
26 | zxPatternI18NRouting | Connect sfRoute "search_hotel_ru" (/:sf_culture/iskat-predlozheniya-po-otelyam) |
27 | zxPatternI18NRouting | Connect sfRoute "search_car_es" (/:sf_culture/buscar-ofertas-de-autos) |
28 | zxPatternI18NRouting | Connect sfRoute "search_car_en" (/:sf_culture/search-car-offers) |
29 | zxPatternI18NRouting | Connect sfRoute "search_car_it" (/:sf_culture/cerca-offerte-auto) |
30 | zxPatternI18NRouting | Connect sfRoute "search_car_ru" (/:sf_culture/iskat-predlozheniya-po-avtomobilyam) |
31 | zxPatternI18NRouting | Connect sfRoute "search_transfer_es" (/:sf_culture/buscar-transfer) |
32 | zxPatternI18NRouting | Connect sfRoute "search_transfer_it" (/:sf_culture/cerca-transfer) |
33 | zxPatternI18NRouting | Connect sfRoute "search_transfer_ru" (/:sf_culture/iskat-transfer) |
34 | zxPatternI18NRouting | Connect sfRoute "search_trip_es" (/:sf_culture/buscar-excursion) |
35 | zxPatternI18NRouting | Connect sfRoute "search_trip_it" (/:sf_culture/cerca-excursioni) |
36 | zxPatternI18NRouting | Connect sfRoute "search_trip_ru" (/:sf_culture/iskat-excursion) |
37 | zxPatternI18NRouting | Connect sfRoute "search_flight_es" (/:sf_culture/buscar-ofertas-de-vuelos) |
38 | zxPatternI18NRouting | Connect sfRoute "search_flight_en" (/:sf_culture/cheap-flight-offers) |
39 | zxPatternI18NRouting | Connect sfRoute "search_flight_it" (/:sf_culture/cerca-offerte-volo) |
40 | zxPatternI18NRouting | Connect sfRoute "search_flight_ru" (/:sf_culture/iskat-predlozheniya-po-rejsam) |
41 | zxPatternI18NRouting | Connect sfDoctrineRoute "cuba_map_es" (/:sf_culture/mapa-hoteles-en-cuba) |
42 | zxPatternI18NRouting | Connect sfDoctrineRoute "cuba_map_it" (/:sf_culture/mappa-di-hotel-cuba) |
43 | zxPatternI18NRouting | Connect sfDoctrineRoute "cuba_map_ru" (/:sf_culture/karta-oteli-na-kube) |
44 | zxPatternI18NRouting | Connect sfDoctrineRoute "destinations_es" (/:sf_culture/destino-cuba) |
45 | zxPatternI18NRouting | Connect sfDoctrineRoute "destinations_it" (/:sf_culture/destinazione-cuba) |
46 | zxPatternI18NRouting | Connect sfDoctrineRoute "destinations_ru" (/:sf_culture/napravlenie-kuba) |
47 | zxPatternI18NRouting | Connect sfRoute "cars_old_es" (/:sf_culture/autos/) |
48 | zxPatternI18NRouting | Connect sfRoute "cars_old_it" (/:sf_culture/auto/) |
49 | zxPatternI18NRouting | Connect sfDoctrineRoute "cars_es" (/:sf_culture/oferta-autos-cuba) |
50 | zxPatternI18NRouting | Connect sfDoctrineRoute "cars_en" (/:sf_culture/cars-offers-cuba) |
51 | zxPatternI18NRouting | Connect sfDoctrineRoute "cars_it" (/:sf_culture/offerte-auto-cuba) |
52 | zxPatternI18NRouting | Connect sfDoctrineRoute "cars_ru" (/:sf_culture/predlozhenie-avto-kuba) |
53 | zxPatternI18NRouting | Connect sfDoctrineRoute "car_category_es" (/:sf_culture/renta-de-auto-:slug-en-cuba) |
54 | zxPatternI18NRouting | Connect sfDoctrineRoute "car_category_it" (/:sf_culture/prenotazione-auto-:slug-cuba) |
55 | zxPatternI18NRouting | Connect sfDoctrineRoute "car_category_ru" (/:sf_culture/arenda-avtomobilej-:slug-na-kube) |
56 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_car_es" (/:sf_culture/bk-rentar-auto-:id) |
57 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_car_it" (/:sf_culture/bk-prenotazione-auto-:id) |
58 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_car_ru" (/:sf_culture/bk-arenda-avtomobilej-:id) |
59 | zxPatternI18NRouting | Connect sfDoctrineRoute "car_es" (/:sf_culture/d-auto-:slug) |
60 | zxPatternI18NRouting | Connect sfDoctrineRoute "car_en" (/:sf_culture/d-car-:slug) |
61 | zxPatternI18NRouting | Connect sfDoctrineRoute "car_it" (/:sf_culture/d-prenotazione-auto-:slug) |
62 | zxPatternI18NRouting | Connect sfDoctrineRoute "car_ru" (/:sf_culture/d-avto-:slug) |
63 | zxPatternI18NRouting | Connect sfRoute "contact_es" (/:sf_culture/contacto) |
64 | zxPatternI18NRouting | Connect sfRoute "contact_it" (/:sf_culture/contattaci) |
65 | zxPatternI18NRouting | Connect sfRoute "contacted_es" (/:sf_culture/solicitud-enviada) |
66 | zxPatternI18NRouting | Connect sfDoctrineRoute "flight_schedules_es" (/:sf_culture/vuelos-a-cuba) |
67 | zxPatternI18NRouting | Connect sfDoctrineRoute "flight_schedules_en" (/:sf_culture/cheap-flights-to-cuba) |
68 | zxPatternI18NRouting | Connect sfDoctrineRoute "flight_schedules_it" (/:sf_culture/voli-per-cuba) |
69 | zxPatternI18NRouting | Connect sfDoctrineRoute "flight_schedules_ru" (/:sf_culture/rejsy-na-kubu) |
70 | zxPatternI18NRouting | Connect sfDoctrineRoute "domestic_flight_old_es" (/:sf_culture/vuelos-nacionales) |
71 | zxPatternI18NRouting | Connect sfDoctrineRoute "domestic_flight_old_en" (/:sf_culture/national-flights) |
72 | zxPatternI18NRouting | Connect sfDoctrineRoute "domestic_flight_old_it" (/:sf_culture/voli-nazional) |
73 | zxPatternI18NRouting | Connect sfDoctrineRoute "domestic_flight_old_ru" (/:sf_culture/nacionalnye-rejsy) |
74 | zxPatternI18NRouting | Connect sfDoctrineRoute "domestic_flight_es" (/:sf_culture/vuelos-a-cayo-largo) |
75 | zxPatternI18NRouting | Connect sfDoctrineRoute "domestic_flight_en" (/:sf_culture/cayo-largo-flights) |
76 | zxPatternI18NRouting | Connect sfDoctrineRoute "domestic_flight_it" (/:sf_culture/voli-a-cayo-largo) |
77 | zxPatternI18NRouting | Connect sfDoctrineRoute "domestic_flight_ru" (/:sf_culture/nacionalnye-rejsy) |
78 | zxPatternI18NRouting | Connect sfRoute "flight_schedules_old_es" (/:sf_culture/vuelos/) |
79 | zxPatternI18NRouting | Connect sfRoute "flight_schedules_old_en" (/:sf_culture/flights/) |
80 | zxPatternI18NRouting | Connect sfRoute "flight_schedules_old_it" (/:sf_culture/voli/) |
81 | zxPatternI18NRouting | Connect sfRoute "flight_schedules_pagging_old_es" (/:sf_culture/vuelos/:page) |
82 | zxPatternI18NRouting | Connect sfRoute "flight_schedules_pagging_old_en" (/:sf_culture/flights/:page) |
83 | zxPatternI18NRouting | Connect sfRoute "flight_schedules_pagging_old_it" (/:sf_culture/voli/:page) |
84 | zxPatternI18NRouting | Connect sfRoute "flight_schedules_pagging_old_ru" (/:sf_culture/rejsy/:stranica) |
85 | zxPatternI18NRouting | Connect sfDoctrineRoute "flight_schedule_es" (/:sf_culture/vuelo-:slug-:id) |
86 | zxPatternI18NRouting | Connect sfDoctrineRoute "flight_schedule_it" (/:sf_culture/voli-:slug-:id) |
87 | zxPatternI18NRouting | Connect sfDoctrineRoute "flight_schedule_ru" (/:sf_culture/rejs-:slug-:id) |
88 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_flight_schedule_es" (/:sf_culture/reservar-vuelo-:slug-:id) |
89 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_flight_schedule_it" (/:sf_culture/prenotazione-voli-:slug-:id) |
90 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_flight_schedule_ru" (/:sf_culture/bron-rejs-:slug-:id) |
91 | zxPatternI18NRouting | Connect sfDoctrineRoute "transfers_es" (/:sf_culture/traslados-en-cuba) |
92 | zxPatternI18NRouting | Connect sfDoctrineRoute "transfers_en" (/:sf_culture/transfers-in-cuba) |
93 | zxPatternI18NRouting | Connect sfDoctrineRoute "transfers_it" (/:sf_culture/transferimenti-cuba) |
94 | zxPatternI18NRouting | Connect sfDoctrineRoute "transfers_ru" (/:sf_culture/transfers-kubu) |
95 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_transfer_es" (/:sf_culture/reservar-traslado-desde-:departure-hasta-:arrival-:id) |
96 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_transfer_it" (/:sf_culture/prenotazione-transferimento-da-:departure-a-:arrival-:id) |
97 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_transfer_ru" (/:sf_culture/bron-transfer-from-:departure-to-:arrival-:id) |
98 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_trips_es" (/:sf_culture/escursiones-en-cuba) |
99 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_trips_en" (/:sf_culture/excursions-in-cuba) |
100 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_trips_it" (/:sf_culture/escursioni-a-cuba) |
101 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_trips_ru" (/:sf_culture/ehkskursii-kuba) |
102 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_trip_destination_es" (/:sf_culture/escursiones-:slug-cuba) |
103 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_trip_destination_it" (/:sf_culture/escursioni-:slug-cuba) |
104 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_trip_destination_ru" (/:sf_culture/ehkskursii-:slug-kuba) |
105 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_trip_es" (/:sf_culture/escursion-:slug) |
106 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_trip_it" (/:sf_culture/escursione-:slug) |
107 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_trip_ru" (/:sf_culture/ehkskursiya-:slug) |
108 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_trip_es" (/:sf_culture/reservar-excursion-:slug-cuba) |
109 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_trip_it" (/:sf_culture/prenotazione-escursione-:slug-cuba) |
110 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_trip_ru" (/:sf_culture/bron-ehkskursiya-:slug-kuba) |
111 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_tours_es" (/:sf_culture/tours-en-cuba) |
112 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_tours_en" (/:sf_culture/tours-in-cuba) |
113 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_tours_it" (/:sf_culture/tours-di-cuba) |
114 | zxPatternI18NRouting | Connect sfDoctrineRoute "cms_tours_ru" (/:sf_culture/tury-na-kube) |
115 | zxPatternI18NRouting | Connect sfDoctrineRoute "combos_es" (/:sf_culture/combinados-en-cuba) |
116 | zxPatternI18NRouting | Connect sfDoctrineRoute "combos_en" (/:sf_culture/combos-in-cuba) |
117 | zxPatternI18NRouting | Connect sfDoctrineRoute "combos_it" (/:sf_culture/combos-di-cuba) |
118 | zxPatternI18NRouting | Connect sfDoctrineRoute "combos_ru" (/:sf_culture/combo-na-kube) |
119 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_combo_es" (/:sf_culture/reservar-combinado-:slug-cuba) |
120 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_combo_it" (/:sf_culture/prenotazione-combo-:slug-cuba) |
121 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_combo_ru" (/:sf_culture/bron-combo-:slug-kuba) |
122 | zxPatternI18NRouting | Connect sfDoctrineRoute "combo_es" (/:sf_culture/combinado-:slug-cuba) |
123 | zxPatternI18NRouting | Connect sfDoctrineRoute "combo_ru" (/:sf_culture/combo-:slug-kuba) |
124 | zxPatternI18NRouting | Connect sfDoctrineRoute "combo_flight_es" (/:sf_culture/vuelo+hotel-:slug) |
125 | zxPatternI18NRouting | Connect sfDoctrineRoute "combo_flight_it" (/:sf_culture/volo+albergo-:slug) |
126 | zxPatternI18NRouting | Connect sfDoctrineRoute "combo_flight_ru" (/:sf_culture/combo-:slug-kuba) |
127 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_tour_es" (/:sf_culture/reservar-tour-:slug-cuba) |
128 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_tour_it" (/:sf_culture/prenotazione-tour-:slug-cuba) |
129 | zxPatternI18NRouting | Connect sfDoctrineRoute "book_tour_ru" (/:sf_culture/bron-tur-:slug-kuba) |
130 | zxPatternI18NRouting | Connect sfRoute "cart_es" (/:sf_culture/cesta) |
131 | zxPatternI18NRouting | Connect sfRoute "checkout_es" (/:sf_culture/caja) |
132 | zxPatternI18NRouting | Connect sfRoute "cart_requested_es" (/:sf_culture/cart-solicitud-enviada) |
133 | zxPatternI18NRouting | Connect sfRoute "cart_requested_en" (/:sf_culture/cart-sent-request) |
134 | zxPatternI18NRouting | Connect sfRoute "sitemap_es" (/:sf_culture/mapa-de-sitio) |
135 | zxPatternI18NRouting | Connect sfRoute "search_es" (/:sf_culture/buscar) |
136 | zxPatternI18NRouting | Connect sfRoute "search_it" (/:sf_culture/cerca) |
137 | zxPatternI18NRouting | Connect sfRoute "search_ru" (/:sf_culture/poisk) |
138 | zxPatternI18NRouting | Connect sfRoute "search_tour_es" (/:sf_culture/buscar-ofertas-de-tours) |
139 | zxPatternI18NRouting | Connect sfRoute "search_tour_en" (/:sf_culture/search-tour-offers) |
140 | zxPatternI18NRouting | Connect sfRoute "search_tour_it" (/:sf_culture/cerca-offerte-tour) |
141 | zxPatternI18NRouting | Connect sfRoute "search_tour_ru" (/:sf_culture/iskat-predlozheniya-po-tur) |
142 | zxPatternI18NRouting | Connect sfRoute "search_combo_es" (/:sf_culture/buscar-ofertas-de-combos) |
143 | zxPatternI18NRouting | Connect sfRoute "search_combo_en" (/:sf_culture/search-combos-offers) |
144 | zxPatternI18NRouting | Connect sfRoute "search_combo_it" (/:sf_culture/cerca-offerte-combos) |
145 | zxPatternI18NRouting | Connect sfRoute "search_combo_ru" (/:sf_culture/iskat-predlozheniya-po-tur) |
146 | zxPatternI18NRouting | Connect sfDoctrineRoute "house_es" (/:sf_culture/casa-particular-:slug_:destination-cuba) |
147 | zxPatternI18NRouting | Connect sfDoctrineRoute "house_en" (/:sf_culture/private-house-:slug_:destination-cuba) |
148 | zxPatternI18NRouting | Connect sfDoctrineRoute "house_it" (/:sf_culture/casa-private-:slug_:destination-cuba) |
149 | zxPatternI18NRouting | Connect sfDoctrineRoute "house_ru" (/:sf_culture/chastnyj-sektor:slug_:destination-kuba) |
150 | zxPatternI18NRouting | Match route "hotel" (/:sf_culture/hotel-:slug_:destination-cuba) for /it/hotel-casa-real-havana_avana-cuba with parameters array ( 'module' => 'hotel', 'action' => 'view', 'current_item' => 'hotel', 'parent' => 'hotels', 'sf_culture' => 'it', 'slug' => 'casa-real-havana', 'destination' => 'avana',) |
151 | sfFilterChain | Executing filter "sfRenderingFilter" |
152 | sfFilterChain | Executing filter "internationalFilter" |
153 | Doctrine_Connection_Mysql | exec : SET NAMES 'UTF8' - () |
154 | Doctrine_Connection_Mysql | query : SELECT currency FROM currency WHERE code = 'EUR' LIMIT 1 - () |
155 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at, h2.id AS h2__id, h2.description AS h2__description, h2.facilities AS h2__facilities, h2.tours AS h2__tours, h2.rooms AS h2__rooms, h2.address AS h2__address, h2.photo_title AS h2__photo_title, h2.lang AS h2__lang, h2.slug AS h2__slug, h2.h1_title AS h2__h1_title, h2.meta_title AS h2__meta_title, h2.meta_description AS h2__meta_description, h2.seo_description AS h2__seo_description, h2.meta_keywords AS h2__meta_keywords FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id WHERE (h2.slug = ? AND h.is_published = ?) - (casa-real-havana, 1) |
156 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at, h2.id AS h2__id, h2.description AS h2__description, h2.facilities AS h2__facilities, h2.tours AS h2__tours, h2.rooms AS h2__rooms, h2.address AS h2__address, h2.photo_title AS h2__photo_title, h2.lang AS h2__lang, h2.slug AS h2__slug, h2.h1_title AS h2__h1_title, h2.meta_title AS h2__meta_title, h2.meta_description AS h2__meta_description, h2.seo_description AS h2__seo_description, h2.meta_keywords AS h2__meta_keywords, d.id AS d__id, d.parent_id AS d__parent_id, d.code AS d__code, d.lat_max AS d__lat_max, d.lng_max AS d__lng_max, d.lat_min AS d__lat_min, d.lng_min AS d__lng_min, d.is_active AS d__is_active, d.is_published AS d__is_published, d.id_ws AS d__id_ws, d.main_photo_filename AS d__main_photo_filename, d.has_free_transfer AS d__has_free_transfer, d.cache_big_photo_url AS d__cache_big_photo_url, d.cache_hotels_qty AS d__cache_hotels_qty, d.cache_json_basic_data AS d__cache_json_basic_data, d2.id AS d2__id, d2.name AS d2__name, d2.summary AS d2__summary, d2.description AS d2__description, d2.trip_seo_description AS d2__trip_seo_description, d2.lang AS d2__lang, d2.h1_title AS d2__h1_title, d2.meta_title AS d2__meta_title, d2.meta_description AS d2__meta_description, d2.seo_description AS d2__seo_description, d2.meta_keywords AS d2__meta_keywords, d2.slug AS d2__slug, h3.id AS h3__id, h3.code AS h3__code, h3.id_ws AS h3__id_ws, h4.id AS h4__id, h4.name AS h4__name, h4.lang AS h4__lang, h5.id AS h5__id, h5.code AS h5__code, h5.dingus_user AS h5__dingus_user, h5.dingus_password AS h5__dingus_password, h5.slug AS h5__slug, h5.slug AS h5__0 FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id LEFT JOIN destination d ON h.destination_id = d.id LEFT JOIN destination_translation d2 ON d.id = d2.id LEFT JOIN hotel_plan h3 ON h.hotel_plan_id = h3.id LEFT JOIN hotel_plan_translation h4 ON h3.id = h4.id LEFT JOIN hotel_chain h5 ON h.hotel_chain_id = h5.id WHERE ((h.hotel_chain_id = h5.id AND h.is_published = 1 AND h2.lang = ? AND d2.lang = ? AND h4.lang = ?) AND h.id = ?) - (it, it, it, 822) |
157 | Doctrine_Connection_Statement | execute : SELECT m.id AS m__id, m.site AS m__site, m.name AS m__name, m.ads AS m__ads, m.ad_groups AS m__ad_groups, m.videos AS m__videos, m.hero AS m__hero, m.faqs AS m__faqs, m.offers AS m__offers, m.route AS m__route, m2.id AS m2__id, m2.h1_title AS m2__h1_title, m2.meta_title AS m2__meta_title, m2.meta_description AS m2__meta_description, m2.meta_keywords AS m2__meta_keywords, m2.seo_description AS m2__seo_description, m2.lang AS m2__lang FROM metadata m LEFT JOIN metadata_translation m2 ON m.id = m2.id WHERE (m.route = ?) - (hotel/view) |
158 | sfFilterChain | Executing filter "sfExecutionFilter" |
159 | hotelActions | Call "hotelActions->executeView()" |
160 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at, h2.id AS h2__id, h2.description AS h2__description, h2.facilities AS h2__facilities, h2.tours AS h2__tours, h2.rooms AS h2__rooms, h2.address AS h2__address, h2.photo_title AS h2__photo_title, h2.lang AS h2__lang, h2.slug AS h2__slug, h2.h1_title AS h2__h1_title, h2.meta_title AS h2__meta_title, h2.meta_description AS h2__meta_description, h2.seo_description AS h2__seo_description, h2.meta_keywords AS h2__meta_keywords FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id WHERE (h2.slug = ? AND h.is_published = ?) - (casa-real-havana, 1) |
161 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at, h2.id AS h2__id, h2.description AS h2__description, h2.facilities AS h2__facilities, h2.tours AS h2__tours, h2.rooms AS h2__rooms, h2.address AS h2__address, h2.photo_title AS h2__photo_title, h2.lang AS h2__lang, h2.slug AS h2__slug, h2.h1_title AS h2__h1_title, h2.meta_title AS h2__meta_title, h2.meta_description AS h2__meta_description, h2.seo_description AS h2__seo_description, h2.meta_keywords AS h2__meta_keywords, d.id AS d__id, d.parent_id AS d__parent_id, d.code AS d__code, d.lat_max AS d__lat_max, d.lng_max AS d__lng_max, d.lat_min AS d__lat_min, d.lng_min AS d__lng_min, d.is_active AS d__is_active, d.is_published AS d__is_published, d.id_ws AS d__id_ws, d.main_photo_filename AS d__main_photo_filename, d.has_free_transfer AS d__has_free_transfer, d.cache_big_photo_url AS d__cache_big_photo_url, d.cache_hotels_qty AS d__cache_hotels_qty, d.cache_json_basic_data AS d__cache_json_basic_data, d2.id AS d2__id, d2.name AS d2__name, d2.summary AS d2__summary, d2.description AS d2__description, d2.trip_seo_description AS d2__trip_seo_description, d2.lang AS d2__lang, d2.h1_title AS d2__h1_title, d2.meta_title AS d2__meta_title, d2.meta_description AS d2__meta_description, d2.seo_description AS d2__seo_description, d2.meta_keywords AS d2__meta_keywords, d2.slug AS d2__slug, h3.id AS h3__id, h3.code AS h3__code, h3.id_ws AS h3__id_ws, h4.id AS h4__id, h4.name AS h4__name, h4.lang AS h4__lang, h5.id AS h5__id, h5.code AS h5__code, h5.dingus_user AS h5__dingus_user, h5.dingus_password AS h5__dingus_password, h5.slug AS h5__slug, h5.slug AS h5__0 FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id LEFT JOIN destination d ON h.destination_id = d.id LEFT JOIN destination_translation d2 ON d.id = d2.id LEFT JOIN hotel_plan h3 ON h.hotel_plan_id = h3.id LEFT JOIN hotel_plan_translation h4 ON h3.id = h4.id LEFT JOIN hotel_chain h5 ON h.hotel_chain_id = h5.id WHERE ((h.hotel_chain_id = h5.id AND h.is_published = 1 AND h2.lang = ? AND d2.lang = ? AND h4.lang = ?) AND h.id = ?) - (it, it, it, 822) |
162 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.room_type_id AS h__room_type_id, h.hotel_id AS h__hotel_id, h.adults AS h__adults, h.children AS h__children, h.minperson AS h__minperson, h.maxperson AS h__maxperson, h.minadults AS h__minadults, h.minchildren AS h__minchildren, h.has_unique_price AS h__has_unique_price, h.availability AS h__availability, h.id_ws AS h__id_ws, h.checkin_time AS h__checkin_time, h.checkout_time AS h__checkout_time, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.cache_has_dingus_prices AS h__cache_has_dingus_prices, h.cache_bk_dates_with_availability AS h__cache_bk_dates_with_availability, h.cache_json_basic_data AS h__cache_json_basic_data, h.cache_direct_payment_days AS h__cache_direct_payment_days, h.cache_price_begin_at AS h__cache_price_begin_at, h.cache_price_end_at AS h__cache_price_end_at, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_offer_discount AS h__cache_offer_discount, h.orden AS h__orden, h.channel_id AS h__channel_id, h.channel_hotel_id AS h__channel_hotel_id, h.channel_room_id AS h__channel_room_id, h.cache_big_photo_url AS h__cache_big_photo_url, h.cache_photo_alt_title AS h__cache_photo_alt_title, h.cache_register_price AS h__cache_register_price, h.cache_register_regular_price AS h__cache_register_regular_price, h.cache_register_offers AS h__cache_register_offers, h.cache_plan_code AS h__cache_plan_code, h.cache_stop_sale_days AS h__cache_stop_sale_days, h.cache_sale_begin_at AS h__cache_sale_begin_at, h.cache_sale_end_at AS h__cache_sale_end_at, h.cache_hotel_room_offer_ids AS h__cache_hotel_room_offer_ids, h.is_published AS h__is_published, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.is_dingus_connected AS h__is_dingus_connected, h.is_accept_three_adults_one_child AS h__is_accept_three_adults_one_child, h.is_infant_included AS h__is_infant_included, h.is_accept_one_adult_one_child AS h__is_accept_one_adult_one_child, h.is_accept_one_adult_two_childs AS h__is_accept_one_adult_two_childs FROM hotel_room h, room_type r WHERE (h.room_type_id = r.id AND h.hotel_id = ? AND h.is_published = 1) ORDER BY h.orden ASC, r.orden ASC - (822) |
163 | Doctrine_Connection_Mysql | query : SELECT DISTINCT h3.id FROM hotel_photo h3 LEFT JOIN hotel_photo_translation h4 ON h3.id = h4.id WHERE (h3.filename <> '' AND h3.hotel_id = 822 AND h3.version = 2) ORDER BY h3.is_promo DESC, h3.filename ASC LIMIT 50 - () |
164 | Doctrine_Connection_Mysql | query : SELECT h.id AS h__id, h.filename AS h__filename, h.hotel_id AS h__hotel_id, h.is_promo AS h__is_promo, h.version AS h__version, h2.id AS h2__id, h2.title AS h2__title, h2.lang AS h2__lang FROM hotel_photo h LEFT JOIN hotel_photo_translation h2 ON h.id = h2.id WHERE h.id IN ('17589', '17557', '17555', '17559', '17561', '17981', '18003', '17983', '17985', '17987', '17989', '17995', '17999', '18001') AND (h.filename <> '' AND h.hotel_id = 822 AND h.version = 2) ORDER BY h.is_promo DESC, h.filename ASC - () |
165 | Doctrine_Connection_Statement | execute : SELECT f.id AS f__id, f2.id AS f2__id, f2.lang AS f2__lang, f2.name AS f2__name, f3.id AS f3__id, f4.id AS f4__id, f4.lang AS f4__lang, f4.name AS f4__name FROM facility f LEFT JOIN facility_translation f2 ON f.id = f2.id LEFT JOIN hotel_facility h ON f.id = h.facility_id LEFT JOIN facility_type f3 ON f.facility_type_id = f3.id LEFT JOIN facility_type_translation f4 ON f3.id = f4.id WHERE (h.hotel_id = ? AND (f.facility_type_id = f3.id AND f3.id = f4.id AND f.id = f2.id AND f3.id = f.facility_type_id AND f2.name <> "" AND f2.lang = ? AND f4.lang = ?)) ORDER BY f.facility_type_id ASC, f2.name ASC - (822, it, it) |
166 | Doctrine_Connection_Statement | execute : SELECT DISTINCT c3.id FROM cms_trip c3 LEFT JOIN cms_trip_translation c4 ON c3.id = c4.id WHERE c3.destination_id = ? AND (ifnull(c3.is_active, 0) = 1 AND ifnull(c3.is_published, 0) = 1) ORDER BY ifnull(c3.is_promo, 0) desc LIMIT 3 - (1) |
167 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.is_active AS c__is_active, c.is_published AS c__is_published, c.is_promo AS c__is_promo, c.price_base AS c__price_base, c.price_adult AS c__price_adult, c.price_child AS c__price_child, c.destination_id AS c__destination_id, c.earn_percent AS c__earn_percent, c.orden AS c__orden, c.monday AS c__monday, c.tuesday AS c__tuesday, c.wednesday AS c__wednesday, c.thursday AS c__thursday, c.friday AS c__friday, c.saturday AS c__saturday, c.sunday AS c__sunday, c.provider_id AS c__provider_id, c.min_persons AS c__min_persons, c.max_persons AS c__max_persons, c.require_passport AS c__require_passport, c.is_private AS c__is_private, c.photo_filename AS c__photo_filename, c.photo_file_updated_at AS c__photo_file_updated_at, c.photo_file_size AS c__photo_file_size, c.main_photo_filename AS c__main_photo_filename, c.cache_big_photo_url AS c__cache_big_photo_url, c.cache_price_by_pax_for_two_pax AS c__cache_price_by_pax_for_two_pax, c.cache_min_price AS c__cache_min_price, c.departure_time AS c__departure_time, c.duration AS c__duration, c.event_time AS c__event_time, c.event_date AS c__event_date, c.is_event AS c__is_event, c.has_transfer AS c__has_transfer, c.cache_has_posibility_direct_payment AS c__cache_has_posibility_direct_payment, c.cache_direct_payment_days AS c__cache_direct_payment_days, c.cache_json_basic_data AS c__cache_json_basic_data, c.bfi_account_number AS c__bfi_account_number, c.bfi_account_holder AS c__bfi_account_holder, c.notification_emails AS c__notification_emails, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.payment_method_id AS c__payment_method_id, c.payment_begin_at AS c__payment_begin_at, c.payment_end_at AS c__payment_end_at, c.latitude AS c__latitude, c.longitude AS c__longitude, c2.id AS c2__id, c2.name AS c2__name, c2.content AS c2__content, c2.photo_title AS c2__photo_title, c2.lang AS c2__lang, c2.slug AS c2__slug, c2.h1_title AS c2__h1_title, c2.meta_title AS c2__meta_title, c2.meta_description AS c2__meta_description, c2.seo_description AS c2__seo_description, c2.meta_keywords AS c2__meta_keywords FROM cms_trip c LEFT JOIN cms_trip_translation c2 ON c.id = c2.id WHERE c.id IN ('8', '476', '54') AND (c.destination_id = ? AND (ifnull(c.is_active, 0) = 1 AND ifnull(c.is_published, 0) = 1)) ORDER BY ifnull(c.is_promo, 0) desc - (1) |
168 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.hotel_id AS h__hotel_id, h.title AS h__title, h.author AS h__author, h.location AS h__location, h.email AS h__email, h.created_at AS h__created_at, h.rating AS h__rating, h.culture AS h__culture, h.summary AS h__summary, h.is_published AS h__is_published FROM hotel_review h WHERE (h.hotel_id = ? AND ifnull(h.is_published, 0) = 1) ORDER BY h.id desc LIMIT 5 - (822) |
169 | sfPHPView | Set component "newsletter_popup" (newsletter/popup) |
170 | sfPHPView | Set component "footer" (main/footer) |
171 | sfPHPView | Render "sf_app_dir/modules/hotel/templates/viewSuccess.php" |
172 | Doctrine_Connection_Mysql | query : SELECT h.id AS h__id, h.hotel_id AS h__hotel_id, h.facility_id AS h__facility_id FROM hotel_facility h WHERE (h.hotel_id = 822 AND h.facility_id = 808) - () |
173 | sfPartialView | Render "sf_app_dir/modules/hotel/templates/_crs_wrapper.php" |
174 | main | Call "hotel->executeCrs()" |
175 | Doctrine_Connection_Mysql | query : select distinct d.id as destination_id, dt.lang, dt.name as destination_name, d.cache_json_basic_data as data, (CASE WHEN d.id = 1 THEN -99 WHEN d.id = 2 THEN -98 WHEN d.id = 3 THEN -97 WHEN d.id = 5 THEN -96 WHEN d.id = 4 THEN -95 WHEN d.id = 8 THEN -94 ELSE 200 END ) AS sort_order from destination d left join destination_translation dt on (d.id = dt.id) left join hotel h on (h.destination_id = d.id) where dt.lang = 'it' and d.is_published = 1 and h.is_active = 1 and h.is_published = 1 order by sort_order; - () |
176 | Doctrine_Connection_Mysql | query : select h.id, h.cache_json_basic_data as data, h.name, dt.name as destination_name from hotel h left join destination d on (h.destination_id = d.id) left join destination_translation dt on (d.id = dt.id) where dt.lang = 'it' and d.is_published = 1 and ifnull(h.is_active, false) != false and ifnull(h.is_published, false) != false order by name ASC; - () |
177 | sfPartialView | Render "sf_app_dir/modules/hotel/templates/_crs.php" |
178 | main | Call "main->executeXe2()" |
179 | Doctrine_Connection_Mysql | query : SELECT c.id AS c__id, c.currency AS c__currency, c.code AS c__code FROM currency c - () |
180 | sfPartialView | Render "sf_app_dir/modules/main/templates/_xe2.php" |
181 | sfPartialView | Render "sf_app_dir/modules/hotel/templates/_search_info.php" |
182 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.hotel_room_id AS h__hotel_room_id, h.provider_id AS h__provider_id, h.offer_id AS h__offer_id, h.pax_price AS h__pax_price, h.suplement_price AS h__suplement_price, h.third_pax_price AS h__third_pax_price, h.child_pax_price AS h__child_pax_price, h.child_pax_price2 AS h__child_pax_price2, h.second_child_pax_price2 AS h__second_child_pax_price2, h.offer_type AS h__offer_type, h.booking_window_begin_at AS h__booking_window_begin_at, h.booking_window_end_at AS h__booking_window_end_at, h.travel_window_begin_at AS h__travel_window_begin_at, h.travel_window_end_at AS h__travel_window_end_at, h.booking_window_discount AS h__booking_window_discount, h.begin_at AS h__begin_at, h.end_at AS h__end_at, h.release_days AS h__release_days, h.availability AS h__availability, h.min_book_days AS h__min_book_days, h.earn_percent AS h__earn_percent, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel_room_offer h LEFT JOIN hotel_room_offer_date h2 ON h.id = h2.hotel_room_offer_id WHERE (h2.hotel_room_offer_id = h.id AND h2.end_at >= ? AND h.hotel_room_id = ?) ORDER BY h2.begin_at ASC - (2024-05-11, 2020) |
183 | Doctrine_Connection_Mysql | query : SELECT c.id AS c__id, c.currency AS c__currency, c.code AS c__code, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang FROM currency c LEFT JOIN currency_translation c2 ON c.id = c2.id - () |
184 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.currency_code AS r__currency_code, r.from_date AS r__from_date, r.to_date AS r__to_date, r.rate_plan_code AS r__rate_plan_code, r.rooms_to_sell AS r__rooms_to_sell, r.release_days AS r__release_days, r.minimum_stay AS r__minimum_stay, r.maximum_stay AS r__maximum_stay, r.is_closed AS r__is_closed, r.hotel_room_id AS r__hotel_room_id, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM room_availability r WHERE (r.from_date <= ? AND r.to_date >= ? AND r.hotel_room_id = ? AND r.rate_plan_code = ?) ORDER BY r.updated_at DESC - (2024-05-10, 2024-05-10, 2020, NR) |
185 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
186 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.hotel_room_id AS r__hotel_room_id, r.season_id AS r__season_id, r.pax_price AS r__pax_price, r.suplement_price AS r__suplement_price, r.third_pax_price AS r__third_pax_price, r.child_pax_price AS r__child_pax_price, r.child_pax_price2 AS r__child_pax_price2, r.second_child_pax_price2 AS r__second_child_pax_price2, r.provider_id AS r__provider_id, r.early_booking_days AS r__early_booking_days, r.early_booking_date_begin_at AS r__early_booking_date_begin_at, r.early_booking_date_end_at AS r__early_booking_date_end_at, r.early_booking_discount AS r__early_booking_discount, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM room_price r LEFT JOIN hotel_room h ON r.hotel_room_id = h.id, hotel_season h2 WHERE (r.hotel_room_id = h.id AND h.children > 0 AND h2.season_id = r.season_id AND (h2.begin_at <= ? AND h2.end_at >= ?) AND h2.hotel_id = h.hotel_id AND r.provider_id = h2.provider_id AND r.child_pax_price2 = 0 AND h.id = ? AND r.pax_price > 0 AND h.has_unique_price = 0 AND r.provider_id = ? AND h.children > 0) ORDER BY r.updated_at DESC - (2024-05-10, 2024-05-10, 2020, 684) |
187 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.code AS r__code, r.orden AS r__orden FROM room_type r WHERE (r.id = ?) - (606) |
188 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.name AS r__name, r.lang AS r__lang FROM room_type_translation r WHERE (r.id IN (?)) - (606) |
189 | Doctrine_Connection_Statement | execute : SELECT f.id AS f__id, f.icon AS f__icon, f2.id AS f2__id, f2.lang AS f2__lang, f2.name AS f2__name FROM facility f LEFT JOIN facility_translation f2 ON f.id = f2.id LEFT JOIN hotel_room_facility h ON f.id = h.facility_id WHERE (f2.name <> "" AND h.hotel_room_id = ? AND f.facility_type_id = 2) ORDER BY f2.name ASC - (2020) |
190 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.hotel_room_id AS h__hotel_room_id, h.provider_id AS h__provider_id, h.offer_id AS h__offer_id, h.pax_price AS h__pax_price, h.suplement_price AS h__suplement_price, h.third_pax_price AS h__third_pax_price, h.child_pax_price AS h__child_pax_price, h.child_pax_price2 AS h__child_pax_price2, h.second_child_pax_price2 AS h__second_child_pax_price2, h.offer_type AS h__offer_type, h.booking_window_begin_at AS h__booking_window_begin_at, h.booking_window_end_at AS h__booking_window_end_at, h.travel_window_begin_at AS h__travel_window_begin_at, h.travel_window_end_at AS h__travel_window_end_at, h.booking_window_discount AS h__booking_window_discount, h.begin_at AS h__begin_at, h.end_at AS h__end_at, h.release_days AS h__release_days, h.availability AS h__availability, h.min_book_days AS h__min_book_days, h.earn_percent AS h__earn_percent, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel_room_offer h LEFT JOIN hotel_room_offer_date h2 ON h.id = h2.hotel_room_offer_id WHERE (h2.hotel_room_offer_id = h.id AND h2.end_at >= ? AND h.hotel_room_id = ?) ORDER BY h2.begin_at ASC - (2024-05-11, 2339) |
191 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.currency_code AS r__currency_code, r.from_date AS r__from_date, r.to_date AS r__to_date, r.rate_plan_code AS r__rate_plan_code, r.rooms_to_sell AS r__rooms_to_sell, r.release_days AS r__release_days, r.minimum_stay AS r__minimum_stay, r.maximum_stay AS r__maximum_stay, r.is_closed AS r__is_closed, r.hotel_room_id AS r__hotel_room_id, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM room_availability r WHERE (r.from_date <= ? AND r.to_date >= ? AND r.hotel_room_id = ? AND r.rate_plan_code = ?) ORDER BY r.updated_at DESC - (2024-05-10, 2024-05-10, 2339, NR) |
192 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
193 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.hotel_room_id AS r__hotel_room_id, r.season_id AS r__season_id, r.pax_price AS r__pax_price, r.suplement_price AS r__suplement_price, r.third_pax_price AS r__third_pax_price, r.child_pax_price AS r__child_pax_price, r.child_pax_price2 AS r__child_pax_price2, r.second_child_pax_price2 AS r__second_child_pax_price2, r.provider_id AS r__provider_id, r.early_booking_days AS r__early_booking_days, r.early_booking_date_begin_at AS r__early_booking_date_begin_at, r.early_booking_date_end_at AS r__early_booking_date_end_at, r.early_booking_discount AS r__early_booking_discount, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM room_price r LEFT JOIN hotel_room h ON r.hotel_room_id = h.id, hotel_season h2 WHERE (r.hotel_room_id = h.id AND h.children > 0 AND h2.season_id = r.season_id AND (h2.begin_at <= ? AND h2.end_at >= ?) AND h2.hotel_id = h.hotel_id AND r.provider_id = h2.provider_id AND r.child_pax_price2 = 0 AND h.id = ? AND r.pax_price > 0 AND h.has_unique_price = 0 AND r.provider_id = ? AND h.children > 0) ORDER BY r.updated_at DESC - (2024-05-10, 2024-05-10, 2339, 684) |
194 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.code AS r__code, r.orden AS r__orden FROM room_type r WHERE (r.id = ?) - (601) |
195 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.name AS r__name, r.lang AS r__lang FROM room_type_translation r WHERE (r.id IN (?)) - (601) |
196 | Doctrine_Connection_Statement | execute : SELECT f.id AS f__id, f.icon AS f__icon, f2.id AS f2__id, f2.lang AS f2__lang, f2.name AS f2__name FROM facility f LEFT JOIN facility_translation f2 ON f.id = f2.id LEFT JOIN hotel_room_facility h ON f.id = h.facility_id WHERE (f2.name <> "" AND h.hotel_room_id = ? AND f.facility_type_id = 2) ORDER BY f2.name ASC - (2339) |
197 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.hotel_room_id AS h__hotel_room_id, h.provider_id AS h__provider_id, h.offer_id AS h__offer_id, h.pax_price AS h__pax_price, h.suplement_price AS h__suplement_price, h.third_pax_price AS h__third_pax_price, h.child_pax_price AS h__child_pax_price, h.child_pax_price2 AS h__child_pax_price2, h.second_child_pax_price2 AS h__second_child_pax_price2, h.offer_type AS h__offer_type, h.booking_window_begin_at AS h__booking_window_begin_at, h.booking_window_end_at AS h__booking_window_end_at, h.travel_window_begin_at AS h__travel_window_begin_at, h.travel_window_end_at AS h__travel_window_end_at, h.booking_window_discount AS h__booking_window_discount, h.begin_at AS h__begin_at, h.end_at AS h__end_at, h.release_days AS h__release_days, h.availability AS h__availability, h.min_book_days AS h__min_book_days, h.earn_percent AS h__earn_percent, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel_room_offer h LEFT JOIN hotel_room_offer_date h2 ON h.id = h2.hotel_room_offer_id WHERE (h2.hotel_room_offer_id = h.id AND h2.end_at >= ? AND h.hotel_room_id = ?) ORDER BY h2.begin_at ASC - (2024-05-11, 2341) |
198 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.currency_code AS r__currency_code, r.from_date AS r__from_date, r.to_date AS r__to_date, r.rate_plan_code AS r__rate_plan_code, r.rooms_to_sell AS r__rooms_to_sell, r.release_days AS r__release_days, r.minimum_stay AS r__minimum_stay, r.maximum_stay AS r__maximum_stay, r.is_closed AS r__is_closed, r.hotel_room_id AS r__hotel_room_id, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM room_availability r WHERE (r.from_date <= ? AND r.to_date >= ? AND r.hotel_room_id = ? AND r.rate_plan_code = ?) ORDER BY r.updated_at DESC - (2024-05-10, 2024-05-10, 2341, NR) |
199 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
200 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.hotel_room_id AS r__hotel_room_id, r.season_id AS r__season_id, r.pax_price AS r__pax_price, r.suplement_price AS r__suplement_price, r.third_pax_price AS r__third_pax_price, r.child_pax_price AS r__child_pax_price, r.child_pax_price2 AS r__child_pax_price2, r.second_child_pax_price2 AS r__second_child_pax_price2, r.provider_id AS r__provider_id, r.early_booking_days AS r__early_booking_days, r.early_booking_date_begin_at AS r__early_booking_date_begin_at, r.early_booking_date_end_at AS r__early_booking_date_end_at, r.early_booking_discount AS r__early_booking_discount, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM room_price r LEFT JOIN hotel_room h ON r.hotel_room_id = h.id, hotel_season h2 WHERE (r.hotel_room_id = h.id AND h.children > 0 AND h2.season_id = r.season_id AND (h2.begin_at <= ? AND h2.end_at >= ?) AND h2.hotel_id = h.hotel_id AND r.provider_id = h2.provider_id AND r.child_pax_price2 = 0 AND h.id = ? AND r.pax_price > 0 AND h.has_unique_price = 0 AND r.provider_id = ? AND h.children > 0) ORDER BY r.updated_at DESC - (2024-05-10, 2024-05-10, 2341, 684) |
201 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.code AS r__code, r.orden AS r__orden FROM room_type r WHERE (r.id = ?) - (603) |
202 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.name AS r__name, r.lang AS r__lang FROM room_type_translation r WHERE (r.id IN (?)) - (603) |
203 | Doctrine_Connection_Statement | execute : SELECT f.id AS f__id, f.icon AS f__icon, f2.id AS f2__id, f2.lang AS f2__lang, f2.name AS f2__name FROM facility f LEFT JOIN facility_translation f2 ON f.id = f2.id LEFT JOIN hotel_room_facility h ON f.id = h.facility_id WHERE (f2.name <> "" AND h.hotel_room_id = ? AND f.facility_type_id = 2) ORDER BY f2.name ASC - (2341) |
204 | sfPartialView | Render "sf_app_dir/modules/hotel/templates/_photo_slider.php" |
205 | sfPartialView | Render "sf_app_dir/modules/hotel/templates/_gallery.php" |
206 | Doctrine_Connection_Mysql | query : SELECT DISTINCT h3.id FROM hotel_photo h3 LEFT JOIN hotel_photo_translation h4 ON h3.id = h4.id WHERE (h3.filename <> '' AND h3.hotel_id = 822 AND h3.version = 2) ORDER BY h3.is_promo DESC, h3.filename ASC LIMIT 50 - () |
207 | Doctrine_Connection_Mysql | query : SELECT h.id AS h__id, h.filename AS h__filename, h.hotel_id AS h__hotel_id, h.is_promo AS h__is_promo, h.version AS h__version, h2.id AS h2__id, h2.title AS h2__title, h2.lang AS h2__lang FROM hotel_photo h LEFT JOIN hotel_photo_translation h2 ON h.id = h2.id WHERE h.id IN ('17589', '17557', '17555', '17559', '17561', '17981', '18003', '17983', '17985', '17987', '17989', '17995', '17999', '18001') AND (h.filename <> '' AND h.hotel_id = 822 AND h.version = 2) ORDER BY h.is_promo DESC, h.filename ASC - () |
208 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
209 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
210 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
211 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
212 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
213 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
214 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
215 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
216 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
217 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
218 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
219 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
220 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) - (822) |
221 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.room_type_id AS h__room_type_id, h.hotel_id AS h__hotel_id, h.adults AS h__adults, h.children AS h__children, h.minperson AS h__minperson, h.maxperson AS h__maxperson, h.minadults AS h__minadults, h.minchildren AS h__minchildren, h.has_unique_price AS h__has_unique_price, h.availability AS h__availability, h.id_ws AS h__id_ws, h.checkin_time AS h__checkin_time, h.checkout_time AS h__checkout_time, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.cache_has_dingus_prices AS h__cache_has_dingus_prices, h.cache_bk_dates_with_availability AS h__cache_bk_dates_with_availability, h.cache_json_basic_data AS h__cache_json_basic_data, h.cache_direct_payment_days AS h__cache_direct_payment_days, h.cache_price_begin_at AS h__cache_price_begin_at, h.cache_price_end_at AS h__cache_price_end_at, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_offer_discount AS h__cache_offer_discount, h.orden AS h__orden, h.channel_id AS h__channel_id, h.channel_hotel_id AS h__channel_hotel_id, h.channel_room_id AS h__channel_room_id, h.cache_big_photo_url AS h__cache_big_photo_url, h.cache_photo_alt_title AS h__cache_photo_alt_title, h.cache_register_price AS h__cache_register_price, h.cache_register_regular_price AS h__cache_register_regular_price, h.cache_register_offers AS h__cache_register_offers, h.cache_plan_code AS h__cache_plan_code, h.cache_stop_sale_days AS h__cache_stop_sale_days, h.cache_sale_begin_at AS h__cache_sale_begin_at, h.cache_sale_end_at AS h__cache_sale_end_at, h.cache_hotel_room_offer_ids AS h__cache_hotel_room_offer_ids, h.is_published AS h__is_published, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.is_dingus_connected AS h__is_dingus_connected, h.is_accept_three_adults_one_child AS h__is_accept_three_adults_one_child, h.is_infant_included AS h__is_infant_included, h.is_accept_one_adult_one_child AS h__is_accept_one_adult_one_child, h.is_accept_one_adult_two_childs AS h__is_accept_one_adult_two_childs FROM hotel_room h WHERE (h.hotel_id = ?) ORDER BY h.orden ASC - (822) |
222 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.filename AS r__filename, r.hotel_room_id AS r__hotel_room_id, r.is_promo AS r__is_promo, r.version AS r__version FROM room_photo r WHERE (r.hotel_room_id IN (?)) - (2020) |
223 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN (?)) - (2645) |
224 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN (?)) - (2647) |
225 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN (?)) - (2649) |
226 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN (?)) - (2997) |
227 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN (?)) - (2999) |
228 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN (?)) - (3001) |
229 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN (?)) - (3003) |
230 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN (?)) - (3005) |
231 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.filename AS r__filename, r.hotel_room_id AS r__hotel_room_id, r.is_promo AS r__is_promo, r.version AS r__version FROM room_photo r WHERE (r.hotel_room_id IN (?)) - (2339) |
232 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN (?)) - (3039) |
233 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.filename AS r__filename, r.hotel_room_id AS r__hotel_room_id, r.is_promo AS r__is_promo, r.version AS r__version FROM room_photo r WHERE (r.hotel_room_id IN (?)) - (2341) |
234 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN (?)) - (3041) |
235 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.filename AS r__filename, r.hotel_room_id AS r__hotel_room_id, r.is_promo AS r__is_promo, r.version AS r__version FROM room_photo r WHERE (r.hotel_room_id IN (?)) - (2343) |
236 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN (?)) - (3043) |
237 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.code AS r__code, r.orden AS r__orden FROM room_type r WHERE (r.id = ?) - (605) |
238 | Doctrine_Connection_Statement | execute : SELECT r.id AS r__id, r.name AS r__name, r.lang AS r__lang FROM room_type_translation r WHERE (r.id IN (?)) - (605) |
239 | sfPartialView | Render "sf_app_dir/modules/hotel/templates/_modal_crs.php" |
240 | sfPartialView | Render "sf_app_dir/modules/hotel/templates/_modal_crs_accomodation.php" |
241 | sfPHPView | Decorate content with "sf_app_dir/templates/layout.php" |
242 | sfPHPView | Render "sf_app_dir/templates/layout.php" |
243 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h2.id AS h2__id, h2.lang AS h2__lang, h2.slug AS h2__slug FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id WHERE (h.id = ? AND h2.lang = ?) - (822, es) |
244 | Doctrine_Connection_Statement | execute : SELECT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.slug AS d2__slug FROM destination d LEFT JOIN destination_translation d2 ON d.id = d2.id WHERE (d.id = ? AND d2.lang = ?) - (1, es) |
245 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h2.id AS h2__id, h2.lang AS h2__lang, h2.slug AS h2__slug FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id WHERE (h.id = ? AND h2.lang = ?) - (822, en) |
246 | Doctrine_Connection_Statement | execute : SELECT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.slug AS d2__slug FROM destination d LEFT JOIN destination_translation d2 ON d.id = d2.id WHERE (d.id = ? AND d2.lang = ?) - (1, en) |
247 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h2.id AS h2__id, h2.lang AS h2__lang, h2.slug AS h2__slug FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id WHERE (h.id = ? AND h2.lang = ?) - (822, it) |
248 | Doctrine_Connection_Statement | execute : SELECT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.slug AS d2__slug FROM destination d LEFT JOIN destination_translation d2 ON d.id = d2.id WHERE (d.id = ? AND d2.lang = ?) - (1, it) |
249 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h2.id AS h2__id, h2.lang AS h2__lang, h2.slug AS h2__slug FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id WHERE (h.id = ? AND h2.lang = ?) - (822, it) |
250 | Doctrine_Connection_Statement | execute : SELECT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.slug AS d2__slug FROM destination d LEFT JOIN destination_translation d2 ON d.id = d2.id WHERE (d.id = ? AND d2.lang = ?) - (1, it) |
251 | Doctrine_Connection_Statement | execute : SELECT DISTINCT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.name AS d2__name, d2.slug AS d2__slug, (CASE WHEN d2.id = 1 THEN -99 WHEN d2.id = 2 THEN -98 WHEN d2.id = 3 THEN -97 WHEN d2.id = 5 THEN -96 WHEN d2.id = 4 THEN -95 WHEN d2.id = 8 THEN -94 WHEN d2.id = 11 THEN -93 ELSE 200 END) AS d__0 FROM destination d LEFT JOIN destination_translation d2 ON d.id = d2.id, hotel h WHERE (h.destination_id = d.id AND h.is_active = 1 AND d.is_published = 1 AND h.is_published = 1 AND d2.lang = ?) ORDER BY d__0, d2.name ASC - (it) |
252 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c2.id AS c2__id, c2.lang AS c2__lang, c2.name AS c2__name, c2.slug AS c2__slug FROM car_category c LEFT JOIN car_category_translation c2 ON c.id = c2.id, car c3 WHERE ((c3.car_category_id = c.id AND c.is_published = 1 AND c3.is_published = 1) AND c2.lang = ?) ORDER BY c.orden, c2.name ASC - (it) |
253 | Doctrine_Connection_Statement | execute : SELECT DISTINCT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.name AS d2__name, d2.slug AS d2__slug FROM destination d LEFT JOIN destination_translation d2 ON d.id = d2.id, cms_trip c LEFT JOIN cms_trip_translation c2 ON c.id = c2.id WHERE (d.id = c.destination_id AND c.is_published = 1 AND c2.lang = ? AND d2.lang = ?) - (it, it) |
254 | Doctrine_Connection_Mysql | query : select distinct bl.product_id from bl_culture bl where bl.product_model = 'CmsTour' and bl.is_it_banned = true; - () |
255 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.days AS c__days, c.is_combo AS c__is_combo, c2.id AS c2__id, c2.lang AS c2__lang, c2.name AS c2__name, c2.slug AS c2__slug FROM cms_tour c LEFT JOIN cms_tour_translation c2 ON c.id = c2.id WHERE (c.is_published = 1 AND c2.name <> "" AND c.is_combo = 0 AND c2.lang = ?) ORDER BY c.days ASC - (it) |
256 | Doctrine_Connection_Mysql | query : select distinct bl.product_id from bl_culture bl where bl.product_model = 'CmsTour' and bl.is_it_banned = true; - () |
257 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.days AS c__days, c.is_combo AS c__is_combo, c2.id AS c2__id, c2.lang AS c2__lang, c2.name AS c2__name, c2.slug AS c2__slug FROM cms_tour c LEFT JOIN cms_tour_translation c2 ON c.id = c2.id WHERE ((c.is_published = 1 AND c2.name <> "" AND c.is_combo = 1 AND c2.lang = ?) AND ifnull(c.is_domestic_promo, 0) = 0) ORDER BY c.days ASC - (it) |
258 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.menu AS c__menu, c.template AS c__template, c.is_active AS c__is_active, c.is_published AS c__is_published, c.orden AS c__orden, c2.id AS c2__id, c2.name AS c2__name, c2.content AS c2__content, c2.lang AS c2__lang, c2.slug AS c2__slug, c2.h1_title AS c2__h1_title, c2.meta_title AS c2__meta_title, c2.meta_description AS c2__meta_description, c2.seo_description AS c2__seo_description, c2.meta_keywords AS c2__meta_keywords FROM cms c LEFT JOIN cms_translation c2 ON c.id = c2.id WHERE (c.id = ? AND c.is_published = ? AND c2.lang = ?) - (5, 1, it) |
259 | sfPartialView | Render "sf_app_dir/modules/main/templates/_header.php" |
260 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h2.id AS h2__id, h2.lang AS h2__lang, h2.slug AS h2__slug, d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.name AS d2__name, d2.slug AS d2__slug FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id LEFT JOIN destination d ON h.destination_id = d.id LEFT JOIN destination_translation d2 ON d.id = d2.id WHERE ((h.is_published = 1 AND h2.lang = ? AND d2.lang = ?) AND h.id = ?) - (it, it, 822) |
261 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h2.id AS h2__id, h2.lang AS h2__lang, h2.slug AS h2__slug, d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.name AS d2__name, d2.slug AS d2__slug FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id LEFT JOIN destination d ON h.destination_id = d.id LEFT JOIN destination_translation d2 ON d.id = d2.id WHERE ((h.is_published = 1 AND h2.lang = ? AND d2.lang = ?) AND h.id = ?) - (it, it, 892) |
262 | Doctrine_Connection_Statement | execute : SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = ?) LIMIT 1 - (892) |
263 | sfPartialView | Render "sf_app_dir/modules/main/templates/_footer.php" |
264 | Doctrine_Connection_Statement | execute : SELECT c.id AS c__id, c.menu AS c__menu, c.template AS c__template, c.is_active AS c__is_active, c.is_published AS c__is_published, c.orden AS c__orden, c2.id AS c2__id, c2.name AS c2__name, c2.content AS c2__content, c2.lang AS c2__lang, c2.slug AS c2__slug, c2.h1_title AS c2__h1_title, c2.meta_title AS c2__meta_title, c2.meta_description AS c2__meta_description, c2.seo_description AS c2__seo_description, c2.meta_keywords AS c2__meta_keywords FROM cms c LEFT JOIN cms_translation c2 ON c.id = c2.id WHERE (c.is_published = 1 AND c2.name <> "" AND c2.slug <> "" AND c2.lang = ?) AND (c.menu = ? OR c.menu = "left_footer_menu") ORDER BY c.orden, c2.name ASC - (it, footer_menu) |
265 | sfWebResponse | Send status "HTTP/2.0 200 OK" |
266 | sfWebResponse | Send header "Content-Type: text/html; charset=utf-8" |
type | calls | time (ms) | time (%) |
---|---|---|---|
Configuration | 17 | 445.23 | 61 |
Factories | 1 | 460.40 | 63 |
Database (Doctrine) | 93 | 90.94 | 12 |
Action "hotel/view" | 1 | 42.57 | 5 |
View "Success" for "hotel/view" | 1 | 183.99 | 25 |
Partial "hotel/_crs_wrapper" | 1 | 24.63 | 3 |
Component "hotel/crs" | 1 | 20.66 | 2 |
Partial "hotel/_crs" | 1 | 3.36 | 0 |
Component "main/xe2" | 1 | 1.08 | 0 |
Partial "main/_xe2" | 1 | 0.17 | 0 |
Partial "hotel/_search_info" | 1 | 0.16 | 0 |
Partial "hotel/_photo_slider" | 1 | 0.65 | 0 |
Partial "hotel/_gallery" | 1 | 58.33 | 8 |
Partial "hotel/_modal_crs" | 1 | 0.13 | 0 |
Partial "hotel/_modal_crs_accomodation" | 1 | 0.26 | 0 |
Partial "main/_header" | 1 | 18.31 | 2 |
Partial "main/_footer" | 1 | 5.41 | 0 |
SET NAMES 'UTF8'
SELECT currency FROM currency WHERE code = 'EUR' LIMIT 1
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at, h2.id AS h2__id, h2.description AS h2__description, h2.facilities AS h2__facilities, h2.tours AS h2__tours, h2.rooms AS h2__rooms, h2.address AS h2__address, h2.photo_title AS h2__photo_title, h2.lang AS h2__lang, h2.slug AS h2__slug, h2.h1_title AS h2__h1_title, h2.meta_title AS h2__meta_title, h2.meta_description AS h2__meta_description, h2.seo_description AS h2__seo_description, h2.meta_keywords AS h2__meta_keywords FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id WHERE (h2.slug = 'casa-real-havana' AND h.is_published = '1')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at, h2.id AS h2__id, h2.description AS h2__description, h2.facilities AS h2__facilities, h2.tours AS h2__tours, h2.rooms AS h2__rooms, h2.address AS h2__address, h2.photo_title AS h2__photo_title, h2.lang AS h2__lang, h2.slug AS h2__slug, h2.h1_title AS h2__h1_title, h2.meta_title AS h2__meta_title, h2.meta_description AS h2__meta_description, h2.seo_description AS h2__seo_description, h2.meta_keywords AS h2__meta_keywords, d.id AS d__id, d.parent_id AS d__parent_id, d.code AS d__code, d.lat_max AS d__lat_max, d.lng_max AS d__lng_max, d.lat_min AS d__lat_min, d.lng_min AS d__lng_min, d.is_active AS d__is_active, d.is_published AS d__is_published, d.id_ws AS d__id_ws, d.main_photo_filename AS d__main_photo_filename, d.has_free_transfer AS d__has_free_transfer, d.cache_big_photo_url AS d__cache_big_photo_url, d.cache_hotels_qty AS d__cache_hotels_qty, d.cache_json_basic_data AS d__cache_json_basic_data, d2.id AS d2__id, d2.name AS d2__name, d2.summary AS d2__summary, d2.description AS d2__description, d2.trip_seo_description AS d2__trip_seo_description, d2.lang AS d2__lang, d2.h1_title AS d2__h1_title, d2.meta_title AS d2__meta_title, d2.meta_description AS d2__meta_description, d2.seo_description AS d2__seo_description, d2.meta_keywords AS d2__meta_keywords, d2.slug AS d2__slug, h3.id AS h3__id, h3.code AS h3__code, h3.id_ws AS h3__id_ws, h4.id AS h4__id, h4.name AS h4__name, h4.lang AS h4__lang, h5.id AS h5__id, h5.code AS h5__code, h5.dingus_user AS h5__dingus_user, h5.dingus_password AS h5__dingus_password, h5.slug AS h5__slug, h5.slug AS h5__0 FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id LEFT JOIN destination d ON h.destination_id = d.id LEFT JOIN destination_translation d2 ON d.id = d2.id LEFT JOIN hotel_plan h3 ON h.hotel_plan_id = h3.id LEFT JOIN hotel_plan_translation h4 ON h3.id = h4.id LEFT JOIN hotel_chain h5 ON h.hotel_chain_id = h5.id WHERE ((h.hotel_chain_id = h5.id AND h.is_published = 1 AND h2.lang = 'it' AND d2.lang = 'it' AND h4.lang = 'it') AND h.id = '822')
SELECT m.id AS m__id, m.site AS m__site, m.name AS m__name, m.ads AS m__ads, m.ad_groups AS m__ad_groups, m.videos AS m__videos, m.hero AS m__hero, m.faqs AS m__faqs, m.offers AS m__offers, m.route AS m__route, m2.id AS m2__id, m2.h1_title AS m2__h1_title, m2.meta_title AS m2__meta_title, m2.meta_description AS m2__meta_description, m2.meta_keywords AS m2__meta_keywords, m2.seo_description AS m2__seo_description, m2.lang AS m2__lang FROM metadata m LEFT JOIN metadata_translation m2 ON m.id = m2.id WHERE (m.route = 'hotel/view')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at, h2.id AS h2__id, h2.description AS h2__description, h2.facilities AS h2__facilities, h2.tours AS h2__tours, h2.rooms AS h2__rooms, h2.address AS h2__address, h2.photo_title AS h2__photo_title, h2.lang AS h2__lang, h2.slug AS h2__slug, h2.h1_title AS h2__h1_title, h2.meta_title AS h2__meta_title, h2.meta_description AS h2__meta_description, h2.seo_description AS h2__seo_description, h2.meta_keywords AS h2__meta_keywords FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id WHERE (h2.slug = 'casa-real-havana' AND h.is_published = '1')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at, h2.id AS h2__id, h2.description AS h2__description, h2.facilities AS h2__facilities, h2.tours AS h2__tours, h2.rooms AS h2__rooms, h2.address AS h2__address, h2.photo_title AS h2__photo_title, h2.lang AS h2__lang, h2.slug AS h2__slug, h2.h1_title AS h2__h1_title, h2.meta_title AS h2__meta_title, h2.meta_description AS h2__meta_description, h2.seo_description AS h2__seo_description, h2.meta_keywords AS h2__meta_keywords, d.id AS d__id, d.parent_id AS d__parent_id, d.code AS d__code, d.lat_max AS d__lat_max, d.lng_max AS d__lng_max, d.lat_min AS d__lat_min, d.lng_min AS d__lng_min, d.is_active AS d__is_active, d.is_published AS d__is_published, d.id_ws AS d__id_ws, d.main_photo_filename AS d__main_photo_filename, d.has_free_transfer AS d__has_free_transfer, d.cache_big_photo_url AS d__cache_big_photo_url, d.cache_hotels_qty AS d__cache_hotels_qty, d.cache_json_basic_data AS d__cache_json_basic_data, d2.id AS d2__id, d2.name AS d2__name, d2.summary AS d2__summary, d2.description AS d2__description, d2.trip_seo_description AS d2__trip_seo_description, d2.lang AS d2__lang, d2.h1_title AS d2__h1_title, d2.meta_title AS d2__meta_title, d2.meta_description AS d2__meta_description, d2.seo_description AS d2__seo_description, d2.meta_keywords AS d2__meta_keywords, d2.slug AS d2__slug, h3.id AS h3__id, h3.code AS h3__code, h3.id_ws AS h3__id_ws, h4.id AS h4__id, h4.name AS h4__name, h4.lang AS h4__lang, h5.id AS h5__id, h5.code AS h5__code, h5.dingus_user AS h5__dingus_user, h5.dingus_password AS h5__dingus_password, h5.slug AS h5__slug, h5.slug AS h5__0 FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id LEFT JOIN destination d ON h.destination_id = d.id LEFT JOIN destination_translation d2 ON d.id = d2.id LEFT JOIN hotel_plan h3 ON h.hotel_plan_id = h3.id LEFT JOIN hotel_plan_translation h4 ON h3.id = h4.id LEFT JOIN hotel_chain h5 ON h.hotel_chain_id = h5.id WHERE ((h.hotel_chain_id = h5.id AND h.is_published = 1 AND h2.lang = 'it' AND d2.lang = 'it' AND h4.lang = 'it') AND h.id = '822')
SELECT h.id AS h__id, h.room_type_id AS h__room_type_id, h.hotel_id AS h__hotel_id, h.adults AS h__adults, h.children AS h__children, h.minperson AS h__minperson, h.maxperson AS h__maxperson, h.minadults AS h__minadults, h.minchildren AS h__minchildren, h.has_unique_price AS h__has_unique_price, h.availability AS h__availability, h.id_ws AS h__id_ws, h.checkin_time AS h__checkin_time, h.checkout_time AS h__checkout_time, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.cache_has_dingus_prices AS h__cache_has_dingus_prices, h.cache_bk_dates_with_availability AS h__cache_bk_dates_with_availability, h.cache_json_basic_data AS h__cache_json_basic_data, h.cache_direct_payment_days AS h__cache_direct_payment_days, h.cache_price_begin_at AS h__cache_price_begin_at, h.cache_price_end_at AS h__cache_price_end_at, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_offer_discount AS h__cache_offer_discount, h.orden AS h__orden, h.channel_id AS h__channel_id, h.channel_hotel_id AS h__channel_hotel_id, h.channel_room_id AS h__channel_room_id, h.cache_big_photo_url AS h__cache_big_photo_url, h.cache_photo_alt_title AS h__cache_photo_alt_title, h.cache_register_price AS h__cache_register_price, h.cache_register_regular_price AS h__cache_register_regular_price, h.cache_register_offers AS h__cache_register_offers, h.cache_plan_code AS h__cache_plan_code, h.cache_stop_sale_days AS h__cache_stop_sale_days, h.cache_sale_begin_at AS h__cache_sale_begin_at, h.cache_sale_end_at AS h__cache_sale_end_at, h.cache_hotel_room_offer_ids AS h__cache_hotel_room_offer_ids, h.is_published AS h__is_published, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.is_dingus_connected AS h__is_dingus_connected, h.is_accept_three_adults_one_child AS h__is_accept_three_adults_one_child, h.is_infant_included AS h__is_infant_included, h.is_accept_one_adult_one_child AS h__is_accept_one_adult_one_child, h.is_accept_one_adult_two_childs AS h__is_accept_one_adult_two_childs FROM hotel_room h, room_type r WHERE (h.room_type_id = r.id AND h.hotel_id = '822' AND h.is_published = 1) ORDER BY h.orden ASC, r.orden ASC
SELECT DISTINCT h3.id FROM hotel_photo h3 LEFT JOIN hotel_photo_translation h4 ON h3.id = h4.id WHERE (h3.filename <> '' AND h3.hotel_id = 822 AND h3.version = 2) ORDER BY h3.is_promo DESC, h3.filename ASC LIMIT 50
SELECT h.id AS h__id, h.filename AS h__filename, h.hotel_id AS h__hotel_id, h.is_promo AS h__is_promo, h.version AS h__version, h2.id AS h2__id, h2.title AS h2__title, h2.lang AS h2__lang FROM hotel_photo h LEFT JOIN hotel_photo_translation h2 ON h.id = h2.id WHERE h.id IN ('17589', '17557', '17555', '17559', '17561', '17981', '18003', '17983', '17985', '17987', '17989', '17995', '17999', '18001') AND (h.filename <> '' AND h.hotel_id = 822 AND h.version = 2) ORDER BY h.is_promo DESC, h.filename ASC
SELECT f.id AS f__id, f2.id AS f2__id, f2.lang AS f2__lang, f2.name AS f2__name, f3.id AS f3__id, f4.id AS f4__id, f4.lang AS f4__lang, f4.name AS f4__name FROM facility f LEFT JOIN facility_translation f2 ON f.id = f2.id LEFT JOIN hotel_facility h ON f.id = h.facility_id LEFT JOIN facility_type f3 ON f.facility_type_id = f3.id LEFT JOIN facility_type_translation f4 ON f3.id = f4.id WHERE (h.hotel_id = '822' AND (f.facility_type_id = f3.id AND f3.id = f4.id AND f.id = f2.id AND f3.id = f.facility_type_id AND f2.name <> "" AND f2.lang = 'it' AND f4.lang = 'it')) ORDER BY f.facility_type_id ASC, f2.name ASC
SELECT DISTINCT c3.id FROM cms_trip c3 LEFT JOIN cms_trip_translation c4 ON c3.id = c4.id WHERE c3.destination_id = '1' AND (ifnull(c3.is_active, 0) = 1 AND ifnull(c3.is_published, 0) = 1) ORDER BY ifnull(c3.is_promo, 0) desc LIMIT 3
SELECT c.id AS c__id, c.is_active AS c__is_active, c.is_published AS c__is_published, c.is_promo AS c__is_promo, c.price_base AS c__price_base, c.price_adult AS c__price_adult, c.price_child AS c__price_child, c.destination_id AS c__destination_id, c.earn_percent AS c__earn_percent, c.orden AS c__orden, c.monday AS c__monday, c.tuesday AS c__tuesday, c.wednesday AS c__wednesday, c.thursday AS c__thursday, c.friday AS c__friday, c.saturday AS c__saturday, c.sunday AS c__sunday, c.provider_id AS c__provider_id, c.min_persons AS c__min_persons, c.max_persons AS c__max_persons, c.require_passport AS c__require_passport, c.is_private AS c__is_private, c.photo_filename AS c__photo_filename, c.photo_file_updated_at AS c__photo_file_updated_at, c.photo_file_size AS c__photo_file_size, c.main_photo_filename AS c__main_photo_filename, c.cache_big_photo_url AS c__cache_big_photo_url, c.cache_price_by_pax_for_two_pax AS c__cache_price_by_pax_for_two_pax, c.cache_min_price AS c__cache_min_price, c.departure_time AS c__departure_time, c.duration AS c__duration, c.event_time AS c__event_time, c.event_date AS c__event_date, c.is_event AS c__is_event, c.has_transfer AS c__has_transfer, c.cache_has_posibility_direct_payment AS c__cache_has_posibility_direct_payment, c.cache_direct_payment_days AS c__cache_direct_payment_days, c.cache_json_basic_data AS c__cache_json_basic_data, c.bfi_account_number AS c__bfi_account_number, c.bfi_account_holder AS c__bfi_account_holder, c.notification_emails AS c__notification_emails, c.created_at AS c__created_at, c.updated_at AS c__updated_at, c.payment_method_id AS c__payment_method_id, c.payment_begin_at AS c__payment_begin_at, c.payment_end_at AS c__payment_end_at, c.latitude AS c__latitude, c.longitude AS c__longitude, c2.id AS c2__id, c2.name AS c2__name, c2.content AS c2__content, c2.photo_title AS c2__photo_title, c2.lang AS c2__lang, c2.slug AS c2__slug, c2.h1_title AS c2__h1_title, c2.meta_title AS c2__meta_title, c2.meta_description AS c2__meta_description, c2.seo_description AS c2__seo_description, c2.meta_keywords AS c2__meta_keywords FROM cms_trip c LEFT JOIN cms_trip_translation c2 ON c.id = c2.id WHERE c.id IN ('8', '476', '54') AND (c.destination_id = '1' AND (ifnull(c.is_active, 0) = 1 AND ifnull(c.is_published, 0) = 1)) ORDER BY ifnull(c.is_promo, 0) desc
SELECT h.id AS h__id, h.hotel_id AS h__hotel_id, h.title AS h__title, h.author AS h__author, h.location AS h__location, h.email AS h__email, h.created_at AS h__created_at, h.rating AS h__rating, h.culture AS h__culture, h.summary AS h__summary, h.is_published AS h__is_published FROM hotel_review h WHERE (h.hotel_id = '822' AND ifnull(h.is_published, 0) = 1) ORDER BY h.id desc LIMIT 5
SELECT h.id AS h__id, h.hotel_id AS h__hotel_id, h.facility_id AS h__facility_id FROM hotel_facility h WHERE (h.hotel_id = 822 AND h.facility_id = 808)
select distinct d.id as destination_id, dt.lang, dt.name as destination_name, d.cache_json_basic_data as data, (CASE WHEN d.id = 1 THEN -99 WHEN d.id = 2 THEN -98 WHEN d.id = 3 THEN -97 WHEN d.id = 5 THEN -96 WHEN d.id = 4 THEN -95 WHEN d.id = 8 THEN -94 ELSE 200 END ) AS sort_order from destination d left join destination_translation dt on (d.id = dt.id) left join hotel h on (h.destination_id = d.id) where dt.lang = 'it' and d.is_published = 1 and h.is_active = 1 and h.is_published = 1 order by sort_order;
select h.id, h.cache_json_basic_data as data, h.name, dt.name as destination_name from hotel h left join destination d on (h.destination_id = d.id) left join destination_translation dt on (d.id = dt.id) where dt.lang = 'it' and d.is_published = 1 and ifnull(h.is_active, false) != false and ifnull(h.is_published, false) != false order by name ASC;
SELECT c.id AS c__id, c.currency AS c__currency, c.code AS c__code FROM currency c
SELECT h.id AS h__id, h.hotel_room_id AS h__hotel_room_id, h.provider_id AS h__provider_id, h.offer_id AS h__offer_id, h.pax_price AS h__pax_price, h.suplement_price AS h__suplement_price, h.third_pax_price AS h__third_pax_price, h.child_pax_price AS h__child_pax_price, h.child_pax_price2 AS h__child_pax_price2, h.second_child_pax_price2 AS h__second_child_pax_price2, h.offer_type AS h__offer_type, h.booking_window_begin_at AS h__booking_window_begin_at, h.booking_window_end_at AS h__booking_window_end_at, h.travel_window_begin_at AS h__travel_window_begin_at, h.travel_window_end_at AS h__travel_window_end_at, h.booking_window_discount AS h__booking_window_discount, h.begin_at AS h__begin_at, h.end_at AS h__end_at, h.release_days AS h__release_days, h.availability AS h__availability, h.min_book_days AS h__min_book_days, h.earn_percent AS h__earn_percent, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel_room_offer h LEFT JOIN hotel_room_offer_date h2 ON h.id = h2.hotel_room_offer_id WHERE (h2.hotel_room_offer_id = h.id AND h2.end_at >= '2024-05-11' AND h.hotel_room_id = '2020') ORDER BY h2.begin_at ASC
SELECT c.id AS c__id, c.currency AS c__currency, c.code AS c__code, c2.id AS c2__id, c2.name AS c2__name, c2.lang AS c2__lang FROM currency c LEFT JOIN currency_translation c2 ON c.id = c2.id
SELECT r.id AS r__id, r.currency_code AS r__currency_code, r.from_date AS r__from_date, r.to_date AS r__to_date, r.rate_plan_code AS r__rate_plan_code, r.rooms_to_sell AS r__rooms_to_sell, r.release_days AS r__release_days, r.minimum_stay AS r__minimum_stay, r.maximum_stay AS r__maximum_stay, r.is_closed AS r__is_closed, r.hotel_room_id AS r__hotel_room_id, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM room_availability r WHERE (r.from_date <= '2024-05-10' AND r.to_date >= '2024-05-10' AND r.hotel_room_id = '2020' AND r.rate_plan_code = 'NR') ORDER BY r.updated_at DESC
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT r.id AS r__id, r.hotel_room_id AS r__hotel_room_id, r.season_id AS r__season_id, r.pax_price AS r__pax_price, r.suplement_price AS r__suplement_price, r.third_pax_price AS r__third_pax_price, r.child_pax_price AS r__child_pax_price, r.child_pax_price2 AS r__child_pax_price2, r.second_child_pax_price2 AS r__second_child_pax_price2, r.provider_id AS r__provider_id, r.early_booking_days AS r__early_booking_days, r.early_booking_date_begin_at AS r__early_booking_date_begin_at, r.early_booking_date_end_at AS r__early_booking_date_end_at, r.early_booking_discount AS r__early_booking_discount, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM room_price r LEFT JOIN hotel_room h ON r.hotel_room_id = h.id, hotel_season h2 WHERE (r.hotel_room_id = h.id AND h.children > 0 AND h2.season_id = r.season_id AND (h2.begin_at <= '2024-05-10' AND h2.end_at >= '2024-05-10') AND h2.hotel_id = h.hotel_id AND r.provider_id = h2.provider_id AND r.child_pax_price2 = 0 AND h.id = '2020' AND r.pax_price > 0 AND h.has_unique_price = 0 AND r.provider_id = '684' AND h.children > 0) ORDER BY r.updated_at DESC
SELECT r.id AS r__id, r.code AS r__code, r.orden AS r__orden FROM room_type r WHERE (r.id = '606')
SELECT r.id AS r__id, r.name AS r__name, r.lang AS r__lang FROM room_type_translation r WHERE (r.id IN ('606'))
SELECT f.id AS f__id, f.icon AS f__icon, f2.id AS f2__id, f2.lang AS f2__lang, f2.name AS f2__name FROM facility f LEFT JOIN facility_translation f2 ON f.id = f2.id LEFT JOIN hotel_room_facility h ON f.id = h.facility_id WHERE (f2.name <> "" AND h.hotel_room_id = '2020' AND f.facility_type_id = 2) ORDER BY f2.name ASC
SELECT h.id AS h__id, h.hotel_room_id AS h__hotel_room_id, h.provider_id AS h__provider_id, h.offer_id AS h__offer_id, h.pax_price AS h__pax_price, h.suplement_price AS h__suplement_price, h.third_pax_price AS h__third_pax_price, h.child_pax_price AS h__child_pax_price, h.child_pax_price2 AS h__child_pax_price2, h.second_child_pax_price2 AS h__second_child_pax_price2, h.offer_type AS h__offer_type, h.booking_window_begin_at AS h__booking_window_begin_at, h.booking_window_end_at AS h__booking_window_end_at, h.travel_window_begin_at AS h__travel_window_begin_at, h.travel_window_end_at AS h__travel_window_end_at, h.booking_window_discount AS h__booking_window_discount, h.begin_at AS h__begin_at, h.end_at AS h__end_at, h.release_days AS h__release_days, h.availability AS h__availability, h.min_book_days AS h__min_book_days, h.earn_percent AS h__earn_percent, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel_room_offer h LEFT JOIN hotel_room_offer_date h2 ON h.id = h2.hotel_room_offer_id WHERE (h2.hotel_room_offer_id = h.id AND h2.end_at >= '2024-05-11' AND h.hotel_room_id = '2339') ORDER BY h2.begin_at ASC
SELECT r.id AS r__id, r.currency_code AS r__currency_code, r.from_date AS r__from_date, r.to_date AS r__to_date, r.rate_plan_code AS r__rate_plan_code, r.rooms_to_sell AS r__rooms_to_sell, r.release_days AS r__release_days, r.minimum_stay AS r__minimum_stay, r.maximum_stay AS r__maximum_stay, r.is_closed AS r__is_closed, r.hotel_room_id AS r__hotel_room_id, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM room_availability r WHERE (r.from_date <= '2024-05-10' AND r.to_date >= '2024-05-10' AND r.hotel_room_id = '2339' AND r.rate_plan_code = 'NR') ORDER BY r.updated_at DESC
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT r.id AS r__id, r.hotel_room_id AS r__hotel_room_id, r.season_id AS r__season_id, r.pax_price AS r__pax_price, r.suplement_price AS r__suplement_price, r.third_pax_price AS r__third_pax_price, r.child_pax_price AS r__child_pax_price, r.child_pax_price2 AS r__child_pax_price2, r.second_child_pax_price2 AS r__second_child_pax_price2, r.provider_id AS r__provider_id, r.early_booking_days AS r__early_booking_days, r.early_booking_date_begin_at AS r__early_booking_date_begin_at, r.early_booking_date_end_at AS r__early_booking_date_end_at, r.early_booking_discount AS r__early_booking_discount, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM room_price r LEFT JOIN hotel_room h ON r.hotel_room_id = h.id, hotel_season h2 WHERE (r.hotel_room_id = h.id AND h.children > 0 AND h2.season_id = r.season_id AND (h2.begin_at <= '2024-05-10' AND h2.end_at >= '2024-05-10') AND h2.hotel_id = h.hotel_id AND r.provider_id = h2.provider_id AND r.child_pax_price2 = 0 AND h.id = '2339' AND r.pax_price > 0 AND h.has_unique_price = 0 AND r.provider_id = '684' AND h.children > 0) ORDER BY r.updated_at DESC
SELECT r.id AS r__id, r.code AS r__code, r.orden AS r__orden FROM room_type r WHERE (r.id = '601')
SELECT r.id AS r__id, r.name AS r__name, r.lang AS r__lang FROM room_type_translation r WHERE (r.id IN ('601'))
SELECT f.id AS f__id, f.icon AS f__icon, f2.id AS f2__id, f2.lang AS f2__lang, f2.name AS f2__name FROM facility f LEFT JOIN facility_translation f2 ON f.id = f2.id LEFT JOIN hotel_room_facility h ON f.id = h.facility_id WHERE (f2.name <> "" AND h.hotel_room_id = '2339' AND f.facility_type_id = 2) ORDER BY f2.name ASC
SELECT h.id AS h__id, h.hotel_room_id AS h__hotel_room_id, h.provider_id AS h__provider_id, h.offer_id AS h__offer_id, h.pax_price AS h__pax_price, h.suplement_price AS h__suplement_price, h.third_pax_price AS h__third_pax_price, h.child_pax_price AS h__child_pax_price, h.child_pax_price2 AS h__child_pax_price2, h.second_child_pax_price2 AS h__second_child_pax_price2, h.offer_type AS h__offer_type, h.booking_window_begin_at AS h__booking_window_begin_at, h.booking_window_end_at AS h__booking_window_end_at, h.travel_window_begin_at AS h__travel_window_begin_at, h.travel_window_end_at AS h__travel_window_end_at, h.booking_window_discount AS h__booking_window_discount, h.begin_at AS h__begin_at, h.end_at AS h__end_at, h.release_days AS h__release_days, h.availability AS h__availability, h.min_book_days AS h__min_book_days, h.earn_percent AS h__earn_percent, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel_room_offer h LEFT JOIN hotel_room_offer_date h2 ON h.id = h2.hotel_room_offer_id WHERE (h2.hotel_room_offer_id = h.id AND h2.end_at >= '2024-05-11' AND h.hotel_room_id = '2341') ORDER BY h2.begin_at ASC
SELECT r.id AS r__id, r.currency_code AS r__currency_code, r.from_date AS r__from_date, r.to_date AS r__to_date, r.rate_plan_code AS r__rate_plan_code, r.rooms_to_sell AS r__rooms_to_sell, r.release_days AS r__release_days, r.minimum_stay AS r__minimum_stay, r.maximum_stay AS r__maximum_stay, r.is_closed AS r__is_closed, r.hotel_room_id AS r__hotel_room_id, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM room_availability r WHERE (r.from_date <= '2024-05-10' AND r.to_date >= '2024-05-10' AND r.hotel_room_id = '2341' AND r.rate_plan_code = 'NR') ORDER BY r.updated_at DESC
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT r.id AS r__id, r.hotel_room_id AS r__hotel_room_id, r.season_id AS r__season_id, r.pax_price AS r__pax_price, r.suplement_price AS r__suplement_price, r.third_pax_price AS r__third_pax_price, r.child_pax_price AS r__child_pax_price, r.child_pax_price2 AS r__child_pax_price2, r.second_child_pax_price2 AS r__second_child_pax_price2, r.provider_id AS r__provider_id, r.early_booking_days AS r__early_booking_days, r.early_booking_date_begin_at AS r__early_booking_date_begin_at, r.early_booking_date_end_at AS r__early_booking_date_end_at, r.early_booking_discount AS r__early_booking_discount, r.created_at AS r__created_at, r.updated_at AS r__updated_at FROM room_price r LEFT JOIN hotel_room h ON r.hotel_room_id = h.id, hotel_season h2 WHERE (r.hotel_room_id = h.id AND h.children > 0 AND h2.season_id = r.season_id AND (h2.begin_at <= '2024-05-10' AND h2.end_at >= '2024-05-10') AND h2.hotel_id = h.hotel_id AND r.provider_id = h2.provider_id AND r.child_pax_price2 = 0 AND h.id = '2341' AND r.pax_price > 0 AND h.has_unique_price = 0 AND r.provider_id = '684' AND h.children > 0) ORDER BY r.updated_at DESC
SELECT r.id AS r__id, r.code AS r__code, r.orden AS r__orden FROM room_type r WHERE (r.id = '603')
SELECT r.id AS r__id, r.name AS r__name, r.lang AS r__lang FROM room_type_translation r WHERE (r.id IN ('603'))
SELECT f.id AS f__id, f.icon AS f__icon, f2.id AS f2__id, f2.lang AS f2__lang, f2.name AS f2__name FROM facility f LEFT JOIN facility_translation f2 ON f.id = f2.id LEFT JOIN hotel_room_facility h ON f.id = h.facility_id WHERE (f2.name <> "" AND h.hotel_room_id = '2341' AND f.facility_type_id = 2) ORDER BY f2.name ASC
SELECT DISTINCT h3.id FROM hotel_photo h3 LEFT JOIN hotel_photo_translation h4 ON h3.id = h4.id WHERE (h3.filename <> '' AND h3.hotel_id = 822 AND h3.version = 2) ORDER BY h3.is_promo DESC, h3.filename ASC LIMIT 50
SELECT h.id AS h__id, h.filename AS h__filename, h.hotel_id AS h__hotel_id, h.is_promo AS h__is_promo, h.version AS h__version, h2.id AS h2__id, h2.title AS h2__title, h2.lang AS h2__lang FROM hotel_photo h LEFT JOIN hotel_photo_translation h2 ON h.id = h2.id WHERE h.id IN ('17589', '17557', '17555', '17559', '17561', '17981', '18003', '17983', '17985', '17987', '17989', '17995', '17999', '18001') AND (h.filename <> '' AND h.hotel_id = 822 AND h.version = 2) ORDER BY h.is_promo DESC, h.filename ASC
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '822')
SELECT h.id AS h__id, h.room_type_id AS h__room_type_id, h.hotel_id AS h__hotel_id, h.adults AS h__adults, h.children AS h__children, h.minperson AS h__minperson, h.maxperson AS h__maxperson, h.minadults AS h__minadults, h.minchildren AS h__minchildren, h.has_unique_price AS h__has_unique_price, h.availability AS h__availability, h.id_ws AS h__id_ws, h.checkin_time AS h__checkin_time, h.checkout_time AS h__checkout_time, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.cache_has_dingus_prices AS h__cache_has_dingus_prices, h.cache_bk_dates_with_availability AS h__cache_bk_dates_with_availability, h.cache_json_basic_data AS h__cache_json_basic_data, h.cache_direct_payment_days AS h__cache_direct_payment_days, h.cache_price_begin_at AS h__cache_price_begin_at, h.cache_price_end_at AS h__cache_price_end_at, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_offer_discount AS h__cache_offer_discount, h.orden AS h__orden, h.channel_id AS h__channel_id, h.channel_hotel_id AS h__channel_hotel_id, h.channel_room_id AS h__channel_room_id, h.cache_big_photo_url AS h__cache_big_photo_url, h.cache_photo_alt_title AS h__cache_photo_alt_title, h.cache_register_price AS h__cache_register_price, h.cache_register_regular_price AS h__cache_register_regular_price, h.cache_register_offers AS h__cache_register_offers, h.cache_plan_code AS h__cache_plan_code, h.cache_stop_sale_days AS h__cache_stop_sale_days, h.cache_sale_begin_at AS h__cache_sale_begin_at, h.cache_sale_end_at AS h__cache_sale_end_at, h.cache_hotel_room_offer_ids AS h__cache_hotel_room_offer_ids, h.is_published AS h__is_published, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.is_dingus_connected AS h__is_dingus_connected, h.is_accept_three_adults_one_child AS h__is_accept_three_adults_one_child, h.is_infant_included AS h__is_infant_included, h.is_accept_one_adult_one_child AS h__is_accept_one_adult_one_child, h.is_accept_one_adult_two_childs AS h__is_accept_one_adult_two_childs FROM hotel_room h WHERE (h.hotel_id = '822') ORDER BY h.orden ASC
SELECT r.id AS r__id, r.filename AS r__filename, r.hotel_room_id AS r__hotel_room_id, r.is_promo AS r__is_promo, r.version AS r__version FROM room_photo r WHERE (r.hotel_room_id IN ('2020'))
SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN ('2645'))
SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN ('2647'))
SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN ('2649'))
SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN ('2997'))
SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN ('2999'))
SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN ('3001'))
SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN ('3003'))
SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN ('3005'))
SELECT r.id AS r__id, r.filename AS r__filename, r.hotel_room_id AS r__hotel_room_id, r.is_promo AS r__is_promo, r.version AS r__version FROM room_photo r WHERE (r.hotel_room_id IN ('2339'))
SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN ('3039'))
SELECT r.id AS r__id, r.filename AS r__filename, r.hotel_room_id AS r__hotel_room_id, r.is_promo AS r__is_promo, r.version AS r__version FROM room_photo r WHERE (r.hotel_room_id IN ('2341'))
SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN ('3041'))
SELECT r.id AS r__id, r.filename AS r__filename, r.hotel_room_id AS r__hotel_room_id, r.is_promo AS r__is_promo, r.version AS r__version FROM room_photo r WHERE (r.hotel_room_id IN ('2343'))
SELECT r.id AS r__id, r.title AS r__title, r.lang AS r__lang FROM room_photo_translation r WHERE (r.id IN ('3043'))
SELECT r.id AS r__id, r.code AS r__code, r.orden AS r__orden FROM room_type r WHERE (r.id = '605')
SELECT r.id AS r__id, r.name AS r__name, r.lang AS r__lang FROM room_type_translation r WHERE (r.id IN ('605'))
SELECT h.id AS h__id, h2.id AS h2__id, h2.lang AS h2__lang, h2.slug AS h2__slug FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id WHERE (h.id = '822' AND h2.lang = 'es')
SELECT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.slug AS d2__slug FROM destination d LEFT JOIN destination_translation d2 ON d.id = d2.id WHERE (d.id = '1' AND d2.lang = 'es')
SELECT h.id AS h__id, h2.id AS h2__id, h2.lang AS h2__lang, h2.slug AS h2__slug FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id WHERE (h.id = '822' AND h2.lang = 'en')
SELECT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.slug AS d2__slug FROM destination d LEFT JOIN destination_translation d2 ON d.id = d2.id WHERE (d.id = '1' AND d2.lang = 'en')
SELECT h.id AS h__id, h2.id AS h2__id, h2.lang AS h2__lang, h2.slug AS h2__slug FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id WHERE (h.id = '822' AND h2.lang = 'it')
SELECT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.slug AS d2__slug FROM destination d LEFT JOIN destination_translation d2 ON d.id = d2.id WHERE (d.id = '1' AND d2.lang = 'it')
SELECT h.id AS h__id, h2.id AS h2__id, h2.lang AS h2__lang, h2.slug AS h2__slug FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id WHERE (h.id = '822' AND h2.lang = 'it')
SELECT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.slug AS d2__slug FROM destination d LEFT JOIN destination_translation d2 ON d.id = d2.id WHERE (d.id = '1' AND d2.lang = 'it')
SELECT DISTINCT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.name AS d2__name, d2.slug AS d2__slug, (CASE WHEN d2.id = 1 THEN -99 WHEN d2.id = 2 THEN -98 WHEN d2.id = 3 THEN -97 WHEN d2.id = 5 THEN -96 WHEN d2.id = 4 THEN -95 WHEN d2.id = 8 THEN -94 WHEN d2.id = 11 THEN -93 ELSE 200 END) AS d__0 FROM destination d LEFT JOIN destination_translation d2 ON d.id = d2.id, hotel h WHERE (h.destination_id = d.id AND h.is_active = 1 AND d.is_published = 1 AND h.is_published = 1 AND d2.lang = 'it') ORDER BY d__0, d2.name ASC
SELECT c.id AS c__id, c2.id AS c2__id, c2.lang AS c2__lang, c2.name AS c2__name, c2.slug AS c2__slug FROM car_category c LEFT JOIN car_category_translation c2 ON c.id = c2.id, car c3 WHERE ((c3.car_category_id = c.id AND c.is_published = 1 AND c3.is_published = 1) AND c2.lang = 'it') ORDER BY c.orden, c2.name ASC
SELECT DISTINCT d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.name AS d2__name, d2.slug AS d2__slug FROM destination d LEFT JOIN destination_translation d2 ON d.id = d2.id, cms_trip c LEFT JOIN cms_trip_translation c2 ON c.id = c2.id WHERE (d.id = c.destination_id AND c.is_published = 1 AND c2.lang = 'it' AND d2.lang = 'it')
select distinct bl.product_id from bl_culture bl where bl.product_model = 'CmsTour' and bl.is_it_banned = true;
SELECT c.id AS c__id, c.days AS c__days, c.is_combo AS c__is_combo, c2.id AS c2__id, c2.lang AS c2__lang, c2.name AS c2__name, c2.slug AS c2__slug FROM cms_tour c LEFT JOIN cms_tour_translation c2 ON c.id = c2.id WHERE (c.is_published = 1 AND c2.name <> "" AND c.is_combo = 0 AND c2.lang = 'it') ORDER BY c.days ASC
select distinct bl.product_id from bl_culture bl where bl.product_model = 'CmsTour' and bl.is_it_banned = true;
SELECT c.id AS c__id, c.days AS c__days, c.is_combo AS c__is_combo, c2.id AS c2__id, c2.lang AS c2__lang, c2.name AS c2__name, c2.slug AS c2__slug FROM cms_tour c LEFT JOIN cms_tour_translation c2 ON c.id = c2.id WHERE ((c.is_published = 1 AND c2.name <> "" AND c.is_combo = 1 AND c2.lang = 'it') AND ifnull(c.is_domestic_promo, 0) = 0) ORDER BY c.days ASC
SELECT c.id AS c__id, c.menu AS c__menu, c.template AS c__template, c.is_active AS c__is_active, c.is_published AS c__is_published, c.orden AS c__orden, c2.id AS c2__id, c2.name AS c2__name, c2.content AS c2__content, c2.lang AS c2__lang, c2.slug AS c2__slug, c2.h1_title AS c2__h1_title, c2.meta_title AS c2__meta_title, c2.meta_description AS c2__meta_description, c2.seo_description AS c2__seo_description, c2.meta_keywords AS c2__meta_keywords FROM cms c LEFT JOIN cms_translation c2 ON c.id = c2.id WHERE (c.id = '5' AND c.is_published = '1' AND c2.lang = 'it')
SELECT h.id AS h__id, h2.id AS h2__id, h2.lang AS h2__lang, h2.slug AS h2__slug, d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.name AS d2__name, d2.slug AS d2__slug FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id LEFT JOIN destination d ON h.destination_id = d.id LEFT JOIN destination_translation d2 ON d.id = d2.id WHERE ((h.is_published = 1 AND h2.lang = 'it' AND d2.lang = 'it') AND h.id = '822')
SELECT h.id AS h__id, h2.id AS h2__id, h2.lang AS h2__lang, h2.slug AS h2__slug, d.id AS d__id, d2.id AS d2__id, d2.lang AS d2__lang, d2.name AS d2__name, d2.slug AS d2__slug FROM hotel h LEFT JOIN hotel_translation h2 ON h.id = h2.id LEFT JOIN destination d ON h.destination_id = d.id LEFT JOIN destination_translation d2 ON d.id = d2.id WHERE ((h.is_published = 1 AND h2.lang = 'it' AND d2.lang = 'it') AND h.id = '892')
SELECT h.id AS h__id, h.is_covid_offer AS h__is_covid_offer, h.is_opened AS h__is_opened, h.destination_id AS h__destination_id, h.sub_destination_id AS h__sub_destination_id, h.hotel_chain_id AS h__hotel_chain_id, h.provider_id AS h__provider_id, h.airport_id AS h__airport_id, h.taxi_price AS h__taxi_price, h.micro_price AS h__micro_price, h.mini_price AS h__mini_price, h.stars AS h__stars, h.hotel_plan_id AS h__hotel_plan_id, h.name AS h__name, h.name_ws AS h__name_ws, h.code AS h__code, h.ages AS h__ages, h.dinner_price AS h__dinner_price, h.breakfast_price AS h__breakfast_price, h.total_rooms AS h__total_rooms, h.is_promo AS h__is_promo, h.contract_end_at AS h__contract_end_at, h.is_active AS h__is_active, h.is_published AS h__is_published, h.url AS h__url, h.earn_percent AS h__earn_percent, h.is_under_commission AS h__is_under_commission, h.commission_percent AS h__commission_percent, h.phone AS h__phone, h.fax AS h__fax, h.adress AS h__adress, h.id_ws AS h__id_ws, h.code_ws AS h__code_ws, h.is_hotel AS h__is_hotel, h.allow_direct_booking AS h__allow_direct_booking, h.website AS h__website, h.tpd_destination_rank AS h__tpd_destination_rank, h.tpd_destination_hotel_qty AS h__tpd_destination_hotel_qty, h.tpd_review_qty AS h__tpd_review_qty, h.tpd_destination_id AS h__tpd_destination_id, h.tpd_hotel_id AS h__tpd_hotel_id, h.tpd_rating_average AS h__tpd_rating_average, h.tpd_url AS h__tpd_url, h.photo_filename AS h__photo_filename, h.photo_file_updated_at AS h__photo_file_updated_at, h.photo_file_size AS h__photo_file_size, h.cache_pax_price_in_double AS h__cache_pax_price_in_double, h.cache_regular_pax_price_in_double AS h__cache_regular_pax_price_in_double, h.cache_price_for_two_pax AS h__cache_price_for_two_pax, h.cache_regular_price_for_two_pax AS h__cache_regular_price_for_two_pax, h.cache_offer_discount AS h__cache_offer_discount, h.cache_base_earn_percent AS h__cache_base_earn_percent, h.min_booking_rooms AS h__min_booking_rooms, h.max_booking_rooms AS h__max_booking_rooms, h.is_villa AS h__is_villa, h.main_photo_filename AS h__main_photo_filename, h.cache_big_photo_url AS h__cache_big_photo_url, h.zone_id AS h__zone_id, h.cache_has_free_wifi AS h__cache_has_free_wifi, h.cache_has_posibility_first_child_free AS h__cache_has_posibility_first_child_free, h.cache_discount_second_child AS h__cache_discount_second_child, h.cache_has_posibility_direct_payment AS h__cache_has_posibility_direct_payment, h.bank_account_id AS h__bank_account_id, h.cache_has_free_transfer AS h__cache_has_free_transfer, h.cache_hotel_provider_currency AS h__cache_hotel_provider_currency, h.cache_plan_code AS h__cache_plan_code, h.cache_room_type_id AS h__cache_room_type_id, h.cache_json_basic_data AS h__cache_json_basic_data, h.tpd_data AS h__tpd_data, h.bfi_account_number AS h__bfi_account_number, h.bfi_account_holder AS h__bfi_account_holder, h.notification_emails AS h__notification_emails, h.dingus_hotel_info_response_xml AS h__dingus_hotel_info_response_xml, h.is_dingus_connected AS h__is_dingus_connected, h.latitude AS h__latitude, h.longitude AS h__longitude, h.payment_method_id AS h__payment_method_id, h.payment_begin_at AS h__payment_begin_at, h.payment_end_at AS h__payment_end_at, h.created_at AS h__created_at, h.updated_at AS h__updated_at FROM hotel h WHERE (h.id = '892') LIMIT 1
SELECT c.id AS c__id, c.menu AS c__menu, c.template AS c__template, c.is_active AS c__is_active, c.is_published AS c__is_published, c.orden AS c__orden, c2.id AS c2__id, c2.name AS c2__name, c2.content AS c2__content, c2.lang AS c2__lang, c2.slug AS c2__slug, c2.h1_title AS c2__h1_title, c2.meta_title AS c2__meta_title, c2.meta_description AS c2__meta_description, c2.seo_description AS c2__seo_description, c2.meta_keywords AS c2__meta_keywords FROM cms c LEFT JOIN cms_translation c2 ON c.id = c2.id WHERE (c.is_published = 1 AND c2.name <> "" AND c2.slug <> "" AND c2.lang = 'it') AND (c.menu = 'footer_menu' OR c.menu = "left_footer_menu") ORDER BY c.orden, c2.name ASC
Collegati con i nostri social network
B log