Barcelona Turisme
TikTok Pinterest Youtube Instagram facebook Twitter
Restricted area
Remember password

Enter your contact e-mail where we can send you your username and password

Accomodation Barcelona offers a wide range of top-quality hotels. There are hotels with their own individual style that provide a whole host of services and where you’ll feel right at home.

This section lists all the city’s hotels and hotel chains. The search button will help you find the type of accommodation you’re looking for, quickly and easily.


Hotel chains
Hotel chains
The city is home to a number of Spanish and international hotel chains that offer a great many hotels and guest rooms.
Contact with the Promotion and sales Dept.
Tel:
Fax:
Mail:
[+34] 933 689 700
[+34] 933 689 701
promocio@barcelonaturisme.cat
DEBUG LEVEL
    TIME TYPE MESSAGE

  Fri Apr 19 23:47:32 2024 [DEBUG] Start Handler
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section RECURSO (11770)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Global Section EBDML (11769)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Section Global EBDML (11769)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Section RECURSO (11770)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section RECURSO (9044)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Global Section EBDML (9042)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Section Global EBDML (9042)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Section RECURSO (9044)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section RECURSO (8673)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Global Section EBDML (8672)  

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 4
Size In/Out: 203 B / 1.07 KB
Time: 2 ms
SELECT ps.* FROM PRO_Secciones ps WHERE ps.idPadre=0 AND ps.visible='S' AND ps.idTipoVentana=4 ORDER BY ps.idPadre, ps.orden ASC

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 10
Size In/Out: 222 B / 2.46 KB
Time: 3 ms
SELECT ps.*,ps.nombreENG AS titulo FROM PRO_Secciones ps WHERE ps.idPadre=1 AND ps.visible='S' ORDER BY ps.idPadre, ps.orden ASC

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 6
Size In/Out: 222 B / 1.5 KB
Time: 1 ms
SELECT ps.*,ps.nombreENG AS titulo FROM PRO_Secciones ps WHERE ps.idPadre=2 AND ps.visible='S' ORDER BY ps.idPadre, ps.orden ASC

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 3
Size In/Out: 222 B / 900 B
Time: 1 ms
SELECT ps.*,ps.nombreENG AS titulo FROM PRO_Secciones ps WHERE ps.idPadre=3 AND ps.visible='S' ORDER BY ps.idPadre, ps.orden ASC

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 5
Size In/Out: 335 B / 192 B
Time: 1 ms
SELECT p.idPRO_Pagina as idPagina,p.Titulo_ENG AS titulo,p.idPagina_ebd, p.Titulo_ALT_ENG as tituloAlt,p.PRO_Secciones_idSeccion as idSeccion FROM PRO_Pagina p WHERE p.PRO_Secciones_idSeccion='42' AND p.noVisibleEnMenu='N' ORDER BY p.orden ASC

  Fri Apr 19 23:47:32 2024 [WARNING] SELECT p.idPRO_Pagina as idPagina,p.Titulo_ENG AS titulo,p.idPagina_ebd, p.Titulo_ALT_ENG as tituloAlt,p.PRO_Secciones_idSeccion as idSeccion FROM PRO_Pagina p WHERE p.PRO_Secciones_idSeccion='42' AND p.noVisibleEnMenu='N' ORDER BY p.orden ASC

  Fri Apr 19 23:47:32 2024 [WARNING] Transparència

  Fri Apr 19 23:47:32 2024 [WARNING] Institutional information

  Fri Apr 19 23:47:32 2024 [WARNING] Organisational structure

  Fri Apr 19 23:47:32 2024 [WARNING] Economic information

  Fri Apr 19 23:47:32 2024 [WARNING] Contractor Profile
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section EBDML (10572)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Section EBDML (10572)  

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 1
Size In/Out: 139 B / 50 B
Time: 0 ms
SELECT s.nombreENG AS tituloSeccion,s.idPagina FROM PRO_Secciones s WHERE s.idSeccion=23

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 4
Size In/Out: 214 B / 1.09 KB
Time: 1 ms
SELECT ps.*,nombreENG AS titulo FROM PRO_Secciones ps WHERE ps.idPadre=0 AND ps.visible='S' ORDER BY ps.idPadre, ps.orden ASC

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 1
Size In/Out: 120 B / 174 B
Time: 14 ms
Write time: 1 ms Query time: 1 ms Read time: 12 ms
SELECT * FROM previsio WHERE prev_idioma=3 ORDER BY prev_dia ASC LIMIT 1

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 1
Size In/Out: 108 B / 130 B
Time: 0 ms
SELECT * FROM previsio_iconos WHERE pic_nombre = 'sol.gif'

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 1
Size In/Out: 243 B / 70 B
Time: 0 ms
SELECT p.idPagina,p.idPadre, p.nombreENG as nom, se.paginaeBD as paginaEsqSubhome FROM TBCN2_PAGINA p LEFT JOIN TBCN2_SUBESQUEMAPG se ON se.idSubesquema=p.idSubesquema WHERE p.idPagina=44

Fri Apr 19 23:47:32 2024 [DEBUG] End Section Global EBDML (8672)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Section RECURSO (8673)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Page (9545)
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section RECURSO (10095)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Global Section EBDML (8780)  

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 1
Size In/Out: 196 B / 40 B
Time: 0 ms
SELECT p.PRO_Secciones_idSeccion FROM PRO_Pagina p WHERE p.idPagina_ebd='9545' and p.noVisible<>'S' AND p.noVisibleEnMenu ='N' ORDER BY p.orden ASC

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 1
Size In/Out: 107 B / 40 B
Time: 1 ms
SELECT s.idPadre FROM PRO_Secciones s WHERE s.idSeccion='9'

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 1
Size In/Out: 215 B / 484 B
Time: 1 ms
SELECT s.nombreENG AS tituloSeccion,s.* FROM PRO_Secciones s WHERE s.idSeccion='9'

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 5
Size In/Out: 365 B / 170 B
Time: 1 ms
SELECT p.idPRO_Pagina, p.Titulo_ENG AS tituloPagina, idPagina_ebd, enlaceENG AS urlexterna FROM PRO_Pagina p WHERE p.noVisible<>'S' AND p.PRO_Secciones_idSeccion='9' AND p.noVisibleEnMenu ='N' ORDER BY p.orden ASC

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 6
Size In/Out: 244 B / 90 B
Time: 0 ms
SELECT COUNT(*) AS nRegistros FROM PRO_Pagina p WHERE p.noVisible<>'S' AND p.PRO_Secciones_idSeccion='9' GROUP BY _idRegistro

Fri Apr 19 23:47:32 2024 [DEBUG] End Section Global EBDML (8780)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Section RECURSO (10095)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section EBDML (10091)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section RECURSO (10093)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Global Section EBDML (10011)  

  Fri Apr 19 23:47:32 2024 [WARNING] PAGINA: 39

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 1
Size In/Out: 233 B / 80 B
Time: 1 ms
SELECT p.idPRO_Pagina, p.Titulo_ENG AS tituloPagina, idPagina_ebd, bannerENG AS imagen, p.HTML1_ENG AS intro FROM PRO_Pagina p WHERE p.idPRO_Pagina='39' ORDER BY p.orden ASC

Fri Apr 19 23:47:32 2024 [DEBUG] End Section Global EBDML (10011)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Section RECURSO (10093)  

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 6
Size In/Out: 272 B / 160 B
Time: 1 ms
SELECT cho_codcathotel,cho_descripcion,cho_codtipohotel FROM categoriashotel WHERE cho_codidioma='3' AND cho_codtipohotel=4 ORDER BY cho_codtipohotel,cho_codcathotel ASC

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 1
Size In/Out: 272 B / 80 B
Time: 0 ms
SELECT idBloqueDePagina, tituloENG AS tituloBloque, contenidoENG AS contenido, idTipoBloque, imagen FROM PRO_BloquesDePagina WHERE idPagina='39' AND (idPadre='0' OR idPadre IS NULL) AND visible='S' ORDER BY orden ASC

Fri Apr 19 23:47:32 2024 [DEBUG] End Section EBDML (10091)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section RECURSO (10092)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Global Section EBDML (8792)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section EBDML (9054)  

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 1
Size In/Out: 182 B / 80 B
Time: 1 ms
SELECT contactaTXTENG AS txtcontacta,contactaTelefono,contactaFax,contactaEmail,contactaTwitter FROM PRO_Secciones WHERE idSeccion='9'

Fri Apr 19 23:47:32 2024 [DEBUG] End Section EBDML (9054)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section EBDML (10165)  

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 0
Size In/Out: 144 B / 30 B
Time: 0 ms
SELECT _idRegistro FROM PRO_Secciones WHERE idSeccion='9' AND mostrarBloqueNoticies='S' LIMIT 1

Fri Apr 19 23:47:32 2024 [DEBUG] End Section EBDML (10165)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section EBDML (10643)  

  Fri Apr 19 23:47:32 2024 [WARNING] seccio: 9

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 0
Size In/Out: 344 B / 45 B
Time: 0 ms
SELECT s._idRegistro, s.idPadre, qf.idSeccion as seccion, qfp.idSeccion as seccionP FROM PRO_Secciones s LEFT JOIN PRO_QueFem qf ON qf.idSeccion=s.idSeccion LEFT JOIN PRO_QueFem qfp ON qfp.idSeccion=s.idPadre WHERE s.idSeccion='9' AND s.mostrarBloqueQueFem='S' AND '8671'<>'9545' LIMIT 1

  Fri Apr 19 23:47:32 2024 [WARNING] SELECT s._idRegistro, s.idPadre, qf.idSeccion as seccion, qfp.idSeccion as seccionP FROM PRO_Secciones s LEFT JOIN PRO_QueFem qf ON qf.idSeccion=s.idSeccion LEFT JOIN PRO_QueFem qfp ON qfp.idSeccion=s.idPadre WHERE s.idSeccion='9' AND s.mostrarBloqueQueFem='S' AND '8671'<>'9545' LIMIT 1

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 1
Size In/Out: 115 B / 40 B
Time: 0 ms
SELECT idQueFem FROM PRO_QueFem WHERE visibleHome='S' LIMIT 1

Fri Apr 19 23:47:32 2024 [DEBUG] End Section EBDML (10643)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section EBDML (9055)  

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 0
Size In/Out: 150 B / 30 B
Time: 1 ms
SELECT _idRegistro FROM PRO_Secciones WHERE idSeccion='9' AND mostrarBloqueDestacats='S' LIMIT 1

Fri Apr 19 23:47:32 2024 [DEBUG] End Section EBDML (9055)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section EBDML (9837)  

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 1
Size In/Out: 127 B / 130 B
Time: 0 ms
SELECT * FROM PRO_Banners_X_Pagina_O_Seccion WHERE idPagina='39' ORDER BY Orden

explain this query
Fri Apr 19 23:47:32 2024 [DEBUG]
Rows: 0
Size In/Out: 947 B / 135 B
Time: 1 ms
SELECT TBCN2_BANNER._idRegistro, TBCN2_BANNER.idBanner, TBCN2_BANNER.contenidoENG AS CONTENT, TBCN2_BANNER.textoAltENG AS altBanner, TBCN2_BANNER.flash, TBCN2_BANNER.flashENG AS flashIdioma, TBCN2_BANNER.imagenCAT, TBCN2_BANNER.imagenENG AS imagenIdioma, TBCN2_BANNER.urlImagenExterna, TBCN2_BANNER.urlImagenExternaENG AS ImagenExtIdioma, TBCN2_BANNER.uriEnlace, TBCN2_BANNER.urlEnlaceENG AS urlEnlaceIdioma, TBCN2_BANNER.TipoBanner_idTipoBanner, TBCN2_BANNER.idProd, TBCN2_BANNER.idTipoContenido, TBCN2_BANNER.TipoEnlace_idTipoEnlace, TBCN2_BANNER.idPagina, idFicha, TBCN2_PAGINA.nombreENG AS nombrePagina, TBCN2_BANNER.imagenDeProducto, TBCN2_BANNER.txtEnlace, TBCN2_BANNER.txtEnlaceENG as txtEnlaceIdioma FROM TBCN2_BANNER LEFT JOIN TBCN2_PAGINA ON TBCN2_PAGINA.idPagina=TBCN2_BANNER.idPagina WHERE idBanner=55 AND fechaFinVisible>='2024-4-19' AND fechaInicioVisible<='2024-4-19' AND visibleENG='S'

Fri Apr 19 23:47:32 2024 [DEBUG] End Section EBDML (9837)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Section Global EBDML (8792)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Section RECURSO (10092)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Page (9545)
Fri Apr 19 23:47:32 2024 [DEBUG] Start Section RECURSO (8676)  
Fri Apr 19 23:47:32 2024 [DEBUG] Start Global Section EBDML (8675)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Section Global EBDML (8675)  

Fri Apr 19 23:47:32 2024 [DEBUG] End Section RECURSO (8676)  

  Fri Apr 19 23:47:32 2024 [DEBUG] End Handler

INSPECTION   WATCHES
 
 
 
 
  KEY VALUE