Barcelona Turisme
TikTok Pinterest Youtube Instagram facebook Twitter

Turisme de Barcelona

Twitter
Síguenos en:
Inicio
Área restringida
Recordar clave
Alta nuevo usuario

Introduce el correo de contacto donde podemos enviarte tu clave de acceso.

Operadores Turísticos
 
Agencias de viaje
 
 
Alojamiento
 
 
Cruceros
 
 
Boletines
 
 
Información útil y FAQ’S
 
Los profesionales del sector turístico tenéis en esta sección un abanico de servicios a su disposición. Ponemos a tu alcance los mejores productos y servicios para organizar tu programa de viaje a Barcelona. También incluimos en este apartado recursos como cercadores de agencias receptivas, alojamiento y material turístico. No deje de consultar el apartado de Publicaciones, desde donde puedes hacer tu reserva de material.

Agencias de viaje

Agencias de viaje

Consulta la relación de agencias de viaje receptivas de la ciudad, expertas en organizar visitas, y reservar alojamiento, espacios y todo tipo de servicios.

Boletines

Boletines

Desde Turisme de Barcelona también editamos dos publicaciones profesionales que os mantendrán informados sobre las principales novedades en la oferta turística de la ciudad.

Servicios a agencias de viajes

Este apartado incluye informaciones, productos, y servicios que te pueden servir para ampliar el contenido de tu programa de viaje a Barcelona.

Alojamiento

Alojamiento

La oferta de alojamiento de la ciudad es muy extensa y cuenta con 373 hoteles de 1 a 5 estrellas, con cerca de 34.689 habitaciones, además de apartamentos turísticos, pensiones y albergues.

Cruceros

Cruceros

El puerto de Barcelona es el primer puerto de cruceros de Europa y cuarto del mundo. El año 2017 ha recibido 778 cruceros con 2.712.247 pasajeros, la mayoría de los cuales han embarcado y/o desembarcado en Barcelona.

Información útil y FAQ’S

Aquí puedes encontrar links, listados direcciones, y otras informaciones que te ayudarán a crear con más detalle tus programas.

Contactar con el Dep. de Promoción y Comercialización
Tel:
Fax:
Mail:
[+34] 933 689 700
[+34] 933 689 701
promocio@barcelonaturisme.cat
©Turisme de Barcelona
Información legal
Política de privacidad
Sistema interno de información
Perfil del contratante
Perfil del contratante
Quiénes somos
NIVEL DE DEBUG
    TIME TYPE MESSAGE

  Fri Apr 26 11:20:33 2024 [DEBUG] Start Handler
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section RECURSO (11770)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Global Section EBDML (11769)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section Global EBDML (11769)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section RECURSO (11770)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section RECURSO (9044)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Global Section EBDML (9042)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section Global EBDML (9042)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section RECURSO (9044)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section RECURSO (8673)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Global Section EBDML (8672)  

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 122 B / 40 B
Time: 1 ms
SELECT s.idPadre FROM PRO_Secciones s WHERE s.idSeccion='9'

explain this query
 Fri Apr 26 11:20:33 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 26 11:20:33 2024 [DEBUG]
Rows: 10
Size In/Out: 223 B / 2.46 KB
Time: 2 ms
SELECT ps.*,ps.nombreCAST 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 26 11:20:33 2024 [DEBUG]
Rows: 6
Size In/Out: 223 B / 1.5 KB
Time: 1 ms
SELECT ps.*,ps.nombreCAST 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 26 11:20:33 2024 [DEBUG]
Rows: 3
Size In/Out: 223 B / 900 B
Time: 1 ms
SELECT ps.*,ps.nombreCAST 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 26 11:20:33 2024 [DEBUG]
Rows: 5
Size In/Out: 337 B / 192 B
Time: 0 ms
SELECT p.idPRO_Pagina as idPagina,p.Titulo_CAST AS titulo,p.idPagina_ebd, p.Titulo_ALT_CAST 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 26 11:20:33 2024 [WARNING] SELECT p.idPRO_Pagina as idPagina,p.Titulo_CAST AS titulo,p.idPagina_ebd, p.Titulo_ALT_CAST 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 26 11:20:33 2024 [WARNING] Transparència

  Fri Apr 26 11:20:33 2024 [WARNING] Información institucional

  Fri Apr 26 11:20:33 2024 [WARNING] Estructura organizativa

  Fri Apr 26 11:20:33 2024 [WARNING] Información económica

  Fri Apr 26 11:20:33 2024 [WARNING] Perfil del contratante
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section EBDML (10572)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section EBDML (10572)  

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 140 B / 50 B
Time: 1 ms
SELECT s.nombreCAST AS tituloSeccion,s.idPagina FROM PRO_Secciones s WHERE s.idSeccion=23

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 4
Size In/Out: 215 B / 1.09 KB
Time: 1 ms
SELECT ps.*,nombreCAST 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 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 120 B / 174 B
Time: 1 ms
SELECT * FROM previsio WHERE prev_idioma=2 ORDER BY prev_dia ASC LIMIT 1

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 108 B / 130 B
Time: 1 ms
SELECT * FROM previsio_iconos WHERE pic_nombre = 'sol.gif'

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 244 B / 70 B
Time: 0 ms
SELECT p.idPagina,p.idPadre, p.nombreCAST 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 26 11:20:33 2024 [DEBUG] End Section Global EBDML (8672)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section RECURSO (8673)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Page (8924)
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section RECURSO (8927)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Global Section EBDML (8780)  

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 216 B / 484 B
Time: 0 ms
SELECT s.nombreCAST AS tituloSeccion,s.* FROM PRO_Secciones s WHERE s.idSeccion='9'

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 5
Size In/Out: 367 B / 170 B
Time: 0 ms
SELECT p.idPRO_Pagina, p.Titulo_CAST AS tituloPagina, idPagina_ebd, enlaceCAST 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 26 11:20:33 2024 [DEBUG]
Rows: 6
Size In/Out: 244 B / 90 B
Time: 1 ms
SELECT COUNT(*) AS nRegistros FROM PRO_Pagina p WHERE p.noVisible<>'S' AND p.PRO_Secciones_idSeccion='9' GROUP BY _idRegistro

Fri Apr 26 11:20:33 2024 [DEBUG] End Section Global EBDML (8780)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section RECURSO (8927)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section EBDML (8925)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section RECURSO (8928)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Global Section EBDML (8841)  

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 176 B / 66 B
Time: 0 ms
SELECT _idRegistro, descripcionCAST AS intro, nombreCAST AS title, imagenCabSeccion FROM PRO_Secciones WHERE idSeccion='9'

Fri Apr 26 11:20:33 2024 [DEBUG] End Section Global EBDML (8841)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section RECURSO (8928)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section RECURSO (9646)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Global Section EBDML (9640)  

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 3
Size In/Out: 241 B / 60 B
Time: 1 ms
SELECT idPRO_Pagina FROM PRO_Pagina WHERE PRO_Secciones_idSeccion='9' AND noVisible<>'S' AND (columnaSubhome=1 OR columnaSubhome='' OR columnaSubhome IS NULL OR columnaSubhome=0) ORDER BY orden

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 423 B / 632 B
Time: 1 ms
SELECT pa.*, pa.Titulo_CAST AS titulo, pa.entradillaCAST AS txtdescripcion, IF(pa.bannerCAST IS NULL,pa.bannerCAT,pa.bannerCAST) AS bimg, IF(pa.bannerCAST IS NULL,"bannerCAT","bannerCAST") AS campoimg, enlaceCAST as enlace, idPagina_ebd,idTipoPagina,idTipoBloque , noVisibleEnMenu, pa.imagenCabSeccion FROM PRO_Pagina pa WHERE pa.idPRO_Pagina='12'

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 423 B / 612 B
Time: 1 ms
SELECT pa.*, pa.Titulo_CAST AS titulo, pa.entradillaCAST AS txtdescripcion, IF(pa.bannerCAST IS NULL,pa.bannerCAT,pa.bannerCAST) AS bimg, IF(pa.bannerCAST IS NULL,"bannerCAT","bannerCAST") AS campoimg, enlaceCAST as enlace, idPagina_ebd,idTipoPagina,idTipoBloque , noVisibleEnMenu, pa.imagenCabSeccion FROM PRO_Pagina pa WHERE pa.idPRO_Pagina='34'

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 423 B / 588 B
Time: 0 ms
SELECT pa.*, pa.Titulo_CAST AS titulo, pa.entradillaCAST AS txtdescripcion, IF(pa.bannerCAST IS NULL,pa.bannerCAT,pa.bannerCAST) AS bimg, IF(pa.bannerCAST IS NULL,"bannerCAT","bannerCAST") AS campoimg, enlaceCAST as enlace, idPagina_ebd,idTipoPagina,idTipoBloque , noVisibleEnMenu, pa.imagenCabSeccion FROM PRO_Pagina pa WHERE pa.idPRO_Pagina='32'

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 3
Size In/Out: 172 B / 60 B
Time: 0 ms
SELECT idPRO_Pagina FROM PRO_Pagina WHERE PRO_Secciones_idSeccion='9' AND noVisible<>'S' AND columnaSubhome=2 ORDER BY orden

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 423 B / 568 B
Time: 1 ms
SELECT pa.*, pa.Titulo_CAST AS titulo, pa.entradillaCAST AS txtdescripcion, IF(pa.bannerCAST IS NULL,pa.bannerCAT,pa.bannerCAST) AS bimg, IF(pa.bannerCAST IS NULL,"bannerCAT","bannerCAST") AS campoimg, enlaceCAST as enlace, idPagina_ebd,idTipoPagina,idTipoBloque , noVisibleEnMenu, pa.imagenCabSeccion FROM PRO_Pagina pa WHERE pa.idPRO_Pagina='39'

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 423 B / 632 B
Time: 1 ms
SELECT pa.*, pa.Titulo_CAST AS titulo, pa.entradillaCAST AS txtdescripcion, IF(pa.bannerCAST IS NULL,pa.bannerCAT,pa.bannerCAST) AS bimg, IF(pa.bannerCAST IS NULL,"bannerCAT","bannerCAST") AS campoimg, enlaceCAST as enlace, idPagina_ebd,idTipoPagina,idTipoBloque , noVisibleEnMenu, pa.imagenCabSeccion FROM PRO_Pagina pa WHERE pa.idPRO_Pagina='13'

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 423 B / 592 B
Time: 1 ms
SELECT pa.*, pa.Titulo_CAST AS titulo, pa.entradillaCAST AS txtdescripcion, IF(pa.bannerCAST IS NULL,pa.bannerCAT,pa.bannerCAST) AS bimg, IF(pa.bannerCAST IS NULL,"bannerCAT","bannerCAST") AS campoimg, enlaceCAST as enlace, idPagina_ebd,idTipoPagina,idTipoBloque , noVisibleEnMenu, pa.imagenCabSeccion FROM PRO_Pagina pa WHERE pa.idPRO_Pagina='33'

Fri Apr 26 11:20:33 2024 [DEBUG] End Section Global EBDML (9640)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section RECURSO (9646)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section EBDML (10150)  

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 0
Size In/Out: 157 B / 30 B
Time: 1 ms
SELECT contenidoCAST AS contenidoprintable FROM PRO_BloquesDePagina WHERE idBloqueDePagina=74 ORDER BY orden ASC

Fri Apr 26 11:20:33 2024 [DEBUG] End Section EBDML (10150)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section EBDML (8925)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section RECURSO (8926)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Global Section EBDML (8792)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section EBDML (9054)  

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 183 B / 80 B
Time: 0 ms
SELECT contactaTXTCAST AS txtcontacta,contactaTelefono,contactaFax,contactaEmail,contactaTwitter FROM PRO_Secciones WHERE idSeccion='9'

Fri Apr 26 11:20:33 2024 [DEBUG] End Section EBDML (9054)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section EBDML (10165)  

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

Fri Apr 26 11:20:33 2024 [DEBUG] End Section EBDML (10165)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section EBDML (10643)  

  Fri Apr 26 11:20:33 2024 [WARNING] seccio: 9

explain this query
 Fri Apr 26 11:20:33 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'<>'8924' LIMIT 1

  Fri Apr 26 11:20:33 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'<>'8924' LIMIT 1

explain this query
 Fri Apr 26 11:20:33 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 26 11:20:33 2024 [DEBUG] End Section EBDML (10643)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section EBDML (9055)  

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

Fri Apr 26 11:20:33 2024 [DEBUG] End Section EBDML (9055)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section EBDML (9837)  

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 1
Size In/Out: 127 B / 130 B
Time: 0 ms
SELECT * FROM PRO_Banners_X_Pagina_O_Seccion WHERE idSeccion='9' ORDER BY Orden

explain this query
 Fri Apr 26 11:20:33 2024 [DEBUG]
Rows: 0
Size In/Out: 956 B / 135 B
Time: 16 ms
Write time: 0 ms Query time: 15 ms Read time: 1 ms
SELECT TBCN2_BANNER._idRegistro, TBCN2_BANNER.idBanner, TBCN2_BANNER.contenidoCAST AS CONTENT, TBCN2_BANNER.textoAltCAST AS altBanner, TBCN2_BANNER.flash, TBCN2_BANNER.flashCAST AS flashIdioma, TBCN2_BANNER.imagenCAT, TBCN2_BANNER.imagenCAST AS imagenIdioma, TBCN2_BANNER.urlImagenExterna, TBCN2_BANNER.urlImagenExternaCAST AS ImagenExtIdioma, TBCN2_BANNER.uriEnlace, TBCN2_BANNER.urlEnlaceCAST AS urlEnlaceIdioma, TBCN2_BANNER.TipoBanner_idTipoBanner, TBCN2_BANNER.idProd, TBCN2_BANNER.idTipoContenido, TBCN2_BANNER.TipoEnlace_idTipoEnlace, TBCN2_BANNER.idPagina, idFicha, TBCN2_PAGINA.nombreCAST AS nombrePagina, TBCN2_BANNER.imagenDeProducto, TBCN2_BANNER.txtEnlace, TBCN2_BANNER.txtEnlaceCAST as txtEnlaceIdioma FROM TBCN2_BANNER LEFT JOIN TBCN2_PAGINA ON TBCN2_PAGINA.idPagina=TBCN2_BANNER.idPagina WHERE idBanner=55 AND fechaFinVisible>='2024-4-26' AND fechaInicioVisible<='2024-4-26' AND visibleCAST='S'

Fri Apr 26 11:20:33 2024 [DEBUG] End Section EBDML (9837)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section Global EBDML (8792)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section RECURSO (8926)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Page (8924)
Fri Apr 26 11:20:33 2024 [DEBUG] Start Section RECURSO (8676)  
Fri Apr 26 11:20:33 2024 [DEBUG] Start Global Section EBDML (8675)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section Global EBDML (8675)  

Fri Apr 26 11:20:33 2024 [DEBUG] End Section RECURSO (8676)  

  Fri Apr 26 11:20:33 2024 [DEBUG] End Handler

INSPECTION   WATCHES
 
  
 
 
  KEY VALUE